After installation, look for a file named FittingDB.mdb (Microsoft Access) or ASHRAE_Fittings.dat .
If you are using manual lookup tables, ensure your formulas utilize linear interpolation. Fitting coefficients rarely land exactly on the whole numbers listed in design tables. Step 3: Compile the Total Static Pressure Summary ashrae duct fitting database excel link
Velocity Pressure (Vp)=(Velocity4005)2Velocity Pressure open paren cap V sub p close paren equals open paren the fraction with numerator Velocity and denominator 4005 end-fraction close paren squared Step 3: Fetch the Fitting Coefficient ( Cocap C sub o ) via the Excel Link After installation, look for a file named FittingDB
But real fittings require two-dimensional interpolation (e.g., for W/H ratios not in the table). A basic VLOOKUP is insufficient. Step 3: Compile the Total Static Pressure Summary
The following fitting types were modified: CD, ED, ER, SD, and SR, including specific numbers such as CD3-9, CD3-16, CD3-17, CD3-18, CD3-19, ED1-4, ED1-7, ED2-1, ED5-1 through ED5-10, ER1-2, ER5-1 through ER5-8, SD1-2, SD5-1 through SD5-27, SR1-1, SR5-1 through SR5-21, and others.
Absolutely. The ASHRAE coefficients are derived from real tests (ASHRAE RP-1293, etc.) and are widely accepted for energy modeling.