Lumenaut provides three analysis packages covering Monte Carlo simulation, Statistical Analysis and Decision Tree Excel Analysis. The latter includes sensitivity analysis, tornado charts, spider charts and probability profile charts. Various measures such as expected utility and net present value , and tree size can grow to 28 node width and 16,000 nodes high (enough for most applications). The add-in is reasonably priced at US$149.
PrecisionTree6 is part of an impressive suite of Excel based tools for decision support from Palisade. It supports cumulative risk profile graphs, 2-way sensitivity analysis, policy decision reports and strategy region graphs. Tree size is effectively unlimited in the Industrial version. Advanced features include Bayesian revision which lets the user flip one or more chance nodes to show probabilities calculated using Bayes Rule. Logic nodes, reference nodes, linked trees and other features make this one of the more advanced decision tree add-ins for Excel. PrecisionTree industrial costs £945 and the Professional version £745.
SolutionTree supports the direct building of decision trees by entering data directly into a worksheet. It calculates optimal paths, copy and paste functionality (areas of the tree can be moved around), collapse and expand branches, validation of probabilities, risk profile and cumulative probability charts. A licence costs US$90.
TreeAge Pro Excel
While TreeAge Pro is not a wholly Excel based product it does come with an Excel add-in to transfer data and analysis to and from Excel. This allows graphs to be produced and model inputs to be edited within Excel. The core TreeAge Pro product is a highly visual tool for creating decision trees with a level of functionality that goes beyond the abilities of Excel add-ins alone. TreeAge Pro annual licences costs US$345 and TreeAge Pro Excel costs US$435 for commercial use.
TreePlan Decision Tree add-in is a low cost (US$59) option supporting sensitivity analysis and basic decision tree creation. A fuller sensitivity analysis add-in is available supporting spider and tornado charts for the same price.