Looking for recommendations on software to analyze Arizona Public Service interval data and create load profile reports. Currently using Excel but it's getting unwieldy with multiple accounts and years of 15-minute data. Need something that can handle APS's CSV format and generate professional load duration curves and coincident peak analysis. Budget is around $5,000. What's everyone using for interval data analysis? Preferably something that integrates with utility billing systems for rate optimization studies.
APS load profile analysis software recommendations?
Sarah, I've been using EnergyCAP for interval data analysis with Idaho Power. It handles multiple utility formats including APS and has good load profiling capabilities. The coincident peak analysis tools are solid and it exports nice reports for clients. Cost is about $3,500 annually but includes billing analysis and benchmarking modules. Worth looking at if you're doing a lot of rate optimization work.
For analyzing Connecticut Light & Power data, I use Interval Data Systems' LoadProfiler software. It's specifically designed for utility auditors and handles all the major interval data formats. Great for load duration curves and identifying demand reduction opportunities. Think it's around $4,200 with the utility billing module. Has saved me countless hours compared to Excel spreadsheet analysis.
Sarah, if you're on a tighter budget, check out Energy Lens. It's about $1,800 and handles interval data analysis pretty well. I use it for CPS Energy accounts here in Texas. Not as fancy as the high-end packages but does good load profiling and can import most utility CSV formats. The learning curve is reasonable and it generates decent client reports.
I've tried several packages for NV Energy interval data and ended up with UtilityAnalyzer Pro. Handles complex rate structures well and the load profile visualization tools are excellent for client presentations. About $4,800 but includes training and first year support. The automated peak detection and TOU analysis features alone pay for themselves on large accounts. Definitely worth the investment if you're serious about interval data analysis.