Electric Power Group Presents Maximizing Use of Synchrophasor

Electric Power Group Presents Maximizing Use of Synchrophasor Technology for Everyday Tasks Welcome! The meeting will begin at 2: 00 p. m. EDT / 11: 00 a. m. PDT August 10, 2016 Registration URL: https: //electricpowergroup 2. webex. com/ Webinar Teleconference Number: 1 -650 -479 -3208 Access code: 664 290 902 Please mute your phone during the presentation. We will encourage discussion at planned QA session. Thank you for your cooperation. For any technical issues with this webinar, please contact Kosareff@electricpowergroup. com or call (626) 685– 2015 |

Webinar Series Kickoff Maximizing Use of Synchrophasor Technology for Everyday Tasks © Electric Power Group 2016. All rights reserved |1

Objective § Topics based on feedback from EPG Applications’ Users Group and Industry Stakeholders § Designed to address needs that are common to operators and engineers § Outline the issues faced frequently by users, and cover step-by-step approach to address the issues § Knowledge sharing (use cases, best practice, …) § Advance daily use of synchrophasor applications § Obtain direct feedback on issues and suggestions to prioritize our activities at EPG © Electric Power Group 2016. All rights reserved |2

EPG Webinar Series http: //electricpowergroup. com/webinars. html Initial List of topics: § Extracting large amounts of synchrophasor data efficiently for offline analysis. § Quickly creating an event report that could be distributed to operators, engineers and managers. § Configuring alarms and validate parameters to provide meaningful results for operators. § Mining large data archives for events of different types, e. g. oscillations, generator trips, etc. § Using alarms & events for proactive actions. § Providing secure remote access to users in real-time for monitoring and diagnostics during normal times and emergencies. § Sending data & alarms to EMS. § Leveraging existing one-line diagrams to map synchrophasor data. § Extending grid synchrophasor observability with Linear State Estimation technology. © Electric Power Group 2016. All rights reserved |3

Maximizing Use of Synchrophasor Technology for Everyday Tasks Extracting Large Amount of Synchrophasor Data Efficiently for Offline Analysis Webinar August 10, 2016 Presented by Kevin Chen, Neeraj Nayak, EPG Dan Ilse, Frank Kopecki, Pramila Nirbhavane, NYISO |

Outline § Data Extraction Needs & Solutions Real-Time: Operators See Something of Interest – Seconds to Minutes > Events: What Happened – Root Cause? – 3 to 15 Minutes > Large Amounts: Analysis and Patterns of Grid Behavior – Weeks or Months > § Data Extraction Demonstration using enhanced Phasor Data Extractor § NYISO Use Cases § Discussion > Your Practice, Use Cases, Suggestions § Summary © Electric Power Group 2016. All rights reserved |5

Data Extraction Need & Solution © Electric Power Group 2016. All rights reserved | 6

Real-Time Operation Let me just mark the data and have s ’ e r e h t h, Oit for my g n i h t e engineers to do som g n i t s e r further analysis … inte here! Operator | 7

Real-Time Data Extraction – Method Operators See Something of Interest in RTDMS: Export Data from View/Display > Export Profile Data to COMTRADE > User Marked Event > © Electric Power Group 2016. All rights reserved | 8

Data Extraction for Event Analysis Generator Response Ringdown Analysis Oscillation Analysis Disturbance Analysis © Electric Power Group 2016. All rights reserved | 9

Data Extraction for Event Analysis – Method Access Data for Event Analysis: § RTDMS Replay > COMTRADE > Database § Grid. Smarts > RTDMS Database > Download COMTRADE Files § DB Tool > e. PDC/RTDMS Database > COMTRADE, CSV § PGDA © Electric Power Group 2016. All rights reserved > COMTRADE > RTDMS/e. PDC Database > PI > e. DNA | 10

Large Amounts of Data Extraction – Weeks or Months § Analysis and Patterns of Grid Behavior | 11

Conversation between Kyle and Frank … Ø We hear similar request from other customers Ø We’ve developed a new tool for this purpose – e. PDE Ø You want to try it out? Ø Need to extract large amount of data (about 1 week) Ø Tried DB tool Ø Takes too long Ø Suggestions? ü Another satisfied customer. v Ok Great. I’ll try it. ü Works for me! © Electric Power Group 2016. All rights reserved | 12

Data Extraction Performance § 30 samples/sec using DB tool Data Duration 100 Signals 500 Signals 1000 Signals 2000 Signals 10 Minutes 36 secs 4 Mins 20 secs 12 Mins 23 secs 16 Min 39 secs 1 Hour 5 Mins 25 Mins 1 Hour 14 Mins X § 30 samples/sec using e. PDE Data Duration 100 Signals 500 Signals 1000 Signals 2000 Signals 10 Minutes 6 secs 11 secs 20 secs 34 secs 1 Hour 31 secs 1 Min 12 secs 1 Min 53 secs 3 Min 16 secs 1 Day 10 Mins 30 secs 22 Mins 42 Mins 1 Hour 18 Mins 7 Days 1 Hour 17 Mins 2 Hours 28 Mins 30 Days 5 Hours 46 Mins 10 Hours 52 Mins Can be done; Time increase almost linearly *Results are obtained using Windows Server 2008 R 2, CPU X 5687 @3. 6 GHz, RAM 24 GB, 64 -bit OS. Note: data extraction times vary with several other factors like current load (I/O) on the Database, Database file groups’ structure, Database Server and e. PDE system resources: RAM and CPU, amount of data in the archive, data resolution, network bandwidth and load. | 13

Large Amounts of Data Extraction – Method 1. Connect e. PDE to Database > RTDMS/e. PDC/Data. NXT Database 2. Select Time and Signals 3. Select Output > © Electric Power Group 2016. All rights reserved CSV, ZIP, COMTRADE (next release) | 14

Data Extraction Demonstration Using e. PDE © Electric Power Group 2016. All rights reserved | 15

Extracting Large Amount of Data – Key Takeaways § Access archived data for: > > > Data quality analysis Data mining analysis Event analysis Asset measurement anomalies Data communication problems Research § Multi-threaded & batched processing technique > Breakdown data size to small chunk > Do not overload system resource > Minimize impact on real-time data archiving / visualization © Electric Power Group 2016. All rights reserved | 16

NYISO Use Cases © Electric Power Group 2016. All rights reserved | 17

NYISO Use Cases for Data Extraction § Event Analysis - Large amounts of data needed to analyze an event. § Determining Limits/Threshold - Analyzing a year’s worth of data § Data for EPG - Sending large amounts of data to EPG for analysis and data mining § Data for Academic Institutions – Researchers request large amounts of data. RPI, SUNY Binghamton, CURENT. § Data for Other ISO’s and Transmission Owners – For those who do not have visibility or access to PMU data. § Data for NERC - Government Agencies such as PNNL/DOE, NERC, FERC–SMS § Data for NYSERDA Project - SUNY Binghamton, Bigwood Systems, and NYISO are working on a Generator Parameter Calibration Project | 18

Frequently Asked Questions § How to extract data to meet PRC-002 requirement? A. Select RTDMS trigger-based event file in COMTRADE B. User Event Marker in RTDMS to mark as an event, then download as COMTRADE file C. Use DB Tool to extract up to 15 mins data to CSV, COMTRADE D. Use e. PDE to extract needed data to CSV, COMTRADE faster § How to generate a comprehensive list of event files? 1) Configure ISG profile data extraction folder to be the same as RTDMS Server COMTRADE file folder 2) Point Grid. Smarts to above folder 3) Make sure no firewall between different servers 4) Use Grid. Smarts event list report § As an operating engineer, what’s the best way to extract 3 mins of data to look at a frequency transient? v Grid. Smarts report § How do I extract 1 month of data for oscillation analysis? § How do I extract months to 1 year of data for data mining? § As a protection engineer, what’s the best way to extract 1 week of data to confirm a PMU measurement anomaly? v e. PDE © Electric Power Group 2016. All rights reserved | 19

Q&A, Discussion © Electric Power Group 2016. All rights reserved | 20

Q&A, Discussion § Q&A § Data Extraction − − Your Practices Use Cases Pain Points Suggestions § Next Webinar Focus − Priority − Other topics © Electric Power Group 2016. All rights reserved | 21

EPG Webinar Series § Extracting large amounts of synchrophasor data efficiently for offline analysis. (August 2016) § Quickly creating an event report that could be distributed to operators, engineers and managers. (Sept 21) § Configuring alarms and validate parameters to provide meaningful results for operators. § Mining large data archives for events of different types, e. g. oscillations, generator trips, etc. § Using alarms & events for proactive actions. § Providing secure remote access to users in real-time for monitoring and diagnostics during normal times and emergencies. § Sending data & alarms to EMS. § Leveraging existing one-line diagrams to map synchrophasor data. § Extending grid synchrophasor observability with Linear State Estimation technology. § Other topics? © Electric Power Group 2016. All rights reserved | 22

Summary § Data Extraction Needs & Solutions > Real-Time, Events, Large Amounts § Data Extraction Process Demo using e. PDE § NYISO Use Cases § Discussion © Electric Power Group 2016. All rights reserved | 23

Thank you for participating! If you have any questions regarding any part of the course, please contact us at Contact@electricpowergroup. com Thank you! 201 S. Lake Ave. , Ste. 400 Pasadena, CA 91101 626 -685 -2015 |