{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calcul Coef U","Regle Th-U","local 1","local 2","local 3","local 4","local 5","Bilan"],"not_rendered":{"charts":3,"images":1,"macros":0,"external_links":1,"defined_names":179,"comments":6,"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":"Calcul Coef U","index":0,"n_rows":139,"n_cols":12,"rows_kept":139,"cut":false,"hidden":false,"merged":[[93,7,93,10],[112,2,112,10],[113,7,113,10],[129,7,129,10],[135,8,135,10],[12,1,13,1],[17,1,18,1],[74,2,74,10],[75,7,75,10],[92,2,92,10],[56,2,56,10],[57,7,57,10],[37,2,37,10],[38,7,38,10],[22,1,23,1]]}
[]
[]
[]
[null,"RESISTANCE SUPERFICIELLES"]
[null,"Position de la paroi","Face externe","Rsi","Rse","Total"]
[null,"Flux ascendant ↑ cloisons horizontales ","extérieur, passage ouvert, local ouvert",0.1,0.04,{"$f":"SUM(D6:E6)","v":0.14000000000000001}]
[null,"Flux ascendant ↑ cloisons horizontales ","comble, local non chauffé ",0.1,0.1,{"$f":"SUM(D7:E7)","v":0.2},"Flux horizontal ← cloisons verticales     extérieur, local ouvert"]
[null,"Flux horizontal ← cloisons verticales","extérieur, local ouvert",0.13,0.04,0.17,{"$f":"VLOOKUP(Flux,RSIRSE3,2,FALSE)","v":0.17}]
[null,"Flux horizontal ← cloisons verticales","comble, local non chauffé ",0.13,0.13,0.26,"Matériaux non renseigné (Cf.Résistances thermiques)"]
[null,"Flux descendant ↓ cloisons horizontales","extérieur, passage ouvert, local ouvert",0.17,0.04,0.21000000000000002,{"$f":"IFERROR(VLOOKUP(Deper2,'Regle Th-U'!B6:D291,3,FALSE),0)","v":0}]
[null,"Flux descendant ↓ cloisons horizontales","vide sanitaire, local non chauffé ",0.17,0.17,0.34]
[null,null,null,null,null,null,null,null,null,null,null,"Recommandation ACIVF 01-2006; chap. 9.7 :"]
[null,"Flux ascendant ↑ cloisons horizontales"]
[]
[null,"extérieur, passage ouvert, local ouvert",{"$f":"F6","v":0.14000000000000001}]
[null,"comble, local non chauffé ",{"$f":"F7","v":0.2},null,null,null,"Tableau récapitulatif des Coefficients : "]
[null,null,null,null,null,null,"Paroi","U (W/m².K)"]
[null,"Flux horizontal ← cloisons verticales",null,null,null,1,{"$f":"CELL(\"contenu\",C38)&IF(C38=0,\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"G53","v":0}]
[null,null,null,null,null,2,{"$f":"CELL(\"contenu\",C57)&IF(C57=0,\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"G72","v":0}]
[null,"extérieur, local ouvert",{"$f":"F8","v":0.17},null,null,3,{"$f":"CELL(\"contenu\",C75)&IF(C75=0,\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"G90","v":0}]
[null,"comble, local non chauffé ",{"$f":"F9","v":0.26},null,null,4,{"$f":"CELL(\"contenu\",C93)&IF(C93=0,\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"G108","v":0}]
[null,null,null,null,null,5,{"$f":"CELL(\"contenu\",C113)&IF(C113=0,\"\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"G128","v":0}]
[null,"Flux descendant ↓ cloisons horizontales"]
[]
[null,"extérieur, passage ouvert, local ouvert",{"$f":"F10","v":0.21000000000000002}]
[null,"vide sanitaire, local non chauffé ",{"$f":"F11","v":0.34}]
[]
[]
[null,"Flux ascendant ↑ cloisons horizontales     extérieur, passage ouvert, local ouvert",0.14000000000000001]
[null,"Flux ascendant ↑ cloisons horizontales     comble, local non chauffé",0.2,null,null,null,"Calcul du Coefficient minorateur bu :"]
[null,"Flux horizontal ← cloisons verticales     extérieur, local ouvert",0.17,null,null,null,"Température Intérieure",22]
[null,"Flux horizontal ← cloisons verticales     comble, local non chauffé",0.26,null,null,null,"Température Extérieure",{"$f":"'local 1'!H5","v":-9}]
[null,"Flux descendant ↓ cloisons horizontales    extérieur, passage ouvert, local ouvert",0.21,null,null,null,"Température d'Equilibre Local non chauffé"]
[null,"Flux descendant ↓ cloisons horizontales    vide sanitaire, local non chauffé",0.34,null,null,null,"Coefficient minorateur b ",{"$f":"(H31-H33)/(H31-H32)","v":0.70967741935483875}]
[]
[]
[]
[1,"Paroi :","Plancher Bas Zone Habitable Terre-Plein"]
[null,"Désignation",null,"e (m)","Ru","λ (W/m.k)","Rsi + ε(e/λ)[+ R ]+ Rse","Références"]
[null,"Rsi",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree1,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F41<>0,$D41/$F41,$E41),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree1,RegleThU,8,FALSE),\"\")&IF($F41=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree2,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F42<>0,$D42/$F42,$E42),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree2,RegleThU,8,FALSE),\"\")&IF($F42=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree3,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree3,RegleThU,8,FALSE),\"\")&IF($F43=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree4,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree4,RegleThU,8,FALSE),\"\")&IF($F44=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree5,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree5,RegleThU,8,FALSE),\"\")&IF($F45=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree6,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree6,RegleThU,8,FALSE),\"\")&IF($F46=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree7,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree7,RegleThU,8,FALSE),\"\")&IF($F47=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree8,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree8,RegleThU,8,FALSE),\"\")&IF($F48=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree9,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree9,RegleThU,8,FALSE),\"\")&IF($F49=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree10,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree10,RegleThU,8,FALSE),\"\")&IF($F50=0,\"\",\"\")","v":""}]
[null,"Rse",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,null,null,null,null,"R (m².K/W)",{"$f":"SUM(G40:G51)","v":0}]
[null,null,null,null,null,"U (W/m².K)",{"$f":"IFERROR(1/G52,0)","v":0}]
[]
[]
[]
[2,"Paroi :","Plancher Bas Garage Terre-Plein"]
[null,"Désignation",null,"e (m)","Ru","λ (W/m.k)","Rsi + ε(e/λ)[+ R ]+ Rse","Références"]
[null,"Rsi",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree11,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F60<>0,$D60/$F60,$E60),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree11,RegleThU,8,FALSE),\"\")&IF($F60=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree12,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F61<>0,$D61/$F61,$E61),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree12,RegleThU,8,FALSE),\"\")&IF($F61=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree13,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree13,RegleThU,8,FALSE),\"\")&IF($F62=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree14,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree14,RegleThU,8,FALSE),\"\")&IF($F63=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree15,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree15,RegleThU,8,FALSE),\"\")&IF($F64=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree16,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree16,RegleThU,8,FALSE),\"\")&IF($F65=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree17,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree17,RegleThU,8,FALSE),\"\")&IF($F66=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree18,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree18,RegleThU,8,FALSE),\"\")&IF($F67=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree19,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree19,RegleThU,8,FALSE),\"\")&IF($F68=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree20,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree20,RegleThU,8,FALSE),\"\")&IF($F69=0,\"\",\"\")","v":""}]
[null,"Rse",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,null,null,null,null,"R (m².K/W)",{"$f":"SUM(G59:G70)","v":0}]
[null,null,null,null,null,"U (W/m².K)",{"$f":"IFERROR(1/G71,0)","v":0}]
[]
[]
[3,"Paroi :"]
[null,"Désignation",null,"e (m)","Ru","λ (W/m.k)","Rsi + ε(e/λ)[+ R ]+ Rse","Références"]
[null,"Rsi",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree21,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F78<>0,$D78/$F78,$E78),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree21,RegleThU,8,FALSE),\"\")&IF($F78=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree22,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F79<>0,$D79/$F79,$E79),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree22,RegleThU,8,FALSE),\"\")&IF($F79=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree23,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree23,RegleThU,8,FALSE),\"\")&IF($F80=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree24,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree24,RegleThU,8,FALSE),\"\")&IF($F81=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree25,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree25,RegleThU,8,FALSE),\"\")&IF($F82=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree26,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree26,RegleThU,8,FALSE),\"\")&IF($F83=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree27,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree27,RegleThU,8,FALSE),\"\")&IF($F84=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree28,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree28,RegleThU,8,FALSE),\"\")&IF($F85=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree29,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree29,RegleThU,8,FALSE),\"\")&IF($F86=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree30,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree30,RegleThU,8,FALSE),\"\")&IF($F87=0,\"\",\"\")","v":""}]
[null,"Rse",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,null,null,null,null,"R (m².K/W)",{"$f":"SUM(G77:G88)","v":0}]
[null,null,null,null,null,"U (W/m².K)",{"$f":"IFERROR(1/G89,0)","v":0}]
[]
[]
[4,"Paroi :"]
[null,"Désignation",null,"e (m)","Ru","λ (W/m.k)","Rsi + ε(e/λ)[+ R ]+ Rse","Références"]
[null,"Rsi",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree31,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F96<>0,$D96/$F96,$E96),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree31,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree32,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F97<>0,$D97/$F97,$E97),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree32,RegleThU,8,FALSE),\"\")&IF($F97=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree33,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree33,RegleThU,8,FALSE),\"\")&IF($F98=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree34,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree34,RegleThU,8,FALSE),\"\")&IF($F99=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree35,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree35,RegleThU,8,FALSE),\"\")&IF($F100=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree36,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree36,RegleThU,8,FALSE),\"\")&IF($F101=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree37,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree37,RegleThU,8,FALSE),\"\")&IF($F102=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree38,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree38,RegleThU,8,FALSE),\"\")&IF($F103=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree39,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree39,RegleThU,8,FALSE),\"\")&IF($F104=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree40,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree40,RegleThU,8,FALSE),\"\")&IF($F105=0,\"\",\"\")","v":""}]
[null,"Rse",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,null,null,null,null,"R (m².K/W)",{"$f":"SUM(G95:G106)","v":0}]
[null,null,null,null,null,"U (W/m².K)",{"$f":"IFERROR(1/G107,0)","v":0}]
[]
[]
[null,"Echanges par le sol : (calculs effectués selon guide AICVF 01-2006, chap. 7)"]
[]
[5,"Paroi :"]
[null,"Désignation",null,"e (m)","Ru","λ (W/m.k)","Rsi + ε(e/λ)[+ R ]+ Rse","Références"]
[null,"Rsi",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree41,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F116<>0,$D116/$F116,$E116),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree41,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree42,RegleThU,3,FALSE),0)","v":0},{"$f":"IFERROR(IF($F117<>0,$D117/$F117,$E117),0)","v":0},{"$f":"IFERROR(VLOOKUP(entree42,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree43,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree43,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree44,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree44,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree45,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree45,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree46,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree46,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree47,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree47,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree48,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree48,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree49,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree49,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,{"$f":"IFERROR(VLOOKUP(entree50,RegleThU,3,FALSE),0)","v":0},0,{"$f":"IFERROR(VLOOKUP(entree50,RegleThU,8,FALSE),\"\")&IF($F96=0,\"\",\"\")","v":""}]
[null,"Rse",null,null,null,null,0,"Règles Th-U; fascicule ; chap. 1.5.2"]
[null,null,null,null,null,"R (m².K/W)",{"$f":"SUM(G115:G126)","v":0}]
[null,null,null,null,null,"U (W/m².K)",{"$f":"IFERROR(1/G127,0)","v":0}]
[]
[null,"Ug1 (Pertes basses)",null,"Surface","Périmètre*","Hauteur",null,"Références"]
[null,"Calcul coef. B (Surface / 0,5*périmètre*)",null,32,40,null,{"$f":"IFERROR(D131/(0.5*E131),0)","v":1.6},"Guide AICVF 01-2006; chap. 7.4"]
[null,"Calcul coef. α (1,571*B/(0,21+R1+0,785h))",null,null,null,0,{"$f":"(1.571*G131)/(0.21+G127+(0.785*F132))","v":11.969523809523812},"Guide AICVF 01-2006; chap. 7.4"]
[null,"Détermination coef. β (AICVF; chap. 7.6)",null,null,null,null,{"$f":"IFERROR(VLOOKUP(Alpha,Beta,2,TRUE),0)","v":2.54},"Guide AICVF 01-2006; chap. 7.6"]
[null,"* périmètre en contact avec terre-plein",null,null,null,"Ug1 (W/m².K)",{"$f":"IFERROR((0.2/G131)*G133,0)","v":0.3175}]
[]
[null,"Ug2 (Pertes latérales)",null,"Surface","Périmètre*","Hauteur","R2",null,"Références"]
[null,"Calcul coef. α (0,785*h/(0,17+R2)",null,null,null,null,null,{"$f":"(0.785*F137)/(0.17+G137)","v":0},"Guide AICVF 01-2006; chap. 7.5"]
[null,"Détermination coef. β (AICVF; chap. 7.6)",null,null,null,null,null,null,"Guide AICVF 01-2006; chap. 7.6"]
[null,null,null,null,null,null,"Ug2 (W/m².K)",{"$f":"IFERROR((0.382/F137)*H138,0)","v":0}]

{"sheet":"Regle Th-U","index":1,"n_rows":381,"n_cols":13,"rows_kept":381,"cut":false,"hidden":false,"merged":[[2,4,3,4],[2,5,2,6],[2,1,3,1],[2,2,3,2],[2,3,3,3]]}
[null,null,"Terre cuite ρ nominal = 1900"]
[null,null,{"$f":"VLOOKUP(Deper,B6:D291,3,FALSE)","v":0.74}]
[null,"Matériaux ou application ","Masse volumique sèche (ρ)\nen kg/m3","Conductivité\nthermique\nutile (λ)\nen W/(m.K)","Capacité\nthermique\nmassique\n(Cp)\nen J/(kg.K)","Facteur de résistance à la\ndiffusion devapeur d’eau\n(μ)",null,null,null,"Perméabilité type","Coef.","Alpha","Beta"]
[null,null,null,null,null,"sec","humide",null,"Référence","Non renseigné",null,0,0]
[null,"Matériaux non renseigné (Cf.Résistances thermiques)",null,null,null,null,null,null,null,"Entrée d'air module 15",3.4,0.02,0.02]
[1,"Pierres / Roches plutoniques et métamorphiques / Gneiss, porphyres","2 300 ≤ ρ ≤ 2 900",3.5,1000,10000,10000,{"$f":"OFFSET(B6,0,2,1,1)","v":3.5},"Règle Th-U; fasc2 2.1.1. p3","Entrée d'air module 22",5,0.04,0.04]
[2,"Pierres / Roches plutoniques et métamorphiques / Granites","2 500 ≤ ρ ≤ 2 700",2.8,1000,10000,10000,{"$f":"OFFSET(B7,0,2,1,1)","v":2.8},"Règle Th-U; fasc2 2.1.1. p3","Entrée d'air module 30",6.8,0.06,0.06]
[3,"Pierres / Roches plutoniques et métamorphiques / Schistes, ardoises","2 000 ≤ ρ ≤ 2 800",2.2000000000000002,1000,1000,800,2.2000000000000002,"Règle Th-U; fasc2 2.1.1. p3","Entrée d'air module 45",10.199999999999999,0.08,0.08]
[4,"Roches volcaniques / Basaltes","2 700 ≤ ρ ≤ 3 000",1.6,1000,10000,10000,1.6,"Règle Th-U; fasc2 2.1.2. p3","Entrée d'air module 60",13.6,0.1,0.1]
[5,"Roches volcaniques / Trachytes, andésites","2 000 ≤ ρ ≤ 2 700",1.1000000000000001,1000,20,15,1.1000000000000001,"Règle Th-U; fasc2 2.1.2. p3","Simple fenêtre ou porte-fenêtre - classe A3",0.3,0.12,0.11]
[6,"Roches volcaniques / Pierres naturelles poreuses, ex : laves","ρ ≤ 1 600",0.55000000000000004,1000,20,15,0.55000000000000004,"Règle Th-U; fasc2 2.1.2. p3","Simple fenêtre ou porte-fenêtre - classe A2",0.8,0.13,0.12]
[7,"Pierres calcaires / Marbres","2 600 ≤ ρ ≤ 2 800",3.5,1000,10000,10000,3.5,"Règle Th-U; fasc2 2.1.3. p3","Simple fenêtre ou porte-fenêtre - classe A1",2,0.14000000000000001,0.13]
[8,"Pierres calcaires / Pierres froides ou extra-dures","2 200 ≤ ρ ≤ 2 590",2.2999999999999998,1000,250,200,2.2999999999999998,"Règle Th-U; fasc2 2.1.3. p3","Simple fenêtre ou porte-fenêtre - non classée",4,0.15,0.14000000000000001]
[9,"Pierres calcaires / Pierres dures","2 000 ≤ ρ ≤ 2 190",1.7,1000,200,150,1.7,"Règle Th-U; fasc2 2.1.3. p3","Double fenêtre (A3 + quelconque)",0.3,0.16,0.15]
[10,"Pierres calcaires / Pierres fermes, demi-fermes","1 800 ≤ ρ ≤ 1 990",1.4,1000,50,40,1.4,"Règle Th-U; fasc2 2.1.3. p3","Double fenêtre (2 x A2)",0.5,0.17,0.16]
[11,"Pierres calcaires / Pierres tendres n°2 et 3","1 600 ≤ ρ ≤ 1 790",1.1000000000000001,1000,40,25,1.1000000000000001,"Règle Th-U; fasc2 2.1.3. p3","Double fenêtre (A2 + A1)",0.7,0.18,0.17]
[12,"Pierres calcaires / Pierres très tendres","ρ ≤ 1 590",0.85,1000,30,20,0.85,"Règle Th-U; fasc2 2.1.3. p3","Double fenêtre (A2 + quelconque)",0.8,0.19,0.17499999999999999]
[13,"Grès quartzeux","2 600 ≤ ρ ≤ 2 800",2.6,1000,40,30,2.6,"Règle Th-U; fasc2 2.1.4 p3","Double fenêtre (2 x A1)",1.2,0.2,0.18]
[14,"Grès (silice)","2 200 ≤ ρ ≤ 2 590",2.2999999999999998,1000,40,30,2.2999999999999998,"Règle Th-U; fasc2 2.1.4 p3","Double fenêtre (A1 = quelconque)",1.7,0.21,0.19]
[15,"Grès calcarifères","2 000 ≤ ρ ≤ 2 700",1.9,1000,30,20,1.9,"Règle Th-U; fasc2 2.1.4 p3","Double fenêtre (2 x quelconque)",2.4,0.22,0.2]
[16,"Silex","2 600 ≤ ρ ≤ 2 800",2.6,1000,10000,10000,2.6,"Règle Th-U; fasc2 2.1.5. p3","Porte non classée avec seuil et joint d'étanchéité",1.2,0.23,0.21]
[17,"Meulières (1)","1 900 ≤ ρ ≤ 2 500",1.8,1000,50,40,1.8,"Règle Th-U; fasc2 2.1.5. p3","Porte non classée courante avec plots souples en feuillure",8,0.24,0.22]
[18,"Meulières (2)","1 300 ≤ ρ < 1 900",0.9,1000,30,20,0.9,"Règle Th-U; fasc2 2.1.5. p3","Porte non classée courante sans plots souples en feuillure",20,0.25,0.22500000000000001]
[19,"Ponces naturelles","ρ ≤ 400",0.12,1000,8,6,0.12,"Règle Th-U; fasc2 2.1.5. p3","Trappe de comble perdu avec joint d'étanchéité",0.8,0.26,0.23]
[20,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton plein (1)","2 300 < ρ ≤ 2 600",2,1000,130,80,2,"Règle Th-U; fasc2 2.2.1.1. p4","Trappe de comble perdu sans joint d'étanchéité",4,0.27,0.24]
[21,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton plein (2)","2 000 < ρ ≤ 2 300",1.65,1000,120,70,1.65,"Règle Th-U; fasc2 2.2.1.1. p4","Coffre de VR extérieur sans communication avec l'intérieur",0,0.28000000000000003,0.25]
[22,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton caverneux (1)","1800 < ρ ≤ 2 000",1.35,1000,100,60,1.35,"Règle Th-U; fasc2 2.2.1.2. p4","Coffre de VR intérieur avec joints calfeutrés",0.2,0.28999999999999998,0.255]
[23,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton caverneux (2)","1600 ≤ ρ ≤ 1 800",1.1499999999999999,1000,100,60,1.1499999999999999,"Règle Th-U; fasc2 2.2.1.2. p4","Coffre de VR intérieur d'autre type",1.5,0.3,0.26]
[24,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton plein armé avec V <  1% d'acier et  ≤ 2","2 300 < ρ ≤ 2 400",2.2999999999999998,1000,130,80,2.2999999999999998,"Règle Th-U; fasc2 2.2.1.3. p4",null,null,0.32500000000000001,0.28000000000000003]
[25,"Bétons de granulats courants siliceux, silico-calcaires et calcaires (NFP 18-540) / Béton plein armé avec % d'acier > 2","ρ > 2 400",2.5,1000,130,80,2.5,"Règle Th-U; fasc2 2.2.1.3. p4",null,null,0.35,0.3]
[26,"Bétons de granulats courants de laitiers de haut fourneaux (NFP 18-302) / Béton plein (1)","2 000 ≤ ρ ≤ 2 400",1.4,1000,150,120,1.4,"Règle Th-U; fasc2 2.2.2.1. p4","Type de ventilation","Coef",0.4,0.34]
[27,"Bétons de granulats courants de laitiers de haut fourneaux (NFP 18-302) / Béton plein (2)","2 100 ≤ ρ ≤ 2 300",0.8,1000,150,120,0.8,"Règle Th-U; fasc2 2.2.2.1. p4","Ventilation non réglementaire",null,0.45,0.37]
[28,"Bétons de granulats courants de laitiers de haut fourneaux (NFP 18-302) / Béton caverneux","1 600 ≤ ρ ≤ 2 000",0.7,1000,150,120,0.7,"Règle Th-U; fasc2 2.2.2.2. p4","Ventilation naturelle",1.3,0.5,0.41]
[29,"Bétons de granulats légers / Béton de pouzzolane ou de laitier expansé à structure caverneuse avec éléments fins de sable (1)","1 400 ≤ ρ ≤ 1 600",0.52,1000,30,20,0.52,"Règle Th-U; fasc2 2.2.3.1. p4","VMC double flux avec fourniture de chaleur",1.05,0.55000000000000004,0.44]
[30,"Bétons de granulats légers / Béton de pouzzolane ou de laitier expansé à structure caverneuse avec éléments fins de sable (2)","1 200 ≤ ρ ≤ 1 400",0.44,1000,30,20,0.44,"Règle Th-U; fasc2 2.2.3.1. p4","VMC double flux avec récupération de chaleur",1.05,0.6,0.47]
[31,"Bétons de granulats légers / Béton de pouzzolane ou de laitier expansé à structure caverneuse sans éléments fins de sable","1 000 ≤ ρ ≤ 1 200",0.35,1000,30,20,0.35,"Règle Th-U; fasc2 2.2.3.1. p4","VMC double flux sans préchauffage",1.05,0.65,0.5]
[32,"Béton de cendres volantes frittées","1 000 ≤ ρ ≤ 1 200",0.35,1000,30,20,0.35,"Règle Th-U; fasc2 2.2.3.2. p4","VMC simple flux",1.1499999999999999,0.7,0.53]
[33,"Béton de ponce naturelle","950 ≤ ρ ≤ 1 150",0.46,1000,50,40,0.46,"Règle Th-U; fasc2 2.2.3.3. p4",null,null,0.75,0.56000000000000005]
[34,"Béton d'argile expansée ou de schiste expansé /Béton de structure (ciment≥300kg/m3) avec sable de rivière, sans sable léger","1 600 < ρ ≤ 1 800",1.05,1000,8,6,1.05,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,0.8,0.59]
[35,"Béton d'argile expansée ou de schiste expansé/ Béton de structure (ciment≥300kg/m3) avec sable de rivière et sable léger","1 400 < ρ ≤ 1 600",0.85,1000,8,6,0.85,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,0.85,0.62]
[36,"Béton d'argile expansée ou de schiste expansé / Béton isolants porteurs avec sable léger et au + 10% de sable de rivière","1 200 < ρ ≤ 1 400",0.7,1000,6,4,0.7,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,0.9,0.64]
[37,"Béton d'argile expansée ou de schiste expansé / Béton isolants porteurs avec sable léger, sans sable de rivière","1 000 ≤ ρ ≤ 1 200",0.46,1000,6,4,0.46,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,0.95,0.67]
[38,"Béton d'argile expansée ou de schiste expansé / Bétons caverneux et semi-caverneux avec sable léger, sans sable de rivière","800 < ρ ≤ 1 000",0.33,1000,6,4,0.33,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,1,0.69]
[39,"Béton d'argile expansée ou de schiste expansé / Bétons caverneux et semi-caverneux sans sable et faible dosage ciment (1)","600 < ρ ≤ 800",0.25,1000,6,4,0.25,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,1.05,0.72]
[40,"Béton d'argile expansée ou de schiste expansé / Bétons caverneux et semi-caverneux sans sable et faible dosage ciment (2)","ρ ≤ 600",0.2,1000,6,4,0.2,"Règle Th-U; fasc2 2.2.3.4. p5",null,null,1.1000000000000001,0.74]
[41,"Bétons de granulats très légers / Bétons de perlite ou de vermiculite grade 3 dosage 3/1","600 < ρ ≤ 800",0.31,1000,15,10,0.31,"Règle Th-U; fasc2 2.2.4.1. p5",null,null,1.1499999999999999,0.77]
[42,"Bétons de granulats très légers / Bétons de perlite ou de vermiculite grade 3 dosage 6/1","400 ≤ ρ ≤ 600",0.24,1000,15,10,0.24,"Règle Th-U; fasc2 2.2.4.1. p5",null,null,1.2,0.79]
[43,"Bétons de granulats très légers / Plaques de béton de vermiculite fabriquées en usine","400 ≤ ρ ≤ 600",0.19,1000,15,10,0.19,"Règle Th-U; fasc2 2.2.4.2. p5",null,null,1.25,0.81]
[44,"Bétons cellulaires traités à l'autoclave ρ nominal = 800","765 < ρ ≤ 825",0.28999999999999998,1000,10,6,0.28999999999999998,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.3,0.83]
[45,"Bétons cellulaires traités à l'autoclave ρ nominal = 750","715 < ρ ≤ 775",0.27,1000,10,6,0.27,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.35,0.85]
[46,"Bétons cellulaires traités à l'autoclave ρ nominal = 700","665 < ρ ≤ 725",0.25,1000,10,6,0.25,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.4,0.88]
[47,"Bétons cellulaires traités à l'autoclave ρ nominal = 650","615 < ρ ≤ 675",0.23,1000,10,6,0.23,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.45,0.9]
[48,"Bétons cellulaires traités à l'autoclave ρ nominal = 600","565 < ρ ≤ 625",0.21,1000,10,6,0.21,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.5,0.92]
[49,"Bétons cellulaires traités à l'autoclave ρ nominal = 550","515 < ρ ≤ 575",0.19,1000,10,6,0.19,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.6,0.96]
[50,"Bétons cellulaires traités à l'autoclave ρ nominal = 500","465 < ρ ≤ 525",0.17499999999999999,1000,10,6,0.17499999999999999,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.7,0.99]
[51,"Bétons cellulaires traités à l'autoclave ρ nominal = 450","415 < ρ ≤ 475",0.16,1000,10,6,0.16,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.75,1.01]
[52,"Bétons cellulaires traités à l'autoclave ρ nominal = 400","365 < ρ ≤ 425",0.14499999999999999,1000,10,6,0.14499999999999999,"Règle Th-U; fasc2 2.2.5. p5",null,null,1.8,1.03]
[53,"Bétons de bois / Béton de copeau de bois","450 ≤ ρ ≤ 650",0.16,1000,15,10,0.16,"Règle Th-U; fasc2 2.2.6.1. p5",null,null,1.85,1.0449999999999999]
[54,"Bétons de bois / Panneaux de laine de bois (fibbragglo) en béton de copeaux de bois (1)","100 ≤ ρ ≤ 200",0.1,1000,null,null,0.1,"Règle Th-U; fasc2 2.2.6.3. p5",null,null,1.9,1.06]
[55,"Bétons de bois / Panneaux de laine de bois (fibbragglo) en béton de copeaux de bois (2)","200 ≤ ρ ≤ 600",0.2,1000,null,null,0.2,"Règle Th-U; fasc2 2.2.6.3. p5",null,null,1.95,1.08]
[56,"Plâtres sans granulats \"gaché serré \" ou \"très serrés\" (1)","1 200 < ρ ≤1 500",0.56000000000000005,1000,10,4,0.56000000000000005,"Règle Th-U; fasc2 2.3.1. p6",null,null,2,1.1000000000000001]
[57,"Plâtres sans granulats \"gaché serré \" ou \"très serrés\" (2)","900 < ρ ≤ 1 200",0.43,1000,10,4,0.43,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.1,1.1299999999999999]
[58,"Plâtres sans granulats \"gaché serré \" ou \"très serrés\" (3)","600 ≤ ρ ≤ 900",0.3,1000,10,4,0.3,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.2000000000000002,1.1599999999999999]
[59,"Plâtres sans granulats \"gaché serré \" ou \"très serrés\" (4)","ρ ≤ 600",0.18,1000,10,4,0.18,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.2999999999999998,1.19]
[60,"Plâtres sans granulats courant + enduit intérieur(PFC) ou plâtre gros construction (1)","1 000 ≤ ρ ≤ 1 300",0.56999999999999995,1000,10,6,0.56999999999999995,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.4,1.22]
[61,"Plâtres sans granulats courant + enduit intérieur(PFC) ou plâtre gros construction (2)","ρ ≤ 1 000",0.4,1000,10,6,0.4,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.5,1.25]
[62,"Plâtres sans granulats + enduit intérieur à base de plâtre et sable","ρ ≤ 1 600",0.8,1000,10,6,0.8,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.6,1.28]
[63,"Plâtres / Plaques de Plâtres sans granulats à parement carton ou préfabriqués lisses","750 ≤ ρ ≤ 900",0.25,1000,10,4,0.25,"Règle Th-U; fasc2 2.3.1. p6",null,null,2.6,1.32]
[64,"Plâtres avec granulats légers ou fibres minérales / Plaques de Plâtres avec granulats à parement carton \"feu\"/ fibres minérales","800 ≤ ρ ≤ 1 000",0.25,1000,10,4,0.25,"Règle Th-U; fasc2 2.3.2. p6",null,null,2.8,1.36]
[65,"Plâtres avec granulats légers ou fibres minérales / Plâtre d'enduit avec perlite tout venant ou vermiculite 1/1","600 ≤ ρ ≤ 900",0.3,1000,10,6,0.3,"Règle Th-U; fasc2 2.3.2. p6",null,null,2.9,1.375]
[66,"Plâtres avec granulats légers ou fibres minérales / Plâtre d'enduit avec perlite tout venant ou vermiculite 2/1","500 ≤ ρ ≤ 600",0.18,1000,10,6,{"$f":"OFFSET(B71,0,2,1,1)","v":0.18},"Règle Th-U; fasc2 2.3.2. p6",null,null,3,1.39]
[67,"Terre cuite ρ nominal = 2400","2 300 < ρ ≤ 2 400",1.04,1000,16,10,1.04,"Règle Th-U; fasc2 2.4. p6",null,null,3.1,1.415]
[68,"Terre cuite ρ nominal = 2300","2 200 < ρ ≤ 2 300",0.98,1000,16,10,0.98,"Règle Th-U; fasc2 2.4. p6",null,null,3.2,1.44]
[69,"Terre cuite ρ nominal = 2200","2 100 < ρ ≤ 2 200",0.92,1000,16,10,0.92,"Règle Th-U; fasc2 2.4. p6",null,null,3.3,1.46]
[70,"Terre cuite ρ nominal = 2100","2 000 < ρ ≤ 2 100",0.85,1000,16,10,0.85,"Règle Th-U; fasc2 2.4. p6",null,null,3.4,1.48]
[71,"Terre cuite ρ nominal = 2000","1 900 < ρ ≤ 2 000",0.79,1000,16,10,0.79,"Règle Th-U; fasc2 2.4. p6",null,null,3.5,1.5049999999999999]
[72,"Terre cuite ρ nominal = 1900","1 800 < ρ ≤ 1 900",0.74,1000,16,10,0.74,"Règle Th-U; fasc2 2.4. p6",null,null,3.6,1.53]
[73,"Terre cuite ρ nominal = 1800","1 700 < ρ ≤ 1 800",0.69,1000,16,10,0.69,"Règle Th-U; fasc2 2.4. p6",null,null,3.7,1.55]
[74,"Terre cuite ρ nominal = 1700","1 600 < ρ ≤ 1 700",0.64,1000,16,10,0.64,"Règle Th-U; fasc2 2.4. p6",null,null,3.8,1.57]
[75,"Terre cuite ρ nominal = 1600","1 500 < ρ ≤ 1 600",0.6,1000,16,10,0.6,"Règle Th-U; fasc2 2.4. p6",null,null,3.9,1.59]
[76,"Terre cuite ρ nominal = 1500","1 400 < ρ ≤ 1 500",0.55000000000000004,1000,16,10,0.55000000000000004,"Règle Th-U; fasc2 2.4. p6",null,null,4,1.61]
[77,"Terre cuite ρ nominal = 1400","1 300 < ρ ≤ 1 400",0.5,1000,16,10,0.5,"Règle Th-U; fasc2 2.4. p6",null,null,4.0999999999999996,1.63]
[78,"Terre cuite ρ nominal = 1300","1 200 < ρ ≤ 1 300",0.46,1000,16,10,0.46,"Règle Th-U; fasc2 2.4. p6",null,null,4.2,1.65]
[79,"Terre cuite ρ nominal = 1200","1 100 < ρ ≤ 1 200",0.41,1000,16,10,0.41,"Règle Th-U; fasc2 2.4. p6",null,null,4.3,1.665]
[80,"Terre cuite ρ nominal = 1100","1 000 < ρ ≤ 1 100",0.38,1000,16,10,0.38,"Règle Th-U; fasc2 2.4. p6",null,null,4.4000000000000004,1.68]
[81,"Terre cuite ρ nominal = 1000","ρ ≤ 1000",0.34,1000,16,10,0.34,"Règle Th-U; fasc2 2.4. p6",null,null,4.5,1.7]
[82,"Vegetaux / Bois / Feuillus très lourds ρn>1000kg/m3","ρ > 870",0.28999999999999998,1600,200,50,0.28999999999999998,"Règle Th-U; fasc2 2.5.1. p6",null,null,4.5999999999999996,1.72]
[83,"Vegetaux / Bois / Feuillus lourds 865< ρn≤1000kg/m3","750 < ρ ≤ 870",0.23,1600,200,50,0.23,"Règle Th-U; fasc2 2.5.1. p6",null,null,4.7,1.74]
[84,"Vegetaux / Bois / Feuillus mi-lourds 650<ρn≤865kg/m3","565 < ρ ≤ 750",0.18,1600,200,50,0.18,"Règle Th-U; fasc2 2.5.1. p6",null,null,4.8,1.76]
[85,"Vegetaux / Bois / Feuillus légers 500<ρn≤650kg/m3","435 < ρ ≤ 565",0.15,1600,200,50,0.15,"Règle Th-U; fasc2 2.5.1. p6",null,null,4.9000000000000004,1.7749999999999999]
[86,"Vegetaux / Bois / Feuillus très légers hors balsa 230<ρn≤500kg/m3","200 < ρ ≤ 435",0.13,1600,50,20,0.13,"Règle Th-U; fasc2 2.5.1. p6",null,null,5,1.79]
[87,"Vegetaux / Bois / Balsa ρn≤230kg/m3","ρ ≤ 200",5.7000000000000002E-2,1600,50,20,5.7000000000000002E-2,"Règle Th-U; fasc2 2.5.1. p6",null,null,5.0999999999999996,1.81]
[88,"Vegetaux / Bois / Résineux très lourds ρn>700kg/m3","ρ > 610",0.23,1600,50,20,0.23,"Règle Th-U; fasc2 2.5.1. p6",null,null,5.2,1.82]
[89,"Vegetaux / Bois / Résineux lourds 600<ρn≤700kg/m3","520 < ρ ≤ 610",0.18,1600,50,20,0.18,"Règle Th-U; fasc2 2.5.1. p6",null,null,5.3,1.84]
[90,"Vegetaux / Bois / Résineux mi-lourds 500<ρn≤600kg/m3","435 < ρ ≤ 520",0.15,1600,50,20,0.15,"Règle Th-U; fasc2 2.5.1. p6",null,null,5.4,1.86]
[91,"Vegetaux / Bois / Résineux légers ρn≤500kg/m3","ρ ≤ 435",0.13,1600,50,20,0.13,"Règle Th-U; fasc2 2.5.1. p6",null,null,5.5,1.87]
[92,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 850 à 1000kg/m3  ","750 < ρ ≤ 900",0.24,1600,250,110,0.24,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,5.6,1.89]
[93,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 700 à 850kg/m3","600 < ρ ≤ 750",0.21,1600,250,110,0.21,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,5.7,1.9]
[94,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 600 à 700kg/m3","500 < ρ ≤ 600",0.17,1600,220,90,0.17,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,5.8,1.92]
[95,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 500 à 600kg/m3","450 < ρ ≤ 500",0.15,1600,200,70,0.15,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,5.9,1.93]
[96,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 400 à 500kg/m3","350 < ρ ≤ 450",0.13,1600,200,70,0.13,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,6,1.95]
[97,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ 300 à 400kg/m3","250 < ρ ≤ 350",0.11,1600,200,50,0.11,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,6.1,1.96]
[98,"Panneaux à base de bois (NF EN 13986) / Panneaux contreplaqués NF EN 313-1 /313-2 ρ<300kg/m3","ρ ≤ 250",0.09,1600,200,50,0.09,"Règle Th-U; fasc2 2.5.2.1. p7",null,null,6.2,1.97]
[99,"Panneaux à lamelles longues et orientées (OSB) NF EN 300","ρ ≤ 650",0.13,1700,50,30,0.13,"Règle Th-U; fasc2 2.5.2.2. p7",null,null,6.3,1.9850000000000001]
[100,"Panneaux de particules liées au ciment NF EN 634-1 / NF EN 634-2","ρ ≤ 1 200",0.23,1500,50,30,0.23,"Règle Th-U; fasc2 2.5.2.3. p7",null,null,6.4,2]
[101,"Panneaux de particules NF EN 309 ρn 700 à 900kg/m3","640 < ρ ≤ 820",0.18,1700,50,20,0.18,"Règle Th-U; fasc2 2.5.2.4. p7",null,null,6.5,2.0150000000000001]
[102,"Panneaux de particules NF EN 309 ρn 500 à 700kg/m3","450 < ρ ≤ 640",0.15,1700,50,20,0.15,"Règle Th-U; fasc2 2.5.2.4. p7",null,null,6.6,2.0299999999999998]
[103,"Panneaux de particules NF EN 309 ρn 300 à 500kg/m3","270 < ρ ≤ 450",0.13,1700,50,20,0.13,"Règle Th-U; fasc2 2.5.2.4. p7",null,null,6.7,2.04]
[104,"Panneaux de particules NF EN 309 ρn 200 à 300kg/m3","180 < ρ ≤ 270",0.1,1700,50,20,0.1,"Règle Th-U; fasc2 2.5.2.4. p7",null,null,6.8,2.0499999999999998]
[105,"Panneaux de fibres NF EN 316 (1)","750 < ρ ≤ 1 000",0.2,1700,50,20,0.2,"Règle Th-U; fasc2 2.5.2.5. p7",null,null,6.9,2.0649999999999999]
[106,"Panneaux de fibres NF EN 316 (2)","550 < ρ ≤ 750",0.18,1700,30,20,0.18,"Règle Th-U; fasc2 2.5.2.5. p7",null,null,7,2.08]
[107,"Panneaux de fibres NF EN 316 (3)","350 < ρ ≤ 550",0.14000000000000001,1700,20,12,0.14000000000000001,"Règle Th-U; fasc2 2.5.2.5. p7",null,null,7.1,2.0950000000000002]
[108,"Panneaux de fibres NF EN 316 (4)","200 < ρ ≤ 350",0.1,1700,10,6,0.1,"Règle Th-U; fasc2 2.5.2.5. p7",null,null,7.2,2.1]
[109,"Panneaux de fibres NF EN 316 (5)","ρ ≤ 200",7.0000000000000007E-2,1700,5,2,7.0000000000000007E-2,"Règle Th-U; fasc2 2.5.2.5. p7",null,null,7.3,2.1150000000000002]
[110,"Panneaux de laine de bois agglomérés NF EN 13168 (1)","450 ≤ ρ ≤ 550",0.11,1700,20,12,0.11,"Règle Th-U; fasc2 2.5.3. p7",null,null,7.4,2.13]
[111,"Panneaux de laine de bois agglomérés NF EN 13168 (2)","350 ≤ ρ ≤ 450",0.1,1700,10,5,0.1,"Règle Th-U; fasc2 2.5.3. p7",null,null,7.5,2.14]
[112,"Panneaux de laine de bois agglomérés NF EN 13168 (3)","250 ≤ ρ ≤ 350",0.08,1700,10,5,0.08,"Règle Th-U; fasc2 2.5.3. p7",null,null,7.6,2.15]
[113,"Liège (comprimé, expansé pur, expansé aggloméré au brai…","ρ ≤ 500",0.1,1560,10,5,0.1,"Règle Th-U; fasc2 2.5.4. p7",null,null,7.7,2.16]
[114,"Paille comprimée ","300 ≤ ρ ≤ 400",0.12,1400,1,1,0.12,"Règle Th-U; fasc2 2.5.5. p7",null,null,7.8,2.17]
[115,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (1)","15 ≤ ρ < 25",0.05,1030,1,1,0.05,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,7.9,2.1850000000000001]
[116,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (2)","25 ≤ ρ < 40",4.3999999999999997E-2,1030,1,1,4.3999999999999997E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8,2.2000000000000002]
[117,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (3)","40 ≤ ρ < 100",4.2000000000000003E-2,1030,1,1,4.2000000000000003E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8.1,2.21]
[118,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (4)","100 ≤ ρ < 125",4.3999999999999997E-2,1030,1,1,4.3999999999999997E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8.1999999999999993,2.2200000000000002]
[119,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (5)","125 ≤ ρ < 150",4.5999999999999999E-2,1030,1,1,4.5999999999999999E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8.3000000000000007,2.23]
[120,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (6)","150 ≤ ρ < 175",4.7E-2,1030,1,1,4.7E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8.4,2.2400000000000002]
[121,"Matériaux isolants manufacturés / Laines minérales / Laines de roche (7)","175 ≤ ρ < 200",4.8000000000000001E-2,1030,1,1,4.8000000000000001E-2,"Règle Th-U; fasc2 2.6.2.1. p8",null,null,8.5,2.25]
[122,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (1) 7≤ρ<10kg/m3","7≤ρ<10",5.5E-2,1030,1,null,5.5E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,8.6,2.2599999999999998]
[123,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (2) 10≤ρ<15kg/m3","10≤ρ<15",4.7E-2,1030,1,1,4.7E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,8.6999999999999993,2.27]
[124,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (3) 15≤ρ<20kg/m3","15≤ρ<20",4.3999999999999997E-2,1030,1,1,4.3999999999999997E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,8.8000000000000007,2.2799999999999998]
[125,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (4) 20≤ρ<30kg/m3","20≤ρ<30",4.1000000000000002E-2,1030,1,1,4.1000000000000002E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,8.9,2.29]
[126,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (5) 30≤ρ<40kg/m3","30≤ρ<40",3.9E-2,1030,1,1,3.9E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,9,2.2999999999999998]
[127,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (6) 40≤ρ<80kg/m3","40≤ρ<80",3.7999999999999999E-2,1030,1,1,3.7999999999999999E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,9.1,2.31]
[128,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (7) 80≤ρ<120kg/m3","80≤ρ<120",3.9E-2,1030,1,1,3.9E-2,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,9.1999999999999993,2.3199999999999998]
[129,"Matériaux isolants manufacturés / Laines minérales / Laines de verre (8) 120≤ρ<150kg/m3","120≤ρ<150",0.04,1030,1,1,0.04,"Règle Th-U; fasc2 2.6.2.2. p8",null,null,9.3000000000000007,2.33]
[130,"Matériaux isolants manufacturés / Laines minérales en vrac obtenues par soufflage sur plancher de comble","10 à 60",0.06,1030,1,1,0.06,"Règle Th-U; fasc2 2.6.2.3. p8",null,null,9.4,2.34]
[131,"Matériaux isolants manufacturés / Laines minérales obtenues par épandage manuel sur plancher de comble","10 à 60",6.5000000000000002E-2,1030,1,1,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.2.3. p8",null,null,9.5,2.35]
[132,"Matériaux isolants manufacturés / Autres laines minérales",null,6.5000000000000002E-2,1030,1,1,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.2.4. p8",null,null,9.6,2.36]
[133,"Liège expansé pur conforme NF EN 13170(ICB)","100 ≤ ρ ≤ 150",4.9000000000000002E-2,1560,10,5,4.9000000000000002E-2,"Règle Th-U; fasc2 2.6.3. p8",null,null,9.6999999999999993,2.37]
[134,"Liège expansé aggloméré au brai ou aux résines synthétiques (1)","100 ≤ ρ < 150",4.9000000000000002E-2,1560,10,5,4.9000000000000002E-2,"Règle Th-U; fasc2 2.6.3. p8",null,null,9.8000000000000007,2.38]
[135,"Liège expansé aggloméré au brai ou aux résines synthétiques (2)","150 ≤ ρ ≤ 250",5.5E-2,1560,10,5,5.5E-2,"Règle Th-U; fasc2 2.6.3. p8",null,null,9.9,2.39]
[136,"Polystyrène expansé plaques découpées ds blocs NF EN13163(EPS) (1)","7 ≤ ρ < 10",5.6000000000000001E-2,1450,60,60,5.6000000000000001E-2,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,10,2.4]
[137,"Polystyrène expansé plaques découpées ds blocs NF EN13163(EPS) (2)","10 ≤ ρ < 13",0.05,1450,60,60,0.05,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,10.25,2.42]
[138,"Polystyrène expansé plaques découpées ds blocs NF EN13163(EPS) (3)","13 ≤ ρ < 15",4.7E-2,1450,60,60,{"$f":"OFFSET(B143,0,2,1,1)","v":4.7E-2},"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,10.5,2.44]
[139,"Polystyrène expansé plaques moulées en continu NF EN13163(EPS) (1)","15 ≤ ρ < 19",4.3999999999999997E-2,1450,60,60,4.3999999999999997E-2,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,10.75,2.46]
[140,"Polystyrène expansé plaques moulées en continu NF EN13163(EPS) (2)","19 ≤ ρ < 24",4.2000000000000003E-2,1450,60,60,4.2000000000000003E-2,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,11,2.48]
[141,"Polystyrène expansé plaques moulées en continu NF EN13163(EPS) (3)","24 ≤ ρ < 29",0.04,1450,60,60,0.04,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,11.25,2.5]
[142,"Autres plaques moulées à partir de billes (1)","29 ≤ ρ < 40",3.9E-2,1450,60,60,3.9E-2,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,11.5,2.52]
[143,"Autres plaques moulées à partir de billes (2)","40 ≤ ρ < 60",3.7999999999999999E-2,1450,60,60,3.7999999999999999E-2,"Règle Th-U; fasc2 2.6.4.1.1. p9",null,null,11.75,2.54]
[144,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques sans gaz occlus autre que l'air + CO2 <60 mm ","28 ≤ ρ ≤ 40",4.1000000000000002E-2,1450,150,150,4.1000000000000002E-2,"Règle Th-U; fasc2 2.6.4.1.2.1. p9",null,null,12,2.56]
[145,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques sans gaz occlus autre que l'air + CO2 >60 mm ","28 ≤ ρ ≤ 40",4.5999999999999999E-2,1450,150,150,4.5999999999999999E-2,"Règle Th-U; fasc2 2.6.4.1.2.1. p9",null,null,12.25,2.58]
[146,"Polystyrène Plaques extrudées NF EN 13164 (XPS) /plaques expansées avec HCFC (142b/R22)","25 ≤ ρ ≤ 40",3.5000000000000003E-2,1450,150,150,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.1.2.2. p9",null,null,12.5,2.6]
[147,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques expansées aux CFC sans peau de surface","25 ≤ ρ ≤ 40",3.3000000000000002E-2,1450,150,150,3.3000000000000002E-2,"Règle Th-U; fasc2 2.6.4.1.2.3. p9",null,null,12.75,2.62]
[148,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques expansées aux CFC avec peau de surface","25 ≤ ρ ≤ 40",3.1E-2,1450,150,150,3.1E-2,"Règle Th-U; fasc2 2.6.4.1.2.3. p9",null,null,13,2.64]
[149,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques expansées avec HFC 134a ou 152a e≤ 60 mm","25 < ρ ≤ 40",3.9E-2,1450,150,150,3.9E-2,"Règle Th-U; fasc2 2.6.4.1.2.4. p9",null,null,13.25,2.6549999999999998]
[150,"Polystyrène Plaques extrudées NF EN 13164 (XPS) / plaques expansées avec HFC 134a ou 152a e> 60 mm","25 < ρ ≤ 40",4.3999999999999997E-2,1450,150,150,4.3999999999999997E-2,"Règle Th-U; fasc2 2.6.4.1.2.4. p9",null,null,13.5,2.67]
[151,"Polystyrène Plaques expansées autres que ci-dessus","20 ≤ ρ ≤ 60",0.05,1450,150,150,0.05,"Règle Th-U; fasc2 2.6.4.1.3. p9",null,null,13.75,2.6850000000000001]
[152,"mousse rigide de polychlorure de vinyle NFT 56-202  Q2","25 ≤ ρ ≤ 35",3.1E-2,null,null,null,3.1E-2,"Règle Th-U; fasc2 2.6.4.2. p9",null,null,14,2.71]
[153,"mousse rigide de polychlorure de vinyle NFT 56-202  Q3","35 ≤ ρ ≤ 48",3.4000000000000002E-2,null,null,null,3.4000000000000002E-2,"Règle Th-U; fasc2 2.6.4.2. p9",null,null,14.25,2.7250000000000001]
[154,"mousse de polyurethanne ou de polyisocyanurate NF EN 13165 (PUR) / plaques moulées en continu et expansées avec HCFC(141b)et/ou pentanes / revêtements perméables à la diffusion ","27 ≤ ρ ≤ 40",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.1. p9",null,null,14.5,2.74]
[155,"mousse de polyurethanne ou de polyisocyanurate NF EN 13165 (PUR) / plaques moulées en continu et expansées avec HCFC(141b)et/ou pentanes / alu>50μm ou reconnus étanches au gaz","27 ≤ ρ ≤ 40",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.1. p9",null,null,14.75,2.7549999999999999]
[156,"plaques découpées ds blocs moulés et expansés avec HCFC(141b)et/ou pentanes","37 ≤ ρ ≤ 65",4.1000000000000002E-2,1400,60,60,4.1000000000000002E-2,"Règle Th-U; fasc2 2.6.4.3.2. p9",null,null,15,2.77]
[157,"plaques moulées entre 2parements rigides et expansés avec HCFC(141b)et/ou pentanes","37 ≤ ρ ≤ 60",3.2000000000000001E-2,1400,60,60,3.2000000000000001E-2,"Règle Th-U; fasc2 2.6.4.3.3. p9",null,null,15.25,2.7850000000000001]
[158,"plaques moulées entre 2parements rigides et expansés sans gaz autre que l'air + CO2","37 ≤ ρ ≤ 60",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.3. p9",null,null,15.5,2.8]
[159,"plaques moulées en continu projetés sur parement rigide + expansées HCFC et/ou pentanes","30 ≤ ρ ≤ 50",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.4. p9",null,null,15.75,2.8149999999999999]
[160,"plaques moulées en continu ou découpées ds blocs moulés expansés sans gaz autre qu'air + C02","15 ≤ ρ ≤ 30",0.04,1400,60,60,0.04,"Règle Th-U; fasc2 2.6.4.3.5. p10",null,null,16,2.83]
[161,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:AD","30 ≤ ρ < 35",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,16.25,2.8450000000000002]
[162,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:BD","35 ≤ ρ < 40",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,16.5,2.86]
[163,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:CD","40 ≤ ρ < 50",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,16.75,2.875]
[164,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:DD","50 ≤ ρ < 60",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,17,2.89]
[165,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:ED","60 ≤ ρ < 70",0.04,1400,60,60,0.04,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,17.25,2.9049999999999998]
[166,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:FD","70 ≤ ρ < 100",4.4999999999999998E-2,1400,60,60,4.4999999999999998E-2,"Règle Th-U; fasc2 2.6.4.3.6. p10",null,null,17.5,2.92]
[167,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:AC","29 ≤ ρ < 31",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,17.75,2.93]
[168,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:BC","31 ≤ ρ < 33",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,18,2.94]
[169,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:CC","33 ≤ ρ < 37",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,18.25,2.9550000000000001]
[170,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:DC","37 ≤ ρ < 46",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,18.5,2.97]
[171,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:EC","46 ≤ ρ < 56",3.5000000000000003E-2,1400,60,60,3.5000000000000003E-2,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,18.75,2.9849999999999999]
[172,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:FC","56 ≤ ρ < 66",0.04,1400,60,60,0.04,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,19,3]
[173,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:GC","66 ≤ ρ < 75",0.04,1400,60,60,0.04,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,19.25,3.01]
[174,"Plaques NF T 56-203 découpées ds blocs moulés en discontinu avec CFC   réf:HC","75 ≤ ρ < 100",4.4999999999999998E-2,1400,60,60,4.4999999999999998E-2,"Règle Th-U; fasc2 2.6.4.3.7. p10",null,null,19.5,3.02]
[175,"Plaques moulées en continu avec CFC","27 ≤ ρ ≤ 35",0.03,1400,60,60,0.03,"Règle Th-U; fasc2 2.6.4.3.8. p10",null,null,19.75,3.03]
[176,"Plaques expansées à base de polyuréthanne autres que ci-dessus","20 ≤ ρ < 60",0.05,1400,60,60,0.05,"Règle Th-U; fasc2 2.6.4.3.9. p10",null,null,20,3.04]
[177,"Mousse phénolique rigide en continu expansés aux HCFC(141b) et ou LBL2/pentanes","30 ≤ ρ ≤ 45",0.03,1400,50,50,0.03,"Règle Th-U; fasc2 2.6.4.4.1. p10",null,null,20.25,3.0550000000000002]
[178,"Panneaux à base de mousse phénolique non cités ci-dessus","30 ≤ ρ ≤ 60",0.05,1400,50,50,0.05,"Règle Th-U; fasc2 2.6.4.4.2. p10",null,null,20.5,3.07]
[179,"Autres matières plastiques alvéolaires fabriquées en usine","7 ≤ ρ ≤ 100",6.5000000000000002E-2,null,null,null,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.4.5. p10",null,null,20.75,3.085]
[180,"Plaques à base de perlite expansée et de fibres > à 80% (1)","220 ≤ ρ ≤ 275",6.2E-2,900,5,5,6.2E-2,"Règle Th-U; fasc2 2.6.5.1. p10",null,null,21,3.09]
[181,"Plaques à base de perlite expansée et de fibres > à 80% (2)","180 ≤ ρ ≤ 220",0.06,900,5,5,0.06,"Règle Th-U; fasc2 2.6.5.1. p10",null,null,21.25,3.1]
[182,"Plaques à base de perlite expansée et de fibres > à 80% (3)","150 ≤ ρ ≤ 180",5.8999999999999997E-2,900,5,5,5.8999999999999997E-2,"Règle Th-U; fasc2 2.6.5.1. p10",null,null,21.5,3.11]
[183,"Plaque à base de perlite expansée + cellulose agglomérées non cités ci-dessus","140 ≤ ρ < 260",6.4000000000000001E-2,null,null,null,6.4000000000000001E-2,"Règle Th-U; fasc2 2.6.5.2. p10",null,null,21.75,3.125]
[184,"Plaques homogènes de verre cellulaires (>1978) (1)","110 ≤ ρ ≤ 140",5.0999999999999997E-2,1000,null,null,5.0999999999999997E-2,"Règle Th-U; fasc2 2.6.6. p10",null,null,22,3.14]
[185,"Plaques homogènes de verre cellulaires (>1978) (2)","140 < ρ ≤ 180",5.7000000000000002E-2,1000,null,null,5.7000000000000002E-2,"Règle Th-U; fasc2 2.6.6. p10",null,null,22.25,3.15]
[186,"Produits manufacturés à base de fibres végétales (laine de chanvre…) (1)","20 ≤ ρ < 40",6.5000000000000002E-2,1600,1,1,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.7. p10",null,null,22.5,3.16]
[187,"Produits manufacturés à base de fibres végétales (laine de chanvre…) (2)","40 ≤ ρ < 60",0.06,1600,1,1,0.06,"Règle Th-U; fasc2 2.6.7. p10",null,null,22.75,3.17]
[188,"Produits manufacturés à base de fibres végétales (laine de chanvre…) (3)","60 ≤ ρ < 200",6.5000000000000002E-2,1600,1,1,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.7. p10",null,null,23,3.18]
[189,"Produits manufacturés à base de fibres animales (laine de mouton…) (1)","10 ≤ ρ < 20",6.5000000000000002E-2,1600,1,1,6.5000000000000002E-2,"Règle Th-U; fasc2 2.6.8. p10",null,null,23.25,3.19]
[190,"Produits manufacturés à base de fibres animales (laine de mouton…) (2)","20 ≤ ρ < 50",0.06,1600,1,1,0.06,"Règle Th-U; fasc2 2.6.8. p10",null,null,23.5,3.2]
[191,"Produits manufacturés à base de fibres animales (laine de mouton…) (3)","50 ≤ ρ < 100",0.05,null,null,null,0.05,"Règle Th-U; fasc2 2.6.8. p10",null,null,23.75,3.21]
[192,"Matières plastiques synthétiques compactes, mastics et produits d'étanchéité – naturel",910,0.13,1100,10000,10000,0.13,"Règle Th-U; fasc2 2.7.1. p11",null,null,24,3.22]
[193,"– néoprène (polychloroprène)",1240,0.23,2140,10000,10000,0.23,"Règle Th-U; fasc2 2.7.1. p11",null,null,24.25,3.23]
[194,"– butyle (iso butène), plein/coulé à chaud",1200,0.24,1400,200000,200000,0.24,"Règle Th-U; fasc2 2.7.1. p11",null,null,24.5,3.24]
[195,"– caoutchouc mousse","60-80",0.06,1500,7000,7000,0.06,"Règle Th-U; fasc2 2.7.1. p11",null,null,24.75,3.25]
[196,"– caoutchouc dur (ébonite), plein",1200,0.17,1400,null,null,0.17,"Règle Th-U; fasc2 2.7.1. p11",null,null,25,3.26]
[197,"– éthylène propylène diène monomère (EPDM)",1150,0.25,1000,6000,6000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,25.25,3.27]
[198,"– polyisobuthylène",930,0.2,1100,10000,10000,0.2,"Règle Th-U; fasc2 2.7.1. p11",null,null,25.5,3.28]
[199,"– polysulfure",1700,0.4,1000,10000,10000,0.4,"Règle Th-U; fasc2 2.7.1. p11",null,null,25.75,3.29]
[200,"– butadiène",980,0.25,1000,100000,100000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,26,3.3]
[201,"– acryliques",1050,0.2,1500,10000,10000,0.2,"Règle Th-U; fasc2 2.7.1. p11",null,null,26.25,3.3050000000000002]
[202,"– poly carbonates",1200,0.2,1200,5000,5000,{"$f":"OFFSET(B207,0,2,1,1)","v":0.2},"Règle Th-U; fasc2 2.7.1. p11",null,null,26.5,3.31]
[203,"– polytétrafl uoréthylène (PTFE)",2200,0.25,1000,10000,10000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,26.75,3.32]
[204,"– chlorure de polyvinyle (PVC)",1390,0.17,1900,50000,50000,0.17,"Règle Th-U; fasc2 2.7.1. p11",null,null,27,3.33]
[205,"– polyméthylméthacrylate (PMMA)",1180,0.18,1500,50000,50000,0.18,"Règle Th-U; fasc2 2.7.1. p11",null,null,27.25,3.34]
[206,"– poly acétate",1410,0.3,1400,100000,100000,0.3,"Règle Th-U; fasc2 2.7.1. p11",null,null,27.5,3.35]
[207,"– polyamide (nylon)",1150,0.25,1600,50000,50000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,27.75,3.36]
[208,"– polyamide 6.6 avec 25 % de fibre de verre",1450,0.3,1600,50000,50000,0.3,"Règle Th-U; fasc2 2.7.1. p11",null,null,28,3.37]
[209,"– polyéthylène/polythène, haute densité",980,0.5,1800,100000,100000,0.5,"Règle Th-U; fasc2 2.7.1. p11",null,null,28.25,3.375]
[210,"– polyéthylène/polythène, basse densité",920,0.33,2200,100000,100000,0.33,"Règle Th-U; fasc2 2.7.1. p11",null,null,28.5,3.38]
[211,"– polystyrène",1050,0.16,1300,100000,100000,0.16,"Règle Th-U; fasc2 2.7.1. p11",null,null,28.75,3.39]
[212,"– polypropylène",910,0.22,1800,10000,10000,0.22,"Règle Th-U; fasc2 2.7.1. p11",null,null,29,3.4]
[213,"– polypropylène avec 25 % de fibre de verre",1200,0.25,1800,10000,10000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,29.25,3.41]
[214,"– polyuréthane (PU)",1200,0.25,1800,6000,6000,0.25,"Règle Th-U; fasc2 2.7.1. p11",null,null,29.5,3.42]
[215,"– résine époxy",1200,0.2,1400,10000,10000,0.2,"Règle Th-U; fasc2 2.7.1. p11",null,null,29.75,3.4249999999999998]
[216,"– résine phénolique",1300,0.3,1700,100000,100000,0.3,"Règle Th-U; fasc2 2.7.1. p11",null,null,30,3.43]
[217,"– résine polyester",1400,0.19,1200,10000,10000,0.19,"Règle Th-U; fasc2 2.7.1. p11",null,null,30.25,3.44]
[218,"Mastics pour joints, étanchéité et coupure thermique – silicagel (dessicatif)",720,0.13,1000,null,null,0.13,"Règle Th-U; fasc2 2.7.2. p11",null,null,30.5,3.45]
[219,"– silicone pur",1200,0.35,1000,5000,5000,0.35,"Règle Th-U; fasc2 2.7.2. p11",null,null,30.75,3.46]
[220,"– silicone mastic",1450,0.5,1000,5000,5000,0.5,"Règle Th-U; fasc2 2.7.2. p11",null,null,31,3.47]
[221,"– mousse de silicone",750,0.12,1000,10000,10000,0.12,"Règle Th-U; fasc2 2.7.2. p11",null,null,31.25,3.4750000000000001]
[222,"– uréthane polyuréthane (coupure thermique)",1300,0.21,1800,60,60,0.21,"Règle Th-U; fasc2 2.7.2. p11",null,null,31.5,3.48]
[223,"– chlorure de polyvinyle fl exible avec 40 % de plastifi ant",1200,0.14000000000000001,1000,100000,100000,0.14000000000000001,"Règle Th-U; fasc2 2.7.2. p11",null,null,31.75,3.49]
[224,"– mousse élastomère flexible","60-80",0.05,1500,10000,10000,0.05,"Règle Th-U; fasc2 2.7.2. p11",null,null,32,3.5]
[225,"– mousse de polyuréthane (PU)",70,0.05,1500,60,60,0.05,"Règle Th-U; fasc2 2.7.2. p11",null,null,32.25,3.5049999999999999]
[226,"– mousse de polyéthylène",70,0.05,2300,100,100,0.05,"Règle Th-U; fasc2 2.7.2. p11",null,null,32.5,3.51]
[227,"Produits d'étanchéité / Asphalte pur ","ρ ≤ 2 100",0.7,1000,50000,50000,0.7,"Règle Th-U; fasc2 2.7.3.1. p11",null,null,32.75,3.52]
[228,"Produits d'étanchéité / Asphalte sablé","ρ ≤ 2 100",1.1499999999999999,1000,null,null,1.1499999999999999,"Règle Th-U; fasc2 2.7.3.1. p11",null,null,33,3.53]
[229,"Bitume pur ","ρ ≤ 1 050",0.17,1000,50000,50000,0.17,"Règle Th-U; fasc2 2.7.3.2. p11",null,null,33.25,3.5350000000000001]
[230,"Bitume – cartons feutres et chapes souples imprégnées","1 000 ≤ ρ ≤ 1 100",0.23,1000,50000,50000,0.23,"Règle Th-U; fasc2 2.7.3.2. p11",null,null,33.5,3.54]
[231,"– aluminium",2700,230,880,null,null,230,"Règle Th-U; fasc2 2.8. p12",null,null,33.75,3.55]
[232,"– alliages d’aluminium",2800,160,880,null,null,160,"Règle Th-U; fasc2 2.8. p12",null,null,34,3.56]
[233,"– bronze",8700,65,380,null,null,65,"Règle Th-U; fasc2 2.8. p12",null,null,34.25,3.5649999999999999]
[234,"– laiton",8400,120,380,null,null,120,"Règle Th-U; fasc2 2.8. p12",null,null,34.5,3.57]
[235,"– cuivre",8900,380,380,null,null,380,"Règle Th-U; fasc2 2.8. p12",null,null,34.75,3.5750000000000002]
[236,"– fer pur",7870,72,450,null,null,72,"Règle Th-U; fasc2 2.8. p12",null,null,35,3.58]
[237,"– fer, fonte",7500,50,450,null,null,50,"Règle Th-U; fasc2 2.8. p12",null,null,35.25,3.59]
[238,"– plomb",11300,35,130,null,null,35,"Règle Th-U; fasc2 2.8. p12",null,null,35.5,3.6]
[239,"– acier",7800,50,450,null,null,50,"Règle Th-U; fasc2 2.8. p12",null,null,35.75,3.605]
[240,"– acier inoxydable",7900,17,460,null,null,17,"Règle Th-U; fasc2 2.8. p12",null,null,36,3.61]
[241,"– zinc",7200,110,380,null,null,110,"Règle Th-U; fasc2 2.8. p12",null,null,36.25,3.6150000000000002]
[242,"– Sables et graviers","1 700 ≤ ρ ≤ 2 200",2,"910-1180",50,50,2,"Règle Th-U; fasc2 2.9.1.1. p12",null,null,36.5,3.62]
[243,"– argile ou limon ","1 200 ≤ ρ ≤ 1 800",1.5,"1 670-2 500",50,50,1.5,"Règle Th-U; fasc2 2.9.1.1. p12",null,null,36.75,3.63]
[244,"Pisé, bauge, béton de terre stabilisé, blocs de terre comprimée","1 770 ≤ ρ ≤ 2 000",1.1000000000000001,null,null,null,1.1000000000000001,"Règle Th-U; fasc2 2.9.1.2. p12",null,null,37,3.64]
[245,"revêtements de sols – caoutchouc",1200,0.17,1400,10000,10000,0.17,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,37.25,3.645]
[246,"– plastique",1700,0.25,1400,10000,10000,0.25,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,37.5,3.65]
[247,"– sous couche, caoutchouc-mousse ou plastique cellulaire",270,0.1,1400,10000,10000,0.1,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,37.75,3.6549999999999998]
[248,"– sous-couche feutre",120,0.05,1300,20,15,0.05,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,38,3.66]
[249,"– sous-couche laine",200,0.06,1300,20,15,0.06,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,38.25,3.67]
[250,"– sous-couche liège","ρ < 200",0.05,1500,20,10,0.05,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,38.5,3.68]
[251,"– plaque de liège","ρ > 400",6.5000000000000002E-2,1500,40,20,6.5000000000000002E-2,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,38.75,3.6850000000000001]
[252,"– tapis, revêtement textile",200,0.06,1300,5,5,0.06,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,39,3.69]
[253,"– linoléum",1200,0.17,1400,1000,800,0.17,"Règle Th-U; fasc2 2.9.1.3. p12",null,null,39.25,3.6949999999999998]
[254,"Mortiers d'enduits et de joints de ciment ou de chaux (1)","ρ > 2000",1.8,1000,10,6,1.8,"Règle Th-U; fasc2 2.9.2. p12",null,null,39.5,3.7]
[255,"Mortiers d'enduits et de joints de ciment ou de chaux (2)","1 800 < ρ ≤ 2 000",1.3,1000,10,6,1.3,"Règle Th-U; fasc2 2.9.2. p12",null,null,39.75,3.7050000000000001]
[256,"Mortiers d'enduits et de joints de ciment ou de chaux (3)","1 600 < ρ ≤ 1 800",1,1000,10,6,1,"Règle Th-U; fasc2 2.9.2. p12",null,null,40,3.71]
[257,"Mortiers d'enduits et de joints de ciment ou de chaux (4) ","1 450 < ρ ≤ 1 600",0.8,1000,10,6,0.8,"Règle Th-U; fasc2 2.9.2. p12",null,null,40.5,3.7250000000000001]
[258,"Mortiers d'enduits et de joints de ciment ou de chaux (5)","1 250 < ρ ≤ 1 450",0.7,1000,10,6,0.7,"Règle Th-U; fasc2 2.9.2. p12",null,null,41,3.74]
[259,"Mortiers d'enduits et de joints de ciment ou de chaux (6)","1 000 < ρ ≤ 1 250",0.55000000000000004,1000,10,6,0.55000000000000004,"Règle Th-U; fasc2 2.9.2. p12",null,null,41.5,3.75]
[260,"Mortiers d'enduits et de joints de ciment ou de chaux (7)","750 < ρ ≤ 1 000",0.4,1000,10,6,0.4,"Règle Th-U; fasc2 2.9.2. p12",null,null,42,3.76]
[261,"Mortiers d'enduits et de joints de ciment ou de chaux (8)","500 < ρ ≤ 750",0.3,1000,10,6,0.3,"Règle Th-U; fasc2 2.9.2. p12",null,null,42.5,3.77]
[262,"Fibres-ciment (1)","1 800 < ρ ≤ 2 200",0.95,null,null,null,0.95,"Règle Th-U; fasc2 2.9.3.1. p12",null,null,43,3.78]
[263,"Fibres-ciment (2)","1 400 ≤ ρ ≤ 1 800",0.65,null,null,null,0.65,"Règle Th-U; fasc2 2.9.3.1. p12",null,null,43.5,3.79]
[264,"Fibres-ciment cellulose (1)","1 400 < ρ ≤ 1 800",0.46,null,null,null,0.46,"Règle Th-U; fasc2 2.9.3.2. p12",null,null,44,3.81]
[265,"Fibres-ciment cellulose (2)","1 000 ≤ ρ ≤ 1 400",0.35,null,null,null,0.35,"Règle Th-U; fasc2 2.9.3.2. p12",null,null,44.5,3.82]
[266,"Plaques à base de vermiculite agglomérées aux silicates (1)","400 < ρ ≤ 500",0.19,null,null,null,{"$f":"OFFSET(B271,0,2,1,1)","v":0.19},"Règle Th-U; fasc2 2.9.4. p13",null,null,45,3.83]
[267,"Plaques à base de vermiculite agglomérées aux silicates (2)","300 < ρ ≤ 400",0.14000000000000001,null,null,null,0.14000000000000001,"Règle Th-U; fasc2 2.9.4. p13",null,null,45.5,3.84]
[268,"Plaques à base de vermiculite agglomérées aux silicates (3)","200 < ρ ≤ 300",0.1,null,null,null,0.1,"Règle Th-U; fasc2 2.9.4. p13",null,null,46,3.85]
[269,"– verre sodo-calciare (y compris le verre flotté)",2500,1,750,null,null,1,"Règle Th-U; fasc2 2.9.5. p13",null,null,46.5,3.86]
[270,"– quartz",2200,1.4,750,null,null,1.4,"Règle Th-U; fasc2 2.9.5. p13",null,null,47,3.87]
[271,"– pâte de verre",2000,1.2,750,null,null,1.2,"Règle Th-U; fasc2 2.9.5. p13",null,null,47.5,3.88]
[272,"– air",1.23,2.5000000000000001E-2,1008,1,1,2.5000000000000001E-2,"Règle Th-U; fasc2 2.9.7. p13",null,null,48,3.89]
[273,"– dioxyde de carbone",1.95,1.4E-2,820,1,1,1.4E-2,"Règle Th-U; fasc2 2.9.7. p13",null,null,48.5,3.9]
[274,"– argon",1.7,1.7000000000000001E-2,519,1,1,1.7000000000000001E-2,"Règle Th-U; fasc2 2.9.7. p13",null,null,49,3.91]
[275,"– hexafl uorure de soufre",6.36,1.2999999999999999E-2,614,1,1,1.2999999999999999E-2,"Règle Th-U; fasc2 2.9.7. p13",null,null,49.5,3.92]
[276,"– krypton",3.56,8.9999999999999993E-3,245,1,1,8.9999999999999993E-3,"Règle Th-U; fasc2 2.9.7. p13",null,null,50,3.93]
[277,"– xénon",5.68,5.4000000000000003E-3,160,1,1,5.4000000000000003E-3,"Règle Th-U; fasc2 2.9.7. p13",null,null,50.55,3.94]
[278,"– glace à -10 °C",920,2.2999999999999998,2000,null,null,2.2999999999999998,"Règle Th-U; fasc2 2.9.8. p13",null,null,51,3.95]
[279,"– glace à 0 °C",900,2.2000000000000002,2000,null,null,2.2000000000000002,"Règle Th-U; fasc2 2.9.8. p13",null,null,51.5,3.96]
[280,"– neige fraîchement tombée (< 30 mm)",100,0.05,2000,null,null,0.05,"Règle Th-U; fasc2 2.9.8. p13",null,null,52,3.97]
[281,"– neige souple (30-70 mm)",200,0.12,2000,null,null,0.12,"Règle Th-U; fasc2 2.9.8. p13",null,null,52.5,3.98]
[282,"– neige légèrement comprimée (70-100 mm)",300,0.23,2000,null,null,0.23,"Règle Th-U; fasc2 2.9.8. p13",null,null,53,3.99]
[283,"– neige compactée (< 200 mm)",500,0.6,2000,null,null,0.6,"Règle Th-U; fasc2 2.9.8. p13",null,null,53.5,4]
[284,"– eau à 10 °C",1000,0.6,4190,null,null,0.6,"Règle Th-U; fasc2 2.9.8. p13",null,null,54,4.01]
[285,"– eau à 40 °C",990,0.63,4190,null,null,0.63,"Règle Th-U; fasc2 2.9.8. p13",null,null,54.5,4.0199999999999996]
[286,"– eau à 80 °C",970,0.67,4190,null,null,0.67,"Règle Th-U; fasc2 2.9.8. p13",null,null,55,4.03]
[null,null,null,null,null,null,null,null,null,null,null,55.5,4.0350000000000001]
[null,null,null,null,null,null,null,null,null,null,null,56,4.04]
[null,null,null,null,null,null,null,null,null,null,null,56.5,4.05]
[null,null,null,null,null,null,null,null,null,null,null,57,4.0599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,57.5,4.07]
[null,null,null,null,null,null,null,null,null,null,null,58,4.08]
[null,null,null,null,null,null,null,null,null,null,null,58.5,4.085]
[null,null,null,null,null,null,null,null,null,null,null,59,4.09]
[null,null,null,null,null,null,null,null,null,null,null,59.5,4.0999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,60,4.1100000000000003]
[null,null,null,null,null,null,null,null,null,null,null,60.5,4.12]
[null,null,null,null,null,null,null,null,null,null,null,61,4.13]
[null,null,null,null,null,null,null,null,null,null,null,61.5,4.1349999999999998]
[null,null,null,null,null,null,null,null,null,null,null,62,4.1399999999999997]
[null,null,null,null,null,null,null,null,null,null,null,62.5,4.1500000000000004]
[null,null,null,null,null,null,null,null,null,null,null,63,4.16]
[null,null,null,null,null,null,null,null,null,null,null,63.5,4.165]
[null,null,null,null,null,null,null,null,null,null,null,64,4.17]
[null,null,null,null,null,null,null,null,null,null,null,64.5,4.18]
[null,null,null,null,null,null,null,null,null,null,null,65,4.1900000000000004]
[null,null,null,null,null,null,null,null,null,null,null,65.5,4.1950000000000003]
[null,null,null,null,null,null,null,null,null,null,null,66,4.2]
[null,null,null,null,null,null,null,null,null,null,null,66.5,4.21]
[null,null,null,null,null,null,null,null,null,null,null,67,4.22]
[null,null,null,null,null,null,null,null,null,null,null,67.5,4.2249999999999996]
[null,null,null,null,null,null,null,null,null,null,null,68,4.2300000000000004]
[null,null,null,null,null,null,null,null,null,null,null,68.5,4.24]
[null,null,null,null,null,null,null,null,null,null,null,69,4.25]
[null,null,null,null,null,null,null,null,null,null,null,69.5,4.2549999999999999]
[null,null,null,null,null,null,null,null,null,null,null,70,4.26]
[null,null,null,null,null,null,null,null,null,null,null,70.5,4.2699999999999996]
[null,null,null,null,null,null,null,null,null,null,null,71,4.28]
[null,null,null,null,null,null,null,null,null,null,null,71.5,4.2850000000000001]
[null,null,null,null,null,null,null,null,null,null,null,72,4.29]
[null,null,null,null,null,null,null,null,null,null,null,72.5,4.2949999999999999]
[null,null,null,null,null,null,null,null,null,null,null,73,4.3]
[null,null,null,null,null,null,null,null,null,null,null,73.5,4.3099999999999996]
[null,null,null,null,null,null,null,null,null,null,null,74,4.32]
[null,null,null,null,null,null,null,null,null,null,null,74.5,4.3250000000000002]
[null,null,null,null,null,null,null,null,null,null,null,75,4.33]
[null,null,null,null,null,null,null,null,null,null,null,75.5,4.335]
[null,null,null,null,null,null,null,null,null,null,null,76,4.34]
[null,null,null,null,null,null,null,null,null,null,null,76.5,4.3499999999999996]
[null,null,null,null,null,null,null,null,null,null,null,77,4.3600000000000003]
[null,null,null,null,null,null,null,null,null,null,null,77.5,4.3650000000000002]
[null,null,null,null,null,null,null,null,null,null,null,78,4.37]
[null,null,null,null,null,null,null,null,null,null,null,78.5,4.375]
[null,null,null,null,null,null,null,null,null,null,null,79,4.38]
[null,null,null,null,null,null,null,null,null,null,null,79.5,4.3849999999999998]
[null,null,null,null,null,null,null,null,null,null,null,80,4.3899999999999997]
[null,null,null,null,null,null,null,null,null,null,null,80.5,4.4000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,81,4.41]
[null,null,null,null,null,null,null,null,null,null,null,81.5,4.415]
[null,null,null,null,null,null,null,null,null,null,null,82,4.42]
[null,null,null,null,null,null,null,null,null,null,null,82.5,4.4249999999999998]
[null,null,null,null,null,null,null,null,null,null,null,83,4.43]
[null,null,null,null,null,null,null,null,null,null,null,83.5,4.4349999999999996]
[null,null,null,null,null,null,null,null,null,null,null,84,4.4400000000000004]
[null,null,null,null,null,null,null,null,null,null,null,84.5,4.4450000000000003]
[null,null,null,null,null,null,null,null,null,null,null,85,4.45]
[null,null,null,null,null,null,null,null,null,null,null,85.5,4.46]
[null,null,null,null,null,null,null,null,null,null,null,86,4.47]
[null,null,null,null,null,null,null,null,null,null,null,86.5,4.4749999999999996]
[null,null,null,null,null,null,null,null,null,null,null,87,4.4800000000000004]
[null,null,null,null,null,null,null,null,null,null,null,87.5,4.4850000000000003]
[null,null,null,null,null,null,null,null,null,null,null,88,4.49]
[null,null,null,null,null,null,null,null,null,null,null,88.5,4.4950000000000001]
[null,null,null,null,null,null,null,null,null,null,null,89,4.5]
[null,null,null,null,null,null,null,null,null,null,null,89.5,4.5049999999999999]
[null,null,null,null,null,null,null,null,null,null,null,90,4.51]
[null,null,null,null,null,null,null,null,null,null,null,90.5,4.5149999999999997]
[null,null,null,null,null,null,null,null,null,null,null,91,4.5199999999999996]
[null,null,null,null,null,null,null,null,null,null,null,91.5,4.5250000000000004]
[null,null,null,null,null,null,null,null,null,null,null,92,4.53]
[null,null,null,null,null,null,null,null,null,null,null,92.5,4.5350000000000001]
[null,null,null,null,null,null,null,null,null,null,null,93,4.54]
[null,null,null,null,null,null,null,null,null,null,null,93.5,4.5449999999999999]
[null,null,null,null,null,null,null,null,null,null,null,94,4.55]
[null,null,null,null,null,null,null,null,null,null,null,94.5,4.5549999999999997]
[null,null,null,null,null,null,null,null,null,null,null,95,4.5599999999999996]
[null,null,null,null,null,null,null,null,null,null,null,95.5,4.5650000000000004]
[null,null,null,null,null,null,null,null,null,null,null,96,4.57]
[null,null,null,null,null,null,null,null,null,null,null,96.5,4.5750000000000002]
[null,null,null,null,null,null,null,null,null,null,null,97,4.58]
[null,null,null,null,null,null,null,null,null,null,null,97.5,4.585]
[null,null,null,null,null,null,null,null,null,null,null,98,4.59]
[null,null,null,null,null,null,null,null,null,null,null,98.5,4.5949999999999998]
[null,null,null,null,null,null,null,null,null,null,null,99,4.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,99.5,4.6100000000000003]
[null,null,null,null,null,null,null,null,null,null,null,100,4.62]

{"sheet":"local 1","index":2,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[8,6,10,6],[45,0,46,0],[15,15,16,15],[0,1,0,10],[15,1,15,4],[15,6,15,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,5,16,5],[45,1,45,4],[45,8,46,8],[15,13,16,13],[15,14,16,14],[45,5,45,6],[45,7,46,7],[40,7,40,9],[65,8,65,9],[45,14,46,14],[45,15,46,15],[45,9,46,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[45,13,46,13]]}
[null,{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}}]
[null,"Date :",{"$f":"TODAY()","v":"2013-01-28"}]
[null,"Affaire :"]
[null,"Localité :"]
[null,"Hauteur du batiment (en m) :",null,null,null,null,"Température ext. de base (°C) :",-9,"Notes:"]
[null,"Dénivellation yo (en m):",null,null,null,null,"Région (H1,H2,H3) : "]
[null,"Hauteur au sol (en m) :"]
[null,null,null,null,null,null,"Température intérieure (°C) :",19]
[null,"Local :",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},"Surface (en m²) :",null,50,"Renouvellement d'air :","n en vol/h",2,"tri = "]
[null,"N°:",null,"Hauteur (en m) :",null,2.5,null,"n.V en m3/h",{"$f":"$I$9*$F$11","v":250},"tai = "]
[null,"Type chauffage (C/R)",null,"Volume (en m3) :",null,{"$f":"F9*F10","v":125}]
[]
[]
[null," Pertes statiques :"]
[]
[null,"Désignation",null,null,null,"Nbre","Dimensions",null,"Surface/Long.",null,"U ou ψ (en W/m².K)","C2","Δt(°C ou K)","bu","Pertes","Références"]
[null,"Repère paroi","Indication ","te (en °C)","Or.",null,"Largeur (en m)","Haut/Long (en m)","Brute (m²/m)","Nette (m²/m)"]
[null,"ME",null,{"$f":"$H$5","v":-9},null,1,35,2.5,{"$f":"$G18*$H18*$F18","v":87.5},{"$f":"IF(OR(B19=\"FE\",B19=\"PO\"),IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),I18-I19-I20-I21,I18-I19-I20),I18-I19),I18)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\")),+I19)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)","v":82.399999999999991},0.35,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N18*$M18*$K18*$J18","v":807.51999999999987}]
[null,"FE",null,{"$f":"$H$5","v":-9},null,2,1.5,1.4,{"$f":"$G19*$H19*$F19","v":4.1999999999999993},{"$f":"IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),IF(OR(B22=\"FE\",B22=\"PO\"),I19-I20-I21-I22,I19-I20-I21),I19-I20),I19)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\"),OR(B21=\"FE\",B21=\"PO\")),+I21)","v":4.1999999999999993},2.7,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N19*$M19*$K19*$J19","v":317.52}]
[null,"PO",null,{"$f":"$H$5","v":-9},null,1,0.9,1,{"$f":"$G20*$H20*$F20","v":0.9},0.9,1.8,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N20*$M20*$K20*$J20","v":45.36}]
[null,"PT",null,{"$f":"$H$5","v":-9},null,1,1,2.5,{"$f":"$G21*$H21*$F21","v":2.5},2.5,7.0000000000000007E-2,1,28,1,4.9000000000000004]
[null,"PT",null,-9,null,1,1,2.5,2.5,2.5,0.02,1,28,1,1.4000000000000001]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,"légende: ME = mur ; FE = fenêtre ; PO = porte ; PLH = plancher-haut ; PLB = plancher-bas ; PT = Pont Thermique"]
[null,null,null,null,null,null,null,"Total déperditions [statiques et aérauliques] (en W)",null,null,"Total pertes parois (en W) :",null,{"$f":"SUM(O18:O39)","v":1176.7}]
[null,null,null,null,"Σ∏",{"$f":"J64+'local 2'!J64+'local 3'!J64+'local 4'!J64+'local 5'!J64+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,"local ",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},{"$f":"$M$43+$M$68","v":1176.7},"k (coef pont thermiques) en%",null,0]
[null,null,null,null,null,null,null,null,null,null,"Total pertes parois+ponts (en W) :",null,{"$f":"((M41*M42)/100)+M41","v":1176.7}]
[null,"pertes aérauliques :"]
[]
["Types d'ouvertures ","Désignation",null,null,null,"Dimensions",null,"Coefficients","Surface ou linéaire","Perméabilité","U (en W/m².K)","Débit (m3/h)","Δt(°C ou K)","b","Pertes","Références"]
[null,"Repère type ","Te(°C)","0r.","Nbre","Largeur (en m)","Haut/long (en m)"]
["Entrée d'air module 15",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation1,source1,2,FALSE),0)","v":3.4},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Coffre\"),$G48,$F48*$G48),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Entrée\"),$E48*$H48,$I48*$H48*$E48),\"/\")","v":3.4},1,null,{"$f":"$H$8-$C48","v":28},1,{"$f":"IFERROR(IF($J48>0,$K48*$M48*$N48*$M$66*($J48/$F$42),$I$10*$K48*$M48),0)","v":0}]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation2,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Coffre\"),$G49,$F49*$G49),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Entrée\"),$E49*$H49,$I49*$H49*$E49),\"/\")","v":0},null,null,{"$f":"$H$8-$C49","v":28},1,{"$f":"IFERROR(IF($J49>0,$K49*$M49*$N49*$M$66*($J49/$F$42),$I$10*$K49*$M49),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation3,source1,2,FALSE),0)","v":0},0,{"$f":"IFERROR(IF(EXACT(LEFT($A50,6),\"Entrée\"),$E50*$H50,$I50*$H50*$E50),\"/\")","v":0},null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation4,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation5,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation6,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation7,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation8,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation9,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation10,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation11,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation12,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation13,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation14,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation15,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation16,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,0]
[null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(J48:J63)","v":3.4}]
[null,null,null,null,null,null,null,null,null,null,"Débit réglementaire (en m3/h) :",null,130]
[null,null,null,null,null,null,null,null,"Ventilation naturelle",null,"Coefficient :",{"$f":"IFERROR(VLOOKUP(designation17,typeventil,2,FALSE),0)","v":1.3},{"$f":"$M$65*$L$66","v":169}]
[null,null,null,null,null,null,null,null,null,null,"n.V - Débit rég. (en m3/h)",null,{"$f":"I10-M65","v":120}]
[null,null,null,null,null,null,null,null,null,null,"Total pertes aérauliques (en W) :",null,{"$f":"SUM(O48:O63)","v":0}]

{"sheet":"local 2","index":3,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[40,7,40,9],[0,1,0,10],[8,6,10,6],[15,1,15,4],[15,5,16,5],[15,6,15,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[45,14,46,14],[45,15,46,15],[45,0,46,0],[45,1,45,4],[45,5,45,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[65,8,65,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[45,13,46,13]]}
[null,{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}}]
[null,"Date :",{"$f":"TODAY()","v":"2013-01-28"}]
[null,"Affaire :"]
[null,"Localité :"]
[null,"Hauteur du batiment (en m) :",null,null,null,null,"Température ext. de base (°C) :",-9,"Notes:"]
[null,"Dénivellation yo (en m):",null,null,null,null,"Région (H1,H2,H3) : "]
[null,"Hauteur au sol (en m) :"]
[null,null,null,null,null,null,"Température intérieure (°C) :",19]
[null,"Local :",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},"Surface (en m²) :",null,15,"Renouvellement d'air :","n en vol/h",2,"tri = "]
[null,"N°:",null,"Hauteur (en m) :",null,2.5,null,"n.V en m3/h",{"$f":"$I$9*$F$11","v":75},"tai = "]
[null,"Type chauffage (C/R)",null,"Volume (en m3) :",null,{"$f":"F9*F10","v":37.5}]
[]
[]
[null," Pertes statiques :"]
[]
[null,"Désignation",null,null,null,"Nbre","Dimensions",null,"Surface/Long.",null,"U ou ψ (en W/m².K)","C2","Δt(°C ou K)","bu","Pertes","Références"]
[null,"Repère paroi","Indication ","te (en °C)","Or.",null,"Largeur (en m)","Haut/Long (en m)","Brute (m²/m)","Nette (m²/m)"]
[null,"ME",null,{"$f":"$H$5","v":-9},null,1,15,2.5,{"$f":"$G18*$H18*$F18","v":37.5},{"$f":"IF(OR(B19=\"FE\",B19=\"PO\"),IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),I18-I19-I20-I21,I18-I19-I20),I18-I19),I18)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\")),+I19)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)","v":37.5},0.35,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N18*$M18*$K18*$J18","v":367.49999999999994}]
[null,"PT",null,{"$f":"$H$5","v":-9},null,1,2.5,1,{"$f":"$G19*$H19*$F19","v":2.5},{"$f":"IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),IF(OR(B22=\"FE\",B22=\"PO\"),I19-I20-I21-I22,I19-I20-I21),I19-I20),I19)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\"),OR(B21=\"FE\",B21=\"PO\")),+I21)","v":2.5},7.0000000000000007E-2,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N19*$M19*$K19*$J19","v":4.9000000000000004}]
[null,"ME",null,{"$f":"$H$5","v":-9},null,1,17,2.5,{"$f":"$G20*$H20*$F20","v":42.5},38.125,0.35,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N20*$M20*$K20*$J20","v":373.62499999999994}]
[null,"FE",null,{"$f":"$H$5","v":-9},null,1,1.75,2.5,{"$f":"$G21*$H21*$F21","v":4.375},4.375,2.8,1,28,1,342.99999999999994]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,"légende: ME = mur ; FE = fenêtre ; PO = porte ; PLH = plancher-haut ; PLB = plancher-bas ; PT = Pont Thermique"]
[null,null,null,null,null,null,null,"Total déperditions [statiques et aérauliques] (en W)",null,null,"Total pertes parois (en W) :",null,{"$f":"SUM(O18:O39)","v":1089.0249999999999}]
[null,null,null,null,null,null,null,"local ",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},{"$f":"$M$43+$M$68","v":1089.0249999999999},"k (coef pont thermiques) en%",null,0]
[null,null,null,null,null,null,null,null,null,null,"Total pertes parois+ponts (en W) :",null,{"$f":"((M41*M42)/100)+M41","v":1089.0249999999999}]
[null,"pertes aérauliques :"]
[]
["Types d'ouvertures ","Désignation",null,null,null,"Dimensions",null,"Coefficients","Surface ou linéaire","Perméabilité","U (en W/m².K)","Débit (m3/h)","Δt(°C ou K)","b","Pertes","Références"]
[null,"Repère type ","Te(°C)","0r.","Nbre","Largeur (en m)","Haut/long (en m)"]
["Entrée d'air module 22",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation1,source1,2,FALSE),0)","v":5},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Coffre\"),$G48,$F48*$G48),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Entrée\"),$E48*$H48,$I48*$H48*$E48),\"/\")","v":5},1,null,{"$f":"$H$8-$C48","v":28},1,{"$f":"IFERROR(IF($J48>0,$K48*$M48*$N48*$M$66*($J48/'local 1'!$F$42),$I$10*$K48*$M48),0)","v":0}]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation2,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Coffre\"),$G49,$F49*$G49),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Entrée\"),$E49*$H49,$I49*$H49*$E49),\"/\")","v":0},null,null,{"$f":"$H$8-$C49","v":28},1,{"$f":"IFERROR(IF($J49>0,$K49*$M49*$N49*$M$66*($J49/'local 1'!$F$42),$I$10*$K49*$M49),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation3,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J50>0,$K50*$M50*$N50*$M$66*($J50/'local 1'!$F$42),$I$10*$K50*$M50),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation4,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J51>0,$K51*$M51*$N51*$M$66*($J51/'local 1'!$F$42),$I$10*$K51*$M51),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation5,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J52>0,$K52*$M52*$N52*$M$66*($J52/'local 1'!$F$42),$I$10*$K52*$M52),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation6,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J53>0,$K53*$M53*$N53*$M$66*($J53/'local 1'!$F$42),$I$10*$K53*$M53),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation7,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J54>0,$K54*$M54*$N54*$M$66*($J54/'local 1'!$F$42),$I$10*$K54*$M54),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation8,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J55>0,$K55*$M55*$N55*$M$66*($J55/'local 1'!$F$42),$I$10*$K55*$M55),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation9,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J56>0,$K56*$M56*$N56*$M$66*($J56/'local 1'!$F$42),$I$10*$K56*$M56),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation10,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J57>0,$K57*$M57*$N57*$M$66*($J57/'local 1'!$F$42),$I$10*$K57*$M57),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation11,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J58>0,$K58*$M58*$N58*$M$66*($J58/'local 1'!$F$42),$I$10*$K58*$M58),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation12,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J59>0,$K59*$M59*$N59*$M$66*($J59/'local 1'!$F$42),$I$10*$K59*$M59),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation13,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J60>0,$K60*$M60*$N60*$M$66*($J60/'local 1'!$F$42),$I$10*$K60*$M60),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation14,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J61>0,$K61*$M61*$N61*$M$66*($J61/'local 1'!$F$42),$I$10*$K61*$M61),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation15,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J62>0,$K62*$M62*$N62*$M$66*($J62/'local 1'!$F$42),$I$10*$K62*$M62),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation16,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J63>0,$K63*$M63*$N63*$M$66*($J63/'local 1'!$F$42),$I$10*$K63*$M63),0)","v":0}]
[null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(J48:J63)","v":5}]
[null,null,null,null,null,null,null,null,null,null,"Débit réglementaire (en m3/h) :",null,130]
[null,null,null,null,null,null,null,null,"Ventilation naturelle",null,"Coefficient :",{"$f":"IFERROR(VLOOKUP(designation17,typeventil,2,FALSE),0)","v":1.3},{"$f":"$M$65*$L$66","v":169}]
[null,null,null,null,null,null,null,null,null,null,"n.V - Débit rég. (en m3/h)",null,{"$f":"I10-M65","v":-55}]
[null,null,null,null,null,null,null,null,null,null,"Total pertes aérauliques (en W) :",null,{"$f":"SUM(O48:O63)","v":0}]

{"sheet":"local 3","index":4,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[40,7,40,9],[0,1,0,10],[8,6,10,6],[15,1,15,4],[15,5,16,5],[15,6,15,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[45,14,46,14],[45,15,46,15],[45,0,46,0],[45,1,45,4],[45,5,45,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[65,8,65,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[45,13,46,13]]}
[null,{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}}]
[null,"Date :",{"$f":"TODAY()","v":"2013-01-28"}]
[null,"Affaire :"]
[null,"Localité :"]
[null,"Hauteur du batiment (en m) :",null,null,null,null,"Température ext. de base (°C) :",-9,"Notes:"]
[null,"Dénivellation yo (en m):",null,null,null,null,"Région (H1,H2,H3) : "]
[null,"Hauteur au sol (en m) :"]
[null,null,null,null,null,null,"Température intérieure (°C) :",19]
[null,"Local :",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},"Surface (en m²) :",null,null,"Renouvellement d'air :","n en vol/h",2,"tri = "]
[null,"N°:",null,"Hauteur (en m) :",null,null,null,"n.V en m3/h",{"$f":"$I$9*$F$11","v":0},"tai = "]
[null,"Type chauffage (C/R)",null,"Volume (en m3) :",null,{"$f":"F9*F10","v":0}]
[]
[]
[null," Pertes statiques :"]
[]
[null,"Désignation",null,null,null,"Nbre","Dimensions",null,"Surface/Long.",null,"U ou ψ (en W/m².K)","C2","Δt(°C ou K)","bu","Pertes","Références"]
[null,"Repère paroi","Indication ","te (en °C)","Or.",null,"Largeur (en m)","Haut/Long (en m)","Brute (m²/m)","Nette (m²/m)"]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G18*$H18*$F18","v":0},{"$f":"IF(OR(B19=\"FE\",B19=\"PO\"),IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),I18-I19-I20-I21,I18-I19-I20),I18-I19),I18)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\")),+I19)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)","v":0},null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N18*$M18*$K18*$J18","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G19*$H19*$F19","v":0},{"$f":"IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),IF(OR(B22=\"FE\",B22=\"PO\"),I19-I20-I21-I22,I19-I20-I21),I19-I20),I19)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\"),OR(B21=\"FE\",B21=\"PO\")),+I21)","v":0},null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N19*$M19*$K19*$J19","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G20*$H20*$F20","v":0},0,null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N20*$M20*$K20*$J20","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G21*$H21*$F21","v":0},0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,"légende: ME = mur ; FE = fenêtre ; PO = porte ; PLH = plancher-haut ; PLB = plancher-bas ; PT = Pont Thermique"]
[null,null,null,null,null,null,null,"Total déperditions [statiques et aérauliques] (en W)",null,null,"Total pertes parois (en W) :",null,{"$f":"SUM(O18:O39)","v":0}]
[null,null,null,null,null,null,null,"local ",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},{"$f":"$M$43+$M$68","v":0},"k (coef pont thermiques) en%",null,0]
[null,null,null,null,null,null,null,null,null,null,"Total pertes parois+ponts (en W) :",null,{"$f":"((M41*M42)/100)+M41","v":0}]
[null,"pertes aérauliques :"]
[]
["Types d'ouvertures ","Désignation",null,null,null,"Dimensions",null,"Coefficients","Surface ou linéaire","Perméabilité","U (en W/m².K)","Débit (m3/h)","Δt(°C ou K)","b","Pertes","Références"]
[null,"Repère type ","Te(°C)","0r.","Nbre","Largeur (en m)","Haut/long (en m)"]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation1,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Coffre\"),$G48,$F48*$G48),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Entrée\"),$E48*$H48,$I48*$H48*$E48),\"/\")","v":0},null,null,{"$f":"$H$8-$C48","v":28},1,{"$f":"IFERROR(IF($J48>0,$K48*$M48*$N48*$M$66*($J48/'local 1'!$F$42),$I$10*$K48*$M48),0)","v":0}]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation2,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Coffre\"),$G49,$F49*$G49),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Entrée\"),$E49*$H49,$I49*$H49*$E49),\"/\")","v":0},null,null,{"$f":"$H$8-$C49","v":28},1,{"$f":"IFERROR(IF($J49>0,$K49*$M49*$N49*$M$66*($J49/'local 1'!$F$42),$I$10*$K49*$M49),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation3,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J50>0,$K50*$M50*$N50*$M$66*($J50/'local 1'!$F$42),$I$10*$K50*$M50),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation4,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J51>0,$K51*$M51*$N51*$M$66*($J51/'local 1'!$F$42),$I$10*$K51*$M51),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation5,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J52>0,$K52*$M52*$N52*$M$66*($J52/'local 1'!$F$42),$I$10*$K52*$M52),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation6,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J53>0,$K53*$M53*$N53*$M$66*($J53/'local 1'!$F$42),$I$10*$K53*$M53),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation7,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J54>0,$K54*$M54*$N54*$M$66*($J54/'local 1'!$F$42),$I$10*$K54*$M54),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation8,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J55>0,$K55*$M55*$N55*$M$66*($J55/'local 1'!$F$42),$I$10*$K55*$M55),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation9,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J56>0,$K56*$M56*$N56*$M$66*($J56/'local 1'!$F$42),$I$10*$K56*$M56),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation10,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J57>0,$K57*$M57*$N57*$M$66*($J57/'local 1'!$F$42),$I$10*$K57*$M57),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation11,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J58>0,$K58*$M58*$N58*$M$66*($J58/'local 1'!$F$42),$I$10*$K58*$M58),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation12,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J59>0,$K59*$M59*$N59*$M$66*($J59/'local 1'!$F$42),$I$10*$K59*$M59),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation13,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J60>0,$K60*$M60*$N60*$M$66*($J60/'local 1'!$F$42),$I$10*$K60*$M60),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation14,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J61>0,$K61*$M61*$N61*$M$66*($J61/'local 1'!$F$42),$I$10*$K61*$M61),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation15,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J62>0,$K62*$M62*$N62*$M$66*($J62/'local 1'!$F$42),$I$10*$K62*$M62),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation16,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J63>0,$K63*$M63*$N63*$M$66*($J63/'local 1'!$F$42),$I$10*$K63*$M63),0)","v":0}]
[null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(J48:J63)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Débit réglementaire (en m3/h) :",null,130]
[null,null,null,null,null,null,null,null,"Ventilation non réglementaire",null,"Coefficient :",{"$f":"IFERROR(VLOOKUP(designation17,typeventil,2,FALSE),0)","v":0},{"$f":"$M$65*$L$66","v":0}]
[null,null,null,null,null,null,null,null,null,null,"n.V - Débit rég. (en m3/h)",null,{"$f":"I10-M65","v":-130}]
[null,null,null,null,null,null,null,null,null,null,"Total pertes aérauliques (en W) :",null,{"$f":"SUM(O48:O63)","v":0}]

{"sheet":"local 4","index":5,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[40,7,40,9],[0,1,0,10],[8,6,10,6],[15,1,15,4],[15,5,16,5],[15,6,15,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[45,14,46,14],[45,15,46,15],[45,0,46,0],[45,1,45,4],[45,5,45,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[65,8,65,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[45,13,46,13]]}
[null,{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}}]
[null,"Date :",{"$f":"TODAY()","v":"2013-01-28"}]
[null,"Affaire :"]
[null,"Localité :"]
[null,"Hauteur du batiment (en m) :",null,null,null,null,"Température ext. de base (°C) :",-9,"Notes:"]
[null,"Dénivellation yo (en m):",null,null,null,null,"Région (H1,H2,H3) : "]
[null,"Hauteur au sol (en m) :"]
[null,null,null,null,null,null,"Température intérieure (°C) :",19]
[null,"Local :",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},"Surface (en m²) :",null,null,"Renouvellement d'air :","n en vol/h",2,"tri = "]
[null,"N°:",null,"Hauteur (en m) :",null,null,null,"n.V en m3/h",{"$f":"$I$9*$F$11","v":0},"tai = "]
[null,"Type chauffage (C/R)",null,"Volume (en m3) :",null,{"$f":"F9*F10","v":0}]
[]
[]
[null," Pertes statiques :"]
[]
[null,"Désignation",null,null,null,"Nbre","Dimensions",null,"Surface/Long.",null,"U ou ψ (en W/m².K)","C2","Δt(°C ou K)","bu","Pertes","Références"]
[null,"Repère paroi","Indication ","te (en °C)","Or.",null,"Largeur (en m)","Haut/Long (en m)","Brute (m²/m)","Nette (m²/m)"]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G18*$H18*$F18","v":0},{"$f":"IF(OR(B19=\"FE\",B19=\"PO\"),IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),I18-I19-I20-I21,I18-I19-I20),I18-I19),I18)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\")),+I19)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)","v":0},null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N18*$M18*$K18*$J18","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G19*$H19*$F19","v":0},{"$f":"IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),IF(OR(B22=\"FE\",B22=\"PO\"),I19-I20-I21-I22,I19-I20-I21),I19-I20),I19)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\"),OR(B21=\"FE\",B21=\"PO\")),+I21)","v":0},null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N19*$M19*$K19*$J19","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G20*$H20*$F20","v":0},0,null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N20*$M20*$K20*$J20","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G21*$H21*$F21","v":0},0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,"légende: ME = mur ; FE = fenêtre ; PO = porte ; PLH = plancher-haut ; PLB = plancher-bas ; PT = Pont Thermique"]
[null,null,null,null,null,null,null,"Total déperditions [statiques et aérauliques] (en W)",null,null,"Total pertes parois (en W) :",null,{"$f":"SUM(O18:O39)","v":0}]
[null,null,null,null,null,null,null,"local ",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},{"$f":"$M$43+$M$68","v":0},"k (coef pont thermiques) en%",null,0]
[null,null,null,null,null,null,null,null,null,null,"Total pertes parois+ponts (en W) :",null,{"$f":"((M41*M42)/100)+M41","v":0}]
[null,"pertes aérauliques :"]
[]
["Types d'ouvertures ","Désignation",null,null,null,"Dimensions",null,"Coefficients","Surface ou linéaire","Perméabilité","U (en W/m².K)","Débit (m3/h)","Δt(°C ou K)","b","Pertes","Références"]
[null,"Repère type ","Te(°C)","0r.","Nbre","Largeur (en m)","Haut/long (en m)"]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation1,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Coffre\"),$G48,$F48*$G48),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Entrée\"),$E48*$H48,$I48*$H48*$E48),\"/\")","v":0},null,null,{"$f":"$H$8-$C48","v":28},1,{"$f":"IFERROR(IF($J48>0,$K48*$M48*$N48*$M$66*($J48/'local 1'!$F$42),$I$10*$K48*$M48),0)","v":0}]
["Non renseigné",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation2,source1,2,FALSE),0)","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Coffre\"),$G49,$F49*$G49),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Entrée\"),$E49*$H49,$I49*$H49*$E49),\"/\")","v":0},null,null,{"$f":"$H$8-$C49","v":28},1,{"$f":"IFERROR(IF($J49>0,$K49*$M49*$N49*$M$66*($J49/'local 1'!$F$42),$I$10*$K49*$M49),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation3,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J50>0,$K50*$M50*$N50*$M$66*($J50/'local 1'!$F$42),$I$10*$K50*$M50),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation4,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J51>0,$K51*$M51*$N51*$M$66*($J51/'local 1'!$F$42),$I$10*$K51*$M51),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation5,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J52>0,$K52*$M52*$N52*$M$66*($J52/'local 1'!$F$42),$I$10*$K52*$M52),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation6,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J53>0,$K53*$M53*$N53*$M$66*($J53/'local 1'!$F$42),$I$10*$K53*$M53),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation7,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J54>0,$K54*$M54*$N54*$M$66*($J54/'local 1'!$F$42),$I$10*$K54*$M54),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation8,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J55>0,$K55*$M55*$N55*$M$66*($J55/'local 1'!$F$42),$I$10*$K55*$M55),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation9,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J56>0,$K56*$M56*$N56*$M$66*($J56/'local 1'!$F$42),$I$10*$K56*$M56),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation10,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J57>0,$K57*$M57*$N57*$M$66*($J57/'local 1'!$F$42),$I$10*$K57*$M57),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation11,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J58>0,$K58*$M58*$N58*$M$66*($J58/'local 1'!$F$42),$I$10*$K58*$M58),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation12,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J59>0,$K59*$M59*$N59*$M$66*($J59/'local 1'!$F$42),$I$10*$K59*$M59),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation13,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J60>0,$K60*$M60*$N60*$M$66*($J60/'local 1'!$F$42),$I$10*$K60*$M60),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation14,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J61>0,$K61*$M61*$N61*$M$66*($J61/'local 1'!$F$42),$I$10*$K61*$M61),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation15,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J62>0,$K62*$M62*$N62*$M$66*($J62/'local 1'!$F$42),$I$10*$K62*$M62),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation16,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J63>0,$K63*$M63*$N63*$M$66*($J63/'local 1'!$F$42),$I$10*$K63*$M63),0)","v":0}]
[null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(J48:J63)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Débit réglementaire (en m3/h) :",null,130]
[null,null,null,null,null,null,null,null,"Ventilation non réglementaire",null,"Coefficient :",{"$f":"IFERROR(VLOOKUP(designation17,typeventil,2,FALSE),0)","v":0},{"$f":"$M$65*$L$66","v":0}]
[null,null,null,null,null,null,null,null,null,null,"n.V - Débit rég. (en m3/h)",null,{"$f":"I10-M65","v":-130}]
[null,null,null,null,null,null,null,null,null,null,"Total pertes aérauliques (en W) :",null,{"$f":"SUM(O48:O63)","v":0}]

{"sheet":"local 5","index":6,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[40,7,40,9],[0,1,0,10],[8,6,10,6],[15,1,15,4],[15,5,16,5],[15,6,15,7],[15,8,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[45,14,46,14],[45,15,46,15],[45,0,46,0],[45,1,45,4],[45,5,45,6],[45,7,46,7],[45,8,46,8],[45,9,46,9],[65,8,65,9],[45,10,46,10],[45,11,46,11],[45,12,46,12],[45,13,46,13]]}
[null,{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}}]
[null,"Date :",{"$f":"TODAY()","v":"2013-01-28"}]
[null,"Affaire :"]
[null,"Localité :"]
[null,"Hauteur du batiment (en m) :",null,null,null,null,"Température ext. de base (°C) :",-9,"Notes:"]
[null,"Dénivellation yo (en m):",null,null,null,null,"Région (H1,H2,H3) : "]
[null,"Hauteur au sol (en m) :"]
[null,null,null,null,null,null,"Température intérieure (°C) :",19]
[null,"Local :",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},"Surface (en m²) :",null,20,"Renouvellement d'air :","n en vol/h",2,"tri = "]
[null,"N°:",null,"Hauteur (en m) :",null,2.5,null,"n.V en m3/h",{"$f":"$I$9*$F$11","v":100},"tai = "]
[null,"Type chauffage (C/R)",null,"Volume (en m3) :",null,{"$f":"F9*F10","v":50}]
[]
[]
[null," Pertes statiques :"]
[]
[null,"Désignation",null,null,null,"Nbre","Dimensions",null,"Surface/Long.",null,"U ou ψ (en W/m².K)","C2","Δt(°C ou K)","bu","Pertes","Références"]
[null,"Repère paroi","Indication ","te (en °C)","Or.",null,"Largeur (en m)","Haut/Long (en m)","Brute (m²/m)","Nette (m²/m)"]
[null,"PT",null,{"$f":"$H$5","v":-9},null,4,2.5,1,{"$f":"$G18*$H18*$F18","v":10},{"$f":"IF(OR(B19=\"FE\",B19=\"PO\"),IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),I18-I19-I20-I21,I18-I19-I20),I18-I19),I18)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\")),+I19)+IF(AND(OR(B18=\"FE\",B18=\"PO\"),OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)","v":10},0.1,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N18*$M18*$K18*$J18","v":28.000000000000004}]
[null,"PT",null,{"$f":"$H$5","v":-9},null,3,2.5,1,{"$f":"$G19*$H19*$F19","v":7.5},{"$f":"IF(OR(B20=\"FE\",B20=\"PO\"),IF(OR(B21=\"FE\",B21=\"PO\"),IF(OR(B22=\"FE\",B22=\"PO\"),I19-I20-I21-I22,I19-I20-I21),I19-I20),I19)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\")),+I20)+IF(AND(OR(B19=\"FE\",B19=\"PO\"),OR(B20=\"FE\",B20=\"PO\"),OR(B21=\"FE\",B21=\"PO\")),+I21)","v":7.5},0.15,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N19*$M19*$K19*$J19","v":31.5}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G20*$H20*$F20","v":0},0,null,1,{"$f":"$H$8-$H$5","v":28},1,{"$f":"$N20*$M20*$K20*$J20","v":0}]
[null,null,null,{"$f":"$H$5","v":-9},null,null,null,null,{"$f":"$G21*$H21*$F21","v":0},0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,null,null,-9,null,null,null,null,0,0,null,1,28,1,0]
[null,"légende: ME = mur ; FE = fenêtre ; PO = porte ; PLH = plancher-haut ; PLB = plancher-bas ; PT = Pont Thermique"]
[null,null,null,null,null,null,null,"Total déperditions [statiques et aérauliques] (en W)",null,null,"Total pertes parois (en W) :",null,{"$f":"SUM(O18:O39)","v":59.5}]
[null,null,null,null,null,null,null,"local ",{"$f":"RIGHT(CELL(\"nomfichier\",B1),LEN(CELL(\"nomfichier\",B1))-FIND(\"]\",CELL(\"nomfichier\",B1)))","v":{"$error":"#VALUE!"}},{"$f":"$M$43+$M$68","v":59.5},"k (coef pont thermiques) en%",null,0]
[null,null,null,null,null,null,null,null,null,null,"Total pertes parois+ponts (en W) :",null,{"$f":"((M41*M42)/100)+M41","v":59.5}]
[null,"pertes aérauliques :"]
[]
["Types d'ouvertures ","Désignation",null,null,null,"Dimensions",null,"Coefficients","Surface ou linéaire","Perméabilité","U (en W/m².K)","Débit (m3/h)","Δt(°C ou K)","b","Pertes","Références"]
[null,"Repère type ","Te(°C)","0r.","Nbre","Largeur (en m)","Haut/long (en m)"]
["Entrée d'air module 30",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation1,source1,2,FALSE),0)","v":6.8},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Coffre\"),$G48,$F48*$G48),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A48,6),\"Entrée\"),$E48*$H48,$I48*$H48*$E48),\"/\")","v":6.8},1,null,{"$f":"$H$8-$C48","v":28},1,{"$f":"IFERROR(IF($J48>0,$K48*$M48*$N48*$M$66*($J48/'local 1'!$F$42),$I$10*$K48*$M48),0)","v":0}]
["Entrée d'air module 45",null,{"$f":"$H$5","v":-9},null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation2,source1,2,FALSE),0)","v":10.199999999999999},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Coffre\"),$G49,$F49*$G49),\"/\")","v":0},{"$f":"IFERROR(IF(EXACT(LEFT($A49,6),\"Entrée\"),$E49*$H49,$I49*$H49*$E49),\"/\")","v":10.199999999999999},1,null,{"$f":"$H$8-$C49","v":28},1,{"$f":"IFERROR(IF($J49>0,$K49*$M49*$N49*$M$66*($J49/'local 1'!$F$42),$I$10*$K49*$M49),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation3,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J50>0,$K50*$M50*$N50*$M$66*($J50/'local 1'!$F$42),$I$10*$K50*$M50),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation4,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J51>0,$K51*$M51*$N51*$M$66*($J51/'local 1'!$F$42),$I$10*$K51*$M51),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation5,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J52>0,$K52*$M52*$N52*$M$66*($J52/'local 1'!$F$42),$I$10*$K52*$M52),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation6,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J53>0,$K53*$M53*$N53*$M$66*($J53/'local 1'!$F$42),$I$10*$K53*$M53),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation7,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J54>0,$K54*$M54*$N54*$M$66*($J54/'local 1'!$F$42),$I$10*$K54*$M54),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation8,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J55>0,$K55*$M55*$N55*$M$66*($J55/'local 1'!$F$42),$I$10*$K55*$M55),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation9,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J56>0,$K56*$M56*$N56*$M$66*($J56/'local 1'!$F$42),$I$10*$K56*$M56),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation10,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J57>0,$K57*$M57*$N57*$M$66*($J57/'local 1'!$F$42),$I$10*$K57*$M57),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation11,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J58>0,$K58*$M58*$N58*$M$66*($J58/'local 1'!$F$42),$I$10*$K58*$M58),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation12,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J59>0,$K59*$M59*$N59*$M$66*($J59/'local 1'!$F$42),$I$10*$K59*$M59),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation13,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J60>0,$K60*$M60*$N60*$M$66*($J60/'local 1'!$F$42),$I$10*$K60*$M60),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation14,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J61>0,$K61*$M61*$N61*$M$66*($J61/'local 1'!$F$42),$I$10*$K61*$M61),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation15,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J62>0,$K62*$M62*$N62*$M$66*($J62/'local 1'!$F$42),$I$10*$K62*$M62),0)","v":0}]
["Non renseigné",null,-9,null,1,null,null,{"$f":"IFERROR(VLOOKUP(designation16,source1,2,FALSE),0)","v":0},0,0,null,null,28,1,{"$f":"IFERROR(IF($J63>0,$K63*$M63*$N63*$M$66*($J63/'local 1'!$F$42),$I$10*$K63*$M63),0)","v":0}]
[null,null,null,null,null,null,null,null,"Σ",{"$f":"SUM(J48:J63)","v":17}]
[null,null,null,null,null,null,null,null,null,null,"Débit réglementaire (en m3/h) :",null,130]
[null,null,null,null,null,null,null,null,"Ventilation naturelle",null,"Coefficient :",{"$f":"IFERROR(VLOOKUP(designation17,typeventil,2,FALSE),0)","v":1.3},{"$f":"$M$65*$L$66","v":169}]
[null,null,null,null,null,null,null,null,null,null,"n.V - Débit rég. (en m3/h)",null,{"$f":"I10-M65","v":-30}]
[null,null,null,null,null,null,null,null,null,null,"Total pertes aérauliques (en W) :",null,{"$f":"SUM(O48:O63)","v":0}]

{"sheet":"Bilan","index":7,"n_rows":58,"n_cols":20,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Pertes statiques ","Pertes Aérauliques","Total","hors pt","pt",null,null,"Déperditions statiques \n(hors ponts thermiques)","Déperditions statiques \n(hors ponts thermiques)","Ratio \nPonts Thermiques","Ratio \nPonts Thermiques"]
[null,{"$f":"'local 1'!B1:K1","v":{"$error":"#VALUE!"}},{"$f":"'local 1'!M43","v":1176.7},{"$f":"'local 1'!M68","v":0},{"$f":"SUM(C4:D4)","v":1176.7},{"$f":"SUM(SUMIF('local 1'!B18:B39,\"ME\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"FE\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PO\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLH\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLB\",'local 1'!O18:O39))+$D4","v":1170.3999999999999},{"$f":"SUMIF('local 1'!B18:B39,\"PT\",'local 1'!O18:O39)","v":6.3000000000000007},null,{"$f":"B4","v":{"$error":"#VALUE!"}},{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"ME\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"FE\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PO\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLH\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLB\",'local 1'!O18:O39)))/'local 1'!$F$9,0)","v":23.407999999999998},{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"ME\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"FE\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PO\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLH\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLB\",'local 1'!O18:O39)))/'local 1'!$F$11,0)","v":9.3631999999999991},{"$f":"IFERROR(SUMIF('local 1'!B18:B39,\"PT\",'local 1'!O18:O39)/'local 1'!$F$9,0)","v":0.126},{"$f":"IFERROR(SUMIF('local 1'!B18:B39,\"PT\",'local 1'!O18:O39)/'local 1'!$F$11,0)","v":5.0400000000000007E-2}]
[null,{"$f":"'local 2'!B1:K1","v":{"$error":"#VALUE!"}},{"$f":"'local 2'!M43","v":1089.0249999999999},{"$f":"'local 2'!M68","v":0},1089.0249999999999,{"$f":"SUM(SUMIF('local 2'!B18:B39,\"ME\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"FE\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PO\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLH\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLB\",'local 2'!O18:O39))+$D5","v":1084.1249999999998},{"$f":"SUMIF('local 2'!B18:B39,\"PT\",'local 2'!O18:O39)","v":4.9000000000000004},null,{"$error":"#VALUE!"},{"$f":"IFERROR((SUM(SUMIF('local 2'!B18:B39,\"ME\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"FE\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PO\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLH\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLB\",'local 2'!O18:O39)))/'local 2'!$F$9,0)","v":72.274999999999991},{"$f":"IFERROR((SUM(SUMIF('local 2'!B18:B39,\"ME\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"FE\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PO\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLH\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLB\",'local 2'!O18:O39)))/'local 2'!$F$11,0)","v":28.909999999999993},{"$f":"IFERROR(SUMIF('local 2'!B18:B39,\"PT\",'local 2'!O18:O39)/'local 2'!$F$9,0)","v":0.32666666666666672},{"$f":"IFERROR(SUMIF('local 2'!B18:B39,\"PT\",'local 2'!O18:O39)/'local 2'!$F$11,0)","v":0.13066666666666668},null,null,{"$f":"F10","v":"déperditions statiques et aérauliques hors ponts thermiques"},"déperditions linéiques"]
[null,{"$f":"'local 3'!B1:K1","v":{"$error":"#VALUE!"}},{"$f":"'local 3'!M43","v":0},{"$f":"'local 3'!M68","v":0},0,{"$f":"SUM(SUMIF('local 3'!B18:B39,\"ME\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"FE\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PO\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLH\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLB\",'local 3'!O18:O39))+$D6","v":0},{"$f":"SUMIF('local 3'!B18:B39,\"PT\",'local 3'!O18:O39)","v":0},null,{"$error":"#VALUE!"},{"$f":"IFERROR((SUM(SUMIF('local 3'!B18:B39,\"ME\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"FE\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PO\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLH\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLB\",'local 3'!O18:O39)))/'local 3'!$F$9,0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 3'!B18:B39,\"ME\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"FE\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PO\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLH\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLB\",'local 3'!O18:O39)))/'local 3'!$F$11,0)","v":0},{"$f":"IFERROR(SUMIF('local 3'!B18:B39,\"PT\",'local 3'!O18:O39)/'local 3'!$F$9,0)","v":0},{"$f":"IFERROR(SUMIF('local 3'!B18:B39,\"PT\",'local 3'!O18:O39)/'local 3'!$F$11,0)","v":0},null,null,96.959434033265595,3.0405659667344023]
[null,{"$f":"'local 4'!B1:K1","v":{"$error":"#VALUE!"}},{"$f":"'local 4'!M43","v":0},{"$f":"'local 4'!M68","v":0},0,{"$f":"SUM(SUMIF('local 4'!B18:B39,\"ME\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"FE\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PO\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLH\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLB\",'local 4'!O18:O39))+$D7","v":0},{"$f":"SUMIF('local 4'!B18:B39,\"PT\",'local 4'!O18:O39)","v":0},null,{"$error":"#VALUE!"},{"$f":"IFERROR((SUM(SUMIF('local 4'!B18:B39,\"ME\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"FE\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PO\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLH\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLB\",'local 4'!O18:O39)))/'local 4'!$F$9,0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 4'!B18:B39,\"ME\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"FE\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PO\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLH\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLB\",'local 4'!O18:O39)))/'local 4'!$F$11,0)","v":0},{"$f":"IFERROR(SUMIF('local 4'!B18:B39,\"PT\",'local 4'!O18:O39)/'local 4'!$F$9,0)","v":0},{"$f":"IFERROR(SUMIF('local 4'!B18:B39,\"PT\",'local 4'!O18:O39)/'local 4'!$F$11,0)","v":0}]
[null,{"$f":"'local 5'!B1:K1","v":{"$error":"#VALUE!"}},{"$f":"'local 5'!M43","v":59.5},{"$f":"'local 5'!M68","v":0},59.5,{"$f":"SUM(SUMIF('local 5'!B18:B39,\"ME\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"FE\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PO\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLH\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLB\",'local 5'!O18:O39))+$D8","v":0},{"$f":"SUMIF('local 5'!B18:B39,\"PT\",'local 5'!O18:O39)","v":59.5},null,{"$error":"#VALUE!"},{"$f":"IFERROR((SUM(SUMIF('local 5'!B18:B39,\"ME\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"FE\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PO\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLH\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLB\",'local 5'!O18:O39)))/'local 5'!$F$9,0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 5'!B18:B39,\"ME\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"FE\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PO\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLH\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLB\",'local 5'!O18:O39)))/'local 5'!$F$11,0)","v":0},{"$f":"IFERROR(SUMIF('local 5'!B18:B39,\"PT\",'local 5'!O18:O39)/'local 5'!$F$9,0)","v":2.9750000000000001},{"$f":"IFERROR(SUMIF('local 5'!B18:B39,\"PT\",'local 5'!O18:O39)/'local 5'!$F$11,0)","v":1.19}]
[null,"Total ",{"$f":"SUM(C4:C8)","v":2325.2249999999999},{"$f":"SUM(D4:D8)","v":0},2325.2249999999999,{"$f":"SUM(F4:F8)","v":2254.5249999999996},{"$f":"SUM(G4:G8)","v":70.7},null,"Total ",{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"ME\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"FE\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PO\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLH\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLB\",'local 1'!O18:O39),SUMIF('local 2'!B18:B39,\"ME\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"FE\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PO\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLH\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLB\",'local 2'!O18:O39),SUMIF('local 3'!B18:B39,\"ME\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"FE\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PO\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLH\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLB\",'local 3'!O18:O39),SUMIF('local 4'!B18:B39,\"ME\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"FE\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PO\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLH\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLB\",'local 4'!O18:O39),SUMIF('local 5'!B18:B39,\"ME\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"FE\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PO\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLH\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLB\",'local 5'!O18:O39),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!)))/(SUM('local 1'!$F$9,'local 2'!$F$9,'local 3'!$F$9,'local 4'!$F$9,'local 5'!$F$9,#REF!,#REF!,#REF!,#REF!,#REF!)),0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"ME\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"FE\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PO\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLH\",'local 1'!O18:O39),SUMIF('local 1'!B18:B39,\"PLB\",'local 1'!O18:O39),SUMIF('local 2'!B18:B39,\"ME\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"FE\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PO\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLH\",'local 2'!O18:O39),SUMIF('local 2'!B18:B39,\"PLB\",'local 2'!O18:O39),SUMIF('local 3'!B18:B39,\"ME\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"FE\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PO\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLH\",'local 3'!O18:O39),SUMIF('local 3'!B18:B39,\"PLB\",'local 3'!O18:O39),SUMIF('local 4'!B18:B39,\"ME\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"FE\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PO\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLH\",'local 4'!O18:O39),SUMIF('local 4'!B18:B39,\"PLB\",'local 4'!O18:O39),SUMIF('local 5'!B18:B39,\"ME\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"FE\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PO\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLH\",'local 5'!O18:O39),SUMIF('local 5'!B18:B39,\"PLB\",'local 5'!O18:O39),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!),SUMIF(#REF!,\"ME\",#REF!),SUMIF(#REF!,\"FE\",#REF!),SUMIF(#REF!,\"PO\",#REF!),SUMIF(#REF!,\"PLH\",#REF!),SUMIF(#REF!,\"PLB\",#REF!)))/(SUM('local 1'!$F$11,'local 2'!$F$11,'local 3'!$F$11,'local 4'!$F$11,'local 5'!$F$11,#REF!,#REF!,#REF!,#REF!,#REF!)),0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"PT\",'local 1'!O18:O39),SUMIF('local 2'!B18:B39,\"PT\",'local 2'!O18:O39),SUMIF('local 3'!B18:B39,\"PT\",'local 3'!O18:O39),SUMIF('local 4'!B18:B39,\"PT\",'local 4'!O18:O39),SUMIF('local 5'!B18:B39,\"PT\",'local 5'!O18:O39),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!)))/(SUM('local 1'!$F$9,'local 2'!$F$9,'local 3'!$F$9,'local 4'!$F$9,'local 5'!$F$9,#REF!,#REF!,#REF!,#REF!,#REF!)),0)","v":0},{"$f":"IFERROR((SUM(SUMIF('local 1'!B18:B39,\"PT\",'local 1'!O18:O39),SUMIF('local 2'!B18:B39,\"PT\",'local 2'!O18:O39),SUMIF('local 3'!B18:B39,\"PT\",'local 3'!O18:O39),SUMIF('local 4'!B18:B39,\"PT\",'local 4'!O18:O39),SUMIF('local 5'!B18:B39,\"PT\",'local 5'!O18:O39),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!),SUMIF(#REF!,\"PT\",#REF!)))/(SUM('local 1'!$F$11,'local 2'!$F$11,'local 3'!$F$11,'local 4'!$F$11,'local 5'!$F$11,#REF!,#REF!,#REF!,#REF!,#REF!)),0)","v":0}]
[null,null,null,null,null,"déperditions statiques et aérauliques hors ponts thermiques","déperditions linéiques"]
[null,null,null,null,null,{"$f":"(F9*100)/E9","v":96.959434033265595},{"$f":"(G9*100)/E9","v":3.0405659667344023},null,"Proportion des déperditions linéiques du bâtiment :"]
[null,"Déperditions statiques et aérauliques par m² de surface plancher :"]
[null,"Déperditions par m² (en W)",{"$f":"IFERROR(E9/('local 1'!F9+'local 2'!F9+'local 3'!F9+'local 4'!F9+'local 5'!F9+#REF!+#REF!+#REF!+#REF!+#REF!),0)","v":0}]
[]
[null,"Déperditions statiques et aérauliques rapportée au volume :"]
[null,"Déperditions par m3 (en W)",{"$f":"IFERROR(E9/('local 1'!F11+'local 2'!F11+'local 3'!F11+'local 4'!F11+'local 5'!F11+#REF!+#REF!+#REF!+#REF!+#REF!),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D3","v":"Pertes Aérauliques"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B4","v":{"$error":"#VALUE!"}},{"$f":"D4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B5","v":{"$error":"#VALUE!"}},{"$f":"D5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":{"$error":"#VALUE!"}},{"$f":"D6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":{"$error":"#VALUE!"}},{"$f":"D7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8","v":{"$error":"#VALUE!"}},{"$f":"D8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]