|
I set up an excel spreadsheet which may be similar to yours. I set up columns for:
1. Date
2. Miles (on tripodometer)
3. gallons pumped
4. MPG (formula for col2 / col3)
5. $/gal
6. Total price (formula for col3 * col5)
7. Notes
And at the bottom, I made a row for computing the averages of each column (aside from the date and notes, obviously), and the sum total for the "total price" column.
I'd be interested to compare with yours, if you have other statistics tracked or whatnot.
|