{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["HS1-XYZ"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"HS1-XYZ","index":0,"n_rows":57,"n_cols":100,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,5,56,8],[56,15,56,18],[56,60,56,62],[49,1,50,16],[54,11,54,28],[54,29,54,32],[54,33,54,35],[54,57,54,60],[55,11,55,14],[55,23,55,24],[55,40,55,44],[55,57,55,60],[48,1,48,16],[43,1,43,6],[43,26,43,29],[43,49,43,52],[43,53,43,56],[44,1,44,64],[45,1,45,64],[46,1,46,6],[46,7,46,64],[47,1,47,64],[41,1,41,6],[41,26,41,29],[41,49,41,52],[41,53,41,56],[41,57,41,60],[41,61,41,64],[43,57,43,60],[43,61,43,64],[42,1,42,6],[42,26,42,29],[42,49,42,52],[42,53,42,56],[42,57,42,60],[42,61,42,64],[39,57,39,60],[39,61,39,64],[40,26,40,29],[40,37,40,40],[40,41,40,44],[40,45,40,48],[40,49,40,52],[40,53,40,56],[40,57,40,60],[39,30,39,33],[39,34,39,36],[39,37,39,40],[39,41,39,44],[39,45,39,48],[39,49,39,52],[40,61,40,64],[39,26,39,29],[38,41,38,44],[38,45,38,48],[38,49,38,52],[38,53,38,56],[39,1,39,2],[39,3,39,10],[39,11,39,19],[39,20,39,22],[39,23,39,25],[39,53,39,56],[36,41,36,44],[36,45,36,48],[38,57,38,60],[38,61,38,64],[37,61,37,64],[38,1,38,2],[38,3,38,10],[38,11,38,19],[38,20,38,22],[38,23,38,25],[38,26,38,29],[38,30,38,33],[38,34,38,36],[38,37,38,40],[37,37,37,40],[37,41,37,44],[37,45,37,48],[37,49,37,52],[37,1,37,2],[37,3,37,10],[37,11,37,19],[37,20,37,22],[37,23,37,25],[37,26,37,29],[37,30,37,33],[37,34,37,36],[36,34,36,36],[36,49,36,52],[36,53,36,56],[35,53,35,56],[35,57,35,60],[35,61,35,64],[37,53,37,56],[37,57,37,60],[36,57,36,60],[36,61,36,64],[36,26,36,29],[36,30,36,33],[35,30,35,33],[35,34,35,36],[35,37,35,40],[36,1,36,2],[36,3,36,10],[36,11,36,19],[36,20,36,22],[36,23,36,25],[36,37,36,40],[35,41,35,44],[35,45,35,48],[35,49,35,52],[35,1,35,2],[35,3,35,10],[35,11,35,19],[35,20,35,22],[35,23,35,25],[35,26,35,29],[34,61,34,64],[33,61,33,64],[34,1,34,2],[34,3,34,10],[34,11,34,19],[34,20,34,22],[34,23,34,25],[34,26,34,29],[34,30,34,33],[34,34,34,36],[34,37,34,40],[33,37,33,40],[33,41,33,44],[33,45,33,48],[33,49,33,52],[33,53,33,56],[34,41,34,44],[34,45,34,48],[34,49,34,52],[34,53,34,56],[34,57,34,60],[33,57,33,60],[32,57,32,60],[32,61,32,64],[33,1,33,2],[33,3,33,10],[33,11,33,19],[33,20,33,22],[33,23,33,25],[33,26,33,29],[33,30,33,33],[33,34,33,36],[32,34,32,36],[32,37,32,40],[32,41,32,44],[32,45,32,48],[32,49,32,52],[31,57,31,60],[31,61,31,64],[32,1,32,2],[32,3,32,10],[32,11,32,19],[32,20,32,22],[32,23,32,25],[32,26,32,29],[32,30,32,33],[31,30,31,33],[31,34,31,36],[31,37,31,40],[31,41,31,44],[31,45,31,48],[31,49,31,52],[31,1,31,2],[31,3,31,10],[31,11,31,19],[31,20,31,22],[31,23,31,25],[31,26,31,29],[32,53,32,56],[31,53,31,56],[30,61,30,64],[29,61,29,64],[30,1,30,2],[30,3,30,10],[30,11,30,19],[30,20,30,22],[30,23,30,25],[30,26,30,29],[30,30,30,33],[30,34,30,36],[30,37,30,40],[29,37,29,40],[29,41,29,44],[29,45,29,48],[29,49,29,52],[29,53,29,56],[30,41,30,44],[30,45,30,48],[30,49,30,52],[30,53,30,56],[30,57,30,60],[29,57,29,60],[28,57,28,60],[28,61,28,64],[29,1,29,2],[29,3,29,10],[29,11,29,19],[29,20,29,22],[29,23,29,25],[29,26,29,29],[29,30,29,33],[29,34,29,36],[28,34,28,36],[28,37,28,40],[28,41,28,44],[28,45,28,48],[28,49,28,52],[27,57,27,60],[27,61,27,64],[28,1,28,2],[28,3,28,10],[28,11,28,19],[28,20,28,22],[28,23,28,25],[28,26,28,29],[28,30,28,33],[27,30,27,33],[27,34,27,36],[27,37,27,40],[27,41,27,44],[27,45,27,48],[27,49,27,52],[27,1,27,2],[27,3,27,10],[27,11,27,19],[27,20,27,22],[27,23,27,25],[27,26,27,29],[28,53,28,56],[27,53,27,56],[26,61,26,64],[25,61,25,64],[26,1,26,2],[26,3,26,10],[26,11,26,19],[26,20,26,22],[26,23,26,25],[26,26,26,29],[26,30,26,33],[26,34,26,36],[26,37,26,40],[25,37,25,40],[25,41,25,44],[25,45,25,48],[25,49,25,52],[25,53,25,56],[26,41,26,44],[26,45,26,48],[26,49,26,52],[26,53,26,56],[26,57,26,60],[25,57,25,60],[24,57,24,60],[24,61,24,64],[25,1,25,2],[25,3,25,10],[25,11,25,19],[25,20,25,22],[25,23,25,25],[25,26,25,29],[25,30,25,33],[25,34,25,36],[24,34,24,36],[24,37,24,40],[24,41,24,44],[24,45,24,48],[24,49,24,52],[23,57,23,60],[23,61,23,64],[24,1,24,2],[24,3,24,10],[24,11,24,19],[24,20,24,22],[24,23,24,25],[24,26,24,29],[24,30,24,33],[23,30,23,33],[23,34,23,36],[23,37,23,40],[23,41,23,44],[23,45,23,48],[23,49,23,52],[23,1,23,2],[23,3,23,10],[23,11,23,19],[23,20,23,22],[23,23,23,25],[23,26,23,29],[24,53,24,56],[23,53,23,56],[22,61,22,64],[21,61,21,64],[22,1,22,2],[22,3,22,10],[22,11,22,19],[22,20,22,22],[22,23,22,25],[22,26,22,29],[22,30,22,33],[22,34,22,36],[22,37,22,40],[21,37,21,40],[21,41,21,44],[21,45,21,48],[21,49,21,52],[21,53,21,56],[22,41,22,44],[22,45,22,48],[22,49,22,52],[22,53,22,56],[22,57,22,60],[21,57,21,60],[20,57,20,60],[20,61,20,64],[21,1,21,2],[21,3,21,10],[21,11,21,19],[21,20,21,22],[21,23,21,25],[21,26,21,29],[21,30,21,33],[21,34,21,36],[20,34,20,36],[20,37,20,40],[20,41,20,44],[20,45,20,48],[20,49,20,52],[19,57,19,60],[19,61,19,64],[20,1,20,2],[20,3,20,10],[20,11,20,19],[20,20,20,22],[20,23,20,25],[20,26,20,29],[20,30,20,33],[19,30,19,33],[19,34,19,36],[19,37,19,40],[19,41,19,44],[19,45,19,48],[19,49,19,52],[19,1,19,2],[19,3,19,10],[19,11,19,19],[19,20,19,22],[19,23,19,25],[19,26,19,29],[20,53,20,56],[19,53,19,56],[18,61,18,64],[17,61,17,64],[18,1,18,2],[18,3,18,10],[18,11,18,19],[18,20,18,22],[18,23,18,25],[18,26,18,29],[18,30,18,33],[18,34,18,36],[18,37,18,40],[17,37,17,40],[17,41,17,44],[17,45,17,48],[17,49,17,52],[17,53,17,56],[18,41,18,44],[18,45,18,48],[18,49,18,52],[18,53,18,56],[18,57,18,60],[17,57,17,60],[16,57,16,60],[16,61,16,64],[17,1,17,2],[17,3,17,10],[17,11,17,19],[17,20,17,22],[17,23,17,25],[17,26,17,29],[17,30,17,33],[17,34,17,36],[16,34,16,36],[16,37,16,40],[16,41,16,44],[16,45,16,48],[16,49,16,52],[15,57,15,60],[15,61,15,64],[16,1,16,2],[16,3,16,10],[16,11,16,19],[16,20,16,22],[16,23,16,25],[16,26,16,29],[16,30,16,33],[15,30,15,33],[15,34,15,36],[15,37,15,40],[15,41,15,44],[15,45,15,48],[15,49,15,52],[15,1,15,2],[15,3,15,10],[15,11,15,19],[15,20,15,22],[15,23,15,25],[15,26,15,29],[16,53,16,56],[15,53,15,56],[14,61,14,64],[13,61,13,64],[14,1,14,2],[14,3,14,10],[14,11,14,19],[14,20,14,22],[14,23,14,25],[14,26,14,29],[14,30,14,33],[14,34,14,36],[14,37,14,40],[13,37,13,40],[13,41,13,44],[13,45,13,48],[13,49,13,52],[13,53,13,56],[14,41,14,44],[14,45,14,48],[14,49,14,52],[14,53,14,56],[14,57,14,60],[13,57,13,60],[12,57,12,60],[12,61,12,64],[13,1,13,2],[13,3,13,10],[13,11,13,19],[13,20,13,22],[13,23,13,25],[13,26,13,29],[13,30,13,33],[13,34,13,36],[12,34,12,36],[12,37,12,40],[12,41,12,44],[12,45,12,48],[12,49,12,52],[11,57,11,60],[11,61,11,64],[12,1,12,2],[12,3,12,10],[12,11,12,19],[12,20,12,22],[12,23,12,25],[12,26,12,29],[12,30,12,33],[11,30,11,33],[11,34,11,36],[11,37,11,40],[11,41,11,44],[11,45,11,48],[11,49,11,52],[11,1,11,2],[11,3,11,10],[11,11,11,19],[11,20,11,22],[11,23,11,25],[11,26,11,29],[12,53,12,56],[11,53,11,56],[10,61,10,64],[9,61,9,64],[10,1,10,2],[10,3,10,10],[10,11,10,19],[10,20,10,22],[10,23,10,25],[10,26,10,29],[10,30,10,33],[10,34,10,36],[10,37,10,40],[9,37,9,40],[9,41,9,44],[9,45,9,48],[9,49,9,52],[9,53,9,56],[10,41,10,44],[10,45,10,48],[10,49,10,52],[10,53,10,56],[10,57,10,60],[9,57,9,60],[8,53,8,56],[8,57,8,60],[9,1,9,2],[9,3,9,10],[9,11,9,19],[9,20,9,22],[9,23,9,25],[9,26,9,29],[9,30,9,33],[9,34,9,36],[7,1,8,2],[7,3,8,10],[7,11,8,19],[7,20,8,22],[7,23,8,25],[7,26,8,29],[5,13,5,16],[5,29,5,32],[5,45,5,48],[5,61,5,64],[6,13,6,16],[6,29,6,32],[6,45,6,48],[6,61,6,64],[7,30,7,33],[7,34,7,36],[7,37,7,48],[7,49,7,60],[7,61,8,64],[8,30,8,36],[8,37,8,40],[8,41,8,44],[8,45,8,48],[8,49,8,52],[3,1,4,5],[3,6,4,10],[3,23,3,25],[3,38,3,40],[3,41,3,48],[0,31,0,35],[2,1,2,10],[2,23,2,25],[2,38,2,40],[2,41,2,64],[3,49,3,56],[3,57,3,64],[4,23,4,25],[4,38,4,40],[4,41,4,48],[4,49,4,56],[4,57,4,64]]}
[null,null,"Pracovní lístek",{"$nulls":16},"měsíc:",{"$f":"IF(F57<7,IF(F57=1,\" leden\",IF(F57=2,\" únor\",IF(F57=3,\" březen\",IF(F57=4,\" duben\",IF(F57=5,\" květen\",\" červen\"))))),IF(F57=7,\"červenec\",IF(F57=8,\" srpen\",IF(F57=9,\" září\",IF(F57=10,\" říjen\",IF(F57=11,\"listopad\",\"prosinec\"))))))","v":" srpen"},{"$nulls":9},"rok:",{"$f":"P57","v":2021},{"$nulls":13},"jméno a příjmení:",{"$f":"L55","v":"Xyz Xyz"}]
[]
[null,"pracovní doba:",{"$nulls":20},"pracovní fond vč. svátků",22,{"$nulls":13},"nemoc, OČR",{"$f":"BY41","v":0},null,null,{"$f":"IF(BI57=-9.99,\"Dohoda o pracovní činnosti\",IF(BF56=0,\"Dohoda o provedení práce\",\"dovolená - ve dnech\"))","v":"dovolená - ve dnech"}]
[null,{"$f":"IF(BF56=0,0.00001,BF56)","v":8},{"$nulls":4},"hodin",{"$nulls":15},"dovolená",{"$f":"BW41","v":0},{"$nulls":13},"ostatní placené dny",{"$f":"IF((BX41+BZ41+CB41)>0,(BX41+BZ41+CB41)/B$4,0)","v":0},null,null,{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",\"nárok k 1.\"&F57&\".\"&RIGHT(P57,2))","v":"nárok k 1.8.21"},{"$nulls":7},{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",\"čerpání\")","v":"čerpání"},{"$nulls":7},{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",\"zbývá\")","v":"zbývá"}]
[{"$nulls":22},"svátek",{"$f":"BV41","v":0},{"$nulls":13},"ostatní neplacené dny",{"$f":"CA41+CC41","v":0},null,null,{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",BI57)","v":13},{"$nulls":7},{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",X4)","v":0},{"$nulls":7},{"$f":"IF(OR(BI57=-9.99,BF56=0),\"\",AP5-AX5)","v":13},{"$nulls":24},"Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby","Chyby"]
[{"$nulls":12},"měsíční odměny ",{"$nulls":15},{"$f":"IF(J57=\"H\",\"pololetní odměny \",\"roční odměny \")","v":"pololetní odměny "},{"$nulls":15},{"$f":"IF(J57=\"H\",\"roční odměny \",IF(J57=\"D\",\"aktivní prodej \",\"mimořádné odměny \"))","v":"roční odměny "},{"$nulls":15},{"$f":"IF(J57=\"H\",\"ostatní odměny \",\"náhr. cestovních výloh \")","v":"ostatní odměny "},{"$nulls":21},"jen HS !!"]
[{"$nulls":12},{"$f":"IF(J57=\"N\",\"měsíční prémie \",IF(OR(J57=\"D\",J57=\"T\",J57=\"S\",J57=\"Z\"),\"odebrané stravenky \",\"osobní ohodnocení \"))","v":"osobní ohodnocení "},6000,{"$nulls":14},{"$f":"IF(J57=\"H\",\"příplatek za vedení \",IF(J57=\"N\",\"hodinové prémie \",IF(J57=\"T\",\"osobní prémie v % \",\"osobní prémie \")))","v":"příplatek za vedení "},{"$nulls":15},{"$f":"IF(J57=\"H\",\"specializační příplatek \",\"osobní ohodnocení \")","v":"specializační příplatek "},2800,{"$nulls":14},{"$f":"IF(J57=\"H\",\"ostatní příplatky \",\"příplatek za prostředí \")","v":"ostatní příplatky "},1100,{"$nulls":4},"přípl.","práce ve sv.v","příplatek za","příplatek za","příplatek za","snížení doby","přerušení a pr.","svátek ve","dovolená","lékař","nemoc, OČR","služební","neplacené","ostatní plac.","ostatní neplac.","náhrady","práce při  PR","práce po 24 h","přerušení","neodpracované","nepřípustné","nepřípustné","nepřípustné","délka","služební cesta","služební cesta","neodpr.+ odpr.","zadáno neodpr.","zápis do","diety nebo","HS-prohození","HS-prohození","vyplněno jen","příspěvek na"]
[null,"den",null,{"$f":"IF(J57=\"R\",\"činnost 1                    / \",\"\")&\"místo\"","v":"místo"},{"$nulls":7},{"$f":"\"činnost\"&IF(J57=\"R\",\" 2\",\"\")","v":"činnost"},{"$nulls":8},"od",null,null,"do",null,null,"hodiny  přít.",null,null,null,"hodiny",null,null,null," důvod ",null,null,"příplatky",{"$nulls":11},{"$f":"IF(OR(J57=\"D\",J57=\"S\",J57=\"T\",J57=\"Z\"),IF(U$57=\"ano\",\"směnové příplatky\",\"---\"),\"pohotovost\")","v":"pohotovost"},{"$nulls":11},"Diety / stravné",{"$nulls":4},"odp.","pracovní době","svátek","noc","so + ne","o přestávky","přes půlnoc","všední den",null,"doprovod",null,"cesta","volno, vč. \"A\"","nepřítomnost","nepřítomnost","60%, 80%","pohotovosti"," poslední den","práce","hod.ve volnu","znaky - důvod","rozmezí hodin","hodnoty hodin","dovolené","kratší než 5 h","víc, než práce","hodin je víc","bez hodin","nexist. dne","stravné","MP I","MP II","\"od\" nebo \"do\"","stravování"]
[{"$nulls":30},"nepřítomnosti",{"$nulls":6},{"$f":"IF(U$57=\"ano\",\"---\",\"noc\")","v":"noc"},null,null,null,"so+ne",null,null,null,"svátek",null,null,null,{"$f":"IF(J57=\"H\",\"MP I\",IF(OR(J57=\"D\",J57=\"S\",J57=\"T\",J57=\"Z\"),IF(T$57=\"ano\",\"odp.\",\"---\"),\"15%\"))","v":"MP I"},null,null,null,{"$f":"IF(J57=\"H\",\"MP II\",IF(OR(J57=\"D\",J57=\"S\",J57=\"T\",J57=\"Z\"),IF(U$57=\"ano\",\"noc\",\"---\"),\"25%\"))","v":"MP II"},null,null,null,{"$f":"IF(J57=\"H\",\"PT\",\"---\")","v":"PT"},{"$nulls":31},"jen do 2020"]
["Ne",{"$f":"IF(SUM(CE10:CF10)>0,\" chy\",\"1.\")","v":"1."},{"$nulls":24},{"$f":"IF(OR(CU10>0,BT10=0),IF(OR(CU10>0,BZ10=0),\"\",BZ10),IF(AI10=\"S\",IF(AND(BT10>AE10,AE10>0,AE10<>B$4),IF(BT10-AE10>B$4,B$4,BT10),IF(BZ10=0,\"\",BZ10)),BT10))","v":""},{"$nulls":10},{"$f":"IF(OR(AND(BR10<0.2,J$57=\"H\"),BR10=0,AND(J$57<>\"D\",BF$56=0),CU10>0,AI10=\"S\",U$57=\"ano\"),\"\",MIN(BT10,IF(BR10<6.5,MIN(BR10,6),BR10-0.5)))","v":""},null,null,null,{"$f":"IF(OR(BS10=0,AI10=\"S\",CU10>0,AND(J$57<>\"D\",BF$56=0)),\"\",IF(BS10<6.5,MIN(BS10,6),IF(BS10<13,MIN(BS10-0.5,12),IF(BS10<19.5,MIN(BS10-1,18),IF(BS10<26,MIN(BS10-1.5,24),BS10-2)))))","v":""},null,null,null,{"$f":"IF(OR(BQ10=0,BF$56=0,AI10=\"S\",CU10>0),\"\",IF(BQ10<6.5,MIN(BQ10,6),IF(BQ10<13,MIN(BQ10-0.5,12),IF(BQ10<19.5,MIN(BQ10-1,18),IF(BQ10<26,MIN(BQ10-1.5,24),BQ10-2)))))","v":""},{"$nulls":15},{"$f":"IF(AI10=\"S\",IF(AND(BT10>B$4,OR(AE10=B$4,AE10=0)),IF(BU10>18,BO$44,IF(BU10>12,BO$43,BO$42)),IF(AE10>18,BO$44,IF(AE10>12,BO$43,IF(BT10>4.9,BO$42,\"\")))),IF(AND(BT10>2.9,AH$55=\"ano\"),BO$41,\"\"))","v":""},{"$nulls":4},{"$f":"IF(AND(U10>13.99,X10<22.01,U10<X10),BT10,IF(OR(AND(U10<14.01,X10>21.99),AND(U10<14.01,U10>X10),AND(X10>21.99,U10>X10)),7.5,IF(AND(OR(U10>X10,U10<14),X10>20),MAX(X10-14.5,6),IF(AND(OR(U10>X10,U10<14),X10>14),X10-14,IF(AND(U10<16,OR(X10>22,U10>X10)),MAX(21.5-U10,6),IF(AND(U10<22,OR(X10>22,U10>X10)),22-U10,\"\"))))))","v":""},{"$f":"IF(A10=\"Sv\",IF(AT10=\"\",0,MIN(AT10,B$4)),0)","v":0},{"$f":"IF(OR(A10=\"Sv\",A10=\"Ss\",A10=\"Ns\"),IF(U10>X10,IF(OR(U$57<>\"ano\",U10<21),24-U10,0),BU10)+IF(U9>X9,IF(OR(U$57<>\"ano\",U9<21),X9,BU9),0),0)","v":0},{"$f":"IF(OR(U10=\" \",X10=\" \"),0,IF(U10>X10,MAX(6-U10,0)+MIN(2,24-U10)+MAX(X10-22,0)+MIN(6,X10),IF(X10<6,X10-U10,MAX(6-U10,0)+IF(U10>22,X10-U10,MAX(X10-22,0)))))","v":0},{"$f":"IF(OR(LEFT(A10,1)=\"N\",A10=\"So\",A10=\"Ss\"),IF(AND(U10>X10,LEFT(A10,1)=\"N\"),BU10-X10,BU10),IF(AND(U10>X10,OR(A11=\"So\",A11=\"Ss\",A4=\"So\",A4=\"Ss\")),X10,0))","v":0},{"$f":"IF(BU10<6.5,MIN(BU10,6),IF(BU10<13,MIN(BU10-0.5,12),IF(BU10<19.5,MIN(BU10-1,18),IF(BU10<26,MIN(BU10-1.5,24),BU10-2))))","v":0},{"$f":"IF(OR(U10>24,X10>24,AE10>24),0,IF(X10-U10<0,X10-U10+24,X10-U10)-IF(AI10=\"P\",AE10,0))","v":0},{"$f":"IF(AND(A10=\"Sv\",AI10<>\"N\",AI10<>\"X\",BF$56<>0),1,0)","v":0},{"$f":"IF(AI10<>\"D\",0,IF(AE10>0,AE10/B$4,1))","v":0},{"$f":"IF(AI10=\"L\",IF(AE10=0,B$4,AE10),0)","v":0},{"$f":"IF(AND(AI10=\"N\",BT10<B$4,OR(A10=\"\",A10=\"Sv\")),IF(AE10=0,(B$4-BT10)/B$4,AE10/B$4),0)","v":0},{"$f":"IF(AND(AI10=\"S\",A10=\"\"),IF(OR(AE10=0,AE10>B$4),B$4,AE10),0)","v":0},{"$f":"IF(OR(AI10=\"A\",AI10=\"E\"),IF(AE10>0,AE10/B$4,1),0)","v":0},{"$f":"IF(OR(AI10=\"O\",AI10=\"60%\",AI10=\"80%\"),IF(AE10=0,B$4,AE10),0)","v":0},{"$f":"IF(AI10=\"X\",IF(AE10>0,AE10/B$4,1),0)","v":0},{"$f":"IF(AI10=\"O\",CB10,0)+IF(AI10=\"60%\",CB10*0.6,0)+IF(AI10=\"80%\",CB10*0.8,0)","v":0},{"$f":"IF(J$57=\"H\",IF(BF10>24,1,IF(AND(MIN(BF10+0,B$4)+MIN(BT10,B$4)>B$4,BT10>5),1,0)),0)","v":0},null,{"$f":"IF(CJ10>0,0,IF(AND(AI10=\"P\",BU10<0),1,0))","v":0},{"$f":"IF(OR(A10=\"\",AI10=\"N\",AI10=\"P\",AI10=\"S\",AND(A10=\"Sv\",AI10=\"X\")),0,IF(AND(AE10=\"\",AI10=\"\"),0,IF(A10=\"Sv\",30,1)))","v":0},{"$f":"IF(OR(AI10=\"\",AI10=\"D\",AI10=\"L\",AI10=\"N\",AI10=\"S\",AI10=\"V\",AI10=\"P\",AI10=\"A\",AI10=\"E\",AI10=\"O\",AI10=\"X\",AI10=\"60%\",AI10=\"80%\"),0,1)","v":0},{"$f":"IF(X10=\" \",1,IF(OR(U10<0,U10>24,X10<0,X10>24,AE10<0,AE10>24,AX10<0,AND(AX10>24,AX10<>\"\"),BB10<0,AND(BB10>24,BB10<>\"\"),BF10<0,BF10>24),1,0))","v":0},{"$f":"IF(CJ10>0,0,IF(OR(U10>24,X10>24,AE10>24,AND(AX10>24,AX10<>\"\"),AND(AX10>24,AX10<>\"\"),BF10>24),1,U10*4-FLOOR(U10*4,1)+X10*4-FLOOR(X10*4,1)+AE10*4-FLOOR(AE10*4,1)+IF(AX10=\"\",0,AX10*4-FLOOR(AX10*4,1))+IF(BB10=\"\",0,BB10*4-FLOOR(BB10*4,1))+BF10*4-FLOOR(BF10*4,1)))","v":0},{"$f":"IF(AND(P$57<2021,AI10=\"D\",AE10<>B$4,AE10<>B$4/2,AE10<>0),1,0)","v":0},{"$f":"IF(AND(AI10=\"S\",AE10<5,AE10<>0),1,0)","v":0},{"$f":"IF(AND(AI10=\"S\",BT10<B$4,AE10>BU10,AE10<>8,AE10>0),1,0)","v":0},{"$f":"IF(CJ10>0,0,IF(AND(AND(AI10<>\"\",AI10<>\"P\",AI10<>\"S\"),BT10+AE10>B$4),1,0))","v":0},{"$f":"IF(AND(BT10>0,AI10<>\"\",AI10<>\"N\",AI10<>\"S\",AI10<>\"V\",AE10=0),1,0)","v":0},null,{"$f":"IF(AND(BJ10<>BO$41,BJ10<>BO$42,BJ10<>BO$43,BJ10<>BO$44,BJ10<>ROUND(BO$42*0.3,0),BJ10<>ROUND(BO$43*0.65,0),BJ10<>ROUND(BO$44*0.75,0),BJ10<>ROUND(BO$43*0.3,0),BJ10<>ROUND(BO$44*0.5,0),BJ10<>ROUND(BO$44*0.25,0),BJ10<>0,BJ10<>\"\"),1,0)","v":0},{"$f":"IF(J$57=\"H\",IF(OR(A10=\"\",AX10=\"\",AX10=0),0,1),0)","v":0},{"$f":"IF(J$57=\"H\",IF(OR(A10<>\"\",BB10=\"\",BB10=0),0,1),0)","v":0},{"$f":"IF(OR(AND(U10<>\"\",X10=\"\"),AND(U10=\"\",X10<>\"\")),1,0)","v":0},{"$f":"IF(OR(BJ10<>BO$41,BJ10=\"\"),0,BJ10)","v":0}]
[null,{"$f":"IF(SUM(CE11:CF11)>0,\" chy\",\"2.\")","v":"2."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE12:CF12)>0,\" chy\",\"3.\")","v":"3."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE13:CF13)>0,\" chy\",\"4.\")","v":"4."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE14:CF14)>0,\" chy\",\"5.\")","v":"5."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE15:CF15)>0,\" chy\",\"6.\")","v":"6."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["So",{"$f":"IF(SUM(CE16:CF16)>0,\" chy\",\"7.\")","v":"7."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["Ne",{"$f":"IF(SUM(CE17:CF17)>0,\" chy\",\"8.\")","v":"8."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE18:CF18)>0,\" chy\",\"9.\")","v":"9."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE19:CF19)>0,\" chy\",\"10.\")","v":"10."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE20:CF20)>0,\" chy\",\"11.\")","v":"11."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE21:CF21)>0,\" chy\",\"12.\")","v":"12."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE22:CF22)>0,\" chy\",\"13.\")","v":"13."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["So",{"$f":"IF(SUM(CE23:CF23)>0,\" chy\",\"14.\")","v":"14."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["Ne",{"$f":"IF(SUM(CE24:CF24)>0,\" chy\",\"15.\")","v":"15."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE25:CF25)>0,\" chy\",\"16.\")","v":"16."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE26:CF26)>0,\" chy\",\"17.\")","v":"17."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE27:CF27)>0,\" chy\",\"18.\")","v":"18."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE28:CF28)>0,\" chy\",\"19.\")","v":"19."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE29:CF29)>0,\" chy\",\"20.\")","v":"20."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["So",{"$f":"IF(SUM(CE30:CF30)>0,\" chy\",\"21.\")","v":"21."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["Ne",{"$f":"IF(SUM(CE31:CF31)>0,\" chy\",\"22.\")","v":"22."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE32:CF32)>0,\" chy\",\"23.\")","v":"23."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE33:CF33)>0,\" chy\",\"24.\")","v":"24."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE34:CF34)>0,\" chy\",\"25.\")","v":"25."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE35:CF35)>0,\" chy\",\"26.\")","v":"26."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(SUM(CE36:CF36)>0,\" chy\",\"27.\")","v":"27."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["So",{"$f":"IF(SUM(CE37:CF37)>0,\" chy\",\"28.\")","v":"28."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(U37>X37,AH$57=\"\",U$57<>\"ano\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0]
["Ne",{"$f":"IF(SUM(CE38:CF38)>0,\" chy\",AH57)","v":"29."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(U38>X38,AK$57=\"\",U$57<>\"ano\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(B38=\"\",OR(D38<>\"\",L38<>\"\",U38<>\"\",X38<>\"\",AE38<>\"\",AI38<>\"\",AX38<>\"\",BB38<>\"\",BF38<>\"\",BJ38<>\"\")),1,0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(SUM(CE39:CF39)>0,\" chy\",AK57)","v":"30."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(U39>X39,AN$57=\"\",U$57<>\"ano\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(B39=\"\",OR(D39<>\"\",L39<>\"\",U39<>\"\",X39<>\"\",AE39<>\"\",AI39<>\"\",AX39<>\"\",BB39<>\"\",BF39<>\"\",BJ39<>\"\")),1,0)","v":0},0,0,0,0,0]
[null,{"$f":"IF(SUM(CE40:CP40)>0,\" chy\",AN57)","v":"31."},{"$nulls":24},"",{"$nulls":10},"",null,null,null,"",null,null,null,"",{"$nulls":15},"",{"$nulls":4},"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(U40>X40,U$57<>\"ano\"),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(B40=\"\",OR(D40<>\"\",L40<>\"\",U40<>\"\",X40<>\"\",AE40<>\"\",AI40<>\"\",AX40<>\"\",BB40<>\"\",BF40<>\"\",BJ40<>\"\")),1,0)","v":0},0,0,0,0,0]
[null,null,{"$f":"IF(L53=\"\",\"\",\"!!! Pozor na chybové hlášení !!!\")","v":""},{"$nulls":18},"celkem",{"$nulls":4},{"$f":"SUM(AA10:AD40)","v":0},{"$nulls":10},{"$f":"SUM(AL10:AO40)","v":0},null,null,null,{"$f":"SUM(AP10:AS40)","v":0},null,null,null,{"$f":"SUM(AT10:AW40)","v":0},null,null,null,{"$f":"SUM(AX10:BA40)","v":0},null,null,null,{"$f":"SUM(BB10:BE40)","v":0},null,null,null,{"$f":"SUM(BF10:BI40)","v":0},null,null,null,{"$f":"SUM(BJ10:BM40)","v":0},{"$nulls":4},75,{"$f":"SUM(BP10:BP40)","v":0},{"$nulls":5},{"$f":"SUM(BV10:BV40)","v":0},{"$f":"IF(BF56=0,0,SUM(BW10:BW40))","v":0},{"$f":"IF(BF56=0,0,SUM(BX10:BX40))","v":0},{"$f":"IF(BF56=0,0,SUM(BY10:BY40))","v":0},{"$f":"SUM(BZ10:BZ40)","v":0},{"$f":"IF(BF56=0,0,SUM(CA10:CA40))","v":0},{"$f":"IF(BF56=0,0,SUM(CB10:CB40))","v":0},{"$f":"IF(BF56=0,0,SUM(CC10:CC40))","v":0},{"$f":"IF(BF56=0,0,SUM(CD10:CD40))","v":0},{"$f":"SUM(CE10:CE40)","v":0},{"$f":"SUM(CF10:CF40)","v":0},{"$f":"SUM(CG10:CG40)","v":0},{"$f":"SUM(CH10:CH40)","v":0},{"$f":"SUM(CI10:CI40)","v":0},{"$f":"SUM(CJ10:CJ40)+CJ42","v":0},{"$f":"SUM(CK10:CK40)+CK42","v":0},{"$f":"SUM(CL10:CL40)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"os. číslo:",{"$nulls":23},"přesčas / úvazek z minulých měsísů ",{"$f":"BF55","v":40},{"$nulls":21},"přesčas k proplacení ",0,null,null,null,"diety:",null,null,null,"  5 - 12",null,null,null,{"$f":"BO42&\",-\"","v":"91,-"},{"$nulls":4},91,{"$nulls":8},"hodiny","dny","hodiny","dny","hodiny","dny","poměr hod",{"$nulls":5},{"$f":"IF(OR(AX42<0,AX42>999,BF56<0,BF56>24),1,0)","v":0},{"$f":"IF(CJ42>0,0,AX42*4-FLOOR(AX42*4,1)+ABS(BF55)*4-FLOOR(ABS(BF55)*4,1)+IF(J57<>\"M\",BF56*20-FLOOR(BF56*20,1),0))","v":0},{"$nulls":9},"=KDYŽ(ROK(DNES())*12+MĚSÍC(DNES())+(DEN(DNES())-1)/100>$P$57*12+$F$57+1;SUMA(CU10:CU40);0)"]
[null,{"$f":"MID(L56,1,1)&\" \"&MID(L56,2,1)&\" \"&MID(L56,3,1)&\" \"&MID(L56,4,1)","v":"1 2 3 4"},{"$nulls":23},"celkem odpracováno hodin ",{"$f":"AA41+AA42","v":40},{"$nulls":21},"do dalších měsíců zbývá úvazek ",{"$f":"IF(AA44-AX42<0,AA44-AX42,\"\")","v":""},null,null,null,"stravné",null,null,null,"12 - 18",null,null,null,{"$f":"BO43&\",-\"","v":"138,-"},{"$nulls":4},138,{"$f":"IF(BP7=\"\",\"\",BP7)","v":"práce ve sv.v"},"příplatek za","příplatek za","příplatek za","snížení doby","přerušení a pr.","svátek ve","dovolená","lékař","nemoc, OČR","služební","neplacené","ostatní plac.","ostatní neplac.","náhrady","práce při  PR","práce po 24 h","přerušení","neodpracované","nepřípustné","nepřípustné","nepřípustné","délka","služební cesta","služební cesta","neodpr.+ odpr.","zadáno neodpr.","zápis do","diety nebo",{"$f":"IF(CS7=\"\",\"\",CS7)","v":"HS-prohození"},{"$f":"IF(CT7=\"\",\"\",CT7)","v":"HS-prohození"},"vyplněno jen","příspěvek na"]
[null,{"$f":"IF(X56=\"\",\"\",\"středisko: \"&X56)","v":"středisko: 1"},{"$nulls":23},"přesčas / úvazek na konci měsíce ",{"$f":"IF(OR(AA43-BW45<-99,BF56=0),0,AA43-BW45)","v":0},{"$nulls":21},"do dalších měsíců zbývá přesčas ",{"$f":"IF(AND(AC57<>\"ano\",AA44-AX42>-0.01),AA44-AX42,\"\")","v":0},null,null,null,{"$f":"BO41&\",-\"","v":"75,-"},null,null,null,"18 - 24",null,null,null,{"$f":"BO44&\",-\"","v":"217,-"},{"$nulls":4},217,{"$f":"IF(BP8=\"\",\"\",BP8)","v":"pracovní době"},"svátek","noc","so + ne","o přestávky","přes půlnoc",null,{"$f":"IF(BW8=\"\",\"\",BW8)","v":""},"doprovod","","cesta","volno, vč. \"A\"","nepřítomnost","nepřítomnost","60%, 80%","pohotovosti"," poslední den","práce","hod.ve volnu","znaky - důvod","rozmezí hodin","hodnoty hodin","dovolené","kratší než 5 h","víc, než práce","hodin je víc","bez hodin","nexist. dne","stravné",{"$f":"IF(CS8=\"\",\"\",CS8)","v":"MP I"},{"$f":"IF(CT8=\"\",\"\",CT8)","v":"MP II"},"\"od\" nebo \"do\"","stravování"]
[null,"důvody nepřítomnosti:  D - dovolená, L - lékař, N - nemoc nebo OČR, S - služební cesta, V - náhradní volno, P - přerušení práce,",{"$nulls":65},"Svátek 1.5.:",{"$f":"IF(BR45<6.5,MIN(BR45,6),IF(BR45<13,MIN(BR45-0.5,12),IF(BR45<19.5,MIN(BR45-1,18),IF(BR45<26,MIN(BR45-1.5,24),BR45-2))))","v":0},{"$f":"IF(AND(F57=4,U39>X39),IF(OR(U$57<>\"ano\",U39<21),X39,BU39),0)","v":0},null,null,null,"Mělo být odpracováno hodin:",{"$f":"ROUND(((X3-BV41-BW41-BY41-CA41-CC41)*B4-BX41-CB41)*4,0)/4","v":176}]
[null,"A - neomluvená absence, E - neplacené volno, O - ostatní placené volno, X - dny před nástupem a po ukončení prac. poměru",{"$nulls":65},"Svátek 1.1.:",{"$f":"IF(BR46<6.5,MIN(BR46,6),IF(BR46<13,MIN(BR46-0.5,12),IF(BR46<19.5,MIN(BR46-1,18),IF(BR46<26,MIN(BR46-1.5,24),BR46-2))))","v":0},{"$f":"IF(AND(F57=12,U40>X40),IF(OR(U$57<>\"ano\",U40<21),X40,BU40),0)","v":0}]
[null,"poznámky:",{"$nulls":71}," Původně - Mělo být odpracováno hodin:",{"$f":"ROUND(((X3-BV41-BW41-BY41-CA41-CC41)*B4-BX41-CB41-MAX(AT41-AX42,0))*4,0)/4","v":176}]
[]
[null,"zpracoval:",{"$nulls":15}," podpis a razítko vedoucího:",{"$nulls":23}," podpis zaměstnance:"]
[null,"XYZ"]
[]
[]
[{"$nulls":10},"chybové hlášení: ",{"$f":"IF(CH41>0,IF(CH41>29,\"Ve svátky může být nepřítomnost jen N -nemoc, S -služební cesta nebo X -ostatní neplacená!\",\"Ve dnech volna může být nepřítomnost jen N - nemoc, S - služební cesta nebo P - přerušení!\"),IF(OR(CI41>0,BF55=\" \",BF56=\" \",AO56=\" \"),IF(CI41>0,\"V sloupci 'důvod nepřítomnosti' jsou nepřípustné znaky!\",\"V některé modré buňce pod chybovým hlášením je zadaný nepřípustný znak!\"),IF(CJ41>0,IF(AX42<0,\"Do přesčasu k proplacení nelze zadat zápornou hodnotu!\",\"Pro hodiny lze zadat pouze číselné hodnoty v rozmezí  0 - 24 !\"),IF(CK41>0,\"Hodiny lze zadat pouze desetinným číslem a zaokrouhlené na čtvrthodiny!\",IF(CL41>0,\"Dovolenou lze vybírat pouze po celých dnech nebo po polovinách dnů!\",IF(CM41>0,\"Sluzební cesta nemůže být kratší než 5 hodin!\",IF(CN41>0,\"Služební cesta nemůže být delší než doba zaměstnance v práci, je-li tato doba kratší než \"&B4&\" h.\",L54)))))))","v":""}]
[{"$nulls":11},{"$f":"IF(CO41>0,IF(B4=0.00001,\"U dohody o provedení práce nelze použít tuto nepřítomnost.\",\"Kromě „P“ a „S“ nemůže být součet hodin přítomnosti a nepřítomnosti vyšší než \"&B4&\" hodin!\"),IF(CP41>0,\"Je-li zadána odpracovaná doba i důvod nepřítomnosti, musí se zadat i hodiny nepřítomnosti!\",IF(CG41>0,\"Přerušení práce nemůže být delší, než odpracovaná doba!\",IF(CF41>0,\"Na konci měsíce nelze zapsat konec pracovní činnosti po 24 hodině.\",IF(AX42>MAX(AA44,0),\"Přesčas k proplacení nemůže být vyšší než přesčas na konci měsíce!\",IF(Y57+AX42>416,\"Byl přečerpán roční přesčasový limit. Proplatit lze nejvíce \"&416-Y57&\" hod\"&IF(ROUND(Y57,0)=Y57,IF(416-Y57<5,\"\",\"in\"),\"in\")&\" přesčasu.\",IF(OR(CE41>0,CQ41>0),IF(CE41>0,\"Je-li zadaná pohotovost PR, lze zadat odpracovanou dobu maximálně 5 hodin.\",\"Do řádku pro neexistující den nelze zapisovat!\"),M54)))))))","v":""},{"$f":"IF(AND(J57<>\"H\",BF56>6,OR(Y57+AX42>150,AX42>ROUND(32*BW45/MAX(BF56,0.01)/5,0)/4)),\"Není-li uzavřevá dohoda podle § 93, odst. 3 ZP, nelze proplatit přesčas vyšší než \"&MAX(0,MIN(150-Y57,ROUND(32*BW45/BF56/5,0)/4))&\" hodin.\",IF(OR(N6<0,N6>9999999,N7>9999999,N7<0,AD6<0,AD6>9999999,AD7>9999999,AD7<0,AT6<0,AT6>9999999,AT7>9999999,AT7<0,BJ6<0,BJ6>9999999,BJ7>9999999,BJ7<0),\"V některé z buněk pro odměny prémie aj. je nepřípustný znak\",IF(OR(BF55<-99.9,BF55>300),\"Pro přesčas / úvazek z minulých měsísů byla zadána nepřípustná hodnota !\",N54)))","v":""},{"$f":"IF(OR(BQ45>0,BQ46>0),\"Před svátkem nelze na konci měsíce zapsat konec pracovní činnosti po 24 hodině!\",IF(OR(CS41>0,CT41>0),\"Pohotovost MP I\"&IF(CS41>0,\" lze zadat jen v pracovních dnech.\",\"I lze zadat jen ve dnech pracovního klidu.\"),IF(CU41>0,\"V jednom řádku nelze vyplnit pouze ''od'' nebo pouze ''do''\",IF(CR41>0,\"Pro diety nebo stravné byla použitá neplatná sazba.\",\"\"))))","v":""}]
[null," jméno a příjmení:",{"$nulls":9},"Xyz Xyz",{"$nulls":17},"stravné",null,null,null,"ano",{"$nulls":22},"přesčas / úvazek z minulých měsísů: ",40,null,null,null," hodin"]
[null," osobní číslo:",{"$nulls":9},1234,{"$nulls":10},"středisko: ",1,{"$nulls":15},{"$f":"IF(K57=\"M\",\"základní měsíční mzda: \",\"základní hodinová mzda: \")","v":"základní hodinová mzda: "},{"$nulls":5},"Kč",{"$nulls":10},"pracovní doba: ",8,null,null,null," hodin"]
[null,"měsíc:",null,null,null,8,null,null,null,"H",{"$f":"IF(OR(AO56>400,AND(AM57>400,AO56=0)),\"M\",\"H\")","v":"H"},null,"rok:",null,null,2021,null,null,null,"ne","ne",null,null,null,63.5,332.65,null,null,"ne",null,null,{"$f":"Y57+AX42","v":63.5},null,{"$f":"IF(OR(F57<>2,P57/4-FLOOR(P57/4,1)=0),\"29.\",\"\")","v":"29."},null,null,{"$f":"IF(F57<>2,\"30.\",\"\")","v":"30."},null,38980,{"$f":"IF(OR(F57=1,F57=3,F57=5,F57=7,F57=8,F57=10,F57=12),\"31.\",\"\")","v":"31."},{"$f":"IF(AA44-AX42<0,AA44-AX42,0)","v":0},{"$f":"AA44-AX42","v":0},{"$nulls":17},"zůstatek dovolené k 1. dni v měsíci ",13,null,null,"dnů"]