An Interactive 5-Day Training Course
Well Control Kill Sheet Calculations Using MS Excel
Kill Sheets Built in Excel
Secure your spot now!
Duration
5 Days
Price
$ 2,000
Starting From
06 Mar 2027
Well Control Kill Sheet Calculations Using MS Excel
Have Questions ?
Well Control Kill Sheet Calculations Using MS Excel - DC-KILL-EXCEL-PEA27
| Code | Date | Time | Duration | Location | Currency | Early Bird Fee Per Person |
|---|---|---|---|---|---|---|
| DC-KILL-EXCEL-PEA27 | 06 - 10 Mar 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.
Well Control Kill Sheet Calculations Using MS Excel
This course
builds well control kill sheets and calculations in Microsoft Excel.
Participants build pressure and volume calculations, kill mud weight, pump
schedules and step-down charts, driller's and wait and weight methods, kick
tolerance and maximum allowable pressures, subsea and horizontal well sheets,
and verification checks, using live formulas with no macros, add-ins or coding.
Description
A kill sheet is the working document of a well control operation. Its pressures, volumes and pump schedule are calculated in advance and relied on while a kick is being circulated out, which is the worst possible moment to discover an arithmetic error or a wrong assumption.
This course builds those calculations in Excel. It starts with the pressure relationships behind well control: hydrostatic, formation and circulating pressures, and the slow circulating rate data the sheet depends on. It builds kill mud weight, initial and final circulating pressures, and the pump pressure schedule with the step-down chart. It builds the driller's method and the wait and weight method side by side so the differences are visible, then kick tolerance and maximum allowable annular surface pressure calculations. It adds sheets for subsea wells with choke line friction, deviated and horizontal wells, and tapered strings, and closes with verification checks, pre-recorded data sheets and the presentation of a kill sheet that can be used under pressure. All with live formulas and no macros, add-ins or coding.
The step-down chart is where sheets go wrong most often. The pressure must fall from the initial circulating pressure to the final circulating pressure as kill mud travels from surface to the bit, and the schedule must reflect the actual drillstring volume, including tapered sections and downhole tools. A sheet built on a nominal string volume will put the driller on the wrong pressure.
Horizontal and subsea wells break the simple assumptions. In a horizontal well, kill mud in the lateral adds no hydrostatic, so the pressure schedule is not a straight line against strokes. In a subsea well, choke line friction has to be accounted for. Both need their own sheets rather than adjustments to a vertical land sheet.
This is a calculation course, not a certification course. It builds the arithmetic and the understanding behind the kill sheet. It does not award IWCF, IADC or any other well control certification, and it is not a substitute for accredited well control training.
By the end of this training, participants will be able to:
- Build the pressure relationships that underpin kill sheet calculations.
- Record and use slow circulating rate data correctly.
- Calculate kill mud weight from shut-in pressures.
- Calculate initial and final circulating pressures.
- Build pump pressure schedules and step-down charts.
- Build driller's method and wait and weight method sheets and compare them.
- Calculate kick tolerance and maximum allowable annular surface pressure.
- Build kill sheets for subsea wells including choke line friction.
- Build kill sheets for deviated, horizontal and tapered string wells.
- Apply verification checks and present kill sheets for operational use.
The course is instructor-led and entirely hands-on in Microsoft Excel. Participants build each sheet from blank workbooks and test them against worked well control examples and real shut-in data. All work uses live formulas with no macros, add-ins or coding, and participants keep every workbook they build. The course teaches calculation and does not award well control certification.
Organisations sending participants to this training will:
- Give engineers and supervisors kill sheets they built and understand.
- Reduce calculation errors in well control preparation.
- Handle subsea, horizontal and tapered string cases correctly.
- Standardise kill sheet practice across rigs.
- Support, not replace, accredited well control training.
Participants will:
- Understand the pressure relationships behind kill sheets.
- Be able to build kill sheets for any well configuration.
- Be able to calculate kick tolerance and pressure limits.
- Be able to check a kill sheet for errors.
- Take away working kill sheet workbooks.
- Drilling engineers
- Rig site supervisors and company representatives
- Drillers and senior rig crew
- Well control instructors and trainers
- Service company technical staff
- Graduate engineers in drilling roles
Module 1: Pressure Relationships
- Hydrostatic and formation pressure
- Shut-in drillpipe and casing pressure
- Circulating pressure components
- Building the pressure basis sheet
- Units and conversions
Module 2: Slow Circulating Rate Data
- Why slow circulating rates are recorded
- Recording and updating the data
- Effect of mud weight changes
- Building the data sheet
- Using the data in the kill calculation
Module 3: Kill Mud Weight
- Kill mud weight calculation
- Margins and overbalance
- Volume of kill mud required
- Barite requirements
- Mixing calculations
Module 4: Circulating Pressures
- Initial circulating pressure
- Final circulating pressure
- Pressure components and their sources
- Building the calculation
- Checking against field data
Module 5: Pump Schedule and Step-Down
- Drillstring volume and strokes to bit
- Step-down pressure schedule
- Tapered strings and downhole tools
- Building the step-down chart
- Presenting it for use at the choke
Module 6: Driller's and Wait and Weight
- Driller's method sheet
- Wait and weight method sheet
- Pressure and volume differences
- Comparing casing pressures
- Choosing between methods
Module 7: Kick Tolerance and Limits
- Kick tolerance calculation
- Maximum allowable annular surface pressure
- Leak-off and formation strength data
- Pressure limits during the kill
- Building a limits sheet
Module 8: Subsea and Horizontal Wells
- Choke line friction correction
- Subsea kill sheet construction
- Horizontal well pressure schedules
- Hydrostatic in the lateral
- Deviated well considerations
Module 9: Verification and Presentation
- Checking the sheet for errors
- Pre-recorded data sheets
- Sensitivity to input errors
- Format for use under pressure
- Keeping sheets current on the rig
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.
