{"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 3"]
["(nicht rechtsverbindlich)"]
[]
["Name:"]
[]
["Mietstufe d. Wohnortes:",{"$nulls":4},"Mietstufen nach Ländern"]
[]
["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!H21,\"\")","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!I18","v":{"$error":"#N/A"}}]
[{"$nulls":4},"Klimakomponente",{"$f":"Hilfsrechnungen!I19","v":{"$error":"#N/A"}}]
[]
["Höchstmiete / Belastung",null,{"$f":"IFERROR(INDEX(Hilfsrechnungen!A30:M37,MATCH(C8,Hilfsrechnungen!A30:A37,0),MATCH(C10,Hilfsrechnungen!A30:M30,0)),\"\")","v":""}]
[]
[]
["Zu berücksichtigende Miete",null,{"$f":"IF(C22>C25+F23,C25+F22+F23,IF(C22=0,\"\",C22+F22))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
["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 und Pflegegeld 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":""},{"$f":"IF(E35-E40=0,\"\",E35-E40)","v":""},{"$f":"IF(F35-F40=0,\"\",F35-F40)","v":""},{"$f":"IF(G35-G40=0,\"\",G35-G40)","v":""}]
["pauschaler Abzug in %"]
["pauschaler Abzug als Betrag",null,{"$f":"IFERROR(C41*C42,\"\")","v":""},{"$f":"IFERROR(D41*D42,\"\")","v":""},{"$f":"IFERROR(E41*E42,\"\")","v":""},{"$f":"IFERROR(F41*F42,\"\")","v":""},{"$f":"IFERROR(G41*G42,\"\")","v":""}]
["Zwischenergebnis",null,{"$f":"IFERROR(C41-C43,\"\")","v":""},{"$f":"IFERROR(D41-D43,\"\")","v":""},{"$f":"IFERROR(E41-E43,\"\")","v":""},{"$f":"IFERROR(F41-F43,\"\")","v":""},{"$f":"IFERROR(G41-G43,\"\")","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, Carsten Richter Version 2023.1"]
["Weitere Infos zum Wohngeld"]
["www.bmi.bund.de/Wohngeld"]

{"sheet":"Mietstufen","index":1,"n_rows":56,"n_cols":2,"rows_kept":56}
["Gemeinde/-Teilort","Mietstufe"]
[]
["Mietstufe 1",1]
["Mietstufe 2",2]
["Mietstufe 3",3]
["Mietstufe 4",4]
["Mietstufe 5",5]
["Mietstufe 6",6]
["Mietstufe 7",7]
["Abstatt",3]
["Bad Friedrichshall",4]
["Bad Rappenau",3]
["Bad Wimpfen",3]
["Beilstein",3]
["Brackenheim",3]
["Cleebronn",3]
["Eberstadt",3]
["Ellhofen",3]
["Eppingen",3]
["Erlenbach",3]
["Flein",3]
["Gemmingen",3]
["Güglingen",3]
["Gundelsheim",3]
["Hardhausen am Kocher",3]
["Heilbronn",4]
["Ilsfeld",3]
["Ittlingen",3]
["Jagsthausen",3]
["Kirchardt",3]
["Langenbrettach",3]
["Lauffen am Neckar",3]
["Lehrensteinsfeld",3]
["Leingarten ",4]
["Löwenstein",3]
["Massenbachhausen",3]
["Möckmühl",3]
["Neckarsulm",4]
["Neckarwestheim",3]
["Neudenau",3]
["Neuenstadt am Kocher",2]
["Nordheim",3]
["Obersulm",3]
["Oedheim",3]
["Offenau",3]
["Pfaffenhofen",3]
["Roigheim",3]
["Schwaigern",3]
["Siegelsbach",3]
["Talheim",3]
["Untereisesheim",3]
["Untergruppenbach",3]
["Weinsberg",4]
["Widdern ",3]
["Wüstenrot",3]
["Zaberfeld",3]

{"sheet":"Hilfsrechnungen","index":2,"n_rows":51,"n_cols":13,"rows_kept":51}
["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",{"$f":"4/$C$13","v":0.04},{"$f":"3/$C$13","v":0.03},{"$f":"2/$C$13","v":0.02},{"$f":"1/$C$13","v":0.01},{"$f":"0","v":0},{"$f":"-1/$C$13","v":-0.01},{"$f":"-2/$C$13","v":-0.02},{"$f":"-3/$C$13","v":-0.03},{"$f":"-4/$C$13","v":-0.04},{"$f":"-6/$C$13","v":-0.06},{"$f":"-9/$C$13","v":-0.09},{"$f":"-1.2/C12","v":-0.12}]
["b",{"v":0.0004991,"d":"4.99E-04"},{"v":0.0003716,"d":"3.72E-04"},{"v":3.035E-4,"d":"3.04E-04"},{"v":2.251E-4,"d":"2.25E-04"},{"v":1.985E-4,"d":"1.99E-04"},{"v":0.0001792,"d":"1.79E-04"},{"v":0.0001657,"d":"1.66E-04"},{"v":0.0001648,"d":"1.65E-04"},{"v":0.0001432,"d":"1.43E-04"},{"v":0.00013,"d":"1.30E-04"},{"v":1.188E-4,"d":"1.19E-04"},{"v":0.0001152,"d":"1.15E-04"}]
["c",{"v":4.62e-05,"d":"4.62E-05"},{"v":3.45e-05,"d":"3.45E-05"},{"v":2.78e-05,"d":"2.78E-05"},{"v":2e-05,"d":"2.00E-05"},{"v":1.95E-5,"d":"1.95E-05"},{"v":1.88E-5,"d":"1.88E-05"},{"v":1.87e-05,"d":"1.87E-05"},{"v":1.87e-05,"d":"1.87E-05"},{"v":1.88E-5,"d":"1.88E-05"},{"v":1.88E-5,"d":"1.88E-05"},{"v":2.22e-05,"d":"2.22E-05"},{"v":2.51E-5,"d":"2.51E-05"}]
["Mmin",52,64,76,88,99,99,111,123,135,146,180,286]
["Ymin",350,600,800,1000,1200,"1 400",1600,1800,2000,2200,2400,2600]
["Höchstbeträge HK",{"v":110.4,"d":"110.40 €"},{"v":142.6,"d":"142.60 €"},{"v":170.2,"d":"170.20 €"},{"v":197.8,"d":"197.80 €"},{"v":225.6,"d":"225.60 €"},{"$f":"F8+27.6","v":{"v":253.2,"d":"253.20 €"}},{"v":280.8,"d":"280.80 €"},{"v":308.40000000000003,"d":"308.40 €"},{"v":336.00000000000006,"d":"336.00 €"},{"v":363.6000000000001,"d":"363.60 €"},{"v":391.2000000000001,"d":"391.20 €"},{"v":418.8000000000001,"d":"418.80 €"}]
["Klimakomponente",{"v":19.2,"d":"19.20 €"},{"v":24.8,"d":"24.80 €"},{"v":29.6,"d":"29.60 €"},{"v":34.4,"d":"34.40 €"},{"v":39.2,"d":"39.20 €"},{"$f":"F9+4.8","v":{"v":44,"d":"44.00 €"}},{"v":48.8,"d":"48.80 €"},{"v":53.599999999999994,"d":"53.60 €"},{"v":58.39999999999999,"d":"58.40 €"},{"v":63.19999999999999,"d":"63.20 €"},{"v":67.99999999999999,"d":"68.00 €"},{"v":72.79999999999998,"d":"72.80 €"}]
[{"$nulls":7},"HH-Mitglieder",{"$f":"Wohngeldberechnung!C10","v":0}]
[{"$nulls":7},"Miete","M",{"$f":"IF(Wohngeldberechnung!C28<HLOOKUP(I10,B2:M6,5),HLOOKUP(I10,B2:M6,5),Wohngeldberechnung!C28)","v":{"$error":"#VALUE!"}}]
[null,"e1",10]
[null,"e2",100,{"$nulls":4},"Gesamtek","Y",{"$f":"IF(Wohngeldberechnung!C54<HLOOKUP(I10,B2:M7,6),HLOOKUP(I10,B2:M7,6),Wohngeldberechnung!C54)","v":{"$error":"#N/A"}}]
[null,"e4",10000]
[null,"e5",100000,{"$nulls":4},"a",{"$f":"HLOOKUP(I10,B2:M3,2)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"b",{"$f":"HLOOKUP(I10,B2:M4,3)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"c",{"$f":"HLOOKUP(I10,B2:M5,4)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"d",{"$f":"HLOOKUP(I10,B2:M8,7)","v":{"$error":"#N/A"}}]
[{"$nulls":7},"e",{"$f":"HLOOKUP(I10,B2:M9,8)","v":{"$error":"#N/A"}}]
[{"$nulls":6},"WoG unrund",{"$f":"1.15*(J11-(I15+I16*J11+I17*J13)*J13)","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"Wohngeld rund",{"$f":"ROUND(H20,0)","v":{"$error":"#VALUE!"}}]
[]
[]
[{"$nulls":6},"z1",{"$f":"I15+I16*J11+I17*J13","v":{"$error":"#N/A"}}]
[{"$nulls":6},"z2",{"$f":"H24*J13","v":{"$error":"#N/A"}}]
[{"$nulls":6},"z3",{"$f":"J11-H25","v":{"$error":"#VALUE!"}}]
[{"$nulls":6},"z4",{"$f":"1.18*H26","v":{"$error":"#VALUE!"}}]
[]
["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":"F31+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":"F32+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":"F33+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":"F34+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":"F35+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":"F36+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":"F37+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]