=ROUND(EXP(-a*(T-60)*(1+0.8*a*(T-60))),5) But the variable a (alpha) for products is given by: a = (K0 / (Density_at_60F^2)) + (K1 / Density_at_60F) + K2
=ASTM_54B_VCF(0.85, 95) -> Returns the VCF for diesel at 95°F. Step-by-Step: Building Your ASTM 54B Excel Calculator Let’s build a professional-grade calculator from scratch. 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 | Astm Table 54b Excel
You can approximate Table 54B using the formula used in international standards: =ROUND(EXP(-a*(T-60)*(1+0
ASTM Table 54B requires density in kg/m³ at 60°F, not API gravity. If you have API, convert it first using API = (141.5 / SG) - 131.5 and then Density = SG * 1000 . Step 2: Calculate Alpha In cell B6, enter: = (341.0977 / ((B2/1000)^2)) + (-0.69859 / (B2/1000)) + 0.001373 If you have API, convert it first using API = (141
Note: We divide B2 by 1000 because the constants expect density in g/cm³ (e.g., 0.830, not 830). In cell B7, enter: =ROUND(EXP(-B6*(B3-60)*(1+0.8*B6*(B3-60))),6) Step 4: Calculate Gross Standard Volume (GSV) In cell B8, enter: =B4 * B7
Extremely lightweight (two cells). Infinite precision. No lookup tables. Cons: Requires validation against official ASTM tables (differences are usually in the 5th decimal). Method 3: VBA User-Defined Function (The Ultimate Method) For engineers who hate typing long formulas, Visual Basic for Applications (VBA) is the answer.
'Calculate VCF VCF = Exp(-Alpha * DeltaT * (1 + 0.8 * Alpha * DeltaT))