{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Mietkaufwohnungen","Tabelle1"],"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":"Mietkaufwohnungen","index":0,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[]
[]
[]
[]
[]
["Bauvorhaben:"]
[]
["Top Nr. ","Wohnfläche",null,"Freiflächen \n(Loggien, Balkone, Terrassen)",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<=Tabelle1!$C$2),B13,IF(AND(C13=2,B13<=Tabelle1!$C$3),B13,IF(AND(C13=3,B13<=Tabelle1!$C$4),B13,IF(AND(C13=4,B13<=Tabelle1!$C$5),B13,IF(AND(C13=5,B13<=Tabelle1!$C$6),B13,\"nicht förderbar\"))))))","v":""}]
[2,null,null,null,null,null,{"$f":"(IF(SUM(D14+E14+F14)<=8,(D14+E14+F14),\"nicht förderbar\"))","v":0},{"$f":"IF(B14=\"\",\"\",IF(AND(C14=1,B14<=Tabelle1!$C$2),B14,IF(AND(C14=2,B14<=Tabelle1!$C$3),B14,IF(AND(C14=3,B14<=Tabelle1!$C$4),B14,IF(AND(C14=4,B14<=Tabelle1!$C$5),B14,IF(AND(C14=5,B14<=Tabelle1!$C$6),B14,\"nicht förderbar\"))))))","v":""}]
[3,null,null,null,null,null,{"$f":"(IF(SUM(D15+E15+F15)<=8,(D15+E15+F15),\"nicht förderbar\"))","v":0},{"$f":"IF(B15=\"\",\"\",IF(AND(C15=1,B15<=Tabelle1!$C$2),B15,IF(AND(C15=2,B15<=Tabelle1!$C$3),B15,IF(AND(C15=3,B15<=Tabelle1!$C$4),B15,IF(AND(C15=4,B15<=Tabelle1!$C$5),B15,IF(AND(C15=5,B15<=Tabelle1!$C$6),B15,\"nicht förderbar\"))))))","v":""}]
[4,null,null,null,null,null,0,{"$f":"IF(B16=\"\",\"\",IF(AND(C16=1,B16<=Tabelle1!$C$2),B16,IF(AND(C16=2,B16<=Tabelle1!$C$3),B16,IF(AND(C16=3,B16<=Tabelle1!$C$4),B16,IF(AND(C16=4,B16<=Tabelle1!$C$5),B16,IF(AND(C16=5,B16<=Tabelle1!$C$6),B16,\"nicht förderbar\"))))))","v":""}]
[5,null,null,null,null,null,0,{"$f":"IF(B17=\"\",\"\",IF(AND(C17=1,B17<=Tabelle1!$C$2),B17,IF(AND(C17=2,B17<=Tabelle1!$C$3),B17,IF(AND(C17=3,B17<=Tabelle1!$C$4),B17,IF(AND(C17=4,B17<=Tabelle1!$C$5),B17,IF(AND(C17=5,B17<=Tabelle1!$C$6),B17,\"nicht förderbar\"))))))","v":""}]
[6,null,null,null,null,null,0,{"$f":"IF(B18=\"\",\"\",IF(AND(C18=1,B18<=Tabelle1!$C$2),B18,IF(AND(C18=2,B18<=Tabelle1!$C$3),B18,IF(AND(C18=3,B18<=Tabelle1!$C$4),B18,IF(AND(C18=4,B18<=Tabelle1!$C$5),B18,IF(AND(C18=5,B18<=Tabelle1!$C$6),B18,\"nicht förderbar\"))))))","v":""}]
[7,null,null,null,null,null,0,{"$f":"IF(B19=\"\",\"\",IF(AND(C19=1,B19<=Tabelle1!$C$2),B19,IF(AND(C19=2,B19<=Tabelle1!$C$3),B19,IF(AND(C19=3,B19<=Tabelle1!$C$4),B19,IF(AND(C19=4,B19<=Tabelle1!$C$5),B19,IF(AND(C19=5,B19<=Tabelle1!$C$6),B19,\"nicht förderbar\"))))))","v":""}]
[8,null,null,null,null,null,0,{"$f":"IF(B20=\"\",\"\",IF(AND(C20=1,B20<=Tabelle1!$C$2),B20,IF(AND(C20=2,B20<=Tabelle1!$C$3),B20,IF(AND(C20=3,B20<=Tabelle1!$C$4),B20,IF(AND(C20=4,B20<=Tabelle1!$C$5),B20,IF(AND(C20=5,B20<=Tabelle1!$C$6),B20,\"nicht förderbar\"))))))","v":""}]
[9,null,null,null,null,null,0,{"$f":"IF(B21=\"\",\"\",IF(AND(C21=1,B21<=Tabelle1!$C$2),B21,IF(AND(C21=2,B21<=Tabelle1!$C$3),B21,IF(AND(C21=3,B21<=Tabelle1!$C$4),B21,IF(AND(C21=4,B21<=Tabelle1!$C$5),B21,IF(AND(C21=5,B21<=Tabelle1!$C$6),B21,\"nicht förderbar\"))))))","v":""}]
[10,null,null,null,null,null,{"$f":"(IF(SUM(D22+E22+F22)<=8,(D22+E22+F22),\"nicht förderbar\"))","v":0},{"$f":"IF(B22=\"\",\"\",IF(AND(C22=1,B22<=Tabelle1!$C$2),B22,IF(AND(C22=2,B22<=Tabelle1!$C$3),B22,IF(AND(C22=3,B22<=Tabelle1!$C$4),B22,IF(AND(C22=4,B22<=Tabelle1!$C$5),B22,IF(AND(C22=5,B22<=Tabelle1!$C$6),B22,\"nicht förderbar\"))))))","v":""}]
[11,null,null,null,null,null,{"$f":"(IF(SUM(D23+E23+F23)<=8,(D23+E23+F23),\"nicht förderbar\"))","v":0},{"$f":"IF(B23=\"\",\"\",IF(AND(C23=1,B23<=Tabelle1!$C$2),B23,IF(AND(C23=2,B23<=Tabelle1!$C$3),B23,IF(AND(C23=3,B23<=Tabelle1!$C$4),B23,IF(AND(C23=4,B23<=Tabelle1!$C$5),B23,IF(AND(C23=5,B23<=Tabelle1!$C$6),B23,\"nicht förderbar\"))))))","v":""}]
[12,null,null,null,null,null,0,{"$f":"IF(B24=\"\",\"\",IF(AND(C24=1,B24<=Tabelle1!$C$2),B24,IF(AND(C24=2,B24<=Tabelle1!$C$3),B24,IF(AND(C24=3,B24<=Tabelle1!$C$4),B24,IF(AND(C24=4,B24<=Tabelle1!$C$5),B24,IF(AND(C24=5,B24<=Tabelle1!$C$6),B24,\"nicht förderbar\"))))))","v":""}]
[13,null,null,null,null,null,0,{"$f":"IF(B25=\"\",\"\",IF(AND(C25=1,B25<=Tabelle1!$C$2),B25,IF(AND(C25=2,B25<=Tabelle1!$C$3),B25,IF(AND(C25=3,B25<=Tabelle1!$C$4),B25,IF(AND(C25=4,B25<=Tabelle1!$C$5),B25,IF(AND(C25=5,B25<=Tabelle1!$C$6),B25,\"nicht förderbar\"))))))","v":""}]
[14,null,null,null,null,null,0,{"$f":"IF(B26=\"\",\"\",IF(AND(C26=1,B26<=Tabelle1!$C$2),B26,IF(AND(C26=2,B26<=Tabelle1!$C$3),B26,IF(AND(C26=3,B26<=Tabelle1!$C$4),B26,IF(AND(C26=4,B26<=Tabelle1!$C$5),B26,IF(AND(C26=5,B26<=Tabelle1!$C$6),B26,\"nicht förderbar\"))))))","v":""}]
[15,null,null,null,null,null,0,{"$f":"IF(B27=\"\",\"\",IF(AND(C27=1,B27<=Tabelle1!$C$2),B27,IF(AND(C27=2,B27<=Tabelle1!$C$3),B27,IF(AND(C27=3,B27<=Tabelle1!$C$4),B27,IF(AND(C27=4,B27<=Tabelle1!$C$5),B27,IF(AND(C27=5,B27<=Tabelle1!$C$6),B27,\"nicht förderbar\"))))))","v":""}]
[16,null,null,null,null,null,0,{"$f":"IF(B28=\"\",\"\",IF(AND(C28=1,B28<=Tabelle1!$C$2),B28,IF(AND(C28=2,B28<=Tabelle1!$C$3),B28,IF(AND(C28=3,B28<=Tabelle1!$C$4),B28,IF(AND(C28=4,B28<=Tabelle1!$C$5),B28,IF(AND(C28=5,B28<=Tabelle1!$C$6),B28,\"nicht förderbar\"))))))","v":""}]
[17,null,null,null,null,null,0,{"$f":"IF(B29=\"\",\"\",IF(AND(C29=1,B29<=Tabelle1!$C$2),B29,IF(AND(C29=2,B29<=Tabelle1!$C$3),B29,IF(AND(C29=3,B29<=Tabelle1!$C$4),B29,IF(AND(C29=4,B29<=Tabelle1!$C$5),B29,IF(AND(C29=5,B29<=Tabelle1!$C$6),B29,\"nicht förderbar\"))))))","v":""}]
[18,null,null,null,null,null,0,{"$f":"IF(B30=\"\",\"\",IF(AND(C30=1,B30<=Tabelle1!$C$2),B30,IF(AND(C30=2,B30<=Tabelle1!$C$3),B30,IF(AND(C30=3,B30<=Tabelle1!$C$4),B30,IF(AND(C30=4,B30<=Tabelle1!$C$5),B30,IF(AND(C30=5,B30<=Tabelle1!$C$6),B30,\"nicht förderbar\"))))))","v":""}]
[19,null,null,null,null,null,0,{"$f":"IF(B31=\"\",\"\",IF(AND(C31=1,B31<=Tabelle1!$C$2),B31,IF(AND(C31=2,B31<=Tabelle1!$C$3),B31,IF(AND(C31=3,B31<=Tabelle1!$C$4),B31,IF(AND(C31=4,B31<=Tabelle1!$C$5),B31,IF(AND(C31=5,B31<=Tabelle1!$C$6),B31,\"nicht förderbar\"))))))","v":""}]
[20,null,null,null,null,null,0,{"$f":"IF(B32=\"\",\"\",IF(AND(C32=1,B32<=Tabelle1!$C$2),B32,IF(AND(C32=2,B32<=Tabelle1!$C$3),B32,IF(AND(C32=3,B32<=Tabelle1!$C$4),B32,IF(AND(C32=4,B32<=Tabelle1!$C$5),B32,IF(AND(C32=5,B32<=Tabelle1!$C$6),B32,\"nicht förderbar\"))))))","v":""}]
[21,null,null,null,null,null,0,{"$f":"IF(B33=\"\",\"\",IF(AND(C33=1,B33<=Tabelle1!$C$2),B33,IF(AND(C33=2,B33<=Tabelle1!$C$3),B33,IF(AND(C33=3,B33<=Tabelle1!$C$4),B33,IF(AND(C33=4,B33<=Tabelle1!$C$5),B33,IF(AND(C33=5,B33<=Tabelle1!$C$6),B33,\"nicht förderbar\"))))))","v":""}]
[22,null,null,null,null,null,0,{"$f":"IF(B34=\"\",\"\",IF(AND(C34=1,B34<=Tabelle1!$C$2),B34,IF(AND(C34=2,B34<=Tabelle1!$C$3),B34,IF(AND(C34=3,B34<=Tabelle1!$C$4),B34,IF(AND(C34=4,B34<=Tabelle1!$C$5),B34,IF(AND(C34=5,B34<=Tabelle1!$C$6),B34,\"nicht förderbar\"))))))","v":""}]
[23,null,null,null,null,null,0,{"$f":"IF(B35=\"\",\"\",IF(AND(C35=1,B35<=Tabelle1!$C$2),B35,IF(AND(C35=2,B35<=Tabelle1!$C$3),B35,IF(AND(C35=3,B35<=Tabelle1!$C$4),B35,IF(AND(C35=4,B35<=Tabelle1!$C$5),B35,IF(AND(C35=5,B35<=Tabelle1!$C$6),B35,\"nicht förderbar\"))))))","v":""}]
[24,null,null,null,null,null,0,{"$f":"IF(B36=\"\",\"\",IF(AND(C36=1,B36<=Tabelle1!$C$2),B36,IF(AND(C36=2,B36<=Tabelle1!$C$3),B36,IF(AND(C36=3,B36<=Tabelle1!$C$4),B36,IF(AND(C36=4,B36<=Tabelle1!$C$5),B36,IF(AND(C36=5,B36<=Tabelle1!$C$6),B36,\"nicht förderbar\"))))))","v":""}]
[25,null,null,null,null,null,0,{"$f":"IF(B37=\"\",\"\",IF(AND(C37=1,B37<=Tabelle1!$C$2),B37,IF(AND(C37=2,B37<=Tabelle1!$C$3),B37,IF(AND(C37=3,B37<=Tabelle1!$C$4),B37,IF(AND(C37=4,B37<=Tabelle1!$C$5),B37,IF(AND(C37=5,B37<=Tabelle1!$C$6),B37,\"nicht förderbar\"))))))","v":""}]
[26,null,null,null,null,null,0,{"$f":"IF(B38=\"\",\"\",IF(AND(C38=1,B38<=Tabelle1!$C$2),B38,IF(AND(C38=2,B38<=Tabelle1!$C$3),B38,IF(AND(C38=3,B38<=Tabelle1!$C$4),B38,IF(AND(C38=4,B38<=Tabelle1!$C$5),B38,IF(AND(C38=5,B38<=Tabelle1!$C$6),B38,\"nicht förderbar\"))))))","v":""}]
[27,null,null,null,null,null,0,{"$f":"IF(B39=\"\",\"\",IF(AND(C39=1,B39<=Tabelle1!$C$2),B39,IF(AND(C39=2,B39<=Tabelle1!$C$3),B39,IF(AND(C39=3,B39<=Tabelle1!$C$4),B39,IF(AND(C39=4,B39<=Tabelle1!$C$5),B39,IF(AND(C39=5,B39<=Tabelle1!$C$6),B39,\"nicht förderbar\"))))))","v":""}]
[28,null,null,null,null,null,{"$f":"(IF(SUM(D40+E40+F40)<=8,(D40+E40+F40),\"nicht förderbar\"))","v":0},{"$f":"IF(B40=\"\",\"\",IF(AND(C40=1,B40<=Tabelle1!$C$2),B40,IF(AND(C40=2,B40<=Tabelle1!$C$3),B40,IF(AND(C40=3,B40<=Tabelle1!$C$4),B40,IF(AND(C40=4,B40<=Tabelle1!$C$5),B40,IF(AND(C40=5,B40<=Tabelle1!$C$6),B40,\"nicht förderbar\"))))))","v":""}]
[29,null,null,null,null,null,0,{"$f":"IF(B41=\"\",\"\",IF(AND(C41=1,B41<=Tabelle1!$C$2),B41,IF(AND(C41=2,B41<=Tabelle1!$C$3),B41,IF(AND(C41=3,B41<=Tabelle1!$C$4),B41,IF(AND(C41=4,B41<=Tabelle1!$C$5),B41,IF(AND(C41=5,B41<=Tabelle1!$C$6),B41,\"nicht förderbar\"))))))","v":""}]
[30,null,null,null,null,null,0,{"$f":"IF(B42=\"\",\"\",IF(AND(C42=1,B42<=Tabelle1!$C$2),B42,IF(AND(C42=2,B42<=Tabelle1!$C$3),B42,IF(AND(C42=3,B42<=Tabelle1!$C$4),B42,IF(AND(C42=4,B42<=Tabelle1!$C$5),B42,IF(AND(C42=5,B42<=Tabelle1!$C$6),B42,\"nicht förderbar\"))))))","v":""}]
[31,null,null,null,null,null,0,{"$f":"IF(B43=\"\",\"\",IF(AND(C43=1,B43<=Tabelle1!$C$2),B43,IF(AND(C43=2,B43<=Tabelle1!$C$3),B43,IF(AND(C43=3,B43<=Tabelle1!$C$4),B43,IF(AND(C43=4,B43<=Tabelle1!$C$5),B43,IF(AND(C43=5,B43<=Tabelle1!$C$6),B43,\"nicht förderbar\"))))))","v":""}]
[32,null,null,null,null,null,0,{"$f":"IF(B44=\"\",\"\",IF(AND(C44=1,B44<=Tabelle1!$C$2),B44,IF(AND(C44=2,B44<=Tabelle1!$C$3),B44,IF(AND(C44=3,B44<=Tabelle1!$C$4),B44,IF(AND(C44=4,B44<=Tabelle1!$C$5),B44,IF(AND(C44=5,B44<=Tabelle1!$C$6),B44,\"nicht förderbar\"))))))","v":""}]
[33,null,null,null,null,null,0,{"$f":"IF(B45=\"\",\"\",IF(AND(C45=1,B45<=Tabelle1!$C$2),B45,IF(AND(C45=2,B45<=Tabelle1!$C$3),B45,IF(AND(C45=3,B45<=Tabelle1!$C$4),B45,IF(AND(C45=4,B45<=Tabelle1!$C$5),B45,IF(AND(C45=5,B45<=Tabelle1!$C$6),B45,\"nicht förderbar\"))))))","v":""}]
[34,null,null,null,null,null,0,{"$f":"IF(B46=\"\",\"\",IF(AND(C46=1,B46<=Tabelle1!$C$2),B46,IF(AND(C46=2,B46<=Tabelle1!$C$3),B46,IF(AND(C46=3,B46<=Tabelle1!$C$4),B46,IF(AND(C46=4,B46<=Tabelle1!$C$5),B46,IF(AND(C46=5,B46<=Tabelle1!$C$6),B46,\"nicht förderbar\"))))))","v":""}]
[35,null,null,null,null,null,0,{"$f":"IF(B47=\"\",\"\",IF(AND(C47=1,B47<=Tabelle1!$C$2),B47,IF(AND(C47=2,B47<=Tabelle1!$C$3),B47,IF(AND(C47=3,B47<=Tabelle1!$C$4),B47,IF(AND(C47=4,B47<=Tabelle1!$C$5),B47,IF(AND(C47=5,B47<=Tabelle1!$C$6),B47,\"nicht förderbar\"))))))","v":""}]
[36,null,null,null,null,null,0,{"$f":"IF(B48=\"\",\"\",IF(AND(C48=1,B48<=Tabelle1!$C$2),B48,IF(AND(C48=2,B48<=Tabelle1!$C$3),B48,IF(AND(C48=3,B48<=Tabelle1!$C$4),B48,IF(AND(C48=4,B48<=Tabelle1!$C$5),B48,IF(AND(C48=5,B48<=Tabelle1!$C$6),B48,\"nicht förderbar\"))))))","v":""}]
[37,null,null,null,null,null,0,{"$f":"IF(B49=\"\",\"\",IF(AND(C49=1,B49<=Tabelle1!$C$2),B49,IF(AND(C49=2,B49<=Tabelle1!$C$3),B49,IF(AND(C49=3,B49<=Tabelle1!$C$4),B49,IF(AND(C49=4,B49<=Tabelle1!$C$5),B49,IF(AND(C49=5,B49<=Tabelle1!$C$6),B49,\"nicht förderbar\"))))))","v":""}]
[38,null,null,null,null,null,0,{"$f":"IF(B50=\"\",\"\",IF(AND(C50=1,B50<=Tabelle1!$C$2),B50,IF(AND(C50=2,B50<=Tabelle1!$C$3),B50,IF(AND(C50=3,B50<=Tabelle1!$C$4),B50,IF(AND(C50=4,B50<=Tabelle1!$C$5),B50,IF(AND(C50=5,B50<=Tabelle1!$C$6),B50,\"nicht förderbar\"))))))","v":""}]
[39,null,null,null,null,null,0,{"$f":"IF(B51=\"\",\"\",IF(AND(C51=1,B51<=Tabelle1!$C$2),B51,IF(AND(C51=2,B51<=Tabelle1!$C$3),B51,IF(AND(C51=3,B51<=Tabelle1!$C$4),B51,IF(AND(C51=4,B51<=Tabelle1!$C$5),B51,IF(AND(C51=5,B51<=Tabelle1!$C$6),B51,\"nicht förderbar\"))))))","v":""}]
[40,null,null,null,null,null,0,{"$f":"IF(B52=\"\",\"\",IF(AND(C52=1,B52<=Tabelle1!$C$2),B52,IF(AND(C52=2,B52<=Tabelle1!$C$3),B52,IF(AND(C52=3,B52<=Tabelle1!$C$4),B52,IF(AND(C52=4,B52<=Tabelle1!$C$5),B52,IF(AND(C52=5,B52<=Tabelle1!$C$6),B52,\"nicht förderbar\"))))))","v":""}]
[41,null,null,null,null,null,0,{"$f":"IF(B53=\"\",\"\",IF(AND(C53=1,B53<=Tabelle1!$C$2),B53,IF(AND(C53=2,B53<=Tabelle1!$C$3),B53,IF(AND(C53=3,B53<=Tabelle1!$C$4),B53,IF(AND(C53=4,B53<=Tabelle1!$C$5),B53,IF(AND(C53=5,B53<=Tabelle1!$C$6),B53,\"nicht förderbar\"))))))","v":""}]
[42,null,null,null,null,null,0,{"$f":"IF(B54=\"\",\"\",IF(AND(C54=1,B54<=Tabelle1!$C$2),B54,IF(AND(C54=2,B54<=Tabelle1!$C$3),B54,IF(AND(C54=3,B54<=Tabelle1!$C$4),B54,IF(AND(C54=4,B54<=Tabelle1!$C$5),B54,IF(AND(C54=5,B54<=Tabelle1!$C$6),B54,\"nicht förderbar\"))))))","v":""}]
[43,null,null,null,null,null,0,{"$f":"IF(B55=\"\",\"\",IF(AND(C55=1,B55<=Tabelle1!$C$2),B55,IF(AND(C55=2,B55<=Tabelle1!$C$3),B55,IF(AND(C55=3,B55<=Tabelle1!$C$4),B55,IF(AND(C55=4,B55<=Tabelle1!$C$5),B55,IF(AND(C55=5,B55<=Tabelle1!$C$6),B55,\"nicht förderbar\"))))))","v":""}]
[44,null,null,null,null,null,0,{"$f":"IF(B56=\"\",\"\",IF(AND(C56=1,B56<=Tabelle1!$C$2),B56,IF(AND(C56=2,B56<=Tabelle1!$C$3),B56,IF(AND(C56=3,B56<=Tabelle1!$C$4),B56,IF(AND(C56=4,B56<=Tabelle1!$C$5),B56,IF(AND(C56=5,B56<=Tabelle1!$C$6),B56,\"nicht förderbar\"))))))","v":""}]
[45,null,null,null,null,null,0,{"$f":"IF(B57=\"\",\"\",IF(AND(C57=1,B57<=Tabelle1!$C$2),B57,IF(AND(C57=2,B57<=Tabelle1!$C$3),B57,IF(AND(C57=3,B57<=Tabelle1!$C$4),B57,IF(AND(C57=4,B57<=Tabelle1!$C$5),B57,IF(AND(C57=5,B57<=Tabelle1!$C$6),B57,\"nicht förderbar\"))))))","v":""}]
[46,null,null,null,null,null,0,{"$f":"IF(B58=\"\",\"\",IF(AND(C58=1,B58<=Tabelle1!$C$2),B58,IF(AND(C58=2,B58<=Tabelle1!$C$3),B58,IF(AND(C58=3,B58<=Tabelle1!$C$4),B58,IF(AND(C58=4,B58<=Tabelle1!$C$5),B58,IF(AND(C58=5,B58<=Tabelle1!$C$6),B58,\"nicht förderbar\"))))))","v":""}]
[47,null,null,null,null,null,0,{"$f":"IF(B59=\"\",\"\",IF(AND(C59=1,B59<=Tabelle1!$C$2),B59,IF(AND(C59=2,B59<=Tabelle1!$C$3),B59,IF(AND(C59=3,B59<=Tabelle1!$C$4),B59,IF(AND(C59=4,B59<=Tabelle1!$C$5),B59,IF(AND(C59=5,B59<=Tabelle1!$C$6),B59,\"nicht förderbar\"))))))","v":""}]
[48,null,null,null,null,null,0,{"$f":"IF(B60=\"\",\"\",IF(AND(C60=1,B60<=Tabelle1!$C$2),B60,IF(AND(C60=2,B60<=Tabelle1!$C$3),B60,IF(AND(C60=3,B60<=Tabelle1!$C$4),B60,IF(AND(C60=4,B60<=Tabelle1!$C$5),B60,IF(AND(C60=5,B60<=Tabelle1!$C$6),B60,\"nicht förderbar\"))))))","v":""}]
[49,null,null,null,null,null,0,{"$f":"IF(B61=\"\",\"\",IF(AND(C61=1,B61<=Tabelle1!$C$2),B61,IF(AND(C61=2,B61<=Tabelle1!$C$3),B61,IF(AND(C61=3,B61<=Tabelle1!$C$4),B61,IF(AND(C61=4,B61<=Tabelle1!$C$5),B61,IF(AND(C61=5,B61<=Tabelle1!$C$6),B61,\"nicht förderbar\"))))))","v":""}]
[50,null,null,null,null,null,0,{"$f":"IF(B62=\"\",\"\",IF(AND(C62=1,B62<=Tabelle1!$C$2),B62,IF(AND(C62=2,B62<=Tabelle1!$C$3),B62,IF(AND(C62=3,B62<=Tabelle1!$C$4),B62,IF(AND(C62=4,B62<=Tabelle1!$C$5),B62,IF(AND(C62=5,B62<=Tabelle1!$C$6),B62,\"nicht förderbar\"))))))","v":""}]
[]
["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)*75))>0,D67-(COUNTIF(C13:C62,3))*75,0)","v":0},null,{"$f":"IF(D67-((COUNTIF(C13:C62,3)*75))<0,ABS(D67-(COUNTIF(C13:C62,3))*75),0)","v":0},{"$f":"IF(D67=0,0,IF((COUNTIF(C13:C62,3)*75)>=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)*90))>0,D68-(COUNTIF(C13:C62,4))*90,0)","v":0},null,{"$f":"IF(D68-((COUNTIF(C13:C62,4)*90))<0,ABS(D68-(COUNTIF(C13:C62,4))*90),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)*90)*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)*100))>0,D69-(COUNTIF(C13:C62,5))*100,0)","v":0},null,{"$f":"IF(D69-((COUNTIF(C13:C62,5)*100))<0,ABS(D69-(COUNTIF(C13:C62,5))*100),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)*100)*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"}]

{"sheet":"Tabelle1","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["MK-RK","m2","Ü-m2"]
[1,35,{"$f":"B2*1.1","v":38.5}]
[2,50,{"$f":"B3*1.1","v":55.000000000000007}]
[3,75,82.5]
[4,90,99.000000000000014]
[5,100,110.00000000000001]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"85*1.1","v":93.500000000000014}]