Head Calculation Xls | Booster Pump

Calculating the correct head for a booster pump is the difference between a high-performing water system and one that barely trickles at the top floor. To get this right in an Excel sheet, you need to account for three major "energy thieves": elevation, friction, and residual pressure. The Core Formula for Pump Head In your Excel spreadsheet, the Total Dynamic Head ( TDHcap T cap D cap H ) is the sum of these key components:

Step 2: Required Outlet Pressure

• Minimum tap pressure (by code) = 2 bar = 20.4 m head.
• Add this to static head: 16.5 + 20.4 = 36.9 m (Minimum TDH at zero flow)

Introduction

Result: Pump selection should deliver 10 m³/hr at 39.5 m head, with duty point near best efficiency point (BEP). booster pump head calculation xls

2. Parallel Pump Operation Curve

For multiple pumps, your XLS can sum flows at same head. Great for duty/standby or lead-lag configurations.

Do you have a booster pump head calculation XLS you want reviewed? Or a specific scenario (e.g., seawater, high-rise, VSD)? Leave a comment or contact our engineering team for a free template review. Calculating the correct head for a booster pump

Resistance caused by fluid moving through pipes. This is often calculated using the Hazen-Williams Darcy-Weisbach equations. Minor Losses ( cap H sub m

TDH equals cap H sub s plus cap H sub f plus cap H sub required pressure end-sub minus cap H sub existing supply end-sub Calculating Total Dynamic Head - Grundfos Minimum tap pressure (by code) = 2 bar = 20

Step D: System Curve Generation

Make a column (G1:G10) with flows: 0, 2, 4, 6, 8, 10, 12 m³/hr. Compute TDH for each. Plot X-Y scatter chart. Compare to pump data.