MPG Calculator For Excel - Formula's Included - Idiot Proof!

Currently reading:
MPG Calculator For Excel - Formula's Included - Idiot Proof!

Diss_50

A.K.A Pierre Van Punto
Joined
Oct 10, 2006
Messages
314
Points
64
Location
Linwood, Scotland
Right Fiatzo Forumo. For all you folks out there, here is some handy MPG info.

Working out MPG in Microsoft Excel

Open a new spread sheet and enter the folowing infomation.

Column Headings -


a1 MPG b1 Miles driven c1 Gallons d1 Litres e1 Pence per Litre f1 Pounds worth of fule

Formulas/Data -


a2 =sum(B2/C2) b2 type miles driven here i.e. (200) c2 =sum(D2/4.54) d2 =sum(F2/E2) e2 type pence per litre here f2 type pounds worth of petrol here

In F2 the cost needs to be entered without the decimal place eg: £25.81 is 2581.

Now we all should be able to work out our MPG! (y)

P.S. Could a mod make this a sticky? ;)
 
Kewl. My 1.4 Bravo sx is doing 40.55 mpg:slayer:
 
Well, With a calculator you can. But a calculator cant table information and store it over a period of time and constantly update automatically. I have my MPG tabled over the last few weeks and I intend to keep it going over time.

Which sadly, my calculator can't do. But feel free to use a calculator if you've got a good memory. :rolleyes:
 
I dont know really :D Its interesting to look at past/present MPG rates. Drive carefully one week wrecklessly the next! :slayer: - see what the differences are. (y)

Valeen - im doing the same thing! hehe - I've got folk thinking im producing stats for the service plan! :D
 
assuming you can accuratly measure how many miles you get. using a fuel gauge is not accurate enough to know when a certain amount of fuel has been used. so you could easily notice a sudden drop in mpg and think there's something wrong, but in reality all you've noticed is that a fuel gauge is not an accurate indicator. my gauge can read a quarter, then i switch engien off and back on 2 mins later, and it reads a bit more than a quarter. if i was waiting for it to say a quarter full, do i use the first time it says quarter full, or the second? unless you run it dry every time (i dont suggest you do that) it wont be very accurate at all.

plus weather will affect mpg, and if its been a bad week for traffic that will too, there's many variables, so its an inaccurate indicator of many things, that its pretty useless.
 
Last edited:
yes its called a fuel gauge, we all have one, the accuracy of a fuel gauge is very questionable. same for trip computers that give mpg.
 
assuming you can accuratly measure how many miles you get. using a fuel gauge is not accurate enough to know when a certain amount of fuel has been used. so you could easily notice a sudden drop in mpg and think there's something wrong, but in reality all you've noticed is that a fuel gauge is not an accurate indicator. my gauge can read a quarter, then i switch engien off and back on 2 mins later, and it reads a bit more than a quarter. if i was waiting for it to say a quarter full, do i use the first time it says quarter full, or the second? unless you run it dry every time (i dont suggest you do that) it wont be very accurate at all.

plus weather will affect mpg, and if its been a bad week for traffic that will too, there's many variables, so its an inaccurate indicator of many things, that its pretty useless.

I got 57 MPG last week by driving very carefully, drove the same this week and am down to an estimated 52 MPG, not checked yet. The reason? I used a new tesco pump 2 weeks ago for my fill up and the vapour return must have been set a lot higher and allowed a greater tank fill. Since I used a different place the following week, it filled up to a lower level and gave a false reading :(
 
ARRGHH!! :p

Okay well we'll use it for a rough MPG calculator!

And if you want to you can add a comment next to your Excel cell saying - stuck in traffic for 4mins today. Turned the engine off and on 3 times today, Raining while driving for 7 mins. Temp. was on average 8 degrees celsius. That way you can keep an accurate-ish account on your MPG.

P.S Jug - Its an aftermarket fuel monitor. Not a fuel gauge.

Where theres a will there a way! :D
 
ARRGHH!! :p

Okay well we'll use it for a rough MPG calculator!

And if you want to you can add a comment next to your Excel cell saying - stuck in traffic for 4mins today. Turned the engine off and on 3 times today, Raining while driving for 7 mins. Temp. was on average 8 degrees celsius. That way you can keep an accurate-ish account on your MPG.

Where theres a will there a way! :D


why not produce a drop box of optional variables in excel, and use formulas to calculate adjusted mpg using approximate adjustments for each varibale, such as take 1 litre off for each 15mins of idle.
 
Go on then hun, you set it up and we'll copy and paste :p
 
do people really need a spreadsheet to calculate mpg? a calculator works just as well :rolleyes:

Errr... Yes! Something to shut the missus up with when she starts moaning about spending on the car :D

Spreadsheet I got running is a little more sophisticated than just MPG, add all expenditure on the car to it and get a figure pence per mile incl. depreciation and the all important what i'm saving with the JTD v's the previous 1.6... answer £9 - £13 per tankfull of fuel. (Should mean I re-coupe the cost to change in 37 months)

Find that the Stilos trip computer is pretty accurate and experience shows, as Hellcat suggests, that its useful to keep an eye on MPG as an indicator of possible problems. As I have posted elsewhere on here, Stilo with tracking out will give about 4-6 MPG less (JTD & 1.6), dying coil pack & cream crackered plugs (1.6) worth about 7-9 MPG... certainly makes a difference if you cover 20 - 25K a year like I does :( (reminds me service due shortly, pads & tyres all round too! :cry: )
 
Back
Top