Excel Tools
Our Excel add ins described below can get you into the Chance Age fast. They leverage the native Data Table function to bring interactive simulation to all Excel users. That means that the models built with these tools do not require the tools or other macros to run.
ChanceCalc
ChanceCalc is an Excel add-in that accesses uncertainties stored as SIP Libraries in the cloud or on your desktop, then calculates the chance of achieving your targets in native Excel with a single command. ChanceCalc Lite is free and has limited input and output abilities.
ChanceCalc Monte Carlo
ChanceCalc Monte Carlo expands the capabilities to include Monte Carlo simulation with internal generation of random variates and the ability to save stochastic libraries as SIPmath 2.0 files, including metadata. Regularly scheduled “How to” sessions are provided. A good transitional step between ChanceCalc and ChanceCalc Monte Carlo are the Free Legacy SIPmath Tools.
Tools Summary
| Description | Cost | |
|---|---|---|
| ChanceCalc Lite | Easiest way to enter the Chance Age. Reads random inputs from SIP libraries. Includes step by step tutorial and examples. Limited to 5 Input SIPS. | Free |
| ChanceCalc | Adds unlimited Inputs. Saves output SIP Libraries as CSV. Metalog Interface creates uncertain inputs from Metalog Templates. | $150 |
| Legacy SIPmath Tools | Our legacy Monte Carlo tool generates its own random inputs. SIPmath 2.0 Format only. Good transitional step between ChanceCalc and ChanceCalc Monte Carlo. | Free |
| ChanceCalc Monte Carlo | All the features of ChanceCalc plus full Monte Carlo with correlated variates, and multiple experiment simulations. Includes regularly scheduled training and Q&A. | $1500 |
Feature Comparison
| FEATURES | ChanceCalc Lite | ChanceCalc | Free Legacy SIPmath Tools | ChanceCalc Monte Carlo |
|---|---|---|---|---|
| Creates interactive simulations in Excel that run without macros or add-ins using the data table. Can perform thousands of trials per keystroke. | ||||
| Input SIP Library Formats | SIPmath 3.0, SIPmath 2.0, CSV | SIPmath 3.0, SIPmath 2.0, CSV | SIPmath 2.0 | SIPmath 3.0, SIPmath 2.0, CSV |
| Number of Input SIP Libraries | 1 | Unlimited | Unlimited | Unlimited |
| Total Number of Input SIPs | 5 | Unlimited | Unlimited | Unlimited |
| Metalog Template Interface | ||||
| Generates Random Variates Internally | ||||
| Output SIP Library Formats | NA | SIPmath 3.0*, CSV | SIPmath 2.0 | SIPmath 3.0*, SIPmath 2.0, CSV |
| Generates Correlated Random Variates Internally | ||||
| Multi-experiment and multi-scenarion mode: For comparitive experiments. | ||||
| Cost | Free | $150 | Free | $1500 Includes training sessions |
*ChanceCalc and ChanceCalc Monte Carlo can output SIPmath 3.0 Libraries containing a single variable using Metalog Template workbooks. To generate multiple variable 3.0 Libraries, we recommend the Analytic Solver from Frontline Systems.
