{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Preise"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[1,1,1,4],[1,7,1,8],[5,1,5,6],[7,1,7,6],[9,7,9,8],[15,1,15,3],[15,7,15,8],[19,1,19,2],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,3,22,4],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,7],[29,1,29,2],[30,1,30,2],[32,1,32,9],[33,1,33,9],[34,1,34,9],[35,1,35,9],[37,1,37,9],[38,1,38,3]]}
[]
[null,"Tarifinformation Kleinkindgruppe ",{"$nulls":3},{"v":2024,"d":"2024 -"},{"$f":"F2+1","v":2025},"Sep. 2024-Juli 2025"]
[]
[null,"1. Monat auswählen",{"$nulls":3},{"v":9,"d":"Monat   09"}]
[]
[null,"2. Die vereinbarte Betreuungszeit von - bis laut Betreuungsvertrag eingeben \nFormat: hh:mm"]
[]
[null,"3. Mittagessen x in der Spalte nach den Kosten eintragen"]
[{"$nulls":8},".X↓"]
[null,null,"von","bis","Zeit regulär","verlängerte\nÖffnungszeit","Kosten Tag","Mittagessen"]
[null,"Montag","00:00:00","00:00:00",{"$f":"IF(C11=0,0,IF(C11*24<7,IF(D11*24>17,10,D11*24-7),IF(D11*24>17,17-C11*24,D11*24-C11*24)))","v":{"v":0,"d":"0.00"}},{"$f":"D11*24-C11*24-E11","v":0},{"$f":"E11*$D$25+F11*$D$26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(I11=\"x\",$D$27,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Dienstag","00:00:00","00:00:00",{"$f":"IF(C12=0,0,IF(C12*24<7,IF(D12*24>17,10,D12*24-7),IF(D12*24>17,17-C12*24,D12*24-C12*24)))","v":{"v":0,"d":"0.00"}},{"$f":"D12*24-C12*24-E12","v":0},{"$f":"E12*$D$25+F12*$D$26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(I12=\"x\",$D$27,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Mittwoch","00:00:00","00:00:00",{"v":0,"d":"0.00"},{"$f":"D13*24-C13*24-E13","v":0},{"$f":"E13*$D$25+F13*$D$26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(I13=\"x\",$D$27,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Donnerstag","00:00:00","00:00:00",{"v":0,"d":"0.00"},{"$f":"D14*24-C14*24-E14","v":0},{"$f":"E14*$D$25+F14*$D$26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(I14=\"x\",$D$27,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Freitag","00:00:00","00:00:00",{"$f":"IF(C15=0,0,IF(C15*24<7,IF(D15*24>16,9,D15*24-7),IF(D15*24>16,16-C15*24,D15*24-C15*24)))","v":{"v":0,"d":"0.00"}},{"$f":"D15*24-C15*24-E15","v":0},{"$f":"E15*$D$25+F15*$D$26","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(I15=\"x\",$D$27,0)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},{"$f":"SUM(E11:E15)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F11:F15)","v":0},{"$f":"SUM(G11:G15)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H11:H15)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Vereinbarte Betreuungszeit",{"$f":"E16+F16","v":{"v":0,"d":"0.00"}},"  Stunden ",null,null,{"$f":"COUNTIF(G11:G15,\">0\")","v":0}]
[]
[null,"Kostenbeitrag ",null,"Kostenersatz \nLand Salzburg","Mittagessen ","Betreuungs-\nbeitrag","Elternbeitrag \ngesamt"]
[null,{"$f":"DATE(F2,F4,1)","v":"2024-09-01"},{"$f":"$G$11*Preise!M69+$G$12*Preise!N69+$G$13*Preise!O69+$G$14*Preise!P69+$G$15*Preise!Q69","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($C$18<31,$D$30,$D$31)","v":{"v":20,"d":"20.00 €"}},{"$f":"$H$11*Preise!M69+$H$12*Preise!N69+$H$13*Preise!O69+$H$14*Preise!P69+$H$15*Preise!Q69","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C21-D21<0,0,C21-D21)","v":{"v":0,"d":"0.00 €"}},{"$f":"F21+E21","v":{"v":0,"d":"0.00 €"}}]
[null,{"$f":"IF(MONTH(B21)=6,DATE(F2,7,1),\"\")","v":""},{"$f":"IF(B22=\"\",\"\",$G$11*Preise!M70+$G$12*Preise!N70+$G$13*Preise!O70+$G$14*Preise!P70+$G$15*Preise!Q70)","v":""},{"$f":"IF(B22=\"\",\"\",IF($C$18<31,$D$30,$D$31))","v":""},{"$f":"IF(B22=\"\",\"\",$H$11*Preise!M70+$H$12*Preise!N70+$H$13*Preise!O70+$H$14*Preise!P70+$H$15*Preise!Q70)","v":""},{"$f":"IF(B22=\"\",\"\",IF(C22-D22<0,0,C22-D22))","v":""},{"$f":"IF(B22=\"\",\"\",F22+E22)","v":""}]
[]
[null,"Tarife "]
[null,"Stunden regulär",null,{"v":1.3,"d":"1.30 €"}]
[null,"Stunden verl. Öffnungszeit",null,{"v":2.6,"d":"2.60 €"}]
[null,"Mittagessen",null,{"v":3.25,"d":"3.25 €"}]
[]
[null,"Förderung Landesregierung \nwird nur bei einer Betreuung von 2 Wochen und 2 Tage pro Monat gewährt. "]
[null,"bis 30 Stunden",null,{"v":20,"d":"20.00 €"},"im Monat"]
[null,"ab 31 Stunden",null,{"v":40,"d":"40.00 €"},"im Monat"]
[]
[null,"Verrechnet werden monatlich\n- die in der Betreuungsvereinbarung fixierten Stunden pro Tag und \n- die Tage an denen das Kind für das Mittagessen angemeldet ist. "]
[null,"Die Juliwochen bis zum Beginn der Sommerferein wird gemeinsam mit der Junirechnung verrechnet!"]
[null,"Gesetzliche Feiertage, der Allerseelentag sowie die Weihnachts-, Oster- und Sommerferien werden von der regulären Verrechnung ausgenommen. Nicht ausgenommen werden der, in jedem Betrieb unterschiedlich stattfindende, Klausurtag und Betriebsausflugstag. "]
[null,"Für die Betreuung in den Ferienzeiten ist eine zusätzliche Anmeldung erforderlich! \nDie Kosten dafür sind nicht in diesem Infoblatt nicht enthalten und werden extra verrechnet. "]
[]
[null,"Genauere Informationen entnehmen Sie bitte der Tarifordnung"]
[null,"www.stadt-salzburg.at/kinderbetreuung"]

{"sheet":"Preise","index":1,"n_rows":119,"n_cols":38,"rows_kept":119,"hidden":true,"merged":[[5,1,5,11],[44,2,44,8],[45,2,45,8],[46,2,46,8],[47,2,47,8],[48,2,48,8],[49,2,49,8],[50,2,50,8],[51,2,51,8],[52,2,52,8],[53,2,53,8],[54,2,54,8],[55,2,55,8],[56,2,56,8],[57,2,57,8],[58,2,58,8],[59,2,59,8],[60,2,60,8],[61,2,61,8],[62,2,62,8],[63,2,63,8],[63,11,63,13],[64,2,64,8],[64,11,64,13],[65,2,65,8],[66,2,66,8],[67,2,67,8],[68,2,68,8],[69,2,69,8],[70,2,70,8],[71,2,71,8],[72,2,72,8],[73,2,73,8],[74,2,74,8],[75,2,75,8],[76,2,76,8],[77,2,77,8],[78,2,78,8],[79,2,79,8],[80,2,80,8],[81,2,81,8],[82,2,82,8],[83,2,83,8],[84,2,84,8],[85,2,85,8],[86,2,86,8],[87,2,87,8],[88,2,88,8],[89,2,89,8],[90,2,90,8],[91,2,91,8],[92,2,92,8],[93,2,93,8],[94,2,94,8],[95,2,95,8],[96,2,96,8],[97,2,97,8],[98,2,98,8],[99,2,99,8],[100,2,100,8],[101,2,101,8],[102,2,102,8],[103,2,103,8],[104,2,104,8],[105,2,105,8],[106,2,106,8],[107,2,107,8],[108,2,108,8],[109,2,109,8],[110,2,110,8],[111,2,111,8],[112,2,112,8],[113,2,113,8],[114,2,114,8],[115,2,115,8],[116,2,116,8],[117,2,117,8],[118,2,118,8]]}
["Stunden regulär"]
["Stunden verl. Öffnungszeit"]
["ESSEN"]
["Kostenersatz Land"]
["Kostenersatz Land"]
[{"$f":"Tabelle1!F2","v":2024},"Namex"]
[{"$f":"DATE($A$6+1,1,1)","v":"2025-01-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6+1,1,B7)","v":"2025-01-01"},{"$f":"DATE($A$6+1,1,C7)","v":"2025-01-02"},"2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30","2025-01-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B8)=1,1,IF(WEEKDAY(B8)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B8,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B8),1)))","v":1},{"$f":"IF(WEEKDAY(C8)=1,1,IF(WEEKDAY(C8)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C8,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C8),1)))","v":1},1,1,1,1,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,null,{"$f":"COUNTIF(B9:AF9,2)","v":3},{"$f":"COUNTIF(B9:AF9,3)","v":4},{"$f":"COUNTIF(B9:AF9,4)","v":4},{"$f":"COUNTIF(B9:AF9,5)","v":4},{"$f":"COUNTIF(B9:AF9,6)","v":4}]
[{"$f":"DATE($A$6+1,2,1)","v":"2025-02-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,{"$f":"DATE($A$6+1,2,B10)","v":"2025-02-01"},{"$f":"DATE($A$6+1,2,C10)","v":"2025-02-02"},"2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09","2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16","2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23","2025-02-24","2025-02-25","2025-02-26","2025-02-27","2025-02-28",{"$f":"DATE($A$6+1,2,AD10)","v":"2025-03-01"},null,null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B11)=1,1,IF(WEEKDAY(B11)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B11,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B11),1)))","v":1},{"$f":"IF(WEEKDAY(C11)=1,1,IF(WEEKDAY(C11)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C11,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C11),1)))","v":1},2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,{"$f":"IF(MONTH(AD11)=3,1,IF(WEEKDAY(AD11)=1,1,IF(WEEKDAY(AD11)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(AD11,$A$45:$A$120,0)))=TRUE(),WEEKDAY(AD11),1))))","v":1},{"$nulls":3},{"$f":"COUNTIF(B12:AF12,2)","v":4},{"$f":"COUNTIF(B12:AF12,3)","v":4},{"$f":"COUNTIF(B12:AF12,4)","v":4},{"$f":"COUNTIF(B12:AF12,5)","v":4},{"$f":"COUNTIF(B12:AF12,6)","v":4}]
[{"$f":"DATE($A$6+1,3,1)","v":"2025-03-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6+1,3,B13)","v":"2025-03-01"},{"$f":"DATE($A$6+1,3,C13)","v":"2025-03-02"},"2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09","2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16","2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23","2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28","2025-03-29","2025-03-30","2025-03-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B14)=1,1,IF(WEEKDAY(B14)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B14,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B14),1)))","v":1},{"$f":"IF(WEEKDAY(C14)=1,1,IF(WEEKDAY(C14)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C14,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C14),1)))","v":1},2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,null,{"$f":"COUNTIF(B15:AF15,2)","v":5},{"$f":"COUNTIF(B15:AF15,3)","v":4},{"$f":"COUNTIF(B15:AF15,4)","v":4},{"$f":"COUNTIF(B15:AF15,5)","v":4},{"$f":"COUNTIF(B15:AF15,6)","v":4}]
[{"$f":"DATE($A$6+1,4,1)","v":"2025-04-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"DATE($A$6+1,4,B16)","v":"2025-04-01"},{"$f":"DATE($A$6+1,4,C16)","v":"2025-04-02"},"2025-04-03","2025-04-04","2025-04-05","2025-04-06","2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13","2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20","2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27","2025-04-28","2025-04-29","2025-04-30",null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B17)=1,1,IF(WEEKDAY(B17)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B17,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B17),1)))","v":3},{"$f":"IF(WEEKDAY(C17)=1,1,IF(WEEKDAY(C17)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C17,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C17),1)))","v":4},5,6,1,1,2,3,4,5,6,1,1,1,1,1,1,1,1,1,1,3,4,5,6,1,1,2,3,4,null,null,{"$f":"COUNTIF(J18:AF18,2)","v":1},{"$f":"COUNTIF(J18:AF18,3)","v":2},{"$f":"COUNTIF(J18:AF18,4)","v":3},{"$f":"COUNTIF(J18:AF18,5)","v":2},{"$f":"COUNTIF(J18:AF18,6)","v":2}]
[{"$f":"DATE($A$6+1,5,1)","v":"2025-05-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6+1,5,B19)","v":"2025-05-01"},{"$f":"DATE($A$6+1,5,C19)","v":"2025-05-02"},"2025-05-03","2025-05-04","2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11","2025-05-12","2025-05-13","2025-05-14","2025-05-15","2025-05-16","2025-05-17","2025-05-18","2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25","2025-05-26","2025-05-27","2025-05-28","2025-05-29","2025-05-30","2025-05-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B20)=1,1,IF(WEEKDAY(B20)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B20,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B20),1)))","v":5},{"$f":"IF(WEEKDAY(C20)=1,1,IF(WEEKDAY(C20)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C20,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C20),1)))","v":6},1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,1,6,1,null,{"$f":"COUNTIF(B21:AF21,2)","v":4},{"$f":"COUNTIF(B21:AF21,3)","v":4},{"$f":"COUNTIF(B21:AF21,4)","v":4},{"$f":"COUNTIF(B21:AF21,5)","v":4},{"$f":"COUNTIF(B21:AF21,6)","v":5}]
[{"$f":"DATE($A$6+1,6,1)","v":"2025-06-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"DATE($A$6+1,6,B22)","v":"2025-06-01"},{"$f":"DATE($A$6+1,6,C22)","v":"2025-06-02"},"2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08","2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15","2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28","2025-06-29","2025-06-30",null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B23)=1,1,IF(WEEKDAY(B23)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B23,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B23),1)))","v":1},{"$f":"IF(WEEKDAY(C23)=1,1,IF(WEEKDAY(C23)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C23,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C23),1)))","v":2},3,4,5,6,1,1,1,3,4,5,6,1,1,2,3,4,1,6,1,1,2,3,4,5,6,1,1,2,null,null,{"$f":"COUNTIF(B24:AF24,2)","v":4},{"$f":"COUNTIF(B24:AF24,3)","v":4},{"$f":"COUNTIF(B24:AF24,4)","v":4},{"$f":"COUNTIF(B24:AF24,5)","v":3},{"$f":"COUNTIF(B24:AF24,6)","v":4}]
[{"$f":"DATE($A$6+1,7,1)","v":"2025-07-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6+1,7,B25)","v":"2025-07-01"},{"$f":"DATE($A$6+1,7,C25)","v":"2025-07-02"},"2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30","2025-07-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B26)=1,1,IF(WEEKDAY(B26)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B26,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B26),1)))","v":3},{"$f":"IF(WEEKDAY(C26)=1,1,IF(WEEKDAY(C26)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C26,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C26),1)))","v":4},5,6,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,{"$f":"COUNTIF(B27:I27,2)","v":0},{"$f":"COUNTIF(B27:I27,3)","v":1},{"$f":"COUNTIF(B27:I27,4)","v":1},{"$f":"COUNTIF(B27:I27,5)","v":1},{"$f":"COUNTIF(B27:I27,6)","v":1}]
[{"$f":"DATE($A$6,8,1)","v":"2024-08-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6,8,B28)","v":"2024-08-01"},{"$f":"DATE($A$6,8,C28)","v":"2024-08-02"},"2024-08-03","2024-08-04","2024-08-05","2024-08-06","2024-08-07","2024-08-08","2024-08-09","2024-08-10","2024-08-11","2024-08-12","2024-08-13","2024-08-14","2024-08-15","2024-08-16","2024-08-17","2024-08-18","2024-08-19","2024-08-20","2024-08-21","2024-08-22","2024-08-23","2024-08-24","2024-08-25","2024-08-26","2024-08-27","2024-08-28","2024-08-29","2024-08-30","2024-08-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B29)=1,1,IF(WEEKDAY(B29)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B29,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B29),1)))","v":5},{"$f":"IF(WEEKDAY(C29)=1,1,IF(WEEKDAY(C29)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C29,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C29),1)))","v":6},1,1,2,3,4,5,6,1,1,2,3,4,1,6,1,1,2,3,4,5,1,1,1,1,1,1,1,1,1,null,{"$f":"COUNTIF(B30:AF30,2)","v":3},{"$f":"COUNTIF(B30:AF30,3)","v":3},{"$f":"COUNTIF(B30:AF30,4)","v":3},{"$f":"COUNTIF(B30:AF30,5)","v":3},{"$f":"COUNTIF(B30:AF30,6)","v":3}]
[{"$f":"DATE($A$6,9,1)","v":"2024-09-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"DATE($A$6,9,B31)","v":"2024-09-01"},{"$f":"DATE($A$6,9,C31)","v":"2024-09-02"},"2024-09-03","2024-09-04","2024-09-05","2024-09-06","2024-09-07","2024-09-08","2024-09-09","2024-09-10","2024-09-11","2024-09-12","2024-09-13","2024-09-14","2024-09-15","2024-09-16","2024-09-17","2024-09-18","2024-09-19","2024-09-20","2024-09-21","2024-09-22","2024-09-23","2024-09-24","2024-09-25","2024-09-26","2024-09-27","2024-09-28","2024-09-29","2024-09-30",null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B32)=1,1,IF(WEEKDAY(B32)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B32,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B32),1)))","v":1},{"$f":"IF(WEEKDAY(C32)=1,1,IF(WEEKDAY(C32)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C32,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C32),1)))","v":1},1,1,1,1,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,null,null,{"$f":"COUNTIF(B33:AF33,2)","v":4},{"$f":"COUNTIF(B33:AF33,3)","v":3},{"$f":"COUNTIF(B33:AF33,4)","v":3},{"$f":"COUNTIF(B33:AF33,5)","v":3},{"$f":"COUNTIF(B33:AF33,6)","v":3}]
[{"$f":"DATE($A$6,10,1)","v":"2024-10-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6,10,B34)","v":"2024-10-01"},{"$f":"DATE($A$6,10,C34)","v":"2024-10-02"},"2024-10-03","2024-10-04","2024-10-05","2024-10-06","2024-10-07","2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12","2024-10-13","2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19","2024-10-20","2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26","2024-10-27","2024-10-28","2024-10-29","2024-10-30","2024-10-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B35)=1,1,IF(WEEKDAY(B35)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B35,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B35),1)))","v":3},{"$f":"IF(WEEKDAY(C35)=1,1,IF(WEEKDAY(C35)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C35,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C35),1)))","v":4},5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,null,{"$f":"COUNTIF(B36:AF36,2)","v":4},{"$f":"COUNTIF(B36:AF36,3)","v":5},{"$f":"COUNTIF(B36:AF36,4)","v":5},{"$f":"COUNTIF(B36:AF36,5)","v":5},{"$f":"COUNTIF(B36:AF36,6)","v":4}]
[{"$f":"DATE($A$6,11,1)","v":"2024-11-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,{"$f":"DATE($A$6,11,B37)","v":"2024-11-01"},{"$f":"DATE($A$6,11,C37)","v":"2024-11-02"},"2024-11-03","2024-11-04","2024-11-05","2024-11-06","2024-11-07","2024-11-08","2024-11-09","2024-11-10","2024-11-11","2024-11-12","2024-11-13","2024-11-14","2024-11-15","2024-11-16","2024-11-17","2024-11-18","2024-11-19","2024-11-20","2024-11-21","2024-11-22","2024-11-23","2024-11-24","2024-11-25","2024-11-26","2024-11-27","2024-11-28","2024-11-29","2024-11-30",null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B38)=1,1,IF(WEEKDAY(B38)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B38,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B38),1)))","v":1},{"$f":"IF(WEEKDAY(C38)=1,1,IF(WEEKDAY(C38)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C38,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C38),1)))","v":1},1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,null,null,{"$f":"COUNTIF(B39:AF39,2)","v":4},{"$f":"COUNTIF(B39:AF39,3)","v":4},{"$f":"COUNTIF(B39:AF39,4)","v":4},{"$f":"COUNTIF(B39:AF39,5)","v":4},{"$f":"COUNTIF(B39:AF39,6)","v":4}]
[{"$f":"DATE($A$6,12,1)","v":"2024-12-01"},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,{"$f":"DATE($A$6,12,B40)","v":"2024-12-01"},{"$f":"DATE($A$6,12,C40)","v":"2024-12-02"},"2024-12-03","2024-12-04","2024-12-05","2024-12-06","2024-12-07","2024-12-08","2024-12-09","2024-12-10","2024-12-11","2024-12-12","2024-12-13","2024-12-14","2024-12-15","2024-12-16","2024-12-17","2024-12-18","2024-12-19","2024-12-20","2024-12-21","2024-12-22","2024-12-23","2024-12-24","2024-12-25","2024-12-26","2024-12-27","2024-12-28","2024-12-29","2024-12-30","2024-12-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[{"$f":"Tabelle1!F2","v":2024},{"$f":"IF(WEEKDAY(B41)=1,1,IF(WEEKDAY(B41)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(B41,$A$45:$A$120,0)))=TRUE(),WEEKDAY(B41),1)))","v":1},{"$f":"IF(WEEKDAY(C41)=1,1,IF(WEEKDAY(C41)=7,1,IF(ISERROR(INDEX($A$45:$A$120,MATCH(C41,$A$45:$A$120,0)))=TRUE(),WEEKDAY(C41),1)))","v":2},3,4,5,6,1,1,2,3,4,5,6,1,1,2,3,4,5,6,1,1,2,1,1,1,1,1,1,1,1,null,{"$f":"COUNTIF(B42:AF42,2)","v":4},{"$f":"COUNTIF(B42:AF42,3)","v":3},{"$f":"COUNTIF(B42:AF42,4)","v":3},{"$f":"COUNTIF(B42:AF42,5)","v":3},{"$f":"COUNTIF(B42:AF42,6)","v":3}]
[{"$f":"A42+1","v":2025}]
[]
[{"$f":"IF(B45=\"ja\",DATE(A6+1,1,1))","v":"2025-01-01"},"ja","Neujahr"]
[{"$f":"IF(B46=\"ja\",DATE(A6+1,1,2))","v":"2025-01-02"},"ja","Weihnachtsferien"]
[{"$f":"IF(B47=\"ja\",DATE(A6+1,1,3))","v":"2025-01-03"},"ja","Weihnachtsferien"]
[{"$f":"IF(B48=\"ja\",DATE(A6+1,1,4))","v":"2025-01-04"},"ja","Weihnachtsferien"]
[{"$f":"IF(B49=\"ja\",DATE(A6+1,1,5))","v":"2025-01-05"},"ja","Weihnachtsferien"]
[{"$f":"IF(B50=\"ja\",DATE(A6+1,1,6))","v":"2025-01-06"},"ja","Heilig Drei Könige"]
[{"$nulls":11},1,{"$f":"AH9","v":3},{"$f":"AI9","v":4},4,4,4,null,null,9]
[{"$f":"IF(B52=\"ja\",A58-2,\"\")","v":""},"nein","Karfeitag",{"$nulls":8},2,{"$f":"AH12","v":4},{"$f":"AI12","v":4},4,4,4,null,null,10]
[{"$f":"$A$58-6","v":"2025-04-14"},"ja","Osterferien",{"$nulls":8},3,{"$f":"AH15","v":5},{"$f":"AI15","v":4},4,4,4,null,null,11]
[{"$f":"$A$58-5","v":"2025-04-15"},"ja","Osterferien",{"$nulls":8},4,{"$f":"AH18","v":1},{"$f":"AI18","v":2},3,2,2,null,null,12]
[{"$f":"$A$58-4","v":"2025-04-16"},"ja","Osterferien",{"$nulls":8},5,{"$f":"AH21","v":4},{"$f":"AI21","v":4},4,4,5,null,null,1]
[{"$f":"$A$58-3","v":"2025-04-17"},"ja","Osterferien",{"$nulls":8},6,{"$f":"AH24","v":4},{"$f":"AI24","v":4},4,3,4,null,null,2]
[{"$f":"$A$58-2","v":"2025-04-18"},"ja","Osterferien",{"$nulls":8},7,{"$f":"AH27","v":0},{"$f":"AI27","v":1},1,1,1,null,null,3]
[{"$f":"IF(B58=\"ja\",DATE(A43,3,1)+MOD((255-11*MOD(A43,19)-21),30)+21+(MOD((255-11*MOD(A43,19)-21),30)+21>48)+6-MOD(A43+INT(A43/4)+MOD((255-11*MOD(A43,19)-21),30)+21+(MOD((255-11*MOD(A43,19)-21),30)+21>48)+1,7),\"\")","v":"2025-04-20"},"ja","Ostersonntag",{"$nulls":8},8,{"$f":"AH30","v":3},{"$f":"AI30","v":3},3,3,3,null,null,4]
[{"$f":"IF(B59=\"ja\",A58+1,\"\")","v":"2025-04-21"},"ja","Ostermontag",{"$nulls":8},9,{"$f":"AH33","v":4},{"$f":"AI33","v":3},3,3,3,null,null,5]
[{"$f":"IF(B60=\"ja\",DATE(A6,5,1),\"\")","v":"2024-05-01"},"ja","Staatsfeiertag",{"$nulls":8},10,{"$f":"AH36","v":4},{"$f":"AI36","v":5},5,5,4,null,null,6]
[{"$f":"IF(B61=\"ja\",A58+39,\"\")","v":"2025-05-29"},"ja","Christi Himmelfahrt",{"$nulls":8},11,{"$f":"AH39","v":4},{"$f":"AI39","v":4},4,4,4]
[{"$f":"IF(B62=\"ja\",A58+49,\"\")","v":"2025-06-08"},"ja","Pfingstsonntag",{"$nulls":8},12,{"$f":"AH42","v":4},{"$f":"AI42","v":3},3,3,3]
[{"$f":"IF(B63=\"ja\",A58+50,\"\")","v":"2025-06-09"},"ja","Pfingstmontag"]
[{"$f":"IF(B64=\"ja\",A58+60,\"\")","v":"2025-06-19"},"ja","Fronleichnam",{"$nulls":8},{"$f":"IF(WEEKDAY(DATE(A6,7,7))=2,DATE(A6,7,7),IF(WEEKDAY(DATE(A6,7,7))=1,DATE(A6,7,8),DATE(A6,7,16)-WEEKDAY(DATE(A6,7,7))))","v":"2024-07-08"}]
[{"$f":"L65","v":"2025-07-07"},null,"Sommerferien",{"$nulls":8},{"$f":"IF(WEEKDAY(DATE(A43,7,7))=2,DATE(A43,7,7),IF(WEEKDAY(DATE(A43,7,7))=1,DATE(A43,7,8),DATE(A43,7,16)-WEEKDAY(DATE(A43,7,7))))","v":"2025-07-07"}]
[{"$f":"A65+1","v":"2025-07-08"},null,"Sommerferien"]
[{"$f":"A66+1","v":"2025-07-09"},null,"Sommerferien"]
["2025-07-10",null,"Sommerferien"]
[{"$f":"A68+1","v":"2025-07-11"},null,"Sommerferien",{"$nulls":8},{"$f":"Tabelle1!F4","v":9},{"$f":"SUMIF($L$51:$L$62,$L$69,M51:M62)","v":4},{"$f":"SUMIF($L$51:$L$62,$L$69,N51:N62)","v":3},3,3,3]
["2025-07-12",null,"Sommerferien",{"$nulls":9},{"$f":"AH27","v":0},{"$f":"AI27","v":1},1,1,1]
["2025-07-13",null,"Sommerferien"]
["2025-07-14",null,"Sommerferien"]
["2025-07-15",null,"Sommerferien"]
["2025-07-16",null,"Sommerferien"]
["2025-07-17",null,"Sommerferien"]
["2025-07-18",null,"Sommerferien"]
["2025-07-19",null,"Sommerferien"]
["2025-07-20",null,"Sommerferien"]
["2025-07-21",null,"Sommerferien"]
["2025-07-22",null,"Sommerferien"]
["2025-07-23",null,"Sommerferien"]
["2025-07-24",null,"Sommerferien"]
["2025-07-25",null,"Sommerferien"]
["2025-07-26",null,"Sommerferien"]
["2025-07-27",null,"Sommerferien"]
["2025-07-28",null,"Sommerferien"]
["2025-07-29",null,"Sommerferien"]
["2025-07-30",null,"Sommerferien"]
["2025-07-31",null,"Sommerferien"]
["2025-08-01",null,"Sommerferien"]
[{"$f":"IF(B91=\"ja\",$L$64+46,\"\")","v":"2024-08-23"},"ja","Sommerferien"]
[{"$f":"A91+1","v":"2024-08-24"},null,"Sommerferien"]
[{"$f":"A92+1","v":"2024-08-25"},null,"Sommerferien"]
["2024-08-26",null,"Sommerferien"]
["2024-08-27",null,"Sommerferien"]
["2024-08-28",null,"Sommerferien"]
["2024-08-29",null,"Sommerferien"]
["2024-08-30",null,"Sommerferien"]
["2024-08-31",null,"Sommerferien"]
["2024-09-01",null,"Sommerferien"]
["2024-09-02",null,"Sommerferien"]
["2024-09-03",null,"Sommerferien"]
["2024-09-04",null,"Sommerferien"]
["2024-09-05",null,"Sommerferien"]
["2024-09-06",null,"Sommerferien"]
[{"$f":"IF(B106=\"ja\",DATE(A6,9,24),\"\")","v":""},"nein","Ruberti"]
[{"$f":"IF(B107=\"ja\",DATE(A6,8,15),\"\")","v":"2024-08-15"},"ja","Mariä Himmelfahrt"]
[{"$f":"IF(B108=\"ja\",DATE(A6,10,26),\"\")","v":"2024-10-26"},"ja","Nationalfeiertag"]
[{"$f":"IF(B109=\"ja\",DATE(A6,11,1),\"\")","v":"2024-11-01"},"ja","Allerheiligen"]
[{"$f":"IF(B110=\"ja\",DATE(A6,11,2),\"\")","v":"2024-11-02"},"ja","Allerseelen"]
[{"$f":"IF(B111=\"ja\",DATE(A6,12,8),\"\")","v":"2024-12-08"},"ja","Mariä Empfängnis"]
[{"$f":"IF(B112=\"ja\",DATE(A6,12,25),\"\")","v":"2024-12-25"},"ja","Christtag"]
[{"$f":"IF(B113=\"ja\",DATE(A6,12,26),\"\")","v":"2024-12-26"},"ja","Stefanitag"]
[{"$f":"IF(B114=\"ja\",DATE($A$6,12,24),\"\")","v":"2024-12-24"},"ja","Heiliger Abend"]
[{"$f":"IF(B115=\"ja\",DATE($A$6,12,27),\"\")","v":"2024-12-27"},"ja","Weihnachtsferien"]
[{"$f":"IF(B116=\"ja\",DATE($A$6,12,28),\"\")","v":"2024-12-28"},"ja","Weihnachtsferien"]
[{"$f":"IF(B117=\"ja\",DATE($A$6,12,29),\"\")","v":"2024-12-29"},"ja","Weihnachtsferien"]
[{"$f":"IF(B118=\"ja\",DATE($A$6,12,30),\"\")","v":"2024-12-30"},"ja","Weihnachtsferien"]
[{"$f":"IF(B119=\"ja\",DATE($A$6,12,31),\"\")","v":"2024-12-31"},"ja","Weihnachtsferien"]