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.
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.
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.
Reporting
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.
