Astm Table 54b Excel • High-Quality
If your observed volume is 10,000 barrels at 92.5°F with a density of 830 kg/m³, your VCF might be ~0.9845, meaning your GSV is 9,845 barrels. You have lost 155 barrels due to thermal contraction (since the liquid is hotter than 60°F).
, the physical volume of the liquid will shrink, even though not a single drop was lost. Policy Commons Astm Table 54b Excel
For more information on ASTM Table 54B and its implementation in Excel, we recommend the following resources: If your observed volume is 10,000 barrels at 92
: For high-accuracy needs, ASTM International sells digital adjuncts to ensure compliance with the latest standards. Volume Correction Factor Calculation Guide | PDF - Scribd Policy Commons For more information on ASTM Table
Enter the ASTM Table 54B coefficients into your Excel spreadsheet, using the following formulas:
= (341.0977 / (A1^2)) + (-0.69859 / A1) + 0.001373