Probability Management Compatible VendorsA Stochastic Information Packet or SIP is an array of simulated or historical realizations of an uncertain quantity. It provides a representation of a probability distribution as data with provenance, and is additive and auditable. The following software packages have been designed for compatibility with SIPs, and all are more powerful than native Excel for creating SIP libraries. We appreciate the ongoing support of the associated firms.
Below, we describe standards that will facilitate the use of libraries generated by such programs as inputs to SIP math dashboards in native Excel.
Analytica, from Lumina Systems
Powerful multi-dimensional modeling and simulation language. Calculates with the equivalent of SIP math internally and supports many distributions for performing Monte Carlo. Can import and export SIPs from and to Excel.Crystal Ball, from Oracle Corp
Powerful traditional Monte Carlo Simulation for Excel, with a broad user base. Supports many distributions. Generates and reads SIPs.Risk Solver Platform, Frontline Systems
Capable of interactive simulation and stochastic optimization on industrial sized problems, using both SIPs, and internally generated random numbers from many distributions.XLSim, from Vector Economics
Free Excel add-in performs traditional Monte Carlo simulation with common distributions. Features include: SIP processing and DIST Distribution Strings, which compress SIP trials into a single cell for improved stochastic library management.
Stochastic Library Standard for Excel 10/30/2012We have created a simple standard described here, and supported by the SIPmath Modeler Tools.
Stochastic libraries are stored in Excel worksheets containing SIPs and SLURPs (coherent sets of SIPs). The standard has three parts.