Gas Pipeline Flow Analysis
Spreadsheet
35 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Gas Pipeline Flow Analysis | ||
| 2 | Pipeline Data | ||
| 3 | Inlet Pressure | 800 | psia |
| 4 | Outlet Pressure | 400 | psia |
| 5 | Pipe Diameter | 6 | inches |
| 6 | Pipe Length | 20 | miles |
| 7 | |||
| 8 | Gas Properties | ||
| 9 | Gas Specific Gravity | 0.65 | air=1 |
| 10 | Average Temperature | 80 | degF |
| 11 | Compressibility Factor (Z) | 0.92 | - |
| 12 | Gas Viscosity | 0.012 | cP |
| 13 | |||
| 14 | Pipeline Efficiency | ||
| 15 | E (Weymouth) | 1 | - |
| 16 | E (Panhandle A) | 0.92 | - |
| 17 | E (Panhandle B) | 0.95 | - |
| 18 | |||
| 19 | Flow Rate Calculations | ||
| 20 | Equation | Flow Rate (Mscf/d) | |
| 21 | Weymouth | 444375.3841 | |
| 22 | Panhandle A | 431698.0916 | |
| 23 | Panhandle B | 581563.7278 | |
| 24 | |||
| 25 | Outlet Pressure at 15 MMscf/d | ||
| 26 | Target Flow Rate | 15000 | Mscf/d |
| 27 | Pout (Weymouth) | 799.658102 | psia |
| 28 | Pout (Panhandle A) | 799.4080842 | psia |
| 29 | Pout (Panhandle B) | 799.7696087 | psia |
| 30 | |||
| 31 | Flow Properties at Target Rate | ||
| 32 | Average Pressure | 799.829051 | psia |
| 33 | Gas Velocity | 15.51602773 | ft/s |
| 34 | Gas Density | 2.827113213 | lb/ft3 |
| 35 | Reynolds Number | 2720520.833 | - |
Description
Calculate gas pipeline flow rates and outlet pressures using Weymouth, Panhandle A, and Panhandle B equations.
Design Steps:
- Define pipeline geometry and gas properties
- Calculate flow capacity using each correlation
- Compare outlet pressures at fixed flow rate
- Evaluate gas velocity and Reynolds number
Equation Selection:
- Weymouth: High-pressure large-diameter pipelines, conservative
- Panhandle A: Medium-pressure transmission lines, Re > 5M
- Panhandle B: High-pressure large-diameter, fully turbulent flow
Typical Efficiency Factors:
- Weymouth: E = 1.0 (theoretical)
- Panhandle A: E = 0.92
- Panhandle B: E = 0.95
Reference: Ikoku, C.U. (1984). Natural Gas Production Engineering.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Gas Pipeline Flow Analysis
- Click on the blueprint to preview the spreadsheet template
- Click Insert to place it into your worksheet. Modify the input values to match your data.