Fuel Consumption Spreadsheet

I have created a Prius fuel consumption and cost recording Excel spreadsheet. At present it is designed to record in dollars ($), litres and kilometers with an output in L/100km and for comparison, US MPG.
I am looking at expanding the spreadsheet to cover other numbering systems.
I know that Europe uses Euros and litres but how do you measure fuel consumption? Is it L/100km or km/L?
Am I correct in assuming that Britain uses a hybrid system - L/mile, or is it gallons/km? To save me time, what is the conversion rate to L and km?
I know the US uses US gallons and miles so I do not need info on that system.
Are there any other systems that I have not mentioned?
If it is easy to expand my spreadsheet to encompass the lot I will by giving a selectable choice. If not, I will consider separate spreadsheets.
The spreadsheet is well documented and made easy to use.

 

<div class='quotetop'>QUOTE(Tideland Prius @ Aug 20 2006, 02:32 AM) [snapback]306183[/snapback]</div>

That means my current spreadsheet is suitable for the European continent except for changing the $ sign to the €. That will be easily done.

 

<div class='quotetop'>QUOTE(Oxo @ Aug 20 2006, 05:07 AM) [snapback]306198[/snapback]</div>

Well now, the British version creates quite a dilemma.
One question. Does the MFD show litres or gallons? I assume it displays miles.
If petrol is sold in litres then the spreadsheet should input the quantity and price of fuel in litres. The distance input should be the same as the MFD.
If the readout is required in MPG then the spreadsheet will calculate and chart MPG.
As far as keeping track of fuel price, the spreadsheet will have to chart the price per litre and the cost per tankful against ₤.
Does anyone want to have the fuel cost charted as gallons and ₤.
The Prius being a hybrid car should feel completely at home in Britain with their hybrid numbering system.
In the distorted words of a well known saying: "Oh what a mess, Great Britain."
Thanks you both for the info so far.

 

Could someone please tell me the range of prices in euros for a litre of petrol in Europe? I need the information to set up the scale for the Price Chart.

 

Thank you for the info Oxo and no the spreadsheet is not complex but complete and easy to use.
On the main fill up sheet it will have cells to enter the MFD fuel consumption figure in MPG, the ODO reading in miles, the number of litres added and the cost per litre. The date is automatically entered. All these entries are used for calculations.

There are other cells for input of data such as petrol type, temperature (are you still ºF or have you changed to ºC?), distance after blink and comments. All these entries are for info only and are not used in any calculations.

On another sheet, other car expenses from initial purchase price to insurance and maintenance details can be input for record purposes. Apart from totalling costs, these entries play no part in the two charts that are produced.

On the main fill up sheet, there will be columns for the conversion of litres to gallons, the fuel consumption (FC) per fill up in MPG, lifetime FC in MPG, distance per fill up in mile, total fuel used in gallons and cost per fill up in £. For comparison with US readers' posts, I have included two columns with US FC in MPG and US lifetime FC.

There will be a fuel consumption chart that compares the MFD reading with the FC per fill up and the lifetime FC in graphical format.

There will be another chart that graphs the cost per fill up and price per litre. This chart allows easy observation of how costs escalate over time.

I already have most of this operating and it will only need minor modification to encompass what I have detailed above.

 

<div class='quotetop'>QUOTE(Oxo @ Aug 23 2006, 03:37 AM) [snapback]308112[/snapback]</div>

I am toooo old to be elegant in my design. I started writing computer programs in 1965 and have got worse ever since. The spreadsheet works and to me that is all that matters. No that is not correct, the number one aim is it has to be simple to use.
Thanks to you I now have enough information to go ahead an try to produce a UK model.

 

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.

 

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.