The energy lost as water flows through pipes, fittings, and valves. Triple "D" Pump Company Pressure Head ( cap H sub p
=SUM(Straight_Pipe_Cell, Total_Fitting_Length_Cell)
Create a sub-table for fittings, multiplying the number of each fitting by its equivalent length. Step 3: Calculate Total Head
(Pressure Head): The difference in pressure between the discharge point and the suction point (essential for closed-loop systems or pressurized tanks). Hvcap H sub v booster pump head calculation xls
TDH=Hs+Hf+HrTDH equals cap H sub s plus cap H sub f plus cap H sub r = Total Dynamic Head (m or ft) Hscap H sub s = Total Static Head ( Hfcap H sub f = Total Friction Head Loss (pipes + fittings) Hrcap H sub r = Residual Pressure required at the remote fixture 3. Step-by-Step Calculation Methodology Step 1: Determine the Flow Rate (Q)
: The elevation difference between the water source level and the highest fixture. Supply PressureSupply Pressure
In a summary cell, enter the formula to sum: =StaticLift + FrictionLoss_Pipe + FrictionLoss_Fittings + RequiredPressure Step 4: Add Safety Margin The energy lost as water flows through pipes,
(Residual/Pressure Head): The minimum pressure required at the furthest fixture (e.g., 20–30 PSI for a shower). Building Your Excel Spreadsheet
You can build an automated spreadsheet using the guide below. Set up your Excel columns with these exact labels and formulas to automate your engineering workflow. Section 1: Design Inputs Create an input block for your project data. Input Description Example Value Design Flow Rate ( B5 Static Height ( Hscap H sub s B6 Target Residual Pressure ( Hdcap H sub d B7 Minimum Available Inlet Pressure ( Hincap H sub i n end-sub B8 Pipe Internal Diameter ( B9 Pipe Roughness Coefficient ( (PPR Pipe) B10 Total Straight Pipe Length Section 2: Fitting Losses (Equivalent Length Method) Create a quick reference table to tally fittings. Fitting Type Equiv. Length per Unit (m) Total Length (m) 90-degree Elbow =B14*C14 Gate Valve =B15*C15 Check Valve =B16*C16 Total Equivalent Length =SUM(D14:D16)+B10 (Cell D18) Section 3: Automated Calculations & Formulas
Using an for this process is industry standard because it allows for easy adjustments to pipe lengths, fittings, and flow rates, automatically recalculating the Total Dynamic Head (TDH). 1. What is Booster Pump Head Calculation? Hvcap H sub v TDH=Hs+Hf+HrTDH equals cap H
) . This represents the total pressure the pump must overcome to move fluid from the suction point to the discharge point at a specific flow rate. In an Excel sheet, your primary formula will be:
Offers downloadable spreadsheets for Hazen-Williams friction loss and pipe sizing calculations.