Astm Table 54 Excel -

(Where D15 = density at 15°C, T15 = observed temp) | 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 | This paper provides a complete, ready-to-implement guide for creating, validating, and using ASTM Table 54 in Excel for professional hydrocarbon measurement.

Function ASTM_Table54_VCF(Density15 As Double, TempObs As Double, ProductType As String) As Double Dim alpha As Double, dt As Double Dim K2 As Double If ProductType = "Crude" Then K2 = 341.0957 ElseIf ProductType = "Product" Then K2 = 594.5418 Else ASTM_Table54_VCF = CVErr(xlErrNA) Exit Function End If If Density15 <= 0 Then ASTM_Table54_VCF = CVErr(xlErrValue) Exit Function End If

Actually, for crude oils, the formula simplifies using a different set. More precisely, API 11.1.4 gives for crude oils: astm table 54 excel

[ VCF = \exp\left( -\alpha_15 \Delta t \left(1 + 0.5 \alpha_15 \Delta t\right) \right) ]

=IF(B4="Crude", 341.0957/(B2^2), IF(B4="Product", 594.5418/(B2^2), NA())) Step 3: Calculate Δt (temperature difference): (Where D15 = density at 15°C, T15 =

Excel: VCF = 0.96942 Volume at 15°C = 5000 * 0.96942 = 4847.1 m³

Step 2: In cell B5, calculate thermal expansion coefficient: (Where D15 = density at 15°C

VCF = 1 - a dt + b dt^2 - c dt^3 + d dt^4 ...