Decision Tree

Garden City Consultants

1.8 (16)

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.
Bővítmény képességei
Használatakor ez a bővítmény:
  • Olvashatja és módosíthatja a dokumentumot
  • Adatokat küldhet az interneten keresztül
  • https://store-images.s-microsoft.com/image/apps.10372.afbb07d6-eff5-4b15-a085-38a263d593b7.41a17728-f744-4d84-92a4-a4e8ef9bc5ce.8a6320a9-c45c-431f-b05f-cb012860d78e.jpeg
    https://store-images.s-microsoft.com/image/apps.10372.afbb07d6-eff5-4b15-a085-38a263d593b7.41a17728-f744-4d84-92a4-a4e8ef9bc5ce.8a6320a9-c45c-431f-b05f-cb012860d78e.jpeg
    https://store-images.s-microsoft.com/image/apps.5878.afbb07d6-eff5-4b15-a085-38a263d593b7.41a17728-f744-4d84-92a4-a4e8ef9bc5ce.693cd7c3-4d74-474e-9de5-049b3408be53.jpeg
    https://store-images.s-microsoft.com/image/apps.27735.afbb07d6-eff5-4b15-a085-38a263d593b7.41a17728-f744-4d84-92a4-a4e8ef9bc5ce.f48897af-3275-4ecd-9f32-063b85cc9b1b.jpeg
    https://store-images.s-microsoft.com/image/apps.32515.afbb07d6-eff5-4b15-a085-38a263d593b7.41a17728-f744-4d84-92a4-a4e8ef9bc5ce.912af6db-0dd2-44f6-b17f-611f20eda0c5.jpeg