Excel Add-In for Oil & Gas PVT Correlations

In 1991, William McCain published a groundbreaking paper in petroleum engineering, identifying the best PVT correlations for oil, gas, and water after analyzing hundreds of fluid studies from around the world.

‍

While these correlations are available in many software tools, sometimes you just need a quick, on-the-spot calculation directly in Excel—without the hassle of switching between applications.

‍

I’ve taken these correlations and coded them into VBA as an Excel Add-in. Now, you can access them in any workbook—no coding required. Simply use them like standard Excel formulas and streamline your workflow.