Personal Fuel Calculator

I like the look. Thank you!

You have a much slimmer spreadsheet than I use (I add all sorts of other calculations that likely have interest to me alone!), and it is appealing to look at. I like the graphs, and I am hoping they are time/date scaled.

I hope to enter some of my data to see what it would look like!

 

Thanks so much for this! It looks and works great!
I am a spreadsheet rookie so this is just what I was looking for.
I have a question though, I have a relatively new Prius but I only started saving my fill-up/mpg info starting at 1629 miles on the odometer. For that reason when I fill in the first row of the chart my calculated mpg is way off (high) b/c it is taking all those miles as being driven on 1 tank instead of just the previous 458 like it should. Is there a place to correct for this by entering the "started to chart" odometer reading?
Thanks again Kcissm!

 

Never mind, I see it... at the head of the column. Thanks again for the great work!

 

Thanks!

 

Kcissem, I like your calculator. I'm barely beyond novice stage on Excel (took a college Lotus course once a hundred years ago), and this works for me.

I did just stumble across a potential problem tonight. As I was entering tonight's fill, I had previously used a hand calculator in my car to figure my manual mileage -- MFD read 52.5 on 532 miles, and my calculation showed 55.78 with a 9.537 gallons fill. Fairly close, not out of line with what I was seeing before. But when I put my figures into the spreadsheet, I got a manual calculation of 68.5 mpg in column J. So I looked at the formula in cell J24 and saw that is was dividing H24 by J23. I checked the other J cells and noted that you are dividing the current miles by the previous number of gallons. I'm far from a math whiz, but it seems to me I should be dividing the current miles (532, in this case) by the most recent fill (9.537) to get the miles per gallon based on the most current numbers. That's the way I've always figured mileage. Could you please explain the reasoning behind using the previous fill gallons in the J cell formulas? If that's the way it should be, I'm happy to accept your reasoning, but it seems odd to me. I'm using the Excel 2003 program. Please be gentle.

 

Nice work. It appears that for lifetime MFD average you have a simple average of all the individual results. A more accurate (and true average) would be a weighted average based on the mileage driven for each individual tank. This is what I use in my spreadsheet. The formula for it: =SUMPRODUCT($K$9:K30,$B$9:B30)/SUM($B$9:B30)

coloumn K contains the range of MFD results and coloumn B the miles driven for each tank.

Again nice look and functionality.

 

I'm wondering if we (PCers) are changing our method of calculating mileage less because of the variable bladder size than because we can see the real-time MPG. Non-MFD cars don't give us that experience. My previous cars have been pretty consistent on mileage in given situations (so much for city driving, so much for highway driving), within a range. Prius can vary greatly even over the same route based on times stopped, pressure on the accelerator, ideal speed, etc. So a 500-mile tank this month may not have all the same elements as a 500-mile tank last month. We would have to check the displayed MPG to see if we actually were getting the same MPG for the same distance travelled. So, while theoretically the car's calculation should be the same as a manual calculation, we see a displayed figure and assume it is the standard and make changes in our methods of manual calculation based on that premise.

Additionally, I'm not sure why the previous fillup would be any more accurate than the second-previous fillup or an even older fill. It seems to me that the previous fill has no relation, physically, to the current tank volume. I would think that the current fill relates to the current tank volume, but I understand why you have a different view.

At any rate, you've given me something else to think about, however poorly I express those thoughts, and I appreciate that.

 

I found this excel table a great starting point. As with most applications, some personal adjustment makes them more useful.
I had already changed the formula to reflect the current tank fill and have now incorporated the weighted value from the MFD.
I fooled around a bit with some of the other formulas as well and now have something that suits me to a tee.
Thanks for doing the hard part, and leaving the fun adjustment only.

 

I see what you're trying to do with using previous fillups. But I'm still having trouble agreeing with that. Using simple figures that my soft brain can handle, let's say you have driven for X miles (the number doesn't seem to be relevant here) and stop to put in one gallon, and that fills it up again. You drive 100 miles, and then you put in 10 gallons. By your spreadsheet, that most recent MPG would be 100 mpg. But regardless of the size of the tank, you have used 10 gallons of gas in driving that 100 miles, so it seems to me the effect would be 10 mpg.

I agree that a better overall average is determined with a number of fills, and that should be a better indication of the efficiency of the engine.

Again, thank you for your hard work on what could well be the definitive mileage calculator.

 

Many thanks Kcissem, very useful calculator for those of us new to Prius and this Forum.
I've modified it for the UK - we have a wierd mix of buying petrol in litres but measuring everything else in imperial units, miles, mpg, etc!
Cheers!

 

Great calculator for excel.

I'm no expert in excel and wanted to change the results to display in Litres and km's

How do I go about changing the formulas in excel?

Does somebody have this calculator but for the Metric system?

 

Have you check out the spreadsheets in the File Library?

http://priuschat.com/forums/file-library/23105-prius-fuel-spreadsheet.html

There are 4 spreadsheets for US, UK, EU and AU.

 

I found that connector you were looking for

Cindy, is this the thing you were lookin
It's on the list of computer accessories and parts. They have the DVI video thing to convert that jap monitor to work with your other computer. Just about any other kind of wire adaptor, usb connectors, monitor extension wires, ps2 extention wires, and all kinds of female and male swap connectors and things that I think would help your shop. If that above linclick on computer accessories. Let me know if that is what you need and give me your email address again.
:cheer2: