|
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 for determining optimal
strategy.
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 from Excel's menu,
(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.
|