{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Formular","Makro"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"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":"Formular","index":0,"n_rows":65,"n_cols":47,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,0,63,16],[63,18,63,34],[56,0,56,35],[57,0,57,34],[52,0,52,35],[53,0,53,30],[53,31,53,33],[53,34,53,36],[54,0,54,35],[55,8,55,9],[55,14,55,21],[55,22,55,35],[50,0,50,8],[50,13,50,23],[50,25,50,27],[50,29,50,35],[51,0,51,8],[51,13,51,23],[51,25,51,27],[51,29,51,30],[51,31,51,33],[51,34,51,35],[46,0,46,35],[47,9,47,24],[47,25,47,27],[47,29,47,35],[48,0,48,8],[48,9,48,24],[48,25,48,27],[48,29,48,35],[49,0,49,8],[49,9,49,24],[49,25,49,27],[49,29,49,35],[41,0,41,35],[42,0,42,35],[43,0,43,30],[43,31,43,33],[43,34,43,35],[44,0,44,35],[45,0,45,20],[45,22,45,23],[45,26,45,30],[45,31,45,33],[45,34,45,35],[35,0,35,35],[36,0,36,35],[37,0,37,30],[37,31,37,33],[37,34,37,35],[38,0,38,35],[39,0,39,8],[39,9,39,35],[40,0,40,35],[30,0,30,35],[31,0,31,8],[31,9,31,30],[31,31,31,33],[31,34,31,35],[32,0,32,35],[33,0,33,8],[33,9,33,35],[34,0,34,35],[27,0,27,4],[27,5,27,8],[27,9,27,35],[28,0,28,4],[28,5,28,8],[28,9,28,30],[28,31,28,33],[28,34,28,35],[29,0,29,30],[29,31,29,33],[23,0,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],[16,0,16,30],[17,31,17,33],[17,34,17,35],[18,0,18,35],[19,31,19,33],[20,0,20,35],[21,0,21,35],[22,0,22,35],[19,13,19,30],[8,34,8,36],[9,0,9,36],[10,0,10,36],[11,0,11,36],[12,28,12,29],[12,30,12,36],[14,0,14,36],[15,0,15,30],[15,31,15,33],[7,0,7,4],[7,5,7,15],[7,17,7,24],[7,25,7,31],[7,32,7,33],[8,0,8,4],[8,5,8,13],[8,17,8,24],[8,25,8,31],[8,32,8,33],[3,0,3,36],[4,0,4,33],[4,34,5,36],[5,0,5,33],[6,0,6,4],[6,5,6,15],[6,17,6,24],[6,25,6,31],[6,32,6,33],[0,0,0,36],[1,0,1,4],[1,5,1,15],[1,17,1,23],[1,24,1,33],[1,34,1,36],[2,0,2,4],[2,17,2,23],[2,24,2,33],[2,34,2,36],[2,5,2,15]]}
["Generelle Angaben"]
["Adresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parzelle Nr."]
["PLZ / Ort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baugesuchs-Nr."]
[]
["Angaben zur Luft / Wasser-Wärmepumpe (techn. Datenblatt + Situationsplan mit eingezeichneter WP beilegen)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angabe des Herstellers:"]
["gemäss Euro-Norm EN 255 resp. EN 14511 (siehe auch www.wpz.ch) "]
["Hersteller",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schallleistung LwA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Modell / Typ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schalldruckpegel LpA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dBA",null,null,null,null,null,null,null,false]
["Leistung",null,null,null,null,null,null,null,null,null,null,null,null,null,"kW",null,null,"bei s1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[]
["Aufstellungsart"]
[]
["Vorsorgeprinzip",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lärmschutzmassnahmen müssen eine Wirkung von mindestens",{"$f":"IF(AO13<0,0,AO13)","v":""},null,"dB erreichen!",null,null,null,null,null,null,null,null,null,{"$f":"IF(F9=\"\",\"\",IF(AF16=\"\",0,IF(F9<10,(AF16-58),(AF16-(58+(F9-10)*0.5)))))","v":""}]
["Nach Faktenblatt \"Lärmtechnische Beurteilung von Wärmepumpen\", Abschnitt 2.1"]
[]
["Schallleistungspegel aussen LwA (Herstellerangaben / Wärmepumpen-Testzentrum www.wpz.ch)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO8=FALSE,IF(Z8=\"\",\"\",(Z8+20*LOG10(Z9)+11-3)),Z7)","v":""},null,null,"dBA"]
["Distanz (s) Quelle - Empfänger"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bitte Empfindlichkeitsstufe am Empfangsort wählen"]
["Planungswert Nacht gemäss Anhang 6 LSV",null,null,null,null,null,null,null,null,null,null,null,null,"Bitte Empfindlichkeitsstufe am Empfangsort wählen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N20=\"Bitte Empfindlichkeitsstufe am Empfangsort wählen\", 0,IF(N20=\"Empfindlichkeitsstufe II (Wohnzone)\",45,50))","v":0},null,null,"dBA",null,null,null,null,null,1,"Empfindlichkeitsstufe II (Wohnzone)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Empfindlichkeitsstufe III (z.B. Mischzone)"]
["Berechnung des Beurteilungspegels Lr am Empfangsort"]
[]
["Korrekturfaktoren"]
["Richtwirkungs-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["korrektur Dc bei"]
["Nachbargebäuden"]
["oder Baulinien"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO25=1,6,IF(AO25=2,9,IF(AO25=3,6,IF(AO25=4,9,3))))","v":6},null,null,"dB"]
["Schalldruckpegel LpA am Empfangsort (LpA = LwA-11+Dc -20*log(s))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF18=\"\",\"\",IF(AF16=\"\",\"\",AF16-11+AF29-20*LOG(AF18)))","v":""},null,null,"dBA"]
[]
["Pegelkorrektur K1",null,null,null,null,null,null,null,null,"Heizbetrieb während der Nacht (19:00 - 07:00 Uhr)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,"dB"]
[]
["Pegelkorrektur K2",null,null,null,null,null,null,null,null,"Hörbarkeit der Tonhaltigkeit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO35=2,2,IF(AO35=3,4,IF(AO35=4,6,0)))","v":0},null,null,"dB"]
[]
["Pegelkorrektur K3",null,null,null,null,null,null,null,null,"Hörbarkeit der Impulshaltigkeit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO41=2,2,IF(AO41=3,4,IF(AO41=4,6,0)))","v":0},null,null,"dB"]
[]
["Pegelkorrektur durch Betriebsdauer t (In der Regel: t = 720 Min.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,720,null,"Min.",null,null,null,null,null,null,{"$f":"10*LOG(W46/720)","v":0},null,null,"dB"]
[]
["Lärmschutzmassnahmen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3,null,null,"dB",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO48=TRUE,Z48,\"\")","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-5,null,null,"dB",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO49=TRUE,Z49,\"\")","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-6,null,null,"dB",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO50=TRUE,Z50,\"\")","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dB",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO51=TRUE,Z51,\"\")","v":""},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dB",null,null,{"$f":"SUM(AN48:AN52)","v":0},null,null,"dB",null,null,null,null,{"$f":"IF(AO52=TRUE,Z52,\"\")","v":""},false]
[]
["Beurteilungspegel Lr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF30=\"\",\"\",AF30+AF32+AF38+AF44+AF46+AF52)","v":""},null,null,"dBA"]
[]
["Der Planungswert von",null,null,null,null,null,null,null,{"$f":"AF20","v":0},null,"dBA wird ",null,null,null,{"$f":"IF(AF30=\"\",\"\",IF(AF54<=AF20,\"eingehalten.\",\"nicht eingehalten.\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[]
[]
[]
[]
[]
["Ort, Datum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unterschrift Verfasser"]

{"sheet":"Makro","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["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"]