{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Datenblatt pro Kind","Parameter"],"not_rendered":{"images":2,"defined_names":2,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Datenblatt pro Kind","index":0,"n_rows":176,"n_cols":16,"rows_kept":176,"merged":[[14,7,14,9],[18,5,18,9],[28,0,30,0],[35,8,35,9],[37,8,37,9],[39,8,39,9],[46,5,47,9],[53,5,53,9],[148,6,148,9],[150,6,150,9],[154,5,155,9],[158,5,159,9],[164,0,164,1],[167,0,167,1]]}
["Betreuungsgutscheine - Provisorischer Rechner "]
[]
["Angaben Erziehungsberechtigte"]
[]
["Name der 1. Person",null,null,"Name der 2. Person"]
[]
["Wohnsitz in Münchenstein","bitte wählen",null,"Wohnsitz in Münchenstein",null,"bitte wählen"]
[]
["Adresse",null,null,"2. Person Kindvater/Mutter"]
[]
["PLZ / Ort"]
[]
["Antrag vollständig",null,null,"Ja",null,"zurückgeschickt am:"]
[]
[{"$nulls":3},"nein",null,"Grund:"]
[]
["Angaben zum Kind"]
[]
["Name des Kindes",null,null,"Betreuungseinrichtung"]
[]
["Geburtsdatum",null,null,"Betreuungsbeginn"]
[]
[]
["Erwerbspensum"]
[]
[null,"1. Person",null,"2. Person",null,"Total Pensum",null,"anspruchsberechtigtes Pensum"]
[]
["Alleinerziehend",{"$nulls":4},{"$f":"B28","v":{"v":0,"d":"0%"}},null,{"$f":"F28","v":{"v":0,"d":"0%"}}]
["zwei Erziehungsberechtigte / feste Lebensgemeinschaft"]
[{"$nulls":5},{"$f":"B30+D30","v":{"v":0,"d":"0%"}},null,{"$f":"IF(F30=0%,0,F30-100%)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":7},{"$f":"H28+H30","v":{"v":0,"d":"0%"}}]
[]
["massgebendes Einkommen"]
[]
["Steuerbares Einkommen (Ziff 790)",null,null,0,null,"Einkäufe 2. Säule 2 (Ziff 600+605)",null,null,0]
[]
["Steuerbares Vermögen (Ziff 899)",null,null,0,null,"Einkäufe 3. Säule (Ziff 610+615)",null,null,0]
[]
["Anrechenbarer Vermögensanteil",null,null,{"$f":"IF(D41<0,\"0\",D41)","v":"0"},null,"Liegenschaftsunterhalt (Ziff 415+420+460+470)",null,null,0]
[{"$nulls":3},{"$f":"(D38-100000)/10","v":{"v":-10000,"d":"CHF -10,000"}}]
[]
["Kinderabzug (ab dem zweiten Kind CHF 6'500 pro Kind)",null,null,0]
[]
["Massgebendes Einkommen Betreuungsgutscheine",null,null,{"$f":"D36+D40+I36+I38+I40-D43","v":0}]
[]
["Wird die Familie quellenbesteuert?",null,null,"bitte wählen",null,{"$f":"IF(D47=\"Ja\",\"Hinweis: Wenn quellenbesteuert, Bruttoeinkommen minus 25 % bei Feld \nSteuerbares Einkommen eintragen\",\"\")","v":""}]
[]
[]
["weitere finanzielle Angaben"]
[]
["finanzielle Beteiliung durch Arbeitgeber monatlich:",null,null,0]
[]
["Bezieht die Familie wirtschaftliche Sozialhilfe?",null,null,"bitte wählen",null,{"$f":"IF(D54=\"Ja\",\"Hinweis: Die Auszahlung erfolgt eventuell via Sozialamt\",\"\")","v":""}]
[]
["Betreuungsform"]
[]
["Alter des Kindes","bitte wählen"]
[]
["Kindertagesstätte"]
[{"$nulls":15}," "]
[null,"Vollkostentarif pro Tag",null,"Anzahl betreute Tage\npro Woche",null,"Betreuungsgutschein pro Tag",null,"Kostenbeteiligung Eltern pro Tag",null,"Betreuungsgutschein pro Monat",{"$nulls":3}," "]
[]
["Kinder unter 18 Monaten",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B66<0,0,B66)","v":0},null,{"$f":"IF(ISBLANK(D64),\"\",IF(B64-F66<=Parameter!D55,Parameter!D55,B64-F66))","v":{"v":20,"d":"CHF 20.00"}},null,{"$f":"IF(ISBLANK(D64),\"\",ROUND(J66/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D64/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Die Kitabetreuung wird an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D64),\"\",IF(OR(F66>=B64,F66>B64-H64),B64-H64,F66))","v":{"v":-20,"d":"CHF -20.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D64),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,4,1))","v":{"v":105,"d":"CHF 105.00"}},{"$nulls":3},{"$f":"IF(D64/5*100%<=$H$32,F64*(D64/5*100)*240/(100*12),($H$32*F64*240)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J64=\"\",0,J64)","v":0}]
[null,{"$f":"B64*240/12/5*D64","v":0},null," ",{"$nulls":3},{"$f":"Parameter!D55*240/12/5*D64","v":0},null,{"$f":"B68-H68-J67","v":0}]
[]
["Kinder über 18 Monaten",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B72<0,0,B72)","v":0},null,{"$f":"IF(ISBLANK(D70),\"\",IF(B70-F72<=Parameter!E55,Parameter!E55,B70-F72))","v":{"v":20,"d":"CHF 20.00"}},null,{"$f":"IF(ISBLANK(D70),\"\",ROUND(J72/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D70/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Die Kitabetreuung wird an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D70),\"\",IF(OR(F72>=B70,F72>B70-H70),B70-H70,F72))","v":{"v":-20,"d":"CHF -20.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D70),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,5,1))","v":{"v":95,"d":"CHF 95.00"}},{"$nulls":3},{"$f":"IF(D70/5*100%<=$H$32,F70*(D70/5*100)*240/(100*12),($H$32*F70*240)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J70=\"\",0,J70)","v":0}]
[null,{"$f":"B70*240/12/5*D70","v":0},{"$nulls":5},{"$f":"Parameter!E55*240/12/5*D70","v":0},null,{"$f":"B74-H74-J73","v":0}]
[]
["Tagesfamilien"]
[]
[null,"Vollkostentarif pro Stunde",null,"Anzahl betreute Stunden pro Woche",null,"Betreuungsgutschein pro Stunde",null,"Kostenbeteiligung Eltern pro Stunde",null,"Betreuungsgutschein pro Monat"]
[]
["Kinder unter 18 Monaten",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B82<0,0,B82)","v":0},null,{"$f":"IF(ISBLANK(D80),\"\",IF(B80-F82<=Parameter!F54,Parameter!F54,B80-F82))","v":{"v":2,"d":"CHF 2.00"}},null,{"$f":"IF(ISBLANK(D80),\"\",ROUND(J82/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D80*4*100%/200>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Es werden maximal \"&($H$32*50)&\" Stunden pro Woche unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D80),\"\",IF(OR(F82>=B80,F82>B80-H80),B80-H80,F82))","v":{"v":-2,"d":"CHF -2.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D80),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,6,1))","v":{"v":10.5,"d":"CHF 10.50"}},{"$nulls":3},{"$f":"IF(D80*100%/50<=$H$32,F80*D80*48/12,(F80*($H$32*50/100%)*48)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J80=\"\",0,J80)","v":0},null,null," "]
[null,{"$f":"B80*240/12/5*D80","v":0},null," ",{"$nulls":3},{"$f":"Parameter!F54*240/12/5*D80","v":0},null,{"$f":"B84-H84-J83","v":0}]
[]
["Kinder über 18 Monaten",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B88<0,0,B88)","v":0},null,{"$f":"IF(ISBLANK(D86),\"\",IF(B86-F88<=Parameter!G54,Parameter!G54,B86-F88))","v":{"v":2,"d":"CHF 2.00"}},null,{"$f":"IF(ISBLANK(D86),\"\",ROUND(J88/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D86*4*100%/200>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Es werden maximal \"&($H$32*50)&\" Stunden pro Woche unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D86),\"\",IF(OR(F88>=B86,F88>B86-H86),B86-H86,F88))","v":{"v":-2,"d":"CHF -2.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D86),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,7,1))","v":{"v":9.5,"d":"CHF 9.50"}},{"$nulls":3},{"$f":"IF(D86*100%/50<=$H$32,F86*D86*48/12,(F86*($H$32*50/100%)*48)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J86=\"\",0,J86)","v":0},null,null," "]
[null,{"$f":"B86*240/12/5*D86","v":0},null," ",{"$nulls":3},{"$f":"Parameter!F61*240/12/5*D86","v":0},null,{"$f":"B90-H90-J89","v":0}]
[]
[]
["Tagesstrukturen"]
[]
[null,"Vollkostentarif pro Modul",null,"Anzahl besuchte Module pro Woche",null,"Betreuungsgutschein pro Modul",null,"Kostenbeteiligung Eltern pro Modul",null,"Betreuungsgutschein pro Monat",null,null," "]
[]
["Frühmorgen",{"$nulls":4},{"$f":"IF(B99<0,0,B99)","v":""},null,{"$f":"IF(ISBLANK(D97),\"\",IF(B97-F99<=Parameter!H55,Parameter!H55,B97-F99))","v":""},null,{"$f":"IF(ISBLANK(D97),\"\",ROUND(J99/5,2)*5)","v":""}]
[{"$nulls":9},{"$f":"IF(D97/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Das Frühmorgenmodul wird an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D97),\"\",IF(OR(F99>=B97,F99>B97-H97),B97-H97,F99))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D97),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,8,1))","v":""},{"$nulls":3},{"$f":"IF(D97/5*100%<=$H$32,F97*(D97/5*100)*190/(100*12),($H$32*F97*190)/12)","v":{"$error":"#VALUE!"}}," "]
[{"$nulls":9},{"$f":"IF(J97=\"\",0,J97)","v":0}]
[null,{"$f":"B97*190/12/5*D97","v":0},{"$nulls":5},{"$f":"Parameter!H55*190/12/5*D97","v":0},null,{"$f":"B101-H101-J100","v":0}]
[]
["Mittagstisch (ohne Essen)",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B105<0,0,B105)","v":0},null,{"$f":"IF(ISBLANK(D103),\"\",IF(B103-F105<=Parameter!I55,Parameter!I55,B103-F105))","v":{"v":3,"d":"CHF 3.00"}},null,{"$f":"IF(ISBLANK(D103),\"\",ROUND(J105/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D103/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Das Mittagsmodul wird an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D103),\"\",IF(OR(F105>=B103,F105>B103-H103),B103-H103,F105))","v":{"v":-3,"d":"CHF -3.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D103),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,9,1))","v":{"v":14.25,"d":"CHF 14.25"}},{"$nulls":3},{"$f":"IF(D103/5*100%<=$H$32,F103*(D103/5*100)*190/(100*12),($H$32*F103*190)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J103=\"\",0,J103)","v":0}]
[null,{"$f":"B103*190/12/5*D103","v":0},{"$nulls":5},{"$f":"Parameter!I55*190/12/5*D103","v":0},null,{"$f":"B107-H107-J106","v":0}]
[]
["Nachmittag I 13.30 bis 15.30",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B111<0,0,B111)","v":0},null,{"$f":"IF(ISBLANK(D109),\"\",IF(B109-F111<=Parameter!J55,Parameter!J55,B109-F111))","v":{"v":4,"d":"CHF 4.00"}},null,{"$f":"IF(ISBLANK(D109),\"\",ROUND(J111/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D109/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Es werden Nachmittagsmodule an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D109),\"\",IF(OR(F111>=B109,F111>B109-H109),B109-H109,F111))","v":{"v":-4,"d":"CHF -4.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D109),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,10,1))","v":{"v":19,"d":"CHF 19.00"}},{"$nulls":3},{"$f":"IF(D109/5*100%<=$H$32,F109*(D109/5*100)*190/(100*12),($H$32*F109*190)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J109=\"\",0,J109)","v":0}]
[null,{"$f":"B109*190/12/5*D109","v":0},{"$nulls":5},{"$f":"Parameter!J55*190/12/5*D109","v":0},null,{"$f":"B113-H113-J112","v":0}]
[]
["Nachmittag II 15.30 bis 18.00",0,null,{"v":0,"d":"0.0"},null,{"$f":"IF(B117<0,0,B117)","v":0},null,{"$f":"IF(ISBLANK(D115),\"\",IF(B115-F117<=Parameter!K55,Parameter!K55,B115-F117))","v":{"v":5,"d":"CHF 5.00"}},null,{"$f":"IF(ISBLANK(D115),\"\",ROUND(J117/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D115/5*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Es werden Nachmittagsmodule an maximal \"&($H$32*5)&\" Wochentag/en unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D115),\"\",IF(OR(F117>=B115,F117>B115-H115),B115-H115,F117))","v":{"v":-5,"d":"CHF -5.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D115),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,11,1))","v":{"v":23.75,"d":"CHF 23.75"}},{"$nulls":3},{"$f":"IF(D115/5*100%<=$H$32,F115*(D115/5*100)*190/(100*12),($H$32*F115*190)/12)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J115=\"\",0,J115)","v":0}]
[null,{"$f":"B115*190/12/5*D115","v":0},{"$nulls":5},{"$f":"Parameter!K55*190/12/5*D115","v":0},null,{"$f":"B119-H119-J118","v":0}]
[]
["Ferienbetreuung",null,null,{"$f":"D109+D115","v":{"v":0,"d":"0.0"}}]
[]
[null,"Vollkostentarif pro Halbtag",null,"Anzahl betreute Tage pro Jahr",null,"Betreuungsgutschein pro Tag",null,"Kostenbeteiligung Eltern pro Tag",null,"Betreuungsgutscheine pro Jahr"]
[]
[null,0,null,0,null,{"$f":"IF(B127<0,0,B127)","v":0},null,{"$f":"IF(ISBLANK(D125),\"\",IF(B125-F127<Parameter!L55,Parameter!L55,B125-F127))","v":{"v":8,"d":"CHF 8.00"}},null,{"$f":"IF(ISBLANK(D125),\"\",ROUND(J127/5,2)*5)","v":0}]
[{"$nulls":9},{"$f":"IF(D125/30*100%>$H$32,\"Hinweis: Das maximal unterstützte Pensum liegt bei \"&($H$32*100)&\"%. Die Ferienbetreuung wird an maximal \"&($H$32*30)&\" Tagen pro Jahr unterstützt.\",\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(D125),\"\",IF(OR(F127>=B125,F127>B125-H125),B125-H125,F127))","v":{"v":-8,"d":"CHF -8.00"}},{"$nulls":3},{"$f":"IF(ISBLANK(D125),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,12,1))","v":{"v":38,"d":"CHF 38.00"}},{"$nulls":3},{"$f":"IF(D125/30*100%<=$H$32,F125*D125,$H$32*30*F125)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":9},{"$f":"IF(J125=\"\",0,J125)","v":0}]
[null,{"$f":"B125*D125","v":0},{"$nulls":5},{"$f":"Parameter!L55*D125","v":0},null,{"$f":"B129-H129-J128","v":0}]
[]
[]
["Spielgruppen"]
[]
[null,"Vollkostentarif pro Modul",null,"Anzahl Halbtage\npro Woche",null,"Betreuungsgutschein pro Modul",null,"Kostenbeteiligung Eltern pro Modul",null,"Betreuungsgutscheine pro Quartal"]
[]
[null,0,null,0,null,{"$f":"IF(F138=\"\",\"\",F138)","v":""},null,{"$f":"IF(ISBLANK(D136),\"\",IF(B136-(F142*B140)<Parameter!M55,Parameter!M55,B136-(F142*B140)))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISBLANK(D136),\"\",ROUND(J138/5,2)*5)","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":5},{"$f":"IF(B142<0,0,B142)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(D140),\"\",(F136*D136*D140/4))","v":""}]
[null,"Dauer Spielgruppe in Stunden pro Modul",null,"Anzahl Wochen pro Jahr"]
[]
[]
[null,{"$f":"IF(OR(ISBLANK(B140),ISBLANK(B136)),\"\",IF(OR(F142>=(B136/B140),F142>(B136-H136)/B140),B136-H136,F142*B140))","v":""},{"$nulls":3},{"$f":"IF(ISBLANK(B140),\"\",VLOOKUP($D$45,Parameter!$A$35:$M$47,13,1))","v":""},{"$nulls":3},{"$f":"IF(J136=\"\",0,J136)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,{"$f":"B136*D136*D140","v":0},{"$nulls":5},{"$f":"Parameter!M55*D140*D136","v":0},null,{"$f":"B145-H145-J144","v":0}]
[]
["Zahlungsdaten"]
[]
["erstmalige Auszahlung",null,null,{"$f":"IF(F19>TODAY(),F19,TODAY()+30)","v":"2020-09-05"},null,"Kontoinhaber"]
[]
["massgebendes Einkommen",null,null,{"$f":"D45","v":0},null,"IBAN: CH"]
[]
["Betreuungsgutschein pro Monat:","Kindertagesstätten",null,{"$f":"J67+J73","v":0},{"$nulls":7}," "]
[]
[null,"Tagesfamilien",null,{"$f":"J83+J89","v":0},null,{"$f":"IF(OR(D155=\"\",D155=0),\"\",\"Hinweis: Dies entspricht dem maximalen Anspruch, die Stunden werden nachträglich effektiv abgerechnet.\")","v":""}]
[]
[null,"Tagesstrukturen",null,{"$f":"J100+J106+J112+J118","v":0}]
[]
["Anrechenbarer Anteil Arbeitgeber",null,null,{"$f":"IF(D162<0,D162,D163)","v":0},null,{"$f":"IF(OR(D159=\"\",D159=0),\"\",\"Hinweis: Der Arbeitgeberbeitrag übersteigt die Differenz zwischen den Vollkosten und der Summe der Eigenkosten und der Betreuungsgutscheine. Dieser Anteil wird von den Betreuungsgutscheinen abgezogen.\")","v":""}]
[]
[{"$nulls":3},{"$f":"(J68+J74+J84+J90+J101+J107+J113+J119)-D52","v":0}]
[{"$nulls":3},{"$f":"IF(ISBLANK(D161),\"\",ROUND(D161/5,2)*5)","v":0}]
[{"$nulls":3},{"$f":"IF(D162>0,0,D162-D52)","v":0}]
[]
["Auszahlung pro Monat \n(Kita + Tagesfamilien + Tagesstrukturen)",null,null,{"$f":"IF(D153+D155+D157+D159<=0,\"0\",D153+D155+D157+D159)","v":"0"}]
[{"$nulls":3},{"$f":"D155+D157+#REF!+D159+#REF!","v":{"$error":"#REF!"}}]
[]
["Ferienbetreuung pro Jahr \n(direkte Verrechnung mit Kosten)",null,null,{"$f":"J128","v":0}]
[]
["Auszahlung pro Quartal (Spielgruppen)",null,null,{"$f":"J142","v":{"$error":"#VALUE!"}}]
[]
["Administration"]
[]
["Bestätigung /Ablehnung geschickt",null,null,"Ja",null,"Datum:"]
[]
["Zahlung eingerichtet",null,null,"Ja",null,"Datum:"]

{"sheet":"Parameter","index":1,"n_rows":55,"n_cols":14,"rows_kept":55,"merged":[[4,0,4,2],[4,3,4,4],[4,5,5,5],[4,6,5,6],[23,0,24,2],[23,3,23,4],[23,5,23,6],[23,7,23,11],[23,12,24,12],[25,0,25,2],[26,0,26,2],[27,0,27,2],[32,0,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,11],[32,12,33,12],[32,13,33,13],[51,0,52,2],[51,3,51,4],[51,5,51,6],[51,7,51,11],[51,12,52,12],[53,0,53,2],[54,0,54,2]]}
["Parameter für Berechnung Betreuungsgutscheine"]
[]
[]
["Höhe Betreuungsgutscheine in Stunden"]
["massgebendes Einkommen",null,null,"Kindertagesstätte / Tagesfamilien",null,"Schulergänzende Betreuung / Ferienbetreuung","Spielgruppe"]
["von",null,"bis","Kinder unter \n18 Monaten","Kinder\nüber 18 Monate"]
[0,"bis",{"v":45000,"d":"CHF 45,000"},{"v":10.5,"d":"CHF 10.50"},{"v":9.5,"d":"CHF 9.50"},{"v":9.5,"d":"CHF 9.50"},{"v":7.5,"d":"CHF 7.50"}]
[{"v":45001,"d":"CHF 45,001"},"bis",{"$f":"C7+5000","v":{"v":50000,"d":"CHF 50,000"}},{"v":9.7,"d":"CHF 9.70"},{"v":8.7,"d":"CHF 8.70"},{"v":8.7,"d":"CHF 8.70"},{"v":6.9,"d":"CHF 6.90"}]
[{"$f":"A8+5000","v":{"v":50001,"d":"CHF 50,001"}},"bis",{"$f":"C8+5000","v":{"v":55000,"d":"CHF 55,000"}},{"v":9,"d":"CHF 9.00"},{"v":8,"d":"CHF 8.00"},{"v":8,"d":"CHF 8.00"},{"v":6.3,"d":"CHF 6.30"}]
[{"$f":"A9+5000","v":{"v":55001,"d":"CHF 55,001"}},"bis",{"v":60000,"d":"CHF 60,000"},{"v":8.2,"d":"CHF 8.20"},{"v":7.2,"d":"CHF 7.20"},{"v":7.2,"d":"CHF 7.20"},{"v":5.7,"d":"CHF 5.70"}]
[{"v":60001,"d":"CHF 60,001"},"bis",{"v":65000,"d":"CHF 65,000"},{"v":7.4,"d":"CHF 7.40"},{"v":6.4,"d":"CHF 6.40"},{"v":6.4,"d":"CHF 6.40"},{"v":5.1,"d":"CHF 5.10"}]
[{"v":65001,"d":"CHF 65,001"},"bis",{"v":70000,"d":"CHF 70,000"},{"v":6.6,"d":"CHF 6.60"},{"v":5.6,"d":"CHF 5.60"},{"v":5.6,"d":"CHF 5.60"},{"v":4.5,"d":"CHF 4.50"}]
[{"v":70001,"d":"CHF 70,001"},"bis",{"v":75000,"d":"CHF 75,000"},{"v":5.9,"d":"CHF 5.90"},{"v":4.9,"d":"CHF 4.90"},{"v":4.9,"d":"CHF 4.90"},{"v":3.9,"d":"CHF 3.90"}]
[{"v":75001,"d":"CHF 75,001"},"bis",{"v":80000,"d":"CHF 80,000"},{"v":5.1,"d":"CHF 5.10"},{"v":4.1,"d":"CHF 4.10"},{"v":4.1,"d":"CHF 4.10"},{"v":3.3,"d":"CHF 3.30"}]
[{"v":80001,"d":"CHF 80,001"},"bis",{"v":85000,"d":"CHF 85,000"},{"v":4.3,"d":"CHF 4.30"},{"v":3.3,"d":"CHF 3.30"},{"v":3.3,"d":"CHF 3.30"},{"v":2.7,"d":"CHF 2.70"}]
[{"v":85001,"d":"CHF 85,001"},"bis",{"v":90000,"d":"CHF 90,000"},{"v":3.5,"d":"CHF 3.50"},{"v":2.5,"d":"CHF 2.50"},{"v":2.5,"d":"CHF 2.50"},{"v":2.1,"d":"CHF 2.10"}]
[{"v":90001,"d":"CHF 90,001"},"bis",{"v":95000,"d":"CHF 95,000"},{"v":2.8,"d":"CHF 2.80"},{"v":1.8,"d":"CHF 1.80"},{"v":1.8,"d":"CHF 1.80"},{"v":1.5,"d":"CHF 1.50"}]
[{"v":95001,"d":"CHF 95,001"},"bis",{"v":100000,"d":"CHF 100,000"},{"v":2,"d":"CHF 2.00"},{"v":1,"d":"CHF 1.00"},{"v":1,"d":"CHF 1.00"},{"v":1,"d":"CHF 1.00"}]
[{"v":100001,"d":"CHF 100,001"},"bis",{"v":999999999,"d":"CHF 999,999,999"},"CHF -","CHF -","CHF -","CHF -"]
[]
[]
[]
["maximaler Anspruch an Betreuungsstunden pro Jahr"]
["maximaler Anspruch an Betreuungsstunden",null,null,"Kindertagesstätte",null,"Tagesfamilien",null,"Schulergänzende Betreuung / Ferienbetreuung",{"$nulls":4},"Spielgruppe"]
[{"$nulls":3},"Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Frühmorgen","Mittagstisch","Nachmittag 1 13.30 bis 15.30","Nachmittag I1 15.30 bis 18.00","Ferienbetreuung"]
["maximale Betreuungstunden pro Element",null,null,10,10,10,10,0,1.5,2,2.5,4,8]
["maximale Betreuungstage pro Jahr",null,null,240,240,240,240,190,190,190,190,30,40]
["maximale Betreuungsstunden pro Jahr",null,null,{"$f":"D26*D27","v":2400},{"$f":"E26*E27","v":2400},2400,2400,0,285,380,475,120,320]
[]
[]
[]
["Höhe Betreuungsgutscheine pro Betreuungselement"]
["massgebendes Einkommen",null,null,"Kindertagesstätte pro Tag",null,"Tagesfamilien pro Stunde",null,"Schulergänzende Betreuung / Ferienbetreuung pro Element",{"$nulls":4},"Spielgruppe pro Stunde","Spielgruppe pro Modul"]
["von",null,"bis","Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Frühmorgen","Mittagstisch","Nachmittag 1 13.30 bis 15.30","Nachmittag I1 15.30 bis 18.00","Ferienbetreuung"]
[0,"bis",{"v":45000,"d":"CHF 45,000"},{"$f":"D7*$D$26","v":{"v":105,"d":"CHF 105.00"}},{"$f":"E7*$E$26","v":{"v":95,"d":"CHF 95.00"}},{"v":10.5,"d":"CHF 10.50"},{"v":9.5,"d":"CHF 9.50"},0,{"$f":"F7*$I$26","v":{"v":14.25,"d":"CHF 14.25"}},{"$f":"F7*$J$26","v":{"v":19,"d":"CHF 19.00"}},{"$f":"F7*$K$26","v":{"v":23.75,"d":"CHF 23.75"}},{"$f":"F7*$L$26","v":{"v":38,"d":"CHF 38.00"}},{"v":7.5,"d":"CHF 7.50"},{"$f":"M35*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":45001,"d":"CHF 45,001"},"bis",{"$f":"C35+5000","v":{"v":50000,"d":"CHF 50,000"}},{"$f":"D8*$D$26","v":{"v":97,"d":"CHF 97.00"}},{"$f":"E8*$E$26","v":{"v":87,"d":"CHF 87.00"}},{"v":9.7,"d":"CHF 9.70"},{"v":8.7,"d":"CHF 8.70"},0,{"$f":"F8*$I$26","v":{"v":13.049999999999999,"d":"CHF 13.05"}},{"$f":"F8*$J$26","v":{"v":17.4,"d":"CHF 17.40"}},{"$f":"F8*$K$26","v":{"v":21.75,"d":"CHF 21.75"}},{"$f":"F8*$L$26","v":{"v":34.8,"d":"CHF 34.80"}},{"v":6.9,"d":"CHF 6.90"},{"$f":"M36*'Datenblatt pro Kind'!$B$140","v":0}]
[{"$f":"A36+5000","v":{"v":50001,"d":"CHF 50,001"}},"bis",{"$f":"C36+5000","v":{"v":55000,"d":"CHF 55,000"}},{"v":90,"d":"CHF 90.00"},{"v":80,"d":"CHF 80.00"},{"v":9,"d":"CHF 9.00"},{"v":8,"d":"CHF 8.00"},0,{"v":12,"d":"CHF 12.00"},{"v":16,"d":"CHF 16.00"},{"v":20,"d":"CHF 20.00"},{"v":32,"d":"CHF 32.00"},{"v":6.3,"d":"CHF 6.30"},{"$f":"M37*'Datenblatt pro Kind'!$B$140","v":0}]
[{"$f":"A37+5000","v":{"v":55001,"d":"CHF 55,001"}},"bis",{"v":60000,"d":"CHF 60,000"},{"v":82,"d":"CHF 82.00"},{"v":72,"d":"CHF 72.00"},{"v":8.2,"d":"CHF 8.20"},{"v":7.2,"d":"CHF 7.20"},0,{"v":10.8,"d":"CHF 10.80"},{"v":14.4,"d":"CHF 14.40"},{"v":18,"d":"CHF 18.00"},{"v":28.8,"d":"CHF 28.80"},{"v":5.7,"d":"CHF 5.70"},{"$f":"M38*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":60001,"d":"CHF 60,001"},"bis",{"v":65000,"d":"CHF 65,000"},{"v":74,"d":"CHF 74.00"},{"v":64,"d":"CHF 64.00"},{"v":7.4,"d":"CHF 7.40"},{"v":6.4,"d":"CHF 6.40"},0,{"v":9.600000000000001,"d":"CHF 9.60"},{"v":12.8,"d":"CHF 12.80"},{"v":16,"d":"CHF 16.00"},{"v":25.6,"d":"CHF 25.60"},{"v":5.1,"d":"CHF 5.10"},{"$f":"M39*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":65001,"d":"CHF 65,001"},"bis",{"v":70000,"d":"CHF 70,000"},{"v":66,"d":"CHF 66.00"},{"v":56,"d":"CHF 56.00"},{"v":6.6,"d":"CHF 6.60"},{"v":5.6,"d":"CHF 5.60"},0,{"v":8.399999999999999,"d":"CHF 8.40"},{"v":11.2,"d":"CHF 11.20"},{"v":14,"d":"CHF 14.00"},{"v":22.4,"d":"CHF 22.40"},{"v":4.5,"d":"CHF 4.50"},{"$f":"M40*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":70001,"d":"CHF 70,001"},"bis",{"v":75000,"d":"CHF 75,000"},{"v":59,"d":"CHF 59.00"},{"v":49,"d":"CHF 49.00"},{"v":5.9,"d":"CHF 5.90"},{"v":4.9,"d":"CHF 4.90"},0,{"v":7.3500000000000005,"d":"CHF 7.35"},{"v":9.8,"d":"CHF 9.80"},{"v":12.25,"d":"CHF 12.25"},{"v":19.6,"d":"CHF 19.60"},{"v":3.9,"d":"CHF 3.90"},{"$f":"M41*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":75001,"d":"CHF 75,001"},"bis",{"v":80000,"d":"CHF 80,000"},{"v":51,"d":"CHF 51.00"},{"v":41,"d":"CHF 41.00"},{"v":5.1,"d":"CHF 5.10"},{"v":4.1,"d":"CHF 4.10"},0,{"v":6.1499999999999995,"d":"CHF 6.15"},{"v":8.2,"d":"CHF 8.20"},{"v":10.25,"d":"CHF 10.25"},{"v":16.4,"d":"CHF 16.40"},{"v":3.3,"d":"CHF 3.30"},{"$f":"M42*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":80001,"d":"CHF 80,001"},"bis",{"v":85000,"d":"CHF 85,000"},{"v":43,"d":"CHF 43.00"},{"v":33,"d":"CHF 33.00"},{"v":4.3,"d":"CHF 4.30"},{"v":3.3,"d":"CHF 3.30"},0,{"v":4.949999999999999,"d":"CHF 4.95"},{"v":6.6,"d":"CHF 6.60"},{"v":8.25,"d":"CHF 8.25"},{"v":13.2,"d":"CHF 13.20"},{"v":2.7,"d":"CHF 2.70"},{"$f":"M43*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":85001,"d":"CHF 85,001"},"bis",{"v":90000,"d":"CHF 90,000"},{"v":35,"d":"CHF 35.00"},{"v":25,"d":"CHF 25.00"},{"v":3.5,"d":"CHF 3.50"},{"v":2.5,"d":"CHF 2.50"},0,{"v":3.75,"d":"CHF 3.75"},{"v":5,"d":"CHF 5.00"},{"$f":"F16*$K$26","v":{"v":6.25,"d":"CHF 6.25"}},{"v":10,"d":"CHF 10.00"},{"v":2.1,"d":"CHF 2.10"},{"$f":"M44*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":90001,"d":"CHF 90,001"},"bis",{"v":95000,"d":"CHF 95,000"},{"v":28,"d":"CHF 28.00"},{"v":18,"d":"CHF 18.00"},{"v":2.8,"d":"CHF 2.80"},{"v":1.8,"d":"CHF 1.80"},0,{"v":2.7,"d":"CHF 2.70"},{"v":3.6,"d":"CHF 3.60"},{"v":4.5,"d":"CHF 4.50"},{"v":7.2,"d":"CHF 7.20"},{"v":1.5,"d":"CHF 1.50"},{"$f":"M45*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":95001,"d":"CHF 95,001"},"bis",{"v":100000,"d":"CHF 100,000"},{"v":20,"d":"CHF 20.00"},{"v":10,"d":"CHF 10.00"},{"v":2,"d":"CHF 2.00"},{"v":1,"d":"CHF 1.00"},0,{"v":1.5,"d":"CHF 1.50"},{"v":2,"d":"CHF 2.00"},{"v":2.5,"d":"CHF 2.50"},{"v":4,"d":"CHF 4.00"},{"v":1,"d":"CHF 1.00"},{"$f":"M46*'Datenblatt pro Kind'!$B$140","v":0}]
[{"v":100001,"d":"CHF 100,001"},"bis",{"v":999999999,"d":"CHF 999,999,999"},0,0,0,0,0,0,0,0,0,"CHF -",0]
[]
[]
[]
["Minimale Kostenbeteiligung pro Stunde"]
["Minimale Kostenbeteiligung ",null,null,"Kindertagesstätte",null,"Tagesfamilien",null,"Schulergänzende Betreuung / Ferienbetreuung",{"$nulls":4},"Spielgruppe"]
[{"$nulls":3},"Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Kinder unter \n18 Monaten","Kinder\nüber 18 Monate","Frühmorgen","Mittagstisch","Nachmittag 1 13.30 bis 15.30","Nachmittag I1 15.30 bis 18.00","Ferienbetreuung"]
["Minimale Kostenbeteiligung pro Stunde",null,null,{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":2,"d":"CHF 2.00"},{"v":1,"d":"CHF 1.00"}]
["Minimale Kostenbeteiligung pro Element",null,null,{"$f":"D54*D26","v":{"v":20,"d":"CHF 20.00"}},{"$f":"E54*E26","v":{"v":20,"d":"CHF 20.00"}},null,null,0,{"v":3,"d":"CHF 3.00"},{"v":4,"d":"CHF 4.00"},{"v":5,"d":"CHF 5.00"},{"v":8,"d":"CHF 8.00"},{"$f":"M54*'Datenblatt pro Kind'!B140","v":0}]