ev-efficiency-excel.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Cumulative Total KG of CO2 Emissions in Use and Production of Vehicle (Tesla Methodology)
2	Year	Chevy Suburban	Average 25MPG Car	Hummer EV	Ford Escape Hybrid	Prius	VW ID.4	Ford Mach E	Nissan Leaf	Prius Prime	Tesla Model 3	Wuling Mini	E-bike
3	kWh/mi			0.72			0.35	0.34	0.30	0.25	0.24	0.15	0.02
4	Gas vehicle kgCO2/mi	0.59	0.40		0.24	0.18				0.19
5	Weight (kg)	2,644.10	1,650.97	4,114.60	1,604.44	1,354.50	2,069.79	1,994.88	1,596.26	1,527.71	1,646.66	705.52	27.24
6	Battery size (kWh)	0.00	0.00	246.80	1.40	1.30	82.00	68.00	40.00	8.80	54.00	13.80	0.67

7	Vehicle production emissions (kg	14,542.5	9,080.3	22,095.4	8,824.4	7,449.8	11,114.8	10,712.5	8,571.9	8,303.1	8,842.6	3,788.6	146.3
8	Battery production emissions (kg	0.00	0.00	7,404.00	42.00	39.00	2,460.00	2,040.00	1,200.00	264.00	1,620.00	414.00	80.64
9	Total production emissions (kg	14,543	9,080	29,499	8,866	7,489	13,575	12,752	9,772	8,567	10,463	4,203	227
10	Year	Cumulative Lifecycle Emissions												Estimated US gCO2/kWh (AOE2021)	Charging loss adjusted gCO2/kWh
11	2023	21,480	13,798	33,076	11,743	9,595	15,314	14,442	11,262	9,979	11,655	4,948	338	367	422
12	2024	28,418	18,516	36,398	14,620	11,701	16,928	16,010	12,646	11,336	12,762	5,640	442	341	392
13	2025	35,356	23,234	39,572	17,496	13,807	18,471	17,509	13,969	12,663	13,820	6,301	540	326	375
14	2026	42,294	27,951	42,798	20,373	15,913	20,039	19,032	15,313	14,000	14,895	6,973	641	331	381
15	2027	49,232	32,669	45,963	23,250	18,019	21,578	20,527	16,632	15,325	15,950	7,632	739	325	374
16	2028	56,170	37,387	49,106	26,127	20,126	23,106	22,011	17,942	16,645	16,998	8,287	837	323	371
17	2029	63,108	42,105	52,235	29,003	22,232	24,627	23,489	19,245	17,961	18,041	8,939	934	321	369
18	2030	70,046	46,822	55,308	31,880	24,338	26,121	24,940	20,526	19,267	19,065	9,579	1,030	316	363
19	2031	76,984	51,540	58,342	34,757	26,444	27,595	26,373	21,790	20,563	20,077	10,211	1,124	312	358
20	2032	83,921	56,258	61,337	37,633	28,550	29,051	27,787	23,038	21,852	21,075	10,835	1,217	308	354
21	2033	90,859	60,976	64,314	40,510	30,656	30,499	29,193	24,278	23,137	22,068	11,456	1,310	306	351
22	2034	97,797	65,694	67,275	43,387	32,762	31,938	30,591	25,512	24,418	23,054	12,072	1,402	304	349
23	2035	104,735	70,411	70,174	46,263	34,869	33,347	31,960	26,720	25,686	24,021	12,676	1,492	298	342
24	2036	111,673	75,129	73,055	49,140	36,975	34,748	33,321	27,920	26,951	24,981	13,277	1,582	296	340
25	2037	118,611	79,847	75,912	52,017	39,081	36,136	34,670	29,111	28,210	25,933	13,872	1,671	293	337
26	2038	125,549	84,565	78,735	54,893	41,187	37,509	36,003	30,287	29,462	26,874	14,460	1,759	290	333
27	2039	132,487	89,282	81,545	57,770	43,293	38,875	37,330	31,458	30,712	27,811	15,046	1,846	289	332
28
29	Total use emissions	117,944	80,202	52,046	48,904	35,804	25,300	24,577	21,686	22,145	17,349	10,843	1,619
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100