{"text_format":"3","workbook":"xls","n_sheets":14,"sheets":["UHB","Bemerk","Steuern EM","Steuern EF","Tarif","Liegenschaft","Steuerfuss","Benutzerhinweise","Funktionen","Makros","Dialog1","Dialog2","Dialog3","Modul"],"not_rendered":{"images":2087,"macros":1,"external_links":1,"defined_names":77,"comments":12},"unopened":[{"sheet":"Funktionen","index":8,"reason":"not_a_worksheet"},{"sheet":"Makros","index":9,"reason":"not_a_worksheet"},{"sheet":"Modul","index":13,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"UHB","index":0,"n_rows":82,"n_cols":10,"rows_kept":82,"merged":[[15,1,15,9]],"flags":["formulas_cached_only"]}
[null,"Grunddaten:","Kind","Eheleute:",null,"Muster-Test","Konfession","Tarif","Steuerfuss","Direktlink zur Vorlage:"]
[null,"Total K-UHB",0,"Ehemann","in","Zürich","reformiert","G",{"v":129,"d":"129%"},"https://arbrch.ch/UHB"]
[null,"inkl. KZ/Monat",2,"Ehefrau","in","Zürich","katholisch","V",{"v":129,"d":"129%"}]
[{"v":2,"d":"2 Kind(er)"},{"v":2000,"d":"2,000"},"",null,null,""]
[null,"Bearbeiter/in:",null,"",{"$nulls":4},"Steuerfuss-Stand = 26.07.2017"]
{"$rows_empty":10}
[null,"UHB.XLT  -   © Georges Chanson, 8027 Zürich, chanson@arbeitsrechtler.ch   -   Ver. 26.07.2017, Tarif 2012 (ZH) / 2014 (Bund)   -   ohne Gewähr !"]
[null,"Unterhaltsberechnung i.S. Muster-Test",{"$nulls":7},"Verknüpfungen"]
["Verknüpfungen ","Einkommen",null,"Ehemann",null,null,"Ehefrau",null,"Gesamt"]
[{"$nulls":5},"Netto-Erwerbseinkommen, inkl. KZ/Jahr"]
[{"$nulls":5},"13. Monatslohn/Gratifikation/Jahr"]
["an Steuern EM B3",null,null,0,null,"Total Erwerbseinkommen/Jahr",0,null,null,"an Steuern EF B3"]
["an Steuern EM B10",{"$nulls":4},"Vermögensertrag/Jahr",{"$nulls":3},"an Steuern EF B10"]
["von Liegenschaft",null,null,0,null,"Liegenschaftenertrag/Jahr netto",0,null,null,"von Liegenschaft"]
["an Steuern EM B12",{"$nulls":4},"Weitere Einkünfte/Jahr",{"$nulls":3},"an Steuern EF B12"]
[]
[{"$nulls":3},0,null,"Einkommen/Jahr",0]
[{"$nulls":3},0,null,"Einkommen/pro Monat",0]
["an Steuern EM B4",{"$nulls":4},"abzüglich Familienzulagen/Monat",{"$nulls":3},"an Steuern EF B4"]
[{"$nulls":3},0,null,"Total Einkommen/Monat",0,null,0]
[null,"Ausgaben"]
[{"$nulls":3},{"v":1200,"d":"1,200"},null,"Grundbetrag: Erwachsene   (1'100/1'200)",{"v":1350,"d":"1,350"}]
[{"$nulls":3},0,null,"Grundbetrag: Kinder ","?"]
[{"$nulls":5},"Wohnen: Miete, inkl."]
[{"$nulls":5},"Wohnen: Liegenschaftenaufwand"]
[{"$nulls":5},"Wohnen: Heizung, allenfalls Strom"]
[{"$nulls":5},"Telefon - Radio/TV"]
[{"$nulls":5},"Versicherungen: AHV"]
[{"$nulls":5},"Versicherungen: Krankenkasse"]
[{"$nulls":5},"Versicherungen: Unfall"]
[{"$nulls":5},"Versicherungen: Personalvorsorge"]
[{"$nulls":5},"Versicherungen: Leben"]
[{"$nulls":5},"Versicherungen: Hausrat etc."]
[{"$nulls":5},"Versicherungen:Haftpflicht"]
[{"$nulls":5},"Beruf: Verpflegung Schwerarbeit/auswärts"]
[{"$nulls":5},"Beruf: Kleider"]
[{"$nulls":5},"Beruf: Fahrtauslagen"]
[{"$nulls":5},"Beruf: Fachliteratur"]
[{"$nulls":5},"Beruf: Verbandsbeiträge"]
[{"$nulls":5},"Unterstützungsleistungen"]
[{"$nulls":5},"Verschiedenes: Schulung/Pflege Kinder"]
[{"$nulls":5},"Verschiedenes: Kompetenzstücke"]
[{"$nulls":5},"Verschiedenes: Arzt, Umzug, MPE etc."]
[{"$nulls":5},"................................................................."]
[24,24,{"$nulls":3},"Steuern: Kanton + Gemeinde",null,null,24,24]
[0,0,{"$nulls":3},"Steuern: Bund",null,null,0,0]
[]
[{"$nulls":3},{"v":1200,"d":"1,200"},null,"Zwischentotal",{"v":1350,"d":"1,350"}]
[{"$nulls":3},0,null,"Zuschlag 20% (BGE 121 III 49)",0]
[]
[{"$nulls":3},{"v":1200,"d":"1,200"},null,"Total Ausgaben",{"v":1350,"d":"1,350"},null,{"v":2550,"d":"2,550"}]
[null,"Überschuss/Manko"]
[{"$nulls":5},"Total beider Einnahmen",null,null,0]
[{"$nulls":5},"Total beider Ausgaben",null,null,{"v":2550,"d":"2,550"}]
[]
[{"$nulls":5},"Überschuss bzw. Manko",null,null,0]
[{"$nulls":3},0,null,"Überschuss (+) bzw. Manko (-)",0,null,0]
[null,"Aufteilung/Berechnung Unterhaltsbeitrag"]
[null,"Differenz-Anteil EM:",null,{"v":1200,"d":"1,200"},null,"Total Ausgaben",{"v":1350,"d":"1,350"},null,{"v":2550,"d":"2,550"}]
[null,0,"%",0,null,"Überschuss bzw. Mankoanteil",0,null,0]
[]
["UHB EM an EF:",null,null,{"v":1200,"d":"1,200"},null,"Anteil pro Ehegatte",{"v":1350,"d":"1,350"},null,{"v":2550,"d":"2,550"},"UHB EF an EM"]
[false,null,null,0,null,"Total Einkommen",0,null,0,false]
[]
[null,"Jahr:",null,0,null,"Zwischentotal für Festlegung UHB",0,null,""]
[0,0,null,0,null,"Bar-Unterhaltsbeitrag",0,null,null,0]
[0,0,null,0,null,"davon Kinder",0,null,null,0]
[0,0,null,0,null,"davon Ehepartner",0,null,null,0]
[0,0,null,0,null,"zuzüglich Familienzulagen",0,null,null,0]
[0,0,null,0,null,"Total UHB inkl. Familienzulagen",0,null,null,0]
[null,"26.07.2017"]
["PfadBlatt()","C:\\Program Files\\Microsoft Office\\Templates\\Excel.2003\\UHB.XLT_UHB",{"$nulls":7},"an Steuern EF"]
[{"$nulls":3},0,null,"für jeden Ehepartner verbleibend",0]

{"sheet":"Bemerk","index":1,"n_rows":36,"n_cols":1,"rows_kept":36,"flags":["formulas_cached_only"]}
["Bemerkungen zur Unterhaltsberechnung i.S. Muster-Test"]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
["Beilagen"]
[{"v":1,"d":"1."}]
[{"v":2,"d":"2."}]
[{"v":3,"d":"3."}]
[{"v":4,"d":"4."}]
[{"v":5,"d":"5."}]
[{"v":6,"d":"6."}]
[{"v":7,"d":"7."}]
[{"v":8,"d":"8."}]
[{"v":9,"d":"9."}]
[{"v":10,"d":"10."}]
[{"v":11,"d":"11."}]
[{"v":12,"d":"12."}]
[{"v":13,"d":"13."}]
[{"v":14,"d":"14."}]
[{"v":15,"d":"15."}]
[{"v":16,"d":"16."}]
[{"v":17,"d":"17."}]
[{"v":18,"d":"18."}]
[{"v":19,"d":"19."}]
[{"v":20,"d":"20."}]
["26.07.2017"]

{"sheet":"Steuern EM","index":2,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[28,8,28,9],[29,6,29,7],[29,8,29,9],[30,4,30,5],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,6,33,7],[33,8,33,9]],"flags":["formulas_cached_only"]}
["Steuerberechnung Ehemann i.S. Muster-Test",null,null,"in: Zürich",null,"Konfession: reformiert",null,"26.7.2017","Berechnung Abzüge StSt + BuSt",null,"Berufsauslagen zZt."]
["Einkommen Staatssteuer",{"$nulls":3},"Gemeinde-Steuerfuss: 129%","Kanton: 100%","0 Kinder in Obhut","Grundtarif","Berufsauslagen:","2017 (StE 2016)",{"v":2000,"d":"2000 BAMin"},"neu ab 2012!"]
["Einkünfte",0,"Erwerbseinkommen Ehemann , inkl. KZ",null,"Abzüge Steuerjahr 2017 (StE 2016) *",null,"Kanton","Bund",0,"    ",{"v":4000,"d":"4000 BAMax"}]
[null,0,"Kinderzulagen von Arbeitgeber",null,"Berufsauslagen:","Pauschale (3% NL II)","2000-4000","dito",0,"Pauschale EF",{"v":3,"d":"3 BAProz"}]
[null,null,"ev. Erwerbseinkommen Ehefrau, inkl. KZ",null,null,"Fahrt/ZVV",null,"dito",null,null,{"v":800,"d":"800 NBMin"}]
[null,null,"Nebenerwerb (Ehemann + ev. Ehefrau)",null,null,"Verpflegung, voll",{"v":3200,"d":"3,200"},"dito",null,null,{"v":2400,"d":"2400 NBMax"}]
[null,null,"Renten (z.B. AHV/IV: 100% - BVG: i.R. 80%)",null,null,"verbilligt",{"v":1600,"d":"1,600"},"dito",null,null,{"v":20,"d":"20 NBProz"}]
[null,null,"UVG-Renten für NBU vor 1987 (i.R. 80%)",null,null,"Weiterbild./Umschul.",500,"dito",null,null,0]
[null,0,"Vermögensertrag",null,"Nebenbeschäftigung","20%, min./max.","800-2400","dito",0,null,0]
[null,0,"Liegenschaftenertrag/Eigenmietwert, netto",null,"Erstausbildung","kein Abzug mehr möglich !","0 !","0 !",0,null,0]
[null,0,"Alimente + KZ von Ehefrau",null,"3. Säule, max. 20% vom","mit Vorsorge, max.",{"v":6768,"d":"6,768"},"dito",null,{"v":0,"d":"max. 20% EE = 0"},null,"ab 01.01.2015, unverändert"]
[null,0,"übrige Einkünfte",null,"Erwerbseinkommen","ohne Vorsorge, max.",{"v":33840,"d":"33,840"},"dito",null,{"v":0,"d":"EE = 0"},null,"ab 01.01.2015, unverändert"]
[null,0,"Total Einkünfte",{"$nulls":5},"Berechnung Versicherungsabzug:"]
[{"$nulls":4},"Versicherung/Zinsen","übrige",{"v":2600,"d":"2,600"},{"v":1700,"d":"1,700"},{"v":2600,"d":"2,600"},{"v":1700,"d":"1,700"}]
["Abzüge",0,"Berufsauslagen (Pauschale, etc.)/Nebenb. ",null,null,"übrige, ohne BVG",{"v":3900,"d":"3,900"},{"v":2550,"d":"2,550"}]
[null,0,"Schuldzinsen",null,null,"pro Kind/Unt.         **",{"v":1300,"d":"1,300"},700,0,0]
[null,0,"Alimente + Kinderzulagen an Ehefrau",{"$nulls":5},{"v":2600,"d":"2,600"},{"v":1700,"d":"1,700"}]
[null,0,"3. Säule",null,"Parteien",null,{"v":10000,"d":"max.  10,000"},{"v":10100,"d":"max.  10,100"},null,null,"",""]
[null,{"v":2600,"d":"2,600"},"Versicherungen/Sparzinsen",null,"Inv./Krankheit/Unfall","nur >5% Netto-EK Ziff. 21",null,null,{"v":0,"d":"Selbstbeh: 0"},{"v":0,"d":"Selbstbeh: 0"}]
[null,0,"Parteien",{"$nulls":7},"\"Reineinkommen\" für Abzüge Zuwend. + Inv. "]
[null,null,"Vermögensverwaltung/AHV etc.",null,"Gem. Zuwendungen","max. 20% Netto-EK Ziff. 21","min. 100",null,{"v":0,"d":"max. 0 !"},{"v":0,"d":"max. 0 !"},0,"Einkünfte StST"]
[null,0,"Invalidität/Krankheit/Unfall",{"$nulls":5},300,300,{"v":-2600,"d":"-2,600"},"Abzüge StSt"]
[null,300,"Gemeinnützige Zuwendungen",{"$nulls":5},"Berechnung Sozialabzüge:",null,{"v":-2600,"d":"-2,600"},"Nettoeink. StST"]
[null,{"v":2900,"d":"2,900"},"Total Abzüge",null,"Sozialabzüge","pro Kind          **",{"v":9000,"d":"9,000"},{"v":6500,"d":"6,500"},0,0,900,"Korr. BUSt"]
[{"$nulls":5},"pro Unterstützung",{"v":2700,"d":"2,700"},{"v":6500,"d":"6,500"},null,null,{"v":-1700,"d":"-1,700"},"Nettoeink. BUSt"]
[null,0,"Reineinkommen Staatssteuer",null,null,"Kinderbetreuung/Kind",{"v":10100,"d":"max.  10,100"},{"v":10100,"d":"max.  10,100"}]
[null,{"v":0,"d":"- 0"},"Sozialabzüge Staatssteuer",{"$nulls":5},0,0]
[{"$nulls":4},"* Abzüge 3. Säule gelten ab Steuerjahr 2015",{"$nulls":3},"Quellen Abzüge / Berufsauslagen:"]
[null,0,"Steuerbares Einkommen Staatssteuer",null,"** Abzug, i.d.R. wenn Steuerpflichtiger Kinderunterhalt zur Hauptsache bestreitet!",{"$nulls":3},"http://www.zhlex.zh.ch/Erlass.html?Open&Ordnr=631.33 ",null,"(ab Steuerperiode 2016)"]
[{"$nulls":4},"     Ausnahmen: StG 34 I a2 + KS EStV Nr. 30 vom 21.12.2010, 2.A.)",null,"Direktlink auf KS",null,"http://www.zhlex.zh.ch/Erlass.html?Open&Ordnr=631.1"]
["Einkommen Bundessteuer",{"$nulls":3},"Wegleitung zur Steuererklärung 2016",{"$nulls":3},"http://www.admin.ch/ch/d/sr/c642_118_1.html",null,"BerufskostenVO"]
[null,0,"Reineinkommen Staatssteuer, ungerundet",{"$nulls":5},"http://www.admin.ch/ch/d/sr/c642_119_2.html",null,"VKP"]
[null,0,"Korr: UVG-Renten (NBU vor 1988, i.R. 100%)",null,"Steuerberechnung",{"$nulls":3},"http://www.admin.ch/ch/d/sr/831_461_3/a7.html"]
[null,900,"Korr: Versicherungen/Sparzinsen",{"$nulls":3},"Tarif:",null,"http://www.admin.ch/ch/d/sr/831_441_1/a5.html"]
[null,0,"Korr: Parteibeiträge",null,"Staatssteuer",null,"V","G"]
[null,0,"Korr: Invalidität/Krankheit/Unfall",null,"Einkommenssteuer 100%  (§ 35 II StG, gültig ab 2012)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,0,"Korr: Gemeinnützige Zuwendungen",null,"Vermögenssteuer 100% (§ 47 II 2 StG, gültig ab 2012)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":4},"Total 100%",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,0,"Reineinkommen Bundessteuer",null,"Steuerfuss Kanton",{"v":1,"d":"100.0%"}]
[null,{"v":0,"d":"- 0"},"Sozialabzüge Bundessteuer",null,"Steuerfuss Gde. + KG",{"v":1.29,"d":"129.0%"}]
[{"$nulls":4},"Steuern Kanton, Gemeinde, KG",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,0,"Steuerbares Einkommen Bundessteuer",null,"Personalsteuer",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
[]
["Vermögen Staatssteuer",{"$nulls":3},"Total Staatssteuer",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
["Aktiven",null,"Wertschriften etc."]
[null,null,"bar, Edelmetalle"]
[null,null,"Fahrzeuge",{"$nulls":3},"verh./Eineltern","allein"]
[null,null,"Erbschaftsanteile",null,"Bundessteuer (Art.36 DBG + VKP, ab 2014)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"übrige Vermögenswerte",null,"Ermässigung pro selbst unterh. Kind: CHF 251",null,{"v":0,"d":"0.00"}]
[null,0,"Liegenschaften",null,"Total Bundessteuer",null,{"v":0,"d":"0.00"}]
[null,null,"Geschäftskapital"]
[null,0,"Total Aktiven",null,"Total Steuern",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
[]
["Passiven",0,"Hypothekarschulden"]
[null,null,"übrige Passiven",null,"Übernahme in Unter-","Staatssteuer",{"v":0,"d":"0.00"},{"v":24,"d":"24.00"}]
[null,0,"Total Passiven",null,"haltsberechnung","Bund",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,0,"Reinvermögen"]
[]
[{"$nulls":4},"Hinweis: getrennte Besteuerung ab dauernder Trennung oder Scheidung"]
[{"$nulls":4},"für ganze Steuerperiode (vgl. § 52 StG ZH)"]

{"sheet":"Steuern EF","index":3,"n_rows":63,"n_cols":12,"rows_kept":63,"merged":[[0,9,0,10],[32,4,33,5]],"flags":["formulas_cached_only"]}
["Steuerberechnung Ehefrau i.S. Muster-Test",null,null,"in: Zürich",null,"Konfession: katholisch",null,"26.7.2017",null,"Hinweis: Vorgaben für Abzüge in 'Steuern EM'"]
["Einkommen Staatssteuer",{"$nulls":3},"Gemeinde-Steuerfuss: 129%","Kanton: 100%","2 Kinder in Obhut","VerhTarif"]
["Einkünfte",0,"Erwerbseinkommen Ehefrau , inkl. KZ",null,"Abzüge Steuerjahr 2017 (StE 2016) *",null,"Kanton","Bund","Berufsauslagen:"]
[null,0,"Kinderzulagen von Arbeitgeber",null,"Berufsauslagen:","Pauschale (3% NL II)","2000-4000","dito",0]
[{"$nulls":4},""]
[null,null,"Nebenerwerb",null,"","Fahrt/ZVV",null,"dito"]
[null,null,"Renten (z.B. AHV/IV: 100% - BVG: i.R. 80%)",null,"","Verpflegung, voll",{"v":3200,"d":"3,200"},"dito"]
[null,null,"UVG-Renten für NBU vor 1987 (i.R. 80%)",null,"","verbilligt",{"v":1600,"d":"1,600"},"dito"]
[null,0,"Vermögensertrag",null,"","Weiterbild./Umschul.",500,"dito"]
[null,0,"Liegenschaftenertrag/Eigenmietwert, netto",null,"Nebenbeschäftigung","20%, min./max.","800-2400","dito",0]
[null,0,"Alimente + KZ von Ehemann",null,"Erstausbildung","kein Abzug mehr möglich !","0 !","0 !",0,null,0]
[null,0,"übrige Einkünfte",null,"3. Säule, max. 20% vom","mit Vorsorge, max.",{"v":6768,"d":"6,768"},"dito",0,null,0]
[null,0,"Total Einkünfte",null,"Erwerbseinkommen","ohne Vorsorge, max.",{"v":33840,"d":"33,840"},"dito",0,{"v":0,"d":"max. 20% EE = 0"},{"v":0,"d":"EE = 0"}]
[{"$nulls":8},"Berechnung Versicherungsabzug:"]
["Abzüge",0,"Berufsauslagen (Pauschale, etc.)/Nebenb. ",null,"Versicherung/Zinsen","übrige",{"v":2600,"d":"2,600"},{"v":1700,"d":"1,700"},{"v":2600,"d":"2,600"},{"v":1700,"d":"1,700"}]
[null,0,"Schuldzinsen",null,null,"übrige, ohne BVG",{"v":3900,"d":"3,900"},{"v":2550,"d":"2,550"}]
[null,0,"Alimente an Ehemann persönlich",null,null,"pro Kind/Unt.         **",{"v":1300,"d":"1,300"},700,{"v":2600,"d":"2,600"},{"v":1400,"d":"1,400"}]
[null,0,"3. Säule",{"$nulls":5},5200,3100]
[null,{"v":5200,"d":"5,200"},"Versicherungen/Sparzinsen",null,"Parteien",null,{"v":10000,"d":"max.  10,000"},{"v":10100,"d":"max.  10,100"},null,null,"",""]
[null,0,"Parteien",null,"Inv./Krankheit/Unfall","nur >5% Netto-EK Ziff. 21",0,0,{"v":0,"d":"Selbstbeh: 0"},{"v":0,"d":"Selbstbeh: 0"}]
[null,null,"Vermögensverwaltung/AHV etc."]
[{"$nulls":11},"Einkünfte StST"]
[null,0,"Invalidität/Krankheit/Unfall",null,"Gem. Zuwendungen","max. 20% Netto-EK Ziff. 21","min. 100",0,{"v":0,"d":"max. 0 !"},{"v":0,"d":"max. 0 !"},"\"Reineinkommen\" für Abzüge Zuwend. + Inv. "]
[null,300,"Gemeinnützige Zuwendungen",{"$nulls":5},300,300,0,"Einkünfte StST"]
[null,{"v":5500,"d":"5,500"},"Total Abzüge",{"$nulls":5},"Berechnung Sozialabzüge:",null,{"v":-5200,"d":"-5,200"},"Abzüge StSt"]
[{"$nulls":4},"Sozialabzüge","pro Kind          **",{"v":9000,"d":"9,000"},{"v":6500,"d":"6,500"},{"v":18000,"d":"18,000"},{"v":13000,"d":"13,000"},{"v":-5200,"d":"-5,200"},"Nettoeink. StST"]
[null,0,"Reineinkommen Staatssteuer",null,null,"pro Unterstützung",{"v":2700,"d":"2,700"},{"v":6500,"d":"6,500"},null,null,{"v":2100,"d":"2,100"},"Korr. BUSt"]
[null,{"v":18000,"d":"- 18,000"},"Sozialabzüge Staatssteuer",null,null,"Kinderbetreuung/Kind",{"v":10100,"d":"max.  10,100"},{"v":10100,"d":"max.  10,100"},null,null,{"v":-3100,"d":"-3,100"},"Nettoeink. BUSt"]
[{"$nulls":8},{"v":18000,"d":"18,000"},{"v":13000,"d":"13,000"}]
[null,0,"Steuerbares Einkommen Staatssteuer",null,"* Abzüge 3. Säule gelten ab Steuerjahr 2015",{"$nulls":3},"Quellen Abzüge / Berufsauslagen:"]
["Einkommen Bundessteuer",{"$nulls":3},"** siehe Steuern Ehemann",{"$nulls":3},"siehe Steuern Ehemann"]
[]
[null,0,"Reineinkommen Staatssteuer, ungerundet",null,"siehe Steuern Ehemann"]
[null,0,"Korr: UVG-Renten (NBU vor 1988, i.R. 100%)"]
[null,{"v":2100,"d":"2,100"},"Korr: Versicherungen/Sparzinsen",null,"Steuerberechnung"]
[null,0,"Korr: Parteibeiträge",{"$nulls":3},"  Tarif:"]
[null,0,"Korr: Invalidität/Krankheit/Unfall",null,"Staatssteuer",null,"V","G"]
[null,0,"Korr: Gemeinnützige Zuwendungen"]
[{"$nulls":4},"Einkommenssteuer 100%  (§ 35 II StG, gültig ab 2012)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,0,"Reineinkommen Bundessteuer",null,"Vermögenssteuer 100% (§ 47 II 2 StG, gültig ab 2012)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,{"v":13000,"d":"- 13,000"},"Sozialabzüge Bundessteuer",null,"Total 100%",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":4},"Steuerfuss Kanton",{"v":1,"d":"100.0%"}]
[null,0,"Steuerbares Einkommen Bundessteuer",null,"Steuerfuss Gde. + KG",{"v":1.29,"d":"129.0%"}]
[{"$nulls":4},"Steuern Kanton, Gemeinde, KG",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Vermögen Staatssteuer",{"$nulls":3},"Personalsteuer",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
["Aktiven",null,"Wertschriften etc."]
[null,null,"bar, Edelmetalle",null,"Total Staatssteuer",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
[null,null,"Fahrzeuge"]
[null,null,"Erbschaftsanteile"]
[null,null,"übrige Vermögenswerte",{"$nulls":3},"verh./Eineltern","allein"]
[null,0,"Liegenschaften",null,"Bundessteuer (Art. 36 DBG)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"Geschäftskapital",null,"Ermässigung pro selbst unterh. Kind: CHF 251",null,{"v":-502,"d":"-502.00"}]
[null,0,"Total Aktiven",null,"Total Bundessteuer",null,{"v":0,"d":"0.00"}]
[]
["Passiven",0,"Hypothekarschulden",null,"Total Steuern",null,{"v":24,"d":"24.00"},{"v":24,"d":"24.00"}]
[null,null,"übrige Passiven"]
[null,0,"Total Passiven"]
[{"$nulls":4},"Übernahme in Unter-","Staatssteuer",{"v":24,"d":"24.00"},{"v":0,"d":"0.00"}]
[null,0,"Reinvermögen",null,"haltsberechnung","Bund",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
[{"$nulls":4},"Hinweis: getrennte Besteuerung ab dauernder Trennung oder Scheidung"]
[{"$nulls":4},"für ganze Steuerperiode (vgl. § 52 StG ZH)"]

{"sheet":"Tarif","index":4,"n_rows":53,"n_cols":29,"rows_kept":53,"hidden":true,"merged":[[2,22,2,25],[3,22,3,23],[3,24,3,25],[31,22,31,27],[32,22,32,24],[32,25,32,27]],"flags":["formulas_cached_only"]}
[{"$nulls":9},"Formeln zur Steuerberechung:",{"$nulls":4},0]
[{"$nulls":11},"OS 66 508, i.K. 01.01.2012",null,"Ehemann","Ehefrau",{"$nulls":4},"Ehemann","Ehefrau"]
[{"$nulls":9},"Staatssteuer Einkommen",null,"§ 35 Abs. 2 StG, gültig ab 2012",null,"\"Verheiratetentarif\"",null,"Staatssteuer Einkommen",null,"§ 35 Abs. 1 StG, gültig ab 2012",null,"\"Grundtarif\"",null,null,"% / Grenzbeträge zum Einkopieren"]
[{"$nulls":9},"für","bis","%","max. Steuer","Steuer","Steuer","für","bis","%","max. Steuer","Steuer","Steuer",null,"Verheiratetentarif",null,"Grundtarif"]
[{"$nulls":9},{"v":13500,"d":"13,500"},{"v":13500,"d":"13,500"},0,0,0,0,{"v":6700,"d":"6,700"},{"v":6700,"d":"6,700"},0,0,0,0,null,{"v":13500,"d":"13,500"},0,{"v":6700,"d":"6,700"},0]
[{"$nulls":9},{"v":6100,"d":"6,100"},{"v":19600,"d":"19,600"},2,122,"","",{"v":4700,"d":"4,700"},{"v":11400,"d":"11,400"},2,94,"","",null,{"v":6100,"d":"6,100"},2,{"v":4700,"d":"4,700"},2]
[{"$nulls":9},{"v":7700,"d":"7,700"},{"v":27300,"d":"27,300"},3,353,"","",{"v":4700,"d":"4,700"},{"v":16100,"d":"16,100"},3,235,"","",null,{"v":7700,"d":"7,700"},3,{"v":4700,"d":"4,700"},3]
[{"$nulls":9},{"v":9400,"d":"9,400"},{"v":36700,"d":"36,700"},4,729,"","",{"v":7600,"d":"7,600"},{"v":23700,"d":"23,700"},4,539,"","",null,{"v":9400,"d":"9,400"},4,{"v":7600,"d":"7,600"},4]
[{"$nulls":9},{"v":10700,"d":"10,700"},{"v":47400,"d":"47,400"},5,{"v":1264,"d":"1,264"},"","",{"v":9300,"d":"9,300"},{"v":33000,"d":"33,000"},5,{"v":1004,"d":"1,004"},"","",null,{"v":10700,"d":"10,700"},5,{"v":9300,"d":"9,300"},5]
[{"$nulls":9},{"v":13900,"d":"13,900"},{"v":61300,"d":"61,300"},6,{"v":2098,"d":"2,098"},"","",{"v":10700,"d":"10,700"},{"v":43700,"d":"43,700"},6,{"v":1646,"d":"1,646"},"","",null,{"v":13900,"d":"13,900"},6,{"v":10700,"d":"10,700"},6]
[{"$nulls":9},{"v":30800,"d":"30,800"},{"v":92100,"d":"92,100"},7,{"v":4254,"d":"4,254"},"","",{"v":12400,"d":"12,400"},{"v":56100,"d":"56,100"},7,{"v":2514,"d":"2,514"},"","",null,{"v":30800,"d":"30,800"},7,{"v":12400,"d":"12,400"},7]
[{"$nulls":9},{"v":30800,"d":"30,800"},{"v":122900,"d":"122,900"},8,{"v":6718,"d":"6,718"},"","",{"v":16900,"d":"16,900"},{"v":73000,"d":"73,000"},8,{"v":3866,"d":"3,866"},"","",null,{"v":30800,"d":"30,800"},8,{"v":16900,"d":"16,900"},8]
[{"$nulls":9},{"v":46400,"d":"46,400"},{"v":169300,"d":"169,300"},9,{"v":10894,"d":"10,894"},"","",{"v":32500,"d":"32,500"},{"v":105500,"d":"105,500"},9,{"v":6791,"d":"6,791"},"","",null,{"v":46400,"d":"46,400"},9,{"v":32500,"d":"32,500"},9]
[{"$nulls":9},{"v":55400,"d":"55,400"},{"v":224700,"d":"224,700"},10,{"v":16434,"d":"16,434"},"","",{"v":32200,"d":"32,200"},{"v":137700,"d":"137,700"},10,{"v":10011,"d":"10,011"},"","",null,{"v":55400,"d":"55,400"},10,{"v":32200,"d":"32,200"},10]
[{"$nulls":9},{"v":60100,"d":"60,100"},{"v":284800,"d":"284,800"},11,{"v":23045,"d":"23,045"},"","",{"v":51000,"d":"51,000"},{"v":188700,"d":"188,700"},11,{"v":15621,"d":"15,621"},"","",null,{"v":60100,"d":"60,100"},11,{"v":51000,"d":"51,000"},11]
[{"$nulls":9},{"v":69300,"d":"69,300"},{"v":354100,"d":"354,100"},12,{"v":31361,"d":"31,361"},"","",{"v":66200,"d":"66,200"},{"v":254900,"d":"254,900"},12,{"v":23565,"d":"23,565"},"","",null,{"v":69300,"d":"69,300"},12,{"v":66200,"d":"66,200"},12]
[{"$nulls":9},"Kontrollsumme:",null,13,null,"","","Kontrollsumme:",null,13,null,"","",null,{"v":354100,"d":"354,100"},13,{"v":254900,"d":"254,900"},13]
[{"$nulls":9},{"v":354100,"d":"354,100"},{"v":1440200,"d":"1,440,200"},null,{"v":97272,"d":"97,272"},0,0,{"v":254900,"d":"254,900"},{"v":943800,"d":"943,800"},null,{"v":65886,"d":"65,886"},0,0]
[]
[{"$nulls":9},"Staatssteuer Vermögen ",null,"§ 47 Abs. 2 StG, gültig ab 2012",null,"Ehemann","Ehefrau","Staatssteuer Vermögen ",null,"§ 47 Abs. 1 StG, gültig ab 2012",null,"Ehemann","Ehefrau"]
[{"$nulls":9},"für","bis","%","max. Steuer","\"Verheiratetentarif\"",null,"für","bis","%","max. Steuer","\"Grundtarif\""]
[{"$nulls":9},{"v":142000,"d":"142,000"},{"v":154000,"d":"154,000"},0,0,0,0,{"v":77000,"d":"77,000"},{"v":77000,"d":"77,000"},0,0,0,0,null,{"v":154000,"d":"154,000"},0,{"v":77000,"d":"77,000"},0,null,null,0]
[{"$nulls":9},{"v":213000,"d":"213,000"},{"v":231000,"d":"231,000"},0.05,{"v":106.5,"d":"107"},"","",{"v":231000,"d":"231,000"},{"v":308000,"d":"308,000"},0.05,{"v":115.5,"d":"116"},"","",null,{"v":231000,"d":"231,000"},0.05,{"v":231000,"d":"231,000"},0.05]
[{"$nulls":9},{"v":355000,"d":"355,000"},{"v":385000,"d":"385,000"},0.1,{"v":461.5,"d":"462"},"","",{"v":386000,"d":"386,000"},{"v":694000,"d":"694,000"},0.1,{"v":501.5,"d":"502"},"","",null,{"v":385000,"d":"385,000"},0.1,{"v":386000,"d":"386,000"},0.1]
[{"$nulls":9},{"v":567000,"d":"567,000"},{"v":616000,"d":"616,000"},0.15,{"v":1312,"d":"1,312"},"","",{"v":616000,"d":"616,000"},{"v":1310000,"d":"1,310,000"},0.15,{"v":1425.5,"d":"1,426"},"","",null,{"v":616000,"d":"616,000"},0.15,{"v":616000,"d":"616,000"},0.15]
[{"$nulls":9},{"v":853000,"d":"853,000"},{"v":925000,"d":"925,000"},0.2,{"v":3018,"d":"3,018"},"","",{"v":925000,"d":"925,000"},{"v":2235000,"d":"2,235,000"},0.2,{"v":3275.5,"d":"3,276"},"","",null,{"v":925000,"d":"925,000"},0.2,{"v":925000,"d":"925,000"},0.2]
[{"$nulls":9},{"v":852000,"d":"852,000"},{"v":924000,"d":"924,000"},0.25,{"v":5148,"d":"5,148"},"","",{"v":923000,"d":"923,000"},{"v":3158000,"d":"3,158,000"},0.25,{"v":5583,"d":"5,583"},"","",null,{"v":924000,"d":"924,000"},0.25,{"v":923000,"d":"923,000"},0.25]
[{"$nulls":9},"Kontrollsumme:",null,0.3,null,"","","Kontrollsumme:",null,0.3,null,"","",null,{"v":3235000,"d":"3,235,000"},0.3,{"v":3158000,"d":"3,158,000"},0.3]
[{"$nulls":9},{"v":2982000,"d":"2,982,000"},{"v":3235000,"d":"3,235,000"},null,{"v":10046,"d":"10,046"},0,0,{"v":3158000,"d":"3,158,000"},{"v":7705000,"d":"7,705,000"},null,{"v":10901,"d":"10,901"},0,0]
[]
[{"$nulls":12},"Ehemann","Ehefrau",{"$nulls":3},"Ehemann","Ehefrau"]
[{"$nulls":9},"Bundessteuer","Art. 36 II DBG, ab 2012/2014*",null,"Ehepaar/Eineltern","Ehepaar/Eineltern",null,"Art. 36 I DBG, ab 2012/2014*",null,"Alleinstehende","Alleinstehende",{"$nulls":3},"% / Steuern / Grenzbeträge zum Einkopieren"]
[{"$nulls":9},"Grenzbetrag","Steuer","%","Steuer","Steuer","Grenzbetrag","Steuer","%","Steuer","Steuer",{"$nulls":3},"Ehepaar/Eineltern",null,null,"Alleinstehende"]
[{"$nulls":9},{"v":28300,"d":"28,300"},{"v":0,"d":"0.00"},0,0,0,{"v":14500,"d":"14,500"},{"v":0,"d":"0.00"},0,0,0,{"$nulls":3},{"v":28300,"d":"28,300"},{"v":0,"d":"0.00"},0,{"v":14500,"d":"14,500"},{"v":0,"d":"0.00"},0]
[{"$nulls":9},{"v":28300,"d":"28,300"},{"v":0,"d":"0.00"},1,"","",{"v":14500,"d":"14,500"},{"v":0,"d":"0.00"},0.77,"","",{"$nulls":3},{"v":28300,"d":"28,300"},{"v":0,"d":"0.00"},1,{"v":14500,"d":"14,500"},{"v":0,"d":"0.00"},0.77]
[{"$nulls":9},{"v":50900,"d":"50,900"},{"v":226,"d":"226.00"},2,"","",{"v":31600,"d":"31,600"},131.65,0.88,"","",{"$nulls":3},{"v":50900,"d":"50,900"},{"v":226,"d":"226.00"},2,{"v":31600,"d":"31,600"},131.65,0.88]
[{"$nulls":9},{"v":58400,"d":"58,400"},{"v":376,"d":"376.00"},3,"","",{"v":41400,"d":"41,400"},{"v":217.9,"d":"217.90"},2.64,"","",{"$nulls":3},{"v":58400,"d":"58,400"},{"v":376,"d":"376.00"},3,{"v":41400,"d":"41,400"},{"v":217.9,"d":"217.90"},2.64]
[{"$nulls":9},{"v":75300,"d":"75,300"},{"v":883,"d":"883.00"},4,"","",{"v":55200,"d":"55,200"},{"v":582.2,"d":"582.20"},2.97,"","",{"$nulls":3},{"v":75300,"d":"75,300"},{"v":883,"d":"883.00"},4,{"v":55200,"d":"55,200"},{"v":582.2,"d":"582.20"},2.97]
[{"$nulls":9},{"v":90300,"d":"90,300"},{"v":1483,"d":"1,483.00"},5,"","",{"v":72500,"d":"72,500"},{"v":1096,"d":"1,096.00"},5.94,"","",{"$nulls":3},{"v":90300,"d":"90,300"},{"v":1483,"d":"1,483.00"},5,{"v":72500,"d":"72,500"},{"v":1096,"d":"1,096.00"},5.94]
[{"$nulls":9},{"v":103400,"d":"103,400"},{"v":2138,"d":"2,138.00"},6,"","",{"v":78100,"d":"78,100"},{"v":1428.6,"d":"1,428.60"},6.6,"","",{"$nulls":3},{"v":103400,"d":"103,400"},{"v":2138,"d":"2,138.00"},6,{"v":78100,"d":"78,100"},{"v":1428.6,"d":"1,428.60"},6.6]
[{"$nulls":9},{"v":114700,"d":"114,700"},{"v":2816,"d":"2,816.00"},7,"","",{"v":103600,"d":"103,600"},{"v":3111.6,"d":"3,111.60"},8.8,"","",{"$nulls":3},{"v":114700,"d":"114,700"},{"v":2816,"d":"2,816.00"},7,{"v":103600,"d":"103,600"},{"v":3111.6,"d":"3,111.60"},8.8]
[{"$nulls":9},{"v":124200,"d":"124,200"},{"v":3481,"d":"3,481.00"},8,"","",{"v":134600,"d":"134,600"},{"v":5839.6,"d":"5,839.60"},11,"","",{"$nulls":3},{"v":124200,"d":"124,200"},{"v":3481,"d":"3,481.00"},8,{"v":134600,"d":"134,600"},{"v":5839.6,"d":"5,839.60"},11]
[{"$nulls":9},{"v":131700,"d":"131,700"},{"v":4081,"d":"4,081.00"},9,"","",{"v":176000,"d":"176,000"},{"v":10393.6,"d":"10,393.60"},13.2,"","",{"$nulls":3},{"v":131700,"d":"131,700"},{"v":4081,"d":"4,081.00"},9,{"v":176000,"d":"176,000"},{"v":10393.6,"d":"10,393.60"},13.2]
[{"$nulls":9},{"v":137300,"d":"137,300"},{"v":4585,"d":"4,585.00"},10,"","",{"v":755200,"d":"755,200"},{"v":86848,"d":"86,848.00"},null,"","",{"$nulls":3},{"v":137300,"d":"137,300"},{"v":4585,"d":"4,585.00"},10,{"v":755200,"d":"755,200"},{"v":86848,"d":"86,848.00"}]
[{"$nulls":9},{"v":141200,"d":"141,200"},{"v":4975,"d":"4,975.00"},11,"","",{"v":755300,"d":"755,300"},{"v":86859.5,"d":"86,859.50"},11.5,"","",{"$nulls":3},{"v":141200,"d":"141,200"},{"v":4975,"d":"4,975.00"},11,null,null,11.5]
[{"$nulls":9},{"v":143100,"d":"143,100"},{"v":5184,"d":"5,184.00"},12,"","",{"$nulls":3},0,0,{"$nulls":3},{"v":143100,"d":"143,100"},{"v":5184,"d":"5,184.00"},12]
[{"$nulls":9},{"v":145000,"d":"145,000"},{"v":5412,"d":"5,412.00"},13,"","",{"$nulls":8},{"v":145000,"d":"145,000"},{"v":5412,"d":"5,412.00"},13]
[{"$nulls":9},{"v":895800,"d":"895,800"},{"v":103016,"d":"103,016.00"},null,"","",{"$nulls":8},{"v":895800,"d":"895,800"},{"v":103016,"d":"103,016.00"}]
[{"$nulls":9},{"v":895900,"d":"895,900"},{"v":103028.5,"d":"103,028.50"},11.5,"","",{"$nulls":8},{"v":895900,"d":"895,900"},{"v":103028.5,"d":"103,028.50"},11.5]
[{"$nulls":12},0,0]
[{"$nulls":9},"* neuer Tarif: ","AS 2013 2397"]
[]
[{"$nulls":11},"Mindeststeuerbetrag:",25]

{"sheet":"Liegenschaft","index":5,"n_rows":96,"n_cols":11,"rows_kept":96,"flags":["formulas_cached_only"]}
["Verknüpfungen","Liegenschaftenrechnung i.S. Muster-Test",{"$nulls":7},"Verknüpfungen"]
[null,"Ehemann",null,null,"Bem.",null,"Bem.",null,"Ehefrau"]
[]
["an Steuern EM",{"$nulls":4},"Steuerwert Liegenschaft(en)",{"$nulls":3},"an Steuern EF"]
[null,"Kapital","Zins",null,null,"Berechnung Schuldzinsen/Jahr",null,"Zins","Kapital"]
[{"$nulls":5},"1. Hypothek"]
[{"$nulls":5},"2. Hypothek"]
[{"$nulls":5},"3. Hypothek"]
[{"$nulls":5},"Darlehen"]
[]
["an Steuern EM",0,{"$nulls":3},"Total Schulden Liegenschaft",null,null,0,"an Steuern EF"]
[]
[{"$nulls":5},"Aufwand/Jahr"]
[null,0,{"$nulls":3},"1. Hypothek",null,null,0]
[null,0,{"$nulls":3},"2. Hypothek",null,null,0]
[null,0,{"$nulls":3},"3. Hypothek",null,null,0]
[0,0,{"$nulls":3},"Darlehen",null,null,0,0]
[{"$nulls":5},"Gebäudeversicherung, kantonale"]
[{"$nulls":5},"Gebäude, Sachversicherung"]
[{"$nulls":5},"Gebäude, Haftpflichtversicherung"]
[{"$nulls":5},"Kehricht-Grundgebühr"]
[{"$nulls":5},"Wasser"]
[{"$nulls":5},"Abwasser"]
[{"$nulls":5},"Elektrisch/Gas"]
[{"$nulls":5},"Heizmaterial"]
[{"$nulls":5},"Kaminfeger"]
[{"$nulls":5},"Service-Abonnemente"]
[{"$nulls":5},"Tankrevision"]
[{"$nulls":5},"Kabelfernsehen"]
[{"$nulls":5},"Gartenpflege"]
[{"$nulls":5},"Hauswartung"]
[{"$nulls":5},"Verbandsbeiträge"]
["ev. an UHB",{"$nulls":4},"Verschiedenes",{"$nulls":3},"ev. an UHB"]
[]
[0,0,{"$nulls":3},"Aufwand ohne Rückstellungen/Jahr",null,null,0,0]
["Ausgaben/Monat",{"$nulls":8},"Ausgaben/Monat"]
[{"$nulls":5},"Rückstellung Unterhaltskosten"]
[{"$nulls":5},"Rückstellung Renovationen"]
[{"$nulls":5},"Amortisation Hypotheken/Darlehen"]
[]
[0,0,{"$nulls":3},"Total Aufwand/Jahr",null,null,0,0]
["Ausgaben/Monat",{"$nulls":4},"Bruttoertrag/Jahr",{"$nulls":3},"Ausgaben/Monat"]
[{"$nulls":5},"Mietzins(en)"]
[{"$nulls":5},"Nebenkosten"]
[]
["an Steuern EM",0,{"$nulls":3},"Total Bruttoertrag/Jahr",null,null,0,"an Steuern EF"]
[]
["an UHB",0,{"$nulls":3},"Nettoertrag ohne Rückstellungen/Jahr",null,null,0,"an UHB"]
[null,0,{"$nulls":3},"Nettoertrag abzügl. Rückstellungen/Jahr",null,null,0]
["an Steuern EM",{"$nulls":8},"an Steuern EF","% Eigenmietwert"]
[null,0,{"$nulls":3},"Eigenmietwert (EFH max. 3.75%, StWE max. 4.75% StW)",null,null,0,null,3.75]
[null,0,{"$nulls":3},"Pauschal-Unterhaltsabzug 20%",null,null,0,null,"Unterhaltsabzug"]
[0,0,{"$nulls":3},"Unterhaltsabzug effektiv (wenn > pauschal)",null,null,0,0,20]
[null,"26.7.2017"]
[null,"Bemerkungen und Beilagen zur Liegenschaftenrechnung i.S. Muster-Test"]
[]
[null,"Bemerkungen",1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,"Beilagen",{"v":1,"d":"1."}]
[null,null,{"v":2,"d":"2."}]
[null,null,{"v":3,"d":"3."}]
[null,null,{"v":4,"d":"4."}]
[null,null,{"v":5,"d":"5."}]
[null,null,{"v":6,"d":"6."}]
[null,null,{"v":7,"d":"7."}]
[null,null,{"v":8,"d":"8."}]
[null,null,{"v":9,"d":"9."}]
[null,null,{"v":10,"d":"10."}]
[null,null,{"v":11,"d":"11."}]
[null,null,{"v":12,"d":"12."}]
[null,null,{"v":13,"d":"13."}]
[null,null,{"v":14,"d":"14."}]
[null,null,{"v":15,"d":"15."}]
[null,null,{"v":16,"d":"16."}]
[null,null,{"v":17,"d":"17."}]
[null,null,{"v":18,"d":"18."}]
[null,null,{"v":19,"d":"19."}]
[null,null,{"v":20,"d":"20."}]

{"sheet":"Steuerfuss","index":6,"n_rows":173,"n_cols":12,"rows_kept":173,"flags":["formulas_cached_only"]}
["Steuerfuss-Tabelle",null,"Letzte Aktualisierung:","2017-07-26","EM","EF","Provisorisch","EM Gde-Diff.","EF-Gde-Diff.","nach Aktualisierungen Datum nachtragen!"]
["Steuerfuss Kanton:",100,"lt. KRB 14.12.15","LS 631.21","Zürich","Zürich",{"$nulls":5},"Aktualisierung: www.statistik.zh.ch"]
["Gemeindesteuerfüsse für das Jahr 2017 (ohne Gewähr!)",{"$nulls":3},"r","k",{"$nulls":3},"Quelle: Statistisches Amt Kt. Zürich",null,2017]
["               Konfession\nGemeinde","andere/keine","reformiert","katholisch",129,129,0,0,0,"Steuersätze mit irgendeinem Eintrag in Spalte J gelten als provisorisch!",null,"unterschiedliche Steuerfüsse innerhalb Gemeinde"]
["Adlikon",119,131,133,0,0,0,0,0,null,"Adlikon","SchulG, ref. KG, kath. KG"]
["Adliswil",102,113,114,0,0,0,0,0,null,"Adliswil",""]
["Aesch",87,98,98,0,0,0,0,0,null,"Aesch",""]
["Aeugst a.A.",96,109,110,0,0,0,0,0,null,"Aeugst a.A.",""]
["Affoltern a.A.",124,137,138,0,0,0,0,0,null,"Affoltern a.A.",""]
["Altikon",114,128,127,0,0,0,0,0,null,"Altikon",""]
["Andelfingen",114,126,128,0,0,0,0,0,null,"Andelfingen",""]
["Bachenbülach",106,116,117,0,0,0,0,0,null,"Bachenbülach",""]
["Bachs",130,144,143,0,0,0,0,0,null,"Bachs",""]
["Bäretswil",102,116,116,0,0,0,0,0,null,"Bäretswil",""]
["Bassersdorf",109,121,119,0,0,0,0,0,null,"Bassersdorf",""]
["Bauma",116,130,130,0,0,0,0,0,null,"Bauma",""]
["Benken",118,132,132,0,0,0,0,0,null,"Benken",""]
["Berg a.I.",109,123,122,0,0,0,0,0,null,"Berg a.I.",""]
["Birmensdorf",110,121,121,0,0,0,0,0,null,"Birmensdorf",""]
["Bonstetten",110,123,121,0,0,0,0,0,null,"Bonstetten",""]
["Boppelsen",91,102,101,0,0,0,0,0,null,"Boppelsen",""]
["Brütten",89,102,102,0,0,0,0,0,null,"Brütten",""]
["Bubikon",102,113,116,0,0,0,0,0,null,"Bubikon",""]
["Buch a.I.",109,123,122,0,0,0,0,0,null,"Buch a.I.",""]
["Buchs",111,122,121,0,0,0,0,0,null,"Buchs",""]
["Bülach",111,121,122,0,0,0,0,0,null,"Bülach",""]
["Dachsen",109,121,123,0,0,0,0,0,null,"Dachsen",""]
["Dägerlen",119,133,132,0,0,0,0,0,null,"Dägerlen"]
["Dällikon",109,120,119,0,0,0,0,0,null,"Dällikon",""]
["Dänikon",111,122,121,0,0,0,0,0,null,"Dänikon",""]
["Dättlikon",114,128,127,0,0,0,0,0,null,"Dättlikon",""]
["Dielsdorf",100,111,112,0,0,0,0,0,null,"Dielsdorf",""]
["Dietikon",129,141,142,0,0,0,0,0,null,"Dietikon",""]
["Dietlikon",95,106,104,0,0,0,0,0,null,"Dietlikon",""]
["Dinhard",89,103,102,0,0,0,0,0,null,"Dinhard","SchulG, ref. KG, kath. KG"]
["Dorf",109,123,122,0,0,0,0,0,null,"Dorf",""]
["Dübendorf",105,117,116,0,0,0,0,0,null,"Dübendorf",""]
["Dürnten",115,129,129,0,0,0,0,0,null,"Dürnten",""]
["Egg",98,110,107,0,0,0,0,0,null,"Egg",""]
["Eglisau",113,127,126,0,0,0,0,0,null,"Eglisau",""]
["Elgg",121,135,135,0,0,0,0,0,null,"Elgg","SchulG, ref. KG, kath. KG"]
["Ellikon a.d.Th.",119,133,132,0,0,0,0,0,null,"Ellikon a.d.Th.",""]
["Elsau",121,135,134,0,0,0,0,0,null,"Elsau",""]
["Embrach",118,130,131,0,0,0,0,0,null,"Embrach",""]
["Erlenbach",79,89,88,0,0,0,0,0,null,"Erlenbach",""]
["Fällanden",96,106,107,0,0,0,0,0,null,"Fällanden",""]
["Fehraltorf",107,121,120,0,0,0,0,0,null,"Fehraltorf",""]
["Feuerthalen",114,128,128,0,0,0,0,0,null,"Feuerthalen",""]
["Fischenthal",127,141,141,0,0,0,0,0,null,"Fischenthal",""]
["Flaach",110,124,123,0,0,0,0,0,null,"Flaach",""]
["Flurlingen",112,124,126,0,0,0,0,0,null,"Flurlingen",""]
["Freienstein-Teufen",97,111,110,0,0,0,0,0,null,"Freienstein-Teufen",""]
["Geroldswil",97,108,108,0,0,0,0,0,null,"Geroldswil",""]
["Glattfelden",112,126,125,0,0,0,0,0,null,"Glattfelden",""]
["Gossau",119,133,133,0,0,0,0,0,null,"Gossau",""]
["Greifensee",91,102,101,0,0,0,0,0,null,"Greifensee",""]
["Grüningen",113,126,127,0,0,0,0,0,null,"Grüningen",""]
["Hagenbuch",112,126,126,0,0,0,0,0,null,"Hagenbuch",""]
["Hausen a.A.",112,126,127,0,0,0,0,0,null,"Hausen a.A.",""]
["Hedingen",105,117,119,0,0,0,0,0,null,"Hedingen",""]
["Henggart",106,118,119,0,0,0,0,0,null,"Henggart",""]
["Herrliberg",78,87,87,0,0,0,0,0,null,"Herrliberg",""]
["Hettlingen",98,111,111,0,0,0,0,0,null,"Hettlingen",""]
["Hinwil",114,126,129,0,0,0,0,0,null,"Hinwil",""]
["Hirzel",130,141,145,0,0,0,0,0,null,"Hirzel",""]
["Hittnau",118,132,131,0,0,0,0,0,null,"Hittnau",""]
["Hochfelden",116,126,127,0,0,0,0,0,null,"Hochfelden",""]
["Hofstetten",135,149,149,0,0,0,0,0,null,"Hofstetten",""]
["Hombrechtikon",119,133,133,0,0,0,0,0,null,"Hombrechtikon",""]
["Horgen",87,97,97,0,0,0,0,0,null,"Horgen",""]
["Höri",114,124,125,0,0,0,0,0,null,"Höri",""]
["Humlikon",121,133,135,0,0,0,0,0,null,"Humlikon",""]
["Hüntwangen",101,115,114,0,0,0,0,0,null,"Hüntwangen",""]
["Hütten",135,149,150,0,0,0,0,0,null,"Hütten",""]
["Hüttikon",115,126,125,0,0,0,0,0,null,"Hüttikon",""]
["Illnau-Effretikon",115,128,128,0,0,0,0,0,null,"Illnau-Effretikon","ref. KG, kath. KG"]
["Kappel a.A.",112,126,127,0,0,0,0,0,null,"Kappel a.A.",""]
["Kilchberg",76,85,84,0,0,0,0,0,null,"Kilchberg",""]
["Kleinandelfingen",110,122,124,0,0,0,0,0,null,"Kleinandelfingen",""]
["Kloten",105,115,115,0,0,0,0,0,null,"Kloten",""]
["Knonau",111,125,126,0,0,0,0,0,null,"Knonau",""]
["Küsnacht",77,84,86,0,0,0,0,0,null,"Küsnacht",""]
["Langnau a.A.",102,114,115,0,0,0,0,0,null,"Langnau a.A.",""]
["Laufen-Uhwiesen",109,121,123,0,0,0,0,0,null,"Laufen-Uhwiesen",""]
["Lindau",115,127,128,0,0,0,0,0,null,"Lindau",""]
["Lufingen",89,103,102,0,0,0,0,0,null,"Lufingen",""]
["Männedorf",95,107,107,0,0,0,0,0,null,"Männedorf",""]
["Marthalen",113,127,127,0,0,0,0,0,null,"Marthalen"]
["Maschwanden",130,144,145,0,0,0,0,0,null,"Maschwanden",""]
["Maur",87,96.5,96,0,0,0,0,0,null,"Maur",""]
["Meilen",79,87,88,0,0,0,0,0,null,"Meilen",""]
["Mettmenstetten",101,113,116,0,0,0,0,0,null,"Mettmenstetten",""]
["Mönchaltorf",111,124,120,0,0,0,0,0,null,"Mönchaltorf",""]
["Neerach",76,88,88,0,0,0,0,0,null,"Neerach",""]
["Neftenbach",109,118,122,0,0,0,0,0,null,"Neftenbach",""]
["Niederglatt",107,120,119,0,0,0,0,0,null,"Niederglatt",""]
["Niederhasli",111,124,123,0,0,0,0,0,null,"Niederhasli",""]
["Niederweningen",108,118,120,0,0,0,0,0,null,"Niederweningen",""]
["Nürensdorf",90,102,100,0,0,0,0,0,null,"Nürensdorf",""]
["Oberembrach",117,129,130,0,0,0,0,0,null,"Oberembrach",""]
["Oberengstringen",112,122,126,0,0,0,0,0,null,"Oberengstringen",""]
["Oberglatt",122,134,134,0,0,0,0,0,null,"Oberglatt","SchulG, ref. KG, kath. KG"]
["Oberrieden",88,100,98,0,0,0,0,0,null,"Oberrieden",""]
["Oberstammheim",124,138,138,0,0,0,0,0,null,"Oberstammheim",""]
["Oberweningen",104,114,116,0,0,0,0,0,null,"Oberweningen",""]
["Obfelden",121,133,135,0,0,0,0,0,null,"Obfelden",""]
["Oetwil a.d.L.",94,105,105,0,0,0,0,0,null,"Oetwil a.d.L.",""]
["Oetwil a.S.",119,131,128,0,0,0,0,0,null,"Oetwil a.S.",""]
["Opfikon",99,107,108,0,0,0,0,0,null,"Opfikon",""]
["Ossingen",118,132,132,0,0,0,0,0,null,"Ossingen",""]
["Otelfingen",102,113,112,0,0,0,0,0,null,"Otelfingen",""]
["Ottenbach",117,131,131,0,0,0,0,0,null,"Ottenbach",""]
["Pfäffikon",105,117,118,0,0,0,0,0,null,"Pfäffikon",""]
["Pfungen",112,123,125,0,0,0,0,0,null,"Pfungen",""]
["Rafz",113,127,126,0,0,0,0,0,null,"Rafz",""]
["Regensberg",109,123,121,0,0,0,0,0,null,"Regensberg",""]
["Regensdorf",118,129,128,0,0,0,0,0,null,"Regensdorf",""]
["Rheinau",130,144,144,0,0,0,0,0,null,"Rheinau",""]
["Richterswil",108,120,123,0,0,0,0,0,null,"Richterswil",""]
["Rickenbach",106,118,119,0,0,0,0,0,null,"Rickenbach",""]
["Rifferswil",135,149,150,0,0,0,0,0,null,"Rifferswil",""]
["Rorbas",104,118,117,0,0,0,0,0,null,"Rorbas",""]
["Rümlang",107,118,118,0,0,0,0,0,null,"Rümlang",""]
["Rüschlikon",78,88,88,0,0,0,0,0,null,"Rüschlikon",""]
["Russikon",113,125,126,0,0,0,0,0,null,"Russikon",""]
["Rüti",121,135,135,0,0,0,0,0,null,"Rüti",""]
["Schlatt",128,142,140,0,0,0,0,0,null,"Schlatt",""]
["Schleinikon",110,120,122,0,0,0,0,0,null,"Schleinikon"]
["Schlieren",114,125,126,0,0,0,0,0,null,"Schlieren",""]
["Schöfflisdorf",107,117,119,0,0,0,0,0,null,"Schöfflisdorf",""]
["Schönenberg",114,127,129,0,0,0,0,0,null,"Schönenberg",""]
["Schwerzenbach",103,113,114,0,0,0,0,0,null,"Schwerzenbach",""]
["Seegräben",113,125,127,0,0,0,0,0,null,"Seegräben",""]
["Seuzach",92,103.5,105,0,0,0,0,0,null,"Seuzach",""]
["Stadel",112,126,125,0,0,0,0,0,null,"Stadel",""]
["Stäfa",90,102,102,0,0,0,0,0,null,"Stäfa",""]
["Stallikon",98,106,109,0,0,0,0,0,null,"Stallikon",""]
["Steinmaur",108,120,120,0,0,0,0,0,null,"Steinmaur",""]
["Thalheim a.d.Th.",107,121,120,0,0,0,0,0,null,"Thalheim a.d.Th.",""]
["Thalwil",85,97,95,0,0,0,0,0,null,"Thalwil",""]
["Trüllikon",111,125,125,0,0,0,0,0,null,"Trüllikon",""]
["Truttikon",124,138,138,0,0,0,0,0,null,"Truttikon",""]
["Turbenthal",122,136,135,0,0,0,0,0,null,"Turbenthal","SchulG, ref. KG, kath. KG"]
["Uetikon a.S.",87,97,99,0,0,0,0,0,null,"Uetikon a.S.",""]
["Uitikon",83,92,94,0,0,0,0,0,null,"Uitikon",""]
["Unterengstringen",100,111,114,0,0,0,0,0,null,"Unterengstringen",""]
["Unterstammheim",122,136,136,0,0,0,0,0,null,"Unterstammheim",""]
["Urdorf",118,127,129,0,0,0,0,0,null,"Urdorf",""]
["Uster",109,119,119,0,0,0,0,0,null,"Uster","SchulG, ref. KG, kath. KG"]
["Volken",119,133,132,0,0,0,0,0,null,"Volken",""]
["Volketswil",100,108,110,0,0,0,0,0,null,"Volketswil",""]
["Wädenswil",106,116,118,0,0,0,0,0,null,"Wädenswil",""]
["Wald",122,136,138,0,0,0,0,0,null,"Wald",""]
["Wallisellen",97,104,106,0,0,0,0,0,null,"Wallisellen",""]
["Waltalingen",130,144,144,0,0,0,0,0,null,"Waltalingen",""]
["Wangen-Brüttisellen",96,107,105,0,0,0,0,0,null,"Wangen-Brüttisellen",""]
["Wasterkingen",108,122,121,0,0,0,0,0,null,"Wasterkingen",""]
["Weiach",94,105,107,0,0,0,0,0,null,"Weiach",""]
["Weiningen",101,112,112,0,0,0,0,0,null,"Weiningen",""]
["Weisslingen",101,114,113,0,0,0,0,0,null,"Weisslingen",""]
["Wettswil a.A.",89,97,100,0,0,0,0,0,null,"Wettswil a.A.",""]
["Wetzikon",119,133,133,0,0,0,0,0,null,"Wetzikon",""]
["Wiesendangen",90,105,103,0,0,0,0,0,null,"Wiesendangen","ref. KG, kath. KG"]
["Wil",103,117,116,0,0,0,0,0,null,"Wil",""]
["Wila",124,138,137,0,0,0,0,0,null,"Wila",""]
["Wildberg",130,144,143,0,0,0,0,0,null,"Wildberg","SchulG, ref. KG, kath. KG"]
["Winkel",76,86,87,0,0,0,0,0,null,"Winkel",""]
["Winterthur",124,136,140,0,0,0,0,0,null,"Winterthur",""]
["Zell",122,136,134,0,0,0,0,0,null,"Zell",""]
["Zollikon",82,89,91,0,0,0,0,0,null,"Zollikon",""]
["Zumikon",85,94,94,0,0,0,0,0,null,"Zumikon",""]
["Zürich",119,129,129,129,129,0,0,0,null,"Zürich",""]
[{"$nulls":4},0,0,0,0,0,null,0,""]

{"sheet":"Benutzerhinweise","index":7,"n_rows":25,"n_cols":2,"rows_kept":25,"flags":["formulas_cached_only"]}
[null,"Hinweise zu UHB.XLT (© chanson@arbeitsrechtler.ch)"]
[null,"Anwendung:"]
[null,"*** Zahlen nur in die dafür vorgesehenen (schraffierten) Eingabefelder eingeben! Pinkfarbige Zahlen (bei Grunddaten auch Text) sind Vorschläge, die überschrieben werden können."]
[null,"*** Vor Berechnung alle Grunddaten im Blatt 'UHB' (Zellen B1-I5) eingeben. Bei Ortsnamen Gemeinde aus Liste auswählen."]
[null,"*** Möglich ist die Berechnung in 2 Varianten (Überschussbeteiligung mit oder ohne Kinderzulagen). Standardeinstellung in der Vorlage ist \"exklusive\". Zum Wechseln Schaltfläche \"Kinderzulagen .....\" betätigen."]
[null,"*** Verknüpfungen zwischen Steuerberechnungen und UHB-Tabelle (rot=Export, blau=Import) in jedem Fall auf Richtigkeit checken (speziell Formeln in 'Steuern EM' und 'Steuern EF')."]
[null,"*** Vorschlag Unterhaltsbeitrag in Manko-Fällen speziell auf Billigkeit prüfen und via Aufteilung Freibetrag allenfalls korrieren. Allenfalls 20% Zuschlag (Zulässigkeit umstritten) wählen."]
[null,"***Annähern UHB an Steuern kann automatisch erfolgen. Nach Eingabe aller Zahlen Schaltfläche \"Steuern automatisch berechnen\", ganz unten, betätigen und eingeblendete Hinweise beachten. Für"]
[null,"manuelles Einfügen der Steuerbeträge in den Feldern B54/55 + I54/55 (ohne automatische Neuberechnung) Schaltfläche 'Steuern einfügen' oder via Tastatur <Ctrl+S>."]
[null,"*** Die Automatische Berechnung kann unter <Extras><Optionen><Berechnen> vorübergehend oder dauernd ausgeschaltet werden, was die Zahleneingabe wesentlich schneller macht."]
[null,"*** Der Steuerfuss wird gestützt auf die Angaben im Blatt 'Steuerfuss' vorgeschlagen, kann aber überschrieben werden. Achtung: Steuerfüsse ändern jährlich."]
[null,"*** Steuersätze und Abzüge basieren auf der jeweiligen Wegleitung. Vorschläge Abzüge checken! Bei Gesetzesänderungen jeweils Grenzbeträge und neue Abzüge ändern. "]
[null,"*** mit dem Schaltknopf <UHB> Wechsel ins Blatt 'UHB'"]
[null,"*** Für die Arbeit am PC (und im Ausdruck nicht sichtbar) können durch <Einfügen> <Notizen> einzelnen Zellen Notizen zugeordnet oder diese abgerufen werden. Notizen sind durch rotes Quadrat in der rechten oberen Zellenecke erkennbar."]
[null,"*** Für sichtbare Bemerkungen ist das Blatt 'Bemerk' vorgesehen. Die Ziffern zu den erläuternden Bemerkungen können im Blatt 'UHB' in den Spalten C und H eingesetzt werden."]
[null,"Anpassungen:"]
[null,"*** Das Blatt 'Tarif' ist ausgeblendet (allenfalls via <Format><Blatt> einblenden). Bei Änderungen dort anpassen."]
[null,"Bei Bundessteuer 1. Grenzbetrag jeweils Fr. 100.-- unter der entsprechenden Zahl im Tarif. Restliche entsprechen der ersten Zahl für jede neue %-Gruppe. Bei Staatssteuer \"von/bis\" Tarif, dh. Differenz zwischen Stufen errechnen."]
[null,"*** Das Blatt 'Makros' ist in der Mustervorlage ausgeblendet (allenfalls via <Format><Blatt> einblenden). Falls in 'UHB' zusätzliche Zeilen eingefügt werden, müssten alle Zeilennummern im Makro entsprechend angepasst werden."]
[null,"*** Die Vorlage ist als Dateityp \"Mustervorlage\" gespeichert und kann nach Änderungen mit <Datei><Speichern unter> mit diesem Dateityp wieder unter dem ursprünglichen Namen UHB.XLT gespeichert werden."]
[null,"Feed-Back:"]
[null,"*** Support kann ich nicht leisten. Für verlorene Prozesse infolge allfälliger Fehler in der Vorlage hafte ich nicht. Für Verbesserungsvorschläge oder Hinweise auf Fehler bin ich jedoch dankbar."]
[null,"*** Viele Anregungen verdanke ich Martin Pestalozzi, 8630 Rüti, von dem auch die Grundstruktur des Blattes 'Liegenschaft' stammt. Wertvolle Hinweise stammen auch von Martin Farner, Zürich. Für die Erhebung bzw. Überprüfung der Daten ab 2014 und nützliche Hinweise danke ich Birgit Ramildi, Zürich/Regensdorf."]
[null,"01.02.2017/Georges Chanson, CHANSON WILLE Rechtsanwälte, Postfach 1605, 8027 Zürich, "]
[null,"                  Telefon 044 201 10 30, Fax 044 201 47 51, chanson@arbeitsrechtler.ch  www.arbeitsrechtler.ch"]

{"sheet":"Dialog1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Dialog2","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"Dialog3","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}