Astm Table 54 Excel !!link!! Jun 2026
The value of (\alpha_15) is obtained from:
Without correction (assuming 42°C = 15°C): error = 152.9 m³ → financial loss at $80/bbl ~ $77,000.
If the Excel sheet is used for custody transfer, enable "Track Changes" or maintain a version history. In a dispute, you must be able to prove that the calculation methodology used on a specific date matched the ASTM standard. astm table 54 excel
Thus, 1000 liters at 35°C = 983.55 liters at 15°C.
Density (kg/m³) = Density at 15°C (kg/m³) x (1 + (Temperature (°C) - 15) x Correction Factor) The value of (\alpha_15) is obtained from: Without
=B3-15
But Excel-friendly: In cell B6:
alpha = K2 / (Density15 ^ 2) dt = TempObs - 15
Correction Factor = 0.000612 + (20 - 15) / (20 - 15) x (0.000645 - 0.000612) = 0.000645 Thus, 1000 liters at 35°C = 983
The table provides correction factors for a range of temperatures, from -20°C to 100°C, and is commonly used in the petroleum industry.
