PrecisionTree

Bayesian Revision – This lets you to "flip” one or more chance nodes in a model in order to show probabilities calculated using Bayes’ Rule. This is valuable when the probabilities of a model are not available in a directly useful form. For example, you may need to know the probability of an outcome occurring given the results of a particular test. The test’s accuracy may be known, but the only way to determine the probability you seek is to "reverse” a traditional tree using Bayes Rule.

Logic nodes– A special type of node where the optimum branch is selected according to conditions the user defines. A logic node behaves like a decision node, but it selects the branch whose branch logic formula evaluates to TRUE as the logical (optimum) decision.

Reference nodes– Are used to reference a sub-tree. The sub-tree can be on any sheet in the workbook. Use reference nodes to simplify a tree, to reference the same sub-tree many times in a tree, or to build a tree that’s too large to fit on one spreadsheet.

Linked Trees– Allow the branch values for a decision tree to be linked to cells in an Excel model external to the tree. Each node can be linked to an Excel cell reference or range name. End node payoffs can be calculated by a detailed spreadsheet model. This powerful feature combines the strength of a decision tree for describing decision situations with the strength of a traditional spreadsheet model for calculating results.

Payoffs with VBA Macros– PrecisionTree can calculate decision tree path payoff values using a custom VBA formula. Using this method, you can drastically simplify your models.

Custom Utility Functions– Converts a model’s monetary payoffs into "utility” to account for the decision maker’s attitude toward risk, which can affect the optimal decision choice. PrecisionTree offers a default exponential utility function, but, using VBA custom functions, you can easily construct your own custom utility function.

PrecisonTree Developer Kit–Built-in programming language that allows you to automate PrecisionTree using Excel VBA.

Influence Diagrams–Using nodes and arcs, influence diagrams are used to summarize the general structure of a decision. They can also represent asymmetric trees. You can convert influence diagrams into decision trees.