Universal Fuel Consumption Excel Sheet

Thank you so much for the spreadsheet. I was looking for a way to record all this information. I just filled up last week. My 1st time since getting the car more than 3 weeks ago. The dealer filled the tank before I got there. This will give me a good idea on the money my Prius is saving me. I stepped up from a F250 diesel. Much cheaper this way, I love my Prius.

 

Makes total sense. Thanks again for the spreadsheet.
I screwed up today on the first fill up and put $40 in thinking it wouldn't take the whole 40, it did, so I had to go put another 20 in, I pumped it and it stopped right away..so not knowing if it stopped because it was full, I continued pumping and BAM, it overflowed out on the side of my car! I was pissed!
I'm also banking that it was completely full when it was filled up from the dealer, It looked full.
Another Question for you..what is MPG (US) and MPG (IMP). I'm assuming that MPG (IMP) is what the car should tell me but its off by .11.(less than what the car says)

Take care,

Natty

 

Hi Natty,

"MPG US" is US gallons (~3.78litres) whereas MPG (IMP) is imperial gallons ~4.6 litres.

Enjoy your new wheels and congrats,
Natty

 

Prius 07,

Thanks for that info.
Man, so I'm off approx 8 MPG between calculated MPG and computer in the prius MPG. Is that normal to be that off on the first tank? I guess I can't be sure that the dealer had it filled ALL the way up. Since I barfed my first fill up, I'll know more 2 more fill ups down the road.

Natty

 

:target:Thank you very much. I have been using another spreadsheet program somone had posted last year and it also does a lot, but I like your program, because I don't have to input as much and still get great results, but the one thing that the other program did, that is real neat and I am wondering if you could possibly impliment it into your spreadsheet.

The one thing I know everyone likes to know is just how much they are saving compared to the gas hog they got rid of when they bought the awesome gas SIPPING wonder. The program I had been using allowed you to plug in what you use to get as a base MPG. I had a Honda van that got 20mpg. The program would show how much it would cost if I was using the Honda, then a running total savings. So far after 9 months I have saved $923.71. Example: when I put in 4.476 galons of gas at $3.239 per gallon, it cost me $14.50, but in the honda at 20 mpg it would have cost me $ 37.64 to fill up. Have no idea how it is done. Just a thought.

But thanks what you have done.

Richard123

 

Hello Priusuk2008,
I just got my Prius 3 weeks ago, and was recording the fill-ups in a notepad. The spreadsheet you developed keeps a great track record for consumption.
Thank you for sharing the sheet. By the way do they still have steak and kidney pies? Based in Brize Norton 4 years.

 

the best thing about excel is that it can be customized to fit. for me, i keep separate subtotals for winter and summer mileage along with cents per mile cost...

 

Apologies if this is already something you know about, but consider using PivotTables. If you have two columns (say, date and mpg), you can easily have Excel put them into bins based on month (or season).

Might save you a bit of effort, is all. Good luck!

 

Thanks for the spreadsheet for tracking to fuel data for the Prius. I have already started using it, but I also added a column to indicate the price per gallon. The price per gallon was $3.18 when I bought my Prius just a month ago. Today's price when I fill up the tank was $3.50. My current MPG is 45.97, overall MPG is 42.35 with a total mileage of 1528.

 

Just in case you overlooked it that is already in the spreadsheet. column Q, or R for price/liter.

 

Many thanks PriusUK2008, for a very useful spreadsheet. I've been keeping all my fill ups in an expense management book. As soon as I downloaded your sheet, I transfered my figures to it.

I've attached the results here just in case anyone is interested in looking at a 2 year log of mileage and gas purchases

 

OK! Here are the numbers with costs added. Note that fuel cost for 2 years of operation comes to $0.072/ mile. I wonder if there is a list showing actual (as opposed to EPA calculated costs) for all vehicles?

 

Nice work... I love the "autofilter" option in excel
I have a simpler version of it that I've been using.

In mine I added a column to calculate hypothetical savings for each fill-up over my last car (assumes 25mpg). So if the distance was 400 miles and cost was $4/gal, I would have used 16 gallons in my old car and spent $64 for that fill-up. Helps me quantify the justification for owning the Prius :bowl:

 

The spread sheet is GREAT! I don't even try to justify the Prius. I bought it because I wanted it and liked it.

Bob