The formula driving these tables is based on the , standardized jointly by ASTM, API, and IP. The 1980 and 2004 editions are the most widely used.
cap V cap C cap F equals e raised to the open paren negative alpha center dot d cap T center dot open paren 1 plus 0.8 center dot alpha center dot d cap T close paren close paren power (Excel function: : Observed Temperature (°C) - 15°C : Thermal expansion coefficient at 15°C 2. Calculate (Thermal Expansion Coefficient) The value of depends on your product's density at 15°C ( cap D sub 15 ). You must use specific constants ( cap K sub 0 cap K sub 1 ) based on the density range: Astm Table 54b Excel
Here’s a you could implement or request for an ASTM Table 54B Excel calculator/table (commonly used for crude oil, fuel oils, and lubricating oils – Generalized Crude Oils, Correction of Volume to 60°F against API Gravity at 60°F). The formula driving these tables is based on
: If you are using a static lookup table instead of a formula, use the FORECAST or TREND function in Excel to interpolate between known density and temperature values. standardized jointly by ASTM
