{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Wohngeldberechnung","Mietstufen","Hilfsrechnungen"],"not_rendered":{"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Wohngeldberechnung","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"merged":[[0,0,0,6],[1,0,1,6],[3,1,3,3],[5,1,5,3],[18,0,18,6],[19,0,19,6],[31,0,31,6],[32,0,32,6]]}
["W O H N G E L D R E C H N E R    2 0 2 2"]
["(nicht rechtsverbindlich)"]
[]
["Name:"]
[]
["Mietstufe d. Wohnortes:",{"$nulls":4},"Mietstufen-Übersicht BMI"]
[]
["Mietstufe:",null,{"$f":"IFERROR(VLOOKUP(B6,Mietstufen!A3:B56,2,FALSE),\"\")","v":""}]
[]
["Anzahl der Haush. Mitglieder:"]
[]
["Berück. Miete/Belastung:",null,{"$f":"IFERROR(IF(C28=0,\"\",C28),\"\")","v":""}]
[]
["monatl. Gesamteinkommen:",null,{"$f":"IF(C54=0,\"\",C54)","v":""}]
[]
["Wohngeld:",null,{"$f":"IFERROR(Hilfsrechnungen!H20,\"\")","v":""}]
[]
[]
["B e r e c h n u n g   z u   b e r ü c k s i c h t i g e n d e   M i e t e / B e l a s t u n g"]
["!!! Heizkosten bleiben außer Betracht!!!"]
[]
["tatsächliche Miete / Belastung",{"$nulls":3},"Heizkostenentl.",{"$f":"Hilfsrechnungen!I17","v":{"$error":"#N/A"}}]
[]
[]
["Höchstmiete / Belastung",null,{"$f":"IFERROR(INDEX(Hilfsrechnungen!A29:M36,MATCH(C8,Hilfsrechnungen!A29:A36,0),MATCH(C10,Hilfsrechnungen!A29:M29,0)),\"\")","v":""}]
[]
[]
["Zu berücksichtigende Miete",null,{"$f":"IF(C22>C25,C25+F22,IF(C22=0,\"\",C22+F22))","v":""}]
[]
[]
[]
["M o n a t l i c h e s   G e s a m t e i n k o m m e n"]
["!!! Kindergeld bleibt beim Wohngeld außer Betracht !!!"]
[]
["Höhe des Bruttoeinkommens"]
["Wessen Einkommen?"]
["Einkommesart"]
[]
["Einkommensbereinigung"]
["abzgl. Werbungskosten(-pauschale)"]
["Zwischenergebnis",null,{"$f":"IF(C35-C40=0,\"\",C35-C40)","v":""},{"$f":"IF(D35-D40=0,\"\",D35-D40)","v":""},"","",""]
["pauschaler Abzug in %"]
["pauschaler Abzug als Betrag",null,{"$f":"IFERROR(C41*C42,\"\")","v":""},{"$f":"IFERROR(D41*D42,\"\")","v":""},"","",""]
["Zwischenergebnis",null,{"$f":"IFERROR(C41-C43,\"\")","v":""},{"$f":"IFERROR(D41-D43,\"\")","v":""},"","",""]
[]
["Summe der bereinigten Einkommen",null,{"$f":"IF(SUM(C44:G44)=0,\"\",SUM(C44:G44))","v":""}]
[]
["Weitere Freibeträge"]
["Schwerbehinderung 100% oder <100% und pflegebed.?"]
["\"Kind\" bis 25 Jahre alt und eigenes Einkommen"]
["Alleinerziehenden-Freibetrag (mind. 1 Kind minderj.)"]
["weitere Absetzmöglichkeiten (u.a. Unterhaltsz.)"]
[]
["Monatl. Gesamteinkommen",null,{"$f":"IFERROR(C46-SUM(C49:C52),\"\")","v":""}]
[]
[]
["© Diakonische Bezirksstelle Neuenstadt, Version 2022"]
["Weitere Infos zum Wohngeld"]
["www.bmi.bund.de/Wohngeld"]

{"sheet":"Mietstufen","index":1,"n_rows":9,"n_cols":2,"rows_kept":9}
["Gemeinde/-Teilort","Mietstufe"]
[]
["Mietstufe 1",1]
["Mietstufe 2",2]
["Mietstufe 3",3]
["Mietstufe 4",4]
["Mietstufe 5",5]
["Mietstufe 6",6]
["Mietstufe 7",7]

{"sheet":"Hilfsrechnungen","index":2,"n_rows":50,"n_cols":13,"rows_kept":50}
["Berechnungsformeln für a,b,c sowie für Mmin und Ymin"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["a",0.04,0.03,0.02,0.01,0,-0.01,-0.02,-0.03,-0.04,-0.06,-0.1,-0.14]
["b",{"$f":"5.64/10000","v":5.6399999999999994E-4},{"$f":"3.94/10000","v":0.000394},{"$f":"3.4/10000","v":3.3999999999999997E-4},{"$f":"3.04/10000","v":0.000304},0.000268,0.000251,2.32E-4,0.000206,0.000179,0.000143,1.07E-4,9.8e-05]
["c",0.0001157,8.63e-05,6.95e-05,3.61e-05,3.52e-05,3.02e-05,{"$f":"3.1/100000","v":3.1e-05},3.1e-05,{"$f":"3.26/100000","v":3.26E-5},{"$f":"3.77/100000","v":3.77e-05},{"$f":"4.44/100000","v":4.44e-05},{"$f":"5.03/100000","v":5.03e-05}]
["Mmin",52,64,76,88,99,99,111,123,135,146,180,286]
["Ymin",275,357,414,447,532,618,702,787,872,957,1248,1443]
["Höchstbeträge HK",{"v":14.4,"d":"14.40 €"},{"v":18.6,"d":"18.60 €"},{"v":22.2,"d":"22.20 €"},{"v":25.8,"d":"25.80 €"},{"v":29.4,"d":"29.40 €"},{"$f":"F8+3.6","v":{"v":33,"d":"33.00 €"}},{"$f":"G8+3.6","v":{"v":36.6,"d":"36.60 €"}},{"v":40.2,"d":"40.20 €"},{"v":43.800000000000004,"d":"43.80 €"},{"v":47.400000000000006,"d":"47.40 €"},{"v":51.00000000000001,"d":"51.00 €"},{"v":54.60000000000001,"d":"54.60 €"}]
[{"$nulls":7},"HH-Mitglieder",{"$f":"Wohngeldberechnung!C10","v":0}]
[{"$nulls":7},"Miete","M",{"$f":"IF(Wohngeldberechnung!C28<HLOOKUP(I9,B2:M6,5),HLOOKUP(I9,B2:M6,5),Wohngeldberechnung!C28)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":7},"Gesamtek","Y",{"$f":"IF(Wohngeldberechnung!C54<HLOOKUP(I9,B2:M7,6),HLOOKUP(I9,B2:M7,6),Wohngeldberechnung!C54)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":7},"a",{"$f":"HLOOKUP(I9,B2:M3,2)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"b",{"$f":"HLOOKUP(I9,B2:M4,3)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"c",{"$f":"HLOOKUP(I9,B2:M5,4)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"d",{"$f":"HLOOKUP(I9,B2:M8,7)","v":{"$error":"#N/A"}}]
[]
[{"$nulls":6},"WoG unrund",{"$f":"1.15*(J10-(I14+I15*J10+I16*J12)*J12)","v":{"$error":"#N/A"}}]
[{"$nulls":6},"Wohngeld rund",{"$f":"ROUND(H19,0)","v":{"$error":"#N/A"}}]
[]
[]
[{"$nulls":6},"z1",{"$f":"I14+I15*J10+I16*J12","v":{"$error":"#N/A"}}]
[{"$nulls":6},"z2",{"$f":"H23*J12","v":{"$error":"#N/A"}}]
[{"$nulls":6},"z3",{"$f":"J10-H24","v":{"$error":"#N/A"}}]
[{"$nulls":6},"z4",{"$f":"1.08*H25","v":{"$error":"#N/A"}}]
[]
["Höchstbeträge für Miete/Belastung"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[1,{"v":347,"d":"347 €"},{"v":420,"d":"420 €"},{"v":501,"d":"501 €"},{"v":584,"d":"584 €"},{"v":667,"d":"667 €"},{"$f":"F30+79","v":{"v":746,"d":"746 €"}},{"v":825,"d":"825 €"},{"v":904,"d":"904 €"},{"v":983,"d":"983 €"},{"v":1062,"d":"1,062 €"},{"v":1141,"d":"1,141 €"},{"v":1220,"d":"1,220 €"}]
[2,{"v":392,"d":"392 €"},{"v":474,"d":"474 €"},{"v":564,"d":"564 €"},{"v":659,"d":"659 €"},{"v":752,"d":"752 €"},{"$f":"F31+90","v":{"v":842,"d":"842 €"}},{"v":932,"d":"932 €"},{"v":1022,"d":"1,022 €"},{"v":1112,"d":"1,112 €"},{"v":1202,"d":"1,202 €"},{"v":1292,"d":"1,292 €"},{"v":1382,"d":"1,382 €"}]
[3,{"v":438,"d":"438 €"},{"v":530,"d":"530 €"},{"v":631,"d":"631 €"},{"v":736,"d":"736 €"},{"v":841,"d":"841 €"},{"$f":"F32+102","v":{"v":943,"d":"943 €"}},{"v":1045,"d":"1,045 €"},{"v":1147,"d":"1,147 €"},{"v":1249,"d":"1,249 €"},{"v":1351,"d":"1,351 €"},{"v":1453,"d":"1,453 €"},{"v":1555,"d":"1,555 €"}]
[4,{"v":491,"d":"491 €"},{"v":595,"d":"595 €"},{"v":708,"d":"708 €"},{"v":825,"d":"825 €"},{"v":944,"d":"944 €"},{"$f":"F33+114","v":{"v":1058,"d":"1,058 €"}},{"v":1172,"d":"1,172 €"},{"v":1286,"d":"1,286 €"},{"v":1400,"d":"1,400 €"},{"v":1514,"d":"1,514 €"},{"v":1628,"d":"1,628 €"},{"v":1742,"d":"1,742 €"}]
[5,{"v":540,"d":"540 €"},{"v":654,"d":"654 €"},{"v":778,"d":"778 €"},{"v":909,"d":"909 €"},{"v":1038,"d":"1,038 €"},{"$f":"F34+124","v":{"v":1162,"d":"1,162 €"}},{"v":1286,"d":"1,286 €"},{"v":1410,"d":"1,410 €"},{"v":1534,"d":"1,534 €"},{"v":1658,"d":"1,658 €"},{"v":1782,"d":"1,782 €"},{"v":1906,"d":"1,906 €"}]
[6,{"v":591,"d":"591 €"},{"v":716,"d":"716 €"},{"v":853,"d":"853 €"},{"v":995,"d":"995 €"},{"v":1137,"d":"1,137 €"},{"$f":"F35+143","v":{"v":1280,"d":"1,280 €"}},{"v":1423,"d":"1,423 €"},{"v":1566,"d":"1,566 €"},{"v":1709,"d":"1,709 €"},{"v":1852,"d":"1,852 €"},{"v":1995,"d":"1,995 €"},{"v":2138,"d":"2,138 €"}]
[7,{"v":651,"d":"651 €"},{"v":788,"d":"788 €"},{"v":937,"d":"937 €"},{"v":1095,"d":"1,095 €"},{"v":1251,"d":"1,251 €"},{"$f":"F36+157","v":{"v":1408,"d":"1,408 €"}},{"v":1565,"d":"1,565 €"},{"v":1722,"d":"1,722 €"},{"v":1879,"d":"1,879 €"},{"v":2036,"d":"2,036 €"},{"v":2193,"d":"2,193 €"},{"v":2350,"d":"2,350 €"}]
[]
[]
[1,{"$nulls":10},100]
[2,null,null,150,null,{"v":0.1,"d":"10%"},null,50,{"$nulls":3},200]
[3,null,null,300,null,{"v":0.2,"d":"20%"},null,100,null,8.5,null,300]
[4,null,null,450,null,{"v":0.3,"d":"30%"},null,150,null,83.33,null,400]
[5,null,null,600,{"$nulls":3},200]
[6]
[7]
[8]
[9,{"$nulls":3},0]
[10,{"$nulls":3},{"$f":"1320/12","v":110}]
[11]
[12]