Astm Table 54b Excel Jun 2026

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 .

| Example | Density at 15°C (kg/m³) | Temperature (°C) | ALPHA (calculated) | VCF (calculated) | | ------- | ----------------------- | ---------------- | ------------------ | ---------------- | | 1 | 839 | 32.5 | (within region ≥839) | 0.98515 | | 2 | 889 | 115.55 | (within region ≥839) | 0.91966 | | 3 | 903.5 | 30.50 | 0.0007672 | 0.988067 | | 4 | 819 | 26.75 | 0.0008864 | 0.989552 | | 5 | 777.5 (transition zone) | 9 | 0.0010708 | 1.006412 | | 6 | 749 | 32 | 0.0012033 | 0.979423 | Astm Table 54b Excel

: Use a combination of INDEX , MATCH , and linear interpolation formulas to find the exact factor. ASTM Table 54B requires density in kg/m³ at

If you prefer a single, nested formula without helper columns, paste this into your target cell: If you prefer a single, nested formula without

If you need to calculate VCF across thousands of rows, standard formulas can become cumbersome. A User-Defined Function (UDF) written in VBA provides a cleaner, reusable solution. How to Add the VBA Code: Press ALT + F11 to open the VBA Editor. Click . Paste the following code into the window: