{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Kalender","Termine"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Kalender","index":0,"n_rows":82,"n_cols":34,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,2,2,2],[1,3,1,33],[57,4,57,5],[57,6,57,7],[57,10,57,11],[58,6,58,7],[56,2,56,3],[56,4,56,5],[56,6,56,7]]}
[]
[null,null,"Jahr",{"$f":"C64","v":"2025-07-01"}]
[null,null,null,{"$f":"_xlfn.SEQUENCE(1,EOMONTH(DATE(YEAR($E$58),MONTH($C64),1),0)-DATE(YEAR($E$58),MONTH($C64),1)+1,DATE(YEAR($E$58),MONTH($C64),1))","v":"2025-07-01"},"2025-07-02","2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30","2025-07-31"]
[null,null,"2025-07-01",{"$f":"WEEKDAY(D3)","v":"1900-01-03"},{"$f":"WEEKDAY(E3)","v":"1900-01-04"},"1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05"]
[null,null,{"$f":"DATE(YEAR($C4),MONTH($C4)+12,DAY($C4))","v":"2026-07-01"},{"$f":"IF(D$3<>\"\",_xlfn.XLOOKUP(D$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(E$3<>\"\",_xlfn.XLOOKUP(E$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(F$3<>\"\",_xlfn.XLOOKUP(F$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(G$3<>\"\",_xlfn.XLOOKUP(G$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(H$3<>\"\",_xlfn.XLOOKUP(H$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(I$3<>\"\",_xlfn.XLOOKUP(I$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(J$3<>\"\",_xlfn.XLOOKUP(J$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(K$3<>\"\",_xlfn.XLOOKUP(K$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(L$3<>\"\",_xlfn.XLOOKUP(L$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(M$3<>\"\",_xlfn.XLOOKUP(M$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(N$3<>\"\",_xlfn.XLOOKUP(N$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(O$3<>\"\",_xlfn.XLOOKUP(O$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(P$3<>\"\",_xlfn.XLOOKUP(P$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(Q$3<>\"\",_xlfn.XLOOKUP(Q$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(R$3<>\"\",_xlfn.XLOOKUP(R$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(S$3<>\"\",_xlfn.XLOOKUP(S$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(T$3<>\"\",_xlfn.XLOOKUP(T$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(U$3<>\"\",_xlfn.XLOOKUP(U$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(V$3<>\"\",_xlfn.XLOOKUP(V$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(W$3<>\"\",_xlfn.XLOOKUP(W$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(X$3<>\"\",_xlfn.XLOOKUP(X$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(Y$3<>\"\",_xlfn.XLOOKUP(Y$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(Z$3<>\"\",_xlfn.XLOOKUP(Z$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AA$3<>\"\",_xlfn.XLOOKUP(AA$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AB$3<>\"\",_xlfn.XLOOKUP(AB$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AC$3<>\"\",_xlfn.XLOOKUP(AC$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AD$3<>\"\",_xlfn.XLOOKUP(AD$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AE$3<>\"\",_xlfn.XLOOKUP(AE$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AF$3<>\"\",_xlfn.XLOOKUP(AF$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AG$3<>\"\",_xlfn.XLOOKUP(AG$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""},{"$f":"IF(AH$3<>\"\",_xlfn.XLOOKUP(AH$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")","v":""}]
[null,null,null,{"$f":"IF(WEEKDAY(D$3)=2,\" KW\"&_xlfn.ISOWEEKNUM(D$3),\"\")","v":""},{"$f":"IF(WEEKDAY(E$3)=2,\" KW\"&_xlfn.ISOWEEKNUM(E$3),\"\")","v":""},"","","",""," KW28","","","","","",""," KW29","","","","","",""," KW30","","","","","",""," KW31","","",""]
[null,null,null,{"$f":"IF(D$3<>\"\",_xlfn.XLOOKUP(D$3,$K$61:$K$82,$E$61:$E$82,\"\"),\"\")&IF(WEEKDAY(D$3)=2,\" KW\"&_xlfn.ISOWEEKNUM(D$3),\"\")","v":""},null,null,"Un",null,"Pr",null,null,null,"Un",null,"Pr",null,null,null,"Un",null,"Pr",null,null,"Un",null,null,"Pr",null,null,null,null,"Un","Un"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Un =","Universität"]
[null,null,null,null,null,null,"Pr '=","Praktischer Dienst"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Kalenderjahr"]
[null,null,"Monat (Start)",null,"Jahr"]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58),DAY($E$58))","v":"2025-01-01"},null,"2025-01-01",null,null,null,null,null,null,null,{"$f":"DATE(YEAR($E58),MONTH($E58)+12,DAY($E58))","v":"2026-01-01"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$1),DAY($E$58))","v":"2025-02-01"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$2),DAY($E$58))","v":"2025-03-01"},null,"Feiertag",null,null,null,"Termintyp",null,"Datum"]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$3),DAY($E$58))","v":"2025-04-01"},null,"Neujahr",null,null,null,"Fix",null,{"$f":"DATE(YEAR($E$58),1,1)","v":"2025-01-01"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$4),DAY($E$58))","v":"2025-05-01"},null,"Tag der Arbeit",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),5,1)","v":"2025-05-01"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$5),DAY($E$58))","v":"2025-06-01"},null,"Tag der deutschen Einheit",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),10,1)","v":"2025-10-01"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$6),DAY($E$58))","v":"2025-07-01"},null,"Reformationstag",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),10,31)","v":"2025-10-31"}]
[null,null,{"$f":"DATE(YEAR($E$58),MONTH($E$58)+ROW($A$7),DAY($E$58))","v":"2025-08-01"},null,"Heiligabend",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),12,24)","v":"2025-12-24"}]
[null,null,null,null,"1. Weihnachtstag",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),12,25)","v":"2025-12-25"}]
[null,null,null,null,"2.Weihnachtstag",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),12,26)","v":"2025-12-26"}]
[null,null,null,null,"Silvester",null,null,null,"Fix",null,{"$f":"DATE(YEAR(Kalender!$E$58),12,31)","v":"2025-12-31"}]
[]
[null,null,null,null,"Ostersonntag",null,null,null,"Anker",null,{"$f":"7*ROUND((4&-YEAR($E$58))/7+MOD(19*MOD(YEAR($E$58),19)-7,30)*0.14,)-6","v":"2025-04-20"}]
[null,null,null,null,"Karfreitag",null,null,null,"abhängig",null,{"$f":"$K70-2","v":"2025-04-18"}]
[null,null,null,null,"Ostermontag",null,null,null,"abhängig",null,{"$f":"$K70+1","v":"2025-04-21"}]
[null,null,null,null,"Christi Himmelfahrt",null,null,null,"abhängig",null,{"$f":"$K70+39","v":"2025-05-29"}]
[null,null,null,null,"Pfingssonntag",null,null,null,"abhängig",null,{"$f":"$K70+49","v":"2025-06-08"}]
[null,null,null,null,"Pfingsmontag",null,null,null,"abhängig",null,{"$f":"$K70+50","v":"2025-06-09"}]
[null,null,null,null,"Neujahr",null,null,null,null,null,{"$f":"DATE(YEAR($M$58),1,1)","v":"2026-01-01"}]
[null,null,null,null,"Ostersonntag",null,null,null,null,null,{"$f":"7*ROUND((4&-YEAR($M$58))/7+MOD(19*MOD(YEAR($M$58),19)-7,30)*0.14,)-6","v":"2026-04-05"}]
[null,null,null,null,"Karfreitag",null,null,null,null,null,{"$f":"$K77-2","v":"2026-04-03"}]
[null,null,null,null,"Ostermontag",null,null,null,null,null,{"$f":"$K77+1","v":"2026-04-06"}]
[null,null,null,null,"Christi Himmelfahrt",null,null,null,null,null,{"$f":"$K77+39","v":"2026-05-14"}]
[null,null,null,null,"Pfingssonntag",null,null,null,null,null,{"$f":"$K77+49","v":"2026-05-24"}]
[null,null,null,null,"Pfingsmontag",null,null,null,null,null,{"$f":"$K77+50","v":"2026-05-25"}]

{"sheet":"Termine","index":1,"n_rows":7,"n_cols":64,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,"Termine Universität"]
[]
[null,null,{"$f":"IF(Br_Einheit=\"Un\",Br_Datum,\"\")","v":""},"","","2025-07-04","","","","","","2025-07-10","","","","","","2025-07-16","","","","","2025-07-21","","","","","","","","2025-07-29","2025-07-30","",{"$f":"IF(Br_Einheit=\"Pr\",Br_Datum,\"\")","v":""},"","","","","2025-07-06","","","","","","2025-07-12","","","","","","2025-07-18","","","","","","2025-07-24","","","","","","",""]