Elektrokotel Samek EPPO 2 - 20, 24
HDO povel A1B6DP01 (správně asi A1B6DP1) časy jaro 2013:
po-pá 0:00-7:00 8:00-10:55 11:55-14:10 15:10-18:30 19:30-24:00
so-ne 0:00-7:30 8:30-10:15 11:15-13:15 14:15-17:30 18:30-24:00

INSERT INTO adny (DATETIME, t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12) SELECT date(Ard.DATETIME) as DATETIME, avg(Ard.t2) as t1, min(Ard.t2) as t2, max(Ard.t2) as t3, avg(Ard.t1) as t4, min(Ard.t1) as t5, max(Ard.t1) as t6, avg(Ard.t5) as t7, min(Ard.t5) as t8, max(Ard.t5) as t9, sum((Ard.t8- BArd.t8)) AS t10, sum(((Ard.t8- BArd.t8)>0.5))/6 AS t11, sum(((Ard.t8- BArd.t8)>0.5))/6*16*6.43939 as t12 FROM a2021dny AS Ard LEFT JOIN a2021dny AS BArd ON (Ard.ID = BArd.ID+1) WHERE (Ard.DATETIME >= SUBDATE(CURDATE(),29)) AND (Ard.DATETIME <= SUBDATE(CURDATE(),-1)) GROUP BY date(Ard.DATETIME) ORDER BY DATETIME DESC

od	den	t1 venku avg	t2 venku min	t3 venku max	t4 T1 deska avg	t5 T1 deska min	t6 T1 deska max koupelna	t7 nahore avg	t8 nahore min	t9 nahore max	t10 updown sum	počet hodin topení sum(((Ard.t8- BArd.t8)>0.5))/6 AS t11	Kč sum(((Ard.t8- BArd.t8)>0.5))/6*16*2.2
19.04.2025	Saturday	10.141	8.880	13.190	13.213	13.130	13.310	15.290	14.750	15.880	-0.180	0.000	0.000
18.04.2025	Friday	10.079	9.190	11.190	13.364	13.250	13.560	16.244	15.940	16.500	1.930	0.167	17.172
15.04.2025	Tuesday	13.322	12.250	14.940	11.277	11.000	11.500	13.156	12.940	13.250	0.320	0.000	0.000
14.04.2025	Monday	15.240	8.130	22.000	10.659	10.250	11.000	12.090	11.380	12.880	0.810	0.000	0.000
13.04.2025	Sunday	14.009	6.750	19.940	9.938	9.560	10.310	10.548	9.750	11.380	0.810	0.000	0.000
12.04.2025	Saturday	13.374	6.630	20.560	9.303	9.000	9.630	8.679	8.060	9.690	0.810	0.000	0.000
11.04.2025	Friday	7.372	2.440	13.000	8.983	8.880	9.060	8.062	7.940	8.250	-0.120	0.000	0.000
10.04.2025	Thursday	7.725	3.310	11.810	9.010	8.880	9.130	8.006	7.810	8.250	0.000	0.000	0.000
09.04.2025	Wednesday	7.869	0.750	16.560	8.930	8.690	9.060	7.630	7.500	7.810	0.060	0.000	0.000
08.04.2025	Tuesday	7.989	1.810	16.250	8.966	8.750	9.130	7.402	7.190	7.690	0.190	0.000	0.000
07.04.2025	Monday	4.743	-0.940	10.000	9.100	9.000	9.250	7.917	7.440	8.750	-0.500	0.000	0.000
06.04.2025	Sunday	3.352	-0.810	8.060	9.595	9.310	9.880	9.618	8.750	10.560	-0.810	0.000	0.000
05.04.2025	Saturday	8.022	2.880	13.750	9.929	9.750	10.130	10.675	10.560	10.750	-0.070	0.000	0.000
04.04.2025	Friday	11.890	1.880	22.190	9.671	9.310	10.000	9.886	9.500	10.630	0.500	0.000	0.000
03.04.2025	Thursday	10.045	0.060	19.870	9.358	9.000	9.560	9.090	8.810	9.560	0.320	0.000	0.000
02.04.2025	Wednesday	9.567	3.940	17.870	9.176	8.630	9.380	8.519	8.250	8.940	0.370	0.000	0.000
01.04.2025	Tuesday	7.613	3.750	13.560	9.058	8.880	9.190	8.269	8.130	8.380	0.060	0.000	0.000
31.03.2025	Monday	6.676	5.500	10.560	9.079	9.000	9.190	8.561	8.380	8.750	-0.120	0.000	0.000
30.03.2025	Sunday	8.500	3.690	13.560	9.078	8.940	9.190	8.682	8.630	8.750	0.120	0.000	0.000
29.03.2025	Saturday	7.989	5.690	10.440	8.968	8.060	9.060	8.601	8.500	8.690	0.130	0.000	0.000
28.03.2025	Friday	7.467	1.500	16.370	8.830	8.630	9.000	8.321	8.060	8.500	0.060	0.000	0.000
27.03.2025	Thursday	7.139	1.060	12.880	8.873	8.750	9.000	8.538	8.440	8.690	0.000	0.000	0.000
26.03.2025	Wednesday	6.620	3.380	8.940	8.838	8.750	8.880	8.912	8.690	9.130	-0.060	0.000	0.000
25.03.2025	Tuesday	8.548	3.380	15.000	8.752	8.560	8.880	9.001	8.940	9.130	0.190	0.000	0.000
24.03.2025	Monday	8.899	4.810	13.810	8.504	8.310	8.690	8.756	8.630	8.940	0.250	0.000	0.000
23.03.2025	Sunday	8.930	6.000	11.750	8.265	8.130	8.440	8.532	8.190	8.750	0.250	0.000	0.000
22.03.2025	Saturday	9.318	-0.440	17.560	7.918	7.630	8.130	7.718	7.440	8.190	0.310	0.000	0.000
21.03.2025	Friday	7.868	0.190	17.310	7.774	7.560	7.940	7.038	6.810	7.440	0.000	0.000	0.000