Booster Pump Head Calculation Xls !!link!!
Many open-source Excel-VBA computational solvers have been created specifically to handle the determination of the Darcy-Weisbach friction factor and its visualization on a Moody’s chart.
Pressure drops from fittings like elbows, valves, and tees. A common rule of thumb is to add 25% to the total pipe length to account for these if specific K-values aren't used. Residual Pressure ( cap H sub r booster pump head calculation xls
= Pipe roughness coefficient (e.g., Copper = 150, PVC = 150, Galvanized Iron = 120) = Inside pipe diameter (inches) Accounting for Fittings (Equivalent Length Method) Residual Pressure ( cap H sub r =
To create a functional , you should organize your columns to handle these specific variables: Calculation of Booster Pump The Excel file also flagged that her initial
Use Excel to test maximum and minimum demand scenarios. 6. Accessing/Building Your Own Tool
Without the sheet, she might have forgotten the fixture pressure requirement and undersized the pump by 25 m. The Excel file also flagged that her initial 80 mm pipe would cause too much friction—she upsized to 100 mm, saving long-term energy costs.