Gas Pipeline Sizing
Spreadsheet
34 rows x 5 columns
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Gas Pipeline Sizing | ||||
| 2 | Design Parameters | ||||
| 3 | Gas Specific Gravity | 0.65 | dimensionless | ||
| 4 | Average Temperature | 80 | degF | ||
| 5 | Compressibility (Z) | 0.92 | dimensionless | ||
| 6 | Gas Viscosity | 0.012 | cP | ||
| 7 | Inlet Pressure | 800 | psi | ||
| 8 | Min Delivery Pressure | 400 | psi | ||
| 9 | Target Flow Rate | 3 | MMscf/d | ||
| 10 | Pipeline Length | 50 | miles | ||
| 11 | |||||
| 12 | Diameter Screening | ||||
| 13 | Pipe ID (in) | Weymouth | Panhandle A | Panhandle B | Velocity |
| 14 | Pout (psi) | Pout (psi) | Pout (psi) | (ft/s) | |
| 15 | 4 | 509.9692624 | 624.7500892 | 679.0872917 | 8.526270871 |
| 16 | 6 | 772.2000545 | 777.8900206 | 784.9022399 | 3.15740219 |
| 17 | 8 | 794.0884768 | 794.5852836 | 796.4026854 | 1.751651951 |
| 18 | 10 | 798.2064002 | 798.1710259 | 798.812664 | 1.118168743 |
| 19 | 12 | 799.3221674 | 799.2456431 | 799.5196248 | 0.7759643423 |
| 20 | |||||
| 21 | Length Sensitivity (8" pipe) | ||||
| 22 | Length (mi) | Weymouth | Panhandle A | Panhandle B | Re |
| 23 | Pout (psi) | Pout (psi) | Pout (psi) | ||
| 24 | 10 | 798.8211951 | 798.9199926 | 799.2818323 | 408078.125 |
| 25 | 25 | 797.0497189 | 797.2972385 | 798.2033692 | 408078.125 |
| 26 | 50 | 794.0884768 | 794.5852836 | 796.4026854 | 408078.125 |
| 27 | 75 | 791.1161504 | 791.864041 | 794.5979209 | 408078.125 |
| 28 | 100 | 788.1326144 | 789.1334145 | 792.7890479 | 408078.125 |
| 29 | |||||
| 30 | Flow Capacity (8" x 50 mi) | ||||
| 31 | Correlation | Capacity (MMscf/d) | |||
| 32 | Weymouth | 21.41095123 | |||
| 33 | Panhandle A | 26.20498054 | |||
| 34 | Panhandle B | 28.66834617 |
| Name | Refers To | Comment |
|---|---|---|
| SG_gas | $B$3 | Gas specific gravity |
| T | $B$4 | Average temperature, degF |
| Z | $B$5 | Gas compressibility factor |
| Ug | $B$6 | Gas viscosity, cP |
| P_in | $B$7 | Inlet pressure, psia |
| P_min | $B$8 | Minimum delivery pressure, psia |
| Qg | $B$9 | Target flow rate, MMscf/d |
| L | $B$10 | Pipeline length, miles |
Description
Size a gas pipeline by comparing three diameters across three correlations (Weymouth, Panhandle A, Panhandle B) to find the smallest pipe that delivers the target flow rate with acceptable outlet pressure. Also evaluates how pipeline length affects capacity for the selected diameter.
Decision criteria: Select the smallest diameter where outlet pressure exceeds minimum delivery pressure across all applicable correlations. Check gas velocity stays below erosional limit (~60 ft/s).
Workflow
- Inputs: Gas properties (SG, T, Z, μg), target flow rate, inlet pressure, minimum delivery pressure
- Step 1: For each diameter, compute outlet pressure at target rate using all 3 correlations
- Step 2: Flag which diameters meet minimum delivery pressure
- Step 3: For selected diameter, sweep pipeline length to find maximum reach
- Output: Diameter selection table + length sensitivity for the chosen size
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Gas Pipeline Sizing
- Click on the blueprint to preview
- Click Insert to place it into your worksheet. Modify the input values to match your data.