{"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":42,"n_cols":10,"rows_kept":42,"merged":[[1,1,1,4],[1,7,1,8],[3,1,3,3],[4,3,4,7],[5,1,5,6],[9,8,9,9],[11,8,11,9],[13,8,13,9],[15,8,15,9],[17,8,17,9],[19,8,19,9],[20,8,20,9],[24,1,24,2],[24,6,24,7],[25,6,25,7],[26,6,26,7],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[33,1,33,2],[33,3,33,4],[35,1,35,9],[36,1,36,9],[37,1,37,9],[38,1,38,9],[40,1,40,9],[41,1,41,3]]}
[]
[null,"Tarifinformation Hort ",{"$nulls":3},{"v":2024,"d":"2024 -"},{"$f":"F2+1","v":2025},"Sept. 24 - Juli 25"]
[]
[null,"1. Monat auswählen",{"$nulls":3},{"v":9,"d":"Monat   09"}]
[]
[null,"2. Die vereinbarte Betreuungszeit von - bis laut Betreuungsvertag eingeben \nFormat hh:mm"]
[]
[null,"3. Mittagessen x in der Spalte nach den Kosten entragen"]
[{"$nulls":9},".X↓"]
[null,null,"von","bis","Zeit regulär",null,"verlängerte\nÖffnungszeit","Kosten ","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"}},null,{"$f":"D11*24-C11*24-E11","v":0},{"$f":"E11*$D$30+G11*$D$31","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(J11=\"x\",$D$32,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Montag","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"}},null,{"$f":"D12*24-C12*24-E12","v":0},{"v":0,"d":"0.00 €"}]
[null,"Dienstag","00:00:00","00:00:00",{"$f":"IF(C13=0,0,IF(C13*24<7,IF(D13*24>17,10,D13*24-7),IF(D13*24>17,17-C13*24,D13*24-C13*24)))","v":{"v":0,"d":"0.00"}},null,{"$f":"D13*24-C13*24-E13","v":0},{"v":0,"d":"0.00 €"},{"$f":"IF(J13=\"x\",$D$32,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Dienstag","00:00:00","00:00:00",{"$f":"IF(C14=0,0,IF(C14*24<7,IF(D14*24>17,10,D14*24-7),IF(D14*24>17,17-C14*24,D14*24-C14*24)))","v":{"v":0,"d":"0.00"}},null,{"$f":"D14*24-C14*24-E14","v":0},{"v":0,"d":"0.00 €"}]
[null,"Mittwoch","00:00:00","00:00:00",{"v":0,"d":"0.00"},null,0,{"v":0,"d":"0.00 €"},{"$f":"IF(J15=\"x\",$D$32,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Mittwoch","00:00:00","00:00:00",{"v":0,"d":"0.00"},null,0,{"v":0,"d":"0.00 €"}]
[null,"Donnerstag","00:00:00","00:00:00",{"v":0,"d":"0.00"},null,0,{"v":0,"d":"0.00 €"},{"$f":"IF(J17=\"x\",$D$32,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Donnerstag","00:00:00","00:00:00",{"$f":"IF(C18=0,0,IF(C18*24<7,IF(D18*24>17,10,D18*24-7),IF(D18*24>17,17-C18*24,D18*24-C18*24)))","v":{"v":0,"d":"0.00"}},null,0,{"v":0,"d":"0.00 €"}]
[null,"Freitag","00:00:00","00:00:00",{"$f":"IF(C19=0,0,IF(C19*24<7,IF(D19*24>16,9,D19*24-7),IF(D19*24>16,16-C19*24,D19*24-C19*24)))","v":{"v":0,"d":"0.00"}},null,0,{"v":0,"d":"0.00 €"},{"$f":"IF(J19=\"x\",$D$32,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Freitag","00:00:00","00:00:00",{"$f":"IF(C20=0,0,IF(C20*24<7,IF(D20*24>16,10,D20*24-7),IF(D20*24>16,16-C20*24,D20*24-C20*24)))","v":{"v":0,"d":"0.00"}},null,0,{"v":0,"d":"0.00 €"}]
[{"$nulls":4},{"$f":"SUM(E11:E20)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(G11:G20)","v":0},{"$f":"SUM(H11:H20)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I11:I20)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Vereinbarte Betreuungszeit",{"$f":"E21+G21","v":{"v":0,"d":"0.00"}},"  Stunden "]
[]
[null,"Kostenbeitrag ",null,null,"Mittagessen ","Betreuungs-\nbeitrag","Elternbeitrag \ngesamt"]
[null,{"$f":"DATE(F2,F4,1)","v":"2024-09-01"},{"$f":"($H$11+$H$12)*Preise!M69+($H$13+$H$14)*Preise!N69+($H$15+$H$16)*Preise!O69+($H$17+$H$18)*Preise!P69+($H$19+$H$20)*Preise!Q69","v":{"v":0,"d":"0.00 €"}},null,{"$f":"$I$11*Preise!M69+$I$13*Preise!N69+$I$15*Preise!O69+$I$17*Preise!P69+$I$19*Preise!Q69","v":{"v":0,"d":"0.00 €"}},{"$f":"C26","v":{"v":0,"d":"0.00 €"}},{"$f":"F26+E26","v":{"v":0,"d":"0.00 €"}}]
[null,{"$f":"IF(MONTH(B26)=6,DATE(F2,7,1),\"\")","v":""},{"$f":"IF(B27=\"\",\"\",($H$11+$H$12)*Preise!M70+($H$13+$H$14)*Preise!N70+($H$15+$H$16)*Preise!O70+($H$17+$H$18)*Preise!P70+($H$19+$H$20)*Preise!Q70)","v":""},null,{"$f":"IF(B27=\"\",\"\",$I$11*Preise!M70+$I$13*Preise!N70+$I$15*Preise!O70+$I$17*Preise!P70+$I$19*Preise!Q70)","v":""},{"$f":"C27","v":""},{"$f":"IF(B27=\"\",\"\",F27+E27)","v":""}]
[]
[null,"Tarife "]
[null,"Stunden regulär",null,{"v":0.7,"d":"0.70 €"}]
[null,"Stunden verl. Öffnungszeit",null,{"v":1.4,"d":"1.40 €"}]
[null,"Mittagessen",null,{"v":3.5,"d":"3.50 €"}]
[]
[null,"Kostenersatz Land Salzburg",null,"kein Kostenersatz "]
[]
[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 Herbstferien inc. der damit in Verbindung stehende schulautonomen Tage, Weihnachts-, Oster-, Semester- 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":153,"n_cols":38,"rows_kept":153,"hidden":true,"merged":[[0,2,0,5],[1,2,1,5],[2,2,2,5],[3,2,3,5],[4,1,4,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],[119,2,119,8],[120,2,120,8],[121,2,121,8],[122,2,122,8],[123,2,123,8],[124,2,124,8],[125,2,125,8],[126,2,126,8],[127,2,127,8],[128,2,128,8],[129,2,129,8],[130,2,130,8],[131,2,131,8],[132,2,132,8],[133,2,133,8],[134,2,134,8],[135,2,135,8],[136,2,136,8],[137,2,137,8],[138,2,138,8],[139,2,139,8],[140,2,140,8],[141,2,141,8],[142,2,142,8],[143,2,143,8],[144,2,144,8],[145,2,145,8],[146,2,146,8],[147,2,147,8],[148,2,148,8],[149,2,149,8],[150,2,150,8],[151,2,151,8],[152,2,152,8]]}
["Stunden regulär"]
["Stunden verl. Öffnungszeit"]
["ESSEN"]
["Kostenersatz Land"]
[{"$f":"Tabelle1!F2","v":2024},"Kalender"]
[{"$f":"DATE($A$42,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$42,1,B6)","v":"2025-01-01"},{"$f":"DATE($A$42,1,C6)","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(B7)=1,1,IF(WEEKDAY(B7)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B7,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B7),1)))","v":1},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(B8:AF8,2)","v":3},{"$f":"COUNTIF(B8:AF8,3)","v":4},{"$f":"COUNTIF(B8:AF8,4)","v":4},{"$f":"COUNTIF(B8:AF8,5)","v":4},{"$f":"COUNTIF(B8:AF8,6)","v":4}]
[{"$f":"DATE($A$42,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$42,2,B9)","v":"2025-02-01"},{"$f":"DATE($A$42,2,C9)","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$42,2,AD9)","v":"2025-03-01"},null,null,"Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B10)=1,1,IF(WEEKDAY(B10)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B10,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B10),1)))","v":1},1,2,3,4,5,6,1,1,1,1,1,1,1,1,1,2,3,4,5,6,1,1,2,3,4,5,6,{"$f":"IF(MONTH(AD10)=3,1,IF(WEEKDAY(AD10)=1,1,IF(WEEKDAY(AD10)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(AD10,$A$45:$A$153,0)))=TRUE(),WEEKDAY(AD10),1))))","v":1},{"$nulls":3},{"$f":"COUNTIF(B11:AF11,2)","v":3},{"$f":"COUNTIF(B11:AF11,3)","v":3},{"$f":"COUNTIF(B11:AF11,4)","v":3},{"$f":"COUNTIF(B11:AF11,5)","v":3},{"$f":"COUNTIF(B11:AF11,6)","v":3}]
[{"$f":"DATE($A$42,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$42,3,B12)","v":"2025-03-01"},{"$f":"DATE($A$42,3,C12)","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(B13)=1,1,IF(WEEKDAY(B13)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B13,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B13),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,1,2,null,{"$f":"COUNTIF(B14:AF14,2)","v":5},{"$f":"COUNTIF(B14:AF14,3)","v":4},{"$f":"COUNTIF(B14:AF14,4)","v":4},{"$f":"COUNTIF(B14:AF14,5)","v":4},{"$f":"COUNTIF(B14:AF14,6)","v":4}]
[{"$f":"DATE($A$42,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$42,4,B15)","v":"2025-04-01"},{"$f":"DATE($A$42,4,C15)","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(B16)=1,1,IF(WEEKDAY(B16)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B16,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B16),1)))","v":3},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(B17:AF17,2)","v":2},{"$f":"COUNTIF(B17:AF17,3)","v":4},{"$f":"COUNTIF(B17:AF17,4)","v":4},{"$f":"COUNTIF(B17:AF17,5)","v":3},{"$f":"COUNTIF(B17:AF17,6)","v":3}]
[{"$f":"DATE($A$42,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$542,5,B18)","v":"1900-05-01"},{"$f":"DATE($A$542,5,C18)","v":"1900-05-02"},"1900-05-03","1900-05-04","1900-05-05","1900-05-06","1900-05-07","1900-05-08","1900-05-09","1900-05-10","1900-05-11","1900-05-12","1900-05-13","1900-05-14","1900-05-15","1900-05-16","1900-05-17","1900-05-18","1900-05-19","1900-05-20","1900-05-21","1900-05-22","1900-05-23","1900-05-24","1900-05-25","1900-05-26","1900-05-27","1900-05-28","1900-05-29","1900-05-30","1900-05-31","Summe","Montag","Dienstag","Mittwoch","Donnerstag","Freitag"]
[null,{"$f":"IF(WEEKDAY(B19)=1,1,IF(WEEKDAY(B19)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B19,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B19),1)))","v":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,3,4,5,null,{"$f":"COUNTIF(B20:AF20,2)","v":4},{"$f":"COUNTIF(B20:AF20,3)","v":5},{"$f":"COUNTIF(B20:AF20,4)","v":5},{"$f":"COUNTIF(B20:AF20,5)","v":5},{"$f":"COUNTIF(B20:AF20,6)","v":4}]
[{"$f":"DATE($A$42,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$42,6,B21)","v":"2025-06-01"},{"$f":"DATE($A$42,6,C21)","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(B22)=1,1,IF(WEEKDAY(B22)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B22,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B22),1)))","v":1},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(B23:AF23,2)","v":4},{"$f":"COUNTIF(B23:AF23,3)","v":4},{"$f":"COUNTIF(B23:AF23,4)","v":4},{"$f":"COUNTIF(B23:AF23,5)","v":3},{"$f":"COUNTIF(B23:AF23,6)","v":4}]
[{"$f":"DATE($A$42,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$42,7,B24)","v":"2025-07-01"},{"$f":"DATE($A$42,7,C24)","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(B25)=1,1,IF(WEEKDAY(B25)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B25,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B25),1)))","v":3},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(B26:AF26,2)","v":0},{"$f":"COUNTIF(B26:AF26,3)","v":1},{"$f":"COUNTIF(B26:AF26,4)","v":1},{"$f":"COUNTIF(B26:AF26,5)","v":1},{"$f":"COUNTIF(B26:AF26,6)","v":1}]
[{"$f":"DATE($A$5,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$5,8,B27)","v":"2024-08-01"},{"$f":"DATE($A$5,8,C27)","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(B28)=1,1,IF(WEEKDAY(B28)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B28,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B28),1)))","v":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,1,1,null,{"$f":"COUNTIF(B29:AF29,2)","v":0},{"$f":"COUNTIF(B29:AF29,3)","v":0},{"$f":"COUNTIF(B29:AF29,4)","v":0},{"$f":"COUNTIF(B29:AF29,5)","v":1},{"$f":"COUNTIF(B29:AF29,6)","v":1}]
[{"$f":"DATE($A$5,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$5,9,B30)","v":"2024-09-01"},{"$f":"DATE($A$5,9,C30)","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(B31)=1,1,IF(WEEKDAY(B31)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B31,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B31),1)))","v":1},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(B32:AF32,2)","v":4},{"$f":"COUNTIF(B32:AF32,3)","v":3},{"$f":"COUNTIF(B32:AF32,4)","v":3},{"$f":"COUNTIF(B32:AF32,5)","v":3},{"$f":"COUNTIF(B32:AF32,6)","v":3}]
[{"$f":"DATE($A$5,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$5,10,B33)","v":"2024-10-01"},{"$f":"DATE($A$5,10,C33)","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(B34)=1,1,IF(WEEKDAY(B34)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B34,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B34),1)))","v":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,1,1,1,1,null,{"$f":"COUNTIF(B35:AF35,2)","v":3},{"$f":"COUNTIF(B35:AF35,3)","v":4},{"$f":"COUNTIF(B35:AF35,4)","v":4},{"$f":"COUNTIF(B35:AF35,5)","v":4},{"$f":"COUNTIF(B35:AF35,6)","v":4}]
[{"$f":"DATE($A$5,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$5,11,B36)","v":"2024-11-01"},{"$f":"DATE($A$5,11,C36)","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(B37)=1,1,IF(WEEKDAY(B37)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B37,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B37),1)))","v":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,3,4,5,6,1,null,null,{"$f":"COUNTIF(B38:AF38,2)","v":4},{"$f":"COUNTIF(B38:AF38,3)","v":4},{"$f":"COUNTIF(B38:AF38,4)","v":4},{"$f":"COUNTIF(B38:AF38,5)","v":4},{"$f":"COUNTIF(B38:AF38,6)","v":4}]
[{"$f":"DATE($A$5,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$5,12,B39)","v":"2024-12-01"},{"$f":"DATE($A$5,12,C39)","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(B40)=1,1,IF(WEEKDAY(B40)=7,1,IF(ISERROR(INDEX($A$45:$A$153,MATCH(B40,$A$45:$A$153,0)))=TRUE(),WEEKDAY(B40),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,1,1,1,1,1,1,1,1,null,{"$f":"COUNTIF(B41:AF41,2)","v":4},{"$f":"COUNTIF(B41:AF41,3)","v":3},{"$f":"COUNTIF(B41:AF41,4)","v":3},{"$f":"COUNTIF(B41:AF41,5)","v":3},{"$f":"COUNTIF(B41:AF41,6)","v":3}]
[{"$f":"A41+1","v":2025}]
[]
[]
[null,null,"Sondertage"]
[null,null,"Sondertage"]
[null,null,"Sondertage"]
[null,null,"Sondertage"]
[null,null,"Sondertage"]
[{"$f":"IF(B50=\"ja\",DATE(A42,1,1),\"\")","v":"2025-01-01"},"ja","Neujahr"]
[{"$f":"IF(B51=\"ja\",DATE(A42,1,2),\"\")","v":"2025-01-02"},"ja","Weihnachtsferien",{"$nulls":8},1,{"$f":"AH8","v":3},{"$f":"AI8","v":4},{"$f":"AJ8","v":4},{"$f":"AK8","v":4},{"$f":"AL8","v":4},null,null,9]
[{"$f":"IF(B52=\"ja\",DATE(A42,1,3),\"\")","v":"2025-01-03"},"ja","Weihnachtsferien",{"$nulls":8},2,{"$f":"AH11","v":3},{"$f":"AI11","v":3},{"$f":"AJ11","v":3},{"$f":"AK11","v":3},{"$f":"AL11","v":3},null,null,10]
[{"$f":"IF(B53=\"ja\",DATE(A42,1,4),\"\")","v":"2025-01-04"},"ja","Weihnachtsferien",{"$nulls":8},3,{"$f":"AH14","v":5},{"$f":"AI14","v":4},{"$f":"AJ14","v":4},{"$f":"AK14","v":4},{"$f":"AL14","v":4},null,null,11]
[{"$f":"IF(B54=\"ja\",DATE(A42,1,5),\"\")","v":"2025-01-05"},"ja","Weihnachtsferien",{"$nulls":8},4,{"$f":"AH17","v":2},{"$f":"AI17","v":4},{"$f":"AJ17","v":4},{"$f":"AK17","v":3},{"$f":"AL17","v":3},null,null,12]
[{"$f":"IF(B55=\"ja\",DATE(A42,1,6),\"\")","v":"2025-01-06"},"ja","Heilig Drei Könige",{"$nulls":8},5,{"$f":"AH20","v":4},{"$f":"AI20","v":5},{"$f":"AJ20","v":5},{"$f":"AK20","v":5},{"$f":"AL20","v":4},null,null,1]
[{"$f":"IF(B56=\"ja\",IF(WEEKDAY(DATE(A42,2,8))=2,DATE(A42,2,8),IF(WEEKDAY(DATE(A42,2,8))=1,DATE(A42,2,9),DATE(A42,2,17)-WEEKDAY(DATE(A42,2,8)))),\"\")","v":"2025-02-10"},"ja","Semesterferien",{"$nulls":8},6,{"$f":"AH23","v":4},{"$f":"AI23","v":4},{"$f":"AJ23","v":4},{"$f":"AK23","v":3},{"$f":"AL23","v":4},null,null,2]
[{"$f":"IF(A56=\"\",\"\",A56+1)","v":"2025-02-11"},null,"Semesterferien",{"$nulls":8},7,{"$f":"AH26","v":0},{"$f":"AI26","v":1},{"$f":"AJ26","v":1},{"$f":"AK26","v":1},{"$f":"AL26","v":1},null,null,3]
[{"$f":"IF(A57=\"\",\"\",A57+1)","v":"2025-02-12"},null,"Semesterferien",{"$nulls":8},8,{"$f":"AH29","v":0},{"$f":"AI29","v":0},{"$f":"AJ29","v":0},{"$f":"AK29","v":1},{"$f":"AL29","v":1},null,null,4]
["2025-02-13",null,"Semesterferien",{"$nulls":8},9,{"$f":"AH32","v":4},{"$f":"AI32","v":3},{"$f":"AJ32","v":3},{"$f":"AK32","v":3},{"$f":"AL32","v":3},null,null,5]
["2025-02-14",null,"Semesterferien",{"$nulls":8},10,{"$f":"AH35","v":3},{"$f":"AI35","v":4},{"$f":"AJ35","v":4},{"$f":"AK35","v":4},{"$f":"AL35","v":4},null,null,6]
[{"$f":"IF(B61=\"ja\",A67-2,\"\")","v":""},"nein","Karfeitag",{"$nulls":8},11,{"$f":"AH38","v":4},{"$f":"AI38","v":4},{"$f":"AJ38","v":4},{"$f":"AK38","v":4},{"$f":"AL38","v":4}]
[{"$f":"IF(B62=\"ja\",$A$67-6,\"\")","v":"2025-04-14"},"ja","Osterferien",{"$nulls":8},12,{"$f":"AH41","v":4},{"$f":"AI41","v":3},{"$f":"AJ41","v":3},{"$f":"AK41","v":3},{"$f":"AL41","v":3}]
[{"$f":"IF(B63=\"ja\",$A$67-5,\"\")","v":"2025-04-15"},"ja","Osterferien"]
[{"$f":"IF(B64=\"ja\",$A$67-4,\"\")","v":"2025-04-16"},"ja","Osterferien",{"$nulls":8},{"$f":"IF(WEEKDAY(DATE(A5,7,7))=2,DATE(A5,7,7),IF(WEEKDAY(DATE(A5,7,7))=1,DATE(A5,7,8),DATE(A5,7,16)-WEEKDAY(DATE(A5,7,7))))","v":"2024-07-08"}]
[{"$f":"IF(B65=\"ja\",$A$67-3,\"\")","v":"2025-04-17"},"ja","Osterferien",{"$nulls":8},{"$f":"IF(WEEKDAY(DATE(A42,7,7))=2,DATE(A42,7,7),IF(WEEKDAY(DATE(A42,7,7))=1,DATE(A42,7,8),DATE(A42,7,16)-WEEKDAY(DATE(A42,7,7))))","v":"2025-07-07"}]
[{"$f":"IF(B66=\"ja\",$A$67-2,\"\")","v":"2025-04-18"},"ja","Osterferien"]
[{"$f":"IF(B67=\"ja\",DATE(A42,3,1)+MOD((255-11*MOD(A42,19)-21),30)+21+(MOD((255-11*MOD(A42,19)-21),30)+21>48)+6-MOD(A42+INT(A42/4)+MOD((255-11*MOD(A42,19)-21),30)+21+(MOD((255-11*MOD(A42,19)-21),30)+21>48)+1,7),\"\")","v":"2025-04-20"},"ja","Ostersonntag"]
[{"$f":"IF(B68=\"ja\",A67+1,\"\")","v":"2025-04-21"},"ja","Ostermontag"]
[{"$f":"IF(B69=\"ja\",DATE(A42,5,1),\"\")","v":"2025-05-01"},"ja","Staatsfeiertag",{"$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]
[{"$f":"IF(B70=\"ja\",A67+39,\"\")","v":"2025-05-29"},"ja","Christi Himmelfahrt",{"$nulls":9},{"$f":"AH26","v":0},{"$f":"AI26","v":1},1,1,1]
[{"$f":"IF(B71=\"ja\",A67+49,\"\")","v":"2025-06-08"},"ja","Pfingstsonntag"]
[{"$f":"IF(B72=\"ja\",A67+50,\"\")","v":"2025-06-09"},"ja","Pfingstmontag"]
[{"$f":"IF(B73=\"ja\",A67+60,\"\")","v":"2025-06-19"},"ja","Fronleichnam"]
[{"$f":"IF(B74=\"ja\",L65,\"\")","v":"2025-07-07"},"ja","Sommerferien"]
[{"$f":"IF($A$74=\"\",\"\",A74+1)","v":"2025-07-08"},null,"Sommerferien"]
[{"$f":"IF($A$74=\"\",\"\",A75+1)","v":"2025-07-09"},null,"Sommerferien"]
["2025-07-10",null,"Sommerferien"]
["2025-07-11",null,"Sommerferien",{"$nulls":11},100,134,{"$f":"P78-O78","v":34}]
["2025-07-12",null,"Sommerferien",{"$nulls":11},90,104,{"$f":"P79-O79","v":14}]
["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($A$74=\"\",\"\",$L$64+26)","v":"2024-08-03"},null,"Sommerferien"]
["2024-08-04",null,"Sommerferien"]
["2024-08-05",null,"Sommerferien"]
["2024-08-06",null,"Sommerferien"]
["2024-08-07",null,"Sommerferien"]
["2024-08-08",null,"Sommerferien"]
["2024-08-09",null,"Sommerferien"]
["2024-08-10",null,"Sommerferien"]
["2024-08-11",null,"Sommerferien"]
["2024-08-12",null,"Sommerferien"]
["2024-08-13",null,"Sommerferien"]
["2024-08-14",null,"Sommerferien"]
["2024-08-15",null,"Sommerferien"]
["2024-08-16",null,"Sommerferien"]
["2024-08-17",null,"Sommerferien"]
["2024-08-18",null,"Sommerferien"]
["2024-08-19",null,"Sommerferien"]
["2024-08-20",null,"Sommerferien"]
["2024-08-21",null,"Sommerferien"]
["2024-08-22",null,"Sommerferien"]
["2024-08-23",null,"Sommerferien"]
["2024-08-24",null,"Sommerferien"]
["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(B135=\"ja\",DATE(A5,9,24),\"\")","v":""},"nein","Ruberti"]
[{"$f":"IF(B136=\"ja\",DATE(A5,8,15),\"\")","v":"2024-08-15"},"ja","Mariä Himmelfahrt"]
[{"$f":"IF(B137=\"ja\",DATE(A5,10,26),\"\")","v":"2024-10-26"},"ja","Nationalfeiertag"]
[{"$f":"IF(B138=\"ja\",DATE(A5,10,27),\"\")","v":"2024-10-27"},"ja","Herbstferien"]
[{"$f":"IF(B139=\"ja\",DATE(A5,10,28),\"\")","v":"2024-10-28"},"ja","Herbstferien"]
[{"$f":"IF(B140=\"ja\",DATE(A5,10,29),\"\")","v":"2024-10-29"},"ja","Herbstferien"]
[{"$f":"IF(B141=\"ja\",DATE(A5,10,30),\"\")","v":"2024-10-30"},"ja","Herbstferien"]
[{"$f":"IF(B142=\"ja\",DATE(A5,10,31),\"\")","v":"2024-10-31"},"ja","Herbstferien"]
[{"$f":"IF(B143=\"ja\",DATE(A5,11,1),\"\")","v":"2024-11-01"},"ja","Allerheiligen"]
[{"$f":"IF(B144=\"ja\",DATE(A5,11,2),\"\")","v":"2024-11-02"},"ja","Allerseelen"]
[{"$f":"IF(B145=\"ja\",DATE(A5,12,8),\"\")","v":"2024-12-08"},"ja","Mariä Empfängnis"]
[{"$f":"IF(B146=\"ja\",DATE(A5,12,25),\"\")","v":"2024-12-25"},"ja","Christtag"]
[{"$f":"IF(B147=\"ja\",DATE(A5,12,26),\"\")","v":"2024-12-26"},"ja","Stefanitag"]
[{"$f":"IF(B148=\"ja\",DATE($A$5,12,24),\"\")","v":"2024-12-24"},"ja","Heiliger Abend"]
[{"$f":"IF(B149=\"ja\",DATE($A$5,12,27),\"\")","v":"2024-12-27"},"ja","Weihnachtsferien"]
[{"$f":"IF(B150=\"ja\",DATE($A$5,12,28),\"\")","v":"2024-12-28"},"ja","Weihnachtsferien"]
[{"$f":"IF(B151=\"ja\",DATE($A$5,12,29),\"\")","v":"2024-12-29"},"ja","Weihnachtsferien"]
[{"$f":"IF(B152=\"ja\",DATE($A$5,12,30),\"\")","v":"2024-12-30"},"ja","Weihnachtsferien"]
[{"$f":"IF(B153=\"ja\",DATE($A$5,12,31),\"\")","v":"2024-12-31"},"ja","Weihnachtsferien"]