Reservoir Engineering Using MS-Excel
Have Questions ?
Reservoir Engineering Using MS-Excel - RE-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| RE-EXCEL-PEA27 | 01 - 05 Mar 2027 | 10 AM CST | 4 Hours Per Day |
Online |
USD |
2000 |
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.
Reservoir Engineering Using MS-Excel
A foundation to intermediate course covering the core calculations every reservoir engineer needs. Participants build each method as a spreadsheet, from rock and fluid properties through volumetrics, material balance, well inflow performance, waterflooding and decline analysis. No prior reservoir engineering experience is assumed beyond a basic engineering or geoscience background.
Description
Reservoir engineering rests on a small number of relationships applied carefully to imperfect data. How much hydrocarbon is in the rock, what drives it to the well, how fast the well can produce, how much water will arrive and when, and what the field will deliver over its life. Every one of these questions is answered by a calculation that fits comfortably on a spreadsheet, and an engineer who has built those calculations personally understands the reservoir in a way that no amount of reading achieves.
This course works through the standard reservoir engineering methods in
the order an engineer meets them in practice, and shows how each one is set up
in Excel. It covers porosity, permeability, saturation and compressibility; PVT
properties for oil, gas and water; drive mechanisms and how to recognise them;
volumetric estimation of oil and gas in place; material balance for oil and gas
reservoirs; water influx and simple aquifer models; Darcy flow, skin and inflow
performance relationships; waterflood displacement and breakthrough prediction;
and decline curve analysis with reserves estimation. Alongside the technical
content, participants learn how to lay a spreadsheet out so that inputs are
separated from calculations, units stay consistent, and the result can be
checked.
Reservoir engineering is the discipline that converts a static description of the subsurface into a production forecast. A geologist and a petrophysicist describe the rock, its volume and its fluid content. The reservoir engineer takes that description, applies the physics of fluid flow and material balance, and produces the numbers on which the entire development rests: recoverable volume, production rate, well count, facility size and field life.
The methods used to do this have a long history and are well established. Volumetric estimation, material balance, Darcy flow and decline analysis were developed decades ago and remain the backbone of the discipline because they are grounded in conservation of mass and in measured reservoir behaviour. Numerical simulation extends them but does not replace them; the analytical methods remain the check that tells an engineer whether a simulation result is plausible.
Learning these methods by building them is the fastest route to real understanding. When an engineer assembles a material balance calculation cell by cell, the meaning of each term becomes clear, and so does the effect of getting an input wrong. This course is built on that principle. It assumes a technical background but no prior reservoir engineering specialisation, and it takes participants to the point where they can carry out the standard calculations of the discipline independently and explain what they mean.
By the end of this training, participants will be able to:
- Define and apply the basic rock and fluid properties used in reservoir engineering calculations
- Calculate oil, gas and water PVT properties from standard correlations and check them against laboratory data
- Identify reservoir drive mechanisms from pressure and production behaviour
- Estimate oil and gas in place by volumetric methods and apply appropriate recovery factors
- Construct and solve material balance equations for oil and gas reservoirs
- Apply simple aquifer models to estimate water influx and assess aquifer strength
- Build inflow performance relationships for oil and gas wells and quantify the effect of skin and drawdown
- Perform fractional flow and frontal advance calculations to predict waterflood breakthrough and recovery
- Analyse production decline and estimate remaining reserves and field life
- Lay out reservoir engineering spreadsheets with separated inputs, consistent units and results that can be verified
The course is delivered as a structured teaching programme that moves from principles to calculation. Each topic starts with the physical behaviour being described, develops the governing equation to the level needed for correct use, and then shows the calculation set up in a spreadsheet with worked field data. Examples are chosen from straightforward oil and gas fields so that the method rather than the complication is the focus. Common mistakes are covered directly, including unit errors, correlations used outside their range and misread pressure data, so that participants learn to check their own work.
Organizations sending participants to this training will:
- Build reliable in-house reservoir engineering capability from the foundation upward
- Bring graduate engineers and cross-discipline staff to a productive technical level faster
- Reduce basic calculation and unit errors in the spreadsheets used for reporting and planning
- Improve the quality of routine volumetric, material balance and forecast work across the asset
- Establish a common technical language between reservoir, production, geology and petrophysics teams
- Prepare staff to progress into advanced reservoir engineering and simulation work.
Participants will:
- Gain a solid working command of the core calculations of reservoir engineering
- Understand what each equation assumes and where it should not be applied
- Build and check their own models instead of relying on results produced elsewhere
- Read pressure and production data and draw the right conclusions from it
- Contribute confidently to field development, reserves and forecasting discussions
- Establish the foundation needed for advanced reservoir engineering study
- Graduate and early-career reservoir engineers
- Petroleum and production engineers moving into reservoir work
- Geologists, geophysicists and petrophysicists working alongside reservoir teams
- Field and operations engineers who need to understand reservoir behaviour
- Reserves and technical evaluation staff building a calculation foundation
- Experienced professionals returning to reservoir engineering after time in another discipline
- Technical supervisors who need to review and understand routine reservoir calculations
Module 1 — Reservoir Engineering Fundamentals and Model Setup
- The role of reservoir engineering in field development
- Reservoir types, classification and typical development questions
- Data sources: cores, logs, tests, production and laboratory studies
- Field and SI unit systems and safe conversion practice
- Spreadsheet layout: inputs, calculations, results and assumptions
- Simple error checks that catch most spreadsheet mistakes
Module 2 — Reservoir Rock Properties
- Porosity: total, effective and its measurement
- Permeability, absolute and effective, and Darcy units
- Fluid saturations and their determination
- Rock and pore compressibility
- Capillary pressure and transition zone behaviour
- Relative permeability curves and what they represent
- Net pay definition and property averaging
Module 3 — Reservoir Fluid Properties and PVT
- Reservoir fluid types and phase behaviour basics
- Bubble point pressure and its estimation
- Solution gas-oil ratio and oil formation volume factor
- Oil viscosity and compressibility
- Gas gravity, pseudo-critical properties and z-factor
- Gas formation volume factor and gas viscosity
- Formation water properties
- Selecting and checking correlations against laboratory data
Module 4 — Reservoir Drive Mechanisms
- Solution gas drive behaviour and recovery expectation
- Gas cap expansion drive
- Water drive: edge, bottom and aquifer strength
- Gravity drainage and combination drives
- Compaction and rock expansion contribution
- Recognising the drive mechanism from field data
- Typical recovery factors by mechanism
Module 5 — Volumetric Estimation of Oil and Gas in Place
- The volumetric equation for oil and for gas
- Gross rock volume from maps and area-depth relationships
- Net-to-gross, average porosity and average saturation
- Recovery factor selection and analogue use
- Building a volumetric calculation sheet
- Simple sensitivity on the main input parameters
Module 6 — Material Balance for Oil Reservoirs
- The material balance concept and its assumptions
- Underground withdrawal and expansion terms
- Undersaturated and saturated reservoir cases
- Gas cap and water influx terms
- Straight line methods for estimating oil in place
- Drive index calculation and interpretation
- Building and solving a material balance sheet from field history
Module 7 — Material Balance for Gas Reservoirs
- Gas material balance and the p/z relationship
- Volumetric gas reservoirs and gas in place estimation
- Water drive gas reservoirs and their pressure behaviour
- Effect of formation and water compressibility
- Abandonment pressure and recoverable gas
- Common misinterpretations of the p/z plot
Module 8 — Water Influx and Simple Aquifer Models
- Aquifer geometry, size and strength
- Steady-state water influx
- Unsteady-state influx and dimensionless influx functions
- Pseudo-steady-state aquifer models
- Fitting aquifer parameters to observed pressure data
- Effect of aquifer support on recovery and water production
Module 9 — Fluid Flow and Well Inflow Performance
- Darcy’s law and radial flow into a well
- Steady-state, pseudo-steady-state and transient flow
- Skin factor and its causes
- Productivity index and straight line IPR
- Vogel IPR for saturated reservoirs
- Gas well deliverability and the back pressure equation
- Effect of depletion and drawdown on well rate
Module 10 — Waterflooding and Displacement
- Why waterflood: pressure maintenance and displacement
- Mobility ratio and its effect on sweep
- Fractional flow calculation
- Buckley-Leverett frontal advance and breakthrough
- Welge method for average saturation and recovery
- Areal, vertical and displacement sweep efficiency
- Water cut development and surveillance plots
Module 11 — Decline Curve Analysis and Reserves
- Production decline behaviour and its causes
- Exponential, hyperbolic and harmonic decline
- Fitting decline models to production data
- Economic limit and remaining reserves
- Forecast construction from decline parameters
- Reserves categories and what supports each one
Module 12 — Building and Checking a Simple Field Model
- Combining volumetrics, material balance and decline into one workbook
- Cross-checking results from independent methods
- Simple sensitivity and scenario cases
- Presenting results in clear technical charts
- Documenting assumptions and data sources
- Preparing a calculation for review by others
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.
A veteran Reservoir Engineer with over 40 years of international experience across leading operators including Shell International E&P, Petroleum Development Oman (PDO), BG Group, and Oil India Limited. He is a recognized authority in reservoir engineering with deep expertise in field development planning, waterflood and chemical EOR, resource volume estimation and audits, production forecasting, and technical assurance.
At PDO, he served as Reservoir Engineering Coach and Technical Authority, mentoring over 250 engineers and designing a 3-year Graduate Development Program. As Subsurface Instructor, he built internal reservoir engineering courses that replaced 12 commercial courses and saved the company USD 0.5 million annually. Earlier, as Discipline Lead at Shell, he led standards and training for 75+ engineers and oversaw production forecasting for fields producing over 300,000 BOPD.
His hands-on field experience includes leading the implementation of one of the world's largest polymer floods in a 3-billion-barrel heavy oil field, simulation of complex coning-prone reservoirs, SEC reserves management, and FDP approvals with JV partners and regulators.
He holds B.Tech and M.Tech degrees in Petroleum Engineering from IIT (ISM) Dhanbad, serves as a reviewer for the SPE Reservoir Engineering Journal, and has authored numerous papers presented at SPE, IPTC, and SPWLA conferences worldwide. He has delivered 50+ international technical training programs and continues to consult and lecture globally, including guest lectures at IIT Dhanbad and IIT Madras.
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.