I either run various SQL queries against the data, looking for things more manually. Or write a C# app to query the records into a data set and loop through the records programmatically with checks for different rules based on the different business logic of residential power rate plans.
I asked Grok how to approach it. It,said Python is best with five or six libraries. Maybe someday, but way too much to do now.