Astm Table 54b Excel

Featured Events

Astm Table 54b Excel Jun 2026

For professionals who need to call Table 54B repeatedly across many worksheets, a VBA User‑Defined Function (UDF) is the most convenient option. The function replicates the piecewise ALPHA and VCF logic.

End Function

To calculate the gross standard volume at 15°C: Astm Table 54b Excel

Function ASTM_54B_VCF(Density60 As Double, ObsTempF As Double) As Double 'Constants for Table 54B (Generalized Products) Const K0 As Double = 341.0977 Const K1 As Double = -0.69859 Const K2 As Double = 0.001373 Dim Alpha As Double Dim DeltaT As Double Dim VCF As Double For professionals who need to call Table 54B

ASTM Table 54B is a subset of the (Manual of Petroleum Measurement Standards). It applies to generalized petroleum products like gasoline, jet fuel, fuel oil, and diesel. It applies to generalized petroleum products like gasoline,

ASTM Table 54B is part of the . It specifically applies to generalized petroleum products—such as diesel, fuel oil, jet fuel, and gasoline—and corrects volumes to the international standard temperature of 15°C . Key Parameters Required To utilize Table 54B, you need two primary inputs: Density at 15°C ( D15cap D sub 15 ): The base density of the product in Observed Temperature (

View All Events

For professionals who need to call Table 54B repeatedly across many worksheets, a VBA User‑Defined Function (UDF) is the most convenient option. The function replicates the piecewise ALPHA and VCF logic.

End Function

To calculate the gross standard volume at 15°C:

Function ASTM_54B_VCF(Density60 As Double, ObsTempF As Double) As Double 'Constants for Table 54B (Generalized Products) Const K0 As Double = 341.0977 Const K1 As Double = -0.69859 Const K2 As Double = 0.001373 Dim Alpha As Double Dim DeltaT As Double Dim VCF As Double

ASTM Table 54B is a subset of the (Manual of Petroleum Measurement Standards). It applies to generalized petroleum products like gasoline, jet fuel, fuel oil, and diesel.

ASTM Table 54B is part of the . It specifically applies to generalized petroleum products—such as diesel, fuel oil, jet fuel, and gasoline—and corrects volumes to the international standard temperature of 15°C . Key Parameters Required To utilize Table 54B, you need two primary inputs: Density at 15°C ( D15cap D sub 15 ): The base density of the product in Observed Temperature (