// Analyze drilling performance and metrics using API 12-digit well numbering system. Use for drilling time analysis, cost benchmarking, well comparison, sidetracks tracking, and drilling efficiency metrics across GOM fields.
[HINT] Download the complete skill directory including SKILL.md and all related files
| name | api12-drilling-analyzer |
| description | Analyze drilling performance and metrics using API 12-digit well numbering system. Use for drilling time analysis, cost benchmarking, well comparison, sidetracks tracking, and drilling efficiency metrics across GOM fields. |
| type | reference |
| capabilities | [] |
| requires | [] |
| tags | [] |
| category | data |
| version | 1.0.0 |
API Number → Parse/Validate → Query BSEE Data → Analyze Drilling Metrics → Benchmark → Report
| Digits | Description | Example |
|---|---|---|
| 1-2 | State Code | 17 = Louisiana (OCS) |
| 3-5 | County/Area Code | 710 = Green Canyon |
| 6-10 | Well Sequence | 49130 |
| 11-12 | Sidetrack Number | 00, 01, 02 |
| 13-14 | Completion Number | 00, 01 (14-digit only) |
from dataclasses import dataclass, field
from datetime import date, timedelta
from typing import Optional, List, Dict, Any
from enum import Enum
import pandas as pd
import re
class APIFormat(Enum):
"""API number format types."""
*See sub-skills for full details.*
### Drilling Analyzer
```python
from typing import List, Dict, Optional
from pathlib import Path
import pandas as pd
import numpy as np
import logging
logger = logging.getLogger(__name__)
class DrillingAnalyzer:
*See sub-skills for full details.*
### Report Generator
```python
import plotly.graph_objects as go
from plotly.subplots import make_subplots
from pathlib import Path
class DrillingReportGenerator:
"""Generate interactive drilling analysis reports."""
def __init__(self, analyzer: DrillingAnalyzer):
"""
*See sub-skills for full details.*
## YAML Configuration
### Drilling Analysis Configuration
```yaml
# config/drilling_analysis.yaml
metadata:
task: drilling_performance_analysis
created: "2024-01-15"
wells:
# List of API numbers to analyze
- api: "177104913000"
*See sub-skills for full details.*
### AFE Configuration
```yaml
# config/afe_estimate.yaml
metadata:
task: afe_estimation
well_name: "Proposed Well A-1"
target_well:
area: "Green Canyon"
block: "640"
*See sub-skills for full details.*
## CLI Usage
### API Number Operations
```bash
# Parse and validate API number
python -m drilling_analyzer parse "177104913001"
# Find all sidetracks for a well
python -m drilling_analyzer sidetracks --api 1771049130
# List wells by area
python -m drilling_analyzer list --area GC --water-depth-min 5000
# Benchmark by area
python -m drilling_analyzer benchmark --by area --output reports/area_benchmark.html
# Benchmark by operator
python -m drilling_analyzer benchmark --by operator --min-wells 3
# Generate AFE estimate
python -m drilling_analyzer afe --td 25000 --water-depth 7000 --area GC
# Generate comprehensive benchmark report
python -m drilling_analyzer report --config config/drilling_analysis.yaml
# Compare specific wells
python -m drilling_analyzer compare --apis 177104913000,177104913001,177590301100
# Generate efficiency metrics
python -m drilling_analyzer efficiency --output reports/efficiency.csv