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 | |
|---|---|---|
| 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 |
| Legacy SIPmath Tools | Our legacy Monte Carlo tool generates its own random inputs. SIPmath 2.0 Format only. | Free |
| ChanceCalc+ | All the features of ChanceCalc plus the full SIPmath Monte Carlo module with correlated variates, and multiple experiment simulations. | Free Open-Source VBA modules or $1500 ready to run with install package. |
| XLTree | Decision Tree Software. May be tied to ChanceCalc. | Free |
Feature Comparison (click here for XLTree)
| FEATURES | ChanceCalc Lite | 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 3.0, SIPmath 2.0, CSV | SIPmath 2.0 | SIPmath 3.0, SIPmath 2.0, CSV |
| Number of Input SIP Libraries | 1 | Unlimited | Unlimited |
| Total Number of Input SIPs | 5 | Unlimited | Unlimited |
| Metalog Template Interface | |||
| Generates Random Variates Internally | |||
| Output SIP Library Formats | NA | 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 | 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.