@benjamin.t.brannon,
Thanks for the pointers. I actually looked at the open source programs you highlighted and they were really cool, but seemed mostly focused on HVAC energy and modeling heating/cooling requirements. But you also spurred me to find the OpenEI database of rate tables… At one fell swoop I can download most of the rate schedules in the US. Sorting through them is another story since they have some many different structures.
The good news is that I have been able to download and parse the .json version of the database. The bad news is that is a complex schema with a lot of context built into the comments. 52,251 different rates with up to 60 different variables, where variables can actually be lists of data. The json database is probably a good training ground for representing all the possible rate schedules.
The gist of my current rate is here, but there are some missing details…