PRISM Predictive Reliability Intelligent System Monitor Alexander - - PowerPoint PPT Presentation

prism
SMART_READER_LITE
LIVE PREVIEW

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


slide-1
SLIDE 1

SEPTEMBER 5 - 7, 2018

PRISM

Predictive Reliability Intelligent System Monitor

Alexander Shvedov Lower Colorado River Authority Transmission Reliability Engineering Engineering Associate

slide-2
SLIDE 2

SEPTEMBER 5 - 7, 2018

LCRA Transmission Services Corporation

Over 5,000 miles of transmission lines 400+ substations Over 70 counties across State of Texas

slide-3
SLIDE 3

SEPTEMBER 5 - 7, 2018

Discussion

  • Introduction
  • Maintenance Approaches
  • Needs Identification
  • Design Considerations
  • Process Improvement
  • PRISM Today
  • Challenges and Lessons Learned
  • Next Steps
slide-4
SLIDE 4

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

slide-5
SLIDE 5

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

slide-6
SLIDE 6

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
slide-7
SLIDE 7

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

slide-8
SLIDE 8

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

slide-9
SLIDE 9

SEPTEMBER 5 - 7, 2018

PRISM Today

slide-10
SLIDE 10

SEPTEMBER 5 - 7, 2018

PRISM Today

slide-11
SLIDE 11

SEPTEMBER 5 - 7, 2018

PRISM Today

slide-12
SLIDE 12

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
slide-13
SLIDE 13

SEPTEMBER 5 - 7, 2018

Next Steps

Collect More Data Automate Updates Develop Health Algorithms Monitor

slide-14
SLIDE 14

SEPTEMBER 5 - 7, 2018

Questions?