{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Abrechnungsformular","Abrechnungsformular_plus","Statistik AV","Liste"],"not_rendered":{"charts":0,"images":1,"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":"Abrechnungsformular","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,14,1,14],[5,14,6,14],[25,0,25,11],[32,3,32,8],[36,8,36,9],[10,10,10,11],[10,7,10,8],[33,3,33,8],[28,6,28,7],[29,6,29,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Kanton Zürich",null,"Stadt / Gemeinde"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(INDEX(Liste!B:C,MATCH(O3,Liste!A:A,0),1),\" \",INDEX(Liste!B:C,MATCH(O3,Liste!A:A,0),2))","v":"Gemeinde / Stadt"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BFS-Nr."]
["Abrechnungsformular"]
["Gebührenpflichtige Leistungen gemäss Gebührenverordnung für Geodaten vom 30.08.2017 (LS 704.15)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standardfälle"]
["1. Grundpreis",null,null,null,null,null,null,null,null,null,null,null,"Fr."]
[" Administration (1 x pro Auftrag)",null,null,null,null,null,null,"Pauschal",1,null,"Preis",50,{"$f":"I8*L8","v":50}]
[]
["2. Grafische Produkte (Plan für das Grundbuch, Katasterplan amtliche Vermessung)"]
[" Format",null,null,null,null,null,null,"Ausschnitte",null,null,"Auflage Papier"]
[null,null,null,null,null,null,null,"Anzahl","Preis",null,"Anzahl","Preis"]
[" bis A3",null,null,null,null,null,null,null,15,null,null,5,{"$f":"IF(H13>0,H13*I13+K13*L13,0)","v":0}]
[" A2 (42x60)",null,null,null,null,null,null,null,30,null,null,10,{"$f":"IF(H14>0,H14*I14+K14*L14,0)","v":0}]
[" A1 (60x84)",null,null,null,null,null,null,null,30,null,null,20,{"$f":"IF(H15>0,H15*I15+K15*L15,0)","v":0}]
[" A0 (1m²)",null,null,null,null,null,null,null,30,null,null,40,{"$f":"IF(H16>0,H16*I16+K16*L16,0)","v":0}]
[]
["3. Zusatzarbeiten"]
["3.1 Nachträgliche Richtigkeitsbestätigung gemäss § 3 Abs. 1 lit. a der Bauverfahrensverordnung vom 3. Dezember 1997"]
[" 1. Kontrolle von Kundenplänen",null,null,null,"bis A3",null,null,"Anz. Ausschnitte",null,null,"Preis",100,{"$f":"I20*L20","v":0}]
[" (bis 10 Exemplare)",null,null,null,"grösser A3",null,null,"Anz. Ausschnitte",null,null,"Preis",150,{"$f":"I21*L21","v":0}]
[" Nachkontrollen von Kundenplänen",null,null,null,"bis A3",null,null,"Anz. Ausschnitte",null,null,"Preis",80,{"$f":"I22*L22","v":0}]
[" (bis 10 Exemplare)",null,null,null,"grösser A3",null,null,"Anz. Ausschnitte",null,null,"Preis",100,{"$f":"I23*L23","v":0}]
[null,null,null,null,null,null,null,"weitere Exemplare pro Ausschnitt",null,null,"Preis",5,{"$f":"SUM(I20:I21)*I24*L24","v":0}]
[]
["3.2 Beglaubigung gemäss Art. 73a der Technischen Verordnung des VBS über die amtliche Vermessung vom 10. Juni 1994 bzw.\n      § 6 der kantonalen Verordnung über den Kataster der öffentlich-rechtlichen Eigentumsbeschränkungen vom 30. August 2017"]
[" Pläne pro Ausschnitt bzw. Auszug",null,null,null,null,null,null,"1. Exemplar",null,null,"Preis",50,{"$f":"I27*L27","v":0}]
[null,null,null,null,null,null,null,"weitere Exemplare",null,null,"Preis",5,{"$f":"I28*L28","v":0}]
[" Nachträgliche Beglaubigung",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I29*L29","v":0}]
[" (gemäss Art. 38 Abs. 2 VAV)",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I30*L30","v":0}]
[]
["3.3 Zusätzliche Aufwendungen"]
[" Fremdrechnung ohne MWSt.",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L33","v":0}]
[" Transportkosten, Verpackung",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L34","v":0}]
[]
["4. Zusammenfassung"]
[" Summe ohne Pos 3.3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M30)","v":50}]
[" Zusätzliche Aufwendungen (Pos 3.3)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M33:M34)","v":0}]
[" Total",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M37+M38","v":50}]
[" Mehrwertsteuer",null,null,null,null,null,null,null,null,null,null,8.1000000000000003E-2,{"$f":"MROUND(M39*L40,0.05)","v":4.05}]
[" Rechnungstotal",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M39+M40","v":54.05}]

{"sheet":"Abrechnungsformular_plus","index":1,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[28,6,28,7],[29,6,29,7],[46,1,46,5],[46,6,46,7],[0,14,1,14],[5,14,6,14],[10,7,10,8],[10,10,10,11],[25,0,25,11],[32,3,32,8],[45,1,45,5],[45,6,45,7],[44,1,44,5],[44,6,44,7],[33,3,33,8],[36,8,36,9],[43,1,43,5],[43,6,43,7],[49,8,49,9],[55,8,55,9],[56,8,56,9],[47,3,47,8],[48,3,48,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Kanton Zürich",null,"Stadt / Gemeinde"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(INDEX(Liste!B:C,MATCH(O3,Liste!A:A,0),1),\" \",INDEX(Liste!B:C,MATCH(O3,Liste!A:A,0),2))","v":"Gemeinde / Stadt"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BFS-Nr."]
["Abrechnungsformular"]
["A. Gebührenpflichtige Leistungen gemäss Gebührenverordnung für Geodaten vom 30.08.2017 (LS 704.15)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standardfälle"]
["1. Grundpreis",null,null,null,null,null,null,null,null,null,null,null,"Fr."]
[" Administration (1 x pro Auftrag)",null,null,null,null,null,null,"Pauschal",1,null,"Preis",50,{"$f":"I8*L8","v":50}]
[]
["2. Grafische Produkte (Plan für das Grundbuch, Katasterplan amtliche Vermessung)"]
[" Format",null,null,null,null,null,null,"Ausschnitte",null,null,"Auflage Papier"]
[null,null,null,null,null,null,null,"Anzahl","Preis",null,"Anzahl","Preis"]
[" bis A3",null,null,null,null,null,null,null,15,null,null,5,{"$f":"IF(H13>0,H13*I13+K13*L13,0)","v":0}]
[" A2 (42x60)",null,null,null,null,null,null,null,30,null,null,10,{"$f":"IF(H14>0,H14*I14+K14*L14,0)","v":0}]
[" A1 (60x84)",null,null,null,null,null,null,null,30,null,null,20,{"$f":"IF(H15>0,H15*I15+K15*L15,0)","v":0}]
[" A0 (1m²)",null,null,null,null,null,null,null,30,null,null,40,{"$f":"IF(H16>0,H16*I16+K16*L16,0)","v":0}]
[]
["3. Zusatzarbeiten"]
["3.1 Nachträgliche Richtigkeitsbestätigung gemäss § 3 Abs. 1 lit. a der Bauverfahrensverordnung vom 3. Dezember 1997"]
[" 1. Kontrolle von Kundenplänen",null,null,null,"bis A3",null,null,"Anz. Ausschnitte",null,null,"Preis",100,{"$f":"I20*L20","v":0}]
[" (bis 10 Exemplare)",null,null,null,"grösser A3",null,null,"Anz. Ausschnitte",null,null,"Preis",150,{"$f":"I21*L21","v":0}]
[" Nachkontrollen von Kundenplänen",null,null,null,"bis A3",null,null,"Anz. Ausschnitte",null,null,"Preis",80,{"$f":"I22*L22","v":0}]
[" (bis 10 Exemplare)",null,null,null,"grösser A3",null,null,"Anz. Ausschnitte",null,null,"Preis",100,{"$f":"I23*L23","v":0}]
[null,null,null,null,null,null,null,"weitere Exemplare pro Ausschnitt",null,null,"Preis",5,{"$f":"SUM(I20:I21)*I24*L24","v":0}]
[]
["3.2 Beglaubigung gemäss Art. 73a der Technischen Verordnung des VBS über die amtliche Vermessung vom 10. Juni 1994 bzw.\n      § 6 der kantonalen Verordnung über den Kataster der öffentlich-rechtlichen Eigentumsbeschränkungen vom 30. August 2017"]
[" Pläne pro Ausschnitt bzw. Auszug",null,null,null,null,null,null,"1. Exemplar",null,null,"Preis",50,{"$f":"I27*L27","v":0}]
[null,null,null,null,null,null,null,"weitere Exemplare",null,null,"Preis",5,{"$f":"I28*L28","v":0}]
[" Nachträgliche Beglaubigung",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I29*L29","v":0}]
[" (gemäss Art. 38 Abs. 2 VAV)",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I30*L30","v":0}]
[]
["3.3 Zusätzliche Aufwendungen"]
[" Fremdrechnung ohne MWSt.",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L33","v":0}]
[" Transportkosten, Verpackung",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L34","v":0}]
[]
["4. Zusammenfassung"]
[" Summe ohne Pos 3.3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M30)","v":50}]
[" Zusätzliche Aufwendungen (Pos 3.3)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M33:M34)","v":0}]
[" Total gebührenpflichtige Leistungen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M37+M38","v":50}]
[]
["B. Weitere Leistungen (nicht gemäss Gebührenverordnung für Geodaten)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fr."]
[" Arbeit",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I44*L44","v":0}]
[" Arbeit",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I45*L45","v":0}]
[" Arbeit",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I46*L46","v":0}]
[" Arbeit",null,null,null,null,null,"Anz. Std.",null,null,null,"Ansatz",null,{"$f":"I47*L47","v":0}]
[" Fremdrechnung ohne MWSt.",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L48","v":0}]
[" Fremdrechnung ohne MWSt.",null,null,null,null,null,null,null,null,null,"Betrag",null,{"$f":"L49","v":0}]
[" Total weitere Leistungen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M44:M49)","v":0}]
[]
["C. Zusammenstellung aller Leistungen"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fr."]
[" Total gebührenpflichtige Leistungen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M39","v":50}]
[" Total weitere Leistungen",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M50","v":0}]
[" Zwischentotal",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M55+M56","v":50}]
[" Mehrwertsteuer",null,null,null,null,null,null,null,null,null,null,8.1000000000000003E-2,{"$f":"MROUND(M57*L58,0.05)","v":4.05}]
[" Rechnungstotal",null,null,null,null,null,null,null,null,null,null,null,{"$f":"M57+M58","v":54.05}]

{"sheet":"Statistik AV","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Kanton Zürich"]
["Statistische Angaben über die Planabgaben in der amtlichen Vermessung"]
[]
["Die folgenden Werte können für die Statistik verwendet werden:"]
[]
[null,"Anzahl","Zwischentotal\nexkl. MWSt.","Total\ninkl. MWSt."]
["Grafische Produkte",{"$f":"IF(SUM(Abrechnungsformular!H13:H16)>0,SUM(Abrechnungsformular!H13:H16),SUM(Abrechnungsformular_plus!H13:H16))","v":0},{"$f":"Abrechnungsformular!M8+IF(SUM(Abrechnungsformular!H13:H16)>0,SUM(Abrechnungsformular!M13:M16)+SUM(Abrechnungsformular!M33:M34),SUM(Abrechnungsformular_plus!M13:M16)+SUM(Abrechnungsformular_plus!M33:M34))","v":50},{"$f":"MROUND(C7*Abrechnungsformular!L40,0.05)+C7","v":54.05}]
["Richtigkeitsbestätigungen",{"$f":"IF(SUM(Abrechnungsformular!I20:I21)>0,SUM(Abrechnungsformular!I20:I21),SUM(Abrechnungsformular_plus!I20:I21))","v":0},{"$f":"Abrechnungsformular!M8+IF(SUM(Abrechnungsformular!I20:I24)>0,SUM(Abrechnungsformular!M20:M24),SUM(Abrechnungsformular_plus!M20:M24))-IF(B7>0,Abrechnungsformular!M8,0)","v":50},{"$f":"MROUND(C8*Abrechnungsformular!L40,0.05)+C8","v":54.05}]

{"sheet":"Liste","index":3,"n_rows":164,"n_cols":3,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
["Kanton Zürich"]
["Gemeindeliste"]
["BFS-Nr.","Gemeinde /","Stadt"]
["BFS","Typ","Name"]
[131,"Stadt","Adliswil"]
[241,"Gemeinde","Aesch (ZH)"]
[1,"Gemeinde","Aeugst am Albis"]
[2,"Gemeinde","Affoltern am Albis"]
[211,"Gemeinde","Altikon"]
[291,"Gemeinde","Andelfingen"]
[51,"Gemeinde","Bachenbülach"]
[81,"Gemeinde","Bachs"]
[111,"Gemeinde","Bäretswil"]
[52,"Gemeinde","Bassersdorf"]
[297,"Gemeinde","Bauma"]
[22,"Gemeinde","Benken (ZH)"]
[23,"Gemeinde","Berg am Irchel"]
[242,"Gemeinde","Birmensdorf (ZH)"]
[3,"Gemeinde","Bonstetten"]
[82,"Gemeinde","Boppelsen"]
[213,"Gemeinde","Brütten"]
[112,"Gemeinde","Bubikon"]
[24,"Gemeinde","Buch am Irchel"]
[83,"Gemeinde","Buchs (ZH)"]
[53,"Stadt","Bülach"]
[25,"Gemeinde","Dachsen"]
[214,"Gemeinde","Dägerlen"]
[84,"Gemeinde","Dällikon"]
[85,"Gemeinde","Dänikon"]
[215,"Gemeinde","Dättlikon"]
[86,"Gemeinde","Dielsdorf"]
[243,"Stadt","Dietikon"]
[54,"Gemeinde","Dietlikon"]
[216,"Gemeinde","Dinhard"]
[26,"Gemeinde","Dorf"]
[191,"Stadt","Dübendorf"]
[113,"Gemeinde","Dürnten"]
[192,"Gemeinde","Egg"]
[55,"Gemeinde","Eglisau"]
[294,"Gemeinde","Elgg"]
[218,"Gemeinde","Ellikon an der Thur"]
[219,"Gemeinde","Elsau"]
[56,"Gemeinde","Embrach"]
[151,"Gemeinde","Erlenbach (ZH)"]
[193,"Gemeinde","Fällanden"]
[172,"Gemeinde","Fehraltorf"]
[27,"Gemeinde","Feuerthalen"]
[114,"Gemeinde","Fischenthal"]
[28,"Gemeinde","Flaach"]
[29,"Gemeinde","Flurlingen"]
[57,"Gemeinde","Freienstein-Teufen"]
[244,"Gemeinde","Geroldswil"]
[58,"Gemeinde","Glattfelden"]
[115,"Gemeinde","Gossau (ZH)"]
[194,"Gemeinde","Greifensee"]
[116,"Gemeinde","Grüningen"]
[220,"Gemeinde","Hagenbuch"]
[4,"Gemeinde","Hausen am Albis"]
[5,"Gemeinde","Hedingen"]
[31,"Gemeinde","Henggart"]
[152,"Gemeinde","Herrliberg"]
[221,"Gemeinde","Hettlingen"]
[117,"Gemeinde","Hinwil"]
[173,"Gemeinde","Hittnau"]
[59,"Gemeinde","Hochfelden"]
[153,"Gemeinde","Hombrechtikon"]
[295,"Gemeinde","Horgen"]
[60,"Gemeinde","Höri"]
[61,"Gemeinde","Hüntwangen"]
[87,"Gemeinde","Hüttikon"]
[296,"Stadt","Illnau-Effretikon"]
[6,"Gemeinde","Kappel am Albis"]
[135,"Gemeinde","Kilchberg (ZH)"]
[33,"Gemeinde","Kleinandelfingen"]
[62,"Stadt","Kloten"]
[7,"Gemeinde","Knonau"]
[154,"Gemeinde","Küsnacht (ZH)"]
[136,"Gemeinde","Langnau am Albis"]
[34,"Gemeinde","Laufen-Uhwiesen"]
[176,"Gemeinde","Lindau"]
[63,"Gemeinde","Lufingen"]
[155,"Gemeinde","Männedorf"]
[35,"Gemeinde","Marthalen"]
[8,"Gemeinde","Maschwanden"]
[195,"Gemeinde","Maur"]
[156,"Gemeinde","Meilen"]
[9,"Gemeinde","Mettmenstetten"]
[196,"Gemeinde","Mönchaltorf"]
[88,"Gemeinde","Neerach"]
[223,"Gemeinde","Neftenbach"]
[89,"Gemeinde","Niederglatt"]
[90,"Gemeinde","Niederhasli"]
[91,"Gemeinde","Niederweningen"]
[64,"Gemeinde","Nürensdorf"]
[65,"Gemeinde","Oberembrach"]
[245,"Gemeinde","Oberengstringen"]
[92,"Gemeinde","Oberglatt"]
[137,"Gemeinde","Oberrieden"]
[93,"Gemeinde","Oberweningen"]
[10,"Gemeinde","Obfelden"]
[157,"Gemeinde","Oetwil am See"]
[246,"Gemeinde","Oetwil an der Limmat"]
[66,"Stadt","Opfikon"]
[37,"Gemeinde","Ossingen"]
[94,"Gemeinde","Otelfingen"]
[11,"Gemeinde","Ottenbach"]
[177,"Gemeinde","Pfäffikon"]
[224,"Gemeinde","Pfungen"]
[67,"Gemeinde","Rafz"]
[95,"Gemeinde","Regensberg"]
[96,"Gemeinde","Regensdorf"]
[38,"Gemeinde","Rheinau"]
[138,"Gemeinde","Richterswil"]
[225,"Gemeinde","Rickenbach (ZH)"]
[12,"Gemeinde","Rifferswil"]
[68,"Gemeinde","Rorbas"]
[97,"Gemeinde","Rümlang"]
[139,"Gemeinde","Rüschlikon"]
[178,"Gemeinde","Russikon"]
[118,"Gemeinde","Rüti (ZH)"]
[226,"Gemeinde","Schlatt (ZH)"]
[98,"Gemeinde","Schleinikon"]
[247,"Stadt","Schlieren"]
[99,"Gemeinde","Schöfflisdorf"]
[197,"Gemeinde","Schwerzenbach"]
[119,"Gemeinde","Seegräben"]
[227,"Gemeinde","Seuzach"]
[100,"Gemeinde","Stadel"]
[158,"Gemeinde","Stäfa"]
[13,"Gemeinde","Stallikon"]
[292,"Gemeinde","Stammheim"]
[101,"Gemeinde","Steinmaur"]
[39,"Gemeinde","Thalheim an der Thur"]
[141,"Gemeinde","Thalwil"]
[40,"Gemeinde","Trüllikon"]
[41,"Gemeinde","Truttikon"]
[228,"Gemeinde","Turbenthal"]
[159,"Gemeinde","Uetikon am See"]
[248,"Gemeinde","Uitikon"]
[249,"Gemeinde","Unterengstringen"]
[250,"Gemeinde","Urdorf"]
[198,"Stadt","Uster"]
[43,"Gemeinde","Volken"]
[199,"Gemeinde","Volketswil"]
[293,"Stadt","Wädenswil"]
[120,"Gemeinde","Wald (ZH)"]
[69,"Gemeinde","Wallisellen"]
[200,"Gemeinde","Wangen-Brüttisellen"]
[70,"Gemeinde","Wasterkingen"]
[102,"Gemeinde","Weiach"]
[251,"Gemeinde","Weiningen (ZH)"]
[180,"Gemeinde","Weisslingen"]
[14,"Gemeinde","Wettswil am Albis"]
[121,"Gemeinde","Wetzikon (ZH)"]
[298,"Gemeinde","Wiesendangen"]
[71,"Gemeinde","Wil (ZH)"]
[181,"Gemeinde","Wila"]
[182,"Gemeinde","Wildberg"]
[72,"Gemeinde","Winkel"]
[230,"Stadt","Winterthur"]
[231,"Gemeinde","Zell (ZH)"]
[161,"Gemeinde","Zollikon"]
[160,"Gemeinde","Zumikon"]
[261,"Stadt","Zürich"]