14.0 - Well Analytics
Last updated
Last updated
This option is available at any level in the database tree by right clicking on an item and selecting Reporting > Well Analytics. Alternatively, it can be opened by clicking on the Well Analytics icon () on the Daily Reporting Toolbar. The Well Analytics tool 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 KPI metrics.
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.
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.
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.
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.
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.
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.
The user should choose the report format (Excel or PDF) from the Report Type drop-down. The number in the # Results box 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 Phase and Hole Size columns.
Checking the Inc Non Drlg Hrs checkbox 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.
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.
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 Section 13.4– 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 Well Data & Personnel dialog in the daily report. (See 13.4.8 – Well Data & Personnel)
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 (Section 13.5 – Drill String Editor). A BHA can then be assigned to a well in the Daily Activity section of the Daily Report (Section 13.4.7.6 – 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 Performance Report (Section 13.5.6 – Performance Report Menu).
State: Allows the user to filter their search for wells in the selected US state. The state is assigned in the Well Data & Personnel dialog in the daily report. (See Section 13.4.8 – Well Data & Personnel)
Job Number: Filter the search using job number. The job number is assigned in the Well Data & Personnel dialog in the daily report. (See Section 13.4.8 – Well Data & Personnel)
Directional Company: Filter the search using the directional company. The directional company is assigned in the Well Data & Personnel dialog in the daily report. (See Section 13.4.8 – Well Data & Personnel)
Well Status: Filter the search using the well status. The well status is assigned on the main userinterface in the Daily Reports window.
Rig: Filter the search using the rig used to drill the well. The rig for a well is defined by the selection in the Well Data & Personnel dialog in the daily report.
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 Well Data & Personnel dialog in the daily report.
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 Performance Report.
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 Performance Report 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 Performance Report in the Drill String Editor.
Once the desired filters have been selected, the user can then choose from one of the following options:
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.
Map 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 map is selected.
Colour by Op: Selecting this option will colour wells and plans on the map according to their Operator.
Database QC Report
Clicking on the Print button 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:
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.
How the wells are displayed on the map can be customised using options found on the Search tab (see previous section).
The KPI 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.
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
White Chart: Changes the background of the charts from black to white.
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.
Select KPI: This dropdown menu allows the user to select from the following list of KPI charts:
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.
