{"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],[39,32,39,35],[40,9,40,10],[41,0,41,35],[42,0,42,35],[43,0,43,35],[44,0,44,35],[45,0,45,35],[46,0,46,35],[47,0,47,35],[48,0,48,35],[49,0,49,35],[50,0,50,35]]}
[{"$nulls":7},"Name des Kindes",{"$nulls":7},"Geburtstag",{"$nulls":4},"Ferien*","Weihn.Vorjahr",null,null,{"$f":"DATE(Jahr,1,1)","v":"2013-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":"2013-01-05"},null,{"$f":"VLOOKUP(AQ2,Schulferien!$A$10:$B$25,2)","v":"Thüringen"},{"$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":"2013-02-18"},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":"2013-02-23"},{"$nulls":6},"bitte Kanzleianschrift eintragen",{"$nulls":8},16]
[{"$nulls":13},"geb.:",{"$nulls":7},"Osterferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),5)","v":"2013-03-25"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),6)","v":"2013-04-06"},{"$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\")","v":"31.3.13"}]
[{"$f":"IF(AN7=1,+Schulferien!B8,IF(AN7=2,+Schulferien!B28,\"\"))","v":2013},{"$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":"2013-05-10"},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":"2013-05-10"},{"$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":"2013-07-15"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),10)","v":"2013-08-23"}]
[{"$nulls":3},{"$f":"+Schulferien!B8","v":2013},{"$nulls":9},"geb.:",{"$nulls":7},"Herbstferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),11)","v":"2013-10-21"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),12)","v":"2013-11-02"},{"$nulls":12},1]
[{"$nulls":3},{"$f":"+Schulferien!B28","v":2014},{"$nulls":9},"geb.:",{"$nulls":7},"Weihnachtsf.",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),13)","v":"2013-12-23"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),14)","v":"2014-01-04"},{"$nulls":12},1]
[{"$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":"2013-01-01"},{"$f":"IF(A9=\"\",\"\",CHOOSE(WEEKDAY(A9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,{"$f":"DATE(YEAR(A9),MONTH(A9)+1,DAY(A9))","v":"2013-02-01"},{"$f":"IF(D9=\"\",\"\",CHOOSE(WEEKDAY(D9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(D9),MONTH(D9)+1,DAY(D9))","v":"2013-03-01"},{"$f":"IF(G9=\"\",\"\",CHOOSE(WEEKDAY(G9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(G9),MONTH(G9)+1,DAY(G9))","v":"2013-04-01"},{"$f":"IF(J9=\"\",\"\",CHOOSE(WEEKDAY(J9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mo"},null,{"$f":"DATE(YEAR(J9),MONTH(J9)+1,DAY(J9))","v":"2013-05-01"},{"$f":"IF(M9=\"\",\"\",CHOOSE(WEEKDAY(M9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mi"},null,{"$f":"DATE(YEAR(M9),MONTH(M9)+1,DAY(M9))","v":"2013-06-01"},{"$f":"IF(P9=\"\",\"\",CHOOSE(WEEKDAY(P9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Sa"},null,{"$f":"DATE(YEAR(P9),MONTH(P9)+1,DAY(P9))","v":"2013-07-01"},{"$f":"IF(S9=\"\",\"\",CHOOSE(WEEKDAY(S9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mo"},null,{"$f":"DATE(YEAR(S9),MONTH(S9)+1,DAY(S9))","v":"2013-08-01"},{"$f":"IF(V9=\"\",\"\",CHOOSE(WEEKDAY(V9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,{"$f":"DATE(YEAR(V9),MONTH(V9)+1,DAY(V9))","v":"2013-09-01"},{"$f":"IF(Y9=\"\",\"\",CHOOSE(WEEKDAY(Y9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,{"$f":"DATE(YEAR(Y9),MONTH(Y9)+1,DAY(Y9))","v":"2013-10-01"},{"$f":"IF(AB9=\"\",\"\",CHOOSE(WEEKDAY(AB9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,{"$f":"DATE(YEAR(AB9),MONTH(AB9)+1,DAY(AB9))","v":"2013-11-01"},{"$f":"IF(AE9=\"\",\"\",CHOOSE(WEEKDAY(AE9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(AE9),MONTH(AE9)+1,DAY(AE9))","v":"2013-12-01"},{"$f":"IF(AH9=\"\",\"\",CHOOSE(WEEKDAY(AH9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,null,"Neujahr",{"$f":"DATE(Jahr,1,1)","v":"2013-01-01"}]
[{"$f":"IF(MONTH(DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))>MONTH(A9),\"\",DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))","v":"2013-01-02"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))>MONTH(D9),\"\",DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))","v":"2013-02-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))>MONTH(G9),\"\",DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))","v":"2013-03-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))>MONTH(J9),\"\",DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))","v":"2013-04-02"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))>MONTH(M9),\"\",DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))","v":"2013-05-02"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))>MONTH(P9),\"\",DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))","v":"2013-06-02"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))>MONTH(S9),\"\",DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))","v":"2013-07-02"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))>MONTH(V9),\"\",DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))","v":"2013-08-02"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))>MONTH(Y9),\"\",DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))","v":"2013-09-02"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))>MONTH(AB9),\"\",DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))","v":"2013-10-02"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))>MONTH(AE9),\"\",DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))","v":"2013-11-02"},"Sa",null,{"$f":"IF(AH9=\"\",\"\",IF(MONTH(+AH9+1)=MONTH(AH9),AH9+1,\"\"))","v":"2013-12-02"},"Mo",null,null,"Rosenmontag",{"$f":"+AM12-48","v":"2013-02-11"}]
[{"$f":"IF(MONTH(DATE(YEAR(A10),MONTH(A10),DAY(A10)+1))>MONTH(A10),\"\",DATE(YEAR(A10),MONTH(A10),DAY(A10)+1))","v":"2013-01-03"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))>MONTH(D10),\"\",DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))","v":"2013-02-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))>MONTH(G10),\"\",DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))","v":"2013-03-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))>MONTH(J10),\"\",DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))","v":"2013-04-03"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))>MONTH(M10),\"\",DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))","v":"2013-05-03"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))>MONTH(P10),\"\",DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))","v":"2013-06-03"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))>MONTH(S10),\"\",DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))","v":"2013-07-03"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))>MONTH(V10),\"\",DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))","v":"2013-08-03"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))>MONTH(Y10),\"\",DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))","v":"2013-09-03"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))>MONTH(AB10),\"\",DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))","v":"2013-10-03"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))>MONTH(AE10),\"\",DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))","v":"2013-11-03"},"So",null,"2013-12-03","Di",null,null,"Karfreitag",{"$f":"+AM12-2","v":"2013-03-29"}]
["2013-01-04","Fr",null,"2013-02-04","Mo",null,"2013-03-04","Mo",null,"2013-04-04","Do",null,"2013-05-04","Sa",null,"2013-06-04","Di",null,"2013-07-04","Do",null,"2013-08-04","So",null,"2013-09-04","Mi",null,"2013-10-04","Fr",null,"2013-11-04","Mo",null,"2013-12-04","Mi",null,null,"Ostersonntag",{"$f":"DATEVALUE(AO3)","v":"2013-03-31"}]
["2013-01-05","Sa",null,"2013-02-05","Di",null,"2013-03-05","Di",null,"2013-04-05","Fr",null,"2013-05-05","So",null,"2013-06-05","Mi",null,"2013-07-05","Fr",null,"2013-08-05","Mo",null,"2013-09-05","Do",null,"2013-10-05","Sa",null,"2013-11-05","Di",null,"2013-12-05","Do",null,null,"Ostermontag",{"$f":"+AM12+1","v":"2013-04-01"}]
["2013-01-06","So",null,"2013-02-06","Mi",null,"2013-03-06","Mi",null,"2013-04-06","Sa",null,"2013-05-06","Mo",null,"2013-06-06","Do",null,"2013-07-06","Sa",null,"2013-08-06","Di",null,"2013-09-06","Fr",null,"2013-10-06","So",null,"2013-11-06","Mi",null,"2013-12-06","Fr",null,null,"Maifeiertag",{"$f":"DATE(Jahr,5,1)","v":"2013-05-01"}]
["2013-01-07","Mo",null,"2013-02-07","Do",null,"2013-03-07","Do",null,"2013-04-07","So",null,"2013-05-07","Di",null,"2013-06-07","Fr",null,"2013-07-07","So",null,"2013-08-07","Mi",null,"2013-09-07","Sa",null,"2013-10-07","Mo",null,"2013-11-07","Do",null,"2013-12-07","Sa",null,null,"ChristiHiFa",{"$f":"+AM12+39","v":"2013-05-09"}]
["2013-01-08","Di",null,"2013-02-08","Fr",null,"2013-03-08","Fr",null,"2013-04-08","Mo",null,"2013-05-08","Mi",null,"2013-06-08","Sa",null,"2013-07-08","Mo",null,"2013-08-08","Do",null,"2013-09-08","So",null,"2013-10-08","Di",null,"2013-11-08","Fr",null,"2013-12-08","So",null,null,"Pfingstso",{"$f":"+AM12+49","v":"2013-05-19"}]
["2013-01-09","Mi",null,"2013-02-09","Sa",null,"2013-03-09","Sa",null,"2013-04-09","Di",null,"2013-05-09","Do",null,"2013-06-09","So",null,"2013-07-09","Di",null,"2013-08-09","Fr",null,"2013-09-09","Mo",null,"2013-10-09","Mi",null,"2013-11-09","Sa",null,"2013-12-09","Mo",null,null,"PfingstMo",{"$f":"+AM16+1","v":"2013-05-20"}]
["2013-01-10","Do",null,"2013-02-10","So",null,"2013-03-10","So",null,"2013-04-10","Mi",null,"2013-05-10","Fr",null,"2013-06-10","Mo",null,"2013-07-10","Mi",null,"2013-08-10","Sa",null,"2013-09-10","Di",null,"2013-10-10","Do",null,"2013-11-10","So",null,"2013-12-10","Di",null,null,"Fronleichnam",{"$f":"+AM12+60","v":"2013-05-30"}]
["2013-01-11","Fr",null,"2013-02-11","Mo",null,"2013-03-11","Mo",null,"2013-04-11","Do",null,"2013-05-11","Sa",null,"2013-06-11","Di",null,"2013-07-11","Do",null,"2013-08-11","So",null,"2013-09-11","Mi",null,"2013-10-11","Fr",null,"2013-11-11","Mo",null,"2013-12-11","Mi",null,null,"Nationalfeiertag",{"$f":"DATE(Jahr,10,3)","v":"2013-10-03"}]
["2013-01-12","Sa",null,"2013-02-12","Di",null,"2013-03-12","Di",null,"2013-04-12","Fr",null,"2013-05-12","So",null,"2013-06-12","Mi",null,"2013-07-12","Fr",null,"2013-08-12","Mo",null,"2013-09-12","Do",null,"2013-10-12","Sa",null,"2013-11-12","Di",null,"2013-12-12","Do",null,null,"1.Weihnachtstag",{"$f":"DATE(Jahr,12,25)","v":"2013-12-25"}]
["2013-01-13","So",null,"2013-02-13","Mi",null,"2013-03-13","Mi",null,"2013-04-13","Sa",null,"2013-05-13","Mo",null,"2013-06-13","Do",null,"2013-07-13","Sa",null,"2013-08-13","Di",null,"2013-09-13","Fr",null,"2013-10-13","So",null,"2013-11-13","Mi",null,"2013-12-13","Fr",null,null,"2. Weihnachtstag",{"$f":"+AM20+1","v":"2013-12-26"}]
["2013-01-14","Mo",null,"2013-02-14","Do",null,"2013-03-14","Do",null,"2013-04-14","So",null,"2013-05-14","Di",null,"2013-06-14","Fr",null,"2013-07-14","So",null,"2013-08-14","Mi",null,"2013-09-14","Sa",null,"2013-10-14","Mo",null,"2013-11-14","Do",null,"2013-12-14","Sa"]
["2013-01-15","Di",null,"2013-02-15","Fr",null,"2013-03-15","Fr",null,"2013-04-15","Mo",null,"2013-05-15","Mi",null,"2013-06-15","Sa",null,"2013-07-15","Mo",null,"2013-08-15","Do",null,"2013-09-15","So",null,"2013-10-15","Di",null,"2013-11-15","Fr",null,"2013-12-15","So"]
["2013-01-16","Mi",null,"2013-02-16","Sa",null,"2013-03-16","Sa",null,"2013-04-16","Di",null,"2013-05-16","Do",null,"2013-06-16","So",null,"2013-07-16","Di",null,"2013-08-16","Fr",null,"2013-09-16","Mo",null,"2013-10-16","Mi",null,"2013-11-16","Sa",null,"2013-12-16","Mo"]
["2013-01-17","Do",null,"2013-02-17","So",null,"2013-03-17","So",null,"2013-04-17","Mi",null,"2013-05-17","Fr",null,"2013-06-17","Mo",null,"2013-07-17","Mi",null,"2013-08-17","Sa",null,"2013-09-17","Di",null,"2013-10-17","Do",null,"2013-11-17","So",null,"2013-12-17","Di"]
["2013-01-18","Fr",null,"2013-02-18","Mo",null,"2013-03-18","Mo",null,"2013-04-18","Do",null,"2013-05-18","Sa",null,"2013-06-18","Di",null,"2013-07-18","Do",null,"2013-08-18","So",null,"2013-09-18","Mi",null,"2013-10-18","Fr",null,"2013-11-18","Mo",null,"2013-12-18","Mi"]
["2013-01-19","Sa",null,"2013-02-19","Di",null,"2013-03-19","Di",null,"2013-04-19","Fr",null,"2013-05-19","So",null,"2013-06-19","Mi",null,"2013-07-19","Fr",null,"2013-08-19","Mo",null,"2013-09-19","Do",null,"2013-10-19","Sa",null,"2013-11-19","Di",null,"2013-12-19","Do"]
["2013-01-20","So",null,"2013-02-20","Mi",null,"2013-03-20","Mi",null,"2013-04-20","Sa",null,"2013-05-20","Mo",null,"2013-06-20","Do",null,"2013-07-20","Sa",null,"2013-08-20","Di",null,"2013-09-20","Fr",null,"2013-10-20","So",null,"2013-11-20","Mi",null,"2013-12-20","Fr"]
["2013-01-21","Mo",null,"2013-02-21","Do",null,"2013-03-21","Do",null,"2013-04-21","So",null,"2013-05-21","Di",null,"2013-06-21","Fr",null,"2013-07-21","So",null,"2013-08-21","Mi",null,"2013-09-21","Sa",null,"2013-10-21","Mo",null,"2013-11-21","Do",null,"2013-12-21","Sa"]
["2013-01-22","Di",null,"2013-02-22","Fr",null,"2013-03-22","Fr",null,"2013-04-22","Mo",null,"2013-05-22","Mi",null,"2013-06-22","Sa",null,"2013-07-22","Mo",null,"2013-08-22","Do",null,"2013-09-22","So",null,"2013-10-22","Di",null,"2013-11-22","Fr",null,"2013-12-22","So"]
["2013-01-23","Mi",null,"2013-02-23","Sa",null,"2013-03-23","Sa",null,"2013-04-23","Di",null,"2013-05-23","Do",null,"2013-06-23","So",null,"2013-07-23","Di",null,"2013-08-23","Fr",null,"2013-09-23","Mo",null,"2013-10-23","Mi",null,"2013-11-23","Sa",null,"2013-12-23","Mo"]
["2013-01-24","Do",null,"2013-02-24","So",null,"2013-03-24","So",null,"2013-04-24","Mi",null,"2013-05-24","Fr",null,"2013-06-24","Mo",null,"2013-07-24","Mi",null,"2013-08-24","Sa",null,"2013-09-24","Di",null,"2013-10-24","Do",null,"2013-11-24","So",null,"2013-12-24","Di"]
["2013-01-25","Fr",null,"2013-02-25","Mo",null,"2013-03-25","Mo",null,"2013-04-25","Do",null,"2013-05-25","Sa",null,"2013-06-25","Di",null,"2013-07-25","Do",null,"2013-08-25","So",null,"2013-09-25","Mi",null,"2013-10-25","Fr",null,"2013-11-25","Mo",null,"2013-12-25","Mi"]
["2013-01-26","Sa",null,"2013-02-26","Di",null,"2013-03-26","Di",null,"2013-04-26","Fr",null,"2013-05-26","So",null,"2013-06-26","Mi",null,"2013-07-26","Fr",null,"2013-08-26","Mo",null,"2013-09-26","Do",null,"2013-10-26","Sa",null,"2013-11-26","Di",null,"2013-12-26","Do"]
["2013-01-27","So",null,"2013-02-27","Mi",null,"2013-03-27","Mi",null,"2013-04-27","Sa",null,"2013-05-27","Mo",null,"2013-06-27","Do",null,"2013-07-27","Sa",null,"2013-08-27","Di",null,"2013-09-27","Fr",null,"2013-10-27","So",null,"2013-11-27","Mi",null,"2013-12-27","Fr"]
["2013-01-28","Mo",null,"2013-02-28","Do",null,"2013-03-28","Do",null,"2013-04-28","So",null,"2013-05-28","Di",null,"2013-06-28","Fr",null,"2013-07-28","So",null,"2013-08-28","Mi",null,"2013-09-28","Sa",null,"2013-10-28","Mo",null,"2013-11-28","Do",null,"2013-12-28","Sa"]
["2013-01-29","Di",null,"","",null,"2013-03-29","Fr",null,"2013-04-29","Mo",null,"2013-05-29","Mi",null,"2013-06-29","Sa",null,"2013-07-29","Mo",null,"2013-08-29","Do",null,"2013-09-29","So",null,"2013-10-29","Di",null,"2013-11-29","Fr",null,{"$f":"IF(AH36=\"\",\"\",IF(MONTH(+AH36+1)=MONTH(AH36),AH36+1,\"\"))","v":"2013-12-29"},"So"]
["2013-01-30","Mi",null,null,"",null,"2013-03-30","Sa",null,"2013-04-30","Di",null,"2013-05-30","Do",null,"2013-06-30","So",null,"2013-07-30","Di",null,"2013-08-30","Fr",null,"2013-09-30","Mo",null,"2013-10-30","Mi",null,"2013-11-30","Sa",null,{"$f":"IF(AH37=\"\",\"\",IF(MONTH(+AH37+1)=MONTH(AH37),AH37+1,\"\"))","v":"2013-12-30"},"Mo"]
["2013-01-31",{"$f":"IF(A39=\"\",\"\",CHOOSE(WEEKDAY(A39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,null,{"$f":"IF(D39=\"\",\"\",CHOOSE(WEEKDAY(D39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2013-03-31",{"$f":"IF(G39=\"\",\"\",CHOOSE(WEEKDAY(G39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,"",{"$f":"IF(J39=\"\",\"\",CHOOSE(WEEKDAY(J39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2013-05-31",{"$f":"IF(M39=\"\",\"\",CHOOSE(WEEKDAY(M39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,"",{"$f":"IF(P39=\"\",\"\",CHOOSE(WEEKDAY(P39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2013-07-31","Mi",null,"2013-08-31","Sa",null,"","",null,"2013-10-31","Do",null,"","",null,{"$f":"IF(AH38=\"\",\"\",IF(MONTH(+AH38+1)=MONTH(AH38),AH38+1,\"\"))","v":"2013-12-31"},"Di"]
[{"$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."]
["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":"2013-01-01"}]
[{"$f":"+AM10","v":"2013-02-11"}]
["2013-03-29"]
["2013-03-31"]
["2013-04-01"]
["2013-05-01"]
["2013-05-09"]
["2013-05-19"]
["2013-05-20"]
["2013-05-30"]
["2013-10-03"]
["2013-12-25"]
[{"$f":"+AM21","v":"2013-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,2013,"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 2012"}]
[1,"Baden-Württemberg",null,null,"2013-03-25","2013-04-05","2013-05-21","2013-06-01","2013-07-25","2013-09-07","2013-10-28","2013-10-30","2013-12-23","2014-01-04","2013-01-05"]
[{"$f":"+A10+1","v":2},"Bayern","2013-02-11","2013-02-15","2013-03-26","2013-04-06","2013-05-21","2013-05-31","2013-07-31","2013-09-11","2013-10-28","2013-10-31","2013-12-23","2014-01-04","2013-01-05"]
[{"$f":"+A11+1","v":3},"Berlin","2013-02-04","2013-02-09","2013-03-27","2013-04-06","2013-05-10","2013-05-10","2013-06-19","2013-08-02","2013-09-30","2013-10-12","2013-12-24","2014-01-03","2013-01-04"]
[4,"Brandenburg","2013-02-04","2013-02-09","2013-03-27","2013-04-06","2013-05-10","2013-05-10","2013-06-20","2013-08-02","2013-09-30","2013-10-12","2013-12-25","2014-01-03","2013-01-04"]
[5,"Bremen","2013-01-31","2013-02-01","2013-03-16","2013-04-02","2013-05-10","2013-05-10","2013-06-27","2013-08-07","2013-10-04","2013-10-18","2013-12-26","2014-01-03","2013-01-05"]
[6,"Hamburg","2013-02-01","2013-02-01","2013-03-04","2013-03-15","2013-05-02","2013-05-10","2013-06-20","2013-07-31","2013-09-30","2013-10-11","2013-12-19","2014-01-03","2013-01-04"]
[7,"Hessen",null,null,"2013-03-25","2013-04-06",null,null,"2013-07-08","2013-08-16","2013-10-14","2013-10-26","2013-12-23","2014-01-11","2013-01-12"]
[8,"Mecklenb.-Vorp.","2013-02-04","2013-02-15","2013-03-25","2013-04-03","2013-05-17","2013-05-21","2013-06-22","2013-08-03","2013-10-14","2013-10-19","2013-12-23","2014-01-03","2013-01-04"]
[9,"Niedersachsen","2013-01-31","2013-02-01","2013-03-16","2013-04-02","2013-05-10","2013-05-10","2013-06-27","2013-08-07","2013-10-04","2013-10-18","2013-12-23","2014-01-03","2013-01-05"]
[10,"NRW",null,null,"2013-03-25","2013-04-06","2013-05-21","2013-05-21","2013-07-22","2013-09-03","2013-10-21","2013-11-02","2013-12-23","2014-01-07","2013-01-04"]
[11,"Rheinland-Pfalz",null,null,"2013-03-20","2013-04-05",null,null,"2013-07-08","2013-08-16","2013-10-04","2013-10-18","2013-12-23","2014-01-07","2013-01-04"]
[12,"Saarland","2013-02-11","2013-02-16","2013-03-25","2013-04-06",null,null,"2013-07-08","2013-08-17","2013-10-21","2013-11-02","2013-12-20","2014-01-04","2013-01-05"]
[13,"Sachsen","2013-02-04","2013-02-15","2013-03-29","2013-04-06","2013-05-18","2013-05-22","2013-07-15","2013-08-23","2013-10-21","2013-11-01","2013-12-21","2014-01-03","2013-01-02"]
[14,"Sachsen-Anhalt","2013-02-01","2013-02-08","2013-03-25","2013-03-30","2013-05-10","2013-05-18","2013-07-15","2013-08-28","2013-10-21","2013-10-25","2013-12-21","2014-01-03","2013-01-04"]
[15,"Schleswig-Holstein",null,null,"2013-03-25","2013-04-09","2013-05-10","2013-05-10","2013-06-24","2013-08-03","2013-10-04","2013-10-18","2013-12-23","2014-01-06","2013-01-05"]
[16,"Thüringen","2013-02-18","2013-02-23","2013-03-25","2013-04-06","2013-05-10","2013-05-10","2013-07-15","2013-08-23","2013-10-21","2013-11-02","2013-12-23","2014-01-04","2013-01-05"]
[]
[]
[null,2014,"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 2013"}]
[1,"Baden-Württemb.",null,null,"2014-04-14","2014-04-25","2014-06-10","2014-06-21","2014-07-31","2014-09-13","2014-10-27","2014-10-30","2014-12-22","2015-01-05",{"$f":"+N10","v":"2014-01-04"}]
[{"$f":"+A30+1","v":2},"Bayern","2014-03-03","2014-03-07","2014-04-14","2014-04-26","2014-06-10","2014-06-21","2014-07-30","2014-09-15","2014-10-27","2014-10-31","2014-12-24","2015-01-05",{"$f":"+N11","v":"2014-01-04"}]
[{"$f":"+A31+1","v":3},"Berlin","2014-02-03","2014-02-08","2014-04-14","2014-04-26","2014-05-30","2014-05-30","2014-07-09","2014-08-22","2014-10-20","2014-11-01","2014-12-22","2015-01-02","2014-01-03"]
[4,"Brandenburg","2014-02-03","2014-02-08","2014-04-26","2014-05-02","2014-05-30","2014-05-30","2014-07-10","2014-08-22","2014-10-20","2014-11-01","2014-12-22","2015-01-02","2014-01-03"]
[5,"Bremen","2014-01-30","2014-01-31","2014-04-03","2014-05-22","2014-05-30","2014-06-10","2014-07-31","2014-09-10","2014-10-27","2014-11-08","2014-12-22","2015-01-05","2014-01-03"]
[6,"Hamburg","2014-01-31","2014-01-31","2014-03-03","2014-03-14","2014-04-28","2014-05-02","2014-07-10","2014-08-20","2014-10-13","2014-10-24","2014-12-22","2015-01-06","2014-01-03"]
[7,"Hessen",null,null,"2014-04-14","2014-04-26",null,null,"2014-07-28","2014-09-05","2014-10-20","2014-11-01","2014-12-22","2015-01-10","2014-01-11"]
[8,"Mecklenb.-Vorp.","2014-02-03","2014-02-15","2014-04-14","2014-04-23","2014-06-06","2014-06-10","2014-07-14","2014-08-23","2014-10-20","2014-10-25","2014-12-22","2015-01-02","2011-01-01"]
[9,"Niedersachsen","2014-01-30","2014-01-31","2014-04-03","2014-04-22","2014-05-30","2014-06-10","2014-07-31","2014-09-10","2014-10-27","2014-11-08","2014-12-22","2015-01-05","2014-01-03"]
[10,"NRW",null,null,"2014-04-14","2014-04-26","2014-06-10","2014-06-10","2014-07-07","2014-08-19","2014-10-06","2014-10-18","2014-12-22","2015-01-06","2014-01-07"]
[11,"Rheinland-Pfalz",null,null,"2014-04-11","2014-04-25",null,null,"2014-07-28","2014-09-05","2014-10-20","2014-10-31","2014-12-22","2015-01-07","2014-01-07"]
[12,"Saarland","2014-03-03","2014-03-08","2014-04-14","2014-04-26",null,null,"2014-07-28","2014-09-06","2014-10-02","2014-10-31","2014-12-22","2015-01-07","2014-01-04"]
[13,"Sachsen","2014-02-17","2014-03-01","2014-04-18","2014-04-26","2014-05-30","2014-05-30","2014-07-21","2014-08-29","2014-10-20","2014-10-31","2014-12-22","2015-01-03","2014-01-03"]
[14,"Sachsen-Anhalt","2014-02-01","2014-02-12","2014-04-14","2014-04-17","2014-05-30","2014-06-07","2014-07-21","2014-09-03","2014-10-27","2014-10-30","2014-12-22","2015-01-05","2014-01-03"]
[15,"Schleswig-Holstein",null,null,"2014-04-16","2014-05-02","2014-05-30","2014-05-30","2014-07-14","2014-08-23","2014-10-13","2014-10-25","2014-12-22","2015-01-06","2014-01-06"]
[16,"Thüringen","2014-02-17","2014-02-22","2014-04-19","2014-05-02","2014-05-30","2014-05-30","2014-07-21","2014-08-02","2014-10-06","2014-10-18","2014-12-22","2015-01-03","2014-01-04"]
[{"$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)."]