{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Zugewinn","Modul1","Indextabelle","Dialog Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":1,"reason":"part_missing"},{"sheet":"Dialog Info","index":3,"reason":"not_a_worksheet"}],"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":"Zugewinn","index":0,"n_rows":69,"n_cols":12,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Datum","Index","Bezeichnung",{"$f":"CONCATENATE(\"Vortrag Kläger\",IF(ISBLANK($E$2),\"\",\" (\"&$E$2&\")\"))","v":"Vortrag Kläger (Mann)"},null,{"$f":"IF(ISBLANK($E$2),\"Vortrag Beklagter\",\"Vortrag Beklagter (\"&IF($E$2=\"Frau\",\"Mann\",\"Frau\")&\")\")","v":"Vortrag Beklagter (Frau)"},null,"bewiesen / unstr.",null,"Gericht"]
[null,"Z u g e w i n n a u s g l e i c h",null,"Kläger ist ","Mann"," Ausgleichspflichtig ist …",null,{"$f":"H52","v":"niemand"},{"$f":"J52","v":0},null,null,"Auszufüllen bzw. zu modifizieren sind die hellgelb hinterlegten Felder."]
[null,null,"Zustellung des Scheidungsantrags:","2016-01-03",{"$f":"CONCATENATE(\" Verbraucherpreisindex \",YEAR(D3),\":\")","v":" Verbraucherpreisindex 2016:"},{"$f":"LOOKUP(YEAR(D3),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60)","v":106.9},null,null,null,null,null,"Die Formeln in den orangefarben hinter-"]
[null,null,"Eheschließung:","2003-05-04",{"$f":"CONCATENATE(\" Verbraucherpreisindex \",YEAR(D4),\":\")","v":" Verbraucherpreisindex 2003:"},{"$f":"LOOKUP(YEAR(D4),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60)","v":89.6},null,null,null,null,null,"legten Feldern, die bei Einigkeit/Unstrittig-"]
[null,null,null,null,null,null,null,null,null,null,null,"keit den effektiven Zugewinn aus den Vor-"]
[null,"Vermögenswerte der Frau:",null,null,null,null,null,null,null,null,null,"trägen ermitteln, können überschrieben wer-"]
[null,null,null,{"$f":"\"Vortrag Kläger (\"&$E$2&\")\"","v":"Vortrag Kläger (Mann)"},null,{"$f":"\"Vortrag Beklagter (\"&IF($E$2=\"Frau\",\"Mann\",\"Frau\")&\")\"","v":"Vortrag Beklagter (Frau)"},null,"bewiesen / unstr.",null,"Gericht",null,"den, wenn ein bewiesener Vermögenswert"]
["Datum","Index","Bezeichnung","Wert","Wert indiziert","Wert","Wert indiziert","Wert","Wert indiziert","Wert indiziert",null," vom Vortrag des Klägers bzw.  des Beklag-"]
[null,null,"Anfangsvermögen der Frau (§ 1374 Abs. 1 BGB)",null,null,null,null,null,null,null,null,"ten abweicht."]
[null,null,null,null,{"$f":"IF(ISBLANK(D10),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",D10*$F$3/$F$4))","v":""},null,{"$f":"IF(ISBLANK(F10),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",F10*$F$3/$F$4))","v":""},{"$f":"IF(ISBLANK($C10),\"\",IF(F10=\"\",D10,IF(D10=\"\",F10,\"\")))","v":""},{"$f":"IF($F$4=0,\"Bitte Indexwerte berichtigen!\",IF(ISNUMBER(H10),H10*$F$3/$F$4,\"\"))","v":""},{"$f":"IF(ISNUMBER(H10),I10,IF(E10<G10,E10,G10))","v":""},null,"Die Daten bei der Auflistung des Anfangs-"]
[null,null,null,null,{"$f":"IF(ISBLANK(D11),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",D11*$F$3/$F$4))","v":""},null,{"$f":"IF(ISBLANK(F11),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",F11*$F$3/$F$4))","v":""},{"$f":"IF(ISBLANK($C11),\"\",IF(F11=\"\",D11,IF(D11=\"\",F11,\"\")))","v":""},{"$f":"IF($F$4=0,\"Bitte Indexwerte berichtigen!\",IF(ISNUMBER(H11),H11*$F$3/$F$4,\"\"))","v":""},{"$f":"IF(ISNUMBER(H11),I11,IF(E11<G11,E11,G11))","v":""},null,"und Endvermögens sind für die Berechnung"]
["Summe Frau (§ 1374 I BGB)",null,null,null,{"$f":"IF(SUM(E9:E11)<0,0,SUM(E9:E11))","v":0},null,{"$f":"IF(SUM(G9:G11)<0,0,SUM(G9:G11))","v":0},null,null,{"$f":"IF(SUM(J9:J11)<0,0,SUM(J9:J11))","v":0},null,"des Zugewinns unerheblich, können aber"]
[null,null,"Zurechnung zum Anfangsvermögen der Frau (§ 1374 Abs. 2 BGB)",null,null,null,null,null,null,null,null,"zu Dokumentationszwecken eingetragen"]
[null,{"$f":"IF(A14=\"\",$F$3,LOOKUP(YEAR(A14),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D14),\"\",D14*$F$3/$B14)","v":""},null,{"$f":"IF(ISBLANK(F14),\"\",F14*$F$3/$B14)","v":""},{"$f":"IF(ISBLANK($C14),\"\",IF(F14=\"\",D14,IF(D14=\"\",F14,\"\")))","v":""},{"$f":"IF(ISNUMBER(H14),H14*$F$3/$B14,\"\")","v":""},{"$f":"IF(ISNUMBER(H14),I14,IF(E14<G14,E14,G14))","v":""},null,"werden."]
[null,{"$f":"IF(A15=\"\",$F$3,LOOKUP(YEAR(A15),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D15),\"\",D15*$F$3/$B15)","v":""},null,{"$f":"IF(ISBLANK(F15),\"\",F15*$F$3/$B15)","v":""},{"$f":"IF(ISBLANK($C15),\"\",IF(F15=\"\",D15,IF(D15=\"\",F15,\"\")))","v":""},{"$f":"IF(ISNUMBER(H15),H15*$F$3/$B15,\"\")","v":""},{"$f":"IF(ISNUMBER(H15),I15,IF(E15<G15,E15,G15))","v":""}]
["Anfangsvermögen + Zurechnung Frau",null,null,null,{"$f":"IF(SUM(E12:E15)<0,0,SUM(E12:E15))","v":0},null,{"$f":"IF(SUM(G12:G15)<0,0,SUM(G12:G15))","v":0},null,null,{"$f":"IF(SUM(J12:J15)<0,0,SUM(J12:J15))","v":0}]
[null,null,"Endvermögen der Frau (§ 1375 Abs. 1 BGB)"]
[null,null,null,null,{"$f":"IF(ISBLANK(D18),\"\",D18)","v":""},null,{"$f":"IF(ISBLANK(F18),\"\",F18)","v":""},{"$f":"IF(ISBLANK($C18),\"\",IF(F18=\"\",D18,IF(D18=\"\",F18,\"\")))","v":""},{"$f":"IF(ISNUMBER(H18),H18,\"\")","v":""},{"$f":"IF(ISNUMBER(H18),I18,G18)","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK(D19),\"\",D19)","v":""},null,{"$f":"IF(ISBLANK(F19),\"\",F19)","v":""},{"$f":"IF(ISBLANK($C19),\"\",IF(F19=\"\",D19,IF(D19=\"\",F19,\"\")))","v":""},{"$f":"IF(ISNUMBER(H19),H19,\"\")","v":""},{"$f":"IF(ISNUMBER(H19),I19,G19)","v":""}]
["Summe Frau (§ 1375 I BGB)",null,null,null,{"$f":"IF(SUM(E17:E19)<0,0,SUM(E17:E19))","v":0},null,{"$f":"IF(SUM(G17:G19)<0,0,SUM(G17:G19))","v":0},null,null,{"$f":"IF(SUM(J17:J19)<0,0,SUM(J17:J19))","v":0}]
[null,null,"Zurechnung zum Endvermögen der Frau (§ 1375 Abs. 2 BGB)"]
[null,{"$f":"IF(A22=\"\",$F$3,LOOKUP(YEAR(A22),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D22),\"\",D22*$F$3/$B22)","v":""},null,{"$f":"IF(ISBLANK(F22),\"\",F22*$F$3/$B22)","v":""},{"$f":"IF(ISBLANK($C22),\"\",IF(F22=\"\",D22,IF(D22=\"\",F22,\"\")))","v":""},{"$f":"IF(ISNUMBER(H22),H22*$F$3/$B22,\"\")","v":""},{"$f":"IF(ISNUMBER(H22),I22,G22)","v":""}]
[null,{"$f":"IF(A23=\"\",$F$3,LOOKUP(YEAR(A23),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D23),\"\",D23*$F$3/$B23)","v":""},null,{"$f":"IF(ISBLANK(F23),\"\",F23*$F$3/$B23)","v":""},{"$f":"IF(ISBLANK($C23),\"\",IF(F23=\"\",D23,IF(D23=\"\",F23,\"\")))","v":""},{"$f":"IF(ISNUMBER(H23),H23*$F$3/$B23,\"\")","v":""},{"$f":"IF(ISNUMBER(H23),I23,G23)","v":""}]
["Endvermögen + Zurechnung Frau",null,null,null,{"$f":"IF(SUM(E20:E23)<0,0,SUM(E20:E23))","v":0},null,{"$f":"IF(SUM(G20:G23)<0,0,SUM(G20:G23))","v":0},null,null,{"$f":"IF(SUM(J20:J23)<0,0,SUM(J20:J23))","v":0}]
["Zugewinn der Frau",null,null,null,{"$f":"IF(E$24-E$16<0,0,E$24-E$16)","v":0},null,{"$f":"IF(G$24-G$16<0,0,G$24-G$16)","v":0},null,null,{"$f":"IF(J$24-J$16<0,0,J$24-J$16)","v":0}]
[]
[null,"Vermögenswerte des Mannes:"]
[null,null,null,{"$f":"\"Vortrag Kläger (\"&$E$2&\")\"","v":"Vortrag Kläger (Mann)"},null,{"$f":"\"Vortrag Beklagter (\"&IF($E$2=\"Frau\",\"Mann\",\"Frau\")&\")\"","v":"Vortrag Beklagter (Frau)"},null,"bewiesen / unstr.",null,"Gericht"]
["Datum","Index","Bezeichnung","Wert","Wert indiziert","Wert","Wert indiziert","Wert","Wert indiziert","Wert indiziert"]
[null,null,"Anfangsvermögen des Mannes (§ 1374 Abs. 1 BGB)"]
[null,null,null,null,{"$f":"IF(ISBLANK(D31),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",D31*$F$3/$F$4))","v":""},null,{"$f":"IF(ISBLANK(F31),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",F31*$F$3/$F$4))","v":""},{"$f":"IF(ISBLANK($C31),\"\",IF(F31=\"\",D31,IF(D31=\"\",F31,\"\")))","v":""},{"$f":"IF($F$4=0,\"Bitte Indexwerte berichtigen!\",IF(ISNUMBER(H31),H31*$F$3/$F$4,\"\"))","v":""},{"$f":"IF(ISNUMBER(H31),I31,IF(E31<G31,E31,G31))","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK(D32),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",D32*$F$3/$F$4))","v":""},null,{"$f":"IF(ISBLANK(F32),\"\",IF($F$4=0,\"Bitte Indexwerte berichtigen!\",F32*$F$3/$F$4))","v":""},{"$f":"IF(ISBLANK($C32),\"\",IF(F32=\"\",D32,IF(D32=\"\",F32,\"\")))","v":""},{"$f":"IF($F$4=0,\"Bitte Indexwerte berichtigen!\",IF(ISNUMBER(H32),H32*$F$3/$F$4,\"\"))","v":""},{"$f":"IF(ISNUMBER(H32),I32,IF(E32<G32,E32,G32))","v":""}]
["Summe Mann (§ 1374 I BGB)",null,null,null,{"$f":"IF(SUM(E30:E32)<0,0,SUM(E30:E32))","v":0},null,{"$f":"IF(SUM(G30:G32)<0,0,SUM(G30:G32))","v":0},null,null,{"$f":"IF(SUM(J30:J32)<0,0,SUM(J30:J32))","v":0}]
[null,null,"Zurechnung zum Anfangsvermögen des Mannes (§ 1374 Abs. 2 BGB)"]
[null,{"$f":"IF(A35=\"\",$F$3,LOOKUP(YEAR(A35),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D35),\"\",D35*$F$3/$B35)","v":""},null,{"$f":"IF(ISBLANK(F35),\"\",F35*$F$3/$B35)","v":""},{"$f":"IF(ISBLANK($C35),\"\",IF(F35=\"\",D35,IF(D35=\"\",F35,\"\")))","v":""},{"$f":"IF(ISNUMBER(H35),H35*$F$3/$B35,\"\")","v":""},{"$f":"IF(ISNUMBER(H35),I35,IF(E35<G35,E35,G35))","v":""}]
[null,{"$f":"IF(A36=\"\",$F$3,LOOKUP(YEAR(A36),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,"",null,"",{"$f":"IF(ISBLANK($C36),\"\",IF(F36=\"\",D36,IF(D36=\"\",F36,\"\")))","v":""},"",""]
["Anfangsvermögen + Zurechnung Mann",null,null,null,{"$f":"IF(SUM(E33:E36)<0,0,SUM(E33:E36))","v":0},null,{"$f":"IF(SUM(G33:G36)<0,0,SUM(G33:G36))","v":0},null,null,{"$f":"IF(SUM(J33:J36)<0,0,SUM(J33:J36))","v":0}]
[null,null,"Endvermögen des Mannes (§ 1375 Abs. 1 BGB)"]
[null,null,null,null,{"$f":"IF(ISBLANK(D39),\"\",D39)","v":""},null,{"$f":"IF(ISBLANK(F39),\"\",F39)","v":""},{"$f":"IF(ISBLANK($C39),\"\",IF(F39=\"\",D39,IF(D39=\"\",F39,\"\")))","v":""},{"$f":"IF(ISNUMBER(H39),H39,\"\")","v":""},{"$f":"IF(ISNUMBER(H39),I39,G39)","v":""}]
[null,null,null,null,{"$f":"IF(ISBLANK(D40),\"\",D40)","v":""},null,{"$f":"IF(ISBLANK(F40),\"\",F40)","v":""},{"$f":"IF(ISBLANK($C40),\"\",IF(F40=\"\",D40,IF(D40=\"\",F40,\"\")))","v":""},{"$f":"IF(ISNUMBER(H40),H40,\"\")","v":""},{"$f":"IF(ISNUMBER(H40),I40,G40)","v":""}]
["Summe Mann (§ 1375 I BGB)",null,null,null,{"$f":"IF(SUM(E38:E40)<0,0,SUM(E38:E40))","v":0},null,{"$f":"IF(SUM(G38:G40)<0,0,SUM(G38:G40))","v":0},null,null,{"$f":"IF(SUM(J38:J40)<0,0,SUM(J38:J40))","v":0}]
[null,null,"Zurechnung zum Endvermögen des Mannes (§ 1375 Abs. 2 BGB)"]
[null,{"$f":"IF(A43=\"\",$F$3,LOOKUP(YEAR(A43),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D43),\"\",D43*$F$3/$B43)","v":""},null,{"$f":"IF(ISBLANK(F43),\"\",F43*$F$3/$B43)","v":""},{"$f":"IF(ISBLANK($C43),\"\",IF(F43=\"\",D43,IF(D43=\"\",F43,\"\")))","v":""},{"$f":"IF(ISNUMBER(H43),H43*$F$3/$B43,\"\")","v":""},{"$f":"IF(ISNUMBER(H43),I43,G43)","v":""}]
[null,{"$f":"IF(A44=\"\",$F$3,LOOKUP(YEAR(A44),Indextabelle!$A$3:$A$60,Indextabelle!$B$3:$B$60))","v":106.9},null,null,{"$f":"IF(ISBLANK(D44),\"\",D44*$F$3/$B44)","v":""},null,{"$f":"IF(ISBLANK(F44),\"\",F44*$F$3/$B44)","v":""},{"$f":"IF(ISBLANK($C44),\"\",IF(F44=\"\",D44,IF(D44=\"\",F44,\"\")))","v":""},{"$f":"IF(ISNUMBER(H44),H44*$F$3/$B44,\"\")","v":""},{"$f":"IF(ISNUMBER(H44),I44,G44)","v":""}]
["Endvermögen + Zurechnung Mann",null,null,null,{"$f":"IF(SUM(E41:E44)<0,0,SUM(E41:E44))","v":0},null,{"$f":"IF(SUM(G41:G44)<0,0,SUM(G41:G44))","v":0},null,null,{"$f":"IF(SUM(J41:J44)<0,0,SUM(J41:J44))","v":0}]
["Zugewinn des Mannes",null,null,null,{"$f":"IF(E$45-E$37<0,0,E$45-E$37)","v":0},null,{"$f":"IF(G$45-G$37<0,0,G$45-G$37)","v":0},null,null,{"$f":"IF(J$45-J$37<0,0,J$45-J$37)","v":0}]
[]
["Ausgleichsberechnung:",null,null,{"$f":"D7","v":"Vortrag Kläger (Mann)"},null,{"$f":"F7","v":"Vortrag Beklagter (Frau)"},null,"Gericht"]
[null,"Zugewinn des Mannes:",null,null,{"$f":"E$46","v":0},null,{"$f":"G$46","v":0},null,null,{"$f":"J$46","v":0}]
[null,"Zugewinn der Frau:",null,null,{"$f":"E$25","v":0},null,{"$f":"G$25","v":0},null,null,{"$f":"J$25","v":0}]
[null,"Differenz:",null,null,{"$f":"E49-E50","v":0},null,{"$f":"G49-G50","v":0},null,null,{"$f":"J49-J50","v":0}]
[null,"Ausgleichspflichtig ist …",null,{"$f":"IF(E51=0,\"niemand\",IF(E51>0,\"der Mann\",\"die Frau\"))","v":"niemand"},{"$f":"ABS(E51)/2","v":0},{"$f":"IF(G51=0,\"niemand\",IF(G51>0,\"der Mann\",\"die Frau\"))","v":"niemand"},{"$f":"ABS(G51)/2","v":0},{"$f":"IF(J51=0,\"niemand\",IF(J51>0,\"der Mann\",\"die Frau\"))","v":"niemand"},null,{"$f":"ABS(J51)/2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Frau"]
["Mann"]

{"sheet":"Indextabelle","index":2,"n_rows":75,"n_cols":3,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Verbraucherpreisindizes des Statistischen Bundesamtes zur Basis 2010 (= 100)"]
["\n\n\n\n\n\nJahr","\n\n\n\n\n\nIndex","Neuere Indexwerte müssen ab Zeile 63 in Spalte B in die gelb hinterlegten Felder eingegeben werden, sobald sie veröffentlicht sind. Ältere Indexwerte müssen im Bedarfsfall oberhalb von Zeile 38 ebenfalls in Spalte B in die gelb hinterlegten Felder eingegeben werden. Anschließend sollte die Tabelle sicherheitshalber mit nebenstehender Schaltfläche wieder verborgen werden."]
[1958]
[1959]
[1960]
[1961]
[1962]
[1963]
[1964]
[1965]
[1966]
[1967]
[1968]
[1969]
[1970]
[1971]
[1972]
[1973]
[1974]
[1975]
[1976]
[1977]
[1978]
[1979]
[1980]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993,77.099999999999994]
[1994,79.099999999999994]
[1995,80.5]
[1996,81.599999999999994]
[1997,83.2]
[1998,84]
[1999,84.5]
[2000,85.7]
[2001,87.4]
[2002,88.6]
[2003,89.6]
[2004,91]
[2005,92.5]
[2006,93.9]
[2007,96.1]
[2008,98.6]
[2009,98.9]
[2010,100]
[2011,102.1]
[2012,104.1]
[2013,105.7]
[2014,106.6]
[2015,106.9]
[2016,107.4]
[2017,109.3]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]