Hi,
I have TABLE A with incoming dates of cargo trains on 2 platforms (Platform 1 and Platform 2). In Table A, a value in Plaform 1 or 2 columns is number of days spent by train on the platform. I need to distribute the number of days a train will spend on the platform across the days the platform was occupied by the train.
For e.g., if a train comes to Platform 2 on 09-06-2018 and it stays there for 1.23 days, the final table should have 1.00 under Platform 2 on 09-06-2018 and 0.23 under Platform 2 on 10-06-2018.
In case Platform 2 has an incoming train on 10-06-2018 with stay time as 1.33 days, it would get the remaining day = 1.00-0.23 = 0.77 on 10-06-2018 and the remaining period of stay = 1.33-0.77 = 0.56 should be shown for 11-06-2018.
I have manually expanded it for the data given in TABLE A and the desired result is shown in TABLE B.
I need to do this for an entire year of data.
Kindly help. Thank you!
Bookmarks