{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Vorblatt_Muster 6","Planungsdaten","Kostendaten_ES","Kostendaten_2.Ebene_ES","Kostendaten_bis_3.Ebene_ES","Kostendaten_NES","Kostendaten_2.Ebene_NES","Kostendaten_bis_3.Ebene_NES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":343,"comments":8,"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":"Vorblatt_Muster 6","index":0,"n_rows":64,"n_cols":20,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,8,3,11],[4,8,4,10],[48,9,48,13],[49,9,49,13],[61,9,61,13],[52,9,52,13],[53,9,53,13],[56,9,56,13],[57,9,57,13],[60,9,60,13],[46,9,46,14],[4,13,4,17],[18,4,18,6],[6,1,6,6],[6,8,6,10],[6,11,6,16],[7,1,8,6],[7,8,7,10],[8,8,8,10],[22,4,22,6],[24,4,24,6],[28,2,28,17],[30,1,30,3],[30,15,30,17],[30,10,30,13],[62,9,62,14],[49,1,49,7],[50,9,50,14],[53,1,53,7],[54,9,54,14],[57,1,57,7],[58,9,58,14],[61,1,61,7],[50,1,50,3],[59,1,59,4],[55,1,55,4],[20,4,20,6],[46,5,46,6],[34,15,34,17],[3,13,3,16],[45,1,45,7],[14,4,14,6],[16,4,16,6],[36,15,36,17],[38,15,38,17],[12,2,12,3],[12,4,12,6],[46,15,46,17],[44,9,44,13],[45,9,45,13],[40,15,40,17],[32,15,32,17]]}
[null,"GABau Hessen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muster 6"]
[null,"KOSTENERMITTLUNG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"        der Entscheidungsunterlage-Bau (ES-Bau)",null,null,null,null,null,null,"      PPP/Koop",null,null,null,null,"Kostendaten:",null,null,null,null,null,false]
[null,"        zu dem",null,". Nachtrag der ES-Bau vom",null,null,null,null,null,null,null,null,null,"bitte auswählen",null,null,null,null,null,"bitte auswählen"]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,"Anzahl der Bauwerke",null,null,"   Art der Kostenermittlung:",null,null,null,null,null,null,null,"bitte auswählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kostenschätzung",null,null,null,null,null,null,"Kostendaten 2. Ebene"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kostenberechnung",null,null,null,null,null,null,"Kostendaten 3. Ebene"]
[]
[null,"Allgemeine Angaben:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte auswählen"]
[null,"zuständig ",null,null,"bitte auswählen",null,null,null,null,"Aufstellung Bedarfskonzept",null,null,null,null,null,null,"M/J",null,null,"LBIH NL Nord"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LBIH NL Süd"]
[null,"Bedarfsträger",null,null,null,null,null,null,null,"Aufstellung Bedarfsanmeldung",null,null,null,null,null,null,"M/J",null,null,"LBIH NL Ost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LBIH NL Mitte"]
[null,"Architekt/ Ingenieur/ FbT",null,null,null,null,null,null,null,"Zustimmung zur Bedarfsanmeldung",null,null,null,null,null,null,"M/J",null,null,"LBIH NL West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LBIH NL Rhein-Main"]
[null,"Auftragsnummer AG",null,null,null,null,null,null,null,"haushr. Anerk. der ES-Bau",null,null,null,null,{"$f":"IF($T$4=TRUE,\"geplant\",\"\")","v":""},null,"M/J",null,null,"LBIH-Zentrale"]
[]
[null,"Projekt Nr.",null,null,null,null,null,null,null,"Baubeginn",null,null,null,null,{"$f":"IF($T$4=TRUE,\"geplant\",\"\")","v":""},null,"M/J"]
[]
[null,"Wirtschaftseinheit",null,null,null,null,null,null,null,"Übergabe",null,null,null,null,"geplant",null,"M/J"]
[]
[null,"Gebäude Nr. ",null,null,null,null,null,null,null,"Bauzeit",null,null,"Monate"]
[]
[]
[]
[null,"Mittelbedarf:"," (beginnt mit der geplanten Aufnahme in den Haushalt)"]
[]
[null,null,null,null,null,null,null,null,null,null,"Jahr",null,null,null,null,"Ausgabemittel"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"  Aufnahme in HH 20",null,null,null,null,null,"EUR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"                      2. Jahr 20",null,null,null,null,null,"EUR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"                       3. Jahr 20",null,null,null,null,null,"EUR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"                       4. Jahr 20",null,null,null,null,null,"EUR"]
[]
[null,null,null,null,null,null,null,null,null,null,"5. Jahr und folgende",null,null,null,null,null,null,null,"EUR"]
[]
[]
[null,"aufgestellt:"]
[]
[null,"bitte auswählen"]
[null,"LBIH / Organisationseinheit1",null,null,null,null,null,null,null,"Datum,  \nName, Funktion  (in Druckbuchstaben)",null,null,null,null,null,"\nUnterschrift"]
[null,"baufachlich geprüft:"]
[]
[null,"bitte auswählen"]
[null,"LBIH / Organisationseinheit1",null,null,null,null,null,null,null,"Datum,  \nName, Funktion  (in Druckbuchstaben)",null,null,null,null,null,"Unterschrift"]
[null,"einverstanden:"]
[]
[]
[null,"Bedarfsträger ",null,null,null,null,null,null,null,"Datum,  \nName, Funktion  (in Druckbuchstaben) ",null,null,null,null,null,"Unterschrift"]
[null,"bitte auswählen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte auswählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fachlich genehmigt:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"geprüft und genehmigt:"]
[null,"Ressort ",null,null,null,null,null,null,null,"Datum,  \nName, Funktion  (in Druckbuchstaben)",null,null,null,null,null,"Unterschrift"]
[null,"bitte auswählen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bitte auswählen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"haushaltsrechtlich anerkannt:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zur Kenntnis genommen:"]
[null,"HMdF ",null,null,null,null,null,null,null,"Datum,  \nName, Funktion  (in Druckbuchstaben)",null,null,null,null,null,"Unterschrift"]
[null,"1 In festgelegten Sonderfällen, z.B. Baumaßnahmen in Zuständigkeit der Hochschulen"]

{"sheet":"Planungsdaten","index":1,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[32,6,32,7],[32,8,32,9],[24,15,24,16],[18,15,18,16],[19,15,19,16],[30,6,30,7],[30,8,30,9],[19,3,19,10],[21,6,21,7],[31,15,31,16],[22,15,22,16],[23,8,23,9],[23,10,23,12],[22,6,22,7],[18,11,18,13],[21,8,21,9],[30,12,30,13],[27,6,27,9],[27,10,27,13],[27,15,27,16],[28,15,29,16],[28,14,29,14],[30,10,30,11],[32,15,32,16],[45,15,45,16],[2,13,2,16],[16,15,16,16],[13,3,13,10],[15,11,15,16],[7,4,7,6],[15,3,15,10],[12,11,12,16],[13,11,13,16],[8,9,8,10],[7,9,7,10],[8,4,8,6],[5,9,5,10],[7,13,8,16],[12,1,12,10],[16,11,16,13],[14,11,14,16],[14,3,14,10],[16,1,16,3],[16,4,16,10],[3,8,3,10],[4,1,6,6],[7,12,8,12],[33,6,33,7],[33,8,33,9],[34,6,34,7],[40,6,40,7],[39,6,39,7],[39,8,39,9],[34,8,34,9],[42,4,42,6],[40,8,40,9],[36,6,36,7],[36,8,36,9],[37,6,37,7],[45,8,45,9],[45,3,45,7],[44,8,44,9],[43,3,43,7],[35,6,35,7],[35,8,35,9],[42,1,42,3],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[45,10,45,11],[44,10,44,11],[43,10,43,11],[36,10,36,11],[37,10,37,11],[39,10,39,11],[40,10,40,11],[40,15,40,16],[43,15,43,16],[42,15,42,16],[44,15,44,16],[44,3,44,7],[37,15,37,16],[39,15,39,16],[36,15,36,16],[37,8,37,9],[39,12,39,13],[40,12,40,13],[42,10,42,11],[36,12,36,13],[37,12,37,13],[34,15,34,16],[35,15,35,16],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[33,15,33,16],[31,10,31,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[4,18,4,19],[19,11,19,13],[17,15,17,16],[23,15,23,16],[21,10,21,12],[18,3,18,10],[31,6,31,7],[31,8,31,9],[23,6,23,7],[24,6,24,7],[24,8,24,9],[24,10,24,12],[22,8,22,12],[28,12,29,13],[28,10,29,11],[28,6,29,7],[28,8,29,9],[26,1,26,16],[28,1,29,5],[30,15,30,16],[17,3,17,10],[17,11,17,13],[31,12,31,13],[21,13,21,14]]}
[null,"GABau Hessen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muster 6 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zusammenstellung der Planungsdaten "]
[]
[null,"Baumaßnahme:"]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""},null,null,null,null,null,null,"Bauwerkszuordnungs-Nr.",null,null,null,"(BWZ):"]
[]
[null,null,null,null,null,null,null,null,"Projekt-Nr.: ",{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""}]
[null,"Straße + Nr.:",null,null,null,null,null,null,"Bearb.:",null,null,null,"Bauwerk:"]
[null,"PLZ + Ort:",null,null,null,null,null,null,"Datum:"]
[]
[]
[null,"Nutzung gemäß Bedarfsanmeldung (gem. Muster 13)"]
[null,"Nutzungsflächen NUF  (gem. DIN 277:2021-08)",null,null,null,null,null,null,null,null,null," Fläche \"R\" (gem. DIN 277)\nin m²"]
[null,"NUF 1-6"]
[null,"NUF 7"]
[null,"NUF",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(L14), ISNUMBER(L15)), L14+L15,\"\")","v":""}]
[null,"Nutzeinheiten",null,null,"Bezeichnung",null,null,null,null,null,null,"Anzahl",null,null,"NUF / NE\nin m² / NE"]
[null,"NE 1",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER($L$16),L18<>\"\",L18<>0),$L$16/L18,\"\")","v":""}]
[null,"NE 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER($L$16),L19<>\"\",L19<>0),$L$16/L19,\"\")","v":""}]
[null,"NE 3",null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"Baugrundstück",null,null,null,null," Fläche                in m²",null,"BAW\n(Bauart /   Bauweise)",null,null,null,null,"Geschosszahl"]
[null,"BF",null,"Bebaute Fläche",null,null,null,null,"Stellplätze",null,null,null,null,"UG"]
[null,"UF",null,"Unbebaute Fläche",null,null,{"$f":"IF(AND(G23<>\"\",G25<>\"\"),G25-G23,\"\")","v":""},null,"gefordert",null,"erfüllt",null,null,"OG"]
[null,"GF",null,"Grundstücksfläche",null,null,null,null,null,null,null,null,null,"DG"]
[]
[null," Geplante Grundflächen und Rauminhalt des Bauwerks gem. ES-Bau / NES-Bau  \n (gem. DIN 277:2021-08)"]
[null,null,null,null,null,null,{"$f":"IF('Vorblatt_Muster 6'!T4=FALSE,CONCATENATE('Vorblatt_Muster 6'!C5,\". NES-Bau\"),\"ES-Bau\")","v":". NES-Bau"},null,null,null,"bisher haushrtl. anerkannt",null,null,null,"Summe","Verhältnis"]
[null,null,null,null,null,null,"Fläche \"R\"\nm²",null,"Fläche \"S\"\nm²",null,"Fläche \"R\"\nm²",null,"Fläche \"S\"\nm²",null,"Gesamt","Fl.\"R\"/ \nNUF \"R\" %"]
[]
[null,"NUF 1-6",null,"Nutzungsfläche (1 - 6)",null,null,0,null,0,null,0,null,0,null,{"$f":"IF(AND(ISNUMBER(G31),ISNUMBER(I31),ISNUMBER(K31),ISNUMBER(M31)),G31+I31+K31+M31,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(S31),ISNUMBER($S$33),$S$33<>0),S31/$S$33*100,\"\")","v":""},null,null,{"$f":"+G31+K31","v":0}]
[null,"NUF 7",null,"sonstige Nutzungsfläche",null,null,0,null,0,null,0,null,0,null,{"$f":"IF(AND(ISNUMBER(G32),ISNUMBER(I32),ISNUMBER(K32),ISNUMBER(M32)),G32+I32+K32+M32,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(S32),ISNUMBER($S$33),$S$33<>0),S32/$S$33*100,\"\")","v":""},null,null,{"$f":"+G32+K32","v":0}]
[null,"NUF",null,"Nutzungsfläche",null,null,{"$f":"IF(ISNUMBER(G31),IF(ISNUMBER(G32),SUM(G31:G32),\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(I31),IF(ISNUMBER(I32),SUM(I31:I32),\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K31),IF(ISNUMBER(K32),SUM(K31:K32),\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(M31),IF(ISNUMBER(M32),SUM(M31:M32),\"\"),\"\")","v":0},null,0,"",null,null,0]
[null,"TF",null,"Technikfläche",null,null,0,null,0,null,0,null,0,null,0,"",null,null,0]
[null,"VF",null,"Verkehrsfläche",null,null,0,null,0,null,0,null,0,null,0,"",null,null,0]
[null,"NRF",null,"Netto - Raumfläche",null,null,{"$f":"IF(AND(ISNUMBER(G33),ISNUMBER(G34),ISNUMBER(G35)),SUM(G33:G35),\"\")","v":0},null,{"$f":"IF(AND(I33<>\"\",I34<>\"\",I35<>\"\"),SUM(I33:I35),\"\")","v":0},null,{"$f":"IF(AND(K33<>\"\",K34<>\"\",K35<>\"\"),SUM(K33:K35),\"\")","v":0},null,{"$f":"IF(AND(M33<>\"\",M34<>\"\",M35<>\"\"),SUM(M33:M35),\"\")","v":0},null,0,"",null,null,0]
[null,"KGF",null,"Konstruktions-Grundfläche",null,null,{"$f":"IF(ISNUMBER(G38),IF(ISNUMBER(G36),G38-G36,\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(I38),IF(ISNUMBER(I36),I38-I36,\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(K38),IF(ISNUMBER(K36),K38-K36,\"\"),\"\")","v":0},null,{"$f":"IF(ISNUMBER(M38),IF(ISNUMBER(M36),M38-M36,\"\"),\"\")","v":0},null,0,"",null,null,0]
[null,"BGF",null,"Brutto-Grundfläche",null,null,0,null,0,null,0,null,0,null,0,"",null,null,0]
[]
[null,"BRI",null,"Brutto-Rauminhalt",null,null,"BRI \"R\"\nm³",null," BRI \"S\"\nm³",null,"BRI \"R\"\nm³",null," BRI \"S\"\nm³",null,"Gesamt","BRI / BGF in m"]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF(AND(ISNUMBER(G41),ISNUMBER(I41),ISNUMBER(K41),ISNUMBER(M41)),G41+I41+K41+M41,\"\")","v":0},{"$f":"IF(AND(ISNUMBER(S41),ISNUMBER(S38),S38<>0),S41/S38,\"\")","v":""},null,null,0]
[]
[null,"Nutzeinheiten",null,null,"Bezeichnung",null,null,null,null,null,"Anzahl",null,"NUF / NE\nm² / NE",null,"NRF / NE\nm² / NE","BGF/ NE\nm² / NE"]
[null,"NE 1",null,{"$f":"IF(_NE1<>\"\", _NE1, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NEZahl1<>\"\", NEZahl1, \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$33),ISNUMBER(K44),K44<>0),$G$33/K44,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$36),ISNUMBER(K44),K44<>0),$G$36/K44,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($G$38),ISNUMBER(K44),K44<>0),$G$38/K44,\"\")","v":""}]
[null,"NE 2",null,{"$f":"IF(_NE2<>\"\", _NE2, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NEZahl2<>\"\", NEZahl2, \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$33),ISNUMBER(K45),K45<>0),$G$33/K45,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$36),ISNUMBER(K45),K45<>0),$G$36/K45,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($G$38),ISNUMBER(K45),K45<>0),$G$38/K45,\"\")","v":""}]
[null,"NE 3",null,{"$f":"IF(_NE3<>\"\", _NE3, \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(NEZahl3<>\"\", NEZahl3, \"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$33),ISNUMBER(K46),K46<>0),$G$33/K46,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($G$36),ISNUMBER(K46),K46<>0),$G$36/K46,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($G$38),ISNUMBER(K46),K46<>0),$G$38/K46,\"\")","v":""}]

{"sheet":"Kostendaten_ES","index":2,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[23,12,23,15],[37,11,38,12],[37,13,38,15],[24,3,24,4],[37,8,37,9],[38,8,38,9],[36,8,36,9],[24,12,24,15],[25,12,25,15],[26,12,26,15],[27,12,27,15],[28,12,28,15],[35,11,36,12],[35,13,36,15],[39,3,39,7],[39,8,39,9],[36,3,36,7],[35,8,35,9],[38,3,38,7],[37,3,37,7],[35,3,35,7],[8,4,8,6],[8,9,8,10],[7,4,7,6],[3,11,4,11],[22,3,22,4],[20,3,20,4],[2,13,2,15],[4,1,6,7],[21,3,21,4],[12,3,12,4],[15,3,15,4],[13,3,13,4],[14,3,14,4],[11,12,11,15],[11,1,11,4],[16,3,16,4],[17,3,17,4],[21,12,21,13],[6,9,6,10],[7,9,7,10],[3,12,4,13],[6,12,7,15],[41,1,46,15],[30,1,32,11],[12,12,19,15],[18,3,18,4],[29,3,29,4],[27,3,27,4],[28,3,28,4],[26,3,26,4],[25,3,25,4],[33,1,33,4],[19,3,19,4],[33,11,33,15],[29,12,29,15],[22,12,22,15],[21,14,21,15],[40,1,40,3]]}
["GABau Hessen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muster 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zusammenstellung der Kostendaten"]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,null,null,null,"BWZ:",{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"Projekt-Nr.: ",{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,"Bauwerk:",{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.:",null,null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},null,null,null,"Bearb.:",{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort:",null,null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},null,null,null,"Datum:",{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""}]
[]
[]
[null,"Kostenübersicht\n(nach DIN 276:2018-12)",null,null,null,"€\n( Euro )",null,"Kosten / \nNUF\n€ / m²","Kosten / \nNRF\n€ / m² ","Kosten / \nBGF\n€ / m² ","Kosten / \nBRI\n€ / m³ ","Kosten / \nBWK\nin %"]
[null,200,null,"Vorbereitende Maßnahmen",null,{"$f":"IF(_KG200_2=0,_KG200,IF(_KG200=0,_KG200_2,\"Mehrfacheingabe\"))","v":0},null,{"$f":"IF(AND(ISNUMBER($F13),ISNUMBER(nNFa),nNFa<>0),$F13/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F13),ISNUMBER(nNRFa),nNRFa<>0),$F13/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F13),ISNUMBER(nBGFa),nBGFa<>0),$F13/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F13),ISNUMBER(nBRIa),nBRIa<>0),$F13/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F13),ISNUMBER($F$16),$F$16<>0),F13/$F$16*100,\"\")","v":""}]
[null,300,null,"Bauwerk - Baukonstruktionen",null,{"$f":"IF(_KG300_2=0,_KG300,IF(_KG300=0,_KG300_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",""]
[null,"400 ",null,"Bauwerk - Technische Anlagen",null,{"$f":"IF(_KG400_2=0,_KG400,IF(_KG400=0,_KG400_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",""]
[null,"BWK ",null,"Bauwerk (300 + 400) Zwischensumme",null,{"$f":"IF(AND(ISNUMBER(F14),ISNUMBER(F15)),SUM(F14:F15),\"\")","v":0},null,"","","","",""]
[null,500,null,"Außenanlagen und Freiflächen",null,{"$f":"IF(_KG500_2=0,_KG500,IF(_KG500=0,_KG500_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",""]
[null,"640",null,"Künstlerische Ausstattung",null,{"$f":"IF(_KG640_2=0,_KG640,IF(_KG640=0,_KG640_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",""]
[null,"690",null,"Sonstige Ausstattung",null,{"$f":"IF(_KG690_2=0,_KG690,IF(_KG690=0,_KG690_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",{"$f":"IF(AND(ISNUMBER(F19),ISNUMBER($F$16),$F$16<>0),F19/$F$16*100,\"\")","v":""}]
[null,"700 *",null,"Baunebenkosten",null,{"$f":"IF(_KG700_2=0,_KG700,IF(_KG700=0,_KG700_2,\"Mehrfacheingabe\"))","v":0},null,"","","","",""]
[null,"800"," ","Finanzierung",null,{"$f":"IF(_KG800_2=0,_KG800,IF(_KG800=0,_KG800_2,\"Mehrfacheingabe\"))","v":0},null,{"$f":"IF(AND(ISNUMBER($F21),ISNUMBER(nNFa),nNFa<>0),$F21/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F21),ISNUMBER(nNRFa),nNRFa<>0),$F21/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F21),ISNUMBER(nBGFa),nBGFa<>0),$F21/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F21),ISNUMBER(nBRIa),nBRIa<>0),$F21/nBRIa,\"\")","v":""},""]
[null,null,null,"zur Aufrundung",null,{"$f":"IF(S22=\"\",\"\",S22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(F13,F14,F15,F17,F18,F19,F20,F21), -3)","v":0},{"$f":"SUM(F13,F14,F15,F17,F18,F19,F20,F21)","v":0},{"$f":"Q22-R22","v":0}]
[null,"GBK",null,"Gesamtbaukosten\n(200-500,640,690,700*,800)",null,{"$f":"IF(AND(ISNUMBER(F13),ISNUMBER(F16),ISNUMBER(F17),ISNUMBER(F18),ISNUMBER(F19),ISNUMBER(F20),ISNUMBER(F21),ISNUMBER(F22)),(F13+F16+F17+F18+F19+F20+F21+F22),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER($F23),ISNUMBER(nNFa),nNFa<>0),$F23/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F23),ISNUMBER(nNRFa),nNRFa<>0),$F23/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F23),ISNUMBER(nBGFa),nBGFa<>0),$F23/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F23),ISNUMBER(nBRIa),nBRIa<>0),$F23/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F23),ISNUMBER($F$16),$F$16<>0),F23/$F$16*100,\"\")","v":""}]
[null,"Nachrichtlich:",null,null,null,null,null,null,null,null,null,null,"Anmerkung:"]
[null,100,null,"Grundstück",null,{"$f":"IF(_KG100_2=0,_KG100,IF(_KG100=0,_KG100_2,\"Mehrfacheingabe\"))","v":0},null,{"$f":"IF(AND(ISNUMBER($F25),ISNUMBER(nNFa),nNFa<>0),$F25/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F25),ISNUMBER(nNRFa),nNRFa<>0),$F25/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F25),ISNUMBER(nBGFa),nBGFa<>0),$F25/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F25),ISNUMBER(nBRIa),nBRIa<>0),$F25/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F25),ISNUMBER($F$16),$F$16<>0),F25/$F$16*100,\"\")","v":""}]
[null,"610",null,"Allgemeine Ausstattung",null,{"$f":"IF(_KG610_2=0,_KG610,IF(_KG610=0,_KG610_2,\"Mehrfacheingabe\"))","v":0},null,{"$f":"IF(AND(ISNUMBER($F26),ISNUMBER(nNFa),nNFa<>0),$F26/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F26),ISNUMBER(nNRFa),nNRFa<>0),$F26/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F26),ISNUMBER(nBGFa),nBGFa<>0),$F26/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F26),ISNUMBER(nBRIa),nBRIa<>0),$F26/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F26),ISNUMBER($F$16),$F$16<>0),F26/$F$16*100,\"\")","v":""},"Kostenschätzung",null,null,null,"bitte auswählen"]
[null,620,null,"Besondere Ausstattung",null,{"$f":"IF(_KG620_2=0,_KG620,IF(_KG620=0,_KG620_2,\"Mehrfacheingabe\"))","v":0},null,"","","","","","bitte auswählen"]
[null,630,null,"Informationstechnische Ausstattung",null,{"$f":"IF(_KG630_2=0,_KG630,IF(_KG630=0,_KG630_2,\"Mehrfacheingabe\"))","v":0},null,"","","","","","bitte auswählen",null,null,null,"Kostenschätzung"]
[null,711,null,"Projektleitung \nEP 18 ab 01.01.2020",null,{"$f":"IF(_KG711_EP18_2=0,_KG711_EP18,IF(_KG711_EP18=0,_KG711_EP18_2,\"Mehrfacheingabe\"))","v":0},null,"","","","","",null,null,null,null,"Kostenrahmen"]
[null,"GK",null,"Gesamtkosten\n(100-800)",null,{"$f":"IF(AND(ISNUMBER(F13),ISNUMBER(F16),ISNUMBER(F17),ISNUMBER(F18),ISNUMBER(F19),ISNUMBER(F20),ISNUMBER(F22),ISNUMBER(F25),ISNUMBER(F26),ISNUMBER(F27),ISNUMBER(F28),ISNUMBER(F29)),SUM(F13,F16:F22,SUM(F25:F29)),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER($F30),ISNUMBER(nNFa),nNFa<>0),$F30/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F30),ISNUMBER(nNRFa),nNRFa<>0),$F30/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F30),ISNUMBER(nBGFa),nBGFa<>0),$F30/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($F30),ISNUMBER(nBRIa),nBRIa<>0),$F30/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(F30),ISNUMBER($F$16),$F$16<>0),F30/$F$16*100,\"\")","v":""},null,null,null,null,"noch nicht bekannt"]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]
[]
[]
[null,"Besondere Kosteneinflüsse:",null,null,null,null,null,null,null,null,null,"nachrichtlich:\n(Gesamt neu)"]
[null,"KG"]
[null,null,null,null,null,null,null,null,null,null,null,"aktivierungs-pflichtig (in €)",null,"Aufwand \n(in €)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Kontrollsumme:",{"$f":"IF(F23=SUM(L38:P39),\"Summe entspricht PK\",\"PK nicht vollständig aufgeteilt\")","v":"Summe entspricht PK"}]
[null,"Erläuterungsfeld"]

{"sheet":"Kostendaten_2.Ebene_ES","index":3,"n_rows":79,"n_cols":12,"rows_kept":79,"cut":false,"hidden":true,"merged":[[5,1,7,3],[6,6,6,8],[7,6,7,8],[9,6,9,8],[12,9,12,10],[14,5,14,7],[15,5,15,7],[15,9,15,10],[16,9,16,10],[12,5,12,7],[12,1,12,3],[77,11,77,13],[66,11,66,13],[67,11,67,13],[74,11,74,13],[75,11,75,13],[63,11,63,13],[64,11,64,13],[43,11,43,13],[54,11,54,13],[48,11,48,13],[49,11,49,13],[51,11,51,13],[44,11,44,13],[72,11,72,13],[68,11,68,13],[65,11,65,13],[46,11,46,13],[47,11,47,13],[70,11,70,13],[45,11,45,13],[50,11,50,13],[71,11,71,13],[58,11,58,13],[59,11,59,13],[73,11,73,13],[69,11,69,13],[53,11,53,13],[76,9,76,10],[76,11,76,13],[52,9,52,10],[49,9,49,10],[51,9,51,10],[50,9,50,10],[62,9,62,10],[72,9,72,10],[54,9,54,10],[52,11,52,13],[70,9,70,10],[71,9,71,10],[53,9,53,10],[58,9,58,10],[61,11,61,13],[62,11,62,13],[55,11,55,13],[56,11,56,13],[60,11,60,13],[75,9,75,10],[57,11,57,13],[33,11,33,13],[31,11,31,13],[28,11,28,13],[32,11,32,13],[35,11,35,13],[36,11,36,13],[29,11,29,13],[30,11,30,13],[34,11,34,13],[12,11,12,13],[13,11,13,13],[14,11,14,13],[15,11,15,13],[16,11,16,13],[17,11,17,13],[14,9,14,10],[17,5,17,7],[16,5,16,7],[23,11,23,13],[24,5,24,7],[17,9,17,10],[77,9,77,10],[66,9,66,10],[67,9,67,10],[72,5,72,7],[46,5,46,7],[0,4,0,13],[1,4,1,13],[2,10,2,13],[13,5,13,7],[13,9,13,10],[20,11,20,13],[21,11,21,13],[22,11,22,13],[18,11,18,13],[19,11,19,13],[4,11,4,12],[7,11,8,13],[37,11,37,13],[38,11,38,13],[24,11,24,13],[25,11,25,13],[36,9,36,10],[39,9,39,10],[41,11,41,13],[42,11,42,13],[41,9,41,10],[42,9,42,10],[40,9,40,10],[39,11,39,13],[48,9,48,10],[44,9,44,10],[45,9,45,10],[46,9,46,10],[47,9,47,10],[77,5,77,7],[75,5,75,7],[58,5,58,7],[63,5,63,7],[64,5,64,7],[76,5,76,7],[65,5,65,7],[74,5,74,7],[40,5,40,7],[41,5,41,7],[42,5,42,7],[43,5,43,7],[71,5,71,7],[70,5,70,7],[44,5,44,7],[45,5,45,7],[55,5,55,7],[56,5,56,7],[57,5,57,7],[60,5,60,7],[68,5,68,7],[47,5,47,7],[61,5,61,7],[62,5,62,7],[39,5,39,7],[37,9,37,10],[38,9,38,10],[26,11,26,13],[27,11,27,13],[17,2,17,3],[18,9,18,10],[19,9,19,10],[20,9,20,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[18,5,18,7],[19,5,19,7],[20,5,20,7],[24,2,24,3],[25,2,25,3],[25,5,25,7],[22,5,22,7],[23,2,23,3],[21,5,21,7],[21,9,21,10],[23,5,23,7],[74,9,74,10],[60,2,60,3],[51,2,51,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[40,11,40,13],[26,2,26,3],[27,2,27,3],[26,9,26,10],[27,5,27,7],[38,2,38,3],[34,9,34,10],[31,2,31,3],[28,2,28,3],[28,9,28,10],[31,9,31,10],[28,5,28,7],[34,5,34,7],[35,5,35,7],[36,5,36,7],[37,5,37,7],[35,9,35,10],[59,5,59,7],[48,2,48,3],[52,2,52,3],[49,5,49,7],[65,9,65,10],[63,9,63,10],[69,5,69,7],[69,9,69,10],[73,5,73,7],[73,9,73,10],[48,5,48,7],[52,5,52,7],[53,5,53,7],[54,5,54,7],[68,9,68,10],[59,9,59,10],[61,9,61,10],[51,5,51,7],[50,5,50,7],[64,9,64,10],[55,9,55,10],[56,9,56,10],[57,9,57,10],[78,1,79,13],[60,9,60,10],[37,2,37,3],[30,2,30,3],[32,2,32,3],[26,5,26,7],[31,5,31,7],[43,9,43,10],[42,2,42,3],[43,2,43,3],[33,9,33,10],[38,5,38,7],[32,9,32,10],[27,9,27,10],[33,5,33,7],[29,5,29,7],[30,5,30,7],[29,9,29,10],[30,9,30,10],[39,2,39,3],[32,5,32,7],[75,2,75,3],[66,5,66,7],[67,5,67,7]]}
["GABau Hessen",null,null,null,"Muster 6"]
[null,null,null,null,"Kosten nach DIN 276,  2. Ebene"]
[]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,null,null,"BWZ",{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,"Projekt-Nr.: ",null,{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,null,null,"Bauwerk:",{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.:",null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},"Bearb.:",null,{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort:",null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},"Datum:",null,{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""}]
[]
[]
[null,"Kostengruppen \n(nach DIN 276:2018-12)",null,null,"€","€ / m² NUF",null,null,"€ / m² BGF","€ / m³ BRI",null,"Kosten / BWK  in %"]
[null,110,"Grundstückswert (nachrichtlich)",null,0,{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(nNFa),nNFa<>0), $E14/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(nBGFa),nBGFa<>0),$E14/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(nBRIa),nBRIa<>0),$E14/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(BWK),BWK<>0),($E14/BWK*100),\"\")","v":""}]
[null,120,"Grundstücksnebenkosten (nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,130,"Rechte Dritter (nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,100,"Grundstück (nachrichtlich)",null,{"$f":"IF(COUNTA(E14:E16)=3,SUM(E14:E16),\"\")","v":0},"",null,null,"","",null,""]
[null,210,"Herrichten",null,0,"",null,null,"","",null,""]
[null,"220         Öffentliche Erschließung","Öffentliche Erschließung",null,0,"",null,null,"","",null,""]
[null,230,"Nichtöffentliche Erschließung",null,0,"",null,null,"","",null,""]
[null,240,"Ausgleichsmaßnahmen und -abgaben",null,0,"",null,null,"","",null,""]
[null,250,"Übergangsmaßnahmen",null,0,"",null,null,"","",null,""]
[null,200,"Vorbereitende Maßnahmen",null,{"$f":"IF(COUNTA(E18:E22)=5,SUM(E18:E22),\"\")","v":0},"",null,null,"","",null,""]
[null,310,"Baugrube / Erdbau",null,0,"",null,null,"","",null,""]
[null,320,"Gründung, Unterbau",null,0,"",null,null,"","",null,""]
[null,330,"Außenwände / Vertikale\nBaukonstruktionen, außen",null,0,"",null,null,"","",null,""]
[null,340,"Innenwände / Vertikale\nBaukonstruktionen, innen",null,0,"",null,null,"","",null,""]
[null,350,"Decken / Horizontale\nBaukonstruktionen",null,0,"",null,null,"","",null,""]
[null,360,"Dächer",null,0,"",null,null,"","",null,""]
[null,370,"Infrastrukturanlagen",null,0,"",null,null,"","",null,""]
[null,380,"Baukonstruktive Einbauten\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektr. Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,0,"",null,null,"","",null,""]
[null,390,"Sonstige Maßnahmen für Baukonstruktionen",null,0,"",null,null,"","",null,""]
[null,300,"Bauwerk - Baukonstruktionen\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektronische Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(COUNTA(E24:E32)=9,SUM(E24:E32),\"\")","v":0},"",null,null,"","",null,""]
[null,410,"Abwasser-, Wasser-, Gasanlagen",null,0,"",null,null,"","",null,""]
[null,420,"Wärmeversorgungsanlagen",null,0,"",null,null,"","",null,""]
[null,430,"Lufttechnische Anlagen",null,0,"",null,null,"","",null,""]
[null,440,"Elektrische Anlagen",null,0,"",null,null,"","",null,""]
[null,450,"Kommunikations-, sicherheits- u. informationstechnische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,0,"",null,null,"","",null,""]
[null,460,"Förderanlagen",null,0,"",null,null,{"$f":"IF(AND(ISNUMBER($E39),ISNUMBER(nBGFa),nBGFa<>0),$E39/nBGFa,\"\")","v":""},"",null,""]
[null,470,"Nutzungsspezifische und\nverfahrenstechniche Anlagen",null,0,"",null,null,"","",null,""]
[null,480,"Gebäudeautomation",null,0,"",null,null,"","",null,""]
[null,490,"Sonst. Maßnahmen für Technische Anl.",null,0,"",null,null,"","",null,""]
[null,400,"Bauwerk Technische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(COUNTA(E34:E42)=9,SUM(E34:E42),\"\")","v":0},"",null,null,"","",null,""]
[null,510,"Erdbau",null,0,"",null,null,"","",null,""]
[null,520,"Gründung Unterbau",null,0,"",null,null,"","",null,""]
[null,530,"Oberbau, Deckschichten",null,0,"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER($E46),ISNUMBER(BWK),BWK<>0),($E46/BWK*100),\"\")","v":""}]
[null,540,"Baukonstruktionen",null,0,{"$f":"IF(AND(ISNUMBER($E47),ISNUMBER(nNFa),nNFa<>0), $E47/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E47),ISNUMBER(nBGFa),nBGFa<>0),$E47/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E47),ISNUMBER(nBRIa),nBRIa<>0),$E47/nBRIa,\"\")","v":""},null,""]
[null,550,"Technische Anlagen",null,0,"",null,null,"","",null,""]
[null,560,"Einbauten in Außenanlagen\nund Freiflächen",null,0,"",null,null,"","",null,""]
[null,570,"Vegetationsflächen",null,0,"",null,null,"","",null,""]
[null,580,"Wasserflächen",null,0,"",null,null,"","",null,""]
[null,590,"Sonst.  Maßnahmen für Außenanl. u. Freiflächen",null,0,"",null,null,"","",null,""]
[null,500,"Außenanlagen und Freiflächen",null,{"$f":"IF(COUNTA(E44:E52)=9,SUM(E44:E52),\"\")","v":0},"",null,null,"","",null,""]
[null,610,"Allgemeine Ausstattung (nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,620,"Besondere Ausstattung (nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,630,"Informationstechnische\nAusstattung (nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,640,"Künstlerische Ausstattung",null,0,"",null,null,"","",null,""]
[null,690,"Sonstige Ausstattung \n(Zuordnung Schilder, Wegweiser, Informations- u. Werbetafeln,\nzu KG 386 u. KG 451)",null,0,"",null,null,"","",null,""]
[null,600,"Ausstattung und Kunstwerke\n(ohne KG 610, 620, 630)",null,{"$f":"IF(COUNTA(E57:E58)=2,SUM(E57:E58),\"\")","v":0},"",null,null,"","",null,""]
[null,710,"Bauherrenaufgaben",null,0,"",null,null,"","",null,""]
[null,711,"Projektleitung (bei EP 18 ab 2020, nachrichtlich)",null,0,"",null,null,"","",null,""]
[null,720,"Vorbereitung der Objektplanung",null,0,"",null,null,"","",null,""]
[null,730,"Objektplanung",null,0,"",null,null,"","",null,""]
[null,740,"Fachplanung",null,0,"",null,null,"","",null,""]
[null,750,"Künstlerische Leistungen",null,0,"",null,null,"","",null,""]
[null,760,"Allgemeine Baunebenkosten",null,0,"",null,null,"","",null,""]
[null,790,"Sonstige Baunebenkosten",null,0,"",null,null,"","",null,""]
[null,700,"Baunebenkosten",null,{"$f":"IF(COUNTA(E60,E62:E67)=7,E60+SUM(E62:E67),\"\")","v":0},"",null,null,"","",null,""]
[null,810,"Finanzierungsnebenkosten",null,0,"",null,null,"","",null,""]
[null,820,"Fremdkapitalzinsen",null,0,"",null,null,"","",null,""]
[null,830,"Eigenkapitalzinsen",null,0,"",null,null,"","",null,""]
[null,840,"Bürgschaften",null,0,"",null,null,"","",null,""]
[null,890,"Sonstige Finanzierungskosten",null,0,"",null,null,"","",null,""]
[null,800,"Finanzierung",null,{"$f":"IF(COUNTA(E69:E73)=5,SUM(E69:E73),\"\")","v":0},"",null,null,"","",null,""]
[]
[null,"GBK","Gesamtbaukosten \n(200-500, 640, 690, 700*,800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E23),ISNUMBER(E33),ISNUMBER(E43),ISNUMBER(E53),ISNUMBER(E59),ISNUMBER(E68),ISNUMBER(_KG800_2)),(E23+E33+E43+E53+E59+E68+_KG800_2),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($E76),ISNUMBER(nNFa),nNFa<>0), $E76/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E76),ISNUMBER(nBGFa),nBGFa<>0),$E76/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E76),ISNUMBER(nBRIa),nBRIa<>0),$E76/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($E76),ISNUMBER(BWK),BWK<>0),($E76/BWK*100),\"\")","v":""}]
[]
[null,"GK","Gesamtkosten (100-800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E17),ISNUMBER(E23),ISNUMBER(E33),ISNUMBER(E43),ISNUMBER(E53),ISNUMBER(E54),ISNUMBER(E55),ISNUMBER(E56),ISNUMBER(E59),ISNUMBER(E61),ISNUMBER(E68),ISNUMBER(E74)),(E17+E23+E33+E43+E53+E54+E55+E56+E59+E61+E68+E74),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($E78),ISNUMBER(nNFa),nNFa<>0), $E78/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E78),ISNUMBER(nBGFa),nBGFa<>0),$E78/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E78),ISNUMBER(nBRIa),nBRIa<>0),$E78/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER($E78),ISNUMBER(BWK),BWK<>0),($E78/BWK*100),\"\")","v":""}]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]

{"sheet":"Kostendaten_bis_3.Ebene_ES","index":4,"n_rows":345,"n_cols":15,"rows_kept":345,"cut":false,"hidden":true,"merged":[[293,5,293,7],[298,2,298,3],[299,2,299,3],[300,2,300,3],[331,11,331,13],[320,11,320,13],[322,11,322,13],[323,11,323,13],[324,11,324,13],[325,11,325,13],[326,11,326,13],[327,11,327,13],[328,11,328,13],[330,11,330,13],[310,11,310,13],[311,11,311,13],[312,11,312,13],[313,11,313,13],[314,11,314,13],[315,11,315,13],[316,11,316,13],[318,11,318,13],[319,11,319,13],[302,2,302,3],[303,2,303,3],[304,2,304,3],[305,2,305,3],[306,2,306,3],[248,11,248,13],[250,11,250,13],[293,11,293,13],[295,11,295,13],[296,11,296,13],[297,11,297,13],[298,11,298,13],[274,11,274,13],[279,11,279,13],[280,11,280,13],[281,11,281,13],[282,11,282,13],[283,11,283,13],[284,11,284,13],[287,11,287,13],[288,11,288,13],[264,11,264,13],[266,11,266,13],[267,11,267,13],[268,11,268,13],[269,11,269,13],[290,11,290,13],[270,11,270,13],[291,11,291,13],[272,11,272,13],[273,11,273,13],[271,11,271,13],[289,11,289,13],[292,11,292,13],[232,11,232,13],[233,11,233,13],[234,11,234,13],[235,11,235,13],[236,11,236,13],[218,11,218,13],[220,11,220,13],[221,11,221,13],[222,11,222,13],[223,11,223,13],[224,11,224,13],[225,11,225,13],[226,11,226,13],[227,11,227,13],[245,11,245,13],[246,11,246,13],[247,11,247,13],[240,11,240,13],[241,11,241,13],[242,11,242,13],[243,11,243,13],[244,11,244,13],[198,11,198,13],[199,11,199,13],[200,11,200,13],[201,11,201,13],[202,11,202,13],[203,11,203,13],[204,11,204,13],[207,11,207,13],[166,11,166,13],[167,11,167,13],[168,11,168,13],[169,11,169,13],[171,11,171,13],[172,11,172,13],[173,11,173,13],[174,11,174,13],[175,11,175,13],[186,11,186,13],[187,11,187,13],[189,11,189,13],[190,11,190,13],[191,11,191,13],[192,11,192,13],[193,11,193,13],[194,11,194,13],[196,11,196,13],[176,11,176,13],[177,11,177,13],[179,11,179,13],[180,11,180,13],[181,11,181,13],[182,11,182,13],[158,11,158,13],[159,11,159,13],[161,11,161,13],[162,11,162,13],[163,11,163,13],[164,11,164,13],[165,11,165,13],[146,11,146,13],[147,11,147,13],[148,11,148,13],[149,11,149,13],[150,11,150,13],[152,11,152,13],[153,11,153,13],[154,11,154,13],[155,11,155,13],[197,11,197,13],[183,11,183,13],[184,11,184,13],[185,11,185,13],[140,11,140,13],[141,11,141,13],[142,11,142,13],[143,11,143,13],[144,11,144,13],[139,11,139,13],[124,11,124,13],[125,11,125,13],[126,11,126,13],[127,11,127,13],[128,11,128,13],[129,11,129,13],[130,11,130,13],[131,11,131,13],[132,11,132,13],[156,11,156,13],[157,11,157,13],[119,11,119,13],[120,11,120,13],[121,11,121,13],[122,11,122,13],[123,11,123,13],[107,11,107,13],[108,11,108,13],[109,11,109,13],[110,11,110,13],[111,11,111,13],[112,11,112,13],[113,11,113,13],[114,11,114,13],[135,11,135,13],[136,11,136,13],[137,11,137,13],[138,11,138,13],[91,11,91,13],[92,11,92,13],[93,11,93,13],[94,11,94,13],[75,11,75,13],[76,11,76,13],[77,11,77,13],[78,11,78,13],[79,11,79,13],[81,11,81,13],[82,11,82,13],[83,11,83,13],[84,11,84,13],[115,11,115,13],[116,11,116,13],[117,11,117,13],[118,11,118,13],[106,11,106,13],[89,11,89,13],[96,11,96,13],[95,11,95,13],[97,11,97,13],[98,11,98,13],[99,11,99,13],[100,11,100,13],[101,11,101,13],[102,11,102,13],[103,11,103,13],[105,11,105,13],[87,11,87,13],[88,11,88,13],[90,11,90,13],[68,11,68,13],[69,11,69,13],[71,11,71,13],[72,11,72,13],[73,11,73,13],[74,11,74,13],[53,11,53,13],[54,11,54,13],[57,11,57,13],[58,11,58,13],[59,11,59,13],[60,11,60,13],[61,11,61,13],[63,11,63,13],[64,11,64,13],[85,11,85,13],[86,11,86,13],[45,11,45,13],[48,11,48,13],[49,11,49,13],[50,11,50,13],[52,11,52,13],[31,11,31,13],[32,11,32,13],[33,11,33,13],[34,11,34,13],[35,11,35,13],[37,11,37,13],[38,11,38,13],[39,11,39,13],[40,11,40,13],[65,11,65,13],[66,11,66,13],[67,11,67,13],[24,11,24,13],[25,11,25,13],[26,11,26,13],[29,11,29,13],[30,11,30,13],[330,5,330,7],[331,5,331,7],[304,5,304,7],[305,5,305,7],[306,5,306,7],[308,5,308,7],[309,5,309,7],[310,5,310,7],[311,5,311,7],[312,5,312,7],[313,5,313,7],[321,5,321,7],[295,5,295,7],[296,5,296,7],[297,5,297,7],[298,5,298,7],[299,5,299,7],[300,5,300,7],[302,5,302,7],[303,5,303,7],[294,5,294,7],[266,5,266,7],[267,5,267,7],[41,11,41,13],[42,11,42,13],[43,11,43,13],[44,11,44,13],[269,5,269,7],[270,5,270,7],[271,5,271,7],[272,5,272,7],[273,5,273,7],[274,5,274,7],[245,5,245,7],[246,5,246,7],[247,5,247,7],[248,5,248,7],[250,5,250,7],[251,5,251,7],[252,5,252,7],[253,5,253,7],[255,5,255,7],[236,5,236,7],[237,5,237,7],[238,5,238,7],[240,5,240,7],[241,5,241,7],[242,5,242,7],[243,5,243,7],[244,5,244,7],[239,5,239,7],[260,5,260,7],[268,5,268,7],[199,5,199,7],[180,5,180,7],[181,5,181,7],[182,5,182,7],[183,5,183,7],[184,5,184,7],[185,5,185,7],[186,5,186,7],[187,5,187,7],[189,5,189,7],[226,5,226,7],[227,5,227,7],[228,5,228,7],[230,5,230,7],[231,5,231,7],[232,5,232,7],[233,5,233,7],[200,5,200,7],[201,5,201,7],[202,5,202,7],[203,5,203,7],[204,5,204,7],[207,5,207,7],[208,5,208,7],[209,5,209,7],[206,5,206,7],[197,5,197,7],[198,5,198,7],[142,5,142,7],[143,5,143,7],[144,5,144,7],[146,5,146,7],[147,5,147,7],[148,5,148,7],[145,5,145,7],[169,5,169,7],[171,5,171,7],[172,5,172,7],[173,5,173,7],[174,5,174,7],[175,5,175,7],[176,5,176,7],[177,5,177,7],[179,5,179,7],[159,5,159,7],[161,5,161,7],[162,5,162,7],[163,5,163,7],[164,5,164,7],[165,5,165,7],[166,5,166,7],[167,5,167,7],[168,5,168,7],[170,5,170,7],[102,5,102,7],[103,5,103,7],[105,5,105,7],[106,5,106,7],[107,5,107,7],[108,5,108,7],[127,5,127,7],[128,5,128,7],[129,5,129,7],[130,5,130,7],[131,5,131,7],[132,5,132,7],[135,5,135,7],[136,5,136,7],[137,5,137,7],[118,5,118,7],[119,5,119,7],[120,5,120,7],[121,5,121,7],[122,5,122,7],[123,5,123,7],[124,5,124,7],[125,5,125,7],[126,5,126,7],[111,5,111,7],[112,5,112,7],[113,5,113,7],[114,5,114,7],[115,5,115,7],[116,5,116,7],[117,5,117,7],[79,5,79,7],[81,5,81,7],[82,5,82,7],[98,5,98,7],[45,5,45,7],[48,5,48,7],[49,5,49,7],[50,5,50,7],[52,5,52,7],[53,5,53,7],[54,5,54,7],[57,5,57,7],[58,5,58,7],[47,5,47,7],[83,5,83,7],[84,5,84,7],[85,5,85,7],[86,5,86,7],[87,5,87,7],[88,5,88,7],[90,5,90,7],[91,5,91,7],[92,5,92,7],[93,5,93,7],[94,5,94,7],[95,5,95,7],[97,5,97,7],[37,5,37,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[41,5,41,7],[42,5,42,7],[43,5,43,7],[44,5,44,7],[24,5,24,7],[25,5,25,7],[26,5,26,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[5,1,7,3],[6,6,6,8],[7,6,7,8],[9,6,9,8],[154,2,154,3],[164,2,164,3],[166,2,166,3],[147,2,147,3],[148,2,148,3],[149,2,149,3],[150,2,150,3],[151,2,151,3],[152,2,152,3],[153,2,153,3],[93,2,93,3],[94,2,94,3],[117,2,117,3],[118,2,118,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[124,2,124,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[119,2,119,3],[35,5,35,7],[79,2,79,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[90,2,90,3],[91,2,91,3],[178,2,178,3],[155,2,155,3],[156,2,156,3],[157,2,157,3],[158,2,158,3],[159,2,159,3],[160,2,160,3],[161,2,161,3],[162,2,162,3],[163,2,163,3],[167,2,167,3],[168,2,168,3],[169,2,169,3],[170,2,170,3],[171,2,171,3],[172,2,172,3],[173,2,173,3],[81,2,81,3],[82,2,82,3],[99,2,99,3],[92,2,92,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[63,2,63,3],[64,2,64,3],[120,2,120,3],[111,2,111,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[100,2,100,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[104,2,104,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[47,2,47,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[37,2,37,3],[38,2,38,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[26,2,26,3],[327,2,327,3],[328,2,328,3],[330,2,330,3],[331,2,331,3],[316,2,316,3],[317,2,317,3],[318,2,318,3],[319,2,319,3],[320,2,320,3],[322,2,322,3],[323,2,323,3],[324,2,324,3],[325,2,325,3],[308,2,308,3],[309,2,309,3],[310,2,310,3],[311,2,311,3],[312,2,312,3],[313,2,313,3],[314,2,314,3],[315,2,315,3],[326,2,326,3],[297,2,297,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[287,2,287,3],[288,2,288,3],[289,2,289,3],[290,2,290,3],[291,2,291,3],[292,2,292,3],[293,2,293,3],[295,2,295,3],[296,2,296,3],[269,2,269,3],[270,2,270,3],[271,2,271,3],[272,2,272,3],[273,2,273,3],[274,2,274,3],[279,2,279,3],[284,2,284,3],[280,2,280,3],[281,2,281,3],[282,2,282,3],[283,2,283,3],[275,2,275,3],[276,2,276,3],[286,2,286,3],[258,2,258,3],[254,2,254,3],[259,2,259,3],[261,2,261,3],[262,2,262,3],[263,2,263,3],[264,2,264,3],[266,2,266,3],[267,2,267,3],[268,2,268,3],[104,9,104,10],[104,11,104,13],[247,2,247,3],[248,2,248,3],[250,2,250,3],[251,2,251,3],[252,2,252,3],[253,2,253,3],[255,2,255,3],[256,2,256,3],[257,2,257,3],[240,2,240,3],[241,2,241,3],[242,2,242,3],[243,2,243,3],[244,2,244,3],[245,2,245,3],[204,2,204,3],[203,2,203,3],[246,2,246,3],[109,5,109,7],[110,5,110,7],[170,9,170,10],[170,11,170,13],[178,5,178,7],[99,5,99,7],[89,2,89,3],[227,2,227,3],[228,2,228,3],[176,2,176,3],[177,2,177,3],[180,2,180,3],[181,2,181,3],[183,2,183,3],[182,2,182,3],[184,2,184,3],[185,2,185,3],[187,2,187,3],[186,2,186,3],[179,2,179,3],[210,2,210,3],[211,2,211,3],[213,2,213,3],[214,2,214,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[145,2,145,3],[146,2,146,3],[96,2,96,3],[95,2,95,3],[97,2,97,3],[98,2,98,3],[341,2,341,3],[55,5,55,7],[55,9,55,10],[56,5,56,7],[56,9,56,10],[62,2,62,3],[70,2,70,3],[80,2,80,3],[62,5,62,7],[62,9,62,10],[139,5,139,7],[139,9,139,10],[233,2,233,3],[234,2,234,3],[215,2,215,3],[216,2,216,3],[205,2,205,3],[206,2,206,3],[132,2,132,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[133,2,133,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[140,2,140,3],[89,5,89,7],[89,9,89,10],[96,5,96,7],[96,9,96,10],[104,5,104,7],[0,4,0,13],[1,4,1,13],[2,10,2,13],[23,5,23,7],[23,9,23,10],[23,11,23,13],[13,5,13,7],[13,9,13,10],[13,11,13,13],[4,11,4,12],[14,5,14,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[14,11,14,13],[15,11,15,13],[16,11,16,13],[17,11,17,13],[18,11,18,13],[19,11,19,13],[20,11,20,13],[21,11,21,13],[22,11,22,13],[8,6,8,8],[7,11,9,12],[12,1,12,3],[12,5,12,7],[12,9,12,10],[12,11,12,13],[13,2,13,3],[14,2,14,3],[15,2,15,3],[46,5,46,7],[46,9,46,10],[46,11,46,13],[27,5,27,7],[27,9,27,10],[27,11,27,13],[28,5,28,7],[28,9,28,10],[28,11,28,13],[36,2,36,3],[36,5,36,7],[36,9,36,10],[36,11,36,13],[34,2,34,3],[35,2,35,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],[47,9,47,10],[70,9,70,10],[70,11,70,13],[80,5,80,7],[47,11,47,13],[51,5,51,7],[51,9,51,10],[51,11,51,13],[55,11,55,13],[56,11,56,13],[62,11,62,13],[59,5,59,7],[60,5,60,7],[61,5,61,7],[63,5,63,7],[64,5,64,7],[65,5,65,7],[66,5,66,7],[67,5,67,7],[68,5,68,7],[69,5,69,7],[71,5,71,7],[72,5,72,7],[73,5,73,7],[80,9,80,10],[80,11,80,13],[70,5,70,7],[74,5,74,7],[75,5,75,7],[76,5,76,7],[77,5,77,7],[78,5,78,7],[178,9,178,10],[178,11,178,13],[151,11,151,13],[160,5,160,7],[160,9,160,10],[160,11,160,13],[151,5,151,7],[151,9,151,10],[174,2,174,3],[175,2,175,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[145,9,145,10],[145,11,145,13],[165,2,165,3],[149,5,149,7],[150,5,150,7],[152,5,152,7],[153,5,153,7],[154,5,154,7],[155,5,155,7],[156,5,156,7],[157,5,157,7],[158,5,158,7],[138,5,138,7],[140,5,140,7],[141,5,141,7],[100,5,100,7],[101,5,101,7],[196,2,196,3],[197,2,197,3],[205,5,205,7],[205,9,205,10],[188,11,188,13],[195,5,195,7],[195,9,195,10],[195,11,195,13],[188,5,188,7],[188,9,188,10],[200,2,200,3],[188,2,188,3],[189,2,189,3],[190,2,190,3],[191,2,191,3],[192,2,192,3],[193,2,193,3],[194,2,194,3],[195,2,195,3],[205,11,205,13],[198,2,198,3],[199,2,199,3],[201,2,201,3],[202,2,202,3],[190,5,190,7],[191,5,191,7],[192,5,192,7],[193,5,193,7],[194,5,194,7],[196,5,196,7],[206,9,206,10],[206,11,206,13],[207,2,207,3],[208,2,208,3],[209,2,209,3],[229,5,229,7],[229,9,229,10],[229,11,229,13],[217,2,217,3],[219,2,219,3],[210,5,210,7],[211,5,211,7],[213,5,213,7],[214,5,214,7],[215,5,215,7],[216,5,216,7],[217,5,217,7],[218,5,218,7],[220,5,220,7],[221,5,221,7],[222,5,222,7],[223,5,223,7],[224,5,224,7],[225,5,225,7],[208,11,208,13],[209,11,209,13],[210,11,210,13],[211,11,211,13],[213,11,213,13],[214,11,214,13],[215,11,215,13],[216,11,216,13],[239,9,239,10],[239,11,239,13],[212,2,212,3],[212,5,212,7],[212,9,212,10],[212,11,212,13],[219,5,219,7],[219,9,219,10],[219,11,219,13],[218,2,218,3],[220,2,220,3],[221,2,221,3],[222,2,222,3],[223,2,223,3],[224,2,224,3],[225,2,225,3],[226,2,226,3],[235,2,235,3],[236,2,236,3],[237,2,237,3],[230,2,230,3],[231,2,231,3],[232,2,232,3],[238,2,238,3],[234,5,234,7],[235,5,235,7],[217,11,217,13],[237,11,237,13],[238,11,238,13],[228,11,228,13],[230,11,230,13],[231,11,231,13],[260,9,260,10],[260,11,260,13],[265,5,265,7],[265,9,265,10],[265,11,265,13],[249,5,249,7],[249,9,249,10],[249,11,249,13],[254,5,254,7],[254,9,254,10],[254,11,254,13],[256,5,256,7],[257,5,257,7],[258,5,258,7],[259,5,259,7],[261,5,261,7],[262,5,262,7],[263,5,263,7],[264,5,264,7],[259,11,259,13],[261,11,261,13],[262,11,262,13],[263,11,263,13],[251,11,251,13],[252,11,252,13],[253,11,253,13],[255,11,255,13],[256,11,256,13],[257,11,257,13],[258,11,258,13],[277,5,277,7],[277,9,277,10],[277,11,277,13],[275,5,275,7],[275,9,275,10],[275,11,275,13],[276,5,276,7],[276,9,276,10],[276,11,276,13],[294,9,294,10],[294,11,294,13],[301,5,301,7],[301,9,301,10],[301,11,301,13],[278,5,278,7],[278,9,278,10],[278,11,278,13],[286,5,286,7],[286,9,286,10],[286,11,286,13],[279,5,279,7],[280,5,280,7],[281,5,281,7],[282,5,282,7],[283,5,283,7],[284,5,284,7],[287,5,287,7],[288,5,288,7],[289,5,289,7],[290,5,290,7],[291,5,291,7],[292,5,292,7],[338,5,338,7],[338,9,338,10],[338,11,338,13],[335,5,335,7],[335,9,335,10],[335,11,335,13],[336,5,336,7],[336,9,336,10],[336,11,336,13],[321,9,321,10],[321,11,321,13],[329,5,329,7],[329,9,329,10],[329,11,329,13],[307,5,307,7],[307,9,307,10],[307,11,307,13],[317,5,317,7],[317,9,317,10],[317,11,317,13],[314,5,314,7],[315,5,315,7],[316,5,316,7],[318,5,318,7],[319,5,319,7],[320,5,320,7],[322,5,322,7],[323,5,323,7],[324,5,324,7],[325,5,325,7],[326,5,326,7],[327,5,327,7],[337,9,337,10],[299,11,299,13],[300,11,300,13]],"merged_total":1050,"flags":["merged_cut"]}
[null,"GABau Hessen",null,null,"Muster 6"]
[null,null,null,null,{"$f":"IF(O5=TRUE,\"Kosten nach DIN 276,  3. Ebene\",\"Kosten nach DIN 276,  2. Ebene\")","v":"Kosten nach DIN 276,  3. Ebene"}]
[]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,null,null,"BWZ:",{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""},null,null,{"$f":"sichtbar(B15)","v":true}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,"Projekt-Nr.: ",null,{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,null,null,"Bauwerk:",{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.:",null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},"Bearb.:",null,{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort:",null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},"Datum:",null,{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""}]
[]
[]
[null,"Kostengruppen \n(nach DIN 276:2018-12)",null,null,"€","€ / m² NUF",null,null,"€ / m² BGF","€ / m³ BRI",null,"Kosten / BWK  in %"]
[null,110,"Grundstückswert",null,0,{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(nNFa),nNFa<>0),E14/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(nBGFa),nBGFa<>0),$E14/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E14),ISNUMBER(nBRIa),nBRIa<>0),$E14/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(BWK),BWK<>0),(E14/BWK*100),\"\")","v":""}]
[null,121,"Vermessungsgebühren",null,0]
[null,122,"Gerichtsgebühren",null,0]
[null,123,"Notariatsgebühren",null,0]
[null,124,"Grunderwerbssteuer",null,0]
[null,125,"Untersuchungen",null,0]
[null,126,"Wertermittlungen",null,0]
[null,127,"Genehmigungsgebühren",null,0]
[null,128,"Bodenordnung",null,0]
[null,129,"Sonstiges zur KG 120",null,0]
[null,120,"Grundstücksnebenkosten",null,{"$f":"IF(COUNTIF(E15:E23,\"*\")=9,\"*\",IF(COUNTA(E15:E23)=9,SUM(E15:E23),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E24),ISNUMBER(nNFa),nNFa<>0),E24/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E24),ISNUMBER(nBGFa),nBGFa<>0),$E24/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E24),ISNUMBER(nBRIa),nBRIa<>0),$E24/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(E24),ISNUMBER(BWK),BWK<>0),(E24/BWK*100),\"\")","v":""}]
[null,131,"Abfindungen",null,0]
[null,132,"Ablösen dinglicher Rechte",null,0]
[null,139,"Sonstiges zur KG 130",null,0]
[null,130,"Rechte Dritter",null,{"$f":"IF(COUNTIF(E25:E27,\"*\")=3,\"*\",IF(COUNTA(E25:E27)=3,SUM(E25:E27),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E28),ISNUMBER(BWK),BWK<>0),(E28/BWK*100),\"\")","v":""}]
[null,100,"Grundstück",null,{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(E24),ISNUMBER(E28)),(E14+E24+E28),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E29),ISNUMBER(BWK),BWK<>0),(E29/BWK*100),\"\")","v":""}]
[null,211,"Sicherungsmaßnahmen",null,0]
[null,212,"Abbruchmaßnahmen",null,0]
[null,213,"Altlastenbeseitigung",null,0]
[null,214,"Herrichten der Geländepberfläche",null,0]
[null,215,"Kampfmittelräumung",null,0]
[null,216,"Kulturhistorische Funde",null,0]
[null,219,"Sonstiges zur KG 210",null,0]
[null,210,"Herrichten",null,{"$f":"IF(COUNTIF(E30:E36,\"*\")=7,\"*\",IF(COUNTA(E30:E36)=7,SUM(E30:E36),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E37),ISNUMBER(BWK),BWK<>0),(E37/BWK*100),\"\")","v":""}]
[null,221,"Abwasserentsorgung",null,0]
[null,222,"Wasserversorgung",null,0]
[null,223,"Gasversorgung",null,0]
[null,224,"Fernwärmeversorgung",null,0]
[null,225,"Stromversorgung",null,0]
[null,226,"Telekommunikation",null,0]
[null,227,"Verkehrserschließung",null,0]
[null,228,"Abfallentsorgung",null,0]
[null,229,"Sonstiges zur KG 220",null,0]
[null,"220         Öffentliche Erschließung","Öffentliche Erschließung",null,{"$f":"IF(COUNTIF(E38:E46,\"*\")=9,\"*\",IF(COUNTA(E38:E46)=9,SUM(E38:E46),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E47),ISNUMBER(BWK),BWK<>0),(E47/BWK*100),\"\")","v":""}]
[null,230,"Nichtöffentliche Erschließung",null,0,"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E48),ISNUMBER(BWK),BWK<>0),(E48/BWK*100),\"\")","v":""}]
[null,241,"Ausgleichsmaßnahmen",null,0]
[null,242,"Ausgleichsabgaben",null,0]
[null,249,"Sonstiges zur KG 240",null,0]
[null,240,"Ausgleichsmaßnahmen und -abgaben",null,{"$f":"IF(COUNTIF(E49:E51,\"*\")=3,\"*\",IF(COUNTA(E49:E51)=3,SUM(E49:E51),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E52),ISNUMBER(BWK),BWK<>0),(E52/BWK*100),\"\")","v":""}]
[null,251,"Bauliche Maßnahmen",null,0]
[null,252,"Organisatorische Maßnahmen",null,0]
[null,259,"Sonstiges zur KG 250",null,0]
[null,250,"Übergangsmaßnahmen",null,{"$f":"IF(COUNTIF(E53:E55,\"*\")=3,\"*\",IF(COUNTA(E53:E55)=3,SUM(E53:E55),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E56),ISNUMBER(BWK),BWK<>0),(E56/BWK*100),\"\")","v":""}]
[null,200,"Vorbereitende Maßnahmen",null,{"$f":"IF(AND(ISNUMBER(E37),ISNUMBER(E47),ISNUMBER(E48),ISNUMBER(E52),ISNUMBER(E56)),(E37+E47+E48+E52+E56),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E57),ISNUMBER(BWK),BWK<>0),(E57/BWK*100),\"\")","v":""}]
[null,311,"Herstellung",null,0]
[null,312,"Umschließung",null,0]
[null,313,"Wasserhaltung",null,0]
[null,314,"Vortrieb",null,0]
[null,319,"Sonstiges zur KG 310",null,0]
[null,310,"Baugrube / Erdbau",null,{"$f":"IF(COUNTIF(E58:E62,\"*\")=5,\"*\",IF(COUNTA(E58:E62)=5,SUM(E58:E62),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E63),ISNUMBER(BWK),BWK<>0),(E63/BWK*100),\"\")","v":""}]
[null,321,"Baugrundverbesserung",null,0]
[null,322,"Flachgründungen und Bodenplatten",null,0]
[null,323,"Tiefgründungen",null,0]
[null,324,"Gründungsbeläge",null,0]
[null,325,"Abdichtungen und Bekleidunge",null,0]
[null,326,"Dränagen",null,0]
[null,329,"Sonstiges zur KG 320",null,0]
[null,320,"Gründung, Unterbau",null,{"$f":"IF(COUNTIF(E64:E70,\"*\")=7,\"*\",IF(COUNTA(E64:E70)=7,SUM(E64:E70),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E71),ISNUMBER(BWK),BWK<>0),(E71/BWK*100),\"\")","v":""}]
[null,331,"Tragende Außenwände",null,0]
[null,332,"Nichttragende Außenwände",null,0]
[null,333,"Außenstützen",null,0]
[null,334,"Außenwandöffnungen",null,0]
[null,335,"Außenwandbekleidungen, außen",null,0]
[null,336,"Außenwandbekleidungen, innen",null,0]
[null,337,"Elementierte Außenwandkonstruktionen",null,0]
[null,338,"Lichtschutz zur KG 330",null,0]
[null,339,"Sonstiges zur KG 330",null,0]
[null,330,"Außenwände / Vertikale\nBaukonstruktionen, außen",null,{"$f":"IF(COUNTIF(E72:E80,\"*\")=9,\"*\",IF(COUNTA(E72:E80)=9,SUM(E72:E80),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E81),ISNUMBER(nNFa),nNFa<>0),E81/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E81),ISNUMBER(BWK),BWK<>0),(E81/BWK*100),\"\")","v":""}]
[null,341,"Tragende Innenwände",null,0]
[null,342,"Nichttragende Innenwände",null,0]
[null,343,"Innenstützen",null,0]
[null,344,"Innenwandöffnungen",null,0]
[null,345,"Innenwandbekleidunge",null,0]
[null,346,"Elementierte Innenwandkonstruktionen",null,0]
[null,347,"Lichtschutz zur KG 340",null,0]
[null,349,"Sonstiges zur KG 340",null,0]
[null,340,"Innenwände / Vertikale\nBaukonstruktionen, innen",null,{"$f":"IF(COUNTIF(E82:E89,\"*\")=9,\"*\",IF(COUNTA(E82:E89)=8,SUM(E82:E89),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E90),ISNUMBER(BWK),BWK<>0),(E90/BWK*100),\"\")","v":""}]
[null,351,"Deckenkonstruktionen",null,0]
[null,352,"Deckenöffnungen",null,0]
[null,353,"Deckenbeläge",null,0]
[null,354,"Deckenbekleidungen",null,0]
[null,355,"Elementierte Deckenkonstruktionen",null,0]
[null,359,"Sonstiges zur KG 350",null,0]
[null,350,"Decken / Horizontale\nBaukonstruktionen",null,{"$f":"IF(COUNTIF(E91:E96,\"*\")=6,\"*\",IF(COUNTA(E91:E96)=6,SUM(E91:E96),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E97),ISNUMBER(BWK),BWK<>0),(E97/BWK*100),\"\")","v":""}]
[null,361,"Dachkonstruktionen",null,0]
[null,362,"Dachöffnungen",null,0]
[null,363,"Dachbeläge",null,0]
[null,364,"Dachbekleidungen",null,0]
[null,365,"Elementierte Dachkonstruktionen",null,0]
[null,366,"Lichtschutz zu KG 360",null,0]
[null,369,"Sonstiges zur KG 360",null,0]
[null,360,"Dächer",null,{"$f":"IF(COUNTIF(E98:E104,\"*\")=7,\"*\",IF(COUNTA(E98:E104)=7,SUM(E98:E104),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E105),ISNUMBER(BWK),BWK<>0),(E105/BWK*100),\"\")","v":""}]
[null,371,"Anlagen für den Straßenverkehr",null,0]
[null,372,"Anlagen für den Schienenverkehr",null,0]
[null,373,"Anlagen für den Flugverkehr",null,0]
[null,374,"Anlagen des Wasserbaus",null,0]
[null,375,"Anlagen der Abwasserentsorgung",null,0]
[null,376,"Anlagen der Wasserversorgung",null,0]
[null,377,"Anl. der Energie- u.\nInformationsversorgung",null,0]
[null,378,"Anlagen der Abfallentsorgung",null,0]
[null,379,"Sonstiges zur KG 370",null,0]
[null,370,"Infrastrukturanlagen",null,{"$f":"IF(COUNTIF(E106:E114,\"*\")=9,\"*\",IF(COUNTA(E106:E114)=9,SUM(E106:E114),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E115),ISNUMBER(nNFa),nNFa<>0),E115/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E115),ISNUMBER(BWK),BWK<>0),(E115/BWK*100),\"\")","v":""}]
[null,381,"Allgemeine Einbauten",null,0]
[null,382,"Besondere Einbauten",null,0]
[null,383,"Landschaftsgestalterische Einbauten",null,0]
[null,384,"Mechanische Einbauten",null,0]
[null,385,"Einbauten in Konstruktionen des Ingenieurbaus",null,0]
[null,386,"Orientierungs- und Informationssysteme \n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektr. Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,0]
[null,387,"Schutzeinbauten",null,0]
[null,389,"Sonstiges zur KG 380",null,0]
[null,380,"Baukonstruktive Einbauten\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektronische Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(COUNTIF(E116:E123,\"*\")=8,\"*\",IF(COUNTA(E116:E123)=8,SUM(E116:E123),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E124),ISNUMBER(nNFa),nNFa<>0),E124/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E124),ISNUMBER(BWK),BWK<>0),(E124/BWK*100),\"\")","v":""}]
[null,391,"Baustelleneinrichtung",null,0]
[null,392,"Gerüste",null,0]
[null,393,"Sicherungsmaßnahmen",null,0]
[null,394,"Abbruchmaßnahmen",null,0]
[null,395,"Instandsetzungen",null,0]
[null,396,"Materialentsorgung",null,0]
[null,397,"Zusätzliche Maßnahmen",null,0]
[null,398,"Provisorische Baukonstruktionen",null,0]
[null,399,"Sonstiges zur KG 390",null,0]
[null,390,"Sonstige Maßnahmen für Baukonstruktionen",null,{"$f":"IF(COUNTIF(E125:E133,\"*\")=9,\"*\",IF(COUNTA(E125:E133)=9,SUM(E125:E133),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E134),ISNUMBER(BWK),BWK<>0),(E134/BWK*100),\"\")","v":""}]
[null,300,"Bauwerk - Baukonstruktionen\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektronische Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(AND(ISNUMBER(E63),ISNUMBER(E71),ISNUMBER(E81),ISNUMBER(E90),ISNUMBER(E97),ISNUMBER(E105),ISNUMBER(E115),ISNUMBER(E124),ISNUMBER(E134)),(E63+E71+E81+E90+E97+E105+E115+E124+E134),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E135),ISNUMBER(BWK),BWK<>0),(E135/BWK*100),\"\")","v":""}]
[null,411,"Abwasseranlagen",null,0]
[null,412,"Wasseranlagen",null,0]
[null,413,"Gasanlagen",null,0]
[null,419,"Sonstiges zur KG 410",null,0]
[null,410,"Abwasser-, Wasser-, Gasanlagen",null,{"$f":"IF(COUNTIF(E136:E139,\"*\")=4,\"*\",IF(COUNTA(E136:E139)=4,SUM(E136:E139),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E140),ISNUMBER(BWK),BWK<>0),(E140/BWK*100),\"\")","v":""}]
[null,421,"Wärmeerzeugungsanlagen",null,0]
[null,422,"Wärmeverteilnetze",null,0]
[null,423,"Raumheizflächen",null,0]
[null,424,"Verkehrsheizflächen",null,0]
[null,429,"Sonstiges zur KG 420",null,0]
[null,420,"Wärmeversorgungsanlagen",null,{"$f":"IF(COUNTIF(E141:E145,\"*\")=5,\"*\",IF(COUNTA(E141:E145)=5,SUM(E141:E145),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E146),ISNUMBER(nNFa),nNFa<>0),E146/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E146),ISNUMBER(BWK),BWK<>0),(E146/BWK*100),\"\")","v":""}]
[null,431,"Lüftungsanlagen",null,0]
[null,432,"Teilklimaanlagen",null,0]
[null,433,"Klimaanlagen   ",null,0]
[null,434,"Kälteanlagen   ",null,0]
[null,439,"Sonstiges zur KG 430",null,0]
[null,430,"Lufttechnische Anlagen",null,{"$f":"IF(COUNTIF(E147:E151,\"*\")=5,\"*\",IF(COUNTA(E147:E151)=5,SUM(E147:E151),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E152),ISNUMBER(BWK),BWK<>0),(E152/BWK*100),\"\")","v":""}]
[null,441,"Hoch- und Mittelspannungsanlagen",null,0]
[null,442,"Eigenstromversorgungsanlagen",null,0]
[null,443,"Niederspannungsschaltanlagen",null,0]
[null,444,"Niederspannungsinstallationsanlage",null,0]
[null,445,"Beleuchtungsanlagen",null,0]
[null,446,"Blitzschutz- und Erdungsanlagen",null,0]
[null,447,"Fahrleitungssysteme",null,0]
[null,449,"Sonstiges zur KG 440",null,0]
[null,440,"Elektrische Anlagen",null,{"$f":"IF(COUNTIF(E153:E160,\"*\")=8,\"*\",IF(COUNTA(E153:E160)=8,SUM(E153:E160),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E161),ISNUMBER(BWK),BWK<>0),(E161/BWK*100),\"\")","v":""}]
[null,451,"Telekommunikationsanlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,0]
[null,452,"Such- und Signalanlagen",null,0]
[null,453,"Zeitdienstanlagen",null,0]
[null,454,"Elektroakustische Anlagen",null,0]
[null,455,"Audiovisuelle Medien- und Antennenanlagen",null,0]
[null,456,"Antennenanlagen",null,0]
[null,457,"Datenübertragungsnetze",null,0]
[null,458,"Verkehrsbeeinflussungsanlagen",null,0]
[null,459,"Sonstiges zur KG 450",null,0]
[null,450,"Kommunikations-, sicherheits- u. informationstechnische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(COUNTIF(E162:E170,\"*\")=9,\"*\",IF(COUNTA(E162:E170)=9,SUM(E162:E170),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E171),ISNUMBER(BWK),BWK<>0),(E171/BWK*100),\"\")","v":""}]
[null,461,"Aufzugsanlagen",null,0]
[null,462,"Fahrtreppen, Fahrsteige",null,0]
[null,463,"Befahranlagen",null,0]
[null,464,"Transportanlagen",null,0]
[null,465,"Krananlagen",null,0]
[null,466,"Hydraulikanlagen",null,0]
[null,469,"Sonstiges zur KG 460",null,0]
[null,460,"Förderanlagen",null,{"$f":"IF(COUNTIF(E172:E178,\"*\")=7,\"*\",IF(COUNTA(E172:E178)=7,SUM(E172:E178),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E179),ISNUMBER(BWK),BWK<>0),(E179/BWK*100),\"\")","v":""}]
[null,471,"Küchentechnische Anlagen",null,0]
[null,472,"Wäscherei-, Reinigungs- und badetechnische Anlagen",null,0]
[null,473,"Medienversorgungsanlagen, Medizin- und labortechnische Anlagen",null,0]
[null,474,"Feuerlöschanlagen",null,0]
[null,475,"Prozesswärme-, kälte- und -luftanlagen",null,0]
[null,476,"Weitere nutzungsspezifische Anlagen",null,0]
[null,477,"Verfahrenstechnische Anlagen,\nWasser, Abwasser und Gase",null,0]
[null,478,"Verfahrenstechnische Anlagen, Feststoffe, Wertstoffe und Abfälle",null,0]
[null,479,"Sonstiges zur KG 470",null,0]
[null,470,"Nutzungsspezifische und\nverfahrenstechniche Anlagen",null,{"$f":"IF(COUNTIF(E180:E188,\"*\")=9,\"*\",IF(COUNTA(E180:E188)=9,SUM(E180:E188),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E189),ISNUMBER(BWK),BWK<>0),(E189/BWK*100),\"\")","v":""}]
[null,481,"Automationseinrichtungen",null,0]
[null,482,"Schaltschränke, Automationsschwerpunkte",null,0]
[null,483,"Automationsmanagement",null,0]
[null,484,"Kabel, Leitungen und\nVerlegesysteme",null,0]
[null,485,"Datenübertragungsnetze",null,0]
[null,489,"Sonstiges zur KG 480",null,0]
[null,480,"Gebäudeautomation",null,{"$f":"IF(COUNTIF(E190:E195,\"*\")=6,\"*\",IF(COUNTA(E190:E195)=6,SUM(E190:E195),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E196),ISNUMBER(BWK),BWK<>0),(E196/BWK*100),\"\")","v":""}]
[null,491,"Baustelleneinrichtung",null,0]
[null,492,"Gerüste",null,0]
[null,493,"Sicherungsmaßnahmen",null,0]
[null,494,"Abbruchmaßnahmen",null,0]
[null,495,"Instandsetzungen",null,0]
[null,496,"Materialentsorgung",null,0]
[null,497,"Zusätzliche Maßnahmen",null,0]
[null,498,"Provisorische technische\nAnlagen",null,0]
[null,499,"Sonstiges zur KG 490",null,0]
[null,490,"Sonst. Maßnahmen für Technische Anl.",null,{"$f":"IF(COUNTIF(E197:E205,\"*\")=9,\"*\",IF(COUNTA(E197:E205)=9,SUM(E197:E205),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E206),ISNUMBER(nNFa),nNFa<>0),E206/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E206),ISNUMBER(BWK),BWK<>0),(E206/BWK*100),\"\")","v":""}]
[null,400,"Bauwerk Technische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(AND(ISNUMBER(E140),ISNUMBER(E146),ISNUMBER(E152),ISNUMBER(E161),ISNUMBER(E171),ISNUMBER(E179),ISNUMBER(E189),ISNUMBER(E196),ISNUMBER(E206)),(E140+E146+E152+E161+E171+E179+E189+E196+E206),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E207),ISNUMBER(BWK),BWK<>0),(E207/BWK*100),\"\")","v":""}]
[null,511,"Herstellung",null,0]
[null,512,"Umschließung",null,0]
[null,513,"Wasserhaltung",null,0]
[null,514,"Vortrieb",null,0]
[null,515,"Sonstiges zur KG 510",null,0]
[null,510,"Erdbau",null,{"$f":"IF(COUNTIF(E208:E212,\"*\")=5,\"*\",IF(COUNTA(E208:E212)=5,SUM(E208:E212),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E213),ISNUMBER(BWK),BWK<>0),(E213/BWK*100),\"\")","v":""}]
[null,521,"Baugrundverbesserung",null,0]
[null,522,"Gründungen und Bodenplatten",null,0]
[null,523,"Gründungsbeläge",null,0]
[null,524,"Abdichtungen und Bekleidungen",null,0]
[null,525,"Dränagen",null,0]
[null,529,"Sonstiges zur KG 520",null,0]
[null,520,"Gründung Unterbau",null,{"$f":"IF(COUNTIF(E214:E219,\"*\")=6,\"*\",IF(COUNTA(E214:E219)=6,SUM(E214:E219),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E220),ISNUMBER(BWK),BWK<>0),(E220/BWK*100),\"\")","v":""}]
[null,531,"Wege",null,0]
[null,532,"Straßen",null,0]
[null,533,"Plätze, Höfe, Terrassen",null,0]
[null,534,"Stellplätze",null,0]
[null,535,"Sportplatzflächen",null,0]
[null,536,"Spielplatzflächen",null,0]
[null,537,"Gleisanlagen",null,0]
[null,538,"Flugplatzflächen",null,0]
[null,539,"Sonstiges zur KG 530",null,0]
[null,530,"Oberbau, Deckschichten",null,{"$f":"IF(COUNTIF(E221:E229,\"*\")=9,\"*\",IF(COUNTA(E221:E229)=9,SUM(E221:E229),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E230),ISNUMBER(BWK),BWK<>0),(E230/BWK*100),\"\")","v":""}]
[null,541,"Einfriedungen",null,0]
[null,542,"Schutzkonstruktionen",null,0]
[null,543,"Wandkonstruktionen",null,0]
[null,544,"Rampen, Treppen, Tribünen",null,0]
[null,545,"Überdachungen",null,0]
[null,546,"Stege",null,0]
[null,547,"Kanal- und\nSchachtkonstruktionen",null,0]
[null,548,"Wasserbecken",null,0]
[null,549,"Sonstiges zur KG 540",null,0]
[null,540,"Baukonstruktionen",null,{"$f":"IF(COUNTIF(E231:E239,\"*\")=9,\"*\",IF(COUNTA(E231:E239)=9,SUM(E231:E239),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E240),ISNUMBER(BWK),BWK<>0),(E240/BWK*100),\"\")","v":""}]
[null,551,"Abwasseranlagen",null,0]
[null,552,"Wasseranlagen",null,0]
[null,553,"Anlagen für Gase und\nFlüssigkeiten",null,0]
[null,554,"Wärmeversorgungsanlagen",null,0]
[null,555,"Raumlufttechnische Anlagen",null,0]
[null,556,"Elektrische Anlagen",null,0]
[null,557,"Kommunikations-, sicherheits und\ninformationstechnische Anlagen,  Automation",null,0]
[null,558,"Nutzungsspezifische Anlagen",null,0]
[null,559,"Sonstiges zur KG 550",null,0]
[null,550,"Technische Anlagen",null,{"$f":"IF(COUNTIF(E241:E249,\"*\")=9,\"*\",IF(COUNTA(E241:E249)=9,SUM(E241:E249),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E250),ISNUMBER(BWK),BWK<>0),(E250/BWK*100),\"\")","v":""}]
[null,561,"Allgemeine Einbauten",null,0]
[null,562,"Besondere Einbauten",null,0]
[null,563,"Orientierungs- und\nInformationssysteme",null,0]
[null,569,"Sonstiges zur KG 560",null,0]
[null,560,"Einbauten in Außenanlagen\nund Freiflächen",null,{"$f":"IF(COUNTIF(E251:E254,\"*\")=4,\"*\",IF(COUNTA(E251:E254)=4,SUM(E251:E254),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E255),ISNUMBER(BWK),BWK<>0),(E255/BWK*100),\"\")","v":""}]
[null,571,"Vegetationstechnische\nBodenbearbeitung",null,0]
[null,572,"Sicherungsbauweisen",null,0]
[null,573,"Pflanzflächen",null,0]
[null,574,"Rasen- und Saatflächen",null,0]
[null,579,"Sonstiges zur KG 570",null,0]
[null,570,"Vegetationsflächen",null,{"$f":"IF(COUNTIF(E256:E260,\"*\")=5,\"*\",IF(COUNTA(E256:E260)=5,SUM(E256:E260),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E261),ISNUMBER(BWK),BWK<>0),(E261/BWK*100),\"\")","v":""}]
[null,581,"Befestigungen",null,0]
[null,582,"Abdichtungen",null,0]
[null,583,"Bepflanzungen",null,0]
[null,589,"Sonstiges zur KG 580",null,0]
[null,580,"Wasserflächen",null,{"$f":"IF(COUNTIF(E262:E265,\"*\")=4,\"*\",IF(COUNTA(E262:E265)=4,SUM(E262:E265),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E266),ISNUMBER(BWK),BWK<>0),(E266/BWK*100),\"\")","v":""}]
[null,591,"Baustelleneinrichtung",null,0]
[null,592,"Gerüste",null,0]
[null,593,"Sicherungsmaßnahmen",null,0]
[null,594,"Abbruchmaßnahmen",null,0]
[null,595,"Instandsetzungen",null,0]
[null,596,"Materialentsorgung",null,0]
[null,597,"Zusätzliche Maßnahmen",null,0]
[null,598,"Provisorische Außenanlagen und\nFreiflächen",null,0]
[null,599,"Sonstiges zur KG 590",null,0]
[null,590,"Sonst.  Maßnahmen für Außenanl. u. Freiflächen",null,{"$f":"IF(COUNTIF(E267:E275,\"*\")=9,\"*\",IF(COUNTA(E267:E275)=9,SUM(E267:E275),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E276),ISNUMBER(nNFa),nNFa<>0),E276/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E276),ISNUMBER(BWK),BWK<>0),(E276/BWK*100),\"\")","v":""}]
[null,500,"Außenanlagen und Freiflächen",null,{"$f":"IF(AND(ISNUMBER(E213),ISNUMBER(E220),ISNUMBER(E230),ISNUMBER(E240),ISNUMBER(E250),ISNUMBER(E255),ISNUMBER(E261),ISNUMBER(E266),ISNUMBER(E276)),(E213+E220+E230+E240+E250+E255+E261+E266+E276),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E277),ISNUMBER(BWK),BWK<>0),(E277/BWK*100),\"\")","v":""}]
[null,610,"Allgemeine Ausstattung (nachrichtlich)",null,0,"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E278),ISNUMBER(BWK),BWK<>0),(E278/BWK*100),\"\")","v":""}]
[null,620,"Besondere Ausstattung (nachrichtlich)",null,0,"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E279),ISNUMBER(BWK),BWK<>0),(E279/BWK*100),\"\")","v":""}]
[null,630,"Informationstechnische\nAusstattung (nachrichtlich)",null,0,"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E280),ISNUMBER(BWK),BWK<>0),(E280/BWK*100),\"\")","v":""}]
[null,641,"Kunstobjekte",null,0]
[null,642,"Künstlerische Gestaltung des\nBauwerks",null,0]
[null,643,"Künstlerische Gestaltung der\nAußenanlagen und Freiflächen",null,0]
[null,649,"Sonstiges zur KG 640",null,0]
[null,640,"Künstlerische Ausstattung",null,{"$f":"IF(COUNTIF(E281:E284,\"*\")=4,\"*\",IF(COUNTA(E281:E284)=4,SUM(E281:E284),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER(E285),ISNUMBER(nNFa),nNFa<>0),E285/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E285),ISNUMBER(BWK),BWK<>0),(E285/BWK*100),\"\")","v":""}]
[null,690,"Sonstige Ausstattung \n(Zuordnung Schilder, Wegweiser, Informations- u. Werbetafeln,\nzu KG 386 u. KG 451)",null,0,{"$f":"IF(AND(ISNUMBER(E286),ISNUMBER(nNFa),nNFa<>0),E286/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E286),ISNUMBER(BWK),BWK<>0),(E286/BWK*100),\"\")","v":""}]
[null,600,"Ausstattung und Kunstwerke\n(ohne KG 610, 620, 630)",null,{"$f":"IF(AND(ISNUMBER(E285),ISNUMBER(E286)),(E285+E286),\"\")","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E287),ISNUMBER(BWK),BWK<>0),(E287/BWK*100),\"\")","v":""}]
[null,711,"Projektleitung (bei EP 18 ab 2020, nachrichtlich)",null,0,{"$f":"IF(AND(ISNUMBER(E288),ISNUMBER(nNFa),nNFa<>0),E288/nNFa,\"\")","v":""},null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E288),ISNUMBER(BWK),BWK<>0),(E288/BWK*100),\"\")","v":""}]
[null,711,"Projektleitung (Maßnahmen außerhalb des EP18 und Altmaßnahmen EP 18, Anteil der KG 711 bis 31.12.2019)",null,0]
[null,712,"Bedarfsplanung",null,0]
[null,713,"Projektsteuerung",null,0]
[null,714,"Sicherheits- und\nGesundheitsschutzkoordination",null,0]
[null,715,"Vergabeverfahren",null,0]
[null,719,"Sonstiges zur KG 710",null,0]
[null,710,"Bauherrenaufgaben",null,{"$f":"IF(COUNTIF(E289:E294,\"*\")=6,\"*\",IF(COUNTA(E289:E294)=6,SUM(E289:E294),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E295),ISNUMBER(BWK),BWK<>0),(E295/BWK*100),\"\")","v":""}]
[null,721,"Untersuchungen",null,0]
[null,722,"Wertermittlungen",null,0]
[null,723,"Städtebauliche Leistungen",null,0]
[null,724,"Landschaftsplanerische\nLeistungen",null,0]
[null,725,"Wettbewerbe",null,0]
[null,729,"Sonstiges zur KG 720",null,0]
[null,720,"Vorbereitung der Objektplanung",null,{"$f":"IF(COUNTIF(E296:E301,\"*\")=6,\"*\",IF(COUNTA(E296:E301)=6,SUM(E296:E301),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E302),ISNUMBER(BWK),BWK<>0),(E302/BWK*100),\"\")","v":""}]
[null,731,"Gebäude und Innenräume",null,0]
[null,732,"Freianlagen",null,0]
[null,733,"Ingenieurbauwerke",null,0]
[null,734,"Verkehrsanlagen",null,0]
[null,739,"Sonstiges zur KG 730",null,0]
[null,730,"Objektplanung",null,{"$f":"IF(COUNTIF(E303:E307,\"*\")=5,\"*\",IF(COUNTA(E303:E307)=5,SUM(E303:E307),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E308),ISNUMBER(BWK),BWK<>0),(E308/BWK*100),\"\")","v":""}]
[null,741,"Tragwerksplanung",null,0]
[null,742,"Technische Ausrüstung",null,0]
[null,743,"Bauphysik",null,0]
[null,744,"Geotechnik",null,0]
[null,745,"Ingenieurvermessung",null,0]
[null,746,"Lichttechnik, Tageslichttechnik",null,0]
[null,747,"Brandschutz",null,0]
[null,748,"Altlasten, Kampfmittel,\nkulturhistorische Funde",null,0]
[null,749,"Sonstiges zur KG 740",null,0]
[null,740,"Fachplanung",null,{"$f":"IF(COUNTIF(E309:E317,\"*\")=9,\"*\",IF(COUNTA(E309:E317)=9,SUM(E309:E317),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E318),ISNUMBER(BWK),BWK<>0),(E318/BWK*100),\"\")","v":""}]
[null,751,"Kunstwettbewerbe",null,0]
[null,752,"Honorare",null,0]
[null,759,"Sonstiges zur KG 750",null,0]
[null,750,"Künstlerische Leistungen",null,{"$f":"IF(COUNTIF(E319:E321,\"*\")=3,\"*\",IF(COUNTA(E319:E321)=3,SUM(E319:E321),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E322),ISNUMBER(BWK),BWK<>0),(E322/BWK*100),\"\")","v":""}]
[null,761,"Gutachten und Beratung",null,0]
[null,762,"Prüfungen, Genehmigungen,\nAbnahmen",null,0]
[null,763,"Bewirtschaftungskosten",null,0]
[null,764,"Bemusterungskosten",null,0]
[null,765,"Betriebskosten nach der\nAbnahme",null,0]
[null,766,"Versicherungen",null,0]
[null,769,"Sonstiges zur KG 760",null,0]
[null,760,"Allgemeine Baunebenkosten",null,{"$f":"IF(COUNTIF(E323:E329,\"*\")=7,\"*\",IF(COUNTA(E323:E329)=7,SUM(E323:E329),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E330),ISNUMBER(BWK),BWK<>0),(E330/BWK*100),\"\")","v":""}]
[null,791,"Bestandsdokumentation",null,0]
[null,799,"Sonstiges zur KG 790",null,0]
[null,790,"Sonstige Baunebenkosten",null,{"$f":"IF(COUNTIF(E331:E332,\"*\")=2,\"*\",IF(COUNTA(E331:E332)=2,SUM(E331:E332),\"\"))","v":0},"",null,null,"","",null,{"$f":"IF(AND(ISNUMBER(E333),ISNUMBER(BWK),BWK<>0),(E333/BWK*100),\"\")","v":""}]
[null,"700 *","Baunebenkosten",null,{"$f":"IF(AND(ISNUMBER(E295),ISNUMBER(E302),ISNUMBER(E308),ISNUMBER(E318),ISNUMBER(E322),ISNUMBER(E330),ISNUMBER(E318),ISNUMBER(E330),ISNUMBER(E333)),(E295+E302+E308+E318+E322+E330+E333),\"\")","v":0},"",null,null,"","",null,""]
[null,810,"Finanzierungsnebenkosten",null,0,{"$f":"IF(AND(ISNUMBER(E335),ISNUMBER(nNFa),nNFa<>0),E335/nNFa,\"\")","v":""},null,null,"","",null,""]
[null,820,"Fremdkapitalzinsen",null,0,"",null,null,"","",null,""]
[null,830,"Eigenkapitalzinsen",null,0,"",null,null,"","",null,""]
[null,840,"Bürgschaften",null,0,"",null,null,"","",null,""]
[null,890,"Sonstige Finanzierungskosten",null,0,"",null,null,"","",null,""]
[null,800,"Finanzierung",null,{"$f":"IF(COUNTIF(E335:E339,\"*\")=5,\"*\",IF(COUNTA(E335:E339)=5,SUM(E335:E339),\"\"))","v":0},"",null,null,"","",null,""]
[]
[null,"GBK","Gesamtbaukosten \n(200-500, 640, 690, 700*,800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E57),ISNUMBER(E135),ISNUMBER(E207),ISNUMBER(E277),ISNUMBER(E287),ISNUMBER(E334),ISNUMBER(_KG800)),(E57+E135+E207+E277+E287+E334+_KG800),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($E342),ISNUMBER(nNFa),nNFa<>0), $E342/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E342),ISNUMBER(nBGFa),nBGFa<>0),$E342/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E342),ISNUMBER(nBRIa),nBRIa<>0),$E342/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(E342),ISNUMBER(BWK),BWK<>0),(E342/BWK*100),\"\")","v":""}]
[]
[null,"GK","Gesamtkosten (100-800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E29),ISNUMBER(E57),ISNUMBER(E135),ISNUMBER(E207),ISNUMBER(E277),ISNUMBER(E278),ISNUMBER(E279),ISNUMBER(E280),ISNUMBER(E287),ISNUMBER(E288),ISNUMBER(E334),ISNUMBER(E340)),(E29+E57+E135+E207+E277+E278+E279+E280+E287+E288+E334+E340),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($E344),ISNUMBER(nNFa),nNFa<>0), $E344/nNFa,\"\")","v":""},null,null,{"$f":"IF(AND(ISNUMBER($E344),ISNUMBER(nBGFa),nBGFa<>0),$E344/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($E344),ISNUMBER(nBRIa),nBRIa<>0),$E344/nBRIa,\"\")","v":""},null,{"$f":"IF(AND(ISNUMBER(E344),ISNUMBER(BWK),BWK<>0),(E344/BWK*100),\"\")","v":""}]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]

{"sheet":"Kostendaten_NES","index":5,"n_rows":46,"n_cols":23,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,1,35,2],[34,1,34,4],[36,14,37,15],[38,14,39,15],[36,12,37,13],[38,12,39,13],[34,12,34,15],[15,3,15,4],[16,3,16,4],[26,3,26,4],[27,3,27,4],[19,3,19,4],[21,3,21,4],[29,3,29,4],[26,7,26,8],[29,7,29,8],[17,9,17,10],[21,7,21,8],[21,9,21,10],[9,22,12,22],[22,7,22,8],[22,9,22,10],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[20,7,20,8],[18,9,18,10],[9,20,12,20],[19,9,19,10],[19,7,19,8],[12,9,12,10],[13,9,13,10],[15,9,15,10],[16,9,16,10],[14,3,14,4],[40,8,40,9],[40,13,40,15],[20,9,20,10],[30,9,30,10],[38,8,38,9],[39,3,39,7],[29,9,29,10],[31,1,32,15],[26,9,26,10],[27,7,27,8],[28,9,28,10],[30,7,30,8],[28,3,28,4],[25,9,25,10],[14,9,14,10],[45,12,45,15],[46,14,46,15],[22,11,22,15],[39,8,39,9],[36,3,36,7],[36,8,36,9],[37,3,37,7],[37,8,37,9],[23,3,23,4],[41,13,41,15],[43,12,43,15],[23,9,23,10],[38,3,38,7],[27,9,27,10],[28,7,28,8],[42,12,42,15],[45,0,46,0],[12,7,12,8],[25,7,25,8],[13,7,13,8],[14,7,14,8],[17,3,17,4],[18,3,18,4],[20,3,20,4],[22,3,22,4],[40,3,40,7],[12,1,12,4],[25,3,25,4],[13,3,13,4],[30,3,30,4],[23,7,23,8],[45,1,49,11],[2,13,2,15],[5,1,7,6],[6,9,6,10],[7,9,7,10],[8,4,8,6],[7,11,7,12],[4,11,4,12],[7,13,9,15],[9,4,9,6],[9,9,9,10],[8,9,8,10]]}
["GABau Hessen",null,null,null,null,null,null,null,null,null,null,null,"Muster 6, ",{"$f":"IF(_nNr.<>\"\",_nNr.,\"\")","v":""},". Nachtrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zusammenstellung der Kostendaten   "]
[]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,null,null,null,"BWZ:        ",null,{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Projekt-Nr.: ",null,{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,"Bauwerk:",null,{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.:",null,null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},null,null,"Bearb.:",null,{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort:",null,null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},null,null,"Datum:",null,{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Direkteingabe Nachtragssumme\nauf 1. Ebene",null,"Direkteingabe gesamt \n(haushr. Anerk.)\nauf 1. Ebene"]
[]
[]
[null,"Kostenübersicht\n(nach DIN 276:2018-12)",null,null,null,"Nachtrag\n€ ( Euro )",null,"gesamt    (haushr. anerk.)\n€",null,"gesamt neu\n€",null,"Kosten / NUF\n€ / m²","Kosten / NRF\n€ / m² ","Kosten / BGF\n€ / m² ","Kosten / BRI\n€ / m³ ","Kosten / BWK\nin %"]
[null,200,null,"Vorbereitende Maßnahmen",null,{"$f":"IF(AND(U14=0,_nKG200_2=0),_nKG200,IF(AND(U14=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),U14,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W14=0,KG200gen_2=0),KG200gen,IF(AND(W14=0,KG200gen=0),KG200gen_2,IF(AND(KG200gen_2=0,KG200gen=0),W14,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X14=0,_nKG200_2=0),_nKG200,IF(AND(X14=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X14,\"Mehrfacheingabe\")))","v":0},{"$f":"F14+H14","v":0},null,{"$f":"IF(AND(ISNUMBER($J14),ISNUMBER(nNFa),nNFa<>0),$J14/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J14),ISNUMBER(nNRFa),nNRFa<>0),$J14/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J14),ISNUMBER(nBGFa),nBGFa<>0),$J14/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J14),ISNUMBER(nBRIa),nBRIa<>0),$J14/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J14),ISNUMBER(nBWKges),nBWKges<>0),$J14/nBWKges*100,\"\")","v":""},null,null,null,null,0,null,0]
[null,300,null,"Bauwerk - Baukonstruktionen",null,{"$f":"IF(AND(U15=0,_nKG300_2=0),_nKG300,IF(AND(U15=0,_nKG300=0),_nKG300_2,IF(AND(_nKG300_2=0,_nKG300=0),U15,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W15=0,KG300gen_2=0),KG300gen,IF(AND(W15=0,KG300gen=0),KG300gen_2,IF(AND(KG300gen_2=0,KG300gen=0),W15,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X15=0,_nKG200_2=0),_nKG200,IF(AND(X15=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X15,\"Mehrfacheingabe\")))","v":0},0,null,"","","","","",null,null,null,null,0,null,0]
[null,"400 ",null,"Bauwerk - Technische Anlagen",null,{"$f":"IF(AND(U16=0,_nKG400_2=0),_nKG400,IF(AND(U16=0,_nKG400=0),_nKG400_2,IF(AND(_nKG400_2=0,_nKG400=0),U16,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W16=0,KG400gen_2=0),KG400gen,IF(AND(W16=0,KG400gen=0),KG400gen_2,IF(AND(KG400gen_2=0,KG400gen=0),W16,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X16=0,_nKG200_2=0),_nKG200,IF(AND(X16=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X16,\"Mehrfacheingabe\")))","v":0},0,null,"","","","","",null,null,null,null,0,null,0]
[null,"BWK ",null,"Bauwerk (300 + 400) Zwischensumme",null,{"$f":"IF(AND(ISNUMBER(F15),ISNUMBER(F16)),SUM(F15:F16),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(H15),ISNUMBER(H16)),SUM(H15:H16),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(J15),ISNUMBER(J16)),SUM(J15:J16),\"\")","v":0},null,"","","","","",null,null,null,null,{"$f":"IF(AND(ISNUMBER(U15),ISNUMBER(U16)),SUM(U15:U16),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(W15),ISNUMBER(W16)),SUM(W15:W16),\"\")","v":0}]
[null,500,null,"Außenanlagen und Freiflächen",null,{"$f":"IF(AND(U18=0,_nKG500_2=0),_nKG500,IF(AND(U18=0,_nKG500=0),_nKG500_2,IF(AND(_nKG500_2=0,_nKG500=0),U18,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W18=0,KG500gen_2=0),KG500gen,IF(AND(W18=0,KG500gen=0),KG500gen_2,IF(AND(KG500gen_2=0,KG500gen=0),W18,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X18=0,_nKG200_2=0),_nKG200,IF(AND(X18=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X18,\"Mehrfacheingabe\")))","v":0},0,null,"","","","","",null,null,null,null,0,null,0]
[null,"640",null," Künstlerische Ausstattung",null,{"$f":"IF(AND(U19=0,_nKG640_2=0),_nKG640,IF(AND(U19=0,_nKG640=0),_nKG640_2,IF(AND(_nKG640_2=0,_nKG640=0),U19,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W19=0,KG640gen_2=0),KG640gen,IF(AND(W19=0,KG640gen=0),KG640gen_2,IF(AND(KG640gen_2=0,KG640gen=0),W19,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X19=0,_nKG200_2=0),_nKG200,IF(AND(X19=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X19,\"Mehrfacheingabe\")))","v":0},0,null,"","","","","",null,null,null,null,0,null,0]
[null,"690",null,"Sonstige Ausstattung",null,{"$f":"IF(AND(U20=0,_nKG690_2=0),_nKG690,IF(AND(U20=0,_nKG690=0),_nKG690_2,IF(AND(_nKG690_2=0,_nKG690=0),U20,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W20=0,KG690gen_2=0),KG690gen,IF(AND(W20=0,KG690gen=0),KG690gen_2,IF(AND(KG690gen_2=0,KG690gen=0),W20,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X20=0,_nKG200_2=0),_nKG200,IF(AND(X20=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X20,\"Mehrfacheingabe\")))","v":0},{"$f":"F20+H20","v":0},null,"","","","","",null,null,null,null,0,null,0]
[null,"700 *",null,"Baunebenkosten ",null,{"$f":"IF(AND(U21=0,_nKG700_2=0),_nKG700,IF(AND(U21=0,_nKG700=0),_nKG700_2,IF(AND(_nKG700_2=0,_nKG700=0),U21,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W21=0,KG700gen_2=0),KG700gen,IF(AND(W21=0,KG700gen=0),KG700gen_2,IF(AND(KG700gen_2=0,KG700gen=0),W21,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X21=0,_nKG200_2=0),_nKG200,IF(AND(X21=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X21,\"Mehrfacheingabe\")))","v":0},0,null,"","","","","",null,null,null,null,0,null,0]
[null,"800"," ","Finanzierung",null,{"$f":"IF(AND(U22=0,_nKG800_2=0),_nKG800,IF(AND(U22=0,_nKG800=0),_nKG800_2,IF(AND(_nKG800_2=0,_nKG800=0),U22,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W22=0,KG800gen_2=0),KG800gen,IF(AND(W22=0,KG800gen=0),KG800gen_2,IF(AND(KG800gen_2=0,KG800gen=0),W22,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X22=0,_nKG200_2=0),_nKG200,IF(AND(X22=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X22,\"Mehrfacheingabe\")))","v":0},{"$f":"F22+H22","v":0},null,"","","","","",null,null,null,null,0,null,0]
[null,null,null,"zur Aufrundung",null,{"$f":"IF(S23=\"\",\"\",S23)","v":0},null,0,null,{"$f":"F23+H23","v":0},null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(F14+F15+F16+F18+F19+F20+F21+F22), -3)","v":0},{"$f":"SUM(F14+F15+F16+F18+F19+F20+F21+F22)","v":0},{"$f":"Q23-R23","v":0}]
[null,"GBK",null,"Gesamtbaukosten\n(200-500,640,690,700*,800)",null,{"$f":"IF(AND(ISNUMBER(F14),ISNUMBER(F17),ISNUMBER(F18),ISNUMBER(F19),ISNUMBER(F20),ISNUMBER(F21),ISNUMBER(F22),ISNUMBER(F23)),(F14+F17+F18+F19+F20+F21+F22+F23),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(H14),ISNUMBER(H17),ISNUMBER(H18),ISNUMBER(H19),ISNUMBER(H20),ISNUMBER(H21),ISNUMBER(H22),ISNUMBER(H23)),(H14+H17+H18+H19+H20+H21+H22+H23),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(I14),ISNUMBER(I17),ISNUMBER(I18),ISNUMBER(I19),ISNUMBER(I20),ISNUMBER(I21),ISNUMBER(I23)),(I14+I17+I18+I19+I20+I21+I23),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J14),ISNUMBER(J17),ISNUMBER(J18),ISNUMBER(J19),ISNUMBER(J20),ISNUMBER(J21),ISNUMBER(J22),ISNUMBER(J23)),(J14+J17+J18+J19+J20+J21+J22+J23),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(K14),ISNUMBER(K17),ISNUMBER(K18),ISNUMBER(K19),ISNUMBER(K20),ISNUMBER(K21),ISNUMBER(K23)),(K14+K17+K18+K19+K20+K21+K23),\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J24),ISNUMBER(nNFa),nNFa<>0),$J24/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J24),ISNUMBER(nNRFa),nNRFa<>0),$J24/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J24),ISNUMBER(nBGFa),nBGFa<>0),$J24/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J24),ISNUMBER(nBRIa),nBRIa<>0),$J24/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J24),ISNUMBER(nBWKges),nBWKges<>0),$J24/nBWKges*100,\"\")","v":""}]
[null,"Nachrichtlich:"]
[null,100,null,"Grundstück",null,{"$f":"IF(AND(U26=0,_nKG100_2=0),_nKG100,IF(AND(U26=0,_nKG100=0),_nKG100_2,IF(AND(_nKG100_2=0,_nKG100=0),U26,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W26=0,KG100gen_2=0),KG100gen,IF(AND(W26=0,KG100gen=0),KG100gen_2,IF(AND(KG100gen_2=0,KG100gen=0),W26,\"Mehrfacheingabe\")))","v":0},{"$f":"IF(AND(X26=0,_nKG200_2=0),_nKG200,IF(AND(X26=0,_nKG200=0),_nKG200_2,IF(AND(_nKG200_2=0,_nKG200=0),X26,\"Mehrfacheingabe\")))","v":0},{"$f":"F26+H26","v":0},null,{"$f":"IF(AND(ISNUMBER($J26),ISNUMBER(nNFa),nNFa<>0),$J26/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J26),ISNUMBER(nNRFa),nNRFa<>0),$J26/nNRFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J26),ISNUMBER(nBGFa),nBGFa<>0),$J26/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J26),ISNUMBER(nBRIa),nBRIa<>0),$J26/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($J26),ISNUMBER(nBWKges),nBWKges<>0),$J26/nBWKges*100,\"\")","v":""},null,null,null,null,0,null,0]
[null,"610",null,"Allgemeine Ausstattung",null,{"$f":"IF(AND(U27=0,_nKG610_2=0),_nKG610,IF(AND(U27=0,_nKG610=0),_nKG610_2,IF(AND(_nKG610_2=0,_nKG610=0),U27,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W27=0,KG610gen_2=0),KG610gen,IF(AND(W27=0,KG610gen=0),KG610gen_2,IF(AND(KG610gen_2=0,KG610gen=0),W27,\"Mehrfacheingabe\")))","v":0},0,{"$f":"F27+H27","v":0},null,"","","","","",null,null,null,null,0,null,0]
[null,620,null,"Besondere Ausstattung",null,{"$f":"IF(AND(U28=0,_nKG620_2=0),_nKG620,IF(AND(U28=0,_nKG620=0),_nKG620_2,IF(AND(_nKG620_2=0,_nKG620=0),U28,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W28=0,KG620gen_2=0),KG620gen,IF(AND(W28=0,KG620gen=0),KG620gen_2,IF(AND(KG620gen_2=0,KG620gen=0),W28,\"Mehrfacheingabe\")))","v":0},0,{"$f":"F28+H28","v":0},null,"","","","","",null,null,null,null,0,null,0]
[null,630,null,"Informationstechnische Ausstattung",null,{"$f":"IF(AND(U29=0,_nKG630_2=0),_nKG630,IF(AND(U29=0,_nKG630=0),_nKG630_2,IF(AND(_nKG630_2=0,_nKG630=0),U29,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W29=0,KG630gen_2=0),KG630gen,IF(AND(W29=0,KG630gen=0),KG630gen_2,IF(AND(KG630gen_2=0,KG630gen=0),W29,\"Mehrfacheingabe\")))","v":0},0,{"$f":"F29+H29","v":0},null,"","","","","",null,null,null,null,0,null,0]
[null,711,null,"Projektleitung EP 18 ab 01.01.2020",null,{"$f":"IF(AND(U30=0,_nKG711_EP18_2=0),_nKG711_EP18,IF(AND(U30=0,_nKG711_EP18=0),_nKG711_EP18_2,IF(AND(_nKG711_EP18_2=0,_nKG711_EP18=0),U30,\"Mehrfacheingabe\")))","v":0},null,{"$f":"IF(AND(W30=0,KG711_EP18_gen_2=0),KG711_EP18_gen,IF(AND(W30=0,KG711_EP18_gen=0),KG711_EP18_gen_2,IF(AND(KG711_EP18_gen_2=0,KG711_EP18_gen=0),W30,\"Mehrfacheingabe\")))","v":0},0,0,null,"","","","","",null,null,null,null,0,null,0]
[null,"GK",null,"Gesamtkosten\n(100-800)",null,{"$f":"IF(AND(ISNUMBER(F14),ISNUMBER(F17),ISNUMBER(F18),ISNUMBER(F19),ISNUMBER(F20),ISNUMBER(F21),ISNUMBER(F23),ISNUMBER(F26),ISNUMBER(F27),ISNUMBER(F28),ISNUMBER(F29),ISNUMBER(F30)),SUM(F14,F17:F23,SUM(F26:F30)),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(H14),ISNUMBER(H17),ISNUMBER(H18),ISNUMBER(H19),ISNUMBER(H20),ISNUMBER(H21),ISNUMBER(H22),ISNUMBER(H23),ISNUMBER(H26),ISNUMBER(H27),ISNUMBER(H28),ISNUMBER(H29),ISNUMBER(H30)),SUM(H14,H17:H23,SUM(H26:H30)),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(I14),ISNUMBER(I17),ISNUMBER(I18),ISNUMBER(I19),ISNUMBER(I20),ISNUMBER(I21),ISNUMBER(I23),ISNUMBER(I26),ISNUMBER(I27),ISNUMBER(I28),ISNUMBER(I29),ISNUMBER(I30),ISNUMBER(#REF!)),SUM(I14,I17:I23,SUM(I26:I30)),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(J14),ISNUMBER(J17),ISNUMBER(J18),ISNUMBER(J19),ISNUMBER(J20),ISNUMBER(J21),ISNUMBER(J22),ISNUMBER(J23),ISNUMBER(J26),ISNUMBER(J27),ISNUMBER(J28),ISNUMBER(J29),ISNUMBER(J30)),SUM(J14,J17:J23,SUM(J26:J30)),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(K14),ISNUMBER(K17),ISNUMBER(K18),ISNUMBER(K19),ISNUMBER(K20),ISNUMBER(K21),ISNUMBER(K23),ISNUMBER(K26),ISNUMBER(K27),ISNUMBER(K28),ISNUMBER(K29),ISNUMBER(K30),ISNUMBER(#REF!)),SUM(K14,K17:K23,SUM(K26:K30)),\"\")","v":""},"","","","",""]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]
[]
[]
[null,"Besondere Kosteneinflüsse:",null,null,null,null,null,null,null,null,null,null,"nachrichtlich:\n(Gesamt neu)"]
[null,"KG"]
[null,null,null,null,null,null,null,null,null,null,null,null,"aktivierungs-pflichtig (in €)",null,"Aufwand \n(in €)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kontrollsumme:",{"$f":"IF(F24=SUM(M39:P40),\"Summe entspricht PK\",\"PK nicht vollständig aufgeteilt\")","v":"Summe entspricht PK"}]
[]
[null,"Summe der haushaltrechtlich anerkannten ES-Bau",null,null,null,null,null,null,null,null,null,null,0]
[null,"Summe der haushaltrechtlich anerkannten Nachträge",null,null,null,null,null,null,"1. bis",null,"Nachtrag",null,{"$f":"M46-M43","v":0}]
[null,"Erläuterungsfeld",null,null,null,null,null,null,null,null,null,null,"gesamt","(haushr. anerk.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H24","v":0}]

{"sheet":"Kostendaten_2.Ebene_NES","index":6,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":true,"merged":[[77,12,77,13],[1,4,1,14],[2,11,2,14],[4,12,4,13],[28,2,28,3],[31,2,31,3],[26,2,26,3],[27,2,27,3],[24,2,24,3],[25,2,25,3],[23,2,23,3],[17,2,17,3],[12,1,12,3],[20,2,20,3],[18,2,18,3],[5,1,7,4],[6,7,6,8],[7,7,7,8],[9,7,9,8],[15,12,15,13],[16,12,16,13],[17,12,17,13],[4,10,4,11],[21,12,21,13],[53,12,53,13],[54,12,54,13],[8,7,8,8],[7,10,9,13],[13,12,13,13],[14,12,14,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[19,12,19,13],[20,12,20,13],[18,12,18,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[12,12,12,14],[57,12,57,13],[75,12,75,13],[75,2,75,3],[48,12,48,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[60,2,60,3],[55,2,55,3],[56,2,56,3],[52,2,52,3],[51,2,51,3],[48,2,48,3],[43,2,43,3],[38,2,38,3],[39,2,39,3],[53,2,53,3],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[60,12,60,13],[73,12,73,13],[74,10,74,11],[74,12,74,14],[72,12,72,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[65,12,65,13],[66,12,66,13],[67,12,67,13],[61,12,61,13],[70,12,70,13],[71,12,71,13],[78,1,79,13],[30,2,30,3],[32,2,32,3],[37,2,37,3],[42,2,42,3],[58,2,58,3],[68,12,68,13],[69,12,69,13],[54,2,54,3],[57,2,57,3],[34,12,34,13],[35,12,35,13],[36,12,36,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[76,10,76,11],[76,12,76,14],[55,12,55,13],[56,12,56,13],[58,12,58,13],[59,12,59,13]]}
["GABau Hessen",null,null,null,null,null,null,null,null,"Muster 6, ",{"$f":"IF(_nNr.<>\"\",_nNr.,\"\")","v":""},". Nachtrag"]
[null,null,null,null,"Kosten nach DIN 276,  2. Ebene"]
[]
[]
[null,"Baumaßnahme",null,null,null,null,null,null,null,"BWZ",{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Projekt-Nr. ",{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,"Bauwerk:",{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.",null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},null,null,"Bearb.",{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort",null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},null,null,"Datum",{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""}]
[]
[]
[null,"Kostengruppen \n(nach DIN 276:2018-12)",null,null,"Nachtrag\n€ ( Euro )",null,"gesamt    (haushr. anerk.)\n€",null,"gesamt neu\n€","€ / m² NUF","€ / m² BGF","€ / m³ BRI","Kosten / BWK  in %"]
[null,110,"Grundstückswert (nachrichtlich)",null,0,null,0,null,{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(G14)),E14+G14,\"\")","v":0},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nNFa),nNFa<>0), $I14/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nBGFa),nBGFa<>0),$I14/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nBRIa),nBRIa<>0),$I14/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I14),ISNUMBER(nBWKges),nBWKges<>0),I14/nBWKges*100,\"\")","v":""}]
[null,120,"Grundstücksnebenkosten (nachrichtlich)",null,0,null,0,null,{"$f":"IF(AND(ISNUMBER(E15),ISNUMBER(G15)),E15+G15,\"\")","v":0},"","","",""]
[null,130,"Rechte Dritter (nachrichtlich)",null,0,null,0,null,0,"","","",""]
[null,100,"Grundstück (nachrichtlich)",null,{"$f":"IF(COUNTA(E14:E16)=3,SUM(E14:E16),\"\")","v":0},null,{"$f":"IF(COUNTA(G14:G16)=3,SUM(G14:G16),\"\")","v":0},null,0,"","","",""]
[null,210,"Herrichten",null,0,null,0,null,0,"","","",""]
[null,"220         Öffentliche Erschließung","Öffentliche Erschließung",null,0,null,0,null,0,"","","",""]
[null,230,"Nichtöffentliche Erschließung",null,0,null,0,null,0,"","","",""]
[null,240,"Ausgleichsmaßnahmen und -abgaben",null,0,null,0,null,0,"","","",""]
[null,250,"Übergangsmaßnahmen",null,0,null,0,null,0,"","","",""]
[null,200,"Vorbereitende Maßnahmen",null,{"$f":"IF(COUNTA(E18:E22)=5,SUM(E18:E22),\"\")","v":0},null,{"$f":"IF(COUNTA(G18:G22)=5,SUM(G18:G22),\"\")","v":0},null,0,"","","",""]
[null,310,"Baugrube / Erdbau",null,0,null,0,null,0,"","","",""]
[null,320,"Gründung, Unterbau",null,0,null,0,null,0,"","","",""]
[null,330,"Außenwände / Vertikale\nBaukonstruktionen, außen",null,0,null,0,null,0,"","","",""]
[null,340,"Innenwände / Vertikale\nBaukonstruktionen, innen",null,0,null,0,null,0,"","","",""]
[null,350,"Decken / Horizontale\nBaukonstruktionen",null,0,null,0,null,0,"","","",""]
[null,360,"Dächer",null,0,null,0,null,0,"","","",""]
[null,370,"Infrastrukturanlagen",null,0,null,0,null,0,"","","",""]
[null,380,"Baukonstruktive Einbauten\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektronische Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,0,null,0,null,0,"","","",""]
[null,390,"Sonstige Maßnahmen für Baukonstruktionen",null,0,null,0,null,0,"","","",""]
[null,300,"Bauwerk - Baukonstruktionen\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektronische Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(COUNTA(E24:E32)=9,SUM(E24:E32),\"\")","v":0},null,{"$f":"IF(COUNTA(G24:G32)=9,SUM(G24:G32),\"\")","v":0},null,0,"","","",""]
[null,410,"Abwasser-, Wasser-, Gasanlagen",null,0,null,0,null,0,"","","",""]
[null,420,"Wärmeversorgungsanlagen",null,0,null,0,null,0,"","","",""]
[null,430,"Lufttechnische Anlagen",null,0,null,0,null,0,"","","",""]
[null,440,"Elektrische Anlagen",null,0,null,0,null,0,"","","",""]
[null,450,"Kommunikations-, sicherheits- u. informationstechnische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,0,null,0,null,0,"","","",""]
[null,460,"Förderanlagen",null,0,null,0,null,0,"","","",""]
[null,470,"Nutzungsspezifische und\nverfahrenstechniche Anlagen",null,0,null,0,null,0,"","","",""]
[null,480,"Gebäudeautomation",null,0,null,0,null,0,"","","",""]
[null,490,"Sonst. Maßnahmen für Technische Anl.",null,0,null,0,null,0,"","","",""]
[null,400,"Bauwerk Technische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(COUNTA(E34:E42)=9,SUM(E34:E42),\"\")","v":0},null,{"$f":"IF(COUNTA(G34:G42)=9,SUM(G34:G42),\"\")","v":0},null,0,"","","",""]
[null,510,"Erdbau",null,0,null,0,null,0,"","","",""]
[null,520,"Gründung Unterbau",null,0,null,0,null,0,"","","",""]
[null,530,"Oberbau, Deckschichten",null,0,null,0,null,0,{"$f":"IF(AND(ISNUMBER($I46),ISNUMBER(nNFa),nNFa<>0), $I46/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I46),ISNUMBER(nBGFa),nBGFa<>0),$I46/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I46),ISNUMBER(nBRIa),nBRIa<>0),$I46/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I46),ISNUMBER(nBWKges),nBWKges<>0),I46/nBWKges*100,\"\")","v":""}]
[null,540,"Baukonstruktionen",null,0,null,0,null,0,"","","",""]
[null,550,"Technische Anlagen",null,0,null,0,null,0,"","","",""]
[null,560,"Einbauten in Außenanlagen\nund Freiflächen",null,0,null,0,null,0,"","","",""]
[null,570,"Vegetationsflächen",null,0,null,0,null,0,"","","",""]
[null,580,"Wasserflächen",null,0,null,0,null,0,"","","",""]
[null,590,"Sonst.  Maßnahmen für Außenanl. u. Freiflächen",null,0,null,0,null,0,"","","",""]
[null,500,"Außenanlagen und Freiflächen",null,{"$f":"IF(COUNTA(E44:E52)=9,SUM(E44:E52),\"\")","v":0},null,{"$f":"IF(COUNTA(G44:G52)=9,SUM(G44:G52),\"\")","v":0},null,0,"","","",""]
[null,610,"Allgemeine Ausstattung (nachrichtlich)",null,0,null,0,null,0,"","","",""]
[null,620,"Besondere Ausstattung (nachrichtlich)",null,0,null,0,null,0,"","","",""]
[null,630,"Informationstechnische\nAusstattung (nachrichtlich)",null,0,null,0,null,0,"","","",""]
[null,640,"Künstlerische Ausstattung",null,0,null,0,null,0,"","","",""]
[null,690,"Sonstige Ausstattung \n(Zuordnung Schilder, Wegweiser, Informations- u. Werbetafeln zu KG 386 u. KG 451)",null,0,null,0,null,0,"","","",""]
[null,600,"Ausstattung und Kunstwerke\n(ohne KG 610, 620, 630)",null,{"$f":"IF(COUNTA(E57:E58)=2,SUM(E57:E58),\"\")","v":0},null,{"$f":"IF(COUNTA(G57:G58)=2,SUM(G57:G58),\"\")","v":0},null,0,"","","",""]
[null,710,"Bauherrenaufgaben",null,0,null,0,null,0,"","","",""]
[null,711,"Projektleitung (bei EP 18 ab 2020, nachrichtlich)",null,0,null,0,null,0,"","","",""]
[null,720,"Vorbereitung der Objektplanung",null,0,null,0,null,0,"","","",""]
[null,730,"Objektplanung",null,0,null,0,null,0,"","","",""]
[null,740,"Fachplanung",null,0,null,0,null,0,"","","",""]
[null,750,"Künstlerische Leistungen",null,0,null,0,null,0,"","","",""]
[null,760,"Allgemeine Baunebenkosten",null,0,null,0,null,0,"","","",""]
[null,790,"Sonstige Baunebenkosten",null,0,null,0,null,0,"","","",""]
[null,700,"Baunebenkosten",null,{"$f":"IF(COUNTA(E60,E62:E67)=7,E60+SUM(E62:E67),\"\")","v":0},null,{"$f":"IF(COUNTA(G60,G62:G67)=7,G60+SUM(G62:G67),\"\")","v":0},null,0,"","","",""]
[null,810,"Finanzierungsnebenkosten",null,0,null,0,null,0,"","","",""]
[null,820,"Fremdkapitalzinsen",null,0,null,0,null,0,"","","",""]
[null,830,"Eigenkapitalzinsen",null,0,null,0,null,0,"","","",""]
[null,840,"Bürgschaften",null,0,null,0,null,0,"","","",""]
[null,890,"Sonstige Finanzierungskosten",null,0,null,0,null,0,"","","",""]
[null,800,"Finanzierung",null,{"$f":"IF(COUNTA(E69:E73)=5,SUM(E69:E73),\"\")","v":0},null,{"$f":"IF(COUNTA(G69:G73)=5,SUM(G69:G73),\"\")","v":0},null,0,"","","",""]
[]
[null,"GBK","Gesamtbaukosten \n(200-500, 640, 690, 700*,800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E23),ISNUMBER(E33),ISNUMBER(E43),ISNUMBER(E53),ISNUMBER(E59),ISNUMBER(E68),ISNUMBER(_nKG800_2)),(E23+E33+E43+E53+E59+E68+_nKG800_2),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G23),ISNUMBER(G33),ISNUMBER(G43),ISNUMBER(G53),ISNUMBER(G59),ISNUMBER(G68),ISNUMBER(KG800gen_2)),(G23+G33+G43+G53+G59+G68+KG800gen_2),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(H23),ISNUMBER(H33),ISNUMBER(H43),ISNUMBER(H53),ISNUMBER(H59),ISNUMBER(H68),ISNUMBER(H74)),(H23+H33+H43+H53+H59+H68+H74),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E76),ISNUMBER(G76)),E76+G76,\"\")","v":0},{"$f":"IF(AND(ISNUMBER($I76),ISNUMBER(nNFa),nNFa<>0), $I76/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I76),ISNUMBER(nBGFa),nBGFa<>0),$I76/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I76),ISNUMBER(nBRIa),nBRIa<>0),$I76/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I76),ISNUMBER(nBWKges),nBWKges<>0),I76/nBWKges*100,\"\")","v":""}]
[]
[null,"GK","Gesamtkosten (100-800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E17),ISNUMBER(E23),ISNUMBER(E33),ISNUMBER(E43),ISNUMBER(E53),ISNUMBER(E54),ISNUMBER(E55),ISNUMBER(E56),ISNUMBER(E59),ISNUMBER(E61),ISNUMBER(E68),ISNUMBER(E74)),(E17+E23+E33+E43+E53+E54+E55+E56+E59+E61+E68+E74),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G17),ISNUMBER(G23),ISNUMBER(G33),ISNUMBER(G43),ISNUMBER(G53),ISNUMBER(G54),ISNUMBER(G55),ISNUMBER(G56),ISNUMBER(G59),ISNUMBER(G61),ISNUMBER(G68),ISNUMBER(G74)),(G17+G23+G33+G43+G53+G54+G55+G56+G59+G61+G68+G74),\"\")","v":0},{"$f":"IF(AND(ISNUMBER(H17),ISNUMBER(H23),ISNUMBER(H33),ISNUMBER(H43),ISNUMBER(H53),ISNUMBER(H54),ISNUMBER(H55),ISNUMBER(H56),ISNUMBER(H59),ISNUMBER(H61),ISNUMBER(H68),ISNUMBER(H74)),(H17+H23+H33+H43+H53+H54+H55+H56+H59+H61+H68+H74),\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E78),ISNUMBER(G78)),E78+G78,\"\")","v":0},{"$f":"IF(AND(ISNUMBER($I78),ISNUMBER(nNFa),nNFa<>0), $I78/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I78),ISNUMBER(nBGFa),nBGFa<>0),$I78/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I78),ISNUMBER(nBRIa),nBRIa<>0),$I78/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I78),ISNUMBER(nBWKges),nBWKges<>0),I78/nBWKges*100,\"\")","v":""}]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]

{"sheet":"Kostendaten_bis_3.Ebene_NES","index":7,"n_rows":345,"n_cols":15,"rows_kept":345,"cut":false,"hidden":true,"merged":[[33,12,33,13],[34,12,34,13],[35,12,35,13],[24,2,24,3],[36,12,36,13],[285,12,285,13],[8,7,8,8],[13,12,13,13],[7,7,7,8],[7,10,9,13],[9,7,9,8],[23,12,23,13],[24,12,24,13],[25,12,25,13],[28,2,28,3],[29,2,29,3],[30,2,30,3],[28,12,28,13],[29,12,29,13],[30,12,30,13],[25,2,25,3],[26,2,26,3],[12,1,12,3],[13,2,13,3],[343,12,343,13],[286,2,286,3],[5,1,7,4],[6,7,6,8],[27,2,27,3],[26,12,26,13],[27,12,27,13],[37,2,37,3],[38,2,38,3],[39,2,39,3],[37,12,37,13],[38,12,38,13],[39,12,39,13],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[31,12,31,13],[32,12,32,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[2,10,2,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[4,10,4,11],[4,12,4,13],[12,12,12,13],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[44,2,44,3],[45,2,45,3],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[44,12,44,13],[45,12,45,13],[40,2,40,3],[41,2,41,3],[43,2,43,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[48,12,48,13],[49,12,49,13],[50,12,50,13],[51,12,51,13],[52,12,52,13],[53,12,53,13],[52,2,52,3],[53,2,53,3],[46,2,46,3],[47,2,47,3],[46,12,46,13],[47,12,47,13],[42,2,42,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[56,12,56,13],[57,12,57,13],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[62,12,62,13],[54,2,54,3],[55,2,55,3],[54,12,54,13],[55,12,55,13],[48,2,48,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[68,12,68,13],[69,12,69,13],[70,12,70,13],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[65,12,65,13],[66,12,66,13],[67,12,67,13],[63,12,63,13],[64,12,64,13],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[89,2,89,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[95,12,95,13],[96,12,96,13],[97,12,97,13],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[92,12,92,13],[93,12,93,13],[94,12,94,13],[104,2,104,3],[105,2,105,3],[106,2,106,3],[104,12,104,13],[105,12,105,13],[106,12,106,13],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[103,2,103,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[116,2,116,3],[117,2,117,3],[118,2,118,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[112,2,112,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[124,2,124,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[134,12,134,13],[135,12,135,13],[136,12,136,13],[131,2,131,3],[132,2,132,3],[133,2,133,3],[131,12,131,13],[132,12,132,13],[133,12,133,13],[140,2,140,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[145,2,145,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[149,2,149,3],[150,2,150,3],[151,2,151,3],[149,12,149,13],[150,12,150,13],[151,12,151,13],[146,2,146,3],[147,2,147,3],[148,2,148,3],[146,12,146,13],[147,12,147,13],[148,12,148,13],[158,2,158,3],[159,2,159,3],[160,2,160,3],[158,12,158,13],[159,12,159,13],[160,12,160,13],[152,2,152,3],[153,2,153,3],[154,2,154,3],[155,2,155,3],[156,2,156,3],[157,2,157,3],[152,12,152,13],[153,12,153,13],[154,12,154,13],[155,12,155,13],[156,12,156,13],[157,12,157,13],[167,2,167,3],[168,2,168,3],[169,2,169,3],[170,2,170,3],[161,2,161,3],[162,2,162,3],[163,2,163,3],[164,2,164,3],[165,2,165,3],[166,2,166,3],[176,2,176,3],[177,2,177,3],[178,2,178,3],[176,12,176,13],[177,12,177,13],[178,12,178,13],[171,2,171,3],[172,2,172,3],[173,2,173,3],[174,2,174,3],[175,2,175,3],[173,12,173,13],[174,12,174,13],[175,12,175,13],[185,2,185,3],[186,2,186,3],[187,2,187,3],[188,2,188,3],[179,2,179,3],[180,2,180,3],[181,2,181,3],[182,2,182,3],[183,2,183,3],[184,2,184,3],[194,2,194,3],[195,2,195,3],[196,2,196,3],[194,12,194,13],[195,12,195,13],[196,12,196,13],[189,2,189,3],[190,2,190,3],[191,2,191,3],[192,2,192,3],[193,2,193,3],[191,12,191,13],[192,12,192,13],[193,12,193,13],[203,2,203,3],[204,2,204,3],[205,2,205,3],[203,12,203,13],[204,12,204,13],[205,12,205,13],[197,2,197,3],[198,2,198,3],[199,2,199,3],[200,2,200,3],[201,2,201,3],[202,2,202,3],[197,12,197,13],[198,12,198,13],[199,12,199,13],[200,12,200,13],[201,12,201,13],[202,12,202,13],[209,2,209,3],[210,2,210,3],[211,2,211,3],[212,2,212,3],[206,2,206,3],[207,2,207,3],[208,2,208,3],[206,12,206,13],[207,12,207,13],[208,12,208,13],[210,12,210,13],[211,12,211,13],[212,12,212,13],[218,2,218,3],[219,2,219,3],[220,2,220,3],[218,12,218,13],[219,12,219,13],[220,12,220,13],[213,2,213,3],[214,2,214,3],[215,2,215,3],[216,2,216,3],[217,2,217,3],[215,12,215,13],[216,12,216,13],[217,12,217,13],[213,12,213,13],[214,12,214,13],[221,2,221,3],[222,2,222,3],[223,2,223,3],[224,2,224,3],[225,2,225,3],[226,2,226,3],[224,12,224,13],[225,12,225,13],[226,12,226,13],[231,2,231,3],[232,2,232,3],[233,2,233,3],[234,2,234,3],[235,2,235,3],[236,2,236,3],[227,2,227,3],[228,2,228,3],[230,2,230,3],[241,2,241,3],[242,2,242,3],[243,2,243,3],[244,2,244,3],[245,2,245,3],[246,2,246,3],[237,2,237,3],[238,2,238,3],[240,2,240,3],[251,2,251,3],[252,2,252,3],[253,2,253,3],[254,2,254,3],[247,2,247,3],[248,2,248,3],[250,2,250,3],[247,12,247,13],[248,12,248,13],[249,12,249,13],[250,12,250,13],[251,12,251,13],[252,12,252,13],[253,12,253,13],[254,12,254,13],[255,2,255,3],[256,2,256,3],[257,2,257,3],[258,2,258,3],[259,2,259,3],[257,12,257,13],[258,12,258,13],[259,12,259,13],[255,12,255,13],[256,12,256,13],[264,2,264,3],[266,2,266,3],[267,2,267,3],[261,2,261,3],[262,2,262,3],[263,2,263,3],[260,12,260,13],[261,12,261,13],[262,12,262,13],[263,12,263,13],[274,2,274,3],[275,2,275,3],[276,2,276,3],[277,2,277,3],[278,2,278,3],[268,2,268,3],[269,2,269,3],[270,2,270,3],[271,2,271,3],[272,2,272,3],[273,2,273,3],[290,2,290,3],[291,2,291,3],[292,2,292,3],[293,2,293,3],[287,2,287,3],[288,2,288,3],[289,2,289,3],[288,12,288,13],[289,12,289,13],[293,12,293,13],[295,2,295,3],[296,2,296,3],[297,2,297,3],[298,2,298,3],[299,2,299,3],[296,12,296,13],[297,12,297,13],[298,12,298,13],[299,12,299,13],[304,2,304,3],[305,2,305,3],[306,2,306,3],[304,12,304,13],[305,12,305,13],[306,12,306,13],[307,12,307,13],[300,2,300,3],[302,2,302,3],[303,2,303,3],[300,12,300,13],[301,12,301,13],[302,12,302,13],[303,12,303,13],[314,2,314,3],[315,2,315,3],[316,2,316,3],[317,2,317,3],[308,2,308,3],[309,2,309,3],[310,2,310,3],[311,2,311,3],[312,2,312,3],[313,2,313,3],[322,2,322,3],[323,2,323,3],[324,2,324,3],[325,2,325,3],[326,2,326,3],[327,2,327,3],[318,2,318,3],[319,2,319,3],[320,2,320,3],[338,12,338,13],[339,12,339,13],[336,12,336,13],[337,12,337,13],[334,12,334,13],[335,12,335,13],[332,12,332,13],[333,12,333,13],[328,2,328,3],[330,2,330,3],[331,2,331,3],[328,12,328,13],[329,12,329,13],[330,12,330,13],[331,12,331,13],[342,5,342,7],[342,9,342,10],[342,11,342,13],[340,5,340,7],[340,9,340,10],[340,11,340,13],[341,2,341,3],[341,12,341,13],[71,12,71,13],[72,12,72,13],[73,12,73,13],[74,12,74,13],[75,12,75,13],[76,12,76,13],[86,12,86,13],[87,12,87,13],[88,12,88,13],[89,12,89,13],[90,12,90,13],[91,12,91,13],[77,12,77,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[81,12,81,13],[82,12,82,13],[83,12,83,13],[84,12,84,13],[85,12,85,13],[107,12,107,13],[108,12,108,13],[109,12,109,13],[110,12,110,13],[111,12,111,13],[112,12,112,13],[98,12,98,13],[99,12,99,13],[100,12,100,13],[101,12,101,13],[102,12,102,13],[103,12,103,13],[119,12,119,13],[120,12,120,13],[121,12,121,13],[122,12,122,13],[123,12,123,13],[124,12,124,13],[113,12,113,13],[114,12,114,13],[115,12,115,13],[116,12,116,13],[117,12,117,13],[118,12,118,13],[125,12,125,13],[126,12,126,13],[127,12,127,13],[128,12,128,13],[129,12,129,13],[130,12,130,13],[137,12,137,13],[138,12,138,13],[139,12,139,13],[140,12,140,13],[141,12,141,13],[142,12,142,13],[143,12,143,13],[144,12,144,13],[145,12,145,13],[167,12,167,13],[168,12,168,13],[169,12,169,13],[170,12,170,13],[171,12,171,13],[172,12,172,13],[161,12,161,13],[162,12,162,13],[163,12,163,13],[164,12,164,13],[165,12,165,13],[166,12,166,13],[227,12,227,13],[228,12,228,13],[229,12,229,13],[230,12,230,13],[231,12,231,13],[232,12,232,13],[233,12,233,13],[234,12,234,13],[179,12,179,13],[180,12,180,13],[181,12,181,13],[182,12,182,13],[183,12,183,13],[184,12,184,13],[185,12,185,13],[186,12,186,13],[187,12,187,13],[188,12,188,13],[189,12,189,13],[190,12,190,13],[221,12,221,13],[222,12,222,13],[223,12,223,13],[209,12,209,13],[240,12,240,13],[241,12,241,13],[242,12,242,13],[243,12,243,13],[244,12,244,13],[245,12,245,13],[246,12,246,13],[274,12,274,13],[264,12,264,13],[265,12,265,13],[266,12,266,13],[267,12,267,13],[268,12,268,13],[269,12,269,13],[270,12,270,13],[285,2,285,3],[279,12,279,13],[280,12,280,13],[279,2,279,3],[280,2,280,3],[281,2,281,3],[282,2,282,3],[283,2,283,3],[284,2,284,3],[281,12,281,13],[282,12,282,13],[283,12,283,13],[284,12,284,13],[276,12,276,13],[322,12,322,13],[323,12,323,13],[324,12,324,13],[325,12,325,13],[326,12,326,13],[327,12,327,13],[314,12,314,13],[315,12,315,13],[316,12,316,13],[317,12,317,13],[318,12,318,13],[319,12,319,13],[320,12,320,13],[321,12,321,13],[277,12,277,13],[278,12,278,13],[344,1,345,12],[1,4,1,13],[308,12,308,13],[309,12,309,13],[310,12,310,13],[311,12,311,13],[312,12,312,13],[313,12,313,13],[290,12,290,13],[291,12,291,13],[292,12,292,13],[294,12,294,13],[295,12,295,13],[271,12,271,13],[272,12,272,13],[273,12,273,13],[286,12,286,13],[287,12,287,13],[235,12,235,13],[236,12,236,13],[237,12,237,13],[238,12,238,13],[239,12,239,13],[275,12,275,13]]}
[null,"GABau Hessen",null,null,null,null,null,null,null,"Muster 6,",{"$f":"IF(_nNr.<>\"\",_nNr.,\"\")","v":""},". Nachtrag"]
[null,null,null,null,{"$f":"IF(O5=TRUE,\"Kosten nach DIN 276,  3. Ebene\",\"Kosten nach DIN 276,  2. Ebene\")","v":"Kosten nach DIN 276,  3. Ebene"}]
[]
[]
[null,"Baumaßnahme:",null,null,null,null,null,null,null,"BWZ:",{"$f":"IF(mBWZ<>\"\",mBWZ,\"\")","v":""},null,null,null,{"$f":"sichtbar(B15)","v":true}]
[null,{"$f":"IF(mBaumaßnahme<>\"\",mBaumaßnahme,\"\")","v":""}]
[]
[null,null,null,null,null,null,"Projekt-Nr.: ",{"$f":"IF(mProjektNr<>\"\",mProjektNr,\"\")","v":""},null,"Bauwerk:",{"$f":"IF(mBauwerk<>\"\",mBauwerk,\"\")","v":""}]
[null,"Straße + Nr.:",null,{"$f":"IF(mStrasse<>\"\",mStrasse,\"\")","v":""},null,null,"Bearb.:",{"$f":"IF(mBearbeiter<>\"\",mBearbeiter,\"\")","v":""}]
[null,"PLZ + Ort:",null,{"$f":"IF(mPLZOrt<>\"\",mPLZOrt,\"\")","v":""},null,null,"Datum:",{"$f":"IF(mDatum<>\"\",mDatum,\"\")","v":""}]
[]
[]
[null,"Kostengruppen \n(nach DIN 276:2018-12)",null,null,"Nachtrag\n€ ( Euro )",null,"gesamt    (haushr. anerk.)\n€",null,"gesamt neu\n€","€ / m² NUF","€ / m² BGF","€ / m³ BRI","Kosten / BWK  in %"]
[null,110,"Grundstückswert",null,0,null,0,null,{"$f":"E14+G14","v":0},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nNFa),nNFa<>0),$I14/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nBGFa),nBGFa<>0),$I14/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I14),ISNUMBER(nBRIa),nBRIa<>0),$I14/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I14),ISNUMBER(nBWKges),nBWKges<>0),I14/nBWKges*100,\"\")","v":""}]
[null,121,"Vermessungsgebühren",null,0,null,0,null,{"$f":"E15+G15","v":0}]
[null,122,"Gerichtsgebühren",null,0,null,0,null,{"$f":"E16+G16","v":0}]
[null,123,"Notariatsgebühren",null,0,null,0,null,0]
[null,124,"Grunderwerbssteuer",null,0,null,0,null,0]
[null,125,"Untersuchungen",null,0,null,0,null,0]
[null,126,"Wertermittlungen",null,0,null,0,null,0]
[null,127,"Genehmigungsgebühren",null,0,null,0,null,0]
[null,128,"Bodenordnung",null,0,null,0,null,0]
[null,129,"Sonstiges zur KG 120",null,0,null,0,null,0]
[null,120,"Grundstücksnebenkosten",null,{"$f":"IF(COUNTIF(E15:E23,\"*\")=9,\"*\",IF(COUNTA(E15:E23)=9,SUM(E15:E23),\"\"))","v":0},{"$f":"IF(AND(ISNUMBER($E24),ISNUMBER(nNFa),nNFa<>0), $E24/nNFa,\"\")","v":""},{"$f":"IF(COUNTIF(G15:G23,\"*\")=9,\"*\",IF(COUNTA(G15:G23)=9,SUM(G15:G23),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I24),ISNUMBER(nNFa),nNFa<>0),$I24/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I24),ISNUMBER(nBGFa),nBGFa<>0),$I24/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I24),ISNUMBER(nBRIa),nBRIa<>0),$I24/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I24),ISNUMBER(nBWKges),nBWKges<>0),I24/nBWKges*100,\"\")","v":""}]
[null,131,"Abfindungen",null,0,null,0,null,0]
[null,132,"Ablösen dinglicher Rechte",null,0,null,0,null,0]
[null,139,"Sonstiges zur KG 130",null,0,null,0,null,0]
[null,130,"Rechte Dritter",null,{"$f":"IF(COUNTIF(E25:E27,\"*\")=3,\"*\",IF(COUNTA(E25:E27)=3,SUM(E25:E27),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G25:G27,\"*\")=3,\"*\",IF(COUNTA(G25:G27)=3,SUM(G25:G27),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I28),ISNUMBER(nNFa),nNFa<>0),$I28/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I28),ISNUMBER(nBGFa),nBGFa<>0),$I28/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I28),ISNUMBER(nBRIa),nBRIa<>0),$I28/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I28),ISNUMBER(nBWKges),nBWKges<>0),I28/nBWKges*100,\"\")","v":""}]
[null,100,"Grundstück",null,{"$f":"IF(AND(ISNUMBER(E14),ISNUMBER(E24),ISNUMBER(E28)),(E14+E24+E28),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G14),ISNUMBER(G24),ISNUMBER(G28)),(G14+G24+G28),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I29),ISNUMBER(nNFa),nNFa<>0),$I29/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I29),ISNUMBER(nBGFa),nBGFa<>0),$I29/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I29),ISNUMBER(nBRIa),nBRIa<>0),$I29/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I29),ISNUMBER(nBWKges),nBWKges<>0),I29/nBWKges*100,\"\")","v":""}]
[null,211,"Sicherungsmaßnahmen",null,0,null,0,null,0]
[null,212,"Abbruchmaßnahmen",null,0,null,0,null,0]
[null,213,"Altlastenbeseitigung",null,0,null,0,null,0]
[null,214,"Herrichten der Geländepberfläche",null,0,null,0,null,0]
[null,215,"Kampfmittelräumung",null,0,null,0,null,0]
[null,216,"Kulturhistorische Funde",null,0,null,0,null,0]
[null,219,"Sonstiges zur KG 210",null,0,null,0,null,0]
[null,210,"Herrichten",null,{"$f":"IF(COUNTIF(E30:E36,\"*\")=7,\"*\",IF(COUNTA(E30:E36)=7,SUM(E30:E36),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G30:G36,\"*\")=7,\"*\",IF(COUNTA(G30:G36)=7,SUM(G30:G36),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I37),ISNUMBER(nNFa),nNFa<>0),$I37/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I37),ISNUMBER(nBGFa),nBGFa<>0),$I37/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I37),ISNUMBER(nBRIa),nBRIa<>0),$I37/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I37),ISNUMBER(nBWKges),nBWKges<>0),I37/nBWKges*100,\"\")","v":""}]
[null,221,"Abwasserentsorgung",null,0,null,0,null,0]
[null,222,"Wasserversorgung",null,0,null,0,null,0]
[null,223,"Gasversorgung",null,0,null,0,null,0]
[null,224,"Fernwärmeversorgung",null,0,null,0,null,0]
[null,225,"Stromversorgung",null,0,null,0,null,0]
[null,226,"Telekommunikation",null,0,null,0,null,0]
[null,227,"Verkehrserschließung",null,0,null,0,null,0]
[null,228,"Abfallentsorgung",null,0,null,0,null,0]
[null,229,"Sonstiges zur KG 220",null,0,null,0,null,0]
[null,"220         Öffentliche Erschließung","Öffentliche Erschließung",null,{"$f":"IF(COUNTIF(E38:E46,\"*\")=9,\"*\",IF(COUNTA(E38:E46)=9,SUM(E38:E46),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G38:G46,\"*\")=9,\"*\",IF(COUNTA(G38:G46)=9,SUM(G38:G46),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I47),ISNUMBER(nNFa),nNFa<>0),$I47/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I47),ISNUMBER(nBGFa),nBGFa<>0),$I47/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I47),ISNUMBER(nBRIa),nBRIa<>0),$I47/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I47),ISNUMBER(nBWKges),nBWKges<>0),I47/nBWKges*100,\"\")","v":""}]
[null,230,"Nichtöffentliche Erschließung",null,0,"",0,null,0,{"$f":"IF(AND(ISNUMBER($I48),ISNUMBER(nNFa),nNFa<>0),$I48/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I48),ISNUMBER(nBGFa),nBGFa<>0),$I48/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I48),ISNUMBER(nBRIa),nBRIa<>0),$I48/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I48),ISNUMBER(nBWKges),nBWKges<>0),I48/nBWKges*100,\"\")","v":""}]
[null,241,"Ausgleichsmaßnahmen",null,0,null,0,null,0]
[null,242,"Ausgleichsabgaben",null,0,null,0,null,0]
[null,249,"Sonstiges zur KG 240",null,0,null,0,null,0]
[null,240,"Ausgleichsmaßnahmen und -abgaben",null,{"$f":"IF(COUNTIF(E49:E51,\"*\")=3,\"*\",IF(COUNTA(E49:E51)=3,SUM(E49:E51),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G49:G51,\"*\")=3,\"*\",IF(COUNTA(G49:G51)=3,SUM(G49:G51),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I52),ISNUMBER(nNFa),nNFa<>0),$I52/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I52),ISNUMBER(nBGFa),nBGFa<>0),$I52/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I52),ISNUMBER(nBRIa),nBRIa<>0),$I52/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I52),ISNUMBER(nBWKges),nBWKges<>0),I52/nBWKges*100,\"\")","v":""}]
[null,251,"Bauliche Maßnahmen",null,0,null,0,null,0]
[null,252,"Organisatorische Maßnahmen",null,0,null,0,null,0]
[null,259,"Sonstiges zur KG 250",null,0,null,0,null,0]
[null,250,"Übergangsmaßnahmen",null,{"$f":"IF(COUNTIF(E53:E55,\"*\")=3,\"*\",IF(COUNTA(E53:E55)=3,SUM(E53:E55),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G53:G55,\"*\")=3,\"*\",IF(COUNTA(G53:G55)=3,SUM(G53:G55),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I56),ISNUMBER(nNFa),nNFa<>0),$I56/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I56),ISNUMBER(nBGFa),nBGFa<>0),$I56/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I56),ISNUMBER(nBRIa),nBRIa<>0),$I56/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I56),ISNUMBER(nBWKges),nBWKges<>0),I56/nBWKges*100,\"\")","v":""}]
[null,200,"Vorbereitende Maßnahmen",null,{"$f":"IF(AND(ISNUMBER(E37),ISNUMBER(E47),ISNUMBER(E48),ISNUMBER(E52),ISNUMBER(E56)),(E37+E47+E48+E52+E56),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G37),ISNUMBER(G47),ISNUMBER(G48),ISNUMBER(G52),ISNUMBER(G56)),(G37+G47+G48+G52+G56),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I57),ISNUMBER(nNFa),nNFa<>0),$I57/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I57),ISNUMBER(nBGFa),nBGFa<>0),$I57/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I57),ISNUMBER(nBRIa),nBRIa<>0),$I57/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I57),ISNUMBER(nBWKges),nBWKges<>0),I57/nBWKges*100,\"\")","v":""}]
[null,311,"Herstellung",null,0,null,0,null,0]
[null,312,"Umschließung",null,0,null,0,null,0]
[null,313,"Wasserhaltung",null,0,null,0,null,0]
[null,314,"Vortrieb",null,0,null,0,null,0]
[null,319,"Sonstiges zur KG 310",null,0,null,0,null,0]
[null,310,"Baugrube / Erdbau",null,{"$f":"IF(COUNTIF(E58:E62,\"*\")=5,\"*\",IF(COUNTA(E58:E62)=5,SUM(E58:E62),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G58:G62,\"*\")=5,\"*\",IF(COUNTA(G58:G62)=5,SUM(G58:G62),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I63),ISNUMBER(nNFa),nNFa<>0),$I63/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I63),ISNUMBER(nBGFa),nBGFa<>0),$I63/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I63),ISNUMBER(nBRIa),nBRIa<>0),$I63/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I63),ISNUMBER(nBWKges),nBWKges<>0),I63/nBWKges*100,\"\")","v":""}]
[null,321,"Baugrundverbesserung",null,0,null,0,null,0]
[null,322,"Flachgründungen und Bodenplatten",null,0,null,0,null,0]
[null,323,"Tiefgründungen",null,0,null,0,null,0]
[null,324,"Gründungsbeläge",null,0,null,0,null,0]
[null,325,"Abdichtungen und Bekleidunge",null,0,null,0,null,0]
[null,326,"Dränagen",null,0,null,0,null,0]
[null,329,"Sonstiges zur KG 320",null,0,null,0,null,0]
[null,320,"Gründung, Unterbau",null,{"$f":"IF(COUNTIF(E64:E70,\"*\")=7,\"*\",IF(COUNTA(E64:E70)=7,SUM(E64:E70),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G64:G70,\"*\")=7,\"*\",IF(COUNTA(G64:G70)=7,SUM(G64:G70),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I71),ISNUMBER(nNFa),nNFa<>0),$I71/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I71),ISNUMBER(nBGFa),nBGFa<>0),$I71/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I71),ISNUMBER(nBRIa),nBRIa<>0),$I71/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I71),ISNUMBER(nBWKges),nBWKges<>0),I71/nBWKges*100,\"\")","v":""}]
[null,331,"Tragende Außenwände",null,0,null,0,null,0]
[null,332,"Nichttragende Außenwände",null,0,null,0,null,0]
[null,333,"Außenstützen",null,0,null,0,null,0]
[null,334,"Außenwandöffnungen",null,0,null,0,null,0]
[null,335,"Außenwandbekleidungen, außen",null,0,null,0,null,0]
[null,336,"Außenwandbekleidungen, innen",null,0,null,0,null,0]
[null,337,"Elementierte Außenwandkonstruktionen",null,0,null,0,null,0]
[null,338,"Lichtschutz zur KG 330",null,0,null,0,null,0]
[null,339,"Sonstiges zur KG 330",null,0,null,0,null,{"$f":"E80+G80","v":0}]
[null,330,"Außenwände / Vertikale\nBaukonstruktionen, außen",null,{"$f":"IF(COUNTIF(E72:E80,\"*\")=9,\"*\",IF(COUNTA(E72:E80)=9,SUM(E72:E80),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G72:G80,\"*\")=9,\"*\",IF(COUNTA(G72:G80)=9,SUM(G72:G80),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I81),ISNUMBER(nNFa),nNFa<>0),$I81/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I81),ISNUMBER(nBGFa),nBGFa<>0),$I81/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I81),ISNUMBER(nBRIa),nBRIa<>0),$I81/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I81),ISNUMBER(nBWKges),nBWKges<>0),I81/nBWKges*100,\"\")","v":""}]
[null,341,"Tragende Innenwände",null,0,null,0,null,0]
[null,342,"Nichttragende Innenwände",null,0,null,0,null,0]
[null,343,"Innenstützen",null,0,null,0,null,0]
[null,344,"Innenwandöffnungen",null,0,null,0,null,0]
[null,345,"Innenwandbekleidunge",null,0,null,0,null,0]
[null,346,"Elementierte Innenwandkonstruktionen",null,0,null,0,null,0]
[null,347,"Lichtschutz zur KG 340",null,0,null,0,null,0]
[null,349,"Sonstiges zur KG 340",null,0,null,0,null,0]
[null,340,"Innenwände / Vertikale\nBaukonstruktionen, innen",null,{"$f":"IF(COUNTIF(E82:E89,\"*\")=9,\"*\",IF(COUNTA(E82:E89)=8,SUM(E82:E89),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G82:G89,\"*\")=9,\"*\",IF(COUNTA(G82:G89)=8,SUM(G82:G89),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I90),ISNUMBER(nNFa),nNFa<>0),$I90/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I90),ISNUMBER(nBGFa),nBGFa<>0),$I90/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I90),ISNUMBER(nBRIa),nBRIa<>0),$I90/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I90),ISNUMBER(nBWKges),nBWKges<>0),I90/nBWKges*100,\"\")","v":""}]
[null,351,"Deckenkonstruktionen",null,0,null,0,null,0]
[null,352,"Deckenöffnungen",null,0,null,0,null,0]
[null,353,"Deckenbeläge",null,0,null,0,null,0]
[null,354,"Deckenbekleidungen",null,0,null,0,null,0]
[null,355,"Elementierte Deckenkonstruktionen",null,0,null,0,null,0]
[null,359,"Sonstiges zur KG 350",null,0,null,0,null,0]
[null,350,"Decken / Horizontale\nBaukonstruktionen",null,{"$f":"IF(COUNTIF(E91:E96,\"*\")=6,\"*\",IF(COUNTA(E91:E96)=6,SUM(E91:E96),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G91:G96,\"*\")=6,\"*\",IF(COUNTA(G91:G96)=6,SUM(G91:G96),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I97),ISNUMBER(nNFa),nNFa<>0),$I97/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I97),ISNUMBER(nBGFa),nBGFa<>0),$I97/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I97),ISNUMBER(nBRIa),nBRIa<>0),$I97/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I97),ISNUMBER(nBWKges),nBWKges<>0),I97/nBWKges*100,\"\")","v":""}]
[null,361,"Dachkonstruktionen",null,0,null,0,null,0]
[null,362,"Dachöffnungen",null,0,null,0,null,0]
[null,363,"Dachbeläge",null,0,null,0,null,0]
[null,364,"Dachbekleidungen",null,0,null,0,null,0]
[null,365,"Elementierte Dachkonstruktionen",null,0,null,0,null,0]
[null,366,"Lichtschutz zu KG 360",null,0,null,0,null,0]
[null,369,"Sonstiges zur KG 360",null,0,null,0,null,0]
[null,360,"Dächer",null,{"$f":"IF(COUNTIF(E98:E104,\"*\")=7,\"*\",IF(COUNTA(E98:E104)=7,SUM(E98:E104),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G98:G104,\"*\")=7,\"*\",IF(COUNTA(G98:G104)=7,SUM(G98:G104),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I105),ISNUMBER(nNFa),nNFa<>0),$I105/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I105),ISNUMBER(nBGFa),nBGFa<>0),$I105/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I105),ISNUMBER(nBRIa),nBRIa<>0),$I105/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I105),ISNUMBER(nBWKges),nBWKges<>0),I105/nBWKges*100,\"\")","v":""}]
[null,371,"Anlagen für den Straßenverkehr",null,0,null,0,null,0]
[null,372,"Anlagen für den Schienenverkehr",null,0,null,0,null,0]
[null,373,"Anlagen für den Flugverkehr",null,0,null,0,null,0]
[null,374,"Anlagen des Wasserbaus",null,0,null,0,null,0]
[null,375,"Anlagen der Abwasserentsorgung",null,0,null,0,null,0]
[null,376,"Anlagen der Wasserversorgung",null,0,null,0,null,0]
[null,377,"Anl. der Energie- u.\nInformationsversorgung",null,0,null,0,null,0]
[null,378,"Anlagen der Abfallentsorgung",null,0,null,0,null,0]
[null,379,"Sonstiges zur KG 370",null,0,null,0,null,0]
[null,370,"Infrastrukturanlagen",null,{"$f":"IF(COUNTIF(E106:E114,\"*\")=9,\"*\",IF(COUNTA(E106:E114)=9,SUM(E106:E114),\"\"))","v":0},null,{"$f":"IF(COUNTIF(G106:G114,\"*\")=9,\"*\",IF(COUNTA(G106:G114)=9,SUM(G106:G114),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I115),ISNUMBER(nNFa),nNFa<>0),$I115/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I115),ISNUMBER(nBGFa),nBGFa<>0),$I115/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I115),ISNUMBER(nBRIa),nBRIa<>0),$I115/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I115),ISNUMBER(nBWKges),nBWKges<>0),I115/nBWKges*100,\"\")","v":""}]
[null,381,"Allgemeine Einbauten",null,0,null,0,null,0]
[null,382,"Besondere Einbauten",null,0,null,0,null,0]
[null,383,"Landschaftsgestalterische Einbauten",null,0,null,0,null,0]
[null,384,"Mechanische Einbauten",null,0,null,0,null,0]
[null,385,"Einbauten in Konstruktionen des Ingenieurbaus",null,0,null,0,null,0]
[null,386,"Orientierungs- und Informationssysteme \n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektr. Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,0,null,0,null,0]
[null,387,"Schutzeinbauten",null,0,null,0,null,0]
[null,389,"Sonstiges zur KG 380",null,0,null,0,null,0]
[null,380,"Baukonstruktive Einbauten\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektr. Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(COUNTIF(E116:E123,\"*\")=8,\"*\",IF(COUNTA(E116:E123)=8,SUM(E116:E123),\"\"))","v":0},null,{"$f":"IF(COUNTIF(G116:G123,\"*\")=8,\"*\",IF(COUNTA(G116:G123)=8,SUM(G116:G123),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I124),ISNUMBER(nNFa),nNFa<>0),$I124/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I124),ISNUMBER(nBGFa),nBGFa<>0),$I124/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I124),ISNUMBER(nBRIa),nBRIa<>0),$I124/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I124),ISNUMBER(nBWKges),nBWKges<>0),I124/nBWKges*100,\"\")","v":""}]
[null,391,"Baustelleneinrichtung",null,0,null,0,null,0]
[null,392,"Gerüste",null,0,null,0,null,0]
[null,393,"Sicherungsmaßnahmen",null,0,null,0,null,0]
[null,394,"Abbruchmaßnahmen",null,0,null,0,null,0]
[null,395,"Instandsetzungen",null,0,null,0,null,0]
[null,396,"Materialentsorgung",null,0,null,0,null,0]
[null,397,"Zusätzliche Maßnahmen",null,0,null,0,null,0]
[null,398,"Provisorische Baukonstruktionen",null,0,null,0,null,0]
[null,399,"Sonstiges zur KG 390",null,0,null,0,null,0]
[null,390,"Sonstige Maßnahmen für Baukonstruktionen",null,{"$f":"IF(COUNTIF(E125:E133,\"*\")=9,\"*\",IF(COUNTA(E125:E133)=9,SUM(E125:E133),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G125:G133,\"*\")=9,\"*\",IF(COUNTA(G125:G133)=9,SUM(G125:G133),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I134),ISNUMBER(nNFa),nNFa<>0),$I134/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I134),ISNUMBER(nBGFa),nBGFa<>0),$I134/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I134),ISNUMBER(nBRIa),nBRIa<>0),$I134/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I134),ISNUMBER(nBWKges),nBWKges<>0),I134/nBWKges*100,\"\")","v":""}]
[null,300,"Bauwerk - Baukonstruktionen\n(incl. Schilder, Wegweiser, Informations- u. Werbetafeln; \nelektr. Schilder, Wegweiser, Informations- u. Werbetafeln in KG 451)",null,{"$f":"IF(AND(ISNUMBER(E63),ISNUMBER(E71),ISNUMBER(E81),ISNUMBER(E90),ISNUMBER(E97),ISNUMBER(E105),ISNUMBER(E115),ISNUMBER(E124),ISNUMBER(E134)),(E63+E71+E81+E90+E97+E105+E115+E124+E134),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G63),ISNUMBER(G71),ISNUMBER(G81),ISNUMBER(G90),ISNUMBER(G97),ISNUMBER(G105),ISNUMBER(G115),ISNUMBER(G124),ISNUMBER(G134)),(G63+G71+G81+G90+G97+G105+G115+G124+G134),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I135),ISNUMBER(nNFa),nNFa<>0),$I135/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I135),ISNUMBER(nBGFa),nBGFa<>0),$I135/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I135),ISNUMBER(nBRIa),nBRIa<>0),$I135/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I135),ISNUMBER(nBWKges),nBWKges<>0),I135/nBWKges*100,\"\")","v":""}]
[null,411,"Abwasseranlagen",null,0,null,0,null,0]
[null,412,"Wasseranlagen",null,0,null,0,null,0]
[null,413,"Gasanlagen",null,0,null,0,null,0]
[null,419,"Sonstiges zur KG 410",null,0,null,0,null,0]
[null,410,"Abwasser-, Wasser-, Gasanlagen",null,{"$f":"IF(COUNTIF(E136:E139,\"*\")=4,\"*\",IF(COUNTA(E136:E139)=4,SUM(E136:E139),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G136:G139,\"*\")=4,\"*\",IF(COUNTA(G136:G139)=4,SUM(G136:G139),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I140),ISNUMBER(nNFa),nNFa<>0),$I140/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I140),ISNUMBER(nBGFa),nBGFa<>0),$I140/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I140),ISNUMBER(nBRIa),nBRIa<>0),$I140/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I140),ISNUMBER(nBWKges),nBWKges<>0),I140/nBWKges*100,\"\")","v":""}]
[null,421,"Wärmeerzeugungsanlagen",null,0,null,0,null,0]
[null,422,"Wärmeverteilnetze",null,0,null,0,null,0]
[null,423,"Raumheizflächen",null,0,null,0,null,0]
[null,424,"Verkehrsheizflächen",null,0,null,0,null,{"$f":"E144+G144","v":0}]
[null,429,"Sonstiges zur KG 420",null,0,null,0,null,0]
[null,420,"Wärmeversorgungsanlagen",null,{"$f":"IF(COUNTIF(E141:E145,\"*\")=5,\"*\",IF(COUNTA(E141:E145)=5,SUM(E141:E145),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G141:G145,\"*\")=5,\"*\",IF(COUNTA(G141:G145)=5,SUM(G141:G145),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I146),ISNUMBER(nNFa),nNFa<>0),$I146/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I146),ISNUMBER(nBGFa),nBGFa<>0),$I146/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I146),ISNUMBER(nBRIa),nBRIa<>0),$I146/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I146),ISNUMBER(nBWKges),nBWKges<>0),I146/nBWKges*100,\"\")","v":""}]
[null,431,"Lüftungsanlagen",null,0,null,0,null,0]
[null,432,"Teilklimaanlagen",null,0,null,0,null,0]
[null,433,"Klimaanlagen   ",null,0,null,0,null,0]
[null,434,"Kälteanlagen   ",null,0,null,0,null,0]
[null,439,"Sonstiges zur KG 430",null,0,null,0,null,0]
[null,430,"Lufttechnische Anlagen",null,{"$f":"IF(COUNTIF(E147:E151,\"*\")=5,\"*\",IF(COUNTA(E147:E151)=5,SUM(E147:E151),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G147:G151,\"*\")=5,\"*\",IF(COUNTA(G147:G151)=5,SUM(G147:G151),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I152),ISNUMBER(nNFa),nNFa<>0),$I152/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I152),ISNUMBER(nBGFa),nBGFa<>0),$I152/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I152),ISNUMBER(nBRIa),nBRIa<>0),$I152/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I152),ISNUMBER(nBWKges),nBWKges<>0),I152/nBWKges*100,\"\")","v":""}]
[null,441,"Hoch- und Mittelspannungsanlagen",null,0,null,0,null,0]
[null,442,"Eigenstromversorgungsanlagen",null,0,null,0,null,0]
[null,443,"Niederspannungsschaltanlagen",null,0,null,0,null,0]
[null,444,"Niederspannungsinstallationsanlage",null,0,null,0,null,0]
[null,445,"Beleuchtungsanlagen",null,0,null,0,null,0]
[null,446,"Blitzschutz- und Erdungsanlagen",null,0,null,0,null,0]
[null,447,"Fahrleitungssysteme",null,0,null,0,null,0]
[null,449,"Sonstiges zur KG 440",null,0,null,0,null,0]
[null,440,"Elektrische Anlagen",null,{"$f":"IF(COUNTIF(E153:E160,\"*\")=8,\"*\",IF(COUNTA(E153:E160)=8,SUM(E153:E160),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G153:G160,\"*\")=8,\"*\",IF(COUNTA(G153:G160)=8,SUM(G153:G160),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I161),ISNUMBER(nNFa),nNFa<>0),$I161/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I161),ISNUMBER(nBGFa),nBGFa<>0),$I161/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I161),ISNUMBER(nBRIa),nBRIa<>0),$I161/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I161),ISNUMBER(nBWKges),nBWKges<>0),I161/nBWKges*100,\"\")","v":""}]
[null,451,"Telekommunikationsanlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,0,null,0,null,0]
[null,452,"Such- und Signalanlagen",null,0,null,0,null,0]
[null,453,"Zeitdienstanlagen",null,0,null,0,null,0]
[null,454,"Elektroakustische Anlagen",null,0,null,0,null,0]
[null,455,"Audiovisuelle Medien- und Antennenanlagen",null,0,null,0,null,0]
[null,456,"Antennenanlagen",null,0,null,0,null,0]
[null,457,"Datenübertragungsnetze",null,0,null,0,null,0]
[null,458,"Verkehrsbeeinflussungsanlagen",null,0,null,0,null,0]
[null,459,"Sonstiges zur KG 450",null,0,null,0,null,0]
[null,450,"Kommunikations-, sicherheits- u. informationstechnische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(COUNTIF(E162:E170,\"*\")=9,\"*\",IF(COUNTA(E162:E170)=9,SUM(E162:E170),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G162:G170,\"*\")=9,\"*\",IF(COUNTA(G162:G170)=9,SUM(G162:G170),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I171),ISNUMBER(nNFa),nNFa<>0),$I171/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I171),ISNUMBER(nBGFa),nBGFa<>0),$I171/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I171),ISNUMBER(nBRIa),nBRIa<>0),$I171/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I171),ISNUMBER(nBWKges),nBWKges<>0),I171/nBWKges*100,\"\")","v":""}]
[null,461,"Aufzugsanlagen",null,0,null,0,null,0]
[null,462,"Fahrtreppen, Fahrsteige",null,0,null,0,null,0]
[null,463,"Befahranlagen",null,0,null,0,null,0]
[null,464,"Transportanlagen",null,0,null,0,null,0]
[null,465,"Krananlagen",null,0,null,0,null,0]
[null,466,"Hydraulikanlagen",null,0,null,0,null,0]
[null,469,"Sonstiges zur KG 460",null,0,null,0,null,0]
[null,460,"Förderanlagen",null,{"$f":"IF(COUNTIF(E172:E178,\"*\")=7,\"*\",IF(COUNTA(E172:E178)=7,SUM(E172:E178),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G172:G178,\"*\")=7,\"*\",IF(COUNTA(G172:G178)=7,SUM(G172:G178),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I179),ISNUMBER(nNFa),nNFa<>0),$I179/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I179),ISNUMBER(nBGFa),nBGFa<>0),$I179/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I179),ISNUMBER(nBRIa),nBRIa<>0),$I179/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I179),ISNUMBER(nBWKges),nBWKges<>0),I179/nBWKges*100,\"\")","v":""}]
[null,471,"Küchentechnische Anlagen",null,0,null,0,null,0]
[null,472,"Wäscherei-, Reinigungs- und badetechnische Anlagen",null,0,null,0,null,0]
[null,473,"Medienversorgungsanlagen, Medizin- und labortechnische Anlagen",null,0,null,0,null,0]
[null,474,"Feuerlöschanlagen",null,0,null,0,null,0]
[null,475,"Prozesswärme-, kälte- und -luftanlagen",null,0,null,0,null,0]
[null,476,"Weitere nutzungsspezifische Anlagen",null,0,null,0,null,0]
[null,477,"Verfahrenstechnische Anlagen,\nWasser, Abwasser und Gase",null,0,null,0,null,0]
[null,478,"Verfahrenstechnische Anlagen, Feststoffe, Wertstoffe und Abfälle",null,0,null,0,null,0]
[null,479,"Sonstiges zur KG 470",null,0,null,0,null,0]
[null,470,"Nutzungsspezifische und\nverfahrenstechniche Anlagen",null,{"$f":"IF(COUNTIF(E180:E188,\"*\")=9,\"*\",IF(COUNTA(E180:E188)=9,SUM(E180:E188),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G180:G188,\"*\")=9,\"*\",IF(COUNTA(G180:G188)=9,SUM(G180:G188),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I189),ISNUMBER(nNFa),nNFa<>0),$I189/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I189),ISNUMBER(nBGFa),nBGFa<>0),$I189/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I189),ISNUMBER(nBRIa),nBRIa<>0),$I189/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I189),ISNUMBER(nBWKges),nBWKges<>0),I189/nBWKges*100,\"\")","v":""}]
[null,481,"Automationseinrichtungen",null,0,null,0,null,0]
[null,482,"Schaltschränke, Automationsschwerpunkte",null,0,null,0,null,0]
[null,483,"Automationsmanagement",null,0,null,0,null,0]
[null,484,"Kabel, Leitungen und\nVerlegesysteme",null,0,null,0,null,0]
[null,485,"Datenübertragungsnetze",null,0,null,0,null,0]
[null,489,"Sonstiges zur KG 480",null,0,null,0,null,0]
[null,480,"Gebäudeautomation",null,{"$f":"IF(COUNTIF(E190:E195,\"*\")=6,\"*\",IF(COUNTA(E190:E195)=6,SUM(E190:E195),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G190:G195,\"*\")=6,\"*\",IF(COUNTA(G190:G195)=6,SUM(G190:G195),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I196),ISNUMBER(nNFa),nNFa<>0),$I196/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I196),ISNUMBER(nBGFa),nBGFa<>0),$I196/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I196),ISNUMBER(nBRIa),nBRIa<>0),$I196/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I196),ISNUMBER(nBWKges),nBWKges<>0),I196/nBWKges*100,\"\")","v":""}]
[null,491,"Baustelleneinrichtung",null,0,null,0,null,0]
[null,492,"Gerüste",null,0,null,0,null,0]
[null,493,"Sicherungsmaßnahmen",null,0,null,0,null,0]
[null,494,"Abbruchmaßnahmen",null,0,null,0,null,0]
[null,495,"Instandsetzungen",null,0,null,0,null,0]
[null,496,"Materialentsorgung",null,0,null,0,null,0]
[null,497,"Zusätzliche Maßnahmen",null,0,null,0,null,0]
[null,498,"Provisorische technische\nAnlagen",null,0,null,0,null,0]
[null,499,"Sonstiges zur KG 490",null,0,null,0,null,0]
[null,490,"Sonst. Maßnahmen für Technische Anl.",null,{"$f":"IF(COUNTIF(E197:E205,\"*\")=9,\"*\",IF(COUNTA(E197:E205)=9,SUM(E197:E205),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G197:G205,\"*\")=9,\"*\",IF(COUNTA(G197:G205)=9,SUM(G197:G205),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I206),ISNUMBER(nNFa),nNFa<>0),$I206/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I206),ISNUMBER(nBGFa),nBGFa<>0),$I206/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I206),ISNUMBER(nBRIa),nBRIa<>0),$I206/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I206),ISNUMBER(nBWKges),nBWKges<>0),I206/nBWKges*100,\"\")","v":""}]
[null,400,"Bauwerk Technische Anlagen\n(incl. elektronische Schilder, Wegweiser, Informations- u. Werbetafeln)",null,{"$f":"IF(AND(ISNUMBER(E140),ISNUMBER(E146),ISNUMBER(E152),ISNUMBER(E161),ISNUMBER(E171),ISNUMBER(E179),ISNUMBER(E189),ISNUMBER(E196),ISNUMBER(E206)),(E140+E146+E152+E161+E171+E179+E189+E196+E206),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G140),ISNUMBER(G146),ISNUMBER(G152),ISNUMBER(G161),ISNUMBER(G171),ISNUMBER(G179),ISNUMBER(G189),ISNUMBER(G196),ISNUMBER(G206)),(G140+G146+G152+G161+G171+G179+G189+G196+G206),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I207),ISNUMBER(nNFa),nNFa<>0),$I207/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I207),ISNUMBER(nBGFa),nBGFa<>0),$I207/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I207),ISNUMBER(nBRIa),nBRIa<>0),$I207/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I207),ISNUMBER(nBWKges),nBWKges<>0),I207/nBWKges*100,\"\")","v":""}]
[null,511,"Herstellung",null,0,null,0,null,{"$f":"E208+G208","v":0}]
[null,512,"Umschließung",null,0,null,0,null,0]
[null,513,"Wasserhaltung",null,0,null,0,null,0]
[null,514,"Vortrieb",null,0,null,0,null,0]
[null,515,"Sonstiges zur KG 510",null,0,null,0,null,0]
[null,510,"Erdbau",null,{"$f":"IF(COUNTIF(E208:E212,\"*\")=5,\"*\",IF(COUNTA(E208:E212)=5,SUM(E208:E212),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G208:G212,\"*\")=5,\"*\",IF(COUNTA(G208:G212)=5,SUM(G208:G212),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I213),ISNUMBER(nNFa),nNFa<>0),$I213/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I213),ISNUMBER(nBGFa),nBGFa<>0),$I213/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I213),ISNUMBER(nBRIa),nBRIa<>0),$I213/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I213),ISNUMBER(nBWKges),nBWKges<>0),I213/nBWKges*100,\"\")","v":""}]
[null,521,"Baugrundverbesserung",null,0,null,0,null,0]
[null,522,"Gründungen und Bodenplatten",null,0,null,0,null,0]
[null,523,"Gründungsbeläge",null,0,null,0,null,0]
[null,524,"Abdichtungen und Bekleidungen",null,0,null,0,null,0]
[null,525,"Dränagen",null,0,null,0,null,0]
[null,529,"Sonstiges zur KG 520",null,0,null,0,null,0]
[null,520,"Gründung Unterbau",null,{"$f":"IF(COUNTIF(E214:E219,\"*\")=6,\"*\",IF(COUNTA(E214:E219)=6,SUM(E214:E219),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G214:G219,\"*\")=6,\"*\",IF(COUNTA(G214:G219)=6,SUM(G214:G219),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I220),ISNUMBER(nNFa),nNFa<>0),$I220/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I220),ISNUMBER(nBGFa),nBGFa<>0),$I220/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I220),ISNUMBER(nBRIa),nBRIa<>0),$I220/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I220),ISNUMBER(nBWKges),nBWKges<>0),I220/nBWKges*100,\"\")","v":""}]
[null,531,"Wege",null,0,null,0,null,0]
[null,532,"Straßen",null,0,null,0,null,0]
[null,533,"Plätze, Höfe, Terrassen",null,0,null,0,null,0]
[null,534,"Stellplätze",null,0,null,0,null,0]
[null,535,"Sportplatzflächen",null,0,null,0,null,0]
[null,536,"Spielplatzflächen",null,0,null,0,null,0]
[null,537,"Gleisanlagen",null,0,null,0,null,0]
[null,538,"Flugplatzflächen",null,0,null,0,null,0]
[null,539,"Sonstiges zur KG 530",null,0,null,0,null,0]
[null,530,"Oberbau, Deckschichten",null,{"$f":"IF(COUNTIF(E221:E229,\"*\")=9,\"*\",IF(COUNTA(E221:E229)=9,SUM(E221:E229),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G221:G229,\"*\")=9,\"*\",IF(COUNTA(G221:G229)=9,SUM(G221:G229),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I230),ISNUMBER(nNFa),nNFa<>0),$I230/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I230),ISNUMBER(nBGFa),nBGFa<>0),$I230/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I230),ISNUMBER(nBRIa),nBRIa<>0),$I230/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I230),ISNUMBER(nBWKges),nBWKges<>0),I230/nBWKges*100,\"\")","v":""}]
[null,541,"Einfriedungen",null,0,null,0,null,0]
[null,542,"Schutzkonstruktionen",null,0,null,0,null,0]
[null,543,"Wandkonstruktionen",null,0,null,0,null,0]
[null,544,"Rampen, Treppen, Tribünen",null,0,null,0,null,0]
[null,545,"Überdachungen",null,0,null,0,null,0]
[null,546,"Stege",null,0,null,0,null,0]
[null,547,"Kanal- und\nSchachtkonstruktionen",null,0,null,0,null,0]
[null,548,"Wasserbecken",null,0,null,0,null,0]
[null,549,"Sonstiges zur KG 540",null,0,null,0,null,0]
[null,540,"Baukonstruktionen",null,{"$f":"IF(COUNTIF(E231:E239,\"*\")=9,\"*\",IF(COUNTA(E231:E239)=9,SUM(E231:E239),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G231:G239,\"*\")=9,\"*\",IF(COUNTA(G231:G239)=9,SUM(G231:G239),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I240),ISNUMBER(nNFa),nNFa<>0),$I240/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I240),ISNUMBER(nBGFa),nBGFa<>0),$I240/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I240),ISNUMBER(nBRIa),nBRIa<>0),$I240/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I240),ISNUMBER(nBWKges),nBWKges<>0),I240/nBWKges*100,\"\")","v":""}]
[null,551,"Abwasseranlagen",null,0,null,0,null,0]
[null,552,"Wasseranlagen",null,0,null,0,null,0]
[null,553,"Anlagen für Gase und\nFlüssigkeiten",null,0,null,0,null,0]
[null,554,"Wärmeversorgungsanlagen",null,0,null,0,null,0]
[null,555,"Raumlufttechnische Anlagen",null,0,null,0,null,0]
[null,556,"Elektrische Anlagen",null,0,null,0,null,0]
[null,557,"Kommunikations-, sicherheitsund\ninformationstechnische\nAnlagen, Automation",null,0,null,0,null,0]
[null,558,"Nutzungsspezifische Anlagen",null,0,null,0,null,0]
[null,559,"Sonstiges zur KG 550",null,0,null,0,null,0]
[null,550,"Technische Anlagen",null,{"$f":"IF(COUNTIF(E241:E249,\"*\")=9,\"*\",IF(COUNTA(E241:E249)=9,SUM(E241:E249),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G241:G249,\"*\")=9,\"*\",IF(COUNTA(G241:G249)=9,SUM(G241:G249),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I250),ISNUMBER(nNFa),nNFa<>0),$I250/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I250),ISNUMBER(nBGFa),nBGFa<>0),$I250/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I250),ISNUMBER(nBRIa),nBRIa<>0),$I250/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I250),ISNUMBER(nBWKges),nBWKges<>0),I250/nBWKges*100,\"\")","v":""}]
[null,561,"Allgemeine Einbauten",null,0,null,0,null,0]
[null,562,"Besondere Einbauten",null,0,null,0,null,0]
[null,563,"Orientierungs- und\nInformationssysteme",null,0,null,0,null,0]
[null,569,"Sonstiges zur KG 560",null,0,null,0,null,0]
[null,560,"Einbauten in Außenanlagen\nund Freiflächen",null,{"$f":"IF(COUNTIF(E251:E254,\"*\")=4,\"*\",IF(COUNTA(E251:E254)=4,SUM(E251:E254),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G251:G254,\"*\")=4,\"*\",IF(COUNTA(G251:G254)=4,SUM(G251:G254),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I255),ISNUMBER(nNFa),nNFa<>0),$I255/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I255),ISNUMBER(nBGFa),nBGFa<>0),$I255/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I255),ISNUMBER(nBRIa),nBRIa<>0),$I255/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I255),ISNUMBER(nBWKges),nBWKges<>0),I255/nBWKges*100,\"\")","v":""}]
[null,571,"Vegetationstechnische\nBodenbearbeitung",null,0,null,0,null,0]
[null,572,"Sicherungsbauweisen",null,0,null,0,null,0]
[null,573,"Pflanzflächen",null,0,null,0,null,0]
[null,574,"Rasen- und Saatflächen",null,0,null,0,null,0]
[null,579,"Sonstiges zur KG 570",null,0,null,0,null,0]
[null,570,"Vegetationsflächen",null,{"$f":"IF(COUNTIF(E256:E260,\"*\")=5,\"*\",IF(COUNTA(E256:E260)=5,SUM(E256:E260),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G256:G260,\"*\")=5,\"*\",IF(COUNTA(G256:G260)=5,SUM(G256:G260),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I261),ISNUMBER(nNFa),nNFa<>0),$I261/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I261),ISNUMBER(nBGFa),nBGFa<>0),$I261/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I261),ISNUMBER(nBRIa),nBRIa<>0),$I261/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I261),ISNUMBER(nBWKges),nBWKges<>0),I261/nBWKges*100,\"\")","v":""}]
[null,581,"Befestigungen",null,0,null,0,null,0]
[null,582,"Abdichtungen",null,0,null,0,null,0]
[null,583,"Bepflanzungen",null,0,null,0,null,0]
[null,589,"Sonstiges zur KG 580",null,0,null,0,null,0]
[null,580,"Wasserflächen",null,{"$f":"IF(COUNTIF(E262:E265,\"*\")=4,\"*\",IF(COUNTA(E262:E265)=4,SUM(E262:E265),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G262:G265,\"*\")=4,\"*\",IF(COUNTA(G262:G265)=4,SUM(G262:G265),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I266),ISNUMBER(nNFa),nNFa<>0),$I266/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I266),ISNUMBER(nBGFa),nBGFa<>0),$I266/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I266),ISNUMBER(nBRIa),nBRIa<>0),$I266/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I266),ISNUMBER(nBWKges),nBWKges<>0),I266/nBWKges*100,\"\")","v":""}]
[null,591,"Baustelleneinrichtung",null,0,null,0,null,0]
[null,592,"Gerüste",null,0,null,0,null,0]
[null,593,"Sicherungsmaßnahmen",null,0,null,0,null,0]
[null,594,"Abbruchmaßnahmen",null,0,null,0,null,0]
[null,595,"Instandsetzungen",null,0,null,0,null,0]
[null,596,"Materialentsorgung",null,0,null,0,null,{"$f":"E272+G272","v":0}]
[null,597,"Zusätzliche Maßnahmen",null,0,null,0,null,0]
[null,598,"Provisorische Außenanlagen und\nFreiflächen",null,0,null,0,null,0]
[null,599,"Sonstiges zur KG 590",null,0,null,0,null,0]
[null,590,"Sonst.  Maßnahmen für Außenanl. u. Freiflächen",null,{"$f":"IF(COUNTIF(E267:E275,\"*\")=9,\"*\",IF(COUNTA(E267:E275)=9,SUM(E267:E275),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G267:G275,\"*\")=9,\"*\",IF(COUNTA(G267:G275)=9,SUM(G267:G275),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I276),ISNUMBER(nNFa),nNFa<>0),$I276/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I276),ISNUMBER(nBGFa),nBGFa<>0),$I276/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I276),ISNUMBER(nBRIa),nBRIa<>0),$I276/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I276),ISNUMBER(nBWKges),nBWKges<>0),I276/nBWKges*100,\"\")","v":""}]
[null,500,"Außenanlagen und Freiflächen",null,{"$f":"IF(AND(ISNUMBER(E213),ISNUMBER(E220),ISNUMBER(E230),ISNUMBER(E240),ISNUMBER(E250),ISNUMBER(E255),ISNUMBER(E261),ISNUMBER(E266),ISNUMBER(E276)),(E213+E220+E230+E240+E250+E255+E261+E266+E276),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G213),ISNUMBER(G220),ISNUMBER(G230),ISNUMBER(G240),ISNUMBER(G250),ISNUMBER(G255),ISNUMBER(G261),ISNUMBER(G266),ISNUMBER(G276)),(G213+G220+G230+G240+G250+G255+G261+G266+G276),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I277),ISNUMBER(nNFa),nNFa<>0),$I277/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I277),ISNUMBER(nBGFa),nBGFa<>0),$I277/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I277),ISNUMBER(nBRIa),nBRIa<>0),$I277/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I277),ISNUMBER(nBWKges),nBWKges<>0),I277/nBWKges*100,\"\")","v":""}]
[null,610,"Allgemeine Ausstattung (nachrichtlich)",null,0,"",0,null,0,{"$f":"IF(AND(ISNUMBER($I278),ISNUMBER(nNFa),nNFa<>0),$I278/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I278),ISNUMBER(nBGFa),nBGFa<>0),$I278/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I278),ISNUMBER(nBRIa),nBRIa<>0),$I278/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I278),ISNUMBER(nBWKges),nBWKges<>0),I278/nBWKges*100,\"\")","v":""}]
[null,620,"Besondere Ausstattung (nachrichtlich)",null,0,"",0,null,0,{"$f":"IF(AND(ISNUMBER($I279),ISNUMBER(nNFa),nNFa<>0),$I279/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I279),ISNUMBER(nBGFa),nBGFa<>0),$I279/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I279),ISNUMBER(nBRIa),nBRIa<>0),$I279/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I279),ISNUMBER(nBWKges),nBWKges<>0),I279/nBWKges*100,\"\")","v":""}]
[null,630,"Informationstechnische\nAusstattung (nachrichtlich)",null,0,null,0,null,0,{"$f":"IF(AND(ISNUMBER($I280),ISNUMBER(nNFa),nNFa<>0),$I280/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I280),ISNUMBER(nBGFa),nBGFa<>0),$I280/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I280),ISNUMBER(nBRIa),nBRIa<>0),$I280/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I280),ISNUMBER(nBWKges),nBWKges<>0),I280/nBWKges*100,\"\")","v":""}]
[null,641,"Kunstobjekte",null,0,null,0,null,0]
[null,642,"Künstlerische Gestaltung des\nBauwerks",null,0,null,0,null,0]
[null,643,"Künstlerische Gestaltung der\nAußenanlagen und Freiflächen",null,0,null,0,null,0]
[null,649,"Sonstiges zur KG 640",null,0,null,0,null,0]
[null,640,"Künstlerische Ausstattung",null,{"$f":"IF(COUNTIF(E281:E284,\"*\")=4,\"*\",IF(COUNTA(E281:E284)=4,SUM(E281:E284),\"\"))","v":0},null,{"$f":"IF(COUNTIF(G281:G284,\"*\")=4,\"*\",IF(COUNTA(G281:G284)=4,SUM(G281:G284),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I285),ISNUMBER(nNFa),nNFa<>0),$I285/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I285),ISNUMBER(nBGFa),nBGFa<>0),$I285/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I285),ISNUMBER(nBRIa),nBRIa<>0),$I285/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I285),ISNUMBER(nBWKges),nBWKges<>0),I285/nBWKges*100,\"\")","v":""}]
[null,690,"Sonstige Ausstattung \n(Zuordnung Schilder, Wegweiser, Informations- u. Werbetafeln,\nzu KG 386 u. KG 451)",null,0,null,0,null,0,{"$f":"IF(AND(ISNUMBER($I286),ISNUMBER(nNFa),nNFa<>0),$I286/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I286),ISNUMBER(nBGFa),nBGFa<>0),$I286/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I286),ISNUMBER(nBRIa),nBRIa<>0),$I286/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I286),ISNUMBER(nBWKges),nBWKges<>0),I286/nBWKges*100,\"\")","v":""}]
[null,600,"Ausstattung und Kunstwerke\n(ohne KG 610, 620, 630)",null,{"$f":"IF(AND(ISNUMBER(E285)),(E285),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G285)),(G285),\"\")","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I287),ISNUMBER(nNFa),nNFa<>0),$I287/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I287),ISNUMBER(nBGFa),nBGFa<>0),$I287/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I287),ISNUMBER(nBRIa),nBRIa<>0),$I287/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I287),ISNUMBER(nBWKges),nBWKges<>0),I287/nBWKges*100,\"\")","v":""}]
[null,711,"Projektleitung (bei EP 18 ab 2020, nachrichtlich)",null,0,null,0,null,0,{"$f":"IF(AND(ISNUMBER($I288),ISNUMBER(nNFa),nNFa<>0),$I288/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I288),ISNUMBER(nBGFa),nBGFa<>0),$I288/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I288),ISNUMBER(nBRIa),nBRIa<>0),$I288/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I288),ISNUMBER(nBWKges),nBWKges<>0),I288/nBWKges*100,\"\")","v":""}]
[null,711,"Projektleitung (bei Maßnahmen außerhalb des EP18 und Altmaßnahmen EP18, Anteil der KG 711  bis 31.01.2019)",null,0,null,0,null,0]
[null,712,"Bedarfsplanung",null,0,null,0,null,0]
[null,713,"Projektsteuerung",null,0,null,0,null,0]
[null,714,"Sicherheits- und\nGesundheitsschutzkoordination",null,0,null,0,null,0]
[null,715,"Vergabeverfahren",null,0,null,0,null,0]
[null,719,"Sonstiges zur KG 710",null,0,null,0,null,0]
[null,710,"Bauherrenaufgaben",null,{"$f":"IF(COUNTIF(E289:E294,\"*\")=6,\"*\",IF(COUNTA(E289:E294)=6,SUM(E289:E294),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G289:G294,\"*\")=6,\"*\",IF(COUNTA(G289:G294)=6,SUM(G289:G294),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I295),ISNUMBER(nNFa),nNFa<>0),$I295/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I295),ISNUMBER(nBGFa),nBGFa<>0),$I295/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I295),ISNUMBER(nBRIa),nBRIa<>0),$I295/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I295),ISNUMBER(nBWKges),nBWKges<>0),I295/nBWKges*100,\"\")","v":""}]
[null,721,"Untersuchungen",null,0,null,0,null,0]
[null,722,"Wertermittlungen",null,0,null,0,null,0]
[null,723,"Städtebauliche Leistungen",null,0,null,0,null,0]
[null,724,"Landschaftsplanerische\nLeistungen",null,0,null,0,null,0]
[null,725,"Wettbewerbe",null,0,null,0,null,0]
[null,729,"Sonstiges zur KG 720",null,0,null,0,null,0]
[null,720,"Vorbereitung der Objektplanung",null,{"$f":"IF(COUNTIF(E296:E301,\"*\")=6,\"*\",IF(COUNTA(E296:E301)=6,SUM(E296:E301),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G296:G301,\"*\")=6,\"*\",IF(COUNTA(G296:G301)=6,SUM(G296:G301),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I302),ISNUMBER(nNFa),nNFa<>0),$I302/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I302),ISNUMBER(nBGFa),nBGFa<>0),$I302/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I302),ISNUMBER(nBRIa),nBRIa<>0),$I302/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I302),ISNUMBER(nBWKges),nBWKges<>0),I302/nBWKges*100,\"\")","v":""}]
[null,731,"Gebäude und Innenräume",null,0,null,0,null,0]
[null,732,"Freianlagen",null,0,null,0,null,0]
[null,733,"Ingenieurbauwerke",null,0,null,0,null,0]
[null,734,"Verkehrsanlagen",null,0,null,0,null,0]
[null,739,"Sonstiges zur KG 730",null,0,null,0,null,0]
[null,730,"Objektplanung",null,{"$f":"IF(COUNTIF(E303:E307,\"*\")=5,\"*\",IF(COUNTA(E303:E307)=5,SUM(E303:E307),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G303:G307,\"*\")=5,\"*\",IF(COUNTA(G303:G307)=5,SUM(G303:G307),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I308),ISNUMBER(nNFa),nNFa<>0),$I308/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I308),ISNUMBER(nBGFa),nBGFa<>0),$I308/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I308),ISNUMBER(nBRIa),nBRIa<>0),$I308/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I308),ISNUMBER(nBWKges),nBWKges<>0),I308/nBWKges*100,\"\")","v":""}]
[null,741,"Tragwerksplanung",null,0,null,0,null,0]
[null,742,"Technische Ausrüstung",null,0,null,0,null,0]
[null,743,"Bauphysik",null,0,null,0,null,0]
[null,744,"Geotechnik",null,0,null,0,null,0]
[null,745,"Ingenieurvermessung",null,0,null,0,null,0]
[null,746,"Lichttechnik, Tageslichttechnik",null,0,null,0,null,0]
[null,747,"Brandschutz",null,0,null,0,null,0]
[null,748,"Altlasten, Kampfmittel,\nkulturhistorische Funde",null,0,null,0,null,0]
[null,749,"Sonstiges zur KG 740",null,0,null,0,null,0]
[null,740,"Fachplanung",null,{"$f":"IF(COUNTIF(E309:E317,\"*\")=9,\"*\",IF(COUNTA(E309:E317)=9,SUM(E309:E317),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G309:G317,\"*\")=9,\"*\",IF(COUNTA(G309:G317)=9,SUM(G309:G317),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I318),ISNUMBER(nNFa),nNFa<>0),$I318/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I318),ISNUMBER(nBGFa),nBGFa<>0),$I318/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I318),ISNUMBER(nBRIa),nBRIa<>0),$I318/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I318),ISNUMBER(nBWKges),nBWKges<>0),I318/nBWKges*100,\"\")","v":""}]
[null,751,"Kunstwettbewerbe",null,0,null,0,null,0]
[null,752,"Honorare",null,0,null,0,null,0]
[null,759,"Sonstiges zur KG 750",null,0,null,0,null,0]
[null,750,"Künstlerische Leistungen",null,{"$f":"IF(COUNTIF(E319:E321,\"*\")=3,\"*\",IF(COUNTA(E319:E321)=3,SUM(E319:E321),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G319:G321,\"*\")=3,\"*\",IF(COUNTA(G319:G321)=3,SUM(G319:G321),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I322),ISNUMBER(nNFa),nNFa<>0),$I322/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I322),ISNUMBER(nBGFa),nBGFa<>0),$I322/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I322),ISNUMBER(nBRIa),nBRIa<>0),$I322/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I322),ISNUMBER(nBWKges),nBWKges<>0),I322/nBWKges*100,\"\")","v":""}]
[null,761,"Gutachten und Beratung",null,0,null,0,null,0]
[null,762,"Prüfungen, Genehmigungen,\nAbnahmen",null,0,null,0,null,0]
[null,763,"Bewirtschaftungskosten",null,0,null,0,null,0]
[null,764,"Bemusterungskosten",null,0,null,0,null,0]
[null,765,"Betriebskosten nach der\nAbnahme",null,0,null,0,null,0]
[null,766,"Versicherungen",null,0,null,0,null,0]
[null,769,"Sonstiges zur KG 760",null,0,null,0,null,0]
[null,760,"Allgemeine Baunebenkosten",null,{"$f":"IF(COUNTIF(E323:E329,\"*\")=7,\"*\",IF(COUNTA(E323:E329)=7,SUM(E323:E329),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G323:G329,\"*\")=7,\"*\",IF(COUNTA(G323:G329)=7,SUM(G323:G329),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I330),ISNUMBER(nNFa),nNFa<>0),$I330/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I330),ISNUMBER(nBGFa),nBGFa<>0),$I330/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I330),ISNUMBER(nBRIa),nBRIa<>0),$I330/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I330),ISNUMBER(nBWKges),nBWKges<>0),I330/nBWKges*100,\"\")","v":""}]
[null,791,"Bestandsdokumentation",null,0,null,0,null,0]
[null,799,"Sonstiges zur KG 790",null,0,null,0,null,0]
[null,790,"Sonstige Baunebenkosten",null,{"$f":"IF(COUNTIF(E331:E332,\"*\")=2,\"*\",IF(COUNTA(E331:E332)=2,SUM(E331:E332),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G331:G332,\"*\")=2,\"*\",IF(COUNTA(G331:G332)=2,SUM(G331:G332),\"\"))","v":0},null,0,{"$f":"IF(AND(ISNUMBER($I333),ISNUMBER(nNFa),nNFa<>0),$I333/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I333),ISNUMBER(nBGFa),nBGFa<>0),$I333/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I333),ISNUMBER(nBRIa),nBRIa<>0),$I333/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I333),ISNUMBER(nBWKges),nBWKges<>0),I333/nBWKges*100,\"\")","v":""}]
[null,700,"Baunebenkosten",null,{"$f":"IF(AND(ISNUMBER(E295),ISNUMBER(E302),ISNUMBER(E308),ISNUMBER(E318),ISNUMBER(E322),ISNUMBER(E330),ISNUMBER(E318),ISNUMBER(E330),ISNUMBER(E333)),(E295+E302+E308+E318+E322+E330+E333),\"\")","v":0},"",{"$f":"IF(AND(ISNUMBER(G295),ISNUMBER(G302),ISNUMBER(G308),ISNUMBER(G318),ISNUMBER(G322),ISNUMBER(G330),ISNUMBER(G318),ISNUMBER(G330),ISNUMBER(G333)),(G295+G302+G308+G318+G322+G330+G333),\"\")","v":0},null,0,"","","",""]
[null,810,"Finanzierungsnebenkosten",null,0,"",0,null,0,"","","",""]
[null,820,"Fremdkapitalzinsen",null,0,"",0,null,0,"","","",""]
[null,830,"Eigenkapitalzinsen",null,0,"",0,null,{"$f":"E337+G337","v":0},"","","",""]
[null,840,"Bürgschaften",null,0,"",0,null,0,"","","",""]
[null,890,"Sonstige Finanzierungskosten",null,0,"",0,null,0,"","","",""]
[null,800,"Finanzierung",null,{"$f":"IF(COUNTIF(E335:E339,\"*\")=5,\"*\",IF(COUNTA(E335:E339)=5,SUM(E335:E339),\"\"))","v":0},"",{"$f":"IF(COUNTIF(G335:G339,\"*\")=5,\"*\",IF(COUNTA(G335:G339)=5,SUM(G335:G339),\"\"))","v":0},null,{"$f":"E340+G340","v":0},"","","",""]
[]
[null,"GBK","Gesamtbaukosten \n(200-500, 640, 690, 700*,800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E57),ISNUMBER(E135),ISNUMBER(E207),ISNUMBER(E277),ISNUMBER(E287),ISNUMBER(E334),ISNUMBER(E340)),(E57+E135+E207+E277+E287+E334+E340),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G57),ISNUMBER(G135),ISNUMBER(G207),ISNUMBER(G277),ISNUMBER(G287),ISNUMBER(G334),ISNUMBER(G340)),(G57+G135+G207+G277+G287+G334+G340),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(I57),ISNUMBER(I135),ISNUMBER(I207),ISNUMBER(I277),ISNUMBER(I287),ISNUMBER(I334),ISNUMBER(I340)),(I57+I135+I207+I277+I287+I334+I340),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($I342),ISNUMBER(nNFa),nNFa<>0),$I342/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I342),ISNUMBER(nBGFa),nBGFa<>0),$I342/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I342),ISNUMBER(nBRIa),nBRIa<>0),$I342/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I342),ISNUMBER(nBWKges),nBWKges<>0),I342/nBWKges*100,\"\")","v":""}]
[]
[null,"GK","Gesamtkosten (100-800) ohne Aufrundung",null,{"$f":"IF(AND(ISNUMBER(E29),ISNUMBER(E57),ISNUMBER(E135),ISNUMBER(E207),ISNUMBER(E277),ISNUMBER(E278),ISNUMBER(E279),ISNUMBER(E280),ISNUMBER(E287),ISNUMBER(E288),ISNUMBER(E334),ISNUMBER(E340)),(E29+E57+E135+E207+E277+E278+E279+E280+E287+E288+E334+E340),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(G29),ISNUMBER(G57),ISNUMBER(G135),ISNUMBER(G207),ISNUMBER(G277),ISNUMBER(G278),ISNUMBER(G279),ISNUMBER(G280),ISNUMBER(G287),ISNUMBER(G288),ISNUMBER(G334),ISNUMBER(G340)),(G29+G57+G135+G207+G277+G278+G279+G280+G287+G288+G334+G340),\"\")","v":0},null,{"$f":"IF(AND(ISNUMBER(I29),ISNUMBER(I57),ISNUMBER(I135),ISNUMBER(I207),ISNUMBER(I277),ISNUMBER(I278),ISNUMBER(I279),ISNUMBER(I280),ISNUMBER(I287),ISNUMBER(I288),ISNUMBER(I334),ISNUMBER(I340)),(I29+I57+I135+I207+I277+I278+I279+I280+I287+I288+I334+I340),\"\")","v":0},{"$f":"IF(AND(ISNUMBER($I344),ISNUMBER(nNFa),nNFa<>0),$I344/nNFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I344),ISNUMBER(nBGFa),nBGFa<>0),$I344/nBGFa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER($I344),ISNUMBER(nBRIa),nBRIa<>0),$I344/nBRIa,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(I344),ISNUMBER(nBWKges),nBWKges<>0),I344/nBWKges*100,\"\")","v":""}]
[null,"* bei Baumaßnahmen im EP 18 ab 01.01.2020 ohne KG 711, ggf. mit Anteil KG 711, der bis 31.12.2019 erlöst wurde;\n* bei Baumaßnahmen außerhalb des EP 18 inkl. KG 711"]