EV Charging Costs

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Total	Miles:	24,578	Cost:	£5,150.09		CPM:	£0.21	kWh:	11312	m/kWh:	2.17				Starting Mileage:	72148
2	Date	Who	Location	Cost	kWh	Rate	Arrival Battery %	Battery % Charged To	Mileage	Miles	% Added	kW per %	% used	kW used	m/kWh

3	13/02/2021	Pod Point	Whitfield, Lidl	£8.95	38.9	£0.23	57	90	72217	69	33	1.178787879	#VALUE!	#VALUE!	N/A
4	21/02/2021	Pod Point	Whitfield, Lidl	£8.36	36.4	£0.23	59	90	72282	65	31	1.174193548	31	36.4	1.79
5	08/03/2021	Pod Point	Whitfield, Lidl	£10.35	45	£0.23	52	90	72361	79	38	1.184210526	38	45	1.76
6	17/03/2021	Tesla	Maidstone	£7.13	31	£0.23	64	90	72417	56	26	1.192307692	26	31	1.81
7	27/03/2021	Electric Highway	Folkestone Services	£7.95	26.5	£0.30	68	90	72464	47	22	1.204545455	22	26.5	1.77
8	03/04/2021	Ionity	Folkestone Services	£25.04	36	£0.70	60	90	72527	63	30	1.2	30	36	1.75
9	04/04/2021	Electric Highway	Folkestone Services	£10.02	33.4	£0.30	62	90	72587	60	28	1.192857143	28	33.4	1.80
10	05/04/2021	Pod Point	Whitfield, Lidl	£11.42	45.7	£0.25	52	90	72663	76	38	1.202631579	38	45.7	1.66
11	10/04/2021	Tesla	Maidstone	£5.98	26	£0.23	70	90	72709	46	20	1.318652174	20	26	1.77
12	16/04/2021	Pod Point	Whitfield, Lidl	£1.38	5.52	£0.25	70	75	72755	46	5	1.170209905	20	23.07314857	1.99
13	17/04/2021	Pod Point	Tenterden, Tesco	£0.00	8.7	£0.00	60	70	72791	36	10	0.8340702692	15	12.87035135	2.80
14	18/04/2021	Pod Point	Whitfield, Lidl	£12.85	51.39	£0.25	49	90	72839	48	41	1.266563173	21	26.05873653	1.84
15	24/04/2021	Gridserve	Braintree	£12.55	52	£0.24	39	90	72958	119	51	1.019462185	51	52	2.29
16	24/04/2021	Tesla	Maidstone	£10.81	47	£0.23	32	90	73093	135	58	0.8122296296	58	47	2.87
17	25/04/2021	Electric Highway	Folkestone Services	£5.07	16.9	£0.30	67	80	73147	54	13	1.285546136	23	29.75546136	1.81
18	25/04/2021	Tesla	Maidstone	£9.66	42	£0.23	29	80	73265	118	51	0.8303898305	51	42	2.81
19	1/5/2021	InstaVolt	Folkestone	£8.34	23.83	£0.35	53	60	73329	64	7	3.206193195	27	87.9538639	0.73
20	3/5/2021	Pod Point	Whitfield, Lidl	£2.88	11.52	£0.25	30	37	73399	70	7	1.644707178	30	49.3482651	1.42
21	3/5/2021	Pod Point	Whitfield, Lidl	£10.51	42.03	£0.25	28	80	73421	22	52	0.8016415275	9	7.559414318	2.91
22	8/5/2021	Tesla	Maidstone	£10.35	45	£0.23	40	90	73496	75	50	0.9	40	36	2.08
23	23/5/2021	InstaVolt	Folkestone	£8.04	22.97	£0.35	23	50	73601	105	27	0.8508888889	67	57.00955556	1.84
24	26/05/2021	Pod Point	Whitfield, Lidl	£13.67	54.68	£0.25	26	95	73638	37	69	0.7924637681	24	19.01913043	1.95
25	28/5/2021	Tesla	Wokingham	£2.40	8	£0.30	36	48	73760	122	12	0.6666666667	59	39.33333333	3.10
26	28/5/2021	Electric Highway	Reading Services	£1.71	5.7	£0.30	45	52	73767	7	7	0.8142857143	3	2.442857143	2.87
27	28/5/2021	Tesla	Membury Services	£9.60	30	£0.32	40	80	73793	26	40	0.75	12	9	2.89
28	28/5/2021	Revive	Bath	£6.41	19.71	£0.33	61	85	73841	48	24	0.82125	19	15.60375	3.08
29	29/5/2021	Pod Point	Stow-on-the-Wold, Tesco	£0.00	14.3	£0.00	41	59	73927	86	18	0.7944444444	44	34.95555556	2.46
30	30/5/2021	Tesla	Membury Services	£18.24	57	£0.32	8	82	74027	100	74	0.7702702703	51	39.28378378	2.55
31	30/5/2021	Electric Highway	Clacket Lane	£8.22	27.4	£0.30	46	79	74111	84	33	0.8303030303	36	29.89090909	2.81
32	3/6/2021	Electric Highway	Folkestone Services	£1.74	5.8	£0.30	24	28	74228	117	4	1.45	55	79.75	1.47
33	5/6/2021	Pod Point	Whitfield, Lidl	£8.18	32.72	£0.25	8	50	74295	67	42	0.779047619	20	15.58095238	4.30
34	10/6/2021	Pod Point	Whitfield, Lidl	£16.03	64.12	£0.25	7	87	74335	40	80	0.8015	43	34.4645	1.16
35	23/06/2021	Pod Point	Whitfield, Lidl	£14.34	57.37	£0.25	15	88	74454	119	73	0.785890411	72	56.58410959	2.10
36	26/06/2021	Electric Highway	Folkestone Services	£0.00	12	£0.00	71	86	74475	21	15	0.8	17	13.6	1.54
37	03/07/2021	Pod Point	Whitfield, Lidl	£13.14	52.54	£0.25	35	100	74555	80	65	0.8083076923	51	41.22369231	1.94
38	07/07/2021	Tesla	Birchanger Services	£5.76	16	£0.36	42	64	74656	101	22	0.7272727273	58	42.18181818	2.39
39	07/07/2021	Tesla	Grantham Services	£12.47	43	£0.29	24	80	74753	97	56	0.7678571429	40	30.71428571	3.16
40	07/07/2021	Electric Highway	Wetherby Services	£9.10	30.3	£0.30	30	70	74865	112	40	0.7583333333	50	37.91666667	2.95
41	08/07/2021	Electric Highway	Wetherby Services	£9.82	32.7	£0.30	53	97	74893	28	44	0.7439393939	17	12.6469697	2.21
42	09/07/2021	Tesla	Gretna Green Services	£6.12	18	£0.34	40	63	75014	121	23	0.7826086957	57	44.60869565	2.71
43	09/07/2021	Tesla	Abington Services	£7.59	23	£0.33	41	71	75063	49	30	0.7666666667	22	16.86666667	2.91
44	09/07/2021	Tesla	Perth	£11.70	39	£0.30	36	87	75148	85	51	0.7647058824	35	26.76470588	3.18
45	09/07/2021	Tesla	Aviemore	£2.40	8	£0.30	51	62	75234	86	11	0.7272727273	36	26.18181818	3.28
46	10/07/2021	Home	Dingwall	£0.00	28	£0.00	43	79	75279	45	36	0.7777777778	19	14.77777778	3.05
47	11/07/2021	Tesla	Perth	£13.50	45	£0.30	21	79	75411	132	58	0.775862069	58	45	2.93
48	11/07/2021	Tesla	Abington Services	£14.19	43	£0.33	27	82	75513	102	55	0.7818181818	52	40.65454545	2.51
49	11/07/2021	Crossroads B&B	Brisco	£0.00	35	£0.00	50	95	75578	65	45	0.7777777778	32	24.88888889	2.61
50	12/07/2021	BP Polar	Hilton Chester	£15.00	41.7	£0.36	24	81	75747	169	57	0.7315789474	71	51.94210526	3.25
51	13/07/2021	BP Polar	Hilton Chester	£4.16	11.6	£0.36	76	90	75754	7	14	0.8285714286	5	4.142857143	1.69
52	13/07/2021	Tesla	Rugby Services	£10.15	35	£0.29	37	84	75877	123	47	0.7446808511	53	39.46808511	3.12
53	13/07/2021	Tesla	Bluewater Shopping Centre	£12.40	40	£0.31	38	90	75993	116	52	0.7692307692	46	35.38461538	3.28
54	17/07/2021	Electric Highway	Folkestone Services	£10.38	34.6	£0.30	30	70	76081	88	40	0.865	60	51.9	1.70
55	18/07/2021	Home	Tenterden	£0.00	11	£0.00	46	60	76126	45	14	0.7857142857	24	18.85714286	2.39
56	31/07/2021	Electric Highway	Folkestone Services	£0.00	35.2	£0.00	8	49	76186	60	41	0.8585365854	52	44.64390244	1.34
57	01/08/2021	Electric Highway	Folkestone Services	£0.00	23	£0.00	12	39	76265	79	27	0.8518518519	37	31.51851852	2.51
58	7/8/2021	InstaVolt	Folkestone	£11.66	29.158	£0.40	9	46	76303	38	37	0.7880540541	30	23.64162162	1.61
59	7/8/2021	Electric Highway	Folkestone Services	£3.60	12	£0.30	27	42	76349	46	15	0.8	19	15.2	3.03
60	8/8/2021	Connected. Kerb	Dover	£3.09	11.89	£0.26	35	49	76363	14	14	0.8492857143	7	5.945	2.35
61	8/8/2021	Pod Point	Whitfield, Lidl	£5.38	21.51	£0.25	26	54	76406	43	28	0.7682142857	23	17.66892857	2.43
62	14/08/2021	Tesla	Maidstone	£5.04	14	£0.36	10	28	76471	65	18	0.7777777778	44	34.22222222	1.90
63	14/08/2021	Tesla	Dartford	£0.00	8	£0.00	18	31	76500	29	13	0.6153846154	10	6.153846154	4.71
64	14/08/2021	Tesla	Maidstone	£18.72	52	£0.36	24	88	76522	22	64	0.8125	7	5.6875	3.87
65	15/08/2021	Electric Highway	Folkestone Services	£6.51	21.7	£0.30	53	80	76583	61	27	0.8037037037	35	28.12962963	2.17
66	21/08/2021	Tesla	Maidstone	£4.68	13	£0.36	48	66	76636	53	18	0.7222222222	32	23.11111111	2.29
67	21/08/2021	Pod Point	Whitfield, Lidl	£3.88	15.5	£0.25	41	61	76686	50	20	0.775	25	19.375	2.58
68	24/08/2021	InstaVolt	Folkestone	£6.48	16.2	£0.40	13	33	76769	83	20	0.81	48	38.88	2.13
69	25/08/2021	Pod Point	Whitfield, Lidl	£1.27	5.07	£0.25	26	32	76785	16	6	0.845	7	5.915	2.70
70	25/08/2021	Pod Point	Faversham, Tesco	£0.00	8.3	0	22	39	76809	24	17	0.4882352941	10	4.882352941	4.92
71	28/08/2021	Electric Highway	Folkestone Services	£1.14	3.8	£0.30	8	12	76853	44	4	0.95	31	29.45	1.49
72	28/08/2021	Ionity	Folkestone Services	£15.94	23.1	£0.69	12	41	76853	0	29	0.7965517241	0	0	N/A
73	28/08/2021	Tesla	Maidstone	£20.16	56	£0.36	8	80	76927	74	72	0.7777777778	33	25.66666667	2.88
74	30/08/2021	Ionity	Folkestone Services	£12.71	18.408	£0.69	17	40	77046	119	23	0.8003478261	63	50.42191304	2.36
75	30/08/2021	Electric Highway	Folkestone Services	£10.14	33.8	£0.30	21	61	77087	41	40	0.845	19	16.055	2.55
76	02/09/2021	Connected. Kerb	Dover	£0.71	2.7	£0.26	50	53	77102	15	3	0.9	11	9.9	1.52
77	04/09/2021	Tesla	Maidstone	£20.52	57	£0.36	16	90	77172	70	74	0.7702702703	37	28.5	2.46
78	06/09/2021	Tesla	Maidstone	£4.32	12	£0.36	48	64	77251	79	16	0.75	42	31.5	2.51
79	06/09/2021	Tesla	Amesbury	£18.36	51	£0.36	9	72	77371	120	63	0.8095238095	55	44.52380952	2.70
80	06/09/2021	Tesla	Exeter	£14.40	48	£0.30	25	87	77465	94	62	0.7741935484	47	36.38709677	2.58
81	08/09/2021	Tesla	Exeter	£7.20	24	£0.30	45	78	77524	59	33	0.7272727273	42	30.54545455	1.93
82	09/09/2021	InstaVolt	Plymouth	£9.43	23.569	£0.40	24	54	77638	114	30	0.7856333333	54	42.4242	2.69
83	10/09/2021	Tesla	Exeter	£12.90	43	£0.30	23	80	77710	72	57	0.7543859649	31	23.38596491	3.08
84	10/09/2021	Tesla	Exeter	£8.70	29	£0.30	49	87	77770	60	38	0.7631578947	31	23.65789474	2.54
85	11/09/2021	evcharge.online	Finlake	£14.55	58.165	£0.25	24	95	77902	132	71	0.8192253521	63	51.61119718	2.56
86	12/09/2021	Tesla	Fleet Services	£21.66	57	£0.38	16	89	78074	172	73	0.7808219178	79	61.68493151	2.79
87	16/09/2021	InstaVolt	Folkestone	£7.60	19	£0.40	7	31	78239	165	24	0.7916666667	82	64.91666667	2.54
88	18/09/2021	Ionity	Folkestone Services	£8.78	12.727	£0.69	17	33	78263	24	16	0.7954375	14	11.136125	2.16
89	18/09/2021	Tesla	Maidstone	£20.52	57	£0.36	13	85	78300	37	72	0.7916666667	20	15.83333333	2.34
90	23/09/2021	InstaVolt	Folkestone	£4.38	10.95	£0.40	39	53	78376	76	14	0.7821428571	46	35.97857143	2.11
91	23/09/2021	InstaVolt	Folkestone	£3.18	7.958	£0.40	51	61	78380	4	10	0.7958	2	1.5916	2.51
92	25/09/2021	Tesla	Maidstone	£20.88	58	£0.36	14	87	78470	90	73	0.7945205479	47	37.34246575	2.41
93	30/09/2021	InstaVolt	Folkestone	£9.09	22.722	£0.40	16	45	78604	134	29	0.7835172414	71	55.62972414	2.41
94	1/10/2021	Pod Point	Whitfield, Lidl	£12.26	49.05	£0.25	32	94	78628	24	62	0.7911290323	13	10.28467742	2.33
95	2/10/2021	Tesla	Maidstone	£7.92	22	£0.36	21	50	78750	122	29	0.7586206897	73	55.37931034	2.20
96	3/10/2021	Pod Point	Whitfield, Lidl	£14.38	57.53	£0.25	13	85	78805	55	72	0.7990277778	37	29.56402778	1.86
97	13/10/2021	InstaVolt	Folkestone	£9.74	24.347	£0.40	16	47	78909	104	31	0.7853870968	69	54.19170968	1.92
98	14/10/2021	InstaVolt	Folkestone	£4.53	11.314	£0.40	36	50	78928	19	14	0.8081428571	11	8.889571429	2.14
99	16/10/2021	Tesla	Maidstone	£8.28	23	£0.36	11	41	78994	66	30	0.7666666667	39	29.9	2.21
100	16/10/2021	Connected. Kerb	Strood	£4.75	18.98	£0.25	36	60	79004	10	24	0.7908333333	5	3.954166667	2.53