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.
Mark 4.5
Release date: 6/19/2020
Build number: 20.06.02
Changes
- Added Matrix Check tool. The tool checks correlation matrix for formatting and to see if it is positive definite or positive semi-definite. If not, shows potential errors.
- Added error handling for operations that cannot be done on a protected sheet.
Mark 4.6
Release date: 7/7/2020
Build number: 20.07.03
Changes
- Added user defined number formatting to simulation output. Also applies to summary report.
- Refined simulation histogram horizontal axis to use scientific notation for very small numbers.
Mark 5
Release date: 10/16/2020
Build number: 20.09.14
Changes
- Added risk register.
- Added risk register report.
- Added risk rank report.
- Added heat map.
Mark 5.1
Release date: 5/14/2021
Build number: 21.05.07
Changes
- Improved handling of decimal comma.
- Fixed an issue for some machines that would cause an error when checking for the Excel version.
- RVEXTVALMAX, RVCEXTVALMAX, RVEXTVALMIN, RVCEXTVALMIN, RVLOGISTIC, RVCLOGISTIC> Improved error handling when truncation limits are not feasible.
- Minor bug fixes.
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.
Mark 3.5
Release date: 6/19/2020
Build number: 20.06.15
Changes
- Added Matrix Check tool. The tool checks correlation matrix for formatting and to see if it is positive definite or positive semi-definite. If not, shows potential errors.
- Added error handling for operations that cannot be done on a protected sheet.
Mark 3.6
Release date: 7/7/2020
Build number: 20.07.7
Changes
- Added user defined number formatting to simulation output. Also applies to summary report.
- Refined simulation histogram horizontal axis to use scientific notation for very small numbers.
Mark 4
Release date: 10/16/2020
Build number: 20.09.09
Changes
- Added risk register.
- Added risk register report.
- Added risk rank report.
- Added heat map.
Mark 4.1
Release date: 5/14/2021
Build number: 21.05.05
Changes
- Improved handling of decimal comma.
- Fixed an issue for some machines that would cause an error when checking for the Excel version.
- RVEXTVALMAX, RVCEXTVALMAX, RVEXTVALMIN, RVCEXTVALMIN, RVLOGISTIC, RVCLOGISTIC> Improved error handling when truncation limits are not feasible.
- Minor bug fixes.