How to Keep Track of Fuel Use

Step-by-Step Guide

1. 1

   Step 1: The first four columns of your spreadsheet are from your receipts

   A:
   Date, B:
   Odometer, C:
   Fuel, D:
   Price.
   
   Enter in every decimal place of precision you get. , “=$B3-$B2”). , “=$E3/$C3”). , A 3x sample, a 6x sample, and an overall sample. (“=AVERAGE($F3:$F5)”, “=AVERAGE($F3:$F8)”, “=AVERAGE($F$3:$F3)”, respectively.) This keeps track of changes over weeks, changes over months, and overall changes in mileage, so you get slightly quicker feedback and overall feedback. , “=$D2*$C2”), and if you entered everything right, it should be exactly what you paid the gas station attendant. , “=$J3/$E3” or “=$E3/$C3”). ,
2. 2

   Step 2: and are just straight input fields.

3. 3

   Step 3: 'Miles' is just the current odometer reading minus the previous odometer (i.e.

4. 4

   Step 4: 'MPG' is the result of 'Miles' divided by 'Fuel' (i.e.

5. 5

   Step 5: You can break the 'Average' MPG down into three categories.

6. 6

   Step 6: 'Cost' is taking 'Price' times 'Fuel' (i.e.

7. 7

   Step 7: 'Cost/Mile' is taking the result of 'Cost'

8. 8

   Step 8: and dividing it by 'Miles' (i.e.

9. 9

   Step 9: To add tanks

10. 10

    Step 10: simply copy the bottom line of the spreadsheet and paste it to the next line

11. 11

    Step 11: and then enter the current figures for the first four fields.

Detailed Guide

About the Author