The first step is to download the ASTM Table 54B coefficients from the ASTM website or a reputable source. The coefficients are typically presented in a tabular format, with values for Coefficient A, B, and C.
The constants vary by density to account for different physical properties of the products: Density Range ( is less than or equal to 770 is greater than 770 is less than 778 Transition Zone (See Transition Formula) is greater than or equal to 778 is less than 839 is greater than or equal to 839 Note: In the Transition Zone, Implementing in Excel To build an automated calculator in Excel: Input Cells : Define cells for Observed Temperature (e.g., ) and Density at 15°C (e.g., Logic for Alpha statement to select the correct based on the density in VCF Calculation : Apply the formula using the function for Astm Table 54b Excel