Efficiency Tracking

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		MINI CHARGING HISTORY
2		Battery:	28.9 kWh					Best: 5.4 mi/kWh	155 mi		Insert enough rows above row 6 then paste data from MINI app export into L6 (paste as plain text)
3		Initial ODO reading:		14 mi				Worst: 2.7 mi/kWh	78 mi
4	Totals	4,209 mi			155 kWh	453 mi	416%	Avg: 3.6 mi/kWh	105 mi		Plug-in date	Total mileage	SOC when plugged in	Unplug date	State of charge when unplugged	Charging location	Location address	Cost(*)	Energy charged(*)	Energy rate 1	Energy rate 2	Savings(*)	Charged time	Precondition for departure
5	Plug-in date	Mileage	Plugged in	Unplugged	Energy	Trip Distance	% Used	Efficiency	Range	Notes	Plug-in date	Total mileage	SOC when plugged in	Unplug date	State of charge when unplugged	Charging location	Location address	Cost(*)	Energy charged(*)	Energy rate 1	Energy rate 2	Savings(*)	Charged time	Precondition for departure

6
7	11/29/2021 04:17 PM	4,223 mi	59%	85%	9 kWh	35 mi	31%	3.9 mi/kWh	113 mi		11/29/2021 4:17 PM	4,223 mi	0.59	11/29/2021 6:39 PM	0.85	Charger location	Address	-- USD	~ 9 kWh	--	--	--	2h 22min	On
8	11/27/2021 07:15 AM	4,188 mi	53%	90%	13 kWh	52 mi	47%	3.8 mi/kWh	111 mi		11/27/2021 7:15 AM	4,188 mi	0.53	11/27/2021 10:44 AM	0.9	Charger location	Address	-- USD	~ 13 kWh	--	--	--	3h 28min	On
9	11/25/2021 09:45 PM	4,136 mi	27%	100%	24 kWh	44 mi	45%	3.4 mi/kWh	98 mi		11/25/2021 9:45 PM	4,136 mi	0.27	11/26/2021 6:50 AM	1	Charger location	Address	-- USD	~ 24 kWh	0.10 USD/kWh (All day)	--	--	6h 44min	Off
10	11/25/2021 10:06 AM	4,092 mi	69%	72%	2 kWh	31 mi	31%	3.5 mi/kWh	100 mi		11/25/2021 10:06 AM	4,092 mi	0.69	11/25/2021 10:22 AM	0.72	Charger location	Address	-- USD	< 2 kWh	--	--	--	16 min	On
11	11/23/2021 12:11 PM	4,061 mi	41%	100%	19 kWh	66 mi	59%	3.9 mi/kWh	112 mi		11/23/2021 12:11 PM	4,061 mi	0.41	11/24/2021 6:15 AM	1	Charger location	Address	-- USD	~ 19 kWh	--	--	--	5h 27min	On
12	11/21/2021 08:29 PM	3,995 mi	36%	100%	22 kWh	42 mi	42%	3.5 mi/kWh	100 mi		11/21/2021 8:29 PM	3,995 mi	0.36	11/22/2021 6:51 AM	1	Charger location	Address	-- USD	~ 22 kWh	--	--	--	6h 10min	On
13	11/21/2021 07:03 AM	3,953 mi	48%	78%	11 kWh	34 mi	35%	3.4 mi/kWh	97 mi		11/21/2021 7:03 AM	3,953 mi	0.48	11/21/2021 9:48 AM	0.78	Charger location	Address	-- USD	~ 11 kWh	--	--	--	2h 45min	Off
14	11/20/2021 10:12 AM	3,919 mi	58%	83%	9 kWh	38 mi	42%	3.1 mi/kWh	90 mi		11/20/2021 10:12 AM	3,919 mi	0.58	11/20/2021 12:28 PM	0.83	Charger location	Address	-- USD	~ 9 kWh	0.10 USD/kWh (All day)	--	--	2h 15min	Off
15	11/19/2021 12:34 PM	3,881 mi	65%	100%	11 kWh	18 mi	23%	2.7 mi/kWh	78 mi		11/19/2021 12:34 PM	3,881 mi	0.65	11/19/2021 6:23 PM	1	Charger location	Address	-- USD	~ 11 kWh	--	--	--	3h 29min	Off
16	11/13/2021 06:16 PM	3,863 mi	44%	88%	14 kWh	3 mi	3%	3.5 mi/kWh	100 mi		11/13/2021 6:16 PM	3,863 mi	0.44	11/13/2021 9:56 PM	0.88	Charger location	Address	~ 0.64 USD	~ 14 kWh	--	--	--	3h 40min	On
17	11/13/2021 04:21 PM	3,860 mi	29%	47%	6 kWh	90 mi	58%	5.4 mi/kWh	155 mi		11/13/2021 4:21 PM	3,860 mi	0.29	11/13/2021 5:51 PM	0.47	Charger location	Address	~ 2.60 USD	~ 6 kWh	--	--	--	1h 30min	On
18	11/10/2021 04:07 PM	3,770 mi	42%	87%	15 kWh					<- empty for first data point	11/10/2021 4:07 PM	3,770 mi	0.42	11/10/2021 8:04 PM	0.87	Charger location	Address	~ 1.45 USD	~ 15 kWh	--	--	--	3h 57min	On
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