{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Plán služeb","Seznam","Přehled","Dny","Svátky","Směny","Logo"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":14,"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":"Plán služeb","index":0,"n_rows":66,"n_cols":39,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,1,65,2],[32,1,33,2],[34,1,35,2],[37,1,37,2],[38,1,38,2],[54,1,55,2],[56,1,57,2],[58,1,59,2],[60,1,61,2],[39,1,40,2],[41,1,42,2],[62,1,63,2],[1,36,1,38],[2,36,2,38],[9,1,10,2],[11,1,12,2],[8,1,8,2],[2,1,2,2],[7,1,7,2],[1,1,1,15],[53,1,53,2],[43,1,44,2],[45,1,46,2],[47,1,48,2],[49,1,50,2],[13,1,14,2],[15,1,16,2],[17,1,18,2],[19,1,20,2],[52,1,52,2],[22,1,22,2],[23,1,23,2],[24,1,25,2],[26,1,27,2],[28,1,29,2],[30,1,31,2]]}
[]
[null,"Vaše společnost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Září 2011",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.planovani.net"]
[]
[null,null,null,{"$f":"DAY(Dny!D3)","v":31},{"$f":"DAY(Dny!E3)","v":1},{"$f":"DAY(Dny!F3)","v":2},{"$f":"DAY(Dny!G3)","v":3},{"$f":"DAY(Dny!H3)","v":4},{"$f":"DAY(Dny!I3)","v":5},{"$f":"DAY(Dny!J3)","v":6},{"$f":"DAY(Dny!K3)","v":7},{"$f":"DAY(Dny!L3)","v":8},{"$f":"DAY(Dny!M3)","v":9},{"$f":"DAY(Dny!N3)","v":10},{"$f":"DAY(Dny!O3)","v":11},{"$f":"DAY(Dny!P3)","v":12},{"$f":"DAY(Dny!Q3)","v":13},{"$f":"DAY(Dny!R3)","v":14},{"$f":"DAY(Dny!S3)","v":15},{"$f":"DAY(Dny!T3)","v":16},{"$f":"DAY(Dny!U3)","v":17},{"$f":"DAY(Dny!V3)","v":18},{"$f":"DAY(Dny!W3)","v":19},{"$f":"DAY(Dny!X3)","v":20},{"$f":"DAY(Dny!Y3)","v":21},{"$f":"DAY(Dny!Z3)","v":22},{"$f":"DAY(Dny!AA3)","v":23},{"$f":"DAY(Dny!AB3)","v":24},{"$f":"DAY(Dny!AC3)","v":25},{"$f":"DAY(Dny!AD3)","v":26},{"$f":"DAY(Dny!AE3)","v":27},{"$f":"DAY(Dny!AF3)","v":28},{"$f":"DAY(Dny!AG3)","v":29},{"$f":"DAY(Dny!AH3)","v":30},{"$f":"DAY(Dny!AI3)","v":1},{"$f":"DAY(Dny!AJ3)","v":2},{"$f":"Směny!AM2","v":"fond pracovní doby bez svátků"},null,{"$f":"Směny!AL2*24","v":168}]
[null,null,null,{"$f":"LOOKUP(Dny!D4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"st"},{"$f":"LOOKUP(Dny!E4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"čt"},{"$f":"LOOKUP(Dny!F4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"pá"},{"$f":"LOOKUP(Dny!G4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"so"},{"$f":"LOOKUP(Dny!H4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"ne"},{"$f":"LOOKUP(Dny!I4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"po"},{"$f":"LOOKUP(Dny!J4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"út"},{"$f":"LOOKUP(Dny!K4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"st"},{"$f":"LOOKUP(Dny!L4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"čt"},{"$f":"LOOKUP(Dny!M4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"pá"},{"$f":"LOOKUP(Dny!N4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"so"},{"$f":"LOOKUP(Dny!O4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"ne"},{"$f":"LOOKUP(Dny!P4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"po"},{"$f":"LOOKUP(Dny!Q4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"út"},{"$f":"LOOKUP(Dny!R4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"st"},{"$f":"LOOKUP(Dny!S4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"čt"},{"$f":"LOOKUP(Dny!T4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"pá"},{"$f":"LOOKUP(Dny!U4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"so"},{"$f":"LOOKUP(Dny!V4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"ne"},{"$f":"LOOKUP(Dny!W4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"po"},{"$f":"LOOKUP(Dny!X4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"út"},{"$f":"LOOKUP(Dny!Y4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"st"},{"$f":"LOOKUP(Dny!Z4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"čt"},{"$f":"LOOKUP(Dny!AA4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"pá"},{"$f":"LOOKUP(Dny!AB4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"so"},{"$f":"LOOKUP(Dny!AC4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"ne"},{"$f":"LOOKUP(Dny!AD4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"po"},{"$f":"LOOKUP(Dny!AE4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"út"},{"$f":"LOOKUP(Dny!AF4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"st"},{"$f":"LOOKUP(Dny!AG4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"čt"},{"$f":"LOOKUP(Dny!AH4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"pá"},{"$f":"LOOKUP(Dny!AI4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"so"},{"$f":"LOOKUP(Dny!AJ4,Dny!$C$8:$C$14,Dny!$D$8:$D$14)","v":"ne"},"týdenní fond pracovní doby",null,{"$f":"5*Směny!AM3","v":40}]
[null,null,null,{"$f":"IF(Dny!D5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!E5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!F5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!G5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!H5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!I5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!J5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!K5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!L5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!M5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!N5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!O5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!P5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!Q5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!R5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!S5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!T5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!U5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!V5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!W5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!X5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!Y5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!Z5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AA5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AB5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AC5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AD5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AE5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AF5,\"sv\",\"\")","v":"sv"},{"$f":"IF(Dny!AG5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AH5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AI5,\"sv\",\"\")","v":""},{"$f":"IF(Dny!AJ5,\"sv\",\"\")","v":""}]
[null,null,null,null,null,"",""]
[null,"Mgr. Průša",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"převod/doplánovat",null,{"$f":"((AM9+AM20+AM21)-$AM$4) + AL8","v":-168}]
[null,"René",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno",null,{"$f":"(IF(AG$4<28,SUM(Směny!E8:AF9),IF(AH$4<28,SUM(Směny!E8:AG9),IF(AI$4<28,SUM(Směny!E8:AH9),SUM(Směny!E8:AI9))))) * 24","v":0}]
[null,"přestávka 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v děl. sm.",null,{"$f":"(IF(AG$4<28,SUM(Směny!E7:AF7),IF(AH$4<28,SUM(Směny!E7:AG7),IF(AI$4<28,SUM(Směny!E7:AH7),SUM(Směny!E7:AI7)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E10:AF11),IF(AH$4<28,SUM(Směny!E10:AG11),IF(AI$4<28,SUM(Směny!E10:AH11),SUM(Směny!E10:AI11))))))*24","v":0}]
[null,"přestávka 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E8:AF8)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E9:AF9)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E8:AF8)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E9:AF9)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E8:AG8)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E9:AG9)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E8:AG8)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E9:AG9)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E8:AH8)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E9:AH9)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E8:AH8)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E9:AH9)),SUM(SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E8:AI8)+SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E9:AI9)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E8:AI8)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E9:AI9)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E8:AF8)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E9:AF9)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E8:AG8)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E9:AG9)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E8:AH8)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E9:AH9)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E8:AI8)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E9:AI9)))))))*24","v":0}]
[null,"přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas",null,{"$f":"(IF(AG$4<28,SUM(Směny!E12:AF13),IF(AH$4<28,SUM(Směny!E12:AG13),IF(AI$4<28,SUM(Směny!E12:AH13),SUM(Směny!E12:AI13)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E14:AF15),IF(AH$4<28,SUM(Směny!E14:AG15),IF(AI$4<28,SUM(Směny!E14:AH15),SUM(Směny!E14:AI15))))))*24","v":0}]
[null,"přestávka přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E12:AF12)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E13:AF13)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E12:AF12)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E13:AF13)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E12:AG12)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E13:AG13)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E12:AG12)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E13:AG13)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E12:AH12)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E13:AH13)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E12:AH12)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E13:AH13)),SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E12:AH12)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E13:AH13)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E12:AH12)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E13:AH13)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E12:AF12)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E13:AF13)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E12:AG12)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E13:AG13)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E12:AH12)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E13:AH13)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E12:AI12)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E13:AI13)))))))*24","v":0}]
[null,"dosah na pracovišti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah na pracovišti",null,{"$f":"(IF(AG$4<28,SUM(Směny!E16:AF17),IF(AH$4<28,SUM(Směny!E16:AG17),IF(AI$4<28,SUM(Směny!E16:AH17),SUM(Směny!E16:AI17)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah mimo pracoviště",null,{"$f":"(IF(AG$4<28,SUM(Směny!E18:AF19),IF(AH$4<28,SUM(Směny!E18:AG19),IF(AI$4<28,SUM(Směny!E18:AH19),SUM(Směny!E18:AI19)))))*24","v":0}]
[null,"dosah mimo prac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nemoc",null,{"$f":"(IF(AG$4<28,SUM(Směny!E20:AF20),IF(AH$4<28,SUM(Směny!E20:AG20),IF(AI$4<28,SUM(Směny!E20:AH20),SUM(Směny!E20:AI20)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dovolená",null,{"$f":"(IF(AG$4<28,SUM(Směny!E21:AF21),IF(AH$4<28,SUM(Směny!E21:AG21),IF(AI$4<28,SUM(Směny!E21:AH21),SUM(Směny!E21:AI21)))))*24","v":0}]
[]
[null," Levá",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"převod/doplánovat",null,{"$f":"((AM24+AM35+AM36)-$AM$4) + AL23","v":-168}]
[null,"Jitka",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno",null,{"$f":"(IF(AG$4<28,SUM(Směny!E23:AF24),IF(AH$4<28,SUM(Směny!E23:AG24),IF(AI$4<28,SUM(Směny!E23:AH24),SUM(Směny!E23:AI24))))) * 24","v":0}]
[null,"přestávka 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v děl. sm.",null,{"$f":"(IF(AG$4<28,SUM(Směny!E22:AF22),IF(AH$4<28,SUM(Směny!E22:AG22),IF(AI$4<28,SUM(Směny!E22:AH22),SUM(Směny!E22:AI22)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E25:AF26),IF(AH$4<28,SUM(Směny!E25:AG26),IF(AI$4<28,SUM(Směny!E25:AH26),SUM(Směny!E25:AI26))))))*24","v":0}]
[null,"přestávka 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E23:AF23)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E24:AF24)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E23:AF23)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E24:AF24)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E23:AG23)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E24:AG24)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E23:AG23)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E24:AG24)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E23:AH23)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E24:AH24)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E23:AH23)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E24:AH24)),SUM(SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E23:AI23)+SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E24:AI24)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E23:AI23)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E24:AI24)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E23:AF23)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E24:AF24)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E23:AG23)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E24:AG24)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E23:AH23)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E24:AH24)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E23:AI23)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E24:AI24)))))))*24","v":0}]
[null,"přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas",null,{"$f":"(IF(AG$4<28,SUM(Směny!E27:AF28),IF(AH$4<28,SUM(Směny!E27:AG28),IF(AI$4<28,SUM(Směny!E27:AH28),SUM(Směny!E27:AI28)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E29:AF30),IF(AH$4<28,SUM(Směny!E29:AG30),IF(AI$4<28,SUM(Směny!E29:AH30),SUM(Směny!E29:AI30))))))*24","v":0}]
[null,"přestávka přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E27:AF27)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E28:AF28)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E27:AF27)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E28:AF28)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E27:AG27)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E28:AG28)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E27:AG27)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E28:AG28)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E27:AH27)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E28:AH28)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E27:AH27)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E28:AH28)),SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E27:AH27)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E28:AH28)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E27:AH27)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E28:AH28)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E27:AF27)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E28:AF28)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E27:AG27)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E28:AG28)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E27:AH27)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E28:AH28)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E27:AI27)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E28:AI28)))))))*24","v":0}]
[null,"dosah na pracovišti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah na pracovišti",null,{"$f":"(IF(AG$4<28,SUM(Směny!E31:AF32),IF(AH$4<28,SUM(Směny!E31:AG32),IF(AI$4<28,SUM(Směny!E31:AH32),SUM(Směny!E31:AI32)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah mimo pracoviště",null,{"$f":"(IF(AG$4<28,SUM(Směny!E33:AF34),IF(AH$4<28,SUM(Směny!E33:AG34),IF(AI$4<28,SUM(Směny!E33:AH34),SUM(Směny!E33:AI34)))))*24","v":0}]
[null,"dosah mimo prac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nemoc",null,{"$f":"(IF(AG$4<28,SUM(Směny!E35:AF35),IF(AH$4<28,SUM(Směny!E35:AG35),IF(AI$4<28,SUM(Směny!E35:AH35),SUM(Směny!E35:AI35)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dovolená",null,{"$f":"(IF(AG$4<28,SUM(Směny!E36:AF36),IF(AH$4<28,SUM(Směny!E36:AG36),IF(AI$4<28,SUM(Směny!E36:AH36),SUM(Směny!E36:AI36)))))*24","v":0}]
[]
[null,"JUDr. Nesvá",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"převod/doplánovat",null,{"$f":"((AM39+AM50+AM51)-$AM$4) + AL38","v":-168}]
[null,"Jana",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno",null,{"$f":"(IF(AG$4<28,SUM(Směny!E38:AF39),IF(AH$4<28,SUM(Směny!E38:AG39),IF(AI$4<28,SUM(Směny!E38:AH39),SUM(Směny!E38:AI39))))) * 24","v":0}]
[null,"přestávka 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v děl. sm.",null,{"$f":"(IF(AG$4<28,SUM(Směny!E37:AF37),IF(AH$4<28,SUM(Směny!E37:AG37),IF(AI$4<28,SUM(Směny!E37:AH37),SUM(Směny!E37:AI37)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E40:AF41),IF(AH$4<28,SUM(Směny!E40:AG41),IF(AI$4<28,SUM(Směny!E40:AH41),SUM(Směny!E40:AI41))))))*24","v":0}]
[null,"přestávka 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E38:AF38)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E39:AF39)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E38:AF38)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E39:AF39)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E38:AG38)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E39:AG39)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E38:AG38)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E39:AG39)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E38:AH38)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E39:AH39)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E38:AH38)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E39:AH39)),SUM(SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E38:AI38)+SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E39:AI39)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E38:AI38)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E39:AI39)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E38:AF38)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E39:AF39)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E38:AG38)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E39:AG39)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E38:AH38)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E39:AH39)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E38:AI38)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E39:AI39)))))))*24","v":0}]
[null,"přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas",null,{"$f":"(IF(AG$4<28,SUM(Směny!E42:AF43),IF(AH$4<28,SUM(Směny!E42:AG43),IF(AI$4<28,SUM(Směny!E42:AH43),SUM(Směny!E42:AI43)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E44:AF45),IF(AH$4<28,SUM(Směny!E44:AG45),IF(AI$4<28,SUM(Směny!E44:AH45),SUM(Směny!E44:AI45))))))*24","v":0}]
[null,"přestávka přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E42:AF42)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E43:AF43)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E42:AF42)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E43:AF43)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E42:AG42)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E43:AG43)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E42:AG42)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E43:AG43)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E42:AH42)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E43:AH43)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E42:AH42)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E43:AH43)),SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E42:AH42)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E43:AH43)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E42:AH42)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E43:AH43)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E42:AF42)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E43:AF43)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E42:AG42)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E43:AG43)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E42:AH42)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E43:AH43)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E42:AI42)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E43:AI43)))))))*24","v":0}]
[null,"dosah na pracovišti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah na pracovišti",null,{"$f":"(IF(AG$4<28,SUM(Směny!E46:AF47),IF(AH$4<28,SUM(Směny!E46:AG47),IF(AI$4<28,SUM(Směny!E46:AH47),SUM(Směny!E46:AI47)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah mimo pracoviště",null,{"$f":"(IF(AG$4<28,SUM(Směny!E48:AF49),IF(AH$4<28,SUM(Směny!E48:AG49),IF(AI$4<28,SUM(Směny!E48:AH49),SUM(Směny!E48:AI49)))))*24","v":0}]
[null,"dosah mimo prac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nemoc",null,{"$f":"(IF(AG$4<28,SUM(Směny!E50:AF50),IF(AH$4<28,SUM(Směny!E50:AG50),IF(AI$4<28,SUM(Směny!E50:AH50),SUM(Směny!E50:AI50)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dovolená",null,{"$f":"(IF(AG$4<28,SUM(Směny!E51:AF51),IF(AH$4<28,SUM(Směny!E51:AG51),IF(AI$4<28,SUM(Směny!E51:AH51),SUM(Směny!E51:AI51)))))*24","v":0}]
[]
[null," Námel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"převod/doplánovat",null,{"$f":"((AM54+AM65+AM66)-$AM$4) + AL53","v":-168}]
[null,"Filip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno",null,{"$f":"(IF(AG$4<28,SUM(Směny!E53:AF54),IF(AH$4<28,SUM(Směny!E53:AG54),IF(AI$4<28,SUM(Směny!E53:AH54),SUM(Směny!E53:AI54))))) * 24","v":0}]
[null,"přestávka 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v děl. sm.",null,{"$f":"(IF(AG$4<28,SUM(Směny!E52:AF52),IF(AH$4<28,SUM(Směny!E52:AG52),IF(AI$4<28,SUM(Směny!E52:AH52),SUM(Směny!E52:AI52)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E55:AF56),IF(AH$4<28,SUM(Směny!E55:AG56),IF(AI$4<28,SUM(Směny!E55:AH56),SUM(Směny!E55:AI56))))))*24","v":0}]
[null,"přestávka 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E53:AF53)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E54:AF54)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E53:AF53)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E54:AF54)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E53:AG53)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E54:AG54)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E53:AG53)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E54:AG54)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E53:AH53)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E54:AH54)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E53:AH53)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E54:AH54)),SUM(SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E53:AI53)+SUMIF(Směny!$E$5:$AI$5,\"so\",Směny!E54:AI54)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E53:AI53)+SUMIF(Směny!$E$5:$AI$5,\"ne\",Směny!E54:AI54)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odpracováno ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E53:AF53)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E54:AF54)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E53:AG53)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E54:AG54)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E53:AH53)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E54:AH54)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E53:AI53)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E54:AI54)))))))*24","v":0}]
[null,"přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas",null,{"$f":"(IF(AG$4<28,SUM(Směny!E57:AF58),IF(AH$4<28,SUM(Směny!E57:AG58),IF(AI$4<28,SUM(Směny!E57:AH58),SUM(Směny!E57:AI58)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v noci",null,{"$f":"((IF(AG$4<28,SUM(Směny!E59:AF60),IF(AH$4<28,SUM(Směny!E59:AG60),IF(AI$4<28,SUM(Směny!E59:AH60),SUM(Směny!E59:AI60))))))*24","v":0}]
[null,"přestávka přesčas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas v so + ne",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E57:AF57)+SUMIF(Směny!$E$5:$AF$5,\"so\",Směny!E58:AF58)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E57:AF57)+SUMIF(Směny!$E$5:$AF$5,\"ne\",Směny!E58:AF58)),IF(AH$4<28,SUM(SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E57:AG57)+SUMIF(Směny!$E$5:$AG$5,\"so\",Směny!E58:AG58)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E57:AG57)+SUMIF(Směny!$E$5:$AG$5,\"ne\",Směny!E58:AG58)),IF(AI$4<28,SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E57:AH57)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E58:AH58)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E57:AH57)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E58:AH58)),SUM(SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E57:AH57)+SUMIF(Směny!$E$5:$AH$5,\"so\",Směny!E58:AH58)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E57:AH57)+SUMIF(Směny!$E$5:$AH$5,\"ne\",Směny!E58:AH58)))))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přesčas ve svátek",null,{"$f":"((IF(AG$4<28,SUM(SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E57:AF57)+SUMIF(Směny!$E$6:$AF$6,\"sv\",Směny!E58:AF58)),IF(AH$4<28,SUM(SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E57:AG57)+SUMIF(Směny!$E$6:$AG$6,\"sv\",Směny!E58:AG58)),IF(AI$4<28,SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E57:AH57)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E58:AH58)),SUM(SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E57:AI57)+SUMIF(Směny!$E$6:$AH$6,\"sv\",Směny!E58:AI58)))))))*24","v":0}]
[null,"dosah na pracovišti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah na pracovišti",null,{"$f":"(IF(AG$4<28,SUM(Směny!E61:AF62),IF(AH$4<28,SUM(Směny!E61:AG62),IF(AI$4<28,SUM(Směny!E61:AH62),SUM(Směny!E61:AI62)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dosah mimo pracoviště",null,{"$f":"(IF(AG$4<28,SUM(Směny!E63:AF64),IF(AH$4<28,SUM(Směny!E63:AG64),IF(AI$4<28,SUM(Směny!E63:AH64),SUM(Směny!E63:AI64)))))*24","v":0}]
[null,"dosah mimo prac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nemoc",null,{"$f":"(IF(AG$4<28,SUM(Směny!E65:AF65),IF(AH$4<28,SUM(Směny!E65:AG65),IF(AI$4<28,SUM(Směny!E65:AH65),SUM(Směny!E65:AI65)))))*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dovolená",null,{"$f":"(IF(AG$4<28,SUM(Směny!E66:AF66),IF(AH$4<28,SUM(Směny!E66:AG66),IF(AI$4<28,SUM(Směny!E66:AH66),SUM(Směny!E66:AI66)))))*24","v":0}]

{"sheet":"Seznam","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["No.","Os. číslo","Jméno","Příjmení","Titul","Telefon","e-Mail"]
[1,"","René","Průša","Mgr.","",""]
[2,"","Jitka","Levá","","",""]
[3,"","Jana","Nesvá","JUDr.","",""]
[4,"","Filip","Námel","","",""]

{"sheet":"Přehled","index":2,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["jméno","příjmení","celkem","děl sm","noc","sone","svátek","přesčas","přčs noc","přčs sone","přče sv","ds prac","ds mimo","nemoc","dov"]
["René","Průša",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jitka","Levá",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Jana","Nesvá",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Filip","Námel",0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Dny","index":3,"n_rows":55,"n_cols":37,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"LOOKUP(B2,F8:F19,G8:G19)","v":"Září"},9,{"$f":"LOOKUP(B3,I8:I13,J8:J13)","v":2011}]
[null,2,null,{"$f":"E3-1","v":"2011-08-31"},{"$f":"DATE(C2,B2,1)","v":"2011-09-01"},{"$f":"E3+1","v":"2011-09-02"},{"$f":"F3+1","v":"2011-09-03"},"2011-09-04","2011-09-05","2011-09-06","2011-09-07","2011-09-08","2011-09-09","2011-09-10","2011-09-11","2011-09-12","2011-09-13","2011-09-14","2011-09-15","2011-09-16","2011-09-17","2011-09-18","2011-09-19","2011-09-20","2011-09-21","2011-09-22","2011-09-23","2011-09-24","2011-09-25","2011-09-26","2011-09-27","2011-09-28","2011-09-29","2011-09-30","2011-10-01","2011-10-02","2011-10-03"]
[null,null,null,{"$f":"WEEKDAY(D3,2)","v":3},{"$f":"WEEKDAY(E3,2)","v":4},5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7]
["počet",4,null,{"$f":"OR(D3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(E3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(F3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(G3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(H3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(I3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(J3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(K3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(L3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(M3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(N3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(O3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(P3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(Q3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(R3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(S3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(T3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(U3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(V3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(W3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(X3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(Y3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(Z3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AA3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AB3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AC3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AD3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AE3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AF3=Svátky!$A$1:$F$13)","v":true},{"$f":"OR(AG3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AH3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AI3=Svátky!$A$1:$F$13)","v":false},{"$f":"OR(AJ3=Svátky!$A$1:$F$13)","v":false}]
["znacka",0]
[null,0]
["00:00",null,1,"po",null,1,"Leden",null,1,2010]
["00:30",null,2,"út",null,2,"Únor",null,2,2011]
["01:00",null,3,"st",null,3,"Březen",null,3,2012]
["01:30",null,4,"čt",null,4,"Duben",null,4,2013]
["02:00",null,5,"pá",null,5,"Květen",null,5,2014]
["02:30",null,6,"so",null,6,"Červen",null,6,2015]
["03:00",null,7,"ne",null,7,"Červenec"]
["03:30",null,null,null,null,8,"Srpen"]
["04:00",null,null,null,null,9,"Září"]
["04:30",null,null,null,null,10,"Říjen"]
["05:00",null,null,null,null,11,"Listopad"]
["05:30",null,null,null,null,12,"Prosinec"]
["06:00"]
["06:30"]
["07:00",null,null," "]
["07:30"]
["08:00"]
["08:30",null,"07:00","15:30","11:30","12:00",null,null,"zelená"]
["09:00",null,"15:00","23:30","19:00","19:30",null,null,"oranžová"]
["09:30",null,"19:00","07:00","23:00","23:30","03:00","03:30","modrá"]
["10:00"]
["10:30",null,null,null," "]
["11:00"]
["11:30",null,"bez barvy"]
["12:00",null,"modrá"]
["12:30",null,"oranžová"]
["13:00",null,"zelená"]
["13:30"]
["14:00"]
["14:30"]
["15:00"]
["15:30"]
["16:00"]
["16:30"]
["17:00"]
["17:30"]
["18:00"]
["18:30"]
["19:00"]
["19:30"]
["20:00"]
["20:30"]
["21:00"]
["21:30"]
["22:00"]
["22:30"]
["23:00"]
["23:30"]

{"sheet":"Svátky","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["2010-01-01","2011-01-01","2012-01-01","2013-01-01","2014-01-01","2015-01-01"]
["2010-05-01","2011-05-01","2012-05-01","2013-05-01","2014-05-01","2015-05-01"]
["2010-05-08","2011-05-08","2012-05-08","2013-05-08","2014-05-08","2015-05-08"]
["2010-07-05","2011-07-05","2012-07-05","2013-07-05","2014-07-05","2015-07-05"]
["2010-07-06","2011-07-06","2012-07-06","2013-07-06","2014-07-06","2015-07-06"]
["2010-09-28","2011-09-28","2012-09-28","2013-09-28","2014-09-28","2015-09-28"]
["2010-10-28","2011-10-28","2012-10-28","2013-10-28","2014-10-28","2015-10-28"]
["2010-11-17","2011-11-17","2012-11-17","2013-11-17","2014-11-17","2015-11-17"]
["2010-12-24","2011-12-24","2012-12-24","2013-12-24","2014-12-24","2015-12-24"]
["2010-12-25","2011-12-25","2012-12-25","2013-12-25","2014-12-25","2015-12-25"]
["2010-12-26","2011-12-26","2012-12-26","2013-12-26","2014-12-26","2015-12-26"]
[]
["2010-04-05","2011-04-25","2012-04-09","2013-04-01","2014-04-21","2015-04-06"]

{"sheet":"Směny","index":5,"n_rows":125,"n_cols":39,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,{"$f":"IF(OR(E5=\"so\",E5=\"ne\"),0,1)","v":1},1,0,0,1,1,1,1,1,0,0,1,1,1,1,1,0,0,1,1,1,1,1,0,0,1,1,1,{"$f":"IF(OR(AG5=\"so\",AG5=\"ne\",AH4<21),0,1)","v":1},{"$f":"IF(OR(AH5=\"so\",AH5=\"ne\",AH4<21),0,1)","v":1},{"$f":"IF(OR(AI5=\"so\",AI5=\"ne\",AI4<21),0,1)","v":0},{"$f":"IF(OR(AJ5=\"so\",AJ5=\"ne\",AJ4<21),0,1)","v":0},{"$f":"SUM(E2:AI2)/24","v":0.91666666666666663},{"$f":"IF(AL3=2,AK2 *AM3,AK3 * AM3)","v":7},{"$f":"IF(AL3=2,\"fond pracovní doby se svátky\",\"fond pracovní doby bez svátků\")","v":"fond pracovní doby bez svátků"}]
[null,null,null,null,{"$f":"IF(OR(E5=\"so\",E5=\"ne\",E6=\"sv\"),0,1)","v":1},1,0,0,1,1,1,1,1,0,0,1,1,1,1,1,0,0,1,1,1,1,1,0,0,1,1,0,{"$f":"IF(OR(AG5=\"so\",AG5=\"ne\",AG6=\"sv\",AH4<21),0,1)","v":1},{"$f":"IF(OR(AH5=\"so\",AH5=\"ne\",AH6=\"sv\",AH4<21),0,1)","v":1},{"$f":"IF(OR(AI5=\"so\",AI5=\"ne\",AI6=\"sv\",AI4<21),0,1)","v":0},{"$f":"IF(OR(AJ5=\"so\",AJ5=\"ne\",AJ6=\"sv\",AJ4<21),0,1)","v":0},{"$f":"SUM(E3:AI3)/24","v":0.875},1,8]
[null,null,null,null,{"$f":"DAY(Dny!E3)","v":1},{"$f":"DAY(Dny!F3)","v":2},{"$f":"DAY(Dny!G3)","v":3},{"$f":"DAY(Dny!H3)","v":4},{"$f":"DAY(Dny!I3)","v":5},{"$f":"DAY(Dny!J3)","v":6},{"$f":"DAY(Dny!K3)","v":7},{"$f":"DAY(Dny!L3)","v":8},{"$f":"DAY(Dny!M3)","v":9},{"$f":"DAY(Dny!N3)","v":10},{"$f":"DAY(Dny!O3)","v":11},{"$f":"DAY(Dny!P3)","v":12},{"$f":"DAY(Dny!Q3)","v":13},{"$f":"DAY(Dny!R3)","v":14},{"$f":"DAY(Dny!S3)","v":15},{"$f":"DAY(Dny!T3)","v":16},{"$f":"DAY(Dny!U3)","v":17},{"$f":"DAY(Dny!V3)","v":18},{"$f":"DAY(Dny!W3)","v":19},{"$f":"DAY(Dny!X3)","v":20},{"$f":"DAY(Dny!Y3)","v":21},{"$f":"DAY(Dny!Z3)","v":22},{"$f":"DAY(Dny!AA3)","v":23},{"$f":"DAY(Dny!AB3)","v":24},{"$f":"DAY(Dny!AC3)","v":25},{"$f":"DAY(Dny!AD3)","v":26},{"$f":"DAY(Dny!AE3)","v":27},{"$f":"DAY(Dny!AF3)","v":28},{"$f":"DAY(Dny!AG3)","v":29},{"$f":"DAY(Dny!AH3)","v":30},{"$f":"DAY(Dny!AI3)","v":1},{"$f":"DAY(Dny!AJ3)","v":2},{"$f":"AJ4+1","v":3}]
[null,null,null,null,{"$f":"'Plán služeb'!E5","v":"čt"},{"$f":"'Plán služeb'!F5","v":"pá"},{"$f":"'Plán služeb'!G5","v":"so"},{"$f":"'Plán služeb'!H5","v":"ne"},{"$f":"'Plán služeb'!I5","v":"po"},{"$f":"'Plán služeb'!J5","v":"út"},{"$f":"'Plán služeb'!K5","v":"st"},{"$f":"'Plán služeb'!L5","v":"čt"},{"$f":"'Plán služeb'!M5","v":"pá"},{"$f":"'Plán služeb'!N5","v":"so"},{"$f":"'Plán služeb'!O5","v":"ne"},{"$f":"'Plán služeb'!P5","v":"po"},{"$f":"'Plán služeb'!Q5","v":"út"},{"$f":"'Plán služeb'!R5","v":"st"},{"$f":"'Plán služeb'!S5","v":"čt"},{"$f":"'Plán služeb'!T5","v":"pá"},{"$f":"'Plán služeb'!U5","v":"so"},{"$f":"'Plán služeb'!V5","v":"ne"},{"$f":"'Plán služeb'!W5","v":"po"},{"$f":"'Plán služeb'!X5","v":"út"},{"$f":"'Plán služeb'!Y5","v":"st"},{"$f":"'Plán služeb'!Z5","v":"čt"},{"$f":"'Plán služeb'!AA5","v":"pá"},{"$f":"'Plán služeb'!AB5","v":"so"},{"$f":"'Plán služeb'!AC5","v":"ne"},{"$f":"'Plán služeb'!AD5","v":"po"},{"$f":"'Plán služeb'!AE5","v":"út"},{"$f":"'Plán služeb'!AF5","v":"st"},{"$f":"'Plán služeb'!AG5","v":"čt"},{"$f":"'Plán služeb'!AH5","v":"pá"},{"$f":"'Plán služeb'!AI5","v":"so"},{"$f":"'Plán služeb'!AJ5","v":"ne"}]
[null,null,null,null,{"$f":"'Plán služeb'!E6","v":""},{"$f":"'Plán služeb'!F6","v":""},{"$f":"'Plán služeb'!G6","v":""},{"$f":"'Plán služeb'!H6","v":""},{"$f":"'Plán služeb'!I6","v":""},{"$f":"'Plán služeb'!J6","v":""},{"$f":"'Plán služeb'!K6","v":""},{"$f":"'Plán služeb'!L6","v":""},{"$f":"'Plán služeb'!M6","v":""},{"$f":"'Plán služeb'!N6","v":""},{"$f":"'Plán služeb'!O6","v":""},{"$f":"'Plán služeb'!P6","v":""},{"$f":"'Plán služeb'!Q6","v":""},{"$f":"'Plán služeb'!R6","v":""},{"$f":"'Plán služeb'!S6","v":""},{"$f":"'Plán služeb'!T6","v":""},{"$f":"'Plán služeb'!U6","v":""},{"$f":"'Plán služeb'!V6","v":""},{"$f":"'Plán služeb'!W6","v":""},{"$f":"'Plán služeb'!X6","v":""},{"$f":"'Plán služeb'!Y6","v":""},{"$f":"'Plán služeb'!Z6","v":""},{"$f":"'Plán služeb'!AA6","v":""},{"$f":"'Plán služeb'!AB6","v":""},{"$f":"'Plán služeb'!AC6","v":""},{"$f":"'Plán služeb'!AD6","v":""},{"$f":"'Plán služeb'!AE6","v":""},{"$f":"'Plán služeb'!AF6","v":"sv"},{"$f":"'Plán služeb'!AG6","v":""},{"$f":"'Plán služeb'!AH6","v":""},{"$f":"'Plán služeb'!AI6","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"11:30:00"]
[]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"09:30:00"]
[]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"11:30:00"]
[]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"11:30:00"]
[]
[null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,0.47916666666666669]

{"sheet":"Logo","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}