An Interactive 5-Day Training Course
Drilling Engineering Using MS Excel
Excel Workbooks for Drilling Calculations
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
07 Feb 2027
Drilling Engineering Using MS Excel
Have Questions ?
Drilling Engineering Using MS Excel - DC-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| DC-EXCEL-PEA27 | 07 - 11 Feb 2027 | 10 AM CST | 4 Hours / 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.
Drilling Engineering Using MS Excel
This course builds drilling engineering calculations in Microsoft Excel. Participants build workbooks for mud and hydraulics, buoyancy and string weight, trajectory and dogleg, casing loads, cement volumes, kill sheets, time and cost tracking and performance analysis, using live formulas with no macros, add-ins or coding.
Description
Most drilling engineering calculation happens in Excel, and most of it happens in spreadsheets that were inherited, are poorly laid out and cannot be checked. This course rebuilds the common drilling calculations as clean, documented workbooks that participants build themselves and take away for use.
The course works through the calculations a drilling engineer needs: mud weight, hydrostatic and circulating pressures, buoyancy and string weight, annular velocity and hole cleaning, trajectory and dogleg severity, casing loads and design factors, cement volumes and displacement, kill sheet calculations, and well time and cost tracking. Each is built step by step as a working sheet with inputs separated from calculations, units handled explicitly and results presented for checking. The course closes with performance analysis across wells, charting and the workbook construction practice that makes a spreadsheet auditable: documentation, validation, error trapping and protection. Everything is built with live formulas only, with no macros, no add-ins and no coding.
Spreadsheet errors are common and usually invisible. A unit mistake, a dragged formula that missed a row or a hard-coded number inside a formula produces results that look reasonable and are wrong, and the person who finds out is usually downstream. Building with inputs separated, units labelled and checks included is what prevents that.
Building the calculation teaches the engineering. An engineer who has built a kill sheet from the pressure relationships understands what each number means, which is different from filling in a form. The workbooks produced here are useful, but the understanding behind them is the main output.
Everything is built with live formulas. No macros, no add-ins and no coding, so the workbooks open and run on any computer with Excel, can be audited by anyone and will still work when the person who built them has moved on.
By the end of this training, participants will be able to:
- Build drilling calculation workbooks with separated inputs, calculations and outputs.
- Calculate mud weight, hydrostatic pressure and pressure gradients.
- Calculate buoyancy, string weight and hook load.
- Calculate annular velocity, pressure losses and hole cleaning indicators.
- Build trajectory and dogleg severity calculations from survey data.
- Build casing load and design factor checks.
- Calculate cement volumes, displacement and job parameters.
- Build a working kill sheet with pressure and volume calculations.
- Track well time and cost against plan.
- Apply charting, validation, error trapping and documentation practice.
The course is instructor-led and entirely hands-on. Participants build every workbook themselves in Microsoft Excel during the sessions, starting from blank sheets, with the instructor working through each calculation and checking results. All workbooks are built with live formulas only, with no macros, add-ins or coding, and participants keep everything they build.
Organisations sending participants to this training will:
- Replace inherited spreadsheets with workbooks that can be checked.
- Reduce calculation errors in routine drilling engineering work.
- Standardise calculations across the drilling team.
- Build capability without software licences or coding.
- Improve the auditability of engineering calculations.
Participants will:
- Be able to build drilling calculation workbooks from scratch.
- Understand the calculations rather than filling in a template.
- Be able to check and correct existing spreadsheets.
- Be able to present results clearly with charts.
- Take away a set of working drilling workbooks.
- Drilling engineers
- Rig site supervisors and company representatives
- Well planners
- Graduate engineers in drilling roles
- Service company technical staff
- Engineers who rely on inherited spreadsheets
Module 1: Workbook Foundations
- Structuring inputs, calculations and outputs
- Named ranges and references
- Unit handling and conversion sheets
- Formatting for readability
- Avoiding hard-coded values
Module 2: Mud and Pressure Calculations
- Mud weight and gradient conversions
- Hydrostatic pressure calculation
- Pressure at depth and at the shoe
- Equivalent mud weight
- Pressure window sheets
Module 3: Buoyancy and String Weight
- Buoyancy factor calculation
- String weight in air and in mud
- Hook load calculation
- Weight on bit and neutral point
- Overpull and tension checks
Module 4: Hydraulics and Hole Cleaning
- Annular velocity calculation
- Pressure loss components
- Equivalent circulating density
- Cuttings transport indicators
- Flow rate optimisation sheet
Module 5: Trajectory and Surveys
- Minimum curvature calculation
- Building a survey sheet
- Dogleg severity
- True vertical depth and displacement
- Trajectory plotting
Module 6: Casing Calculations
- Burst, collapse and tension loads
- Design factor calculation
- String weight and section selection
- Load case comparison sheets
- Results presentation
Module 7: Cementing Calculations
- Annular and casing volumes
- Slurry volume and excess
- Displacement volume and strokes
- Job timing
- Lift pressure checks
Module 8: Kill Sheet and Well Control
- Pressure and volume calculations
- Kill mud weight
- Initial and final circulating pressures
- Pressure schedule and step-down
- Building a usable kill sheet
Module 9: Time, Cost and Performance
- Time versus depth tracking
- Cost tracking against authorisation for expenditure
- Performance comparison across wells
- Charting results
- Validation, error trapping and workbook protection
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.
