Meter Data Validation & Anomaly Detection for Utilities
Validate meter readings, detect anomalies, and generate utility compliance reports
What You Can Do
You can upload large meter datasets and have Claude systematically validate readings against ANSI C12.18/C12.19 standards, detect statistical outliers and consumption anomalies, flag potential meter tampering or data transmission errors, and cross-reference current readings against historical customer patterns. Claude generates compliance reports and trend analysis suitable for regulatory audits and billing dispute investigations in minutes instead of manual review hours.
Features
Checks meter readings against C12.18/C12.19 industry compliance requirements and identifies non-conforming data points
Flags outliers using consumption pattern analysis, seasonal variation baselines, and deviation thresholds specific to meter type and customer segment
Detects jumps in consumption, zero readings, duplicate entries, and transmission gaps that indicate potential billing inaccuracies
Compares current readings against 12+ months of customer-specific consumption history to identify tampering signals or installation issues
Produces formatted compliance documentation with data quality metrics, flagged records, remediation recommendations, and validation timestamps
Identifies non-communicating meters, data gaps, and signal transmission failures affecting meter estate coverage
Flags consumption anomalies consistent with meter tampering, bypass, or data manipulation patterns
Groups findings by customer class, geographic region, or meter cohort to identify systemic data quality or infrastructure issues
Example Output
Input: CSV file with 5,000 residential meter readings from Q4 validation
Output Sample:
METER DATA VALIDATION REPORT — Q4 2024
Total Records Processed: 5,000 | Valid: 4,847 | Flagged: 153 (3.1%)
COMPLIANCE STATUS: PASS with remediation required
CRITICAL FINDINGS:
✓ Meter 892341: 340% consumption spike vs. 24-month baseline — flagged for tampering investigation
✓ Meter 561204: Zero readings for 18 consecutive days — non-communicating meter, AMI replacement recommended
✓ Meters 103401-103405: Duplicate transmission entries detected — data transmission error in recent upload batch
✓ Customer segment "multi-family" showing 12% higher anomaly rate — infrastructure upgrade candidate
COMPLIANCE FINDINGS:
✓ 94.2% of flagged readings violate ANSI C12.19 consumption variance thresholds
✓ 23 meters require replacement post-audit
✓ Estimated billing correction: $47,300 across flagged accounts
AUDIT DOCUMENTATION: Validation methodology, statistical thresholds, and flagged record remediation plan included
What's Included
- SKILL.md: Complete validation framework with ANSI C12.18/C12.19 reference standards and anomaly detection protocols
- Meter Validation Checklist: Step-by-step checklist for pre-audit data preparation and flagged record review
- Anomaly Detection Thresholds Template: Configurable deviation percentages, seasonal adjustment factors, and outlier criteria by meter type
- Compliance Report Template: Pre-formatted audit-ready report structure with findings sections, remediation recommendations, and validation timestamps
- Historical Pattern Analysis Worksheet: Framework for establishing consumption baselines and identifying tampering signal patterns
Who It's For
- Utility Metering Engineers — validating meter data quality before billing cycles and regulatory submissions
- Regulatory Compliance Specialists — preparing PUC audit documentation and billing accuracy reviews
- Customer Service Dispute Investigators — analyzing consumption patterns to resolve billing complaints
- AMI/AMR Program Managers — monitoring data quality after meter replacement or infrastructure upgrades
- Utility Operations Analysts — detecting Non-Technical Losses and meter reading anomalies in customer estates
Best For
- Pre-billing meter data validation across 1,000+ meter records
- Regulatory audit preparation and PUC compliance documentation
- Customer billing dispute investigations requiring historical pattern analysis
- Meter tampering and Non-Technical Loss detection workflows
- Post-meter replacement data quality assurance and installation verification
- AMI network health monitoring and non-communicating meter identification
You might also like
You can input historical load patterns, weather data, and external factors to generate accurate 24-72 hour ahead and week-ahead demand forecasts. The skill identifies hidden correlations, flags anomalies, integrates external intelligence (events, economic indicators, industrial schedules), and provides confidence intervals and actionable demand-side response recommendations to support reserve margin planning, generation unit commitment, and resource allocation decisions.
by screenpipe
You can create, list, enable, disable, and run markdown-based AI automation pipes that execute on schedules ranging from every 30 minutes to custom cron expressions. Manage service connections to Telegram, Slack, Discord, and other platforms directly from the CLI, and troubleshoot pipe execution with built-in logging and debugging commands.
by screenpipe
You can rapidly diagnose metering problems by analyzing consumption patterns, detecting statistical anomalies, and interpreting load profiles against baseline data. Claude structures your diagnostic protocols, identifies technical faults, validates billing accuracy, and recommends corrective actions—transforming raw meter data into actionable intelligence that impacts customer satisfaction and revenue assurance.
by diegosouzapw
You can structure comprehensive expert witness testimony that withstands regulatory scrutiny, legal discovery, and cross-examination in state PSC filings and FERC proceedings. This skill helps you balance technical rigor with accessibility for non-engineering commissioners, anticipate opposing counsel's challenges, establish clear methodological foundations, and create testimony that becomes part of the permanent regulatory record. You'll develop direct testimony, rebuttal testimony, surrebuttal testimony, and supplemental testimony across multiple jurisdictions with consistent quality and strategic presentation.
by screenpipe
You can rapidly diagnose root causes of transmission line faults by organizing relay data, SCADA logs, and field reports into coherent analytical narratives. Claude helps you verify protective device coordination, identify protection scheme failures, and rank remediation priorities by risk level. This accelerates outage forensics, supports stakeholder reporting, and flags equipment anomalies that warrant immediate investigation.
by screenpipe
You can rapidly diagnose root causes of meter under-registration and functional failures by analyzing test reports, customer data, and load profiles. The skill quantifies revenue impact across account portfolios, generates make-good calculations for billing adjustments, and produces forensically defensible corrective action plans that meet NERC/WECC/FERC compliance standards—transforming multi-day manual analysis into structured, audit-ready documentation.
by diegosouzapw
You can rapidly evaluate generation unit commitment decisions, load redistribution options, and reserve scheduling during real-time grid operations. This skill synthesizes real-time sensor data, weather patterns, maintenance schedules, and regulatory constraints to surface actionable dispatch recommendations within minutes—handling peak demand periods, contingencies, renewable variability, and transmission constraints where traditional algorithms alone may produce ambiguous or risky outputs.
by screenpipe