FMI Add-In for Excel - Release Information
Released 20 February 2018
- Support for loading and simulating 2.0 FMUs.
- It is now possible to simulate FMUs containing 64-bit Windows binaries. Both 32- and 64-bit FMUs can be simulated in both the 32- and 64-bit FMI Add-In for Excel distributions. If an FMU contains both 32- and 64- bit binaries the 32-bit binary will be used for simulation.
- New Ribbon design with improved usability and added features.
- Added new Add case and Remove case buttons.
- Number of processes are now in the Ribbon rather than the Simulation sheet.
- It is now possible to specify the number of cases that will initially be in a created Simulation sheet.
- New sheet styles and layouts with improved presentation of data and usability. Upgrading from Sheets generated by earlier version is not supported.
- Color coding now clearly mark which cells the user is encouraged to interact with.
- Headers and better layout clearly separates different areas.
- And much more.
- It is now possible to create plots for an Simulation sheet using the new Create plot button in the Ribbon.
- No need to save Simulation sheet before simulation or initialization. If saved, the old behavior with using the workbooks directory as current directory for simulation and initialization is used. If unsaved, a temporary directory is used.
- Changed default values for the experiment column in the FMU sheet for 1.0 FMUs:
- constants cannot be indata by default.
- discrete locals are at least outdata by default.
- inputs are not outdata by default.
- Script functions have input that is no longer used:
- inputTypes in FMIInitialize0 and FMISimulate0 is unused.
- Fixed bug where running an experiment with an FMU on a path with extended ASCII characters failed. For example, the path "C:/User/René/myFMU.fmu" will now work if used in the Simulation sheet.
- Pop-ups are no longer produced by FMI Add-In when the Excel flag Application.DisplayAlerts is set to false.
- Fixed FMI Add-In for Excel to not require MSVCR100D.dll
- Added FMI Add-In for Excel installer for 64-bit Excel.
- Removed data validation with drop-down menu for boolean values.
- Fixed bug with missing FMIAddInScript.xlsm.
- Simulation or initialization is now performed with current directory set to the workbook directory. This should
simplify the look up of external data in the FMU, that relays on current directory. The workbook must now
always be saved before any simulation or initialization is run.
- Temporarily tries to unprotect a protected experiment sheet before a simulation or initialization is run, and before
the workbook is saved.
- Updated installer to not require running in elevated mode unless any of the prerequisites is missing and requires elevated mode to be installed.
- Fixed bug with locale dependent expiry date.
- Fixed bugs in the updating script and in loading invalid FMUs.
- Simulation results now includes the result point at initial time.
- Introduced new license feature: runtime (FMI_ADDIN_EXCEL_RUNTIME). With this license feature, users can perform simulations, parameter sweeps, etc and use a restricted set of the API macro functions. For more information, see Section 5.2 in Chapter 2.
- Introduced possibility to set an experiment expiry date.
- Changed license checkout procedure. The license will now be checked out when the user starts working with FMI Add-In for Excel, rather than at startup of Excel.
- Fixed problem with loading FMUs containing external DLL files.
- Support for calling the add-in functions from Visual Basic script in Excel.
- Simulation timeout time can now be specified for each case in the Experiment sheet.
- Fixed problem with parsing input trajectory values.
- Fixed problem with long simulations causing Excel to display the dialog message: Excel is waiting for another application to complete an OLE action.
- Changed simulation timeout time from 100s to infinity
- Parallel simulation and initialization support
- Excel sheets based on named ranges
- The FMU path in the Experiment sheet can be an absolute path or relative path
- New example added, a heat exchanger for steady-state computation that uses the initialization functionality to perform a parameter sweep
- FMI Add-In is built with FMI Library 2.0a2 containing bug fixes
- Simulation of Co-Simulation 1.0 FMUs supported
- Initialization of Model Exchange 1.0 FMUs supported
- Input trajectories supported
- Final simulation and initialization results are written to an experiment sheet
- Simulation of Co-Simulation FMUs generates a result sheet with output trajectories