{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Umgangsregelung","Schulferien"],"not_rendered":{"charts":0,"images":0,"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":"Umgangsregelung","index":0,"n_rows":72,"n_cols":43,"rows_kept":72,"cut":false,"hidden":false,"merged":[[6,33,6,38],[5,33,5,37],[3,26,3,27],[3,21,3,23],[4,24,4,25],[1,33,1,38],[2,33,2,38],[3,33,3,38],[4,33,4,38],[7,33,7,35],[2,21,2,23],[4,26,4,27],[0,28,6,28],[0,33,0,38],[5,26,5,27],[3,24,3,25],[5,24,5,25],[2,24,2,25],[2,26,2,27],[7,37,7,38],[0,24,0,25],[0,26,0,27],[0,21,0,23],[1,24,1,25],[1,26,1,27],[1,0,1,6],[1,21,1,23],[5,13,5,14],[0,0,0,6],[1,7,1,12],[4,21,4,23],[0,20,6,20],[0,7,0,12],[0,15,0,18],[0,13,0,14],[6,15,6,18],[3,15,3,18],[1,15,1,18],[2,7,2,12],[2,13,2,14],[7,0,7,2],[7,3,7,5],[7,9,7,11],[0,19,6,19],[2,0,2,6],[5,7,5,12],[3,7,3,12],[7,12,7,14],[7,15,7,17],[2,15,2,18],[1,13,1,14],[3,0,4,6],[4,7,4,12],[4,15,4,18],[4,13,4,14],[3,13,3,14],[7,30,7,32],[6,21,6,23],[6,24,6,25],[6,26,6,27],[5,15,5,18],[7,24,7,26],[7,27,7,29],[6,13,6,14],[6,7,6,12],[6,3,6,5],[5,3,5,5],[7,18,7,20],[7,6,7,8],[40,9,40,10],[7,21,7,23],[31,37,38,38],[51,0,51,38],[46,0,46,38],[47,0,47,38],[48,0,48,38],[49,0,49,38],[50,0,50,38],[41,0,41,38],[42,0,42,38],[43,0,43,38],[44,0,44,38],[45,0,45,38],[39,32,39,35]]}
[null,null,null,null,null,null,null,"Name des Kindes",null,null,null,null,null,null,null,"Geburtstag",null,null,null,null,"Ferien*","Weihn.Vorjahr",null,null,{"$f":"DATE(Jahr,1,1)","v":"2015-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":"2015-01-05"},null,{"$f":"VLOOKUP(AQ2,Schulferien!$A$10:$B$25,2)","v":"Bayern"},null,null,null,null,"Rechtsanwalt Dr. Übler"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"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":"2015-02-16"},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":"2015-02-20"},null,null,null,null,null,null,"Luitpoldplatz 24",null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"Osterferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),5)","v":"2015-03-30"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),6)","v":"2015-04-11"},null,null,null,null,null,null,"92237 Sulzbach-Rosenberg",null,null,"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\")","v":"5.4.2015"}]
[{"$f":"IF(AN7=1,+Schulferien!B8,IF(AN7=2,+Schulferien!B28,\"\"))","v":2015},null,null,null,null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"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":"2015-05-16"},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":"2015-06-05"},null,null,null,null,null,null,"Tel. 09661 53201",null,null,"1905-06-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"Sommerferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),9)","v":"2015-08-01"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),10)","v":"2015-09-14"},null,null,null,null,null,null,"info@ra-uebler.de"]
[null,null,null,{"$f":"+Schulferien!B8","v":2015},null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"Herbstferien",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),11)","v":"2015-11-02"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),12)","v":"2015-11-07"},null,null,null,null,null,null,"www.ra-uebler.de",null,null,null,null,null,1]
[null,null,null,{"$f":"+Schulferien!B28","v":2014},null,null,null,null,null,null,null,null,null,"geb.:",null,null,null,null,null,null,null,"Weihnachtsf.",null,null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),13)","v":"2015-12-24"},null,{"$f":"VLOOKUP(AQ2,IF(AN7=1,Schulferien!A10:N25,Schulferien!A30:N45),14)","v":"2016-01-05"},null,null,null,null,null,null,null,null,null,null,null,null,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"},null,null,null,"Feiertage"]
[{"$f":"DATE(Jahr,1,1)","v":"2015-01-01"},{"$f":"IF(A9=\"\",\"\",CHOOSE(WEEKDAY(A9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,{"$f":"DATE(YEAR(A9),MONTH(A9)+1,DAY(A9))","v":"2015-02-01"},{"$f":"IF(D9=\"\",\"\",CHOOSE(WEEKDAY(D9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,{"$f":"DATE(YEAR(D9),MONTH(D9)+1,DAY(D9))","v":"2015-03-01"},{"$f":"IF(G9=\"\",\"\",CHOOSE(WEEKDAY(G9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,{"$f":"DATE(YEAR(G9),MONTH(G9)+1,DAY(G9))","v":"2015-04-01"},{"$f":"IF(J9=\"\",\"\",CHOOSE(WEEKDAY(J9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mi"},null,{"$f":"DATE(YEAR(J9),MONTH(J9)+1,DAY(J9))","v":"2015-05-01"},{"$f":"IF(M9=\"\",\"\",CHOOSE(WEEKDAY(M9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},null,{"$f":"DATE(YEAR(M9),MONTH(M9)+1,DAY(M9))","v":"2015-06-01"},{"$f":"IF(P9=\"\",\"\",CHOOSE(WEEKDAY(P9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mo"},null,{"$f":"DATE(YEAR(P9),MONTH(P9)+1,DAY(P9))","v":"2015-07-01"},{"$f":"IF(S9=\"\",\"\",CHOOSE(WEEKDAY(S9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mi"},null,{"$f":"DATE(YEAR(S9),MONTH(S9)+1,DAY(S9))","v":"2015-08-01"},{"$f":"IF(V9=\"\",\"\",CHOOSE(WEEKDAY(V9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Sa"},null,{"$f":"DATE(YEAR(V9),MONTH(V9)+1,DAY(V9))","v":"2015-09-01"},{"$f":"IF(Y9=\"\",\"\",CHOOSE(WEEKDAY(Y9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,{"$f":"DATE(YEAR(Y9),MONTH(Y9)+1,DAY(Y9))","v":"2015-10-01"},{"$f":"IF(AB9=\"\",\"\",CHOOSE(WEEKDAY(AB9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},null,{"$f":"DATE(YEAR(AB9),MONTH(AB9)+1,DAY(AB9))","v":"2015-11-01"},{"$f":"IF(AE9=\"\",\"\",CHOOSE(WEEKDAY(AE9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,{"$f":"DATE(YEAR(AE9),MONTH(AE9)+1,DAY(AE9))","v":"2015-12-01"},{"$f":"IF(AH9=\"\",\"\",CHOOSE(WEEKDAY(AH9,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,null,"Neujahr",{"$f":"DATE(Jahr,1,1)","v":"2015-01-01"}]
[{"$f":"IF(MONTH(DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))>MONTH(A9),\"\",DATE(YEAR(A9),MONTH(A9),DAY(A9)+1))","v":"2015-01-02"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))>MONTH(D9),\"\",DATE(YEAR(D9),MONTH(D9),DAY(D9)+1))","v":"2015-02-02"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))>MONTH(G9),\"\",DATE(YEAR(G9),MONTH(G9),DAY(G9)+1))","v":"2015-03-02"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))>MONTH(J9),\"\",DATE(YEAR(J9),MONTH(J9),DAY(J9)+1))","v":"2015-04-02"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))>MONTH(M9),\"\",DATE(YEAR(M9),MONTH(M9),DAY(M9)+1))","v":"2015-05-02"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))>MONTH(P9),\"\",DATE(YEAR(P9),MONTH(P9),DAY(P9)+1))","v":"2015-06-02"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))>MONTH(S9),\"\",DATE(YEAR(S9),MONTH(S9),DAY(S9)+1))","v":"2015-07-02"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))>MONTH(V9),\"\",DATE(YEAR(V9),MONTH(V9),DAY(V9)+1))","v":"2015-08-02"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))>MONTH(Y9),\"\",DATE(YEAR(Y9),MONTH(Y9),DAY(Y9)+1))","v":"2015-09-02"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))>MONTH(AB9),\"\",DATE(YEAR(AB9),MONTH(AB9),DAY(AB9)+1))","v":"2015-10-02"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))>MONTH(AE9),\"\",DATE(YEAR(AE9),MONTH(AE9),DAY(AE9)+1))","v":"2015-11-02"},"Mo",null,{"$f":"IF(AH9=\"\",\"\",IF(MONTH(+AH9+1)=MONTH(AH9),AH9+1,\"\"))","v":"2015-12-02"},"Mi",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":"2015-01-03"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))>MONTH(D10),\"\",DATE(YEAR(D10),MONTH(D10),DAY(D10)+1))","v":"2015-02-03"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))>MONTH(G10),\"\",DATE(YEAR(G10),MONTH(G10),DAY(G10)+1))","v":"2015-03-03"},"Di",null,{"$f":"IF(MONTH(DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))>MONTH(J10),\"\",DATE(YEAR(J10),MONTH(J10),DAY(J10)+1))","v":"2015-04-03"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))>MONTH(M10),\"\",DATE(YEAR(M10),MONTH(M10),DAY(M10)+1))","v":"2015-05-03"},"So",null,{"$f":"IF(MONTH(DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))>MONTH(P10),\"\",DATE(YEAR(P10),MONTH(P10),DAY(P10)+1))","v":"2015-06-03"},"Mi",null,{"$f":"IF(MONTH(DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))>MONTH(S10),\"\",DATE(YEAR(S10),MONTH(S10),DAY(S10)+1))","v":"2015-07-03"},"Fr",null,{"$f":"IF(MONTH(DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))>MONTH(V10),\"\",DATE(YEAR(V10),MONTH(V10),DAY(V10)+1))","v":"2015-08-03"},"Mo",null,{"$f":"IF(MONTH(DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))>MONTH(Y10),\"\",DATE(YEAR(Y10),MONTH(Y10),DAY(Y10)+1))","v":"2015-09-03"},"Do",null,{"$f":"IF(MONTH(DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))>MONTH(AB10),\"\",DATE(YEAR(AB10),MONTH(AB10),DAY(AB10)+1))","v":"2015-10-03"},"Sa",null,{"$f":"IF(MONTH(DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))>MONTH(AE10),\"\",DATE(YEAR(AE10),MONTH(AE10),DAY(AE10)+1))","v":"2015-11-03"},"Di",null,"2015-12-03","Do",null,null,"Karfreitag",{"$f":"+AM12-2","v":"2015-04-03"}]
["2015-01-04","So",null,"2015-02-04","Mi",null,"2015-03-04","Mi",null,"2015-04-04","Sa",null,"2015-05-04","Mo",null,"2015-06-04","Do",null,"2015-07-04","Sa",null,"2015-08-04","Di",null,"2015-09-04","Fr",null,"2015-10-04","So",null,"2015-11-04","Mi",null,"2015-12-04","Fr",null,null,"Ostersonntag",{"$f":"DATEVALUE(AO3)","v":"2015-04-05"}]
["2015-01-05","Mo",null,"2015-02-05","Do",null,"2015-03-05","Do",null,"2015-04-05","So",null,"2015-05-05","Di",null,"2015-06-05","Fr",null,"2015-07-05","So",null,"2015-08-05","Mi",null,"2015-09-05","Sa",null,"2015-10-05","Mo",null,"2015-11-05","Do",null,"2015-12-05","Sa",null,null,"Ostermontag",{"$f":"+AM12+1","v":"2015-04-06"}]
["2015-01-06","Di",null,"2015-02-06","Fr",null,"2015-03-06","Fr",null,"2015-04-06","Mo",null,"2015-05-06","Mi",null,"2015-06-06","Sa",null,"2015-07-06","Mo",null,"2015-08-06","Do",null,"2015-09-06","So",null,"2015-10-06","Di",null,"2015-11-06","Fr",null,"2015-12-06","So",null,null,"Maifeiertag",{"$f":"DATE(Jahr,5,1)","v":"2015-05-01"}]
["2015-01-07","Mi",null,"2015-02-07","Sa",null,"2015-03-07","Sa",null,"2015-04-07","Di",null,"2015-05-07","Do",null,"2015-06-07","So",null,"2015-07-07","Di",null,"2015-08-07","Fr",null,"2015-09-07","Mo",null,"2015-10-07","Mi",null,"2015-11-07","Sa",null,"2015-12-07","Mo",null,null,"ChristiHiFa",{"$f":"+AM12+39","v":"2015-05-14"}]
["2015-01-08","Do",null,"2015-02-08","So",null,"2015-03-08","So",null,"2015-04-08","Mi",null,"2015-05-08","Fr",null,"2015-06-08","Mo",null,"2015-07-08","Mi",null,"2015-08-08","Sa",null,"2015-09-08","Di",null,"2015-10-08","Do",null,"2015-11-08","So",null,"2015-12-08","Di",null,null,"Pfingstso",{"$f":"+AM12+49","v":"2015-05-24"}]
["2015-01-09","Fr",null,"2015-02-09","Mo",null,"2015-03-09","Mo",null,"2015-04-09","Do",null,"2015-05-09","Sa",null,"2015-06-09","Di",null,"2015-07-09","Do",null,"2015-08-09","So",null,"2015-09-09","Mi",null,"2015-10-09","Fr",null,"2015-11-09","Mo",null,"2015-12-09","Mi",null,null,"PfingstMo",{"$f":"+AM16+1","v":"2015-05-25"}]
["2015-01-10","Sa",null,"2015-02-10","Di",null,"2015-03-10","Di",null,"2015-04-10","Fr",null,"2015-05-10","So",null,"2015-06-10","Mi",null,"2015-07-10","Fr",null,"2015-08-10","Mo",null,"2015-09-10","Do",null,"2015-10-10","Sa",null,"2015-11-10","Di",null,"2015-12-10","Do",null,null,"Fronleichnam",{"$f":"+AM12+60","v":"2015-06-04"}]
["2015-01-11","So",null,"2015-02-11","Mi",null,"2015-03-11","Mi",null,"2015-04-11","Sa",null,"2015-05-11","Mo",null,"2015-06-11","Do",null,"2015-07-11","Sa",null,"2015-08-11","Di",null,"2015-09-11","Fr",null,"2015-10-11","So",null,"2015-11-11","Mi",null,"2015-12-11","Fr",null,null,"Nationalfeiertag",{"$f":"DATE(Jahr,10,3)","v":"2015-10-03"}]
["2015-01-12","Mo",null,"2015-02-12","Do",null,"2015-03-12","Do",null,"2015-04-12","So",null,"2015-05-12","Di",null,"2015-06-12","Fr",null,"2015-07-12","So",null,"2015-08-12","Mi",null,"2015-09-12","Sa",null,"2015-10-12","Mo",null,"2015-11-12","Do",null,"2015-12-12","Sa",null,null,"1.Weihnachtstag",{"$f":"DATE(Jahr,12,25)","v":"2015-12-25"}]
["2015-01-13","Di",null,"2015-02-13","Fr",null,"2015-03-13","Fr",null,"2015-04-13","Mo",null,"2015-05-13","Mi",null,"2015-06-13","Sa",null,"2015-07-13","Mo",null,"2015-08-13","Do",null,"2015-09-13","So",null,"2015-10-13","Di",null,"2015-11-13","Fr",null,"2015-12-13","So",null,null,"2. Weihnachtstag",{"$f":"+AM20+1","v":"2015-12-26"}]
["2015-01-14","Mi",null,"2015-02-14","Sa",null,"2015-03-14","Sa",null,"2015-04-14","Di",null,"2015-05-14","Do",null,"2015-06-14","So",null,"2015-07-14","Di",null,"2015-08-14","Fr",null,"2015-09-14","Mo",null,"2015-10-14","Mi",null,"2015-11-14","Sa",null,"2015-12-14","Mo"]
["2015-01-15","Do",null,"2015-02-15","So",null,"2015-03-15","So",null,"2015-04-15","Mi",null,"2015-05-15","Fr",null,"2015-06-15","Mo",null,"2015-07-15","Mi",null,"2015-08-15","Sa",null,"2015-09-15","Di",null,"2015-10-15","Do",null,"2015-11-15","So",null,"2015-12-15","Di"]
["2015-01-16","Fr",null,"2015-02-16","Mo",null,"2015-03-16","Mo",null,"2015-04-16","Do",null,"2015-05-16","Sa",null,"2015-06-16","Di",null,"2015-07-16","Do",null,"2015-08-16","So",null,"2015-09-16","Mi",null,"2015-10-16","Fr",null,"2015-11-16","Mo",null,"2015-12-16","Mi"]
["2015-01-17","Sa",null,"2015-02-17","Di",null,"2015-03-17","Di",null,"2015-04-17","Fr",null,"2015-05-17","So",null,"2015-06-17","Mi",null,"2015-07-17","Fr",null,"2015-08-17","Mo",null,"2015-09-17","Do",null,"2015-10-17","Sa",null,"2015-11-17","Di",null,"2015-12-17","Do"]
["2015-01-18","So",null,"2015-02-18","Mi",null,"2015-03-18","Mi",null,"2015-04-18","Sa",null,"2015-05-18","Mo",null,"2015-06-18","Do",null,"2015-07-18","Sa",null,"2015-08-18","Di",null,"2015-09-18","Fr",null,"2015-10-18","So",null,"2015-11-18","Mi",null,"2015-12-18","Fr"]
["2015-01-19","Mo",null,"2015-02-19","Do",null,"2015-03-19","Do",null,"2015-04-19","So",null,"2015-05-19","Di",null,"2015-06-19","Fr",null,"2015-07-19","So",null,"2015-08-19","Mi",null,"2015-09-19","Sa",null,"2015-10-19","Mo",null,"2015-11-19","Do",null,"2015-12-19","Sa"]
["2015-01-20","Di",null,"2015-02-20","Fr",null,"2015-03-20","Fr",null,"2015-04-20","Mo",null,"2015-05-20","Mi",null,"2015-06-20","Sa",null,"2015-07-20","Mo",null,"2015-08-20","Do",null,"2015-09-20","So",null,"2015-10-20","Di",null,"2015-11-20","Fr",null,"2015-12-20","So"]
["2015-01-21","Mi",null,"2015-02-21","Sa",null,"2015-03-21","Sa",null,"2015-04-21","Di",null,"2015-05-21","Do",null,"2015-06-21","So",null,"2015-07-21","Di",null,"2015-08-21","Fr",null,"2015-09-21","Mo",null,"2015-10-21","Mi",null,"2015-11-21","Sa",null,"2015-12-21","Mo"]
["2015-01-22","Do",null,"2015-02-22","So",null,"2015-03-22","So",null,"2015-04-22","Mi",null,"2015-05-22","Fr",null,"2015-06-22","Mo",null,"2015-07-22","Mi",null,"2015-08-22","Sa",null,"2015-09-22","Di",null,"2015-10-22","Do",null,"2015-11-22","So",null,"2015-12-22","Di"]
["2015-01-23","Fr",null,"2015-02-23","Mo",null,"2015-03-23","Mo",null,"2015-04-23","Do",null,"2015-05-23","Sa",null,"2015-06-23","Di",null,"2015-07-23","Do",null,"2015-08-23","So",null,"2015-09-23","Mi",null,"2015-10-23","Fr",null,"2015-11-23","Mo",null,"2015-12-23","Mi"]
["2015-01-24","Sa",null,"2015-02-24","Di",null,"2015-03-24","Di",null,"2015-04-24","Fr",null,"2015-05-24","So",null,"2015-06-24","Mi",null,"2015-07-24","Fr",null,"2015-08-24","Mo",null,"2015-09-24","Do",null,"2015-10-24","Sa",null,"2015-11-24","Di",null,"2015-12-24","Do",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. "]
["2015-01-25","So",null,"2015-02-25","Mi",null,"2015-03-25","Mi",null,"2015-04-25","Sa",null,"2015-05-25","Mo",null,"2015-06-25","Do",null,"2015-07-25","Sa",null,"2015-08-25","Di",null,"2015-09-25","Fr",null,"2015-10-25","So",null,"2015-11-25","Mi",null,"2015-12-25","Fr"]
["2015-01-26","Mo",null,"2015-02-26","Do",null,"2015-03-26","Do",null,"2015-04-26","So",null,"2015-05-26","Di",null,"2015-06-26","Fr",null,"2015-07-26","So",null,"2015-08-26","Mi",null,"2015-09-26","Sa",null,"2015-10-26","Mo",null,"2015-11-26","Do",null,"2015-12-26","Sa"]
["2015-01-27","Di",null,"2015-02-27","Fr",null,"2015-03-27","Fr",null,"2015-04-27","Mo",null,"2015-05-27","Mi",null,"2015-06-27","Sa",null,"2015-07-27","Mo",null,"2015-08-27","Do",null,"2015-09-27","So",null,"2015-10-27","Di",null,"2015-11-27","Fr",null,"2015-12-27","So"]
["2015-01-28","Mi",null,"2015-02-28","Sa",null,"2015-03-28","Sa",null,"2015-04-28","Di",null,"2015-05-28","Do",null,"2015-06-28","So",null,"2015-07-28","Di",null,"2015-08-28","Fr",null,"2015-09-28","Mo",null,"2015-10-28","Mi",null,"2015-11-28","Sa",null,"2015-12-28","Mo"]
["2015-01-29","Do",null,"","",null,"2015-03-29","So",null,"2015-04-29","Mi",null,"2015-05-29","Fr",null,"2015-06-29","Mo",null,"2015-07-29","Mi",null,"2015-08-29","Sa",null,"2015-09-29","Di",null,"2015-10-29","Do",null,"2015-11-29","So",null,{"$f":"IF(AH36=\"\",\"\",IF(MONTH(+AH36+1)=MONTH(AH36),AH36+1,\"\"))","v":"2015-12-29"},"Di"]
["2015-01-30","Fr",null,null,"",null,"2015-03-30","Mo",null,"2015-04-30","Do",null,"2015-05-30","Sa",null,"2015-06-30","Di",null,"2015-07-30","Do",null,"2015-08-30","So",null,"2015-09-30","Mi",null,"2015-10-30","Fr",null,"2015-11-30","Mo",null,{"$f":"IF(AH37=\"\",\"\",IF(MONTH(+AH37+1)=MONTH(AH37),AH37+1,\"\"))","v":"2015-12-30"},"Mi"]
["2015-01-31",{"$f":"IF(A39=\"\",\"\",CHOOSE(WEEKDAY(A39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Sa"},null,null,{"$f":"IF(D39=\"\",\"\",CHOOSE(WEEKDAY(D39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2015-03-31",{"$f":"IF(G39=\"\",\"\",CHOOSE(WEEKDAY(G39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Di"},null,"",{"$f":"IF(J39=\"\",\"\",CHOOSE(WEEKDAY(J39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2015-05-31",{"$f":"IF(M39=\"\",\"\",CHOOSE(WEEKDAY(M39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"So"},null,"",{"$f":"IF(P39=\"\",\"\",CHOOSE(WEEKDAY(P39,1),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":""},null,"2015-07-31","Fr",null,"2015-08-31","Mo",null,"","",null,"2015-10-31","Sa",null,"","",null,{"$f":"IF(AH38=\"\",\"\",IF(MONTH(+AH38+1)=MONTH(AH38),AH38+1,\"\"))","v":"2015-12-31"},"Do"]
[null,null,null,null,null,null,null,null,null,null,null,{"$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},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*) 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."]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+AM9","v":"2015-01-01"}]
[{"$f":"+AM10","v":"00:00:00"}]
["2015-04-03"]
["2015-04-05"]
["2015-04-06"]
["2015-05-01"]
["2015-05-14"]
["2015-05-24"]
["2015-05-25"]
["2015-06-04"]
["2015-10-03"]
["2015-12-25"]
[{"$f":"+AM21","v":"2015-12-26"}]

{"sheet":"Schulferien","index":1,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,0,6,14],[27,1,28,1],[7,8,7,9],[7,10,7,11],[27,2,27,3],[27,4,27,5],[7,1,8,1],[27,10,27,11],[27,6,27,7],[27,8,27,9],[7,4,7,5],[7,6,7,7],[7,2,7,3],[7,12,7,14],[27,12,27,14],[51,0,51,35],[52,0,52,35],[46,9,46,10],[47,0,47,35],[48,0,48,35],[49,0,49,35],[50,0,50,35]]}
[]
[]
[]
[]
[]
["Ferienregelung und Anpassung des Umgangskalenders"]
[]
[null,2015,"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 2014"}]
[1,"Baden-Württemberg",null,null,"2015-03-30","2015-04-10","2015-05-26","2015-06-06","2015-07-30","2015-09-12","2015-11-02","2015-11-06","2015-12-23","2016-01-09",{"$f":"+N30","v":"2015-01-05"}]
[{"$f":"+A10+1","v":2},"Bayern","2015-02-16","2015-02-20","2015-03-30","2015-04-11","2015-05-16","2015-06-05","2015-08-01","2015-09-14","2015-11-02","2015-11-07","2015-12-24","2016-01-05",{"$f":"+N31","v":"2015-01-05"}]
[{"$f":"+A11+1","v":3},"Berlin","2015-02-02","2015-02-07","2015-03-30","2015-04-11","2015-05-15","2015-05-15","2015-07-15","2015-08-28","2015-10-19","2015-10-31","2015-12-23","2016-01-02","2015-01-02"]
[4,"Brandenburg","2015-02-02","2015-02-07","2015-04-01","2015-04-11","2015-05-15","2015-05-15","2015-07-16","2015-08-28","2015-10-19","2015-10-30","2015-12-23","2016-01-02","2015-01-02"]
[5,"Bremen","2015-02-02","2015-02-03","2015-03-25","2015-04-10","2015-05-15","2015-05-15","2015-07-23","2015-09-02","2015-10-19","2015-10-31","2015-12-23","2016-01-06","2015-01-05"]
[6,"Hamburg","2015-01-30","2015-01-30","2015-03-02","2015-03-13","2015-05-11","2015-05-15","2015-07-16","2015-08-26","2015-10-19","2015-10-30","2015-12-21","2016-01-01","2015-01-06"]
[7,"Hessen",null,null,"2015-03-30","2015-04-11",null,null,"2015-07-27","2015-09-04","2015-10-19","2015-10-31","2015-12-23","2016-01-09","2015-01-10"]
[8,"Mecklenb.-Vorp.","2015-02-02","2015-02-14","2015-03-30","2015-04-08","2015-05-22","2015-05-26","2015-07-20","2015-08-29","2015-10-24","2015-10-30","2015-12-23","2016-01-02","2015-01-02"]
[9,"Niedersachsen","2015-02-02","2015-02-03","2015-03-25","2015-04-10","2015-05-15","2015-05-15","2015-07-23","2015-09-02","2015-10-19","2015-10-31","2015-12-23","2016-01-06","2015-01-05"]
[10,"NRW",null,null,"2015-03-30","2015-04-11","2015-05-26","2015-05-26","2015-06-29","2015-08-11","2015-10-05","2015-10-17","2015-12-23","2016-01-06","2015-01-06"]
[11,"Rheinland-Pfalz",null,null,"2015-03-26","2015-04-10",null,null,"2015-07-27","2015-09-04","2015-10-19","2015-10-30","2015-12-23","2016-01-08","2015-01-07"]
[12,"Saarland","2015-02-16","2015-02-21","2015-03-30","2015-04-11",null,null,"2015-07-27","2015-09-04","2015-10-19","2015-10-31","2015-12-21","2016-01-02","2015-01-07"]
[13,"Sachsen","2015-02-09","2015-02-21","2015-04-02","2015-04-11","2015-05-15","2015-05-15","2015-07-13","2015-08-21","2015-10-12","2015-10-24","2015-12-21","2016-01-02","2015-01-03"]
[14,"Sachsen-Anhalt","2015-02-02","2015-02-14","2015-04-02","2015-04-02","2015-05-15","2015-05-26","2015-07-13","2015-08-26","2015-10-17","2015-10-24","2015-12-21","2016-01-05","2015-01-05"]
[15,"Schleswig-Holstein",null,null,"2015-04-01","2015-04-17","2015-05-15","2015-05-15","2015-07-20","2015-08-29","2015-10-19","2015-10-31","2015-12-21","2016-01-06","2015-01-06"]
[16,"Thüringen","2015-02-02","2015-02-07","2015-03-30","2015-04-11","2015-05-15","2015-05-15","2015-07-13","2015-08-21","2015-10-05","2015-10-17","2015-12-23","2016-01-02","2015-01-03"]
[]
[]
[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","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","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","2014-01-03"]
[9,"Niedersachsen","2014-01-30","2014-01-31","2014-04-03","2014-04-22","2014-06-10","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"]
[null,null,null,null,null,null,null,null,null,null,"©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)."]