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

Rich Apr 16, 2007

  1. Rich

    Rich Rollin on boost mother hubbards

    373
    0
    16
    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. smitch

    smitch Active Member

    1,588
    0
    36
    Mate, you need to get out more. :)
     
  3. Rich

    Rich Rollin on boost mother hubbards

    373
    0
    16
    I get out too much, and now I'm skint - that's the problem :p
     
  4. smitch

    smitch Active Member

    1,588
    0
    36
    Ha ha!

    Fair play. :salute:
     
  5. benw123

    benw123 Moderator

    1,863
    3
    38
    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!
     
  6. Rich

    Rich Rollin on boost mother hubbards

    373
    0
    16
    Yeah sure, updated it to show the cost per mile as well :)
     
  7. marmite

    marmite Counting the Tesco Club points

    1,101
    0
    36
    too scared to use it:crying:
     
  8. Caesium

    Caesium My BM is fixed! VCDS Map User

    4,879
    4
    36
    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.
     
  9. Rich

    Rich Rollin on boost mother hubbards

    373
    0
    16
    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
     
  10. marmite

    marmite Counting the Tesco Club points

    1,101
    0
    36
    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
     
  11. S3tony

    S3tony Member

    395
    0
    16

    ouch how big is your tank?
     
  12. marmite

    marmite Counting the Tesco Club points

    1,101
    0
    36
    72Litre ish
     
  13. Rich

    Rich Rollin on boost mother hubbards

    373
    0
    16
    Jesus. Big bucks on petrol then :O :O
     
  14. S3tony

    S3tony Member

    395
    0
    16

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

    marmite Counting the Tesco Club points

    1,101
    0
    36
    Yeah

    It is hard too keep up with her sometimes!

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

    marriedblonde Active Member

    4,371
    7
    36
    Mines the same, 3 tanks a week of approx 50 litre's each time...
     

Share This Page