Fuel Consumption Spreadsheet

Orf · 08-26-2006, 02:14 AM

I have finished a Excel spreadsheet for Europe. The text is English and data is in metric with costs in Euros.
Would anyone like to try it as I have not tested it using actual European figures?
If so, please PM me with your email address and I will send you a copy.
Copies will be free and users are welcome to make changes such as a change of language.
Please notify me of any errors or problems you find or suggestions you would like to see.

I have finished a Excel spreadsheet for Britain. The text is English and fuel input data is in litres with costs in Pounds.
I have one person testing the spreadsheet but would like someone else to try it.
If so, please PM me with your email address and I will send you a copy.
Copies will be free and users are welcome to make changes.

Also, I have finished a Excel spreadsheet for Australia. The text is English and data is in metric with costs in dollars. The spreadsheet could be used by anyone in a country that uses metric and $.
Anyone wishing to have a copy (they are free) please PM me with your email address and I will send you a copy.
Please notify me of any errors or problems you find or suggestions you would like to see incorporated.

OK, you Yanks have not been forgotten, I will start on one for you next week.

Orf · 08-29-2006, 12:47 AM

OK, I have now finished the American spread sheet making four types in total.

These spreadsheets are designed to calculate fuel economy/consumption and allow complete record keeping of costs associated with owning a Prius. By inputting all events and costs the spreadsheet will give a complete history of the Prius including a total cost of motoring.

There are four spreadsheets each designed to be used in countries with differing numerical systems.

It is important when using a spreadsheet to fuel the car so that the tank is completely filled. If one or more refuels are made that do not fill the tank, by combining these refuels and inputting them as one entry will maintain the integrity of calculations.

The following entries are required to calculate Fuel Consumption:

1. The MFD fuel consumption reading,
2. the odometer reading,
3. the amount of fuel added at fill up,
4. the unit price of the fuel, and
5. the outside temperature at the time of fill up.

The four Microsoft Excel spreadsheets are:

1. Data input for the North American driver - Miles, US gallons, $ and °F.
2. Data input for the British driver - Miles, Litres, £ and °C.
3. Data input for the European driver - Kilometres, Litres, € and °C.
4. Data input for driver that use the metric system - Kilometres, Litres, $, and °C.

All spreadsheets are in English and contain full instructions on their use.

The files for downloading can be found in the Priuschat's File Library.

08-26-2006, 02:14 AM	#11
Orf Senior Member Join Date: Mar 2006 Location: Devonport, Tasmania Posts: 335 My Car: 2006 Prius Package: I-Tech Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	I have finished a Excel spreadsheet for Europe. The text is English and data is in metric with costs in Euros. Would anyone like to try it as I have not tested it using actual European figures? If so, please PM me with your email address and I will send you a copy. Copies will be free and users are welcome to make changes such as a change of language. Please notify me of any errors or problems you find or suggestions you would like to see. I have finished a Excel spreadsheet for Britain. The text is English and fuel input data is in litres with costs in Pounds. I have one person testing the spreadsheet but would like someone else to try it. If so, please PM me with your email address and I will send you a copy. Copies will be free and users are welcome to make changes. Also, I have finished a Excel spreadsheet for Australia. The text is English and data is in metric with costs in dollars. The spreadsheet could be used by anyone in a country that uses metric and $. Anyone wishing to have a copy (they are free) please PM me with your email address and I will send you a copy. Please notify me of any errors or problems you find or suggestions you would like to see incorporated. OK, you Yanks have not been forgotten, I will start on one for you next week. __________________ 06 I-Tech Prius with Nav, Bra, MFD Hood and Camera. Laughing all the way to the bowser.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fuel consumption: US Vs the World	Alric	Fuel Economy	34	07-27-2007 12:05 PM
Prius Fuel Spreadsheet	Orf	The File Library	0	08-29-2006 12:36 AM
Fuel Use Spreadsheet?	bandgeek	Fuel Economy	3	07-05-2005 12:39 AM
Fuel Consumption	gwnc59a	Fuel Economy	3	03-26-2005 11:10 PM
Disappointing fuel consumption	aikidojoe	Prius Main Forum	33	03-17-2005 10:25 AM

08-29-2006, 12:47 AM	#12
Orf Senior Member Join Date: Mar 2006 Location: Devonport, Tasmania Posts: 335 My Car: 2006 Prius Package: I-Tech Nominated 0 Times in 0 Posts TOTM Awards: 0 Friends: 0	OK, I have now finished the American spread sheet making four types in total. These spreadsheets are designed to calculate fuel economy/consumption and allow complete record keeping of costs associated with owning a Prius. By inputting all events and costs the spreadsheet will give a complete history of the Prius including a total cost of motoring. There are four spreadsheets each designed to be used in countries with differing numerical systems. It is important when using a spreadsheet to fuel the car so that the tank is completely filled. If one or more refuels are made that do not fill the tank, by combining these refuels and inputting them as one entry will maintain the integrity of calculations. The following entries are required to calculate Fuel Consumption: 1. The MFD fuel consumption reading, 2. the odometer reading, 3. the amount of fuel added at fill up, 4. the unit price of the fuel, and 5. the outside temperature at the time of fill up. The four Microsoft Excel spreadsheets are: 1. Data input for the North American driver - Miles, US gallons, $ and °F. 2. Data input for the British driver - Miles, Litres, £ and °C. 3. Data input for the European driver - Kilometres, Litres, € and °C. 4. Data input for driver that use the metric system - Kilometres, Litres, $, and °C. All spreadsheets are in English and contain full instructions on their use. The files for downloading can be found in the Priuschat's File Library.