: Clearly defined cells for Density at 15°C and Observed Temperature . Using data validation (drop-down lists or limits) ensures inputs stay within the valid range for refined products.
Example pseudocode:
You will find many commercial and free spreadsheets online with names like “ASTM Table 54B Excel calculator.” Astm Table 54b Excel
The Ultimate Guide to Implementing ASTM Table 54B in Excel ASTM Table 54B (Generalized Products, Correction of Volume to 15°C) is a cornerstone standard in the oil, gas, and petrochemical industries. It provides the Volume Correction Factors (VCF) needed to convert petroleum liquid volumes measured at observed temperatures to standard volumes at 15°C. : Clearly defined cells for Density at 15°C
The actual temperature of the liquid during measurement. It provides the Volume Correction Factors (VCF) needed
| Temperature (°F) | API Gravity | Density (at 60°F) | Correction Factor (CF) | Density (at T) | | --- | --- | --- | --- | --- | | 80 | 20 | 850 | 0.99485 | 846.22 |