Documents
User Generated
Resources
Learning Center

Gas Mileage Calculator

VIEWS: 1,304 PAGES: 10

This is an example of gas mileage calculator. This document is useful for calculating gas mileage.

• pg 1
```									Gas Mileage Calculator

2. Each time you re-fuel, record the odometer reading, the amount of fuel added
and the cost
(Don't delete the blue columns - they contain formulas)
To use metric values, substitute km for miles and liters for gallons

Refuel Odometer                     Gallons                       \$Cost
4/14/2008     10.0                      1        \$ 3.50 (mileage)
4/29/08         78.0     68.0       0.966       \$   3.59    70.4    \$ 0.053
5/2/08        173.8      95.8       1.326       \$   4.93    72.2    \$ 0.051
5/14/08       268.3      94.5       1.225       \$   4.81    77.1    \$ 0.051
5/19/08       346.8      78.5       1.115       \$   4.37    70.4    \$ 0.056
5/29/08       445.3      98.5       1.315       \$   5.38    74.9    \$ 0.055
6/7/08        525.2      79.9       1.206       \$   4.09    66.3    \$ 0.051
6/11/08       619.8      94.6       1.216       \$   5.06    77.8    \$ 0.053
6/19/08       713.8      94.0       1.169       \$   4.86    80.4    \$ 0.052
6/26/08       801.0      87.2       1.134       \$   4.72    76.9    \$ 0.054
7/2/08        900.4      99.4       1.314       \$   5.52    75.6    \$ 0.056
7/9/08        991.3      90.9       1.177       \$   4.94    77.2    \$ 0.054
7/16/08      1,071.8     80.5       1.166       \$   4.90    69.0    \$ 0.061
7/27/08      1,164.9     93.1       1.184       \$   4.95    78.6    \$ 0.053
8/4/08       1,248.6     83.7       1.105       \$   4.53    75.7    \$ 0.054
8/11/08      1,335.9     87.3       1.096       \$   4.12    79.7    \$ 0.047
8/25/08      1,431.1     95.2       1.296       \$   4.77    73.5    \$ 0.050
8/30/08      1,523.9     92.8       1.239       \$   4.76    74.9    \$ 0.051
9/5/08       1,614.5     90.6       1.246       \$   4.68    72.7    \$   0.05
Gas Mileage Calculator
Scooter
2. Each time you re-fuel, record the odometer reading, the amount of fuel added             \$Cost per Mile
and the cost                                                                                  Distance
(Don't delete the blue columns - they contain formulas)                                            Cost
To use metric values, substitute km for miles and liters for gallons

\$Total  \$Total Cost
Refuel    Odometer                  Gallons                            \$Cost     Cost Gas    Gas
142250                                        (mileage)              \$ 827.67 \$    88.48
5/6/08     142504      254.0       11.433      \$ 40.00     22.2      \$ 0.157
5/9/08     142786      282.0       13.201      \$ 47.51     21.4      \$ 0.168
5/10/08     143045      259.0       11.626      \$ 43.00     22.3      \$ 0.166
5/16/08     143295      250.0       11.586      \$ 42.51     21.6      \$ 0.170
5/23/08     143544      249.0       12.266      \$ 46.60     20.3      \$ 0.187
6/1/08     143784      240.0       12.503      \$ 47.50     19.2      \$ 0.198
6/13/08     144014      230.0       12.182      \$ 47.50     18.9      \$ 0.207
6/20/08     144259      245.0       12.183      \$ 47.50     20.1      \$ 0.194
7/13/08     144491      232.0       11.998      \$ 47.50     19.3      \$ 0.205
7/15/08     144773      282.0       12.631      \$ 50.01     22.3      \$ 0.177
7/20/08     145057      284.0       12.251      \$ 48.26     23.2      \$ 0.170
7/25/08     145309      252.0       11.697      \$ 45.02     21.5      \$ 0.179
7/31/08     145558      249.0       12.502      \$ 47.50     19.9      \$ 0.191
8/12/08     145812      254.0       13.035      \$ 46.00     19.5      \$ 0.181
8/16/08     146075      263.0       12.639      \$ 47.51     20.8      \$ 0.181
8/17/08     146373      298.0       12.802      \$ 48.25     23.3      \$ 0.162
8/24/08     146627      254.0       11.767      \$ 40.00     21.6      \$ 0.157
9/1/08     146882      255.0       13.079      \$ 45.50     19.5      \$ 0.178
Car
Trip Fuel Cost Estimator                                          Trip Fuel Cost Estimator
\$ 0.053                                             \$Cost per Mile \$ 0.179
1,614.5 miles                                          Distance    4,632 miles
\$ 85.59                                                    Cost \$ 830.80

40                                                                                                             \$0.30
Mileage

35                                                                                                             \$0.25
30                                                                                                             \$0.20
25
20                                                                                                             \$0.15
15                                                                                                             \$0.10
5/20/2008

6/17/2008

7/15/2008

7/29/2008

8/12/2008

8/26/2008
5/6/2008

6/3/2008

7/1/2008
Service Log - Scooter                                                     Service Log - Car

Date      Miles      Service             Cost       Total   \$ 119.64      Date
6/5/2008        506 500 mile service     \$ 72.32                         1/29/2008
8/7/2008       1286 1200 mile service    \$ 47.32                          5/5/2008

january   x
february
march
april
may       x
june
july
august
september x
october
november
december
Service Log - Car

Miles       Service      Cost       Total   \$ 140.53
Oil change    \$ 41.95
Oil change    \$ 98.58
km or      Liters or       km/L or                           km or   Liters or       km/L or
Date   Odometer    Miles      Gallons     \$    MPG           Date   Odometer    Miles   Gallons     \$    MPG

Fold Here

Fold Here                                                        Fold Here

km or      Liters or       km/L or                           km or   Liters or       km/L or
Date   Odometer    Miles      Gallons     \$    MPG           Date   Odometer    Miles   Gallons     \$    MPG

Fold Here
Total Scooter Costs
\$3.00/gal
Item         Cost                                  Total       \$ 2,066.09           Savings     \$ 256.77
Gas           \$   88.48                            Spent
Servicing     \$ 119.64

Insurance                 \$ 456.14 (April - December 2008)
Loan payments             \$ 846.54 (April - December 2008)

Jacket     \$ 150.00                 \$     555.29
Gloves     \$   25.00
Helmet       \$   170.00            Fuel Consumption Comparison
Alarm        \$    29.00                                                                                    Scooter
License      \$    15.00                            Scooter     Car       Difference Price/Gal Miles
Lock         \$   100.00            January                      \$ 114.82             \$    2.90
MSF Class    \$    65.00            February                     \$ 101.01             \$    2.84
Cup holder   \$     1.29            March                        \$ 181.72             \$    3.15
April                        \$ 183.66             \$    3.47
May             \$   26.58    \$ 219.62 \$ 193.04 \$       3.79    445.3
June            \$   18.73    \$ 142.50 \$ 123.77 \$       3.89    355.7
July            \$   20.31    \$ 238.29 \$ 217.98 \$       3.79    363.9
August          \$   18.18    \$ 181.76 \$ 163.58 \$       3.59    359.0
September       \$    4.68    \$  45.50 \$    40.82                 90.6
October
November
December

\$   88.48   \$ 1,408.88                        1,614.5
\$3.50/gal \$4.00/gal \$4.25/gal \$4.50/gal
\$ 299.56 \$ 342.36 \$ 363.76 \$ 385.15

2008
Scooter                           Car               Total
Gallons MPG           Miles      Gallons   MPG       Miles     Savings

6.9     64.10      1,294        60     21.53   1,739.3   \$   80.15
4.7     75.28        947        49     19.38   1,302.7   \$   64.03
4.8     75.17      1,299        61     21.27   1,662.9   \$   65.50
4.7     75.80      1,069        50     21.28   1,508.5   \$   64.62
1.2     72.71        255        13     19.50     419.6   \$   16.31
-
-
-

4,864.0                       6,633.0   \$ 290.61

```
To top