{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Lisez_moi","Conclusion_globale","Complétude_du_dossier","Informations_sur_le_bâtiment","Essai_selon_norme_guide","Analyse_resultats","Commentaires_generaux","conditionnement","courbe_debits_fuite","pressions_debit_nul","Photos","modele","ValidationCase"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":24,"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":"Lisez_moi","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Règles d'utillisation du document"]
[]
["Version 1",null,"¨"]
["un premier onglet \"Conclusion_globale\" à ne pas modifier",null,"¨"]
["les réserves et recommandations se copient/collent via une macro ainsi que la coche des cases correspondantes en respectant le code couleur.",null,"¨"]
["ne pas rajouter de lignes dans l'onglet \"Conclusion_globale\", il faut agrandir les lignes déjà existantes si besoin d'espace.",null,"¨"]
["une fois la grille renseignée, il suffit de cliquer sur le bouton en haut à droite  \"compilation des grilles\" pour que la macro s'exécute.",null,"¨"]
[null,null,"¨"]
["ne pas renommer les onglets",null,"¨"]
[]
["ne pas supprimer les onglets"]
[]
["ne pas enlever les mots Réserves et Recommandation (sans s) écrit en gras  dans le document aux colonnes EFG (à partir du 2ème onglet)"]
["inscrire les différentes réserves sous la première ligne après le titre \"Réserves\""]
["inscrire les différentes recommandations sous la première ligne après le titre \"Recommandation\""]
[]
["ne pas écrire \"uniquement\" le mot Réserves ou Recommandation dans une autre case des colonnes EFG dans les différents onglets."]
[]
["lors de la compilation des onglets, les lignes des réserves et recommandations (restées vierges pour les critères de la grille) se réduisent au seul titre de l'onglet dans \"conclusion globale\" pour une meilleure visibilité."]
[]
["code couleur à respecter impérativement"]
["1er passage noir"]
["2ème passage vert"]
["3ème passage rouge"]
[]
["Attention : être précis et concis dans les commentaires. Une limitation du nombre de caractères est prévue dans la prochaine version."]
[]
["V2 du 01/12/2021 : "]
["ajout de la mention pénalité de 0,3 si travaux \"impactant  la perméabilité à l'air après la livraison\" au critère AB1-1 (informations sur le bâtiment)"]
["ajout de la mention le résultat inclut la ou les pénalité(s) prévues par le RE2020 le cas échéant au critère AB3-1 + détail du calcul (analyse des résultats)"]
["ajout de la mention pénalité de 1,2 si mesure par échantillonage RE2020 au critère AB4-2 (commentaires généraux : échantillonnage)"]
[]
["V3 du 01/08/2022 : "]
["modification du critère AB3-1 (pas de calcul de la pénalité car inclut dans le moteur de calcul de l'Eth)."]

{"sheet":"Conclusion_globale","index":1,"n_rows":369,"n_cols":12,"rows_kept":369,"cut":false,"hidden":false,"merged":[[368,1,368,2],[361,2,361,11],[363,1,363,2],[364,1,364,2],[365,1,365,2],[366,1,366,2],[367,1,367,2],[355,2,355,11],[356,2,356,11],[357,1,357,11],[358,2,358,11],[359,2,359,11],[360,2,360,11],[349,2,349,11],[350,2,350,11],[351,2,351,11],[352,2,352,11],[353,2,353,11],[354,2,354,11],[343,2,343,11],[344,2,344,11],[345,2,345,11],[346,2,346,11],[347,2,347,11],[348,1,348,11],[337,2,337,11],[338,2,338,11],[339,2,339,11],[340,2,340,11],[341,2,341,11],[342,2,342,11],[331,2,331,11],[332,2,332,11],[333,2,333,11],[334,2,334,11],[335,1,335,11],[336,2,336,11],[325,2,325,11],[326,1,326,11],[327,2,327,11],[328,2,328,11],[329,2,329,11],[330,2,330,11],[319,2,319,11],[320,2,320,11],[321,2,321,11],[322,2,322,11],[323,2,323,11],[324,2,324,11],[313,2,313,11],[314,2,314,11],[315,2,315,11],[316,2,316,11],[317,1,317,11],[318,2,318,11],[307,2,307,11],[308,2,308,11],[309,2,309,11],[310,2,310,11],[311,2,311,11],[312,2,312,11],[301,2,301,11],[302,2,302,11],[303,2,303,11],[304,2,304,11],[305,2,305,11],[306,2,306,11],[295,2,295,11],[296,2,296,11],[297,2,297,11],[298,2,298,11],[299,2,299,11],[300,2,300,11],[289,2,289,11],[290,2,290,11],[291,2,291,11],[292,2,292,11],[293,2,293,11],[294,2,294,11],[283,2,283,11],[284,2,284,11],[285,2,285,11],[286,2,286,11],[287,2,287,11],[288,2,288,11],[277,2,277,11],[278,2,278,11],[279,2,279,11],[280,1,280,11],[281,2,281,11],[282,2,282,11],[271,2,271,11],[272,2,272,11],[273,2,273,11],[274,2,274,11],[275,2,275,11],[276,2,276,11],[265,2,265,11],[266,2,266,11],[267,2,267,11],[268,2,268,11],[269,2,269,11],[270,2,270,11],[259,2,259,11],[260,2,260,11],[261,2,261,11],[262,2,262,11],[263,2,263,11],[264,2,264,11],[253,2,253,11],[254,2,254,11],[255,2,255,11],[256,2,256,11],[257,2,257,11],[258,2,258,11],[247,2,247,11],[248,2,248,11],[249,2,249,11],[250,2,250,11],[251,2,251,11],[252,2,252,11],[241,2,241,11],[242,2,242,11],[243,2,243,11],[244,2,244,11],[245,2,245,11],[246,2,246,11],[235,2,235,11],[236,2,236,11],[237,2,237,11],[238,2,238,11],[239,2,239,11],[240,2,240,11],[229,2,229,11],[230,2,230,11],[231,2,231,11],[232,2,232,11],[233,2,233,11],[234,2,234,11],[223,2,223,11],[224,2,224,11],[225,2,225,11],[226,2,226,11],[227,2,227,11],[228,2,228,11],[217,2,217,11],[218,1,218,11],[219,1,219,11],[220,2,220,11],[221,2,221,11],[222,2,222,11],[211,2,211,11],[212,2,212,11],[213,2,213,11],[214,2,214,11],[215,2,215,11],[216,2,216,11],[205,2,205,11],[206,2,206,11],[207,2,207,11],[208,2,208,11],[209,2,209,11],[210,2,210,11],[199,2,199,11],[200,2,200,11],[201,2,201,11],[202,2,202,11],[203,2,203,11],[204,2,204,11],[193,2,193,11],[194,2,194,11],[195,2,195,11],[196,1,196,11],[197,1,197,11],[198,2,198,11],[187,2,187,11],[188,2,188,11],[189,2,189,11],[190,2,190,11],[191,1,191,11],[192,2,192,11],[181,2,181,11],[182,1,182,11],[183,2,183,11],[184,2,184,11],[185,2,185,11],[186,2,186,11],[175,2,175,11],[176,2,176,11],[177,2,177,11],[178,2,178,11],[179,2,179,11],[180,2,180,11],[169,1,169,11],[170,2,170,11],[171,2,171,11],[172,2,172,11],[173,2,173,11],[174,2,174,11],[163,2,163,11],[164,2,164,11],[165,2,165,11],[166,2,166,11],[167,2,167,11],[168,2,168,11],[157,2,157,11],[158,2,158,11],[159,2,159,11],[160,1,160,11],[161,2,161,11],[162,2,162,11],[151,1,151,11],[152,2,152,11],[153,2,153,11],[154,2,154,11],[155,2,155,11],[156,2,156,11],[145,2,145,11],[146,2,146,11],[147,2,147,11],[148,2,148,11],[149,2,149,11],[150,2,150,11],[139,2,139,11],[140,2,140,11],[141,2,141,11],[142,2,142,11],[143,2,143,11],[144,2,144,11],[133,2,133,11],[134,2,134,11],[135,2,135,11],[136,2,136,11],[137,2,137,11],[138,2,138,11],[127,2,127,11],[128,2,128,11],[129,2,129,11],[130,2,130,11],[131,2,131,11],[132,2,132,11],[121,2,121,11],[122,2,122,11],[123,2,123,11],[124,2,124,11],[125,2,125,11],[126,2,126,11],[115,2,115,11],[116,2,116,11],[117,2,117,11],[118,2,118,11],[119,2,119,11],[120,2,120,11],[109,2,109,11],[110,2,110,11],[111,2,111,11],[112,2,112,11],[113,2,113,11],[114,1,114,11],[103,2,103,11],[104,2,104,11],[105,2,105,11],[106,2,106,11],[107,2,107,11],[108,2,108,11],[97,2,97,11],[98,2,98,11],[99,2,99,11],[100,2,100,11],[101,2,101,11],[102,2,102,11],[91,2,91,11],[92,2,92,11],[93,2,93,11],[94,2,94,11],[95,2,95,11],[96,2,96,11],[85,2,85,11],[86,2,86,11],[87,2,87,11],[88,2,88,11],[89,2,89,11],[90,2,90,11],[79,2,79,11],[80,2,80,11],[81,2,81,11],[82,2,82,11],[83,2,83,11],[84,2,84,11],[73,2,73,11],[74,2,74,11],[75,2,75,11],[76,2,76,11],[77,2,77,11],[78,2,78,11],[67,2,67,11],[68,2,68,11],[69,2,69,11],[70,2,70,11],[71,2,71,11],[72,2,72,11],[61,2,61,11],[62,2,62,11],[63,2,63,11],[64,2,64,11],[65,2,65,11],[66,2,66,11],[55,2,55,11],[56,2,56,11],[57,2,57,11],[58,2,58,11],[59,2,59,11],[60,2,60,11],[49,2,49,11],[50,2,50,11],[51,2,51,11],[52,1,52,11],[53,1,53,11],[54,2,54,11],[43,2,43,11],[44,2,44,11],[45,2,45,11],[46,2,46,11],[47,2,47,11],[48,2,48,11],[37,2,37,11],[38,2,38,11],[39,2,39,11],[40,2,40,11],[41,2,41,11],[42,2,42,11],[31,1,31,11],[32,2,32,11],[33,2,33,11],[34,2,34,11],[35,2,35,11],[36,2,36,11],[16,1,17,11],[18,1,19,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[30,1,30,2],[9,1,9,2],[9,3,9,8],[9,9,9,11],[11,1,11,11],[13,1,13,11],[14,1,15,11],[6,1,7,2],[6,3,7,5],[6,6,7,8],[6,9,7,11],[8,1,8,2],[8,3,8,8],[8,9,8,11],[1,1,1,11],[2,1,2,11],[5,1,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,11]]}
[]
[null,"Autorisation à réaliser des essais de perméabilité à l’air sur l'enveloppe des bâtiments"]
[null,"Grille d’évaluation des dossiers"]
[]
[]
[null,"Dossier n°",null,"Société",null,null,"Nom du demandeur",null,null,"Date de soumission du dossier de suivi"]
[]
[]
[null,"Identification de l’expert ",null,"Ordre de mission",null,null,null,null,null,"Date d’instruction du dossier "]
[]
[]
[null,"Avis détaillé sur le dossier"]
[]
[null,"Dossiers examinés (liste des rapports examinés et leur référence)"]
[null,"Passage n°1:"]
[]
[null,"Passage n°2:"]
[]
[null,"Passage n°3:"]
[]
[null,"Conclusion"]
[null,"Conclusion n°1: "]
[null,"Coclusion n°2: "]
[null,"Coclusion n°3:"]
[null,null,"Dossier devant être accepté"]
[null,null,"Oui",null,null,"¨"]
[null,null,"Oui, avec des recommandations",null,null,"¨"]
[null,null,"Demande de lever des réserves",null,null,"¨"]
[null,null,"Non",null,null,"¨"]
[]
[null,"Réserves"]
[null,{"$f":"+Complétude_du_dossier!B1","v":"AA . Complétude du dossier"}]
[null,"AA.1"]
[]
[]
[]
[null,"AA.2"]
[]
[]
[]
[null,"AA.3"]
[]
[]
[]
[null,"AA.4"]
[]
[]
[]
[null,"AA.5"]
[]
[]
[]
[null,{"$f":"+Informations_sur_le_bâtiment!A1","v":"AB . Examen des rapports conformes à NF EN ISO 9972 et au FD P50-784"}]
[null,{"$f":"+Informations_sur_le_bâtiment!A4","v":"AB1-Informations sur le bâtiment"}]
[null,"AB1-1"]
[]
[]
[]
[null,"AB1-2"]
[]
[]
[]
[null,"AB1-3"]
[]
[]
[]
[null,"AB1-4"]
[]
[]
[]
[null,"AB1-5"]
[]
[]
[]
[null,"AB1-6"]
[]
[]
[]
[null,"AB1-7"]
[]
[]
[]
[null,"AB1-8"]
[]
[]
[]
[null,"AB1-9"]
[]
[]
[]
[null,"AB1-10"]
[]
[]
[]
[null,"AB1-11"]
[]
[]
[]
[null,"AB1-12"]
[]
[]
[]
[null,"AB1-13"]
[]
[]
[]
[null,"AB1-14"]
[]
[]
[]
[null,"AB1-15"]
[]
[]
[]
[null,{"$f":"+Essai_selon_norme_guide!A1","v":"AB2- Essai selon la norme NF EN ISO 9972 et le FD P50-784"}]
[null,"AB2-1"]
[]
[]
[]
[null,"AB2-2"]
[]
[]
[]
[null,"AB2-3"]
[]
[]
[]
[null,"AB2-4"]
[]
[]
[]
[null,"AB2-5"]
[]
[]
[]
[null,"AB2-6"]
[]
[]
[]
[null,"AB2-7"]
[]
[]
[]
[null,"AB2-8"]
[]
[]
[]
[null,"AB2-9"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"AB3- Analyse des résultats"}]
[null,"AB3-1"]
[]
[]
[]
[null,"AB3-2"]
[]
[]
[]
[null,{"$f":"+Commentaires_generaux!A1","v":"AB4- Commentaires généraux"}]
[null,"AB4-1"]
[]
[]
[]
[null,"AB4-2"]
[]
[]
[]
[null,{"$f":"+conditionnement!A1","v":"AB5- Etat des ouvertures de l'enveloppe pendant l'essai"}]
[null,"AB5-1"]
[]
[]
[]
[null,"AB5-2"]
[]
[]
[]
[null,"AB5-3"]
[]
[]
[]
[null,{"$f":"+courbe_debits_fuite!A1","v":"AB6- Courbes de débits de fuite"}]
[null,"AB6-1"]
[]
[]
[]
[null,"AB6-2"]
[]
[]
[]
[null,{"$f":"+pressions_debit_nul!A1","v":"AB7- Pressions à débit nul"}]
[null,"AB7"]
[]
[]
[]
[null,"Recommandations"]
[null,{"$f":"+B32","v":"AA . Complétude du dossier"}]
[null,"AA.1"]
[]
[]
[]
[null,"AA.2"]
[]
[]
[]
[null,"AA.3"]
[]
[]
[]
[null,"AA.4"]
[]
[]
[]
[null,"AA.5"]
[]
[]
[]
[null,{"$f":"+Informations_sur_le_bâtiment!A1","v":"AB . Examen des rapports conformes à NF EN ISO 9972 et au FD P50-784"}]
[null,{"$f":"+Informations_sur_le_bâtiment!A4","v":"AB1-Informations sur le bâtiment"}]
[null,"AB1-1"]
[]
[]
[]
[null,"AB1-2"]
[]
[]
[]
[null,"AB1-3"]
[]
[]
[]
[null,"AB1-4"]
[]
[]
[]
[null,"AB1-5"]
[]
[]
[]
[null,"AB1-6"]
[]
[]
[]
[null,"AB1-7"]
[]
[]
[]
[null,"AB1-8"]
[]
[]
[]
[null,"AB1-9"]
[]
[]
[]
[null,"AB1-10"]
[]
[]
[]
[null,"AB1-11"]
[]
[]
[]
[null,"AB1-12"]
[]
[]
[]
[null,"AB1-13"]
[]
[]
[]
[null,"AB1-14"]
[]
[]
[]
[null,"AB1-15"]
[]
[]
[]
[null,{"$f":"+Essai_selon_norme_guide!A1","v":"AB2- Essai selon la norme NF EN ISO 9972 et le FD P50-784"},"\n"]
[null,"AB2-1"]
[]
[]
[]
[null,"AB2-2"]
[]
[]
[]
[null,"AB2-3"]
[]
[]
[]
[null,"AB2-4"]
[]
[]
[]
[null,"AB2-5"]
[]
[]
[]
[null,"AB2-6"]
[]
[]
[]
[null,"AB2-7"]
[]
[]
[]
[null,"AB2-8"]
[]
[]
[]
[null,"AB2-9"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"AB3- Analyse des résultats"}]
[null,"AB3-1"]
[]
[]
[]
[null,"AB3-2"]
[]
[]
[]
[null,{"$f":"+Commentaires_generaux!A1","v":"AB4- Commentaires généraux"}]
[null,"AB4-1"]
[]
[]
[]
[null,"AB4-2"]
[]
[]
[]
[null,{"$f":"+conditionnement!A1","v":"AB5- Etat des ouvertures de l'enveloppe pendant l'essai"}]
[null,"AB5-1"]
[]
[]
[]
[null,"AB5-2"]
[]
[]
[]
[null,"AB5-3"]
[]
[]
[]
[null,{"$f":"+courbe_debits_fuite!A1","v":"AB6- Courbes de débits de fuite"}]
[null,"AB6-1"]
[]
[]
[]
[null,"AB6-2"]
[]
[]
[]
[null,{"$f":"+pressions_debit_nul!A1","v":"AB7- Pressions à débit nul"}]
[null,"AB7"]
[]
[]
[]
[null,null,"\n"]
[null,"\n",null,"Complétude du dossier","Examen des rapports"]
[null,"Critère",null,null,"Information sur le bâtiment","Essai selon la norme","Analyses  des résultats","Commentaires généraux","Etat des ouvertures de l'enveloppe","Courbes des débits de fuite","Pressions à débit nul","Global"]
[null,"Conforme",null,"¨","¨","¨","¨","¨","¨","¨","¨","¨"]
[null,"Non conforme",null,"¨","¨","¨","¨","¨","¨","¨","¨","¨"]
[null,"Réserves",null,"¨","¨","¨","¨","¨","¨","¨","¨","¨"]
[null,"Recommandations",null,"¨","¨","¨","¨","¨","¨","¨","¨","¨"]

{"sheet":"Complétude_du_dossier","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[28,8,28,9],[29,8,29,9],[9,8,10,10],[17,8,17,9],[15,4,15,6],[16,4,16,6],[17,4,17,6],[22,8,22,9],[22,4,22,6],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[11,8,11,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[2,1,2,2],[11,7,20,7],[21,7,30,7],[31,1,40,3],[11,4,11,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[26,4,26,6],[27,4,27,6],[32,4,32,6],[34,4,34,6],[9,7,10,7],[35,4,35,6],[36,4,36,6],[39,4,39,6],[40,4,40,6],[11,1,20,3],[21,1,30,3],[38,4,38,6],[9,0,10,0],[9,1,10,3],[9,4,10,6],[12,4,12,6],[14,4,14,6],[24,4,24,6],[25,4,25,6],[11,0,20,0],[21,0,30,0],[13,4,13,6],[18,4,18,6],[23,4,23,6],[28,4,28,6],[41,0,50,0],[51,0,60,0],[58,8,58,9],[59,8,59,9],[56,4,56,6],[52,4,52,6],[40,8,40,9],[42,4,42,6],[49,4,49,6],[50,4,50,6],[51,8,51,9],[46,8,46,9],[47,8,47,9],[31,7,40,7],[38,8,38,9],[39,8,39,9],[41,7,50,7],[51,1,60,3],[41,1,41,3],[42,1,43,3],[44,1,48,3],[49,1,50,3],[31,0,40,0],[37,4,37,6],[56,8,56,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[44,8,44,9],[48,8,48,9],[41,4,41,6],[51,7,60,7],[60,4,60,6],[60,8,60,9],[46,4,46,6],[47,4,47,6],[57,4,57,6],[59,4,59,6],[52,8,52,9],[53,8,53,9],[54,8,54,9],[57,8,57,9],[45,8,45,9],[49,8,49,9],[50,8,50,9],[54,4,54,6],[55,4,55,6],[58,4,58,6],[53,4,53,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[48,4,48,6],[30,8,30,9],[31,8,31,9],[51,4,51,6],[55,8,55,9],[37,8,37,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[33,4,33,6]]}
[null,"AA . Complétude du dossier"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[]
[null,null,null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AA.1","Conformité du matériel aux exigences de la norme (marque et type de matériel)",null,null,"Réserves",null,null,"5 rapports + registre","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AA.2","Constats de vérification / certificats d’étalonnage\n(le rapport de mesure inclut les constats de vérification et/ou les certificats d'étalonnage des matériels utilisés)\n",null,null,"Réserves",null,null,"5 rapports + registre","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AA.3","Registre des opérations testées précisant les opérations candidates au label (indiquer le nombre de mesures enregistrées dans le registre)",null,null,"Réserves",null,null,"5 rapports + registre","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AA.4","Justificatifs des critères d’expérience :",null,null,"Réserves",null,null,"Attestation validation formation + 5 rapports + registre des opérations","Conforme",null,"¨"]
[null,"formation externe reconnue par le Ministère en charge de la Construction",null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,"5 rapports datant d'après validation de la formation ",null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[null,"au moins 10 essais réalisés sur des opérations différentes"]
[]
["AA.5","Justificatif de validation de formation reconnue par le Ministère en charge de la Construction (document daté et signé)",null,null,"Réserves",null,null,"Attestation validation formation ","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"Informations_sur_le_bâtiment","index":3,"n_rows":159,"n_cols":11,"rows_kept":159,"cut":false,"hidden":false,"merged":[[36,8,36,9],[37,4,37,6],[37,8,37,9],[38,4,38,6],[38,8,38,9],[39,4,39,6],[39,8,39,9],[24,4,24,6],[24,8,24,9],[25,4,25,6],[25,8,25,9],[26,4,26,6],[26,8,26,9],[27,4,27,6],[27,8,27,9],[11,7,12,7],[111,4,111,6],[33,1,42,3],[83,0,92,0],[63,0,72,0],[73,0,81,0],[93,0,102,0],[61,4,61,6],[5,1,5,2],[11,0,12,0],[13,1,22,3],[11,1,12,3],[13,0,22,0],[28,4,28,6],[30,4,30,6],[31,4,31,6],[29,4,29,6],[21,4,21,6],[14,4,14,6],[15,4,15,6],[11,4,12,6],[13,4,13,6],[16,4,16,6],[36,4,36,6],[17,4,17,6],[23,4,23,6],[22,4,22,6],[23,0,32,0],[23,1,32,3],[33,4,33,6],[103,0,112,0],[113,0,122,0],[32,4,32,6],[80,4,80,6],[43,4,43,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[53,4,53,6],[60,4,60,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[18,4,18,6],[19,4,19,6],[20,4,20,6],[55,4,55,6],[56,4,56,6],[123,0,132,0],[133,0,142,0],[33,0,42,0],[43,0,52,0],[53,0,62,0],[83,8,83,9],[71,8,71,9],[82,4,82,6],[83,4,83,6],[90,4,90,6],[71,4,71,6],[72,4,72,6],[73,4,73,6],[43,1,52,3],[53,1,62,3],[63,1,72,3],[73,1,81,3],[83,1,92,3],[101,4,101,6],[102,4,102,6],[103,4,103,6],[81,4,81,6],[101,8,101,9],[34,4,34,6],[63,4,63,6],[70,4,70,6],[62,8,62,9],[72,8,72,9],[73,8,73,9],[23,8,23,9],[28,8,28,9],[30,8,30,9],[29,8,29,9],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[49,4,49,6],[54,4,54,6],[70,8,70,9],[32,8,32,9],[53,8,53,9],[60,8,60,9],[61,8,61,9],[34,8,34,9],[35,4,35,6],[35,8,35,9],[141,8,141,9],[13,7,22,7],[23,7,32,7],[102,8,102,9],[103,8,103,9],[81,8,81,9],[82,8,82,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[43,7,52,7],[33,7,42,7],[13,8,13,9],[16,8,16,9],[14,8,14,9],[15,8,15,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[63,7,72,7],[93,7,102,7],[148,4,148,6],[11,8,12,10],[63,8,63,9],[150,8,150,9],[90,8,90,9],[91,8,91,9],[33,8,33,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[80,8,80,9],[17,8,17,9],[22,8,22,9],[43,8,43,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[143,8,143,9],[93,8,93,9],[21,8,21,9],[31,8,31,9],[132,8,132,9],[133,8,133,9],[140,8,140,9],[129,4,129,6],[143,0,152,0],[153,0,162,0],[153,1,162,3],[153,4,153,6],[143,1,152,3],[150,4,150,6],[143,4,143,6],[153,8,153,9],[159,4,159,6],[159,8,159,9],[160,4,160,6],[152,8,152,9],[151,8,151,9],[161,4,161,6],[161,8,161,9],[160,8,160,9],[162,4,162,6],[162,8,162,9],[151,4,151,6],[152,4,152,6],[145,4,145,6],[146,4,146,6],[147,4,147,6],[119,4,119,6],[124,4,124,6],[103,7,112,7],[123,7,132,7],[93,1,102,3],[103,1,112,3],[113,1,122,3],[123,1,132,3],[93,4,93,6],[100,4,100,6],[94,4,94,6],[95,4,95,6],[96,4,96,6],[97,4,97,6],[98,4,98,6],[99,4,99,6],[105,4,105,6],[106,4,106,6],[107,4,107,6],[108,4,108,6],[109,4,109,6],[110,4,110,6],[127,4,127,6],[128,4,128,6],[118,8,118,9],[124,8,124,9],[110,8,110,9],[111,8,111,9],[112,8,112,9],[133,1,142,3],[112,4,112,6],[113,4,113,6],[120,4,120,6],[123,4,123,6],[130,4,130,6],[131,4,131,6],[140,4,140,6],[132,4,132,6],[133,4,133,6],[125,4,125,6],[121,4,121,6],[122,4,122,6],[126,4,126,6],[114,4,114,6],[115,4,115,6],[116,4,116,6],[117,4,117,6],[118,4,118,6],[57,4,57,6],[58,4,58,6],[59,4,59,6],[54,8,54,9],[55,8,55,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[59,8,59,9],[53,7,62,7],[62,4,62,6],[74,4,74,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[73,7,81,7],[130,8,130,9],[84,4,84,6],[85,4,85,6],[86,4,86,6],[87,4,87,6],[88,4,88,6],[89,4,89,6],[83,7,92,7],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[88,8,88,9],[89,8,89,9],[92,8,92,9],[91,4,91,6],[92,4,92,6],[107,8,107,9],[108,8,108,9],[109,8,109,9],[114,8,114,9],[115,8,115,9],[116,8,116,9],[117,8,117,9],[100,8,100,9],[153,7,162,7],[154,8,154,9],[155,8,155,9],[156,8,156,9],[113,7,122,7],[147,8,147,9],[148,8,148,9],[149,8,149,9],[157,8,157,9],[158,8,158,9],[123,8,123,9],[113,8,113,9],[120,8,120,9],[122,8,122,9],[121,8,121,9],[119,8,119,9],[125,8,125,9],[126,8,126,9],[127,8,127,9],[128,8,128,9],[138,8,138,9],[139,8,139,9],[144,8,144,9],[143,7,152,7],[131,8,131,9],[129,8,129,9],[69,4,69,6],[69,8,69,9],[64,4,64,6],[64,8,64,9],[65,4,65,6],[65,8,65,9],[66,4,66,6],[66,8,66,9],[67,4,67,6],[67,8,67,9],[68,4,68,6],[68,8,68,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[97,8,97,9],[98,8,98,9],[99,8,99,9],[104,8,104,9],[105,8,105,9],[106,8,106,9],[104,4,104,6],[149,4,149,6],[154,4,154,6],[155,4,155,6],[156,4,156,6],[157,4,157,6],[158,4,158,6],[134,8,134,9],[135,8,135,9],[136,8,136,9],[137,8,137,9],[145,8,145,9],[146,8,146,9],[142,8,142,9],[134,4,134,6],[135,4,135,6],[136,4,136,6],[137,4,137,6],[138,4,138,6],[139,4,139,6],[133,7,142,7],[144,4,144,6],[141,4,141,6],[142,4,142,6]]}
["AB . Examen des rapports conformes à NF EN ISO 9972 et au FD P50-784"]
[]
[]
["AB1-Informations sur le bâtiment"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB1-1","Informations sur le bâtiment (date de construction ou de réhabilitation, adresse, type de permis de construire précisant s'il s'agit ou non d'un permis groupé ou non, nombre de niveaux, nombre de logements, étage du logement testé).                                              RE 2020 : travaux \"impactant la perméabilité à l'air après la livraison le cas échéant : descriptif des travaux réservés +  mention de la pénalité de 0,3.",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-2","Coordonnées du client, noms de la société, rôle et fonction, et coordonnées de l'opérateur réalisant les tests.",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-3","Objectif de l'essai : justifier la finalité, obtention d'un label, etc. \nSi rapport individuel servant à la détermination de la perméabilité globale, justification de l'échantillonnage.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-4","Information sur les parties soumises à l'essai (description, hauteur, Srt, surfaces appropriées, volume intérieur, surface de paroi froide hors plancher bas, autres dimensions)\n\nSelon le FD P50-784 (2016):\n- volume (V) intérieur : incertitude à estimer comme suit (recommandation) : \n* 3% si calcul à partir de plans ou mesuré avec précision sur site\n* 10% si la valeur retenue est celle du volume chauffé au sens de la RT2012 ou si calcul du volume comme suit : ShabxHsp (pour un RDC)\n- Srt : si mesure sur un bâtiment entier ou sur une partie de bâtiment quel que soit son type (résidentiel ou non, usage individuel ou collectif).\n- SAHB : si mesure sur une partie de bâtiment résidentiel.\n- SUrt : si mesure sur une partie de bâtiment non résidentiel\nNota : Sref pour la RE2020.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-5","Type de système de chauffage, de ventilation, de conditionnement d'air",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-6","Informations + justifications des calculs permettant de vérifier les résultats annoncés : source d'information Atbât et volume chauffé : si pas synthèse d'étude thermique, fournir plans + cotes + détail calcul, sinon fournir extrait de synthèse d'étude thermique",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-7","Date de l'essai",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-8","Référence à la norme NF EN ISO 9972 et à son guide d'application associé",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-9","Moment du mesurage détaillé (état du bâtiment au moment de l'essai: bâtiment neuf ou bâtiment existant, en situation initiale (existant), en cours de chantier, à réception,...)\n\nMoment du mesurage selon le FD P50-784 (2016) : \n- 2 situations : bâtiment neuf ou bâtiment existant.\n- 4 états : en cours de chantier, à réception, en cours d'utilisation et initial avant travaux.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-10","Méthode employée",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-11","Conditions de réalisation de l'essai (en pressurisation, dépressurisation, par paliers croissants ou décroissants)",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-12","Équipements utilisés (pression, différence de pression, débit d'air, température, vitesse du vent, dimensions) Fournisseur, modèle, numéro de série, dates d'étalonnages\n\nSelon le FD P50-784 (2016): \nCertificats étalonnage des matériels utilisés avec les plages d'étalonnage donc d'utilisation.\nPériodicité maximale : \n- Anémomètre : 4 ans\n- Thermomètre : 4 ans\n- Ventilateur et orifices associés : 2 ans\n- Manomètre numérique : 1 an\n- Mètre classe 3 et télémètre: 1an\n\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-13","Lieu d'installation de la porte soufflante sur porte communiquant vers un lnc (Cf. FAQ perméa Cerema du 23/07/2021) : réserve si les 3 points de vérification ne figurent pas dans le rapport. Lieu d'implantation du système de mesure : Préciser la position de la sonde (sinon recommandation) et dans le cas où elle est placée dans un autre volume fermé, indiquer l’état de ce volume vis-à-vis de l’extérieur, exemple « ouvert sur l’extérieur » (sinon recommandation) .",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-14","Protocole de contrôle en service du matériel utlisé pendant la mesure",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB1-15","Registre des opérations : \nVérifier : nom de l’opérateur + nom de la société ; nombre de rapports fournis correspondant au nombre de mesures enregistrées dans le registre (sinon réclamer les rapports manquants via une réserve) ; complétude des colonnes (cf colonne « CM » saisie des données obligatoires complète.\nNB : si rapports de mesure corrigés, vérifier que les données relatives à la mesure ont été retranscrites dans le registre (ex : Atbât recalculé, volume, Q4Pa_surf….). Les cases en bleu foncé sont obligatoirement renseignées.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"Essai_selon_norme_guide","index":4,"n_rows":96,"n_cols":11,"rows_kept":96,"cut":false,"hidden":false,"merged":[[2,1,2,2],[90,1,99,3],[80,4,80,6],[97,4,97,6],[70,4,70,6],[89,4,89,6],[59,4,59,6],[40,4,40,6],[29,4,29,6],[60,4,60,6],[44,4,44,6],[55,4,55,6],[37,4,37,6],[30,4,30,6],[77,4,77,6],[91,4,91,6],[96,4,96,6],[77,8,77,9],[78,4,78,6],[78,8,78,9],[79,4,79,6],[79,8,79,9],[50,4,50,6],[50,8,50,9],[57,4,57,6],[57,8,57,9],[54,4,54,6],[54,8,54,9],[53,8,53,9],[70,7,79,7],[71,4,71,6],[71,8,71,9],[72,4,72,6],[72,8,72,9],[73,4,73,6],[73,8,73,9],[74,4,74,6],[74,8,74,9],[75,4,75,6],[75,8,75,9],[76,4,76,6],[70,0,79,0],[80,0,89,0],[30,1,39,3],[10,0,19,0],[20,0,29,0],[80,1,89,3],[70,1,79,3],[60,1,69,3],[50,0,59,0],[40,1,49,3],[50,1,59,3],[80,8,80,9],[89,8,89,9],[90,4,90,6],[90,8,90,9],[87,4,87,6],[87,8,87,9],[88,4,88,6],[88,8,88,9],[98,8,98,9],[80,7,89,7],[81,4,81,6],[81,8,81,9],[82,4,82,6],[82,8,82,9],[83,4,83,6],[83,8,83,9],[84,4,84,6],[85,4,85,6],[85,8,85,9],[86,4,86,6],[97,8,97,9],[84,8,84,9],[86,8,86,9],[90,7,99,7],[37,8,37,9],[38,4,38,6],[38,8,38,9],[39,4,39,6],[39,8,39,9],[46,4,46,6],[46,8,46,9],[49,8,49,9],[49,4,49,6],[47,4,47,6],[48,4,48,6],[47,8,47,9],[48,8,48,9],[40,8,40,9],[43,4,43,6],[41,4,41,6],[42,4,42,6],[41,8,41,9],[42,8,42,9],[43,8,43,9],[40,7,49,7],[45,4,45,6],[45,8,45,9],[90,0,99,0],[18,4,18,6],[18,8,18,9],[19,4,19,6],[19,8,19,9],[40,0,49,0],[60,0,69,0],[8,0,9,0],[8,1,9,3],[8,4,9,6],[8,7,9,7],[8,8,9,10],[10,1,19,3],[10,4,10,6],[10,8,10,9],[17,4,17,6],[17,8,17,9],[20,1,29,3],[20,4,20,6],[20,8,20,9],[27,4,27,6],[27,8,27,9],[28,4,28,6],[28,8,28,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[10,7,19,7],[14,8,14,9],[15,8,15,9],[16,8,16,9],[11,4,11,6],[12,4,12,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[20,7,29,7],[21,4,21,6],[21,8,21,9],[22,4,22,6],[22,8,22,9],[38,13,38,15],[38,16,47,16],[38,17,38,18],[39,13,39,15],[39,17,39,18],[40,13,40,15],[40,17,40,18],[41,13,41,15],[41,17,41,18],[42,13,42,15],[42,17,42,18],[43,13,43,15],[43,17,43,18],[44,13,44,15],[44,17,44,18],[45,13,45,15],[45,17,45,18],[46,13,46,15],[46,17,46,18],[47,13,47,15],[47,17,47,18],[23,4,23,6],[23,8,23,9],[24,4,24,6],[24,8,24,9],[25,4,25,6],[25,8,25,9],[26,4,26,6],[26,8,26,9],[30,7,39,7],[31,4,31,6],[31,8,31,9],[32,4,32,6],[32,8,32,9],[33,4,33,6],[33,8,33,9],[34,4,34,6],[34,8,34,9],[35,4,35,6],[35,8,35,9],[36,4,36,6],[36,8,36,9],[29,8,29,9],[30,8,30,9],[56,8,56,9],[60,7,69,7],[61,4,61,6],[61,8,61,9],[62,4,62,6],[62,8,62,9],[63,4,63,6],[63,8,63,9],[64,4,64,6],[64,8,64,9],[65,4,65,6],[65,8,65,9],[66,4,66,6],[66,8,66,9],[58,4,58,6],[58,8,58,9],[59,8,59,9],[50,7,59,7],[51,4,51,6],[51,8,51,9],[52,4,52,6],[52,8,52,9],[53,4,53,6],[76,8,76,9],[55,8,55,9],[56,4,56,6],[60,8,60,9],[67,4,67,6],[67,8,67,9],[68,4,68,6],[68,8,68,9],[69,4,69,6],[69,8,69,9],[70,8,70,9],[96,8,96,9],[98,4,98,6],[99,4,99,6],[99,8,99,9],[91,8,91,9],[92,4,92,6],[92,8,92,9],[93,4,93,6],[93,8,93,9],[94,4,94,6],[94,8,94,9],[95,4,95,6],[95,8,95,9]]}
["AB2- Essai selon la norme NF EN ISO 9972 et le FD P50-784"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB2-1","Évaluation ou mesure de la vitesse du vent",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-2","Mesure des températures extérieure et intérieure",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-3","Pression barométrique\n- Si elle est absente du rapport : recommandation.\n- Si elle est mentionnée dans le rapport : préciser comment elle est déterminée (mesure ou calcul à partir de l'altitude du lieu ou donnée issue de la station météorologique locale). \n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-4","Différences de pression Différences de pression à débit nul Δp0,1+, Δp0,1-, Δp0,2+,Δp0,2-,Δp0,1, Δp0,2 pour chaque essai (pressurisation et dépressurisation) .Vérifier < 5Pa\n(pendant au moins 30 secondes et avec 10 valeurs minimum)\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-5","Tableau des différences de pression induites et des débits d'air correspondants, \n\nSelon le FD P50-784 (2016): \n- différences de pression mesurée.\n- différence de pression induite dans le bâtiment.\n- pression cible.\n- débit d'air qr, mesuré qm, à travers l'enveloppe qenv.\n- pour chaque palier de pression, préciser le diaphragme utilisé.\n- si bâtiment tertiaire : préciser la méthode utilisée pour homogénéiser la pression\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-6","Séquence de mesures (différence de pression minimale et intervalles conformes à la norme). Une différence de +/- 3Pa est admise sur la différence de pression minimale mesurée Δpmin mesurée",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-7","Expression des résultats : Cenv, CL, n, q50, n50, q4, Q4Pa-surf, surface de fuite (optionnelle) en pressurisation et/ou en dépressurisation \nn compris entre 0.5 et 1\n\nIncertitude sur le q4 doit être inférieure à 15%, sinon essai non valable.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-8","Intervalles à 95% de Cenv, CL, n, Q4PaSurf",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB2-9","Critères d'application de la norme (8 critères listés dans le FD)",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"Analyse_resultats","index":5,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,0,9,0],[8,1,9,3],[8,4,9,6],[13,4,13,6],[16,4,16,6],[10,0,19,0],[27,4,27,6],[28,4,28,6],[10,4,10,6],[20,0,29,0],[20,4,20,6],[19,4,19,6],[26,4,26,6],[21,4,21,6],[24,4,24,6],[24,8,24,9],[25,4,25,6],[25,8,25,9],[26,8,26,9],[2,1,2,2],[20,1,29,3],[10,1,19,3],[12,8,12,9],[20,8,20,9],[18,4,18,6],[19,8,19,9],[29,4,29,6],[29,8,29,9],[27,8,27,9],[28,8,28,9],[20,7,29,7],[21,8,21,9],[22,4,22,6],[22,8,22,9],[23,4,23,6],[23,8,23,9],[8,7,9,7],[17,4,17,6],[8,8,9,10],[17,8,17,9],[18,8,18,9],[10,8,10,9],[13,8,13,9],[14,4,14,6],[14,8,14,9],[15,4,15,6],[15,8,15,9],[16,8,16,9],[10,7,19,7],[11,4,11,6],[11,8,11,9],[12,4,12,6]]}
["AB3- Analyse des résultats"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB3-1","Situation du Q4Pa-Surf mesuré par rapport aux objectifs (Le résultat inclut le cas échéant la ou les pénalité(s) prévue(s) par la RE2020. ",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB3-2","Diagnostic qualitatif de l'enveloppe. Références aux localisations des fuites principales du guide d'application (selon annexe C du FD)",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"Commentaires_generaux","index":6,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,8,9,10],[2,1,2,2],[8,0,9,0],[8,1,9,3],[8,4,9,6],[8,7,9,7],[10,0,19,0],[10,1,19,3],[10,4,10,6],[10,8,10,9],[17,4,17,6],[17,8,17,9],[18,4,18,6],[18,8,18,9],[19,4,19,6],[19,8,19,9],[10,7,19,7],[11,4,11,6],[11,8,11,9],[12,4,12,6],[12,8,12,9],[13,4,13,6],[20,1,29,3],[20,4,20,6],[20,8,20,9],[20,0,29,0],[27,4,27,6],[27,8,27,9],[28,4,28,6],[28,8,28,9],[29,4,29,6],[29,8,29,9],[26,8,26,9],[13,8,13,9],[14,4,14,6],[14,8,14,9],[15,4,15,6],[15,8,15,9],[16,4,16,6],[16,8,16,9],[20,7,29,7],[21,4,21,6],[21,8,21,9],[22,4,22,6],[22,8,22,9],[23,4,23,6],[23,8,23,9],[24,4,24,6],[24,8,24,9],[25,4,25,6],[25,8,25,9],[26,4,26,6]]}
["AB4- Commentaires généraux"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB4-1","Justificatifs du non-respect de la norme (le cas échéant)",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB4-2","Application d'une règle d'échantillonnage : justifications, bonne application et calcul de la perméabilité globale. Fournir un rapport de synthèse.\nPour les logements collectifs (cf §5.1.2.1.3 du FD P50-784) : \nPrésence de la liste des logements par étage et de leur shl ainsi que le choix retenu.\nLa valeur du résultat pondéré de la mesure de l’échantillon doit être présente.\nDans le cas de bâtiment dont la srt est inf/ou égale à 500 m2, le bâtiment est mesuré dans son ensemble ou la justification du choix de l’échantillonnage doit être clairement définie. \nPour les MIG (cf §5.1.2.1.2 du FD P50-784). : \nPrésence de la liste des maisons avec leur shm et le choix retenu.                                                            RE 2020 : mesure par échantillonnage le cas échéant : mention de la pénalité de 1,2.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"conditionnement","index":7,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[20,4,20,6],[29,4,29,6],[39,4,39,6],[16,4,16,6],[11,0,20,0],[21,0,30,0],[30,4,30,6],[33,4,33,6],[36,4,36,6],[9,0,10,0],[9,1,10,3],[2,1,2,2],[21,1,30,3],[11,1,20,3],[30,8,30,9],[9,7,10,7],[9,8,10,10],[18,4,18,6],[18,8,18,9],[19,4,19,6],[19,8,19,9],[20,8,20,9],[11,4,11,6],[11,8,11,9],[11,7,20,7],[12,4,12,6],[12,8,12,9],[13,4,13,6],[9,4,10,6],[21,4,21,6],[21,8,21,9],[28,4,28,6],[28,8,28,9],[29,8,29,9],[31,0,40,0],[39,8,39,9],[31,8,31,9],[38,8,38,9],[40,4,40,6],[40,8,40,9],[31,4,31,6],[31,1,40,3],[38,4,38,6],[31,7,40,7],[32,4,32,6],[32,8,32,9],[13,8,13,9],[14,4,14,6],[14,8,14,9],[15,4,15,6],[15,8,15,9],[16,8,16,9],[17,4,17,6],[17,8,17,9],[21,7,30,7],[22,4,22,6],[22,8,22,9],[23,4,23,6],[23,8,23,9],[24,4,24,6],[24,8,24,9],[25,4,25,6],[25,8,25,9],[26,4,26,6],[26,8,26,9],[27,4,27,6],[27,8,27,9],[36,8,36,9],[37,4,37,6],[37,8,37,9],[33,8,33,9],[34,4,34,6],[34,8,34,9],[35,4,35,6],[35,8,35,9]]}
["AB5- Etat des ouvertures de l'enveloppe pendant l'essai"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[]
[null,null,null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB5-1","Conditionnement du bâtiment détaillé (une colonne présentant l’état du bâtiment au moment de la mesure est présente, l’ensemble des points du tableau 2 du FD P50-784 doit être présent dans le rapport).",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB5-2","Explications sur l'obturation d'éléments sensibles (l’ensemble des points du tableau A.1 de l'annexe A du FD P50-784 doit être présent dans le rapport).",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB5-3","Cohérence de la méthode employée avec le moment du mesurage et le conditionnement du bâtiment \n\n",null,null,"Réserves",null,null,"5 rapports + registre des opérations","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"courbe_debits_fuite","index":8,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,2],[20,0,29,0],[10,0,19,0],[8,0,9,0],[8,4,9,6],[8,1,9,3],[10,1,19,3],[20,1,29,3],[29,4,29,6],[19,4,19,6],[13,4,13,6],[16,4,16,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[18,4,18,6],[29,8,29,9],[20,4,20,6],[20,8,20,9],[27,4,27,6],[27,8,27,9],[28,4,28,6],[28,8,28,9],[25,8,25,9],[26,8,26,9],[20,7,29,7],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,8,24,9],[8,7,9,7],[10,7,19,7],[11,4,11,6],[11,8,11,9],[12,4,12,6],[12,8,12,9],[10,4,10,6],[8,8,9,10],[10,8,10,9],[17,4,17,6],[17,8,17,9],[13,8,13,9],[14,4,14,6],[14,8,14,9],[15,4,15,6],[15,8,15,9],[16,8,16,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[19,8,19,9],[18,8,18,9]]}
["AB6- Courbes de débits de fuite"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB6-1","Graphe du débit de fuite d'air (bi-logarithmique, différence de pression en abscisse et débit en ordonnée)",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]
[]
[]
[]
[]
["AB6-2","Coefficient de détermination r² supérieur ou égal à 0,98 \nExplication en cas de coefficients de corrélation faible ou de points atypiques.\n",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"pressions_debit_nul","index":9,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,8,9,10],[2,1,2,2],[8,0,9,0],[8,1,9,3],[8,4,9,6],[8,7,9,7],[19,4,19,6],[19,8,19,9],[10,0,19,0],[10,1,19,3],[10,4,10,6],[10,8,10,9],[17,4,17,6],[17,8,17,9],[18,4,18,6],[18,8,18,9],[10,7,19,7],[11,4,11,6],[11,8,11,9],[12,4,12,6],[15,4,15,6],[15,8,15,9],[16,4,16,6],[16,8,16,9],[12,8,12,9],[13,4,13,6],[13,8,13,9],[14,4,14,6],[14,8,14,9]]}
["AB7- Pressions à débit nul"]
[]
[null,"Avis global"]
[null,"Conforme","¨"]
[null,"Non conforme","¨"]
[null,"Réserves","¨"]
[null,"Recommandations","¨"]
[]
[null,"Sous-critère",null,null,"Commentaires / recommandations éventuelles",null,null,"Documents consultés","Conformité"]
[]
["AB7","Ensemble des points mesurés nécessaires à la détermination des pressions à débit nul  Δp0,1+, Δp0,1-, Δp0,2+,Δp0,2-,Δp0,1, Δp0,2",null,null,"Réserves",null,null,"5 rapports","Conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Non conforme",null,"¨"]
[null,null,null,null,null,null,null,null,"Réserves",null,"¨"]
[null,null,null,null,null,null,null,null,"Recommandations",null,"¨"]
[]
[null,null,null,null,"Recommandation"]

{"sheet":"Photos","index":10,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Enregistrer dans cette feuille les photos pour illustrer les réserves"]

{"sheet":"modele","index":11,"n_rows":369,"n_cols":12,"rows_kept":369,"cut":false,"hidden":false,"merged":[[6,1,7,2],[6,3,7,5],[6,6,7,8],[6,9,7,11],[8,1,8,2],[8,3,8,8],[8,9,8,11],[1,1,1,11],[2,1,2,11],[5,1,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,11],[30,1,30,2],[31,1,31,11],[32,2,32,11],[33,2,33,11],[34,2,34,11],[9,1,9,2],[9,3,9,8],[9,9,9,11],[11,1,11,11],[13,1,13,11],[14,1,15,11],[16,1,17,11],[18,1,19,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[41,2,41,11],[42,2,42,11],[43,2,43,11],[44,2,44,11],[45,2,45,11],[46,2,46,11],[35,2,35,11],[36,2,36,11],[37,2,37,11],[38,2,38,11],[39,2,39,11],[40,2,40,11],[53,1,53,11],[54,2,54,11],[55,2,55,11],[56,2,56,11],[57,2,57,11],[58,2,58,11],[47,2,47,11],[48,2,48,11],[49,2,49,11],[50,2,50,11],[51,2,51,11],[52,1,52,11],[65,2,65,11],[66,2,66,11],[67,2,67,11],[68,2,68,11],[69,2,69,11],[70,2,70,11],[59,2,59,11],[60,2,60,11],[61,2,61,11],[62,2,62,11],[63,2,63,11],[64,2,64,11],[77,2,77,11],[78,2,78,11],[79,2,79,11],[80,2,80,11],[81,2,81,11],[82,2,82,11],[71,2,71,11],[72,2,72,11],[73,2,73,11],[74,2,74,11],[75,2,75,11],[76,2,76,11],[89,2,89,11],[90,2,90,11],[91,2,91,11],[92,2,92,11],[93,2,93,11],[94,2,94,11],[83,2,83,11],[84,2,84,11],[85,2,85,11],[86,2,86,11],[87,2,87,11],[88,2,88,11],[101,2,101,11],[102,2,102,11],[103,2,103,11],[104,2,104,11],[105,2,105,11],[106,2,106,11],[95,2,95,11],[96,2,96,11],[97,2,97,11],[98,2,98,11],[99,2,99,11],[100,2,100,11],[113,2,113,11],[114,1,114,11],[115,2,115,11],[116,2,116,11],[117,2,117,11],[118,2,118,11],[107,2,107,11],[108,2,108,11],[109,2,109,11],[110,2,110,11],[111,2,111,11],[112,2,112,11],[125,2,125,11],[126,2,126,11],[127,2,127,11],[128,2,128,11],[129,2,129,11],[130,2,130,11],[119,2,119,11],[120,2,120,11],[121,2,121,11],[122,2,122,11],[123,2,123,11],[124,2,124,11],[137,2,137,11],[138,2,138,11],[139,2,139,11],[140,2,140,11],[141,2,141,11],[142,2,142,11],[131,2,131,11],[132,2,132,11],[133,2,133,11],[134,2,134,11],[135,2,135,11],[136,2,136,11],[149,2,149,11],[150,2,150,11],[151,1,151,11],[152,2,152,11],[153,2,153,11],[154,2,154,11],[143,2,143,11],[144,2,144,11],[145,2,145,11],[146,2,146,11],[147,2,147,11],[148,2,148,11],[161,2,161,11],[162,2,162,11],[163,2,163,11],[164,2,164,11],[165,2,165,11],[166,2,166,11],[155,2,155,11],[156,2,156,11],[157,2,157,11],[158,2,158,11],[159,2,159,11],[160,1,160,11],[173,2,173,11],[174,2,174,11],[175,2,175,11],[176,2,176,11],[177,2,177,11],[178,2,178,11],[167,2,167,11],[168,2,168,11],[169,1,169,11],[170,2,170,11],[171,2,171,11],[172,2,172,11],[185,2,185,11],[186,2,186,11],[187,2,187,11],[188,2,188,11],[189,2,189,11],[190,2,190,11],[179,2,179,11],[180,2,180,11],[181,2,181,11],[182,1,182,11],[183,2,183,11],[184,2,184,11],[197,1,197,11],[198,2,198,11],[199,2,199,11],[200,2,200,11],[201,2,201,11],[202,2,202,11],[191,1,191,11],[192,2,192,11],[193,2,193,11],[194,2,194,11],[195,2,195,11],[196,1,196,11],[209,2,209,11],[210,2,210,11],[211,2,211,11],[212,2,212,11],[213,2,213,11],[214,2,214,11],[203,2,203,11],[204,2,204,11],[205,2,205,11],[206,2,206,11],[207,2,207,11],[208,2,208,11],[221,2,221,11],[222,2,222,11],[223,2,223,11],[224,2,224,11],[225,2,225,11],[226,2,226,11],[215,2,215,11],[216,2,216,11],[217,2,217,11],[218,1,218,11],[219,1,219,11],[220,2,220,11],[233,2,233,11],[234,2,234,11],[235,2,235,11],[236,2,236,11],[237,2,237,11],[238,2,238,11],[227,2,227,11],[228,2,228,11],[229,2,229,11],[230,2,230,11],[231,2,231,11],[232,2,232,11],[245,2,245,11],[246,2,246,11],[247,2,247,11],[248,2,248,11],[249,2,249,11],[250,2,250,11],[239,2,239,11],[240,2,240,11],[241,2,241,11],[242,2,242,11],[243,2,243,11],[244,2,244,11],[257,2,257,11],[258,2,258,11],[259,2,259,11],[260,2,260,11],[261,2,261,11],[262,2,262,11],[251,2,251,11],[252,2,252,11],[253,2,253,11],[254,2,254,11],[255,2,255,11],[256,2,256,11],[269,2,269,11],[270,2,270,11],[271,2,271,11],[272,2,272,11],[273,2,273,11],[274,2,274,11],[263,2,263,11],[264,2,264,11],[265,2,265,11],[266,2,266,11],[267,2,267,11],[268,2,268,11],[281,2,281,11],[282,2,282,11],[283,2,283,11],[284,2,284,11],[285,2,285,11],[286,2,286,11],[275,2,275,11],[276,2,276,11],[277,2,277,11],[278,2,278,11],[279,2,279,11],[280,1,280,11],[293,2,293,11],[294,2,294,11],[295,2,295,11],[296,2,296,11],[297,2,297,11],[298,2,298,11],[287,2,287,11],[288,2,288,11],[289,2,289,11],[290,2,290,11],[291,2,291,11],[292,2,292,11],[305,2,305,11],[306,2,306,11],[307,2,307,11],[308,2,308,11],[309,2,309,11],[310,2,310,11],[299,2,299,11],[300,2,300,11],[301,2,301,11],[302,2,302,11],[303,2,303,11],[304,2,304,11],[317,1,317,11],[318,2,318,11],[319,2,319,11],[320,2,320,11],[321,2,321,11],[322,2,322,11],[311,2,311,11],[312,2,312,11],[313,2,313,11],[314,2,314,11],[315,2,315,11],[316,2,316,11],[329,2,329,11],[330,2,330,11],[331,2,331,11],[332,2,332,11],[333,2,333,11],[334,2,334,11],[323,2,323,11],[324,2,324,11],[325,2,325,11],[326,1,326,11],[327,2,327,11],[328,2,328,11],[341,2,341,11],[342,2,342,11],[343,2,343,11],[344,2,344,11],[345,2,345,11],[346,2,346,11],[335,1,335,11],[336,2,336,11],[337,2,337,11],[338,2,338,11],[339,2,339,11],[340,2,340,11],[353,2,353,11],[354,2,354,11],[355,2,355,11],[356,2,356,11],[357,1,357,11],[358,2,358,11],[347,2,347,11],[348,1,348,11],[349,2,349,11],[350,2,350,11],[351,2,351,11],[352,2,352,11],[366,1,366,2],[367,1,367,2],[368,1,368,2],[359,2,359,11],[360,2,360,11],[361,2,361,11],[363,1,363,2],[364,1,364,2],[365,1,365,2]]}
[]
[null,"Autorisation à réaliser des essais de perméabilité à l’air sur l'enveloppe des bâtiments"]
[null,"Grille d’évaluation des dossiers"]
[]
[]
[null,"Dossier n°",null,"Société",null,null,"Nom du demandeur",null,null,"Date de soumission du dossier de suivi"]
[]
[]
[null,"Identification de l’expert ",null,"Ordre de mission",null,null,null,null,null,"Date d’instruction du dossier "]
[]
[]
[null,"Avis détaillé sur le dossier"]
[]
[null,"Dossiers examinés (liste des rapports examinés et leur référence)"]
[null,"Passage n°1:"]
[]
[null,"Passage n°2:"]
[]
[null,"Passage n°3:"]
[]
[null,"Conclusion"]
[null,"Conclusion n°1:"]
[null,"Coclusion n°2:"]
[null,"Coclusion n°3:"]
[null,null,"Dossier devant être accepté"]
[null,null,"Oui",null,null,"¨"]
[null,null,"Oui, avec des recommandations",null,null,"¨"]
[null,null,"Demande de lever des réserves",null,null,"¨"]
[null,null,"Non",null,null,"¨"]
[]
[null,"Réserves"]
[null,{"$f":"+Complétude_du_dossier!B1","v":"AA . Complétude du dossier"}]
[null,"AA.1"]
[]
[]
[]
[null,"AA.2"]
[]
[]
[]
[null,"AA.3"]
[]
[]
[]
[null,"AA.4"]
[]
[]
[]
[null,"AA.5"]
[]
[]
[]
[null,{"$f":"+Informations_sur_le_bâtiment!A1","v":"AB . Examen des rapports conformes à NF EN ISO 9972 et au FD P50-784"}]
[null,{"$f":"+Informations_sur_le_bâtiment!A4","v":"AB1-Informations sur le bâtiment"}]
[null,"AB1-1"]
[]
[]
[]
[null,"AB1-2"]
[]
[]
[]
[null,"AB1-3"]
[]
[]
[]
[null,"AB1-4"]
[]
[]
[]
[null,"AB1-5"]
[]
[]
[]
[null,"AB1-6"]
[]
[]
[]
[null,"AB1-7"]
[]
[]
[]
[null,"AB1-8"]
[]
[]
[]
[null,"AB1-9"]
[]
[]
[]
[null,"AB1-10"]
[]
[]
[]
[null,"AB1-11"]
[]
[]
[]
[null,"AB1-12"]
[]
[]
[]
[null,"AB1-13"]
[]
[]
[]
[null,"AB1-14"]
[]
[]
[]
[null,"AB1-15"]
[]
[]
[]
[null,{"$f":"+Essai_selon_norme_guide!A1","v":"AB2- Essai selon la norme NF EN ISO 9972 et le FD P50-784"}]
[null,"AB2-1"]
[]
[]
[]
[null,"AB2-2"]
[]
[]
[]
[null,"AB2-3"]
[]
[]
[]
[null,"AB2-4"]
[]
[]
[]
[null,"AB2-5"]
[]
[]
[]
[null,"AB2-6"]
[]
[]
[]
[null,"AB2-7"]
[]
[]
[]
[null,"AB2-8"]
[]
[]
[]
[null,"AB2-9"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"AB3- Analyse des résultats"}]
[null,"AB3-1"]
[]
[]
[]
[null,"AB3-2"]
[]
[]
[]
[null,{"$f":"+Commentaires_generaux!A1","v":"AB4- Commentaires généraux"}]
[null,"AB4-1"]
[]
[]
[]
[null,"AB4-2"]
[]
[]
[]
[null,{"$f":"+conditionnement!A1","v":"AB5- Etat des ouvertures de l'enveloppe pendant l'essai"}]
[null,"AB5-1"]
[]
[]
[]
[null,"AB5-2"]
[]
[]
[]
[null,"AB5-3"]
[]
[]
[]
[null,{"$f":"+courbe_debits_fuite!A1","v":"AB6- Courbes de débits de fuite"}]
[null,"AB6-1"]
[]
[]
[]
[null,"AB6-2"]
[]
[]
[]
[null,{"$f":"+pressions_debit_nul!A1","v":"AB7- Pressions à débit nul"}]
[null,"AB7"]
[]
[]
[]
[null,"Recommandations"]
[null,{"$f":"+B32","v":"AA . Complétude du dossier"}]
[null,"AA.1"]
[]
[]
[]
[null,"AA.2"]
[]
[]
[]
[null,"AA.3"]
[]
[]
[]
[null,"AA.4"]
[]
[]
[]
[null,"AA.5"]
[]
[]
[]
[null,{"$f":"+Informations_sur_le_bâtiment!A1","v":"AB . Examen des rapports conformes à NF EN ISO 9972 et au FD P50-784"}]
[null,{"$f":"+Informations_sur_le_bâtiment!A4","v":"AB1-Informations sur le bâtiment"}]
[null,"AB1-1"]
[]
[]
[]
[null,"AB1-2"]
[]
[]
[]
[null,"AB1-3"]
[]
[]
[]
[null,"AB1-4"]
[]
[]
[]
[null,"AB1-5"]
[]
[]
[]
[null,"AB1-6"]
[]
[]
[]
[null,"AB1-7"]
[]
[]
[]
[null,"AB1-8"]
[]
[]
[]
[null,"AB1-9"]
[]
[]
[]
[null,"AB1-10"]
[]
[]
[]
[null,"AB1-11"]
[]
[]
[]
[null,"AB1-12"]
[]
[]
[]
[null,"AB1-13"]
[]
[]
[]
[null,"AB1-14"]
[]
[]
[]
[null,"AB1-15"]
[]
[]
[]
[null,{"$f":"+Essai_selon_norme_guide!A1","v":"AB2- Essai selon la norme NF EN ISO 9972 et le FD P50-784"},"\n"]
[null,"AB2-1"]
[]
[]
[]
[null,"AB2-2"]
[]
[]
[]
[null,"AB2-3"]
[]
[]
[]
[null,"AB2-4"]
[]
[]
[]
[null,"AB2-5"]
[]
[]
[]
[null,"AB2-6"]
[]
[]
[]
[null,"AB2-7"]
[]
[]
[]
[null,"AB2-8"]
[]
[]
[]
[null,"AB2-9"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"AB3- Analyse des résultats"}]
[null,"AB3-1"]
[]
[]
[]
[null,"AB3-2"]
[]
[]
[]
[null,{"$f":"+Commentaires_generaux!A1","v":"AB4- Commentaires généraux"}]
[null,"AB4-1"]
[]
[]
[]
[null,"AB4-2"]
[]
[]
[]
[null,{"$f":"+conditionnement!A1","v":"AB5- Etat des ouvertures de l'enveloppe pendant l'essai"}]
[null,"AB5-1"]
[]
[]
[]
[null,"AB5-2"]
[]
[]
[]
[null,"AB5-3"]
[]
[]
[]
[null,{"$f":"+courbe_debits_fuite!A1","v":"AB6- Courbes de débits de fuite"}]
[null,"AB6-1"]
[]
[]
[]
[null,"AB6-2"]
[]
[]
[]
[null,{"$f":"+pressions_debit_nul!A1","v":"AB7- Pressions à débit nul"}]
[null,"AB7"]
[]
[]
[]
[null,null,"\n"]
[null,"\n",null,"Complétude du dossier","Examen des rapports"]
[null,"Critère",null,null,"Information sur le bâtiment","Essai selon la norme","Analyses  des résultats","Commentaires généraux","Etat des ouvertures de l'enveloppe","Courbes des débits de fuite","Pressions à débit nul","Global"]
[null,"Conforme",null,{"$f":"+Complétude_du_dossier!C4","v":"¨"},{"$f":"+Informations_sur_le_bâtiment!C7","v":"¨"},{"$f":"+Essai_selon_norme_guide!C4","v":"¨"},{"$f":"+Analyse_resultats!C4","v":"¨"},"¨",{"$f":"+conditionnement!C4","v":"¨"},"¨","¨","¨"]
[null,"Non conforme",null,{"$f":"+Complétude_du_dossier!C5","v":"¨"},{"$f":"+Informations_sur_le_bâtiment!C8","v":"¨"},{"$f":"+Essai_selon_norme_guide!C5","v":"¨"},{"$f":"+Analyse_resultats!C5","v":"¨"},{"$f":"+Commentaires_generaux!C5","v":"¨"},{"$f":"+conditionnement!C5","v":"¨"},{"$f":"+courbe_debits_fuite!C5","v":"¨"},{"$f":"+pressions_debit_nul!C5","v":"¨"},"¨"]
[null,"Réserves",null,"¨","¨","¨","¨",{"$f":"+Commentaires_generaux!C6","v":"¨"},"¨",{"$f":"+courbe_debits_fuite!C6","v":"¨"},{"$f":"+pressions_debit_nul!C6","v":"¨"},"¨"]
[null,"Recommandations",null,"¨","¨",{"$f":"+Essai_selon_norme_guide!C7","v":"¨"},{"$f":"+Analyse_resultats!C7","v":"¨"},{"$f":"+Commentaires_generaux!C7","v":"¨"},{"$f":"+conditionnement!C7","v":"¨"},{"$f":"+courbe_debits_fuite!C7","v":"¨"},{"$f":"+pressions_debit_nul!C7","v":"¨"},"¨"]

{"sheet":"ValidationCase","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"¨"]
[null,"x"]