{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Umgangsregelung","Schulferien"],"not_rendered":{"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Umgangsregelung","index":0,"n_rows":72,"n_cols":43,"rows_kept":72,"merged":[[0,0,0,6],[0,7,0,12],[0,13,0,14],[0,15,0,18],[0,19,6,19],[0,20,6,20],[0,21,0,23],[0,24,0,25],[0,26,0,27],[0,28,6,28],[0,33,0,38],[1,0,1,6],[1,7,1,12],[1,13,1,14],[1,15,1,18],[1,21,1,23],[1,24,1,25],[1,26,1,27],[1,33,1,38],[2,0,2,6],[2,7,2,12],[2,13,2,14],[2,15,2,18],[2,21,2,23],[2,24,2,25],[2,26,2,27],[2,33,2,38],[3,0,4,6],[3,7,3,12],[3,13,3,14],[3,15,3,18],[3,21,3,23],[3,24,3,25],[3,26,3,27],[3,33,3,38],[4,7,4,12],[4,13,4,14],[4,15,4,18],[4,21,4,23],[4,24,4,25],[4,26,4,27],[4,33,4,38],[5,3,5,5],[5,7,5,12],[5,13,5,14],[5,15,5,18],[5,24,5,25],[5,26,5,27],[5,33,5,37],[6,3,6,5],[6,7,6,12],[6,13,6,14],[6,15,6,18],[6,21,6,23],[6,24,6,25],[6,26,6,27],[6,33,6,38],[7,0,7,2],[7,3,7,5],[7,6,7,8],[7,9,7,11],[7,12,7,14],[7,15,7,17],[7,18,7,20],[7,21,7,23],[7,24,7,26],[7,27,7,29],[7,30,7,32],[7,33,7,35],[7,37,7,38],[31,37,38,38],[39,32,39,35],[40,9,40,10],[41,0,41,38],[42,0,42,38],[43,0,43,38],[44,0,44,38],[45,0,45,38],[46,0,46,38],[47,0,47,38],[48,0,48,38],[49,0,49,38],[50,0,50,38],[51,0,51,38]]}
[{"$nulls":7},"Name des Kindes",{"$nulls":7},"Geburtstag",{"$nulls":4},"Ferien*","Weihn.Vorjahr",null,null,{"$f":"DATE(Jahr,1,1)","v":"2016-01-01"},null,{"$f":"IF(VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:O25,Schulferien!A30:O45),15)=0,\"\",VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:O25,Schulferien!A30:O45),15))","v":"2016-01-06"},null,{"$f":"VLOOKUP(AQ2,Schulferien!$A$10:$B$25,2)","v":"NRW"},{"$nulls":4},"… Rechtsanwalt …"]
[{"$nulls":13},"geb.:",{"$nulls":7},"Winterferien",null,null,{"$f":"IF(VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),3)=0,\"\",VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),3))","v":""},null,{"$f":"IF(VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),4)=0,\"\",VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),4))","v":""},{"$nulls":6},"bitte Kanzleianschrift eintragen",{"$nulls":8},10]
[{"$nulls":13},"geb.:",{"$nulls":7},"Osterferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),5)","v":"2016-03-21"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),6)","v":"2016-04-02"},{"$nulls":9},"1905-06-28",null,null,"Ostersonntag",{"$f":"CHOOSE(Jahr-2005,\"16.4.06\",\"8.4.07\",\"23.3.08\",\"12.4.09\",\"4.4.10\",\"24.4.11\",\"8.4.12\",\"31.3.13\",\"20.4.14\",\"5.4.2015\",\"27.3.2016\",\"16.4.2017\")","v":"27.3.2016"}]
[{"$f":"IF(AN7=1,+Schulferien!B8,IF(AN7=2,+Schulferien!B28,\"\"))","v":2016},{"$nulls":12},"geb.:",{"$nulls":7},"Pfingstferien",null,null,{"$f":"IF(VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),7)=0,\"\",VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),7))","v":"2016-05-17"},null,{"$f":"IF(VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),8)=0,\"\",VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),8))","v":"2016-05-17"},{"$nulls":9},"1905-06-29"]
[{"$nulls":13},"geb.:",{"$nulls":7},"Sommerferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),9)","v":"2016-07-11"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),10)","v":"2016-08-23"}]
[{"$nulls":3},{"$f":"+Schulferien!B8","v":2017},{"$nulls":9},"geb.:",{"$nulls":7},"Herbstferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),11)","v":"2016-10-10"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),12)","v":"2016-10-21"},{"$nulls":12},1]
[{"$nulls":3},{"$f":"+Schulferien!B28","v":2016},{"$nulls":9},"geb.:",{"$nulls":7},"Weihnachtsf.",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),13)","v":"2016-12-23"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),14)","v":"2017-01-06"},{"$nulls":12},2]
[{"$f":"CHOOSE(MONTH(A9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Januar"},null,null,{"$f":"CHOOSE(MONTH(D9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Februar"},null,null,{"$f":"CHOOSE(MONTH(G9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"März"},null,null,{"$f":"CHOOSE(MONTH(J9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"April"},null,null,{"$f":"CHOOSE(MONTH(M9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Mai"},null,null,{"$f":"CHOOSE(MONTH(P9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juni"},null,null,{"$f":"CHOOSE(MONTH(S9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Juli"},null,null,{"$f":"CHOOSE(MONTH(V9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"August"},null,null,{"$f":"CHOOSE(MONTH(Y9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"September"},null,null,{"$f":"CHOOSE(MONTH(AB9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Oktober"},null,null,{"$f":"CHOOSE(MONTH(AE9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"November"},null,null,{"$f":"CHOOSE(MONTH(AH9),\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Dezember"},{"$nulls":3},"Feiertage"]
[{"$f":"DATE(Jahr,1,1)","v":"2016-01-01"},{"$f":"IF(A9=\"\",\"\",CHOOSE(WEEKDAY(A9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(A9),MONTH(A9)+1,DAY(A9))","v":"2016-02-01"},{"$f":"IF(D9=\"\",\"\",CHOOSE(WEEKDAY(D9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mo"},null,{"$f":"DATE(YEAR(D9),MONTH(D9)+1,DAY(D9))","v":"2016-03-01"},{"$f":"IF(G9=\"\",\"\",CHOOSE(WEEKDAY(G9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,{"$f":"DATE(YEAR(G9),MONTH(G9)+1,DAY(G9))","v":"2016-04-01"},{"$f":"IF(J9=\"\",\"\",CHOOSE(WEEKDAY(J9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(J9),MONTH(J9)+1,DAY(J9))","v":"2016-05-01"},{"$f":"IF(M9=\"\",\"\",CHOOSE(WEEKDAY(M9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,{"$f":"DATE(YEAR(M9),MONTH(M9)+1,DAY(M9))","v":"2016-06-01"},{"$f":"IF(P9=\"\",\"\",CHOOSE(WEEKDAY(P9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mi"},null,{"$f":"DATE(YEAR(P9),MONTH(P9)+1,DAY(P9))","v":"2016-07-01"},{"$f":"IF(S9=\"\",\"\",CHOOSE(WEEKDAY(S9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(S9),MONTH(S9)+1,DAY(S9))","v":"2016-08-01"},{"$f":"IF(V9=\"\",\"\",CHOOSE(WEEKDAY(V9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mo"},null,{"$f":"DATE(YEAR(V9),MONTH(V9)+1,DAY(V9))","v":"2016-09-01"},{"$f":"IF(Y9=\"\",\"\",CHOOSE(WEEKDAY(Y9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,{"$f":"DATE(YEAR(Y9),MONTH(Y9)+1,DAY(Y9))","v":"2016-10-01"},{"$f":"IF(AB9=\"\",\"\",CHOOSE(WEEKDAY(AB9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Sa"},null,{"$f":"DATE(YEAR(AB9),MONTH(AB9)+1,DAY(AB9))","v":"2016-11-01"},{"$f":"IF(AE9=\"\",\"\",CHOOSE(WEEKDAY(AE9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,{"$f":"DATE(YEAR(AE9),MONTH(AE9)+1,DAY(AE9))","v":"2016-12-01"},{"$f":"IF(AH9=\"\",\"\",CHOOSE(WEEKDAY(AH9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,null,"Neujahr",{"$f":"DATE(Jahr,1,1)","v":"2016-01-01"}]
[{"$f":"IF(MONTH(DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))>MONTH(A9),\"\",DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))","v":"2016-01-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))>MONTH(D9),\"\",DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))","v":"2016-02-02"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))>MONTH(G9),\"\",DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))","v":"2016-03-02"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))>MONTH(J9),\"\",DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))","v":"2016-04-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))>MONTH(M9),\"\",DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))","v":"2016-05-02"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))>MONTH(P9),\"\",DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))","v":"2016-06-02"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))>MONTH(S9),\"\",DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))","v":"2016-07-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))>MONTH(V9),\"\",DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))","v":"2016-08-02"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))>MONTH(Y9),\"\",DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))","v":"2016-09-02"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))>MONTH(AB9),\"\",DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))","v":"2016-10-02"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))>MONTH(AE9),\"\",DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))","v":"2016-11-02"},"Mi",null,{"$f":"IF(AH9=\"\",\"\",IF(MONTH(+AH9+1)=MONTH(AH9),AH9+1,\"\"))","v":"2016-12-02"},"Fr",null,null,"Rosenmontag"]
[{"$f":"IF(MONTH(DATE(YEAR(A10),MONTH(A10),DAY(A10)+1))>MONTH(A10),\"\",DATE(YEAR(A10),MONTH(A10),DAY(A10)+1))","v":"2016-01-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))>MONTH(D10),\"\",DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))","v":"2016-02-03"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))>MONTH(G10),\"\",DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))","v":"2016-03-03"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))>MONTH(J10),\"\",DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))","v":"2016-04-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))>MONTH(M10),\"\",DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))","v":"2016-05-03"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))>MONTH(P10),\"\",DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))","v":"2016-06-03"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))>MONTH(S10),\"\",DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))","v":"2016-07-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))>MONTH(V10),\"\",DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))","v":"2016-08-03"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))>MONTH(Y10),\"\",DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))","v":"2016-09-03"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))>MONTH(AB10),\"\",DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))","v":"2016-10-03"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))>MONTH(AE10),\"\",DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))","v":"2016-11-03"},"Do",null,"2016-12-03","Sa",null,null,"Karfreitag",{"$f":"+AM12-2","v":"2016-03-25"}]
["2016-01-04","Mo",null,"2016-02-04","Do",null,"2016-03-04","Fr",null,"2016-04-04","Mo",null,"2016-05-04","Mi",null,"2016-06-04","Sa",null,"2016-07-04","Mo",null,"2016-08-04","Do",null,"2016-09-04","So",null,"2016-10-04","Di",null,"2016-11-04","Fr",null,"2016-12-04","So",null,null,"Ostersonntag",{"$f":"DATEVALUE(AO3)","v":"2016-03-27"}]
["2016-01-05","Di",null,"2016-02-05","Fr",null,"2016-03-05","Sa",null,"2016-04-05","Di",null,"2016-05-05","Do",null,"2016-06-05","So",null,"2016-07-05","Di",null,"2016-08-05","Fr",null,"2016-09-05","Mo",null,"2016-10-05","Mi",null,"2016-11-05","Sa",null,"2016-12-05","Mo",null,null,"Ostermontag",{"$f":"+AM12+1","v":"2016-03-28"}]
["2016-01-06","Mi",null,"2016-02-06","Sa",null,"2016-03-06","So",null,"2016-04-06","Mi",null,"2016-05-06","Fr",null,"2016-06-06","Mo",null,"2016-07-06","Mi",null,"2016-08-06","Sa",null,"2016-09-06","Di",null,"2016-10-06","Do",null,"2016-11-06","So",null,"2016-12-06","Di",null,null,"Maifeiertag",{"$f":"DATE(Jahr,5,1)","v":"2016-05-01"}]
["2016-01-07","Do",null,"2016-02-07","So",null,"2016-03-07","Mo",null,"2016-04-07","Do",null,"2016-05-07","Sa",null,"2016-06-07","Di",null,"2016-07-07","Do",null,"2016-08-07","So",null,"2016-09-07","Mi",null,"2016-10-07","Fr",null,"2016-11-07","Mo",null,"2016-12-07","Mi",null,null,"ChristiHiFa",{"$f":"+AM12+39","v":"2016-05-05"}]
["2016-01-08","Fr",null,"2016-02-08","Mo",null,"2016-03-08","Di",null,"2016-04-08","Fr",null,"2016-05-08","So",null,"2016-06-08","Mi",null,"2016-07-08","Fr",null,"2016-08-08","Mo",null,"2016-09-08","Do",null,"2016-10-08","Sa",null,"2016-11-08","Di",null,"2016-12-08","Do",null,null,"Pfingstso",{"$f":"+AM12+49","v":"2016-05-15"}]
["2016-01-09","Sa",null,"2016-02-09","Di",null,"2016-03-09","Mi",null,"2016-04-09","Sa",null,"2016-05-09","Mo",null,"2016-06-09","Do",null,"2016-07-09","Sa",null,"2016-08-09","Di",null,"2016-09-09","Fr",null,"2016-10-09","So",null,"2016-11-09","Mi",null,"2016-12-09","Fr",null,null,"PfingstMo",{"$f":"+AM16+1","v":"2016-05-16"}]
["2016-01-10","So",null,"2016-02-10","Mi",null,"2016-03-10","Do",null,"2016-04-10","So",null,"2016-05-10","Di",null,"2016-06-10","Fr",null,"2016-07-10","So",null,"2016-08-10","Mi",null,"2016-09-10","Sa",null,"2016-10-10","Mo",null,"2016-11-10","Do",null,"2016-12-10","Sa",null,null,"Fronleichnam",{"$f":"+AM12+60","v":"2016-05-26"}]
["2016-01-11","Mo",null,"2016-02-11","Do",null,"2016-03-11","Fr",null,"2016-04-11","Mo",null,"2016-05-11","Mi",null,"2016-06-11","Sa",null,"2016-07-11","Mo",null,"2016-08-11","Do",null,"2016-09-11","So",null,"2016-10-11","Di",null,"2016-11-11","Fr",null,"2016-12-11","So",null,null,"Nationalfeiertag",{"$f":"DATE(Jahr,10,3)","v":"2016-10-03"}]
["2016-01-12","Di",null,"2016-02-12","Fr",null,"2016-03-12","Sa",null,"2016-04-12","Di",null,"2016-05-12","Do",null,"2016-06-12","So",null,"2016-07-12","Di",null,"2016-08-12","Fr",null,"2016-09-12","Mo",null,"2016-10-12","Mi",null,"2016-11-12","Sa",null,"2016-12-12","Mo",null,null,"1.Weihnachtstag",{"$f":"DATE(Jahr,12,25)","v":"2016-12-25"}]
["2016-01-13","Mi",null,"2016-02-13","Sa",null,"2016-03-13","So",null,"2016-04-13","Mi",null,"2016-05-13","Fr",null,"2016-06-13","Mo",null,"2016-07-13","Mi",null,"2016-08-13","Sa",null,"2016-09-13","Di",null,"2016-10-13","Do",null,"2016-11-13","So",null,"2016-12-13","Di",null,null,"2. Weihnachtstag",{"$f":"+AM20+1","v":"2016-12-26"}]
["2016-01-14","Do",null,"2016-02-14","So",null,"2016-03-14","Mo",null,"2016-04-14","Do",null,"2016-05-14","Sa",null,"2016-06-14","Di",null,"2016-07-14","Do",null,"2016-08-14","So",null,"2016-09-14","Mi",null,"2016-10-14","Fr",null,"2016-11-14","Mo",null,"2016-12-14","Mi"]
["2016-01-15","Fr",null,"2016-02-15","Mo",null,"2016-03-15","Di",null,"2016-04-15","Fr",null,"2016-05-15","So",null,"2016-06-15","Mi",null,"2016-07-15","Fr",null,"2016-08-15","Mo",null,"2016-09-15","Do",null,"2016-10-15","Sa",null,"2016-11-15","Di",null,"2016-12-15","Do"]
["2016-01-16","Sa",null,"2016-02-16","Di",null,"2016-03-16","Mi",null,"2016-04-16","Sa",null,"2016-05-16","Mo",null,"2016-06-16","Do",null,"2016-07-16","Sa",null,"2016-08-16","Di",null,"2016-09-16","Fr",null,"2016-10-16","So",null,"2016-11-16","Mi",null,"2016-12-16","Fr"]
["2016-01-17","So",null,"2016-02-17","Mi",null,"2016-03-17","Do",null,"2016-04-17","So",null,"2016-05-17","Di",null,"2016-06-17","Fr",null,"2016-07-17","So",null,"2016-08-17","Mi",null,"2016-09-17","Sa",null,"2016-10-17","Mo",null,"2016-11-17","Do",null,"2016-12-17","Sa"]
["2016-01-18","Mo",null,"2016-02-18","Do",null,"2016-03-18","Fr",null,"2016-04-18","Mo",null,"2016-05-18","Mi",null,"2016-06-18","Sa",null,"2016-07-18","Mo",null,"2016-08-18","Do",null,"2016-09-18","So",null,"2016-10-18","Di",null,"2016-11-18","Fr",null,"2016-12-18","So"]
["2016-01-19","Di",null,"2016-02-19","Fr",null,"2016-03-19","Sa",null,"2016-04-19","Di",null,"2016-05-19","Do",null,"2016-06-19","So",null,"2016-07-19","Di",null,"2016-08-19","Fr",null,"2016-09-19","Mo",null,"2016-10-19","Mi",null,"2016-11-19","Sa",null,"2016-12-19","Mo"]
["2016-01-20","Mi",null,"2016-02-20","Sa",null,"2016-03-20","So",null,"2016-04-20","Mi",null,"2016-05-20","Fr",null,"2016-06-20","Mo",null,"2016-07-20","Mi",null,"2016-08-20","Sa",null,"2016-09-20","Di",null,"2016-10-20","Do",null,"2016-11-20","So",null,"2016-12-20","Di"]
["2016-01-21","Do",null,"2016-02-21","So",null,"2016-03-21","Mo",null,"2016-04-21","Do",null,"2016-05-21","Sa",null,"2016-06-21","Di",null,"2016-07-21","Do",null,"2016-08-21","So",null,"2016-09-21","Mi",null,"2016-10-21","Fr",null,"2016-11-21","Mo",null,"2016-12-21","Mi"]
["2016-01-22","Fr",null,"2016-02-22","Mo",null,"2016-03-22","Di",null,"2016-04-22","Fr",null,"2016-05-22","So",null,"2016-06-22","Mi",null,"2016-07-22","Fr",null,"2016-08-22","Mo",null,"2016-09-22","Do",null,"2016-10-22","Sa",null,"2016-11-22","Di",null,"2016-12-22","Do"]
["2016-01-23","Sa",null,"2016-02-23","Di",null,"2016-03-23","Mi",null,"2016-04-23","Sa",null,"2016-05-23","Mo",null,"2016-06-23","Do",null,"2016-07-23","Sa",null,"2016-08-23","Di",null,"2016-09-23","Fr",null,"2016-10-23","So",null,"2016-11-23","Mi",null,"2016-12-23","Fr"]
["2016-01-24","So",null,"2016-02-24","Mi",null,"2016-03-24","Do",null,"2016-04-24","So",null,"2016-05-24","Di",null,"2016-06-24","Fr",null,"2016-07-24","So",null,"2016-08-24","Mi",null,"2016-09-24","Sa",null,"2016-10-24","Mo",null,"2016-11-24","Do",null,"2016-12-24","Sa",null,null,"In die weißen Felder können weitere Frei-, Feier- und Brückentage eingegeben werden. Diese Angaben werden im Kalender in der Tagesspalte knallrot angezeigt. In der Datumsspalte werden die Sondertage hellblau markiert. "]
["2016-01-25","Mo",null,"2016-02-25","Do",null,"2016-03-25","Fr",null,"2016-04-25","Mo",null,"2016-05-25","Mi",null,"2016-06-25","Sa",null,"2016-07-25","Mo",null,"2016-08-25","Do",null,"2016-09-25","So",null,"2016-10-25","Di",null,"2016-11-25","Fr",null,"2016-12-25","So"]
["2016-01-26","Di",null,"2016-02-26","Fr",null,"2016-03-26","Sa",null,"2016-04-26","Di",null,"2016-05-26","Do",null,"2016-06-26","So",null,"2016-07-26","Di",null,"2016-08-26","Fr",null,"2016-09-26","Mo",null,"2016-10-26","Mi",null,"2016-11-26","Sa",null,"2016-12-26","Mo"]
["2016-01-27","Mi",null,"2016-02-27","Sa",null,"2016-03-27","So",null,"2016-04-27","Mi",null,"2016-05-27","Fr",null,"2016-06-27","Mo",null,"2016-07-27","Mi",null,"2016-08-27","Sa",null,"2016-09-27","Di",null,"2016-10-27","Do",null,"2016-11-27","So",null,"2016-12-27","Di"]
["2016-01-28","Do",null,"2016-02-28","So",null,"2016-03-28","Mo",null,"2016-04-28","Do",null,"2016-05-28","Sa",null,"2016-06-28","Di",null,"2016-07-28","Do",null,"2016-08-28","So",null,"2016-09-28","Mi",null,"2016-10-28","Fr",null,"2016-11-28","Mo",null,"2016-12-28","Mi"]
["2016-01-29","Fr",null,"2016-02-29","Mo",null,"2016-03-29","Di",null,"2016-04-29","Fr",null,"2016-05-29","So",null,"2016-06-29","Mi",null,"2016-07-29","Fr",null,"2016-08-29","Mo",null,"2016-09-29","Do",null,"2016-10-29","Sa",null,"2016-11-29","Di",null,{"$f":"IF(AH36=\"\",\"\",IF(MONTH(+AH36+1)=MONTH(AH36),AH36+1,\"\"))","v":"2016-12-29"},"Do"]
["2016-01-30","Sa",null,null,"",null,"2016-03-30","Mi",null,"2016-04-30","Sa",null,"2016-05-30","Mo",null,"2016-06-30","Do",null,"2016-07-30","Sa",null,"2016-08-30","Di",null,"2016-09-30","Fr",null,"2016-10-30","So",null,"2016-11-30","Mi",null,{"$f":"IF(AH37=\"\",\"\",IF(MONTH(+AH37+1)=MONTH(AH37),AH37+1,\"\"))","v":"2016-12-30"},"Fr"]
["2016-01-31",{"$f":"IF(A39=\"\",\"\",CHOOSE(WEEKDAY(A39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,null,{"$f":"IF(D39=\"\",\"\",CHOOSE(WEEKDAY(D39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2016-03-31",{"$f":"IF(G39=\"\",\"\",CHOOSE(WEEKDAY(G39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,"",{"$f":"IF(J39=\"\",\"\",CHOOSE(WEEKDAY(J39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2016-05-31",{"$f":"IF(M39=\"\",\"\",CHOOSE(WEEKDAY(M39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,"",{"$f":"IF(P39=\"\",\"\",CHOOSE(WEEKDAY(P39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2016-07-31","So",null,"2016-08-31","Mi",null,"","",null,"2016-10-31","Mo",null,"","",null,{"$f":"IF(AH38=\"\",\"\",IF(MONTH(+AH38+1)=MONTH(AH38),AH38+1,\"\"))","v":"2016-12-31"},"Sa"]
[{"$nulls":11},{"$f":"COUNTA(F9:F39,I9:I39,C9:C39,L9:L39,O9:O39,R9:R39,U9:U39,X9:X39,AA9:AA39,AD9:AD39,AG9:AG39,AJ9:AJ39)","v":0},{"$nulls":20},"*) keine Gewähr"]
["Erläuterungen:"]
["Nur die weißen Felder können vom Anwender ausgefüllt werden. Die weißen Kalenderfelder können auch formatiert werden, d.h. der Anwender kann sie z.B. mit einer anderen Hintergrundfarbe versehen,"]
["um z.B. einen von den Schulferien abweichenden Urlaubszeitraum zu markieren. Dazu sind alle Formatierungsfunktionen von Excel freigeschaltet. Der Kanzleiname oben rechts ist änderbar (vgl. unten)."]
["Wählen Sie danach das Bundesland und dann das Jahr aus. Der Kalender kann auch für die Jahre ab 2008 verwendet werden. Wechseln Sie dazu in das Register 'Schulferien'."]
["Die Ferienzeiten für die Sommer- und Herbsferien werden in den Farben rot und goldgelb markiert. Die Weihnachts-, Winter- und Pfingstferien und bundesweiten Feiertage werden blau angezeigt."]
["Tragen Sie in die weiße Kalenderspalte die Umgangstermine ein und markieren Sie diese mit einem 'U'. Groß- oder Kleinschreibung ist unerheblich. Die Umgangstage werden dadurch gelb unterlegt."]
["Achten Sie darauf, dass die Ferientermine richtig angegeben sind. Die bundeseinheitlichen Feiertage sind als Wochentage knallrot markiert. Brückentage und zus. Feiertage können in das weiße Raster eingegeben werden."]
["Zum Ausdrucken benutzen Sie das Querformat und tragen Sie gegebenenfalls unter der Menüoption <Datei> <Seite einrichten> die Option \"Anpassen auf eine Seite\" ein."]
["Den Kanzleieintrag in der oberen rechten Ecke des Kalenders können Sie löschen und durch Ihren eigenen Kanzleinamen ersetzen. Klicken Sie dazu in die entsprechenden Felder."]
["Beachten Sie bitte, dass die Feiertage und auch die Schulferien von den Anwendern zu prüfen sind, da nicht nur länderweite Varianzen, sondern auch regionale Unterschiede zu beachten sind."]
["Rosenmontag ist zwar (noch) nicht globaler Feiertag, wiewohl der Autor Karnevalsflüchter ist, wird dem Sitz des Verlages jedoch dadurch Reverenz erwiesen, dass Rosenmontag als Feiertag angegeben ist."]
{"$rows_empty":8}
[{"$f":"+AM9","v":"2016-01-01"}]
[{"$f":"+AM10","v":"00:00:00"}]
["2016-03-25"]
["2016-03-27"]
["2016-03-28"]
["2016-05-01"]
["2016-05-05"]
["2016-05-15"]
["2016-05-16"]
["2016-05-26"]
["2016-10-03"]
["2016-12-25"]
[{"$f":"+AM21","v":"2016-12-26"}]

{"sheet":"Schulferien","index":1,"n_rows":51,"n_cols":15,"rows_kept":51,"merged":[[5,0,6,14],[7,1,8,1],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,14],[27,1,28,1],[27,2,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,14],[46,9,46,10],[47,0,47,35],[48,0,48,35],[49,0,49,35],[50,0,50,35],[51,0,51,35],[52,0,52,35]]}
[]
[]
[]
[]
[]
["Ferienregelung und Anpassung des Umgangskalenders"]
[]
[null,2017,"Winter",null,"Ostern",null,"Pfingsten",null,"Sommer",null,"Herbst",null,"Weihnachten"]
[null,null,"von","bis","von","bis","von","bis","von","bis","von","bis","von","bis",{"$f":"\"Rest \"&TEXT(B8-1,\"####\")","v":"Rest 2016"}]
[1,"Baden-Württemberg",null,null,"2017-04-10","2017-04-21","2017-06-06","2017-06-16","2017-07-27","2017-09-09","2017-10-30","2017-11-03","2017-12-22","2018-01-05","2017-01-07"]
[{"$f":"+A10+1","v":2},"Bayern","2017-02-27","2017-03-03","2017-04-10","2017-04-22","2017-06-06","2017-06-16","2017-07-29","2017-09-11","2017-10-30","2017-11-03","2017-12-23","2018-01-05",{"$f":"+N31","v":"2017-01-05"}]
[{"$f":"+A11+1","v":3},"Berlin","2017-01-30","2017-02-04","2017-04-10","2017-04-18","2017-05-24","2017-06-06","2017-07-20","2017-09-01","2017-10-23","2017-11-04","2017-12-21","2018-01-02","2017-01-03"]
[4,"Brandenburg","2017-01-30","2017-02-04","2017-04-10","2017-04-22","2017-05-26","2017-05-26","2017-07-20","2017-09-01","2017-10-23","2017-11-04","2017-12-21","2018-01-02","2017-01-03"]
[5,"Bremen","2017-01-30","2017-01-31","2017-04-10","2017-04-22","2017-05-26","2017-05-26","2017-06-22","2017-08-02","2017-10-02","2017-10-14","2017-12-23","2018-01-06","2017-01-06"]
[6,"Hamburg","2017-01-30","2017-01-30","2017-03-06","2017-03-17","2017-05-22","2017-05-26","2017-07-20","2017-08-30","2017-10-16","2017-10-27","2017-12-22","2018-01-05","2017-01-06"]
[7,"Hessen",null,null,"2017-04-03","2017-04-15",null,null,"2017-07-03","2017-08-11","2017-10-09","2017-10-21","2017-12-24","2018-01-13","2017-01-07"]
[8,"Mecklenb.-Vorp.","2017-02-06","2017-02-18","2017-04-10","2017-04-19","2017-06-02","2017-06-06","2017-07-24","2017-09-02","2017-10-23","2017-10-30","2017-12-21","2018-01-03","2017-01-02"]
[9,"Niedersachsen","2017-01-30","2017-01-31","2017-04-20","2017-04-22","2017-05-26","2017-06-06","2017-06-22","2017-08-02","2017-10-02","2017-10-13","2017-12-22","2018-01-05","2017-01-06"]
[10,"NRW",null,null,"2017-04-10","2017-04-22","2017-06-06","2017-06-06","2017-07-17","2017-08-29","2017-10-23","2017-11-04","2017-12-27","2018-01-06","2017-01-06"]
[11,"Rheinland-Pfalz",null,null,"2017-04-10","2017-04-21",null,null,"2017-07-03","2017-08-11","2017-10-02","2017-10-13","2017-12-22","2018-01-09","2017-01-06"]
[12,"Saarland","2017-02-27","2017-03-04","2017-04-10","2017-04-22",null,null,"2017-07-03","2017-08-14","2017-10-02","2017-10-14","2017-12-21","2018-01-05","2016-12-31"]
[13,"Sachsen","2017-02-13","2017-02-24","2017-04-13","2017-04-22","2017-05-26","2017-05-26","2017-06-26","2017-08-04","2017-10-02","2017-10-14","2017-12-23","2018-01-02","2017-01-02"]
[14,"Sachsen-Anhalt","2017-02-04","2017-02-11","2017-04-10","2017-04-13","2017-05-26","2017-05-26","2017-06-26","2017-08-09","2017-10-02","2017-10-13","2017-12-21","2018-01-03","2017-01-02"]
[15,"Schleswig-Holstein",null,null,"2017-04-07","2017-04-21","2017-05-26","2017-05-26","2017-07-24","2017-09-02","2017-10-16","2017-10-27","2017-12-21","2018-01-06","2017-01-06"]
[16,"Thüringen","2017-02-06","2017-02-11","2017-04-10","2017-04-21","2017-05-26","2017-05-26","2017-06-26","2017-08-09","2017-10-02","2017-10-14","2017-12-22","2018-01-05","2016-12-31"]
[]
[]
[null,2016,"Winter",null,"Ostern",null,"Pfingsten",null,"Sommer",null,"Herbst",null,"Weihnachten"]
[null,null,"von","bis","von","bis","von","bis","von","bis","von","bis","von","bis",{"$f":"\"Rest \"&TEXT(B28-1,\"####\")","v":"Rest 2015"}]
[1,"Baden-Württemb.",null,null,"2016-03-29","2016-04-02","2016-05-17","2016-05-28","2016-07-28","2016-09-10","2016-11-02","2016-11-04","2016-12-23","2017-01-07","2016-01-09"]
[{"$f":"+A30+1","v":2},"Bayern","2016-02-08","2016-02-12","2016-03-21","2016-04-01","2016-05-17","2016-05-28","2016-07-30","2016-09-12","2016-10-31","2016-11-04","2016-12-24","2017-01-05","2016-01-05"]
[{"$f":"+A31+1","v":3},"Berlin","2016-01-30","2016-02-06","2016-03-21","2016-04-02","2016-05-17","2016-05-18","2016-07-21","2016-09-02","2016-10-17","2016-10-28","2016-12-23","2017-01-03","2016-01-02"]
[4,"Brandenburg","2016-02-01","2016-02-06","2016-03-23","2016-04-02","2016-05-06","2016-05-17","2016-07-21","2016-09-03","2016-10-17","2016-10-28","2016-12-23","2017-01-03","2016-01-02"]
[5,"Bremen","2016-01-28","2016-01-29","2016-03-18","2016-04-02","2016-05-17","2016-05-17","2016-06-23","2016-08-03","2016-10-04","2016-10-15","2016-12-21","2017-01-06","2016-01-06"]
[6,"Hamburg","2016-01-29","2016-01-29","2016-03-07","2016-03-18","2016-05-17","2016-05-20","2016-07-21","2016-08-31","2016-10-17","2016-10-28","2016-12-27","2017-01-06","2016-01-01"]
[7,"Hessen",null,null,"2016-03-29","2016-04-09",null,null,"2016-07-18","2016-08-26","2016-10-17","2016-10-29","2016-12-22","2017-01-07","2016-01-09"]
[8,"Mecklenb.-Vorp.","2016-02-01","2016-02-13","2016-03-21","2016-03-30","2016-05-14","2016-05-17","2016-07-25","2016-09-03","2016-10-24","2016-10-28","2016-12-22","2017-01-02","2016-01-02"]
[9,"Niedersachsen","2016-01-28","2016-01-29","2016-03-18","2016-04-02","2016-05-06","2016-05-17","2016-06-23","2016-08-03","2016-10-04","2016-10-15","2016-12-21","2017-01-06","2016-01-06"]
[10,"NRW",null,null,"2016-03-21","2016-04-02","2016-05-17","2016-05-17","2016-07-11","2016-08-23","2016-10-10","2016-10-21","2016-12-23","2017-01-06","2016-01-06"]
[11,"Rheinland-Pfalz",null,null,"2016-03-18","2016-04-01",null,null,"2016-07-18","2016-08-26","2016-10-10","2016-10-21","2016-12-22","2017-01-06","2016-01-08"]
[12,"Saarland","2016-02-08","2016-02-13","2016-03-29","2016-04-09",null,null,"2016-07-18","2016-08-26","2016-10-10","2016-10-22","2016-12-17","2016-12-31","2016-01-02"]
[13,"Sachsen","2016-02-08","2016-02-20","2016-03-25","2016-04-02","2016-05-06","2016-05-06","2016-06-27","2016-08-05","2016-10-03","2016-10-15","2016-12-23","2017-01-02","2016-01-02"]
[14,"Sachsen-Anhalt","2016-02-01","2016-02-10","2016-03-24","2016-03-24","2016-05-06","2016-05-14","2016-06-27","2016-08-10","2016-10-04","2016-10-15","2016-12-19","2017-01-02","2016-01-05"]
[15,"Schleswig-Holstein",null,null,"2016-03-24","2016-04-09","2016-05-06","2016-05-06","2016-07-28","2016-09-03","2016-10-17","2016-10-29","2016-12-23","2017-01-06","2016-01-06"]
[16,"Thüringen","2016-02-01","2016-02-06","2016-03-24","2016-04-02","2016-05-06","2016-05-06","2016-06-27","2016-08-10","2016-10-10","2016-10-22","2016-12-21","2016-12-31","2016-01-02"]
[{"$nulls":10},"©opyright Rechtsanwalt Jörn Hauß Duisburg 2006"]
["Erläuterungen:"]
["Nur die weißen Felder können vom Anwender ausgefüllt werden."]
["Wenn der Umgangskalender auf die Jahre ab 2008 umgestellt werden soll, reicht es aus, die roten Jahresangaben auf dieser Seite auf das gewünschte Jahr umzustellen."]
["Die Schulferientermine für die Jahre ab 2008 müssen vom Anwender selbst eingetragen werden. Dabei reicht es aus, wenn der Anwender nur die Ferientermine 'seines' Bundeslandes einträgt."]
["Die Schulferienangaben in den obigen Aufstellungen sollten vom Anwender geprüft werden, weil teilweise regionale Abweichungen bestehen (z.B. für die Nordseeinseln)."]