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
Function VCF_54B(t As Double, dens15 As Double) As Double ' t in °C, dens15 in kg/m³ ' Use fitted polynomial coefficients for product group B Dim K0, K1, K2... as Double '... apply equation VCF_54B = Exp(-alpha * (t - 15)) ' simplified End Function Astm Table 54b Excel
for generalized petroleum products (like gasoline, jet fuel, and fuel oil) to convert observed volumes at a specific temperature to a standard volume at 15°C. Step-by-Step Implementation Guide for Excel With a properly built Excel file, a user