Universal Fuel Consumption Excel Sheet

[priusuk2008]

One thing that I thought might be useful for worldwide readers is a universal consumption sheet, which will convert and log your miles or kilometres against how you buy your gas, by the gallon or by the litre.

I havent gone to graphs in this, but I would appreciate any feedback from USA, European and other readers please.

I have password protected the formulae as there are a couple of tables I use and you will see the report headings change dependent on how you record your mileage. Also, for size consideration, I only have 100 lines in here and you may need more for a full history. I'll be glad to supply the password if you need it to copy more rows, but first I'd appreciate what you think of it....

Thanks

File removed - see updated version 3 on 18/05/08

[JimboK]

Just with a quick glance, it looks nice. Thanks for sharing. I won't be using it because I already have a commercial Palm-based application to track my fillups and mileage, but I'm sure many can make good use of it.

A suggestion, if you think it merits it: Add columns to calculate the per-tank and lifetime differences between MFD mileage and calculated mileage. I did one strictly for that purpose that you're welcome to incorporate into yours if you like.

[The Root]

Priusuk:

This is a very well put together spreadsheet. I will not need to add rows for about 3-4 years based on my miles per year projections, but when that time comes, I would like to do that. By then, I certainly won't remember where this came from, so I would appreciate a PM with the password now. Thanks for all the work you put into this.

[priusuk2008]

Thanks for your kind words Root and also Jimbok for feedback. No-one else yet has commented on including the MFD readings so not too sure if anyone else sees this as important, so I'll wait for a bit if you don't mind.

The password protection is not to protect proprietary rights or anything Root, just to avoid errors by users, deleting rows or putting data in cells where a number is required, that's all. The password is the name of the worksheet if you wish to add your lines now, just copy the whole of the last row down as much as you need.

Thanks again for the positive feedback, sure is appreciated.

[BIGGDOGG]

Great document PriusUK2008. I am at work now but tonight I will punch in all my numbers and check it out more. I have only filled the tank up 12 times since I bought it in November so I am far from needing the Password. But I will keep you informed.

[NOVA-Prius]

Thanks for putting this together and for sharing! I have started using it. I've only filled up twice since I bought the car and have been recording data in a small notebook that lives in the glove compartment. This will give me a way to preserve and tally the information.

The only thing I track that isn't including in your ss is the price of the gas. I thought that it would be interesting to track costs over time. However, I defer to the far more experienced "senior" members of the forum regarding anything that you might want to change/add to your doc.

Again, thanks.

[priusuk2008]

Thanks NOVA-Prius, feedback appreciated. Its a good point you raise and I did originally have the cost in this sheet, together with a calculation of the cost per US Gal/Imp Gal/Litre.

I took it out only because I couldn't think of a way of making the cost and all cost per XX (mile/km/litre/gal etc) universal. For example in USA you would want to show dollars ($), similar to Canada,Australia and New Zealand even though they are different dollars. In Europe people would want to see EURO costs "€" and in UK they would want to see GB Pounds (£). In Japan they want Yen (can't do that symbol??) etc, etc etc.

I think maybe the solution is to just have columns that the "user" can currency format to his or her taste. This does leave the problem that formulae are unprotected to enable this, unless anyone can think up a "lookup" type scenario that I could use, so you select your currency and the heading changes, but not the row formatting (I think I can do this, but it isn't ideal)... any thoughts anyone?

[priusuk2008]

Ok, I have included costs in this version. You select your currency and its abbreviation from a table and it will now, in addition to all the other calcs, tell you cost per litre/gall/US gall of fuel and running cost per mile or kilometre for the fill up, life to date and any season you care to filter on.

This had been bugging me too, and while the solution doesn't show fancy $ or € signs, it is legible and understandable in the country in which it is used.

There is one line of data in the file defaulted to US selections but it will work fine anywhere in the world now.

Give it a go and let me know if it works for you please.

File removed: See Version 3 updated on 18/05/08

Thanks

[The Root]

Even better with the cost factor added. Thanks. I have saved it and will give it a try within the next few days.

[Anniee]

Thank you PriusUK2008. for the spreadsheet.

I am going to use it not only for my Prius, but will also keep a spreadsheet for the other two gas hogs we have. I am hoping that when my husband sees the difference in gas costs he will buy a Prius for himself. It should not have to take a spreadsheet to convince him, surely he is aware of the costs, but sometimes seeing things in black and white will make more of an impact.

Anniee