Liquid Pipeline Sizing
Spreadsheet
36 rows x 3 columns
| A | B | C | |
|---|---|---|---|
| 1 | Liquid Pipeline Sizing | ||
| 2 | Pipeline Data | ||
| 3 | Pipe Diameter | 6 | inches |
| 4 | Pipe Length | 5000 | ft |
| 5 | Relative Roughness (e/D) | 0.0006 | - |
| 6 | Elevation Change (dH) | 0 | ft |
| 7 | |||
| 8 | Fluid Properties | ||
| 9 | Liquid Density | 52 | lb/ft3 |
| 10 | Liquid Viscosity | 3.5 | cP |
| 11 | |||
| 12 | Design Flow Rate | ||
| 13 | Target Flow Rate | 3000 | bbl/d |
| 14 | |||
| 15 | Pressure Drop Calculation | ||
| 16 | Pressure Drop | 107.6429088 | psi |
| 17 | |||
| 18 | Pressure Requirements | ||
| 19 | Desired Outlet Pressure | 50 | psia |
| 20 | Required Inlet Pressure | 157.6429088 | psia |
| 21 | |||
| 22 | Verification | ||
| 23 | Calculated Outlet Pressure | 50 | psia |
| 24 | |||
| 25 | Flow Capacity Check | ||
| 26 | Available Pressure Drop | 200 | psi |
| 27 | Max Flow Rate | 4256.734657 | bbl/d |
| 28 | |||
| 29 | Flow Properties | ||
| 30 | Velocity | 0.9929500061 | ft/s |
| 31 | Reynolds Number | 10994.28571 | - |
| 32 | Friction Factor | 0.03110484053 | - |
| 33 | |||
| 34 | Velocity Check | ||
| 35 | Erosional Velocity Limit | 10 | ft/s |
| 36 | Velocity OK? | OK |
Description
Design a liquid pipeline using Darcy-Weisbach pressure drop calculations. Determine required pressures, flow capacity, and verify velocity limits.
Design Steps:
- Define pipeline geometry and fluid properties
- Calculate pressure drop at target flow rate
- Determine inlet/outlet pressures
- Check velocity and Reynolds number
Velocity Guidelines:
- Crude oil: 3-8 ft/s typical
- Water: 5-10 ft/s typical
- Erosional velocity limit: varies by fluid and material
Relative Roughness:
- New steel: e/D = 0.0002
- Commercial steel: e/D = 0.0006
- Corroded steel: e/D = 0.002
Elevation Change (dH):
- Positive: outlet higher than inlet (uphill)
- Negative: outlet lower than inlet (downhill)
- Zero: flat pipeline
Reference: Crane Technical Paper No. 410 - Flow of Fluids.
How to use this blueprint
- In Excel, go to the Petroleum Office ribbon tab and click Blueprint Manager
- Search for Liquid Pipeline Sizing
- 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.