EJeep_LiFePO4

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	kWh meter	Odometer	Miles driven	kWh used	Corrected	wH/mi	mpge	avg temp	Notes	188,814.9	Gas miles	189,296.8	<= LiFEPO4 start

2	4/21/2014	59.13	189,310.5	13.7	6.44	6.13	447	75	55		481.9	AGM miles	3,548.4	Tot electric miles
3	4/22/2014	65.83	189,324.5	14.0	6.70	6.39	456	74	57		3,066.5	LiFePO4 miles	86.42%	LiFePO4 pct
4	4/23/2014	78.25	189,354.3	29.8	12.42	12.11	406	83	58		0.415	Slope
5	4/24/2014	88.96	189,377.4	23.1	10.71	10.40	450	75	51		0.276	Intercept	2712	<= Est. annual mi
6	4/25/2014	93.21	189,387.1	9.7	4.25	3.94	406	83	55				842	<= Est annual kWh
7	4/26/2014	97.17	189,397.1	10.0	3.96	3.65	365	92	57		435.4	Avg Wh/mi
8	4/27/2014	104.60	189,413.7	16.6	7.43	7.12	429	79	50		77.4	Avg mpge	52.69	<= kWh meter start
9	4/28/2014	111.06	189,426.2	12.5	6.46	6.15	492	69	47	New PS pump	15.0	Avg dist	952.42	<= LiFePO4 tot kWh
10	4/29/2014	129.81	189,466.5	40.3	18.95	18.64	462	73	45	Cell died! Adj. by 96/95	$3.50	Gas $/gal	2.31	<= Daily avg kWh
11	5/1/2014	135.10	189,477.8	11.3	5.29	4.67	413	82	52		19	Orig MPG
12	5/2/2014	139.33	189,488.5	10.7	4.23	3.92	366	92	52		$0.08	Elec $/kWh	41	<= Assumed parasitic milliamps
13	5/17/2014	145.80	189,494.2	5.7	6.47	1.79	315	107	54	Two weeks idle	$1,007.19	Annual gas	0.984	<= Assumed Ah lost, per day
14	5/19/2014	153.21	189,509.8	15.6	7.41	6.79	435	77	66	1 day idle	$63.33	Annual elec	311.7312	<= Assumed Wh lost, per day
15	5/20/2014	159.72	189,523.6	13.8	6.51	6.20	449	75	64		$943.86	Annual savings	0.98	<= Ah lost, per day
16	5/21/2014	168.33	189,544.4	20.8	8.61	8.30	399	84	64		7.06	Average kWh	12.92	<= Static watts
17	5/26/2014	169.88	189,544.4		1.55					5 days, recharge			40.77	<= Static milliamps
18	5/27/2014	174.55	189,554.3	9.9	4.67	4.36	440	77	69
19	5/28/2014	178.82	189,564.0	9.7	4.27	3.96	408	83	71
20	5/29/2014	185.47	189,579.6	15.6	6.65	6.34	406	83	70
21	5/30/2014	191.89	189,593.0	13.4	6.42	6.11	456	74	64
22	6/2/2014	201.20	189,613.0	20.0	9.31	8.37	419	80	66	2 days idle
23	6/3/2014	211.62	189,638.0	25.0	10.42	10.11	404	83	72
24	6/4/2014	226.38	189,673.7	35.7	14.76	14.45	405	83	67
25	6/5/2014	230.38	189,682.6	8.9	4.00	3.69	414	81	66
26	6/6/2014	233.08	189,687.5	4.9	2.70	2.39	487	69	67
27	6/7/2014	236.76	189,694.9	7.4	3.68	3.37	455	74	56
28	6/8/2014	242.63	189,708.0	13.1	5.87	5.56	424	79	56	Interpolated dist
29	6/9/2014	248.89	189,720.4	12.4	6.26	5.95	480	70	59
30	6/10/2014	256.74	189,738.7	18.3	7.85	7.54	412	82	59
31	6/11/2014	270.53	189,770.7	32.0	13.79	13.48	421	80	66
32	6/12/2014	277.37	189,785.4	14.7	6.84	6.53	444	76	60
33	6/13/2014	283.77	189,799.3	13.9	6.40	6.09	438	77	70
34	6/16/2014	291.19	189,815.2	15.9	7.42	6.48	408	83	70	2 days idle
35	6/17/2014	299.04	189,832.9	17.7	7.85	7.54	426	79	71
36	6/18/2014	303.60	189,842.6	9.7	4.56	4.25	438	77	62
37	6/19/2014	309.02	189,854.8	12.2	5.42	5.11	419	80	64
38	6/23/2014	313.57	189,863.5	8.7	4.55	3.30	380	89	66	4 days idle
39	6/24/2014	322.87	189,885.7	22.2	9.30	8.99	405	83	64
40	6/25/2014	331.79	189,906.8	21.1	8.92	8.61	408	83	68
41	6/26/2014	339.65	189,923.6	16.8	7.86	7.55	449	75	73	<= Note, different weather station
42	6/30/2014	346.73	189,937.8	14.2	7.08	5.83	411	82	75	4 days idle
43	7/1/2014	361.16	189,974.2	36.4	14.43	14.12	388	87	66
44	7/2/2014	363.61	189,979.0	4.8	2.45	2.14	445	76	67
45	7/3/2014	371.73	189,997.4	18.4	8.12	7.81	424	79	70
46	7/7/2014	379.63	190,013.0	15.6	7.90	6.65	426	79	78	4 days idle
47	7/8/2014	386.98	190,030.9	17.9	7.35	7.04	393	86	71
48	7/9/2014	392.86	190,043.5	12.6	5.88	5.57	442	76	71
49	7/10/2014	398.10	190,054.0	10.5	5.24	4.93	469	72	77
50	7/11/2014	402.86	190,063.9	9.9	4.76	4.45	449	75	72
51	7/15/2014	411.74	190,081.9	18.0	8.88	7.63	424	79	65	4 days idle
52	7/16/2014	416.65	190,092.2	10.3	4.91	4.60	446	75	63
53	7/17/2014	421.59	190,102.2	10.0	4.94	4.63	463	73	66
54	7/18/2014	425.97	190,112.4	10.2	4.38	4.07	399	84	70
55	7/20/2014	429.93	190,121.8	9.4	3.96	3.34	355	95	77	2 days idle
56	7/21/2014	441.58	190,147.8	26.0	11.65	11.34	436	77	76
57	7/22/2014	447.97	190,161.8	14.0	6.39	6.08	434	78	77
58	7/23/2014	453.24	190,172.2	10.4	5.27	4.96	477	71	75
59	7/24/2014	465.01	190,200.9	28.7	11.77	11.46	399	84	77
60	7/25/2014	475.72	190,226.0	25.1	10.71	10.40	414	81	74
61	7/26/2014	479.74	190,234.7	8.7	4.02	3.71	426	79	70
62	7/28/2014	486.62	190,250.6	15.9	6.88	6.26	393	86	73	1 day idle
63	7/29/2014	493.35	190,265.1	14.5	6.73	6.42	443	76	67
64	7/31/2014	502.52	190,284.7	19.6	9.17	8.55	436	77	68	2 days idle
65	8/4/2014	509.09	190,297.0	12.3	6.57	5.32	433	78	71	3 days idle, 1000 miles
66	8/5/2014	514.31	190,307.8	10.8	5.22	4.91	454	74	73
67	8/6/2014	526.13	190,335.6	27.8	11.82	11.51	414	81	72
68	8/7/2014	532.40	190,349.0	13.4	6.27	5.96	445	76	71
69	8/11/2014	544.39	190,376.3	27.3	11.99	10.74	394	86	69	4 days idle
70	8/12/2014	554.61	190,400.7	24.4	10.22	9.91	406	83	70
71	8/14/2014	564.44	190,423.6	22.9	9.83	9.21	402	84	76
72	8/15/2014	574.32	190,447.6	24.0	9.88	9.57	399	85	73
73	8/16/2014	577.28	190,454.8	7.2	2.96	2.65	368	92	73
74	8/17/2014	588.63	190,482.1	27.3	11.35	11.04	404	83	74
75	8/18/2014	597.24	190,501.9	19.8	8.61	8.30	419	80	73
76	8/19/2014	602.23	190,512.6	10.7	4.99	4.68	437	77	70
77	8/20/2014	606.61	190,522.4	9.8	4.38	4.07	415	81	74
78	8/22/2014	612.40	190,533.6	11.2	5.79	5.17	461	73	67	2 days idle
79	8/26/2014	622.82	190,555.4	21.8	10.42	9.17	421	80	66	4 days idle
80	8/27/2014	628.55	190,568.7	13.3	5.73	5.42	407	83	67
81	8/28/2014	642.57	190,600.5	31.8	14.02	13.71	431	78	61
82	9/2/2014	650.95	190,617.0	16.5	8.38	6.82	413	82	64	5 days idle
83	9/3/2014	656.08	190,627.6	10.6	5.13	4.82	455	74	71
84	9/5/2014	668.19	190,651.0	23.4	12.11	11.49	491	69	54	2 days idle
85	9/8/2014	673.44	190,660.9	9.9	5.25	4.31	436	77	66	3 days idle
86	9/9/2014	682.28	190,679.8	18.9	8.84	8.53	451	75	66
87	9/10/2014	687.15	190,689.6	9.8	4.87	4.56	465	72	61
88	9/15/2014	695.92	190,705.1	15.5	8.77	7.21	465	72	57	5 days idle
89	9/16/2014	703.58	190,721.6	16.5	7.66	7.35	445	76
90	9/18/2014	708.70	190,731.6	10.0	5.12	4.50	450	75		2 days idle
91	9/19/2014	715.38	190,745.5	13.9	6.68	6.37	458	74
92	9/23/2014	722.78	190,759.6	14.1	7.40	6.15	436	77		4 days idle
93	9/24/2014	728.50	190,771.8	12.2	5.72	5.41	443	76
94	9/25/2014	735.17	190,787.3	15.5	6.67	6.36	410	82
95	9/26/2014	739.58	190,797.0	9.7	4.41	4.10	423	80
96	9/29/2014	747.37	190,811.5	14.5	7.79	6.85	473	71		3 days idle
97	10/2/2014	754.42	190,825.4	13.9	7.05	6.11	440	77
98	10/3/2014	760.76	190,836.4	11.0	6.34	6.03	548	61
99	10/8/2014	766.75	190,846.4	10.0	5.99	4.43	443	76
100	10/15/2014	773.17	190,856.3	9.9	6.42	4.24	428	79