Thanks for the spreadsheet. I played around with the numbers a bit and tried to figure out what my peak, shoulder and off-peak usage would be. With the TOU plan, it looks like I would only save $2 to $5 a month with the winter billing rates. With the summer rates, it looks like I'd save between $30 and $40 a month. With the Peak Demand plan, my bill would go up $75 to $90 a month.Here's the Excel spreadsheet. All the inputs are in the blue outlined area. You can input your usage as kw in each time period for the month or as an hourly average through the month (use the dropdown next to the value). The peak values must be greater than the averages (they'll highlight red if they are not). They're only used in the Peak Demand plan calculations. Each plan's values include two sets of cost figures: the first is without the fixed dollar costs that you pay regardless of usage; the second includes the fixed items so it should be very close to what your actual bill would be (except taxes and franchise fees). If you want to include the windsource charge, add 0.015 to "Other per kwh charges" in the constants area.
Hopefully my understanding of the plans is correct and all the numbers are right. Note that it doesn't handle any kind of solar over-production; that seemed difficult to try to model.
I was hoping the savings for the TOU plan would be larger but I'll give it a try and see if it actually results in a lower bill. At any rate, it will be nice to have the bridge meter and get a more accurate idea of my energy usage throughout the month.
Last edited: