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!

P.S. Could a mod make this a sticky?

Kewl. My 1.4 Bravo sx is doing 40.55 mpg:slayer:

well if i have done this right then my 2.4 JTD just done 49mpg:slayer:

I'm hitting 31mpg in my MK1 punto 60's Probs because i've got a heavy foot and a problem with the idle control valve.

do people really need a spreadsheet to calculate mpg? a calculator works just as well

jug said:

do people really need a spreadsheet to calculate mpg? a calculator works just as well

Click to expand...

obviously they do

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.

well im bored at work and if i do it in the spredsheet i can at least pretend im doing summit

Diss_50 said:

have my MPG tabled over the last few weeks and I intend to keep it going over time.

Click to expand...

oh in that case it makes sense. but why do you want a history of mpg?

I dont know really Its interesting to look at past/present MPG rates. Drive carefully one week wrecklessly the next! :slayer: - see what the differences are.

Valeen - im doing the same thing! hehe - I've got folk thinking im producing stats for the service plan!

It actually gives a reasonable indication of the health of the car. If it starts dropping then something is wrong. Maybe needs an air filter.. fuel filter.. or an italian tuneup - or maybe you're doing too much italian tuning

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 installed a sensor that tells me approx. how much I have left in the tank and how empty or full it is on a visual display and its real time which is pretty handy.

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.

jug said:

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.

Click to expand...

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

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!

The Negotiator said:

fill up

Click to expand...

you fill your tank! i've never done that once in my life. does it hurt?

Diss_50 said:

ARRGHH!!

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!

Click to expand...

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

jug said:

do people really need a spreadsheet to calculate mpg? a calculator works just as well

Click to expand...

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

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