{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["A-D","E-F","G","H","I-J","Auswertung","115 IV","Freibeträge"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":0,"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":"A-D","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,6,1,8],[5,6,5,8],[6,6,6,8],[8,8,9,8],[18,6,18,7],[18,0,18,5],[6,0,6,5],[5,0,5,5],[8,1,8,5],[8,6,9,6],[8,7,9,7]]}
["A","Angaben zur Person und zum Rechtsstreit"]
[null,"Erwerbstätig",null,"(Ja/Nein)",null,"Streitwert (in EUR)"]
[null,"Aktenzeichen",null,"(bitte angeben)"]
[null,"Entscheidungsdatum",null,"(Datum)"]
[]
["Freibetrag der Partei",null,null,null,null,null,{"$f":"Freibeträge!$B$2","v":492}]
["Freibetrag wegen Erwerbstätigkeit",null,null,null,null,null,{"$f":"IF(C2=\"Ja\",Freibeträge!B8,\"\")","v":""}]
[]
["D","Angehörige, denen Sie Bar- oder Naturalunterhalt gewähren",null,null,null,null,"Lebensalter","Freibetrag","Anzahl(üUB)"]
[null,"Name, Vorname","Geburts-datum","Verhältnis (Ehegatte (E), Kind (K), Sonstige (S))","Monatsbetrag in EUR, soweit Sie den Unterhalt nur durch Zahlung gewähren","Eigene Einnahmen des/der Berechtigten?"]
[1,null,null,null,null,null,{"$f":"Lebensalter(C11)","v":""},{"$f":"Freibetrag1(B11,C11,D11,E11,F11,G11)","v":""},{"$f":"IF(H11>F11,1,0)","v":0}]
[2,null,null,null,null,null,{"$f":"Lebensalter(C12)","v":""},{"$f":"Freibetrag1(B12,C12,D12,E12,F12,G12)","v":""},{"$f":"IF(H12>F12,1,0)","v":0}]
[3,null,null,null,null,null,"","",0]
[4,null,null,null,null,null,"","",0]
[5,null,null,null,null,null,"","",0]
[6,null,null,null,null,null,"","",0]
[7,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,{"$f":"IF(AND(C18<>\"\",D18<>\"\"),Freibetrag(D18,G18),\"\")","v":""}]
["Summe Unterhaltsfreibeträge",null,null,null,null,null,{"$f":"SUM(H11:H17)","v":0},null,{"$f":"SUM(I11:I17)","v":0}]

{"sheet":"E-F","index":1,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,7],[17,0,17,5],[17,6,17,7],[29,0,29,3],[42,0,42,5],[42,6,42,7],[1,0,1,3],[12,0,12,3],[19,1,19,7],[24,0,24,3],[39,0,39,3],[41,1,41,7]]}
["E","Bruttoeinnahmen"]
["monatliche Einkünfte","monatliche Einkünfte"]
[null,"Bruttoarbeitslohn",null,"(Betrag in €)"]
[null,"sonstige Erwerbseinkünfte",null,"(Betrag in €)"]
[null,"ALG I",null,"(Betrag in €)"]
[null,"ALG II",null,"(Betrag in €)"]
[null,"Renten",null,"(Betrag in €)"]
[null,"Vermietung/Verpachtung",null,"(Betrag in €)"]
[null,"Wohngeld",null,"(Betrag in €)"]
[null,"Kindergeld",null,"(Betrag in €)"]
[null,"Unterhalt",null,"(Betrag in €)"]
[null,"sonstige Einkünfte",null,"(Betrag in €)"]
["einmalige Einkünfte"]
[null,"Urlaubsgeld (1/12)",null,"(Betrag in €)",{"$f":"IF( C14<> \"\",C14/12,\"\")","v":""}]
[null,"Weihnachtsgeld (1/12)",null,"(Betrag in €)",{"$f":"IF( C15<> \"\",C15/12,\"\")","v":""},null,{"$f":"IF(C15=\"\",\"\",ROW())","v":""}]
[null,"Sonstige Einmaleinkünfte (1/12)",null,"(Betrag in €)",{"$f":"IF( C16<> \"\",C16/12,\"\")","v":""},null,{"$f":"IF(C16=\"\",\"\",ROW())","v":""}]
[]
["Summe Bruttoeinnahmen",null,null,null,null,null,{"$f":"IF(SUM(C3:C12)+SUM(E14:E16)>0,SUM(C3:C12)+SUM(E14:E16),\"\")","v":""}]
[]
["F","Abzüge von den Bruttoeinnahmen"]
[null,"Einkommenssteuer/Lohnsteuer",null,"(Betrag in €)"]
[null,"Kirchensteuer",null,"(Betrag in €)"]
[null,"Solidaritätsbeitrag",null,"(Betrag in €)"]
[null,"Gewerbesteuer",null,"(Betrag in €)"]
["Summe Steuern","Summe Steuern",null,null,{"$f":"IF(SUM(C21:C24)>0,SUM(C21:C24),\"\")","v":""}]
[null,"Krankenversicherung",null,"(Betrag in €)"]
[null,"Pflegeversicherung",null,"(Betrag in €)"]
[null,"Rentenversicherung",null,"(Betrag in €)"]
[null,"Arbeitslosenversicherung",null,"(Betrag in €)"]
["Summe Sozialversicherungsbeträge","Summe Sozialversicherungsbeiträge",null,null,{"$f":"IF(SUM(C26:C29)>0,SUM(C26:C29),\"\")","v":""}]
[null,"Gewerkschaftsbeiträge",null,"(Betrag in €)"]
[null,"Kfz-Haftpflichtversicherung",null,"(Betrag in €)"]
[null,"Hausrat- /Haftpflichtversicherung",null,"(Betrag in €)"]
[null,"Lebensversicherung",null,"(Betrag in €)"]
[null,"sonstige angemessene Versicherungen",null,"(Betrag in €)"]
[null,"Fahrt zur Arbeit",null,"(km einfach)",{"$f":"IF(C36<>\"\",5.2*C36,\"\")","v":""}]
[null,"sonstige Werbungskosten",null,"(Betrag in €)"]
[null,"geförderte Altersvorsorge",null,"(Betrag in €)"]
[null,"Sonstige Abzüge",null,"(Betrag in €)"]
["Summe weitere Abzüge","Summe Sozialversicherungsbeiträge",null,null,{"$f":"IF(SUM(C31:C35)+SUM(C37:C39)+SUM(E36)>0,(SUM(C31:C35)+SUM(C37:C39)+SUM(E36)),\"\")","v":""}]
[]
[null,"Nettoeinkommen"]
["Summe Nettoeinnahmen",null,null,null,null,null,{"$f":"SUM(G18)-SUM(E25:E40)","v":0}]

{"sheet":"G","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,0,20,1],[0,1,0,7],[8,0,8,1],[10,1,10,7],[14,0,14,1],[16,1,16,7]]}
["G","Vermögenswerte"]
[null,"Bank-, Giro, Sparkonten",null,"(Summe Kontostände in €)"]
[null,"Grundeigentum",null,"(Verkehrswert in €)"]
[null,"Kraftfahrzeuge",null,"(Verkehrswert in €)"]
[null,"Bargeld/Wertgegenstände",null,"(Verkehrswert in €)"]
[null,"Lebens-/Rentenversicherung",null,"(Rückkaufwert in €)"]
[null,"sonstige Vermögenswerte",null,"(Verkehrswert in €)"]
[]
["Summe Vermögenswerte",null,{"$f":"SUM(SUM(C2:C7))","v":0}]
[]
[null,"Schonvermögen"]
[null,"Grundbetrag für die Partei",5000,"(Fixbetrag)"]
[null,"Erhöhungsbetrag für Unterhaltsberechtigte",{"$f":"500*'A-D'!I19","v":0},"(500,00 € pro Person)"]
[]
["Summe Schonvermögen",null,{"$f":"SUM(C12:C13)","v":5000}]
[]
[null,"Vermögenseinsatz"]
[null,"Vermögenswerte",{"$f":"C9","v":0}]
[null,"Schonvermögen",{"$f":"C15","v":5000}]
[]
["einzusetzendes Vermögen",null,{"$f":"IF(C18>C19,C18-C19,0)","v":0}]

{"sheet":"H","index":3,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,17,5],[16,1,16,7],[17,6,17,7],[0,1,0,7],[1,0,1,3],[5,0,5,3],[10,0,10,5],[10,6,10,7],[12,1,12,7]]}
["H","Wohnkosten"]
["Mieter oder ähnliches Nutzungsverhältnis","monatliche Einkünfte"]
[null,"Miete",null,"(Betrag in €)"]
[null,"Heizkosten",null,"(Betrag in €)"]
[null,"übrige Nebenkosten",null,"(Betrag in €)"]
["Eigentümer, Miteigentümer oder Erbbauberechtigter"]
[null,"Zinsen und Tilgung",null,"(Betrag in €)",{"$f":"IF( C7<> \"\",C7/12,\"\")","v":""}]
[null,"Heizkosten",null,"(Betrag in €)",{"$f":"IF( C8<> \"\",C8/12,\"\")","v":""},null,{"$f":"IF(C8=\"\",\"\",ROW())","v":""}]
[null,"übrige Nebenkosten",null,"(Betrag in €)",{"$f":"IF( C9<> \"\",C9/12,\"\")","v":""},null,{"$f":"IF(C9=\"\",\"\",ROW())","v":""}]
[]
["Summe Wohnkosten",null,null,null,null,null,{"$f":"IF(SUM(C3:C5)+SUM(C7:C9)>0,SUM(C3:C5)+SUM(C7:C9),\"\")","v":""}]
[]
[null,"Aufteilung der Wohnkosten"]
[null,"Zahl der weiteren Mitbewohner",null,"(Kopfzahl)",null,null,null,{"$f":"IF(G11<>\"\",G11/(1+C14),\"\")","v":""}]
[null,"Nettoeinkommen der Mitbewohner",null,"(Betrag in €)",null,null,null,{"$f":"IF(C15<>\"\",G11/('E-F'!G43+C15)*'E-F'!G43,\"\")","v":""}]
[]
[null,"Anteilige Wohnkosten"]
["anrechenbare Wohnkosten",null,null,null,null,null,{"$f":"IF(C15<>\"\",H15,H14)","v":""}]

{"sheet":"I-J","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,5],[14,6,14,7],[0,1,0,7],[6,1,6,7],[4,0,4,5],[4,6,4,7]]}
["I","Mehrbedarfe"]
[null,"nach § 21 SGB II",null,"(Betrag in €)"]
[null,"nach § 30 SGB XII",null,"(Betrag in €)"]
[]
["Summe Mehrbedarfe",null,null,null,null,null,{"$f":"SUM(SUM(C2:C3))","v":0}]
[]
["J","Besondere Belastungen"]
[null,"Abzahlungsverpflichtungen",null,"(Betrag in €)"]
[null,"Kreditraten",null,"(Betrag in €)"]
[null,"PKH-Kosten",null,"(Betrag in €)"]
[null,"Fortbildungskosten",null,"(Betrag in €)"]
[null,"Sonstiges (Anwaltskosten, Fortbildung etc.)",null,"(Betrag in €)"]
[null,"Aufwendungen wegen körperlicher Gebrechen",null,"(Betrag in €)"]
[]
["Summe besondere Belastungen",null,null,null,null,null,{"$f":"SUM(SUM(C8:C13))","v":0}]

{"sheet":"Auswertung","index":5,"n_rows":71,"n_cols":4,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Aktenzeichen:",null,{"$f":"IF(ISBLANK('A-D'!$C$3),\"[keine Angabe]\",'A-D'!$C$3)","v":"[keine Angabe]"}]
[null,null,"Betrag","Summen"]
["Einkünfte",null,"[Leer]"]
[null,{"$f":"'E-F'!B3","v":"Bruttoarbeitslohn"},{"$f":"IF(ISBLANK('E-F'!$C3),\"\",'E-F'!C3)","v":""}]
[null,{"$f":"'E-F'!B4","v":"sonstige Erwerbseinkünfte"},{"$f":"IF(ISBLANK('E-F'!$C4),\"\",'E-F'!C4)","v":""}]
[null,{"$f":"'E-F'!B5","v":"ALG I"},{"$f":"IF(ISBLANK('E-F'!$C5),\"\",'E-F'!C5)","v":""}]
[null,{"$f":"'E-F'!B6","v":"ALG II"},{"$f":"IF(ISBLANK('E-F'!$C6),\"\",'E-F'!C6)","v":""}]
[null,{"$f":"'E-F'!B7","v":"Renten"},{"$f":"IF(ISBLANK('E-F'!$C7),\"\",'E-F'!C7)","v":""}]
[null,{"$f":"'E-F'!B8","v":"Vermietung/Verpachtung"},{"$f":"IF(ISBLANK('E-F'!$C8),\"\",'E-F'!C8)","v":""}]
[null,{"$f":"'E-F'!B9","v":"Wohngeld"},{"$f":"IF(ISBLANK('E-F'!$C9),\"\",'E-F'!C9)","v":""}]
[null,{"$f":"'E-F'!B10","v":"Kindergeld"},{"$f":"IF(ISBLANK('E-F'!$C10),\"\",'E-F'!C10)","v":""}]
[null,{"$f":"'E-F'!B11","v":"Unterhalt"},{"$f":"IF(ISBLANK('E-F'!$C11),\"\",'E-F'!C11)","v":""}]
[null,{"$f":"'E-F'!B12","v":"sonstige Einkünfte"},{"$f":"IF(ISBLANK('E-F'!$C12),\"\",'E-F'!C12)","v":""}]
[null,{"$f":"'E-F'!B14","v":"Urlaubsgeld (1/12)"},{"$f":"IF(ISBLANK('E-F'!$C14),\"\",'E-F'!E14)","v":""}]
[null,{"$f":"'E-F'!B15","v":"Weihnachtsgeld (1/12)"},{"$f":"IF(ISBLANK('E-F'!$C15),\"\",'E-F'!E15)","v":""}]
[null,{"$f":"'E-F'!B16","v":"Sonstige Einmaleinkünfte (1/12)"},{"$f":"IF(ISBLANK('E-F'!$C16),\"\",'E-F'!E16)","v":""}]
[null,"Summe der Einkünfte","[Leer]",{"$f":"SUM(C4:C16)","v":0}]
["Abzüge",null,"[Leer]"]
[null,{"$f":"'E-F'!B21","v":"Einkommenssteuer/Lohnsteuer"},{"$f":"IF(ISBLANK('E-F'!$C21),\"\",'E-F'!C21)","v":""}]
[null,{"$f":"'E-F'!B22","v":"Kirchensteuer"},{"$f":"IF(ISBLANK('E-F'!$C22),\"\",'E-F'!C22)","v":""}]
[null,{"$f":"'E-F'!B23","v":"Solidaritätsbeitrag"},{"$f":"IF(ISBLANK('E-F'!$C23),\"\",'E-F'!C23)","v":""}]
[null,{"$f":"'E-F'!B24","v":"Gewerbesteuer"},{"$f":"IF(ISBLANK('E-F'!$C24),\"\",'E-F'!C24)","v":""}]
[null,{"$f":"'E-F'!B26","v":"Krankenversicherung"},{"$f":"IF(ISBLANK('E-F'!$C26),\"\",'E-F'!C26)","v":""}]
[null,{"$f":"'E-F'!B27","v":"Pflegeversicherung"},{"$f":"IF(ISBLANK('E-F'!$C27),\"\",'E-F'!C27)","v":""}]
[null,{"$f":"'E-F'!B28","v":"Rentenversicherung"},{"$f":"IF(ISBLANK('E-F'!$C28),\"\",'E-F'!C28)","v":""}]
[null,{"$f":"'E-F'!B29","v":"Arbeitslosenversicherung"},{"$f":"IF(ISBLANK('E-F'!$C29),\"\",'E-F'!C29)","v":""}]
[null,{"$f":"'E-F'!B31","v":"Gewerkschaftsbeiträge"},{"$f":"IF(ISBLANK('E-F'!$C31),\"\",'E-F'!C31)","v":""}]
[null,{"$f":"'E-F'!B32","v":"Kfz-Haftpflichtversicherung"},{"$f":"IF(ISBLANK('E-F'!$C32),\"\",'E-F'!C32)","v":""}]
[null,{"$f":"'E-F'!B33","v":"Hausrat- /Haftpflichtversicherung"},{"$f":"IF(ISBLANK('E-F'!$C33),\"\",'E-F'!C33)","v":""}]
[null,{"$f":"'E-F'!B34","v":"Lebensversicherung"},{"$f":"IF(ISBLANK('E-F'!$C34),\"\",'E-F'!C34)","v":""}]
[null,{"$f":"'E-F'!B35","v":"sonstige angemessene Versicherungen"},{"$f":"IF(ISBLANK('E-F'!$C35),\"\",'E-F'!C35)","v":""}]
[null,{"$f":"'E-F'!B36","v":"Fahrt zur Arbeit"},{"$f":"IF(ISBLANK('E-F'!$E36),\"\",'E-F'!E36)","v":""}]
[null,{"$f":"'E-F'!B37","v":"sonstige Werbungskosten"},{"$f":"IF(ISBLANK('E-F'!$C37),\"\",'E-F'!C37)","v":""}]
[null,{"$f":"'E-F'!B38","v":"geförderte Altersvorsorge"},{"$f":"IF(ISBLANK('E-F'!$C38),\"\",'E-F'!C38)","v":""}]
[null,{"$f":"'E-F'!B39","v":"Sonstige Abzüge"},{"$f":"IF(ISBLANK('E-F'!$C39),\"\",'E-F'!C39)","v":""}]
[null,"Summe der Abzüge","[Leer]",{"$f":"SUM(C19:C35)","v":0}]
["Freibeträge",null,"[Leer]"]
[null,{"$f":"'A-D'!$A$6","v":"Freibetrag der Partei"},{"$f":"'A-D'!$G$6","v":492}]
[null,{"$f":"'A-D'!$A$7","v":"Freibetrag wegen Erwerbstätigkeit"},{"$f":"IF(ISBLANK('A-D'!$G7),\"\",'A-D'!$G7)","v":""}]
[null,{"$f":"IF('A-D'!H11=\"\",\"N.N.\",'A-D'!B11&\" (\"&'A-D'!G11&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H11),\"\",'A-D'!H11)","v":""}]
[null,{"$f":"IF('A-D'!H12=\"\",\"N.N.\",'A-D'!B12&\" (\"&'A-D'!G12&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H12),\"\",'A-D'!H12)","v":""}]
[null,{"$f":"IF('A-D'!H13=\"\",\"N.N.\",'A-D'!B13&\" (\"&'A-D'!G13&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H13),\"\",'A-D'!H13)","v":""}]
[null,{"$f":"IF('A-D'!H14=\"\",\"N.N.\",'A-D'!B14&\" (\"&'A-D'!G14&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H14),\"\",'A-D'!H14)","v":""}]
[null,{"$f":"IF('A-D'!H15=\"\",\"N.N.\",'A-D'!B15&\" (\"&'A-D'!G15&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H15),\"\",'A-D'!H15)","v":""}]
[null,{"$f":"IF('A-D'!H16=\"\",\"N.N.\",'A-D'!B16&\" (\"&'A-D'!G16&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H16),\"\",'A-D'!H16)","v":""}]
[null,{"$f":"IF('A-D'!H17=\"\",\"N.N.\",'A-D'!B17&\" (\"&'A-D'!G17&\")\")","v":"N.N."},{"$f":"IF(ISBLANK('A-D'!$H17),\"\",'A-D'!H17)","v":""}]
[null,"Summe der Freibeträge","[Leer]",{"$f":"SUM(C38:C46)","v":492}]
["Wohnkosten",null,"[Leer]"]
[null,{"$f":"H!B3","v":"Miete"},{"$f":"IF(ISBLANK(H!C3),\"\",H!C3)","v":""}]
[null,{"$f":"H!B4","v":"Heizkosten"},{"$f":"IF(ISBLANK(H!C4),\"\",H!C4)","v":""}]
[null,{"$f":"H!B5","v":"übrige Nebenkosten"},{"$f":"IF(ISBLANK(H!C5),\"\",H!C5)","v":""}]
[null,{"$f":"H!B7","v":"Zinsen und Tilgung"},{"$f":"IF(ISBLANK(H!C7),\"\",H!C7)","v":""}]
[null,{"$f":"H!B8","v":"Heizkosten"},{"$f":"IF(ISBLANK(H!C8),\"\",H!C8)","v":""}]
[null,{"$f":"H!B9","v":"übrige Nebenkosten"},{"$f":"IF(ISBLANK(H!C9),\"\",H!C9)","v":""}]
[null,"Summe der anrechenbaren Wohnkosten","[Leer]",{"$f":"IF(H!G18<>\"\",H!G18,0)","v":0}]
["Mehrbedarfe",null,"[Leer]"]
[null,{"$f":"'I-J'!B2","v":"nach § 21 SGB II"},{"$f":"IF(ISBLANK('I-J'!C2),\"\",'I-J'!C2)","v":""}]
[null,{"$f":"'I-J'!B3","v":"nach § 30 SGB XII"},{"$f":"IF(ISBLANK('I-J'!C3),\"\",'I-J'!C3)","v":""}]
[null,"Summe der Mehrbedarfe","[Leer]",{"$f":"SUM(C57:C58)","v":0}]
["besondere Belastungen",null,"[Leer]"]
[null,{"$f":"'I-J'!B8","v":"Abzahlungsverpflichtungen"},{"$f":"IF(ISBLANK('I-J'!C8),\"\",'I-J'!C8)","v":""}]
[null,{"$f":"'I-J'!B9","v":"Kreditraten"},{"$f":"IF(ISBLANK('I-J'!C9),\"\",'I-J'!C9)","v":""}]
[null,{"$f":"'I-J'!B10","v":"PKH-Kosten"},{"$f":"IF(ISBLANK('I-J'!C10),\"\",'I-J'!C10)","v":""}]
[null,{"$f":"'I-J'!B11","v":"Fortbildungskosten"},{"$f":"IF(ISBLANK('I-J'!C11),\"\",'I-J'!C11)","v":""}]
[null,{"$f":"'I-J'!B12","v":"Sonstiges (Anwaltskosten, Fortbildung etc.)"},{"$f":"IF(ISBLANK('I-J'!C12),\"\",'I-J'!C12)","v":""}]
[null,{"$f":"'I-J'!B13","v":"Aufwendungen wegen körperlicher Gebrechen"},{"$f":"IF(ISBLANK('I-J'!C13),\"\",'I-J'!C13)","v":""}]
[null,"Summe der besonderen Belastungen","[Leer]",{"$f":"SUM(C61:C66)","v":0}]
[null,null,"[Leer]"]
["einzusetzendes Einkommen",null,"[Leer]",{"$f":"SummeEinkünfte-SummeAbzüge-SummeFreibeträge-SummeWohnkosten-SummeMehrbedarfe-SummeBesondereBelastungen","v":-492}]
[null,null,"[Leer]"]
["Monatsrate",null,"[Leer]",{"$f":"Monatsrate(D69)","v":0}]

{"sheet":"115 IV","index":6,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,6],[17,0,17,1],[22,0,22,1]]}
["Vergleichsberechnung nach § 115 Abs. 4 ZPO"]
["Streitwert"]
[7500]
["Rechtsanwaltskosten","Tatbestand","einfache Gebühr","Faktor","Betrag"]
["Verfahrensgebühr","KV Nr. 3100",{"$f":"rvg(A3)","v":456},1.3,{"$f":"C5*D5","v":592.80000000000007}]
["Terminsgebühr","KV Nr. 3104",{"$f":"rvg(A3)","v":456},1.2,{"$f":"C6*D6","v":547.19999999999993}]
["Post/Telefon","KV Nr. 7002",null,null,{"$f":"IF(SUM(E5:E6)/100*20>20,20,SUM(E5:E6)/100*20)","v":20}]
["Auslagen"]
["Mehrwertsteuer","19%",null,null,{"$f":"SUM(E5:E8)/100*19","v":220.4}]
[]
["Zwischensumme",null,null,null,null,{"$f":"SUM(E5:E9)","v":1380.4}]
["Gerichtskosten","Tatbestand","einfache Gebühr","Faktor","Betrag"]
["Gebühren",null,{"$f":"gkg(A3)","v":203},2,{"$f":"C13*D13","v":406}]
["Auslagen"]
[]
["Zwischensumme",null,null,null,null,{"$f":"SUM(E13:E14)","v":406}]
[]
["Summe: Kosten des Rechtsstreits",null,null,null,null,null,{"$f":"SUM(F16,F11)","v":1786.4}]
[]
["Vermögenseinsatz",null,null,null,{"$f":"G!C21","v":0}]
["4 Monatsraten",null,{"$f":"Auswertung!D71","v":0},4,{"$f":"C21*D21","v":0}]
[]
["Summe: eigener Finanzierungsbeitrag",null,null,null,null,null,{"$f":"SUM(E20:E21)","v":0}]

{"sheet":"Freibeträge","index":7,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Person",{"$f":"IF('A-D'!C4<>\"\",'A-D'!C4,TODAY())","v":"2019-12-19"},"2014-01-01","2015-01-01","2016-01-01","2017-01-01","2018-01-01","2019-01-01","2019-02-21"]
["Partei",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":492},452,462,468,473,481,491,492]
["Kind 0-6",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":284},263,268,272,272,275,282,284]
["Kind 7-14",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":350},299,306,309,333,339,345,350]
["Kind 15-18",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":373},341,349,353,359,364,372,373]
["sonstige",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":393},362,370,374,377,383,392,393]
[]
["Erwerbstätigkeit",{"$f":"HLOOKUP(ED,Matrix,ROW())","v":224},206,210,213,215,219,223,224]