Open your Excel workbook and press ALT + F11 to open the VBA Editor. Click . Paste the following standardized VBA code structure:
For Generalized Products (Table 54B), the constants are typically
This step‑by‑step process is used daily by bunker surveyors, ship officers, and cargo inspectors to determine the quantity of fuel delivered or remaining on board.
=IF(A2<=770, (346.42278+0.43884*A2)/A2^2, IF(A2<778, -0.0033612+2680.32/A2^2, IF(A2<839, (594.5418+0*A2)/A2^2, (186.9696+0.48618*A2)/A2^2 ) ) ) Astm Table 54b Excel
Where:
The primary goal of Table 54B is to find the , also known as CTL (Correction for the effect of Temperature on Liquid). Key Inputs Required:
The coefficients are presented in a tabular format, with values ranging from 0.000001 to 0.001, depending on the specific liquid being measured. Open your Excel workbook and press ALT +
: This Google Play app generates complete ASTM tables for custom density and temperature ranges. Light tables (up to 30x3) can be shared via text, while larger ones are exported as Excel files for official reporting. The app is based on ASTM D1250-08 and supports VCF calculations for Tables 54A, 54B, 54C, and 54D.
VCF=exp(−α15×Δt×(1+0.8×α15×Δt))VCF equals exp open paren negative alpha sub 1 5 cross delta t cross open paren 1 plus 0.8 cross alpha sub 1 5 cross delta t close paren close paren
The formula changes slightly based on the commodity group, but the general format for generalized products is: =IF(A2<=770, (346
If you need assistance expanding your workbook, let me know:
: Industry standards typically require VCF to be rounded to 5 decimal places .