Cell A10: Elevation (m) = 25 Cell B10: Friction Loss (m) = Calculate per 2.2 below Cell C10: P_discharge (bar) = 4.0 Cell D10: P_suction (bar) = 2.5 Cell E10: TDH (m) = A10 + B10 + (C10 - D10)*10.2 This is where Excel shines for iterative design.
| Parameter | Formula | Excel Example | | :--- | :--- | :--- | | Hydraulic Power (P_h) | Q (m³/s) * TDH (m) * ρ * g | = (Q_m3h/3600) * TDH * 1000 * 9.81 | | Shaft Power (P_s) | P_h / Pump Efficiency (η_p) | = P_h / 0.75 (for 75% efficiency) | | Motor Power (P_m) | P_s / Motor Efficiency (η_m) | = P_s / 0.92 |
=CEILING(P_m, 1.5) ' Rounds up to nearest 1.5 kW or 2 HP Create a clean Output section that automatically updates: booster pump calculation excel
A booster pump isn’t just a "water pusher." It is the critical component that ensures adequate pressure and flow in water supply systems—from high-rise buildings and industrial plants to irrigation networks. Under-sizing leads to low pressure at fixtures; over-sizing leads to energy waste, premature wear, and cavitation.
The most reliable way to avoid these pitfalls? A well-structured . While dedicated software exists, Excel remains the industry workhorse because it is transparent, customizable, and universally accessible. Cell A10: Elevation (m) = 25 Cell B10:
H_friction = f * (L / D) * (v² / (2*g))
In this post, I’ll break down the key calculations every booster pump sizing spreadsheet must include, complete with formulas and logic. Your Excel sheet should start with a clear Input tab. Without accurate data, the best formulas are useless. The most reliable way to avoid these pitfalls
TDH = H_geo + H_friction + (P_discharge - P_suction) * 10.2
Download a template or build one using the formulas above. Test it against a known installed pump. Refine it with your local pipe material data. Then use it on every project. Have you built your own pump sizing spreadsheet? What’s the most useful feature you’ve added? Let’s discuss in the comments.
NPSHa = P_suction*10.2 - H_vapour - H_suction_friction