Astm Table 54b Excel _top_ -

The standard relies on the underlying API MPMS Chapter 11.1 implementation procedures. The VCF is calculated using the following exponential math:

For a more robust solution, advanced users create a VBA Function.

CF = A + B × (T - 60) + C × (T - 60)² Astm Table 54b Excel

End Function

The governing document for this standardised calculation is (also designated API MPMS Chapter 11.1, Volume VIII), which provides a uniform and authoritative basis for the measurement of petroleum fluids irrespective of point of origin, destination, or the units of measurement used by custom or statute. The standard relies on the underlying API MPMS Chapter 11

Excel, with its widespread use and versatile calculation capabilities, is an ideal platform for applying ASTM Table 54b. By creating a template or using a pre-designed workbook, users can easily calculate the volume correction factors (VCFs) and subsequently, the mass of petroleum products given their volume and temperature.

=ROUND(EXP(-((613.97226/(A2^2)) + (0.00000)/A2) * (B2 - 15) * (1 + 0.8 * (B2 - 15) / 6300)), 4) Excel, with its widespread use and versatile calculation

Function VCF54B(ObservedTemp As Double, Density15 As Double) As Variant Dim K0 As Double Dim K1 As Double Dim Alpha15 As Double Dim DeltaT As Double Dim VCFValue As Double ' Constants for ASTM Table 54B (Refined Products) K0 = 186.9696 K1 = 0.48642 ' Error handling for realistic density ranges If Density15 < 610 Or Density15 > 1075 Then VCF54B = CVErr(xlErrNum) Exit Function End If ' Calculate thermal expansion coefficient Alpha15 = (K0 + (K1 * Density15)) / (Density15 ^ 2) ' Calculate temperature delta DeltaT = ObservedTemp - 15 ' Calculate VCF VCFValue = Exp(-Alpha15 * DeltaT * (1 + 0.8 * Alpha15 * DeltaT)) ' Round to 4 decimal places per API standard guidelines VCF54B = Round(VCFValue, 4) End Function Use code with caution.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.