{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Anleitung","Einstellungen","Monate","Feiertage","Monat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Anleitung","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Urlaubsplaner"]
[]
["1. Tragen Sie hier (Blatt Einstellungen) das Kalenderjahr ein."]
["2. Ergänzen Sie ggf. die Beschäftigtenliste im Blatt \"Monat\" um neue Kolleginnen und Kollegen."]
["3. Im Tabellenblatt \"Feiertage\" können weitere Feiertage gepflegt werden."]
["4. Starten Sie das Makro im Blatt Einstellungen durch die Schaltfläche \"Kalenderblätter anlegen\""]
[{"$f":"\"5. Das Blatt Monat wird ausgeblendet und die Tabelle kann als Urlaubsplaner_\"&Geschäftsjahr&\".XLS gespeichert werden.\"","v":"5. Das Blatt Monat wird ausgeblendet und die Tabelle kann als Urlaubsplaner_2020.XLS gespeichert werden."}]
[]
["ACHTUNG:"]
["Bitte nicht als \"Vorlage_Urlaubsplaner.xlsm\" speichern!"]
[]
[]
["Eine Ausführliche Anleitung ist auf der Seite www.andreas-unkelbach.de zu finden."]
[]
["http://www.andreas-unkelbach.de/blog/?go=show&id=495"]

{"sheet":"Einstellungen","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Urlaubsplaner",2020,"Jahr"]
[]
[]
["Sofern die Liste unter \"Monat\" vollständig gepflegt ist, können die Kalenderblätter angelegt werden."]
[]
[]
[]
[{"$f":"\"Das Blatt Monat wird ausgeblendet und die Tabelle kann als Urlaubsplaner_\"&Geschäftsjahr&\".XLS gespeichert werden.\"","v":"Das Blatt Monat wird ausgeblendet und die Tabelle kann als Urlaubsplaner_2020.XLS gespeichert werden."}]
[]
["ACHTUNG:"]
["Bitte nicht als \"Vorlage_Urlaubsplaner.xlsm\" speichern!"]

{"sheet":"Monate","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Monat","Anzahl Tage","Tage_Monat"]
["Januar",31,1]
["Februar",{"$f":"IF((MOD(Geschäftsjahr,4)=0)-(MOD(Geschäftsjahr,100)=0)+(MOD(Geschäftsjahr,400)=0)=0,28,29)","v":29},2,{"$f":"MOD(Geschäftsjahr,4)=0","v":true}]
["März",31,3]
["April",30,4]
["Mai",31,5]
["Juni",30,6]
["Juli",31,7]
["August",31,8]
["September",30,9]
["Oktober",31,10]
["November",30,11]
["Dezember",31,12]

{"sheet":"Feiertage","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Datum","Feiertag","Relev","Feiertage_Hessen"]
[{"$f":"VierteAdvent-35","v":"2020-11-15"},"Volkstrauertag ",null,null,null,"Sofern ein Datum als Feiertag markiert werden soll ist in der Spalte C (Relev) eine 2 einzutragen"]
[{"$f":"VierteAdvent-32","v":"2020-11-18"},"Buss- u. Bettag "]
[{"$f":"VierteAdvent-28","v":"2020-11-22"},"Totensonntag/Ewigkeitssonntag "]
[{"$f":"VierteAdvent-21","v":"2020-11-29"},"1. Advent "]
[{"$f":"VierteAdvent-14","v":"2020-12-06"},"2. Advent "]
[{"$f":"VierteAdvent-7","v":"2020-12-13"},"3. Advent "]
[{"$f":"Weihnachten-WEEKDAY(Weihnachten,2)","v":"2020-12-20"},"4. Advent"]
[{"$f":"DATE(Geschäftsjahr,12,24)","v":"2020-12-24"},"Heiligabend"]
[{"$f":"DATE(Geschäftsjahr,12,25)","v":"2020-12-25"},"1. Weihnachtstag",2]
[{"$f":"DATE(Geschäftsjahr,12,26)","v":"2020-12-26"},"2. Weihnachtstag",2]
[{"$f":"DATE(Geschäftsjahr,12,31)","v":"2020-12-31"},"Silvester",null,null,null,"Geschenkideen für Feiertage?"]
[{"$f":"Ostersonntag-52","v":"2020-02-20"},"Altweiber"]
[{"$f":"Ostersonntag-48","v":"2020-02-24"},"Rosenmontag",null,null,null,"https://www.unkelbach.art/"]
[{"$f":"Ostersonntag-2","v":"2020-04-10"},"Karfreitag",2]
[{"$f":"7*ROUND((4&-Geschäftsjahr)/7+MOD(19*MOD(Geschäftsjahr,19)-7,30)*0.14,)-6","v":"2020-04-12"},"Ostersonntag"]
[{"$f":"Ostersonntag+1","v":"2020-04-13"},"Ostermontag",2]
[{"$f":"Ostersonntag+39","v":"2020-05-21"},"Himmelfahrt",2]
[{"$f":"Ostersonntag+49","v":"2020-05-31"},"Pfingstsonntag"]
[{"$f":"Ostersonntag+50","v":"2020-06-01"},"Pfingstmontag",2]
[{"$f":"Ostersonntag+60","v":"2020-06-11"},"Fronleichnam",2]
[{"$f":"DATE(Geschäftsjahr,5,1)","v":"2020-05-01"},"Tag der Arbeit",2]
[{"$f":"DATE(Geschäftsjahr,7,13)","v":"2020-07-13"},"Andreas Unkelbach Geburtstag"]
[{"$f":"DATE(Geschäftsjahr,10,3)","v":"2020-10-03"},"Tag der deutschen Einheit",2]
[{"$f":"DATE(Geschäftsjahr,12,6)","v":"2020-12-06"},"Nikolaus"]
[{"$f":"DATE(Geschäftsjahr,1,1)","v":"2020-01-01"},"Neujahrstag",2]

{"sheet":"Monat","index":4,"n_rows":20,"n_cols":37,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,0,16,28],[8,30,12,30],[8,31,12,31],[8,24,12,24],[8,25,12,25],[8,26,12,26],[8,27,12,27],[8,28,12,28],[8,29,12,29],[8,23,12,23],[8,12,12,12],[8,13,12,13],[8,14,12,14],[8,15,12,15],[8,16,12,16],[8,17,12,17],[8,18,12,18],[8,19,12,19],[8,20,12,20],[8,21,12,21],[8,22,12,22],[8,11,12,11],[8,0,13,0],[8,1,12,1],[8,2,12,2],[8,3,12,3],[8,4,12,4],[8,5,12,5],[8,6,12,6],[8,7,12,7],[8,8,12,8],[8,9,12,9],[8,10,12,10]]}
[{"$f":"Geschäftsjahr","v":2020}]
["Tage im Monat",{"$f":"VLOOKUP(A8,Tage_Monat,2,FALSE)","v":29}]
["Datum",{"$f":"IF(B14>0,DATE(Geschäftsjahr,IF(ISNA(VLOOKUP($A$8,Tage_Monat,3,FALSE)),0,VLOOKUP($A$8,Tage_Monat,3,FALSE)),B14),\"\")","v":"2020-02-01"},"2020-02-02","2020-02-03","2020-02-04","2020-02-05","2020-02-06","2020-02-07","2020-02-08","2020-02-09","2020-02-10","2020-02-11","2020-02-12","2020-02-13","2020-02-14","2020-02-15","2020-02-16","2020-02-17","2020-02-18","2020-02-19","2020-02-20","2020-02-21","2020-02-22","2020-02-23","2020-02-24","2020-02-25","2020-02-26","2020-02-27","2020-02-28",{"$f":"IF(B2>28,IF(AD14>0,DATE(Geschäftsjahr,IF(ISNA(VLOOKUP($A$8,Tage_Monat,3,FALSE)),0,VLOOKUP($A$8,Tage_Monat,3,FALSE)),AD14),\"\"),\"\")","v":"2020-02-29"},{"$f":"IF(B2>29,IF(AE14>0,DATE(Geschäftsjahr,IF(ISNA(VLOOKUP($A$8,Tage_Monat,3,FALSE)),0,VLOOKUP($A$8,Tage_Monat,3,FALSE)),AE14),\"\"),\"\")","v":""},{"$f":"IF(B2>30,IF(AF14>0,DATE(Geschäftsjahr,IF(ISNA(VLOOKUP($A$8,Tage_Monat,3,FALSE)),0,VLOOKUP($A$8,Tage_Monat,3,FALSE)),AF14),\"\"),\"\")","v":""}]
["Feiertag",{"$f":"IF(ISNA(VLOOKUP(B3,Feiertage_Hessen,3,FALSE)),0,VLOOKUP(B3,Feiertage_Hessen,3,FALSE))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Bezeichnung Feiertag",{"$f":"IF(ISNA(VLOOKUP(B3,Feiertage_Hessen,2,FALSE)),\"\",VLOOKUP(B3,Feiertage_Hessen,2,FALSE))","v":""},"","","","","","","","","","","","","","","","","","","Altweiber","","","","Rosenmontag","","","","","","",""]
["Wochenende",{"$f":"IF(B3=\"\",0,IF(WEEKDAY(B3,2)>5,1,0))","v":1},{"$f":"IF(C3=\"\",0,IF(WEEKDAY(C3,2)>5,1,0))","v":1},0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0]
["Hilfstabelle",{"$f":"B4+B6","v":1},{"$f":"C4+C6","v":1},0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0]
["Februar"]
["Name",{"$f":"IF(B3=\"\",\"\",IF(B5=\"\",TEXT(B3,\"TTTT\"),B5))","v":"Samstag"},{"$f":"IF(C3=\"\",\"\",IF(C5=\"\",TEXT(C3,\"TTTT\"),C5))","v":"Sonntag"},"Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag","Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag","Montag","Dienstag","Mittwoch","Altweiber","Freitag","Samstag","Sonntag","Rosenmontag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","","",null,"FB","Fortbildung","FA","Freizeitausgleich"]
[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,null,null,"GT","Gleittag",null,"Feiertage"]
[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,null,null,"JU","Jahresurlaub"]
[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,null,null,"KU","Kur"]
[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,null,null,"SU","Sonderurlaub"]
[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,{"$f":"IF(B2>28,29,\"\")","v":29},{"$f":"IF(B2>29,30,\"\")","v":""},{"$f":"IF(B2>30,31,\"\")","v":""},null,"ZA","Zeitausgleich"]
["Unkelbach, A."]
["Unkelbach, C."]
["Abteilung 1"]
["andreas-unkelbach.de"]
["htmling.net"]
["kaestnerfuerkinder.net"]