{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["GR","RT","StR","Stammdaten"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":14,"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":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[[38,4,38,5],[38,12,38,13],[40,1,40,16],[36,1,36,16],[39,17,39,18],[39,1,39,2],[15,3,16,3],[15,14,15,15],[15,11,16,11],[3,12,3,13],[4,12,4,13],[15,12,15,13],[11,4,11,5],[14,1,14,16],[13,1,13,2],[16,5,16,6],[16,13,16,18],[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],[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],[0,1,0,16],[41,12,41,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],[41,6,41,9],[41,14,41,15],[12,4,12,5],[35,1,35,2],[1,11,1,16],[6,4,6,5],[7,4,7,5],[53,6,53,10],[53,14,53,16],[59,12,59,13],[58,12,58,13],[56,1,56,16],[50,0,52,0],[41,4,41,5],[48,0,49,0],[47,1,47,16],[52,1,52,16],[42,1,42,16],[43,4,43,5],[43,12,43,13]]}
["GRUNDDATEN","Grunddaten der nicht 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","Finanziell weniger leistungsfähiger Elternteil (in der Regel mit überwiegendem Betreuungsanteil)",null,null,null,null,null,null,null,"Anderer Elternteil",null,null,null,null,null,"Neuer Partner","Quelle / Gesamt"]
[null,"Zivilstand","unverheiratet",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 (nur falls ≠ heutiger Tag)",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"]
[null,"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":""}]
[null,"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":""}]
[null,"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"]
["B1","Nettoeinkommen"]
["B2","Weiteres Einkommen"]
["B3","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",null,null,null,null,null,null,null,"fam. Notbedarf"]
["C1","Grundbetr.",null,{"$f":"SUM(E18,G18:J18)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(M18,O18:P18)","v":0}]
["C2","Wohn- inkl. Nebenkosten",null,0,null,null,null,null,null,null,null,0]
["C3","Krankenkasse (KVG, abzgl. IPV)",null,0,null,null,null,null,null,null,null,0]
["C4","Zus. Ges.kosten Elternteil",null,0,null,null,null,null,null,null,null,0]
["C5","Versicherungen",null,0,null,null,null,null,null,null,null,0]
["C6","Billag",null,0,null,null,null,null,null,null,null,0]
["C7","Kommunikationskosten",null,0,null,null,null,null,null,null,null,0]
["C8","Krankenkasse Kinder",null,0,null,null,null,null,null,null,null,0]
["C9","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]
["C11","Fremdbetreuungskosten",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]
["C15","zus. berufsbed. Kosten",null,0,null,null,null,null,null,null,null,0]
["C12","Steuern eingeben",null,0,null,null,null,null,null,null,null,0]
["C18",null,null,0,null,null,null,null,null,null,null,0]
["C19",null,null,0,null,null,null,null,null,null,null,0]
["C20",null,null,0,null,null,null,null,null,null,null,0]
[null,"Summe",null,{"$f":"SUM(D18:D35)","v":0},{"$f":"SUM(E$18:E$35)","v":0},null,{"$f":"SUM(G$18:G$35)","v":0},{"$f":"SUM(H$18:H$35)","v":0},{"$f":"SUM(I$18:I$35)","v":0},{"$f":"SUM(J$18:J$35)","v":0},{"$f":"SUM(K$18:K$35)","v":0},{"$f":"SUM(L18:L35)","v":0},{"$f":"SUM(M$18:M$35)","v":0},null,{"$f":"SUM(O$18:O$35)","v":0},{"$f":"SUM(P$18:P$35)","v":0},{"$f":"IF($S$4=\"betreut Kinder nicht\",SUM(Q$18:Q$35),IF($S$4=\"betreut Kinder\",SUM(Q$18:Q$35),\"\"))","v":0},{"$f":"SUM(R$18:R$35)","v":0}]
[null,"Betreuungsunterhalt"]
[null,"Lebenshaltungskosten",null,null,null,null,null,null,null,null,{"$f":"K$36","v":0},null,null,null,null,null,{"$f":"Q$36","v":0}]
["C25","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$36-E$14)>=0,SUM(K$36-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$36-R$14)>0),SUM(Q$36-R$14),IF(AND(S4=\"betreut Kinder nicht\",SUM(Q$36-M$14)>0),SUM(Q$36-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","Einkommen (inkl. Einkommen Kinder)",null,{"$f":"SUM(E14,G14:J14)","v":0},{"$f":"IF(E14<>\"\",E14,\"\")","v":0},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":"SUM(M14,O14:P14)","v":0},{"$f":"IF(M14<>\"\",M14,\"\")","v":0},null,{"$f":"IF(O14<>\"\",O14,\"\")","v":0},{"$f":"IF(P14<>\"\",P14,\"\")","v":0}]
["C25","abzgl. fam. Notbedarf Eltern",null,{"$f":"-SUM(E36)","v":0},{"$f":"IF(E36<>\"\",SUM(E36),\"\")","v":0},null,null,null,null,null,null,{"$f":"-SUM(M36)","v":0},{"$f":"IF(M36<>\"\",SUM(M36),\"\")","v":0}]
["Unterhaltsberechnung","abzgl. Barbedarf Kinder",null,{"$f":"-SUM(G36:J36)","v":0},null,null,{"$f":"IF(G36<>\"\",G36,\"\")","v":0},{"$f":"IF(H36<>\"\",H36,\"\")","v":0},{"$f":"IF(I36<>\"\",I36,\"\")","v":0},{"$f":"IF(J36<>\"\",J36,\"\")","v":0},{"$f":"IF(E46=\"\",\"\",E46)","v":""},{"$f":"-SUM(O46,P46)","v":0},null,null,{"$f":"IF(O36<>\"\",O36,\"\")","v":0},{"$f":"IF(P36<>\"\",P36,\"\")","v":0}]
[null,"Überschuss über fam. Notbedarf und Barbedarf Kinder",null,{"$f":"SUM(D44:D46)","v":0},null,null,null,null,null,null,{"$f":"IF(E47=\"\",\"\",E47)","v":""},{"$f":"SUM(L44:L46)","v":0}]
[null," Bestimmung Barbedarf der Kinder"]
[null,"Überschuss nach Abzug fam. Notbedarf",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M14-M36)","v":0}]
[null,"abzüglich Barbedarf Kinder",null,null,null,null,{"$f":"IF(G36<>\"\",G36,\"\")","v":0},{"$f":"IF(H36<>\"\",H36,\"\")","v":0},{"$f":"IF(I36<>\"\",I36,\"\")","v":0},{"$f":"IF(J36<>\"\",J36,\"\")","v":0},null,{"$f":"-SUM(G50:J50,O50:P50)","v":0},null,null,{"$f":"IF(O36<>\"\",O36,\"\")","v":0},{"$f":"IF(P36<>\"\",P36,\"\")","v":0}]
[null,"zzgl. Einkommen Kinder",null,null,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":"SUM(G51:J51,O51:P51)","v":0},null,null,{"$f":"IF(O14<>\"\",O14,\"\")","v":0},{"$f":"IF(P14<>\"\",P14,\"\")","v":0}]
[null,"Anspruch je Kind / Überschuss nach Deckung Barbedarf",null,null,null,null,{"$f":"SUM(G50-G51)","v":0},{"$f":"SUM(H50-H51)","v":0},{"$f":"SUM(I50-I51)","v":0},{"$f":"SUM(J50-J51)","v":0},null,{"$f":"SUM(L49,IF(L50<>\"\",L50,0),IF(L51<>\"\",L51,0))","v":0},null,null,{"$f":"SUM(O50-O51)","v":0},{"$f":"SUM(P50-P51)","v":0}]
[null,"Bestimmung des theoretischen Betreuungsunterhaltes der Kinder"]
[null,"Überschuss nach Abzug Barbedarf",null,null,null,null,"Betreuungsunterhalt über- od. unterschritten!",null,null,null,null,{"$f":"SUM(L52)","v":0},null,null,"Betreuungsunterhalt über- od. unterschritten!"]
[null,"Betreuungsunterhalt pro Kind eingeben",null,null,null,null,null,null,null,null,{"$f":"D$40","v":0},null,null,null,null,null,{"$f":"Q$40","v":0}]
[null,"Anspruch je Kind",null,null,null,null,{"$f":"SUM(G55)","v":0},{"$f":"SUM(H55)","v":0},{"$f":"SUM(I55)","v":0},{"$f":"SUM(J55)","v":0},null,null,null,null,{"$f":"SUM(O55)","v":0},{"$f":"SUM(P55)","v":0}]
[null,"Überschussaufteilung"]
[null,"Überschuss ",{"$f":"IF(M14-M36-SUM(G52:J52,O52:P52)-SUM(G55:J55,O55:P55)>0,M14-M36-SUM(G52:J52,O52:P52)-SUM(G55:J55,O55:P55),0)","v":0}]
[null,"Anteil in Prozent eingeben",{"$f":"ROUND(SUM(D59,L59),3)","v":0},{"$f":"SUM(G59:J59)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(M59:P59)","v":0}]
[null,"Anteil in Franken",{"$f":"SUM(C58*C59)","v":0},{"$f":"SUM($C$58*D59)","v":0},null,null,{"$f":"SUM($C$58*G$59)","v":0},{"$f":"SUM($C$58*H$59)","v":0},{"$f":"SUM($C$58*I$59)","v":0},{"$f":"SUM($C$58*J$59)","v":0},null,{"$f":"SUM($C$58*L59)","v":0},{"$f":"SUM($C$58*M$59)","v":0},null,{"$f":"SUM($C$58*O$59)","v":0},{"$f":"SUM($C$58*P$59)","v":0}]

{"sheet":"RT","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,2],[22,7,22,8],[20,1,20,2],[18,0,18,10],[17,1,17,2],[17,7,17,8],[21,1,21,2],[25,7,25,8],[25,3,25,4],[25,5,25,6],[24,7,24,8],[23,0,23,10],[24,1,24,2],[22,1,22,2],[25,9,25,10],[0,11,0,12],[19,1,19,2],[5,0,5,10],[9,0,9,10],[10,7,10,8],[10,9,10,10],[10,3,10,6],[6,3,6,6],[6,7,6,8],[6,9,6,10],[17,11,17,13],[14,1,14,2],[13,0,13,10],[15,0,15,10],[0,1,0,2],[16,1,16,2],[16,3,16,10],[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]]}
["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$36<>\"\",GR!E$36,\"\")","v":0},null,{"$f":"IF(GR!G$36<>\"\",GR!G$36,\"\")","v":0},{"$f":"IF(GR!H$36<>\"\",GR!H$36,\"\")","v":0},{"$f":"IF(GR!I$36<>\"\",GR!I$36,\"\")","v":0},{"$f":"IF(GR!J$36<>\"\",GR!J$36,\"\")","v":0},{"$f":"IF(GR!M$36<>\"\",GR!M$36,\"\")","v":0},null,{"$f":"IF(GR!O$36<>\"\",GR!O$36,\"\")","v":0},{"$f":"IF(GR!P$36<>\"\",GR!P$36,\"\")","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}]
["Barbedarf"]
["Mittel zur Deckung Barbedarf (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 Barbedarf Einkommen Kinder bereits abgezogen",null,null,{"$f":"GR!G$52","v":0},{"$f":"GR!H$52","v":0},{"$f":"GR!I$52","v":0},{"$f":"GR!J$52","v":0},null,null,{"$f":"GR!O$52","v":0},{"$f":"GR!P$52","v":0}]
[{"$f":"\"Effektiv von \"&IF(GR!M5<>\"\",GR!M5,\"\")&\" geschuldeter Barbetrag\"","v":"Effektiv von  geschuldeter Barbetrag"},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}]
["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$55","v":0},{"$f":"GR!H$55","v":0},{"$f":"GR!I$55","v":0},{"$f":"GR!J$55","v":0},null,null,{"$f":"GR!O$55","v":0},{"$f":"GR!P$55","v":0}]
[{"$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":"\"Deckung vorhandenes Manko Barbedarf der eigenen Kinder durch Überschuss \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")","v":"Deckung vorhandenes Manko Barbedarf der eigenen Kinder durch Überschuss "}]
[{"$f":"\"Allfälliger Beitrag \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" zur Mankodeckung Barbedarf Kinder\"","v":"Allfälliger Beitrag  zur Mankodeckung Barbedarf Kinder"},null,null,{"$f":"IF(AND(SUM($D$8:$G$8>$D$9:$G$9),SUM($B$11+SUM($D$13:$G$13))>0),MIN(SUM($B$11+SUM($D$13:$G$13))*SUM(D$9/SUM($D$9:$G$9)),D$8-D$9),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8>$D$9:$G$9),SUM($B$11+SUM($D$13:$G$13))>0),MIN(SUM($B$11+SUM($D$13:$G$13))*SUM(E$9/SUM($D$9:$G$9)),E$8-E$9),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8>$D$9:$G$9),SUM($B$11+SUM($D$13:$G$13))>0),MIN(SUM($B$11+SUM($D$13:$G$13))*SUM(F$9/SUM($D$9:$G$9)),F$8-F$9),0)","v":0},{"$f":"IF(AND(SUM($D$8:$G$8>$D$9:$G$9),SUM($B$11+SUM($D$13:$G$13))>0),MIN(SUM($B$11+SUM($D$13:$G$13))*SUM(G$9/SUM($D$9:$G$9)),G$8-G$9),0)","v":0}]
["Überschussaufteilung"]
["Gesamthaft verbleibender Überschuss nach Deckung Unterhaltsbeiträge",null,null,{"$f":"IF(GR!C58<0,0,GR!C58)","v":0}]
["Anspruch aus Überschuss",null,null,{"$f":"SUM(GR!G$59*GR!$C$58)","v":0},{"$f":"SUM(GR!H$59*GR!$C$58)","v":0},{"$f":"SUM(GR!I$59*GR!$C$58)","v":0},{"$f":"SUM(GR!J$59*GR!$C$58)","v":0},{"$f":"SUM(GR!M$59*GR!$C$58)","v":0},null,{"$f":"SUM(GR!O$59*GR!$C$58)","v":0},{"$f":"SUM(GR!P$59*GR!$C$58)","v":0},"Überschuss nicht vollständig verteilt"]
["Manko"]
["Theoretischer Unterhaltsanspruch            ",null,null,{"$f":"SUM(D$8,D$12,D$18)","v":0},{"$f":"SUM(E$8,E$12,E$18)","v":0},{"$f":"SUM(F$8,F$12,F$18)","v":0},{"$f":"SUM(G$8,G$12,G$18)","v":0},null,null,{"$f":"SUM(J$8,J$12,J$18)","v":0},{"$f":"SUM(K$8,K$12,K$18)","v":0}]
["Unterhaltsanspruch effektiv",null,null,{"$f":"SUM(D$9,D$13,D$18)","v":0},{"$f":"SUM(E$9,E$13,E$18)","v":0},{"$f":"SUM(F$9,F$13,F$18)","v":0},{"$f":"SUM(G$9,G$13,G$18)","v":0},null,null,{"$f":"SUM(J$9,J$13,J$18)","v":0},{"$f":"SUM(K$9,K$13,K$18)","v":0}]
[{"$f":"\"Beitrag zur Mankodeckung Barbedarf \"&IF(GR!$E$5<>\"\",GR!$E$5,\"\")&\" bei vorhandenen Mitteln\"","v":"Beitrag zur Mankodeckung Barbedarf  bei vorhandenen Mitteln"},null,null,{"$f":"D15","v":0},{"$f":"E15","v":0},{"$f":"F15","v":0},{"$f":"G15","v":0}]
["Manko pro Person",null,null,{"$f":"ROUND(D21-D20+D22,1)","v":0},{"$f":"ROUND(E21-E20+E22,1)","v":0},{"$f":"ROUND(F21-F20+F22,1)","v":0},{"$f":"ROUND(G21-G20+G22,1)","v":0},null,null,{"$f":"ROUND(J21-J20+J22,1)","v":0},{"$f":"ROUND(K21-K20+K22,1)","v":0}]
["Effektive Unterhaltsbeiträge"]
["Zuzusprechender Unterhalt pro Kopf",null,null,{"$f":"ROUND(D21,1)","v":0},{"$f":"ROUND(E21,1)","v":0},{"$f":"ROUND(F21,1)","v":0},{"$f":"ROUND(G21,1)","v":0},null,null,{"$f":"ROUND(J21,1)","v":0},{"$f":"ROUND(K21,1)","v":0}]
["Zuzusprechender Unterhalt pro Haushalt",{"$f":"SUM(B25:G25)","v":0},null,null,null,null,null,{"$f":"J25+K25","v":0},{"$f":"I22","v":0}]

{"sheet":"StR","index":2,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[14,0,14,4],[7,0,7,4],[29,0,29,4],[15,1,15,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],[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]]}
["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"]
["Steuertarif leer lassen"]
["Konfession leer lassen"]
["Wohnort leer lassen"]
["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$26*12","v":0},{"$f":"RT!$B$26*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",{"$f":"SUM(GR!E29*12)","v":0},{"$f":"SUM(GR!E29*12)","v":0},{"$f":"SUM(GR!M29*12)","v":0},{"$f":"SUM(GR!M29*12)","v":0}]
["b) Verpflegung",{"$f":"IF(SUM(GR!$E$30*12)>3200,3200,SUM(GR!$E$30*12))","v":0},{"$f":"IF(SUM(GR!$E$30*12)>3200,3200,SUM(GR!$E$30*12))","v":0},{"$f":"IF(SUM(GR!$M$30*12)>3200,3200,SUM(GR!$M$30*12))","v":0},{"$f":"IF(SUM(GR!$M$30*12)>3200,3200,SUM(GR!$M$30*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 optional",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M20<>\"\",M20,\"\")","v":""}]
["Schuldzinsen optional"]
["Unterhaltsbeiträge",null,null,{"$f":"RT!B26*12","v":0},{"$f":"RT!$B$26*12","v":0}]
["Aufwendungen für Säule 3a optional"]
["Versicherungsprämien (Erwachsene)",{"$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",{"$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 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"]
["Total Direkte Bundessteuer leer lassen"]
["Abzüglich Verrechnungssteuerguthaben optional"]
["Gesamter jährlicher Steuerbetrag ",{"$f":"SUM(B33:B34)-B35","v":0},null,{"$f":"SUM(D33:D34)-D35","v":0}]
["Monatlicher Steuerbetrag",{"$f":"ROUND(B36/12,1)","v":0},null,{"$f":"ROUND(D36/12,1)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[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":"Stammdaten","index":3,"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"]