I've been doing rate analysis manually in Excel for years but I'm drowning in work here in Denver. Xcel Energy has dozens of rate schedules and I'm making too many errors trying to track everything by hand. What commercial software are people using for comprehensive rate analysis? Budget is flexible - accuracy is more important than cost right now.
Rate analysis software recommendations
Carl, I've been using EnergyCAP for about three years now. It's expensive - around $15,000 annually for my practice - but it handles rate modeling really well. Built-in tariff libraries for most major utilities including Xcel. The what-if scenarios and rate comparison features have paid for themselves many times over.
Pete's right about EnergyCAP being pricey but powerful. I use UtilityAnalyzer which is about half the cost. Good rate modeling capabilities and decent tariff coverage. The learning curve is steep though - took me about two months to get comfortable with all the features. TEP rates are complex and it handles them well.
Have you looked at RateAcuity? I started using it last year for Duke Energy accounts and I'm impressed. The interface is more intuitive than some of the older platforms. They have good Xcel Energy coverage Carl. Pricing is around $8,000 annually which seems reasonable for the functionality.
Thanks for the suggestions everyone. David, RateAcuity sounds promising. Do they handle time-of-use rates well? About 60% of my Xcel accounts are on TOU schedules and the manual calculations are killing me. Also wondering about interval data import - can it pull directly from utility portals?
Yes to both Carl. TOU modeling is one of RateAcuity's strengths - really good at peak/off-peak optimization scenarios. They don't pull directly from utility portals but they integrate with UtilityAPI which does the data collection. I've found that combination works well for my workflow.
I've been watching this thread with interest. Currently using a hybrid approach - Excel templates for simple accounts and outsourcing complex rate analysis to a consultant. The outsourcing costs are adding up though. Carl, if you go with one of these platforms I'd love to hear how it works out.
Dana brings up a good point about outsourcing costs. I calculated that I was spending $2,400 monthly on rate analysis consulting. Invested in EnergyCAP last year and it paid for itself in about six months. The accuracy improvement alone was worth it - caught several billing errors I would have missed manually.
Lucille, that ROI timeline sounds reasonable. I'm leaning toward either RateAcuity or EnergyCAP. The $15K for EnergyCAP is steep but if it prevents errors like you mentioned it's probably worth it. Does anyone have experience with their customer support? Implementation looks complex.
EnergyCAP support is excellent Carl. They assigned a dedicated implementation specialist for the first 90 days. The training webinars are comprehensive and they have a good knowledge base. Still, expect at least a month to get fully up to speed. The complexity is real but the capabilities are worth it.
One thing to consider Carl - make sure whatever platform you choose has good reporting capabilities. I spend a lot of time creating client presentations and UtilityAnalyzer's report builder saves me hours every week. The visual rate comparison charts are especially helpful for explaining savings opportunities to clients.
Omar makes a great point about reporting. RateAcuity has really improved their reporting module in recent updates. The before/after analysis charts are professional looking and easy for clients to understand. Carl, both EnergyCAP and RateAcuity offer free demos - definitely worth scheduling calls with both.
Great advice everyone. I've scheduled demos with both EnergyCAP and RateAcuity next week. The reporting capabilities Omar mentioned are crucial - I spend way too much time in PowerPoint right now. Will update the thread after I've seen both platforms in action.
This has been a really valuable discussion. For members considering software investments, don't forget to factor in the learning curve time. Even the best platform won't help if you can't dedicate the hours needed for proper implementation. I've seen too many auditors buy expensive software and never use it effectively.