I have a table consisting of ID numbers, dates, and logged units of work carried out (cumulative).
From this I have added columns of:
1. Days Passed: How many days since the last entry for this ID.
2. Work Done: How many work units have been done since the last entry for that ID.
3. Daily Work: How much work has been done per day since the last test.
It looks like this, you should be able to paste it into excel from the "Raw Paste Data" section here.
When its the first record for the ID, I have used the date the ID would have started and cumulative work of 0 to calcutate the new columns.
How do I calculate the work done in the year before the last entry for each ID?
I.e. for vehicle 1, from 21/05/2017 to 21/05/2018, i would need all 356 days at 16.7 units a day, plus 2 days at 45 units, plus 7 days at 20.23.
Thank you for reading, and any help you can provide.
From this I have added columns of:
1. Days Passed: How many days since the last entry for this ID.
2. Work Done: How many work units have been done since the last entry for that ID.
3. Daily Work: How much work has been done per day since the last test.
It looks like this, you should be able to paste it into excel from the "Raw Paste Data" section here.
When its the first record for the ID, I have used the date the ID would have started and cumulative work of 0 to calcutate the new columns.
How do I calculate the work done in the year before the last entry for each ID?
I.e. for vehicle 1, from 21/05/2017 to 21/05/2018, i would need all 356 days at 16.7 units a day, plus 2 days at 45 units, plus 7 days at 20.23.
Thank you for reading, and any help you can provide.
