Pump Head Calculation Xls | Booster

Here’s a concise review of a typical Booster Pump Head Calculation Excel Sheet (XLS), covering its usual strengths, weaknesses, and accuracy considerations.

4. Friction Loss Components (Critical)

Your XLS must automatically compute friction loss using:

  • Darcy-Weisbach (most accurate, requires pipe roughness ε)
  • Hazen-Williams (common for water in building services, C-factor: PE 140, steel 100, old pipes 80)

Fittings equivalent length table (elbow 90° = 30D, tee = 60D, gate valve = 8D, check valve = 100D).

Part 9: Real-World Case Study – Head Calculation XLS Prevents Disaster

Problem: A contractor sized a booster pump using a “rule of thumb” (5 bar for every 10 floors). They installed a 15 kW pump for a 6-floor building. Result: burst pipes, noise complaints, and 200% energy waste. booster pump head calculation xls

Solution with XLS:

  • An engineer built a simple XLS with Darcy-Weisbach.
  • At 6 m³/hr flow, correct TDH was 32 m (3.2 bar).
  • Existing pump delivered 55 m (5.5 bar) → throttling valve wasted 2.3 bar.
  • Replaced pump with 5.5 kW unit (proper impeller trim). Annual energy saving: $4,800. Payback: 3 months.

The XLS paid for itself 100× over.

System Curve vs. Pump Curve

Your XLS should ultimately generate a system curve (flow vs. required head) to compare against pump manufacturer curves. If your spreadsheet cannot do this, it is incomplete. Here’s a concise review of a typical Booster

Part 3: Step-by-Step – How to Perform Booster Pump Head Calculation in Excel

Let’s walk through a sample scenario to see how the XLS should work.

Scenario: A residential building of 6 floors (ground +5). Booster pump to supply potable water to 20 apartments. Flow required = 10 m³/hr.

8. Notes & References

  • Use g = 9.81 m/s².
  • For accurate friction factor for all Re regimes, use built-in iterative solver for Colebrook or Excel’s Goal Seek / VBA function; Swamee-Jain is acceptable for turbulent flow Re > 4000.
  • If fluid is not water or temperature differs, update density and viscosity.
  • For multiple pipe runs or fittings distributed, allow segmented pipe inputs or multiple line items.

The Master Formula:

TDH = Hₛ + H_d + H_f + H_v

Where:

  • Hₛ = Static Suction Head (vertical distance from water source to pump centerline)
  • H_d = Static Discharge Head (vertical distance from pump centerline to the highest outlet)
  • H_f = Total Friction Losses (pipes, fittings, valves, meters)
  • H_v = Velocity Head (usually negligible in booster systems, but included for accuracy)

✅ Strengths (What’s Usually Good)

| Feature | Comment | |---------|---------| | Flow rate input | Clear cells for GPM, L/s, or m³/h. | | Static head calculation | Correctly sums elevation difference (suction to discharge). | | Friction loss estimation | Often includes Hazen-Williams or Darcy-Weisbach equations. | | Minor losses | Some sheets allow K-factors or equivalent lengths. | | Pressure tank sizing | Advanced versions include drawdown calculations. | | NPSH check | Good sheets include NPSH available vs. required. | | Unit flexibility | Supports both metric and imperial units. | | Graphs | Some generate system curve vs. pump curve. |