Daily Reporting How To Guide
A guide to the Daily Reporting module within Well Seeker Pro.
The purpose of this document is to introduce the user to the daily reporting package features within Well Seeker Pro. It has been assumed that the user has already installed Well Seeker Pro, has a valid license that gives them access to the Reporting features and has a database structure in place ranging from Operator to Actual Well level.
The Well Seeker PRO daily reporting package allows the user to semi-automate the creation of daily drilling reports. The daily reporting package is made up of the of the Drill String Editor and all the Reporting sub menu tools.
Figure 1: Reporting Menu
The daily reporting package can produce the following reports:
1. Daily Reports
2. Company Man’s Report
3. Morning Report Package
4. Daily Cost
5. Well Cost
6. Field Invoice
7. Filtered Invoices
8. Cost Tracking
9. Tool Inventory
10. Tool Utilisation
11. Tool Tracking
12. BHA
13. BHA Performance
14. Mud Motor Performance
15. Mud Motor Failure
16. MWD Performance
17. MWD Failure
18. BHA Incident Reports
19. End of Well Reports
20. Personnel Utilisation
21. Personnel Tracking
22. KPI Tracking
23. Rig Tracking
24. Depth vs Time
25. Shipping Tickets
26. Pipe Tally
27. Slide Sheets
28. Slide Analysis
29. Motor Yield Report
30. Mud Chemical Inventory
31. Mud Chemical Usage
32. Certification Report
33. Well Statistics
34. Revenue Report
35. Rig Days Report
36. Well Ranking Report
It is suggested that data is input in the following order to increase input efficiency and reduce the requirement to duplicate data entry. However, this is just a guide and the user can deviate from this sequence should they wish.
1. Input tool listing into Tool Inventory. This will give the user the option to select these components when creating a BHA, reducing duplicate data entry.
2. Input/import the BHA for the upcoming run in the Drill String Editor. Once created a BHA can be associated with a time and date window within daily reporting. This allows for sharing of data between Drill String Editor and Daily Reporting, including allocating tool performance and utilisation data.
3. Confirm/edit Activity Codes, Cost Codes and Phase Codes. These codes can be utilised in the Daily Reporting dialog and when referenced, are used by Well Seeker to generate the relevant KPI data. If the user is interested in reporting this data, it is important that these codes are set correctly at the start of the job.
4. Input/confirm Shipping Addresses. Shipping addresses can be selected in the shipping ticket dialog.
5. Fill in the Daily Reporting and Shipping Ticket sections as required.
6. The user can populate the daily activity section of the daily report directly from the slide sheet. If it is the user’s intention to populate the daily report in this way, then input the drilling data into the Slide Sheet over the relevant 00:00-24:00 time interval. At any time, the user can select Get DDR from Run Sheet within the Daily Reporting dialog, and the daily activity section will be populated automatically with the relevant data from the run sheet.
The Daily Reporting toolbar is an additional toolbar that gives access to the main Daily Reporting Functions. It can be enabled/disabled using the View > Toolbars and Docking Windows menu item.
Figure 2: Reporting Toolbar
The drill string editor is used to construct the BHA and drill string for each drilling section. The information here is used in Daily Reporting and is required for the Slide Sheet.
Figure 3: Drill String Editor Window
The Drill String Editor window is divided into five parts: The toolbar, the top dialog, the lower dialog, Assembly Details and Component Properties.
The toolbar contains all the functions required to operate the Drill String Editor. These functions can also be accessed using the dropdown menus at the top of the dialog.
Figure 4: Drill String Editor toolbar
Save: Saves any changes made to the BHA in the Drill String Editor.
Select BHA to Print: Opens the Select BHA dialog which allows the user to select which BHAs they want to print BHA and Performance reports for. The selected reports will then be exported together in a single document. The user can choose the format of the document using the drop down box at the top of the dialog.
Figure 5: Select BHA to print
Print Tally Book BHA: Exports the selected BHA to an Excel report in a compact format designed to be attached to a DD/MWD operator’s tally book.
Print BHA Excel: Exports the currently selected BHA as a BHA report in Excel format.
Print BHA Inverted Excel: Exports the currently selected BHA as a BHA report in Excel format, but with the BHA arranged so that the bit as at the bottom of the page.
Print PDF BHA: Exports the currently selected BHA as a BHA report in PDF format.
Print PDF BHA Inverted: Exports the currently selected BHA as a BHA report in PDF format, but with the BHA arranged so that the bit as at the bottom of the page.
Print all BHAs Excel: Exports all BHAs in Excel format. All reports will be contained in a single document.
Print all BHAs PDF: Exports all BHAs in PDF format. All reports will be contained in a single document.
Single page BHAs: If this option is toggled on, BHA reports will be formatted so that they fit onto a single A4 page.
Print all Performance Reports Excel: Exports all performance reports in Excel format, contained in a single document.
Print all Performance Reports PDF: Exports all performance reports in PDF format, contained in a single document.
Add New: Creates a new blank BHA in the Drill String Editor.
Delete: Deletes the currently selected BHA. Note that if the BHA is selected in a Daily report a warning message will appear advising “The BHA is currently in use with Daily Reports or Engineering and cannot be deleted”. If a BHA has a run sheet associated with it, then deleting the BHA also deletes the run sheet.
Exit: Closes the Drill String Editor window.
Undo: Reverses the last action performed.
Redo: Reverses the last undo action performed.
Copy BHA: Duplicates the currently selected BHA and adds it to the bottom of the list of existing BHA’s.
Insert from Inventory: Opens the Insert From Inventory dialog, allowing the user to import a component from the Tool Inventory into the BHA. See Section 2.8 – Insert from Inventory for more information.
MWD Probe Order: Opens the MWD Probe Order dialog box. This dialog allows the user to set which tools are in the MWD string. Tools can be renamed in the MWD column and can be included or exclude from the string by toggling the Included check box on or off. The order of the tools can be changed using the Move Up and Move Down buttons.
This can then be displayed on the BHA report if the Include MWD section in BHA option is toggled on.
Figure 6: MWD Probe Order
Use IADC Bit Grading: If this option is toggled on, the Grade In and Grade Out fields for the Component Properties of the Bit are edited using the Bit Grading dialog box. Click on the ‘…’ button next to the Grade In or Grade Out fields to open the dialog.
Figure 7: Bit Grading Dialog
The Bit Grading dialog complies with the IADC bit grading system. Use the drop-down box on each row to fill in each part of the IADC code. If the bit is new, the user can simply click on the New checkbox.
If this option is toggled off, then the Grade In and Grade Out fields can be filled in manually.
Include MWD section in BHA: Toggles the MWD probe string section on in the BHA report. The string can be configured using the MWD Probe Order option.
Component catalogue: Opens the component catalogue. If the Insert function is used in the component catalogue, it will apply to the row selected in the Assembly Details table when the component catalogue was opened. See section 2.9 – Component Catalogue.
Material grades catalogue: Opens the material grades catalogue. See Section 2.10 – Material Grades Catalogue.
Pipe class catalogue: Opens the pipe class catalogue See Section 2.11 – Pipe Class Catalogue.
Use Drop Down: These options control how certain fields in the component properties can be edited. When toggled off, the fields can be edited manually. When toggled on, they are edited using a dropdown box that contains a pre-defined list. This is to avoid spelling discrepancies between different users, as many of the fields are used in the Well Analytics module.
The connections field is used in all component types. The bit make field is used in the Bit component type. The motor make, motor lobes, bend angle and stages fields are used in the Motor component type.
Import Engineering BHA: Imports a BHA exported from the Innova Engineering software package. Note that this will overwrite the currently selected BHA.
Import BHA: Allows the user to import BHA’s exported from the Drill String Editor in Well Seeker. Using this function will cause a dialog box to appear asking the user to open the desired .mdb export file. Once the file is selected the Import/Export window will open allowing the user to select the desired BHAs to be imported. Once selected, the BHA’s will be added on to the end of the current list of BHAs in the Drill String Editor.
Export BHA: Opens the Import/Export window, allowing the user to select which BHAs they want to export. The exported BHAs will be exported as a .mdb file.
Figure 8: Import/Export dialog
Export BHA in Engineering Format: Exports the currently selected BHA in a .bha format, allowing the BHA to be imported into the Innova Engineering software package.
Export current BHA to Oasis: Exports the currently open BHA, and all its associated drilling performance data to an external Oasis ERP database. The Oasis endpoint credentials need to be set up in the main interface file menu.
Export all BHAs to Oasis: Exports all BHAs in the currently open Drill String Editor, along with all their associated drilling performance data to an external Oasis ERP database. The Oasis endpoint credentials need to be set up in the main interface file menu.
Edit Data: Opens the Performance Report dialog. See Section 2.12 – Performance Report.
Performance Report: Prints the performance report for the current BHA in Excel format. To print the performance report in other formats, open the performance report dialog using the Edit Data option.
The main user interface is where the user constructs the drill string and records details for each component. It is split into 4 different sections which are discussed in detail in the below sections.
Figure 9: Drill String Editor main user interface
The upper dialog allows the user to select any available BHAs from the dropdown menu on the left. The BHA can be given a unique title in the Description Box. The data added to the Rig, BHA #, MWD # and Mud Weight cells are included when printing the BHA.
Figure 10: Upper Dialog
The lower dialog is used to define the Depth In/Out and the Date In/Out for the selected BHA. These values can be updated manually, or they can be automatically filled in by opening the Performance Report and clicking on Get Data From DDR. This will only work if the BHA has been used in the daily activities of the well’s Daily Reporting.
The lower dialog also displays the buoyed BHA weight and weight below jar (if a jar is included in the assembly). Note that these weights are when the assembly is vertical. The formation cell is for the user to input the target formation, and this is a searchable input in the Well Analytics tool. Any text in the formation and comments section will be displayed in the BHA report when printed.
Figure 11: Lower Dialog
The Assembly Details grid allows the user to construct the drill string, allowing it to be included in various reports in the Drill String, Performance Report and Daily Reporting Modules. Different types of assembly can be modelled including drilling, casing and liner assemblies and data entry is identical for each.
Figure 12: Assembly Details
The grid can be manipulated by right clicking on a row to open the Assembly Grid Context Menu:
- Copy: Copies the selected row.
- Paste: Replaces the selected row with the copied row.
- Delete: Deletes the selected row.
- Insert: Inserts a new row into the assembly above the selected line.
- Move Up / Move Down: Moves the selected line up or down in the list. Line 1 cannot be moved and should always contain the lowest component in the BHA, for example the bit.
- Insert from Catalogue: Automatically fills in the component information in the Assembly Details. See Section 2.9 – Component Catalogue for more information.
- Insert from Inventory: Opens the Insert From Inventory dialog. See Section 2.8 – Insert from Inventory for more information.
Figure 13: Assembly Context Menu
New lines can be added opening the Context Menu and selecting the Insert command. Lines can also be deleted by selecting the desired row, opening the Context Menu and selecting Delete. Lines in the grid can be rearranged using the Move Up and Move Down buttons in the Context Menu, except for the bit, which must always remain at the top in row 1.
It is recommended that the first thing the user does when filling in a new line is select the component type in the Component column. Once a component type has been selected on any given line, the user can then either manually enter the relevant component details, or by right clicking on the line, select to insert the component from the Catalogue or from the Inventory. Selecting to insert opens either the component catalogue or the insert from inventory dialog and allows the user to choose the appropriate component and insert the relevant details automatically at the click of a button.
The following describes each column in the Assembly Details table:
Component: Before any other details can be entered the component type must be selected from the dropdown list. The type of component that is selected will determine the properties displayed in the Component Properties section.
Description: A description of the component entered. This is only used in the generation of reports and plays no part in any of the calculations
OD: The outer diameter of the component in inches or mm
ID: The inside diameter of the component in inches or mm
TJ OD: If the component has a tool joint (such as drill pipe) enter the OD in inches into this column.
TJ ID: If the component has a tool joint (such as drill pipe) enter the ID in inches into this column.
Weight: This is the weight per unit length of the component, this must be entered by the user and is used for BHA weight calculations.
Cumulative Weight: The cumulative weight of the drill string components up to that point. This is automatically calculated.
Length: The length of the component in the system units.
Cumulative Length: The cumulative length of the drill string components up to that point. This is automatically calculated.
Non-Magnetic: Select this option if the component is made of non-mag material. This is currently for reference only.
The Component Properties section is where the user can include extra information for each component in the drill string. Selecting a row in the Assembly Details section will display the Component Properties for the component in that row. The Component Properties section will not populate until the selected row has a component type selected.
Figure 14: Component Properties for the bit
The details entered into the Component Properties are featured in the BHA reports, performance reports and daily reports.
The Insert From Inventory dialog allows the user to import drill string components from the Tool Inventory into the Drill String Editor. It can be accessed by selecting the desired row in the Assembly Details and right clicking, or from the Edit menu.
Figure 15: Insert from Inventory dialog
The Insert From Inventory dialog contains all tools currently in the Tool Inventory for the well. See Section 7.0 – Tool Inventory for more information on adding tools to the Tool Inventory. If the Component field in the Assembly Details has already been selected, the dialog will be filtered so that it only shows components of that type.
The user can select an item from the dialog and click the Insert button to add it to the drill string. If the other Assembly Details fields have been recorded in the Tool Inventory, then they will also be imported. The SN, Cnx Top, Cnx Bottom, Make and Model fields will be imported into the Component Properties.
The Component Catalogue can be accessed via the Catalogues menu or by clicking on the ‘Component Catalogue’ icon in the toolbar. Right-clicking in the Assembly Details grid and selecting ‘Insert from Catalogue’ will also open the component catalogue.
The Component Catalogue contains a list of drill string components with pre-defined properties that can be used in the Assembly Details section. The desired component can be searched for using the dropdown menus at the top. Clicking the Insert button will add the selected component to the BHA list. Note that the insert function will only work, when the catalogue has been opened via the assembly details grid.
Figure 16: Component Catalogue
Custom components can be added, removed and edited using the Add, Delete and Edit buttons. Components which come with the standard install can also be edited and removed if desired. The Reset button will revert the catalogue back to its originally installed state. Finally, the component catalogue can be imported and exported to and from other users.
The material grades catalogue allows the user to define the minimum yield and ultimate yield of the common types of material grade used in drill pipe and casing. The user can also create new material grades if required. The material grade for a drill string component can be selected in the component properties section of the main Drill String Editor window for drill pipe, heavy weight drill pipe and casing / liner only. These material grades are used for calculations in the Engineering module.
Figure 17: Material Grades Catalogue
The pipe class catalogue allows the user to define the wall thickness of the different classes of drill pipe. The catalogue comes with 5 default classes but also allows the user to create new drill pipe classes if required. The pipe class for a drill string component can be selected in the component properties section of the main Drill String Editor window for drill pipe and heavy weight drill pipe only. These material grades are used for calculations in the Engineering module.
Figure 18: Pipe Class Catalogue
The Performance Report allows the user to generate a BHA performance report, using the data from the Drill String Editor and information pulled from the Daily Reports.
Figure 19: Performance Report
Once the details of the Performance Report have been filled in, the Print Performance Report option can be used to export the report in Excel format. In the case of a motor failure, the Print Motor Failure option will export an Excel format report with details specific to the motor. Equivalent reports are available for the MWD string.
The Get from DDR button can be used to automatically fill in the Performance Report using information from the Daily Reports dialog. Any fields that correspond to data available from the DDR will be populated when the Get from DDR button is selected. The values imported will be the corresponding run data from the Daily Reports dialog covering the selected BHA.
The toolbar contains all the functions required to operate the Performance Report. These functions can also be accessed using the dropdown menus at the top of the dialog.
Figure 20: Performance Report toolbar
Print Motor Performance Report Excel/PDF: Prints a performance report in Excel or PDF format. Contains run data, motor data, drilling parameters, bit data, mud data, sensor offsets, dogleg performance, BHA details and failure information. In addition, it contains any comments from the operations at time of incident, troubleshooting performed, surface findings and additional comments boxes. Pictures can be attached using Add Images in the Tools menu.
Print Motor Incident Report Excel: Prints a motor incident report containing motor information from the performance report and drill string editor. It also contains extra fields that can be filled in with more detailed motor information and comments on any failures. Pictures can be attached using Add Images in the Tools menu.
Print Motor Failure Report Excel: Prints a motor failure report containing personnel, run information, mud information, bit information, motor description and drilling activity. It also contains the troubleshooting, surface findings, and evaluation comments boxes.
Additionally, it contains spaces to document the incident type, disassembly observations, damaged components, and additional observations. Pictures can be attached using Add Images in the Tools menu.
Print Motor Chargeback Report PDF: Prints a performance report in PDF format with the Chargeback comment box added to the bottom.
Print MWD Performance Report Excel/PDF: Prints a MWD performance report in Excel or PDF format. Contains run data, MWD tool serial numbers, MWD plug in data, drilling parameters, bit data, mud data, sensor offsets, dogleg performance, BHA details, MWD post run data, MWD tool order, magnetics, and failure information.
In addition, it contains any comments from the operations at time of incident, troubleshooting performed, MWD incident info, MWD shop findings and MWD comments boxes. Pictures can be attached using Add Images in the Tools menu.
Print MWD Failure Report Excel: Prints a MWD failure report containing personnel, run information, mud information, bit information, motor description and MWD information. It also contains the troubleshooting, surface findings, shop findings, and evaluation comments boxes.
Additionally, it contains spaces to document the incident type and additional observations. Pictures can be attached using Add Images in the Tools menu.
Save: Saves changes to the performance report.
Exit: Closes the performance report window.
Add Images: Allows the user to attach images to the performance report, that will then be included at the bottom of any motor report that is printed.
To add an image the user should browse for it by clicking on the folder icon, then clicking on the add button. Once added, any image can be rotated by selecting it in the list and clicking rotate image or deleted by clicking on delete image.
Get Data From DDR: This option automatically will populate the main, mud properties and MWD sections with data taken from the Daily Reporting (DDR) module for the well. Note that this will overwrite any data already entered into these sections. For this option to produce accurate data the DDR must have fluids, parameters, costs and activity data entered for every day the BHA is in use. The BHA must also have pick up (6O) and lay down (6P) activities correctly assigned in the daily activity section of the DDR.
Attach Files: The attach files dialog allows the user to attach external files to the performance report. These files will remain with the report if the well or reporting data is exported.
To add a file the user should first select the category that they want to assign the file to in the dropdown box. These categories are arbitrary and are to help with sorting large numbers of files. The user should then browse for the file by clicking on the folder icon and then clicking on the add button. Once added, any file can be open by selecting it in the list and clicking open file or deleted by clicking on delete.
Get MWD surface system data: If available, this option will retrieve all serial numbers of MWD surface equipment from the Tool Inventory. They will then be available as dropdown boxes in their appropriate fields in the MWD section. For more information on the Tool Inventory see Section 7.0 – Tool Inventory.
Get Min Avg Max Values: If this option is toggled on, the Get Data From DDR button will import in and display the minimum, average and maximum values for the drilling parameters during the BHA run. They will be displayed in a min/avg/max format. If this option is toggled off, only the average value will be displayed.
Figure 21: Performance Report main section
The main section of the Performance Report contains the following fields:
- Depth In: The start depth for the BHA run. This is entered in the main Drill String Editor window and is not editable in this dialog. This field is updated if the Get from DDR radio button is selected.
- Depth Out: The end depth for the BHA run. This is entered in the main Drill String Editor window and is not editable in this dialog. This field is updated if the Get from DDR radio button is selected.
- Total Drilled: The distance between the Depth In and Depth Out. This is automatically calculated and is not editable in this dialog.
- Time In: The time in 24hr format that the BHA went below the rotary table on the Date In. The Date In field can be found in the main Drill String Editor window. This field is auto populated if the Get from DDR radio button is selected.
- Time Out: The time in 24hr format that the BHA returned above the rotary table on the Date Out. The Date Out field can be found in the main Drill String Editor window. This field is auto populated if the Get from DDR radio button is selected.
- BRT Hrs: The total time that the BHA spent below the rotary table. This is automatically calculated and is not editable in this dialog.
- Slide Drilled: If there was any sliding during the BHA run, the user can record the distance slid here. This is a manual input. This field is auto populated if the Get from DDR radio button is selected.
- Rotary Drilled: The distance drilled while rotating on bottom. This is automatically calculated by taking away the Slide Drilled distance from the Total Drilled distance.
- Drilling/Circulating Hrs: The total number of hours spent drilling, both rotary and sliding. This value is automatically calculated from the data entered in the DDR.
- Rotary Hrs: The number of hours spent rotating on bottom. This value is automatically calculated by taking the Slide Hrs away from the total Drilling Hours.
- Slide Hrs: If there was any sliding during the BHA run, the user can record the sliding hours here. This value is automatically calculated from the data entered in the DDR; however the user can manually edit this cell if they wish, which in turn will change the rotary hours.
- Slide ROP: The average Rate of Penetration during sliding. This is automatically calculated by dividing the Slide Drilled distance by the Slide Hrs.
- Rotary ROP: The average Rate of Penetration during rotation on bottom. This is automatically calculated by dividing the Rotary Drilled distance by the Rotary Hrs.
- Average ROP: The average Rate of Penetration over the whole run, including both rotation and sliding. This is calculated automatically by dividing the Total Drilled distance by the Drilling Hrs.
- Date In: Date BHA is in hole. This is entered in the main Drill String Editor window and is not editable in this dialog. This field is updated if the Get from DDR radio button is selected.
- Date Out: Date BHA is out of hole. This is entered in the main Drill String Editor window and is not editable in this dialog. This field is updated if the Get from DDR radio button is selected.
- # Stalls: The number of motor stalls recorded during the BHA run.
- Stall Pressure: The average standpipe pressure at the time of stalling.
- Dry Ream Time: The number of hours spent reaming while not circulating.
- Wash / Ream Time: The number of hours spent reaming while circulating.
- Average Temperature: The average downhole temperature during the BHA run.
- Max Temperature: The maximum downhole temperature during the BHA run.
- BHA Cost: The total cost of the well while the BHA is in hole. This is pulled automatically from cost data in the DDR when the Performance Report is opened.
- State/Province/Region: The state, province or region of the well in which this BHA was run. This field is auto populated if the Get from DDR radio button is selected.
- Country/County/AFE: The county or local area of the well in which this BHA was run. This field is auto populated if the Get from DDR radio button is selected.
- Job #: The job number for the well. This field is auto populated if the Get from DDR radio button is selected.
- API Job #: If the well has an API job number assigned, it can be entered here. This field is auto populated if the Get from DDR radio button is selected.
- Rig: The name of the rig. This is automatically populated with the Rig input from the main page of the Drill String Editor.
- Lead DD: The name of the Lead Directional Driller that ran this BHA. This field is auto populated if the Get from DDR radio button is selected.
- Co Man: The name of the Company Man on the rig. This field is auto populated if the Get from DDR radio button is selected.
- Flow Rate: The average drilling mud flow rate during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- WOB: The average Weight on Bit whilst on bottom during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- WOB Slide: The average Weight on Bit whilst sliding on bottom during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- RPM: The average Rotations Per Minute of the string whilst drilling during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- On Btm Press: The average On Bottom Pressure during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- Off Btm Press: The average Off Bottom Pressure during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- On Btm Tq: The average On Bottom Torque during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- Off Btm Tq: The average Off Bottom Torque during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- Plan DLS: Average planned dogleg severity for the run.
- Act DLS: Average actual dogleg severity during the run.
- Max DLS: The highest recorded actual dogleg severity during the run.
- PU: The average surface hook load recorded while pulling the BHA out of hole.
- ROT: The average surface hook load recorded while rotating off bottom.
- SO: The average surface hook load recorded while running the BHA in hole.
- Min Temp: The maximum downhole temperature during the BHA run.
- Cost Per Ft/Cost Per Hr: The cost per foot and cost per hour during the BHA run. This is calculated automatically from cost data in the DDR.
Figure 22: Performance Report mud properties section
The Mud Properties section contains the following fields:
- Type: The type of drilling mud used during the BHA run. This field is auto populated if the Get from DDR radio button is selected.
- 600, 300, 200, 100, 6, 3: If viscometer shear rate test results are available, they can be entered in these fields. The numbers represent the RPM of the viscometer when the shear rate was measured. These fields are auto populated if the Get from DDR radio button is selected.
- PV: The mud Plastic Viscosity. This field is auto populated if the Get from DDR radio button is selected.
- YP: The mud Yield Point. This field is auto populated if the Get from DDR radio button is selected.
- Weight: The mud density. This field is auto populated if the Get from DDR radio button is selected.
- Temp: The temperature of the mud during drilling. This field is auto populated if the Get from DDR radio button is selected.
- Solids %: The % volume of the mud made up of solids. This field is auto populated if the Get from DDR radio button is selected.
- Sand %: The % volume of the mud made up of sand. This field is auto populated if the Get from DDR radio button is selected.
- Chlorides: The chloride content of the mud. This field is auto populated if the Get from DDR radio button is selected.
- Oil/Water: The relative proportions of oil and water in the mud, in %.
Figure 23: Performance Report mud properties section
The MWD section contains the following fields:
- MWD Plug In/Out Date/Time: These fields are automatically taken from the component properties of the MWD tool in the drill string editor. They can be refreshed by closing and reopening the performance report window.
- MWD Plug in Hrs: Calculated automatically from the above values.
- Circulating Hrs: This value is automatically calculated from the data entered in the DDR and can be refreshed by clicking the Get Data from DDR button.
- Tests: The MWD section allows the user to record the results of various pre- and post-run MWD tests. They are filled as PASS or FAIL using the dropdown box in each field.
- Pulse Amp On/Off Bottom: The recorded amplitude of MWD telemetry pulses during drilling when on and off bottom.
- Good Detection: A PASS or FAIL dropdown box allowing the user to record whether pulse detection was good during the BHA run.
- Day/Night MWD Engineer: The MWD personnel on shift at the well site during the BHA run. This can be updated from the DDR personnel section by clicking the Get Data from DDR button.
- Required Non-Mag Above/Below: The length of non-magnetic drill collar required above and below the MWD directional sensor to ensure there is no magnetic interference distorting azimuth measurements.
- Min/Max Temperature: The minimum and maximum recorded temperature whilst drilling. Can be updated by clicking the Get Data from DDR button.
- Serial Numbers (SN): The serial numbers of the MWD surface equipment used at the well site. If these have been recorded in the Tool Inventory then they can be imported into the MWD section by clicking on the Get MWD Surface System button. The fields will then become dropdown boxes containing the serial numbers of available equipment.
- EDR: The make of the electronic drilling recorder used on the rig to record drilling parameters, etc.
- Transducer Type: The make of the Standpipe transducer
- Receiver Type: The make of the surface system data receiver.
- Hookload sensor: The serial number of the hookload sensor. Available serial numbers can be pulled in from the Tool Inventory by clicking on the Get MWD Surface System button.
- Surf Sys Ver/Type: The make and version of the surface system.
- Int/Ext Offset: The internal and external (scribe line) toolface offset between the MWD and the motor highside.
- Laptop 3/4 SN: The serial numbers of spare laptops. Available serial numbers can be pulled in from the Tool Inventory by clicking on the Get MWD Surface System button.
- BU Receiver SN: The make of the backup surface system data receiver.
- BU Surface System Type: The make of the backup surface system.
- DD/MWD 1/MWD 2 Verification: The personnel that signed off on MWD reports delivered to the operator.
- Survey/TF sequence: The programmed mode of the MWD for recording surveys and toolfaces.
- X/O Angle: The inclination at which the MWD stops recording magnetic toolfaces and starts recording gravity toolfaces.
Figure 24: Failure Information
The Failure Information section allows the user to record any failures that occur during the BHA run. The Failed check box must be checked before any other features become available. The other features allow the user to record if the failure required a BHA trip and how many hours passed before the failure. The comments box can be used to record any other information relevant to issues or failures during the BHA run.
BHA Component: The BHA component that failed can be selected here. Note that components will only be available for select if they have been given a serial number in their Component Properties in the Drill String Editor.
MWD Tool: If a particular MWD tool component was the cause of the failure, this dropdown box can be used to select it. Note that components will only be available for selection if they have been assigned serial numbers in the Component Properties of an MWD tool in the Drill String Editor.
Motor Cat: Allows the user to specify any parts of the motor that failed.
MWD Cat: Allows the user to specify any parts of the MWD that failed.
NPT (Non-Productive Time): The non-productive time caused by the failure can be entered here and will be displayed in the Performance Report.
Hrs to failure: The time in hours between running in hole and failure can be recorded here and will be displayed in the Performance Report.
Trip for failure: Checking this box will indicate in the Performance Report that a BHA trip was required because of the failure.
LIH (Lost in Hole): Checking this box will indicate in the Performance Report if the BHA was lost in hole.
EDR Review: This should be checked if data from the electronic drilling recorder on the rig has been gathered.
Acct MTBF: This should be checked if the failure needs to be included in calculating the Mean Time Between Failure statistics for the failed component.
Surface failure: Checking this box will indicate in the Performance Report that the failure occurred at surface.
Closed: Checking this box will indicate in the Performance Report that the failure has been resolved.
Comment Boxes: The Operations at Time of Failure, Trouble Shooting Performed, Surface Findings, Shop Findings and Evaluation boxes can be used to make comments about the failure. These comments will be displayed in the Motor Failure Report and the Performance Report.
Figure 25: Performance Data and Additional Comments
The Performance Data and Additional Comments sections can be used to record if there were any failures during the BHA run, the reason for POOH and any miscellaneous information.
Motor Failed: Check this box to indicate if there was a motor failure. This will also check the ‘failed’ box in the Failure Information section to allow the user to enter details of the failure.
MWD Failed: Check this box to indicate if there was an MWD failure. This will also check the ‘failed’ box in the Failure Information section to allow the user to enter details of the failure.
Catastrophic Failure: Check this box to indicate that there was a sudden and complete failure of any component during the BHA run.
Unplanned Trip: Check this box to indicated that the BHA was pulled out of hole for an unplanned reason, such as BHA failure.
MWD OOS: This should be checked if the MWD was operated Out Of Specification. For example, in downhole temperatures it was not rated for.
Reason POOH: This dropdown box can be used to record the reason the BHA was pulled, which will appear in the Performance Report.
Additional Comments: This section can be used to record any miscellaneous information that the user deems relevant. The user can enter any relevant information regarding the run in this section and this can be included in the EOWR.
MWD Comments: Can be used for general comments on the MWD performance that will be included in the MWD performance report.
MWD Failure Information: Can be used to describe any MWD failures and will appear in the MWD performance and failure reports.
MWD Shop Findings: Can be used to describe the results of investigation in the workshop and will appear in the MWD performance and failure reports.
Chargeback: Can be used for comments that will be included in the motor chargeback report.
This option can be accessed via the database navigator menu or directly from the Daily Reporting dialog. Note that when accessing via the database navigator menu, the Activity Codes option will only be available to select from Operator Level.
These codes are used in the Daily Activities section of the Daily Reporting package and utilised for KPI Tracking Graphs and automatic calculations of Drilling Parameter and Drilling Summary data when selected.
Figure 26: Activity Code Dialog
The active check box allows the user to select which of the activity codes are active. Any codes which are selected as active will be available from the dropdown menu in the Daily Reports section. If the code is not selected as active, it will NOT be available to select in the Daily Reports. The Set to Default button will set the activity codes to match the values entered in the Activity / Cost Code Defaults, in the main interface Tools menu. The Reset button will reset all the activity codes the Well Seeker factory default.
The window can also be locked using the checkbox in the bottom left. When locked it is not possible to change any of the data in the window. If a password has been set in the associated Operator Properties, it will need to be entered before the window can be unlocked.
This option can be accessed via the database navigator menu or directly from the Daily Reporting dialog. Note that when accessing via the database navigator menu, the Cost Codes option will only be available to select from Well Level.
This tool is used to define cost items, that can then be used in the Daily Costs tool in the Daily Reporting package and in the AFE Designer.
Figure 27: Cost Codes Dialog
- Description: A description of the Item or Service
- Cost Code: Appropriate cost code. This will be something made up by the user.
- Value: The unit cost of the item or service
- Cost Schedule: User can choose the following options from a drop-down menu: Fixed, Daily, Hourly, Variable or Footage
- Group: Appropriate group code. This allows the user to see which costs are associated with the same group.
- Type: User can choose the following options from a drop-down menu: Tangible, Intangible or Consumable
- Vendor: Enter the vendor’s name. This allows the user to group costs by vendor.
The cost code profile can be exported as a .mdb file using the Export button, and the Import button can be used to import cost code profiles.
If any cost codes have been sent to the well using the Bid Sheet tool, the name of the bid will appear in the Linked Bid box.
The Search box can be used to filter the results table. The Update from remote button allows the user to pull in cost codes from a bid sheet on a remote server.
Figure 28: Update from remote
To access bid sheets the operator must exist on both the local and the remote server. The user must also have recently connected to the remote server via the Real Time Data Exchange or Remote Data Fetch.
The Set to Default button will set the cost codes to match the values entered in the Activity / Cost Code Defaults in the main interface Tools menu. The Import from Oasis button allows the user to import cost codes from an external Oasis ERP database.
Once complete, the data entered in this section will be available to select in the Daily Costs section of the Daily Reports and also in the AFE Designer.
The window can also be locked using the checkbox in the bottom left. When locked it is not possible to change any of the data in the window. If a password has been set in the associated Operator Properties, it will need to be entered before the window can be unlocked.
This option can be accessed via the database navigator menu or directly from the Daily Reporting dialog. Note that when accessing via the database navigator menu, the Phase Codes option will only be available to select from Operator Level.
These phase codes are used in the Daily Activities section of the Daily Reporting package and utilised for KPI Tracking Graphs and the Depth v Time Chart. Phases can be created and edited here.
Figure 29: Well Phases Dialog
The Set to Default button will set the Phase codes to match the values entered in the Activity / Cost Code Defaults in the main interface Tools menu.
The window can also be locked using the checkbox in the bottom left. When locked it is not possible to change any of the data in the window. If a password has been set in the associated Operator Properties, it will need to be entered before the window can be unlocked.
The Daily Reporting section of Well Seeker allows the user to create daily reports for a given well. The Daily Reporting tool is only available for selection at the Actual Well level.
Figure 30: Daily Reports window
The user can access all features of the daily reporting module via either the menus, the toolbar or the main user interface itself. The figure below details the functions of the DDR toolbar. All the options available via the toolbar are also available from the various menus at the top of the page.
Figure 31: Daily Reports toolbar
Figure 32: DDR File Menu
Add daily report: Creates a new daily report.
Delete report: Deletes the currently selected report.
Last report: Selects the last daily report.
First report: Selects the first daily report.
Export cost data to Oasis: Exports cost data to an external Oasis ERP database. The Oasis endpoint credentials need to be set up in main interface File menu..
Save: Saves any changes to the daily report.
Import Pason Activity Data: Imports activity data (e.g. WOB, depth, ROP, etc) from a Pason file.
Reload Reports: Updates all daily reports. This is most useful when accessing an SQL database which is being regularly updated from the field.
Print BHA: Prints the BHA which is assigned to the daily report being displayed in the main user interface at the time.
Print DDR: Prints the currently selected daily report as an Excel file.
Print Company Mans Report: Prints the currently selected daily report as a Company Mans Report in Excel format. Turn on Show Company Man Report Options in the Report Options menu to activate the parts of the daily report interface that are used in the Company Mans Report.
Print Cost Reports: The Print Cost Reports submenu gives the user access to all cost related reports.
Figure 33: Print Cost Reports submenu
The Print Cost Reports Submenu contains the below items:
- Print Daily Cost: Prints the daily cost associated with the selected Daily Report as an Excel file.
- Print Well Cost: Prints ALL the daily cost information for the actual well as a single Excel file.
- Print Invoice Date Range: Allows the user to print versions of the Well Cost (Standard Invoice), Grouped Invoice and Cost Tracking report that are restricted to a specified date range.
Figure 34: Invoice Date Range
The user should enter the desired date ranges in the table. The Print checkbox can be used to enable or disable the selected range. The user should then select the report type and file format from the dropdown boxes and select Print to print the report. The Save button will save the entered settings.
- Print Field Invoice Grouped: Prints a field invoice, where all associated individual costs are grouped together. If for example on a 10 day well the same cost appears each day (operating @ $1,000), all of these would be grouped together with the date range and the total cost ($10,000). Note, only costs which are entered over consecutive days are grouped together. In a situation where there is a day, or several days where a given cost does not appear, then an additional line will be added to the report.
- Print Cost Tracking: Prints a report that lists all cost codes for the well, and then marks on which days they were used.
- Print Filtered Cost Report: Prints a Well Cost report that can be filtered to only show the cost codes that the user wants.
Figure 35: Print Filtered Cost Report
The user should select the cost costs that they wish to include and then click the Print button to print the report.
The Search box can be used to filter the results table. The Update from remote button allows the user to pull in cost codes from a bid sheet on a remote server.
Figure 36: Update from remote
To access bid sheets the operator must exist on both the local and the remote server. The user must also have recently connected to the remote server via the Real Time Data Exchange or Remote Data Fetch.
Print Tool and Personnel Tracking: Prints an excel report that lists all items in the Tool Inventory and the DD and MWD personnel for the well. The report will show which days the tools were in hole and the personnel were on site. It also totals up the number of days each tool was in hole and on locations, and totals the number of days each personnel member was on site.
Print EOWR: Prints an End of Well Report in Excel format. The user can select what data they wish to be included in the EOWR via the Report Options menu.
Print Tool Utilization: Prints a tool utilisation report in Excel format. The tool utilisation report lists every BHA component used in the well, along with the circulating hours, drilling hours, BRT hours and the runs in which each component was used. Note, that only tools with a serial number entered in the component details section of the relevant BHA will be included in this report.
Print Shipping Ticket: Opens the Shipping Ticket dialog, from which a shipping ticket can be setup and printed. See Section 13.8 – Shipping Ticket for more details.
Print Slide Sheet: Prints the slide sheet in excel format for the BHA selected in the currently active daily report.
Print RVDS Slide Sheet: Prints the RVDS slide sheet in excel format for the BHA selected in the currently active daily report. This slide sheet is not associated with the standard slide sheet and requires a separate license to access.
Print Personnel Utilization: Prints a personnel utilization report including Name, Position, Date and time of arrival and departure and total days / hours on site.
Print PDF Reports: Allows the user to print PDF versions of the above reports. It also gives quick access to PDF versions of reports found in other reporting modules such as the performance reports from the Drill String editor. Additionally, the user can print out a Certification Report and a Certified Survey Listing.
Create Morning Report Package: Creates a zipped folder which contains a copy of the current database and an excel morning report. The morning report contains the following tabs: Summary, Well Summary, Personnel Report, Field Invoice, Grouped Invoice, Tool Inventory, Tool Utilization, Depth vs Time, Activity Summary chart, Phase Summary chart, Footage per Day chart, Footage per Phase chart, Survey Report, all Daily Reports, all BHA’s, all BHA Performance Reports, all Daily Cost Reports.
Report Colours: Allows the user to select the background colour for all excel reports generated in Well Seeker. This option is linked to the excel report colour option in the Report Manager. When the colour is changed in either of these locations, the other will update to match automatically.
Select Merge PDF File: Allows the user to add an external PDF document to the PDF End of Well Report. User should select the PDF file in the dialog box that opens, and then click on the Open button. The external document will be added to the biggening of the EOWR, after the cover page.
Clear Merge PDF File: If a Merge PDF file has been selected, this option clears the selection.
Exit: Closes the Daily Report Dialog
Figure 37: DDR View Menu
Pump Data: Opens the Pump Data dialog. See Section 6.12 – Pump Data.
Daily Cost: Opens the Daily Cost dialog. See Section 6.11 – Daily Costs.
Next Report: Selects the next day’s report from the currently selected report.
Previous Report: Selects the previous day’s report from the currently selected report.
KPI Tracking: Opens the KPI (Key Performance Indicator) Tracking dialog. See Section 6.13 – KPI Tracking Graphs.
Depth v Time graph: Opens the Time v Depth dialog. See Section 6.14 – Depth v Time graph.
Mud chemical usage: Opens the Mud Chemical Usage window. See Section 6.10 – Mud Chemical Usage.
Well Statistics: Opens the Well Statistics dialog. See Section 6.15 – Well Statistics.
Figure 38: DDR Report Options Menu
Copy Previous Report: Gives the user the option to copy certain information (well data & personnel, Fluids and Drilling Parameters details) from the current report to the next new report when the Add Daily Report button is pressed.
Copy Previous Report Costs: Gives the user the option to copy the daily costs from the current report to the next new report when the Add Daily Report button is pressed.
Report Hours: Allows the user to set the number of decimal places that time in hours is reported to in reports.
Daily Report: Allows the user to select whether to include the following data in body of the Daily Report. Toggling these options on/off will add/remove the relevant items from the daily report when it is printed using the Print Report button. If there is no data available, the section will not be included regardless of whether the section is toggled on/off:
- Include BHA: Includes the most recently used BHA for that day. Data for the BHA is taken from the Drill String Editor (2.0 - Drill String Editor).
- Include Surveys: The daily report will check the depths in the Daily Activity section against the surveys in the actual wellbore for the well. Any surveys that fall within that day’s drilling will be included in a table.
- Include Pump Data: Adds data from the Pump Data dialog (6.12 – Pump Data).
- Include Mud Chemical Usage: Adds data taken from the Mud Chemical Usage (6.10 – Mud Chemical Usage) and Mud Chemical Inventory (13.0 - Mud Chemical Inventory).
- Include Daily Costs: Adds data from the Daily Costs dialog (6.11 – Daily Costs).
- Include MWD Data: MWD Data is taken from the MWD Parameters dialog (6.9 – MWD Parameters) and the Drill String Editor (2.0 - Drill String Editor), specifically the component details of the MWD/LWD component.
- Include Sign Off Section: Adds a section at the bottom of the report where the creators and approvers of the report can put their signature.
- Show activity description of code in DDR: Toggling this on will cause the Code column in the Daily Activity section to show the full description of the activity code, as opposed to just the code number.
Figure 39: Daily Report Submenu
EOWR – The End of Well Report (EOWR) is a collection of other reports from the Reporting module. The EOWR submenu allows the user to select which reports are included in the EOWR report when it is printed using the Print EOWR button in the File Menu.
Figure 40: EOWR Submenu
The option Include Section Separators only applies to the PDF version of the EOWR. It adds title pages between each report included in the EOWR.
Date Format: Allows the user to choose between DD/MM/YY and MM/DD/YY (default) date formats.
Location: Select between USA, Canada, and Rest of the World. This toggles the headings in the Well Details section of the Daily Reports Dialog between State and County (USA), Province and AFE (Canada) and Region and Country (Rest of the World).
Additional Daily Report Options: This submenu only applies to Excel format DDRs. It allows the user to add other reports from the Reporting module to the DDR when it is printed using the Print DDR button in the File Menu.
Figure 41: Additional Daily Report Options submenu
- Include Slide Sheet with DDR: When selected, an additional tab will be included in the generated DDR which includes the Slide Sheet.
- Include Costs with DDR: When selected, an additional tab will be included in the generated DDR which includes the Daily Costs.
- Include BHA with DDR: When selected, an additional tab will be included in the generated DDR which includes the BHA.
- Include Survey Report with DDR: When selected, an additional tab will be included in the generated DDR which includes the Survey Report.
- Include Inventory with DDR: When selected, an additional tab will be included in the generated DDR which includes the Inventory.
Set Default Activity Code / Description: If the user uses the Get DDR from Run Sheet button to populate the Daily Activity Section, Well Seeker will fill in any time gaps with a default activity code and description. The code and description can be edited here.
Figure 42: Default Activity Code window
Get Slide Rotate Hours from Activity: With this option selected the Slide Drill Run, Slide Hours Run, Rotary Hours Run, Circulating Hours Run and BRT Hrs will be automatically calculated in the drilling summary section on the main user interface, based upon the Activity selection in the Daily Activity section of the Daily Reports Dialog. The only exception to this is the BRT Hrs, which use the date and time entered in the Drill String Editor and the Performance report as the point which the assembly goes below rotary table. With this option unselected these details can be input manually by the user.
Auto Update Motor Report Params: The Motor Report has a Get Data from DDR function that will pull in the DDR Drilling Parameters from relevant DDRs. Once a Motor Report has been populated this way, turning on the Auto Update Motor Report Params option will keep the Motor Report updated if any of the DDR Drilling Parameters are changed.
Auto Update BHA Hours on save: When selected, this option automatically updates the BRT Hrs, Drlg/Circ Hrs, Rotary and Slide Hrs in the motor Performance Report.
Morning Report Package:
Figure 43: Morning Report Package submenu
- Open email with morning report package: When selected, if the user chooses to Create a morning report package via the file menu, instead of the option to save the zipped folder, Well Seeker will open an email with the zipped folder attached.
- Include EOWR as part of ZIP file: Toggling this option on will include an EOWR in excel format in the morning report package zip file.
- Include database in package: Toggling this option on will include the currently selected Well Seeker database as part of the morning report package zip file.
Reporting Period 06:00 – 06:00: When this option is toggled on, printing a DDR will create a report with daily activities that are reported from 06:00 to 06:00 instead of midnight to midnight. Note that this does not change the time period for activities in the DDR main user interface.
Include day gaps in grouped cost report: By default, the Grouped Invoice groups each cost starting from the first day to the last day it is included in the Daily Costs, and ignores any days in between where the cost is not included. Toggling on this option will split costs up to show where a cost has missing days.
Include phase gaps in footage per day: If there is a time gap in the daily reports – for example there is a break in operations so there are a few dates without reports assigned – then by default the Footage Per Day KPI chart will cut the missing days out. If this option is toggled on, the tap gap will be preserved in the chart.
Toolbar Prints PDF Reports: Changes the Print Report, Print Daily Cost, Print Well Cost, Tool Utilization Report, Print Shipping Ticket, Print Slide Sheet and Print EOWR functions on the toolbar to print their reports in PDF format instead of Excel. This also changes their matching functions in the File menu.
Use dropdown list for personnel: If this option is toggled on, the Name fields in the Well Data & Personnel window can be populated using a dropdown box instead of manually entering names into the fields. The dropdown box is populated using the Personnel Details tool in the main interface Tools menu.
Use dropdown list for Rig: If this option is toggled on, the Rig field in the Well Data & Personnel window can be populated using a dropdown box instead of manually entering a rig name into the field. The dropdown box is populated using the Rig Names tool in the main interface Tools menu.
Show company man report options: Toggling this option on will add extra fields to the Fluids section, Drilling Parameters section and the Well Data and Personnel window, which are included in the Company Man’s Report.
Include mud chemical costs in invoice: If this option is toggled on, mud chemicals will have their costs included when displayed in reports.
Group cost reports by BHA: When this option is toggled on, the Field Invoiced Grouped report will group costs by BHA and date rather than just by date.
Include all BHA’s for 24hr summary: If this option is toggled off, the 24-hour Drilling Summary section in the DDR only shows stats for the most recent BHA. If it is toggled on the 24-hour Drilling Summary section will show all BHAs used that day.
Circ hours includes drilling hours: This option relates to the Total Circulating/BRT hours statistic in the Run Data section of the PDF BHA Performance Report, which is accessed by opening the File menu and selecting Print PDF Reports > Print BHA Performance Report. If this option is toggled on, the statistic shows the Total Circulating and Drilling Hours/BRT hours.
Figure 44: DDR Well Data Menu
Well Data and personnel: Opens the Well Data & Personnel window. See Section 6.8 – Well Data & Personnel.
MWD Parameters: Opens the MWD Parameters window. See Section 6.9 – MWD Parameters.
Figure 45: DDR Tools Menu
Drill String Editor: Opens the Drill String Editor. See Section 2.0 - Drill String Editor.
Phase Codes: Opens the Phase Codes window. See Section 5.0 - Phase Codes.
Cost Codes: Opens the Cost Codes window. See Section 4.0 - Cost Codes.
Activity Codes: Opens the Activity Codes window. See Section
Shipping Addresses: Opens the Shipping Addresses window. See Section 8.0 – Shipping Addresses.
Pipe Tally: Opens the Pipe Tally window. See Section 10.0 – Pipe Tally.
Tool Inventory: Opens the Tool Inventory window. See Section 7.0 – Tool Inventory.
Mud chemical inventory: Opens the Mud Chemical Inventory. See Section 13.0 - Mud Chemical Inventory.
RT Data Exchange: Opens the Real Time Data Exchange window.
Clear Personnel Names: This option will delete all names from the Personnel section in the Well Data and Personnel window for every day in the current Daily Reports window.
Figure 46: DDR Data Validation Menu
Update activity descriptions from slide sheet all reports: Performs the below Update activity descriptions from slide sheet function but for every report in the Daily Reports window.
Update activity descriptions from slide sheet: Updates the description for slide drilling and rotary drilling activities in the current report. Well Seeker will use drilling parameters recorded in the slide sheet to generate a generic description for each row. Note that a BHA must be selected for each row for this function to work.
Check activity against slide sheet all reports: Performs the below Check activity against slide sheet function but for every report in the Daily Reports window.
Check activity against slide sheet: Selecting this option compares the daily activity grid on the selected report with the associated slide sheet. Well Seeker will highlight any discrepancies between the two and the user can then decide if any adjustments need to be made.
Get drilling params from slide sheet all reports: Performs the below Get drilling params from slide sheet function but for every report in the Daily Reports window.
Get drilling params from slide sheet: This option will populate the Drilling Parameters section using drilling parameters recorded in the slide sheet. For this function to work, there must be at least one row in the report that has a BHA selected and the date for the report must be inside the date range of the slide sheet for that BHA.
Highlight Activity Lines: When selected the following lines will be automatically highlighted in the Daily Activity Grid:
- Any rotary drilling activity will be highlighted Blue
- Any slide drilling activity will be highlighted Green
- Picking up or Laying down BHA will be highlighted Yellow
- Any repair activity will be highlighted Red
Zero RPM for all slides on slide sheet: This option will set the RPM value to zero for slide records in the slide sheet. Note that this will affect ALL slide sheets that are associated with the same actual well as the daily report, and cannot be undone.
Round Depths: This option will round all Start Depth and End Depth records in the current report to the nearest whole number.
The main user interface is where the user records all the relevant information relating to the day’s activities. It is split into 5 different sections which are discussed in detail in the below sections.
Figure 47: DDR Main User Interface
Figure 48: Report Selection Menu
This section can be used to navigate through existing reports. The dropdown box on the left can be used to select the desired report from a list in chronological order. The calendar to the right is used to assign a date to the report. Only one report can be assigned to each date.
Selecting the Calculate button recalculates BRT hours and slide rotate distances from the daily activity entered.
Selecting the Get DDR from Run Sheet radio button will update the Daily Activity section with data which has already been populated in the Slide Sheet for the selected day.
Prior to selecting Get DDR from Run Sheet button select the BHA and Phase in the Daily Activity grid and set the Default Activity Code via the Report Options Menu. Then select the Get DDR from Run Sheet button. This will ensure all imported entries will have the same BHA and Phase as the start row initially, which saves the user manually selecting these for each row. Data will only be populated from the slide sheet that has the same date and legitimate time stamps as the daily report in question.
Any gaps between the end and start time on adjacent rows in the slide sheet will be added in the daily activity section as a separate row, with the activity and description that the user set for the Default Activity Code. For example, in the below slide sheet, Row 1 has an end time of 17:10, and row 2 has a start time of 17:15. This 5 minute gap will be populated in the daily activity section as start time 17:10, end time 17:15, activity 5A: Circulating (in this example this is the activity set as the default). The activity can be edited if required and the time can be further subdivided by right clicking on the row and selecting insert row, if more than one thing happened over this time period e.g. rig repair etc.
Figure 49: Get DDR from Run Sheet Example
This function allows the user to update the daily report from the Run sheet incrementally. For example, the user selects Get DDR from Run Sheet when the run sheet has data populated up to 08:00 on the same day as the daily report in question. From 00:00 – 08:00 the Daily Activity section will populate with the data from the run sheet. The user may wish to make some small changes to the details if they so wish and save these changes in the Daily Reports dialog. The user then updates the slide sheet with data up to 15:00. The user selects Get DDR from Run Sheet and only the additional data from the end of the existing time stamp in Daily Activity to the end of the time stamp in the slide sheet is added to the Daily Activity section. The data previously input from 00:00-08:00 is not overwritten. This allows the user to update their report from the slide sheet throughout the workday and edit any additional data within the Daily Reports dialog. For more information on Slide Sheets see Section 11.0 – Slide Sheet.
Selecting the Get Params radio button will automatically populate the Drilling Parameters section of the main user interface with the relevant data taken from the slide sheet. Well Seeker will use the last selected BHA in the day to draw drilling parameters from.
The Well Status dropdown allows the user to assign one of the following options to the well: N/A, Active, Standby, TD, Complete. These options are searchable in the search database dialog and allow the user to quickly find the relevant wells in the database. This is also a searchable option in the well analytics.
The DD Coordinator and MWD Coordinator dropdown boxes allow the user to assign coordinators to the well, which can then be used in KPI and activity tracking. The available names are taken from the Personnel Details tool in the main interface Tools menu.
The DDR Fluids Section can be used to record drilling fluids information for the day, which can then be included in reports.
Figure 50: Fluids Section
- Type – The type of drilling mud currently in the wellbore e.g. Water based, oil based, fresh water etc.
- 600, 300, 200, 100, 6, 3 – The Fann dial readings of the drilling mud.
- PV – The mud plastic viscosity.
- YP – The mud yield point.
- Weight – The mud density.
- Viscosity – Viscosity of the mud.
- Temp – Temperature of the mud
- 10s Gel – The 10 second Gel strength of the mud.
- Solids % - The % volume of the mud made up of solids.
- Sand % - The % volume of the mud made up of sand.
- Chlorides – The chloride content of the mud.
- API Fluid Loss – Filtrate rate of the mud according to the API filtrate test.
- PH – The acidity of the mud.
- Oil/Water – The % proportions of oil and water in the mud.
The following fields are only available if show company man report options is toggled on in the Report Options menu:
- Weight Out: The density of the mud after circulation.
- Viscosity Out: The viscosity of the mud after circulation.
- WPS: The water phase salinity of the mud.
- HTHP: Filtrate rate of the mud according to the HTHP filtrate test.
- 10m Gel: The 10 minute Gel strength of the mud.
- LCM: The lost circulation material of the mud, if present.
- LGS: The low gravity solid content of the mud.
- MBT: The amount of clay-like material in WBM as measured by an MBT test.
- Oil: The proportion of oil in the drilling fluid as a percentage.
- Water: The proportion of water in the drilling fluid as a percentage.
- ES: The electrical stability of the mud.
- Lime: The lime content of the mud.
- Calcium: The calcium content of the mud.
- PM: The phenolphthalein end point of the mud as measured by a PM test; the amount of acid required to reduce the mud pH to 8.3.
- PF: The phenolphthalein alkalinity of the mud filtrate.
- MF: The methyl orange alkalinity end point of the mud filtrate. The amount of acid required to reduce the mud pH to 4.3
- Liquid: The % volume of the mud made up of liquid.
The drilling parameters can be manually entered by the user or pulled directly from the slide sheet by selecting the Get Params radio button in the report section of the main user interface.
Figure 51: Drilling Parameters
- ROP – The average Rate of Penetration.
- For the 24hr period this value is calculated by subtracting the 00:00 start depth from the end depth and dividing by the sum of the daily slide and rotary hours.
- For the period of the run, this value is calculated by subtracting the start depth run from the end depth and dividing by the sum of the run slide and run rotary hours.
- WOB – The average Weight on Bit during drilling.
- RPM Surface – The average Rotations per Minute recorded at surface during drilling.
- RPM Downhole – The average Rotations per Minute at the bit during drilling. This value is calculated by adding the RPM surface value to the product of the flow rate and the rev/gal value of the motor if there is one present. The rev/gal value of the motor is set in the Drill String Editor. This cell is auto populated.
- Flow Rate – The average flow rate. This value is used in the RPM downhole calculation.
- SPP On Btm – The average standpipe pressure recorded when on bottom and drilling.