=CEILING(P_m, 1.5) ' Rounds up to nearest 1.5 kW or 2 HP Create a clean Output section that automatically updates:
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. booster pump calculation excel
| Parameter | Unit | Description | Typical Value | | :--- | :--- | :--- | :--- | | Flow Rate (Q) | m³/h or GPM | Peak demand (fixture units, sprinkler heads, etc.) | Variable | | Suction Pressure (P_suction) | bar or psi | Pressure available at pump inlet (from city main or tank) | 2.5 bar | | Required Discharge Pressure (P_discharge) | bar or psi | Pressure needed at the highest/farthest fixture | 4.0 bar | | Elevation Difference (H_geo) | m or ft | Vertical distance from pump to highest point | 25 m | | Pipe Length (L) | m | Total length of the longest run | 150 m | | Pipe Diameter (D) | mm or in | Nominal bore | 80 mm | | Friction Factor (f) | dimensionless | Darcy-Weisbach or Hazen-Williams C-factor | 0.02 (or C=130) | =CEILING(P_m, 1