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

{"sheet":"Tabelle1","index":0,"n_rows":35,"n_cols":10,"rows_kept":35,"merged":[[14,2,14,9]]}
[null,"Schulgeldberechnung QuerWege Gesamtschule","Bitte alle grau unterlegten Felder ausfüllen"]
[{"$nulls":4},"Adresse:"]
[null,"Name des Kindes:"]
[null,"Name der Eltern:"]
[null,"Name der Eltern:"]
[]
[null,null,"Einkommen 1 ",null,"Einkommen 2",null,"Einkommen 3 (Sonstige)",null,"Einkommen Kindergeld"]
[null,"Jährliches Einkommen"]
[null,"Monatliches Einkommen",{"$nulls":6},{"$f":"C11*250","v":{"v":0,"d":"0.00 €"}}]
[null,"Einkommen zu Berechnung",{"$f":"IF(C9=0,C8/12,C9)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(E9=0,E8/12,E9)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(G9=0,G8/12,G9)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(I9=0,I8/12,I9)","v":{"v":0,"d":"0.00 €"}}]
[null,"Anzahl der kindergeldberechtigten Kinder"]
[]
[]
[]
[null,"absetzbare Pauschalbeträge in %","                                                              Bitte in das zutreffende Feld eine X eintragen"]
["-","lediglich sozialversicherungsplichtiges oder lediglich einkommenssteuerplichtiges E.",30,null,30,null,30,null,30]
["-","steuer- und sozialversicherungsplichtiges E.",40,"x",40,"x",40,null,40]
["-","Beamtenbezüge",25,null,25,null,25,null,25]
["-","weder steuer- noch sozialversicherungsplichtiges E.",5,null,5,null,5,null,5,"x"]
["-","kein Abzug",0,null,0,null,0,"x",0]
[]
[]
[null,"Kinderfreibetrag ab dem zweiten Kind (je Kind)",{"v":300,"d":"300.00 €"}]
[]
[null,"Bereinigte Einkommen",{"$f":"IF(D16=\"X\",C10-(C10/100*C16),IF(D17=\"X\",C10-(C10/100*C17),IF(D18=\"X\",C10-(C10/100*C18),IF(D19=\"X\",C10-(C10/100*C19),IF(D20=\"X\",C10,IF(D21=\"X\",\"\",\"Bitte alle grau unterlegten Felder ausfüllen\"))))))","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(F16=\"X\",E10-(E10/100*E16),IF(F17=\"X\",E10-(E10/100*E17),IF(F18=\"X\",E10-(E10/100*E18),IF(F19=\"X\",E10-(E10/100*E19),IF(F20=\"X\",E10,IF(D21=\"X\",\"\",\"Bitte alle grau unterlegten Felder ausfüllen\"))))))","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(H16=\"X\",G10-(G10/100*G16),IF(H17=\"X\",G10-(G10/100*G17),IF(H18=\"X\",G10-(G10/100*G18),IF(H19=\"X\",G10-(G10/100*G19),IF(H20=\"X\",G10,IF(F21=\"X\",\"\",\"Bitte alle grau unterlegten Felder ausfüllen\"))))))","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"}]
[null,"Summe der bereinigten Einkommen",{"$f":"C25+E25+G25+I25","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Kinderfreibetrag",{"$f":"IF(C11=1,C27,IF(C11=2,C27-C23,IF(C11=3,C27-(C23*2),IF(C11=4,C27-(C23*3),IF(C11=5,C27-(C23*4),IF(C11=6,C27-(C23*5),\"Bitte Kinderanzahl eingeben\"))))))","v":"Bitte Kinderanzahl eingeben"}]
[null,null,{"$f":"(((C26+C28)*0.048)+50)","v":{"$error":"#VALUE!"}}]
[null,"Gebühr (1. Kind)",{"$f":"IF(C29 >= 300, 300, IF(C29 <= 50, 50, C29))","v":{"$error":"#VALUE!"}}]
[]
[null,"weitere Kinder in Quer-Wege Schulen"]
[]
[null,"Gebühr pro Kind ab 2. Kind (75 %)",{"$f":"IF(C30=300,237,(((C26+C28)*0.048)*0.75)+50)","v":{"$error":"#VALUE!"}}]
[null,"Gebühr pro Kind ab 3. Kind (50 %)",{"$f":"IF(C30=300,175,(((C26+C28)*0.048)*0.5)+50)","v":{"$error":"#VALUE!"}}]