I've developed and downloaded various spreadsheets to use my GreenButton pge downloaded usage data to "bin" it into correct peaks and tiers and then calculate expected bills based on rate structures.

However, I'm at the last step now needing to overlay pvwatts hourly generation data on top to net-out the usage data to estimate potential bills after solar.

Anyone have a sheet to do this before I spend x number of hours doing this myself?

Another question: Based on your experience in e6 or EVA, if i estimate a system will annually leave x number kWh remaining (net consumed) what rate is this usually billed at, assuming a typical homeowners usage patterns? If I know it'll all be in tier 1, is it usually winter off-peak rates that are left at true-up since summer peak dollars offset all summer usage and winter partpeak?

I know mathematically how true up works in pge territory, just wondering if an equivalent generalization can be made for typical customers.