| Cell | Parameter | Example Value | Formula/Logic | | :--- | :--- | :--- | :--- | | | Density @ 15°C (kg/m³) | 825.5 | User Input | | B2 | Observed Temperature (°C) | 34.2 | User Input | | C2 | Volume Correction Factor (VCF) | 0.9856 | Result of Interpolation Logic | | D2 | Gross Observed Volume (m³) | 1,000 | User Input | | E2 | Gross Standard Volume (m³) | 985.6 | =D2 * C2 |
| Method | Pros | Cons | |--------|------|------| | Printed Tables | No power required | Prone to interpolation errors, bulky | | Dedicated Software (e.g., Flow-Cal) | Accurate, compliant | Expensive, license-restricted | | | Transparent, flexible, auditable, reusable | Requires correct implementation of polynomial equations | Astm Table 54b Excel
ASTM Table 54B provides a set of coefficients and equations to calculate the density of crude oils at temperatures between 60°F and 100°F (15°C and 38°C). The table is used to: | Cell | Parameter | Example Value |
The formula driving these tables is based on the , standardized jointly by ASTM, API, and IP. The 1980 and 2004 editions are the most widely used. When implementing this in Excel, rather than using
When implementing this in Excel, rather than using static lookup tables, you can use the mathematical implementation based on the ASTM D1250 standard: