{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tabelle1","Tabelle2","Tabelle3","Tabelle4"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":18,"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":"Tabelle1","index":0,"n_rows":51,"n_cols":54,"rows_kept":51,"cut":false,"hidden":false,"merged":[[42,1,42,31],[2,0,3,3],[4,2,4,3],[4,4,4,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[40,2,40,4],[40,6,40,8],[40,10,40,11],[40,13,40,17],[40,19,40,23]]}
[]
[]
["Projektplan"]
[]
[null,null,"Auswahlbereich",null,"Tabelle4"]
[]
["AKTIVITÄT","START DES PLANS","DAUER DES PLANS","TATSÄCHLICHER START","TATSÄCHLICHE DAUER","PROZENT ABGESCHLOSSEN","ZEITRÄUME"]
[null,null,null,null,null,null,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,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48]
["Aktivität 01",1,5,1,4,0.25]
["Aktivität 02",1,6,1,6,1]
["Aktivität 03",2,4,2,5,0.35]
["Aktivität 04",4,8,4,6,0.1]
["Aktivität 05",4,2,4,8,0.85]
["Aktivität 06",4,3,4,6,0.85]
["Aktivität 07",5,4,5,3,0.5]
["Aktivität 08",5,2,5,5,0.6]
["Aktivität 09",5,2,5,6,0.75]
["Aktivität 10",6,5,6,7,1]
["Aktivität 11",6,1,5,8,0.6]
["Aktivität 12",9,3,9,3,0]
["Aktivität 13",9,6,9,7,0.5]
["Aktivität 14",9,3,9,1,0]
["Aktivität 15",9,4,8,5,0.01]
["Aktivität 16",10,5,10,3,0.8]
["Aktivität 17",11,2,11,5,0]
["Aktivität 18",12,6,12,7,0]
["Aktivität 19",12,1,12,5,0]
["Aktivität 20",14,5,14,6,0]
["Aktivität 21",14,8,14,2,0.44]
["Aktivität 22",14,7,14,3,0]
["Aktivität 23",15,4,15,8,0.12]
["Aktivität 24",15,5,15,3,0.05]
["Aktivität 25",15,8,15,5,0]
["Aktivität 26",16,28,16,30,0.5]
[]
[]
[]
["Abwesenheitsplan für Mitarbeiter"]
["Februar"]
[]
["Schlüssel für Abwesenheitstyp","U","Urlaub",null,null,"P","Privat",null,null,"K","Krank",null,null,"Benutzerdefiniert 1",null,null,null,null,null,"Benutzerdefiniert 2"]
[]
[null,"Abwesenheitsdaten",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":"Kalenderjahr","v":0}]
[null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,1),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,2),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,3),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,4),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,5),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,6),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,7),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,8),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,9),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,10),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,11),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,12),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,13),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,14),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,15),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,16),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,17),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,18),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,19),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,20),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,21),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,22),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,23),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,24),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,25),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,26),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,27),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,28),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,29),1),\"aaa\")","v":"Mi"}]
["Mitarbeitername","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"," ","  ","Tage gesamt"]
["Harsimran Brar",null,null,"U","U","U","U",null,null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(Februar9[[#This Row],[1]:[29]])","v":5}]
["Jordan Mitchell",null,null,null,null,"K","K",null,null,null,null,"P",null,null,null,null,null,null,null,null,"K",null,null,null,null,"U","U","U",null,null,null,null,{"$f":"COUNTA(Februar9[[#This Row],[1]:[29]])","v":7}]
["Asaf Karten",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":"COUNTA(Februar9[[#This Row],[1]:[29]])","v":0}]
["Vanja Jovanovic",null,null,"K",null,null,null,null,null,null,null,null,null,null,"K",null,null,null,"P",null,null,null,null,null,null,null,null,null,"K",null,null,null,{"$f":"COUNTA(Februar9[[#This Row],[1]:[29]])","v":4}]
["Madison Butler",null,null,null,null,null,null,null,"U","U","U","U",null,null,null,null,null,null,null,null,null,null,null,null,"K",null,null,null,null,null,null,null,{"$f":"COUNTA(Februar9[[#This Row],[1]:[29]])","v":5}]
[{"$f":"Monatsname&\" ergebnis\"","v":" ergebnis"},{"$f":"SUBTOTAL(103,Februar9[1])","v":0},{"$f":"SUBTOTAL(103,Februar9[2])","v":0},{"$f":"SUBTOTAL(103,Februar9[3])","v":2},{"$f":"SUBTOTAL(103,Februar9[4])","v":1},{"$f":"SUBTOTAL(103,Februar9[5])","v":2},{"$f":"SUBTOTAL(103,Februar9[6])","v":2},{"$f":"SUBTOTAL(103,Februar9[7])","v":0},{"$f":"SUBTOTAL(103,Februar9[8])","v":1},{"$f":"SUBTOTAL(103,Februar9[9])","v":1},{"$f":"SUBTOTAL(103,Februar9[10])","v":1},{"$f":"SUBTOTAL(103,Februar9[11])","v":2},{"$f":"SUBTOTAL(103,Februar9[12])","v":0},{"$f":"SUBTOTAL(103,Februar9[13])","v":1},{"$f":"SUBTOTAL(103,Februar9[14])","v":1},{"$f":"SUBTOTAL(103,Februar9[15])","v":0},{"$f":"SUBTOTAL(103,Februar9[16])","v":0},{"$f":"SUBTOTAL(103,Februar9[17])","v":0},{"$f":"SUBTOTAL(103,Februar9[18])","v":1},{"$f":"SUBTOTAL(103,Februar9[19])","v":0},{"$f":"SUBTOTAL(103,Februar9[20])","v":1},{"$f":"SUBTOTAL(103,Februar9[21])","v":0},{"$f":"SUBTOTAL(103,Februar9[22])","v":0},{"$f":"SUBTOTAL(103,Februar9[23])","v":0},{"$f":"SUBTOTAL(103,Februar9[24])","v":1},{"$f":"SUBTOTAL(103,Februar9[25])","v":1},{"$f":"SUBTOTAL(103,Februar9[26])","v":1},{"$f":"SUBTOTAL(103,Februar9[27])","v":1},{"$f":"SUBTOTAL(103,Februar9[28])","v":1},{"$f":"SUBTOTAL(103,Februar9[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Februar9[Tage gesamt])","v":21}]

{"sheet":"Tabelle2","index":1,"n_rows":35,"n_cols":37,"rows_kept":35,"cut":false,"hidden":false,"merged":[[31,35,31,39],[34,3,34,39],[35,3,35,39],[36,3,36,39],[37,3,37,39],[38,3,38,39],[31,4,31,8],[31,10,31,13],[31,15,31,18],[31,20,31,23],[31,25,31,28],[31,30,31,33],[29,35,29,39],[30,4,30,8],[30,10,30,13],[30,15,30,18],[30,20,30,23],[30,25,30,28],[30,30,30,33],[30,35,30,39],[29,4,29,8],[29,10,29,13],[29,15,29,18],[29,20,29,23],[29,25,29,28],[29,30,29,33],[27,35,27,39],[28,4,28,8],[28,10,28,13],[28,15,28,18],[28,20,28,23],[28,25,28,28],[28,30,28,33],[28,35,28,39],[27,4,27,8],[27,10,27,13],[27,15,27,18],[27,20,27,23],[27,25,27,28],[27,30,27,33],[25,35,25,39],[26,4,26,8],[26,10,26,13],[26,15,26,18],[26,20,26,23],[26,25,26,28],[26,30,26,33],[26,35,26,39],[25,4,25,8],[25,10,25,13],[25,15,25,18],[25,20,25,23],[25,25,25,28],[25,30,25,33],[23,35,23,39],[24,4,24,8],[24,10,24,13],[24,15,24,18],[24,20,24,23],[24,25,24,28],[24,30,24,33],[24,35,24,39],[23,4,23,8],[23,10,23,13],[23,15,23,18],[23,20,23,23],[23,25,23,28],[23,30,23,33],[21,35,21,39],[22,4,22,8],[22,10,22,13],[22,15,22,18],[22,20,22,23],[22,25,22,28],[22,30,22,33],[22,35,22,39],[21,4,21,8],[21,10,21,13],[21,15,21,18],[21,20,21,23],[21,25,21,28],[21,30,21,33],[19,35,19,39],[20,4,20,8],[20,10,20,13],[20,15,20,18],[20,20,20,23],[20,25,20,28],[20,30,20,33],[20,35,20,39],[19,4,19,8],[19,10,19,13],[19,15,19,18],[19,20,19,23],[19,25,19,28],[19,30,19,33],[15,26,15,28],[15,29,16,30],[15,31,15,33],[17,35,17,39],[18,4,18,8],[18,10,18,13],[18,15,18,18],[18,20,18,23],[18,25,18,28],[18,30,18,33],[18,35,18,39],[17,4,17,8],[17,10,17,13],[17,15,17,18],[17,20,17,23],[17,25,17,28],[17,30,17,33],[15,3,16,4],[15,5,15,8],[15,9,16,10],[15,11,15,13],[15,14,16,15],[15,16,15,18],[11,3,11,13],[11,17,11,26],[11,29,11,39],[12,3,12,13],[12,17,12,26],[12,29,12,39],[15,34,16,35],[15,36,15,38],[16,5,16,8],[16,11,16,13],[16,16,16,18],[16,21,16,23],[16,26,16,28],[16,31,16,33],[16,36,16,38],[15,19,16,20],[15,21,15,23],[15,24,16,25],[10,3,10,13],[10,17,10,26],[10,29,10,39],[7,3,7,13],[7,17,7,26],[7,29,7,39],[8,3,8,13],[8,17,8,26],[8,29,8,39],[3,3,3,39],[4,17,4,21],[4,22,4,26],[6,3,6,13],[6,16,6,26],[6,29,6,39],[9,3,9,13],[9,17,9,26],[9,29,9,39]]}
[]
[]
[]
[null,null,null,"Wöchentlicher Terminplan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woche vom:",null,null,null,null,{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2024-12-16"}]
[]
[null,null,null,"Wochenziele",null,null,null,null,null,null,null,null,null,null,null,null,"Aufgaben",null,null,null,null,null,null,null,null,null,null,null,null,"Termine dieser Woche"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"TEXT(Anfangsdatum+0,\"TT\")","v":"16"},null,{"$f":"(TEXT(Anfangsdatum+0,\"aaaa\"))","v":"Montag"},null,null,null,{"$f":"TEXT(Anfangsdatum+1,\"TT\")","v":"17"},null,{"$f":"(TEXT(Anfangsdatum+1,\"aaaa\"))","v":"Dienstag"},null,null,{"$f":"TEXT(Anfangsdatum+2,\"TT\")","v":"18"},null,{"$f":"(TEXT(Anfangsdatum+2,\"aaaa\"))","v":"Mittwoch"},null,null,{"$f":"TEXT(Anfangsdatum+3,\"TT\")","v":"19"},null,{"$f":"(TEXT(Anfangsdatum+3,\"aaaa\"))","v":"Donnerstag"},null,null,{"$f":"TEXT(Anfangsdatum+4,\"TT\")","v":"20"},null,{"$f":"(TEXT(Anfangsdatum+4,\"aaaa\"))","v":"Freitag"},null,null,{"$f":"TEXT(Anfangsdatum+5,\"TT\")","v":"21"},null,{"$f":"(TEXT(Anfangsdatum+5,\"aaaa\"))","v":"Samstag"},null,null,{"$f":"TEXT(Anfangsdatum+6,\"TT\")","v":"22"},null,{"$f":"(TEXT(Anfangsdatum+6,\"aaaa\"))","v":"Sonntag"}]
[null,null,null,null,null,{"$f":"(TEXT(Anfangsdatum+0,\"MMMM\"))","v":"Dezember"},null,null,null,null,null,{"$f":"(TEXT(Anfangsdatum+1,\"MMMM\"))","v":"Dezember"},null,null,null,null,{"$f":"(TEXT(Anfangsdatum+2,\"MMMM\"))","v":"Dezember"},null,null,null,null,{"$f":"(TEXT(Anfangsdatum+3,\"MMMM\"))","v":"Dezember"},null,null,null,null,{"$f":"(TEXT(Anfangsdatum+4,\"MMMM\"))","v":"Dezember"},null,null,null,null,{"$f":"(TEXT(Anfangsdatum+5,\"MMMM\"))","v":"Dezember"},null,null,null,null,{"$f":"(TEXT(Anfangsdatum+6,\"MMMM\"))","v":"Dezember"}]
[null,null,null,"✔","Dies ist ein Beispieltext."]
[null,null,null,"✖","Dies ist ein Beispieltext."]
[null,null,null,"✔","Dies ist ein Beispieltext."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Notizen"]

{"sheet":"Tabelle3","index":2,"n_rows":16,"n_cols":33,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,7,31],[5,2,5,4],[5,6,5,8],[5,10,5,11],[5,13,5,17],[5,19,5,23]]}
[]
[]
["Abwesenheitsplan für Mitarbeiter"]
["Januar"]
[]
["Schlüssel für Abwesenheitstyp","U","Urlaub",null,null,"P","Privat",null,null,"K","Krank",null,null,"Benutzerdefiniert 1",null,null,null,null,null,"Benutzerdefiniert 2"]
[]
[null,"Abwesenheitsdaten",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,2023]
[null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,1),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,2),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,3),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,4),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,5),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,6),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,7),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,8),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,9),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,10),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,11),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,12),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,13),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,14),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,15),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,16),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,17),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,18),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,19),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,20),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,21),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,22),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,23),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,24),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,25),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,26),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,27),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,28),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,29),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,30),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,1,31),1),\"aaa\")","v":"Di"}]
["Mitarbeitername","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","Tage gesamt"]
["Harsimran Brar",null,null,"U","U","U","U",null,null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA([3]Januar!$C11:$AG11)","v":3}]
["Jordan Mitchell",null,null,null,null,"K","K",null,null,null,null,"P",null,null,null,null,null,null,null,null,"K",null,null,null,null,"U","U","U",null,null,null,null,{"$f":"COUNTA([3]Januar!$C12:$AG12)","v":4}]
["Asaf Karten",null,null,"P",null,null,null,null,null,null,null,null,null,null,"K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",null,null,{"$f":"COUNTA([3]Januar!$C13:$AG13)","v":6}]
["Vanja Jovanovic",null,null,null,null,null,null,"P",null,null,null,null,null,null,null,null,null,null,null,"U","U","U",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA([3]Januar!$C14:$AG14)","v":31}]
["Madison Butler",null,null,null,"K","U","U",null,null,null,null,null,null,null,null,null,null,"K",null,null,null,null,null,null,"K",null,null,null,null,null,null,"V",{"$f":"COUNTA([3]Januar!$C15:$AG15)","v":0}]
[{"$f":"Monatsname&\" ergebnis\"","v":" ergebnis"},{"$f":"SUBTOTAL(103,[3]Januar!$C$9:$C$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$D$9:$D$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$E$9:$E$13)","v":2},{"$f":"SUBTOTAL(103,[3]Januar!$F$9:$F$13)","v":2},{"$f":"SUBTOTAL(103,[3]Januar!$G$9:$G$13)","v":3},{"$f":"SUBTOTAL(103,[3]Januar!$H$9:$H$13)","v":3},{"$f":"SUBTOTAL(103,[3]Januar!$I$9:$I$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$J$9:$J$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$K$9:$K$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$L$9:$L$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$M$9:$M$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$N$9:$N$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$O$9:$O$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$P$9:$P$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$Q$9:$Q$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$R$9:$R$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$S$9:$S$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$T$9:$T$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$U$9:$U$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$V$9:$V$13)","v":2},{"$f":"SUBTOTAL(103,[3]Januar!$W$9:$W$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$X$9:$X$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$Y$9:$Y$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$Z$9:$Z$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$AA$9:$AA$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$AB$9:$AB$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$AC$9:$AC$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$AD$9:$AD$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$AE$9:$AE$13)","v":1},{"$f":"SUBTOTAL(103,[3]Januar!$AF$9:$AF$13)","v":0},{"$f":"SUBTOTAL(103,[3]Januar!$AG$9:$AG$13)","v":1},{"$f":"SUBTOTAL(109,Januar[Tage gesamt])","v":44}]

{"sheet":"Tabelle4","index":3,"n_rows":16,"n_cols":33,"rows_kept":16,"cut":false,"hidden":false,"merged":[[7,1,7,31],[5,2,5,4],[5,6,5,8],[5,10,5,11],[5,13,5,17],[5,19,5,23]]}
[]
[]
["Abwesenheitsplan für Mitarbeiter"]
["Februar"]
[]
["Schlüssel für Abwesenheitstyp","U","Urlaub",null,null,"P","Privat",null,null,"K","Krank",null,null,"Benutzerdefiniert 1",null,null,null,null,null,"Benutzerdefiniert 2"]
[]
[null,"Abwesenheitsdaten",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":"Kalenderjahr","v":0}]
[null,{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,1),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,2),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,3),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,4),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,5),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,6),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,7),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,8),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,9),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,10),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,11),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,12),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,13),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,14),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,15),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,16),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,17),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,18),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,19),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,20),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,21),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,22),1),\"aaa\")","v":"Mi"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,23),1),\"aaa\")","v":"Do"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,24),1),\"aaa\")","v":"Fr"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,25),1),\"aaa\")","v":"Sa"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,26),1),\"aaa\")","v":"So"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,27),1),\"aaa\")","v":"Mo"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,28),1),\"aaa\")","v":"Di"},{"$f":"TEXT(WEEKDAY(DATE(Kalenderjahr,2,29),1),\"aaa\")","v":"Mi"}]
["Mitarbeitername","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"," ","  ","Tage gesamt"]
["Harsimran Brar",null,null,"U","U","U","U",null,null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(Februar[[#This Row],[1]:[29]])","v":5}]
["Jordan Mitchell",null,null,null,null,"K","K",null,null,null,null,"P",null,null,null,null,null,null,null,null,"K",null,null,null,null,"U","U","U",null,null,null,null,{"$f":"COUNTA(Februar[[#This Row],[1]:[29]])","v":7}]
["Asaf Karten",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":"COUNTA(Februar[[#This Row],[1]:[29]])","v":0}]
["Vanja Jovanovic",null,null,"K",null,null,null,null,null,null,null,null,null,null,"K",null,null,null,"P",null,null,null,null,null,null,null,null,null,"K",null,null,null,{"$f":"COUNTA(Februar[[#This Row],[1]:[29]])","v":4}]
["Madison Butler",null,null,null,null,null,null,null,"U","U","U","U",null,null,null,null,null,null,null,null,null,null,null,null,"K",null,null,null,null,null,null,null,{"$f":"COUNTA(Februar[[#This Row],[1]:[29]])","v":5}]
[{"$f":"Monatsname&\" ergebnis\"","v":" ergebnis"},{"$f":"SUBTOTAL(103,Februar[1])","v":0},{"$f":"SUBTOTAL(103,Februar[2])","v":0},{"$f":"SUBTOTAL(103,Februar[3])","v":2},{"$f":"SUBTOTAL(103,Februar[4])","v":1},{"$f":"SUBTOTAL(103,Februar[5])","v":2},{"$f":"SUBTOTAL(103,Februar[6])","v":2},{"$f":"SUBTOTAL(103,Februar[7])","v":0},{"$f":"SUBTOTAL(103,Februar[8])","v":1},{"$f":"SUBTOTAL(103,Februar[9])","v":1},{"$f":"SUBTOTAL(103,Februar[10])","v":1},{"$f":"SUBTOTAL(103,Februar[11])","v":2},{"$f":"SUBTOTAL(103,Februar[12])","v":0},{"$f":"SUBTOTAL(103,Februar[13])","v":1},{"$f":"SUBTOTAL(103,Februar[14])","v":1},{"$f":"SUBTOTAL(103,Februar[15])","v":0},{"$f":"SUBTOTAL(103,Februar[16])","v":0},{"$f":"SUBTOTAL(103,Februar[17])","v":0},{"$f":"SUBTOTAL(103,Februar[18])","v":1},{"$f":"SUBTOTAL(103,Februar[19])","v":0},{"$f":"SUBTOTAL(103,Februar[20])","v":1},{"$f":"SUBTOTAL(103,Februar[21])","v":0},{"$f":"SUBTOTAL(103,Februar[22])","v":0},{"$f":"SUBTOTAL(103,Februar[23])","v":0},{"$f":"SUBTOTAL(103,Februar[24])","v":1},{"$f":"SUBTOTAL(103,Februar[25])","v":1},{"$f":"SUBTOTAL(103,Februar[26])","v":1},{"$f":"SUBTOTAL(103,Februar[27])","v":1},{"$f":"SUBTOTAL(103,Februar[28])","v":1},{"$f":"SUBTOTAL(103,Februar[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Februar[Tage gesamt])","v":21}]