Hvalves/fittingscap H sub v a l v e s / f i t t i n g s end-sub
Using the standard Hazen-Williams formula, the friction loss (meter head per 100 meters of pipe) can be computed via an Excel Add-In or with user-defined functions (VBA) that allow selective options for either Hazen-Williams or Darcy-Weisbach formulations.
By using an Excel spreadsheet to automate these formulas, you can significantly reduce engineering time and ensure that your booster pump sizing is precise, safe, and efficient.
You can build a simple spreadsheet by following these steps: Pump Head Calculation Template | PDF | Valve - Scribd
When setting up your calculation blocks in Excel , use these standard conversions: booster pump head calculation xls
| Aspect | Rating (1–5) | |--------|--------------| | Ease of use | ⭐⭐⭐⭐ | | Accuracy (if properly built) | ⭐⭐⭐ | | Completeness | ⭐⭐½ | | Practical utility | ⭐⭐⭐⭐ (for preliminary design) |
[H = \fracP\gamma]
Elevation of the water source relative to the pump.
Boost water from a main to a rooftop tank 30 feet above. Incoming Pressure: 20 PSI. Required Head at Top: 10 PSI. Pipe: 100 ft of 1.5-inch PVC (with 5 elbows). (let's assume 5 ft). The pump needs to be capable of of head at the required flow rate. 6. Tips for Accurate Calculations Always consider max flowAlways consider max flow Hvalves/fittingscap H sub v a l v e
Calculating the head for a booster pump is essential for ensuring that a fluid system operates effectively and efficiently. Utilizing Excel (XLS) for these calculations offers a practical and efficient approach to pump system design. By understanding the principles of head calculations and leveraging the computational power of XLS, engineers can accurately size and select booster pumps for a wide range of applications.
:
Create a clean input sheet to gather all raw data. This makes the tool easy to use for non-engineers. Include these sections:
A lookup section for "Equivalent Lengths" of valves and fittings (elbows, tees, check valves). Boost water from a main to a rooftop tank 30 feet above
= Suction side static head and friction losses, respectively. Ensure that the calculated NPSHAcap N cap P cap S cap H sub cap A
She needed to calculate the total dynamic head (TDH) for the booster pump:
What (copper, PVC, stainless steel) and diameters you use most often?
represents the total pressure the pump must generate to overcome gravity and friction while maintaining the desired flow. Friction Losses Required PSI
=B12*2.31 (for imperial) or =B12*10.2 (for metric) . Total Dynamic Head (Cell B18): =SUM(B15:B17) Common Calculation Pitots to Avoid