{"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":62,"n_cols":41,"rows_kept":62,"cut":false,"hidden":false,"merged":[[40,0,40,35],[41,0,41,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],[60,0,60,16],[60,18,60,34],[56,0,56,35],[57,0,57,16],[57,17,57,24],[57,25,57,34],[58,0,58,35],[59,0,59,35],[47,9,47,24],[47,25,47,27],[55,8,55,9],[52,34,52,36],[54,10,54,17],[54,18,54,26],[51,0,51,26],[51,27,51,30],[55,10,55,17],[55,18,55,26],[48,0,48,8],[48,13,48,23],[48,25,48,27],[52,31,52,33],[50,0,50,35],[51,31,51,33],[51,34,51,36],[52,0,52,26],[52,27,52,30],[53,0,53,35],[54,8,54,9],[44,31,44,33],[44,34,44,35],[45,0,45,20],[45,22,45,23],[49,29,49,30],[49,31,49,33],[49,34,49,35],[46,0,46,35],[48,29,48,35],[47,0,47,8],[44,0,44,20],[44,22,44,23],[44,26,44,30],[47,29,47,35],[49,0,49,8],[49,13,49,23],[49,25,49,27],[28,31,28,33],[28,0,28,30],[45,26,45,30],[45,31,45,33],[45,34,45,35],[32,0,32,8],[32,9,32,35],[30,9,30,30],[30,31,30,33],[29,0,29,35],[30,0,30,8],[31,34,31,35],[31,0,31,8],[30,34,30,35],[31,9,31,30],[31,31,31,33],[42,0,42,30],[42,31,42,33],[42,34,42,35],[43,0,43,35],[37,0,37,35],[38,0,38,8],[38,9,38,35],[39,0,39,35],[26,0,26,4],[26,5,26,8],[26,9,26,35],[27,0,27,4],[27,5,27,8],[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],[27,9,27,30],[27,31,27,33],[27,34,27,35],[20,0,20,35],[21,0,21,35],[17,0,17,30],[17,31,17,33],[16,34,16,36],[17,34,17,36],[18,19,18,35],[19,0,19,39],[25,0,25,4],[25,5,25,8],[25,9,25,35],[12,31,12,33],[14,0,14,30],[14,31,14,33],[14,34,14,35],[10,17,10,24],[13,0,13,30],[13,31,13,35],[15,0,15,35],[16,0,16,30],[16,31,16,33],[7,25,7,33],[18,0,18,18],[5,0,5,36],[6,0,6,33],[6,34,7,36],[7,0,7,4],[8,0,8,4],[8,5,8,15],[8,25,8,31],[8,32,8,33],[7,5,7,24],[8,17,8,24],[9,0,9,4],[9,5,9,15],[9,25,9,31],[9,32,9,33],[10,0,10,4],[10,5,10,13],[10,25,10,31],[10,32,10,33],[9,17,9,24],[10,34,10,36],[11,0,11,36],[12,0,12,30],[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]]}
["Formulaire d'attestation du respect des exigences de protection contre le \nbruit pour des installations CVC et similaires dans des situations simples"]
["Évaluation des émissions sonores pour les installations de chauffage, de ventilation et de climatisation "]
["Informations générales / Emplacement de l'installation"]
["Adresse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° parcelle"]
["NPA / Lieu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autorisation\nconstruction n°"]
[]
["Informations sur l'installation (fiche tech.  + plan de situation avec l'installation à fournir en annexe)",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,"Données du fabricant:\n"]
["Technologie:",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,true]
["Fabricant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puissance sonore LwA",null,null,null,null,null,null,null,54,null,null,null,null,null,null,"dBA"]
["Modèle/type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pression sonore LpA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dBA",null,null,null,null,null,null,null,true]
["Puissance",null,null,null,null,null,null,null,null,null,null,null,null,null,"kW",null,null,"à distance s1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m"]
[]
["Puissance sonore à la source 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,null,null,{"$f":"IF(AO10=FALSE,IF(Z10=\"\",\"\",(Z10+20*LOG10(Z11)+11-3)),Z9)","v":54},null,null,"dBA"]
["Distance (s) entre la source et le récepteur:"]
["(bâtiment voisin / limite de construction pour parcelle non bâtie / dans le bâtiment même pour les maisons plurifamiliales)",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,4,null,null,"m"]
[]
["Valeur de planification selon ann. 6 OPB",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(AO17=1,45+AO20,IF(AO17=2,50+AO20,55))","v":45},null,null,"dB(A) de nuit",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(AO17=1,55+AO20,IF(AO17=2,60+AO20,65))","v":55},null,null,"dB(A) de jour"]
["Local d'exploitation selon art. 42 OPB?",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,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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO19=TRUE,5,0)","v":0}]
["Calcul du niveau d’évaluation Lr au récepteur"]
[]
["Facteurs de corrections"]
["Correction de la",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,3]
["directivité Dc"]
[]
[]
[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(AO24=1,6,IF(AO24=2,9,IF(AO24=3,6,IF(AO24=4,9,3))))","v":6},null,null,"dB"]
["Pression sonore LpA au récepteur (LpA = LwA-11+Dc -20*log(s/s1))",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(AF15=\"\",\"\",IF(AF13=\"\",\"\",AF13-11+AF28-20*LOG(AF15)))","v":36.95880017344075},null,null,"dB(A)"]
[]
["Correction de niveau K1",null,null,null,null,null,null,null,null,"pour le fonctionnement nocturne (19h00 - 07h00)",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"]
[null,null,null,null,null,null,null,null,null,"pour le fonctionnement de jour (07h00 - 19h00)",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"]
["Correction de niveau K2",null,null,null,null,null,null,null,null,"Audibilité des composantes tonales"]
[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,2]
[]
[]
[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(AO34=2,2,IF(AO34=3,4,IF(AO34=4,6,0)))","v":2},null,null,"dB"]
[]
["Correction de niveau K3",null,null,null,null,null,null,null,null,"Audibilité des composantes impulsives"]
[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(AO40=2,2,IF(AO40=3,4,IF(AO40=4,6,0)))","v":0},null,null,"dB"]
[]
["Correction relative au temps de fonctionnement t:",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,"durant la nuit",null,null,null,null,{"$f":"IF(W45=0,\"-\",10*LOG(W45/720))","v":0},null,null,"dB"]
[" (en principe: t = 720 min, autres durées doivent être justifiées)",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,"durant le jour",null,null,null,null,{"$f":"IF(W46=0,\"-\",10*LOG(W46/720))","v":0},null,null,"dB"]
[]
["Mesures de protection ",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(AO48=TRUE,Z48,\"\")","v":0},true]
["contre le bruit",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(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,null,null,null,"dB",null,null,{"$f":"SUM(AN48:AN50)","v":0},null,null,"dB",null,null,null,null,{"$f":"IF(AO50=TRUE,Z50,\"\")","v":""},false]
[]
["Niveau d'évaluation 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,"Nuit",null,null,null,{"$f":"IF(AF29=\"\",\"\",IF(AF45=\"-\",0,AF29+AF31+AF37+AF43+AF45+AF50))","v":48.95880017344075},null,null,"dB(A)"]
[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,"Jour",null,null,null,{"$f":"IF(AF29=\"\",\"\",IF(AF46=\"-\",0,AF29+AF32+AF37+AF43+AF46+AF50))","v":43.95880017344075},null,null,"dB(A)"]
[]
["La valeur de planification de ",null,null,null,null,null,null,null,{"$f":"AF17","v":45},null,"dB(A) de nuit est",null,null,null,null,null,null,null,{"$f":"IF(AF29=\"\",\"\",IF(AF52<=AF17,\"respectée.\",\"dépassée.\"))","v":"dépassée."}]
[null,null,null,null,null,null,null,null,{"$f":"AF18","v":55},null,"dB(A) de jour est",null,null,null,null,null,null,null,{"$f":"IF(AF29=\"\",\"\",IF(AF53<=AF18,\"respectée.\",\"dépassée.\"))","v":"respectée."}]
[]
["Est-ce que le principe de prévention a été mis en oeuvre?",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]
[]
["Auteur"]
[]
["Lieu, date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature"]

{"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"]