Booster Pump Head Calculation Xls

Program these specific Excel formulas to calculate head components automatically: =((B4/3600)/((PI()*(B6/1000)^2)/4)) Hazen-Williams Friction Loss Per Meter (

: The height to which the fluid needs to be lifted, measured in feet or meters.

For an accurate Excel sheet, your columns should include these variables: Static Head ( cap H sub s

Note: Account for valves, bends, and tees by adding their "equivalent pipe length" to Step 4: Define the Residual Pressure ( Hdcap H sub d booster pump head calculation xls

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

v=QA=4QπD2v equals the fraction with numerator cap Q and denominator cap A end-fraction equals the fraction with numerator 4 cap Q and denominator pi cap D squared end-fraction Ensure units are consistent (e.g., B. Pipe Friction Loss (Hazen-Williams Formula) This is commonly used for water.

via Hazen-Williams): =((10.67 * D18 * (B20^1.852)) / ((B9^1.852) * (B21^4.87))) (Put this in Cell B22) Program these specific Excel formulas to calculate head

Create dedicated cells for user inputs to keep the model dynamic. Example Value Design Flow Rate ( B2 Pipe Roughness Coefficient ( B3 Inside Pipe Diameter ( 2.067 (2" Sch 40 PVC) B4 Static Elevation Rise ( Hscap H sub s B5 Required Residual Pressure Sheet Tab 2: Pipe & Fitting Friction Loss Layout Use a tabular format to map out the pipe network segments. Diameter (in) Pipe Length (ft) Fitting Type Fitting Qty Equiv. Length/Fitting (ft) Total Length (ft) Loss / 100 ft Segment Loss (ft) Foot Valve 90° Elbow 4. Excel Formulas for Automation

H = Hf + Hs + Hm

Follow this sequence to calculate your required booster pump head. Step 1: Determine the Design Flow Rate (GPM or via Hazen-Williams): =((10

Mariana entered the data:

:

To build an accurate XLS template, you must program standard hydraulic formulas into your cells. Two primary methods exist for calculating friction loss. The Hazen-Williams Equation

Later, she uploaded her own improved version online with a note: "Booster pump head calculation — includes friction loss for PEX, copper, and CPVC. Drop test passed."

): The pressure required to accelerate the liquid. Often negligible, but crucial in high-velocity systems. Pressure Head ( hpressureh sub p r e s s u r e end-sub