ABCDEFGHIJKLMNOPQRST
1
Fuel Cost Spreadsheet
2
Fields with a background highlight require input
3
(1) Calculating Miles Per Gallon
4
Instructions: Go to a gas station and fill your tank to full. Note your mileage on the odometer and enter it under "Initial Mileage". Drive your normal routine until you need to fill up again. Again, go to a gas station and fill your tank to full. Note the mileage and enter it under "Ending Mileage". Check your gas receipt to see how many gallons you filled your tank with and enter it under "Gallons to Full" (to at least two decimal places). This will allow the spreadsheet to calculate your actual MPG, based on your normal driving habits.
5
6
Initial Mileage4,706(3) Estimated cost of fuel per year at current gas prices
7
Ending Mileage4,975Days Between Fillup11
8
Trip Mileage269Estimated Annual Mileage8,926
9
Gallons to Full12.28Estimated Cost$1,344.66
10
Actual MPG21.91
11
12
(2) Calculating Cost per Mile
13
ActualEstimated (Optional)
14
Miles Per Gallon21.91
15
Gallons Per Mile0.05-
16
Cost of Gas ($/gal)$3.30$3.30
17
Cost Per Mile$0.15-
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100