{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tool NL - FR","Tekst NL","Tekst FR","Referenties - Références","Installatie - Installation"],"not_rendered":{"charts":0,"images":33,"macros":1,"external_links":0,"defined_names":11,"comments":2,"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":"Tool NL - FR","index":0,"n_rows":126,"n_cols":49,"rows_kept":126,"cut":false,"hidden":false,"merged":[[2,20,3,29],[104,1,106,5],[2,8,2,9],[10,4,10,7],[11,4,11,7],[12,4,12,7],[63,3,63,5],[76,3,76,5],[100,3,100,5],[94,2,94,5],[73,7,75,12]]}
[]
[null,null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E2,'Tekst FR'!E2)","v":"In te vullen velden"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F2,'Tekst FR'!F2)","v":"   Volgens BE wetgeving (residentieel)"},null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!I2,'Tekst FR'!I2)","v":"Versie:"},"2022-05-16"]
[null,null,null,null,null,null,null,null,"Nederlands",null,null,null,null,null,"Nederlands",null,null,null,null,null,"WIJZIGINGEN? "]
[null,null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E4,'Tekst FR'!E4)","v":"Laatste versie file & tutorial: "},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F4,'Tekst FR'!F4)","v":"https://www.renson.eu/nl-be/voor-professionals/easyflex-tool"},null,null,null,null,null,null,null,null,"Français"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berekening in deze tab. Taal: in tab NL en FR (verwijzing)"]
[]
[]
[]
[null,"Ingave velden"]
[null,null,null,"( x )",null,null,null,null,null,null,"x"]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C11,'Tekst FR'!C11)","v":"Keuze unit / reductiefactor (EPB)"},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E11,'Tekst FR'!E11)","v":"Healthbox 3.0 (RF 0,9)"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F11,'Tekst FR'!F11)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!G11,'Tekst FR'!G11)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H11,'Tekst FR'!H11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zet een \"x\" bij de keuze van de unit"]
[null,null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E12,'Tekst FR'!E12)","v":"Healthbox 3.0 Smartzone (RF 0,61)"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F12,'Tekst FR'!F12)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!G12,'Tekst FR'!G12)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H12,'Tekst FR'!H12)","v":0}]
[null,null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E13,'Tekst FR'!E13)","v":"Healthbox 3.0 Smartzone (RF 0,5 / 0,43)"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F13,'Tekst FR'!F13)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!G13,'Tekst FR'!G13)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H13,'Tekst FR'!H13)","v":0}]
[]
[]
[]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C17,'Tekst FR'!C17)","v":"Afvoer"}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B18,'Tekst FR'!B18)","v":"Aantal"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C18,'Tekst FR'!C18)","v":"Ruimte(s) waar ventilatie moet voorzien worden:"},null,null,null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!I18,'Tekst FR'!I18)","v":"Debiet m³/h (per ruimte)"},null,null,null,null,null,null,null,null,null,null,null,"ROOSTERBASISSEN",null,null,null,null,null,null,null,null,null,"aantal ventielen","Tellers",null,null,null,null,null,null,null,"Regels"]
[null,null,null,null,null,null,null,null,"m³/h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teller ruimtes",null,null,null,null,null,null,null,"toilet diam 80 , alle andere ruimtes diam 125",null,null,null,null,null,null,null,null,"1. Aanduiding type ruimte met \"x\" "]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C20,'Tekst FR'!C20)","v":"Toilet"},null,null,null,null,null,{"$f":"IF(B20=\"\",0,J20)","v":0},25,25,null,null,null,{"$f":"B20*I20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF20","v":0},{"$f":"IF(B20=\"x\",1,0)","v":0},null,null,null,null,null,{"$f":"IF(B25>4,\"1\",\"0\")","v":"0"}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C21,'Tekst FR'!C21)","v":"Keuken"},null,null,null,null,null,{"$f":"IF(B21=\"\",0,J21)","v":0},75,76,null,null,null,{"$f":"B21*I21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF21","v":0},{"$f":"IF(B21=\"x\",1,0)","v":0},null,null,"toiletten",{"$f":"B20","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C22,'Tekst FR'!C22)","v":"Wasplaats"},null,null,null,null,null,0,50,51,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF22","v":0},0,null,null,"keuken",{"$f":"B21","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C23,'Tekst FR'!C23)","v":"Badkamer zonder toilet"},null,null,null,null,null,0,50,51,null,null,null,{"$f":"B23*I23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"wasplaats / BK z toilet",{"$f":"B22+B23","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C24,'Tekst FR'!C24)","v":"Badkamer met toilet"},null,null,null,null,null,0,50,51,null,null,null,{"$f":"B24*I24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"Badkamer met toilet",{"$f":"B24","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C25,'Tekst FR'!C25)","v":"Slaapkamer"},null,null,null,null,null,0,30,31,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C26,'Tekst FR'!C26)","v":"Andere droge ruimtes (bv. bureau)"},null,null,null,null,null,{"$f":"IF(B26=\"\",0,J26)","v":0},30,41,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"slaapkamers",{"$f":"B25+B26","v":0}]
[null,null,null,null,null,null,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,0]
[null,{"$f":"SUM(B20:B26)","v":0},null,null,null,null,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,0]
[null,null,null,null,null,null,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,0]
[null,null,null,null,null,null,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,0]
[null,null,null,null,null,null,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,0,null,null,"accoudec diam 82",null,{"$f":"AJ21","v":0}]
[null,null,null,null,null,null,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,0,null,null,"accoudec diam127",null,{"$f":"SUM(AJ22:AJ26)","v":0}]
[null,null,null,null,null,null,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,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enkel natte ruimtes met \"x\" aanvinken als RF = 0,90"]
[null,null,null,null,null,null,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,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slaapkamer(s) met \"x\" aanvinken als RF = 0,61"]
[null,null,null,null,null,null,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,0,null,null,"Kitsamenstelling",null,null,null,"keuken","bk met toilet","toilet","bkzt/wasplaats","slk",null,"Correctiefactoren",null,null,null,"Slaapkamer(s) met \"x\" aanvinken als RF = 0,50"]
[null,null,null,null,null,null,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,0,null,null,0.9,{"$f":"IF(D11=\"x\",1,0)","v":0},null,null,{"$f":"1*$AJ$36","v":0},{"$f":"1*$AJ$36","v":0},0,0,0,null,null,null,null,null,"Alle droge ruimtes met \"x\" aanvinken als RF = 0,43"]
[null,null,null,null,null,null,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,0,null,null,0.61,{"$f":"IF(D12=\"x\",1,0)","v":0},null,null,{"$f":"1*$AJ$37","v":0},{"$f":"1*$AJ$37","v":0},0,0,{"$f":"2*$AJ$37","v":0}]
[null,null,null,null,null,null,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,0,null,null,"0,43/0,5",{"$f":"IF(D13=\"x\",1,0)","v":0},{"$f":"SUM(AJ37:AJ38)","v":0},null,{"$f":"1*$AJ$38","v":0},{"$f":"1*$AJ$38","v":0},0,0,{"$f":"2*$AJ$38","v":0}]
[null,null,null,null,null,null,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":"AF39","v":0},0,null,null,null,null,null,"TUSSENTELLER KIT",{"$f":"SUM(AM36:AM38)","v":0},{"$f":"SUM(AN36:AN38)","v":0},0,0,{"$f":"SUM(AQ36:AQ38)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"x\",IF(G40=0,0,IF(G40<J40,J40,IF(G40>K40,K40,G40))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extra kleppen",null,null,"NODIG",{"$f":"AJ22","v":0},{"$f":"AJ24","v":0},{"$f":"AJ21","v":0},{"$f":"AJ23","v":0},{"$f":"AJ26","v":0},{"$f":"+SUM(AM40:AQ40)","v":0}]
[null,{"$f":"B20+B21+B22+B23+B24+B25+B26","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C41,'Tekst FR'!C41)","v":"TOTAAL"},null,null,null,null,null,{"$f":"SUM(O20:O26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAAL",{"$f":"AM40-AM39","v":0},{"$f":"AN40-AN39","v":0},{"$f":"AO40-AO39","v":0},0,0,null,{"$f":"IF(AN40=0,1,0)","v":1}]
[null,{"$f":"IF(B41>11,IF($I$3=\"Nederlands\",'Tekst NL'!B42,'Tekst FR'!B42),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I41>450,IF($I$3=\"Nederlands\",'Tekst NL'!I42,'Tekst FR'!I42),\"\")","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,"EXTRA BUITEN KIT",{"$f":"IF(AM41>0,AM41,\"0\")","v":"0"},{"$f":"IF(AN41>0,AN41,\"0\")","v":"0"},{"$f":"IF(AO41>0,AO41,\"0\")","v":"0"},{"$f":"IF(AP41>0,AP41,\"0\")-AS41","v":-1},{"$f":"IF(AQ41>0,AQ41,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AP42<0,\"0\",AP42)","v":"0"},null,null,{"$f":"IF(AJ37=1,0,1)","v":1}]
[null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!D44,'Tekst FR'!D44)","v":"UNIT"},{"$f":"IF(D11=\"x\",E11,IF(D12=\"x\",E12,IF(D13=\"x\",E13,IF($I$3=\"Nederlands\",'Tekst NL'!E44,'Tekst FR'!E44))))","v":"Kies ventilatiesysteem"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø125","EXTRA ROOSTERBASIS 0,9",{"$f":"IF(AJ36=1,AK32-4,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø125","EXTRA ROOSTERBASIS 0,61/0,5/0,43",{"$f":"IF(AK38=1,AK32-6,\"0\")","v":"0"},{"$f":"SUM(AM45+AM44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø80","EXTRA ROOSTERBASIS 0,9",{"$f":"IF(AJ36=1,AK31-1,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø80","EXTRA ROOSTERBASIS 0,61/0,5/0,43",{"$f":"IF(AK38=1,AK31-1,\"0\")","v":"0"},null,null,{"$f":"IF(SUM(AM46:AM47)<0,0,SUM(AM46:AM47))","v":0}]
[]
[]
[]
[]
[null,{"$f":"IF(B25+B26>5,IF($I$3=\"Nederlands\",'Tekst NL'!B52,'Tekst FR'!B52),\"\")","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,"aantal m kanaal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"diam 80",{"$f":"AJ21","v":0},null,5,{"$f":"AJ54*AL54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"diam 125",{"$f":"SUM(AJ23:AJ26)","v":0},null,5,{"$f":"AJ55*AL55","v":0}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B56,'Tekst FR'!B56)","v":"Keuze doorvoer"},null,"( x )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dubbel 125 ",{"$f":"AJ22","v":0},null,10,0]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B57,'Tekst FR'!B57)","v":"Muurrooster "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muurrooster ",null,{"$f":"IF(D57=\"x\",1,\"0\")","v":"0"}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B58,'Tekst FR'!B58)","v":"Dakdoorvoer plat dak"},null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(AM54:AM56)","v":0},"m easyflex",null,"Dakdoorvoer plat dak",null,{"$f":"IF(D58=\"x\",1,\"0\")","v":"0"}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B59,'Tekst FR'!B59)","v":"Dakdoorvoer hellend dak"},null,null,null,null,null,null,null,null,null,null,null,null,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":"(AM58/15)","v":0},null,null,"dakdoorvoer hellend dak",null,{"$f":"IF(D59=\"x\",1,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(AM59,0)","v":0},"rollen easyflex"]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B61,'Tekst FR'!B61)","v":"Materiaallijst"}]
[]
[null,null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!D63,'Tekst FR'!D63)","v":"Aantal"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E63,'Tekst FR'!E63)","v":"Eenheidsprijs 2022"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F63,'Tekst FR'!F63)","v":"Totaal"}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C64,'Tekst FR'!C64)","v":"VENTILATIEUNIT"}]
[null,66060102,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C65,'Tekst FR'!C65)","v":"Kit Healthbox 3.0"},{"$f":"AJ36","v":0},1594.23,{"$f":"D65*E65","v":0}]
[null,66060103,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C66,'Tekst FR'!C66)","v":"Kit Healthbox 3.0 Smartzone"},{"$f":"AK38","v":0},1652.77,0]
[null,66060125,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C67,'Tekst FR'!C67)","v":"Regelmodule wasplaats/badkamer zonder toilet"},{"$f":"AP43","v":"0"},146.38999999999999,0]
[null,66060126,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C68,'Tekst FR'!C68)","v":"Regelmodule badkamer met toilet"},{"$f":"AN42","v":"0"},205.43,0]
[null,66060127,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C69,'Tekst FR'!C69)","v":"Regelmodule toilet"},{"$f":"AO42","v":"0"},191.37,0]
[null,66060128,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C70,'Tekst FR'!C70)","v":"Regelmodule keuken"},{"$f":"AM42","v":"0"},176.15,0]
[null,66060129,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C71,'Tekst FR'!C71)","v":"Regelmodule slaapkamer"},{"$f":"IF(D12=\"x\",AL20,AQ42)","v":"0"},176.15,0]
[null,66031676,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C72,'Tekst FR'!C72)","v":"Niet-regelbare roosterbasis 174 x 174 mm ø125"},{"$f":"IF(SUM(AM44:AM45)<0,0,SUM(AM44:AM45))","v":0},7.2,0]
[null,66031675,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C73,'Tekst FR'!C73)","v":"Niet-regelbare roosterbasis 134 x 14 mm ø80"},{"$f":"IF(SUM(AM46:AM47)<0,0,SUM(AM46:AM47))","v":0},6.65,0]
[null,66060119,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C74,'Tekst FR'!C74)","v":"Print voor klepcollector"},{"$f":"IF($B$41>9,\"2\",IF($B$41>7,\"1\",\"0\"))","v":"0"},56.1,0,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H74,'Tekst FR'!H74)","v":"Minimale hoeveelheden worden standaard ingevuld. Echter kunnen \ncollectoren ook met minder regelmodules gebruikt worden om een compacte installatie te verkrijgen. Max. aantal per Healthbox 3.0: 66060119 = 2 stuks. 66060118 = 4 stuks"}]
[null,66060118,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C75,'Tekst FR'!C75)","v":"T-stuk voor klepcollector"},{"$f":"IF($B$41=11,\"4\",IF($B$41=10,\"3\",IF($B$41=9,\"2\",IF($B$41=8,\"1\",\"0\"))))","v":"0"},16.47,0]
[]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C77,'Tekst FR'!C77)","v":"LEIDINGEN"}]
[null,"G0013117",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C78,'Tekst FR'!C78)","v":"Ventielaansluiting ø125"},{"$f":"IF(OR(D11=\"x\", D13=\"x\"), D85,\nIF(D12=\"x\", IF(B25=2, 2, ROUNDUP(B25/2, 0)),0))","v":0},21.05,{"$f":"D78*E78","v":0}]
[null,"G0013116",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C79,'Tekst FR'!C79)","v":"Ventielaansluiting ø80"},{"$f":"D86","v":0},14.49,0]
[null,"G0013118",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C80,'Tekst FR'!C80)","v":"Dubbele ventielaansluiting ø125"},{"$f":"B21*2","v":0},34.83,0]
[null,"G0013132",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C81,'Tekst FR'!C81)","v":"Betondoorvoer 0,25 m ø125 "},{"$f":"D80/2","v":0},2.94,0]
[null,"G0013111",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C82,'Tekst FR'!C82)","v":"Koppelstuk met rubbers, plat ovaal"},{"$f":"D80*2+(D78+D79)*2","v":0},2.77,0]
[null,"G0013122",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C83,'Tekst FR'!C83)","v":"Koppelstuk met rubbers, rond ø125"},{"$f":"D85*2","v":0},4.62,0]
[null,"G0013121",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C84,'Tekst FR'!C84)","v":"Koppelstuk met rubbers, rond ø80"},{"$f":"D86","v":0},4.62,0]
[null,"G0013147",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C85,'Tekst FR'!C85)","v":"Kit haakse betondoorvoer ø125"},{"$f":"AJ55","v":0},27.2,{"$f":"D85*E85","v":0}]
[null,"G0013146",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C86,'Tekst FR'!C86)","v":"Kit haakse betondoorvoer ø80"},{"$f":"AJ54","v":0},20.7,0]
[null,"G0013110",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C87,'Tekst FR'!C87)","v":"Flexibel kanaal 140 x 64 15 m"},{"$f":"AM60","v":0},173.9,0]
[null,"G0013137",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C88,'Tekst FR'!C88)","v":"Metalen overzetbeugel"},{"$f":"10*D87","v":0},1.65,0]
[null,66014133,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C89,'Tekst FR'!C89)","v":"Acoudec 25 mm ø82 x 0,5 m"},{"$f":"AK31","v":0},15.11,{"$f":"D89*E89","v":0}]
[null,66014134,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C90,'Tekst FR'!C90)","v":"Acoudec 25 mm ø127 x 0,5 m"},{"$f":"AK32","v":0},17.579999999999998,0]
[null,66014110,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C91,'Tekst FR'!C91)","v":"Klemband Ø50-90mm"},{"$f":"D89","v":0},1.64,{"$f":"D91*E91","v":0}]
[null,66014111,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C92,'Tekst FR'!C92)","v":"Klemband Ø60-165mm"},{"$f":"D90","v":0},2.0499999999999998,{"$f":"D92*E92","v":0}]
[null,66014106,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C93,'Tekst FR'!C93)","v":"Flexibel Isodec ø152 x 10 m"},{"$f":"D65+D66","v":0},78.900000000000006,0]
[]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C95,'Tekst FR'!C95)","v":"DOORVOEREN*"}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C96,'Tekst FR'!C96)","v":"* Algemeen voorstel. Zie technische fiche om zekerheid te hebben over juiste model volgens type dak"}]
[null,76050001,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C97,'Tekst FR'!C97)","v":"Geveldoorvoerrooster zwart ø150"},{"$f":"IF(D57=\"\",0,1)","v":0},104.2,{"$f":"D97*E97","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H97,'Tekst FR'!H97)","v":"Zie ook variant in wit: 76050002"}]
[null,66014096,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C98,'Tekst FR'!C98)","v":"Designdakdoorvoer zwart ø150/160"},{"$f":"IF(D59=\"\",0,1)","v":0},116.57,{"$f":"D98*E98","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H98,'Tekst FR'!H98)","v":"Zie ook variant in  terracota: 66014097"}]
[null,66014263,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C99,'Tekst FR'!C99)","v":"Dakdoorvoer XL platte daken 160"},{"$f":"IF(D58=\"\",0,1)","v":0},163.96,{"$f":"D99*E99","v":0}]
[]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C101,'Tekst FR'!C101)","v":"ROOSTERS"}]
[null,66031630,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C102,'Tekst FR'!C102)","v":"XD25-50 puro Ø80"},{"$f":"AJ21","v":0},11.98,{"$f":"D102*E102","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H102,'Tekst FR'!H102)","v":"Zie ook varianten: "}]
[null,66031631,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C103,'Tekst FR'!C103)","v":"XD75 puro  Ø125"},{"$f":"SUM(AJ22:AJ26)","v":0},17.13,0,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H103,'Tekst FR'!H103)","v":"Zie ook varianten: "}]
[]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B105,'Tekst FR'!B105)","v":"Deze lijst is indicatief en geeft enkel een goede raming voor de benodigde hoeveelheid kanalen. \nEr kunnen stukken ontbreken of stukken te veel zijn. Stijgleidingen moeten nog voorzien worden, net als eventuele andere toebehoren."},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C105,'Tekst FR'!C105)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!D105,'Tekst FR'!D105)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E105,'Tekst FR'!E105)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F105,'Tekst FR'!F105)","v":0}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B106,'Tekst FR'!B106)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C106,'Tekst FR'!C106)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!D106,'Tekst FR'!D106)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E106,'Tekst FR'!E106)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F106,'Tekst FR'!F106)","v":0}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B107,'Tekst FR'!B107)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C107,'Tekst FR'!C107)","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!E107,'Tekst FR'!E107)","v":0},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!F107,'Tekst FR'!F107)","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C108,'Tekst FR'!C108)","v":"Opties (zelf in te vullen)"}]
[null,"G0013120",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C109,'Tekst FR'!C109)","v":"Y-stuk plat ovaal (RF 0,61)"},null,38.090000000000003,{"$f":"D109*E109","v":0},null,{"$f":"IF(D109>0,IF($I$3=\"Nederlands\",'Tekst NL'!H109,'Tekst FR'!H109),\"\")","v":""}]
[]
[null,66031686,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C111,'Tekst FR'!C111)","v":"Regelbare roosterbasis 174 x 174 mm ø125 (RF 0,61)"},null,21.66,{"$f":"D111*E111","v":0},null,{"$f":"IF(D111>0,IF($I$3=\"Nederlands\",'Tekst NL'!H111,'Tekst FR'!H111),\"\")","v":""}]
[null,66031687,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C112,'Tekst FR'!C112)","v":"Regelbare roosterbasis 134 x 14 mm ø80 (RF 0,61)"},null,17.600000000000001,{"$f":"D112*E112","v":0},null,{"$f":"IF(D112>0,IF($I$3=\"Nederlands\",'Tekst NL'!H112,'Tekst FR'!H112),\"\")","v":""}]
[]
[null,"G0013131",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C114,'Tekst FR'!C114)","v":"Stijgleiding 3 m ø80"},null,19.47,{"$f":"D114*E114","v":0},null,{"$f":"IF(D114>0,IF($I$3=\"Nederlands\",'Tekst NL'!H114,'Tekst FR'!H114),\"\")","v":""}]
[null,"G0013130",{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C115,'Tekst FR'!C115)","v":"Stijgleiding 3 m ø125"},null,27.13,{"$f":"D115*E115","v":0},null,{"$f":"IF(D115>0,IF($I$3=\"Nederlands\",'Tekst NL'!H115,'Tekst FR'!H115),\"\")","v":""}]
[]
[null,null,null,null,null,{"$f":"D117*E117","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H117,'Tekst FR'!H117)","v":"Andere zelf in te vullen indien gewenst"}]
[null,null,null,null,null,{"$f":"D118*E118","v":0},null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H118,'Tekst FR'!H118)","v":"Andere zelf in te vullen indien gewenst"}]
[null,null,null,null,null,0,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!H119,'Tekst FR'!H119)","v":"Andere zelf in te vullen indien gewenst"}]
[]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C121,'Tekst FR'!C121)","v":"TOTAAL PRIJS RENSON"},null,null,{"$f":"SUM(F65:F104)+SUM(F109:F119)","v":0}]
[null,null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C122,'Tekst FR'!C122)","v":"TOTAAL PRIJS RENSON incl. tijdelijke prijstoeslag (*)"},null,null,{"$f":"F121*1.08","v":0}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B123,'Tekst FR'!B123)","v":"U vindt onze huidige prijslijst & andere documentatie terug op ons portaal voor professionals: https://www.renson.eu/nl-be/voor-professionals "}]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B124,'Tekst FR'!B124)","v":"(*)Mogelijke prijstoeslagen vanaf September 2021 (en 2022) contacteer uw distributiepartner of Renson om de huidige prijstoeslag te kennen. "}]
[]
[null,{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!B126,'Tekst FR'!B126)","v":"Datum"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!C126,'Tekst FR'!C126)","v":"2022-04-27"},{"$f":"IF($I$3=\"Nederlands\",'Tekst NL'!D126,'Tekst FR'!D126)","v":"Offerte 30 dagen geldig"}]

{"sheet":"Tekst NL","index":1,"n_rows":126,"n_cols":11,"rows_kept":126,"cut":false,"hidden":true,"merged":[[63,3,63,5],[104,1,106,5],[11,4,11,7],[10,4,10,7],[12,4,12,7],[76,3,76,5],[100,3,100,5],[73,7,75,12]]}
[]
[null,null,null,null,"In te vullen velden","   Volgens BE wetgeving (residentieel)",null,null,"Versie:"]
[]
[null,null,null,null,"Laatste versie file & tutorial: ","https://www.renson.eu/nl-be/voor-professionals/easyflex-tool"]
[]
[]
[]
[]
[null,"Ingave velden"]
[null,null,null,"(x/o)"]
[null,null,"Keuze unit / reductiefactor (EPB)",null,"Healthbox 3.0 (RF 0,9)"]
[null,null,null,null,"Healthbox 3.0 Smartzone (RF 0,61)"]
[null,null,null,null,"Healthbox 3.0 Smartzone (RF 0,5 / 0,43)"]
[]
[]
[]
[null,null,"Afvoer"]
[null,"Aantal","Ruimte(s) waar ventilatie moet voorzien worden:",null,null,null,null,null,"Debiet m³/h (per ruimte)"]
[null,null,null,null,null,null,null,null,"m³/h"]
[null,null,"Toilet",null,null,null,null,null,{"$f":"IF(B20=\"\",0,J20)","v":0},25,25]
[null,null,"Keuken",null,null,null,null,null,{"$f":"IF(B21=\"\",0,J21)","v":0},75,76]
[null,null,"Wasplaats",null,null,null,null,null,0,50,51]
[null,null,"Badkamer zonder toilet",null,null,null,null,null,0,50,51]
[null,null,"Badkamer met toilet",null,null,null,null,null,0,50,51]
[null,null,"Slaapkamer",null,null,null,null,null,0,30,31]
[null,null,"Andere droge ruimtes (bv. bureau)",null,null,null,null,null,{"$f":"IF(B26=\"\",0,J26)","v":0},30,41]
[]
[null,{"$f":"SUM(B20:B26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"x\",IF(G40=0,0,IF(G40<J40,J40,IF(G40>K40,K40,G40))),0)","v":0}]
[null,{"$f":"B20+B21+B22+B23+B24+B25+B26","v":0},"TOTAAL",null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"Maximaal 11 kleppen op 1 unit",null,null,null,null,null,null,"Debiet te groot voor één ventilatie unit"]
[]
[null,null,null,"UNIT",{"$f":"IF(D11=\"x\",E11,IF(D12=\"x\",E12,IF(D13=\"x\",E13,\"Kies ventilatiesysteem\")))","v":"Kies ventilatiesysteem"}]
[]
[]
[]
[]
[]
[]
[]
[null,"Mogelijks het max. aantal CO² regelmodules overschreden. Zie handleiding Healthbox 3.0. Dit hangt af van het totaal aantal regelmodules en het aantal klepcollectoren"]
[]
[]
[]
[null,"Keuze doorvoer",null,"(x/o)"]
[null,"Muurrooster "]
[null,"Dakdoorvoer plat dak"]
[null,"Dakdoorvoer hellend dak"]
[]
[null,"Materiaallijst"]
[]
[null,null,null,"Aantal","Eenheidsprijs 2022","Totaal"]
[null,null,"VENTILATIEUNIT"]
[null,66060102,"Kit Healthbox 3.0"]
[null,66060103,"Kit Healthbox 3.0 Smartzone"]
[null,66060125,"Regelmodule wasplaats/badkamer zonder toilet"]
[null,66060126,"Regelmodule badkamer met toilet"]
[null,66060127,"Regelmodule toilet"]
[null,66060128,"Regelmodule keuken"]
[null,66060129,"Regelmodule slaapkamer"]
[null,66031676,"Niet-regelbare roosterbasis 174 x 174 mm ø125"]
[null,66031675,"Niet-regelbare roosterbasis 134 x 14 mm ø80"]
[null,66060119,"Print voor klepcollector",null,null,null,null,"Minimale hoeveelheden worden standaard ingevuld. Echter kunnen \ncollectoren ook met minder regelmodules gebruikt worden om een compacte installatie te verkrijgen. Max. aantal per Healthbox 3.0: 66060119 = 2 stuks. 66060118 = 4 stuks"]
[null,66060118,"T-stuk voor klepcollector"]
[]
[null,null,"LEIDINGEN"]
[null,"G0013117","Ventielaansluiting ø125"]
[null,"G0013116","Ventielaansluiting ø80"]
[null,"G0013118","Dubbele ventielaansluiting ø125"]
[null,"G0013132","Betondoorvoer 0,25 m ø125 "]
[null,"G0013111","Koppelstuk met rubbers, plat ovaal"]
[null,"G0013122","Koppelstuk met rubbers, rond ø125"]
[null,"G0013121","Koppelstuk met rubbers, rond ø80"]
[null,"G0013147","Kit haakse betondoorvoer ø125"]
[null,"G0013146","Kit haakse betondoorvoer ø80"]
[null,"G0013110","Flexibel kanaal 140 x 64 15 m"]
[null,"G0013137","Metalen overzetbeugel"]
[null,66014133,"Acoudec 25 mm ø82 x 0,5 m"]
[null,66014134,"Acoudec 25 mm ø127 x 0,5 m"]
[null,66014110,"Klemband Ø50-90mm"]
[null,66014111,"Klemband Ø60-165mm"]
[null,66014106,"Flexibel Isodec ø152 x 10 m"]
[]
[null,null,"DOORVOEREN*"]
[null,null,"* Algemeen voorstel. Zie technische fiche om zekerheid te hebben over juiste model volgens type dak"]
[null,76050001,"Geveldoorvoerrooster zwart ø150",null,null,null,null,"Zie ook variant in wit: 76050002"]
[null,66014096,"Designdakdoorvoer zwart ø150/160",null,null,null,null,"Zie ook variant in  terracota: 66014097"]
[null,66014263,"Dakdoorvoer XL platte daken 160"]
[]
[null,null,"ROOSTERS"]
[null,66031630,"XD25-50 puro Ø80",null,null,null,null,"Zie ook varianten: "]
[null,66031631,"XD75 puro  Ø125",null,null,null,null,"Zie ook varianten: "]
[]
[null,"Deze lijst is indicatief en geeft enkel een goede raming voor de benodigde hoeveelheid kanalen. \nEr kunnen stukken ontbreken of stukken te veel zijn. Stijgleidingen moeten nog voorzien worden, net als eventuele andere toebehoren."]
[]
[]
[null,null,"Opties (zelf in te vullen)"]
[null,"G0013120","Y-stuk plat ovaal (RF 0,61)",null,null,null,null,"Per Y-stuk nog 2 x 'koppelstuk met rubbers, plat ovaal' toevoegen G0013111"]
[]
[null,66031686,"Regelbare roosterbasis 174 x 174 mm ø125 (RF 0,61)",null,null,null,null,"Niet-regelbare roosterbasis 66031676 verwijderen"]
[null,66031687,"Regelbare roosterbasis 134 x 14 mm ø80 (RF 0,61)",null,null,null,null,"Niet-regelbare roosterbasis 66031675 verwijderen"]
[]
[null,"G0013131","Stijgleiding 3 m ø80",null,null,null,null,"Per stijglijding nog 1 x 'koppelstuk met rubbers, rond ø80' toevoegen G0013121"]
[null,"G0013130","Stijgleiding 3 m ø125",null,null,null,null,"Per stijglijding nog 1 x 'koppelstuk met rubbers, rond ø125' toevoegen G0013122"]
[]
[null,null,null,null,null,null,null,"Andere zelf in te vullen indien gewenst"]
[null,null,null,null,null,null,null,"Andere zelf in te vullen indien gewenst"]
[null,null,null,null,null,null,null,"Andere zelf in te vullen indien gewenst"]
[]
[null,null,"TOTAAL PRIJS RENSON"]
[null,null,"TOTAAL PRIJS RENSON incl. tijdelijke prijstoeslag (*)"]
[null,"U vindt onze huidige prijslijst & andere documentatie terug op ons portaal voor professionals: https://www.renson.eu/nl-be/voor-professionals "]
[null,"(*)Mogelijke prijstoeslagen vanaf September 2021 (en 2022) contacteer uw distributiepartner of Renson om de huidige prijstoeslag te kennen. "]
[]
[null,"Datum",{"$f":"TODAY()","v":"2022-04-27"},"Offerte 30 dagen geldig"]

{"sheet":"Tekst FR","index":2,"n_rows":126,"n_cols":49,"rows_kept":126,"cut":false,"hidden":true,"merged":[[100,3,100,5],[104,1,106,5],[94,2,94,5],[10,4,10,7],[11,4,11,7],[12,4,12,7],[63,3,63,5],[76,3,76,5],[73,7,75,12]]}
[]
[null,null,null,null,"Champs à remplir","       Selon loi Belge (résidentiel)",null,null,"Version:"]
[]
[null,null,null,null,"Dernière version outil & tutoriel:","https://www.renson.eu/fr-be/pour-les-professionnels/easyflex-tool"]
[]
[]
[]
[]
[null,"Ingave velden"]
[null,null,null,"(x/o)"]
[null,null,"Choix unité / Facteur de réduction (PEB)",null,"Healthbox 3.0 (FR 0,9)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zet een \"x\" bij de keuze van de unit"]
[null,null,null,null,"Healthbox 3.0 Smartzone (FR 0,61)"]
[null,null,null,null,"Healthbox 3.0 Smartzone (FR 0,5 / 0,43)"]
[]
[]
[]
[null,null,"Extraction"]
[null,"Quantité","Pièce(s) ou on doit prévoir la ventilation:",null,null,null,null,null,"Débit m³/h (par pièce)",null,null,null,null,null,null,null,null,null,null,null,"ROOSTERBASISSEN",null,null,null,null,null,null,null,null,null,"aantal ventielen","Tellers",null,null,null,null,null,null,null,"Regels"]
[null,null,null,null,null,null,null,null,"m³/h",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teller ruimtes",null,null,null,null,null,null,null,"toilet diam 80 , alle andere ruimtes diam 125",null,null,null,null,null,null,null,null,"1. Aanduiding type ruimte met \"x\" "]
[null,null,"Toilette",null,null,null,null,null,{"$f":"IF(B20=\"\",0,J20)","v":0},25,25,null,null,null,{"$f":"B20*I20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF20","v":0},{"$f":"IF(B20=\"x\",1,0)","v":0},null,null,null,null,null,{"$f":"IF(B25>4,\"1\",\"0\")","v":"0"}]
[null,null,"Cuisine",null,null,null,null,null,{"$f":"IF(B21=\"\",0,J21)","v":0},75,76,null,null,null,{"$f":"B21*I21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF21","v":0},{"$f":"IF(B21=\"x\",1,0)","v":0},null,null,"toiletten",{"$f":"B20","v":0}]
[null,null,"Buanderie",null,null,null,null,null,0,50,51,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF22","v":0},0,null,null,"keuken",{"$f":"B21","v":0}]
[null,null,"Salle de bains sans toilet",null,null,null,null,null,0,50,51,null,null,null,{"$f":"B23*I23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"wasplaats / BK z toilet",{"$f":"B22+B23","v":0}]
[null,null,"Salles de bains avec toilette",null,null,null,null,null,0,50,51,null,null,null,{"$f":"B24*I24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"Badkamer met toilet",{"$f":"B24","v":0}]
[null,null,"Chambe à coucher",null,null,null,null,null,0,30,31,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"Autre pièce sèche (ex. Bureau)",null,null,null,null,null,{"$f":"IF(B26=\"\",0,J26)","v":0},30,41,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"slaapkamers",{"$f":"B25+B26","v":0}]
[null,null,null,null,null,null,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,0]
[null,{"$f":"SUM(B20:B26)","v":0},null,null,null,null,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,0]
[null,null,null,null,null,null,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,0]
[null,null,null,null,null,null,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,0]
[null,null,null,null,null,null,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,0,null,null,"accoudec diam 82",null,{"$f":"AJ21","v":0}]
[null,null,null,null,null,null,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,0,null,null,"accoudec diam127",null,{"$f":"SUM(AJ22:AJ26)","v":0}]
[null,null,null,null,null,null,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,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enkel natte ruimtes met \"x\" aanvinken als RF = 0,90"]
[null,null,null,null,null,null,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,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slaapkamer(s) met \"x\" aanvinken als RF = 0,61"]
[null,null,null,null,null,null,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,0,null,null,"Kitsamenstelling",null,null,null,"keuken","bk met toilet","toilet","bkzt/wasplaats","slk",null,"Correctiefactoren",null,null,null,"Slaapkamer(s) met \"x\" aanvinken als RF = 0,50"]
[null,null,null,null,null,null,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,0,null,null,0.9,{"$f":"IF(D11=\"x\",1,0)","v":0},null,null,{"$f":"1*$AJ$36","v":0},{"$f":"1*$AJ$36","v":0},0,0,0,null,null,null,null,null,"Alle droge ruimtes met \"x\" aanvinken als RF = 0,43"]
[null,null,null,null,null,null,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,0,null,null,0.61,{"$f":"IF(D12=\"x\",1,0)","v":0},null,null,{"$f":"1*$AJ$37","v":0},{"$f":"1*$AJ$37","v":0},0,0,{"$f":"2*$AJ$37","v":0}]
[null,null,null,null,null,null,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,0,null,null,"0,43/0,5",{"$f":"IF(D13=\"x\",1,0)","v":0},{"$f":"SUM(AJ37:AJ38)","v":0},null,{"$f":"1*$AJ$38","v":0},{"$f":"1*$AJ$38","v":0},0,0,{"$f":"2*$AJ$38","v":0}]
[null,null,null,null,null,null,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":"AF39","v":0},0,null,null,null,null,null,"TUSSENTELLER KIT",{"$f":"SUM(AM36:AM38)","v":0},{"$f":"SUM(AN36:AN38)","v":0},0,0,{"$f":"SUM(AQ36:AQ38)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"x\",IF(G40=0,0,IF(G40<J40,J40,IF(G40>K40,K40,G40))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"extra kleppen",null,null,"NODIG",{"$f":"AJ22","v":0},{"$f":"AJ24","v":0},{"$f":"AJ21","v":0},{"$f":"AJ23","v":0},{"$f":"AJ26","v":0},{"$f":"+SUM(AM40:AQ40)","v":0}]
[null,{"$f":"B20+B21+B22+B23+B24+B25+B26","v":0},"TOTAL",null,null,null,null,null,{"$f":"SUM(O20:O26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBTOTAAL",{"$f":"AM40-AM39","v":0},{"$f":"AN40-AN39","v":0},{"$f":"AO40-AO39","v":0},0,0,null,{"$f":"IF(AN40=0,1,0)","v":1}]
[null,"Maximum 11 modules de réglage sur 1 unité",null,null,null,null,null,null,"Débit trop élevé pour 1 unité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXTRA BUITEN KIT",{"$f":"IF(AM41>0,AM41,\"0\")","v":"0"},{"$f":"IF(AN41>0,AN41,\"0\")","v":"0"},{"$f":"IF(AO41>0,AO41,\"0\")","v":"0"},{"$f":"IF(AP41>0,AP41,\"0\")-AS41","v":-1},{"$f":"IF(AQ41>0,AQ41,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AP42<0,\"0\",AP42)","v":"0"},null,null,{"$f":"IF(AJ37=1,0,1)","v":1}]
[null,null,null,"UNITÉ",{"$f":"IF(D11=\"x\",E11,IF(D12=\"x\",E12,IF(D13=\"x\",E13,\"Choix système de ventilation\")))","v":"Choix système de ventilation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø125","EXTRA ROOSTERBASIS 0,9",{"$f":"IF(AJ36=1,AK32-4,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø125","EXTRA ROOSTERBASIS 0,61/0,5/0,43",{"$f":"IF(AK38=1,AK32-6,\"0\")","v":"0"},{"$f":"SUM(AM45+AM44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø80","EXTRA ROOSTERBASIS 0,9",{"$f":"IF(AJ36=1,AK31-1,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ø80","EXTRA ROOSTERBASIS 0,61/0,5/0,43",{"$f":"IF(AK38=1,AK31-1,\"0\")","v":"0"},null,null,{"$f":"IF(SUM(AM46:AM47)<0,0,SUM(AM46:AM47))","v":0}]
[]
[]
[]
[]
[null,"Le nombre maximal des modules de réglage avec CO² est potentiellement dépassé. Voir manuel Healthbox 3.0. Ceci dépends du nombre de modules de réglage total et le nombre de collecteurs utilisé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aantal m kanaal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"diam 80",{"$f":"AJ21","v":0},null,5,{"$f":"AJ54*AL54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"diam 125",{"$f":"SUM(AJ23:AJ26)","v":0},null,5,{"$f":"AJ55*AL55","v":0}]
[null,"Choix sortie en toiture / façade",null,"(x/o)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dubbel 125 ",{"$f":"AJ22","v":0},null,10,0]
[null,"Grille pour passage en façade",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Muurrooster ",null,{"$f":"IF(D57=\"x\",1,\"0\")","v":"0"}]
[null,"Sortie en toiture toit plat",null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(AM54:AM56)","v":0},"m easyflex",null,"Dakdoorvoer plat dak",null,{"$f":"IF(D58=\"x\",1,\"0\")","v":"0"}]
[null,"Sortie en toiture toit incliné",null,null,null,null,null,null,null,null,null,null,null,null,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":"(AM58/15)","v":0},null,null,"dakdoorvoer hellend dak",null,{"$f":"IF(D59=\"x\",1,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(AM59,0)","v":0},"rollen easyflex"]
[null,"Liste de pièces"]
[]
[null,null,null,"Quantité","Prix unitaire 2022","Total"]
[null,null,"UNITÉ"]
[null,66060102,"Kit Healthbox 3.0"]
[null,66060103,"Kit Healthbox 3.0 Smartzone"]
[null,66060125,"Module de réglage buanderie / salle de bains sans toilettes"]
[null,66060126,"Module de réglage salle de bains avec toilettes"]
[null,66060127,"Module de réglage toilettes"]
[null,66060128,"Module de réglage cuisine"]
[null,66060129,"Module de réglage chambre à coucher"]
[null,66031676,"Base de la grille Ø125 - 174x174 - non-réglable"]
[null,66031675,"Base de la grille Ø80 - 134x134 - non-réglable"]
[null,66060119,"Print pour collecteur",null,null,null,null,"Quantités minimales sont pré-remplis. Par contre, les collecteurs peuvent aussi être utilisés avec moins de modules de réglage pour obtenir une installation compacte. Quantité max. par Healthbox 3.0: 66060119 = 2 pièces. 66060118 = 4 pièces"]
[null,66060118,"Pièce en T pour collecteur"]
[]
[null,null,"GAINES"]
[null,"G0013117","Raccordement à la grille Ø125"]
[null,"G0013116","Raccordement à la grille Ø80"]
[null,"G0013118","Raccordement double à la grille Ø125 mm"]
[null,"G0013132","Pièce intermédiaire 0,25m ø125"]
[null,"G0013111","Couplage oblong avec des caoutchoucs"]
[null,"G0013122","Couplage avec des caoutchoucs Ø125mm"]
[null,"G0013121","Couplage avec des caoutchoucs Ø80"]
[null,"G0013147","Kit passage de dalle coudé ø125"]
[null,"G0013146","Kit passage de dalle ø80"]
[null,"G0013110","Gaine flexible 140x64 15m"]
[null,"G0013137","Bride de fixation en métal"]
[null,66014133,"Flexible ACOUDEC 25mm ø82 x 0,5m"]
[null,66014134,"Flexible ACOUDEC 25mm ø127 x 0,5m"]
[null,66014110,"Collier de serrage Ø50-90mm"]
[null,66014111,"Collier de serrage Ø60-165mm"]
[null,66014106,"Flexible ISODEC ø152mm x 10m"]
[]
[null,null,"SORTIE EN TOITURES/FAÇADE*"]
[null,null,"* Proposition générale. Voir fiche technique pour avoir certitude sur modèle exacte selon type de toit"]
[null,76050001,"Grille pour passage en façade noire ø150",null,null,null,null,"Variante blanche: 76050002"]
[null,66014096,"Sortie en toiture incliné noire design noir ø150/160",null,null,null,null,"Variante terracota: 66014097"]
[null,66014263,"Sortie en toiture noire design XL pour toitures plates Ø160"]
[]
[null,null,"PLAQUE DE RECOUVREMENT"]
[null,66031630,"XD25-50 puro  Ø80",null,null,null,null,"Variantes:"]
[null,66031631,"XD75 puro  Ø125",null,null,null,null,"Variantes:"]
[]
[null,"Cette liste des pièces est indicative et ne donne qu'une bonne estimation du nombre de pièces et gaines besoin. C’est possible que des pièces manquent ou soient superflues (selon les besoins de votre projet). Vous deviez encore ajouter des gaines (conduits verticals) , ainsi que d'autre accessoires si nécessaire."]
[]
[]
[null,null,"Options (à remplir par utilisateur)"]
[null,"G0013120","Pièce en Y (FR 0,61)",null,null,null,null,"Par pièce en Y, à ajouter 2 x couplage oblong avec des caoutchoucs G0013111"]
[]
[null,66031686,"Base pour grille Ø125 - 174x174 - réglable (RF 0,61)",null,null,null,null,"Supprimer base de la grille non-réglable 66031676"]
[null,66031687,"Base pour grille Ø80 - 134x134 - réglable (RF 0,61)",null,null,null,null,"Supprimer base de la grille non-réglable 66031675"]
[]
[null,"G0013131","Gaine ronde 3m Ø80 - conduit vertical",null,null,null,null,"Par gaine, à ajouter 1 x Couplage avec des caoutchoucs Ø80 G0013121"]
[null,"G0013130","Gaine ronde Ø125mm 3m - conduit vertical",null,null,null,null,"Par gaine, à ajouter 1 x Couplage avec des caoutchoucs Ø125 G0013122"]
[]
[null,null,null,null,null,null,null,"Autre à remplir si désiré"]
[null,null,null,null,null,null,null,"Autre à remplir si désiré"]
[null,null,null,null,null,null,null,"Autre à remplir si désiré"]
[]
[null,null,"TOTAL PRIX RENSON"]
[null,null,"TOTAL PRIX RENSON incl. surcharge temporelle (*)"]
[null,"Vous trouviez notre liste de prix actuel et autre documentation sur notre platforme pour professionels: https://www.renson.eu/fr-be/pour-les-professionnels"]
[null,"(*)Suppléments de prix possibles à partir de septembre 2021 (et 2022). Contactez votre partenaire de distribution ou Renson pour connaître le supplément de prix en vigueur."]
[]
[null,"Date",{"$f":"TODAY()","v":"2022-04-27"},"Offre valable 30 jours"]

{"sheet":"Referenties - Références","index":3,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,4,8,4],[9,4,10,4],[35,4,36,4],[39,4,40,4],[25,4,26,4],[27,4,28,4]]}
[]
[null,"REF.","VENTILATIEUNIT","UNITÉ"]
[null,66060102,"Kit Healthbox 3.0","Kit Healthbox 3.0"]
[null,66060103,"Kit Healthbox 3.0 Smartzone","Kit Healthbox 3.0 Smartzone"]
[null,66060125,"Regelmodule wasplaats/badkamer zonder toilet","Module de réglage buanderie / salle de bains sans toilettes"]
[null,66060126,"Regelmodule badkamer met toilet","Module de réglage salle de bains avec toilettes"]
[null,66060127,"Regelmodule toilet","Module de réglage toilettes"]
[null,66060128,"Regelmodule keuken","Module de réglage cuisine"]
[null,66060129,"Regelmodule slaapkamer","Module de réglage chambre à coucher"]
[null,66031676,"Niet-regelbare roosterbasis 174 x 174 mm ø125","Base de la grille Ø125 - 174x174 - non-réglable"]
[null,66031675,"Niet-regelbare roosterbasis 134 x 14 mm ø80","Base de la grille Ø80 - 134x134 - non-réglable"]
[null,66060119,"Print voor klepcollector","Print pour collecteur"]
[null,66060118,"T-stuk voor klepcollector","Pièce en T pour collecteur"]
[null,null,"LEIDINGEN","GAINES"]
[null,"G0013117","Ventielaansluiting ø125","Raccordement à la grille Ø125"]
[null,"G0013116","Ventielaansluiting ø80","Raccordement à la grille Ø80"]
[null,"G0013118","Dubbele ventielaansluiting ø125","Raccordement double à la grille Ø125 mm"]
[null,"G0013132","Betondoorvoer 0,25 m ø125 ","Pièce intermédiaire 0,25m ø125"]
[null,"G0013111","Koppelstuk met rubbers, plat ovaal","Couplage oblong avec des caoutchoucs"]
[null,"G0013122","Koppelstuk met rubbers, rond ø125","Couplage avec des caoutchoucs Ø125mm"]
[null,"G0013121","Koppelstuk met rubbers, rond ø80","Couplage avec des caoutchoucs Ø80"]
[null,"G0013147","Kit haakse betondoorvoer ø125","Kit passage de dalle coudé ø125"]
[null,"G0013146","Kit haakse betondoorvoer ø80","Kit passage de dalle ø80"]
[null,"G0013110","Flexibel kanaal 140 x 64 15 m","Flexibel kanaal 140 x 64 15 m"]
[null,"G0013137","Metalen overzetbeugel","Bride de fixation en métal"]
[null,66014133,"Acoudec 25 mm ø82 x 0,5 m","Flexible ACOUDEC 25mm ø82 x 0,5m"]
[null,66014134,"Acoudec 25 mm ø127 x 0,5 m","Flexible ACOUDEC 25mm ø127 x 0,5m"]
[null,66014110,"Klemband Ø50-90mm","Collier de serrage Ø50-90mm"]
[null,66014111,"Klemband Ø60-165mm","Collier de serrage Ø60-165mm"]
[null,66014106,"Flexibel Isodec ø152 x 10 m","Flexible ISODEC ø152mm x 10m"]
[null,null,"DOORVOEREN","SORTIE EN TOITURES / FAÇADE"]
[null,76050001,"Geveldoorvoerrooster zwart ø150","Grille pour passage en façade noire ø150"]
[null,66014096,"Designdakdoorvoer zwart ø150/160","Sortie en toiture incliné noire design noir ø150/160"]
[null,66014263,"Dakdoorvoer XL platte daken 160","Sortie en toiture noire design XL pour toitures plates Ø160"]
[null,null,"ROOSTERS","PLAQUE DE RECOUVREMENT"]
[null,66031630,"XD25-50 puro","XD25-50 puro"]
[null,66031631,"XD75 puro","XD75 puro"]
[null,null,"Opties (zelf in te vullen)","Options (à remplir par utilisateur)"]
[null,"G0013120","Y-stuk plat ovaal (RF 0,61)","Pièce en Y (FR 0,61)"]
[null,66031686,"Regelbare roosterbasis 174 x 174 mm ø125 (RF 0,61)","Base pour grille Ø125 - 174x174 - réglable (RF 0,61)"]
[null,66031687,"Regelbare roosterbasis 134 x 14 mm ø80 (RF 0,61)","Base pour grille Ø80 - 134x134 - réglable (RF 0,61)"]
[null,"G0013131","Stijgleiding 3 m ø80","Gaine ronde 3m Ø80 - conduit vertical"]
[null,"G0013130","Stijgleiding 3 m ø125","Gaine ronde Ø125mm 3m - conduit vertical"]

{"sheet":"Installatie - Installation","index":4,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Meer info:",null,"Plus d'info:"]
["https://www.renson.eu/nl-be/producten-zoeken/ventilatie/mechanische-ventilatie/units/healthbox-3-0",null,"https://www.renson.eu/fr-be/producten-zoeken/ventilatie/mechanische-ventilatie/units/healthbox-3-0"]
["> downloads -> Handleiding",null,"> downloads -> Instructions"]
["> downloads -> Technische Fiche",null,"> downloads -> Fiche Technique"]
["> downloads -> Brochure B2C",null,"> downloads -> Brochure B2C"]
[]
["https://www.renson.eu/nl-be/voor-professionals/epb-platform",null,"https://www.renson.eu/fr-be/pour-les-professionnels/peb-plateforme"]
["> Mechanische Ventilatie (voor B2B brochure)",null,"> Ventilation Mécanique (pour brochure B2B)"]
["> Waarden EPB (voor brochure en waarden EPB)",null,"> Valeurs PEB (pour brochure & valeurs atour PEB)"]
[]
["https://www.renson.eu/nl-be/voor-professionals/opleidingen",null,"https://www.renson.eu/fr-be/pour-les-professionnels/formations"]
["Voor gratis opleidingen in ons hoofdkantoor",null,"Pour formations gratuit dans notre siège social"]