| Row | Parameter | Value | Unit | |-----|-----------|-------|------| | 1 | Flow rate (Q) | 500 | GPM | | 2 | Pipe ID | 4 | inches | | 3 | Pipe length | 200 | ft | | 4 | Static suction head | 10 | ft | | 5 | Static discharge head | 50 | ft | | 6 | Friction loss (per 100 ft) | 3.2 | ft | | 7 | Fittings equivalent length | 50 | ft | | 8 | | 8.0 | ft | | 9 | Total dynamic head | 48.0 | ft |
= same × discharge length + fitting losses pump head calculation excel
Use → List: "Mild Steel", "Stainless", "HDPE", "PVC". Then use VLOOKUP to fetch roughness values (e.g., 0.15 mm for steel, 0.01 mm for PVC). | Row | Parameter | Value | Unit
Create a dynamic chart: User enters multiple flow rates (50%, 75%, 100%, 125% of design flow). Excel calculates head at each flow (Head ∝ Flow² for friction component). Plot (Head vs Flow). Overlay manufacturer’s Pump Curve . The intersection is the operating point. Excel calculates head at each flow (Head ∝
In Excel (assuming ε = roughness in m, D in m):
| Diam (mm) | Flow (L/s) | Velocity (m/s) | f (Darcy) | hf (m/100m) | |-----------|------------|----------------|-----------|-------------|