{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kostenvoranschlag"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Kostenvoranschlag","index":0,"n_rows":267,"n_cols":16,"rows_kept":267}
["Objekt"]
["Auftrag"]
[]
["Kostenvoranschlag",{"$nulls":3},"Datum",null,"KV Original","Mutation","KV aktuell","Stichtag","Teuerung","Teuerung","Teuerung","KV indexiert",null,"Bemerkungen"]
[{"$nulls":9},"yyyy.mm"]
[]
[1,"Vorbereitungsarbeiten",{"$nulls":4},{"$f":"SUM(G8+G15+G25+G32+G45+G55+G64+G69+G77)","v":0},{"$f":"SUM(H8+H15+H25+H32+H45+H55+H64+H69+H77)","v":0},{"$f":"SUM(I8+I15+I25+I32+I45+I55+I64+I69+I77)","v":0},{"$nulls":4},{"$f":"SUM(N8+N15+N25+N32+N45+N55+N64+N69+N77)","v":0}]
[null,10,"Bestandsaufnahmen, Baugrunduntersuchungen",{"$nulls":3},{"$f":"SUM(G9:G14)","v":0},{"$f":"SUM(H9:H14)","v":0},{"$f":"SUM(I9:I14)","v":0},{"$nulls":4},{"$f":"SUM(N9:N14)","v":0}]
[null,null,101,"Bestandsaufnahmen"]
[null,null,102,"Baugrunduntersuchungen"]
[null,null,103,"Grundwasseruntersuchungen"]
[null,null,104,"Baugespann"]
[null,null,109,"Übriges"]
[]
[null,11,"Räumungen, Terrainvorbereitungen",{"$nulls":3},{"$f":"SUM(G16:G24)","v":0},{"$f":"SUM(H16:H24)","v":0},{"$f":"SUM(I16:I24)","v":0},{"$nulls":4},{"$f":"SUM(N16:N24)","v":0}]
[null,null,111,"Rodungen"]
[null,null,112,"Rückbau"]
[null,null,{"v":112,"d":"112.0"},"Demontagen"]
[null,null,112.1,"Abbrüche"]
[null,null,112.2,"Entsorgung spezieller Baustoffe"]
[null,null,113,"Sanierung Altlasten"]
[null,null,114,"Erdbewegungen"]
[null,null,115,"Bohr- und Schneidarbeiten"]
[]
[null,12,"Sicherungen, Provisorien",{"$nulls":3},{"$f":"SUM(G26:G31)","v":0},{"$f":"SUM(H26:H31)","v":0},{"$f":"SUM(I26:I31)","v":0},{"$nulls":4},{"$f":"SUM(N26:N31)","v":0}]
[null,null,121,"Sicherung vorhandener Anlagen"]
[null,null,122,"Provisorien"]
[null,null,123,"Unterfangungen"]
[null,null,124,"Instandsetzungsarbeiten"]
[null,null,129,"Übriges"]
[]
[null,13,"Gemeinsame Baustelleneinrichtung",{"$nulls":3},{"$f":"SUM(G33:G44)","v":0},{"$f":"SUM(H33:H44)","v":0},0,{"$nulls":4},{"$f":"SUM(N33:N44)","v":0}]
[null,null,131,"Abschrankungen"]
[null,null,132,"Zufahrten, Plätze"]
[null,null,133,"Büro Bauleitung"]
[null,null,135,"Provisorische Installationen"]
[null,null,{"v":135,"d":"135.0"},"Kanalisationen"]
[null,null,135.1,"Elektro"]
[null,null,135.3,"Wasser"]
[null,null,136,"Kosten für Energie, Wasser und dgl."]
[null,null,137,"Provisorische Abschlüsse und Abdeckungen"]
[null,null,138,"Sortierung Bauabfälle"]
[null,null,139,"Übriges"]
[]
[null,14,"Anpassungen an bestehende Bauten",{"$nulls":3},{"$f":"SUM(G46:G54)","v":0},{"$f":"SUM(H46:H54)","v":0},0,{"$nulls":4},{"$f":"SUM(N46:N54)","v":0}]
[null,null,141,"Terraingestaltung, Rohbau 1"]
[null,null,{"v":141,"d":"141.0"},"Erdarbeiten"]
[null,null,141.1,"Baumeisterarbeiten"]
[null,null,141.6,"Natur- und Kunststeinarbeiten"]
[null,null,142,"Rohbau 2"]
[null,null,143,"Elektroanlagen"]
[null,null,145,"Sanitäranlagen"]
[null,null,149,"Übriges"]
[]
[null,15,"Anpassungen an bestehende Erschliessungsanlagen",{"$nulls":3},{"$f":"SUM(G56:G63)","v":0},{"$f":"SUM(H56:H63)","v":0},0,{"$nulls":4},{"$f":"SUM(N56:N63)","v":0}]
[null,null,151,"Erdarbeiten"]
[null,null,152,"Kanalisationsleitungen"]
[null,null,153,"Elektroleitungen, Gebäudeautomation"]
[null,null,154,"Leitungen für HLK-Anlagen"]
[null,null,155,"Sanitärleitungen"]
[null,null,156,"Nebenarbeiten"]
[null,null,159,"Übriges"]
[]
[null,16,"Anpassungen an bestehende Verkehrsanlagen",{"$nulls":3},{"$f":"SUM(G65:G68)","v":0},{"$f":"SUM(H65:H68)","v":0},0,{"$nulls":4},{"$f":"SUM(N65:N68)","v":0}]
[null,null,161,"Strassen"]
[null,null,162,"Bahnen"]
[null,null,169,"Übriges"]
[]
[null,17,"Spezialtiefbau",{"$nulls":3},{"$f":"SUM(G70:G76)","v":0},{"$f":"SUM(H70:H76)","v":0},0,{"$nulls":4},{"$f":"SUM(N70:N76)","v":0}]
[null,null,171,"Pfähle"]
[null,null,172,"Baugrubenabschlüsse"]
[null,null,174,"Anker"]
[null,null,175,"Grundwasserabdichtungen"]
[null,null,176,"Wasserhaltung"]
[null,null,179,"Übriges"]
[]
[null,19,"Honorare",{"$nulls":3},{"$f":"SUM(G78:G92)","v":0},{"$f":"SUM(H78:H92)","v":0},0,{"$nulls":4},{"$f":"SUM(N78:N92)","v":0}]
[null,null,191,"Architekt"]
[null,null,192,"Bauingenieur"]
[null,null,193,"Elektroingenieur"]
[null,null,194,"HLK-Ingenieur"]
[null,null,195,"Sanitäringenieur"]
[null,null,196,"Landschaftsarchitekt"]
[null,null,197,"Spezialisten 1"]
[null,null,{"v":197,"d":"197.0"},"Geometer"]
[null,null,197.1,"Geologe, Geotechniker"]
[null,null,198,"Spezialisten 2"]
[null,null,198.2,"Bauökonom"]
[null,null,198.4,"Umweltingenieur"]
[null,null,199,"Übriges"]
[]
[]
["4     Umgebung",{"$nulls":5},{"$f":"SUM(G94+G100+G131+G142+G149+G159+G166+G175)","v":0},{"$f":"SUM(H94+H100+H131+H142+H149+H159+H166+H175)","v":0},{"$f":"SUM(I94+I100+I131+I142+I149+I159+I166+I175)","v":0},{"$nulls":4},{"$f":"SUM(N94+N100+N131+N142+N149+N159+N166+N175)","v":0}]
[null,40,"Terraingestaltung",{"$nulls":3},{"$f":"SUM(G95:G99)","v":0},{"$f":"SUM(H95:H99)","v":0},{"$f":"SUM(I95:I99)","v":0},{"$nulls":4},{"$f":"SUM(N95:N99)","v":0}]
[null,null,401,"Erdbewegungen"]
[null,null,"401.0","Baustelleneinrichtung"]
[null,null,401.1,"Erdarbeiten"]
[null,null,409,"Übriges"]
[]
[null,41,"Rohbau- und Ausbauarbeiten",{"$nulls":3},{"$f":"SUM(G101:G130)","v":0},{"$f":"SUM(H101:H130)","v":0},{"$f":"SUM(I101:I130)","v":0},{"$nulls":4},{"$f":"SUM(N101:N130)","v":0}]
[null,null,411,"Baumeisterarbeiten"]
[null,null,"411.0","Baustelleneinrichtung"]
[null,null,411.1,"Gerüste"]
[null,null,411.2,"Böschungs-, Uferverbauungen"]
[null,null,411.3,"Baumeisteraushub"]
[null,null,411.4,"Kanalisationen ausserhalb Gebäude"]
[null,null,411.5,"Beton- und Stahlbetonarbeiten"]
[null,null,411.6,"Maurerarbeiten"]
[null,null,411.7,"Instandsetzungsarbeiten"]
[null,null,411.8,"Witterungsbedingte Massnahmen"]
[null,null,413,"Übriger Rohbau 1"]
[null,null,413.2,"Montagebau in Beton, vorgefertigtem Mauerwerk"]
[null,null,413.3,"Montagebau in Stahl"]
[null,null,413.4,"Montagebau in Holz"]
[null,null,413.5,"Montagebau als Leichtkonstruktion"]
[null,null,413.6,"Natur- und Kunststeinarbeiten"]
[null,null,414,"Rohbau 2"]
[null,null,414.1,"Fenster, Aussentüren, Tore"]
[null,null,414.2,"Spenglerarbeiten"]
[null,null,414.3,"Blitzschutzanlagen"]
[null,null,414.4,"Bedachungsarbeiten"]
[null,null,414.5,"Spezielle Dichtungen und Dämmungen"]
[null,null,414.6,"Fassadenputze"]
[null,null,414.7,"Äussere Oberflächenbehandlungen"]
[null,null,414.8,"Äussere Abschlüsse, Sonnenschutzanlagen"]
[null,null,414.9,"Arealabschlüsse"]
[null,null,415,"Ausbau 1"]
[null,null,416,"Ausbau 2"]
[null,null,419,"Übriges"]
[]
[null,42,"Gartenanlagen",{"$nulls":3},{"$f":"SUM(G132:G141)","v":0},{"$f":"SUM(H132:H141)","v":0},{"$f":"SUM(I132:I141)","v":0},{"$nulls":4},{"$f":"SUM(N132:N141)","v":0}]
[null,null,421,"Gärtnerarbeiten"]
[null,null,421.1,"Garten- und Landschaftsbau"]
[null,null,421.2,"Pflanzenlieferung"]
[null,null,421.3,"Erstellungspflege"]
[null,null,422,"Einfriedungen"]
[null,null,423,"Ausstattungen, Geräte"]
[null,null,424,"Spiel- und Sportplätze"]
[null,null,425,"Stützmauern"]
[null,null,429,"Übriges"]
[]
[null,44,"Installationen",{"$nulls":3},{"$f":"SUM(G143:G148)","v":0},{"$f":"SUM(H143:H148)","v":0},0,{"$nulls":4},0]
[null,null,443,"Elektroanlagen"]
[null,null,444,"HLK-Anlagen, Gebäudeautomation"]
[null,null,445,"Sanitäranlagen"]
[null,null,446,"Transportanlagen"]
[null,null,449,"Übriges"]
[]
[null,45,"Leitungen innerhalb Grundstück",{"$nulls":3},{"$f":"SUM(G150:G158)","v":0},{"$f":"SUM(H150:H158)","v":0},{"$f":"SUM(I150:I158)","v":0},{"$nulls":4},{"$f":"SUM(N150:N158)","v":0}]
[null,null,451,"Erdarbeiten"]
[null,null,452,"Kanalisationsleitungen"]
[null,null,453,"Elektroleitungen, Gebäudeautomation"]
[null,null,454,"Leitungen für HLK-Anlagen"]
[null,null,455,"Sanitärleitungen"]
[null,null,456,"Nebenarbeiten"]
[null,null,458,"Kanalspülung"]
[null,null,459,"Übriges"]
[]
[null,46,"Kleinere Trassenbauten",{"$nulls":3},{"$f":"SUM(G160:G165)","v":0},{"$f":"SUM(H160:H165)","v":0},0,{"$nulls":4},{"$f":"SUM(N160:N165)","v":0}]
[null,null,461,"Erd- und Unterbau"]
[null,null,463,"Oberbau"]
[null,null,464,"Entwässerung"]
[null,null,465,"Werkleitungen und Kanalisationen"]
[null,null,468,"Ausbau"]
[]
[null,47,"Kunstbauten",{"$nulls":3},{"$f":"SUM(G167:G174)","v":0},{"$f":"SUM(H167:H174)","v":0},{"$f":"SUM(I167:I174)","v":0},{"$nulls":4},{"$f":"SUM(N167:N174)","v":0}]
[null,null,471,"Baugrube"]
[null,null,472,"Tragkonstruktionen"]
[null,null,473,"Oberbau"]
[null,null,474,"Entwässerung"]
[null,null,475,"Werkleitungen und Kanalisationen"]
[null,null,477,"Transportanlagen"]
[null,null,478,"Ausbau"]
[]
[null,49,"Honorare",{"$nulls":3},{"$f":"SUM(G176:G194)","v":0},{"$f":"SUM(H176:H194)","v":0},{"$f":"SUM(I176:I194)","v":0},{"$nulls":4},{"$f":"SUM(N176:N194)","v":0}]
[null,null,491,"Architekt"]
[null,null,492,"Bauingenieur"]
[null,null,493,"Elektroingenieur"]
[null,null,494,"HLK-Ingenieur"]
[null,null,495,"Sanitäringenieur"]
[null,null,496,"Landschaftsarchitekt"]
[null,null,497,"Spezialisten 1"]
[null,null,{"v":497,"d":"497.0"},"Geometer"]
[null,null,497.1,"Geologe, Geotechniker"]
[null,null,497.2,"Innenarchitekt"]
[null,null,497.3,"Bauphysiker"]
[null,null,497.4,"Akustiker"]
[null,null,497.5,"Fachkoordinator"]
[null,null,498,"Spezialisten 2"]
[null,null,498.2,"Bauökonom"]
[null,null,498.4,"Umweltingenieur"]
[null,null,499,"Übriges"]
[]
[]
["5     Baunebenkosten und Übergangskonten",{"$nulls":5},{"$f":"SUM(G196+G200+G212+G222+G227+G232+G243)","v":0},{"$f":"SUM(H196+H200+H212+H222+H227+H232+H243)","v":0},{"$f":"SUM(I196+I200+I212+I222+I227+I232+I243)","v":0},{"$nulls":4},{"$f":"SUM(N196+N200+N212+N222+N227+N232+N243)","v":0}]
[null,50,"Wettbewerbskosten",{"$nulls":3},{"$f":"SUM(G197:G199)","v":0},{"$f":"SUM(H197:H199)","v":0},0,{"$nulls":4},0]
[null,null,"501","Wettbewerbe"]
[null,null,"509","Übriges"]
[]
[null,51,"Bewilligungen, Gebühren",{"$nulls":3},{"$f":"SUM(G201:G211)","v":0},{"$f":"SUM(H201:H211)","v":0},{"$f":"SUM(I201:I211)","v":0},{"$nulls":4},{"$f":"SUM(N201:N211)","v":0}]
[null,null,511,"Bewilligungen,  Gebühren"]
[null,null,512,"Anschlussgebühren"]
[null,null,"512.0","Kanalisation"]
[null,null,512.1,"Elektrizität"]
[null,null,512.2,"Kommunikation"]
[null,null,512.3,"Gas"]
[null,null,512.4,"Wasser"]
[null,null,512.5,"Fernheizung"]
[null,null,512.6,"Radio, Fernsehen"]
[null,null,519,"Übriges"]
[]
[null,52,"Dokumentation und Präsentation",{"$nulls":3},{"$f":"SUM(G213:G221)","v":0},{"$f":"SUM(H213:H221)","v":0},{"$f":"SUM(I213:I221)","v":0},{"$nulls":4},{"$f":"SUM(N213:N221)","v":0}]
[null,null,521,"Muster, Materialprüfungen"]
[null,null,{"v":521,"d":"521.0"},"Muster"]
[null,null,521.1,"Materialprüfungen"]
[null,null,522,"Modelle"]
[null,null,523,"Fotos"]
[null,null,524,"Vervielfältigungen, Plandokumente"]
[null,null,525,"Dokumentation"]
[null,null,529,"Übriges"]
[]
[null,53,"Versicherungen",{"$nulls":3},{"$f":"SUM(G223:G226)","v":0},{"$f":"SUM(H223:H226)","v":0},{"$f":"SUM(I223:I226)","v":0},{"$nulls":4},{"$f":"SUM(N223:N226)","v":0}]
[null,null,531,"Bauzeitversicherungen"]
[null,null,532,"Spezialversicherungen"]
[null,null,539,"Übriges"]
[]
[null,55,"Bauherrenleistungen",{"$nulls":3},{"$f":"SUM(G228:G231)","v":0},{"$f":"SUM(H228:H231)","v":0},{"$f":"SUM(I228:I231)","v":0},{"$nulls":4},{"$f":"SUM(N228:N231)","v":0}]
[null,null,557,"Betriebsplanung"]
[null,null,558,"Projektleitung, Projektbegleitung"]
[null,null,559,"Übriges"]
[]
[null,56,"Übrige Baunebenkosten",{"$nulls":3},{"$f":"SUM(G233:G242)","v":0},{"$f":"SUM(H233:H242)","v":0},{"$f":"SUM(I233:I242)","v":0},{"$nulls":4},{"$f":"SUM(N233:N242)","v":0}]
[null,null,561,"Bewachung durch Dritte"]
[null,null,562,"Entschädigungen, Nutzerkosten, Ersatzabgaben"]
[null,null,563,"Miete von fremdem Grund"]
[null,null,564,"Gutachten"]
[null,null,565,"Reisespesen"]
[null,null,566,"Grundsteinlegung, Aufrichte, Einweihung"]
[null,null,567,"Anwaltskosten, Gerichtskosten"]
[null,null,568,"Baureklame"]
[null,null,569,"Übriges"]
[]
[null,58,"Rückstellungen und Reserven",{"$nulls":3},{"$f":"SUM(G244:G248)","v":0},{"$f":"SUM(H244:H248)","v":0},{"$f":"SUM(I244:I248)","v":0},{"$nulls":4},{"$f":"SUM(N244:N248)","v":0}]
[null,null,580,"Übergangsposition"]
[null,null,581,"Rückstellungen für zu erwartende Kosten"]
[null,null,582,"Rückstellungen für Teuerung"]
[null,null,589,"Übriges"]
[]
[]
["6     Reserve",{"$nulls":5},{"$f":"SUM(G251+G254+G257+G260+G263)","v":0},{"$f":"SUM(H251+H254+H257+H260+H263)","v":0},{"$f":"SUM(I251+I254+I257+I260+I263)","v":0},{"$nulls":4},{"$f":"SUM(N251+N254+N257+N260+N263)","v":0}]
[null,61,"Zuschlag Bauherrschaft",{"$nulls":3},{"$f":"SUM(G252:G253)","v":0},{"$f":"SUM(H252:H253)","v":0},0,{"$nulls":4},0]
[null,null,"611","Zuschlag Bauherrschaft"]
[]
[null,62,"Unvorhergesehenes",{"$nulls":3},{"$f":"SUM(G255:G256)","v":0},{"$f":"SUM(H255:H256)","v":0},0,{"$nulls":4},0]
[null,null,"621","Unvorhergesehenes"]
[]
[null,66,"Verrechnung zu Lasten GSZ",{"$nulls":3},{"$f":"SUM(G258:G259)","v":0},{"$f":"SUM(H258:H259)","v":0},{"$f":"SUM(I258:I259)","v":0},{"$nulls":4},{"$f":"SUM(N258:N259)","v":0}]
[null,null,"661","Kostenbeteiligung GSZ"]
[]
[null,67,"Verrechnung zu Gunsten GSZ",{"$nulls":3},{"$f":"SUM(G261:G262)","v":0},{"$f":"SUM(H261:H262)","v":0},{"$f":"SUM(I261:I262)","v":0},{"$nulls":4},{"$f":"SUM(N261:N262)","v":0}]
[null,null,"671","Kostenbeteiligung Dritter"]
[]
[null,69,"Rückstellungen",{"$nulls":3},{"$f":"SUM(G264:G266)","v":0},{"$f":"SUM(H264:H266)","v":0},{"$f":"SUM(I264:I266)","v":0},{"$nulls":4},{"$f":"SUM(N264:N266)","v":0}]
[null,null,"691","Rückstellungen"]
[]
[]
[{"$nulls":6},{"$f":"SUM(G7+G93+G195+G250)","v":0},{"$f":"SUM(H7+H93+H195+H250)","v":0},{"$f":"SUM(I7+I93+I195+I250)","v":0},{"$nulls":4},{"$f":"SUM(N7+N93+N195+N250)","v":0}]