Pump Head Calculation Excel Jun 2026

$$H_total = H_static + H_pressure + H_friction$$

Create a table for your system variables. Essential inputs include:

The phrase is more than a keyword—it represents a practical, powerful approach to hydraulic design. With a well-structured spreadsheet, you can size pumps in minutes, avoid costly field modifications, and present clear data to clients or senior engineers. pump head calculation excel

You don’t have to start from zero. Search for:

To calculate pump head in Excel, you must determine the Total Dynamic Head (TDH) , which is the sum of the vertical lift ( Static Head ) and the energy lost due to moving fluid through pipes ( Friction Head ICC - International Code Council Core Components for Excel Calculation $$H_total = H_static + H_pressure + H_friction$$ Create

This accounts for the pressure difference between the destination tank and the source tank. If you are pumping into a pressurized vessel, the pump must work harder.

Pump water from Tank A (atmospheric) to Tank B (open), 25m higher. Flow = 150 m³/hr. Pipe = 200mm ID steel, total length = 300m. Fittings: 4 elbows, 2 gate valves, 1 check valve. You don’t have to start from zero

The Reynolds number ($Re$) determines if the flow is laminar or turbulent. This dictates which friction factor calculation we use. $$Re = (\rho \times V \times D) / \mu$$

Htotal=Hstatic+Hfriction+Hpressure+Hvelocitycap H sub t o t a l end-sub equals cap H sub s t a t i c end-sub plus cap H sub f r i c t i o n end-sub plus cap H sub p r e s s u r e end-sub plus cap H sub v e l o c i t y end-sub The vertical distance the fluid must be lifted. Friction Head ( Hfrictioncap H sub f r i c t i o n end-sub

Better: = =PI()*(B4/2000)^2 Velocity (m/s) = =(B3/1000)/C20 (where C20 = area)