{"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":14,"n_cols":5,"rows_kept":14}
[]
["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","v":{"v":0,"d":"0.00"}},null,"Kind",null,{"$f":"E$10/3","v":{"v":0,"d":"0.00"}}]

{"sheet":"Krankenkasse","index":2,"n_rows":10,"n_cols":5,"rows_kept":10}
[]
["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"}}]

{"sheet":"Barunterhalt","index":3,"n_rows":86,"n_cols":6,"rows_kept":86}
[]
["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"]
[]
[null,null,"Erwerbseinkommen Kind "]
[]
[null,null,"Weitere Einnahmen Kind "]
[{"$f":"SUM(A3:A12)","v":{"v":0,"d":"0.00"}},null,"Total Einnahmen",null,{"$f":"SUM(E3:E12)","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 "]
[]
[{"$f":"A23*0.2","v":{"v":0,"d":"0.00"}},null,"Zivilprozessualer Zuschlag",null,{"$f":"E23*0.2","v":{"v":0,"d":"0.00"}}]
[{"$f":"A24*0.2","v":{"v":0,"d":"0.00"}},null,"Zuschlag Kind",null,{"$f":"E24*0.2","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(A30:A30)=0,Wohnkosten!A10,Wohnkosten!A10-SUM(A30:A30))","v":{"v":0,"d":"0.00"}},null,"Wohnkosten",null,{"$f":"IF(SUM(E30:E30)=0,Wohnkosten!E10,Wohnkosten!E10-SUM(E30:E30))","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A24>0,Wohnkosten!A14,0)","v":{"v":0,"d":"0.00"}},null,"Wohnkostenanteil Kind",null,{"$f":"IF(E24>0,Wohnkosten!E14,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 ",null,{"$f":"Krankenkasse!E10","v":{"v":0,"d":"0.00"}}]
[null,null,"Krankenkasse VVG"]
[null,null,"Krankenkasse VVG Kind "]
[null,null,"Behandlungskosten"]
[null,null,"Behandlungskosten Kind "]
[]
[null,null,"Mobilitätskosten"]
[null,null,"Mobilitätskosten Kind "]
[]
[null,null,"Berufsauslagen Kleider"]
[null,null,"Berufsauslagen Nahrung"]
[]
[null,null,"Weiterbildungskosten"]
[null,null,"Ausbildung Kind "]
[]
[null,null,"Drittbetreuung Kind"]
[]
[null,null,"Schuldamortisation"]
[]
[null,null,"Hobbies"]
[null,null,"Hobbies Kind "]
[]
[null,null,"Rechtlich geschuldete Unterhaltsbeiträge"]
[null,null,"Steuern"]
[null,null,"Vorsorgeaufbau (1. & 2. Säule)"]
[]
[null,null,"Divers"]
[null,null,"Divers Kind "]
[]
[{"$f":"SUM(A23:A63)","v":{"v":0,"d":"0.00"}},null,"Existenzminimum 1",null,{"$f":"SUM(E23:E63)","v":{"v":0,"d":"0.00"}}]
[null,null,"Gesamteinkommen",null,null,{"$f":"SUM(A13,E13)","v":{"v":0,"d":"0.00"}}]
[null,null,"Gesamtexistenzminimum",null,null,{"$f":"SUM(A65,E65)","v":{"v":0,"d":"0.00"}}]
[null,null,"Überschuss",null,null,{"$f":"IF(F66>F67,F66-F67,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"Manko",null,null,{"$f":"IF(F66<F67,F66-F67,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"$F$68/3","v":{"v":0,"d":"0.00"}},null,"Überschussanteil ",null,{"$f":"$F$68/3","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(A24>0,$F$68/3/SUM(A24,E24)*A24,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind",null,{"$f":"IF(E24>0,$F$68/3/SUM(A24,E24)*E24,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"SUM(A65,A70:A71)","v":{"v":0,"d":"0.00"}},null,"Existenzminimum 2",null,{"$f":"SUM(E65,E70:E71)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((A13+(E13-E72))<A65,IF(SUM(E3:E6)>E65,SUM(E3:E6)-E65,0),IF(SUM(E3:E6)>E72,SUM(E3:E6)-E72,0))","v":{"v":0,"d":"0.00"}},null,"Unterhaltsanspruch maximal (zzgl. Zulagen)",null,{"$f":"IF((E13+(A13-A72))<E65,IF(SUM(A3:A6)>A65,SUM(A3:A6)-A65,0),IF(SUM(A3:A6)>A72,SUM(A3:A6)-A72,0))","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"SUM(A23,A26,A29,A32,A33,A35,A37,A39,A42,A45,A46,A48,A53,A55,A58,A59,A60,A62)","v":{"v":0,"d":"0.00"}},null,"Barbedarf Eltern",null,{"$f":"SUM(E23,E26,E29,E32,E33,E35,E37,E39,E42,E45,E46,E48,E53,E55,E58,E59,E60,E62)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A24+A27+A30+A36+A38+A40+A43+A49+A51+A56+A63","v":{"v":0,"d":"0.00"}},null,"Barbedarf Kind ",null,{"$f":"E24+E27+E30+E36+E38+E40+E43+E49+E51+E56+E63","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF((A76-A8-A10-A12-E8-E10-E12)>0,A76-A8-A10-A12-E8-E10-E12,0)","v":{"v":0,"d":"0.00"}},null,"Barbedarf nach Abzug Einnahmen Kind",null,{"$f":"IF((E76-E8-E10-E12-A8-A10-A12)>0,E76-E8-E10-E12-A8-A10-A12,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(SUM(A3:A6)>A75,SUM(A3:A6)-A75,0)","v":{"v":0,"d":"0.00"}},null,"Leistungsfähigkeit Eltern",null,{"$f":"IF(SUM(E3:E6)>E75,SUM(E3:E6)-E75,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(A24>0,IF(A$80>0,A$80/SUM(A$78:A$78)*A78,0),0)","v":{"v":0,"d":"0.00"}},null,"Beitrag betreuender Elternteil Kind",null,{"$f":"IF(E24>0,IF(E$80>0,E$80/SUM(E$78:E$78)*E78,0),0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(A$73>0,IF((A78-A82)>0,A78-A82,0),0)","v":{"v":0,"d":"0.00"}},null,"Anspruch Barunterhalt maximal  (zzgl. Zulagen)",null,{"$f":"IF(E$73>0,IF((E78-E82)>0,E78-E82,0),0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(($E$80/(IF(SUM(A$84:A$84)>0,SUM(A$84:A$84),1))*A84)>A84,A84,$E$80/(IF(SUM(A$84:A$84)>0,SUM(A$84:A$84),1))*A84)","v":{"v":0,"d":"0.00"}},null,"Anspruch Barunterhalt Kind  (zzgl. Zulagen)",null,{"$f":"IF(($A$80/(IF(SUM(E$84:E$84)>0,SUM(E$84:E$84),1))*E84)>E84,E84,$A$80/(IF(SUM(E$84:E$84)>0,SUM(E$84:E$84),1))*E84)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Betreuungsunterhalt","index":4,"n_rows":18,"n_cols":5,"rows_kept":18}
[]
["Zumutbare Erwerbstätigkeit Mutter in %:",null,null,{"$f":"MIN(A12:A12)","v":0}]
["Zumutbare Erwerbstätigkeit Vater in %:",null,null,{"$f":"MIN(E12:E12)","v":0}]
[]
["MUTTER",{"$nulls":3},"VATER"]
[]
[{"$f":"SUM(Barunterhalt!A23,Barunterhalt!A26,Barunterhalt!A29,Barunterhalt!A35,Barunterhalt!A42,Barunterhalt!A45,Barunterhalt!A46,Barunterhalt!A59)","v":{"v":0,"d":"0.00"}},null,"Betreuungskosten",null,{"$f":"SUM(Barunterhalt!E23,Barunterhalt!E26,Barunterhalt!E29,Barunterhalt!E35,Barunterhalt!E42,Barunterhalt!E45,Barunterhalt!E46,Barunterhalt!E59)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(Barunterhalt!A73>0,A7*(100-$D$2)/100,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt maximal",null,{"$f":"IF(Barunterhalt!E73>0,E7*(100-$D$3)/100,0)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF((Barunterhalt!A73-(SUM(Barunterhalt!A86:'Barunterhalt'!A86)))>0,IF(Barunterhalt!A73-(SUM(Barunterhalt!A86:'Barunterhalt'!A86))>A8,A8,Barunterhalt!A73-(SUM(Barunterhalt!A86:'Barunterhalt'!A86))),0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt effektiv",null,{"$f":"IF((Barunterhalt!E73-(SUM(Barunterhalt!E86:'Barunterhalt'!E86)))>0,IF(Barunterhalt!E73-(SUM(Barunterhalt!E86:'Barunterhalt'!E86))>E8,E8,Barunterhalt!E73-(SUM(Barunterhalt!E86:'Barunterhalt'!E86))),0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Erwerbskapazität trotz Betreuung Kind  in %"]
[]
[{"$f":"100-A12","v":100},null,"Erwerbsausfall infolge Betreuung Kind in %",null,{"$f":"100-E12","v":100}]
[]
[{"$f":"IF(A$14>0,A$8/SUM(A$14:A$14)*A14,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt maximal",null,{"$f":"IF(E$14>0,E$8/SUM(E$14:E$14)*E14,0)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(A$14>0,A$9,0)","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt effektiv",null,{"$f":"IF(E$14>0,E$9,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!A65","v":{"v":0,"d":"0.00"}},null,"Existenzminimum exkl. Überschussanteil",null,{"$f":"Barunterhalt!E65","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!A13","v":{"v":0,"d":"0.00"}},null,"Eigene Einnahmen",null,{"$f":"Barunterhalt!E13","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!E8","v":{"v":0,"d":"0.00"}},null,"Kinderzulagen u.Ä. von Unterhaltsschuldner",null,{"$f":"Barunterhalt!A8","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!A86","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"Barunterhalt!E86","v":{"v":0,"d":"0.00"}}]
[{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt total",null,{"$f":"Betreuungsunterhalt!E18","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"Barunterhalt!A73","v":{"v":0,"d":"0.00"}},null,"Unterhaltsanspruch Maximal",null,{"$f":"Barunterhalt!E73","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":27,"n_cols":5,"rows_kept":27}
[]
[null,null,"Bei verheirateten Paaren"]
[]
["EHEFRAU",{"$nulls":3},"EHEMANN"]
[]
[{"$f":"Barunterhalt!A73","v":{"v":0,"d":"0.00"}},null,"Unterhalt maximal",null,{"$f":"Barunterhalt!E73","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!A86","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"Barunterhalt!E86","v":{"v":0,"d":"0.00"}}]
[{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt",null,{"$f":"Betreuungsunterhalt!E18","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(Barunterhalt!A24>0,A$11/2,A$11)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Unterhaltsgläubiger",null,{"$f":"IF(Barunterhalt!E24>0,E$11/2,E$11)","v":{"v":0,"d":"0.00"}}]
[{"$f":"IF(Barunterhalt!A24>0,A$11/2,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind ",null,{"$f":"IF(Barunterhalt!E24>0,E$11/2,0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Bei unverheirateten Paaren"]
[]
["MUTTER",{"$nulls":3},"VATER"]
[]
[{"$f":"Barunterhalt!A73","v":{"v":0,"d":"0.00"}},null,"Unterhalt maximal",null,{"$f":"Barunterhalt!E73","v":{"v":0,"d":"0.00"}}]
[{"$f":"Barunterhalt!A86","v":{"v":0,"d":"0.00"}},null,"Barunterhalt exkl. Überschussanteil",null,{"$f":"Barunterhalt!E86","v":{"v":0,"d":"0.00"}}]
[{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},null,"Betreuungsunterhalt",null,{"$f":"Betreuungsunterhalt!E18","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"A21-SUM(A22:A23)","v":{"v":0,"d":"0.00"}},null,"Zu verteilender Überschuss",null,{"$f":"E21-SUM(E22:E23)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"IF(Barunterhalt!A24>0,A$25,0)","v":{"v":0,"d":"0.00"}},null,"Überschussanteil Kind ",null,{"$f":"IF(Barunterhalt!E24>0,E$25,0)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Zusammenfassung","index":7,"n_rows":31,"n_cols":4,"rows_kept":31}
[]
[null,null,"Bei verheirateten Paaren"]
[]
[null,"MUTTER",null,"VATER"]
[]
[null,{"$f":"Barunterhalt!A84+Überschussverteilung!A14","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt  inkl. Überschuss",{"$f":"Barunterhalt!E84+Überschussverteilung!E14","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Barunterhalt!A86+Überschussverteilung!A14","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt  inkl. Überschuss",{"$f":"Barunterhalt!E86+Überschussverteilung!E14","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A16","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt",{"$f":"Betreuungsunterhalt!E16","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt ",{"$f":"Betreuungsunterhalt!E18","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!A73>0,IF((SUM(B6,B10,B14)+Barunterhalt!A13+SUM(Barunterhalt!E8:'Barunterhalt'!E12))<Barunterhalt!A65,Barunterhalt!A65-SUM(B6,B10,B14)-Barunterhalt!A13-SUM(Barunterhalt!E8:'Barunterhalt'!E12),0),0)","v":{"v":0,"d":"0.00"}},"Manko",{"$f":"IF(Barunterhalt!E73>0,IF((SUM(D6,D10,D14)+Barunterhalt!E13+SUM(Barunterhalt!A8:'Barunterhalt'!A12))<Barunterhalt!E65,Barunterhalt!E65-SUM(D6,D10,D14)-Barunterhalt!E13-SUM(Barunterhalt!A8:'Barunterhalt'!A12),0),0)","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"SUM(B8:B8)+SUM(B12:B12)+B14","v":{"v":0,"d":"0.00"}},"Total Anspruch Unterhaltsbeiträge",{"$f":"SUM(D8:D8)+SUM(D12:D12)+D14","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,null,"Bei nicht verheirateten Paaren"]
[]
[null,{"$f":"Barunterhalt!A84+Überschussverteilung!A27","v":{"v":0,"d":"0.00"}},"Maximal Barunterhalt inkl. Überschuss",{"$f":"Barunterhalt!E84+Überschussverteilung!E27","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Barunterhalt!A86+Überschussverteilung!A27","v":{"v":0,"d":"0.00"}},"Anspruch Barunterhalt inkl. Überschuss",{"$f":"Barunterhalt!E86+Überschussverteilung!E27","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A16","v":{"v":0,"d":"0.00"}},"Maximal Betreuungsunterhalt ",{"$f":"Betreuungsunterhalt!E16","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"Betreuungsunterhalt!A18","v":{"v":0,"d":"0.00"}},"Anspruch Betreuungsunterhalt ",{"$f":"Betreuungsunterhalt!E18","v":{"v":0,"d":"0.00"}}]
[]
[null,{"$f":"SUM(B25:B25)+SUM(B29:B29)","v":{"v":0,"d":"0.00"}},"Total Anspruch Unterhaltsbeiträge",{"$f":"SUM(D25:D25)+SUM(D29:D29)","v":{"v":0,"d":"0.00"}}]