The heart of the engineering design process is finding the intersection of accurate data and efficient tools. For booster pump sizing, the is the ideal blend of both.
If you are currently setting up a spreadsheet, I can help you write the exact Excel formulas for your specific pipe materials. Tell me:
TDH=(Elevdis−Elevsuc)+Hfriction+Hfittings+(Pdesiredρg)−(Psupplyρg)cap T cap D cap H equals open paren cap E l e v sub d i s end-sub minus cap E l e v sub s u c end-sub close paren plus cap H sub f r i c t i o n end-sub plus cap H sub f i t t i n g s end-sub plus open paren the fraction with numerator cap P sub d e s i r e d end-sub and denominator rho g end-fraction close paren minus open paren the fraction with numerator cap P sub s u p p l y end-sub and denominator rho g end-fraction close paren In simpler terms: 2. Friction Loss Formula (Hazen-Williams)
[Suction Source] ---> (H_in) ---> [Booster Pump] ---> (H_f + H_s) ---> [Highest Outlet (H_d)] Hscap H sub s booster pump head calculation xls
This guide breaks down the physics of booster pump head calculation and provides the formulas needed to build an Excel spreadsheet ( .xls ) for automated engineering design. 1. Understanding Total Dynamic Head (TDH)
: Losses due to friction in the pipes, fittings, and valves, which depend on the pipe size, flow rate, and type of pipe material.
The friction head loss is calculated using the Darcy-Weisbach equation: The heart of the engineering design process is
hf=10.67×L×Q1.852÷(C1.852×D4.87)h sub f equals 10.67 cross cap L cross cap Q to the 1.852 power divided by open paren cap C to the 1.852 power cross cap D to the 4.87 power close paren = Friction loss (meters) = Length of pipe (meters) = Flow rate (
To build an efficient Excel calculation sheet, structure your workbook with dedicated input, calculation, and output blocks. Your sheet must solve for the following four elements: 1. Static Head ( Hscap H sub s
Total Dynamic Head (TDH) = Static Head + Friction Head Loss + Pressure Head + Velocity Head Key Variables Defined Static Head ( Hscap H sub s Understanding Total Dynamic Head (TDH) : Losses due
Convert total fixture units to flow rate using Hunter’s Curve. This yields the flow rate in Liters per Second (L/s) or Gallons per Minute (GPM). Step 2: Measure the Static Head ( Hscap H sub s
Do you prefer or imperial units (feet, GPM) ? What pipe material (PVC, Copper, Steel) are you using?
Program these specific Excel formulas to calculate head components automatically: =((B4/3600)/((PI()*(B6/1000)^2)/4)) Hazen-Williams Friction Loss Per Meter (
Comprehensive Guide to Booster Pump Head Calculation (with Excel XLS Workflow)
A lookup section for "Equivalent Lengths" of valves and fittings (elbows, tees, check valves).