Xcel Energy here in Colorado has completed their smart meter rollout and now we have access to 15-minute interval data for all accounts. On one hand, it's amazing for identifying billing errors, demand anomalies, and power quality issues. On the other hand, I'm drowning in data and clients expect me to analyze every single interval. Anyone else finding that smart meter data is both a blessing and a curse? How are you handling the increased workload and client expectations?
Smart meter interval data - blessing or curse for audits?
Scott, I'm dealing with the same thing at Westar Energy in Kansas. The 15-minute data is incredible for catching demand spikes that were missed with monthly readings, but clients now want detailed reports on every single anomaly. I've started using Excel pivot tables and conditional formatting to automatically flag intervals that are 20% above normal patterns. Saves me hours of manual review and helps focus on the real issues.
Georgia Power's smart meters have been a game changer for my audits. Found a $15,000 demand billing error last month where the utility was using peak demand from a day when the customer wasn't even operating due to a power outage. The old mechanical demand register would have reset, but their billing system was pulling from corrupted interval data. Without the detailed timestamps, I never would have caught it.
Eleanor, that's exactly the type of error that makes all this data analysis worthwhile. Xcel Energy here in Minneapolis had a similar issue where their interval data collection system was duplicating certain 15-minute periods, artificially inflating monthly demand readings. Found it on three different accounts totaling over $40,000 in overbilling. The mechanical meters never would have had this type of systematic error.
Christine, that's a great example of how smart meter data can reveal utility billing system bugs. I've found similar issues with Xcel's time-of-use calculations where the meter correctly recorded usage but their billing software applied the wrong rate periods due to daylight saving time transitions. The detailed interval timestamps made it easy to prove the error.
One downside I'm seeing is that some utilities are getting lazy with their billing validation because they assume smart meter data is always accurate. Had a Westar Energy account where a communication failure caused three days of missing intervals, but instead of estimating usage, they just billed zero for those days. Customer got a tiny bill one month then got hammered the next month with catch-up charges and penalties.
Rachel, I've seen that too. The irony is that mechanical meters were more forgiving of communication issues because they stored cumulative readings locally. Smart meters are dependent on the communication infrastructure, and when that fails, you get gaps in the data. Georgia Power has backup cellular modems on critical accounts, but smaller accounts are out of luck if the radio network goes down.
The other challenge is that clients now expect real-time analysis. With mechanical meters, we'd do quarterly or annual audits. Now they want monthly reports with trend analysis, demand forecasting, and anomaly detection. I've had to invest in better software tools and honestly charge more for the enhanced service level. The smart meter data enables better auditing, but it also raises the bar for what clients expect.
Christine, you're absolutely right about client expectations. I've started offering different service tiers - basic audit (same as before), enhanced audit (quarterly interval data review), and premium monitoring (monthly analysis with alerts). The premium service costs 3x more but clients love getting proactive notifications about demand spikes or unusual usage patterns.
That's a smart business model, Scott. I might steal that idea for my Kansas accounts. The key is educating clients about what the interval data can and can't tell us. Some think it's magic and expect us to diagnose equipment problems from meter data alone. Others don't understand why they're paying more for analysis when the utility provides the data for free.
The data quality issues are my biggest frustration. Xcel's smart meters collect great data 95% of the time, but that 5% of corrupted intervals, missed readings, or clock sync errors can really mess up your analysis. With mechanical meters, you knew if the reading was good or bad just by looking at it. Now you need sophisticated validation algorithms to catch data quality problems.