Tutorial: Excel Add-In as a User Interface for Deployment

​

Introduction​

The following tutorial explains how to use the Excel Add-In as a user interface. It shows how to establish a workflow between pro users who prepare and share a simulation and deployment users who do not touch the simulation environment of Modelon Impact at all, but instead only use the Excel interface to run simulations and evaluate results.

Preparations for the Tutorial

Before you begin, make sure you have the Modelon Impact Add-In for Excel installed.

If you are not familiar yet with the Excel Add-In, please refer to the following article Excel Add-In getting started.

The Pro user sets up a workspace which contains a simulation model that is to be investigated and shares the workspace with the deployment users. Support how to do this is provided in the following articles: How to configure a workspace, How to share a workspace. Make sure the results of the baseline simulation are included. Download the Excel template and prepare it with the required modifiers and outputs such that the deployment users can investigate and modify the simulation as needed (more details on settings). Share the prepared Excel template with your colleagues but make sure the analysis settings are empty!

Instruction

The following steps will guide you how to use the Excel Add-In as a user interface for deployment users.

Step 1

Open the preconfigured template you received from the pro user and launch the Modelon Excel Add-In. Check if the analysis settings are empty.

Step 2​

Click the link to the shared workspace you got from the pro user and take the workspace ID and model name from the link in your browser.

Enter workspace ID and model name in the Excel template.

Step 3

Choose your baseline result and click get baseline

Step 4

Enter your values for the modifiers and eventually add more outputs for investigation if needed. Set your simulation time and start your case

Step 5

After the simulation is done, review the output carefully.