{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Parkplatzberechnung","Tabelle1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"Parkplatzberechnung","index":0,"n_rows":213,"n_cols":15,"rows_kept":213,"cut":false,"hidden":false,"merged":[[210,0,210,1],[211,0,211,1],[210,4,210,5],[211,4,211,5],[118,0,118,1],[118,4,118,5],[119,0,119,1],[119,4,119,5],[189,0,189,3],[189,4,189,6],[162,4,162,5],[143,4,143,6],[167,3,167,12],[206,0,206,1],[206,4,206,5],[200,0,201,0],[200,2,201,2],[200,4,200,5],[201,4,201,5],[202,0,203,0],[202,4,202,5],[203,4,203,5],[204,0,205,0],[204,4,204,5],[189,10,189,12],[165,10,165,12],[164,3,164,12],[112,0,113,0],[123,10,123,12],[142,10,142,12],[162,10,162,11],[162,7,162,8],[117,0,117,1],[182,6,182,8],[114,0,114,1],[115,0,115,1],[116,0,116,1],[124,0,125,0],[162,0,162,3],[165,4,165,6],[165,7,165,9],[126,0,127,0],[146,0,147,0],[144,0,145,0],[160,0,160,3],[171,0,171,1],[176,0,176,1],[144,9,145,9],[79,0,82,1],[84,0,87,1],[108,4,108,5],[96,11,96,12],[92,0,93,0],[92,9,92,10],[95,7,95,8],[95,9,95,10],[95,11,95,12],[96,7,96,8],[102,4,102,5],[103,0,104,0],[103,4,103,5],[104,4,104,5],[105,0,105,1],[105,4,105,5],[106,0,107,0],[84,3,85,12],[79,3,79,12],[96,9,96,10],[92,2,93,8],[83,0,83,1],[92,11,92,12],[99,3,99,5],[56,4,56,6],[56,7,56,9],[56,10,56,12],[57,4,57,6],[57,7,57,9],[57,10,57,12],[60,0,61,0],[93,9,93,10],[93,11,93,12],[89,2,90,5],[78,0,78,1],[89,0,90,1],[77,10,77,12],[76,0,77,2],[56,0,57,3],[58,9,59,9],[74,0,74,3],[58,0,59,0],[77,4,77,6],[77,7,77,9],[76,3,76,12],[90,6,90,8],[89,6,89,8],[91,10,91,12],[0,0,0,5],[0,6,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[6,2,6,5],[6,0,6,1],[4,2,4,12],[4,0,4,1],[6,11,6,12],[8,0,8,1],[8,2,8,12],[9,0,9,1],[9,2,9,12],[17,0,17,12],[18,0,54,12],[10,0,10,1],[10,2,10,12],[11,0,11,1],[11,2,11,12],[12,0,12,1],[14,0,14,12],[15,2,15,12],[16,2,16,12],[16,0,16,1],[15,0,15,1],[13,0,13,1],[12,2,12,4],[13,2,13,4],[172,3,173,12],[166,0,166,1],[91,0,91,3],[109,4,109,5],[99,7,99,12],[100,4,100,5],[140,0,140,3],[95,0,96,1],[124,9,125,9],[117,4,117,5],[120,0,120,5],[100,7,120,12],[101,0,102,0],[101,4,101,5],[111,4,111,5],[110,4,110,5],[95,2,96,6],[112,4,112,5],[113,4,113,5],[114,4,114,5],[115,4,115,5],[116,4,116,5],[107,4,107,5],[122,10,122,12],[143,7,143,9],[106,4,106,5],[110,0,111,0],[122,0,123,3],[108,0,109,0],[108,2,109,2],[123,4,123,6],[123,7,123,9],[142,4,142,6],[122,4,122,6],[122,7,122,9],[55,0,55,12],[121,0,121,12],[98,0,98,1],[98,2,98,12],[191,3,191,5],[191,7,191,12],[190,0,190,5],[190,6,190,12],[90,11,90,12],[89,11,89,12],[90,9,90,10],[89,9,89,10],[143,10,143,12],[142,0,143,3],[75,0,75,3],[75,4,75,6],[75,7,75,9],[75,10,75,12],[97,0,97,12],[91,7,91,9],[91,4,91,6],[142,7,142,9],[182,0,183,1],[182,2,183,5],[184,0,185,0],[184,2,185,8],[192,7,212,12],[193,0,194,0],[193,4,193,5],[194,4,194,5],[195,0,196,0],[195,4,195,5],[196,4,196,5],[197,0,197,1],[197,4,197,5],[198,0,199,0],[198,4,198,5],[199,4,199,5],[205,4,205,5],[207,0,207,1],[207,4,207,5],[208,0,208,1],[208,4,208,5],[209,0,209,1],[209,4,209,5],[212,0,212,5],[192,4,192,5],[189,7,189,9],[7,0,7,1],[7,2,7,5],[177,3,178,12],[167,0,170,1],[177,0,180,1],[164,0,165,2],[187,0,188,1],[187,2,188,6],[187,7,187,8],[187,9,187,10],[187,11,187,12],[188,7,188,8],[188,9,188,10],[188,11,188,12],[182,9,182,10],[182,11,182,12],[183,6,183,8],[183,9,183,10],[183,11,183,12],[184,9,184,10],[184,11,184,12],[185,9,185,10],[185,11,185,12],[172,0,175,1]]}
["Stadt\nLuzern\nBaubewilligungen",null,null,null,null,null,"Version 1.1 vom 19. September 2024"]
[]
["  Berechnung Autoparkplätze / Motorrad- und Veloabstellplätze"]
[]
[]
[]
["    Geschäfts-Nr.: (sofern bekannt)",null,null,null,null,null,null,null,null,null,null,"Eingabe als PDF"]
["    Datum:"]
[" 1.  Lage/Bauort"]
["      Strasse"]
["      Grundstück"]
["      ausgefüllt von"]
["      Parkplatzzone I-IV",null,"Bitte auswählen"]
["      Neubau / Umbau",null,"Bitte auswählen"]
[]
["Parkplatzreglement",null,"Reglement über private Fahrzeugabstellplätze (Parkplatzreglement) vom 12. November 2020\n\n"]
["Plan Zoneneinteilung",null,"Reduktionszonen"]
[]
["Berechnungsgrundlagen \nDie Berechnung der Autoparkplätze (Art. 9 ff. Parkplatzreglement [PPR]) erfolgt über die Ermittlung des Normbedarfs anhand der Nutzungsart der Baute oder Anlage. Das Stadtgebiet ist in vier Reduktionszonen aufgeteilt (siehe Link oben: Reduktionszonen). Die erforderliche Anzahl Autoparkplätze ergibt sich anhand der zonenbedingten Reduktion des Normbedarfs. Die massgebende Geschossfläche wird gestützt auf Ziff. 2 der SIA-Norm 416 berechnet. Als massgebende Geschossfläche zur Bestimmung des Normbedarfs (für Autoparkplätze und Veloabstellplätze) gilt:\n\na. Die Nebennutz- und Funktionsflächen (einschliesslich der entsprechenden Konstruktionsflächen) sowie Geschossflächen in \n    Geschossen ohne Hauptnutzfläche sind nicht zu berücksichtigen;\nb. alle weiteren Geschossflächen sind zu berücksichtigen;\nc. Die Verkehrsflächen (einschliesslich der entsprechenden Konstruktionsflächen) in Geschossen mit mehreren Nutzungen sind\n    prozentual auf die entsprechenden Geschossflächen aufzuteilen;\nd. Wenn unterschiedliche Nutzungen auf einem Geschoss vorhanden sind, sind die dazugehörigen Konstruktionsflächen in der\n    Wandmitte aufzuteilen.\n\nHinweise für die Berechnung\nÜber die gesamte Berechnung wird die Zahl der sich ergebenden Abstellplätze nicht gerundet. Es ist mit den sich ergebenden effektiven Zahlen zu rechnen. Die Rundung auf ganze Abstellplätze erfolgt erst am Schluss der Berechnung. Bruchteile von weniger als 0,5 Abstellplätzen werden abgerundet, jene von 0,5 und mehr Abstellplätzen werden aufgerundet.\n\nDer Normbedarf für die im Parkplatzreglement nicht explizit erwähnten Nutzungen wird gemäss Art. 4 Abs. 5 PPR grundsätzlich nach den Richtwerten der VSS-Normen 40 281 und 40 065 festgelegt.\n\nBei neubauähnlichen Umbauten, Zweckänderungen und Erweiterungen können die bestehenden Abstellplätze im Rahmen der Bestandesgarantie beibehalten werden. In diesem Fall sind die bestehenden Parkplätze in einem Plan vermasst auszuweisen und die damalige Baubewilligung beizulegen oder das Erstellungsdatum zu belegen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C60=\"\",\"\",B3+C3)","v":""}]
[]
[]
[]
[]
["Berechnungsgrundlagen Neubauten und Neuanlagen"]
["a)  Autoparkplätze\n     Normbedarf der neuen Nutzung",null,null,null,"Bewohnende",null,null,"Besuchende/Kundschaft",null,null,"Beschäftigte"]
[null,null,null,null,"1 PP pro",null,null,"1 PP pro",null,null,"1 PP pro"]
["Wohnungen (Whg.) 100  m2\n* grössere Anzahl eintragen","GF",null,"      m2",100,"m2",{"$f":"IF((C60<=(C59/100)),C59/E59,\"\")","v":0},1000," m2",{"$f":"SUM(C59/H59)","v":0},null,"------","------"]
[null,"Whg. ",null,"     W.",1,"Whg.",{"$f":"IF(C59=\"\",\"\",(IF(G59=\"\",C60/E60,\"\")))","v":""},"-----","-----",null,null,"------","------"]
["Alterswohnungen, Studio, Studierendenwohnungen","GF",null,"      m2",null,"------","-----",1000,"m2",{"$f":"SUM(C61/H61)","v":0},null,"------","------"]
[null,"Whg.",null,"      W",4,"Whg.",{"$f":"SUM(C62/E62)","v":0},null,"------","-----",null,"------","------"]
["Büro, Labor, Praxis,Therapie","GF",null,"      m2",null,"-----","-----",300,"m2",{"$f":"SUM(C63/H63)","v":0},75," m2",{"$f":"SUM(C63/K63)","v":0}]
["Lagerräume, Archive, Kühler","GF",null,"      m2",null,"-----","-----",null,"-----","-----",300," m2",{"$f":"SUM(C64/K64)","v":0}]
["Läden, Drogerie, Apotheke","GF",null,"      m2",null,"-----","-----",75,"m2",{"$f":"SUM(C65/H65)","v":0},200,"m2",0]
["Fabrikation, Werkstätten","GF",null,"      m2",null,"-----","-----",500,"m2",{"$f":"SUM(C66/H66)","v":0},150,"m2",0]
["Restaurant, Café, Küche","Sitzpl.",null,"      S.",null,"-----","-----",8,"Sitzpl.",{"$f":"SUM(C67/H67)","v":0},30,"Sitzpl.",0]
["Hotel, Pension, Jugendherb.","Betten",null,"      B.",null,"-----","-----",6,"Betten",{"$f":"SUM(C68/H68)","v":0},15,"B.",0]
["Kulturräume, Saalbauten","Sitzpl. ",null,"      S.",null,"-----","-----",10,"Sitzpl.",{"$f":"SUM(C69/H69)","v":0},"-----","-----","-----"]
["Schule Unterstufen VSS-Norm","Kl. Zim",null,"Kl. Zim",null,"-----","-----",0.2,"Kl. Zim",{"$f":"SUM(C70*H70)","v":0},1,"Kl. Zim",{"$f":"SUM(C70*K70)","v":0}]
["Pflegeheim gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.3,"Bett",0,0.5,"Bett",{"$f":"SUM(C71*K71)","v":0}]
["Spital, Klinik gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.5,"Bett",0,1,"Bett",{"$f":"SUM(C72*K72)","v":0}]
["Bedarf nach VSS / Freier Text","Betten",null,null,null,"-----","-----",null,null,{"$f":"SUM(C73*H73)","v":0},null,null,{"$f":"SUM(C73*K73)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,null,null,"-----","-----",null,null,{"$f":"SUM(C74*H74)","v":0},null,null,{"$f":"SUM(C74*K74)","v":0}]
["a) Total Normbedarf  übertragen in Tabelle b) \n      zur Bestimmung der Anzahl PP",null,null,null,null,null,{"$f":"SUM(G59:G73)","v":0},null,null,{"$f":"SUM(J59:J74)","v":0},null,null,{"$f":"SUM(M59:M74)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(A3:A8,B3:B8,#REF!,C3:C8,#REF!)","v":0}]
["b) Erforderliche Parkplätze nach Zonen",null,null,"Maximum und Minimum in % des Normbedarfs"]
[null,null,null,"Total","Bewohnende",null,null,"Besuchende/Kundschaft",null,null,"Beschäftigte"]
["Maximal zulässige Anzahl PP, berechnet aus Normbedarf a) der neuen Nutzung",null,{"$f":"IF($C$13=Tabelle1!$A$4,0,$C$13)","v":0},{"$f":"IF($C$79=0,0,IF($C$79=C80,D80,VLOOKUP($C$79,$C$80:$M$83,2)))","v":0},{"$f":"IF($C$79=0,0,IF($C$79=C80,0,VLOOKUP($C$79,$C$80:$M$83,3)))","v":0},{"$f":"SUM(G75*E79)","v":0},{"$f":"MROUND(F79,1)","v":0},{"$f":"IF($C$79=0,0,IF($C$79=C80,0,VLOOKUP($C$79,$C$80:$M$83,6)))","v":0},{"$f":"SUM(J75*H79)","v":0},{"$f":"MROUND(I79,1)","v":0},{"$f":"IF($C$79=0,0,IF($C$79=C80,0,VLOOKUP($C$79,$C$80:$M$83,9)))","v":0},{"$f":"SUM(M75*K79)","v":0},{"$f":"MROUND(L79,1)","v":0}]
["Maximal zulässige Anzahl PP, berechnet aus Normbedarf a) der neuen Nutzung",null,"Zone I","Keine"]
[null,null,"Zone II",{"$f":"SUM(M81,J81,G81)","v":0},0.3,{"$f":"SUM(G75*E81)","v":0},{"$f":"MROUND(F81,1)","v":0},0.3,{"$f":"SUM(J75*H81)","v":0},{"$f":"MROUND(I81,1)","v":0},0.2,{"$f":"SUM(M75*K81)","v":0},{"$f":"MROUND(L81,1)","v":0}]
[null,null,"Zone III",{"$f":"SUM(M82,J82,G82)","v":0},0.7,{"$f":"SUM(G75*E82)","v":0},{"$f":"MROUND(F82,1)","v":0},0.6,{"$f":"SUM(J75*H82)","v":0},0,0.5,{"$f":"SUM(M75*K82)","v":0},0]
[null,null,"Zone IV",{"$f":"SUM(M83,J83,G83)","v":0},1,{"$f":"SUM(G75*E83)","v":0},{"$f":"MROUND(F83,1)","v":0},1,{"$f":"SUM(J75*H83)","v":0},{"$f":"MROUND(I83,1)","v":0},1,{"$f":"SUM(M75*K83)","v":0},{"$f":"MROUND(L83,1)","v":0}]
["Mindestens erforderliche\nAnzahl PP, berechnet aus Normbedarf a) der neuen Nutzung",null,{"$f":"IF($C$13=Tabelle1!$A$4,0,$C$13)","v":0},{"$f":"IF($C$84=0,0,IF($C$84=C85,D85,(IF(C84=C86,D85,(VLOOKUP($C$84,$C$85:$M$88,2))))))","v":0},{"$f":"IF($C$84=0,0,IF($C$84=C85,0,VLOOKUP($C$84,$C$85:$M$88,3)))","v":0},{"$f":"SUM(G75*E84)","v":0},{"$f":"MROUND(F84,1)","v":0},{"$f":"IF($C$84=0,0,IF($C$84=C85,0,VLOOKUP($C$84,$C$85:$M$88,6)))","v":0},{"$f":"SUM(J75*H84)","v":0},{"$f":"MROUND(I84,1)","v":0},{"$f":"IF($C$84=0,0,IF($C$84=C85,0,VLOOKUP($C$84,$C$85:$M$88,9)))","v":0},{"$f":"SUM(M75*K84)","v":0},{"$f":"MROUND(L84,1)","v":0}]
["Mindestens erforderliche\nAnzahl PP, berechnet aus Normbedarf a) der neuen Nutzung",null,"Zone I","Keine"]
[null,null,"Zone II"]
[null,null,"Zone III",{"$f":"SUM(M87,J87,G87)","v":0},0.3,{"$f":"SUM(G75*E87)","v":0},{"$f":"MROUND(F87,1)","v":0},0.2,{"$f":"SUM(J75*H87)","v":0},{"$f":"MROUND(I87,1)","v":0},0.1,{"$f":"SUM(M75*K87)","v":0},{"$f":"MROUND(L87,1)","v":0}]
[null,null,"Zone IV",{"$f":"SUM(M88,J88,G88)","v":0},0.8,{"$f":"SUM(G75*E88)","v":0},{"$f":"MROUND(F88,1)","v":0},0.5,{"$f":"SUM(J75*H88)","v":0},{"$f":"MROUND(I88,1)","v":0},0.5,{"$f":"SUM(M75*K88)","v":0},{"$f":"MROUND(L88,1)","v":0}]
[]
["Roller- und Motorradparkplätze  ",null,"Anteil der neu bewilligten Autoparkplätze",null,null,null,"Projektierte Autoparkplätze",null,null,"Anteil ",null,"Anzahl PP"]
[null,null,null,null,null,null,null,null,null,0.15,null,{"$f":"IF(G91=\"Bitte eingeben\",0,SUM(G91*J91))","v":0}]
[]
["Behindertenparkplätze",null,"Ab 40 Autoparkplätzen ist min. 1 PP für Kundschaft oder Besuchende als IV-Parkplatz zu realisieren. Im Übrigen gilt die SIA-Norm (SN 521 500).",null,null,null,null,null,null,"Anzahl Parkplätze",null,"Anzahl PP"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN((J94/40),0)","v":0}]
[]
["Carparkplätze ",null,"Hotel und Pension 1 Carparkplatz pro 50 Betten",null,null,null,null,"Anzahl Betten",null,"Reduktion Zone",null,"Anzahl PP"]
[null,null,null,null,null,null,null,{"$f":"C68","v":0},null,{"$f":"IF($C$13=Tabelle1!$A$4,0,IF($C$13=C168,0,VLOOKUP($C$13,C169:H171,6)))","v":0},null,{"$f":"SUM(H97/50)*J97","v":0}]
[]
["Veloabstellplätze",null,"(Art. 18 ff. Parkplatzreglement)"]
[null,null,"Menge","1 Veloabstellplätz pro",null,null,"Minimum","Hinweis / Bemerkungen"]
["Wohnungen",null,null,1,"Zimmer",null,{"$f":"SUM(C101/D101)","v":0},"Die halben Zimmer der Wohnungen werden mitgerechnet (z. B. 2.5-Zimmerwohnung = 2.5 Veloabstellplätze). Die Rundung auf ganze Abstellplätze erfolgt am Schluss, Bruchteile von weniger als 0,5 Abstellplätzen werden abgerundet, jene von 0,5 und mehr Abstellplätzen werden aufgerundet. \n\nBei Wohnungen sind die Veloabstellplätze für Besuchende im Wert für Bewohnende enthalten.\n\nAnteil Kurzzeit-Veloabstellplätze 30 %.\n\nKönnen Nutzung und Anzahl Arbeitsplätze noch nicht ermittelt werden, ist der Standardbedarf über die Geschossfläche GF gemäss VSS-Norm SN 40 065 festzulegen. \n\nBei Wohnungen wird der Normbedarf nicht reduziert. Bei den übrigen Objekten kann der Normbedarf bei ungünstiger Topografie, sehr ungünstiger Lage, zum Schutz des Ortsbildes oder bei Mehrfachnutzungen reduziert werden.\n\nWeitere Auskünfte erteilt das Tiefbauamt der Stadt Luzern."]
["Alterswohnung\nStudierendenwohnungen",null,null,4,"Wohnung",null,{"$f":"SUM(C102/D102)","v":0}]
[null,"Besuchende",null,1000," m2",null,{"$f":"SUM(C103/D103)","v":0}]
["Post, Bank, Büro, Labor, Praxis, Therapie, Coiffeur",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C104/D104)","v":0}]
[null,"Besuchende",null,50," m2",null,{"$f":"SUM(C105/D105)","v":0}]
["Lagerraum, Archiv",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C106/D106)","v":0}]
["Läden, Drogerie\nApotheke",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C107/D107)","v":0}]
[null,"Besuchende",null,50," m2",null,{"$f":"SUM(C108/D108)","v":0}]
["Fabrikation\nWerkstätten",null,null,150," m2",null,{"$f":"SUM(C109/D109)","v":0}]
[null,"Besuchende",null,500," m2",null,{"$f":"SUM(C109/D110)","v":0}]
["Restaurant, Café, Spital, Pflege-Altersheime",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C111/D111)","v":0}]
[null,"Besuchende",null,5,"Sitzplätze*",null,0]
["Hotel, Pension, Saalbaute Kulturraum, Unterhaltung ",null,null,5,"Arbeitsplätze",null,0]
[null,"Besuchende",null,10,"Sitzplätze",null,0]
["Lehrpersonen / Personal",null,null,5,"Personen",null,0]
["Höhere Schulen",null,null,2,"Studierende",null,0]
["Mittelschulen",null,null,2,"Schulkinder",null,0]
["Primarschulen, Kindergärten",null,null,5,"Schulkinder",null,0]
["Bedarf nach VSS / Freier Text",null,null,1,null,null,{"$f":"SUM(C119/D119)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,1,null,null,0]
["Total Veloabstellplätze",null,null,null,null,null,{"$f":"SUM(G101:G120)","v":0}]
["Berechnungsgrundlagen bei Um- und Anbauten"]
["a)   Autoparkplätze\n      Normbedarf der alten Nutzung",null,null,null,"Bewohnende",null,null,"Besuchende/Kundschaft",null,null,"Beschäftigte"]
[null,null,null,null,"1 PP pro",null,null,"1 PP pro",null,null,"1 PP pro"]
["Wohnungen (Whg.) 100  m2\n* grössere Anzahl eintragen","GF",null,"      m2",100,"m2",{"$f":"IF((C126<=(C125/100)),C125/E125,\"\")","v":0},1000," m2",{"$f":"SUM(C125/H125)","v":0},null,"------","------"]
[null,"Whg. ",null,"     W.",1,"Whg.",{"$f":"IF(C125=\"\",\"\",(IF(G125=\"\",C126/E126,\"\")))","v":""},"-----","-----",null,null,"------","------"]
["Alterswohnungen, Studio, Studierendenwohnungen","GF",null,"      m2",null,"------","-----",1000,"m2",{"$f":"SUM(C127/H127)","v":0},null,"------","------"]
[null,"Whg.",null,"      W",4,"Whg.",{"$f":"SUM(C128/E128)","v":0},null,"------","-----",null,"------","------"]
["Büro, Labor, Praxis,Therapie","GF",null,"      m2",null,"-----","-----",300,"m2",{"$f":"SUM(C129/H129)","v":0},75," m2",{"$f":"SUM(C129/K129)","v":0}]
["Lagerräume, Archive, Kühler","GF",null,"      m2",null,"-----","-----",null,"-----","-----",300," m2",{"$f":"SUM(C130/K130)","v":0}]
["Läden, Drogerie, Apotheke","GF",null,"      m2",null,"-----","-----",75,"m2",{"$f":"SUM(C131/H131)","v":0},200,"m2",0]
["Fabrikation, Werkstätten","GF",null,"      m2",null,"-----","-----",500,"m2",{"$f":"SUM(C132/H132)","v":0},150,"m2",0]
["Restaurant, Café, Küche","Sitzpl.",null,"      S.",null,"-----","-----",8,"Sitzpl.",{"$f":"SUM(C133/H133)","v":0},30,"Sitzpl.",0]
["Hotel, Pension, Jugendherb.","Betten",null,"      B.",null,"-----","-----",6,"Betten",{"$f":"SUM(C134/H134)","v":0},15,"B.",0]
["Kulturräume, Saalbauten","Sitzpl. ",null,"      S.",null,"-----","-----",10,"Sitzpl.",{"$f":"SUM(C135/H135)","v":0},"-----","-----","-----"]
["Schule Unterstufen VSS-Norm","Kl. Zim",null,"Kl. Zim",null,"-----","-----",0.2,"Kl. Zim",{"$f":"SUM(C136*H136)","v":0},1,"Kl. Zim",{"$f":"SUM(C136*K136)","v":0}]
["Pflegeheim gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.3,"Bett",0,0.5,"Bett",{"$f":"SUM(C137*K137)","v":0}]
["Spital, Klinik gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.5,"Bett",0,1,"Bett",{"$f":"SUM(C138*K138)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,null,null,"-----","-----",null,null,{"$f":"SUM(C139*H139)","v":0},null,null,{"$f":"SUM(C139*K139)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,null,null,"-----","-----",null,null,0,null,null,{"$f":"SUM(C140*K140)","v":0}]
["a) Total Normbedarf der alten Nutzung\nübertragen in Tabelle c) zur Bestimmung der Anzahl PP",null,null,null,null,null,{"$f":"SUM(G125:G140)","v":0},null,null,{"$f":"SUM(J125:J140)","v":0},null,null,{"$f":"SUM(M125:M140)","v":0}]
[]
["b) Autoparkplätze\n    Normbedarf der neuen Nutzung",null,null,null,"Bewohnende",null,null,"Besuchende/Kundschaft",null,null,"Beschäftigte"]
[null,null,null,null,"1 PP pro",null,null,"1 PP pro",null,null,"1 PP pro"]
["Wohnungen (Whg.) 100  m2\n* grössere Anzahl eintragen","GF",null,"      m2",100,"m2",{"$f":"IF((C146<=(C145/100)),C145/E145,\"\")","v":0},1000," m2",{"$f":"SUM(C145/H145)","v":0},null,"------","------"]
[null,"Whg. ",null,"     W.",1,"Whg.",{"$f":"IF(C145=\"\",\"\",(IF(G145=\"\",C146/E146,\"\")))","v":""},"-----","-----",null,null,"------","------"]
["Alterswohnungen, Studio, Studierendenwohnungen","GF",null,"      m2",null,"------","-----",1000,"m2",{"$f":"SUM(C147/H147)","v":0},null,"------","------"]
[null,"Whg.",null,"      W",4,"Whg.",{"$f":"SUM(C148/E148)","v":0},null,"------","-----",null,"------","------"]
["Büro, Labor, Praxis,Therapie","GF",null,"      m2",null,"-----","-----",300,"m2",{"$f":"SUM(C149/H149)","v":0},75," m2",{"$f":"SUM(C149/K149)","v":0}]
["Lagerräume, Archive, Kühler","GF",null,"      m2",null,"-----","-----",null,"-----","-----",300," m2",{"$f":"SUM(C150/K150)","v":0}]
["Läden, Drogerie, Apotheke","GF",null,"      m2",null,"-----","-----",75,"m2",{"$f":"SUM(C151/H151)","v":0},200,"m2",0]
["Fabrikation, Werkstätten","GF",null,"      m2",null,"-----","-----",500,"m2",{"$f":"SUM(C152/H152)","v":0},150,"m2",0]
["Restaurant, Café, Küche","Sitzpl.",null,"      S.",null,"-----","-----",8,"Sitzpl.",{"$f":"SUM(C153/H153)","v":0},30,"Sitzpl.",0]
["Hotel, Pension, Jugendherb.","Betten",null,"      B.",null,"-----","-----",6,"Betten",{"$f":"SUM(C154/H154)","v":0},15,"B.",0]
["Kulturräume, Saalbauten","Sitzpl. ",null,"      S.",null,"-----","-----",10,"Sitzpl.",{"$f":"SUM(C155/H155)","v":0},"-----","-----","-----"]
["Schule Unterstufen VSS-Norm","Kl. Zim",null,"Kl. Zim",null,"-----","-----",0.2,"Kl. Zim",{"$f":"SUM(C156*H156)","v":0},1,"Kl. Zim",{"$f":"SUM(C156*K156)","v":0}]
["Pflegeheim gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.3,"Bett",0,0.5,"Bett",{"$f":"SUM(C157*K157)","v":0}]
["Spital, Klinik gem. VSS-Norm","Betten",null,"      B.",null,"-----","-----",0.5,"Bett",0,1,"Bett",{"$f":"SUM(C158*K158)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,null,null,"-----","-----",null,null,{"$f":"SUM(C159*H159)","v":0},null,null,{"$f":"SUM(C159*K159)","v":0}]
["Bedarf nach VSS / Freier Text",null,null,null,null,"-----","-----",null,null,{"$f":"SUM(C160*H160)","v":0},null,null,{"$f":"SUM(C160*K160)","v":0}]
["b) Total Normbedarf der neuen Nutzung\nübertragen in Tabelle d+e) zur Bestimmung der Anzahl PP ",null,null,null,null,null,{"$f":"SUM(G145:G160)","v":0},null,null,{"$f":"SUM(J145:J160)","v":0},null,null,{"$f":"SUM(M145:M160)","v":0}]
[]
["c) Normbedarf Diff. der alten und neuen Nutzung  übertragen in Tabelle f) zur Bestimmung der mindestens erforderlichen Anzahl PP",null,null,null,null,null,{"$f":"SUM(G161-G141)","v":0},null,null,{"$f":"SUM(J161-J141)","v":0},null,null,{"$f":"SUM(M161-M141)","v":0}]
[]
["Erforderliche Parkplätze nach Zonen",null,null,"Maximum und Minimum in % des Normbedarfs"]
[null,null,null,"Total","Bewohnende",null,null,"Besuchende/Kundschaft",null,null,"Beschäftigte"]
["d) Maximal zulässige\nAnzahl PP berechnet aus Normbedarf b) der neuen Nutzung",null,{"$f":"IF($C$13=Tabelle1!$A$4,0,$C$13)","v":0},{"$f":"IF($C$167=0,0,IF($C$167=C168,D168,VLOOKUP($C$167,$C$168:$M$171,2)))","v":0},{"$f":"IF($C$167=0,0,IF($C$167=C168,0,VLOOKUP($C$167,$C$168:$M$171,3)))","v":0},{"$f":"SUM(G161*E167)","v":0},{"$f":"ROUND(F167,0)","v":0},{"$f":"IF($C$167=0,0,IF($C$167=C168,0,VLOOKUP($C$167,$C$168:$M$171,6)))","v":0},{"$f":"SUM(J161*H167)","v":0},{"$f":"ROUND(I167,0)","v":0},{"$f":"IF($C$167=0,0,IF($C$167=C168,0,VLOOKUP($C$167,$C$168:$M$171,9)))","v":0},{"$f":"SUM(M161*K167)","v":0},{"$f":"ROUND(L167,0)","v":0}]
["d) Maximal zulässige\nAnzahl PP berechnet aus Normbedarf b) der neuen Nutzung",null,"Zone I","Keine"]
[null,null,"Zone II",{"$f":"SUM(M169,J169,G169)","v":0},0.3,{"$f":"$G$161*E169","v":0},{"$f":"MROUND(F169,1)","v":0},0.3,{"$f":"SUM(J161*H169)","v":0},{"$f":"MROUND(I169,1)","v":0},0.2,{"$f":"SUM(M161*K169)","v":0},{"$f":"MROUND(L169,1)","v":0}]
[null,null,"Zone III",{"$f":"SUM(M170,J170,G170)","v":0},0.7,{"$f":"$G$161*E170","v":0},{"$f":"MROUND(F170,1)","v":0},0.6,{"$f":"SUM(J161*H170)","v":0},0,0.5,{"$f":"SUM(M161*K170)","v":0},0]
[null,null,"Zone IV",{"$f":"SUM(M171,J171,G171)","v":0},1,0,{"$f":"MROUND(F171,1)","v":0},1,{"$f":"SUM(J161*H171)","v":0},{"$f":"MROUND(I171,1)","v":0},1,{"$f":"SUM(M161*K171)","v":0},{"$f":"MROUND(L171,1)","v":0}]
["e) Mindestens erforderliche\nAnzahl PP berechnet aus Normbedarf b) der neuen Nutzung",null,{"$f":"IF($C$13=Tabelle1!$A$4,0,$C$13)","v":0},{"$f":"IF($C$172=0,0,IF($C$172=C173,D173,(IF($C$172=C174,D173,VLOOKUP($C$172,$C$173:$M$176,2)))))","v":0},{"$f":"IF($C$172=0,0,IF($C$172=C173,0,VLOOKUP($C$172,$C$173:$M$176,3)))","v":0},{"$f":"SUM(G161*E172)","v":0},{"$f":"ROUND(F172,0)","v":0},{"$f":"IF($C$172=0,0,IF($C$172=C173,0,VLOOKUP($C$172,$C$173:$M$176,6)))","v":0},{"$f":"SUM(J161*H172)","v":0},{"$f":"ROUND(I172,0)","v":0},{"$f":"IF($C$172=0,0,IF($C$172=C173,0,VLOOKUP($C$172,$C$173:$M$176,9)))","v":0},{"$f":"SUM(M161*K172)","v":0},{"$f":"ROUND(L172,0)","v":0}]
["e) Mindestens erforderliche\nAnzahl PP berechnet aus Normbedarf b) der neuen Nutzung",null,"Zone I","Keine"]
[null,null,"Zone II"]
[null,null,"Zone III",{"$f":"SUM(M175,J175,G175)","v":0},0.3,{"$f":"SUM(G161*E175)","v":0},{"$f":"ROUND(F175,0)","v":0},0.2,{"$f":"SUM(J161*H175)","v":0},{"$f":"MROUND(I175,1)","v":0},0.1,{"$f":"SUM(M161*K175)","v":0},{"$f":"MROUND(L175,1)","v":0}]
[null,null,"Zone IV",{"$f":"SUM(M176,J176,G176)","v":0},0.8,{"$f":"SUM(G161*E176)","v":0},{"$f":"ROUND(F176,0)","v":0},0.5,{"$f":"SUM(J161*H176)","v":0},{"$f":"MROUND(I176,1)","v":0},0.5,{"$f":"SUM(M161*K176)","v":0},{"$f":"MROUND(L176,1)","v":0}]
["f) Mindestens erforderliche\nAnzahl PP berechnet aus Normbedarf c) Diff. der alten und neuen Nutzung",null,{"$f":"IF($C$13=Tabelle1!$A$4,0,$C$13)","v":0},{"$f":"IF($C$177=0,0,IF($C$177=C178,D178,IF(C177=C179,D178,VLOOKUP($C$177,$C$178:$M$181,2))))","v":0},{"$f":"IF($C$177=0,0,IF($C$177=C178,0,VLOOKUP($C$177,$C$178:$M$181,3)))","v":0},{"$f":"SUM(G163*E177)","v":0},{"$f":"ROUND(F177,0)","v":0},{"$f":"IF($C$177=0,0,IF($C$177=C178,0,VLOOKUP($C$177,$C$178:$M$181,6)))","v":0},{"$f":"SUM(J163*H177)","v":0},{"$f":"ROUND(I177,0)","v":0},{"$f":"IF($C$177=0,0,IF($C$177=C178,0,VLOOKUP($C$177,$C$178:$M$181,9)))","v":0},{"$f":"SUM(M163*K177)","v":0},{"$f":"ROUND(L177,0)","v":0}]
["f) Mindestens erforderliche\nAnzahl PP berechnet aus Normbedarf c) Diff. der alten und neuen Nutzung",null,"Zone I","Keine"]
[null,null,"Zone II"]
[null,null,"Zone III",{"$f":"IF((SUM(M180,J180,G180))<=0,\" \",SUM(M180,J180,G180))","v":" "},0.3,{"$f":"SUM(G163*E180)","v":0},{"$f":"ROUND(F180,0)","v":0},0.2,{"$f":"SUM(J163*H180)","v":0},{"$f":"ROUND(I180,0)","v":0},0.1,{"$f":"SUM(M163*K180)","v":0},{"$f":"ROUND(L180,0)","v":0}]
[null,null,"Zone IV",{"$f":"IF((SUM(M181,J181,G181))<=0,\" \",SUM(M181,J181,G181))","v":" "},0.8,{"$f":"SUM(G163*E181)","v":0},{"$f":"ROUND(F181,0)","v":0},0.5,{"$f":"SUM(J163*H181)","v":0},{"$f":"ROUND(I181,0)","v":0},0.5,{"$f":"SUM(M163*K181)","v":0},{"$f":"ROUND(L181,0)","v":0}]
[]
["Roller- und Motorradparkplätze  ",null,"Anteil der neu bewilligten Autoparkplätze",null,null,null,"Projektierte Autoparkplätze",null,null,"Anteil ",null,"Anzahl PP"]
[null,null,null,null,null,null,null,null,null,0.15,null,{"$f":"IF(G184=\"Bitte eingeben\",0,SUM(G184*J184))","v":0}]
["Behinderten-Parkplätze",null,"Ab 40 Autoparkplätzen ist min. 1 PP für Kundschaft oder Besuchende als IV-Parkplatz zu realisieren. Im Übrigen gilt die SIA-Norm (521 500).",null,null,null,null,null,null,"Anzahl Parkplätze",null,"Anzahl PP"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN((J186/40),0)","v":0}]
[]
["Carparkplätze ",null,"Hotel und Pension 1 Carparkplatz pro 50 Betten",null,null,null,null,"Anzahl Betten",null,"Reduktion Zone",null,"Anzahl PP"]
[null,null,null,null,null,null,null,{"$f":"C154","v":0},null,{"$f":"IF($C$13=Tabelle1!$A$4,0,IF($C$13=C168,0,VLOOKUP($C$13,C169:H171,6)))","v":0},null,{"$f":"SUM(H189/50)*J189","v":0}]
[]
["Veloabstellplätze Mindestbedarf der neuen Nutzung",null,null,null,null,null,"(Art. 18 ff. Parkplatzreglement)"]
[null,null,"Menge","1 Veloabstellplatz pro",null,null,"Minimum","Hinweis / Bemerkungen"]
["Wohnungen",null,null,1,"Zimmer",null,{"$f":"SUM(C193/D193)","v":0},"Die halben Zimmer der Wohnungen werden mitgerechnet (z. B. 2.5-Zimmerwohnung = 2.5 Veloabstellplätze). Die Rundung auf ganze Abstellplätze erfolgt am Schluss, Bruchteile von weniger als 0,5 Abstellplätzen werden abgerundet, jene von 0,5 und mehr Abstellplätzen werden aufgerundet. \n\nBei Wohnungen sind die Veloabstellplätze für Besuchende im Wert für Bewohnende enthalten.\n\nAnteil Kurzzeit-Veloabstellplätze 30 %.\n\nKönnen Nutzung und Anzahl Arbeitsplätze noch nicht ermittelt werden, ist der Standardbedarf über die Geschossfläche GF gemäss VSS-Norm SN 40 065 festzulegen. \n\nBei Wohnungen wird der Normbedarf nicht reduziert. Bei den übrigen Objekten kann der Normbedarf bei ungünstiger Topografie, sehr ungünstiger Lage, zum Schutz des Ortsbildes oder bei Mehrfachnutzungen reduziert werden.\n\nWeitere Auskünfte erteilt das Tiefbauamt der Stadt Luzern."]
["Alterswohnung\nStudierendenwohnungen",null,null,4,"Wohnung",null,{"$f":"SUM(C194/D194)","v":0}]
[null,"Besuchende",null,1000," m2",null,{"$f":"SUM(C195/D195)","v":0}]
["Post, Bank, Büro, Labor, Praxis, Therapie, Coiffeur",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C196/D196)","v":0}]
[null,"Besuchende",null,50," m2",null,{"$f":"SUM(C197/D197)","v":0}]
["Lagerraum, Archiv",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C198/D198)","v":0}]
["Läden, Drogerie\nApotheke",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C199/D199)","v":0}]
[null,"Besuchende",null,50," m2",null,{"$f":"SUM(C200/D200)","v":0}]
["Fabrikation\nWerkstätten",null,null,150," m2",null,{"$f":"SUM(C201/D201)","v":0}]
[null,"Besuchende",null,500," m2",null,{"$f":"SUM(C201/D202)","v":0}]
["Restaurant, Café, Spital, Pflege-Altersheime",null,null,5,"Arbeitsplätze",null,{"$f":"SUM(C203/D203)","v":0}]
[null,"Besuchende",null,5,"Sitzplätze*",null,0]
["Hotel, Pension, Saalbaute Kulturraum, Unterhaltung ",null,null,5,"Arbeitsplätze",null,0]
[null,"Besuchende",null,10,"Sitzplätze",null,0]
["Lehrpersonen / Personal",null,null,5,"Personen",null,0]
["Höhere Schulen",null,null,2,"Studierende",null,0]
["Mittelschulen",null,null,2,"Schulkinder",null,0]
["Primarschulen, Kindergärten",null,null,5,"Schulkinder",null,0]
["Bedarf nach VSS / Freier Text",null,null,1,null,null,{"$f":"IF(D211=0,\"\",(SUM(C211/D211)))","v":0}]
["Bedarf nach VSS / Freier Text",null,null,1,null,null,{"$f":"IF(D212=0,\"\",(SUM(C212/D212)))","v":0}]
["Total Veloabstellplätze",null,null,null,null,null,{"$f":"SUM(G193:G212)","v":0}]

{"sheet":"Tabelle1","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Parkplatzzone I-IV","Art der Nutzung"]
[]
["Bitte auswählen"]
["Zone I"]
["Zone II",null,null,null,0.7]
["Zone III",null,null,null,0.7]
["Zone IV",null,null,null,1]
[]
[]
[]
[]
[]
[]
["Bauart"]
["Bitte auswählen"]
["Neubau"]
["Umbau"]