{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["PP-Nachweis","Steuerelemente"],"read":"whole","date_system":"1900"}

{"sheet":"PP-Nachweis","index":0,"n_rows":122,"n_cols":24,"rows_kept":122,"merged":[[0,20,5,20],[1,21,1,24],[4,4,4,11],[4,21,4,24],[7,0,7,5],[9,0,12,5],[9,11,12,11],[9,19,12,21],[9,22,12,24],[10,12,11,16],[10,17,11,17],[13,11,17,11],[13,13,13,14],[13,16,13,17],[13,20,13,21],[15,20,15,21],[19,20,19,21],[21,20,21,21],[24,20,24,21],[27,20,27,21],[30,20,30,21],[33,20,33,21],[36,20,36,21],[43,14,43,15],[46,14,46,15],[53,20,54,21],[56,20,56,23],[63,0,63,5],[65,0,67,5],[65,11,67,11],[65,12,67,17],[65,19,67,21],[65,22,67,24],[68,11,72,11],[68,13,68,14],[68,16,68,17],[68,20,68,21],[70,20,70,21],[74,20,74,21],[76,20,76,21],[79,20,79,21],[82,20,82,21],[85,20,85,21],[88,20,88,21],[91,20,91,21],[98,14,98,15],[101,14,101,15],[104,14,104,15],[111,20,112,21],[114,20,114,23],[117,20,119,21],[121,13,121,16]]}
[{"$nulls":20},"ausgefüllt durch Bauinspektorat"]
["Parkplatznachweis (Agglomerationen)",{"$nulls":17},"Baukontr.-Nr.:"]
[]
[]
["Strasse, Nr.:",{"$nulls":17},"Baugesuch eingereicht:"]
[]
[]
["a) bestehendes Gebäude",{"$nulls":5},"Diese Tabelle ist bei Nutzungsänderungen, Um- und Anbauten auszufüllen."]
[]
["Nutzungen",{"$nulls":10},"Ansätze",{"$nulls":7},"Ansätze",null,null,"Zweiräder"]
[{"$nulls":12},"Motorfahrzeuge"]
[]
[]
["Wohnnutzungen (Art. 51 BauV)",{"$nulls":6},"Anz. Wohn.",{"$nulls":3},"Nach\nArt. 51 BauV",null,"Minimum",null,null,"Maximum",{"$nulls":3},"Pro Wohn."]
[]
["Total Wohnungen",{"$nulls":6},0,{"$nulls":5},{"$f":"IF(H16=0,0,IF(H16<3,1,IF(H16=3,2,H16*0.5)))","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(H16=0,0,IF(H16=1,4,IF(H16=2,5,IF(H16=3,7,H16*2))))","v":{"v":0,"d":"0.00"}},{"$nulls":3},2,null,null,{"$f":"H16*U16","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":7}," "]
[]
["Übrige Nutzungen (Art. 52 BauV)",{"$nulls":6},"GF in m2",{"$nulls":3},"n = (Art.\n52 BauV)",null,"GF/n",{"$nulls":6},"je 100m2 GF"]
[]
["Restaurant",{"$nulls":6},0,{"$nulls":3},15,null,{"$f":"H22/L22","v":{"v":0,"d":"0.00"}},{"$nulls":6},3,null,null,{"$f":"H22/100*U22","v":{"v":0,"d":"0.00"}}]
[]
[]
["Einkaufen, Freizeit, Kultur",{"$nulls":6},0,{"$nulls":3},20,null,{"$f":"H25/L25","v":{"v":0,"d":"0.00"}},{"$nulls":6},3,null,null,{"$f":"H25/100*U25","v":{"v":0,"d":"0.00"}}]
[]
[]
["Hotel",{"$nulls":6},0,{"$nulls":3},30,null,{"$f":"H28/L28","v":{"v":0,"d":"0.00"}},{"$nulls":6},2,null,null,{"$f":"H28/100*U28","v":{"v":0,"d":"0.00"}}]
[]
[]
["Arbeiten Gewerbe, Dienstleistungen",{"$nulls":10},50,null,{"$f":"H31/L31","v":{"v":0,"d":"0.00"}},{"$nulls":6},2,null,null,{"$f":"H31/100*U31","v":{"v":0,"d":"0.00"}}]
[]
[]
["Spital, Heim",{"$nulls":10},100,null,{"$f":"H34/L34","v":{"v":0,"d":"0.00"}},{"$nulls":6},1,null,null,{"$f":"H34/100*U34","v":{"v":0,"d":"0.00"}}]
[]
[]
["Schule",{"$nulls":6},0,{"$nulls":3},120,null,{"$f":"H37/L37","v":{"v":0,"d":"0.00"}},{"$nulls":6},10,null,null,{"$f":"H37/100*U37","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":11},"Total GF/n",null,{"$f":"SUM(N22:N37)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Berechnung der übrigen Nutzungen gemäss Art. 52 + 53 BauV",{"$nulls":12},{"$f":"IF(N40<=200.0001,Steuerelemente!C9,IF(N40<=300,Steuerelemente!C17,Steuerelemente!C20))","v":{"v":0,"d":"0.00"}},"-",null,{"$f":"IF(N40<=200.0001,Steuerelemente!C13,Steuerelemente!C20)","v":{"v":0,"d":"0.00"}}]
[]
[]
["Total Abstellplätze für Motorfahrzeuge / Fahrräder gerundet: ",{"$nulls":12},{"$f":"N44+N16","v":0},"-",null,{"$f":"Q44+Q16","v":0},{"$nulls":6},{"$f":"SUM(X15:X37)","v":0}]
[]
[]
[]
["b) Nachweis der bestehenden Abstellplätze"]
[]
[]
["a) Motorfahrzeuge",{"$nulls":4},"offen",{"$nulls":3},"b) Zweiräder",{"$nulls":4},"offen"]
[]
[]
[{"$nulls":5},"in Garagen, Einstellhallen (Unterstände)",{"$nulls":8},"überdacht",null,0]
[]
[]
[{"$nulls":5},"Total bestehende",null,{"$f":"SUM(H54:H57)","v":0},{"$nulls":6},"Total bestehende",null,{"$f":"SUM(Q54:Q57)","v":0}]
[]
[]
[]
["c) projektiertes Gebäude",{"$nulls":5},"Diese Tabelle ist bei Nutzungsänderungen, Um- und Anbauten sowie Neubauten auszufüllen."]
[]
["Nutzungen",{"$nulls":10},"Ansätze","Motorfahrzeuge",{"$nulls":6},"Ansätze",null,null,"Zweiräder"]
[]
[]
["Wohnnutzungen (Art. 51 BauV)",{"$nulls":6},"Anz. Wohn.",{"$nulls":3},"Nach\nArt. 51 BauV",null,"Minimum",null,null,"Maximum",{"$nulls":3},"Pro Wohn."]
[]
["Total Wohnungen",{"$nulls":6},0,{"$nulls":5},{"$f":"IF(H71=0,0,IF(H71<3,1,IF(H71=3,2,H71*0.5)))","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(H71=0,0,IF(H71=1,4,IF(H71=2,5,IF(H71=3,7,H71*2))))","v":{"v":0,"d":"0.00"}},{"$nulls":3},2,null,null,{"$f":"H71*U71","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Übrige Nutzungen (Art. 52 BauV)",{"$nulls":6},"GF in m2",{"$nulls":3},"n = (Art.\n52 BauV)",null,"GF/n",{"$nulls":6},"je 100m2 GF"]
[]
["Restaurant",{"$nulls":6},0,{"$nulls":3},15,null,{"$f":"H77/L77","v":{"v":0,"d":"0.00"}},{"$nulls":6},3,null,null,{"$f":"H77/100*U77","v":{"v":0,"d":"0.00"}}]
[]
[]
["Einkaufen, Freizeit, Kultur",{"$nulls":10},20,null,{"$f":"H80/L80","v":{"v":0,"d":"0.00"}},{"$nulls":6},3,null,null,{"$f":"H80/100*U80","v":{"v":0,"d":"0.00"}}]
[]
[]
["Hotel",{"$nulls":10},30,null,{"$f":"H83/L83","v":{"v":0,"d":"0.00"}},{"$nulls":6},2,null,null,{"$f":"H83/100*U83","v":{"v":0,"d":"0.00"}}]
[]
[]
["Arbeiten Gewerbe, Dienstleistungen",{"$nulls":6},0,{"$nulls":3},50,null,{"$f":"H86/L86","v":{"v":0,"d":"0.00"}},{"$nulls":6},2,null,null,{"$f":"H86/100*U86","v":{"v":0,"d":"0.00"}}]
[]
[]
["Spital, Heim",{"$nulls":10},100,null,{"$f":"H89/L89","v":{"v":0,"d":"0.00"}},{"$nulls":6},1,null,null,{"$f":"H89/100*U89","v":{"v":0,"d":"0.00"}}]
[]
[]
["Schule",{"$nulls":6},0,{"$nulls":3},120,null,{"$f":"H92/L92","v":{"v":0,"d":"0.00"}},{"$nulls":6},10,null,null,{"$f":"H92/100*U92","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":11},"Total GF/n",null,{"$f":"SUM(N77:N92)","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Berechnung der übrigen Nutzungen gemäss Art. 52 + 53 BauV",{"$nulls":12},{"$f":"IF(N95<=200.0001,Steuerelemente!E9,IF(N95<=300,Steuerelemente!E17,Steuerelemente!E20))","v":{"v":0,"d":"0.00"}},"-",null,{"$f":"IF(N95<=200.0001,Steuerelemente!E13,Steuerelemente!E20)","v":{"v":0,"d":"0.00"}}]
[]
[]
["zusätzliche Abstellplätze nach Art. 50.3, 4 oder 53.4 BauV",{"$nulls":12},0,"-"]
[]
[]
["Total Abstellplätze für Motorfahrzeuge / Fahrräder gerundet: ",{"$nulls":12},{"$f":"N102+N99+N71","v":0},"-",null,{"$f":"Q102+Q99+Q71","v":0},{"$nulls":6},{"$f":"SUM(X71:X92)","v":0}]
[]
[]
[]
["d) Nachweis aller Abstellplätze nach Ausführung des Projekts",{"$nulls":19},"der Projektverfasser:"]
[]
[]
["a) Motorfahrzeuge",{"$nulls":4},"offen",null,0,null,"b) Zweiräder",{"$nulls":4},"offen",{"$nulls":5},"Ort, Datum:"]
[]
[]
[{"$nulls":5},"in Garagen, Einstellhallen (Unterstände)",null,0,{"$nulls":6},"überdacht",null,0]
[]
[]
[{"$nulls":5},"Total",null,{"$f":"SUM(H112:H115)","v":0},{"$nulls":6},"Total",null,{"$f":"SUM(Q112:Q115)","v":0},{"$nulls":3},"Unterschrift:"]
[]
[]
[]
[{"$nulls":3},"  Durch Projektverfasser auszufüllen.",{"$nulls":9},"Berechnungszelle"]

{"sheet":"Steuerelemente","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"hidden":true,"merged":[[0,2,5,2],[0,4,5,4]]}
[null,null,"a) bestehendes Geäude",null,"b) Projektiertes Gebäude"]
[]
[]
[]
[]
["a) Bandbreite nach Art. 52 BauV"]
["a) Bandbreite"]
["Minimal = (0.45 x BGF/n) -3","=",{"$f":"('PP-Nachweis'!N40*0.45)-3","v":{"v":-3,"d":"-3.00"}},null,{"$f":"('PP-Nachweis'!N95*0.45)-3","v":{"v":-3,"d":"-3.00"}}]
["Mindestens nach Art. 52.3 BauV","=",{"$f":"IF('PP-Nachweis'!H22+'PP-Nachweis'!H25+'PP-Nachweis'!H28+'PP-Nachweis'!H31+'PP-Nachweis'!H34+'PP-Nachweis'!H37=0,0,IF(C8<=1,1,C8))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF('PP-Nachweis'!H77+'PP-Nachweis'!H80+'PP-Nachweis'!H83+'PP-Nachweis'!H86+'PP-Nachweis'!H89+'PP-Nachweis'!H92=0,0,IF(E8<=1,1,E8))","v":{"v":0,"d":"0.00"}}]
[]
[]
["Maximal= (0,6 x BGF/n) + 5","=",{"$f":"('PP-Nachweis'!N40*0.6)+5","v":{"v":5,"d":"5.00"}},null,{"$f":"('PP-Nachweis'!N95*0.6)+5","v":{"v":5,"d":"5.00"}}]
["Nullwert = 5 löschen",null,{"$f":"IF(C12<=5,,C12)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(E12<=5,,E12)","v":{"v":0,"d":"0.00"}}]
[]
[]
["b) Grundbedarf nach Art. 53"]
["(0.25 x BGF/n) + 50","=",{"$f":"('PP-Nachweis'!N40*0.25)+50","v":{"v":50,"d":"50.00"}},null,{"$f":"('PP-Nachweis'!N95*0.25)+50","v":{"v":50,"d":"50.00"}}]
["Koordination nach Art. 53.3 a","=",{"v":125,"d":"125.00"},null,{"v":125,"d":"125.00"}]
[]
["Erforderliche Anzahl PP",null,{"$f":"IF(C17<=125,125,C17)","v":{"v":125,"d":"125.00"}},null,{"$f":"IF(E17<=125,125,E17)","v":{"v":125,"d":"125.00"}}]