DTace Features

This page lists the features of DTace.

Referenced Data

DTace can reference tree data to spreadsheet cells.  For example, if you have calculated payoff values in the workbook, just reference the cell where the payoff is located.

Tree Layout

Auto arrange feature will automatically arrange tree in either a horizontal or vertical orientation.  Nodes can also be manually moved to arrange the tree any way you want.

Left to Right
Top to Bottom

Node Hiding

DTace has node hiding options to only show important features of the decision tree.  You can show only the nodes on optimal paths, while hiding non-optimal nodes.  Also, you can hide by node level.  Finally, a base node can be selected and all nodes that are not children of the base node will be hidden.

Before Hiding
After Hiding

Text Visibility

Data fields and their labels can be toggled on and off.  Text can be located above/below nodes or left/right.

Click to Edit

When the click to edit setting is on, clicking on a node will open the edit node form to quickly edit nodes.

Connector Types

Three connector types are available: straight, curved, and elbow.

Node Sorting

When new nodes are added to an existing tree, the node sorting tool will rearrange nodes so they are next to their parent node.

Roll Back

You can use expected value, exponential utility, certainty equivalent, or define your own utility function.

Probability Check

The probability check tool verifies that outcomes from each chance node have a total probability of one.  As a result, there are fewer probability errors.

Risk Profile

The risk profile tool allows for the creation of probability plots and payoff table for the optimal path through the tree.

Sensitivity Analysis

A sensitivity analysis tool that varies payoffs and probabilities to find the factors that have the most impact on expected value or utility.  A sensitivity report can be sent to a new worksheet or workbook.  Tornado and spider charts can be included in the sensitivity report.

Selection Tools

Selection tools that are useful for mass copying and formatting.  Using these tools allows you to easily use Excel native formatting tools.  Selection types: select everything, select all nodes, select by node type, select all text, select all connectors.

Saved Arrangement

The saved arrangement tool saves a tree arrangement to allow for temporary changes to layout.  As a result, tree layout can be restored to saved arrangement later.  For example you can arrange the tree for a presentation, and save this arrangement.  You can auto arrange the tree for the most compact arrangement, and then restore the presentation layout any time.


DTace generates node data reports in a new worksheet or workbook.  It also has several data filtering and sorting functions to only get the data you want.

Monte Carlo Simulation Compatible with Simulation Master

The SIMROLLBACK worksheet function allows Monte Carlo simulation of expected value.  Using Simulation Master, chance node outcomes can be treated as random variables for simulation.