Finally have most of the tariffs working and am ready to do a fun comparison. Below, I look at the $ savings between no solar and solar with net metering for all the applicable tariffs (tariffs that are marked as net metering applicable in the OpenEI database). This is all based on my Sense data (Total Usage and Solar Production) for 2019. Monthly savings vary as one would expect, as solar increases in the summer and drops off in the winter. The bars of dots are likely similar E-1 PG&E tariffs, 1 for every one of 10 regions perhaps x 2 for normal and all-electric households.
Here’s the same for TOU rates where there is a separate buy and sell price for electricity.
Please note that I haven’t been able to do California NEM2, only NEM1 pricing, because the OpenEI database doesn’t yet include sell prices that reflect the non-bypassable charges. Also now know I need to rewrite my code to resolve costing at an hourly level in order to do NEM2 calculation.