Uses the density at 15°C and the observed temperature to determine the VCF. The Formula: Standard Volume ( V15cap V sub 15 ) = Observed Volume ( Vtcap V sub t ) × Volume Correction Factor (VCF).
If you are building a calculator for professional use, you should utilize the standard implementations (often available as DLLs or Add-Ins). However, for educational purposes or internal estimations, you can build a simplified approximation.
The calculation proceeds as follows:
Let’s build a professional-grade calculator from scratch. Astm Table 54b Excel
Tell me your specific project requirements, and I can provide the exact formulas or code structures you need. Share public link
In cell B6, enter: = (341.0977 / ((B2/1000)^2)) + (-0.69859 / (B2/1000)) + 0.001373
The polynomial is validated only for certain ranges. If you enter a temperature of 300°F, Excel will give you a number, but it will be wrong. Always enforce data validation (Data > Data Validation) to restrict observed temperatures between -40°F and 200°F. Uses the density at 15°C and the observed
Here is a simplified structural breakdown of how a VBA function handles this calculation: : Define cells for Density at 15°C ( D15cap D sub 15 ) and Temperature ( Calculate Thermal Expansion ( α15alpha sub 15 ) : The standard defines product-specific constants ( K0cap K sub 0 K1cap K sub 1
Finally, the Gross Standard Volume (G.S.V.) at 15°C = Gross Observed Volume (G.O.V., m³) × VCF.
Petroleum liquids expand when heated and contract when cooled. To trade oil fairly, the industry standardizes volumes to a fixed reference temperature. Share public link In cell B6, enter: = (341
In the oil and gas industry, accurate volume correction is critical for financial transactions, inventory management, and custody transfer. Petroleum products expand and contract significantly with temperature changes. To standardize measurements, the industry relies on the American Society for Testing and Materials (ASTM) measurement tables.
Using a VBA module allows you to cleanly run this calculation across thousands of rows without bloating your spreadsheet. Method 2: 2D Index-Match Lookup Tables
This step‑by‑step process is used daily by bunker surveyors, ship officers, and cargo inspectors to determine the quantity of fuel delivered or remaining on board.