Close the VBA Editor. You can now use =VCF_Table54B(A2, B2) directly in your cells. Method 2: Native Excel Formulas
Calculate the difference between the alternate measurement temperature ( in °C) and the 15°C base standard: Δt=t−15delta t equals t minus 15 3. Calculating the VCF ( CTLcap C sub cap T cap L end-sub
Comprehensive Guide to Using ASTM Table 54B in Excel for Petroleum Calculations Astm Table 54b Excel
This paper presents a step-by-step guide to creating an Excel spreadsheet for performing calculations using ASTM Table 54B. The spreadsheet can be used to calculate the density of crude oils at various temperatures and convert the density from one temperature to another. By following this guide, users can create a useful tool for everyday calculations in the petroleum industry.
Understanding and Utilizing ASTM Table 54B in Excel ASTM Table 54B (Generalized Products, Correction of Volume to 15°C) is a cornerstone standard in the petroleum and chemical industries. It provides the Volume Correction Factors (VCF) needed to convert metered liquid volumes at observed temperatures to standard volumes at 15°C. Close the VBA Editor
Use VLOOKUP to find the VCF based on the intersection of Density and Temperature.
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 Calculating the VCF ( CTLcap C sub cap
Where:
. If you have API Gravity, you must first convert it to density at 15°C. For pre-built templates, sites like Knowledge of Sea
Excel handles raw numbers differently than dedicated software. Always wrap your final formulas inside a ROUND(..., 5) function to ensure compliance with oil custom entry regulations.
=VLOOKUP(Observed_Temp, Table54B_Range, Match(Density15, Density_Columns, 0), TRUE) Method 2: VBA Custom Function (Recommended)