AppSource
Skip to main content

Decision Tree

Garden City Consultants
a tool to visualize a course of actions, statistical probability outcomes or option pricing

Description:

Decision Tree Excel Add-in visualizes a course of actions, statistical probability outcomes or option pricing.

Two sample data in the add-in helps user to understand the data structures:

  • Decision Tree Sample Data.

  • Option Pricing model sample data.

Both sample data have the same format.

The data has 4 columns:

  • ID: numeric identifier of the node.

  • Label: the label of the node in the tree.

  • ParentID: the parent node id in the tree.

  • Size: the font size of the node. It is a relative representation of the font size, not the real font size.

  • Style: the color of the node. It can be a text such as "black", "red", "green" or a color code such as #FF0000, #00FF00.

Features:

  • User can select different fonts in the setting window for the tree labels.

  • Adjustable node size of the tree by using the max font size setting.

  • Mouse over the chart to view the data detail in the tool-tips.

  • Change the chart title by clicking in the title area and enter a preferred text for the chart title.

  • Easy to use and user friendly are the key features of this add-in. Sample data can be the template to build own data.

  • Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entering.

Instruction:

  • Download this add in and start Excel 2013 SP1 or later Add in.

  • Select a sample data type in the sample data drop-down in the setting window and Click Insert Sample Data button to view the chart.

  • Clean the sample data and set the focus to the first cell.

  • Select a different type of sample data in the setting window and view the chart.

  • Repeat step 2, 3, 4 to view all the 2 different sample data.

  • Build own data and paste into sample data table and click binding existing data button to draw the chart.
Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680110/Asset_2a9992a0-ab50-4696-b5b6-584dd88d6924/DecisionTree1.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680110/Asset_2a9992a0-ab50-4696-b5b6-584dd88d6924/DecisionTree1.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680110/Asset_19b056ca-d542-47b9-91c6-77887e302579/DecisionTree2.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680110/Asset_6ae448a3-664a-44c0-a337-bdf92cf944b1/DecisionTree3.jpg
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949680110/Asset_b5be63c3-7b48-4a3e-9617-77fa3bc65dda/DecisionTree4.jpg