Calculating mpg

fishphone · 19th September 2007, 22:20

I have noticed quite a few threads on mpg figures. I use an excel spreadsheet to keep tabs on the mpg for my siggie. It becomes more accurate as more data is enterred. I find the figures calculated are actually quite close to those stated on the fuel computer. I was going to attach the spreadsheet for all to use if they wish, but have just realised that this cannot be done. If anyone wishes to have a copy please e mail me at fishphone75@hotmail.com and I will send directly to you as an attachment, with instructions on its use.

**izonoky** · 19th September 2007, 23:15

you could always do a quick screen grab (print screen) then paste into Paint and save as a jpg then upload

just to give a basic idea of what your figures and layout looks like.

fishphone · 21st September 2007, 13:28

Here is a jpeg of the sheet, not sure if image quality will allow a decent view of it. File attachment size is restricted to 100KB.

**Penfold101** · 21st September 2007, 13:38

Deja Vu....... Alright izonoky, how you doing matey...?

**brianjamesreed** · 6th November 2007, 23:11

Hi

Just to say I do exactly the same with a spread sheet. Have it loaded onto a Dell handheld and only need to enter milage and litres each time I fill up. Must add that this only works if, like me, you fill your tank to the neck each time you fill with juice. No point just sticking in 20 quid at a time.

Spread sheet goes something like this (but I'm no expert)
Column1 row 1 Starting mileage
column 2 row1 fill-up mileage (automatically carried over to column 1 row2--new starting mileage)
Column 3 row 1 litres added
column 4 row 1 total milegae since fill ie column 2 minus column 1
column 5 row 1 mileage divided by litres = miles per litre
column 6 row 1 miles per litre multiplied by 4.55 =mpg for that tank of fuel
column 7 row 1 all mpg's added together then divided by number of tank fills gives average mpg for life of vehicle.

Using the auto formulas in excell you only need to manually enter fill up mileage and number of litres and the rest automatically populates itself across the table.

My 2.0 dti has averaged over 44.1 mpg over the last 8000 miles and typically returns 530 miles to the tank at between 43.5 and 45.5 mpg. Never realy had it on a decent long run!

BJR

**m8internet** · 7th November 2007, 07:06

On my Vectra I use the 1/8ths on the fuel gauge
Each one is between 30 and 50 miles and 7 or 8 litres
On a full tank I can get between 210 and 400 miles