The Excel file, exclusively XLSX type, includes two tabs:
- General: to set Frequency (Hz) and Power Base (MVA) for the imported power grid
- Pins: to define incoming and outgoing pins described in the Pins section. Note that for PowerFactory, only positive sequence components I/O pins are supported listed in the Native Library section. ePHASORSIM automatically creates a unique internal ID for each component of the system during the generation of the '*_solver.opal' file. The incoming and outgoing pins for each component must be specified referring to the internal ID declared in the '*_solver.opal' file.
The convention for these internal IDs is based on prefixes followed by loc_name and ID given in the DGS file (*.XML). Note that the loc_name is converted into lowercase and any space characters are ignored. The following table lists these conventions:
The Format of the Identifiers in PowerFactory and Excel File
DGS Format and Example | OPAL Format Convention | Notes |
Bus | bus_[loc_name]_[ID] | |
Load | load_[loc_name]_[ID]_Z, load_[loc_name]_[ID]_I , or load_[loc_name]_[ID]_P | Z, I, P reflect constant impedance, current, and power |
Switch Switch with loc_name Switch A and item ID 220 in StaSwitch section | sw_[loc_name]_[ID] | |
Generator | gen_[loc_name]_[ID] | |
Static Generator | genstat_[loc_name]_[ID]_p | |
Line | line_[loc_name]_[ID] | |
2-Winding Transformer | xf2w_[loc_name]_[ID] | |
3-Winding Transformer | xf3w_[loc_name]_[ID] e.g.: xf3w_tr3_13 | |
Excitation System | exc_[machine loc_name]_[machine ID] | |
Power System Stabilizer | pss_[machine loc_name]_[machine ID] | |
Turbine-Governor | tg_[machine loc_name]_[machine ID] |