Pipeline pressure drop calculation estimates the pressure lost as fluid moves through straight pipe, valves, and fittings. For steady liquid flow, use Darcy–Weisbach for pipe friction, add local losses, and then account separately for elevation and any change in velocity when calculating the required inlet-to-outlet pressure difference.
This guide works through a water pipeline and provides copyable Excel formulas. At 50 m³/h through 100 m of pipe with a 102.3 mm internal diameter, the illustrative system loses 37.70 kPa through friction and fittings. If the outlet is 6 m higher and has the same diameter, the required inlet-to-outlet pressure difference becomes 96.44 kPa.
The example assumes steady, single-phase, incompressible Newtonian flow in a full circular pipe. All geometry, fitting coefficients, and fluid properties are illustrative design inputs rather than universal recommendations.
Quick calculation summary
| Result | Example value |
|---|---|
| Mean velocity | 1.690 m/s |
| Reynolds number | 172,517 |
| Darcy friction factor, Swamee–Jain | 0.01889 |
| Straight-pipe pressure loss | 26.30 kPa |
| Fitting and valve pressure loss | 11.40 kPa |
| Total irreversible loss | 37.70 kPa = 0.3770 bar |
| Equivalent loss head | 3.851 m of this water |
| Pressure difference including 6 m rise | 96.44 kPa |
For a quick comparison using your own inputs, visit our pipe pressure-drop calculator. Confirm which losses a tool includes before comparing its result with a complete line calculation.
Darcy–Weisbach equation and SI units
The pressure loss along a straight, uniform pipe is:
Δppipe = fD × (L/D) × (ρv²/2)
The equivalent head loss is:
hpipe = fD × (L/D) × v²/(2g)
| Symbol | Definition | Unit |
|---|---|---|
| Δp | Pressure loss | Pa |
| fD | Darcy friction factor | Dimensionless |
| L | Straight-pipe length | m |
| D | Actual internal diameter | m |
| ρ | Fluid density at operating conditions | kg/m³ |
| v | Mean velocity | m/s |
| g | Gravitational acceleration | m/s² |
| h | Head loss of the flowing liquid | m |
Dimensional consistency is straightforward: L/D and f are dimensionless, while ρv² has units kg/(m·s²), equal to Pa. Convert Pa to kPa by dividing by 1,000, or to bar by dividing by 100,000.
Use a Darcy friction factor throughout. For the same flow condition it is four times the Fanning friction factor. Substituting a Fanning value into this equation without conversion underestimates straight-pipe loss by a factor of four. The Pipe Flow Darcy–Weisbach reference explains the factor convention.
Choose the friction factor from the flow regime
First calculate velocity and Reynolds number:
v = 4Q/(πD²), where Q is in m³/s.
Re = ρvD/μ, where dynamic viscosity μ is in Pa·s.
For fully developed laminar flow in a circular pipe, fD = 64/Re. For turbulent flow, the Colebrook–White relationship accounts for Reynolds number and relative roughness ε/D:
1/√fD = −2 log10[ε/(3.7D) + 2.51/(Re√fD)]
Because f appears on both sides, Colebrook needs an iterative solution. The explicit Swamee–Jain approximation is convenient in Excel:
fD = 0.25/{log10[ε/(3.7D) + 5.74/Re0.9]}²
This worksheet uses the laminar expression below Re = 2,000, flags 2,000–4,000 for review, and uses Swamee–Jain above 4,000. This is a conservative spreadsheet convention, not a sharp physical boundary. The EPA EPANET algorithm documentation describes its laminar and turbulent calculations; EPANET handles the intermediate region differently from the review flag used here.
Keep roughness and diameter in the same units. For example, 0.045 mm roughness equals 0.000045 m. Surface condition, corrosion, deposits, and lining can affect the value. A roughness selected for new pipe may not represent a fouled operating line.
Add fittings, valves, and equipment losses
Local losses are commonly expressed using a resistance coefficient K:
Δplocal = ΣK × ρv²/2
Add K values only when they refer to the same reference velocity. A reducer, branch connection, or component with a different bore may require its own velocity basis. Obtain coefficients for the actual geometry and valve position, or use manufacturer pressure-drop data.
The term “minor loss” does not mean negligible loss. In a short line with several restrictive components, local losses can exceed straight-pipe friction. For equipment such as filters and exchangers, use the appropriate vendor pressure drop at the design flow, fluid properties, and clean or fouled condition.
If an equivalent-length method is used, the corresponding relation is Leq = KD/fD for the stated basis. Use either the equivalent length or the K loss for that component. Counting both doubles its contribution. A tabulated equivalent length may use a particular reference friction factor, so check the source before converting it.
Worked example: water pipeline pressure drop
Consider a water transfer line between two pressure measurement sections of equal internal diameter. There is no pump or turbine between those sections. The outlet is 6 m above the inlet. The fitting total represents the components between the sections; no separate entrance, exit, or equipment loss is added.
| Input | Value |
|---|---|
| Water temperature | Approximately 20°C |
| Flow Q | 50 m³/h |
| Density ρ | 998 kg/m³ |
| Dynamic viscosity μ | 0.001 Pa·s |
| Internal diameter D | 0.1023 m |
| Straight length L | 100 m |
| Absolute roughness ε | 0.000045 m |
| Combined local-loss coefficient ΣK | 8.0 |
| Additional equipment loss | 0 Pa |
| Outlet elevation minus inlet elevation | +6 m |
| Gravity g | 9.81 m/s² |
The selected K total is an illustrative aggregate, not a recommended allowance for every pipeline. In a project worksheet, retain the individual component quantities and their data sources.
Step 1: Convert flow and find velocity
Q = 50/3600 = 0.0138889 m³/s
v = 4 × 0.0138889/(π × 0.1023²) = 1.6898 m/s
Use actual bore rather than nominal diameter. Pipe schedule, internal lining, and deposits change flow area even when the nominal line designation stays the same.
Step 2: Find Reynolds number and friction factor
Re = 998 × 1.6898 × 0.1023/0.001 = 172,517
ε/D = 0.000045/0.1023 = 0.000440
Swamee–Jain gives fD = 0.018886. An independent iterative Colebrook calculation gives approximately 0.018788. The friction-factor difference is about 0.52% for this case; this is a case-specific comparison, not a general accuracy guarantee.
Step 3: Calculate straight-pipe and fitting losses
Δppipe = 0.018886 × (100/0.1023) × (998 × 1.6898²/2) = 26.30 kPa
Δplocal = 8 × (998 × 1.6898²/2) = 11.40 kPa
Δploss = 26.30 + 11.40 = 37.70 kPa
The corresponding loss head is 37,702.7/(998 × 9.81) = 3.851 m. Fittings contribute approximately 30% of this result, so omitting them would materially change the assessment.
Step 4: Include elevation in the pressure balance
For equal inlet and outlet velocities, without a pump or turbine between the endpoints:
pin − pout = Δploss + ρg(zout − zin)
Elevation contribution = 998 × 9.81 × 6 = 58.74 kPa
Required pressure difference = 37.70 + 58.74 = 96.44 kPa
If the required outlet pressure is 200 kPa gauge, the corresponding inlet pressure is 296.44 kPa gauge, assuming both use the same atmospheric reference. Elevation changes static pressure but is not an irreversible friction loss. A downhill line can gain static pressure even while losing total mechanical energy.
If endpoint velocities differ, include ρ(vout² − vin²)/2 under the usual turbulent-flow kinetic-energy approximation. For laminar flow, appropriate kinetic-energy correction factors may be needed. Reservoir boundaries also require their correct velocity and entrance/exit treatment.
Pipeline pressure drop calculation in Excel
Put labels in column A, values or formulas in B, and units in C. These formulas use English Excel function names and commas; regional installations may require semicolons.
| Cell | Input | Value |
|---|---|---|
| B2 | Flow, m³/h | 50 |
| B3 | Density, kg/m³ | 998 |
| B4 | Dynamic viscosity, Pa·s | 0.001 |
| B5 | Internal diameter, m | 0.1023 |
| B6 | Straight length, m | 100 |
| B7 | Absolute roughness, m | 0.000045 |
| B8 | Total K | 8 |
| B9 | Outlet minus inlet elevation, m | 6 |
| B10 | Additional equipment loss, Pa | 0 |
| B11 | Gravity, m/s² | 9.81 |
| Cell | Output | Formula |
|---|---|---|
| B14 | Flow, m³/s | =B2/3600 |
| B15 | Velocity, m/s | =4*B14/(PI()*B5^2) |
| B16 | Reynolds number | =B3*B15*B5/B4 |
| B17 | Relative roughness | =B7/B5 |
| B18 | Darcy friction factor | =IF(B16<2000,64/B16,IF(B16>4000,0.25/(LOG10(B17/3.7+5.74/B16^0.9)^2),NA())) |
| B19 | Straight-pipe loss, Pa | =B18*(B6/B5)*B3*B15^2/2 |
| B20 | Local loss, Pa | =B8*B3*B15^2/2 |
| B21 | Total irreversible loss, Pa | =B19+B20+B10 |
| B22 | Total loss, kPa | =B21/1000 |
| B23 | Loss head, m | =B21/(B3*B11) |
| B24 | Elevation pressure contribution, Pa | =B3*B11*B9 |
| B25 | Required inlet minus outlet pressure, kPa | =(B21+B24)/1000 |
| B26 | Straight-pipe gradient, kPa/100 m | =B19/B6*100/1000 |
| B27 | Hydraulic power dissipated by losses, kW | =B14*B21/1000 |
B25 assumes equal endpoint velocities and no intervening pump or turbine. B26 deliberately excludes fittings and equipment so the reported gradient remains a straight-pipe quantity. B27 is 0.524 kW for the example; it is not motor input power. Motor sizing requires the complete pump duty and applicable efficiencies.
Validate positive flow, density, viscosity, diameter, length, and gravity. Roughness, K, and equipment loss must be nonnegative. Elevation may be positive or negative. Zero-flow cases require separate handling because the friction-factor expression divides by Reynolds number. Keep transitional-flow errors visible, and distinguish input cells from protected formula cells.
How flow, diameter, and roughness change the result
The following cases retain the same water properties, 100 m length, and K = 8. Each row recalculates Reynolds number and friction factor. Values below exclude elevation and additional equipment loss.
| Case | Flow, m³/h | Diameter, mm | Roughness, mm | Velocity, m/s | Total loss, kPa |
|---|---|---|---|---|---|
| Lower flow | 40 | 102.3 | 0.045 | 1.352 | 24.55 |
| Base case | 50 | 102.3 | 0.045 | 1.690 | 37.70 |
| Higher flow | 60 | 102.3 | 0.045 | 2.028 | 53.61 |
| Larger bore | 50 | 128.2 | 0.045 | 1.076 | 13.14 |
| Higher assumed roughness | 50 | 102.3 | 0.150 | 1.690 | 43.48 |
A 20% flow increase raises the example loss by approximately 42%. The relationship is close to flow squared here, but not exactly: friction factor also changes. At fixed flow, straight-pipe loss varies approximately with D−5 if f is held constant, while local loss with a fixed K varies with D−4. Always recalculate f and component data for a final comparison.
The larger-bore case reduces loss substantially, but it does not automatically establish the best pipe size. Compare installed cost, operating hours, energy cost, process constraints, and acceptable velocity. The constant K assumption is useful for comparison; verify the actual larger-size components before selecting equipment.
Extend the worksheet to a real piping system
For pipes in series, create one row per uniform segment. Record flow, diameter, length, roughness, fluid properties, and local components; calculate each segment’s losses and sum them. Apply endpoint elevation and velocity changes consistently to the full energy balance.
For branches or parallel paths, do not assume that every pipe carries the total flow. Solve continuity at junctions and compatible pressure changes along connected paths. A single-line spreadsheet cannot determine an unknown network flow split merely by summing pressure drops. The EPA EPANET resource describes a hydraulic network-modeling option for water systems.
On pump suction piping, friction loss also reduces available NPSH. Review the suction-line pressure-loss and NPSH guide rather than evaluating discharge head alone. For broader pump work, see the stated features of the separately listed pump sizing calculations spreadsheet.
Common mistakes and field troubleshooting
- Wrong viscosity units: 1 cP equals 0.001 Pa·s. Kinematic viscosity is a different quantity; convert using μ = ρν.
- Wrong bore: nominal size or outside diameter can understate velocity and loss.
- Double-counted components: do not add both K and equivalent length for the same fitting.
- Unrealistic valve position: a partially closed valve may have far greater resistance than the fully open model.
- Uncorrected measurements: pressure taps at different elevations measure an elevation contribution as well as loss.
- Hidden restrictions: check dirty strainers, fouling, blocked passages, and unexpected reducers when measured loss exceeds the model.
Compare measurements at a known, stable flow and temperature. Check pressure-instrument calibration and sensing-line effects before adjusting roughness to force a match. A mismatch may reflect omitted equipment or incorrect flow measurement rather than pipe-wall condition.
The calculation does not verify wall thickness, pressure rating, support loads, corrosion allowance, or transient surge. Compressible gases with significant density change, flashing liquids, two-phase flow, slurries, and non-Newtonian fluids require suitable models. No universal allowable pressure-drop gradient or velocity is imposed by the Darcy–Weisbach equation itself.
Frequently asked questions
1. What is the pipeline pressure drop formula?
For a uniform liquid line, irreversible pressure loss is (fL/D + ΣK)ρv²/2 plus separately specified equipment losses. Add elevation and endpoint velocity changes when calculating the required static pressure difference.
2. Can Darcy–Weisbach be used for liquids other than water?
Yes, with appropriate density, viscosity, roughness, and friction-factor treatment for the flow. This worksheet assumes a single-phase Newtonian liquid with effectively constant density.
3. What is the difference between head loss and pressure drop?
Head loss represents mechanical energy lost per unit weight. Pressure loss is related by Δp = ρgh. The same head loss corresponds to different pressure losses for liquids with different densities.
4. Should elevation be included in friction loss?
No. Keep elevation separate in the energy balance. For equal endpoint velocities, an upward elevation change increases the required inlet pressure; a downward change can recover static pressure.
5. Is Swamee–Jain the same as Colebrook?
Swamee–Jain is an explicit approximation. Colebrook is implicit and normally solved iteratively. Check applicability and the required calculation accuracy rather than assuming identical results.
6. Does this article include an Excel download?
The article includes a cell-by-cell layout and formulas for building your own worksheet. It does not include a newly created downloadable workbook.
7. Why is my measured pressure drop higher than calculated?
Possible causes include higher actual flow, a smaller bore, increased roughness, restricted valves, fouled equipment, or omitted fittings. Also verify elevation corrections, fluid temperature, and instrument accuracy.
Build a pressure balance that can be checked
For this example, straight-pipe friction and fittings consume 37.70 kPa. The 6 m rise adds 58.74 kPa, giving a 96.44 kPa inlet-to-outlet requirement. Preserve that distinction in Excel, document the component data, and test the credible operating cases. Explore more practical engineering calculations and resources at GrowMechanical.
