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,409.10	1,389	30.56	$4.30	$1.84	38.65	23.65	44,444

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.22		$15,219.04

Total of “Tires”		Total of “Misc”		Cost per Mile With Cost of Vehicle
$387.70		$4,557.40		$0.34

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	$172.63				25.87
2012-2
2012-3
2012-4		$172.63	1,229	$0.140		25.87

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					$387.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

Sheet 5: Misc.

Date	Mileage	Cost	Job	Total Costs
	75459			$4,557.40
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

Sheet 6: Gas Mileage Data

Total cash	Total gallons	Average MPG	Highest price	Lowest price	Best Gas mileage	Worst Gas Mileage	Total Miles
$4,409.10	1389.34	30.562	$4.30	$1.84	38.65	23.65	44444

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
Q-1 2012	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
	02/17/12	120314	$3.779	$37.55	9.937	235	23.649