TDH = 36.9 (static + required pressure) + 4.0 (friction) – 1.5 (suction help) ≈ 39.4 m
Result: Pump selection should deliver 10 m³/hr at 39.5 m head, with duty point near best efficiency point (BEP).
Provide one worked example in the sheet using typical values:
Your XLS must automatically compute friction loss using: booster pump head calculation xls
Fittings equivalent length table (elbow 90° = 30D, tee = 60D, gate valve = 8D, check valve = 100D).
Excel (XLS) is widely used for engineering calculations due to its flexibility and powerful computational capabilities. For booster pump head calculations, an XLS file can be set up to:
An XLS template for booster pump head calculations might include: TDH = 36
Worksheet for Calculations:
Worksheet for Results:
TDH = Hₛ + H_d + H_f + H_v
Where:
Booster Pump Head Calculation — Excel Workbook Design
A professional booster pump head calculation xls is not just a simple calculator. It should contain the following tabs/features: Provide one worked example in the sheet using
| Feature | Purpose | |---------|---------| | Input Sheet | Flow, pipe lengths, diameters, elevations, required outlet pressure | | Friction Loss Tables | Embedded lookup tables for Hazen-Williams C values, Darcy friction factors | | Fittings Equivalent Length Database | Dropdown selection for elbow, tee, reducer, valve, backflow preventer | | NPSH Available Calculator | Compare against pump’s NPSH required (NPSHr). Red cells if insufficient | | Multi-Flow Point Calculation | Generate system curve (0%, 25%, 50%, 75%, 100%, 120% of design flow) | | Viscosity Correction | For hot water or glycol systems | | Unit Converter | Bar to m, psi to ft, GPM to m³/hr | | Pump Selection Table | Extract data from Grundfos, Wilo, Armstrong, KSB curves (manual entry or API) |
💡 Pro Tip: Do not trust a free XLS that skips NPSH or fitting losses. Those are the leading causes of pump failure.