12.0 - Well Analytics

The Well Analytics window can be accessed by right-clicking in the Object Explorer and selecting Reporting > Well Analytics, or by selecting the Analytics option in the Home ribbon. It allows the user to search through their database and select wells based on various search criteria. The user can then plot these wells on google maps or compare them using several Key Performance Indicator (KPI) metrics.

Figure 338: Well Analytics dialog

On the left of the Well Analytics window is the database tree. This tree contains every actual well and well plan in the database. Clicking on the check box beside each well enables them to be included in the Map and KPI tab. The user can select these wells manually or using the filtering tools in the Search tab.

12.1 - Well Analytics Toolbar

12.2 - Well Analytics Menus

12.2.1 - Well Analytics File Menu

Print current chart Excel/PDF: Prints the last viewed KPI chart as an image in an Excel or PDF document.

Print all charts Excel/PDF: Export all KPI charts as images in a single Excel or PDF document,

Export all chart data: Exports all KPI charts as data tables in an Excel document.

Exit: Close the Well Analytics window.

12.2.2 - Well Analytics Database Tree Menu

Expand All: Expands the Database Tree to show every well in the database.

Collapse All: Collapses the Database Tree so that no wells are visible.

Hide Tree: Removes the Database Tree section from the Analytics window so that the user can view the map and the KPI charts easier. Click on Hide Tree again to bring the Database Tree back.

Select Wells: All wells currently in the Wells section, and set as included, will be selected in the Database Tree, allowing them to be used in the Maps and KPI tab.

Deselect Wells: Clears the selections made in the Database Tree.

12.2.3 - Well Analytics Search Database Menu

Search: Any well that matches all the filters will appear in the Wells section.

Clear Results: Clears all wells from the Wells section.

Reset Filters: Clears all search filters.

12.2.4 - Well Analytics KPI Reports Menu

Motor KPI: Once a search has been completed this button may be selected. Creates an excel motor KPI report, containing statistics for all motors used in the filtered wells that appear in the Wells section.

Motor KPI Summary: Once a search has been completed this button may be selected. Creates an excel motor KPI report for the filtered wells that appear in the Wells section. This is like the Motor KPI report but instead of listing individual motors is summarises them by manufacturer, size and state.

MWD KPI: Once a search has been completed this button may be selected. Creates an excel MWD KPI report, containing statistics for all MWD tools used in the filtered wells that appear in the Wells section.

Section KPI: Once a search has been completed this button may be selected. Creates an excel report containing statistics for each drilling phase in the filtered wells that appear in the Wells section.

Revenue Report: Only functions when a Date Range filter has been applied in the Search tab. This report lists every job running on each day inside the date range, along with the total revenue and number of rigs for each day.

Rig Days Report: Only functions when a Date Range filter has been applied in the Search tab. This report lists every job running on each day inside the date range, along with the number of rigs, the 30-day average rigs and the 10-day average rigs for each day.

Personnel Report: Only functions when a Date Range filter has been applied in the Search tab. Creates an excel personnel report for all wells within the date range. This lists all personnel in the database and shows the days that they worked within the set date range.

Rig Days Chart: Displays a chart generated using data from the Rig Days Report.

Revenue Chart: Displays a chart generated using data from the Revenue Report.

Well Ranking: Generates a Well Ranking report from the filtered wells that appear in the Wells section. This report shows which out of the selected wells performed the best in several different categories, as well as an overall score between 0 and 1 based on the performance of each well over all categories.

Well Ranking Weights: Allows the user to set how much each category affects the overall score of a well in the Well Ranking report. The user should enter a value between 0 and 1 in the Weight column. The user can also exclude a category from affecting the overall score entirely by unchecking the checkbox in the Included column.

Figure 339: Well Ranking Weights

Drill Records: This option is only available when connected to a remote server database. Opens the Drilling Records dialog, which allows the user to create a report containing rankings of the wells that have performed best in selected KPIs.

Figure 340: Drilling Records dialog

The user should choose the report format (Excel or PDF) from the Report Type drop-down. The number in the # Resultsbox sets how many results are in each ranking – for example a value of 5 will mean each ranking lists the top 5 wells.

The user should select the KPIs that they want to create rankings for in the KPI column. Currently there are four KPIs to choose from – fastest section, fastest ROP, longest section, and max footage per day. The user can optionally limit each ranking to a single phase and/or hole size if they wish, by choosing a value from the dropdowns in the Phaseand Hole Size columns.

Checking the Inc Non Drlg Hrscheckbox will factor non-drilling hours into the rankings. The Active column can be toggled off to disable a ranking and remove it from the report.

Once the user is happy with their setup, they can generate the report by clicking on the Create button.

Get well list from search grid: If this option is toggled on, reports generated from the KPI Reports Menu will be populated with wells in the Wells section. If it is toggled off, the reports will be populated by the wells that have been selected in the Database Tree.

12.2.5 - Well Analytics Depth V Days Menu

Remove Flat Time at Start: Removes any time when there is no change in depth at the start of the Depth V Days KPI chart. The Generate KPI button on the KPI Tab needs to be clicked before any changes are applied.

Remove all flat time: Removes any time when there is no change in depth at any point in the Depth V Days KPI chart. The Generate KPI button on the KPI Tab needs to be clicked before any changes are applied.

Print tabular Depth V Days: Exports the data in the Depth V Days chart as a table in Excel format. The Generate KPI button on the KPI Tab needs to be clicked before this function will work.

12.3 - Search Tab

Figure 341: Well Analytics search tab

The search tab contains several options which can be used to quickly filter through the data in the database tree to find the relevant information. Each field must be activated using the checkbox to its right.

Operator: Allows the user to filter their search for a given operator.

Date Range:Allows the user to filter their search based on start and end dates. The start and end dates which Well Seeker searches for are the ones associated with the daily reports for each individual well. (See Daily Reporting).

Distance from Well: Enter a decimal latitude and longitude into the Lat and Long boxes, and then a radius into the Dist box. Well Seeker will include any wells in the database which are the radius entered. The user can also select a well from the dropdown boxes – this will populate the Lat and Long boxes with the surface location of the selected well.

Drilling Parameters: Allows the user to search for wells that contain the entered drilling parameter. Currently only RPM is available.

Formation: Allows the user to filter their search for wells that are targeting a selected formation. The formation which Well Seeker searches for is the one entered in the Job Data dialog. (Job Data)

Assembly Type: Allows the user to filter their search for wells with the selected BHA type. Options available from the drop-down menu are Motor, RSS and Rotary. A BHA is defined as a Motor or RSS BHA if there is a motor or RSS present for the BHA in the Drill String Editor (Drill String Editor). A BHA can then be assigned to a well in the Daily Activity section of the Daily Report (DDR Daily Activity).

Failure: Allows the user to filter their search for wells which had a BHA failure. The failure type can be MWD, Motor or Any. Whether or not a BHA failed is defined in the Run Data dialog. (Drill String Editor)

State: Allows the user to filter their search for wells in the selected US state. The state is assigned in the Job Data dialog. (Job Data)

Job Number: Filter the search using job number. The job number is assigned in the Job Data dialog. (Job Data).)

Directional Company: Filter the search using the directional company. The directional company is assigned in the Job Data dialog. (Job Data)

Well Status: Filter the search using the well status. The well status is assigned on the main user interface in the Job Data dialog. (Job Data)

Rig: Filter the search using the rig used to drill the well. The rig for a well is defined by the selection in the Job Data dialog. (Job Data)

Motor SN: Filter the search for a particular mud motor serial number. The mud motor serial number is defined by the SN of the motor in the Drill String Editor.

County: Filter the search using the county. The county that a well is in is defined by the selection in the Job Data dialog. (Job Data)

Motor Make: Filter the search using the motor make. The motor make is taken from the motor component details in the Drill String Editor.

Bit Make: Filter the search using the bit make. The bit make is taken from the motor component details in the Drill String Editor.

LIH (Lost in Hole): Allows the user to filter their search for failures that resulted in a BHA being lost in hole. For a BHA to be flagged as LIH, the LIH checkbox must be checked in the Failure Information section of the Run Data dialog. (Drill String Editor)

Hole Size: Allows the user to filter their search for wells that drilled a section with the selected hole size. The hole size is set by the OD of the bit in the Drill String Editor.

MWD Type: Allows the user to search by the selected MWD type. This is set on the main user interface in the Daily Reports window.

Drive Type: Allows the user to search by the selected drive type. This is set on the main user interface in the Daily Reports window.

Motor Config: Allows the user to search by the selected motor lobes and stages. These are set in the Component Properties section for the motor in the Drill String Editor.

Serial Number: Allows the user to search for wells containing tools with the matching serial number. The serial number is set in the Component Properties section for any tool in the Drill String Editor. Serial numbers entered in the Tool Inventory do not count.

Incidents/Failures: Searches for wells that have the Failed option checked in the Run Data dialog in the Drill String Editor. If CLOSED is selected in the drop-down box, then the results will only show wells where the Closed option has been checked in the Performance Report. If OPEN is selected then the results will only show wells where the Closed option has NOT been checked.

Chargeback: Searches for wells that have any text entered in the Chargeback section in the Run Data dialog in the Drill String Editor.

District: Filter the search using the district. The district that a well is in is defined by the selection in the Job Data dialog. (Job Data)

Once the desired filters have been selected, the user can then choose from one of the following options:

Figure 342: Well Analytics action buttons

• Search: Any well that matches all the filters will appear in the Wells section below.

• Clear Results: Clears all wells from the Wells section.

• Reset Filters: Clears all search filters.

• Select Wells: All wells currently in the Wells section, and set as included, will be selected in the Database Tree, allowing them to be used in the Maps and KPI tab.

• Deselect Wells: Clears the selections made in the Database Tree.

• Check All: Toggles the Include column on for all wells in the Wells section. Wells with Include toggled off will not be selected when the Select Wells button is clicked.

• Uncheck all: Toggles the Include column off for all wells in the Wells section. Wells with Include toggled off will not be selected when the Select Wells button is clicked.

• Open Job: Selecting a well in the Wells section and then clicking Open Job will close the Analytics window and open the well in the main database tree.

• Ignore Offsets: If this option is toggled on, when the Search button is clicked, Well Seeker will only return wells that have Daily Reporting data recorded.

Options:

• Well Paths: Displays the well path of selected wells on the Map tab. Note that this will always show the surveys but will only show the plans if the Show planned well paths option is selected as well.

• Lease Lines: If any of the selected wells have lease lines associated with them, selecting this option will display them on the map.

• Well Names: Displays the well names of selected wells on the map. Note, the names will display at the wellhead.

• Planned wells: Displays the well paths of selected plans on the map, so long as Show well paths on mapis selected.

• Colour by Op: Selecting this option will colour wells and plans on the map according to their Operator.

  

  Figure 343: Search Tab options

Database QC Report: Clicking on the Printbutton in the Database QC Report section will generate an Excel spreadsheet that contains statistics for all wells selected in the Database Tree. The QC report contains the following information:

12.4 - Map Tab

The Map tab displays the selected wells on Google Maps. Surveys are displayed in Blue and Well Plans are displayed in Green. Note that Google Maps references the WGS 84 Mercator projection, so any wells referenced to a CRS which does not use this projection, may be offset slightly on the map.

Figure 344: Well Analytics maps tab

How the wells are displayed on the map can be customised using options found on the Search tab (see previous section).

12.5 - KPI Tab

The KPI (Key Performance Indicator) tab allows the user to quickly generate a variety of KPI charts for the selected wells. The data used to generate these charts is taken from the daily reports and BHA’s associated with each of these wells.

Figure 345: Well Analytics KPI tab

Generate KPI: Generates all the KPI charts for the selected wells.

Export: Creates an excel document containing the data used to generate the currently selected chart

Sanitised: Instantly sanitises the names displayed along the X axis of the charts.

Short Names: Shortens names in the X axis be removing the rig name.

Sort Data: Sorts the data in the chart so that the smallest value is on the left and the largest on the right.

12.5.1 - Select KPI

This dropdown menu allows the user to select from the following list of KPI charts:

Slide & Rotation Footage Depth V Time Failure Analysis Directional Cost Per Foot Well Cost Per Foot BHA Details Detailed Cost Breakdown Wells by Formation Activity Comparison Wells by Rig Parameter Comparison Average Interval Cost by Quarter Footage per Day by Operator	Wells by Directional Company Wells by Motor Make Wells by Bit Make ROP & Footage by Formation ROP & Footage by Directional Company ROP & Footage by Motor Make ROP & Footage by Bit Make ROP & Footage by Hole Size Phase Comparison ROP & Footage by Rig Well / Section Performance Driller Performance Footage per Day by Rig BHA reason pulled summary

Phase: When in the appropriate KPI chart, the user can select to either view the Well data or any one of the available Phases from this dropdown menu.

12.5.2 - Context Menu

Right click in the KPI chart area will open the context menu and double click will open the Customization dialog, where the user can customize the main title and subtitle, viewing style, grid lines, font size etc.

Viewing Style: Allows the user to select the desired Chart style.

Font Size: Allows the user to select the desired font size, which will affect all fonts on the chart including title and axis labels. Large, Medium or Small.

Show Legend: Allows the user to toggle the chart legend on and off.

Plotting Method: Allows the user to select the way the line is plotted: Point, Line, Bar, Points + Line, Spline Area.

Data Shadows: Allows the user to select between off, shadow and 3D.

Grid Options: Allows the user to change the grid options in the chart.

Graph and/or Table: Allows the user to view the chart only, table only or both at the same time.

Point Label Orientation: Allows the user to select the orientation of the X axis series labels.

Mark Data Points: Adds the data points relating to the data labels.

Maximise: Maximises the chart to fill the screen. Escape button exits this view.

Customization Dialog: Opens a dialog that allows the user to chart titles, axis min and max values, fonts, line colour and styles.

Export Dialog: Allows the user to Export the chart as an image. The user has 3 options:

Figure 346: Export Dialog

• Clipboard: Click on Exportto send the chart to the clipboard, allowing it to be pasted as an image into another document.

• File: Saves the chart as an image file. Select the image file type from the section at the top. Click on Browse to choose where to save the file on your PC. Click on Export to save the file.

• Printer: Sends the chart to your default printer. Choose the size of the image in the Export Size section and the click on Export to print.