Page Contents

1 Migrate to v2.0
2 v1.8 to v2.0
- 2.1 Pins Changes
- 2.2 Major Changes
3 v1.7 to v1.8

Migrate to v2.0

EPXlsUpgrader is a utility software to facilitate ePHASORSIM's Excel file migration from v1.8 to v2.0. This software automates the converting steps described below.

It can be found under %RTLAB_ROOT%/mingw/bin
Excel files need to be in .xlsx format. It is easy to convert a .xls to .xlsx using the Microsoft Excel 'Save As' function.
This tool will not alter the original file. Instead, it will create a new file in the 2.0 format using the input file's data.
The resulting file is a v2.0 .xlsx ready to be used in ePHASORSIM solver.
Converting may take a few seconds or minutes depending on the file size.
This tool is meant to be used in Windows in command line prompt or Windows PowerShell:

Some v1.8 files can contain empty cells which used to be valid. Please note that empty cells are not valid in v2.0 anymore. The software will warn the user if empty cells were found while upgrading a v1.8 file to v2.0. Empty cells will be highlighted in yellow in the output file and the user will need to manually enter values for them.

Empty cells example

Empty cell warning

To migrate Excel files older than v1.8, please contact the Support team.

v1.8 to v2.0

Pins Changes

Instructions in Pins page of the Excel file are updated for Machine, Exciter, Power System Stabilizer and Turbine-Governor.

Please consult Available I/O Pins tables for those pages and validate the correct paths.
For example,
- the old pin path gen_30_1/delta must be modified to gen_30_1/pins/delta,
- or ex_30_1/varVref must be changed to ex_30_1/pins/dVref.
- These changes are independent of Excel Template version.

Major Changes

Below is the list of major changes introduced in the Excel template v2.0:

Support for native models is extended when using Excel data import for generator, exciter, stabilizer, and turbine governor. For list of supported components and more details please explore Native Library. 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.
Deprecated Models:
1. SM_T1 and XF_2W
2. when migrating from v1.8, they can be replaced by their counterparts SynGenGENROU and Positive Sequence 2W Transformer, respectively

Note that various component pages are merged to a single Excel page. When migrating data from v1.8, use the following table to navigate pages in the new template.

Page names in v1.8	Page name in v2.0
Synchronous Machine, Induction Machine	Machine
Vsource, Vsource 3-phase	Voltage Source
Load, Multiphase Load	Load
Line, Multiphase Line	Line
2W-Transformer, 3W-Transformer, Multiphase Transformer	Transformer
Multiphase Shunt	Shunt

The Type parameter is removed from all pages except Multiphase Fault. Instead, for each type of component, a preformatted data block is created in pages of Excel template. A data block of any component type is a collection of cells predetermined to enter its required data. For example, in Machine page of new template, there is a defined section to enter data for machine type SyncGenGENCLS. Thus, when migrating data from v1.8, skip the Type parameter column of the component (which is SM_T2 in this example) and copy the rest of data to the corresponding data block in v2.0.

The following table shows the mapping between type names in v1.8 and the corresponding names in v2.0. When migrating from v1.8, use the following table to copy data to the correct data block.

Type Name in v1.8	New Name in v2.0
SM_T2	SynGenGENCLS
SM_T3	SynGenGENROU
SM_T4	SynGenGENROE
IM_T1	AsyncGenSingleCage and AsyncGenDoubleCage
EX_T2	ExciterEXST1
PSS_T2	StabilizerSTAB1
TG_T2	TurbineGovernorTGOV1
LN_PI	PositiveSeqLine
XF_OLTC	PositiveSeq2wXF
LD_CZ	PositiveSeqZload
LD_CI	PositiveSeqIload
LD_CP	PositiveSeqPload

The parameter columns in the component pages of the Excel template are now uniformly rearranged in v2.0. The following table shows an overview of the overall change; however, these changes are discussed in further details below.

Pages in v2.0	Columns Order Overview
Machine	Bus	ID	Status	Rest of parameters (refer to 5.a)
Voltage Source	ID	Bus	Rest of parameters (refer to 5.b)
Exciter, PSS and Turbine, and Governor	ID	Machine ID	Rest of parameters (refer to 5.c)
Load, Line, Transformer, and Shunt	ID	Status	Rest of parameters (refer to 5.d, 5.e, 5.f and 5.g, respectively)

Synchronous and Induction Machine
In addition to removal of Type column, the location of parameter Ra (pu) is also changed from column R in v1.8 to column K in v2.0 for both Synchronous Machine and Induction Machine, as shown in figure below.

Vsource 3-phase
In addition to re-ordering ID and Bus columns, each type of voltage source is separated into different data blocks with their respective parameters as shown in the figure below. The parameter names are also modified, which is summarized in the table below.

Parameter Name in v1.8	Parameter Name in v2.0
V (KV)	kV (ph-ph RMS)
Angle (deg)	Angle_a (deg)
Bus A, Bus B and Bus C	Bus1, Bus2 and Bus3, respectively
R_pos, X_pos, R_zero and X_zero	R1, X1, R0 and X0, respectively

EX_T2, PSS_T2 and TG_T2
In addition to renaming of v1.8 component types EX_T2, PSS_T2 and TG_T2 to ExciterEXST1, StabilibzerSTAB1 and TurbineGovernorTGOV1, respectively, their parameter names and column order are also modified as shown below.

Component Name in v1.8

Parameters modified in v2.0

EX_T2

VR_max, VR_min, VI_max and VI_min are renamed to VRMAX, VRMIN, VIMAX and VIMIN, respectively.

PSS_T2

Kstab, TW and Vs_max are renamed to K, T and HLIM, respectively.

K/T represents ratio of K and T.
Similarly, T1/T3 is the ratio of T1 and T3, and T2/T4 is the ratio of T2 and T4.
HLIM = Vs_max = -Vs_min

TG_T2

V_max and V_min are renamed to VMAX and VMIN.

Multiphase Load
In addition to removing Type and re-arranging ID and Status columns, load is divided into different data blocks for each phase with their respective parameters as shown in figure below.
Multiphase Line
In addition to re-arranging ID and Status columns, the parameter Mode is removed and line is divided into different data blocks for each phase with their respective parameters as shown in figure below.
Multiphase Transformer
In addition to re-arranging Status column, the parameter Mutual Impedance is removed and each transformer type is separated into different data blocks with their respective parameters as shown in figure below.
Shunt
In addition to re-arranging Status column, Multiphase Shunt is divided into different data blocks for each phase with their respective parameters, where V (KV) is renamed to kV (ph-ph RMS), as shown in figure below.

The Unit (V, pu) parameter is added as column 4 in Bus page. This parameter is only used for importing data via UDB. Thus, when migrating data from v1.8, add correct unit if UDB import is required.

v1.7 to v1.8

To migrate data from v1.7 to v1.8, use the Excel template v1.8 included in the software
Below is the list of major changes introduced in the Excel template v1.8:

Status column is added for components listed in the following table. In v1.7, the default value for Status is 1; therefore, the value in the new column should be 1 to keep it compatible with the previous version.
Page Status added on
Load Column F
Line Column H
2W-Transformer Column L
3W-Transformer Column T
Multiphase Line Column AH
Multiphase Transformer Column AE
In page Exciter, two empty columns L and M (Efd_max and Efd_min) must be deleted.