{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Aérat. sur le vitrage","Aérat. sur la fenêtre","Aérat. sur le vitrage (exemple)","Aérat. sur la fenêtre (exemple)","Lijst verluchtingen","Taal"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":4,"defined_names":226,"comments":4,"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":"Aérat. sur le vitrage","index":0,"n_rows":54,"n_cols":45,"rows_kept":54,"cut":false,"hidden":false,"merged":[[16,1,16,19],[16,20,16,22],[16,23,16,25],[16,26,16,28],[5,0,5,33],[6,0,6,33],[8,8,8,33],[10,8,10,33],[12,8,12,33],[19,1,19,19],[19,20,19,22],[19,23,19,25],[19,26,19,28],[17,1,17,19],[17,20,17,22],[17,23,17,25],[17,26,17,28],[18,1,18,19],[18,20,18,22],[18,23,18,25],[18,26,18,28],[20,44,20,46],[24,17,24,28],[27,1,27,19],[27,20,27,22],[27,23,27,25],[27,26,27,28],[24,44,24,46],[20,1,20,19],[20,20,20,22],[20,23,20,25],[20,26,20,28],[20,36,20,38],[20,39,20,41],[27,36,27,38],[27,39,27,41],[24,36,24,38],[30,26,30,28],[34,20,34,33],[37,28,37,32],[28,1,28,19],[28,20,28,22],[28,23,28,25],[28,26,28,28],[29,1,29,19],[29,20,29,22],[29,23,29,25],[29,26,29,28],[31,1,31,19],[31,20,31,22],[31,23,31,25],[31,26,31,28],[32,1,32,19],[49,14,49,16],[52,0,52,33],[53,0,53,33],[16,36,16,38],[16,39,16,41],[17,36,17,38],[17,39,17,41],[39,18,39,24],[40,1,40,5],[40,9,40,14],[40,28,40,30],[41,9,41,11],[41,12,41,14],[30,1,30,19],[30,20,30,22],[30,23,30,25],[32,39,32,41],[24,39,24,41],[44,35,44,36],[28,36,28,38],[28,39,28,41],[29,36,29,38],[29,39,29,41],[30,36,30,38],[30,39,30,41],[31,36,31,38],[31,39,31,41],[40,18,40,24],[32,20,32,22],[32,23,32,25],[32,26,32,28],[32,36,32,38]]}
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus"]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:"]
[]
["Référence:"]
[]
["pièce d' epreuve:"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,null,{"$f":"X17/1000","v":0},null,null,"m"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,null,{"$f":"X18/1000","v":0},null,null,"m"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw",null,null,null,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique du vitrage:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug",null,null,null,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique linéaire                                                                 pour les jonctions entre les profilés et les vitrages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yg",null,null,null,null,null,"W/mK",null,null,null,null,null,null,null,null,null,0.05,null,null,"W/mK",null,null,null,{"$f":"IF(X21=0,AK21,X21)","v":0.05},"W/mK"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,2,FALSE)","v":{"$error":"#N/A"}},null,null,"W/m²K",null,null,null,{"$f":"VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,3,FALSE)","v":{"$error":"#N/A"}},"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Longueur aérateur 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr1",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X28>0,1,0)","v":0},{"$f":"X28/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr2",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X29>0,1,0)","v":0},{"$f":"X29/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr3",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X30>0,1,0)","v":0},{"$f":"X30/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr4",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X31>0,1,0)","v":0},{"$f":"X31/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr5",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X32>0,1,0)","v":0},{"$f":"X32/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr6",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,0,0,null,null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur",{"$f":"IF(R25=0,\"= ? W/m²K\",CONCATENATE(\"= \",VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,2,FALSE),\" W/m²K\"))","v":"= ? W/m²K"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R25=0,\"= ? mm\",VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,3,FALSE)*1000)","v":"= ? mm"},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"IF(X17=0,\"? mm\",X17)","v":"? mm"},null,null,null,null,null,null,null,"Uw,incl. Aérateur",null,null,null,null,null,null,null,null,"Lri",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(X17=0,X18=0,X19=0,X20=0,R25=0,COUNTIF(X28:Z33,\">0\")=0),\"?\",X19+((AK25-X20)*(AK28+AK29+AK30+AK31+AK32+AK33)*AR25-AR21*COUNTIF(AJ28:AJ33,1)*2*AR25)/(AK17*AK18))","v":"?"},null,null,"W/m²K"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X18=0,\"?\",X18)","v":"?"},null,null,"mm"]
[]
[]
["(1) Conforme  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]

{"sheet":"Aérat. sur la fenêtre","index":1,"n_rows":65,"n_cols":55,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,0,5,35],[55,8,55,10],[55,11,55,13],[55,39,55,40],[56,39,56,40],[60,13,60,15],[52,0,53,4],[52,7,52,14],[53,7,53,9],[53,30,53,35],[54,8,54,13],[54,39,54,40],[40,29,40,31],[38,29,38,31],[39,26,39,28],[37,29,37,31],[38,1,38,3],[38,4,38,6],[38,7,38,9],[38,10,38,12],[38,13,38,15],[38,16,38,19],[38,20,38,22],[38,23,38,25],[40,47,40,48],[41,36,41,38],[41,45,41,46],[45,31,45,34],[48,10,49,11],[48,23,49,24],[39,29,39,31],[40,1,40,3],[40,4,40,6],[40,7,40,9],[40,10,40,12],[40,13,40,15],[40,16,40,19],[40,20,40,22],[40,23,40,25],[40,26,40,28],[39,1,39,3],[39,4,39,6],[39,7,39,9],[39,10,39,12],[39,13,39,15],[39,16,39,19],[39,20,39,22],[39,23,39,25],[38,26,38,28],[34,29,34,31],[37,1,37,3],[37,4,37,6],[37,7,37,9],[37,10,37,12],[37,13,37,15],[37,16,37,19],[37,20,37,22],[37,23,37,25],[37,26,37,28],[34,1,34,3],[34,4,34,6],[34,7,34,9],[34,10,34,12],[34,13,34,15],[34,16,34,19],[34,20,34,22],[34,23,34,25],[34,26,34,28],[32,16,32,19],[32,20,32,22],[32,23,32,25],[32,26,32,28],[32,29,32,31],[33,1,33,3],[33,4,33,6],[33,7,33,9],[33,10,33,12],[33,13,33,15],[33,16,33,19],[33,20,33,22],[33,23,33,25],[33,26,33,28],[33,29,33,31],[27,44,27,46],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,12],[30,13,30,15],[30,16,30,19],[30,20,30,22],[30,23,30,25],[30,26,30,28],[27,1,27,22],[27,23,27,25],[27,26,27,28],[27,29,27,31],[27,36,27,38],[27,39,27,41],[30,29,30,31],[25,45,25,46],[26,1,26,22],[26,23,26,25],[26,26,26,28],[26,29,26,31],[18,1,18,22],[18,23,18,25],[18,26,18,28],[18,29,18,31],[22,29,22,31],[23,29,23,31],[6,0,6,35],[8,8,8,35],[10,8,10,35],[12,8,12,35],[16,1,16,22],[16,23,16,25],[16,26,16,28],[16,29,16,31],[25,1,25,18],[25,19,25,31],[23,1,23,28],[63,0,63,35],[62,0,62,35],[64,0,65,35],[16,36,16,38],[17,1,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,31],[17,36,17,38],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,12],[31,13,31,15],[31,16,31,19],[31,20,31,22],[31,23,31,25],[31,26,31,28],[31,29,31,31],[32,1,32,3],[32,4,32,6],[32,7,32,9],[32,10,32,12],[32,13,32,15]]}
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus"]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:"]
[]
["Référence:"]
[]
["pièce d' epreuve:"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw =",null,null,null,null,null,"mm",null,null,null,null,null,null,{"$f":"AA17/1000","v":0},null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw =",null,null,null,null,null,"mm",null,null,null,null,null,null,{"$f":"AA18/1000","v":0},null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neen"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw =",null,null,null,null,null,"W/m²K"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Hauteur du fenêtre incluant l' aérateur:"]
[null,"Les dimensions et les valeurs U des différents profils de fenêtres et des panneaux vitrés sont connues : "]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur =",{"$f":"VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,2,FALSE)","v":{"$error":"#N/A"}},null,"hr =",{"$f":"VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,3,FALSE)","v":{"$error":"#N/A"}},null,"Ar =",null,{"$f":"AT26*AA18/1000000","v":{"$error":"#N/A"}},"m²"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug =",null,null,null,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique linéaire pour les jonctions entre les profilés et les vitrages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yg =",null,null,null,null,null,"W/mK",null,null,null,null,null,null,0.05,null,null,"W/mK",null,null,null,{"$f":"IF(AA28=0,AK28,AA28)","v":0.05},"W/mK",null,null,null,null,null,"Onbekend"]
[]
[null,"Profils raccourcis"]
[null,"x",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"Uf,x",null,null,"[W/m²K]"]
[null,"bf,x",null,null,"[mm]"]
[null,"bf,x",null,null,"[m]",null,null,{"$f":"H33/1000","v":0},null,null,{"$f":"K33/1000","v":0},null,null,{"$f":"N33/1000","v":0},null,null,{"$f":"Q33/1000","v":0},null,null,null,{"$f":"U33/1000","v":0},null,null,{"$f":"X33/1000","v":0},null,null,{"$f":"AA33/1000","v":0},null,null,{"$f":"AD33/1000","v":0}]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,{"$f":"$AT$26*H34*H32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*K34*K32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*N34*N32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*Q34*Q32","v":{"$error":"#N/A"}},null,null,null,{"$f":"$AT$26*U34*U32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*X34*X32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*AA34*AA32","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*AD34*AD32","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H35:AF35)","v":{"$error":"#N/A"}}]
[]
[null,"Déduction de vitrage:"]
[null,"y",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"bg,y",null,null,"[mm]"]
[null,"bg,y",null,null,"[m]",null,null,{"$f":"H39/1000","v":0},null,null,{"$f":"K39/1000","v":0},null,null,{"$f":"N39/1000","v":0},null,null,{"$f":"Q39/1000","v":0},null,null,null,{"$f":"U39/1000","v":0},null,null,{"$f":"X39/1000","v":0},null,null,{"$f":"AA39/1000","v":0},null,null,{"$f":"AD39/1000","v":0}]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,{"$f":"$AT$26*H40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*K40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*N40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*Q40*$AA$27","v":{"$error":"#N/A"}},null,null,null,{"$f":"$AT$26*U40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*X40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*AA40*$AA$27","v":{"$error":"#N/A"}},null,null,{"$f":"$AT$26*AD40*$AA$27","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H41:AF41)","v":{"$error":"#N/A"}},null,null,null,"aantal glasplaten:",{"$f":"8-COUNTIF(H41:AF41,0)","v":8}]
[null,"Erreur: S bf,x + Sbg,y doit être égal à Bw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF((SUM(H33:W33)+SUM(H39:AJ39)-AA18)<0,\"=> trop court: \",\"=> trop long: \"),ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18),\" mm!\")","v":"=> trop long: 0 mm!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H33:W33)+SUM(H39:AJ39)","v":0},null,null,"m",null,null,"verschil =",{"$f":"ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur",{"$f":"IF(T26=0,\"= ? W/m²K\",CONCATENATE(\"= \",VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,2,FALSE),\" W/m²K\"))","v":"= ? W/m²K"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr =",{"$f":"IF(T26=0,\"? mm\",VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,3,FALSE)*1000)","v":"? mm"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"bg,x",null,null,null,null,null,null,null,null,null,null,null,null,"bf,y"]
[]
[]
[]
[{"$f":"IF(AA17=0,\"? mm\",IF(AQ23=TRUE,AA17,AA17+AF46))","v":"? mm"},null,null,null,null,null,null,"Ug,x ; Ag,x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uf,y ; Af,y",null,null,null,"hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA17=0,T26=0),\"? mm\",A53-AF46)","v":"? mm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/m²K"]
[null,null,null,null,null,null,null,null,"Uw,incl. Aérateur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Hoogte excl. verluchting",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0),\"?\",((AA19*AK17*AK18)+(AQ26*AK18*AT26))/((AK17*AK18)+(AK18*AT26)))","v":"?"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AQ23<>TRUE,AU55,IF(AQ24<>TRUE,AU56,AU57))","v":"?"},null,null,"W/m²K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1",null,"Hoogte incl. verluchting (vereenv.)",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0,AA27=0),\"?\",((AA19*AK17*AK18)+(AQ26-MIN(AA19,AA27))*(AT26*AK18))/(AK17*AK18))","v":"?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2",null,"Hoogte incl. verluchting (vereenv.)",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0,AA27=0,AR42<>0),\"?\",(AA19*AK17*AK18+AQ26*AK18*AT26-AQ35-AQ41-2*AV41*AT26*AR28)/(AK17*AK18))","v":"?"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA18=0,\"?\",AA18)","v":"?"},null,null,"mm"]
[]
["(1) Conforme  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]
["(3) Simplification : comme valeur sûre, la surface de l’aérateur remplace une partie de la surface de la ‘fenêtre sans aérateur’ dont la valeur U = min (Ug et Uw)"]

{"sheet":"Aérat. sur le vitrage (exemple)","index":2,"n_rows":52,"n_cols":45,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,33],[6,0,6,33],[8,8,8,33],[10,8,10,33],[12,8,12,33],[16,36,16,38],[16,39,16,41],[17,1,17,19],[17,20,17,22],[17,23,17,25],[17,26,17,28],[17,36,17,38],[17,39,17,41],[16,1,16,19],[16,20,16,22],[16,23,16,25],[16,26,16,28],[18,1,18,19],[18,20,18,22],[18,23,18,25],[18,26,18,28],[19,1,19,19],[19,20,19,22],[19,23,19,25],[19,26,19,28],[20,44,20,46],[24,17,24,28],[24,36,24,38],[24,39,24,41],[24,44,24,46],[20,1,20,19],[20,20,20,22],[20,23,20,25],[20,26,20,28],[20,36,20,38],[20,39,20,41],[27,39,27,41],[28,1,28,19],[28,20,28,22],[28,23,28,25],[28,26,28,28],[28,36,28,38],[28,39,28,41],[27,1,27,19],[27,20,27,22],[27,23,27,25],[27,26,27,28],[27,36,27,38],[30,39,30,41],[29,1,29,19],[29,20,29,22],[29,23,29,25],[29,26,29,28],[29,36,29,38],[29,39,29,41],[30,1,30,19],[30,20,30,22],[30,23,30,25],[30,26,30,28],[30,36,30,38],[42,35,42,36],[47,14,47,16],[50,0,50,33],[51,0,51,33],[32,20,32,33],[35,28,35,32],[37,18,37,24],[38,1,38,5],[38,9,38,14],[38,28,38,30],[39,9,39,11],[39,12,39,14]]}
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus"]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:",null,null,null,null,null,null,null,"adg"]
[]
["Référence:",null,null,null,null,null,null,null,"Raam 030"]
[]
["pièce d' epreuve:",null,null,null,null,null,null,null,"note de calcule menuisier"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw",null,null,1480,null,null,"mm",null,null,null,null,null,null,null,null,null,{"$f":"X17/1000","v":1.48},null,null,"m"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw",null,null,1230,null,null,"mm",null,null,null,null,null,null,null,null,null,{"$f":"X18/1000","v":1.23},null,null,"m"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw",null,null,1.41,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique du vitrage:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug",null,null,1.1000000000000001,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique linéaire                                                                 pour les jonctions entre les profilés et les vitrages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yg",null,null,null,null,null,"W/mK",null,null,null,null,null,null,null,null,null,0.05,null,null,"W/mK",null,null,null,{"$f":"IF(X21=0,AK21,X21)","v":0.05},"W/mK"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AR75 Small",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,2,FALSE)","v":3},null,null,"W/m²K",null,null,null,{"$f":"VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,3,FALSE)","v":7.4999999999999997E-2},"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Longueur aérateur 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr1",null,null,1130,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X28>0,1,0)","v":1},{"$f":"X28/1000","v":1.1299999999999999},null,null,"m"]
[null,"Longueur aérateur 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr2",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X29>0,1,0)","v":0},{"$f":"X29/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr3",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X30>0,1,0)","v":0},{"$f":"X30/1000","v":0},null,null,"m"]
[null,"Longueur aérateur 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lr4",null,null,null,null,null,"mm",null,null,null,null,null,null,null,null,{"$f":"IF(X31>0,1,0)","v":0},{"$f":"X31/1000","v":0},null,null,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur",{"$f":"IF(R25=0,\"= ? W/m²K\",CONCATENATE(\"= \",VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,2,FALSE),\" W/m²K\"))","v":"= 3 W/m²K"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R25=0,\"= ? mm\",VLOOKUP(R25,'Lijst verluchtingen'!B5:D174,3,FALSE)*1000)","v":75},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lri",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"IF(X17=0,\"? mm\",X17)","v":1480},null,null,null,null,null,null,null,"Uw,incl. Aérateur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(X17=0,X18=0,X19=0,X20=0,R25=0,X28=0),\"?\",X19+((AK25-X20)*(AK28+AK29+AK30+AK31)*AR25-AR21*COUNTIF(AJ28:AJ31,1)*2*AR25)/(AK17*AK18))","v":1.4943358602504944},null,null,"W/m²K"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X18=0,\"?\",X18)","v":1230},null,null,"mm"]
[]
[]
["(1) Conforme  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]

{"sheet":"Aérat. sur la fenêtre (exemple)","index":3,"n_rows":194,"n_cols":64,"rows_kept":194,"cut":false,"hidden":false,"merged":[[170,47,170,48],[171,36,171,38],[171,45,171,46],[184,39,184,40],[185,39,185,40],[186,39,186,40],[105,47,105,48],[106,36,106,38],[106,45,106,46],[119,39,119,40],[120,39,120,40],[121,39,121,40],[135,63,140,89],[146,36,146,38],[147,36,147,38],[190,13,190,15],[192,0,192,35],[193,0,193,35],[194,0,195,35],[81,36,81,38],[82,36,82,38],[90,45,90,46],[92,36,92,38],[92,39,92,41],[92,44,92,46],[155,45,155,46],[157,36,157,38],[157,39,157,41],[157,44,157,46],[175,31,175,34],[178,10,179,11],[178,23,179,24],[182,0,183,4],[182,7,182,14],[183,7,183,9],[183,30,183,35],[184,8,184,13],[185,8,185,10],[185,11,185,13],[169,29,169,31],[170,1,170,3],[170,4,170,6],[170,7,170,9],[170,10,170,12],[170,13,170,15],[170,16,170,19],[170,20,170,22],[170,23,170,25],[170,26,170,28],[170,29,170,31],[169,1,169,3],[169,4,169,6],[169,7,169,9],[169,10,169,12],[169,13,169,15],[169,16,169,19],[169,20,169,22],[169,23,169,25],[169,26,169,28],[167,29,167,31],[168,1,168,3],[168,4,168,6],[168,7,168,9],[168,10,168,12],[168,13,168,15],[168,16,168,19],[168,20,168,22],[168,23,168,25],[168,26,168,28],[168,29,168,31],[167,1,167,3],[167,4,167,6],[167,7,167,9],[167,10,167,12],[167,13,167,15],[167,16,167,19],[167,20,167,22],[167,23,167,25],[167,26,167,28],[163,29,163,31],[164,1,164,3],[164,4,164,6],[164,7,164,9],[164,10,164,12],[164,13,164,15],[164,16,164,19],[164,20,164,22],[164,23,164,25],[164,26,164,28],[164,29,164,31],[163,1,163,3],[163,4,163,6],[163,7,163,9],[163,10,163,12],[163,13,163,15],[163,16,163,19],[163,20,163,22],[163,23,163,25],[163,26,163,28],[161,29,161,31],[162,1,162,3],[162,4,162,6],[162,7,162,9],[162,10,162,12],[162,13,162,15],[162,16,162,19],[162,20,162,22],[162,23,162,25],[162,26,162,28],[162,29,162,31],[161,1,161,3],[161,4,161,6],[161,7,161,9],[161,10,161,12],[161,13,161,15],[161,16,161,19],[161,20,161,22],[161,23,161,25],[161,26,161,28],[156,1,156,22],[156,23,156,25],[156,26,156,28],[156,29,156,31],[157,1,157,22],[157,23,157,25],[157,26,157,28],[157,29,157,31],[160,1,160,3],[160,4,160,6],[160,7,160,9],[160,10,160,12],[160,13,160,15],[160,16,160,19],[160,20,160,22],[160,23,160,25],[160,26,160,28],[160,29,160,31],[148,1,148,22],[148,23,148,25],[148,26,148,28],[148,29,148,31],[152,29,152,31],[153,1,153,28],[153,29,153,31],[155,1,155,18],[155,19,155,31],[140,8,140,35],[142,8,142,35],[146,1,146,22],[146,23,146,25],[146,26,146,28],[146,29,146,31],[147,1,147,22],[147,23,147,25],[147,26,147,28],[147,29,147,31],[120,8,120,10],[120,11,120,13],[125,13,125,15],[127,0,127,35],[128,0,128,35],[129,0,129,35],[135,0,135,35],[136,0,136,35],[138,8,138,35],[105,29,105,31],[110,31,110,34],[113,10,114,11],[113,23,114,24],[117,0,118,4],[117,7,117,14],[118,7,118,9],[118,30,118,35],[119,8,119,13],[105,1,105,3],[105,4,105,6],[105,7,105,9],[105,10,105,12],[105,13,105,15],[105,16,105,19],[105,20,105,22],[105,23,105,25],[105,26,105,28],[103,29,103,31],[104,1,104,3],[104,4,104,6],[104,7,104,9],[104,10,104,12],[104,13,104,15],[104,16,104,19],[104,20,104,22],[104,23,104,25],[104,26,104,28],[104,29,104,31],[103,1,103,3],[103,4,103,6],[103,7,103,9],[103,10,103,12],[103,13,103,15],[103,16,103,19],[103,20,103,22],[103,23,103,25],[103,26,103,28],[99,29,99,31],[102,1,102,3],[102,4,102,6],[102,7,102,9],[102,10,102,12],[102,13,102,15],[102,16,102,19],[102,20,102,22],[102,23,102,25],[102,26,102,28],[102,29,102,31],[99,1,99,3],[99,4,99,6],[99,7,99,9],[99,10,99,12],[99,13,99,15],[99,16,99,19],[99,20,99,22],[99,23,99,25],[99,26,99,28],[97,29,97,31],[98,1,98,3],[98,4,98,6],[98,7,98,9],[98,10,98,12],[98,13,98,15],[98,16,98,19],[98,20,98,22],[98,23,98,25],[98,26,98,28],[98,29,98,31],[97,1,97,3],[97,4,97,6],[97,7,97,9],[97,10,97,12],[97,13,97,15],[97,16,97,19],[97,20,97,22],[97,23,97,25],[97,26,97,28],[95,29,95,31],[96,1,96,3],[96,4,96,6],[96,7,96,9],[96,10,96,12],[96,13,96,15],[96,16,96,19],[96,20,96,22],[96,23,96,25],[96,26,96,28],[96,29,96,31],[95,1,95,3],[95,4,95,6],[95,7,95,9],[95,10,95,12],[95,13,95,15],[95,16,95,19],[95,20,95,22],[95,23,95,25],[95,26,95,28],[90,19,90,31],[91,1,91,22],[91,23,91,25],[91,26,91,28],[91,29,91,31],[92,1,92,22],[92,23,92,25],[92,26,92,28],[92,29,92,31],[5,63,10,89],[70,63,75,89],[70,0,70,35],[71,0,71,35],[73,8,73,35],[75,8,75,35],[77,8,77,35],[81,1,81,22],[81,23,81,25],[81,26,81,28],[81,29,81,31],[5,0,5,35],[6,0,6,35],[8,8,8,35],[10,8,10,35],[12,8,12,35],[25,45,25,46],[23,1,23,28],[23,29,23,31],[27,44,27,46],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,12],[82,1,82,22],[82,23,82,25],[82,26,82,28],[82,29,82,31],[83,1,83,22],[83,23,83,25],[83,26,83,28],[83,29,83,31],[87,29,87,31],[88,1,88,28],[88,29,88,31],[90,1,90,18],[16,36,16,38],[17,1,17,22],[17,23,17,25],[17,26,17,28],[17,29,17,31],[17,36,17,38],[16,1,16,22],[16,23,16,25],[16,26,16,28],[16,29,16,31],[25,1,25,18],[25,19,25,31],[26,1,26,22],[26,23,26,25],[26,26,26,28],[26,29,26,31],[18,1,18,22],[18,23,18,25],[18,26,18,28],[18,29,18,31],[22,29,22,31],[27,36,27,38],[27,39,27,41],[30,29,30,31],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,12],[31,13,31,15],[31,16,31,19],[31,20,31,22],[31,23,31,25],[31,26,31,28],[31,29,31,31],[30,13,30,15],[30,16,30,19],[30,20,30,22],[30,23,30,25],[30,26,30,28],[27,1,27,22],[27,23,27,25],[27,26,27,28],[27,29,27,31],[32,29,32,31],[33,1,33,3],[33,4,33,6],[33,7,33,9],[33,10,33,12],[33,13,33,15],[33,16,33,19],[33,20,33,22],[33,23,33,25],[33,26,33,28],[33,29,33,31],[32,1,32,3],[32,4,32,6],[32,7,32,9],[32,10,32,12],[32,13,32,15],[32,16,32,19],[32,20,32,22],[32,23,32,25],[32,26,32,28],[34,29,34,31],[37,1,37,3],[37,4,37,6],[37,7,37,9],[37,10,37,12],[37,13,37,15],[37,16,37,19],[37,20,37,22],[37,23,37,25],[37,26,37,28],[37,29,37,31],[34,1,34,3],[34,4,34,6],[34,7,34,9],[34,10,34,12],[34,13,34,15],[34,16,34,19],[34,20,34,22],[34,23,34,25],[34,26,34,28],[38,29,38,31],[39,1,39,3],[39,4,39,6],[39,7,39,9],[39,10,39,12],[39,13,39,15],[39,16,39,19],[39,20,39,22],[39,23,39,25],[39,26,39,28],[38,1,38,3],[38,4,38,6],[38,7,38,9],[38,10,38,12],[38,13,38,15],[38,16,38,19],[38,20,38,22],[38,23,38,25],[38,26,38,28],[40,29,40,31],[40,47,40,48],[41,36,41,38],[41,45,41,46],[45,31,45,34],[48,10,49,11],[48,23,49,24],[39,29,39,31],[40,1,40,3],[40,4,40,6],[40,7,40,9],[40,10,40,12],[40,13,40,15],[40,16,40,19],[40,20,40,22],[40,23,40,25],[40,26,40,28],[63,0,63,35],[64,0,64,35],[55,8,55,10],[55,11,55,13],[55,39,55,40],[56,39,56,40],[60,13,60,15],[62,0,62,35],[52,0,53,4],[52,7,52,14],[53,7,53,9],[53,30,53,35],[54,8,54,13],[54,39,54,40]]}
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSSIBILITÉ 1                                                  exemple rempli                                                            "]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:",null,null,null,null,null,null,null,"adg"]
[]
["Référence:",null,null,null,null,null,null,null,"Raam 030"]
[]
["pièce d' epreuve:",null,null,null,null,null,null,null,"note de calcul menuisier"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw =",null,null,1480,null,null,"mm",null,null,null,null,null,null,{"$f":"AA17/1000","v":1.48},null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw =",null,null,1230,null,null,"mm",null,null,null,null,null,null,{"$f":"AA18/1000","v":1.23},null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neen"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw =",null,null,1.41,null,null,"W/m²K"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Hauteur du fenêtre incluant l' aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,"Les dimensions et les valeurs U des différents profils de fenêtres et des panneaux vitrés sont connues : "]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisivent AIR Light",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur =",{"$f":"VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,2,FALSE)","v":2},null,"hr =",{"$f":"VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,3,FALSE)","v":6.5000000000000002E-2},null,"Ar =",null,{"$f":"AT26*AA18/1000000","v":7.9950000000000005E-5},"m²"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug =",null,null,1.1000000000000001,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique linéaire pour les jonctions entre les profilés et les vitrages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yg =",null,null,null,null,null,"W/mK",null,null,null,null,null,null,0.05,null,null,"W/mK",null,null,null,{"$f":"IF(AA28=0,AK28,AA28)","v":0.05},"W/mK",null,null,null,null,null,"Onbekend"]
[]
[null,"Profils raccourcis"]
[null,"x",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"Uf,x",null,null,"[W/m²K]"]
[null,"bf,x",null,null,"[mm]"]
[null,"bf,x",null,null,"[m]",null,null,{"$f":"H33/1000","v":0},null,null,{"$f":"K33/1000","v":0},null,null,{"$f":"N33/1000","v":0},null,null,{"$f":"Q33/1000","v":0},null,null,null,{"$f":"U33/1000","v":0},null,null,{"$f":"X33/1000","v":0},null,null,{"$f":"AA33/1000","v":0},null,null,{"$f":"AD33/1000","v":0}]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,{"$f":"$AT$26*H34*H32","v":0},null,null,{"$f":"$AT$26*K34*K32","v":0},null,null,{"$f":"$AT$26*N34*N32","v":0},null,null,{"$f":"$AT$26*Q34*Q32","v":0},null,null,null,{"$f":"$AT$26*U34*U32","v":0},null,null,{"$f":"$AT$26*X34*X32","v":0},null,null,{"$f":"$AT$26*AA34*AA32","v":0},null,null,{"$f":"$AT$26*AD34*AD32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H35:AF35)","v":0}]
[]
[null,"Déduction de vitrage:"]
[null,"y",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"bg,y",null,null,"[mm]"]
[null,"bg,y",null,null,"[m]",null,null,{"$f":"H39/1000","v":0},null,null,{"$f":"K39/1000","v":0},null,null,{"$f":"N39/1000","v":0},null,null,{"$f":"Q39/1000","v":0},null,null,null,{"$f":"U39/1000","v":0},null,null,{"$f":"X39/1000","v":0},null,null,{"$f":"AA39/1000","v":0},null,null,{"$f":"AD39/1000","v":0}]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,{"$f":"$AT$26*H40*$AA$27","v":0},null,null,{"$f":"$AT$26*K40*$AA$27","v":0},null,null,{"$f":"$AT$26*N40*$AA$27","v":0},null,null,{"$f":"$AT$26*Q40*$AA$27","v":0},null,null,null,{"$f":"$AT$26*U40*$AA$27","v":0},null,null,{"$f":"$AT$26*X40*$AA$27","v":0},null,null,{"$f":"$AT$26*AA40*$AA$27","v":0},null,null,{"$f":"$AT$26*AD40*$AA$27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H41:AF41)","v":0},null,null,null,"aantal glasplaten:",{"$f":"8-COUNTIF(H41:AF41,0)","v":0}]
[null,"Erreur: S bf,x + Sbg,y doit être égal à Bw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF((SUM(H33:W33)+SUM(H39:AJ39)-AA18)<0,\"=> trop court: \",\"=> trop long: \"),ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18),\" mm!\")","v":"=> trop court: 1230 mm!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H33:W33)+SUM(H39:AJ39)","v":0},null,null,"m",null,null,"verschil =",{"$f":"ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18)","v":1230}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur",{"$f":"IF(T26=0,\"= ? W/m²K\",CONCATENATE(\"= \",VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,2,FALSE),\" W/m²K\"))","v":"= 2 W/m²K"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr =",{"$f":"IF(T26=0,\"? mm\",VLOOKUP(T26,'Lijst verluchtingen'!B5:D174,3,FALSE)*1000)","v":65}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"bg,x",null,null,null,null,null,null,null,null,null,null,null,null,"bf,y"]
[]
[]
[]
[{"$f":"IF(AA17=0,\"? mm\",IF(AQ23=TRUE,AA17,AA17+AF46))","v":1545},null,null,null,null,null,null,"Ug,x ; Ag,x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uf,y ; Af,y",null,null,null,"hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AA17=0,T26=0),\"? mm\",A53-AF46)","v":1480},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/m²K"]
[null,null,null,null,null,null,null,null,"Uw,incl. Aérateur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Hoogte excl. verluchting",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0),\"?\",((AA19*AK17*AK18)+(AQ26*AK18*AT26))/((AK17*AK18)+(AK18*AT26)))","v":1.4348220064724917}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AQ23<>TRUE,AU55,IF(AQ24<>TRUE,AU56,AU57))","v":1.4348220064724917},null,null,"W/m²K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1",null,"Hoogte incl. verluchting (vereenv.)",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0,AA27=0),\"?\",((AA19*AK17*AK18)+(AQ26-MIN(AA19,AA27))*(AT26*AK18))/(AK17*AK18))","v":1.4495270270270268}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2",null,"Hoogte incl. verluchting (vereenv.)",null,null,null,null,{"$f":"IF(OR(AA19=0,AA17=0,AA18=0,T26=0,AA27=0,AR42<>0),\"?\",(AA19*AK17*AK18+AQ26*AK18*AT26-AQ35-AQ41-2*AV41*AT26*AR28)/(AK17*AK18))","v":"?"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA18=0,\"?\",AA18)","v":1230},null,null,"mm"]
[]
["(1)  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]
["(3) Simplification : comme valeur sûre, la surface de l’aérateur remplace une partie de la surface de la ‘fenêtre sans aérateur’ dont la valeur U = min (Ug et Uw)"]
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSSIBILITÉ 2                                                  exemple rempli                                                               "]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:",null,null,null,null,null,null,null,"adg"]
[]
["Référence:",null,null,null,null,null,null,null,"Raam 030"]
[]
["pièce d' epreuve:",null,null,null,null,null,null,null,"note de calcul menuisier"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw =",null,null,1480,null,null,"mm"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw =",null,null,1230,null,null,"mm"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw =",null,null,1.41,null,null,"W/m²K"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Hauteur du fenêtre incluant l' aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"Les dimensions et les valeurs U des différents profils de fenêtres et des panneaux vitrés sont connues : "]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisivent AIR Light"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug =",null,null,1.1000000000000001,null,null,"W/m²K"]
[]
[]
[null,"Profils raccourcis"]
[null,"x",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"Uf,x",null,null,"[W/m²K]"]
[null,"bf,x",null,null,"[mm]"]
[null,"bf,x",null,null,"[m]",null,null,{"$f":"H98/1000","v":0},null,null,{"$f":"K98/1000","v":0},null,null,{"$f":"N98/1000","v":0},null,null,{"$f":"Q98/1000","v":0},null,null,null,{"$f":"U98/1000","v":0},null,null,{"$f":"X98/1000","v":0},null,null,{"$f":"AA98/1000","v":0},null,null,{"$f":"AD98/1000","v":0}]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,{"$f":"$AT$26*H99*H97","v":0},null,null,{"$f":"$AT$26*K99*K97","v":0},null,null,{"$f":"$AT$26*N99*N97","v":0},null,null,{"$f":"$AT$26*Q99*Q97","v":0},null,null,null,{"$f":"$AT$26*U99*U97","v":0},null,null,{"$f":"$AT$26*X99*X97","v":0},null,null,{"$f":"$AT$26*AA99*AA97","v":0},null,null,{"$f":"$AT$26*AD99*AD97","v":0}]
[]
[null,"Déduction de vitrage:"]
[null,"y",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"bg,y",null,null,"[mm]"]
[null,"bg,y",null,null,"[m]",null,null,{"$f":"H104/1000","v":0},null,null,{"$f":"K104/1000","v":0},null,null,{"$f":"N104/1000","v":0},null,null,{"$f":"Q104/1000","v":0},null,null,null,{"$f":"U104/1000","v":0},null,null,{"$f":"X104/1000","v":0},null,null,{"$f":"AA104/1000","v":0},null,null,{"$f":"AD104/1000","v":0}]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,{"$f":"$AT$26*H105*$AA$27","v":0},null,null,{"$f":"$AT$26*K105*$AA$27","v":0},null,null,{"$f":"$AT$26*N105*$AA$27","v":0},null,null,{"$f":"$AT$26*Q105*$AA$27","v":0},null,null,null,{"$f":"$AT$26*U105*$AA$27","v":0},null,null,{"$f":"$AT$26*X105*$AA$27","v":0},null,null,{"$f":"$AT$26*AA105*$AA$27","v":0},null,null,{"$f":"$AT$26*AD105*$AA$27","v":0}]
[null,"Erreur: S bf,x + Sbg,y doit être égal à Bw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF((SUM(H98:W98)+SUM(H104:AJ104)-AA83)<0,\"=> trop court: \",\"=> trop long: \"),ABS(SUM(H98:W98)+SUM(H104:AJ104)-AA83),\" mm!\")","v":"=> trop court: 1230 mm!"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur","= 2 W/m²K"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr =",65]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"bg,x",null,null,null,null,null,null,null,null,null,null,null,null,"bf,y"]
[]
[]
[]
[{"$f":"IF(AA82=0,\"? mm\",IF(AQ88=TRUE,AA82,AA82+AF111))","v":1480},null,null,null,null,null,null,"Ug,x ; Ag,x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uf,y ; Af,y",null,null,null,"hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1415]
[null,null,null,null,null,null,null,null,"Uw,incl. Aérateur"]
[null,null,null,null,null,null,null,null,1.45,null,null,"W/m²K"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA83=0,\"?\",AA83)","v":1230},null,null,"mm"]
[]
["(1) Conforme  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]
["(3) Simplification : comme valeur sûre, la surface de l’aérateur remplace une partie de la surface de la ‘fenêtre sans aérateur’ dont la valeur U = min (Ug et Uw)"]
[]
[]
[]
[]
[]
["Calculer la valeur Uw de la fenêtre avec aérateur inclus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POSSIBILITÉ 3                                                 exemple rempli                                                               "]
["Selon la réglementation PEB belge, l’aérateur fait partie de la fenêtre dans laquelle ou sur laquelle il est monté.  Les aérateurs doivent donc être inclus dans le calcul de la valeur Uw de la fenêtre.  Les rapporteurs PEB reçoivent souvent des notes de calcul thermique de fenêtres dans lesquelles les aérateurs ne sont pas repris.  Cette feuille de calcul est une aide pour calculer ultérieurement et simplement les aérateurs dans les valeurs Uw de la fenêtre. "]
[]
["Adresse:",null,null,null,null,null,null,null,"adg"]
[]
["Référence:",null,null,null,null,null,null,null,"Raam 030"]
[]
["pièce d' epreuve:",null,null,null,null,null,null,null,"note de calcul menuisier"]
[]
["fenêtre sans aérateur:"]
[]
[null,"Hauteur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hw =",null,null,1480,null,null,"mm"]
[null,"Largeur de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bw =",null,null,1230,null,null,"mm"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uw =",null,null,1.41,null,null,"W/m²K"]
[]
["fenêtre avec aérateur:"]
[]
[null,"Hauteur du fenêtre incluant l' aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,"Les dimensions et les valeurs U des différents profils de fenêtres et des panneaux vitrés sont connues : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[]
[null,"Aérateur:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisivent AIR Light"]
[null,"Coefficient de transmission thermique de la fenêtre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ug =",null,null,1.1000000000000001,null,null,"W/m²K"]
[null,"Le coefficient de transmission thermique linéaire pour les jonctions entre les profilés et les vitrages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yg =",null,null,null,null,null,"W/mK"]
[]
[null,"Profils raccourcis"]
[null,"x",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"Uf,x",null,null,"[W/m²K]",null,null,1.47,null,null,1.47]
[null,"bf,x",null,null,"[mm]",null,null,150,null,null,150]
[null,"bf,x",null,null,"[m]",null,null,{"$f":"H163/1000","v":0.15},null,null,{"$f":"K163/1000","v":0.15},null,null,{"$f":"N163/1000","v":0},null,null,{"$f":"Q163/1000","v":0},null,null,null,{"$f":"U163/1000","v":0},null,null,{"$f":"X163/1000","v":0},null,null,{"$f":"AA163/1000","v":0},null,null,{"$f":"AD163/1000","v":0}]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,{"$f":"$AT$26*H164*H162","v":1.43325E-2},null,null,{"$f":"$AT$26*K164*K162","v":1.43325E-2},null,null,{"$f":"$AT$26*N164*N162","v":0},null,null,{"$f":"$AT$26*Q164*Q162","v":0},null,null,null,{"$f":"$AT$26*U164*U162","v":0},null,null,{"$f":"$AT$26*X164*X162","v":0},null,null,{"$f":"$AT$26*AA164*AA162","v":0},null,null,{"$f":"$AT$26*AD164*AD162","v":0}]
[]
[null,"Déduction de vitrage:"]
[null,"y",null,null,"[-]",null,null,1,null,null,2,null,null,3,null,null,4,null,null,null,5,null,null,6,null,null,7,null,null,8]
[null,"bg,y",null,null,"[mm]",null,null,930]
[null,"bg,y",null,null,"[m]",null,null,{"$f":"H169/1000","v":0.93},null,null,{"$f":"K169/1000","v":0},null,null,{"$f":"N169/1000","v":0},null,null,{"$f":"Q169/1000","v":0},null,null,null,{"$f":"U169/1000","v":0},null,null,{"$f":"X169/1000","v":0},null,null,{"$f":"AA169/1000","v":0},null,null,{"$f":"AD169/1000","v":0}]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,{"$f":"$AT$26*H170*$AA$27","v":6.6495000000000012E-2},null,null,{"$f":"$AT$26*K170*$AA$27","v":0},null,null,{"$f":"$AT$26*N170*$AA$27","v":0},null,null,{"$f":"$AT$26*Q170*$AA$27","v":0},null,null,null,{"$f":"$AT$26*U170*$AA$27","v":0},null,null,{"$f":"$AT$26*X170*$AA$27","v":0},null,null,{"$f":"$AT$26*AA170*$AA$27","v":0},null,null,{"$f":"$AT$26*AD170*$AA$27","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ur","= 2 W/m²K"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr =",65]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"bg,x",null,null,null,null,null,null,null,null,null,null,null,null,"bf,y"]
[]
[]
[]
[1480,null,null,null,null,null,null,"Ug,x ; Ag,x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uf,y ; Af,y",null,null,null,"hr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1415]
[null,null,null,null,null,null,null,null,"Uw,incl. Aérateur"]
[null,null,null,null,null,null,null,null,1.44,null,null,"W/m²K"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA148=0,\"?\",AA148)","v":1230},null,null,"mm"]
[]
["(1) Conforme  NBN EN ISO 10077-1;"]
["(2) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs."]

{"sheet":"Lijst verluchtingen","index":4,"n_rows":72,"n_cols":4,"rows_kept":72,"cut":false,"hidden":true,"merged":[[0,2,2,2],[0,3,2,3]]}
[null,null,"U-waarde","Oppervlakte"]
[]
[]
[null,null,"[W/m²K]","[m²/m]"]
[1,"Invisivent AIR Light",2,6.5000000000000002E-2]
[2,"Invisivent AIR Basic",1.8,6.5000000000000002E-2]
[3,"Invisivent AIR High",1.8,6.5000000000000002E-2]
[4,"Invisivent COMFORT Basic",1.8,6.5000000000000002E-2]
[5,"Invisivent COMFORT High",1.8,6.5000000000000002E-2]
[6,"Invisivent COMFORT Ultra",1.7,6.5000000000000002E-2]
[7,"Invisivent EVO",2.8,6.2E-2]
[8,"Invisivent EVO HF",2.8,6.2E-2]
[9,"Invisivent EVO AK Basic",2,6.2E-2]
[10,"Invisivent EVO AK High",2.2000000000000002,6.2E-2]
[11,"Invisivent EVO HR",2,6.2E-2]
[12,"Invisivent UT",1.8,6.5000000000000002E-2]
[13,"Fixvent Mono AK EVO Small",1.47,0.13200000000000001]
[14,"Fixvent Mono AK EVO Medium",0.98,0.13200000000000001]
[15,"Fixvent Mono AK EVO Large",0.86,0.13200000000000001]
[16,"Fixvent Mono AK EVO Xlarge",0.77,0.13200000000000001]
[17,"Fixvent Mono AK EVO XXlarge",0.72,0.13200000000000001]
[18,"Screenvent Small",4.4000000000000004,0.12]
[19,"Screenvent Medium",4.0999999999999996,0.12]
[20,"Screenvent Large",4,0.12]
[21,"Screenvent Mistral AK Small",4.4000000000000004,0.12]
[22,"Screenvent Mistral AK Medium",4.0999999999999996,0.12]
[23,"Screenvent Mistral AK Large",4,0.12]
[]
[]
[]
[]
[]
[]
[]
[]
[24,"AR75 Small",3,7.4999999999999997E-2]
[25,"AR75 Medium",3,7.4999999999999997E-2]
[26,"AR75 Large",3,7.4999999999999997E-2]
[27,"AR75 XLarge",3,7.4999999999999997E-2]
[28,"AR90",3.91,0.09]
[29,"AR60",4.5,0.06]
[30,"THM90EVO",3.79,0.09]
[31,"THM90PBEVO",3.79,0.09]
[32,"THM90TREVO",3.79,0.09]
[33,"THK60",4.5,0.06]
[34,"THK90",3.91,0.09]
[35,"Sonovent Small  10",4.5,0.105]
[36,"Sonovent Small  15",4.5,0.105]
[37,"Sonovent Small  20",4.5,0.105]
[38,"Sonovent Small  25",4.5,0.105]
[39,"Sonovent Medium 10",4.5,0.105]
[40,"Sonovent Medium 15",4.5,0.105]
[41,"Sonovent Medium 20",4.5,0.105]
[42,"Sonovent Medium 25",4.5,0.105]
[43,"Sonovent Large 10",4.5,0.105]
[44,"Sonovent Large 15",4.5,0.105]
[45,"Sonovent Large 20",4.5,0.105]
[46,"Sonovent Large 25",4.5,0.105]
[47,"Sonovent XLarge 10",4.5,0.105]
[48,"Sonovent XLarge 15",4.5,0.105]
[49,"Sonovent XLarge 20",4.5,0.105]
[50,"Sonovent XLarge 25",4.5,0.105]
[51,"Sonovent Compact 10 ",6,7.8E-2]
[52,"Sonovent Compact 13 ",6,7.8E-2]
[53,"Sonovent Compact 15",6,7.8E-2]
[54,"Sonovent Compact 15",6,7.8E-2]
[55]
[56]
[57]
[58]
[59]
[60]

{"sheet":"Taal","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},"Nederlands","Français","English"]
[2,{"$f":"HLOOKUP(B$1,$C$1:$G$31,A2,FALSE)","v":{"$error":"#REF!"}},"Uw-waarde raam berekenen inclusief verluchting","Calculer la valeur Uw du châssis avec aérateur inclus","Calculation of the Uw-value of a window, including window ventilator"]
[3,{"$f":"HLOOKUP(B$1,$C$1:$G$31,A3,FALSE)","v":{"$error":"#REF!"}},"Referentie:","Référence :","Reference:"]
[4,{"$error":"#REF!"},"Raamverluchtingen dienen in de globale Uw-waarde van het raam meegerekend te worden. Soms gebeurt het dat de schrijnwerker bij de berekening van Uw geen rekening houdt met de impact van het rooster omdat de gebruikte software dit niet ondersteunt. Dit rekenblad is dan ook een hulp om de invloed van de verluchting op de globale Uw-waarde van het raam in rekening te brengen. Gezien elk raam anders is en Renson geen kennis heeft  van de eigenschappen van de beschouwde ramen, werden er een aantal vereenvoudigingen in de berekening doorgevoerd waardoor het resultaat mogelijk iets kan afwijken van de gedetailleerde berekening.","Les aérateurs doivent être calculés dans la valeur Uw globale du châssis. Parfois il arrive que le menuisier lors du calcul de la valeur Uw ne tient pas compte de l'impact de l'aérateur parce que le logiciel utilisé ne le prévoit pas. Cette feuille de calcul est une aide pour prendre en compte l'influence de l'aérateur sur la valeur Uw globale du châssis. Etant donné que chaque châssis est différent et que Renson ne connaît pas les caractéristiques des châssis pris en compte, on a effectué des simplifications dans le calcul ce qui peut faire différer le résultat légèrement du calcul détaillé. ","Window ventilators should be taken into account in the calculation of the total Uw-value of a window. It might happen that the window constructor doesn’t take into account the impact of the window ventilator when calculating the Uw-value, because he doesn’t dispose of the suitable software. Therefore, this calculation sheet is a tool to help you calculate the influence of the window ventilator on the global Uw-value of the window. Since every window is different and RENSON has no knowledge of the windows concerned, a few simplifications have been implemented in this calculation, which may cause a slight deviation in the result compared to a detailed calculation."]
[5,{"$error":"#REF!"},"Ontvangen gegevens van de schrijnwerker:","Données reçues du menuisier :","Received details from the window constructor:"]
[6,{"$error":"#REF!"},"Raambreedte =","Largeur châssis =","Total width of the window ="]
[7,{"$error":"#REF!"},"Raamhoogte =","Hauteur châssis  =","Total height of the window ="]
[8,{"$error":"#REF!"},"Uw-waarde van het raam exclusief de raamverluchting:","Valeur  Uw du châssis sans aérateur :","Uw-value of the window EXCL. the window ventilator ="]
[9,{"$error":"#REF!"},"Toegepaste raamverluchting:","Aérateur utilisé :","Applied window ventilator:"]
[10,{"$error":"#REF!"},"Ur =","Ua =","Uv ="]
[11,{"$error":"#REF!"},"Hoogte rooster =","Hauteur aérateur =","Height of the window ventilator ="]
[12,{"$error":"#REF!"},"Lengte rooster (lr) =","Longueur aérateur (lr) =","Length of the window ventilator (lv) ="]
[13,{"$error":"#REF!"},"Gegeven Ug-waarde van het glas:","Valeur Ug donnée du vitrage :","Given Ug-value off the glass:"]
[14,{"$error":"#REF!"},"Uw-waarde raam inclusief de verluchting:","Valeur Uw du châssis, aérateur inclus :","Uw-value of the window INCL. window ventilator:"]
[15,{"$error":"#REF!"},"Raambreedte = ","Largeur châssis = ","Total width of the window = "]
[16,{"$error":"#REF!"},"(1) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen.","(1) L'outil concerné est purement informatif. Renson ne peut pas être tenu responsable d'erreurs éventuelles dans les calculs.","1)This tool is only informative. RENSON can not be held responsible for possible errors in the calculations."]
[17,{"$error":"#REF!"},"lr","la","lv"]
[18,{"$error":"#REF!"}]
[19,{"$error":"#REF!"}]
[20,{"$error":"#REF!"}]
[21,{"$error":"#REF!"}]
[22,{"$error":"#REF!"}]
[23,{"$error":"#REF!"}]
[24,{"$error":"#REF!"}]
[25,{"$error":"#REF!"}]
[26,{"$error":"#REF!"}]
[27,{"$error":"#REF!"}]
[28,{"$error":"#REF!"}]
[29,{"$error":"#REF!"}]
[30,{"$error":"#REF!"}]