Sheet - Pump Head Calculation Excel

v (m/s) = Q / (π*(D/1000)^2/4) / 3600 (if Q in m³/h) Velocity head = v²/(2g) Usually if suction/discharge diameters are equal. Section 5: Friction Loss – Darcy-Weisbach Reynolds number : ( Re = \fracv \cdot D\nu ) Friction factor f : use Colebrook or Moody approximation. In Excel, use this simplified explicit formula (Swamee-Jain): f = 0.25 / [ LOG10( ε/(3.7*D) + 5.74/Re^0.9 ) ]^2 Then head loss in pipe:

h_friction_pipe = f * (L/D) * (v²/(2g)) Fittings losses (equivalent length method or K-factor): pump head calculation excel sheet

h_fittings = (K_elbow * n_elbow + K_valve * n_valve) * v²/(2g) Total friction head = pipe loss + fittings loss TDH = H_static + H_friction_total + H_velocity (if any) Section 7: Output & Results | Description | Value | Unit | |-------------|-------|------| | Static head | 33.19 | m | | Suction friction | 0.85 | m | | Discharge friction | 12.40 | m | | Total pump head | 46.44 | m | | Required hydraulic power | (Q * TDH * ρ * g)/3600000 | kW | v (m/s) = Q / (π*(D/1000)^2/4) / 3600

Pump head (total dynamic head, TDH) is the total energy that a pump must impart to the fluid to move it from suction to discharge. It is expressed in meters (or feet) of liquid column. It is expressed in meters (or feet) of liquid column