Skip to content
qnikil7 edited this page Sep 9, 2021 · 2 revisions

ExcelFMI is an add-in in excel that would simulate FMU's in Excel.

Currently the plan is to use Excel as a front-end which would interact with a python function using FMPy to interface with the FMU's. If this is operational, python could be replaced with another language to directly interact with the FMU.

Step 1: (Functional)

  1. Create a basic ribbon containing the following.
  • Browse to select FMU.
  • Once FMU is selected, dump the information into the excel sheet.
  • Edit information directly or create another button to setup.
  • Select Input Values, dialog box would be better.
  • Select Output Values, dialog box would be better.
  • Simulate button to run the simulate function.
  • For multiple cases, input values to be entered in a separate row and output values would be populated there.
  • Add another output as message to display error.
  1. Create python functions for the following.
  • Selecting FMU inputs
  • Selecting FMU outputs
  • Simulating FMU
  1. Distribution of the software.
  • Excel add-in needs to be added to excel
  • python function needs to be added to path so A python package which contains the script to get inputs, outputs and simulate
  • code packaged as an executable to do this, install a python package and a add the excel add-in to some default path to browse.
  • create a pipeline to build.

Step 2: (Speed)

  • Develop without using python
Clone this wiki locally