OK, I finally have some code that adds ToU tags to Sense hourly export files, then aggregates the data into daily and billing period summaries, so I can compare against my real PG&E billing data. The fun part is I can also pull out solar and see how much solar is saving me, though I might likely be using a different rate schedule if I didn’t have solar.
Here’s a view on the kWh comparison between my PG&E bills and Sense aggregation.
As I examined in the thread below, my Sense is about 1% optimistic (lower) than my PG&E numbers on an hourly basis, plus I had fair number of network related dropouts WRT Sense, especially within May and June, so this data appears to square with my hourly investigations.
And here’s a view of how much solar has saved me over the past year. Roughly 2K per year on a 15.5K total investment back in 2012. Sure there are better deals today.
Will have to try a comparison using the PG&E standard residential tiered model.