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.

Tutorial

See how the tool works in this 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


How did you like it?

If you can spare a moment, I would really appreciate any feedback to help me improve the products I’m putting out.

https://page.famewall.io/CrowdField


About the author

2024-04-AlanHeadshots_Final.jpg

Alan Mourgues, MSc, is a Petroleum Reservoir Engineering Consultant with 25 years of international industry experience. Through his business, moREc, he provides subsurface and financial expertise to Australian and international clients in the conventional and CBM industries.

Alan is also the founder of CrowdField, The Go-To Hub for the O&G Crowd

To learn more, visit crowdfield.net.

Alan’s LinkedIn

CrowdField’s LinkedIn

https://embed.famewall.io/carousel/CrowdField


Alan's Lifetime Vault

Alternatively, you can gain lifetime access to everything I produce and publish in the Store with a single one-off payment.

This includes courses, tutorials, resources, and all future content I will continue to create and publish.

Untitled


CrowdField

The Go-To Hub for the O&G Crowd

LinkedIn is no longer the gathering hub for technical discussion and growth, is it?

Enter CrowdField.

We are dedicated to building a vibrant ecosystem for reservoir engineers, with the goal of creating a dynamic community for knowledge sharing, tool exchange, collaboration, and monetization.

Our value proposition to you includes:

Sounds appealing? Check us out at crowdfield.net

https://www.crowdfield.net/

Store

Check the CrowdField Store for a growing catalog of valuable products, both free and paid.

https://www.crowdfield.net/store

Blog

Deep dives, how-to’s, case studies… The CrowdField Blog is your go-to resource for staying up to date with our growing community.

https://www.crowdfield.net/blog

The CrowdField dAIgest - Newsletter

Subscribe for free to stay up to date with AI news, startups, innovators, workflows, and AI jobs in O&G.

https://www.crowdfield.net/newsletter