{"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":76,"n_cols":10,"rows_kept":76,"cut":false,"hidden":false,"merged":[[63,0,63,4],[7,2,7,7],[9,3,10,6],[9,7,11,7],[9,0,11,0],[9,1,11,1],[75,3,75,6],[75,0,75,2],[73,0,73,1],[73,2,73,3],[72,2,72,3],[72,0,72,1],[71,0,71,1],[64,0,64,2],[65,0,65,2],[66,0,66,2],[67,0,67,2],[68,0,68,2],[64,6,64,7],[65,6,65,7],[67,6,67,7],[68,6,68,7],[71,2,71,3]]}
[]
[]
[]
[]
[]
[]
[]
["Bauvorhaben:"]
[]
["Top Nr. ","Wohnfläche",null,"Freiflächen \n(Balkone, Terrassen)",null,null,null,"Prüfung Wohnfläche "]
[]
[null,null,"Anzahl\nRäume","Loggien\n(unzulässig)","Balkone","Terrassen","Freifläche ingesamt"]
[1,null,null,0,null,null,{"$f":"(IF(SUM(D13+E13+F13)<=6,(D13+E13+F13),\"nicht förderbar\"))","v":0},{"$f":"IF(B13=\"\",\"\",IF(AND(C13=1,B13<=30),B13,IF(AND(C13=2,B13<=45),B13,IF(AND(C13=3,B13<=65),B13,\"nicht förderbar\"))))","v":""}]
[2,null,null,null,null,null,{"$f":"(IF(SUM(D14+E14+F14)<=6,(D14+E14+F14),\"nicht förderbar\"))","v":0},{"$f":"IF(B14=\"\",\"\",IF(AND(C14=1,B14<=30),B14,IF(AND(C14=2,B14<=45),B14,IF(AND(C14=3,B14<=65),B14,\"nicht förderbar\"))))","v":""}]
[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,0,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,"",null,{"$f":"COUNTIF(G13:H62,\"nicht förderbar\")","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J62>0,\"C\",0)","v":0}]
["Überprüfung gemäß Oö. Junges-Wohnen-Verordnung:\n§ 2 Abs. 2 Z. 3   (Mindestanteil an 1- und 2-Raumwohnungen = 66,67 %)\n§ 10 Abs. 1 Z. 3 (Mindestwohnungsanzahl Gesamtprojekt = 12)"]
["Prozentuelle Aufteilung Wohnungen",null,null,"Anzahl\nWohnungen","%-Anteil\nam Projekt",null,"Überprüfung geforderter %-Anteil an 1- und 2-Raumwohnungen am Gesamtprojekt:"]
["1- Raumwohnungen",null,null,{"$f":"COUNTIF(C13:C62,1)","v":0},{"$f":"D66/D69","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D69<12,\"Wohnungsanzahl !\",IF((E66+E67)<=66.66%,\"Anteil 1- und 2-Raumwohnungen zu gering\",(E66+E67)))","v":"Wohnungsanzahl !"}]
["2- Raumwohnungen",null,null,{"$f":"COUNTIF(C13:C62,2)","v":0},{"$f":"D67/D69","v":{"$error":"#DIV/0!"}}]
["3- Raumwohnungen",null,null,{"$f":"COUNTIF(C13:C62,3)","v":0},{"$f":"D68/D69","v":{"$error":"#DIV/0!"}},null,"Überprüfung Anzahl errichteter Wohnungen:"]
["Summe Wohnungen",null,null,{"$f":"SUM(D66:D68)","v":0},{"$f":"IF(D69=0,\"\",D69/D69)","v":""},null,{"$f":"IF(D69=0,\"Wohnungsanzahl !\",IF(COUNT(C13:C62)<12,\"zu geringe Anzahl an Wohnungen\",\"förderbar\"))","v":"Wohnungsanzahl !"}]
[]
["Flächenaufstellung"]
["Wohnfläche    ",null,{"$f":"SUM(H13:H62)","v":0},null,null,"(Fläche Berechnung Darlehen)"]
["Balkone, Terrassen",null,{"$f":"SUM(G13:G62)","v":0}]
["Baukostenfläche",null,{"$f":"SUM(C72:D73)","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(D69>=12,IF(E66+E67>66.6%,\"Projekt förderbar\",\"Projekt nicht förderbar\"),\"Projekt nicht förderbar\"))","v":"Projekt nicht förderbar"}]