-
Notifications
You must be signed in to change notification settings - Fork 0
Home
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)
- 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.
- Create python functions for the following.
- Selecting FMU inputs
- Selecting FMU outputs
- Simulating FMU
- 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