An Interactive 5-Day Training Course
Nodal Analysis Using MS Excel
Building IPR and VLP Models
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
18 Oct 2027
Nodal Analysis Using MS Excel
Have Questions ?
Nodal Analysis Using MS Excel - PE-NA-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| PE-NA-EXCEL-PEA27 | 18 - 22 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.
Nodal Analysis Using MS Excel
Description
Nodal analysis is taught in most production engineering courses using commercial software, which leaves engineers able to run a program but not always able to say what it is doing. Building the same analysis in Excel removes that gap: every correlation, every iteration and every assumption is visible and testable.
Participants build the complete calculation chain during the course. It starts with PVT and fluid properties, then inflow performance for oil and gas wells, including skin and completion effects. It then builds vertical lift performance using both empirical correlations and a mechanistic approach, with pressure and temperature stepped along the tubing, followed by choke and flowline calculations. The workbook is then solved for the operating point, extended with sensitivity analysis on tubing size, wellhead pressure, skin, water cut and gas-liquid ratio, matched against field test data, and finally extended to run across multiple wells.
The operating point of a well is where the inflow and outflow curves cross. Getting there in a spreadsheet requires stepping pressure up the tubing through changing fluid properties, iterating until the calculation converges, and repeating for a range of rates. Doing that once makes the entire method concrete in a way that no amount of software use does.
Matching is where the value lies. A model that has not been matched to a measured flowing gradient or a well test predicts the assumptions in it. Participants match their models to real data during the course, see how much the choice of correlation changes the answer and learn which parameters are worth adjusting and which are not.
The finished workbook is a working tool. It can size tubing, predict the effect of a stimulation, show when a well will need lift and test whether a proposed change is worth doing, for any well in the participant's own field.
By the end of this training, participants will be able to:
- Build PVT and fluid property calculations for well performance work.
- Build inflow performance relationships for oil and gas wells, including skin.
- Build vertical lift performance using empirical correlations.
- Implement a mechanistic flow model for tubing performance.
- Step pressure and temperature along the tubing with iterative solution.
- Build choke and flowline calculations and apply surface constraints.
- Solve for the well operating point and identify unstable regions.
- Run sensitivity analysis on the main design variables.
- Match model results to gradient surveys and well test data.
- Extend the workbook to analyse multiple wells.
Organisations sending participants to this training will:
- Give engineers a well performance tool they fully understand.
- Improve the quality of tubing sizing and well performance decisions.
- Provide a means of checking results from commercial software.
- Standardise well performance methods across a team.
- Reduce licence dependence for routine well performance work.
Participants will:
- Understand nodal analysis from the equations up.
- Be able to build and match a complete well performance model.
- Be able to run and interpret sensitivity studies.
- Be able to diagnose underperforming wells with your own tool.
- Leave with a working nodal analysis workbook.
- Production engineers
- Well performance and optimisation engineers
- Production technologists
- Reservoir engineers working with well models
- Completion engineers
- Graduate engineers in production roles
Module 1: Workbook Design and Data
- Structure of a nodal analysis workbook
- Input data requirements
- Well geometry and deviation handling
- Unit control and validation
Module 2: PVT and Fluid Properties
- Black oil correlations
- Gas properties and z-factor
- Water properties and mixing
- Property calculation along the flow path
Module 3: Inflow Performance
- Productivity index and Vogel methods
- Composite and future IPR
- Gas well deliverability
- Skin and completion pressure losses
- Building and plotting IPR curves
Module 4: Multiphase Flow Fundamentals in the Model
- Flow variables and holdup
- Pressure gradient components
- Flow pattern considerations
- Fluid property updating along the tubing
Module 5: Vertical Lift Performance with Correlations
- Implementing empirical correlations
- Pressure stepping and iteration
- Temperature profile calculation
- Building VLP curves
Module 6: Mechanistic Tubing Model
- Flow pattern prediction
- Pattern-specific gradient calculation
- Comparison with correlation results
- Selecting a method
Module 7: Chokes, Flowlines and Surface Constraints
- Choke flow calculations
- Flowline pressure drop
- Separator pressure
- Moving the node to different points in the system
Module 8: Operating Point and Sensitivities
- Solving for the intersection
- Stable and unstable operating regions
- Sensitivity to tubing size, wellhead pressure and skin
- Sensitivity to water cut and gas-liquid ratio
- Data tables and charting
Module 9: Matching and Multi-Well Application
- Matching to gradient surveys
- Matching to well test data
- Adjusting parameters sensibly
- Extending the workbook to multiple wells
- Validating and documenting the finished tool
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.
