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:
👉 FAQs, Troubleshooting & Feature Request
If you’d like to support the CrowdField project, two small actions make a big difference:
👉 Subscribe to the CrowdField YouTube channel, here
👉 Follow CrowdField on LinkedIn, here
That’s where I share short demos, workflows, and behind-the-scenes builds that don’t always make it into written content.
If you can spare a moment, I would really appreciate any feedback to help me refine existing products and decide what to build next.
https://page.famewall.io/CrowdField
Alan Mourgues, MSc, is a Petroleum Reservoir Engineering Consultant with 25 years of international industry experience.
Through his consultancy, moREc, he provides subsurface and financial expertise to Australian and international clients.
Alan is also the founder of CrowdField, a platform built to help O&G professionals upskill, collaborate, and monetize their expertise.
https://embed.famewall.io/carousel/CrowdField
Technical professionals need better places to learn, build, and collaborate.
CrowdField is an ecosystem for subsurface pros to:
Explore the platform at crowdfield.net
Check the growing catalog of free and paid tools to help you level up and improve productivity.
https://www.crowdfield.net/store
Explore our Plans and choose the option that matches your ambition 👇