Home

PQView User Manual

1. IEEE Std 1159 3 PQDIF Single File IEEE Std 1159 3 PQDIF Basic Folder IEEE Std 1159 3 PQDIF C Folder IEEE Std 37 111 COMTRADE Channel Map Folder Cancel IEEE Std 37 111 COMTRADE Channel Map by Site Folder Dranetz BMI InfoNode DualNode PCInfoNode Dranetz BMI NodeCenter Database Dranetz BMI NodeLink Database Dranetz BMI PASS Database 8010 8020 Dranetz BMI PASS Archive 8010 8020 Dranetz BMI PES Database PQPager 3100 Dranetz BMI PES Database 7100 7100 5 Dranet RMT DDR File Power xnlorerfmi Power Guidel Figure 9 Data Store Format Dialog After you have selected a data format using the Data Store Format dialog a second dialog appears where you select the disk and directory path where the files you want to import are located The exact appearance of this dialog varies with the specific format selection The following examples show the Import Source Path dialog box for two different data store formats Electrotek Concepts Inc 2 12 Figure I0Fi1eure 10 below shows the dialog that appears if you select Dranetz BMI NodeCenter Database as the data format Specify PQDIF Annex Folder Look in Databases ex E3 File name Files of type PODIFPOF Config Files padifpof ini Y Cancel Figure 10 Import Source Path Dialog for Dranetz BMI NodeCenter Database In the Import Source dialog box enter the file name and c
2. SITE1 5 30 1995 13 15 03 1270 x Jaya Myb v vc T vnet AddRes AddNet AddP AddRMS Yab M vbe vca Show Derived Chart E Lu Tr met Autozoom StackCharts Rectangular Show Char A PERSE SITE1 5 30 1995 13 15 03 1270 390000000000 001 ARAVA ALAA 0 00 0 02 0 04 0 06 0 08 0 10 0 12 0 14 0 16 0 18 s L Time s EPRI Bectrotek POMew SITE1 5 30 1995 13 15 03 1270 7500 va vb vo a b k 1500 gt 7000 1000 3 3 3 5 6000 0 00 0 05 0 10 0 15 0 20 0 25 Time s EPRI Bectrotek Record 14 4 Figure 29 Event Display Electrotek Concepts Inc 3 5 1 2 RMS Voltage Variations Analysis Panel To access the RMS Voltage Variations Analysis Panel select RMS Variations from the View menu The RMS Voltage Variations Analysis Panel window opens You can also access the panel by selecting Reports amp Tools from the View menu and then selecting the shortcut link to the panel The RMS Voltage Variations Analysis Panel lets you select which categories of events to include in reports Figure 30Eieure 30 For many reports the selection must include all event types because the report queries include their own filters for selecting the proper events For other reports you can use this window to produce a specialized report covering o
3. Border Style Font Size v Show Legend Numeric Precision Plotting Method Data Shadows Grid Options v Include Data Labels Mark Data Points Maximize Customization Dialog Export Dialog Figure 36 Right Click on Scatter Plot to Include Data Labels Command Display Type Button rex 8 RMS Variation Magnitude Duration Scatter Plot p x Mag Dur Scatter Plot T RMS Variation Magnitude Duration Scatter Plot Sites Event Count 24 1 8 Event Count ITIC Lower Curve 10 Event Count ITIC Upper Curve 0 o o Voltage Magnitude pu 10 10 10 EPRI Electrotek POView Figure 37 1TIC Magnitude Duration Scatter Plot Electrotek Concepts Inc 3 15 The total number of events represented on the curve are counted as Total Events Events that fall below the lower ITIC curve are counted as Events Violating ITIC Lower Curve Events that are above the upper ITIC curve are counted as Events Violating ITIC Upper Curve The deeper the voltage the more likely a computer will trip off line Command Button Display Type Time Stamp Phase Mag kV Mag Dur 5 Dur Record 14 1 bj of 24 Figure 38 Table Summary of RMS Voltage Variation Events To create a Microsoft Word report select Report Writer from the View menu or select the General Report Writer shortcut from the Reports amp Tools window
4. 13 2 kv 25 MYA Substation 13 2 kv 22 4 MVA Substatiol 33 kv 50 MVA Substation 13 2 kV 12 MYA Substation Connection Type gt Use DST Correction Figure 18 Associating a Property to a Parent In the example you can see that all of the properties are associated with Eventl The properties A B and E are of equal rank and associated with Sitel Given equal rank the properties are then sorted in ascending order alphabetically Property C and D are of equal ranking but in this case are associated directly with Property B Property B has been designated as the parent of Property C and D Hierarchy Sitel Property Property B Property C Property D Property E Figure 19 Property Hierarchy Electrotek Concepts Inc 2 20 3 Using the Power Quality Data Analyzer The Power Quality Data Analyzer PQDA provides reporting and analysis functions using Power Quality Databases created by the Power Quality Data Manager This section provides detailed steps for completing the following key tasks in the Power Quality Data Analyzer PQDA e Navigating the PODA e Opening a Power Quality Database in PODA e Selecting Data o Selecting a Group of Sites o Selecting the Date and Time Range e Analyzing Data e Creating Reports 3 4 Navigating the PQDA This section lists the commands that are available in each menu when PQDA is running and its main window is active When you perform ce
5. Rank Parent E UTC Offset 5 Use DST Correction Connection 3P4W T Nominal Base Voltage V 7448 Nominal Fundamental Frequency 60 Properties 1 1 1970 lowerRMSthresl 1 1 1970 0 9 upperRMSthres 1 1 1970 1 1 Utility 171 1970 144970 Record 14 4 15 rs of 4 Record 1 1 gt vi pe of 4 Figure 16 Entering a Property Name in the Name Field lxi To edit or specify more information about the property place the cursor on the name of the property to be edited and double click The Site Properties window opens Electrotek Concepts Inc 2 19 Site Name SITE1 Description 13 2 kv 25 MVA Substatic Source Name Sample Data Source Rank 0 Parent X Figure 17 Site Properties Window In this window the name of the property may be edited or changed A description giving more information about the property may be added A rank may be applied to the property to affect its order in the list of properties Assigning a rank to a property gives the property a value or weight For example a property with a lower rank appears before a property with a higher rank Another property may be designated as the parent for a property By associating properties to parents a hierarchy may be developed within the list of properties Site Name SITE1 Description 13 2 kv 25 MYA Substatic Source Name Sample Data Source Rank Parent
6. Navigating PODM Creating a Power Quality Database Opening and Closing Existing Power Quality Databases Managing Data from Data Sources After creating or importing a data source proceed to the next major section Using the Power Quality Data Analyzer which explains how to generate reports trend plots histogram plots and correlation plots from the database 2 1 Navigating PQDM This section describes the commands that are available through PQDM s menus The commands available change with the active window For example the commands used to open a database are only available when the main window is active In addition many of the commands are simply passed by PODM to the Microsoft Access engine for processing for example the Edit menu commands 2 1 1 File Menu Commands The table below describes the commands available from the PODM File menu Table 2 File Menu Commands for the PQDM New Power Quality Database Creates a new empty Power Quality Database The program uses a template file that contains empty tables corresponding to all tables that PQDM and PQDA use in a Power Quality Database The normal template file is called PQDM PQT and is located in the directory where you installed Access A Power Quality Database created with this template initially has no site data in the Sites Table you must enter information about your sites into the Sites Table before you can load data into the database Open Power Quality Database Opens
7. Once you open a Power Quality Database PODA displays the path and file name of the database along with the number of sites events and steady state measurements contained in the database The date and time ranges of event and steady state data are displayed in the PODA window Figure 21Figure 21 sample21 mdb o x Sites 4 Events 510 From 5 1 1995 9 59 20 AM To 5 31 1995 10 37 41 PM Steady State Measurements 16360 From 5 1 1995 4 03 16 AM To 6 2 1995 12 11 44 AM Figure 21 PQDA Main Window showing a Connected Database In addition the Sites icon in the main window acts as a shortcut to activate other PODA features Double click on the Sites icons and the respective selection windows are displayed 3 3 Selecting Data Three data selection windows are available to help you select sites date ranges and event types for generating analyses and reports Selections made using these windows are persistent so the selections you make here remain in effect until you use the window again to change your selections Also the selections made using these windows apply to many analysis and reporting functions in PODA This means that you can select a group of sites and a date range and then run several different reports without having to reselect the same sites or date range 3 3 1 Selecting a Group of Sites The Select Sites window can be activated by double clicking the cursor on the Sites icon in the window or by selec
8. POView Power Quality Database Management and Analysis Software System Electrotek Concepts EPRI PQView 3 48 User Manual Quick Start December 2007 Electrotek Concepts Inc DISCLAIMER OF WARRANTIES AND LIMITATION OF LIABILITIES THIS NOTICE MAY NOT BE REMOVED FROM THE PROGRAM BY ANY USER THEREOF NEITHER EPRI ANY MEMBER OF EPRI NOR ANY PERSON OR ORGANIZATION ACTING ON BEHALF OF THEM 1 MAKES ANY WARRANTY OR REPRESENTATION WHATSOEVER EXPRESS OR IMPLIED INCLUDING ANY WARRANTY OF MERCHANTABILITY OR FITNESS OF ANY PURPOSE WITH RESPECT TO THE PROGRAM OR 2 ASSUMES ANY LIABILITY WHATSOEVER WITH RESPECT TO ANY USE OF THE PROGRAM OR ANY PORTION THEREOF OR WITH RESPECT TO ANY DAMAGES WHICH MAY RESULT FROM SUCH USE RESTRICTED RIGHTS LEGEND USE DUPLICATION OR DISCLOSURE BY THE UNITED STATES FEDERAL GOVERNMENT IS SUBJECT TO RESTRICTION AS SET FORTH IN PARAGRAPH g 3 i WITH THE EXCEPTION OF PARAGRAPH g 3 i b 5 OF THE RIGHTS IN TECHNICAL DATA AND COMPUTER SOFTWARE CLAUSE IN FAR 52 227 14 ALTERNATE 11 ORGANIZATION THAT PREPARED THIS PACKAGE Electrotek Concepts Inc PQWeb and PQView are registered trademarks of Electrotek Concepts Inc and are part of the EPRI Power Quality Diagnostic System InstallShield is a registered trademark of InstallShield Software Corporation Microsoft Windows and Windows NT are registered trademarks of the Microsoft Corporation Electrotek Concepts is a registered
9. 101 52 100 6296 5 2 1995 09 39 55 3750 OSC 102 56 99 09 SITE 5 2 1995 09 39 55 6900 RMS 69 43 99 06 O 5 2 1995 09 39 57 6250 OSC 105 42 115 15 STEI 5 2 1995 09 39 58 0020 RMS 87 77 98 75 STEI 5 2 1995 11 25 57 0000 OSC 100 69 100 27 O SITE4 5 2 1995 14 47 59 6250 OSC 113 65 107 6196 SITE2 5 2 1995 18 36 29 5000 OSC 103 16 106 31 hal Record 14 1 bj of 510 Figure 26 PQ Event Viewer Selection Dialog Box The PQ Event Selection dialog box contains a summary of the events It displays the site name with the associated event the trigger phase and the date and time of the event Figure 26Figure 26 The summary of events is filtered by the sites and the date time range specified Figure 27Figure27 To filter the selected sites click Sites from the command buttons in the upper left corner of the PQ Event Viewer window and then define the site selection To set the date time range click Date Time Range from the command buttons in the upper left corner of the PQ Event Viewer window and then define the range Note The command buttons located in the upper left corner of the PQ Event Viewer window let you select sites select the date range build an event list sort the event list ascending by time sort the event list descending by time export the selected event to TOP view characteristics of the selected event view properties of the selected event enable
10. 519 1992 is defined to be the average monthly maximum load current at a particular location The value can be supplied by the user by selecting User Defined for Current Base or can be computed by PQView by selecting CP99 If CP99 is selected then the 99 percentile value of rms current is computed and then used to normalize the TDD and individual harmonics This computed or user defined current base value appears on the summary form Electrotek Concepts Inc 3 18 B3 Statistical Summary of Voltage THD and Harmonics x Statistical Summary of Voltage THD and Harmonics 05 Average B CP95 0 80 0 70 0 60 0 50 0 40 Voltage 0 30 0 20 Percent of Fundamental 0 10 0 00 Dd M e THD 11 THD and Individual Harmonics PQView Figure 42 Voltage Total Harmonic Distortion and Selected Harmonics amp Statistical Summary of Current TDD and Harmonics Base Current 229 2 amps Statistical Summary of Current TDD and Harmonics BCP05 B Average B 95 e o e 5 E 5 5 TDD and Individual Harmonics PQView Figure 43 Current Total Demand Distortion and Selected Harmonics Current Total Demand Distortion can be normalized in one of two ways By default the summary tool can compute the 99 percentile value of rms current for the selected site and selected date range This number can be use
11. By default the user interface appears in Spanish on computers configured to be in a Spanish speaking country You can select the report start date and finish date using a calendar You can also cancel the recharacterization process by using the lt Esc gt key Conformidad con CREG 024 2005 Seleccione La Lengua mmm Seleccione Sitios LCUBSub Fecha del Inicio 11 19 2007 Fecha del Final 11 26 2007 _ Carpeta de Salida Figure 47 CREG 024 2005 Window 3 5 1 6 Report Writer The Repot Writer creates Microsoft Word documents based on templates that you can create edit and run through the tabs available in the Report Writer window Available tabs for configuring Microsoft Word documents are as follows General Events Event Filters Metering Imbalance Harmonics Flicker Aggregation and Compliance Each report can have different configurations using combinations of check boxes and text boxes To open the PQView Report Writer select Report Writer from the View menu You can also click the General Report Writer shortcut link under the Report Writer heading in the Reports amp Tools window The Report Writer window opens see Figure 48Figure 48 Electrotek Concepts Inc 3 21 amp Report Writer sj This tool lets you create edit and run configurations Each report can have different configurations using combinations of check ER Nye boxes and text boxes Report Configurations General Eve
12. Data In this way the old data that has been loaded will be deleted and replaced by the same data with the added characteristics The advantage to selecting Leave Previously Loaded Data Unchanged is this at some time there may be data which duplicates the data already imported If this feature is not selected the import process will be slowed because time must be taken to delete the already imported data and replace it with the new data Note Usually you want to leave previously loaded data unchanged 2 4 2 5 1 For CREG 024 Report Users Creating and Exporting CREG Summaries and Downloading Status Events There are many other options that can be completed after a data source import completes For example under the Export tab the user can specify export folder locations where IEEE COMTRADE files can exported for new events or where CREG 024 summaries should be written When exporting CREG summaries the last fourteen days of data will be exported to CSV files automatically To create CREG summaries for historical data use the CREG reporting tool in the PQView PQ Data Analyzer Select View gt Reports amp Tools and then click the CREG 024 link under Report Writer 2 4 2 5 2 For CREG 024 Report Users Downloading Status Events from Dranetz BMI Info Nodes To download status events from Dranetz BMI InfoNodes which are required for the feeder sites of a CREG 024 summary report mark the Status Events check box under the Characteristic tab
13. PQView DemoDB Security Server Objects Ca Replication Management Figure 67 Verify the Correct Database is Selected 10 Select Query Execute from the menu bar 11 Click the Execute button 12 Select File Exit to close Studio Express A Microsoft SOL Server Management Studio Express dialog box displays as shown in Figure 68Figure 68 Microsoft SQL Server Management Studio Express 21x Save changes to the Following items Solution1 Miscellaneous Files SQLQuery4 sql Figure 68 Microsoft SQL Server Management Studio Express Dialog Box 13 Click No You do not want to save the query you just ran 14 Complete the steps for Opening the Database on page 4 10 in the section Creating a New PQView Database with Microsoft SQL Server 2000 You open the database to prepare it to accept data Electrotek Concepts Inc 5 5 Note to Microsoft SQL Users Power quality databases housed in Microsoft SQL Server opened by specifying ODBC Databases in the Files of type box A standard Select Data Source dialog box appears You must have an ODBC Data Source Name configured on your client machine in order to access SQL Server databases The preferred method of connecting to the SQL database however is to address the SQL server directly Support for ODBC connections to PQView databases in PQView will be discontinued in 2008 Electrotek Concepts Inc 5 6
14. Task Where to Complete Task Creating the POView DatabaseCreating the Create the database in Microsoft SQL Server 2000 POView Database as described on page 4 Enterprise 1 Running the Script FileRunnine the Seript Run the script file to create system tables triggers indexes File as described on page 4 5 roles and properties in SQL Query Analyzer Optional Selecting a Recovery Select a Recovery Option in Microsoft SQL Server 2000 OpuontOpiensab Selecune a Kecovepe Enterprise Opties as described on page 4 9 Opening the Database as described on Open the database in PQView s PQ Data Manager page 4 10 PQDM 4 1 Creating the PQView Database To create the PQView database complete the following steps 1 Select Start gt Programs gt Microsoft SQL Server gt Enterprise Manager SQL Enterprise Manager displays a window similar to Figure 52Figure52 Electrotek Concepts Inc 4 1 15 SOL Server Enterprise Manager Console Root Microsoft SOL Servers SQL Server Group a File Action View Tools Window Help e gt fmm x r gt N 0 r Console Root SQL Server Group 1 Item Microsoft SQL Servers SQL Server Group local windows NT local J J Databases Windows NT Data Transformation Services J Management 9 08 Replication J Security Cd Support Services J Meta Data Services Figure 52 SQL Server Enterprise Manager 2 necessary expand t
15. VARIATION FREQUENCY INDEX AT EACH MONITORING SITE 3 16 FIGURE 40 RMS VARIATION MAGNITUDE SCATTER PLOT 3 17 FIGURE 41 HARMONIC STATISTICAL SUMMARY 3 18 FIGURE 42 VOLTAGE TOTAL HARMONIC DISTORTION AND SELECTED HARMONICS 3 19 FIGURE 43 CURRENT TOTAL DEMAND DISTORTION AND SELECTED HARMONICS 3 19 FIGURE 44 MONITOR AVAILABILITY REPORTS 3 20 FIGURE 45 EXAMPLE OF THE TYPE OF INFORMATION IN MONTHLY REPORT 3 20 FIGURE 46 EXAMPLE OF TOTALS INCLUDED IN MONTHLY REPORT WITH TOTALS REPORT 3 21 FIGURE 47 CREG 024 2005 WINDOW 3 21 FIGURE 48 REPORT WRITER WINDOW LISTS SEVERAL TYPES OF REPORTS AVAILABLE 3 22 FIGURE 49 REPORT BROWSER 3 22 FIGURE 50 SiNGLE SITE STATISTICAL CALCULATOR INITIAL WINDOW 3 23 Electrotek Concepts Inc FIGURE 51 SINGLE SITE STATISTICAL CALCULATOR 3 23 FIGURE 52 SQL SERVER ENTERPRISE MANAGER 4 2 FIGURE 53 DATABASE PROPERTIES GENERAL TAB 4 3 FIGURE 54 DATABASE PROPERTIES DATA FILES TAB 4 4 FIGURE 55 FILE PROPERTIES SECTION IN DATABASE PROPERTIES DATA FILES TAB 4 4 FIGURE 56 VERIFY THE DATABASE NAME BEFORE RUNNING THE SCRIPT FILE 4 6 FIGURE 57 VERIFY THE DATABASE NAME IN SQL QUERY ANALYZER 4 7 FIGURE 58 CHECK THE MESSAGES TAB OF THE QUERY WINDOW AFTER RUNNING THE SCRIPT FILE 4 7 FIGURE 59 SECTION OF PQVIEW3X SQL SCRIPT FILE TO EDIT 4 8 FIGURE 60 MICROSOFT SQL SERVERS 4 10 FIGURE 61 OPEN PowER QUALITY DATABASE DiALOG BOX 4 11 FIGURE 62 ODBC DATABASE DIALOG BOX 4 12 FIGURE
16. You can mark one or more reports and print them all with a single command amp Report Browser x Select or mark report s After the report s has been marked or selected you can view or print an individual report or batch print a number of reports Report Group Report Writer z Reports Compliance with NVE1557 PQ Index Report Report Writer Summary of PQ Monitoring Results Print Print Marked Save As Send Mark All Clear All Close Figure 49 Report Browser Each time this window opens it builds a list of all reports and determines their groups The report groups are displayed in the Report Group drop down list box As you change the Report group selection the reports of that group type are displayed in the Reports list box Electrotek Concepts Inc 3 22 Select a report and then click View to preview the report on screen or click Print to print the report Double clicking a report in the list also opens the report in view mode 3 5 1 8 Single Site Statistical Calculator To open the Single Site Statistical Calculator select View gt Report Browser to obtain the Report Browser Change the Report Type property to Steady State Analysis The Steady State Statistics tool appears in the list of available reports Select Steady State Analysis in the Reports list and then click View The Steady State Statistics Calculator window opens amp Steady State Stat
17. an existing Power Quality Database file which you have created using the New Power Quality Database command described above Close Power Quality Database Closes the Power Quality Database file that 15 currently open After using this command you will have to use the New or Open commands to connect to another database file Data Sources Opens the Data Source dialog From this dialog you can create setup activate deactivate delete and take ownership of data sources Electrotek Concepts Inc 2 1 Start Background Processing Stop Background Processing Database Connections ODBC Data Sources Transfer Import Export Electrotek Concepts Inc Enables PODM s background processing tasks including alarm processing poll request processing unscheduled import operations and scheduled data import operations This command is active by default Disables PODM s background processing These menu items are enabled or disabled as appropriate to reflect the current background processing state The background processing state is remembered for each database This last state for a specific database is restored whenever PQDM is started or a Power Quality Database is opened Exit closes all database files and exits from the Access system Use this form to create open edit and delete connections to databases containing PQView measurements If you enable a database for background scanning then the PQ Data Manager connects
18. expansion during import from a data source an ODBC open database connectivity error can appear in PODM with no other explanation It is recommended that you choose to not grow a database using automatic database expansion In contrast if you choose to not automatically grow a database but instead choose a fixed size and then meet that size you will receive a much more helpful error message in PODM Could not allocate space for object because the PRIMARY filegroup is full To receive the more helpful error message in PODM when you create a database specify a fixed file size for the PQView database in the Initial Size MB field on the Data Files tab in the Database Properties dialog box 4 2 Running the Script File To create the PQView database system tables triggers and indexes roles and database user ID and password you must run a Transact SQL TSQL script file on the PQView database file that you just created in the previous section The name of the script file is PQView3x SQL It is available to you in these ways e download from the PQView Users Group download page e Onacomputer with a current PQView 3 x installation where it can be found in this example in c Program Files pqview30 sql pqview3x sql The script creates the following objects e Tables Indexes Triggers Default properties A role for read write access to the database pqview writer A role for read only access to the database pqview rea
19. of PQView the POA MDB database file may grow because Microsoft Access does not fully recover space used by temporary files To recover this space and optimize performance you can occasionally compress these database files Rebuilds table indices when connected to a SQL Server database This command requires that you have database administrator DB A or database owner DBO permission to the database This command can be used to open a popup zoom box in a modal window from the text boxes of most windows Opens the POView COMTRADE File Viewer dialog box Provides a count of all waveform and or rms samples stored in the open database Provides a count of all steady state samples stored in the open database Opens a window that lets you browse for the 1159 3 Annex C folder Use this command to correct PQDIF folders that do not follow the IEEE Std 1159 3 Annex C recommendation Opens a window that lets you select an add in to open as well as view currently installed add ins and reports 2 7 Install Data Handler Microsoft Access Options Options 2 1 7 Setup Menu Commands Opens a window that lets you specify optional data handlers Opens a window that displays tabs for the following Microsoft Access options Pages Advanced International Spelling Tables Queries View General Edit Find Keyboard Datasheets and Forms Reports Opens the PODM Options window with tabs for configuring General SMTP NodeL
20. on the database size see PQ View Database Size below 10 If you want to change the transaction log file folder from the default location click the Transactions Log tab In the Location section specify a new folder You can type the folder name or browse to it Tip A one MB initial size is adequate for most PQView databases It is OK to grow transaction log databases automatically using 10 increments with unrestricted file growth because the transaction log associated with a PQView database rarely exceeds a few tens of megabytes 11 Click OK You create your PQView database Note It takes a few minutes to create a 10 gigabyte database 12 Complete Running the Script FileRunning the Seript Eille as described below By running the PQView3x sql script file against the new database you populate it with PQView tables triggers indexes properties roles and database user ID and password 4 1 1 PQView Database Size The default setting for SQL Server is to grow databases automatically when needed in 10 chunks For example if the database is 1 gigabyte in size SQL Server can automatically grow the database to 1 1 gigabytes During the database expansion no queries can be run against the database When the expansion is small or if the server is unloaded this expansion can take just a few seconds However when the database is large in excess of several gigabytes the expansion can take many seconds If PQView s PQDM triggers the
21. tabs for setting General Charts Color event roll quantity labels characteristic labels and other labels 3 1 8 Menu Shortcuts via the Keyboard The menus for the Power Quality Data Analyzer include the following keyboard shortcuts Table 12 Menu Shortcuts via the Keyboard PQDA Cut Copy Delete Find Paste Replace Save Record Select Records Undo Ctrl X Ctrl C Del Ctrl F Ctrl V Ctrl H Shift Enter Ctrl A Ctrl Z 3 2 Opening a Power Quality Database in PQDA The PQDA window appears when you start the Power Quality Data Analyzer and it remains on the screen at all times while you are using PQDA although it may be covered up by other windows Power quality databases housed in Microsoft SQL Server are opened by specifying ODBC Databases in the Files of type box A standard Select Data Source dialog box appears You must have an ODBC Data Source Name configured on your client machine in order to access SQL Server databases Electrotek Concepts Inc 3 4 The PQDA window always shows the current status of the Power Quality Database that is being used by PQDA If no Power Quality Database is open the window displays a message telling you how to open a database by selecting the Open command from the File menu Figure 20Figure 20 Use the Open Power Quality Database command in the File menu to open an existing database Figure 20 PQDA Main Window with No Database Connection
22. the system event edit mode export events view marked events in roll view specific events by ID and close the PQ Event Viewer Figure 27 Apply Filtering by Selecting Sites or Date Time Range from the Command Buttons in the PQ Event Viewer After changing either filter click OK to apply the changes to the list of events To view an event in the list select the event and click Go Figure 28Figure28 Electrotek Concepts Inc 3 9 amp PQ Event Viewer ER 2021 e e amp 2 d ge A total of 510 events were Found Event List Preferences shortcuts Mark amp Plot All Events Mark Events Unmark All Events Go Site Name Date and Time Minimum Maximum SITE1 5 30 1995 07 53 16 3750 99 44 106 0496 SITE1 5 30 1995 07 53 17 0630 100 97 96 101 5296 SITE1 5 30 1995 07 53 17 6880 100 27 99 85 SITE1 5 30 1995 07 53 18 1270 75 97 99 94 SITE1 5 30 1995 08 00 08 7500 108 34 99 85 SITE1 5 30 1995 08 00 09 2520 68 44 99 93 SITE1 5 30 1995 13 15 02 5250 100 13 109 17 5 30 1995 13 15 03 1270 MS 76 25 5 30 1995 18 37 48 0630 104 63 5 30 1995 18 37 48 6880 110 23 103 93 5 30 1995 19 29 27 7500 106 60 106 03 5 30 1995 22 09 24 3750 124 37 112 14 5 31 1995 18 37 41 5630 104 91 110 02 Record 14 505 gt pi gt gt of 510 m KJ 00000 Figure 28 Selecting an Event By default all phases are shown or displayed Figure 29Fisure 29
23. to process The Open Power Quality Database dialog box appears as shown in Figure 5Eieure5 Open Power Quality Database Ae Use this Form to connect to an existing measurements database Specify the database type and connection information then press the OK button Recently Used J SETS Microsoft Access Microsoft SQLServer ODBC Data Source FieName C C C C Figure 5 Power Quality Database Dialog 2 Specify the path to the database file to open 3 From the File menu select the Close Power Quality Database command to close the currently open database The PODM window is always on the screen when you are using PODM Its purpose is to display the status of the Power Quality Database that is currently in use 3 No Database Currently Open ojx Use the New Power Quality Database command in the File menu to create and open a new empty database Use the Open Power Quality Database command in the File menu to open an existing database Figure 6 PQDM Main Window Databases Closed Once you have opened a Power Quality Database the PODM window displays the directory path and file name of the database the number of sites events and steady state measurements and the time range of the events and steady state measurements Figure 7Figure 7 Electrotek Concepts Inc 2 10 Sites 4 Events 510 From 5 1 1995 9 59 20 AM To 5 31 1995 10
24. to the database automatically when a data source in that database needs to be imported according to its schedule Opens the dialog box for the ODBC Data Source Administrator with tabs for the User DSN System DSN File DSN Drivers Tracing and Connection Pooling ODBC is a programming interface that enables applications to access data in database management systems that use Structured Query Language SQL as a data access standard Use this tool to copy measurements from one PQView database to another Specify a source database from which to copy measurements and a destination database into which the measurements will be copied records will be removed from the destination database before transfer begins Supported PQView database versions include 2 x and 3 x To import measurements from a data source select a data handler select one or more sites specify a date range and click the Import command button Leave either data range text boxes empty to leave that date range limit unbound If you select no sites in the Select Sites list box all sites will be imported Use this command to export sites site properties and documents You also can export to PQDIF and export events to COMTRADE 2 2 Translate Print Setup Print Preview Print Database Properties Version Information Exit 2 1 2 Edit Menu Commands Translates INST to PQDIF files Provides print setup options for margins page and c
25. 37 41 PM Steady State Measurements 15360 5 1 1995 4 03 16 AM 6 2 1995 12 11 44 AM Figure 7 PQDM Main Window Connected Open Database 2 4 Managing Data from Data Sources Data is imported or loaded into a PQView database from data sources A data source is a unique combination that consists of a type of data store format and location For example if you have data from a single Dranetz BMI PCInfoNode and data from a single ION Enterprise amp Schneider Electric ION Enterprise database then you would have two databases A data source can contain data for one or more sites PQDM allows you to create up to two billion data sources To view the list of data sources select the Data Sources command from the File menu This command opens the Data Sources dialog box see Figure 8Figure 8 From this dialog you can create setup activate deactivate delete and take ownership of data sources To create a new data source click New Note Background processing is disabled while this form is open amp Data Sources Use this form to create setup activate deactivate delete and take ownership of data sources Note that background processing is disabled while this form is open Sample Data Source 572719397 LOZA PM luas Copy Activate Deactivate Reset Delete em iwas pesetas Lem ee EN Close F Close this form after manual data source import Figure 8 The Data Sources Dialog Data sou
26. 63 WINDOWS AUTHENTICATION 5 1 FIGURE 64 NEW DATABASE DiALOG BOX FIGURE 65 NEW DATABASE OPTIONS DiALOG BOX FIGURE 66 SELECT NEW QUERY FIGURE 67 VERIFY THE CORRECT DATABASE IS SELECTED FIGURE 68 MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS DIALOG BOX agag O O1 Electrotek Concepts Inc vi TABLES TABLE 1 PLATFORM REQUIREMENTS TABLE 2 FILE MENU COMMANDS FOR THE PQDM TABLE 3 VIEW MENU COMMANDS FOR THE PQDM TABLE 4 RECORD MENU COMMANDS FOR THE TABLE 5 TOOL MENU COMMANDS FOR THE PQDM TABLE 6 SETUP MENU COMMANDS FOR THE PQDM TABLE 7 MENU SHORTCUTS VIA THE KEYBOARD PQDM TABLE 8 FIELDS IN THE SITES WINDOW TABLE 9 VIEW MENU COMMANDS FOR THE PQDA n TABLE 10 RECORD MENU COMMANDS FOR THE PQDA TABLE 11 TOOLS MENU COMMANDS FOR THE PQDA TABLE 12 MENU SHORTCUTS VIA THE KEYBOARD PQDA TABLE 13 WILDCARD CHARACTER PATTERNS AVAILABLE WITH SITE PROPERTY FILTER TABLE 14 OVERVIEW TABLE 15 USER ACCOUNT INFORMATION cO Q WW G Electrotek Concepts Inc vii 1 Getting Started PQView 3 48 is a multi component software system developed by Electrotek Concepts Inc and the Electric Power Research Institute Inc EPRI for building and analyzing databases of power quality and energy measurements Measurements can be stored in either M
27. A curve are counted as Events Violating CBEMA Lower Curve Events that are above the upper CBEMA curve are counted as Events Violating CBEMA Upper Curve Note In the upper left corner command buttons are available see Figure 35Figure35 to copy the scatter plot export to Excel save the scatter plot as a CVS file print the scatter plot edit properties enable the Toggle Event Click Mode which lets you click on a point to see the event and its temporally related events enable the Toggle Event Zoom Mode which lets you draw a box around groups of events to see them in an event roll enable the Toggle Edit Mode which lets you click on a point to delete it unzoom toggle crosshairs and close the scatter plot From the drop down list under the command buttons see Figure 35Figure35 you can also select and generate more than thirty additional report types amp ae amp o l gt x ue Mag Dur Scatter Plot Figure 35 CBEMA Magnitude Duration Scatter Plot Command Buttons and Drop Down List Box for Additional Reports Electrotek Concepts Inc You can also right click on the scatter plot to access commands for setting the viewing style border style font style show the legend numeric precision plotting method data shadows grid options include data labels mark data points undo the zoom maximize the scatter plot open the customization window and export the scatter plot Viewing Style
28. ID I Sense measurements from IEEE files and magnitude duration text files e Square D measurements from PowerLogic circuit monitor meters in System Manager databases and then exported to IEEE PQDIF and IEEE COMTRADE files Electrotek Concepts Inc 1 2 1 2 Power Quality Data Analyzer PQDA PQDA creates trends histograms and statistical summary tables of more than 125 steady state characteristics defined within the IEEE Std 1159 3 PQDIF standard It creates charts event lists tables and indices to analyze voltage sags dips swells and interruptions PODA interfaces with Microsoft Word to create summary documents automatically and allows the user to filter invalid measurements from final analysis 1 2 1 Steady State Data Log Analysis PQDA creates trends histograms profiles and statistics for any steady state voltage current power and energy quantity The data for trend and histogram charts can be filtered to exclude invalid measurements Each trend can become an event timeline by plotting any associated waveform or rms variation measurements as tick marks along the x axis Each trend and histogram can be copied automatically into Microsoft Word documents exported to HTML documents with related graphics files or sent to a printer Users can view trends and histograms for the minimum average maximum standard deviation count and any percentile for steady state data in intervals of minutes hours days weeks mon
29. S Variation SARFI System Event Analysis RMS Variation Sensitivity Curves RMS Variation Summary RMS Variation Summary Sort by Site RMS Variation Sort by Site SDGE RMS Variation Frequency Index for Each Site RMS Variation Magnitude Column Chart RMS Variation Magnitude Duration Column Chart RMS Variation Magnitude Duration Column Chart DPQ RMS Variation Magnitude Duration Contour Chart RMS Variation Magnitude Duration Statistical Summary Electrotek Concepts Inc 3 11 The RMS Variation Analysis Panel presents you with options for creating and customizing reports and plots including the following command buttons as described in the table below e Site Date and Events e Graphic Displays Site Date and Events Graphic Displays Command Button In the upper left hand corner of the RMS Variations Analysis Panel are displayed the icons for site date and events To display these windows click their respective icons By making selections in these windows you can choose the sites date and define the event by duration or magnitude These windows are the same windows available from the View menu selections The icons at the lower left hand side of the RMS Variations Analysis Panel et you determine how to display the data see Figure 31 Fieure 31 through Figure 38Ficure38 Display Type RMS Variation Event Count Magnitude Column Chart sag Histogram RMS Variation Event Count Magnitude Column Char
30. SOURCE PROCESSING 2 15 FIGURE 14 SITES WINDOW 2 17 FIGURE 15 SITES WINDOW 2 19 FIGURE 16 ENTERING A PROPERTY NAME IN THE NAME FIELD 2 19 FIGURE 17 SITE PROPERTIES WINDOW 2 20 FIGURE 18 ASSOCIATING A PROPERTY TO A PARENT 2 20 FIGURE 19 PROPERTY HIERARCHY 2 20 FIGURE 20 PQDA MAIN WINDOW WITH NO DATABASE CONNECTION 3 5 FIGURE 21 PQDA MAIN WINDOW SHOWING A CONNECTED DATABASE 3 5 FIGURE 22 SELECT SITES WINDOW 3 6 FIGURE 23 VIEW MENU 3 7 FIGURE 24 SELECT DATE AND TIME WINDOW 3 7 3 8 3 9 FIGURE 25 REPORTS AND TOOLS WINDOW FIGURE 26 PQ EVENT VIEWER SELECTION DIALOG BOX FIGURE 27 APPLY FILTERING BY SELECTING SITES OR DATE TIME RANGE FROM THE COMMAND BUTTONS IN THE PQ EVENT VIEWER 3 9 FIGURE 28 SELECTING AN EVENT 3 10 FIGURE 29 EVENT DISPLAY 3 10 FIGURE 30 RMS VOLTAGE VARIATIONS ANALYSIS PANEL 3 11 FIGURE 31 RMS VARIATION MAGNITUDE COLUMN CHART 3 12 FIGURE 32 RMS VARIATION MAGNITUDE DURATION COLUMN CHART 3 13 FIGURE 33 RMS VARIATION CUMULATIVE MAGNITUDE DURATION CONTOUR CHART 3 13 FiGURE 34 CBEMA MAGNITUDE DURATION SCATTER PLOT 3 14 FIGURE 35 CBEMA MAGNITUDE DURATION SCATTER PLOT COMMAND BUTTONS AND DROP DOWN LisT BOX FOR ADDITIONAL REPORTS 3 14 FIGURE 36 RIGHT CLICK ON SCATTER PLOT TO INCLUDE DATA LABELS 3 15 FIGURE 37 ITIC MAGNITUDE DURATION SCATTER PLOT 3 15 FiGURE 38 TABLE SUMMARY OF RMS VOLTAGE VARIATION EVENTS 3 16 FiGURE 39 RMS
31. This check box is marked automatically when creating a data source on a computer with its locale set to Colombia 2 4 3 Importing Data from a Data Source You can manually import the data by selecting a data source in the Data Sources list box and clicking Import The PODM Status window appears during the data source import Electrotek Concepts Inc 2 16 2 4 4 Activating or Deactivating a Data Source Scheduled imports and poll requests externally initiated imports are only performed on active data sources Select the data source in the Data Source list box and click Activate or Deactivate Under the Active column you can note whether the data source is active or inactive 2 4 5 Resetting a Data Source To reset a data source select it in the Data Sources list box and click Reset Resetting removes the Last Import Time information which is just as if the data source had never been imported 2 4 6 Taking Ownership of a Data Source Normally the Data Source list box only displays the data sources that are owned by your computer Clicking on the Show All check box causes the data sources for all computers to be displayed As you scroll through the list of data sources notice that the controls for manipulating a data source are enabled only for those data sources that belong to your computer To take ownership of a data source select it in the list box and click Own Your computer is now responsible for the data source The com
32. You must have Word 95 Word 97 Word 2000 or Word 2003 installed on the computer to use the Report Writer The options and criteria selected from the RMS Variations Panel will be inserted into a report template and saved to a directory For more information see the Report Writer section on page 3 21 Command Button Display Type by Site Name 5 2 S es gt IRVFI Histogram m RVFI by Site Name i Site Count Cumulative Frequency o o o in StDev 5 354 w Aouanbai4 aeneinuno o o o a a eer ae 2 o L 1 3 6 7 RMS Variation Event Count EPRI Electrotek Figure 39 RMS Variation Frequency Index at Each Monitoring Site Electrotek Concepts Inc 3 16 Display Type Button t 3 RMS Variation Magnitude Time Scatter Plot Timeline Time Line RMS Variation Magnitude Time Scatter Plot LCUBSub from 11 25 2006 to 11 26 2007 N T 0 lt 3 gt m Jan 2007 EPRI Electrotek Figure 40 RMS Variation Magnitude Scatter Plot 3 5 1 3 Harmonic Statistics The Harmonic Statistical Summary form is a means to statistically summarize voltage and current harmonic distortion The characteristics that can be summarized include THDy TDD and individual voltage and current harmonics The main user dialog depicted i
33. al sites with line line voltages that are derived from the line neutral voltages of other sites Virtual line line voltages configured on this tab will be derived automatically during data source import if that option is enabled in the data source setup To manually derive the measurements now select one or more sites specify a date range and click Derive Now Virtual Char Use this tab to create virtual sites with characteristic rms voltages that are derived from the line neutral voltages of other sites Virtual rms voltages configured on this tab will be derived automatically during data source import if that option is enabled in the data source setup To manually derive the measurements now select one or more sites specify a date range and click Derive Now This is an optional add in module for PQView RTF Opens a form which lets you unpack steady state samples into the Steady State Value and or the Steady State Harmonic tables This form can also delete unpacked samples Opens a form which lets you correlate event records using system event records Opens a form which lets you manually characterize or recharacterize already loaded events now For CREG 024 Users The user can now cancel the re characterization process by using the Esc key Opens a form which you can use to set the b3 flag to true if either of the following conditions is met e ifthe rms load current above a minimum value is found e if a manually
34. ar to Figure 60Fieure 60 displayed Electrotek Concepts Inc 4 9 Tm SOL Server Enterprise Manager Console Root Microsoft SOL Seryers SOL Server Group E File Action View Tools Window Help e Amx TAR 88 C Console Root SQL Server Group 1 Item Microsoft SQL Servers g 3 local Windows NT lacal Databases Windows master model msdb Northwind POView_DemoDB pubs 9 tempdb Data Transformation Services Management Replication Security Support Services Meta Data Services Figure 60 Microsoft SQL Servers 2 From the SQL Server Group tree select the Server upon which you will create the database For this example the server is local Windows NT 3 Highlight the new PQView database you just created in the Databases folder In this example the PQView database is PQView_DemoDB 4 Select Action gt Properties from the menu bar The database Properties dialog box displays In this example it is PQView_DemoDB Properties Tip You can also right click the highlighted database and select Properties 5 the Options tab of the database Properties dialog box select Simple from the Model drop down list box You have now set the Recovery or backup option for the database Leave all other defaults on this tab as they are Note If you select the Full option you must be sure that you have enough hard disk space to accommodate the same amount of file space for t
35. automatic data source processing New Power Quality Database Open Power Quality Database Close Power Quality Database Data Sources Start Background Processing Database Connections Figure 13 Selecting Start Background Processing from the File Menu to enable Automatic Data Source Processing When background processing is enabled PODM checks to see if it is time to import a data source once every 10 seconds 2 4 2 4 Specifying Start and End Macros Macros can be run before and after each import operation The Start Macro and End Macro list boxes allow you to specify the macro that is to be run before and after an import operation respectively Note The End Macro is run only if the import operation is successful If these fields are blank then no corresponding macro is run An included macro that is useful when specified as an End Macro is named Delete Future Records When run it automatically deletes measurements that are more than three days 72 hours in the future This macro is useful for automatically filtering bad measurement dates from your database Electrotek Concepts Inc 2 15 2 4 2 5 Setting the Import Data Selection After you have successfully configured a data source specification as described in the preceding sections the list of sites available from the data source are displayed in the Sites list box You can specify to import all sites or you can mark specific sites in the l
36. cale country code setting set to Colombia 2 4 2 Setting Up the Data Source The Data Source Setup dialog Figure 12Figure 12 opens whenever you create a new data source or select an existing data source and click Setup This dialog box also appears by double clicking on a data source in the Data Sources list box For CREG Summary Report Users When creating a new data source for computers configured with a locale country code set to Colombia the checkbox to create CREG summary reports is marked automatically and the output folder is set automatically to the PQView application folder for example C Program Files PQView30 Setting up a new data source includes the following tasks as described in the next sections e Setting the Data Source Name Scheduling Imports Enabling Automatic Data Source Processing Specifying Start and End Macros Setting the Import Data Selection amp Data Source Setup x Name Sample Data Source Description sample data source Specification PQDHPNDS32 DLL PNDSARCH C PQDATA Start poll at Repeat every Minutes Sites Filter Start macro End Macro Sites all Marked Date Range Characteristics Defaults Deletion 591 Derivations Other Database Export RelayStar Select Date and Time Range Option all NewData not older than days Reload last hours From to UTC Em CoN Data Reloading Leave previously loaded data unchanged C Replace previou
37. ccess Line 127 User or role pqview already exists in the current database Server Msg 15023 Level 16 State 1 Procedure sp grantdbaccess Line 127 User or role pqweb already exists in the current database 1 rou s affected lt Grids Messages Query batch completed wi EPALPIBLOOSLT 8 0 EPRI pjbIO03 52 PQView_DemoDB 0 00 11 rows Ln131 Col1 Figure 58 Check the Messages tab of the Query Window after Running the Script File Electrotek Concepts Inc 4 7 Tip If you do not see any error messages after the script file runs click the Messages tab at the bottom of Query window 4 2 1 Editing the Script File Roles are created at the database level and the user accounts are defined across the entire SQL server instance The permissions on the various PQ View tables are listed in the PQ View3x sql script file After the script creates the roles it creates the user accounts You may want to edit or delete the section of the PQView3x sql script file to create security permissions that are appropriate for your organization The section to edit starts near the end of the script file at line 7813 in this example after the comment line Create a role for reading and writing to the database as shown in Figure 59Figure 59 I Create a role for reading and writing to the database i Query EPALPJBLOO3LT7 POView_DemoDB EPRI pjbl003 C Program FilesIPQView301SQLAPOView3x BR Eee Giv
38. cepts Inc 3 1 The table below describes commands available from the PODA View menu Table 9 View Menu Commands for the PQDA Site Selection Date amp Time Selection Events Monitor Availability RMS Variations Trends Map Report Writer Report amp Tools Electrotek Concepts Inc Opens the Select Sites window where you can select sites to include in reports Opens the Select Date and Time window where you select the date and time range Only measurements greater than or equal to the From date and less than the To date will be included in analysis reports Leaving the From or To fields blank will leave that date limit range unbound Opens the PQ Event Viewer window where tabs are available for viewing the event list setting preferences and selecting query shortcuts Opens the Monitor Availability Reports window where you can select sites to analyze select a date range select a report and then click the print preview to open a report Opens the RMS Voltage Variations Analysis Panel where tabs are available for Charts and Reports Report SARFI Preferences and Event Filters Opens the Steady State Trends window where tabs are available for Select Formats Profile Compliance Aggregation Interval Operations Filters and Options Opens the PQView Site Map window where you can select sites the date range select actions for showing voltage sags and interruptions and open ESRI S
39. commercial and free runtime version of Microsoft Access 3 The disk space requirement does not include space needed for user databases temporary files and supporting system files Electrotek Concepts Inc 1 4 1 4 Using PQView A Three Step Process Using PQView is a three step process 1 Use the PQDM program to create a new Power Quality Database from your existing data files New database files are created from template files which contain the table structure but no data e Microsoft Access Users For steps see the section Creating a Power Quality Database on page 2 9 e Microsoft SQL Server 2000 Users For steps see the section Creating a New PQView Database with Microsoft SQL Server 2000 on page 4 1 e Microsoft SQL Server 2005 Users For steps see the section Creating a New PQView Database with Microsoft SQL Server 2005 on page 5 1 2 Use PQDM to import data into the Power Quality Database For steps see the section Managing Data from Data Sources on page 2 11 3 Once you have created a database you can run the PQDA program to generate reports trend plots histogram plots and correlation plots from the database For steps see the sections in Using the Power Quality Data Analyzer starting on page 3 1 Electrotek Concepts Inc 1 5 2 Using the Power Quality Data Manager This section provides detailed steps for completing the following key tasks in the Power Quality Data Manager
40. cy in hertz for example 50 or 60 View the list of properties associated with the site 2 5 2 Viewing and Editing Sites Sub Window Properties To edit or add properties to the sites double click on the Site icon or select Sites from the View menu The Sites window opens Note that both the parent and connection fields contain a drop down list to facilitate your selection It is important that both the nominal base voltage and nominal fundamental fields be specified as some reports dealing with normalization may not function correctly without these values Electrotek Concepts Inc 2 18 5 Sites Site ID T amp amp 20 WA Re Site Name SITE1 Description 13 2 kv 25 MYA Substatic Source Name Sample Data Source Rank 0 Parent UTC Offset 5 Use DST Correction Connection 3p4w Nominal Base Voltage V 7448 Nominal Fundamental Frequency 60 Properties 1 1 1870 1 1 1970 0 3 12121970 1 1 14 1870 14970 Record 14 4 116 gt of 4 _ lowerRMSthresl upperRMSthres Record 14 1 bk pe of 4 Figure 15 Sites Window BEE At the bottom of the Sites window properties are added by entering a name that identifies the property in the Name field EB Sites Site ID T amp amp ob 9 Site ISITE1 Description 13 2 25 MYA Substatic Source Name Sample Data Source _
41. d to normalize the value of total harmonic rms current to compute TDD Or you can specify a value of current for normalization 3 5 1 4 Monitor Availability Reports Monitor Availability calculations indicate if a monitoring instrument is on line or off line on a given day A meter is considered on line if an event is found on a particular day or if rms voltage steady state data is found To open Monitor Availability Reports select Monitor Availability from the View Menu or click the Reports link under Monitor Availability in the Reports amp Tools window The Monitor Availability dialog box opens Electrotek Concepts Inc 3 19 Monitor Availability Reports Select sites to analyze select a date range ER 8 select a report and then click the print preview to open a report Summary Table Summary Report Summary Report by Month Summary Report by Month with Totals Unavailability Report Monitor availability calculations tell whether a monitoring instrument is on line or off line on a given day meter is considered on line if an event is Found on a particular day or if rms voltage steady state data is Found Figure 44 Monitor Availability Reports Monitor Availability Reports are designed to list the number of days per month that each power quality monitor is online The following reports are available Summary Table Summary Report Summary Report by Month Summary Report by Month with Totals Unavailab
42. dates measurement databases automatically once per day manually or as fast as once every minute Figure IFigure below shows the data flow for the Power Quality Data Manager PQDM Power Quality Data Manager N Site and Characterized Raw Event Event Data Data Y Power Quality Instrument Data Database e g PASS Data Figure 1 Power Quality Data Manager Data Flow PQDM characterizes power quality data from different types of monitoring instruments providing you the flexibility to decide how to organize data PQView is compatible with the following data sources e Dranetz BMI Signature System Encore Series DataNode Ethernet connected InfoNode systems and PCInfoNodes NodeLink or NodeCenter e IEEE std 1159 3 2003 PQDIF Dranetz BMI SoftSwitching Technologies Power Measurement PMIG Unipower e PQNodeQG meters from PASS and PES Power Xplorer amp PowerGuide or Power Guia e IEEE Std C37 111 1991 1999 COMTRADE Schweitzer Engineering Laboratories SATEC ABB GEG E Max LEM Square D e EDMI EziView recorded by MK3 and MK6 meters e Electro Industries GaugeTech Communicator Log Files Fluke Reliable Power Metrics in Scenario and PAS Omega database format e HIOKIG CSV files by PQA HiView Pro e Landis Gyr Siemens Quad4 and Quad4 Plus meters e Schneider Electric Power Measurement ION ACM meters in ION Enterprise and PEGASYS databases e SoftSwitching Technologies I GR
43. der A user account for read write access to the database pqview A user account for read only access to the database pqweb You can edit the PQ View3x sql script file to create security permissions that are appropriate for your organization For more information see Editing the Script File on page 4 8 Electrotek Concepts Inc 4 5 Complete the following steps to run the script file 1 2 Know the location of the PQ View3x sql script file before you begin For this example we assume it is on the hard drive in folder c Program Files PQView SQL In SQL Server Enterprise Manager highlight the new database you just created Caution Verify that that the database you have just created is highlighted It is easy to run the script file against the wrong database 5 SQL Server Enterprise Manager Console Roo j File Action View Tools Window Help eo amp m m 2 dB J Console Root Microsoft SQL Servers 3 SQL Server Group Er local Windows NT Databases 9 master ata Transformation Services Management Replication ecurity upport Services Meta Data Services 5 5 Figure 56 Verify the Database Name before Running the Script File Select Tools gt SQL Query Analyzer from the menu bar Query window appears Highlight the database you just created and check that it matches the database listed in the drop down menu in the SQL Query Analyzer menu bar If the correct database name is not display
44. e Name configured on your client machine in order to access SQL Server databases The preferred method of connecting to the SQL database however is to address the SQL server directly Support for ODBC connections to PQView databases in PQView will be discontinued in 2008 4 In the Server field type the name of the SQL server upon which the PQView database resides Or get a list of all available SQL Servers in your network by clicking the Browse button as shown in Figure 61Fiseure 61 and then select the server name upon which the PQView database resides OR If your PQView database and SQL Server are on the same machine you can leave the Server field blank use the loopback IP address 127 0 0 1 or use the alias local as the server name amp Open Power Quality Database Use this Form to connect to an existing measurements database Specify the database type and connection information then press the OK button Recently Used Y Cancel Database Type C Microsoft Access Microsoft SQLServer C ODBC Data Source Server Database PQView DemoDB User Name paview Password Figure 61 Open Power Quality Database Dialog Box 5 In the Database field type the name of the PQView database Tip Click the button to get a list of all available databases on your server Select the PQView database you just created In the User Name field type the user ID In the Password field type the password for the user ID in St
45. e read append edit and delete permissions to the role pqview writer GRANT SELECT INSERT UPDATE DELETE ON Channel TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON ChannelProperty TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON ChannelPropertyValue TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON ConnectionType TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON Conversion TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON Event TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON EventProperty TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON EventPropertyValue TO pqviewv writer GRANT SELECT INSERT UPDATE DELETE ON EventTrigger TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON EventTrend TO pqview writer GRANT SELECT INSERT UPDATE DELETE Info TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON Lock TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON Notification TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON RMSVariation TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON Site TO pqview writer GRANT SELECT INSERT UPDATE DELETE ON SiteProperty TO pqview writer Successfully loaded query file C Program File EPALPIBLOOSLT 8 0 EPRI pjbl003 52 POView_DemoDB 0 00 00 Figure 59 Section of PQView3x sql Script File to Edit Electrotek Concepts Inc 4 8 4 3 PQView and PQWeb Database User ID Password and Role When you c
46. e template files are installed in your PQView directory and labeled with the extension Additional templates are installed with Add In packages To create a new database complete the following steps 1 Fromthe File menu select New Power Quality Database The Select Template Database dialog box appears Figure 3Figure 3 3 Select Template Database Select a Template to use to create the new Power Quality Database Normal ji mm 3 46 0 Database ns aGsassa Cancel Figure 3 Select Template Database Dialog 2 Accept the most recent default template and click OK The New Power Quality Database dialog box appears Specify the name and directory for your new Power Quality Database Figure 4Fieure 4 and click Save Your new database automatically opens as described in the following section Opening and Closing Existing Power Quality Databases Hew Power Quality Database x Save Files E3 a sample21 mdb 2 sample310 mdb 2 system310 mdb File name sample21 mdb Save as type Microsoft Access Databases mdb E _ Cancel Figure 4 Standard File Dialog Electrotek Concepts Inc 2 9 2 3 Opening and Closing Existing Power Quality Databases PQDM operates on one Power Quality Database at a time To open and or close a Power Quality Database complete the following steps 1 From the File menu select Open Power Quality Database to specify the database
47. ed in the drop down box on the menu bar click the down arrow next to the drop down box and select the new PQ View database you just created as shown in Figure 57Eigure 57 Warning The script file deletes any tables triggers and defaults that are already in the PQ View database Be sure to select the correct PQ View database and not an existing POView database when you run this script file Electrotek Concepts Inc 4 6 SOL Query Analyzer File Edit Query Tools Window Help S Pe A v Query EPALPJBLOOS3LT7 master EPRHIpjbl003 Untitled1 Figure 57 Verify the Database Name in SQL Query Analyzer xd Select File gt Open 6 Browse to where the script file is stored on your hard drive 7 Select the file PQView3x sql In this example the script file is in the c Programs Files PQ View 30 SQL folder 8 Click Open 9 Optional Edit or delete the section of the PQView3x sql script file to create security permissions that are appropriate for your organization For more information see the section Editing the Script File on page 4 8 10 From the menu bar select Query gt Execute 11 Check the results of running the script file after it has been executed Scroll down in the lower half of the screen to see the results as shown in Figure 58Eigure 58 The role pqview reader already exists in the current database Server Msg 15023 Level 16 State 1 Procedure sp grantdba
48. een entered Remove Filter Sort Disables the filter after the criteria have been entered Save Record Saves changes to the current record Refresh Refreshes screen Requery Synchronizes the records on the window with the database Data Entry Creates a new empty record Add RMS Variations Lets you select a site for which you can add an rms voltage variation record Also lets you specify a time when the event occurred You must specify an event duration for the RMS variation and a voltage magnitude for each phase To complete the entry click Add Record Derive Opens the Add Derivations window with tabs for Sites Selected Sites Virtual Line Line and Virtual Char as described below Sites These derivations are performed on all sites in the database To manually derive the measurements now specify a date range and click Derive Now They can also be completed during data source import if they are enabled in data source setup Electrotek Concepts Inc 2 5 Derive XTF Unpack Samples Correlate Events Recharacterize Set Load Flag Delete Sites Copy Merge Delete Electrotek Concepts Inc Selected Sites These derivations are performed on the sites selected in the database To manually derive the measurements now specify a date range and click Derive Now They can also be completed during data source import if they are enabled in data source setup Virtual Line Line Use this tab to create virtu
49. entered rms variation or interruption is accompanied by a load interruption It also removes the b3 flag from events that do not meet either of those two criteria Opens the Delete Sites window which lets you select one or more sites to delete from the database and then click Delete The system deletes all measurements associated with the site Opens a tool that lets you copy merge or delete measurements 2 6 Rescue Execute Query 2 1 6 Tools Menu Commands Opens a tool that lets you modify data already loaded in the connected database Opens the Execute Query window which lets you enter an action SQL statement in the text box Also lets you run multiple queries The table below describes the commands available from the PQDM Tools menu Table 5 Tool Menu Commands for the PQDM Compact and Repair Another Database Compact and Repair This Database Compact and Repair PODA Rebuild SQL Server Indexes Zoom Box IEEE COMTRADE File Viewer Display Event Sample Count Display Steady State Sample Count Fix 1159 3 Annex C Folder Add Ins Electrotek Concepts Inc Opens a window that lets you compact and repair another database When a database becomes corrupt or your computer experiences a power outage or hardware problem it may be necessary to repair a particular database This command lets you perform this function Opens a window which lets you compact and repair this database During routine use
50. ep 6 Caution Be sure you are connecting to the database with a user ID having read write permissions because you will be adding look up records to the database For more information about possible errors you may see if you try to connect to the database without the proper user ID see Using the Correct Database User ID on page 4 12 Click Yes for the first informational message Missing Lookup Records 9 When PQView has finished processing your new PQView SQL Server database is ready to be populated with data Figure 62Fieure 62 displays the ODBC Database dialog box that appears when you connect MO 9e Electrotek Concepts Inc 4 11 E ODBC DATABASE POView DemoDB Sites Events Frorn To Steady State Measurements To Figure 62 ODBC Database Dialog Box 10 Select File gt Exit to close PODM Note Using the Correct Database User ID When you connect to the PQView database you must connect to the database using a user account with read write permissions on the database If you connect with a user account with read only permissions you may see the following error message ODBC insert on a linked table Channel failed Electrotek Concepts Inc 4 12 5 Creating a New PQView Database with Microsotft SQL Server 2005 This section assumes that you have installed both SQL Server 2005 and SQL Server Management Studio You can use the same instructions with SQL Server 2005 Express edi
51. event data properties triggers RMS variations transients and trends Opens the Steady State Measurements window which allows you to view tables of all of the data for individual steady state measurement records including site name source name channel name start time start time Offset end time end time Offset number of samples and samples 2 3 Channels Site Properties Event Properties Channel Properties Source Properties Form or Datasheet View UTC Time Standard Time Daylight Saving Time Log Electrotek Concepts Inc Opens the Channels window which allows you to vlew all of the data for individual channel records including channel name description rank parent and properties Opens the Site Properties window which allows you to enter site properties add site properties to all sites add site properties to active sights and import export site properties from comma separated vale CSV files Opens the Event Properties window which allows you to enter event properties including name description rank and parent Opens the Channel Properties window which allows you to enter channel properties including name description rank and parent as well as adding properties to active channels and adding to all channels Opens the Source Properties window which allows you to enter source properties including name description rank and parent Allows you to toggle between the for
52. f 5 Figure 51FEigure 51 shows an example where statistics are computed for Vays The user chose to compute the 5 percentile and the 50 percentile for the selected site and date range amp Steady State Statistics Calculator Formats Aggregation Filters Word Profile Select the site s characteristic and phase s to analyze Press the Compute Stats command button to calculate statistics Select Sites _ Quick Pick Select Characteristic RMS Select Phases Count 12384 Minimum 68710 Average Maximum 5470 Range 157600 Standard Devia ces QQ 7270 02 737800 75 93 742 51 82 23 c 750 son ew w lt p p 000 lt 000 990 gt 000 0 01 Compute Stats Histogram Histogram Setup Copy to Notepad Print Preview Figure 51 Single Site Statistical Calculator Electrotek Concepts Inc 3 23 The Copy command copies all of the statistics to the Windows Clipboard The Print Preview button lets you print a one page report summarizing the statistics Electrotek Concepts Inc 3 24 4 Creating a New PQView Database with Microsoft SQL Server 2000 This section describes how to create a new PQView database with Microsoft SQL Server 2000 The table below describes where to complete each task Table 14 Overview Creating a New PQView Database with Microsoft SQL Server 2000
53. gt n _ Summary 32 2 m YS am Y m SABINTEST SQLEXPRESS SQL Server 9 0 3042 SABINTEST E a PQView DemoDB SABINTESTYSQLEXPRESSIDatabaseslPQView DemoDB 6 Item s Lg Manager Database Diagrams Tables d views Synonyms Rename Programmability Security Reports Delete Refresh Properties Figure 66 Select New Query 5 Select Edit gt Insert File As Text from the menu bar The Insert File dialog box displays 6 Browse to the file PQView3x sql file on your computer In this example it is in c Program Files PQView30 SQL PQView3x sql 7 Select the PQView3x sql file and click Open 8 Optional Edit or delete the section of the PQ View3x sql script file to create security permissions that are appropriate for your organization For more information see the section Editing the Script File on page 4 8 and the section PQView and PQWeb Database User ID Password and Role on page 4 9 9 Verify that you have the correct database selected as shown in Figure 67Figure 67 Electrotek Concepts Inc 5 4 Microsoft SQL Server Management Studio Express Fie Edit View Query Tools Window Community 4 New Query 8 GF G ES RE ao 4 tay PQView_DemoDB B Execute Y 1 Object Explorer 32 m Y SABINTESTISQLEXPRESS SQL Server 9 0 3042 SABINTESTAE El Databases 8 System Databases J
54. h Portable Network Graphics PNG format Supported versions include Internet Explorer 4 72 or later and Netscape Navigator 4 72 or later Table 1 Platform Requirements Computer and Processor Personal computer with an Intel Pentium 233 megahertz MHz or faster processor Pentium III recommended Operating System Microsoft Windows 2000 with Service Pack 3 SP3 Windows XP Windows 2003 Additional Software Required Microsoft Access 2000 Access 2002 Access XP or Access 2003 runtime versions acceptable Optional Microsoft Word 2000 2002 or 2003 Microsoft Excel 2000 2002 or 2003 TOP The Output Processor Microsoft SQL Server 2000 or 2005 Memory 128 MB of RAM or greater Disk Space 45 MB Display Super VGA 800 x 600 or higher resolution monitor 1 PQView can also be run on the following operating systems Microsoft Windows 95 Windows 98 Windows 98 Second Edition Windows Millennium Edition Windows Me Windows NT 4 0 with Service Pack 6 SP6 Effective June 30 2005 the only Microsoft operating systems supported by PQView software is Windows 2000 Windows XP and Windows Server 2003 Because Microsoft no longer supports Windows 95 98 NT and ME the anti virus software companies for example McAfee Norton no longer provide updates or support for the anti virus definitions Therefore PQView no longer officially supports these older Microsoft operating systems 2 PQView is compatible with both the
55. hapefiles Opens the Report Writer window where you can create edit and run configurations Each report can have different configurations using combinations of check boxes and text boxes Available tabs include General Events Event Filters Metering Imbalance Harmonics Flicker Aggregation and Compliance Opens the Reports amp Tools window with links available under the following categories Viewers RMS Variations Steady State Analysis Report Writer Monitor Availability System Events and Report Browser 3 2 Report Browser Form View or Datasheet View 3 1 4 Format Menu Commands Opens the Report Browser window where you can select or mark report s After the report s has been marked or selected you can view or print an individual report or batch print a number of reports Lets you toggle between form or datasheet view when you view reports The Format menu contains standard and other formatting functions for example Font Datasheet Row Height Column Width Hide Columns Unhide Columns and Freeze Columns 3 1 5 Records Menu Commands The following selections are used only when forms displaying more than one record at a time are open Table 10 Record Menu Commands for the PQDA Filter Sort Apply Filter Sort Remove Filter Sort Save Record Refresh Data Entry 3 1 6 Window Menu Commands Provides the following options Filter by Form Filter by Selection Filter Excluding Selectio
56. he database backup file that will be the same size as the data file of files of the database itself 6 Click OK 7 Select File Exit to close SQL Enterprise Manager 4 5 Opening the Database Last you must open the new SQL Server database with POView s PQ Data Manager to prepare it to accept data Before you can open the database ensure that you have the following connectivity information from your database administrator Server Name or IP address PQView Database Name User ID e e e e Password Electrotek Concepts Inc 4 10 If your database administrator only provides you with database name and user ID you can still try to connect to the PQView database by leaving the User Name and Password fields blank When these fields are blank you connect to the database using Windows Authentication mode 1 Select Start gt Programs gt PQView 3 0 gt Power Quality Data Manager 2 Select File gt Open Power Quality Database The Open Power Quality Database dialog box displays as shown in Figure 61Eigure 61 Tip The File gt New Power Quality Database command creates a Microsoft Access database from a template 3 Inthe Database Type section select the radio button for Microsoft SQL Server Note to Microsoft SQL Users Power quality databases housed in Microsoft SQL Server are opened by specifying ODBC Databases in the Files of type box standard Select Data Source dialog box appears You must have an ODBC Data Sourc
57. he tree under Microsoft SQL Servers on the left side of the window From the SQL Server Group in the tree select the server upon which you will create the database For this example the server is local Windows NT The local server is the SQL server instance running on the current computer Note On a given server you can run multiple SQL Server services each with their own ports logins and databases Each of these services is called an instance of SQL Server Highlight the Databases folder Select Action New Database from the menu bar or right click the Databases folder and select New Database The Database Properties General tab dialog box displays as shown in Figure 53Figure53 P Electrotek Concepts Inc 4 2 Database Properties General Data Files Transaction Log tl Name Database Status Owner Date created Size Space avallable Number of users Unknown Unknown Unknown Unknown Unknown Unknown Backup Last database backup Last transaction log backup None None Maintenance Maintenance plan Collation name None Server default 0 Cancel Figure 53 Database Properties General Tab 6 Inthe Name field on the General tab type the name of your PQ View database For this example the name is PQView_DemoDB 7 If you want to change the data file folder from the default location click on the Data Files tab and specif
58. icrosoft Access or Microsoft SQL Server Through its components PO View builds measurement databases writes summary reports computes power quality indices views waveforms rms samples and trend steady state quantities via workstations and web browsers Throughout the world power providers industrial power consumers consulting companies and university researchers widely recognize PQView for its capabilities and flexibility PQView helps build databases with billions of measurements from thousands of monitoring plants taken by many different types of meters including power quality monitors voltage recorders in plant monitors and digital fault recorders It can store and analyze information with the measurements about cause and source of triggered events as well as evaluate the financial impact of events to both a power provider and a power user It can quickly extract meaningful information from a one megabyte or one terabyte database In addition PQView provides the following specialized functionality e Radial and network fault location e Compliance with international and national power quality standards including EuroNorm 501060 the Colombian Energy and Gas Regulatory Commission CREG and the Norwegian Water Resources and Energy Directorate NVE Voltage sag and interruption contract management Power quality event log correlation with SCADA operation logs Load forecasting Wind generation feasibility and assessment PQVie
59. ility Report These reports present a summary of the availability of each monitoring instrument on a monthly basis Availability is based upon the existence of any measurement taken by the instrument for a given day Any day during a particular month that measurements were taken is one monitor day The report displays the number of monitor days and the number of triggered events It also reports the date range as well as the availability of the monitor expressed in percent see Figure 45Fieure 45 Monitor Month Monitors Days Triggered First Date Last Date Avaibhility SITE1 May 1995 31 113 5 1 95 5 31 95 100 Figure 45 Example of the type of information in Monthly Report 1 triggered measurement that is records in the the Event Table or steady state measurements on phase V RMS A or V RMS AB will qualify a monitor as being available for a given day Electrotek Concepts Inc 3 20 The Monthly Availability Report with Totals is identical to the Monthly Report with the exception that the totals for all categories are included Figure 46 Totak for site SITE il 113 511195 5 31 05 100 Figure 46 Example of Totals included in Monthly Report with Totals Report 3 5 1 5 Conformance with CREG 024 2005 Report Window To view the CREG reporting tool select View gt Reports amp Tools and then the CREG 024 Report link under the Report Writer section You can select between an English user interface and a Spanish user interface
60. ink PASS PES PQDIF and Exclude options The table below describes the commands available from the PODM Setup menu Table 6 Setup Menu Commands for the PQDM Standard End Macro PQNotify Messages COMTRADE MAP Fault Location Compliance Opens an obsolete tool as all its major functionality is available in Data Source Setup or under the Records menu This tool will not be available in future versions of PQView Opens the Messages window that lets you configure e mail notification through these tabs General RMS Variation Imbalance No Data Outbox and Sent mail Opens a window that lets you map COMTRADE channels to PQView sites and channels To use this form you must have the Radial fault Location Add In Module or Reactance to Fault Add In Module installed Opens a window where you can set up compliance rules 2 1 8 Menu Shortcuts via the Keyboard Table 7Table 7 below shows the keyboard shortcuts available from the PODM menus Table 7 Menu Shortcuts via the Keyboard PQDM Cut Copy Delete Find Paste Replace Save Record Select All Records Undo Electrotek Concepts Inc Ctrl X Ctrl C Del Ctrl F Ctrl V Ctrl H Shift Enter Ctrl A Ctrl Z 2 8 2 2 Creating a Power Quality Database PQDM allows you to create any number of Power Quality Database files PODM creates new database files from template files that contain the table structure but no data Thes
61. ist by clicking on the check box located to the left of each site s name and then choose to import data from the marked sites Sites that do not already exist in the database are automatically added during an import operation The import operation fills in the siteID description and data source values in the Sites Table for the new site You must manually enter any additional Sites Table information you require The Date and Time Range section lets you specify a time range for which events will be imported Any event files that are found to have occurred outside this time range will be ignored You can enter any valid dates and times into these edit boxes The following Date and Time Range options are available e All to select all data dates found in the data source will be imported This option is usually wasteful if performed more than once e New Data This option is more recent than the latest event per site currently in the database It is useful when importing data on a daily basis Use the but not older than text box to prevent loading of very old data e From To Specify the UTC date range to import e New Files in Each Site s Data Folder In the Data Reloading box there are two available options Replace Previously Loaded Data and Leave Previously Loaded Data Unchanged If for any reason you want to change the properties of the data that have been loaded and include other properties then select Replace Previously Loaded
62. istics Calculator Formats Aggregation Filters Word Profile Select the site s characteristic and phase s to analyze Press the Compute Stats command button to calculate statistics Select Sites _Quick Pick Figure 50 Single Site Statistical Calculator Initial Window Select Characteristic Select Phases Count j Minimum je Average j si Maximum Range SSS Standard Devia Say cst 0 9 SI Range SE e sa sado wep p gt f BEE Compute Stats Histogram Histogram Setup Copy to Notepad Print Preview E vj The calculator is a single form that lets you quickly compute a variety of statistics on steady state sampled data The quantities that can be evaluated include steady state sampled voltage current and power qualities including but not limited to Vms Vina Vs S pf and df The statistics that can be computed include minimum average maximum standard deviation sum and count Up to three cumulative probability values can be computed simultaneously for example 05 CP50 and CP95 Additionally you can specify up to three thresholds The calculator counts and reports the number of samples above each threshold This computation is useful for example if you want to count the number of samples of V that violated the IEEE Std 519 1992 limit o
63. lick Open The Data Source Setup dialog box opens Figure 1 1 Figure below shows the dialog that appears if you select Dranetz BMI InfoNode DualNode PCInfoNode as the data format 8 Specify InfoNode Connection x Specify connection information For the InfoNode IP Address 127 0 0 1 se User Name guest Password PQView Site Names will be derived from DataNode names by appending an optional prefix or suffix to the name of the DataNode Prefix Suffix By default downloaded files are saved to a temporary folder and then deleted IF you want to save the files after downloading specify a permanent download folder Folder d Figure 11 Specify InfoNode Connection Dialog for Dranetz BMI InfoNode DualNode PCInfoNode Note If the PCInfoNode service is running on the same computer that is running PQView then you can use 127 0 0 1 for the IP address 127 0 0 1 is the standard IP address used for a loopback network Electrotek Concepts Inc 2 13 connection The default password for the InfoNode user name guest is password After you Enter the IP Address user name and password click OK The Data Source Setup dialog box opens For CREG Report Users An option is available when downloading directly from InfoNodes and PCInfoNodes Status observation events are now added to the PQView database as interruption events This option is not enabled for new data sources unless your computer has a lo
64. m and datasheet view when viewing properties Provides Coordinated Universal Time UTO based on the local computer s time zone information and clock Many data sources for POView provide their time stamp in UTC For those data sources you must provide a UTC offset in PQView s Site table to display a measurement in local time Opens the Standard Time Zone Information window Opens the Daylight Saving Time Zone Information window Opens the PODM log window 2 4 Data Source Log Opens the PODM log window for the data source Background Processing Log Opens the Background Processing Log window which shows background processing messages This window does not have to be open for background processing to run 2 1 4 Format Menu Commands The Format menu contains standard formatting functions for example Font Row Height Column Width etc 2 1 5 Records Menu Commands The table below describes the commands available from the PODM Records menu Note The following commands are used only when the Site Event or Steady State windows are open Filter Sort Apply Filter Sort Remove Filter Sort Save Record Refresh Requery and Data Entry Table 4 Record Menu Commands for the PQDM Filter Screens records by form by selection excluding selection or according to specified criteria for filtering Sort Arranges records either in ascending or descending order Apply Filter Sort Applies the filter after the criteria have b
65. mization Enabled Numeric Round Abort Parameterization 9 View connection properties Figure 65 New Database Options Dialog Box 11 Optional In the Recovery model field select the Simple option from the drop down list or verify that this is the default option Tip For more information about this optional step see Optional Selecting a Recovery Option Optional Selecting a Recovery Option on page 4 9 in Creating a New PQView Database with Microsoft SQL Server 2000 12 Click OK Your new PQView database is created Tip Leave the SQL Server Management Studio Express open See the next section to run the script file Electrotek Concepts Inc 5 3 5 2 Running the Script File To run the script file complete the following steps 1 In the Object Explorer left hand navigation of Server Management Studio Express expand the Databases folder tree 2 Highlight the name of the PQView database you just created In this example it is PQView DemoDB 3 Right click the selected database A menu selection list displays 4 Select New Query from the list as shown in Figure 66Figure 66 Tip You can also select the New Query button or select File New Query with Current Connect Ensure the correct database name is selected E Microsoft SQL Server Management Studio Express File Edit View Tools Window Community Help 21 New Query 8 27 95 25 BS E Ra Pe
66. n and Advanced Filter Sort Arranges records either in ascending or descending order Applies the filter after the criteria have been entered Disables the filter after the criteria have been entered Saves changes to the current record Allows you to refresh the screen Creates a new empty record The Window menu is used to select the active window if more than one window is open It can also be used to arrange and close windows It functions the same way as in other standard Windows applications 3 1 7 Tools Menu Commands The table below describes the commands available from the PODA Tools menu Electrotek Concepts Inc 3 3 Table 11 Tools Menu Commands for the PQDA Compact and Repair PODM Demo Zoom Box Microsoft Access Options Options During routine use of PQView the PODM MDB database file may grow because Microsoft Access does not fully recover space used by temporary files To recover this space and optimize performance you can occasionally compact and repair these database files Runs a demo showing events for the selected sites and or date range This command can be used to open a popup zoom box in a modal window from the text boxes of most windows Opens a window that displays tabs for the following Microsoft Access options Pages Advanced International Spelling Tables Queries View General Edit Find Keyboard Datasheet and Forms Reports Opens the PODA Options window with
67. n Figure 41Fieure 44 be found by using the PQDA menu bar command View gt Reports amp Tools and selecting from the shortcuts under the Steady State Analysis report group Click the shortcut link Harmonic Statistics The Harmonic Statistical Summary dialog box opens The Harmonic Statistical Summary tool is used to statistically analyze multiple measurements see Figure 4 Fisure AT From the form clicking Voltage Chart opens a window that graphically summarizes voltage total harmonic distortion and selected individual voltage harmonics as Figure 42Fieure 42 shows Clicking Current Chart opens a window that graphically summarizes the total demand distortion and selected individual voltage harmonics see Figure 41Fieure A1 Electrotek Concepts Inc 3 17 amp Harmonic Statistical Summary x This tool is used to statistically analyze multiple harmonic measurements by creating voltage and or current summary charts Select a site to analyze Use the LE calendar button to specify the analyzed date range Specify how to normalize voltage and or current harmonics Specify the phase to analyze Specify the list of harmonics to analyze in the table Select Site Select Voltage Base r Select Current Base SITE1 C vols or Kilovolts C Amps or Kiloamps Select Phase of Fund of RMS CP99 a IHE ic C of RMS C of User Definec So C of Nominal Specify Harmonic s THD Fund Comp
68. nly a particular type or category of events amp 3 RMS Voltage Variations Analysis Panel EE vio Save Preferences Charts amp Reports Report SARFI Preferences Event Filters Graphs and Tables Reports Available r RMS Variation Event List i RMS Variation Event List Spatial Grouping RMS Variation SARFI Event Analysis RMS Variation SARFI System Event Analysis RMS Variation Sensitivity Curves RMS Variation Summary RMS Variation Summary Sort by Site RMS Variation Summary Sort by Site SDGE RMS Variation Frequency Index For Each Site RMS Variation Magnitude Column Chart RMS Variation Magnitude Duration Column Chart RMS Variation Maqnitude Duration Column Chart DPQ gt Timeline Figure 30 RMS Voltage Variations Analysis Panel Note RMS variations can be selected by both voltage magnitude and event duration These categories are based on the definitions in IEEE Std 1159 1995 The RMS Voltage Analysis Panel analyzes rms variations by graphs statistics and indices These analyses present a summary of the event itself The RMS Voltage Variations Analysis Panel permits customization in the creation of events graphs and reports It provides a list of report types that you can customize Note that not all reports are available for all selections These are the available reports RMS Variation Event List RMS Variation Event List Spatial Grouping RMS Variation SARFI Event Analysis RM
69. nts Event Filters Metering Imbalance Harmonics Flicker Aggregation Compliance Multi Site Report Include Table of Contents Single Site Report s Include Table of Figures Save Include Page Footer Rename Output Folder C PROGRA 1 POView30 Template m Run Delete Figure 48 Report Writer Window Lists Several Types of Reports Available To start creating customized Microsoft Word templates for your reports use the check boxes on the General tab to create a summary report for all selected sites or to create a summary report for each selected site You can also select the Table of Contents Table of Figures and Page Footer check boxes to specify whether your templates should include these standard document parts In the Output Folder field specify the location for your Microsoft Word documents The default output folder is the PQView application folder In the Template field specify the location of the template to use for new documents Use the buttons under the Report Configurations panel to the left of the window to create a new report configuration and to save rename run or delete a report configuration 3 5 1 7 Report Browser To display the reports available in PODA select Report Browser from the View menu The Report Browser window opens see Figure 49Eieure 49 From this window you can select a report to view or print Available report types are displayed in a drop down list
70. olumns Allows you to preview documents before printing Opens the Print dialog box Provides database properties including database information version site count source count event count and file information name location size and date Provides file version info for files libraries and controls used by PQView Lets you quit PQDM From the Edit menu standard editing commands are available to cut copy paste find and replace when you are entering text into any PODM Selection windows Commands are also available for selecting and deleting records The Go To selection allows you to navigate through the various site disturbance or steady state records 2 1 3 View Menu Commands The table below describes the commands available from the PODM View menu Table 3 View Menu Commands for the PQDM Site Selection Events Steady State Measurements Electrotek Concepts Inc Opens the Sites window where you can view edit or add site data to the Sites Table Site data consists of site name site description data source for this site sorting rank self reference to the parent record for creating a hierarchical list the UTC offset the flag for Daylight Saving Time connection time Nominal base voltage for example 12000 V and Nominal fundamental frequency that is 50 or 60 Hz Opens the Events window which allows you to view tables of all of the data for individual event records including general
71. on properties REMOVE ca Figure 64 New Database Dialog Box 7 In the Database name field type a database name for your PQView database For this example type PQView DemoDB 8 In the Initial size MB field specify the size of the database by typing a size in this field For this example type 100 MB Tip We recommend using a reasonable initial size for the database such as 10240 MB or 10 gigabytes To anticipate future growth of the database file and gauge an appropriate size talk to your PQView database owner It is easier to set the size of the PQView database to be large now rather than try to fix a database later that is too small 9 Take the defaults for the Log file You do not need to change any defaults on this line 10 In the Object Explorer left hand navigation click Options The Options dialog box displays as shown in Figure 65Figure 65 Electrotek Concepts Inc 5 2 D x Options AA Filegroups lt server default gt E SOL Server 2005 90 Auto Close Auto Create Statistics Auto Shrink Auto Update Statistics Auto Update Statistics Asynchronously Close Cursor on Commit Enabled Default Cursor ANSI NULLS Enabled ANSI Padding Enabled Server ANSI Warnings Enabled SABINTESTSSGLEXPRESS Arithmetic Abort Enabled Connection Concatenate Null Yields Null SABINTEST Administrator Cross database Ownership Chaining Enabled Date Correlation Opti
72. ove from site to site Filters can be used to select a specific set of sites for processing Fields in the Sites window are described in the table below Field Site name Description Source Name Rank Parent UTCOffset Use DST Correction Connection Type Nominal BaseVoltage v Nominal Fundamental F requency Properties Table 8 Fields in the Sites Window Purpose Enter the name of a data gathering site Enter any relevant information Select the data source for this site Enter a sorting rank that overrides the name for displayed values A reference to the parent site record Used to create a hierarchy for the sites For CREG 024 Report Users This field is also used in the CREG 024 report to link a site that only records status measurements for example the feeder site or virtual site to another site that has power quality measurements for example the bus or master site Number of hours to add to a measurement time stamp to convert it to local standard time Universal Coordinated Time is an ISO standard Daylight Savings Time Checking the box activates Daylight Savings Time PQView uses Windows localization information to determine the start and end of Daylight Savings Time From the list box select the type of connection for example three phase three wire three phase four wire and so on Enter the nominal base voltage in volts Enter the nominal fundamental frequen
73. puter that previously owned the data source no longer process it 2 4 7 Deleting a Data Source To delete a data source select it in the Data Sources list box and click Delete 2 5 Viewing and Editing Data Once you open a database you can view and edit the data within that database through windows Separate windows are provided for viewing and editing site information event data and steady state measurements To open one of these windows choose the appropriate command from the View menu or double click on the corresponding icon in the PODM window 2 5 1 Viewing and Editing Site Data The Sites window allows you to view the site description records from the database In addition use this window to enter new site descriptions into the database and to edit site descriptions Sites BE Site ID Site SITE1 Description 13 2 kv 25 MVA Substatic Source Name Sample Data Source Rank 0 Parent Y UTC Offset 5 Use DST Correction Connection raw Nominal Base Voltage V 7448 Nominal Fundamental Frequency 60 Properties Name When Start Value Text Value Object P company 1 1 1970 lowerRMSthresl 1 1 1970 0 9 upperRMSthres 17141970 1 1 Utility 14141970 112370 z Record 14 1 bj p of 4 Record 14 1 bj of 4 Figure 14 Sites Window Electrotek Concepts Inc 2 17 Site information is displayed one site at time The records navigation commands used to m
74. r 3 22 3 5 1 8 Single Site Statistical Calculator 3 23 4 CREATING A NEW PQVIEW DATABASE WITH MICROSOFT SQL SERVER 2000 ___ 4 1 4 1 CREATING THE PQVIEW DATABASE 4 1 4 1 1 PQView Database Size 4 5 4 2 RUNNING THE SCRIPT FILE 4 5 4 2 1 Editing the Script File 4 8 4 3 PQViEW AND PQWEB DATABASE USER ID PASSWORD AND ROLE 4 9 4 4 OPTIONAL SELECTING A RECOVERY OPTION 4 9 4 5 OPENING THE DATABASE 4 10 5 CREATING A NEW PQVIEW DATABASE WITH MICROSOFT SQL SERVER 2005 5 1 5 1 CREATING THE PQViEW DATABASE 5 1 5 2 RUNNING THE SCRIPT FILE 5 4 Electrotek Concepts Inc iv Table of Figures FIGURE 1 POWER QUALITY DATA MANAGER DATA FLOW 1 2 FIGURE 2 POWER QUALITY DATA ANALYZER DATA FLOW 1 3 FIGURE 3 SELECT TEMPLATE DATABASE DIALOG 2 9 FIGURE 4 STANDARD FILE DIALOG 2 9 FIGURE 5 POWER QUALITY DATABASE DIALOG 2 10 FIGURE 6 PQDM MAIN WINDOW DATABASES CLOSED 2 10 FIGURE 7 PQDM MAIN WINDOW CONNECTED OPEN DATABASE 2 11 FIGURE 8 THE DATA SOURCES DIALOG 2 11 FIGURE 9 DATA STORE FORMAT DIALOG 2 12 FIGURE 10 IMPORT SOURCE PATH DIALOG FOR DRANETz BMI NODECENTER DATABASE 2 13 FIGURE 11 SPECIFY INFONODE CONNECTION DIALOG FOR DRANETZ BMI INFONODE DUALNODE PCINFONODE 2 13 FIGURE 12 DATA SOURCE SETUP DiALOG 2 14 FIGURE 13 SELECTING START BACKGROUND PROCESSING FROM THE FILE MENU TO ENABLE AUTOMATIC DATA
75. rce information is stored in the current Power Quality Database allowing you to configure each Power Quality Database independently Electrotek Concepts Inc 2 11 In a network environment it is possible to have a single Power Quality Database receiving data from more than one computer each running PODM From the Data Sources window you can perform the following tasks as described in the next sections Setting the Data Source Format and Path Specification Setting Up the Data Source Importing Data from a Data Source Activating or Deactivating a Data Source Resetting a Data Source Taking Ownership of a Data Source Deleting a Data Source Viewing and Editing Data Viewing and Editing Site Data 2 4 4 Setting the Data Source Format and Path Specification The Specification string is used to associate a data source with the actual data collected from an instrument This string includes both data format information that is what type of instrument created the data and data location information that is where is the data located This Data Store Format dialog box appears after you click New in the Data Sources dialog box see Figure 9Fisure 9 From the Data Store Format dialog box you can view the format selections for instruments supported by PQDM and then select which type of event files to process Select one of the listed formats and click OK Data Store Format Select the format of the Data Store to open
76. reate a new PQView database using the PQ View3x sql script you automatically create a database level user ID and password for the POView and PQWeb products These user IDs are created if they do not already exist on the server instance The last step completed by the script is to add the PQView role to these database level user IDs The PQView user ID automatically is assigned to the pqview writer role while the PQWeb user ID is assigned to the pqview reader role Table 15 15 presents details about the user accounts Table 15 User Account Information Product ID User ID Password Role Role Description Case Sensitive PQView pqview pqview3 pqview writer Grants select insert update and delete permissions to the group PQWeb pqweb pqweb3 pqview reader Grants read only permissions to the group 4 4 Optional Selecting a Recovery Option After a new database is created we recommend that you modify a database recovery option for your POView database This task does not need to be completed if it conflicts with your corporate environment s standard procedure for database backup Note You can select a recovery option after you create the PQView database or run the script file To select a recovery option for your new PQView database complete the following steps 1 In SQL Enterprise Manager expand the tree under Microsoft SQL Servers on the left side of the window if necessary You see a window simil
77. rom text box and June 1 2007 in the To text box Electrotek Concepts Inc 3 7 3 4 Analyzing Selected Data PQDA s main function is to allow you to view Power Quality Data in meaningful visualizations To this end it provides powerful tools for analyzing the data you select These include tools to construct and display correlation plots histogram plots trend plots and reports that can combine graphics and tabular data 3 5 Creating Reports Reports allow you to combine graphics and tabular data that can be grouped sorted and summarized for example sum minimum maximum and average Using the capabilities found in Microsoft Access you can create your own reports Also available in Reports amp Tools is the ability to create histogram correlation and trend plots To display helpful shortcut links to all the reports and analysis tools available in PQDA select Reports amp Tools from the View menu The Reports amp Tools window opens Figure 25Figure25 Reports and Tools DER Viewers Report Writer Event Viewer General Report Writer Map Viewer PQ Index Report RMS Variations EN50160 1557 CREG 024 RMS Voltage Variations Analysis Panel Monitor Availability Reports Steady State Analysis Trends Histograms Profiles and Statistics System Events Phasor Analysis Analysis Details Report Harmonic Analysis Harmonic Statistics Report Browser Figure 25 Reports and Tools Window Subsequent sec
78. rtain functions such as displaying a report in Preview mode the standard Access menus described in the Access manual are active rather than the custom PQDA menus 3 1 1 File Menu Commands The File menu is used to open or close a Power Quality Database for use with PODA The Open Power Quality Database command opens a database file for use by PODA You must first create the database files using PQDM and load data into them before you can open and use them with PQDA The Close Power Quality Database command closes the currently selected database file Selecting Exit closes the database system Additional file menu options consist of standard selections for page setup print preview and print as well as a Send to command for selecting the format of your file output From the File menu you can also select Database Properties and Version Info for database file and version information 3 1 2 Edit Menu Commands The Edit menu allows you to perform standard Windows editing functions such as Copy Cut Paste and Delete when you are entering text into any of the PQDA Selection Windows The Go To selection allows you to navigate through the various site disturbance or steady state records 3 1 3 View Menu Commands Use the commands in the View menu to open the data selection windows and the analysis windows If you are using the commercial version of Microsoft Access you can also open the Access Database window from this menu Electrotek Con
79. s quarter and so on View Site Selection Date amp Time Selection Events Monitor Availability RMS Variations Trends Map Report Writer Reports amp Tools More Reports Form View Datasheet View Figure 23 View Menu Select Date and Time Select the date and time range Only measurements greater than or equal to the From date and less than the To date will be included in analysis reports Leaving the From or To fields Lac blank will leave that date limit range unbound All Today Yesterday Last 24 Hours This Week Last Week Last 7 Days This Month Last Month Last 30 Days This Quarter Last Quarter Last 90 Days This Year Last Year Last 365 Days From gt 11 23 2007 9 00 16 EM To lt 11 24 2007 9 00 16 PM El Figure 24 Select Date and Time Window m r r r r r r If you use the text boxes at the bottom of the Select Date and Time window to enter start and end dates you can enter a time along with the date to further narrow the range The format of the date you enter in the date range filter window depends upon the regionalization information of the computer you are using Note When you select the date and time range remember that the analysis reports include measurements only greater than or equal to the From date and less than the To date For example to set the time range to the entire month of May including May 31 enter May 1 2007 in the F
80. service mark of Electrotek Concepts Inc Electric Power Research Institute and EPRI are registered service marks of the Electric Power Research Institute Inc EPRI Portions Electrotek Concepts Inc 1999 2007 rights reserved Portions EPRI 1999 2007 rights reserved P N UG PQVIEW CHEC Electrotek Concepts Inc 11 TABLE OF CONTENTS 1 GETTING STARTED 1 1 1 14 POWER QUALITY DATA MANAGER PQDM 1 1 1 2 POWER QUALITY DATA ANALYZER PQDA 1 3 1 2 1 Steady State Data Log Analysis 1 3 1 3 PQWEB 1 4 1 4 USING PQViEW A THREE STEP PROCESS 1 5 2 USING THE POWER QUALITY DATA MANAGER 2 1 2 1 NAVIGATING PQDM 2 1 2 1 1 File Menu Commands 2 1 2 1 2 Edit Menu Commands 2 3 2 1 8 View Menu Commands 2 3 2 1 4 Format Menu Commands 2 5 2 1 5 Hecords Menu Commands 2 5 2 1 6 Tools Menu Commands 2 7 2 1 7 Setup Menu Commands 2 8 2 1 8 Menu Shortcuts via the Keyboard 2 8 2 2 CREATING A POWER QUALITY DATABASE 2 9 2 8 OPENING AND CLOSING EXISTING POWER QUALITY DATABASES 2 10 2 4 MANAGING DATA FROM DATA SOURCES 2 11 2 44 1 Setting the Data Source Format and Path Specification 2 12 2 4 2 Setting Up the Data Source 2 14 2 4 2 1 Setting the Data Source Name 2 15 2 4 2 2 Scheduling Imports 2 15 2 4 2 3 Enabling Automatic Data Source Processing 2 15 2 4 2 4 Specifying Start and End Macros 2 15 2 4 2 5 Set
81. sly loaded data Figure 12 Data Source Setup Dialog Electrotek Concepts Inc 2 14 2 4 2 1 Setting the Data Source Name In the Name field enter the data source name Each data source must have a unique name This name is used to identify the data source and is displayed whenever operations are being performed on the data source The name can be any unique string less than 32 characters in length 2 4 2 2 Scheduling Imports You can schedule imports to run periodically at specific times of the day and or day of the month To specify a time to start an import enter date and time information into the Start poll at box If the date is omitted the current date is assumed Assuming that this data source is enabled and that background processing is enabled an import is started at the date and time specified The Repeat every box allows you to schedule subsequent import operations to be performed at regular intervals Import operations are repeated at the interval specified in the text box and units list box For example if an interval of 1 one and a unit of Days is selected from the list box an import operation would be repeated every day at the time specified in the Start poll at box 2 4 2 3 Enabling Automatic Data Source Processing The automatic import can not occur unless you select Start Processing from the File menu Use the checkbox on the main menu or select Start Background Processing from the File menu to enable
82. t Event Count All Sites Cumulative Frequency Event Count 4 Aouonbaj4 EPRI Electrotek 91010 4 02019 4 0 06 01 S 0106 09 01 96 1 9 01 09 amp s E z 5 2 Voltage Magnitude Figure 31 RMS Variation Magnitude Column Chart Electrotek Concepts Inc 3 12 Display Type Button RMS Variation Event Count Magnitude Duration Column Chart EPRI Electrotek Figure 32 RMS Variation Magnitude Duration Column Chart Command Display Type Button i amp RMS Variation Magnitude Duration Contour Chart A Cumulative Count of Sags and Interruptions 100 23 Voltage Magnitude AE Duration Figure 33 RMS Variation Cumulative Magnitude Duration Contour Chart This graph follows the procedure for making contour charts from IEEE Std 1346 1998 Electrotek Concepts Inc 3 13 Display Type Button sl amp RMS Variation Magnitude Duration Scatter Plot IMag Dur Scatter Plot M RMS Variation Magnitude Duration Scatter Plot Sites Event Count 24 Event Count CBEMA Lower Curve 13 Event Count CBEMA Upper Curve 0 Voltage Magnitude pu EPRI Electrotek Figure 34 CBEMA Magnitude Duration Scatter Plot The total number of events represented on the curve are counted as Total Events Events that fall below the lower CBEM
83. te Property Filter 3 Optional Additional SQL Filter Figure 22 Select Sites Window Note Wildcards may be used to match site property values For example to match all site property values that begin with North then specify North for a Site Property Value This would for example match both North and Northwest The table below shows wildcards that you can use to match site property values Table 13 Wildcard Character Patterns Available with Site Property Filter Wildcard Character Matches Examples Any single character a a matches aaa a3a and aBa m Zero or more characters a a matches aa aBa matches abcdefg and Any single digit 0 9 aita matches ala and 2 3 3 2 Selecting the Date and Time Range To activate the Date and Time Selection window select Date amp Time from the View menu The Select Date and Time window opens Figure 24Figure24 Here you can specify the starting and ending dates of the time range for your reports or analysis Figure 24Fieure 24 You can enter any starting and ending Electrotek Concepts Inc 3 6 dates in the edit boxes at the bottom of the window For convenience in setting up standard reports the window also provides buttons which let you easily select standard time ranges such as last month last week thi
84. ths and years Figure 2 below shows the data flow for the Power Quality Data Analyzer Trends Histograms Correlations Reports lt Ep PQDA Power Quality Data Analyzer Configuration Site and Event Data Power Quality Database Figure 2 Power Quality Data Analyzer Data Flow PQDA provides dialogs that allow you to select part or all of the data in the Power Quality Database for analysis Once you make a data selection you can choose from a number of predefined reports PQView provides reports to view disturbance and steady state data in a number of ways For example different reports are provided to view disturbance data in tabular listings CBEMA plots ITIC plots and histograms Electrotek Concepts Inc 1 3 1 3 PQWeb PQWeb is a web server application for viewing and reporting power quality data stored in a POView database PQWeb opens databases in read only mode but never alters any database Its use is limited to retrieving data for viewing and analysis PQWeb provides the following functionality e Event listing of transients and RMS variations e Waveform plotting and zooming e Summary report of RMS variations with magnitude duration plots e Trend plots and histograms of steady state samples e Monitor availability report e Download files in Power Quality Data Interchange Format PQDIF Users require an Internet browser compliant with JavaScript 1 3 and wit
85. ting Site Selection from the View menu This window is used to select a group of sites to be included in a report or other analysis Figure 22Figure 22 Use this window to select the sites to include in reports Select the site selection mode If you want to select only certain sites then select one or more sites from the site list box You can limit the sites displayed in the site list box by using one or more site property filters A site property is a number string or any binary object that you want associated with the site To add a site property select from the drop down list box of available site property names There will be no useful properties for a new database unless you manually add them from the PQView Power Quality Data Manager Electrotek Concepts Inc 3 5 If you do not select any sites from the site selection box then all sites will be selected Select Sites Use this window to select sites to include in reports Select the site selection mode If you want to select only certain sites then select one or more sites from the site list box You OK can limit the sites displayed in the site list box by using one or more site property filters IF you do not select any sites From the site selection box then all sites will be selected Cancel Site Selection Site Property Filter 1 Only Sites Selected in Site List Box xi Site List Select All Deselect All LCUBSub Site Property Filter 2 Si
86. ting the Import Data Selection 2 16 2 4 2 5 1 For CREG 024 Report Users Creating and Exporting CREG Summaries and Downloading Status Events 2 16 2 4 2 5 2 For CREG 024 Report Users Downloading Status Events from Dranetz BMI Info Nodes 2 16 2 4 3 Importing Data from a Data Source 2 16 2 44 Activating or Deactivating a Data Source 2 17 2 4 5 Resetting a Data Source 2 17 2 4 6 Taking Ownership of a Data Source 2 17 2 47 Deleting a Data Source 2 17 2 5 VIEWING AND EDITING DATA 2 17 2 5 1 Viewing and Editing Site Data 2 17 2 5 2 Viewing and Editing Sites Sub Window Properties 2 18 3 USING THE POWER QUALITY DATA ANALYZER 3 1 3 1 NAVIGATING THE PQDA 3 1 3 1 1 File Menu Commands 3 1 3 1 2 Edit Menu Commands 3 1 3 1 3 View Menu Commands 3 1 3 1 4 Format Menu Commands 3 8 3 1 5 Records Menu Commands 3 3 3 1 6 Window Menu Commands 3 8 3 1 7 Tools Menu Commands 3 8 3 1 8 Menu Shortcuts via the Keyboard 3 4 3 2 OPENING A POWER QUALITY DATABASE IN PQDA 3 4 3 3 SELECTING DATA 3 5 3 8 1 Selecting a Group of Sites 3 5 Electrotek Concepts Inc iii 3 8 2 Selecting the Date and Time Range 3 6 3 4 ANALYZING SELECTED DATA 3 8 3 5 CREATING REPORTS 3 8 3 5 1 1 PQ Event Viewer 3 9 3 5 1 2 RMS Voltage Variations Analysis Panel 3 11 3 5 1 3 Harmonic Statistics 3 17 3 5 1 4 Monitor Availability Reports 3 19 3 5 1 5 Conformance with CREG 024 2005 Report Window 3 21 3 5 1 6 Report Writer 3 21 3 5 1 7 Report Browse
87. tion 5 1 Creating the PQView Database Notice that in SQL Server Management Studio Studio or SQL Server Management Studio Express the fields for the database and log file are in the same view in the New Database dialog box To create a new PQView database complete the following steps 1 Select Start gt Programs gt Microsoft SQL Server 2005 gt SQL Server Management Studio The Connect to Server dialog box displays 2 Connectto the server 3 If your installation uses Windows Authentication as shown in Figure 63Eieure 63 click Connect Microsoft Microsoft ay Windows Server System SQL Server 2005 mr Server name SABINTESTSSGLEXPRESS Authentication Windows Authentication User name JSABINTEST administrator Password Remember password Cancel Heo Figure 63 Windows Authentication 4 fyour installation uses SQL Server Authentication type the system administration user ID in the Login field and the password for this user ID in the Password field Then click Connect 5 Highlight and then right click on the Databases folder A drop down menu displays Electrotek Concepts Inc 5 1 6 Select New Database The New Database dialog box displays as shown in Figure 64Eigure 64 amp New Database 2A Options Filegroups By 10 percent unrestricted growth Server SABINTESTSSQLEXPRESS Connection SABINTEST Administrator View connecti
88. tions describe frequently used reports and tools available from the Reports amp Tools window shown above as follows PQ Event Viewer RMS Voltage Variations Analysis Panel Harmonic Statistics Monitor Availability Reports Conformance with CREG 024 2005 Report Window Report Writer Report Browser Single Site Statistical Calculator available from the Report Browser Electrotek Concepts Inc 3 8 3 5 1 1 PQ Event Viewer To access the PQ Event Viewer start the Power Quality Data Analyzer Double click on the Events icon in the main window or select Events from the View menu The PQ Event Viewer window opens See Figure 26Figure 26 An additional way to access the PQ Event Viewer is to select Report Browser from the View menu to display the Report Browser dialog box Select Viewer as the Report Type and then select Event Viewer as the Report amp PQ Event Viewer i B x BEI 21121 P amp al A total of 510 events were Found Event List Preferences shortcuts Mark amp Plot All Events Mark All Events Unmark All Events Marked Site Name Date and Time Type Minimum Maximum Ci SITE4 5 1 1995 05 59 20 2500 OSC 106 60 109 05 SITE2 5 1 1995 18 38 50 5000 OSC 106 45 102 46 SITE2 5 1 1995 18 38 51 0630 OSC 103 44 109 88 SITE 5 2 1995 01 50 51 3770 RMS 94 96 97 54 SITE4 5 2 1995 07 08 05 4380 05 104 66 106 1096 STEI 5 2 1995 09 39 54 6250 OSC
89. ute TDD C THD RMS C Query TOD Select V THD Option r Select I TDD Option Harmonic Component Voltage Chart Current Chart Figure 41 Harmonic Statistical Summary The form offers a means to select a single site and a date range The form also allows the user to specify the specific harmonics that should be summarized For instance harmonics under the 14 can be summarized by entering 2 3 4 5 6 7 8 9 10 11 12 and 13 in the table of selected harmonics Or you can choose to summarize only odd harmonics by entering 3 5 7 9 11 13 15 17 19 21 23 25 and 27 in the table of selected harmonics The limit on the harmonics that can be analyzed is based upon the sampling rate of the power quality monitor that recorded the data The specific harmonics entered in the table will be saved after the summary form is closed The summary charts can be computed for only a single phase at a time that is Phase A or AB Phase B or BC or Phase C or CA The three statistics computed are the 5 percentile CP05 arithmetic mean average and 95 percentile CP95 If the voltage summary is selected statistics for voltage THD and the individual harmonics selected will be displayed These values are normalized to the fundamental voltage V If the current summary is selected then statistics for current TDD and the individual harmonics selected will be displayed These values need to be normalized by which in IEEE Std
90. w offers all these powerful features through a user friendly interface The complete PQView system consists of these main applications e Power Quality Data Manager PODM e Power Quality Data Analyzer PODA e PQWeb 1 1 Power Quality Data Manager PQDM One of PQDM s primary functions is to characterize data files logged by measuring instruments PODM processes the data from these instruments into characteristics suitable for analysis It then stores the characterized data from these instruments in Power Quality Database files The Power Quality Data Analyzer PQDA then uses the resulting Power Quality Database file PQDB to generate reports and perform other types of data analysis The Power Quality Data Manager PQDM is responsible for performing the following specific tasks for creating loading and editing database files e Automatically builds power quality databases from data sources e Automatically sends e mail notifications using SMTP servers or Microsoft Outlook clients when data sources have finished importing when rms voltage variations are imported from data sources or when measurements are not collected from a monitoring instrument for a specified period e Automatically correlates measurements by time stamp and location e Deletes old measurements Electrotek Concepts Inc 1 1 e Manually adds missed rms voltage e Performs EN50160 compliance calculations automatic derivations and automatic fault location e Up
91. y a new folder in the Location field You can type the name of the folder or browse to it Tip We recommend that you store the data file in a folder on a hard drive of your computer not on a network drive Electrotek Concepts Inc 4 3 Database Properties General Data Files Transaction Log Database files Location Initial size MB Filegroup Delete File properties Automatically grow file File growth Maximum file size C In megabytes E Unrestricted file growth gaby 1 d g By percent 10 m Restrict file growth MB 2 Cancel Help Figure 54 Database Properties Data Files Tab 8 In the Initial Size MB field specify the size of the database by typing a size in this field Tip We recommend using a reasonable initial size for the database such as 10240 MB or 10 gigabytes To anticipate future growth of the database file and gauge an appropriate size talk to the PQView database Deselect this option Maximum file size Unrestricted file growth Restrict file growth MB Figure 55 File Properties Section in Database Properties Data Files Tab Electrotek Concepts Inc 4 4 Note If you are sure that the database will never exceed 2 gigabytes in size then it is ok to select the Automatically grow file option since problems seem to occur after the database grows larger than 2 gigabytes For more information

PQView User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents