The 1898 & Co. team was tasked with building a comprehensive software solution that streamlined data collection — synthesizing, validating and consolidating it so it can be easily viewed, processed and audited for use with other downstream business applications. The solution required development of highly customized algorithms that dictate rules and formulas for data collection, resulting in consistency within all the power system computer models.

The central goal was to streamline basic data collection and produce power flow models that are solvable in the Siemens PSS/E software while maintaining an audit history of data changes over time. For example, a key outcome was to create better audit reports that could present a clear picture of how data was provided, who provided it and how it may be updated, reflecting various ranges of values in load forecasts, system capacities and other key operational indicators.

The project followed a series of two-week sprint cycles that involved segmenting different phases of software development to meet a defined set of requirements — then building and testing the software, followed by a demonstration to gain feedback and make any revisions.

Upon completion of the initial development, the software was deployed on the LG&E and KU system.

The project delivered a software solution that has the flexibility to efficiently produce system models as updated data is received on an annual basis for the 10-year planning horizon. Updates to the power system could reflect new construction, the addition of new generation sources such as renewables, or changes in load such as growth in electric vehicle charging stations. For example, specific workflows with defined rules are now in place to model how generation is dispatched, based on costs of certain units, as well as rules that apply to power purchase agreements for generation that is not owned by LG&E and KU.

In addition to efficient data collection, other benefits included:

• An ability to track model updates, audit capabilities, eliminate errors and streamline the overall process.
• A multistep process now is transformed into a single-click solution.
• Multiple databases now are combined into a single repository.
• Custom cases can more easily be generated on demand.
• Custom project lists can now be created.
• Functionality to auto generate files.
• Cases can now be archived with historical tracking.

The models produced by this software solution can be used as the basis for all analysis needed for future system planning as well as studies needed to gain further insight on developing issues.

The LG&E and KU team had a large role in the ultimate success of this effort, particularly because transmission planners were working alongside a software team with both engineering and domain expertise. This resulted in robust testing and quality feedback. Because of that involvement, LG&E and KU got exactly what they needed.