VoseSID | Vose Software

VoseSID

See also: SIDs

=VoseSID(NameSID, Sampling)

 

An array function for entering SIDs (Simulation Imported Data Files) into your model.

The function VoseSID allows two parameters:

  • NameSID - the first parameter (required) is a text string on the name of the SID;

  • Sampling - the second parameter (optional) allows you to control how the values are drawn from the SID:

  • 0, FALSE or omitted  – the function will sample values during a simulation row by row in the order in which they were provided. This is the most common option and allows you to run simulations of different model using the same SID and know that each sample in the models will have matching assumptions. Note – if, for example, your SID contains 5000 rows but you run a simulation of 10000 samples, the function will loop twice through the SID data;

  •  1 or TRUE  - – the function will sample values during a simulation row by row in a random order.

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Spreadsheet risk analysis modeling

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Project risk analysis

Navigation

Enterprise Risk Management software (ERM)

Learn more about our enterprise risk analysis management software tool, Pelican

Enterprise risk management software introduction