Drilling Formulas Calculations Spreadsheet | Download

Table of Contents

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:

Directional Drilling Calculation

Directional Drilling Calculation

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

  • Directional Survey Calculation – 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 the Radius of Curvature Method
  • Dogleg Severity Calculation based on the Tangential Method

Drilling Fluid Formulas

Mud calculations

We have gathered the drilling fluids calculations in our previous articles; we recommend visiting them first for more information. This free download spreadsheet section includes the following drilling formulas calculations:

  • Bulk Density of Cuttings by using Mud Balance
  • Decrease oil-water ratio
  • Determine the oil-water ratio from a retort analysis
  • Determine the density of the 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 the 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

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 a full explanation of 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 to calculate Influx Height
  • Estimate gas migration rate with an empirical equation
  • Estimate the 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 the drilling formulas team that prepared this spreadsheet

Leave a Comment