: =EXP(-Alpha_Cell * DeltaT_Cell * (1 + 0.8 * Alpha_Cell * DeltaT_Cell)) Gross Standard Volume (GSV) : =B3 * VCF_Cell 💡 Pro Tips for Accuracy
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). Astm Table 54b Excel
' Step 3: Calculate VCF using exponential formula VCF = : =EXP(-Alpha_Cell * DeltaT_Cell * (1 + 0
With a properly built Excel file, a user could just type in the observed density and temperature, and the sheet would instantly output the perfect VCF and metric tonnage. Cargo Calculations on Tankers with ASTM Tables - MySeaTime your VCF might be ~0.9845
