Excel Tools
Our Excel add-ins described below can get you into the Chance Age fast. The models they create run in native Excel without macros or add-ins and may be shared with any Excel user.
ChanceCalc+™ Chance Calculator
ChanceCalc+ is an Excel add-in that reads Stochastic (SIP) Libraries in the cloud or on your desktop, then calculates the chance of achieving your targets with a single command. It also includes the SIPmath Monte Carlo simulation module for generating random variates of many kinds, including Metalogs. It can perform thousands of simulation trials per keystroke without macros or add-ins by means of the built-in Excel Data Table function.
In beta test now, contact info@probabilitymanagement.org
XLTree® Decision Tree
XLTree is a Decision Tree add-in for Excel 2016 or higher. It creates interactive Decision Trees in Excel, which may contain State Variables, may be “flipped” for Value of Information calculations, and may be used to create presentation quality graphical representations of trees.
Tools Summary
| Description | Cost | |
|---|---|---|
| Legacy SIPmath Tools | Our legacy Monte Carlo tool generates its own random inputs. SIPmath 2.0 Format only. | Free |
| ChanceCalc+ | All the features of the original ChanceCalc plus the full SIPmath Monte Carlo module with correlated variates, and multiple experiment simulations. | Open-Source VBA modules or $1500 ready to run with install package. Free educational version. |
| XLTree | Decision Tree Software. May be tied to ChanceCalc. | Free |
Feature Comparison (click here for XLTree)
| FEATURES | ChanceCalc+edu | Free Legacy SIPmath Tools | ChanceCalc+ |
|---|---|---|---|
| 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 2.0, CSV | SIPmath 2.0 | SIPmath 3.0, SIPmath 2.0, CSV |
| Maximum Number of Trials | 10,000 | Unlimited | Unlimited |
| Multiple PM Tables | |||
| Exploits Lambda Functions and Dynamic Arrays | |||
| Metalog Template Interface | |||
| Output SIP Library Formats | SIPmath 2.0,CSV | SIPmath 2.0 | SIPmath 3.0*, SIPmath 2.0, CSV |
| Generates Correlated Random Variates Internally | |||
| Multi-experiment and multi-scenario mode: For comparitive experiments. | |||
| Cost | Free | Free | Open-source VBA code or $1500 ready to run with install package |
*ChanceCalc+ 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.