Settings
Report Period
Changes are for demonstration only. In production, these drive all KPI calculations.
KPI Thresholds (RAG)
| KPI | On Target | Warning | Critical |
|---|---|---|---|
| EIFR (per 200k hrs) | ≤ 0.50 | ≤ 1.00 | > 1.00 |
| Repeat Finding Rate | < 10% | < 20% | ≥ 20% |
| Overdue CA Rate | < 5% | < 15% | ≥ 15% |
| Haz. Waste Δ vs Avg | ≤ 5% | ≤ 10% | > 10% |
Rig Risk Score Weights
Risk Score = Σ (Factor Count × Weight)
| Factor | Weight |
|---|---|
| L3 Incident | 5 |
| L2 Incident | 3 |
| L1 Incident | 1 |
| Hazardous Condition | 1 |
| Repeat Finding | 2 |
| Rejected Waste Load | 3 |
Implementation Timeline
Phase 1: Planning & Setup
Wk 1–4
Scope & Kickoff, Data Inventory & Access
Done
Phase 2: Development
Wk 5–10
ETL & Database Prep, Dashboard Build
In Progress
Phase 3: Testing & Deploy
Wk 11–14
SIT, UAT & Training, Go-Live
Upcoming
Roles & Responsibilities
Environmental Engineer (HSE)
Defines KPI logic, validates data, updates dashboard
Data Owners
Ensure data quality and timely extraction from source systems
IT Integration Team
Develop ETL pipelines, maintain Power Query/Gateway connections
Rig Managers / Contractors
Timely reporting of incidents, manhours, and waste
Senior Management
Monthly review, drives action on high-risk rigs