CFM = Sensible Heat Load (Btu/hr) / (1.08 * ΔT)
=B2/(1.08*20) – assuming B2 holds the sensible heat load. 3. Duct Sizing (Equal Friction Method) Using the equal friction method (e.g., 0.08 to 0.12 in. w.g./100 ft), you can size ducts using a friction chart approximation. hvac design calculations excel
Store a friction loss vs. CFM vs. diameter table. Use INDEX/MATCH or linear interpolation to find the nearest duct diameter for a given CFM at your target friction rate. CFM = Sensible Heat Load (Btu/hr) / (1
Velocity (FPM) = CFM / Area (ft²) . Add conditional formatting to highlight if velocity exceeds 1,500 FPM (noise risk) or 2,500 FPM (erosion risk). 4. Water Pipe Sizing (Hydronic Systems) For chilled or hot water systems, use: 0.08 to 0.12 in. w.g./100 ft)
All models appearing on this website are over the age of 18.
118 U.S.C. § 2257 Record-Keeping Requirements Compliance Statement