|
10-20-2008, 12:15 AM | #1 |
╚══════════RN
|
Spreadsheet for fuel economy...
This is the spreadsheet I made for calculating various things related to fuel economy. On the first sheet you put in the date, brand, miles driven, gallons bought, it will then calcuate the MPG for you, then you put in cost per gallon, and it will calculate the cost of the fillup for you and the cost per mile.
The second sheet is completely automatically calculated. You don't have to do anything. It has the total miles you have driven, total gallons bought, total cost of fuel, average cost per gallon, average cost per fillup, average cost per mile, best MPG, worst MPG, average MPG. At the end of the year I will just calculate the average daily rates -- unless someone knows a snappy formula that will calculate it automatically somehow based on how many days have elapsed? The third sheet is a graph that shows MPG. It has each fillup you do, then it also has a second dotted red line that draws a smooth average line of MPG. Please leave comments and suggestions. I am always tweaking this to make it better and suit my tastes more. Or you can modify it yourself and make it your own. Enjoy! NOTE: This is one file, with multiple sheets, not three separate spreadsheets... thought I would make that clear if anyone was wondering since the screeenshots are sort of misleading.
__________________
42.88 |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fuel Economy Poll | pennystocks | Fuel Economy Forum | 42 | 01-28-2013 12:10 PM |
Fuel Economy section? | talnlnky | Suggestions - Feedback - Questions | 4 | 10-19-2008 06:07 AM |
Fuel economy | fmicle | General Yaris / Vitz Discussion | 24 | 05-24-2007 12:51 PM |
Tire Pressure and Gas Economy | KittenRD | General Yaris / Vitz Discussion | 11 | 01-25-2007 10:54 PM |
Fuel Economy Poll | pennystocks | General Yaris / Vitz Discussion | 0 | 05-03-2006 04:04 PM |