Imagine having instant access to the most reliable PVT correlations for oil, gas, and water, all within the simplicity of Excel.

Back in 1991, William McCain’s groundbreaking paper identified the best correlations from hundreds of global fluid studies.

PaperCover.png

I’ve coded these correlations into VBA, so now, instead of switching between software or 3rd party tools, you can seamlessly run these calculations right in your workbook.

With this custom-built Excel Add-in, these correlations are ready to use, no coding required. Simply call them like any other Excel formula.

Tutorial

See how the tool works in this brief video tutorial:

https://youtu.be/JS1iMNJto7U

Here’s a brief example of working through some Oil PVT parameters, demonstrating how different functions are applied to the saturated and undersaturated regions:

Oil_example.mp4