Empty
&L&F &A&R &T &D
BuildTree
BuildTree (formerly Ctrl + b)
item
x
y
width
height
text
init/result
names
HelpText
TreePlan for Excel 1.79
HelpLineNew
1
Renumber T after editing help.
Edit value of each Boolean Constant, IsTrial and IsStudent
x
y
width
height
x
y
width
height
NewData
ID
Name
Value
Prob
Pred
Kind
NS
S1
S2
S3
S4
S5
Row
Col
Mark
SelectBox
564
160
TreePlan Student - Select
(Arial 10)
2
Locate entry lines in S.
Select cell W7 with text "VersionStrings"
XYWHSelWin
564
160
XYWHSelMac
624
172
0
TreePlan
0
0
0
D
2
1
2
0
0
0
0
2009 03 13 1.73
11
5
ResSelBut
16
(CW 28.33)
Decision Tree Software
3
Select S and T.
In Excel 97, choose Tools | Macro | Macros | W7 | Run
1
Alternative 1
0
0
0
T
0
0
0
0
0
0
0
2009 03 13 1.73
12
15
20
Branch names
17
Add-In for Microsoft Windows Excel 2000-2010
4
Create Names (left column).
These defined names are used by VBA CreateMenuItem
20080414
15
20
15
20
188
2
Alternative 2
0
0
0
T
0
0
0
0
0
0
0
2009 03 13 1.73
12
Partial cash flows
18
and for Macintosh Excel 2011
5
Set protection in VBE, and save as add-in using Excel 97
188
0
2009 03 14 1.73
12
Probabilities
19
6
188
12
Rollback EVs/CEs
20
TreePlan helps you build and modify decision tree diagrams
7
VersionStrings
20000104
188
0
DimSelEU
12
Rollback EUs
21
in Excel worksheets. TreePlan automatically puts formulas
8
0
188
0
12
Terminal values
22
on your worksheet for evaluating these trees.
9
0
188
0
12
208
20
Decision nodes
23
10
0
208
20
228
20
172
0
12
Event nodes
24
To build a new decision tree, first create a new worksheet.
11
0
172
0
12
Terminal nodes
25
Then start TreePlan in one of two ways:
12
0
172
0
12
Branch lines
26
13
0
172
0
12
Diagonal lines
27
Windows Excel 2000-2003
14
0
172
0
''=DoTermForm() 20110608
12
Connectors
28
Tools > Decision Tree, or Ctrl+Shift+T
15
0
172
0
''=DoRollbackForm() 1.78
12
388
20
Nodes
29
16
0
388
20
428
20
173
0
12
Diagonals
30
Windows Excel 2007 & 2010
17
0
173
0
20060416
12
Left branches
31
Add-Ins > Decision Tree, or Ctrl+Shift+T
18
0
173
0
12
Right branches
32
19
0
173
0
12
Terminal values
33
Macintosh Excel 2011
20
0
173
0
14
7
7
178
116
Cells
34
Tools > Decision Tree, or Option+Cmd+T
21
0
7
7
178
116
7
7
198
126
'' =SELECT(!TreeDiagram)
Restrict XL7 recalc fix to tree, 96NOV26
14
200
7
162
116
Objects
35
22
0
200
7
162
116
220
7
182
126
'' =FORMULA.REPLACE("=","=",2,1,FALSE)
Fixes XL7 recalc bug
14
380
7
163
100
Columns
36
When the TreePlan...New dialog box appears, choose
23
0
380
7
163
100
420
7
183
110
0
1
11
130
88
OK
37
New Tree. TreePlan builds a tree diagram with an initial
24
0
11
130
88
11
140
88
0
20080412
3
122
130
88
Options...
38
decision node and two branches. The tree diagram begins
25
0
122
130
88
179
140
88
2
233
130
88
Cancel
39
with the upper left corner of the diagram near the active
26
0
233
130
88
347
140
88
0
2009 03 14 1.73
3
456
130
88
Help
40
cell at the time New... is chosen. TreePlan assigns the
27
0
456
130
88
515
140
88
0
2009 03 13 1.73
41
name TreeDiagram to the range of the tree diagram and
28
0
0
2009 03 13 1.73
42
sets Excel's Print_Area equal to TreeDiagram.
29
0
43
30
0
0
44
To change the structure of the tree diagram, select a node,
31
0
45
start TreePlan, and choose commands from a TreePlan
32
0
DefineColNums
0
46
dialog box. Do not use Excel's commands to modify
33
0
0
item
x
y
width
height
text
init/result
names
47
the tree structure or any other cells or graphic objects in
34
0
x
y
width
height
x
y
width
height
0
TerminalBox
358
152
TreePlan Student - Terminal Node
48
the tree diagram. Only use TreePlan.
35
0
XYWHTerWin
358
152
XYWHTerMac
320
170
0
14
10
6
231
88
49
36
0
10
6
231
88
10
6
210
95
0
111
1
ResTerBut
50
On the left side of each branch of the tree diagram, there is
37
0
0
12
Change to decision node
1
51
a name field above the branch line and a partial-cash-flow
38
0
195
0
12
Change to event node
1
52
value field below the line. On the left side of event
39
0
195
0
DimTerPas
212
Paste subtree
1
53
branches, there is also a probability field above the name
40
0
195
0
DimTerRem
12
Remove previous branch
1
54
field. Decision nodes also have a number in them indicating
41
0
195
0
DimTerGro
214
254
6
89
105
Branches
1
55
the optimal branch.
42
0
254
6
89
105
230
6
80
115
0
DimTerOpt
211
2
ResTerNum
56
43
0
0
12
One
57
On the right side of each branch of the tree diagram, there