My Fuel Economy Investigation (Petrol)

[burns863]

Quote: Originally Posted by Humph (original)

Yes it is , shows me exactly how much all my business miles cost me on top of what the company pays per mile.

If you would like a copy PM me, that goes for anyone.



I have to agree that on Vpower mine gives more of a kick in the back when you hit the gas.

I have just used the spreadsheet that was very kindly emailed to me by Humph But the MPG value being calculated seems to god to be true... 55.8 mpg

I have attached a screenshot of my input into the spreadsheet which I wil explain to makle sure I have inputted it right....

1) Started using the spreadsheet 2 fill ups ago. Start mileage before the fill up was 75030
2) Filled up for a second time at 75340 miles (so 310 miles travelled)
3) Starting in cell E4 I started to fill in my second fill up data (as instructed to on the instructions sheet). Second fill up consisted of £25 worth of Tesco Super Uunleaded 97 (25.28 litres).
4) My MPG value comes out a 55.8.

Is this right? I have inputted everything as it says on the instruction sheet but 55.8 seems too high?

Thanks

Dan

[neilw]

For it to work you need to start off with a full tank, record mileage, drive until you need to fill up again, record mileage and fill tank to full again and keep note of number of litres (or gallons) used to fill up. If you only put £25 of petrol in I'm guessing you didn't put a full tank in (if you're driving a mini that is).

[humph]

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.

[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!