Free Useful Well Control Spreadsheet – 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.

Version 1.3 updated on 28-Jan-19.

In this version (1.3), the spreadsheet is updated into .xlxs file which is the newest Excel Version. Moreover, all formulas are unlocked so you can modify to suit for you needs too.

Figure 1 – Well Control Formula V1.3 Screenshot

 In this file, there are several formulas covering from basic formulas to well control related ones.

There are a total of 52 well control 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
  • Bottle Capacity Required in Accumulator
  • 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
  • Increase in Casing Pressure due to Kick Penetration
  • Initial Circulating Pressure (ICP)
  • Kick tolerance factor (KTF)
  • Kill Weight Mud (KWM)
  • Lube Increment
  • 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
  • Mud Increment
  • New Pressure Loss With New Mud (psi)
  • New Pump Pressure With New Strokes (psi)
  • Riser Margin
  • Time To Penetrate Kick
  • Trip margin

Download Well Control Formula

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

Well Control Formula Spreadsheet

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

Tagged , . Bookmark the permalink.

About DrillingFormulas.Com

Working in the oil field and loving to share knowledge.

21 Responses to Free Useful Well Control Spreadsheet – All Important Well Control Formulas For Oilfield Personnel

  1. Yoo says:

    Please send it, thanks

  2. Julio Blanco Garcia says:

    Buenas noches, los saludo cordialmente.

    Dentro de sus amabilidades, fuera usted tan amable de indicarnos el calculo hidráulico de las barrenas?, o cual seria según cálculos el flujo de lodo para que su efectividad de perforar sea el optimo?


    Julio Herman Blanco García.

    == Translate ==
    Good evening, I greet you cordially.

    Within their kindnesses you kindly indicate the hydraulic calculation bits out?, Or calculations which would flow according to their effectiveness mud drilling is optimal?


    Herman Garcia Blanco in July.

  3. Ahmed Ali says:

    Excellent.Keep it up guys.this side is very good regarding formulas.Appriciated

  4. Noor Farosh Khan says:

    Please send me the Well control and related formula spread sheet by the E-mail, Because i am unable to down load due to the user name and employer password, I don,t know the user name and pass word in computer.


    Noor Khan

    Night pusher

  5. nawai says:

    I would like to learn more about well control.

  6. mujuono says:

    Tanks your lessons about well control drilling formulas.i am very glad.tanks

  7. adel says:

    Thenk you very much

  8. Ernie Postowski says:

    Are the drilling formulas available in metric ?

  9. wahab khan says:

    Please send me the Well control and related formula spread sheet by above E-mail, Because i am unable to down load.

  10. junaid says:

    thanks it helped me alot

  11. tegsingh says:

    please send drilling related formullas& well control kill sheet. regards

  12. rachmad says:

    Thanks, for give us an updated

  13. Dendougui Salim says:

    Please send it, thanks

  14. Micbael Zurcher says:

    Great stuff! Please send me a copy.

  15. Issoufou Namane Kondo says:

    Hi could please send me the excel file drilling Well control and related formula spread sheet by following adress email
    Thanks in advance。

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.