Excel Sheet | Pump Head Calculation

The energy loss caused by the resistance of pipe walls and fittings.

f = 0.25 / [LOG10( ε/(3.7*D) + 5.74/Re^0.9 )]^2

A professional calculation sheet typically uses a "Sectional" layout to keep variables organized. 1. Input Parameters Calculation of Pump Sizing - ExcelCalcs pump head calculation excel sheet

Here is an example of a pump head calculation Excel sheet:

Velocity (m/s) = Flow Rate / (Pipe Cross-sectional Area) = (B1/3600) / (PI()*(B2/1000)^2/4) The energy loss caused by the resistance of

= friction_factor * (B3 / (B2/1000)) * (Velocity^2 / (2*9.81))

Fittings losses (equivalent length method or K-factor): Input Parameters Calculation of Pump Sizing - ExcelCalcs

💡 Head (ft) = Pressure (psi) * 2.31 / Specific Gravity

| Category | Inputs | |----------|--------| | Fluid properties | Density, viscosity, vapor pressure (for cavitation check) | | Suction side | Static suction head, pipe diameter, length, fittings, valves | | Discharge side | Static discharge head, pipe diameter, length, fittings, valves, pressure tank data | | Flow data | Design flow rate (e.g., m³/h or GPM) | | Friction data | Pipe roughness (ε), friction factor method (e.g., Moody, Hazen-Williams) |

Pump head is the total energy that a pump imparts to a fluid, expressed in (imperial) or meters (metric). It represents the height of a fluid column that the pump can overcome, factoring in pressure, elevation, and friction losses.

Use a higher friction factor for older pipes to account for scaling.