Astm Table 54 Excel -
[ VCF = \exp\left( -\alpha_15 \Delta t \right) \cdot \left(1 - 0.5 \alpha_15^2 \Delta t^2 \right) ]
=IF(B4="Crude", 341.0957/(B2^2), IF(B4="Product", 594.5418/(B2^2), NA())) Step 3: Calculate Δt (temperature difference): astm table 54 excel
[ \alpha_15 = \fracK_0 + K_1 \rho_15 + K_2 \rho_15^2\rho_15^2 ] [ VCF = \exp\left( -\alpha_15 \Delta t \right)