This is drilling formula calculation sheet **v1.5** updated in July-2013. I add many essential drilling formulas in to one Excel spread sheet and I would like to share with you for **FREE**.

**Just simply sign up our mail list and the download link will be sent you directly once the email confirmation is completed.**

**The drilling formula calculation sheet will send you automatically via email when your sign up is confirmed !!! **

**How to use the drilling formula file**

When you open up the file, you will see the fist page call index page which shows you all of formulas like this.

You can click at each topic you like so as to see each formula. For example, let’s check one topic D-Exponent and D-Exponent Corrected.

You will see the screen like this. You add figures into **the yellow cells** and **the blue cells** are results. You are able to input the numbers into the yellow cells only.

You can go back to the index page by clicking cell named “Back to the first page”

If you are interested in background of the calculation, you can click the links shown at the right side.

I wish thedrilling formula calculation sheet would be advantageous for you. **I will keep update as much as possible.**

Please feel free to send or share with your friends. This is FREE Excel spread sheet so please do not sell it for any reason.

**Ref book: ** **Formulas and Calculations for Drilling, Production and Workover, Second Edition**

I have tried many times to use spread sheet and it don’t seem to be working, haven’t been able to enter any values etc. , is there an app? Or can you send me a link by mail?

You can enter values into the yellow cells but you cannot input anything into the blue cells because they are calculated values.

Hi

I dont know why this is not working in my Iphone.

This is Excel sheet. It works well with application which can run MS excel file. It won’t work by itself on the phone. It is designed for desktop computer mainly.

Regareds,

Shyne

Dear Sir，

I had subscribed already but I can’t download or get the spreadsheet. Would you please tell what should I do ?

Thank you very much！

Shiwei Yang,

Please check your mailbox.

Regards,

Shyne

I can’t download any information. Can u let me know how. What do I need to do? Thanks a lot.

Tim,

You need to subscribe to our mailing list. The system will send the file to you automatically.

Regards,

Shyne.

Can you please send me a copy of this spreadsheet? I can’t download any information,..Thanks

I am a subscriber but I can’t down load drilling formula spread sheet 1.5 how can I??? I alreadey check my e-mail and i dont have anything from drillingformulas.

Best regards

Please check your email. It will be delivered into your email.

Regards,

Shyne.

I would like the formula spread sheet

Please check your email. It will be delivered into your email.

Regards,

Shyne.

Yes i downloaded the drilling formulas spreadsheet, but ALL the formulas are locked and i cannot unlock them

pls provied me the formula in how to calculate hook speed under weight??

I am a sponge and trying to obtain as much knowledge as I can get.Thank you for this site it is good to know that there are people willing to share

Your stuff is cool. Thanks.

Hi –

I just downloaded your spread sheet. Thanks very much for providing this to the industry. I work in Drilling Integrity and Well Design. I noted that the kick tolerance calculation is not correct when calculating a swab kick. If you set up parameters to model a swab kick, it will have an output value. IF you increase the mudweight, the KT volume increases, which is incorrect. In reality, when you drill deeper or increase your mud density, the KT volume reduces. This is a very common problem with KT calculators. Most of them are wrong for modelling a swab kick. These are the inputs I used:

5,500

9,500

11.0 FP

–

12.0 MW

0.11

14.7

8.5

5.0

6.5

500.0

If you increase the MW from 12.0 to 13.0 the MAASP correctly reduces, but the actual volume increases.

If you want any help with this, please let me know.

Kind regards,

Randy

Thanks for comment. I will correct the spread sheet.

Dear ,

Thank you so much for your spread sheets!

BEST REGARDS

Hi,

I am already a subscriber. Is it possible for me to download this spread sheet?

Hakan

Hakan,

Please check your email. I sent it to you already.

This site is so profitable and educative, please keep up the good job.

Hi –

I just downloaded your spread sheet.

thanks for sharing these information. will you please send me a copy？I can not download the sheet.