Results 1 to 4 of 4

Thread: Petrol vs Diesel Calculator

  1. #1
    Senior Member
    Join Date
    Nov 2010
    Location
    North West
    Posts
    2,293

    Thumbs up Petrol vs Diesel Calculator

    I have an Excel spreadsheet that calculates whether you should buy a Petrol or Diesel car depending on how many miles you do.

    It works for both private purchases (just replace AP for Purchase Price) and Motability leases.

    If you would like a copy then you can download from here https://www.dropbox.com/sh/yquxtj2rist15kx/O_1KF9T3jU (changed link to my dropbox folder)


    Input:
    1. Current Petrol Price £/L
    2. Current Diesel Price £/L
    3. Petrol Car AP
    4. Petrol Car mpg
    5. Diesel Car AP
    6. Diesel Car mpg
    7. Your Milage over 3 years



    Outputs:
    1. Whether to get Petrol or Diesel Car
    2. Savings over 3 years
    3. Savings over 1 year
    Last edited by Paul; 20-08-12 at 13:35.
    Motability Car History
    05/09-05/12; Nissan Qashqai 1.5 Diesel Tekna; 36,500 miles; avg 41.1mpg
    06/12-07/15; Ford C-Max 2.0 Diesel Titanium Powershift; 35,400 miles; avg 37.8mpg
    07/15-09/17; Skoda Octavia 1.6 Diesel SE-L DSG; 28,200miles; avg 43.9mpg
    09/17-Present; VW Touran 1.4 Petrol SEL DSG; 11,600miles; avg 35.9mpg (28.6 - 43.9mpg)

    Click here to send me an email with any private Motoring questions you may have. Replies usually within 48hrs

  2. #2
    littlebib
    Guest
    diesel is about 9p more expensive than petrol

  3. #3
    Senior Member
    Join Date
    Nov 2010
    Location
    North West
    Posts
    2,293
    I just filled my wife's car up (as that's my job) and her's is a petrol that gulps it down (25mpg).

    Anyway I've just spotted that Petrol is currently at it's lowest price since 13th December 2011 at £1.289/L, Diesel is still quite high at £1.389/L which is a pity as I use 10 times as much fuel as her.
    Motability Car History
    05/09-05/12; Nissan Qashqai 1.5 Diesel Tekna; 36,500 miles; avg 41.1mpg
    06/12-07/15; Ford C-Max 2.0 Diesel Titanium Powershift; 35,400 miles; avg 37.8mpg
    07/15-09/17; Skoda Octavia 1.6 Diesel SE-L DSG; 28,200miles; avg 43.9mpg
    09/17-Present; VW Touran 1.4 Petrol SEL DSG; 11,600miles; avg 35.9mpg (28.6 - 43.9mpg)

    Click here to send me an email with any private Motoring questions you may have. Replies usually within 48hrs

  4. #4
    littlebib
    Guest
    it could be worse, the 3p tax increase was scrapped

Similar Threads

  1. Housing Benefit Calculator! CONFUSION ? ! (example given) Total Applicable amount?
    By Treasol in forum Benefits - help & advice on disability benefits, incapacity benefits, ESA and DLA
    Replies: 2
    Last Post: 15-09-13, 15:27
  2. Why some folk should avoid diesel cars
    By Deleted in forum Motoring - help & advice on cars for disabled people, Blue Badge and Motability
    Replies: 3
    Last Post: 08-08-13, 09:17
  3. Any advice of petrol or diesel?!?
    By shopaholic in forum Motoring - help & advice on cars for disabled people, Blue Badge and Motability
    Replies: 11
    Last Post: 21-05-13, 09:35
  4. Petrol to go up again
    By fwipperie in forum Motoring - help & advice on cars for disabled people, Blue Badge and Motability
    Replies: 8
    Last Post: 27-01-13, 16:08

Tags for this Thread

Posting Permissions

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