Single-Phase Liquid Pipe Flow
Single-phase liquid flow in vertical tubing with named inputs and rate sensitivity analysis. Shows friction loss, gravity head, Reynolds number, and required BHP at 14 rate points.
Inputs
Named cells you can edit — every result recalculates from them.
| Name | Description | Default | Unit |
|---|---|---|---|
VFP_Ql |
Liquid Rate | 5000 | bbl/d |
VFP_RhoL |
Liquid Density | 50 | lb/ft3 |
VFP_UL |
Liquid Viscosity | 1.0 | cP |
VFP_ID |
Tubing ID | 2.992 | in |
VFP_Len |
Tubing Length | 8000 | ft |
VFP_Rough |
Roughness | 0.0006 | in |
VFP_Angle |
Pipe Angle | 90 | degrees |
VFP_Pwh |
Wellhead Pressure | 200 | psi |
2 sheets, shown with the values the file opens with
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Pipe Flow — Inputs | |||||
| 2 | Single-phase liquid flow in vertical tubing. Pressure drop has two components: friction (increases with rate²) and gravity/hydrostatic (constant for a given density and depth). | |||||
| 3 | ||||||
| 4 | Liquid Properties | |||||
| 5 | Liquid Rate | 5000 | bbl/d | |||
| 6 | Liquid Density | 50 | lb/ft3 | |||
| 7 | Liquid Viscosity | 1 | cP | |||
| 8 | ||||||
| 9 | Pipe Properties | |||||
| 10 | Tubing ID | 2.992 | in | |||
| 11 | Tubing Length | 8000 | ft | |||
| 12 | Roughness | 0.0006 | in | |||
| 13 | Pipe Angle | 90 | degrees | |||
| 14 | ||||||
| 15 | Calculated Results | |||||
| 16 | Reynolds Number | 123663.1016 | dimensionless | |||
| 17 | Friction Loss | 155.5209781 | psi | |||
| 18 | Gravity Head | 2777.777778 | psi | |||
| 19 | ||||||
| 20 | Well Application | |||||
| 21 | Wellhead Pressure | 200 | psi | |||
| 22 | Required BHP (upflow) | 3133.298756 | psia |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rate Sensitivity — Friction Pressure Drop | |||||
| 2 | Friction loss vs rate for the tubing defined on the Inputs sheet. Reynolds number determines flow regime (laminar <2100, turbulent >4000). | |||||
| 3 | ||||||
| 4 | Friction Loss vs Rate | |||||
| 5 | q (bbl/d) | dP Friction (psi) | Re | BHP (psi) | ||
| 6 | 500 | 2.319413361 | 12366.31016 | 2980.097191 | ||
| 7 | 1000 | 7.988241123 | 24732.62032 | 2985.766019 | ||
| 8 | 1500 | 16.65007178 | 37098.93048 | 2994.42785 | ||
| 9 | 2000 | 28.18637467 | 49465.24064 | 3005.964152 | ||
| 10 | 2500 | 42.53556264 | 61831.5508 | 3020.31334 | ||
| 11 | 3000 | 59.66038849 | 74197.86096 | 3037.438166 | ||
| 12 | 3500 | 79.53629994 | 86564.17112 | 3057.314078 | ||
| 13 | 4000 | 102.1461609 | 98930.48128 | 3079.923939 | ||
| 14 | 4500 | 127.4775065 | 111296.7914 | 3105.255284 | ||
| 15 | 5000 | 155.5209781 | 123663.1016 | 3133.298756 | ||
| 16 | 6000 | 219.7170191 | 148395.7219 | 3197.494797 | ||
| 17 | 7000 | 294.6928278 | 173128.3422 | 3272.470606 | ||
| 18 | 8000 | 380.421281 | 197860.9626 | 3358.199059 | ||
| 19 | 10000 | 584.0668367 | 247326.2032 | 3561.844614 | ||
| 20 | ||||||
| 21 | ||||||
| 22 | ||||||
| 23 | ||||||
| 24 | ||||||
| 25 | ||||||
| 26 | ||||||
| 27 | ||||||
| 28 | ||||||
| 29 | ||||||
| 30 | ||||||
| 31 | ||||||
| 32 | ||||||
| 33 | ||||||
| 34 | ||||||
| 35 | ||||||
| 36 | ||||||
| 37 | ||||||
| 38 | ||||||
| 39 | ||||||
| 40 | ||||||
| 41 | ||||||
| 42 | ||||||
| 43 | ||||||
| 44 | ||||||
| 45 | ||||||
| 46 | ||||||
| 47 | ||||||
| 48 | ||||||
| 49 | ||||||
| 50 | ||||||
| 51 | ||||||
| 52 | ||||||
| 53 | ||||||
| 54 | ||||||
| 55 | ||||||
| 56 | ||||||
| 57 | ||||||
| 58 | ||||||
| 59 | ||||||
| 60 | ||||||
| 61 | ||||||
| 62 | ||||||
| 63 | ||||||
| 64 |
| Name | Refers To | Comment |
|---|---|---|
| VFP_Angle | Inputs!$B$13 | |
| VFP_ID | Inputs!$B$10 | |
| VFP_Len | Inputs!$B$11 | |
| VFP_Pwh | Inputs!$B$21 | |
| VFP_Ql | Inputs!$B$5 | |
| VFP_RhoL | Inputs!$B$6 | |
| VFP_Rough | Inputs!$B$12 | |
| VFP_UL | Inputs!$B$7 |
| Opens in | Needs the Petroleum Office add-in: its PO functions show #NAME? without it once Excel recalculates. |
| Functions used | PO.VFP.Liq.PinPO.VFP.Liq.RePO.VFP.Liq.dPfrcPO.VFP.Liq.dPgrv |
| File | PipeFlowFunctions.xlsx, 12 KB |
| Category | Production |
| For agents and tools | Structure (.json) · Descriptor (.md) |



