| |
|
|
|
|
|
TreePlan®
helps you build a decision tree diagram in an Excel worksheet
using dialog boxes. Decision trees are useful for analyzing sequential
decision problems under uncertainty.
Your decision tree model may
include various controllable alternatives (e.g., whether to introduce a
new product, whether to bid on a new project) and uncontrollable
uncertainties (e.g., possible demand for a product, whether you're
awarded a contract), arranged in chronological order.
TreePlan automatically includes formulas for summing cash flows to obtain outcome values and for calculating rollback values to determine optimal
strategy.
|
|
|
|
|
 |
|
 |
|
|
|
Only US$59 |
|
Free Trial and
User Guide |
|
|
| |
|
|
| Benefits: |
* |
Save time by using TreePlan to quickly build a decision
tree model. |
|
* |
Format your decision tree using TreePlan to select cells
and Excel's formatting commands. |
|
* |
Use TreePlan's diagram to explain your analysis to
colleagues. |
|
* |
Check your assumptions using Excel's Data Table command to
automate sensitivity analysis. |
|
* |
Integrate your decision tree model with other Excel
models. |
|
* |
Easily use the single-file TreePlan add-in with no
complicated installation; simply open TreePlan.xla
whenever and wherever
you need it. |
To use TreePlan, you
(1) open a new worksheet,
(2) choose Tools | Decision Tree
(Excel 2003 & 2011) or Add-Ins | Decision Tree (Excel 2007, 2010, & 2013),
(3) select a node to change the structure of your decision
tree,
(4) enter branch names, cash flows, and probabilities,
and
(5) determine the optimal strategy from TreePlan's results.
Click each tree diagram thumbnail below to see the full-size tree diagrams.
| Expected Value Rollback |
|
Risk Utility Rollback |
|
|
|
|
| |
|
|
| Decision Node Dialog Box |
|
Options Dialog Box |
 |
|
 |
To provide feedback or for additional information about TreePlan, SensIt, and
RiskSim,
please send e-mail to
Mike Middleton.
|
