I've been working on an Excel macro that automatically calculates demand charges based on 15-minute interval data. Works great for We Energies commercial accounts here in Milwaukee. The macro identifies peak demand windows and applies the appropriate rate schedule multipliers. Anyone interested in taking a look? I can share the template if there's interest.
Excel macro for demand calculations - sharing my template
That would be fantastic Linda! I've been doing ComEd demand calculations manually and it's eating up way too much time. Does your macro handle multiple rate schedules or just one specific tariff? Most of my Chicago clients are on different commercial rates.
It handles multiple schedules Yuri. I've built in rate tables for We Energies Cg-1, Cg-2, and Cg-5 tariffs. The macro pulls the appropriate rate based on the account classification you select. Should be easy to modify for ComEd rates - just need to update the lookup tables with their demand charges.
This sounds amazing Linda. I'm dealing with JEA accounts here in Jacksonville and their demand billing can be tricky. Do you validate against the actual utility bills or just calculate what it should be? I've found some utilities have quirks in their billing systems.
Linda, I'd love to see this. Ohio Edison has been a nightmare for demand analysis lately. Are you handling seasonal rates too? Some of our summer/winter demand differentials are significant and I'm tracking them in separate spreadsheets right now.
Rob - I always validate against actual bills. Found several discrepancies that way, including a $3,200 overbilling on a manufacturing client. Jim - yes, seasonal rates are built in. The macro checks the billing period dates and applies summer/winter rates accordingly. I'll clean up the code and post it this weekend.
Looking forward to this Linda! OPPD here in Omaha has some complex demand ratchet provisions that I'm still calculating by hand. If your template handles ratchets that would save me hours every month.
Ken - the current version doesn't handle ratchets but that's definitely on my list for version 2.0. For now it just calculates current month demand charges. I've uploaded the file to my Google Drive - PM me if you want the link. Planning to add ratchet calculations and power factor adjustments next.