{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Disclaimer","Instructions","Calculation"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Instructions","index":1,"n_rows":67,"n_cols":9,"rows_kept":67,"merged":[[23,4,23,6]],"flags":["formulas_cached_only"]}
[]
["Instructions for Pipesizing:"]
[]
["1. Enter general project description information."]
["2. Select pipe material via Pipe Type scroll menu.  "]
[null,"Contact vendor or Laclede Gas for pressure drops using Corrugated"]
[null,"Stainless Steel Tubing (CSST)."]
["3. Enter pressure (PSIG) exiting meter.  Inches water column is automatically computed."]
["4. It is recommended that you draw a piping diagram, labeling all appliances and piping"]
[null,"segments."," (Example below.)"]
{"$rows_empty":12}
[null,null,"Meter Gauge Pres.:",0.1445," PSIG",3.9997599999999998,"In. W.C."]
[" Pipe","Nom.","Flow","Length"," -------Fittings-------",{"$nulls":3},"Prev."]
["Seg.","Size","CFH","Feet"," L-90"," T-BR"," T-ST",null,"Sec."]
[1,{"v":1,"d":"1.00"},140,100,{"$nulls":4}," MTR."]
[2,{"v":0.5,"d":"0.50"},40,10,3,1,null,null,1]
[3,{"v":0.5,"d":"0.50"},100,20,3,null,1,null,1]
[4,{"$nulls":7},3]
[5,{"$nulls":7},4]
[]
[]
["5. Enter information for each pipe segment."]
[null,"A. Enter nominal pipe size (Inches).  (If optimizing pipe size, guess"]
[null,"size and adjust after all pipe segments have been entered.)"]
[null,"B. Enter gas flow through segment (CFH)."]
[null,"C. Enter segment length (Feet)."]
[null,"D. Enter number of fittings in segment.  Begin each segment with a 'T'"]
[null,"fitting or meter and, if connected to an appliance, add three elbows to"]
[null,"account for connection losses."]
[null,"E. Enter in previous segment reference number.  First segment defaults to meter."]
[null,"F. Enter appliance if applicable. (Optional)"]
["6. Repeat step 5 as required for entire system."]
["7. Adjust nominal sizes to maintain adequate pressure at equipment connections."]
[]
[]
["General Notes:"]
[]
["1. User inputs are in blue."]
["2. At appliance connections, the pressure drop through the sedimant trap, shut-off"]
["valve, union and reducer can be accounted for by entering three elbows in pipe segment."]
["3. This program can be used to determine the pressure drop and exit pressrue for an"]
["existing system by entering the piping system as installed.  This program can also be "]
["used to optimize a new installation by adjusting the nominal pipe sizes until the "]
["desired pressure drop is obtained."]
["4. Only 'tree' configurations can be analyzed with this spreadsheet.  Looped or "]
["gridded systems require additional analysis."]
[]
[]
["Calculation Procedure:"]
[]
["This spreadsheet calculates the pressure drop through each segment in sequence using"]
["the high-pressure and low-pressure equations found in the International Fuel Gas Code"]
["1997.  The resultant outlet pressure from the previous segment is used as the inlet"]
["pressure of the next segment.  The results from the high-pressure equation are used"]
["until the segment outlet is below 1.5 psig.  Once below 1.5 psig the low-pressure "]
["equation is used."]

{"sheet":"Calculation","index":2,"n_rows":76,"n_cols":28,"rows_kept":76,"merged":[[6,4,6,6],[6,8,6,9],[6,10,6,11]],"flags":["formulas_cached_only"]}
[null,"Project:","Project"]
[null,"Client:","Client",{"$nulls":4},"Pipe Type:"]
[null,"User:","User",{"$nulls":11},"Date:  ","2004-12-30T14:49:00.510",{"$nulls":4},"Cr",0.6094167901632215]
[null,"Comments:","Comment",{"$nulls":3},"",{"$nulls":7}," Sp. Gravity:  ",{"v":0.6,"d":"0.60"},{"$nulls":4},"Y",0.9979044007584074]
[{"$nulls":7},"Max. Press. Drop",{"$error":"#VALUE!"},"PSIG",{"$error":"#VALUE!"},"Inch W.C.",{"$nulls":3},"N.G. 0.60; Propane 1.52",{"$nulls":4},"T (R)",520]
[null,null,"Meter Gauge Pres.:",0.1445," PSIG",3.9997599999999998,"In. W.C.",{"$nulls":6},"Atmos. Pres.:",14.7," PSI",{"$nulls":4},"Z",0.012]
[" Pipe","Nom.","Flow","Length"," -------Fittings-------",null,null,"Equiv."," -------Exit-------",null," -------Drop-------",null,"Prev.",null,"Pipe"]
["Seg.","Size","CFH","Feet"," L-90"," T-BR"," T-ST","Length","PSIG","Inches W.C.","PSI","Inches W.C.","Sec.","Appliance","Seg.",{"$nulls":9},"High Press.","Low Press.",null,"CSST"]
[1,{"$nulls":6},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}," MTR.",null,1,{"$nulls":5},"Q=","Rate cfh",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[2,{"$nulls":6},"","","","","",1,null,2,{"$nulls":5},"D=","ID pipe, in",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[3,{"$nulls":6},"","","","","",2,null,3,{"$nulls":5},"P1=","psia",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[4,{"$nulls":6},"","","","","",3,null,4,{"$nulls":5},"P2=","psia",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[5,{"$nulls":6},"","","","","",4,null,5,{"$nulls":5},"Y=","superexpansibility",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[6,{"$nulls":6},"","","","","",5,null,6,{"$nulls":5},"Cr=",".00354 S T (z/s)^0.152",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[7,{"$nulls":6},"","","","","",6,null,7,{"$nulls":5},"L=","length, ft",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[8,{"$nulls":6},"","","","","",7,null,8,{"$nulls":5},"Del H=","press drop, \"WC",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[9,{"$nulls":6},"","","","","",8,null,9,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[10,{"$nulls":6},"","","","","",9,null,10,{"$nulls":5},"S","specific gravity",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[11,{"$nulls":6},"","","","","",10,null,11,{"$nulls":5},"T","absolute temp, R  = 460 + F",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[12,{"$nulls":6},"","","","","",11,null,12,{"$nulls":5},"Z","Viscosity  = 0.012 natural gas",null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[13,{"$nulls":6},"","","","","",12,null,13,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[14,{"$nulls":6},"","","","","",13,null,14,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[15,{"$nulls":6},"","","","","",14,null,15,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[16,{"$nulls":6},"","","","","",15,null,16,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[17,{"$nulls":6},"","","","","",16,null,17,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[18,{"$nulls":6},"","","","","",17,null,18,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[19,{"$nulls":6},"","","","","",18,null,19,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[20,{"$nulls":6},"","","","","",19,null,20,{"$nulls":9},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
["Calculations based on:",{"$nulls":5},"4\" Water Column = 0.1445 Psi",{"$nulls":7},"Recommended"]
["International Mechanical Code 1996",{"$nulls":5},"10\" Water Column = 0.362 Psi",{"$nulls":4},"                    Laclede Gas",null,null,"System Pressure"]
["National Fuel Gas Code 1996",{"$nulls":5},"27.68\" Water Column = 1 Psi",{"$nulls":4},"Meter Outlet Pressure",null,null,"Drop"]
["60 Deg. F, 14.7 psia",{"$nulls":5},"1 CFH = 1,000 BTUH",{"$nulls":4},"Low  ","4\" W.C.",null,"0.3 - 0.5 \" W.C.",{"$nulls":3},3,"Material Selection"]
[{"$nulls":6},"100,000 BTUH = 1 Therm",{"$nulls":4},"Med  ","2 psig - residential",null,"1 psig",{"$nulls":4},"Pipe (Steel & Iron)"]
["Notes:",{"$nulls":10},"Med  ","2 psig - commercial",null,"8 - 10 \" W.C.",{"$nulls":4},"Tube (Copper - K)"]
["Include equivalent feet for pipe specialties and fittings not listed above.",{"$nulls":10},"High*  ","5 psig & above",null," ---",{"$nulls":4},"Tube (Copper - L)"]
["Recommended minimum pipe & tube size is 1/2\" Diameter.",{"$nulls":10},"      * Outlet pressure above 2 psig requires ",{"$nulls":7},"Plastic"]
[{"$nulls":11},"             contractor certification of leakage test.",{"$nulls":7},"CSST NOT Working"]
[{"$nulls":11},"             MPSC - Rule 20 of General Order 20."]
[]
[]
["PIPE DATA - Steel & Iron (Sch. 40)",{"$nulls":6},"TUBE DATA - Copper Type L"]
[" Nom.","Int.",null,"   -- Equiv. Length -",{"$nulls":3}," Nom.","Int.",null,"   -- Equiv. Length -"]
[" Size","Dia.","    L-90","  T-BR"," T-ST",null,null," Size","Dia.","    L-90","  T-BR"," T-ST"]
[0.375,0.493,{"v":1.4,"d":"1.40"},{"v":3,"d":"3.00"},{"v":0.9,"d":"0.90"},null,null,0.375,{"v":0.43,"d":"0.430"},{"v":1.4,"d":"1.40"},{"v":3,"d":"3.00"},{"v":0.9,"d":"0.90"}]
[{"v":0.5,"d":"0.500"},0.622,1.55,{"v":3.1,"d":"3.10"},{"v":1.3,"d":"1.30"},null,null,{"v":0.5,"d":"0.500"},0.545,1.55,{"v":3.1,"d":"3.10"},{"v":1.3,"d":"1.30"}]
[{"v":0.75,"d":"0.750"},0.824,2.06,4.12,{"v":2,"d":"2.00"},null,null,0.625,0.666,{"v":1.8,"d":"1.80"},{"v":3.6,"d":"3.60"},{"v":1.6,"d":"1.60"}]
[{"v":1,"d":"1.00"},1.049,2.62,5.24,{"v":2.6,"d":"2.60"},null,null,{"v":0.75,"d":"0.750"},0.785,2.06,4.12,{"v":2,"d":"2.00"}]
[1.25,{"v":1.38,"d":"1.380"},3.45,{"v":6.9,"d":"6.90"},{"v":3.3,"d":"3.30"},null,null,{"v":1,"d":"1.00"},1.025,2.62,5.24,{"v":2.6,"d":"2.60"}]
[{"v":1.5,"d":"1.50"},{"v":1.61,"d":"1.610"},4.02,8.04,{"v":4,"d":"4.00"},null,null,1.25,1.265,3.45,{"v":6.9,"d":"6.90"},{"v":3.3,"d":"3.30"}]
[{"v":2,"d":"2.00"},2.067,5.17,{"v":10.3,"d":"10.30"},{"v":5,"d":"5.00"},null,null,{"v":1.5,"d":"1.50"},1.505,4.02,8.04,{"v":4,"d":"4.00"}]
[{"v":2.5,"d":"2.50"},2.469,6.16,{"v":12.3,"d":"12.30"},{"v":6,"d":"6.00"},null,null,{"v":2,"d":"2.00"},1.985,5.17,{"v":10.3,"d":"10.30"},{"v":5,"d":"5.00"}]
[{"v":3,"d":"3.00"},3.068,7.67,{"v":15.3,"d":"15.30"},{"v":7.5,"d":"7.50"},null,null,{"v":2.5,"d":"2.50"},2.465,6.16,{"v":12.3,"d":"12.30"},{"v":6,"d":"6.00"}]
[{"v":3.5,"d":"3.50"},3.548,8.89,{"v":17.8,"d":"17.80"},8.75,null,null,{"v":3,"d":"3.00"},2.945,7.67,{"v":15.3,"d":"15.30"},{"v":7.5,"d":"7.50"}]
[{"v":4,"d":"4.00"},4.026,{"v":10.1,"d":"10.10"},{"v":20.2,"d":"20.20"},{"v":10,"d":"10.00"},null,null,{"v":3.5,"d":"3.50"},3.425,8.89,{"v":17.8,"d":"17.80"},8.75]
[{"v":5,"d":"5.00"},5.047,{"v":12.6,"d":"12.60"},{"v":25.3,"d":"25.30"},{"v":12.5,"d":"12.50"},null,null,{"v":4,"d":"4.00"},3.905,{"v":10.1,"d":"10.10"},{"v":20.2,"d":"20.20"},{"v":10,"d":"10.00"}]
[{"v":6,"d":"6.00"},6.065,{"v":15.2,"d":"15.20"},{"v":30.3,"d":"30.30"},{"v":15,"d":"15.00"},null,null,{"v":5,"d":"5.00"},4.875,{"v":12.6,"d":"12.60"},{"v":25.3,"d":"25.30"},{"v":12.5,"d":"12.50"}]
[{"v":8,"d":"8.00"},7.981,{"v":20,"d":"20.00"},{"v":40,"d":"40.00"},{"v":20,"d":"20.00"},null,null,{"v":6,"d":"6.00"},5.845,{"v":15.2,"d":"15.20"},{"v":30.3,"d":"30.30"},{"v":15,"d":"15.00"}]
[{"v":10,"d":"10.00"},{"v":10.02,"d":"10.020"},{"v":25,"d":"25.00"},{"v":50,"d":"50.00"},{"v":25,"d":"25.00"}]
[]
["TUBE DATA - Plastic (Polyethylene)",{"$nulls":6},"TUBE DATA - Copper Type K"]
[" Nom.","Int.",null,"   -- Equiv. Length -",{"$nulls":3}," Nom.","Int.",null,"   -- Equiv. Length -"]
[" Size","Dia.","    L-90","  T-BR"," T-ST",null,null," Size","Dia.","    L-90","  T-BR"," T-ST"]
[0.75,{"v":0.86,"d":"0.860"},2.06,4.12,{"v":2,"d":"2.00"},null,null,0.375,0.402,{"v":1.4,"d":"1.40"},{"v":3,"d":"3.00"},{"v":0.9,"d":"0.90"}]
[{"v":1,"d":"1.00"},1.077,2.62,5.24,{"v":2.6,"d":"2.60"},null,null,{"v":0.5,"d":"0.500"},0.527,1.55,{"v":3.1,"d":"3.10"},{"v":1.3,"d":"1.30"}]
[1.25,1.358,3.45,{"v":6.9,"d":"6.90"},{"v":3.3,"d":"3.30"},null,null,0.625,0.652,{"v":1.8,"d":"1.80"},{"v":3.6,"d":"3.60"},{"v":1.6,"d":"1.60"}]
[{"v":1.5,"d":"1.50"},1.551,4.02,8.04,{"v":4,"d":"4.00"},null,null,{"v":0.75,"d":"0.750"},0.745,2.06,4.12,{"v":2,"d":"2.00"}]
[{"v":2,"d":"2.00"},1.943,5.17,{"v":10.3,"d":"10.30"},{"v":5,"d":"5.00"},null,null,{"v":1,"d":"1.00"},0.995,2.62,5.24,{"v":2.6,"d":"2.60"}]
[{"$nulls":7},1.25,1.245,3.45,{"v":6.9,"d":"6.90"},{"v":3.3,"d":"3.30"}]
[{"$nulls":7},{"v":1.5,"d":"1.50"},1.481,4.02,8.04,{"v":4,"d":"4.00"}]
["TUBE DATA - CSST",{"$nulls":6},{"v":2,"d":"2.00"},1.959,5.17,{"v":10.3,"d":"10.30"},{"v":5,"d":"5.00"}]
[" Nom.",null,"B",null,"   -- Equiv. Length -",null,null,{"v":2.5,"d":"2.50"},2.435,6.16,{"v":12.3,"d":"12.30"},{"v":6,"d":"6.00"}]
[" Size","A","Exponent","    L-90","  T-BR"," T-ST",null,{"v":3,"d":"3.00"},2.907,7.67,{"v":15.3,"d":"15.30"},{"v":7.5,"d":"7.50"}]
[0.375,{"v":2.158495e-05,"d":"0.000"},{"v":2.07082325,"d":"2.07"},{"v":0.12400000000000001,"d":"0.12"},{"v":0.24800000000000003,"d":"0.25"},{"v":0.10400000000000001,"d":"0.10"},null,{"v":3.5,"d":"3.50"},3.385,8.89,{"v":17.8,"d":"17.80"},8.75]
[{"v":0.5,"d":"0.50"},{"v":3.45297e-06,"d":"0.000"},{"v":2.10561268,"d":"2.11"},{"v":0.6200000000000001,"d":"0.62"},{"v":1.2400000000000002,"d":"1.24"},0.52,null,{"v":4,"d":"4.00"},3.857,{"v":10.1,"d":"10.10"},{"v":20.2,"d":"20.20"},{"v":10,"d":"10.00"}]
[0.75,{"v":8.3963e-07,"d":"0.000"},{"v":2.06320996,"d":"2.06"},{"v":3.2550000000000003,"d":"3.26"},{"v":6.510000000000001,"d":"6.51"},{"v":2.7300000000000004,"d":"2.73"},null,{"v":5,"d":"5.00"},4.805,{"v":12.6,"d":"12.60"},{"v":25.3,"d":"25.30"},{"v":12.5,"d":"12.50"}]
[{"v":1,"d":"1.00"},{"v":3.8046e-07,"d":"0.000"},{"v":1.99626208,"d":"2.00"},{"v":9.3,"d":"9.30"},{"v":18.6,"d":"18.60"},{"v":7.800000000000001,"d":"7.80"},null,{"v":6,"d":"6.00"},5.741,{"v":15.2,"d":"15.20"},{"v":30.3,"d":"30.30"},{"v":15,"d":"15.00"}]