Anyone use any spreadsheets for the calculation of gas mileage, purchase amounts, etc? I have my own website and I'd like to track my Prius stuff, but I'm horrible with mathmatical calculations (yes, horrible for a programmer, I know). So, if anyone uses a spreadsheet or other nifty electronic tracking functions, I'd appreciate it if you were able to pass them along. Rob http://27chickens.com/
Here is mine. I am tracking / estimating how much I am saving in gas had I kept my Lexus which was getting around 22 MPG. There are charts on the second tab. You put data in the light green cells (Date, Odometer Reading, Gallons of Gas, Price p/Gallon & the MPG the MFD is showing for that tank). I also track the accuracy of the MFD MPG display (p/tank). Ken
I guess I should explain my spreadsheet... Enter the date, the number of miles for this fill-up (I use odometer A), the number of gallons pumped and the total amount you paid. Everything else is calculated. I added the four-tank rolling average after seeing the ups and downs from last summer. It's ugly, but it works. Charlie
I don't have my Prius yet, but I put one together so I'll be ready. It's very simple. Just put in Odometer reading, and gallons and it does the rest. Total cost is for budget purposes. Ken
