{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Formular","Daten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"Formular","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,7],[4,1,4,2],[5,1,5,2],[22,0,22,7],[5,6,5,7],[7,6,7,7],[15,0,15,5],[13,1,13,2],[53,0,53,7],[9,1,9,2],[10,6,10,7],[6,6,6,7],[11,6,11,7],[6,1,6,2],[7,1,7,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[]
["Betreuungskosten-Rechner ab 01.01.2024"]
[]
[]
["Familienname","Familienname"]
["Wohngemeinde","Benken",null,null,null,null,{"$f":"IF($K$7=1,\"Gemeinde mit Mittagstisch\",\"Gemeinde ohne Mittagstisch\")","v":"Gemeinde mit Mittagstisch"},null,null,"Gemeinde mit Leistungsvertrag",{"$f":"IF(ISNA(VLOOKUP(B6,Gemeinden_mit_Leistungsvertrag,1,FALSE)),0,1)","v":1}]
["Bruttoeinkommen",0,null,null,null,null,{"$f":"VLOOKUP($B$7,INDIRECT($K$9),2,TRUE)","v":"Stufe 8 Sozialamt"},null,null,"Gemeinde mit Mittagstisch",{"$f":"IF(ISNA(VLOOKUP(B6,Gemeinden_mit_Mittagstisch,1,FALSE)),0,1)","v":1}]
["Sozialamttarif","Ja",null,null,null,null,{"$f":"IF(B7<>999999,\"\",\"Einkommen nicht deklariert\")","v":""},null,null,"Sozialamt Tarif ok",{"$f":"IF(AND(K6 = 1,B8=\"Ja\"),1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,"Tabelle",{"$f":"IF(K8=1,Daten!A42,IF(K6=1,Daten!A25,Daten!A36))","v":"Tarif_Sozialamt"}]
["Name/Vorname Kind","Name und Vorname",null,null,null,null,null,null,null,"Mittagstisch ok",{"$f":"IF(AND(K7,B12=\"Ja\"),1,0)","v":1}]
["Geburtsdatum","2015-01-01",null,null,{"$f":"\"Alter: \" & DATEDIF($B$11,TODAY(),\"y\") &\" Jahre \"&DATEDIF($B$11,TODAY(),\"ym\")& \" Monate \"&IF(DAY($B$11)<=DAY(TODAY()),DAY(TODAY())-DAY($B$11),DAY(TODAY())+DAY(DATE(YEAR($B$11),MONTH($B$11)+1,1)-1)-DAY($B$11))&\" Tage\"","v":"Alter: 8 Jahre 10 Monate 10 Tage"},null,{"$f":"IF($K$13=1,\"Säuglingszuschlag\",\"kein Säuglingszuschlag\")","v":"kein Säuglingszuschlag"},null,null,"Mittagstisch Preis Spalte wegen Alter",{"$f":"IF(K10,IF(DATEDIF(B11,TODAY(),\"Y\")<Mittagstisch_Altersgrenze,7,8),0)","v":7}]
["Schulpflichtig","Ja",null,null,null,null,{"$f":"IF($K$10=1,\"Mittagstisch möglich\",\"Mittagstisch nicht möglich\")","v":"Mittagstisch möglich"},null,null,"Essen Preis Spalte Mahlzeiten Tabelle",{"$f":"IF(DATEDIF(B11,TODAY(),\"Y\")<Mahlzeiten_Altersgrenze_1,2,IF(DATEDIF(B11,TODAY(),\"Y\")<Mahlzeiten_Altersgrenze_2,3,4))","v":3}]
["Geschwisterrabatt MT","Nein",null,null,null,null,null,null,null,"Säuglingszuschlag",{"$f":"IF(DATEDIF(B11,TODAY(),\"M\")<Kleinkindergrenze_Monate,1,0)","v":0}]
["Geschwisterrabatt TK","Nein"]
[]
["Mittagstisch"]
[null,"Mo","Di","Mi","Do","Fr"]
["Mittagstisch","Nein","Nein","Nein","Nein","Nein"]
["Tarif Mittagstisch",{"$f":"IF(AND($K$10,B$18=\"Ja\"),VLOOKUP($B$7,INDIRECT($K$9),$K$11,TRUE),0)","v":0},{"$f":"IF(AND($K$10,C$18=\"Ja\"),VLOOKUP($B$7,INDIRECT($K$9),$K$11,TRUE),0)","v":0},{"$f":"IF(AND($K$10,D$18=\"Ja\"),VLOOKUP($B$7,INDIRECT($K$9),$K$11,TRUE),0)","v":0},{"$f":"IF(AND($K$10,E$18=\"Ja\"),VLOOKUP($B$7,INDIRECT($K$9),$K$11,TRUE),0)","v":0},{"$f":"IF(AND($K$10,F$18=\"Ja\"),VLOOKUP($B$7,INDIRECT($K$9),$K$11,TRUE),0)","v":0}]
["Geschw. Rabatt",{"$f":"IF(AND($K$10,B$18=\"Ja\"),IF($B$13=\"2 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),9,TRUE),IF($B$13=\"ab 3 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),10,TRUE),0)),0)","v":0},{"$f":"IF(AND($K$10,C$18=\"Ja\"),IF($B$13=\"2 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),9,TRUE),IF($B$13=\"ab 3 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),10,TRUE),0)),0)","v":0},0,0,0]
["Kosten Mittagstisch / Tag",{"$f":"B19-B20","v":0},{"$f":"C19-C20","v":0},0,0,0]
[]
["Tageskind"]
["Betreuung","Mo","Di","Mi","Do","Fr","Sa","So"]
["Betreuungszeit 1 Beginn"]
["Betreuungszeit 1 Ende"]
["Betreuungszeit 2 Beginn"]
["Betreuungszeit 2 Ende"]
["Betreuungszeit 3 Beginn"]
["Betreuungszeit 3 Ende"]
["Übernachtung","Nein","Nein","Nein","Nein","Nein","Nein","Nein"]
["Zeit Total / Tag",{"$f":"B26-B25+B28-B27+B30-B29","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Betreuungstarif / Std",{"$f":"VLOOKUP($B$7,INDIRECT($K$9),3,TRUE)","v":15},15,15,15,15,15,15]
["Geschw. Rabatt / Std",{"$f":"IF($B$14=\"2 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),4,TRUE),IF($B$14=\"ab 3 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),5,TRUE),0))","v":0},{"$f":"IF($B$14=\"2 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),4,TRUE),IF($B$14=\"ab 3 Kinder\",VLOOKUP($B$7,INDIRECT($K$9),5,TRUE),0))","v":0},0,0,0,0,0]
["Säuglingszuschlag / Std",{"$f":"IF($K13,Kleinkinderzuschlag_pro_Stunde,0)","v":0},0,0,0,0,0,0]
["Wochenendzuschlag / Std",null,null,null,null,null,{"$f":"Sa_So_Zuschlag_pro_Stunde","v":1},{"$f":"Sa_So_Zuschlag_pro_Stunde","v":1}]
["Infrastrukturbeitrag / Std",{"$f":"VLOOKUP($B$7,INDIRECT($K$9),6,TRUE)","v":0.5},{"$f":"VLOOKUP($B$7,INDIRECT($K$9),6,TRUE)","v":0.5},0.5,0.5,0.5,0.5,0.5]
["Übernachtung",{"$f":"IF(B31=\"Ja\",IF($K$13,Uebernachtung_Kleinkind,Uebernachtung_Kind),0)","v":0},0,0,0,0,0,0]
["Kosten Betreuung / Tag",{"$f":"ROUND(24*B32*(B33-B34+B35+B36+B37)/5,2)*5+B38","v":0},{"$f":"ROUND(24*C32*(C33-C34+C35+C36+C37)/5,2)*5+C38","v":0},0,0,0,0,0]
[]
["Mahlzeiten","Mo","Di","Mi","Do","Fr","Sa","So"]
["Frühstück"]
["Znüni"]
["Mittagessen"]
["Zvieri"]
["Nachtessen"]
["Frühstück",{"$f":"B42*VLOOKUP($A47,Mahlzeiten_Tabelle,$K$12,FALSE)","v":0},0,0,0,0,0,0]
["Znüni",0,0,0,0,0,0,0]
["Mittagessen",0,0,0,0,0,0,0]
["Zvieri",0,0,0,0,0,0,0]
["Nachtessen",0,0,0,0,0,0,0]
["Kosten Mahlzeiten / Tag",{"$f":"SUM(B47:B51)","v":0},{"$f":"SUM(C47:C51)","v":0},0,0,0,0,0]
[]
["Summe"]
["Total / Tag",{"$f":"B21+B39+B52","v":0},{"$f":"C21+C39+C52","v":0},0,0,0,0,0]
[]
["Total / Woche",{"$f":"SUM(B55:H55)","v":0}]
[]
["Total / Monat",{"$f":"4*B57","v":0}]

{"sheet":"Daten","index":1,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
[]
["Gemeinden mit Leistungsvertrag"]
["Amden"]
["Benken"]
["Eschenbach"]
["Gommiswald"]
["Kaltbrunn"]
["Schänis"]
["Schmerikon"]
["Uznach"]
["Weesen"]
[]
[]
["Gemeinden_mit_Mittagstisch"]
["Benken"]
["Eschenbach"]
["Gommiswald"]
["Kaltbrunn"]
["Schänis"]
["Schmerikon"]
["Weesen"]
[]
[]
[null,null,"Spalte 3","Spalte 4","Spalte 5","Spalte 6","Spalte 7","Spalte 8","Spalte 9","Spalte 10"]
["Tarif_Gemeinden_mit_Leistungsvertrag"]
["Bruttoeinkommen","Stufe","Kosten/Betreuungsstunde","Betreuung Rabatt\nRabatt 2 Kinder 5%","Betreuung Rabatt\nRabatt 3 Kinder 8%","Infrastrukturbeiträge/Stunde","Mittagstisch bis 12J","Mittagstisch ab 12J","Mittgstisch Rabatt\n 2 Kinder 5%","Mittgstisch Rabatt\nRabatt 3 Kinder 8%"]
[0,"Stufe 1",4,0,0,0.5,8,8,0,0]
[60001,"Stufe 2",5,0,0,0.5,9,9,0,0]
[80001,"Stufe 3",5.5,0.25,0.45,0.5,10,10,0.5,0.8]
[90001,"Stufe 4",6,0.3,0.5,0.5,11,11,0.55000000000000004,0.9]
[100001,"Stufe 5",7,0.35,0.55000000000000004,0.5,12,12,0.6,0.95]
[120001,"Stufe 6",8,0.4,0.65,0.5,13,13,0.65,1.05]
[140001,"Stufe 7",9,0.45,0.7,0.5,14,14,0.7,1.1000000000000001]
[]
[]
["Tarif_Gemeinden_ohne_Leistungsvertrag"]
["Bruttoeinkommen","Stufe","Kosten/Betreuungsstunde","Betreuung Rabatt\nRabatt 2 Kinder 5%","Betreuung Rabatt\nRabatt 3 Kinder 8%","Infrastrukturbeiträge/Stunde"]
[0,"Stufe 9",9.5,0.45,0.75,0.5]
[120001,"Stufe 9",9.5,0.45,0.75,0.5]
[]
[]
["Tarif_Sozialamt"]
["Bruttoeinkommen","Stufe","Kosten/Betreuungsstunde","Betreuung Rabatt\nRabatt 2 Kinder 5%","Betreuung Rabatt\nRabatt 3 Kinder 8%","Infrastrukturbeiträge/Stunde","Mittagstisch bis 12J","Mittagstisch ab 12J","Mittgstisch Rabatt\n 2 Kinder 5%","Mittgstisch Rabatt\nRabatt 3 Kinder 8%"]
[0,"Stufe 8 Sozialamt",15,0.75,1.2,0.5,20,20,1,1.6]
[]
[]
[]
["Kleinkinderzuschlag_pro_Stunde",2]
["Kleinkindergrenze_Monate [Monate]",18]
[]
[]
["Sa_So_Zuschlag_pro_Stunde",1]
[]
["Mittagstisch_Altersgrenze",12]
["Mahlzeiten_Altersgrenze_1",6]
["Mahlzeiten_Altersgrenze_2",12]
[]
[]
["Mahlzeiten_Tabelle","<6J","6J bis 12J",">=12J"]
["Frühstück",2,2.5,3]
["Znüni",1,1.5,2]
["Mittagessen",4,6,8]
["Zvieri",1,1.5,2]
["Nachtessen",3,4,5]
[]
[]
["Uebernachtung_Tabelle"]
["Uebernachtung_Kleinkind",17]
["Uebernachtung_Kind",15]
[]
["Uhrzeit_Auswahl_Liste",null,"Null_1_Auswahl_Liste"]
["07:00:00",null,0]
["07:15:00",null,1]
["07:30:00",null,0]
["07:45:00"]
["08:00:00"]
["08:15:00"]
["08:30:00"]
["08:45:00"]
["09:00:00"]
["09:15:00"]
["09:30:00"]
["09:45:00"]
["10:00:00"]
["10:15:00"]
["10:30:00"]
["10:45:00"]
["11:00:00"]
["11:15:00"]
["11:30:00"]
["11:45:00"]
["12:00:00"]
["12:15:00"]
["12:30:00"]
["12:45:00"]
["13:00:00"]
["13:15:00"]
["13:30:00"]
["13:45:00"]
["14:00:00"]
["14:15:00"]
["14:30:00"]
["14:45:00"]
["15:00:00"]
["15:15:00"]
["15:30:00"]
["15:45:00"]
["16:00:00"]
["16:15:00"]
["16:30:00"]
["16:45:00"]
["17:00:00"]
["17:15:00"]
["17:30:00"]
["17:45:00"]
["18:00:00"]
["18:15:00"]
["18:30:00"]
["18:45:00"]
["19:00:00"]