Booster Pump Calculation Excel -

(Note: 10.2 converts bar to meters of water)

#EngineeringExcel #PumpSizing #HydraulicCalculations #BoosterPump #ExcelForEngineers

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. booster pump calculation excel

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.

Q_m3h = 50 [m³/h] Q_m3s = Q_m3h / 3600 D_m = 0.08 [80 mm] Area = PI() * (D_m/2)^2 v = Q_m3s / Area f = 0.02 (assume clean steel pipe) L = 150 g = 9.81 H_friction = f * (L / D_m) * (v^2 / (2*g)) Create a lookup table for f based on pipe material and Reynolds number using the Moody chart. Use XLOOKUP or INDEX-MATCH . 2.3 NPSH Available (Net Positive Suction Head) – The Cavitation Check Cavitation destroys pumps. Always calculate NPSHa:

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

=CEILING(P_m, 1.5) ' Rounds up to nearest 1.5 kW or 2 HP Create a clean Output section that automatically updates:

H_friction = f * (L / D) * (v² / (2*g))

NPSHa = P_suction*10.2 - H_vapour - H_suction_friction Then use it on every project

| 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) |

NPSHa = (D10*10.2) - 0.34 - H_friction_suction Condition: NPSHa must be > NPSHr (from pump curve) by at least 0.5 m. Once you have TDH and Q, calculate hydraulic, shaft, and motor power.