Your well portfolio lives in Excel. So does your regulatory risk.
Northwoods Energy tracked every well, APD filing, rig schedule, and surface agreement in spreadsheets. As the portfolio grew, the gaps became operational: no single view of well status, no way to see regulatory risk at a glance, and no audit trail for rig moves. Armely built a custom Wells Inventory Management Application on SharePoint Online that replaced those files with a live, role-controlled system of record.
Does this describe your operations?
- Well data is spread across multiple Excel files with no single view of the portfolio
- You cannot see which wells have APD approvals, denials, or expirations without manual checking
- Rig scheduling requires cross-referencing files and notifying people manually
- New staff or contractors get the same file access as everyone else, with no role separation
- There is no audit trail showing when wells were moved between rigs or who made changes
- Leadership cannot see total acreage, approval rates, or regulatory risk without requesting a report
What Armely did for Northwoods Energy
Northwoods Energy manages a portfolio of wells across multiple PADs and DSUs, with regulatory filings, rig schedules, right-of-way agreements, and surface agreements. All of it was tracked in Excel.
Armely built a custom Wells Inventory Management Application on SharePoint Online with well lifecycle tracking, drag-and-drop rig scheduling, Gantt chart views, a live dashboard showing APD status and acreage, role-based access through Active Directory, and a secure API connection to on-premise SQL Server.
Every well now has a unique identifier from inception to retirement. Regulatory risk is visible at a glance. Rig moves happen in one interface. Leadership sees live data without requesting a report.
At a glance
| Before | After |
|---|---|
| Well data scattered across multiple Excel files with no single portfolio view | One system of record with a unique identifier for every well from inception to retirement |
| APD approvals, denials, and expirations tracked manually across state and federal filings | Live dashboard shows approved, pending, denied, and expiring APDs in real time |
| Rig scheduling required updating multiple files and manually notifying teams | Drag-and-drop rig moves with instant Gantt chart and color-coded status views |
| No audit trail for well moves or data changes | Full move history recorded automatically for every well |
| No role-based access, with everyone working in the same files | Three access tiers through Active Directory: Admin, Contributor, and View-Only |
| Leadership relied on manual reports to see acreage, approvals, and risk | Self-service dashboard with live acreage, approval counts, and expiration alerts |