The FMI Add-in for Excel (FMIE) is a commercial product from Modelon AB that enables the deployment of FMUs in Microsoft Excel. FMIE enables the user to programmatically control the add-in through Visual Basic code in Excel. This allows the implementation of custom workflows and interfaces for the user to interact and automate the tasks involved in loading; simulation and analysis of FMUs.
In this paper we present a workflow in FMIE for an automobile thermal management model FMU. The workflow utilizes Visual Basic scripts for automation and user-forms for user interaction.
Keywords: FMU;Automated workflow;FMI Add-In for Excel; Visualization; Design of Experiments; Batch Simulations; Monte-Carlo Analysis
Proceedings of the 10th International Modelica Conference; March 10-12; 2014; Lund; Sweden
[1] Modelisar ITEA2, “Functional Mock-up Interface for Model Exchange”, Accessed from www.fmi-standard.org in Nov 2013.
[2] Modelisar ITEA2, “Functional Mock-up Interface for Co-Simulation”, Accessed from www.fmi-standard.org in Nov 2013.
[3] Modelon AB, “FMI Add-In for Excel”, Accessed from http://www.modelon.com/products/fmi-addin-for-excel/ in Nov 2013.
[4] Batteh J., Gohl, J., S Chandrasekar, “Integrated Vehicle Thermal Management in Modelica: Overview and Applications” Proceedings of the 10th International Modelica Conference, Lund, 2014.