An Interactive 5-Day Training Course
Petroleum Geology Using MS Excel
Petroleum Geology Calculations in MS Excel
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
02 Aug 2027
Home Geology and Geoscience Petroleum Geology Using MS Excel
Petroleum Geology Using MS Excel
Have Questions ?
Petroleum Geology Using MS Excel - GG-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| GG-EXCEL-PEA27 | 02 - 06 Aug 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.
Petroleum Geology Using MS Excel
This training covers petroleum geology calculations built in MS Excel. It works through spreadsheet construction for technical work, well log calculations, net pay and cut-off application, volumetric calculation, pressure and fluid gradient analysis, correlation and cross section construction, decline and production analysis, data handling and charting and the auditing of technical spreadsheets.
Description
Most petroleum geology calculations are performed inside software packages that hide the arithmetic, and the result is a generation of geoscientists who can produce a number but cannot say how it was derived or what it is sensitive to. Building the same calculations in a spreadsheet, from the raw data upwards, makes the mechanics visible: the cut-offs applied, the averaging method used, the assumptions embedded and the parameters that drive the answer.
This training builds petroleum geology calculations from the ground up. Spreadsheet construction for technical work is established first, covering layout, naming, separation of inputs from calculation and the practices that make a sheet auditable. Well log calculations follow, covering the standard petrophysical computations performed cell by cell. Net pay and cut-off application are then developed, covering the mechanics and the sensitivity of the result to the cut-offs chosen. Volumetric calculation follows. Pressure and fluid gradient analysis are then addressed, covering contact determination and compartment identification from pressure data. Correlation and cross section construction follow. Decline and production analysis are then developed. Data handling and charting follow. The training closes with the auditing of technical spreadsheets.
Building the calculation reveals the sensitivity. A volumetric calculation performed in a spreadsheet, with each input in its own cell, allows the effect of each parameter to be seen immediately: changing the net to gross by five percentage points, moving the contact by ten metres, or altering the recovery factor shows directly how much each matters. The same calculation inside a modelling package produces a number with the sensitivities hidden, and most users have never tested them.
A spreadsheet with inputs scattered through the calculation cannot be audited. The single most important practice in technical spreadsheet work is separating inputs from logic: all the parameters, cut-offs, constants and assumptions in one clearly labelled block, and the calculation referring to them rather than containing them. A sheet built this way can be reviewed, reused for another well and changed safely. A sheet with the numbers typed into the formulas cannot, and such sheets are the source of a large share of technical errors.
Net pay is defined by the cut-offs and the cut-offs are a choice. Applying a porosity cut-off, a water saturation cut-off and a shale volume cut-off to a log and summing the surviving intervals gives net pay, and reasonable alternative cut-offs applied to the same log can change the answer by tens of per cent. Building this in a spreadsheet, with the cut-offs as inputs, makes the dependence visible and is the clearest way to understand why net pay definitions have to be agreed across a team.
Finally, spreadsheet errors are common, consequential and detectable. Studies of operational spreadsheets consistently find errors in a large majority of them: ranges that do not extend to the last row of data, copied formulas with mis-anchored references, numbers typed over formulas and units mixed within a column. These are all detectable by systematic checking, and any spreadsheet feeding a volume estimate or a technical decision deserves that check before its output is used.
By the end of this training, participants will be able to:
- Construct technical spreadsheets that are auditable and reusable
- Separate inputs from calculation logic
- Perform well log petrophysical calculations cell by cell
- Apply cut-offs and calculate net reservoir and net pay
- Assess the sensitivity of net pay to cut-off selection
- Build volumetric calculations with explicit inputs
- Analyse pressure data for gradients, contacts and compartments
- Construct correlation panels and cross sections
- Perform decline and production analysis
- Audit technical spreadsheets and detect common errors
The training is spreadsheet construction throughout, working on real well and field data. Participants build each calculation from the raw data and test its sensitivity to the inputs. Deliberately flawed spreadsheets are supplied for auditing. Results from participants' spreadsheets are compared against the software derived values for the same data to identify where differences arise.
Organisations sending participants to this training will:
- Build technical spreadsheets that can be audited and reused
- Understand the calculations their software performs
- Test the sensitivity of technical results to their inputs
- Agree net pay definitions on an informed basis
- Reduce spreadsheet errors in technical work
- Improve the technical competence of junior staff
Participants will:
- Build petroleum geology calculations from first principles
- Understand what the software is doing
- Test sensitivities directly
- Construct auditable spreadsheets
- Analyse pressure and production data
- Detect errors in technical spreadsheets
- Graduate and early career geoscientists
- Geologists wanting to understand their software
- Petrophysicists building calculations
- Reservoir engineers working with geological data
- Technical staff performing volume calculations
- Staff reviewing technical spreadsheets
- Geoscientists returning to technical work
Module 1 - Technical Spreadsheet Construction
- Layout for technical calculations
- Separating inputs, calculation and output
- Named ranges and their use
- Cell referencing and anchoring
- Absolute and relative references
- Documentation within the sheet
- Units and their labelling
- Data validation on inputs
- Conditional formatting for checking
- Protecting formula cells
- Version control of spreadsheets
- Templates for repeated work
Module 2 - Well Log Calculations
- Importing and formatting log data
- Depth indexing and alignment
- Shale volume from gamma ray
- Linear and non-linear shale volume methods
- Porosity from density
- Matrix and fluid density selection
- Neutron density porosity
- Shale corrections to porosity
- Resistivity and formation factor
- Archie saturation calculation
- Shaly sand saturation models
- Parameter sensitivity testing
Module 3 - Net Pay and Cut-Offs
- Net reservoir and net pay definitions
- Porosity cut-off application
- Saturation cut-off application
- Shale volume cut-off application
- Permeability based cut-offs
- Logical functions for cut-off flags
- Summing net intervals
- Net to gross calculation
- Zone by zone summaries
- Cut-off sensitivity analysis
- Deriving cut-offs from core data
- Documenting the net definition
Module 4 - Volumetric Calculation
- Volumetric equation and its terms
- Gross rock volume inputs
- Area and thickness relationships
- Net to gross application
- Porosity averaging methods
- Pore volume weighted averaging
- Saturation and hydrocarbon pore volume
- Formation volume factor application
- Oil and gas in place calculation
- Recovery factor application
- Unit conversions and their errors
- Sensitivity and tornado analysis
Module 5 - Pressure and Fluid Analysis
- Formation pressure data tabulation
- Pressure depth plotting
- Gradient calculation from pressure data
- Fluid density from gradients
- Fluid type identification
- Contact determination from gradient intersections
- Free water level calculation
- Pressure offsets between compartments
- Overpressure quantification
- Pressure in depleted reservoirs
- Buoyancy and column height calculation
- Seal capacity estimation
Module 6 - Correlation and Cross Sections
- Well data tabulation for correlation
- Marker depth tables
- True vertical depth conversion
- Deviation survey calculation
- Minimum curvature method
- Datum selection and flattening
- Thickness calculation between markers
- Isochore and isopach tabulation
- Cross section construction by chart
- Log display panels
- Structural and stratigraphic sections
- Annotation and presentation
Module 7 - Production and Decline Analysis
- Production data import and cleaning
- Rate and cumulative calculation
- Production plotting conventions
- Semi-log and log-log plots
- Exponential decline fitting
- Hyperbolic decline fitting
- Decline parameter determination
- Estimated ultimate recovery calculation
- Water cut and gas oil ratio trends
- Material balance calculation in outline
- Well comparison and normalisation
- Forecast construction
Module 8 - Data Handling, Charting and Auditing
- Lookup and reference functions
- Index and match techniques
- Pivot tables for data summaries
- Sorting and filtering large data sets
- Text functions for data cleaning
- Chart types for technical data
- Axis control and log scales
- Multiple series and secondary axes
- Common spreadsheet errors
- Range and reference error detection
- Auditing tools and formula tracing
- Review checklist for technical spreadsheets
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.
