1. Objective To provide a structured, reusable Excel-based method for calculating the total dynamic head (TDH) of a chilled water pump in a closed-loop HVAC system. Accurate head calculation ensures proper pump selection, energy efficiency, and system reliability. 2. Key Parameters for Pump Head Calculation In a closed chilled water system, the total head (in meters or feet) is the sum of:
h_f = 10.67 × (Q^1.852) / (C^1.852 × D^4.87) × L_eq 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 | of 90° elbows | | 12 | | | No
Common equivalent lengths (for water, schedule 40 steel pipe): 1. Objective To provide a structured
h_f = f × (L_eq / D) × (v² / (2g))