ASTM Table 54B is a standard table used in the petroleum industry to calculate the density of crude oils. Here is a useful paper on creating an Excel spreadsheet to work with ASTM Table 54B:
If you must perform a direct lookup (not recommended for dynamic spreadsheets), you would: Astm Table 54b Excel
alpha equals the fraction with numerator cap K sub 0 plus cap K sub 1 center dot cap D sub 15 and denominator cap D sub 15 squared end-fraction Density Range ( cap K sub 0 cap K sub 1 Product Type Transition/Jet 3. Setting Up the Excel Sheet Organize your inputs and formulas as follows: Density @ 15°C (kg/m³) Observed Temp (°C) Cell A3 (dT) Cell A4 (K0) =IF(A1 ASTM Table 54B is a standard table used
While official ASTM tables are copyrighted and usually sold as software or manuals, you can automate calculations in Excel using the standardized mathematical formulas. 1. The Core Formula Astm Table 54b Excel
Transitioning these complex tables into an Excel environment significantly reduces human error and speeds up cargo calculations on tankers and in refineries. Key Components of an ASTM 54B Excel Tool
ASTM Table 54B is a standard table used in the petroleum industry to calculate the density of crude oils. Here is a useful paper on creating an Excel spreadsheet to work with ASTM Table 54B:
If you must perform a direct lookup (not recommended for dynamic spreadsheets), you would:
alpha equals the fraction with numerator cap K sub 0 plus cap K sub 1 center dot cap D sub 15 and denominator cap D sub 15 squared end-fraction Density Range ( cap K sub 0 cap K sub 1 Product Type Transition/Jet 3. Setting Up the Excel Sheet Organize your inputs and formulas as follows: Density @ 15°C (kg/m³) Observed Temp (°C) Cell A3 (dT) Cell A4 (K0) =IF(A1
While official ASTM tables are copyrighted and usually sold as software or manuals, you can automate calculations in Excel using the standardized mathematical formulas. 1. The Core Formula
Transitioning these complex tables into an Excel environment significantly reduces human error and speeds up cargo calculations on tankers and in refineries. Key Components of an ASTM 54B Excel Tool
