| Temperature (°C) | Correction Factor | | --- | --- | | 15 | 0.000612 | | 20 | 0.000645 |
Use in Excel: =ASTM_Table54_VCF(B2, B3, B4)
Correction Factor = 0.000612 + (20 - 15) / (20 - 15) x (0.000645 - 0.000612) = 0.000645
Interpolating the correction factor at 20°C, we get:
Actually, for crude oils, the formula simplifies using a different set. More precisely, API 11.1.4 gives for crude oils:
VCF is defined as the ratio of the volume of liquid at the observed temperature (t) to the volume at the reference temperature (t_ref = 15°C).
[ \alpha_15 = \fracK_0 + K_1 \rho_15 + K_2 \rho_15^2\rho_15^2 ]
| A | B | C | |---|---|---| | 1 | Density @15°C (kg/m³) | 850.0 | | 2 | Observed Temp (°C) | 35.0 | | 3 | Product Type | Product | | 4 | Alpha | =IF(C3="Crude",341.0957/B1^2,594.5418/B1^2) | | 5 | dt | =B2-15 | | 6 | VCF | =EXP(-B4 B5 (1+0.5 B4 B5+(1/6) B4^2 B5^2)) | | 7 | Volume at 15°C | = (Enter gross volume) * B6 |
[ VCF = \exp\left[-\alpha_15 \Delta t (1 + 0.5\alpha_15 \Delta t + \frac16\alpha_15^2 \Delta t^2 + \dots)\right] ]
Maximum deviation < 0.00002 for most ranges. Within custody transfer tolerance (±0.0005).
' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2))
