{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["calculs2","Données-Résultats","chaudDD","Base","MAJ"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"calculs2","index":0,"n_rows":89,"n_cols":16,"rows_kept":89,"cut":false,"hidden":true,"merged":[[19,7,20,7],[19,9,20,9],[19,11,20,11],[19,5,20,5]]}
[null,null,null,null,null,{"$f":"'Données-Résultats'!G16","v":"Circuit A"},null,{"$f":"'Données-Résultats'!J16","v":"Circuit B"},null,{"$f":"'Données-Résultats'!M16","v":"Circuit C"},null,{"$f":"'Données-Résultats'!P16","v":"Circuit D"}]
[]
[null,{"$f":"'Données-Résultats'!C16","v":"Utilisation"}]
[null,{"$f":"'Données-Résultats'!C19","v":"Référence"},{"$f":"'Données-Résultats'!D19","v":"-"},{"$f":"'Données-Résultats'!E19","v":"-"},{"$f":"'Données-Résultats'!F19","v":":"},{"$f":"'Données-Résultats'!G19","v":0},"choix1",{"$f":"'Données-Résultats'!J19","v":0},"choix2",{"$f":"'Données-Résultats'!M19","v":0},"choix3",{"$f":"'Données-Résultats'!P19","v":0},"choix4"]
[null,{"$f":"'Données-Résultats'!C20","v":"Puissance nominale d'utilisation"},{"$f":"'Données-Résultats'!D20","v":"Pu"},{"$f":"'Données-Résultats'!E20","v":"kW"},{"$f":"'Données-Résultats'!F20","v":":"},{"$f":"'Données-Résultats'!G20","v":0},null,{"$f":"'Données-Résultats'!J20","v":0},null,{"$f":"'Données-Résultats'!M20","v":0},null,{"$f":"'Données-Résultats'!P20","v":0}]
[null,{"$f":"'Données-Résultats'!C21","v":"Température de départ nominale"},"Tdu",{"$f":"'Données-Résultats'!E21","v":"°C"},{"$f":"'Données-Résultats'!F21","v":":"},{"$f":"'Données-Résultats'!G21","v":0},null,{"$f":"'Données-Résultats'!J21","v":0},null,{"$f":"'Données-Résultats'!M21","v":0},null,{"$f":"'Données-Résultats'!P21","v":0}]
[null,"maximum T départ",null,"°C",{"$f":"MAX(F6,H6,J6,L6)","v":0}]
[null,{"$f":"'Données-Résultats'!C29","v":"Température de retour d'utilisation"},"Tru",{"$f":"'Données-Résultats'!E22","v":"°C"},{"$f":"'Données-Résultats'!F22","v":":"},{"$f":"'Données-Résultats'!H22","v":0},{"$f":"'Données-Résultats'!G22","v":0},{"$f":"'Données-Résultats'!K22","v":0},{"$f":"'Données-Résultats'!J22","v":0},{"$f":"'Données-Résultats'!N22","v":0},{"$f":"'Données-Résultats'!M22","v":0},{"$f":"'Données-Résultats'!Q22","v":0},{"$f":"'Données-Résultats'!P22","v":0}]
[null,"ou Débit d'utilisation","qvu","m3/h",":"]
[]
[null,"Débit d'utilisation","qvu",null,null,{"$f":"IF(G8=\"Tru\",F5/(1.163*(F6-F8)),\"***\")","v":"***"},null,{"$f":"IF(I8=\"Tru\",H5/(1.163*(H6-H8)),\"***\")","v":"***"},null,{"$f":"IF(K8=\"Tru\",J5/(1.163*(J6-J8)),\"***\")","v":"***"},null,{"$f":"IF(M8=\"Tru\",L5/(1.163*(L6-L8)),\"***\")","v":"***"}]
[null,"valeur sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F11)","v":0},null,{"$f":"IF(OR(H5=0,H6=0,H8=0),0,H11)","v":0},null,{"$f":"IF(OR(J5=0,J6=0,J8=0),0,J11)","v":0},null,{"$f":"IF(OR(L5=0,L6=0,L8=0),0,L11)","v":0}]
[null,"Temp retour utilisation","Tru",null,null,{"$f":"IF(G8=\"qvu\",F6-(F5/(F8*1.163)),\"***\")","v":"***"},null,{"$f":"IF(I8=\"qvu\",H6-(H5/(H8*1.163)),\"***\")","v":"***"},null,{"$f":"IF(K8=\"qvu\",J6-(J5/(J8*1.163)),\"***\")","v":"***"},null,{"$f":"IF(M8=\"qvu\",L6-(L5/(L8*1.163)),\"***\")","v":"***"}]
[null,"valeur sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F13)","v":0},null,{"$f":"IF(OR(H5=0,H6=0,H8=0),0,H13)","v":0},null,{"$f":"IF(OR(J5=0,J6=0,J8=0),0,J13)","v":0},null,{"$f":"IF(OR(L5=0,L6=0,L8=0),0,L13)","v":0}]
[null,"Débit de génération","qvg",null,null,{"$f":"IF(G8=\"Tru\",F5/(1.163*($E$7-F8)),F5/(1.163*($E$7-F14)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(I8=\"Tru\",H5/(1.163*($E$7-H8)),H5/(1.163*($E$7-H14)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K8=\"Tru\",J5/(1.163*($E$7-J8)),J5/(1.163*($E$7-J14)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(M8=\"Tru\",L5/(1.163*($E$7-L8)),L5/(1.163*($E$7-L14)))","v":{"$error":"#DIV/0!"}}]
[null,"valeur sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F15)","v":0},null,{"$f":"IF(OR(H5=0,H6=0,H8=0),0,H15)","v":0},null,{"$f":"IF(OR(J5=0,J6=0,J8=0),0,J15)","v":0},null,{"$f":"IF(OR(L5=0,L6=0,L8=0),0,L15)","v":0}]
[null,"Temp retour utilisation","Tru",null,null,{"$f":"IF(G8=\"qvu\",F6-(F5/(F8*1.163)),F8)","v":0},null,{"$f":"IF(I8=\"qvu\",H6-(H5/(H8*1.163)),H8)","v":0},null,{"$f":"IF(K8=\"qvu\",J6-(J5/(J8*1.163)),J8)","v":0},null,{"$f":"IF(M8=\"qvu\",L6-(L5/(L8*1.163)),L8)","v":0}]
[null,"valeur sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F17)","v":0},null,{"$f":"IF(OR(H5=0,H6=0,H8=0),0,H17)","v":0},null,{"$f":"IF(OR(J5=0,J6=0,J8=0),0,J17)","v":0},null,{"$f":"IF(OR(L5=0,L6=0,L8=0),0,L17)","v":0}]
[null,"rapport Tmax/Td",null,null,null,{"$f":"$E$7/F6","v":{"$error":"#DIV/0!"}},null,{"$f":"$E$7/H6","v":{"$error":"#DIV/0!"}},null,{"$f":"$E$7/J6","v":{"$error":"#DIV/0!"}},null,{"$f":"$E$7/L6","v":{"$error":"#DIV/0!"}}]
[null,"vanne ou pas",null,null,null,{"$f":"IF(F19>1,\"mettre une vanne de mélange\",\"\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(H19>1,\"mettre une vanne de mélange\",\"\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(J19>1,\"mettre une vanne de mélange\",\"\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(L19>1,\"mettre une vanne de mélange\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"valeur sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),\"\",F20)","v":""},null,{"$f":"IF(OR(H5=0,H6=0,H8=0),\"\",H20)","v":""},null,{"$f":"IF(OR(J5=0,J6=0,J8=0),\"\",J20)","v":""},null,{"$f":"IF(OR(L5=0,L6=0,L8=0),\"\",L20)","v":""}]
[null,"Diamètre"]
[null,"Calcul avec vitesse silencieuse:"]
[null,{"$f":"'Données-Résultats'!C31","v":"Diamètre tube circuit d'utilisation"},{"$f":"'Données-Résultats'!D31","v":"Øu"},{"$f":"'Données-Résultats'!E31","v":"mm"},{"$f":"'Données-Résultats'!F31","v":"="},{"$f":"IF(G8=\"Tru\",22.9*F12^0.4,22.9*F8^0.4)","v":0},null,{"$f":"IF(I8=\"Tru\",22.9*H12^0.4,22.9*H8^0.4)","v":0},null,{"$f":"IF(K8=\"Tru\",22.9*J12^0.4,22.9*J8^0.4)","v":0},null,{"$f":"IF(M8=\"Tru\",22.9*L12^0.4,22.9*L8^0.4)","v":0},{"$f":"'Données-Résultats'!Q31","v":0},{"$f":"'Données-Résultats'!R31","v":0},{"$f":"'Données-Résultats'!S31","v":0},{"$f":"'Données-Résultats'!T31","v":0}]
[null,"valeur proche",{"$f":"'Données-Résultats'!D32","v":0},{"$f":"'Données-Résultats'!E32","v":0},{"$f":"'Données-Résultats'!F32","v":0},{"$f":"VLOOKUP(F25,Base!$A$5:$A$31,1,TRUE)","v":0},null,{"$f":"VLOOKUP(H25,Base!$A$5:$A$31,1,TRUE)","v":0},null,{"$f":"VLOOKUP(J25,Base!$A$5:$A$31,1,TRUE)","v":0},null,{"$f":"VLOOKUP(L25,Base!$A$5:$A$31,1,TRUE)","v":0},{"$f":"'Données-Résultats'!Q32","v":0},{"$f":"'Données-Résultats'!R32","v":0},{"$f":"'Données-Résultats'!S32","v":0},{"$f":"'Données-Résultats'!T32","v":0}]
[null,"diam réel",null,null,null,{"$f":"VLOOKUP(F25,Base!$A$5:$B$30,2,TRUE)","v":13.2},null,{"$f":"VLOOKUP(H25,Base!$A$5:$B$30,2,TRUE)","v":13.2},null,{"$f":"VLOOKUP(J25,Base!$A$5:$B$30,2,TRUE)","v":13.2},null,{"$f":"VLOOKUP(L25,Base!$A$5:$B$30,2,TRUE)","v":13.2}]
[null,"diam réf",null,null,null,{"$f":"VLOOKUP(F27,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"},null,{"$f":"VLOOKUP(H27,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"},null,{"$f":"VLOOKUP(J27,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"},null,{"$f":"VLOOKUP(L27,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"}]
[null,"sans div0",null,null,null,{"$f":"IF(F25=0,\"\",F28)","v":""},null,{"$f":"IF(H25=0,\"\",H28)","v":""},null,{"$f":"IF(J25=0,\"\",J28)","v":""},null,{"$f":"IF(L25=0,\"\",L28)","v":""}]
[null,"Somme puissances utilisations",null,"kW",{"$f":"F5+H5+J5+L5","v":0}]
[null,"sans div0",null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),\"\",E30)","v":""}]
[]
[null,"Débit total de génération",null,"m3/h",null,{"$f":"F16+H16+J16+L16","v":0}]
[null,null,null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F33)","v":0}]
[null,"Température de mélange",null,{"$f":"'Données-Résultats'!E42","v":"°C"},{"$f":"'Données-Résultats'!F42","v":"="},{"$f":"(F16*F18+H16*H18+J16*J18+L16*L18)/(F16+H16+J16+L16)","v":{"$error":"#DIV/0!"}}]
[null,"sans div0",null,"°C",null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F35)","v":0}]
[null,"Débit transitant dans bouteille"]
[null,"Coefficient de bypass",null,null,null,145]
[null,"Coeff/100",null,null,null,{"$f":"IF(F5=0,0,F38/100)","v":0}]
[null,"Débit transitant",null,null,null,{"$f":"IF(F39=1,\"0\",F34*(F39-1))","v":0},"m3/h"]
[null,{"$f":"'Données-Résultats'!C41","v":"Température départ primaire"},"Tdp",{"$f":"'Données-Résultats'!E41","v":"°C"},{"$f":"'Données-Résultats'!F41","v":"="},{"$f":"E7","v":0}]
[null,{"$f":"'Données-Résultats'!C42","v":"Température retour primaire"},"Trp","°C",null,{"$f":"(F34*F36+F40*E7)/(F34+F40)","v":{"$error":"#DIV/0!"}}]
[null,"sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F42)","v":0}]
[null,"chute",null,null,null,{"$f":"F41-F43","v":0}]
[null,{"$f":"'Données-Résultats'!C44","v":"Puissance utile de génération"},{"$f":"'Données-Résultats'!D34","v":"Pu"},{"$f":"'Données-Résultats'!E34","v":"kW"},{"$f":"'Données-Résultats'!F34","v":"="},{"$f":"E31","v":""},null,{"$f":"1.163*F49*(F41-F35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F45)","v":0}]
[null,"Coef surpuissance",null,null,null,{"$f":"'Données-Résultats'!H45","v":0}]
[null,"Puissance de génération à installer",null,null,null,{"$f":"F46*(100+F47)/100","v":0}]
[null,{"$f":"'Données-Résultats'!C47","v":"Débit du circuit primaire"},{"$f":"'Données-Résultats'!D47","v":"qvp"},{"$f":"'Données-Résultats'!E47","v":"m3/h"},{"$f":"'Données-Résultats'!F47","v":"="},{"$f":"F48/(1.163*(F41-F43))","v":{"$error":"#DIV/0!"}}]
[null,"div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F49)","v":0},null,{"$f":"IF(F50<#REF!,\"Ajuster la majoration de puissance.\",\"Le débit primaire est bien ajusté.\")","v":{"$error":"#REF!"}}]
[null,"Diamètre circuit primaire","Dp","mm","=",{"$f":"22.9*F49^0.4","v":{"$error":"#DIV/0!"}}]
[null,"div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F51)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(F51,Base!$A$5:$A$31,1,TRUE)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"VLOOKUP(F51,Base!$A$5:$B$30,2,TRUE)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"VLOOKUP(F54,Base!$B$5:$C$31,2,TRUE)","v":{"$error":"#DIV/0!"}}]
[null,"sans div0",null,null,null,{"$f":"IF(OR(F5=0,F6=0,F8=0),0,F55)","v":0}]
[]
[null,"Bouteille"]
[null,"Diamètre circuit secondaire","Ds","mm","=",{"$f":"F25","v":0},null,null,null,null,null,null,null,{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"VLOOKUP(F59,Base!$A$5:$A$31,1,TRUE)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(F59,Base!$A$5:$B$30,2,TRUE)","v":13.2}]
[null,null,null,null,null,{"$f":"VLOOKUP(F61,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"}]
[null,"sans div0",null,null,null,{"$f":"IF(F59=0,\"\",F62)","v":""}]
[]
[null,"Diametre bouteille","Db","mm","=",{"$f":"3*F52","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(F65,Base!$A$5:$A$31,1,TRUE)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(F65,Base!$A$5:$B$30,2,TRUE)","v":13.2}]
[null,null,null,null,null,{"$f":"VLOOKUP(F67,Base!$B$5:$C$31,2,TRUE)","v":"AC - 17.2 * 2"}]
[null,null,null,null,null,{"$f":"IF(F65=0,\"\",F68)","v":""}]
[null,"test circuit",null,null,null,{"$f":"IF(F5>0,1,0)","v":0},null,{"$f":"IF(H5>0,1,0)","v":0},null,{"$f":"IF(J5>0,1,0)","v":0},null,{"$f":"IF(L5>0,1,0)","v":0}]
[null,"Nombre de circuits",null,null,null,{"$f":"SUM(F70,H70,J70,L70)","v":0}]
[null,"Hauteur de bouteille",null,null,null,{"$f":"IF(F71=1,13*F52,IF(F71=2,19*F52,IF(F71=3,25*F52,IF(F71=4,31*F52))))","v":false}]
[null,null,null,null,null,{"$f":"ROUND(F72/10,0)*10","v":0}]
[null,null,null,null,"a",{"$f":"ROUND(2*F52/10,0)*10","v":0}]
[null,null,null,null,"b",{"$f":"ROUND(3*F52/10,0)*10","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Données-Résultats'!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Données-Résultats","index":1,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":false,"merged":[[5,3,5,17],[6,3,6,17],[7,3,7,17],[3,17,3,18],[28,6,28,7],[28,9,28,10],[22,12,23,13],[22,15,23,16],[15,12,15,13],[15,15,15,16],[18,12,18,13],[19,12,19,13],[20,12,20,13],[18,15,18,16],[19,15,19,16],[20,15,20,16],[31,9,31,10],[30,6,30,7],[30,9,30,10],[31,6,31,7],[22,9,23,10],[50,2,51,5],[15,6,15,7],[15,9,15,10],[19,6,19,7],[20,6,20,7],[19,9,19,10],[20,9,20,10],[18,9,18,10],[18,6,18,7],[37,6,37,7],[22,6,23,7],[33,6,33,7],[36,6,36,7],[45,6,45,7],[43,6,43,7],[34,6,34,7],[58,9,58,10],[46,6,46,7],[47,6,47,7],[48,6,48,7],[66,6,66,7],[58,6,58,7],[57,6,57,7],[59,6,59,7],[60,6,60,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[30,12,30,13],[30,15,30,16],[27,6,27,7],[27,9,27,10],[29,6,29,7],[29,9,29,10],[27,12,27,13],[28,12,28,13],[27,15,27,16],[29,12,29,13],[29,15,29,16],[28,15,28,16],[58,12,58,13],[58,15,58,16],[57,15,57,16],[31,15,31,16],[31,12,31,13],[42,6,42,7],[38,6,38,7],[40,6,40,7],[41,6,41,7],[57,12,57,13],[57,9,57,10],[55,6,55,7],[56,6,56,7]]}
[]
[]
[null,null,null,null,"Dimensionnement d'une bouteille de découplage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 04/2020"]
[]
[]
[null,null," Références du projet"]
[]
[]
[]
[]
[]
[]
["?",null,"Données"]
[]
["?",null,"Utilisation",null,null,null,"Circuit A",null,null,"Circuit B",null,null,"Circuit C",null,null,"Circuit D"]
[]
[null,null,"Désignation","Symbole","Unité"]
["?",null,"Référence","-","-",":"]
[null,null,"Puissance nominale d'utilisation","Pu","kW",":"]
["?",null,"Température de départ nominale","qdu","°C",":"]
["?",null,"Température de retour d'utilisation","qru",{"$f":"IF(C24=\"Débit\",\"m3/h\",\"°C\")","v":"°C"},":"]
[null,null,"ou Débit d'utilisation","qvu","m3/h",null,{"$f":"calculs2!F22","v":""},null,null,{"$f":"calculs2!H22","v":""},null,null,{"$f":"calculs2!J22","v":""},null,null,{"$f":"calculs2!L22","v":""}]
["?",null,"Présence ou non d'une vanne de mélange"]
[null,null,"Résultats"]
[]
[]
["?",null,"Débit d'utilisation","qvu","m3/h","=",{"$f":"calculs2!F12","v":0},null,null,{"$f":"calculs2!H12","v":0},null,null,{"$f":"calculs2!J12","v":0},null,null,{"$f":"calculs2!L12","v":0}]
["?",null,"Température de retour d'utilisation","qru",{"$f":"IF(C29=\"Débit\",\"m3/h\",\"°C\")","v":"°C"},"=",{"$f":"calculs2!F14","v":0},null,null,{"$f":"calculs2!H14","v":0},null,null,{"$f":"calculs2!J14","v":0},null,null,{"$f":"calculs2!L14","v":0}]
["?",null,"Débit secondaire","qvs","m3/h","=",{"$f":"calculs2!F16","v":0},null,null,{"$f":"calculs2!H16","v":0},null,null,{"$f":"calculs2!J16","v":0},null,null,{"$f":"calculs2!L16","v":0}]
["?",null,"Diamètre tube circuit d'utilisation","Øu","mm","=",{"$f":"calculs2!F25","v":0},null,null,{"$f":"calculs2!H25","v":0},null,null,{"$f":"calculs2!J25","v":0},null,null,{"$f":"calculs2!L25","v":0}]
[null,null,null,null,null,null,{"$f":"calculs2!F29","v":""},null,null,{"$f":"calculs2!H29","v":""},null,null,{"$f":"calculs2!J29","v":""},null,null,{"$f":"calculs2!L29","v":""}]
[]
["?",null,"Puissance totale d'utilisation","Pu","kW","=",{"$f":"calculs2!E31","v":""}]
["?",null,"Débit total secondaire","Qvs","m3/h","=",{"$f":"calculs2!F34","v":0}]
[]
["?",null,"Température de mélange bouteille","Tm","°C","=",{"$f":"calculs2!F36","v":0}]
["?",null,"Coefficient de bypass de bouteille","Cb","-",":",{"$f":"calculs2!F39","v":0}]
["?",null,"Débit transitant dans la bouteille","qvb","m3/h","=",{"$f":"calculs2!F40","v":0}]
[]
["?",null,"Température départ primaire","qdp","°C","=",{"$f":"calculs2!F41","v":0}]
["?",null,"Température retour primaire","qrp","°C","=",{"$f":"calculs2!F43","v":0}]
["?",null,"Chute de température générateur","Dq","°C","=",{"$f":"calculs2!F44","v":0}]
["?",null,"Puissance utile de génération","Pg","kW","=",{"$f":"calculs2!F46","v":0}]
["?",null,"Coefficient de surpuissance","Cs","%"]
["?",null,"Puissance de génération à installer","Pg","kW","=",{"$f":"calculs2!F48","v":0}]
["?",null,"Débit du circuit primaire","qvp","m3/h","=",{"$f":"calculs2!F50","v":0}]
["?",null,"Diamètre du circuit primaire","Øp","mm","=",{"$f":"calculs2!F52","v":0}]
[null,null,null,null,null,null,{"$f":"calculs2!F56","v":0}]
[]
[]
[]
[]
[]
["?",null,"Bouteille"]
[null,null,"Diamètre du circuit primaire","Øp","mm","=",{"$f":"calculs2!F52","v":0}]
[null,null,null,null,null,null,{"$f":"calculs2!F56","v":0}]
[null,null,"Diamètre des circuits de génération","Øs","mm","=",{"$f":"calculs2!F25","v":0},null,null,{"$f":"calculs2!H25","v":0},null,null,{"$f":"calculs2!J25","v":0},null,null,{"$f":"calculs2!L25","v":0}]
[null,null,null,null,null,null,{"$f":"calculs2!F29","v":""},null,null,{"$f":"calculs2!H29","v":""},null,null,{"$f":"calculs2!J29","v":""},null,null,{"$f":"calculs2!L29","v":""}]
[null,null,"Diamètre de la bouteille","Øb","mm","=",{"$f":"calculs2!F65","v":0}]
[null,null,null,null,null,null,{"$f":"calculs2!F69","v":""}]
[]
[]
[null,null,"Hauteur de la bouteille   ","H","mm","=",{"$f":"calculs2!F73","v":0}]
[null,null,"Cote a","a","mm","=",{"$f":"calculs2!F74","v":0}]
[null,null,"Cote b","b","mm","=",{"$f":"calculs2!F75","v":0}]

{"sheet":"chaudDD","index":2,"n_rows":154,"n_cols":30,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,"base de données chaudières"]
[]
["Pu",{"$f":"'Données-Résultats'!G46","v":0}]
[]
["solution","Pmax","Modèle","combustible","Pmin","Pmax","qm fumées","qm fumées","diam sortie ch.","T fumées","% CO2","n°test",null,null,"solutions","Modèle","combustible","Pmin","Pmax","qm fumées","qm fumées","diam sortie ch.","T fumées","% CO2"]
[null,"kW","sans regu",null,"kW","kW","kg/h","kg/s","mm",null,null,null,null,null,null,null,null,"kW","kW","kg/h","kg/s","mm",null,null,null,null,"Modèle",null,"Pmin (kW)","Pmax (kW)"]
[{"$f":"L8","v":1},54,"DTG 230-7","gaz",27,54,119,{"$f":"G8/3600","v":3.3055555555555553E-2},180,null,null,{"$f":"IF($B$4<=F8,1,0)","v":1},null,null,1,{"$f":"VLOOKUP(O8,$A$8:$L$110,3,FALSE)","v":"DTG 230-7"},{"$f":"VLOOKUP(O8,$A$8:$L$110,4,FALSE)","v":"gaz"},{"$f":"VLOOKUP(O8,$A$8:$L$110,5,FALSE)","v":27},{"$f":"VLOOKUP(O8,$A$8:$L$110,6,FALSE)","v":54},{"$f":"VLOOKUP(O8,$A$8:$L$110,7,FALSE)","v":119},{"$f":"VLOOKUP(O8,$A$8:$L$110,8,FALSE)","v":3.3055555555555553E-2},{"$f":"VLOOKUP(O8,$A$8:$L$110,9,FALSE)","v":180},{"$f":"VLOOKUP(O8,$A$8:$L$110,10,FALSE)","v":0},{"$f":"VLOOKUP(O8,$A$8:$L$110,11,FALSE)","v":0},1,null,{"$f":"IF(ISNA(P8)=TRUE,\"hors gamme\",P8)","v":"DTG 230-7"},{"$f":"IF(ISNA(Q8)=TRUE,\"\",Q8)","v":"gaz"},{"$f":"IF(ISNA(R8)=TRUE,\"\",R8)","v":27},54]
[{"$f":"A8+L9","v":2},63,"DTG 230-8","gaz",36,63,138,{"$f":"G9/3600","v":3.833333333333333E-2},180,null,null,{"$f":"IF($B$4<=F9,1,0)","v":1},null,null,2,{"$f":"VLOOKUP(O9,$A$8:$K$110,3,FALSE)","v":"DTG 230-8"},{"$f":"VLOOKUP(O9,$A$8:$K$110,4,FALSE)","v":"gaz"},36,63,138,3.833333333333333E-2,180,0,0,2,null,{"$f":"IF(ISNA(P9)=TRUE,\"hors gamme\",P9)","v":"DTG 230-8"},{"$f":"IF(ISNA(Q9)=TRUE,\"\",Q9)","v":"gaz"},36,63]
[3,70,"DTG 230-9","gaz",36,72,160,4.4444444444444446E-2,180,null,null,1,null,null,3,"DTG 230-9","gaz",36,72,160,4.4444444444444446E-2,180,0,0,3,null,"DTG 230-9","gaz",36,72]
[4,81,"DTG 230-10","gaz",45,81,177,4.9166666666666664E-2,200,null,null,1,null,null,4,"DTG 230-10","gaz",45,81,177,4.9166666666666664E-2,200,0,0,4,null,"DTG 230-10","gaz",45,81]
[5,86,"C 230-85 Eco / C 210-85 Eco","gaz",8.9,86,137,3.8055555555555558E-2,150,null,null,1,null,null,6,"DTG 230-11","gaz",45,90,197,5.4722222222222221E-2,200,0,0,6,null,"DTG 230-11","gaz",45,90]
[6,90,"DTG 230-11","gaz",45,90,197,5.4722222222222221E-2,200,null,null,1,null,null,7,"GT 334","fioul",55,90,149,4.1388888888888892E-2,180,195,13,7,null,"GT 334","fioul",55,90]
[7,90,"GT 334","fioul",55,90,149,4.1388888888888892E-2,180,195,13,1,null,null,8,"GT 334","gaz",55,90,160,4.4444444444444446E-2,180,195,9.5,8,null,"GT 334","gaz",55,90]
[8,90,"GT 334","gaz",55,90,160,4.4444444444444446E-2,180,195,9.5,1,null,null,9,"DTG 230-12","gaz",54,99,216,0.06,200,0,0,9,null,"DTG 230-12","gaz",54,99]
[9,99,"DTG 230-12","gaz",54,99,216,0.06,200,null,null,1,null,null,10,"DTG 230-13","gaz",54,108,235,6.5277777777777782E-2,220,0,0,10,null,"DTG 230-13","gaz",54,108]
[10,108,"DTG 230-13","gaz",54,108,235,6.5277777777777782E-2,220,null,null,1,null,null,11,"GT 335","fioul",90,115,191,5.3055555555555557E-2,180,190,13,11,null,"GT 335","fioul",90,115]
[11,115,"GT 335","fioul",90,115,191,5.3055555555555557E-2,180,190,13,1,null,null,12,"GT 335","gaz",90,115,206,5.7222222222222223E-2,180,190,9.5,12,null,"GT 335","gaz",90,115]
[12,115,"GT 335","gaz",90,115,206,5.7222222222222223E-2,180,190,9.5,1,null,null,13,"DTG 230-14","gaz",54,117,255,7.0833333333333331E-2,220,0,0,13,null,"DTG 230-14","gaz",54,117]
[13,117,"DTG 230-14","gaz",54,117,255,7.0833333333333331E-2,220,null,null,1,null,null,14,"DTG 330-8 Eco","gaz",88,126,313.2,8.6999999999999994E-2,250,130,6.4,14,null,"DTG 330-8 Eco","gaz",88,126]
[14,126,"DTG 330-8 Eco","gaz",88,126,{"$f":"H21*3600","v":313.2},8.6999999999999994E-2,250,130,6.4,1,null,null,16,"DTG 330-8 S","gaz",83,140,352.8,9.8000000000000004E-2,250,140,6.4,16,null,"DTG 330-8 S","gaz",83,140]
[15,129,"C 230-130 Eco / C 210-130 Eco","gaz",13.5,129,205,{"$f":"G22/3600","v":5.6944444444444443E-2},150,null,null,1,null,null,17,"DTG 330-9 Eco","gaz",101,144,360,0.1,250,130,6.4,17,null,"DTG 330-9 Eco","gaz",101,144]
[16,140,"DTG 330-8 S","gaz",83,140,{"$f":"H23*3600","v":352.8},9.8000000000000004E-2,250,140,6.4,1,null,null,18,"GT 336","fioul",115,150,248,6.8888888888888888E-2,180,195,13,18,null,"GT 336","fioul",115,150]
[17,144,"DTG 330-9 Eco","gaz",101,144,{"$f":"H24*3600","v":360},0.1,250,130,6.4,1,null,null,19,"GT 336","gaz",115,150,270,7.4999999999999997E-2,180,195,9.5,19,null,"GT 336","gaz",115,150]
[18,150,"GT 336","fioul",115,150,248,{"$f":"G25/3600","v":6.8888888888888888E-2},180,195,13,1,null,null,20,"DTG 330-9 S","gaz",95,160,403.2,0.112,250,140,6.4,20,null,"DTG 330-9 S","gaz",95,160]
[19,150,"GT 336","gaz",115,150,270,{"$f":"G26/3600","v":7.4999999999999997E-2},180,195,9.5,1,null,null,21,"DTG 330-10 Eco","gaz",113,162,410.40000000000003,0.114,300,125,6.3,21,null,{"$f":"IF(ISNA(P26)=TRUE,\"hors gamme\",P26)","v":"DTG 330-10 Eco"},"gaz",113,162]
[20,160,"DTG 330-9 S","gaz",95,160,{"$f":"H27*3600","v":403.2},0.112,250,140,6.4,1,null,null,22,"C 230-170 Eco / C 210-170 Eco","gaz",18.100000000000001,171,274,7.6111111111111115E-2,150,0,0,22,null,"C 230-170 Eco / C 210-170 Eco","gaz",18.100000000000001,171]
[21,162,"DTG 330-10 Eco","gaz",113,162,{"$f":"H28*3600","v":410.40000000000003},0.114,300,125,6.3,1,null,null,23,"DTG 330-10 S","gaz",107,180,460.8,0.128,300,130,6.6,23,null,"DTG 330-10 S","gaz",107,180]
[22,171,"C 230-170 Eco / C 210-170 Eco","gaz",18.100000000000001,171,274,7.6111111111111115E-2,150,null,null,1,null,null,24,"DTG 330-11 Eco","gaz",126,180,446.4,0.124,300,125,6.4,24,null,"DTG 330-11 Eco","gaz",126,180]
[23,180,"DTG 330-10 S","gaz",107,180,{"$f":"H30*3600","v":460.8},0.128,300,130,6.6,1,null,null,25,"GT 337","fioul",150,185,306,8.5000000000000006E-2,200,195,13,25,null,"GT 337","fioul",150,185]
[24,180,"DTG 330-11 Eco","gaz",126,180,{"$f":"H31*3600","v":446.4},0.124,300,125,6.4,1,null,null,26,"GT 337","gaz",150,185,331,9.194444444444444E-2,200,195,9.5,26,null,"GT 337","gaz",150,185]
[25,185,"GT 337","fioul",150,185,306,{"$f":"G32/3600","v":8.5000000000000006E-2},200,195,13,1,null,null,27,"DTG 330-12 Eco","gaz",139,198,464.40000000000003,0.129,300,130,6.8,27,null,"DTG 330-12 Eco","gaz",139,198]
[26,185,"GT 337","gaz",150,185,331,{"$f":"G33/3600","v":9.194444444444444E-2},200,195,9.5,1,null,null,28,"DTG 330-11 S","gaz",119,200,507.59999999999997,0.14099999999999999,300,130,6.4,28,null,"DTG 330-11 S","gaz",119,200]
[27,198,"DTG 330-12 Eco","gaz",139,198,{"$f":"H34*3600","v":464.40000000000003},0.129,300,130,6.8,1,null,null,29,"C 230-210 Eco / C 210-210 Eco","gaz",22.7,214,343,9.5277777777777781E-2,150,0,0,29,null,"C 230-210 Eco / C 210-210 Eco","gaz",22.7,214]
[28,200,"DTG 330-11 S","gaz",119,200,{"$f":"H35*3600","v":507.59999999999997},0.14099999999999999,300,130,6.4,1,null,null,30,"DTG 330-12 S","gaz",131,220,558,0.155,300,135,6.4,30,null,"DTG 330-12 S","gaz",131,220]
[29,214,"C 230-210 Eco / C 210-210 Eco","gaz",22.7,214,343,{"$f":"G36/3600","v":9.5277777777777781E-2},150,null,null,1,null,null,31,"GT 338","fioul",185,230,381,0.10583333333333333,200,185,13,31,null,"GT 338",{"$f":"IF(ISNA(Q36)=TRUE,\"\",Q36)","v":"fioul"},185,230]
[30,220,"DTG 330-12 S","gaz",131,220,{"$f":"H37*3600","v":558},0.155,300,135,6.4,1,null,null,32,"GT 338","gaz",185,230,411,0.11416666666666667,200,185,9.5,32,null,"GT 338","gaz",185,230]
[31,230,"GT 338","fioul",185,230,381,{"$f":"G38/3600","v":0.10583333333333333},200,185,13,1,null,null,33,"DTG 330-14 Eco","gaz",164,234,572.4,0.159,350,125,6.5,33,null,"DTG 330-14 Eco","gaz",164,234]
[32,230,"GT 338","gaz",185,230,411,{"$f":"G39/3600","v":0.11416666666666667},200,185,9.5,1,null,null,34,"DTG 330-14 S","gaz",155,260,608.40000000000009,0.16900000000000001,350,130,7,34,null,"DTG 330-14 S","gaz",155,260]
[33,234,"DTG 330-14 Eco","gaz",164,234,{"$f":"H40*3600","v":572.4},0.159,350,125,6.5,1,null,null,35,"DTG 330-16 Eco","gaz",{"$f":"VLOOKUP(O40,$A$8:$L$110,5,FALSE)","v":189},{"$f":"VLOOKUP(O40,$A$8:$L$110,6,FALSE)","v":270},{"$f":"VLOOKUP(O40,$A$8:$L$110,7,FALSE)","v":615.6},{"$f":"VLOOKUP(O40,$A$8:$L$110,8,FALSE)","v":0.17100000000000001},{"$f":"VLOOKUP(O40,$A$8:$L$110,9,FALSE)","v":350},{"$f":"VLOOKUP(O40,$A$8:$L$110,10,FALSE)","v":130},{"$f":"VLOOKUP(O40,$A$8:$L$110,11,FALSE)","v":7},35,null,"DTG 330-16 Eco","gaz",189,270]
[34,260,"DTG 330-14 S","gaz",155,260,{"$f":"H41*3600","v":608.40000000000009},0.16900000000000001,350,130,7,1,null,null,36,{"$f":"VLOOKUP(O41,$A$8:$K$110,3,FALSE)","v":"GT 339"},{"$f":"VLOOKUP(O41,$A$8:$K$110,4,FALSE)","v":"fioul"},230,280,463,0.12861111111111112,200,195,13,36,null,"GT 339","fioul",230,280]
[35,270,"DTG 330-16 Eco","gaz",189,270,{"$f":"H42*3600","v":615.6},0.17100000000000001,350,130,7,1,null,null,37,"GT 339","gaz",230,280,500,0.1388888888888889,200,195,9.5,37,null,"GT 339","gaz",230,280]
[36,280,"GT 339","fioul",230,280,463,{"$f":"G43/3600","v":0.12861111111111112},200,195,13,1,null,null,38,"C 310-280 Eco","gaz",56,282,453,0.12583333333333332,250,0,0,38,null,"C 310-280 Eco","gaz",56,282]
[37,280,"GT 339","gaz",230,280,500,{"$f":"G44/3600","v":0.1388888888888889},200,195,9.5,1,null,null,39,"DTG 330-16 S","gaz",179,300,640.79999999999995,0.17799999999999999,350,135,7.7,39,null,"DTG 330-16 S","gaz",179,300]
[38,282,"C 310-280 Eco","gaz",56,282,453,{"$f":"G45/3600","v":0.12583333333333332},250,null,null,1,null,null,40,"DTG 330-18 Eco","gaz",214,306,655.19999999999993,0.182,350,135,7.5,40,null,"DTG 330-18 Eco","gaz",214,306]
[39,300,"DTG 330-16 S","gaz",179,300,{"$f":"H46*3600","v":640.79999999999995},0.17799999999999999,350,135,7.7,1,null,null,42,"GT 430-8","gaz",250,310,568,0.15777777777777777,250,200,9,42,null,"GT 430-8","gaz",250,310]
[40,306,"DTG 330-18 Eco","gaz",214,306,{"$f":"H47*3600","v":655.19999999999993},0.182,350,135,7.5,1,null,null,43,"DTG 330-18 S","gaz",202,340,727.2,0.20200000000000001,350,140,7.7,43,null,"DTG 330-18 S","gaz",202,340]
[41,310,"GT 430-8","fioul",250,310,516,{"$f":"G48/3600","v":0.14333333333333334},250,200,13,1,null,null,44,"DTG 330-20 Eco","gaz",239,342,705.6,0.19600000000000001,400,135,7.8,44,null,"DTG 330-20 Eco","gaz",239,342]
[42,310,"GT 430-8","gaz",250,310,568,{"$f":"G49/3600","v":0.15777777777777777},250,200,9,1,null,null,45,"C 310-350 Eco","gaz",71,535,565,0.15694444444444444,250,0,0,45,null,"C 310-350 Eco","gaz",71,535]
[43,340,"DTG 330-18 S","gaz",202,340,{"$f":"H50*3600","v":727.2},0.20200000000000001,350,140,7.7,1,null,null,46,"GT 430-9","fioul",310,370,615,0.17083333333333334,250,200,13,46,null,"GT 430-9","fioul",310,370]
[44,342,"DTG 330-20 Eco","gaz",239,342,{"$f":"H51*3600","v":705.6},0.19600000000000001,400,135,7.8,1,null,null,47,"GT 430-9","gaz",310,370,677,0.18805555555555556,250,200,9,47,null,"GT 430-9","gaz",310,370]
[45,353,"C 310-350 Eco","gaz",71,535,565,{"$f":"G52/3600","v":0.15694444444444444},250,null,null,1,null,null,48,"DTG 330-20 S","gaz",226,380,802.80000000000007,0.223,400,140,7.8,48,null,"DTG 330-20 S","gaz",226,380]
[46,370,"GT 430-9","fioul",310,370,615,{"$f":"G53/3600","v":0.17083333333333334},250,200,13,1,null,null,49,"GT 530-7","fioul",348,406,705,0.19583333333333333,300,210,0,49,null,"GT 530-7","fioul",348,406]
[47,370,"GT 430-9","gaz",310,370,677,{"$f":"G54/3600","v":0.18805555555555556},250,200,9,1,null,null,50,"GT 530-7","gaz",348,406,705,0.19583333333333333,300,210,0,50,null,"GT 530-7","gaz",348,406]
[48,380,"DTG 330-20 S","gaz",226,380,{"$f":"H55*3600","v":802.80000000000007},0.223,400,140,7.8,1,null,null,51,"C 310-430 Eco","gaz",84,427,680,0.18888888888888888,250,0,0,51,null,"C 310-430 Eco","gaz",84,427]
[49,406,"GT 530-7","fioul",348,406,705,{"$f":"G56/3600","v":0.19583333333333333},300,210,null,1,null,null,52,"GT 430-10","fioul",370,430,716,0.19888888888888889,250,200,13,52,null,"GT 430-10","fioul",370,430]
[50,406,"GT 530-7","gaz",348,406,705,0.19583333333333333,300,210,null,1,null,null,53,"GT 430-10","gaz",370,430,789,0.21916666666666668,250,200,9,53,null,"GT 430-10","gaz",370,430]
[51,427,"C 310-430 Eco","gaz",84,427,680,0.18888888888888888,250,null,null,1,null,null,54,"GT 530-8","fioul",406,464,805,0.22361111111111112,300,210,0,54,null,"GT 530-8","fioul",406,464]
[52,430,"GT 430-10","fioul",370,430,716,0.19888888888888889,250,200,13,1,null,null,55,"GT 530-8","gaz",406,464,805,0.22361111111111112,300,210,0,55,null,"GT 530-8","gaz",406,464]
[53,430,"GT 430-10","gaz",370,430,789,0.21916666666666668,250,200,9,1,null,null,56,"GT 430-11","fioul",430,495,823,0.2286111111111111,300,200,13,56,null,{"$f":"IF(ISNA(P60)=TRUE,\"hors gamme\",P60)","v":"GT 430-11"},"fioul",430,495]
[54,464,"GT 530-8","fioul",406,464,805,0.22361111111111112,300,210,null,1,null,null,57,"GT 430-11","gaz",430,495,906,0.25166666666666665,300,200,9,57,null,"GT 430-11","gaz",430,495]
[55,464,"GT 530-8","gaz",406,464,805,0.22361111111111112,300,210,null,1,null,null,58,"C 310-500 Eco","gaz",98,499,793,0.22027777777777777,250,0,0,58,null,"C 310-500 Eco","gaz",98,499]
[56,495,"GT 430-11","fioul",430,495,823,0.2286111111111111,300,200,13,1,null,null,59,"GT 530-9","fioul",464,522,895,0.24861111111111112,300,208,0,59,null,"GT 530-9","fioul",464,522]
[57,495,"GT 430-11","gaz",430,495,906,0.25166666666666665,300,200,9,1,null,null,60,"GT 530-9","gaz",464,522,895,0.24861111111111112,300,208,0,60,null,"GT 530-9","gaz",464,522]
[58,499,"C 310-500 Eco","gaz",98,499,793,0.22027777777777777,250,null,null,1,null,null,61,"GT 430-12","fioul",495,570,947,0.26305555555555554,300,200,13,61,null,"GT 430-12","fioul",495,570]
[59,522,"GT 530-9","fioul",464,522,895,0.24861111111111112,300,208,null,1,null,null,62,"GT 430-12","gaz",495,570,1043,0.28972222222222221,300,200,9,62,null,"GT 430-12","gaz",495,570]
[60,522,"GT 530-9","gaz",464,522,895,0.24861111111111112,300,208,null,1,null,null,63,"C 310-570 Eco","gaz",113,573,907,0.25194444444444447,250,0,0,63,null,"C 310-570 Eco","gaz",113,573]
[61,570,"GT 430-12","fioul",495,570,947,0.26305555555555554,300,200,13,1,null,null,64,"GT 530-10","fioul",522,580,990,0.27500000000000002,350,207,0,64,null,"GT 530-10","fioul",522,580]
[62,570,"GT 430-12","gaz",495,570,1043,0.28972222222222221,300,200,9,1,null,null,65,"GT 530-10","gaz",522,580,990,0.27500000000000002,350,207,0,65,null,"GT 530-10","gaz",522,580]
[{"$f":"A69+L70","v":63},573,"C 310-570 Eco","gaz",113,573,907,0.25194444444444447,250,null,null,{"$f":"IF($B$4<=F70,1,0)","v":1},null,null,66,"GT 530-11","fioul",580,638,1080,0.3,350,206,0,66,null,{"$f":"IF(ISNA(P70)=TRUE,\"hors gamme\",P70)","v":"GT 530-11"},"fioul",580,638]
[64,580,"GT 530-10","fioul",522,580,990,0.27500000000000002,350,207,null,1,null,null,67,"GT 530-11","gaz",580,638,1080,0.3,350,206,0,67,null,{"$f":"IF(ISNA(P71)=TRUE,\"hors gamme\",P71)","v":"GT 530-11"},"gaz",580,638]
[65,580,"GT 530-10","gaz",522,580,990,0.27500000000000002,350,207,null,1,null,null,68,"GT 430-13","fioul",{"$f":"VLOOKUP(O72,$A$8:$L$110,5,FALSE)","v":570},{"$f":"VLOOKUP(O72,$A$8:$L$110,6,FALSE)","v":645},{"$f":"VLOOKUP(O72,$A$8:$L$110,7,FALSE)","v":1071},{"$f":"VLOOKUP(O72,$A$8:$L$110,8,FALSE)","v":0.29749999999999999},{"$f":"VLOOKUP(O72,$A$8:$L$110,9,FALSE)","v":300},{"$f":"VLOOKUP(O72,$A$8:$L$110,10,FALSE)","v":200},{"$f":"VLOOKUP(O72,$A$8:$L$110,11,FALSE)","v":13},68,null,{"$f":"IF(ISNA(P72)=TRUE,\"hors gamme\",P72)","v":"GT 430-13"},"fioul",570,645]
[66,638,"GT 530-11","fioul",580,638,1080,0.3,350,206,null,1,null,null,69,{"$f":"VLOOKUP(O73,$A$8:$K$110,3,FALSE)","v":"GT 430-13"},{"$f":"VLOOKUP(O73,$A$8:$K$110,4,FALSE)","v":"gaz"},570,645,1180,0.32777777777777778,300,200,9,69,null,{"$f":"IF(ISNA(P73)=TRUE,\"hors gamme\",P73)","v":"GT 430-13"},"gaz",570,645]
[67,638,"GT 530-11","gaz",580,638,1080,0.3,350,206,null,1,null,null,70,"GT 530-12","fioul",638,696,1175,0.3263888888888889,350,205,0,70,null,{"$f":"IF(ISNA(P74)=TRUE,\"hors gamme\",P74)","v":"GT 530-12"},"fioul",638,696]
[68,645,"GT 430-13","fioul",570,645,1071,0.29749999999999999,300,200,13,1,null,null,71,"GT 530-12","gaz",638,696,1175,0.3263888888888889,350,205,0,71,null,"GT 530-12","gaz",638,696]
[69,645,"GT 430-13","gaz",570,645,1180,0.32777777777777778,300,200,9,1,null,null,72,"GT 430-14","fioul",645,700,1163,0.32305555555555554,300,200,13,72,null,"GT 430-14","fioul",645,700]
[70,696,"GT 530-12","fioul",638,696,1175,0.3263888888888889,350,205,null,1,null,null,73,"GT 430-14","gaz",645,700,1280,0.35555555555555557,300,200,9,73,null,"GT 430-14","gaz",645,700]
[71,696,"GT 530-12","gaz",638,696,1175,0.3263888888888889,350,205,null,1,null,null,74,"C 610-700 Eco","gaz",94,706,1130,0.31388888888888888,350,0,0,74,null,"C 610-700 Eco","gaz",94,706]
[72,700,"GT 430-14","fioul",645,700,1163,0.32305555555555554,300,200,13,1,null,null,75,"GT 530-13","fioul",696,754,1275,0.35416666666666669,350,204,0,75,null,"GT 530-13","fioul",696,754]
[73,700,"GT 430-14","gaz",645,700,1280,0.35555555555555557,300,200,9,1,null,null,76,"GT 530-13","gaz",696,754,1275,0.35416666666666669,350,204,0,76,null,"GT 530-13","gaz",696,754]
[74,706,"C 610-700 Eco","gaz",94,706,1130,0.31388888888888888,350,null,null,1,null,null,77,"GT 530-14","fioul",754,812,1370,0.38055555555555554,400,203,0,77,null,"GT 530-14","fioul",754,812]
[75,754,"GT 530-13","fioul",696,754,1275,0.35416666666666669,350,204,null,1,null,null,78,"GT 530-14","gaz",754,812,1370,0.38055555555555554,400,203,0,78,null,"GT 530-14","gaz",754,812]
[76,754,"GT 530-13","gaz",696,754,1275,0.35416666666666669,350,204,null,1,null,null,79,"C 610-860 Eco","gaz",131,854,1360,0.37777777777777777,350,0,0,79,null,"C 610-860 Eco","gaz",131,854]
[77,812,"GT 530-14","fioul",754,812,1370,0.38055555555555554,400,203,null,1,null,null,80,"GT 530-15","fioul",812,870,1465,0.40694444444444444,400,202,0,80,null,"GT 530-15","fioul",812,870]
[78,812,"GT 530-14","gaz",754,812,1370,0.38055555555555554,400,203,null,1,null,null,81,"GT 530-15","gaz",812,870,1465,0.40694444444444444,400,202,0,81,null,"GT 530-15","gaz",812,870]
[79,854,"C 610-860 Eco","gaz",131,854,1360,0.37777777777777777,350,null,null,1,null,null,82,"GT 530-16","fioul",870,928,1560,0.43333333333333335,400,202,0,82,null,"GT 530-16","fioul",870,928]
[80,870,"GT 530-15","fioul",812,870,1465,0.40694444444444444,400,202,null,1,null,null,83,"GT 530-16","gaz",870,928,1560,0.43333333333333335,400,202,0,83,null,{"$f":"IF(ISNA(P87)=TRUE,\"hors gamme\",P87)","v":"GT 530-16"},"gaz",870,928]
[81,870,"GT 530-15","gaz",812,870,1465,0.40694444444444444,400,202,null,1,null,null,84,"GT 530-17","fioul",928,986,1650,0.45833333333333331,400,202,0,84,null,{"$f":"IF(ISNA(P88)=TRUE,\"hors gamme\",P88)","v":"GT 530-17"},"fioul",928,986]
[82,928,"GT 530-16","fioul",870,928,1560,0.43333333333333335,400,202,null,1,null,null,85,"GT 530-17","gaz",928,986,1650,0.45833333333333331,400,202,0,85,null,"GT 530-17","gaz",928,986]
[83,928,"GT 530-16","gaz",870,928,1560,0.43333333333333335,400,202,null,1,null,null,86,"C 610-1000 Eco","gaz",130,998,1586,0.44055555555555553,350,0,0,86,null,"C 610-1000 Eco","gaz",130,998]
[84,986,"GT 530-17","fioul",928,986,1650,0.45833333333333331,400,202,null,1,null,null,87,"GT 530-18","fioul",986,1044,1750,0.4861111111111111,400,201,0,87,null,"GT 530-18","fioul",986,1044]
[85,986,"GT 530-17","gaz",928,986,1650,0.45833333333333331,400,202,null,1,null,null,88,"GT 530-18","gaz",986,1044,1750,0.4861111111111111,400,201,0,88,null,"GT 530-18","gaz",986,1044]
[86,998,"C 610-1000 Eco","gaz",130,998,1586,0.44055555555555553,350,null,null,1,null,null,89,"GT 530-19","fioul",1044,1102,1840,0.51111111111111107,400,201,0,89,null,"GT 530-19","fioul",1044,1102]
[87,1044,"GT 530-18","fioul",986,1044,1750,0.4861111111111111,400,201,null,1,null,null,90,"GT 530-19","gaz",1044,1102,1840,0.51111111111111107,400,201,0,90,null,"GT 530-19","gaz",1044,1102]
[88,1044,"GT 530-18","gaz",986,1044,1750,0.4861111111111111,400,201,null,1,null,null,91,"C 610-1140 Eco","gaz",156,1146,1814,0.50388888888888894,350,0,0,91,null,"C 610-1140 Eco","gaz",156,1146]
[89,1102,"GT 530-19","fioul",1044,1102,1840,0.51111111111111107,400,201,null,1,null,null,92,"GT 530-20","fioul",1102,1160,1930,0.53611111111111109,400,201,0,92,null,"GT 530-20","fioul",1102,1160]
[90,1102,"GT 530-19","gaz",1044,1102,1840,0.51111111111111107,400,201,null,1,null,null,93,"GT 530-20","gaz",1102,1160,1930,0.53611111111111109,400,201,0,93,null,"GT 530-20","gaz",1102,1160]
[91,1146,"C 610-1140 Eco","gaz",156,1146,1814,0.50388888888888894,350,null,null,1,null,null,94,"GT 530-21","fioul",1160,1218,2030,0.56388888888888888,500,201,0,94,null,"GT 530-21","fioul",1160,1218]
[92,1160,"GT 530-20","fioul",1102,1160,1930,0.53611111111111109,400,201,null,1,null,null,95,"GT 530-21","gaz",1160,1218,2030,0.56388888888888888,500,201,0,95,null,{"$f":"IF(ISNA(P99)=TRUE,\"hors gamme\",P99)","v":"GT 530-21"},{"$f":"IF(ISNA(Q99)=TRUE,\"\",Q99)","v":"gaz"},1160,1218]
[93,1160,"GT 530-20","gaz",1102,1160,1930,0.53611111111111109,400,201,null,1,null,null,96,"GT 530-22","fioul",1218,1276,2125,0.59027777777777779,500,201,0,96,null,{"$f":"IF(ISNA(P100)=TRUE,\"hors gamme\",P100)","v":"GT 530-22"},"fioul",1218,1276]
[94,1218,"GT 530-21","fioul",1160,1218,2030,0.56388888888888888,500,201,null,1,null,null,97,"GT 530-22","gaz",1218,1276,2125,0.59027777777777779,500,201,0,97,null,"GT 530-22","gaz",1218,1276]
[95,1218,"GT 530-21","gaz",1160,1218,2030,0.56388888888888888,500,201,null,1,null,null,98,"GT 530-23","fioul",1276,1334,2225,0.61805555555555558,500,200,0,98,null,"GT 530-23","fioul",1276,1334]
[96,1276,"GT 530-22","fioul",1218,1276,2125,0.59027777777777779,500,201,null,1,null,null,99,"GT 530-23","gaz",1276,1334,2225,0.61805555555555558,500,200,0,99,null,"GT 530-23","gaz",1276,1334]
[97,1276,"GT 530-22","gaz",1218,1276,2125,0.59027777777777779,500,201,null,1,null,null,100,"GT 530-24","fioul",{"$f":"VLOOKUP(O104,$A$8:$L$110,5,FALSE)","v":1334},{"$f":"VLOOKUP(O104,$A$8:$L$110,6,FALSE)","v":1392},{"$f":"VLOOKUP(O104,$A$8:$L$110,7,FALSE)","v":2330},{"$f":"VLOOKUP(O104,$A$8:$L$110,8,FALSE)","v":0.64722222222222225},{"$f":"VLOOKUP(O104,$A$8:$L$110,9,FALSE)","v":500},{"$f":"VLOOKUP(O104,$A$8:$L$110,10,FALSE)","v":200},{"$f":"VLOOKUP(O104,$A$8:$L$110,11,FALSE)","v":0},100,null,"GT 530-24","fioul",1334,1392]
[98,1334,"GT 530-23","fioul",1276,1334,2225,0.61805555555555558,500,200,null,1,null,null,101,{"$f":"VLOOKUP(O105,$A$8:$K$110,3,FALSE)","v":"GT 530-24"},{"$f":"VLOOKUP(O105,$A$8:$K$110,4,FALSE)","v":"gaz"},1334,1392,2330,0.64722222222222225,500,200,0,101,null,"GT 530-24","gaz",1334,1392]
[99,1334,"GT 530-23","gaz",1276,1334,2225,0.61805555555555558,500,200,null,1,null,null,102,"GT 530-25","fioul",1392,1450,2430,0.67500000000000004,500,200,0,102,null,"GT 530-25","fioul",1392,1450]
[100,1392,"GT 530-24","fioul",1334,1392,2330,0.64722222222222225,500,200,null,1,null,null,103,"GT 530-25","gaz",1392,1450,2430,0.67500000000000004,500,200,0,103,null,"GT 530-25","gaz",1392,1450]
[101,1392,"GT 530-24","gaz",1334,1392,2330,0.64722222222222225,500,200,null,1,null,null,104,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},104,null,"hors gamme","","",""]
[102,1450,"GT 530-25","fioul",1392,1450,2430,0.67500000000000004,500,200,null,1,null,null,105,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},105,null,"hors gamme","","",""]
[103,1450,"GT 530-25","gaz",1392,1450,2430,{"$f":"G110/3600","v":0.67500000000000004},500,200,null,{"$f":"IF($B$4<=F110,1,0)","v":1},null,null,106,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},106,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},107,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},108,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},109,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},110,null,{"$f":"IF(ISNA(P114)=TRUE,\"hors gamme\",P114)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},111,null,{"$f":"IF(ISNA(P115)=TRUE,\"hors gamme\",P115)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},112,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},113,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},114,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},115,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},116,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},117,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},118,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},119,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},120,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},121,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,122,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},122,null,{"$f":"IF(ISNA(P126)=TRUE,\"hors gamme\",P126)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,123,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},123,null,{"$f":"IF(ISNA(P127)=TRUE,\"hors gamme\",P127)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,124,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},124,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},125,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},126,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},127,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},128,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},129,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},130,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},131,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"VLOOKUP(O136,$A$8:$L$110,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,9,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,10,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O136,$A$8:$L$110,11,FALSE)","v":{"$error":"#N/A"}},132,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,{"$f":"VLOOKUP(O137,$A$8:$K$110,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O137,$A$8:$K$110,4,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},133,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,134,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},134,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,135,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},135,null,{"$f":"IF(ISNA(P139)=TRUE,\"hors gamme\",P139)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,136,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},136,null,{"$f":"IF(ISNA(P140)=TRUE,\"hors gamme\",P140)","v":"hors gamme"},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},137,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,138,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},138,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},139,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},140,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},141,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},142,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},143,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,144,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},144,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},145,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},146,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},147,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,148,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},148,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},149,null,"hors gamme","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},150,null,"hors gamme","","",""]

{"sheet":"Base","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Base Tubes ACIER","(à masquer)","(à masquer)"]
["Diamètre réel int.","valeurs décaleés","Réf décalées","Référence"]
[0,13.2,"AC - 17.2 * 2"]
[13.2,16.7,"AC - 21.3 * 2.3","AC - 17.2 * 2"]
[16.7,22.3,"AC - 26.9 * 2.3","AC - 21.3 * 2.3"]
[22.3,27.9,"AC - 33.7 * 2.9","AC - 26.9 * 2.3"]
[27.9,36.6,"AC - 42.4 * 2.9","AC - 33.7 * 2.9"]
[36.6,42.5,"AC - 48.3 * 2.9","AC - 42.4 * 2.9"]
[42.5,53.9,"AC - 60.3 * 3.2","AC - 48.3 * 2.9"]
[53.9,63.6,"AC - 70.0 * 3.2","AC - 60.3 * 3.2"]
[63.6,69.7,"AC - 76.1 * 3.2","AC - 70.0 * 3.2"]
[69.7,82.5,"AC - 88.9 * 3.2","AC - 76.1 * 3.2"]
[82.5,94.4,"AC - 101.6 * 3.6","AC - 88.9 * 3.2"]
[94.4,100.8,"AC - 108 * 3.6","AC - 101.6 * 3.6"]
[100.8,107.1,"AC - 114.3 * 3.6","AC - 108 * 3.6"]
[107.1,125,"AC - 133 * 4.0","AC - 114.3 * 3.6"]
[125,131.69999999999999,"AC - 139.7 * 4.0","AC - 133 * 4.0"]
[131.69999999999999,150,"AC - 159 * 4.5","AC - 139.7 * 4.0"]
[150,159.30000000000001,"AC - 168.3 * 4.5","AC - 159 * 4.5"]
[159.30000000000001,183.1,"AC - 193.7 * 5.4","AC - 168.3 * 4.5"]
[183.1,207.3,"AC - 219.1 * 5.9","AC - 193.7 * 5.4"]
[207.3,231.9,"AC - 244.5 * 6.3","AC - 219.1 * 5.9"]
[231.9,260.39999999999998,"AC - 273 * 6.3","AC - 244.5 * 6.3"]
[260.39999999999998,309.7,"AC - 323.9 * 7.1","AC - 273 * 6.3"]
[309.7,339.6,"AC - 355.6 * 8.0","AC - 323.9 * 7.1"]
[339.6,352,"AC - 368 * 8.0","AC - 355.6 * 8.0"]
[352,388.8,"AC - 406.4 * 8.8","AC - 368 * 8.0"]
[388.8,399,"AC - 419 * 10.0 ","AC - 406.4 * 8.8"]
[399,null,null,"AC - 419 * 10.0 "]

{"sheet":"MAJ","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Auteur","MAJ"]
["2018-04-05","Alexandre Diebold","Création outil à partir d'une ancienne version"]