{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Verluchting op glas","Verluchting op raam","Verluchting op glas (vb)","Verluchting op raam (vb)","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":"Verluchting op glas","index":0,"n_rows":54,"n_cols":45,"rows_kept":54,"cut":false,"hidden":false,"merged":[[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],[32,39,32,41],[32,36,32,38],[31,39,31,41],[31,36,31,38],[49,14,49,16],[52,0,52,33],[53,0,53,33],[39,18,39,24],[40,1,40,5],[40,9,40,14],[40,28,40,30],[41,9,41,11],[41,12,41,14],[40,18,40,24],[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],[30,1,30,19],[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],[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],[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],[17,39,17,41],[17,36,17,38],[16,39,16,41],[16,36,16,38],[32,20,32,22],[32,23,32,25],[32,26,32,28],[30,26,30,28],[30,20,30,22],[30,23,30,25],[24,39,24,41]]}
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting"]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:"]
[]
["Referentie raam:"]
[]
["Stavingstuk:"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,"Breedte raam:",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,"Warmtedoorgangscoëfficient raam:",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,"Warmtedoorgangscoëfficient glas:",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,"Lineaire doorgangscoëfficiënt raamprofiel - glas:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Verluchting:",null,null,null,null,null,null,null,null,null,null,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,"Roosterlengte 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,"Roosterlengte 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,"Roosterlengte 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,0,{"$f":"X30/1000","v":0},null,null,"m"]
[null,"Roosterlengte 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,"Roosterlengte 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,"Roosterlengte 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,{"$f":"X33/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":"= ? 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. Verluchting",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) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen. "]

{"sheet":"Verluchting op raam","index":1,"n_rows":65,"n_cols":55,"rows_kept":65,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting"]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:"]
[]
["Referentie raam:"]
[]
["Stavingstuk:"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,"Breedte raam:",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,"Warmtedoorgangscoëfficient raam:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Hoogte raam inclusief verluchting:"]
[null,"Afmetingen en U-waarden individuele profielen en glasplaten zijn gekend:"]
[]
[null,"Type verluchting:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Warmtedoorgangscoëfficient glas:",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,"Lineaire doorgangscoëfficiënt raamprofiel - glas:",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,"Ingekorte profielen"]
[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,"Aftrek glas:"]
[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,"Fout: S bf,x + Sbg,y moet gelijk zijn aan Bw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF((SUM(H33:W33)+SUM(H39:AJ39)-AA18)<0,\"=> tekort: \",\"=> teveel: \"),ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18),\" mm!\")","v":"=> teveel: 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. Verluchting",null,null,null,null,null,null,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) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen;"]
["(3) Vereenvoudiging: Als veilige waarde, vervangt het oppervlak van de verluchting, een deeloppervlak van het ‘raam zonder verluchting’ waarvan de U-waarde = min (Ug en Uw)."]

{"sheet":"Verluchting op glas (vb)","index":2,"n_rows":52,"n_cols":45,"rows_kept":52,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[5,0,5,33],[6,0,6,33],[8,8,8,33],[10,8,10,33],[12,8,12,33]]}
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting"]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:",null,null,null,null,null,null,null,"adg"]
[]
["Referentie raam:",null,null,null,null,null,null,null,"Raam 030"]
[]
["Stavingstuk:",null,null,null,null,null,null,null,"Rekennota schrijnwerker"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,"Breedte raam:",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,"Warmtedoorgangscoëfficient raam:",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,"Warmtedoorgangscoëfficient glas:",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,"Lineaire doorgangscoëfficiënt raamprofiel - glas:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Verluchting:",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,"Roosterlengte 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,"Roosterlengte 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,"Roosterlengte 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,0,{"$f":"X30/1000","v":0},null,null,"m"]
[null,"Roosterlengte 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,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":"= 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. Verluchting",null,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) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen. "]

{"sheet":"Verluchting op raam (vb)","index":3,"n_rows":197,"n_cols":64,"rows_kept":197,"cut":false,"hidden":false,"merged":[[197,0,198,35],[187,8,187,13],[187,39,187,40],[188,8,188,10],[188,11,188,13],[188,39,188,40],[189,39,189,40],[193,13,193,15],[195,0,195,35],[196,0,196,35],[173,47,173,48],[174,36,174,38],[174,45,174,46],[178,31,178,34],[181,10,182,11],[181,23,182,24],[185,0,186,4],[185,7,185,14],[186,7,186,9],[186,30,186,35],[172,29,172,31],[173,1,173,3],[173,4,173,6],[173,7,173,9],[173,10,173,12],[173,13,173,15],[173,16,173,19],[173,20,173,22],[173,23,173,25],[173,26,173,28],[173,29,173,31],[172,1,172,3],[172,4,172,6],[172,7,172,9],[172,10,172,12],[172,13,172,15],[172,16,172,19],[172,20,172,22],[172,23,172,25],[172,26,172,28],[170,29,170,31],[171,1,171,3],[171,4,171,6],[171,7,171,9],[171,10,171,12],[171,13,171,15],[171,16,171,19],[171,20,171,22],[171,23,171,25],[171,26,171,28],[171,29,171,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],[166,29,166,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],[167,29,167,31],[166,1,166,3],[166,4,166,6],[166,7,166,9],[166,10,166,12],[166,13,166,15],[166,16,166,19],[166,20,166,22],[166,23,166,25],[166,26,166,28],[164,29,164,31],[165,1,165,3],[165,4,165,6],[165,7,165,9],[165,10,165,12],[165,13,165,15],[165,16,165,19],[165,20,165,22],[165,23,165,25],[165,26,165,28],[165,29,165,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],[160,1,160,22],[160,23,160,25],[160,26,160,28],[160,29,160,31],[160,36,160,38],[160,39,160,41],[160,44,160,46],[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],[163,29,163,31],[155,29,155,31],[156,29,156,31],[158,1,158,18],[158,19,158,31],[158,45,158,46],[159,1,159,22],[159,23,159,25],[159,26,159,28],[159,29,159,31],[150,1,150,22],[150,23,150,25],[150,26,150,28],[150,29,150,31],[150,36,150,38],[151,1,151,22],[151,23,151,25],[151,26,151,28],[151,29,151,31],[130,0,131,35],[138,0,138,32],[138,62,143,88],[139,0,139,35],[141,8,141,35],[143,8,143,35],[145,8,145,35],[149,1,149,22],[149,23,149,25],[149,26,149,28],[149,29,149,31],[149,36,149,38],[120,8,120,13],[120,39,120,40],[121,8,121,10],[121,11,121,13],[121,39,121,40],[122,39,122,40],[126,13,126,15],[128,0,128,35],[129,0,129,35],[106,47,106,48],[107,36,107,38],[107,45,107,46],[111,31,111,34],[114,10,115,11],[114,23,115,24],[118,0,119,4],[118,7,118,14],[119,7,119,9],[119,30,119,35],[105,29,105,31],[106,1,106,3],[106,4,106,6],[106,7,106,9],[106,10,106,12],[106,13,106,15],[106,16,106,19],[106,20,106,22],[106,23,106,25],[106,26,106,28],[106,29,106,31],[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],[100,1,100,3],[100,4,100,6],[100,7,100,9],[100,10,100,12],[100,13,100,15],[100,16,100,19],[100,20,100,22],[100,23,100,25],[100,26,100,28],[100,29,100,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],[93,39,93,41],[93,44,93,46],[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],[92,1,92,22],[92,23,92,25],[92,26,92,28],[92,29,92,31],[93,1,93,22],[93,23,93,25],[93,26,93,28],[93,29,93,31],[93,36,93,38],[84,1,84,22],[84,23,84,25],[84,26,84,28],[84,29,84,31],[88,29,88,31],[89,29,89,31],[91,1,91,18],[91,19,91,31],[91,45,91,46],[82,1,82,22],[82,23,82,25],[82,26,82,28],[82,29,82,31],[82,36,82,38],[83,1,83,22],[83,23,83,25],[83,26,83,28],[83,29,83,31],[83,36,83,38],[5,63,10,89],[71,0,71,32],[71,63,76,89],[72,0,72,35],[74,8,74,35],[76,8,76,35],[78,8,78,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],[5,0,5,32],[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],[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],[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],[31,29,31,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],[32,29,32,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],[33,29,33,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],[34,29,34,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],[39,23,39,25],[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],[38,26,38,28],[38,29,38,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],[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],[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],[62,0,62,35],[63,0,63,35],[64,0,65,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]]}
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOGELIJKHEID 1                                                  Ingevuld voorbeeld                                                              "]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:",null,null,null,null,null,null,null,"Maalbeekstraat 10 - 8790 Waregem"]
[]
["Referentie raam:",null,null,null,null,null,null,null,"Raam 030"]
[]
["Stavingstuk:",null,null,null,null,null,null,null,"rekennota schrijnwerker"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,"Breedte raam:",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,"Warmtedoorgangscoëfficient raam:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Hoogte raam inclusief verluchting:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Afmetingen en U-waarden individuele profielen en glasplaten zijn gekend:"]
[]
[null,"Type verluchting:",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":{"$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,"Warmtedoorgangscoëfficient glas:",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,"Lineaire doorgangscoëfficiënt raamprofiel - glas:",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(AQ28=TRUE,AK28,AA28)","v":0},"W/mK",null,null,null,null,null,"Onbekend"]
[]
[null,"Ingekorte profielen"]
[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.85,null,null,1.85]
[null,"bf,x",null,null,"[mm]",null,null,150,null,null,150]
[null,"bf,x",null,null,"[m]",null,null,{"$f":"H33/1000","v":0.15},null,null,{"$f":"K33/1000","v":0.15},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,"Aftrek glas:"]
[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":"H39/1000","v":0.93},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,"Fout: S bf,x + Sbg,y moet gelijk zijn aan Bw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF((SUM(H33:W33)+SUM(H39:AJ39)-AA18)<0,\"=> tekort: \",\"=> teveel: \"),ABS(SUM(H33:W33)+SUM(H39:AJ39)-AA18),\" mm!\")","v":"=> teveel: 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":1230},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":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,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":{"$error":"#N/A"}}]
[]
[]
[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":{"$error":"#N/A"}},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":{"$error":"#N/A"}},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. Verluchting",null,null,null,null,null,null,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":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AQ23<>TRUE,AU55,IF(AQ24<>TRUE,AU56,AU57))","v":{"$error":"#N/A"}},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":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AA18=0,\"?\",AA18)","v":1230},null,null,"mm"]
[]
["(1) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen. "]
[]
[]
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOGELIJKHEID 2                                                  Ingevuld voorbeeld                                                              "]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:",null,null,null,null,null,null,null,"Maalbeekstraat 10 - 8790 Waregem"]
[]
["Referentie raam:",null,null,null,null,null,null,null,"Raam 030"]
[]
["Stavingstuk:",null,null,null,null,null,null,null,"rekennota schrijnwerker"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,1.48,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[null,"Breedte raam:",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,1.23,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neen"]
[null,"Warmtedoorgangscoëfficient raam:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Hoogte raam inclusief verluchting:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Afmetingen en U-waarden individuele profielen en glasplaten zijn gekend:"]
[]
[null,"Type verluchting:",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 =",2,null,"hr =",6.5000000000000002E-2,null,"Ar =",null,7.9950000000000005E-5,"m²"]
[null,"Warmtedoorgangscoëfficient glas:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,"W/mK",null,null,null,0,"W/mK",null,null,null,null,null,"Onbekend"]
[]
[null,"Ingekorte profielen"]
[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.85,null,null,1.85]
[null,"bf,x",null,null,"[mm]",null,null,150,null,null,150]
[null,"bf,x",null,null,"[m]",null,null,0.15,null,null,0.15,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,1.8037500000000001E-2,null,null,1.8037500000000001E-2,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,3.6075000000000003E-2]
[]
[null,"Aftrek glas:"]
[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,0.93,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,6.6495000000000012E-2,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,6.6495000000000012E-2,null,null,null,"aantal glasplaten:",1]
[null,"Fout: S bf,x + Sbg,y moet gelijk zijn aan Bw",null,null,null,null,null,null,null,null,null,null,null,"=> teveel: 0 mm!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1230,null,null,"m",null,null,"verschil =",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,null,null,null,null,null,null,null,"W/m²K"]
[null,null,null,null,null,null,null,null,"Uw,incl. Verluchting",null,null,null,null,null,null,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,1.4348220064724917]
[null,null,null,null,null,null,null,null,1.4495270270270268,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,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,1.4414930784442976]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1230,null,null,"mm"]
[]
["(1) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen. "]
["(3) Vereenvoudiging: Als veilige waarde, vervangt het oppervlak van de verluchting, een deeloppervlak van het ‘raam zonder verluchting’ waarvan de U-waarde = min (Ug en Uw)."]
[]
[]
[]
[]
[]
[]
[]
["Berekening U-waarde raam inclusief verluchting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOGELIJKHEID 3                                                  Ingevuld voorbeeld                                                              "]
["Volgens de Belgische EPB-regelgeving maken verluchtingen deel uit van het raam waarin of waarop ze gemonteerd worden. De raamverluchtingen moeten dus ook ingerekend worden in de Uw-waarde van het raam. Vaak ontvangen EPB-verslaggevers thermische rekennota's van ramen waar de raamverluchtingen niet zijn opgenomen. Dit rekenblad is een hulp om achteraf, eenvoudig de raamverluchtingen in de Uw-waarden van het raam in te rekenen. "]
[]
["Adres wooneenheid:",null,null,null,null,null,null,null,"Maalbeekstraat 10 - 8790 Waregem"]
[]
["Referentie raam:",null,null,null,null,null,null,null,"Raam 030"]
[]
["Stavingstuk:",null,null,null,null,null,null,null,"rekennota schrijnwerker"]
[]
["Raam zonder verluchting:"]
[]
[null,"Hoogte raam:",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,1.48,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ja"]
[null,"Breedte raam:",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,1.23,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neen"]
[null,"Warmtedoorgangscoëfficient raam:",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"]
[]
["Raam met verluchting:"]
[]
[null,"Hoogte raam inclusief verluchting:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Afmetingen en U-waarden individuele profielen en glasplaten zijn gekend:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Type verluchting:",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 =",2,null,"hr =",6.5000000000000002E-2,null,"Ar =",null,7.9950000000000005E-5,"m²"]
[null,"Warmtedoorgangscoëfficient glas:",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,"Lineaire doorgangscoëfficiënt raamprofiel - glas:",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,0.05,"W/mK",null,null,null,null,null,"Onbekend"]
[]
[null,"Ingekorte profielen"]
[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,0.15,null,null,0.15,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Uf,y x Af,y",null,null,"[W/K]",null,null,1.43325E-2,null,null,1.43325E-2,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,2.8665E-2]
[]
[null,"Aftrek glas:"]
[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,0.93,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Ug,y x Ag,y",null,null,"[W/mmK]",null,null,6.6495000000000012E-2,null,null,0,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,6.6495000000000012E-2,null,null,null,"aantal glasplaten:",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1230,null,null,"m",null,null,"verschil =",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,null,null,null,null,null,null,null,"W/m²K"]
[null,null,null,null,null,null,null,null,"Uw,incl. Verluchting",null,null,null,null,null,null,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,1.4348220064724917]
[null,null,null,null,null,null,null,null,1.4419929685783339,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,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,1.4419929685783339]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1230,null,null,"mm"]
[]
["(1) De berekeningen zijn uitgevoerd conform NBN B62-002;"]
["(2) De betreffende tool is louter informatief. Renson kan dan ook niet aansprakelijk worden gesteld voor eventuele onjuistheden in de berekeningen. "]

{"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 (HR) Light",2,6.5000000000000002E-2]
[2,"Invisivent AIR (HR) Basic",1.8,6.5000000000000002E-2]
[3,"Invisivent AIR (HR) High",1.8,6.5000000000000002E-2]
[4,"Invisivent COMFORT (HR) Basic",1.8,6.5000000000000002E-2]
[5,"Invisivent COMFORT (HR) High",1.8,6.5000000000000002E-2]
[6,"Invisivent COMFORT (HR) 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,"Fixvent Mono AK EVO Small",1.47,0.13200000000000001]
[13,"Fixvent Mono AK EVO Medium",0.98,0.13200000000000001]
[14,"Fixvent Mono AK EVO Large",0.86,0.13200000000000001]
[15,"Fixvent Mono AK EVO Xlarge",0.77,0.13200000000000001]
[16,"Fixvent Mono AK EVO XXlarge",0.72,0.13200000000000001]
[17,"Screenvent Small",4.4000000000000004,0.12]
[18,"Screenvent Medium",4.0999999999999996,0.12]
[19,"Screenvent Large",4,0.12]
[20,"Screenvent Mistral AK Small",4.4000000000000004,0.12]
[21,"Screenvent Mistral AK Medium",4.0999999999999996,0.12]
[22,"Screenvent Mistral AK Large",4,0.12]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[23,"AR75 Small",3,7.4999999999999997E-2]
[24,"AR75 Medium",3,7.4999999999999997E-2]
[25,"AR75 Large",3,7.4999999999999997E-2]
[26,"AR75 XLarge",3,7.4999999999999997E-2]
[27,"AR90",3.91,0.09]
[28,"AR60",4.5,0.06]
[29,"THM90EVO",3.79,0.09]
[30,"THM90PBEVO",3.79,0.09]
[31,"THM90TREVO",3.79,0.09]
[32,"THK60",4.5,0.06]
[33,"THK90",3.91,0.09]
[34,"Sonovent Small  10",4.5,0.105]
[35,"Sonovent Small  15",4.5,0.105]
[36,"Sonovent Small  20",4.5,0.105]
[37,"Sonovent Small  25",4.5,0.105]
[38,"Sonovent Medium 10",4.5,0.105]
[39,"Sonovent Medium 15",4.5,0.105]
[40,"Sonovent Medium 20",4.5,0.105]
[41,"Sonovent Medium 25",4.5,0.105]
[42,"Sonovent Large 10",4.5,0.105]
[43,"Sonovent Large 15",4.5,0.105]
[44,"Sonovent Large 20",4.5,0.105]
[45,"Sonovent Large 25",4.5,0.105]
[46,"Sonovent XLarge 10",4.5,0.105]
[47,"Sonovent XLarge 15",4.5,0.105]
[48,"Sonovent XLarge 20",4.5,0.105]
[49,"Sonovent XLarge 25",4.5,0.105]
[50,"Sonovent Compact 10 ",6,7.8E-2]
[51,"Sonovent Compact 13 ",6,7.8E-2]
[52,"Sonovent Compact 15",6,7.8E-2]
[53,null,4.5,0.105]
[54,null,4.5,0.105]
[55,null,4.5,0.105]
[56,null,4.5,0.105]
[57,null,4.5,0.105]
[58,null,4.5,0.105]

{"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!"}]