Booster Pump Head | Calculation Xls

Booster Pump Head Calculation using Excel

Introduction

Booster pumps are used to increase the pressure of a fluid in a piping system. They are commonly used in water supply systems, irrigation systems, and industrial processes. The head calculation of a booster pump is crucial to ensure that it can provide the required pressure to overcome the losses in the system and deliver the desired flow rate. This paper will discuss the calculation of booster pump head using Microsoft Excel.

Booster Pump Head Calculation

The head of a booster pump is calculated using the following formula:

H = Hf + Hs + Hm

Where:

H = Total head (m)
Hf = Friction head loss (m)
Hs = Static head (m)
Hm = Margin of safety (m)

Friction Head Loss (Hf)

The friction head loss is calculated using the Darcy-Weisbach equation:

Hf = f * (L/D) * (V^2/2g)

Where:

f = Friction factor
L = Length of pipe (m)
D = Diameter of pipe (m)
V = Velocity of fluid (m/s)
g = Acceleration due to gravity (m/s^2)

Static Head (Hs)

The static head is the difference in elevation between the suction and discharge points:

Hs = Zs - Zd

Where:

Zs = Elevation of suction point (m)
Zd = Elevation of discharge point (m)

Margin of Safety (Hm)

The margin of safety is added to account for any uncertainties in the system:

Hm = 10-20% of H

Excel Calculation

To calculate the booster pump head using Excel, we can create a simple spreadsheet with the following inputs:

| Input | Value | Unit | | --- | --- | --- | | Flow rate (Q) | | m^3/s | | Length of pipe (L) | | m | | Diameter of pipe (D) | | m | | Elevation of suction point (Zs) | | m | | Elevation of discharge point (Zd) | | m | | Friction factor (f) | | - | | Velocity of fluid (V) | | m/s |

The calculations can be performed using the following steps:

Calculate the friction head loss (Hf) using the Darcy-Weisbach equation
Calculate the static head (Hs) using the elevation difference
Calculate the margin of safety (Hm) as a percentage of the total head
Calculate the total head (H) by adding Hf, Hs, and Hm

Example Calculation

Suppose we want to calculate the booster pump head for a water supply system with the following inputs:

| Input | Value | Unit | | --- | --- | --- | | 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 |

Using the calculations above, we get:

Hf = 0.02 * (1000/0.1) * (1.5^2/2*9.81) = 2.29 m Hs = 20 - 10 = 10 m Hm = 10% of H = 0.1 * (2.29 + 10) = 1.23 m H = 2.29 + 10 + 1.23 = 13.52 m

Conclusion

The calculation of booster pump head is an important step in designing a piping system. Using Excel, we can create a simple and efficient tool to perform these calculations. By inputting the required parameters, we can quickly calculate the total head required for the booster pump. This calculation can be used to select the correct pump and ensure that it can provide the required pressure to overcome the losses in the system and deliver the desired flow rate.

References

Munson, B. R., Young, D. F., & Okiishi, T. H. (2013). Fundamentals of fluid mechanics. John Wiley & Sons.
Darcy, H. (1857). Les fontaines publiques de la ville de Dijon. Dalmont.

Appendix

Below is an example Excel spreadsheet for calculating booster pump head:

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

Please note that this is a simplified example and actual calculations may require more complex formulas and considerations.

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

Abstract

Provide a concise Excel workbook to calculate booster pump head requirements for a system, including friction losses, static lift, velocity head, fittings, safety margin, and pump selection guidance.

3. Material Cost & Energy Cost Estimator

Pipe friction = pumping cost. Add annual kWh calculation: kW = (Flow × Head × SG)/(367 × Pump Efficiency)
Multiply by operating hours and $/kWh. A bigger pipe may save money over 10 years.

🛠 Recommendations for Use

| Do | Don’t | |----|-------| | ✅ Lock input cells / use data validation | ❌ Rely on it for final pump selection without checking curves | | ✅ Add a “design margin” cell (e.g., 1.1 factor) | ❌ Ignore NPSH calculation | | ✅ Validate with real operating data | ❌ Use for viscous or multiphase fluids | | ✅ Include a pressure tank drawdown check for variable flow | ❌ Forget to account for parallel or standby pumps | booster pump head calculation xls

Part 1: The Hydraulic Foundation – What Is Pump Head?

Before entering data into your XLS, understand that "head" is the height of a fluid column that the pump can generate, measured in meters (or feet). For booster pumps, we calculate Total Dynamic Head (TDH) .

❌ Common Weaknesses / Errors to Check

| Issue | Why It Matters | |-------|----------------| | Hidden or unprotected formulas | Users may accidentally break calculations. | | No friction loss for all pipe materials | Some sheets assume only PVC or steel. | | Ignores temperature effects | Viscosity and density changes affect pump performance. | | No allowance for future fouling | Pipes scale up → higher friction loss over time. | | Minor losses underestimated | Many sheets use only 10–20% of friction loss, which is often too low for systems with many valves/fittings. | | No NPSH margin | Should have a safety factor (e.g., 0.5–1 m extra). | | Doesn’t check pump operating point | Without pump curves, you might select an undersized pump. |

2. Suction Side Data

Elevation difference from supply tank water level to pump suction flange.
Supply pressure (if city water or pressurized line). Enter in bar or psi; convert to meters (1 bar = 10.2 m).
Pipe length, diameter, material (for friction factor).

4. Calculations (with suggested Excel formulas)

Convert units:
- B4: Q_m3s = =A4/1000
- B7: D_m = =A7/1000
Cross-sectional area:
- B20: Area = =PI()*(B7/2)^2
Velocity:
- B21: V = =B4/1000 / B20
Reynolds number:
- B22: Re = =B21B7/1e3B6/(B6) (use correct formula below)
- Correct formulas to use in sheet:
  - Q_m3s: =A4/1000
  - D_m: =A7/1000
  - Area: =PI()*(D_m/2)^2
  - V: =Q_m3s/Area
  - Re: =VD_m1000/(A6) — (if A6 in Pa·s; otherwise use kinematic viscosity)
Friction factor (f) — use Colebrook-White implicit solution approximated by Swamee-Jain:
- f = 0.25 / (LOG10( (ε/(3.7*D)) + (5.74/(Re^0.9)) ))^2
- Excel: =0.25/(LOG10( (A14/(3.7D_m1000)) + (5.74/(Re^0.9)) ) )^2
- Note: ensure units of ε and D match (mm vs m) — better convert ε to m first: eps_m = A14/1000.
Head loss due to friction (hf):
- hf = f*(L/D_m)(V^2/(2g))
- Excel: =f*(A8/D_m)(V^2/(29.81))
Head loss due to fittings (h_fittings):
- Sum K_total = A10A12 + A11A13
- h_fittings = K_total*(V^2/(2*g))
Velocity head:
- h_velocity = V^2/(2*g)
Total dynamic head (TDH) before margin:
- TDH = H_static + hf + h_fittings + h_velocity
Apply safety margin:
- TDH_design = TDH*(1 + A15/100)