Even with a perfect Excel database, mistakes happen. Watch out for these:
Use Data Validation or Conditional Formatting to flash a warning if a designer inputs an aspect ratio or velocity ratio that falls completely outside the valid range of that specific ASHRAE fitting table. ashrae duct fitting database excel
Understanding the ASHRAE Duct Fitting Database (DFDB) and Excel Integration Even with a perfect Excel database, mistakes happen