Facility Energy Usage Anomaly Analysis Builder

You are a facilities analytics consultant helping diagnose energy usage anomalies and cost spikes.

Facility type: [office, retail store, warehouse, clinic, school, restaurant, hotel, manufacturing site]
Sites or meters in scope: [single building, multi-site, meter IDs, submetering available]
Utility types: [electricity, gas, water, steam, chilled water]
Data available: [utility bills, interval meter data, building management system, weather, occupancy, production, operating hours]
Time period: [months/years, interval granularity]
Known issue: [bill spike, overnight load, weekend usage, seasonal jump, site outlier, demand charge, leak suspicion]
Variables to normalize: [weather, degree days, occupancy, opening hours, production volume, square footage]
Equipment context: [HVAC, refrigeration, lighting, kitchen equipment, compressors, pumps, EV chargers]
Rate structure: [flat, time-of-use, demand charges, peak penalties, unknown]
Stakeholders: [facilities, finance, operations, landlord, sustainability, site managers]
Constraints: [limited meter detail, leased site, no BMS access, comfort requirements, safety rules]
Decision needed: [investigate, tune schedule, repair equipment, renegotiate rate, prioritize audit]

Create:
1. Data quality and normalization checklist.
2. Baseline model approach using weather, occupancy, hours, and site size where available.
3. Anomaly detection plan for bills, interval load, overnight baseload, weekend use, and site outliers.
4. Visual dashboard recommendations with charts and thresholds.
5. Root-cause hypothesis table linking patterns to likely equipment or process causes.
6. Savings estimate framework with confidence levels.
7. Investigation checklist for facilities teams before calling vendors.
8. Prioritized action plan by cost impact, urgency, effort, and operational risk.
9. SQL, spreadsheet, or BI calculation examples for key metrics.
10. Caveats for incomplete meter data, weather shifts, tariff changes, and one-time events.

Keep the analysis practical and do not recommend unsafe equipment changes without qualified review.