{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Tabelle1","Tabelle2","Tabelle3","Tabelle4","Tabelle5"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":104,"n_cols":10,"rows_kept":104,"merged":[[4,3,4,9],[5,8,5,9],[6,8,6,9],[8,3,8,9],[9,3,9,9],[11,3,11,9],[12,3,12,9],[14,3,14,9],[15,3,15,9],[16,3,16,9],[18,3,18,9],[19,3,19,9],[20,3,20,9],[21,3,21,9],[22,3,22,9],[24,8,24,9],[25,8,25,9],[27,5,27,6],[28,5,28,6],[30,5,30,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[52,1,52,2],[52,5,52,6],[53,1,53,2],[53,5,53,6],[54,1,54,2],[54,5,54,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[62,5,62,6],[63,5,63,6],[64,5,64,6],[65,5,65,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[70,5,70,6],[71,5,71,6],[72,5,72,6],[73,5,73,6],[74,5,74,6],[75,5,75,6],[76,5,76,6],[77,5,77,6],[78,1,78,2],[78,5,78,6],[79,1,79,2],[79,5,79,6],[80,5,80,6],[82,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[86,5,86,6],[87,5,87,6],[88,5,88,6],[89,5,89,6],[90,5,90,6],[91,5,91,6],[92,5,92,6],[93,5,93,6],[94,5,94,6],[96,5,96,6],[97,5,97,6],[98,5,98,6],[99,5,99,6],[101,1,101,9]]}
[]
[]
[null,"Projektdaten",{"$nulls":6},"Datum:"]
[null,"Bezeichnung"]
[null,"Projekt"]
[null,"ID-Nummer (Projektnummer)",{"$nulls":3},"Projektstand"]
[null,"Parzellen-Nummer",{"$nulls":3},"GVL-Nummer"]
[null,"Standortadresse"]
[null,"Adresse"]
[null,"PLZ / Ort"]
[null,"Beteiligte"]
[null,"Bauherrschaft"]
[null,"Projektleiter/in"]
[null,"Projekt"]
[null,"Katogerie"]
[null,"Projekt-Kurzbeschrieb"]
[null,"Nutzungs-Kurzbeschrieb"]
[null,"Konzepte"]
[null,"Achitektur"]
[null,"Statik"]
[null,"Haustechnik"]
[null,"Ökologie"]
[null,"Energie-Standards / ECO"]
[null,"Termine"]
[null,"Planungsbeginn",{"$nulls":3},"Fertigstellung"]
[null,"Baubeginn",{"$nulls":3},"Bezug"]
[null,"Grundstück"]
[null,"Grundstücksfläche ",null,"GSF",{"$nulls":4},"m2"]
[null,"bearb. Umgebungsfläche ",null,"BUF",{"$nulls":4},"m2"]
[null,"Gebäudevolumen"]
[null,"nach SIA 416",{"$nulls":6},"m3"]
[null,"Flächendaten SIA 416 und D 0165"]
[null,"Geschossfläche",null,"GF",{"$nulls":4},"m2",{"v":1,"d":"100%"}]
[null,"Wohnen ",null,"HNF1",{"$nulls":4},"m2"]
[null,"Büro ",null,"HNF2",{"$nulls":4},"m2"]
[null,"Produktion ",null,"HNF3",{"$nulls":4},"m2"]
[null,"Verkauf, Lager ",null,"HNF4",{"$nulls":4},"m2"]
[null,"Bildung, Kultur ",null,"HNF5",{"$nulls":4},"m2"]
[null,"Heilen ",null,"HNF6",{"$nulls":4},"m2"]
[null,"Hauptnutzfläche ",null,"HNF",null,{"$f":"SUM(F34:G39)","v":0},null,null,"m2",{"$f":"IFERROR(J33/F33*(F34+F35+F36+F37+F38+F39),0)","v":{"v":0,"d":"0%"}}]
[null,"Nebennutzfläche ",null,"NNF",{"$nulls":4},"m2",{"$f":"IFERROR(J33/F33*F41,0)","v":{"v":0,"d":"0%"}}]
[null,"Nutzfläche",null,"NF",null,{"$f":"SUM(F40:G41)","v":0},null,null,"m2",{"$f":"IFERROR(J33/F33*(F40+J41),0)","v":{"v":0,"d":"0%"}}]
[null,"Verkehrsfläche ",null,"VF",{"$nulls":4},"m2",{"$f":"IFERROR(J33/F33*F43,0)","v":{"v":0,"d":"0%"}}]
[null,"Funktionsfläche ",null,"FF",{"$nulls":4},"m2",{"$f":"IFERROR(J33/F33*F44,0)","v":{"v":0,"d":"0%"}}]
[null,"Konstruktionsfläche ",null,"KF",null,{"$f":"SUM(F33-F42-F43-F44)","v":0},null,null,"m2",{"$f":"IFERROR(J33/F33*F45,0)","v":{"v":0,"d":"0%"}}]
[null,"Energiedaten SIA 380/1"]
[null,"Energiebezugsfläche (EBF)",null,"AE",{"$nulls":4},"m2"]
[null,"Gebäudehüllfläche",null,"Ath",{"$nulls":4},"m3"]
[null,"Gebäudehüllzahl ",null,"Ath / AE"]
[null,"Heizwärmebedarf ",null,"Qh",{"$nulls":4},"MJ/m2a"]
[null,"Energiekennzahl (Minergie) ",null,"E",{"$nulls":4},"kWh/m2a"]
[null,"Nutzungseinheiten"]
[{"$nulls":3},"Einheit 1"]
[{"$nulls":3},"Einheit 2"]
[{"$nulls":3},"Einheit 3"]
[null,"Ausgangswerte / Indexstand",{"$nulls":6},"Jahr","Index"]
[null,"Baupreisindex CH ",{"$nulls":3},"Basis ",1998]
[null,"Baupreisindex CH Hochbau Zentralschweiz ",{"$nulls":3},"Basis "]
[null,"Anlagekosten "]
[null,"Investitionskosten",null,"BKP 0-9",null,{"$f":"SUM(F61:G62)","v":0},null,null,"CHF",{"$f":"IFERROR(J61+J62,0)","v":{"v":1,"d":"100%"}}]
[null,"Grundstück ",null,"BKP 0",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F61,0)","v":{"v":0,"d":"0%"}}]
[null,"Baukosten ",null,"BKP 1-9",null,{"$f":"SUM(F63,F74,F75,F76,F77,F78,F79,F80,F81)","v":0},null,null,"CHF",{"v":1,"d":"100%"}]
[null,"Vorbereitungsarbeiten ",null,"BKP 1",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F63,0)","v":{"v":0,"d":"0%"}}]
[null,"Baugrube",null,"BKP 20"]
[null,"Rohbau 1",null,"BKP 21"]
[null,"Rohbau 2",null,"BKP 22"]
[null,"Elektroanlagen",null,"BKP 23"]
[null,"HLK-Anlagen",null,"BKP 24"]
[null,"Sanitäranlagen",null,"BKP 25"]
[null,"Transportanlagen",null,"BKP 26"]
[null,"Ausbau 1",null,"BKP 27"]
[null,"Ausbau 2",null,"BKP 28"]
[null,"Honorare",null,"BKP 29"]
[null,"Gebäude ",null,"BKP 2",null,{"$f":"SUM(F64:G73)","v":0},null,null,"CHF",{"$f":"IFERROR(J62/F62*F74,0)","v":{"v":0,"d":"0%"}}]
[null,"Betriebseinrichtungen ",null,"BKP 3",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F75,0)","v":{"v":0,"d":"0%"}}]
[null,"Umgebung",null,"BKP 4",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F76,0)","v":{"v":0,"d":"0%"}}]
[null,"Baunebenkosten ",null,"BKP 5",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F77,0)","v":{"v":0,"d":"0%"}}]
[null,"Reserve ",null,"BKP 6",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F78,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"BKP 7",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F79,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":3},"BKP 8",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F80,0)","v":{"v":0,"d":"0%"}}]
[null,"Ausstattung ",null,"BKP 9",{"$nulls":4},"CHF",{"$f":"IFERROR(J62/F62*F81,0)","v":{"v":0,"d":"0%"}}]
[null,"Kostenkennzahlen"]
[null,"BKP 2 / HNF",{"$nulls":3},{"$f":"IFERROR(F74/F40,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2 / NF",{"$nulls":3},{"$f":"IFERROR(F74/F42,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2 / GF",{"$nulls":3},{"$f":"IFERROR(F74/F33,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2 / GV",{"$nulls":3},{"$f":"IFERROR(F74/F31,0)","v":0},null,null,"CHF/m3"]
[null,"BKP 2+3 / HNF ",{"$nulls":3},{"$f":"IFERROR((F74+F75)/F40,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2+3 / NF ",{"$nulls":3},{"$f":"IFERROR((F74+F75)/F42,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2+3 / GF",{"$nulls":3},{"$f":"IFERROR((F74+F75)/F33,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 2+3 / GV ",{"$nulls":3},{"$f":"IFERROR((F74+F75)/F31,0)","v":0},null,null,"CHF/m3"]
[null,"BKP 4 / BUF ",{"$nulls":3},{"$f":"IFERROR(F76/F29,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 1-9 / HNF",{"$nulls":3},{"$f":"IFERROR(F62/F40,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 1-9 / NF",{"$nulls":3},{"$f":"IFERROR(F62/F42,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 1-9 / GF",{"$nulls":3},{"$f":"IFERROR(F62/F33,0)","v":0},null,null,"CHF/m2"]
[null,"BKP 1-9 / GV",{"$nulls":3},{"$f":"IFERROR(F62/F31,0)","v":0},null,null,"CHF/m3"]
[null,"Flächen- und Volumenkennzahlen"]
[null,"Nutzfläche / Geschossfläche",{"$nulls":3},{"$f":"IFERROR(F42/F33,0)*100","v":0},null,null,"%"]
[null,"Verkehrsfläche / Hauptnutzflächen",{"$nulls":3},{"$f":"IFERROR(F43/F40,0)*100","v":0},null,null,"%"]
[null,"Gebäudevolumen / Geschossfläche",{"$nulls":3},{"$f":"IFERROR(F31/F33,0)","v":{"v":0,"d":"0.00"}}]
[null,"Gebäudehüllfläche / Gebäudevolumen",{"$nulls":3},{"$f":"IFERROR(F48/F31,0)","v":{"v":0,"d":"0.00"}}]
[null,"Dokumente"]
[]
[]
[null,"Sämtliche monetären Grössen sind inkl. MwSt."]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}