Home » Downloads » Drilling Formulas Calculations Spreadsheet | Download

Drilling Formulas Calculations Spreadsheet | Download

Drilling Formulas Calculations are not difficult to perform and after downloading this free spreadsheet, you will find how easy they are. In this spreadsheet you will find that it is divided into many sections:

Applied Drilling Formulas Calculations Spreadsheet

formulas and calculations for drilling operations free download
pipe elongation
formulas and calculations for drilling operations free download

This section includes the following formulas:

Basic Drilling Formulas

Basic Drilling Formulas

In this Basic Drilling Formulas calculations you shall find the following:

  • BOP Accumulator Capacity
  • Amount of cuttings drilled per foot of hole drilled
  • Annular Volume Capacity Calculations
  • Annular Velocity (AV)
  • Buoyancy Factor (BF)
  • Buoyancy Factor (BF) with different fluid weight inside and outside
  • Convert Temperature Unit
  • Converting Pressure into Mud Weight
  • Coring Cost Per Footage Recovered
  • Depth of drill pipe 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) & Leak off Test
  • 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
  • Pressure Gradient
  • Slug Calculation
  • Specific Gravity (SG)
  • Total Bit Revolution in downhole drilling Mud Motor

Directional Drilling Calculation

Directional Drilling Calculation

Drilling Formulas website also didn’t forget to add the directional drilling calculations which contains the following:

Drilling Fluid Formulas

Mud calculations

We have gathered in our previous articles the drilling fluids calculations, we recommend to visit it first for more info. This free download spreadsheet section includes the following drilling formulas calculations:

  • 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 in drilling mud
  • 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
  • Solid Density From Retort Analysis

Engineering Formulas

  • Annular Pressure Loss
  • Critical RPM
  • Calculate Equivalent Circulating Density with Engineering Formula
  • Bottom Hole Pressure from Wellhead Pressure in a Dry Gas Well

Hydraulic Formulas

Hydraulics equations

Previously in our drilling hydraulics section, we have discussed all drilling hydraulics calculations and we also provided drilling hydraulics calculators to be used by drilling engineers. This section also include the following drilling formulas calculations:

  • Bit Nozzle Velocity
  • Bit Aggressiveness
  • Bit Hydraulic Horsepower
  • Bit Hydraulic Horsepower Per Area of Dril Bit (HSI)
  • Critical Flow Rate
  • Cross Flow Velocity Under a Drilling Bit
  • Cutting Carrying Index
  • Cutting Slip Velocity Method#1
  • Cutting Slip Velocity Method#2
  • Effective Viscosity
  • Hydraulic Horse Power (HPP)
  • Impact Force of Jet Nozzles on Bottom Hole
  • Mechanical Specific Energy
  • Minimum Flow Rate PDC bit
  • Optimum Flow Rate for basic system
  • Power Law Constant
  • Pressure Drop Across Bit
  • 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

Well Control Drilling Formulas Calculations

We recommend visiting our well control section first that have full explanation to drilling kicks, how to deal with them and the killing procedures ( driller methodWait & weight killing method)

  • Actual gas migration rate in a shut in well
  • Adjusted maximum allowable shut-in casing pressure for new mud weCalculate 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
  • 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

Free Download Formulas & Calculations For Drilling Operations

Thanks to drilling formulas team that prepared this spreadsheet