Sheets
9
Reading to savings
Free Download
Utility Consumption Anomaly Alert Dashboard
Consultation
We can help decide what should stay in Excel and what should move to a web system, based on site count, owners, dashboard needs, notification rules, and history tracking requirements. We can also adjust only the columns you actually need in your current workbook.
We can tune the columns to match your current workbook.
A free Excel dashboard template for detecting unusual water, electricity, and gas consumption from meter readings, historical averages, and budget thresholds. The same page also shows the matching web system flow.
meter readings
historical average
anomaly alert
budget variance
Alerts
5 levels
Normal to severe
Output
Exception list
Action-oriented
Input example
Find abnormal consumption before the bill arrives
The workbook compares current readings with previous periods, historical averages, and budgets so unusual usage is visible early.
Reading month
May 2026
Electricity
38,600 kWh
Exception
6 meters
Forecast
8,400 over budget
Free Download
See what is inside the Excel version first
A free Excel dashboard template for detecting unusual water, electricity, and gas consumption from meter readings, historical averages, and budget thresholds. Align parameters, owners, categories, and status rules before entering site data.
File
facility_management_utility_consumption_anomaly_dashboard_template_en.xlsx
Sheets
9 sheets
Purpose
Dashboard, energy data input, anomaly detection, closed-loop actions, monthly summary, anomaly rules, scenario library, base settings, instructions
The dashboard summarizes total usage, total cost, anomaly count, high-risk anomalies, open anomalies, and carbon emissions.
Energy data input, anomaly detection, closed-loop actions, and monthly summaries create a complete discovery and follow-up flow.
The anomaly rules, scenario library, and base settings keep thresholds, scenarios, responsible roles, unit prices, and carbon factors consistent.
Align parameters, owners, categories, and status rules before entering site data.
How Excel is used
How utility anomaly detection works in Excel
The workbook is designed so source records, assumptions, analysis, dashboard, and report pages lead to a management decision.
Step 1
Register meters and thresholds
Enter meter type, area, unit, frequency, owner, price, and normal fluctuation threshold.
Step 2
Enter reading records
Record current readings, previous readings, period days, and notes for water, electricity, and gas meters.
Step 3
Compare against history
Calculate usage, daily average, month-over-month change, historical average deviation, and budget variance.
Step 4
Follow up exceptions
Review likely causes and recommended actions such as rereading, leak checks, equipment shutdown checks, or site inspection.