For more information on ASTM Table 54B and its implementation in Excel, we recommend the following resources:
ASTM Table 54B is a standard table used in the petroleum industry to calculate the density of crude oils. Here is a useful paper on creating an Excel spreadsheet to work with ASTM Table 54B:
=EXP(-((B4+B5*B3)/(B3^2))*(B2-15)*(1+0.8*((B4+B5*B3)/(B3^2))*(B2-15))) Use code with caution. Step C: Rounding Rules
: The core formula must accurately interpolate values from Table 54B based on the specific gravity or density of the product. Astm Table 54b Excel
Ensure your density is formatted as kg/m³ (e.g., 845.2) and not relative density/specific gravity (e.g., 0.8452).
Example pseudocode:
Using an spreadsheet automates these complex interpolations, reducing human error in cargo surveys and bunkering operations. What is ASTM Table 54B? For more information on ASTM Table 54B and
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.
| | Temperature Range | |---|---| | 653 to 778 | -18°C to 95°C | | 778 to 824 | -18°C to 125°C | | 824 to 1,075 | -18°C to 150°C |
A very specific request!
In cell B8, enter: =B4 * B7
Underneath the printed tables sat a complex complex exponential algorithm utilizing thermal expansion coefficients (