@schadenfreude, @RTraphan, @rex, @derek.nheiley, @schenkzoola, @stephan.hesmer, @johnhmccauley, @shaver.deyerle, @Craft21, @david1, @tmdatanet, @Bubuski, @jimsar9, @aaron1, @doug1, @noel.hastings, @kevin8, @mike_gessner, @franklyn, @jij.pers, @mikeahechtman, @paul.moceri, @reuben.sterling, @dchurco, @bfach82, @brucewhitneyvt, @gobbel, @benjamin.t.brannon, @brandon.keilman, @dmitrysml777, @TheTrystero
All you guys indicated a very strong need for a way to look at your Sense data with ToU pricing. There’s now a way. I have created two web apps that run off of an industry-wide database of rates, OpenEI. The first web app enables you to upload a monthly or billing period hourly exported Sense CSV, select your ToU plan, then see costs and kWH by Sense device and by ToU period.
https://pgstats.shinyapps.io/UtilityToUCost/
The second web app allows you to visualize the rate table for your rate plan coming out of the OpenEI database. That’s important because I have discovered that some of these rates are out of date. For instance, the May 1 price changes to the PG&E plans haven’t been entered yet.
https://pgstats.shinyapps.io/RatesChecker/
You also might not find your rate plan in my app yet for a variety of reasons, if it includes:
- Demand charges
- Tiering
- Separate buy vs sell pricing
Your rate might not be in the database or wrong if:
- It is relatively new
- You get your power from a municipal supplier or coop. Those are in the database, but there are thousands of rates associated with those and bloat the database.
Try it out. Let me know your thoughts and feel free to ask questions either here or via PM. If your rates are out of date, or if you have a pure ToU plan that’s not visible, let me know and I can try to update.