{"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":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[66,0,66,2],[67,4,67,5],[66,4,66,5],[7,2,7,7],[9,3,10,6],[64,0,64,2],[64,4,64,5],[63,4,63,5],[65,0,65,2],[65,4,65,5],[63,0,63,2],[9,7,11,7],[9,0,11,0],[9,1,11,1],[76,3,76,6],[76,0,76,2],[67,0,67,2],[72,0,72,1],[74,0,74,1],[68,4,68,5],[72,2,72,3],[68,0,68,2],[74,2,74,3],[73,2,73,3],[71,2,71,3],[73,0,73,1],[71,0,71,1]]}
[]
[]
[]
[]
[]
[]
[]
["Bauvorhaben:"]
[]
["Top Nr. ","Wohnfläche",null,"Freiflächen \n(Loggien, Balkone, Terrasse)",null,null,null,"Prüfung Wohnfläche "]
[]
[null,null,"Anzahl\nRäume","Loggien","Balkone","Terrassen","Freifläche ingesamt"]
[1,null,null,null,null,null,{"$f":"(IF(SUM(D13+E13+F13)<=8,(D13+E13+F13),\"nicht förderbar\"))","v":0},{"$f":"IF(B13=\"\",\"\",IF(AND(C13=1,B13<=38.5),B13,IF(AND(C13=2,B13<=55),B13,IF(AND(C13=3,B13<=77),B13,IF(AND(C13=4,B13<=93.5),B13,IF(AND(C13=5,B13<=104.5),B13,\"nicht förderbar\"))))))","v":""}]
[2,null,null,null,null,null,0,""]
[3,null,null,null,null,null,0,""]
[4,null,null,null,null,null,0,""]
[5,null,null,null,null,null,0,""]
[6,null,null,null,null,null,0,""]
[7,null,null,null,null,null,0,""]
[8,null,null,null,null,null,0,""]
[9,null,null,null,null,null,0,""]
[10,null,null,null,null,null,0,""]
[11,null,null,null,null,null,0,""]
[12,null,null,null,null,null,0,""]
[13,null,null,null,null,null,0,""]
[14,null,null,null,null,null,0,""]
[15,null,null,null,null,null,0,""]
[16,null,null,null,null,null,0,""]
[17,null,null,null,null,null,0,""]
[18,null,null,null,null,null,0,""]
[19,null,null,null,null,null,0,""]
[20,null,null,null,null,null,0,""]
[21,null,null,null,null,null,0,""]
[22,null,null,null,null,null,0,""]
[23,null,null,null,null,null,0,""]
[24,null,null,null,null,null,0,""]
[25,null,null,null,null,null,0,""]
[26,null,null,null,null,null,0,""]
[27,null,null,null,null,null,0,""]
[28,null,null,null,null,null,0,""]
[29,null,null,null,null,null,0,""]
[30,null,null,null,null,null,0,""]
[31,null,null,null,null,null,0,""]
[32,null,null,null,null,null,0,""]
[33,null,null,null,null,null,0,""]
[34,null,null,null,null,null,0,""]
[35,null,null,null,null,null,0,""]
[36,null,null,null,null,null,0,""]
[37,null,null,null,null,null,0,""]
[38,null,null,null,null,null,0,""]
[39,null,null,null,null,null,0,""]
[40,null,null,null,null,null,0,""]
[41,null,null,null,null,null,0,""]
[42,null,null,null,null,null,0,""]
[43,null,null,null,null,null,0,""]
[44,null,null,null,null,null,0,""]
[45,null,null,null,null,null,0,""]
[46,null,null,null,null,null,0,""]
[47,null,null,null,null,null,0,""]
[48,null,null,null,null,null,0,""]
[49,null,null,null,null,null,0,""]
[50,null,null,null,null,null,0,""]
[]
["Raumklassen gem. § 2 Abs. 2 Ziffer 1 Oö. Neubauförderungs-Verordnung",null,null,"WFL\nRaumklasse","Überschreitung",null,"Unterschreitung","Projekt förderungswürdig\n (nach Ausgleich)"]
["1- Raumwohnungen",null,null,{"$f":"SUM(IF(C13:C62=1,B13:B62,0))","v":0},{"$f":"IF(D65-((COUNTIF(C13:C62,1)*35))>0,D65-(COUNTIF(C13:C62,1))*35,0)","v":0},null,{"$f":" IF(D65-((COUNTIF(C13:C62,1)*35))<0,ABS(D65-(COUNTIF(C13:C62,1))*35),0)","v":0},{"$f":"IF(D65=0,0,IF((COUNTIF(C13:C62,1)*35)>=D65,\"förderbar\",\"nicht förderbar\"))","v":0}]
["2- Raumwohnungen",null,null,{"$f":"SUM(IF(C13:C62=2,B13:B62,0))","v":0},{"$f":"IF(D66-((COUNTIF(C13:C62,2)*50))>0,D66-(COUNTIF(C13:C62,2))*50,0)","v":0},null,{"$f":" IF(D66-((COUNTIF(C13:C62,2)*50))<0,ABS(D66-(COUNTIF(C13:C62,2))*50),0)","v":0},{"$f":"IF(D66=0,0,IF((COUNTIF(C13:C62,2)*50)>=D66,\"förderbar\",\"nicht förderbar\"))","v":0}]
["3- Raumwohnungen",null,null,{"$f":"SUM(IF(C13:C62=3,B13:B62,0))","v":0},{"$f":"IF(D67-((COUNTIF(C13:C62,3)*70))>0,D67-(COUNTIF(C13:C62,3))*70,0)","v":0},null,{"$f":"IF(D67-((COUNTIF(C13:C62,3)*70))<0,ABS(D67-(COUNTIF(C13:C62,3))*70),0)","v":0},{"$f":"IF(D67=0,0,IF((COUNTIF(C13:C62,3)*70)>=D67,\"förderbar\",\"nicht förderbar\"))","v":0}]
["4- Raumwohnungen",null,null,{"$f":"SUM(IF(C13:C62=4,B13:B62,0))","v":0},{"$f":"IF(D68-((COUNTIF(C13:C62,4)*85))>0,D68-(COUNTIF(C13:C62,4))*85,0)","v":0},null,{"$f":"IF(D68-((COUNTIF(C13:C62,4)*85))<0,ABS(D68-(COUNTIF(C13:C62,4))*85),0)","v":0},{"$f":"IF(D68=0,0,IF(E68=0,\"förderbar\",IF(E68<=(G66+G67+G65+G69),\"förderbar\",IF((COUNTIF(C13:C62,4)*85)*110%<D68,\"nicht förderbar\",IF(E68>(G66+G65+G67),\"fehlender Ausgleich bei 2- und 3 Raumwohnung\",IF(ABS(SUM(E68+E69))-ABS(SUM(G68+G69))<=ABS(SUM(G66+G65+G67)),\"förderbar\",\"fehlender Ausgleich bei 2- und 3 Raumwohnung\"))))))","v":0}]
["5- Raumwohnungen",null,null,{"$f":"SUM(IF(C13:C62=5,B13:B62,0))","v":0},{"$f":"IF(D69-((COUNTIF(C13:C62,5)*95))>0,D69-(COUNTIF(C13:C62,5))*95,0)","v":0},null,{"$f":"IF(D69-((COUNTIF(C13:C62,5)*95))<0,ABS(D69-(COUNTIF(C13:C62,5))*95),0)","v":0},{"$f":"IF(D69=0,0,IF(E69=0,\"förderbar\",IF(AND(E69<=(G65+G66+G67+G68),(E65+E66+E67+E68+E69)<=(G65+G66+G67+G68+G69)),\"förderbar\",IF((COUNTIF(C13:C62,5)*95)*110%<D69,\"nicht förderbar\",IF(E69>(G65+G66+G67),\"fehlender Ausgleich bei 2- und 3 Raumwohnung\",IF(ABS(SUM(E68+E69))-ABS(SUM(G68+G69))<=ABS(SUM(G65+G66+G67)),\"förderbar\",\"fehlender Ausgleich bei 2- und 3 Raumwohnung\"))))))","v":0}]
[" "]
["Flächenaufstellung"]
["Wohnfläche    ",null,{"$f":"SUM(B13:B62)","v":0},null,null,"(Fläche Berechnung Darlehen)"]
["Loggienfläche ",null,{"$f":"SUM(D13:D62)","v":0}]
["Balkon- und Terrassenfläche",null,{"$f":"SUM(E13:F62)","v":0}]
["Baukostenfläche",null,{"$f":"SUM(C72:D74)","v":0},null,null,"(Fläche Berechnung Baukostenobergrenze)"]
[]
["Gesamtbeurteilung:",null,null,{"$f":"IF(COUNTIF(G13:H62,\"nicht förderbar\")>0,\"Projekt nicht förderbar\",IF(H65=\"nicht förderbar\",\"Projekt nicht förderbar\",IF(H66=\"nicht förderbar\",\"Projekt nicht förderbar\",IF(AND(OR(H66=\"förderbar\",H66=0),OR(H67=\"förderbar\",H67=0),OR(H68=\"förderbar\",H68=0),OR(H69=\"förderbar\",H69=0)),\"Projekt förderbar\",\"Projekt nicht förderbar\"))))","v":"Projekt förderbar"}]