Sargent's Drilling Utilities is a drilling software program that performs most of the
well-related calculations that the Man on the Rig needs in
his day-to-day work.
If you are a Drilling Supervisor or a Well Site Drilling Engineer, you have, no
doubt, made several spreadsheets over the years to calculate various
tasks, such as
casing cement jobs, hydraulics, balanced cement plugs, liner cementation, etc.
And then.... suddenly, your company changes Cementing Contractor, and....
here you are.... you can start all over, because none of the chemicals in the new
have the same same units as your program has, rendering your formulas for
mixwater calculations useless.
OR... you change rig, and now you find yourself using 4" DP, running
10-3/8" casing, drilling 8-3/4" hole using Duplex mud pumps, instead of the good ol' 5" DP,
8-1/2" hole and triplex pumps, which all your spreadsheets formulas are
based on...! Oh shit... What do you do then...? Call the Mud Loggers...? Hmmm...
Nope, instead you cancel your planned - and long overdue - 33 minutes power nap,
and instead grab a pen and a piece of paper....
Well, been there - done that......! Not good, need my nap!
Consequently, I decided to make a program which would make
ALL my calculations REGARDLESS OF which rig I was on, and who was the
cementing contractor, etc, etc.
And... "Sargent's Drilling Utilities" is it.
It is - in essence - just a Microsoft Excel file, which contains several
modules for the various calculations. Most of the code is written in VBA (Visual
Basic for Applications).
The program is under constant development, but has reached a stage where it is very
useful to me in my daily work, and it just may be to you too....
It is my ambitions with this program that ANY man on ANY rig can benefit from
using it - whether he is in 6000 ft of water on a hi-tech semi-sub, or on a
kelly rig with doubles in West-Texas...! So, if you have any comments, any bugs
to report or any suggestions for improvements, then
because this program is for YOU too....!
At the present time, the program uses OILFIELD UNITS only. I have
received several emails from users around the world asking if I could make an SI
And I will. But not until I start coding everything in pure
Visual Basic.Net, and totally eliminate Microsoft Excel as the "base" for the
This will entail starting from scratch..... but the end product will, no doubt,
be much better in all aspects and with faster execution.
This next phase of the program will be named "Sargent's Drilling Utilities Pro".
Expected release date: 2005-2006.
SDU - drilling software / drilling fluid software for the man on the rig !
Pull-down menus for easy definition of the drill string and
the casing scheme.
Editable tubular data base, for easy one-time addition of
YOUR rig's particular tubular.
Editable cement chemical data base, for easy one-time
addition of YOUR cement chemicals (presently: Halliburton, BJ
A pop-up "mini-Menu" window for easy navigation between the
Integrated data sharing - Define pertinent well
configuration data on one screen, and it will be used in most
other modules as well.
Input check of user data entry - will warn you if you have
entered invalid data.
Automated "Bug Report" generator, for easy reporting (by
email) of any bugs to me.
Integrated Help File
Specific Program Modules
Well Configuration Page
This is the "nerve centre" of the program. Here you define
your drill string, the casing scheme, the hole size, hole depth and pump
and you will get an instant calculation of Pump Pressure and
all pertinent geometric well data (string volume, bottom's up, open hole annulus
This page also has graphical presentation of a) the System
Pressure Loss down thru the drill string and up thru the annulus, b) fluid
velocities in all string components and
The page also has a feature to graphically present the well
trajectory, as defined in the "Active Survey Listing". The BHA components are
coloured in on the trajectory
drilling fluid software.
The drill string and casing scheme data will
automatically be transferred to this page from the Well Configuration page.
Calculates pressure losses throughout the entire well
system, i.e. in each drill string component, through BHA
components (*), through the bit and up through each of potentially
50 different annuli sections. Based on mud rheology, flow rate,
nozzle selection, etc.
All formulas are taken from MI's Drilling Fluids Manual.
(*) Select specific BHA components, such as mud motor,
MWD, LWD, Rotary Steerable Systems (PowerDrive) etc in various sizes, and the
program will calculate
the actual pressure drop over each component
using the Directional Drilling Contractor's formular. So far only one DD
contractor's formulars have been coded.
Single String Cementation
Cement any string inside any previous casing
size with any open hole size (yeah, yeah... must be physically possible, of
Easy pull-down menu selection of previous and new casing
Easy pull-down menu selection of cementing contractor and
additives. Add your own chemicals, and units, ONCE, and save in
Balanced Cement Plug
Define cement stinger, running string, casing scheme and
cement chemical additives using pull-down menus.
Type in a few pertinent well data (hole data, plug length,
top of plug, %excess, water
ahead, under-displacement, etc), and the entire job will be calculated.
The program can store 5 surveys, each with up to 1000
survey stations. User Interface allows entering surveys, selecting various
plots, and performing interpolation.
The current "Active Survey Listing" will be used in other
modules, when applicable (i.e. in Hole Cleaning module, Horizontal Kill Sheet,
Horizontal Well Control Simulator).
Hole Cleaning Evaluation
New feature in Version 9.7.0
This is a new feature. Not bug tested, and not fully developed
yet. However, presently, it will calculate - based on the Preston Moore
Correlation - Slip velocity,
Cuttings Transport Ratio and the effective
Cuttings Transport Velocity - for vertical holes as well as for
inclined and HORIZONTAL well bores.
This feature will be developed further in the near future
to take into account the ROP, porosity, etc.
Pre-Recorded Well Date page
The drill string and casing scheme
data will automatically be transferred to this page from the Well Configuration
This page gives you all the pertinent data required.
Vertical Kill Sheet
This is for VERTICAL holes, as taught in Well Control
Enter kick data and shut-in pressures. Program will produce
the "kill sheet" with step down charts and graphs.
Print and bring to the floor (as a GUIDANCE ONLY !).
Horizontal Kill Sheet
This is for HORIZONTAL holes, - and is not normally taught (in
depth) in Well Control schools.
This module uses the survey data from the "Active Survey
Enter kick data and shut-in pressures. Select Kill Mud
Weight. Program will produce the "kill sheet" with step down charts and graphs.
Print and bring to the floor (as a GUIDANCE ONLY !).
Horizontal Well Control Simulator
Simulates circulating out a gas influx using the
Drillers Method, from the depth of the bit, in a wellbore with any given
trajectory - vertical, deviated or horizontal.
Based on constant-bottom-hole-pressure, and using a
user-defined temperature profile, this module calculates and plots the
as the gas is being circulated out (first circulation) and as
kill fluid is being circulated all around (second circulation):
- Influx position in annulus
- Influx height
- Influx volume
- Pit gain
- DPP and CP, as read on the choke panel
(assuming constant bottom hole pressure is maintained)
- Pressure at casing shoe
- Shoe fracture pressure (which is
constant, of course)
Print out the graphs and bring to the rig floor, along with
your Kill Sheet, for use as GUIDELINES (only) during the actual well killing
Brine Calculations & Salt Tables
Ever needed to know how much salt is required to make
xx bbls of x.xx ppg brine from seawater?
Ever needed to know how much x.xx ppg brine should be mixed
with XX bbls y.yy ppg brine to produce YY bbls of z.zz ppg brine ?
Well... this module will tell you. Presently includes:
NaCl, CaCl2 and KCL.
Detailed Annuli Data
This is a pop-up window showing various calculated
date for EACH separate annulus section, for the given Well Configuration:
- Fluid velocity (ft/min)
- Flow regime (Laminar or Turbulent)
- Pressure loss (psi)
- Length (ft)
- Capacity (bbl/ft)
- Slip Velocity (assuming vertical
- Cuttings Transport Ratio (assuming
- Cuttings Transport Velocity
(assuming vertical hole)
Under construction - not accessable yet.
The program has many more features.
Dansk Rig Supervisor Forening, DRSF
Sargents Drilling utilities - free drilling software for the man on the rig !
Sargent's Drilling utilities - free drilling software for the man on the rig
Sargents Drilling utilities - free drilling fluid software for the man on the
This page uses frames, but your browser doesn't support them.