Tesla - Cost to home charge by provider v3

	A	B	C	D	E	F	H	I	K
4	Model 3 variant	Starting battery %	Finishing battery %	Charger type	Hours needed to charge				Made by https://www.teslaev.co.uk
5	SR+ (Aeros)	50	90	Wall box	3.32
6									I've now built this calculator into my web site, which doesn't need to be desktop based, or require the Google Sheets app https://www.teslaev.co.uk/tesla-cost-to-charge-calculator/
7		Energy supplier tariff details					Example total household costs
8		Special rate hours	Special rate	Standard rate	Total charge cost	Cost Per Mile	Avg UK per day cost (9 kWh)	Avg UK cost, plus charging
9	Bulb - Vari Fair (E7)	7	£0.089	£0.180	£2.07	£0.02	£1.83	£3.91
10	Octopus Go	4	£0.050	£0.140	£1.16	£0.01	£1.51	£2.67
11	Octopus Go Faster*	5	£0.055	£0.140	£1.28	£0.01	£1.51	£2.79
12	OVO Energy - EV Everywhere (E7)	7	£0.091	£0.176	£2.11	£0.02	£1.80	£3.91
13	EDF - Go Electric 35	5	£0.045	£0.185	£1.04	£0.01	£1.98	£3.02
14	EDF - Go Electric 98	10	£0.090	£0.206	£2.09	£0.02	£2.14	£4.23
15	British Gas - Electric Drivers	5	£0.047	£0.200	£1.09	£0.01	£2.05	£3.14
16
17	If you decide to move to Octopus, use this referral link to share £100 credit with me (£50 each):				https://share.octopus.energy/open-dodo-178
18
19	How to use this spreadsheet
20	Choose your Model 3 from the drop down under the 'Model 3 variant' header
21	Type in the starting battery % under the 'Starting battery % header
22	Choose your finishing battery % from dropdown under the 'Finishing battery %' header
23	Choose your charger type from the dropdown under the 'Charger type' header
24
25
26	* EDF Go Electric 98 also has the special rate all weekend, 10 hours is based on weekday usage, Octopus Go Faster is currently an invite only Beta
27
28	Assumptions are based on the cost of a full charge (finishing battery % + 6.5% charge loss) The total cost to charge assumes you took full advantage of special rate hours Avg UK Cost = 9kWh (avg UK household useage is = 8-10 kWh) * standard rate + standing charge - this will differ for your house size / usage Range figures (to calculate cost per mile) taken from https://teslike.com/range/ Assumes your wall box gets 7 kWh and the Tesla UMC achieves the maximum 2.3 kWh
29
30
31
32
33	This does not constitue as financial advice, you must consider all aspects of your energy use, not just how much it costs to charge your Tesla. Don't be tempted to sacrifice your day rate for the cheapest possible overnight charging Tariff details accurate as of 2/12/2020. Prices based on SG postcode
34
35
36
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149