Drilling Formula Calculation Sheet

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: Drilling Formula Book Formulas and Calculations for Drilling, Production and Workover, Second Edition

103 Responses to Drilling Formula Calculation Sheet

  1. Joel cote says:

    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?

  2. omid says:

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

  3. Shiwei Yang says:

    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!

  4. Tim Chamberlain says:

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

  5. marvin manahan says:

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

  6. Rafael Castillo says:

    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

  7. Brandon Bramlage says:

    I would like the formula spread sheet

  8. ray grajeda says:

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

  9. mahmoud says:

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

  10. Joe says:

    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

  11. Muhammed Sian says:

    Your stuff is cool. Thanks.

  12. Randy says:

    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:
    11.0 FP

    12.0 MW
    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,

  13. Vinson Gong says:

    Dear ,
    Thank you so much for your spread sheets!


  14. Hakan Ozkara says:

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


  15. raymond says:

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

  16. MARYAM says:

    Hi –
    I just downloaded your spread sheet.

  17. Yubo Li says:

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

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.