{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Leerformular","Modul1","Tabelle1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":1,"reason":"part_missing"}],"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":"Leerformular","index":0,"n_rows":74,"n_cols":6,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["PKH-fix",null,"PKH-Rate:",{"$f":"E71","v":0},"KGsoft 2/2022"]
[]
[null,null,"Nur in die so unterlegten Felder Eingaben tätigen !","hier Eingaben","keine Eingaben!"]
[]
["Einkünfte (monatlich)",1,"Bruttoeinkommen",0,{"$f":"SUM(D5:D11)","v":0}]
[null,2,"Rente",0]
[null,3,"Wohngeld",0]
[null,4,"Kindergeld",0]
[null,5,"ALG II",0]
[null,6,"Unterhalt",0]
[null,7]
["Einmaleinkünfte",8,"Urlaubsgeld",0,{"$f":"SUM(D12:D15)/12","v":0}]
["(Berücksichtigung zu 1/12)",9,"Weihnachtsgeld",0]
[null,10,"Sonstiges",0]
[null,11]
["Abzüge gemäß § 82 II SGB 12",12,"Lohnsteuer",0,{"$f":"SUM(D16:D33)","v":0}]
[null,13,"Gewerbesteuer",0]
[null,14,"Kirchensteuer",0]
[null,15,"Rentenversicherung",0]
[null,16,"Krankenversicherung",0]
[null,17,"Arbeitslosenversicherung",0]
[null,18,"Pflegeversicherung",0]
[null,19,"Solidaritätsbeitrag",0]
[null,20,"Gewerkschaftsbeiträge",0]
[null,21,"Kfz-Haftpflicht",0]
[null,22,"Hausrat- /Haftpflichtversicherung",0]
[null,23,"Lebensversicherung",0]
[null,24,"sonst. angemes. Versicherungen",0]
[null,25,"Fahrt zur Arbeit",0]
[null,26,"sonstige Werbungskosten",0]
[null,27,"geförderte Altersvorsorge",0]
[null,28,"Sonstiges",0]
[null,29]
["Nettoeinkommen",30,null,null,{"$f":"E5+E12-E16","v":0}]
[null,31]
["Erwerbsfreibetrag § 115 I Nr. 1 b",32,null,null,0]
["Erwerbstaetigenfreibetrag: 225 EUR",33]
[null,34,"sonstiger Mehrbedarf",0]
[null,35]
["Freibeträge nach § 115 I ZPO",36,"Partei",494,494]
["(Unterhaltsfreibeträge)",37,"    Ehegatte                           eigenes Einkommen",0,0]
[null,38,"                                            Geldrente",0]
["Freibetrag Partei        : 494 EUR",39,"    1. Kind                              eigenes Einkommen",0,0]
["Freibetrag Partner       : 494 EUR",40,"                                            Geldrente",0]
["Freibetrag Kind (bis 5)  : 314 EUR",41,"    2. Kind                              eigenes Einkommen",0,0]
["Freibetrag Kind (6 - 13) : 342 EUR",42,"                                            Geldrente",0]
["Freibetrag Kind (14 - 17): 414 EUR",43,"    3. Kind                              eigenes Einkommen",0,0]
["Freibetrag Kind (ab 18)  : 396 EUR",44,"                                            Geldrente",0]
[null,45,"    4. Kind                              eigenes Einkommen",0,0]
[null,46,"                                            Geldrente",0]
[null,47,"Sonderfälle (z.B. Betreuung neben Geldrente, weitere",0]
[null,48,"                      Unterhaltsberechtigte)"]
["Unterkunft und Heizung",49,"Unterkunft, Heizung, sonst. Nebenkosten",0,{"$f":"IF(D54>0,((E5+E12)*D53)/(E5+E12+D54),D53)","v":0}]
[null,50,"Bruttoeinkommen des/der im Haushalt lebenden Angehörigen",0]
[null,51]
["Mehrbedarf gemäß",52,"MB f. alleinige Kinderbetreuung (§ 21 Abs. 3 SGB II)",null,{"$f":"MAX(F57,F58,F59)","v":0},446]
["§ 21 SGB II und § 30 SGB XII",53,"     Anzahl allein betreuter Kinder",0,null,{"$f":"(IF(D57>5,5,D57)*($F$56*12/100))","v":0}]
["Regelbedarf I § 21 SGBII : 446 EUR",54,"          davon bis 6 Jahre",0,null,{"$f":"IF(D58>0,$F$56*36/100,0)","v":0}]
[null,55,"          davon 7 bis 15 Jahre ",0,null,{"$f":"IF(D59>=2,$F$56*36/100,0)","v":0}]
[null,56,"weiterer Mehrbedarf",0,{"$f":"D60","v":0}]
[null,57]
["besondere Belastungen",58,"Abzahlungsverpflichtungen",0,{"$f":"SUM(D62:D68)","v":0}]
[null,59,"Kreditraten",0]
[null,60,"PKH-Kosten",0]
[null,61,"Fortbildungskosten",0]
[null,62,"Sonstiges (Anwaltskosten, Fortbildung ...)",0]
[null,63,"Aufwendungen wegen körperlicher Gebrechen",0]
[null,64]
["einzusetzendes Einkommen",65,null,null,{"$f":"E34-(SUM(E36:E68))","v":-494}]
[null,66]
[null,67,null,"PKH-Rate:",0]
[]
["maximal sind 48 Monatsraten aufzubringen (§ 115 Abs. 2 Satz 4 ZPO)",null,null,"maximal:",{"$f":"E71*48","v":0}]
["keine PKH, wenn Prozesskosten 4 Monatsraten nicht übersteigen (§ 115 Abs. 4 ZPO)",null,null,"Bagatellgrenze:",{"$f":"E71*4","v":0}]

{"sheet":"Tabelle1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}