Astm Table 54 Excel [ 2025 ]

[ \alpha_15 = \fracK_0 + K_1 \rho_15 + K_2 \rho_15^2\rho_15^2 ]

[ 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

' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2)) End Function [ \alpha_15 = \fracK_0 + K_1 \rho_15 +

[ VCF = \frac\textVolume at t\textVolume at 15°C ] for crude oils

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

[ \alpha_15 = \fracK_0 + K_1 \rho_15 + K_2 \rho_15^2\rho_15^2 ]

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

' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2)) End Function

[ VCF = \frac\textVolume at t\textVolume at 15°C ]

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