{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Home","Data","Devices","Transfer","Ducts Rect","Ducts Round","Tab 2","Langage","Versions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"comments":3,"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":"Home","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,4,7],[25,1,25,7],[9,1,9,7],[27,1,27,7],[28,1,28,7],[11,1,11,7],[12,1,12,7],[13,1,13,7]]}
[]
[]
[]
[]
[null,"Ontwerp van stookafdelingen"]
[null,null,null,null,"NBN B 61-001/002:2019"]
[]
[null,null,null,null,"Ontwikkeld in het kader van het Belgische project \"KMO - normenantenne\""]
[]
[null,"Bezoek onze website : http://www.wtcb.be"]
[]
[null,"Het WTCB kan niet verantwoordelijk gesteld worden voor de ingevoerde  "]
[null,"gegevens, noch voor het verkeerde gebruik van de software"]
[null,"of de verkeerde resultaten die eruit zouden voortkomen."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Conception des chaufferies"]
[null,null,null,null,"NBN B 61-001/002:2019"]
[]
[null,null,null,null,"Développé dans le cadre du projet belge \"PME - antenne normes\""]
[]
[null,"Visitez notre site web : http://www.cstc.be"]
[]
[null,"Le CSTC ne peut être tenu responsable des données introduites, de la"]
[null,"mauvaise utilisation du programme ou des erreurs qui en résulteraient."]
[]
[null,null,null,null,"Versie - Version 2.3 (2021)"]

{"sheet":"Data","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,2,30,7],[31,2,31,7],[6,1,6,7],[7,1,7,7],[13,2,13,4],[28,2,28,7],[29,2,29,7],[23,2,23,7],[3,1,3,7],[11,1,11,7],[19,1,19,7],[26,1,26,7],[14,2,14,7],[15,2,15,7],[16,2,16,7],[17,2,17,7],[21,2,21,7],[22,2,22,7],[24,2,24,7]]}
[]
[null,null,null,"Français",null,null,{"$f":"Langage!A33","v":"Nouveau calcul"}]
[]
[null,{"$f":"Langage!A28","v":"Données administratives"}]
[]
[]
[null,{"$f":"Langage!A31","v":"Conception des chaufferies"}]
[null,{"$f":"Langage!A32","v":"NBN B 61-001/002:2019"}]
[]
[]
[]
[null,{"$f":"Langage!A27","v":"Références"}]
[]
[null,{"$f":"Langage!A21","v":"Dossier"},null,null,null,null,{"$f":"Langage!A26","v":"Date"}]
[null,{"$f":"Langage!A22","v":"Nom"}]
[null,{"$f":"Langage!A23","v":"Adresse"}]
[null,{"$f":"Langage!A24","v":"Commune"}]
[null,{"$f":"Langage!A25","v":"Commentaire"}]
[]
[null,{"$f":"Langage!A29","v":"Bâtiment"}]
[]
[null,{"$f":"Langage!A23","v":"Adresse"}]
[null,{"$f":"Langage!A24","v":"Commune"}]
[null,{"$f":"Langage!A7","v":"Entité de bâtiment"}]
[null,{"$f":"Langage!A25","v":"Commentaire"}]
[]
[null,{"$f":"Langage!A30","v":"Installateur"}]
[]
[null,{"$f":"Langage!A22","v":"Nom"}]
[null,{"$f":"Langage!A23","v":"Adresse"}]
[null,{"$f":"Langage!A24","v":"Commune"}]
[null,{"$f":"Langage!A25","v":"Commentaire"}]

{"sheet":"Devices","index":2,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[26,5,27,5],[26,2,27,2],[24,1,24,10],[35,1,35,10],[27,8,27,9],[26,8,26,9],[3,1,3,5],[7,3,9,3],[7,5,9,5],[7,4,9,4],[7,6,9,6],[5,1,5,10],[7,9,9,9],[7,7,9,8],[7,10,9,10]]}
[]
[]
[]
[null,{"$f":"Langage!A5","v":"Données techniques"}]
[]
[null,{"$f":"Langage!A8","v":"Données relatives aux appareils de combustion"}]
[]
[null,null,{"$f":"Langage!A10","v":"Appareil"},{"$f":"Langage!A11","v":"Puissance nominale"},{"$f":"Langage!A9","v":"Circuit de combustion"},{"$f":"Langage!A48","v":"Combustible"},{"$f":"Langage!A49","v":"Brûleur"},{"$f":"Langage!A99","v":"Débit calorifique nominal\nsur Hs ou sur Hi\n(indiquer un des deux)"},null,{"$f":"Langage!A47","v":"Débit d’air comburant spécifique"},{"$f":"Langage!A46","v":"Débit d’air comburant"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://exceljet.net/formula/index-and-match-with-multiple-criteria"]
[null,null,null,"Pn   kW",null,null,null,"Qn,s   kW","Qn,i   kW","m³/(h.kW)","m³/h"]
[null,1,null,null,null,null,null,null,null,{"$f":"IF(E12=\"RS\",0,IF(OR(D12=\"\",S12=\"\"),\"\",IF(E12=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F12='Tab 2'!A$4:A$29)*(Devices!U12='Tab 2'!B$4:B$29)*(Devices!S12='Tab 2'!C$4:C$29),0)),\"\")))","v":""},{"$f":"IF(J12=\"\",\"\",J12*T12)","v":""},null,null,null,null,null,null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,'Tab 2'!A$4:F$29,2,FALSE))","v":""},{"$f":"IF(H12<>\"\",\"HS\",IF(I12<>\"\",\"HI\",\"\"))","v":""},{"$f":"IF(H12<>\"\",H12,IF(I12<>\"\",I12,0))","v":0},{"$f":"IF(OR(R12=0,R12=\"\"),\"\",G12)","v":""}]
[null,2,null,null,null,null,null,null,null,{"$f":"IF(E13=\"RS\",0,IF(OR(D13=\"\",S13=\"\"),\"\",IF(E13=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F13='Tab 2'!A$4:A$29)*(Devices!U13='Tab 2'!B$4:B$29)*(Devices!S13='Tab 2'!C$4:C$29),0)),\"\")))","v":""},{"$f":"IF(J13=\"\",\"\",J13*T13)","v":""},null,null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,'Tab 2'!A$4:F$29,2,FALSE))","v":""},{"$f":"IF(H13<>\"\",\"HS\",IF(I13<>\"\",\"HI\",\"\"))","v":""},{"$f":"IF(H13<>\"\",H13,IF(I13<>\"\",I13,0))","v":0},{"$f":"IF(OR(R13=0,R13=\"\"),\"\",G13)","v":""}]
[null,3,null,null,null,null,null,null,null,{"$f":"IF(E14=\"RS\",0,IF(OR(D14=\"\",S14=\"\"),\"\",IF(E14=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F14='Tab 2'!A$4:A$29)*(Devices!U14='Tab 2'!B$4:B$29)*(Devices!S14='Tab 2'!C$4:C$29),0)),\"\")))","v":""},{"$f":"IF(J14=\"\",\"\",J14*T14)","v":""},null,null,null,null,null,null,{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,4,null,null,null,null,null,null,null,{"$f":"IF(E15=\"RS\",0,IF(OR(D15=\"\",S15=\"\"),\"\",IF(E15=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F15='Tab 2'!A$4:A$29)*(Devices!U15='Tab 2'!B$4:B$29)*(Devices!S15='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,5,null,null,null,null,null,null,null,{"$f":"IF(E16=\"RS\",0,IF(OR(D16=\"\",S16=\"\"),\"\",IF(E16=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F16='Tab 2'!A$4:A$29)*(Devices!U16='Tab 2'!B$4:B$29)*(Devices!S16='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,6,null,null,null,null,null,null,null,{"$f":"IF(E17=\"RS\",0,IF(OR(D17=\"\",S17=\"\"),\"\",IF(E17=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F17='Tab 2'!A$4:A$29)*(Devices!U17='Tab 2'!B$4:B$29)*(Devices!S17='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,7,null,null,null,null,null,null,null,{"$f":"IF(E18=\"RS\",0,IF(OR(D18=\"\",S18=\"\"),\"\",IF(E18=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F18='Tab 2'!A$4:A$29)*(Devices!U18='Tab 2'!B$4:B$29)*(Devices!S18='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,8,null,null,null,null,null,null,null,{"$f":"IF(E19=\"RS\",0,IF(OR(D19=\"\",S19=\"\"),\"\",IF(E19=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F19='Tab 2'!A$4:A$29)*(Devices!U19='Tab 2'!B$4:B$29)*(Devices!S19='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,9,null,null,null,null,null,null,null,{"$f":"IF(E20=\"RS\",0,IF(OR(D20=\"\",S20=\"\"),\"\",IF(E20=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F20='Tab 2'!A$4:A$29)*(Devices!U20='Tab 2'!B$4:B$29)*(Devices!S20='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[null,10,null,null,null,null,null,null,null,{"$f":"IF(E21=\"RS\",0,IF(OR(D21=\"\",S21=\"\"),\"\",IF(E21=\"NRS\",INDEX('Tab 2'!F$4:F$29,MATCH(1,(Devices!F21='Tab 2'!A$4:A$29)*(Devices!U21='Tab 2'!B$4:B$29)*(Devices!S21='Tab 2'!C$4:C$29),0)),\"\")))","v":""},"",null,null,null,null,null,null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,'Tab 2'!A$4:F$29,2,FALSE))","v":""},"",0,""]
[]
[null,null,{"$f":"Langage!A6","v":"Total"},{"$f":"IF(COUNTBLANK(D12:D21)=10,\"\",SUM(D12:D21))","v":""}]
[]
[null,{"$f":"Langage!A35","v":"Dispositions techniques"}]
[]
[null,null,{"$f":"Langage!A12","v":"Surface au sol"},null,null,{"$f":"Langage!A43","v":"Débit"},null,null,{"$f":"Langage!A67","v":"Norme applicable"},null,null,null,null,null,null,null,null,"qv,iaq","qv,cool","qv,comb",null,"Pn,tot"]
[null,null,null,null,null,null,null,null,{"$f":"IF(D23=\"\",\"-\",IF(D23>=70,\"NBN B 61-001\",\"NBN B 61-002\"))","v":"-"}]
[null,null,"m²",null,null,"m³/h",null,null,null,null,null,null,null,null,null,null,null,"m³/h","m³/h","m³/h",null,"kW"]
[null,null,null,null,{"$f":"Langage!A36","v":"Air comburant"},{"$f":"IF(COUNTBLANK(K12:K21)=10,\"\",SUM(K12:K21))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"3*C30","v":0},{"$f":"12*D23^0.6","v":{"$error":"#VALUE!"}},{"$f":"IF(F30=\"\",0,F30)","v":0},{"$f":"COUNTIF(E12:E21,\"NRS\")","v":0},{"$f":"IF(COUNTBLANK(D12:D21)=10,\"\",SUM(D12:D21))","v":""},null,{"$f":"F30","v":""}]
[null,null,null,null,{"$f":"Langage!A37","v":"Amenée d’air"},{"$f":"IF(OR(D23=\"\",C30=\"\"),\"\",MAX(S30-T30,R30-T30,0))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F30+F31","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"Langage!A38","v":"Evacuation d’air"},{"$f":"IF(OR(D23=\"\",C30=\"\"),\"\",MAX(S30-T30,R30))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(U30<>0,\"NAT\",\"MEC\")","v":"MEC"}]
[]
[]
[]
[null,{"$f":"Langage!A98","v":"Sigles"}]
[]
[null,null,"RS",{"$f":"Langage!A44","v":"Etanche"},null,"NG",{"$f":"Langage!A53","v":"Gaz naturel"},null,"q/Dp",{"$f":"Langage!A$79","v":"Couple Débit / Pression"}]
[null,null,"NRS",{"$f":"Langage!A45","v":"Non-étanche"},null,"LPG",{"$f":"Langage!A54","v":"Propane - Butane"}]
[null,null,null,null,null,"HO",{"$f":"Langage!A55","v":"Gasoil de chauffage"},null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"}]
[null,null,"BWI",{"$f":"Langage!A62","v":"Brûleur avec coupe-tirage"},null,"CO",{"$f":"Langage!A56","v":"Coke"},null,"Kout",{"$f":"Langage!A$78","v":"Facteur K (extraction)"}]
[null,null,"BWO",{"$f":"Langage!A63","v":"Brûleur sans coupe-tirage"},null,"KE",{"$f":"Langage!A57","v":"Pétrole lampant"}]
[null,null,"ICE",{"$f":"Langage!A64","v":"Moteur à combustion interne"},null,"SC",{"$f":"Langage!A58","v":"Charbon"},null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"}]
[null,null,null,null,null,"BC",{"$f":"Langage!A59","v":"Lignite"},null,"CD",{"$f":"Langage!A$81","v":"Coefficient de perte de décharge"}]
[null,null,"HS",{"$f":"Langage!A66","v":"Pouvoir calorifique supérieur"},null,"WL",{"$f":"Langage!A60","v":"Bois (bûches)"}]
[null,null,"HI",{"$f":"Langage!A65","v":"Pouvoir calorifique inférieur"},null,"WP",{"$f":"Langage!A61","v":"Bois (granulés)"}]

{"sheet":"Transfer","index":3,"n_rows":49,"n_cols":72,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,8],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,8,12,8],[11,7,12,7],[20,1,20,8],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[35,1,35,8],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8]]}
[]
[]
[]
[null,{"$f":"Langage!A86","v":"Dispositif de transfert d’air monté dans une paroi extérieure du local"}]
[]
[null,{"$f":"Langage!A36","v":"Air comburant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critère d'acceptation","Pa",3]
[]
[null,null,{"$f":"Langage!A$43","v":"Débit"},null,null,null,null,null,null,null,null,null,"q/Dp","q/Dp",null,null,null,null,null,null,null,null,null,null,null,null,"Masse volumique air 20°C","kg/m³",1.204]
[null,null,"m³/h",null,null,null,null,null,null,null,null,null,"CE","CD",null,null,null,null,null,null,null,null,null,null,null,null,"Viscosité cinématique air 20°C","m²/s",{"$f":"0.000015","v":1.5E-5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kin","Kout",null,null,null,null,null,null,null,null,null,null,null,null,"Rugosité absolue","m",{"$f":"0.00015","v":1.4999999999999999E-4},null,"Acier à joint lonitudinal"]
[]
[null,null,{"$f":"Langage!A$87","v":"Dispositif de transfert d’air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:R16,2,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:R16,4,FALSE))","v":""},{"$f":"Langage!A$88","v":"Dimensions"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:X16,8,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:X16,10,FALSE))","v":""}]
[]
[null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:R16,3,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:R16,5,FALSE))","v":""},"mm",{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:X16,9,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:X16,11,FALSE))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D15=M14,E15<>\"\"),C10/3600/SQRT(2*AC$6/E15/AC$8),\"\")","v":""},{"$f":"IF(R14=\"\",\"\",IF(R14>1,\"OUT\",HLOOKUP(MIN(IF(AB15:BT15>R14,AB15:BT15)),AB15:BT16,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G15=\"\",\"\",HLOOKUP(G15,AB14:BT15,2,FALSE))","v":""},{"$f":"IF(X14>R14,\"OK\",\"NOK\")","v":"NOK"}," ",null,"200x100","250x100","200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:R16,6,FALSE))","v":""},null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:X16,12,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!A$91","v":"Débit minimum"},"m³/h",{"$f":"IF(D15=M15,C10*SQRT(E15/AC$6),\"\")","v":""}," ",{"$f":"Langage!A$92","v":"Débit nominal"},"m³/h",{"$f":"Langage!A$72","v":"Perte de pression"},"Pa",{"$f":"IF(OR(G15=\"\",H15=\"\"),\"\",(C10/H15)^2*E15)","v":""},{"$f":"IF(X15<=AC$6,\"OK\",\"NOK\")","v":"NOK"},{"$f":"Langage!A$93","v":"Max. 3.0 Pa"},null,{"$f":"(0.2*0.1)","v":2.0000000000000004E-2},{"$f":"(0.25*0.1)","v":2.5000000000000001E-2},{"$f":"(0.2*0.15)","v":0.03},{"$f":"(0.3*0.1)","v":0.03},{"$f":"(0.25*0.15)","v":3.7499999999999999E-2},{"$f":"(0.2*0.2)","v":4.0000000000000008E-2},{"$f":"(0.4*0.1)","v":4.0000000000000008E-2},{"$f":"(0.3*0.15)","v":4.4999999999999998E-2},{"$f":"(0.25*0.2)","v":0.05},{"$f":"(0.3*0.2)","v":0.06},{"$f":"(0.4*0.15)","v":0.06},{"$f":"(0.25*0.25)","v":6.25E-2},{"$f":"(0.3*0.25)","v":7.4999999999999997E-2},{"$f":"(0.5*0.15)","v":7.4999999999999997E-2},{"$f":"(0.4*0.2)","v":8.0000000000000016E-2},{"$f":"(0.3*0.3)","v":0.09},{"$f":"(0.6*0.15)","v":0.09},{"$f":"(0.4*0.25)","v":0.1},{"$f":"(0.5*0.2)","v":0.1},{"$f":"(0.4*0.3)","v":0.12},{"$f":"(0.6*0.2)","v":0.12},{"$f":"(0.5*0.25)","v":0.125},{"$f":"(0.5*0.3)","v":0.15},{"$f":"(0.6*0.25)","v":0.15},{"$f":"(0.4*0.4)","v":0.16000000000000003},{"$f":"(0.8*0.2)","v":0.16000000000000003},{"$f":"(0.6*0.3)","v":0.18},{"$f":"(0.5*0.4)","v":0.2},{"$f":"(0.8*0.25)","v":0.2},{"$f":"(0.6*0.4)","v":0.24},{"$f":"(0.8*0.3)","v":0.24},{"$f":"(1*0.25)","v":0.25},{"$f":"(0.5*0.5)","v":0.25},{"$f":"(1*0.3)","v":0.3},{"$f":"(0.6*0.5)","v":0.3},{"$f":"(0.8*0.4)","v":0.32000000000000006},{"$f":"(0.6*0.6)","v":0.36},{"$f":"(1*0.4)","v":0.4},{"$f":"(0.8*0.5)","v":0.4},{"$f":"(0.8*0.6)","v":0.48},{"$f":"(1*0.5)","v":0.5},{"$f":"(1*0.6)","v":0.6},{"$f":"(0.8*0.8)","v":0.64000000000000012},{"$f":"(1*0.8)","v":0.8},{"$f":"(1*1)","v":1}]
[null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:S16,7,FALSE))","v":""},null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D15=M16,E15<>\"\"),C10/3600/SQRT(2*AC$6*E15^2/AC$8),\"\")","v":""},{"$f":"IF(R16=\"\",\"\",IF(R16>1,\"OUT\",HLOOKUP(MIN(IF(AB15:BT15>R16,AB15:BT15)),AB15:BT16,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G15=\"\",\"\",HLOOKUP(G15,AB14:BT15,2,FALSE))","v":""},{"$f":"IF(X16>R16,\"OK\",\"NOK\")","v":"NOK"}," ",null,{"$f":"AB14","v":"200x100"},{"$f":"AC14","v":"250x100"},"200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:Z16,14,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,M14:Y16,13,FALSE))","v":""}]
[]
[null,null,{"$f":"IF(OR(R19=0,G15=0,G15=\"\"),\"\",R19+G15)","v":""}]
[]
[null,{"$f":"Langage!A$37","v":"Amenée d’air"}]
[]
[null,null,{"$f":"Langage!A$43","v":"Débit"}]
[null,null,"m³/h"]
[]
[]
[null,null,{"$f":"Langage!A$87","v":"Dispositif de transfert d’air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:R31,2,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:R31,4,FALSE))","v":""},{"$f":"Langage!A$88","v":"Dimensions"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:X31,8,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:X31,10,FALSE))","v":""}]
[]
[null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:R31,3,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:R31,5,FALSE))","v":""},"mm",{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:X31,9,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:X31,11,FALSE))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D30=M29,E30<>\"\"),C25/3600/SQRT(2*AC$6/E30/AC$8),\"\")","v":""},{"$f":"IF(R29=\"\",\"\",IF(R29>1,\"OUT\",HLOOKUP(MIN(IF(AB30:BT30>R29,AB30:BT30)),AB30:BT31,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G30=\"\",\"\",HLOOKUP(G30,AB29:BT30,2,FALSE))","v":""},{"$f":"IF(X29>R29,\"OK\",\"NOK\")","v":"NOK"}," ",null,"200x100","250x100","200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:R31,6,FALSE))","v":""},null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:X31,12,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!A$91","v":"Débit minimum"},"m³/h",{"$f":"IF(D30=M30,C25*SQRT(E30/AC$6),\"\")","v":""}," ",{"$f":"Langage!A$92","v":"Débit nominal"},"m³/h",{"$f":"Langage!A$72","v":"Perte de pression"},"Pa",{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",(C25/H30)^2*E30)","v":""},{"$f":"IF(X30<=AC$6,\"OK\",\"NOK\")","v":"NOK"},{"$f":"Langage!A$93","v":"Max. 3.0 Pa"},null,{"$f":"(0.2*0.1)","v":2.0000000000000004E-2},{"$f":"(0.25*0.1)","v":2.5000000000000001E-2},{"$f":"(0.2*0.15)","v":0.03},{"$f":"(0.3*0.1)","v":0.03},{"$f":"(0.25*0.15)","v":3.7499999999999999E-2},{"$f":"(0.2*0.2)","v":4.0000000000000008E-2},{"$f":"(0.4*0.1)","v":4.0000000000000008E-2},{"$f":"(0.3*0.15)","v":4.4999999999999998E-2},{"$f":"(0.25*0.2)","v":0.05},{"$f":"(0.3*0.2)","v":0.06},{"$f":"(0.4*0.15)","v":0.06},{"$f":"(0.25*0.25)","v":6.25E-2},{"$f":"(0.3*0.25)","v":7.4999999999999997E-2},{"$f":"(0.5*0.15)","v":7.4999999999999997E-2},{"$f":"(0.4*0.2)","v":8.0000000000000016E-2},{"$f":"(0.3*0.3)","v":0.09},{"$f":"(0.6*0.15)","v":0.09},{"$f":"(0.4*0.25)","v":0.1},{"$f":"(0.5*0.2)","v":0.1},{"$f":"(0.4*0.3)","v":0.12},{"$f":"(0.6*0.2)","v":0.12},{"$f":"(0.5*0.25)","v":0.125},{"$f":"(0.5*0.3)","v":0.15},{"$f":"(0.6*0.25)","v":0.15},{"$f":"(0.4*0.4)","v":0.16000000000000003},{"$f":"(0.8*0.2)","v":0.16000000000000003},{"$f":"(0.6*0.3)","v":0.18},{"$f":"(0.5*0.4)","v":0.2},{"$f":"(0.8*0.25)","v":0.2},{"$f":"(0.6*0.4)","v":0.24},{"$f":"(0.8*0.3)","v":0.24},{"$f":"(1*0.25)","v":0.25},{"$f":"(0.5*0.5)","v":0.25},{"$f":"(1*0.3)","v":0.3},{"$f":"(0.6*0.5)","v":0.3},{"$f":"(0.8*0.4)","v":0.32000000000000006},{"$f":"(0.6*0.6)","v":0.36},{"$f":"(1*0.4)","v":0.4},{"$f":"(0.8*0.5)","v":0.4},{"$f":"(0.8*0.6)","v":0.48},{"$f":"(1*0.5)","v":0.5},{"$f":"(1*0.6)","v":0.6},{"$f":"(0.8*0.8)","v":0.64000000000000012},{"$f":"(1*0.8)","v":0.8},{"$f":"(1*1)","v":1}]
[null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:S31,7,FALSE))","v":""},null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D30=M31,E30<>\"\"),C25/3600/SQRT(2*AC$6*E30^2/AC$8),\"\")","v":""},{"$f":"IF(R31=\"\",\"\",IF(R31>1,\"OUT\",HLOOKUP(MIN(IF(AB30:BT30>R31,AB30:BT30)),AB30:BT31,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G30=\"\",\"\",HLOOKUP(G30,AB29:BT30,2,FALSE))","v":""},{"$f":"IF(X31>R31,\"OK\",\"NOK\")","v":"NOK"}," ",null,{"$f":"AB29","v":"200x100"},{"$f":"AC29","v":"250x100"},"200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:Z31,14,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,M29:Y31,13,FALSE))","v":""}]
[]
[]
[]
[null,{"$f":"Langage!A$38","v":"Evacuation d’air"}]
[]
[null,null,{"$f":"Langage!A$43","v":"Débit"}]
[null,null,"m³/h"]
[]
[]
[null,null,{"$f":"Langage!A$87","v":"Dispositif de transfert d’air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:R46,2,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:R46,4,FALSE))","v":""},{"$f":"Langage!A$88","v":"Dimensions"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:X46,8,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:X46,10,FALSE))","v":""}]
[]
[null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:R46,3,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:R46,5,FALSE))","v":""},"mm",{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:X46,9,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:X46,11,FALSE))","v":""},null,null,null,"Kout",{"$f":"Langage!A$78","v":"Facteur K (extraction)"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D45=M44,E45<>\"\"),C40/3600/SQRT(2*AC$6/E45/AC$8),\"\")","v":""},{"$f":"IF(R44=\"\",\"\",IF(R44>1,\"OUT\",HLOOKUP(MIN(IF(AB45:BT45>R44,AB45:BT45)),AB45:BT46,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G45=\"\",\"\",HLOOKUP(G45,AB44:BT45,2,FALSE))","v":""},{"$f":"IF(X44>R44,\"OK\",\"NOK\")","v":"NOK"}," ",null,"200x100","250x100","200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:R46,6,FALSE))","v":""},null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:X46,12,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!A$91","v":"Débit minimum"},"m³/h",{"$f":"IF(D45=M45,C40*SQRT(E45/AC$6),\"\")","v":""}," ",{"$f":"Langage!A$92","v":"Débit nominal"},"m³/h",{"$f":"Langage!A$72","v":"Perte de pression"},"Pa",{"$f":"IF(OR(G45=\"\",H45=\"\"),\"\",(C40/H45)^2*E45)","v":""},{"$f":"IF(X45<=AC$6,\"OK\",\"NOK\")","v":"NOK"},{"$f":"Langage!A$93","v":"Max. 3.0 Pa"},null,{"$f":"(0.2*0.1)","v":2.0000000000000004E-2},{"$f":"(0.25*0.1)","v":2.5000000000000001E-2},{"$f":"(0.2*0.15)","v":0.03},{"$f":"(0.3*0.1)","v":0.03},{"$f":"(0.25*0.15)","v":3.7499999999999999E-2},{"$f":"(0.2*0.2)","v":4.0000000000000008E-2},{"$f":"(0.4*0.1)","v":4.0000000000000008E-2},{"$f":"(0.3*0.15)","v":4.4999999999999998E-2},{"$f":"(0.25*0.2)","v":0.05},{"$f":"(0.3*0.2)","v":0.06},{"$f":"(0.4*0.15)","v":0.06},{"$f":"(0.25*0.25)","v":6.25E-2},{"$f":"(0.3*0.25)","v":7.4999999999999997E-2},{"$f":"(0.5*0.15)","v":7.4999999999999997E-2},{"$f":"(0.4*0.2)","v":8.0000000000000016E-2},{"$f":"(0.3*0.3)","v":0.09},{"$f":"(0.6*0.15)","v":0.09},{"$f":"(0.4*0.25)","v":0.1},{"$f":"(0.5*0.2)","v":0.1},{"$f":"(0.4*0.3)","v":0.12},{"$f":"(0.6*0.2)","v":0.12},{"$f":"(0.5*0.25)","v":0.125},{"$f":"(0.5*0.3)","v":0.15},{"$f":"(0.6*0.25)","v":0.15},{"$f":"(0.4*0.4)","v":0.16000000000000003},{"$f":"(0.8*0.2)","v":0.16000000000000003},{"$f":"(0.6*0.3)","v":0.18},{"$f":"(0.5*0.4)","v":0.2},{"$f":"(0.8*0.25)","v":0.2},{"$f":"(0.6*0.4)","v":0.24},{"$f":"(0.8*0.3)","v":0.24},{"$f":"(1*0.25)","v":0.25},{"$f":"(0.5*0.5)","v":0.25},{"$f":"(1*0.3)","v":0.3},{"$f":"(0.6*0.5)","v":0.3},{"$f":"(0.8*0.4)","v":0.32000000000000006},{"$f":"(0.6*0.6)","v":0.36},{"$f":"(1*0.4)","v":0.4},{"$f":"(0.8*0.5)","v":0.4},{"$f":"(0.8*0.6)","v":0.48},{"$f":"(1*0.5)","v":0.5},{"$f":"(1*0.6)","v":0.6},{"$f":"(0.8*0.8)","v":0.64000000000000012},{"$f":"(1*0.8)","v":0.8},{"$f":"(1*1)","v":1}]
[null,null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:S46,7,FALSE))","v":""},null,null,null,null,null,null,"CD",{"$f":"Langage!A$81","v":"Coefficient de perte de décharge"},"-",{"$f":"Langage!A$90","v":"Surface minimum"},"m²",{"$f":"IF(AND(D45=M46,E45<>\"\"),C40/3600/SQRT(2*AC$6*E45^2/AC$8),\"\")","v":""},{"$f":"IF(R46=\"\",\"\",IF(R46>1,\"OUT\",HLOOKUP(MIN(IF(AB45:BT45>R46,AB45:BT45)),AB45:BT46,2,TRUE)))","v":""}," "," ",{"$f":"Langage!A$89","v":"Surface"},"m²",{"$f":"IF(G45=\"\",\"\",HLOOKUP(G45,AB44:BT45,2,FALSE))","v":""},{"$f":"IF(X46>R46,\"OK\",\"NOK\")","v":"NOK"}," ",null,{"$f":"AB44","v":"200x100"},{"$f":"AC44","v":"250x100"},"200x150","300x100","250x150","200x200","400x100","300x150","250x200","300x200","400x150","250x250","300x250","500x150","400x200","300x300","600x150","400x250","500x200","400x300","600x200","500x250","500x300","600x250","400x400","800x200","600x300","500x400","800x250","600x400","800x300","1000x250","500x500","1000x300","600x500","800x400","600x600","1000x400","800x500","800x600","1000x500","1000x600","800x800","1000x800","1000x1000"]
[null,null,null,null,null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:Z46,14,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,M44:Y46,13,FALSE))","v":""}]
[]
[null,null,{"$f":"IF(OR(R49=0,G45=0,G45=\"\"),\"\",R49+G45)","v":""}]

{"sheet":"Ducts Rect","index":4,"n_rows":64,"n_cols":76,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,9],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[20,1,20,9],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[35,1,35,9],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6]]}
[]
[]
[]
[null,{"$f":"Langage!A85","v":"Conduits de ventilation - Rectangulaires - Tôle d'acier galvanisé"}]
[]
[null,{"$f":"Langage!A36","v":"Air comburant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critère d'acceptation","Pa",3]
[]
[null,null,{"$f":"Langage!A43","v":"Débit"},{"$f":"Langage!A69","v":"Longueur droite"},{"$f":"Langage!A70","v":"Coude 90°"},{"$f":"Langage!A71","v":"Coude 45°"},{"$f":"Langage!A88","v":"Dimensions"},{"$f":"Langage!A73","v":"Options"},{"$f":"Langage!A94","v":"Minimum"},{"$f":"Langage!A72","v":"Perte de pression"},null,null,"q/Dp","q/Dp",null,null,null,null,null,null,null,"Masse volumique air 20°C","kg/m³",1.204]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null,null,"CE","CD",null,null,null,null,null,null,null,"Viscosité cinématique air 20°C","m²/s",{"$f":"0.000015","v":1.5E-5}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",HLOOKUP(\"OK\",X12:BP27,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(\"OK\",X12:BP27,16,FALSE))","v":""},null,null,"Kin","Kout",null,null,null,null,null,null,null,"Rugosité absolue","m",{"$f":"0.00015","v":1.4999999999999999E-4},null,null,null,null,null,"Acier à joint lonitudinal"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(T12,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(I11,X13:BP27,15,FALSE))","v":""}]
[null,null,{"$f":"Langage!A75","v":"Bouche de prise d'air"},{"$f":"Langage!A82","v":"Données"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,2,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,4,FALSE))","v":""},null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(U12,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(I12,X13:BP27,15,FALSE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"\",\"\",HLOOKUP(I10,X13:BP14,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",MIN(IF(X14:BP14>S12,X14:BP14)))","v":""},{"$f":"IF(T12=0,0,IF(C10=\"\",\"\",MIN(IF(X14:BP14>T12,X14:BP14))))","v":""},"Air comburant",null,{"$f":"IF(OR(X27=\"OUT\",X27>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y27=\"OUT\",Y27>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Z27=\"OUT\",Z27>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK",null,null,null,null,null,"200x100",0.13300000000000001,{"$f":"BV12","v":"200x100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse",null,"Dimensions possibles","mm","200x100","250x100","300x100","400x100","200x150","250x150","200x200","300x150","400x150","250x200","500x150","300x200","600x150","250x250","400x200","300x250","500x200","300x300","600x200","400x250","800x200","500x250","400x300","600x250","500x300","800x250","400x400","600x300","1000x250","800x300","500x400","1000x300","600x400","500x500","800x400","600x500","1000x400","600x600","800x500","1000x500","800x600","1000x600","800x800","1000x800","1000x1000",null,null,null,null,null,"250x100",0.14299999999999999,{"$f":"BV13","v":"250x100"}]
[null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,3,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S19=0,S19=\"\"),\"\",IF(S19=\"OUT\",\"OUT\",S19))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-"," "," ",{"$f":"IF(D15<>N14,\"\",E15*X8*T14^2/2)","v":""},{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:BP28,16,FALSE))","v":""},null,"Diamètre hydraulique","mm",0.13300000000000001,0.14299999999999999,0.15,0.16,0.17100000000000001,0.188,0.2,0.2,0.218,0.222,0.23100000000000001,0.24,0.24,0.25,0.26700000000000002,0.27300000000000002,0.28599999999999998,0.3,0.3,0.308,0.32,0.33300000000000002,0.34300000000000003,0.35299999999999998,0.375,0.38100000000000001,0.4,0.4,0.4,0.436,0.44400000000000001,0.46200000000000002,0.48,0.5,0.53300000000000003,0.54500000000000004,0.57099999999999995,0.6,0.61499999999999999,0.66700000000000004,0.68600000000000005,0.75,0.8,0.88900000000000001,1,null,null,null,null,null,"300x100",0.15,"300x100"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D15<>N15,\"\",(C10/F15)^2*E15)","v":""},null,null,"Section","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"400x100",0.16,"400x100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-"," "," ",{"$f":"IF(D15<>N16,\"\",1/E15^2*X8*T16^2/2)","v":""},{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:BP28,16,FALSE))","v":""},null,"Vitesse réelle","m/s",{"$f":"X28","v":0},{"$f":"Y28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"200x150",0.17100000000000001,"200x150"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S19=0,S19=\"\",J15=0,J15=\"\"),\"\",IF(S19=\"OUT\",\"OUT\",S19+J15))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X16*X14/$X$9","v":0},{"$f":"Y16*Y14/$X$9","v":0},{"$f":"Z16*Z14/$X$9","v":0},0,0,0,0,0,0,0,0,{"$f":"AI16*AI14/$X$9","v":0},{"$f":"AJ16*AJ14/$X$9","v":0},0,0,0,0,0,{"$f":"AP16*AP14/$X$9","v":0},0,{"$f":"AR16*AR14/$X$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP16*BP14/$X$9","v":0},null,null,null,null,null,"250x150",0.188,"250x150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Coefficient de frottement","-",{"$f":"IF(X17<3300,\"OUT\",0.25/(LOG($X$10/X14/3.7+5.74/X17^0.9))^2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",0.25/(LOG($X$10/Y14/3.7+5.74/Y17^0.9))^2)","v":"OUT"},{"$f":"IF(Z17<3300,\"OUT\",0.25/(LOG($X$10/Z14/3.7+5.74/Z17^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AI17<3300,\"OUT\",0.25/(LOG($X$10/AI14/3.7+5.74/AI17^0.9))^2)","v":"OUT"},{"$f":"IF(AJ17<3300,\"OUT\",0.25/(LOG($X$10/AJ14/3.7+5.74/AJ17^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AP17<3300,\"OUT\",0.25/(LOG($X$10/AP14/3.7+5.74/AP17^0.9))^2)","v":"OUT"},"OUT",{"$f":"IF(AR17<3300,\"OUT\",0.25/(LOG($X$10/AR14/3.7+5.74/AR17^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP17<3300,\"OUT\",0.25/(LOG($X$10/BP14/3.7+5.74/BP17^0.9))^2)","v":"OUT"},null,null,null,null,null,"200x200",0.2,"200x200"]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:BP27,15,FALSE))","v":""},null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X18=\"OUT\",\"OUT\",X18/X14*$X$8/2*X16^2)","v":"OUT"},{"$f":"IF(Y18=\"OUT\",\"OUT\",Y18/Y14*$X$8/2*Y16^2)","v":"OUT"},{"$f":"IF(Z18=\"OUT\",\"OUT\",Z18/Z14*$X$8/2*Z16^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AI18=\"OUT\",\"OUT\",AI18/AI14*$X$8/2*AI16^2)","v":"OUT"},{"$f":"IF(AJ18=\"OUT\",\"OUT\",AJ18/AJ14*$X$8/2*AJ16^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AP18=\"OUT\",\"OUT\",AP18/AP14*$X$8/2*AP16^2)","v":"OUT"},"OUT",{"$f":"IF(AR18=\"OUT\",\"OUT\",AR18/AR14*$X$8/2*AR16^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP18=\"OUT\",\"OUT\",BP18/BP14*$X$8/2*BP16^2)","v":"OUT"},null,null,null,null,null,"300x150",0.2,"300x150"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X19=\"OUT\",\"OUT\",X19*$D10)","v":"OUT"},{"$f":"IF(Y19=\"OUT\",\"OUT\",Y19*$D10)","v":"OUT"},{"$f":"IF(Z19=\"OUT\",\"OUT\",Z19*$D10)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AI19=\"OUT\",\"OUT\",AI19*$D10)","v":"OUT"},{"$f":"IF(AJ19=\"OUT\",\"OUT\",AJ19*$D10)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AP19=\"OUT\",\"OUT\",AP19*$D10)","v":"OUT"},"OUT",{"$f":"IF(AR19=\"OUT\",\"OUT\",AR19*$D10)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP19=\"OUT\",\"OUT\",BP19*$D10)","v":"OUT"},null,null,null,null,null,"400x150",0.218,"400x150"]
[null,{"$f":"Langage!A$37","v":"Amenée d’air"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",0.25,0.26,0.26,0.27,0.23,0.23,0.21,0.25,0.26,0.23,0.27,0.24,0.27,0.21,0.25,0.22,0.26,0.21,0.26,0.24,0.27,0.25,0.23,0.26,0.24,0.27,0.21,0.25,0.27,0.26,0.23,0.27,0.24,0.21,0.25,0.22,0.26,0.21,0.24,0.25,0.23,0.24,0.21,0.23,0.21,null,null,null,null,null,"250x200",0.222,"250x200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",$E10*X21*$X$8*X16^2/2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",$E10*Y21*$X$8*Y16^2/2)","v":"OUT"},null,null,"OUT",{"$f":"IF(AC17<3300,\"OUT\",$E10*AC21*$X$8*AC16^2/2)","v":"OUT"},"OUT",{"$f":"IF(AE17<3300,\"OUT\",$E10*AE21*$X$8*AE16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AP17<3300,\"OUT\",$E10*AP21*$X$8*AP16^2/2)","v":"OUT"},{"$f":"IF(AQ17<3300,\"OUT\",$E10*AQ21*$X$8*AQ16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP17<3300,\"OUT\",$E10*BP21*$X$8*BP16^2/2)","v":"OUT"},null,null,null,null,null,"500x150",0.23100000000000001,"500x150"]
[null,null,{"$f":"Langage!A$43","v":"Débit"},{"$f":"Langage!A$69","v":"Longueur droite"},{"$f":"Langage!A$70","v":"Coude 90°"},{"$f":"Langage!A$71","v":"Coude 45°"},{"$f":"Langage!A$88","v":"Dimensions"},{"$f":"Langage!A$73","v":"Options"},{"$f":"Langage!A$94","v":"Minimum"},{"$f":"Langage!A$72","v":"Perte de pression"},null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",{"$f":"0.6*X21","v":0.15},{"$f":"0.6*Y21","v":0.156},{"$f":"0.6*Z21","v":0.156},0.16200000000000001,0.13800000000000001,0.13800000000000001,0.126,{"$f":"0.6*AE21","v":0.15},0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.16200000000000001,0.126,0.15,0.13200000000000001,0.156,0.126,{"$f":"0.6*AP21","v":0.156},{"$f":"0.6*AQ21","v":0.14399999999999999},0.16200000000000001,0.15,0.13800000000000001,0.156,0.14399999999999999,0.16200000000000001,0.126,0.15,0.16200000000000001,0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.126,0.15,0.13200000000000001,0.156,0.126,0.14399999999999999,0.15,0.13800000000000001,0.14399999999999999,0.126,0.13800000000000001,{"$f":"0.6*BP21","v":0.126},null,null,null,null,null,"300x200",0.24,"300x200"]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",$F10*X23*$X$8*X16^2/2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",$F10*Y23*$X$8*Y16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AE17<3300,\"OUT\",$F10*AE23*$X$8*AE16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AP17<3300,\"OUT\",$F10*AP23*$X$8*AP16^2/2)","v":"OUT"},{"$f":"IF(AQ17<3300,\"OUT\",$F10*AQ23*$X$8*AQ16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP17<3300,\"OUT\",$F10*BP23*$X$8*BP16^2/2)","v":"OUT"},null,null,null,null,null,"600x150",0.24,"600x150"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",HLOOKUP(\"OK\",X30:BP45,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(\"OK\",X30:BP45,16,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Sortie libre du conduit","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,"250x250",0.25,"250x250"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(T27,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(I26,X31:BP45,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",X25*$X$8*X16^2/2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",Y25*$X$8*Y16^2/2)","v":"OUT"},{"$f":"IF(Z17<3300,\"OUT\",Z25*$X$8*Z16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(AI17<3300,\"OUT\",AI25*$X$8*AI16^2/2)","v":"OUT"},{"$f":"IF(AJ17<3300,\"OUT\",AJ25*$X$8*AJ16^2/2)","v":"OUT"},"OUT","OUT",{"$f":"IF(AM17<3300,\"OUT\",AM25*$X$8*AM16^2/2)","v":"OUT"},"OUT","OUT",{"$f":"IF(AP17<3300,\"OUT\",AP25*$X$8*AP16^2/2)","v":"OUT"},{"$f":"IF(AQ17<3300,\"OUT\",AQ25*$X$8*AQ16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",{"$f":"IF(BP17<3300,\"OUT\",BP25*$X$8*BP16^2/2)","v":"OUT"},null,null,null,null,null,"400x200",0.26700000000000002,"400x200"]
[null,null,{"$f":"Langage!A$75","v":"Bouche de prise d'air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,2,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,4,FALSE))","v":""},null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(U27,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(I27,X31:BP45,15,FALSE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I25=\"\",\"\",HLOOKUP(I25,X31:BP32,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",MIN(IF(X32:BP32>S27,X32:BP32)))","v":""},{"$f":"IF(T27=0,0,IF(C25=\"\",\"\",MIN(IF(X32:BP32>T27,X32:BP32))))","v":""},"Perte de pression partielle","Pa",{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(X17<3300,\"OUT\",X20+X22+X24+X26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(Y17<3300,\"OUT\",Y20+Y22+Y24+Y26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(Z17<3300,\"OUT\",Z20+Z22+Z24+Z26))","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(AI17<3300,\"OUT\",AI20+AI22+AI24+AI26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(AJ17<3300,\"OUT\",AJ20+AJ22+AJ24+AJ26))","v":0},0,0,{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(AM17<3300,\"OUT\",AM20+AM22+AM24+AM26))","v":0},0,0,{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(AP17<3300,\"OUT\",AP20+AP22+AP24+AP26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(AQ17<3300,\"OUT\",AQ20+AQ22+AQ24+AQ26))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(BP17<3300,\"OUT\",BP20+BP22+BP24+BP26))","v":0},null,null,null,null,null,"300x250",0.27300000000000002,"300x250"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse",null,"Vitesse réelle","m/s",{"$f":"$C10/(0.2*0.1)/3600","v":0},{"$f":"$C10/(0.25*0.1)/3600","v":0},{"$f":"$C10/(0.3*0.1)/3600","v":0},{"$f":"$C10/(0.4*0.1)/3600","v":0},{"$f":"$C10/(0.2*0.15)/3600","v":0},{"$f":"$C10/(0.25*0.15)/3600","v":0},{"$f":"$C10/(0.2*0.2)/3600","v":0},{"$f":"$C10/(0.3*0.15)/3600","v":0},{"$f":"$C10/(0.4*0.15)/3600","v":0},{"$f":"$C10/(0.25*0.2)/3600","v":0},{"$f":"$C10/(0.5*0.15)/3600","v":0},{"$f":"$C10/(0.3*0.2)/3600","v":0},{"$f":"$C10/(0.6*0.15)/3600","v":0},{"$f":"$C10/(0.25*0.25)/3600","v":0},{"$f":"$C10/(0.4*0.2)/3600","v":0},{"$f":"$C10/(0.3*0.25)/3600","v":0},{"$f":"$C10/(0.5*0.2)/3600","v":0},{"$f":"$C10/(0.3*0.3)/3600","v":0},{"$f":"$C10/(0.6*0.2)/3600","v":0},{"$f":"$C10/(0.4*0.25)/3600","v":0},{"$f":"$C10/(0.8*0.2)/3600","v":0},{"$f":"$C10/(0.5*0.25)/3600","v":0},{"$f":"$C10/(0.4*0.3)/3600","v":0},{"$f":"$C10/(0.6*0.25)/3600","v":0},{"$f":"$C10/(0.5*0.3)/3600","v":0},{"$f":"$C10/(0.8*0.25)/3600","v":0},{"$f":"$C10/(0.4*0.4)/3600","v":0},{"$f":"$C10/(0.6*0.3)/3600","v":0},{"$f":"$C10/(1*0.25)/3600","v":0},{"$f":"$C10/(0.8*0.3)/3600","v":0},{"$f":"$C10/(0.5*0.4)/3600","v":0},{"$f":"$C10/(1*0.3)/3600","v":0},{"$f":"$C10/(0.6*0.4)/3600","v":0},{"$f":"$C10/(0.5*0.5)/3600","v":0},{"$f":"$C10/(0.8*0.4)/3600","v":0},{"$f":"$C10/(0.6*0.5)/3600","v":0},{"$f":"$C10/(1*0.4)/3600","v":0},{"$f":"$C10/(0.6*0.6)/3600","v":0},{"$f":"$C10/(0.8*0.5)/3600","v":0},{"$f":"$C10/(1*0.5)/3600","v":0},{"$f":"$C10/(0.8*0.6)/3600","v":0},{"$f":"$C10/(1*0.6)/3600","v":0},{"$f":"$C10/(0.8*0.8)/3600","v":0},{"$f":"$C10/(1*0.8)/3600","v":0},{"$f":"$C10/(1*1)/3600","v":0},null,null,null,null,null,"500x200",0.28599999999999998,"500x200"]
[null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,3,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S34=0,S34=\"\"),\"\",IF(S34=\"OUT\",\"OUT\",S34))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-"," "," ",{"$f":"IF(D30<>N29,\"\",E30*$X$8*T29^2/2)","v":""},{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:BP46,16,FALSE))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"300x300",0.3,"300x300"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D30<>N30,\"\",(C25/F30)^2*E30)","v":""},null,null,"Amenée d'air",null,{"$f":"IF(OR(X45=\"OUT\",X45>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y45=\"OUT\",Y45>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Z45=\"OUT\",Z45>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK",null,null,null,null,null,"600x200",0.3,"600x200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-"," "," ",{"$f":"IF(D30<>N31,\"\",1/E30^2*$X$8*T29^2/2)","v":""},{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:BP46,16,FALSE))","v":""},null,"Dimensions possibles","mm",{"$f":"X13","v":"200x100"},{"$f":"Y13","v":"250x100"},{"$f":"Z13","v":"300x100"},"400x100","200x150","250x150","200x200","300x150","400x150","250x200","500x150","300x200","600x150","250x250","400x200","300x250","500x200","300x300","600x200","400x250","800x200","500x250","400x300","600x250","500x300","800x250","400x400","600x300","1000x250","800x300","500x400","1000x300","600x400","500x500","800x400","600x500","1000x400","600x600","800x500","1000x500","800x600","1000x600","800x800","1000x800","1000x1000",null,null,null,null,null,"400x250",0.308,"400x250"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S34=0,S34=\"\",J30=0,J30=\"\"),\"\",IF(S34=\"OUT\",\"OUT\",S34+J30))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Diamètre hydraulique","mm",{"$f":"X14","v":0.13300000000000001},{"$f":"Y14","v":0.14299999999999999},{"$f":"Z14","v":0.15},0.16,0.17100000000000001,0.188,0.2,0.2,0.218,0.222,0.23100000000000001,0.24,0.24,0.25,0.26700000000000002,0.27300000000000002,0.28599999999999998,0.3,0.3,0.308,0.32,0.33300000000000002,0.34300000000000003,0.35299999999999998,0.375,0.38100000000000001,0.4,0.4,0.4,0.436,0.44400000000000001,0.46200000000000002,0.48,0.5,0.53300000000000003,0.54500000000000004,0.57099999999999995,0.6,0.61499999999999999,0.66700000000000004,0.68600000000000005,0.75,0.8,0.88900000000000001,1,null,null,null,null,null,"800x200",0.32,"800x200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Section","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500x250",0.33300000000000002,"500x250"]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:BP45,15,FALSE))","v":""},null,null,"Vitesse réelle","m/s",{"$f":"X46","v":0},{"$f":"Y46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"400x300",0.34300000000000003,"400x300"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X34*X32/$X$9","v":0},{"$f":"Y34*Y32/$X$9","v":0},{"$f":"Z34*Z32/$X$9","v":0},{"$f":"AA34*AA32/$X$9","v":0},{"$f":"AB34*AB32/$X$9","v":0},{"$f":"AC34*AC32/$X$9","v":0},{"$f":"AD34*AD32/$X$9","v":0},{"$f":"AE34*AE32/$X$9","v":0},{"$f":"AF34*AF32/$X$9","v":0},{"$f":"AG34*AG32/$X$9","v":0},{"$f":"AH34*AH32/$X$9","v":0},{"$f":"AI34*AI32/$X$9","v":0},{"$f":"AJ34*AJ32/$X$9","v":0},{"$f":"AK34*AK32/$X$9","v":0},{"$f":"AL34*AL32/$X$9","v":0},{"$f":"AM34*AM32/$X$9","v":0},{"$f":"AN34*AN32/$X$9","v":0},{"$f":"AO34*AO32/$X$9","v":0},{"$f":"AP34*AP32/$X$9","v":0},{"$f":"AQ34*AQ32/$X$9","v":0},{"$f":"AR34*AR32/$X$9","v":0},{"$f":"AS34*AS32/$X$9","v":0},{"$f":"AT34*AT32/$X$9","v":0},{"$f":"AU34*AU32/$X$9","v":0},{"$f":"AV34*AV32/$X$9","v":0},{"$f":"AW34*AW32/$X$9","v":0},{"$f":"AX34*AX32/$X$9","v":0},{"$f":"AY34*AY32/$X$9","v":0},{"$f":"AZ34*AZ32/$X$9","v":0},{"$f":"BA34*BA32/$X$9","v":0},{"$f":"BB34*BB32/$X$9","v":0},{"$f":"BC34*BC32/$X$9","v":0},{"$f":"BD34*BD32/$X$9","v":0},{"$f":"BE34*BE32/$X$9","v":0},{"$f":"BF34*BF32/$X$9","v":0},{"$f":"BG34*BG32/$X$9","v":0},{"$f":"BH34*BH32/$X$9","v":0},{"$f":"BI34*BI32/$X$9","v":0},{"$f":"BJ34*BJ32/$X$9","v":0},{"$f":"BK34*BK32/$X$9","v":0},{"$f":"BL34*BL32/$X$9","v":0},{"$f":"BM34*BM32/$X$9","v":0},{"$f":"BN34*BN32/$X$9","v":0},{"$f":"BO34*BO32/$X$9","v":0},{"$f":"BP34*BP32/$X$9","v":0},null,null,null,null,null,"600x250",0.35299999999999998,"600x250"]
[null,{"$f":"Langage!A$38","v":"Evacuation d’air"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient de frottement","-",{"$f":"IF(X35<3300,\"OUT\",0.25/(LOG($X$10/X32/3.7+5.74/X35^0.9))^2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",0.25/(LOG($X$10/Y32/3.7+5.74/Y35^0.9))^2)","v":"OUT"},{"$f":"IF(Z35<3300,\"OUT\",0.25/(LOG($X$10/Z32/3.7+5.74/Z35^0.9))^2)","v":"OUT"},{"$f":"IF(AA35<3300,\"OUT\",0.25/(LOG($X$10/AA32/3.7+5.74/AA35^0.9))^2)","v":"OUT"},{"$f":"IF(AB35<3300,\"OUT\",0.25/(LOG($X$10/AB32/3.7+5.74/AB35^0.9))^2)","v":"OUT"},{"$f":"IF(AC35<3300,\"OUT\",0.25/(LOG($X$10/AC32/3.7+5.74/AC35^0.9))^2)","v":"OUT"},{"$f":"IF(AD35<3300,\"OUT\",0.25/(LOG($X$10/AD32/3.7+5.74/AD35^0.9))^2)","v":"OUT"},{"$f":"IF(AE35<3300,\"OUT\",0.25/(LOG($X$10/AE32/3.7+5.74/AE35^0.9))^2)","v":"OUT"},{"$f":"IF(AF35<3300,\"OUT\",0.25/(LOG($X$10/AF32/3.7+5.74/AF35^0.9))^2)","v":"OUT"},{"$f":"IF(AG35<3300,\"OUT\",0.25/(LOG($X$10/AG32/3.7+5.74/AG35^0.9))^2)","v":"OUT"},{"$f":"IF(AH35<3300,\"OUT\",0.25/(LOG($X$10/AH32/3.7+5.74/AH35^0.9))^2)","v":"OUT"},{"$f":"IF(AI35<3300,\"OUT\",0.25/(LOG($X$10/AI32/3.7+5.74/AI35^0.9))^2)","v":"OUT"},{"$f":"IF(AJ35<3300,\"OUT\",0.25/(LOG($X$10/AJ32/3.7+5.74/AJ35^0.9))^2)","v":"OUT"},{"$f":"IF(AK35<3300,\"OUT\",0.25/(LOG($X$10/AK32/3.7+5.74/AK35^0.9))^2)","v":"OUT"},{"$f":"IF(AL35<3300,\"OUT\",0.25/(LOG($X$10/AL32/3.7+5.74/AL35^0.9))^2)","v":"OUT"},{"$f":"IF(AM35<3300,\"OUT\",0.25/(LOG($X$10/AM32/3.7+5.74/AM35^0.9))^2)","v":"OUT"},{"$f":"IF(AN35<3300,\"OUT\",0.25/(LOG($X$10/AN32/3.7+5.74/AN35^0.9))^2)","v":"OUT"},{"$f":"IF(AO35<3300,\"OUT\",0.25/(LOG($X$10/AO32/3.7+5.74/AO35^0.9))^2)","v":"OUT"},{"$f":"IF(AP35<3300,\"OUT\",0.25/(LOG($X$10/AP32/3.7+5.74/AP35^0.9))^2)","v":"OUT"},{"$f":"IF(AQ35<3300,\"OUT\",0.25/(LOG($X$10/AQ32/3.7+5.74/AQ35^0.9))^2)","v":"OUT"},{"$f":"IF(AR35<3300,\"OUT\",0.25/(LOG($X$10/AR32/3.7+5.74/AR35^0.9))^2)","v":"OUT"},{"$f":"IF(AS35<3300,\"OUT\",0.25/(LOG($X$10/AS32/3.7+5.74/AS35^0.9))^2)","v":"OUT"},{"$f":"IF(AT35<3300,\"OUT\",0.25/(LOG($X$10/AT32/3.7+5.74/AT35^0.9))^2)","v":"OUT"},{"$f":"IF(AU35<3300,\"OUT\",0.25/(LOG($X$10/AU32/3.7+5.74/AU35^0.9))^2)","v":"OUT"},{"$f":"IF(AV35<3300,\"OUT\",0.25/(LOG($X$10/AV32/3.7+5.74/AV35^0.9))^2)","v":"OUT"},{"$f":"IF(AW35<3300,\"OUT\",0.25/(LOG($X$10/AW32/3.7+5.74/AW35^0.9))^2)","v":"OUT"},{"$f":"IF(AX35<3300,\"OUT\",0.25/(LOG($X$10/AX32/3.7+5.74/AX35^0.9))^2)","v":"OUT"},{"$f":"IF(AY35<3300,\"OUT\",0.25/(LOG($X$10/AY32/3.7+5.74/AY35^0.9))^2)","v":"OUT"},{"$f":"IF(AZ35<3300,\"OUT\",0.25/(LOG($X$10/AZ32/3.7+5.74/AZ35^0.9))^2)","v":"OUT"},{"$f":"IF(BA35<3300,\"OUT\",0.25/(LOG($X$10/BA32/3.7+5.74/BA35^0.9))^2)","v":"OUT"},{"$f":"IF(BB35<3300,\"OUT\",0.25/(LOG($X$10/BB32/3.7+5.74/BB35^0.9))^2)","v":"OUT"},{"$f":"IF(BC35<3300,\"OUT\",0.25/(LOG($X$10/BC32/3.7+5.74/BC35^0.9))^2)","v":"OUT"},{"$f":"IF(BD35<3300,\"OUT\",0.25/(LOG($X$10/BD32/3.7+5.74/BD35^0.9))^2)","v":"OUT"},{"$f":"IF(BE35<3300,\"OUT\",0.25/(LOG($X$10/BE32/3.7+5.74/BE35^0.9))^2)","v":"OUT"},{"$f":"IF(BF35<3300,\"OUT\",0.25/(LOG($X$10/BF32/3.7+5.74/BF35^0.9))^2)","v":"OUT"},{"$f":"IF(BG35<3300,\"OUT\",0.25/(LOG($X$10/BG32/3.7+5.74/BG35^0.9))^2)","v":"OUT"},{"$f":"IF(BH35<3300,\"OUT\",0.25/(LOG($X$10/BH32/3.7+5.74/BH35^0.9))^2)","v":"OUT"},{"$f":"IF(BI35<3300,\"OUT\",0.25/(LOG($X$10/BI32/3.7+5.74/BI35^0.9))^2)","v":"OUT"},{"$f":"IF(BJ35<3300,\"OUT\",0.25/(LOG($X$10/BJ32/3.7+5.74/BJ35^0.9))^2)","v":"OUT"},{"$f":"IF(BK35<3300,\"OUT\",0.25/(LOG($X$10/BK32/3.7+5.74/BK35^0.9))^2)","v":"OUT"},{"$f":"IF(BL35<3300,\"OUT\",0.25/(LOG($X$10/BL32/3.7+5.74/BL35^0.9))^2)","v":"OUT"},{"$f":"IF(BM35<3300,\"OUT\",0.25/(LOG($X$10/BM32/3.7+5.74/BM35^0.9))^2)","v":"OUT"},{"$f":"IF(BN35<3300,\"OUT\",0.25/(LOG($X$10/BN32/3.7+5.74/BN35^0.9))^2)","v":"OUT"},{"$f":"IF(BO35<3300,\"OUT\",0.25/(LOG($X$10/BO32/3.7+5.74/BO35^0.9))^2)","v":"OUT"},{"$f":"IF(BP35<3300,\"OUT\",0.25/(LOG($X$10/BP32/3.7+5.74/BP35^0.9))^2)","v":"OUT"},null,null,null,null,null,"500x300",0.375,"500x300"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X36=\"OUT\",\"OUT\",X36/X32*$X$8/2*X34^2)","v":"OUT"},{"$f":"IF(Y36=\"OUT\",\"OUT\",Y36/Y32*$X$8/2*Y34^2)","v":"OUT"},{"$f":"IF(Z36=\"OUT\",\"OUT\",Z36/Z32*$X$8/2*Z34^2)","v":"OUT"},{"$f":"IF(AA36=\"OUT\",\"OUT\",AA36/AA32*$X$8/2*AA34^2)","v":"OUT"},{"$f":"IF(AB36=\"OUT\",\"OUT\",AB36/AB32*$X$8/2*AB34^2)","v":"OUT"},{"$f":"IF(AC36=\"OUT\",\"OUT\",AC36/AC32*$X$8/2*AC34^2)","v":"OUT"},{"$f":"IF(AD36=\"OUT\",\"OUT\",AD36/AD32*$X$8/2*AD34^2)","v":"OUT"},{"$f":"IF(AE36=\"OUT\",\"OUT\",AE36/AE32*$X$8/2*AE34^2)","v":"OUT"},{"$f":"IF(AF36=\"OUT\",\"OUT\",AF36/AF32*$X$8/2*AF34^2)","v":"OUT"},{"$f":"IF(AG36=\"OUT\",\"OUT\",AG36/AG32*$X$8/2*AG34^2)","v":"OUT"},{"$f":"IF(AH36=\"OUT\",\"OUT\",AH36/AH32*$X$8/2*AH34^2)","v":"OUT"},{"$f":"IF(AI36=\"OUT\",\"OUT\",AI36/AI32*$X$8/2*AI34^2)","v":"OUT"},{"$f":"IF(AJ36=\"OUT\",\"OUT\",AJ36/AJ32*$X$8/2*AJ34^2)","v":"OUT"},{"$f":"IF(AK36=\"OUT\",\"OUT\",AK36/AK32*$X$8/2*AK34^2)","v":"OUT"},{"$f":"IF(AL36=\"OUT\",\"OUT\",AL36/AL32*$X$8/2*AL34^2)","v":"OUT"},{"$f":"IF(AM36=\"OUT\",\"OUT\",AM36/AM32*$X$8/2*AM34^2)","v":"OUT"},{"$f":"IF(AN36=\"OUT\",\"OUT\",AN36/AN32*$X$8/2*AN34^2)","v":"OUT"},{"$f":"IF(AO36=\"OUT\",\"OUT\",AO36/AO32*$X$8/2*AO34^2)","v":"OUT"},{"$f":"IF(AP36=\"OUT\",\"OUT\",AP36/AP32*$X$8/2*AP34^2)","v":"OUT"},{"$f":"IF(AQ36=\"OUT\",\"OUT\",AQ36/AQ32*$X$8/2*AQ34^2)","v":"OUT"},{"$f":"IF(AR36=\"OUT\",\"OUT\",AR36/AR32*$X$8/2*AR34^2)","v":"OUT"},{"$f":"IF(AS36=\"OUT\",\"OUT\",AS36/AS32*$X$8/2*AS34^2)","v":"OUT"},{"$f":"IF(AT36=\"OUT\",\"OUT\",AT36/AT32*$X$8/2*AT34^2)","v":"OUT"},{"$f":"IF(AU36=\"OUT\",\"OUT\",AU36/AU32*$X$8/2*AU34^2)","v":"OUT"},{"$f":"IF(AV36=\"OUT\",\"OUT\",AV36/AV32*$X$8/2*AV34^2)","v":"OUT"},{"$f":"IF(AW36=\"OUT\",\"OUT\",AW36/AW32*$X$8/2*AW34^2)","v":"OUT"},{"$f":"IF(AX36=\"OUT\",\"OUT\",AX36/AX32*$X$8/2*AX34^2)","v":"OUT"},{"$f":"IF(AY36=\"OUT\",\"OUT\",AY36/AY32*$X$8/2*AY34^2)","v":"OUT"},{"$f":"IF(AZ36=\"OUT\",\"OUT\",AZ36/AZ32*$X$8/2*AZ34^2)","v":"OUT"},{"$f":"IF(BA36=\"OUT\",\"OUT\",BA36/BA32*$X$8/2*BA34^2)","v":"OUT"},{"$f":"IF(BB36=\"OUT\",\"OUT\",BB36/BB32*$X$8/2*BB34^2)","v":"OUT"},{"$f":"IF(BC36=\"OUT\",\"OUT\",BC36/BC32*$X$8/2*BC34^2)","v":"OUT"},{"$f":"IF(BD36=\"OUT\",\"OUT\",BD36/BD32*$X$8/2*BD34^2)","v":"OUT"},{"$f":"IF(BE36=\"OUT\",\"OUT\",BE36/BE32*$X$8/2*BE34^2)","v":"OUT"},{"$f":"IF(BF36=\"OUT\",\"OUT\",BF36/BF32*$X$8/2*BF34^2)","v":"OUT"},{"$f":"IF(BG36=\"OUT\",\"OUT\",BG36/BG32*$X$8/2*BG34^2)","v":"OUT"},{"$f":"IF(BH36=\"OUT\",\"OUT\",BH36/BH32*$X$8/2*BH34^2)","v":"OUT"},{"$f":"IF(BI36=\"OUT\",\"OUT\",BI36/BI32*$X$8/2*BI34^2)","v":"OUT"},{"$f":"IF(BJ36=\"OUT\",\"OUT\",BJ36/BJ32*$X$8/2*BJ34^2)","v":"OUT"},{"$f":"IF(BK36=\"OUT\",\"OUT\",BK36/BK32*$X$8/2*BK34^2)","v":"OUT"},{"$f":"IF(BL36=\"OUT\",\"OUT\",BL36/BL32*$X$8/2*BL34^2)","v":"OUT"},{"$f":"IF(BM36=\"OUT\",\"OUT\",BM36/BM32*$X$8/2*BM34^2)","v":"OUT"},{"$f":"IF(BN36=\"OUT\",\"OUT\",BN36/BN32*$X$8/2*BN34^2)","v":"OUT"},{"$f":"IF(BO36=\"OUT\",\"OUT\",BO36/BO32*$X$8/2*BO34^2)","v":"OUT"},{"$f":"IF(BP36=\"OUT\",\"OUT\",BP36/BP32*$X$8/2*BP34^2)","v":"OUT"},null,null,null,null,null,"800x250",0.38100000000000001,"800x250"]
[null,null,{"$f":"Langage!A$43","v":"Débit"},{"$f":"Langage!A$69","v":"Longueur droite"},{"$f":"Langage!A$70","v":"Coude 90°"},{"$f":"Langage!A$71","v":"Coude 45°"},{"$f":"Langage!A$88","v":"Dimensions"},{"$f":"Langage!A$73","v":"Options"},{"$f":"Langage!A$94","v":"Minimum"},{"$f":"Langage!A$72","v":"Perte de pression"},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X37=\"OUT\",\"OUT\",X37*$D25)","v":"OUT"},{"$f":"IF(Y37=\"OUT\",\"OUT\",Y37*$D25)","v":"OUT"},{"$f":"IF(Z37=\"OUT\",\"OUT\",Z37*$D25)","v":"OUT"},{"$f":"IF(AA37=\"OUT\",\"OUT\",AA37*$D25)","v":"OUT"},{"$f":"IF(AB37=\"OUT\",\"OUT\",AB37*$D25)","v":"OUT"},{"$f":"IF(AC37=\"OUT\",\"OUT\",AC37*$D25)","v":"OUT"},{"$f":"IF(AD37=\"OUT\",\"OUT\",AD37*$D25)","v":"OUT"},{"$f":"IF(AE37=\"OUT\",\"OUT\",AE37*$D25)","v":"OUT"},{"$f":"IF(AF37=\"OUT\",\"OUT\",AF37*$D25)","v":"OUT"},{"$f":"IF(AG37=\"OUT\",\"OUT\",AG37*$D25)","v":"OUT"},{"$f":"IF(AH37=\"OUT\",\"OUT\",AH37*$D25)","v":"OUT"},{"$f":"IF(AI37=\"OUT\",\"OUT\",AI37*$D25)","v":"OUT"},{"$f":"IF(AJ37=\"OUT\",\"OUT\",AJ37*$D25)","v":"OUT"},{"$f":"IF(AK37=\"OUT\",\"OUT\",AK37*$D25)","v":"OUT"},{"$f":"IF(AL37=\"OUT\",\"OUT\",AL37*$D25)","v":"OUT"},{"$f":"IF(AM37=\"OUT\",\"OUT\",AM37*$D25)","v":"OUT"},{"$f":"IF(AN37=\"OUT\",\"OUT\",AN37*$D25)","v":"OUT"},{"$f":"IF(AO37=\"OUT\",\"OUT\",AO37*$D25)","v":"OUT"},{"$f":"IF(AP37=\"OUT\",\"OUT\",AP37*$D25)","v":"OUT"},{"$f":"IF(AQ37=\"OUT\",\"OUT\",AQ37*$D25)","v":"OUT"},{"$f":"IF(AR37=\"OUT\",\"OUT\",AR37*$D25)","v":"OUT"},{"$f":"IF(AS37=\"OUT\",\"OUT\",AS37*$D25)","v":"OUT"},{"$f":"IF(AT37=\"OUT\",\"OUT\",AT37*$D25)","v":"OUT"},{"$f":"IF(AU37=\"OUT\",\"OUT\",AU37*$D25)","v":"OUT"},{"$f":"IF(AV37=\"OUT\",\"OUT\",AV37*$D25)","v":"OUT"},{"$f":"IF(AW37=\"OUT\",\"OUT\",AW37*$D25)","v":"OUT"},{"$f":"IF(AX37=\"OUT\",\"OUT\",AX37*$D25)","v":"OUT"},{"$f":"IF(AY37=\"OUT\",\"OUT\",AY37*$D25)","v":"OUT"},{"$f":"IF(AZ37=\"OUT\",\"OUT\",AZ37*$D25)","v":"OUT"},{"$f":"IF(BA37=\"OUT\",\"OUT\",BA37*$D25)","v":"OUT"},{"$f":"IF(BB37=\"OUT\",\"OUT\",BB37*$D25)","v":"OUT"},{"$f":"IF(BC37=\"OUT\",\"OUT\",BC37*$D25)","v":"OUT"},{"$f":"IF(BD37=\"OUT\",\"OUT\",BD37*$D25)","v":"OUT"},{"$f":"IF(BE37=\"OUT\",\"OUT\",BE37*$D25)","v":"OUT"},{"$f":"IF(BF37=\"OUT\",\"OUT\",BF37*$D25)","v":"OUT"},{"$f":"IF(BG37=\"OUT\",\"OUT\",BG37*$D25)","v":"OUT"},{"$f":"IF(BH37=\"OUT\",\"OUT\",BH37*$D25)","v":"OUT"},{"$f":"IF(BI37=\"OUT\",\"OUT\",BI37*$D25)","v":"OUT"},{"$f":"IF(BJ37=\"OUT\",\"OUT\",BJ37*$D25)","v":"OUT"},{"$f":"IF(BK37=\"OUT\",\"OUT\",BK37*$D25)","v":"OUT"},{"$f":"IF(BL37=\"OUT\",\"OUT\",BL37*$D25)","v":"OUT"},{"$f":"IF(BM37=\"OUT\",\"OUT\",BM37*$D25)","v":"OUT"},{"$f":"IF(BN37=\"OUT\",\"OUT\",BN37*$D25)","v":"OUT"},{"$f":"IF(BO37=\"OUT\",\"OUT\",BO37*$D25)","v":"OUT"},{"$f":"IF(BP37=\"OUT\",\"OUT\",BP37*$D25)","v":"OUT"},null,null,null,null,null,"400x400",0.4,"400x400"]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null," ",null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",{"$f":"X21","v":0.25},{"$f":"Y21","v":0.26},{"$f":"Z21","v":0.26},0.27,0.23,0.23,0.21,0.25,0.26,0.23,0.27,0.24,0.27,0.21,0.25,0.22,0.26,0.21,0.26,0.24,0.27,0.25,0.23,0.26,0.24,0.27,0.21,0.25,0.27,0.26,0.23,0.27,0.24,0.21,0.25,0.22,0.26,0.21,0.24,0.25,0.23,0.24,0.21,0.23,0.21,null,null,null,null,null,"600x300",0.4,"600x300"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C40=\"\",\"\",HLOOKUP(\"OK\",X48:BP63,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(\"OK\",X48:BP63,16,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",$E25*X39*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",$E25*Y39*$X$8*Y34^2/2)","v":"OUT"},{"$f":"IF(Z35<3300,\"OUT\",$E25*Z39*$X$8*Z34^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",null,null,null,null,null,"1000x250",0.4,"1000x250"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C40=\"\",\"\",VLOOKUP(T42,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(I41,X49:BP63,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",{"$f":"0.6*X39","v":0.15},{"$f":"0.6*Y39","v":0.156},{"$f":"0.6*Z39","v":0.156},0.16200000000000001,0.13800000000000001,0.13800000000000001,0.126,0.15,0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.16200000000000001,0.126,0.15,0.13200000000000001,0.156,0.126,0.156,0.14399999999999999,0.16200000000000001,0.15,0.13800000000000001,0.156,0.14399999999999999,0.16200000000000001,0.126,0.15,0.16200000000000001,0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.126,0.15,0.13200000000000001,0.156,0.126,0.14399999999999999,0.15,0.13800000000000001,0.14399999999999999,0.126,0.13800000000000001,0.126,null,null,null,null,null,"800x300",0.436,"800x300"]
[null,null,{"$f":"Langage!A$76","v":"Bouche de rejet d'air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,2,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,4,FALSE))","v":""},null,null,{"$f":"IF(C40=\"\",\"\",VLOOKUP(U42,BW$12:BX$56,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(I42,X49:BP63,15,FALSE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(I40=\"\",\"\",HLOOKUP(I40,X49:BP50,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",MIN(IF(X50:BP50>S42,X50:BP50)))","v":""},{"$f":"IF(T42=0,0,IF(C40=\"\",\"\",MIN(IF(X50:BP50>T42,X50:BP50))))","v":""},"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",$F25*X41*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",$F25*Y41*$X$8*Y34^2/2)","v":"OUT"},{"$f":"IF(Z35<3300,\"OUT\",$F25*Z41*$X$8*Z34^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",null,null,null,null,null,"500x400",0.44400000000000001,"500x400"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse",null,"Sortie libre du conduit","-",{"$f":"X25","v":1},{"$f":"Y25","v":1},{"$f":"Z25","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,"1000x300",0.46200000000000002,"1000x300"]
[null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,3,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S49=0,S49=\"\"),\"\",IF(S49=\"OUT\",\"OUT\",S49))","v":""},null,null,null,"Kout",{"$f":"Langage!A$78","v":"Facteur K (extraction)"},"-"," "," ",{"$f":"IF(D45<>N44,\"\",E45*$X$8*T44^2/2)","v":""},{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:BP64,16,FALSE))","v":""},null,"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",X43*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",Y43*$X$8*Y34^2/2)","v":"OUT"},{"$f":"IF(Z35<3300,\"OUT\",Z43*$X$8*Z34^2/2)","v":"OUT"},{"$f":"IF(AA35<3300,\"OUT\",AA43*$X$8*AA34^2/2)","v":"OUT"},{"$f":"IF(AB35<3300,\"OUT\",AB43*$X$8*AB34^2/2)","v":"OUT"},{"$f":"IF(AC35<3300,\"OUT\",AC43*$X$8*AC34^2/2)","v":"OUT"},{"$f":"IF(AD35<3300,\"OUT\",AD43*$X$8*AD34^2/2)","v":"OUT"},{"$f":"IF(AE35<3300,\"OUT\",AE43*$X$8*AE34^2/2)","v":"OUT"},{"$f":"IF(AF35<3300,\"OUT\",AF43*$X$8*AF34^2/2)","v":"OUT"},{"$f":"IF(AG35<3300,\"OUT\",AG43*$X$8*AG34^2/2)","v":"OUT"},{"$f":"IF(AH35<3300,\"OUT\",AH43*$X$8*AH34^2/2)","v":"OUT"},{"$f":"IF(AI35<3300,\"OUT\",AI43*$X$8*AI34^2/2)","v":"OUT"},{"$f":"IF(AJ35<3300,\"OUT\",AJ43*$X$8*AJ34^2/2)","v":"OUT"},{"$f":"IF(AK35<3300,\"OUT\",AK43*$X$8*AK34^2/2)","v":"OUT"},{"$f":"IF(AL35<3300,\"OUT\",AL43*$X$8*AL34^2/2)","v":"OUT"},{"$f":"IF(AM35<3300,\"OUT\",AM43*$X$8*AM34^2/2)","v":"OUT"},{"$f":"IF(AN35<3300,\"OUT\",AN43*$X$8*AN34^2/2)","v":"OUT"},{"$f":"IF(AO35<3300,\"OUT\",AO43*$X$8*AO34^2/2)","v":"OUT"},{"$f":"IF(AP35<3300,\"OUT\",AP43*$X$8*AP34^2/2)","v":"OUT"},{"$f":"IF(AQ35<3300,\"OUT\",AQ43*$X$8*AQ34^2/2)","v":"OUT"},{"$f":"IF(AR35<3300,\"OUT\",AR43*$X$8*AR34^2/2)","v":"OUT"},{"$f":"IF(AS35<3300,\"OUT\",AS43*$X$8*AS34^2/2)","v":"OUT"},{"$f":"IF(AT35<3300,\"OUT\",AT43*$X$8*AT34^2/2)","v":"OUT"},{"$f":"IF(AU35<3300,\"OUT\",AU43*$X$8*AU34^2/2)","v":"OUT"},{"$f":"IF(AV35<3300,\"OUT\",AV43*$X$8*AV34^2/2)","v":"OUT"},{"$f":"IF(AW35<3300,\"OUT\",AW43*$X$8*AW34^2/2)","v":"OUT"},{"$f":"IF(AX35<3300,\"OUT\",AX43*$X$8*AX34^2/2)","v":"OUT"},{"$f":"IF(AY35<3300,\"OUT\",AY43*$X$8*AY34^2/2)","v":"OUT"},{"$f":"IF(AZ35<3300,\"OUT\",AZ43*$X$8*AZ34^2/2)","v":"OUT"},{"$f":"IF(BA35<3300,\"OUT\",BA43*$X$8*BA34^2/2)","v":"OUT"},{"$f":"IF(BB35<3300,\"OUT\",BB43*$X$8*BB34^2/2)","v":"OUT"},{"$f":"IF(BC35<3300,\"OUT\",BC43*$X$8*BC34^2/2)","v":"OUT"},{"$f":"IF(BD35<3300,\"OUT\",BD43*$X$8*BD34^2/2)","v":"OUT"},{"$f":"IF(BE35<3300,\"OUT\",BE43*$X$8*BE34^2/2)","v":"OUT"},{"$f":"IF(BF35<3300,\"OUT\",BF43*$X$8*BF34^2/2)","v":"OUT"},{"$f":"IF(BG35<3300,\"OUT\",BG43*$X$8*BG34^2/2)","v":"OUT"},{"$f":"IF(BH35<3300,\"OUT\",BH43*$X$8*BH34^2/2)","v":"OUT"},{"$f":"IF(BI35<3300,\"OUT\",BI43*$X$8*BI34^2/2)","v":"OUT"},{"$f":"IF(BJ35<3300,\"OUT\",BJ43*$X$8*BJ34^2/2)","v":"OUT"},{"$f":"IF(BK35<3300,\"OUT\",BK43*$X$8*BK34^2/2)","v":"OUT"},{"$f":"IF(BL35<3300,\"OUT\",BL43*$X$8*BL34^2/2)","v":"OUT"},{"$f":"IF(BM35<3300,\"OUT\",BM43*$X$8*BM34^2/2)","v":"OUT"},{"$f":"IF(BN35<3300,\"OUT\",BN43*$X$8*BN34^2/2)","v":"OUT"},{"$f":"IF(BO35<3300,\"OUT\",BO43*$X$8*BO34^2/2)","v":"OUT"},{"$f":"IF(BP35<3300,\"OUT\",BP43*$X$8*BP34^2/2)","v":"OUT"},null,null,null,null,null,"600x400",0.48,"600x400"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D45<>N45,\"\",(C40/F45)^2*E45)","v":""},null,null,"Perte de pression partielle","Pa",{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(X35<3300,\"OUT\",X38+X40+X42+X44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(Y35<3300,\"OUT\",Y38+Y40+Y42+Y44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(Z35<3300,\"OUT\",Z38+Z40+Z42+Z44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AA35<3300,\"OUT\",AA38+AA40+AA42+AA44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AB35<3300,\"OUT\",AB38+AB40+AB42+AB44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AC35<3300,\"OUT\",AC38+AC40+AC42+AC44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AD35<3300,\"OUT\",AD38+AD40+AD42+AD44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AE35<3300,\"OUT\",AE38+AE40+AE42+AE44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AF35<3300,\"OUT\",AF38+AF40+AF42+AF44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AG35<3300,\"OUT\",AG38+AG40+AG42+AG44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AH35<3300,\"OUT\",AH38+AH40+AH42+AH44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AI35<3300,\"OUT\",AI38+AI40+AI42+AI44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AJ35<3300,\"OUT\",AJ38+AJ40+AJ42+AJ44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AK35<3300,\"OUT\",AK38+AK40+AK42+AK44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AL35<3300,\"OUT\",AL38+AL40+AL42+AL44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AM35<3300,\"OUT\",AM38+AM40+AM42+AM44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AN35<3300,\"OUT\",AN38+AN40+AN42+AN44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AO35<3300,\"OUT\",AO38+AO40+AO42+AO44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AP35<3300,\"OUT\",AP38+AP40+AP42+AP44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AQ35<3300,\"OUT\",AQ38+AQ40+AQ42+AQ44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AR35<3300,\"OUT\",AR38+AR40+AR42+AR44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AS35<3300,\"OUT\",AS38+AS40+AS42+AS44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AT35<3300,\"OUT\",AT38+AT40+AT42+AT44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AU35<3300,\"OUT\",AU38+AU40+AU42+AU44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AV35<3300,\"OUT\",AV38+AV40+AV42+AV44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AW35<3300,\"OUT\",AW38+AW40+AW42+AW44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AX35<3300,\"OUT\",AX38+AX40+AX42+AX44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AY35<3300,\"OUT\",AY38+AY40+AY42+AY44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(AZ35<3300,\"OUT\",AZ38+AZ40+AZ42+AZ44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BA35<3300,\"OUT\",BA38+BA40+BA42+BA44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BB35<3300,\"OUT\",BB38+BB40+BB42+BB44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BC35<3300,\"OUT\",BC38+BC40+BC42+BC44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BD35<3300,\"OUT\",BD38+BD40+BD42+BD44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BE35<3300,\"OUT\",BE38+BE40+BE42+BE44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BF35<3300,\"OUT\",BF38+BF40+BF42+BF44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BG35<3300,\"OUT\",BG38+BG40+BG42+BG44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BH35<3300,\"OUT\",BH38+BH40+BH42+BH44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BI35<3300,\"OUT\",BI38+BI40+BI42+BI44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BJ35<3300,\"OUT\",BJ38+BJ40+BJ42+BJ44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BK35<3300,\"OUT\",BK38+BK40+BK42+BK44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BL35<3300,\"OUT\",BL38+BL40+BL42+BL44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BM35<3300,\"OUT\",BM38+BM40+BM42+BM44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BN35<3300,\"OUT\",BN38+BN40+BN42+BN44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BO35<3300,\"OUT\",BO38+BO40+BO42+BO44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(BP35<3300,\"OUT\",BP38+BP40+BP42+BP44))","v":0},null,null,null,null,null,"500x500",0.5,"500x500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",{"$f":"Langage!A$81","v":"Coefficient de perte de décharge"},"-"," "," ",{"$f":"IF(D45<>N46,\"\",1/E45^2*$X$8*T44^2/2)","v":""},{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:BP64,16,FALSE))","v":""},null,"Vitesse réelle","m/s",{"$f":"$C25/(0.2*0.1)/3600","v":0},{"$f":"$C25/(0.25*0.1)/3600","v":0},{"$f":"$C25/(0.3*0.1)/3600","v":0},{"$f":"$C25/(0.4*0.1)/3600","v":0},{"$f":"$C25/(0.2*0.15)/3600","v":0},{"$f":"$C25/(0.25*0.15)/3600","v":0},{"$f":"$C25/(0.2*0.2)/3600","v":0},{"$f":"$C25/(0.3*0.15)/3600","v":0},{"$f":"$C25/(0.4*0.15)/3600","v":0},{"$f":"$C25/(0.25*0.2)/3600","v":0},{"$f":"$C25/(0.5*0.15)/3600","v":0},{"$f":"$C25/(0.3*0.2)/3600","v":0},{"$f":"$C25/(0.6*0.15)/3600","v":0},{"$f":"$C25/(0.25*0.25)/3600","v":0},{"$f":"$C25/(0.4*0.2)/3600","v":0},{"$f":"$C25/(0.3*0.25)/3600","v":0},{"$f":"$C25/(0.5*0.2)/3600","v":0},{"$f":"$C25/(0.3*0.3)/3600","v":0},{"$f":"$C25/(0.6*0.2)/3600","v":0},{"$f":"$C25/(0.4*0.25)/3600","v":0},{"$f":"$C25/(0.8*0.2)/3600","v":0},{"$f":"$C25/(0.5*0.25)/3600","v":0},{"$f":"$C25/(0.4*0.3)/3600","v":0},{"$f":"$C25/(0.6*0.25)/3600","v":0},{"$f":"$C25/(0.5*0.3)/3600","v":0},{"$f":"$C25/(0.8*0.25)/3600","v":0},{"$f":"$C25/(0.4*0.4)/3600","v":0},{"$f":"$C25/(0.6*0.3)/3600","v":0},{"$f":"$C25/(1*0.25)/3600","v":0},{"$f":"$C25/(0.8*0.3)/3600","v":0},{"$f":"$C25/(0.5*0.4)/3600","v":0},{"$f":"$C25/(1*0.3)/3600","v":0},{"$f":"$C25/(0.6*0.4)/3600","v":0},{"$f":"$C25/(0.5*0.5)/3600","v":0},{"$f":"$C25/(0.8*0.4)/3600","v":0},{"$f":"$C25/(0.6*0.5)/3600","v":0},{"$f":"$C25/(1*0.4)/3600","v":0},{"$f":"$C25/(0.6*0.6)/3600","v":0},{"$f":"$C25/(0.8*0.5)/3600","v":0},{"$f":"$C25/(1*0.5)/3600","v":0},{"$f":"$C25/(0.8*0.6)/3600","v":0},{"$f":"$C25/(1*0.6)/3600","v":0},{"$f":"$C25/(0.8*0.8)/3600","v":0},{"$f":"$C25/(1*0.8)/3600","v":0},{"$f":"$C25/(1*1)/3600","v":0},null,null,null,null,null,"800x400",0.53300000000000003,"800x400"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S49=0,S49=\"\",J45=0,J45=\"\"),\"\",IF(S49=\"OUT\",\"OUT\",S49+J45))","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"600x500",0.54500000000000004,"600x500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Evacuation d'air",null,{"$f":"IF(OR(X63=\"OUT\",X63>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y63=\"OUT\",Y63>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Z63=\"OUT\",Z63>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK",null,null,null,null,null,"1000x400",0.57099999999999995,"1000x400"]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:BP63,15,FALSE))","v":""},null,null,"Dimensions possibles","mm",{"$f":"X13","v":"200x100"},{"$f":"Y13","v":"250x100"},{"$f":"Z13","v":"300x100"},"400x100","200x150","250x150","200x200","300x150","400x150","250x200","500x150","300x200","600x150","250x250","400x200","300x250","500x200","300x300","600x200","400x250","800x200","500x250","400x300","600x250","500x300","800x250","400x400","600x300","1000x250","800x300","500x400","1000x300","600x400","500x500","800x400","600x500","1000x400","600x600","800x500","1000x500","800x600","1000x600","800x800","1000x800","1000x1000",null,null,null,null,null,"600x600",0.6,"600x600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diamètre hydraulique","mm",{"$f":"X14","v":0.13300000000000001},{"$f":"Y14","v":0.14299999999999999},{"$f":"Z14","v":0.15},0.16,0.17100000000000001,0.188,0.2,0.2,0.218,0.222,0.23100000000000001,0.24,0.24,0.25,0.26700000000000002,0.27300000000000002,0.28599999999999998,0.3,0.3,0.308,0.32,0.33300000000000002,0.34300000000000003,0.35299999999999998,0.375,0.38100000000000001,0.4,0.4,0.4,0.436,0.44400000000000001,0.46200000000000002,0.48,0.5,0.53300000000000003,0.54500000000000004,0.57099999999999995,0.6,0.61499999999999999,0.66700000000000004,0.68600000000000005,0.75,0.8,0.88900000000000001,1,null,null,null,null,null,"800x500",0.61499999999999999,"800x500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000x500",0.66700000000000004,"1000x500"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse réelle","m/s",{"$f":"X64","v":0},{"$f":"Y64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,"800x600",0.68600000000000005,"800x600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X52*X50/$X$9","v":0},{"$f":"Y52*Y50/$X$9","v":0},{"$f":"Z52*Z50/$X$9","v":0},{"$f":"AA52*AA50/$X$9","v":0},{"$f":"AB52*AB50/$X$9","v":0},{"$f":"AC52*AC50/$X$9","v":0},{"$f":"AD52*AD50/$X$9","v":0},{"$f":"AE52*AE50/$X$9","v":0},{"$f":"AF52*AF50/$X$9","v":0},{"$f":"AG52*AG50/$X$9","v":0},{"$f":"AH52*AH50/$X$9","v":0},{"$f":"AI52*AI50/$X$9","v":0},{"$f":"AJ52*AJ50/$X$9","v":0},{"$f":"AK52*AK50/$X$9","v":0},{"$f":"AL52*AL50/$X$9","v":0},{"$f":"AM52*AM50/$X$9","v":0},{"$f":"AN52*AN50/$X$9","v":0},{"$f":"AO52*AO50/$X$9","v":0},{"$f":"AP52*AP50/$X$9","v":0},{"$f":"AQ52*AQ50/$X$9","v":0},{"$f":"AR52*AR50/$X$9","v":0},{"$f":"AS52*AS50/$X$9","v":0},{"$f":"AT52*AT50/$X$9","v":0},{"$f":"AU52*AU50/$X$9","v":0},{"$f":"AV52*AV50/$X$9","v":0},{"$f":"AW52*AW50/$X$9","v":0},{"$f":"AX52*AX50/$X$9","v":0},{"$f":"AY52*AY50/$X$9","v":0},{"$f":"AZ52*AZ50/$X$9","v":0},{"$f":"BA52*BA50/$X$9","v":0},{"$f":"BB52*BB50/$X$9","v":0},{"$f":"BC52*BC50/$X$9","v":0},{"$f":"BD52*BD50/$X$9","v":0},{"$f":"BE52*BE50/$X$9","v":0},{"$f":"BF52*BF50/$X$9","v":0},{"$f":"BG52*BG50/$X$9","v":0},{"$f":"BH52*BH50/$X$9","v":0},{"$f":"BI52*BI50/$X$9","v":0},{"$f":"BJ52*BJ50/$X$9","v":0},{"$f":"BK52*BK50/$X$9","v":0},{"$f":"BL52*BL50/$X$9","v":0},{"$f":"BM52*BM50/$X$9","v":0},{"$f":"BN52*BN50/$X$9","v":0},{"$f":"BO52*BO50/$X$9","v":0},{"$f":"BP52*BP50/$X$9","v":0},null,null,null,null,null,"1000x600",0.75,"1000x600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient de frottement","-",{"$f":"IF(X53<3300,\"OUT\",0.25/(LOG($X$10/X50/3.7+5.74/X53^0.9))^2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",0.25/(LOG($X$10/Y50/3.7+5.74/Y53^0.9))^2)","v":"OUT"},{"$f":"IF(Z53<3300,\"OUT\",0.25/(LOG($X$10/Z50/3.7+5.74/Z53^0.9))^2)","v":"OUT"},{"$f":"IF(AA53<3300,\"OUT\",0.25/(LOG($X$10/AA50/3.7+5.74/AA53^0.9))^2)","v":"OUT"},{"$f":"IF(AB53<3300,\"OUT\",0.25/(LOG($X$10/AB50/3.7+5.74/AB53^0.9))^2)","v":"OUT"},{"$f":"IF(AC53<3300,\"OUT\",0.25/(LOG($X$10/AC50/3.7+5.74/AC53^0.9))^2)","v":"OUT"},{"$f":"IF(AD53<3300,\"OUT\",0.25/(LOG($X$10/AD50/3.7+5.74/AD53^0.9))^2)","v":"OUT"},{"$f":"IF(AE53<3300,\"OUT\",0.25/(LOG($X$10/AE50/3.7+5.74/AE53^0.9))^2)","v":"OUT"},{"$f":"IF(AF53<3300,\"OUT\",0.25/(LOG($X$10/AF50/3.7+5.74/AF53^0.9))^2)","v":"OUT"},{"$f":"IF(AG53<3300,\"OUT\",0.25/(LOG($X$10/AG50/3.7+5.74/AG53^0.9))^2)","v":"OUT"},{"$f":"IF(AH53<3300,\"OUT\",0.25/(LOG($X$10/AH50/3.7+5.74/AH53^0.9))^2)","v":"OUT"},{"$f":"IF(AI53<3300,\"OUT\",0.25/(LOG($X$10/AI50/3.7+5.74/AI53^0.9))^2)","v":"OUT"},{"$f":"IF(AJ53<3300,\"OUT\",0.25/(LOG($X$10/AJ50/3.7+5.74/AJ53^0.9))^2)","v":"OUT"},{"$f":"IF(AK53<3300,\"OUT\",0.25/(LOG($X$10/AK50/3.7+5.74/AK53^0.9))^2)","v":"OUT"},{"$f":"IF(AL53<3300,\"OUT\",0.25/(LOG($X$10/AL50/3.7+5.74/AL53^0.9))^2)","v":"OUT"},{"$f":"IF(AM53<3300,\"OUT\",0.25/(LOG($X$10/AM50/3.7+5.74/AM53^0.9))^2)","v":"OUT"},{"$f":"IF(AN53<3300,\"OUT\",0.25/(LOG($X$10/AN50/3.7+5.74/AN53^0.9))^2)","v":"OUT"},{"$f":"IF(AO53<3300,\"OUT\",0.25/(LOG($X$10/AO50/3.7+5.74/AO53^0.9))^2)","v":"OUT"},{"$f":"IF(AP53<3300,\"OUT\",0.25/(LOG($X$10/AP50/3.7+5.74/AP53^0.9))^2)","v":"OUT"},{"$f":"IF(AQ53<3300,\"OUT\",0.25/(LOG($X$10/AQ50/3.7+5.74/AQ53^0.9))^2)","v":"OUT"},{"$f":"IF(AR53<3300,\"OUT\",0.25/(LOG($X$10/AR50/3.7+5.74/AR53^0.9))^2)","v":"OUT"},{"$f":"IF(AS53<3300,\"OUT\",0.25/(LOG($X$10/AS50/3.7+5.74/AS53^0.9))^2)","v":"OUT"},{"$f":"IF(AT53<3300,\"OUT\",0.25/(LOG($X$10/AT50/3.7+5.74/AT53^0.9))^2)","v":"OUT"},{"$f":"IF(AU53<3300,\"OUT\",0.25/(LOG($X$10/AU50/3.7+5.74/AU53^0.9))^2)","v":"OUT"},{"$f":"IF(AV53<3300,\"OUT\",0.25/(LOG($X$10/AV50/3.7+5.74/AV53^0.9))^2)","v":"OUT"},{"$f":"IF(AW53<3300,\"OUT\",0.25/(LOG($X$10/AW50/3.7+5.74/AW53^0.9))^2)","v":"OUT"},{"$f":"IF(AX53<3300,\"OUT\",0.25/(LOG($X$10/AX50/3.7+5.74/AX53^0.9))^2)","v":"OUT"},{"$f":"IF(AY53<3300,\"OUT\",0.25/(LOG($X$10/AY50/3.7+5.74/AY53^0.9))^2)","v":"OUT"},{"$f":"IF(AZ53<3300,\"OUT\",0.25/(LOG($X$10/AZ50/3.7+5.74/AZ53^0.9))^2)","v":"OUT"},{"$f":"IF(BA53<3300,\"OUT\",0.25/(LOG($X$10/BA50/3.7+5.74/BA53^0.9))^2)","v":"OUT"},{"$f":"IF(BB53<3300,\"OUT\",0.25/(LOG($X$10/BB50/3.7+5.74/BB53^0.9))^2)","v":"OUT"},{"$f":"IF(BC53<3300,\"OUT\",0.25/(LOG($X$10/BC50/3.7+5.74/BC53^0.9))^2)","v":"OUT"},{"$f":"IF(BD53<3300,\"OUT\",0.25/(LOG($X$10/BD50/3.7+5.74/BD53^0.9))^2)","v":"OUT"},{"$f":"IF(BE53<3300,\"OUT\",0.25/(LOG($X$10/BE50/3.7+5.74/BE53^0.9))^2)","v":"OUT"},{"$f":"IF(BF53<3300,\"OUT\",0.25/(LOG($X$10/BF50/3.7+5.74/BF53^0.9))^2)","v":"OUT"},{"$f":"IF(BG53<3300,\"OUT\",0.25/(LOG($X$10/BG50/3.7+5.74/BG53^0.9))^2)","v":"OUT"},{"$f":"IF(BH53<3300,\"OUT\",0.25/(LOG($X$10/BH50/3.7+5.74/BH53^0.9))^2)","v":"OUT"},{"$f":"IF(BI53<3300,\"OUT\",0.25/(LOG($X$10/BI50/3.7+5.74/BI53^0.9))^2)","v":"OUT"},{"$f":"IF(BJ53<3300,\"OUT\",0.25/(LOG($X$10/BJ50/3.7+5.74/BJ53^0.9))^2)","v":"OUT"},{"$f":"IF(BK53<3300,\"OUT\",0.25/(LOG($X$10/BK50/3.7+5.74/BK53^0.9))^2)","v":"OUT"},{"$f":"IF(BL53<3300,\"OUT\",0.25/(LOG($X$10/BL50/3.7+5.74/BL53^0.9))^2)","v":"OUT"},{"$f":"IF(BM53<3300,\"OUT\",0.25/(LOG($X$10/BM50/3.7+5.74/BM53^0.9))^2)","v":"OUT"},{"$f":"IF(BN53<3300,\"OUT\",0.25/(LOG($X$10/BN50/3.7+5.74/BN53^0.9))^2)","v":"OUT"},{"$f":"IF(BO53<3300,\"OUT\",0.25/(LOG($X$10/BO50/3.7+5.74/BO53^0.9))^2)","v":"OUT"},{"$f":"IF(BP53<3300,\"OUT\",0.25/(LOG($X$10/BP50/3.7+5.74/BP53^0.9))^2)","v":"OUT"},null,null,null,null,null,"800x800",0.8,"800x800"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X54=\"OUT\",\"OUT\",X54/X50*$X$8/2*X52^2)","v":"OUT"},{"$f":"IF(Y54=\"OUT\",\"OUT\",Y54/Y50*$X$8/2*Y52^2)","v":"OUT"},{"$f":"IF(Z54=\"OUT\",\"OUT\",Z54/Z50*$X$8/2*Z52^2)","v":"OUT"},{"$f":"IF(AA54=\"OUT\",\"OUT\",AA54/AA50*$X$8/2*AA52^2)","v":"OUT"},{"$f":"IF(AB54=\"OUT\",\"OUT\",AB54/AB50*$X$8/2*AB52^2)","v":"OUT"},{"$f":"IF(AC54=\"OUT\",\"OUT\",AC54/AC50*$X$8/2*AC52^2)","v":"OUT"},{"$f":"IF(AD54=\"OUT\",\"OUT\",AD54/AD50*$X$8/2*AD52^2)","v":"OUT"},{"$f":"IF(AE54=\"OUT\",\"OUT\",AE54/AE50*$X$8/2*AE52^2)","v":"OUT"},{"$f":"IF(AF54=\"OUT\",\"OUT\",AF54/AF50*$X$8/2*AF52^2)","v":"OUT"},{"$f":"IF(AG54=\"OUT\",\"OUT\",AG54/AG50*$X$8/2*AG52^2)","v":"OUT"},{"$f":"IF(AH54=\"OUT\",\"OUT\",AH54/AH50*$X$8/2*AH52^2)","v":"OUT"},{"$f":"IF(AI54=\"OUT\",\"OUT\",AI54/AI50*$X$8/2*AI52^2)","v":"OUT"},{"$f":"IF(AJ54=\"OUT\",\"OUT\",AJ54/AJ50*$X$8/2*AJ52^2)","v":"OUT"},{"$f":"IF(AK54=\"OUT\",\"OUT\",AK54/AK50*$X$8/2*AK52^2)","v":"OUT"},{"$f":"IF(AL54=\"OUT\",\"OUT\",AL54/AL50*$X$8/2*AL52^2)","v":"OUT"},{"$f":"IF(AM54=\"OUT\",\"OUT\",AM54/AM50*$X$8/2*AM52^2)","v":"OUT"},{"$f":"IF(AN54=\"OUT\",\"OUT\",AN54/AN50*$X$8/2*AN52^2)","v":"OUT"},{"$f":"IF(AO54=\"OUT\",\"OUT\",AO54/AO50*$X$8/2*AO52^2)","v":"OUT"},{"$f":"IF(AP54=\"OUT\",\"OUT\",AP54/AP50*$X$8/2*AP52^2)","v":"OUT"},{"$f":"IF(AQ54=\"OUT\",\"OUT\",AQ54/AQ50*$X$8/2*AQ52^2)","v":"OUT"},{"$f":"IF(AR54=\"OUT\",\"OUT\",AR54/AR50*$X$8/2*AR52^2)","v":"OUT"},{"$f":"IF(AS54=\"OUT\",\"OUT\",AS54/AS50*$X$8/2*AS52^2)","v":"OUT"},{"$f":"IF(AT54=\"OUT\",\"OUT\",AT54/AT50*$X$8/2*AT52^2)","v":"OUT"},{"$f":"IF(AU54=\"OUT\",\"OUT\",AU54/AU50*$X$8/2*AU52^2)","v":"OUT"},{"$f":"IF(AV54=\"OUT\",\"OUT\",AV54/AV50*$X$8/2*AV52^2)","v":"OUT"},{"$f":"IF(AW54=\"OUT\",\"OUT\",AW54/AW50*$X$8/2*AW52^2)","v":"OUT"},{"$f":"IF(AX54=\"OUT\",\"OUT\",AX54/AX50*$X$8/2*AX52^2)","v":"OUT"},{"$f":"IF(AY54=\"OUT\",\"OUT\",AY54/AY50*$X$8/2*AY52^2)","v":"OUT"},{"$f":"IF(AZ54=\"OUT\",\"OUT\",AZ54/AZ50*$X$8/2*AZ52^2)","v":"OUT"},{"$f":"IF(BA54=\"OUT\",\"OUT\",BA54/BA50*$X$8/2*BA52^2)","v":"OUT"},{"$f":"IF(BB54=\"OUT\",\"OUT\",BB54/BB50*$X$8/2*BB52^2)","v":"OUT"},{"$f":"IF(BC54=\"OUT\",\"OUT\",BC54/BC50*$X$8/2*BC52^2)","v":"OUT"},{"$f":"IF(BD54=\"OUT\",\"OUT\",BD54/BD50*$X$8/2*BD52^2)","v":"OUT"},{"$f":"IF(BE54=\"OUT\",\"OUT\",BE54/BE50*$X$8/2*BE52^2)","v":"OUT"},{"$f":"IF(BF54=\"OUT\",\"OUT\",BF54/BF50*$X$8/2*BF52^2)","v":"OUT"},{"$f":"IF(BG54=\"OUT\",\"OUT\",BG54/BG50*$X$8/2*BG52^2)","v":"OUT"},{"$f":"IF(BH54=\"OUT\",\"OUT\",BH54/BH50*$X$8/2*BH52^2)","v":"OUT"},{"$f":"IF(BI54=\"OUT\",\"OUT\",BI54/BI50*$X$8/2*BI52^2)","v":"OUT"},{"$f":"IF(BJ54=\"OUT\",\"OUT\",BJ54/BJ50*$X$8/2*BJ52^2)","v":"OUT"},{"$f":"IF(BK54=\"OUT\",\"OUT\",BK54/BK50*$X$8/2*BK52^2)","v":"OUT"},{"$f":"IF(BL54=\"OUT\",\"OUT\",BL54/BL50*$X$8/2*BL52^2)","v":"OUT"},{"$f":"IF(BM54=\"OUT\",\"OUT\",BM54/BM50*$X$8/2*BM52^2)","v":"OUT"},{"$f":"IF(BN54=\"OUT\",\"OUT\",BN54/BN50*$X$8/2*BN52^2)","v":"OUT"},{"$f":"IF(BO54=\"OUT\",\"OUT\",BO54/BO50*$X$8/2*BO52^2)","v":"OUT"},{"$f":"IF(BP54=\"OUT\",\"OUT\",BP54/BP50*$X$8/2*BP52^2)","v":"OUT"},null,null,null,null,null,"1000x800",0.88900000000000001,"1000x800"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X55=\"OUT\",\"OUT\",X55*$D40)","v":"OUT"},{"$f":"IF(Y55=\"OUT\",\"OUT\",Y55*$D40)","v":"OUT"},{"$f":"IF(Z55=\"OUT\",\"OUT\",Z55*$D40)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT",null,null,null,null,null,"1000x1000",1,"1000x1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",{"$f":"X21","v":0.25},{"$f":"Y21","v":0.26},{"$f":"Z21","v":0.26},0.27,0.23,0.23,0.21,0.25,0.26,0.23,0.27,0.24,0.27,0.21,0.25,0.22,0.26,0.21,0.26,0.24,0.27,0.25,0.23,0.26,0.24,0.27,0.21,0.25,0.27,0.26,0.23,0.27,0.24,0.21,0.25,0.22,0.26,0.21,0.24,0.25,0.23,0.24,0.21,0.23,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",$E40*X57*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",$E40*Y57*$X$8*Y52^2/2)","v":"OUT"},{"$f":"IF(Z53<3300,\"OUT\",$E40*Z57*$X$8*Z52^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",{"$f":"0.6*X57","v":0.15},{"$f":"0.6*Y57","v":0.156},{"$f":"0.6*Z57","v":0.156},0.16200000000000001,0.13800000000000001,0.13800000000000001,0.126,0.15,0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.16200000000000001,0.126,0.15,0.13200000000000001,0.156,0.126,0.156,0.14399999999999999,0.16200000000000001,0.15,0.13800000000000001,0.156,0.14399999999999999,0.16200000000000001,0.126,0.15,0.16200000000000001,0.156,0.13800000000000001,0.16200000000000001,0.14399999999999999,0.126,0.15,0.13200000000000001,0.156,0.126,0.14399999999999999,0.15,0.13800000000000001,0.14399999999999999,0.126,0.13800000000000001,0.126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",$F40*X59*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",$F40*Y59*$X$8*Y52^2/2)","v":"OUT"},{"$f":"IF(Z53<3300,\"OUT\",$F40*Z59*$X$8*Z52^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée libre du conduit","-",{"$f":"X25","v":1},{"$f":"Y25","v":1},{"$f":"Z25","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",X61*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",Y61*$X$8*Y52^2/2)","v":"OUT"},{"$f":"IF(Z53<3300,\"OUT\",Z61*$X$8*Z52^2/2)","v":"OUT"},{"$f":"IF(AA53<3300,\"OUT\",AA61*$X$8*AA52^2/2)","v":"OUT"},{"$f":"IF(AB53<3300,\"OUT\",AB61*$X$8*AB52^2/2)","v":"OUT"},{"$f":"IF(AC53<3300,\"OUT\",AC61*$X$8*AC52^2/2)","v":"OUT"},{"$f":"IF(AD53<3300,\"OUT\",AD61*$X$8*AD52^2/2)","v":"OUT"},{"$f":"IF(AE53<3300,\"OUT\",AE61*$X$8*AE52^2/2)","v":"OUT"},{"$f":"IF(AF53<3300,\"OUT\",AF61*$X$8*AF52^2/2)","v":"OUT"},{"$f":"IF(AG53<3300,\"OUT\",AG61*$X$8*AG52^2/2)","v":"OUT"},{"$f":"IF(AH53<3300,\"OUT\",AH61*$X$8*AH52^2/2)","v":"OUT"},{"$f":"IF(AI53<3300,\"OUT\",AI61*$X$8*AI52^2/2)","v":"OUT"},{"$f":"IF(AJ53<3300,\"OUT\",AJ61*$X$8*AJ52^2/2)","v":"OUT"},{"$f":"IF(AK53<3300,\"OUT\",AK61*$X$8*AK52^2/2)","v":"OUT"},{"$f":"IF(AL53<3300,\"OUT\",AL61*$X$8*AL52^2/2)","v":"OUT"},{"$f":"IF(AM53<3300,\"OUT\",AM61*$X$8*AM52^2/2)","v":"OUT"},{"$f":"IF(AN53<3300,\"OUT\",AN61*$X$8*AN52^2/2)","v":"OUT"},{"$f":"IF(AO53<3300,\"OUT\",AO61*$X$8*AO52^2/2)","v":"OUT"},{"$f":"IF(AP53<3300,\"OUT\",AP61*$X$8*AP52^2/2)","v":"OUT"},{"$f":"IF(AQ53<3300,\"OUT\",AQ61*$X$8*AQ52^2/2)","v":"OUT"},{"$f":"IF(AR53<3300,\"OUT\",AR61*$X$8*AR52^2/2)","v":"OUT"},{"$f":"IF(AS53<3300,\"OUT\",AS61*$X$8*AS52^2/2)","v":"OUT"},{"$f":"IF(AT53<3300,\"OUT\",AT61*$X$8*AT52^2/2)","v":"OUT"},{"$f":"IF(AU53<3300,\"OUT\",AU61*$X$8*AU52^2/2)","v":"OUT"},{"$f":"IF(AV53<3300,\"OUT\",AV61*$X$8*AV52^2/2)","v":"OUT"},{"$f":"IF(AW53<3300,\"OUT\",AW61*$X$8*AW52^2/2)","v":"OUT"},{"$f":"IF(AX53<3300,\"OUT\",AX61*$X$8*AX52^2/2)","v":"OUT"},{"$f":"IF(AY53<3300,\"OUT\",AY61*$X$8*AY52^2/2)","v":"OUT"},{"$f":"IF(AZ53<3300,\"OUT\",AZ61*$X$8*AZ52^2/2)","v":"OUT"},{"$f":"IF(BA53<3300,\"OUT\",BA61*$X$8*BA52^2/2)","v":"OUT"},{"$f":"IF(BB53<3300,\"OUT\",BB61*$X$8*BB52^2/2)","v":"OUT"},{"$f":"IF(BC53<3300,\"OUT\",BC61*$X$8*BC52^2/2)","v":"OUT"},{"$f":"IF(BD53<3300,\"OUT\",BD61*$X$8*BD52^2/2)","v":"OUT"},{"$f":"IF(BE53<3300,\"OUT\",BE61*$X$8*BE52^2/2)","v":"OUT"},{"$f":"IF(BF53<3300,\"OUT\",BF61*$X$8*BF52^2/2)","v":"OUT"},{"$f":"IF(BG53<3300,\"OUT\",BG61*$X$8*BG52^2/2)","v":"OUT"},{"$f":"IF(BH53<3300,\"OUT\",BH61*$X$8*BH52^2/2)","v":"OUT"},{"$f":"IF(BI53<3300,\"OUT\",BI61*$X$8*BI52^2/2)","v":"OUT"},{"$f":"IF(BJ53<3300,\"OUT\",BJ61*$X$8*BJ52^2/2)","v":"OUT"},{"$f":"IF(BK53<3300,\"OUT\",BK61*$X$8*BK52^2/2)","v":"OUT"},{"$f":"IF(BL53<3300,\"OUT\",BL61*$X$8*BL52^2/2)","v":"OUT"},{"$f":"IF(BM53<3300,\"OUT\",BM61*$X$8*BM52^2/2)","v":"OUT"},{"$f":"IF(BN53<3300,\"OUT\",BN61*$X$8*BN52^2/2)","v":"OUT"},{"$f":"IF(BO53<3300,\"OUT\",BO61*$X$8*BO52^2/2)","v":"OUT"},{"$f":"IF(BP53<3300,\"OUT\",BP61*$X$8*BP52^2/2)","v":"OUT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression partielle","Pa",{"$f":"IF(OR($D40=\"\",$D40=0),0,IF(X53<3300,\"OUT\",X56+X58+X60+X62))","v":0},{"$f":"IF(OR($D40=\"\",$D40=0),0,IF(Y53<3300,\"OUT\",Y56+Y58+Y60+Y62))","v":0},{"$f":"IF(OR($D40=\"\",$D40=0),0,IF(Z53<3300,\"OUT\",Z56+Z58+Z60+Z62))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse réelle","m/s",{"$f":"$C40/(0.2*0.1)/3600","v":0},{"$f":"$C40/(0.25*0.1)/3600","v":0},{"$f":"$C40/(0.3*0.1)/3600","v":0},{"$f":"$C40/(0.4*0.1)/3600","v":0},{"$f":"$C40/(0.2*0.15)/3600","v":0},{"$f":"$C40/(0.25*0.15)/3600","v":0},{"$f":"$C40/(0.2*0.2)/3600","v":0},{"$f":"$C40/(0.3*0.15)/3600","v":0},{"$f":"$C40/(0.4*0.15)/3600","v":0},{"$f":"$C40/(0.25*0.2)/3600","v":0},{"$f":"$C40/(0.5*0.15)/3600","v":0},{"$f":"$C40/(0.3*0.2)/3600","v":0},{"$f":"$C40/(0.6*0.15)/3600","v":0},{"$f":"$C40/(0.25*0.25)/3600","v":0},{"$f":"$C40/(0.4*0.2)/3600","v":0},{"$f":"$C40/(0.3*0.25)/3600","v":0},{"$f":"$C40/(0.5*0.2)/3600","v":0},{"$f":"$C40/(0.3*0.3)/3600","v":0},{"$f":"$C40/(0.6*0.2)/3600","v":0},{"$f":"$C40/(0.4*0.25)/3600","v":0},{"$f":"$C40/(0.8*0.2)/3600","v":0},{"$f":"$C40/(0.5*0.25)/3600","v":0},{"$f":"$C40/(0.4*0.3)/3600","v":0},{"$f":"$C40/(0.6*0.25)/3600","v":0},{"$f":"$C40/(0.5*0.3)/3600","v":0},{"$f":"$C40/(0.8*0.25)/3600","v":0},{"$f":"$C40/(0.4*0.4)/3600","v":0},{"$f":"$C40/(0.6*0.3)/3600","v":0},{"$f":"$C40/(1*0.25)/3600","v":0},{"$f":"$C40/(0.8*0.3)/3600","v":0},{"$f":"$C40/(0.5*0.4)/3600","v":0},{"$f":"$C40/(1*0.3)/3600","v":0},{"$f":"$C40/(0.6*0.4)/3600","v":0},{"$f":"$C40/(0.5*0.5)/3600","v":0},{"$f":"$C40/(0.8*0.4)/3600","v":0},{"$f":"$C40/(0.6*0.5)/3600","v":0},{"$f":"$C40/(1*0.4)/3600","v":0},{"$f":"$C40/(0.6*0.6)/3600","v":0},{"$f":"$C40/(0.8*0.5)/3600","v":0},{"$f":"$C40/(1*0.5)/3600","v":0},{"$f":"$C40/(0.8*0.6)/3600","v":0},{"$f":"$C40/(1*0.6)/3600","v":0},{"$f":"$C40/(0.8*0.8)/3600","v":0},{"$f":"$C40/(1*0.8)/3600","v":0},{"$f":"$C40/(1*1)/3600","v":0}]

{"sheet":"Ducts Round","index":5,"n_rows":63,"n_cols":43,"rows_kept":63,"cut":false,"hidden":false,"merged":[[35,1,35,9],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[20,1,20,9],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[3,1,3,5],[5,1,5,9],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6]]}
[]
[]
[]
[null,{"$f":"Langage!A68","v":"Conduits de ventilation - Circulaires - Acier galvanisé à joint spiral"}]
[]
[null,{"$f":"Langage!A36","v":"Air comburant"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critère d'acceptation","Pa",3]
[]
[null,null,{"$f":"Langage!A43","v":"Débit"},{"$f":"Langage!A69","v":"Longueur droite"},{"$f":"Langage!A70","v":"Coude 90°"},{"$f":"Langage!A71","v":"Coude 45°"},{"$f":"Langage!A74","v":"Diamètre"},{"$f":"Langage!A73","v":"Options"},{"$f":"Langage!A94","v":"Minimum"},{"$f":"Langage!A72","v":"Perte de pression"},null,null,"q/Dp","q/Dp",null,null,null,null,null,null,null,"Masse volumique air 20°C","kg/m³",1.204]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null,null,"CE","CD",null,null,null,null,null,null,null,"Viscosité cinématique air 20°C","m²/s",{"$f":"0.000015","v":1.5E-5}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",HLOOKUP(\"OK\",X12:AQ27,2,FALSE))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(\"OK\",X12:AQ27,16,FALSE))","v":""},null,null,"Kin","Kout",null,null,null,null,null,null,null,"Rugosité absolue","m",{"$f":"0.00009","v":9.0000000000000006E-5},null,null,"Acier à joint spiral"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"\",\"\",MIN(IF(X13:AQ13>I10,X13:AQ13)))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(I11,X13:AQ27,15,FALSE))","v":""}]
[null,null,{"$f":"Langage!A75","v":"Bouche de prise d'air"},{"$f":"Langage!A82","v":"Données"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,2,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,4,FALSE))","v":""},null,null,{"$f":"IF(I11=0,0,IF(C10=\"\",\"\",MIN(IF(X13:AQ13>I11,X13:AQ13))))","v":""},{"$f":"IF(C10=\"\",\"\",HLOOKUP(I12,X13:AQ27,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Air comburant",null,{"$f":"IF(OR(X27=\"OUT\",X27>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y27=\"OUT\",Y27>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse",null,"Diamètres possibles","mm",100,125,150,160,200,250,300,315,355,400,450,500,560,630,710,800,900,1000,1120,1250]
[null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,3,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S19=0,S19=\"\"),\"\",IF(S19=\"OUT\",\"OUT\",S19))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-"," "," ",{"$f":"IF(D15<>N14,\"\",E15*X8*T14^2/2)","v":""},{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:AQ27,4,FALSE))","v":""},null,"Diamètre","mm",{"$f":"X13/1000","v":0.1},0.125,{"$f":"Z13/1000","v":0.15},0.16,0.2,0.25,0.3,0.315,0.35499999999999998,0.4,0.45,0.5,0.56000000000000005,0.63,0.71,0.8,0.9,1,1.1200000000000001,1.25]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,N14:S16,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D15<>N15,\"\",(C10/F15)^2*E15)","v":""},null,null,"Section","m²",{"$f":"PI()*(X14)^2/4","v":7.8539816339744835E-3},1.2271846303085129E-2,{"$f":"PI()*(Z14)^2/4","v":1.7671458676442587E-2},2.0106192982974676E-2,3.1415926535897934E-2,4.9087385212340517E-2,7.0685834705770348E-2,7.793113276311181E-2,9.8979803542163416E-2,0.12566370614359174,0.15904312808798329,0.19634954084936207,0.2463008640414398,0.31172453105244724,0.39591921416865367,0.50265482457436694,0.63617251235193317,0.78539816339744828,0.98520345616575922,1.227184630308513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-"," "," ",{"$f":"IF(D15<>N16,\"\",1/E15^2*X8*T14^2/2)","v":""},{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:AQ27,4,FALSE))","v":""},null,"Vitesse","m/s",{"$f":"$C10/X15/3600","v":0},0,{"$f":"$C10/Z15/3600","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S19=0,S19=\"\",J15=0,J15=\"\"),\"\",IF(S19=\"OUT\",\"OUT\",S19+J15))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X16*X14/$X$9","v":0},{"$f":"Y16*Y14/$X$9","v":0},{"$f":"Z16*Z14/$X$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Coefficient de frottement","-",{"$f":"IF(X17<3300,\"OUT\",0.25/(LOG($X$10/X14/3.7+5.74/X17^0.9))^2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",0.25/(LOG($X$10/Y14/3.7+5.74/Y17^0.9))^2)","v":"OUT"},{"$f":"IF(Z17<3300,\"OUT\",0.25/(LOG($X$10/Z14/3.7+5.74/Z17^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G10=\"\",\"\",HLOOKUP(G10,X13:AQ27,15,FALSE))","v":""},null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X18=\"OUT\",\"OUT\",X18/X14*$X$8/2*X16^2)","v":"OUT"},{"$f":"IF(Y18=\"OUT\",\"OUT\",Y18/Y14*$X$8/2*Y16^2)","v":"OUT"},{"$f":"IF(Z18=\"OUT\",\"OUT\",Z18/Z14*$X$8/2*Z16^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X19=\"OUT\",\"OUT\",X19*$D10)","v":"OUT"},{"$f":"IF(Y19=\"OUT\",\"OUT\",Y19*$D10)","v":"OUT"},{"$f":"IF(Z19=\"OUT\",\"OUT\",Z19*$D10)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,{"$f":"Langage!A$37","v":"Amenée d’air"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",0.37,0.3,0.25,0.25,0.24,0.24,0.28999999999999998,0.28000000000000003,0.27,0.25,0.24,0.23,0.21,0.2,0.19,0.18,0.17,0.16,0.16,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",$E10*X21*$X$8*X16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,{"$f":"Langage!A$43","v":"Débit"},{"$f":"Langage!A$69","v":"Longueur droite"},{"$f":"Langage!A$70","v":"Coude 90°"},{"$f":"Langage!A$71","v":"Coude 45°"},{"$f":"Langage!A$74","v":"Diamètre"},{"$f":"Langage!A$73","v":"Options"},{"$f":"Langage!A$94","v":"Minimum"},{"$f":"Langage!A$72","v":"Perte de pression"},null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",0.17,0.14000000000000001,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.1,0.09,0.08,0.08,0.08,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",$F10*X23*$X$8*X16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",HLOOKUP(\"OK\",X30:AQ45,2,FALSE))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(\"OK\",X30:AQ45,16,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Sortie libre du conduit","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,{"$f":"IF(C25=\"\",\"\",MIN(IF(X31:AQ31>I25,X31:AQ31)))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(I26,X31:AQ45,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X17<3300,\"OUT\",X25*$X$8*X16^2/2)","v":"OUT"},{"$f":"IF(Y17<3300,\"OUT\",Y25*$X$8*Y16^2/2)","v":"OUT"},{"$f":"IF(Z17<3300,\"OUT\",Z25*$X$8*Z16^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,{"$f":"Langage!A$75","v":"Bouche de prise d'air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,2,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,4,FALSE))","v":""},null,null,{"$f":"IF(I26=0,0,IF(C25=\"\",\"\",MIN(IF(X31:AQ31>I26,X31:AQ31))))","v":""},{"$f":"IF(C25=\"\",\"\",HLOOKUP(I27,X31:AQ45,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression partielle","Pa",{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(X17<3300,\"OUT\",X20+X22+X24+X26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(Y17<3300,\"OUT\",Y20+Y22+Y24+Y26))","v":0},{"$f":"IF(OR($D10=\"\",$D10=0),0,IF(Z17<3300,\"OUT\",Z20+Z22+Z24+Z26))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse"]
[null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,3,FALSE))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S34=0,S34=\"\"),\"\",IF(S34=\"OUT\",\"OUT\",S34))","v":""},null,null,null,"Kin",{"$f":"Langage!A$77","v":"Facteur K (aspiration)"},"-"," "," ",{"$f":"IF(D30<>N29,\"\",E30*$X$8*T29^2/2)","v":""},{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:AQ45,4,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,N29:S31,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D30<>N30,\"\",(C25/F30)^2*E30)","v":""},null,null,"Amenée d'air",null,{"$f":"IF(OR(X45=\"OUT\",X45>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y45=\"OUT\",Y45>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CE",{"$f":"Langage!A$80","v":"Coefficient de perte d'entrée"},"-"," "," ",{"$f":"IF(D30<>N31,\"\",1/E30^2*$X$8*T29^2/2)","v":""},{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:AQ45,4,FALSE))","v":""},null,"Diamètres possibles","mm",{"$f":"X13","v":100},{"$f":"Y13","v":125},150,160,200,250,300,315,355,400,450,500,560,630,710,800,900,1000,1120,1250]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S34=0,S34=\"\",J30=0,J30=\"\"),\"\",IF(S34=\"OUT\",\"OUT\",S34+J30))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Diamètre","mm",{"$f":"X31/1000","v":0.1},0.125,0.15,0.16,0.2,0.25,0.3,0.315,0.35499999999999998,0.4,0.45,0.5,0.56000000000000005,0.63,0.71,0.8,0.9,1,1.1200000000000001,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Section","m²",{"$f":"PI()*(X32)^2/4","v":7.8539816339744835E-3},{"$f":"PI()*(Y32)^2/4","v":1.2271846303085129E-2},1.7671458676442587E-2,2.0106192982974676E-2,3.1415926535897934E-2,4.9087385212340517E-2,7.0685834705770348E-2,7.793113276311181E-2,9.8979803542163416E-2,0.12566370614359174,0.15904312808798329,0.19634954084936207,0.2463008640414398,0.31172453105244724,0.39591921416865367,0.50265482457436694,0.63617251235193317,0.78539816339744828,0.98520345616575922,1.227184630308513]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G25=\"\",\"\",HLOOKUP(G25,X31:AQ45,15,FALSE))","v":""},null,null,"Vitesse","m/s",{"$f":"$C25/X33/3600","v":0},{"$f":"$C25/Y33/3600","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X34*X32/$X$9","v":0},{"$f":"Y34*Y32/$X$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Langage!A$38","v":"Evacuation d’air"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient de frottement","-",{"$f":"IF(X35<3300,\"OUT\",0.25/(LOG($X$10/X32/3.7+5.74/X35^0.9))^2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",0.25/(LOG($X$10/Y32/3.7+5.74/Y35^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X36=\"OUT\",\"OUT\",X36/X32*$X$8/2*X34^2)","v":"OUT"},{"$f":"IF(Y36=\"OUT\",\"OUT\",Y36/Y32*$X$8/2*Y34^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,{"$f":"Langage!A$43","v":"Débit"},{"$f":"Langage!A$69","v":"Longueur droite"},{"$f":"Langage!A$70","v":"Coude 90°"},{"$f":"Langage!A$71","v":"Coude 45°"},{"$f":"Langage!A$74","v":"Diamètre"},{"$f":"Langage!A$73","v":"Options"},{"$f":"Langage!A$94","v":"Minimum"},{"$f":"Langage!A$72","v":"Perte de pression"},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X37=\"OUT\",\"OUT\",X37*$D25)","v":"OUT"},{"$f":"IF(Y37=\"OUT\",\"OUT\",Y37*$D25)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,"m³/h","m","#","#","mm",null,"mm","Pa",null,null,null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",{"$f":"X21","v":0.37},{"$f":"Y21","v":0.3},0.25,0.25,0.24,0.24,0.28999999999999998,0.28000000000000003,0.27,0.25,0.24,0.23,0.21,0.2,0.19,0.18,0.17,0.16,0.16,0.15]
[null,null,null,null,null,null,null,null,{"$f":"IF(C40=\"\",\"\",HLOOKUP(\"OK\",X48:AQ63,2,FALSE))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(\"OK\",X48:AQ63,16,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",$E25*X39*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",$E25*Y39*$X$8*Y34^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,{"$f":"IF(C40=\"\",\"\",MIN(IF(X49:AQ49>I40,X49:AQ49)))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(I41,X49:AQ63,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",{"$f":"X23","v":0.17},{"$f":"Y23","v":0.14000000000000001},0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.1,0.09,0.08,0.08,0.08,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,{"$f":"Langage!A$76","v":"Bouche de rejet d'air"},{"$f":"Langage!A$82","v":"Données"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,2,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,4,FALSE))","v":""},null,null,{"$f":"IF(I41=0,0,IF(C40=\"\",\"\",MIN(IF(X49:AQ49>I41,X49:AQ49))))","v":""},{"$f":"IF(C40=\"\",\"\",HLOOKUP(I42,X49:AQ63,15,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",$F25*X41*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",$F25*Y41*$X$8*Y34^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression","Vitesse",null,"Sortie libre du conduit","-",{"$f":"X25","v":1},{"$f":"Y25","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,3,FALSE))","v":""},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,5,FALSE))","v":""},null,null,{"$f":"Langage!A$96","v":"Conduit"},{"$f":"IF(OR(S49=0,S49=\"\"),\"\",IF(S49=\"OUT\",\"OUT\",S49))","v":""},null,null,null,"Kout",{"$f":"Langage!A$78","v":"Facteur K (extraction)"},"-"," "," ",{"$f":"IF(D45<>N44,\"\",E45*$X$8*T44^2/2)","v":""},{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:AQ63,4,FALSE))","v":""},null,"Perte de pression singulière","Pa",{"$f":"IF(X35<3300,\"OUT\",X43*$X$8*X34^2/2)","v":"OUT"},{"$f":"IF(Y35<3300,\"OUT\",Y43*$X$8*Y34^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$97","v":"Bouche"},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,N44:S46,6,FALSE))","v":""},null,null,null,"q/Dp",{"$f":"Langage!A$83","v":"Différence de pression"},"Pa",{"$f":"Langage!$A$43","v":"Débit"},"m³/h",{"$f":"IF(D45<>N45,\"\",(C40/F45)^2*E45)","v":""},null,null,"Perte de pression partielle","Pa",{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(X35<3300,\"OUT\",X38+X40+X42+X44))","v":0},{"$f":"IF(OR($D25=\"\",$D25=0),0,IF(Y35<3300,\"OUT\",Y38+Y40+Y42+Y44))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CD",{"$f":"Langage!A$81","v":"Coefficient de perte de décharge"},"-"," "," ",{"$f":"IF(D45<>N46,\"\",1/E45^2*$X$8*T44^2/2)","v":""},{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:AQ63,4,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"Langage!A$84","v":"Cumulée"},{"$f":"IF(OR(S49=0,S49=\"\",J45=0,J45=\"\"),\"\",IF(S49=\"OUT\",\"OUT\",S49+J45))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression conduit",null,null,"Evacuation d'air",null,{"$f":"IF(OR(X63=\"OUT\",X63>$X$6),\"OUT\",\"OK\")","v":"OK"},{"$f":"IF(OR(Y63=\"OUT\",Y63>$X$6),\"OUT\",\"OK\")","v":"OK"},"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,null,null,null,null,null,null,null,null,{"$f":"Langage!$A$93","v":"Max. 3.0 Pa"},null,null,null,null,null,null,null,null,{"$f":"IF(G40=\"\",\"\",HLOOKUP(G40,X49:AQ63,15,FALSE))","v":""},null,null,"Diamètres possibles","mm",{"$f":"X13","v":100},{"$f":"Y13","v":125},150,160,200,250,300,315,355,400,450,500,560,630,710,800,900,1000,1120,1250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diamètre","mm",{"$f":"X49/1000","v":0.1},{"$f":"Y49/1000","v":0.125},0.15,0.16,0.2,0.25,0.3,0.315,0.35499999999999998,0.4,0.45,0.5,0.56000000000000005,0.63,0.71,0.8,0.9,1,1.1200000000000001,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section","m²",{"$f":"PI()*(X50)^2/4","v":7.8539816339744835E-3},{"$f":"PI()*(Y50)^2/4","v":1.2271846303085129E-2},1.7671458676442587E-2,2.0106192982974676E-2,3.1415926535897934E-2,4.9087385212340517E-2,7.0685834705770348E-2,7.793113276311181E-2,9.8979803542163416E-2,0.12566370614359174,0.15904312808798329,0.19634954084936207,0.2463008640414398,0.31172453105244724,0.39591921416865367,0.50265482457436694,0.63617251235193317,0.78539816339744828,0.98520345616575922,1.227184630308513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse","m/s",{"$f":"$C40/X51/3600","v":0},{"$f":"$C40/Y51/3600","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de Reynolds","-",{"$f":"X52*X50/$X$9","v":0},{"$f":"Y52*Y50/$X$9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient de frottement","-",{"$f":"IF(X53<3300,\"OUT\",0.25/(LOG($X$10/X50/3.7+5.74/X53^0.9))^2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",0.25/(LOG($X$10/Y50/3.7+5.74/Y53^0.9))^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéique","Pa/m",{"$f":"IF(X54=\"OUT\",\"OUT\",X54/X50*$X$8/2*X52^2)","v":"OUT"},{"$f":"IF(Y54=\"OUT\",\"OUT\",Y54/Y50*$X$8/2*Y52^2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression linéaire","Pa",{"$f":"IF(X55=\"OUT\",\"OUT\",X55*$D40)","v":"OUT"},{"$f":"IF(Y55=\"OUT\",\"OUT\",Y55*$D40)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 90° r/D=1","-",{"$f":"X21","v":0.37},{"$f":"Y21","v":0.3},0.25,0.25,0.24,0.24,0.28999999999999998,0.28000000000000003,0.27,0.25,0.24,0.23,0.21,0.2,0.19,0.18,0.17,0.16,0.16,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",$E40*X57*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",$E40*Y57*$X$8*Y52^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coude 45° r/D=1","-",{"$f":"X23","v":0.17},{"$f":"Y23","v":0.14000000000000001},0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.1,0.09,0.08,0.08,0.08,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",$F40*X59*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",$F40*Y59*$X$8*Y52^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrée libre du conduit","-",{"$f":"X25","v":1},{"$f":"Y25","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression singulière","Pa",{"$f":"IF(X53<3300,\"OUT\",X61*$X$8*X52^2/2)","v":"OUT"},{"$f":"IF(Y53<3300,\"OUT\",Y61*$X$8*Y52^2/2)","v":"OUT"},"OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT","OUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perte de pression partielle","Pa",{"$f":"IF(OR($D40=\"\",$D40=0),0,IF(X53<3300,\"OUT\",X56+X58+X60+X62))","v":0},{"$f":"IF(OR($D40=\"\",$D40=0),0,IF(Y53<3300,\"OUT\",Y56+Y58+Y60+Y62))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Tab 2","index":6,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["NBN B 61-001/002 - Tableau 2"]
[]
["Code",null,null,"Combustible","Type d'appareil de combustion","Débit d'air comburant spécifique"]
["NG","BWI","HI","Gaz naturel de type H ou L","Brûleur avec coupe-tirage",2.9,null,null,"Natural gas","Burner with draught diverter"]
["NG","BWO","HI","Gaz naturel de type H ou L","Brûleur sans coupe-tirage",1.34,null,null,null,"Burner without draught diverter"]
["NG","ICE","HI","Gaz naturel de type H ou L","Moteur à combustion interne",1.34,null,null,null,"Internal combustion engine"]
["LPG","BWI","HI","Propane / Butane","Brûleur avec coupe-tirage",2.9,null,null,"Liquefied Petroleum Gas"]
["LPG","BWO","HI","Propane / Butane","Brûleur sans coupe-tirage",1.34]
["LPG","ICE","HI","Propane / Butane","Moteur à combustion interne",1.34]
["HO",null,"HI","Gasoil de chauffage","Brûleur ou moteur à\ncombustion interne",1.33,null,null,"Heating oil"]
["CO",null,"HI","Coke",null,1.71,null,null,"Coke"]
["KE",null,"HI","Pétrole lampant",null,1.41,null,null,"Kerosene"]
["SC",null,"HI","Charbon (anthracite)",null,1.67,null,null,"Stone coal (anthracite)"]
["BC",null,"HI","Lignite",null,1.72,null,null,"Brown coal"]
["WL",null,"HI","Bois (bûches)",null,2.9,null,null,"Wood (logs)"]
["WP",null,"HI","Bois (granulés)",null,2,null,null,"Wood (pellets)"]
["NG","BWI","HS","Gaz naturel de type H ou L","Brûleur avec coupe-tirage",2.6]
["NG","BWO","HS","Gaz naturel de type H ou L","Brûleur sans coupe-tirage",1.21]
["NG","ICE","HS","Gaz naturel de type H ou L","Moteur à combustion interne",1.21]
["LPG","BWI","HS","Propane / Butane","Brûleur avec coupe-tirage",2.6]
["LPG","BWO","HS","Propane / Butane","Brûleur sans coupe-tirage",1.21]
["LPG","ICE","HS","Propane / Butane","Moteur à combustion interne",1.21]
["HO",null,"HS","Gasoil de chauffage","Brûleur ou moteur à\ncombustion interne",1.24]
["CO",null,"HS","Coke",null,1.57]
["KE",null,"HS","Pétrole lampant",null,1.32]
["SC",null,"HS","Charbon (anthracite)",null,1.61]
["BC",null,"HS","Lignite",null,1.64]
["WL",null,"HS","Bois (bûches)",null,2.7]
["WP",null,"HS","Bois (granulés)",null,1.9]

{"sheet":"Langage","index":7,"n_rows":100,"n_cols":5,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Choix de la langue"]
[null,1,2,3,4]
[{"$f":"Data!D2","v":"Français"},"Français","Nederlands","English","Deutsch"]
[]
[{"$f":"IF(A$3=B$3,B5,IF(A$3=C$3,C5,IF(A$3=D$3,D5,E5)))","v":"Données techniques"},"Données techniques","Technische gegevens"]
["Total","Total","Totaal","Total","Gesamt"]
["Entité de bâtiment","Entité de bâtiment","Gebouwentiteit","Building entity","Baukörper"]
["Données relatives aux appareils de combustion","Données relatives aux appareils de combustion","Gegevens betreffende de verbrandingstoestellen"]
["Circuit de combustion","Circuit de combustion","Verbrandingskring"]
["Appareil","Appareil","Toestel","Device"]
["Puissance nominale","Puissance nominale","Nominaal vermogen"]
["Surface au sol","Surface au sol","Vloeroppervlakte"]
["Débit de l'amenée d'air","Débit de l'amenée d'air","luchttoevoerdebiet"]
["Débit de l'évacuation d'air","Débit de l'évacuation d'air","luchtafvoerdebiet"]
["Type","Type","Type"]
["Nature","Nature","Aard"]
["Ouverture franche","Ouverture franche","Ongehinderde opening"]
["Choix d'un dispositif de transfert","Choix d'un dispositif de transfert","Keuze van een luchtrooster"]
["Dp catalogue","Dp catalogue","Dp catalogus"]
["Débit catalogue","Débit catalogue","Debiet catalogus"]
[{"$f":"IF(A$3=B$3,B21,IF(A$3=C$3,C21,IF(A$3=D$3,D21,E21)))","v":"Dossier"},"Dossier","Dossier","File","Dossier"]
["Nom","Nom","Naam","Name","Name"]
["Adresse","Adresse","Adres","Address","Adresse"]
["Commune","Commune","Gemeente","City","Gemeinde"]
["Commentaire","Commentaire","Commentaar","Comment","Kommentar"]
["Date","Date","Datum","Date","Datum"]
["Références","Références","Referentie","Reference","Referenzen"]
["Données administratives","Données administratives","Administratieve gegevens","Administrative data","Verwaltungsangaben"]
["Bâtiment","Bâtiment","Gebouw","Building","Gebäude"]
["Installateur","Installateur","Installateur","Installer","Installateur"]
["Conception des chaufferies","Conception des chaufferies","Ontwerp van stookafdelingen","Design of boiler rooms","Heizungsraumgestaltung"]
["NBN B 61-001/002:2019","NBN B 61-001/002:2019","NBN B 61-001/002:2019","NBN B 61-001/002:2019","NBN B 61-001/002:2019"]
["Nouveau calcul","Nouveau calcul","Nieuwe berekening","New calculation","Neue Berechnung"]
["Ventilation du local de chauffe","Ventilation du local de chauffe","Ventilatie van het stooklokaal"]
["Dispositions techniques","Dispositions techniques","Technische bepalingen"]
["Air comburant","Air comburant","Verbrandingslucht"]
["Amenée d’air","Amenée d’air","Luchttoevoer"]
["Evacuation d’air","Evacuation d’air","Luchtafvoer"]
["Naturelle","Naturelle","Natuurlijk"]
["Mecanique","Mecanique","Mechanisch"]
["Dispositif de transfert","Dispositif de transfert","Luchtrooster"]
["Conduit","Conduit","Kanaal"]
["Débit","Débit","Debiet"]
["Etanche","Etanche","Gesloten","Roomsealed"]
["Non-étanche","Non-étanche","Open","Non-roomsealed"]
["Débit d’air comburant","Débit d’air comburant","Verbrandings- luchtdebiet"]
["Débit d’air comburant spécifique","Débit d’air comburant spécifique","Specifiek verbrandings- luchtdebiet"]
["Combustible","Combustible","Brandstof"]
["Brûleur","Brûleur","Brander"]
["Débit calorifique nominal sur Hs","Débit calorifique nominal sur Hs","Nominaal calorisch debiet op Hs"]
["Débit calorifique nominal sur Hi","Débit calorifique nominal sur Hi","Nominaal calorisch debiet op Hi"]
["Référence","Référence","Referentie"]
[{"$f":"IF(A$3=B$3,B53,IF(A$3=C$3,C53,IF(A$3=D$3,D53,E53)))","v":"Gaz naturel"},"Gaz naturel","Aardgas"]
["Propane - Butane","Propane - Butane","Propaan - Butaan"]
["Gasoil de chauffage","Gasoil de chauffage","Verwarmingsgasolie"]
["Coke","Coke","Cokes"]
["Pétrole lampant","Pétrole lampant","Lampolie"]
["Charbon","Charbon","Steenkool"]
["Lignite","Lignite","Bruinkool"]
["Bois (bûches)","Bois (bûches)","Hout (houtblokken)"]
["Bois (granulés)","Bois (granulés)","Hout (pellets)"]
["Brûleur avec coupe-tirage","Brûleur avec coupe-tirage","Brander met trekonderbreker"]
["Brûleur sans coupe-tirage","Brûleur sans coupe-tirage","Brander zonder trekonderbreker"]
["Moteur à combustion interne","Moteur à combustion interne","Inwendige verbrandingsmotor"]
["Pouvoir calorifique inférieur","Pouvoir calorifique inférieur","Onderste verbrandingswaarde"]
["Pouvoir calorifique supérieur","Pouvoir calorifique supérieur","Bovenste verbrandingswaarde"]
["Norme applicable","Norme applicable","Toepasbare norm"]
["Conduits de ventilation - Circulaires - Acier galvanisé à joint spiral","Conduits de ventilation - Circulaires - Acier galvanisé à joint spiral","Ventilatiekanalen - Cirkelvormige - Gegalvaniseerd staal met een spiraalnaad "]
["Longueur droite","Longueur droite","Rechte lengte"]
["Coude 90°","Coude 90°","Bocht 90°"]
["Coude 45°","Coude 45°","Bocht 45°"]
["Perte de pression","Perte de pression","Drukverlies"]
["Options","Options","Opties"]
["Diamètre","Diamètre","Diameter"]
["Bouche de prise d'air","Bouche de prise d'air","Inlaat luchtventiel"]
["Bouche de rejet d'air","Bouche de rejet d'air","Uitlaat luchtventiel"]
["Facteur K (aspiration)","Facteur K (aspiration)","K-factor (aanzuig)"]
["Facteur K (extraction)","Facteur K (extraction)","K-factor (uitblaas)"]
["Couple Débit / Pression","Couple Débit / Pression","Debiet / Druk koppel"]
["Coefficient de perte d'entrée","Coefficient de perte d'entrée","Inlaat verliescoëfficiënt"]
["Coefficient de perte de décharge","Coefficient de perte de décharge","Uitlaat verliescoëfficiënt"]
["Données","Données","Gegevens"]
["Différence de pression","Différence de pression","Drukverschil"]
["Cumulée","Cumulée","Gecumuleerd"]
["Conduits de ventilation - Rectangulaires - Tôle d'acier galvanisé","Conduits de ventilation - Rectangulaires - Tôle d'acier galvanisé","Ventilatiekanalen - Rechthoekige - Gegalvaniseerd plaatstaal "]
["Dispositif de transfert d’air monté dans une paroi extérieure du local","Dispositif de transfert d’air monté dans une paroi extérieure du local","Luchtrooster in een buitenwand van het lokaal"]
["Dispositif de transfert d’air","Dispositif de transfert d’air","Luchtrooster"]
["Dimensions","Dimensions","Afmetingen"]
["Surface","Surface","Oppervlakte"]
[{"$f":"IF(A$3=B$3,B90,IF(A$3=C$3,C90,IF(A$3=D$3,D90,E90)))","v":"Surface minimum"},"Surface minimum","Minimum oppervlakte"]
["Débit minimum","Débit minimum","Minimum debiet"]
["Débit nominal","Débit nominal","Nominaal debiet"]
["Max. 3.0 Pa","Max. 3.0 Pa","Max. 3.0 Pa"]
["Minimum","Minimum","Minimum"]
["Dimensions = Largeur x Hauteur","Dimensions = Largeur x Hauteur","Afmetingen = Breedte x Hoogte"]
["Conduit","Conduit","Kanaal"]
["Bouche","Bouche","Ventiel"]
["Sigles","Sigles","Afkortingen"]
["Débit calorifique nominal\nsur Hs ou sur Hi\n(indiquer un des deux)","Débit calorifique nominal\nsur Hs ou sur Hi\n(indiquer un des deux)","Nominaal calorisch debiet\nop Hs of op Hi\n(één van de twee aangeven)"]
[0]

{"sheet":"Versions","index":8,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Liste des versions successives"]
[]
["v1.0","2019-12-13","Original"]
["v1.1","2020-03-12","Correction d'une erreur de recherche dans le tableau des conduits rectangulaires (tableau de recherche pas complet)"]
[null,null,"Correction du calcul de la vitesse d'air dans les grilles des conduits rectangulaires (vitesse calculée avec la section hydraulique et pas la section réelle)"]
[null,null,"Modification de la fonction de recherche de la 3ème section possible"]
["v1.2","2020-03-26","Correction d'un lien erroné vers une autre feuille de calcul (pas d'influence sur les résultats)"]
[null,null,"Correction de la mise en forme conditionnelle de cellules"]
[null,null,"Correction de la dénomination des bouches pour le rejet d'air."]
["v2.1","2020-05-25","Modification de la forme d'introduction du débit calorifique"]
[null,null,"Elargissement du choix des conduits circulaires et rectangulaires  (toutes les dimensions normalisées pour les conduits circulaires + toutes les dimensions normalisées jusque 1000 mm pour les conduits rectangulaires)"]
[null,null,"Elargissement du choix aux coefficients CD et CE pour les grilles et les bouches"]
[null,null,"Rassemblement de tous les sigles dans l'onglet Devices"]
[null,null,"Suppression des générations d'erreur quand on introduit une valeur pas nécessaire dans les caractéristiques des générateurs de chaleur"]
["v2.2","2020-09-19","Correction du calcul de la vitesse d'air dans les conduits rectangulaires (vitesse calculée avec la section hydraulique et pas la section réelle)"]
[]
[]
[]
["Avertissements"]
[]
["Il y a des feuilles cachées qui comportent des tableaux"]
["Il y a des colonnes cachées qui contiennent des informations et valeurs intermédiaires"]
[null,"On ne peut donc pas simplement ajouter ou supprimer des lignes"]
["Il y a des fonctions de recherche dans les tableaux"]
[null,"Ces fonctions sont mises à jour automatiquement en cas d'ajout de ligne ou de colonne mais il faut rester très vigilant"]
[]
["Mode d'emploi"]
[]
["Lire la norme de référence"]
["Remplir les cellules oranges. Les autres cellules ne peuvent pas être modifiées."]
[]
[]
["Possibilités d'amélioration"]
[]
["Possibilité de choisir le matériau des conduits"]
["Possibilité d'inverser la largeur et la hauteur des conduits rectangulaires (ça influence la perte de pression des coudes)"]
["Possibilité de choisir la perte de pression à l'entrée (ou la sortie) libre des conduits"]