{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Projektdaten","Zusammenstellung Flächen","Flächen SIA 416 Detail","Anlagekosten","Gebäudekosten"],"not_rendered":{"images":9,"external_links":1,"defined_names":60},"read":"whole","date_system":"1900"}

{"sheet":"Projektdaten","index":0,"n_rows":29,"n_cols":10,"rows_kept":29,"merged":[[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6]]}
[]
["Projektdaten",{"$nulls":7},"Datum ","tt.mm.jj"]
[]
["Projektdaten","Standort"]
[null,"Projekt"]
[null,"ID-Nummer"]
[null,"Auftraggeber","Kanton Luzern, Dienststelle Immobilien, Stadthofstrasse 4, 6002 Luzern"]
[null,"Projektleitung Bauherr"]
[null,"Projektleitung Planer"]
[null,"Nutzungs-Kurzbeschrieb"]
[null,"Architekturkonzept"]
[null,"Statikkonzept"]
[null,"Haustechnikkonzept"]
[null,"Ökologie / Energiestandards"]
[]
["Anzahl Geschosse",null,"UG",null,null,"Diverse Funktionale Einheiten FE",null,null,"Anzahl \"...\""]
[null,null,"EG",{"$nulls":5},"Anzahl \"...\""]
[null,null,"OG",{"$nulls":5},"Anzahl \"...\""]
[null,null,"DG",{"$nulls":5},"Anzahl \"...\""]
[null,null,"Total ",{"$f":"SUM(D16:D19)","v":0},null,"Massgebende Funktionale Einheit FE",null,null,"Anzahl \"...\""]
[]
["Termine",null,"Planungsbeginn",null,null,"Energiebezugsfläche (EBF) AE",null,null,"m2"]
[null,null,"Baubeginn",null,null,"Gebäudehüllzahl Ath/AE",null,null,"(-)"]
[null,null,"Bauvollendung",null,null,"Heizwärmebedarf Qh",null,null,"MJ/m2a"]
[null,null,"Bezug",null,null,"Energiekennzahl nach Minergie E",null,null,"kWh/m2a"]
[]
["Kostenstand",null,"Baupreisindex Hochbau Zentralschweiz",{"$nulls":3},"erstellt",null,"tt.mm.jj",{"v":0,"d":"0.0"}]
["Baupreisindex-Bundesamt für Statistik",null,"Baupreisindex Hochbau Zentralschweiz",{"$nulls":3},"aktuell",null,"tt.mm.jj",{"v":0,"d":"0.0"}]
[{"$nulls":8},"Teuerung",{"$f":"(J28-J27)/J27","v":{"$error":"#DIV/0!"}}]

{"sheet":"Zusammenstellung Flächen","index":1,"n_rows":36,"n_cols":17,"rows_kept":36}
[]
["Flächen nach SIA 416"]
[]
["Grundstück","Grundstücksfläche ",null,null,"GSF",null,"m2"]
[null,"Gebäudegrundfläche ",null,null,"GGF",null,"m2"]
[null,"Umgebungsfläche ",null,null,"UF",null,"m2"]
[null,"Bearbeitete Umgebungsfläche",null,null,"BUF",null,"m2"]
[]
[]
[null,null,"Umbau",{"$nulls":5},"Neubau",{"$nulls":4},"Gesamt"]
[]
["Flächen","Geschossfläche ",null,null,"GF",{"$f":"'Flächen SIA 416 Detail'!I18","v":0},"m2",null,null,"GF",{"$f":"'Flächen SIA 416 Detail'!U18","v":0},"m2",null,null,"GF",{"$f":"'Flächen SIA 416 Detail'!I35","v":0},"m2"]
[null,"Nettogeschossfläche ",null,null,"NGF",{"$f":"'Flächen SIA 416 Detail'!G18","v":0},"m2",null,null,"NGF",{"$f":"'Flächen SIA 416 Detail'!S18","v":0},"m2",null,null,"NGF",{"$f":"'Flächen SIA 416 Detail'!G35","v":0},"m2"]
[null,"Konstruktionsfläche SIA 416",null,null,"KF",{"$f":"'Flächen SIA 416 Detail'!H18","v":0},"m2",null,null,"KF",{"$f":"'Flächen SIA 416 Detail'!T18","v":0},"m2",null,null,"KF",{"$f":"'Flächen SIA 416 Detail'!H35","v":0},"m2"]
[null,"Nutzfläche SIA ",null,null,"NF",{"$f":"'Flächen SIA 416 Detail'!D18","v":0},"m2",null,null,"NF",{"$f":"'Flächen SIA 416 Detail'!P18","v":0},"m2",null,null,"NF",{"$f":"'Flächen SIA 416 Detail'!D35","v":0},"m2"]
[null,"Verkehrsfläche ",null,null,"VF",{"$f":"'Flächen SIA 416 Detail'!E18","v":0},"m2",null,null,"VF",{"$f":"'Flächen SIA 416 Detail'!Q18","v":0},"m2",null,null,"VF",{"$f":"'Flächen SIA 416 Detail'!E35","v":0},"m2"]
[null,"Funktionsfläche",null,null,"FF",{"$f":"'Flächen SIA 416 Detail'!F18","v":0},"m2",null,null,"FF",{"$f":"'Flächen SIA 416 Detail'!R18","v":0},"m2",null,null,"FF",{"$f":"'Flächen SIA 416 Detail'!F35","v":0},"m2"]
[null,"Hauptnutzfläche ",null,null,"HNF",{"$f":"'Flächen SIA 416 Detail'!B18","v":0},"m2",null,null,"HNF",{"$f":"'Flächen SIA 416 Detail'!N18","v":0},"m2",null,null,"HNF",{"$f":"'Flächen SIA 416 Detail'!B35","v":0},"m2"]
[null,"Nebennutzfläche ",null,null,"NNF",{"$f":"'Flächen SIA 416 Detail'!C18","v":0},"m2",null,null,"NNF",{"$f":"'Flächen SIA 416 Detail'!O18","v":0},"m2",null,null,"NNF",{"$f":"'Flächen SIA 416 Detail'!C35","v":0},"m2"]
[null,"Funktionale Einheit",null,null,"FE",null,"-",null,null,"FE",null,"-",null,null,"FE",null,"-"]
[null,"Aussenwandfläche (Fassade inkl. UG)",null,null,"AWF",null,"m2",null,null,"AWF",null,"m2",null,null,"AWF",null,"m2"]
[null,"Fenster, Aussentüren und -tore",null,null,"FEN",null,"m2",null,null,"FEN",null,"m2",null,null,"FEN",null,"m2"]
[null,"Dachfläche",null,null,"DF",null,"m2",null,null,"DF",null,"m2",null,null,"DF",null,"m2"]
[null,"Energiebezugsfläche SIA 416/1, 380/1",null,null,"EBF",null,"m2",null,null,"EBF",null,"m2",null,null,"EBF",null,"m2"]
[]
["Volumen","Gebäudevolumen ",null,null,"GV",{"$f":"'Flächen SIA 416 Detail'!K18","v":0},"m3",null,null,"GV",{"$f":"'Flächen SIA 416 Detail'!W18","v":0},"m3",null,null,"GV",{"$f":"'Flächen SIA 416 Detail'!K35","v":0},"m3"]
[]
["Projektkennziffern",null,"GSF/GF",null,null,{"$f":"IF(GSF=0,0,GSF/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"GSF/GF",null,{"$f":"IF(GSF=0,0,GSF/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"GSF/GF",null,{"$f":"IF(GSF=0,0,GSF/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"GGF/GF",null,null,{"$f":"IF(GGF=0,0,GGF/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"GGF/GF",null,{"$f":"IF(GGF=0,0,GGF/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"GGF/GF",null,{"$f":"IF(GGF=0,0,GGF/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"GV/GF",null,null,{"$f":"IF(GV_UMBAU=0,0,GV_UMBAU/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"GV/GF",null,{"$f":"IF(GV_NEUBAU=0,0,GV_NEUBAU/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"GV/GF",null,{"$f":"IF(GV_GESAMT=0,0,GV_GESAMT/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"NF/GF",null,null,{"$f":"IF(NF_UMBAU=0,0,NF_UMBAU/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"NF/GF",null,{"$f":"IF(NF_NEUBAU=0,0,NF_NEUBAU/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"NF/GF",null,{"$f":"IF(NF_GESAMT=0,0,NF_GESAMT/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"GF/DF",null,null,{"$f":"IF(GF_UMBAU=0,0,GF_UMBAU/DF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"GF/DF",null,{"$f":"IF(GF_NEUBAU=0,0,GF_NEUBAU/DF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"GF/DF",null,{"$f":"IF(GF_GESAMT=0,0,GF_GESAMT/DF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"AWF/GF",null,null,{"$f":"IF(AWF_UMBAU=0,0,AWF_UMBAU/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"AWF/GF",null,{"$f":"IF(AWF_NEUBAU=0,0,AWF_NEUBAU/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"AWF/GF",null,{"$f":"IF(AWF_GESAMT=0,0,AWF_GESAMT/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"EBF/GF",null,null,{"$f":"IF(EBF_UMBAU=0,0,EBF_UMBAU/GF_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"EBF/GF",null,{"$f":"IF(EBF_NEUBAU=0,0,EBF_NEUBAU/GF_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"EBF/GF",null,{"$f":"IF(EBF_GESAMT=0,0,EBF_GESAMT/GF_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"GF/FE",null,null,{"$f":"IF(GF_UMBAU=0,0,GF_UMBAU/FE_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"GF/FE",null,{"$f":"IF(GF_NEUBAU=0,0,GF_NEUBAU/FE_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"GF/FE",null,{"$f":"IF(GF_GESAMT=0,0,GF_GESAMT/FE_GESAMT)","v":{"v":0,"d":"0.00"}}]
[null,null,"NF/FE",null,null,{"$f":"IF(NF_UMBAU=0,0,NF_UMBAU/FE_UMBAU)","v":{"v":0,"d":"0.00"}},null,null,"NF/FE",null,{"$f":"IF(NF_NEUBAU=0,0,NF_NEUBAU/FE_NEUBAU)","v":{"v":0,"d":"0.00"}},null,null,"NF/FE",null,{"$f":"IF(NF_GESAMT=0,0,NF_GESAMT/FE_GESAMT)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Flächen SIA 416 Detail","index":2,"n_rows":38,"n_cols":23,"rows_kept":38}
[]
["Flächen- und Volumennachweis nach SIA 416"]
[]
[{"$f":"'Zusammenstellung Flächen'!C10","v":"Umbau"},{"$nulls":11},{"$f":"'Zusammenstellung Flächen'!I10","v":"Neubau"}]
[]
["Geschoss","HNF\n[m2]\n","NNF\n[m2]","NF\n[m2]","VF\n[m2]","FF\n[m2]","NGF\n[m2]","KF\n[m2]","GF\n[m2]","Höhe\n[m]","GV 416\n[m3]",null,"Geschoss","HNF\n[m2]\n","NNF\n[m2]","NF\n[m2]","VF\n[m2]","FF\n[m2]","NGF\n[m2]","KF\n[m2]","GF\n[m2]","Höhe\n[m]","GV 416\n[m3]"]
["2.UG ",null,null,{"$f":"SUM(B7:C7)","v":0},null,null,{"$f":"SUM(D7:F7)","v":0},null,{"$f":"SUM(G7:H7)","v":0},null,{"$f":"I7*J7","v":0},null,"2.UG ",null,null,{"$f":"SUM(N7:O7)","v":0},null,null,{"$f":"SUM(P7:R7)","v":0},null,{"$f":"SUM(S7:T7)","v":0},null,{"$f":"U7*V7","v":0}]
["1.UG",null,null,{"$f":"SUM(B8:C8)","v":0},null,null,{"$f":"SUM(D8:F8)","v":0},null,{"$f":"SUM(G8:H8)","v":0},null,0,null,"1.UG",null,null,{"$f":"SUM(N8:O8)","v":0},null,null,{"$f":"SUM(P8:R8)","v":0},null,{"$f":"SUM(S8:T8)","v":0},null,0]
["EG",null,null,0,null,null,0,null,0,null,0,null,"EG",null,null,0,null,null,0,null,0,null,0]
["1.OG",null,null,0,null,null,0,null,0,null,0,null,"1.OG",null,null,0,null,null,0,null,0,null,0]
["2.OG",null,null,0,null,null,0,null,0,null,0,null,"2.OG",null,null,0,null,null,0,null,0,null,0]
["3.OG",null,null,0,null,null,0,null,0,null,0,null,"3.OG",null,null,0,null,null,0,null,0,null,0]
["4.OG",null,null,0,null,null,0,null,0,null,0,null,"4.OG",null,null,0,null,null,0,null,0,null,0]
["5.OG",null,null,0,null,null,0,null,0,null,0,null,"5.OG",null,null,0,null,null,0,null,0,null,0]
["6.OG",null,null,0,null,null,0,null,0,null,0,null,"6.OG",null,null,0,null,null,0,null,0,null,0]
["7.OG",null,null,0,null,null,0,null,0,null,0,null,"7.OG",null,null,0,null,null,0,null,0,null,0]
["8.OG",null,null,0,null,null,0,null,0,null,0,null,"8.OG",null,null,0,null,null,0,null,0,null,0]
["Total",{"$f":"SUM(B7:B17)","v":0},0,0,0,0,0,0,{"$f":"SUM(I7:I17)","v":0},null,{"$f":"SUM(K7:K17)","v":0},null,"Total",{"$f":"SUM(N7:N17)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(W7:W17)","v":0}]
[]
[]
[{"$f":"'Zusammenstellung Flächen'!N10","v":"Gesamt"}]
[]
["Geschoss","HNF\n[m2]\n","NNF\n[m2]","NF\n[m2]","VF\n[m2]","FF\n[m2]","NGF\n[m2]","KF\n[m2]","GF\n[m2]","Höhe\n[m]","GV 416\n[m3]"]
["2.UG ",null,null,{"$f":"SUM(B24:C24)","v":0},null,null,{"$f":"SUM(D24:F24)","v":0},null,{"$f":"SUM(G24:H24)","v":0},null,{"$f":"I24*J24","v":0}]
["1.UG",null,null,{"$f":"SUM(B25:C25)","v":0},null,null,{"$f":"SUM(D25:F25)","v":0},null,{"$f":"SUM(G25:H25)","v":0},null,0]
["EG",null,null,0,null,null,0,null,0,null,0]
["1.OG",null,null,0,null,null,0,null,0,null,0]
["2.OG",null,null,0,null,null,0,null,0,null,0]
["3.OG",null,null,0,null,null,0,null,0,null,0]
["4.OG",null,null,0,null,null,0,null,0,null,0]
["5.OG",null,null,0,null,null,0,null,0,null,0]
["6.OG",null,null,0,null,null,0,null,0,null,0]
["7.OG",null,null,0,null,null,0,null,0,null,0]
["8.OG",null,null,0,null,null,0,null,0,null,0]
["Total",{"$f":"SUM(B24:B34)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(K24:K34)","v":0}]
[]
[]
["Legende Flächennachweis nach SIA 416"]

{"sheet":"Anlagekosten","index":3,"n_rows":75,"n_cols":17,"rows_kept":75,"merged":[[1,0,1,7],[7,3,7,6],[7,8,7,11],[7,13,7,16],[38,0,38,8],[44,3,44,6],[44,8,44,11],[44,13,44,16]]}
[]
["Anlagekosten nach BKP (1-stellig inkl. MwSt.)",{"$nulls":10},"Baupreisindex:",null,{"$f":"Projektdaten!I27","v":"tt.mm.jj"}]
[]
[null,"Vorprojekt"]
[0,"Bauprojekt"]
[null,"Schlussrechnung"]
[]
[{"$nulls":3},{"$f":"'Zusammenstellung Flächen'!C10","v":"Umbau"},{"$nulls":4},{"$f":"'Zusammenstellung Flächen'!I10","v":"Neubau"},{"$nulls":4},{"$f":"'Zusammenstellung Flächen'!N10","v":"Gesamt"}]
[]
["BKP","Bezeichnung",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]"]
[]
["0","Grundstück",null,null,{"$f":"(D12/D$22)","v":{"$error":"#DIV/0!"}},{"$f":"D12/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D12/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(I12/I$22)","v":{"$error":"#DIV/0!"}},{"$f":"I12/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I12/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(N12/N$22)","v":{"$error":"#DIV/0!"}},{"$f":"N12/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N12/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[1,"Vorbereitungsarbeiten",null,null,{"$f":"(D13/D$22)","v":{"$error":"#DIV/0!"}},{"$f":"D13/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D13/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I13/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I13/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N13/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N13/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[2,"Gebäude",null,null,{"$error":"#DIV/0!"},{"$f":"D14/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D14/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I14/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I14/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N14/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N14/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[3,"Betriebseinrichtungen",null,null,{"$error":"#DIV/0!"},{"$f":"D15/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D15/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I15/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I15/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N15/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N15/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[4,"Umgebung",null,null,{"$error":"#DIV/0!"},{"$f":"D16/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D16/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I16/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I16/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N16/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N16/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[5,"Baunebenkosten",null,null,{"$error":"#DIV/0!"},{"$f":"D17/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D17/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I17/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I17/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N17/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N17/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[6,"Reserve",null,null,{"$error":"#DIV/0!"},{"$f":"D18/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D18/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I18/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I18/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N18/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N18/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[7,{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"D19/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D19/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I19/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I19/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N19/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N19/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[8,{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"D20/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D20/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I20/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I20/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N20/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N20/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[9,"Ausstattung",null,null,{"$error":"#DIV/0!"},{"$f":"D21/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D21/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"I21/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I21/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$f":"N21/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N21/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Erstellungskosten",null,{"$f":"SUM(D12:D21)","v":0},{"$f":"SUM(E12:E21)","v":{"$error":"#DIV/0!"}},{"$f":"D22/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D22/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(I12:I21)","v":0},{"$error":"#DIV/0!"},{"$f":"I22/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I22/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(N12:N21)","v":0},{"$f":"SUM(O12:O21)","v":{"$error":"#DIV/0!"}},{"$f":"N22/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N22/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[]
[]
["Projektkennwerte",null,null,"Betrag\n[CHF]",{"$nulls":4},"Betrag\n[CHF]",{"$nulls":4},"Betrag\n[CHF]"]
[]
[null,"Kosten BKP 2 / GF",null,{"$f":"D14/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I14/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N14/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2 / GV",null,{"$f":"D14/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I14/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N14/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / HNF",null,{"$f":"(D14+D15)/'Zusammenstellung Flächen'!F$18","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I14+I15)/'Zusammenstellung Flächen'!K$18","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N14+N15)/'Zusammenstellung Flächen'!P$18","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / GF",null,{"$f":"(D14+D15)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I14+I15)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N14+N15)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / GV",null,{"$f":"(D14+D15)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I14+I15)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N14+N15)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-8 / GF",null,{"$f":"(D13+D14+D15+D16+D17+D18+D19+D20)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I13+I14+I15+I16+I17+I18+I19+I20)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N13+N14+N15+N16+N17+N18+N19+N20)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-8 / GV",null,{"$f":"(D13+D14+D15+D16+D17+D18+D19+D20)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I13+I14+I15+I16+I17+I18+I19+I20)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N13+N14+N15+N16+N17+N18+N19+N20)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / GF",null,{"$f":"D22/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I22/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N22/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / GV",null,{"$f":"D22/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I22/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N22/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / FE",null,{"$f":"(D14+D15)/'Zusammenstellung Flächen'!F20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I14+I15)/'Zusammenstellung Flächen'!K20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N14+N15)/'Zusammenstellung Flächen'!P20","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / FE",null,{"$f":"D22/'Zusammenstellung Flächen'!F$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I22/'Zusammenstellung Flächen'!K$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N22/'Zusammenstellung Flächen'!P$20","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 4 / BUF",null,{"$f":"D16/'Zusammenstellung Flächen'!F$7","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I16/'Zusammenstellung Flächen'!F7","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N16/'Zusammenstellung Flächen'!F7","v":{"$error":"#DIV/0!"}}]
["Anlagekosten nach BKP (1-stellig inkl. MwSt.)",{"$nulls":10},"Baupreisindex",null,{"$f":"Projektdaten!I28","v":"tt.mm.jj"},null,null,"INDEXIERT"]
[]
[0,"Vorprojekt"]
[0,"Bauprojekt"]
[null,"Schlussrechnung"]
[]
[{"$nulls":3},{"$f":"'Zusammenstellung Flächen'!C10","v":"Umbau"},{"$nulls":4},{"$f":"'Zusammenstellung Flächen'!I10","v":"Neubau"},{"$nulls":4},{"$f":"'Zusammenstellung Flächen'!N10","v":"Gesamt"}]
[]
["BKP","Bezeichnung",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]"]
[]
["0","Grundstück",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D12*(1+Projektdaten!$J$29))","v":0},{"$f":"D49/D$59","v":{"$error":"#DIV/0!"}},{"$f":"D49/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D49/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I12*(1+Projektdaten!$J$29))","v":0},{"$f":"I49/I$59","v":{"$error":"#DIV/0!"}},{"$f":"I49/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I49/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N12*(1+Projektdaten!$J$29))","v":0},{"$f":"N49/N$59","v":{"$error":"#DIV/0!"}},{"$f":"N49/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N49/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[1,"Vorbereitungsarbeiten",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D13*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D50/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D50/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I13*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I50/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I50/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N13*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N50/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N50/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[2,"Gebäude",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D14*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D51/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D51/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I14*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I51/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I51/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N14*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N51/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N51/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[3,"Betriebseinrichtungen",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D52/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D52/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I52/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I52/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N52/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N52/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[4,"Umgebung",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D53/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D53/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I53/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I53/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N53/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N53/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[5,"Baunebenkosten",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D54/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D54/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I54/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I54/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N54/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N54/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[6,"Reserve",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D55/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D55/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I55/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I55/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N55/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N55/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[7,null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D56/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D56/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I56/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I56/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N56/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N56/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[8,null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D57/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D57/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I57/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I57/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N57/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N57/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[9,"Ausstattung",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D58/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D58/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I58/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I58/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N58/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N58/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Erstellungskosten",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,D22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"D59/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"D59/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,I22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"I59/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"I59/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,N22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"N59/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"N59/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[]
[]
["Projektkennwerte",null,null,"Betrag\n[CHF]",{"$nulls":4},"Betrag\n[CHF]",{"$nulls":4},"Betrag\n[CHF]"]
[]
[null,"Kosten BKP 2 / GF",null,{"$f":"D51/'Zusammenstellung Flächen'!F12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I51/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N51/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2 / GV",null,{"$f":"D51/'Zusammenstellung Flächen'!F26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I51/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N51/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / HNF",null,{"$f":"(D51+D52)/'Zusammenstellung Flächen'!F18","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I51+I52)/'Zusammenstellung Flächen'!K$18","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N51+N52)/'Zusammenstellung Flächen'!P$18","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / GF",null,{"$f":"(D51+D52)/'Zusammenstellung Flächen'!F12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I51+I52)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N51+N52)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / GV",null,{"$f":"(D51+D52)/'Zusammenstellung Flächen'!F26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I51+I52)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N51+N52)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-8 / GF",null,{"$f":"(D50+D51+D52+D53+D54+D55+D56+D57)/'Zusammenstellung Flächen'!F12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I50+I51+I52+I53+I54+I55+I56+I57)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N50+N51+N52+N53+N54+N55+N56+N57)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-8 / GV",null,{"$f":"(D50+D51+D52+D53+D54+D55+D56+D57)/'Zusammenstellung Flächen'!F26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I50+I51+I52+I53+I54+I55+I56+I57)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N50+N51+N52+N53+N54+N55+N56+N57)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / GF",null,{"$f":"D59/'Zusammenstellung Flächen'!F12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I59/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N59/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / GV",null,{"$f":"D59/'Zusammenstellung Flächen'!F26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I59/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N59/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 2+3 / FE",null,{"$f":"(D51+D52)/'Zusammenstellung Flächen'!F$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(I51+I52)/'Zusammenstellung Flächen'!K$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"(N51+N52)/'Zusammenstellung Flächen'!P$20","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 1-9 / FE",null,{"$f":"D59/'Zusammenstellung Flächen'!F$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I59/'Zusammenstellung Flächen'!K$20","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N59/'Zusammenstellung Flächen'!P$20","v":{"$error":"#DIV/0!"}}]
[null,"Kosten BKP 4 / BUF",null,{"$f":"D53/'Zusammenstellung Flächen'!$F$7","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"I53/'Zusammenstellung Flächen'!F7","v":{"$error":"#DIV/0!"}},{"$nulls":4},{"$f":"N53/'Zusammenstellung Flächen'!F7","v":{"$error":"#DIV/0!"}}]

{"sheet":"Gebäudekosten","index":4,"n_rows":65,"n_cols":20,"rows_kept":65,"merged":[[1,1,1,9],[7,3,7,7],[7,9,7,13],[7,15,7,19],[33,1,33,9],[39,3,39,7],[39,9,39,13],[39,15,39,19]]}
[]
[null,"Gebäudekosten nach BKP (2-stellig inkl. MwSt.)",{"$nulls":11},"Baupreisindex",null,{"$f":"Projektdaten!I27","v":"tt.mm.jj"}]
[]
[null,null,"Vorprojekt"]
[null,null,"Bauprojekt"]
[null,null,"Schlussrechnung"]
[]
[{"$nulls":3},{"$f":"'Zusammenstellung Flächen'!C10","v":"Umbau"},{"$nulls":5},{"$f":"'Zusammenstellung Flächen'!I10","v":"Neubau"},{"$nulls":5},{"$f":"'Zusammenstellung Flächen'!N10","v":"Gesamt"}]
[]
[null,"BKP","Bezeichnung","Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]"]
[]
[null,2,"Gebäude",{"$f":"Anlagekosten!D14","v":0},{"$nulls":5},{"$f":"Anlagekosten!I14","v":0},{"$nulls":5},{"$f":"Anlagekosten!N14","v":0}]
[null,20,"Baugrube",null,null,{"$f":"E13/E$23","v":{"$error":"#DIV/0!"}},{"$f":"E13/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E13/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"K13/K$23","v":{"$error":"#DIV/0!"}},{"$f":"K13/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K13/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"Q13/Q$23","v":{"$error":"#DIV/0!"}},{"$f":"Q13/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q13/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,21,"Rohbau 1",null,null,{"$error":"#DIV/0!"},{"$f":"E14/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E14/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K14/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K14/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"Q14/Q$23","v":{"$error":"#DIV/0!"}},{"$f":"Q14/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q14/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,22,"Rohbau 2",null,null,{"$error":"#DIV/0!"},{"$f":"E15/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E15/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K15/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K15/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q15/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q15/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,23,"Elektroanlagen",null,null,{"$error":"#DIV/0!"},{"$f":"E16/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E16/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K16/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K16/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q16/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q16/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,24,"Heizung, Lüftung, Klima",null,null,{"$error":"#DIV/0!"},{"$f":"E17/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E17/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K17/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K17/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q17/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q17/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,25,"Sanitäranlagen",null,null,{"$error":"#DIV/0!"},{"$f":"E18/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E18/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K18/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K18/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q18/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q18/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,26,"Transportanlagen",null,null,{"$error":"#DIV/0!"},{"$f":"E19/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E19/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K19/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K19/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q19/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q19/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,27,"Ausbau 1",null,null,{"$error":"#DIV/0!"},{"$f":"E20/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E20/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K20/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K20/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q20/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q20/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,28,"Ausbau 2",null,null,{"$error":"#DIV/0!"},{"$f":"E21/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E21/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K21/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K21/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q21/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q21/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,29,"Honorare",null,null,{"$error":"#DIV/0!"},{"$f":"E22/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E22/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"K22/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K22/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$error":"#DIV/0!"},{"$f":"Q22/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q22/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Erstellungskosten",null,{"$f":"SUM(E13:E22)","v":0},{"$f":"SUM(F13:F22)","v":{"$error":"#DIV/0!"}},{"$f":"E23/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E23/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(K13:K22)","v":0},{"$f":"SUM(L13:L22)","v":{"$error":"#DIV/0!"}},{"$f":"K23/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K23/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(Q13:Q22)","v":0},{"$f":"SUM(R13:R22)","v":{"$error":"#DIV/0!"}},{"$f":"Q23/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q23/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Projektkennwerte",null,null,"Betrag\n[CHF]",{"$nulls":5},"Betrag\n[CHF]",{"$nulls":5},"Betrag\n[CHF]"]
[]
[null,null,"Kosten BKP 20+21+22 / GF",null,{"$f":"(E14+E15+E13)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K14+K15+K13)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q14+Q15+Q13)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 20+21+22 / GV",null,{"$f":"(E13+E14+E15)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K13+K14+K15)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q13+Q14+Q15)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 23+24+25+26 / GF",null,{"$f":"(E16+E17+E18+E19)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$16+K$17+K$18+K$19)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$16+Q$17+Q$18+Q$19)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 23+24+25+26 / GV",null,{"$f":"(E16+E17+E18+E19)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$16+K$17+K$18+K$19)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$16+Q$17+Q$18+Q$19)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 27+28 / GF",null,{"$f":"(E20+E21)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$20+K$21)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$20+Q$21)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 27+28 / GV",null,{"$f":"(E20+E21)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$20+K$21)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$20+Q$21)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,"Gebäudekosten nach BKP (2-stellig inkl. MwSt.)",{"$nulls":11},"Baupreisindex",null,{"$f":"Projektdaten!I28","v":"tt.mm.jj"},{"$nulls":3},"INDEXIERT"]
[]
[null,null,"Vorprojekt"]
[null,null,"Bauprojekt"]
[null,null,"Schlussrechnung"]
[]
[{"$nulls":3},{"$f":"'Zusammenstellung Flächen'!C10","v":"Umbau"},{"$nulls":5},{"$f":"'Zusammenstellung Flächen'!I10","v":"Neubau"},{"$nulls":5},{"$f":"'Zusammenstellung Flächen'!N10","v":"Gesamt"}]
[]
[null,"BKP","Bezeichnung","Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]",null,"Betrag\n[CHF]","Betrag\n[CHF]","%","/m3 GV\n[CHF]","/m2 GF\n[CHF]"]
[]
[null,2,"Gebäude",{"$f":"Anlagekosten!D51","v":0},{"$nulls":5},{"$f":"Anlagekosten!I51","v":0},{"$nulls":5},{"$f":"Anlagekosten!N51","v":0}]
[null,20,"Baugrube",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E13*(1+Projektdaten!$J$29))","v":0},{"$f":"E45/E$55","v":{"$error":"#DIV/0!"}},{"$f":"E45/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E45/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K13*(1+Projektdaten!$J$29))","v":0},{"$f":"K45/K$55","v":{"$error":"#DIV/0!"}},{"$f":"K45/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K45/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q13*(1+Projektdaten!$J$29))","v":0},{"$f":"Q45/Q$55","v":{"$error":"#DIV/0!"}},{"$f":"Q45/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q45/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,21,"Rohbau 1",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E14*(1+Projektdaten!$J$29))","v":0},{"$f":"E46/E$55","v":{"$error":"#DIV/0!"}},{"$f":"E46/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E46/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K14*(1+Projektdaten!$J$29))","v":0},{"$f":"K46/K$55","v":{"$error":"#DIV/0!"}},{"$f":"K46/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K46/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q14*(1+Projektdaten!$J$29))","v":0},{"$f":"Q46/Q$55","v":{"$error":"#DIV/0!"}},{"$f":"Q46/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q46/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,22,"Rohbau 2",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E47/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E47/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K47/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K47/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q15*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q47/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q47/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,23,"Elektroanlagen",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E48/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E48/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K48/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K48/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q16*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q48/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q48/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,24,"Heizung, Lüftung, Klima",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E49/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E49/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K49/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K49/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q17*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q49/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q49/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,25,"Sanitäranlagen",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E50/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E50/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K50/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K50/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q18*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q50/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q50/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,26,"Transportanlagen",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E51/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E51/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K51/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K51/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q19*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q51/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q51/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,27,"Ausbau 1",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E52/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E52/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K52/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K52/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q20*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q52/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q52/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,28,"Ausbau 2",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E53/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E53/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K53/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K53/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q21*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q53/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q53/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,29,"Honorare",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E54/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E54/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K54/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K54/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q22*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q54/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q54/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Erstellungskosten",null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,E23*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"E55/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$f":"E55/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,K23*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"K55/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$f":"K55/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},null,null,{"$f":"IF(Projektdaten!$J$28-Projektdaten!$J$27=0,0,Q23*(1+Projektdaten!$J$29))","v":0},{"$error":"#DIV/0!"},{"$f":"Q55/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}},{"$f":"Q55/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Projektkennwerte",null,null,"Betrag\n[CHF]",{"$nulls":5},"Betrag\n[CHF]",{"$nulls":5},"Betrag\n[CHF]"]
[]
[null,null,"Kosten BKP 20+21+22 / GF",null,{"$f":"(E45+E46+E47)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K45+K46+K47)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q45+Q46+Q47)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 20+21+22 / GV",null,{"$f":"(E45+E46+E47)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K45+K46+K47)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q45+Q46+Q47)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 23+24+25+26 / GF",null,{"$f":"(E48+E49+E50+E51)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$48+K$49+K$50+K$51)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$48+Q$49+Q$50+Q$51)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 23+24+25+26 / GV",null,{"$f":"(E48+E49+E50+E51)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$48+K$49+K$50+K$51)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$48+Q$49+Q$50+Q$51)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 27+28 / GF",null,{"$f":"(E52+E53)/'Zusammenstellung Flächen'!F$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$52+K$53)/'Zusammenstellung Flächen'!K$12","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$52+Q$53)/'Zusammenstellung Flächen'!P$12","v":{"$error":"#DIV/0!"}}]
[null,null,"Kosten BKP 27+28 / GV",null,{"$f":"(E52+E53)/'Zusammenstellung Flächen'!F$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(K$52+K$53)/'Zusammenstellung Flächen'!K$26","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"(Q$52+Q$53)/'Zusammenstellung Flächen'!P$26","v":{"$error":"#DIV/0!"}}]