Hi Paul
That looks OK except for the figure in I24. Here you are taking an average of the average fuel consumption per fill. This gives a figure of
7.58 km/litre. When you take total distance divide by total fuel purchased, this works out as 7.36 km/litre.
This type of spreadsheet works best when you use a 'brim to brim' measurement. Part fills have to be included in the next full tank figure to give an accurate reading.
The fuel consumption figure per fill is then relative to the other fuel consumptions per fill and is useful to track a deterioration (or improvement) in performance.
You can perhaps relate this to the type of running over a particular fill - motorway, minor roads, wind, rain, temperature, average speeds etc which will perhaps give an indication of what's going on mpg wise.
David
That looks OK except for the figure in I24. Here you are taking an average of the average fuel consumption per fill. This gives a figure of
7.58 km/litre. When you take total distance divide by total fuel purchased, this works out as 7.36 km/litre.
This type of spreadsheet works best when you use a 'brim to brim' measurement. Part fills have to be included in the next full tank figure to give an accurate reading.
The fuel consumption figure per fill is then relative to the other fuel consumptions per fill and is useful to track a deterioration (or improvement) in performance.
You can perhaps relate this to the type of running over a particular fill - motorway, minor roads, wind, rain, temperature, average speeds etc which will perhaps give an indication of what's going on mpg wise.
David