Overview

Intro
Extracted data
Oil Change
Tires
Misc.
Gas Mileage Data


Sheet 1: Intro

----------- Home -------------- Email -----------
This is a spread sheet of the fuel milage of my 2000 Ford Focus.

I bought this car used with 75,000 miles and have been keeping track of the Gas Mileage and Maintenance since day one.
If you want a copy of this spread sheet book for your car, just ask.

Sheet 2: Extracted data

Total Fuel Costs Total Gallons Average MPG Highest Price Lowest Price Best Gas Mileage Worst Gas Mileage Total Miles
$4,727.10 1,469 30.31 $4.30 $1.84 38.65 23.65 46,508








Total of “Oil Change”
Cost of Vehicle after Interest
Cost per Mile Without Cost of Vehicle
Total Cost Overall
$377.04
$5,487.80
$0.23
$16,197.60








Total of “Tires”
Total of “Misc”
Cost per Mile With Cost of Vehicle


$523.70
$5,081.96
$0.35










Year – Quarter Quarterly fuel payout Yearly fuel payout Miles Cost per mile MPG Yearly MPG Overall MPG
2007-4 $91.57 $91.57 490 $0.187 27.89 27.89 30.19
2008-1 $323.96


28.65

2008-2 $370.97


32.23

2008-3 $427.25


32.12

2008-4 $223.28 $1,345.45 12,034 $0.112 31.22 31.05
2009-1 $192.87


30.31

2009-2 $131.61


33.28

2009-3 $326.64


33.24

2009-4 $243.41 $894.53 10,325 $0.087 29.83 31.66
2010-1 $213.47


29.26

2010-2 $196.13


31.20

2010-3 $290.64


31.85

2010-4 $181.09 $881.33 9,392 $0.094 31.32 30.91
2011-1 $194.35


32.34

2011-2 $98.22


29.45

2011-3 $421.33


29.36

2011-4 $309.69 $1,023.59 8,594 $0.119 26.65 29.45
2012-1 $323.92


25.83

2012-2 $166.71


25.85

2012-3






2012-4
$490.63 3,293 $0.149
25.84

Sheet 3: Oil Change

Date Odometer Job Cost Mileage Cost/Mile Total Costs

75,459 New Car



02/22/2008 77,962 Oil Change $35.35 2503 $0.01 $377.04
07/02/2008 83,243 Oil Change $36.42 5281 $0.01
04/11/2009 91,478 Oil Change $36.42 8235 $0.00
06/08/2009 94,302 Oil Change $36.42 2824 $0.01
08/22/2009 97,722 Oil Change $36.42 3420 $0.01
11/27/2009 100,670 Oil Change $37.49 2948 $0.01
03/24/2010 103,457 Oil Change $37.49 2787 $0.01
08/22/2010 107,072 Oil Change $39.63 3615 $0.01
04/22/2011 113,242 Oil Change $39.63 6170 $0.01
11/05/2011 117855 Oil Change $41.77 4613 $0.01

Sheet 4: Tires

Date Odometer Mileage Cost Job Costs/Mile Total Costs

75459



$523.70
12/06/2008 87518 12059 $124.00 New Tires $0.01
09/15/2009 98468 10950 $134.00 New Tires $0.01
02/06/2011 111734 13266 $129.70 New Tires $0.01
03/10/2012 120755 9021 $136.00 New Tires $0.02

Sheet 5: Misc.

Date Mileage Cost Job Total Costs

75459

$5,081.96
08/06/2008 83592 $128.74 AC Recharge
01/07/2009 88381 $366.10 Brake Cable



NYS Inspection



Rear Wheel Bearings
03/25/2009 90774 $584.49 Exhaust Pipe



Exhaust Flex Pipe
04/16/2009 91577 $109.00 Ignition Coil


$21.49 Spark Plugs
07/30/2009 96618 $52.48 O2 Sensor
09/29/2009 98944 $31.18 Diagnostics
12/10/2009 100990 $108.07 PVC Hose
12/29/2009 101414 $219.69 Replace IAC Valve
02/01/2010 102475 $21.00 NYS Inspection
04/08/2010 103813 $351.00 Ignition Key
05/06/2010 104391 $49.88 PDFE Sensor Hose
05/26/2010 104692 $77.94 Replaced IAC Valve
06/10/2010 105085 $94.60 Diagnostics
06/15/2010 105150 $35.85 Throttle Body gasket
06/25/2010 105460 $78.77 Diagnostics
07/02/2010 105713 $83.65 ??Emission box??

105910 $12.89 Fuel Filter
07/16/2010
$27.39 Freon

106065 $184.09 Spark Plugs



Spark Plug Wires



Check A/C
08/06/2010 106738 $651.21 A/C/ hose



A/C/ hose



Accumulator/Dryer
10/15/2010 110000 $3.21 Hose Clamps
03/17/2011 112656 $409.72 brake line



Brake Shoe's



Rear Seal?



Wheel Bearings



LR spring



LR wheel cylinder



Brake fluid



NYS Inspection
06/10/2011 113377 $49.41 Brake lines (front L+R)


$6.56 Brake fluid and penetrating oil


$21.99 Brake Pads (front L+R)


$43.99 Brake Caliper (L-front) *Note Needs R-rear bleeder screw
06/27/2011 113504 $21.43 Alternator From Junk Yard Ford Windstar
07/23/2011 114180 $21.40 Used Rim From Junk Yard Focus.
07/23/2011 114190 $12.90 Change Tire Change rubber from rim to rim.
07/23/2011 114190 $10.00 Freon Recharge A/C
01/19/2012 119620 $77.00 L+R Struts


$23.00 R – Rear brake Shoes


$148.00 L+R Brake Drums


$60.00 L+R Rear Brake Cylinder


$14.04 R – Brake spring kit


$0.61 ?Fitting? Unknown but possibly brake line adapter


$3.16 Brake fluid


$275.00 Labor


$45.07 Tax
02/11/2012 120100 $21.40 Alternator Same Focus type/year, Not replaced yet
02/28/2012 120536 $21.50 Suspension check Possible Rear tires Camber issue
03/27/2012 120356 $58.03 rear shocks
03/28/2012 120536 $62.71 Suspension lower rear control arm
04/04/2012 121408 $263.63 EVAP Canister Purge Valve



(replaced control arm)



4 wheel alignment
04/10/2012 121441 $23.53 Breather Tube Ass.


$95.16 Idle Air Control Valve

Sheet 6: Gas Mileage Data

Total cash Total gallons Average MPG Highest price Lowest price Best Gas mileage Worst Gas Mileage Total Miles




$4,727.10 1469.23 30.310 $4.30 $1.84 38.647 23.649 46508

















Quarter Date Odometer P.P.G. Total Spent Gallons Miles M.P.G.





12/14/07 75614 $3.259 $34.19 10.490






Q-4 2007 12/22/07 75870 $3.199 $31.39 9.812 256 26.091





12/29/07 76104 $3.299 $26.00 7.881 234 29.692





01/03/08 76336 $3.359 $26.90 8.009 232 28.967





01/12/08 76627 $3.229 $30.36 9.403 291 30.948





01/21/08 76882 $3.259 $30.00 9.205 255 27.702





01/29/08 77128 $3.199 $27.03 8.450 246 29.112




Q-1 2008 02/05/08 77392 $3.199 $30.00 9.379 264 28.148





02/12/08 77624 $3.239 $27.25 8.413 232 27.576





02/20/08 77892 $3.299 $31.36 9.505 268 28.196





03/01/08 78148 $3.329 $31.00 9.313 256 27.488





03/07/08 78389 $3.379 $28.05 8.301 241 29.033





03/15/08 78658 $3.439 $32.00 9.305 269 28.909





03/24/08 78916 $3.379 $30.00 8.878 258 29.061





04/03/08 79192 $3.499 $32.00 9.145 276 30.180





04/08/08 79486 $3.559 $32.01 8.994 294 32.688





04/18/08 79787 $3.699 $36.26 9.802 301 30.708





04/30/08 80099 $3.759 $37.50 9.975 312 31.278




Q-2 2008 05/06/08 80409 $3.839 $36.51 9.509 310 32.601





05/16/08 80744 $3.939 $41.50 10.536 335 31.796





05/23/08 81019 $4.079 $34.15 8.372 275 32.848





06/01/08 81348 $4.099 $41.00 10.003 329 32.890





06/12/08 81675 $4.259 $40.00 9.392 327 34.817





06/21/08 81981 $4.259 $40.05 9.403 306 32.543





07/01/08 82304 $4.299 $42.00 9.769 323 33.064





07/09/08 82612 $4.279 $39.79 9.300 308 33.118



`

07/20/08 82935 $4.179 $41.15 9.848 323 32.799





07/27/08 83276 $4.139 $41.40 10.003 341 34.090





08/05/08 83591 $4.159 $40.31 9.693 315 32.498




Q-3 2008 08/14/08 83877 $3.979 $38.00 9.551 286 29.945





08/23/08 84194 $3.899 $39.52 10.135 317 31.278





09/01/08 84468 $3.899 $34.01 8.722 274 31.415





09/10/08 84768 $3.799 $37.00 9.739 300 30.804





09/16/08 85098 $3.799 $38.03 10.011 330 32.964





09/28/08 85395 $3.799 $36.03 9.484 297 31.316





10/08/08 85741 $3.579 $37.75 10.547 346 32.806





10/19/08 86062 $3.279 $32.70 9.974 321 32.184





10/29/08 86397 $2.919 $31.50 10.790 335 31.047





11/07/08 86681 $2.739 $23.70 8.653 284 32.821




Q-4 2008 11/17/08 87004 $2.149 $21.63 10.066 323 32.088





12/01/08 87318 $2.239 $23.25 10.384 314 30.239





12/09/08 87610 $1.979 $19.25 9.726 292 30.023





12/17/08 87859 $1.959 $16.30 8.319 249 29.931





12/25/08 88138 $1.839 $17.20 9.353 279 29.830





01/07/09 88391 $1.959 $16.40 8.373 253 30.216





01/12/09 88589 $1.879 $12.60 6.705 198 29.530





01/21/09 88871 $1.959 $19.01 9.704 282 29.060





02/01/09 89157 $2.079 $19.75 9.499 286 30.108




Q-1 2009 02/08/09 89457 $2.099 $20.40 9.720 300 30.864





02/19/09 89764 $2.059 $20.91 10.156 307 30.228





02/28/09 90071 $2.119 $21.60 10.195 307 30.113





03/08/09 90374 $2.079 $20.75 9.979 303 30.364





03/17/08 90696 $2.079 $20.00 9.619 322 33.475





03/28/09 90988 $2.139 $21.45 10.026 292 29.124





04/14/09 91577 $2.179 $40.69 18.673 589 31.543




Q-2 2009
93967
$36.42








06/09/09 94324 $2.699 $26.50 9.819 357 36.358





06/24/09 94639 $2.839 $28.00 9.861 315 31.944





07/01/09 94967 $2.839 $27.10 9.546 328 34.360





07/08/09 95299 $2.719 $27.00 9.931 332 33.431





07/09/09 95451 $2.599 $12.05 4.637 152 32.780





07/09/09 95648 $2.499 $12.76 5.108 197 38.567





07/09/09 95949 $2.739 $22.63 8.263 301 36.427





07/18/09 96294 $2.749 $30.40 11.060 345 31.193





07/25/09 96618 $2.659 $25.00 9.401 324 34.464




Q-3 2009 08/05/09 96956 $2.799 $28.03 10.016 338 33.746





08/10/09 97258 $2.779 $25.82 9.291 302 32.505





08/18/09 97443 $2.799 $17.00 6.074 185 30.458





08/23/09 97734 $2.799 $25.19 9.000 291 32.333





09/04/09 98017 $2.799 $24.50 8.753 283 32.332





09/11/09 98313 $2.799 $27.00 9.646 296 30.686





09/15/09 98567 $2.799 $22.15 7.912 254 32.103








$0.00








10/06/09 99119 $2.699 $27.02 10.011







10/13/09 99409 $2.699 $25.00 9.262 290 31.311





10/26/09 99715 $2.859 $29.01 10.146 306 30.160




Q-4 2009 11/01/09 100026 $2.839 $27.41 9.654 311 32.215





11/09/09 100327 $2.859 $27.01 9.446 301 31.865





11/26/09 100625 $2.859 $28.59 10.000 298 29.800





12/06/09 100900 $2.859 $27.01 9.446 275 29.113





12/18/09 101143 $2.799 $25.60 9.145 243 26.572





12/27/09 101405 $2.819 $26.78 9.500 262 27.579





01/06/10 101676 $2.879 $29.05 10.090 271 26.858





01/15/10 101945 $2.939 $28.00 9.528 269 28.233





01/26/10 102226 $2.839 $26.42 9.305 281 30.199




Q-1 2010 02/02/10 102524 $2.839 $28.65 10.092 298 29.528





02/13/10 102793 $2.839 $26.71 9.407 269 28.596





03/03/10 103067 $2.899 $27.00 9.315 274 29.415





03/19/10 103331 $2.899 $30.00 10.250 264 25.756 <--Shortsville




03/30/10 103544 $2.939 $17.64 6.001 213 35.494 <--Farmington




04/12/10 103813 $2.999 $26.20 8.736 269 30.792 <--Shortsville




04/25/10 104103 $3.019 $28.06 9.293 290 31.206





05/06/10 104399 $3.039 $28.57 9.400 296 31.489




Q-2 2010 05/26/10 104701 $2.939 $29.50 10.037 302 30.089





06/08/10 105024 $2.879 $29.16 10.129 323 31.889





06/21/10 105319 $2.879 $27.35 9.501 295 31.049





06/29/10 105621 $2.879 $27.29 9.464 302 31.910





07/12/10 105910 $2.839 $28.40 10.005 289 28.886





07/25/10 106159 $2.839 $23.50 8.279 249 30.076





07/29/10 106381 $2.839 $19.44 7.023 222 31.610





08/05/10 106697 $2.819 $28.00 9.932 316 31.816





08/10/10 106947 $2.819 $25.00 8.867 250 28.194




Q-3 2010 08/22/10 107249 $2.839 $28.01 9.867 302 30.607





09/01/10 107585 $2.819 $29.26 10.379 336 32.373





09/08/10 107916 $2.799 $28.00 10.004 331 33.087





09/17/10 108206 $2.799 $24.00 8.575 290 33.819





09/22/10 108518 $2.799 $27.99 10.000 312 31.200





09/27/10 108919 $2.799 $29.04 10.376 401 38.647 gas station change




10/03/10 109235 $2.779 $27.00 9.646 316 32.760





10/10/10 109589 $2.859 $29.06 10.166 354 34.822 Long Drives



Q-4 2010 10/29/10 109900 $2.979 $30.08 10.098 311 30.798 Short drives




11/15/10 110201 $3.059 $31.05 10.151 301 29.652





12/15/10 110516 $3.179 $34.00 10.695 315 29.453





12/31/10 110797 $3.239 $29.90 9.231 281 30.441





01/08/11 111139 $3.129 $29.02 9.276 342 36.869 gas station change + Bob used and filled it.




01/27/11 111488 $3.299 $35.15 10.656 349 32.752 gas station change



Q-1 2011 02/07/11 111800 $3.299 $33.70 10.215 312 30.543 gas station change




02/17/11 112123 $3.319 $33.75 10.170 323 31.760





03/04/11 112476 $3.599 $24.98 6.918 353 31.760 Unrecorded amount from bob makes for bad mileage




03/25/11 112786 $3.699 $37.75 10.206 310 30.374 Back to Farmington




04/12/11 113092 $3.899 $20.01 5.131 306
not a full tank



Q-2 2011 04/22/11 113247 $3.959 $39.76 15.337 461 30.058 full tank and made calculations with this.




06/30/11 113539 $3.799 $38.45 10.121 292 28.851





07/10/11 113866 $3.819 $38.51 10.084 327 32.428





07/23/11 114181 $3.819 $40.35 10.566 315 29.813





07/30/11 114477 $3.839 $40.70 10.603 296 27.917 Constant A/C use




08/05/11 114771 $3.859 $38.91 10.084 294 29.155





08/15/11 115085 $3.849 $41.16 10.693 314 29.365




Q-3 2011 08/20/11 115385 $3.819 $37.70 9.873 300 30.386





08/26/11 115682 $3.819 $38.42 10.061 297 29.520





09/03/11 115992 $3.799 $39.59 10.421 310 29.748





09/10/11 116276 $3.799 $36.47 9.601 284 29.580





09/16/11 116513 $3.779 $31.61 8.365 237 28.332





09/24/11 116783 $3.759 $37.91 10.086 270 26.770 WGI weekend




10/03/11 117080 $3.719 $37.81 10.166 297 29.215





10/12/11 117358 $3.679 $37.34 10.149 278 27.392





10/26/11 117647 $3.659 $38.76 10.593 289 27.282





11/06/11 117910 $3.619 $34.96 9.661 263 27.223




Q-4 2011 11/18/11 118191 $3.579 $37.82 10.567 281 26.592





11/27/11 118454 $3.579 $34.58 9.661 263 27.223





12/10/11 118691 $3.499 $33.42 9.550 237 24.817





12/23/11 118952 $3.499 $37.00 10.575 261 24.681





12/31/11 119085 $3.439 $18.00 5.235 133 25.406





01/07/12 119317 $3.499 $28.08 8.026 232 28.906





01/16/12 119571 $3.539 $34.25 9.677 254 26.248





01/25/12 119831 $3.559 $36.85 10.355 260 25.109





02/06/12 120079 $3.679 $35.90 9.757 248 25.418




Q-1 2012 02/17/12 120314 $3.779 $37.55 9.937 235 23.649





03/01/12 120581 $3.899 $40.57 10.405 267 25.661





03/13/12 120857 $3.929 $41.17 10.478 276 26.341





03/18/12 121027 $3.929 $26.30 6.695 170 25.392





03/29/12 121305 $3.999 $43.25 10.815 278 25.705




Q-2 2012 04/09/12 121546 $4.059 $39.02 9.612 241 25.073





04/20/12 121829 $4.079 $42.30 10.370 283 27.290





05/03/12 122100 $3.969 $42.47 10.701 271 25.325





05/16/12 122378 $3.969 $42.92 10.814 278 25.707