An Interactive 5-Day Training Course
Production Engineering Using MS Excel
Building Production Calculations in Excel
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
04 Oct 2027
Production Engineering Using MS Excel
Have Questions ?
Production Engineering Using MS Excel - PE-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| PE-EXCEL-PEA27 | 04 - 08 Oct 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.
Production Engineering Using MS Excel
Description
Excel remains the tool most production engineers actually use. It is available everywhere, it shows every step of a calculation, and a workbook built by the engineer who uses it is understood in a way that commercial software rarely is. The difficulty is that most engineering spreadsheets are built badly: undocumented, unvalidated, full of hard-coded constants and impossible to check.
This course teaches both the engineering and the spreadsheet craft. Participants build, step by step, a set of production engineering workbooks: fluid property and PVT calculations, inflow performance for oil and gas wells, pressure traverse calculations, choke and flowline models, well performance and simple nodal analysis, decline curve analysis and material balance. Alongside this, the course covers spreadsheet structure, named ranges, data validation, iterative solution and Solver, unit handling, charting, error trapping and documentation, so the workbooks are auditable and reusable.
A production engineer who can build a calculation in Excel can check any number that arrives from anywhere else. That is the underlying value: not that Excel is better than dedicated software, but that building the calculation forces an understanding of what is inside it, and gives a way to test whether a commercial result is credible.
Spreadsheet quality matters because these files get shared and reused for years. A workbook with constants buried in formulas, no unit labels, no validation of inputs and no indication of which cells are inputs and which are results will eventually produce a wrong answer that somebody acts on. Good structure costs a little time to build and prevents that.
The workbooks built during this course cover the calculations production engineers use most often. Participants finish with working tools rather than notes, and with the skill to extend them. Nothing is provided as a locked black box; every formula is built and tested in the room.
By the end of this training, participants will be able to:
- Structure engineering spreadsheets for clarity, auditability and reuse.
- Build fluid property and PVT correlation calculations.
- Build inflow performance relationships for oil and gas wells.
- Build pressure traverse calculations for single-phase and multiphase flow.
- Build choke and flowline pressure drop calculations.
- Combine inflow and outflow to find well operating points.
- Build decline curve analysis and forecasting workbooks.
- Build simple material balance calculations.
- Apply iterative solution, Solver and goal seek to engineering problems.
- Apply validation, error trapping, unit control and documentation to engineering workbooks.
Organisations sending participants to this training will:
- Give engineers reliable calculation tools they understand and can check.
- Reduce dependence on undocumented legacy spreadsheets.
- Improve the quality and auditability of engineering calculations.
- Provide a way to verify results from commercial software.
- Standardise calculation methods across a team.
Participants will:
- Be able to build production engineering calculations from first principles.
- Be able to structure spreadsheets that others can audit and reuse.
- Understand the equations behind standard production calculations.
- Be able to check and challenge results from other sources.
- Leave with a working set of calculation workbooks.
- Production engineers
- Production technologists
- Reservoir engineers
- Well surveillance and operations engineers
- Graduate engineers in production roles
- Engineers moving into production engineering
Module 1: Engineering Spreadsheet Design
- Input, calculation and output separation
- Named ranges and cell referencing
- Data validation and input control
- Unit handling and conversion
- Error trapping and diagnostics
- Documentation and version control
Module 2: Fluid Properties and PVT
- Oil property correlations
- Gas property and z-factor calculation
- Water properties
- Bubble point and solution gas calculations
- Building a reusable PVT sheet
Module 3: Oil Well Inflow Performance
- Productivity index calculations
- Vogel and composite IPR
- Horizontal well inflow
- Future IPR prediction
- Plotting IPR curves
Module 4: Gas Well Inflow Performance
- Back-pressure equation
- Non-Darcy flow and the Jones approach
- Pseudo-pressure calculation
- Absolute open flow potential
Module 5: Pressure Traverse Calculations
- Single-phase flow pressure drop
- Multiphase flow correlations
- Iterative pressure and temperature stepping
- Building a traverse calculation sheet
- Plotting gradient curves
Module 6: Chokes and Flowlines
- Critical and subcritical choke flow
- Choke sizing calculations
- Flowline pressure drop
- Separator pressure effects
Module 7: Well Performance
- Combining inflow and outflow
- Solving for the operating point
- Sensitivity tables and data tables
- Charting well performance
Module 8: Decline Analysis and Forecasting
- Arps decline curve fitting
- Regression and curve fitting in Excel
- Forecast generation
- Reserves and cumulative production calculations
Module 9: Material Balance and Solution Techniques
- Simple oil and gas material balance
- p/z analysis
- Goal seek, Solver and iterative calculation
- Circular references and convergence
- Testing and validating a finished workbook
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.
