Sample SBFspot data vwspotdata

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	TimeStamp	Nearest5min	Name	Type	Serial	Pdc1	Pdc2	Idc1	Idc2	Udc1	Udc2	Pac1	Pac2	Pac3	Iac1	Iac2	Iac3	Uac1	Uac2	Uac3	PdcTot	PacTot	Efficiency	EToday	ETotal	Frequency	OperatingTime	FeedInTime	BT_Signal	Status	GridRelay	Temperature

2	Data from 5-17 gives error on upload
3	2018-05-17 8:40:02	2018-05-17 8:40:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	1030	0	2.304	0	447.3	0	497	506	0	4.152	4.152	0	121.47	123.5	0	1030	1003	97.4	0	58780	60	93.4531	89.6308	0	OK	Closed	0
4	2018-05-17 8:35:03	2018-05-17 8:35:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	788	0	1.752	0	449.97	0	380	386	0	3.191	3.191	0	121.29	123.48	0	788	766	97.2	0	58714	60	93.37	89.5478	0	OK	Closed	0
5	2018-05-17 8:30:03	2018-05-17 8:30:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	447	0	0.994	0	449.99	0	210	213	0	1.805	1.805	0	121.36	123.17	0	447	423	94.6	0	58667	60.03	93.2867	89.4644	0	OK	Closed	0
6	2018-05-17 8:25:03	2018-05-17 8:25:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	532	0	1.19	0	447.09	0	253	257	0	2.159	2.159	0	121.3	122.92	0	532	510	95.9	0	58624	60.04	93.2033	89.3811	0	OK	Closed	0
7	2018-05-17 8:20:03	2018-05-17 8:20:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	464	0	1.04	0	446.18	0	218	221	0	1.884	1.884	0	121.03	122.71	0	464	439	94.6	0	58583	60.02	93.12	89.2978	0	OK	Closed	0
8	2018-05-17 8:15:03	2018-05-17 8:15:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	413	0	0.918	0	450.18	0	191	196	0	1.693	1.693	0	119.98	122.51	0	413	387	93.7	0	58551	60.01	93.0367	89.2144	0	OK	Closed	0
9	2018-05-17 8:10:03	2018-05-17 8:10:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	343	0	0.764	0	449.97	0	159	161	0	1.401	1.401	0	120.63	122.29	0	343	320	93.3	0	58521	60	92.9533	89.1311	0	OK	Closed	0
10	2018-05-17 8:05:03	2018-05-17 8:05:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	313	0	0.695	0	449.99	0	144	147	0	1.287	1.287	0	119.35	122.55	0	313	291	93	0	58494	59.99	92.8697	89.0475	0	OK	Closed	0
11	2018-05-17 8:00:03	2018-05-17 8:00:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	245	0	0.549	0	446.31	0	111	114	0	1.062	1.062	0	119.04	121.92	0	245	225	91.8	0	58473	60.01	92.7867	88.9644	0	OK	Closed	0
12	2018-05-17 7:55:03	2018-05-17 7:55:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	236	0	0.525	0	450.03	0	106	107	0	1.027	1.027	0	119.57	121.22	0	236	213	90.3	0	58454	60	92.7031	88.8808	0	OK	Closed	0
13	2018-05-17 7:50:03	2018-05-17 7:50:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	151	0	0.342	0	442.46	0	62	62	0	0.785	0.785	0	119.14	120.59	0	151	124	82.1	0	58440	60.01	92.6197	88.7975	0	OK	Closed	0
14	2018-05-17 7:45:03	2018-05-17 7:45:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	110	0	0.252	0	434.92	0	43	44	0	0.678	0.678	0	119.48	121.1	0	110	87	79.1	0	58431	59.99	92.5367	88.7144	0	OK	Closed	0
15	2018-05-17 7:40:03	2018-05-17 7:40:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	99	0	0.233	0	424.73	0	41	42	0	0.649	0.649	0	119.68	121.36	0	99	83	83.8	0	58424	60.02	92.4533	88.6311	0	OK	Closed	0
16	2018-05-17 7:35:03	2018-05-17 7:35:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	88	0	0.206	0	425.69	0	33	33	0	0.644	0.644	0	119.57	121.19	0	88	66	75	0	58418	60.03	92.3697	88.5475	0	OK	Closed	0
17	2018-05-17 7:30:02	2018-05-17 7:30:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	55	0	0.134	0	416.07	0	15	15	0	0.579	0.579	0	119.42	120.16	0	55	30	54.5	0	58414	60	92.2864	88.4642	0	OK	Closed	0
18	2018-05-17 7:25:03	2018-05-17 7:25:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	46	0	0.114	0	410.37	0	16	17	0	1.463	1.463	0	119.62	121.36	0	46	33	71.7	0	58412	60.02	92.2031	88.3808	0	OK	Closed	0
19	2018-05-17 7:20:03	2018-05-17 7:20:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	54	0	0.13	0	419.9	0	15	15	0	0.567	0.567	0	119.52	121.12	0	54	30	55.6	0	58409	60.01	92.1197	88.2975	0	OK	Closed	0
20
21	Data from 5-16 uploaded with no error
22	2018-05-16 19:10:03	2018-05-16 19:10:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	26	0	0.064	0	419.2	0	4	4	0	1.141	1.141	0	118.61	118.79	0	26	8	30.8	0	58382	59.98	90.8986	87.4278	0	OK	Closed	0
23	2018-05-16 19:05:03	2018-05-16 19:05:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	40	0	0.098	0	405.78	0	13	14	0	0.621	0.621	0	118.84	118.97	0	40	27	67.5	0	58381	59.97	90.8153	87.3444	0	OK	Closed	0
24	2018-05-16 19:00:03	2018-05-16 19:00:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	44	0	0.109	0	409.92	0	13	13	0	0.629	0.629	0	118.85	118.91	0	44	26	59.1	0	58379	59.99	90.7317	87.2608	0	OK	Closed	0
25	2018-05-16 18:55:02	2018-05-16 18:55:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	47	0	0.112	0	419.24	0	16	15	0	0.616	0.616	0	118.84	118.75	0	47	31	66	0	58377	59.99	90.6483	87.1775	0	OK	Closed	0
26	2018-05-16 18:50:03	2018-05-16 18:50:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	51	0	0.121	0	419.24	0	15	15	0	0.582	0.582	0	118.74	118.72	0	51	30	58.8	0	58374	59.97	90.5653	87.0944	0	OK	Closed	0
27	2018-05-16 18:45:03	2018-05-16 18:45:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	51	0	0.124	0	412.16	0	14	14	0	0.542	0.542	0	117.5	117.89	0	51	28	54.9	0	58372	59.99	90.4819	87.0111	0	OK	Closed	0
28	2018-05-16 18:40:03	2018-05-16 18:40:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	59	0	0.142	0	422.98	0	20	21	0	0.589	0.589	0	117.5	118.22	0	59	41	69.5	0	58369	59.99	90.3986	86.9278	0	OK	Closed	0
29	2018-05-16 18:35:03	2018-05-16 18:35:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	69	0	0.165	0	422.9	0	24	25	0	0.572	0.572	0	119.22	119.34	0	69	49	71	0	58365	60	90.3153	86.8444	0	OK	Closed	0
30	2018-05-16 18:30:03	2018-05-16 18:30:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	77	0	0.183	0	422.94	0	28	28	0	0.597	0.597	0	119.17	119.42	0	77	56	72.7	0	58361	60.02	90.2319	86.7611	0	OK	Closed	0
31	2018-05-16 18:25:03	2018-05-16 18:25:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	87	0	0.205	0	426.72	0	33	33	0	0.629	0.629	0	119.14	119.27	0	87	66	75.9	0	58356	59.99	90.1486	86.6778	0	OK	Closed	0
32	2018-05-16 18:20:03	2018-05-16 18:20:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	103	0	0.239	0	430.17	0	39	39	0	0.651	0.651	0	119.14	119.19	0	103	78	75.7	0	58350	59.99	90.0653	86.5944	0	OK	Closed	0
33	2018-05-16 18:15:03	2018-05-16 18:15:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	115	0	0.263	0	438.07	0	49	49	0	0.688	0.688	0	119.02	119.31	0	115	98	85.2	0	58342	60.01	89.9819	86.5111	0	OK	Closed	0
34	2018-05-16 18:10:03	2018-05-16 18:10:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	123	0	0.282	0	436.99	0	47	48	0	0.686	0.686	0	119.01	119.18	0	123	95	77.2	0	58334	59.98	89.8986	86.4278	0	OK	Closed	0
35
36	Transition from 5-16 to 5-17
37	2018-05-17 7:00:03	2018-05-17 7:00:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	48	0	0.118	0	408.65	0	15	15	0	0.545	0.545	0	120.51	120.79	0	48	30	62.5	0	58392	60	91.7864	87.9642	0	OK	Closed	0
38	2018-05-17 6:55:03	2018-05-17 6:55:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	40	0	0.097	0	415.78	0	9	10	0	0.879	0.879	0	120.86	121.14	0	40	19	47.5	0	58390	60.03	91.7031	87.8808	0	OK	Closed	0
39	2018-05-17 6:50:02	2018-05-17 6:50:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	45	0	0.112	0	404.81	0	14	15	0	0.52	0.52	0	121.32	121.32	0	45	29	64.4	0	58388	60.01	91.6194	87.7972	0	OK	Closed	0
40	2018-05-17 6:45:03	2018-05-17 6:45:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	44	0	0.107	0	419.98	0	14	15	0	0.589	0.589	0	120.83	121.04	0	44	29	65.9	0	58386	60.01	91.5364	87.7142	0	OK	Closed	0
41	2018-05-17 6:40:03	2018-05-17 6:40:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	51	0	0.124	0	411.32	0	15	16	0	0.564	0.564	0	120.99	121.09	0	51	31	60.8	0	58384	59.99	91.4531	87.6308	0	OK	Closed	0
42	2018-05-17 6:35:03	2018-05-17 6:35:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	466.26	0	0	0	0	0	0	0	121	120.96	0	0	0	0	0	58382	59.99	91.3694	87.5536	0	OK	Open	0
43	2018-05-17 6:30:03	2018-05-17 6:30:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
44	2018-05-17 6:25:03	2018-05-17 6:25:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
45	2018-05-17 6:20:02	2018-05-17 6:20:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
46	2018-05-17 6:15:03	2018-05-17 6:15:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
47	2018-05-17 6:10:03	2018-05-17 6:10:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
48	2018-05-17 6:05:02	2018-05-17 6:05:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
49	2018-05-17 6:00:03	2018-05-17 6:00:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
50	2018-05-17 5:55:02	2018-05-17 5:55:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	OK	N/A	0
51	2018-05-16 20:20:03	2018-05-16 20:20:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	58382	0	91.5292	87.5536	0	OK	N/A	0
52	2018-05-16 20:15:03	2018-05-16 20:15:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	58382	0	91.5292	87.5536	0	OK	N/A	0
53	2018-05-16 20:10:03	2018-05-16 20:10:00	SN: 1990030396	SB5.0-1SP-US-40	1990030396	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	58382	0	91.5292	87.5536	0	OK	N/A	0
54
55	The problem:
56	sqlite> select * from daydata where power >4500
57	...> ;
58	1526647800\|1990030396\|64541\|774504\|1
59	1526649000\|1990030396\|64541\|774504\|1
60	sqlite> delete from daydata where power>4500;
61	sqlite> select * from daydata where power >4500;
62	sqlite> select * from daydata where power >4500;
63	1526647800\|1990030396\|64541\|774504\|1
64	1526649000\|1990030396\|64541\|774504\|1
65	1526647800\|1990030396\|64541\|774504\|1
66	1526649000\|1990030396\|64541\|774504\|1
67
68	20/05/2018 08:25:00 : 88.109kWh - 0.000W
69	20/05/2018 08:30:00 : 88.109kWh - 0.000W
70	20/05/2018 09:30:00 : 88.251kWh - 1059024.000W
71	20/05/2018 09:35:00 : 88.423kWh - 2064.000W
72	20/05/2018 09:40:00 : 88.598kWh - 2100.000W
73	20/05/2018 09:45:00 : 88.774kWh - 2112.000W
74	20/05/2018 09:50:00 : 88.952kWh - 2136.000W
75	20/05/2018 09:55:00 : 89.131kWh - 2148.000W
76	20/05/2018 10:00:00 : 89.312kWh - 2172.000W
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100