Welcome to PriusChat

We'd love to have you join our community and participate in the conversation! Sign up for FREE today.

Sign Up

Fuel Consumption Spreadsheet

Discussion in 'Gen II Prius Main Forum' started by Orf, Aug 19, 2006.

Social Buttons

  1. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    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.
  2. Tideland Prius

    Tideland Prius Moderator of the North Staff Member

    Joined:
    Oct 2, 2004
    Messages:
    28,354
    Likes Received:
    1,483
    Location:
    Canada
    Your Vehicle Year:
    2010 Prius
    Model:
    N/A
    I believe they use L/100km. Only Japan uses km/L IIRC.

    Oh and UK uses mpg
  3. Oxo

    Oxo New Member

    Joined:
    Sep 17, 2005
    Messages:
    535
    Likes Received:
    0
    Location:
    Oxfordshire, UK
    Your Vehicle Year:
    2005 Prius
    <div class='quotetop'>QUOTE(Tideland Prius @ Aug 20 2006, 02:32 AM) [snapback]306183[/snapback]</div>

    Yes, but petrol is sold in litres and always priced per litre. Also the price varies with location. Here about 40 miles to the west of London I paid £0.979 when I last filled in July but I heard someone say they'd seen £1 per litre somewhere in Wales. To calculate my mpg I have to convert the litres into gallons. To convert price per litre into price per gallon, multiply by 4.54596 (97.9 p is £4.45 a gallon. 10 years ago it was £2.86 a gallon)
  4. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    <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.
  5. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    <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.
  6. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    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.
  7. Oxo

    Oxo New Member

    Joined:
    Sep 17, 2005
    Messages:
    535
    Likes Received:
    0
    Location:
    Oxfordshire, UK
    Your Vehicle Year:
    2005 Prius
    <div class='quotetop'>QUOTE(Orf @ Aug 20 2006, 09:35 PM) [snapback]306499[/snapback]</div>

    The MFD shows gallons and miles. Presumably these are Imperial gallons, but I've never checked.

    I keep a simple spreadsheet which calculates and shows MPG with each fill, so I can compare this with various readings on the MFD (I usually reset it for my longer journeys - I don't wait for an automatic reset). You seem to be creating a very complex spreadsheet. Petrol prices in Europe are likely to vary accortding to the retailer as well as the region. Small outlets often reduce the price against the prices on the big dealers nearby. Some people will drive for miles just to buy their fuel at a penny a litre cheaper!(I suppose these are the same people who will drive 6 miles to deliver a letter rather than trust it to the Post Office).
    Hybrid numbering systems exist elsewhere too. I bet Americans use 35mm film and size petrol engines in litres, not cubic inches. And their pharmacists use grams and mgs!
  8. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    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.
  9. Oxo

    Oxo New Member

    Joined:
    Sep 17, 2005
    Messages:
    535
    Likes Received:
    0
    Location:
    Oxfordshire, UK
    Your Vehicle Year:
    2005 Prius
    <div class='quotetop'>QUOTE(Orf @ Aug 22 2006, 06:22 PM) [snapback]307877[/snapback]</div>

    It may not seem complex to you but it is to me because I'm by no means a spreadsheet expert although I think a modern spreadsheet is a most elegant piece of software and I enjoy designing simple ones within my reach.

    I think the answer to your question is that the UK has changed to Celsius but many older (old-fashioned?) people still think in Fahrenheit. TV and radio forecasts always give Celsius figures prominently but the presenter will often give the F figure as an aside.
  10. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    <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.
  11. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    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.
  12. Orf

    Orf New Member

    Joined:
    Mar 11, 2006
    Messages:
    414
    Likes Received:
    4
    Location:
    Devonport, Tasmania
    Your Vehicle Year:
    2009 Prius
    Model:
    N/A
    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.
Similar Threads: Fuel Consumption
Forum Title Date
Gen II Prius Technical Discussion best fuel consumption display Aug 23, 2014
Toyota Prius Plug-in Fuel Consumption During Typical Warm-Up Jul 14, 2014
Gen III 2010+ Prius Fuel Economy Missing Fuel Consumption Data? Jul 7, 2014
Prius, Hybrid, EV and Alt-Fuel News Canada Introduces 5-Cycle Fuel Consumption Tests Apr 22, 2014
Prius, Hybrid, EV and Alt-Fuel News Fuel Consumption Down 11% Nov 19, 2013