' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2)) End Function
=B3-15 Step 4: Calculate VCF using series expansion (Excel does not have a direct liquid expansion function). Use the exact API formula:
Thus, 1000 liters at 35°C = 983.55 liters at 15°C. To avoid repeated formulas and enable batch processing, create a VBA module:
Excel: VCF = 0.96942 Volume at 15°C = 5000 * 0.96942 = 4847.1 m³
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):
For Crude Oils:
' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2)) End Function
=B3-15 Step 4: Calculate VCF using series expansion (Excel does not have a direct liquid expansion function). Use the exact API formula: astm table 54 excel
Thus, 1000 liters at 35°C = 983.55 liters at 15°C. To avoid repeated formulas and enable batch processing, create a VBA module: ' API 11
Excel: VCF = 0.96942 Volume at 15°C = 5000 * 0.96942 = 4847.1 m³ ASTM Table 54 corresponds primarily to and Generalized
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):
For Crude Oils: