Free Useful Well Control Spread Sheet – All Important Well Control Formulas For Oilfield Personnel

There are a lot of people who are interested in well control and we would like to help them learn and make their life easier by sharing the well control spread sheet. The image (Figure 1) below is the screen shot of the spread sheet.

well control spread sheet capture

Figure 1 – Well Control Formula Screen Shot

 In this file, there are several formulas covering from basic formulas to well control related ones. There are a total of 47 formulas listed below;

• Annular Capacity

• Annular Velocity (AV)

• Converting Pressure into Mud Weight

• Displacement of plain pipe such as casing, tubing, etc.

• How many feet of drill pipe pulled to lose certain amount of hydrostatic pressure (psi)

• Hydrostatic Pressure (HP) Calculation

• Hydrostatic Pressure (HP) Decrease When POOH

• Inner Capacity of open hole, inside cylindrical objects

• Pressure Gradient

• Slug Calculation

• Specific Gravity (SG)

• Pump out (both duplex and triplex pump)

• Pump Pressure and Pump Stroke Relationship

• Formation Integrity Test (FIT)

• Leak Off Test (LOT)

• Increase mud weight by adding Barite

• Increase mud weight by adding Calcium Carbonate

• Increase mud weight by adding Hematite

• Equivalent Circulating Density (ECD)

• Equivalent Circulating Density (ECD) Using Yield Point for MW less than or equal to 13 ppg

• Equivalent Circulating Density (ECD) Using Yield Point for MW more than 13 ppg

• Calculate Equivalent Circulating Density with Engineering Formula

• Surge and Swab Pressure Method#1

• Surge and Swab Pressure Method#2

• Accumulator capacity

• Actual gas migration rate in a shut in well

• Adjusted maximum allowable shut-in casing pressure for new mud weight

• Calculate Influx Height

• Estimate gas migration rate with an empirical equation

• Estimate type of influx

• Final Circulating Pressure (FCP)

• Formation pressure from kick analysis

• Hydrostatic Pressure Loss Due to Gas Cut Mud

• Initial Circulating Pressure (ICP)

• Kick Tolerance (Surface Stack and Vertical Well)

• Kick tolerance factor (KTF)

• Kill Weight Mud (KWM)

• Maximum formation pressure (FP)

• Maximum influx height

• Maximum Initial Shut-In Casing Pressure (MISICP)

• Maximum pit gain from gas kick in water based mud

• Maximum Surface Pressure from Gas Influx in Water Based Mud

• Maximum surface pressure from kick tolerance information

• New Pressure Loss With New Mud (psi)

• New Pump Pressure With New Strokes (psi)

• Riser Margin

• Trip margin

Download Well Control Formula

Please check the download link below to get the file for FREE.

If you think this file is useful for your friends, please feel free to share with them. Additionally, if you want some equations to be added into the spread sheet, please send us some feedback to


5 Responses to Free Useful Well Control Spread Sheet – All Important Well Control Formulas For Oilfield Personnel

  1. khalil says:

    great help sir. thank u

  2. Mohammad Javad says:

    thank you.

  3. Ciro Barboza says:


  4. Aung Myint Thein says:

    Thank a lot for all drilling personal

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.