Fuel Cost Calculator

Jotun

Jotun

Jotun

Soldato
Joined
11 Jun 2005
Posts
3,606
Location
Liverpool
Last night I knocked together a table to show the cost of fuel when varying the MPG returned and made a little calculator to work out how much would be saved/lost by changing cars, and I thought I'd share it here as hopefully it'll be useful to some others :)

Excel 2007
Excel 2003

I've only tested these in Excel 2003 and 2007. It doesn't use any macro's so should run fine regardless of your security settings. No idea if it will work on Open Office, or other version of Office.

The overview sheet gives the cost for a range of annual mileages with differing economy performances. The price per litre of fuel can be changed in the top left of the sheet.

The comparison sheet tells you what difference there will be in fuel costs, and any of the values in the orange box can be changed. At the bottom it will also give an estimate of how long it will take to break even from spending slightly more on a more economical car, although all calculations are done on the assumption that there is no loans or interest to pay. Numbers are rounded to 2 decimal places, and my calculations *should* be correct!

Hopefully it'll save someone a few minutes and be of some use if anyone is considering changing cars for economy reasons, or wants to know how much they could save by driving less, etc.
 
The new Office formats are in essance that, but they work fine for me, if you have 2007 or 2003 with conversion pack installed.
 
[TW]Fox;12279472 said:
Erm it just opens up a zip file full of xml's?
Click to expand...

Odd :confused: I've only got one machine with 2007 installed, so can't try it on others, but I've never had that happen before.
 
I did pretty much the same sort of spreadsheet comparing MPG vs fuel price to give me my cost per week based on my average weekly mileage which it works out from my fillups and how often. Sad I know but I felt like knocking up something fuel-related, lol
 
howardcanning said:
I did pretty much the same sort of spreadsheet comparing MPG vs fuel price to give me my cost per week based on my average weekly mileage which it works out from my fillups and how often. Sad I know but I felt like knocking up something fuel-related, lol
Click to expand...

That would be cool. Any chance you could post a copy of it? :)
 
I made a spreadsheet at work the other day to work out the saving on owning a diesel with the crazy fuel prices at the moment, it was shockingly bad tbh (and I mean the saving)
 
2007 version works fine in Office 2008 here, apart from a warning about some things not being compatible :)
 
Cheers, I am going away till sunday in about 2 hours, and will have no web access :eek:, any chance you could leave it up until Monday morning? I'll post a reply when I have got it.
Thanks very much
 
Good stuff cheers!

Edit* It actually gives a much broader view of other fuel cost calcs out there, the saving from just engine braking and tyre pressure can amount to say 5MPG which is a saving of £272 a year based on current fuel prices if you drove say 15k miles. Pretty big differences from relatively EASY changes in driving habit!
 
Last edited:
Thanks thats really good, as the comparison on P2 lets you compare vehicles with different fuel costs I can easily compare the Insight ive been thinking about to my current super unleaded beast.
 
You must log in or register to reply here.
Back
Top Bottom