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

{"sheet":"Honorarberechnung","index":0,"n_rows":270,"n_cols":11,"rows_kept":270,"cut":false,"hidden":false,"merged":[[3,3,3,8],[4,3,4,8],[5,3,5,8],[6,3,6,8],[7,3,7,8],[158,3,158,7],[8,3,8,8],[21,3,21,5],[21,6,21,10],[80,3,80,10],[81,3,81,10],[82,3,82,10],[26,3,26,5],[26,6,26,10],[22,3,22,5],[22,6,22,10],[62,3,64,7],[62,8,64,8],[62,9,64,10],[16,3,16,10],[17,3,17,10],[83,3,83,10],[84,3,84,10],[85,3,85,10],[150,3,150,10],[151,3,151,10],[222,3,222,10],[168,3,168,7],[171,3,171,7],[173,3,173,7],[183,3,183,7],[188,3,188,7],[192,3,192,7],[196,3,196,7],[215,3,215,10],[217,3,217,10],[221,3,221,10],[220,3,220,10],[253,3,253,7],[241,3,241,7],[244,3,244,7],[245,3,245,7],[246,3,246,7],[251,3,251,7],[252,3,252,7],[238,3,238,7],[239,3,239,7],[240,3,240,7],[247,3,247,7],[250,3,250,7],[23,3,23,5],[23,6,23,10],[24,3,24,5],[24,6,24,10],[25,3,25,5],[25,6,25,10]]}
[null,"Honorarberechnung  Landschaftsarchitekturleistungen"]
[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,"Landschaftsarchitekturleistungen",null,null,null,null,null,"Konto-Nr."]
[null,"Objektbezeichnung",null,null,null,null,null,null,null,"BKP",496.5]
[]
[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 Landschaftsarchitekturleistungen"]
[null,null,null,"Ordnung SIA 105 (Ausgabe 2014) für Leistungen und Honorare der Landschaftsarchitekten"]
[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 Aufwandschätzung)"]
[null,"B","Honorierung nach Baukosten","Ausschreibung, Realisierung",null,null,"Pauschal (Basis definitiver Kostenvoranschlag) oder"]
[null,"C","Honorierung nach Baukosten",null,null,null,"gemäss effektiven Baukosten (gem. Bauabrechnung)"]
[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"]
[]
[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":"+E130+E262","v":0},null,null,{"$f":"+H130+H262","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,{"$f":"+F131+F263","v":0},null,null,{"$f":"+I131+I263","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,{"$f":"+G132+G264","v":0},null,null,{"$f":"+J132+J264","v":0},0]
[null,null,"Mehrwertsteuer (*)",null,{"$f":"+E133","v":0},{"$f":"+F133","v":0},{"$f":"+G133","v":0},{"$f":"+H265","v":0},{"$f":"+I265","v":0},{"$f":"+J265","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 (ohne Arbeitsmodelle)",null,null,null,null,null,null,null,0]
[null,"BKP 525","Spezielle Dokumentation",null,null,0,null,null,null,null,0]
[null,"BKP 565","Reisekosten (vgl. Merkblatt)",null,null,null,null,null,null,null,0]
[null,null,null,null,null,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":"Landschaftsarchitekturleistungen"},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":496.5}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 105 (Ausgabe 2014); Art. 7 Honorarberechnung nach den Baukosten"]
[null,"Leistungen",null,"Grundleistungen nach SIA 105, Art. 4.2 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,"B","aufwandbestimmende Baukosten","CHF",{"$f":"+K200","v":0},{"$f":"+E90","v":0},{"$f":"+E90","v":0}]
[null,"Z1",2016,null,6.2E-2,{"$f":"+E91","v":6.2E-2},{"$f":"+E91","v":6.2E-2}]
[null,"Z2",2016,null,10.58,{"$f":"+E92","v":10.58},{"$f":"+E92","v":10.58}]
[null,"p","Grundfaktor für Stundenaufwand",null,{"$f":"IF(+E90>0,(+E91+E92/(E90^(1/3))),0)","v":0},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 105","(%)","(%)","(%)","(%)","(%)","(%)","(%)"]
[null,"4.2.31","Lösungsmöglichk./ Grobschätzung",0.04,0.04,null,null,null,null,null,{"$f":"SUM(E98:J98)","v":0.04}]
[null,null,"Vorprojekt und Kostenschätzung",0.08,0.08,null,null,null,null,null,{"$f":"SUM(E99:J99)","v":0.08}]
[null,"4.2.32","Bauprojekt",0.1,0.1,null,null,null,null,null,{"$f":"SUM(E100:J100)","v":0.1}]
[null,null,"Detailstudien",0.04,0.04,null,null,null,null,null,0.04]
[null,null,"Kostenvoranschlag",0.04,0.04,null,null,null,null,null,0.04]
[null,"4.2.33","Bewilligungsverfahren",2.5000000000000001E-2,2.5000000000000001E-2,null,null,null,null,null,2.5000000000000001E-2]
[null,"4.2.41","Ausschreibungspläne",0.1,null,0.1,null,null,null,null,{"$f":"SUM(E104:J104)","v":0.1}]
[null,null,"Ausschreibung und Vergabe",0.08,null,0.08,null,null,null,null,0.08]
[null,"4.2.51","Ausführungspläne",0.15,null,0.15,null,null,null,null,0.15]
[null,null,"Werkverträge",0.01,null,0.01,null,null,null,null,0.01]
[null,"4.2.52","Gestalterische Leitung",0.06,null,0.06,null,null,null,null,0.06]
[null,null,"Bauleitung und Kostenkontrolle",0.23,null,0.23,null,null,null,null,0.23]
[null,"4.2.53","Inbetriebnahme",0.01,null,0.01,null,null,null,null,0.01]
[null,null,"Dokumentation Bauwerk",0.01,null,0.01,null,null,null,null,0.01]
[null,null,"Leitung Garantiearbeiten",1.4999999999999999E-2,null,1.4999999999999999E-2,null,null,null,null,1.4999999999999999E-2]
[null,null,"Schlussabrechnung",0.01,null,0.01,null,null,null,null,0.01]
[null,"q","Total Grundleistungen",{"$f":"SUM(D98:D113)","v":1},{"$f":"SUM(E98:E113)","v":0.32500000000000001},{"$f":"SUM(F98:F113)","v":0.67500000000000004},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,"B","aufwandbestimmende Baukosten","CHF",{"$f":"+E90","v":0},{"$f":"+F90","v":0},{"$f":"+G90","v":0}]
[null,"n","Schwierigkeitsgrad",null,1,{"$f":"+E119","v":1},{"$f":"+E119","v":1}]
[null,"r","Anpassungsfaktor",null,1,{"$f":"+E120","v":1},{"$f":"+E120","v":1}]
[null,null,null,null,0,{"$f":"+E121","v":0},{"$f":"+E121","v":0}]
[null,"Tm","durchschnittlicher Zeitaufwand","Std.",{"$f":"+E90*E93*E119*E114*E120*IF(E121>0,E121,1)/100","v":0},{"$f":"+F90*F93*F119*F114*F120*IF(F121>0,F121,1)/100","v":0},{"$f":"+G90*G93*G119*G114*G120*IF(G121>0,G121,1)/100","v":0},null,null,null,{"$f":"SUM(E122:J122)","v":0}]
[null,"i","Teamfaktor",null,1,{"$f":"+E123","v":1},1]
[null,"Tp","Prognostizierter Zeitaufwand","Std.",{"$f":"+E122*E123","v":0},{"$f":"+F122*F123","v":0},{"$f":"+G122*G123","v":0},null,null,null,{"$f":"SUM(E124:J124)","v":0}]
[null,"s","Faktor für Sonderleistungen",null,1,{"$f":"+E125","v":1},{"$f":"+F125","v":1}]
[null,"h","angebotener Stundenansatz","CHF",130,{"$f":"+E126","v":130},{"$f":"+F126","v":130}]
[null,"H","Honorar exkl. MWSt (**)","CHF",{"$f":"ROUND(E124*E125*E126,-2)","v":0},{"$f":"ROUND(F124*F125*F126,-2)","v":0},{"$f":"ROUND(G124*G125*G126,-2)","v":0},null,null,null,{"$f":"SUM(E127:J127)","v":0}]
[null,null,"Rabatt","%",0.15,{"$f":"+E128","v":0.15},{"$f":"+E128","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)","CHF",{"$f":"ROUND(E127*(100%-E128),-1)","v":0},{"$f":"ROUND(F127*(100%-F128),-1)","v":0},{"$f":"ROUND(G127*(100%-G128),-1)","v":0},null,null,null,{"$f":"SUM(E129:J129)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt","CHF",{"$f":"+E129","v":0},null,null,null,null,null,{"$f":"SUM(E130:J130)","v":0}]
[null,"TA2","Teilauftrag 2 exkl. MWSt","CHF",null,{"$f":"+F129","v":0},null,null,null,null,{"$f":"SUM(E131:J131)","v":0}]
[null,"TA3","Teilauftrag 3 exkl. MWSt","CHF",null,null,{"$f":"+G129","v":0},null,null,null,{"$f":"SUM(E132:J132)","v":0}]
[null,null,"Mehrwertsteuer (*)",0.08,{"$f":"ROUND(+E129*$D133,-1)","v":0},{"$f":"ROUND(+F129*$D133,-1)","v":0},{"$f":"ROUND(+G129*$D133,-1)","v":0},null,null,null,{"$f":"SUM(E133:G133)","v":0}]
[null,"H","Honorar inkl. MWSt (**)","CHF",{"$f":"ROUND(E129+E133,-2)","v":0},{"$f":"ROUND(F129+F133,-2)","v":0},{"$f":"ROUND(G129+G133,-2)","v":0},null,null,null,{"$f":"SUM(E134:J134)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt","CHF",{"$f":"+E134","v":0},null,null,{"$f":"+H134","v":0},null,null,{"$f":"SUM(E135:J135)","v":0}]
[null,"TA2","Teilauftrag 2 inkl. MWSt","CHF",null,{"$f":"+F134","v":0},null,null,{"$f":"+I134","v":0},null,{"$f":"SUM(E136:J136)","v":0}]
[null,"TA3","Teilauftrag 3 inkl. MWSt","CHF",null,null,{"$f":"+G134","v":0},null,null,{"$f":"+J134","v":0},{"$f":"SUM(E137:J137)","v":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":"Landschaftsarchitekturleistungen"},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":496.5}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 105 (2014); Art. 7 Honorarberechnung nach den aufwandbestimmenden 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":"+$I158*J158","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I159*J159","v":0}]
[null,1,"Vorbereitungsarbeiten"]
[null,10,"Aufnahmen, Baugrunduntersuchungen","50%, falls durch Bauingenieur geplant/ausgeführt",null,null,null,null,null,0.5,{"$f":"+$I161*J161","v":0}]
[null,11,"Räumungen, Terrainvorbereitungen","50%, falls durch Bauingenieur geplant/ausgeführt",null,null,null,null,null,0.5,0]
[null,119,"Entsorgung belastete Bauabfälle","(Mehrkosten) nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,12,"Sicherungen, Provisorien","50%, falls durch Bauingenieur geplant/ausgeführt",null,null,null,null,null,0.5,0]
[null,13,"Gemeinsame Baustelleinrichtung",null,null,null,null,null,null,1,0]
[null,15,"Anpassungen an Erschl.leitungen","70% berechtigt bei Beizug von Ingenieuren",null,null,null,null,0,0.7,0]
[null,16,"Anpassungen an Verkehrsanlagen","50%, falls durch Bauingenieur geplant/ausgeführt",null,null,null,null,0,0.5,0]
[null,17,"Spez. Fundationen, Baugrubensich.","50%, falls durch Bauingenieur geplant/ausgeführt",null,null,null,null,0,0.5,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I169*J169","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":"+$I172*J172","v":0}]
[null,3,"Betriebseinrichtungen"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I174*J174","v":0}]
[null,4,"Umgebung"]
[null,40,"Terraingestaltung",null,null,null,null,null,0,1,{"$f":"+$I176*J176","v":0}]
[null,41,"Roh- und Ausbauarbeiten",null,null,null,null,null,0,1,0]
[null,42,"Gartenanlagen",null,null,null,null,null,0,1,0]
[null,43,"Reserve",null,null,null,null,null,null,0,{"$f":"+$I179*J179","v":0}]
[null,44,"Installationen","70% berechtigt bei Beizug von Ingenieuren",null,null,null,null,0,0.7,0]
[null,45,"Erschliessung durch Leitungen","70% berechtigt bei Beizug von Ingenieuren",null,null,null,null,0,0.7,0]
[null,46,"Kleinere Trassenbauten",null,null,null,null,null,0,1,0]
[null,47,"Kleinere Kunstbauten",null,null,null,null,null,0,1,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I184*J184","v":0}]
[null,49,"Honorare","nicht aufwandbestimmend",null,null,null,null,0,"0%",0]
[null,5,"Baunebenkosten"]
[null,"50-56","Allgemeine Baunebenkosten","nicht aufwandbestimmend",null,null,null,null,0,"0%",{"$f":"+$I187*J187","v":0}]
[null,58,"Übergangskonten",null,null,null,null,null,null,null,{"$f":"+$I188*J188","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I189*J189","v":0}]
[null,6,"Reserven"]
[null,61,"Zuschlag Bauherrschaft","nicht aufwandbestimmend",null,null,null,null,0,"0%",{"$f":"+$I191*J191","v":0}]
[null,62,"Unvorhergesehenes","nicht aufwandbestimmend",null,null,null,null,0,"0%",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I193*J193","v":0}]
[null,9,"Ausstattung"]
[null,98,"Kunst und Bau","100% für Bauobjekte; 25-50% für bewegliche Objekte",null,null,null,null,null,0.5,0]
[null,99,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,"0%",0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+$I197*J197","v":0}]
[null,null,"Zwischentotal","inkl. MWSt",null,null,null,null,{"$f":"SUM(I157:I197)","v":0},null,{"$f":"SUM(K157:K197)","v":0}]
[null,null,"Mehrwertsteuer (*)","nicht aufwandbestimmend",null,null,null,0.08,{"$f":"ROUND(I198*H199/(100%+H199),-1)","v":0},null,{"$f":"ROUND(K198*H199/(100%+H199),-1)","v":0}]
[null,"B","Total (**)","Aufwandbestimmende Baukosten exkl. MWSt",null,null,null,null,{"$f":"ROUND(SUM(I198-I199),-2)","v":0},null,{"$f":"ROUND(SUM(K198-K199),-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":"Landschaftsarchitekturleistungen"},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":496.5}]
[]
[null,"Honorarordnung",null,"Ordnung 105 (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 a =",0.8,"MA",{"$f":"+G234*I234","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":"+I239*J239","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I240*J240","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I241*J241","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,{"$f":"+I242*J242","v":0}]
[null,"TA1","Total Teilauftrag 1","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K239:K242)","v":0}]
[]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I245*J245","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I246*J246","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I247*J247","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,{"$f":"+I248*J248","v":0}]
[null,"TA2","Total Teilauftrag 2","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K245:K248)","v":0}]
[]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I251*J251","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I252*J252","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,0]
[null,"TA3",null,null,null,null,null,null,null,null,{"$f":"+I254*J254","v":0}]
[null,"TA3","Total Teilauftrag 3","exkl. MWSt",null,null,"Kostendach",null,null,null,{"$f":"SUM(K251:K254)","v":0}]
[null," ","Total",null,null,null,null,null,{"$f":"SUM(I239:I255)","v":0},null,{"$f":"SUM(K243+K249+K255)","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":"+H260","v":0.15},{"$f":"+H260","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)",null,null,null,null,{"$f":"ROUND(K243*(100%-H260),-1)","v":0},{"$f":"ROUND(K249*(100%-I260),-1)","v":0},{"$f":"ROUND(K255*(100%-J260),-1)","v":0},{"$f":"SUM(E261:J261)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,null,null,null,{"$f":"+H261","v":0},null,null,{"$f":"SUM(E262:J262)","v":0}]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,null,null,null,{"$f":"+I261","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,null,null,null,{"$f":"+J261","v":0},0]
[null,null,"Mehrwertsteuer (*)",0.08,null,null,null,{"$f":"ROUND(+H261*$D265,-1)","v":0},{"$f":"ROUND(+I261*$D265,-1)","v":0},{"$f":"ROUND(+J261*$D265,-1)","v":0},0]
[null,"H","Honorar inkl. MWSt (**)",null,null,null,null,{"$f":"ROUND(H261+H265,-2)","v":0},{"$f":"ROUND(I261+I265,-2)","v":0},{"$f":"ROUND(J261+J265,-2)","v":0},0]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,null,null,null,{"$f":"+H266","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,null,null,null,{"$f":"+I266","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,null,null,null,{"$f":"+J266","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]