Sargent's Drilling Utilities - Free Drilling Software for the Man on the Rig

<body style="font-family: Comic Sans MS" bgcolor="#C0C0C0"> <p><font size="4"><b>Introduction</b></font></p> <p>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.</p> <p>If you are a Drilling Supervisor or a Well Site Drilling Engineer, you have, no doubt, made <i>several </i>spreadsheets over the years to calculate various tasks, such as casing cement jobs, hydraulics, balanced cement plugs, liner cementation, etc.</p> <p align="justify">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 recipes have the same same units as your program has, rendering your formulas for mixwater calculations useless.<br> <br> 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, 9-5/8" casing, 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... hardly...<br> <br> Nope, instead you cancel your planned - and long overdue - 33 minutes power nap, and instead grab a pen and a piece of paper....</p> <p align="justify">Well, been there - done that......!   Not good, need my nap!</p> <p align="justify">Consequently, I decided to make a program which would make ALL my calculations REGARDLESS OF <i>which </i> rig I was on, and who was the cementing contractor, etc, etc. And... "Sargent's Drilling Utilities" is it.</p> <p align="justify">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).<br> 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....<br> <br> 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 <a href="mailto:sargent@sargent.dk" style="color: black; text-decoration: none"> email me,</a> because this program is for YOU too....!<br> <br> 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 (Metric) version. And I <i>will</i>. But not until I start coding everything in pure Visual Basic.Net, and totally eliminate Microsoft Excel as the "base" for the program.<br> This will entail starting from scratch..... but the end product will, no doubt, be much better in all aspects and with faster execution.<br>  </p> <p align="justify">This next phase of the program will be named "Sargent's Drilling Utilities Pro". Expected release date: 2005-2006.<br>  </p> <p align="justify">SDU - drilling software / drilling fluid software for the man on the rig !</p> <p><b><font size="4" color="#FFFFFF"><u><a href="sdudescription.htm">Features</a></u>  </font><u> <font size="4" color="#0000FF"><a href="sduscreenshots.htm">Screen Shots</a></u>  <u> <a href="downloadarea.htm">Download</a></u></font></b></p> <p><b><font size="4" color="#000080">General</font></b></p> Pull-down menus for easy definition of the drill string and the casing scheme.<p>Editable tubular data base, for easy one-time addition of YOUR rig's particular tubular.</p> Editable cement chemical data base, for easy one-time addition of YOUR cement chemicals (presently: Halliburton, BJ and Dowell).<p>A pop-up "mini-Menu" window for easy navigation between the modules.</p> Integrated data sharing - Define pertinent well configuration data on one screen, and it will be used in most other modules as well.<p>Input check of user data entry - will warn you if you have entered invalid data.</p> Automated "Bug Report" generator, for easy reporting (by email) of any bugs to me.<p>Integrated Help File</p> <p> <b><font size="4" color="#000080">Specific Program Modules</font><font size="3" color="#000080"> </font> <font color="#000080" size="2">(brief description)</font></b></p> <p><b><font color="#FFFF00">Well Configuration Page</font><font color="#FF0000"><br> </font></b>    This is the "nerve centre" of the program. Here you define your drill string, the casing scheme, the hole size, hole depth and pump strokes,<br>     and you will get an instant calculation of Pump Pressure and all pertinent geometric well data (string volume, bottom's up, open hole annulus volume, etc).<br>     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<br>      annuli sections.<br>     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<br>      in orange.</p> <p><font color="#FFFF00"><b>Hydraulics Page<br> </b>    </font>drilling fluid software<font color="#FFFF00">.<br>    </font>The drill string and casing scheme data will automatically be transferred to this page from the Well Configuration page.<font color="#FFFF00"><br>     </font>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<br>      up to 50 different annuli sections. Based on mud rheology, flow rate, nozzle selection, etc.<font color="#FFFF00"><br>     </font>All formulas are taken from MI's Drilling Fluids Manual.<br>     (*) Select specific BHA components, such as  mud motor, MWD, LWD, Rotary Steerable Systems (PowerDrive) etc in various sizes, and the program will calculate<br>       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.</p> <p><b><font color="#FFFF00">Single String Cementation</font><br> </b>    Cement any string inside any previous casing size with any open hole size (yeah, yeah... must be physically possible, of course).<br>     Easy pull-down menu selection of previous and new casing strings.<br>     Easy pull-down menu selection of cementing contractor and additives. Add your own chemicals, and units, ONCE, and save in database.</p> <p><b><font color="#FFFF00">Balanced Cement Plug</font></b><font color="#FF0000"><b><br> </b>    </font>Define cement stinger, running string, casing scheme and cement chemical additives using pull-down menus.<br>     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.</p> <p><font color="#FFFF00"><b>Surveys page<br> </b>    </font>The program can store 5 surveys, each with up to 1000 survey stations. User Interface allows entering surveys, selecting various plots, and performing interpolation.<br>     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).</p> <p><b><font color="#FFFF00">Hole Cleaning Evaluation</font></b><font color="#FF0000">  </font> <font color="#FF0000" style="font-size: 9pt">New feature in Version 9.7.0</font><font color="#008000" style="font-size: 9pt"><br> </font> <font size="1" color="#FF0000">    </font>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,<br>    Cuttings Transport Ratio and the effective Cuttings Transport Velocity - for vertical holes as well as for inclined and HORIZONTAL well bores.<br>    This feature will be developed further in the near future to take into account the ROP, porosity, etc.</p> <p><font color="#FFFF00"><b>Pre-Recorded Well Date page<br> </b>    </font>The drill string and casing scheme data will automatically be transferred to this page from the Well Configuration page.<font color="#FFFF00"><br>     </font>This page gives you all the pertinent data required.</p> <p><b><font color="#FFFF00">Vertical Kill Sheet</font><font color="#FF0000"><br> </font></b>    This is for VERTICAL holes, as taught in Well Control schools.<br>     Enter kick data and shut-in pressures. Program will produce the "kill sheet" with step down charts and graphs. <br>     Print and bring to the floor (as a GUIDANCE ONLY !).</p> <p><b><font color="#FFFF00">Horizontal Kill Sheet</font></b></p> <p>   This is for HORIZONTAL holes, - and is not normally taught (in depth) in Well Control schools.<br>     This module uses the survey data from the "Active Survey Listing".<br>     Enter kick data and shut-in pressures. Select Kill Mud Weight. Program will produce the "kill sheet" with step down charts and graphs. <br>     Print and bring to the floor (as a GUIDANCE ONLY !).</p> <p><b><font color="#FFFF00">Horizontal Well Control Simulator</font><font color="#FF0000"><br> </font></b>    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.<br>     Based on constant-bottom-hole-pressure, and using a user-defined temperature profile, this module calculates <u>and plots</u> the following data, <br>     as the gas is being circulated out (first circulation) and as kill fluid is being circulated all around (second circulation):<br>     -    Influx position in annulus<br>     -    Influx height<br>     -    Influx volume<br>     -    Pit gain<br>     -    DPP and CP, as read on the choke panel (assuming constant bottom hole pressure is maintained)<br>     -    Pressure at casing shoe<br>     -    Shoe fracture pressure (which is constant, of course)<br>     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 operation.<font color="#FF0000">     </font></p> <p><b><font color="#FFFF00">Brine Calculations & Salt Tables</font><font color="#FF0000"><br> </font></b>    Ever needed to know how much salt is required to make xx bbls of x.xx ppg brine from seawater?<br>     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 ?<br>     Well... this module will tell you.  Presently includes: NaCl, CaCl2 and KCL.</p> <p><b><font color="#FFFF00">Detailed Annuli Data</font></b><font color="#FF0000"><b><br> </b>    </font>This is a pop-up window showing various calculated date for EACH separate annulus section, for the given Well Configuration:<br>         - Fluid velocity (ft/min)<br>         - Flow regime (Laminar or Turbulent)<br>         - Pressure loss (psi)<br>         - Length (ft)<br>         - Capacity (bbl/ft)<br>         - Slip Velocity (assuming vertical hole)<br>         - Cuttings Transport Ratio (assuming vertical hole)<br>         - Cuttings Transport Velocity (assuming vertical hole)</p> <p><b><font color="#FFFF00">Liner Cementation</font></b><font color="#FF0000"><b><br> </b>    </font>Under construction - not accessable yet.</p> <p><font color="#0000FF">The program has many more features.</font></p> <p><font color="#0000FF">Dansk Rig Supervisor Forening, DRSF</font></p> <p>Sargents Drilling utilities - free drilling software for the man on the rig !</p> <p>Sargent's Drilling utilities - free drilling software for the man on the rig !</p> <p>Sargents Drilling utilities - free drilling fluid software for the man on the rig !</p> <p> </p> <p> </p> <p> </p> <p>    </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p>This page uses frames, but your browser doesn't support them.</p> </body>