{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["testování"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"testování","index":0,"n_rows":103,"n_cols":15,"rows_kept":103,"cut":false,"hidden":false,"merged":[[70,0,87,0],[88,0,102,0],[1,0,21,0],[39,0,53,0],[54,0,69,0],[22,0,38,0]]}
[null,"time [UTC +2 (CEST)]","PIR_obyvák [on/off]","PIR_chodba [on/off]","kuchyň průtok TV a SV","koupelna průtok TV a SV","Mag_vchod [on/off]","obývák: \nneteče voda=0; ok=10; pád=1","koupelna: \nok=10; zbytek=0","pohyb","došel se napít (průtok>0), poté bez pohybu => pád obývák","došel do koupelny (průtok>0), poté bez pohybu => \npád koupelna",null,null,"Krizová situace?"]
["Senior se probudil, došel do koupelny (průtok > 0) a vrátil se zpět do postele ","2019-04-16T23:54:00",0,0,0,null,"-",{"$f":"IF(K2=\"neteče voda\",0,IF(K2=\"pád obývák\",1,10))","v":0},{"$f":"IF(L2=\"ok\",10,0)","v":0},{"$f":"IF(C2=1,\"pohyb obývák\",IF(D2=1,\"pohyb chodba\",\"-\"))","v":"-"},{"$f":"IF(E2>0.00001,IF(SUM(C3:C4)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F2>0.00001,IF(SUM(D3:D4)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N2=\"pohyb obývák\",\"NE\",IF(OR(N2=\"pád\",N2=\"pád koupelna/chodba\",N2=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-16T23:55:00",0,0,0,null,"-",0,{"$f":"IF(L3=\"ok\",10,0)","v":0},"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:56:00",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:57:00",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:58:00.005",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:59:00.010",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T00:00:00.015",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T00:01:00.020",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T00:02:00.025",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T00:03:00.030",0,0,0,null,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T00:04:00.035",1,0,0,1.188621E-12,"-",{"$f":"IF(K12=\"neteče voda\",0,IF(K12=\"pád obývák\",1,10))","v":0},0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K12=\"neteče voda\",IF(D12=1,\"pohyb chodba\",IF(C12=1,\"pohyb obývák\",IF(SUM(H2:H11)>9,\"ok\",IF(F12>0.00001,IF(SUM(D13:D14)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I2:I11)>9,\"ok\",\"pád\"))))),K12)","v":"pohyb obývák"},{"$f":"IF(M12=\"pohyb chodba\",IF(OR(M13=\"pohyb chodba\",M14=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G12:G13)>0,\"odešel z bytu\",IF(M13=\"pohyb obývák\",\"ok\",IF(OR(M13=\"pád\",M13=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M12)","v":"pohyb obývák"},{"$f":"IF(N12=\"pohyb obývák\",\"NE\",IF(OR(N12=\"pád\",N12=\"pád koupelna/chodba\",N12=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T00:05:00.040",1,0,0,1.058039E-25,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K13=\"neteče voda\",IF(D13=1,\"pohyb chodba\",IF(C13=1,\"pohyb obývák\",IF(SUM(H2:H12)>9,\"ok\",IF(F13>0.00001,IF(SUM(D14:D15)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I2:I12)>9,\"ok\",\"pád\"))))),K13)","v":"pohyb obývák"},"pohyb obývák",{"$f":"IF(N13=\"pohyb obývák\",\"NE\",IF(OR(N13=\"pád\",N13=\"pád koupelna/chodba\",N13=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T00:06:00.045",1,0,0,9.4180440000000004E-39,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K14=\"neteče voda\",IF(D14=1,\"pohyb chodba\",IF(C14=1,\"pohyb obývák\",IF(SUM(H2:H13)>9,\"ok\",IF(F14>0.00001,IF(SUM(D15:D16)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I2:I13)>9,\"ok\",\"pád\"))))),K14)","v":"pohyb obývák"},"pohyb obývák","NE"]
[null,"2019-04-17T00:07:00.050",0,1,0,0.1578823,"-",0,10,"pohyb chodba","neteče voda","ok",{"$f":"IF(K15=\"neteče voda\",IF(D15=1,\"pohyb chodba\",IF(C15=1,\"pohyb obývák\",IF(SUM(H2:H14)>9,\"ok\",IF(F15>0.00001,IF(SUM(D16:D17)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I2:I14)>9,\"ok\",\"pád\"))))),K15)","v":"pohyb chodba"},"--","NE"]
[null,"2019-04-17T00:08:00.055",0,0,0,4.3339099999999998E-2,"-",0,10,"-","neteče voda","ok",{"$f":"IF(K16=\"neteče voda\",IF(D16=1,\"pohyb chodba\",IF(C16=1,\"pohyb obývák\",IF(SUM(H2:H15)>9,\"ok\",IF(F16>0.00001,IF(SUM(D17:D18)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I2:I15)>9,\"ok\",\"pád\"))))),K16)","v":"v koupelně"},"v koupelně","NE"]
[null,"2019-04-17T00:09:00.060",1,1,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K17=\"neteče voda\",IF(D17=1,\"pohyb chodba\",IF(C17=1,\"pohyb obývák\",IF(SUM(H3:H16)>9,\"ok\",IF(F17>0.00001,IF(SUM(D18:D19)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I3:I16)>9,\"ok\",\"pád\"))))),K17)","v":"pohyb chodba"},"ok","NE"]
[null,"2019-04-17T00:10:00.065",1,0,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K18=\"neteče voda\",IF(D18=1,\"pohyb chodba\",IF(C18=1,\"pohyb obývák\",IF(SUM(H4:H17)>9,\"ok\",IF(F18>0.00001,IF(SUM(D19:D20)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I4:I17)>9,\"ok\",\"pád\"))))),K18)","v":"pohyb obývák"},"pohyb obývák","NE"]
[null,"2019-04-17T00:11:00.070",1,0,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K19=\"neteče voda\",IF(D19=1,\"pohyb chodba\",IF(C19=1,\"pohyb obývák\",IF(SUM(H5:H18)>9,\"ok\",IF(F19>0.00001,IF(SUM(D20:D21)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I5:I18)>9,\"ok\",\"pád\"))))),K19)","v":"pohyb obývák"},"pohyb obývák","NE"]
[null,"2019-04-17T00:12:00.075",0,0,0,1.4012979999999999E-44,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K20=\"neteče voda\",IF(D20=1,\"pohyb chodba\",IF(C20=1,\"pohyb obývák\",IF(SUM(H6:H19)>9,\"ok\",IF(F20>0.00001,IF(SUM(D21:D22)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I6:I19)>9,\"ok\",\"pád\"))))),K20)","v":"ok"},"ok","NE"]
[null,"2019-04-17T00:13:00.080",0,0,0,1.4012979999999999E-44,"-",0,0,"-",{"$f":"IF(E21>0.00001,IF(SUM(C22:C33)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F21>0.00001,IF(SUM(D22:D33)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K21=\"neteče voda\",IF(D21=1,\"pohyb chodba\",IF(C21=1,\"pohyb obývák\",IF(SUM(H7:H20)>9,\"ok\",IF(F21>0.00001,IF(SUM(D22:D33)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I7:I20)>9,\"ok\",\"pád\"))))),K21)","v":"ok"},{"$f":"IF(M21=\"pohyb chodba\",IF(OR(M22=\"pohyb chodba\",M33=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G21:G22)>0,\"odešel z bytu\",IF(M22=\"pohyb obývák\",\"ok\",IF(OR(M22=\"pád\",M22=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M21)","v":"ok"},"NE"]
[null,"2019-04-17T00:14:00.085",0,0,0,1.4012979999999999E-44,"-",0,0,"-",{"$f":"IF(E22>0.00001,IF(SUM(C33:C34)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F22>0.00001,IF(SUM(D33:D34)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K22=\"neteče voda\",IF(D22=1,\"pohyb chodba\",IF(C22=1,\"pohyb obývák\",IF(SUM(H8:H21)>9,\"ok\",IF(F22>0.00001,IF(SUM(D33:D34)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I8:I21)>9,\"ok\",\"pád\"))))),K22)","v":"ok"},{"$f":"IF(M22=\"pohyb chodba\",IF(OR(M33=\"pohyb chodba\",M34=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G22:G33)>0,\"odešel z bytu\",IF(M33=\"pohyb obývák\",\"ok\",IF(OR(M33=\"pád\",M33=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M22)","v":"ok"},"NE"]
["Senior se šel napít do kuchyně => pohyb po spotřebě vody (průtok >0) => vrátil se to postele","2019-04-16T23:05:00",0,0,0,0,"-",0,0,"-",{"$f":"IF(E23>0.00001,IF(SUM(C24:C25)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F23>0.00001,IF(SUM(D24:D25)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí","NE"]
[null,"2019-04-16T23:06:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:07:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:08:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:09:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:10:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:11:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:12:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:13:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:14:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T23:15:00",1,0,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K33=\"neteče voda\",IF(D33=1,\"pohyb chodba\",IF(C33=1,\"pohyb obývák\",IF(SUM(H23:H32)>9,\"ok\",IF(F33>0.00001,IF(SUM(D34:D35)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I32)>9,\"ok\",\"pád\"))))),K33)","v":"pohyb obývák"},{"$f":"IF(M33=\"pohyb chodba\",IF(OR(M34=\"pohyb chodba\",M35=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G33:G34)>0,\"odešel z bytu\",IF(M34=\"pohyb obývák\",\"ok\",IF(OR(M34=\"pád\",M34=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M33)","v":"pohyb obývák"},"NE"]
[null,"2019-04-16T23:16:00",1,0,3.9765200000000001E-2,1.4012979999999999E-44,"-",10,0,{"$f":"IF(C34=1,\"pohyb obývák\",IF(D34=1,\"pohyb chodba\",\"-\"))","v":"pohyb obývák"},"ok","neteče voda",{"$f":"IF(K34=\"neteče voda\",IF(D34=1,\"pohyb chodba\",IF(C34=1,\"pohyb obývák\",IF(SUM(H23:H33)>9,\"ok\",IF(F34>0.00001,IF(SUM(D35:D36)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I33)>9,\"ok\",\"pád\"))))),K34)","v":"ok"},"ok","NE"]
[null,"2019-04-16T23:17:00",0,0,3.998575E-2,1.4012979999999999E-44,"-",10,0,"-","ok","neteče voda",{"$f":"IF(K35=\"neteče voda\",IF(D35=1,\"pohyb chodba\",IF(C35=1,\"pohyb obývák\",IF(SUM(H23:H33)>9,\"ok\",IF(F35>0.00001,IF(SUM(D36:D37)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I33)>9,\"ok\",\"pád\"))))),K35)","v":"ok"},"ok","NE"]
[null,"2019-04-16T23:18:00",1,0,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K36=\"neteče voda\",IF(D36=1,\"pohyb chodba\",IF(C36=1,\"pohyb obývák\",IF(SUM(H23:H35)>9,\"ok\",IF(F36>0.00001,IF(SUM(D37:D38)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I35)>9,\"ok\",\"pád\"))))),K36)","v":"pohyb obývák"},"pohyb obývák","NE"]
[null,"2019-04-16T23:19:00",1,0,0,1.4012979999999999E-44,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K37=\"neteče voda\",IF(D37=1,\"pohyb chodba\",IF(C37=1,\"pohyb obývák\",IF(SUM(H23:H36)>9,\"ok\",IF(F37>0.00001,IF(SUM(D38:D39)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I36)>9,\"ok\",\"pád\"))))),K37)","v":"pohyb obývák"},"pohyb obývák","NE"]
[null,"2019-04-16T23:20:00",0,0,0,1.4012979999999999E-44,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K38=\"neteče voda\",IF(D38=1,\"pohyb chodba\",IF(C38=1,\"pohyb obývák\",IF(SUM(H23:H37)>9,\"ok\",IF(F38>0.00001,IF(SUM(D39:D40)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I37)>9,\"ok\",\"pád\"))))),K38)","v":"ok"},"ok","NE"]
[null,"2019-04-16T23:21:00",0,0,0,1.4012979999999999E-44,"-",0,0,"-",{"$f":"IF(E39>0.00001,IF(SUM(C40:C51)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F39>0.00001,IF(SUM(D40:D51)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K39=\"neteče voda\",IF(D39=1,\"pohyb chodba\",IF(C39=1,\"pohyb obývák\",IF(SUM(H23:H38)>9,\"ok\",IF(F39>0.00001,IF(SUM(D40:D41)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I23:I38)>9,\"ok\",\"pád\"))))),K39)","v":"ok"},{"$f":"IF(M39=\"pohyb chodba\",IF(OR(M40=\"pohyb chodba\",M51=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G39:G40)>0,\"odešel z bytu\",IF(M40=\"pohyb obývák\",\"ok\",IF(OR(M40=\"pád\",M40=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M39)","v":"ok"},"NE"]
["Senior se šel napít do kuchyně (průtok > 0) => žádný pohyb po spotřebě vody => pád kuchyň/obývák","2019-04-17T23:12:00",0,0,0,1.4012979999999999E-44,"-",0,0,"-",{"$f":"IF(E40>0.00001,IF(SUM(C51:C52)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F40>0.00001,IF(SUM(D51:D52)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí","NE"]
[null,"2019-04-17T23:13:00",0,0,0,0,"-",{"$f":"IF(K41=\"neteče voda\",0,IF(K41=\"pád obývák\",1,10))","v":0},{"$f":"IF(L41=\"ok\",10,0)","v":0},"-",{"$f":"IF(E41>0.00001,IF(SUM(C44:C45)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F41>0.00001,IF(SUM(D44:D45)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N41=\"pohyb obývák\",\"NE\",IF(OR(N41=\"pád\",N41=\"pád koupelna/chodba\",N41=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T23:14:00",0,0,0,0,"-",{"$f":"IF(K42=\"neteče voda\",0,IF(K42=\"pád obývák\",1,10))","v":0},{"$f":"IF(L42=\"ok\",10,0)","v":0},"-",{"$f":"IF(E42>0.00001,IF(SUM(C43:C44)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F42>0.00001,IF(SUM(D43:D44)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N42=\"pohyb obývák\",\"NE\",IF(OR(N42=\"pád\",N42=\"pád koupelna/chodba\",N42=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T23:15:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:16:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:17:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:18:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:19:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:20:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:21:00",0,0,0,0,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:22:00",1,0,0,0,"-",0,0,"pohyb obývák","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T23:23:00",1,0,0,0,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K51=\"neteče voda\",IF(D51=1,\"pohyb chodba\",IF(C51=1,\"pohyb obývák\",IF(SUM(H40:H50)>9,\"ok\",IF(F51>0.00001,IF(SUM(D52:D53)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I40:I50)>9,\"ok\",\"pád\"))))),K51)","v":"pohyb obývák"},{"$f":"IF(M51=\"pohyb chodba\",IF(OR(M52=\"pohyb chodba\",M53=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G51:G52)>0,\"odešel z bytu\",IF(M52=\"pohyb obývák\",\"ok\",IF(OR(M52=\"pád\",M52=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M51)","v":"pohyb obývák"},"NE"]
[null,"2019-04-17T23:24:00",0,0,3.9984930000000002E-2,0,"-",1,0,"-","pád obývák","neteče voda",{"$f":"IF(K52=\"neteče voda\",IF(D52=1,\"pohyb chodba\",IF(C52=1,\"pohyb obývák\",IF(SUM(H40:H51)>9,\"ok\",IF(F52>0.00001,IF(SUM(D53:D54)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I40:I51)>9,\"ok\",\"pád\"))))),K52)","v":"pád obývák"},{"$f":"IF(M52=\"pohyb chodba\",IF(OR(M53=\"pohyb chodba\",M54=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G52:G53)>0,\"odešel z bytu\",IF(M53=\"pohyb obývák\",\"ok\",IF(OR(M53=\"pád\",M53=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M52)","v":"pád obývák"},"ANO"]
[null,"2019-04-17T23:25:00",0,0,0,6.2139240000000001E-13,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K53=\"neteče voda\",IF(D53=1,\"pohyb chodba\",IF(C53=1,\"pohyb obývák\",IF(SUM(H40:H52)>9,\"ok\",IF(F53>0.00001,IF(SUM(D54:D55)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I40:I52)>9,\"ok\",\"pád\"))))),K53)","v":"pád"},{"$f":"IF(M53=\"pohyb chodba\",IF(OR(M54=\"pohyb chodba\",M55=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G53:G54)>0,\"odešel z bytu\",IF(M54=\"pohyb obývák\",\"ok\",IF(OR(M54=\"pád\",M54=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M53)","v":"pád"},"ANO"]
[null,"2019-04-17T23:26:00",0,0,2.2211259999999999E-26,5.53127E-26,"-",0,0,"-",{"$f":"IF(E54>0.00001,IF(SUM(C55:C65)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F54>0.00001,IF(SUM(D55:D65)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K54=\"neteče voda\",IF(D54=1,\"pohyb chodba\",IF(C54=1,\"pohyb obývák\",IF(SUM(H40:H53)>9,\"ok\",IF(F54>0.00001,IF(SUM(D55:D65)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I40:I53)>9,\"ok\",\"pád\"))))),K54)","v":"pád"},{"$f":"IF(M54=\"pohyb chodba\",IF(OR(M55=\"pohyb chodba\",M65=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G54:G55)>0,\"odešel z bytu\",IF(M55=\"pohyb obývák\",\"ok\",IF(OR(M55=\"pád\",M55=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M54)","v":"pád"},"ANO"]
["Senior se probudil, došel do koupelny (průtok > 0) => žádný pohyb po spotřebě vody => pád koupelna","2019-04-16T22:18:00",0,0,1.9771199999999999E-39,0,"-",0,0,"-",{"$f":"IF(E55>0.00001,IF(SUM(C65:C66)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F55>0.00001,IF(SUM(D65:D66)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí","NE"]
[null,"2019-04-16T22:19:00",0,0,1.4012979999999999E-44,-3.799359E-13,"-",{"$f":"IF(K56=\"neteče voda\",0,IF(K56=\"pád obývák\",1,10))","v":0},{"$f":"IF(L56=\"ok\",10,0)","v":0},"-",{"$f":"IF(E56>0.00001,IF(SUM(C57:C58)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F56>0.00001,IF(SUM(D57:D58)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N56=\"pohyb obývák\",\"NE\",IF(OR(N56=\"pád\",N56=\"pád koupelna/chodba\",N56=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-16T22:19:59.990",0,0,1.4012979999999999E-44,-3.3772080000000001E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:20:59.985",0,0,1.4012979999999999E-44,-2.9550570000000001E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:21:59.980",0,0,1.4012979999999999E-44,-2.5329060000000002E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:22:59.975",0,0,1.4012979999999999E-44,-2.110755E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:23:59.970",0,0,1.4012979999999999E-44,-1.688604E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:24:59.965",0,0,1.4012979999999999E-44,-1.2664530000000001E-13,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:25:59.960",0,0,1.4012979999999999E-44,-8.4430200000000002E-14,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:26:59.955",0,0,1.4012979999999999E-44,-4.2215100000000001E-14,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T22:27:59.950",1,0,1.4012979999999999E-44,0,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K65=\"neteče voda\",IF(D65=1,\"pohyb chodba\",IF(C65=1,\"pohyb obývák\",IF(SUM(H55:H64)>9,\"ok\",IF(F65>0.00001,IF(SUM(D66:D67)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I55:I64)>9,\"ok\",\"pád\"))))),K65)","v":"pohyb obývák"},{"$f":"IF(M65=\"pohyb chodba\",IF(OR(M66=\"pohyb chodba\",M67=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G65:G66)>0,\"odešel z bytu\",IF(M66=\"pohyb obývák\",\"ok\",IF(OR(M66=\"pád\",M66=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M65)","v":"pohyb obývák"},"NE"]
[null,"2019-04-16T22:28:59.945",1,0,1.4012979999999999E-44,4.2215100000000001E-14,"-",0,0,{"$f":"IF(C66=1,\"pohyb obývák\",IF(D66=1,\"pohyb chodba\",\"-\"))","v":"pohyb obývák"},"neteče voda","neteče voda",{"$f":"IF(K66=\"neteče voda\",IF(D66=1,\"pohyb chodba\",IF(C66=1,\"pohyb obývák\",IF(SUM(H55:H65)>9,\"ok\",IF(F66>0.00001,IF(SUM(D67:D68)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I55:I65)>9,\"ok\",\"pád\"))))),K66)","v":"pohyb obývák"},{"$f":"IF(M66=\"pohyb chodba\",IF(OR(M67=\"pohyb chodba\",M68=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G66:G67)>0,\"odešel z bytu\",IF(M67=\"pohyb obývák\",\"ok\",IF(OR(M67=\"pád\",M67=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M66)","v":"pohyb obývák"},"NE"]
[null,"2019-04-16T22:29:59.940",0,1,1.4012979999999999E-44,0,"-",0,0,"pohyb chodba",{"$f":"IF(E67>0.00001,IF(SUM(C68:C70)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F67>0.00001,IF(SUM(D68:D70)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K67=\"neteče voda\",IF(D67=1,\"pohyb chodba\",IF(C67=1,\"pohyb obývák\",IF(SUM(H55:H66)>9,\"ok\",IF(F67>0.00001,IF(SUM(D68:D70)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I55:I66)>9,\"ok\",\"pád\"))))),K67)","v":"pohyb chodba"},{"$f":"IF(M67=\"pohyb chodba\",IF(OR(M68=\"pohyb chodba\",M70=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G67:G68)>0,\"odešel z bytu\",IF(M68=\"pohyb obývák\",\"ok\",IF(OR(M68=\"pád\",M68=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M67)","v":"--"},"NE"]
[null,"2019-04-16T22:30:59.935",0,0,1.4012979999999999E-44,0.1081584,"-",0,0,"-",{"$f":"IF(E68>0.00001,IF(SUM(C70:C70)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F68>0.00001,IF(SUM(D70:D70)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"pád koupelna"},{"$f":"IF(K68=\"neteče voda\",IF(D68=1,\"pohyb chodba\",IF(C68=1,\"pohyb obývák\",IF(SUM(H55:H67)>9,\"ok\",IF(F68>0.00001,IF(SUM(D70:D70)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I55:I67)>9,\"ok\",\"pád\"))))),K68)","v":"pád koupelna/chodba"},{"$f":"IF(M68=\"pohyb chodba\",IF(OR(M70=\"pohyb chodba\",#REF!=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G68:G70)>0,\"odešel z bytu\",IF(M70=\"pohyb obývák\",\"ok\",IF(OR(M70=\"pád\",M70=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M68)","v":"pád koupelna/chodba"},"ANO"]
[null,"2019-04-16T22:31:59.925",0,0,1.4012979999999999E-44,3.8153489999999998E-2,"-",{"$f":"IF(K69=\"neteče voda\",0,IF(K69=\"pád obývák\",1,10))","v":0},{"$f":"IF(L69=\"ok\",10,0)","v":0},"-",{"$f":"IF(E69>0.00001,IF(SUM(C70:C70)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F69>0.00001,IF(SUM(D70:D70)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"pád koupelna"},{"$f":"IF(K69=\"neteče voda\",IF(D69=1,\"pohyb chodba\",IF(C69=1,\"pohyb obývák\",IF(SUM(H57:H68)>9,\"ok\",IF(F69>0.00001,IF(SUM(D70:D70)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I57:I68)>9,\"ok\",\"pád\"))))),K69)","v":"pád koupelna/chodba"},{"$f":"IF(M69=\"pohyb chodba\",IF(OR(M70=\"pohyb chodba\",#REF!=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G69:G70)>0,\"odešel z bytu\",IF(M70=\"pohyb obývák\",\"ok\",IF(OR(M70=\"pád\",M70=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M69)","v":"pád koupelna/chodba"},{"$f":"IF(N69=\"pohyb obývák\",\"NE\",IF(OR(N69=\"pád\",N69=\"pád koupelna/chodba\",N69=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"ANO"}]
[null,"2019-04-16T22:31:59.930",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-",{"$f":"IF(E70>0.00001,IF(SUM(#REF!)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F70>0.00001,IF(SUM(#REF!)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K70=\"neteče voda\",IF(D70=1,\"pohyb chodba\",IF(C70=1,\"pohyb obývák\",IF(SUM(H55:H68)>9,\"ok\",IF(F70>0.00001,IF(SUM(#REF!)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I55:I68)>9,\"ok\",\"pád\"))))),K70)","v":"pád"},{"$f":"IF(M70=\"pohyb chodba\",IF(OR(#REF!=\"pohyb chodba\",#REF!=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G70:G70)>0,\"odešel z bytu\",IF(#REF!=\"pohyb obývák\",\"ok\",IF(OR(#REF!=\"pád\",#REF!=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M70)","v":"pád"},"ANO"]
["Senior odešel z bytu","2019-04-16T03:02:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",{"$f":"IF(K71=\"neteče voda\",0,IF(K71=\"pád obývák\",1,10))","v":0},{"$f":"IF(L71=\"ok\",10,0)","v":0},"-",{"$f":"IF(E71>0.00001,IF(SUM(C72:C73)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F71>0.00001,IF(SUM(D72:D73)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N71=\"pohyb obývák\",\"NE\",IF(OR(N71=\"pád\",N71=\"pád koupelna/chodba\",N71=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-16T03:03:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:03:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:04:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",{"$f":"IF(K74=\"neteče voda\",0,IF(K74=\"pád obývák\",1,10))","v":0},{"$f":"IF(L74=\"ok\",10,0)","v":0},"-","neteče voda","neteče voda","spí","spí",{"$f":"IF(N74=\"pohyb obývák\",\"NE\",IF(OR(N74=\"pád\",N74=\"pád koupelna/chodba\",N74=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-16T03:05:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:06:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:07:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:08:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:09:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:10:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:11:59.995",1,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb obývák","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-16T03:12:59.995",1,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K82=\"neteče voda\",IF(D82=1,\"pohyb chodba\",IF(C82=1,\"pohyb obývák\",IF(SUM(H71:H71)>9,\"ok\",IF(F82>0.00001,IF(SUM(D83:D84)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I71)>9,\"ok\",\"-\"))))),K82)","v":"pohyb obývák"},{"$f":"IF(M82=\"pohyb chodba\",IF(OR(M83=\"pohyb chodba\",M84=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G82:G83)>0,\"odešel z bytu\",IF(M83=\"pohyb obývák\",\"ok\",IF(OR(M83=\"pád\",M83=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M82)","v":"pohyb obývák"},"NE"]
[null,"2019-04-16T03:13:59.995",0,1,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb chodba","neteče voda","neteče voda",{"$f":"IF(K83=\"neteče voda\",IF(D83=1,\"pohyb chodba\",IF(C83=1,\"pohyb obývák\",IF(SUM(H71:H82)>9,\"ok\",IF(F83>0.00001,IF(SUM(D84:D85)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I82)>9,\"ok\",\"-\"))))),K83)","v":"pohyb chodba"},"--","NE"]
[null,"2019-04-16T03:14:59.995",0,1,1.4012979999999999E-44,3.3447730000000001E-40,1,{"$f":"IF(K84=\"neteče voda\",0,IF(K84=\"pád obývák\",1,10))","v":0},{"$f":"IF(L84=\"ok\",10,0)","v":0},"pohyb chodba","neteče voda","neteče voda",{"$f":"IF(K84=\"neteče voda\",IF(D84=1,\"pohyb chodba\",IF(C84=1,\"pohyb obývák\",IF(SUM(H71:H83)>9,\"ok\",IF(F84>0.00001,IF(SUM(D85:D86)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I83)>9,\"ok\",\"-\"))))),K84)","v":"pohyb chodba"},"odešel z bytu","NE"]
[null,"2019-04-16T03:15:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,0,0,0,"-","neteče voda","neteče voda",{"$f":"IF(K85=\"neteče voda\",IF(D85=1,\"pohyb chodba\",IF(C85=1,\"pohyb obývák\",IF(SUM(H71:H84)>9,\"ok\",IF(F85>0.00001,IF(SUM(D86:D87)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I84)>9,\"ok\",\"-\"))))),K85)","v":"-"},{"$f":"IF(M85=\"pohyb chodba\",IF(OR(M86=\"pohyb chodba\",M87=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G85:G86)>0,\"odešel z bytu\",IF(M86=\"pohyb obývák\",\"ok\",IF(OR(M86=\"pád\",M86=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M85)","v":"-"},"NE"]
[null,"2019-04-16T03:16:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K86=\"neteče voda\",IF(D86=1,\"pohyb chodba\",IF(C86=1,\"pohyb obývák\",IF(SUM(H71:H85)>9,\"ok\",IF(F86>0.00001,IF(SUM(D87:D88)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I85)>9,\"ok\",\"-\"))))),K86)","v":"-"},"-","NE"]
[null,"2019-04-16T03:17:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K87=\"neteče voda\",IF(D87=1,\"pohyb chodba\",IF(C87=1,\"pohyb obývák\",IF(SUM(H71:H86)>9,\"ok\",IF(F87>0.00001,IF(SUM(D88:D89)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I86)>9,\"ok\",\"-\"))))),K87)","v":"-"},"-","NE"]
[null,"2019-04-16T03:18:59.995",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-",{"$f":"IF(E88>0.00001,IF(SUM(C89:C99)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F88>0.00001,IF(SUM(D89:D99)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(K88=\"neteče voda\",IF(D88=1,\"pohyb chodba\",IF(C88=1,\"pohyb obývák\",IF(SUM(H71:H87)>9,\"ok\",IF(F88>0.00001,IF(SUM(D89:D99)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I71:I87)>9,\"ok\",\"-\"))))),K88)","v":"-"},{"$f":"IF(M88=\"pohyb chodba\",IF(OR(M89=\"pohyb chodba\",M99=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G88:G89)>0,\"odešel z bytu\",IF(M89=\"pohyb obývák\",\"ok\",IF(OR(M89=\"pád\",M89=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M88)","v":"-"},"NE"]
["Senior upadnul v chodbě/kopelně (nedošel do koupelny - průtok = 0)","2019-04-17T01:11:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",{"$f":"IF(K89=\"neteče voda\",0,IF(K89=\"pád obývák\",1,10))","v":0},{"$f":"IF(L89=\"ok\",10,0)","v":0},"-",{"$f":"IF(E89>0.00001,IF(SUM(C99:C100)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F89>0.00001,IF(SUM(D99:D100)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N89=\"pohyb obývák\",\"NE\",IF(OR(N89=\"pád\",N89=\"pád koupelna/chodba\",N89=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T01:12:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",{"$f":"IF(K90=\"neteče voda\",0,IF(K90=\"pád obývák\",1,10))","v":0},{"$f":"IF(L90=\"ok\",10,0)","v":0},"-",{"$f":"IF(E90>0.00001,IF(SUM(C91:C92)>0,\"ok\",\"pád obývák\"),\"neteče voda\")","v":"neteče voda"},{"$f":"IF(F90>0.00001,IF(SUM(D91:D92)>0,\"ok\",\"pád koupelna\"),\"neteče voda\")","v":"neteče voda"},"spí","spí",{"$f":"IF(N90=\"pohyb obývák\",\"NE\",IF(OR(N90=\"pád\",N90=\"pád koupelna/chodba\",N90=\"pád obývák\")=TRUE,\"ANO\",\"NE\"))","v":"NE"}]
[null,"2019-04-17T01:13:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:14:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:15:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:16:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:17:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:18:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:19:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:20:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,{"$f":"IF(C98=1,\"pohyb obývák\",IF(D98=1,\"pohyb chodba\",\"-\"))","v":"-"},"neteče voda","neteče voda","spí","spí","NE"]
[null,"2019-04-17T01:21:00",1,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb obývák","neteče voda","neteče voda",{"$f":"IF(K99=\"neteče voda\",IF(D99=1,\"pohyb chodba\",IF(C99=1,\"pohyb obývák\",IF(SUM(H89:H98)>9,\"ok\",IF(F99>0.00001,IF(SUM(D100:D101)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I89:I98)>9,\"ok\",\"-\"))))),K99)","v":"pohyb obývák"},{"$f":"IF(M99=\"pohyb chodba\",IF(OR(M100=\"pohyb chodba\",M101=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G99:G100)>0,\"odešel z bytu\",IF(M100=\"pohyb obývák\",\"ok\",IF(OR(M100=\"pád\",M100=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M99)","v":"pohyb obývák"},"NE"]
[null,"2019-04-17T01:22:00",0,1,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb chodba","neteče voda","neteče voda",{"$f":"IF(K100=\"neteče voda\",IF(D100=1,\"pohyb chodba\",IF(C100=1,\"pohyb obývák\",IF(SUM(H89:H99)>9,\"ok\",IF(F100>0.00001,IF(SUM(D101:D102)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I89:I99)>9,\"ok\",\"-\"))))),K100)","v":"pohyb chodba"},{"$f":"IF(M100=\"pohyb chodba\",IF(OR(M101=\"pohyb chodba\",M102=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G100:G101)>0,\"odešel z bytu\",IF(M101=\"pohyb obývák\",\"ok\",IF(OR(M101=\"pád\",M101=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M100)","v":"--"},"NE"]
[null,"2019-04-17T01:23:00",0,1,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"pohyb chodba","neteče voda","neteče voda",{"$f":"IF(K101=\"neteče voda\",IF(D101=1,\"pohyb chodba\",IF(C101=1,\"pohyb obývák\",IF(SUM(H89:H100)>9,\"ok\",IF(F101>0.00001,IF(SUM(D102:D103)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I89:I100)>9,\"ok\",\"-\"))))),K101)","v":"pohyb chodba"},{"$f":"IF(M101=\"pohyb chodba\",IF(OR(M102=\"pohyb chodba\",M103=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G101:G102)>0,\"odešel z bytu\",IF(M102=\"pohyb obývák\",\"ok\",IF(OR(M102=\"pád\",M102=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M101)","v":"pád"},"ANO"]
[null,"2019-04-17T01:24:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K102=\"neteče voda\",IF(D102=1,\"pohyb chodba\",IF(C102=1,\"pohyb obývák\",IF(SUM(H89:H101)>9,\"ok\",IF(F102>0.00001,IF(SUM(D103:D104)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I89:I101)>9,\"ok\",\"-\"))))),K102)","v":"-"},{"$f":"IF(M102=\"pohyb chodba\",IF(OR(M103=\"pohyb chodba\",M104=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G102:G103)>0,\"odešel z bytu\",IF(M103=\"pohyb obývák\",\"ok\",IF(OR(M103=\"pád\",M103=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M102)","v":"-"},"NE"]
[null,"2019-04-17T01:25:00",0,0,1.4012979999999999E-44,3.3447730000000001E-40,"-",0,0,"-","neteče voda","neteče voda",{"$f":"IF(K103=\"neteče voda\",IF(D103=1,\"pohyb chodba\",IF(C103=1,\"pohyb obývák\",IF(SUM(H89:H102)>9,\"ok\",IF(F103>0.00001,IF(SUM(D104:D105)>0,\"v koupelně\",\"pád koupelna/chodba\"),IF(SUM(I89:I102)>9,\"ok\",\"-\"))))),K103)","v":"-"},{"$f":"IF(M103=\"pohyb chodba\",IF(OR(M104=\"pohyb chodba\",M105=\"pohyb chodba\")=TRUE,\"--\",IF(SUM(G103:G104)>0,\"odešel z bytu\",IF(M104=\"pohyb obývák\",\"ok\",IF(OR(M104=\"pád\",M104=\"pád koupelna/chodba\")=TRUE,\"--\",\"pád\")))),M103)","v":"-"},"NE"]