Working on a large Westar Energy account in Wichita. Multiple meters, complex demand billing. Anyone have an Excel template that tracks coincident vs non-coincident demand across multiple meters? Getting buried in the calculations.
Excel template for demand analysis - anyone have a good one?
I've got one that handles up to 12 meters. Built it for a Dominion Energy client in Richmond. Calculates peak demand windows, ratchet billing, and seasonal variations. Can email it to you if you want.
Phil, could you send that to me too? Dealing with PSE&G in Newark and their coincident demand calculations are killing me. Manual process is taking forever.
There's a good one floating around from the 2009 conference. Has pivot tables built in for trend analysis. Really helpful for identifying demand anomalies.
I'll put together a template library for the members section. Everyone can contribute their best tools. We need to stop reinventing the wheel every audit.