Fuel Mileage and excel spreadsheet

Check your mail box- Just PM'd you...

 

I can only guess as I can't see any number. If you just take the average of 5.63, 6.25, 5.85 or whatever numbers you have in that column, you're not going to get the accurate number unless miles driven between each fill up are exactly the same. Most likely they are not.

For example, 6.25 mpg average on a 1000-mile run (160 gallons) would have more weight towards overall average than 5.63 mpg average on a 200-mile run (35.524 gallons). But simple average function will not take the mileage discrepancy into account.

Real overall mpg in this case would be 1200 miles / (160 + 35.524) = 6.137 mpg. But the average function on mpg column is doing (5.63 + 6.25) /2 = 5.935 mpg instead.

Does that make sense?

Right click on the cell, and go to "format cells", then "numbers". Change the decimal point from 2 to however many you want.

Can't help on that one.

 

Try Google docs.

 

First thing that popped out was that you are showing a value in F6 and F9 without a corresponding fuel cost value in E6 and E9.

Here's what it looks like if you recalc after removing F6 and F9:



It's a pretty close match.

Also, column C is rounded to the nearest mile, Columns D and F go out to 4 decimal points. If you re-format D and F to 2 digits and have your driver record the odometer to the nearest 10th of mile you can get very close to matching C14 and F13, but it will never be exact.

 

Check out fuel gauges. It is free and very simple

 

Fuelgauges.com