Astm Table 54 — Excel Better

| Coefficient | Value | |-------------|-------| | K0 | 341.0957 | | K1 | 0.0 | | K2 | 0.0 |

[ VCF = \exp\left[-\alpha_15 \Delta t (1 + 0.5\alpha_15 \Delta t + \frac16\alpha_15^2 \Delta t^2 + \dots)\right] ] astm table 54 excel

=EXP(-B5 * (B3-15) * (1 + 0.5*B5*(B3-15) + (1/6)*B5^2*(B3-15)^2)) This third-order expansion is accurate to 6 decimal places for Δt ≤ 50°C. Assuming Density15 in A1, TempObs in A2, Type in A3: | Coefficient | Value | |-------------|-------| | K0 | 341

[ \alpha_15 = \fracK_1\rho_15^2 + \fracK_2\rho_15 + K_3 ] TempObs in A2

For Crude Oils:

Actually, for crude oils, the formula simplifies using a different set. More precisely, API 11.1.4 gives for crude oils:

This 2-term approximation is valid for most industrial ranges (±0.0002). For higher precision, use: