=VCF_54B(Density15, ObservedTemp)
If you design your own, document the equation sources and validation data. Many auditors require traceability to API/ASTM equations.
If your company restricts macro-enabled workbooks ( .xlsm ), you can write the math directly into a cell formula. Assuming is in cell A2 and Observed Temperature is in cell B2 : For a distillate product (Diesel), paste this into cell C2 :
(Where a0 , a1 , etc. are named constants.)
: It is critical to obtain Excel templates from reputable providers like the ASTM International official site or certified maritime software developers to ensure the underlying formulas match the latest standards (e.g., API MPMS Chapter 11.1).
If VBA is blocked by IT policy, implement the polynomial as a single-cell array formula. For example:
In cell D2 , use a nested IF or IFS function to determine alpha based on density ranges.
Many industry-specific software packages and calculators from providers like AFA SARL include these tables as built-in functions.
— Correction for the Effect of Temperature on Liquid) is calculated using the following exponential formula:
: While primarily for refined products, the logic behind these tables is essential for ensuring transparency in international oil trades. Usage Considerations
α=K0+(K1⋅D15)D152alpha equals the fraction with numerator cap K sub 0 plus open paren cap K sub 1 center dot cap D sub 15 close paren and denominator cap D sub 15 squared end-fraction K0cap K sub 0 K1cap K sub 1 Constants by Density Range The constants used in the calculation change depending on the product's density: Product Type Density Range ( K0cap K sub 0 K1cap K sub 1 346.42278346.42278 0.438840.43884 Transition Zone Use Special Formula: Middle Distillates 594.5418594.5418 Fuel Oils 186.9696186.9696 0.486180.48618 3. Implementation Resources
There is no single universal "Table 54B" — it's a table identifier used inside different ASTM documents. To produce a precise, deeply technical article you must identify the exact ASTM standard (for example ASTM A106, A515, A992, A370, etc.) that contains the Table 54B you mean. I will assume you mean a common case: materials/mechanical properties tables in structural steel or pressure-vessel related ASTM standards.
VCF=e(−α⋅ΔT⋅(1+0.8⋅α⋅ΔT))cap V cap C cap F equals e raised to the open paren negative alpha center dot cap delta cap T center dot open paren 1 plus 0.8 center dot alpha center dot cap delta cap T close paren close paren power : Constant (approx. 2.718282.71828 ΔTcap delta cap T : Observed Temperature (
: A downloadable Windows program that includes Tables 54B, 54A, 53A, and 53B. This is an executable software rather than an Excel file but provides comprehensive calculation capabilities.
The historical ASTM IP standard requires specific rounding steps for intermediate values (like
End Function
