{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","Jména zaměstnanců"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Leden","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,"Plán Nepřítomnosti Zaměstnanců"]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[{"$nulls":33},"Zadejte rok:"]
[null,"Leden","Data nepřítomnosti",{"$nulls":30},2019]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,1),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,2),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,3),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,4),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,5),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,6),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,7),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,8),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,9),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,10),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,11),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,12),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,13),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,14),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,15),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,16),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,17),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,18),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,19),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,20),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,21),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,22),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,23),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,24),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,25),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,26),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,27),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,28),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,29),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,30),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,1,31),1),\"aaa\")","v":"čt"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",null,null,"D","D","D","D",{"$nulls":6},"D",{"$nulls":18},{"$f":"COUNTA(Leden!$C7:$AG7)","v":5}]
[null,"Zaměstnanec 2",{"$nulls":4},"Z","Z",{"$nulls":4},"O",{"$nulls":8},"Z",{"$nulls":4},"D","D","D",{"$nulls":4},{"$f":"COUNTA(Leden!$C8:$AG8)","v":7}]
[null,"Zaměstnanec 3",null,null,"O",{"$nulls":10},"Z",{"$nulls":14},"Z",null,null,{"$f":"COUNTA(Leden!$C9:$AG9)","v":3}]
[null,"Zaměstnanec 4",{"$nulls":6},"O",{"$nulls":11},"D","D","D",{"$nulls":10},{"$f":"COUNTA(Leden!$C10:$AG10)","v":4}]
[null,"Zaměstnanec 5",{"$nulls":3},"Z","D","D",{"$nulls":10},"Z",{"$nulls":6},"Z",{"$nulls":6},"D",{"$f":"COUNTA(Leden!$C11:$AG11)","v":6}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Leden Celkem"},{"$f":"SUBTOTAL(103,Leden!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,Leden!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,Leden!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,Leden!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,Leden!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,Leden!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,Leden!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,Leden!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,Leden[Celkový počet dnů])","v":25}]

{"sheet":"Únor","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Únor","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,1),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,2),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,3),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,4),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,5),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,6),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,7),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,8),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,9),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,10),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,11),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,12),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,13),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,14),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,15),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,16),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,17),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,18),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,19),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,20),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,21),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,22),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,23),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,24),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,25),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,26),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,27),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,28),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,2,29),1),\"aaa\")","v":"pá"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"," ","  ","Celkový počet dnů"]
[null,"Zaměstnanec 1",null,null,"D","D","D","D",{"$nulls":6},"D",{"$nulls":18},{"$f":"COUNTA(Únor[[#This Row],[1]:[29]])","v":5}]
[null,"Zaměstnanec 2",{"$nulls":4},"Z","Z",{"$nulls":4},"O",{"$nulls":8},"Z",{"$nulls":4},"D","D","D",{"$nulls":4},{"$f":"COUNTA(Únor[[#This Row],[1]:[29]])","v":7}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Únor[[#This Row],[1]:[29]])","v":0}]
[null,"Zaměstnanec 4",null,null,"Z",{"$nulls":10},"Z",{"$nulls":3},"O",{"$nulls":9},"Z",{"$nulls":3},{"$f":"COUNTA(Únor[[#This Row],[1]:[29]])","v":4}]
[null,"Zaměstnanec 5",{"$nulls":7},"D","D","D","D",{"$nulls":12},"Z",{"$nulls":7},{"$f":"COUNTA(Únor[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Únor Celkem"},{"$f":"SUBTOTAL(103,Únor[1])","v":0},{"$f":"SUBTOTAL(103,Únor[2])","v":0},{"$f":"SUBTOTAL(103,Únor[3])","v":2},{"$f":"SUBTOTAL(103,Únor[4])","v":1},{"$f":"SUBTOTAL(103,Únor[5])","v":2},{"$f":"SUBTOTAL(103,Únor[6])","v":2},{"$f":"SUBTOTAL(103,Únor[7])","v":0},{"$f":"SUBTOTAL(103,Únor[8])","v":1},{"$f":"SUBTOTAL(103,Únor[9])","v":1},{"$f":"SUBTOTAL(103,Únor[10])","v":1},{"$f":"SUBTOTAL(103,Únor[11])","v":2},{"$f":"SUBTOTAL(103,Únor[12])","v":0},{"$f":"SUBTOTAL(103,Únor[13])","v":1},{"$f":"SUBTOTAL(103,Únor[14])","v":1},{"$f":"SUBTOTAL(103,Únor[15])","v":0},{"$f":"SUBTOTAL(103,Únor[16])","v":0},{"$f":"SUBTOTAL(103,Únor[17])","v":0},{"$f":"SUBTOTAL(103,Únor[18])","v":1},{"$f":"SUBTOTAL(103,Únor[19])","v":0},{"$f":"SUBTOTAL(103,Únor[20])","v":1},{"$f":"SUBTOTAL(103,Únor[21])","v":0},{"$f":"SUBTOTAL(103,Únor[22])","v":0},{"$f":"SUBTOTAL(103,Únor[23])","v":0},{"$f":"SUBTOTAL(103,Únor[24])","v":1},{"$f":"SUBTOTAL(103,Únor[25])","v":1},{"$f":"SUBTOTAL(103,Únor[26])","v":1},{"$f":"SUBTOTAL(103,Únor[27])","v":1},{"$f":"SUBTOTAL(103,Únor[28])","v":1},{"$f":"SUBTOTAL(103,Únor[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Únor[Celkový počet dnů])","v":21}]

{"sheet":"Březen","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Březen","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,1),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,2),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,3),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,4),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,5),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,6),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,7),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,8),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,9),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,10),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,11),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,12),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,13),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,14),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,15),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,16),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,17),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,18),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,19),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,20),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,21),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,22),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,23),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,24),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,25),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,26),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,27),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,28),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,29),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,30),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,3,31),1),\"aaa\")","v":"ne"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Březen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Březen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Březen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Březen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Březen[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Březen Celkem"},{"$f":"SUBTOTAL(103,Březen[1])","v":0},{"$f":"SUBTOTAL(103,Březen[2])","v":0},{"$f":"SUBTOTAL(103,Březen[3])","v":0},{"$f":"SUBTOTAL(103,Březen[4])","v":0},{"$f":"SUBTOTAL(103,Březen[5])","v":0},{"$f":"SUBTOTAL(103,Březen[6])","v":0},{"$f":"SUBTOTAL(103,Březen[7])","v":0},{"$f":"SUBTOTAL(103,Březen[8])","v":0},{"$f":"SUBTOTAL(103,Březen[9])","v":0},{"$f":"SUBTOTAL(103,Březen[10])","v":0},{"$f":"SUBTOTAL(103,Březen[11])","v":0},{"$f":"SUBTOTAL(103,Březen[12])","v":0},{"$f":"SUBTOTAL(103,Březen[13])","v":0},{"$f":"SUBTOTAL(103,Březen[14])","v":0},{"$f":"SUBTOTAL(103,Březen[15])","v":0},{"$f":"SUBTOTAL(103,Březen[16])","v":0},{"$f":"SUBTOTAL(103,Březen[17])","v":0},{"$f":"SUBTOTAL(103,Březen[18])","v":0},{"$f":"SUBTOTAL(103,Březen[19])","v":0},{"$f":"SUBTOTAL(103,Březen[20])","v":0},{"$f":"SUBTOTAL(103,Březen[21])","v":0},{"$f":"SUBTOTAL(103,Březen[22])","v":0},{"$f":"SUBTOTAL(103,Březen[23])","v":0},{"$f":"SUBTOTAL(103,Březen[24])","v":0},{"$f":"SUBTOTAL(103,Březen[25])","v":0},{"$f":"SUBTOTAL(103,Březen[26])","v":0},{"$f":"SUBTOTAL(103,Březen[27])","v":0},{"$f":"SUBTOTAL(103,Březen[28])","v":0},{"$f":"SUBTOTAL(103,Březen[29])","v":0},{"$f":"SUBTOTAL(103,Březen[30])","v":0},{"$f":"SUBTOTAL(103,Březen[31])","v":0},{"$f":"SUBTOTAL(109,Březen[Celkový počet dnů])","v":0}]

{"sheet":"Duben","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Duben","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,1),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,2),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,3),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,4),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,5),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,6),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,7),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,8),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,9),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,10),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,11),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,12),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,13),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,14),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,15),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,16),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,17),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,18),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,19),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,20),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,21),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,22),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,23),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,24),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,25),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,26),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,27),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,28),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,29),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,4,30),1),\"aaa\")","v":"út"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Duben[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Duben[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Duben[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Duben[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Duben[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Duben Celkem"},{"$f":"SUBTOTAL(103,Duben[1])","v":0},{"$f":"SUBTOTAL(103,Duben[2])","v":0},{"$f":"SUBTOTAL(103,Duben[3])","v":0},{"$f":"SUBTOTAL(103,Duben[4])","v":0},{"$f":"SUBTOTAL(103,Duben[5])","v":0},{"$f":"SUBTOTAL(103,Duben[6])","v":0},{"$f":"SUBTOTAL(103,Duben[7])","v":0},{"$f":"SUBTOTAL(103,Duben[8])","v":0},{"$f":"SUBTOTAL(103,Duben[9])","v":0},{"$f":"SUBTOTAL(103,Duben[10])","v":0},{"$f":"SUBTOTAL(103,Duben[11])","v":0},{"$f":"SUBTOTAL(103,Duben[12])","v":0},{"$f":"SUBTOTAL(103,Duben[13])","v":0},{"$f":"SUBTOTAL(103,Duben[14])","v":0},{"$f":"SUBTOTAL(103,Duben[15])","v":0},{"$f":"SUBTOTAL(103,Duben[16])","v":0},{"$f":"SUBTOTAL(103,Duben[17])","v":0},{"$f":"SUBTOTAL(103,Duben[18])","v":0},{"$f":"SUBTOTAL(103,Duben[19])","v":0},{"$f":"SUBTOTAL(103,Duben[20])","v":0},{"$f":"SUBTOTAL(103,Duben[21])","v":0},{"$f":"SUBTOTAL(103,Duben[22])","v":0},{"$f":"SUBTOTAL(103,Duben[23])","v":0},{"$f":"SUBTOTAL(103,Duben[24])","v":0},{"$f":"SUBTOTAL(103,Duben[25])","v":0},{"$f":"SUBTOTAL(103,Duben[26])","v":0},{"$f":"SUBTOTAL(103,Duben[27])","v":0},{"$f":"SUBTOTAL(103,Duben[28])","v":0},{"$f":"SUBTOTAL(103,Duben[29])","v":0},{"$f":"SUBTOTAL(103,Duben[30])","v":0},{"$f":"SUBTOTAL(103,Duben[30])","v":0},{"$f":"SUBTOTAL(109,Duben[Celkový počet dnů])","v":0}]

{"sheet":"Květen","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Květen","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,1),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,2),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,3),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,4),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,5),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,6),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,7),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,8),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,9),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,10),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,11),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,12),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,13),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,14),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,15),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,16),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,17),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,18),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,19),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,20),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,21),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,22),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,23),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,24),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,25),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,26),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,27),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,28),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,29),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,30),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,5,31),1),\"aaa\")","v":"pá"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Květen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Květen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Květen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Květen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Květen[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Květen Celkem"},{"$f":"SUBTOTAL(103,Květen[1])","v":0},{"$f":"SUBTOTAL(103,Květen[2])","v":0},{"$f":"SUBTOTAL(103,Květen[3])","v":0},{"$f":"SUBTOTAL(103,Květen[4])","v":0},{"$f":"SUBTOTAL(103,Květen[5])","v":0},{"$f":"SUBTOTAL(103,Květen[6])","v":0},{"$f":"SUBTOTAL(103,Květen[7])","v":0},{"$f":"SUBTOTAL(103,Květen[8])","v":0},{"$f":"SUBTOTAL(103,Květen[9])","v":0},{"$f":"SUBTOTAL(103,Květen[10])","v":0},{"$f":"SUBTOTAL(103,Květen[11])","v":0},{"$f":"SUBTOTAL(103,Květen[12])","v":0},{"$f":"SUBTOTAL(103,Květen[13])","v":0},{"$f":"SUBTOTAL(103,Květen[14])","v":0},{"$f":"SUBTOTAL(103,Květen[15])","v":0},{"$f":"SUBTOTAL(103,Květen[16])","v":0},{"$f":"SUBTOTAL(103,Květen[17])","v":0},{"$f":"SUBTOTAL(103,Květen[18])","v":0},{"$f":"SUBTOTAL(103,Květen[19])","v":0},{"$f":"SUBTOTAL(103,Květen[20])","v":0},{"$f":"SUBTOTAL(103,Květen[21])","v":0},{"$f":"SUBTOTAL(103,Květen[22])","v":0},{"$f":"SUBTOTAL(103,Květen[23])","v":0},{"$f":"SUBTOTAL(103,Květen[24])","v":0},{"$f":"SUBTOTAL(103,Květen[25])","v":0},{"$f":"SUBTOTAL(103,Květen[26])","v":0},{"$f":"SUBTOTAL(103,Květen[27])","v":0},{"$f":"SUBTOTAL(103,Květen[28])","v":0},{"$f":"SUBTOTAL(103,Květen[29])","v":0},{"$f":"SUBTOTAL(103,Květen[30])","v":0},{"$f":"SUBTOTAL(103,Květen[31])","v":0},{"$f":"SUBTOTAL(109,Květen[Celkový počet dnů])","v":0}]

{"sheet":"Červen","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Červen","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,1),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,2),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,3),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,4),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,5),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,6),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,7),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,8),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,9),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,10),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,11),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,12),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,13),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,14),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,15),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,16),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,17),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,18),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,19),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,20),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,21),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,22),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,23),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,24),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,25),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,26),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,27),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,28),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,29),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,6,30),1),\"aaa\")","v":"ne"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Červen[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Červen[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Červen[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Červen[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Červen[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Červen Celkem"},{"$f":"SUBTOTAL(103,Červen[1])","v":0},{"$f":"SUBTOTAL(103,Červen[2])","v":0},{"$f":"SUBTOTAL(103,Červen[3])","v":0},{"$f":"SUBTOTAL(103,Červen[4])","v":0},{"$f":"SUBTOTAL(103,Červen[5])","v":0},{"$f":"SUBTOTAL(103,Červen[6])","v":0},{"$f":"SUBTOTAL(103,Červen[7])","v":0},{"$f":"SUBTOTAL(103,Červen[8])","v":0},{"$f":"SUBTOTAL(103,Červen[9])","v":0},{"$f":"SUBTOTAL(103,Červen[10])","v":0},{"$f":"SUBTOTAL(103,Červen[11])","v":0},{"$f":"SUBTOTAL(103,Červen[12])","v":0},{"$f":"SUBTOTAL(103,Červen[13])","v":0},{"$f":"SUBTOTAL(103,Červen[14])","v":0},{"$f":"SUBTOTAL(103,Červen[15])","v":0},{"$f":"SUBTOTAL(103,Červen[16])","v":0},{"$f":"SUBTOTAL(103,Červen[17])","v":0},{"$f":"SUBTOTAL(103,Červen[18])","v":0},{"$f":"SUBTOTAL(103,Červen[19])","v":0},{"$f":"SUBTOTAL(103,Červen[20])","v":0},{"$f":"SUBTOTAL(103,Červen[21])","v":0},{"$f":"SUBTOTAL(103,Červen[22])","v":0},{"$f":"SUBTOTAL(103,Červen[23])","v":0},{"$f":"SUBTOTAL(103,Červen[24])","v":0},{"$f":"SUBTOTAL(103,Červen[25])","v":0},{"$f":"SUBTOTAL(103,Červen[26])","v":0},{"$f":"SUBTOTAL(103,Červen[27])","v":0},{"$f":"SUBTOTAL(103,Červen[28])","v":0},{"$f":"SUBTOTAL(103,Červen[29])","v":0},{"$f":"SUBTOTAL(103,Červen[30])","v":0},{"$f":"SUBTOTAL(103,Červen[[ ]])","v":0},{"$f":"SUBTOTAL(109,Červen[Celkový počet dnů])","v":0}]

{"sheet":"Červenec","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Červenec","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,1),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,2),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,3),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,4),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,5),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,6),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,7),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,8),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,9),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,10),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,11),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,12),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,13),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,14),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,15),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,16),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,17),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,18),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,19),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,20),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,21),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,22),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,23),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,24),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,25),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,26),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,27),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,28),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,29),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,30),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,7,31),1),\"aaa\")","v":"st"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Červenec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Červenec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Červenec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Červenec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Červenec[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Červenec Celkem"},{"$f":"SUBTOTAL(103,Červenec[1])","v":0},{"$f":"SUBTOTAL(103,Červenec[2])","v":0},{"$f":"SUBTOTAL(103,Červenec[3])","v":0},{"$f":"SUBTOTAL(103,Červenec[4])","v":0},{"$f":"SUBTOTAL(103,Červenec[5])","v":0},{"$f":"SUBTOTAL(103,Červenec[6])","v":0},{"$f":"SUBTOTAL(103,Červenec[7])","v":0},{"$f":"SUBTOTAL(103,Červenec[8])","v":0},{"$f":"SUBTOTAL(103,Červenec[9])","v":0},{"$f":"SUBTOTAL(103,Červenec[10])","v":0},{"$f":"SUBTOTAL(103,Červenec[11])","v":0},{"$f":"SUBTOTAL(103,Červenec[12])","v":0},{"$f":"SUBTOTAL(103,Červenec[13])","v":0},{"$f":"SUBTOTAL(103,Červenec[14])","v":0},{"$f":"SUBTOTAL(103,Červenec[15])","v":0},{"$f":"SUBTOTAL(103,Červenec[16])","v":0},{"$f":"SUBTOTAL(103,Červenec[17])","v":0},{"$f":"SUBTOTAL(103,Červenec[18])","v":0},{"$f":"SUBTOTAL(103,Červenec[19])","v":0},{"$f":"SUBTOTAL(103,Červenec[20])","v":0},{"$f":"SUBTOTAL(103,Červenec[21])","v":0},{"$f":"SUBTOTAL(103,Červenec[22])","v":0},{"$f":"SUBTOTAL(103,Červenec[23])","v":0},{"$f":"SUBTOTAL(103,Červenec[24])","v":0},{"$f":"SUBTOTAL(103,Červenec[25])","v":0},{"$f":"SUBTOTAL(103,Červenec[26])","v":0},{"$f":"SUBTOTAL(103,Červenec[27])","v":0},{"$f":"SUBTOTAL(103,Červenec[28])","v":0},{"$f":"SUBTOTAL(103,Červenec[29])","v":0},{"$f":"SUBTOTAL(103,Červenec[30])","v":0},{"$f":"SUBTOTAL(103,Červenec[31])","v":0},{"$f":"SUBTOTAL(109,Červenec[Celkový počet dnů])","v":0}]

{"sheet":"Srpen","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Srpen","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,1),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,2),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,3),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,4),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,5),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,6),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,7),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,8),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,9),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,10),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,11),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,12),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,13),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,14),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,15),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,16),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,17),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,18),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,19),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,20),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,21),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,22),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,23),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,24),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,25),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,26),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,27),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,28),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,29),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,30),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,8,31),1),\"aaa\")","v":"so"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Srpen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Srpen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Srpen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Srpen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Srpen[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Srpen Celkem"},{"$f":"SUBTOTAL(103,Srpen[1])","v":0},{"$f":"SUBTOTAL(103,Srpen[2])","v":0},{"$f":"SUBTOTAL(103,Srpen[3])","v":0},{"$f":"SUBTOTAL(103,Srpen[4])","v":0},{"$f":"SUBTOTAL(103,Srpen[5])","v":0},{"$f":"SUBTOTAL(103,Srpen[6])","v":0},{"$f":"SUBTOTAL(103,Srpen[7])","v":0},{"$f":"SUBTOTAL(103,Srpen[8])","v":0},{"$f":"SUBTOTAL(103,Srpen[9])","v":0},{"$f":"SUBTOTAL(103,Srpen[10])","v":0},{"$f":"SUBTOTAL(103,Srpen[11])","v":0},{"$f":"SUBTOTAL(103,Srpen[12])","v":0},{"$f":"SUBTOTAL(103,Srpen[13])","v":0},{"$f":"SUBTOTAL(103,Srpen[14])","v":0},{"$f":"SUBTOTAL(103,Srpen[15])","v":0},{"$f":"SUBTOTAL(103,Srpen[16])","v":0},{"$f":"SUBTOTAL(103,Srpen[17])","v":0},{"$f":"SUBTOTAL(103,Srpen[18])","v":0},{"$f":"SUBTOTAL(103,Srpen[19])","v":0},{"$f":"SUBTOTAL(103,Srpen[20])","v":0},{"$f":"SUBTOTAL(103,Srpen[21])","v":0},{"$f":"SUBTOTAL(103,Srpen[22])","v":0},{"$f":"SUBTOTAL(103,Srpen[23])","v":0},{"$f":"SUBTOTAL(103,Srpen[24])","v":0},{"$f":"SUBTOTAL(103,Srpen[25])","v":0},{"$f":"SUBTOTAL(103,Srpen[26])","v":0},{"$f":"SUBTOTAL(103,Srpen[27])","v":0},{"$f":"SUBTOTAL(103,Srpen[28])","v":0},{"$f":"SUBTOTAL(103,Srpen[29])","v":0},{"$f":"SUBTOTAL(103,Srpen[30])","v":0},{"$f":"SUBTOTAL(103,Srpen[31])","v":0},{"$f":"SUBTOTAL(109,Srpen[Celkový počet dnů])","v":0}]

{"sheet":"Září","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Září","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,1),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,2),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,3),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,4),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,5),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,6),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,7),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,8),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,9),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,10),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,11),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,12),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,13),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,14),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,15),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,16),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,17),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,18),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,19),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,20),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,21),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,22),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,23),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,24),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,25),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,26),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,27),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,28),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,29),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,9,30),1),\"aaa\")","v":"po"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Září[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Září[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Září[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Září[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Září[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Září Celkem"},{"$f":"SUBTOTAL(103,Září[1])","v":0},{"$f":"SUBTOTAL(103,Září[2])","v":0},{"$f":"SUBTOTAL(103,Září[3])","v":0},{"$f":"SUBTOTAL(103,Září[4])","v":0},{"$f":"SUBTOTAL(103,Září[5])","v":0},{"$f":"SUBTOTAL(103,Září[6])","v":0},{"$f":"SUBTOTAL(103,Září[7])","v":0},{"$f":"SUBTOTAL(103,Září[8])","v":0},{"$f":"SUBTOTAL(103,Září[9])","v":0},{"$f":"SUBTOTAL(103,Září[10])","v":0},{"$f":"SUBTOTAL(103,Září[11])","v":0},{"$f":"SUBTOTAL(103,Září[12])","v":0},{"$f":"SUBTOTAL(103,Září[13])","v":0},{"$f":"SUBTOTAL(103,Září[14])","v":0},{"$f":"SUBTOTAL(103,Září[15])","v":0},{"$f":"SUBTOTAL(103,Září[16])","v":0},{"$f":"SUBTOTAL(103,Září[17])","v":0},{"$f":"SUBTOTAL(103,Září[18])","v":0},{"$f":"SUBTOTAL(103,Září[19])","v":0},{"$f":"SUBTOTAL(103,Září[20])","v":0},{"$f":"SUBTOTAL(103,Září[21])","v":0},{"$f":"SUBTOTAL(103,Září[22])","v":0},{"$f":"SUBTOTAL(103,Září[23])","v":0},{"$f":"SUBTOTAL(103,Září[24])","v":0},{"$f":"SUBTOTAL(103,Září[25])","v":0},{"$f":"SUBTOTAL(103,Září[26])","v":0},{"$f":"SUBTOTAL(103,Září[27])","v":0},{"$f":"SUBTOTAL(103,Září[28])","v":0},{"$f":"SUBTOTAL(103,Září[29])","v":0},{"$f":"SUBTOTAL(103,Září[30])","v":0},{"$f":"SUBTOTAL(103,Září[[ ]])","v":0},{"$f":"SUBTOTAL(109,Září[Celkový počet dnů])","v":0}]

{"sheet":"Říjen","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Říjen","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,1),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,2),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,3),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,4),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,5),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,6),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,7),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,8),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,9),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,10),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,11),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,12),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,13),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,14),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,15),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,16),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,17),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,18),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,19),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,20),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,21),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,22),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,23),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,24),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,25),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,26),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,27),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,28),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,29),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,30),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,10,31),1),\"aaa\")","v":"čt"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Říjen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Říjen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Říjen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Říjen[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Říjen[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Říjen Celkem"},{"$f":"SUBTOTAL(103,Říjen[1])","v":0},{"$f":"SUBTOTAL(103,Říjen[2])","v":0},{"$f":"SUBTOTAL(103,Říjen[3])","v":0},{"$f":"SUBTOTAL(103,Říjen[4])","v":0},{"$f":"SUBTOTAL(103,Říjen[5])","v":0},{"$f":"SUBTOTAL(103,Říjen[6])","v":0},{"$f":"SUBTOTAL(103,Říjen[7])","v":0},{"$f":"SUBTOTAL(103,Říjen[8])","v":0},{"$f":"SUBTOTAL(103,Říjen[9])","v":0},{"$f":"SUBTOTAL(103,Říjen[10])","v":0},{"$f":"SUBTOTAL(103,Říjen[11])","v":0},{"$f":"SUBTOTAL(103,Říjen[12])","v":0},{"$f":"SUBTOTAL(103,Říjen[13])","v":0},{"$f":"SUBTOTAL(103,Říjen[14])","v":0},{"$f":"SUBTOTAL(103,Říjen[15])","v":0},{"$f":"SUBTOTAL(103,Říjen[16])","v":0},{"$f":"SUBTOTAL(103,Říjen[17])","v":0},{"$f":"SUBTOTAL(103,Říjen[18])","v":0},{"$f":"SUBTOTAL(103,Říjen[19])","v":0},{"$f":"SUBTOTAL(103,Říjen[20])","v":0},{"$f":"SUBTOTAL(103,Říjen[21])","v":0},{"$f":"SUBTOTAL(103,Říjen[22])","v":0},{"$f":"SUBTOTAL(103,Říjen[23])","v":0},{"$f":"SUBTOTAL(103,Říjen[24])","v":0},{"$f":"SUBTOTAL(103,Říjen[25])","v":0},{"$f":"SUBTOTAL(103,Říjen[26])","v":0},{"$f":"SUBTOTAL(103,Říjen[27])","v":0},{"$f":"SUBTOTAL(103,Říjen[28])","v":0},{"$f":"SUBTOTAL(103,Říjen[29])","v":0},{"$f":"SUBTOTAL(103,Říjen[30])","v":0},{"$f":"SUBTOTAL(103,Říjen[31])","v":0},{"$f":"SUBTOTAL(109,Říjen[Celkový počet dnů])","v":0}]

{"sheet":"Listopad","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Listopad","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,1),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,2),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,3),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,4),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,5),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,6),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,7),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,8),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,9),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,10),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,11),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,12),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,13),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,14),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,15),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,16),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,17),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,18),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,19),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,20),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,21),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,22),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,23),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,24),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,25),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,26),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,27),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,28),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,29),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,11,30),1),\"aaa\")","v":"so"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Listopad[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Listopad[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Listopad[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Listopad[[#This Row],[1]:[30]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Listopad[[#This Row],[1]:[30]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Listopad Celkem"},{"$f":"SUBTOTAL(103,Listopad[1])","v":0},{"$f":"SUBTOTAL(103,Listopad[2])","v":0},{"$f":"SUBTOTAL(103,Listopad[3])","v":0},{"$f":"SUBTOTAL(103,Listopad[4])","v":0},{"$f":"SUBTOTAL(103,Listopad[5])","v":0},{"$f":"SUBTOTAL(103,Listopad[6])","v":0},{"$f":"SUBTOTAL(103,Listopad[7])","v":0},{"$f":"SUBTOTAL(103,Listopad[8])","v":0},{"$f":"SUBTOTAL(103,Listopad[9])","v":0},{"$f":"SUBTOTAL(103,Listopad[10])","v":0},{"$f":"SUBTOTAL(103,Listopad[11])","v":0},{"$f":"SUBTOTAL(103,Listopad[12])","v":0},{"$f":"SUBTOTAL(103,Listopad[13])","v":0},{"$f":"SUBTOTAL(103,Listopad[14])","v":0},{"$f":"SUBTOTAL(103,Listopad[15])","v":0},{"$f":"SUBTOTAL(103,Listopad[16])","v":0},{"$f":"SUBTOTAL(103,Listopad[17])","v":0},{"$f":"SUBTOTAL(103,Listopad[18])","v":0},{"$f":"SUBTOTAL(103,Listopad[19])","v":0},{"$f":"SUBTOTAL(103,Listopad[20])","v":0},{"$f":"SUBTOTAL(103,Listopad[21])","v":0},{"$f":"SUBTOTAL(103,Listopad[22])","v":0},{"$f":"SUBTOTAL(103,Listopad[23])","v":0},{"$f":"SUBTOTAL(103,Listopad[24])","v":0},{"$f":"SUBTOTAL(103,Listopad[25])","v":0},{"$f":"SUBTOTAL(103,Listopad[26])","v":0},{"$f":"SUBTOTAL(103,Listopad[27])","v":0},{"$f":"SUBTOTAL(103,Listopad[28])","v":0},{"$f":"SUBTOTAL(103,Listopad[29])","v":0},{"$f":"SUBTOTAL(103,Listopad[30])","v":0},{"$f":"SUBTOTAL(103,Listopad[[ ]])","v":0},{"$f":"SUBTOTAL(109,Listopad[Celkový počet dnů])","v":0}]

{"sheet":"Prosinec","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,4],[1,6,1,8],[1,10,1,13],[1,15,1,16],[1,18,1,19],[3,2,3,32]]}
[null,{"$f":"Název_nepřítomnosti_zaměstnanců","v":"Plán Nepřítomnosti Zaměstnanců"}]
[null,"Klíč typu nepřítomnosti","D","Dovolená",null,"O","Osobní důvody",null,null,"Z","Zdravotní neschopnost",{"$nulls":4},"Vlastní 1",null,null,"Vlastní 2"]
[]
[null,"Prosinec","Data nepřítomnosti",{"$nulls":30},{"$f":"KalendářníRok","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,1),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,2),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,3),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,4),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,5),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,6),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,7),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,8),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,9),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,10),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,11),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,12),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,13),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,14),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,15),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,16),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,17),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,18),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,19),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,20),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,21),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,22),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,23),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,24),1),\"aaa\")","v":"út"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,25),1),\"aaa\")","v":"st"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,26),1),\"aaa\")","v":"čt"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,27),1),\"aaa\")","v":"pá"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,28),1),\"aaa\")","v":"so"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,29),1),\"aaa\")","v":"ne"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,30),1),\"aaa\")","v":"po"},{"$f":"TEXT(WEEKDAY(DATE(KalendářníRok,12,31),1),\"aaa\")","v":"út"}]
[null,"Jméno zaměstnance","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","Celkový počet dnů"]
[null,"Zaměstnanec 1",{"$nulls":31},{"$f":"COUNTA(Prosinec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 2",{"$nulls":31},{"$f":"COUNTA(Prosinec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 3",{"$nulls":31},{"$f":"COUNTA(Prosinec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 4",{"$nulls":31},{"$f":"COUNTA(Prosinec[[#This Row],[1]:[31]])","v":0}]
[null,"Zaměstnanec 5",{"$nulls":31},{"$f":"COUNTA(Prosinec[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"NázevMěsíce&\" Celkem\"","v":"Prosinec Celkem"},{"$f":"SUBTOTAL(103,Prosinec[1])","v":0},{"$f":"SUBTOTAL(103,Prosinec[2])","v":0},{"$f":"SUBTOTAL(103,Prosinec[3])","v":0},{"$f":"SUBTOTAL(103,Prosinec[4])","v":0},{"$f":"SUBTOTAL(103,Prosinec[5])","v":0},{"$f":"SUBTOTAL(103,Prosinec[6])","v":0},{"$f":"SUBTOTAL(103,Prosinec[7])","v":0},{"$f":"SUBTOTAL(103,Prosinec[8])","v":0},{"$f":"SUBTOTAL(103,Prosinec[9])","v":0},{"$f":"SUBTOTAL(103,Prosinec[10])","v":0},{"$f":"SUBTOTAL(103,Prosinec[11])","v":0},{"$f":"SUBTOTAL(103,Prosinec[12])","v":0},{"$f":"SUBTOTAL(103,Prosinec[13])","v":0},{"$f":"SUBTOTAL(103,Prosinec[14])","v":0},{"$f":"SUBTOTAL(103,Prosinec[15])","v":0},{"$f":"SUBTOTAL(103,Prosinec[16])","v":0},{"$f":"SUBTOTAL(103,Prosinec[17])","v":0},{"$f":"SUBTOTAL(103,Prosinec[18])","v":0},{"$f":"SUBTOTAL(103,Prosinec[19])","v":0},{"$f":"SUBTOTAL(103,Prosinec[20])","v":0},{"$f":"SUBTOTAL(103,Prosinec[21])","v":0},{"$f":"SUBTOTAL(103,Prosinec[22])","v":0},{"$f":"SUBTOTAL(103,Prosinec[23])","v":0},{"$f":"SUBTOTAL(103,Prosinec[24])","v":0},{"$f":"SUBTOTAL(103,Prosinec[25])","v":0},{"$f":"SUBTOTAL(103,Prosinec[26])","v":0},{"$f":"SUBTOTAL(103,Prosinec[27])","v":0},{"$f":"SUBTOTAL(103,Prosinec[28])","v":0},{"$f":"SUBTOTAL(103,Prosinec[29])","v":0},{"$f":"SUBTOTAL(103,Prosinec[30])","v":0},{"$f":"SUBTOTAL(103,Prosinec[31])","v":0},{"$f":"SUBTOTAL(109,Prosinec[Celkový počet dnů])","v":0}]

{"sheet":"Jména zaměstnanců","index":12,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[1,14,1,15]]}
[null,"Jména zaměstnanců"]
[]
[null,"Jména zaměstnanců"]
[null,"Zaměstnanec 1"]
[null,"Zaměstnanec 2"]
[null,"Zaměstnanec 3"]
[null,"Zaměstnanec 4"]
[null,"Zaměstnanec 5"]