interpolate dates

ClaudiusLi

I'm looking for a way to estimate fuel consumption based normalize fuel deliveries.

Let's say I have deliveries of the form:

day, gallons
0, 4
4, 2
8, 4
10, 1

Should be converted to
day, usage
0, 0.5
1, 0.5
2, 0.5
3, 0.5
4, 1
5, 1
6, 1
7, 1
8, .5
9, .5

I'm assuming that the delivery people always fill up the tank so any delivery is actually the amount of fuel used since the last delivery. How do I add those lines and calculate those backwards rolling averages with variable window sizes?

RolandJones

Hi @ClaudiusLi,

Could I check with you which tool you are using?

Thanks,

Roland