{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Anleitung","Wohnkosten","Krankenkasse","Barunterhalt","Betreuungsunterhalt","Nachehelicher Unterhalt","Überschussverteilung","Zusammenfassung"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Wohnkosten","index":1,"n_rows":15,"n_cols":5,"rows_kept":15}
[]
["MUTTER",{"$nulls":3},"VATER"]
[]
[null,null,"Miete (Hälfte bei Konkubinat)"]
[null,null,"Nebenkosten (Wasser, Heizung)"]
[null,null,"Hypothekarzinsen"]
[null,null,"Gebäudeunterhalt (20% Eigenmietwert / 12) "]
[null,null,"Gebäudeversicherung"]
[]
[{"$f":"SUM(A4:A8)","v":{"v":0,"d":"0.00"}},null,"Total",null,{"$f":"SUM(E4:E8)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Wohnkostenanteil Kinder"]
[]
[{"$f":"$A$10/3/2","v":{"v":0,"d":"0.00"}},null,"Kind 1",null,{"$f":"E$10/3/2","v":{"v":0,"d":"0.00"}}]
[{"$f":"$A$10/3/2","v":{"v":0,"d":"0.00"}},null,"Kind 2",null,{"$f":"E$10/3/2","v":{"v":0,"d":"0.00"}}]

{"sheet":"Krankenkasse","index":2,"n_rows":15,"n_cols":5,"rows_kept":15}
[]
["MUTTER",{"$nulls":3},"VATER"]
[null,null,"Krankenkasse KVG"]
[null,null,"Prämienverbilligung"]
[{"$f":"A3-A4","v":{"v":0,"d":"0.00"}},null,"Total",null,{"$f":"E3-E4","v":{"v":0,"d":"0.00"}}]
[]
["Kind 1",{"$nulls":3},"Kind 1"]
[null,null,"Krankenkasse KVG"]
[null,null,"Prämienverbilligung"]
[{"$f":"A8-A9","v":{"v":0,"d":"0.00"}},null,"Total",null,{"$f":"E8-E9","v":{"v":0,"d":"0.00"}}]
[]
["Kind 2",{"$nulls":3},"Kind 2"]
[null,null,"Krankenkasse KVG"]
[null,null,"Prämienverbilligung"]
[{"$f":"A13-A14","v":{"v":0,"d":"0.00"}},null,"Total",null,{"$f":"E13-E14","v":{"v":0,"d":"0.00"}}]

{"sheet":"Barunterhalt","index":3,"n_rows":106,"n_cols":6,"rows_kept":106}
[]
["MUTTER",{"$nulls":3},"VATER","          Bemerkungen"]
[null,null,"monatliches Nettoeinkommen exkl. KZ"]
[null,null,"13. Monatslohn (monatlicher Anteil)"]
[null,null,"Erträge aus Miete/Pacht"]
[null,null,"AHV/IV Rente"]
[]
[null,null,"Kinder- & Ausbildungszulagen Kind 1"]
[null,null,"Kinder- & Ausbildungszulagen Kind 2"]
[]
[null,null,"Erwerbseinkommen Kind 1"]
[null,null,"Erwerbseinkommen Kind 2"]
[]
[null,null,"Weitere Einnahmen Kind 1"]
[null,null,"Weitere Einnahmen Kind 2"]
[{"$f":"SUM(A3:A15)","v":{"v":0,"d":"0.00"}},null,"Total Einnahmen",null,{"$f":"SUM(E3:E15)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Grundbeträge"]
[null,"Alleinstehender Schuldner",null,{"v":1200,"d":"1,200.00"}]
[null,"Alleinerziehend m.  Unterstützungspflicht:",null,{"v":1350,"d":"1,350.00"}]
[null,"Ehepaar/2 in Hausgemeinschaft:",null,{"v":1700,"d":"1,700.00"}]
[null,"Unterhalt Kinder"]
[null,"bis zu 10 Jahren",null,{"v":400,"d":"400.00"}]
[null,"über 10 Jahre",null,{"v":600,"d":"600.00"}]
[]
[null,null,"Grundbetrag"]
[null,null,"Grundbetrag Kind 1"]
[null,null,"Grundbetrag Kind 2"]
[]
[{"$f":"A26*0.2","v":{"v":0,"d":"0.00"}},null,"Zivilprozessualer Zuschlag",null,{"$f":"E26*0.2","v":{"v":0,"d":"0.00"}}]
[{"$f":"A27*0.2","v":{"v":0,"d":"0.00"}},null,"Zuschlag Kind 1",null,{"$f":"E27*0.2","v":{"v":0,"d":"0.00"}}]
[{"$f":"A28*0.2","v":{"v":0,"d":"0.00"}},null,"Zuschlag Kind 2",null,{"$f":"E28*0.2","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(A35:A36)=0,Wohnkosten!A10,Wohnkosten!A10-SUM(A35:A36))","v":{"v":0,"d":"0.00"}},null,"Wohnkosten",null,{"$f":"IF(SUM(E35:E36)=0,Wohnkosten!E10,Wohnkosten!E10-SUM(E35:E36))","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A27>0,Wohnkosten!A14,0)","v":{"v":0,"d":"0.00"}},null,"Wohnkostenanteil Kind 1",null,{"$f":"IF(E27>0,Wohnkosten!E14,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A28>0,Wohnkosten!A15,0)","v":{"v":0,"d":"0.00"}},null,"Wohnkostenanteil Kind 2",null,{"$f":"IF(E28>0,Wohnkosten!E15,0)","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Hausrat-, Unfall-, Haftpflichtversicherung"]
[null,null,"Lebensversicherung (Säule 3a)"]
[]
[{"$f":"Krankenkasse!A5","v":{"v":0,"d":"0.00"}},null,"Krankenkasse KVG",null,{"$f":"Krankenkasse!E5","v":{"v":0,"d":"0.00"}}]
[{"$f":"Krankenkasse!A10","v":{"v":0,"d":"0.00"}},null,"Krankenkasse KVG Kind 1",null,{"$f":"Krankenkasse!E10","v":{"v":0,"d":"0.00"}}]
[{"$f":"Krankenkasse!A15","v":{"v":0,"d":"0.00"}},null,"Krankenkasse KVG Kind 2",null,{"$f":"Krankenkasse!E15","v":{"v":0,"d":"0.00"}}]
[null,null,"Krankenkasse VVG"]
[null,null,"Krankenkasse VVG Kind 1"]
[null,null,"Krankenkasse VVG Kind 2"]
[null,null,"Behandlungskosten"]
[null,null,"Behandlungskosten Kind 1"]
[null,null,"Behandlungskosten Kind 2"]
[]
[null,null,"Mobilitätskosten"]
[null,null,"Mobilitätskosten Kind 1"]
[null,null,"Mobilitätskosten Kind 2"]
[]
[null,null,"Berufsauslagen Kleider"]
[null,null,"Berufsauslagen Nahrung"]
[]
[null,null,"Weiterbildungskosten"]
[null,null,"Ausbildung Kind 1"]
[null,null,"Ausbildung Kind 2"]
[]
[null,null,"Drittbetreuung Kind 1"]
[null,null,"Drittbetreuung Kind 2"]
[]
[null,null,"Schuldamortisation"]
[]
[null,null,"Hobbies"]
[null,null,"Hobbies Kind 1"]
[null,null,"Hobbies Kind 2"]
[]
[null,null,"Rechtlich geschuldete Unterhaltsbeiträge"]
[null,null,"Steuern"]
[null,null,"Vorsorgeaufbau (1. & 2. Säule)"]
[]
[null,null,"Divers"]
[null,null,"Divers Kind 1"]
[null,null,"Divers Kind 2"]
[]
[{"$f":"SUM(A26:A77)","v":{"v":0,"d":"0.00"}},null,"Existenzminimum 1",null,{"$f":"SUM(E26:E77)","v":{"v":0,"d":"0.00"}}]
[null,null,"Gesamteinkommen",null,null,{"$f":"SUM(A16,E16)","v":{"v":0,"d":"0.00"}}]
[null,null,"Gesamtexistenzminimum",null,null,{"$f":"SUM(A79,E79)","v":{"v":0,"d":"0.00"}}]
[null,null,"Überschuss",null,null,{"$f":"IF(F80>F81,F80-F81,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Manko",null,null,{"$f":"IF(F80<F81,F80-F81,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"$F$82/3","v":{"v":0,"d":"0.00"}},null,"Überschussanteil ",null,{"$f":"$F$82/3","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A27>0,$F$82/3/2/SUM(A27,E27)*A27,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 1",null,{"$f":"IF(E27>0,$F$82/3/2/SUM(A27,E27)*E27,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A28>0,$F$82/3/2/SUM(A28,E28)*A28,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 2",null,{"$f":"IF(E28>0,$F$82/3/2/SUM(A28,E28)*E28,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(A79,A84:A86)","v":{"v":0,"d":"0.00"}},null,"Existenzminimum 2",null,{"$f":"SUM(E79,E84:E86)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((A16+(E16-E87))<A79,IF(SUM(E3:E6)>E79,SUM(E3:E6)-E79,0),IF(SUM(E3:E6)>E87,SUM(E3:E6)-E87,0))","v":{"v":0,"d":"0.00"}},null,"Unterhaltsanspruch maximal (zzgl. Zulagen)",null,{"$f":"IF((E16+(A16-A87))<E79,IF(SUM(A3:A6)>A79,SUM(A3:A6)-A79,0),IF(SUM(A3:A6)>A87,SUM(A3:A6)-A87,0))","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"SUM(A26,A30,A34,A38,A39,A41,A44,A47,A51,A55,A56,A58,A65,A67,A71,A72,A73,A75)","v":{"v":0,"d":"0.00"}},null,"Barbedarf Eltern",null,{"$f":"SUM(E26,E30,E34,E38,E39,E41,E44,E47,E51,E55,E56,E58,E65,E67,E71,E72,E73,E75)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A27+A31+A35+A42+A45+A48+A52+A59+A62+A68+A76","v":{"v":0,"d":"0.00"}},null,"Barbedarf Kind 1",null,{"$f":"E27+E31+E35+E42+E45+E48+E52+E59+E62+E68+E76","v":{"v":0,"d":"0.00"}}]
[{"$f":"A28+A32+A36+A43+A46+A49+A53+A60+A63+A69+A77","v":{"v":0,"d":"0.00"}},null,"Barbedarf Kind 2",null,{"v":0,"d":"0.00"}]
[]
[{"$f":"IF((A91-A8-A11-A14-E8-E11-E14)>0,A91-A8-A11-A14-E8-E11-E14,0)","v":{"v":0,"d":"0.00"}},null,"Barbedarf nach Abzug Einnahmen Kind 1",null,{"$f":"IF((E91-E8-E11-E14-A8-A11-A14)>0,E91-E8-E11-E14-A8-A11-A14,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((A92-A9-A12-A15-E9-E12-E15)>0,A92-A9-A12-A15-E9-E12-E15,0)","v":{"v":0,"d":"0.00"}},null,"Barbedarf nach Abzug Einnahmen Kind 2",null,{"$f":"IF((E92-E9-E12-E15-A9-A12-A15)>0,E92-E9-E12-E15-A9-A12-A15,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(A3:A6)>A90,SUM(A3:A6)-A90,0)","v":{"v":0,"d":"0.00"}},null,"Leistungsfähigkeit Eltern",null,{"$f":"IF(SUM(E3:E6)>E90,SUM(E3:E6)-E90,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(A27>0,IF(A$97>0,A$97/SUM(A$94:A$95)*A94,0),0)","v":{"v":0,"d":"0.00"}},null,"Beitrag betreuender Elternteil Kind 1",null,{"$f":"IF(E27>0,IF(E$97>0,E$97/SUM(E$94:E$95)*E94,0),0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A28>0,IF(A$97>0,A$97/SUM(A$94:A$95)*A95,0),0)","v":{"v":0,"d":"0.00"}},null,"Beitrag betreuender Elternteil Kind 2",null,{"$f":"IF(E28>0,IF(E$97>0,E$97/SUM(E$94:E$95)*E95,0),0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(A$88>0,IF((A94-A99)>0,A94-A99,0),0)","v":{"v":0,"d":"0.00"}},null,"Anspruch Unterhalt maximal Kind 1 (zzgl. Zulagen)",null,{"$f":"IF(E$88>0,IF((E94-E99)>0,E94-E99,0),0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A$88>0,IF((A95-A100)>0,A95-A100,0),0)","v":{"v":0,"d":"0.00"}},null,"Anspruch Unterhalt maximal Kind 2 (zzgl. Zulagen)",null,{"$f":"IF(E$88>0,IF((E95-E100)>0,E95-E100,0),0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(($E$97/(IF(SUM(A$102:A$103)>0,SUM(A$102:A$103),1))*A102)>A102,A102,$E$97/(IF(SUM(A$102:A$103)>0,SUM(A$102:A$103),1))*A102)","v":{"v":0,"d":"0.00"}},null,"Anspruch Barunterhalt Kind 1 (zzgl. Zulagen)",null,{"$f":"IF(($A$97/(IF(SUM(E$102:E$103)>0,SUM(E$102:E$103),1))*E102)>E102,E102,$A$97/(IF(SUM(E$102:E$103)>0,SUM(E$102:E$103),1))*E102)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(($E$97/(IF(SUM(A$102:A$103)>0,SUM(A$102:A$103),1))*A103)>A103,A103,$E$97/(IF(SUM(A$102:A$103)>0,SUM(A$102:A$103),1))*A103)","v":{"v":0,"d":"0.00"}},null,"Anspruch Barunterhalt Kind 2 (zzgl. Zulagen)",null,{"$f":"IF(($A$97/(IF(SUM(E$102:E$103)>0,SUM(E$102:E$103),1))*E103)>E103,E103,$A$97/(IF(SUM(E$102:E$103)>0,SUM(E$102:E$103),1))*E103)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Betreuungsunterhalt","index":4,"n_rows":22,"n_cols":5,"rows_kept":22}
[]
["Zumutbare Erwerbstätigkeit Mutter in %:",null,null,{"$f":"MIN(A12:A13)","v":0}]
["Zumutbare Erwerbstätigkeit Vater in %:",null,null,{"$f":"MIN(E12:E13)","v":0}]
[]
["MUTTER",{"$nulls":3},"VATER"]
[]
[{"$f":"SUM(Barunterhalt!A26,Barunterhalt!A30,Barunterhalt!A34,Barunterhalt!A41,Barunterhalt!A51,Barunterhalt!A55,Barunterhalt!A56,Barunterhalt!A72)","v":{"v":0,"d":"0.00"}},null,"Betreuungskosten",null,{"$f":"SUM(Barunterhalt!E26,Barunterhalt!E30,Barunterhalt!E34,Barunterhalt!E41,Barunterhalt!E51,Barunterhalt!E55,Barunterhalt!E56,Barunterhalt!E72)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(Barunterhalt!A88>0,A7*(100-$D$2)/100,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt maximal",null,{"$f":"IF(Barunterhalt!E88>0,E7*(100-$D$3)/100,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((Barunterhalt!A88-(SUM(Barunterhalt!A105:'Barunterhalt'!A106)))>0,IF(Barunterhalt!A88-(SUM(Barunterhalt!A105:'Barunterhalt'!A106))>A8,A8,Barunterhalt!A88-(SUM(Barunterhalt!A105:'Barunterhalt'!A106))),0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt effektiv",null,{"$f":"IF((Barunterhalt!E88-(SUM(Barunterhalt!E105:'Barunterhalt'!E106)))>0,IF(Barunterhalt!E88-(SUM(Barunterhalt!E105:'Barunterhalt'!E106))>E8,E8,Barunterhalt!E88-(SUM(Barunterhalt!E105:'Barunterhalt'!E106))),0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Erwerbskapazität trotz Betreuung Kind 1 in %"]
[null,null,"Erwerbskapazität trotz Betreuung Kind 2 in %"]
[]
[{"$f":"100-A12","v":100},null,"Erwerbsausfall infolge Betreuung Kind 1 in %",null,{"$f":"100-E12","v":100}]
[{"$f":"100-A13","v":100},null,"Erwerbsausfall infolge Betreuung Kind 2 in %",null,{"$f":"100-E13","v":100}]
[]
[{"$f":"IF(SUM(A$15:A$16)>0,A$8/SUM(A$15:A$16)*A15,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt Kind 1 maximal",null,{"$f":"IF(SUM(E$15:E$16)>0,E$8/SUM(E$15:E$16)*E15,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(A$15:A$16)>0,A$8/SUM(A$15:A$16)*A16,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt Kind 2 maximal",null,{"$f":"IF(SUM(E$15:E$16)>0,E$8/SUM(E$15:E$16)*E16,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(A$15:A$16)>0,A$9/SUM(A$15:A$16)*A15,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt Kind 1 effektiv",null,{"$f":"IF(SUM(E$15:E$16)>0,E$9/SUM(E$15:E$16)*E15,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(A$15:A$16)>0,A$9/SUM(A$15:A$16)*A16,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt Kind 2 effektiv",null,{"$f":"IF(SUM(E$15:E$16)>0,E$9/SUM(E$15:E$16)*E16,0)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Nachehelicher Unterhalt","index":5,"n_rows":14,"n_cols":5,"rows_kept":14}
[]
["EHEFRAU",{"$nulls":3},"EHEMANN"]
[]
[{"$f":"Barunterhalt!A79","v":{"v":0,"d":"0.00"}},null,"Existenzminimum exkl. Überschussanteil",null,{"$f":"Barunterhalt!E79","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!A16","v":{"v":0,"d":"0.00"}},null,"Eigene Einnahmen",null,{"$f":"Barunterhalt!E16","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Barunterhalt!E8:'Barunterhalt'!E15)","v":{"v":0,"d":"0.00"}},null,"Kinderzulagen u.Ä. von Unterhaltsschuldner",null,{"$f":"SUM(Barunterhalt!A8:'Barunterhalt'!A15)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Barunterhalt!A105:'Barunterhalt'!A106)","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"SUM(Barunterhalt!E105:'Barunterhalt'!E106)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Betreuungsunterhalt!A21:'Betreuungsunterhalt'!A22)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt total",null,{"$f":"SUM(Betreuungsunterhalt!E21:'Betreuungsunterhalt'!E22)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"Barunterhalt!A88","v":{"v":0,"d":"0.00"}},null,"Unterhaltsanspruch Maximal",null,{"$f":"Barunterhalt!E88","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(A5:A8)<A4,A4-SUM(A5:A8),0)","v":{"v":0,"d":"0.00"}},null,"Nachehelicher Unterhalt  maximal exkl. Überschussanteil",null,{"$f":"IF(SUM(E5:E8)<E4,E4-SUM(E5:E8),0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((A10-A7-A8)>A11,A11,A10-A7-A8)","v":{"v":0,"d":"0.00"}},null,"Nachehelicher Unterhalt exkl. Überschussanteil",null,{"$f":"IF((E10-E7-E8)>E11,E11,E10-E7-E8)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"A12+Überschussverteilung!A13","v":{"v":0,"d":"0.00"}},null,"Nachehelicher Unterhalt inkl. Überschussanteil",null,{"$f":"E12+Überschussverteilung!E13","v":{"v":0,"d":"0.00"}}]

{"sheet":"Überschussverteilung","index":6,"n_rows":29,"n_cols":5,"rows_kept":29}
[]
[null,null,"Bei verheirateten Paaren"]
[]
["EHEFRAU",{"$nulls":3},"EHEMANN"]
[]
[{"$f":"Barunterhalt!A88","v":{"v":0,"d":"0.00"}},null,"Unterhalt maximal",null,{"$f":"Barunterhalt!E88","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Barunterhalt!A105:'Barunterhalt'!A106)","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"SUM(Barunterhalt!E105:'Barunterhalt'!E106)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Betreuungsunterhalt!A21:'Betreuungsunterhalt'!A22)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt",null,{"$f":"SUM(Betreuungsunterhalt!E21:'Betreuungsunterhalt'!E22)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Nachehelicher Unterhalt'!A12","v":{"v":0,"d":"0.00"}},null,"Nachehelicher Unterhalt exkl. Überschussanteil",null,{"$f":"'Nachehelicher Unterhalt'!E12","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"A6-SUM(A7:A9)","v":{"v":0,"d":"0.00"}},null,"Zu verteilender Überschuss",null,{"$f":"E6-SUM(E7:E9)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(Barunterhalt!A27:'Barunterhalt'!A28)>0,A$11/2,A$11)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Unterhaltsgläubiger",null,{"$f":"IF(SUM(Barunterhalt!E27:'Barunterhalt'!E28)>0,E$11/2,E$11)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(Barunterhalt!A27:'Barunterhalt'!A28)>0,A$11/2/2,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 1",null,{"$f":"IF(SUM(Barunterhalt!E27:'Barunterhalt'!E28)>0,E$11/2/2,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(Barunterhalt!A27:'Barunterhalt'!A28)>0,A$11/2/2,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 2",null,{"$f":"IF(SUM(Barunterhalt!E27:'Barunterhalt'!E28)>0,E$11/2/2,0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Bei unverheirateten Paaren"]
[]
["MUTTER",{"$nulls":3},"VATER"]
[]
[{"$f":"Barunterhalt!A88","v":{"v":0,"d":"0.00"}},null,"Unterhalt maximal",null,{"$f":"Barunterhalt!E88","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Barunterhalt!A105:'Barunterhalt'!A106)","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"SUM(Barunterhalt!E105:'Barunterhalt'!E106)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(Betreuungsunterhalt!A21:'Betreuungsunterhalt'!A22)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt",null,{"$f":"SUM(Betreuungsunterhalt!E21:'Betreuungsunterhalt'!E22)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"A22-SUM(A23:A24)","v":{"v":0,"d":"0.00"}},null,"Zu verteilender Überschuss",null,{"$f":"E22-SUM(E23:E24)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(Barunterhalt!A27:'Barunterhalt'!A28)>0,A$26/2,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 1",null,{"$f":"IF(SUM(Barunterhalt!E27:'Barunterhalt'!E28)>0,E$26/2,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(SUM(Barunterhalt!A27:'Barunterhalt'!A28)>0,A$26/2,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind 2",null,{"$f":"IF(SUM(Barunterhalt!E27:'Barunterhalt'!E28)>0,E$26/2,0)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Zusammenfassung","index":7,"n_rows":39,"n_cols":4,"rows_kept":39}
[]
[null,null,"Bei verheirateten Paaren"]
[]
[null,"MUTTER",null,"VATER"]
[]
[null,{"$f":"Barunterhalt!A102+Überschussverteilung!A14","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt Kind 1 inkl. Überschuss",{"$f":"Barunterhalt!E102+Überschussverteilung!E14","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Barunterhalt!A103+Überschussverteilung!A15","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt Kind 2 inkl. Überschuss",{"$f":"Barunterhalt!E103+Überschussverteilung!E15","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Barunterhalt!A105+Überschussverteilung!A14","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt Kind 1 inkl. Überschuss",{"$f":"Barunterhalt!E105+Überschussverteilung!E14","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Barunterhalt!A106+Überschussverteilung!A15","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt Kind 2 inkl. Überschuss",{"$f":"Barunterhalt!E106+Überschussverteilung!E15","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt Kind 1",{"$f":"Betreuungsunterhalt!E18","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Betreuungsunterhalt!A19","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt Kind 2",{"$f":"Betreuungsunterhalt!E19","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A21","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt Kind 1",{"$f":"Betreuungsunterhalt!E21","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Betreuungsunterhalt!A22","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt Kind 2",{"$f":"Betreuungsunterhalt!E22","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"'Nachehelicher Unterhalt'!A14","v":{"v":0,"d":"0.00"}},"Nachehelicher Unterhalt",{"$f":"'Nachehelicher Unterhalt'!E14","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Barunterhalt!A88>0,IF((SUM(B6:B7,B12:B13,B18)+Barunterhalt!A16+SUM(Barunterhalt!E8:'Barunterhalt'!E15))<Barunterhalt!A79,Barunterhalt!A79-SUM(B6:B7,B12:B13,B18)-Barunterhalt!A16-SUM(Barunterhalt!E8:'Barunterhalt'!E15),0),0)","v":{"v":0,"d":"0.00"}},"Manko",{"$f":"IF(Barunterhalt!E88>0,IF((SUM(D6:D7,D12:D13,D18)+Barunterhalt!E16+SUM(Barunterhalt!A8:'Barunterhalt'!A15))<Barunterhalt!E79,Barunterhalt!E79-SUM(D6:D7,D12:D13,D18)-Barunterhalt!E16-SUM(Barunterhalt!A8:'Barunterhalt'!A15),0),0)","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"SUM(B9:B10)+SUM(B15:B16)+B18","v":{"v":0,"d":"0.00"}},"Total Anspruch Unterhaltsbeiträge",{"$f":"SUM(D9:D10)+SUM(D15:D16)+D18","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,null,"Bei nicht verheirateten Paaren"]
[]
[null,{"$f":"Barunterhalt!A102+Überschussverteilung!A28","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt Kind 1 inkl. Überschuss",{"$f":"Barunterhalt!E102+Überschussverteilung!E28","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Barunterhalt!A103+Überschussverteilung!A29","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt Kind 2 inkl. Überschuss",{"$f":"Barunterhalt!E103+Überschussverteilung!E29","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Barunterhalt!A105+Überschussverteilung!A28","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt Kind 1 inkl. Überschuss",{"$f":"Barunterhalt!E105+Überschussverteilung!E28","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Barunterhalt!A106+Überschussverteilung!A29","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt Kind 2 inkl. Überschuss",{"$f":"Barunterhalt!E106+Überschussverteilung!E29","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt Kind 1",{"$f":"Betreuungsunterhalt!E18","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Betreuungsunterhalt!A19","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt Kind 2",{"$f":"Betreuungsunterhalt!E19","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A21","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt Kind 1",{"$f":"Betreuungsunterhalt!E21","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"Betreuungsunterhalt!A22","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt Kind 2",{"$f":"Betreuungsunterhalt!E22","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"SUM(B30:B31)+SUM(B36:B37)","v":{"v":0,"d":"0.00"}},"Total Anspruch Unterhaltsbeiträge",{"$f":"SUM(D30:D31)+SUM(D36:D37)","v":{"v":0,"d":"0.00"}}]