ModelRisk: Monte Carlo simulation within Excel | Vose Software


Release notes

What's New

version 6.1.99 (including changes from 6.1.95 to 6.1.99)

  • Results Viewer changes:
    • New "Create SID" button on the "General" tab - allows you to upload all simulation results or the active chart data only to SIDs Library
    • New "Export to XML" button on the "General" tab - allows you to upload all simulation results or the active chart data only to XML-file
    • New "Export to XML" button on the "List options" tab - allows you to upload data list to XML-file
  • SIDs Library changes:
    • The toolbar has been re-designed
    • New "Create SID from Simulation results". Allows you to import into the SIDs Library the active model simulation results or saved results from .vmrs-files
  • Data Viewer changes:
    • Correlation values ​​have been added to the "View data" tab that allows you to compare quickly rows (columns) of data selected for viewing
    • The design of the correlation matrix, used on the "Multivariate Data Analysis" tabs (available when viewing multivariate data in the "data" mode) and "Multivariate time series" (available when viewing multivariate data in the "Time series" mode), has been changed
    • Several changes in the other "Data Analysis" windows aimed at improving the visibility of data presentation
  • Advanced Options changed: The "Optimization options" window has been re-designed

version 6.1.94 (including changes of 6.1.93 and 6.1.92)

  • The simulation performance of large models is optimized.
  • A new high-performance algorithm of the models’ analysis which is used in the initial stage of simulation is implemented.
  • The performance of the statistical functions listed is improved (in some cases the improvement can be significant):VoseSimPercentile, VoseSimProbability, VoseSimCorrelation, VoseSimCorrelationMatrix, VoseSimCofV, VoseSimCVARp, VoseSimCVARx, VoseSimSensitivityMean, VoseSimSensitivityPercentile, VosePrecisionProbability, VosePrecisionPercentile, VoseSixSigmaDefectPPM, VoseSixSigmaProbDefectShift, VoseSixSigmaProbDefectShiftLower, VoseSixSigmaProbDefectShiftUpper, VoseSixSigmaDefectShiftPPMLower, VoseSixSigmaDefectShiftPPMUpper,VoseSixSigmaSigmaLevel, VoseSixSigmaYield, VoseSixSigmaDefectShiftPPM
  • VoseSID function is improved: the performance of the function is improved, compatibility bugs with the new algorithm are fixed (6.1.91, 6.1.92, 6.1.93), the incorrect performance of the function in the Fixed seed и Go to sample modes is fixed.
  • VoseCopulaMultiNormal and VoseCopulaMultiT performance is fixed.
  • The Results Viewer bug is fixed. In particular, when selecting the list of results from the first to last line manually and copying, the last line of the list was not copied to the clipboard.

version 6.1.91

  • The following changes in Results Viewer are implemented: new interface design of the main controls, new Statistics Pane supporting percentiles sorting, save behavior: readonly flag after vmrs-file saving is removed
  • New interface design of the Select Distribution window including new distributions grid and new statistics table is implemented.
  • New statistics table is implemented in all windows where supported.
  • Expert window bug is fixed: Weibull mathematics used for the known x1/p1, x2/p2 was incorrect for "beta".
  • Expert window bug is fixed: Exporting of Distribution-Object failed.

version 6.1.90

  • Results Viewer Data List tooltip text overflow is fixed.
  • Slider bug is fixed for some windows (error occurred when moving chart sliders in non-English systems).
  • Expert window drawing positioning bug is fixed (error occurred while the window was in full screen mode).
  • Expert window localization bug is fixed. (error occurred in non-English localized versions of MS Office - recalculate button was unresponsive).
  • Aggregate Panjer window bug is fixed (selection of any distribution in Fit menu could possibly cause application crash).
  • Aggregate DePril window slider bug is fixed (error occured when the marker values of Statistics grid "Lower P" or "Upper P" were entered manually).
  • Results Viewer bug is fixed (the initial position of the slider in CumulA and CumulD charts could be incorrect when the minimum value of simulation results repeated in more than 5% of the total number of values).

version 6.1.89

  • Optimized VoseCopulaMultiNormal and VoseCopulaMultiT performance. To manage the optimization settings use the Advanced Options item of the ModelRisk taskbar icon in the context menu and press the Optimization Options button.
  • Fixed Copula Insertion into the linked Distributions combined with VoseInput or VoseOutput (Copula Bivariate & Multivariate windows).
  • Prevented the hidden DSNFiles sheet creation when there are no associated DSN-files.
  • Fixed Results Viewer: Fixed the incorrect reading of the Type option on the Variables tab of the Histogram chart settings. (The Type option read as undefined value was saved as Line instead of Bar).
  • Fixed Results Viewer: Fixed the incorrect slider’s value formatting on Non-English Locales.
  • Fixed the problem of pasting formulas in the uppercase that was reproduced in some localized (e.g. Turkish) versions of Office.
  • Fixed the User Interface Template loading error: the NUMLOCK button automatically turned off when starting ModelRisk and switching the Ribbon template.

version 6.1.88

  • Changes in the Advanced Options window available from context menu of the ModelRisk task-bar Icon (in the desktop bottom left corner): added a new Optimization settings button that allows to manage Simulation Statistics Optimization and Distributions Optimization at Simulation time.
  • Optimized the Simulation statistics worksheet functions: VoseSimPercentile, VoseSimProbability, VoseSimCVARp, VoseSimCVARx,VoseSimCorrelation, VoseSimCorrelationMatrix, VoseSimMean, VoseSimVariance, VoseSimStdev, VoseSimCofV, VoseSimSkewness, VoseSimKurtosis, VoseSimMin, VoseSimMax, VoseSimSemiVariance, VoseSimSemiStdev, VoseSimMSE, VoseSimValue, VoseSimTable.
  • Fixed the VoseSimPercentile bug: a problem occured when the book name included a space.
  • Fixed Results Viewer: Removed the tooltip flickering when moving the mouse cursor over the list of variables.
  • Fixed Cholesky algorithm: The problem in calculations, in the case when the input matrix consisted of zeros and ones.
  • Fixed the problem of pasting formulas in uppercase that was reproduced in some localized (e.g. Turkish) versions of Office.
  • Fixed Goto Sample Simulation Mode.
  • Fixed the Advanced Options window: While the initial loading of the window, the Server busy system message sometimes appeared.

version 6.1.87

  • Fixed the Distribution Object functions behaviour when simulating in the mode with the active optimization

version 6.1.86

  • Fixed VoseProb, VoseDataObject functioning and the interface for its creation

version 6.1.85

  • The Select Interface Templates demo window
  • Improved the simulation algorithm in the Fixed Seed mode
  • Improved the RV design

version 6.1.82

  • Support for the automatic connection of the workstations to the network license
  • Fixed a bug reproduced in the Stop On Output Error mode when simulating the workbooks without Vose functions

version 6.1.74

  • Fixed an activation bug in 2-year and 3-year licenses

version 6.1.73

  • Fixed a problem with AutoRun on User Logon which did not work while switching off and on again
  • Fixed a problem which caused ‘ModelRiskSettings.ini not found’ message
  • Implemented a new distribution VoseThreePercentiles
  • Improved parallelization algorithms for some complex features which use cache
  • Updated Interfaces for the non-English languages
  • Added French language
  • Added overall License Manager Manual for our products
Tags: Monte Carlo simulation, Monte Carlo method, Monte Carlo analyses, Simulation software Excel,decision making software