Advanced Reservoir Engineering Using MS-Excel
Have Questions ?
Advanced Reservoir Engineering Using MS-Excel - RE-AD-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| RE-AD-EXCEL-PEA27 | 15 - 19 Mar 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 Reservoir Engineering Using MS- Excel
A senior-level course for experienced reservoir engineers. It covers compositional fluid behaviour, advanced material balance with assisted history matching, fractured and gas condensate systems, finite difference solution of flow equations in a spreadsheet, miscible and enhanced recovery modelling, coupled geomechanical and thermal effects, unconventional performance and probabilistic decision analysis. Substantial prior reservoir engineering experience is required.
Description
There is a level of reservoir engineering practice where the standard methods have all been applied, the answers disagree with each other, and the engineer has to decide what the reservoir is actually doing. A material balance that returns a pore volume larger than the mapped structure. A condensate field where the reported liquid recovery cannot be reconciled with the depletion study. A fractured carbonate where the fracture system drains far faster than the matrix can supply. A chalk reservoir where compaction and permeability loss are competing. An injection scheme where miscibility is marginal at current pressure. These problems are not solved by running the calculation again; they are solved by reformulating it.
This course operates at that level. It covers equation of state fluid description and pseudoisation into working models, advanced material balance formulations with regression-based and constrained history matching, non-uniqueness diagnosis and parameter confidence, dual porosity and matrix-fracture transfer, gas condensate and volatile oil engineering including two-phase pseudo-pressure, finite difference solution of the diffusivity and material balance equations directly in a spreadsheet with stability and convergence control, extended displacement theory including multiphase fractional flow and gravity-dominated systems, miscibility and minimum miscibility pressure, analytical modelling of chemical and thermal recovery, unconventional well performance, coupled geomechanical and thermal effects on flow, integrated production system modelling, and probabilistic forecasting with formal decision analysis. The methods are demanding and the course assumes the audience is ready for them.
Reservoir engineering practice divides at a point that has less to do with years of experience than with the type of problem being solved. Below it, the discipline is the correct application of established methods to reservoirs that behave broadly as those methods assume. Above it, the reservoir does not cooperate: the fluid changes composition as it depletes, the rock is two media rather than one, part of the drive energy comes from the rock framework rather than the fluid, the flow regime never stabilises, or the displacement process alters the fluids themselves. In these cases the standard equation is not merely imprecise, it is the wrong equation.
Numerical simulation is the usual response, and it is often the right one. But a simulation model of a complex reservoir contains hundreds of parameters, most of which are unmeasured, and it can be tuned to match almost any history. Without an independent analytical understanding of the mechanism, the engineer has no basis for judging whether the match is meaningful. The advanced analytical methods exist to supply exactly that basis: to establish what the pressure history implies about connected volume, what the fluid data implies about achievable liquid recovery, what the fracture description implies about matrix drainage rate, and where the simulation result should be treated with suspicion.
Those methods are fully implementable in a spreadsheet, including numerical solution of the flow equations themselves for one dimensional and simple multi-cell systems. Building them there keeps every assumption visible and every parameter accountable. This course develops them to the level required of a senior reservoir engineer who is expected to reach a defensible position on a difficult reservoir and hold it in front of a technical audit.
By the end of this training, participants will be able to:
- Apply equation of state fluid descriptions and pseudoise compositional behaviour into working reservoir models
- Formulate advanced material balance for multi-tank, compacting, communicating and abnormally pressured systems
- Perform regression-based assisted history matching and quantify parameter non-uniqueness and confidence limits
- Model dual porosity behaviour including matrix-fracture transfer, imbibition and gravity drainage
- Analyse gas condensate and volatile oil reservoirs using two-phase pseudo-pressure and depletion study data
- Solve the flow and material balance equations numerically in a spreadsheet with control of stability and convergence
- Evaluate miscible and immiscible gas injection, estimate minimum miscibility pressure and model displacement performance
- Model chemical, polymer and thermal recovery processes analytically and screen enhanced recovery options quantitatively
- Quantify coupled geomechanical, thermal and compaction effects on reservoir performance and permeability
- Generate probabilistic forecasts, apply decision analysis and value of information, and defend the result under technical audit.
Organisations sending participants to this training will:
- Reach defensible technical positions on the reservoirs where routine methods disagree or fail
- Provide independent analytical validation of simulation studies before results drive investment
- Improve reserves reliability for complex assets and strengthen their position under technical audit
- Evaluate enhanced recovery, gas injection and pressure maintenance options on a rigorous technical basis
- Retain senior subsurface capability internally rather than outsourcing complex reservoir studies
- Reduce the risk of major development decisions resting on a model that misrepresents the reservoir mechanism
Participants will:
- Operate at senior technical level on complex and non-conventional reservoir systems
- Recognise and correct the point at which a standard method becomes invalid
- Build numerical and advanced analytical models independently and defend them in technical review
- Diagnose contradictory results between material balance, simulation and production data
- Quantify uncertainty rigorously and convert it into decision-relevant advice
- Take on reservoir engineering authority, audit and technical assurance responsibilities
This course is ideal for reservoir engineers, petroleum engineers, and technical professionals in the oil and gas sector who wish to deepen their Excel skills for advanced reservoir analysis. It is also beneficial for data analysts and project managers looking to understand the engineering insights behind reservoir data and performance evaluation.
Module 1 — Compositional Fluid Behaviour and Advanced PVT
- Phase envelopes, critical behaviour and near-critical fluids
- Cubic equations of state, formulation and parameter meaning
- Tuning an equation of state to laboratory measurements
- Constant volume depletion, differential liberation and swelling test data
- Modified black oil formulation and volatilised oil-gas ratio
- Pseudoisation and lumping of components for working models
- Compositional gradients with depth and gravity-chemical equilibrium
- Multi-stage separator optimisation and surface yield calculation
Module 2 — Advanced Material Balance and Assisted History Matching
- Full material balance expansion with all drive and compaction terms
- Abnormally pressured and compacting reservoirs and apparent volume inflation
- Multi-tank formulations with intertank transmissibility
- Communicating layers and partial pressure equilibration
- Objective function formulation, weighting and data conditioning
- Regression-based and constrained parameter estimation
- Non-uniqueness diagnosis, parameter correlation and confidence limits
- Ensemble and multi-realisation matching approaches
Module 3 — Naturally Fractured Reservoir Engineering
- Fracture system description for engineering use
- Dual porosity and dual permeability formulations
- Matrix-fracture transfer functions and shape factor derivation
- Capillary imbibition and its rate dependence
- Gravity drainage, capillary continuity and block-to-block reinfiltration
- Material balance and depletion behaviour of fractured systems
- Recovery mechanisms, expected recovery and surveillance diagnostics
Module 4 — Gas Condensate and Volatile Oil Systems
- Retrograde behaviour and near-wellbore condensate saturation build-up
- Three-region model and effective near-well relative permeability
- Two-phase pseudo-pressure formulation for deliverability
- Condensate material balance using depletion study data
- Gas cycling, revaporisation and enhanced liquid recovery
- Volatile oil systems and the black oil formulation breakdown point
- Reconciling reported liquid yields with fluid and reservoir data
Module 5 — Numerical Solution of Reservoir Equations in a Spreadsheet
- Finite difference approximation of the diffusivity equation
- Explicit, implicit and Crank-Nicolson formulations
- Grid design, time stepping and truncation error
- Stability criteria and convergence control
- One dimensional single-phase and two-phase solution schemes
- Multi-cell tank models with intercell flow
- IMPES concept and its spreadsheet implementation
- Validation of numerical results against analytical solutions
Module 6 — Advanced Displacement Theory
- Multiphase fractional flow with gravity and capillary terms
- Extended Buckley-Leverett for dipping and layered systems
- Displacement stability, viscous fingering and instability number
- Gravity segregation, gravity number and segregated flow
- Stratified reservoir performance with and without crossflow
- Streamtube and streamline approximations for areal sweep
- Scaling groups and their use in performance prediction
Module 7 — Miscible and Gas Injection Displacement
- First contact, vaporising gas and condensing gas drive mechanisms
- Ternary diagrams and multiple contact miscibility development
- Minimum miscibility pressure by correlation, slim tube and EOS methods
- Miscible displacement efficiency and mixing zone growth
- Water alternating gas design, ratio and cycle optimisation
- Injectant selection and carbon dioxide flooding considerations
- Conformance control and breakthrough management
Module 8 — Enhanced Recovery Process Modelling
- Screening framework against rock, fluid and reservoir criteria
- Polymer flooding: rheology, mobility control and analytical recovery prediction
- Surfactant and alkaline processes, interfacial tension and capillary desaturation
- Thermal recovery: steam flooding, cyclic steam and heat balance calculation
- In-situ combustion and its applicability limits
- Analytical incremental recovery estimation and pilot scale-up
- Sequencing technical screening with economic evaluation
Module 9 — Unconventional and Tight Reservoir Performance
- Flow physics in nanodarcy systems and non-Darcy contributions
- Adsorption, desorption and gas storage in organic-rich rock
- Stimulated reservoir volume and effective fracture network representation
- Linear flow analysis and contacted pore volume estimation
- Transient dominated production and modified decline formulations
- Parent-child interference, depletion and refracturing response
- Forecast reliability and realistic recovery factor expectation
Module 10 — Coupled Geomechanical and Thermal Effects
- Stress path during depletion and effective stress change
- Compaction drive contribution and reservoir strain calculation
- Stress-dependent permeability and porosity loss
- Compaction, subsidence and well integrity consequences
- Thermal stress effects around injectors and fracture growth
- Coupling strategies and when a coupled treatment is required
- Practical implementation of coupled effects in analytical models
Module 11 — Integrated Production System Modelling
- Inflow performance for complex wells, completions and multilaterals
- Multiphase vertical lift performance and correlation selection
- Nodal analysis, operating point and system deliverability
- Network constraints, backpressure and compression effects
- Artificial lift screening and its influence on recovery
- Coupling reservoir depletion with well and facility limits over field life
- Optimising field production under multiple constraints
Module 12 — Probabilistic Forecasting, Decision Analysis and Assurance
- Uncertainty framing and parameter distribution selection
- Monte Carlo forecasting of profiles, recovery and reserves
- Parameter dependence, correlation and correct aggregation across assets
- Experimental design and response surface methods
- Value of information and value of flexibility assessment
- Decision trees and expected value under uncertainty
- Presenting probabilistic results to decision makers and boards
- Model documentation, technical assurance and audit readiness
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.
Your expert course leader is a senior petroleum engineering consultant, certified trainer and university lecturer with more than 25 years of experience, specialising in advanced reservoir engineering modelling using spreadsheet based tools.
His technical expertise covers compositional PVT, assisted history matching, fractured and condensate systems, spreadsheet based numerical solution methods, miscible displacement, EOR modelling, coupled effects and probabilistic decision analysis.
He has provided consulting and technical support to international operators and national oil companies across the Middle East, North Africa, Asia Pacific and the Americas, working on advanced reservoir modelling studies, EOR performance evaluation, fractured and condensate reservoir analysis and probabilistic decision support projects across a range of asset types.
He has designed and delivered technical training programmes on advanced reservoir engineering using Excel for operating companies and service providers, conducting both classroom and online sessions for engineers and technical staff across the Middle East, Asia Pacific, Africa and Europe.
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.