It is critical to note that ASTM standards are proprietary. Any Excel template created should be verified against the official ASTM Petroleum Measurement Tables (ANSI/ASTM D 1250) to ensure compliance. Accuracy checks should be performed by comparing the spreadsheet's output against the official printed tables at various random intervals to confirm the interpolation logic is functioning correctly.
Imagine trying to buy or sell a massive cargo of petroleum products. Liquids expand when they get hot and shrink when they get cold. If a refinery in the Middle East pumps liters of fuel at a warm 35 raised to the composed with power C Astm Table 54b Excel
Enter the ASTM Table 54B coefficients into your Excel spreadsheet, using the following formulas: It is critical to note that ASTM standards are proprietary
ASTM Table 54B – Implementation and Usage in Excel Imagine trying to buy or sell a massive
Convert to barrels (if needed): 983,200 L ÷ 158.987 = 6,184 barrels .
: Multiply the observed volume by this VCF to get the volume at 15°C. Key Considerations Cargo Calculations on Tankers with ASTM Tables - MySeaTime 23 Sept 2018 —