Transportation Costs.xlsx

	A	B	C	D	E	F	G	H	K	L	M	N	O	P	Q	R	S	T	U	V	W	AB	AC	AD
1	Year	Tesla Km	Elantra Km	Truck Km	Total km	Truck L/100	Truck Gas $	Elantra Gas $	Truck Math			Elantra Math			Tesla Math				COVID	Start	End	Return trip driving km
2	2013		28152	36484	64636	14.8	7257	3034	Distance to work	108		Distance to work	165		Charge	47.265	kWh/charge		Work from home	43906	44452	Home to CC	22
3	2014		27889	36585	64474	14.7	7443	3006	Yearly work km	14904		Yearly work km	37950		Charge to	1						Home to work	108
4	2015		28546	35855	64401	14.7	6246	3077	Truck Gas Mileage	13.4	L/100km	Gas Mileage	7.5	L/100km	KM/Charge	345						Trish work	115
5	2016		32546	47998	80544	14.2	7191	3508	Gas price	1.4	$/L	Gas price	1.4	$/L	Theoretical	0.137	kWh/km					Trish at work	50
6	2017		30525	47855	78380	13.4	7413	3290	Total work gas	1997.136		Total work gas	2846.25		Electricity Cost	0.103	Dollars/kWh					Keith work	14904
7	2018	4565	25839	47285	77689	13.4	8395	2785	Total work gas $	2795.99		Total work gas $	3984.75		Theor Cost	0.014	Dollars/km					Trish work	37950
8	2019	52465		28565	81030	13.6	4619		$/km truck	0.19		$/km elantra	0.105		Trish work km	37950						Hockey km	11640
9	2020	6855		2750	9605	13.5	379		Theo FE City	14.1		Theo FE City	7.1		Theo Gas equiv	2.1	L/100km					Kids work	6256.8
10	2021	9877		4898	14775	13.4	949		Theo FE HWY	10.6		Theo FE HWY	6.6		Truck ratio	6.4						Misc (visits, etc)	2000
11	2022	51612		18205	69817	13.4	4357								Elantra ratio	3.6						Total	72750.8
12	2023	5668		2101	7769	13.4	396								REAL Truck Ratio	13.2
13	Total	131042	as of Feb 15, 2023												REAL Elantra Ratio	5.2
14
15				Tesla KM deflected	From Truck	From Elantra	$ Saved								Total MWh/yr	7.19
16				2018	570	3995	$461.99								Total CO2							Hockey	7	months
17				2019	19290	33175	$6,361.85								Ontario Grid	0.3	TONS of CO2						50	hockey/month
18				2020	2056	4799	$792.87								US Grid	2.9	TONS of CO2						350	hock/yr
19				2021	2963	6914	$1,142.45								If we instead drove:								30	away
20				2022	9000	2000	$1,743.18								Truck	13	TONS of CO2						320	home
21				2023	1700	3968	$655.58								Car	7	TONS of CO2						120	km away
22						Total	$11,157.92								CO2 Saved/yr								12	km home
23						If no covid	$21,073.06								US								7440	Yearly km
24						Black book value	$39,858.00								Versus ICE Car	4.5	TONS of CO2	Saved				Tourn	4200
25						Purchase cost	$57,282.00								Versus ICE Truck	10.3	TONS of CO2	Saved					11640	Total hockey
26						profit	$3,649.06								Canada
27						Yearly profit	$701.74	<--- I.e. we get paid almost $3500 yearly to drive the tesla (similar to a side income stream)							Versus ICE Car	7.2	TONS of CO2	Saved
28															Versus ICE Truck	12.9	TONS of CO2	Saved
29								Going further: Future costs: Only maintenance and battery replacement, which is less than buying full car.
30															Alternate: using https://calculator.carbonfootprint.com/calculator.aspx?tab=4
31															50k km on:	Tons
32															Silverado 2018	14.4
33															Elantra 2014	8.1
34															Model 3 2018	2.4
35
36
37
38
39
40
41
42
43
44
45	Gas prices	$/L
46
47	42592	101.1
48	42623	100.9
49	42653	105.4
50	42684	101.4
51	42714	104.7
52	42745	112.8
53	42776	107.8
54	42806	107.6
55	42837	116
56	42867	112
57	42898	107.3
58	42928	109.5
59	42959	112.5
60	42989	118.2
61	43020	114.9
62	43050	122.2
63	43081	121
64	43111	124.5
65	43142	123.6
66	43172	126.1
67	43203	133.7
68	43233	137.3
69	43264	134.6
70	43294	135.6
71	43325	133.6
72	43355	129.3
73	43386	124
74	43416	111.7
75	43447	105.5
76	43477	102.4
77	43508	102.1
78	43538	115.8
79	43569	126.7
80	43599	127.7
81	43630	118.9
82	43660	125.3
83	43691	118.5
84	43721	116.7
85	43752	116.9
86	43782	116.4
87	43813	116
88	43843	114.6
89	43874	111
90	43904	86.1
91	43935	79.1
92	43965	91.2
93	43996	99.9
94	44026	104.3
95	44057	103.9
96	44087	101.8
97	44118	100.7
98	44148	99.3
99	44179	103.6
100	44209	110.9