EV Charge Calculator V3.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	EV Charge Time & Cost Calculator
2
3	Vehicle	Charge Rate (kW)	Starting SOC (%)	Target SOC (%)	Usable Battery Capacity (kWh)	Energy Needed (kWh)*	Cost per kWh	Total Cost	Cost with Tax	Minutes	Hours	Days
4	F-150 Lightning Platinum	1.2 kW	73%	90%	131 kWh	26.724	$0.039	$1.04	$1.18	1,336 minutes	22.27 hours	0.93 days
5	Mustang Mach-E Premium Extended Range	1.2 kW	82%	95%	91 kWh	14.196	$1.039	$14.75	$16.67	710 minutes	11.83 hours	0.49 days
6
7
8	Drop down values
9	Manually Adjustable values
10	Calculated values
11
12	Tax rate	1.13
13	*Loss Rate (efficiency)	1.20
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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