{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Données-Résultats","MAJ","Base de données","calculs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Données-Résultats","index":0,"n_rows":122,"n_cols":11,"rows_kept":122,"cut":false,"hidden":false,"merged":[[5,3,5,10],[6,3,6,10],[7,3,7,10]]}
[]
[null,null,null,null,null,null,null,"Calcul pratique Fluides / Utilitaires"]
[null,null,null,null,null,null,null," Débit - Diamètre - Vitesse"]
[null,null,null,null,null,null,null,null,null,null,"Version 04/2020"]
[]
[]
[null,"?"," Références du projet"]
[]
[]
[null,null,"Données / Résultats"]
[]
[]
[null,null,"Type de tube",null,null,null,"Acier"]
[null,null,"Choix de l'unité du débit ",null,null,null,"m3/h","?"]
[]
[null,null,"Désignation","Symbole","Unité"]
[null,null,"Débit de circulation","qv",{"$f":"IF(G14=\"m3/h\",\"m3/h\",IF(G14=\"l/h\",\"l/h\",\"-\"))","v":"m3/h"},":",0]
[null,null,"Vitesse de circulation","v","m/s",":",0]
[]
[null,null,"Diamètre intérieur ","fi","mm","=",{"$f":"calculs!E27","v":0}]
[null,null,"Diamètre référence","fr","mm",null,{"$f":"IF(I21=\"Diamètre hors standard !\",\"--------\",calculs!E31)","v":0},null,{"$f":"calculs!E35","v":0}]
[]
[]
[null,null,"Vitesse de circulation","v","m/s",":",0]
[null,null,"Diamètre référence","fr","mm",":","AC - 26.9 * 2.3"]
[null,null,"Diamètre intérieur ","fi","mm",null,{"$f":"calculs!F14","v":22.3}]
[]
[null,null,"Débit de circulation","qv",{"$f":"IF(G14=\"m3/h\",\"m3/h\",IF(G14=\"l/h\",\"l/h\",\"-\"))","v":"m3/h"},"=",{"$f":"calculs!F22","v":0}]
[]
[null,null,"Débit de circulation","qv",{"$f":"IF(G14=\"m3/h\",\"m3/h\",IF(G14=\"l/h\",\"l/h\",\"-\"))","v":"m3/h"},":",0]
[null,null,"Diamètre référence","fr","mm",":","AC - 17.2 * 2"]
[null,null,"Diamètre intérieur ","fi","mm",null,{"$f":"calculs!G14","v":13.2}]
[]
[null,null,"Vitesse de circulation","v","m/s","=",{"$f":"calculs!G24","v":0}]
[]
[]
[null,null,"Cas de la vitesse silencieuse"]
[null,null,"Diamètre référence","fr","mm",":","AC - 17.2 * 2"]
[null,null,"Diamètre intérieur ","fi","mm",null,{"$f":"calculs!H14","v":13.2}]
[]
[null,null,"Vitesse de circulation","v","m/s","=",{"$f":"calculs!H25","v":0.51380930314660522}]
[]
[null,null,"Débit de circulation","qv",{"$f":"IF(G14=\"m3/h\",\"m3/h\",IF(G14=\"l/h\",\"l/h\",\"-\"))","v":"m3/h"},":",0]
[]
[null,null,"Diamètre intérieur ","fi","mm","=",{"$f":"calculs!I26","v":0}]
[null,null,"Diamètre référence","fr","mm",null,{"$f":"IF(I46=\"Diamètre hors standard !\",\"--------\",calculs!I31)","v":0},null,{"$f":"calculs!I35","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"liste saisie 1","d int"]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 12 * 1.1\",IF(calculs!$E$7=\"Acier\",\"AC - 17.2 * 2\",IF(calculs!$E$7=\"Cuivre\",\"CU - 12 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 17.2 * 2"},{"$f":"IF(calculs!$E$7=\"PER\",9.8,IF(calculs!$E$7=\"Acier\",13.2,IF(calculs!$E$7=\"Cuivre\",10,IF(calculs!$E$7=\"-\",\"-\"))))","v":13.2}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 16 * 1.5\",IF(calculs!$E$7=\"Acier\",\"AC - 21.3 * 2.3\",IF(calculs!$E$7=\"Cuivre\",\"CU - 14 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 21.3 * 2.3"},{"$f":"IF(calculs!$E$7=\"PER\",13,IF(calculs!$E$7=\"Acier\",16.7,IF(calculs!$E$7=\"Cuivre\",12,IF(calculs!$E$7=\"-\",\"-\"))))","v":16.7}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 20 * 1.9\",IF(calculs!$E$7=\"Acier\",\"AC - 26.9 * 2.3\",IF(calculs!$E$7=\"Cuivre\",\"CU - 15 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 26.9 * 2.3"},{"$f":"IF(calculs!$E$7=\"PER\",16.2,IF(calculs!$E$7=\"Acier\",22.3,IF(calculs!$E$7=\"Cuivre\",13,IF(calculs!$E$7=\"-\",\"-\"))))","v":22.3}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 25 * 2.3\",IF(calculs!$E$7=\"Acier\",\"AC - 33.7 * 2.9\",IF(calculs!$E$7=\"Cuivre\",\"CU - 16 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 33.7 * 2.9"},{"$f":"IF(calculs!$E$7=\"PER\",20.4,IF(calculs!$E$7=\"Acier\",27.9,IF(calculs!$E$7=\"Cuivre\",14,IF(calculs!$E$7=\"-\",\"-\"))))","v":27.9}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 32 * 2.9\",IF(calculs!$E$7=\"Acier\",\"AC - 42.4 * 2.9\",IF(calculs!$E$7=\"Cuivre\",\"CU - 18 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 42.4 * 2.9"},{"$f":"IF(calculs!$E$7=\"PER\",26.2,IF(calculs!$E$7=\"Acier\",36.6,IF(calculs!$E$7=\"Cuivre\",16,IF(calculs!$E$7=\"-\",\"-\"))))","v":36.6}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 40 * 3.7\",IF(calculs!$E$7=\"Acier\",\"AC - 48.3 * 2.9\",IF(calculs!$E$7=\"Cuivre\",\"CU - 20 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 48.3 * 2.9"},{"$f":"IF(calculs!$E$7=\"PER\",32.6,IF(calculs!$E$7=\"Acier\",42.5,IF(calculs!$E$7=\"Cuivre\",18,IF(calculs!$E$7=\"-\",\"-\"))))","v":42.5}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 50 * 4.6\",IF(calculs!$E$7=\"Acier\",\"AC - 60.3 * 3.2\",IF(calculs!$E$7=\"Cuivre\",\"CU - 22 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 60.3 * 3.2"},{"$f":"IF(calculs!$E$7=\"PER\",40.8,IF(calculs!$E$7=\"Acier\",53.9,IF(calculs!$E$7=\"Cuivre\",20,IF(calculs!$E$7=\"-\",\"-\"))))","v":53.9}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 63 * 5.8\",IF(calculs!$E$7=\"Acier\",\"AC - 70.0 * 3.2\",IF(calculs!$E$7=\"Cuivre\",\"CU - 25 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 70.0 * 3.2"},{"$f":"IF(calculs!$E$7=\"PER\",51.4,IF(calculs!$E$7=\"Acier\",63.6,IF(calculs!$E$7=\"Cuivre\",23,IF(calculs!$E$7=\"-\",\"-\"))))","v":63.6}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 75 * 6.8\",IF(calculs!$E$7=\"Acier\",\"AC - 76.1 * 3.2\",IF(calculs!$E$7=\"Cuivre\",\"CU - 28 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 76.1 * 3.2"},{"$f":"IF(calculs!$E$7=\"PER\",61.4,IF(calculs!$E$7=\"Acier\",69.7,IF(calculs!$E$7=\"Cuivre\",26,IF(calculs!$E$7=\"-\",\"-\"))))","v":69.7}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 90 * 8.2\",IF(calculs!$E$7=\"Acier\",\"AC - 88.9 * 3.2\",IF(calculs!$E$7=\"Cuivre\",\"CU - 30 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 88.9 * 3.2"},{"$f":"IF(calculs!$E$7=\"PER\",73.6,IF(calculs!$E$7=\"Acier\",82.5,IF(calculs!$E$7=\"Cuivre\",28,IF(calculs!$E$7=\"-\",\"-\"))))","v":82.5}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"PER - 110 * 10\",IF(calculs!$E$7=\"Acier\",\"AC - 101.6 * 3.6\",IF(calculs!$E$7=\"Cuivre\",\"CU - 32 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 101.6 * 3.6"},{"$f":"IF(calculs!$E$7=\"PER\",90,IF(calculs!$E$7=\"Acier\",94.4,IF(calculs!$E$7=\"Cuivre\",30,IF(calculs!$E$7=\"-\",\"-\"))))","v":94.4}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 108 * 3.6\",IF(calculs!$E$7=\"Cuivre\",\"CU - 36 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 108 * 3.6"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",100.8,IF(calculs!$E$7=\"Cuivre\",34,IF(calculs!$E$7=\"-\",\"-\"))))","v":100.8}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 114.3 * 3.6\",IF(calculs!$E$7=\"Cuivre\",\"CU - 38 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 114.3 * 3.6"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",107.1,IF(calculs!$E$7=\"Cuivre\",36,IF(calculs!$E$7=\"-\",\"-\"))))","v":107.1}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 133 * 4.0\",IF(calculs!$E$7=\"Cuivre\",\"CU - 40 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 133 * 4.0"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",125,IF(calculs!$E$7=\"Cuivre\",38,IF(calculs!$E$7=\"-\",\"-\"))))","v":125}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 139.7 * 4.0\",IF(calculs!$E$7=\"Cuivre\",\"CU - 42 * 1.0\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 139.7 * 4.0"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",131.7,IF(calculs!$E$7=\"Cuivre\",40,IF(calculs!$E$7=\"-\",\"-\"))))","v":131.69999999999999}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 159 * 4.5\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 159 * 4.5"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",150,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":150}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 168.3 * 4.5\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 168.3 * 4.5"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",159.3,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":159.30000000000001}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 193.7 * 5.4\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 193.7 * 5.4"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",183.1,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":183.1}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 219.1 * 5.9\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 219.1 * 5.9"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",207.3,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":207.3}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 244.5 * 6.3\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 244.5 * 6.3"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",231.9,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":231.9}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 273 * 6.3\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 273 * 6.3"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",260.4,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":260.39999999999998}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 323.9 * 7.1\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 323.9 * 7.1"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",309.7,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":309.7}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 355.6 * 8.0\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 355.6 * 8.0"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",339.6,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":339.6}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 368 * 8.0\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 368 * 8.0"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",352,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":352}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 406.4 * 8.8\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 406.4 * 8.8"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",388.8,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":388.8}]
[null,null,{"$f":"IF(calculs!$E$7=\"PER\",\"-\",IF(calculs!$E$7=\"Acier\",\"AC - 419 * 10.0\",IF(calculs!$E$7=\"Cuivre\",\"-\",IF(calculs!$E$7=\"-\",\"-\",))))","v":"AC - 419 * 10.0"},{"$f":"IF(calculs!$E$7=\"PER\",\"\",IF(calculs!$E$7=\"Acier\",399,IF(calculs!$E$7=\"Cuivre\",\"\",IF(calculs!$E$7=\"-\",\"-\"))))","v":399}]

{"sheet":"MAJ","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date ","Auteur","MAJ"]
["2018-04-06","Alexandre Diebold","Restructuration outil"]

{"sheet":"Base de données","index":2,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[]
["Base Tubes PER","(à masquer)","(à masquer)"]
["Diamètre réel int.","valeurs décaleés","Réf décalées","Référence"]
[0,9.8000000000000007,"PER - 12 * 1.1"]
[9.8000000000000007,13,"PER - 16 * 1.5","PER - 12 * 1.1"]
[13,16.2,"PER - 20 * 1.9","PER - 16 * 1.5"]
[16.2,20.399999999999999,"PER - 25 * 2.3","PER - 20 * 1.9"]
[20.399999999999999,26.2,"PER - 32 * 2.9","PER - 25 * 2.3"]
[26.2,32.6,"PER - 40 * 3.7","PER - 32 * 2.9"]
[32.6,40.799999999999997,"PER - 50 * 4.6","PER - 40 * 3.7"]
[40.799999999999997,51.4,"PER - 63 * 5.8","PER - 50 * 4.6"]
[51.4,61.4,"PER - 75 * 6.8","PER - 63 * 5.8"]
[61.4,73.599999999999994,"PER - 90 * 8.2","PER - 75 * 6.8"]
[73.599999999999994,90,"PER - 110 * 10","PER - 90 * 8.2"]
[90,null,null,"PER - 110 * 10"]
[]
["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 "]
[]
["Base Tubes CUIVRE","(à masquer)","(à masquer)"]
["Diamètre réel int.","valeurs décaleés","Réf décalées","Référence"]
[0,10,"CU - 12 * 1.0"]
[10,12,"CU - 14 * 1.0","CU - 12 * 1.0"]
[12,13,"CU - 15 * 1.0","CU - 14 * 1.0"]
[13,14,"CU - 16 * 1.0","CU - 15 * 1.0"]
[14,16,"CU - 18 * 1.0","CU - 16 * 1.0"]
[16,18,"CU - 20 * 1.0","CU - 18 * 1.0"]
[18,20,"CU - 22 * 1.0","CU - 20 * 1.0"]
[20,23,"CU - 25 * 1.0","CU - 22 * 1.0"]
[23,26,"CU - 28 * 1.0","CU - 25 * 1.0"]
[26,28,"CU - 30 * 1.0","CU - 28 * 1.0"]
[28,30,"CU - 32 * 1.0","CU - 30 * 1.0"]
[30,34,"CU - 36 * 1.0","CU - 32 * 1.0"]
[34,36,"CU - 38 * 1.0","CU - 36 * 1.0"]
[36,38,"CU - 40 * 1.0","CU - 38 * 1.0"]
[38,40,"CU - 42 * 1.0","CU - 40 * 1.0"]
[40,null,null,"CU - 42 * 1.0"]

{"sheet":"calculs","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[[32,8,33,8],[34,4,35,4],[34,5,35,5],[34,6,35,6],[34,7,35,7],[34,8,35,8],[32,4,33,4],[32,5,33,5],[32,6,33,6],[32,7,33,7]]}
[]
[]
[]
[]
["Données "]
[]
["Type de tube",null,null,null,{"$f":"'Données-Résultats'!G13","v":"Acier"}]
["unité du débit",null,null,null,{"$f":"'Données-Résultats'!G14","v":"m3/h"}]
["Désignation","Symbole","Unité",null,null,null,null,"Cas de la vitesse silencieuse"]
["Débit","qv","l/h",":",{"$f":"IF(E8=\"l/h\",'Données-Résultats'!G17,'Données-Résultats'!G17*1000)","v":0},null,{"$f":"IF(E8=\"l/h\",'Données-Résultats'!G30,'Données-Résultats'!G30*1000)","v":0},null,{"$f":"IF(E8=\"l/h\",'Données-Résultats'!G43,'Données-Résultats'!G43*1000)","v":0}]
["Vitesse","v","m/s",":",{"$f":"'Données-Résultats'!G18","v":0},{"$f":"'Données-Résultats'!G24","v":0}]
["Diamètre intérieur théorique","qi","mm",":",null,{"$f":"'Données-Résultats'!G26","v":22.3},{"$f":"'Données-Résultats'!G32","v":13.2},{"$f":"'Données-Résultats'!G39","v":13.2}]
["Diamètre int. Réel","qir","mm",":",null,{"$f":"VLOOKUP(F15,'Données-Résultats'!$C$97:$D$202,2,0)","v":22.3},{"$f":"VLOOKUP(G15,'Données-Résultats'!$C$97:$D$202,2,0)","v":13.2},{"$f":"VLOOKUP(H15,'Données-Résultats'!$C$97:$D$202,2,0)","v":13.2}]
[null,null,null,null,null,{"$f":"IF(OR('Données-Résultats'!G25=\"-\",$E$8=\"-\"),0,F13)","v":22.3},{"$f":"IF(OR('Données-Résultats'!G31=\"-\",$E$8=\"-\"),0,G13)","v":13.2},{"$f":"IF(OR('Données-Résultats'!G38=\"-\",$E$8=\"-\"),0,H13)","v":13.2}]
[null,null,null,":",null,{"$f":"'Données-Résultats'!G25","v":"AC - 26.9 * 2.3"},{"$f":"'Données-Résultats'!G31","v":"AC - 17.2 * 2"},{"$f":"'Données-Résultats'!G38","v":"AC - 17.2 * 2"}]
["Diamètre référence","qr","mm",":"]
[]
["Résultats "]
["Désignation","Symbole","Unité",null,null,null,null,"Cas de la vitesse silencieuse"]
["Débit","qv","l/h","=",null,{"$f":"IF(E8=\"l/h\",F12^2*F11*2.82,F12^2*F11*2.82/1000)","v":0}]
[null,null,null,null,null,{"$f":"IF(E8=\"l/h\",ROUND(F20,0),ROUND(F20,2))","v":0}]
[null,null,null,null,null,{"$f":"IF(OR($E$7=\"-\",$E$8=\"-\"),0,F21)","v":0}]
["Vitesse","v","m/s","=",null,null,{"$f":"0.354*G10*G12^-2","v":0},{"$f":"(H12/50)^0.5","v":0.51380930314660522}]
[null,null,null,null,null,null,{"$f":"IF(OR(G10=0,G12=0),0,G23)","v":0},{"$f":"IF(H12=0,0,H23)","v":0.51380930314660522}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($E$7=\"-\",$E$8=\"-\"),0,H24)","v":0.51380930314660522}]
["Diamètre intérieur théorique","qi","mm","=",{"$f":" 0.595*(E10/E11)^0.5","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"1.44*I10^0.4","v":0}]
[null,null,null,null,{"$f":"IF(OR(E10=0,E11=0),0,E26)","v":0}]
["Diamètre int. Réel","qir","mm","=",{"$f":"C41","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"C53","v":0}]
[null,null,null,null,{"$f":"IF(OR(E10=0,E11=0),0,E28)","v":0}]
["Diamètre référence","qr","mm","=",{"$f":"D41","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D53","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"IF(OR(E10=0,E11=0),0,E30)","v":0},null,null,null,{"$f":"IF(I10=0,0,I30)","v":0}]
[]
["Mise en garde",null,null,null,{"$f":"IF(AND($E$7=\"Cuivre\",E27>40),\"Diamètre hors standard !\",IF(AND($E$7=\"PER\",E27>90),\"Diamètre hors standard !\",IF(AND($E$7=\"Acier\",E27>399),\"Diamètre hors standard !\",0)))","v":0},null,null,null,{"$f":"IF(AND($E$7=\"Cuivre\",I26>40),\"Diamètre hors standard !\",IF(AND($E$7=\"PER\",I26>90),\"Diamètre hors standard !\",IF(AND($E$7=\"Acier\",I26>399),\"Diamètre hors standard !\",0)))","v":0}]
[]
[null,null,null,null,{"$f":"IF(E33=\"FAUX\",0,E33)","v":0},null,null,null,{"$f":"IF(I33=\"FAUX\",0,I33)","v":0}]
[]
[]
[]
[]
["diamètre 1 calculé","valeur proche inf.","diam. Int. Réel","ref"]
[{"$f":"E26","v":{"$error":"#DIV/0!"}},{"$f":"IF(E7=\"PER\",VLOOKUP(A41,'Base de données'!A4:A15,1,TRUE),IF(E7=\"acier\",VLOOKUP(A41,'Base de données'!A19:A45,1,TRUE),IF(E7=\"cuivre\",VLOOKUP(A41,'Base de données'!A49:A64,1,TRUE))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(A41=B41,B41,IF(E7=\"PER\",VLOOKUP(A41,'Base de données'!A4:B14,2,TRUE),IF(E7=\"acier\",VLOOKUP(A41,'Base de données'!A19:B44,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(A41,'Base de données'!A49:B63,2,TRUE)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E7=\"PER\",VLOOKUP(C41,'Base de données'!B4:C15,2,TRUE),IF(E7=\"acier\",VLOOKUP(C41,'Base de données'!B19:C45,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(C41,'Base de données'!B49:C64,2,TRUE))))","v":{"$error":"#DIV/0!"}}]
[]
["diamètre 2 saisi","valeur proche inf.","diam. Int. Réel","ref"]
[{"$f":"F12","v":22.3},{"$f":"IF(E7=\"PER\",VLOOKUP(A44,'Base de données'!A4:A15,1,TRUE),IF(E7=\"acier\",VLOOKUP(A44,'Base de données'!A19:A45,1,TRUE),IF(E7=\"cuivre\",VLOOKUP(A44,'Base de données'!A49:A64,1,TRUE))))","v":22.3},{"$f":"IF(A44=B44,B44,IF(E7=\"PER\",VLOOKUP(A44,'Base de données'!A4:B14,2,TRUE),IF(E7=\"acier\",VLOOKUP(A44,'Base de données'!A19:B44,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(A44,'Base de données'!A49:B63,2,TRUE)))))","v":22.3},{"$f":"IF(E7=\"PER\",VLOOKUP(C44,'Base de données'!B4:C15,2,TRUE),IF(E7=\"acier\",VLOOKUP(C44,'Base de données'!B19:C45,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(C44,'Base de données'!B49:C64,2,TRUE))))","v":"AC - 26.9 * 2.3"}]
[]
["diamètre 3 saisi","valeur proche inf.","diam. Int. Réel","ref"]
[{"$f":"G12","v":13.2},{"$f":"IF(E7=\"PER\",VLOOKUP(A47,'Base de données'!A4:A15,1,TRUE),IF(E7=\"acier\",VLOOKUP(A47,'Base de données'!A19:A45,1,TRUE),IF(E7=\"cuivre\",VLOOKUP(A47,'Base de données'!A49:A64,1,TRUE))))","v":13.2},{"$f":"IF(A47=B47,B47,IF(E7=\"PER\",VLOOKUP(A47,'Base de données'!A4:B14,2,TRUE),IF(E7=\"acier\",VLOOKUP(A47,'Base de données'!A19:B44,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(A47,'Base de données'!A49:B63,2,TRUE)))))","v":13.2},{"$f":"IF(E7=\"PER\",VLOOKUP(C47,'Base de données'!B4:C15,2,TRUE),IF(E7=\"acier\",VLOOKUP(C47,'Base de données'!B19:C45,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(C47,'Base de données'!B49:C64,2,TRUE))))","v":"AC - 17.2 * 2"}]
[]
["diamètre 4 saisi","valeur proche inf.","diam. Int. Réel","ref"]
[{"$f":"H12","v":13.2},{"$f":"IF(E7=\"PER\",VLOOKUP(A50,'Base de données'!A4:A15,1,TRUE),IF(E7=\"acier\",VLOOKUP(A50,'Base de données'!A19:A45,1,TRUE),IF(E7=\"cuivre\",VLOOKUP(A50,'Base de données'!A49:A64,1,TRUE))))","v":13.2},{"$f":"IF(A50=B50,B50,IF(E7=\"PER\",VLOOKUP(A50,'Base de données'!A4:B14,2,TRUE),IF(E7=\"acier\",VLOOKUP(A50,'Base de données'!A19:B44,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(A50,'Base de données'!A49:B63,2,TRUE)))))","v":13.2},{"$f":"IF(E7=\"PER\",VLOOKUP(C50,'Base de données'!B4:C15,2,TRUE),IF(E7=\"acier\",VLOOKUP(C50,'Base de données'!B19:C45,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(C50,'Base de données'!B49:C64,2,TRUE))))","v":"AC - 17.2 * 2"}]
[]
["diamètre 5 calculé","valeur proche inf.","diam. Int. Réel","ref"]
[{"$f":"I26","v":0},{"$f":"IF(E7=\"PER\",VLOOKUP(A53,'Base de données'!A4:A15,1,TRUE),IF(E7=\"acier\",VLOOKUP(A53,'Base de données'!A19:A45,1,TRUE),IF(E7=\"cuivre\",VLOOKUP(A53,'Base de données'!A49:A64,1,TRUE))))","v":0},{"$f":"IF(A53=B53,B53,IF(E7=\"PER\",VLOOKUP(A53,'Base de données'!A4:B14,2,TRUE),IF(E7=\"acier\",VLOOKUP(A53,'Base de données'!A19:B44,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(A53,'Base de données'!A49:B63,2,TRUE)))))","v":0},{"$f":"IF(E7=\"PER\",VLOOKUP(C53,'Base de données'!B4:C15,2,TRUE),IF(E7=\"acier\",VLOOKUP(C53,'Base de données'!B19:C45,2,TRUE),IF(E7=\"cuivre\",VLOOKUP(C53,'Base de données'!B49:C64,2,TRUE))))","v":{"$error":"#N/A"}}]