Volt_Energy_Cost
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
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 BillsThis Year's Bills (pge.com)Charge @HomeHouseYear-Year Non-CarVolt Stats (voltstats.net)Gas Cost24MPG PremiumVoltVoltVolt
9
DateHouse kWhBill $Bill DaysDateDayskWh$kWhkWhCompareStart MileEnd MileMilesTotal GasGas Used$/gallon+kWh/dayGas $+Electric $Gas $Energy $% Diff$ Diff
10
10/7/10683121.962910/6/1128896219.451687287%79509431.11.14.048.45158.8697.494.45106.14-33%-52.71
11
11/5/1044053.762911/4/112964997.75261388-12%9502,1171,1679.18.04.077.21197.9043.9932.5676.55-61%-121.35
12
12/8/1050161.003312/6/113273285.462195132%2,1172,84172411.92.83.877.69116.8124.4610.8437.15-68%-79.66
13
1/6/1137044.34291/6/123147846.10131347-6%2,8413,28444313.51.63.922.6672.301.766.274.97-93%-67.33
14
2/6/1143053.59302/5/122967380.54268405-6%3,2844,3871,10319.05.53.978.87182.3626.9521.8850.62-72%-131.74
15
3/9/1145356.38323/7/123262676.14265361-20%4,3875,4961,10924.55.54.595.41211.9619.7625.1644.92-79%-167.04
16
4/7/1137145.59294/5/122956762.14213354-5%5,4966,32582927.63.14.496.76155.1316.5513.9230.47-80%-124.65
17
5/8/1130737.65305/6/123058365.102713121%6,3257,31198630.52.94.429.20181.5527.4512.8240.27-78%-141.28
18
6/8/1133741.33326/6/1232781154.2224453759%7,3118,3681,05737.46.94.7013.87206.95112.8932.47145.36-30%-61.59
19
7/8/1154184.86307/4/1230799174.26283515-5%8,3689,5951,22744.67.24.308.59219.7289.4030.86120.26-45%-99.46
20
8/7/1153087.86298/2/1229976232.3826771034%9,59510,58398845.10.53.9915.40164.11144.522.03146.55-11%-17.56
21
9/7/11640112.98329/3/12321,069270.6922484532%10,58312,1991,61668.123.04.2713.39287.54157.7198.08255.79-11%-31.76
22
23
AnnualizedDayskWh$MilesGas Used128i Gas $+Electric $Volt Gas $Energy $% Diff$ Diff
24
Compare MPG243658,8771,5732812.27620512,259682,167.06767.13292.941,064.88-51%-1,102.18
25
1564.231564.23
26
27
28
HouseCarMonthly Last YearExcluding EVWith EV
29
Sep728168Sep683728896
30
Oct1,116429Oct440388649
31
Nov1,629648Nov501513732
32
Dec1,977778Dec370347478
33
Jan2,3821,046Jan430405673
34
Feb2,7431,311Feb453361626
35
Mar3,0971,524Mar371354567
36
Apr3,4091,795Apr307312583
37
May3,9462,039May337537781
38
Jun4,4622,322Jun541515799
39
Jul5,1712,589Jul530710976
40
Aug6,0162,812Aug6408451,069
41
42
43
44
45
46
47
48
49
50
51
52
Before EVWith EV
53
Sep683728
54
Oct1,1231,116
55
Nov1,6241,629
56
Dec1,9941,977
57
Jan2,4242,382
58
Feb2,8772,743
59
Mar3,2483,097
60
Apr3,5553,409
61
May3,8923,946
62
Jun4,4334,462
63
Jul4,9635,171
64
Aug5,6036,016
65
66
67
466.9166667501.3496663
68
69
70
71
72
73
74
75
76
77
78
Before EVWith 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
Loading...
 
 
 
Volt_Dollars_Per_Mile
E1_vs_E9A