{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["GR","RT","StR","Changes_ToDo","TaxData","RawData","TaxCalculation","TaxFeetMunicipalities2018","ListMunicipalities","TaxFeetMunicipalities2019","TaxFeetMunicipalities2020","TaxFeetMunicipalities2021","TaxFeetMunicipalities2022","Ideas_Information"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":22,"comments":4,"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":"GR","index":0,"n_rows":84,"n_cols":21,"rows_kept":84,"cut":false,"hidden":false,"merged":[[60,0,60,20],[73,5,73,9],[73,14,73,18],[81,2,81,8],[81,11,81,17],[53,0,53,1],[17,0,17,20],[18,3,18,4],[18,12,18,13],[59,0,59,20],[55,0,55,20],[54,5,54,8],[54,0,54,1],[18,14,18,17],[54,14,54,17],[18,5,18,8],[16,3,16,4],[13,3,13,4],[16,12,16,13],[8,3,8,4],[12,3,12,4],[8,12,8,13],[15,12,15,13],[14,3,14,4],[13,12,13,13],[14,12,14,13],[11,3,11,4],[10,0,10,20],[16,0,16,1],[11,12,11,13],[12,12,12,13],[15,3,15,4],[6,3,6,4],[6,12,6,13],[7,3,7,4],[4,3,4,4],[5,3,5,4],[0,0,0,20],[0,21,83,21],[76,0,76,20],[80,0,80,20],[72,0,72,20],[67,0,67,20],[1,0,1,20],[9,12,9,13],[9,3,9,4],[3,3,3,4],[3,12,3,13],[7,12,7,13],[4,12,4,13],[5,12,5,13],[2,2,2,10],[2,11,2,19]]}
["ZH UHR - Grundrechner (GR)"]
["Geschäfts-Nr. [...] - Grunddaten"]
["Position","Quelle","Finanziell weniger leistungsfähiger Elternteil (grds. mit überwiegendem Betreuungsanteil)",null,null,null,null,null,null,null,null,"Finanziell leistungsfähigerer Elternteil",null,null,null,null,null,null,null,null,"Quelle"]
["Zivilstand","verheiratet",null,"Elternteil",null,"Kind 1","Kind 2","Kind 3","Kind 4",null,"Neuer Partner",null,"Elternteil",null,"Kind 1","Kind 2","Kind 3","Kind 4",null,"Neuer Partner"]
["Stichtag",""]
["Name(n)",null,null,""]
["Geburtstag(e)",null,null,"",null,null,null,null,null,null,null,null,""]
["Alter (Jahre)",null,null,{"$f":"IF(AND($B$5<>\"\",D7<>\"\"),DATEDIF(D7,$B$5,\"Y\"),IF(D7<>\"\",DATEDIF(D7,TODAY(),\"Y\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",F7<>\"\"),DATEDIF(F7,$B$5,\"Y\"),IF(F7<>\"\",DATEDIF(F7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",G7<>\"\"),DATEDIF(G7,$B$5,\"Y\"),IF(G7<>\"\",DATEDIF(G7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",H7<>\"\"),DATEDIF(H7,$B$5,\"Y\"),IF(H7<>\"\",DATEDIF(H7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",I7<>\"\"),DATEDIF(I7,$B$5,\"Y\"),IF(I7<>\"\",DATEDIF(I7,TODAY(),\"Y\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",K7<>\"\"),DATEDIF(K7,$B$5,\"Y\"),IF(K7<>\"\",DATEDIF(K7,TODAY(),\"Y\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",M7<>\"\"),DATEDIF(M7,$B$5,\"Y\"),IF(M7<>\"\",DATEDIF(M7,TODAY(),\"Y\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",O7<>\"\"),DATEDIF(O7,$B$5,\"Y\"),IF(O7<>\"\",DATEDIF(O7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",P7<>\"\"),DATEDIF(P7,$B$5,\"Y\"),IF(P7<>\"\",DATEDIF(P7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",Q7<>\"\"),DATEDIF(Q7,$B$5,\"Y\"),IF(Q7<>\"\",DATEDIF(Q7,TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",R7<>\"\"),DATEDIF(R7,$B$5,\"Y\"),IF(R7<>\"\",DATEDIF(R7,TODAY(),\"Y\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",T7<>\"\"),DATEDIF(T7,$B$5,\"Y\"),IF(T7<>\"\",DATEDIF(T7,TODAY(),\"Y\"),\"\"))","v":""}]
["Alter (Monate)",null,null,{"$f":"IF(AND($B$5<>\"\",D7<>\"\"),DATEDIF(D7,$B$5,\"ym\"),IF(D7<>\"\",DATEDIF(D7,TODAY(),\"ym\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",F$7<>\"\"),DATEDIF(F$7,$B$5,\"ym\"),IF(F$7<>\"\",DATEDIF(F$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",G$7<>\"\"),DATEDIF(G$7,$B$5,\"ym\"),IF(G$7<>\"\",DATEDIF(G$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",H$7<>\"\"),DATEDIF(H$7,$B$5,\"ym\"),IF(H$7<>\"\",DATEDIF(H$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",I$7<>\"\"),DATEDIF(I$7,$B$5,\"ym\"),IF(I$7<>\"\",DATEDIF(I$7,TODAY(),\"ym\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",K7<>\"\"),DATEDIF(K7,$B$5,\"ym\"),IF(K7<>\"\",DATEDIF(K7,TODAY(),\"ym\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",M$7<>\"\"),DATEDIF(M$7,$B$5,\"ym\"),IF(M$7<>\"\",DATEDIF(M$7,TODAY(),\"ym\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",O$7<>\"\"),DATEDIF(O$7,$B$5,\"ym\"),IF(O$7<>\"\",DATEDIF(O$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",P$7<>\"\"),DATEDIF(P$7,$B$5,\"ym\"),IF(P$7<>\"\",DATEDIF(P$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",Q$7<>\"\"),DATEDIF(Q$7,$B$5,\"ym\"),IF(Q$7<>\"\",DATEDIF(Q$7,TODAY(),\"ym\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",R$7<>\"\"),DATEDIF(R$7,$B$5,\"ym\"),IF(R$7<>\"\",DATEDIF(R$7,TODAY(),\"ym\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",T$7<>\"\"),DATEDIF(T$7,$B$5,\"ym\"),IF(T$7<>\"\",DATEDIF(T$7,TODAY(),\"ym\"),\"\"))","v":""}]
["Alter (Tage)",null,null,{"$f":"IF(AND($B$5<>\"\",D7<>\"\"),DATEDIF(D7,$B$5,\"md\"),IF(D7<>\"\",DATEDIF(D7,TODAY(),\"md\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",F$7<>\"\"),DATEDIF(F$7,$B$5,\"md\"),IF(F$7<>\"\",DATEDIF(F$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",G$7<>\"\"),DATEDIF(G$7,$B$5,\"md\"),IF(G$7<>\"\",DATEDIF(G$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",H$7<>\"\"),DATEDIF(H$7,$B$5,\"md\"),IF(H$7<>\"\",DATEDIF(H$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",I$7<>\"\"),DATEDIF(I$7,$B$5,\"md\"),IF(I$7<>\"\",DATEDIF(I$7,TODAY(),\"md\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",K7<>\"\"),DATEDIF(K7,$B$5,\"md\"),IF(K7<>\"\",DATEDIF(K7,TODAY(),\"md\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",M$7<>\"\"),DATEDIF(M$7,$B$5,\"md\"),IF(M$7<>\"\",DATEDIF(M$7,TODAY(),\"md\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",O$7<>\"\"),DATEDIF(O$7,$B$5,\"md\"),IF(O$7<>\"\",DATEDIF(O$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",P$7<>\"\"),DATEDIF(P$7,$B$5,\"md\"),IF(P$7<>\"\",DATEDIF(P$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",Q$7<>\"\"),DATEDIF(Q$7,$B$5,\"md\"),IF(Q$7<>\"\",DATEDIF(Q$7,TODAY(),\"md\"),\"\"))","v":""},{"$f":"IF(AND($B$5<>\"\",R$7<>\"\"),DATEDIF(R$7,$B$5,\"md\"),IF(R$7<>\"\",DATEDIF(R$7,TODAY(),\"md\"),\"\"))","v":""},null,{"$f":"IF(AND($B$5<>\"\",T$7<>\"\"),DATEDIF(T$7,$B$5,\"md\"),IF(T$7<>\"\",DATEDIF(T$7,TODAY(),\"md\"),\"\"))","v":""}]
["Einkommensberechnung"]
["Erwerbseinkommen"]
["Weiteres Einkommen"]
["Weiteres Einkommen"]
["Weiteres Einkommen"]
["Kinder- und Familienzulagen"]
["Monatl. Einkommen pro Haushalt / Person",null,{"$f":"SUM(D17:I17)","v":0},{"$f":"IF(SUM(D12:D15)>0,SUM(D12:D15),0)","v":0},null,{"$f":"SUM(F12:F14,F16)","v":0},{"$f":"SUM(G12:G14,G16)","v":0},{"$f":"SUM(H12:H14,H16)","v":0},{"$f":"SUM(I12:I14,I16)","v":0},null,{"$f":"SUM(K12:K14)","v":0},{"$f":"SUM(M17:R17)","v":0},{"$f":"IF(SUM(M12:M15)>0,SUM(M12:M15),0)","v":0},null,{"$f":"SUM(O12:O14,O16)","v":0},{"$f":"SUM(P12:P14,P16)","v":0},{"$f":"SUM(Q12:Q14,Q16)","v":0},{"$f":"SUM(R12:R14,R16)","v":0},null,{"$f":"SUM(T12:T14)","v":0}]
["Bedarfsberechnung"]
[null,"Quelle","Kosten pro Haushalt","Bedarf Elternteil",null,"Barbedarfe Kinder",null,null,null,"LH-Kosten betr. Person","Bedarf         Neuer Partner","Kosten pro Haushalt","Bedarf Elternteil",null,"Barbedarfe Kinder",null,null,null,"LH-Kosten betr. Person","Bedarf        Neuer Partner","Quelle"]
[]
["Grundbetrag",null,{"$f":"SUM(D21:I21)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M21:R21)","v":0}]
["Wohnkosten",null,0,null,null,null,null,null,null,null,null,0]
["Hypothekarzins",null,0,null,null,null,null,null,null,null,null,0]
["Wohnnebenkosten",null,0,null,null,null,null,null,null,null,null,0]
["Krankenkasse KVG (abz. IPV)",null,0,null,null,null,null,null,null,null,null,0]
["regelmässige, ungedeckte Gesundheitskosten",null,0,null,null,null,null,null,null,null,null,0]
["Fremdbetreuungskosten (z.B. Hort/Krippe)",null,0,null,null,null,null,null,null,null,null,0]
["notwendige Berufs-/Ausbildungsauslagen:"]
["Fahrten zum Arbeitsplatz",null,{"$f":"SUM(D29:I29)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M29:R29)","v":0}]
["Mehrkosten auswärtige Verpflegung",null,{"$f":"SUM(D30:I30)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M30:R30)","v":0}]
["notwendige Weiterbildungs-/Schulkosten",null,{"$f":"SUM(D31:I31)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M31:R31)","v":0}]
["Überdurchschnittlicher Kleider-/Wäscheverbrauch",null,{"$f":"SUM(D32:I32)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M32:R32)","v":0}]
[]
["Unterhaltsverpflichtung(en)",null,{"$f":"SUM(D34:I34)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M34:R34)","v":0}]
["Zusätzliche Bedarfspositionen"]
["laufende Steuern",null,{"$f":"SUM(D36:I36)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M36:R36)","v":0}]
["Radio-/TV",null,{"$f":"SUM(D37:I37)","v":0},null,null,null,null,null,null,null,null,0]
["Pauschale für Hausrat-/Haftpflichtversicherung",null,{"$f":"SUM(D38:I38)","v":0},null,null,null,null,null,null,null,null,0]
["Kommunikationskosten (inkl. Internet)",null,{"$f":"SUM(D39:I39)","v":0},null,null,null,null,null,null,null,null,0]
["Krankenkasse (VVG)",null,{"$f":"SUM(D40:I40)","v":0},null,null,null,null,null,null,null,null,0]
["Kompensation Vorsorge (nur Scheidung)",null,{"$f":"SUM(D41:I41)","v":0},null,null,null,null,null,null,null,null,0]
["Abzahlungsraten Schulden",null,{"$f":"SUM(D42:I42)","v":0},null,null,null,null,null,null,null,null,0]
["regelmässige Sparquote (z.B. 3. Säule, etc.)",null,{"$f":"SUM(D43:I43)","v":0},null,null,null,null,null,null,null,null,0]
["Manuelle Bedarfspositionen"]
[null,null,0,null,null,null,null,null,null,null,null,{"$f":"SUM(M45:R45)","v":0}]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
[null,null,0,null,null,null,null,null,null,null,null,0]
["Summe",null,{"$f":"SUM(C21:C53)","v":0},{"$f":"SUM(D$21:D$53)","v":0},null,{"$f":"SUM(F$21:F$53)","v":0},0,0,0,0,0,{"$f":"SUM(L21:L53)","v":0},{"$f":"SUM(M$21:M$53)","v":0},null,{"$f":"SUM(O$21:O$53)","v":0},0,0,0,0,0]
["Bedarfszahlen",null,null,{"$f":"SUM(D54,E54)","v":0},null,{"$f":"SUM(F54,G54,H54,I54)","v":0},null,null,null,null,null,null,{"$f":"SUM(M54,N54)","v":0},null,{"$f":"SUM(O54,P54,Q54,R54)","v":0}]
["Betreuungsunterhalt"]
["Totale Lebenshaltungskosten",null,null,null,null,null,null,null,null,{"$f":"J$54","v":0},null,null,null,null,null,null,null,null,{"$f":"S$54","v":0}]
["Totale Einkommen",null,null,{"$f":"D$17","v":0},null,null,null,null,null,null,null,null,{"$f":"M17","v":0}]
["Betreuungsunterhalt",null,{"$f":"IF(SUM(J$54-D$17)>=0,SUM(J$54-D$17),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($S$54>0,$T$58=\"\",SUM(S$54-$M$17)>0),SUM(S$54-$M$17),IF(AND($S$54>0,$M$58=\"\",SUM(S$54-$T$17)>0),SUM(S$54-T$17),0))","v":0},null,"Betreuungsunterhalt"]
["Übersicht finanzielle Verhältnisse / Verteilung Betreuungsunterhalt und Überschuss"]
["Verfügbare Geldmittel "]
["Gesamteinkommen (inkl. Einkommen Kinder)",{"$f":"SUM(C62,L62)","v":0},{"$f":"SUM(D62,F62:I62)","v":0},{"$f":"IF(D17<>\"\",D17,\"\")","v":0},null,{"$f":"IF(F17>F54,F54,F17)","v":0},{"$f":"IF(G17>G54,G54,G17)","v":0},{"$f":"IF(H17>H54,H54,H17)","v":0},{"$f":"IF(I17>I54,I54,I17)","v":0},null,null,{"$f":"SUM(M62,O62:R62)","v":0},{"$f":"IF(M17<>\"\",M17,\"\")","v":0},null,{"$f":"IF(O17>O54,O54,O17)","v":0},{"$f":"IF(P17>P54,P54,P17)","v":0},{"$f":"IF(Q17>Q54,Q54,Q17)","v":0},{"$f":"IF(R17>R54,R54,R17)","v":0}]
["abzgl. fam. Notbedarf Eltern",{"$f":"SUM(C63,L63)","v":0},{"$f":"-SUM(D54)","v":0},{"$f":"IF(D54<>\"\",SUM(D54),\"\")","v":0},null,null,null,null,null,null,null,{"$f":"-SUM(M54)","v":0},{"$f":"IF(M54<>\"\",SUM(M54),\"\")","v":0}]
["abzgl. Barbedarf Kinder",{"$f":"SUM(C64,L64)","v":0},{"$f":"-SUM(F55:I55)","v":0},null,null,{"$f":"IF(F54<>\"\",F54,\"\")","v":0},{"$f":"IF(G54<>\"\",G54,\"\")","v":0},{"$f":"IF(H54<>\"\",H54,\"\")","v":0},{"$f":"IF(I54<>\"\",I54,\"\")","v":0},{"$f":"IF(D64=\"\",\"\",D64)","v":""},null,{"$f":"-SUM(O64:R64)","v":0},null,null,{"$f":"IF(O54<>\"\",O54,\"\")","v":0},{"$f":"IF(P54<>\"\",P54,\"\")","v":0},{"$f":"IF(Q54<>\"\",Q54,\"\")","v":0},{"$f":"IF(R54<>\"\",R54,\"\")","v":0}]
["Gesamtüberschuss",{"$f":"IF((SUM(C62:C64)+SUM(L62:L64))>0,SUM(C62:C64)+SUM(L62:L64),0)","v":0},{"$f":"SUM(C62:C64)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(L62:L64)","v":0}]
[{"$f":"\"Überschuss \"&IF(GR!$M$6<>\"\",GR!$M$6,\"\")&\" (ohne Anteil \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\")\"","v":"Überschuss  (ohne Anteil )"},{"$f":"IF(RT!C12>0,B65-RT!C12,B65)","v":0},null,null,null,null,null,null,null,{"$f":"IF(D66=\"\",\"\",D66)","v":""}]
["Überschuss über erw. Bedarf",{"$f":"SUM(C67,L67)","v":0},null,null,null,null,null,null,null,{"$f":"IF(D67=\"\",\"\",D67)","v":""}]
["Barunterhalt"]
["Elterneinkommen nach Abzug fam. Notbedarf Eltern",{"$f":"SUM(C69,L69)","v":0},{"$f":"SUM(D17-D54)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(M17-M54)","v":0}]
["abzüglich Barbedarf Kinder",{"$f":"SUM(C70,L70)","v":0},{"$f":"-SUM(F70:I70)","v":0},null,null,{"$f":"IF(F54<>\"\",F54,\"\")","v":0},{"$f":"IF(G54<>\"\",G54,\"\")","v":0},{"$f":"IF(H54<>\"\",H54,\"\")","v":0},{"$f":"IF(I54<>\"\",I54,\"\")","v":0},null,null,{"$f":"-SUM(O70:R70)","v":0},null,null,{"$f":"IF(O54<>\"\",O54,\"\")","v":0},{"$f":"IF(P54<>\"\",P54,\"\")","v":0},{"$f":"IF(Q54<>\"\",Q54,\"\")","v":0},{"$f":"IF(R54<>\"\",R54,\"\")","v":0}]
["zzgl. Einkommen Kinder",{"$f":"SUM(C71,L71)","v":0},{"$f":"IF(SUM(F62:I62)>=SUM(F70:I70),SUM(F70:I70),SUM(F62:I62))","v":0},null,null,{"$f":"IF(F17<>\"\",-F17,\"\")","v":0},{"$f":"IF(G17<>\"\",-G17,\"\")","v":0},{"$f":"IF(H17<>\"\",-H17,\"\")","v":0},{"$f":"IF(I17<>\"\",-I17,\"\")","v":0},null,null,{"$f":"IF(SUM(O62:R62)>=SUM(O70:R70),SUM(O70:R70),SUM(O62:R62))","v":0},null,null,{"$f":"IF(O17<>\"\",-O17,\"\")","v":0},{"$f":"IF(P17<>\"\",-P17,\"\")","v":0},{"$f":"IF(Q17<>\"\",-Q17,\"\")","v":0},{"$f":"IF(R17<>\"\",-R17,\"\")","v":0}]
["Überschuss nach Deckung Barbedarf / Anspruch je Kind",{"$f":"IF(SUM(C72,L72)>0,SUM(C72,L72),0)","v":0},{"$f":"SUM(C69,IF(C70<>\"\",C70,0),IF(C71<>\"\",C71,0))","v":0},null,null,{"$f":"IF(SUM(F70+F71)>0,SUM(F70+F71),0)","v":0},{"$f":"IF(SUM(G70+G71)>0,SUM(G70+G71),0)","v":0},{"$f":"IF(SUM(H70+H71)>0,SUM(H70+H71),0)","v":0},{"$f":"IF(SUM(I70+I71)>0,SUM(I70+I71),0)","v":0},null,null,{"$f":"SUM(L69,IF(L70<>\"\",L70,0),IF(L71<>\"\",L71,0))","v":0},null,null,{"$f":"IF(SUM(O70+O71)>0,SUM(O70+O71),0)","v":0},{"$f":"IF(SUM(P70+P71)>0,SUM(P70+P71),0)","v":0},{"$f":"IF(SUM(Q70+Q71)>0,SUM(Q70+Q71),0)","v":0},{"$f":"IF(SUM(R70+R71)>0,SUM(R70+R71),0)","v":0}]
["Betreuungsunterhalt"]
["Überschuss nach Abzug Barbedarf",{"$f":"SUM(B72)","v":0},null,null,null,{"$f":"IF(SUM($F75:$I75)<>J75,\"! Verteilung prüfen !\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O75:R75)<>S75,\"! Verteilung prüfen !\",\"\")","v":""}]
["Betreuungsunterhalt (Vorschlag / Kind) eingeben",null,null,null,null,null,null,null,null,{"$f":"ROUND(C$59,0)","v":0},null,null,null,null,null,null,null,null,{"$f":"ROUND(S$59,0)","v":0}]
["Anspruch je Kind",null,null,null,null,{"$f":"F75","v":0},{"$f":"SUM(G75)","v":0},{"$f":"SUM(H75)","v":0},{"$f":"SUM(I75)","v":0},null,null,null,null,null,{"$f":"SUM(O75)","v":0},{"$f":"SUM(P75)","v":0},{"$f":"SUM(Q75)","v":0},{"$f":"SUM(R75)","v":0}]
["Überschussaufteilung"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N54","v":0}]
[]
[{"$f":"IF(B82<=0,\"Kein Überschuss vorhanden\",IF(AND(B4=\"ledig\",B80=\"\"),\"Verfügbare Geldmittel nach Deckung der Unterhaltsansprüche - Überschussaufteilung (kein Überschussanspruch für Elternteil 1)\",IF(AND(B4=\"ledig\",B80=\"\"),\"Verfügbare Geldmittel nach Deckung der Unterhaltsansprüche - Überschussaufteilung\",\"Verfügbare Geldmittel nach Deckung der Unterhaltsansprüche - Überschussaufteilung\")))","v":"Kein Überschuss vorhanden"}]
["Überschuss",{"$f":"IF(GR!B4=\"ledig\",RT!H29,IF(B74>0,B74,0))","v":0},"! Verteilung prüfen !",null,null,null,null,null,null,null,null,"! Verteilung prüfen !"]
["Anteil in Prozent eingeben",{"$f":"ROUND(SUM(C83,L83),2)","v":0},{"$f":"ROUND(SUM(D83:I83),2)","v":0},null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(M83:R83),2)","v":0}]
["Anteil in Franken",null,{"$f":"SUM(D84:I84)","v":0},{"$f":"IF(SUM(F84:I84,$M84:$R84)>=$B82,0,IF(AND(D83>0,D83<>\"\"),MIN($B82*D83,$B82-SUM(F84:I84,$M84:$R84)),0))","v":0},null,{"$f":"$B$82*F83","v":0},{"$f":"$B$82*G83","v":0},{"$f":"$B$82*H83","v":0},{"$f":"$B$82*I83","v":0},null,null,{"$f":"SUM(M84:R84)","v":0},{"$f":"$B$82*$M$83","v":0},null,{"$f":"$B$82*O83","v":0},{"$f":"$B$82*P83","v":0},{"$f":"$B$82*Q83","v":0},{"$f":"$B$82*R83","v":0}]

{"sheet":"RT","index":1,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[30,1,30,2],[29,1,29,2],[28,1,28,2],[41,14,41,16],[5,14,5,17],[31,7,31,8],[28,3,28,6],[19,1,19,2],[20,0,20,12],[19,7,19,8],[22,1,22,2],[26,1,26,2],[28,7,28,8],[41,1,41,2],[38,1,38,2],[37,1,37,2],[36,1,36,2],[35,1,35,2],[31,1,31,2],[42,1,42,2],[38,7,38,8],[42,7,42,8],[40,0,40,12],[33,7,33,8],[33,1,33,2],[34,0,34,12],[0,0,0,12],[21,9,22,10],[21,3,22,4],[24,3,24,5],[24,7,24,8],[21,7,21,8],[22,7,22,8],[1,1,1,2],[1,7,1,8],[3,1,3,2],[3,7,3,8],[5,1,5,2],[5,7,5,8],[23,1,23,2],[23,7,23,8],[24,1,24,2],[2,0,2,12],[32,0,32,12],[30,7,30,8],[21,11,22,12],[29,7,29,8],[27,0,27,12],[26,7,26,8],[25,0,25,12],[6,0,6,12],[10,0,10,12],[18,1,18,2],[18,7,18,8],[14,0,14,12],[7,7,7,8],[7,9,7,10],[7,11,7,12],[4,1,4,2],[4,7,4,8],[17,0,17,12],[15,7,15,8],[15,1,15,2],[11,7,11,8]]}
["ZH UHR - Rechnungstool (RT)"]
["Position",{"$f":"IF(GR!D6<>\"\",GR!D6,\"\")","v":""},null,{"$f":"IF(GR!F6<>\"\",GR!F6,\"\")","v":""},{"$f":"IF(GR!G6<>\"\",GR!G6,\"\")","v":""},{"$f":"IF(GR!H6<>\"\",GR!H6,\"\")","v":""},{"$f":"IF(GR!I6<>\"\",GR!I6,\"\")","v":""},{"$f":"IF(GR!M6<>\"\",GR!M6,\"\")","v":""},null,{"$f":"IF(GR!O6<>\"\",GR!O6,\"\")","v":""},{"$f":"IF(GR!P6<>\"\",GR!P6,\"\")","v":""},{"$f":"IF(GR!Q6<>\"\",GR!Q6,\"\")","v":""},{"$f":"IF(GR!R6<>\"\",GR!R6,\"\")","v":""}]
["Verfügbare Geldmittel"]
["Einkommen Elternteile / Kinder",{"$f":"IF(GR!D$17<>\"\",GR!D$17,\"\")","v":0},null,{"$f":"IF(GR!F$17<>\"\",GR!F$17,\"\")","v":0},{"$f":"IF(GR!G$17<>\"\",GR!G$17,\"\")","v":0},{"$f":"IF(GR!H$17<>\"\",GR!H$17,\"\")","v":0},{"$f":"IF(GR!I$17<>\"\",GR!I$17,\"\")","v":0},{"$f":"IF(GR!M$17<>\"\",GR!M$17,\"\")","v":0},null,{"$f":"IF(GR!O$17<>\"\",GR!O$17,\"\")","v":0},{"$f":"IF(GR!P$17<>\"\",GR!P$17,\"\")","v":0},{"$f":"IF(GR!Q$17<>\"\",GR!Q$17,\"\")","v":0},{"$f":"IF(GR!R$17<>\"\",GR!R$17,\"\")","v":0}]
["Fam. Not- bzw. Kindesbedarf",{"$f":"IF(GR!D$54<>\"\",GR!D$54,\"\")","v":0},null,{"$f":"IF(GR!F$54<>\"\",GR!F$54,\"\")","v":0},{"$f":"IF(GR!G$54<>\"\",GR!G$54,\"\")","v":0},{"$f":"IF(GR!H$54<>\"\",GR!H$54,\"\")","v":0},{"$f":"IF(GR!I$54<>\"\",GR!I$54,\"\")","v":0},{"$f":"IF(GR!M$54<>\"\",GR!M$54,\"\")","v":0},null,{"$f":"IF(GR!O$54<>\"\",GR!O$54,\"\")","v":0},{"$f":"IF(GR!P$54<>\"\",GR!P$54,\"\")","v":0},{"$f":"IF(GR!Q$54<>\"\",GR!Q$54,\"\")","v":0},{"$f":"IF(GR!R$54<>\"\",GR!R$54,\"\")","v":0}]
[{"$f":"\"Theoretische Leistungsfähigkeit von \"&IF(GR!D6<>\"\",GR!D6,\"\")&\" / \"&IF(GR!M6<>\"\",GR!M6,\"\")","v":"Theoretische Leistungsfähigkeit von  / "},{"$f":"IF(AND(B$4<>\"\",B$5<>\"\"),SUM(B$4-B$5),\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(H$4<>\"\",H$5<>\"\"),H4-H5-(RawData!N6*1*(J5-J4)+RawData!N7*(K5-K4)+RawData!N8*(L5-L4)+RawData!N9*(M5-M4)),\"\")","v":0},null,null,null,null,null,null,"! Unzulässige Berechnung (Mankoteilung; vgl. BGer 5A_1031/2019, E 5.1) !"]
["Barunterhalt"]
["Mittel zur Deckung Barunterhalt (theoretisch / effektiv)",{"$f":"$B$6","v":0},{"$f":"IF(B8>0,B8,0)","v":0},null,null,null,null,{"$f":"IF($H$6>0,$H$6,0)","v":0}]
["Theoretisch geschuldeter Barunterhalt (Einkommen Kinder abgezogen)",null,null,{"$f":"GR!F$72","v":0},{"$f":"GR!G$72","v":0},{"$f":"GR!H$72","v":0},{"$f":"GR!I$72","v":0},null,null,{"$f":"GR!O$72","v":0},{"$f":"GR!P$72","v":0},{"$f":"GR!Q$72","v":0},{"$f":"GR!R$72","v":0}]
[{"$f":"\"Von \"&IF(GR!M6<>\"\",GR!M6,\"\")&\" geschuldeter Barunterhalt ohne Leistungsfähigkeit \"&IF(GR!D6<>\"\",GR!D6,\"\")","v":"Von  geschuldeter Barunterhalt ohne Leistungsfähigkeit "},null,null,{"$f":"IF(AND(RawData!$N$6=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),D$9,IF(AND(RawData!$N$6=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(D$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND(RawData!$N$6=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),D$9,IF(AND(RawData!$N$6=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(D$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND($H$6<=0),0)))))","v":0},{"$f":"IF(AND(RawData!$N$7=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),E$9,IF(AND(RawData!$N$7=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(E$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND(RawData!$N$7=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),E$9,IF(AND(RawData!$N$7=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(E$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND($H$6<=0),0)))))","v":0},{"$f":"IF(AND(RawData!$N$8=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),F$9,IF(AND(RawData!$N$8=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(F$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND(RawData!$N$8=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),F$9,IF(AND(RawData!$N$8=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(F$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND($H$6<=0),0)))))","v":0},{"$f":"IF(AND(RawData!$N$9=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),G$9,IF(AND(RawData!$N$9=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(G$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND(RawData!$N$9=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),G$9,IF(AND(RawData!$N$9=1,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(G$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(AND($H$6<=0),0)))))","v":0},null,null,{"$f":"IF(AND(RawData!$N$6=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),J$9,IF(AND(RawData!$N$6=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(J$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(RawData!$N$6=1,0,IF(AND($H$6<=0),0))))","v":0},{"$f":"IF(AND(RawData!$N$7=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),K$9,IF(AND(RawData!$N$7=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(K$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(RawData!$N$7=1,0,IF(AND($H$6<=0),0))))","v":0},{"$f":"IF(AND(RawData!$N$8=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),L$9,IF(AND(RawData!$N$8=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(L$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(RawData!$N$8=1,0,IF(AND($H$6<=0),0))))","v":0},{"$f":"IF(AND(RawData!$N$9=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>=0),M$9,IF(AND(RawData!$N$9=0,$H$6-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)<0,$H$6>0),$H$6*SUM(M$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),IF(RawData!$N$9=1,0,IF(AND($H$6<=0),0))))","v":0},null,"Manko Barunterhalt: ",{"$f":"IF(SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)>SUM($D$10:$G$10,RawData!$N10*$J$10+RawData!$N11*$K$10+RawData!$N12*$L$10+RawData!N13*$M$10),SUM($D$10:$G$10,RawData!N10*$J$10+RawData!N11*$K$10+RawData!N12*$L$10+RawData!N13*$M$10)-SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9),0)","v":0}]
["Betreuungsunterhalt"]
["Mittel nach Deckung Barbedarf (theoretisch / effektiv)",{"$f":"B6","v":0},{"$f":"IF(B12>0,B12,0)","v":0},null,null,null,null,{"$f":"IF(AND($H$6<>\"\",SUM($H$6-SUM($D$9:$G$9,SUM(RawData!N10*$J$9+RawData!N11*$K$9+RawData!N12*$L$9+RawData!N13*$M$9)))>0),SUM($H$6-SUM($D$9:$G$9,SUM(RawData!N10*$J$9+RawData!N11*$K$9+RawData!N12*$L$9+RawData!N13*$M$9))),0)","v":0}]
["Gem. manueller Verteilung in GR Zeile 75 geschuldeter Betreuungsunterhalt",null,null,{"$f":"GR!F$75","v":0},{"$f":"GR!G$75","v":0},{"$f":"GR!H$75","v":0},{"$f":"GR!I$75","v":0},null,null,{"$f":"GR!O$75","v":0},{"$f":"GR!P$75","v":0},{"$f":"GR!Q$75","v":0},{"$f":"GR!R$75","v":0},null,"! Im GR prüfen !"]
[{"$f":"\"Effektiv von \"&IF(GR!M6<>\"\",GR!M6,\"\")&\" geschuldeter Betreuungsunterhalt\"","v":"Effektiv von  geschuldeter Betreuungsunterhalt"},null,null,{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),D$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(D$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),E$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(E$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),F$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(F$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),G$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(G$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},null,null,{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),J$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(J$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),K$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(K$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),L$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(L$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},{"$f":"IF(AND($H$12>=0,$H$12>=SUM($D$13:$G$13,$J$13:$M$13)),M$13,IF(AND($H$12>0,$H$12<SUM($D$13:$G$13,$J$13:$M$13)),$H$12*SUM(M$13)/SUM($D$13:$G$13,$J$13:$M$13),IF(SUM($D$13:$G$13,$J$13:$M$13)=0,0,IF(AND($H$12<=0),0,0))))","v":0},null,"Manko Betreuungsunterhalt:",{"$f":"IF(SUM($D$13:$G$13,$J$13:$M$13)>SUM($D$14:$G$14,$J$14:$M$14),SUM($D$14:$G$14,$J$14:$M$14)-SUM($D$13:$G$13,$J$13:$M$13),0)","v":0}]
["(Nach-)Ehelicher Unterhalt"]
["Mittel nach Deckung Kinderunterhalt",{"$f":"IF(AND(GR!B4 = \"ledig\",SUM(B12+SUM($D$14:$G$14)) < 0), 0, SUM(B12+SUM($D$14:$G$14)))","v":0},null,null,null,null,null,{"$f":"IF($H$12>0,$H$12-SUM(D14:G14,J14:M14),0)","v":0}]
[{"$f":"\"Anspruch \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" zur Deckung fam. Bedarf (theoretisch / effektiv)\"","v":"Anspruch  zur Deckung fam. Bedarf (theoretisch / effektiv)"},{"$f":"IF(B16<0,ABS(B16),0)","v":0},{"$f":"IF(SUM($D$13:$G$13)>SUM($D$14:$G$14),0,IF(AND(SUM($D$13:$G$13)=SUM($D$14:$G$14),$B$16>0),0,IF(AND(SUM($D$13:$G$13)=SUM($D$14:$G$14),$B$16<=0,$H$16>0,$H$16>ABS($B$16)),ABS($B$16),IF(AND(SUM($D$13:$G$13)=SUM($D$14:$G$14),$B$16<=0,$H$16<=ABS($B$16)),$H$16,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,"Manko fam. Bedarf",{"$f":"IF(B17>C17,C17-B17,0)","v":0}]
[{"$f":"\"Beitrag von \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" zur Mankodeckung   [ = Total \"&ROUND(SUM(D19:G19,J19:M19),0)&\" / \"&ROUND(SUM(D20:G20,J20:M20),0)&\" ]\"","v":"Beitrag von  zur Mankodeckung   [ = Total 0 / 0 ]"}]
[{"$f":"\"Beitrag \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" zur Mankodeckung Barunterhalt Kinder\"","v":"Beitrag  zur Mankodeckung Barunterhalt Kinder"},null,null,{"$f":"IF($P$10=0,0,IF(AND(RawData!$N6=1,$P$10<0,$B$16>0,D$9>0),MIN(D$9-D$10,$B$16*(D$9/SUM($D$9:$G$9,RawData!$N$10*$J$9+RawData!$N$11*$K$9+RawData!$N$12*$L$9+RawData!$N$13*$M$9))),IF(AND(RawData!$N6=0,$P$10<0,$B$16>0,D$9>0),MIN(D$9-D$10,$B$16*(D$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9))),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N7=1,$P$10<0,$B$16>0,E$9>0),MIN(E$9-E$10,$B$16*(E$9/SUM($D$9:$G$9,RawData!$N$10*$J$9+RawData!$N$11*$K$9+RawData!$N$12*$L$9+RawData!$N$13*$M$9))),IF(AND(RawData!$N7=0,$P$10<0,$B$16>0,E$9>0),MIN(E$9-E$10,$B$16*(E$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9))),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N7=1,$P$10<0,$B$16>0,F$9>0),MIN(F$9-F$10,$B$16*(F$9/SUM($D$9:$G$9,RawData!$N$10*$J$9+RawData!$N$11*$K$9+RawData!$N$12*$L$9+RawData!$N$13*$M$9))),IF(AND(RawData!$N7=0,$P$10<0,$B$16>0,F$9>0),MIN(F$9-F$10,$B$16*(F$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9))),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N7=1,$P$10<0,$B$16>0,G$9>0),MIN(G$9-G$10,$B$16*(G$9/SUM($D$9:$G$9,RawData!$N$10*$J$9+RawData!$N$11*$K$9+RawData!$N$12*$L$9+RawData!$N$13*$M$9))),IF(AND(RawData!$N7=0,$P$10<0,$B$16>0,G$9>0),MIN(G$9-G$10,$B$16*(G$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9))),0)))","v":0},null,null,{"$f":"IF($P$10=0,0,IF(AND(RawData!$N6=1,$P$10<0,$B$16>0,J$9>0),0,IF(AND(RawData!$N6=0,$P$10<0,$B$16>0,J$9>0),MIN(J$9-J$10,$B$16*(J$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),0),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N6=1,$P$10<0,$B$16>0,K$9>0),0,IF(AND(RawData!$N6=0,$P$10<0,$B$16>0,K$9>0),MIN(K$9-K$10,$B$16*(K$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),0),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N6=1,$P$10<0,$B$16>0,L$9>0),0,IF(AND(RawData!$N6=0,$P$10<0,$B$16>0,L$9>0),MIN(L$9-L$10,$B$16*(L$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),0),0)))","v":0},{"$f":"IF($P$10=0,0,IF(AND(RawData!$N6=1,$P$10<0,$B$16>0,M$9>0),0,IF(AND(RawData!$N6=0,$P$10<0,$B$16>0,M$9>0),MIN(M$9-M$10,$B$16*(M$9/SUM($D$9:$G$9,RawData!$N10*$J$9+RawData!$N11*$K$9+RawData!$N12*$L$9+RawData!$N13*$M$9)),0),0)))","v":0}]
[{"$f":"\"Beitrag \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" zur Mankodeckung Betreuungsunterhalt\"","v":"Beitrag  zur Mankodeckung Betreuungsunterhalt"},null,null,{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,D$13>0),MIN(D$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(D$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,E$13>0),MIN(E$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(E$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,F$13>0),MIN(F$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(F$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,G$13>0),MIN(G$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(G$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},null,null,{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,J$13>0),MIN(J$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(J$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,K$13>0),MIN(K$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(K$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,L$13>0),MIN(L$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(L$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0},{"$f":"IF(AND($P$14<0,$B$16-SUM($D$19:$G$19)>0,M$13>0),MIN(M$13/SUM($D$13:$G$13,$J$13:$M$13)*($B$16-SUM($D$19:$G$19,$J$19:$M$19)),(-($P$10+$P$14)-SUM($D19:$G19,$J$19:$M$19))*(M$13/SUM($D$13:$G$13,$J$13:$M$13))),0)","v":0}]
["Überschussverteilung"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Überschuss \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" / Überschuss \"&IF(GR!$M$6<>\"\",GR!$M$6,\"\")&\"\"","v":"Überschuss  / Überschuss "},{"$f":"IF(B16-SUM(D19:G20,J19:M20)>0,B16-SUM(D19:G20,J19:M20),0)","v":0},null,null,null,null,null,{"$f":"IF(H16-C17>0,H16-C17,0)","v":0},null,null,null,null,null,null,"Gesamtüberschuss: ",{"$f":"B29+H29","v":0}]
["Anteil am (Gesamt-)Überschuss gem. Verteilung in GR Zeile 83",{"$f":"SUM(GR!D$83*GR!$B$82)","v":0},null,{"$f":"SUM(GR!F$83*GR!$B$82)","v":0},{"$f":"SUM(GR!G$83*GR!$B$82)","v":0},{"$f":"SUM(GR!H$83*GR!$B$82)","v":0},{"$f":"SUM(GR!I$83*GR!$B$82)","v":0},{"$f":"SUM(GR!M$83*GR!$B$82)","v":0},null,{"$f":"SUM(GR!O$83*GR!$B$82)","v":0},{"$f":"SUM(GR!P$83*GR!$B$82)","v":0},{"$f":"SUM(GR!Q$83*GR!$B$82)","v":0},{"$f":"SUM(GR!R$83*GR!$B$82)","v":0},null,"! Im GR prüfen !"]
[{"$f":"\"Überschussbeteiligung von \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")","v":"Überschussbeteiligung von "},{"$f":"IF(OR($B$29<=0,$B30<=0),0,IF(AND($B$29>0,$B$30>0,$B$29<=$B$30),$B$29,IF(AND($B$29>$B$30,$B$30>0,$B$29<=SUM($B$30:$G$30)),$B$30,IF(AND($B$29>$B$30,$B$30>0,$B$29>SUM($B$30:$G$30)),$B$30))))","v":0},null,{"$f":"IF(OR($B$29<=0,D$30<=0),0,IF(AND($B$29>0,$B$29<=$B$30),0,IF(AND($B$29>$B$30,D$30>0,$B$29<=SUM($B$30:$G$30)),SUM($B$29-$B$30)*(D$30/SUM($D$30:$G$30)),IF(AND($B$29>$B$30,D$30>0,$B$29>SUM($B$30:$G$30)),D$30))))","v":0},{"$f":"IF(OR($B$29<=0,E$30<=0),0,IF(AND($B$29>0,$B$29<=$B$30),0,IF(AND($B$29>$B$30,E$30>0,$B$29<=SUM($B$30:$G$30)),SUM($B$29-$B$30)*(E$30/SUM($D$30:$G$30)),IF(AND($B$29>$B$30,E$30>0,$B$29>SUM($B$30:$G$30)),E$30))))","v":0},{"$f":"IF(OR($B$29<=0,F$30<=0),0,IF(AND($B$29>0,$B$29<=$B$30),0,IF(AND($B$29>$B$30,F$30>0,$B$29<=SUM($B$30:$G$30)),SUM($B$29-$B$30)*(F$30/SUM($D$30:$G$30)),IF(AND($B$29>$B$30,F$30>0,$B$29>SUM($B$30:$G$30)),F$30))))","v":0},{"$f":"IF(OR($B$29<=0,G$30<=0),0,IF(AND($B$29>0,$B$29<=$B$30),0,IF(AND($B$29>$B$30,G$30>0,$B$29<=SUM($B$30:$G$30)),SUM($B$29-$B$30)*(G$30/SUM($D$30:$G$30)),IF(AND($B$29>$B$30,G$30>0,$B$29>SUM($B$30:$G$30)),G$30))))","v":0},{"$f":"IF($H$30<=0,0,IF(AND($H$29>=$H$30,$H$30>0),0,IF(AND($H$29<$H$30,$H$30>0),MIN(SUM($D$10:$G$10),$H30-$H29))))","v":0},null,{"$f":"IF(J30<=0,0,IF(AND($H$29>$H$30,$H$29>SUM($H$30:$M$30)),0,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),MIN(D$10,($B$29-SUM($B$31:$H$31))*(J$30/SUM($J$30:$M$30))),IF(AND($H29<$H30,D$10>D$30),MIN(D$30,(($B$29-SUM($B31:$I$31)*(J$30/SUM($J$30:$M$30))))),IF(AND($H29<$H30,D$10<=D$30),MIN(D$10,(($B$29-SUM($B31:$I$31)*(J$30/SUM($J$30:$M$30))))))))))","v":0},{"$f":"IF(K30=0,0,IF(AND($H$29>$H$30,$H$29>SUM($H$30:$M$30)),0,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),MIN(E$10,($B$29-SUM($B$31:$H$31))*(K$30/SUM($J$30:$M$30))),IF(AND($H29<$H30,E$10>E$30),MIN(E$30,(($B$29-SUM($B31:$I$31)*(K$30/SUM($J$30:$M$30))))),IF(AND($H29<$H30,E$10<=E$30),MIN(E$10,(($B$29-SUM($B31:$I$31)*(K$30/SUM($J$30:$M$30))))))))))","v":0},{"$f":"IF(L30=0,0,IF(AND($H$29>$H$30,$H$29>SUM($H$30:$M$30)),0,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),MIN(F$10,($B$29-SUM($B$31:$H$31))*(L$30/SUM($J$30:$M$30))),IF(AND($H29<$H30,F$10>F$30),MIN(F$30,(($B$29-SUM($B31:$I$31)*(L$30/SUM($J$30:$M$30))))),IF(AND($H29<$H30,F$10<=F$30),MIN(F$10,(($B$29-SUM($B31:$I$31)*(L$30/SUM($J$30:$M$30))))))))))","v":0},{"$f":"IF(M30=0,0,IF(AND($H$29>$H$30,$H$29>SUM($H$30:$M$30)),0,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),MIN(G$10,($B$29-SUM($B$31:$H$31))*(M$30/SUM($J$30:$M$30))),IF(AND($H29<$H30,G$10>G$30),MIN(G$30,(($B$29-SUM($B31:$I$31)*(M$30/SUM($J$30:$M$30))))),IF(AND($H29<$H30,G$10<=G$30),MIN(G$10,(($B$29-SUM($B31:$I$31)*(M$30/SUM($J$30:$M$30))))))))))","v":0}]
[{"$f":"\"Überschussbeteiligung von \"&IF(GR!$M$6<>\"\",GR!$M$6,\"\")","v":"Überschussbeteiligung von "},{"$f":"IF($B$29=0,B$30,IF(AND($B$29>0,$B$30>0,$B$29<=$B$30),$B$30-$B$31,IF(AND($B$29>$B$30,$B$29<=SUM($B$30:$G$30)),0,IF(AND($B$29>SUM($B$30:$G$30)),B$30-B$31))))","v":0},null,{"$f":"IF($B$29=0,D$30,IF(AND($B$29>0,$B$29<=$B$30),D$30,IF(AND($B$29>$B$30,$B$29<=SUM($B$30:$G$30)),D$30-D$31,IF(AND($B$29>$B$30,$B$29>SUM($B$30:$G$30)),0))))","v":0},{"$f":"IF($B$29=0,E$30,IF(AND($B$29>0,$B$29<=$B$30),E$30,IF(AND($B$29>$B$30,$B$29<=SUM($B$30:$G$30)),E$30-E$31,IF(AND($B$29>$B$30,$B$29>SUM($B$30:$G$30)),0))))","v":0},{"$f":"IF($B$29=0,F$30,IF(AND($B$29>0,$B$29<=$B$30),F$30,IF(AND($B$29>$B$30,$B$29<=SUM($B$30:$G$30)),F$30-F$31,IF(AND($B$29>$B$30,$B$29>SUM($B$30:$G$30)),0))))","v":0},{"$f":"IF($B$29=0,G$30,IF(AND($B$29>0,$B$29<=$B$30),G$30,IF(AND($B$29>$B$30,$B$29<=SUM($B$30:$G$30)),G$30-G$31,IF(AND($B$29>$B$30,$B$29>SUM($B$30:$G$30)),0))))","v":0},{"$f":"IF($H$29>=$H$30,$H$30,IF(AND($H$29<$H$30,$H$30>0),$H$30-$H$31))","v":0},null,{"$f":"IF(J30=0,0,IF($H$29>SUM($H$30:$M$30),J$30,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),($H$29-$H30)*(J$30/SUM($J$30:$M$30)),IF($H$29<$H$30,0))))","v":0},{"$f":"IF(K30=0,0,IF($H$29>SUM($H$30:$M$30),K$30,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),($H$29-$H30)*(K$30/SUM($J$30:$M$30)),IF($H$29<$H$30,0))))","v":0},{"$f":"IF(L30=0,0,IF($H$29>SUM($H$30:$M$30),L$30,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),($H$29-$H30)*(L$30/SUM($J$30:$M$30)),IF($H$29<$H$30,0))))","v":0},{"$f":"IF(M30=0,0,IF($H$29>SUM($H$30:$M$30),M$30,IF(AND($H$29>$H$30,$H$29<=SUM($H$30:$M$30)),($H$29-$H30)*(M$30/SUM($J$30:$M$30)),IF($H$29<$H$30,0))))","v":0}]
[{"$f":"\"Beitrag von \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" am Barunterhalt der Kinder im eigenen Haushalt (GR Spalten D bis G)  [ = Total \"&ROUND(SUM(D34:G34),0)&\" ]\"","v":"Beitrag von  am Barunterhalt der Kinder im eigenen Haushalt (GR Spalten D bis G)  [ = Total 0 ]"}]
[{"$f":"\"Anteil von \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" an der Bedarfsdeckung der Kinder in GR Spalte D bis G\"","v":"Anteil von  an der Bedarfsdeckung der Kinder in GR Spalte D bis G"},null,null,{"$f":"IF($H$29>=SUM($H$30:$M$30),0,IF($H$29<SUM($H$30:$M$30),MIN((D$9/SUM($D$9:$G$9))*(SUM($H$30:$M$30)-SUM($H$32:$M$32)),D$9/SUM($D$9:$G$9)*$H$6),0))","v":0},{"$f":"IF($H$29>=SUM($H$30:$M$30),0,IF($H$29<SUM($H$30:$M$30),MIN((E$9/SUM($D$9:$G$9))*(SUM($H$30:$M$30)-SUM($H$32:$M$32)),E$9/SUM($D$9:$G$9)*$H$6),0))","v":0},{"$f":"IF($H$29>=SUM($H$30:$M$30),0,IF($H$29<SUM($H$30:$M$30),MIN((F$9/SUM($D$9:$G$9))*(SUM($H$30:$M$30)-SUM($H$32:$M$32)),F$9/SUM($D$9:$G$9)*$H$6),0))","v":0},{"$f":"IF($H$29>=SUM($H$30:$M$30),0,IF($H$29<SUM($H$30:$M$30),MIN((G$9/SUM($D$9:$G$9))*(SUM($H$30:$M$30)-SUM($H$32:$M$32)),G$9/SUM($D$9:$G$9)*$H$6),0))","v":0}]
["Mankos"]
["Theoretische Unterhaltsansprüche",{"$f":"SUM(B$17,$B$30)","v":0},null,{"$f":"SUM(D$9,D$13,D$30)","v":0},{"$f":"SUM(E$9,E$13,E$30)","v":0},{"$f":"SUM(F$9,F$13,F$30)","v":0},{"$f":"SUM(G$9,G$13,G$30)","v":0},null,null,{"$f":"IF(AND(RawData!$N6=1),SUM(J$5,J$13,J$30),IF(AND(RawData!$N$6=0),SUM(J$9,J$13,J$30)))","v":0},{"$f":"IF(AND(RawData!$N7=1),SUM(K$5,K$13,K$30),IF(AND(RawData!$N7=0),SUM(K$9,K$13,K$30)))","v":0},{"$f":"IF(AND(RawData!$N8=1),SUM(L$5,L$13,L$30),IF(AND(RawData!$N8=0),SUM(L$9,L$13,L$30)))","v":0},{"$f":"IF(AND(RawData!$N9=1),SUM(M$5,M$13,M$30),IF(AND(RawData!$N9=0),SUM(M$9,M$13,M$30)))","v":0}]
[{"$f":"\"Anteil Unterhaltsbeiträge (ohne Zeile 34) von \"&IF(GR!$M$6<>\"\",GR!$M$6,\"\")","v":"Anteil Unterhaltsbeiträge (ohne Zeile 34) von "},{"$f":"SUM($C$17,B$32)","v":0},null,{"$f":"SUM(D$10,D$14,D$32)","v":0},{"$f":"SUM(E$10,E$14,E$32)","v":0},{"$f":"SUM(F$10,F$14,F$32)","v":0},{"$f":"SUM(G$10,G$14,G$32)","v":0},null,null,{"$f":"IF(AND(RawData!$N6=1,$H$6>=0),SUM(J$5,J$14,J32),IF(AND(RawData!$N$6=0,$H$6>=0),SUM(J$10,J$14,J$32),IF(AND(RawData!$N$6=0,$H$6<0),SUM(J$10,J$14,J$32))))","v":0},{"$f":"IF(AND(RawData!$N7=1,$H$6>=0),SUM(K$5,K$14,K32),IF(AND(RawData!$N$7=0,$H$6>=0),SUM(K$10,K$14,K$32),IF(AND(RawData!$N$7=0,$H$6<0),SUM(J$10,J$14,J$32))))","v":0},{"$f":"IF(AND(RawData!$N8=1,$H$6>=0),SUM(L$5,L$14,L32),IF(AND(RawData!$N$8=0,$H$6>=0),SUM(L$10,L$14,L$32),IF(AND(RawData!$N$8=0,$H$6<0),SUM(J$10,J$14,J$32))))","v":0},{"$f":"IF(AND(RawData!$N9=1,$H$6>=0),SUM(M$5,M$14,M32),IF(AND(RawData!$N$9=0,$H$6>=0),SUM(M$10,M$14,M$32),IF(AND(RawData!$N$9=0,$H$6<0),SUM(J$10,J$14,J$32))))","v":0}]
[{"$f":"\"Anteil Unterhaltsbeiträge von \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")","v":"Anteil Unterhaltsbeiträge von "},{"$f":"B31","v":0},null,{"$f":"SUM(D$19,D$20,D$31)","v":0},{"$f":"SUM(E$19,E$20,E$31)","v":0},{"$f":"SUM(F$19,F$20,F$31)","v":0},{"$f":"SUM(G$19,G$20,G$31)","v":0},null,null,{"$f":"IF(AND(RawData!$N$6=1,$H$6>0),SUM(J$19,J$20,J$31),IF(AND(RawData!$N$6=0,$H$6>=0),SUM(J$19,J$20,J$31),IF(AND(RawData!$N$6=0,$H$6<0),SUM(J$19,J$20,J$31))))","v":0},{"$f":"IF(AND(RawData!$N$7=1,$H$6>0),SUM(K$19,K$20,K$31),IF(AND(RawData!$N$7=0,$H$6>=0),SUM(K$19,K$20,K$31),IF(AND(RawData!$N$7=0,$H$6<0),SUM(K$19,K$20,K$31))))","v":0},{"$f":"IF(AND(RawData!$N$8=1,$H$6>0),SUM(L$19,L$20,L$31),IF(AND(RawData!$N$8=0,$H$6>=0),SUM(L$19,L$20,L$31),IF(AND(RawData!$N$8=0,$H$6<0),SUM(L$19,L$20,L$31))))","v":0},{"$f":"IF(AND(RawData!$N$9=1,$H$6>0),SUM(M$19,M$20,M$31),IF(AND(RawData!$N$9=0,$H$6>=0),SUM(M$19,M$20,M$31),IF(AND(RawData!$N$9=0,$H$6<0),SUM(M$19,M$20,M$31))))","v":0}]
["Manko pro Person",{"$f":"IF($B$36-SUM(B$37+B$38)>0,-($B$36-SUM(B$37+B$38)),0)","v":0},null,{"$f":"D$37+D$38-D$36","v":0},{"$f":"E$37+E$38-E$36","v":0},{"$f":"F$37+F$38-F$36","v":0},{"$f":"G$37+G$38-G$36","v":0},null,null,{"$f":"J$37+J$38-J$36","v":0},{"$f":"K$37+K$38-K$36","v":0},{"$f":"L$37+L$38-L$36","v":0},{"$f":"M$37+M$38-M$36","v":0},null,"Gesamtes Manko: ",{"$f":"SUM(B39:G39,J39:M39)","v":0}]
[{"$f":"\"Effektives Manko \"&IF(GR!$D$6<>\"\",GR!$D$6,\"\")&\" abzgl. Manko Betreuungsunterhalt Kinder\"","v":"Effektives Manko  abzgl. Manko Betreuungsunterhalt Kinder"},{"$f":"IF(B$39>=0,0,IF(AND(B$39<0,SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)>0),ROUND(MIN(B$39+(SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)),0),1),IF(AND(B$39<=0,SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)=0),B$39,0)))","v":0},{"$f":"IF(C$39>=0,0,IF(AND(C$39<0,SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)>0),ROUND(MIN(C$39+(SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)),0),1),IF(AND(C$39<=0,SUM($D$13:$G$13,$J13:$K$13)-SUM($D$14:$G$14,$J$14:$K$14)=0),C$39,0)))","v":0}]
["Unterhaltsbeiträge"]
["Zuzusprechender Unterhalt/Betrag pro Kopf",{"$f":"IF(B$37>0,B$37,0)","v":0},null,{"$f":"IF(D$37-D34>0,D$37-D34,0)","v":0},{"$f":"IF(E$37-E34>0,E$37-E34,0)","v":0},{"$f":"IF(F$37-F34>0,F$37-F34,0)","v":0},{"$f":"IF(G$37-G34>0,G$37-G34,0)","v":0},null,null,{"$f":"J$37","v":0},{"$f":"K$37","v":0},{"$f":"L$37","v":0},{"$f":"M$37","v":0},null,"! Leistungsfähigerer Elternteil wohl auf falscher Seite eingetragen !"]
["Zuzusprechender Unterhalt an Gesamthaushalt",{"$f":"SUM(B42:G42)","v":0},null,null,null,null,null,null,{"$f":"I39","v":0}]

{"sheet":"StR","index":2,"n_rows":64,"n_cols":63,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,12],[15,0,15,12],[8,0,8,12],[1,0,1,12],[32,0,32,12],[16,7,16,8],[16,1,16,2],[7,1,7,2],[4,1,4,2],[4,7,4,8],[2,1,2,2],[2,7,2,8],[3,1,3,2],[3,7,3,8],[62,1,62,2],[62,7,62,8],[63,1,63,2],[63,7,63,8],[60,1,60,2],[60,7,60,8],[38,1,38,2],[38,7,38,8],[41,1,41,2],[41,7,41,8],[61,1,61,2],[61,7,61,8],[45,7,45,8],[45,1,45,2],[49,0,49,12],[50,1,50,2],[50,7,50,8],[56,1,56,2],[56,7,56,8],[37,0,37,12],[5,1,5,2],[5,7,5,8],[6,1,6,2],[6,7,6,8],[7,7,7,8],[21,1,21,2],[21,7,21,8]]}
["ZH UHR - Steuerrechner (StR)"]
["Grunddaten"]
[null,"Unterhaltsgläubiger",null,null,null,null,null,"Unterhaltsschuldner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Name",{"$f":"IF(GR!D6<>\"\",GR!D6,\"\")","v":""},null,{"$f":"IF(GR!F6<>\"\",GR!F6,\"\")","v":""},{"$f":"IF(GR!G6<>\"\",GR!G6,\"\")","v":""},{"$f":"IF(GR!H6<>\"\",GR!H6,\"\")","v":""},{"$f":"IF(GR!I6<>\"\",GR!I6,\"\")","v":""},{"$f":"IF(GR!M6<>\"\",GR!M6,\"\")","v":""},null,{"$f":"IF(GR!O6<>\"\",GR!O6,\"\")","v":""},{"$f":"IF(GR!P6<>\"\",GR!P6,\"\")","v":""},{"$f":"IF(GR!Q6<>\"\",GR!Q6,\"\")","v":""},{"$f":"IF(GR!R6<>\"\",GR!R6,\"\")","v":""}]
["Steuerjahr *"]
["Steuertarif *",null,null,null,null,null,null,null,null,null,null,null,null,null,"! Steuertarife prüfen !"]
["Konfession"]
["Steuergemeinde *"]
["Einkommensberechnung"]
["Position","Staats- und Gemeindesteuer","direkte Bundessteuer",null,null,null,null,"Staats- und Gemeindesteuer","direkte Bundessteuer"]
["Erwerbs-, Renten und Vermögensertrag",{"$f":"IF((GR!C17-SUM(GR!F12:'GR'!I12))*12>0,(GR!C17-SUM(GR!F12:'GR'!I12))*12,0)","v":0},{"$f":"IF((GR!C17-SUM(GR!F12:'GR'!I12))*12>0,(GR!C17-SUM(GR!F12:'GR'!I12))*12,0)","v":0},null,null,null,null,{"$f":"IF((GR!L17-SUM(GR!O12:'GR'!R12))*12>0,(GR!L17-SUM(GR!O12:'GR'!R12))*12,0)","v":0},{"$f":"IF((GR!L17-SUM(GR!O12:'GR'!R12))*12>0,(GR!L17-SUM(GR!O12:'GR'!R12))*12,0)","v":0}]
["Unterhaltsbeiträge Eintrag mit Steuerberechnung"]
["Einkünfte aus Liegenschaften"]
["Weitere Position(en)"]
["Total der Einkünfte",{"$f":"SUM(B11:B14)","v":0},{"$f":"SUM(C11:C14)","v":0},null,null,null,null,{"$f":"SUM(H11,H13:H14)","v":0},{"$f":"SUM(I11,I13:I14)","v":0}]
["Abzüge"]
[null,"Berufsauslagen",null,null,null,null,null,"Berufsauslagen"]
["Mobilitätskosten ",{"$f":"IF(GR!$D$29*12<=5000,GR!$D$29*12,5000)","v":0},{"$f":"IF(GR!$D$29*12<=3000,GR!$D$29*12,3000)","v":0},null,null,null,null,{"$f":"IF(GR!$M$29*12<=5000,GR!$M$29*12,5000)","v":0},{"$f":"IF(GR!$M$29*12<=3000,GR!$M$29*12,3000)","v":0}]
["Verpflegung",{"$f":"IF(GR!$D$30*12>3200,3200,GR!$D$30*12)","v":0},{"$f":"IF(GR!$D$30*12>3200,3200,GR!$D$30*12)","v":0},null,null,null,null,{"$f":"IF(GR!$M$30*12>3200,3200,GR!$M$30*12)","v":0},{"$f":"IF(GR!$M$30*12>3200,3200,GR!$M$30*12)","v":0}]
["Weitere Berufskosten",{"$f":"IF(GR!$D$12*12*0.03>4000,4000,IF(AND(GR!$D$12*12*0.03<4000,GR!$D$12*12*0.03>2000),GR!$D$12*12*0.03,IF(AND(GR!$D$12*12*0.03<2000,GR!$D$12*12>0),2000,IF(GR!$D$12*12=0,0))))","v":0},{"$f":"IF(GR!$D$12*12*0.03>4000,4000,IF(AND(GR!$D$12*12*0.03<4000,GR!$D$12*12*0.03>2000),GR!$D$12*12*0.03,IF(AND(GR!$D$12*12*0.03<2000,GR!$D$12*12>0),2000,IF(GR!$D$12*12=0,0))))","v":0},null,null,null,null,{"$f":"IF(GR!$M$12*12*0.03>4000,4000,IF(AND(GR!$M$12*12*0.03<4000,GR!$M$12*12*0.03>2000),GR!$M$12*12*0.03,IF(AND(GR!$M$12*12*0.03<2000,GR!$M$12*12>0),2000,IF(GR!$M$12*12=0,0))))","v":0},{"$f":"IF(GR!$M$12*12*0.03>4000,4000,IF(AND(GR!$M$12*12*0.03<4000,GR!$M$12*12*0.03>2000),GR!$M$12*12*0.03,IF(AND(GR!$M$12*12*0.03<2000,GR!$M$12*12>0),2000,IF(GR!$M$12*12=0,0))))","v":0}]
["Weiterbildungskosten "]
[null,"Weitere Abzüge",null,null,null,null,null,"Weitere Abzüge"]
["Hypothekarzinsen ",{"$f":"SUM(GR!$D$23:'GR'!$I$23)*12","v":0},{"$f":"SUM(GR!$D$23:'GR'!$I$23)*12","v":0},null,null,null,null,{"$f":"SUM(GR!$M$23:'GR'!$R$23)*12","v":0},{"$f":"SUM(GR!$M$23:'GR'!$R$23)*12","v":0}]
["Unterhaltsbeiträge Eintrag mit Steuerberechnung"]
["Aufwendungen für Säule 3a "]
["Versicherungsprämien (Erwachsene)",{"$f":"IF(SUM(GR!$D$23:'GR'!$E$23,GR!$D$25:'GR'!$E$25,GR!$E$36)*12>2600,2600,SUM(GR!$D$23:'GR'!$E$23,GR!$D$25:'GR'!$E$25,GR!$E$36)*12)","v":0},{"$f":"IF(SUM(GR!$D$23:'GR'!$E$23,GR!$D$25:'GR'!$E$25,GR!$E$36)*12>1700,1700,SUM(GR!$D$23:'GR'!$E$23,GR!$D$25:'GR'!$E$25,GR!$E$36)*12)","v":0},null,null,null,null,{"$f":"IF(SUM(GR!$M$23:'GR'!$N$23,GR!$M$25:'GR'!$N$25,GR!$N$36)*12>2600,2600,SUM(GR!$M$23:'GR'!$N$23,GR!$M$25:'GR'!$N$25,GR!$N$36)*12)","v":0},{"$f":"IF(SUM(GR!$M$23:'GR'!$N$23,GR!$M$25:'GR'!$N$25,GR!$N$36)*12>1700,1700,SUM(GR!$M$23:'GR'!$N$23,GR!$M$25:'GR'!$N$25,GR!$N$36)*12)","v":0}]
["Versicherungsprämien (Kinder)",{"$f":"MIN(RawData!$E$4*1300,RawData!$E$4*SUM(GR!$F$25:$I$25)*12)","v":0},{"$f":"MIN(RawData!$E$4*700,RawData!$E$4*SUM(GR!$F$25:$I$25)*12)","v":0},null,null,null,null,{"$f":"MIN(1300*RawData!$F$4,RawData!$F$4*SUM(RawData!$N$10*GR!$O$25+RawData!$N$11*GR!$P$25+RawData!$N$12*GR!$Q$25+RawData!$N$13*GR!$R$25)*12)","v":0},{"$f":"MIN(700*RawData!$F$4,RawData!$F$4*SUM(RawData!$N$10*GR!$O$25+RawData!$N$11*GR!$P$25+RawData!$N$12*GR!$Q$25+RawData!$N$13*GR!$R$25)*12)","v":0},null,null,null,null,null,"Gemeinsame Kinder - Zuteilung Abzüge prüfen"]
["Kosten Fremdbetreuung",{"$f":"MIN(10100*RawData!$E$4,SUM(GR!$F$27:$I$27)*12)","v":0},{"$f":"MIN(10100*RawData!$E$4,SUM(GR!$F$27:$I$27)*12)","v":0},null,null,null,null,{"$f":"MIN(10100*RawData!$F$4,SUM(MIN(10100,RawData!$N$10*GR!$O$27*12)+MIN(10100,RawData!$N$11*GR!$P$27*12)+MIN(10100,RawData!$N$12*GR!$Q$27*12)+MIN(10100,RawData!$N$13*GR!$R$27*12)))","v":0},{"$f":"MIN(10100*RawData!$F$4,SUM(MIN(10100,RawData!$N$10*GR!$O$27*12)+MIN(10100,RawData!$N$11*GR!$P$27*12)+MIN(10100,RawData!$N$12*GR!$Q$27*12)+MIN(10100,RawData!$N$13*GR!$R$27*12)))","v":0},null,null,null,null,null,"Gemeinsame Kinder - Zuteilung Abzüge prüfen"]
["Kinderabzüge ",{"$f":"COUNTIF(GR!$F$8:$I$8,\"<18\")*9000","v":0},{"$f":"COUNTIF(GR!$F$8:$I$8,\"<18\")*6500","v":0},null,null,null,null,{"$f":"SUM(COUNTIF(GR!$O$8,\"<18\")*SUM(RawData!$N$10*9000))+COUNTIF(GR!$P$8,\"<18\")*SUM(RawData!$N$11*9000)+COUNTIF(GR!$Q$8,\"<18\")*SUM(RawData!$N$12*9000)+COUNTIF(GR!$R$8,\"<18\")*SUM(RawData!$N$13*9000)","v":0},{"$f":"SUM(COUNTIF(GR!$O$8,\"<18\")*SUM(RawData!$N$10*6500))+COUNTIF(GR!$P$8,\"<18\")*SUM(RawData!$N$11*6500)+COUNTIF(GR!$Q$8,\"<18\")*SUM(RawData!$N$12*6500)+COUNTIF(GR!$R$8,\"<18\")*SUM(RawData!$N$13*6500)","v":0},null,null,null,null,null,"Gemeinsame Kinder - Zuteilung Abzüge prüfen"]
["weitere Schuldzinsen "]
["Weitere Position(en)"]
["Total der Abzüge",{"$f":"SUM(B18:B31)","v":0},{"$f":"SUM(C18:C31)","v":0},null,null,null,null,{"$f":"SUM(H18:H31)","v":0},{"$f":"SUM(I18:I31)","v":0}]
["Vermögen"]
["Grundstück"]
["Wertschriften"]
["Weitere Position"]
["Vermögen",{"$f":"SUM(B34:B36)","v":0},null,null,null,null,null,{"$f":"SUM(H34:H36)","v":0}]
["Steuerdaten"]
[null,"Steuerwerte",null,null,null,null,null,"Steuerwerte"]
["Steuerbares Einkommen",{"$f":"IF(B15-B32>0,B15-B32,0)","v":0},{"$f":"IF(C15-C32>0,C15-C32,0)","v":0},null,null,null,null,{"$f":"IF(H15-H32>0,H15-H32,0)","v":0},{"$f":"IF(I15-I32>0,I15-I32,0)","v":0}]
["Steuerbares Vermögen",{"$f":"IF(B37>0,B37,0)","v":0},null,null,null,null,null,{"$f":"IF(H37>0,H37,0)","v":0}]
[null,"Steuerfüsse",null,null,null,null,null,"Steuerfüsse"]
["Steuerfuss Kanton",{"$f":"TaxData!B4/100","v":0},null,null,null,null,null,{"$f":"TaxData!D4/100","v":0}]
["Steuerfuss Steuergemeinde",{"$f":"TaxData!B3/100","v":0},null,null,null,null,null,{"$f":"TaxData!D3/100","v":0}]
["Steuerfuss Kirchgemeinde",{"$f":"(TaxData!B9-TaxData!B3)/100","v":0},null,null,null,null,null,{"$f":"(TaxData!D9-TaxData!D3)/100","v":0}]
[null,"Einfache Staatsteuer",null,null,null,null,null,"Einfache Staatsteuer"]
["Einfache Staatssteuer (Einkommen)"]
["Einfache Staatssteuer (Vermögen)"]
["Total Einfache Staatssteuer",{"$f":"SUM(B47:B48)","v":0},null,null,null,null,null,{"$f":"SUM(H47:H48)","v":0}]
["Berechnungen"]
[null,"Staats- und Gemeindesteuer",null,null,null,null,null,"Staats- und Gemeindesteuer"]
["Staatssteuer Kanton"]
["Gemeindesteuer"]
["Kirchensteuer"]
["Personalsteuer (pauschal)"]
["Total Staats- und Gemeindesteuer",{"$f":"SUM(B52:B55)","v":0},null,null,null,null,null,{"$f":"SUM(H52:H55)","v":0}]
[null,"Direkte Bundessteuer ",null,null,null,null,null,"Direkte Bundessteuer "]
["Direkte Bundessteuer "]
["Ermässigung Kinderbetreung"]
["Total Direkte Bundessteuer",null,{"$f":"IF(SUM(C58-C59)>0,SUM(C58-C59),0)","v":0},null,null,null,null,null,{"$f":"IF(SUM(I58-I59)>0,SUM(I58-I59),0)","v":0}]
[null,"Verrechnungssteuerguthaben und Bedarf",null,null,null,null,null,"Verrechnungssteuerguthaben und Bedarf"]
["Abzüglich Verrechnungssteuerguthaben "]
["Gesamter jährlicher Steuerbetrag ",{"$f":"SUM($B$56+$C$60-$B$62)","v":0},null,null,null,null,null,{"$f":"SUM($H$56+$I$60-$H$62)","v":0}]
["Monatlicher Steuerbetrag/-bedarf",{"$f":"B63/12","v":0},null,{"$f":"D63/12","v":0},{"$f":"E63/12","v":0},{"$f":"F63/12","v":0},{"$f":"G63/12","v":0},{"$f":"H63/12","v":0},null,{"$f":"J63/12","v":0},{"$f":"K63/12","v":0},{"$f":"L63/12","v":0},{"$f":"M63/12","v":0}]

{"sheet":"Changes_ToDo","index":3,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":true,"merged":[[1,0,1,4],[44,0,44,4],[48,0,48,4],[4,0,4,4],[8,0,8,4],[13,0,13,4],[17,0,17,4],[23,0,23,4],[25,0,25,4],[28,0,28,4],[30,0,30,4],[32,0,32,4],[36,0,36,4],[34,0,34,4],[38,0,38,4],[40,0,40,4]]}
["Allgemein & Design","UserExperience","Formeln","Kommentare","Rechtliches"]
["Version 4.0f (31.03.2022)"]
["Implementierung StR_Beta (Staats- und Gemeindesteuern für Bezirke Meilen, Horgen, Uster und Zürich.","Rahmen in GR F27 und O27 (Barbedarf) auf linker Seite fehlt","GR Zeile 84:\nIm Beispiel 8 ergibt sich eine Differenz von Fr. 1.—zwischen GR B84 und GR B82 (verursacht rote Fehleranzeige). Diese Unschönheit wurde dadurch behoben, dass die Anteile in GR Zeile 84 nicht mehr gerundet werden.\n"]
["Umfassendes Redesing; Straffung und Neuanordnung Buttons, Kommentarfelder etc.",null,"StR_Beta Zeile 26:\nGestützt auf Rückmeldungen bin ich der Formel in StR Zeile 26 nachgegangen und habe festgestellt, dass in der neusten Testversion tatsächlich eine leicht veränderte Formel eingetragen ist. Dies erklärt sich dadurch, dass offenbar beim Test des Buttons «Formeln eintragen» für StR Zeile 26 noch eine ältere Version dieser Formel (wieder)eintragen worden ist. Dies wurde nun behoben, auch wurden sämtliche weiteren Formeln in StR Zeilen 18 bis 20, 22 und 25 bis 28 überprüft (stimmen überein). Ohnehin erweist sich auch die jetzige Formel in StR Zeile 26 wohl seit je her als nicht ganz richtig, ich kann dies dann gerne näher ausführen. Jedenfalls bleibt dieser Umstand ohne Einfluss auf die Berechnung von Unterhaltsbeiträgen, hat aber zur Folge, dass die Steuerabzüge in einigen der Beispiele um hohe drei- bis niedrige vierstellige Beträge anders ausfallen. Bevor Du diese Änderung der Formel «absegnest» warte ich noch damit ab, die aktuelle Testversion Dritten zum Test zu Verfügung zu stellen."]
["Version 4.0g (11.04.2022)"]
["Anpassung Zahlenformat (Feinjustierung noch nöctig) --> keine weitere Anpassung Zahlenformat mit Zusatz \".-\" (=  benutzerdefiniertes Format) empfehlenswert, da zu grosser Tempoverlust (je sichtbare Formatumwandlung bei jeder Zelleingabe)","Vermeidung doppelte Eingabe \"reduzierter Steuertarif\" mittels Warnfeld StR_Beta G6","Gelöscht redundante Formel GR B84 wegen Rundungsproblematiken und Differenz zu B82 (vgl. Beispiel 3)","Neuer Kommentar StR_Beta A6"]
["Anpassung Iterationsablauf, nunmehr wird die Grundberechnung in StR_Beta Zeile 66 eingetragen statt bereits die dreifach iterierten Steuerdaten (abrufbar unter Iteration AN/AUS). Dies gîbt dem Nutzer die Kontrolle zurück.","Änderung Ablauf Steuerberechnung und Iteration (siehe auch E-Mail vom 11.04.2022).",null,"Neuer Kommentar StR_Beta A66"]
["Erweiterung StR_Beta mit kompletten Staats- und Gemeindesteuern; Anpassung Aufbau an kantonalen StR",null,null,"Neuer Kommentar StR_Beta A61 zu Abzug Kinderbetreuung gem. Art. 36 Abs. 2bis DBG"]
["Version 4.0h (14.04.2022)"]
["Wiederherstellung Iterationsablauf StR_Beta gemäss Version 4.0f ",null,"StR_Beta Zeile 26:\nAnpassung Formel an § 31 lit. g StG ZH. Sowohl die alte Version der Formel als auch die Formulierung seit 4.0f war nicht ganz richtig (an Prüfbedingungen geknüpfte Maximal- statt Pauschalabzüge).","Leichte sprachliche Anpassung Kommentar StR_Beta A61"]
["Automatische Anpassung Druckbereiche im StR_Beta in Abhängigkeit der sichtbaren Zellen",null,"StR_Beta Zeile 28:\nKinderabzüge nur bei einem Alter <18 Jahre.","Anpassung Kommentar StR_Beta A66"]
["Vefreinerung Aufbau, Logik und Design Steuerberechnungen",null,"Aufgrund der obigen Änderung mussten bei den Formeln im GR Zeilen 8 bis 10 die Angaben \"Jahre\" etc. entfernen, ansonsten die aktuelle Funktion für die Berechnung in StR_Beta Zeile 28  (Zulässigkeit Abzug nur bei Minderjährigkeit) nicht korrekt rechnet (Datentypen). ","Ergänzung Beschriftung StR_Beta A66"]
["Anpassung der Einblendungen bei Beispielen in RT"]
["Version 4.0i (19.04.2022)"]
["Anpassung der automatisch wieder einsetzbaren Formeln im StR_Beta (siehe rechts unter Spalte \"Formeln\")",null,"StR_Beta Zeile 26:\nAnpassung Formel an § 31 lit. g StG ZH. Sowohl die alte Version der Formel als auch die Formulierung seit 4.0f war nicht ganz richtig (an Prüfbedingungen geknüpfte Maximal- statt Pauschalabzüge)."]
["GR Zeilen 8 bis 10 neu eingefärbt, weil automatisch errechnete Werte (keine Nutzereingaben)",null,"StR_Beta Zeile 28:\nKinderabzüge nur bei einem Alter <18 Jahre."]
[null,null,"Aufgrund der obigen Änderung mussten bei den Formeln im GR Zeilen 8 bis 10 die Angaben \"Jahre\" etc. entfernen, ansonsten die aktuelle Funktion für die Berechnung in StR_Beta Zeile 28  (Zulässigkeit Abzug nur bei Minderjährigkeit) nicht korrekt rechnet (Datentypen). "]
["Version 4.0j (29.04.2022)"]
["Unterscheidung Leistungsfähigkeit hervorgehoben (z.B. GR Zeile 3)",null,"StR_Beta Zeile 18: Übernahme Bedarfszahlen GR  auf gesetzliche Höchstbeträge (Fr. 5'000.- bzw. Fr. 3'000.-) beschränkt. Ebenfalls angepasst bei Formeln wiederherstellen.","Umfassende Anpassung/Ergänzung Kommentare StR_Beta (inkl. Bestimmungen StG ZH). Gleichzeitig auch Check nach Richtigkeit der Abzüge."]
["Button \"Einstellungen\" wieder auf allen Tabellenblättern vorhanden",null,"Formeln StR_Beta Zeile 43 an zusätzliche Bedingung (>0) genknüpft, ansonsten negative Resultate in StR_Beta Zeile 43 möglich sind."]
["Kommentarfelder auch für StR_Beta"]
["StR_Beta berechnet nun auch Beträge im Millionenbereich korrekt."]
["Optisch: Rahmenproblematik Ein- Ausblenden (wohl) gelöst"]
["Version 4.0k (02.05.2022)"]
["Anpassung Iterationsablauf"]
["Version 4.0l-o (bis 26.05.2022)"]
["Behebung Bugs 4.0k im GR gemäss Bugliste (Stand 4.Mai 2022) S. 1.",null,"Umfangreiche Anpassungen Formeln RT (siehe auch separate E-Mails und Bugliste)","Ergänzung Kommentar StR_Beta A63"]
[null,null,"Anpassung Formel Steueranteil Kind","Ergänzung Kommentar RT Zeile 18 betr. Betreuungsunterhalt"]
["Version 4.0p-q (bis 02.06.2022)"]
["Anpassung Eingabemaske an kleinere Bildschirme; allgemeine optische Anpassungen",null,"Umfangreiche Anpassungen Formeln RT (siehe auch separate E-Mails und Bugliste)"]
["Version 4.0r (08.06.2022)"]
["Anpassung Warnfelder RT (insbes. Spezifizierungen Manko)",null,"Umfangreiche Anpassungen Formeln RT (siehe auch separate E-Mails und Bugliste)","Anpassung Text RT Zelle A34"]
["Version 4.0s (13.06.2022)"]
["Anpassung Warnfelder RT (insbes. Spezifizierungen Manko)"]
["Version 4.0t (15.06.2022)"]
["Anpassung Warnfelder RT (insbes. Spezifizierungen Manko)"]
["Version 4.0u (16.06.2022)"]
["Anpassung Warnfelder RT (insbes. Spezifizierungen Manko)"]
["Version 4.0v (27.06.2022)"]
["Neuer Button StR zur Auswahl Steuergemeinde"]
["Version 4.0w (13.07.2022)"]
["Entfernung Link GR A21, A26, A38, A39 und A40",null,"Anpassung Formel StR Zeile 11","Anpassung Kommentar StR_Beta A11"]
["Komplette Steuerdaten 2018 bis 2022",null,"Präzisierung Formeln RT Zeile 20"]
[]
["Offene Fragen"]
[]
[]
[]
["Next Steps"]
["Manual --> geschätzter Aufwand (5/5)"]

{"sheet":"TaxData","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["TaxYear",{"$f":"StR!B5","v":0},null,{"$f":"StR!H5","v":0}]
["Municipality",{"$f":"RawData!AA1","v":"keine Auswahl"},null,{"$f":"RawData!AA2","v":"keine Auswahl"}]
["MunicipalityTaxFeet"]
["StateTaxFeet"]
["Confession",{"$f":"StR!B7","v":0},null,{"$f":"StR!H7","v":0}]
["RefTaxFeet"]
["KathTaxFeet"]
["ChrKathTaxFeet"]
["TotalTaxFeet"]
["Status",{"$f":"StR!B6","v":0},null,{"$f":"StR!H6","v":0}]
["TaxBasisSingle",{"$f":"TaxCalculation!E20","v":0},null,{"$f":"TaxCalculation!M20","v":0}]
["TaxBasisMarried",{"$f":"TaxCalculation!E39","v":0},null,{"$f":"TaxCalculation!M39","v":0}]
["FortuneTaxSingle",{"$f":"TaxCalculation!E52","v":0},null,{"$f":"TaxCalculation!M52","v":0}]
["FortuneTaxMarried",{"$f":"TaxCalculation!E65","v":0},null,{"$f":"TaxCalculation!M65","v":0}]
["FederalTaxSingle",{"$f":"TaxCalculation!F82","v":0},null,{"$f":"TaxCalculation!N82","v":0}]
["FederalTaxMarried",{"$f":"TaxCalculation!F104","v":0},null,{"$f":"TaxCalculation!N104","v":0}]

{"sheet":"RawData","index":5,"n_rows":31,"n_cols":36,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,19,0],[0,2,19,2],[0,6,19,6],[0,10,19,10],[0,14,19,14],[14,12,14,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[0,34,19,34],[0,16,19,16],[0,31,19,31],[0,27,19,27],[0,25,19,25],[0,23,19,23],[0,21,19,21]]}
["Makros","(1) Mankofall","Eingabefenster - MultiPage 0 (Anzahl Kinder etc.)",0,null,"","Eingabefenster - MultiPage1 (Phasen)",1,1,null,"Eingabefenster - MultiPage 0","Ja","Nein","Nein","Eingabefenster - MultiPage1 (Weitere Optionen)",null,"GR - Fahrtkosten PW",1,1,0.1,null,"GR - ErwBedarf","Erw. Bedarf EIN","Kommentarfelder (GR und StR)",null,"StR - Steuergemeinde","keine Auswahl","StR - ResetFormula","Zeile 18 - Mobilitätskosten",null,null,"Diverses",null,null,"Booleans (Gem. Kinder / Wohnsitz)",false]
[null,"(2) Einverdienerehe",null,1,"","",null,2,null,null,null,"Nein",null,null,null,null,null,2,{"$f":"S1+1","v":2},0.2,null,null,"Erw. Bedarf AUS",null,null,null,"keine Auswahl",null,"Zeile 19 - Verpflegungskosten",null,null,null,null,null,null,false]
[null,"(3) Zuverdienerehe",null,2,"","",null,3,null,null,null,null,null,null,null,null,null,3,{"$f":"S2+1","v":3},0.3,null,null,null,null,null,null,null,null,"Zeile 20 - Berufskosten",null,null,null,null,null,null,false]
[null,"(4) Alternierende Obhut",null,3,"0","0",null,4,null,null,null,null,null,null,null,null,null,4,{"$f":"S3+1","v":4},0.4,null,null,null,null,null,null,null,null,"Zeile 23 - Hypothekarzinsen",null,null,null,null,null,null,false]
[null,"(5) Einstufige Berechnung",null,4,"","",null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"S4+1","v":5},0.5,{"$f":"IF(AND(U2<>\"\",U3<>\"\",U4<>\"\"),SUM(U2*U3*U4),IF(AND(U2<>\"\",U3<>\"\",U4=\"\"),SUM(U2*U3),IF(AND(U2<>\"\",U3=\"\",U4<>\"\"),SUM(U2*U4),IF(AND(U2<>\"\",U3=\"\",U4=\"\"),U2,IF(AND(U2=\"\",U3<>\"\",U4<>\"\"),\"\",IF(AND(U2=\"\",U3=\"\",U4=\"\"),\"\",\"\"))))))","v":""},null,null,null,null,null,null,null,"Zeile 26 - Versicherungsprämien (Erwachsene)"]
[null,"(6) Mann hat Kind aus neuer Beziehung",null,null,"","",null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"S5+1","v":6},0.6,{"$f":"IF(U1=\"\",\"\",IF(U5=\"\",\"\",SUM(U1*U5)))","v":""},null,null,null,null,null,null,null,"Zeile 27 - Versicherungsprämien (Kinder)",null,null,null,null,null,null,true]
[null,"(7) Frau hat Kind aus neuer Beziehung",null,"verheiratet","","",null,null,null,null,null,null,null,0,null,null,null,null,7,0.7,null,null,null,null,null,null,null,null,"Zeile 28 - Kosten Fremdbetreuung",null,null,null,null,null,null,true]
[null,"(8) Kinder leben im Haushalt des leistungsfähigeren Elternteils",null,"ledig","","",null,null,null,null,null,null,null,0,null,null,null,null,8,0.8,null,null,null,null,null,null,null,null,"Zeile 29 - Kinderabzüge",null,null,null,null,null,null,true]
[null,null,null,null,"","",null,null,null,null,null,null,null,0,null,null,null,null,9,0.9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,"verheiratet","","",null,null,null,null,null,null,null,{"$f":"IF($N$6=1,0,1)","v":1},null,null,null,null,10,1]
[null,"[Beispiele folgen]",null,null,"","",null,null,null,null,null,null,null,{"$f":"IF($N$7=1,0,1)","v":1},null,null,null,null,11]
[null,null,null,null,"","",null,null,null,null,null,null,null,{"$f":"IF($N$8=1,0,1)","v":1},null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N$9=1,0,1)","v":1},null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
["Steuerbedarf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
["Wert StR_Beta",{"$f":"RT!B43*12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]

{"sheet":"TaxCalculation","index":6,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":true,"merged":[[66,1,66,5],[66,9,66,13],[83,1,83,5],[83,9,83,13],[0,0,0,6],[0,8,0,12],[2,0,2,4],[2,8,2,12],[21,0,21,4],[21,8,21,12],[40,0,40,4],[40,8,40,12],[53,0,53,4],[53,8,53,12]]}
["Für den unterhaltsberechtigten Elternteil",null,null,null,null,null,null,null,"Für den unterhaltspflichtigen Elternteil"]
[]
["§ 35 Abs. 1 StG: Grundtarif (seit 01.12.2012)",null,null,null,null,null,null,null,"§ 35 Abs. 1 StG: Grundtarif (seit 01.12.2012)"]
["Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme",null,null,null,"Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme"]
[0,{"$f":"StR!B40","v":0},null,null,null,null,null,null,0,{"$f":"StR!H40","v":0}]
[6700,{"$f":"B5-A6","v":-6700},0,{"$f":"C6*A6","v":0},null,null,null,null,6700,{"$f":"J5-I6","v":-6700},0,{"$f":"K6*I6","v":0}]
[4700,-11400,0.02,94,{"$f":"IF(B6>0,IF(B6<A7,B6*C7,D7),0)","v":0},null,null,null,4700,-11400,0.02,94,{"$f":"IF(J6>0,IF(J6<I7,J6*K7,L7),0)","v":0}]
[4700,-16100,0.03,141,0,null,null,null,4700,-16100,0.03,141,0]
[7600,-23700,0.04,304,0,null,null,null,7600,-23700,0.04,304,0]
[9300,-33000,0.05,465,0,null,null,null,9300,-33000,0.05,465,0]
[10700,-43700,0.06,642,0,null,null,null,10700,-43700,0.06,642,0]
[12400,-56100,7.0000000000000007E-2,868.00000000000011,0,null,null,null,12400,-56100,7.0000000000000007E-2,868.00000000000011,0]
[16900,-73000,0.08,1352,0,null,null,null,16900,-73000,0.08,1352,0]
[32500,-105500,0.09,2925,0,null,null,null,32500,-105500,0.09,2925,0]
[32200,-137700,0.1,3220,0,null,null,null,32200,-137700,0.1,3220,0]
[51000,-188700,0.11,5610,0,null,null,null,51000,-188700,0.11,5610,0]
[66200,-254900,0.12,7944,0,null,null,null,66200,-254900,0.12,7944,0]
["darüber",{"$f":"B17","v":-254900},0.13,{"$f":"IF(B17>0,B17*C18,0)","v":0},{"$f":"IF(B17>0,B17*C18,0)","v":0},null,null,null,"darüber",{"$f":"J17","v":-254900},0.13,{"$f":"IF(J17>0,J17*K18,0)","v":0},{"$f":"IF(J17>0,J17*K18,0)","v":0}]
[]
[null,null,null,"Total",{"$f":"SUM(E6:E19)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M6:M19)","v":0}]
[]
["§ 35 Abs. 1 StG: Elterntarif (seit 01.12.2012)",null,null,null,null,null,null,null,"§ 35 Abs. 1 StG: Elterntarif (seit 01.12.2012)"]
["Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme",null,null,null,"Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme"]
[0,{"$f":"StR!B40","v":0},null,null,null,null,null,null,0,{"$f":"StR!H40","v":0}]
[13500,{"$f":"B24-A25","v":-13500},0,{"$f":"C25*A25","v":0},null,null,null,null,13500,{"$f":"J24-I25","v":-13500},0,{"$f":"K25*I25","v":0}]
[6100,-19600,0.02,{"$f":"C26*A26","v":122},{"$f":"IF(B25>0,IF(B25<A26,B25*C26,D26),0)","v":0},null,null,null,6100,-19600,0.02,{"$f":"K26*I26","v":122},{"$f":"IF(J25>0,IF(J25<I26,J25*K26,L26),0)","v":0}]
[7700,-27300,0.03,231,0,null,null,null,7700,-27300,0.03,231,0]
[9400,-36700,0.04,376,0,null,null,null,9400,-36700,0.04,376,0]
[10700,-47400,0.05,535,0,null,null,null,10700,-47400,0.05,535,0]
[13900,-61300,0.06,834,0,null,null,null,13900,-61300,0.06,834,0]
[30800,-92100,7.0000000000000007E-2,2156,0,null,null,null,30800,-92100,7.0000000000000007E-2,2156,0]
[30800,-122900,0.08,2464,0,null,null,null,30800,-122900,0.08,2464,0]
[46400,-169300,0.09,4176,0,null,null,null,46400,-169300,0.09,4176,0]
[55400,-224700,0.1,5540,0,null,null,null,55400,-224700,0.1,5540,0]
[60100,-284800,0.11,6611,0,null,null,null,60100,-284800,0.11,6611,0]
[69300,-354100,0.12,8316,0,null,null,null,69300,-354100,0.12,8316,0]
["darüber",{"$f":"B36","v":-354100},0.13,{"$f":"IF(B36>0,B36*C37,0)","v":0},{"$f":"IF(B36>0,B36*C37,0)","v":0},null,null,null,"darüber",{"$f":"J36","v":-354100},0.13,{"$f":"IF(J36>0,J36*K37,0)","v":0},{"$f":"IF(J36>0,J36*K37,0)","v":0}]
[]
[null,null,null,"Total",{"$f":"SUM(E25:E38)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M25:M38)","v":0}]
[]
["§ 47 Abs. 1 StG: Grundtarif (seit 01.12.2013)",null,null,null,null,null,null,null,"§ 47 Abs. 1 StG: Grundtarif (seit 01.12.2013)"]
["Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme",null,null,null,"Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme"]
[0,{"$f":"StR!B37","v":0},null,null,null,null,null,null,0,{"$f":"StR!H37","v":0}]
[77000,{"$f":"B43-A44","v":-77000},0,{"$f":"C44*A44","v":0},null,null,null,null,77000,{"$f":"J43-I44","v":-77000},0,{"$f":"K44*I44","v":0}]
[231000,-308000,5.0000000000000001E-4,115.5,{"$f":"IF(B44>0,IF(B44<A45,B44*C45,D45),0)","v":0},null,null,null,231000,-308000,5.0000000000000001E-4,115.5,{"$f":"IF(J44>0,IF(J44<I45,J44*K45,L45),0)","v":0}]
[386000,-694000,1E-3,386,0,null,null,null,386000,-694000,1E-3,386,0]
[616000,-1310000,1.5E-3,924,0,null,null,null,616000,-1310000,1.5E-3,924,0]
[925000,-2235000,2E-3,1850,0,null,null,null,925000,-2235000,2E-3,1850,0]
[923000,-3158000,2.5000000000000001E-3,2307.5,0,null,null,null,923000,-3158000,2.5000000000000001E-3,2307.5,0]
["darüber",{"$f":"B49","v":-3158000},3.0000000000000001E-3,{"$f":"IF(B49>0,ROUNDDOWN(B49/100,0)*100*C50,0)","v":0},0,null,null,null,"darüber",{"$f":"J49","v":-3158000},3.0000000000000001E-3,{"$f":"IF(J49>0,ROUNDDOWN(J49/100,0)*100*K50,0)","v":0},0]
[]
[null,null,null,"Total",{"$f":"SUM(E44:E51)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M44:M51)","v":0}]
[]
["§ 47 Abs. 2 StG: Elterntarif (seit 01.12.2013)",null,null,null,null,null,null,null,"§ 47 Abs. 2 StG: Elterntarif (seit 01.12.2013)"]
["Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme",null,null,null,"Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme"]
[0,{"$f":"StR!B37","v":0},null,null,null,null,null,null,0,{"$f":"StR!H37","v":0}]
[154000,{"$f":"B56-A57","v":-154000},0,{"$f":"C57*A57","v":0},null,null,null,null,154000,{"$f":"J56-I57","v":-154000},0,{"$f":"K57*I57","v":0}]
[231000,-385000,5.0000000000000001E-4,115.5,{"$f":"IF(B57>0,IF(B57<A58,B57*C58,D58),0)","v":0},null,null,null,231000,-385000,5.0000000000000001E-4,115.5,{"$f":"IF(J57>0,IF(J57<I58,J57*K58,L58),0)","v":0}]
[385000,-770000,1E-3,385,0,null,null,null,385000,-770000,1E-3,385,0]
[616000,-1386000,1.5E-3,924,0,null,null,null,616000,-1386000,1.5E-3,924,0]
[925000,-2311000,2E-3,1850,0,null,null,null,925000,-2311000,2E-3,1850,0,null,null,"WENN(K81>0;ABRUNDEN(K81/100;0)*100*L82;0)"]
[924000,-3235000,2.5000000000000001E-3,2310,0,null,null,null,924000,-3235000,2.5000000000000001E-3,2310,0]
["darüber",{"$f":"B62","v":-3235000},3.0000000000000001E-3,{"$f":"IF(B62>0,ROUNDDOWN(B62/100,0)*100*C63,0)","v":0},0,null,null,null,"darüber",{"$f":"J62","v":-3235000},3.0000000000000001E-3,{"$f":"IF(J62>0,ROUNDDOWN(J62/100,0)*100*K63,0)","v":0},0]
[]
[null,null,null,"Total",{"$f":"SUM(E57:E64)","v":0},null,null,null,null,null,null,"Total",{"$f":"SUM(M57:M64)","v":0}]
[]
[null,"Art. 36 Abs. 1 DBG (Schwellen seit 01.01.2014)",null,null,null,null,null,null,null,"Art. 36 Abs. 1 DBG (Schwellen seit 01.01.2014)"]
["Schwellen","Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme","Prüfung",null,"Schwellen","Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme","Prüfung"]
[0,0,{"$f":"StR!C40","v":0},null,null,null,null,null,0,0,{"$f":"StR!I40","v":0}]
[14500,14500,{"$f":"C69-B70","v":-14500},0,{"$f":"D70*B70","v":0},null,{"$f":"E70","v":0},null,14500,14500,{"$f":"K69-J70","v":-14500},0,{"$f":"L70*J70","v":0},null,{"$f":"M70","v":0}]
[31600,{"$f":"A71-A70","v":17100},-31600,7.7000000000000002E-3,131.67000000000002,{"$f":"IF(C70>0,IF(C70<B71,100*ROUNDDOWN(C70/100,0)*D71,E71),0)","v":0},{"$f":"E71","v":131.67000000000002},null,31600,{"$f":"I71-I70","v":17100},-31600,7.7000000000000002E-3,131.67000000000002,{"$f":"IF(K70>0,IF(K70<J71,100*ROUNDDOWN(K70/100,0)*L71,M71),0)","v":0},{"$f":"M71","v":131.67000000000002}]
[41400,9800,-41400,8.8000000000000005E-3,86.240000000000009,0,{"$f":"E71+E72","v":217.91000000000003},null,41400,9800,-41400,8.8000000000000005E-3,86.240000000000009,0,{"$f":"M71+M72","v":217.91000000000003}]
[55200,13800,-55200,2.64E-2,364.32,0,{"$f":"G72+E73","v":582.23},null,55200,13800,-55200,2.64E-2,364.32,0,{"$f":"O72+M73","v":582.23}]
[72500,17300,-72500,2.9700000000000001E-2,513.81000000000006,0,1096.04,null,72500,17300,-72500,2.9700000000000001E-2,513.81000000000006,0,1096.04]
[78100,5600,-78100,5.9400000000000001E-2,332.64,0,1428.6799999999998,null,78100,5600,-78100,5.9400000000000001E-2,332.64,0,1428.6799999999998]
[103600,25500,-103600,6.6000000000000003E-2,1683,0,3111.68,null,103600,25500,-103600,6.6000000000000003E-2,1683,0,3111.68]
[134600,31000,-134600,8.7999999999999995E-2,2728,0,5839.68,null,134600,31000,-134600,8.7999999999999995E-2,2728,0,5839.68]
[176000,41400,-176000,0.11,4554,0,10393.68,null,176000,41400,-176000,0.11,4554,0,10393.68]
[755200,579200,-755200,0.13200000000000001,76454.400000000009,0,86848.080000000016,null,755200,579200,-755200,0.13200000000000001,76454.400000000009,0,86848.080000000016]
["darüber",null,{"$f":"C79","v":-755200},0.115,{"$f":"IF(C79>0,ROUNDDOWN(C79/100,0)*100*D80,0)","v":0},{"$f":"IF(C79>0,ROUNDDOWN(C79/100,0)*100*D80,0)","v":0},null,null,"darüber",null,{"$f":"K79","v":-755200},0.115,{"$f":"IF(K79>0,ROUNDDOWN(K79/100,0)*100*L80,0)","v":0},{"$f":"IF(K79>0,ROUNDDOWN(K79/100,0)*100*L80,0)","v":0}]
[]
[null,null,null,null,"Total",{"$f":"IF(SUM(F70:F80)>25,SUM(F70:F80),0)","v":0},null,null,null,null,null,null,"Total",{"$f":"IF(SUM(N70:N80)>25,SUM(N70:N80),0)","v":0}]
[]
[null,"Art. 36 Abs. 2 und Abs. 2bis DBG (Schwellen seit 01.01.2014)",null,null,null,null,null,null,null,"Art. 36 Abs. 2 und Abs. 2bis DBG (Schwellen seit 01.01.2014)"]
["Schwellen","Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme","Prüfung",null,"Schwellen","Einkommensteil","Einkommensrest","Steuersatz","Steuerteil","Steuersumme","Prüfung"]
[null,0,{"$f":"StR!C40","v":0},null,null,null,null,null,null,0,{"$f":"StR!I40","v":0}]
[28300,28300,{"$f":"C86-B87","v":-28300},0,{"$f":"D87*B87","v":0},null,{"$f":"E87","v":0},null,28300,28300,{"$f":"K86-J87","v":-28300},0,{"$f":"L87*J87","v":0},null,{"$f":"M87","v":0}]
[50900,{"$f":"A88-A87","v":22600},-50900,0.01,226,{"$f":"IF(C87>0,IF(C87<B88,100*ROUNDDOWN(C87/100,0)*D88,E88),0)","v":0},{"$f":"E88","v":226},null,50900,{"$f":"I88-I87","v":22600},-50900,0.01,226,{"$f":"IF(K87>0,IF(K87<J88,100*ROUNDDOWN(K87/100,0)*L88,M88),0)","v":0},{"$f":"M88","v":226}]
[58400,7500,-58400,0.02,150,0,{"$f":"E88+E89","v":376},null,58400,7500,-58400,0.02,150,0,{"$f":"M88+M89","v":376}]
[75300,16900,-75300,0.03,507,0,{"$f":"G89+E90","v":883},null,75300,16900,-75300,0.03,507,0,{"$f":"O89+M90","v":883}]
[90300,15000,-90300,0.04,600,0,1483,null,90300,15000,-90300,0.04,600,0,1483]
[103400,13100,-103400,0.05,655,0,2138,null,103400,13100,-103400,0.05,655,0,2138]
[114700,11300,-114700,0.06,678,0,2816,null,114700,11300,-114700,0.06,678,0,2816]
[124200,9500,-124200,7.0000000000000007E-2,665.00000000000011,0,3481,null,124200,9500,-124200,7.0000000000000007E-2,665.00000000000011,0,3481]
[131700,7500,-131700,0.08,600,0,4081,null,131700,7500,-131700,0.08,600,0,4081]
[137300,5600,-137300,0.09,504,0,4585,null,137300,5600,-137300,0.09,504,0,4585]
[141200,3900,-141200,0.1,390,0,4975,null,141200,3900,-141200,0.1,390,0,4975]
[143100,1900,-143100,0.11,209,0,5184,null,143100,1900,-143100,0.11,209,0,5184]
[145000,1900,-145000,0.12,228,0,5412,null,145000,1900,-145000,0.12,228,0,5412]
[895800,750800,-895800,0.13,97604,0,103016,null,895800,750800,-895800,0.13,97604,0,103016]
[895900,100,-895900,0.13,13,0,103029,null,895900,100,-895900,0.13,13,0,103029]
["darüber",null,{"$f":"C101","v":-895900},0.115,{"$f":"IF(C101>0,ROUNDDOWN(C79/100,0)*100*D102,0)","v":0},{"$f":"IF(C101>0,ROUNDDOWN(C79/100,0)*100*D102,0)","v":0},null,null,"darüber",null,{"$f":"K101","v":-895900},0.115,{"$f":"IF(K101>0,ROUNDDOWN(K79/100,0)*100*L102,0)","v":0},{"$f":"IF(K101>0,ROUNDDOWN(K79/100,0)*100*L102,0)","v":0}]
[]
[null,null,null,null,"Total",{"$f":"IF(SUM(F87:F102)>25,SUM(F87:F102),0)","v":0},null,null,null,null,null,null,"Total",{"$f":"IF(SUM(N87:N102)>25,SUM(N87:N102),0)","v":0}]

{"sheet":"TaxFeetMunicipalities2018","index":7,"n_rows":163,"n_cols":6,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["BFS","Gemeinde","andere","reformiert","katholisch","christ-katholisch"]
[21,"Adlikon",124,136,138,138]
[131,"Adliswil",100,110,108,114]
[241,"Aesch",87,98,98,101]
[1,"Aeugst a.A.",95,107,108,109]
[2,"Affoltern a.A.",124,136,137,138]
[211,"Altikon",114,126,127,128]
[30,"Andelfingen",112,124,126,126]
[51,"Bachenbülach",106,116,117,120]
[81,"Bachs",127,141,138,141]
[111,"Bäretswil",102,116,116,116]
[52,"Bassersdorf",109,121,118,123]
[297,"Bauma",120,134,134,134]
[22,"Benken",114,128,128,128]
[23,"Berg a.I.",98,110,111,112]
[242,"Birmensdorf",110,121,121,124]
[3,"Bonstetten",109,122,120,123]
[82,"Boppelsen",94,107,104,108]
[213,"Brütten",89,102,102,103]
[112,"Bubikon",118,130,131,132]
[24,"Buch a.I.",106,118,119,120]
[83,"Buchs",110,121,120,124]
[53,"Bülach",110,120,121,124]
[25,"Dachsen",109,121,123,123]
[214,"Dägerlen",117,131,130,131]
[84,"Dällikon",108,119,118,122]
[85,"Dänikon",120,131,130,134]
[215,"Dättlikon",114,128,127,128]
[86,"Dielsdorf",105,116,116,119]
[243,"Dietikon",123,135,136,137]
[54,"Dietlikon",98,110,106,112]
[216,"Dinhard",87,99,100,101]
[26,"Dorf",109,123,122,123]
[191,"Dübendorf",99,110,109,113]
[113,"Dürnten",115,129,128,129]
[192,"Egg",98,110,107,112]
[55,"Eglisau",113,127,126,127]
[294,"Elgg",117,131,131,131]
[218,"Ellikon a.d.Th.",119,131,132,133]
[219,"Elsau",118,132,131,132]
[56,"Embrach",118,130,131,132]
[151,"Erlenbach",79,88,86,93]
[193,"Fällanden",103,114,113,117]
[172,"Fehraltorf",107,120,120,121]
[27,"Feuerthalen",114,128,128,128]
[114,"Fischenthal",124,138,138,138]
[28,"Flaach",107,119,120,121]
[29,"Flurlingen",112,124,126,126]
[57,"Freienstein-Teufen",99,113,112,113]
[244,"Geroldswil",108,119,117,122]
[58,"Glattfelden",120,134,133,134]
[115,"Gossau",119,133,133,133]
[194,"Greifensee",94,105,104,108]
[116,"Grüningen",113,127,126,127]
[220,"Hagenbuch",114,128,128,128]
[4,"Hausen a.A.",112,126,126,126]
[5,"Hedingen",105,117,118,119]
[31,"Henggart",100,114,113,114]
[152,"Herrliberg",78,87,86,92]
[221,"Hettlingen",96,109,109,110]
[117,"Hinwil",112,124,128,126]
[173,"Hittnau",116,130,129,130]
[59,"Hochfelden",116,126,127,130]
[153,"Hombrechtikon",119,133,132,133]
[295,"Horgen",87,97,95,101]
[60,"Höri",117,127,128,131]
[32,"Humlikon",123,135,137,137]
[61,"Hüntwangen",104,118,117,118]
[87,"Hüttikon",119,132,129,133]
[296,"Illnau-Effretikon",110,123,123,124]
[6,"Kappel a.A.",102,116,116,116]
[135,"Kilchberg",72,81,78,86]
[33,"Kleinandelfingen",110,122,124,124]
[62,"Kloten",103,113,112,117]
[7,"Knonau",117,131,131,131]
[154,"Küsnacht",77,84,84,91]
[136,"Langnau a.A.",106,116,120,120]
[34,"Laufen-Uhwiesen",102,114,116,116]
[176,"Lindau",108,120,121,122]
[63,"Lufingen",89,101,102,103]
[155,"Männedorf",95,107,106,109]
[35,"Marthalen",109,123,123,123]
[8,"Maschwanden",129,143,143,143]
[195,"Maur",87,96,96,101]
[156,"Meilen",84,93,91,98]
[9,"Mettmenstetten",99,111,113,113]
[196,"Mönchaltorf",111,124,120,125]
[88,"Neerach",76,88,87,90]
[223,"Neftenbach",107,116,120,121]
[89,"Niederglatt",107,120,118,121]
[90,"Niederhasli",116,129,127,130]
[91,"Niederweningen",104,114,115,118]
[64,"Nürensdorf",90,102,99,104]
[65,"Oberembrach",117,129,130,131]
[245,"Oberengstringen",112,122,125,126]
[92,"Oberglatt",122,135,133,136]
[137,"Oberrieden",88,100,99,102]
[93,"Oberweningen",98,108,109,112]
[10,"Obfelden",121,133,134,135]
[246,"Oetwil a.d.L.",103,114,112,117]
[157,"Oetwil a.S.",119,133,128,133]
[66,"Opfikon",94,102,101,108]
[37,"Ossingen",99,113,113,113]
[94,"Otelfingen",110,123,120,124]
[11,"Ottenbach",117,131,130,131]
[177,"Pfäffikon",113,125,126,127]
[224,"Pfungen",117,129,130,131]
[67,"Rafz",113,127,126,127]
[95,"Regensberg",106,120,117,120]
[96,"Regensdorf",118,129,128,132]
[38,"Rheinau",118,132,132,132]
[138,"Richterswil",101,113,116,115]
[225,"Rickenbach",106,118,119,120]
[12,"Rifferswil",125,139,139,139]
[68,"Rorbas",103,117,116,117]
[97,"Rümlang",109,123,120,123]
[139,"Rüschlikon",73,83,83,87]
[178,"Russikon",113,125,126,127]
[118,"Rüti",121,135,134,135]
[226,"Schlatt",125,139,137,139]
[98,"Schleinikon",110,120,121,124]
[247,"Schlieren",111,122,123,125]
[99,"Schöfflisdorf",101,111,112,115]
[197,"Schwerzenbach",99,110,109,113]
[119,"Seegräben",115,127,129,129]
[227,"Seuzach",99,111,112,113]
[100,"Stadel",110,124,123,124]
[158,"Stäfa",88,99,100,102]
[13,"Stallikon",101,109,112,115]
[292,"Stammheim",124,138,138,138]
[101,"Steinmaur",114,126,125,128]
[39,"Thalheim a.d.Th.",102,114,115,116]
[141,"Thalwil",85,95,95,99]
[40,"Trüllikon",114,128,128,128]
[41,"Truttikon",118,132,132,132]
[228,"Turbenthal",126,140,139,140]
[159,"Uetikon a.S.",87,98,98,101]
[248,"Uitikon",80,90,91,94]
[249,"Unterengstringen",100,111,113,114]
[250,"Urdorf",118,128,129,132]
[198,"Uster",112,123,122,126]
[43,"Volken",111,123,124,125]
[199,"Volketswil",103,112,113,117]
[293,"Wädenswil",105,116,117,119]
[120,"Wald",122,136,138,136]
[69,"Wallisellen",97,105,105,111]
[200,"Wangen-Brüttisellen",101,112,109,115]
[70,"Wasterkingen",116,130,129,130]
[102,"Weiach",89,100,102,103]
[251,"Weiningen",103,114,112,117]
[180,"Weisslingen",106,119,118,120]
[14,"Wettswil a.A.",85,93,96,99]
[121,"Wetzikon",119,133,133,133]
[298,"Wiesendangen",90,104,103,104]
[71,"Wil",106,120,119,120]
[181,"Wila",129,143,142,143]
[182,"Wildberg",129,143,142,143]
[72,"Winkel",76,86,87,90]
[230,"Winterthur",125,138,141,139]
[231,"Zell",118,132,130,132]
[161,"Zollikon",85,93,94,99]
[160,"Zumikon",85,94,94,99]
[261,"Zürich",119,129,129,133]

{"sheet":"ListMunicipalities","index":8,"n_rows":163,"n_cols":11,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["Gemeinde","s","Excel Dropdown mit Suchfunktion erstellen - durchsuchbare Dropdownliste (Autovervollständigung) - YouTube"]
["Adlikon",{"$f":"SEARCH($B$1,Gemeinde)","v":{"$error":"#VALUE!"}},"Excel # 425 - Datenüberprüfung mit Suche - Dropdown mit Suchfunktion - Teil 1 - YouTube",null,null,null,null,null,null,null,"Teil 1"]
["Adliswil",5,"Excel # 426 - Dropdown mit Suchfunktion - Teil 2 - Leerzeilen vermeiden - YouTube",null,null,null,null,null,null,null,"Teil 2"]
["Aesch",3]
["Aeugst a.A.",5]
["Affoltern a.A.",{"$error":"#VALUE!"}]
["Altikon",{"$error":"#VALUE!"}]
["Andelfingen",{"$error":"#VALUE!"}]
["Bachenbülach",{"$error":"#VALUE!"}]
["Bachs",5]
["Bäretswil",6]
["Bassersdorf",3]
["Bauma",{"$error":"#VALUE!"}]
["Benken",{"$error":"#VALUE!"}]
["Berg a.I.",{"$error":"#VALUE!"}]
["Birmensdorf",7]
["Bonstetten",4]
["Boppelsen",7]
["Brütten",{"$error":"#VALUE!"}]
["Bubikon",{"$error":"#VALUE!"}]
["Buch a.I.",{"$error":"#VALUE!"}]
["Buchs",5]
["Bülach",{"$error":"#VALUE!"}]
["Dachsen",5]
["Dägerlen",{"$error":"#VALUE!"}]
["Dällikon",{"$error":"#VALUE!"}]
["Dänikon",{"$error":"#VALUE!"}]
["Dättlikon",{"$error":"#VALUE!"}]
["Dielsdorf",5]
["Dietikon",{"$error":"#VALUE!"}]
["Dietlikon",{"$error":"#VALUE!"}]
["Dinhard",{"$error":"#VALUE!"}]
["Dorf",{"$error":"#VALUE!"}]
["Dübendorf",{"$f":"SEARCH($B$1,Gemeinde)","v":{"$error":"#VALUE!"}}]
["Dürnten",{"$error":"#VALUE!"}]
["Egg",{"$error":"#VALUE!"}]
["Eglisau",5]
["Elgg",{"$error":"#VALUE!"}]
["Ellikon a.d.Th.",{"$error":"#VALUE!"}]
["Elsau",3]
["Embrach",{"$error":"#VALUE!"}]
["Erlenbach",{"$error":"#VALUE!"}]
["Fällanden",{"$error":"#VALUE!"}]
["Fehraltorf",{"$error":"#VALUE!"}]
["Feuerthalen",{"$error":"#VALUE!"}]
["Fischenthal",3]
["Flaach",{"$error":"#VALUE!"}]
["Flurlingen",{"$error":"#VALUE!"}]
["Freienstein-Teufen",7]
["Geroldswil",7]
["Glattfelden",{"$error":"#VALUE!"}]
["Gossau",3]
["Greifensee",8]
["Grüningen",{"$error":"#VALUE!"}]
["Hagenbuch",{"$error":"#VALUE!"}]
["Hausen a.A.",4]
["Hedingen",{"$error":"#VALUE!"}]
["Henggart",{"$error":"#VALUE!"}]
["Herrliberg",{"$error":"#VALUE!"}]
["Hettlingen",{"$error":"#VALUE!"}]
["Hinwil",{"$error":"#VALUE!"}]
["Hittnau",{"$error":"#VALUE!"}]
["Hochfelden",{"$error":"#VALUE!"}]
["Hombrechtikon",{"$error":"#VALUE!"}]
["Horgen",{"$error":"#VALUE!"}]
["Höri",{"$f":"SEARCH($B$1,Gemeinde)","v":{"$error":"#VALUE!"}}]
["Humlikon",{"$error":"#VALUE!"}]
["Hüntwangen",{"$error":"#VALUE!"}]
["Hüttikon",{"$error":"#VALUE!"}]
["Illnau-Effretikon",{"$error":"#VALUE!"}]
["Kappel a.A.",{"$error":"#VALUE!"}]
["Kilchberg",{"$error":"#VALUE!"}]
["Kleinandelfingen",{"$error":"#VALUE!"}]
["Kloten",{"$error":"#VALUE!"}]
["Knonau",{"$error":"#VALUE!"}]
["Küsnacht",3]
["Langnau a.A.",{"$error":"#VALUE!"}]
["Laufen-Uhwiesen",13]
["Lindau",{"$error":"#VALUE!"}]
["Lufingen",{"$error":"#VALUE!"}]
["Männedorf",{"$error":"#VALUE!"}]
["Marthalen",{"$error":"#VALUE!"}]
["Maschwanden",3]
["Maur",{"$error":"#VALUE!"}]
["Meilen",{"$error":"#VALUE!"}]
["Mettmenstetten",8]
["Mönchaltorf",{"$error":"#VALUE!"}]
["Neerach",{"$error":"#VALUE!"}]
["Neftenbach",{"$error":"#VALUE!"}]
["Niederglatt",{"$error":"#VALUE!"}]
["Niederhasli",9]
["Niederweningen",{"$error":"#VALUE!"}]
["Nürensdorf",6]
["Oberembrach",{"$error":"#VALUE!"}]
["Oberengstringen",8]
["Oberglatt",{"$error":"#VALUE!"}]
["Oberrieden",{"$error":"#VALUE!"}]
["Oberweningen",{"$f":"SEARCH($B$1,Gemeinde)","v":{"$error":"#VALUE!"}}]
["Obfelden",{"$error":"#VALUE!"}]
["Oetwil a.d.L.",{"$error":"#VALUE!"}]
["Oetwil a.S.",10]
["Opfikon",{"$error":"#VALUE!"}]
["Ossingen",2]
["Otelfingen",{"$error":"#VALUE!"}]
["Ottenbach",{"$error":"#VALUE!"}]
["Pfäffikon",{"$error":"#VALUE!"}]
["Pfungen",{"$error":"#VALUE!"}]
["Rafz",{"$error":"#VALUE!"}]
["Regensberg",6]
["Regensdorf",6]
["Rheinau",{"$error":"#VALUE!"}]
["Richterswil",8]
["Rickenbach",{"$error":"#VALUE!"}]
["Rifferswil",7]
["Rorbas",6]
["Rümlang",{"$error":"#VALUE!"}]
["Rüschlikon",3]
["Russikon",3]
["Rüti",{"$error":"#VALUE!"}]
["Schlatt",1]
["Schleinikon",1]
["Schlieren",1]
["Schöfflisdorf",1]
["Schwerzenbach",1]
["Seegräben",1]
["Seuzach",1]
["Stadel",1]
["Stäfa",1]
["Stallikon",1]
["Stammheim",{"$f":"SEARCH($B$1,Gemeinde)","v":1}]
["Steinmaur",1]
["Thalheim a.d.Th.",{"$error":"#VALUE!"}]
["Thalwil",{"$error":"#VALUE!"}]
["Trüllikon",{"$error":"#VALUE!"}]
["Truttikon",{"$error":"#VALUE!"}]
["Turbenthal",{"$error":"#VALUE!"}]
["Uetikon a.S.",11]
["Uitikon",{"$error":"#VALUE!"}]
["Unterengstringen",9]
["Urdorf",{"$error":"#VALUE!"}]
["Uster",2]
["Volken",{"$error":"#VALUE!"}]
["Volketswil",7]
["Wädenswil",6]
["Wald",{"$error":"#VALUE!"}]
["Wallisellen",6]
["Wangen-Brüttisellen",14]
["Wasterkingen",3]
["Weiach",{"$error":"#VALUE!"}]
["Weiningen",{"$error":"#VALUE!"}]
["Weisslingen",4]
["Wettswil a.A.",5]
["Wetzikon",{"$error":"#VALUE!"}]
["Wiesendangen",4]
["Wil",{"$error":"#VALUE!"}]
["Wila",{"$error":"#VALUE!"}]
["Wildberg",{"$error":"#VALUE!"}]
["Winkel",{"$error":"#VALUE!"}]
["Winterthur",{"$error":"#VALUE!"}]
["Zell",{"$error":"#VALUE!"}]
["Zollikon",{"$error":"#VALUE!"}]
["Zumikon",{"$error":"#VALUE!"}]
["Zürich",{"$error":"#VALUE!"}]

{"sheet":"TaxFeetMunicipalities2019","index":9,"n_rows":163,"n_cols":6,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["BFS","Gemeinde","andere","reformiert","katholisch","christ-katholisch"]
[21,"Adlikon",124,136,138,138]
[131,"Adliswil",100,110,108,114]
[241,"Aesch",87,98,98,101]
[1,"Aeugst a.A.",95,107,108,109]
[2,"Affoltern a.A.",124,136,137,138]
[211,"Altikon",114,126,127,128]
[30,"Andelfingen",112,124,126,126]
[51,"Bachenbülach",106,116,117,120]
[81,"Bachs",127,141,138,141]
[111,"Bäretswil",102,116,116,116]
[52,"Bassersdorf",109,121,118,123]
[297,"Bauma",120,134,134,134]
[22,"Benken",114,128,128,128]
[23,"Berg a.I.",98,110,111,112]
[242,"Birmensdorf",110,121,121,124]
[3,"Bonstetten",109,122,120,123]
[82,"Boppelsen",94,107,104,108]
[213,"Brütten",89,102,102,103]
[112,"Bubikon",118,130,131,132]
[24,"Buch a.I.",106,118,119,120]
[83,"Buchs",110,121,120,124]
[53,"Bülach",110,120,121,124]
[25,"Dachsen",109,121,123,123]
[214,"Dägerlen",117,131,130,131]
[84,"Dällikon",108,119,118,122]
[85,"Dänikon",120,131,130,134]
[215,"Dättlikon",114,128,127,128]
[86,"Dielsdorf",105,116,116,119]
[243,"Dietikon",123,135,136,137]
[54,"Dietlikon",98,110,106,112]
[216,"Dinhard",87,99,100,101]
[26,"Dorf",109,123,122,123]
[191,"Dübendorf",99,110,109,113]
[113,"Dürnten",115,129,128,129]
[192,"Egg",98,110,107,112]
[55,"Eglisau",113,127,126,127]
[294,"Elgg",117,131,131,131]
[218,"Ellikon a.d.Th.",119,131,132,133]
[219,"Elsau",118,132,131,132]
[56,"Embrach",118,130,131,132]
[151,"Erlenbach",79,88,86,93]
[193,"Fällanden",103,114,113,117]
[172,"Fehraltorf",107,120,120,121]
[27,"Feuerthalen",114,128,128,128]
[114,"Fischenthal",124,138,138,138]
[28,"Flaach",107,119,120,121]
[29,"Flurlingen",112,124,126,126]
[57,"Freienstein-Teufen",99,113,112,113]
[244,"Geroldswil",108,119,117,122]
[58,"Glattfelden",120,134,133,134]
[115,"Gossau",119,133,133,133]
[194,"Greifensee",94,105,104,108]
[116,"Grüningen",113,127,126,127]
[220,"Hagenbuch",114,128,128,128]
[4,"Hausen a.A.",112,126,126,126]
[5,"Hedingen",105,117,118,119]
[31,"Henggart",100,114,113,114]
[152,"Herrliberg",78,87,86,92]
[221,"Hettlingen",96,109,109,110]
[117,"Hinwil",112,124,128,126]
[173,"Hittnau",116,130,129,130]
[59,"Hochfelden",116,126,127,130]
[153,"Hombrechtikon",119,133,132,133]
[295,"Horgen",87,97,95,101]
[60,"Höri",117,127,128,131]
[32,"Humlikon",123,135,137,137]
[61,"Hüntwangen",104,118,117,118]
[87,"Hüttikon",119,132,129,133]
[296,"Illnau-Effretikon",110,123,123,124]
[6,"Kappel a.A.",102,116,116,116]
[135,"Kilchberg",72,81,78,86]
[33,"Kleinandelfingen",110,122,124,124]
[62,"Kloten",103,113,112,117]
[7,"Knonau",117,131,131,131]
[154,"Küsnacht",77,84,84,91]
[136,"Langnau a.A.",106,116,120,120]
[34,"Laufen-Uhwiesen",102,114,116,116]
[176,"Lindau",108,120,121,122]
[63,"Lufingen",89,101,102,103]
[155,"Männedorf",95,107,106,109]
[35,"Marthalen",109,123,123,123]
[8,"Maschwanden",129,143,143,143]
[195,"Maur",87,96,96,101]
[156,"Meilen",84,93,91,98]
[9,"Mettmenstetten",99,111,113,113]
[196,"Mönchaltorf",111,124,120,125]
[88,"Neerach",76,88,87,90]
[223,"Neftenbach",107,116,120,121]
[89,"Niederglatt",107,120,118,121]
[90,"Niederhasli",116,129,127,130]
[91,"Niederweningen",104,114,115,118]
[64,"Nürensdorf",90,102,99,104]
[65,"Oberembrach",117,129,130,131]
[245,"Oberengstringen",112,122,125,126]
[92,"Oberglatt",122,135,133,136]
[137,"Oberrieden",88,100,99,102]
[93,"Oberweningen",98,108,109,112]
[10,"Obfelden",121,133,134,135]
[246,"Oetwil a.d.L.",103,114,112,117]
[157,"Oetwil a.S.",119,133,128,133]
[66,"Opfikon",94,102,101,108]
[37,"Ossingen",99,113,113,113]
[94,"Otelfingen",110,123,120,124]
[11,"Ottenbach",117,131,130,131]
[177,"Pfäffikon",113,125,126,127]
[224,"Pfungen",117,129,130,131]
[67,"Rafz",113,127,126,127]
[95,"Regensberg",106,120,117,120]
[96,"Regensdorf",118,129,128,132]
[38,"Rheinau",118,132,132,132]
[138,"Richterswil",101,113,116,115]
[225,"Rickenbach",106,118,119,120]
[12,"Rifferswil",125,139,139,139]
[68,"Rorbas",103,117,116,117]
[97,"Rümlang",109,123,120,123]
[139,"Rüschlikon",73,83,83,87]
[178,"Russikon",113,125,126,127]
[118,"Rüti",121,135,134,135]
[226,"Schlatt",125,139,137,139]
[98,"Schleinikon",110,120,121,124]
[247,"Schlieren",111,122,123,125]
[99,"Schöfflisdorf",101,111,112,115]
[197,"Schwerzenbach",99,110,109,113]
[119,"Seegräben",115,127,129,129]
[227,"Seuzach",99,111,112,113]
[100,"Stadel",110,124,123,124]
[158,"Stäfa",88,99,100,102]
[13,"Stallikon",101,109,112,115]
[292,"Stammheim",124,138,138,138]
[101,"Steinmaur",114,126,125,128]
[39,"Thalheim a.d.Th.",102,114,115,116]
[141,"Thalwil",85,95,95,99]
[40,"Trüllikon",114,128,128,128]
[41,"Truttikon",118,132,132,132]
[228,"Turbenthal",126,140,139,140]
[159,"Uetikon a.S.",87,98,98,101]
[248,"Uitikon",80,90,91,94]
[249,"Unterengstringen",100,111,113,114]
[250,"Urdorf",118,128,129,132]
[198,"Uster",112,123,122,126]
[43,"Volken",111,123,124,125]
[199,"Volketswil",103,112,113,117]
[293,"Wädenswil",105,116,117,119]
[120,"Wald",122,136,138,136]
[69,"Wallisellen",97,105,105,111]
[200,"Wangen-Brüttisellen",101,112,109,115]
[70,"Wasterkingen",116,130,129,130]
[102,"Weiach",89,100,102,103]
[251,"Weiningen",103,114,112,117]
[180,"Weisslingen",106,119,118,120]
[14,"Wettswil a.A.",85,93,96,99]
[121,"Wetzikon",119,133,133,133]
[298,"Wiesendangen",90,104,103,104]
[71,"Wil",106,120,119,120]
[181,"Wila",129,143,142,143]
[182,"Wildberg",129,143,142,143]
[72,"Winkel",76,86,87,90]
[230,"Winterthur",125,138,141,139]
[231,"Zell",118,132,130,132]
[161,"Zollikon",85,93,94,99]
[160,"Zumikon",85,94,94,99]
[261,"Zürich",119,129,129,133]

{"sheet":"TaxFeetMunicipalities2020","index":10,"n_rows":163,"n_cols":6,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["BFS","Gemeinde","andere","reformiert","katholisch","christ-katholisch"]
[1,"Aeugst a.A.",95,107,108,109]
[2,"Affoltern a.A.",124,136,137,138]
[3,"Bonstetten",109,122,120,123]
[4,"Hausen a.A.",112,126,126,126]
[5,"Hedingen",105,117,118,119]
[6,"Kappel a.A.",102,116,116,116]
[7,"Knonau",117,131,131,131]
[8,"Maschwanden",129,143,143,143]
[9,"Mettmenstetten",99,111,113,113]
[10,"Obfelden",121,133,134,135]
[11,"Ottenbach",117,131,130,131]
[12,"Rifferswil",125,139,139,139]
[13,"Stallikon",101,109,112,115]
[14,"Wettswil a.A.",85,93,96,99]
[21,"Adlikon",124,136,138,138]
[22,"Benken",114,128,128,128]
[23,"Berg a.I.",98,110,111,112]
[24,"Buch a.I.",106,118,119,120]
[25,"Dachsen",109,121,123,123]
[26,"Dorf",109,123,122,123]
[27,"Feuerthalen",114,128,128,128]
[28,"Flaach",107,119,120,121]
[29,"Flurlingen",112,124,126,126]
[30,"Andelfingen",112,124,126,126]
[31,"Henggart",100,114,113,114]
[32,"Humlikon",123,135,137,137]
[33,"Kleinandelfingen",110,122,124,124]
[34,"Laufen-Uhwiesen",102,114,116,116]
[35,"Marthalen",109,123,123,123]
[37,"Ossingen",99,113,113,113]
[38,"Rheinau",118,132,132,132]
[39,"Thalheim a.d.Th.",102,114,115,116]
[40,"Trüllikon",114,128,128,128]
[41,"Truttikon",118,132,132,132]
[43,"Volken",111,123,124,125]
[51,"Bachenbülach",106,116,117,120]
[52,"Bassersdorf",109,121,118,123]
[53,"Bülach",110,120,121,124]
[54,"Dietlikon",98,110,106,112]
[55,"Eglisau",113,127,126,127]
[56,"Embrach",118,130,131,132]
[57,"Freienstein-Teufen",99,113,112,113]
[58,"Glattfelden",120,134,133,134]
[59,"Hochfelden",116,126,127,130]
[60,"Höri",117,127,128,131]
[61,"Hüntwangen",104,118,117,118]
[62,"Kloten",103,113,112,117]
[63,"Lufingen",89,101,102,103]
[64,"Nürensdorf",90,102,99,104]
[65,"Oberembrach",117,129,130,131]
[66,"Opfikon",94,102,101,108]
[67,"Rafz",113,127,126,127]
[68,"Rorbas",103,117,116,117]
[69,"Wallisellen",97,105,105,111]
[70,"Wasterkingen",116,130,129,130]
[71,"Wil",106,120,119,120]
[72,"Winkel",76,86,87,90]
[81,"Bachs",127,141,138,141]
[82,"Boppelsen",94,107,104,108]
[83,"Buchs",110,121,120,124]
[84,"Dällikon",108,119,118,122]
[85,"Dänikon",120,131,130,134]
[86,"Dielsdorf",105,116,116,119]
[87,"Hüttikon",119,132,129,133]
[88,"Neerach",76,88,87,90]
[89,"Niederglatt",107,120,118,121]
[90,"Niederhasli",116,129,127,130]
[91,"Niederweningen",104,114,115,118]
[92,"Oberglatt",122,135,133,136]
[93,"Oberweningen",98,108,109,112]
[94,"Otelfingen",110,123,120,124]
[95,"Regensberg",106,120,117,120]
[96,"Regensdorf",118,129,128,132]
[97,"Rümlang",109,123,120,123]
[98,"Schleinikon",110,120,121,124]
[99,"Schöfflisdorf",101,111,112,115]
[100,"Stadel",110,124,123,124]
[101,"Steinmaur",114,126,125,128]
[102,"Weiach",89,100,102,103]
[111,"Bäretswil",102,116,116,116]
[112,"Bubikon",118,130,131,132]
[113,"Dürnten",115,129,128,129]
[114,"Fischenthal",124,138,138,138]
[115,"Gossau",119,133,133,133]
[116,"Grüningen",113,127,126,127]
[117,"Hinwil",112,124,128,126]
[118,"Rüti",121,135,134,135]
[119,"Seegräben",115,127,129,129]
[120,"Wald",122,136,138,136]
[121,"Wetzikon",119,133,133,133]
[131,"Adliswil",100,110,108,114]
[135,"Kilchberg",72,81,78,86]
[136,"Langnau a.A.",106,116,120,120]
[137,"Oberrieden",88,100,99,102]
[138,"Richterswil",101,113,116,115]
[139,"Rüschlikon",73,83,83,87]
[141,"Thalwil",85,95,95,99]
[151,"Erlenbach",79,88,86,93]
[152,"Herrliberg",78,87,86,92]
[153,"Hombrechtikon",119,133,132,133]
[154,"Küsnacht",77,84,84,91]
[155,"Männedorf",95,107,106,109]
[156,"Meilen",84,93,91,98]
[157,"Oetwil a.S.",119,133,128,133]
[158,"Stäfa",88,99,100,102]
[159,"Uetikon a.S.",87,98,98,101]
[160,"Zumikon",85,94,94,99]
[161,"Zollikon",85,93,94,99]
[172,"Fehraltorf",107,120,120,121]
[173,"Hittnau",116,130,129,130]
[176,"Lindau",108,120,121,122]
[177,"Pfäffikon",113,125,126,127]
[178,"Russikon",113,125,126,127]
[180,"Weisslingen",106,119,118,120]
[181,"Wila",129,143,142,143]
[182,"Wildberg",129,143,142,143]
[191,"Dübendorf",99,110,109,113]
[192,"Egg",98,110,107,112]
[193,"Fällanden",103,114,113,117]
[194,"Greifensee",94,105,104,108]
[195,"Maur",87,96,96,101]
[196,"Mönchaltorf",111,124,120,125]
[197,"Schwerzenbach",99,110,109,113]
[198,"Uster",112,123,122,126]
[199,"Volketswil",103,112,113,117]
[200,"Wangen-Brüttisellen",101,112,109,115]
[211,"Altikon",114,126,127,128]
[213,"Brütten",89,102,102,103]
[214,"Dägerlen",117,131,130,131]
[215,"Dättlikon",114,128,127,128]
[216,"Dinhard",87,99,100,101]
[218,"Ellikon a.d.Th.",119,131,132,133]
[219,"Elsau",118,132,131,132]
[220,"Hagenbuch",114,128,128,128]
[221,"Hettlingen",96,109,109,110]
[223,"Neftenbach",107,116,120,121]
[224,"Pfungen",117,129,130,131]
[225,"Rickenbach",106,118,119,120]
[226,"Schlatt",125,139,137,139]
[227,"Seuzach",99,111,112,113]
[228,"Turbenthal",126,140,139,140]
[230,"Winterthur",125,138,141,139]
[231,"Zell",118,132,130,132]
[241,"Aesch",87,98,98,101]
[242,"Birmensdorf",110,121,121,124]
[243,"Dietikon",123,135,136,137]
[244,"Geroldswil",108,119,117,122]
[245,"Oberengstringen",112,122,125,126]
[246,"Oetwil a.d.L.",103,114,112,117]
[247,"Schlieren",111,122,123,125]
[248,"Uitikon",80,90,91,94]
[249,"Unterengstringen",100,111,113,114]
[250,"Urdorf",118,128,129,132]
[251,"Weiningen",103,114,112,117]
[261,"Zürich",119,129,129,133]
[292,"Stammheim",124,138,138,138]
[293,"Wädenswil",105,116,117,119]
[294,"Elgg",117,131,131,131]
[295,"Horgen",87,97,95,101]
[296,"Illnau-Effretikon",110,123,123,124]
[297,"Bauma",120,134,134,134]
[298,"Wiesendangen",90,104,103,104]

{"sheet":"TaxFeetMunicipalities2021","index":11,"n_rows":163,"n_cols":6,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["BFS","Gemeinde","andere","reformiert","katholisch","christ-katholisch"]
[21,"Adlikon",124,136,138,138]
[131,"Adliswil",100,110,108,114]
[241,"Aesch",87,98,98,101]
[1,"Aeugst a.A.",95,107,108,109]
[2,"Affoltern a.A.",124,136,137,138]
[211,"Altikon",114,126,127,128]
[30,"Andelfingen",112,124,126,126]
[51,"Bachenbülach",106,116,117,120]
[81,"Bachs",127,141,138,141]
[111,"Bäretswil",102,116,116,116]
[52,"Bassersdorf",109,121,118,123]
[297,"Bauma",120,134,134,134]
[22,"Benken",114,128,128,128]
[23,"Berg a.I.",98,110,111,112]
[242,"Birmensdorf",110,121,121,124]
[3,"Bonstetten",109,122,120,123]
[82,"Boppelsen",94,107,104,108]
[213,"Brütten",89,102,102,103]
[112,"Bubikon",118,130,131,132]
[24,"Buch a.I.",106,118,119,120]
[83,"Buchs",110,121,120,124]
[53,"Bülach",110,120,121,124]
[25,"Dachsen",109,121,123,123]
[214,"Dägerlen",117,131,130,131]
[84,"Dällikon",108,119,118,122]
[85,"Dänikon",120,131,130,134]
[215,"Dättlikon",114,128,127,128]
[86,"Dielsdorf",105,116,116,119]
[243,"Dietikon",123,135,136,137]
[54,"Dietlikon",98,110,106,112]
[216,"Dinhard",87,99,100,101]
[26,"Dorf",109,123,122,123]
[191,"Dübendorf",99,110,109,113]
[113,"Dürnten",115,129,128,129]
[192,"Egg",98,110,107,112]
[55,"Eglisau",113,127,126,127]
[294,"Elgg",117,131,131,131]
[218,"Ellikon a.d.Th.",119,131,132,133]
[219,"Elsau",118,132,131,132]
[56,"Embrach",118,130,131,132]
[151,"Erlenbach",79,88,86,93]
[193,"Fällanden",103,114,113,117]
[172,"Fehraltorf",107,120,120,121]
[27,"Feuerthalen",114,128,128,128]
[114,"Fischenthal",124,138,138,138]
[28,"Flaach",107,119,120,121]
[29,"Flurlingen",112,124,126,126]
[57,"Freienstein-Teufen",99,113,112,113]
[244,"Geroldswil",108,119,117,122]
[58,"Glattfelden",120,134,133,134]
[115,"Gossau",119,133,133,133]
[194,"Greifensee",94,105,104,108]
[116,"Grüningen",113,127,126,127]
[220,"Hagenbuch",114,128,128,128]
[4,"Hausen a.A.",112,126,126,126]
[5,"Hedingen",105,117,118,119]
[31,"Henggart",100,114,113,114]
[152,"Herrliberg",78,87,86,92]
[221,"Hettlingen",96,109,109,110]
[117,"Hinwil",112,124,128,126]
[173,"Hittnau",116,130,129,130]
[59,"Hochfelden",116,126,127,130]
[153,"Hombrechtikon",119,133,132,133]
[295,"Horgen",87,97,95,101]
[60,"Höri",117,127,128,131]
[32,"Humlikon",123,135,137,137]
[61,"Hüntwangen",104,118,117,118]
[87,"Hüttikon",119,132,129,133]
[296,"Illnau-Effretikon",110,123,123,124]
[6,"Kappel a.A.",102,116,116,116]
[135,"Kilchberg",72,81,78,86]
[33,"Kleinandelfingen",110,122,124,124]
[62,"Kloten",103,113,112,117]
[7,"Knonau",117,131,131,131]
[154,"Küsnacht",77,84,84,91]
[136,"Langnau a.A.",106,116,120,120]
[34,"Laufen-Uhwiesen",102,114,116,116]
[176,"Lindau",108,120,121,122]
[63,"Lufingen",89,101,102,103]
[155,"Männedorf",95,107,106,109]
[35,"Marthalen",109,123,123,123]
[8,"Maschwanden",129,143,143,143]
[195,"Maur",87,96,96,101]
[156,"Meilen",84,93,91,98]
[9,"Mettmenstetten",99,111,113,113]
[196,"Mönchaltorf",111,124,120,125]
[88,"Neerach",76,88,87,90]
[223,"Neftenbach",107,116,120,121]
[89,"Niederglatt",107,120,118,121]
[90,"Niederhasli",116,129,127,130]
[91,"Niederweningen",104,114,115,118]
[64,"Nürensdorf",90,102,99,104]
[65,"Oberembrach",117,129,130,131]
[245,"Oberengstringen",112,122,125,126]
[92,"Oberglatt",122,135,133,136]
[137,"Oberrieden",88,100,99,102]
[93,"Oberweningen",98,108,109,112]
[10,"Obfelden",121,133,134,135]
[246,"Oetwil a.d.L.",103,114,112,117]
[157,"Oetwil a.S.",119,133,128,133]
[66,"Opfikon",94,102,101,108]
[37,"Ossingen",99,113,113,113]
[94,"Otelfingen",110,123,120,124]
[11,"Ottenbach",117,131,130,131]
[177,"Pfäffikon",113,125,126,127]
[224,"Pfungen",117,129,130,131]
[67,"Rafz",113,127,126,127]
[95,"Regensberg",106,120,117,120]
[96,"Regensdorf",118,129,128,132]
[38,"Rheinau",118,132,132,132]
[138,"Richterswil",101,113,116,115]
[225,"Rickenbach",106,118,119,120]
[12,"Rifferswil",125,139,139,139]
[68,"Rorbas",103,117,116,117]
[97,"Rümlang",109,123,120,123]
[139,"Rüschlikon",73,83,83,87]
[178,"Russikon",113,125,126,127]
[118,"Rüti",121,135,134,135]
[226,"Schlatt",125,139,137,139]
[98,"Schleinikon",110,120,121,124]
[247,"Schlieren",111,122,123,125]
[99,"Schöfflisdorf",101,111,112,115]
[197,"Schwerzenbach",99,110,109,113]
[119,"Seegräben",115,127,129,129]
[227,"Seuzach",99,111,112,113]
[100,"Stadel",110,124,123,124]
[158,"Stäfa",88,99,100,102]
[13,"Stallikon",101,109,112,115]
[292,"Stammheim",124,138,138,138]
[101,"Steinmaur",114,126,125,128]
[39,"Thalheim a.d.Th.",102,114,115,116]
[141,"Thalwil",85,95,95,99]
[40,"Trüllikon",114,128,128,128]
[41,"Truttikon",118,132,132,132]
[228,"Turbenthal",126,140,139,140]
[159,"Uetikon a.S.",87,98,98,101]
[248,"Uitikon",80,90,91,94]
[249,"Unterengstringen",100,111,113,114]
[250,"Urdorf",118,128,129,132]
[198,"Uster",112,123,122,126]
[43,"Volken",111,123,124,125]
[199,"Volketswil",103,112,113,117]
[293,"Wädenswil",105,116,117,119]
[120,"Wald",122,136,138,136]
[69,"Wallisellen",97,105,105,111]
[200,"Wangen-Brüttisellen",101,112,109,115]
[70,"Wasterkingen",116,130,129,130]
[102,"Weiach",89,100,102,103]
[251,"Weiningen",103,114,112,117]
[180,"Weisslingen",106,119,118,120]
[14,"Wettswil a.A.",85,93,96,99]
[121,"Wetzikon",119,133,133,133]
[298,"Wiesendangen",90,104,103,104]
[71,"Wil",106,120,119,120]
[181,"Wila",129,143,142,143]
[182,"Wildberg",129,143,142,143]
[72,"Winkel",76,86,87,90]
[230,"Winterthur",125,138,141,139]
[231,"Zell",118,132,130,132]
[161,"Zollikon",85,93,94,99]
[160,"Zumikon",85,94,94,99]
[261,"Zürich",119,129,129,133]

{"sheet":"TaxFeetMunicipalities2022","index":12,"n_rows":163,"n_cols":6,"rows_kept":163,"cut":false,"hidden":true,"merged":[]}
["BFS","keine Auswahl","andere","reformiert","katholisch","christ-katholisch"]
[21,"Adlikon",126,138,140,140]
[131,"Adliswil",102,112,110,116]
[241,"Aesch",89,100,100,103]
[1,"Aeugst a.A.",95,107,108,109]
[2,"Affoltern a.A.",124,136,137,138]
[211,"Altikon",114,126,127,128]
[30,"Andelfingen",114,126,128,128]
[51,"Bachenbülach",106,116,117,120]
[81,"Bachs",127,141,138,141]
[111,"Bäretswil",106,120,119,120]
[52,"Bassersdorf",114,126,123,128]
[297,"Bauma",120,134,133,134]
[22,"Benken",114,128,128,128]
[23,"Berg a.I.",98,110,111,112]
[242,"Birmensdorf",112,123,123,126]
[3,"Bonstetten",109,121,120,123]
[82,"Boppelsen",94,107,104,108]
[213,"Brütten",89,102,102,103]
[112,"Bubikon",118,130,131,132]
[24,"Buch a.I.",106,118,119,120]
[83,"Buchs",110,121,120,124]
[53,"Bülach",110,120,121,124]
[25,"Dachsen",112,124,126,126]
[214,"Dägerlen",117,131,130,131]
[84,"Dällikon",108,119,118,122]
[85,"Dänikon",120,131,130,134]
[215,"Dättlikon",116,130,129,130]
[86,"Dielsdorf",105,117,116,119]
[243,"Dietikon",123,135,136,137]
[54,"Dietlikon",102,114,110,116]
[216,"Dinhard",87,99,100,101]
[26,"Dorf",109,123,122,123]
[191,"Dübendorf",99,110,109,113]
[113,"Dürnten",115,129,128,129]
[192,"Egg",101,113,110,115]
[55,"Eglisau",113,126,126,127]
[294,"Elgg",115,129,129,129]
[218,"Ellikon a.d.Th.",119,131,132,133]
[219,"Elsau",120,134,133,134]
[56,"Embrach",118,130,131,132]
[151,"Erlenbach",79,88,86,93]
[193,"Fällanden",103,114,113,117]
[172,"Fehraltorf",107,120,119,121]
[27,"Feuerthalen",114,127,128,128]
[114,"Fischenthal",124,138,137,138]
[28,"Flaach",107,119,120,121]
[29,"Flurlingen",112,124,126,126]
[57,"Freienstein-Teufen",99,113,112,113]
[244,"Geroldswil",110,121,119,124]
[58,"Glattfelden",120,134,133,134]
[115,"Gossau",119,133,133,133]
[194,"Greifensee",94,105,104,108]
[116,"Grüningen",113,127,126,127]
[220,"Hagenbuch",116,130,130,130]
[4,"Hausen a.A.",112,124,126,126]
[5,"Hedingen",105,117,118,119]
[31,"Henggart",102,116,115,116]
[152,"Herrliberg",78,87,86,92]
[221,"Hettlingen",96,109,109,110]
[117,"Hinwil",112,124,128,126]
[173,"Hittnau",116,130,128,130]
[59,"Hochfelden",116,126,127,130]
[153,"Hombrechtikon",119,130,132,133]
[295,"Horgen",90,100,98,104]
[60,"Höri",115,125,126,129]
[32,"Humlikon",125,137,139,139]
[61,"Hüntwangen",108,122,121,122]
[87,"Hüttikon",115,128,125,129]
[296,"Illnau-Effretikon",110,123,123,124]
[6,"Kappel a.A.",102,116,116,116]
[135,"Kilchberg",72,81,78,86]
[33,"Kleinandelfingen",112,124,126,126]
[62,"Kloten",103,113,112,117]
[7,"Knonau",117,131,131,131]
[154,"Küsnacht",75,82,82,89]
[136,"Langnau a.A.",106,116,120,120]
[34,"Laufen-Uhwiesen",102,114,116,116]
[176,"Lindau",108,120,121,122]
[63,"Lufingen",89,101,102,103]
[155,"Männedorf",95,107,106,109]
[35,"Marthalen",105,119,119,119]
[8,"Maschwanden",130,142,144,144]
[195,"Maur",87,96,96,101]
[156,"Meilen",84,93,91,98]
[9,"Mettmenstetten",99,111,113,113]
[196,"Mönchaltorf",111,124,120,125]
[88,"Neerach",76,88,87,90]
[223,"Neftenbach",107,116,120,121]
[89,"Niederglatt",107,120,118,121]
[90,"Niederhasli",116,129,127,130]
[91,"Niederweningen",104,114,115,118]
[64,"Nürensdorf",90,102,99,104]
[65,"Oberembrach",117,129,130,131]
[245,"Oberengstringen",112,122,125,126]
[92,"Oberglatt",122,135,133,136]
[137,"Oberrieden",88,100,99,102]
[93,"Oberweningen",98,108,109,112]
[10,"Obfelden",121,133,134,135]
[246,"Oetwil a.d.L.",108,119,117,122]
[157,"Oetwil a.S.",119,133,128,133]
[66,"Opfikon",94,102,101,108]
[37,"Ossingen",99,113,113,113]
[94,"Otelfingen",110,123,120,124]
[11,"Ottenbach",117,129,130,131]
[177,"Pfäffikon",113,125,125,127]
[224,"Pfungen",117,129,130,131]
[67,"Rafz",113,127,126,127]
[95,"Regensberg",106,120,117,120]
[96,"Regensdorf",118,129,128,132]
[38,"Rheinau",118,132,132,132]
[138,"Richterswil",101,113,116,115]
[225,"Rickenbach",106,118,119,120]
[12,"Rifferswil",125,137,139,139]
[68,"Rorbas",103,117,116,117]
[97,"Rümlang",109,123,120,123]
[139,"Rüschlikon",75,85,85,89]
[178,"Russikon",113,125,125,127]
[118,"Rüti",121,135,134,135]
[226,"Schlatt",125,139,137,139]
[98,"Schleinikon",110,120,121,124]
[247,"Schlieren",111,122,123,125]
[99,"Schöfflisdorf",101,111,112,115]
[197,"Schwerzenbach",101,112,111,115]
[119,"Seegräben",115,127,129,129]
[227,"Seuzach",99,111,112,113]
[100,"Stadel",112,126,125,126]
[158,"Stäfa",80,91,92,94]
[13,"Stallikon",101,109,112,115]
[292,"Stammheim",119,133,133,133]
[101,"Steinmaur",114,126,125,128]
[39,"Thalheim a.d.Th.",104,116,117,118]
[141,"Thalwil",85,95,95,99]
[40,"Trüllikon",114,128,128,128]
[41,"Truttikon",115,129,129,129]
[228,"Turbenthal",124,138,137,138]
[159,"Uetikon a.S.",87,98,98,101]
[248,"Uitikon",80,90,91,94]
[249,"Unterengstringen",100,111,113,114]
[250,"Urdorf",118,128,129,132]
[198,"Uster",112,123,122,126]
[43,"Volken",111,123,124,125]
[199,"Volketswil",103,112,113,117]
[293,"Wädenswil",105,116,117,119]
[120,"Wald",122,136,138,136]
[69,"Wallisellen",97,105,105,111]
[200,"Wangen-Brüttisellen",101,112,109,115]
[70,"Wasterkingen",116,130,129,130]
[102,"Weiach",89,100,102,103]
[251,"Weiningen",103,114,112,117]
[180,"Weisslingen",116,129,128,130]
[14,"Wettswil a.A.",89,97,100,103]
[121,"Wetzikon",119,133,133,133]
[298,"Wiesendangen",90,104,103,104]
[71,"Wil",104,118,117,118]
[181,"Wila",129,143,142,143]
[182,"Wildberg",129,143,142,143]
[72,"Winkel",76,86,87,90]
[230,"Winterthur",125,138,142,139]
[231,"Zell",118,132,130,132]
[161,"Zollikon",82,90,91,96]
[160,"Zumikon",81,89,90,95]
[261,"Zürich",119,129,129,133]

{"sheet":"Ideas_Information","index":13,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Unterhaltsberechnungen als Funktionen schreiben"]
["Using ClassModules"]
[]
[]
[]
[]
["https://www.zh.ch/de/steuern-finanzen/steuern/steuerstatistiken/aktuelle-gemeinde-steuerfuesse.html#/"]
["https://amp.derbund.ch/ein-dorf-drei-steuerfuesse-694130473257"]