In this six-part video tutorial, I will guide you on how to transform Excel into an accessible user interface for swiftly generating a black-oil .DATA simulation deck for a basic box model.
The tutorial uses a gas/water field as an example, but the process can be adapted and expanded for an oil field or a CBM field.
The primary aim is to enable users to quickly set up a simple model and test various key sensitivities without relying on more time-consuming pre-processing software.
The Excel UI is linked to a series of VBA macros that drive the model generation process. The code is unlocked with the workbook, so users can further customize it to meet their needs.
→ For a better viewing experience, please watch on a large screen and not on a mobile display.
→ In the video player, click on this symbol at the bottom right to maximize it for a full-screen view:
→ You can also adjust the playback speed. I recommend to set it at 1.25x
<aside> ⚠️ Mac Users: ActiveX (scroll bars) is a technology that is not supported on the Mac operating system. This is a Mac compatibility issue, not an issue with Excel itself, so I'm afraid I can't do anything on my end.
</aside>
👉 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 👇