Astm: Table 54 Excel Verified
Step 2: In cell B5, calculate thermal expansion coefficient:
[ VCF = \exp\left( -\alpha_15 \Delta t \left(1 + 0.5 \alpha_15 \Delta t\right) \right) ] astm table 54 excel
Use in Excel: =ASTM_Table54_VCF(B2, B3, B4) 6.1 Comparison with Official ASTM Table 54 (Excerpt) | Density15 (kg/m³) | Temp (°C) | Official VCF | Excel VCF (2004) | Delta | |------------------|-----------|--------------|------------------|-------| | 800.0 | 20.0 | 0.99565 | 0.99566 | +0.00001 | | 850.0 | 30.0 | 0.98234 | 0.98233 | -0.00001 | | 900.0 | 45.0 | 0.96891 | 0.96890 | -0.00001 | Step 2: In cell B5, calculate thermal expansion
For Crude Oils: