Documentation Home Page ePHASORSIM Home Page
Pour la documentation en FRANÇAIS, utilisez l'outil de traduction de votre navigateur Chrome, Edge ou Safari. Voir un exemple.

Introduction to Excel Template

Page Content

The primary input data format for ePHASORSIM is an Excel workbook that can be in XLS or XLSX formats. An empty and preformatted Excel template file is provided with each installation of product located at the following path:

C:\OPAL-RT\RT-LAB\<installed version>\Simulink\ephasorsim\Template.xls

This file is also accessible via:

  1.  ePHASORSIM Blockset page in MATLAB’s Help section.

  2. Mask of ePHASORSIM Solver through the link below Complete network field in the Network data

This Excel template includes individual and preformatted worksheets for all supported components and their required data entry with guidelines in form of field comments. In Native Library chapter, all the components are presented based on this Excel template format; however, ePHASORSIM also supports other vendor specific file formats, which are discussed in Third Party Data Formats.

The version of the Excel template file included in this package is v2.0. This new template has the following new features:

  • The component worksheets in earlier versions for positive sequence and multiphase systems, which share the same type, are now merged into a single worksheet. For example, Load and Multiphase Load worksheets in earlier version, which corresponds to positive sequence and multiphase systems respectively, are now merged to a single worksheet named Load

  • Several types of machine, exciter, turbine and governor, power system stabilizer (PSS) in Native Library can be imported via this version of Excel file. Previously, many of these models were only accessible using PSS/e input files.

  • FMU of a single component exciter, turbine-governor, and PSS controller types can be added and instantiated via the corresponding component worksheets. Thus, there is no need to create a separate worksheet for each new single component FMU. The sperate sheet in Excel file is still required in case of GenUnit FMU.

Each worksheet of the Excel template has a specific name that must not be modified or changed. Empty worksheets which do not define any components may be omitted.

General

The basic information of the power system and current version of template

Pins

To define incoming ports and outgoing ports of the model

Bus

To define all buses

Current Injector

To externally inject current into a bus

Voltage Source

To define positive sequence and three-phase voltage source

Machine

To define various synchronous machines and induction machine models

Exciter

To define various native and FMU excitation system models

PSS

To define various native and FMU power system stabilizer models

Turbine and Governor

To define various native and FMU turbine-governor models

Load

Constant impedance, constant current, and constant power positive sequence loads and multiphase ZIP model loads.

Line

PI-section positive sequence and multiphase line models

Transformer

Two and three winding positive sequence transformers and two-winding multiphase transformers.

Switch

To model breakers and disconnectors

Shunt

Positive sequence and multiphase Shunt models.

Multiphase Fault

Fault model for phase-to-ground fault (single-phase, double-phase, three-phase) and phase-to-phase fault (double-phase, three-phase).

Notes:

  • Incorrect names of Excel worksheets create invalid simulation results.

  • Parameters not used by a component type but existing in the worksheet must be left empty, e.g. for single-phase-to-ground fault in Multiphase Fault worksheet, Bus2 and Bus3 column must be left empty.

  • A data row can be commented in the Excel file by adding ‘//’ to the leftmost cell of that row.

  • In Excel template v2.0, for worksheets where model type is listed, the default order of blocks and columns after row 11 must not change. Also, one empty row between End of each block and the next block is mandatory; otherwise, empty rows are NOT allowed.

  • If there exist several components with Status=0 in the Excel file whose Status is not going to change during simulation, it is recommended to remove them from the file. Otherwise, in large-scale system they will have impact on run-time performance and memory usage.

  • Please Refer to Migration Notes for details about how to migrate from older versions of Excel template.

General 

The basic information of the power system is entered on this Excel worksheet.

General parameters

Symbol

Description

Unit

Excel file version

Defines the version of the template

v2.0

Name

Name of the Excel file



Frequency (Hz)

Frequency of the network

Hz

Power Base (MVA)

Based power of the network

MVA

Pins

In ePHASORSIM, Pins are the links to interact with the Solver block in the Simulink model. There are two types of pins:

Outgoing

To define measurement probes or monitor a status in the power system (e.g. voltage of a bus, or in-service status of a shunt device)

Incoming

To send operational commands to the simulator (e.g. apply faults). These pins must not be left disconnected; otherwise, the Solver block may behave unexpectedly.

Refer to each component page in Native Library chapter to explore the available I/O pins.

Example

Pins for Positive Sequence Components

 

OPAL-RT TECHNOLOGIES, Inc. | 1751, rue Richardson, bureau 1060 | Montréal, Québec Canada H3K 1G6 | opal-rt.com | +1 514-935-2323