Automated Deployment of Modelica Models in Excel via Functional Mockup Interface and Integration with modeFRONTIER

John Batteh
Modelon Inc., USA

Jesse Gohl
Modelon Inc., USA

Anand Pitchaikani
Modelon Inc., USA

Alexander Duggan
ESTECO North America Inc., USA

Nader Fateh
ESTECO North America Inc., USA

Ladda ner artikelhttp://dx.doi.org/10.3384/ecp15118171

Ingår i: Proceedings of the 11th International Modelica Conference, Versailles, France, September 21-23, 2015

Linköping Electronic Conference Proceedings 118:18, s. 171-180

Visa mer +

Publicerad: 2015-09-18

ISBN: 978-91-7685-955-1

ISSN: 1650-3686 (tryckt), 1650-3740 (online)


This paper describes a method for automated deployment of Modelica models as simulators in Microsoft Excel using Functional Mockup Interface (FMI) and FMI Add-in for Excel. Using existing interfaces, integration with modeFRONTIER is demonstrated and illustrated with several different example models in different physical domains to highlight the range of applications and types of analyses that can be covered with the automated toolchain. This toolchain can be applied to any FMU that includes the annotations described to support the automation.


Modelica; Functional Mockup Interface; automation; simulator; deployment; optimization; robust design


John Batteh, Jesse Gohl, and Chandrasekar Sureshkumar. Integrated Vehicle Thermal Management in Modelica: Overview and Applications, Proceedings of the 10th International Modelica Conference, Lund, Sweden, pp. 409-418, March 2014. doi: 10.3384/ecp14096409.

Dassault Systemes. Dymola 2015 FD01, 2015. DLR, PowerTrain Library, v.2.3.0, 2015.

ESTECO SpA. modeFRONTIER 2014 Update 1, 2015. http://www.esteco.com/

Richard Hale, Sacit Cetiner, David Fugate, Lou Qualls, John Batteh, and Michael Tiller. Dynamic Modeling of Small Modular Nuclear Reactors using MoDSim, Proceedings of the 10th International Modelica Conference, Lund, Sweden, pp. 989-998, March 2014. doi: 10.3384/ecp14096989.

Modelon AB, FMI Add-in for Excel, v1.3.5, 2015. http://www.modelon.com/products/fmi-add-in-for-excel/.

Modelon AB, Heat Exchanger Library, v1.2, 2015. http://www.modelon.com/products/modelicalibraries/heat-exchanger-library/.

T. Montrone, A. Turco, R. Enrico. FAST Optimizers: General Description. ESTECO Technical Report 2014-001, Trieste, Italy, 2014.

S. Poles. The SIMPLEX Method. ESTECO Technical Report 2003-005, Trieste, Italy, 2003.

S. Poles. MOGA-II an Improved Multi-Objective Genetic Algorithm. ESTECO Technical Report 2003-006, Trieste, Italy, 2003.

Karline Soetaert and Thomas Petzoldt. Inverse Modelling, Sensitivity and Monte Carlo Analysis in R using Package FME. Journal of Statistical Software, 33(3), pp. 1-28, February 2010.

D. Stefano. Multivariate Analysis algorithms in modeFRONTIER v4. ESTECO Techinical Report 2009-001, Trieste, Italy, 2009.

A. Turco. Hybrid – description. ESTECO Technical Report 2011-003, Trieste, Italy, 2011. Xogeny, XenGen package, 2015. https://github.com/xogeny/XenGen

Citeringar i Crossref