Use data validation dropdowns for units (e.g., m vs. ft) and apply CONVERT functions to standardize all inputs to SI or US customary internally. Part 2: Key Calculations (The Engine of Your Spreadsheet) In a hidden or dedicated column, perform these critical steps. 2.1 Total Dynamic Head (TDH) – The Master Formula The pump must overcome three things: elevation, friction, and velocity head (usually negligible). The core Excel formula for TDH (in meters of water column) is:
(Note: 10.2 converts bar to meters of water)
H_friction = f * (L / D) * (v² / (2*g)) booster pump calculation excel
#EngineeringExcel #PumpSizing #HydraulicCalculations #BoosterPump #ExcelForEngineers
NPSHa = P_suction*10.2 - H_vapour - H_suction_friction Use data validation dropdowns for units (e
| Output Parameter | Value | Unit | Status | | :--- | :--- | :--- | :--- | | Total Dynamic Head | 52.3 | m | ✅ OK | | Flow Rate | 50 | m³/h | ✅ OK | | NPSHa | 4.2 | m | ✅ > NPSHr (3.7 m) | | Required Motor Power | 11 | kW | Select 11 kW / 15 HP | | Velocity | 2.1 | m/s | ⚠️ High (limit 2.0 m/s) |
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
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.
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.