{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Legenda","2020-01","Dane"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"Legenda","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Legenda:",null,null,null,"Dni ustawowo wolne od pracy"]
[null,null,null,null,null,"2020-01-01"]
[null,8,null,"dzień roboczy dla pracownika",null,"2020-01-06"]
[null,8,null,"nadgodziny 50%",null,"2020-04-13"]
[null,8,null,"nadgodziny 100%",null,"2020-05-01"]
[null,null,null,null,null,"2020-06-11"]
[null,"uw",null,"urlop wypoczynkowy",null,"2020-08-15"]
[null,"uwż",null,"urlop wypoczynkowy na żądanie",null,"2020-11-11"]
[null,"ok",null,"urlop okolicznościowy, szkolenie, oddanie krwi",null,"2020-12-25"]
[null,"op",null,"urlop na opiekę",null,"2020-12-26"]
[]
[null,"ch",null,"chorobowe, opieka nad członkiem rodziny"]
[null,"m",null,"urlop macierzyński, rodzicielski, ojcowski"]
[null,"w",null,"urlop wychowawczy"]
[]
[null,"d",null,"delegacja (wyjazd służbowy itp.)"]
[null,"nup",null,"nieobecność usprawiedliwiona płatna"]
[null,"nu",null,"nieobecność usprawiedliwiona bezpłatna"]
[null,"nn",null,"nieobecność nieusprawiedliwiona"]
[null,"zz",null,"godziny związkowe"]
[null,"ub",null,"urlop bezpłatny"]
[]
[]
[null,"odp",null,"odpracowano"]

{"sheet":"2020-01","index":1,"n_rows":13,"n_cols":50,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,37,0,38],[0,39,0,49],[1,49,2,49],[2,0,3,0],[2,2,3,2],[2,3,2,4],[3,3,3,4]]}
["2020-01-01",null,null,null,null," LISTA OBECNOŚCI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dni rob.","Godziny",null,"Zestawienie dni"]
[null,{"$f":"YEAR(A1)","v":2020},null,"UW","UWŻ",{"$f":"A1","v":"2020-01-01"},{"$f":"+F2+1","v":"2020-01-02"},"2020-01-03","2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08","2020-01-09","2020-01-10","2020-01-11","2020-01-12","2020-01-13","2020-01-14","2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19","2020-01-20","2020-01-21","2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26","2020-01-27","2020-01-28","2020-01-29","2020-01-30","2020-01-31",8,"Σ",0.5,"Pracujące","odp","uw","uwż","ok","op","us","ch","m","w","%  w pracy"]
["Lp.","Nazwisko","Zmiana","na poczatek",null,{"$f":"VLOOKUP(WEEKDAY(F2,2),week,2)","v":"śr"},"cz","pt","so","nd","pn","wt","śr","cz","pt","so","nd","pn","wt","śr","cz","pt","so","nd","pn","wt","śr","cz","pt","so","nd","pn","wt","śr","cz","pt",{"$f":"COUNTBLANK(F4:AJ4)","v":21},"H-w",1,"Urlop",{"$f":"SUM(AO5:AO13)","v":0},{"$f":"SUM(AP5:AP13)","v":0},{"$f":"SUM(AQ5:AQ13)","v":0},{"$f":"SUM(AR5:AR13)","v":0},{"$f":"SUM(AS5:AS13)","v":0},{"$f":"SUM(AT5:AT13)","v":0},{"$f":"SUM(AU5:AU13)","v":0},{"$f":"SUM(AV5:AV13)","v":0},{"$f":"SUM(AW5:AW13)","v":0}]
[null,"Imię",null,"do wybrania",null,{"$f":"IF(NETWORKDAYS(F2,F2,_swieta)=1,\"\",IF(WEEKDAY(F2,2)=6,\"x\",\"xx\"))","v":"xx"},"","","x","xx","xx","","","","","x","xx","","","","","","x","xx","","","","","","x","xx","","","","","","etat","Nadl.",0.2,"Chorobowe"]
[1,"Abacki"," 6-14",null,null,null,8,8,8,null,null,null,8,8,8,8,null,null,null,null,null,null,8,8,8,8,8,8,8,null,null,8,8,8,null,null,{"$f":"$AK$2","v":8},{"$f":"SUM(F5:AJ7)","v":152},{"$f":"SumaWgFontKolor(F5:AJ7,$AM$2)","v":16},{"$f":"ROUNDUP(AL6/8,0)","v":13},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AO$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AP$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AQ$2)+COUNTIF($F5:$AJ7,\"uwz\")","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AR$2)+COUNTIF($F5:$AJ7,\"ok.\")","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AS$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AT$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AU$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AV$2)","v":0},{"$f":"COUNTIF($F5:$AJ7,'2020-01'!AW$2)","v":0},{"$f":"IF(AK6>0,AN5/AK6,\"\")","v":0.61904761904761907}]
[null,"Adam","14-22",{"$f":"SUM(AP5:AQ5)","v":0},{"$f":"AQ5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AK$3","v":21},{"$f":"SumaWgFontKolor(F5:AJ7,$AM$4)","v":104},{"$f":"SumaWgFontKolor(F5:AJ7,$AM$3)","v":32},{"$f":"SUM(AP5:AQ5)","v":0}]
[null,"1 zmiana","22- 6",{"$f":"D5-D6","v":0},{"$f":"E5-E6","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,{"$f":"AK5*AK6","v":168},{"$f":"AL5-AL6","v":48},{"$f":"SumaWgFontKolor(F7:AJ7,$AM$4)","v":0},{"$f":"SUM(AU5:AW5)","v":0},null,null,null,null,{"$f":"AS6-AS5","v":0},{"$f":"AT6-AT5","v":0}]
[{"$f":"A5+1","v":2},"Bebacki"," 6-14",null,null,null,8,8,8,null,null,null,8,8,8,8,null,null,null,null,null,null,8,8,8,8,8,8,8,null,null,8,8,8,null,null,{"$f":"$AK$2","v":8},{"$f":"SUM(F8:AJ10)","v":152},{"$f":"SumaWgFontKolor(F8:AJ10,$AM$2)","v":16},{"$f":"ROUNDUP(AL9/8,0)","v":13},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AO$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AP$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AQ$2)+COUNTIF($F8:$AJ10,\"uwz\")","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AR$2)+COUNTIF($F8:$AJ10,\"ok.\")","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AS$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AT$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AU$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AV$2)","v":0},{"$f":"COUNTIF($F8:$AJ10,'2020-01'!AW$2)","v":0},{"$f":"IF(AK9>0,AN8/AK9,\"\")","v":0.61904761904761907}]
[null,"Bartłomiej","14-22",{"$f":"SUM(AP8:AQ8)","v":0},{"$f":"AQ8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AK$3","v":21},{"$f":"SumaWgFontKolor(F8:AJ10,$AM$4)","v":104},{"$f":"SumaWgFontKolor(F8:AJ10,$AM$3)","v":32},{"$f":"SUM(AP8:AQ8)","v":0}]
[null,"1 zmiana","22- 6",{"$f":"D8-D9","v":0},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,{"$f":"AK8*AK9","v":168},{"$f":"AL8-AL9","v":48},{"$f":"SumaWgFontKolor(F10:AJ10,$AM$4)","v":0},{"$f":"SUM(AU8:AW8)","v":0},null,null,null,null,{"$f":"AS9-AS8","v":0},{"$f":"AT9-AT8","v":0}]
[{"$f":"A8+1","v":3},"Cebacki"," 6-14",null,null,null,8,8,8,null,null,null,8,8,8,8,null,null,null,null,null,null,8,8,8,8,8,8,8,null,null,8,8,8,null,null,{"$f":"$AK$2","v":8},{"$f":"SUM(F11:AJ13)","v":152},{"$f":"SumaWgFontKolor(F11:AJ13,$AM$2)","v":16},{"$f":"ROUNDUP(AL12/8,0)","v":13},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AO$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AP$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AQ$2)+COUNTIF($F11:$AJ13,\"uwz\")","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AR$2)+COUNTIF($F11:$AJ13,\"ok.\")","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AS$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AT$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AU$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AV$2)","v":0},{"$f":"COUNTIF($F11:$AJ13,'2020-01'!AW$2)","v":0},{"$f":"IF(AK12>0,AN11/AK12,\"\")","v":0.61904761904761907}]
[null,"Jan","14-22",{"$f":"SUM(AP11:AQ11)","v":0},{"$f":"AQ11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AK$3","v":21},{"$f":"SumaWgFontKolor(F11:AJ13,$AM$4)","v":104},{"$f":"SumaWgFontKolor(F11:AJ13,$AM$3)","v":32},{"$f":"SUM(AP11:AQ11)","v":0}]
[null,"1 zmiana","22- 6",{"$f":"D11-D12","v":0},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,{"$f":"AK11*AK12","v":168},{"$f":"AL11-AL12","v":48},{"$f":"SumaWgFontKolor(F13:AJ13,$AM$4)","v":0},{"$f":"SUM(AU11:AW11)","v":0},null,null,null,null,{"$f":"AS12-AS11","v":0},{"$f":"AT12-AT11","v":0}]

{"sheet":"Dane","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[1,"pn"]
[2,"wt"]
[3,"śr"]
[4,"cz"]
[5,"pt"]
[6,"so"]
[7,"nd"]