Hello All…
Here I am coming with very complex challenge.
Let me see how you will solve this challenge.
Don’t forget to share your solution
with me. Please send your solutions to suresh.n2008@gmail.com
Look at the dataset below
Category
|
Date
|
Time available
|
Allocation Code
|
Category 1
|
1/1/2017
|
24
|
Calendar Time
|
Category 1
|
1/1/2017
|
22.46564641
|
Planned delay
|
Category 1
|
1/1/2017
|
21.65061065
|
Unplanned delay
|
Category 1
|
1/1/2017
|
16.62751987
|
Break
|
Category 1
|
1/1/2017
|
16.25161727
|
Unknown
|
Category 2
|
1/2/2017
|
24
|
Calendar Time
|
Category 2
|
1/2/2017
|
22.46564641
|
Planned delay
|
Category 2
|
1/2/2017
|
21.65061065
|
Unplanned delay
|
Category 2
|
1/2/2017
|
16.62751987
|
Break
|
Category 2
|
1/2/2017
|
16.25161727
|
Unknown
|
Category 3
|
1/3/2017
|
24
|
Calendar Time
|
Category 3
|
1/3/2017
|
22.46564641
|
Planned delay
|
Category 3
|
1/3/2017
|
21.65061065
|
Unplanned delay
|
Category 3
|
1/3/2017
|
16.62751987
|
Break
|
Category 3
|
1/3/2017
|
16.25161727
|
Unknown
|
Note: Data might be same for Category 1,
Category 2, and Category 3. Filter for Category 1 and build below chart.
DO NOT modify above dataset to solve this challenge. Use same and try to solve
By seeing this chart, itself you can understand what we are
showing. If not please follow below explanation.
- Total Calendar Time is 24 hours. That is first bar in above chart.
- 1.53 hours is difference between calendar Time and Planned delay. If you see that bar is starting from 24 hours (top to bottom) and ending at 22.45 hours. The height of the bar is 1.53 hours.
- 0.82 hours is difference between Planned delay and Unplanned delay. But it will start from end of Planned delay bar.
- Similarly, for Break and Unknown bars. Difference from previous value.
- Now whatever remaining is there, should display as Remaining bar.
Go through chart clearly, you will understand the challenge.