Excel | Astm Table 54b

Here’s a solid feature set 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).

2. Volume Correction Factor (VCF) Calculation

• Look up or interpolate VCF based on:

  =LAMBDA(Density,Temp, LET(Alpha,(341.0977/(Density^2)) + (-0.69859/Density) + 0.001373,EXP(-Alpha*(Temp-60)*(1+0.8*Alpha*(Temp-60))))) Astm Table 54b Excel

  Step 1: Set Up Your Input Panel

  | Parameter | Cell Location | Example Value | | --- | --- | --- | | Observed Density (kg/m³ @ 60°F) | B2 | 830.0 | | Observed Temperature (°F) | B3 | 92.5 | | Observed Volume (Barrels or m³) | B4 | 10,000 | Here’s a solid feature set you could implement