Booster Pump Head Calculation Xls !!top!! -
TDH=Hs+Hf+HpTDH equals cap H sub s plus cap H sub f plus cap H sub p Static Head ( Hscap H sub s This is the physical vertical distance the water must lift.
To build a robust booster_pump_head_calculation.xls file, structure your spreadsheet tabs and columns as outlined below. Sheet Tab 1: Input Parameters
| Feature | Purpose | |---------|---------| | | Flow, pipe lengths, diameters, elevations, required outlet pressure | | Friction Loss Tables | Embedded lookup tables for Hazen-Williams C values, Darcy friction factors | | Fittings Equivalent Length Database | Dropdown selection for elbow, tee, reducer, valve, backflow preventer | | NPSH Available Calculator | Compare against pump’s NPSH required (NPSHr). Red cells if insufficient | | Multi-Flow Point Calculation | Generate system curve (0%, 25%, 50%, 75%, 100%, 120% of design flow) | | Viscosity Correction | For hot water or glycol systems | | Unit Converter | Bar to m, psi to ft, GPM to m³/hr | | Pump Selection Table | Extract data from Grundfos, Wilo, Armstrong, KSB curves (manual entry or API) |
If your system requires a specific residual pressure at the discharge (e.g., supplying pressure to the top floors of a high-rise building), convert bars to meters of water column. Use the conversion: (for water). Velocity Head: Calculate using , where v is the fluid velocity and g is gravity. 5. Output Summary
TDH=Static Head+Friction Loss+Operating/Residual PressureTDH equals Static Head plus Friction Loss plus Operating/Residual Pressure Key Components Explained booster pump head calculation xls
Creating a structured Excel sheet simplifies the calculation. Use the following structure to organize your data. Structure of the Spreadsheet
Ensure the Net Positive Suction Head Available ( NPSHAcap N cap P cap S cap H sub cap A ) is greater than the NPSHcap N cap P cap S cap H Required ( NPSHRcap N cap P cap S cap H sub cap R ) by the pump, or cavitation will occur.
A spreadsheet (XLS) is the best tool to automate these complex hydraulic equations. 1. Core Components of Total Dynamic Head (TDH)
If you’d like, I can help you (with formulas and example data). TDH=Hs+Hf+HpTDH equals cap H sub s plus cap
= Hazen-Williams Coefficient (e.g., 140-150 for PVC/Copper, 100-120 for steel). = Diameter ( C. Fittings Friction Loss (Equivalent Length Method)
:
The pressure lost as water rubs against pipe walls, valves, and fittings.
A booster pump ensures adequate water pressure in high-rise buildings, irrigation networks, and industrial systems. Choosing the wrong pump leads to poor pressure or high energy bills. Accurate total dynamic head (TDH) calculation prevents these issues. Red cells if insufficient | | Multi-Flow Point
By setting up these calculations in an Excel worksheet, you can quickly optimize your booster pump selection for efficiency and performance.
TDH equals cap H sub s plus cap H sub f plus cap H sub required pressure end-sub minus cap H sub existing supply end-sub Calculating Total Dynamic Head - Grundfos
): The vertical distance the fluid must be lifted, measured from the pump centerline to the highest discharge point. Friction Head ( Hfcap H sub f
A 2-inch Schedule 40 steel pipe does not have a 2.000-inch inner diameter. Always map your XLS calculations to the exact internal diameter (ID) specified by the manufacturer.