An Interactive 5-Day Training Course
Advanced Production Engineering Using MS Excel
Advanced Models and Automation
Secure your spot now!
Duration
5 Days
Price
$ 2,500
Starting From
11 Oct 2027
Advanced Production Engineering Using MS Excel
Have Questions ?
Advanced Production Engineering Using MS Excel - PE-AD-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| PE-AD-EXCEL-PEA27 | 11 - 15 Oct 2027 | 10 AM CST | 4 Hours Per Day |
Online |
USD |
2500 |
Need this for a group? We deliver the same course in-house — face-to-face at your location or online — tailored to your assets and team level. Contact info@peassociations.com.
Boost your team's skills and your budget! Enjoy group discounts for collaborative learning. Send an inquiry to info@peassociations.com.
Advanced Production Engineering Using MS Excel
Description
Once the standard calculations are in place, Excel can go considerably further: mechanistic flow models, multi-well network solutions, time-stepped depletion models, probabilistic analysis and automated workflows that process a whole field's data. This course covers that advanced territory for engineers who already build their own workbooks.
Participants build mechanistic multiphase flow models rather than empirical correlations, then extend single-well models into simple network and system models with shared constraints. The course covers artificial lift modelling, time-stepped models that couple deliverability with depletion, Monte Carlo simulation for uncertainty, and optimisation using Solver. The automation sections cover VBA for repetitive tasks, user-defined functions, connecting Excel to production databases and files, and building multi-well tools that run over hundreds of wells. Throughout, the course covers testing, validation and performance for large workbooks.
The gap between a single-well spreadsheet and a field-level tool is mostly structure and automation. A calculation that works for one well can be made to run for three hundred if the inputs are tabulated, the calculation is written as a function and a short routine loops over the well list. That is the point at which Excel stops being a calculator and becomes a production engineering tool.
Mechanistic models are the other step up. Empirical flow correlations are quick to implement but fail outside their data range. Implementing a mechanistic model, with flow pattern prediction and pattern-specific pressure gradient calculations, is more work but produces something that behaves sensibly across conditions and that the engineer fully understands.
Advanced workbooks need engineering discipline of their own. Iterative solutions must converge reliably, large models must calculate quickly enough to be usable, and results must be validated against known cases before anybody relies on them. This course covers that discipline as seriously as the modelling itself.
By the end of this training, participants will be able to:
- Build mechanistic multiphase flow models, including flow pattern prediction.
- Implement pattern-specific pressure gradient calculations.
- Build multi-well network models with shared constraints.
- Model gas lift, ESP and rod pump performance in Excel.
- Build time-stepped models coupling deliverability with reservoir depletion.
- Implement Monte Carlo simulation for uncertainty analysis.
- Apply Solver and optimisation routines to production problems.
- Write VBA macros and user-defined functions for repetitive tasks.
- Connect Excel to production databases, files and external data.
- Build, test and validate multi-well tools that run across a field.
Organisations sending participants to this training will:
- Build field-level analysis tools without specialist software.
- Improve the technical quality of in-house engineering models.
- Automate repetitive calculation and reporting work.
- Handle uncertainty explicitly in production analysis.
- Reduce dependence on undocumented individual spreadsheets.
Participants will:
- Be able to implement mechanistic and advanced models in Excel.
- Be able to build network, time-stepped and probabilistic models.
- Be able to automate work with VBA and user-defined functions.
- Be able to connect Excel to production data sources.
- Be able to test and validate complex workbooks.
- Experienced production engineers
- Well performance and optimisation engineers
- Reservoir engineers building analysis tools
- Production technologists
- Technical specialists supporting field operations
- Engineers who already build their own spreadsheets
Module 1: Advanced Workbook Architecture
- Structuring large models
- Calculation performance and volatility
- Iterative solution control and convergence
- Testing frameworks and validation cases
- Version control and change tracking
Module 2: Mechanistic Multiphase Flow Models
- Flow pattern prediction
- Pattern-specific pressure gradient models
- Holdup calculation
- Implementing transition criteria
- Comparison against empirical correlations
Module 3: Network and System Models
- Multi-well systems and shared flowlines
- Back-pressure interaction
- Solving networks iteratively in Excel
- Applying facility constraints
Module 4: Artificial Lift Models
- Gas lift injection and performance modelling
- ESP pump curve and stage calculations
- Rod pump load and displacement calculations
- Lift optimisation across wells
Module 5: Time-Stepped Models
- Coupling deliverability with reservoir depletion
- Tank material balance with well performance
- Forecasting with changing conditions
- Time step control and stability
Module 6: Uncertainty and Monte Carlo
- Distributions and sampling in Excel
- Monte Carlo implementation
- Interpreting probabilistic results
- Sensitivity and tornado analysis
Module 7: Optimisation
- Solver setup for engineering problems
- Constraints and objective functions
- Lift gas allocation optimisation
- Limits and pitfalls of spreadsheet optimisation
Module 8: VBA Automation
- VBA basics and the editor
- Loops over wells and data sets
- User-defined functions for engineering calculations
- Error handling in code
- Automating reports and charts
Module 9: Data Connections and Field-Scale Tools
- Connecting to databases, CSV files and queries
- Refreshing and validating imported data
- Building multi-well batch calculation tools
- Output tables, dashboards and exports
- Testing and handover of finished tools
Upon successful completion of this training course, delegates will be awarded an official Certificate of Completion issued by the Petroleum Engineers Association (PEA), an ISO 9001:2015 certified training organization. The certificate carries 10 Credits and formally records the total learning hours completed.
Each certificate is signed by the Course Facilitator and the CEO of the Petroleum Engineers Association, and serves as verifiable proof of professional training that delegates can present to employers and professional bodies worldwide.
Frequently Asked Questions
All course bookings made through PEA are strictly non-refundable. By registering for a course, you acknowledge and accept that all fees are payable in full and are not subject to refund under any circumstances, including changes in personal or professional commitments or partial attendance.
PEA reserves the right to make reasonable adjustments to course content, trainers, or schedules where necessary, without entitling delegates to a refund. Comprehensive details of each course — including objectives, target audience, and content — are clearly outlined before enrolment, and it is the responsibility of the delegate to ensure the course's suitability prior to booking.
For any inquiries related to cancellations or bookings, please contact our support team, who will be happy to assist you.
