Simulation Master Product Update History

This page lists the product update history for Simulation Master.  You can determine if your product is the latest version by checking the build number in the About form.  Mark numbers are major product updates.

Simulation Master Standard Edition

Mark 1

Release date: 3/6/2017

Build number: 17.03.06

Changes

  • Initial release.

Mark 2

Release date: 4/2/2017

Build number: 17.04.01

Changes

  • Added distribution truncation.
  • Added logistic, extreme value maximum, and extreme value minimum distributions.
  • Added RVUSERDIST user defined distribution function.

Mark 3

Release date: 9/6/2018

Build number: 18.09.01

Changes

  • Added update links tool.
  • Added Help form to ribbon.
  • Added plot options to scatter plots.
  • Added empirical distribution.
  • User interface improvements.
  • Input validation improvements.

Mark 4

Release date: 1/4/2019

Build number: 19.01.01

Changes

  • Added time series.
  • Added copulas.
  • Added Spearman rank correlation calculator.
  • Added "RVC" copula marginal functions.
  • Added RANDNUM function to generate random numbers in cells.
  • Added HIDERV function to prevent random variables from being recorded on simulation data sheet.
  • Protected workbook handling.
  • Correlation report can be created in new workbook.
  • Summary report can be created in new workbook.

Mark 4.1

Release date: 3/5/2019

Build number: 19.03.01

Changes

  • RVC functions: Added error checking for random number range.
  • Various bug fixes.

Mark 4.2

Release date: 6/11/2019

Build number: 19.06.03

Changes

  • Added VaR | expected shortfall tool.
  • Added VALUEATRISK worksheet function.
  • Added EXPSHORTFALL worksheet function.
  • Added integration tool.
  • Added probability grab bars to histogram.
  • Performance improvements when generating simulation output, calculating probabilities, and summary report.
  • Minor bug fixes.

Mark 4.3

Release date: 9/25/2019

Build number: 19.08.04

Changes

  • Added box plot tool.
  • Added option to automatically determine number of bins for histograms using Scott's rule.
  • Improved correlation report speed.
  • Added progress bar to function swap.
  • Improved error checking of worksheet random variable functions.

Mark 4.4

Release date: 1/13/2020

Build number: 20.01.03

Changes

  • Improvement to Update Links tool error handling for protected sheets and compatibility with DTace decision tree sheets.
  • Improvement to Function Swap tool error handling for protected sheets and compatibility with DTace decision tree sheets.
  • Fixed issue with summary report where simulation statistics could be covered by last chart on some systems.
  • Fixed issue where Excel's automatic calculation setting was changed to manual after some simulations.

Simulation Master Premium Edition

Mark 1

Release date: 11/24/2017

Build number: 17.11.11

Changes

  • Initial release.

Mark 2

Release date: 9/6/2018

Build number: 18.09.05

Changes

  • Added update links tool.
  • Added goodness of fit statistics.
  • Added p-value simulation for distribution fitting.
  • Added fit report.
  • Added user specified bin count for distribution fitting.
  • Added fill all bins functionality for distribution fitting.
  • Added empirical distribution.
  • Added option for live charts or charts as images for distribution fit report.
  • User interface improvements.
  • Input validation improvements.

Mark 3

Release date: 12/23/2018

Build number: 18.12.03

Changes

  • Added time series.
  • Added time series fitting.
  • Add time series tool.
  • Added time series analysis: time series plot, ACF and PACF correlograms.
  • Added copulas.
  • Added copula fitting.
  • Add copula tool.
  • Added Spearman rank correlation calculator.
  • Added "RVC" copula marginal functions.
  • Added RANDNUM function to generate random numbers in cells.
  • Added HIDERV function to prevent random variables from being recorded on simulation data sheet.
  • Added parametric bootstrapping of distribution parameter estimates.
  • Added optimization results to summary report.
  • Protected workbook handling.
  • Correlation report can be created in new workbook.
  • Summary report can be created in new workbook.

Mark 3.1

Release date: 3/5/2019

Build number: 19.03.01

Changes

  • Added user-entered percentile for optimization objective.
  • Added user-entered percentile for optimization constraint.
  • Distribution and time series fitting: Optimized code for faster generation of fit reports.
  • RVC functions: Added error checking for random number range.
  • Various bug fixes.

Mark 3.2

Release date: 6/11/2019

Build number: 19.06.02

Changes

  • Added VaR | expected shortfall tool.
  • Added VALUEATRISK worksheet function.
  • Added EXPSHORTFALL worksheet function.
  • Added integration tool.
  • Added probability grab bars to histogram.
  • Performance improvements when generating simulation output, calculating probabilities, and summary report.
  • Minor bug fixes.

Mark 3.3

Release date: 9/25/2019

Build number: 19.09.07

Changes

  • Added box plot tool.
  • Added option to automatically determine number of bins for histograms using Scott's rule.
  • Improved correlation report speed.
  • Added progress bar to function swap.
  • Improved error checking of worksheet random variable functions.
  • Made RVDECISION function volatile.
  • Analyze existing simulation: Drop-down box now shows sheet names of data sheets instead of name | sim #.

Mark 3.4

Release date: 1/13/2020

Build number: 20.01.04

Changes

  • Improvement to Update Links tool error handling for protected sheets and compatibility with DTace decision tree sheets.
  • Improvement to Function Swap tool error handling for protected sheets and compatibility with DTace decision tree sheets.
  • Fixed issue with summary report where simulation statistics could be covered by last chart on some systems.
  • Fixed issue where Excel's automatic calculation setting was changed to manual after some simulations.