OptionsDialog
- Seed: If different than zero, the random number generation is initialized with the specified seed. The will result in different simulations of the same model to produce identical results. It useful for creating replicatable results. If it is zero, then the random number generation will be initialized with a computer randomly selected seed and each simulation would have slightly differrent results.
- The Iterations combo box: Allows you to specifay the number of iterations either from the drop-down list or by typing a number.
- "Update Screen during Simulation" check box: If checked you will be able to see the workbook updating during the simulation, but this may slow down the execution.
- "Use the Latin Hypercube method". If used the Latin Hypercube method will be used to generated samples from the risk distributions. The Latin Hypercube method results in more accurate results for the same number of iterations. It is on by default and there is no reason to change it.
- "Display Random Samples from distributions" checkbox: When it is checked, risk functions in the speadsheet show random samples of the respective distributions. When it is unchecked, risk functions show the mean of the distribution.
After using the XLRisk Options dialog and pressing OK, if not already present, a new sheet will be created in the Active Workbook called "XLRisk". This sheet contains various XLRisk settings and the simulation inputs and outputs. You noramally do not need to change this sheet, except if you want to clear the specified output ranges.