{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Übersicht","202501","202502"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Übersicht","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Mitarbeiter","Früh-\ndienst","Früh-\ndienst 2","Ersatz\nFrüh-\ndienst","Normal-\ndienst","Normal-\ndienst 2","Ersatz Normal\ndienst","Spät-\ndienst","Spät-\ndienst2",null,"Jahr",2025]
[null,"C1","F1","Z1","C2","F2","Z2","C3","F3"]
["Mitarbeiter 1",null,null,null,null,null,null,null,null,null,"Feiertage"]
["Mitarbeiter 2",null,null,null,null,null,null,null,null,null,"2024-12-31","Silvester"]
[null,null,null,null,null,null,null,null,null,null,"2025-01-01","Neujahr"]
["Mitarbeiter 3",null,null,null,null,null,null,null,null,null,"2025-01-06","Heilige Drei Könige"]
["Mitarbeiter 4",null,null,null,null,null,null,null,null,null,"2025-04-18","Karfreitag"]
[null,null,null,null,null,null,null,null,null,null,"2025-04-21","Ostermontag"]
["Mitarbeiter 5",null,null,null,null,null,null,null,null,null,"2025-05-01","Tag der Arbeit"]
["Mitarbeiter 6",null,null,null,null,null,null,null,null,null,"2025-05-29","Christi Himmelfahrt"]
["Mitarbeiter 7",null,null,null,null,null,null,null,null,null,"2025-06-09","Pfingstmontag"]
["Mitarbeiter 8",null,null,null,null,null,null,null,null,null,"2025-06-19","Fronleichnam"]
["Mitarbeiter 9",null,null,null,null,null,null,null,null,null,"2025-08-15","Mariä Himmelfahrt"]
["Mitarbeiter 10",null,null,null,null,null,null,null,null,null,"2025-10-03","Tag der Deutschen Einheit"]
["Mitarbeiter 11",null,null,null,null,null,null,null,null,null,"2025-11-01","Allerheiligen"]
["Mitarbeiter 12",null,null,null,null,null,null,null,null,null,"2025-12-24","Heilig Abend"]
["Mitarbeiter 13",null,null,null,null,null,null,null,null,null,"2025-12-25","1. Weihnachtsfeiertag"]
["Mitarbeiter 14",null,null,null,null,null,null,null,null,null,"2025-12-26","2. Weihnachtsfeiertag"]
["Mitarbeiter 15",null,null,null,null,null,null,null,null,null,"2025-12-31","Silvester"]
["Mitarbeiter 16",null,null,null,null,null,null,null,null,null,"2026-01-01","Neujahr"]
["Mitarbeiter 17",null,null,null,null,null,null,null,null,null,"2026-01-06","Heilige Drei Könige"]
["Mitarbeiter 18"]
["Mitarbeiter 19"]
["Mitarbeiter 20"]
["Mitarbeiter 21"]
["Mitarbeiter 22"]
["Mitarbeiter 23"]
["Mitarbeiter 24"]
["Mitarbeiter 25"]

{"sheet":"202501","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"IF(MATCH(D3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(E3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":"JA"},{"$f":"IF(MATCH(F3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":"JA"},{"$f":"IF(MATCH(G3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(H3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(I3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(J3,Übersicht!$K$4:$K$21,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IFERROR(D1:D1,\"\")","v":""},{"$f":"IFERROR(E1:E1,\"\")","v":"JA"},{"$f":"IFERROR(F1:F1,\"\")","v":"JA"},{"$f":"IFERROR(G1:G1,\"\")","v":""},{"$f":"IFERROR(H1:H1,\"\")","v":""},{"$f":"IFERROR(I1:I1,\"\")","v":""},{"$f":"IFERROR(J1:J1,\"\")","v":""}]
["KW",null,null,{"$f":"DATE(Übersicht!L1,1,1)+(A4-1)*7+1-WEEKDAY(DATE(Übersicht!L1,1,1)-1)","v":"2024-12-30"},{"$f":"D3+1","v":"2024-12-31"},{"$f":"E3+1","v":"2025-01-01"},{"$f":"F3+1","v":"2025-01-02"},"2025-01-03","2025-01-04","2025-01-05"]
[1,null,null,"Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag","Platz für Notizen:"]
[]
[]
["Mitarbeiter 1"]
["Mitarbeiter 2"]
[]
["Mitarbeiter 3"]
["Mitarbeiter 4"]
[]
["Mitarbeiter 5"]
["Mitarbeiter 6",null,null,"C1","F2","Z3"]
["Mitarbeiter 7",null,null,null,null,null,null,"C2"]
["Mitarbeiter 8",null,null,null,null,null,"C3"]
["Mitarbeiter 9"]
["Mitarbeiter 10"]
["Mitarbeiter 11"]
["Mitarbeiter 12",null,null,"F2","C1"]
["Mitarbeiter 13"]
["Mitarbeiter 14",null,null,null,null,null,"Z3"]
["Mitarbeiter 15"]
["Mitarbeiter 16"]
["Mitarbeiter 17"]
["Mitarbeiter 18"]
["Mitarbeiter 19"]
["Mitarbeiter 20"]
["Mitarbeiter 21"]
["Mitarbeiter 22"]
["Mitarbeiter 23"]
["Mitarbeiter 24"]
["Mitarbeiter 25"]

{"sheet":"202502","index":2,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"IF(MATCH(D3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":"JA"},{"$f":"IF(MATCH(E3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(F3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(G3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(H3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(I3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}},{"$f":"IF(MATCH(J3,[1]Übersicht!$H$6:$H$22,0),\"JA\",\"NEIN\")","v":{"$error":"#N/A"}}]
[null,null,null,{"$f":"IFERROR(D1:D1,\"\")","v":"JA"},{"$f":"IFERROR(E1:E1,\"\")","v":""},{"$f":"IFERROR(F1:F1,\"\")","v":""},{"$f":"IFERROR(G1:G1,\"\")","v":""},{"$f":"IFERROR(H1:H1,\"\")","v":""},{"$f":"IFERROR(I1:I1,\"\")","v":""},{"$f":"IFERROR(J1:J1,\"\")","v":""}]
["KW",null,null,{"$f":"DATE(Übersicht!L1,1,1)+(A4-1)*7+1-WEEKDAY(DATE(Übersicht!L1,1,1)-1)","v":"2025-01-06"},{"$f":"D3+1","v":"2025-01-07"},{"$f":"E3+1","v":"2025-01-08"},{"$f":"F3+1","v":"2025-01-09"},"2025-01-10","2025-01-11","2025-01-12"]
[2,null,null,"Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag","Platz für Notizen:"]
[]
["Mitarbeiter 1"]
["Mitarbeiter 2"]
[]
["Mitarbeiter 3",null,null,"C1",null,null,"C1"]
["Mitarbeiter 4"]
[]
["Mitarbeiter 5",null,null,null,null,"C1"]
["Mitarbeiter 6",null,null,"F2"]
["Mitarbeiter 7"]
["Mitarbeiter 8"]
["Mitarbeiter 9",null,null,null,null,"Z3"]
["Mitarbeiter 10"]
["Mitarbeiter 11",null,null,null,null,null,"C2"]
["Mitarbeiter 12",null,null,"Z3"]
["Mitarbeiter 13"]
["Mitarbeiter 14",null,null,null,null,"F2"]
["Mitarbeiter 15"]
["Mitarbeiter 16"]
["Mitarbeiter 17"]
["Mitarbeiter 18"]
["Mitarbeiter 19"]
["Mitarbeiter 20"]
["Mitarbeiter 21"]
["Mitarbeiter 22",null,null,null,null,null,"C3"]
["Mitarbeiter 23"]
["Mitarbeiter 24"]
["Mitarbeiter 25"]