|How It Works|
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.
TreePlan creates formulas for summing cash flows to obtain outcome values and for calculating rollback values to determine optimal strategy.
You can purchase TreePlan risk-free with our 90-day Money-Back Guarantee.
Single-license TreePlan Pro $59
- Save time by using TreePlan to quickly build a decision tree model.
- Two ways to run TreePlan: quick launch for temporary use, or permanent installation.
- Format your decision tree the way you want it.
- Use TreePlan to select a group of cells or shapes. Then apply Excel’s formatting commands to the group.
- Use TreePlan’s diagram to explain your analysis to colleagues.
- Check your assumptions. Perform what-if analysis using the Excel Data Table command to automate sensitivity analysis.
- Integrate your decision tree model with other Excel models.
How It Works
- Open a new worksheet,
- choose Tools | Decision Tree (Mac Excel 2011) or Add-Ins | Decision Tree (Excel 2010 & 2013),
- click the New Tree button, and TreePlan creates an initial tree with two branches,
- select a node, and run TreePlan to change the structure of your decision tree,
- enter branch names, cash flows, and probabilities, and
- see the optimal strategy from TreePlan’s results.
For a larger version of a tree diagram, click the image.
To return from the larger version, use the browser Back button.