Natural Gas Pipeline Flow Calculation Spreadsheet

Where to Find a Natural Gas Pipeline Flow Calculation Spreadsheet

To obtain a natural gas pipeline flow calculation spreadsheet , click here to visit our spreadsheet store.  Intended for use in making natural gas pipeline design calculations, you can buy a convenient natural gas pipeline flow calculation spreadsheet for a very reasonable price.  This spreadsheet makes calculations with the Weymouth equation, the Panhandle A equation, and the Panhandle B equation, and is available in either U.S. or S.I. units.  Read on for information about a natural gas pipeline flow calculation spreadsheet.

Choice of Equations for Natural Gas Pipeline Flow Calculations

Several different equations are used for natural gas pipeline flow calculations.  If the pressure drop across the pipe is less than 40 % of the average pipeline pressure, then the Darcy Weisbach equation is a possibility.  For longer pipelines with larger pressure drop, the three equations that are in most common use are the Weymouth equation, the Panhandle A equation, and the Panhandle B equation.  The choice among these three equations depends upon the pipeline diameter, the pipe length, and the average pipeline pressure.

The Weymouth Equation for Natural Gas Pipeline Flow Calculations

The Weymouth equation was the first of the three to be developed and was the first equation for natural gas pipeline flow calculations that didn’t require an iterative calculation to get a value for the friction factor.  The Weymouth equation is:

Where:

  • Q is the natural gas pipeline flow rate in SCFD
  • E is the pipeline efficiency
  • Tb is the base temperature in oR
  • Pb is the base pressure in psia
  • P1 is the inlet pressure in psia
  • P2 is the outlet pressure in psia
  • G is the specific gravity of the natural gas relative to air
  • Tf is the pipeline temperature of the flowing natural gas in oR
  • L is the pipeline length in miles
  • Le  is the effective pipeline length in  miles
  • ΔH is the height of the pipeline exit above the pipeline inlet in ft
  • Z is the compressibility factor of the natural gas at pipeline T & P
  • D is the pipeline diameter in inches.

Example Spreadsheet for Natural Gas Pipeline Flow Calculations

A spreadsheet for Natural Gas Pipeline Flow Calculations is partially shown in the image below.  It can be used to calculate the natural gas pipeline flow rate with the Weymouth equation, the Panhandle A equation and the Panhandle B equation.  This Excel spreadsheet, as well as others for pipe flow calculations, is available in either U.S. or S.I. units for a very reasonable price in our spreadsheet store.

Natural Gas Pipeline Flow Calculation

 

References for Further Information:

1. Crane Co.,  (1988),  “Flow of Fluids through Valves, Fittings and Pipes,  Technical Paper 401.

2.  GPSA  (Gas Processors Suppliers Association),  (1988),  Engineering Data Book, 11th Ed.

3. Bengtson, Harlan H., (2016), “Natural Gas Pipeline Flow Calculations,”  available as a paperback book or as an Amazon Kindle ebook.

4.  Bengtson, Harlan H.,  (2017),   “Pipe Flow/Friction Factor Calculations with Spreadsheets“,  available as a paperback book or as an Amazon kindle e-book.

5. Bengtson, Harlan H., (2014),  “Natural Gas Pipeline Flow Calculation Spreadsheet“, a blog article at www.EngineeringExcelTemplates.com.

 

 

Flow Through Annulus Calculator Excel Spreadsheet

Where to Find an Excel Spreadsheet Flow Through Annulus Calculator

For an Excel spreadsheet liquid flow through annulus calculatorclick here to visit our spreadsheet store.  Look in the “Non-Circular Duct flow Calculations” category.  Obtain a convenient, easy to use spreadsheet liquid flow through annulus calculator at a reasonable price. Read on for information about the use of Excel spreadsheets to calculate pressure drop or liquid flow rate for annulus flow.

Friction Factor-Pipe Flow Background for a Liquid Flow Through Annulus Calculator

A liquid flow through annulus calculator spreadsheet uses calculations that are very similar to those for flow through a pipe.  The main difference is use of the hydraulic diameter for flow through an annulus in place of the pipe diameter as used for pipe flow.  For details of pipe flow calculations, see the article, “Friction Factor/Pipe Flow Calculations with Excel Spreadsheets.”

Calculation of the Hydraulic Diameter for a Liquid Flow Through Annulus Calculator

The general definition of hydraulic diameter for flow through a non-circular cross-section is:                               DH = 4(A/P),    where:

  • DH is the hydraulic diameter in ft (m for S.I. units)
  • A is the cross-sectional area of flow in sq ft (sq m for S.I. units)
  • P is the wetted perimeter in ft (m for S.I. units)

For a flow through annulus calculator:

  • A = (π/4)(Do2 –  Di2)
  • P  =  π(Do + Di)

Where Do is the inside diameter of the outer pipe and Di is the outside diameter of the inner pipe.  Substituting for A and P in the definition of  DH and simplifying gives:

DH =  Do – Di

Equations for the Liquid Flow Through Annulus Calculator

The Darcy Weisbach equation for flow in an annulus is:  hL = f(L/DH)(V2/2g), with the parameters in the equation as follows: hL is the frictional head loss for flow of a liquid at average velocity, V, through an annulus of length, L, and hydraulic diameter, DH .  The Reynolds number for the flow (Re) and the relative roughness of the pipe (Manning roughness coefficient /pipe diameter, ε/D) are needed to get a value for the friction factor, f.  The Moody friction factor diagram and equations for calculating the friction factor, f, are presented and discussed in the article, “Friction Factor/Pipe Flow Calculations with Excel Spreadsheets.”

Spreadsheets for the Liquid Flow Through Annulus Calculator

The Excel spreadsheet screenshot below shows a liquid flow through annulus calculator spreadsheet for calculation of the head loss and frictional pressure drop for flow of a liquid through an annulus.  Based on the input values for the annulus diameters and length as well as liquid flow rate and properties, the spreadsheet will calculate the head loss and frictional pressure drop.

For low cost, easy to use spreadsheets to make these calculations as well as similar calculations for liquid flow in an annulus or for pipe flow calculations, in S.I. or U.S. units, click here to visit our spreadsheet store.

liquid flow through annulus calculator spreadsheetReferences

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.

3.  Bengtson, Harlan H.,  Advantages of Spreadsheets for Pipe Flow/Friction Factor Calculations,  an e-book available through Amazon.com.