Well Test Data Analytics Using MS-Excel
Have Questions ?
Well Test Data Analytics Using MS-Excel -
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| 03 - 07 May 2027 | 10 AM CST | 4 Hours Per Day |
Online |
USD |
4000 |
Boost your team's skills and your budget! Enjoy group discounts for collaborative learning. Send an inquiry to info@peassociations.com.
Well Test Data Analytics Using MS- Excel
Description
Most operators now hold far more pressure and rate data than they interpret. Permanent downhole gauges record continuously for years, well test data accumulates across dozens or hundreds of wells, and production databases hold rate histories at daily or hourly resolution. What is missing is not data but the ability to process it: to clean it without destroying the transients, to reconstruct a rate history that matches the pressure record, to find the build-ups automatically, to compute derivatives consistently across every well, and to track how permeability, skin and drainage volume change over time.
This course covers that processing work in a spreadsheet environment. It addresses gauge data characteristics and failure modes, filtering and data reduction that preserves transient behaviour, rate history reconstruction and allocation issues, automated detection of shut-in periods and valid build-ups, superposition time computation for variable rate histories, derivative calculation with consistent smoothing across a dataset, diagnostic plot generation, screening interpretation for permeability, skin and boundaries, rate transient analysis applied to long-term production, comparison of results across wells and over time, and the construction of surveillance outputs that surface changes worth investigating. It complements detailed interpretation work rather than replacing it: the objective is to process everything and identify what deserves a full interpretation.
Demo Class
The economics of well testing have changed. A conventional interpretation takes an experienced engineer hours to days per test, which is affordable when a field produces a handful of tests a year. It is not affordable when permanent gauges generate a continuous record from every well and the asset holds fifty producers. The result in most organisations is that the data is stored and never examined, or examined only when a well has already failed and someone goes looking for a cause after the fact.
The practical answer is to separate screening from interpretation. Screening processes every well the same way: clean the data, reconstruct the rate history, find the shut-ins, compute the derivative, extract a permeability and skin estimate, and record the result. It does not need to produce a definitive interpretation. It needs to be consistent, repeatable and applied to everything, so that the values it produces can be compared between wells and tracked over time. A skin that has doubled over eighteen months is a finding regardless of whether the absolute value is exactly right.
This work is dominated by data handling rather than by reservoir physics. Gauges drift, fail and record through periods when the well was not doing what the production database says it was. Rate allocation is imperfect, and a pressure response cannot be interpreted against a rate history that is wrong. Filtering that reduces a year of one-second data to a manageable size can remove exactly the early-time behaviour the interpretation depends on. Getting these steps right is the difference between a screening workflow that surfaces real problems and one that generates noise. This course is built around that reality.
By the end of this training, participants will be able to:
- Assess permanent gauge and well test datasets for quality, drift, gaps and sensor failure
- Apply filtering and data reduction methods that preserve transient behaviour while making datasets manageable
- Reconstruct rate histories from production and allocation data and reconcile them with the pressure record
- Detect shut-in periods and valid build-ups automatically within a long pressure record
- Compute superposition time functions correctly for variable rate histories
- Calculate pressure derivatives consistently across many wells with controlled smoothing
- Generate diagnostic plots and extract screening estimates of permeability, skin and drainage volume
- Apply rate transient analysis methods to long-term production data across a well population
- Track changes in derived parameters over time and identify wells requiring detailed investigation
- Build repeatable surveillance workbooks that process new data as it arrives
The course is delivered as an applied data programme built around processing real gauge and production datasets. Each stage of the workflow is developed as a spreadsheet build, applied first to a single well and then extended across a population, so that participants see where a method that works on one dataset fails on fifty. Poor quality data is used deliberately, including records with gauge drift, missing rate history and undocumented well events, so that the handling of imperfect data is learned rather than assumed away. The relationship between screening output and full interpretation is addressed throughout.
- Organisations sending participants to this training will:
- Extract value from gauge and test data that is currently stored and never analysed
- Detect skin growth, productivity decline and connectivity changes before they become production losses
- Screen an entire well population consistently instead of interpreting a few wells thoroughly
- Prioritise intervention and detailed study effort on the wells that justify it
- Improve the quality and consistency of surveillance reporting
- Build repeatable workflows that survive staff turnover
Participants will:
- Handle large pressure and rate datasets confidently without corrupting them
- Build automated diagnostic and screening workflows rather than repeating manual analysis
- Recognise data quality problems that would invalidate an interpretation
- Track well performance parameters over time and spot meaningful change
- Produce surveillance output that engineers and managers act on
- Free time for the interpretation work that genuinely requires judgement
- Reservoir and production engineers responsible for well surveillance
- Well test engineers handling large volumes of transient data
- Production surveillance and data analysts in subsurface teams
- Petroleum engineers working with permanent downhole gauge installations
- Field development and asset engineers monitoring well performance
- Engineers inheriting large historical datasets that have never been processed
- Technical supervisors building surveillance workflows for an asset
Module 1 — Data Sources, Characteristics and Objectives
- Data sources: permanent gauges, memory gauges, well tests and production databases
- Sampling rates, resolution, accuracy and gauge specification
- What screening analysis can and cannot deliver
- Distinguishing screening from full interpretation
- Defining the surveillance questions the workflow must answer
- Data volume, storage and workbook performance considerations
- Workflow design for repeatable processing
Module 2 — Data Quality Assessment and Conditioning
- Gauge drift, calibration shift and failure signatures
- Identifying gaps, freezes, spikes and communication losses
- Time base alignment between pressure and rate records
- Depth reference, datum correction and gauge position
- Temperature effects on pressure measurement
- Assessing whether a dataset can support the intended analysis
- Documenting data quality limitations alongside results
Module 3 — Filtering, Compression and Data Reduction
- Why raw high frequency data must be reduced
- Filtering methods and their effect on transient content
- Logarithmic and adaptive sampling for transient preservation
- Wavelet and threshold-based compression concepts
- Verifying that reduction has not removed early-time behaviour
- Building a reduction step that runs consistently across wells
- Balancing dataset size against analytical fidelity
Module 4 — Rate History Reconstruction
- Rate data sources and their reliability
- Allocation methods and the errors they introduce
- Reconstructing rate history from well test and production records
- Identifying undocumented rate changes from the pressure response
- Handling commingled production and zonal rate uncertainty
- Effect of rate history error on derived permeability and skin
- Reconciling rate and pressure records before analysis
Module 5 — Automated Event and Build-Up Detection
- Identifying shut-in and flowing periods from the data
- Criteria for a build-up worth analysing: duration, stability and rate history
- Detecting well events, workovers and choke changes
- Segmenting a long record into analysable periods
- Flagging periods where analysis would be unreliable
- Building the detection logic to run without manual review
- Handling false positives and edge cases
Module 6 — Superposition and Time Function Computation
- Superposition principle applied to variable rate histories
- Superposition time calculation and its data requirements
- Equivalent time and its limitations
- Effect of truncating rate history on the time function
- Multi-rate sequences and complex production histories
- Implementing superposition efficiently across large datasets
- Verifying the time function against known solutions
Module 7 — Derivative Computation and Diagnostic Plots
- Derivative algorithms and their behaviour on noisy data
- Smoothing parameter selection and consistency across wells
- Effect of smoothing on flow regime visibility
- Automated log-log diagnostic plot generation
- Recognising flow regimes from screening output
- Distinguishing genuine features from processing artefacts
- Batch generation of diagnostic plots for a well population
Module 8 — Screening Interpretation and Parameter Extraction
- Automated radial flow identification and permeability estimation
- Skin extraction and its sensitivity to rate history quality
- Wellbore storage estimation from early time data
- Boundary and drainage volume indicators from late time behaviour
- Confidence flags on screening results
- Knowing when a screening result must be replaced by full interpretation
- Recording results in a structured well database
Module 9 — Rate Transient Analysis on Production Data
- Applying transient methods to routine production records
- Flowing material balance and drainage volume estimation
- Normalised rate and pressure methods
- Diagnostic decline plots and linear flow analysis
- Effective permeability and skin from production data alone
- Application to wells without dedicated test data
- Reconciling rate transient and build-up derived parameters
Module 10 — Surveillance Output, Trending and Reporting
- Tracking permeability, skin and productivity index over time
- Comparing parameters across a well population
- Identifying wells with deteriorating or anomalous behaviour
- Linking parameter change to well events and interventions
- Building surveillance dashboards and exception reports
- Prioritising intervention and detailed study candidates
- Automating the workflow to process new data as it arrives
- Documentation, version control and workflow handover
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.