CrowdField Masterclass

Subsurface workflows, rebuilt.

Rebuild real engineering workflows across the modern stack, end to end: structured Excel and Power Query, AI copilots, Python engines, web apps, then tools you deploy and version on GitHub.

You build something that runs in every module, using real reservoir-engineering workflows: decline curves, production data, forecasting, economics and Monte Carlo. You finish with two complete case studies: PVT correlations and relative permeability.

The full course is released as 18 video lessons, over 12 hours in total, with accompanying notes and all files and source code. Built for subsurface professionals who know the workflows and want their tooling to catch up. No coding background needed.

Excel
Power Query
VBA
AI copilots
ChatGPT
Codex
Claude
GrokBot
VS Code
Python
Streamlit
Web apps
GitHub
Netlify
Deployment
$599one-time

Premium members pay 30% less. Lifetime members already have it. See pricing

18 lessons
Video & notes in companion workspace
12 hours
Recorded video, self-paced
Every file
Workbooks, datasets, prompts, scripts
End to end
From first workflow to deployed tool
The problem

Your toolkit moved on. Your workflows did not.

  • Copy and paste between disconnected spreadsheets
  • The same production data cleaned by hand every month
  • Workbooks that break the moment someone else opens them
  • Reports assembled by hand from four different sources
  • Tools only you can run, because only you understand them

Python, AI assistants, Power Query and browser apps are all within reach of a working engineer today. None of it needs a computer science degree.

What is missing is the order of operations: which tool a workflow actually needs, how the pieces connect, and how to fold them into the work you already do every day.

This masterclass is about workflow orchestration. Not mastering a single tool, but learning how to combine the modern stack to build workflows that are faster, cleaner, more scalable, and easier to maintain.

What you will build

Working tools, not slides

This is the kind of thing you build. The same Monte Carlo volumetrics model: the nth Excel version buried on your computer on one side, a polished live web app on the other, both driven by the same inputs. Drag the divider.

Every module ends with something that runs, and the course closes with two end-to-end case studies on PVT and relative permeability.

You keep every file, prompt, script and line of code, so you rebuild each one yourself, then point it at your own data.

Module 1.1

A structured Excel workbook

Tables, LET, dynamic arrays, LAMBDA and form controls, with a first look at VBA. The clean base the rest of the course is built on.

Excel
VBA
Module 1.2

A production data pipeline and scenario dashboard

Clean monthly production, reshape forecast tables, load both into the data model, then drive pivot tables, charts and slicers from it. No more manual rebuilds each month.

Power Query
Data model
Module 2.1

AI-assisted formulas, queries and macros

Prompt AI to write, explain, modify and debug Excel formulas, Power Query and VBA, then move from copilot to agent. Every prompt and output is in the notes, ready to reuse.

AI
Claude
Module 2.2

A Python engine with an Excel front end

Move the calculation out of the spreadsheet into Python, while keeping Excel as the place where inputs, review and reporting still happen.

Python
Excel
Module 3.1

An interactive DCA app

Wrap the decline curve forecast engine in a Streamlit app with controls and live charts, so a colleague can run it in a browser without touching the code.

Streamlit
Python
Module 3.2

Web apps built with AI

Beyond Streamlit: economics and Monte Carlo tools built as browser apps, with AI doing most of the coding and you directing the engineering.

Web apps
AI
Module 4.1

A deployed, versioned tool

Put the project on GitHub, deploy it and share it, so the tool stops living in one local spreadsheet on one machine and starts being something a team can use.

GitHub
Deployment
Case Study A

PVT Correlation Explorer

The full method run on PVT correlations, start to finish: workflow design, the engine, the app, and a working tool you can hand over.

PVT
End to end
Case Study B

Relative Permeability Workflow

A second complete build on relative permeability, the same path from spreadsheet logic to a deployed, shareable tool.

Rel perm
End to end
Curriculum

Four modules, 18 lessons, 2 end-to-end case studies

The full course is released, 18 lessons and over 12 hours of video. Focused sessions, each on one step of the workflow. Work through them in order the first time, then come back to the parts you need.

M0
Intro
1 lesson
+

How the course is laid out, the stack it uses, and how to get set up with the files.

  • M0
    Intro
M1
Excel as a Modern Workflow Engine
7 lessons
+

Rebuild the spreadsheet itself, then a Power Query pipeline that takes raw production data through to a scenario dashboard.

  • M1.1 P1
    Excel Foundations, Part 1: Core Formulas, Tables, LET and VBA Intro
  • M1.1 P2
    Excel Foundations, Part 2: Dynamic Arrays, LAMBDA and Interactive Controls
  • M1.2 P1
    Power Query Example 1: Cleaning Monthly Production
  • M1.2 P2
    Power Query Example 2: Forecast Table Reshape
  • M1.2 P3
    Power Query Example 3: Connect and Prepare Tables for the Data Model
  • M1.2 P4a
    Power Query Example 4a: Pivot Tables and Charts from the Data Model, Part 1
  • M1.2 P4b
    Power Query Example 4b: Pivot Tables and Charts from the Data Model, Part 2
M2
AI-Assisted Workflow Development
6 lessons
+

Use AI to write, explain and debug the work, then move the calculation into Python while Excel stays the front end.

  • M2.1 P1
    AI as Your Workflow Copilot, Part 1: AI for Excel Formulas
  • M2.1 P2
    AI as Your Workflow Copilot, Part 2: AI for Power Query
  • M2.1 P3
    AI as Your Workflow Copilot, Part 3: AI for VBA
  • M2.1 P4
    AI as Your Workflow Copilot, Part 4: From Copilot to Agent
  • M2.2 P1
    Excel to Python Workflows, Part 1: From Excel to a Python Engine
  • M2.2 P2
    Excel to Python Workflows, Part 2: Excel Front End, Python Back End
M3
Interactive and AI-Native Workflows
2 lessons
+

Turn the engine into a tool other people can use, first in Streamlit, then as AI-built web apps.

  • M3.1
    From Python Engine to Interactive App (Streamlit)
  • M3.2
    Beyond Streamlit: Building Web Apps with AI
M4
Deployment + End-to-End Workflow Integration
2 lessons, 2 case studies
+

Put what you built on GitHub, deploy it and share it, then run the whole method end to end on two reservoir engineering case studies.

  • M4.1
    GitHub, Deployment and Distribution
  • M4.2
    End-to-End Engineering Workflow Builds
  • Case A
    Case Study A: PVT Correlation Explorer
  • Case B
    Case Study B: Relative Permeability Workflow

Example workflows used across the course include decline curve analysis, production data processing, forecasting, economics, Monte Carlo, PVT correlations and relative permeability.

How it works

Video lessons + files, at your own pace

01

Buy and create your login

Sign up using the same email address you use for your purchase, then access the course through the CrowdField member portal.

02

Watch the lessons

Each lesson is a short recorded video available in the portal. Pause, rewind and return to any step whenever you need to.

03

Open the files

Download the workbook, dataset, query, VBA module and Python files used in each lesson, together with written notes and the exact AI prompts used.

04

Rebuild it on your data

Follow the example workflow first, then apply the same pattern to your own wells, datasets and reports.

What you need: Excel for Windows desktop. Some workbooks use VBA macros and ActiveX controls, which Excel for Mac does not support. From Module 2 onward, you will also use Python and an AI coding assistant. Working subsurface knowledge is the only prerequisite.

Who it is for

Built for practitioners, not developers

This is for you if

  • ✓
    You are a reservoir or subsurface engineer and know DCA, PVT, volumetrics or production analysis
  • ✓
    You lose real hours each week to manual, repeatable spreadsheet work
  • ✓
    You have heard of Python and AI but have not found a practical way in
  • ✓
    You want to build tools the rest of your team can actually use
  • ✓
    You want to keep the engineering judgement, and check every number

This is not for you if

  • ✕
    You want a coding bootcamp or a career change into software
  • ✕
    You want a generic AI tools overview or a list of Excel tips
  • ✕
    You already build and deploy Python apps every week
  • ✕
    You need live classes on a fixed timetable
  • ✕
    You are buying a workflow build for your company (that is moREc)
Alan Mourgues
Your instructor

Alan Mourgues, CPEng

Reservoir Engineer · Founder, CrowdField · Brisbane

  • ✓
    20+ years in reservoir engineering across operators, advisory groups and consulting
  • ✓
    Builds the CrowdField Excel, Python and web app tool library used by subsurface engineers
  • ✓
    Hosts the O&G Expert webinar series
  • ✓
    Hosts the 'Builders, Agents, and Workflows'' podcast, to discuss all things AI in O&G
  • ✓
    Publishes tutorials and more on the CrowdField YouTube channel

This course is the path I took as a reservoir engineer, put in order and cleaned up. The tools in it exist because the work in front of me needed them, not because I set out to write software. The method stays the same the whole way through: start with the workflow, reach for the tool it calls for, and keep every number something you can check yourself.

Testimonials

What practitioners say

Klaas Kostro
“

After 24 years of simulation work I have learned to be sceptical of tools that promise more than they deliver. CrowdField is one of the few places where the gap between knowing about AI and actually applying it to subsurface work gets closed, and Alan is guiding a generation of reservoir engineers across it.

Klaas Kostro
Senior Reservoir Engineer & Simulation Expert, Reservoir GmbH · Founder, runspec.io
Pricing

One course, one price

Pay once for the full course, yours for good. If you are already a CrowdField member, check your route below before you buy.

Subsurface Workflows, Rebuilt
$599one-time

Self-paced. Start today.

Buy the course

After checkout, create your portal login with the same email. The whole course, Modules 0 to 4, is open from day one.

What is included
  • ✓
    All 18 lessons across Modules 0 to 4
  • ✓
    Access to companion workspace with supporting notes
  • ✓
    Every workbook and engineering dataset used in the lessons
  • ✓
    All VBA, Power Query and Python source, plus the app projects
  • ✓
    Written lesson notes with the steps and the exact AI prompts used
  • ✓
    Future updates to the course, at no extra cost

Premium members

30% off

Premium ($30/month) includes 30% off all courses and master classes.

Compare memberships →

Lifetime members 25 founding seats

Included

Lifetime ($990 one-time) includes this course and every current and future CrowdField master class and course, plus the full tool library with source code. Capped at 25 founding seats, and it closes for good once they are gone.

See Lifetime →
FAQ

Before you buy

Do I need to know how to code?
+

No. Working subsurface knowledge is enough. The course shows you how to use AI, Python and Power Query inside workflows you already understand. You read and check the code, and AI does most of the typing.

Is it live or self-paced?
+

Self-paced. Every lesson is a recorded video in the member portal, with the files and notes alongside it. There are no live sessions to attend.

Earlier pages said four one-hour sessions. What changed?
+

The four topics are the same. While building it, I split them into short lessons, one step each, which is easier to follow and easier to come back to. The full course is now 18 lessons plus 2 case studies, from a cleaner Excel workflow through to a tool deployed and versioned on GitHub.

Is the course finished?
+

Yes. All four modules are released, including Module 4: GitHub, deployment and distribution, the end-to-end workflow builds, and the PVT and relative permeability case studies. You get all of it the day you buy.

What software do I need?
+

Excel for Windows desktop. Some workbooks use VBA macros and ActiveX controls, which Excel for Mac does not support. From Module 2 you will also use Python and an AI assistant.

I already use Python. Is this still for me?
+

Possibly. The course is aimed at engineers earlier in that shift. If you already write Python, the value is in the workflow design, the AI-assisted build approach and how Excel, Python and apps fit together, more than in the Python itself. Read through the curriculum and decide.

How do I get access after I buy?
+

Create a login in the CrowdField member portal using the same email you paid with. You'll get instructions in your welcome email.

I was in the founding cohort. Do I keep access?
+

Yes. Founding members keep full access, at no extra cost. Use the same portal login.

I am a CrowdField member. What do I pay?
+

Lifetime members already have it, so there is nothing to buy. Premium members get 30% off all courses and master classes. Essentials (free) members pay the full $599.

Can my company use this?
+

The course is sold to individual practitioners. If you want a workflow built or rolled out for a team, that work is done through moREc.

Something else? Email alan@crowdfield.net.

The tools exist. Your workflows need to catch up.

Start with one workflow you run every month. Rebuild it once, properly, deploy it, and share it as a web app where the rest of your team can use it.

Buy the course, $599

Self-paced · 18 lessons · Premium 30% off · included with Lifetime