Here’s a concise write-up on the ASHRAE Duct Fitting Database in Excel format, covering its purpose, typical content, and practical uses.
Conclusion
If you prefer to build a custom tool without a live link to the database, you can use the Darcy-Weisbach and Colebrook equations found in the ASHRAE Handbook of Fundamentals. ashrae duct fitting database excel
Please ensure you are using the most recent version of the database. Here’s a concise write-up on the ASHRAE Duct
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. An Elbow (ET1) requires (r/D)
The database is available in different versions, including:
.xlsx or .xls (Microsoft Excel)