An Interactive 5-Day Training Course
Casing Design Using MS Excel
Casing Design Built in Excel
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
14 Feb 2027
Casing Design Using MS Excel
Have Questions ?
Casing Design Using MS Excel - DC-CSD-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| DC-CSD-EXCEL-PEA27 | 14 - 18 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.
Casing Design Using MS Excel
This course builds casing design workbooks in Microsoft Excel. Participants build load case definitions, burst, collapse, tension and compression calculations, biaxial and triaxial checks, design envelope plots, string section selection, connection checks, wear and temperature derating, cost optimisation and design summary reporting, using live formulas with no macros, add-ins or coding.
Description
Casing design is normally done in software that produces a design factor table and a plot, and engineers rarely see how the numbers were produced. Building the design in Excel exposes every step, allows load cases to be examined one at a time and gives a tool for checking software output or designing strings where no licence is available.
This course builds a complete casing design workbook. It starts with load case definition and the pressure profiles behind each, then builds burst, collapse, tension and compression calculations with the relevant rating formulas. It adds biaxial and triaxial checks, design factor calculation and design envelope plotting. It then builds string section selection, mixed string optimisation, connection rating checks, wear and temperature derating, and the kick tolerance and pressure test cases that interact with the design. The course closes with cost optimisation across candidate designs and the design summary reporting that goes into the well programme. Everything uses live formulas with no macros, add-ins or coding.
Load cases are where designs fail. The rating formulas are standard and the calculation is arithmetic; the engineering is in deciding which load cases apply, what pressures and temperatures each assumes and whether anything the well will see has been missed. The workbook makes each case explicit and adjustable.
Collapse is the most involved calculation. Collapse rating depends on which of four regimes applies for the given diameter to thickness ratio and grade, and axial tension reduces it further. Building that properly, with the regime selection handled by formula, is one of the most useful things in the workbook.
Mixed string design is where the cost sits. Selecting the lightest grade and weight that passes every case in each section, while keeping the string practical to run and connect, is an optimisation that is easy to do badly. Doing it in a sheet that shows every design factor makes the trade-offs visible.
By the end of this training, participants will be able to:
- Define casing load cases and the pressure and temperature profiles behind them.
- Build burst rating and load calculations.
- Build collapse rating calculations across all regimes.
- Build tension and compression load calculations.
- Apply biaxial and triaxial checks.
- Calculate design factors and plot design envelopes.
- Select string sections and optimise mixed strings.
- Check connection ratings against combined loads.
- Apply wear and temperature derating.
- Compare candidate designs on cost and produce design summary reports.
The course is instructor-led and entirely hands-on in Microsoft Excel. Participants build the design workbook section by section, verifying each calculation against published tables and worked examples, then design complete strings for real wells. All work uses live formulas with no macros, add-ins or coding, and participants keep what they build.
Organisations sending participants to this training will:
- Give engineers the ability to check casing design software output.
- Design casing strings without specialist software licences.
- Make load case assumptions explicit and reviewable.
- Optimise string cost while meeting design factors.
- Improve the quality of casing design documentation.
Participants will:
- Understand casing design calculations from first principles.
- Be able to build a complete casing design workbook.
- Be able to select and optimise mixed strings.
- Be able to check connection and derating effects.
- Take away a working casing design tool.
- Drilling and well engineers
- Well planners and design engineers
- Completion engineers
- Tubular specialists
- Technical authorities reviewing casing designs
- Graduate engineers in well engineering
Module 1: Load Cases and Profiles
- Load case definition by string
- Pressure profile construction
- Temperature profiles
- Internal and external pressure assumptions
- Documenting the design basis
Module 2: Burst
- Burst rating calculation
- Internal pressure load cases
- Gas kick and tubing leak cases
- Design factor calculation
- Building the burst sheet
Module 3: Collapse
- Collapse regimes and selection
- Rating calculation for each regime
- External pressure load cases
- Evacuation and loss cases
- Building the collapse sheet
Module 4: Tension and Compression
- String weight and buoyancy
- Running and overpull loads
- Compression in deviated wells
- Bending loads in doglegs
- Building the axial sheet
Module 5: Combined Loading
- Biaxial effects on collapse and burst
- Triaxial stress calculation
- Von Mises checks
- Design envelope construction
- Plotting load points against the envelope
Module 6: String Selection
- Grade and weight selection
- Section length determination
- Mixed string construction
- Design factor summary across sections
- Practical running considerations
Module 7: Connections
- Connection rating data
- Tension, pressure and compression ratings
- Combined load checks
- Gas tight requirements
- Connection selection sheet
Module 8: Derating
- Temperature derating of yield strength
- Casing wear and wall loss
- Corrosion allowance
- Applying derating in the design
- Sensitivity to derating assumptions
Module 9: Optimisation and Reporting
- Comparing candidate designs
- Cost calculation per string
- Kick tolerance and pressure test checks
- Design summary tables
- Documentation for the well programme
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.
