Ashrae Duct Fitting Database Excel

You can copy from ASHRAE Fundamentals, Table 34.2 (Loss Coefficients). However, this is only feasible for 10-20 common fittings. For the full 1,200+ fittings, buy the database.

Use Power Query (Get & Transform Data) to import the CSV. Remove unnecessary header rows and map the columns to human-readable names. ashrae duct fitting database excel

With coefficient C, velocity pressure Pv (in inches w.g. or Pa), the loss is: You can copy from ASHRAE Fundamentals , Table 34

Loss = C * Pv

In Excel: = [@Coefficient] * (0.602 * ([@Velocity_FPM]/4005)^2) for IP units. You can copy from ASHRAE Fundamentals