Obtain the official coefficients from:
These coefficients are non-public for licensing reasons, but many legitimate sources (including some national metrology institutes) offer them under license.
For Table 54B (fuel oils, density at 15°C between 600 and 1075 kg/m³, temperature range -40°C to +80°C), the general form is:
VCF = exp( -α * ΔT * (1 + 0.8 * α * ΔT) )
Where:
But the actual ASTM implementation uses a 5th or 6th order polynomial specific to product type B.
| Parameter | Cell Location | Example Value | | --- | --- | --- | | Observed Density (kg/m³ @ 60°F) | B2 | 830.0 | | Observed Temperature (°F) | B3 | 92.5 | | Observed Volume (Barrels or m³) | B4 | 10,000 |
Important: ASTM Table 54B requires density in kg/m³ at 60°F, not API gravity. If you have API, convert it first using API = (141.5 / SG) - 131.5 and then Density = SG * 1000. Astm Table 54b Excel
The official ASTM tables are published as massive matrices (e.g., densities from 600 to 1074 kg/m³ and temperatures from -40°C to +40°C). Using paper or PDF versions is tedious and introduces interpolation errors. An Excel-based solution offers:
Sheet1: Calculator
Sheet2: ASTM_Table_54B
Sheet3: Interpolation_Engine (optional, for smooth non-integer API/temp)
If you are building a calculator for professional use, you should utilize the standard implementations (often available as DLLs or Add-Ins). However, for educational purposes or internal estimations, you can build a simplified approximation.
You might ask: Aren't there commercial software packages for this? Yes, but Excel remains the king of flexibility for several reasons: Obtain the official coefficients from:
Before diving into Excel mechanics, it is crucial to understand the underlying physics.