PRISM Predictive Reliability Intelligent System Monitor Alexander Shvedov Lower Colorado River Authority Transmission Reliability Engineering Engineering Associate SEPTEMBER 5 - 7, 2018
LCRA Transmission Services Corporation Over 5,000 miles of 400+ substations transmission lines Over 70 counties across State of Texas SEPTEMBER 5 - 7, 2018
Discussion • Introduction • Maintenance Approaches • Needs Identification • Design Considerations • Process Improvement • PRISM Today • Challenges and Lessons Learned • Next Steps SEPTEMBER 5 - 7, 2018
Introduction • The goal is to achieve full system awareness – Predictive Maintenance – Better understand equipment health factors – Prevent imminent failures – Minimize outages & damages – Identify high-risk assets for replacement – Justify risk reduction expenses SEPTEMBER 5 - 7, 2018
Maintenance Approaches Reactive Proactive Predictive Continuous Real-Time Scheduled Health Failure Alarm Maintenance Monitoring Damage Learn From Estimate Control Past Failures Remaining Life Warning of Justified Upcoming Investment for Failure Risk Reduction SEPTEMBER 5 - 7, 2018
Needs Identification • What do we want to look at? – Start with Transformers, Breakers, Batteries • LCRA developed using off the shelf customizable software • Tool has to work with the systems LCRA has in place • Intuitive and easily taught • Customer support and access to educational information • Next generation analytics capability SEPTEMBER 5 - 7, 2018
Design Considerations Front - End Back - End • Tableau • Database • Dynamic Visuals • Data Centralization • Interactive Dashboards • Data Automation – Filters – SQL Server Stored Procedures – Queries – Windows Task Scheduler – Highlighters – Macro Implementation • Reporting Schemes • Security SEPTEMBER 5 - 7, 2018
Process Improvement Problem • Battery data scattered across monthly, quarterly and annual reports • All reports stored in different locations • Lack of trending capabilities • Different template formats used over the years Solution • Perform a one-time all inclusive data dump to SQL Server • Scheduled routine to import new battery reports • Use Tableau for data visualization SEPTEMBER 5 - 7, 2018
PRISM Today SEPTEMBER 5 - 7, 2018
PRISM Today SEPTEMBER 5 - 7, 2018
PRISM Today SEPTEMBER 5 - 7, 2018
Challenges and Lessons Learned Challenges • Design a systematic approach • Verify data accuracy • Security considerations • Troubleshooting • Identify critical/nuisance alarms Lessons Learned • Better planned approach • Document process for knowledge transfer • Team involvement on every level SEPTEMBER 5 - 7, 2018
Next Steps Collect More Data Automate Updates Develop Health Algorithms Monitor SEPTEMBER 5 - 7, 2018
Questions? SEPTEMBER 5 - 7, 2018
Recommend
More recommend