Content Wrapper

[burns863]

Quote: Originally Posted by Humph (original)

Hi Dan,
The figures the spreadsheet is churning out are correct. Distance travelled 310, and 25.28 litres of fuel is (25.28/4.55 = 5.55 gallons approx). So 310/5.55 = 55.8 MPG. I think the problem is with the amount of fuel you put in as stated above, or more likely the start mileage. The car needs to be full when you record the start mileage, I'm guessing yours wasn't. Delete your start mileage (75030) and put your end mileage (75340) in cell B4 instead. When you fill up again and record the end mileage the results should make sense. The sheet only works if you are filling the car up to full (let the pump cut out, but don't "fill to brim"). You can use £5 of fuel and refill to full, no problem. What it won't let you do is use £20 and top up with £5, this will give misleading results.

I wondered if this was the case! The car was full on the start mileage. But when I filled up again I didnt fill up, I just put 25 in, so this will be the problem. i would normally fill up, but due to money issues i didnt. I will start the sheet again once I fill up next week for work

Cheers!