SEPTEMBER 5 - 7, 2018
PRISM Predictive Reliability Intelligent System Monitor Alexander - - PowerPoint PPT Presentation
PRISM Predictive Reliability Intelligent System Monitor Alexander - - PowerPoint PPT Presentation
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
SEPTEMBER 5 - 7, 2018
LCRA Transmission Services Corporation
Over 5,000 miles of transmission lines 400+ substations 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
Real-Time Failure Alarm Damage Control
Proactive
Scheduled Maintenance Learn From Past Failures Warning of Upcoming Failure
Predictive
Continuous Health Monitoring Estimate Remaining Life Justified Investment for 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
- Tableau
- Dynamic Visuals
- Interactive Dashboards
– Filters – Queries – Highlighters
- Reporting Schemes
- Security
Back - End
- Database
- Data Centralization
- Data Automation
– SQL Server Stored Procedures – Windows Task Scheduler – Macro Implementation
SEPTEMBER 5 - 7, 2018
Process Improvement
- 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
Problem
- Perform a one-time all inclusive data dump to SQL Server
- Scheduled routine to import new battery reports
- Use Tableau for data visualization
Solution
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