We also offer time tracking, invoicing, estimates & project management software.
| Mistake | Consequence | Fix in XLS | |---------|-------------|-------------| | Forgetting velocity head | Minor error (<0.5m) | Usually ignore unless very high flow/small pipe | | Using static head incorrectly | Major error (meters) | Always measure from pump centerline | | Ignoring suction side losses | Cavitation, noise | Add suction pipe friction + fittings | | Double counting required pressure | Pump far too large | Required outlet pressure is part of TDH, not added after | | No variable for future scaling | No flexibility | Add "Design Margin" cell (5–15%) | | Using wrong pipe ID (OD instead of ID) | Underestimation of loss | Always use inner diameter |
A lookup section for "Equivalent Lengths" of valves and fittings (elbows, tees, check valves).
For your Excel sheet, you should create separate sections for these three primary values: Static Head ( Hstaticcap H sub s t a t i c end-sub
An Excel spreadsheet (XLS) automates these calculations to save time and reduce errors. 1. What is Booster Pump Head? booster pump head calculation xls
She found a Reddit thread where an old contractor named PumpGuru60 shared a link to a clean, unlocked Excel workbook. The sheet had color-coded cells:
TDH=(Zdischarge−Zsuction)+(Pdischarge−Psuction)ρg+hfriction_totalcap T cap D cap H equals open paren cap Z sub d i s c h a r g e end-sub minus cap Z sub s u c t i o n end-sub close paren plus the fraction with numerator open paren cap P sub d i s c h a r g e end-sub minus cap P sub s u c t i o n end-sub close paren and denominator rho g end-fraction plus h sub f r i c t i o n _ t o t a l end-sub 4. Step-by-Step Spreadsheet Calculation Step 1: Define System Constraints
hm=K×(v2÷2g)h sub m equals cap K cross open paren v squared divided by 2 g close paren = Velocity of fluid ( = Acceleration due to gravity ( | Mistake | Consequence | Fix in XLS
Valves, tees, and elbows add turbulence and friction. Convert every fitting into an equivalent length of straight pipe using standard engineering tables. Step 4: Define Required Residual Pressure ( Hpcap H sub p Every fixture needs minimum pressure to function. Standard residential fixtures: 15 to 20 PSI Commercial flushometer valves: 25 to 35 PSI Convert PSI to Feet of Head: 3. Designing Your Excel Spreadsheet Structure
Lowest Suction Water Level Elevation — [Feet or meters] Cell B12: Required Terminal Pressure — [PSI or bar] Block C: Automated Calculations (Formulas) Static Head (Cell B15): =B10-B11
Always add a 5% to 10% safety cushion to your calculated TDH to account for internal pipe aging and scale buildup over time. What is Booster Pump Head
Sum up all the calculated values to get the TDH. It is good practice to add a "Safety Factor" cell (typically multiplying your final TDH by 1.10 to 1.15 or adding 5-10% to head requirements) to account for future pipe scaling or minor calculation discrepancies. Net Positive Suction Head (NPSH) - Don't Forget This!
Static head is the vertical distance the fluid must be lifted against gravity.
If building an Excel sheet from scratch sounds daunting, there is a wealth of pre-made templates available online. You can download and modify structured TDH calculators from trusted engineering repositories, such as the comprehensive templates offered on sites like Piping-tools.net .
Priya, a junior mechanical engineer at AquaRise Consultants , had just been handed her first solo project: design a booster pump system for a new 20-story residential tower. The client was clear—residents on the top floors couldn’t suffer from dribbling showers during morning peak hours.
Please note that this is a simplified example and actual calculations may require more complex formulas and considerations.