Excel Spreadsheet

Gas Mileage Calculator

You must be logged in to download this document
Description

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

Reviews
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 Date Reading 4/14/2008 10.0 4/29/08 5/2/08 5/14/08 5/19/08 5/29/08 6/7/08 6/11/08 6/19/08 6/26/08 7/2/08 7/9/08 7/16/08 7/27/08 8/4/08 8/11/08 8/25/08 8/30/08 9/5/08 78.0 173.8 268.3 346.8 445.3 525.2 619.8 713.8 801.0 900.4 991.3 1,071.8 1,164.9 1,248.6 1,335.9 1,431.1 1,523.9 1,614.5 Miles 68.0 95.8 94.5 78.5 98.5 79.9 94.6 94.0 87.2 99.4 90.9 80.5 93.1 83.7 87.3 95.2 92.8 90.6 Gallons (fuel added) 1 0.966 1.326 1.225 1.115 1.315 1.206 1.216 1.169 1.134 1.314 1.177 1.166 1.184 1.105 1.096 1.296 1.239 1.246 $Cost $Cost MPG per Mile $ 3.50 (mileage) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 3.59 4.93 4.81 4.37 5.38 4.09 5.06 4.86 4.72 5.52 4.94 4.90 4.95 4.53 4.12 4.77 4.76 4.68 70.4 72.2 77.1 70.4 74.9 66.3 77.8 80.4 76.9 75.6 77.2 69.0 78.6 75.7 79.7 73.5 74.9 72.7 $ 0.053 $ 0.051 $ 0.051 $ 0.056 $ 0.055 $ 0.051 $ 0.053 $ 0.052 $ 0.054 $ 0.056 $ 0.054 $ 0.061 $ 0.053 $ 0.054 $ 0.047 $ 0.050 $ 0.051 $ 0.05 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 Scooter Trip Fuel Cost Estimator $Cost per Mile Distance Cost Refuel Date 5/6/08 5/9/08 5/10/08 5/16/08 5/23/08 6/1/08 6/13/08 6/20/08 7/13/08 7/15/08 7/20/08 7/25/08 7/31/08 8/12/08 8/16/08 8/17/08 8/24/08 9/1/08 Odometer Reading 142250 142504 142786 143045 143295 143544 143784 144014 144259 144491 144773 145057 145309 145558 145812 146075 146373 146627 146882 Miles 254.0 282.0 259.0 250.0 249.0 240.0 230.0 245.0 232.0 282.0 284.0 252.0 249.0 254.0 263.0 298.0 254.0 255.0 Gallons (fuel added) 11.433 13.201 11.626 11.586 12.266 12.503 12.182 12.183 11.998 12.631 12.251 11.697 12.502 13.035 12.639 12.802 11.767 13.079 $Cost $ 40.00 $ 47.51 $ 43.00 $ 42.51 $ 46.60 $ 47.50 $ 47.50 $ 47.50 $ 47.50 $ 50.01 $ 48.26 $ 45.02 $ 47.50 $ 46.00 $ 47.51 $ 48.25 $ 40.00 $ 45.50 MPG (mileage) 22.2 21.4 22.3 21.6 20.3 19.2 18.9 20.1 19.3 22.3 23.2 21.5 19.9 19.5 20.8 23.3 21.6 19.5 $Cost per Mile $ 0.157 $ 0.168 $ 0.166 $ 0.170 $ 0.187 $ 0.198 $ 0.207 $ 0.194 $ 0.205 $ 0.177 $ 0.170 $ 0.179 $ 0.191 $ 0.181 $ 0.181 $ 0.162 $ 0.157 $ 0.178 $Total $Total Cost Cost Gas Gas (Car) (Scooter) $ 827.67 $ 88.48 Trip Fuel Cost Estimator $ 0.053 1,614.5 miles $ 85.59 Car Trip Fuel Cost Estimator $Cost per Mile $ 0.179 Distance 4,632 miles Cost $ 830.80 40 35 30 25 20 15 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 $0.30 $0.25 $0.20 $0.15 $0.10 Mileage Service Log - Scooter Date Miles Service 6/5/2008 506 500 mile service 8/7/2008 1286 1200 mile service Cost $ 72.32 $ 47.32 Total $ 119.64 Service Log - Car Date 1/29/2008 5/5/2008 january x february march april may x june july august september x october november december Service Log - Car Miles Service Oil change Oil change Cost $ 41.95 $ 98.58 Total $ 140.53 Remember: Reset your trip odometer Date Odometer km or Miles Liters or Gallons $ km/L or MPG Remember: Reset your trip odometer Date Odometer km or Miles Liters or Gallons $ km/L or MPG Fold Here Fold Here Fold Here Remember: Reset your trip odometer Date Odometer km or Miles Liters or Gallons $ km/L or MPG Remember: Reset your trip odometer Date Odometer km or Miles Liters or Gallons $ km/L or MPG Fold Here Total Scooter Costs Item Gas Servicing Cost $ 88.48 $ 119.64 Total Spent $ 2,066.09 Savings $3.00/gal $ 256.77 Insurance Loan payments $ 456.14 (April - December 2008) $ 846.54 (April - December 2008) Additional Purchases Jacket $ 150.00 Gloves $ 25.00 Helmet Alarm License Lock MSF Class Cup holder $ $ $ $ $ $ 170.00 29.00 15.00 100.00 65.00 1.29 $ Total 555.29 Fuel Consumption Comparison Scooter Scooter January February March April May June July August September October November December Car Difference Price/Gal Miles $ 114.82 $ 2.90 $ 101.01 $ 2.84 $ 181.72 $ 3.15 $ 183.66 $ 3.47 $ 219.62 $ 193.04 $ 3.79 445.3 $ 142.50 $ 123.77 $ 3.89 355.7 $ 238.29 $ 217.98 $ 3.79 363.9 $ 181.76 $ 163.58 $ 3.59 359.0 $ 45.50 $ 40.82 90.6 $ $ $ $ $ 26.58 18.73 20.31 18.18 4.68 $ 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 Gallons MPG Miles Car Gallons MPG Total Miles Savings 6.9 4.7 4.8 4.7 1.2 64.10 75.28 75.17 75.80 72.71 1,294 947 1,299 1,069 255 60 49 61 50 13 21.53 19.38 21.27 21.28 19.50 1,739.3 1,302.7 1,662.9 1,508.5 419.6 6,633.0 $ $ $ $ $ 80.15 64.03 65.50 64.62 16.31 4,864.0 $ 290.61

Related docs
Mileage And Gas Calculator
Views: 30  |  Downloads: 0
Gas-Mileage-Log-and-Calculator
Views: 28  |  Downloads: 1
Gas Mileage Comparison Calculator
Views: 1  |  Downloads: 0
And Gas Calculator
Views: 2  |  Downloads: 0
gas-mileage-calculator
Views: 4572  |  Downloads: 105
Epa Gas Mileage Charts
Views: 0  |  Downloads: 0
MPGe Calculator
Views: 30  |  Downloads: 4
Gas Calculator From
Views: 7  |  Downloads: 0
Cars mileage log
Views: 17  |  Downloads: 3
Mileage Log (1 Page)
Views: 5  |  Downloads: 0
Gas Mileage Charts
Views: 144  |  Downloads: 0
mileage trip planner
Views: 52  |  Downloads: 0
calculator automobile
Views: 106  |  Downloads: 4
premium docs
Other docs by Beunaventura L...
Laws Against Abortion
Views: 1518  |  Downloads: 16
Insurance Claims Investigations
Views: 1102  |  Downloads: 16
Injury Compensation Claims
Views: 746  |  Downloads: 16
Handling Claims
Views: 1027  |  Downloads: 15
From Insurance Claim
Views: 1008  |  Downloads: 11
Compensation Claim
Views: 726  |  Downloads: 4
Class Action Claim
Views: 605  |  Downloads: 0
Claims for Injury
Views: 476  |  Downloads: 3
Automobile Insurance Claims
Views: 798  |  Downloads: 12
Auto Insurance Claim Settlement
Views: 953  |  Downloads: 8
Auto Accident Lawsuit
Views: 712  |  Downloads: 2
Free Living Will Forms
Views: 2635  |  Downloads: 46
7th Amendment
Views: 2194  |  Downloads: 3
Safe Drinking Water Act
Views: 394  |  Downloads: 8
Rental Lease
Views: 6824  |  Downloads: 611