The search for an is a rite of passage for HVAC engineers. The smart ones stop searching for a magic download link and instead learn to import the licensed Access database into Excel using Power Query.
The ASHRAE Duct Fitting Database is a collection of loss coefficients (C-factor, or technically Co for round and Co' for rectangular) for hundreds of HVAC fittings, including: ashrae duct fitting database excel link
ASHRAEDFDB.dll (32-bit or 64-bit)
Sample Power Query M-code concept:
The ASHRAE Duct Fitting Database (DFDB) is a digital repository of loss coefficients ( C₀ or Co ) for thousands of duct fittings (elbows, tees, transitions, etc.), based on ASHRAE Fundamentals Handbook, Chapter 34 (or 35 in some editions). The official version is distributed as a Windows DLL (Dynamic Link Library) or as part of commercial HVAC software. The search for an is a rite of passage for HVAC engineers
= Json.Document(Web.Contents("https://api.ashrae.org/dfdb/v1/fittings?ID=EL-1-1")) The official version is distributed as a Windows
| FittingID | Shape | Description | Parameter1 (r/D) | Parameter2 (W/H) | Co_value | |-----------|-------|-------------|------------------|------------------|-----------| | E1-1 | Round | 90° Elbow | 0.5 | - | 0.21 | | E1-1 | Round | 90° Elbow | 1.0 | - | 0.19 | | E2-1 | Rect | 90° Elbow | - | 0.25 | 0.30 |