We're drowning in AMI data from AEP Ohio and need better tools for analysis. Currently using Excel for 15-minute interval analysis but it's getting unwieldy with multiple accounts and years of data. Looking for recommendations on software that can handle large datasets, identify anomalies, and generate reports for utility disputes. What are you all using for smart meter data analysis? Budget is around $5,000-10,000 for something that can handle our client load.
Smart meter interval data analysis - best software tools?
Kevin, we've been using EnergyCAP for about two years now and it's been solid for AMI analysis. Handles PPL Electric's interval data format well and the anomaly detection features have caught billing errors we would have missed manually. Cost was around $8,500 with training. The load profiling tools are excellent for identifying opportunities to switch rate schedules. Their support team actually understands utility billing, which is rare. Worth looking into if you're dealing with multiple Pennsylvania utilities.
We went with UtilityManagement.com's platform for our Cincinnati clients on Duke Energy Ohio. The web-based interface makes it easy to share analysis with clients and the automated bill validation catches errors in real-time. Monthly cost is about $200 per account but it pays for itself when you catch overbilling. The demand forecasting module has been particularly useful for clients considering solar or storage installations. Their Cincinnati data center means fast performance for regional utilities.
CPS Energy here in San Antonio provides their own analysis portal for AMI data, but it's pretty basic. We supplement with PowerTrak Pro which handles multiple utility formats and has excellent reporting capabilities. The initial cost was around $12,000 but handles unlimited accounts. The load shape analysis helped us identify $47,000 in annual savings for a medical center by optimizing their demand patterns. Kevin, if you're dealing with multiple utilities, make sure whatever you choose can handle different interval data formats.
Thanks for the recommendations everyone. I'm leaning toward EnergyCAP based on Sylvia's feedback. The anomaly detection feature sounds like exactly what we need. AEP Ohio's billing has been particularly error-prone since they rolled out their new customer information system last year. Having automated tools to catch discrepancies would save us hours of manual review time. Anyone have experience with their customer service and training program?
Kevin, EnergyCAP's training program is comprehensive. They provided two days of on-site training when we implemented it for our Richmond clients with Dominion Energy. Their support team responds quickly to questions and they update the software regularly to handle new utility formats. We've been using it for three years now and it's been worth every penny. The ROI calculator showed we recovered the software cost within eight months through identified billing errors and rate optimization opportunities.