{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Kalender","Einträge","Feiertage"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"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":"Kalender","index":0,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,10,35,11],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,0,36,1],[36,2,36,3],[35,4,35,5],[35,6,35,7],[35,8,35,9]]}
[2022,null,"Baden - Württemberg"]
[]
["Januar","Februar","März","April","Mai","Juni","Juli","August ","September","Oktober","November","Dezember"]
[{"$f":"IF(MONTH(DATE($A$1,COLUMN(),ROW()-3))=COLUMN(),DATE($A$1,COLUMN(),ROW()-3),\"\")","v":"2022-01-01"},{"$f":"IF(MONTH(DATE($A$1,COLUMN(),ROW()-3))=COLUMN(),DATE($A$1,COLUMN(),ROW()-3),\"\")","v":"2022-02-01"},"2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01"]
[{"$f":"IF(MONTH(DATE($A$1,COLUMN(),ROW()-3))=COLUMN(),DATE($A$1,COLUMN(),ROW()-3),\"\")","v":"2022-01-02"},"2022-02-02","2022-03-02","2022-04-02","2022-05-02","2022-06-02","2022-07-02","2022-08-02","2022-09-02","2022-10-02","2022-11-02","2022-12-02"]
["2022-01-03","2022-02-03","2022-03-03","2022-04-03","2022-05-03","2022-06-03","2022-07-03","2022-08-03","2022-09-03","2022-10-03","2022-11-03","2022-12-03"]
["2022-01-04","2022-02-04","2022-03-04","2022-04-04","2022-05-04","2022-06-04","2022-07-04","2022-08-04","2022-09-04","2022-10-04","2022-11-04","2022-12-04"]
["2022-01-05","2022-02-05","2022-03-05","2022-04-05","2022-05-05","2022-06-05","2022-07-05","2022-08-05","2022-09-05","2022-10-05","2022-11-05","2022-12-05"]
["2022-01-06","2022-02-06","2022-03-06","2022-04-06","2022-05-06","2022-06-06","2022-07-06","2022-08-06","2022-09-06","2022-10-06","2022-11-06","2022-12-06"]
["2022-01-07","2022-02-07","2022-03-07","2022-04-07","2022-05-07","2022-06-07","2022-07-07","2022-08-07","2022-09-07","2022-10-07","2022-11-07","2022-12-07"]
["2022-01-08","2022-02-08","2022-03-08","2022-04-08","2022-05-08","2022-06-08","2022-07-08","2022-08-08","2022-09-08","2022-10-08","2022-11-08","2022-12-08"]
["2022-01-09","2022-02-09","2022-03-09","2022-04-09","2022-05-09","2022-06-09","2022-07-09","2022-08-09","2022-09-09","2022-10-09","2022-11-09","2022-12-09"]
["2022-01-10","2022-02-10","2022-03-10","2022-04-10","2022-05-10","2022-06-10","2022-07-10","2022-08-10","2022-09-10","2022-10-10","2022-11-10","2022-12-10"]
["2022-01-11","2022-02-11","2022-03-11","2022-04-11","2022-05-11","2022-06-11","2022-07-11","2022-08-11","2022-09-11","2022-10-11","2022-11-11","2022-12-11"]
["2022-01-12","2022-02-12","2022-03-12","2022-04-12","2022-05-12","2022-06-12","2022-07-12","2022-08-12","2022-09-12","2022-10-12","2022-11-12","2022-12-12"]
["2022-01-13","2022-02-13","2022-03-13","2022-04-13","2022-05-13","2022-06-13","2022-07-13","2022-08-13","2022-09-13","2022-10-13","2022-11-13","2022-12-13"]
["2022-01-14","2022-02-14","2022-03-14","2022-04-14","2022-05-14","2022-06-14","2022-07-14","2022-08-14","2022-09-14","2022-10-14","2022-11-14","2022-12-14"]
["2022-01-15","2022-02-15","2022-03-15","2022-04-15","2022-05-15","2022-06-15","2022-07-15","2022-08-15","2022-09-15","2022-10-15","2022-11-15","2022-12-15"]
["2022-01-16","2022-02-16","2022-03-16","2022-04-16","2022-05-16","2022-06-16","2022-07-16","2022-08-16","2022-09-16","2022-10-16","2022-11-16","2022-12-16"]
["2022-01-17","2022-02-17","2022-03-17","2022-04-17","2022-05-17","2022-06-17","2022-07-17","2022-08-17","2022-09-17","2022-10-17","2022-11-17","2022-12-17"]
["2022-01-18","2022-02-18","2022-03-18","2022-04-18","2022-05-18","2022-06-18","2022-07-18","2022-08-18","2022-09-18","2022-10-18","2022-11-18","2022-12-18"]
["2022-01-19","2022-02-19","2022-03-19","2022-04-19","2022-05-19","2022-06-19","2022-07-19","2022-08-19","2022-09-19","2022-10-19","2022-11-19","2022-12-19"]
["2022-01-20","2022-02-20","2022-03-20","2022-04-20","2022-05-20","2022-06-20","2022-07-20","2022-08-20","2022-09-20","2022-10-20","2022-11-20","2022-12-20"]
["2022-01-21","2022-02-21","2022-03-21","2022-04-21","2022-05-21","2022-06-21","2022-07-21","2022-08-21","2022-09-21","2022-10-21","2022-11-21","2022-12-21"]
["2022-01-22","2022-02-22","2022-03-22","2022-04-22","2022-05-22","2022-06-22","2022-07-22","2022-08-22","2022-09-22","2022-10-22","2022-11-22","2022-12-22"]
["2022-01-23","2022-02-23","2022-03-23","2022-04-23","2022-05-23","2022-06-23","2022-07-23","2022-08-23","2022-09-23","2022-10-23","2022-11-23","2022-12-23"]
["2022-01-24","2022-02-24","2022-03-24","2022-04-24","2022-05-24","2022-06-24","2022-07-24","2022-08-24","2022-09-24","2022-10-24","2022-11-24","2022-12-24"]
["2022-01-25","2022-02-25","2022-03-25","2022-04-25","2022-05-25","2022-06-25","2022-07-25","2022-08-25","2022-09-25","2022-10-25","2022-11-25","2022-12-25"]
["2022-01-26","2022-02-26","2022-03-26","2022-04-26","2022-05-26","2022-06-26","2022-07-26","2022-08-26","2022-09-26","2022-10-26","2022-11-26","2022-12-26"]
["2022-01-27","2022-02-27","2022-03-27","2022-04-27","2022-05-27","2022-06-27","2022-07-27","2022-08-27","2022-09-27","2022-10-27","2022-11-27","2022-12-27"]
["2022-01-28","2022-02-28","2022-03-28","2022-04-28","2022-05-28","2022-06-28","2022-07-28","2022-08-28","2022-09-28","2022-10-28","2022-11-28","2022-12-28"]
["2022-01-29","","2022-03-29","2022-04-29","2022-05-29","2022-06-29","2022-07-29","2022-08-29","2022-09-29","2022-10-29","2022-11-29","2022-12-29"]
["2022-01-30","","2022-03-30","2022-04-30","2022-05-30","2022-06-30","2022-07-30","2022-08-30","2022-09-30","2022-10-30","2022-11-30","2022-12-30"]
[{"$f":"IF(MONTH(DATE($A$1,COLUMN(),ROW()-3))=COLUMN(),DATE($A$1,COLUMN(),ROW()-3),\"\")","v":"2022-01-31"},"","2022-03-31","","2022-05-31","","2022-07-31","2022-08-31","","2022-10-31","","2022-12-31"]
[]
["Samstage","Sonntage","Feiertage BW","Geschlossen",{"$f":"(Einträge!B1)","v":"Privat "},null,{"$f":"(Einträge!C1)","v":"Privat 1"},null,{"$f":"(Einträge!D1)","v":"Privat 2"},null,{"$f":"(Einträge!E1)","v":"Privat 3"}]
[{"$f":"(Einträge!F1)","v":"Privat 4"},null,{"$f":"(Einträge!G1)","v":"Privat 5"},null,{"$f":"(Einträge!H1)","v":"Privat 6"},null,{"$f":"(Einträge!I1)","v":"Privat 7"},null,{"$f":"(Einträge!J1)","v":"Privat 8"},null,{"$f":"(Einträge!K1)","v":"Privat 9"}]
[{"$f":"(Feiertage!A2)","v":"Neujahr"},{"$f":"(Feiertage!B2)","v":"2022-01-01"},{"$f":"(Feiertage!A3)","v":"Heilige Drei Könige"},{"$f":"(Feiertage!B3)","v":"2022-01-06"},{"$f":"(Feiertage!A5)","v":"Karfreitag"},{"$f":"(Feiertage!B5)","v":"2022-04-15"},{"$f":"(Feiertage!A6)","v":"Ostersonntag"},{"$f":"(Feiertage!B6)","v":"2022-04-17"},{"$f":"(Feiertage!A7)","v":"Ostermontag"},{"$f":"(Feiertage!B7)","v":"2022-04-18"},{"$f":"(Feiertage!A8)","v":"Tag der Arbeit"},{"$f":"(Feiertage!B8)","v":"2022-05-01"}]
[{"$f":"(Feiertage!A9)","v":"Christi Himmelfahrt"},{"$f":"(Feiertage!B9)","v":"2022-05-26"},{"$f":"(Feiertage!A10)","v":"Pfingstsonntag"},{"$f":"(Feiertage!B10)","v":"2022-06-05"},{"$f":"(Feiertage!A11)","v":"Pfingstmontag"},{"$f":"(Feiertage!B11)","v":"2022-06-06"},{"$f":"(Feiertage!A12)","v":"Fronleichnam"},{"$f":"(Feiertage!B12)","v":"2022-06-16"},{"$f":"(Feiertage!A14)","v":"Tag der D Einheit"},{"$f":"(Feiertage!B14)","v":"2022-10-03"},{"$f":"(Feiertage!A16)","v":"Allerheiligen"},{"$f":"(Feiertage!B16)","v":"2022-11-01"}]
[{"$f":"(Feiertage!A18)","v":"1. Weihnachtstag"},{"$f":"(Feiertage!B18)","v":"2022-12-25"},{"$f":"(Feiertage!A19)","v":"2. Weihnachtstag"},{"$f":"(Feiertage!B19)","v":"2022-12-26"}]
[{"$f":"(Feiertage!A4)","v":"Rosenmontag"},{"$f":"(Feiertage!B4)","v":"2022-02-28"},{"$f":"(Feiertage!A13)","v":"Maria Himmelfahrt"},{"$f":"(Feiertage!B13)","v":"2022-08-15"},{"$f":"(Feiertage!A15)","v":"Reformationstag"},{"$f":"(Feiertage!B15)","v":"2022-10-31"},{"$f":"(Feiertage!A17)","v":"Buß- und Bettag"},{"$f":"(Feiertage!B17)","v":"2022-11-16"},{"$f":"(Feiertage!A20)","v":"Silvester"},{"$f":"(Feiertage!B20)","v":"2022-12-31"}]

{"sheet":"Einträge","index":1,"n_rows":103,"n_cols":11,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,0,1,10],[102,1,102,10]]}
["Geschlossen","Privat ","Privat 1","Privat 2","Privat 3","Privat 4","Privat 5","Privat 6","Privat 7","Privat 8","Privat 9"]
["Machen sie hier Ihre Einträge / Privat bis Privat 9 kann umbenannt werden. Farbe im Kalender nicht änderbar. Doppelte werden Rot angezeigt. Das heißt: Es wird nur 1 Wert angezeigt. Dann immer der letzte eingegebene."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ab hier kann kein Eintrag mehr in diesen Spalten gemacht werden. Bei geschlossen kann weiterhin ein Eintrag vorgenommen werden."]

{"sheet":"Feiertage","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"(Kalender!A1)","v":2022}]
["Neujahr",{"$f":"DATE($A$1,1,1)","v":"2022-01-01"},"Neujahr",{"$f":"DATE($A$1,1,1)","v":"2022-01-01"}]
["Heilige Drei Könige",{"$f":"DATE($A$1,1,6)","v":"2022-01-06"},"Heilige Drei Könige",{"$f":"DATE($A$1,1,6)","v":"2022-01-06"}]
["Rosenmontag",{"$f":"($B$6-48)","v":"2022-02-28"},"Karfreitag",{"$f":"($B$6-2)","v":"2022-04-15"}]
["Karfreitag",{"$f":"($B$6-2)","v":"2022-04-15"},"Ostersonntag",{"$f":"ROUND((DAY(MINUTE($A$1/38)/2+55)&\".4.\"&$A$1)/7,)*7-6","v":"2022-04-17"}]
["Ostersonntag",{"$f":"ROUND((DAY(MINUTE($A$1/38)/2+55)&\".4.\"&$A$1)/7,)*7-6","v":"2022-04-17"},"Ostermontag",{"$f":"($B$6+1)","v":"2022-04-18"}]
["Ostermontag",{"$f":"($B$6+1)","v":"2022-04-18"},"Tag der Arbeit",{"$f":"DATE($A$1,5,1)","v":"2022-05-01"}]
["Tag der Arbeit",{"$f":"DATE($A$1,5,1)","v":"2022-05-01"},"Christi Himmelfahrt",{"$f":"($B$6+39)","v":"2022-05-26"}]
["Christi Himmelfahrt",{"$f":"($B$6+39)","v":"2022-05-26"},"Pfingstsonntag",{"$f":"($B$6+49)","v":"2022-06-05"}]
["Pfingstsonntag",{"$f":"($B$6+49)","v":"2022-06-05"},"Pfingstmontag",{"$f":"($B$6+50)","v":"2022-06-06"}]
["Pfingstmontag",{"$f":"($B$6+50)","v":"2022-06-06"},"Fronleichnam",{"$f":"($B$6+60)","v":"2022-06-16"}]
["Fronleichnam",{"$f":"($B$6+60)","v":"2022-06-16"},"Tag der D Einheit",{"$f":"DATE($A$1,10,3)","v":"2022-10-03"}]
["Maria Himmelfahrt",{"$f":"DATE($A$1,8,15)","v":"2022-08-15"},"Allerheiligen",{"$f":"DATE($A$1,11,1)","v":"2022-11-01"}]
["Tag der D Einheit",{"$f":"DATE($A$1,10,3)","v":"2022-10-03"},"1. Weihnachtstag",{"$f":"DATE($A$1,12,25)","v":"2022-12-25"}]
["Reformationstag",{"$f":"DATE($A$1,10,31)","v":"2022-10-31"},"2. Weihnachtstag",{"$f":"DATE($A$1,12,26)","v":"2022-12-26"}]
["Allerheiligen",{"$f":"DATE($A$1,11,1)","v":"2022-11-01"}]
["Buß- und Bettag",{"$f":"DATE($A$1,12,25)-WEEKDAY(DATE($A$1,12,25),2)-32","v":"2022-11-16"}]
["1. Weihnachtstag",{"$f":"DATE($A$1,12,25)","v":"2022-12-25"}]
["2. Weihnachtstag",{"$f":"DATE($A$1,12,26)","v":"2022-12-26"}]
["Silvester",{"$f":"DATE($A$1,12,31)","v":"2022-12-31"}]