{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planer","Admin","MiniaturKalender"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":15,"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":"Planer","index":0,"n_rows":45,"n_cols":37,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,16,5,17],[5,21,5,22],[5,26,5,27],[13,26,13,27],[1,1,1,4],[5,1,5,2],[5,6,5,7],[5,11,5,12]]}
[null,"2020-01-01"]
[null,{"$f":"StartDatum","v":"2020-01-06"},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,"Bitte gewünschten Zeitraum auswählen",null,null,null,null,"2020-01-06"]
[null,{"$f":"\"WOCHE \"&WEEKNUM(StartDatum,2)&\"  |  \"&IF(DAY(EndDatum)<DAY(StartDatum),MONTH(StartDatum)&\".\"&DAY(StartDatum)&\"-\"&MONTH(EndDatum)&\".\"&DAY(EndDatum),DAY(StartDatum)&\"-\"&DAY(EndDatum))","v":"WOCHE 2  |  6-12"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Author","v":"Marie von Ebner-Eschenbach"}]
[]
[null,{"$f":"StartDatum","v":"2020-01-06"},null,null,null,null,{"$f":"B6+1","v":"2020-01-07"},null,null,null,null,{"$f":"G6+1","v":"2020-01-08"},null,null,null,null,{"$f":"L6+1","v":"2020-01-09"},null,null,null,null,{"$f":"Q6+1","v":"2020-01-10"},null,null,null,null,{"$f":"V6+1","v":"2020-01-11"}]
[null,"07:00:00",null,null,null,null,"07:00:00",null,null,null,null,"07:00:00",null,null,null,null,"07:00:00",null,null,null,null,"07:00:00"]
[null,"08:00:00",null,null,null,null,"08:00:00",null,null,null,null,"08:00:00",null,null,null,null,"08:00:00",null,null,null,null,"08:00:00"]
[null,"09:00:00",null,null,null,null,"09:00:00",null,null,null,null,"09:00:00",null,null,null,null,"09:00:00",null,null,null,null,"09:00:00"]
[null,"10:00:00",null,null,null,null,"10:00:00",null,null,null,null,"10:00:00",null,null,null,null,"10:00:00",null,null,null,null,"10:00:00"]
[null,"11:00:00",null,null,null,null,"11:00:00",null,null,null,null,"11:00:00",null,null,null,null,"11:00:00",null,null,null,null,"11:00:00"]
[null,"12:00:00",null,null,null,null,"12:00:00",null,null,null,null,"12:00:00",null,null,null,null,"12:00:00",null,null,null,null,"12:00:00"]
[null,"13:00:00",null,null,null,null,"13:00:00",null,null,null,null,"13:00:00",null,null,null,null,"13:00:00",null,null,null,null,"13:00:00"]
[null,"14:00:00",null,null,null,null,"14:00:00",null,null,null,null,"14:00:00",null,null,null,null,"14:00:00",null,null,null,null,"14:00:00",null,null,null,null,{"$f":"AA6+1","v":"2020-01-12"}]
[null,"15:00:00",null,null,null,null,"15:00:00",null,null,null,null,"15:00:00",null,null,null,null,"15:00:00",null,null,null,null,"15:00:00"]
[null,"16:00:00",null,null,null,null,"16:00:00",null,null,null,null,"16:00:00",null,null,null,null,"16:00:00",null,null,null,null,"16:00:00"]
[null,"17:00:00",null,null,null,null,"17:00:00",null,null,null,null,"17:00:00",null,null,null,null,"17:00:00",null,null,null,null,"17:00:00"]
[null,"18:00:00",null,null,null,null,"18:00:00",null,null,null,null,"18:00:00",null,null,null,null,"18:00:00",null,null,null,null,"18:00:00"]
[null,"19:00:00",null,null,null,null,"19:00:00",null,null,null,null,"19:00:00",null,null,null,null,"19:00:00",null,null,null,null,"19:00:00"]
[null,"20:00:00",null,null,null,null,"20:00:00",null,null,null,null,"20:00:00",null,null,null,null,"20:00:00",null,null,null,null,"20:00:00"]
[]
[null,"AUFGABEN",null,null,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,null,"ExcelNova.org",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ExcelNova.org"]
[]
[null,{"$f":"\"WÖCHENTLICHES Q\"&Admin!$C$8&\" PLANEN\"","v":"WÖCHENTLICHES Q1 PLANEN"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"WÖCHENTLICHES Q\"&Admin!$C$8&\" PLANEN\"","v":"WÖCHENTLICHES Q1 PLANEN"}]

{"sheet":"Admin","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,"Auswahl"]
[null,null,null,null,null,{"$f":"TODAY()-(WEEKDAY(TODAY(),2)-1)","v":"2019-11-04"},0]
[null,null,null,null,null,{"$f":"F3+7","v":"2019-11-11"},1]
[null,"StartDatum",{"$f":"Planer!AK2","v":"2020-01-06"},null,null,{"$f":"F4+7","v":"2019-11-18"},2]
[null,"EndDatum",{"$f":"C5+6","v":"2020-01-12"},null,null,"2019-11-25",3]
[null,"Jahr",{"$f":"YEAR(C5)","v":2020},null,null,"2019-12-02",4]
[null,"Quartal",{"$f":"ROUNDUP(MONTH(StartDatum)/3,0)","v":1},null,null,"2019-12-09",5]
[null,"Monat",{"$f":"MONTH(C5)","v":1},null,null,"2019-12-16",6]
[null,"Tag",{"$f":"DAY(StartDatum)","v":6},null,null,"2019-12-23",7]
[null,"KalenderWoche",{"$f":"WEEKNUM(C5,2)","v":2},null,null,"2019-12-30",8]
[null,"Wochentag",{"$f":"WEEKDAY(StartDatum,2)","v":1},null,null,"2020-01-06",9]
[null,"Monatsanfang",{"$f":"EOMONTH(StartDatum,-1)+1","v":"2020-01-01"}]
[null,"Monatsende",{"$f":"EOMONTH(StartDatum,0)","v":"2020-01-31"}]
[]
[]
[null,"Wochentage"]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]

{"sheet":"MiniaturKalender","index":2,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
[null,null,null,null,{"$f":"StartDatum","v":"2020-01-06"},null,null,null,null,null,null,null,null,{"$f":"OFFSET(N4,VLOOKUP(StartDatum,Admin!$F$3:$G$12,2,0),0)","v":"Marie von Ebner-Eschenbach"},{"$f":"OFFSET(O4,VLOOKUP(StartDatum,Admin!$F$3:$G$12,2,0),0)","v":"Wir müssen immer lernen, zuletzt auch noch sterben lernen."}]
[null,"M","D","M","D","F","S","S"]
[null,{"$f":"IF(WEEKDAY(Monatsanfang,2)=COLUMN(A$1),Monatsanfang,IF(A3=\"\",\"\",A3+1))","v":""},"","2020-01-01","2020-01-02","2020-01-03","2020-01-04","2020-01-05",null,null,null,null,null,"title4","description5"]
[null,{"$f":"H3+1","v":"2020-01-06"},{"$f":"B4+1","v":"2020-01-07"},{"$f":"C4+1","v":"2020-01-08"},"2020-01-09","2020-01-10","2020-01-11","2020-01-12",null,null,null,null,null,"Aldous Huxley","Nichts bewahrt uns so gründlich vor Illusionen wie ein Blick in den Spiegel."]
[null,{"$f":"H4+1","v":"2020-01-13"},{"$f":"B5+1","v":"2020-01-14"},"2020-01-15","2020-01-16","2020-01-17","2020-01-18","2020-01-19",null,null,null,null,null,"Kurt Tucholsky","Der eigene Hund macht keinen Lärm, er bellt nur."]
[null,{"$f":"H5+1","v":"2020-01-20"},{"$f":"B6+1","v":"2020-01-21"},"2020-01-22","2020-01-23","2020-01-24","2020-01-25","2020-01-26",null,null,null,null,null,"George Washington","Wahre Freundschaft: eine sehr langsam wachsende Pflanze."]
[null,{"$f":"IFERROR(IF(MONTH(H6+1)=MONTH(StartDatum),H6+1,\"\"),\"\")","v":"2020-01-27"},{"$f":"IFERROR(IF(MONTH(B7+1)=MONTH(StartDatum),B7+1,\"\"),\"\")","v":"2020-01-28"},{"$f":"IFERROR(IF(MONTH(C7+1)=MONTH(StartDatum),C7+1,\"\"),\"\")","v":"2020-01-29"},{"$f":"IFERROR(IF(MONTH(D7+1)=MONTH(StartDatum),D7+1,\"\"),\"\")","v":"2020-01-30"},{"$f":"IFERROR(IF(MONTH(E7+1)=MONTH(StartDatum),E7+1,\"\"),\"\")","v":"2020-01-31"},{"$f":"IFERROR(IF(MONTH(F7+1)=MONTH(StartDatum),F7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(G7+1)=MONTH(StartDatum),G7+1,\"\"),\"\")","v":""},null,null,null,null,null,"Francis Bacon","Frauen sind die Geliebten der Männer in der Jugend, die Gefährtinnen auf der Höhe des Lebens, die Pflegerinnen im Alter."]
[null,{"$f":"IFERROR(IF(MONTH(H7+1)=MONTH(StartDatum),H7+1,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(B8+1)=MONTH(StartDatum),B8+1,\"\"),\"\")","v":""},"","","","","",null,null,null,null,null,"Dieter Hildebrandt","Die Öffentlich-Rechtlichen machen sich in jede Hose, die man ihnen hinhält, und die Privaten senden das, was darin ist."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oscar Wilde","Der Mensch ist vielerlei. Aber vernünftig ist er nicht."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"John Wayne","Mut ist, wenn man Todesangst hat, aber sich trotzdem in den Sattel schwingt."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Albert Einstein","Ich bin nicht sicher, mit welchen Waffen der dritte Weltkrieg ausgetragen wird, aber im vierten Weltkrieg werden sie mit Stöcken und Steinen kämpfen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ambrose Bierce","Bewunderung ist die höfliche Beachtung des anderen Menschen, der Ähnlichkeit mit dir hat."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Marie von Ebner-Eschenbach","Wir müssen immer lernen, zuletzt auch noch sterben lernen."]