How do I Import SCADA Data into EasyPower for Power Flow Analysis?

The PowerFlow module in EasyPower has the ability to solve the load flow equations for the system using either the manufacturer’s data or SCADA (Supervisory Control and Data Acquisition) data. This information is included in the Power Flow tab of the data dialog box for motors, generators, loads, utilities, MCCs, and panels.

There are four types of loads. Click Help in the data dialog box for a description of the load types and for more information about the options on this tab.

Figure 1: Power Flow Tab

Most SCADA systems provide equipment parameters in a file format that can be modified with Excel. EasyPower requires the data to be provided in a specific format before it can be imported. The procedure below describes the easiest way to do this.

  1. Start with the one-line diagram displayed in Database Edit focus. Click on a blank area of the one-line to ensure no equipment is selected.
  2. Click File > Export Database.
  3. Figure 2: Export Database

  4. Select a location to store the .CSV file. Be sure to change the Save as type to SCADA data files (*.csv).
  5. Figure 3: Save as SCADA Data File Type

  6. Open this file with Excel. The exported file lists both manufacturer’s data and the current SCADA contents from the Power Flow tab. Figure 4 shows the Motors section of the file generated for the DSExample-2.dez file (available in the Sample folder of the EasyPower installed files).

    Figure 4: Sample File Contents

  7. Use Excel's custom sort capabilities to separate the SPEC data from the SCADA data for the list of motors. (See Figure 5.)
  8. Figure 5: Sorting the Data

  9. Use the SCADA system to generate a list of system elements and parameters as needed. Reformat the SCADA list to make it easy to copy and paste data from the SCADA listing into the file you created in step 5. After completing the copy and paste operation, the EasyPower spreadsheet should resemble Figure 6.
  10. Use Excel's custom sort option to return the listing order (in this case Motors) back to match the original configuration generated by the EasyPower .CSV export. See figure 7. Save the modified file.
  11. Figure 6: SCADA Data Copied

    Figure 7: SCADA Data Re-sorted

  12. In EasyPower, from the Database Edit focus, select File > Import SCADA to import the newly created file back into your one-line.
  13. Open the Power Flow tab for any of the items where SCADA data was imported. The SCADA model is now selected and the SCATA fields are populated with the required data. You can now use Power Flow analysis to solve the model using the new SCADA data values.

Feedback and Knowledge Base