{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["GR","RT","StR","Änderungsprotokoll (Updates)","Stammdaten"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":15,"comments":3,"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":82,"n_cols":19,"rows_kept":82,"cut":false,"hidden":false,"merged":[[70,12,70,16],[70,4,70,10],[67,0,69,0],[56,4,56,5],[65,0,66,0],[64,1,64,16],[69,1,69,16],[0,1,0,16],[56,12,56,13],[15,4,15,5],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[15,6,15,9],[10,4,10,5],[56,6,56,9],[56,14,56,15],[12,4,12,5],[50,1,50,2],[1,11,1,16],[6,4,6,5],[7,4,7,5],[2,0,3,0],[13,4,13,5],[8,4,8,5],[1,3,1,10],[2,4,2,5],[3,4,3,5],[4,4,4,5],[2,14,2,15],[2,6,2,9],[5,12,5,13],[8,12,8,13],[9,1,9,16],[5,4,5,5],[7,12,7,13],[2,12,2,13],[6,12,6,13],[3,12,3,13],[4,12,4,13],[15,12,15,13],[11,4,11,5],[14,1,14,16],[13,1,13,2],[54,17,54,18],[54,1,54,2],[15,3,16,3],[15,14,15,15],[15,11,16,11],[16,14,16,18],[81,1,81,16],[53,4,53,5],[53,12,53,13],[55,1,55,16],[51,1,51,16],[80,12,80,13],[79,4,79,5],[80,4,80,5],[79,12,79,13],[77,1,77,16],[78,4,78,10],[78,12,78,16],[73,1,73,16],[57,1,57,16],[58,4,58,5],[58,12,58,13]]}
["GRUNDDATEN","Grunddaten der verheirateten Eltern und Kinder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S4=\"betreut Kinder\",\"! aktiviert !\",\"nicht aktiviert\")","v":"nicht aktiviert"}]
[null,null,"Quelle / Gesamt","Finanziell weniger leistungsfähiger Elternteil (grds. mit überwiegendem Betreuungsanteil)",null,null,null,null,null,null,null,"Anderer Elternteil",null,null,null,null,null,"Neuer Partner","Quelle / Gesamt"]
[null,"Zivilstand","verheiratet",null,"In der Regel überwiegend betreuender Elternteil",null,"Kinder",null,null,null,null,null,"anderer Elternteil",null,"Kinder",null,null,"Neuer Partner","Betreuung"]
[null,"Stichtag eingeben",null,null,"Elternteil 1",null,"Kind 1","Kind 2","Kind 3","Kind 4",null,null,"Elternteil 2",null,"Kind 1","Kind 2",null,"Elternteil 3","betreut Kinder nicht"]
["A1","Name eingeben"]
["A2","Geburtstag eingeben"]
["C1","Alter (Jahre)",null,null,{"$f":"IF(AND($C$4<>\"\",E6<>\"\"),DATEDIF(E6,$C$4,\"Y\")&\" Jahre\",IF(E6<>\"\",DATEDIF(E6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",G6<>\"\"),DATEDIF(G6,$C$4,\"Y\")&\" Jahre\",IF(G6<>\"\",DATEDIF(G6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",H6<>\"\"),DATEDIF(H6,$C$4,\"Y\")&\" Jahre\",IF(H6<>\"\",DATEDIF(H6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",I6<>\"\"),DATEDIF(I6,$C$4,\"Y\")&\" Jahre\",IF(I6<>\"\",DATEDIF(I6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",J6<>\"\"),DATEDIF(J6,$C$4,\"Y\")&\" Jahre\",IF(J6<>\"\",DATEDIF(J6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},null,null,{"$f":"IF(AND($C$4<>\"\",M6<>\"\"),DATEDIF(M6,$C$4,\"Y\")&\" Jahre\",IF(M6<>\"\",DATEDIF(M6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",O6<>\"\"),DATEDIF(O6,$C$4,\"Y\")&\" Jahre\",IF(O6<>\"\",DATEDIF(O6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",P6<>\"\"),DATEDIF(P6,$C$4,\"Y\")&\" Jahre\",IF(P6<>\"\",DATEDIF(P6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",R6<>\"\"),DATEDIF(R6,$C$4,\"Y\")&\" Jahre\",IF(R6<>\"\",DATEDIF(R6,TODAY(),\"Y\")&\" Jahre\",\"\"))","v":""}]
["C1","Alter (Monate)",null,null,{"$f":"IF(AND($C$4<>\"\",E6<>\"\"),DATEDIF(E6,$C$4,\"ym\")&\" Monate\",IF(E6<>\"\",DATEDIF(E6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",G$6<>\"\"),DATEDIF(G$6,$C$4,\"ym\")&\" Monate\",IF(G$6<>\"\",DATEDIF(G$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",H$6<>\"\"),DATEDIF(H$6,$C$4,\"ym\")&\" Monate\",IF(H$6<>\"\",DATEDIF(H$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",I$6<>\"\"),DATEDIF(I$6,$C$4,\"ym\")&\" Monate\",IF(I$6<>\"\",DATEDIF(I$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",J$6<>\"\"),DATEDIF(J$6,$C$4,\"ym\")&\" Monate\",IF(J$6<>\"\",DATEDIF(J$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},null,null,{"$f":"IF(AND($C$4<>\"\",M$6<>\"\"),DATEDIF(M$6,$C$4,\"ym\")&\" Monate\",IF(M$6<>\"\",DATEDIF(M$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",O$6<>\"\"),DATEDIF(O$6,$C$4,\"ym\")&\" Monate\",IF(O$6<>\"\",DATEDIF(O$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",P$6<>\"\"),DATEDIF(P$6,$C$4,\"ym\")&\" Monate\",IF(P$6<>\"\",DATEDIF(P$6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",R6<>\"\"),DATEDIF(R6,$C$4,\"ym\")&\" Monate\",IF(R6<>\"\",DATEDIF(R6,TODAY(),\"ym\")&\" Monate\",\"\"))","v":""}]
["C1","Alter (Tage)",null,null,{"$f":"IF(AND($C$4<>\"\",E6<>\"\"),DATEDIF(E6,$C$4,\"yd\")&\" Tage\",IF(E6<>\"\",DATEDIF(E6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",G$6<>\"\"),DATEDIF(G$6,$C$4,\"yd\")&\" Tage\",IF(G$6<>\"\",DATEDIF(G$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",H$6<>\"\"),DATEDIF(H$6,$C$4,\"yd\")&\" Tage\",IF(H$6<>\"\",DATEDIF(H$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",I$6<>\"\"),DATEDIF(I$6,$C$4,\"yd\")&\" Tage\",IF(I$6<>\"\",DATEDIF(I$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",J$6<>\"\"),DATEDIF(J$6,$C$4,\"yd\")&\" Tage\",IF(J$6<>\"\",DATEDIF(J$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},null,null,{"$f":"IF(AND($C$4<>\"\",M$6<>\"\"),DATEDIF(M$6,$C$4,\"yd\")&\" Tage\",IF(M$6<>\"\",DATEDIF(M$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",O$6<>\"\"),DATEDIF(O$6,$C$4,\"yd\")&\" Tage\",IF(O$6<>\"\",DATEDIF(O$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},{"$f":"IF(AND($C$4<>\"\",P$6<>\"\"),DATEDIF(P$6,$C$4,\"yd\")&\" Tage\",IF(P$6<>\"\",DATEDIF(P$6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""},null,{"$f":"IF(AND($C$4<>\"\",R6<>\"\"),DATEDIF(R6,$C$4,\"yd\")&\" Tage\",IF(R6<>\"\",DATEDIF(R6,TODAY(),\"yd\")&\" Tage\",\"\"))","v":""}]
["Einkommensberechnung","Einkommensberechnung"]
["C1","Nettoeinkommen"]
["C1","Weiteres Einkommen"]
["C1","Kinder- und Familienzulagen"]
["B4","Monatl. Einkommen",null,null,{"$f":"SUM(E11:E13)","v":0},null,{"$f":"SUM(G11:G13)","v":0},{"$f":"SUM(H11:H13)","v":0},{"$f":"SUM(I11:I13)","v":0},{"$f":"SUM(J11:J13)","v":0},null,null,{"$f":"SUM(M11:M13)","v":0},null,{"$f":"SUM(O11:O13)","v":0},{"$f":"SUM(P11:P13)","v":0},null,{"$f":"SUM(R11:R13)","v":0}]
["Bedarfsberechnung","Bedarfsberechnung"]
[null,null,"Quelle","Kosten effektiv",{"$f":"\"Bedarf \"&IF(E5=\"\",\"\",E5)","v":"Bedarf "},null,"Barbedarf Kinder",null,null,null,"Lebenshaltungskosten","Kosten effektiv",{"$f":"\"Bedarf \"&IF(M5=\"\",\"\",M5)","v":"Bedarf "},null,"Barbedarf Kinder",null,"Lebenshaltungskosten",{"$f":"\"Bedarf \"&IF(R5=\"\",\"\",R5)&\"\"","v":"Bedarf "},"Quelle"]
[null,null,null,null,"fam. Notbedarf","erw. Bedarf",null,null,null,null,null,null,"fam. Notbedarf","erw. Bedarf"]
["C1","Grundbetr.",null,{"$f":"SUM(E18:J18)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(M18:P18)","v":0}]
["C1","Wohn- inkl. Nebenkosten",null,{"$f":"SUM(E19:J19)","v":0},null,null,null,null,null,null,null,0]
["C6","Krankenkasse (KVG, abzgl. IPV)",null,{"$f":"SUM(E20:F20)","v":0},null,null,null,null,null,null,null,0]
["C6","Zus. Ges.kosten Elternteil",null,{"$f":"SUM(E21:F21)","v":0},null,null,null,null,null,null,null,0]
["C6","Versicherungen",null,{"$f":"SUM(E22:F22)","v":0},null,null,null,null,null,null,null,0]
["C6","Billag",null,{"$f":"SUM(E23:J23)","v":0},null,null,null,null,null,null,null,0]
["C14","Kommunikationskosten",null,0,null,null,null,null,null,null,null,0]
["C8","Krankenkasse Kinder",null,0,null,null,null,null,null,null,null,0]
["C10","Zus. Ges.kosten Kinder",null,0,null,null,null,null,null,null,null,0]
["C10","Zus. Kinderkosten",null,0,null,null,null,null,null,null,null,0]
["C10","Fremdbetreuungskosten",null,0,null,null,null,null,null,null,null,0]
["C6","Kompensation Vorsorge",null,0,null,null,null,null,null,null,null,0]
["C13","Mobilitätskosten",null,0,null,null,null,null,null,null,null,0]
["C14","Verpflegung",null,0,null,null,null,null,null,null,null,0]
["C14","zus. berufsbed. Kosten",null,0,null,null,null,null,null,null,null,0]
["C14","Krankenkasse (VVG)",null,0,null,null,null,null,null,null,null,0]
["C14","Hobbies/Freizeit",null,0,null,null,null,null,null,null,null,0]
["C12","Steuern eingeben",null,{"$f":"SUM(E35:J35)","v":0},null,null,null,null,null,null,null,0]
["C20",null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(M36:P36)","v":0}]
["C20",null,null,0,null,null,null,null,null,null,null,0]
["C20",null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(M38:P38)","v":0}]
["C21",null,null,0,null,null,null,null,null,null,null,{"$f":"SUM(M39:P39)","v":0}]
["C21",null,null,{"$f":"SUM(E40:J40)","v":0},null,null,null,null,null,null,null,0]
["C21",null,null,{"$f":"SUM(E41:J41)","v":0},null,null,null,null,null,null,null,0]
["C21",null,null,{"$f":"SUM(E42:J42)","v":0},null,null,null,null,null,null,null,0]
["C21",null,null,0,null,null,null,null,null,null,null,0]
["C21",null,null,{"$f":"SUM(E44:J44)","v":0},null,null,null,null,null,null,null,0]
["C21",null,null,{"$f":"SUM(E45:J45)","v":0},null,null,null,null,null,null,null,0]
["C21",null,null,{"$f":"SUM(E46:J46)","v":0},null,null,null,null,null,null,null,0]
["C23",null,null,0,null,null,null,null,null,null,null,0]
["C23",null,null,0,null,null,null,null,null,null,null,0]
["C23",null,null,{"$f":"SUM(E49:J49)","v":0},null,null,null,null,null,null,null,0]
["C24",null,null,0,null,null,null,null,null,null,null,0]
[null,"Summe",null,{"$f":"SUM(D18:D50)","v":0},{"$f":"SUM(E$18:E$50)","v":0},0,0,0,0,0,0,{"$f":"SUM(L18:L50)","v":0},{"$f":"SUM(M$18:M$50)","v":0},{"$f":"SUM(N$18:N$50)","v":0},{"$f":"SUM(O$18:O$50)","v":0},{"$f":"SUM(P$18:P$50)","v":0},{"$f":"IF($S$4=\"betreut Kinder nicht\",SUM(Q$18:Q$50),IF($S$4=\"betreut Kinder\",SUM(Q$18:Q$50),\"\"))","v":0},{"$f":"SUM(R$18:R$50)","v":0}]
[null,"Betreuungsunterhalt"]
["C14","Lebenshaltungskosten",null,null,null,null,null,null,null,null,{"$f":"K$51","v":0},null,null,null,null,null,{"$f":"Q$51","v":0}]
["C14","Einkommen",null,null,{"$f":"E$14","v":0},null,null,null,null,null,null,null,{"$f":"M$14","v":0},null,null,null,null,{"$f":"R14","v":0}]
[null,"Betreuungsunterhalt gesamt ",null,{"$f":"IF(SUM(K$51-E$14)>=0,SUM(K$51-E$14),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S4=\"betreut Kinder\",SUM(Q$51-R$14)>0),SUM(Q$51-R$14),IF(AND(S4=\"betreut Kinder nicht\",SUM(Q$51-M$14)>0),SUM(Q$51-M$14),0))","v":0},"Betreuungsunterhalt gesamt"]
[null,"Übersicht finanzielle Verhältnisse"]
[null,null,"Gesamt","Total",{"$f":"\"Finanzielle Verhältnisse \"&IF(E5=\"\",\"\",E5)","v":"Finanzielle Verhältnisse "},null,"Kinder",null,null,null,"Lebenshaltungskosten","Total",{"$f":"\"Finanzielle Verhältnisse \"&IF(M5=\"\",\"\",M5)","v":"Finanzielle Verhältnisse "},null,"Kinder",null,"Lebenshaltungskosten"]
[null,"Verfügbare Mittel der Elternteile"]
["C25","Gesamteinkommen (inkl. anzurechnendes Einkommen Kinder)",{"$f":"SUM(D59,L59)","v":0},{"$f":"SUM(E14,G14:J14)","v":0},{"$f":"IF(E14<>\"\",E14,\"\")","v":0},null,{"$f":"IF(G14>G51,G51,G14)","v":0},{"$f":"IF(H14>H51,H51,H14)","v":0},{"$f":"IF(I14>I51,I51,I14)","v":0},{"$f":"IF(J14>J51,J51,J14)","v":0},null,{"$f":"IF(SUM(O14:P14)>SUM(O51:P51),SUM(M14,O51:P51),SUM(M14,O14:P14))","v":0},{"$f":"IF(M14<>\"\",M14,\"\")","v":0},null,{"$f":"IF(O14>O51,O51,O14)","v":0},{"$f":"IF(P14>P51,P51,P14)","v":0}]
["C25","abzgl. fam. Notbedarf Eltern",0,{"$f":"-SUM(E51)","v":0},{"$f":"IF(E51<>\"\",SUM(E51),\"\")","v":0},null,null,null,null,null,null,{"$f":"-SUM(M51)","v":0},{"$f":"IF(M51<>\"\",SUM(M51),\"\")","v":0}]
["Unterhaltsberechnung","abzgl. Barbedarf Kinder",0,{"$f":"-SUM(G51:J51)","v":0},null,null,{"$f":"IF(G51<>\"\",G51,\"\")","v":0},{"$f":"IF(H51<>\"\",H51,\"\")","v":0},{"$f":"IF(I51<>\"\",I51,\"\")","v":0},{"$f":"IF(J51<>\"\",J51,\"\")","v":0},{"$f":"IF(E61=\"\",\"\",E61)","v":""},{"$f":"-SUM(O61,P61)","v":0},null,null,{"$f":"IF(O51<>\"\",O51,\"\")","v":0},{"$f":"IF(P51<>\"\",P51,\"\")","v":0}]
[null,"Überschuss über fam. Notbedarf und Barbedarf Kinder",0,{"$f":"SUM(D59:D61)","v":0},null,null,null,null,null,null,{"$f":"IF(E62=\"\",\"\",E62)","v":""},{"$f":"SUM(L59:L61)","v":0}]
[null,"abzgl. erw. Bedarfe",0,{"$f":"-SUM(F51)","v":0},null,{"$f":"IF(F51<>\"\",SUM(F51),\"\")","v":0},null,null,null,null,{"$f":"IF(E63=\"\",\"\",E63)","v":""},{"$f":"-SUM(N51)","v":0},null,{"$f":"IF(N51<>\"\",SUM(N51),\"\")","v":0}]
[null,"Überschuss über erw. Bedarf",0,{"$f":"SUM(D62:D63)","v":0},null,null,null,null,null,null,{"$f":"IF(E64=\"\",\"\",E64)","v":""},{"$f":"SUM(L62:L63)","v":0}]
[null," Bestimmung Barbedarf der Kinder"]
[null,"Überschuss Elterneinkommen nach Abzug fam. Notbedarf der Eltern",{"$f":"SUM(D66,L66)","v":0},{"$f":"SUM(E14-E51)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(M14-M51)","v":0}]
[null,"abzüglich Barbedarf Kinder",{"$f":"SUM(D67,L67)","v":0},{"$f":"-SUM(G67:J67)","v":0},null,null,{"$f":"IF(G51<>\"\",G51,\"\")","v":0},{"$f":"IF(H51<>\"\",H51,\"\")","v":0},{"$f":"IF(I51<>\"\",I51,\"\")","v":0},{"$f":"IF(J51<>\"\",J51,\"\")","v":0},null,{"$f":"-SUM(O67:P67)","v":0},null,null,{"$f":"IF(O51<>\"\",O51,\"\")","v":0},{"$f":"IF(P51<>\"\",P51,\"\")","v":0}]
[null,"zzgl. Einkommen Kinder",{"$f":"SUM(D68,L68)","v":0},{"$f":"IF(SUM(G68:J68)>=SUM(G67:J67),SUM(G67:J67),SUM(G68:J68))","v":0},null,null,{"$f":"IF(G14<>\"\",G14,\"\")","v":0},{"$f":"IF(H14<>\"\",H14,\"\")","v":0},{"$f":"IF(I14<>\"\",I14,\"\")","v":0},{"$f":"IF(J14<>\"\",J14,\"\")","v":0},null,{"$f":"IF(SUM(O68:P68)>=SUM(O67:P67),SUM(O67:P67),SUM(O68:P68))","v":0},null,null,{"$f":"IF(O14<>\"\",O14,\"\")","v":0},{"$f":"IF(P14<>\"\",P14,\"\")","v":0}]
[null,"Überschuss nach Deckung Barbedarf / Anspruch je Kind",{"$f":"SUM(D69,L69)","v":0},{"$f":"SUM(D66,IF(D67<>\"\",D67,0),IF(D68<>\"\",D68,0))","v":0},null,null,{"$f":"IF(SUM(G67-G68)>0,SUM(G67-G68),0)","v":0},{"$f":"IF(SUM(H67-H68)>0,SUM(H67-H68),0)","v":0},{"$f":"IF(SUM(I67-I68)>0,SUM(I67-I68),0)","v":0},{"$f":"IF(SUM(J67-J68)>0,SUM(J67-J68),0)","v":0},null,{"$f":"SUM(L66,IF(L67<>\"\",L67,0),IF(L68<>\"\",L68,0))","v":0},null,null,{"$f":"IF(SUM(O67-O68)>0,SUM(O67-O68),0)","v":0},{"$f":"IF(SUM(P67-P68)>0,SUM(P67-P68),0)","v":0}]
[null,"Bestimmung des theoretischen Betreuungsunterhaltes der Kinder"]
[null,"Überschuss nach Abzug Barbedarf",{"$f":"SUM(C69)","v":0},{"$f":"SUM(D69)","v":0},"Betreuungsunterhalt über- od. unterschritten",null,null,null,null,null,null,{"$f":"SUM(L69)","v":0},"Betreuungsunterhalt über- od. unterschritten"]
[null,"Betreuungsunterhalt pro Kind eingeben",null,null,null,null,null,null,null,null,{"$f":"D$55","v":0},null,null,null,null,null,{"$f":"Q$55","v":0}]
[null,"Anspruch je Kind",null,null,null,null,{"$f":"SUM(G72)","v":0},{"$f":"SUM(H72)","v":0},{"$f":"SUM(I72)","v":0},{"$f":"SUM(J72)","v":0},null,null,null,null,{"$f":"SUM(O72)","v":0},{"$f":"SUM(P72)","v":0}]
[null,"Verfügbare Mittel zur Deckung erweiterter Bedarf nach Deckung Kinderunterhaltsbeiträge"]
[null,"Verbleibende Mittel nach Deckung Gesamtnotbedarf und Kinderunterhalt",{"$f":"D75+L75","v":0},{"$f":"D59-D51+F51","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L59-L51+N51)-SUM(O72:P72)","v":0}]
[null,"abzüglich theoretisch zahlbare erw. Bedarfe",{"$f":"SUM(D76,L76)","v":0},{"$f":"-SUM(F76)","v":0},null,{"$f":"F51","v":0},null,null,null,null,null,{"$f":"-SUM(N76)","v":0},null,{"$f":"N51","v":0}]
[null,"Überschuss nach Deckung erw.  Bedarf",{"$f":"SUM(C75,C76)","v":0},{"$f":"SUM(D75,D76)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L75,L76)","v":0}]
[null,"Verfügbare Mittel nach Deckung des erweiterten Bedarfs - Überschussaufteilung"]
[null,"Überschuss ",{"$f":"IF(C77>0,C77,\"0.00\")","v":"0.00"},null,"Überschuss nicht vollständig verteilt",null,null,null,null,null,null,null,"Überschuss nicht vollständig verteilt"]
[null,"Anteil in Prozent eingeben",{"$f":"ROUND(SUM(D80,L80),3)","v":0},{"$f":"SUM(E80:J80)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(M80:P80)","v":0}]
[null,"Anteil in Franken",{"$f":"SUM(C79*C80)","v":0},{"$f":"SUM($C$79*D80)","v":0},{"$f":"SUM($C$79*E$80)","v":0},null,{"$f":"SUM($C$79*G$80)","v":0},{"$f":"SUM($C$79*H$80)","v":0},{"$f":"SUM($C$79*I$80)","v":0},{"$f":"SUM($C$79*J$80)","v":0},null,{"$f":"SUM($C$79*L80)","v":0},{"$f":"SUM($C$79*M$80)","v":0},null,{"$f":"SUM($C$79*O$80)","v":0},{"$f":"SUM($C$79*P$80)","v":0}]
[null,"Makros"]

{"sheet":"RT","index":1,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[17,1,17,2],[17,7,17,8],[20,7,20,8],[14,7,14,8],[16,0,16,10],[14,1,14,2],[15,7,15,8],[18,1,18,2],[18,7,18,8],[0,1,0,2],[0,7,0,8],[2,1,2,2],[2,7,2,8],[4,1,4,2],[4,7,4,8],[1,0,1,10],[3,1,3,2],[3,7,3,8],[32,7,32,8],[28,1,28,2],[32,1,32,2],[31,0,31,10],[27,3,27,6],[27,1,27,2],[27,7,27,8],[30,1,30,2],[30,7,30,8],[29,1,29,2],[29,7,29,8],[28,7,28,8],[41,1,41,2],[37,7,37,8],[33,0,33,10],[41,7,41,8],[40,7,40,8],[36,1,36,2],[35,1,35,2],[34,1,34,2],[39,0,39,10],[40,1,40,2],[5,0,5,10],[9,0,9,10],[13,0,13,10],[10,7,10,8],[6,7,6,8],[6,9,6,10],[19,11,19,13],[20,3,21,4],[20,9,21,10],[23,3,23,5],[23,7,23,8],[19,0,19,10],[24,0,24,10],[26,0,26,10],[21,7,21,8],[21,1,21,2],[25,1,25,2],[25,7,25,8],[22,1,22,2],[22,7,22,8],[23,1,23,2]]}
["Person",{"$f":"IF(GR!E5<>\"\",GR!E5,\"\")","v":""},null,{"$f":"IF(GR!G5<>\"\",GR!G5,\"\")","v":""},{"$f":"IF(GR!H5<>\"\",GR!H5,\"\")","v":""},{"$f":"IF(GR!I5<>\"\",GR!I5,\"\")","v":""},{"$f":"IF(GR!J5<>\"\",GR!J5,\"\")","v":""},{"$f":"IF(GR!M5<>\"\",GR!M5,\"\")","v":""},null,{"$f":"IF(GR!O5<>\"\",GR!O5,\"\")","v":""},{"$f":"IF(GR!P5<>\"\",GR!P5,\"\")","v":""},{"$f":"\"Neuer Partner \" & IF(GR!S4=\"betreut Kinder\",\"! aktiviert !\",\"nicht aktiviert\")","v":"Neuer Partner nicht aktiviert"}]
["Theoretische Leistungsfähigkeit"]
["Einkommen",{"$f":"IF(GR!E$14<>\"\",GR!E$14,\"\")","v":0},null,null,null,null,null,{"$f":"IF(GR!M$14<>\"\",GR!M$14,\"\")","v":0}]
["Bedarf fam. Not- bzw. Kindesbedarf",{"$f":"IF(GR!E$51<>\"\",GR!E$51,\"\")","v":0},null,{"$f":"IF(GR!G$51<>\"\",GR!G$51,\"\")","v":0},{"$f":"IF(GR!H$51<>\"\",GR!H$51,\"\")","v":0},{"$f":"IF(GR!I$51<>\"\",GR!I$51,\"\")","v":0},{"$f":"IF(GR!J$51<>\"\",GR!J$51,\"\")","v":0},{"$f":"IF(GR!M$51<>\"\",GR!M$51,\"\")","v":0},null,{"$f":"IF(GR!O$51<>\"\",GR!O$51,\"\")","v":0},{"$f":"IF(GR!P$51<>\"\",GR!P$51,\"\")","v":0}]
[{"$f":"\"Theoretische Leistungsfähigkeit von \"&IF(GR!E5<>\"\",GR!E5,\"\")&\" / \"&IF(GR!M5<>\"\",GR!M5,\"\")","v":"Theoretische Leistungsfähigkeit von  / "},{"$f":"IF(AND(B$3<>\"\",B$4<>\"\"),SUM(B$3-B$4),\"\")","v":0},null,null,null,null,null,{"$f":"IF(AND(H$3<>\"\",H$4<>\"\"),SUM(H$3-H$4),\"\")","v":0}]
["Barunterhalt"]
["Mittel zur Deckung Barunterhalt (theoretisch / effektiv)",{"$f":"$B$5","v":0},{"$f":"IF(B7>0,B7,0)","v":0},null,null,null,null,{"$f":"IF($H$5>0,$H$5,0)","v":0}]
["Theoretisch geschuldeter Barunterhalt Einkommen Kinder bereits abgezogen",null,null,{"$f":"GR!G$69","v":0},{"$f":"GR!H$69","v":0},{"$f":"GR!I$69","v":0},{"$f":"GR!J$69","v":0},null,null,{"$f":"GR!O$69","v":0},{"$f":"GR!P$69","v":0}]
[{"$f":"\"Von \"&IF(GR!M5<>\"\",GR!M5,\"\")&\" geschuldeter Barunterhalt ohne Leistungsfähigkeit \"&IF(GR!E5<>\"\",GR!E5,\"\")","v":"Von  geschuldeter Barunterhalt ohne Leistungsfähigkeit "},null,null,{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,D$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(D$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,E$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(E$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,F$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(F$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,G$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(G$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},null,null,{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,J$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(J$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},{"$f":"IF(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>=0,K$8,IF(AND(SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))<0,SUM($H$5)>0),$H$5*SUM(K$8/SUM($D$8:$G$8,$J$8:$K$8)),IF(AND($H$5-SUM($D$8:$G$8,$J$8:$K$8)<=0,$H$5<=0),0,0)))","v":0},{"$f":"\"Manko Barunterhalt Fr. \"&IF(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),ROUND(SUM($D$8:$G$8,$J$8:$K$8)-SUM($D$9:$G$9,$J$9:$K$9),2))","v":"Manko Barunterhalt Fr. FALSCH"}]
["Betreuungsunterhalt"]
[{"$f":"\"Mittel von \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" / \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")&\" nach Deckung Barbedarf (theoretisch / effektiv)\"","v":"Mittel von  /  nach Deckung Barbedarf (theoretisch / effektiv)"},{"$f":"B5","v":0},{"$f":"IF(B11>0,B11,0)","v":0},null,null,null,null,{"$f":"IF(AND($H$5<>\"\",SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8))>0),SUM($H$5-SUM($D$8:$G$8,$J$8:$K$8)),0)","v":0}]
["Gem. manueller Verteilung geschuldeter Betreuungsunterhalt",null,null,{"$f":"GR!G$72","v":0},{"$f":"GR!H$72","v":0},{"$f":"GR!I$72","v":0},{"$f":"GR!J$72","v":0},null,null,{"$f":"GR!O$72","v":0},{"$f":"GR!P$72","v":0},"Manuelle Verteilung überprüfen"]
[{"$f":"\"Effektiv von \"&IF(GR!M5<>\"\",GR!M5,\"\")&\" geschuldeter Betreuungsunterhalt\"","v":"Effektiv von  geschuldeter Betreuungsunterhalt"},null,null,{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),D$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(D$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),E$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(E$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),F$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(F$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),G$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(G$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},null,null,{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),J$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(J$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},{"$f":"IF(AND($H$11>=0,$H$11>=SUM($D$12:$G$12,$J$12:$K$12)),K$12,IF(AND($H$11>0,$H$11<SUM($D$12:$G$12,$J$12:$K$12)),$H$11*SUM(K$12)/SUM($D$12:$G$12,$J$12:$K$12),IF(SUM($D$12:$G$12,$J$12:$K$12)=0,0,IF(AND($H$11<=0),0,0))))","v":0},{"$f":"\"Manko Betreuungsunterhalt Fr. \"&IF(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),ROUND(SUM($D$12:$G$12,$J$12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13),2))","v":"Manko Betreuungsunterhalt Fr. FALSCH"}]
[{"$f":"\"Deckung fam. Notbedarf \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")","v":"Deckung fam. Notbedarf "}]
[{"$f":"\"Mittel von \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" / \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")&\" nach Deckung Kinderunterhalt\"","v":"Mittel von  /  nach Deckung Kinderunterhalt"},{"$f":"SUM(B11+SUM($D$13:$G$13))","v":0},null,null,null,null,null,{"$f":"IF(AND($H$11>0,SUM(GR!$M$14>SUM(GR!M51)-SUM($D$9:$G$9,$J$9:$K$9)-SUM($D$13:$G$13,$J$13:$K$13))),SUM(GR!$M$14-SUM(GR!M51)-SUM($D$9:$G$9,$J$9:$K$9)-SUM($D$13:$G$13,$J$13:$K$13)),0)","v":0}]
[{"$f":"\"Anspruch \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" zur Deckung fam. Notbedarf (theoretisch / effektiv)\"","v":"Anspruch  zur Deckung fam. Notbedarf (theoretisch / effektiv)"},{"$f":"IF(B15<0,ABS(B15),0)","v":0},{"$f":"IF(SUM($D$12:$G$12)>SUM($D$13:$G$13),0,IF(AND(SUM($D$12:$G$12)=SUM($D$13:$G$13),$B$15>0),0,IF(AND(SUM($D$12:$G$12)=SUM($D$13:$G$13),$B$15<=0,$H$15>0,$H$15>ABS($B$15)),ABS($B$15),IF(AND(SUM($D$12:$G$12)=SUM($D$13:$G$13),$B$15<=0,$H$15<=ABS($B$15)),$H$15,0))))","v":0}]
[{"$f":"\"Korrekturrechner I (Mankoanteile \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\") [= Total Fr. \"&ROUND(SUM(D18:G18,J18:K18),2)&\" / Fr. \"&ROUND(SUM(D19:G19,J19:K19),2)&\" ]\"","v":"Korrekturrechner I (Mankoanteile ) [= Total Fr. 0 / Fr. 0 ]"}]
[{"$f":"\"Beitrag \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" zur Mankodeckung Barunterhalt Kinder\"","v":"Beitrag  zur Mankodeckung Barunterhalt Kinder"},null,null,{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((D$8-D$9),$B$15*(D$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((E$8-E$9),$B$15*(E$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((F$8-F$9),$B$15*(F$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((G$8-G$9),$B$15*(G$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0},null,null,{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((J$8-J$9),$B$15*(J$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8,$J$8:$K$8)>SUM($D$9:$G$9,$J$9:$K$9),$B$15>0),MIN((K$8-K$9),$B$15*(K$8/SUM($D$8:$G$8,$J$8:$K$8))),0)","v":0}]
[{"$f":"\"Beitrag \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" zur Mankodeckung Betreuungsunterhalt\"","v":"Beitrag  zur Mankodeckung Betreuungsunterhalt"},null,null,{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((D$12-D$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(D$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0},{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((E$12-E$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(E$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0},{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((F$12-F$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(F$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0},{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((G$12-G$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(G$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0},null,null,{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((J$12-J$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(J$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0},{"$f":"IF(AND(SUM($D$12:$G$12,$J$12:$K$12)>SUM($D$13:$G$13,$J$13:$K$13),$B$15-SUM($D$18:$G$18,$J$18:$K$18)>0),MIN((K$12-K$13),($B$15-SUM($D$15:$G$18,$J$18:$K$18))*(K$12/SUM($D$12:$G$12,$J$12:$K$12))),0)","v":0}]
["Deckung erweiterter Bedarf"]
[{"$f":"\"Mittel von \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" / \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")&\" nach Deckung fam. Notbedarf \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" und Manko Kinder (theoretisch / effektiv)\"","v":"Mittel von  /  nach Deckung fam. Notbedarf  und Manko Kinder (theoretisch / effektiv)"},{"$f":"IF(SUM(C16,B15)-(SUM(D$18:G$18,$J$18,$K$18)+SUM(D$19:G$19,$J$19:$K$19))>=0,SUM(C16,B15)-(SUM(D$18:G$18,$J$18:$K$18)+SUM(D$19:G$19,$J$19:$K$19)),SUM(C16,B15))","v":0},{"$f":"IF(B21>0,B21,0)","v":0},null,null,null,null,{"$f":"IF($H$15-$C$16>0,$H$15-$C$16,0)","v":0}]
[{"$f":"\"Erweiterter Bedarf \"&IF(GR!E5<>\"\",GR!E5,\"\")&\" / \"&IF(GR!M5<>\"\",GR!M5,\"\")","v":"Erweiterter Bedarf  / "},{"$f":"GR!F76","v":0},null,null,null,null,null,{"$f":"GR!N76","v":0}]
["Deckungsanspruch insgesamt",{"$f":"IF(AND(B22=0,H22=0),0,IF((B21+H21)*(B22/(B22+H22))>0,MIN((B21+H21)*(B22/(B22+H22)),B22),0))","v":0},null,null,null,null,null,{"$f":"IF(AND(B22=0,H22=0),0,IF((B21+H21)*(H22/(B22+H22))>0,MIN((B21+H21)*(H22/(B22+H22)),H22),0))","v":0}]
[{"$f":"\"Deckung erw. Bedarf \"&IF(GR!E5<>\"\",GR!E5,\"\")&\" durch \"&IF(GR!M5<>\"\",GR!M5,\"\")","v":"Deckung erw. Bedarf  durch "},{"$f":"IF(H21=0,0,IF(OR(B22=0,C21>B22),0,IF(H22=0,MIN(H21,B22-C21),IF(AND(H21>0,H22>0,B22-C21>0,C21/B22<H21/H22,B21+H21>=B22+H22),MIN(((C21+H21)*(B22/(B22+H22)))-C21,B23-C21,B22),IF(AND(H21>0,H22>0,B22-C21>0,C21/B22<H21/H22),MIN(B23-C21,B22),IF(AND(H21>0,H22>0,B22-C21>0,C21/B22>H21/H22),0,IF(AND(H21>0,H22>0,B22-C21>0,C21/B22=H21/H22),0,IF(AND(H21>0,H22>0,B22-C21<=0),0,0))))))))","v":0}]
[{"$f":"\"Korrekturrechner II [= Total Fr. \"&ROUND(SUM(D26:G26,J26:K26),2)&\" ]\"","v":"Korrekturrechner II [= Total Fr. 0 ]"}]
[{"$f":"\"Beitrag \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" an Kinderunterhaltsbeiträge zur verhältnismässigen Deckung erw. Bedarf \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")","v":"Beitrag  an Kinderunterhaltsbeiträge zur verhältnismässigen Deckung erw. Bedarf "},null,null,{"$f":"IF(AND($C$21=0,$H$21=0),0,IF(OR($C$21=0,$B$22=0,$H$22=0,$H$21>$H$22),0,IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22>$H$21/$H$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(D$8/SUM($D$8:$G$8)))-($H$21*(D$8/SUM($D$8:$G$8))),($H$22-$H$21)*(D$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22<$H$21/$H$22),0,IF(AND($C$21>0,$C21>=$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(D$8/SUM($D$8:$G$8)))-($H$21*(D$8/SUM($D$8:$G$8))),($H$22-$H$21)*(D$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$C21<$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(D$8/SUM($D$8:$G$8)))-($H$21*(D$8/SUM($D$8:$G$8))),($H$22-$H$21)*(D$8/SUM($D$8:$G$8))),0))))))","v":0},{"$f":"IF(AND($C$21=0,$H$21=0),0,IF(OR($C$21=0,$B$22=0,$H$22=0,$H$21>$H$22),0,IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22>$H$21/$H$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(E$8/SUM($D$8:$G$8)))-($H$21*(E$8/SUM($D$8:$G$8))),($H$22-$H$21)*(E$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22<$H$21/$H$22),0,IF(AND($C$21>0,$C21>=$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(E$8/SUM($D$8:$G$8)))-($H$21*(E$8/SUM($D$8:$G$8))),($H$22-$H$21)*(E$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$C21<$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(E$8/SUM($D$8:$G$8)))-($H$21*(E$8/SUM($D$8:$G$8))),($H$22-$H$21)*(E$8/SUM($D$8:$G$8))),0))))))","v":0},{"$f":"IF(AND($C$21=0,$H$21=0),0,IF(OR($C$21=0,$B$22=0,$H$22=0,$H$21>$H$22),0,IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22>$H$21/$H$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(F$8/SUM($D$8:$G$8)))-($H$21*(F$8/SUM($D$8:$G$8))),($H$22-$H$21)*(F$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22<$H$21/$H$22),0,IF(AND($C$21>0,$C21>=$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(F$8/SUM($D$8:$G$8)))-($H$21*(F$8/SUM($D$8:$G$8))),($H$22-$H$21)*(F$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$C21<$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(F$8/SUM($D$8:$G$8)))-($H$21*(F$8/SUM($D$8:$G$8))),($H$22-$H$21)*(F$8/SUM($D$8:$G$8))),0))))))","v":0},{"$f":"IF(AND($C$21=0,$H$21=0),0,IF(OR($C$21=0,$B$22=0,$H$22=0,$H$21>$H$22),0,IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22>$H$21/$H$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(G$8/SUM($D$8:$G$8)))-($H$21*(G$8/SUM($D$8:$G$8))),($H$22-$H$21)*(G$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$H$21>0,$B$22>$C$21,$H$22>$H$21,$C$21/$B$22<$H$21/$H$22),0,IF(AND($C$21>0,$C21>=$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(G$8/SUM($D$8:$G$8)))-($H$21*(G$8/SUM($D$8:$G$8))),($H$22-$H$21)*(G$8/SUM($D$8:$G$8))),IF(AND($C$21>0,$C21<$B$22),MIN((($C$21+$H$21)*($H$22/($B$22+$H$22))*(G$8/SUM($D$8:$G$8)))-($H$21*(G$8/SUM($D$8:$G$8))),($H$22-$H$21)*(G$8/SUM($D$8:$G$8))),0))))))","v":0}]
["Überschussaufteilung"]
[{"$f":"\"Überschuss \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" / gesamthaft verbleibender Überschuss / Überschuss \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")&\"\"","v":"Überschuss  / gesamthaft verbleibender Überschuss / Überschuss "},{"$f":"IF(AND(C21>=B22,H21>=H22),C21-B22,IF(AND(C21+H21>B22+H22,C21>B22,H21<=H22),C21-B22-SUM(D26:G26),0))","v":0},null,{"$f":"GR!C79","v":"0.00"},null,null,null,{"$f":"IF(AND(C21>=B22,H21>=H22),H21-H22,IF(AND(C21+H21>B22+H22,C21<B22,H21>H22),(C21+H21)-(B22+H22),0))","v":0}]
["Anteil am Gesamtüberschuss gem. GR Zeile 81",{"$f":"SUM(GR!E$80*GR!$C$79)","v":0},null,{"$f":"SUM(GR!G$80*GR!$C$79)","v":0},{"$f":"SUM(GR!H$80*GR!$C$79)","v":0},{"$f":"SUM(GR!I$80*GR!$C$79)","v":0},{"$f":"SUM(GR!J$80*GR!$C$79)","v":0},{"$f":"SUM(GR!M$80*GR!$C$79)","v":0},null,{"$f":"SUM(GR!O$80*GR!$C$79)","v":0},{"$f":"SUM(GR!P$80*GR!$C$79)","v":0},"Überschuss nicht vollständig verteilt"]
["Deckung je Haushalt durch Eigenmittel",{"$f":"IF(GR!C77<=0,0,IF(AND(B28>=SUM(B29:G29),SUM(B29:G29)>0),SUM(B29:G29)*(B29/(SUM(B29:G29))),IF(B28<SUM(B29:G29),B28*(B29/(SUM(B29:G29))),0)))","v":0},null,{"$f":"IF(GR!$C$77<=0,0,IF(AND($B$28>=SUM($B$29:$G$29),SUM(B$29:G$29)>0),SUM($B$29:$G$29)*(D$29/(SUM($B$29:$G$29))),IF($B$28<SUM($B$29:$G$29),$B$28*(D$29/(SUM($B$29:$G$29))),0)))","v":0},{"$f":"IF(GR!$C$77<=0,0,IF(AND($B$28>=SUM($B$29:$G$29),SUM(C$29:H$29)>0),SUM($B$29:$G$29)*(E$29/(SUM($B$29:$G$29))),IF($B$28<SUM($B$29:$G$29),$B$28*(E$29/(SUM($B$29:$G$29))),0)))","v":0},{"$f":"IF(GR!$C$77<=0,0,IF(AND($B$28>=SUM($B$29:$G$29),SUM(D$29:I$29)>0),SUM($B$29:$G$29)*(F$29/(SUM($B$29:$G$29))),IF($B$28<SUM($B$29:$G$29),$B$28*(F$29/(SUM($B$29:$G$29))),0)))","v":0},{"$f":"IF(GR!$C$77<=0,0,IF(AND($B$28>=SUM($B$29:$G$29),SUM(E$29:J$29)>0),SUM($B$29:$G$29)*(G$29/(SUM($B$29:$G$29))),IF($B$28<SUM($B$29:$G$29),$B$28*(G$29/(SUM($B$29:$G$29))),0)))","v":0},{"$f":"IF(GR!$C$77<=0,0,IF($H$28>=SUM($H$29:$K$29),$H$29,IF(AND($H$28<SUM($H$29:$K$29),SUM($H$29:$K$29)>0),$H$28*(H$29/SUM($H$29:$K$29)),0)))","v":0},null,{"$f":"IF(GR!$C$77<=0,0,IF($H$28>=SUM($H$29:$K$29),J$29,IF(AND($H$28<SUM($H$29:$K$29),SUM($H$29:$K$29)>0),$H$28*(J$29/SUM($H$29:$K$29)),0)))","v":0},{"$f":"IF(GR!$C$77<=0,0,IF($H$28>=SUM($H$29:$K$29),K$29,IF(AND($H$28<SUM($H$29:$K$29),SUM($H$29:$K$29)>0),$H$28*(K$29/SUM($H$29:$K$29)),0)))","v":0}]
["Ansprüche zur Deckung Überschussanteile",{"$f":"B29-B30","v":0},null,{"$f":"D29-D30","v":0},{"$f":"E29-E30","v":0},{"$f":"F29-F30","v":0},{"$f":"G29-G30","v":0},null,null,{"$f":"IF($H$28>=SUM($H$29:$K$29),J$30,$H$28*(J$29/SUM($H$29:$K$29)))","v":0},{"$f":"IF($H$28>=SUM($H$29:$K$29),K$30,$H$28*(K$29/SUM($H$29:$K$29)))","v":0}]
[{"$f":"\"Korrekturrechner III [= Total Fr. \"&ROUND(SUM(D33:G33,J33:K33),2)&\" ]\"","v":"Korrekturrechner III [= Total Fr. 0 ]"}]
[{"$f":"\"Beitrag \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" zur Deckung der Überschussanteile H, J und K\"","v":"Beitrag  zur Deckung der Überschussanteile H, J und K"},null,null,{"$f":"IF($H$28>=SUM($H$29:$K$29),0,IF($H$28<SUM($H$29:$K$29),(SUM($H$29:$K$29)-$H$28)*(D$8/SUM($D$8:$G$8))))","v":0},{"$f":"IF($H$28>=SUM($H$29:$K$29),0,IF($H$28<SUM($H$29:$K$29),(SUM($H$29:$K$29)-$H$28)*(E$8/SUM($D$8:$G$8))))","v":0},{"$f":"IF($H$28>=SUM($H$29:$K$29),0,IF($H$28<SUM($H$29:$K$29),(SUM($H$29:$K$29)-$H$28)*(F$8/SUM($D$8:$G$8))))","v":0},{"$f":"IF($H$28>=SUM($H$29:$K$29),0,IF($H$28<SUM($H$29:$K$29),(SUM($H$29:$K$29)-$H$28)*(G$8/SUM($D$8:$G$8))))","v":0}]
["Manko / Korrekturrechner"]
["Theoretische Unterhaltsansprüche",{"$f":"SUM(B$16,B$22,$B$31)","v":0},null,{"$f":"SUM(D$8,D$12,D$31)","v":0},{"$f":"SUM(E$8,E$12,E$31)","v":0},{"$f":"SUM(F$8,F$12,F$31)","v":0},{"$f":"SUM(G$8,G$12,G$31)","v":0},null,null,{"$f":"SUM(J$8,J$12,J$31)","v":0},{"$f":"SUM(K$8,K$12,K$31)","v":0}]
[{"$f":"\"Effektive Unterhaltsbeiträge von \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")","v":"Effektive Unterhaltsbeiträge von "},{"$f":"SUM($C$16,B24,B$29-B$30)","v":0},null,{"$f":"SUM(SUM(D$9,D$13,D$29-D$30)-D$26-D$33)","v":0},{"$f":"SUM(SUM(E$9,E$13,E$29-E$30)-E$26-E$33)","v":0},{"$f":"SUM(SUM(F$9,F$13,F$29-F$30)-F$26-F$33)","v":0},{"$f":"SUM(SUM(G$9,G$13,G$29-G$30)-G$26-G$33)","v":0},null,null,{"$f":"SUM(J$9,J$13,J$29-J$30)","v":0},{"$f":"SUM(K$9,K$13,K$29-K$30)","v":0}]
[{"$f":"\"Anteil Unterhaltsbeiträge von \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")","v":"Anteil Unterhaltsbeiträge von "},{"$f":"B23-B24","v":0},null,{"$f":"SUM(D$18,D$19,D$26,D$33)","v":0},{"$f":"SUM(E$18,E$19,E$26,E$33)","v":0},{"$f":"SUM(F$18,F$19,F$26,F$33)","v":0},{"$f":"SUM(G$18,G$19,G$26,G$33)","v":0},null,null,{"$f":"SUM(J$18,J$19)","v":0},{"$f":"SUM(K$18,K$19)","v":0}]
["Manko pro Person",{"$f":"IF(SUM(($B$36-$B$37)-SUM(($B$35-$B$37)-$B$22))>=0,0,SUM(($B$36-$B$37)-SUM(($B$35-$B$37)-$B$22)))","v":0},{"$f":"B$36+B$37-B$35","v":0},{"$f":"D$36+D$37-D$35","v":0},{"$f":"E$36+E$37-E$35","v":0},{"$f":"F$36+F$37-F$35","v":0},{"$f":"G$36+G$37-G$35","v":0},null,null,{"$f":"J$36+J$37-J$35","v":0},{"$f":"K$36+K$37-K$35","v":0}]
[{"$f":"\"Effektives Manko \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" abzüglich Manko Betreuungsunterhalt Kinder\"","v":"Effektives Manko  abzüglich Manko Betreuungsunterhalt Kinder"},{"$f":"IF(B$38>=0,0,IF(AND(B$38<0,SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)>0),ROUND(MIN(B$38+(SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)),0),1),IF(AND(B$38<=0,SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)=0),B$38,0)))","v":0},{"$f":"IF(C$38>=0,0,IF(AND(C$38<0,SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)>0),ROUND(MIN(C$38+(SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)),0),1),IF(AND(C$38<=0,SUM($D$12:$G$12,$J12:$K$12)-SUM($D$13:$G$13,$J$13:$K$13)=0),C$38,0)))","v":0}]
[{"$f":"\"Von \"&IF(GR!$M$5<>\"\",GR!$M$5,\"\")&\" zu leistende Unterhaltsbeiträge\"","v":"Von  zu leistende Unterhaltsbeiträge"}]
["Zuzusprechender Unterhalt pro Kopf",{"$f":"ROUND(B$36,1)","v":0},null,{"$f":"ROUND(D$36,1)","v":0},{"$f":"ROUND(E$36,1)","v":0},{"$f":"ROUND(F$36,1)","v":0},{"$f":"ROUND(G$36,1)","v":0},null,null,{"$f":"ROUND(J$36,1)","v":0},{"$f":"ROUND(K$36,1)","v":0}]
["Zuzusprechender Unterhalt pro Haushalt",{"$f":"SUM(B41:G41)","v":0},null,null,null,null,null,{"$f":"J41+K41","v":0},{"$f":"I38","v":0}]

{"sheet":"StR","index":2,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,3,2,4],[1,1,1,2],[1,3,1,4],[6,1,6,2],[6,3,6,4],[3,1,3,2],[5,1,5,2],[3,3,3,4],[5,3,5,4],[4,1,4,2],[4,3,4,4],[2,1,2,2],[14,0,14,4],[7,0,7,4],[29,0,29,4],[36,1,36,2],[36,3,36,4],[32,1,32,2],[32,3,32,4],[35,1,35,2],[35,3,35,4],[33,1,33,2],[33,3,33,4],[21,1,21,2],[10,3,10,4],[34,1,34,2],[34,3,34,4]]}
["Grunddaten"]
[null,"Haushalt mit finanziell weniger leistungsfähigem Elternteil",null,"Anderer Elternteil"]
["Name",{"$f":"IF(GR!E5<>\"\",GR!E5,\"\")","v":""},null,{"$f":"IF(GR!M5<>\"\",GR!M5,\"\")","v":""}]
["Steuerjahr leer lassen",2011,null,2010]
["Steuertarif leer lassen","Verh. und Einelterntarif",null,"Grundtarif"]
["Konfession leer lassen","evangelisch",null,"christ-katholisch"]
["Wohnort leer lassen","Aesch",null,"Aeugst am Albis"]
["Einkommensberechnung"]
["Position","Staats- und Gemeindesteuer","direkte Bundessteuer","Staats- und Gemeindesteuer","direkte Bundessteuer"]
["Erwerbs-, Renten und Vermögensertrag",{"$f":"SUM(SUM(GR!E14,SUM(GR!G13:J13))*12)","v":0},{"$f":"SUM(SUM(GR!E14,SUM(GR!G13:J13))*12)","v":0},{"$f":"SUM(SUM(GR!M14,SUM(GR!O13:P13))*12)","v":0},{"$f":"SUM(SUM(GR!M14,SUM(GR!O13:P13))*12)","v":0}]
["Unterhaltsbeiträge",{"$f":"RT!$B$42*12","v":0},{"$f":"RT!$B$42*12","v":0}]
["Netto-Eigenmietwert optional"]
["Weitere Position optional"]
["Total der Einkünfte",{"$f":"SUM(B10:B13)","v":0},{"$f":"SUM(C10:C13)","v":0},{"$f":"SUM(D10:D13)","v":0},{"$f":"SUM(E10:E13)","v":0}]
["Abzüge"]
["Berufsauslagen"]
["a) Mobilitätskosten nicht gesperrt",{"$f":"SUM(GR!$E$30*12)","v":0},{"$f":"SUM(GR!$E$30*12)","v":0},{"$f":"SUM(GR!$M$30*12)","v":0},{"$f":"SUM(GR!$M$30*12)","v":0}]
["b) Verpflegung nicht gesperrt",{"$f":"IF(SUM(GR!$E$31*12)>3200,3200,SUM(GR!$E$31*12))","v":0},{"$f":"IF(SUM(GR!$E$31*12)>3200,3200,SUM(GR!$E$31*12))","v":0},{"$f":"IF(SUM(GR!$M$31*12)>3200,3200,SUM(GR!$M$31*12))","v":0},{"$f":"IF(SUM(GR!$M$31*12)>3200,3200,SUM(GR!$M$31*12))","v":0}]
["c) Weitere Berufskosten",{"$f":"IF(GR!$E$14*12*0.03>4000,4000,IF(AND(GR!$E$14*12*0.03<4000,GR!$E$14*12*0.03>2000),GR!$E$14*12*0.03,IF(AND(GR!$E$14*12*0.03<2000,GR!$E$14*12>0),2000,IF(GR!$E$14*12=0,0))))","v":0},{"$f":"IF(GR!$E$14*12*0.03>4000,4000,IF(AND(GR!$E$14*12*0.03<4000,GR!$E$14*12*0.03>2000),GR!$E$14*12*0.03,IF(AND(GR!$E$14*12*0.03<2000,GR!$E$14*12>0),2000,IF(GR!$E$14*12=0,0))))","v":0},{"$f":"IF(GR!$M$14*12*0.03>4000,4000,IF(AND(GR!$M$14*12*0.03<4000,GR!$M$14*12*0.03>2000),GR!$M$14*12*0.03,IF(AND(GR!$M$14*12*0.03<2000,GR!$M$14*12>0),2000,IF(GR!$M$14*12=0,0))))","v":0},{"$f":"IF(GR!$M$14*12*0.03>4000,4000,IF(AND(GR!$M$14*12*0.03<4000,GR!$M$14*12*0.03>2000),GR!$M$14*12*0.03,IF(AND(GR!$M$14*12*0.03<2000,GR!$M$14*12>0),2000,IF(GR!$M$14*12=0,0))))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M19<>\"\",M19,\"\")","v":""}]
["Weiterbildungskosten Eingabe optional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M20<>\"\",M20,\"\")","v":""}]
["Schuldzinsen Eingabe optional"]
["Unterhaltsbeiträge",null,null,{"$f":"RT!B42*12","v":0},{"$f":"RT!$B$42*12","v":0}]
["Aufwendungen für Säule 3a Eingabe optional"]
["Versicherungsprämien (Erwachsene) nicht gesperrt",{"$f":"IF(SUM(GR!$E$20:$E$22)*12>2600,2600,SUM(GR!$E$20:$E$22)*12)","v":0},{"$f":"IF(SUM(GR!$E$20:$E$22)*12>2600,2600,SUM(GR!$E$20:$E$22)*12)","v":0},{"$f":"IF(SUM(GR!$M$20:$M$22)*12>2600,2600,SUM(GR!$M$20:$M$22)*12)","v":0},{"$f":"IF(SUM(GR!$M$20:$M$22)*12>2600,2600,SUM(GR!$M$20:$M$22)*12)","v":0}]
["Versicherungsprämien (Kinder)",{"$f":"IF(SUM(GR!$G$25:'GR'!$J$26)*12>COUNTA(GR!$G$5:$J$5)*1300,COUNTA(GR!$G$5:$J$5)*1300,SUM(GR!$G$25,GR!$J$26)*12)","v":0},{"$f":"IF(SUM(GR!$G$25:'GR'!$J$26)*12>COUNTA(GR!$G$5:$J$5)*1300,COUNTA(GR!$G$5:$J$5)*1300,SUM(GR!$G$25,GR!$J$26)*12)","v":0},{"$f":"IF(SUM(GR!$O$25:'GR'!$P$26)*12>COUNTA(GR!$O$5:$P$5)*1300,COUNTA(GR!$O$5:$P$5)*1300,SUM(GR!$O$25,GR!$P$26)*12)","v":0},{"$f":"IF(SUM(GR!$O$25:'GR'!$P$26)*12>COUNTA(GR!$O$5:$P$5)*1300,COUNTA(GR!$O$5:$P$5)*1300,SUM(GR!$O$25,GR!$P$26)*12)","v":0}]
["Kosten Fremdbetreuung",{"$f":"IF(SUM(GR!$G$28:$J$28)*12>COUNTA(GR!$G$5:$J$5)*10100,COUNTA(GR!$G$5:$J$5)*10100,SUM(GR!$G$28:$J$28)*12)","v":0},{"$f":"IF(SUM(GR!$G$28:$J$28)*12>COUNTA(GR!$G$5:$J$5)*10100,COUNTA(GR!$G$5:$J$5)*10100,SUM(GR!$G$28:$J$28)*12)","v":0},{"$f":"IF(SUM(GR!$O$28:$P$28)*12>COUNTA(GR!$O$5:$P$5)*10100,COUNTA(GR!$O$5:$P$5)*10100,SUM(GR!$O$28:$P$28)*12)","v":0},{"$f":"IF(SUM(GR!$O$28:$P$28)*12>COUNTA(GR!$O$5:$P$5)*10100,COUNTA(GR!$O$5:$P$5)*10100,SUM(GR!$O$28:$P$28)*12)","v":0}]
["Kinderabzüge nicht gesperrt",{"$f":"COUNTA(GR!$G$5:$J$5)*9000","v":0},{"$f":"COUNTA(GR!$G$5:$J$5)*6500","v":0},{"$f":"COUNTA(GR!$O$5:$P$5)*9000","v":0},{"$f":"COUNTA(GR!$O$5:$P$5)*6500","v":0}]
["Weitere Position Eingabe optional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M28<>\"\",M28,\"\")","v":""}]
["Total der Abzüge",{"$f":"SUM(B17:B28)","v":0},{"$f":"SUM(C17:C28)","v":0},{"$f":"SUM(D17:D28)","v":0},{"$f":"SUM(E17:E28)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29<>\"\",M29,\"\")","v":""}]
["Steuerberechnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M30<>\"\",M30,\"\")","v":""}]
["Steuerbares Einkommen",{"$f":"IF(B14-B29<0,0,B14-B29)","v":0},{"$f":"IF(C14-C29<0,0,C14-C29)","v":0},{"$f":"IF(D14-D29<0,0,D14-D29)","v":0},{"$f":"IF(E14-E29<0,0,E14-E29)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M31<>\"\",M31,\"\")","v":""}]
["Steuerbares Vermögen eingeben",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M32<>\"\",M32,\"\")","v":""}]
["Total Staats- und Gemeindesteuer leer lassen",3150.45,null,3251.05]
["Total Direkte Bundessteuer leer lassen",327,null,229.4]
["Abzüglich Verrechnungssteuerguthaben optional"]
["Gesamter jährlicher Steuerbetrag ",{"$f":"SUM(B33:B34)-B35","v":3477.45},null,{"$f":"SUM(D33:D34)-D35","v":3480.4500000000003}]
["Monatlicher Steuerbetrag",{"$f":"ROUND(B36/12,1)","v":289.8},null,{"$f":"ROUND(D36/12,1)","v":290}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H45<>\"\",H45,\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M48<>\"\",M48,\"\")","v":""}]
[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,{"$f":"IF(E47<>\"\",E47,\"\")","v":""},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,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,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,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,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,"",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,null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,""]

{"sheet":"Änderungsprotokoll (Updates)","index":3,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":true,"merged":[[15,7,17,7],[35,3,37,3],[3,5,5,5],[15,3,17,3],[15,1,17,1],[11,1,13,1],[11,3,13,3],[7,1,9,1],[7,3,9,3],[7,5,9,5],[27,3,29,3],[23,3,25,3],[19,3,21,3],[0,0,0,4],[3,3,5,3],[3,1,5,1],[19,1,21,1],[31,3,33,3],[0,6,0,10],[3,7,5,7],[3,9,5,9],[3,11,5,11],[7,7,9,7],[7,9,9,9],[7,11,9,11]]}
["Update 1 (9. Februar 2017)",null,null,null,null,null,"Update 2 (Mai 2017)"]
["GR","Art","RT","Art","StR","Art","GR","Art","RT","Art","StR","Art"]
["Problematik","technisch","Problematik","optisch","Problematik","optisch","Problematik","technisch","Problematik","optisch","Problematik","technisch"]
["Die Spalten C und S waren für die ausführliche Texteingabe zu klein und z.T. fand kein Zeilenumbruch statt.",null,"In den alten Zeilen 18 und 25 stimmte die bedingte Formatierung bei Werten = 0 nicht immer.",null,"C32 und E32 überflüssig, weil bei der direkten Bundessteuer gar keine Vermögenssteuer anfällt.",null,"Die Problematik betr. Spalten C und S besteht z.T. nach wie vor.",null,"Anhand der Rückmeldungen wurde ersichtlich, dass die Berechnungen des RT nicht immer nachvollzogen werden können.",null,"Tabelle wirkt zu überladen"]
["Lösung",null,"Lösung",null,"Lösung",null,"Lösung",null,"Lösung",null,"Lösung"]
["Spalten C und S wurden vergrössert und alle Kommentarzellen nehmen nun einen Zeilenumbruch vor.",null,"Die bedingte Formatierung in den alten Zeilen 18 und 25 wurde angepasst.",null,"C32 und E32 gelöscht und nun leer und gesperrt.",null,"Mehr Text verzerrt die Tabelle unschön.Texteingabe jetzt auf zwei Zeilen beschränkt, was für Texteingabe genügen sollte. Falls dies nicht genügt, kann in der unteren Zelle weitergeschrieben werden.",null,"Das Manuel wurde in dieser Hinsicht umfassend angepasst und die Berechnungsweise wird nun auch anhand von Beispielen erläutert.",null,"Gliederung der Zeilen eingeführt. Nicht benötigte Zeilen können ausgeblendet werden."]
["Problematik","technisch","Problematik","optisch","Problematik","technisch","Problematik","optisch","Problematik","technisch"]
["In Zeile 59 und bei der Berechnung des Barbedarfs (Zeilen 66 ff.) wurde der Fall nicht berücksichtigt, wenn das Kindereinkommen dessen Barbedarf übersteigt (= Zeile 14  grösser als Zeile 51).",null,"Die Zeilenbreite in Zeile 1 und in Spalte A war verzerrt worden, wenn längere Namen eingetragen wurden.",null,"Die Zellen A17 und A27 (z.B. bei geteilter Obhut) erforderten unter Umständen manuelle Eingaben, die Zellen waren jedoch gesperrt.",null,"Kleine optische Unschönheiten, zudem erweckt das Drucksymbol fälschlicherweise den Eindruck, dass mit dessen Betätigung ein Ausdruck stattfindet.",null,"Tabelle wirkt zu überladen"]
["Lösung",null,"Lösung",null,"Lösung",null,"Lösung",null,"Lösung"]
["Formeln und anrechenbares Einkommen der Kinder in Zeilen 59 und beim Barbedarf  (Zeilen 66 ff.) entsprechend angepasst; zudem weisen in den erwähnten Zeilen Reitereinträge auf diese Konstellation hin.",null,"Zellformatierung entsprechend angepasst.",null,"Die Zellen sind nun entsperrt und für die manuelle Eingabe freigegeben; Steuerelemente mit hinterlegten Makros eingefügt, um die Formeln wiederherzustellen.",null,"Entsprechende Anpassungen, Drucksymbol gelöscht. Stattdessen besteht nun die Möglichkeit, bei  abgestufter Unterhaltsberechnung die Berechnungsphase zu bezeichnen.",null,"Gliederung der Zeilen eingeführt. Nicht benötigte Zeilen können ausgeblendet werden."]
["Problematik","optisch","Problematik","technisch",null,null,"Problematik"]
["Nutzer vergessen, den Überschuss zu verteilen.",null,"Die Verteilung der Unterhaltsbeiträge war nicht stimmig, wenn nach Deckung der Kinderunterhaltsbeiträge der unterhaltsberechtigte Elternteil leistungsfähiger als der unterhaltsverpflichtete ist; der Rechner führte bisher keine Berechnungen von links nach rechts aus.",null,null,null,"Bei wenigen Beispielen waren die Zahlen nicht stimmig."]
["Lösung",null,"Lösung",null,null,null,"Lösung"]
["In Zeile 79 blinkt nun eine Warnanzeige auf, wenn der Überschuss nicht verteilt wurde (analog der Warnanzeige in Zeile 71).\n\nEbenso wurden nun in Zeile 79 Reitereinträge angebracht.",null,"Umfangreiche Anpassung der Formeln; Korrekturrechnungen I bis III eingeführt; es findet auch eine Rechnung von links nach rechts statt.",null,null,null,"Entsprechende Korrektur, zudem wurde ein neues Makro-Beispiel eingefügt."]
["Problematik","technisch","Problematik","technisch",null,null,"Problematik","technisch"]
["Makros werden (zu) sorglos aktiviert und der Nutzer ärgerte sich anschliessend über den Verlust seiner bisher getätigten Eingaben.",null,"In ganz spezifischen Fallkonstellationen wurden die ausgegebenen Unterhaltsbeiträge auf schwarz gestellt, weil der Rechner diese Situationen nicht berechnen konnte und die ausgegebenen Beträge irreführend gewesen wären.",null,null,null,"Tabelle wirkt zu überladen"]
["Lösung",null,"Lösung",null,null,null,"Lösung"]
["MsgBox mit Warnmeldung, dass bei Ausführung des Makros alle Daten in sämtlichen Tabellenblättern unwiderruflich gelöscht werden; die Anwender müssen die Durchführung des Makros bestätigen.",null,"Umfangreiche Anpassung der Formeln; Korrekturrechnungen I bis III eingeführt; es findet auch eine Rechnung von links nach rechts statt.",null,null,null,"Gliederung der Zeilen eingeführt. Nicht benötigte Zeilen können ausgeblendet werden."]
["Problematik","Text","Problematik","Text"]
["Es wurde gewünscht, dass Zelle B2 beschriftet werden kann (z.B. Bezeichnung der Berechnungsphase etc.).",null,"Wurde das Beispiel 2 eingespeist, stimmte die Verteilung des fam. Notbedarfes in der alten Zelle H22 nicht."]
["Lösung",null,"Lösung"]
["Zelle B2 entsperrt und es ist nun eine freie Texteingabe möglich.",null,"Formel angepasst."]
[null,null,"Problematik","technisch"]
[null,null,"Diverse Titel (inbes. betr. Barunterhalt) waren in ihrem Wortlaut nicht mehr stimmig zur neuen Programmierung."]
[null,null,"Lösung"]
[null,null,"Terminologische Anpassungen (z.B. Spalte A)."]
[null,null,"Problematik","technisch"]
[null,null,"Die alte Formel in alt H22 zeigte in gewissen Fällen den Anteil, welcher der Ehegatte an seinen erw. Bedarf leisten kann, nicht an, sondern wies 0 aus."]
[null,null,"Lösung"]
[null,null,"Formel angepasst."]
[null,null,"Problematik","technisch"]
[null,null,"Formeltechnische Bezugsproblematik wenn die erw. Bedarfe bei fehlenden finanziellen Mitteln auf \"0\" gesetzt wurden."]
[null,null,"Lösung"]
[null,null,"Die erw. Bedarfe erscheinen nun immer in der im GR eingetragenen Höhe, unabhängigig davon, ob finanzielle Mittel zur Deckung vorhanden sind oder nicht."]
[null,null,"Problematik","optisch"]
[null,null,"Die Kaskade betr. Deckung des erw. Bedarfes war inkohärent."]
[null,null,"Lösung"]
[null,null,"Formeln in den alten Zeilen 19 ff. angepasst."]
[null,null,"Problematik"]
[null,null,"Nutzer vergessen, den Überschuss zu verteilen."]
[null,null,"Lösung"]
[null,null,"In Zelle L29 erscheint nun eine Warnanzeige, wenn der Überschuss nicht verteilt wurde."]

{"sheet":"Stammdaten","index":4,"n_rows":168,"n_cols":12,"rows_kept":168,"cut":false,"hidden":true,"merged":[]}
[2010,2010,"ledig","single","Grundtarif","BASIC","andere","OTHERS","Adlikon","21","Verh. und Einelterntarif","MARRIED_OR_SINGLE_PARENT"]
[2011,2011,"verheiratet","married","Verh. und Einelterntarif","MARRIED_OR_SINGLE_PARENT","evangelisch","REFORMED","Adliswil","131","Alleinstehende","SINGLE"]
[2012,2012,"verwitwet","widowed",null,null,"christ-katholisch","OLD_CATHOLIC","Aesch","241"]
[2013,2013,"geschieden","divorced",null,null,"römisch-katholisch","ROMAN_CATHOLIC","Aeugst am Albis","1"]
[2014,2014,"getrennt","separated",null,null,null,null,"Affoltern am Albis","2"]
[2015,2015,"eingetragene Partnerschaft","partnered",null,null,null,null,"Altikon","211"]
[2016,2016,"aufgelöste Partnerschaft","unpartnered",null,null,null,null,"Andelfingen","30"]
[null,null,null,null,null,null,null,null,"Bachenbülach","51"]
[null,null,null,null,null,null,null,null,"Bachs","81"]
[null,null,null,null,null,null,null,null,"Bassersdorf","52"]
[null,null,null,null,null,null,null,null,"Bauma","297"]
[null,null,null,null,null,null,null,null,"Benken","22"]
[null,null,null,null,null,null,null,null,"Berg am Irchel","23"]
[null,null,null,null,null,null,null,null,"Birmensdorf","242"]
[null,null,null,null,null,null,null,null,"Bonstetten","3"]
[null,null,null,null,null,null,null,null,"Boppelsen","82"]
[null,null,null,null,null,null,null,null,"Brütten","213"]
[null,null,null,null,null,null,null,null,"Bubikon","112"]
[null,null,null,null,null,null,null,null,"Buch am Irchel","24"]
[null,null,null,null,null,null,null,null,"Buchs","83"]
[null,null,null,null,null,null,null,null,"Bäretswil","111"]
[null,null,null,null,null,null,null,null,"Bülach","53"]
[null,null,null,null,null,null,null,null,"Dachsen","25"]
[null,null,null,null,null,null,null,null,"Dielsdorf","86"]
[null,null,null,null,null,null,null,null,"Dietikon","243"]
[null,null,null,null,null,null,null,null,"Dietlikon","54"]
[null,null,null,null,null,null,null,null,"Dinhard","216"]
[null,null,null,null,null,null,null,null,"Dorf","26"]
[null,null,null,null,null,null,null,null,"Dägerlen","214"]
[null,null,null,null,null,null,null,null,"Dällikon","84"]
[null,null,null,null,null,null,null,null,"Dänikon","85"]
[null,null,null,null,null,null,null,null,"Dättlikon","215"]
[null,null,null,null,null,null,null,null,"Dübendorf","191"]
[null,null,null,null,null,null,null,null,"Dürnten","113"]
[null,null,null,null,null,null,null,null,"Egg","192"]
[null,null,null,null,null,null,null,null,"Eglisau","55"]
[null,null,null,null,null,null,null,null,"Elgg","217"]
[null,null,null,null,null,null,null,null,"Ellikon an der Thur","218"]
[null,null,null,null,null,null,null,null,"Elsau","219"]
[null,null,null,null,null,null,null,null,"Embrach","56"]
[null,null,null,null,null,null,null,null,"Erlenbach","151"]
[null,null,null,null,null,null,null,null,"Fehraltorf","172"]
[null,null,null,null,null,null,null,null,"Feuerthalen","27"]
[null,null,null,null,null,null,null,null,"Fischenthal","114"]
[null,null,null,null,null,null,null,null,"Flaach","28"]
[null,null,null,null,null,null,null,null,"Flurlingen","29"]
[null,null,null,null,null,null,null,null,"Freienstein-Teufen","57"]
[null,null,null,null,null,null,null,null,"Fällanden","193"]
[null,null,null,null,null,null,null,null,"Geroldswil","244"]
[null,null,null,null,null,null,null,null,"Glattfelden","58"]
[null,null,null,null,null,null,null,null,"Gossau","115"]
[null,null,null,null,null,null,null,null,"Greifensee","194"]
[null,null,null,null,null,null,null,null,"Grüningen","116"]
[null,null,null,null,null,null,null,null,"Hagenbuch","220"]
[null,null,null,null,null,null,null,null,"Hausen am Albis","4"]
[null,null,null,null,null,null,null,null,"Hedingen","5"]
[null,null,null,null,null,null,null,null,"Henggart","31"]
[null,null,null,null,null,null,null,null,"Herrliberg","152"]
[null,null,null,null,null,null,null,null,"Hettlingen","221"]
[null,null,null,null,null,null,null,null,"Hinwil","117"]
[null,null,null,null,null,null,null,null,"Hirzel","132"]
[null,null,null,null,null,null,null,null,"Hittnau","173"]
[null,null,null,null,null,null,null,null,"Hochfelden","59"]
[null,null,null,null,null,null,null,null,"Hofstetten","222"]
[null,null,null,null,null,null,null,null,"Hombrechtikon","153"]
[null,null,null,null,null,null,null,null,"Horgen","133"]
[null,null,null,null,null,null,null,null,"Humlikon","32"]
[null,null,null,null,null,null,null,null,"Höri","60"]
[null,null,null,null,null,null,null,null,"Hüntwangen","61"]
[null,null,null,null,null,null,null,null,"Hütten","134"]
[null,null,null,null,null,null,null,null,"Hüttikon","87"]
[null,null,null,null,null,null,null,null,"Illnau-Effretikon","296"]
[null,null,null,null,null,null,null,null,"Kappel am Albis","6"]
[null,null,null,null,null,null,null,null,"Kilchberg","135"]
[null,null,null,null,null,null,null,null,"Kleinandelfingen","33"]
[null,null,null,null,null,null,null,null,"Kloten","62"]
[null,null,null,null,null,null,null,null,"Knonau","7"]
[null,null,null,null,null,null,null,null,"Küsnacht","154"]
[null,null,null,null,null,null,null,null,"Langnau am Albis","136"]
[null,null,null,null,null,null,null,null,"Laufen-Uhwiesen","34"]
[null,null,null,null,null,null,null,null,"Lindau","176"]
[null,null,null,null,null,null,null,null,"Lufingen","63"]
[null,null,null,null,null,null,null,null,"Marthalen","35"]
[null,null,null,null,null,null,null,null,"Maschwanden","8"]
[null,null,null,null,null,null,null,null,"Maur","195"]
[null,null,null,null,null,null,null,null,"Meilen","156"]
[null,null,null,null,null,null,null,null,"Mettmenstetten","9"]
[null,null,null,null,null,null,null,null,"Männedorf","155"]
[null,null,null,null,null,null,null,null,"Mönchaltorf","196"]
[null,null,null,null,null,null,null,null,"Neerach","88"]
[null,null,null,null,null,null,null,null,"Neftenbach","223"]
[null,null,null,null,null,null,null,null,"Niederglatt","89"]
[null,null,null,null,null,null,null,null,"Niederhasli","90"]
[null,null,null,null,null,null,null,null,"Niederweningen","91"]
[null,null,null,null,null,null,null,null,"Nürensdorf","64"]
[null,null,null,null,null,null,null,null,"Oberembrach","65"]
[null,null,null,null,null,null,null,null,"Oberengstringen","245"]
[null,null,null,null,null,null,null,null,"Oberglatt","92"]
[null,null,null,null,null,null,null,null,"Oberrieden","137"]
[null,null,null,null,null,null,null,null,"Oberstammheim","36"]
[null,null,null,null,null,null,null,null,"Oberweningen","93"]
[null,null,null,null,null,null,null,null,"Obfelden","10"]
[null,null,null,null,null,null,null,null,"Oetwil am See","157"]
[null,null,null,null,null,null,null,null,"Oetwil an der Limmat","246"]
[null,null,null,null,null,null,null,null,"Opfikon","66"]
[null,null,null,null,null,null,null,null,"Ossingen","37"]
[null,null,null,null,null,null,null,null,"Otelfingen","94"]
[null,null,null,null,null,null,null,null,"Ottenbach","11"]
[null,null,null,null,null,null,null,null,"Pfungen","224"]
[null,null,null,null,null,null,null,null,"Pfäffikon","177"]
[null,null,null,null,null,null,null,null,"Rafz","67"]
[null,null,null,null,null,null,null,null,"Regensberg","95"]
[null,null,null,null,null,null,null,null,"Regensdorf","96"]
[null,null,null,null,null,null,null,null,"Rheinau","38"]
[null,null,null,null,null,null,null,null,"Richterswil","138"]
[null,null,null,null,null,null,null,null,"Rickenbach","225"]
[null,null,null,null,null,null,null,null,"Rifferswil","12"]
[null,null,null,null,null,null,null,null,"Rorbas","68"]
[null,null,null,null,null,null,null,null,"Russikon","178"]
[null,null,null,null,null,null,null,null,"Rümlang","97"]
[null,null,null,null,null,null,null,null,"Rüschlikon","139"]
[null,null,null,null,null,null,null,null,"Rüti","118"]
[null,null,null,null,null,null,null,null,"Schlatt","226"]
[null,null,null,null,null,null,null,null,"Schleinikon","98"]
[null,null,null,null,null,null,null,null,"Schlieren","247"]
[null,null,null,null,null,null,null,null,"Schwerzenbach","197"]
[null,null,null,null,null,null,null,null,"Schöfflisdorf","99"]
[null,null,null,null,null,null,null,null,"Schönenberg","140"]
[null,null,null,null,null,null,null,null,"Seegräben","119"]
[null,null,null,null,null,null,null,null,"Seuzach","227"]
[null,null,null,null,null,null,null,null,"Stadel","100"]
[null,null,null,null,null,null,null,null,"Stallikon","13"]
[null,null,null,null,null,null,null,null,"Steinmaur","101"]
[null,null,null,null,null,null,null,null,"Stäfa","158"]
[null,null,null,null,null,null,null,null,"Thalheim an der Thur","39"]
[null,null,null,null,null,null,null,null,"Thalwil","141"]
[null,null,null,null,null,null,null,null,"Truttikon","41"]
[null,null,null,null,null,null,null,null,"Trüllikon","40"]
[null,null,null,null,null,null,null,null,"Turbenthal","228"]
[null,null,null,null,null,null,null,null,"Uetikon am See","159"]
[null,null,null,null,null,null,null,null,"Uitikon","248"]
[null,null,null,null,null,null,null,null,"Unterengstringen","249"]
[null,null,null,null,null,null,null,null,"Unterstammheim","42"]
[null,null,null,null,null,null,null,null,"Urdorf","250"]
[null,null,null,null,null,null,null,null,"Uster","198"]
[null,null,null,null,null,null,null,null,"Volken","43"]
[null,null,null,null,null,null,null,null,"Volketswil","199"]
[null,null,null,null,null,null,null,null,"Wald","120"]
[null,null,null,null,null,null,null,null,"Wallisellen","69"]
[null,null,null,null,null,null,null,null,"Waltalingen","44"]
[null,null,null,null,null,null,null,null,"Wangen-Brüttisellen","200"]
[null,null,null,null,null,null,null,null,"Wasterkingen","70"]
[null,null,null,null,null,null,null,null,"Weiach","102"]
[null,null,null,null,null,null,null,null,"Weiningen","251"]
[null,null,null,null,null,null,null,null,"Weisslingen","180"]
[null,null,null,null,null,null,null,null,"Wettswil am Albis","14"]
[null,null,null,null,null,null,null,null,"Wetzikon","121"]
[null,null,null,null,null,null,null,null,"Wiesendangen","298"]
[null,null,null,null,null,null,null,null,"Wil","71"]
[null,null,null,null,null,null,null,null,"Wila","181"]
[null,null,null,null,null,null,null,null,"Wildberg","182"]
[null,null,null,null,null,null,null,null,"Winkel","72"]
[null,null,null,null,null,null,null,null,"Winterthur","230"]
[null,null,null,null,null,null,null,null,"Wädenswil","142"]
[null,null,null,null,null,null,null,null,"Zell","231"]
[null,null,null,null,null,null,null,null,"Zollikon","161"]
[null,null,null,null,null,null,null,null,"Zumikon","160"]
[null,null,null,null,null,null,null,null,"Zürich","261"]