{"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":70,"n_cols":9,"rows_kept":70,"cut":false,"hidden":false,"merged":[[64,3,64,4],[64,0,64,1],[69,4,69,7],[69,0,69,3],[65,0,65,1],[67,0,67,1],[65,3,65,4],[67,3,67,4],[66,3,66,4],[7,2,7,8],[8,0,8,8],[9,2,11,2],[9,4,10,7],[9,8,11,8],[9,0,11,0],[9,1,11,1]]}
[]
[]
[]
[]
[]
[]
[]
["Bauvorhaben:"]
["Abbruch- und Neubau, Einbau und Zubau von Wohnungen"]
["Top Nr. ","Wohnfläche","Zubau oder\nEinbau von\nWohnungen in / an das bestende\nGebäude",null,"Freiflächen \n(Loggien, Balkone, Terrassen)",null,null,null,"Prüfung Wohnfläche "]
[]
[null,null,null,"Anzahl\nRäume","Loggien","Balkone","Terrassen","Freifläche ingesamt"]
[1,null,null,null,null,null,null,{"$f":"(IF(SUM(E13+F13+G13)<=8,(E13+F13+G13),\"nicht förderbar\"))","v":0},{"$f":"IF(B13=\"\",\"\",IF(AND(D13=1,C13=\"ja\",B13<=35*1.1),B13,IF(AND(D13=1,C13=\"nein\",B13<=35),B13,IF(AND(D13=2,C13=\"ja\",B13<=55),B13,IF(AND(D13=2,C13=\"nein\",B13<=50),B13,IF(AND(D13=3,C13=\"ja\",B13<=77),B13,IF(AND(D13=3,C13=\"nein\",B13<=70),B13,IF(AND(D13=4,C13=\"ja\",B13<=93.5),B13,IF(AND(D13=4,C13=\"nein\",B13<=85),B13,IF(AND(D13=5,C13=\"ja\",B13<=104.5),B13,IF(AND(D13=5,C13=\"nein\",B13<=95),B13,\"nicht förderbar\")))))))))))","v":""}]
[2,null,null,null,null,null,null,0,{"$f":"IF(B14=\"\",\"\",IF(AND(D14=1,C14=\"ja\",B14<=35*1.1),B14,IF(AND(D14=1,C14=\"nein\",B14<=35),B14,IF(AND(D14=2,C14=\"ja\",B14<=55),B14,IF(AND(D14=2,C14=\"nein\",B14<=50),B14,IF(AND(D14=3,C14=\"ja\",B14<=77),B14,IF(AND(D14=3,C14=\"nein\",B14<=70),B14,IF(AND(D14=4,C14=\"ja\",B14<=93.5),B14,IF(AND(D14=4,C14=\"nein\",B14<=85),B14,IF(AND(D14=5,C14=\"ja\",B14<=104.5),B14,IF(AND(D14=5,C14=\"nein\",B14<=95),B14,\"nicht förderbar\")))))))))))","v":""}]
[3,null,null,null,null,null,null,0,""]
[4,null,null,null,null,null,null,0,""]
[5,null,null,null,null,null,null,0,""]
[6,null,null,null,null,null,null,0,""]
[7,null,null,null,null,null,null,0,""]
[8,null,null,null,null,null,null,0,""]
[9,null,null,null,null,null,null,0,""]
[10,null,null,null,null,null,null,0,""]
[11,null,null,null,null,null,null,0,""]
[12,null,null,null,null,null,null,0,""]
[13,null,null,null,null,null,null,0,""]
[14,null,null,null,null,null,null,0,""]
[15,null,null,null,null,null,null,0,""]
[16,null,null,null,null,null,null,0,""]
[17,null,null,null,null,null,null,0,""]
[18,null,null,null,null,null,null,0,""]
[19,null,null,null,null,null,null,0,""]
[20,null,null,null,null,null,null,0,""]
[21,null,null,null,null,null,null,0,""]
[22,null,null,null,null,null,null,0,""]
[23,null,null,null,null,null,null,0,""]
[24,null,null,null,null,null,null,0,""]
[25,null,null,null,null,null,null,0,""]
[26,null,null,null,null,null,null,0,""]
[27,null,null,null,null,null,null,0,""]
[28,null,null,null,null,null,null,0,""]
[29,null,null,null,null,null,null,0,""]
[30,null,null,null,null,null,null,0,""]
[31,null,null,null,null,null,null,0,""]
[32,null,null,null,null,null,null,0,""]
[33,null,null,null,null,null,null,0,""]
[34,null,null,null,null,null,null,0,""]
[35,null,null,null,null,null,null,0,""]
[36,null,null,null,null,null,null,0,""]
[37,null,null,null,null,null,null,0,""]
[38,null,null,null,null,null,null,0,""]
[39,null,null,null,null,null,null,0,""]
[40,null,null,null,null,null,null,0,""]
[41,null,null,null,null,null,null,0,""]
[42,null,null,null,null,null,null,0,""]
[43,null,null,null,null,null,null,0,""]
[44,null,null,null,null,null,null,0,""]
[45,null,null,null,null,null,null,0,""]
[46,null,null,null,null,null,null,0,""]
[47,null,null,null,null,null,null,0,""]
[48,null,null,null,null,null,null,0,""]
[49,null,null,null,null,null,null,0,""]
[50,null,null,null,null,null,null,0,""]
[]
["Flächenaufstellung"]
["Wohnfläche    ",null,null,{"$f":"SUM(B13:B62)","v":0},null,null,"(Fläche Berechnung Darlehen)"]
["Loggienfläche ",null,null,{"$f":"SUM(E13:E62)","v":0}]
["Balkon- und Terrassenfläche",null,null,{"$f":"SUM(F13:G62)","v":0}]
["Baukostenfläche",null,null,{"$f":"SUM(D65:E67)","v":0},null,null,"(Fläche Berechnung Baukostenobergrenze)"]
[]
["Gesamtbeurteilung:",null,null,null,{"$f":"IF(COUNTIF(H13:I62,\"nicht förderbar\")>0,\"Projekt nicht förderbar\",\"Projekt förderbar\")","v":"Projekt förderbar"}]