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

{"sheet":"Formular","index":0,"n_rows":62,"n_cols":47,"rows_kept":62,"merged":[[0,0,0,36],[1,0,1,36],[2,0,2,36],[3,0,3,4],[3,5,3,15],[3,17,3,23],[3,24,3,33],[3,34,3,36],[4,0,4,4],[4,5,4,6],[4,8,4,15],[4,17,4,23],[4,24,4,33],[4,34,4,36],[5,0,5,36],[6,0,6,33],[6,34,7,36],[7,0,7,4],[7,5,7,24],[7,25,7,33],[8,0,8,4],[8,5,8,15],[8,17,8,24],[8,25,8,31],[8,32,8,33],[9,0,9,4],[9,5,9,15],[9,17,9,24],[9,25,9,31],[9,32,9,33],[10,0,10,4],[10,5,10,13],[10,17,10,24],[10,25,10,31],[10,32,10,33],[10,34,10,36],[11,0,11,36],[12,0,12,30],[12,31,12,33],[13,0,13,30],[13,31,13,35],[14,0,14,30],[14,31,14,33],[14,34,14,35],[15,0,15,35],[16,0,16,30],[16,31,16,33],[16,34,16,36],[17,0,17,30],[17,31,17,33],[17,34,17,36],[18,0,18,18],[18,19,18,35],[19,0,19,39],[20,0,20,35],[21,0,21,35],[22,0,22,35],[23,0,23,4],[23,5,23,8],[23,9,23,35],[24,0,24,4],[24,5,24,8],[24,9,24,35],[25,0,25,4],[25,5,25,8],[25,9,25,35],[26,0,26,4],[26,5,26,8],[26,9,26,35],[27,0,27,4],[27,5,27,8],[27,9,27,30],[27,31,27,33],[27,34,27,35],[28,0,28,30],[28,31,28,33],[29,0,29,35],[30,0,30,8],[30,9,30,30],[30,31,30,33],[30,34,30,35],[31,0,31,8],[31,9,31,30],[31,31,31,33],[31,34,31,35],[32,0,32,8],[32,9,32,35],[33,0,33,35],[34,0,34,35],[35,0,35,35],[36,0,36,30],[36,31,36,33],[36,34,36,35],[37,0,37,35],[38,0,38,8],[38,9,38,35],[39,0,39,35],[40,0,40,35],[41,0,41,35],[42,0,42,30],[42,31,42,33],[42,34,42,35],[43,0,43,35],[44,0,44,20],[44,22,44,23],[44,26,44,30],[44,31,44,33],[44,34,44,35],[45,0,45,20],[45,22,45,23],[45,26,45,30],[45,31,45,33],[45,34,45,35],[46,0,46,35],[47,0,47,8],[47,9,47,24],[47,25,47,27],[47,29,47,35],[48,0,48,8],[48,13,48,23],[48,25,48,27],[48,29,48,35],[49,0,49,8],[49,13,49,23],[49,25,49,27],[49,29,49,30],[49,31,49,33],[49,34,49,35],[50,0,50,35],[51,0,51,26],[51,27,51,30],[51,31,51,33],[51,34,51,36],[52,0,52,26],[52,27,52,30],[52,31,52,33],[52,34,52,36],[53,0,53,35],[54,8,54,9],[54,10,54,17],[54,18,54,26],[55,8,55,9],[55,10,55,17],[55,18,55,26],[56,0,56,35],[57,0,57,16],[57,17,57,24],[57,25,57,34],[58,0,58,35],[59,0,59,35],[60,0,60,16],[60,18,60,34]]}
["Lärmschutznachweis für HLKK Anlagen bei einfachen Situationen"]
["Beurteilung der Lärmimmissionen von Heizungs-, Lüftungs-, Klima- und Kühlanlagen"]
["Generelle Angaben / Standort der Anlage"]
["Adresse",{"$nulls":16},"Parzelle Nr."]
["PLZ / Ort",{"$nulls":16},"Baugesuchs-Nr."]
[]
["Angaben zur Anlage (techn. Datenblatt + Situationsplan mit eingezeichneter Anlage beilegen)",{"$nulls":33},"Angabe des Herstellers:"]
["Art der Anlage:",{"$nulls":24},"andere",{"$nulls":14},false]
["Hersteller",{"$nulls":16},"Schallleistung LwA",{"$nulls":14},"dBA",{"$nulls":13}," "]
["Modell / Typ",{"$nulls":16},"Schalldruckpegel LpA",{"$nulls":14},"dBA",{"$nulls":7},true]
["Leistung",{"$nulls":13},"kW",null,null,"bei s1",{"$nulls":14},"m"]
[]
["Schallleistungspegel aussen LwA",{"$nulls":30},{"$f":"IF(AO10=FALSE,IF(Z10=\"\",\"\",(Z10+20*LOG10(Z11)+11-3)),Z9)","v":0},null,null,"dBA"]
["Distanz (s) Quelle - Empfänger:"]
["(Nachbargebäude; wenn unbebaute Nachbarparzelle: Baulinie, resp. Grenzabstand; MFH: im Gebäude selber)",{"$nulls":33},"m"]
[]
["Planungswert gemäss Anhang 6 LSV",{"$nulls":30},{"$f":"IF(AO17=1,45+AO20,IF(AO17=2,50+AO20,55))","v":50},null,null,"dBA Nacht",{"$nulls":5},2]
[{"$nulls":31},{"$f":"IF(AO17=1,55+AO20,IF(AO17=2,60+AO20,65))","v":60},null,null,"dBA Tag"]
["Betroffener Raum ist Betriebsraum gemäss Art. 42 LSV?",{"$nulls":39},false]
[{"$nulls":40},{"$f":"IF(AO19=TRUE,5,0)","v":0}]
["Berechnung des Beurteilungspegels Lr am Empfangsort"]
[]
["Korrekturfaktoren"]
["Richtwirkungs-",{"$nulls":39},5]
["korrektur Dc"]
[]
[]
[{"$nulls":31},{"$f":"IF(AO24=1,6,IF(AO24=2,9,IF(AO24=3,6,IF(AO24=4,9,3))))","v":3},null,null,"dB"]
["Schalldruckpegel LpA am Empfangsort (LpA = LwA-11+Dc -20*log(s/s0))",{"$nulls":30},{"$f":"IF(AF15=\"\",\"\",IF(AF13=\"\",\"\",AF13-11+AF28-20*LOG(AF15)))","v":""},null,null,"dBA"]
[]
["Pegelkorrektur K1",{"$nulls":8},"Betrieb während der Nacht (19:00 - 07:00 Uhr)",{"$nulls":21},10,null,null,"dB"]
[{"$nulls":9},"Betrieb am Tag (07:00 - 19:00 Uhr)",{"$nulls":21},5,null,null,"dB"]
["Pegelkorrektur K2",{"$nulls":8},"Hörbarkeit der Tonhaltigkeit"]
[{"$nulls":40},2]
[]
[]
[{"$nulls":31},{"$f":"IF(AO34=2,2,IF(AO34=3,4,IF(AO34=4,6,0)))","v":2},null,null,"dB"]
[]
["Pegelkorrektur K3",{"$nulls":8},"Hörbarkeit der Impulshaltigkeit"]
[{"$nulls":40},1]
[]
[]
[{"$nulls":31},{"$f":"IF(AO40=2,2,IF(AO40=3,4,IF(AO40=4,6,0)))","v":0},null,null,"dB"]
[]
["Pegelkorrektur durch Betriebsdauer t:",{"$nulls":21},720,null,"Min.",null,"in der Nacht",{"$nulls":4},{"$f":"IF(W45=0,\"-\",10*LOG(W45/720))","v":{"v":0,"d":"0.0"}},null,null,"dB"]
[" (In der Regel: t = 720 Min, Abweichungen sind zu begründen)",{"$nulls":21},720,null,"Min.",null,"am Tag",{"$nulls":4},{"$f":"IF(W46=0,\"-\",10*LOG(W46/720))","v":{"v":0,"d":"0.0"}},null,null,"dB"]
[]
["Lärmschutzmassnahmen",{"$nulls":27},"dB",{"$nulls":10},{"$f":"IF(AO48=TRUE,Z48,\"\")","v":""},false]
[{"$nulls":28},"dB",{"$nulls":10},{"$f":"IF(AO49=TRUE,Z49,\"\")","v":""},false]
[{"$nulls":28},"dB",null,null,{"$f":"SUM(AN48:AN50)","v":0},null,null,"dB",{"$nulls":4},{"$f":"IF(AO50=TRUE,Z50,\"\")","v":""},false]
[]
["Beurteilungspegel Lr",{"$nulls":26},"Nacht",{"$nulls":3},{"$f":"IF(AF29=\"\",\"\",IF(AF45=\"-\",0,AF29+AF31+AF37+AF43+AF45+AF50))","v":""},null,null,"dBA"]
[{"$nulls":27},"Tag",{"$nulls":3},{"$f":"IF(AF29=\"\",\"\",IF(AF46=\"-\",0,AF29+AF32+AF37+AF43+AF46+AF50))","v":""},null,null,"dBA"]
[]
["Der Planungswert von",{"$nulls":7},{"$f":"AF17","v":50},null,"dBA wird in der Nacht",{"$nulls":7},{"$f":"IF(AF29=\"\",\"\",IF(AF52<=AF17,\"eingehalten.\",\"nicht eingehalten.\"))","v":""}]
[{"$nulls":8},{"$f":"AF18","v":60},null,"dBA wird am Tag",{"$nulls":7},{"$f":"IF(AF29=\"\",\"\",IF(AF53<=AF18,\"eingehalten.\",\"nicht eingehalten.\"))","v":""}]
[]
["Wurde das Vorsorgeprinzip berücksichtigt?",{"$nulls":39},5]
[]
["Verfasser"]
[]
["Ort, Datum",{"$nulls":17},"Unterschrift"]

{"sheet":"Makro","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"hidden":true}
["Zuerst Bilder einfügen"]
["Jedem Bild das zugehörige Makro zuweisen"]
[]
[]
[]
["Klicke auf Bild in D6"]
[]
[]
[]
[]
["Klicke auf Bild in D12"]
[]
[]
[]
[]
[]
["Klicke auf Bild in D18"]