|
| |
| |
TreePlan Decision Tree Add-In
For Microsoft® Excel 97-2007, Windows or Macintosh |
| |
|
 |
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. |
 |
|
 |
|
 |
|
|
|
Only US$49 |
|
Multi User |
|
Free Tryout |
|
|
| |
|
|
| 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.
Click each thumbnail below to see the full-size picture. Use your
browser's Back button to return to this page.
| Decision Tree Inputs |
|
Decision Dialog Box |
 |
|
 |
| |
|
|
| Decision Tree Results |
|
Options Dialog Box |
 |
|
 |
| |
|
|
| Expected Value Rollback |
|
Risk Utility Rollback |
|
|
|
|
To provide feedback or for additional information about TreePlan, SensIt, and
RiskSim, please send e-mail to
Mike Middleton.
|
