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 Contents
The primary input data format for ePHASORSIM is an Excel Template workbook in .xlsx format.
An empty and preformatted Excel Template file is provided with each installation of product located at the following path:
%RTLAB_ROOT%\Simulink\ephasorsim\Template.xlsx
This file is also accessible via:
ePHASORSIM Blockset page in MATLAB’s Help section.
Mask of ePHASORSIM Solver through the link below Complete network field in the Network data.
This Excel Template includes preformatted worksheets for the supported components and their required data entry with guidelines in form of field comments. The components are described under the Native Library chapter.
However, ePHASORSIM also supports other vendor specific file formats, which are discussed in Third Party Data Formats.
Template Worksheets
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.
The basic information of the power system and current version of template | |
To define incoming ports and outgoing ports of the model | |
To define all buses | |
To externally inject current into a bus | |
To define positive sequence and three-phase voltage source | |
To define various synchronous machines and induction machine models | |
To define various native and FMU excitation system models | |
To define various native and FMU power system stabilizer models | |
To define various native and FMU turbine-governor models | |
Constant impedance, constant current, and constant power positive sequence loads and multiphase ZIP model loads. | |
PI-section positive sequence and multiphase line models | |
Two and three winding positive sequence transformers and two-winding multiphase transformers. | |
To model breakers and disconnectors | |
Positive sequence and multiphase Shunt models. | |
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=0in 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 Excel Template Versions for details about how to migrate from older versions of Excel template.
General Worksheet
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 Worksheet
In ePHASORSIM, Pins are the bridges to connect the Solver block with 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. |
A pin is the combination of a unique internal component ID and a pin name.
ePHASORSIM automatically creates a unique internal ID for each component of the system during the generation of the
*_solver.opalfile.The incoming and outgoing pins for each component must be specified referring to the internal ID declared in the
*_solver.opalfile.
Refer to the component pages in Native Library chapter to explore the available I/O pins names.
Below is an example of a Pins worksheet:
OPAL-RT TECHNOLOGIES, Inc. | 1751, rue Richardson, bureau 1060 | Montréal, Québec Canada H3K 1G6 | opal-rt.com | +1 514-935-2323
Follow OPAL-RT: LinkedIn | Facebook | YouTube | X/Twitter