User Tag List

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Calculating mpg

  1. #1
    Regular Member fishphone's Avatar
    Join Date
    May 2007
    Location
    Lincolnshire
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb Calculating mpg

    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.

  2. #2
    Full Member izonoky's Avatar
    Join Date
    Aug 2007
    Location
    London
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

    2.2 Direct SRi

  3. #3
    Regular Member fishphone's Avatar
    Join Date
    May 2007
    Location
    Lincolnshire
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face

    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.

  4. #4
    Full Member Penfold101's Avatar
    Join Date
    Jul 2007
    Location
    Combination of Preston and Oxfordshire...
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    Regular Member brianjamesreed's Avatar
    Join Date
    Apr 2007
    Location
    N Ireland
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default My excell spread sheet

    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

  6. #6
    Regular Member m8internet's Avatar
    Join Date
    Dec 2006
    Location
    Cumbernauld, Scotland
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    Regular Member
    Join Date
    Oct 2007
    Location
    Ripon
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use this website - check everytime I fill up.

    http://www.grantgibson.co.uk/misc/fu...my-calculator/

  8. #8
    Regular Member parapaul's Avatar
    Join Date
    Jul 2006
    Location
    127.0.0.1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just use the calculator on my phone.....

  9. #9
    Full Member izonoky's Avatar
    Join Date
    Aug 2007
    Location
    London
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Quote Originally Posted by Penfold101 View Post
    Deja Vu....... Alright izonoky, how you doing matey...?
    lol, just when I thought it was safe to open me spread sheet...

    2.2 Direct SRi

  10. #10
    Regular Member Stevie-B's Avatar
    Join Date
    Mar 2007
    Location
    NI
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    StatsVehicle Info
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The way prices are going your only making yourselves more depressed....

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •