Chilled Water Pump Head Calculation Excel Sheet Apr 2026

h_f = 10.67 × (Q^1.852) / (C^1.852 × D^4.87) × L_eq

Common equivalent lengths (for water, schedule 40 steel pipe): chilled water pump head calculation excel sheet

In Excel, convert all to consistent units. Worksheet: Pump Head Calculator | A | B | C | D | |---|---|---| | Input Data | | Value | Unit | | Flow rate (Q) | | 100 | m³/hr | | Pipe length (straight) | | 150 | m | | Pipe inner diameter | | 150 | mm | | Pipe roughness (ε) | | 0.15 | mm | | No. of 90° elbows | | 12 | | | No. of gate valves | | 4 | | | No. of strainers | | 1 | | | Chiller drop | | 60 | kPa | | Coil drop | | 30 | kPa | | Control valve drop | | 10 | kPa | | Elevation difference (if open system) | | 0 | m | h_f = 10

h_f = f × (L_eq / D) × (v² / (2g))

| Fitting | Equivalent length (m) per 100 mm pipe dia | |---------|-------------------------------------------| | 90° elbow | 0.3 – 0.6 | | Tee (straight) | 0.6 – 1.2 | | Tee (branch) | 1.5 – 2.4 | | Gate valve (open) | 0.15 – 0.3 | | Globe valve (open) | 6 – 10 | | Swing check valve | 2 – 4 | | Strainer | 3 – 6 | Darcy-Weisbach (more accurate): of gate valves | | 4 | | | No