Booster Pump Head Calculation Xls [better]
:
Account for the resistance from fittings. In your XLS, use the "Equivalent Length" method or How to Calculate Total Dynamic Head
Your summary block will display the exact operational target for pump selection: 5.0 L/s Calculated TDH: Value of Cell B23 (meters) Common Sizing Pitfalls to Avoid Ignoring Minimum Inlet Pressure: Failing to subtract Hincap H sub i n end-sub
Avoid these frequent mistakes when building or using an XLS calculator:
Measure the vertical height from the pump centerline to that highest fixture. booster pump head calculation xls
The pressure required at the tap for a fixture to work correctly (e.g., 20–30 PSI for a shower). Step-by-Step Calculation for Excel
TDH=Hstatic+Hfriction+Hrequired−Hsupplycap T cap D cap H 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 r e q u i r e d end-sub minus cap H sub s u p p l y end-sub Static Head ( Hstaticcap H sub s t a t i c end-sub
TDH=Hs+Hf+HpTDH equals cap H sub s plus cap H sub f plus cap H sub p Static Head ( Hscap H sub s This is the physical vertical distance the water must lift.
): The vertical distance (in feet or meters) from the pump to the highest fixture. Friction Head ( Hfrictioncap H sub f r i c t i o n end-sub : Account for the resistance from fittings
To ensure your Excel sheet produces a valid engineering result, always verify the following factors before selecting a final pump:
If your system uses from an underground tank or positive suction from a city main
Good for preliminary design, but not a substitute for professional hydraulic analysis.
If you are designing water booster systems, take an afternoon to build or audit your XLS. Your pumps will last longer, your customers will have stable pressure, and your energy bills will thank you. If you are designing water booster systems, take
Where:
Commercial fixtures need baseline pressure to operate properly.
Let’s walk through a sample scenario to see how the XLS should work.
, which is the total pressure the pump must generate to overcome gravity and friction.