Docstoc

Gas Mileage Calculator

Document Sample
Gas Mileage Calculator Powered By Docstoc
					Gas Mileage Calculator

1. Enter your beginning odometer reading
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
  Date    Reading        Miles    (fuel added)    $Cost   MPG     per Mile
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
1. Enter your beginning odometer reading                                                   Trip Fuel Cost Estimator
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
  Date      Reading      Miles    (fuel added)    $Cost      MPG       per Mile     (Car)   (Scooter)
             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
Remember: Reset your trip odometer                           Remember: Reset your trip odometer
                   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


Remember: Reset your trip odometer                           Remember: Reset your trip odometer
                   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)


Additional Purchases                    Total
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

				
DOCUMENT INFO
Description: This is an example of gas mileage calculator. This document is useful for calculating gas mileage.