This is the updated version of drilling formulas (Figure 1 – Drilling Formula Spread Sheet V1.5). In this version, we’ve added several equations and fixed some errors.

Figure 1 – Drillingformulas Spread Sheet Version 1.5

Moreover, we have modified new interface so it will be easier to navigate. In this version, there are a total of 99 equations from these topics as applied drilling, basic formula, directional drilling, drilling fluid, drilling engineering, hydraulics, and well control.

The equations are listed below;

• Drill Collar Weight

• 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

• Lag time

• Light weight spot fill to balance formation pressure

• Loss of hydrostatic pressure due to filling water into annulus in case of lost return

• Margine of Overpull

• Pipe Elongation Due to Temperature

• Pressure required to break circulation

• Pump out (both duplex and triplex pump)

• Pump Pressure and Pump Stroke Relationship

• Stuck Pipe Calculation

• Ton Miles Calculation

• Accumulator capacity

• Amount of cuttings drilled per foot of hole drilled

• Annular Capacity

• Annular Velocity (AV)

• Buoyancy Factor (BF)

• Convert Temperature Unit

• Converting Pressure into Mud Weight

• Depth of washout

• D-Exponent and D-Exponent Corrected

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

• Drilling Cost Per Foot

• Equivalent Circulating Density (ECD)

• Formation Integrity Test (FIT)

• Formation Temperature

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

• Hydrostatic Pressure (HP)

• Hydrostatic Pressure (HP) Decrease When POOH

• Inner Capacity of open hole, inside cylindrical objects

• Leak Off Test (LOT)

• Pressure and Force

• Slug Calculation

• Specific Gravity (SG)

• Total Bit Revolution in Mud Motor

• Directional Survey – Angle Averaging Method

• Directional Survey – Radius of Curvature Method

• Directional Survey – Balanced Tangential Method

• Directional Survey – Minimum Curvature Method

• Directional Survey – Tangential Method

• Dogleg Severity Calculation based on Radius of Curvature Method

• Dogleg Severity Calculation based on Tangential Method

• Bulk Density of Cuttings by using Mud Balance

• Decrease oil water ratio

• Determine oil water ratio from a retort analysis

• Determine the density of oil/water mixture

• Dilution to control LGS

• Increase mud weight by adding Barite

• Increase mud weight by adding Calcium Carbonate

• Increase mud weight by adding Hematite

• Increase oil water ratio

• Mixing Fluids of Different Densities with Pit Space Limitation

• Mixing Fluids of Different Densities without Pit Space Limitation

• Plastic Viscosity (PV) and Yield Point (YP) from mud test

• Reduce mud weight by dilution

• Annular Pressure Loss

• Critical RPM

• Calculate Equivalent Circulating Density with Engineering Formula

• Critical Flow Rate

• Cutting Carrying Index

• Cutting Slip Velocity Method#1

• Cutting Slip Velocity Method#2

• Effective Viscosity

• Hydraulic Horse Power (HPP)

• Optimum Flow Rate for basic system

• Power Law Constant

• Pressure Loss Annulus

• Pressure Loss Annulus With Tool Joint Correction

• Pressure Loss Drillstring

• Pressure Loss Drillstring With Tool Joint Correction

• Pressure Loss in Surface Equipment

• Reynold Number

• Surge and Swab Pressure Method#1

• Surge and Swab Pressure Method#2

• Total Flow Area Table

• 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

• Formation pressure from kick analysis

• Hydrostatic Pressure Loss Due to Gas Cut Mud

• Kick Tolerance (Surface Stack and Vertical Well)

• Kick tolerance factor (KTF)

• Kill Weight Mud

• 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

• Trip margin

• Initial Circulating Pressure (ICP)

• Final Circulating Pressure (FCP)

• New Pump Pressure With New Strokes (psi)

• New Pressure Loss With New Mud (psi)

• Riser Margin

We wish you would enjoy our drillingformulas spreadsheet and feel free to share with your friends too. If you have any ideas/suggestions, please feel free to send us email to drillingformulas@gmail.com. We will use your valuable information to improve our spreadsheet.

Related Post

Trip Sheet Excel File Monitoring the well while tripping is one of the most critical in well control because it will tell you about the well condition very quickly. Therefo...
Drilling formula spread update will be distributed... I just have time and I will add some drilling formulas in the drilling formulas spread sheet. It will be version 1.1. I will distribute this shee...
Free Drilling Formulas Spread Sheet Will be Launch... I said about drilling formula software few weeks ago but my friend and I had limited time to write software. Therefore, we decide that we will give dr...
Drilling Formula Excel Sheet Version 1.3 Version 2... Today, we would like to distribute the new update drilling formula version 1.3. It is still totally FREE !!!. What new drilling formulas are...
Share the joy
• 52
•
•
•
•
•
•
•
•
52
Shares

Working in the oil field and loving to share knowledge.

16 Responses to Drilling Formula Spread Sheet V1.5

1. zafar says:

Thanks for valuable and useful updated Spread sheet of Drilling Formula Spread Sheet V1.5.

Sir, can you develop and share Casing Design Spread Sheet, this will be very useful for every one.
thanks & regard

• Zarfar,

Thanks for comment. I will try to do casing design spread sheet later.

2. JOSE M FRIAS RAMON says:

Excelent idea

3. Ramel says:

Good Day! I’m Ramel graduate in mechanical engineering And also a registered Mechanical Engineer. I have experience in oil and gas in piping. I want to work in drilling industry. how to apply and how to get a job in oil and gas. please advise. thank you.

Ramel

• Ramel,

You may need to search for the job in your country and you can find the job posting on the internet as well. I need to go into details later on this one.

Regards,
Shyne

4. Jan says:

When will be available version in SI units?

5. eric says:

awesome
btw sir, can we get the formula as well?
I mean, not just the data that is entered and the results of the calculation, but the formula also included (the calculation / explanation).
thanks

• Hi Eric,

Each formula will have the link to the reference article that you can go to.

Regards,
Shyne

6. YOGO MABIKA says:

Hi Eric,

I am very happy on getting news and knowledge about Drilling instructions online trough this website

Regards

yogo

7. Nabil says:

Dears
I missed it version 1.5
can you please e-mail it to me

• Nabil,

Regards,
Shyne.

8. Edgar Nova says:

Dear Sir;
I will appreciate if can furnish me with the Drilling Formula Excel Sheet Version 1-5.
Your assistance is very important for me due to fact that I am working daily with this programs, It is a great help to be updated with your technical assistance with your Drilling Formulas papers.
Best regards
Edgar Nova

9. Uzochukwu Akalaha says:

I need the spreadsheet ASAP, kindly assist