The user enters duct lengths, fitting types (elbows, tees, transitions), diffuser quantities, grille sizes, coil pressure drops, and filter resistance. Look-up tables using VLOOKUP or XLOOKUP functions allow the user to select a fitting type and automatically populate the "Equivalent Length" or "Dynamic Loss Coefficient" (C or K factor).
Here is a basic example of an ESP calculation Excel sheet: esp calculation hvac excel sheet
=XLOOKUP(A2, 'Fitting Database'!A:A, 'Fitting Database'!C:C) The user enters duct lengths, fitting types (elbows,
Organize your spreadsheet into these logical sections to ensure a systematic calculation: Step A: Identify the Critical Path longest duct run or the path with the most fittings/accessories. The user enters duct lengths
From ASHRAE or SMACNA, each fitting has a loss coefficient (C). The formula is: