{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Mietwohnungen"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":50,"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":"Mietwohnungen","index":0,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[47,0,47,2],[48,4,48,5],[47,4,47,5],[7,2,7,8],[10,3,11,6],[45,0,45,2],[45,4,45,5],[44,4,44,5],[46,0,46,2],[46,4,46,5],[44,0,44,2],[10,8,12,8],[10,0,12,0],[10,1,12,1],[62,3,62,6],[58,3,58,6],[62,0,62,2],[58,0,58,1],[48,0,48,2],[53,0,53,1],[55,0,55,1],[49,4,49,5],[53,2,53,3],[49,0,49,2],[55,2,55,3],[54,2,54,3],[52,2,52,3],[54,0,54,1],[52,0,52,1],[60,4,60,6]]}
[]
[]
[]
[]
[]
[]
[]
["Bauvorhaben:"]
[]
[]
["Top Nr. ","Wohnfläche",null,"\nFreiflächen \n(Loggien, Balkon, Terrasse)",null,null,null,null,"Prüfung Wohnfläche "]
[]
[null,null,"Anzahl\nRäume","Loggien","Balkone","Terassen","Freifläche ingesamt"]
[null,null,null,null,null,null,{"$f":"(IF(SUM(D14+E14+F14)<=8,(D14+E14+F14),\"nicht förderbar\"))","v":0},{"$f":"IF(G14=\"nicht förderbar\",1,0)","v":0},{"$f":"IF(G14=\"nicht förderbar\",\"nicht förderbar\",IF(B14=\"\",\"\",IF(AND(C14=1,B14<=38.5),B14,IF(AND(C14=2,B14<=55.5),B14,IF(AND(C14=3,B14<=77),B14,IF(AND(C14=4,B14<=93.5),B14,IF(AND(C14=5,B14<=104.5),B14,\"nicht förderbar\")))))))","v":""}]
[null,null,null,null,null,null,{"$f":"(IF(SUM(D15+E15+F15)<=8,(D15+E15+F15),\"nicht förderbar\"))","v":0},0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,{"$f":"(IF(SUM(D40+E40+F40)<=8,(D40+E40+F40),\"nicht förderbar\"))","v":0},0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[null,null,null,null,null,null,0,0,""]
[]
["Raumklassen gem. § 3 Abs. 2 Z.2. Neubauförderung",null,null,"WFL\nRaumklasse","Überschreitung",null,"Unterschreitung",null,"Projekt förderungswürdig\n (nach Ausgleich)"]
["1- Raumwohnungen",null,null,{"$f":"SUM(IF(C14:C43=1,B14:B43,0))","v":0},{"$f":"IF(D46-((COUNTIF(C13:C43,1)*35))>0,D46-(COUNTIF(C13:C43,1))*35,0)","v":0},null,{"$f":" IF(D46-((COUNTIF(C13:C43,1)*35))<0,ABS(D46-(COUNTIF(C13:C43,1))*35),0)","v":0},null,{"$f":"IF(D46=0,0,IF((COUNTIF(C14:C43,1)*35)>=D46,\"förderbar\",\"nicht förderbar\"))","v":0}]
["2- Raumwohnungen",null,null,{"$f":"SUM(IF(C14:C43=2,B14:B43,0))","v":0},{"$f":"IF(D47-((COUNTIF(C14:C43,2)*50))>0,D47-(COUNTIF(C14:C43,2))*50,0)","v":0},null,{"$f":" IF(D47-((COUNTIF(C14:C43,2)*50))<0,ABS(D47-(COUNTIF(C14:C43,2))*50),0)","v":0},null,{"$f":"IF(D47=0,0,IF((COUNTIF(C14:C43,2)*50)>=D47,\"förderbar\",\"nicht förderbar\"))","v":0}]
["3- Raumwohnungen",null,null,{"$f":"SUM(IF(C14:C43=3,B14:B43,0))","v":0},{"$f":"IF(D48-((COUNTIF(C14:C43,3)*70))>0,D48-(COUNTIF(C14:C43,3))*70,0)","v":0},null,{"$f":"IF(D48-((COUNTIF(C14:C43,3)*70))<0,ABS(D48-(COUNTIF(C14:C43,3))*70),0)","v":0},null,{"$f":"IF(D48=0,0,IF((COUNTIF(C14:C43,3)*70)>=D48,\"förderbar\",\"nicht förderbar\"))","v":0}]
["4- Raumwohnungen",null,null,{"$f":"SUM(IF(C14:C43=4,B14:B43,0))","v":0},{"$f":"IF(D49-((COUNTIF(C14:C43,4)*85))>0,D49-(COUNTIF(C14:C43,4))*85,0)","v":0},null,{"$f":"IF(D49-((COUNTIF(C14:C43,4)*85))<0,ABS(D49-(COUNTIF(C14:C43,4))*85),0)","v":0},null,{"$f":"IF(D49=0,0,IF(E49=0,\"förderbar\",IF(E49<=(G47+G48+G46+G50),\"förderbar\",IF((COUNTIF(C14:C43,4)*85)<D49,\"nicht förderbar\",IF(E49>(G47+G46+G48),\"fehlender Ausgleich bei 2- und 3 Raumwohnung\",IF(ABS(SUM(E49+E50))-ABS(SUM(G49+G50))<=ABS(SUM(G47+G46+G48)),\"förderbar\",\"fehlender Ausgleich bei 2- und 3 Raumwohnung\"))))))","v":0}]
["5- Raumwohnungen",null,null,{"$f":"SUM(IF(C14:C43=5,B14:B43,0))","v":0},{"$f":"IF(D50-((COUNTIF(C14:C43,5)*95))>0,D50-(COUNTIF(C14:C43,5))*95,0)","v":0},null,{"$f":"IF(D50-((COUNTIF(C14:C43,5)*95))<0,ABS(D50-(COUNTIF(C14:C43,5))*95),0)","v":0},null,{"$f":"IF(D50=0,0,IF(E50=0,\"förderbar\",IF(AND(E50<=(G46+G47+G48+G49),(E46+E47+E48+E49+E50)<=(G46+G47+G48+G49+G50)),\"förderbar\",IF((COUNTIF(C14:C43,5)*95)<D50,\"nicht förderbar\",IF(E50>(G46+G47+G48),\"fehlender Ausgleich bei 2- und 3 Raumwohnung\",IF(ABS(SUM(E49+E50))-ABS(SUM(G49+G50))<=ABS(SUM(G46+G47+G48)),\"förderbar\",\"fehlender Ausgleich bei 2- und 3 Raumwohnung\"))))))","v":0}]
[" "]
["Flächenaustellung"]
["Wohnfläche    ",null,{"$f":"SUM(B14:B37)","v":0},null,null,"(Fläche Berechnung Darlehen und Zuschläge)"]
["Loggienfläche ",null,{"$f":"SUM(D14:D43)","v":0}]
["Balkone, Terrassen",null,{"$f":"SUM(E14:F43)","v":0}]
["Baukostenfläche",null,{"$f":"SUM(C53:D55)","v":0},null,null,"(Fläche Berechnung Baukostenobergrenze)"]
[]
["Durchschnittl Wohnnutzfläche gem. § 3 Abs. 2 Z. 5 Neubauförderung:"]
["durchschnittl. WNF:",null,{"$f":"($C$53+$C$54)/(ROWS($B$14:$B$43)-COUNTIF($B$14:$B$43,\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C59>90, \"Wohnungsdurchschnitt zu groß\",\"förderbar\")","v":{"$error":"#DIV/0!"}}]
[]
["Prüfung Größen Freiflächen:",null,null,null,{"$f":"IF(SUM(H14:H43)>0,\"nicht förderbar\",\"förderbar\")","v":"förderbar"}]
[]
["Gesamtbeurteilung:",null,null,{"$f":"IF(E61=\"nicht förderbar\",\"Projekt nicht förderbar\",IF(I46=\"nicht förderbar\",\"Projekt nicht förderbar\",IF(I47=\"nicht förderbar\",\"Projekt nicht förderbar\",IF(AND(OR(I47=\"förderbar\",I47=0),OR(I48=\"förderbar\",I48=0),OR(I49=\"förderbar\",I49=0),OR(I50=\"förderbar\",I50=0),OR(D59=\"förderbar\",D59=0)),\"Projekt förderbar\",\"Projekt nicht förderbar\"))))","v":{"$error":"#DIV/0!"}}]