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

{"sheet":"Evidence","index":0,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,4,2,9],[2,2,2,3],[1,2,1,3],[13,18,15,20],[9,18,11,21],[49,4,49,6],[49,9,49,11],[43,4,43,6],[44,4,44,6],[43,9,43,11],[44,9,44,11]]}
[]
[null,"Term:",{"$f":"$Q$6&\" / \"&CHOOSE(Q8,\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\")","v":"2023 / September"},null,"Working hours evidence"]
[null,"Name:",{"$f":"Holidays!E2","v":"John Doe"}]
[]
[null,"Day","Week-day","Type","Start","Safety break","End of break","End","Description","Note Pass","0","Weekly total","Day total"]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B6&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B6&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B6&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},1,{"$f":"CHOOSE(WEEKDAY($B6&\"/\" &$Q$8&\"/\" & $Q$6,2),\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\",\"Sun\")","v":"Fri"},"Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 1",null,null,{"$f":"IF($N7<>$N6,SUMIFS($M$6:$M$36,$N$6:$N$36,$N6),\"\")","v":""},{"$f":"IF(NOT(ISBLANK($E6)),IF(NOT(ISBLANK($H6)),($H6-$E6-($G6-$F6)),DailyHours[Daily hours]),)","v":0.33333333333333326},{"$f":"IFERROR(WEEKNUM($B6&\"/\"&$Q$8&\"/\"&$Q$6,21),666)","v":35},null,null,2023,"Year"]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B7&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B7&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B7&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},2,"Sat",null,null,null,null,null,null,null,null,"",{"$f":"IF(NOT(ISBLANK($E7)),IF(NOT(ISBLANK($H7)),($H7-$E7-($G7-$F7)),DailyHours[Daily hours]),)","v":0},{"$f":"IFERROR(WEEKNUM($B7&\"/\"&$Q$8&\"/\"&$Q$6,21),666)","v":35},null,null,{"$f":"DAY(NOW())","v":16},"Day (auto-calculated)"]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B8&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B8&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B8&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},3,"Sun",null,null,null,null,null,null,null,null,{"$f":"IF($N9<>$N8,SUMIFS($M$6:$M$36,$N$6:$N$36,$N8),\"\")","v":0.33333333333333326},{"$f":"IF(NOT(ISBLANK($E8)),IF(NOT(ISBLANK($H8)),($H8-$E8-($G8-$F8)),DailyHours[Daily hours]),)","v":0},35,null,null,9,"Month"]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B9&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B9&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B9&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},4,"Mon","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 2",null,null,"",{"$f":"IF(NOT(ISBLANK($E9)),IF(NOT(ISBLANK($H9)),($H9-$E9-($G9-$F9)),DailyHours[Daily hours]),)","v":0.33333333333333326},36]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B10&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B10&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B10&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},5,"Tue","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 3",null,null,"",{"$f":"IF(NOT(ISBLANK($E10)),IF(NOT(ISBLANK($H10)),($H10-$E10-($G10-$F10)),DailyHours[Daily hours]),)","v":0.33333333333333326},36,null,null,null,null,"Updates the count of days in a month. It will erase the entire calendar and the dates within. Hides non-existent days in the month."]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B11&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B11&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B11&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},6,"Wed","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 4",null,null,"",{"$f":"IF(NOT(ISBLANK($E11)),IF(NOT(ISBLANK($H11)),($H11-$E11-($G11-$F11)),DailyHours[Daily hours]),)","v":0.33333333333333326},36]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B12&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B12&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B12&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},7,"Thu","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 5",null,null,"",{"$f":"IF(NOT(ISBLANK($E12)),IF(NOT(ISBLANK($H12)),($H12-$E12-($G12-$F12)),DailyHours[Daily hours]),)","v":0.33333333333333326},36]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B13&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B13&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B13&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},8,"Fri","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 6",null,null,"",{"$f":"IF(NOT(ISBLANK($E13)),IF(NOT(ISBLANK($H13)),($H13-$E13-($G13-$F13)),DailyHours[Daily hours]),)","v":0.33333333333333326},36]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B14&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B14&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B14&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},9,"Sat",null,null,null,null,null,null,null,null,"",{"$f":"IF(NOT(ISBLANK($E14)),IF(NOT(ISBLANK($H14)),($H14-$E14-($G14-$F14)),DailyHours[Daily hours]),)","v":0},36,null,null,null,null,"Prints the completed sheet to a PDF file in the path (configuration in the Holidays sheet). It will also open the PDF file."]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B15&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B15&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B15&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},10,"Sun",null,null,null,null,null,null,null,null,1.6666666666666663,{"$f":"IF(NOT(ISBLANK($E15)),IF(NOT(ISBLANK($H15)),($H15-$E15-($G15-$F15)),DailyHours[Daily hours]),)","v":0},36]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B16&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B16&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B16&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},11,"Mon","Sick-Day","09:00:00",null,null,"17:30:00","Flu",null,null,"",{"$f":"IF(NOT(ISBLANK($E16)),IF(NOT(ISBLANK($H16)),($H16-$E16-($G16-$F16)),DailyHours[Daily hours]),)","v":0.35416666666666663},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B17&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B17&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B17&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},12,"Tue","Pass","09:00:00",null,null,"10:15:00","Job 10","Dentist",null,"",{"$f":"IF(NOT(ISBLANK($E17)),IF(NOT(ISBLANK($H17)),($H17-$E17-($G17-$F17)),DailyHours[Daily hours]),)","v":5.2083333333333315E-2},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B18&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B18&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B18&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},13,"Wed","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 11",null,null,"",{"$f":"IF(NOT(ISBLANK($E18)),IF(NOT(ISBLANK($H18)),($H18-$E18-($G18-$F18)),DailyHours[Daily hours]),)","v":0.33333333333333326},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B19&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B19&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B19&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},14,"Thu","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 12",null,null,"",{"$f":"IF(NOT(ISBLANK($E19)),IF(NOT(ISBLANK($H19)),($H19-$E19-($G19-$F19)),DailyHours[Daily hours]),)","v":0.33333333333333326},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B20&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B20&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B20&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},15,"Fri","Caring for a family member","09:00:00",null,null,"17:30:00","Children at doctor",null,null,"",{"$f":"IF(NOT(ISBLANK($E20)),IF(NOT(ISBLANK($H20)),($H20-$E20-($G20-$F20)),DailyHours[Daily hours]),)","v":0.35416666666666663},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B21&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B21&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B21&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},16,"Sat",null,null,null,null,null,null,null,null,"",{"$f":"IF(NOT(ISBLANK($E21)),IF(NOT(ISBLANK($H21)),($H21-$E21-($G21-$F21)),DailyHours[Daily hours]),)","v":0},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B22&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B22&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B22&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},17,"Sun",null,null,null,null,null,null,null,null,1.427083333333333,{"$f":"IF(NOT(ISBLANK($E22)),IF(NOT(ISBLANK($H22)),($H22-$E22-($G22-$F22)),DailyHours[Daily hours]),)","v":0},37]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B23&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B23&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B23&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},18,"Mon","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 16",null,null,"",{"$f":"IF(NOT(ISBLANK($E23)),IF(NOT(ISBLANK($H23)),($H23-$E23-($G23-$F23)),DailyHours[Daily hours]),)","v":0.33333333333333326},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B24&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B24&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B24&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},19,"Tue","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 17",null,null,"",{"$f":"IF(NOT(ISBLANK($E24)),IF(NOT(ISBLANK($H24)),($H24-$E24-($G24-$F24)),DailyHours[Daily hours]),)","v":0.33333333333333326},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B25&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B25&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B25&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},20,"Wed","Illness","09:00:00",null,null,"17:00:00","Vaccination impact",null,null,"",{"$f":"IF(NOT(ISBLANK($E25)),IF(NOT(ISBLANK($H25)),($H25-$E25-($G25-$F25)),DailyHours[Daily hours]),)","v":0.33333333333333337},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B26&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B26&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B26&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},21,"Thu","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 19",null,null,"",{"$f":"IF(NOT(ISBLANK($E26)),IF(NOT(ISBLANK($H26)),($H26-$E26-($G26-$F26)),DailyHours[Daily hours]),)","v":0.33333333333333326},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B27&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B27&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B27&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},22,"Fri","Employment","09:00:00","12:00:00","12:30:00","17:30:00","Job 20",null,null,"",{"$f":"IF(NOT(ISBLANK($E27)),IF(NOT(ISBLANK($H27)),($H27-$E27-($G27-$F27)),DailyHours[Daily hours]),)","v":0.33333333333333326},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B28&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B28&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B28&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},23,"Sat",null,null,null,null,null,null,null,null,"",{"$f":"IF(NOT(ISBLANK($E28)),IF(NOT(ISBLANK($H28)),($H28-$E28-($G28-$F28)),DailyHours[Daily hours]),)","v":0},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B29&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B29&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B29&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},24,"Sun",null,null,null,null,null,null,null,null,{"$f":"IF($N30<>$N29,SUMIFS($M$6:$M$36,$N$6:$N$36,$N29),\"\")","v":1.6666666666666663},{"$f":"IF(NOT(ISBLANK($E29)),IF(NOT(ISBLANK($H29)),($H29-$E29-($G29-$F29)),DailyHours[Daily hours]),)","v":0},38]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B30&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B30&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B30&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},25,"Mon","Business trip","09:00:00","12:00:00","12:30:00","16:00:00","At Brno branch for training",null,null,"",{"$f":"IF(NOT(ISBLANK($E30)),IF(NOT(ISBLANK($H30)),($H30-$E30-($G30-$F30)),DailyHours[Daily hours]),)","v":0.27083333333333326},39]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B31&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B31&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B31&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},26,"Tue","An obstacle on employer side","09:00:00",null,null,"17:30:00","Internet down",null,null,"",{"$f":"IF(NOT(ISBLANK($E31)),IF(NOT(ISBLANK($H31)),($H31-$E31-($G31-$F31)),DailyHours[Daily hours]),)","v":0.35416666666666663},39]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B32&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B32&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B32&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},27,"Wed","Holiday","09:00:00",null,null,"17:00:00",null,null,null,"",{"$f":"IF(NOT(ISBLANK($E32)),IF(NOT(ISBLANK($H32)),($H32-$E32-($G32-$F32)),DailyHours[Daily hours]),)","v":0.33333333333333337},39]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B33&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B33&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B33&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":"."},28,"Thu","State Holiday","09:00:00","10:15:00","10:45:00","11:35:00","Job 13",null,null,"",{"$f":"IF(NOT(ISBLANK($E33)),IF(NOT(ISBLANK($H33)),($H33-$E33-($G33-$F33)),DailyHours[Daily hours]),)","v":8.6805555555555525E-2},39]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B34&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B34&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B34&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},29,"Fri","Holiday","09:00:00",null,null,"17:00:00",null,null,null,"",{"$f":"IF(NOT(ISBLANK($E34)),IF(NOT(ISBLANK($H34)),($H34-$E34-($G34-$F34)),DailyHours[Daily hours]),)","v":0.33333333333333337},39]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B35&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B35&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B35&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},30,"Sat",null,null,null,null,null,null,null,null,1.3784722222222223,{"$f":"IF(NOT(ISBLANK($E35)),IF(NOT(ISBLANK($H35)),($H35-$E35-($G35-$F35)),DailyHours[Daily hours]),)","v":0},39,null,null,{"$f":"IFERROR(IF($C34=TEXT(\"Sun\",\"#\"),SUMIFS($M$6:$M$36,$N$6:$N$36,$N34,$D$6:$D$36,\"Employment\"),\"\"),\"\")","v":""}]
[{"$f":"IFERROR(_xlfn.XLOOKUP(DATE(YEAR(TEXT($B36&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),MONTH(TEXT($B36&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\")),DAY(TEXT($B36&\"/\"&$Q$8&\"/\"&$Q$6,\"dd.mm.rrrr\"))),StateHolidays[Date],StateHolidays[x],\"\",0,1),\"\")","v":""},31,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,0,{"$f":"IF(NOT(ISBLANK($E36)),IF(NOT(ISBLANK($H36)),($H36-$E36-($G36-$F36)),DailyHours[Daily hours]),)","v":0},666,null,null,""]
[]
[null,null,null,"Total Worked:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Employment\",$N$6:$N$36,\"<55\")","v":3.9999999999999982},null,null,null,"Obstacle at the employer:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"An obstacle on employer side\",$N$6:$N$36,\"<55\")","v":0.35416666666666663}]
[null,null,null,"Pass:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Pass\",$N$6:$N$36,\"<55\")","v":5.2083333333333315E-2},null,null,null,"Business trip:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Business trip\",$N$6:$N$36,\"<55\")","v":0.27083333333333326}]
[null,null,null,"Holiday:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Holiday\",$N$6:$N$36,\"<55\")","v":0.66666666666666674},null,null,null,"State holiday:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"State Holiday\",$N$6:$N$36,\"<55\")","v":8.6805555555555525E-2}]
[null,null,null,"Sick-day:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Sick-Day\",$N$6:$N$36,\"<55\")","v":0.35416666666666663},null,null,null,"Illness",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Illness\",$N$6:$N$36,\"<55\")","v":0.33333333333333337}]
[null,null,null,"CFM:",{"$f":"SUMIFS($M$6:$M$36,MonthlyEvidence[Type],\"Caring for a family member\",$N$6:$N$36,\"<55\")","v":0.35416666666666663},null,null,null,"Total for employer:",{"$f":"SUM(SUMIFS($M$6:$M$36,MonthlyEvidence[Type],{\"Employment\";\"Sick-Day\";\"Pass\";\"Illness\";\"Caring for a family member\";\"Business trip\";\"An obstacle on employer side\";\"State Holiday\"},$N$6:$N$36,\"<55\"))","v":5.8055555555555536}]
[]
[null,null,null,"Extraordinary reward:",null,null,null,null,"Annual remuneration:"]
[null,null,null,"Performance Reward:",null,null,null,null,"Precipitation:"]
[]
[]
[]
[null,null,null,{"$f":"IF(_xlfn.XLOOKUP(Evidence!$E$50,EmployeeManager[[#All],[Names]],EmployeeManager[[#All],[Position]],\"Podpis:\")=\"employee\",\"Employee's signature:\",\"Line manager's signature:\")","v":"Employee's signature:"},null,null,null,null,{"$f":"IF(_xlfn.XLOOKUP(Evidence!$J$50,EmployeeManager[[#All],[Names]],EmployeeManager[[#All],[Position]],\"Podpis:\")=\"employee\",\"Employee signature:\",\"Line manager's signature:\")","v":"Line manager's signature:"}]
[null,null,null,null,{"$f":"Holidays!$E$2","v":"John Doe"},null,null,null,null,{"$f":"Holidays!$E$3","v":"Rob Netie"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1:N50 range will be printed to PDF file. Nothing outside of the range will be in the printout."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The name of the employee and employee's Line manager can be changed in the Holidays worksheet."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not change anything in the columns A, B, C, L, M, or N, there are formulas for calculations. ¯\\_(ツ)_/¯"]

{"sheet":"Holidays","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Date","State Holiday","x",null,"Names","Position",null,null,null,"Activity type"]
[{"$f":"DATE(YEAR(TODAY())-1,1,1)","v":"2023-01-01"},"Nový rok",".",null,"John Doe","employee",null,null,null,"Employment"]
[{"$f":"(DOLLAR((\"4/\"&YEAR(TODAY())-1)/7+MOD(19*MOD(YEAR(TODAY())-1,19)-7,30)*14%,)*7-6)-2","v":"2023-04-07"},"Velký pátek",".",null,"Rob Netie","line manager",null,null,null,"State Holiday"]
[{"$f":"(DOLLAR((\"4/\"&YEAR(TODAY())-1)/7+MOD(19*MOD(YEAR(TODAY())-1,19)-7,30)*14%,)*7-6)+1","v":"2023-04-10"},"Velikonoční pondělí",".",null,null,null,null,null,null,"Business trip"]
[{"$f":"DATE(YEAR(TODAY())-1,5,1)","v":"2023-05-01"},"Svátek práce",".",null,null,null,null,null,null,"Sick-Day"]
[{"$f":"DATE(YEAR(TODAY())-1,5,8)","v":"2023-05-08"},"Den osvobození ČSR",".",null,"Daily hours",null,null,null,null,"An obstacle on employer side"]
[{"$f":"DATE(YEAR(TODAY())-1,7,5)","v":"2023-07-05"},"Den slovanských věrozvěstů Cyrila a Metoděje",".",null,0.33333333333333331,null,null,null,null,"Pass"]
[{"$f":"DATE(YEAR(TODAY())-1,7,6)","v":"2023-07-06"},"Den upálení mistra Jana Husa",".",null,null,null,null,null,null,"Caring for a family member"]
[{"$f":"DATE(YEAR(TODAY())-1,9,28)","v":"2023-09-28"},"Den české státnosti",".",null,null,null,null,null,null,"Illness"]
[{"$f":"DATE(YEAR(TODAY())-1,10,28)","v":"2023-10-28"},"Den vzniku samostatného československého státu",".",null,null,null,null,null,null,"Holiday"]
[{"$f":"DATE(YEAR(TODAY())-1,11,17)","v":"2023-11-17"},"Den boje za svobodu a demokracii","."]
[{"$f":"DATE(YEAR(TODAY())-1,12,24)","v":"2023-12-24"},"Štědrý den","."]
[{"$f":"DATE(YEAR(TODAY())-1,12,25)","v":"2023-12-25"},"1. svátek vánoční (Boží hod)","."]
[{"$f":"DATE(YEAR(TODAY())-1,12,26)","v":"2023-12-26"},"2. svátek vánoční","."]
[{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2024-01-01"},"Nový rok","."]
[{"$f":"(DOLLAR((\"4/\"&YEAR(TODAY()))/7+MOD(19*MOD(YEAR(TODAY()),19)-7,30)*14%,)*7-6)-2","v":"2024-03-29"},"Velký pátek","."]
[{"$f":"(DOLLAR((\"4/\"&YEAR(TODAY()))/7+MOD(19*MOD(YEAR(TODAY()),19)-7,30)*14%,)*7-6)+1","v":"2024-04-01"},"Velikonoční pondělí","."]
[{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2024-05-01"},"Svátek práce",".",null,"Automatic path to exported files"," "," 2"," 3"," 4"," 5"," 6"," 7"," 8"]
[{"$f":"DATE(YEAR(TODAY()),5,8)","v":"2024-05-08"},"Den osvobození ČSR",".",null,{"$f":"LEFT(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))-1)","v":"C:\\_DEV\\Excel\\"}]
[{"$f":"DATE(YEAR(TODAY()),7,5)","v":"2024-07-05"},"Den slovanských věrozvěstů Cyrila a Metoděje","."]
[{"$f":"DATE(YEAR(TODAY()),7,6)","v":"2024-07-06"},"Den upálení mistra Jana Husa","."]
[{"$f":"DATE(YEAR(TODAY()),9,28)","v":"2024-09-28"},"Den české státnosti","."]
[{"$f":"DATE(YEAR(TODAY()),10,28)","v":"2024-10-28"},"Den vzniku samostatného československého státu","."]
[{"$f":"DATE(YEAR(TODAY()),11,17)","v":"2024-11-17"},"Den boje za svobodu a demokracii","."]
[{"$f":"DATE(YEAR(TODAY()),12,24)","v":"2024-12-24"},"Štědrý den","."]
[{"$f":"DATE(YEAR(TODAY()),12,25)","v":"2024-12-25"},"1. svátek vánoční (Boží hod)","."]
[{"$f":"DATE(YEAR(TODAY()),12,26)","v":"2024-12-26"},"2. svátek vánoční","."]