Oil & Gas Production Dashboard – Excel Workbook with Live KPIs, PivotCharts & One-Click Refresh

Description
This Oil & Gas Production Dashboard is a complete Excel workbook built for production managers, operations analysts, and small-to-mid-sized operators who need a centralized, visual view of well performance without investing in dedicated production management software. At its core is a single, expandable production data table — one row per well per month — capturing everything from production volume and oil pricing to operating costs, profitability, uptime, and downtime.
Rather than a fixed monthly grid, the data table is built as a native Excel Table, meaning it grows without limit: add new months, new wells, or additional years simply by typing into the row below the last one, with formulas and dropdown validation extending automatically. On top of this foundation sit two distinct layers. The KPIs (Executive Summary) sheet presents 21 metrics — total and by-well production, revenue, average oil price, total and per-barrel operating costs, net operating income, net margin per barrel, well uptime, downtime hours, and CAPEX — all built on SUMIFS/AVERAGEIFS formulas that reference the table directly, so every KPI updates instantly the moment new data is entered, with zero manual steps.

The Dashboard sheet adds four PivotTable-driven charts: Total Production by Well, a dual-axis Monthly Production & Revenue Trend, an Operating Cost Breakdown by category, and a Downtime by Well comparison. Because PivotCharts require a refresh to reflect new data, a one-click "Refresh Charts" button (built with a simple macro) updates all four at once and confirms completion with an on-screen message — giving you the analytical flexibility of PivotCharts without the risk of forgetting to refresh. The workbook is macro-enabled (.xlsm) to support this button, with a security prompt on first open being normal and expected.