The Jobs Timeline
A new job can be created by clicking the green, Create New, button in the top right corner of the browser. The lists of jobs that have been entered into Drakewell can be viewed on a weekly calender under Jobs -> Timeline in the top left navigation panel
Jobs are listed in the Timeline by Job Name and Expected Start and End Dates. Those dates are also represented graphically by an accompanying Timeline graph. On the graph, the Job Start Date is represented by a green circle. The Job End Date is Represented by a red circle. The progress of the job is represented by a green line. The remaining days on the job are presented with a gray, hashed line.
Filtering The Jobs Timeline
By typing in the main search filter field, the Jobs Timeline can be filtered by a number of different job attributes. It also supports searching for a specific phrase by wrapping the search term in quotes (“) or wild card searches by prepending or appending an asterisks (*) to the search term.
There are also more specific sections that can be used to filter the jobs list:
- Job Number
- Job Type
After changes are made in any of the filter selections, clicking the green filter button or pressing “Enter” on your keyboard will cause the list to filter according to the selections.
Any searches that are performed frequently can be bookmarked help so that they can be quickly and easily accessed.
Filtering The Jobs Timeline
By default this list will show all active jobs for the week in the currently selected location in the location switcher help , but by using the available search filters, you can find jobs based off different criteria.
The main Search filter let’s you search any detail of a job. It supports searching for a specific phrase by wrapping the search term in quotes (“) or wild card searches by prepending or appending an asterisks (*) to the search term. The search filter also searches through internal and external notes on the job, which can be helpful in certain scenarios.
Search Filter Examples:
To find all jobs with a start date after a certain date, enter: start_date:>YYYY-MM-DD.
To find all jobs with a start date before a certain date, enter: start_date:<YYYY-MM-DD.
To find all jobs with a start date on or after a certain date, enter start_date:>=YYYY-MM-DD.
To find all jobs with a start date after a certain date and an end date before a certain date, enter: start_date:>YYYY-MM-DD AND end_date:<YYYY-MM-DD.
To find all jobs with a start date between certain dates, enter: _start_date:>=YYYY-MM-DD AND start_date:<=YYYY-MM-DD.
To find all jobs with a planned bottom hole location greater than 20,0000 ft, enter: pbhl:>6096. Since Drakewell stores data in metric units, the user will need to convert 20,000 ft to 6096 m.
To find all jobs with a kick off point greater than 2,000 ft, enter: pbhl:609.6.
To find all jobs with a Measured Depth greater than 10,000 ft, enter: md:>3048.
To find all jobs that have written in the notes section “motor failure,” enter: motor failure.
When the job number, or part of the job number is known, use the Job Number box below the Search box to locate it. The filter will search only the Job Number field based on the input into this box.
Jobs Timeline Export Options
The blue, Exports help button will show a list of available raw data files for export.
All export requests are emailed to the user’s email address associated with the Drakewell account that requests the export. Some exports will take longer to compile and deliver.
The email will have have one or both options for downloading the data results:
- Download Excel File
- Download Composite CSV File
The Excel workbook will contain all relevant information related to the particular export request, separated by sections in different worksheets. The CSV file will contain all relevant information related to the particular export request in a single file.
The following are the specific Jobs Timeline export files available for download:
- Export Jobs
- Export BHAs