Prius Mileage Log Excel Spreadsheet

I was told that I would have to use a macro to call excel to do the calculations so did not pursue it further.

 

Oh yeah, I remember, I hate Microsoft Office!

I wonder how tough it would be to do something like this in MySQL and make a web application out of it. (Web applications can be run from your local machine so it wouldn't have to be something that is online).

 

If you think writing Excel macros is tedious, wait till you try to write SQL select instructions that perform complex math.

 

DAMN!!!

 

DOH! I wonder if someone can make a java program that stores the data as text files (just in case we want to migrate it).

 

XML maybe?

 

Seeing all of these wonderful spreadsheets has inspired me to revamp my own basic spreadsheet based calculations.

As far as a program is concerned there are programs on the market that will track all of the things mentioned, I opted not to purchase them just because I wouldn't trust the results since I can't see the math being performed ( I admit to being an obsessive compulsive control freak ). Since I am a programmer professionally I have been working on something similar for a while now, but personal matters ( family, work, sleep ) have delayed that project for a while now.

Again good job to all that posted their spreadsheets. I am now the proud recipient of "Spreadsheet Envy".

Tim In Jax

 

Thanks. Post yours when you get it up.

<changed some formulas to reduce inputs>

 

zzz

 

<div class='quotetop'>QUOTE(Jack Straw @ May 27 2006, 12:12 AM) [snapback]261635[/snapback]</div>

Here's mine. Start by entering your starting ODO reading in A2, and a comparison average MPG in H2 (the red cells).

The four green columns are where you enter your data.

The next 4 yellow columns give you your results:
MPG based on hand calculation - compare to MFD, which is what your Prius says you got.
Avg is the running lifetime average MPG based on hand calculation.
CAvg is the computed lifetime average MPG based on the MFD data.
Saved is the amount saved over another vehicle based on the average MPG entered in H2. I used 26 for my best tank on my old 99 Honda Prelude.

The next 4 blue columns give you extra info:
Miles is used to calculate most of the tank info.
CGals is how many gallons the MFD thinks you've used based on miles driven and MPG. Compare it to Gals in column B to rate accuracy of your fillups and whether or not you're topping off.
TGals is a running total of fuel you pumped in.
TCGals is a running total of fuel the MFD thinks you've used. Compare to TGals. After a while, they should be pretty much even.