{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Beilage 2.1","Beilage 2.2","Beilage 2.3","Beilage 2.4"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Beilage 2.1","index":0,"n_rows":96,"n_cols":18,"rows_kept":96,"merged":[[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[9,12,10,12],[9,13,10,13],[9,14,10,14],[9,15,10,15],[9,16,10,16],[9,17,10,17],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[28,10,29,10],[28,12,29,12],[28,13,29,13],[28,14,29,14],[28,15,29,15],[28,16,29,16],[28,17,29,17],[48,3,49,3],[48,4,49,4],[48,5,49,5],[48,6,49,6],[48,7,49,7],[48,8,49,8],[48,9,49,9],[48,10,49,10],[48,12,49,12],[48,13,49,13],[48,14,49,14],[48,15,49,15],[48,16,49,16],[48,17,49,17],[67,3,68,3],[67,4,68,4],[67,5,68,5],[67,6,68,6],[67,7,68,7],[67,8,68,8],[67,9,68,9],[67,10,68,10],[67,12,68,12],[67,13,68,13],[67,14,68,14],[67,15,68,15],[67,16,68,16],[67,17,68,17],[90,3,91,3],[90,4,91,4],[90,5,91,5],[90,6,91,6],[90,7,91,7],[90,8,91,8],[90,9,91,9],[90,10,91,10],[90,12,91,12],[90,13,91,13],[90,14,91,14],[90,15,91,15],[90,16,91,16],[90,17,91,17],[93,4,93,9]]}
[null,"Bahnhofareal Erlenbach",null,"VERSION 17.01.2020",{"$nulls":6},"Beilage 2.1"]
[{"$nulls":10},"vom Anbieter auszufüllen"]
[null,"Berechnung der GP-Honorare",{"$nulls":8},"Berechnung der aufwandbestimmenden Baukosten gemäss Beilage 2.2"]
[null,"Offerte",{"$nulls":8},"alle übrigen Werte und Beträge sind fix oder werden automatisch berechnet"]
[null,"Vorsicht: Dokument beinhaltet 4 Arbeitsmappen"]
[]
[null,"Statistische Koeffizienten SIA (2018; 0.5 Quantil)",null,"Z1",{"v":0.04452,"d":"0.045"},{"v":0.04899,"d":"0.049"},{"v":0.07315,"d":"0.073"},{"v":0.07315,"d":"0.073"},{"v":0.07315,"d":"0.073"},{"v":0.07315,"d":"0.073"},{"v":0.06105,"d":"0.061"}]
[null,"(Es sind die aktuellesten Werte zu verwenden)",null,"Z2",{"v":12.61034,"d":"12.610"},{"v":8.86602,"d":"8.866"},9.563,9.563,9.563,9.563,{"v":9.96969,"d":"9.970"}]
[]
[{"$nulls":3},"Total \nGeneral-\nplanung","Architektur,\nGesamt-\nleitung","Bau-\nIng.","Elektro-\nIng.","HLKK-\nIng.","Sanitär-\nIng.","MSRL-\nIng.","Landschaftsarch.",null,"Fachkoordination","Nachhalti- ges Bauen","Fassaden-planer","Bauphysiker / Akustik","Brand-schutz- Planer","Förder-anlagen-Planer"]
[null,"31 Vorprojekt"]
[null,"Leistungsanteil in Prozenten (Summen gem. 2.3)",null,"q",{"$f":"SUM('Beilage 2.3'!E9:E10)","v":{"v":0.09,"d":"9.0%"}},{"$f":"'Beilage 2.3'!E30","v":{"v":0.08,"d":"8.0%"}},{"$f":"'Beilage 2.3'!E45","v":{"v":0.06,"d":"6.0%"}},{"$f":"'Beilage 2.3'!E57","v":{"v":0.1,"d":"10.0%"}},{"$f":"'Beilage 2.3'!E69","v":{"v":0.06,"d":"6.0%"}},{"$f":"'Beilage 2.3'!E81+'Beilage 2.3'!E82","v":{"v":0.09,"d":"9.0%"}},{"$f":"'Beilage 2.3'!E94","v":{"v":0.12,"d":"12.0%"}}]
[null,"Aufwandbestimmende Baukosten Grundausbau total (exkl. MwSt) 1) --> noch zu bestimmen",null,"B",{"$f":"'Beilage 2.2'!F38","v":0},{"$f":"'Beilage 2.2'!H38","v":0},{"$f":"'Beilage 2.2'!J38","v":0},{"$f":"'Beilage 2.2'!L38","v":0},{"$f":"'Beilage 2.2'!N38","v":0},{"$f":"'Beilage 2.2'!P38","v":0},{"$f":"'Beilage 2.2'!R38","v":0}]
[null,"Grundfaktor für Stundenaufwand p ",null,"p",{"$f":"(E7+E8/(E13^(1/3)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Teamfaktor i",null,"i",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Schwierigkeitsgrad n",null,"n",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Anpassungsfaktor r",null,"r",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Faktor für Sonderleistungen s",null,"s",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Total Stundenaufwand",null,{"$f":"SUM(E19:K19)","v":{"$error":"#DIV/0!"}},{"$f":"E13*E14/100*E16*E12*E17*E15*E18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Stundenansatz exkl. MwSt",null,{"$f":"SUM(E20:K20)/7","v":0},{"$nulls":8},"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Honorare Total exkl. MwSt",null,{"$f":"SUM(E21:R21)","v":{"$error":"#DIV/0!"}},{"$f":"E19*E20","v":{"$error":"#DIV/0!"}},{"$f":"+F19*F20","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Beilage 2.4'!F7","v":0},{"$f":"'Beilage 2.4'!L7","v":0},{"$f":"'Beilage 2.4'!F20","v":0},{"$f":"'Beilage 2.4'!L20","v":0},{"$f":"'Beilage 2.4'!F33","v":0},{"$f":"'Beilage 2.4'!L33","v":0}]
[null,"Entschädigung Gesamtleitung (%)",null,{"v":0.03,"d":"3%"},{"$f":"D22","v":{"v":0.03,"d":"3%"}}]
[null,"Entschädigung Gesamtleitung (CHF)",null,{"$f":"SUM(E23:R23)","v":{"$error":"#DIV/0!"}},{"$f":"E21*E22","v":{"$error":"#DIV/0!"}}]
[null,"Rabatt (%)",null,{"v":0,"d":"0%"},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},{"$f":"D24","v":{"v":0,"d":"0%"}},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Rabatt (CHF)",null,{"$f":"SUM(E25:N25)","v":{"$error":"#DIV/0!"}},{"$f":"-SUM(E21,E23)*E24","v":{"$error":"#DIV/0!"}},{"$f":"-F21*F24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"-M21*M24","v":0},0,0,0,0,0]
[null,"Honorare netto exkl. MwSt",null,{"$f":"SUM(E26:R26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E21,E23,E25)","v":{"$error":"#DIV/0!"}},{"$f":"+F21+F25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"+M21+M25","v":0},0,0,0,0,0]
[]
[]
[{"$nulls":3},"Total \nGeneral-\nplanung","Architektur,\nGesamt-\nleitung","Bau-\nIng.","Elektro-\nIng.","HLKK-\nIng.","Sanitär-\nIng.","MSRL-\nIng.","Landschaftsarch.",null,"Fachkoordination","Nachhalti- ges Bauen","Fassaden-planer","Bauphysiker / Akustik","Brandschutz- Planer","Förderanlagen-Planer"]
[null,"32, 33 Bauprojekt, Bewilligungsverfahren"]
[null,"Leistungsanteil in Prozenten (Summen gem. 2.3)",null,"q",{"$f":"SUM('Beilage 2.3'!E11:E14)","v":{"v":0.23,"d":"23.0%"}},{"$f":"SUM('Beilage 2.3'!E31:E32)","v":{"v":0.24,"d":"24.0%"}},{"$f":"SUM('Beilage 2.3'!E46:E47)","v":{"v":0.18,"d":"18.0%"}},{"$f":"SUM('Beilage 2.3'!E58:E59)","v":{"v":0.2,"d":"20.0%"}},{"$f":"SUM('Beilage 2.3'!E70:E71)","v":{"v":0.2,"d":"20.0%"}},{"$f":"SUM('Beilage 2.3'!E83:E84)","v":{"v":0.2,"d":"20.0%"}},{"$f":"SUM('Beilage 2.3'!E95:E96)","v":{"v":0.205,"d":"20.5%"}}]
[null,"Aufwandbestimmende Baukosten Grundausbau total (exkl. MwSt) 1) --> noch zu bestimmen",null,"B",{"$f":"+E13","v":0},0,0,0,0,0,0]
[null,"Grundfaktor für Stundenaufwand p ",null,"p",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Teamfaktor i",null,"i",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Schwierigkeitsgrad n",null,"n",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Anpassungsfaktor r",null,"r",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Faktor für Sonderleistungen s",null,"s",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Total Stundenaufwand",null,{"$f":"SUM(E38:K38)","v":{"$error":"#DIV/0!"}},{"$f":"E32*E33/100*E35*E31*E36*E34*E37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Stundenansatz exkl. MwSt",null,{"$f":"SUM(E39:K39)/7","v":0},{"$nulls":8},"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Honorare Total exkl. MwSt",null,{"$f":"SUM(E40:R40)","v":{"$error":"#DIV/0!"}},{"$f":"E38*E39","v":{"$error":"#DIV/0!"}},{"$f":"F38*F39","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM('Beilage 2.4'!F8:F9)","v":0},{"$f":"SUM('Beilage 2.4'!L8:L9)","v":0},{"$f":"SUM('Beilage 2.4'!F21:F22)","v":0},{"$f":"SUM('Beilage 2.4'!L21:L22)","v":0},{"$f":"SUM('Beilage 2.4'!F34:F35)","v":0},{"$f":"SUM('Beilage 2.4'!L34:L35)","v":0}]
[null,"Entschädigung Gesamtleitung (%)",null,{"v":0.03,"d":"3%"},{"$f":"D41","v":{"v":0.03,"d":"3%"}}]
[null,"Entschädigung Gesamtleitung (CHF)",null,{"$f":"SUM(E42:R42)","v":{"$error":"#DIV/0!"}},{"$f":"E40*E41","v":{"$error":"#DIV/0!"}}]
[null,"Rabatt (%)",null,{"v":0,"d":"0%"},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},{"$f":"D43","v":{"v":0,"d":"0%"}},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Rabatt (CHF)",null,{"$f":"SUM(E44:N44)","v":{"$error":"#DIV/0!"}},{"$f":"-SUM(E40,E42)*E43","v":{"$error":"#DIV/0!"}},{"$f":"-F40*F43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"-M40*M43","v":0},0,0,0,0,0]
[null,"Honorare netto exkl. MwSt",null,{"$f":"SUM(E45:R45)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E40,E42,E44)","v":{"$error":"#DIV/0!"}},{"$f":"+F40+F44","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"+M40+M44","v":0},0,0,0,0,0]
[null,"1) aufwandbestimmende Baukosten vom xx.xx.xxxx"]
[]
[]
[{"$nulls":3},"Total \nGeneral-\nplanung","Architektur,\nGesamt-\nleitung","Bau-\nIng.","Elektro-\nIng.","HLKK-\nIng.","Sanitär-\nIng.","MSRL-\nIng.","Landschaftsarch.",null,"Fachkoordination","Nachhalti- ges Bauen","Fassaden-planer","Bauphysiker / Akustik","Brandschutz- Planer","Förderanlagen-Planer"]
[null,"41 Ausschreibung"]
[null,"Leistungsanteil in Prozenten (Summen gem. 2.3)",null,"q",{"$f":"SUM('Beilage 2.3'!E15:E16)","v":{"v":0.14,"d":"14.0%"}},{"$f":"'Beilage 2.3'!E33","v":{"v":0.06,"d":"6.0%"}},{"$f":"'Beilage 2.3'!E48","v":{"v":0.17,"d":"17.0%"}},{"$f":"'Beilage 2.3'!E60","v":{"v":0.19,"d":"19.0%"}},{"$f":"'Beilage 2.3'!E72","v":{"v":0.19,"d":"19.0%"}},{"$f":"'Beilage 2.3'!E85","v":{"v":0.22,"d":"22.0%"}},{"$f":"'Beilage 2.3'!E97","v":{"v":0.14,"d":"14.0%"}}]
[null,"Aufwandbestimmende Baukosten Grundausbau total (exkl. MwSt) 1) --> noch zu bestimmen",null,"B",{"$f":"+E32","v":0},{"$f":"+F32","v":0},0,0,0,0,0]
[null,"Grundfaktor für Stundenaufwand p ",null,"p",{"$f":"+E14","v":{"$error":"#DIV/0!"}},{"$f":"+F14","v":{"$error":"#DIV/0!"}},{"$f":"+G14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Teamfaktor i",null,"i",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Schwierigkeitsgrad n",null,"n",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Anpassungsfaktor r",null,"r",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Faktor für Sonderleistungen s",null,"s",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Total Stundenaufwand",null,{"$f":"SUM(E58:K58)","v":{"$error":"#DIV/0!"}},{"$f":"E52*E53/100*E55*E51*E56*E54*E57","v":{"$error":"#DIV/0!"}},{"$f":"F52*F53/100*F55*F51*F56*F54*F57","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Stundenansatz exkl. MwSt",null,{"$f":"SUM(E59:K59)/7","v":0},{"$nulls":8},"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Honorare Total exkl. MwSt",null,{"$f":"SUM(E60:R60)","v":{"$error":"#DIV/0!"}},{"$f":"+E58*E59","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM('Beilage 2.4'!F10)","v":0},{"$f":"SUM('Beilage 2.4'!L10)","v":0},{"$f":"SUM('Beilage 2.4'!F23)","v":0},{"$f":"SUM('Beilage 2.4'!L23)","v":0},{"$f":"SUM('Beilage 2.4'!F36)","v":0},{"$f":"SUM('Beilage 2.4'!L36)","v":0}]
[null,"Entschädigung Gesamtleitung (%)",null,{"v":0.03,"d":"3%"},{"$f":"D61","v":{"v":0.03,"d":"3%"}}]
[null,"Entschädigung Gesamtleitung (CHF)",null,{"$f":"SUM(E62:R62)","v":{"$error":"#DIV/0!"}},{"$f":"E60*E61","v":{"$error":"#DIV/0!"}}]
[null,"Rabatt (%)",null,{"v":0,"d":"0%"},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},{"$f":"D63","v":{"v":0,"d":"0%"}},null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Rabatt (CHF)",null,{"$f":"SUM(E64:N64)","v":{"$error":"#DIV/0!"}},{"$f":"-SUM(E60,E62)*E63","v":{"$error":"#DIV/0!"}},{"$f":"-F60*F63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"-M60*M63","v":0},0,0,0,0,0]
[null,"Honorare netto exkl. MwSt",null,{"$f":"SUM(E65:R65)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E60,E62,E64)","v":{"$error":"#DIV/0!"}},{"$f":"+F60+F64","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"+M60+M64","v":0},0,0,0,0,0]
[]
[]
[{"$nulls":3},"Total \nGeneral-\nplanung","Architektur,\nGesamt-\nleitung","Bau-\nIng.","Elektro-\nIng.","HLKK-\nIng.","Sanitär-\nIng.","MSRL-\nIng.","Landschaftsarch.",null,"Fachkoordination","Nachhalti- ges Bauen","Fassaden-planer","Bauphysiker / Akustik","Brandschutz- Planer","Förderanlagen-Planer"]
[null,"51, 52, 53 Ausführung, Projektabschluss"]
[null,"Leistungsanteil in Prozenten (Summen gem. 2.3)",null,"q",{"$f":"SUM('Beilage 2.3'!E17:E24)","v":{"v":0.22,"d":"22.0%"}},{"$f":"SUM('Beilage 2.3'!E34:E39)","v":{"v":0.5650000000000001,"d":"56.5%"}},{"$f":"SUM('Beilage 2.3'!E49:E51)","v":{"v":0.5,"d":"50.0%"}},{"$f":"SUM('Beilage 2.3'!E61:E63)","v":{"v":0.42,"d":"42.0%"}},{"$f":"SUM('Beilage 2.3'!E73:E75)","v":{"v":0.45999999999999996,"d":"46.0%"}},{"$f":"SUM('Beilage 2.3'!E86:E88)","v":{"v":0.39,"d":"39.0%"}},{"$f":"SUM('Beilage 2.3'!E98:E100)","v":{"v":0.45999999999999996,"d":"46.0%"}}]
[null,"Aufwandbestimmende Baukosten Grundausbau total (exkl. MwSt) 1) --> noch zu bestimmen",null,"B",{"$f":"E52","v":0},{"$f":"F52","v":0},0,0,0,0,0]
[null,"Grundfaktor für Stundenaufwand p ",null,"p",{"$f":"+E14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Teamfaktor i",null,"i",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Schwierigkeitsgrad n",null,"n",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Anpassungsfaktor r",null,"r",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Faktor für Sonderleistungen s",null,"s",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Total Stundenaufwand",null,{"$f":"SUM(E77:K77)","v":{"$error":"#DIV/0!"}},{"$f":"E71*E72/100*E74*E70*E75*E73*E76","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Stundenansatz exkl. MwSt",null,{"$f":"SUM(E78:K78)/7","v":0},{"$nulls":8},"pauschal","pauschal","pauschal","pauschal","pauschal","pauschal"]
[null,"Honorare Total exkl. MwSt",null,{"$f":"SUM(E79:R79)","v":{"$error":"#DIV/0!"}},{"$f":"+E77*E78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM('Beilage 2.4'!F11:F13)","v":0},{"$f":"SUM('Beilage 2.4'!L11:L13)","v":0},{"$f":"SUM('Beilage 2.4'!F24:F26)","v":0},{"$f":"SUM('Beilage 2.4'!L24:L26)","v":0},{"$f":"SUM('Beilage 2.4'!F37:F39)","v":0},{"$f":"SUM('Beilage 2.4'!L37:L39)","v":0}]
[null,"Abzug Entfall Übergeordnete Gesamtleitung",null,{"$f":"E80","v":0}]
[null,"Zwischensumme exkl. MwSt.",null,{"$f":"SUM(D79-D80)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E79,E80)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"SUM(M79-M80)","v":0},{"$f":"SUM(N79-N80)","v":0},0,0,0,0]
[null,"Entschädigung Gesamtleitung (%)",null,{"v":0,"d":"0%"},{"$f":"D82","v":{"v":0,"d":"0%"}}]
[null,"Entschädigung Gesamtleitung (CHF)",null,{"$f":"SUM(E83:R83)","v":{"$error":"#DIV/0!"}},{"$f":"E81*E82","v":{"$error":"#DIV/0!"}}]
[null,"Rabatt (%)",null,{"v":0,"d":"0%"},{"$f":"D84","v":{"v":0,"d":"0%"}},{"$f":"D84","v":{"v":0,"d":"0%"}},{"$f":"D84","v":{"v":0,"d":"0%"}},{"$f":"D84","v":{"v":0,"d":"0%"}},{"$f":"E84","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,{"$f":"$D$84","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Rabatt (CHF)",null,{"$f":"(D81*D84)","v":{"$error":"#DIV/0!"}},{"$f":"-SUM(E81,E83)*E84","v":{"$error":"#DIV/0!"}},{"$f":"-(F81*F84)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"(M81*M84)","v":0},0,0,0,0,0]
[null,"Honorare netto exkl. MwSt",null,{"$f":"SUM(E86:R86)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E81,E83,E85)","v":{"$error":"#DIV/0!"}},{"$f":"F81-F85","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M81-M85","v":0},0,0,0,0,0]
[]
[]
[]
[]
[{"$nulls":3},"Total \nGeneral-\nplanung","Architektur,\nGesamt-\nleitung","Bau-\nIng.","Elektro-\nIng.","HLKK-\nIng.","Sanitär-\nIng.","MSRL-\nIng.","Landschaftsarch.",null,"Nachhalti- ges Bauen","Nachhalti- ges Bauen","Fassaden-planer","Bauphysiker / Akustik","Brandschutz- Planer","Förderanlagen-Planer"]
[null,"Zusammenfassung"]
[null,"Total Honorare netto exkl. MwSt",null,{"$f":"SUM(E93:R93)","v":{"$error":"#DIV/0!"}},{"$f":"E26+E45+E65+E86","v":{"$error":"#DIV/0!"}},{"$f":"F26+F45+F65+F86","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"M26+M45+M65+M86","v":0},0,0,0,0,0]
[null,"evtl. Überarbeitung Wettbewerbsprojekt",null,0,"Zeitraum xx.xx.xxx"]
[null,"Total Honorare",null,{"$f":"+D93+D94","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B46","v":"1) aufwandbestimmende Baukosten vom xx.xx.xxxx"}]

{"sheet":"Beilage 2.2","index":1,"n_rows":41,"n_cols":20,"rows_kept":41,"merged":[[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[13,16,13,17]]}
[null,{"$f":"'Beilage 2.1'!B1","v":"Bahnhofareal Erlenbach"},{"$nulls":17},"Beilage 2.2"]
[]
[null,"Berechnung der aufwandbestimmenden Baukosten"]
[]
[null,"Anrechnung aufwandbestimmender Baukosten (in Abweichung zu Ordnungen SIA 102, 103, 105, 108)"]
[]
[null,"Grundsatz Anrechnung der aufwandbestimmenden Baukosten (Architektur): "]
[]
[null,{"v":1,"d":"100%"},"Verantwortung für Planung, Termine und Kosten beim  Architekten ohne Unterstützung durch den Fachplaner  (exkl. Bauingenieur)"]
[null,{"v":0.67,"d":"67%"},"Verantwortung für Planung, Termine und Kosten beim Architekten mit Unterstützung durch den Fachplaner"]
[null,{"v":0.33,"d":"33%"},"Verantwortung für Planung, Termine und Kosten beim  Fachplaner mit Planungskoordination durch den Architekten\n"]
[null,{"v":0,"d":"0%"},"Verantwortung für Planung, Termine und Kosten beim Fachplaner, bzw. keine Aufgaben durch den Architekten"]
[]
[null,"BKP","Arbeitsgattung","Aufwandsbestimmende Baukosten","Architektur",null,"Bauingenieur",null,"Elektro-Ingenieur",null,"HLKK-\nIngenieur",null,"Sanitär-\nIngenieur",null,"MSRL-\nIngenieur",null,"Landschafts-architektur",null,null,"Begründung / Voraussetzung für Prozentsatz bei Architekt"]
[null,10,"Bestandsaufnahmen, Baugrunduntersuchungen",null,{"v":0.33,"d":"33%"},{"$f":"IF(AND(E15>0,ISNUMBER(E15)),$D15*E15,\"\")","v":0},{"v":0,"d":"0%"},{"$f":"IF(AND(G15>0,ISNUMBER(G15)),$D15*G15,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(I15>0,ISNUMBER(I15)),$D15*I15,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(K15>0,ISNUMBER(K15)),$D15*K15,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(M15>0,ISNUMBER(M15)),$D15*M15,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(O15>0,ISNUMBER(O15)),$D15*O15,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(Q15>0,ISNUMBER(Q15)),$D15*Q15,\"\")","v":""},null,"Arbeiten erfolgen durch externen Spezialisten (Geologie, Altlasten etc.)"]
[null,11,"Abbrüche und Räumungen",null,"*)",{"$f":"IF(AND(E16>0,ISNUMBER(E16)),$D16*E16,\"\")","v":""},"*)",{"$f":"IF(AND(G16>0,ISNUMBER(G16)),$D16*G16,\"\")","v":""},null,{"$f":"IF(AND(I16>0,ISNUMBER(I16)),$D16*I16,\"\")","v":""},null,{"$f":"IF(AND(K16>0,ISNUMBER(K16)),$D16*K16,\"\")","v":""},null,{"$f":"IF(AND(M16>0,ISNUMBER(M16)),$D16*M16,\"\")","v":""},null,{"$f":"IF(AND(O16>0,ISNUMBER(O16)),$D16*O16,\"\")","v":""},{"v":0,"d":"0%"},{"$f":"IF(AND(Q16>0,ISNUMBER(Q16)),$D16*Q16,\"\")","v":""},null,"Aufteilung zwischen Arch. und Bauing. je nach Situation, zusammen max 100%"]
[null,12,"Sicherungen, Provisorien",null,"*)",{"$f":"IF(AND(E17>0,ISNUMBER(E17)),$D17*E17,\"\")","v":""},"*)","",null,"",null,"",null,"",null,"",{"v":0,"d":"0%"},"",null,"Aufteilung zwischen Arch. und Bauing. je nach Situation, zusammen max 100%"]
[null,13,"Baustelleneinrichtungen",null,"*)","","*)","",null,"",null,"",null,"",null,"",{"v":0,"d":"0%"},"",null,"Aufteilung zwischen Arch. und Bauing. je nach Situation, zusammen max 100%"]
[null,"14-16","Anpassungen an bestehende Bauten",null,"*)","","*)","","*)","","*)","","*)","","*)","",{"v":0,"d":"0%"},"",null,"Aufteilung zwischen Arch. und Bauing. je nach Situation, zusammen max 100%"]
[null,17,"Spezialtiefbau",null,{"v":0.33,"d":"33%"},0,{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},{"$f":"IF(AND(K20>0,ISNUMBER(K20)),$D20*K20,\"\")","v":""},{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",null,"Verantwortung für Pfählung + Baugrubenabschlüsse liegen beim Bauingenieur"]
[null,20,"Aushub",null,{"v":0.33,"d":"33%"},0,{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",null,"Anpassung je nach Komplexität der Situation, Gleisnähe und/oder innerstädtischer Lage."]
[null,21,"Rohbau 1",null,{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,null,"davon Tragkonstruktion",null,null,"",{"v":1,"d":"100%"},0,null,"",null,"",null,"",null,"",null,""]
[null,null,"davon Befestigungen Fassade",null,null,"",{"v":1,"d":"100%"},0,null,"",null,"",null,"",null,"",null,""]
[null,22,"Rohbau 2",null,{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,null,"davon Abdichtungen UG",null,null,"",{"v":1,"d":"100%"},0,null,"",null,"",null,"",null,"",null,"",null,"Der Bauingenieur ist honorarberechtigt für die beplanten Bauteile \n(insb. unterirdische Bauten sowie Abdichtungen im Beton). "]
[null,23,"Elektroanlagen",null,{"v":0.67,"d":"67%"},0,{"v":0,"d":"0%"},"",{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,"241-248","HLKK-Anlagen",null,{"v":0.67,"d":"67%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,249,"MSRL-System",null,{"v":0.33,"d":"33%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},""]
[null,25,"Sanitäranlagen",null,{"v":0.67,"d":"67%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,26,"Transportanlagen",null,{"v":0.67,"d":"67%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",null,"Planung erfolgt in der Regel durch Unternehmer. Bei Beizug eines Förderanlagenplaners reduziert sich der Anteil des Architekten auf 33%"]
[null,"27-28","Ausbau 1 + 2 ",null,{"v":1,"d":"100%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,3,"Betriebseinrichtungen",null,"*)","","*)","","*)","","*)","","*)","","*)","","*)",{"$f":"IF(AND(Q33>0,ISNUMBER(Q33)),$D33*Q33,\"\")","v":""}]
[null,4,"Umgebung",null,{"v":0.33,"d":"33%"},0,"*)","","*)","","*)","","*)","","*)","",{"v":1,"d":"100%"},{"$f":"IF(AND(Q34>0,ISNUMBER(Q34)),$D34*Q34,\"\")","v":0}]
[null,5,"Baunebenkosten",null,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},""]
[null,9,"Ausstattung",null,{"v":0.67,"d":"67%"},0,{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",{"v":0,"d":"0%"},"",null,"Wird durch die SBB ein Innenarchitekt beigezogen, ist der Architekt für die Ausstattung nur zu 33% honorarberechtigt. "]
[null,"19,29,49","Honorare (werden berechnet)",{"$f":"'Beilage 2.1'!D95","v":{"$error":"#DIV/0!"}},{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"}]
[null,null,"TOTAL",{"$f":"D37+D36+D35+D34+D33+D32+D31+D30+D29+D28+D27+D25+D22+D21+D20+D19+D18+D17+D16+D15","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F15:F37)","v":0},null,{"$f":"SUM(H15:H37)","v":0},null,{"$f":"SUM(J15:J37)","v":0},null,{"$f":"SUM(L15:L37)","v":0},null,{"$f":"SUM(N15:N37)","v":0},null,{"$f":"SUM(P15:P37)","v":0},null,{"$f":"SUM(R15:R37)","v":0}]
[]
[]
[null,"*)","Je nach Projekt, sofern Leistung erbracht wird. Gesamthaft in der Regel nicht mehr als 100%."]

{"sheet":"Beilage 2.3","index":2,"n_rows":101,"n_cols":6,"rows_kept":101,"merged":[[14,1,15,1],[20,1,23,1],[80,3,81,3],[80,4,81,4],[82,3,83,3],[82,4,83,4]]}
[null,{"$f":"'Beilage 2.1'!B1","v":"Bahnhofareal Erlenbach"},{"$nulls":3},"Beilage 2.3"]
[]
[null,"Festlegung der Teilleistungsprozente"]
[null,"TU-Modell"]
[]
[null,"Architekturleistungen (Basis SIA 102)"]
[]
[null,"Teilphasen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt","Studium von Lösungsmöglichkeiten und Grobschätzung der Baukosten",{"v":0.03,"d":"3.0%"},{"v":0.03,"d":"3.0%"},"Bei Vorliegen eines Wettbewerbsresultats 1.5%, sonst 3%"]
[null,null,"Vorprojekt und Kostenschätzung",{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"}]
[null,"32 Bauprojekt","Bauprojekt",{"v":0.13,"d":"13.0%"},{"v":0.13,"d":"13.0%"}]
[null,null,"Detailstudien",{"v":0.04,"d":"4.0%"},{"v":0.04,"d":"4.0%"}]
[null,null,"Kostenvoranschlag",{"v":0.04,"d":"4.0%"},{"v":0.04,"d":"4.0%"}]
[null,"33 Bewilligungsverfahren","Bewilligungsverfahren",{"v":0.025,"d":"2.5%"},{"v":0.02,"d":"2.0%"},"Mitwirkung TU"]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag","Ausschreibungspläne",{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"}]
[null,null,"Ausschreibung und Vergabe",{"v":0.08,"d":"8.0%"},{"v":0.04,"d":"4.0%"}]
[null,"51 Ausführungsplanung","Ausführungspläne",{"v":0.15,"d":"15.0%"},{"v":0.15,"d":"15.0%"}]
[null,null,"Werkverträge",{"v":0.01,"d":"1.0%"},{"v":0,"d":"0.0%"},"Wird durch TU geleistet"]
[null,"52 Ausführung","Gestalterische Leitung",{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"}]
[null,null,"Bauleitung und Kostenkontrolle",{"v":0.23,"d":"23.0%"},{"v":0,"d":"0.0%"},"Wird durch TU geleistet"]
[null,"53 Inbetriebnahme, Abschluss","Inbetriebnahme",{"v":0.01,"d":"1.0%"},{"v":0.005,"d":"0.5%"},"Mitwirkung TU"]
[null,null,"Dokumentation über das Bauwerk",{"v":0.01,"d":"1.0%"},{"v":0.005,"d":"0.5%"},"Teil der Revisionspläne bei TU"]
[null,null,"Leitung der Garantiearbeiten",{"v":0.015,"d":"1.5%"},{"v":0,"d":"0.0%"},"Wird durch TU geleistet"]
[null,null,"Schlussabrechnung",{"v":0.01,"d":"1.0%"},{"v":0,"d":"0.0%"},"Wird durch TU geleistet"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D9:D24)","v":{"v":1,"d":"100.0%"}},{"$f":"SUM(E9:E24)","v":{"v":0.6799999999999999,"d":"68.0%"}}]
[]
[null,"Bauingenieurleistungen (SIA 103)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"}]
[null,"32 Bauprojekt",null,{"v":0.22,"d":"22.0%"},{"v":0.22,"d":"22.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt",null,{"v":0.02,"d":"2.0%"},{"v":0.02,"d":"2.0%"}]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.1,"d":"10.0%"},{"v":0.06,"d":"6.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"5 Realisierung","51 Ausführungsprojekt",{"v":0.18,"d":"18.0%"},{"v":0.18,"d":"18.0%"}]
[null,null,"Zuschlag für Anteil Tragkonstuktion",{"v":0.3,"d":"30.0%"},{"v":0.3,"d":"30.0%"}]
[null,"52 Ausführung","allg. Bauleitung",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[null,null,"techn. Bauleitung",{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"}]
[null,null,"Baukontrolle",{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"}]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.03,"d":"3.0%"},{"v":0.015,"d":"1.5%"},"Anteil bei TU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D30:D39)","v":{"v":1.0000000000000002,"d":"100.0%"}},{"$f":"SUM(E30:E39)","v":{"v":0.9450000000000002,"d":"94.5%"}}]
[]
[null,"Leistungen Elektro-Ingenieur (SIA 108)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"}]
[null,"32 Bauprojekt",null,{"v":0.18,"d":"18.0%"},{"v":0.18,"d":"18.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt"]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.21,"d":"21.0%"},{"v":0.17,"d":"17.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"51 Ausführungsprojekt",null,{"v":0.45,"d":"45.0%"},{"v":0.45,"d":"45.0%"}]
[null,"52 Ausführung"]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.1,"d":"10.0%"},{"v":0.05,"d":"5.0%"},"Anteil bei TU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D45:D51)","v":{"v":0.9999999999999999,"d":"100.0%"}},{"$f":"SUM(E45:E51)","v":{"v":0.9100000000000001,"d":"91.0%"}}]
[]
[null,"Leistungen HLKK-Ingenieur (SIA 108)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"}]
[null,"32 Bauprojekt",null,{"v":0.2,"d":"20.0%"},{"v":0.2,"d":"20.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt"]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.23,"d":"23.0%"},{"v":0.19,"d":"19.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"51 Ausführungsprojekt",null,{"v":0.37,"d":"37.0%"},{"v":0.37,"d":"37.0%"}]
[null,"52 Ausführung"]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.1,"d":"10.0%"},{"v":0.05,"d":"5.0%"},"Anteil bei TU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D57:D63)","v":{"v":1,"d":"100.0%"}},{"$f":"SUM(E57:E63)","v":{"v":0.9100000000000001,"d":"91.0%"}}]
[]
[null,"Leistungen Sanitär-Ingenieur (SIA 108)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"}]
[null,"32 Bauprojekt",null,{"v":0.2,"d":"20.0%"},{"v":0.2,"d":"20.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt"]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.23,"d":"23.0%"},{"v":0.19,"d":"19.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"51 Ausführungsprojekt",null,{"v":0.41,"d":"41.0%"},{"v":0.41,"d":"41.0%"}]
[null,"52 Ausführung"]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.1,"d":"10.0%"},{"v":0.05,"d":"5.0%"},"Anteil bei TU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D69:D75)","v":{"v":0.9999999999999999,"d":"100.0%"}},{"$f":"SUM(E69:E75)","v":{"v":0.91,"d":"91.0%"}}]
[]
[null,"Leistungen MSRL-Technik (SIA 108)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"}]
[]
[null,"32 Bauprojekt",null,{"v":0.2,"d":"20.0%"},{"v":0.2,"d":"20.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt"]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.26,"d":"26.0%"},{"v":0.22,"d":"22.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"51 Ausführungsprojekt",null,{"v":0.2,"d":"20.0%"},{"v":0.2,"d":"20.0%"}]
[null,"52 Ausführung",null,{"v":0.13,"d":"13.0%"},{"v":0.13,"d":"13.0%"}]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.12,"d":"12.0%"},{"v":0.06,"d":"6.0%"},"Anteil bei GU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D81:D88)","v":{"v":1,"d":"100.0%"}},{"$f":"SUM(E81:E88)","v":{"v":0.8999999999999999,"d":"90.0%"}}]
[]
[null,"Leistungen Landschaftsarchitektur (SIA 105)"]
[]
[null,"Teilphassen",null,"SIA","Vertrag"]
[null,"31 Vorprojekt",null,{"v":0.12,"d":"12.0%"},{"v":0.12,"d":"12.0%"}]
[null,"32 Bauprojekt",null,{"v":0.18,"d":"18.0%"},{"v":0.18,"d":"18.0%"}]
[null,"33 Bewilligungsverfahren, Auflageprojekt",null,{"v":0.025,"d":"2.5%"},{"v":0.025,"d":"2.5%"}]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",null,{"v":0.18,"d":"18.0%"},{"v":0.14,"d":"14.0%"},"Nur Ausschreibungsunterlagen (Detailausschreibung), keine Ausschreibung, kein Offertvergleich"]
[null,"51 Ausführungsprojekt",null,{"v":0.16,"d":"16.0%"},{"v":0.15,"d":"15.0%"},"nur Ausführungspläne"]
[null,"52 Ausführung",null,{"v":0.29,"d":"29.0%"},{"v":0.29,"d":"29.0%"}]
[null,"53 Inbetriebnahme Abschluss",null,{"v":0.045,"d":"4.5%"},{"v":0.02,"d":"2.0%"},"Anteil bei TU"]
[null,"Total Leistungen des GP-Vertrags",null,{"$f":"SUM(D94:D100)","v":{"v":1,"d":"100.0%"}},{"$f":"SUM(E94:E100)","v":{"v":0.925,"d":"92.5%"}}]

{"sheet":"Beilage 2.4","index":3,"n_rows":40,"n_cols":12,"rows_kept":40}
[null,{"$f":"'Beilage 2.1'!B1","v":"Bahnhofareal Erlenbach"},{"$nulls":9},"Beilage 2.4"]
[]
[null,"Offerte Leistungen Fachkoordination Gebäudetechnik",{"$nulls":5},"Offerte Leistungen Experte für nachhaltiges Bauen"]
[null,"exkl. MwSt.",{"$nulls":5},"exkl. MwSt."]
[]
[null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total",null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total"]
[null,"31 Vorprojekt",{"$nulls":3},{"$f":"D7*E7","v":{"v":0,"d":"0.00"}},null,"31 Vorprojekt",{"$nulls":3},{"$f":"J7*K7","v":{"v":0,"d":"0.00"}}]
[null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"},null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"},null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"},null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"},null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"},null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"},null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Total ",null,{"$f":"SUM(D7:D13)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(E7:E13))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F7:F13)","v":{"v":0,"d":"0.00"}},null,"Total ",null,{"$f":"SUM(J7:J13)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(K7:K13))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L7:L13)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Offerte Leistungen Fassadenplaner",{"$nulls":5},"Offerte Leistungen Bauphysiker / Akustik"]
[null,"exkl. MwSt.",{"$nulls":5},"exkl. MwSt."]
[]
[null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total",null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total"]
[null,"31 Vorprojekt",{"$nulls":3},{"$f":"D20*E20","v":{"v":0,"d":"0.00"}},null,"31 Vorprojekt",{"$nulls":3},{"$f":"J20*K20","v":{"v":0,"d":"0.00"}}]
[null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"},null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"},null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"},null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"},null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"},null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"},null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Total ",null,{"$f":"SUM(D20:D26)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(E20:E26))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F20:F26)","v":{"v":0,"d":"0.00"}},null,"Total ",null,{"$f":"SUM(J20:J26)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(K20:K26))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L20:L26)","v":{"v":0,"d":"0.00"}}]
[]
[null,"Offerte Leistungen Brandschutzplaner",{"$nulls":5},"Offerte Leistungen Spezialist"]
[null,"exkl. MwSt.",{"$nulls":5},"exkl. MwSt."]
[]
[null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total",null,"Teilphasen","Beschrieb der Leistungen","Stunden-aufwand h","Stundenansatz CHF/h","Total"]
[null,"31 Vorprojekt",{"$nulls":3},{"$f":"D33*E33","v":{"v":0,"d":"0.00"}},null,"31 Vorprojekt",{"$nulls":3},{"$f":"J33*K33","v":{"v":0,"d":"0.00"}}]
[null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"},null,"32 Bauprojekt",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"},null,"33 Bewilligungsverfahren",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"},null,"41 Ausschreibung, Offertvergleich, Vergabeantrag",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"},null,"51 Ausführungsplanung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"},null,"52 Ausführung",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"},null,"53 Inbetriebnahme, Abschluss",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"Total ",null,{"$f":"SUM(D33:D39)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(E33:E39))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F33:F39)","v":{"v":0,"d":"0.00"}},null,"Total ",null,{"$f":"SUM(J33:J39)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(K33:K39))/7","v":{"v":0,"d":"0.00"}},{"$f":"SUM(L33:L39)","v":{"v":0,"d":"0.00"}}]