I'm back at it again because of a few threads/comments I have read on here recently talking about fuel consumption with totally unrealistic values or wild claims. Thought It might be nice to put all this data to some use and if you like, you can have a play with it.
I have put together an Excel spreadsheet for you to put in some data and get it to spit out some results. It's a multi part sheet and coveres four different sections on fuel consumption.
Get your Fuel Consumption Worksheet here.
Whats in the sheet?
Part 1: Current Fuel Consumption.
A calculator to check your current fuel usage. Just enter the current price, how much you filled up and what your trip meter said fr the last tank full. (It cant predict what your "future" consumption will be, just give you an idea of the last tank full got. Should also work for partial fill up, providing you reset the trip meter each time you fill the vehicle)
Part 2: E10 Comparison. (This one is going to trigger some people.)
An E10 comparison tool. This I added for some fun. Just add the current price of E10 into part 2 (after you have filled out part 1) and it will give you an idea of how much more E10 you would need to go the same distance, how much it cost and how much it would cost to go the same distance. It will also tell you if you are/were better off filling up on E10 based on your last fill up.
InB4; All the anti-E10 crowd get all butthurt and make stupid, unfounded claims of 50% less km/tank. I have worked on the energy density of E10 to be about 95% of that of regular fuel. This is an average of best case to worst case. There is no way E10 gets 50% less per tank, so I'm not going to change the E10 energy density…
NB: I have not made a 91 v's 98, because 91 and 98 have the same energy density. So it is pointless to compare. Any variance that comes between using 91 and 98 while you are driving has more to do with the conditions than the fuel. So no, I wont be making a 91RON vs 98RON, because it is pointless. And if you think they are different, you need to do a little bit more reading on what RON is and what it does.
Part 3: Should You travel to buy cheaper fuel?
Ever looked at the fuel app or heard someone talking about the cost of fuel being cheap in another town/suburb and wondered if it would be worth the drive over there? Well, now you can pop the figures into this sheet and it will tell you if it's worth the drive over there to fuel up.
(I'm still working on a way to make the math work a little better on this one, so any ideas, let me know if you can think of a better way to work out the difference)
Part 4: Long Term Fuel Consumption Tracking.
A fuel tracking sheet. It will keep an average of your fill ups and distance travelled and how much fuel you have burned, how much money you have spent and let you know what your cars average fuel consumption is like over a longer time frame.
If you have any ideas on other things you would like to know or compare in relation to fuel, let me know and I'll see what I can add.
Price per hour over an average speed.
Comparing two vehicles at the same time.
Graphs for the long term data
As always, feel free to let me know if something looks weird, doesn't make sense or is throwing errors and I will patch it.
And for anyone looking for an Electric V's Petrol comparison, I still have my other worksheet available.