Decision Trees in Microsoft Excel

SolutionTree integrates seamlessly with Microsoft Excel. Model and analyze your decision trees directly in your spreadsheet using the skills you already have. Easily perform complex decision analysis, create automated risk reports, and more -- with almost no learning curve!

SolutionTree automatically calculates the optimal path through your decision tree. As you update the node values, the custom functions will determine the best alternatives by "folding back" the optimum expected value for the entire decision tree. Decision analysis doesn't get any easier than this.

SolutionTree is a lightweight diagram that sits on top of the spreadsheet. And you make your inputs in the spreadsheet like you've always done, instead of in some bulky, complicated dialog box.

With SolutionTree building complex decision trees is easy. Any branch can be moved or copied from one node to another. And you can choose to copy the formulas or just the values, just like you're used to doing in Excel already. You can even paste the branch to a new decision tree or to a different tree in the same workbook.

Sometimes a decision tree will get too complex to take it all in. With SolutionTree you can easily collapse nodes to hide large branches, and you can expand any collapsed node at any time. Tip: To prevent accidental changes or hide sensitive data you can collapse the branch, then protect the worksheet -- great for presentations and printouts!

In any decision tree the total probability must equal 100%. SolutionTree keeps track of this for you so you'll always know if your tree is valid. Plus, any node's children must have a total probability of 100%. SolutionTree can automatically highlight any errors for you allowing you to easily see which nodes need correcting.

You can choose the "Fixed Root Node" setting to keep the root node at the top of the spreadsheet (as shown in screenshot above), or use the standard layout, where the root node "floats" up and down on the spreadsheet depending on the tree structure.

With a click of a button you can create a Risk Profile for the active decision tree. Another click for the Cumulative Probability report. You can also create an Optimal Path report which displays only branches and nodes in the decision tree's optimal path.

Because SolutionTree harnesses the built-in graphical capabilities in Excel, you can change the look and feel of your decision trees to suit your needs -- shadows, reflections, 3D and much more.