{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bonn-Ausweis","Tab"],"not_rendered":{"images":3,"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Bonn-Ausweis","index":0,"n_rows":132,"n_cols":19,"rows_kept":132,"merged":[[0,13,0,18],[1,4,1,6],[1,13,1,18],[2,13,5,18],[6,13,6,18],[109,13,112,18],[125,7,125,8],[127,2,127,8],[129,1,129,9]]}
[{"$nulls":13},"Die Freibetragsberechnung ergibt sich wie folgt: "]
[{"$nulls":4},"Bonn – Ausweis",{"$nulls":8},"Erwerbseinkommen: Einkommen abzüglich Werbungskostenpauschale (1.000€ pro Jahr), abzüglich jeweils 10% (nach Abzug WBK), wenn aus dem Einkommen 1)Steuern, 2)Rentenversicherungsbeiträge oder  3)Kranken- und Pflegeversicherungsbeiträge gezahlt wurden"]
[{"$nulls":13},"Renteneinkommen: Einkommen abzüglich Werbungskostenpauschale (8,50 € pro Monat), abzüglich 10% (nach Abzug WBK), wenn aus dem Einkommen Kranken- und Pflegeversicherungsbeiträge gezahlt wurden"]
[]
["I)","Ermittlung des Einkommens"]
[]
[null,null,"Personen im Haushalt",null,"Jahresbruttoeinkommen aus Erwerbstätigkeit inkl. Sonderzahlungen",null,"Monatsbruttoeinkommen aus Rente",null,"sonstiges Monatseinkommen"]
[]
[null,1,"Antragsteller",{"$nulls":10},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"     Steuern",{"$nulls":8},false]
[{"$nulls":4},"     Kranken- und Pflegeversicherungsbeiträge",null,"     Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N9:N11,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P9:P11,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"     Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E9-IF(E9>=Tab!$F$14,Tab!$F$14,E9))*N12","v":0},null,{"$f":"(G9-IF(G9>=Tab!$F$15,Tab!$F$15,G9))*P12","v":0},{"$f":"I9","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E9<>\"\",IF(E9>=Tab!$F$14,TEXT(E9,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N12<1,\" ./. \" & TEXT((1-N12)*(E9-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N12) *100 &\"%\" & \")\",\"\"),TEXT(E9,\"#.##0,00 €\") & \" ./.\" & TEXT(E9,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O13,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G9<>\"\",IF(G9>=Tab!$F$15,TEXT(G9,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P10 = TRUE,\" ./. \" & TEXT(0.1 *(G9-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G9,\"#.##0,00 €\") & \" ./.\" & TEXT(G9,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q13,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,2,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"     Steuern",{"$nulls":8},false]
[{"$nulls":4},"     Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N18:N20,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P18:P20,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"     Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E18-IF(E18>=Tab!$F$14,Tab!$F$14,E18))*N21","v":0},null,{"$f":"(G18-IF(G18>=Tab!$F$15,Tab!$F$15,G18))*P21","v":0},{"$f":"I18","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E18<>\"\",IF(E18>=Tab!$F$14,TEXT(E18,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N21<1,\" ./. \" & TEXT((1-N21)*(E18-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N21) *100 &\"%\" & \")\",\"\"),TEXT(E18,\"#.##0,00 €\") & \" ./.\" & TEXT(E18,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O22,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G18<>\"\",IF(G18>=Tab!$F$15,TEXT(G18,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P19 = TRUE,\" ./. \" & TEXT(0.1 *(G18-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G18,\"#.##0,00 €\") & \" ./.\" & TEXT(G18,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q22,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,3,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N27:N29,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P27:P29,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E27-IF(E27>=Tab!$F$14,Tab!$F$14,E27))*N30","v":0},null,{"$f":"(G27-IF(G27>=Tab!$F$15,Tab!$F$15,G27))*P30","v":0},{"$f":"I27","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E27<>\"\",IF(E27>=Tab!$F$14,TEXT(E27,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N30<1,\" ./. \" & TEXT((1-N30)*(E27-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N30) *100 &\"%\" & \")\",\"\"),TEXT(E27,\"#.##0,00 €\") & \" ./.\" & TEXT(E27,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O31,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G27<>\"\",IF(G27>=Tab!$F$15,TEXT(G27,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P28 = TRUE,\" ./. \" & TEXT(0.1 *(G27-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G27,\"#.##0,00 €\") & \" ./.\" & TEXT(G27,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q31,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,4,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N36:N38,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P36:P38,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E36-IF(E36>=Tab!$F$14,Tab!$F$14,E36))*N39","v":0},null,{"$f":"(G36-IF(G36>=Tab!$F$15,Tab!$F$15,G36))*P39","v":0},{"$f":"I36","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E36<>\"\",IF(E36>=Tab!$F$14,TEXT(E36,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N39<1,\" ./. \" & TEXT((1-N39)*(E36-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N39) *100 &\"%\" & \")\",\"\"),TEXT(E36,\"#.##0,00 €\") & \" ./.\" & TEXT(E36,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O40,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G36<>\"\",IF(G36>=Tab!$F$15,TEXT(G36,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P37 = TRUE,\" ./. \" & TEXT(0.1 *(G36-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G36,\"#.##0,00 €\") & \" ./.\" & TEXT(G36,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q40,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,5,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N45:N47,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P45:P47,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E45-IF(E45>=Tab!$F$14,Tab!$F$14,E45))*N48","v":0},null,{"$f":"(G45-IF(G45>=Tab!$F$15,Tab!$F$15,G45))*P48","v":0},{"$f":"I45","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E45<>\"\",IF(E45>=Tab!$F$14,TEXT(E45,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N48<1,\" ./. \" & TEXT((1-N48)*(E45-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N48) *100 &\"%\" & \")\",\"\"),TEXT(E45,\"#.##0,00 €\") & \" ./.\" & TEXT(E45,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O49,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G45<>\"\",IF(G45>=Tab!$F$15,TEXT(G45,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P46 = TRUE,\" ./. \" & TEXT(0.1 *(G45-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G45,\"#.##0,00 €\") & \" ./.\" & TEXT(G45,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q49,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,6,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N54:N56,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P54:P56,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E54-IF(E54>=Tab!$F$14,Tab!$F$14,E54))*N57","v":0},null,{"$f":"(G54-IF(G54>=Tab!$F$15,Tab!$F$15,G54))*P57","v":0},{"$f":"I54","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E54<>\"\",IF(E54>=Tab!$F$14,TEXT(E54,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N57<1,\" ./. \" & TEXT((1-N57)*(E54-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N57) *100 &\"%\" & \")\",\"\"),TEXT(E54,\"#.##0,00 €\") & \" ./.\" & TEXT(E54,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O58,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G54<>\"\",IF(G54>=Tab!$F$15,TEXT(G54,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P55 = TRUE,\" ./. \" & TEXT(0.1 *(G54-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G54,\"#.##0,00 €\") & \" ./.\" & TEXT(G54,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q58,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,7,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N63:N65,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P63:P65,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E63-IF(E63>=Tab!$F$14,Tab!$F$14,E63))*N66","v":0},null,{"$f":"(G63-IF(G63>=Tab!$F$15,Tab!$F$15,G63))*P66","v":0},{"$f":"I63","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E63<>\"\",IF(E63>=Tab!$F$14,TEXT(E63,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N66<1,\" ./. \" & TEXT((1-N66)*(E63-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N66) *100 &\"%\" & \")\",\"\"),TEXT(E63,\"#.##0,00 €\") & \" ./.\" & TEXT(E63,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O67,\"#.##0,00 €\"),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(G63<>\"\",IF(G63>=Tab!$F$15,TEXT(G63,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P64 = TRUE,\" ./. \" & TEXT(0.1 *(G63-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G63,\"#.##0,00 €\") & \" ./.\" & TEXT(G63,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q67,\"#.##0,00 €\"),\"\")","v":""}]
[]
[null,8,{"$nulls":11},false]
[{"$nulls":4},"hierin enthalten:",null,"hierin enthalten:",{"$nulls":6},false,null,false]
[{"$nulls":4},"    Steuern",{"$nulls":8},false]
[{"$nulls":4},"    Kranken- und Pflegeversicherungsbeiträge",null,"    Kranken- und Pflegeversicherungsbeiträge",{"$nulls":6},{"$f":" 1- (COUNTIF(N72:N74,\"Wahr\") / 10)","v":1},null,{"$f":" 1- (COUNTIF(P72:P74,\"Wahr\") / 10)","v":1}]
[{"$nulls":4},"    Rentenversichungsbeiträge",{"$nulls":9},{"$f":"(E72-IF(E72>=Tab!$F$14,Tab!$F$14,0))*N75","v":0},null,{"$f":"(G72-IF(G72>=Tab!$F$15,Tab!$F$15,G72))*P75","v":0},{"$f":"I72","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":4},{"$f":"IF(E72<>\"\",IF(E72>=Tab!$F$14,TEXT(E72,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$14,\"#.##0,00 €\")&\" WBK\" & IF(N75<1,\" ./. \" & TEXT((1-N75)*(E72-Tab!$F$14),\"#.##0,00 €\") & \" (\" & (1-N75) *100 &\"%\" & \")\",\"\"),TEXT(E72,\"#.##0,00 €\") & \" ./.\" & TEXT(E72,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(O76,\"#.##0,00 €\"),\"\")","v":""},{"$nulls":9},{"$f":"SUM(O8:O77)","v":0}]
[{"$nulls":6},{"$f":"IF(G72<>\"\",IF(G72>=Tab!$F$15,TEXT(G72,\"#.##0,00 €\") & \"  ./. \"& TEXT(Tab!$F$15,\"#.##0,00 €\") & \" WBK\" & IF(P73 = TRUE,\" ./. \" & TEXT(0.1 *(G72-Tab!$F$15),\"#.##0,00 €\") & \" (10%)\",\"\"),TEXT(G72,\"#.##0,00 €\") & \" ./.\" & TEXT(G72,\"#.##0,00 €\") & \" WBK\") & \" = \" & TEXT(Q76,\"#.##0,00 €\"),\"\")","v":""},{"$nulls":6},"Summen",{"$f":"O78/12","v":0},null,{"$f":"SUM(Q8:Q77)","v":0},{"$f":"SUM(R8:R78)","v":0},{"$f":"SUM(O79:R79)","v":0}]
["II)","Ermittlung der mtl. Einkommensgrenze  (Einkommensgrenze Teil A)"]
[]
[null,null,"Für den Antragsteller",{"$nulls":5},{"$f":"Tab!F6 * 2","v":{"v":1126,"d":"1,126.00 €"}}]
[]
[null,null,"sofern im gleichen Haushalt lebend:"]
[]
[null,{"$f":" IF(C18=Tab!E7,\"X\",\"\")","v":""},"Für Ehe- oder Lebenspartner",{"$nulls":3},{"$f":"Tab!F7","v":{"v":506,"d":"506.00 €"}},null,{"$f":"IF(B86=\"X\",G86,\"\")","v":""}]
[]
[null,{"$f":"COUNTIF($C$18:$C$72,Tab!$E$8)","v":0},{"$f":"IF(B88=1,\"volljährige Person\",\"volljährige Personen\")&\" im Haushalt\"","v":"volljährige Personen im Haushalt"},{"$nulls":3},{"$f":"Tab!F8","v":{"v":451,"d":"451.00 €"}},null,{"$f":"IF(B88>0,B88*G88,\"\")","v":""},{"$nulls":4},{"$f":"COUNTIF($C$18:$C$73,\"Volljähriger*\")","v":0}]
[]
[null,{"$f":"COUNTIF($C$18:$C$72,Tab!$E$9)","v":0},{"$f":"IF(B90=1,\"Kind\",\"Kinder\")&\" von 14 bis 17 Jahren\"","v":"Kinder von 14 bis 17 Jahren"},{"$nulls":3},{"$f":"Tab!F9","v":{"v":471,"d":"471.00 €"}},null,{"$f":"IF(B90>0,B90*G90,\"\")","v":""},{"$nulls":4},{"$f":"COUNTIF($C$18:$C$73,\"*14*\")","v":0}]
[]
[null,{"$f":"COUNTIF($C$18:$C$72,Tab!$E$10)","v":0},{"$f":"IF(B92=1,\"Kind\",\"Kinder\")&\" von 6 bis 13 Jahren\"","v":"Kinder von 6 bis 13 Jahren"},{"$nulls":3},{"$f":"Tab!F10","v":{"v":390,"d":"390.00 €"}},null,{"$f":"IF(B92>0,B92*G92,\"\")","v":""},{"$nulls":4},{"$f":"COUNTIF($C$18:$C$73,\"*6*\")","v":0}]
[]
[null,{"$f":"COUNTIF($C$18:$C$72,Tab!$E$11)","v":0},{"$f":"IF(B94=1,\"Kind\",\"Kinder\")&\" von 0 bis 5 Jahren\"","v":"Kinder von 0 bis 5 Jahren"},{"$nulls":3},{"$f":"Tab!F11","v":{"v":357,"d":"357.00 €"}},null,{"$f":"IF(B94>0,B94*G94,\"\")","v":""},{"$nulls":4},{"$f":"COUNTIF($C$18:$C$73,\"*5*\")","v":0}]
[]
[null,null,"Zuschlag für erstes Kind",{"$nulls":5},{"$f":"IF(B90>0,Tab!F9 * 0.5,IF(B92>0,Tab!F10 * 0.5,IF(B94>0,Tab!F11 * 0.5,\"\")))","v":""}]
[{"$nulls":8},"==========="]
[null,{"$f":"SUM(B88:B94) + IF(B86=\"X\",\"1\",\"0\") +1","v":1},{"$f":"IF(B98=1,\" Person\",\"  Personen\") & \" im Haushalt\"","v":" Person im Haushalt"},{"$nulls":3},"Einkommensgrenze Teil A",null,{"$f":"SUM(I82:I96)","v":{"v":1126,"d":"1,126.00 €"}}]
[]
[]
["III)","zuzüglich tatsächliche angemessene Kosten der Unterkunft pro Monat (Einkommensgrenze Teil B)"]
[]
[null,"Kaltmiete",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[]
[null,"Betriebskosten"]
[]
[null,"tatsächliche Bruttokaltmiete",{"$nulls":4},{"$f":"G103+G105","v":{"v":0,"d":"0.00 €"}}]
[]
[null,{"$f":"\"max. Bruttokaltmiete für \" & B98 & \" Person\"&IF(B98=1,\"\",\"en\")","v":"max. Bruttokaltmiete für 1 Person"},{"$nulls":4},{"$f":"IF(B98>12,0,VLOOKUP(B98,Tab!$B$11:$C$22,2,FALSE))","v":{"v":576,"d":"576.00 €"}}]
[{"$nulls":13},"Berechnung der Heizkostenobergrenze: Der zulässige Quadratmeterpreis der jeweiligen Heizart wird mit der Anzahl der personenabhängig zulässigen qm multipliziert. Für die erste Person sind 50 m², für jede weitere zusätzlich 15 m² vorgesehen. €/m² * (50 + ((PersAnzahl - 1) *15))"]
[null,{"$f":"\"anzurechnende Bruttokaltmiete für \" & B98 & \" Person\"&IF(B98=1,\"\",\"en\")","v":"anzurechnende Bruttokaltmiete für 1 Person"},{"$nulls":6},{"$f":"MIN($G$107,$G$109)","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[null,"Auswahl der Heizungsart",{"$nulls":4},"Öl-Sammelheizung",{"$nulls":8},"Heizungsart",null,{"$f":"VLOOKUP(S114,Tab!E18:F24,2,FALSE)","v":1.98},{"$f":"G114","v":"Öl-Sammelheizung"}]
[]
[null,"tatsächliche Heizungskosten",{"$nulls":4},{"v":0,"d":"0.00 €"}]
[]
[null,"max. Heizungskosten nach Tabelle",{"$nulls":4},{"$f":"R114*(50+((B98-1)*15))","v":99}]
[]
[null,{"$f":"\"anzurechnende Heizkosten für \" & B98 & \" Person\"&IF(B98=1,\"\",\"en\")","v":"anzurechnende Heizkosten für 1 Person"},{"$nulls":6},{"$f":"MIN($G$116,$G$118)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Somit mtl. Einkommensgrenze der Bedarfsgemeinschaft",{"$nulls":6},{"$f":"$I$98+$I$111+$I$120","v":{"v":1126,"d":"1,126.00 €"}}]
[]
[null,"Mtl. Einkommen der Bedarfsgemeinschaft",{"$nulls":6},{"$f":"S79","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":15},"Differenz:",null,null,{"$f":"I122-I124","v":{"v":1126,"d":"1,126.00 €"}}]
[null,null,{"$f":"\"Das monatliche Einkommen \" & IF($S$125<0,\"überschreitet\",\"unterschreitet\") & \" die Einkommensgrenze um \"","v":"Das monatliche Einkommen unterschreitet die Einkommensgrenze um "},{"$nulls":4},{"$f":"ABS($S$125)","v":{"v":1126,"d":"1,126.00 €"}}]
[]
[null,"→",{"$f":" \"Ein Bonn-Ausweis kann Ihnen voraussichtlich\" & IF($S$125<0,\" leider nicht\",\" \") & \" ausgestellt werden!\"","v":"Ein Bonn-Ausweis kann Ihnen voraussichtlich  ausgestellt werden!"}]
[]
[null,"Dieser Online­Rechner berechnet auf der Basis Ihrer Angaben und stellt damit ein unverbindliches Ergebnis dar."]
[null,"Über die Ausstellung eines Bonn-Ausweises entscheidet die Service-Stelle auf Antrag."]
[{"$nulls":8},"2024-10-17"]

{"sheet":"Tab","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[2,4,4,5],[5,1,7,2],[12,4,12,5]]}
[null,"Tabellen"]
[]
[{"$nulls":4},"Regelbeträge SGB II"]
[]
[]
[null,"Richtwert Bruttokalt-\nmiete (GM+BK)",null,null,"Antragsteller",563]
[{"$nulls":4},"Ehe- Lebenspartner",506]
[{"$nulls":4},"Volljähriger im HH",451]
[null,"Personen","€",null,"Kind 14 - 17 Jahre",471]
[{"$nulls":4},"Kind 6 - 13 Jahre",390]
[null,1,576,null,"Kind 0 - 5 Jahre",357]
[null,2,692]
[null,3,828,null,"Werbungskosten"]
[null,4,959,null,"ErwerbsEK",{"v":1230,"d":"1,230"}]
[null,5,{"v":1104,"d":"1,104"},null,"Rente",{"v":8.5,"d":"8.50"}]
[null,6,{"v":1264,"d":"1,264"}]
[null,7,{"v":1437,"d":"1,437"},null,"Heizungsarten","EUR/m²"]
[null,8,{"v":1611,"d":"1,611"},null,"Öl-Sammelheizung",{"v":1.98,"d":"1.98  "}]
[null,9,{"v":1772,"d":"1,772"},null,"Erdgas",{"v":2.41,"d":"2.41  "}]
[null,10,null,null,"Fernwärme",{"v":1.98,"d":"1.98  "}]
[null,11,null,null,"Nachtstrom",{"v":1.98,"d":"1.98  "}]
[null,12,null,null,"Elektroheizung",{"v":1.98,"d":"1.98  "}]
[{"$nulls":4},"Wärmepumpe",{"v":1.14,"d":"1.14  "}]
[null,"Stand:  17.10.2024",null,null,"Pellets",{"v":1.05,"d":"1.05  "}]