Volt_Energy_Cost

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Volt 12-Month Energy Cost Calculates $/mile by comparing electricity consumption from current year with that from the prior year. Also calculates a percentage savings relative to a conventional car getting 24 MPG. This worksheet can not account for differences in household electric usage between years (typically because of weather / air conditioning). Any difference is attributed to the car. Winter values should be more accurate than summer, because household electric usage is more constant. Volt data from voltstats.net ... gas prices from http://energyalmanac.ca.gov/gasoline/retail_gasoline_prices.html ... Charge @Home data from Chargepoint.net 240V charger in garage.
2
3
4
5
6
7
8	Last Year's Bills				This Year's Bills (pge.com)				Charge @Home	House	Year-Year Non-Car	Volt Stats (voltstats.net)					Gas Cost		24MPG Premium	Volt	Volt	Volt
9	Date	House kWh	Bill $	Bill Days	Date	Days	kWh	$	kWh	kWh	Compare	Start Mile	End Mile	Miles	Total Gas	Gas Used	$/gallon	+kWh/day	Gas $	+Electric $	Gas $	Energy $	% Diff	$ Diff
10	10/7/10	683	121.96	29	10/6/11	28	896	219.45	168	728	7%	7	950	943	1.1	1.1	4.04	8.45	158.86	97.49	4.45	106.14	-33%	-52.71
11	11/5/10	440	53.76	29	11/4/11	29	649	97.75	261	388	-12%	950	2,117	1,167	9.1	8.0	4.07	7.21	197.90	43.99	32.56	76.55	-61%	-121.35
12	12/8/10	501	61.00	33	12/6/11	32	732	85.46	219	513	2%	2,117	2,841	724	11.9	2.8	3.87	7.69	116.81	24.46	10.84	37.15	-68%	-79.66
13	1/6/11	370	44.34	29	1/6/12	31	478	46.10	131	347	-6%	2,841	3,284	443	13.5	1.6	3.92	2.66	72.30	1.76	6.27	4.97	-93%	-67.33
14	2/6/11	430	53.59	30	2/5/12	29	673	80.54	268	405	-6%	3,284	4,387	1,103	19.0	5.5	3.97	8.87	182.36	26.95	21.88	50.62	-72%	-131.74
15	3/9/11	453	56.38	32	3/7/12	32	626	76.14	265	361	-20%	4,387	5,496	1,109	24.5	5.5	4.59	5.41	211.96	19.76	25.16	44.92	-79%	-167.04
16	4/7/11	371	45.59	29	4/5/12	29	567	62.14	213	354	-5%	5,496	6,325	829	27.6	3.1	4.49	6.76	155.13	16.55	13.92	30.47	-80%	-124.65
17	5/8/11	307	37.65	30	5/6/12	30	583	65.10	271	312	1%	6,325	7,311	986	30.5	2.9	4.42	9.20	181.55	27.45	12.82	40.27	-78%	-141.28
18	6/8/11	337	41.33	32	6/6/12	32	781	154.22	244	537	59%	7,311	8,368	1,057	37.4	6.9	4.70	13.87	206.95	112.89	32.47	145.36	-30%	-61.59
19	7/8/11	541	84.86	30	7/4/12	30	799	174.26	283	515	-5%	8,368	9,595	1,227	44.6	7.2	4.30	8.59	219.72	89.40	30.86	120.26	-45%	-99.46
20	8/7/11	530	87.86	29	8/2/12	29	976	232.38	267	710	34%	9,595	10,583	988	45.1	0.5	3.99	15.40	164.11	144.52	2.03	146.55	-11%	-17.56
21	9/7/11	640	112.98	32	9/3/12	32	1,069	270.69	224	845	32%	10,583	12,199	1,616	68.1	23.0	4.27	13.39	287.54	157.71	98.08	255.79	-11%	-31.76
22
23					Annualized	Days	kWh	$						Miles		Gas Used			128i Gas $	+Electric $	Volt Gas $	Energy $	% Diff	$ Diff
24	Compare MPG	24				365	8,877	1,573	2812.276205					12,259		68			2,167.06	767.13	292.94	1,064.88	-51%	-1,102.18
25							1564.23	1564.23
26
27
28						House	Car											Monthly	Last Year	Excluding EV	With EV
29					Sep	728	168											Sep	683	728	896
30					Oct	1,116	429											Oct	440	388	649
31					Nov	1,629	648											Nov	501	513	732
32					Dec	1,977	778											Dec	370	347	478
33					Jan	2,382	1,046											Jan	430	405	673
34					Feb	2,743	1,311											Feb	453	361	626
35					Mar	3,097	1,524											Mar	371	354	567
36					Apr	3,409	1,795											Apr	307	312	583
37					May	3,946	2,039											May	337	537	781
38					Jun	4,462	2,322											Jun	541	515	799
39					Jul	5,171	2,589											Jul	530	710	976
40					Aug	6,016	2,812											Aug	640	845	1,069
41
42
43
44
45
46
47
48
49
50
51
52						Before EV	With EV
53					Sep	683	728
54					Oct	1,123	1,116
55					Nov	1,624	1,629
56					Dec	1,994	1,977
57					Jan	2,424	2,382
58					Feb	2,877	2,743
59					Mar	3,248	3,097
60					Apr	3,555	3,409
61					May	3,892	3,946
62					Jun	4,433	4,462
63					Jul	4,963	5,171
64					Aug	5,603	6,016
65
66
67						466.9166667	501.3496663
68
69
70
71
72
73
74
75
76
77
78						Before EV	With EV
79					Sep	$122	$219
80					Oct	$176	$317
81					Nov	$237	$403
82					Dec	$281	$449
83					Jan	$335	$529
84					Feb	$391	$605
85					Mar	$437	$668
86					Apr	$474	$733
87					May	$516	$887
88					Jun	$600	$1,061
89					Jul	$688	$1,294
90					Aug	$801	$1,564
91
92
93
94
95
96
97
98
99
100