{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Diagramm1","Honorarberechnung"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Diagramm1","index":0,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Honorarberechnung","index":1,"n_rows":265,"n_cols":11,"rows_kept":265,"cut":false,"hidden":false,"merged":[[22,3,22,5],[22,6,22,10],[23,3,23,5],[23,6,23,10],[246,3,246,7],[24,3,24,5],[24,6,24,10],[25,3,25,5],[25,6,25,10],[26,3,26,5],[26,6,26,10],[212,3,212,10],[215,3,215,10],[216,3,216,10],[217,3,217,10],[221,4,221,8],[8,3,8,8],[16,3,16,10],[17,3,17,10],[21,3,21,5],[21,6,21,10],[3,3,3,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[7,3,7,8],[191,3,191,7],[249,6,249,7],[243,6,243,7],[237,6,237,7],[62,3,62,7],[152,3,152,7],[163,3,163,7],[166,3,166,7],[168,3,168,7],[178,3,178,7],[183,3,183,7],[144,3,144,10],[145,3,145,10],[222,4,222,8],[223,4,223,8],[210,3,210,10],[62,9,62,10],[63,3,64,7],[63,8,64,8],[63,9,64,10],[187,3,187,7],[79,3,79,10],[80,3,80,10],[81,3,81,10],[82,3,82,10],[84,3,84,10],[83,3,83,10],[233,3,233,7],[234,3,234,7],[224,4,224,8],[225,4,225,8],[226,4,226,8],[227,4,227,8],[245,3,245,7],[248,3,248,7],[235,3,235,7],[236,3,236,7],[239,3,239,7],[240,3,240,7],[241,3,241,7],[242,3,242,7],[247,3,247,7]]}
[null,"Honorarberechnung  Bauingenieurleistungen"]
[null,null,null,null,null,null,null,null,null,null,"Beilage 2a"]
[null,null,null,"Für Honorarofferten sind die gelben Felder auszufüllen / anzupassen!",null,null,null,null,null,null," "]
[null,"Firmenname",null,null,null,null,null,null,null,"Datum"]
[null,"Bezeichnung",null,null,null,null,null,null,null,"Rev."]
[null,"Adresse, Ort",null,null,null,null,null,null,null,"Objekt Nr"]
[null,"verantwortlich  ",null,null,null,null,null,null,null,"PL GSZ"]
[null,"Auftragsbezeichnung",null,"Bauingenieurleistungen",null,null,null,null,null,"Konto-Nr."]
[null,"Objektbezeichnung",null,null,null,null,null,null,null,"BKP",492]
[]
[null,"Grundlagen",null,"STRB 323 vom 13. April 2016",null,null,"Honorierung von Planungsleistungen (Dienstleistungsaufträge)"]
[null,null,null,"Merkblatt zu Planungsaufträgen Grün Stadt Zürich (GSZ)"]
[null,null,null,"Allgemeine Bedingungen von GSZ zum Vertrag für Bauingenieurleistungen"]
[null,null,null,"Ordnung SIA 103 (Ausgabe 2014) für Leistungen und Honorare der Bauingenieure"]
[null,"Freigabe der Honorare/Leistungen",null,"Die Leistungen und die damit verbundenen Honorare werden phasenweise schriftlich freigegeben"]
[null,"Nebenkosten",null,"Vergütung gemäss Merkblatt zu Planungsaufträgen GSZ"]
[null,"Bemerkungen"]
[]
[]
[null,"Objekte / Anlageteile"]
[null,"Phase","Honorarberechnung","Leistungsphase",null,null,"definitive Honorarberechnung"]
[null,"A","Honorierung nach Baukosten","Projektierung",null,null,"Pauschal (Basis Kostenschätzung)"]
[null,"B","Honorierung nach Baukosten","Ausschreibung, Realisierung",null,null,"Pauschal (Basis KV) oder nach effektiven Baukosten"]
[null,"C","Honorierung nach Baukosten","Gesamtleitung / Oberbauleitung"]
[null,"D","Honorierung nach Zeitaufwand","Projektierung",null,null,"nach effektivem Zeitaufwand (Kostendach)"]
[null,"E","Honorierung nach Zeitaufwand","Ausschreibung, Realisierung",null,null,"nach effektivem Zeitaufwand (Kostendach)"]
[null,"F","Honorierung nach Zeitaufwand","Gesamtleitung / Oberbauleitung"]
[]
[null,"Zusammenstellung Honorar"]
[null,"Phase","Bezeichnung Objekt / Anlageteil",null,"A","B","C","D","E","F","Total"]
[null,null," ",null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,"H","Gesamthonorar exkl. MWSt (*)",null,{"$f":"ROUND(SUM(E33:E35),-1)","v":0},0,0,0,0,0,{"$f":"SUM(E32:J32)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,{"$f":"+E124+E257","v":0},null,null,{"$f":"+H124+H257","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,{"$f":"+F125+F258","v":0},null,null,{"$f":"+I125+I258","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,{"$f":"+G126+G259","v":0},null,null,{"$f":"+J126+J259","v":0},0]
[null,null,"Mehrwertsteuer (*)",null,{"$f":"+E127","v":0},{"$f":"+F127","v":0},{"$f":"+G127","v":0},{"$f":"+H260","v":0},{"$f":"+I260","v":0},{"$f":"+J260","v":0},0]
[null,"H","Gesamthonorar inkl. MWSt (**)",null,{"$f":"ROUND(E32+E36,-2)","v":0},0,0,0,0,0,0]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,{"$f":"ROUND(E33+E36,-2)","v":0},null,null,{"$f":"ROUND(H33+H36,-2)","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,{"$f":"ROUND(F34+F36,-2)","v":0},null,null,{"$f":"ROUND(I34+I36,-2)","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,{"$f":"ROUND(G35+G36,-2)","v":0},null,null,{"$f":"ROUND(J35+J36,-2)","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Nebenkosten"]
[null,"Phase","Bezeichnung Objekt / Anlageteil",null,{"$f":"+E$30","v":"A"},{"$f":"+F$30","v":"B"},"C","D","E","F","Total"]
[null," ",null,null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,"BKP 524","Reproduktions-/Druck-/Plotkosten",0.05,{"$f":"ROUND(+E32*$D46,-2)","v":0},0,0,0,0,0,{"$f":"SUM(E46:J46)","v":0}]
[null,"BKP 522","Modelle",null,null,null,null,null,null,null,0]
[null,"BKP 525","Spezielle Dokumentation",null,null,null,null,null,null,null,0]
[null,"BKP 565","Reisekosten",null,null,null,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,0]
[null,"N","Nebenkosten exkl. MWSt (*)",null,{"$f":"ROUND(SUM(E46:E50),-1)","v":0},0,0,0,0,0,{"$f":"SUM(E51:J51)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,{"$f":"+E51","v":0},null,null,{"$f":"+H51","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,{"$f":"+F51","v":0},null,null,{"$f":"+I51","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,{"$f":"+G51","v":0},null,null,{"$f":"+J51","v":0},0]
[null,null,"Mehrwertsteuer (*)",0.08,{"$f":"ROUND(E51*$D55,-1)","v":0},0,0,0,0,0,0]
[null,"N","Nebenkosten inkl. MWSt (*)",null,{"$f":"+E51+E55","v":0},0,0,0,0,0,{"$f":"SUM(E56:J56)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,{"$f":"+E51+E55","v":0},null,null,{"$f":"+H51+H55","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,{"$f":"+F51+F55","v":0},null,null,{"$f":"+I51+I55","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,{"$f":"+G51+G55","v":0},null,null,{"$f":"+J51+J55","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Unterschriften"]
[null,"Rechtsgültige Unterschriften",null,"Stempel / Unterschrift:",null,null,null,null,"Ort:","Datum:"]
[]
[]
[]
[]
[null,"Honorar nach Baukosten"]
[null,null,null,null,null,null,null,null,null,null,"Beilage 2b"]
[null,null,null,"Für Honorarofferten sind die gelben Felder auszufüllen / anzupassen!",null,null,null,null,null,null," "]
[null,{"$f":"+B$4","v":"Firmenname"},null,{"$f":"+D$4","v":0},null,null,null,null,null,{"$f":"+J$4","v":"Datum"},{"$f":"+K$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,{"$f":"+J$5","v":"Rev."},{"$f":"+K$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,{"$f":"+J$6","v":"Objekt Nr"},{"$f":"+K$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,{"$f":"+J$7","v":"PL GSZ"},{"$f":"+K$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Bauingenieurleistungen"},null,null,null,null,null,{"$f":"+J$8","v":"Konto-Nr."},{"$f":"+K$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,{"$f":"+J$9","v":"BKP"},{"$f":"+K$9","v":492}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 103 (Ausgabe 2014), Art. 7 Honorarberechnung nach den Baukosten"]
[null,"Leistungen",null,"Grundleistungen nach SIA 103, Art. 4 und den Allgemeinen Bedingungen GSZ"]
[null,"Berechnungsfaktoren",null,"Die vereinbarten Faktoren gelten für die gesamte Projektierungs- und Realisierungszeit"]
[null,"Schwierigkeitsgrad (n)",null,"Begründung der Einstufung"]
[null,"Anpassungsfaktor (r)",null,"Begründung (bei Abweichung von r = 1.00)"]
[null,"Teamfaktor (i)",null,"Begründung (bei Abweichung von i = 1.00)"]
[null,"Faktor für Sonderleistungen (s)",null,"Begründung (bei Abweichung von s = 1.00)"]
[null,"angebotener Stundenansatz (h)",null,"Begründung (sofern nicht über alle Phasen identisch)"]
[]
[null,"Grundfaktor (p)"]
[null,"Abk.","Bezeichnung",null,{"$f":"+E$30","v":"A"},{"$f":"+F$30","v":"B"},"C","D","E","F","Total"]
[null,"Ba","aufwandbestimmende Baukosten","CHF",{"$f":"+K195","v":0},{"$f":"+E89","v":0},{"$f":"+E89","v":0}]
[null,"Z1",2016,null,7.4999999999999997E-2,{"$f":"+E90","v":7.4999999999999997E-2},{"$f":"+E90","v":7.4999999999999997E-2}]
[null,"Z2",2016,null,7.23,{"$f":"+E91","v":7.23},{"$f":"+E91","v":7.23}]
[null,"p","Grundfaktor für Stundenaufwand",null,{"$f":"IF(+E89>0,(+E90+E91/(E89^(1/3))),0)","v":0},{"$f":"IF(+F89>0,(+F90+F91/(F89^(1/3))),0)","v":0},0,0,0,0]
[]
[null,"Grundleistungen (q)"]
[null,"Abk.","Bezeichnung",null,{"$f":"+E$30","v":"A"},{"$f":"+F$30","v":"B"},"C","D","E","F","Total"]
[null,"Phase","Teilleistung","SIA 103","(%)","(%)","(%)","(%)","(%)","(%)","(%)"]
[null,31,"Vorprojekt  ",0.08,0.08,0,null,null,null,null,{"$f":"SUM(E97:J97)","v":0.08}]
[null,32,"Bauprojekt",0.22,0.22,0,null,null,null,null,{"$f":"SUM(E98:J98)","v":0.22}]
[null,33,"Bewilligungsverf. / Auflageprojekt",0.02,0.02,null,null,null,null,null,0.02]
[null,41,"Ausschreibung, Offertvergleich, Vergabeantrag",0.1,null,0.1,null,null,null,null,0.1]
[null,51,"Ausführungsprojekt",0.18,null,0.18,null,null,null,null,0.18]
[null,null,"Zuschlag Anteil Tragkonstruktion",0.3,null,0,null,null,null,null,{"$f":"SUM(E102:J102)","v":0}]
[null,52,"Ausführung Allg. Bauleitung",0.22,null,0.22,null,null,null,null,0.22]
[null,null,"Ausführung Techn. Bauleitung",0.15,null,0.15,null,null,null,null,0.15]
[null,null,"Ausführung Baukontrolle",7.0000000000000007E-2,null,0,null,null,null,null,0]
[null,null,"Inbetriebnahme, Abschluss",0.03,null,0.03,null,null,null,null,0.03]
[null,"3,4,5","Gesamtleitung inkl. Oberbauleitung",0.1,null,0,null,null,null,null,0]
[null,"q","Total Grundleistungen",null,{"$f":"SUM(E97:E107)","v":0.32},0.68,0,0,0,0,1]
[]
[null,"Honorar nach Baukosten (H)"]
[null,"Abk.","Bezeichnung",null,{"$f":"+E$30","v":"A"},{"$f":"+F$30","v":"B"},"C","D","E","F","Total"]
[null,"Ba","aufwandbestimmende Baukosten","CHF",{"$f":"+E89","v":0},{"$f":"+F89","v":0},{"$f":"+G89","v":0}]
[null,"n","Schwierigkeitsgrad",null,1,{"$f":"+E113","v":1},{"$f":"+E113","v":1}]
[null,"r","Anpassungsfaktor",null,1,{"$f":"+E114","v":1},{"$f":"+E114","v":1}]
[null,null,null,null,0,{"$f":"+E115","v":0},{"$f":"+E115","v":0}]
[null,"Tm","durchschnittlicher Zeitaufwand","Std.",{"$f":"+E89*E92*E113*E108*E114*IF(E115>0,E115,1)/100","v":0},{"$f":"+F89*F92*F113*F108*F114*IF(F115>0,F115,1)/100","v":0},{"$f":"+G89*G92*G113*G108*G114*IF(G115>0,G115,1)/100","v":0},null,null,null,{"$f":"SUM(E116:J116)","v":0}]
[null,"i","Teamfaktor",null,1,{"$f":"+E117","v":1},{"$f":"+E117","v":1}]
[null,"Tp","Prognostizierter Zeitaufwand","Std.",{"$f":"+E116*E117","v":0},{"$f":"+F116*F117","v":0},{"$f":"+G116*G117","v":0},null,null,null,{"$f":"SUM(E118:J118)","v":0}]
[null,"s","Faktor für Sonderleistungen",null,1,{"$f":"+E119","v":1},{"$f":"+E119","v":1}]
[null,"h","angebotener Stundenansatz","CHF",130,{"$f":"+E120","v":130},{"$f":"+E120","v":130}]
[null,"H","Honorar exkl. MWSt (*)","CHF",{"$f":"ROUND(E118*E119*E120,-1)","v":0},{"$f":"ROUND(F118*F119*F120,-1)","v":0},{"$f":"ROUND(G118*G119*G120,-1)","v":0},null,null,null,{"$f":"SUM(E121:J121)","v":0}]
[null,null,"Rabatt ","%",0.15,{"$f":"+E122","v":0.15},{"$f":"+E122","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)","CHF",{"$f":"ROUND(E121*(100%-E122),-1)","v":0},{"$f":"ROUND(F121*(100%-F122),-1)","v":0},{"$f":"ROUND(G121*(100%-G122),-1)","v":0},null,null,null,{"$f":"SUM(E123:J123)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt","CHF",{"$f":"+E123","v":0},null,null,null,null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt","CHF",null,{"$f":"+F123","v":0},null,null,null,null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt","CHF",null,null,{"$f":"+G123","v":0},null,null,null,0]
[null,null,"Mehrwertsteuer (*)",0.08,{"$f":"ROUND(+E123*$D127,-1)","v":0},{"$f":"ROUND(+F123*$D127,-1)","v":0},{"$f":"ROUND(+G123*$D127,-1)","v":0},null,null,null,0]
[null,"H","Honorar inkl. MWSt (**)","CHF",{"$f":"ROUND(E123+E127,-2)","v":0},{"$f":"ROUND(F123+F127,-2)","v":0},{"$f":"ROUND(G123+G127,-2)","v":0},null,null,null,0]
[null,"TA1","Teilauftrag 1 inkl. MWSt","CHF",{"$f":"+E128","v":0},null,null,{"$f":"+H128","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt","CHF",null,{"$f":"+F128","v":0},null,null,{"$f":"+I128","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt","CHF",null,null,{"$f":"+G128","v":0},null,null,{"$f":"+J128","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Aufwandbestimmende Baukosten"]
[null,null,null,null,null,null,null,null,null,null,"Beilage 2c"]
[null,null,null,"Für Honorarofferten sind die gelben Felder auszufüllen / anzupassen!"]
[null,{"$f":"+B$4","v":"Firmenname"},null,{"$f":"+D$4","v":0},null,null,null,null,null,{"$f":"+J$4","v":"Datum"},{"$f":"+K$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,{"$f":"+J$5","v":"Rev."},{"$f":"+K$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,{"$f":"+J$6","v":"Objekt Nr"},{"$f":"+K$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,{"$f":"+J$7","v":"PL GSZ"},{"$f":"+K$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Bauingenieurleistungen"},null,null,null,null,null,{"$f":"+J$8","v":"Konto-Nr."},{"$f":"+K$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,{"$f":"+J$9","v":"BKP"},{"$f":"+K$9","v":492}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 103 (Ausgabe 2014); Art. 7 Honorarberechnung nach den Baukosten"]
[null,"Kostenbasis",null,"Kostenschätzung vom"]
[null,"Bemerkungen"]
[]
[null,"Aufwandbestimmende Baukosten (B)"]
[null,"BKP","Bezeichnung",null,null,null,null,null,"Kosten","Anteil","Berechtigt"]
[null,null,null,"Bemerkungen",null,null,null,null,"CHF","%","CHF"]
[null,"0","Grundstück"]
[null,"01","Grundstück- / Baurechterwerb","nicht aufwandbestimmend",null,null,null,null,null,"0%",{"$f":"+$I152*J152","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I153*J153","v":0}]
[null,1,"Vorbereitungsarbeiten"]
[null,10,"Aufnahmen, Baugrunduntersuchungen",null,null,null,null,null,null,null,{"$f":"+$I155*J155","v":0}]
[null,11,"Räumungen, Terrainvorbereitungen",null,null,null,null,null,null,null,0]
[null,119,"Entsorgung belastete Bauabfälle","(Mehrkosten) nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,12,"Sicherungen, Provisorien",null,null,null,null,null,null,null,0]
[null,13,"Gemeinsame Baustelleinrichtung",null,null,null,null,null,null,null,0]
[null,14,"Anpassungen an best. Bauten",null,null,null,null,null,null,null,0]
[null,15,"Anpassungen an Erschl.leitungen",null,null,null,null,null,null,null,0]
[null,16,"Anpassungen an Verkehrsanlagen",null,null,null,null,null,null,null,0]
[null,17,"Spez. Fundationen, Baugrubensich.",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I164*J164","v":0}]
[null,19,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,2,"Gebäude"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I167*J167","v":0}]
[null,3,"Betriebseinrichtungen"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I169*J169","v":0}]
[null,4,"Umgebung"]
[null,40,"Terraingestaltung",null,null,null,null,null,0,null,{"$f":"+$I171*J171","v":0}]
[null,41,"Roh- und Ausbauarbeiten",null,null,null,null,null,null,null,0]
[null,42,"Gartenanlagen",null,null,null,null,null,null,null,0]
[null,43,"Reserve",null,null,null,null,null,null,null,0]
[null,44,"Installationen",null,null,null,null,null,null,null,0]
[null,45,"Erschliessung durch Leitungen",null,null,null,null,null,null,null,0]
[null,46,"Kleinere Trassenbauten",null,null,null,null,null,null,null,0]
[null,47,"Kleinere Kunstbauten",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I179*J179","v":0}]
[null,49,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,5,"Baunebenkosten"]
[null,"50-56","Allgemeine Baunebenkosten","nicht aufwandbestimmend",null,null,null,null,null,"0%",{"$f":"+$I182*J182","v":0}]
[null,58,"Übergangskonten",null,null,null,null,null,null,null,{"$f":"+$I183*J183","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I184*J184","v":0}]
[null,6,"Reserven"]
[null,61,"Zuschlag Bauherrschaft","nicht aufwandbestimmend",null,null,null,null,null,"0%",{"$f":"+$I186*J186","v":0}]
[null,62,"Unvorhergesehenes","nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I188*J188","v":0}]
[null,9,"Ausstattung"]
[null,98,"Kunst und Bau",null,null,null,null,null,null,null,0]
[null,99,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I192*J192","v":0}]
[null,null,"Zwischentotal","inkl. MWSt",null,null,null,null,{"$f":"SUM(I151:I192)","v":0},null,{"$f":"SUM(K151:K192)","v":0}]
[null,null,"Mehrwertsteuer (*)","nicht aufwandbestimmend",null,null,null,0.08,{"$f":"ROUND(I193*H194/(100%+H194),-1)","v":0},null,{"$f":"ROUND(K193*H194/(100%+H194),-1)","v":0}]
[null,"B","Total (**)","Aufwandbestimmende Baukosten exkl. MWSt",null,null,null,null,{"$f":"ROUND(SUM(I193-I194),-2)","v":0},null,{"$f":"ROUND(SUM(K193-K194),-2)","v":0}]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[]
[null,"Honorar nach dem effektiven Zeitaufwand"]
[null,null,null,null,null,null,null,null,null,null,"Beilage 2d"]
[null,null,null,"Für Honorarofferten sind die gelben Felder auszufüllen / anzupassen!"]
[null,{"$f":"+B$4","v":"Firmenname"},null,{"$f":"+D$4","v":0},null,null,null,null,null,{"$f":"+J$4","v":"Datum"},{"$f":"+K$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,{"$f":"+J$5","v":"Rev."},{"$f":"+K$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,{"$f":"+J$6","v":"Objekt Nr"},{"$f":"+K$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,{"$f":"+J$7","v":"PL GSZ"},{"$f":"+K$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Bauingenieurleistungen"},null,null,null,null,null,{"$f":"+J$8","v":"Konto-Nr."},{"$f":"+K$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,{"$f":"+J$9","v":"BKP"},{"$f":"+K$9","v":492}]
[]
[null,"Honorarordnung",null,"Ordnung 103 (Ausgabe 2014); Art. 6 Honorarberechnung nach dem effektiven Zeitaufwand"]
[null,"Leistungen",null,"Besonders zu vereinbarende Leistungen"]
[null,null,null,"Leistungsvereinbarung gemäss Beilage"]
[null,"Stundenansatz (h)",null,"Max. Stundenansätze gemäss Beschluss Stadtrat Zürich bzw. Empfehlung",null,null,null,null,null,null,"KBOB 2016"]
[null," ",null,"Die Stundenansätze sind fest über die gesamte Projektierung- und Realisierungszeit"]
[null,"Anforderungsfaktor (a)",null,"Anforderungsfaktor (a) für den mittleren Ansatz gemäss Empfehlung KBOB"]
[null," ",null,"Der Faktor ist fest über die gesamte Projektierung- und Realisierungszeit"]
[null,"Teuerung",null,"gemäss KBOB bzw. Vertragsnorm SIA 126 (ab 2. Kalenderjahr)"]
[null,"Kostenbasis"]
[null,"Bemerkungen"]
[]
[null,"Vereinbarte Stundenansätze",null,"Kategorie","Bemerkungen",null,null,null,null,"KBOB","Ansatz"]
[null,null,null,null,null,null," ",null,null,"maximal","vereinbart"]
[null,null,null,"A",null,null,null,null,null,232]
[null,null,null,"B","Maximal verrechenbare Kategorie",null,null,null,null,182]
[null,null,null,"C",null,null,null,null,null,157]
[null,null,null,"D",null,null,null,null,null,133]
[null,null,null,"E",null,null,null,null,null,111]
[null,null,null,"F",null,null,null,null,null,101]
[null,null,null,"G",null,null,null,null,null,97]
[null,"Mittelansatz für Planungsgruppen",null,null,"Mittlerer Ansatz",null,162,"Faktor",0.8,"MA",{"$f":"+G229*I229","v":129.6}]
[]
[null,"Honorar nach dem effektivem Zeitaufwand (H)"]
[null,"Abk.","Bezeichnung",null," ",null,null,null,"Aufwand","Ansatz","Honorar"]
[null,"Phase","Teilleistung","Bemerkungen",null,null," ",null,"Tt (Std.)","h (CHF)","H (CHF)"]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I234*J234","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I235*J235","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I236*J236","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I237*J237","v":0}]
[null,"TA1","Total Teilauftrag 1","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K234:K237)","v":0}]
[]
[null,"TA2",null,null,null,null,null,null,0,0,{"$f":"+I240*J240","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I241*J241","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I242*J242","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I243*J243","v":0}]
[null,"TA2","Total Teilauftrag 2","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K240:K243)","v":0}]
[]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I246*J246","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I247*J247","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,0]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I249*J249","v":0}]
[null,"TA3","Total Teilauftrag 3","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K246:K249)","v":0}]
[null," ","Total",null,null,null,null,null,{"$f":"SUM(I234:I250)","v":0},null,{"$f":"SUM(K238+K244+K250)","v":0}]
[]
[null,"Phase","Objekt / Anlageteil",null,{"$f":"+E$30","v":"A"},{"$f":"+F$30","v":"B"},"C","D","E","F","Total"]
[null,null,"Bezeichnung",null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,null,"Rabatt",null,null,null,null,0.15,{"$f":"+H255","v":0.15},{"$f":"+H255","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)",null,null,null,null,{"$f":"ROUND(K238*(100%-H255),-1)","v":0},{"$f":"ROUND(K244*(100%-I255),-1)","v":0},{"$f":"ROUND(K250*(100%-J255),-1)","v":0},{"$f":"SUM(E256:J256)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,null,null,null,{"$f":"+H256","v":0},null,null,{"$f":"SUM(E257:J257)","v":0}]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,null,null,null,{"$f":"+I256","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,null,null,null,{"$f":"+J256","v":0},0]
[null,null,"Mehrwertsteuer (*)",0.08,null,null,null,{"$f":"ROUND(+H256*$D260,-1)","v":0},{"$f":"ROUND(+I256*$D260,-1)","v":0},{"$f":"ROUND(+J256*$D260,-1)","v":0},{"$f":"SUM(E260:J260)","v":0}]
[null,"H","Honorar inkl. MWSt (**)",null,null,null,null,{"$f":"ROUND(H256+H260,-2)","v":0},{"$f":"ROUND(I256+I260,-2)","v":0},{"$f":"ROUND(J256+J260,-2)","v":0},{"$f":"SUM(E261:J261)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,null,null,null,{"$f":"+H261","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,null,null,null,{"$f":"+I261","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,null,null,null,{"$f":"+J261","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]