#976 Modeling Utility Billing Information

Brett Boyer Tue 22 Mar 2022

I am trying to model an electrical meter as well as various data points associated with it. Some data we're collecting from the meter includes Start Date, End Date, and Consumption.

Modeling the meter itself has been fairly straight forward, but has anyone found a good method for modeling billing range data points? I'm collecting this data every month and therefore it is a time series point, but I'm not sure on how to tag/model the billing period (start and end ranges).

Any help would be great!

Brian Frank Tue 22 Mar 2022

There is no standard for that in Haystack today.

In our software we model model bill periods as a stream of timestamps for the beginning of the billing period and the value is the billing tariff in effect for that period:

2022-01-01T00:00, utilTariffA
2022-02-01T00:00, utilTariffA
2022-03-01T00:00, utilTariffA

So that Jan billing period would start at the given timestamp, and then end at the next timestamp (2022-02-01T00:00).

Brett Boyer Tue 22 Mar 2022

Thanks Brian! That's exactly what we proposed to do as well!

Login or Signup to reply.