{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Antrag","Grundstück","Gebäude","Gebäude Teil 2","Kosten und Finanzierung","Wirtschaftlichkeitsberechnung","Erklärungen","Erklärungen Teil 2","Anlage Berechnung Förderbetrag","Anlage Klimabonus","Checkliste","Tabelle1","Änderungsübersicht"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":14,"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":"Antrag","index":0,"n_rows":72,"n_cols":46,"rows_kept":72,"cut":false,"hidden":false,"merged":[[7,3,8,11],[22,22,22,36],[24,22,24,36],[13,22,13,36],[11,22,11,36],[36,4,36,26],[10,20,10,21],[31,28,34,31],[15,3,15,18],[38,9,38,11],[37,28,39,31],[39,17,41,26],[11,3,11,18],[13,3,13,18],[17,3,17,18],[22,3,22,18],[28,3,29,23],[24,3,24,18],[33,24,34,27],[37,6,37,8],[71,30,71,36],[56,4,56,26],[50,28,50,31],[43,28,43,31],[60,14,60,16],[43,33,43,35],[45,4,45,26],[64,28,64,31],[56,33,62,35],[60,5,60,8],[57,18,57,21],[58,18,58,21],[43,4,43,27],[52,4,52,27],[41,33,41,35],[31,33,34,35],[36,33,39,35],[46,28,48,31],[52,33,52,35],[36,28,36,31],[41,28,41,31],[47,0,69,0],[61,1,61,7],[61,14,61,16],[64,4,64,26],[64,33,64,35],[50,33,50,35],[45,33,48,35],[52,28,52,31],[48,17,50,26],[45,28,45,31],[56,28,62,31],[47,9,47,11],[46,6,46,8],[54,4,54,26],[54,28,54,31],[54,33,54,35]]}
[]
[]
[null,null,null,"Antrag auf     "]
[null,null,null,"Mietwohnungsbauförderung"]
[null,null,null,"Haushalte mit geringem o. mittlerem Einkommen"]
[]
[null,null,null,"Antragsnummer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 Jahre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effi 70",false,null,"20 Jahre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 Jahre"]
[null,null,null,"1. Antragsteller / in ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 a. Betreuer / in oder Beauftragte / r",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2,false]
[null,null,null,"Name, Vorname / Firma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name, Vorname / Firma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4,false]
[null,null,null,"Straße, Hausnummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telefon / Beruf / Titel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"PLZ       Ort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,null,"Telefon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 Jahre Zins",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Jahre lauf",false]
[]
[null,null,null,"2. Bauort / Grundstück",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 b. Korrespondenzadresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 Plus","10 Jahre","10 Jahre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Jahre lauf",false,null,40,"20 Jahre","25 Jahre"]
[null,null,null,"PLZ",null,"Ort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLZ",null,"Ort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,"35 Jahre"]
[]
[null,null,null,"Straße, Hausnummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straße, Hausnummer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,4]
[]
[]
[null,null,null,{"$f":"IF(AND(AP9=TRUE,AP14=TRUE,AP11=FALSE,AP12=FALSE,AP13=FALSE),\"Diese Kombination ist nicht zulässig\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G47:I47)=0,0,1)","v":0},{"$f":"IF(AS7=4,0,1)","v":0},{"$f":"IF(AC46=\"\",0,1)","v":1},{"$f":"SUM(AQ29:AS29)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G38:I38)=0,0,1)","v":0},{"$f":"IF(AR7=4,0,1)","v":0},{"$f":"IF(AC37=\"\",0,1)","v":1},{"$f":"SUM(AQ30:AS30)","v":1}]
[]
[null," 4.",null,"Für das vorstehend bezeichnete und in den Anlagen näher beschriebene ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beträge €",null,null,null,null,"tilgungs-freie Jahre",null,null,null,null,null,null,null,{"$f":"IF(AT30=3,\"\",\"Bitte \")","v":"Bitte "},{"$f":"IF(AQ30=1,\"\",\"Eingabe WE auf Seite 3 tätigen, \")","v":"Eingabe WE auf Seite 3 tätigen, "},{"$f":"IF(AR30=1,\"\",\"Bindungsdauer wählen, \")","v":"Bindungsdauer wählen, "},{"$f":"IF(AS30=1,\"\",\"Darlehenshöhe mit Anlage ermitteln\")","v":""},{"$f":"IF(AT30>0,CONCATENATE(AP32,AQ32,AR32,AS32),\"\")","v":"Bitte Eingabe WE auf Seite 3 tätigen, Bindungsdauer wählen, "}]
[null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bitte ",{"$f":"IF(AQ31=1,\"\",\"Eingabe WE auf S. 3 tätigen, \")","v":"Eingabe WE auf S. 3 tätigen, "},{"$f":"IF(AR31=1,\"\",\"Bindungsdauer wählen, \")","v":"Bindungsdauer wählen, "},{"$f":"IF(AS31=1,\"\",\"Darlehenshöhe eingeben\")","v":"Darlehenshöhe eingeben"},{"$f":"IF(AT31>0,CONCATENATE(AP33,AQ33,AR33,AS33),\"\")","v":""}]
[null,null,null,"Förderobjekt/Bauvorhaben wird/werden beantragt:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AT29=3,\"\",\"Bitte \")","v":"Bitte "},{"$f":"IF(AQ29=1,\"\",\"Eingabe WE auf Seite 3 tätigen, \")","v":"Eingabe WE auf Seite 3 tätigen, "},{"$f":"IF(AR29=1,\"\",\"Bindungsdauer wählen, \")","v":"Bindungsdauer wählen, "},{"$f":"IF(AS29=1,\"\",\"Darlehenshöhe mit Anlage ermitteln\")","v":""},{"$f":"IF(AT29>0,CONCATENATE(AP34,AQ34,AR34,AS34),\"\")","v":"Bitte Eingabe WE auf Seite 3 tätigen, Bindungsdauer wählen, "}]
[]
[]
[null," 4.1",null,null,"Baudarlehen \"Geringe Einkommen\" *1 (ggf. mit Bürgschaft des Landes Hessen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP11=TRUE,'Anlage Berechnung Förderbetrag'!K39,0)","v":0},null,null,null,"*2"]
[null,null,null,null,"für",null,{"$f":"IF(SUM(Gebäude!AA52,Gebäude!AA56)=0,\"\",SUM(Gebäude!AA52,Gebäude!AA56))","v":""},null,null,null,"Wohnungen, davon mit mittelbarer Belegung gemäß",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC37=\"\",\"\",ROUNDDOWN(AC37,-2))","v":0}]
[null,null,null,null,"§ 22 HWoFG",null,null,null,null,{"$f":"IF(Gebäude!AA56=\"\",\"\",Gebäude!AA56)","v":""},null,null,null,"Wohnungen"]
[null,null,null,null,"Bindung",null,null,{"$f":"IF(AR7=1,15,IF(AR7=2,20,IF(AR7=3,25,\"\")))","v":""},"Jahre ",null,null,null,null,null,null,null,null,{"$f":"IF(AT30=0,\"\",IF(AT30>0,AT32))","v":"Bitte Eingabe WE auf Seite 3 tätigen, Bindungsdauer wählen, "}]
[]
[null,null,null,null,"ergänzender Finanzierungszuschuss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SUM(G38:I38)=0,AR7=4),\"\",IF(AR7=1,AC38*0.2,IF(AR7=2,AC38*0.3,IF(AR7=3,AC38*0.4,\"\"))))","v":""}]
[]
[null," 4.11",null,null,"Zuschlag \"Großer Frankfurter Bogen\" *1(hierauf wird kein Finanzierungszuschuss gewährt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP15=TRUE,SUM(G38*10000),\"\")","v":""}]
[]
[null," 4.2",null,null,"Baudarlehen \"Mittlere Einkommen\" *1 (ggf. mit Bürgschaft des Landes Hessen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP12=TRUE,'Anlage Berechnung Förderbetrag'!K41,0)","v":0},null,null,null,"*2"]
[null,null,null,null,"für ",null,{"$f":"IF(SUM(Gebäude!AA50,Gebäude!AA54)=0,\"\",SUM(Gebäude!AA50,Gebäude!AA54))","v":""},null,null,null,"Wohnungen, davon mit mittelbarer Belegung gemäß",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC46=\"\",\"\",ROUNDDOWN(AC46,-2))","v":0}]
["Antragsvordruck: Stand 01.03.2023",null,null,null,"§ 22 HWoFG",null,null,null,null,{"$f":"IF(Gebäude!AA54=\"\",\"\",Gebäude!AA54)","v":""},null,null,null,"Wohnungen"]
[null,null,null,null,"Bindung",null,null,{"$f":"IF(AS7=1,15,IF(AS7=2,20,IF(AS7=3,25,\"\")))","v":""},"Jahre ",null,null,null,null,null,null,null,null,{"$f":"IF(AT29=0,\"\",IF(AT29>0,AT34))","v":"Bitte Eingabe WE auf Seite 3 tätigen, Bindungsdauer wählen, "}]
[]
[null,null,null,null,"ergänzender Finanzierungszuschuss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SUM(G47:I47)=0,AS7=4),\"\",IF(AS7=1,AC47*0.2,IF(AS7=2,AC47*0.25,IF(AS7=3,AC47*0.3,\"\"))))","v":""}]
[]
[null," 4.21",null,null,"Zuschlag \"Großer Frankfurter Bogen\" *1(hierauf wird kein Finanzierungszuschuss gewährt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP16=TRUE,SUM(G47*6000),\"\")","v":""}]
[null,null,null,null,"*1","inkl. Zinszuschuss des Landes Hessen"]
[null," 4.3",null,null,"Zuschuss aus dem Sonderprogramm \"Klimabonus\" (s. Reiter \"Anlage Klimabonus\")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP17=TRUE,'Anlage Klimabonus'!G24,0)","v":0}]
[]
[null," 4.4",null,null,"KfW-Darlehen \"KFN Klimafreundlicher Neubau Wohngebäude\""]
[null,null,null,null,"davon für energet. Fachplanung/Baubegleitung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR"]
[null,null,null,null,"davon für Zertifizierung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KFWG "]
[null,null,null,null,"(ggf. mit Bürgschaft des Landes Hessen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KFWG-Q"]
[null,null,null,null,null,null,null,null,null,"Effizienzhaus:",null,null,null,null,{"$f":"IF(AQ26=1,AQ59,IF(AQ26=2,AQ60,IF(AQ26=3,AQ61,IF(AQ26=4,AQ62,IF(AQ26=5,AQ63,IF(AQ26=6,AQ64,IF(AQ26=7,AQ65,\"\")))))))","v":0},null,null,"Typ"]
[null,null,null,null,null,null,null,null,null,"Darlehenslaufzeit:  ",null,null,null,null,{"$f":"IF(AS26=1,10,IF(AS26=2,25,IF(AS26=3,35,IF(AS26=4,\"\"))))","v":""},null,null,"Jahre"]
[null,null,null,null,"mit Zinszuschuss aus dem Hessischen Energieeffizienzprogramm"]
[]
[null," 4.5"]
[null,null,null,null,"(ggf. mit Bürgschaft des Landes Hessen)"]
[]
[null,null,null,"*2","Bitte zuerst die Angaben auf den Seiten 3 / 3a ergänzen. Anschließend kann der mögliche Förderbetrag"]
[null,null,null,null,"mit Hilfe der \"Anlage Berechnung Förderbetrag\" berechnet werden. "]
[]
[]
[null,"Antragsteller:",null,null,null,{"$f":"IF(D12=\"\",\"\",CONCATENATE(D12,\"  \",W23))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 1  von Seite 8"]

{"sheet":"Grundstück","index":1,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[12,4,12,9],[12,10,12,12],[11,2,11,3],[10,2,10,3],[9,10,9,12],[10,4,10,9],[12,2,12,3],[9,2,9,3],[10,10,10,12],[11,4,11,9],[11,10,11,12],[9,4,9,9],[3,5,3,13],[7,4,7,9],[8,4,8,9],[8,10,8,12],[8,2,8,3],[7,2,7,3],[5,5,5,13],[37,11,37,12],[22,2,22,5],[22,6,22,8],[31,12,31,13],[27,3,27,4],[25,3,25,8],[25,11,25,13],[22,12,22,13],[28,3,28,4],[29,3,29,4],[22,9,22,11],[28,12,28,13],[29,12,29,13],[37,2,37,4],[27,12,27,13],[36,0,42,0],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,2,41,4],[41,5,41,8],[41,9,41,10],[41,11,41,12],[38,9,38,10],[39,9,39,10],[37,5,37,8],[37,9,37,10],[36,11,36,12],[36,2,36,4],[36,5,36,8],[36,9,36,10],[44,3,44,9],[40,2,40,4],[38,5,38,8],[39,5,39,8],[40,5,40,8],[40,9,40,10],[38,2,38,4],[39,2,39,4]]}
[]
[null," 5.","Miteigentumsverhältnisse"]
[]
[null,null,"Rechtsform",null," "]
[]
[null,null,"Vermögensverhältnisse"]
[]
[null,null,"Personen",null,"  Name",null,null,null,null,null,"  Vorname",null,null," Geburtsdatum"]
[null,null,"Antragsteller 1"]
[null,null,"Antragsteller 2"]
[null,null,"Antragsteller 3"]
[null,null,"Antragsteller 4"]
[null,null,"Antragsteller 5"]
[]
[null,null,"Aktuelle Einkommens- und Vermögensauskünfte, Steuerbescheide der letzten drei Jahre mit entsprechenden Steuererklärungen, "]
[null,null,"Verdienstbescheinigungen des Arbeitgebers bitte zur Prüfung der Kreditwürdigkeit beifügen."]
[null,null,"Bei juristischen Personen ist ein aktueller Handelsregisterauszug oder ein anderer Nachweis der Vertretungsberechtigung "]
[null,null,"einzureichen. Im Falle der Bilanzierung bitte geprüfte Bilanzen der letzten drei Jahre beifügen."]
[]
[]
[null," 6.","Ergänzende Angaben zum Bauort/Grundstück"]
[]
[null," 6.1","Kaufvertrag abgeschlossen am:",null,null,null,null,null,null,"Erbbaurecht bestellt bis zum Jahr:"]
[]
[null," 6.2","eingetragen beim Amtsgericht"]
[null,null,"in",null,null,null,null,null,null,"    im Grundbuch von"]
[]
[null,null,"Blatt",null,null,null,"Flur",null,null,"Flurstück",null,"Größe",null,null,"m²"]
[null,null,"Blatt",null,null,null,"Flur",null,null,"Flurstück",null,"Größe",null,null,"m²"]
[null,null,"Blatt",null,null,null,"Flur",null,null,"Flurstück",null,"Größe",null,null,"m²"]
[]
[null,"6.3","Größe des Baugrundstückes:",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(M28:N30)=0,\"\",SUM(M28:N30))","v":""},null,"m²"]
[]
[]
[null,"6.4","Bestehende Objektfinanzierungsmittel (vor-, gleich- und nachrangige)"]
[]
[{"$f":"TODAY()","v":"2023-07-17"},null,"Darlehensgeber",null,null,"Nominalkapital (€)",null,null,null,"Restkapital (€)",null,"Sollzinssatz (%)",null,"Tilgungssatz (%)"]
[null,"6.4.1"]
[null,"6.4.2"]
[null,"6.4.3"]
[null,"6.4.4"]
[null,"6.4.5"]
[]
[]
[null,"Antragsteller:",null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,"Seite 2 von Seite 8"]

{"sheet":"Gebäude","index":2,"n_rows":72,"n_cols":69,"rows_kept":72,"cut":false,"hidden":false,"merged":[[53,27,53,30],[57,37,57,38],[11,49,13,49],[49,36,49,37],[47,27,47,30],[37,27,37,30],[55,27,55,30],[57,27,57,30],[11,42,13,42],[23,26,23,27],[21,26,21,27],[20,29,20,30],[22,26,22,27],[20,26,20,27],[25,29,25,30],[24,29,24,30],[23,29,23,30],[25,26,25,27],[53,47,53,48],[55,47,55,48],[57,47,57,48],[11,47,13,47],[11,46,13,46],[49,27,49,30],[18,2,18,3],[14,5,14,6],[39,27,39,30],[41,27,41,30],[43,27,43,30],[45,27,45,30],[28,29,28,30],[27,26,27,27],[24,8,24,9],[26,29,26,30],[28,21,28,22],[26,26,26,27],[26,8,26,9],[24,13,24,14],[16,8,16,9],[16,13,16,14],[25,11,25,12],[23,13,23,14],[23,11,23,12],[16,11,16,12],[26,13,26,14],[19,13,19,14],[26,5,26,6],[22,13,22,14],[59,26,59,28],[59,23,59,24],[59,16,59,22],[29,29,29,30],[51,27,51,30],[33,27,33,30],[55,22,55,23],[57,20,57,21],[43,22,43,23],[35,20,35,21],[33,22,33,23],[33,20,33,21],[57,22,57,23],[45,20,45,21],[29,21,29,22],[47,20,47,21],[47,22,47,23],[35,27,35,30],[35,16,35,19],[35,22,35,23],[47,16,47,19],[51,20,51,21],[53,16,53,19],[45,22,45,23],[28,2,28,3],[68,2,68,7],[65,8,65,13],[67,8,67,13],[68,8,68,13],[66,8,66,13],[65,2,65,7],[66,2,66,7],[67,2,67,7],[29,13,29,14],[67,14,67,18],[65,14,65,18],[57,14,57,15],[45,14,45,15],[47,14,47,15],[59,14,59,15],[29,8,29,9],[28,8,28,9],[28,11,28,12],[28,13,28,14],[29,2,29,3],[41,2,41,13],[28,5,28,6],[35,14,35,15],[7,47,8,50],[11,50,13,50],[13,26,13,27],[14,26,14,27],[17,2,17,3],[14,11,14,12],[14,21,14,22],[13,21,13,22],[11,17,13,17],[11,19,13,19],[12,13,13,14],[16,26,16,27],[17,26,17,27],[16,2,16,3],[11,2,13,3],[12,8,13,9],[17,8,17,9],[11,4,11,12],[12,7,13,7],[12,11,13,12],[12,4,13,4],[14,8,14,9],[12,10,13,10],[12,5,13,6],[4,28,4,30],[14,13,14,14],[9,15,10,19],[11,16,13,16],[11,28,12,30],[11,20,11,27],[13,29,13,30],[11,18,13,18],[12,23,12,25],[7,14,7,18],[14,29,14,30],[12,20,12,22],[12,26,12,27],[11,15,13,15],[20,2,20,3],[27,2,27,3],[22,2,22,3],[21,8,21,9],[24,2,24,3],[26,2,26,3],[25,8,25,9],[11,63,13,63],[11,62,13,62],[11,55,13,55],[11,56,13,56],[11,43,13,43],[11,53,13,53],[11,48,13,48],[14,2,14,3],[25,2,25,3],[21,2,21,3],[24,5,24,6],[23,2,23,3],[22,5,22,6],[23,5,23,6],[15,2,15,3],[15,5,15,6],[25,5,25,6],[20,21,20,22],[31,20,31,23],[26,11,26,12],[27,11,27,12],[21,11,21,12],[24,11,24,12],[22,8,22,9],[20,5,20,6],[20,8,20,9],[20,11,20,12],[21,5,21,6],[27,5,27,6],[26,21,26,22],[71,27,71,30],[51,22,51,23],[59,29,59,30],[68,19,68,22],[64,22,64,25],[29,11,29,12],[49,20,49,21],[15,11,15,12],[20,13,20,14],[17,21,17,22],[18,21,18,22],[16,21,16,22],[19,21,19,22],[15,21,15,22],[27,21,27,22],[67,19,67,22],[21,13,21,14],[22,11,22,12],[15,13,15,14],[25,21,25,22],[51,16,51,19],[43,20,43,21],[33,16,33,19],[31,14,31,19],[4,38,4,39],[27,29,27,30],[51,0,68,0],[53,2,53,13],[55,2,55,13],[57,2,57,13],[59,2,59,13],[11,61,13,61],[11,54,13,54],[11,57,13,57],[11,60,13,60],[11,52,13,52],[11,51,13,51],[11,58,13,58],[11,59,13,59],[11,40,13,40],[11,41,13,41],[15,26,15,27],[15,29,15,30],[16,29,16,30],[19,26,19,27],[17,29,17,30],[19,29,19,30],[18,29,18,30],[28,26,28,27],[22,29,22,30],[21,29,21,30],[29,26,29,27],[31,25,31,30],[24,21,24,22],[24,26,24,27],[7,2,7,13],[18,26,18,27],[22,21,22,22],[9,2,9,3],[23,8,23,9],[17,11,17,12],[18,13,18,14],[18,11,18,12],[29,5,29,6],[17,5,17,6],[27,8,27,9],[27,13,27,14],[17,13,17,14],[16,5,16,6],[15,8,15,9],[23,21,23,22],[21,21,21,22],[43,14,43,15],[4,14,4,18],[62,2,62,13],[35,2,35,13],[47,2,47,13],[49,16,49,19],[53,14,53,15],[18,5,18,6],[19,5,19,6],[19,8,19,9],[51,2,51,13],[37,2,37,13],[18,8,18,9],[40,4,40,12],[45,2,45,13],[43,2,43,13],[43,16,43,19],[49,14,49,15],[25,13,25,14],[33,14,33,15],[45,16,45,19],[39,2,39,13],[19,2,19,3],[19,11,19,12],[68,14,68,18],[57,16,57,19],[55,16,55,19],[49,2,49,13],[62,14,62,15],[66,14,66,18],[66,19,66,22],[64,16,64,19],[51,14,51,15],[49,22,49,23],[65,19,65,22],[55,14,55,15],[53,20,53,21],[53,22,53,23],[55,20,55,21]]}
[]
[null,null,"7.",null,"Gebäude"]
[null,null,"7.1",null,"Mietwohnungen / Genossenschaftswohnungen"]
[null,null,"7.1.1",null,"Baubeginn "]
[null,null,"Mit dem Bau wird/wurde begonnen am:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,";","  die Bezugsfertigkeit ist vorgesehen bis zum: "]
[]
[null,null,"7.1.2",null,"Passivhausstandard"]
[null,null,"Passivhausstandard gemäß Förderrichtlinie",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK10=1,\"Ja\",IF(AK10=2,\"Nein\",\"\"))","v":"Nein"},null,null,null,null,null,null,null,{"$f":"IF(AK10=1,\"Beantragung 'Klimabonus' nicht möglich!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Ja",null,null,null,null,null,null,null,null,null,null,"DIN 18040 \"R\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nein"]
[null,null,"7.1.3",null," Wohneinheiten / Förderung",null,null,null,null,null,null,null,null,null,null,"bitte mit  X  markieren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,1,2,3,"3a",null,4,5,6,7,null,8,9,10,"10a",11,12,13,14,15,16,17,18,19,20]
[]
[null,null,"An- zahl WE",null,"je Wohneinheit",null,null,null,null,null,null,null,null,null,null,"DIN 18 040 mit \"R\"","DIN 18 040 ohne \"R\"","Mittelbare Belegung","Mittlere Einkommen","Maßnahmen im Gebäudebestand","davon geförderte WE",null,null,null,null,null,null,null,"davon nicht geförderte WE",null,null,null,null,null,null,null,null,null,null,null,"Standard 2","Standard 1","Mittlere Einkommen","Mittelbare Belegung",null,null,"WF Teil2 ohne R","WF Teil1 mit R","Anzahl DIN 18040 \"R\"","geringe EK, DIN 18040","mittlere EK, DIN 18040","WE geringe Einkommen","WF geringe Einkommen","freie Wohnungen","WF tats. geringe Einkommen","WE mittelb. Belegung ohne Kombi.","WF mittelb. Belegung ohne Kombi.","WF tat. mittelb. Belegung ohne Kombi.","WE mittelb. Belegung","Mittelbare Belegung WF","Mittelbare Belegung WF tat","WE Mittlere Einkommen","Mittlere Einkommen WF","Mittlere Einkommen WF tat"]
[null,null,null,null,"Personen","Zimmer",null,"Küche","Bad / WC",null,"zusätzl. WC","Wohn- fläche               m²",null,"Gesamt- wohnfläche        m²",null,null,null,null,null,null,"Obergrenze",null,null,"max. Zusatz-fläche",null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WE","Wohn-       fläche                 m²",null,"DIN 18040 mit \"R\"","§16","DIN 18040 ohne \"R\"","förderfähige           Wohnfläche               m²",null,"WE","Wohn-       fläche             m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WF","Differenz  SOLL-IST",null,"Regelfläche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C15=\"\",L15=\"\"),\"\",L15*C15)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(L15=\"\",U15=\"\",U15=0),\"\",IF(AND(E15=1,L15>=45),45,IF(AND(E15=1,L15<45),L15,IF(AND(E15=2,L15>60),60,IF(AND(E15=2,L15<60),L15,IF(AND(F15=3,L15>72),72,IF(AND(E15>2,BP15*12+60>L15),L15,BP15*12+60)))))))","v":""},null,{"$f":"IF(AND(P15=\"x\",S15=\"x\",T15=\"x\"),\"\",IF(AND(P15=\"X\",R15=\"X\",S15=\"X\"),\"\",IF(OR(AT15=8,AT15=9,U15=\"\"),\"\",IF(OR(AT15=4,AT15=11),BQ15*16/100,\"\"))))","v":""},null,{"$f":"IF(OR(AT15=17,AT15=7),(BQ15*16/100+BQ15+L15-V15)*U15,IF(OR(AT15=16,AT15=15,AT15=8,AT15=13,AT15=1,AT15=9,AT15=20,AT15=21),BQ15*U15,IF(AT15=12,(BQ15+L15-V15)*U15,IF(OR(AT15=4,AT15=11),(BQ15*16/100+BQ15)*U15,IF(AT15=6,(BQ15+L15-V15)*U15,0)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(U15=\"\",U15=0,V15=\"\"),\"\",IF(OR(Z15=0,Z15=\"\"),\"\",IF(Z15/U15>L15,L15*U15,Z15)))","v":""},null,{"$f":"IF(C15=\"\",\"\",IF(C15-U15=0,\"\",C15-U15))","v":""},{"$f":"IF(AC15=\"\",\"\",AC15*L15)","v":""},null,null,null,null,null,17,{"$f":"BQ15*16/100","v":{"$error":"#VALUE!"}},{"$f":"L15-BQ15","v":{"$error":"#VALUE!"}},{"$f":"BQ15","v":""},{"$f":"SUM(AK15:AM15)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=3,P15=\"X\",S15=\"X\",T15=\"X\"),17,IF(COUNTIF(P15:T15,\"x\")=0,1,0))","v":1},{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=2,P15=\"x\",T15=\"X\"),7,IF(AND(COUNTIF(P15:T15,\"x\")=1,P15=\"X\"),4,IF(AND(COUNTIF(P15:T15,\"x\")=1,T15=\"X\"),6,0)))","v":0},{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=2,S15=\"X\",R15=\"X\"),9,IF(AND(COUNTIF(P15:T15,\"x\")=2,S15=\"X\",P15=\"X\"),11,IF(AND(COUNTIF(P15:T15,\"x\")=2,S15=\"X\",T15=\"X\"),12,IF(AND(COUNTIF(P15:T15,\"x\")=1,S15=\"X\"),13,0))))","v":0},{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=3,P15=\"X\",R15=\"X\",T15=\"X\"),21,IF(AND(COUNTIF(P15:T15,\"x\")=1,R15=\"X\"),8,IF(AND(COUNTIF(P15:T15,\"x\")=2,R15=\"X\",P15=\"X\"),15,IF(AND(COUNTIF(P15:T15,\"x\")=2,R15=\"X\",T15=\"X\"),16,0))))","v":0},{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=4,P15=\"X\",R15=\"X\",S15=\"X\",T15=\"X\"),20,IF(AND(COUNTIF(P15:T15,\"x\")=3,R15=\"X\",S15=\"X\",T15=\"X\"),20,IF(AND(COUNTIF(P15:T15,\"x\")=3,P15=\"X\",R15=\"X\",S15=\"X\"),20,0)))","v":0},{"$f":"SUM(AO15:AS15)","v":1},0,{"$f":"IF(OR(U15=\"\",AT15=20,AT15=21),0,IF(OR(AT15=8,AT15=9,AT15=15),0,IF(P15<>\"\",AA15,0)))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20,AT15=21),0,IF(OR(AT15=8,AT15=9,AT15=15),0,IF(P15<>\"\",U15,0)))","v":0},{"$f":"IF(OR(AT15=4,AT15=7),AV15,0)","v":0},{"$f":"IF(OR(AT15=11,AT15=17),AV15,0)","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=4,AT15=5,AT15=6,AT15=7,AT15=3,AT15=1),U15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=4,AT15=5,AT15=6,AT15=7,AT15=3,AT15=1),AA15,0))","v":0},{"$f":"IF(AD15=\"\",0,AD15)","v":0},{"$f":"IF(OR(AT15=20,U15=\"\"),0,IF(OR(AT15=4,AT15=5,AT15=6,AT15=7,AT15=3,AT15=1),N15-BB15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=8,AT15=14,AT15=15,AT15=16,AT15=21),U15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=8,AT15=14,AT15=15,AT15=16,AT15=21),AA15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=8,AT15=14,AT15=15,AT15=16,AT15=21),N15-BB15,0))","v":0},{"$f":"IF(U15=\"\",0,IF(OR(AT15=9,AT15=20),U15,0))","v":0},{"$f":"IF(U15=\"\",0,IF(OR(AT15=9,AT15=20),AA15,0))","v":0},{"$f":"IF(U15=\"\",0,IF(OR(AT15=9,AT15=20),N15-BB15,0))","v":0},{"$f":"IF(AT15=20,0,IF(OR(AT15=10,AT15=11,AT15=12,AT15=13,AT15=17,AT15=18),U15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=10,AT15=11,AT15=12,AT15=13,AT15=17,AT15=18,),AA15,0))","v":0},{"$f":"IF(OR(U15=\"\",AT15=20),0,IF(OR(AT15=10,AT15=11,AT15=12,AT15=13,AT15=17,AT15=18),N15-BB15,0))","v":0},null,{"$f":"IF(L15<V15,L15,V15)","v":""},{"$f":"IF(OR(L15=\"\",V15=\"\"),0,L15-V15)","v":0},{"$f":"IF(E15=\"\",0,E15-2)","v":0},{"$f":"IF(OR(L15=\"\",U15=\"\"),\"\",IF(AND(E15=1,L15>=45),45,IF(AND(E15=1,L15<45),45,IF(AND(E15=2,L15>60),60,IF(AND(E15=2,L15<60),60,IF(AND(F15=3,L15>72),72,IF(AND(E15>2,BP15*12+60>L15),BP15*12+60,BP15*12+60)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C16=\"\",L16=\"\"),\"\",L16*C16)","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(L16=\"\",U16=\"\",U16=0),\"\",IF(AND(E16=1,L16>=45),45,IF(AND(E16=1,L16<45),L16,IF(AND(E16=2,L16>60),60,IF(AND(E16=2,L16<60),L16,IF(AND(F16=3,L16>72),72,IF(AND(E16>2,BP16*12+60>L16),L16,BP16*12+60)))))))","v":""},null,"",null,{"$error":"#VALUE!"},{"$f":"IF(OR(U16=\"\",U16=0,V16=\"\"),\"\",IF(OR(Z16=0,Z16=\"\"),\"\",IF(Z16/U16>L16,L16*U16,Z16)))","v":""},null,"",{"$f":"IF(AC16=\"\",\"\",AC16*L16)","v":""},null,null,null,null,null,12,null,{"$f":"L16-BQ16","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},1,{"$f":"IF(AND(COUNTIF(P16:T16,\"x\")=2,P16=\"x\",T16=\"X\"),7,IF(AND(COUNTIF(P16:T16,\"x\")=1,P16=\"X\"),4,IF(AND(COUNTIF(P16:T16,\"x\")=1,T16=\"X\"),6,0)))","v":0},0,{"$f":"IF(AND(COUNTIF(P16:T16,\"x\")=3,P16=\"X\",R16=\"X\",T16=\"X\"),21,IF(AND(COUNTIF(P16:T16,\"x\")=1,R16=\"X\"),8,IF(AND(COUNTIF(P16:T16,\"x\")=2,R16=\"X\",P16=\"X\"),15,IF(AND(COUNTIF(P16:T16,\"x\")=2,R16=\"X\",T16=\"X\"),16,0))))","v":0},0,{"$f":"SUM(AO16:AS16)","v":1},1,0,0,{"$f":"IF(OR(AT16=4,AT16=7),AV16,0)","v":0},{"$f":"IF(OR(AT16=11,AT16=17),AV16,0)","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=4,AT16=5,AT16=6,AT16=7,AT16=3,AT16=1),U16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=4,AT16=5,AT16=6,AT16=7,AT16=3,AT16=1),AA16,0))","v":0},{"$f":"IF(AD16=\"\",0,AD16)","v":0},{"$f":"IF(OR(AT16=20,U16=\"\"),0,IF(OR(AT16=4,AT16=5,AT16=6,AT16=7,AT16=3,AT16=1),N16-BB16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=8,AT16=14,AT16=15,AT16=16,AT16=21),U16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=8,AT16=14,AT16=15,AT16=16,AT16=21),AA16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=8,AT16=14,AT16=15,AT16=16,AT16=21),N16-BB16,0))","v":0},{"$f":"IF(U16=\"\",0,IF(OR(AT16=9,AT16=20),U16,0))","v":0},{"$f":"IF(U16=\"\",0,IF(OR(AT16=9,AT16=20),AA16,0))","v":0},{"$f":"IF(U16=\"\",0,IF(OR(AT16=9,AT16=20),N16-BB16,0))","v":0},{"$f":"IF(AT16=20,0,IF(OR(AT16=10,AT16=11,AT16=12,AT16=13,AT16=17,AT16=18),U16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=10,AT16=11,AT16=12,AT16=13,AT16=17,AT16=18,),AA16,0))","v":0},{"$f":"IF(OR(U16=\"\",AT16=20),0,IF(OR(AT16=10,AT16=11,AT16=12,AT16=13,AT16=17,AT16=18),N16-BB16,0))","v":0},null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C17=\"\",L17=\"\"),\"\",L17*C17)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,20,null,null,"",0,1,0,0,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C18=\"\",L18=\"\"),\"\",L18*C18)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,7,{"$f":"BQ18*16/100","v":{"$error":"#VALUE!"}},{"$f":"L18-BQ18","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},1,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C19=\"\",L19=\"\"),\"\",L19*C19)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,4,{"$f":"BQ19*16/100","v":{"$error":"#VALUE!"}},null,"",{"$error":"#VALUE!"},1,0,0,0,0,1,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,6,null,{"$f":"L20-BQ20","v":{"$error":"#VALUE!"}},"",{"$error":"#VALUE!"},1,0,0,0,0,1,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,9,null,null,"",0,1,0,0,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,11,{"$f":"BQ22*16/100","v":{"$error":"#VALUE!"}},null,"",{"$error":"#VALUE!"},1,0,0,0,0,1,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,1,null,null,"",0,1,0,0,0,0,1,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,13,null,null,"",0,1,0,0,0,0,1,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,8,null,null,"",0,1,0,0,0,0,1,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C26=\"\",L26=\"\"),\"\",L26*C26)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,15,null,null,"",0,1,0,0,0,0,1,11,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C27=\"\",L27=\"\"),\"\",L27*C27)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$f":"IF(OR(AT27=17,AT27=7),(BQ27*16/100+BQ27+L27-V27)*U27,IF(OR(AT27=16,AT27=15,AT27=8,AT27=13,AT27=1,AT27=9,AT27=20,AT27=21),BQ27*U27,IF(AT27=12,(BQ27+L27-V27)*U27,IF(OR(AT27=4,AT27=11),(BQ27*16/100+BQ27)*U27,IF(AT27=6,(BQ27+L27-V27)*U27,0)))))","v":{"$error":"#VALUE!"}},"",null,"","",null,null,null,null,null,16,null,null,"",0,1,0,0,0,0,1,12,{"$f":"IF(OR(U27=\"\",AT27=20,AT27=21),0,IF(OR(AT27=8,AT27=9,AT27=15),0,IF(P27<>\"\",AA27,0)))","v":0},{"$f":"IF(OR(U27=\"\",AT27=20,AT27=21),0,IF(OR(AT27=8,AT27=9,AT27=15),0,IF(P27<>\"\",U27,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C28=\"\",L28=\"\"),\"\",L28*C28)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$f":"IF(OR(AT28=17,AT28=7),(BQ28*16/100+BQ28+L28-V28)*U28,IF(OR(AT28=16,AT28=15,AT28=8,AT28=13,AT28=1,AT28=9,AT28=20,AT28=21),BQ28*U28,IF(AT28=12,(BQ28+L28-V28)*U28,IF(OR(AT28=4,AT28=11),(BQ28*16/100+BQ28)*U28,IF(AT28=6,(BQ28+L28-V28)*U28,0)))))","v":{"$error":"#VALUE!"}},"",null,"","",null,null,null,null,null,null,null,null,null,null,1,0,0,0,0,1,13,{"$f":"IF(OR(U28=\"\",AT28=20,AT28=21),0,IF(OR(AT28=8,AT28=9,AT28=15),0,IF(P28<>\"\",AA28,0)))","v":0},{"$f":"IF(OR(U28=\"\",AT28=20,AT28=21),0,IF(OR(AT28=8,AT28=9,AT28=15),0,IF(P28<>\"\",U28,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(L28<V28,L28,V28)","v":""},{"$f":"IF(OR(L28=\"\",V28=\"\"),0,L28-V28)","v":0},{"$f":"IF(E28=\"\",0,E28-2)","v":0},{"$f":"IF(OR(L28=\"\",U28=\"\"),\"\",IF(AND(E28=1,L28>=45),45,IF(AND(E28=1,L28<45),45,IF(AND(E28=2,L28>60),60,IF(AND(E28=2,L28<60),60,IF(AND(F28=3,L28>72),72,IF(AND(E28>2,BP28*12+60>L28),BP28*12+60,BP28*12+60)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C29=\"\",L29=\"\"),\"\",L29*C29)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$f":"IF(OR(AT29=17,AT29=7),(BQ29*16/100+BQ29+L29-V29)*U29,IF(OR(AT29=16,AT29=15,AT29=8,AT29=13,AT29=1,AT29=9,AT29=20,AT29=21),BQ29*U29,IF(AT29=12,(BQ29+L29-V29)*U29,IF(OR(AT29=4,AT29=11),(BQ29*16/100+BQ29)*U29,IF(AT29=6,(BQ29+L29-V29)*U29,0)))))","v":{"$error":"#VALUE!"}},"",null,"","",null,null,null,null,null,null,null,null,null,null,1,0,0,0,0,1,14,{"$f":"IF(OR(U29=\"\",AT29=20,AT29=21),0,IF(OR(AT29=8,AT29=9,AT29=15),0,IF(P29<>\"\",AA29,0)))","v":0},{"$f":"IF(OR(U29=\"\",AT29=20,AT29=21),0,IF(OR(AT29=8,AT29=9,AT29=15),0,IF(P29<>\"\",U29,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(L29<V29,L29,V29)","v":""},{"$f":"IF(OR(L29=\"\",V29=\"\"),0,L29-V29)","v":0},{"$f":"IF(E29=\"\",0,E29-2)","v":0},{"$f":"IF(OR(L29=\"\",U29=\"\"),\"\",IF(AND(E29=1,L29>=45),45,IF(AND(E29=1,L29<45),45,IF(AND(E29=2,L29>60),60,IF(AND(E29=2,L29<60),60,IF(AND(F29=3,L29>72),72,IF(AND(E29>2,BP29*12+60>L29),BP29*12+60,BP29*12+60)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C30=\"\",L30=\"\"),\"\",L30*C30)","v":""},null,null,null,null,null,null,null,"",null,"",null,{"$f":"IF(OR(AT30=17,AT30=7),(BQ30*16/100+BQ30+L30-V30)*U30,IF(OR(AT30=16,AT30=15,AT30=8,AT30=13,AT30=1,AT30=9,AT30=20,AT30=21),BQ30*U30,IF(AT30=12,(BQ30+L30-V30)*U30,IF(OR(AT30=4,AT30=11),(BQ30*16/100+BQ30)*U30,IF(AT30=6,(BQ30+L30-V30)*U30,0)))))","v":{"$error":"#VALUE!"}},"",null,"","",null,null,null,null,null,null,null,null,null,null,1,0,0,0,0,1,15,{"$f":"IF(OR(U30=\"\",AT30=20,AT30=21),0,IF(OR(AT30=8,AT30=9,AT30=15),0,IF(P30<>\"\",AA30,0)))","v":0},{"$f":"IF(OR(U30=\"\",AT30=20,AT30=21),0,IF(OR(AT30=8,AT30=9,AT30=15),0,IF(P30<>\"\",U30,0)))","v":0},{"$f":"IF(OR(AT30=4,AT30=7),AV30,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(L30<V30,L30,V30)","v":""},{"$f":"IF(OR(L30=\"\",V30=\"\"),0,L30-V30)","v":0},{"$f":"IF(E30=\"\",0,E30-2)","v":0},{"$f":"IF(OR(L30=\"\",U30=\"\"),\"\",IF(AND(E30=1,L30>=45),45,IF(AND(E30=1,L30<45),45,IF(AND(E30=2,L30>60),60,IF(AND(E30=2,L30<60),60,IF(AND(F30=3,L30>72),72,IF(AND(E30>2,BP30*12+60>L30),BP30*12+60,BP30*12+60)))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 3",null,null,null,null,null,"Seite 3a",null,null,null,null,"Summe Seite 3 und 3 a"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl",null,"Fläche (m²)",null,null,null,"Anzahl",null,"Fläche (m²)",null,null,"Anzahl","Anzahl","Summe Wohnfläche",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zeile 52",null,null,null,"Zeile 56",null,null,"Zeile 54",null,null,"Zeile 50"]
[]
[null,null,"Wohnungen ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(C15:D30)=0,\"\",(SUM(C15:D30)))","v":""},null,{"$f":"IF(SUM(N15:N30)=0,\"\",SUM(N15:N30))","v":""},null,null,null,{"$f":"IF(SUM('Gebäude Teil 2'!C7:D52)=0,\"\",SUM('Gebäude Teil 2'!C7:D52))","v":""},null,{"$f":"IF(SUM('Gebäude Teil 2'!N7:O52)=0,\"\",SUM('Gebäude Teil 2'!N7:O52))","v":""},null,null,null,{"$f":"IF(AND(O36=\"\",U36=\"\"),\"\",SUM(O36,U36))","v":""},{"$f":"IF(AND(Q36=\"\",W36=\"\"),\"\",SUM(Q36,W36))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N15:O30)-SUM(AD15:AE30)=0,\"\",SUM(N15:O30)-SUM(AD15:AE30))","v":""},null,null,null,null,{"$f":"IF(SUM(AA15:AB30)=0,0,SUM(AA15:AB30))","v":0},{"$f":"IF(SUM(U15:U30)=0,\"\",SUM(U15:U30))","v":""},{"$f":"'Gebäude Teil 2'!BI65","v":0},{"$f":"SUM(AX15:AX30)","v":0},{"$f":"SUM(AY15:AY30)","v":0},{"$f":"IF(SUM(AZ15:AZ30)=0,0,SUM(AZ15:AZ30))","v":0},0,{"$f":"IF(SUM(BB15:BB30)=0,0,SUM(BB15:BB30))","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Wohnungsbestand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Gebäude Teil 2'!AR60","v":""},null,null,null,null,{"$f":"'Gebäude Teil 2'!AW63","v":0},{"$f":"'Gebäude Teil 2'!AS60","v":0},null,{"$f":"'Gebäude Teil 2'!AZ60","v":0},{"$f":"'Gebäude Teil 2'!BA60","v":0},{"$f":"'Gebäude Teil 2'!BC60","v":0},{"$f":"'Gebäude Teil 2'!BD60","v":0},{"$f":"'Gebäude Teil 2'!BB60","v":0},{"$f":"'Gebäude Teil 2'!BE60","v":0},{"$f":"'Gebäude Teil 2'!BF60","v":0},{"$f":"'Gebäude Teil 2'!BG60","v":0},{"$f":"'Gebäude Teil 2'!BH60","v":0},{"$f":"'Gebäude Teil 2'!BI60","v":0},{"$f":"'Gebäude Teil 2'!BJ60","v":0},{"$f":"'Gebäude Teil 2'!BK60","v":0},{"$f":"'Gebäude Teil 2'!BL60","v":0},{"$f":"'Gebäude Teil 2'!BM60","v":0},{"$f":"'Gebäude Teil 2'!BN60","v":0}]
[]
[null,null,"Gewerbeflächen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AU15:AU30)","v":120},null,null,null,null,{"$f":"IF(SUM(AV15:AV30)=0,\"\",SUM(AV15:AV30))","v":""},{"$f":"IF(SUM(AW15:AW30)=0,0,SUM(AW15:AW30))","v":0},{"$f":"'Gebäude Teil 2'!BI68","v":0}]
[]
[null,null,"Gemeinschaftsraum/-räume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Gebäude Teil 2'!AW60","v":0},null,null,null,null,{"$f":"'Gebäude Teil 2'!AX60","v":0},{"$f":"IF(SUM(AY15:AY30)=0,\"\",SUM(AY15:AY30))","v":""},{"$f":"'Gebäude Teil 2'!BI69","v":0},null,null,{"$f":"SUM(AZ36:AZ38)+SUM(BD36:BD38)+SUM(BG36:BG38)+SUM(BJ36:BJ38)","v":0},null,{"$f":"BB36+BB38","v":0}]
[]
[null,null,"tatsächliche Fläche der gef. WE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV36=0,\"\",AV36)","v":""},null,{"$f":"IF(AP36=0,\"\",AP36)","v":""},null,null,null,{"$f":"IF(AV38=0,\"\",AV38)","v":""},null,{"$f":"IF(AP38=0,\"\",AP38)","v":""},null,null,null,{"$f":"IF(AND(O44=\"\",U44=\"\"),\"\",SUM(O44,U44))","v":""},{"$f":"IF(AND(Q44=\"\",W44=\"\"),\"\",SUM(Q44,W44))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AD15:AE30)=0,0,SUM(AD15:AE30))","v":0},{"$f":"IF(SUM(AC15:AC30)=0,0,SUM(AC15:AC30))","v":0},{"$f":"'Gebäude Teil 2'!AX63","v":0}]
[]
[null,null,"förderfähige Wohnfläche",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV36=0,\"\",AV36)","v":""},null,{"$f":"IF(AU36=0,\"\",AU36)","v":""},null,null,null,{"$f":"IF(AV38=0,\"\",AV38)","v":""},null,{"$f":"IF(AU38=0,\"\",AU38)","v":""},null,null,null,{"$f":"IF(AND(O46=\"\",U46=\"\"),\"\",SUM(O46,U46))","v":""},{"$f":"IF(AND(Q46=\"\",W46=\"\"),\"\",SUM(Q46,W46))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Gebäude Teil 2'!AW65","v":""}]
[]
[null,null,"davon Fläche gem. DIN 18040 mit \"R\"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV40=0,\"\",AV40)","v":""},null,{"$f":"IF(AU40=0,\"\",AU40)","v":""},null,null,null,{"$f":"IF(AW40=0,\"\",AW40)","v":""},null,{"$f":"IF(AU42=0,\"\",AU42)","v":""},null,null,null,{"$f":"IF(AND(O48=\"\",U48=\"\"),\"\",SUM(O48,U48))","v":""},{"$f":"IF(AND(Q48=\"\",W48=\"\"),\"\",SUM(Q48,W48))","v":""}]
[]
[null,null,"davon mittlere Einkommen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BJ36=0,\"\",BJ36)","v":""},null,{"$f":"IF(BK36=0,\"\",BK36)","v":""},null,null,null,{"$f":"IF(BJ38=0,\"\",BJ38)","v":""},null,{"$f":"IF(BK38=0,\"\",BK38)","v":""},null,null,null,{"$f":"IF(AND(O50=\"\",U50=\"\"),\"\",SUM(O50,U50))","v":""},{"$f":"IF(AND(Q50=\"\",W50=\"\"),\"\",SUM(Q50,W50))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"nicht förderfähiger Anteil Gemeinschaftsraum",null,null,null,null,null,null,null,{"$f":"IF(AB58=\"\",0,AB58/AB36*100)","v":0}]
[]
[{"$f":"TODAY()","v":"2023-07-17"},null,"davon geringe Einkommen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ36=0,\"\",AZ36)","v":""},null,{"$f":"IF(BA36=0,\"\",BA36)","v":""},null,null,null,{"$f":"IF(AZ38=0,\"\",AZ38)","v":""},null,{"$f":"IF(BA38=0,\"\",BA38)","v":""},null,null,null,{"$f":"IF(AND(O52=\"\",U52=\"\"),\"\",SUM(O52,U52))","v":""},{"$f":"IF(AND(Q52=\"\",W52=\"\"),\"\",SUM(Q52,W52))","v":""}]
[]
[null,null,"davon mittelb. Belegung, mittl. EK",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BG36=0,\"\",BG36)","v":""},null,{"$f":"IF(BH36=0,\"\",BH36)","v":""},null,null,null,{"$f":"IF(BG38=0,\"\",BG38)","v":""},null,{"$f":"IF(BH38=0,\"\",BH38)","v":""},null,null,null,{"$f":"IF(AND(O54=\"\",U54=\"\"),\"\",SUM(O54,U54))","v":""},{"$f":"IF(AND(Q54=\"\",W54=\"\"),\"\",SUM(Q54,W54))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtfläche",null,null,null,null,null,null,{"$f":"AB36","v":""}]
[]
[null,null,"davon mittelb. Belegung, ger. EK",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BD36=0,\"\",BD36)","v":""},null,{"$f":"IF(BE36=0,\"\",BE36)","v":""},null,null,null,{"$f":"IF(BD38=0,\"\",BD38)","v":""},null,{"$f":"IF(BE38=0,\"\",BE38)","v":""},null,null,null,{"$f":"IF(SUM(O56,U56)=0,\"\",SUM(O56,U56))","v":""},{"$f":"IF(SUM(Q56,W56)=0,\"\",SUM(Q56,W56))","v":""},null,null,null,{"$f":"#REF!*T67","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"geringe EK",null,null,null,null,null,null,{"$f":"SUM(BC36:BC38)","v":0},null,null,{"$f":"IF(OR(AV56=\"\",AV54=\"\"),0,AV56/AV54*100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O57*T68","v":{"$error":"#VALUE!"}}]
[null,null,"nicht geförderte Wohnungen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV44=0,\"\",AV44)","v":""},null,{"$f":"IF(AU44=0,\"\",AU44)","v":""},null,null,null,{"$f":"IF(AW44=0,\"\",AW44)","v":""},null,{"$f":"IF(AU46=0,\"\",AU46)","v":""},null,null,null,{"$f":"IF(SUM(O58,U58)=0,\"\",SUM(O58,U58))","v":""},{"$f":"IF(SUM(Q58,W58)=0,\"\",SUM(Q58,W58))","v":""},null,null,null,{"$f":"#REF!*T69","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(AB50:AE57)","v":0},null,null,"mittlere EK",null,null,null,null,null,null,{"$f":"SUM(BL36:BL38)","v":0},null,null,{"$f":"IF(OR(AV58=\"\",AV54=\"\"),0,AV58/AV54*100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O59*AC59","v":0}]
[null,null,"Anzahl Abstellplätze im Freien",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl Garagen",null,null,null,null,null,null,null,null,null,"Anzahl Einstellplätze / TG"]
[]
[null,null,"7.1.4",null," Aufzüge"]
[null,null,"Anzahl der neu einzubauenden Aufzüge"]
[]
[null,null,"7.1.5",null,"Umbauter Raum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O65*#REF!","v":{"$error":"#REF!"}}]
[null,null," Art",null,null,null,null,null,"m³                Hauptgebäude",null,null,null,null,null,"m³                                    Tiefgarage",null,null,null,null,"m³                      Gesamt"]
[null,null,"Wohnraum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I67:S67)=0,\"\",SUM(I67:S67))","v":""}]
[null,null,"Gewerbe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I68:S68)=0,\"\",SUM(I68:S68))","v":""}]
[null,null,"Summen",null,null,null,null,null,{"$f":"IF(SUM(I67:N68)=0,\"\",SUM(I67:N68))","v":""},null,null,null,null,null,{"$f":"IF(SUM(O67:P68)=0,\"\",SUM(O67:P68))","v":""},null,null,null,null,{"$f":"IF(SUM(I69:S69)=0,\"\",SUM(I69:S69))","v":""}]
[]
[]
[null,"Antragsteller:",null,null,null,null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"         Seite 3  von Seite 8"]

{"sheet":"Gebäude Teil 2","index":3,"n_rows":69,"n_cols":66,"rows_kept":69,"cut":false,"hidden":false,"merged":[[6,2,6,3],[6,5,6,6],[6,8,6,9],[6,11,6,12],[6,13,6,14],[6,25,6,26],[6,30,6,31],[4,27,4,29],[4,30,4,31],[1,2,1,3],[3,2,5,3],[3,4,3,12],[3,15,5,15],[3,16,5,16],[4,20,4,26],[4,4,5,4],[1,15,2,19],[3,20,3,31],[4,11,5,12],[7,2,7,3],[7,5,7,6],[7,8,7,9],[7,11,7,12],[7,13,7,14],[7,25,7,26],[7,30,7,31],[7,33,7,34],[3,45,5,45],[4,5,5,6],[4,7,5,7],[4,8,5,9],[4,10,5,10],[3,19,5,19],[3,18,5,18],[3,17,5,17],[4,13,5,14],[5,25,5,26],[3,44,5,44],[5,33,5,34],[3,42,5,42],[3,43,5,43],[3,32,4,34],[6,33,6,34],[8,2,8,3],[8,5,8,6],[8,8,8,9],[8,11,8,12],[8,13,8,14],[8,25,8,26],[8,30,8,31],[8,33,8,34],[9,2,9,3],[9,5,9,6],[9,8,9,9],[9,11,9,12],[9,13,9,14],[9,25,9,26],[9,30,9,31],[9,33,9,34],[10,2,10,3],[10,5,10,6],[10,8,10,9],[10,11,10,12],[10,13,10,14],[10,25,10,26],[10,30,10,31],[10,33,10,34],[11,2,11,3],[11,5,11,6],[11,8,11,9],[11,11,11,12],[11,13,11,14],[11,25,11,26],[11,30,11,31],[11,33,11,34],[12,2,12,3],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,13,12,14],[12,25,12,26],[12,30,12,31],[12,33,12,34],[13,2,13,3],[13,5,13,6],[13,8,13,9],[13,11,13,12],[13,13,13,14],[13,25,13,26],[13,30,13,31],[13,33,13,34],[33,33,33,34],[14,2,14,3],[14,5,14,6],[14,8,14,9],[14,11,14,12],[14,13,14,14],[14,25,14,26],[17,30,17,31],[18,30,18,31],[19,30,19,31],[15,33,15,34],[16,33,16,34],[17,33,17,34],[18,33,18,34],[19,33,19,34],[20,33,20,34],[21,33,21,34],[22,33,22,34],[23,33,23,34],[24,33,24,34],[25,33,25,34],[26,33,26,34],[15,5,15,6],[15,8,15,9],[35,33,35,34],[34,2,34,3],[34,25,34,26],[14,30,14,31],[14,33,14,34],[33,2,33,3],[33,5,33,6],[33,8,33,9],[33,11,33,12],[33,13,33,14],[33,25,33,26],[33,30,33,31],[34,33,34,34],[20,30,20,31],[21,30,21,31],[29,30,29,31],[30,30,30,31],[31,30,31,31],[32,30,32,31],[22,30,22,31],[23,30,23,31],[24,30,24,31],[25,30,25,31],[26,30,26,31],[34,30,34,31],[34,5,34,6],[34,8,34,9],[34,11,34,12],[34,13,34,14],[35,2,35,3],[35,5,35,6],[35,8,35,9],[35,11,35,12],[35,13,35,14],[35,25,35,26],[35,30,35,31],[36,33,36,34],[37,2,37,3],[37,5,37,6],[37,8,37,9],[37,11,37,12],[37,13,37,14],[37,25,37,26],[37,30,37,31],[37,33,37,34],[36,2,36,3],[36,30,36,31],[36,5,36,6],[36,8,36,9],[36,11,36,12],[36,13,36,14],[36,25,36,26],[38,5,38,6],[38,8,38,9],[38,11,38,12],[38,13,38,14],[38,25,38,26],[38,33,38,34],[39,30,39,31],[39,33,39,34],[38,30,38,31],[40,33,40,34],[39,2,39,3],[39,5,39,6],[39,8,39,9],[39,11,39,12],[39,13,39,14],[41,25,41,26],[40,8,40,9],[40,11,40,12],[40,13,40,14],[40,25,40,26],[39,25,39,26],[41,2,41,3],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,13,41,14],[42,5,42,6],[42,8,42,9],[42,11,42,12],[42,13,42,14],[41,33,41,34],[40,2,40,3],[40,5,40,6],[53,2,53,3],[53,4,53,12],[53,13,53,14],[42,25,42,26],[44,2,44,3],[44,5,44,6],[44,8,44,9],[41,30,41,31],[42,30,42,31],[42,33,42,34],[43,5,43,6],[43,8,43,9],[43,11,43,12],[43,13,43,14],[43,25,43,26],[43,30,43,31],[40,30,40,31],[46,0,54,0],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[31,2,31,3],[32,2,32,3],[43,2,43,3],[50,2,50,3],[51,2,51,3],[42,2,42,3],[38,2,38,3],[15,11,15,12],[16,5,16,6],[16,8,16,9],[16,11,16,12],[17,5,17,6],[17,8,17,9],[17,11,17,12],[18,5,18,6],[18,8,18,9],[18,11,18,12],[19,5,19,6],[19,8,19,9],[19,11,19,12],[20,5,20,6],[20,8,20,9],[20,11,20,12],[21,5,21,6],[21,8,21,9],[21,11,21,12],[25,11,25,12],[26,5,26,6],[26,8,26,9],[26,11,26,12],[27,5,27,6],[27,8,27,9],[27,11,27,12],[22,5,22,6],[22,8,22,9],[22,11,22,12],[23,5,23,6],[23,8,23,9],[23,11,23,12],[24,5,24,6],[24,8,24,9],[24,11,24,12],[31,5,31,6],[31,8,31,9],[31,11,31,12],[32,5,32,6],[32,8,32,9],[32,11,32,12],[26,13,26,14],[15,13,15,14],[16,13,16,14],[17,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[28,5,28,6],[28,8,28,9],[28,11,28,12],[29,5,29,6],[29,8,29,9],[29,11,29,12],[30,5,30,6],[30,8,30,9],[30,11,30,12],[25,5,25,6],[25,8,25,9],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[21,13,21,14],[22,13,22,14],[23,13,23,14],[24,13,24,14],[25,13,25,14],[27,13,27,14],[28,13,28,14],[29,25,29,26],[30,25,30,26],[15,25,15,26],[19,25,19,26],[20,25,20,26],[17,25,17,26],[18,25,18,26],[3,59,5,59],[3,55,5,55],[3,56,5,56],[15,30,15,31],[16,30,16,31],[16,25,16,26],[25,25,25,26],[26,25,26,26],[21,25,21,26],[22,25,22,26],[23,25,23,26],[24,25,24,26],[27,30,27,31],[28,30,28,31],[3,50,5,50],[5,30,5,31],[67,64,67,70],[68,64,68,70],[65,51,65,58],[64,51,64,58],[3,51,5,51],[3,53,5,53],[64,64,64,70],[64,61,64,63],[65,61,65,63],[65,64,65,70],[68,51,68,58],[67,61,67,63],[68,61,68,63],[3,65,5,65],[3,62,5,62],[3,64,5,64],[3,58,5,58],[3,54,5,54],[3,63,5,63],[3,57,5,57],[3,61,5,61],[3,60,5,60],[66,48,66,50],[67,48,67,50],[68,48,68,50],[44,11,44,12],[45,2,45,3],[45,5,45,6],[45,8,45,9],[66,51,66,58],[67,51,67,58],[44,13,44,14],[44,25,44,26],[44,30,44,31],[65,48,65,50],[48,30,48,31],[44,33,44,34],[46,33,46,34],[64,48,64,50],[57,31,57,34],[47,33,47,34],[48,11,48,12],[48,13,48,14],[48,25,48,26],[47,25,47,26],[47,2,47,3],[48,2,48,3],[48,5,48,6],[49,2,49,3],[43,33,43,34],[45,33,45,34],[46,2,46,3],[46,5,46,6],[46,8,46,9],[46,11,46,12],[46,13,46,14],[46,25,46,26],[45,11,45,12],[45,30,45,31],[46,30,46,31],[45,13,45,14],[45,25,45,26],[49,33,49,34],[50,5,50,6],[50,8,50,9],[50,11,50,12],[50,13,50,14],[50,25,50,26],[51,8,51,9],[51,11,51,12],[51,13,51,14],[47,11,47,12],[47,13,47,14],[51,5,51,6],[49,5,49,6],[49,8,49,9],[49,11,49,12],[49,13,49,14],[49,25,49,26],[47,5,47,6],[47,8,47,9],[50,30,50,31],[48,33,48,34],[47,30,47,31],[48,8,48,9],[3,52,5,52],[51,25,51,26],[49,30,49,31],[50,33,50,34],[3,46,5,46],[51,30,51,31],[51,33,51,34],[3,47,5,47],[3,48,5,48],[3,49,5,49],[27,33,27,34],[28,33,28,34],[29,33,29,34],[30,33,30,34],[31,25,31,26],[32,25,32,26],[27,25,27,26],[28,25,28,26],[31,33,31,34],[32,33,32,34]]}
[]
[null,null,"7.1.3",null," Wohneinheiten / Förderung",null,null,null,null,null,null,null,null,null,null,"bitte mit  X markieren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,"3a",null,4,5,6,7,8,null,null,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(P15:T15,\"x\")=1,R15=\"X\"),8,IF(AND(COUNTIF(P15:T15,\"x\")=2,R15=\"X\",Q15=\"X\"),14,IF(AND(COUNTIF(P15:T15,\"x\")=2,R15=\"X\",P15=\"X\"),15,IF(AND(COUNTIF(P15:T15,\"x\")=2,R15=\"X\",T15=\"X\"),16,0))))","v":0}]
[null,null,"An- zahl WE",null,"je Wohneinheit",null,null,null,null,null,null,null,null,null,null,"DIN 18 040 mit \"R\"","DIN 18 040 ohne \"R\"","Mittelbare Belegung","Mittlere Einkommen","Maßnahmen im Gebäudebestand","davon geförderte WE",null,null,null,null,null,null,null,null,null,null,null,"davon nicht geförderte WE",null,null,null,null,null,null,null,null,null,"Standard 2","Standard 1","Mittlere Einkommen","Mittelbare Belegung",null,"Summe","Wohnfläche Teil 2","Wohnfläche Teil 1","Anzahl DIN 18040 \"R\"","DIN 18040 für geringe EK","DIN 18040 für mittlere EK","freie Wohnungen","WE geringe Einkommen","Wf geringe Einkommen","Wf tats. geringe Einkommen","WE mittelbare Belegung in Kombi","WF mittelb. Belegung in Kombi.","WF tat. mittelb. Belegung in Kombi.","WE mittelb. Belegung","WF mittelb. Belegung","Mittelbare Belegung WF tat","WE Mittlere Einkommen","Mittlere Einkommen WF","WF tats. Mittere Einkommen"]
[null,null,null,null,"Personen","Zimmer",null,"Küche","Bad / WC",null,"zusätzl. WC","Wohn- fläche               m²",null,"Gesamt- wohnfläche        m²",null,null,null,null,null,null,"Obergrenze",null,null,null,null,null,null,"max. Zusatz-fläche",null,null,"Summe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WE","WF","Differenz  SOLL-IST",null,null,"Wohnfläche   m²",null,"DIN 18040 mit \"R\"","§16","DIN 18040 ohne \"R\"","förderfähige           Wohnfläche               m²",null,"WE","Wohn-       fläche             m²"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C7=\"\",L7=\"\"),\"\",L7*C7)","v":""},null,null,null,null,null,null,null,{"$f":"IF(L7<Z7,L7,Z7)","v":""},{"$f":"IF(OR(L7=\"\",Z7=\"\"),0,L7-Z7)","v":0},{"$f":"IF(E7=\"\",0,E7-2)","v":0},{"$f":"IF(OR(L7=\"\",U7=\"\"),\"\",IF(AND(E7=1,L7>=45),45,IF(AND(E7=1,L7<45),45,IF(AND(E7=2,L7>60),60,IF(AND(E7=2,L7<60),60,IF(AND(F7=3,L7>72),72,IF(AND(E7>2,X7*12+60>L7),X7*12+60,X7*12+60)))))))","v":""},{"$f":"IF(OR(L7=\"\",U7=\"\",U7=0),\"\",IF(AND(E7=1,L7>=45),45,IF(AND(E7=1,L7<45),L7,IF(AND(E7=2,L7>60),60,IF(AND(E7=2,L7<60),L7,IF(AND(F7=3,L7>72),72,IF(AND(E7>2,X7*12+60>L7),L7,X7*12+60)))))))","v":""},null,{"$f":"IF(AND(P7=\"x\",S7=\"x\",T7=\"x\"),\"\",IF(AND(P7=\"x\",R7=\"x\",S7=\"x\"),\"\",IF(OR(AV7=8,AV7=9,U7=\"\"),\"\",IF(OR(AV7=4,AV7=11),Z7*16/100,\"\"))))","v":""},null,{"$f":"IF(OR(AV7=17,AV7=7),(Z7*16/100+Z7+L7-Z7)*U7,IF(OR(AV7=16,AV7=15,AV7=8,AV7=13,AV7=1,AV7=9,AV7=20,AV7=21),Z7*U7,IF(AV7=12,(Z7+L7-Z7)*U7,IF(OR(AV7=4,AV7=11),(Z7*16/100+Z7)*U7,IF(AV7=6,(Z7+L7-Z7)*U7,0)))))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(U7=\"\",Z7=\"\",Z7=0),\"\",IF(AD7=0,\"\",IF(AD7/U7>L7,L7*U7,AD7)))","v":""},null,{"$f":"IF(C7=\"\",\"\",IF(C7-U7=0,\"\",C7-U7))","v":""},{"$f":"IF(AG7=\"\",\"\",AG7*L7)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(P7:T7,\"X\")=3,P7=\"X\",S7=\"X\",T7=\"X\"),17,IF(COUNTIF(P7:T7,\"x\")=0,1,0))","v":1},{"$f":"IF(AND(COUNTIF(P7:T7,\"x\")=2,P7=\"x\",T7=\"X\"),7,IF(AND(COUNTIF(P7:T7,\"x\")=1,P7=\"X\"),4,IF(AND(COUNTIF(P7:T7,\"x\")=1,T7=\"X\"),6,0)))","v":0},{"$f":"IF(AND(COUNTIF(P7:T7,\"x\")=2,S7=\"X\",R7=\"X\"),9,IF(AND(COUNTIF(P7:T7,\"x\")=2,S7=\"X\",P7=\"X\"),11,IF(AND(COUNTIF(P7:T7,\"x\")=2,S7=\"X\",T7=\"X\"),12,IF(AND(COUNTIF(P7:T7,\"x\")=1,S7=\"X\"),13,0))))","v":0},{"$f":"IF(AND(COUNTIF(P7:T7,\"X\")=3,P7=\"X\",R7=\"X\",T7=\"X\"),21,IF(AND(COUNTIF(P7:T7,\"x\")=1,R7=\"X\"),8,IF(AND(COUNTIF(P7:T7,\"x\")=2,R7=\"X\",P7=\"X\"),15,IF(AND(COUNTIF(P7:T7,\"x\")=2,R7=\"X\",T7=\"X\"),16,0))))","v":0},{"$f":"IF(AND(COUNTIF(P7:T7,\"x\")=4,P7=\"X\",R7=\"X\",S7=\"X\",T7=\"X\"),20,IF(AND(COUNTIF(P7:T7,\"x\")=3,R7=\"X\",S7=\"X\",T7=\"X\"),20,IF(AND(COUNTIF(P7:T7,\"x\")=3,P7=\"X\",R7=\"X\",S7=\"X\"),20,0)))","v":0},{"$f":"SUM(AQ7:AU7)","v":1},{"$f":"IF(U7=\"\",0,IF(OR(AV7=8,AV7=9,AV7=14,AV7=20),0,IF(Q7<>\"\",AE7,0)))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=8,AV7=9,AV7=15,AV7=20,AV7=21),0,IF(P7<>\"\",AE7,0)))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=8,AV7=9,AV7=15,AV7=20,AV7=21),0,IF(P7<>\"\",U7,0)))","v":0},{"$f":"IF(OR(AV7=4,AV7=7),AX7,0)","v":0},{"$f":"IF(OR(AV7=11,AV7=17),AX7,0)","v":0},{"$f":"IF(AH7=\"\",0,AH7)","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=4,AV7=5,AV7=6,AV7=7,AV7=3,AV7=1),U7,0))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=4,AV7=5,AV7=6,AV7=7,AV7=3,AV7=1,AV7=20),AE7,0))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=4,AV7=5,AV7=6,AV7=7,AV7=3,AV7=1,AV7=20),N7-BB7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=8,AV7=14,AV7=15,AV7=16,AV7=21),U7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=8,AV7=14,AV7=15,AV7=16,AV7=21),AE7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=8,AV7=14,AV7=15,AV7=16,AV7=21),N7-BB7,0))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=9,AV7=20),U7,0))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=9,AV7=20),AE7,0))","v":0},{"$f":"IF(U7=\"\",0,IF(OR(AV7=9,AV7=20),N7-BB7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=10,AV7=11,AV7=12,AV7=13,AV7=17,AV7=18),U7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=10,AV7=11,AV7=12,AV7=13,AV7=17,AV7=18),AE7,0))","v":0},{"$f":"IF(OR(U7=\"\",AV7=20),0,IF(OR(AV7=10,AV7=11,AV7=12,AV7=13,AV7=17,AV7=18),N7-BB7,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,{"$f":"IF(OR(L8=\"\",U8=\"\"),\"\",IF(AND(E8=1,L8>=45),45,IF(AND(E8=1,L8<45),45,IF(AND(E8=2,L8>60),60,IF(AND(E8=2,L8<60),60,IF(AND(F8=3,L8>72),72,IF(AND(E8>2,X8*12+60>L8),X8*12+60,X8*12+60)))))))","v":""},{"$f":"IF(OR(L8=\"\",U8=\"\",U8=0),\"\",IF(AND(E8=1,L8>=45),45,IF(AND(E8=1,L8<45),L8,IF(AND(E8=2,L8>60),60,IF(AND(E8=2,L8<60),L8,IF(AND(F8=3,L8>72),72,IF(AND(E8>2,X8*12+60>L8),L8,X8*12+60)))))))","v":""},null,{"$f":"IF(AND(P8=\"x\",S8=\"x\",T8=\"x\"),\"\",IF(AND(P8=\"x\",R8=\"x\",S8=\"x\"),\"\",IF(OR(AV8=8,AV8=9,U8=\"\"),\"\",IF(OR(AV8=4,AV8=11),Z8*16/100,\"\"))))","v":""},null,{"$error":"#VALUE!"},{"$f":"IF(OR(U8=\"\",Z8=\"\",Z8=0),\"\",IF(AD8=0,\"\",IF(AD8/U8>L8,L8*U8,AD8)))","v":""},null,"","",null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTIF(P8:T8,\"X\")=3,P8=\"X\",S8=\"X\",T8=\"X\"),17,IF(COUNTIF(P8:T8,\"x\")=0,1,0))","v":1},{"$f":"IF(AND(COUNTIF(P8:T8,\"x\")=2,P8=\"x\",T8=\"X\"),7,IF(AND(COUNTIF(P8:T8,\"x\")=1,P8=\"X\"),4,IF(AND(COUNTIF(P8:T8,\"x\")=1,T8=\"X\"),6,0)))","v":0},{"$f":"IF(AND(COUNTIF(P8:T8,\"x\")=2,S8=\"X\",R8=\"X\"),9,IF(AND(COUNTIF(P8:T8,\"x\")=2,S8=\"X\",P8=\"X\"),11,IF(AND(COUNTIF(P8:T8,\"x\")=2,S8=\"X\",T8=\"X\"),12,IF(AND(COUNTIF(P8:T8,\"x\")=1,S8=\"X\"),13,0))))","v":0},{"$f":"IF(AND(COUNTIF(P8:T8,\"X\")=3,P8=\"X\",R8=\"X\",T8=\"X\"),21,IF(AND(COUNTIF(P8:T8,\"x\")=1,R8=\"X\"),8,IF(AND(COUNTIF(P8:T8,\"x\")=2,R8=\"X\",P8=\"X\"),15,IF(AND(COUNTIF(P8:T8,\"x\")=2,R8=\"X\",T8=\"X\"),16,0))))","v":0},{"$f":"IF(AND(COUNTIF(P8:T8,\"x\")=4,P8=\"X\",R8=\"X\",S8=\"X\",T8=\"X\"),20,IF(AND(COUNTIF(P8:T8,\"x\")=3,R8=\"X\",S8=\"X\",T8=\"X\"),20,IF(AND(COUNTIF(P8:T8,\"x\")=3,P8=\"X\",R8=\"X\",S8=\"X\"),20,0)))","v":0},{"$f":"SUM(AQ8:AU8)","v":1},{"$f":"IF(U8=\"\",0,IF(OR(AV8=8,AV8=9,AV8=14,AV8=20),0,IF(Q8<>\"\",AE8,0)))","v":0},0,0,{"$f":"IF(OR(AV8=4,AV8=7),AX8,0)","v":0},{"$f":"IF(OR(AV8=11,AV8=17),AX8,0)","v":0},{"$f":"IF(AH8=\"\",0,AH8)","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=4,AV8=5,AV8=6,AV8=7,AV8=3,AV8=1),U8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=4,AV8=5,AV8=6,AV8=7,AV8=3,AV8=1),AE8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=4,AV8=5,AV8=6,AV8=7,AV8=3,AV8=1),N8-BB8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=8,AV8=14,AV8=15,AV8=16,AV8=21),U8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=8,AV8=14,AV8=15,AV8=16,AV8=21),AE8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=8,AV8=14,AV8=15,AV8=16,AV8=21),N8-BB8,0))","v":0},{"$f":"IF(U8=\"\",0,IF(OR(AV8=9,AV8=20),U8,0))","v":0},{"$f":"IF(U8=\"\",0,IF(OR(AV8=9,AV8=20),AE8,0))","v":0},{"$f":"IF(U8=\"\",0,IF(OR(AV8=9,AV8=20),N8-BB8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=10,AV8=11,AV8=12,AV8=13,AV8=17,AV8=18),U8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=10,AV8=11,AV8=12,AV8=13,AV8=17,AV8=18),AE8,0))","v":0},{"$f":"IF(OR(U8=\"\",AV8=20),0,IF(OR(AV8=10,AV8=11,AV8=12,AV8=13,AV8=17,AV8=18),N8-BB8,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,{"$f":"IF(AND(P9=\"x\",S9=\"x\",T9=\"x\"),\"\",IF(AND(P9=\"x\",R9=\"x\",S9=\"x\"),\"\",IF(OR(AV9=8,AV9=9,U9=\"\"),\"\",IF(OR(AV9=4,AV9=11),Z9*16/100,\"\"))))","v":""},null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C16=\"\",L16=\"\"),\"\",L16*C16)","v":""},null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,{"$f":"IF(U19=\"\",0,IF(OR(AV19=8,AV19=9,AV19=15,AV19=20,AV19=21),0,IF(P19<>\"\",AE19,0)))","v":0},{"$f":"IF(U19=\"\",0,IF(OR(AV19=8,AV19=9,AV19=15,AV19=20,AV19=21),0,IF(P19<>\"\",U19,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,{"$f":"IF(U20=\"\",0,IF(OR(AV20=8,AV20=9,AV20=15,AV20=20,AV20=21),0,IF(P20<>\"\",AE20,0)))","v":0},{"$f":"IF(U20=\"\",0,IF(OR(AV20=8,AV20=9,AV20=15,AV20=20,AV20=21),0,IF(P20<>\"\",U20,0)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,null,null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,{"$f":"Z25","v":""},null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C34=\"\",L34=\"\"),\"\",L34*C34)","v":""},null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C43=\"\",L43=\"\"),\"\",L43*C43)","v":""},null,null,null,null,null,null,null,{"$f":"IF(L43<Z43,L43,Z43)","v":""},{"$f":"IF(OR(L43=\"\",Z43=\"\"),0,L43-Z43)","v":0},{"$f":"IF(E43=\"\",0,E43-2)","v":0},{"$f":"IF(OR(L43=\"\",U43=\"\"),\"\",IF(AND(E43=1,L43>=45),45,IF(AND(E43=1,L43<45),45,IF(AND(E43=2,L43>60),60,IF(AND(E43=2,L43<60),60,IF(AND(F43=3,L43>72),72,IF(AND(E43>2,X43*12+60>L43),X43*12+60,X43*12+60)))))))","v":""},"",null,"",null,{"$error":"#VALUE!"},"",null,{"$f":"IF(C43=\"\",\"\",IF(C43-U43=0,\"\",C43-U43))","v":""},{"$f":"IF(AG43=\"\",\"\",AG43*L43)","v":""},null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"TODAY()","v":"2023-07-17"},null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",0,0,"","",null,"",null,{"$error":"#VALUE!"},"",null,"","",null,null,null,null,null,null,"",null,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"IF(SUM(C7:D52)=0,\"\",(SUM(C7:D52)))","v":""},null,"Summe",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N7:N52)=0,\"\",SUM(N7:N52))","v":""}]
[]
[]
[]
[null,"Antragsteller:",null,null,null,null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"         Seite 3a  von Seite 8"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P47<>\"\",Q47<>\"\"),0,IF(AND(P47<>\"\",Q47<>\"\",T47<>\"\"),0,IF(AND(Q47<>\"\",T47<>\"\"),3,IF(AND(P47<>\"\",T47<>\"\"),7,IF(P47<>\"\",4,IF(Q47<>\"\",5,IF(T47<>\"\",6,\"\")))))))","v":""},{"$f":"IF(SUM(N7:O52)-SUM(AH7:AI52)=0,\"\",SUM(N7:O52)-SUM(AH7:AI52))","v":""},{"$f":"SUM(U7:U52)","v":0},null,null,null,{"$f":"SUM(AW7:AW52)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P49<>\"\",Q49<>\"\"),0,IF(AND(P49<>\"\",Q49<>\"\",T49<>\"\"),0,IF(AND(Q49<>\"\",T49<>\"\"),3,IF(AND(P49<>\"\",T49<>\"\"),7,IF(P49<>\"\",4,IF(Q49<>\"\",5,IF(T49<>\"\",6,\"\")))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AE7:AF52)=0,0,SUM(AE7:AF52))","v":0},{"$f":"SUM(AG7:AG52)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(AG7:AG52)=0,\"\",SUM(AG7:AG52))","v":""},{"$f":"IF(SUM(AH7:AI52)=0,\"\",SUM(AH7:AI52))","v":""},null,null,"nicht geförderte WE (Wohnfläche)",null,null,null,null,null,null,null,null,{"$f":"AS60","v":0},{"$f":"IF(SUM(N7:O52)-SUM(AH7:AI52)=0,\"\",SUM(N7:O52)-SUM(AH7:AI52))","v":""},null,null,"tatsächliche Fläche der gef. WE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF60","v":0},{"$f":"BG60","v":0},null,null,"davon mittelb. Belegung, geringe Einkommen",null,null,null,null,null,null,null,null,{"$f":"SUM(U7:U52)","v":0},{"$f":"IF(SUM(AE7:AF52)=0,\"\",SUM(AE7:AF52))","v":""},null,null,"förderfähige Wohnfläche"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BL60","v":0},{"$f":"BM60","v":0},null,null,"davon mittlere Einkommen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC60","v":0},{"$f":"BD60","v":0},null,null,"davon geringe Einkommen",null,null,null,null,null,null,null,null,{"$f":"AY60","v":0},{"$f":"AX60","v":0},null,null,"davon Fläche gem. DIN 18040 mit \"R\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BI60","v":0},{"$f":"BJ60","v":0},null,null,"davon mittelb. Belegung, mittl. Einkommen",null,null,null,null,null,null,null,null,{"$f":"AZ60","v":0},{"$f":"AW60","v":0},null,null,"davon Fläche gem. DIN 18040 ohne \"R\""]

{"sheet":"Kosten und Finanzierung","index":4,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":false,"merged":[[36,4,36,13],[22,19,24,19],[22,16,24,16],[25,19,27,19],[22,17,24,17],[1,1,1,2],[18,18,19,23],[20,20,20,23],[18,16,18,17],[20,18,20,19],[18,1,18,2],[3,1,3,2],[7,20,7,22],[8,20,8,22],[4,1,4,2],[3,20,3,22],[4,20,4,22],[5,20,5,22],[6,20,6,22],[47,17,49,17],[44,17,46,17],[44,18,46,18],[28,22,30,23],[37,22,39,23],[39,4,39,13],[28,19,30,19],[28,20,30,20],[37,16,39,16],[34,20,36,20],[34,22,36,23],[37,20,39,20],[34,17,36,17],[37,17,39,17],[37,18,39,18],[44,20,46,20],[34,18,36,18],[28,16,30,16],[28,17,30,17],[28,18,30,18],[44,16,46,16],[34,16,36,16],[44,22,46,23],[46,4,46,13],[53,11,53,16],[51,11,52,16],[5,1,5,2],[6,1,6,2],[8,1,8,2],[7,1,7,2],[17,1,17,2],[11,1,11,2],[10,1,10,2],[9,1,9,2],[13,1,13,2],[14,1,14,2],[49,4,49,13],[47,16,49,16],[12,8,12,16],[50,1,50,2],[51,1,51,2],[53,1,53,2],[40,1,40,2],[25,16,27,16],[31,16,33,16],[41,16,43,16],[43,4,43,13],[11,4,11,19],[70,22,70,23],[62,19,62,22],[60,18,60,20],[25,22,27,23],[66,22,66,23],[67,22,67,23],[47,20,49,20],[65,22,65,23],[40,22,40,23],[41,22,43,23],[47,22,49,23],[41,20,43,20],[41,19,43,19],[47,19,49,19],[47,18,49,18],[25,20,27,20],[25,18,27,18],[44,19,46,19],[41,18,43,18],[31,18,33,18],[31,19,33,19],[31,20,33,20],[31,22,33,23],[37,19,39,19],[55,0,68,0],[66,1,66,2],[54,11,55,16],[56,11,57,16],[58,11,59,16],[60,11,61,16],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[65,4,65,17],[61,4,61,9],[58,1,58,2],[60,1,60,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[41,17,43,17],[1,19,2,19],[5,4,5,19],[6,4,6,19],[8,4,8,19],[9,4,9,19],[10,4,10,19],[19,16,19,17],[22,20,24,20],[14,20,14,22],[9,20,9,22],[10,20,10,22],[11,20,11,22],[21,22,21,23],[22,22,24,23],[12,20,12,22],[22,18,24,18],[25,17,27,17],[31,17,33,17],[34,19,36,19],[24,4,24,13],[27,4,27,13],[30,4,30,13],[33,4,33,13]]}
[]
[null," 8.",null,null,"Aufstellung der Gesamtkosten (inkl. MwSt)"]
[]
[null,"8.1",null,null,"Grundstücks- u. öffentl. Erschließungskosten (KG 100 + 200 ohne KG 120)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.2",null,null,"Grundstücksnebenkosten (KG 120)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.3",null,null,"Gebäudeherstellkosten (KG 300 + 400)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.4",null,null,"Gebäudeherstellkosten einer separaten TG (KG 300 + 400)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.5",null,null,"Kosten der Außenanlage (KG 500 ohne KG 534)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.6",null,null,"Herstellkosten Stellplätze (KG 534) / Garagen (KG 300)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.7",null,null,"Baunebenkosten (KG 700 ohne KG 800)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.8",null,null,"Finanzierungskosten (KG 800)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.9",null,null,"Gebäuderestwert",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[null,"8.10",null,null,"Sonstiges: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€"]
[]
[null,"8.11",null,null,"Summe der Gesamtkosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(U4:W13)=0,\"\",SUM(U4:W13))","v":""},null,null,"€"]
[]
[]
[null," 9.",null,"Aufstellung der Finanzierungsmittel (inkl. der beantragten Fördermittel)"]
[null," 9.1",null,null,"Fremdmittel",null,null,null,null,null,null,null,null,null,null,null,"Nominal",null,"Jahresleistungen"]
[null,null,null,null,"grundbuchlich zu sichern ( in der ",null,null,null,null,null,null,null,null,null,null,null,"(€)"]
[null,null,null,null,"Reihenfolge des vorgesehenen ",null,null,null,null,null,null,null,null,null,null,null,"Ausz.",null,"Sollzinsen",null,"Tilgung"]
[null,null,null,null,"grundbuchlichen Ranges)",null,null,null,null,null,null,null,null,"Rang",null,null,"v. H.",null,"v. H.",null,"v.H. "]
[null," 9.1.1",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R23=\"\",\"\",R23*S23/100)","v":""},null,null,{"$f":"IF(R23=\"\",\"\",R23*U23/100)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R23<>0,1,0)","v":0}]
[null," 9.1.2",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R26=\"\",\"\",R26*S26/100)","v":""},null,null,{"$f":"IF(R26=\"\",\"\",R26*U26/100)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R26>0,1,0)","v":0}]
[null," 9.1.3",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R29=\"\",\"\",R29*S29/100)","v":""},null,null,{"$f":"IF(R29=\"\",\"\",R29*U29/100)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R29>0,1,0)","v":0}]
[null,"9.1.4",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R32=\"\",\"\",R32*S32/100)","v":""},null,null,{"$f":"IF(R32=\"\",\"\",R32*U32/100)","v":""}]
[]
[]
[null,"9.1.5",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R35=\"\",\"\",R35*S35/100)","v":""},null,null,{"$f":"IF(R35=\"\",\"\",R35*U35/100)","v":""}]
[]
[]
[null,"9.1.6",null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R38=\"\",\"\",R38*S38/100)","v":""},null,null,{"$f":"IF(R38=\"\",\"\",R38*U38/100)","v":""}]
[]
[]
[null," 9.2",null,null,"Sonstige Fremdmittel (grundbuchlich nicht zu sichern)"]
[null,null,null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R42=\"\",\"\",R42*S42/100)","v":""},null,null,{"$f":"IF(R42=\"\",\"\",R42*U42/100)","v":""}]
[]
[null,"9.2.1"]
[null,null,null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R45=\"\",\"\",R45*S45/100)","v":""},null,null,{"$f":"IF(R45=\"\",\"\",R45*U45/100)","v":""}]
[]
[null,"9.2.2"]
[null,null,null,null,"Geldgeber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R48=\"\",\"\",R48*S48/100)","v":""},null,null,{"$f":"IF(R48=\"\",\"\",R48*U48/100)","v":""}]
[]
[null,"9.2.3"]
[null," 9.3",null,null,"Eigenleistungen"]
[null," 9.3.1",null,null,"Wert d. Baugrundstücks"]
[null,null,null,null,"(abzgl. Belastungen)"]
[null," 9.3.2",null,null,"Bargeld und Guthaben",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(U15=\"\",R64=0),\"\",IF(U15<>R64,\"Finanzierung ungleich Kosten\",\"\"))","v":""}]
[null," 9.3.3",null,null,"Selbst- und ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R64<>U15,\"Der Gesamtbetrag muss Ziffer 8. decken.\",\"\")","v":""}]
[{"$f":"TODAY()","v":"2023-07-17"},null,null,null,"Verwandtenhilfe"]
[null," 9.3.4",null,null,"Sachleistungen, "]
[null,null,null,null,"bezahlte Baumaterialien"]
[null," 9.3.5 ",null,null,"Wert verwendeter "]
[null,null,null,null,"Gebäudeteile"]
[null," 9.3.6",null,null,"Sonstiges:"]
[null,null,null,null,"_________________"]
[null," 9.3.7",null,null,"S u m m e  der  Eigenleistungen",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L52:Q62)","v":0},null,{"$f":"IF(P63=0,\"\",P63)","v":""},null,{"$f":"IF(OR(R63=\"\",U15=\"\"),\"\",(SUM(L52:Q62))/U15*100)","v":""}]
[null," 9.4",null,null,"Gesamtbetrag der Finanzierung",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R23:R50)+P63=0,\"\",SUM(R23:R50)+P63)","v":""}]
[null," 9.5",null,null,"Gesamtbetrag der Sollzinsen für Fremdmittel (inkl. Fördermittel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T23:T50)=0,\"\",SUM(T23:T50))","v":""}]
[null," 9.6",null,null,"Gesamtbetrag der Tilgung für Fremdmittel (inkl. Fördermittel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W23:W50)=0,\"\",SUM(W23:W50))","v":""}]
[null," 9.7",null,null,"Gesamtbeträge",null,null,null,null,null,null,null,null,null,null,null,null,"Finanzierungsmittel",null,"Sollzinsen",null,null,"Tilgung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R64","v":""},null,{"$f":"T65","v":""},null,null,{"$f":"W66","v":""}]
[]
[]
[null,"Antragsteller:",null,null,null,null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 4 von Seite 8"]

{"sheet":"Wirtschaftlichkeitsberechnung","index":5,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[6,1,6,8],[7,16,7,18],[2,1,2,8],[3,1,3,8],[2,9,2,10],[3,9,3,10],[4,9,4,10],[36,20,36,22],[8,16,8,18],[9,16,9,18],[8,1,8,2],[9,1,9,2],[19,17,19,19],[13,22,14,22],[31,1,31,22],[32,1,32,22],[28,1,28,22],[29,1,29,22],[30,1,30,22],[0,1,0,22],[2,11,2,14],[3,11,3,14],[27,1,27,22],[4,1,4,8],[5,9,5,10],[4,16,4,18],[5,16,5,18],[6,16,6,18],[15,22,16,22],[2,16,2,18],[3,16,3,18],[7,1,7,8],[6,9,6,10],[7,9,7,10],[5,1,5,8]]}
["10.","Wirtschaftlichkeitsberechnung"]
["10.1","Erträge (Mieteinnahmen der Kaltmieten) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beträge € jährlich "]
["10.1.1","geförderte WE \"geringe Einkommen\" mit insg.",null,null,null,null,null,null,null,{"$f":"IF(SUM(Gebäude!BC36,Gebäude!BC38)=0,\"\",SUM(Gebäude!BC36,Gebäude!BC38))","v":""},null," m²  tatsächl. WF.",null,null,null,"x",null,null,null,"€"," je m² ",null,{"$f":"IF(OR(J3=\"\",Q3=\"\"),\"\",ROUND(J3*Q3*12,0))","v":""}]
["10.1.2","geförderte WE \"mittlere Einkommen\" mit insg.",null,null,null,null,null,null,null,{"$f":"IF(SUM(Gebäude!BL38,Gebäude!BL36)=0,\"\",SUM(Gebäude!BL38,Gebäude!BL36))","v":""},null," m²  tatsächl. WF",null,null,null,"x",null,null,null,"€"," je m² ",null,""]
["10.1.3","nicht geförd. Wohnungen mit insges. ",null,null,null,null,null,null,null,{"$f":"Gebäude!AB58","v":""},null," m²  Wohnfläche ",null,null,null,"x ",null,null,null,"€"," je m² ",null,""]
["10.1.4","Wohnungen mit \"mittelbare Belegung\"",null,null,null,null,null,null,null,{"$f":"IF(SUM(Gebäude!BF36,Gebäude!BF38,Gebäude!BI36,Gebäude!BI38)=0,\"\",SUM(Gebäude!BF36,Gebäude!BF38,Gebäude!BI36,Gebäude!BI38))","v":""},null," m²  Wohnfläche ",null,null,null,"x ",null,null,null,"€"," je m²",null,""]
["10.1.5","Wohnungen im Bestand mit insges.",null,null,null,null,null,null,null,{"$f":"IF(Gebäude!AB38=\"\",\"\",Gebäude!AB38)","v":""},null," m²  Wohnfläche ",null,null,null,"x",null,null,null,"€"," je m²",null,""]
["10.1.6","gewerbl. genutzte Räume mit insges.",null,null,null,null,null,null,null,{"$f":"IF(Gebäude!AB40=\"\",\"\",Gebäude!AB40)","v":""},null," m²  Fläche",null,null,null,"x ",null,null,null,"€"," je m² ",null,""]
["10.1.7",{"$f":"IF(Gebäude!O60=0,\"\",Gebäude!O60)","v":""},null,"Anzahl  Abstellplätze",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,null,"€"," je Stck.",null,{"$f":"IF(Q9=\"\",\"\",ROUND(Q9*Gebäude!O60*12,0))","v":""}]
["10.1.8",{"$f":"IF(SUM(Gebäude!X60:Y60,Gebäude!AD60:AE60)=0,\"\",SUM(Gebäude!X60:Y60,Gebäude!AD60:AE60))","v":""},null,"Anzahl  Garagen/Einstellplätze Tiefgarage",null,null,null,null,null,null,null,null,null,null,null,"x ",null,null,null,"€"," je Stck.",null,{"$f":"IF(Q10=\"\",\"\",ROUND(Q10*(Gebäude!X60+Gebäude!AD60)*12,0))","v":""}]
["10.1.9","laufende Zuschüsse (1. Jahresrate)"]
["10.1.10","sonstige Erträge (Jahresbetrag):"]
["10.1.11","Summe der Erträge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(W3:W12)=0,\"\",SUM(W3:W12))","v":""}]
[]
["10.2","Aufwendungen"]
["10.2.1","Pauschaler Kostenansatz von 20 Prozent des Rohertrags (Summe 10.1.1 bis 10.1.8) für",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W13=\"\",\"\",SUM(W3:W10)*0.2)","v":""}]
[null,"Bewirtschaftungskosten (Verwaltungskosten, Instandhaltungskosten, Mietausfallwagnis)"]
["10.2.2","Erbbauzinsen "]
["10.2.3","Sonstige Belastungen"]
["10.2.4","Summe der Aufwendungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W20=\"\",\"\",\"entspricht:\")","v":""},null,null,{"$f":"IF(OR(W20=\"\",W13=\"\"),\"\",W20/W13*100)","v":""},null,{"$f":"IF(SUM(W16:W19)=0,\"\",SUM(W16:W19))","v":""}]
["10.3","Mietreinertrag (Summe der Erträge abzüglich Summe der Aufwendungen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W13=\"\",W20=\"\"),\"\",W13-W20)","v":""}]
["10.4","Kapitaldienst (Gesamtbetrag der Sollzinsen und Tilgung für Fremdmittel inkl. beantragter Fördermittel)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM('Kosten und Finanzierung'!T68:W68)=0,\"\",SUM('Kosten und Finanzierung'!T68:W68))","v":""}]
["10.5",{"$f":"IF(W23<0,\"Unterdeckung\",\"Überdeckung (Mietreinertrag abzüglich Kapitaldienst)\")","v":"Überdeckung (Mietreinertrag abzüglich Kapitaldienst)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W21=\"\",W22=\"\"),\"\",W21-W22)","v":""}]
[null,"Hinweis: Sollte sich eine Unterdeckung ergeben, ist dies näher zu erläutern. "]
[]
[null,"Erläuterungen:"]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"TODAY()","v":"2023-07-17"}]
[]
[]
["Antragsteller:",null,null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 5 von Seite 8"]

{"sheet":"Erklärungen","index":6,"n_rows":110,"n_cols":42,"rows_kept":110,"cut":false,"hidden":false,"merged":[[109,22,109,26],[87,2,87,25],[88,2,88,25],[89,2,89,25],[102,2,102,6],[105,2,105,6],[105,8,105,25],[109,2,109,3],[108,2,108,3],[108,22,108,26],[107,2,107,3],[107,22,107,26],[1,5,1,17],[3,5,3,17],[37,2,37,25],[70,2,70,3],[70,22,70,26],[66,2,66,4],[66,8,66,24]]}
[]
[null,"Antragsteller/in:",null,null,null,{"$f":"IF(Antrag!D12=\"\",\"\",Antrag!D12)","v":""}]
[]
[null,"Objektort und -straße:",null,null,null,{"$f":"IF(Antrag!D23=\"\",\"\",CONCATENATE(Antrag!D23,\", \",Antrag!D25,\" \"))","v":""}]
[]
["    Verbindliche Erklärungen der Antragsteller/Darlehensnehmer:"]
[]
[null,"1. Bei Beantragung des Baudarlehens/Finanzierungszuschusses nach den Landesrichtlinien:"]
[null,"Mir/Uns ist bekannt, dass"]
[null,"-","die Antragstellung und Förderzusage auf der Grundlage der Richtlinie des Landes Hessen zur sozialen Mietwohnraumförderung "]
[null,null,"vom 09.09.2020 (StAnz. 40/2020 S. 987 ff.) und des Sonderprogramms \"Klimabonus in der sozialen Wohnraumförderung\" des Landes Hessen ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"vom 19.07.2022 (StAnz. 32/2022, S. 913 ff.) erfolgt,"]
[null,"-","mit der Maßnahme nicht vor Aufnahme in das Förderprogramm durch das für das Wohnungswesen zuständige Ministerium begonnen"]
[null,null,"werden darf,"]
[null,"-","die bei Anmeldung des Bauvorhabens angegebene Einstiegsmiete für die geförderten Wohnungen verbindlich ist,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"-","die Wirtschafts- und Infrastrukturbank Hessen berechtigt ist, ein einmaliges Bearbeitungsentgelt von 1 % des bewilligten Darlehens und jeweils"]
[null,null,"0,5 % des bewilligten Finanzierungszuschusses sowie des bewilligten Klimabonusses zu erheben. "]
[null,"-","im Fall der Nichtabnahme der zugesagten Mittel die Wirtschafts- und Infrastrukturbank Hessen eine Entschädigung verlangen kann. "]
[null,"-","die Checkliste zum Antrag auszufüllen und die entsprechenden Nachweise dazu mit dem Förderantrag einzureichen sind."]
[null,"2. Bei Beantragung von WIBank-Darlehen aus den Mitteln der KfW:"]
[null,"Mir/Uns ist bekannt, dass"]
[null,"-","mit der Maßnahme nicht vor Refinanzierung der Darlehen bei der KfW begonnen werden darf."]
[null,"-","im Fall der Nichtabnahme der zugesagten Mittel die Wirtschafts- und Infrastrukturbank Hessen eine Entschädigung verlangen kann."]
[]
[null,"-","für die Antragstellung und Zusage der Mittel zusätzlich die Vorgaben des entsprechenden KfW-Programmes gelten."]
[]
[null,"Datenschutzerklärung für Antragsteller / Mithafter im Rahmen der Sofortbestätigung Light und Sofortbestätigung Plus"]
[null,"sowie der Sofortbestätigung:"]
[]
[null,"-","Ich/Wir nehme(n) zur Kenntnis, dass meine/unsere Daten im Rahmen der Beantragung einer der o. g. Sofortbestätigungen von der KfW und "]
[null,null,"der Wirtschafts- und Infrastrukturbank Hessen als durchleitendes Kreditinstitut verarbeitet werden. Die Datenschutzgrundsätze der KfW und "]
[null,null,"die produktspezifischen Datenschutzhinweise der KfW wurden mir/uns zur Verfügung gestellt und ich/wir habe(n) diese zur Kenntnis genommen."]
[]
[null,"Erklärungen / Einwilligungen für die Refinanzierungszusage von Antragsteller / Mithafter:"]
[]
[null,"-","Ich/Wir bestätige(n) die Richtigkeit und Vollständigkeit der in diesem Antrag gemachten Angaben. Mir/Uns ist bekannt, dass die "]
[null,null,"Kreditkonditionen zum Zeitpunkt der Erteilung der Kreditzusage der KfW an die Wirtschafts- und Infrastrukturbank Hessen festgelegt werden, "]
[null,null,"soweit für einzelne Programme nicht ausdrücklich etwas anderes gilt. "]
[null,"-","Zusatz für Anträge auf Kredite aus öffentlichen, insbesondere ERP-Mitteln: "]
[null,null,"Mir/Uns ist bekannt, dass die vorstehenden Angaben gemäß dem jeweiligen Programm-Merkblatt (bei ERP-Krediten gemäß den "]
[null,null,"„Allgemeinen Bedingungen für die Vergabe von ERP-Mitteln“ in Verbindung mit den Punkten „Antragsberechtigte“ und „Verwendungszweck“ "]
[null,null,"der Programmrichtlinien für ERP-Programme) subventionserheblich im Sinne von § 264 StGB in Verbindung mit § 2 Subventionsgesetz sind. "]
[null,null,"Die „Allgemeinen Bedingungen für die Vergabe von ERP-Mitteln“ sind mir/uns bekannt. Ich/Wir erkläre(n) mich/uns mit diesen Bedingungen "]
[null,null,"einverstanden. "]
[null,"-","Sofern für das beantragte Förderprodukt eine \"Datenliste Subventionserhebliche Tatsachen\" vorhanden ist:"]
[null,null,"Ich/Wir bestätige(n), dass mir/uns die \"Datenliste Subventionserhebliche Tatsachen\" für das von mir/uns beantragte Produkt/die von mir/uns "]
[null,null,"beantragten Produkte von der Wirtschafts- und Infrastrukturbank Hessen übergeben wurde. Mir/uns ist bekannt, dass die vorstehenden"]
[null,null,"Angaben der \"Datenliste Subventionserhebliche Tatsachen\" für das von mir/uns beantragte Produkt/die von mir/uns beantragten Produkte"]
[null,null,"subventionserheblich im Sinne von § 264 StGB in Verbindung mit § 2 Subventionsgesetz sind."]
[null,"-","Ich/Wir versichere/versichern, kein anderes Kreditinstitut mit der Antragstellung betraut zu haben. Ich/Wir verpflichte(n) mich/uns, die"]
[null,null,"Wirtschafts- und Infrastrukturbank Hessen über die wesentlichen Änderungen der zu diesem Antrag gemachten Angaben, die vor Auszahlung "]
[null,null,"des Darlehens eintreten, unverzüglich und unaufgefordert in Kenntnis zu setzen. Ich/Wir verpflichte(n) mich/uns, die Bereitstellungsprovision"]
[null,null,"in der programmgemäßen Höhe (vgl. Produkt-Merkblatt) sowie die bei Zusagen der KfW ggf. zu zahlende einmalige Zusagegebühr "]
[null,null,"in der programmgemäßen Höhe (vgl. Produkt-Merkblatt) an die Wirtschafts- und Infrastrukturbank Hessen zur Weiterleitung an die KfW zu "]
[null,null,"entrichten. Diese Bereitstellungsprovision sowie bei Zusagen der KfW ggf. die einmalige Zusagegebühr ist auch dann zu zahlen, wenn ich/wir "]
[null,null,"den beantragten und von der KfW zugesagten Kredit nicht in Anspruch nehme(n), es sei denn, dass ich/wir der Wirtschafts- und Infrastruktur-"]
[null,null,"bank Hessen innerhalb der für die Berechnung der Bereitstellungsprovision maßgeblichen Frist (vgl. Produkt-Merkblatt) mitteile(n), dass ich/wir "]
[null,null,"den Kredit nicht in Anspruch nehme(n). Über die Höhe der Bereitstellungsprovision bzw. der Zusagegebühr habe(n) ich/wir mich/uns"]
[null,null,"anhand des Programm-Merkblattes informiert. "]
[null,"-","Mir/Uns ist bekannt, dass die gegen mich/uns gerichteten Ansprüche aus dem Darlehensvertrag mit der Wirtschafts- und Infrastrukturbank "]
[null,null,"Hessen bereits mit ihrer Entstehung an die KfW zur Sicherheit abgetreten sind. "]
[null,"-","Ich/Wir nehme(n) zur Kenntnis, dass meine/unsere Daten im Rahmen der Beantragung der Refinanzierungszusage von der KfW und der "]
[null,null,"Wirtschafts- und Infrastrukturbank Hessen als durchleitendes Kreditinstitut verarbeitet werden. Die produktspezifischen Datenschutzhinweise  "]
[null,null,"der KfW in der zum Zeitpunkt der Anforderung der Sofortbestätigung gültigen Version wurden mir/uns zur Verfügung gestellt "]
[null,null,"und ich/wir habe(n) diese zur Kenntnis genommen. "]
[]
[]
[null,null,"Ort / Datum",null,null,null,null,null,"Unterschrift(en) Antragsteller/Mithafter"]
[]
[]
[null,null,"Antragsteller:",null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 6 von Seite 8"]
[]
[]
[]
[null,"3. Für die Beantragung der Finanzierungsmittel gemäß 1. und 2. sowie der Bürgschaft gilt außerdem:"]
[null,"Mir/Uns ist bekannt, dass"]
[null,"-","für die beantragten Finanzierungsmittel grundsätzlich bankübliche Sicherheiten zu stellen sind. "]
[null,"-","ein Baubuch zu führen ist."]
[null,"-","die Antragstellung und Zusage der Mittel ggf. auf der Grundlage der Richtlinien des Landes Hessen für die Übernahme von Bürgschaften zur"]
[null,null,"Sicherung von Investitionen in Wohngebäuden und Gebäuden mit sozialen Einrichtungen einschließlich der Allgemeinen Vertragsbedingungen "]
[null,null,"(Bürgschaftsrichtlinien 2019) erfolgt. "]
[null,"-","die in diesem Antrag enthaltenen Angaben subventionserheblich im Sinne des § 264 Strafgesetzbuches in Verbindung mit "]
[null,null,"§ 2 des Subventionsgesetzes und dem Hessischen Subventionsgesetz sowie nach § 263 des Strafgesetzbuches in der jeweils "]
[null,null,"geltenden Fassung sind und falsche Angaben zu einem Strafverfahren führen können."]
[null,"-","subventionserhebliche Tatsachen, die sich im Laufe der Abwicklung des Vorhabens ändern, der WIBank mitzuteilen sind."]
[]
["    Ich/Wir versicher(e/n)"]
[null,"-","die im Antrag und den beigefügten Unterlagen enthaltenen Angaben nach bestem Wissen und Gewissen richtig gemacht und keine "]
[null,null,"Tatsachen verschwiegen zu haben, die für die Beurteilung der Förderungswürdigkeit der Maßnahmen und die Beurteilung meiner/unserer "]
[null,null,"Leistungsfähigkeit und Zuverlässigkeit von Bedeutung sein könnten."]
[null,"-","dass, sofern Maßnahmen im KfW-Programm „KFN Klimafreundlicher Neubau Wohngebäude (298)\" durchgeführt werden,  die entsprechenden "]
[null,null,"Programmanforderungen in der derzeit gültigen Fassung eingehalten werden. Bei Bedarf werden die entsprechenden Nachweise vorgelegt."]
[null,"-","dass für die Investitionsvorhaben, die aus dem KfW-Programm finanziert werden, keine weiteren Mittel aus diesem Programm für dieselben "]
[null,null,"Vorhaben – auch nicht über andere Kreditinstitute – beantragt werden bzw. wurden."]
[]
["    Ich/Wir erkläre(n)"]
[null,"-","dass ich/wir die \"Datenschutzhinweise für Kunden und andere Betroffene\" der WIBank zur Kenntnis genommen habe(n)."]
[]
[null,"4. Bei Beantragung des Zinszuschusses (Energie-Effizienzprogramm): "]
[null,"Mir/Uns ist bekannt, dass "]
[null,"-","die Antragstellung und Zusage auf der Grundlage der Eckwerte des \"Hess. Energieeffizienzprogramms im Mietwohnungsbau“ erfolgt."]
[null,null,"   "]
[]
[null,null,"Ort / Datum"]
[]
[]
[null,null,"Betreuungsunternehmen/Beauftragter",null,null,null,null,null,"Unterschrift aller Antragsteller gem. Ziffer 5 auf Seite 2"]
[]
[]
[null,null,"Antragsteller:",null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seite 7 von Seite 8"]

{"sheet":"Erklärungen Teil 2","index":7,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[43,30,43,36],[37,10,37,12],[37,1,37,8],[4,1,4,8],[6,1,6,4],[6,5,6,8],[6,10,6,12],[4,9,4,12],[26,10,26,13],[25,1,25,8],[25,10,25,12]]}
[]
[null,"Bestätigung Architekt/in bzw. Entwurfsverfasser/in"]
[]
[null,"Architekt/in gem. § 57 Hess. Bauordnung"]
[null," ",null,null,null,null,null,null,null," "]
[null,"Name, Vorname / Firma",null,null,null,null,null,null,null,"Straße, Hausnummer"]
[null," ",null,null,null," ",null,null,null," "," "]
[null,"Telefon",null,null,null,"Titel",null,null,null,"PLZ","Ort"]
[]
[null,"Art des Baugenehmigungsverfahrens"]
[]
[]
[]
[]
[]
[]
[null,"Mit der Unterschrift wird bestätigt, dass die Richtlinie in der jeweils gültigen Fassung beachtet wird."]
[null,"Auf Verlangen der Bewilligungsstelle werden Nachweise vorgelegt."]
[]
[null,"Ich bestätige, dass ich die öffentlich-rechtlichen Verpflichtungen als Entwurfsverfasser/in aus § 57 HBO für das Vorhaben "]
[null,"übernehme und dass in den beigefügten Bauvorlagen alle öffentlich-rechtlichen Anforderungen eingehalten wurden. Die Bauvorlagen  "]
[null,"wurden von mir bzw. unter meiner verantwortlichen Leitung angefertigt. Mir ist bekannt, dass personenbezogene Daten aus dieser "]
[null,"Mitteilung und den vorgelegten Bauvorlagen in Dateien der Gemeinde und der Bauaufsicht gespeichert werden."]
[]
[]
[]
[null,"Ort / Datum",null,null,null,null,null,null,null,null,"Unterschrift Architekt/in bzw. Entwurfsverfasser/in"]
[]
[]
[null,"Stellungnahme des Magistrats/Kreisausschusses:"]
[]
[null,"Es wird bestätigt, dass"]
[null,"1. ","an dem vorgesehenen Standort Nachfrage an Wohnungen für Zielgruppen nach der Richtlinie besteht."]
[null,"2.","der Antrag einschließlich Anlagen vollständig ist und die in der maßgeblichen Richtlinie enthaltenen Förderungsvoraussetzungen "]
[null,null,"erfüllt sind."]
[]
[]
[]
[null,"Ort / Datum",null,null,null,null,null,null,null,null,"Unterschrift"]
[]
[]
[null,"Antragsteller:",null,null,null,{"$f":"IF(#REF!=\"\",\"\",CONCATENATE(#REF!,\"  \",#REF!))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""},null,null,null,"Seite 8  von Seite 8"]

{"sheet":"Anlage Berechnung Förderbetrag","index":8,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[17,6,17,7],[24,2,24,6],[29,4,29,5],[12,10,13,10],[19,6,19,7],[17,4,17,5],[19,4,19,5],[23,2,23,3],[21,4,21,5],[16,2,16,6],[34,6,36,7],[29,2,29,3],[23,4,23,5],[20,2,20,8],[31,4,31,5],[27,4,27,5],[27,2,27,3],[29,6,31,7],[28,2,28,8],[34,4,34,5],[21,6,23,7],[25,4,25,5],[1,4,1,8],[47,2,47,10],[12,11,13,11],[42,2,42,10],[17,2,17,3],[19,2,19,3],[21,2,21,3],[45,2,45,10],[25,6,27,7],[25,2,25,3],[31,2,31,3],[34,2,34,3],[36,4,36,5],[36,2,36,3],[46,2,46,10],[3,4,3,8]]}
[]
[null,null,"Antragsteller/in:",null,{"$f":"IF(Antrag!D12=\"\",\"\",Antrag!D12)","v":""}]
[]
[null,null,"Objektort und -straße:",null,{"$f":"IF(Antrag!D23=\"\",\"\",CONCATENATE(Antrag!D23,\", \",Antrag!D25,\" \"))","v":""}]
[]
[null,null,"Anlage:"]
[null,null,"Berechnung des Förderbetrages für das Baudarlehen "]
[null,null,"   A \"geringe Einkommen\" (gemäß Ziffer 4.1 des Antrags)"]
[null,null,"   B \"mittlere Einkommen\" (gemäß Ziffer 4.2 des Antrags)"]
[]
[]
[]
[null,null,"Höhe des Grundstückswerts je m² Boden einschl. Erschließungskosten "]
[null,null,"Grunderwerbsteuer und Kosten der Herrichtung des Grundstücks"]
[]
[]
[null,null,"Ermittlung des Grundbetrages\nauf Basis der jeweiligen förderfähigen Wohnfläche"]
[null,"A",{"$f":"IF(SUM(Gebäude!AB52,Gebäude!AB56)=0,\"\",SUM(Gebäude!AB52,Gebäude!AB56))","v":""},null,"x",null,{"$f":"IF(K13=\"\",\"\",IF(K13<200,1200,IF(K13<250,1300,IF(K13<300,1400,IF(K13<350,1500,IF(K13<400,1600,IF(K13<450,1700,IF(K13<500,1800,1900))))))))","v":""},null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C18=\"\",G18=\"\"),\"\",C18*G18)","v":""}]
[]
[null,"B",{"$f":"IF(SUM(Gebäude!AB50,Gebäude!AB54)=0,\"\",SUM(Gebäude!AB50,Gebäude!AB54))","v":""},null,"x",null,{"$f":"IF(K13=\"\",\"\",IF(K13<200,700,IF(K13<250,800,IF(K13<300,900,IF(K13<350,1000,IF(K13<400,1100,IF(K13<450,1200,IF(K13<500,1300,1400))))))))","v":""},null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C20=\"\",G20=\"\"),\"\",C20*G20)","v":""}]
[null,null,"Ermittlung Zuschlag Rollstuhlgerechtigkeit\nauf Basis der jeweiligen förderfähigen Wohnfläche \n(ohne Wohnfläche der Wohnungen mit mittelbarer Belegung)"]
[null,"A",{"$f":"IF(SUM(Gebäude!AX36:AX38)=0,\"\",SUM(Gebäude!AX36:AX38))","v":""},null,"x",null,150,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C22=\"\",G22=\"\"),\"\",C22*G22)","v":""}]
[]
[null,"B",{"$f":"IF(SUM(Gebäude!AY36:AY38)=0,\"\",SUM(Gebäude!AY36:AY38))","v":""},null,"x",null,null,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C24=\"\",G22=\"\"),\"\",C24*G22)","v":""}]
[null,null,"Ermittlung Zuschlag Passivhaus\nauf Basis der jeweiligen förderfähigen Wohnfläche"]
[null,"A",{"$f":"IF(AND(Gebäude!AK10=1,SUM(Gebäude!AB52,Gebäude!AB56)<>0),SUM(Gebäude!AB52,Gebäude!AB56),\"\")","v":""},null,"x",null,150,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C26=\"\",G26=\"\"),\"\",C26*G26)","v":""}]
[]
[null,"B",{"$f":"IF(AND(Gebäude!AK10=1,SUM(Gebäude!AB50,Gebäude!AB54)<>0),SUM(Gebäude!AB50,Gebäude!AB54),\"\")","v":""},null,"x",null,null,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C28=\"\",G26=\"\"),\"\",C28*G26)","v":""}]
[null,null,"Ermittlung Zuschlag Gemeinschaftsraum /Gemeinschaftsräume\nauf Basis der jeweiligen tatsächlichen Wohnfläche\n(ohne Wohnfläche der Wohnungen mit mittelbarer Belegung)\nim Verhältnis zur Gesamtwohnfläche"]
[null,"A",{"$f":"IF(OR(Gebäude!AB42=\"\",Gebäude!AY56=0),\"\",ROUND((Gebäude!AB42*Gebäude!AY56/100),2))","v":""},null,"x",null,500,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C30=\"\",G30=\"\"),\"\",C30*G30)","v":""}]
[]
[null,"B",{"$f":"IF(OR(Gebäude!AB42=\"\",Gebäude!AY58=0),\"\",ROUND((Gebäude!AB42*Gebäude!AY58/100),2))","v":""},null,"x",null,null,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(OR(C32=\"\",G30=\"\"),\"\",C32*G30)","v":""}]
[]
[null,null,"Ermittlung Zuschlag Aufzug /Aufzüge",null,null,null,null,null,null,null,{"$f":"IF(AND(C35=\"\",Gebäude!O63=\"\"),\"\",IF(AND(C35>0,Gebäude!O63=\"\"),\"Bitte Anzahl der Aufzüge auf Seite 3 angeben.\",\"\"))","v":""},null,null,null,null,{"$f":"Gebäude!O63","v":0}]
[null,"A",{"$f":"Gebäude!AA52","v":""},null,"x",null,3000,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(C35=\"\",\"\",IF(C35<=C37,T39,T41))","v":""},null,null,null,null,{"$f":"C35*G35*P34","v":{"$error":"#VALUE!"}},{"$f":"LARGE(C35:D37,1)","v":{"$error":"#NUM!"}},{"$f":"SMALL(C35:D37,1)","v":{"$error":"#NUM!"}}]
[]
[null,"B",{"$f":"Gebäude!AA50","v":""},null,"x",null,null,null,{"$f":"\"=\"","v":"="},null,{"$f":"IF(C37=\"\",\"\",IF(C37>C35,T41,T39))","v":""},null,null,null,null,{"$f":"C37*G35","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Q35>13.3*P34,1,2)","v":{"$error":"#NUM!"}},{"$f":"IF(R35>13.3*P34,1,2)","v":{"$error":"#NUM!"}},{"$f":"IF(S37=2,G35*R35)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"40000*P34-T37","v":{"$error":"#NUM!"}}]
[null,null,"Förderbetrag      A  \"geringe Einkommen\" ",null,null,null,null,null,null,null,{"$f":"IF(SUM(K18,K22,K26,K30,K35)=0,\"\",SUM(K18,K22,K26,K30,K35))","v":""},null,null,null,null,{"$f":"P34*40000","v":0},{"$f":"SUM(C35:D37)*G35","v":0},{"$f":"IF(Q39>P39,P39,Q39)","v":0},{"$f":"R35/SUM(C35:D37)*R39","v":{"$error":"#NUM!"}},{"$f":"SMALL(S39:S41,1)","v":{"$error":"#NUM!"}}]
[]
[null,null,"Förderbetrag      B  \"mittlere Einkommen\"",null,null,null,null,null,null,null,{"$f":"IF(SUM(K20,K24,K28,K32,K37)=0,\"\",SUM(K20,K24,K28,K32,K37))","v":""},null,null,null,null,null,null,null,{"$f":"Q35/SUM(C35:D37)*R39","v":{"$error":"#NUM!"}},{"$f":"LARGE(S39:S41,1)","v":{"$error":"#NUM!"}}]
[]
[null,null,"Hinweis: Sollte im Antragsformular auf Seite 1 ein anderer als der hier rechnerisch ermittelte Förderbetrag für das Baudarlehen gewählt werden, ist dies zu erläutern. "]
[]
[null,null,"Erläuterungen:"]

{"sheet":"Anlage Klimabonus","index":9,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,3,1,6],[3,3,3,6],[38,1,38,3],[43,1,43,3]]}
[]
[null,"Antragsteller/in:",null,{"$f":"IF(Antrag!D12=\"\",\"\",Antrag!D12)","v":""}]
[]
[null,"Objektort und -straße:",null,{"$f":"IF(Antrag!D23=\"\",\"\",CONCATENATE(Antrag!D23,\", \",Antrag!D25,\" \"))","v":""}]
[]
[]
[null,"HINWEIS:"]
[null,"Die Beantragung ist nur möglich, sofern Ihnen bereits eine entsprechende Mittelzuteilung im "]
[null,"Sonderprogramm \"Klimabonus in der sozialen Wohnraumförderung\" vom Land Hessen vorliegt. "]
[]
[null,"Anlage Klimabonus:"]
[null,"Berechnung des Zuschussbetrages aus dem Sonderprogramm "]
[null,"\"Klimabonus in der sozialen Wohnraumförderung\" "]
[null,{"$f":"IF(Gebäude!AK10=1,\"Eine Kombination aus Klimabonus und den Zuschlägen für ein Passivhaus ist nicht möglich! (s.  auch Ziffer 7.1.2)\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Förderbeträge Klima Neubau"]
[null,"Förderfähige Wohnfläche gemäß Ziffer 7.1.3: ",null,null,null,null,{"$f":"Gebäude!AB46","v":""},null,null,null,null,null,null,null,null,null,"<<<  auswählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,200]
[null,"geplanter Effizienzhausstandard: ",null,null,null,null,{"$f":"IF($N$18=1,$Q$16,IF($N$18=2,$P$17,IF($N$18=3,$P$18,IF($N$18=4,$P$19,IF($N$18=5,$P$20,IF($N$18=6,$P$21,\"\"))))))","v":"<<<  auswählen"},null,null,null,null,null,null,1,null,"55 EE/NH",300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 EE/NH",400]
[null,"Für den geplanten Effizienzhausstandard wird pro m² förderfähige Wohnfläche ein Klimabonus von EUR",null,null,null,null,null,null,null,null,{"$f":"IF(N18=1,\"________\",VLOOKUP(G18,$P$16:$Q$21,2,FALSE))","v":"________"},null,null,null,null,"40 Plus",450]
[null,"gewährt."]
[]
[null,"Der Zuschuss \"Klimabonus\" beläuft sich somit auf:",null,null,null,null,{"$f":"IF(N18=1,\"\",G16*K21)","v":""}]
[]
[]
[]
[]
[null,"Erklärung des Antragstellers und des Energieberaters:"]
[]
[null,"Es ist geplant, einen Neubau in der  "]
[]
[null,null,"Effizienzhaus-Stufe",null,{"$f":"IF($N$18=1,$Q$16,IF($N$18=2,$P$17,IF($N$18=3,$P$18,IF($N$18=4,$P$19,IF($N$18=5,$P$20,IF($N$18=6,$P$21,\"\"))))))","v":"<<<  auswählen"}]
[]
[null,"entsprechend der Bundesförderung für effiziente Gebäude (BEG) - zu errichten."]
[]
[]
[]
[]
[null,"Ort, Datum",null,null,null,"Unterschrift Antragsteller/in",null,{"$f":"IF(Antrag!F72=\"\",\"\",Antrag!F72)","v":""}]
[]
[]
[]
[]
[null,"Ort, Datum",null,null,null,"Stempel und Unterschrift",null,"Energieeffizienz-Experte"]
[null,null,null,null,null,"(wird in der Expertenliste unter www.energie-effizienz-experten.de in "]
[null,null,null,null,null,"den Kategorien für „Wohngebäude“ – Effizienzhaus geführt)"]

{"sheet":"Checkliste","index":10,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[36,4,38,4],[76,0,76,4],[68,0,68,4],[47,3,49,3],[47,4,49,4],[54,0,56,1],[54,3,56,3],[54,4,56,4],[47,2,49,2],[54,2,56,2],[47,0,49,1],[71,0,71,4],[72,0,72,4],[73,0,73,4],[74,0,74,4],[75,0,75,4],[42,0,44,1],[42,3,44,3],[42,4,44,4],[6,0,8,1],[6,3,8,3],[6,4,8,4],[17,0,17,4],[42,2,44,2],[6,2,8,2],[19,2,21,2],[36,2,38,2],[19,0,21,1],[19,3,21,3],[19,4,21,4],[36,0,38,1],[36,3,38,3]]}
[null,"                                                           Checkliste zum Antrag"]
[]
["Wichtiger Hinweis: Sofern die aufgeführten Unterlagen nicht bei Antragstellung vorgelegt "]
[" werden, wird dies zu Rückfragen führen und die Bearbeitungsdauer erheblich verlängern! "]
["Anträge mit nicht vollständig beigefügten Unterlagen werden ggf. nachrangig bearbeitet."]
[null,null,null," ↓   X einfügen oder Doppelklick   ↓"]
["Finanzierungsnachweise und Unterlagen zu den wirtschaftlichen Verhältnissen",null,"Liegt vor","Fehlt      (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.","Finanzierungsnachweise (verbindliche Zusagen oder Angebote für Kapitalmarkt- und andere Fremdmittel bzw. Zuschüsse)"]
["2.","Nachweise der Eigenleistung ( z.B. bare Mittel, bezahlte Baumaterialien, bezahltes Grundstück, Ansparung auf Bausparvertrag, Kapitalabfindung, Selbst- und Verwandtenhilfe)"]
["3.","Nachweis des Grundstückswertes, z. B. durch den Kaufvertrag"]
["4.","Bei privaten Antragstellern: aktuelle Einkommens- und Vermögensauskunft auf dem Vordruck der Wirtschafts- und Infrastrukturbank Hessen, zeitnahe (letzte 3 Jahre) Einkommensteuerbescheide mit Kopien der zugehörigen Steuererklärungen, zeitnahe Verdienstbescheinigung(en) des Arbeitgebers"]
["5.","Bei Unternehmen: Zeitnahe, geprüfte Bilanzen (letzte 3 Jahre) nebst Prüfungsberichten bzw. Vermögensstatus, Gesellschaftsvertrag mit evtl. Nachträgen, aktueller Handelsregisterauszug oder anderer Nachweis über die Vertretungsberechtigung, soweit diese Unterlagen der WIBank noch nicht vorliegen"]
["6."," Bei Beantragung von KfW-Darlehen der Vordruck \"Bestätigung zum Antrag (298)\" "]
["7.","Anlage \"Berechnung des Förderbetrages für das Baudarlehen\""]
[]
["Bei Fragen zu den Finanzierungsnachweisen sowie zu den Unterlagen über die wirtschaftlichen Verhältnisse, \nwenden Sie sich bitte an Ihren Kreditsachbearbeiter oder an die Telefonnummer 069 / 9132-2565."]
[]
["Unterlagen zum Bauvorhaben",null,"Liegt vor","Fehlt       (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.","Bauschein und bauaufsichtlich genehmigte Pläne soweit vorhanden bzw. Eingangsbestätigung der Bauaufsichtsbehörde und Bestätigung des Entwurfsverfassers"]
["2.","Maßstäbliche Bauzeichnungen (Grundrisse, Schnitte, Ansichten, Freiflächen); für die zu fördernden Wohnungen sind vollständig vermaßte Pläne erforderlich."]
["3.","Wohn- und Nutzflächenberechnung; für die zu fördernden Wohnungen ist diese Berechnung nach der Wohnflächenverordnung mit prüfbaren Rechenansätzen zu erstellen."]
["4.","Bruttorauminhalt- und Bruttogeschossflächenberechnung (BRI + BGF) sowie Maß der baulichen Nutzung, Grundflächenzahl (GRZ) und Geschossflächenzahl (GFZ)"]
["5."," Allgemeine Baubeschreibung einschl. Angabe des Standortes der Heizung und Wahl des Energieträgers"]
["6.","Aktueller Grundbuchauszug"]
["7.","Aktuelle Liegenschaftskarte mit Eintragung des Bauvorhabens"]
["8.","Aktueller Auszug aus dem Baulastenverzeichnis"]
["9.","Aktueller Auszug aus dem Altlastenkataster"]
["10.","Eintragungsbewilligungen oder Vertragsentwürfe zu Herrschvermerken im Bestandsverzeichnis und zu Eintragungen in Abt. II"]
["11.","Bei genossenschaftlichem Wohnungsbau: aktueller Auszug der Satzung und Muster eines Dauernutzungsvertrages"]
["12.","Grundstückskaufvertrag"]
[]
[]
["Sofern im Bauvorhaben Gewerbeeinheiten geplant bzw. vorhanden sind, bitte zusätzlich die folgenden Unterlagen vorlegen:",null,"Liegt vor","Fehlt       (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.","Gewerbeflächenberechnung (nach gif-Richtlinien MF/G)"]
["2.","Mieterliste und Gewerbemietverträge sowie eventuell abgeschlossene Zusatzvereinbarungen"]
[]
["Bei Erbbaurechten zusätzlich:",null,"Liegt vor","Fehlt       (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.","Erbbaurechtsvertrag / die Erbbauzinsvereinbarung sowie Nachweise zur aktuellen Erbbauzinshöhe"]
[]
["Bei Bildung von Wohnungseigentum nach WEG sind darüber hinaus noch diese Unterlagen/Nachweise beizufügen:",null,"Liegt vor","Fehlt       (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.","Vollständige Teilungserklärung inkl. Anlagen und Aufteilungspläne"]
["2.","Nachweis über die Höhe der aktuell vorhandenen Instandhaltungsrücklage"]
["3.","Letztes Eigentümerversammlungsprotokoll und letzter Wirtschaftsplan"]
[]
["Bei Maßnahmen im Gebäudebestand und/oder sofern sich auf dem zu verpfändenden Grundstück bereits Objekte befinden außerdem:",null,"Liegt vor","Fehlt       (Bitte unten begründen)","Nicht zutreffend"]
[null,null,null,"(bitte Begrün-","zutreffend"]
[null,null,null,"dung beifügen)"]
["1.      ","Grundrisse, Ansichten und Schnitte aller Bestandsgebäude"]
["2.","Bei Umbaumaßnahmen mit Grundrissänderungen: Grundriss- und Schnittzeichnungen mit farbiger Darstellung \"Abbruch, Bestand, Neu\""]
["3. ","Wohnflächenberechnung und Berechnung des umbauten Raums"]
["4.","GFZ-Berechnung (falls vorhanden)"]
["5.","Ist-Bauzustandsbeschreibung (inkl. durchgeführte Instandhaltungs- und Modernisierungsmaßnahmen) sowie eine Beschreibung der geplanten Modernisierungs-, Instandsetzungs- und Energieeinsparungsmaßnahmen"]
["6.","Bei nicht gebundenen Mehrfamilienhäusern mit/ohne Gewerbeeinheiten, Vorlage einer Mieterliste (mind. Angabe Wohnflächen, Mieten pro m² WF., Lage)"]
["7.","Nachweis über Denkmalschutz"]
["8.","Prüfbare Kostenaufstellung (je Gewerk) / prüfbare Nachweise, z.B. nach DIN 276 sofern Maßnahmen im Bestand durchgeführt werden"]
["9.","Energieausweis, falls vorhanden"]
["10.","Aktuelle Angaben zum Objekt (Vordruck bitte bei uns anfordern)"]
[]
["Bei Fragen oder möglichem Abstimmungsbedarf zu den bautechnischen Unterlagen bitten wir Sie, \nsich frühzeitig unter der Telefonnummer 069 / 9132-2538 an uns zu wenden."]
[]
["Begründung zu fehlenden Unterlagen/Nachweisen:"]

{"sheet":"Tabelle1","index":11,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Bearbeitung am 19.06.2017"]
[]
[null,"Verknüpfungen ab Zeile 34 waren unvollständig, so dass  #Wert anzeigt wurde"]
[null,"Änderungn auf Seite 1 bezügl. 3.1 und 3.2 Zählen der WE"]
[]
[null,"Bearbeitung 20.06.2017"]
[]
[null,"Zuordnung der Wohnflächenergebnisse von Seite 3 auf Seite 5"]
[null,"Seite 5, Instandhaltung, Flächen auf nicht sichtbar gesetzt."]

{"sheet":"Änderungsübersicht","index":12,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Datum","Grund / Maßnahme"]
[]
["2017-10-20","Änderung der Zuweisung, Anzahl der Wohnungen von Seite 3 auf die Seite 1"]
[null,"Übertragung der Zeile Z50 auf 3.2 Seite 1, Z52 auf 3.1, Z54 auf C3.2, Z56 auf 3.1, zweite Zeile "]
[]
["2017-11-06","Einführung des Pull down Menus auf Seite 1"]
[null,"Änderung der Zuordnung Seite 1, Ziffer 3.1 und 3.2"]
[]
["2017-11-07","Änderung Seite 3 \"DIN 18040 mit R\""]
[null,"Seite 3 a eingesetzt §4 Abs 4 ……."]