In 1991, William McCain published a cornerstone paper in petroleum engineering, revealing the best PVT correlations for oil, gas, and water after analyzing hundreds of fluid studies from around the world.
Sure, these correlations are widely available in various software, but oftentimes you just want to run a quick calculation directly in Excel, without switching to third-party tools.
I’ve taken these correlations and coded them into VBA as an Excel Add-in, so you can access them in any workbook—no need to touch the code. Simply call them like any other Excel formula.
See how the tool works in this video tutorial:
Here’s a brief example of working through some Oil PVT parameters, demonstrating how different functions are applied to the saturated and undersaturated regions: