Booster Pump Head Calculation Xls [work] <ORIGINAL ✮>
The calculation of the Total Dynamic Head (TDH) for a booster pump is essential to ensure the system delivers the required pressure and flow to the most remote fixture.
): The vertical distance (elevation change) between the water source and the highest delivery point. Friction Head ( Hfrictioncap H sub f r i c t i o n end-sub booster pump head calculation xls
Step 4: Suction Side Loss (Negligible if tank above pump)
- Static suction head = +1.5 m positive (flooded suction).
- Suction pipe friction = 0.5 m.
- Net positive suction head available (NPSHa) must be calculated separately in XLS to avoid cavitation.
Title: The Excel Sheet That Saved the 15th Floor The calculation of the Total Dynamic Head (TDH)
Pressure Increase Required (ΔP): The increase in pressure needed, usually measured in pounds per square inch (psi) or kilopascals (kPa). Static suction head = +1
5. Additional outputs
- Pump brake power (approx):
Without the sheet, she might have forgotten the fixture pressure requirement and undersized the pump by 25 m. The Excel file also flagged that her initial 80 mm pipe would cause too much friction—she upsized to 100 mm, saving long-term energy costs.
| Input | Value | Unit | Formula | | --- | --- | --- | --- | | Flow rate (Q) | 0.01 | m^3/s | | | Length of pipe (L) | 1000 | m | | | Diameter of pipe (D) | 0.1 | m | | | Elevation of suction point (Zs) | 10 | m | | | Elevation of discharge point (Zd) | 20 | m | | | Friction factor (f) | 0.02 | - | | | Velocity of fluid (V) | 1.5 | m/s | | | Friction head loss (Hf) | =0.02* (1000/0.1)* (1.5^2/2*9.81) | m | =(F2* (F3/F4)* (F7^2/2*9.81)) | | Static head (Hs) | =F5-F6 | m | =(F5-F6) | | Margin of safety (Hm) | =0.1*(Hf+ Hs) | m | =0.1*(F8+F9) | | Total head (H) | =F8+F9+F10 | m | =(F8+F9+F10) |
- Velocity head:
