Use in Excel: =ASTM_Table54_VCF(B2, B3, B4) 6.1 Comparison with Official ASTM Table 54 (Excerpt) | Density15 (kg/m³) | Temp (°C) | Official VCF | Excel VCF (2004) | Delta | |------------------|-----------|--------------|------------------|-------| | 800.0 | 20.0 | 0.99565 | 0.99566 | +0.00001 | | 850.0 | 30.0 | 0.98234 | 0.98233 | -0.00001 | | 900.0 | 45.0 | 0.96891 | 0.96890 | -0.00001 |
[ VCF = \exp\left[-\alpha_15 \Delta t (1 + 0.5\alpha_15 \Delta t + \frac16\alpha_15^2 \Delta t^2 + \dots)\right] ] astm table 54 excel
Where (K_0, K_1, K_2) are coefficients specific to product groups (e.g., crude oils, gasoline, diesel). ASTM Table 54 corresponds primarily to and Generalized Products – Group 1 (refined products with moderate expansion). 3. Data Structures for Excel Implementation 3.1 Required Input Cells | Cell | Variable | Description | |------|----------|-------------| | B2 | Density_15 | Observed density at 15°C (kg/m³) | | B3 | Temp_obs | Observed temperature (°C) | | B4 | ProductType | "Crude" or "Product" | 3.2 Coefficients for ASTM Table 54 (2004 Algorithm) For Generalized Crude Oils (Table 54A): Use in Excel: =ASTM_Table54_VCF(B2, B3, B4) 6
For Crude Oils:
Actually, for crude oils, the formula simplifies using a different set. More precisely, API 11.1.4 gives for crude oils: Data Structures for Excel Implementation 3