ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Setup for Calculating Gas Savings
3
1. Enter the average miles-per-gallon of your vehicle in cell A43.
4
2. Enter the average price per gallon of gasoline in cell A45. This varies by region, so ask Google, "what is the average price of gas in (your state)"
5
6
7
1. There are sections to log miles under "Commute" (rows 5-25), "Errands & Outings" (rows 27-34), and "FUN!" (rows 36-45), depending on the type of ride you did.
8
2. Enter the day of the month in the "D8" column.
9
3. Enter the number of miles ridden in the "Miles" column.
10
4. Because the distance you ride might not always match how far you would have driven in your car (different routes, riding extra miles for fun, etc.), you can enter the distance you WOULD have driven in the "Saved" column.
11
TIP: mapmyride.com is a free tool you can use to plot your route and determine the distance ridden or the would-be driving distance.
12
13
14
• Running totals for the year are displayed in Column A.
15
• Running totals for each month appear at top of each column in Row 2.
16
17
Other Tweaks
18
• If you want to remember what you did for a certain ride, right click on the cell and select "Insert Note" to type a description.
19
• You can color code your entries to indicate which bike you used. The example to the right uses blue for a road bike and black for a mountain bike.
20
• You might do more of one type of ride than another, so feel free to change the names of the "Commute", "Errands & Outings" and "FUN!" sections. Just make sure to also change the names in A17, A20, and A23, respectively. If you actually change the number of rows under each section, you'll need to make sure to update the corresponding formulas for each of the totals.
21
• Whatever else you can think of! Get creative and make it your own!
22
23
24
25
26
Duplicate the "2021" tab to start a new year!
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