{"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":262,"n_cols":12,"rows_kept":262,"cut":false,"hidden":false,"merged":[[54,3,54,4],[94,3,94,4],[141,3,141,11],[142,3,142,11],[156,3,156,8],[123,3,123,4],[80,3,80,11],[81,3,81,11],[82,3,82,11],[83,3,83,11],[84,3,84,11],[25,3,25,6],[25,7,25,11],[26,3,26,6],[26,7,26,11],[45,3,45,4],[23,3,23,6],[23,7,23,11],[24,3,24,6],[24,7,24,11],[21,3,21,6],[21,7,21,11],[22,3,22,6],[22,7,22,11],[7,3,7,9],[8,3,8,9],[16,3,16,11],[17,3,17,11],[3,3,3,9],[4,3,4,9],[5,3,5,9],[6,3,6,9],[220,5,220,9],[62,3,62,8],[62,10,62,11],[159,3,159,8],[161,3,161,8],[176,3,176,8],[181,3,181,8],[63,3,64,8],[63,9,64,9],[63,10,64,11],[79,3,79,11],[207,3,207,11],[209,3,209,11],[212,3,212,11],[213,3,213,11],[185,3,185,8],[189,3,189,8],[218,5,218,9],[219,5,219,9],[214,3,214,11],[256,3,256,4],[224,5,224,9],[234,7,234,8],[240,7,240,8],[246,7,246,8],[230,3,230,8],[236,3,236,8],[239,3,239,8],[242,3,242,8],[231,3,231,8],[232,3,232,8],[233,3,233,8],[245,3,245,8],[237,3,237,8],[238,3,238,8],[221,5,221,9],[222,5,222,9],[223,5,223,9],[243,3,243,8],[244,3,244,8]]}
[null,"Honorarberechnung  Fachingenieurleistungen"]
[null,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," "]
[null,"Firmenname",null,null,null,null,null,null,null,null,"Datum"]
[null,"Bezeichnung",null,null,null,null,null,null,null,null,"Rev."]
[null,"Adresse, Ort",null,null,null,null,null,null,null,null,"Objekt Nr"]
[null,"verantwortlich  ",null,null,null,null,null,null,null,null,"PL GSZ"]
[null,"Auftragsbezeichnung",null,"Fachingenieur, Sparte ...",null,null,null,null,null,null,"Konto-Nr."]
[null,"Objektbezeichnung",null,null,null,null,null,null,null,null,"BKP"]
[]
[null,"Grundlagen",null,"STRB 323 vom 13. April 2016",null,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 Fachingenieurleistungen"]
[null,null,null,"Ordnung SIA 108 (Ausgabe 2014) für Leistungen und Honorare der Fachingenieure"]
[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,null,"definitive Honorarberechnung"]
[null,"A","Honorierung nach Baukosten","Projektierung",null,null,null,"Pauschal (Basis Kostenschätzung)"]
[null,"B","Honorierung nach Baukosten","Ausschreibung, Realisierung",null,null,null,"Pauschal (Basis KV) oder nach effektiven Baukosten"]
[null,"C","Honorierung nach Baukosten"]
[null,"D","Honorierung nach Zeitaufwand","Projektierung",null,null,null,"nach effektivem Zeitaufwand (Kostendach)"]
[null,"E","Honorierung nach Zeitaufwand","Ausschreibung, Realisierung",null,null,null,"nach effektivem Zeitaufwand (Kostendach)"]
[null,"F","Honorierung nach Zeitaufwand"]
[]
[null,"Zusammenstellung Honorar"]
[null,"Phase","Bezeichnung Objekt / Anlageteil",null,null,"A","B","C","D","E","F","Total"]
[null,null," ",null,null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,"H","Gesamthonorar exkl. MWSt (*)",null,null,{"$f":"ROUND(SUM(F33:F35),-1)","v":0},0,0,0,0,0,{"$f":"SUM(F32:K32)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,null,{"$f":"+F121+F254","v":0},null,null,{"$f":"+I121+I254","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,null,{"$f":"+G122+G255","v":0},null,null,{"$f":"+J122+J255","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,null,{"$f":"+H123+H256","v":0},null,null,{"$f":"+K123+K256","v":0},0]
[null,null,"Mehrwertsteuer (**)",null,null,{"$f":"+F124","v":0},{"$f":"+G124","v":0},{"$f":"+H124","v":0},{"$f":"+I257","v":0},{"$f":"+J257","v":0},{"$f":"+K257","v":0},0]
[null,"H","Gesamthonorar inkl. MWSt (*)",null,null,{"$f":"ROUND(F32+F36,-2)","v":0},0,0,0,0,0,0]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,null,{"$f":"+F33+F36","v":0},null,null,{"$f":"+I33+I36","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,null,{"$f":"+G34+G36","v":0},null,null,{"$f":"+J34+J36","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,null,{"$f":"+H35+H36","v":0},null,null,{"$f":"+K35+K36","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Nebenkosten"]
[null,"Phase","Bezeichnung Objekt / Anlageteil",null,null,{"$f":"+F$30","v":"A"},{"$f":"+G$30","v":"B"},"C","D","E","F","Total"]
[null," ",null,null,null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,"BKP 524","Reproduktions-/Druck-/Plotkosten (**)",0.05,null,{"$f":"ROUND(+F32*$D46,-2)","v":0},0,0,0,0,0,{"$f":"SUM(F46:K46)","v":0}]
[null,"BKP 522","Modelle",null,null,null,null,null,null,null,null,0]
[null,"BKP 525","Spezielle Dokumentation",null,null,null,null,null,null,null,null,0]
[null,"BKP 565","Reisekosten",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N","Nebenkosten exkl. MWSt (**)",null,null,{"$f":"ROUND(SUM(F46:F50),-2)","v":0},0,0,0,0,0,{"$f":"SUM(F51:K51)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,null,{"$f":"+F51","v":0},null,null,{"$f":"+I51","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,null,{"$f":"+G51","v":0},null,null,{"$f":"+J51","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,null,{"$f":"+H51","v":0},null,null,{"$f":"+K51","v":0},0]
[null,null,"Mehrwertsteuer (*)",0.08,null,{"$f":"ROUND(F51*$D55,-1)","v":0},0,0,0,0,0,0]
[null,"N","Nebenkosten inkl. MWSt",null,null,{"$f":"+F51+F55","v":0},0,0,0,0,0,{"$f":"SUM(F56:K56)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,null,{"$f":"+F51+F55","v":0},null,null,{"$f":"+I51+I55","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,null,{"$f":"+G51+G55","v":0},null,null,{"$f":"+J51+J55","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,null,{"$f":"+H51+H55","v":0},null,null,{"$f":"+K51+K55","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Unterschriften"]
[null,"Rechtsgültige Unterschriften",null,"Stempel / Unterschrift:",null,null,null,null,null,"Ort:","Datum:"]
[]
[]
[]
[]
[null,"Honorarberechnung nach den Baukosten"]
[null,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," "]
[null,{"$f":"+B$4","v":"Firmenname"},null,{"$f":"+D$4","v":0},null,null,null,null,null,null,{"$f":"+K$4","v":"Datum"},{"$f":"+L$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,null,{"$f":"+K$5","v":"Rev."},{"$f":"+L$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,null,{"$f":"+K$6","v":"Objekt Nr"},{"$f":"+L$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,null,{"$f":"+K$7","v":"PL GSZ"},{"$f":"+L$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Fachingenieur, Sparte ..."},null,null,null,null,null,null,{"$f":"+K$8","v":"Konto-Nr."},{"$f":"+L$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,null,{"$f":"+K$9","v":"BKP"},{"$f":"+L$9","v":0}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 108 (Ausgabe 2014); Art. 7 Honorarberechnung nach den Baukosten"]
[null,"Leistungen",null,"Grundleistungen nach SIA 108, 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,null,{"$f":"+F$30","v":"A"},{"$f":"+G$30","v":"B"},"C","D","E","F","Total"]
[null,"Ba","aufwandbestimmende Baukosten","CHF",null,{"$f":"+L193","v":0},{"$f":"+F89","v":0},{"$f":"+F89","v":0}]
[null,"Z1",2016,null,null,6.6000000000000003E-2,{"$f":"+F90","v":6.6000000000000003E-2},{"$f":"+F90","v":6.6000000000000003E-2}]
[null,"Z2",2016,null,null,11.28,{"$f":"+F91","v":11.28},{"$f":"+F91","v":11.28}]
[null,"p","Grundfaktor für Stundenaufwand",null,null,{"$f":"IF(+F89>0,(+F90+F91/(F89^(1/3))),0)","v":0},0,0,0,0,0]
[]
[null,"Grundleistungen (q)"]
[null,"Abk.","Bezeichnung","SIA 108",null,{"$f":"+F$30","v":"A"},{"$f":"+G$30","v":"B"},"C","D","E","F","Total"]
[null,"Phase","Teilleistung  (El: Elektro, San: Sanitär)","El","San","(%)","(%)","(%)","(%)","(%)","(%)","(%)"]
[null,31,"Vorprojekt  ",0.06,0.06,0.06,null,null,null,null,null,{"$f":"SUM(F97:K97)","v":0.06}]
[null,32,"Bauprojekt",0.18,0.2,0.18,null,null,null,null,null,{"$f":"SUM(F98:K98)","v":0.18}]
[null,33,"Bewilligungsverf. / Auflageprojekt","inkl.","inkl.",null,null,null,null,null,null,0]
[null,41,"Ausschreibung, Offertvergleich, Vergabeantrag",0.21,0.23,null,0.21,null,null,null,null,0.21]
[null,51,"Ausführungsprojekt",0.27,0.23,null,0.27,null,null,null,null,0.27]
[null,52,"Ausführung ",0.18,0.18,null,0.18,null,null,null,null,0.18]
[null,53,"Inbetriebnahme, Abschluss, Mängelbehebung",0.1,0.1,null,0.1,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"q","Total Grundleistungen",{"$f":"SUM(D97:D104)","v":0.99999999999999989},0.99999999999999989,0.24,0.7599999999999999,0,0,0,0,0.99999999999999989]
[]
[null,"Honorar nach Baukosten (H)"]
[null,"Abk.","Bezeichnung",null,null,{"$f":"+F$30","v":"A"},{"$f":"+G$30","v":"B"},"C","D","E","F","Total"]
[null,"Ba","aufwandbestimmende Baukosten","CHF",null,{"$f":"+F89","v":0},{"$f":"+G89","v":0},{"$f":"+H89","v":0}]
[null,"n","Schwierigkeitsgrad",null,null,1,{"$f":"+F110","v":1},{"$f":"+F110","v":1}]
[null,"r","Anpassungsfaktor",null,null,1,{"$f":"+F111","v":1},{"$f":"+F111","v":1}]
[null,null,null,null,null,0,{"$f":"+F112","v":0},{"$f":"+F112","v":0}]
[null,"Tm","Durchschnittlicher Zeitaufwand","Std.",null,{"$f":"+F89*F92*F105*F110*F111*IF(F112>0,F112,1)/100","v":0},{"$f":"+G89*G92*G105*G110*G111*IF(G112>0,G112,1)/100","v":0},{"$f":"+H89*H92*H105*H110*H111*IF(H112>0,H112,1)/100","v":0},null,null,null,{"$f":"SUM(F113:K113)","v":0}]
[null,"i","Teamfaktor",null,null,1,{"$f":"+F114","v":1},{"$f":"+F114","v":1}]
[null,"Tp","Prognostizierter Zeitaufwand","Std.",null,{"$f":"+F113*F114","v":0},{"$f":"+G113*G114","v":0},{"$f":"+H113*H114","v":0},null,null,null,{"$f":"SUM(F115:K115)","v":0}]
[null,"s","Faktor für Sonderleistungen",null,null,1,{"$f":"+F116","v":1},{"$f":"+F116","v":1}]
[null,"h","angebotener Stundenansatz","CHF",null,130,{"$f":"+F117","v":130},{"$f":"+F117","v":130}]
[null,"H","Honorar exkl. MWSt (*)","CHF",null,{"$f":"ROUND(F115*F116*F117,-1)","v":0},{"$f":"ROUND(G115*G116*G117,-1)","v":0},{"$f":"ROUND(H115*H116*H117,-1)","v":0},null,null,null,{"$f":"SUM(F118:K118)","v":0}]
[null,null,"Rabatt","%",null,0.15,{"$f":"+F119","v":0.15},{"$f":"+F119","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)","CHF",null,{"$f":"ROUND(F118*(100%-F119),-1)","v":0},{"$f":"ROUND(G118*(100%-G119),-1)","v":0},{"$f":"ROUND(H118*(100%-H119),-1)","v":0},null,null,null,{"$f":"SUM(F120:K120)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt","CHF",null,{"$f":"+F120","v":0},null,null,null,null,null,{"$f":"SUM(F121:K121)","v":0}]
[null,"TA2","Teilauftrag 2 exkl. MWSt","CHF",null,null,{"$f":"+G120","v":0},null,null,null,null,{"$f":"SUM(F122:K122)","v":0}]
[null,"TA3","Teilauftrag 3 exkl. MWSt","CHF",null,null,null,{"$f":"+H120","v":0},null,null,null,{"$f":"SUM(F123:K123)","v":0}]
[null,null,"Mehrwertsteuer (*)",0.08,null,{"$f":"ROUND(+F120*$D124,-1)","v":0},{"$f":"ROUND(+G120*$D124,-1)","v":0},{"$f":"ROUND(+H120*$D124,-1)","v":0},null,null,null,{"$f":"SUM(F124:H124)","v":0}]
[null,"H","Honorar inkl. MWSt (**)","CHF",null,{"$f":"ROUND(F120+F124,-2)","v":0},{"$f":"ROUND(G120+G124,-2)","v":0},{"$f":"ROUND(H120+H124,-2)","v":0},null,null,null,{"$f":"SUM(F125:K125)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt","CHF",null,{"$f":"+F125","v":0},null,null,{"$f":"+I125","v":0},null,null,{"$f":"SUM(F126:K126)","v":0}]
[null,"TA2","Teilauftrag 2 inkl. MWSt","CHF",null,null,{"$f":"+G125","v":0},null,null,{"$f":"+J125","v":0},null,{"$f":"SUM(F127:K127)","v":0}]
[null,"TA3","Teilauftrag 3 inkl. MWSt","CHF",null,null,null,{"$f":"+H125","v":0},null,null,{"$f":"+K125","v":0},{"$f":"SUM(F128:K128)","v":0}]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Aufwandbestimmende Baukosten"]
[null,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,null,{"$f":"+K$4","v":"Datum"},{"$f":"+L$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,null,{"$f":"+K$5","v":"Rev."},{"$f":"+L$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,null,{"$f":"+K$6","v":"Objekt Nr"},{"$f":"+L$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,null,{"$f":"+K$7","v":"PL GSZ"},{"$f":"+L$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Fachingenieur, Sparte ..."},null,null,null,null,null,null,{"$f":"+K$8","v":"Konto-Nr."},{"$f":"+L$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,null,{"$f":"+K$9","v":"BKP"},{"$f":"+L$9","v":0}]
[]
[null,"Honorarordnung",null,"Ordnung SIA 108 (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,null,"Kosten","Anteil","Berechtigt"]
[null,null,null,"Bemerkungen",null,null,null,null,null,"CHF","%","CHF"]
[null,1,"Vorbereitungsarbeiten"]
[null,10,"Aufnahmen, Baugrunduntersuchungen",null,null,null,null,null,null,0,0,{"$f":"+$J149*K149","v":0}]
[null,11,"Räumungen, Terrainvorbereitungen",null,null,null,null,null,null,0,0,0]
[null,119,"Entsorgung belastete Bauabfälle","(Mehrkosten) nicht aufwandbestimmend",null,null,null,null,null,0,0,0]
[null,12,"Sicherungen, Provisorien",null,null,null,null,null,null,null,null,0]
[null,13,"Gemeinsame Baustelleinrichtung",null,null,null,null,null,null,null,null,0]
[null,135,"Provisorische Installationen",null,null,null,null,null,null,0,0,0]
[null,14,"Anpassungen an best. Bauten",null,null,null,null,null,null,0,0,0]
[null,15,"Anpassungen an Erschl.leitungen",null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J157*K157","v":0}]
[null,19,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,null,null,0]
[null,2,"Gebäude"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J160*K160","v":0}]
[null,3,"Betriebseinrichtungen"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J162*K162","v":0}]
[null,4,"Umgebung"]
[null,40,"Terraingestaltung",null,null,null,null,null,null,0,null,{"$f":"+$J164*K164","v":0}]
[null,41,"Roh- und Ausbauarbeiten",null,null,null,null,null,null,0,null,0]
[null,42,"Gartenanlagen",null,null,null,null,null,null,0,null,0]
[null,44,"Installationen",null,null,null,null,null,null,0,null,0]
[null,443,"Elektroanlagen",null,null,null,null,null,null,0,0,0]
[null,444,"HLKK-Anlagen",null,null,null,null,null,null,0,0,0]
[null,445,"Sanitäranlagen",null,null,null,null,null,null,0,0,0]
[null,45,"Erschliessung durch Leitungen (innerhalb Grundstück)",null,null,null,null,null,null,0,null,0]
[null,453,"Elektroleitungen",null,null,null,null,null,null,0,0,0]
[null,454,"HLKK-Leitungen",null,null,null,null,null,null,0,0,0]
[null,455,"Sanitärleitungen",null,null,null,null,null,null,0,0,0]
[null,46,"Kleinere Trassenbauten",null,null,null,null,null,null,0,null,0]
[null,47,"Kleinere Kunstbauten",null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J177*K177","v":0}]
[null,49,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,0,null,0]
[null,5,"Baunebenkosten"]
[null,"50-56","Allgemeine Baunebenkosten","nicht aufwandbestimmend",null,null,null,null,null,0,0,{"$f":"+$J180*K180","v":0}]
[null,58,"Übergangskonten",null,null,null,null,null,null,null,null,{"$f":"+$J181*K181","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J182*K182","v":0}]
[null,6,"Reserven"]
[null,61,"Zuschlag Bauherrschaft","nicht aufwandbestimmend",null,null,null,null,null,0,null,{"$f":"+$J184*K184","v":0}]
[null,62,"Unvorhergesehenes","nicht aufwandbestimmend",null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J186*K186","v":0}]
[null,9,"Ausstattung"]
[null,98,"Kunst und Bau",null,null,null,null,null,null,0,0,0]
[null,99,"Honorare","nicht aufwandbestimmend",null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$J190*K190","v":0}]
[null,null,"Zwischentotal","inkl. MWSt",null,null,null,null,null,{"$f":"SUM(J148:J190)","v":0},null,{"$f":"SUM(L148:L190)","v":0}]
[null,null,"Mehrwertsteuer (*)","nicht aufwandbestimmend",null,null,null,null,0.08,{"$f":"ROUND(J191*I192/(100%+I192),-1)","v":0},null,{"$f":"ROUND(L191*I192/(100%+I192),-1)","v":0}]
[null,"B","Total (**)","Aufwandbestimmende Baukosten exkl. MWSt",null,null,null,null,null,{"$f":"ROUND(SUM(J191-J192),-2)","v":0},null,{"$f":"ROUND(SUM(L191-L192),-2)","v":0}]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]
[]
[null,"Honorarberechnung nach dem effektiven Zeitaufwand"]
[null,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,null,{"$f":"+K$4","v":"Datum"},{"$f":"+L$4","v":"00:00:00"}]
[null,{"$f":"+B$5","v":"Bezeichnung"},null,{"$f":"+D$5","v":0},null,null,null,null,null,null,{"$f":"+K$5","v":"Rev."},{"$f":"+L$5","v":"00:00:00"}]
[null,{"$f":"+B$6","v":"Adresse, Ort"},null,{"$f":"+D$6","v":0},null,null,null,null,null,null,{"$f":"+K$6","v":"Objekt Nr"},{"$f":"+L$6","v":0}]
[null,{"$f":"+B$7","v":"verantwortlich  "},null,{"$f":"+D$7","v":0},null,null,null,null,null,null,{"$f":"+K$7","v":"PL GSZ"},{"$f":"+L$7","v":0}]
[null,{"$f":"+B$8","v":"Auftragsbezeichnung"},null,{"$f":"+D$8","v":"Fachingenieur, Sparte ..."},null,null,null,null,null,null,{"$f":"+K$8","v":"Konto-Nr."},{"$f":"+L$8","v":0}]
[null,{"$f":"+B$9","v":"Objektbezeichnung"},null,{"$f":"+D$9","v":0},null,null,null,null,null,null,{"$f":"+K$9","v":"BKP"},{"$f":"+L$9","v":0}]
[]
[null,"Honorarordnung",null,"Ordnung 108 (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,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",null,"Bemerkungen",null,null,null,null,"KBOB","Ansatz"]
[null,null,null,null,null,null,null," ",null,null,"maximal","vereinbart"]
[null,null,null,"A",null,null,null,null,null,null,232]
[null,null,null,"B",null,"Maximal verrechenbare Kategorie",null,null,null,null,182]
[null,null,null,"C",null,null,null,null,null,null,157]
[null,null,null,"D",null,null,null,null,null,null,133]
[null,null,null,"E",null,null,null,null,null,null,111]
[null,null,null,"F",null,null,null,null,null,null,101]
[null,null,null,"G",null,null,null,null,null,null,97]
[null,"Mittelansatz für Planungsgruppen",null,null,null,"Mittlerer Ansatz",null,162,"Faktor (a)",0.8,"MA",{"$f":"+H226*J226","v":129.6}]
[]
[null,"Honorar nach dem effektivem Zeitaufwand (H)"]
[null,"Abk.","Bezeichnung",null,null," ",null,null,null,"Aufwand","Ansatz","Honorar"]
[null,"Phase","Teilleistung","Bemerkungen",null,null,null," ",null,"Tt (Std.)","h (CHF)","H (CHF)"]
[null,"TA1",null,null,null,null,null,null,null,null,null,{"$f":"+J231*K231","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,null,{"$f":"+J232*K232","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,null,{"$f":"+J233*K233","v":0}]
[null,"TA1",null,null,null,null,null,null,null,null,null,{"$f":"+J234*K234","v":0}]
[null,"TA1","Total Teilauftrag 1","exkl. MWSt",null,null,null,"Kostendach",null,null,null,{"$f":"SUM(L231:L234)","v":0}]
[]
[null,"TA2",null,null,null,null,null,null,null,null,null,{"$f":"+J237*K237","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,null,{"$f":"+J238*K238","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,null,{"$f":"+J239*K239","v":0}]
[null,"TA2",null,null,null,null,null,null,null,null,null,{"$f":"+J240*K240","v":0}]
[null,"TA2","Total Teilauftrag 2","exkl. MWSt",null,null,null,"Kostendach",null,null,null,{"$f":"SUM(L237:L240)","v":0}]
[]
[null,"TA3",null,null,null,null,null,null,null,null,null,{"$f":"+J243*K243","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,null,{"$f":"+J244*K244","v":0}]
[null,"TA3",null,null,null,null,null,null,null,null,null,0]
[null,"TA3",null,null,null,null,null,null,null,null,null,{"$f":"+J246*K246","v":0}]
[null,"TA3","Total Teilauftrag 3","exkl. MWSt",null,null,null,"Kostendach",null,null,null,{"$f":"SUM(L243:L246)","v":0}]
[null," ","Total",null,null,null,null,null,null,{"$f":"SUM(J231:J247)","v":0},null,{"$f":"SUM(L235+L241+L247)","v":0}]
[]
[null,"Phase","Objekt / Anlageteil",null,null,{"$f":"+F$30","v":"A"},{"$f":"+G$30","v":"B"},"C","D","E","F","Total"]
[null,null,"Bezeichnung",null,null,"CHF","CHF","CHF","CHF","CHF","CHF","CHF"]
[null,null,"Rabatt",null,null,null,null,null,0.15,{"$f":"+I252","v":0.15},{"$f":"+I252","v":0.15}]
[null,"H","Honorar exkl. MWSt (*)",null,null,null,null,null,{"$f":"ROUND(L235*(100%-I252),-1)","v":0},{"$f":"ROUND(L241*(100%-J252),-1)","v":0},{"$f":"ROUND(L247*(100%-K252),-1)","v":0},{"$f":"SUM(F253:K253)","v":0}]
[null,"TA1","Teilauftrag 1 exkl. MWSt",null,null,null,null,null,{"$f":"+I253","v":0},null,null,{"$f":"SUM(F254:K254)","v":0}]
[null,"TA2","Teilauftrag 2 exkl. MWSt",null,null,null,null,null,null,{"$f":"+J253","v":0},null,0]
[null,"TA3","Teilauftrag 3 exkl. MWSt",null,null,null,null,null,null,null,{"$f":"+K253","v":0},0]
[null,null,"Mehrwertsteuer (*)",0.08,null,null,null,null,{"$f":"ROUND(+I253*$D257,-1)","v":0},{"$f":"ROUND(+J253*$D257,-1)","v":0},{"$f":"ROUND(+K253*$D257,-1)","v":0},{"$f":"SUM(F257:K257)","v":0}]
[null,"H","Honorar inkl. MWSt (**)",null,null,null,null,null,{"$f":"ROUND(I253+I257,-2)","v":0},{"$f":"ROUND(J253+J257,-2)","v":0},{"$f":"ROUND(K253+K257,-2)","v":0},{"$f":"SUM(F258:K258)","v":0}]
[null,"TA1","Teilauftrag 1 inkl. MWSt",null,null,null,null,null,{"$f":"+I258","v":0},null,null,0]
[null,"TA2","Teilauftrag 2 inkl. MWSt",null,null,null,null,null,null,{"$f":"+J258","v":0},null,0]
[null,"TA3","Teilauftrag 3 inkl. MWSt",null,null,null,null,null,null,null,{"$f":"+K258","v":0},0]
[null,null,"(*) / (**) = gerundet auf CHF 10.- / CHF 100.-"]