Calculated Vs MFD

	A	B	C	D	E	F	G	H
1	{rtf1ansiansicpg1252cocoartf949cocoasubrtf540
2
3	Date	Start Mileage	End Mileage	Gallons at the pump	Calculaated MPG	$Gallon	MFD	Calculated Gallons by MFD
4	9142005	18514	19196	10.626	64.18	$2.61	69.2	9.86
5	9222005	19196	19834	8.46	75.41	$2.68	70.9	9.00
6	9282005	19834	20350	7.86	65.84	$2.78	65.2	7.91
7	1032005	20350	20933	9.895	58.9	$2.88	64	9.11
8	10112005	20933	21593	9.783	67.46	$2.94	68.8	9.59
9	10192005	21593	22243	9.3	69.89	$2.7	67.7	9.60
10	10262005	22243	22882	9.223	69.28	$2.52	71.4	8.95
11	1122005	22882	23504	8.773	70.9	$2.62	64.3	9.67
12	11122005	23504	24094	9.2	64.13	$2.39	65.8	8.97
13	11192005	24094	24692	9.574	62.46	$2.32	63.7	9.39
14	11282005	24692	25225	9.59	55.57	$2.2	56	9.52
15	1262005	24225	25821	9.526	62.57	$2.16	61.5	25.95
16	12152005	25821	26378	9.833	56.64	$2.2	55.1	10.11
17	12262005	26378	26868	9.55	51.31	$2.14	54	9.07
18	1102006	26868	27404	9.23	58.07	$2.26	57.7	9.29
19	1172006	27404	27928	9.276	56.49	$2.25	58.8	8.91
20	1262006	27928	28366	8.802	49.76	$2.39	51	8.59
21	232006	28366	28908	8.81	61.52	$2.38	60.4	8.97
22	2122006	28908	29443	8.929	59.91	$2.22	58.7	9.11
23	2202006	29443	29971	9.529	55.4	$2.25	58.7	8.99
24	362006	29971	30497	9.038	58.2	$2.4	58.1	9.05
25	3162006	30497	31007	9.059	56.3	$2.53	62	8.23
26	3182006	31007	31636	9.686	64.94	$2.6	61.8	10.18
27	3312006	31636	32189	8.648	63.95	$2.64	62.7	8.82
28	4122006	32189	32710	9.585	54.4	$2.8	61.6	8.46
29	4222006	32710	33282	9.398	60.86	$2.82	62.4	9.17
30	542006	33282	33885	8.939	67.4	$2.84	62.9	9.59
31	5152006	33885	34353	8.474	55.22	$2.9	60.1	7.79
32	5252006	34353	34906	9.758	56.67	$2.83	64	8.64
33	6112006	34906	35480	9.404	61.03	$2.97	61.2	9.38
34	6232006	35480	36054	9.327	61.54	$2.98	62	9.26
35	792006	36054	36517	8.175	56.6	$2.98	62.3	7.43
36	sums:			295.26				306.56