Part I – Getting Started
Hello and welcome to the first in a series of training videos about using KellyDown. In this video, I’m going to show you how to start KellyDown and then describe many of the features of the KellyDown user interface.
Double click on the KellyDown icon on your Windows desktop to start KellyDown. If this is the first time you have run KellyDown on this computer, you will be presented with a message informing you that you do not have a KellyDown license. KellyDown will continue to run in limited evaluation mode for seven days without a license. The limited evaluation mode allows you to perform all the functions of KellyDown on the example database except create new proposals and surveys. Follow the instructions shown on the screen to apply for a fully functional evaluation license, or the permanent license if you have already purchased one.
Next, KellyDown will prompt you to enter a password for the example database. Many customers insist that their data is protected using a password, but if you prefer not to have to enter a password every time you start KellyDown, you can switch this option off. Enter a password hint to remind you of the password and click on the Continue button to open the Example database.
You are reminded that the example database has not been backed up recently. Click on the OK button to continue opening the database.
Main Screen
The KellyDown screen comprises several main components.
The Menu Bar contains drop-down menus that provide access to all of the modules and functions in KellyDown. The order of the menus in KellyDown is always File, Edit, View, Insert etc. The top level menus always contain familiar items, for example, the File menu always contains the Open, Save and Exit items.
The Toolbar is immediately below the menu bar and provides shortcuts to functions that you use most often. For example, if you routinely view survey reports, instead of selecting View, Report, Survey from the menu bar, simply click on the Survey Report button on the toolbar. Hover the mouse over a button to see its function in a tooltip.
The toolbar on the main KellyDown screen is configurable so you can change the buttons that are displayed depending on the functions you use most often. Simply right-click on any of the buttons and select or unselect the buttons you want to be shown on the toolbar.
Immediately below the toolbar is the Reference Bar which consists of five buttons, each one representing a level in the hierarchy from the current proposal or survey back up to the folder level. You may click on any one of these buttons to select that level. The corresponding node is highlighted in the Database Explorer.
Right-click on a button to display a pop-up menu from which you may select one of the menu items associated with that particular level. For example, right-click on the Structure button to edit the structure properties, add a new well or delete the structure.
As you work in different parts of the application, the menus and toolbars continually update so they always relate to the task at hand.
Because you are able to work on several modules at one time in KellyDown, the menus and toolbar buttons change as you switch between each one. We call this effect switching focus from one module to another. For example, we can work on survey data and open the casing program editor for that survey and then also open a graphics display of the casing program. You can keep each of these windows open and switch between each one or change focus from one module to another and the menus will change accordingly.
The Status Bar at the bottom of the KellyDown screen shows informational messages at the left when KellyDown is busy. At the right are shown five panels indicating the North Reference, Units of Length and Diameter and the vertical and horizontal reference origins. We’ll discuss these later. Red text in any of these panels indicates that the corresponding reference is not the preferred reference.
Database Explorer
The Database Explorer is the main method of navigating between the different projects, structures, wells and profiles etc. in the KellyDown database. The Database Explorer is always visible on the left side of the KellyDown screen. When you resize the KellyDown screen, the height of the Database Explorer expands and shrinks accordingly.
The different entities shown in the Database Explorer are referred to as nodes. Click on the Plus symbol next to a node to view the sub-nodes below it and click on the Minus symbol to close the node again. We refer to the relationship between the nodes as either parents or children. A well is the child of the structure it belongs to. A structure is the parent of all the wells underneath it. In the case of profiles, where one survey is tied on to another, we refer to the shallower survey as the parent and the deeper survey as the child.
Each of the nodes in the Database Explorer shows the ID of that particular entity. Hover the mouse over a node to expose a tooltip showing the corresponding Name of that entity and in the case of a profile, the tooltip shows its Wellbore Name and Profile Name.
Click on the ID of a node to expand the node down to the last accessed profile for that node. This feature allows you to easily switch between projects because by clicking on a Folder or Project the node will immediately expand the path down to the last proposal or survey you accessed in that folder or project.
Whenever KellyDown closes, it records the location in the database where you last worked and opens to that same location next time you work in that database.
If there are too many nodes to fit inside the Database Explorer window, use the scroll bar on the right hand side to bring other nodes into view.
The checkboxes next to each node are used to select profiles that will be included in some of the KellyDown modules that require access to several profiles at one time, i.e. the Visualiser module and the Anti-Collision module where all the checked profiles are scanned for proximity against the reference profile.
It is not necessary to select every profile individually. You can select all the profiles in a Project simply by checking the box next to the Project node. Similarly, you may select all the profiles belonging to two Structures by checking the boxes for the two Structures in question.
Hold down the keyboard Control key and click on a node to uncheck every node except the one you are clicking on and its children. Use this function if you have a multi-project database where you only want to export data belonging to say the current project or the current well for example.
If you expand several nodes so the Database Explorer looks very busy, press the F5 key to refresh it or select the View, Refresh Database Explorer menu.
You can only collapse nodes where all of the child nodes are either checked or unchecked. KellyDown keeps track of which nodes are checked and which are not so if a node is collapsed, KellyDown knows that all the nodes below that one are either checked or unchecked depending on the status of the parent node.
Many of the menus found on the main KellyDown menu and on the toolbars are also accessible from the Database Explorer – just right-click on a node and select the appropriate function from the pop-up menu. For example, to add a new folder to the database, right click on the Database node and select Add New Folder from the pop-up menu.
The pop-up menus change depending on which node is selected. For example, when a Project node is selected, the popup menu has an option to edit Lease Lines associated with the project.
When a Structure node is selected, the popup menu has options to edit Section Lines associated with the structure, edit slot coordinates and locate the project centre at structure location.
When a Well node is selected, the popup menu has options to edit the Hard Lines, add new proposals and surveys and locate the structure centre at the well locations.
The Proposal and Survey nodes give you access to many of the editing functions associated with profiles, including making the current profile active or inactive, access to the survey data, slidesheet, targets, casing, survey tools, formation tops, comments and engineering modules.
The Database Explorer is disabled when you work on individual modules, for example, the proposal editor, survey editor and slidesheet editor. This prevents you from switching to a different node in the database where doing so would cause unpredictable or even disastrous results. If for example, you were working on one survey data set, you wouldn’t want the database pointer to move to a different well in a different project because it would become unclear which survey the data belonged to.
Consequently, although the main menu and toolbar are displayed when you click on the Database Explorer, all the menus and toolbar buttons except the Windows and Help menus are disabled when working in a particular module.
Data Reference Panel
Below the Database Explorer is the Data Reference Panel, which is used to switch between different vertical and horizontal origins, between True North and Grid North and to select a different unit system.
In KellyDown, you can easily switch between any of these references with the click on a button, but of course there are safeguards in place to make sure you don’t inadvertently use an incorrect reference in reports or plots for example.
The vertical and horizontal origins are the origins from which coordinate data and vertical depths are referenced, particularly when viewing the data in spreadsheet modules like the survey editor or when printing reports.
We’ll look at the Vertical Origin first and consider the Survey Editor as an example. With the vertical origin set at the well level, you can see in the Survey Editor that the vertical depth originates at zero, which is the wellhead. The Status Bar at the bottom right shows us that the origin is the RKB.
If we change the Vertical Origin to Global, notice that the survey vertical depths now start at a different value, usually a negative number because the well is some distance above the global vertical origin, which is typically mean sea level.
Notice also that the vertical origin label on the status bar now reads Mean Sea Level and is coloured red. The actual text (Mean Sea Level) is defined by the user at the folder level. It is coloured red because it is not the Preferred Vertical Origin for printing reports. This option is set under System Settings, which we will discuss later.
With the horizontal origin set at the well level, notice that in the Survey Editor the Northing and Easting coordinates originate at zero, which is the wellhead.
Change the Horizontal Origin to Global in the Data Reference Panel and notice that the Northings and Eastings now start with a larger number; these are the map coordinates of the well. All the survey data is now referenced to mean sea level and map coordinates as shown in red on the Status Bar.
You can also set the Vertical and Horizontal origins to the Project or the Structure, thereby allowing you to define up to four datums for vertical depths and four origins for horizontal coordinates. These can also be easily updated if you need to define additional datums or origins.
When calculating the survey coordinates, KellyDown adds the offsets from each level back to the origin to be displayed. For example, consider a survey that has a vertical depth of 100m relative to the wellhead. When displaying this survey relative to the global origin, KellyDown adds the well elevation, structure elevation and project elevation to the survey’s vertical depth.
Similarly, when displaying the survey coordinates, KellyDown adds the well offsets, structure offsets and project offsets to the global coordinates to display the survey Northings and Eastings as map coordinates.
By selecting any of the vertical or horizontal origins in the Data Reference panel, you may view and enter survey data relative to any of the predefined origins.
Notice that when the global or project horizontal origin is selected, the North Reference in the Data Reference Panel is set to Grid North and the True North option is disabled. This is because at the global horizontal origin and project origin directions are always relative to Grid North. The True North reference is only applicable for local coordinates since the curvature of the earth drastically reduces the accuracy of True North coordinates over large distances. Map coordinates are therefore always relative to Grid North.
When we set the vertical and horizontal origins back to Well, notice that the origins start at zero again and the True North option is once again enabled.
Change the North Reference to Grid North and notice that the survey azimuths and local coordinates change. It may be obvious why the azimuths change, but not quite so obvious why the northing and easting coordinates change since the survey is in the same location in the real world – it is actually the reference that has changed. The first box on the status bar at the bottom right always shows the current North Reference and when it is coloured red, it means the reference is not the preferred reference set under System Settings.
The last item on the Data Reference Panel is the Unit System selector. We will open up the Casing Editor as well so we can view units other than just lengths. When we change the Unit System to SI (Metric), notice that almost all of the data in the Survey Editor and the Casing Editor changes to the new units. The column headers also change to reflect the new units and the two boxes on the status bar change to reflect the length and diameter units. They are also coloured red because in our example, feet and inches are the preferred units, not metres and millimetres.
The Unit System and North Reference you select in the Data Reference Panel remain in effect only until you change to a node in a different Project, at which time the units revert to the defaults set at the project level and north reference reverts to the default set at the structure level.
The Vertical and Horizontal Origins remain in effect while you are working in the current project. When you switch to a different project, the vertical and horizontal origins switch to the ones set in that project. When you switch back to the current project, they revert back to the ones that were last set for that project.
As already mentioned, if the Reference Origins, North Reference or Units are not set to the preferred ones as defined in System Settings, the corresponding labels on the Status Bar are coloured red and if you attempt to produce a report or plot while these references are not the preferred ones, a warning message pops up to warn you.
Notice that when you do click on any of the reference controls in the Data Reference Panel, focus switches to the Database Explorer window and consequently the menu and toolbar associated with the module you are working in lose focus and are disabled so you need to direct focus back to the module in which you are working before you can continue editing the data or use any of its associated menus or toolbar buttons.
As you can see, there are several methods of launching the same modules in the KellyDown application. To edit the structure properties for example, you can right-click on the structure node in the Database Explorer or right-click on the Structure button on the Reference Bar and select Structure Properties from the pop-up menu, you can select Structure Properties from the main Edit menu or you can click on the Structure Properties button on the toolbar when the Structure is selected in the Database Explorer. In actual fact you can also double click on the Structure node itself in the Database Explorer to launch the Structure Properties dialog.
Editing Text
There are two types of edits you can perform on the data in KellyDown; text edits and numerical edits.
The KellyDown Text Editor has several functions that are not immediately obvious. Several fields in the KellyDown database are limited to a certain number of characters. For example all IDs are limited to 20 characters and Names are limited to 50 characters. If you try to enter more characters than are allowed, you will hear an audible beep and you will be prevented from entering more characters.
You may sometimes find that after entering a large amount of text, that the Caps Lock button was depressed and you need to retype the text in the proper case. This isn’t necessary, just press the Ctrl + T key combination to convert the characters to title case where the first letter of every word is capitalised. You can also press Ctrl + U to convert the text to upper case, Ctrl + L to convert the text to lower case or Ctrl + S to convert the text to sentence case where the beginning of each sentence is capitalised. If you select just a few characters in the text, the effect is applied to only those characters.
Notes fields and Comments fields also contain a built-in spell checker. If you misspell a word, it is highlighted with a red squiggly line beneath it. Right-click on the highlighted word to see a list of possible options.
Choose one of the words with the correct spelling or click on Add to Dictionary if the highlighted word actually is a proper word that the dictionary just didn’t recognise.
Click on Spell to bring up the Spell dialog where you will find additional options.
Editing Numbers
The KellyDown Numerical Editor is quite sophisticated. Its function changes depending on which type of field you are editing.
As far as possible it will only allow you to enter numbers that are within a valid range. For example, you are only able to enter inclination values that are within the range from zero to 180 degrees, inclination values outside of this range are invalid.
You are also prevented from entering illegal characters into numeric fields. You may enter a number with any precision into a field and it is saved with that precision but the display shows only the number of decimal places (if any) that have been defined for that particular type of number.
All length and diameter values are entered in the units shown on the Status Bar. Other values are entered in the units shown against the entry field itself, or in the case of spreadsheets in the units shown in the column header. The values are converted to SI Units (for example metres for lengths and diameters), before being stored in the database.
Normal numeric fields accept only numerical characters.
Northing fields accept numerical characters plus the N and S characters. You may enter Northings as positive or negative numbers or as values followed by an N or S to indicate North or South. They are converted and displayed in the preferred format when you tab to the next field. Easting fields accept numeric characters plus the E and W characters to indicate East or West.
Inclinations and directions may be entered as decimal degrees or degrees, minutes and seconds separated by spaces. Directions may be entered as azimuths, i.e. zero to 360 degrees, or as quadrants (for example. N 45 30 15 E). The following are valid entries for directions:-
123.45 123.45 degrees
123 45 67.89 123 degrees, 45 minutes, 67.89 seconds
-123.456789 minus 123.456789 degrees
N 45 W North 45 West
S45.6789E South 45.6789 East
Geographical coordinate fields handle values entered in decimal degrees or in degrees, minutes and seconds – just separate the degrees, minutes and seconds with a space. They may be entered as either positive or negative values or with an appended N, E, S or W to indicate the direction. When you tab off the field the value is formatted according to the format specified under the Tools, Options menu, under the Display Options tab. The following are valid entries for geographical coordinates:-
23.45 23.45 degrees
23 45 67.89 23 degrees, 45 minutes, 67.89 seconds
23.45 S 23.45 degrees South
23.45E 23.45 degrees East
23 45W 23 degrees and 45 minutes West
-23 45 30 minus 23 degrees, 45 minutes, 30 seconds
Lengths, including depths etc. may be entered as feet or metres irrespective of the current length units by appending an f or an m to the value, for example 1000 m is interpreted as 1000 metres even when the default units are in feet.
Diameters may be entered as inches irrespective of the current diameter units by appending a double quote character, e.g. 10” is interpreted as 10 inches even if the default diameter units are millimetres.
Times and Hours may be entered as decimal hours or as hours and minutes separated by a space. Additionally, Times may be entered simply as hours and minutes without a space, for example enter 930 to enter a time of 9:30.
The formatting of numbers is handled in the Units Editor, which is discussed later. KellyDown allows all values to be displayed in just about any possible unit and format. You may choose to display numbers with or without a thousandths separator and with any number of decimal places, and you may even add your own units if necessary. For example, lengths may be shown in metres, feet or US feet, but you may also add furlongs if you wished.
General Interface
The method of entering information into KellyDown is mostly through either dialogs or spreadsheets. Dialog boxes are used mainly to enter a single record into the KellyDown database, for example: information about a single well or a single target. Spreadsheets are used to enter a collection of records, for example, survey records, slide records or casing records etc.
While you edit information in a dialog or in a spreadsheet, the Database Explorer is disabled and clicking on it causes the main KellyDown menus and toolbars to be displayed but they are disabled. This effect is deliberate to prevent you from changing to another project in the database while you are editing information in the current one.
Dialogs
Dialogs have a consistent look. The title bar shows the type of entity being edited. Immediately below the title bar are the ID and Name of the entity. The ID is a short form of the Name and is used to identify the entity within the KellyDown application itself. Its length is limited to 20 characters. The ID of an entity is displayed in the Database Explorer and in the Data Reference Bar at the top of the main KellyDown screen.
The ID is unique for all entities under its parent entity, for example a structure may contain only one well that has an ID of “Well #1” and a Well may contain only one proposal that has an ID of “Design #1”.
The Name may contain up to fifty characters and is the real-world name of the entity. The name is printed on reports and plots. It does not need to be unique, so a structure may have more than one well whose name is “Well #1”, although this is generally not recommended.
Quite often, the Name is less than 20 characters in length and therefore the same as the ID, so KellyDown automatically copies the ID to the Name field when you tab off the ID field if the Name field is empty or the same as the original ID field.
The ID and Name fields are mandatory fields and must contain valid text. If you tab off either of these fields without entering information, you will be presented with a warning message and directed back to that entry field. The only way of closing the dialog without entering text in these fields is to click on the dialog’s Cancel button.
Most dialogs consist of one or more tabbed pages. Click on the tab at the top of the dialog to access the information contained on that page. The last tab usually contains a Notes field where you may enter supplementary information. This information is used purely as a reminder to you or anybody else who uses the database about actions that have been performed on the particular entity. For example, a customer may move a target from its original position. It is good practise to make a note of what changes were made, when they were made and who instructed you to make the change. There is no limit to the quantity of text that a Notes field may contain.
When a note has been added to a particular entity, a map-pin icon is displayed on the tab itself so you can easily recognise if a note has been added.
Almost all records in the KellyDown database include audit information consisting of the date the record was created, the date it was last updated and the ID of the user who last updated it.
Hover the mouse cursor over the Update User ID to view the actual name of the user who last edited the data.
In some dialogs, you have the option of entering coordinates relative to a number of different origins. This differs from a spreadsheet interface where you select the current vertical and/or horizontal origin using the Data Reference Panel.
In the case of a target, you have the option of entering the target coordinates as either geographic coordinates, map coordinates, offsets from the project, offsets from the structure or offsets from the well.
This may seem a little daunting at first, but it is really quite straightforward. The origin is displayed above each column, i.e. Global Origin, Project Origin etc. and the type of coordinate is displayed at the left, i.e. Vertical Depth, Northings or Eastings.
You may view the actual origin names by hovering the mouse cursor over each of the entry fields. For example hover the mouse over the Northings relative to the Structure Origin to see that the target Northings are relative to AA Pad. The actual naming of the origins is discussed later.
If you are provided with target vertical depths relative to mean sea level and target offsets relative to the wellhead, enter the vertical depth under the first column and the horizontal offsets under the fourth column. As you tab off each field the associated fields are updated automatically.
Above each column you will see the north reference. If the local North Reference is set to True North, it is shown above the Structure and Well coordinate columns, and if the north reference does not comply with the preferred north reference set in System Settings, it is highlighted in red to bring it to your attention.
An additional option set at the project level allows you to always show global coordinates in metres even when the Units are set to feet. In this case, the Global Origin label above the first column is coloured blue and a message is displayed in blue at the bottom of the dialog box to remind you that the map coordinates are shown in metres and not feet.
Spreadsheet Interface
Spreadsheets are used to enter collections of information such as survey data, casing sections or formation tops etc. The title bar shows the data set being edited followed by a Minimise button, a Maximise button and a Close button.
If you click on the Minimise button, the spreadsheet is minimised and may become hidden behind the Database Explorer. If it does, use the Ctrl + Tab key combination to cycle through the open windows in the KellyDown application until the minimised window appears and you can then restore it to its original size and position. Alternatively, you may select the window from the Window menu, which will bring it back into view.
The Maximise button will expand the window so it fills the full area inside the KellyDown application window. Click on the Restore button to restore it to its original size.
Pressing the F11 key or selecting the Windows, Dock menu will cause the spreadsheet to fill the available space to the right of the Database Explorer. Hold down the Ctrl key and click on the F11 key to dock the spreadsheet inside the whole of the KellyDown workspace.
Spreadsheets consist of columns of data that run from top of the spreadsheet to bottom and rows that run across the spreadsheet. The individual entry fields in a spreadsheet are referred to as cells.
Some spreadsheets restrict you to entering information in only certain columns or cells. The other columns or cells are for display purposes only. For example, in the survey editor spreadsheet, you can enter measured depths, inclinations and azimuth values. The other columns display calculated values such as the vertical depth and coordinates etc, so you can’t enter data into these cells. Some spreadsheets such as the survey editor spreadsheet even prevent you from clicking on the read-only cells. This is done so the tab key automatically skips to the next line once you have entered the columns of information that are required. This aids typing by letting you tab from one editable field to another as you type.
To add new information into the spreadsheet, simply continue to type on the bottom row, which automatically adds a new record.
Note: none of the modifications or additions you make to the data in a spreadsheet are saved to the database until you either save the data by using the File, Save menu or close the spreadsheet and answer Yes when KellyDown asks you if you want to save the modifications.
The column headers display the type of information to be entered in the column or the type of information displayed in the column followed by the units of measurement in brackets. The data is referenced to the origins and North reference displayed on the Status Bar at the bottom of the KellyDown screen.
You can change the units, north reference and vertical and horizontal origins at any time whilst the data is displayed in the spreadsheet and it is instantly updated to the new reference. Additionally, you may enter information relative to whatever reference is in effect. KellyDown keeps track of the reference and stores the data appropriately if and when it is saved to the database.
Modifications you make to the data in a spreadsheet are identified by a green coloured marker indicating a new row or an amber coloured marker indicating a modified row to the right of the row label. These markers remain visible until you save the modifications to the database, allowing you to easily see what data has been added or changed during the current editing session but not yet saved to the database.
If any of the columns in the spreadsheet contain information that exceeds a predefined tolerance, the status marker is coloured red so you can quickly scroll across to the offending data even if that column is not presently in view, for example if survey data diverges too far away from the associated well plan.
The various functions you can perform on the data are accessed via the menus or via toolbar buttons. Additionally, pop-up menus provide access to functions that are specific to individual rows or columns.
For example, select some rows in the survey editor and right click on a row. A pop-up menu displays functions you can perform on the data.
Almost all the spreadsheets allow you to modify the columns of data that are displayed in the spreadsheet. Right-click on any of the column headers to present a pop-up menu that allows you to customise the columns.
Columns Editor
The Columns Editor is divided into two halves. The panel on the right lists the columns that are currently selected in the associated spreadsheet and the panel on the left shows additional columns that are available.
Select any of the additional columns on the left and click on the Add button to move them to the Selected Fields panel or move all the columns to the Selected Fields panel by clicking on the Add All button. Remove fields from the Selected Fields panel in the same manner by clicking on the Remove or Remove All button. Use the standard key combinations to select more than one column at a time, for example, use the shift key to select a contiguous group of columns or the Ctrl key to select individual columns.
You may simply double click on a field in the Available Fields panel to move it to the Selected Fields panel or double click on a field in the Selected Fields panel to remove it from the list.
Once you have moved the desired fields to the Selected Fields panel, select one or more of them and click on the Move Up or Move Down button to position them exactly as you wish. Hold down the Ctrl key while clicking on the Move Up or Move Down button to move the selected column or columns ten positions at a time.
Click on the Set Default Columns button to revert to the factory setting list of columns.
When you are happy with the Selected Fields and their order, click on the OK button to return to the spreadsheet and notice that the additional columns have been added. Click the Cancel button to return to the spreadsheet without changing the columns.
If columns you selected in the Columns Editor don’t appear in the spreadsheet, it may be because information in those columns isn’t relevant, i.e. columns about the associated wellplan aren’t shown if a wellplan hasn’t been associated with the current survey under Survey Properties.
Well, that’s all for now. Thanks for watching!
Part II – The Administration menu
Hello and welcome to the second in a series of training videos about using Kelly Down. In this video, I’m going to show you all about the first few items under the Administration menu including how to add new users to the database and how to configure the System Settings in Kelly Down.
When you launch KellyDown for the first time, it is assumed that you are logging on as the Administrator and KellyDown creates an account called the Admin account in the System Database. Every System Database must have at least one user account and one of them must be the Admin account. Only Admin may create additional accounts so other users can access the database.
Admin has several privileges not afforded to other users of the database, one of which is the ability to create and modify other user accounts.
Change Password
The first item under the Administration menu is the option to change the logon password. Any user may change his or her own password. Simply enter the existing password followed by the new password twice, the second time being to confirm you have entered it correctly the first time.
As you enter the new password, an indicator changes colour to show you how strong your password is. A weak password turns the indicator red. A strong password contains one or more upper case characters, lower case characters, numbers and special characters, and turns the indicator green. You should always use a strong password.
Enter a password hint to remind you of the password should you ever attempt to reopen this database after an extended period of time after having forgotten the password.
Log on as a different user
The second item on the Administration menu allows you to log onto the database as a different user. You are presented with the same logon screen that you see when you first log on to the KellyDown database. Simply select a different user name from the drop-down list and enter the password for that user.
You may also use this option to log on to a different database altogether. The first drop-down list contains a list of all the databases that have been recently accessed on your computer.
Access to KellyDown databases is restricted to authorised users who can only gain access by providing their own unique password. Having access to one database does not necessarily mean you have access to another database.
If you are a normal user and you forget your password, the Administrator can log on to the database and change your password for you without prior knowledge of your existing password.
Manage User Accounts
Admin may create or modify other user accounts for the current database. Use the Manage User Accounts menu to load a list of the user accounts for the current database. Select an account from the list and click on a button to edit, add or delete a user account.
Note: Admin may not delete his or her own account or change his or her access level. This prevents the possibility of a database having no Admin account.
The list of users shows their ID, name, logon status and access privilege. Access may be Admin, Normal User or Guest. Admin has full privileges and may perform all functions in KellyDown. A Normal User may perform all functions in KellyDown except the deletion of records. A Guest is only able to view records, reports and plots. He or she is not able to modify the database in any way.
The log-off button allows Admin to clear the logon status of another user in the database. Use this option in cases where a power outage or some other computer or network problem caused a user to lose contact with the database without performing a proper logoff procedure.
Click on the add-new button to add a new user to the database. The new-user-account dialog is displayed.
Enter a user ID and a user-name. The ID appears in the list of users when you first log on to the database and is stored with each record that is added or modified in the database as part of the audit trail.
The user-name and other information are used purely for informational purposes by Admin to keep track of who has access to the database.
Check the use-Windows-authentication box to allow the user to log into the KellyDown database without needing to enter the logon password. This option assumes that if the user is able to log on to the computer, that he or she is also authorised to access the KellyDown database.
Click on the change-password button to load the change-password dialog. You will not need to enter an existing password unless the current user account is Admin.
If your internet service provider allows you to do so and you have configured the outgoing-mail-server under system-settings that are described later, you may click on the send-text message button to send an SMS text message to the user’s mobile phone.
Select the name of the user’s cell phone provider from the list. It will be saved and used as the default next time you send a text message. Then enter a subject and the message you wish to send. Keep the message as short as possible to avoid excessive charges and then click on the send button.
The recipients must be subscribed to an SMS messaging service in order to receive the text message, otherwise he or she will receive a message from his or her mobile provider asking him to subscribe to the service before he can read the message.
If you have an email application installed and configured on your computer, you may click on the send email button in the user properties dialog to launch your email application with the user’s email address filled in ready for you to compose the message.
System Settings
The system-settings dialog is where you enter most of the information that is stored in the system database and shared across all projects databases. Although some of the information may also be accessed and modified from other modules in KellyDown, it is all grouped together here for convenience. Several different tabs separate the modules into different groups.
The General tab provides access to entities such as companies, rigs, magnetic models and survey tools etc., each of which opens up a dialog where you enter the information associated with those entities.
Each element consists of a drop-down list, an Edit button, an add-new button and a delete button. Select the item from the drop-down list and click on one of the buttons to edit, add or delete the item.
Company Properties
The list of companies refers not only to customers that are assigned to structures in KellyDown, but also to the operators of rigs and to drilling contractors.
Click on the edit button to edit the existing company information, or click on the add-new-company button to open the new-company dialog.
First enter the ID, which is used to identify the company in the KellyDown application. As you tab off the ID field, the ID is copied to the name field where you can leave it as is or expand on it. The full name is used in reports and plots.
Most of the options are self-explanatory. You enter details of the address, phone numbers and email address etc. and check the box describing the Relationship of the company. It might be a customer, an operator or a contractor or a combination of two or more.
Once you have entered a valid address, you may click on the view in Google maps button to see the company address location in Google maps, from where you may if you wish have Google maps show you the directions to your customer’s office.
If your computer is configured with access to an email application and you have entered a company email address, click on the send-email button to send an email to the company. KellyDown will open your email application with the email address filled in.
You may enter the contact information for specific employees of the company. Click on the add-new-contact button or the edit-contact button to open the contact properties dialog.
Click on the export button to export the company information to a file that may subsequently be imported into another instance of KellyDown using the Import button.
Company Options
Click on the company-options tab to expose the options that are specific to each individual customer. These include proximity options and the drilling safety factors preferred by the customer.
Global coordinates always metres – normally, units are displayed in whatever units are selected in the data-reference panel, but map coordinates are often displayed in metres regardless of the local units in effect. Check this box if the client prefers global or map coordinates to always be shown in metres.
Show global vertical depths and sub-sea depths as negative values – check this box if the client prefers to see sub-sea depths as negative values.
Use grid coordinate scale factors to calculate local coordinates – this option applies a grid coordinate scale factor to all local coordinates. Although rarely used, there may be some clients that prefer to have local coordinates calculated this way.
Show customer’s own name and logo on reports – if this option is checked and the customer’s branding information has been configured, the style of reports will be formatted according to the customer’s branding instead of to your own company’s branding.
Show hole sections list in drill-records – some customers wish to see names of each hole-section in drilling reports. Click this box to make the option available in other parts of KellyDown.
Show inclinations for river-crossings from horizontal – for river crossing applications, it is normal practise to show inclination values relative to the horizontal instead of to the vertical plane. For example, a horizontal river crossing with a hole sloping down at five degrees to the horizontal is shown as five degrees. At the end of the river crossing where the hole is returning to surface at five degrees to the horizontal, the inclination is minus five degrees.
Show signature-box at the end of drilling-reports – this option causes a signature box to be appended to the end of all drilling reports that may be signed by the client’s representative and your company’s representatives.
Drilling reporting-time – normally, daily drilling reports cover a period from midnight to midnight but if a client prefers daily reports to cover a different twenty-four hour period, say 6:00am to 6:00am, set the start time for the daily drilling reports here.