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.

Excel Input File

Page Content

Prepare the Excel File with the Network Information

  • A template Excel network file is available in the ePHASORSIM Blockset page in the MATLAB user help.

  • Save the Excel file in an empty folder in an intuitive location, like your active default project folder or 'C:\OPAL-RT\ePHASORSIM'. You will use this folder and path throughout this procedure; this is why we recommend an intuitive and/or default location.

Prepare the Simulink Model

  • Change the MATLAB working directory to the previously created folder.

  • Open the Simulink Library.

  • Select RT-LAB/ePHASORSIM.

  • Drag the Solver block into a new Simulink model.

  • Provide a unique Name to the Solver block if there are more than one.

  • Save this model in the previously created folder.

  • Open the mask and follow the following steps.

  • Select Excel as the Input file format.

  • Insert the name of your Excel file in the Complete network field or use Select to pick the file. 

  • Note: The Excel file must also be in the working directory.

image-20241017-230353.png
Excel input

Library Tab

  • To use FMUs, enter the corresponding folder name in the FMU component field, between single quotes, or use Path button to select the folder that contains the required FMUs.

  • The default is the empty string '', or two single quotes.

  • Make sure the compiled FMUs are placed in the folder name specified in the mask (more details about FMUs in Modelica Based Library)

Simulation Settings Tab

  • Specify a Time-step (The default value is 10 ms).

Power-flow calculation

  • Select the Initialization method from the drop-down menu.

  • Enter the Power mismatch (max p.u.) tolerance for the power-flow calculation (The default value is 1e-8).

  • Enter the Max number of NR iterations (The default value is 100).

  • Clicking Execute or Execute and export report runs the power-flow. Only the latter writes the power-flow results in CSV format.

Dynamic simulations

  • Check Start from Power-flow to run power flow before dynamic simulation.

  • Enter the Number of partitions to be used for the network solution (The default value is 1).

  • Clicking Export admittance matrix writes the admittance matrix in CSV format.

  • Check Optimize number of threads (Windows only).

  • Click OK. The ePHASORSIM Solver block is redrawn using the pins from the given Excel file.

    • The network data may also be converted to OPAL format, depending on the configuration of the Refresh netlist option in the Network data tab.

  • Connect Simulink sources and sinks (scopes, displays) to the input/output pins on the ePHASORSIM Solver block.

  • Ensure the simulation is set to use a fixed time-step (under Simulation/Model Configuration parameters/Solver), and that the time-step is consistent with the one specified in the Simulation settings tab.

  • Once the Solver block mask and Simulink model are configured, run the model to verify a reasonable value appears on the scopes.

  • Save your model.

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