{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Calcul du K","Ventilation","Parois moyennes","Parois types"],"not_rendered":{"images":3,"macros":1,"defined_names":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Calcul du K","index":0,"n_rows":196,"n_cols":41,"rows_kept":196,"merged":[[0,31,1,31],[0,32,1,32],[0,33,1,33],[0,34,1,34],[10,3,10,7],[11,3,11,7],[11,11,11,12],[12,3,12,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[32,1,36,1],[32,2,36,2],[32,9,36,9],[32,10,36,10],[32,11,36,11],[37,1,40,1],[37,2,40,2],[37,9,40,9],[37,10,40,10],[37,11,40,11],[41,1,46,1],[41,2,46,2],[41,9,46,9],[41,10,46,10],[41,11,46,11],[47,1,50,1],[47,2,50,2],[47,9,50,9],[47,10,50,10],[47,11,50,11],[51,1,54,1],[51,2,54,2],[51,5,54,7],[51,9,54,9],[51,10,54,10],[51,11,54,11],[55,1,58,1],[55,2,58,2],[55,9,58,9],[55,10,58,10],[55,11,58,11],[59,1,62,1],[59,2,62,2],[59,9,62,9],[59,10,62,10],[59,11,62,11],[63,1,66,1],[63,2,66,2],[63,9,66,9],[63,10,66,10],[63,11,66,11],[67,1,70,1],[67,2,70,2],[67,9,70,9],[67,10,70,10],[67,11,70,11],[71,1,74,1],[71,2,74,2],[71,9,74,9],[71,10,74,10],[71,11,74,11],[75,1,78,1],[75,2,78,2],[75,9,78,9],[75,10,78,10],[75,11,78,11],[79,1,82,1],[79,2,82,2],[79,9,82,9],[79,10,82,10],[79,11,82,11],[83,1,86,1],[83,2,86,2],[83,9,86,9],[83,10,86,10],[83,11,86,11],[87,1,88,1],[87,2,88,2],[87,9,88,9],[87,10,88,10],[87,11,88,11],[89,1,92,1],[89,2,92,2],[89,9,92,9],[89,10,92,10],[89,11,92,11],[109,6,109,7],[110,1,113,1],[110,2,113,2],[110,6,113,7],[115,3,115,8],[115,9,115,10],[116,3,116,8],[116,9,116,10],[117,3,117,8],[117,9,117,10],[118,3,118,8],[118,9,118,10],[119,1,121,1],[119,2,121,2],[119,3,119,8],[119,9,119,10],[120,3,120,8],[120,9,120,10],[121,3,121,8],[121,9,121,10],[122,3,122,8],[122,9,122,10],[123,3,123,8],[123,9,123,10],[127,2,127,3],[127,6,127,9],[128,6,128,8],[129,6,129,8],[147,2,147,9],[148,2,148,9],[149,2,149,9],[150,2,150,9],[151,2,151,9],[152,2,152,9],[153,2,153,9],[154,2,154,9],[155,2,155,9],[156,2,156,9],[157,2,157,9],[158,2,158,9],[159,2,159,9],[160,2,160,9],[161,2,161,9],[162,2,162,9],[170,3,170,4],[171,3,171,4],[172,3,172,4],[173,3,173,4],[174,3,174,4],[176,3,176,4],[182,2,182,6],[185,3,185,4],[186,3,186,4],[187,3,187,4],[188,3,188,4],[195,2,195,5],[198,2,214,9]]}
[{"$nulls":3},"\"Niveau K\"  et bilan énergétique d'un bâtiment",{"$nulls":27},"K<=20 + non","K<=20 + oui","K>20 + non","K>20 + oui"]
[{"$nulls":3},"- encodez les données relatives à votre situation dans les cases bleues.",{"$nulls":21},"montant travaux ",{"$nulls":4},"subventions"]
[{"$nulls":3},"- les résultats sont repris dans les cases jaunes.",{"$nulls":21},"Plafond/Plancher comble",34.48,{"$nulls":3},"Plafond/Plancher comble",{"$f":"ROUND(AA3*$AB$31,0)","v":26},{"$f":"ROUND(AA3*$AB$30,0)","v":28},{"$f":"ROUND(AA3*$AB$33,0)","v":17},{"$f":"ROUND(AA3*$AB$32,0)","v":19}]
[{"$nulls":25},"Toiture en pente dans la structure",71.73,{"$nulls":3},"Toiture en pente dans la structure",54,57,36,39]
[null,null,"Si vous ne connaissez pas les caractéristiques thermiques exactes de vos parois, vous pouvez accéder",{"$nulls":22},"Sarking",140,{"$nulls":3},"Sarking",105,112,70,77]
[null,null,"à un catalogue de parois types et de leur coefficient de transmission thermique k, en cliquant ici :",{"$nulls":22},"Toiture plate",117.91,{"$nulls":3},"Toiture plate",88,94,59,65]
[{"$nulls":25},"Isolation des murs ",79.54,{"$nulls":3},"Isolation des murs ",60,64,40,44]
[{"$nulls":25},"Isolation du sol",32.32,{"$nulls":3},"Isolation du sol",24,26,16,18]
[{"$nulls":25},"menuiseries extérieures",450,{"$nulls":3},"menuiseries extérieures",{"$f":"ROUND(AA9*$AB$31,0)","v":338},{"$f":"ROUND(AA9*$AB$30,0)","v":360},225,{"$f":"ROUND(AA9*$AB$32,0)","v":248}]
[]
[null,null,"Dénomination du bâtiment : "]
[null,null,"Adresse du bâtiment : ",{"$nulls":27},"niveau K",{"$f":"IF(J124<=20,Z30,Z32)","v":"K<=20"}]
[]
[]
[null,null,"/!\\  Afin de pouvoir déterminer le niveau K du bâtiment après travaux, l’ensemble des surfaces de déperdition de l’enveloppe du bâtiment devront être encodées même si certaines parois ne sont pas modifiées thermiquement (c'est à dire isolées ou remplacées en cas de menuiseries). "]
[]
[null,null,"Travaux éligibles – Exigences"]
[null,null,"1) Amélioration de l'enveloppe : "]
[null,null,"a) Rremplacement des menuiseries extérieurs : "]
[null,null,"Coefficient de transmission thermique de l'ensemble châssis et vitrage : Uw ≤ 1.5 W/m²K "]
[null,null,"b) Coefficient de résistance thermique R de l'isolant ajouté : "]
[null,null,"Isolation du toit : R ≥ 6 m²K/W "]
[null,null,"Isolation des murs : R ≥ 6 m²K/W "]
[null,null,"Isolation des sols : R ≥ 4 m²K/W "]
[null,null,"2) Placement d'un système de ventilation  :"]
[null,null,"Débit ≥ 36m³/h par personne  "]
[null,null,"Système de régulation de type INT-C6"]
[]
[null,"1°","Calcul du niveau d'isolation thermique globale \"K\" d'un bâtiment, suivant NBN B62-301",{"$nulls":22},"K","biosourcé"]
[null,null,"Attention: cette méthode de calcul ne correspond pas à la méthode réglementaire actuelle. Elle présente une approche simplifiée concernant les déperditions par le sol et vers les espaces adjacents non chauffés.",{"$nulls":22},"K<=20","oui",0.8]
[{"$nulls":12},"parois modifiées",null,"contrôle U chassis","Avertissement U","oublie isolant","surface modifié correctement",{"$nulls":7},"K<=20","non",0.75]
[null,null,"Parois de la superficie de déperdition thermique","Uj          [W/(m².K)]","Aj            [m²]","Parois modifiées ","Châssis / Isolant Biosourcé","Montant  de subvention ","Uj . Aj        [W/K]","S U j . Aj         [W/K]","aj","S aj . Uj .Aj         [W/K]",null,null,{"$f":"IF(SUM(O33:O41)>=1,1,0)","v":0},{"$f":"IF(SUM(P33:P87)>=1,1,0)","v":0},{"$f":"IF(SUM(Q33:Q87)>=1,1,0)","v":0},{"$nulls":8},"K>20","oui",0.55]
[null,1,"\nFenêtres, tabatières, coupoles et autres parois translucides, portes extérieures",null,null,false,null,{"$f":"IF(OR(G33=\"\",F33=FALSE),\"\",HLOOKUP(N33,$AE$1:$AI$9,9,1)*E33*(1-O33))","v":""},{"$f":"D33*E33","v":{"v":0,"d":"0.0"}},{"$f":"SUM(I33:I37)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K33*J33","v":{"v":0,"d":"0.0"}},{"$f":"IF(F33=TRUE,1,0)","v":0},{"$f":"$AF$12&\" \"&\"+\"&\" \"&G33","v":"K<=20 + "},{"$f":"IF(AND(D33>1.5,M33=1),1,0)","v":0},{"$f":"IF(D33=\"\",0,IF(OR(D33>6,D33<0.7),1,0))","v":0},{"$f":"IF(AND(D33<>\"\",E33<>\"\",F33=TRUE,G33=\"\"),1*$Q$30,0)","v":0},{"$f":"E33*(1-O33)*M33","v":0},{"$nulls":3},"oui",{"$nulls":3},"K>20","non",0.5]
[{"$nulls":5},false,null,{"$f":"IF(OR(G34=\"\",F34=FALSE),\"\",HLOOKUP(N34,$AE$1:$AI$9,9,1)*E34*(1-O34))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F34=TRUE,1,0)","v":0},"K<=20 + ",{"$f":"IF(AND(D34>1.5,M34=1),1,0)","v":0},{"$f":"IF(D34=\"\",0,IF(OR(D34>6,D34<0.7),1,0))","v":0},{"$f":"IF(AND(D34<>\"\",E34<>\"\",F34=TRUE,G34=\"\"),1*$Q$30,0)","v":0},{"$f":"E34*(1-O34)*M34","v":0},{"$nulls":3},"non"]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F35=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"$f":"D36*E36","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(F36=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F37=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G38=\"\",F38=FALSE),\"\",HLOOKUP(N38,$AE$1:$AI$9,9,1)*E38)","v":""},{"$nulls":4},0,"K<=20 + ",0,0,0]
[{"$nulls":5},false,null,"",{"$nulls":4},0,"K<=20 + ",0,0,0]
[{"$nulls":5},false,null,"",{"$nulls":4},0,"K<=20 + ",0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G41=\"\",F41=FALSE),\"\",HLOOKUP(N41,$AE$1:$AI$9,9,1)*E41)","v":""},{"$nulls":4},0,"K<=20 + ",{"$f":"IF(AND(D41>1.5,M41=1),1,0)","v":0},0,0]
[null,2,"\n\nMurs extérieurs, façades ",null,null,false,null,{"$f":"IF(OR(G42=\"\",F42=FALSE),\"\",HLOOKUP(N42,$AE$1:$AI$9,7,1)*E42*(1-O42))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I42:I47)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K42*J42","v":{"v":0,"d":"0.0"}},0,{"$f":"$AF$12&\" \"&\"+\"&\" \"&G42","v":"K<=20 + "},{"$f":"IF(AND(D42>0.24,M42=1),1,0)","v":0},{"$f":"IF(D42=\"\",0,IF(OR(D42>6,D42<0.1),1,0))","v":0},0,{"$f":"E42*(1-O42)*M42","v":0}]
[{"$nulls":5},false,null,{"$f":"IF(OR(G43=\"\",F43=FALSE),\"\",HLOOKUP(N43,$AE$1:$AI$9,7,1)*E43*(1-O43))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,{"$f":"IF(D43=\"\",0,IF(OR(D43>6,D43<0.1),1,0))","v":0},0,{"$f":"E43*(1-O43)*M43","v":0}]
[{"$nulls":5},false,null,"",{"$f":"D44*E44","v":{"v":0,"d":"0.0"}},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[8,{"$nulls":4},false,null,"",{"$f":"D45*E45","v":{"v":0,"d":"0.0"}},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":3},"isolation sarking avec isolant non biosourcé"]
[{"$nulls":5},false,null,{"$f":"IF(OR(G47=\"\",F47=FALSE),\"\",HLOOKUP(N47,$AE$1:$AI$9,7,1)*E47*(1-O47))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":3},"isolation sarking avec isolant biosourcé"]
[null,3,"\nToitures plates",null,null,false,null,{"$f":"IF(OR(G48=\"\",F48=FALSE),\"\",HLOOKUP(N48,$AE$1:$AI$9,6,1)*E48*(1-O48))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I48:I51)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K48*J48","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0,{"$nulls":3},"isolation dans la structure avec isolant biosourcé"]
[{"$nulls":5},false,null,{"$f":"IF(OR(G49=\"\",F49=FALSE),\"\",HLOOKUP(N49,$AE$1:$AI$9,6,1)*E49*(1-O49))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"$f":"D50*E50","v":{"v":0,"d":"0.0"}},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":3},"isolation dans la structure avec isolant non biosourcé"]
[null,4,"\nToitures inclinées qui restera non isolées après travaux",{"$nulls":5},{"v":0,"d":"0.0"},{"$f":"SUM(I52:I55)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K52*J52","v":{"v":0,"d":"0.0"}},null,null,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"$nulls":5},0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"$nulls":5},0,0,0,0]
[{"$nulls":8},{"$f":"D55*E55","v":{"v":0,"d":"0.0"}},{"$nulls":5},0,{"$f":"IF(D55=\"\",0,IF(OR(D55>6,D55<0.1),1,0))","v":0},0,0]
[null,5,"\nToitures inclinées : isolation dans la structure",null,null,false,null,{"$f":"IF(OR(G56=\"\",F56=FALSE),\"\",HLOOKUP(N56,$AE$1:$AI$9,4,1)*E56*(1-O56))","v":""},{"$f":"D56*E56","v":{"v":0,"d":"0.0"}},{"$f":"SUM(I56:I59)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K56*J56","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G57=\"\",F57=FALSE),\"\",HLOOKUP(N57,$AE$1:$AI$9,4,1)*E57*(1-O57))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F58=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"$f":"D59*E59","v":{"v":0,"d":"0.0"}},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[null,6,"\nToitures inclinées : isolation de type Sarking",null,null,false,null,{"$f":"IF(OR(G60=\"\",F60=FALSE),\"\",HLOOKUP(N60,$AE$1:$AI$9,5,1)*E60*(1-O60))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I60:I63)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K60*J60","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G61=\"\",F61=FALSE),\"\",HLOOKUP(N61,$AE$1:$AI$9,5,1)*E61*(1-O61))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[null,7," \nPlancher des combles",null,null,false,null,{"$f":"IF(OR(G64=\"\",F64=FALSE),\"\",HLOOKUP(N64,$AE$1:$AI$9,3,1)*E64*(1-O64))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I64:I67)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K64*J64","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G65=\"\",F65=FALSE),\"\",HLOOKUP(N65,$AE$1:$AI$9,3,1)*E65*(1-O65))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":13},"Catégorie de débit",{"$f":"_xlfn.IFS(D129<AE71,AF71,D129<AE72,AF72,D129<AE73,AF73,D129<AE74,AF74,D129<AE75,AF75,D129<AE76,AF76,TRUE,AF77)","v":"0-3000 m³/h"},{"$nulls":4},"Catégorie de débit",{"$f":"_xlfn.IFS(J129<AK71,AL71,J129<AK72,AL72,J129<AK73,AL73,J129<AK74,AL74,J129<AK75,AL75,J129<AK76,AL76,TRUE,AL77)","v":"0-3000 m³/h"}]
[{"$nulls":5},false,null,"",{"$f":"D67*E67","v":{"v":0,"d":"0.0"}},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":13},"niveau K",{"$f":"IF($J$124<=20,0.75,0.5)","v":0.75},{"$nulls":4},"niveau K",{"$f":"IF($J$124<=20,0.75,0.5)","v":0.75}]
[null,8,"\nPlanchers au-dessus de l'ambiance extérieure ",null,null,false,null,{"$f":"IF(OR(G68=\"\",F68=FALSE),\"\",HLOOKUP(N68,$AE$1:$AI$9,8,1)*E68*(1-O68))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I68:I71)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K68*J68","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0,{"$nulls":14},{"$f":"VLOOKUP(AG66,AF71:AI77,4,0)","v":1600},{"$nulls":5},{"$f":"VLOOKUP(AM66,AL71:AO77,4,0)","v":15000}]
[{"$nulls":5},false,null,{"$f":"IF(OR(G69=\"\",F69=FALSE),\"\",HLOOKUP(N69,$AE$1:$AI$9,8,1)*E69*(1-O69))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":13},"groupe ventilation type C",{"$nulls":5},"groupe ventilation type D"]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":12},2999.99,"0-3000 m³/h",{"$f":"AI71*0.75","v":{"v":1200,"d":"1,200 €"}},{"$f":"AI71*0.5","v":{"v":800,"d":"800 €"}},{"v":1600,"d":"1600.00"},null,2999.99,"0-3000 m³/h",{"$f":"AO71*0.75","v":{"v":11250,"d":"11,250 €"}},{"$f":"AO71*0.5","v":{"v":7500,"d":"7,500 €"}},{"v":15000,"d":"15000.00"}]
[null,9,"\nPlanchers au-dessus d'espaces voisins non à l'abri du gel (vide sanitaire) ",null,null,false,null,{"$f":"IF(OR(G72=\"\",F72=FALSE),\"\",HLOOKUP(N72,$AE$1:$AI$9,8,1)*E72*(1-O72))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I72:I75)","v":{"v":0,"d":"0.0"}},1,{"$f":"+K72*J72","v":{"v":0,"d":"0.0"}},{"$f":"IF(F72=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0,{"$nulls":12},5000.99,"3000-5000 m³/h",{"v":1425,"d":"1,425 €"},{"v":950,"d":"950 €"},{"v":1900,"d":"1900.00"},null,5000.99,"3000-5000 m³/h",{"$f":"AO72*0.75","v":{"v":12900,"d":"12,900 €"}},{"$f":"AO72*0.5","v":{"v":8600,"d":"8,600 €"}},{"v":17200,"d":"17200.00"}]
[{"$nulls":5},false,null,{"$f":"IF(OR(G73=\"\",F73=FALSE),\"\",HLOOKUP(N73,$AE$1:$AI$9,8,1)*E73*(1-O73))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F73=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0,{"$nulls":12},10000.99,"5000-10000 m³/h",{"v":2887.5,"d":"2,888 €"},{"v":1925,"d":"1,925 €"},{"v":3850,"d":"3850.00"},null,10000.99,"5000-10000 m³/h",{"v":16650,"d":"16,650 €"},{"v":11100,"d":"11,100 €"},{"v":22200,"d":"22200.00"}]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":12},15000.99,"10000-15000 m³/h",{"v":3037.5,"d":"3,038 €"},{"v":2025,"d":"2,025 €"},{"v":4050,"d":"4050.00"},null,15000.99,"10000-15000 m³/h",{"v":23062.5,"d":"23,063 €"},{"v":15375,"d":"15,375 €"},{"v":30750,"d":"30750.00"}]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":12},20000.99,"15000-20000 m³/h",{"v":3225,"d":"3,225 €"},{"v":2150,"d":"2,150 €"},{"v":4300,"d":"4300.00"},null,20000.99,"15000-20000 m³/h",{"v":46350,"d":"46,350 €"},{"v":30900,"d":"30,900 €"},{"v":61800,"d":"61800.00"}]
[null,10,"\nPlanchers au-dessus d'espaces voisins à l'abri du gel (caves)",null,null,false,null,{"$f":"IF(OR(G76=\"\",F76=FALSE),\"\",HLOOKUP(N76,$AE$1:$AI$9,8,1)*E76*(1-O76))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I76:I79)","v":{"v":0,"d":"0.0"}},{"v":1,"d":"1.00"},{"$f":"+K76*J76","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0,{"$nulls":12},25000.99,"20000-25000 m³/h",{"v":3675,"d":"3,675 €"},{"v":2450,"d":"2,450 €"},{"v":4900,"d":"4900.00"},null,25000.99,"20000-25000 m³/h",{"v":54000,"d":"54,000 €"},{"v":36000,"d":"36,000 €"},{"v":72000,"d":"72000.00"}]
[{"$nulls":5},false,null,{"$f":"IF(OR(G77=\"\",F77=FALSE),\"\",HLOOKUP(N77,$AE$1:$AI$9,8,1)*E77*(1-O77))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0,{"$nulls":12},999999,"25000-30000 m³/h",{"v":4350,"d":"4,350 €"},{"v":2900,"d":"2,900 €"},{"v":5800,"d":"5800.00"},null,999999,"25000-30000 m³/h",{"v":69187.5,"d":"69,188 €"},{"v":46125,"d":"46,125 €"},{"v":92250,"d":"92250.00"}]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G79=\"\",F79=FALSE),\"\",HLOOKUP(N79,$AE$1:$AI$9,8,1)*E79*(1-O79))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[null,11,"\nPlanchers sur le sol ",null,null,false,null,{"$f":"IF(OR(G80=\"\",F80=FALSE),\"\",HLOOKUP(N80,$AE$1:$AI$9,8,1)*E80*(1-O80))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I80:I83)","v":{"v":0,"d":"0.0"}},{"v":1,"d":"1.00"},{"$f":"+K80*J80","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G81=\"\",F81=FALSE),\"\",HLOOKUP(N81,$AE$1:$AI$9,8,1)*E81*(1-O81))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[null,12,"\nMurs extérieurs en contact avec le sol (murs enterrés), un vide sanitaire ou une cave    ",null,null,false,null,{"$f":"IF(OR(G84=\"\",F84=FALSE),\"\",HLOOKUP(N84,$AE$1:$AI$9,7,1)*E84*(1-O84))","v":""},{"v":0,"d":"0.0"},{"$f":"SUM(I84:I87)","v":{"v":0,"d":"0.0"}},{"v":1,"d":"1.00"},{"$f":"+K84*J84","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G85=\"\",F85=FALSE),\"\",HLOOKUP(N85,$AE$1:$AI$9,7,1)*E85*(1-O85))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,"",{"$f":"D86*E86","v":{"v":0,"d":"0.0"}},{"$nulls":3},{"$f":"IF(F86=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,{"$f":"IF(OR(G87=\"\",F87=FALSE),\"\",HLOOKUP(N87,$AE$1:$AI$9,7,1)*E87*(1-O87))","v":""},{"v":0,"d":"0.0"},{"$nulls":3},{"$f":"IF(F87=TRUE,1,0)","v":0},"K<=20 + ",0,0,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$f":"+I89+I88","v":{"v":0,"d":"0.0"}},1,{"$f":"+K88*J88","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",null,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",null,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$f":"+I90+I91+I92+I93","v":{"v":0,"d":"0.0"}},{"v":0.6666666666666666,"d":"0.67"},{"$f":"+K90*J90","v":{"v":0,"d":"0.0"}},0,"K<=20 + ",null,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",null,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",null,0,0]
[{"$nulls":5},false,null,null,{"v":0,"d":"0.0"},{"$nulls":3},0,"K<=20 + ",null,0,0]
[null,13,"TOTAUX (superficie de déperdition) ","At = S Aj = ",{"$f":"SUM(E33:E37,E42:E87)","v":{"v":0,"d":"0.0"}},{"$nulls":5},"S aj . Uj .Aj = ",{"$f":"SUM(L33:L93)","v":{"v":0,"d":"0.0"}}]
[null,null,"Surfaces modifiées",null,{"$f":"SUM(R33:R37,R42:R87)","v":{"v":0,"d":"0.0"}},{"$f":"IF(AND(E95<E94*0.25,J124>20),1,0)","v":{"v":0,"d":"0.0"}}]
[{"$nulls":14},"vérification encodage",{"$f":"IF(SUM(P104:P107)>=1,1,0)","v":1}]
{"$rows_empty":7}
[{"$nulls":14},"les châssis",{"$f":"IF(OR(D33:D37<>0),0,1)","v":1},null,{"$f":"IF(P104=1,O104,\"\")","v":"les châssis"},{"$f":"IF(AND(P104=1,OR(P105:P107=1)),\",\",\"\")","v":","}]
[null,14,"NŒUDS CONSTRUCTIFS",{"$nulls":11},"les murs",{"$f":"IF(OR(D42:D47,D84:D87<>0),0,1)","v":1},{"$f":"IF(AND(P105=1,P104=1),\",\",\"\")","v":","},{"$f":"IF(P105=1,O105,\"\")","v":"les murs"},{"$f":"IF(AND(P105=1,OR(P106:P107=1)),\",\",\"\")","v":","},null,null,"PEB conforme"]
[null,null,"Valeur par défaut  : ","oui",{"$nulls":8},{"$f":"IF(AND(D106=\"non\",COUNTA(D111:E114)=0),1,0)","v":0},null,"le toit",{"$f":"IF(OR(D48:D51,D56:D67<>0),0,1)","v":1},{"$f":"IF(AND(P106=1,OR(P104:P105=1)),\",\",\"\")","v":","},"le toit",{"$f":"IF(AND(P106=1,P107=1),\",\",\"\")","v":","},null,null," PEB non conforme"]
[null,null,"Nœuds PEB conformes : ","non",{"$nulls":10},"le sol",{"$f":"IF(OR(D68:D83<>0),0,1)","v":1},{"$f":"IF(AND(P107=1,OR(P104:P106=1)),\",\",\"\")","v":","},"le sol"]
[{"$nulls":14},{"$f":"R104&S104&Q105&R105&S105&Q106&R106&S106&Q107&R107","v":"les châssis,,les murs,,le toit,,le sol"}]
[{"$nulls":14},{"$f":"SUBSTITUTE(O108,\",,\",\", \")","v":"les châssis, les murs, le toit, le sol"}]
[{"$nulls":3},"Ψlj          [W/(m.K)]","lj              [m]","Ψlj . lj          [W/K]","S Ψlj . lj                          [W/K]"]
[null,15,"Suivant les définitions de la NBN 62-002",null,null,{"$f":"D111*E111","v":{"v":0,"d":"0.0"}},{"$f":"+F111+F112+F113+F114","v":{"v":0,"d":"0.0"}}]
[{"$nulls":5},{"$f":"D112*E112","v":{"v":0,"d":"0.0"}}]
[{"$nulls":5},{"$f":"D113*E113","v":{"v":0,"d":"0.0"}}]
[{"$nulls":5},{"$f":"D114*E114","v":{"v":0,"d":"0.0"}}]
[]
[null,16,"DEPERDITION THERMIQUE DE LA SUPERFICIE DE DEPERDITION","S aj . Uj .Aj + S Ψlj . Lj   = ",{"$nulls":5},{"$f":"IF(OR(D106=\"oui\",D106=\"\"),L94,G111+L94)","v":{"v":0,"d":"0.0"}},null,"W/K"]
[null,17,"COEFFICIENT MOYEN DE TRANSMISSION THERMIQUE","Um = ",{"$nulls":5},{"$f":"+IF(E94=0,0,J116/E94)","v":{"v":0,"d":"0.0"}},null,"W/m².K"]
[null,18,"VOLUME PROTEGE DU BATIMENT","V = ",{"$nulls":7},"m³"]
[null,19,"COMPACITE VOLUMIQUE DU BATIMENT","V/At = ",{"$nulls":5},{"$f":"+IF(E94=0,0,J118/E94)","v":{"v":0,"d":"0.0"}},null,"m",{"$f":"IF(OR(J119<0.5,J119>5), 1,0)","v":1}]
[null,"18.","NIVEAU D'ISOLATION THERMIQUE GLOBALE DU BATIMENT","Si  V/At < 1 : Um x 100 =   K...",{"$nulls":5},{"$f":"+IF(J119<1.0001,J117*100,\" \")","v":0}]
[{"$nulls":3},"Si 1 < V/At < 4  : Um x 300/(V/At +2) = K…",{"$nulls":5},{"$f":"+IF(J119<1,\" \",IF(J119>4,\" \",J117*300/(J119+2)))","v":" "}]
[{"$nulls":3},"Si V/At > 4  : Um x 50 = K…",{"$nulls":5},{"$f":"IF(J119>3.9999,J117*50,\" \")","v":" "}]
[{"$nulls":3},"NIVEAU K : ",{"$nulls":5},{"$f":"IF(J120<>\" \",ROUND(J120,2),IF(J121<>\" \",ROUND(J121,2),IF(J122<>\" \",ROUND(J122,2),0)))","v":0}]
[null,20,"NIVEAU D'ISOLATION THERMIQUE GLOBALE DU BATIMENT","K = ",{"$nulls":5},{"$f":"IF(OR(J123=0,J118=\"\"),0,IF(D106=\"non\",J123,IF(AND(D106=\"oui\",D107=\"oui\"),J123+3,IF(AND(D106=\"oui\",D107=\"non\"),J123+10,0))))","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,null,"Placement d'un groupe de ventilation de type C",{"$nulls":3},"Placement d'un groupe de ventilation de type D"]
[]
[null,null,"Montant de subvention total (€)",{"$nulls":3},"Montant de subvention total (€)",{"$nulls":5},{"$f":"IF(AND(OR(D130<>0,J130<>0),SUM(H33:H87)=0),1,0)","v":0}]
{"$rows_empty":11}
[null,"2°","Calcul du montant de subvention"]
[]
[]
[]
[]
[]
[null,{"$f":"B151*B152*B154","v":1},"Problèmes : "]
[]
[null,{"$f":"IF(C150=\"\",1,0)","v":1}]
[null,{"$f":"IF(C151=\"\",1,0)","v":1}]
[null,1]
[]
[null,1]
[]
[]
[]
[]
[null,null,"Avertissements : "]
{"$rows_empty":11}
[null,null,"Montant total de subvention pour le remplacement des châssis : ",{"v":0,"d":"0.00 €"},null,{"$f":"SUM(H33:H41)","v":{"v":0,"d":"0.0"}}]
[null,null,"Montant total de subvention pour l'isolation du toit : ",{"v":0,"d":"0.00 €"},null,{"$f":"SUM(H48:H67)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant total de subvention pour l'isolation des murs : ",{"v":0,"d":"0.00 €"},null,{"$f":"SUM(H42:H47,H84:H87)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant total de subvention pour l'isolation des sols : ",{"v":0,"d":"0.00 €"},null,{"$f":"SUM(H68:H83)","v":{"v":0,"d":"0.00"}}]
[null,null,"Montant total de subvention pour le placement d'une ventilation :",{"v":0,"d":"0.00 €"},null,{"$f":"D130+J130","v":0}]
[]
[null,null,"Montant total de subvention ",{"v":0,"d":"0.00 €"}]
[]
[]
[]
[]
[]
[null,"3°","Encodage des consommations de chauffage des 3 dernières années"]
[]
[{"$nulls":12},"fuel","l"]
[null,null,"Année","Relevé",null,"Unité","Combustible",{"$nulls":5},"gaz naturel","m³"]
[null,null,2018,{"$nulls":9},"électricité","kWh"]
[null,null,2019,{"$nulls":9},"butane","kg"]
[null,null,2020,{"$nulls":9},"propane"]
[{"$nulls":12},"pellets"]
[{"$nulls":12},"bois"]
[{"$nulls":12},"charbon "]
[{"$nulls":12},"autre"]
[]
[]
[null,"4°","Eventuelles remarques sur les valeurs encodées : "]

{"sheet":"Ventilation","index":1,"n_rows":77,"n_cols":41,"rows_kept":77,"merged":[[19,2,19,4],[49,2,49,4]]}
{"$rows_empty":19}
[null,null,"Placement de système de ventilation de type C"]
[null,null,"Débit (m³/h)","Nombre de groupe ","Montant de subvention "]
[null,null,"Moins de 3000",null,{"$f":"IF(OR(D22=0,D22=\"\"),\"\",ROUND($AG$67*AI71,0)*D22)","v":""}]
[null,null,"3000-5000",null,""]
[null,null,"5001-10000",null,""]
[null,null,"10001-15000",null,""]
[null,null,"15001-2000",null,""]
[null,null,"20001-25000",null,""]
[null,null,"Plus de 25000",null,""]
{"$rows_empty":21}
[null,null,"Placement de système de ventilation de type D"]
[null,null,"Débit (m³/h)","Nombre de groupe ","Montant de subvention "]
[null,null,"Moins de 3000",null,{"$f":"IF(OR(D52=0,D52=\"\"),\"\",ROUND($AM$67*AO71,0)*Ventilation!D52)","v":""}]
[null,null,"3000-5000",null,{"$f":"IF(OR(D53=0,D53=\"\"),\"\",ROUND($AM$67*AO72,0)*Ventilation!D53)","v":""}]
[null,null,"5001-10000",null,{"$f":"IF(OR(D54=0,D54=\"\"),\"\",ROUND($AM$67*AO73,0)*Ventilation!D54)","v":""}]
[null,null,"10001-15000",null,{"$f":"IF(OR(D55=0,D55=\"\"),\"\",ROUND($AM$67*AO74,0)*Ventilation!D55)","v":""}]
[null,null,"15001-2000",null,{"$f":"IF(OR(D56=0,D56=\"\"),\"\",ROUND($AM$67*AO75,0)*Ventilation!D56)","v":""}]
[null,null,"20001-25000",null,{"$f":"IF(OR(D57=0,D57=\"\"),\"\",ROUND($AM$67*AO76,0)*Ventilation!D57)","v":""}]
[null,null,"Plus de 25000",null,{"$f":"IF(OR(D58=0,D58=\"\"),\"\",ROUND($AM$67*AO77,0)*Ventilation!D58)","v":""}]
{"$rows_empty":7}
[{"$nulls":31},"Catégorie de débit",{"$nulls":5},"Catégorie de débit"]
[{"$nulls":31},"niveau K",{"$f":"IF('Calcul du K'!J124<=20,0.75,0.5)","v":0.75},{"$nulls":4},"niveau K",{"$f":"IF('Calcul du K'!J124<=20,0.75,0.5)","v":0.75}]
[]
[]
[{"$nulls":31},"groupe ventilation type C",{"$nulls":5},"groupe ventilation type D"]
[{"$nulls":30},2999.99,"0-3000 m³/h",{"$f":"AI71*0.75","v":{"v":1200,"d":"1,200 €"}},{"$f":"AI71*0.5","v":{"v":800,"d":"800 €"}},{"v":1600,"d":"1600.00"},null,2999.99,"0-3000 m³/h",{"$f":"AO71*0.75","v":{"v":11250,"d":"11,250 €"}},{"$f":"AO71*0.5","v":{"v":7500,"d":"7,500 €"}},{"v":15000,"d":"15000.00"}]
[{"$nulls":30},5000.99,"3000-5000 m³/h",{"v":1425,"d":"1,425 €"},{"v":950,"d":"950 €"},{"v":1900,"d":"1900.00"},null,5000.99,"3000-5000 m³/h",{"$f":"AO72*0.75","v":{"v":12900,"d":"12,900 €"}},{"$f":"AO72*0.5","v":{"v":8600,"d":"8,600 €"}},{"v":17200,"d":"17200.00"}]
[{"$nulls":30},10000.99,"5000-10000 m³/h",{"v":2887.5,"d":"2,888 €"},{"v":1925,"d":"1,925 €"},{"v":3850,"d":"3850.00"},null,10000.99,"5000-10000 m³/h",{"v":16650,"d":"16,650 €"},{"v":11100,"d":"11,100 €"},{"v":22200,"d":"22200.00"}]
[{"$nulls":30},15000.99,"10000-15000 m³/h",{"v":3037.5,"d":"3,038 €"},{"v":2025,"d":"2,025 €"},{"v":4050,"d":"4050.00"},null,15000.99,"10000-15000 m³/h",{"v":23062.5,"d":"23,063 €"},{"v":15375,"d":"15,375 €"},{"v":30750,"d":"30750.00"}]
[{"$nulls":30},20000.99,"15000-20000 m³/h",{"v":3225,"d":"3,225 €"},{"v":2150,"d":"2,150 €"},{"v":4300,"d":"4300.00"},null,20000.99,"15000-20000 m³/h",{"v":46350,"d":"46,350 €"},{"v":30900,"d":"30,900 €"},{"v":61800,"d":"61800.00"}]
[{"$nulls":30},25000.99,"20000-25000 m³/h",{"v":3675,"d":"3,675 €"},{"v":2450,"d":"2,450 €"},{"v":4900,"d":"4900.00"},null,25000.99,"20000-25000 m³/h",{"v":54000,"d":"54,000 €"},{"v":36000,"d":"36,000 €"},{"v":72000,"d":"72000.00"}]
[{"$nulls":30},999999,"25000-30000 m³/h",{"v":4350,"d":"4,350 €"},{"v":2900,"d":"2,900 €"},{"v":5800,"d":"5800.00"},null,999999,"25000-30000 m³/h",{"v":69187.5,"d":"69,188 €"},{"v":46125,"d":"46,125 €"},{"v":92250,"d":"92250.00"}]

{"sheet":"Parois moyennes","index":2,"n_rows":595,"n_cols":10,"rows_kept":595,"merged":[[1,1,1,3],[1,7,1,9],[64,1,64,3],[64,7,64,9],[114,1,114,3],[114,7,114,9],[164,1,164,3],[164,7,164,9],[214,1,214,3],[214,7,214,9],[264,1,264,3],[264,7,264,9],[314,1,314,3],[314,7,314,9],[364,1,364,3],[364,7,364,9],[414,1,414,3],[414,7,414,9],[464,1,464,3],[464,7,464,9],[514,1,514,3],[514,7,514,9],[564,1,564,3],[564,7,564,9]]}
[]
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":41}
[null,"Paroi équivalente",{"$f":"IF(D47=\"\",\"\",SUMPRODUCT(C6:C45,D6:D45)/D47)","v":""},{"$f":"IF(SUM(D6:D45)=0,\"\",SUM(D6:D45))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J47=\"\",\"\",SUMPRODUCT(I6:I45,J6:J45)/J47)","v":""},{"$f":"IF(SUM(J6:J45)=0,\"\",SUM(J6:J45))","v":""}]
{"$rows_empty":17}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D95=\"\",\"\",SUMPRODUCT(C69:C93,D69:D93)/D95)","v":""},{"$f":"IF(SUM(D69:D93)=0,\"\",SUM(D69:D93))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J95=\"\",\"\",SUMPRODUCT(I69:I93,J69:J93)/J95)","v":""},{"$f":"IF(SUM(J69:J93)=0,\"\",SUM(J69:J93))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D145=\"\",\"\",SUMPRODUCT(C119:C143,D119:D143)/D145)","v":""},{"$f":"IF(SUM(D119:D143)=0,\"\",SUM(D119:D143))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J145=\"\",\"\",SUMPRODUCT(I119:I143,J119:J143)/J145)","v":""},{"$f":"IF(SUM(J119:J143)=0,\"\",SUM(J119:J143))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D195=\"\",\"\",SUMPRODUCT(C169:C193,D169:D193)/D195)","v":""},{"$f":"IF(SUM(D169:D193)=0,\"\",SUM(D169:D193))","v":""}]
{"$rows_empty":19}
[null,"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D245=\"\",\"\",SUMPRODUCT(C219:C243,D219:D243)/D245)","v":""},{"$f":"IF(SUM(D219:D243)=0,\"\",SUM(D219:D243))","v":""}]
{"$rows_empty":19}
[null,"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D295=\"\",\"\",SUMPRODUCT(C269:C293,D269:D293)/D295)","v":""},{"$f":"IF(SUM(D269:D293)=0,\"\",SUM(D269:D293))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D345=\"\",\"\",SUMPRODUCT(C319:C343,D319:D343)/D345)","v":""},{"$f":"IF(SUM(D319:D343)=0,\"\",SUM(D319:D343))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J345=\"\",\"\",SUMPRODUCT(I319:I343,J319:J343)/J345)","v":""},{"$f":"IF(SUM(J319:J343)=0,\"\",SUM(J319:J343))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D395=\"\",\"\",SUMPRODUCT(C369:C393,D369:D393)/D395)","v":""},{"$f":"IF(SUM(D369:D393)=0,\"\",SUM(D369:D393))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J395=\"\",\"\",SUMPRODUCT(I369:I393,J369:J393)/J395)","v":""},{"$f":"IF(SUM(J369:J393)=0,\"\",SUM(J369:J393))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D445=\"\",\"\",SUMPRODUCT(C419:C443,D419:D443)/D445)","v":""},{"$f":"IF(SUM(D419:D443)=0,\"\",SUM(D419:D443))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J445=\"\",\"\",SUMPRODUCT(I419:I443,J419:J443)/J445)","v":""},{"$f":"IF(SUM(J419:J443)=0,\"\",SUM(J419:J443))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D495=\"\",\"\",SUMPRODUCT(C469:C493,D469:D493)/D495)","v":""},{"$f":"IF(SUM(D469:D493)=0,\"\",SUM(D469:D493))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J495=\"\",\"\",SUMPRODUCT(I469:I493,J469:J493)/J495)","v":""},{"$f":"IF(SUM(J469:J493)=0,\"\",SUM(J469:J493))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D545=\"\",\"\",SUMPRODUCT(C519:C543,D519:D543)/D545)","v":""},{"$f":"IF(SUM(D519:D543)=0,\"\",SUM(D519:D543))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J545=\"\",\"\",SUMPRODUCT(I519:I543,J519:J543)/J545)","v":""},{"$f":"IF(SUM(J519:J543)=0,\"\",SUM(J519:J543))","v":""}]
{"$rows_empty":19}
[null,"Parois non modifiées ",{"$nulls":5},"Parois modifiées "]
[]
[]
[null,"Parois","Uj [W/(m².K)]","Aj [m²]",{"$nulls":3},"Parois","Uj [W/(m².K)]","Aj [m²]"]
{"$rows_empty":26}
[null,"Paroi équivalente",{"$f":"IF(D595=\"\",\"\",SUMPRODUCT(C569:C593,D569:D593)/D595)","v":""},{"$f":"IF(SUM(D569:D593)=0,\"\",SUM(D569:D593))","v":""},{"$nulls":3},"Paroi équivalente",{"$f":"IF(J595=\"\",\"\",SUMPRODUCT(I569:I593,J569:J593)/J595)","v":""},{"$f":"IF(SUM(J569:J593)=0,\"\",SUM(J569:J593))","v":""}]

{"sheet":"Parois types","index":3,"n_rows":56,"n_cols":4,"rows_kept":56}
[]
[]
[null,"         Attention, les valeurs reprises ci-dessous sont indicatives. Elles varient en fonction des"]
[null,"         matériaux utilisés réellement dans la composition de chaque paroi."]
[]
[]
[]
[null,"Type de paroi","Coefficient kj (ou U)"]
[]
[null,"Fenétre avec simple vitrage",6,"W/m²K"]
[null,"Fenêtre avec double vitrage traditionnel",3,"W/m²K"]
[null,"Fenêtre avec double vitrage HR",1.5,"W/m²K"]
[null,"Fenêtre avec triple vitrage",0.8,"W/m²K"]
[]
[null,"Porte en bois",2.5,"W/m²K"]
[null,"Porte en aluminium isolé",1.5,"W/m²K"]
[]
[null,"Mur plein de 29 cm",2.2,"W/m²K"]
[null,"Mur plein de 39 cm",1.8,"W/m²K"]
[null,"Mur creux non isolé",1.7,"W/m²K"]
[null,"Mur creux isolé existant",0.45,"W/m²K"]
[null,"Mur plein bardé non isolé",1.8,"W/m²K"]
[null,"Mur plein bardé isolé existant",0.5,"W/m²K"]
[null,"Mur de pierre non isolé de 30 cm",{"$f":"ROUND(1/(0.17+0.3/3.49),1)","v":3.9},"W/m²K"]
[null,"Mur de pierre non isolé de 40 cm",{"$f":"ROUND(1/(0.17+0.4/3.49),1)","v":3.5},"W/m²K"]
[null,"Mur de pierre non isolé de 50 cm",{"$f":"ROUND(1/(0.17+0.5/3.49),1)","v":3.2},"W/m²K"]
[null,"Mur de pierre non isolé de 60 cm",{"$f":"ROUND(1/(0.17+0.6/3.49),1)","v":2.9},"W/m²K"]
[null,"Mur de béton cellulaire de 25 cm (collé)",{"$f":"ROUND(1/(0.17+0.25/0.19),1)","v":0.7},"W/m²K"]
[null,"Mur de béton cellulaire de 30 cm (collé)",{"$f":"ROUND(1/(0.17+0.3/0.19),1)","v":0.6},"W/m²K"]
[null,"Mur de béton cellulaire de 35 cm (collé)",{"$f":"ROUND(1/(0.17+0.35/0.19),1)","v":0.5},"W/m²K"]
[null,"Mur aux normes PEB 2015",0.24,"W/m²K"]
[null,"Mur \"passif\"",0.15,"W/m²K"]
[]
[null,"Toiture plate en béton non isolée",2.8,"W/m²K"]
[null,"Toiture plate en béton isolée existante",0.45,"W/m²K"]
[null,"Toiture inclinée isolée (6 cm de laine)",0.6,"W/m²K"]
[null,"Toiture inclinée isolée (8 cm de laine)",0.45,"W/m²K"]
[null,"Toiture inclinée isolée (10 cm de laine)",0.37,"W/m²K"]
[null,"Toiture aux normes PEB 2015",0.24,"W/m²K"]
[null,"Toiture \"passive\"",0.1,"W/m²K"]
[null,"Plancher en bois de combles inoccupés non isolé",1.7,"W/m²K"]
[null,"Plancher en bois de combles inoccupés isolé existant",0.4,"W/m²K"]
[null,"Plancher en béton de combles inoccupés non isolé",2.6,"W/m²K"]
[null,"Plancher en béton de combles inoccupés isolé existant",0.4,"W/m²K"]
[]
[null,"Plancher sur cave en béton non isolé",2,"W/m²K"]
[null,"Plancher sur sol en béton non isolé",3.2,"W/m²K"]
[null,"Plancher sur cave en béton isolé existant",0.7,"W/m²K"]
[null,"Plancher sur sol en béton isolé existant",0.9,"W/m²K"]
[null,"Plancher sur cave aux normes PEB 2015",0.3,"W/m²K"]
[null,"Plancher sur sol aux normes PEB 2015",0.3,"W/m²K"]
[null,"Plancher \"passif\"",0.15,"W/m²K"]
[]
[]
[null,null,"Pour imprimer cette feuille sur votre "]
[null,null,"imprimante par défaut, cliquez ici :"]