{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dimensionnement","Paramètres"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":9,"comments":0,"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":"Dimensionnement","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[22,3,22,4],[14,1,14,2],[4,1,4,2],[26,3,26,4],[25,3,25,4],[24,3,24,4],[23,3,23,4],[35,0,35,7],[34,3,34,4],[33,3,33,4],[32,3,32,4],[31,3,31,4],[30,3,30,4],[29,3,29,4],[28,3,28,4],[27,3,27,4]]}
["DIMENSIONNEMENT DE LA TUYAUTERIE DE GAZ NATUREL"]
["Basé sur les formules des articles A.3.5 et B.3.5 du Code d'installation du gaz naturel et du propane (B149.1-10)\r\nCe calculateur estime la capacité maximale du gaz naturel et du propane pour des tuyaux en plastique et de schedule 40 seulement. Pour les estimations des tubes en cuivre, veuillez consulter les tableaux A.8 à A.14 et B.6 à B.10 du code CSA B149.1-2010."]
["Veuillez activer les macros avant d'utiliser ce calculateur."]
[]
[null,"Valeur à rentrer"]
[]
[]
[]
[]
[]
[]
[]
[null,"Pouvoir calorifique",null,{"$f":"IF(Paramètres!J11,IF(Paramètres!J10,1000,37.077),IF(Paramètres!J10,2520,93.94))","v":1000},{"$f":"IF(Paramètres!J10,\"Btu/pi3\",\"MJ/m3\")","v":"Btu/pi3"}]
[null,"Longueur du tuyau",null,null,{"$f":"IF(Paramètres!J10,\"pi\",\"m\")","v":"pi"}]
[null,"Facteur de tolérance des raccords",null,1.2]
[]
[null,"Pression atmosphérique",null,{"$f":"IF(Paramètres!J10,Paramètres!C16,Paramètres!D16)","v":14.73},{"$f":"IF(Paramètres!J10,\"lb/po2\",\"kPa\")","v":"lb/po2"}]
[null,"Pression en amont",null,null,{"$f":"IF(Paramètres!J12,IF(Paramètres!J10,\"lb/po2\",\"kPa\"),IF(Paramètres!J10,\"po. c.e.\",\"Pa\"))","v":"lb/po2"}]
[null,"Pression en aval",null,null,{"$f":"IF(Paramètres!J12,IF(Paramètres!J10,\"lb/po2\",\"kPa\"),\"\")","v":"lb/po2"}]
[]
[null,"Facteur de sécurité",null,1]
[]
[null,null,"Diamètre\n (po)",{"$f":"IF(Paramètres!J10,\"Capacité maximale (1000 Btu/h), à 60°F\",\"Capacité maximale (kW), à 15,6°C\")","v":"Capacité maximale (1000 Btu/h), à 60°F"}]
[null,null,"½"]
[null,null,"¾"]
[null,null,1]
[null,null,"1¼"]
[null,null,"1½"]
[null,null,2]
[null,null,"2½"]
[null,null,3]
[null,null,4]
[null,null,6]
[null,null,8]
[null,null,10]
["Gaz Métro n'est pas responsable des données incomplètes, de l'inexactitude, d'une omission ou d'une erreur dans les données et les renseignements fournis dans ce chiffrier."]

{"sheet":"Paramètres","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":true,"merged":[[8,2,8,3],[8,4,8,5],[18,2,18,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Anglais"]
[null,null,"Gaz naturel",null,"Propane"]
[null,"Constants","Imp","SI","Imp","SI",null,null,"unité (anlgais)",true]
[null,"K1",2237,0.35759999999999997,2237,0.35759999999999997,null,null,"Type (GN)",true]
[null,"Y",1,1,1,1,null,null,"Pression (Haute)",true]
[null,"z",1,0.27779999999999999,1,0.27779999999999999]
[null,"Cr",0.60940000000000005,0.60940000000000005,1.26,1.26]
[null,"K2",2313,0.15090000000000001,2313,0.15090000000000001]
[null,"Patm (lb/po2 ou kPa)",14.73,101.325,14.73,101.325]
[]
[]
[null,null,"Diamètre (po)"]
[null,null,"Nominal","Intérieur"]
[null,null,0.5,0.622]
[null,null,0.75,0.82399999999999995]
[null,null,1,1.0489999999999999]
[null,null,1.25,1.38]
[null,null,1.5,1.61]
[null,null,2,2.0670000000000002]
[null,null,2.5,2.4689999999999999]
[null,null,3,3.0680000000000001]
[null,null,4,4.0259999999999998]
[null,null,6,6.0650000000000004]
[null,null,8,7.9809999999999999,null,null,null,null,null,null,"Métrique"]
[null,null,10,10.02]