For industrial systems or fluids at varying temperatures, Darcy-Weisbach provides higher accuracy but requires iterative calculations.
Excel allows you to map pipe diameters to equivalent lengths based on fitting types ( 90∘90 raised to the composed with power elbow, gate valve, etc.) using VLOOKUP or IF functions. D. Total Dynamic Head (TDH)
List your input variables in cells B1:B10 . Include liquid type, pipe material, and required flow rate. Step 2: Calculate Friction Losses Create a table to calculate for straight pipes using the Hazen-Williams formula.
Always add a 5% to 10% safety buffer to your calculated friction losses in Excel. This accounts for internal pipe aging, scaling, and unexpected field modifications during installation.
Organize your piping sections chronologically from suction to discharge. Use columns for: Section ID (e.g., Suction Line, Main Riser, Branch Line) Flow Rate per section Nominal Pipe Size vs. Actual Inside Diameter (ID) Straight Pipe Length
Add a 10% safety margin to the calculated friction head to account for interior pipe scaling and aging.
A is more than just a spreadsheet; it is an essential engineering control document that bridges the gap between hydraulic theory and real-world equipment selection. By automating friction loss calculations, standardizing static lift measurements, and integrating safety factors, an Excel-based tool ensures that the selected booster pump delivers the correct pressure and flow for the life of the system.
Friction loss occurs as water rubs against the pipe walls and moves through valves and elbows. Hazen-Williams Equation
If the booster pump runs on a VFD, the Affinity Laws apply. You can build a section in your XLS to adjust performance based on speed:
): The specific pressure required at the outlet (e.g., a showerhead typically needs 20–30 PSI). Convert PSI to feet of head by multiplying by . Friction Head ( Hfrictioncap H sub f r i c t i o n end-sub
Provide one worked example in the sheet using typical values:
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
A spreadsheet (XLS) is the best tool to automate these complex hydraulic equations. 1. Core Components of Total Dynamic Head (TDH)