Use Excel to test maximum and minimum demand scenarios. 6. Accessing/Building Your Own Tool
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
Hf=10.67×L×Q1.852C1.852×d4.87cap H sub f equals the fraction with numerator 10.67 cross cap L cross cap Q to the 1.852 power and denominator cap C to the 1.852 power cross d to the 4.87 power end-fraction = Pipe Length = Flow Rate = Hazen-Williams Roughness Coefficient = Inside Diameter
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
: Utilize Excel’s charting capabilities to visualize how changes in input parameters affect the pump head. booster pump head calculation xls
Calculating the total dynamic head (TDH) for a booster pump involves summing static elevation, friction losses from piping and fittings, and the required residual pressure at the final fixture. Core Calculation Components
| Issue | Why It Matters | |-------|----------------| | | 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. |
=((B2*0.321) / (3.14159 * (C2/2)^2))
=IF(B4>0, ( ( (B12*B6)/(2*9.81) ) * ( ( (4*B4/3600)/(PI()*(B6/1000)^2) )^2 ) ) , 0 ) Use Excel to test maximum and minimum demand scenarios
A booster pump ensures adequate water pressure in high-rise buildings, water treatment plants, and industrial facilities. Selecting the wrong pump leads to low pressure, high energy bills, or premature equipment failure. To avoid this, engineers calculate the Total Dynamic Head (TDH) required.
: Pipe roughness coefficient (e.g., PVC = 150, Copper = 130, Galvanized Iron = 100) D : Inside pipe diameter (meters) The Darcy-Weisbach Equation & Reynolds Number
A 2-inch Schedule 40 steel pipe has a different internal diameter than a 2-inch Schedule 80 PVC pipe. Always use the actual inside diameter (ID) in formulas. 5. Interpreting Results for Pump Selection
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 Convert every fitting into an equivalent length of
Use these specific Excel formulas to automate your spreadsheet backend: Water Velocity (
If a municipal line feeds your pump with 2 bar (approx. 20 meters) of pressure, your pump does less work. Subtract this value from your total. Structuring Your Excel (.xls / .xlsx) Calculator
Boost water from a main to a rooftop tank 30 feet above. Incoming Pressure: 20 PSI. Required Head at Top: 10 PSI. Pipe: 100 ft of 1.5-inch PVC (with 5 elbows). (let's assume 5 ft). The pump needs to be capable of of head at the required flow rate. 6. Tips for Accurate Calculations Always consider max flowAlways consider max flow