The most reliable way to obtain these tables is through the official ASTM International website , where they sell the Manual of Petroleum Measurement Standards (MPMS) . They often provide digital versions or software implementations.
When implementing this in Excel, rather than using static lookup tables, you can use the mathematical implementation based on the ASTM D1250 standard:
In the world of crude oil, refined petroleum products, and lubricants, accurate volume measurement is the backbone of financial transactions and inventory control. This is where becomes indispensable. Originally published in the ASTM D1250 Standard Guide for Petroleum Measurement Tables , Table 54B is used to correct the volume of crude oils to a standard reference temperature, typically 15°C (59°F). However, relying on printed tables is slow and error-prone. The modern solution? Integrating ASTM Table 54B into Excel .