Hi all - Just installed my iron Xcel electric meter to Mqtt and trying to set up my energy dashboard. I have seen great examples of how to set up helpers for on-peak, off peak, mid-peak and holidays. my question is how do I deal with the billing cycles??? Xcel Colorado is not consistant (eg 6 days after start of month) in its offset. According to Xcel The number of days in a billing period vary depending on your billing cycle and days in a
month.
So my question to the community is how do I set up a moving offset each month in the Utility Helper???
Update: I had ChatGBT analyze my billing data and it suggested an algorithmic rule
Algorithmic rule
- Start at the 4th of the month
- Find the first weekday (Mon–Fri)
- If that date is a holiday, move forward to the next business day
- Cap expectation around the 9th–11th in edge cases
This matches ~95%+ of your historical data
Thanks in advance!