Astm Table 54 Excel Work May 2026

=B3-15 Step 4: Calculate VCF using series expansion (Excel does not have a direct liquid expansion function). Use the exact API formula:

[ 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

Actually, for crude oils, the formula simplifies using a different set. More precisely, API 11.1.4 gives for crude oils: =B3-15 Step 4: Calculate VCF using series expansion

Excel: VCF = 0.96942 Volume at 15°C = 5000 * 0.96942 = 4847.1 m³ for crude oils

For Crude Oils:

But Excel-friendly: In cell B6:

=IF(B4="Crude", 341.0957/(B2^2), IF(B4="Product", 594.5418/(B2^2), NA())) Step 3: Calculate Δt (temperature difference):