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 drillingformulas@gmail.com
Please send it, thanks
You can download from the link.
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?
Sldos,
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?
Sldos,
Herman Garcia Blanco in July.
It is in our drillingformula spread sheet.
Excellent.Keep it up guys.this side is very good regarding formulas.Appriciated
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.
Regards
Noor Khan
Night pusher
I sent to your email already : )
I would like to learn more about well control.
Tanks your lessons about well control drilling formulas.i am very glad.tanks
Thenk you very much
Are the drilling formulas available in metric ?
Thanks
Ernie,
We don’t have it yet.
Regards,
Shyne
Please send me the Well control and related formula spread sheet by above E-mail, Because i am unable to down load.
Please read all material from the website because it has everything you need.
thanks it helped me alot
please send drilling related formullas& well control kill sheet. regards
TEG SINGH
Thanks, for give us an updated
Please send it, thanks
You can download from this link
Great stuff! Please send me a copy.
Hi could please send me the excel file drilling Well control and related formula spread sheet by following adress email
issoufou14@yahoo.com
Thanks in advance。