This hands-on bootcamp is designed for petroleum engineers who want to move beyond theory and actually build reservoir engineering and well testing models from scratch — in Microsoft Excel. Over two intensive days, participants work through 10 real-world projects covering the full spectrum of reservoir characterisation and well performance analysis. No black boxes, no third-party software — every model is built cell by cell, so you understand exactly what's happening under the hood. Exclusively available to PEA Members.

Workshop Objectives

By the end of this 2-day bootcamp, participants will be able to:


Build a Volumetric Reserves Estimator using deterministic and Monte Carlo methods (OOIP/OGIP)


Construct a Black Oil PVT Calculator using Standing & Vasquez-Beggs correlations


Develop a Material Balance Workbook with Havlena-Odeh straight-line analysis


Create a Decline Curve Analyzer with Arps fit using Excel Solver for EUR forecasting


Model Fractional Flow and Buckley-Leverett displacement using fw curves and Welge's method


Analyse Pressure Drawdown Tests using semilog analysis to extract k, skin, and investigation radius


Perform Horner Buildup Analysis including Horner plot and p* extraction


Interpret Pressure Derivative (Bourdet) plots on a log-log diagnostic for flow regime identification


Apply Type Curve Matching using the Gringarten-Bourdet overlay directly in Excel


Analyse Multi-Rate Tests using the superposition time function

About the Presenter

Dr. M. Prince with over 13 years of experience in academia and industry. He have a PhD in Engineering and Technology, an MBA in HR & IT, and an M.Tech in Petroleum Exploration. His research interests lie in Enhanced Oil Recovery (EOR) and have published 41 papers, 19 of which are in Scopus/WOS. He has also worked as an international instructor for engineering and management programs.

Register Now

By registering for this webcast, you are sharing your registration information with PEA and acknowledged that you have read and agreed to the Privacy Policy and Terms and Conditions. By submitting your personal information, you are agreeing that PEA may contact you via the details provided.

View More