Astm: Table 54 Excel [new]

But Excel-friendly: In cell B6:

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 |

This 2-term approximation is valid for most industrial ranges (±0.0002). For higher precision, use: astm table 54 excel

Step 2: In cell B5, calculate thermal expansion coefficient:

' API 11.1.4 standard polynomial ASTM_Table54_VCF = Exp(-alpha * dt * (1 + 0.5 * alpha * dt + (1 / 6) * alpha ^ 2 * dt ^ 2)) End Function But Excel-friendly: In cell B6: Use in Excel:

=B3-15 Step 4: Calculate VCF using series expansion (Excel does not have a direct liquid expansion function). Use the exact API formula:

[ VCF = \frac\textVolume at t\textVolume at 15°C ] use: Step 2: In cell B5

Better: use the official polynomial from API Chapter 11.1.4: