Statistik

• Watt am Stromzähler, kann positiv oder negativ sein.
• PVWatt von PV Anlage
• timestamp bei Erfassung

• PVspend = If Watt<0 then - delta timestamp * watt
• PVused = delta timestamp * PVwatt - PVspend
• PV = PVspend + PVused
• kwh = If Watt<0 delta timestamp * watt

date	kwh	PVused	PVspend
2023-04-05	4.5125	1.792408	1.972726
2023-04-06	3.2648	1.7077123888888863	1.7075558333333334
2023-04-07	5.8018	1.4201059444444435	0.3214002777777778
2023-04-08	5.5336	1.132851	0.289161
2023-04-09	3.3678	1.496727	1.309499
2023-04-10	4.047	1.534613	1.655421
2023-04-11	7.2461	1.045646	0.965852
2023-04-12	4.3214	1.007519	0.047715
2023-04-13	3.5763	1.055254	0.26275
2023-04-14	2.5908	1.927051	1.982498
2023-04-15	3.4569	0.80743	0.493823
2023-04-16	6.4441	0.272874	0.0
2023-04-17	7.4008	0.886142	0.180133
2023-04-18	7.567	1.262698	0.211321
2023-04-19	4.0756	1.028016	0.304528
2023-04-20	3.6588	0.900099	0.239775
2023-04-21	3.238	1.695943	2.192442
2023-04-22	3.5172	1.639498	1.3205
2023-04-23	3.2649	1.428436	1.648335
2023-04-24	3.5043	1.110649	0.738313
2023-04-25	4.8861	1.126323	0.463245
2023-04-26	5.6388	1.874011	1.536548
2023-04-27	5.5901	1.949851	1.882689
2023-04-28	5.4452	0.820935	0.10908
2023-04-29	5.0824	1.561104	1.276989
2023-04-30	6.0537	2.16096	0.545678
2023-05-01	7.0269	1.86769	0.220186
2023-05-02	2.4704	1.631764	1.137363
2023-05-03	3.6195	2.042314	1.938575
2023-05-04	2.251	1.90802	2.474115
2023-05-05	3.1069	1.179777	0.640887
2023-05-06	3.967	2.096273	1.765442
2023-05-07	8.615	1.911138	0.10138
2023-05-08	3.3815	1.074074	0.726769
2023-05-09	3.337	1.552242	1.659994
2023-05-10	3.6103	1.3004	0.283034
2023-05-11	3.2413	1.289861	0.512704
2023-05-12	2.8335	1.198733	0.286474
2023-05-13	4.1098	1.048676	0.414045
2023-05-14	5.0571	1.518439	1.170703
2023-05-15	3.7841	1.745286	1.700565
2023-05-16	3.9068	0.865534	0.089817
2023-05-17	5.7764	1.770956	0.819686
2023-05-18	4.2676	2.705749	1.037628
2023-05-19	8.688	1.621604	0.028409
2023-05-20	5.6314	2.533402	0.695494
2023-05-21	5.2515	2.453685	1.007207
2023-05-22	3.7174	2.478649	1.957889
2023-05-23	3.2271	1.815242	0.503271
2023-05-24	4.0714	1.54332	1.071381
2023-05-25	5.0821	2.452446	0.886532
2023-05-26	5.5986	2.990969	1.592153
2023-05-27	3.4427	2.443348	2.363446
2023-05-28	3.1186	2.423814	2.430046
2023-05-29	4.1007	2.482137	2.418278
2023-05-30	3.1022	2.354446	1.804602
2023-05-31	1.6213	1.464569	3.585229
2023-06-01	1.2701	1.488966	3.314114
2023-06-02	2.7212	2.002807	2.830501
2023-06-03	5.5524	3.258894	1.132231
2023-06-04	3.4958	2.154393	2.647681
2023-06-05	4.5616	2.538577	1.541153
2023-06-06	5.1397	2.626238	1.91908
2023-06-07	5.0551	2.680133	1.663627
2023-06-08	5.2174	1.898266	1.323508
2023-06-09	2.2264	1.922211	2.758383
2023-06-10	4.0734	2.372376	1.418965
2023-06-11	4.1109	2.20541	2.654272
2023-06-12	2.0813	1.635877	2.99155
2023-06-13	3.2892	2.039682	3.077054
2023-06-14	2.1481	2.215939	2.199991
2023-06-15	3.6875	2.424079	1.865237
2023-06-16	2.302	2.025313	2.668531
2023-06-17	6.238	3.004963	1.748962
2023-06-18	2.7759	1.954577	2.629221
2023-06-19	2.3192	1.622234	2.217355
2023-06-20	4.16	2.257349	2.378678
2023-06-21	5.3924	1.33913	1.005887
2023-06-22	2.8104	1.837076	1.323723
2023-06-23	3.1999	1.91567	0.854121
2023-06-24	5.9683	3.141912	1.559132
2023-06-25	3.2641	2.402654	2.618839
2023-06-26	2.698	2.074987	2.397334
2023-06-27	2.5649	1.848111	1.310708
2023-06-28	3.4379	1.722348	1.967732
2023-06-29	3.6492	2.175274	1.421099
2023-06-30	4.043	1.185783	0.399908
2023-07-01	2.423	1.780041	1.181204
2023-07-02	2.5852	1.713996	2.163161
2023-07-03	3.7119	1.628718	1.086003
2023-07-04	3.9191	2.246097	1.086731
2023-07-05	2.8121	1.654843	2.065985
2023-07-06	2.7254	2.026725	2.557649
2023-07-07	3.391	2.564456	2.396679
2023-07-08	4.9988	2.155734	1.9559
2023-07-09	3.7657	2.165243	2.510922
2023-07-10	2.3462	1.901081	2.000239
2023-07-11	3.0811	1.832132	2.204936
2023-07-12	2.086	1.700378	2.366636
2023-07-13	2.4867	1.222786	1.718624
2023-07-14	6.9567	2.523519	1.205971
2023-07-15	3.4322	1.925501	1.37767
2023-07-16	5.518	2.68962	0.689264
2023-07-17	3.4768	1.988043	1.063482
2023-07-18	2.4385	1.823582	1.435721
2023-07-19	2.6316	2.435363	1.542589
2023-07-20	2.7854	1.851327	1.982981
2023-07-21	4.1414	1.508743	1.115652
2023-07-22	5.7809	2.619319	0.825086
2023-07-23	6.4711	1.908608	0.98155
2023-07-24	3.4757	0.998405	0.15739
2023-07-25	3.5473	1.464146	0.787463
2023-07-26	3.2872	1.529879	0.645372
2023-07-27	3.4793	1.169804	0.055415
2023-07-28	3.7015	0.962775	0.264234
2023-07-29	7.0434	2.088807	0.648849
2023-07-30	4.562	2.075075	0.87031
2023-07-31	3.0154	1.505392	1.157826
2023-08-01	3.4173	1.19604	1.229465
2023-08-02	4.2112	1.034189	0.065429
2023-08-03	4.2108	1.782656	0.87644
2023-08-04	3.0949	1.507889	0.955166
2023-08-05	6.8219	2.024726	0.923565
2023-08-06	6.8123	1.216446	0.00409
2023-08-07	3.1693	1.52401	0.619645
2023-08-08	3.2538	2.000089	1.112472
2023-08-09	3.781	1.299551	0.240199
2023-08-10	2.683	1.780199	2.301771
2023-08-11	2.9661	2.008934	2.321646
2023-08-12	8.348	1.81463	0.508559
2023-08-13	4.4125	1.400561	1.59618
2023-08-14	3.9661	1.917425	1.018798
2023-08-15	4.085	2.26111	1.00595
2023-08-16	4.2634	2.023114	1.304032
2023-08-17	4.2233	1.303276	1.124488
2023-08-18	2.3866	1.597592	2.434072
2023-08-19	4.6225	2.181092	1.106088
2023-08-20	4.0396	1.840021	1.91093
2023-08-21	2.6748	1.772929	1.757475
2023-08-22	2.6332	1.557588	1.840914
2023-08-23	3.3078	1.939282	1.660428
2023-08-24	4.1612	1.875132	1.235844
2023-08-25	7.1864	1.152383	0.175129
2023-08-26	4.3677	0.970691	0.144333
2023-08-27	3.9657	0.767582	0.192015
2023-08-28	3.9153	0.867573	0.250929
2023-08-29	2.8829	0.91583	0.211215
2023-08-30	3.3909	1.326839	0.863824
2023-08-31	2.4375	0.559399	0.569679
2023-09-01	4.1508	1.277677	0.793599
2023-09-02	4.4824	1.657833	1.985375
2023-09-03	6.0125	2.305455	0.845081
2023-09-04	5.2087	2.488333	1.203303
2023-09-05	3.0174	1.405921	2.232136
2023-09-06	4.5038	2.484504	1.160166
2023-09-07	2.5944	1.022279	2.544379
2023-09-08	2.9429	1.301832	2.151046
2023-09-09	4.3451	1.921813	1.517487
2023-09-10	4.7995	0.898726	0.492469
2023-09-11	5.1909	1.346405	2.022831
2023-09-12	2.8857	1.458744	1.422228
2023-09-13	3.9466	1.207959	0.216312
2023-09-14	3.873	1.441768	1.099995
2023-09-15	3.6443	1.147849	2.196947
2023-09-16	2.3263	1.061895	1.978656
2023-09-17	3.7096	1.227006	1.663506
2023-09-18	6.4007	0.758166	0.248978
2023-09-19	2.8143	1.430435	1.435857
2023-09-20	3.6384	1.659667	1.738936
2023-09-21	4.1587	0.880908	0.55923
2023-09-22	4.4065	0.944307	0.871978
2023-09-23	5.3862	1.327049	0.498782
2023-09-24	3.1983	1.047071	1.964226
2023-09-25	3.722	1.172628	1.913899
2023-09-26	5.0991	1.658063	1.469437
2023-09-27	7.1203	1.650251	1.254152
2023-09-28	6.9788	1.627956	0.70897
2023-09-29	3.9478	1.460721	1.086345
2023-09-30	6.2971	1.583408	0.750436
2023-10-01	4.229	1.715715	1.213862
2023-10-02	3.2647	1.398149	1.418482
2023-10-03	7.5992	1.227258	0.41117
2023-10-04	5.352	1.169521	1.187305
2023-10-05	4.4863	1.078696	0.399041
2023-10-06	5.5149	0.946682	1.709193
2023-10-07	4.2779	0.796134	0.590704
2023-10-08	3.524	1.153075	0.894646
2023-10-09	3.7527	0.803886	0.562168
2023-10-10	3.5287	1.298468	0.65782
2023-10-11	3.741	1.073351	1.549504
2023-10-12	3.7929	0.643079	0.013619
2023-10-13	4.9701	1.297927	1.14902
2023-10-14	6.1447	0.541031	0.032559
2023-10-15	6.8482	1.013904	0.46758
2023-10-16	5.412	1.008982	1.722976
2023-10-17	3.1851	1.052774	0.148167
2023-10-18	4.9455	1.075895	0.293155
2023-10-19	3.7232	0.620126	0.087374
2023-10-20	4.3015	0.174695	0.0
2023-10-21	4.7278	0.92583	0.180431
2023-10-22	5.3907	1.386258	0.375448
2023-10-23	3.7545	0.570343	0.006576
2023-10-24	5.2003	0.236969	0.0
2023-10-25	3.9583	0.48317	0.070886
2023-10-26	4.4551	0.646121	0.097934
2023-10-27	4.0928	0.798963	0.294326
2023-10-28	3.2064	0.581271	0.450907
2023-10-29	6.0204	0.552266	0.095414
2023-10-30	5.8673	0.581667	0.094441
2023-10-31	2.8456	0.565787	0.068485
2023-11-01	2.5863	0.753807	0.719989
2023-11-02	5.5684	0.196286	0.0
2023-11-03	7.95	0.536954	0.005339
2023-11-04	11.4273	0.647954	0.117371
2023-11-05	6.4119	0.55187	0.094812
2023-11-06	5.4329	0.597351	0.517908
2023-11-07	5.466	0.634453	0.051321
2023-11-08	5.183	0.737978	0.449978
2023-11-09	5.691	0.352922	0.0
2023-11-10	4.0469	0.791718	0.708304
2023-11-11	5.316	0.597619	0.275359
2023-11-12	5.2619	0.553938	0.001567
2023-11-13	3.6762	0.131632	0.0
2023-11-14	5.7044	0.269143	0.0
2023-11-15	3.99	0.633913	0.241926
2023-11-16	5.982	0.330959	0.001306
2023-11-17	5.0238	0.138229	0.0
2023-11-18	6.7827	0.615872	0.011744
2023-11-19	6.8439	0.427636	0.077239
2023-11-20	9.3155	0.763116	0.268659
2023-11-21	3.795	0.37838	0.07126
2023-11-22	5.1361	0.21208	0.0
2023-11-23	5.706	0.311777	0.004037
2023-11-24	4.1784	0.337108	0.015193
2023-11-25	7.0801	0.517314	0.017155
2023-11-26	4.7806	0.42431	0.001253
2023-11-27	4.1593	0.292481	0.045527
2023-11-28	5.138	0.093255	0.0
2023-11-29	6.4105	0.365987	0.055978
2023-11-30	4.3235	0.303656	0.010513
2023-12-01	4.6134	0.081194	0.0
2023-12-02	7.2588	0.022028	0.0
2023-12-03	9.9531	0.502907	0.070611
2023-12-04	5.2423	0.293637	0.001426
2023-12-05	3.8741	0.746247	0.557016
2023-12-06	4.6105	0.084549	0.0
2023-12-07	4.4407	0.634353	0.615779
2023-12-08	5.529	0.10729	0.0
2023-12-09	6.3739	0.337128	0.025711
2023-12-10	4.7315	0.356589	0.041035
2023-12-11	5.5288	0.351994	0.135072
2023-12-12	6.1921	0.15344	0.0
2023-12-13	4.5829	0.477398	0.218616
2023-12-14	5.1984	0.271898	2e-06
2023-12-15	5.0251	0.20673	0.000464
2023-12-16	8.5028	0.490678	0.001356
2023-12-17	4.3548	0.803874	0.341441
2023-12-18	6.035	0.559732	0.633772
2023-12-19	6.0459	0.54686	0.125979
2023-12-20	7.8278	0.524027	0.184261
2023-12-21	5.5985	0.099937	0.0
2023-12-22	12.5027	0.112463	0.0
2023-12-23	10.1683	0.128558	0.0
2023-12-24	3.9162	0.18548	0.0
2023-12-25	5.3386	0.302427	3.3e-05
2023-12-26	5.6737	0.197615	0.0
2023-12-27	5.5736	0.769817	0.229312
2023-12-28	7.3159	0.141298	0.0
2023-12-29	9.2764	0.798993	0.027742
2023-12-30	5.8652	0.721778	0.09258
2023-12-31	6.6664	0.238892	0.001049
2024-01-01	8.0326	0.553813	0.018631
2024-01-02	9.9162	0.180858	0.0
2024-01-03	8.8138	0.44033	0.064521
2024-01-04	7.2832	0.507801	0.079101
2024-01-05	7.4691	0.288052	0.0
2024-01-06	8.2396	0.165632	0.0
2024-01-07	10.7136	0.109905	0.0
2024-01-08	5.1916	0.174629	0.00411
2024-01-09	2.9434	0.635416	0.0
2024-01-10	7.5692	0.69595	0.466563
2024-01-11	4.8939	0.632139	0.0
2024-01-12	4.6921	0.694377	0.568876
2024-01-13	5.9218	0.151189	0.0
2024-01-14	7.1315	1.090078	0.202791
2024-01-15	5.009	0.210483	0.0
2024-01-16	4.4226	0.929056	0.654112
2024-01-17	8.0225	0.197456	0.014468
2024-01-18	5.797	0.111432	0.0
2024-01-19	5.3864	0.696995	0.343797
2024-01-20	8.1293	1.350838	0.306815
2024-01-21	8.3976	0.982827	0.145415
2024-01-22	5.1039	0.238269	0.001294
2024-01-23	8.5939	0.645297	0.165399
2024-01-24	6.8745	0.417096	0.008376
2024-01-25	5.5496	0.890066	0.32047
2024-01-26	4.3918	0.234982	0.0
2024-01-27	5.0428	1.277723	0.733207
2024-01-28	6.1216	1.388898	0.464115
2024-01-29	4.5179	0.919002	0.752288
2024-01-30	4.603	0.855647	0.064722
2024-01-31	4.4437	0.555494	0.008344
2024-02-01	5.8109	0.171479	0.0
2024-02-02	9.45	1.141919	0.137046
2024-02-03	10.2196	0.573139	0.010507
2024-02-04	5.6272	0.24483	0.0
2024-02-05	5.4333	0.75104	1.088566
2024-02-06	5.515	0.494774	0.016635
2024-02-07	5.5569	0.441316	0.00528
2024-02-08	6.4833	0.396821	0.000197
2024-02-09	5.9675	0.403183	0.011691
2024-02-10	8.9	0.662988	0.030544
2024-02-11	7.7096	0.898994	0.211952
2024-02-12	6.0526	0.538252	0.000109
2024-02-13	5.4907	0.918412	0.454273
2024-02-14	5.5334	0.720699	0.130506
2024-02-15	5.9591	1.618288	0.350932
2024-02-16	3.3875	0.724701	0.300225
2024-02-17	13.0386	0.937602	0.271967
2024-02-18	7.5589	1.134577	0.014917
2024-02-19	5.5053	0.610539	0.03301
2024-02-20	5.7004	1.135632	0.360875
2024-02-21	5.6903	1.124232	0.204541
2024-02-22	6.2516	0.288314	0.00271
2024-02-23	4.7065	0.975931	0.110211
2024-02-24	7.381	1.388315	0.64514
2024-02-25	9.3879	2.138491	0.326957
2024-02-26	4.5967	0.865492	0.440111
2024-02-27	4.1718	0.824294	0.167402
2024-02-28	5.8562	0.343813	0.000273
2024-02-29	3.6702	1.234279	1.298343
2024-03-01	4.573	0.732599	0.039122
2024-03-02	8.7052	2.441412	0.428642
2024-03-03	3.83	1.210897	1.195511
2024-03-04	4.6539	0.315801	0.000545
2024-03-05	6.3403	0.381163	0.012142
2024-03-06	4.306	0.334469	0.0
2024-03-07	3.7406	1.09211	0.890854
2024-03-08	4.9943	1.228763	0.974124
2024-03-09	5.9982	1.553415	1.126688
2024-03-10	4.6702	0.189998	0.0
2024-03-11	4.6856	1.066916	0.726029
2024-03-12	5.5028	0.377271	0.001672
2024-03-13	5.2314	0.785082	0.002521
2024-03-14	3.1602	1.269561	1.294616
2024-03-15	6.1345	1.021722	0.320702
2024-03-16	6.58	1.393689	0.574957
2024-03-17	5.9177	1.539286	0.521354
2024-03-18	4.9322	0.643266	0.0
2024-03-19	5.6604	1.527675	1.395081
2024-03-20	7.3089	2.008916	0.761007
2024-03-21	4.9377	1.000425	0.955802
2024-03-22	4.4982	1.146366	1.07028
2024-03-23	10.4293	1.151932	0.147512
2024-03-24	7.9008	0.915966	0.127505
2024-03-25	7.9773	2.169013	0.984918
2024-03-26	7.2712	2.778348	0.558831
2024-03-27	5.1184	1.241029	0.66761
2024-03-28	5.7756	1.53225	0.336258
2024-03-29	6.2354	1.248967	0.292161
2024-03-30	8.9841	0.929997	0.003898
2024-03-31	4.652	1.426933	1.141573
2024-04-01	5.5617	1.221819	0.096281
2024-04-02	4.5085	2.075835	0.724177
2024-04-03	5.9028	1.261579	0.103007
2024-04-04	5.6352	0.9344	0.057612
2024-04-05	4.0414	1.437775	0.778707
2024-04-06	4.5924	2.387439	1.272829
2024-04-07	4.4399	1.607783	1.248864
2024-04-08	3.0841	1.185779	1.780018
2024-04-09	5.7728	0.310347	0.023783
2024-04-10	2.7312	1.632502	1.690578
2024-04-11	3.1409	1.382676	2.274684
2024-04-12	2.7839	1.464634	2.131621
2024-04-13	7.3217	1.752762	1.843273
2024-04-14	5.8081	1.900577	1.489948
2024-04-15	6.5846	1.0217	0.350715
2024-04-16	5.9788	1.331785	0.468014
2024-04-17	2.9783	0.95045	0.735023
2024-04-18	3.6334	1.233866	0.7544
2024-04-19	6.181	0.652519	0.0
2024-04-20	4.6071	2.071004	0.315058
2024-04-21	6.5205	1.779547	0.506421
2024-04-22	3.9195	1.231589	0.781399
2024-04-23	3.9759	1.385167	0.731039
2024-04-24	5.2172	1.000523	0.392115
2024-04-25	2.6084	1.740193	0.44685
2024-04-26	3.4809	1.78123	0.780279
2024-04-27	2.8788	2.357557	1.678246