1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

My petrol cost calculator

Discussion in 'General Chat' started by Rich, Apr 16, 2007.

  1. Rich

    Rich Rollin on boost mother hubbards

    Joined:
    Jan 11, 2007
    Messages:
    373
    Likes Received:
    0
    Woop, just thought I'd share this simple spreadsheet I worked out this morning, so I can show my friends that when I ask for a tenners petrol money for carting them around I'm not kidding :D

    http://webface.genericlan.net/~ricsto/richpersonal/petrolcostcalc.xls

    When you start a journey, reset your mile counter and average MPG computers and when you get back, what it in to the spreadsheet with the price you pay per litre and it will tell you the exact cost it took to make that journey :)

    Any suggestions/improvements welcome
     
  2. Advert Guest Advertisement


  3. smitch

    smitch Active Member

    Joined:
    Sep 15, 2006
    Messages:
    1,588
    Likes Received:
    0
    Mate, you need to get out more. :)
     
  4. Rich

    Rich Rollin on boost mother hubbards

    Joined:
    Jan 11, 2007
    Messages:
    373
    Likes Received:
    0
    I get out too much, and now I'm skint - that's the problem :p
     
  5. smitch

    smitch Active Member

    Joined:
    Sep 15, 2006
    Messages:
    1,588
    Likes Received:
    0
    Ha ha!

    Fair play. :salute:
     
  6. benw123

    benw123 Moderator

    Joined:
    Oct 10, 2004
    Messages:
    1,863
    Likes Received:
    3
    Mate that's really neat. Could you add an optional cost-per-mile field as well? These are the ones you can get from the http://www.whatcar.com website for every car. It includes things like wear and tear, servicing and depreciation.

    Great effort anyway!
     
  7. Rich

    Rich Rollin on boost mother hubbards

    Joined:
    Jan 11, 2007
    Messages:
    373
    Likes Received:
    0
    Yeah sure, updated it to show the cost per mile as well :)
     
  8. marmite

    marmite Counting the Tesco Club points

    Joined:
    Jul 20, 2006
    Messages:
    1,101
    Likes Received:
    0
    too scared to use it:crying:
     
  9. Caesium

    Caesium My BM is fixed!
    VCDS Map User

    Joined:
    May 26, 2004
    Messages:
    4,879
    Likes Received:
    4
    I know how much mine costs and I don't have DIS, I drive 400 miles and then Ihave to put in roughly 40 quid so its 10ppm. Simple.
     
  10. Rich

    Rich Rollin on boost mother hubbards

    Joined:
    Jan 11, 2007
    Messages:
    373
    Likes Received:
    0
    OK now this is even more usefull - I've made a HTML version that you can run on your mobile phone!

    Add the following URL to your phone browser bookmark:
    http://webface.genericlan.net/~ricsto/fuelcost.html

    Then you can easily calculate how much a journey will cost if you're like me and end up taxiing your friends around half the time!

    What it means is you can go on a trip, reset your mpg computer and mileage counter and know exactly how much the drive cost you to make :D - The download to your phone is less than 1kb so you dont have to worry about data charges, you also only download it once and you can make as many calculations as you like as the results are calculated as part of the HTML code by your phone :)

    A lot of phones have the option to save a page offline as well :D


    p.s. the link dosnt work well in FFox, mobile phone browsers work fine and IE will work if you allow the prompt about running scripts :D
     
  11. marmite

    marmite Counting the Tesco Club points

    Joined:
    Jul 20, 2006
    Messages:
    1,101
    Likes Received:
    0
    I Know how much it cost me when I fill it up
    I reset the trip every tank I can do anything for 160 - 303 miles per tank
    so thats 11.1 MPG or 21.04 MPG
     
  12. S3tony

    S3tony Member

    Joined:
    Jun 8, 2004
    Messages:
    396
    Likes Received:
    0

    ouch how big is your tank?
     
  13. marmite

    marmite Counting the Tesco Club points

    Joined:
    Jul 20, 2006
    Messages:
    1,101
    Likes Received:
    0
    72Litre ish
     
  14. Rich

    Rich Rollin on boost mother hubbards

    Joined:
    Jan 11, 2007
    Messages:
    373
    Likes Received:
    0
    Jesus. Big bucks on petrol then :O :O
     
  15. S3tony

    S3tony Member

    Joined:
    Jun 8, 2004
    Messages:
    396
    Likes Received:
    0

    bless her, she likes a drink doesnt she!!!:lmfao:
     
  16. marmite

    marmite Counting the Tesco Club points

    Joined:
    Jul 20, 2006
    Messages:
    1,101
    Likes Received:
    0
    Yeah

    It is hard too keep up with her sometimes!

    Good for the old Nectar points though:)
     
  17. marriedblonde

    marriedblonde Moderator

    Joined:
    Dec 6, 2004
    Messages:
    4,371
    Likes Received:
    7
    Mines the same, 3 tanks a week of approx 50 litre's each time...
     

Share This Page