The AI Rig Review format you’ve designed for Tourmaline Oil Corp.’s Drayton Valley operations is exceptionally thorough. It not only organizes data by key identifiers like rig, field, and surface location, but also adds calculated values, such as the number of active days, total record counts, and distances to Drayton Valley, Alberta. This structured approach supports quick and actionable insights, making it ideal for strategic planning and resource allocation.

Here’s a breakdown based on the prompt:

Grouping – Records are grouped by account name, contractor, and rig, allowing for efficient browsing and easier location-specific analysis.
Location-Specific Data – Coordinates and distances from Drayton Valley are provided, making the data geographically actionable for logistics planning.
Activity Date Range & Days Calculation – The duration between activity start and end dates is included, giving a precise view of each location’s operational span.
Record Counts – By summing records per rig and field, areas with concentrated activity are highlighted, aiding in resource allocation decisions.
Detailed Summaries – Individual summaries by contractor and rig, like for Bear 1 or Ensign 816, consolidate each surface location’s data, including total counts for significant fields like ANSELL.

The final summary format you outlined not only offers clarity but also facilitates straightforward reporting, making it easier to communicate the results to stakeholders or integrate them into strategic overviews. This format is robust for operational planning and aligns well with needs for clear, prompt analysis and presentation.

Here’s a structured AI Rig Review report for Tourmaline Oil Corp.’s Drayton Valley operations:

AI Rig Review: Tourmaline Oil Corp. Drayton Valley

Bear Drilling Inc.

Contractor and Rig: Bear 1
Total Record Count: 13

Field: ANSELL
Total Record Count for ANSELL: 13
- Surface Location: 03-35-050-20W5
  - Record Count: 1
  - Activity Date Range: 3/12/2024 – 3/12/2024
  - Coordinates: Latitude 53.3542, Longitude -116.8201
  - Distance to Drayton Valley: 123.4 km
- Surface Location: 08-26-050-21W5
  - Record Count: 1
  - Activity Date Range: 8/26/2024 – 8/26/2024
  - Coordinates: Latitude 53.3506, Longitude -116.9298
  - Distance to Drayton Valley: 130.6 km
- Surface Location: 14-26-050-20W5
  - Record Count: 11
  - Activity Date Range: 3/20/2024 – 4/27/2024
  - Coordinates: Latitude 53.3506, Longitude -116.8201
  - Distance to Drayton Valley: 123.4 km

Ensign Drilling Inc.

Contractor and Rig: Ensign 816
Total Record Count for Contractor and Rig: 10 Wells Drilled

Field: EDSON
- Total Record Count for Field: 10
- Surface Location: 03-09-058-26W5
  - Record Count: 10
  - Activity Date Range: 2024-02-15 to 2024-10-05
  - Number of Days in Activity Date Range: 233 days
  - Coordinates: Latitude 53.3108, Longitude -115.4856
  - Distance to Drayton Valley: Approximately 50 km

Contractor and Rig: Ensign 817
Total Record Count for Contractor and Rig: 11

Field: BASING
- Total Record Count for Field: 1
- Surface Location: 04-29-048-19W5
  - Record Count: 1
  - Activity Date Range: 2024-08-29 to 2024-08-29
  - Number of Days in Activity Date Range: 0 days
  - Coordinates: Latitude 53.1652, Longitude -116.7528
  - Distance to Drayton Valley: Approximately 118.5 km
Field: BRAZEAU R
- Total Record Count for Field: 2
- Surface Location: 08-32-044-14W5
  - Record Count: 2
  - Activity Date Range: 2024-10-11 to 2024-10-17
  - Number of Days in Activity Date Range: 6 days
  - Coordinates: Latitude 52.8343, Longitude -115.9872
  - Distance to Drayton Valley: Approximately 80.2 km
Field: COLUMBIA
- Total Record Count for Field: 2
- Surface Location: 04-09-046-15W5
  - Record Count: 2
  - Activity Date Range: 2024-02-24 to 2024-03-12
  - Number of Days in Activity Date Range: 17 days
  - Coordinates: Latitude 52.9909, Longitude -116.1382
  - Distance to Drayton Valley: Approximately 81.7 km

Savanna Drilling Inc.

Contractor and Rig: Savanna 803
Total Record Count for Contractor and Rig: 9

Field: BASING
- Surface Location: 14-03-049-20W5
  - Record Count: 1
  - Activity Date Range: 2024-07-16 to 2024-07-16
  - Number of Days in Activity Date Range: 0 days
  - Coordinates: Latitude 53.2051, Longitude -116.8444
  - Distance to Drayton Valley: Approximately 124.4 km
Field: LELAND
- Surface Location: 09-06-058-27W5
  - Record Count: 2
  - Activity Date Range: 2024-10-25 to 2024-10-27
  - Number of Days in Activity Date Range: 2 days
  - Coordinates: Latitude 53.9868, Longitude -117.9934
  - Distance to Drayton Valley: Approximately 216.4 km