{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Lisez_moi","Conclusion_globale","Complétude_du_dossier","Objet_essai","Informations_generales","Essai_permeabilite","Analyse_resultats","Photos","modele","ValidationCase"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":27,"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":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Règles d'utillisation du document"]
[]
["Version 0",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\" (ligne avec vert clair en cpuleur de fond)"]
["inscrire les différentes recommandations sous la première ligne après le titre \"Recommandation\"  (ligne avec vert clair en cpuleur de fond)"]
[]
["ne pas écrire \"uniquement\" le mot Réserves ou Recommandation dans une autre case des colonnes EFG dans les différents onglets."]
[]
["un onglet \"photos\" a été ajouté pour illustrer éventuellement des réserves"]
[]
["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."]
[]
["2021-10-28","Correction coquille dans le titre \"réseaux aérauliques\" au lieu de \"enveloppe des bâtiments\""]

{"sheet":"Conclusion_globale","index":1,"n_rows":263,"n_cols":10,"rows_kept":263,"cut":false,"hidden":false,"merged":[[260,1,260,2],[261,1,261,2],[262,1,262,2],[253,2,253,11],[254,2,254,11],[255,2,255,11],[257,1,257,2],[258,1,258,2],[259,1,259,2],[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,1,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,2,218,11],[219,2,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,2,196,11],[197,2,197,11],[198,2,198,11],[187,2,187,11],[188,2,188,11],[189,2,189,11],[190,2,190,11],[191,2,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,2,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,2,160,11],[161,2,161,11],[162,1,162,11],[151,2,151,11],[152,2,152,11],[153,1,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,1,143,11],[144,1,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,1,110,11],[111,2,111,11],[112,2,112,11],[113,2,113,11],[114,2,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,1,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,1,49,11],[50,2,50,11],[51,2,51,11],[52,2,52,11],[53,2,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,1,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 des réseaux aérauliques"]
[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 1: "]
[]
[null,"Passage 2:  "]
[]
[null,"Passage 3:  "]
[]
[null,"Conclusion"]
[null,"Conclusion 1:"]
[null,"Conclusion 2:"]
[null,"Conclusion 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":"A . Complétude du dossier"}]
[null,"A1"]
[]
[]
[]
[null,"A2"]
[]
[]
[]
[null,{"$f":"+Objet_essai!A1","v":"B . Objet de l'essai"}]
[null,"B1"]
[]
[]
[]
[null,"B2"]
[]
[]
[]
[null,"C. Informations générales"]
[null,"C1"]
[]
[]
[null,"C2"]
[]
[]
[]
[null,"C3"]
[]
[]
[]
[null,"C4"]
[]
[]
[]
[null,"C5"]
[]
[]
[]
[null,{"$f":"+Essai_permeabilite!A1","v":"D. Essai de perméabilité"}]
[null,"D1"]
[]
[]
[]
[null,"D2"]
[]
[]
[]
[null,"D3"]
[]
[]
[]
[null,"D4"]
[]
[]
[]
[null,"D5"]
[]
[]
[]
[null,"D6"]
[]
[]
[]
[null,"D7"]
[]
[]
[]
[null,"D8"]
[]
[]
[]
[null,"D9"]
[]
[]
[]
[null,"D10"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"E. Analyse des résultats"}]
[null,"E1"]
[]
[]
[]
[null,"E2"]
[]
[]
[]
[null,"E3"]
[]
[]
[]
[null,"E4"]
[]
[]
[]
[null,"E5"]
[]
[]
[]
[null,"E6"]
[]
[]
[]
[null,"E7"]
[]
[]
[]
[null,"E8"]
[]
[]
[]
[null,"Recommandations"]
[null,{"$f":"+B32","v":"A . Complétude du dossier"}]
[null,"A1"]
[]
[]
[]
[null,"A2"]
[]
[]
[]
[null,"B. Objet de l'essai"]
[null,"B1"]
[]
[]
[]
[null,"B2"]
[]
[]
[]
[null,"C. Informations générales"]
[null,"C1"]
[]
[]
[null,"C2"]
[]
[]
[]
[null,"C3"]
[]
[]
[]
[null,"C4"]
[]
[]
[]
[null,"C5"]
[]
[]
[]
[null,"D. Essai_permeabilite"]
[null,"D1"]
[]
[]
[]
[null,"D2"]
[]
[]
[]
[null,"D3"]
[]
[]
[]
[null,"D4"]
[]
[]
[]
[null,"D5"]
[]
[]
[]
[null,"D6"]
[]
[]
[]
[null,"D7"]
[]
[]
[]
[null,"D8"]
[]
[]
[]
[null,"D9"]
[]
[]
[]
[null,"D10"]
[]
[]
[]
[null,"E. Analyse des resultats"]
[null,"E1"]
[]
[]
[]
[null,"E2"]
[]
[]
[]
[null,"E3"]
[]
[]
[]
[null,"E4"]
[]
[]
[]
[null,"E5"]
[]
[]
[]
[null,"E6"]
[]
[]
[]
[null,"E7"]
[]
[]
[]
[null,"E8"]
[]
[]
[]
[null,null,"\n"]
[null,"\n",null,"Complétude du dossier","Examen des rapports"]
[null,"Critère",null,"Complétude du dossier","Objet de l'essai","Information générales","Essai perméabilité","Analyse des resultats","Global"]
[null,"Conforme",null,"¨","¨","¨","¨","¨","¨"]
[null,"Non conforme",null,"¨","¨","¨","¨","¨","¨"]
[null,"Réserves",null,"¨","¨","¨","¨","¨","¨"]
[null,"Recommandations",null,"¨","¨","¨","¨","¨","¨"]

{"sheet":"Complétude_du_dossier","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,8,10,10],[29,8,29,9],[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],[20,8,20,9],[21,8,21,9],[23,8,23,9],[24,8,24,9],[28,8,28,9],[26,8,26,9],[27,8,27,9],[25,8,25,9],[2,1,2,2],[11,7,20,7],[21,7,30,7],[11,4,11,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[29,4,29,6],[30,4,30,6],[26,4,26,6],[27,4,27,6],[9,7,10,7],[11,1,20,3],[19,8,19,9],[30,8,30,9],[21,1,30,3],[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]]}
[null,"A . 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é"]
[]
["A1","Rapports conformes aux attentes (Postérieurs à la validation de la formation, faits en autonomie, mesures sur 5 opérations différentes\nMesures faites avec du matériel étalonné)\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["A2","Registre des opérations : au moins 10 mesures sur 10 opérations différentes (Numéros de PC différents)",null,null,"Réserves",null,null,null,"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":"Objet_essai","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,0,29,0],[20,1,29,3],[21,4,21,6],[21,8,21,9],[22,4,22,6],[22,8,22,9],[23,4,23,6],[23,8,23,9],[25,4,25,6],[27,4,27,6],[28,4,28,6],[26,4,26,6],[20,4,20,6],[24,4,24,6],[29,4,29,6],[29,8,29,9],[8,7,9,7],[2,1,2,2],[8,0,9,0],[10,1,19,3],[8,1,9,3],[10,0,19,0],[11,4,11,6],[12,4,12,6],[8,4,9,6],[10,4,10,6],[13,4,13,6],[14,4,14,6],[18,4,18,6],[19,4,19,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[20,8,20,9],[25,8,25,9],[27,8,27,9],[26,8,26,9],[10,7,19,7],[20,7,29,7],[10,8,10,9],[13,8,13,9],[11,8,11,9],[12,8,12,9],[15,8,15,9],[28,8,28,9],[16,8,16,9],[17,8,17,9],[8,8,9,10],[14,8,14,9],[19,8,19,9],[18,8,18,9],[24,8,24,9]]}
["B . Objet de l'essai"]
[]
[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é"]
[]
["B1","Justification de l'objet de l'essai (détermination de la classe, recherche de fuites)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["B2","Objectif chiffré (détermination de la classe recherchée)",null,null,"Réserves",null,null,null,"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_generales","index":4,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,4,55,6],[55,8,55,9],[56,4,56,6],[56,8,56,9],[57,4,57,6],[57,8,57,9],[50,0,59,0],[50,1,59,3],[50,4,50,6],[50,7,59,7],[50,8,50,9],[51,4,51,6],[58,4,58,6],[58,8,58,9],[59,4,59,6],[59,8,59,9],[51,8,51,9],[52,4,52,6],[52,8,52,9],[53,4,53,6],[53,8,53,9],[54,4,54,6],[54,8,54,9],[48,4,48,6],[48,8,48,9],[49,4,49,6],[49,8,49,9],[40,0,49,0],[40,1,49,3],[40,4,40,6],[40,7,49,7],[40,8,40,9],[44,13,44,15],[44,17,44,18],[45,4,45,6],[40,17,40,18],[41,4,41,6],[41,8,41,9],[41,13,41,15],[41,17,41,18],[42,4,42,6],[42,8,42,9],[42,13,42,15],[42,17,42,18],[38,13,38,15],[38,16,47,16],[40,13,40,15],[43,4,43,6],[43,8,43,9],[43,13,43,15],[38,17,38,18],[39,4,39,6],[39,8,39,9],[39,13,39,15],[39,17,39,18],[45,8,45,9],[45,13,45,15],[45,17,45,18],[46,4,46,6],[46,8,46,9],[46,13,46,15],[46,17,46,18],[47,4,47,6],[47,8,47,9],[47,13,47,15],[47,17,47,18],[43,17,43,18],[44,4,44,6],[30,1,39,3],[30,4,30,6],[30,7,39,7],[30,8,30,9],[31,4,31,6],[31,8,31,9],[32,4,32,6],[32,8,32,9],[33,4,33,6],[33,8,33,9],[37,4,37,6],[37,8,37,9],[38,4,38,6],[38,8,38,9],[25,4,25,6],[25,8,25,9],[26,4,26,6],[26,8,26,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],[14,8,14,9],[15,4,15,6],[15,8,15,9],[16,4,16,6],[16,8,16,9],[20,0,29,0],[20,1,29,3],[20,4,20,6],[20,7,29,7],[20,8,20,9],[21,4,21,6],[21,8,21,9],[22,4,22,6],[22,8,22,9],[23,4,23,6],[27,4,27,6],[27,8,27,9],[28,4,28,6],[28,8,28,9],[29,4,29,6],[29,8,29,9],[23,8,23,9],[24,4,24,6],[24,8,24,9],[2,1,2,2],[8,0,9,0],[8,1,9,3],[8,4,9,6],[8,7,9,7],[8,8,9,10],[10,0,19,0],[10,1,19,3],[10,4,10,6],[10,7,19,7],[10,8,10,9],[11,4,11,6],[11,8,11,9],[12,4,12,6],[12,8,12,9],[13,4,13,6],[17,4,17,6],[17,8,17,9],[18,4,18,6],[18,8,18,9],[19,4,19,6],[19,8,19,9],[13,8,13,9],[14,4,14,6]]}
["C. Informations générales"]
[]
[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é"]
[]
["C1","Informations sur le projet Contexte de l’essai (combien de bâtiments, de MI, combien de réseaux, combien de machines….) et préciser les différentes classes des réseaux\n\nAfficher le protocole en vigueur utilisé\nInformations sur le bâtiment\n(identité, adresse, année de construction ou réhabilitation, n° permis de construire avec mention de groupement si nécessaire, type de bâtiment, certification et marque de qualité \n\nInformations sur le(s) réseau(x) composant le bâtiment\n(description, classe attendue pour chaque partie du réseau)\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["C2","Informations sur le client (société, adresse complète, téléphone, mail, rôle et fonction dans l’opération)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["C3","Informations sur l'occupant (Nom et adresse complète) demandé dans le FD – Mettre en recommandation si pas présent\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["C4","Informations sur la société réalisant le test (société, adresse complète, tél., mail, nom du mesureur)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["C5","Informations sur le matériel utilisé (désignation, fabricant, type, n° de série et date de fin de validité de l’étalonnage +  exactitude du débit de fuite)",null,null,"Réserves",null,null,null,"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_permeabilite","index":5,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[100,0,109,0],[100,1,109,3],[100,4,100,6],[100,7,109,7],[100,8,100,9],[101,4,101,6],[101,8,101,9],[102,4,102,6],[102,8,102,9],[103,4,103,6],[103,8,103,9],[104,4,104,6],[104,8,104,9],[105,4,105,6],[105,8,105,9],[106,4,106,6],[106,8,106,9],[107,4,107,6],[107,8,107,9],[108,4,108,6],[108,8,108,9],[109,4,109,6],[109,8,109,9],[66,8,66,9],[70,4,70,6],[77,4,77,6],[80,4,80,6],[89,4,89,6],[90,1,99,3],[91,4,91,6],[96,4,96,6],[97,4,97,6],[78,4,78,6],[78,8,78,9],[79,4,79,6],[79,8,79,9],[74,8,74,9],[75,4,75,6],[75,8,75,9],[76,4,76,6],[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],[2,1,2,2],[59,4,59,6],[40,4,40,6],[29,4,29,6],[44,4,44,6],[55,4,55,6],[37,4,37,6],[30,4,30,6],[77,8,77,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],[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],[30,0,39,0],[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],[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],[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],[63,8,63,9],[64,4,64,6],[64,8,64,9],[65,4,65,6],[65,8,65,9],[66,4,66,6],[30,8,30,9],[56,8,56,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],[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],[93,4,93,6],[93,8,93,9],[94,4,94,6],[94,8,94,9],[95,4,95,6],[95,8,95,9],[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],[60,4,60,6],[60,7,69,7],[61,4,61,6],[61,8,61,9],[62,4,62,6],[62,8,62,9],[63,4,63,6]]}
["D. Essai de perméabilité"]
[]
[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é"]
[]
["D1","Références normatives (exigences référentiel Qualibat 8721) et préciser les documents normatifs utilisés et vérifier la cohérence avec l’essai",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D2","Date de l'essai et nature du contrôle (1er contrôle ou contrôle suite à une non-conformité et dans ce cas associer le rapport correspondant au(x) contrôle(s) antérieur(s).",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D3","Témoin(s) de l'essai (nom et qualité)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D4","Moment du mesurage (existant, en cours de chantier ou à réception)\nSi en chantier précisez où en est la mise en œuvre du réseau)\nNota : si mesure en phase chantier, mentionner dans le rapport que la classe calculée ne peut pas être attribuée au réseau complet.\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D5","Description précise de l'emplacement du matériel de mesure (respecter le critère de distance minimale Distance > 4 Dr)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D6","Conditions de réalisation de l'essai (surpression, dépression)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D7","Conditions météorologiques pendant le test (température, pression atmosphérique - justifier les valeurs)\n+ Altitude du lieu mesuré\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D8","Description du réseau ou de la partie du réseau mesurée (désignation, type, nature et isolation des conduits, type de terminaux, fabricant et installateur, type d’assemblage et dimensions)",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D9","Aire de surfaces de conduits et toutes les justifications nécessaires (Aj, L, surface habitable, débits maximum prévu par Eth, plan et calculs détaillés)\n\n- Si système desservant un seul logement : 100% du réseau est mesuré\n- Si système desservant plusieurs logements : totalité du réseau mesuré ou respect du critère de variété représentative du réseau mesuré.\n\nJustification du réseau testé\n\nCoefficient de pénalité du débit de fuite\n",null,null,"Réserves",null,null,null,"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"]
[]
[]
[]
[]
["D10","Conditionnement du réseau pour l'essai (descriptif des éléments oburés)",null,null,"Réserves",null,null,null,"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":6,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[79,8,79,9],[80,0,89,0],[80,1,89,3],[80,4,80,6],[80,7,89,7],[80,8,80,9],[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],[87,4,87,6],[87,8,87,9],[88,4,88,6],[88,8,88,9],[89,4,89,6],[89,8,89,9],[84,8,84,9],[85,4,85,6],[85,8,85,9],[86,4,86,6],[86,8,86,9],[75,8,75,9],[76,4,76,6],[76,8,76,9],[77,4,77,6],[77,8,77,9],[69,4,69,6],[69,8,69,9],[70,0,79,0],[70,1,79,3],[70,4,70,6],[70,7,79,7],[70,8,70,9],[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],[78,4,78,6],[78,8,78,9],[79,4,79,6],[66,8,66,9],[67,4,67,6],[67,8,67,9],[68,4,68,6],[68,8,68,9],[60,0,69,0],[60,1,69,3],[60,4,60,6],[60,7,69,7],[60,8,60,9],[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],[49,8,49,9],[50,0,59,0],[50,1,59,3],[50,4,50,6],[50,7,59,7],[50,8,50,9],[51,4,51,6],[51,8,51,9],[52,4,52,6],[52,8,52,9],[53,4,53,6],[53,8,53,9],[54,4,54,6],[57,4,57,6],[57,8,57,9],[58,4,58,6],[58,8,58,9],[59,4,59,6],[59,8,59,9],[54,8,54,9],[55,4,55,6],[55,8,55,9],[56,4,56,6],[56,8,56,9],[45,8,45,9],[46,4,46,6],[46,8,46,9],[47,4,47,6],[47,8,47,9],[39,4,39,6],[39,8,39,9],[40,0,49,0],[40,1,49,3],[40,4,40,6],[40,7,49,7],[40,8,40,9],[41,4,41,6],[41,8,41,9],[42,4,42,6],[42,8,42,9],[43,4,43,6],[43,8,43,9],[44,4,44,6],[44,8,44,9],[45,4,45,6],[48,4,48,6],[48,8,48,9],[49,4,49,6],[36,8,36,9],[37,4,37,6],[37,8,37,9],[38,4,38,6],[38,8,38,9],[30,0,39,0],[30,1,39,3],[30,4,30,6],[30,7,39,7],[30,8,30,9],[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],[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]]}
["E. 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é"]
[]
["E1","Situation de la valeur mesurée par rapport aux objectifs et aux classes d’étanchéité des réseaux (graphique)",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"]
[]
[]
[]
[]
["E2","Pression de références, pression d’essai et/ou pression de conception",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"]
[]
[]
[]
[]
["E3","Temps de pressurisation",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"]
[]
[]
[]
[]
["E4","Débit moyen mesuré et corrigé\n(corrigé si mesure débit volumique)\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"]
[]
[]
[]
[]
["E5","Coefficient d’étanchéité f\nVérifier le respect de l’unité\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"]
[]
[]
[]
[]
["E6","Classe d’étanchéité du réseau mesuré ainsi que la limite d’étanchéité fmax spécifiée dans le FD E51-767\n(classes données avec la ou les pression(s) d’essai correspondante(s))\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"]
[]
[]
[]
[]
["E7","Localisation des fuites et description\nSi possible selon le réseau\nObligation de préciser si la détection de fuites est possible ou pas\nLa recherche n’est pas faisable quand le réseau est déjà cloisonné.\nElle est recommandée si la mesure est faite en cours de chantier.\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"]
[]
[]
[]
[]
["E8","Commentaires généraux\n(justification du non-respect de la norme et informations supplémentaires)\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":"Photos","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Enregistrer dans cette feuille les photos pour illustrer éventuellement les réserves"]

{"sheet":"modele","index":8,"n_rows":263,"n_cols":10,"rows_kept":263,"cut":false,"hidden":false,"merged":[[16,1,17,11],[18,1,19,11],[21,1,21,11],[22,1,22,11],[23,1,23,11],[257,1,257,2],[258,1,258,2],[259,1,259,2],[260,1,260,2],[36,2,36,11],[37,2,37,11],[38,2,38,11],[39,2,39,11],[41,2,41,11],[42,2,42,11],[34,2,34,11],[43,2,43,11],[44,2,44,11],[45,2,45,11],[40,1,40,11],[52,2,52,11],[53,2,53,11],[54,2,54,11],[55,2,55,11],[261,1,261,2],[262,1,262,2],[174,2,174,11],[175,2,175,11],[176,2,176,11],[177,2,177,11],[183,2,183,11],[184,2,184,11],[185,2,185,11],[186,2,186,11],[187,2,187,11],[188,2,188,11],[198,2,198,11],[199,2,199,11],[200,2,200,11],[207,2,207,11],[208,2,208,11],[209,2,209,11],[210,2,210,11],[211,2,211,11],[213,2,213,11],[214,2,214,11],[215,2,215,11],[216,2,216,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],[13,1,13,11],[35,2,35,11],[9,1,9,2],[9,3,9,8],[9,9,9,11],[11,1,11,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],[14,1,15,11],[30,1,30,2],[31,1,31,11],[32,2,32,11],[33,2,33,11],[56,2,56,11],[57,2,57,11],[46,2,46,11],[47,2,47,11],[48,2,48,11],[50,2,50,11],[51,2,51,11],[49,1,49,11],[68,2,68,11],[58,2,58,11],[59,2,59,11],[60,2,60,11],[65,2,65,11],[66,2,66,11],[67,2,67,11],[61,2,61,11],[62,2,62,11],[63,2,63,11],[64,2,64,11],[69,1,69,11],[70,2,70,11],[71,2,71,11],[72,2,72,11],[73,2,73,11],[106,2,106,11],[107,2,107,11],[108,2,108,11],[109,2,109,11],[80,2,80,11],[81,2,81,11],[82,2,82,11],[83,2,83,11],[84,2,84,11],[85,2,85,11],[74,2,74,11],[75,2,75,11],[76,2,76,11],[77,2,77,11],[78,2,78,11],[79,2,79,11],[92,2,92,11],[93,2,93,11],[94,2,94,11],[95,2,95,11],[96,2,96,11],[97,2,97,11],[86,2,86,11],[87,2,87,11],[88,2,88,11],[89,2,89,11],[90,2,90,11],[91,2,91,11],[104,2,104,11],[105,2,105,11],[110,1,110,11],[111,2,111,11],[112,2,112,11],[113,2,113,11],[98,2,98,11],[99,2,99,11],[100,2,100,11],[101,2,101,11],[102,2,102,11],[103,2,103,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],[114,2,114,11],[115,2,115,11],[116,2,116,11],[117,2,117,11],[118,2,118,11],[130,2,130,11],[131,2,131,11],[132,2,132,11],[133,2,133,11],[134,2,134,11],[135,2,135,11],[125,2,125,11],[126,2,126,11],[127,2,127,11],[128,2,128,11],[129,2,129,11],[141,2,141,11],[142,2,142,11],[136,2,136,11],[137,2,137,11],[138,2,138,11],[139,2,139,11],[140,2,140,11],[144,1,144,11],[145,2,145,11],[146,2,146,11],[147,2,147,11],[148,2,148,11],[143,1,143,11],[155,2,155,11],[156,2,156,11],[157,2,157,11],[158,2,158,11],[159,2,159,11],[160,2,160,11],[149,2,149,11],[150,2,150,11],[151,2,151,11],[152,2,152,11],[154,2,154,11],[153,1,153,11],[167,2,167,11],[168,2,168,11],[169,2,169,11],[170,2,170,11],[171,2,171,11],[172,2,172,11],[161,2,161,11],[163,2,163,11],[166,2,166,11],[162,1,162,11],[164,2,164,11],[165,2,165,11],[173,2,173,11],[178,2,178,11],[179,2,179,11],[180,2,180,11],[181,2,181,11],[182,1,182,11],[195,2,195,11],[196,2,196,11],[197,2,197,11],[189,2,189,11],[190,2,190,11],[191,2,191,11],[192,2,192,11],[193,2,193,11],[194,2,194,11],[217,2,217,11],[218,2,218,11],[223,1,223,11],[212,2,212,11],[201,2,201,11],[202,2,202,11],[203,2,203,11],[204,2,204,11],[205,2,205,11],[206,2,206,11],[219,2,219,11],[220,2,220,11],[225,2,225,11],[226,2,226,11],[227,2,227,11],[228,2,228,11],[229,2,229,11],[230,2,230,11],[221,2,221,11],[222,2,222,11],[224,2,224,11],[237,2,237,11],[238,2,238,11],[239,2,239,11],[240,2,240,11],[241,2,241,11],[242,2,242,11],[231,2,231,11],[232,2,232,11],[233,2,233,11],[234,2,234,11],[235,2,235,11],[236,2,236,11],[249,2,249,11],[250,2,250,11],[251,2,251,11],[252,2,252,11],[253,2,253,11],[254,2,254,11],[255,2,255,11],[243,2,243,11],[244,2,244,11],[245,2,245,11],[246,2,246,11],[247,2,247,11],[248,2,248,11]]}
[]
[null,"Autorisation à réaliser des essais de perméabilité à l’air des réseaux aérauliques"]
[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 1: "]
[]
[null,"Passage 2:  "]
[]
[null,"Passage 3:  "]
[]
[null,"Conclusion"]
[null,"Conclusion 1:"]
[null,"Conclusion 2:"]
[null,"Conclusion 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":"A . Complétude du dossier"}]
[null,"A1"]
[]
[]
[]
[null,"A2"]
[]
[]
[]
[null,{"$f":"+Objet_essai!A1","v":"B . Objet de l'essai"}]
[null,"B1"]
[]
[]
[]
[null,"B2"]
[]
[]
[]
[null,"C. Informations générales"]
[null,"C1"]
[]
[]
[null,"C2"]
[]
[]
[]
[null,"C3"]
[]
[]
[]
[null,"C4"]
[]
[]
[]
[null,"C5"]
[]
[]
[]
[null,{"$f":"+Essai_permeabilite!A1","v":"D. Essai de perméabilité"}]
[null,"D1"]
[]
[]
[]
[null,"D2"]
[]
[]
[]
[null,"D3"]
[]
[]
[]
[null,"D4"]
[]
[]
[]
[null,"D5"]
[]
[]
[]
[null,"D6"]
[]
[]
[]
[null,"D7"]
[]
[]
[]
[null,"D8"]
[]
[]
[]
[null,"D9"]
[]
[]
[]
[null,"D10"]
[]
[]
[]
[null,{"$f":"+Analyse_resultats!A1","v":"E. Analyse des résultats"}]
[null,"E1"]
[]
[]
[]
[null,"E2"]
[]
[]
[]
[null,"E3"]
[]
[]
[]
[null,"E4"]
[]
[]
[]
[null,"E5"]
[]
[]
[]
[null,"E6"]
[]
[]
[]
[null,"E7"]
[]
[]
[]
[null,"E8"]
[]
[]
[]
[null,"Recommandations"]
[null,{"$f":"+B32","v":"A . Complétude du dossier"}]
[null,"A1"]
[]
[]
[]
[null,"A2"]
[]
[]
[]
[null,"B. Objet de l'essai"]
[null,"B1"]
[]
[]
[]
[null,"B2"]
[]
[]
[]
[null,"C. Informations générales"]
[null,"C1"]
[]
[]
[null,"C2"]
[]
[]
[]
[null,"C3"]
[]
[]
[]
[null,"C4"]
[]
[]
[]
[null,"C5"]
[]
[]
[]
[null,"D. Essai_permeabilite"]
[null,"D1"]
[]
[]
[]
[null,"D2"]
[]
[]
[]
[null,"D3"]
[]
[]
[]
[null,"D4"]
[]
[]
[]
[null,"D5"]
[]
[]
[]
[null,"D6"]
[]
[]
[]
[null,"D7"]
[]
[]
[]
[null,"D8"]
[]
[]
[]
[null,"D9"]
[]
[]
[]
[null,"D10"]
[]
[]
[]
[null,"E. Analyse des resultats"]
[null,"E1"]
[]
[]
[]
[null,"E2"]
[]
[]
[]
[null,"E3"]
[]
[]
[]
[null,"E4"]
[]
[]
[]
[null,"E5"]
[]
[]
[]
[null,"E6"]
[]
[]
[]
[null,"E7"]
[]
[]
[]
[null,"E8"]
[]
[]
[]
[null,null,"\n"]
[null,"\n",null,"Complétude du dossier","Examen des rapports"]
[null,"Critère",null,"Complétude du dossier","Objet de l'essai","Information générales","Essai perméabilité","Analyse des resultats","Global"]
[null,"Conforme",null,{"$f":"+Complétude_du_dossier!C4","v":"¨"},"¨",{"$f":"+Essai_permeabilite!C4","v":"¨"},"¨","¨","¨"]
[null,"Non conforme",null,{"$f":"+Complétude_du_dossier!C5","v":"¨"},"¨","¨",{"$f":"+Analyse_resultats!C5","v":"¨"},"¨","¨"]
[null,"Réserves",null,"¨","¨","¨","¨","¨","¨"]
[null,"Recommandations",null,"¨","¨","¨","¨","¨","¨"]

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