Consulting Report

profilesloezh
TreePlan-Student-179-Addin.xla
Home>Mathematics homework help>Statistics homework help>Consulting Report

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
44
0
12
Two
58
is a rollback Expected Value field below the line near
45
DoNodeRowCol
0
12
Three
59
each node. TreePlan automatically puts the rollback EV
46
0
12
Four
60
formula into this cell: maximum of successor EVs at a
47
0
12
Five
61
decision node, and expected value of successor EVs at an
48
0
1
12
99
88
OK
62
event node.
49
12
99
88
12
112
88
0
2
12
125
88
Cancel
63
50
12
125
88
12
142
88
0
DimTerSel
3
256
125
88
Select...
64
To the right of the terminal nodes, there is an endpoint
51
256
125
88
223
142
88
0
3
133
99
88
Options...
65
value field that sums all of the partial cashflows in the tree.
52
133
99
88
117
112
88
0
3
133
125
88
Help
66
53
133
125
88
117
142
88
0
67
Internally, TreePlan uses the TreeData range, near cell
54
0
68
GV1000, to construct the TreeDiagram.
55
0
69
56
0
item
x
y
width
height
text
init/result
names
70
CAUTION: Do not insert or delete rows or columns in the
57
0
NewBox
320
37
TreePlan Student - New Tree
71
TreeDiagram or TreeData ranges. Modify the tree diagram
58
0
1
10
7
88
New Tree
72
only by using TreePlan's menu options.
59
0
2
116
7
88
Cancel
73
60
0
3
222
7
88
Help
74
61
0
75
TREEPLAN...DECISION and
HelpLineDecision
62
0
76
TREEPLAN...EVENT dialog boxes
63
0
77
64
0
78
Add branch
65
0
item
x
y
width
height
text
init/result
names
79
Adds a single branch after the selected node .
66
x
y
width
height
x
y
width
height
0
EventBox
332
163
TreePlan Student - Event Node
80
(No more than 5 branches are allowed.)
67
XYWHEveWin
332
163
XYWHEveMac
305
183
0
14
14
4
190
153
81
68
14
4
190
153
14
4
172
170
0
11
1
ResEveBut
82
Copy subtree
69
0
DimEveAdd
12
Add branch
83
Copies the selected node and all its successors to the
70
150
0
12
Copy subtree
84
TreePlan clipboard.
71
150
FirstNotMark
2
12
Insert decision
85
72
150
0
12
Insert event
86
Insert decision
73
150
0
12
Change to decision
87
Inserts a decision node and single branch before the
74
150
0
DimEveSho
212
Shorten tree
88
selected node.
75
150
0
12
Change to terminal
89
76
150
0
DimEveRem
12
Remove branch
90
Insert event
77
150
0
1
221
9
88
OK
91
Inserts an event node and single branch before the
78
221
9
88
200
9
88
0
2
221
39
88
Cancel
92
selected node.
79
221
39
88
200
39
88
0
DimEveSel
3
221
69
88
Select...
93
80
221
69
88
200
69
88
3
221
99
88
Options...
94
Change to decision
81
221
99
88
200
99
88
AllImmSucMark
0
3
221
129
88
Help
95
Changes the selected event node to a decision node and
82
221
129
88
200
129
88
0
96
erases the probability fields from the event branches.
83
0
item
x
y
width
height
text
init/result
names
97
84
x
y
width
height
x
y
width
height
0
DecisionBox
332
163
TreePlan Student - Decision Node
98
Change to event
85
XYWHDecWin
332
163
XYWHDecMac
305
183
0
14
14
4
190
153
99
Changes the selected decision node to an event node.
86
14
4
190
153
14
4
172
170
0
11
1
ResDecBut
100
87
0
DimDecAdd
12
Add branch
101
Shorten tree
88
150
0
DimDecCop
12
Copy subtree
102
Removes the selected node and its single successor
89
150
12
Insert decision
103
branch.
90
150
FirstSucNotMark
0
DimDecIns
12
Insert event
104
91
150
0
DimDecEve
12
Change to event
105
Change to terminal
92
150
0
DimDecSho
212
Shorten tree
106
Changes the selected node to a terminal node. All
93
150
0
DimDecTer
12
Change to terminal
107
successor branches are erased.
94
150
0
DimDecRem
12
Remove branch
108
95
150
0
1
221
9
88
OK
109
Remove branch
96
221
9
88
200
9
88
2
221
39
88
Cancel
110
Erases the selected node, the previous branch, and any
97
221
39
88
200
39
88
DefDiagName
0
DimDecSel
3
221
69
88
Select...
111
successor branches and nodes.
98
221
69
88
200
69
88
0
3
221
99
88
Options...
112
99
221
99
88
200
99
88
0
3
221
129
88
Help
113
100
221
129
88
200
129
88
0
114
TREEPLAN...TERMINAL dialog box
HelpLineTerminal
101
0
item
x
y
width
height
text
init/result
names
115
102
x
y
width
height
x
y
width
height
0
HelpBox
500
230
TreePlan Student - Help
116
Change to decision node
103
XYWHHelWin
500
230
XYWHHelMac
480
260
0
15
5
5
490
200
HelpText
16
InitHelpItem
117
Changes the selected terminal node to a decision node
104
5
5
490
200
5
5
470
220
0
1
206
205
88
Close
118
with one to five successor branches.
105
206
205
88
196
230
88
0
119
106
item
x
y
width
height
text
init/result
names
120
Change to event node
107
x
y
width
height
x
y
width
height
ClearTree
0
OptionsBox
387
144
TreePlan Student - Options
121
Changes the selected terminal node to an event node
108
XYWHOptWin
387
144
XYWHOptMac
330
158
0
1
1
14
7
5
373
52
Certainty Equivalents
122
with one to five successor branches.
109
7
5
373
52
7
5
316
57
0
2
2
11
2
ResOptExpBut
123
110
0
Line 21
3
3
12
Use Expected Values
124
Paste subtree
111
300
0
0
4
4
12
Use Exponential Utility Function
125
Pastes the subtree onto the selected terminal node from
112
300
0
0
5
14
7
60
373
52
Decision Node EV/CE Choices
126
the TreePlan clipboard.
113
7
60
373
52
7
67
316
57
0
2010 01 13 for 1.74
6
11
1
ResOptMinBut
127
114
7
12
Maximize (profits)
128
Remove previous branch
115
300
SetColWidths
0
8
12
Minimize (costs)
129
Erases the selected terminal node and the previous
116
300
0
9
5
1
7
117
88
OK
130
branch.
117
7
117
88
7
129
70
0
10
6
2
102
117
88
Cancel
131
118
102
117
88
89
129
70
0
11
7
3
197
117
88
Select...
132
119
197
117
88
171
129
70
0
12
8
3
292
117
88
Help
133
TREEPLAN...SELECT dialog box
HelpLineSelect
120
292
117
88
253
129
70
0
134
121
0
item
x
y
width
height
text
init/result
names
135
Cells
122
x
y
width
height
x
y
width
height
0
PurchaseBox
320
265
TreePlan Trial
20
136
To select a set of nonadjacent cells for subsequent
123
XYWHPurWin
320
265
XYWHPurMac
265
420
1
5
5
5
Thank you for trying TreePlan.
137
formatting, select the appropriate option button.
124
5
5
5
10
250
20
DrawTree
0
2
5
5
20
This is a fully functional, Trial version
138
125
5
20
5
35
250
20
0
3
5
5
32
for 30-day evaluation use only.
139
Objects
126
5
32
5
55
250
20
4
5
5
47
If you want to continue using TreePlan
140
To select all objects, choose Select Special from the
127
5
47
5
80
250
20
0
5
5
5
59
after 30 days, you must purchase the
141
Formula menu, and select the Objects option button.
128
5
59
5
100
250
20
0
6
5
5
71
standard or Student version.
142
129
5
71
5
120
250
20
0
7
5
5
86
You can purchase TreePlan by check or
143
Columns
130
5
86
5
145
250
20
0
8
5
5
98
charge card, by mail, phone, or Internet.
144
To select a set of nonadjacent columns for subsequent
131
5
98
5
165
250
20
0
9
5
5
113
For purchasing information and Help, click
145
formatting, select the appropriate option button.
132
5
113
5
190
250
20
''= CREATE.OBJECT(2,OFFSET(!TreeDiagram,CellRow,CellCol),0,0,OFFSET(!TreeDiagram,CellRow,CellCol),12,12,,FALSE)
10
5
5
125
the How To Buy button below.
146
133
5
125
5
210
250
20
''= OBJECT.PROPERTIES(2)
11
5
5
140
Standard and Student versions do not
147
134
5
140
5
235
250
20
''= PATTERNS(0,1,1,LineWeight)
12
5
5
152
display this purchase reminder notice.
148
TREEPLAN...OPTIONS dialog box
HelpLineOptions
135
5
152
5
255
250
20
0
13
14
3
167
313
62
149
136
3
167
313
62
5
280
255
90
0
14
5
10
176
I understand that I may use this version
150
Certainty Equivalents
137
10
176
15
285
235
20
0
2009 11 23 1.74 for Excel 2010
15
5
10
188
of TreePlan only for evaluation and that
151
The default is to rollback the tree using expected values.
138
10
188
15
305
235
20
0
16
5
10
200
any other use requires purchase of the
152
If you chose to use exponential utilities, TreePlan will
139
10
200
15
325
235
20
0
17
5
10
212
standard or Student version.
153
compute utilities and certainty equivalents at each node.
140
10
212
15
345
235
20
0
18
1
10
235
90
I Agree
154
For the Maximize option, the rollback formulas are
141
10
235
88
5
380
75
25
''= CREATE.OBJECT(3,OFFSET(!TreeDiagram,CellRow,CellCol),0,0,OFFSET(!TreeDiagram,CellRow,CellCol),12,12,,FALSE)
19
2
110
235
80
Quit
155
U=A-B*EXP(-X/RT) and X=-LN((A-U)/B)*RT, and for the
142
116
235
88
90
380
55
25
''= OBJECT.PROPERTIES(2)
Avoid distorted triangles in XL97, 97FEB22
20
3
200
235
100
How To Buy
156
Minimize option, U=A-B*EXP(X/RT) and
143
222
235
88
155
380
105
25
''= PATTERNS(0,1,1,LineWeight)
Added initial vertice to polygon array, 1996NOV05
157
X=LN((A-U)/B)*RT.
144
0
Focus shifted to How To Buy button, and
158
145
0
wider How To Buy button for display
159
NOTE: TreePlan uses the name RT to represent the
146
0
2009 11 23 1.74 for Excel 2010
in Excel 2007 & 2010 for 1.76, 20100817
160
risk tolerance parameter of the exponential utility
147
0
161
function; the names A and B determine scaling.
148
0
BoxTest (formerly Ctrl + d)
162
If the names A, B, and RT don't exist, they are initially
149
0
0
163
defined as A=1, B=1, and RT=999999999999. The
150
0
0
164
name UseExpUtility is a flag indicating whether to use
151
0
exponential utilities or expected values.
152
0
2008 02 09
153
0
Decision Node EV/CE Choices
154
0
The default is to Maximize profits. If you choose to
155
0
Minimize costs instead, the cash flows are interpreted
156
0
as costs, and decisions are made by choosing the
157
Line 84
minimum expected value/CE rather than the maximum.
158
0
TreePlan uses the name MinimizeCosts as a flag
159
"= PATTERNS(0,3,1,1)
Dashed line only when needed, 1997FEB22
indicating whether to maximize profits or minimize
160
0
Handled by VBA Sub, 1.77, 20101202
costs.
161
0
Shorter dashed line, 1997FEB22
162
0
163
Line 97
TRIAL LICENSE
164
0
165
0
TreePlan Software grants a license to prospective
166
0
purchasers to use the Trial version for a 30-day evaluation
167
Line 98
period. You can download the Trial version from
168
0
www.treeplan.com. Please share copies of the Trial
169
0
version freely with prospective purchasers. You are granted
170
0
permission to make as many copies of the Trial version
171
0
as you wish.
172
0
173
0
If you want to continue using the software after 30 days, you
174
0
must purchase a standard or Student license. Visit
175
0
www.treeplan.com for information about purchasing.
176
0
177
0
Instructors who require their students to use the software
178
0
must obtain a Student license, either by using a
179
0
textbook that has a license or by purchasing a license from
180
0
TreePlan Software via www.treeplan.com.
181
0
182
0
183
0
STANDARD LICENSE
184
''= CREATE.OBJECT(2,OFFSET(!TreeDiagram,CellZeroRow,CellZeroCol),0,0,OFFSET(!TreeDiagram,CellZeroRow,CellZeroCol),12,12,,FALSE)
185
''= OBJECT.PROPERTIES(2)
A licensed copy of our software may be used by a single
186
''= PATTERNS(0,1,1,LineWeight)
person who uses the software personally on one or more
187
0
computers.
188
0
189
0
2009 11 23 1.74 for Excel 2010
190
0
STUDENT LICENSE
191
0
192
0
TreePlan Software has granted a license to certain
193
''= CREATE.OBJECT(3,OFFSET(!TreeDiagram,CellZeroRow,CellZeroCol),0,0,OFFSET(!TreeDiagram,CellZeroRow,CellZeroCol),12,12,,FALSE)
textbook publishers to include the Student version with a
194
''= OBJECT.PROPERTIES(2)
specific edition. According to such an agreement with the
195
''= PATTERNS(0,1,1,LineWeight)
publisher, the Student version is for use only by
196
0
instructors and students who are using a specific edition of
197
0
a textbook covered by the license. Visit www.treeplan.com
198
0
2009 11 23 1.74 for Excel 2010
for a list of textbooks.
199
0
200
0
TreePlan Software has granted a license to certain
201
Line 100
universities, schools, departments, and instructors to allow
202
0
students to use the Student version. The Student
203
0
version is for use only by instructors and students in a
204
0
specific university, school, or department covered by the
205
0
license. To purchase a Student license, contact
206
0
TreePlan Software via www.treeplan.com.
207
208
DoTermForm
0
209
0
TREEPLAN PURCHASE (by web using credit card)
HelpLinePurchase
210
0
211
0
You can purchase with VISA, MasterCard, American
212
0
Express, or Discover credit card from our order-processing
213
0
service, SWReg.
214
0
215
0
To start, browse to the "Buy Now" page at
216
0
www.treeplan.com.
217
0
218
0
On SWReg's secure web pages, you enter quantity and
219
0
billing/shipping addresses. For payment,
220
0
(a) you enter your credit card information securely, or
221
0
(b) you may purchase by fax or phone
222
0
without placing your credit card number on the internet.
223
0
224
0
After your purchase, SWReg will send you a confirmation
225
email with a download link for the software.
226
DoRollbackForm
0
227
0
If you have any questions about the status of your purchase
228
0
or about refunds, contact us at [email protected].
229
0
230
0
You may contact us by postal mail at
231
0
232
0
TreePlan Software
233
0
2105 Buchanan St, Apt 1
234
0
San Francisco, CA 94115
235
236
RollbackDec
0
237
0
WARRANTY
238
0
239
0
Users of TreePlan must accept this disclaimer of warranty:
240
0
TreePlan copyrighted software and documentation are
241
0
provided on an 'as is' basis. The author and Decision
242
0
Support Services disclaim all warranties, expressed or
243
0
implied, including, without limitation, the warranties of
244
0
merchantability and of fitness for any purpose. The user
245
0
assumes all risks as to the quality and performance of this
246
0
software and documentation. The author and Decision
247
0
Support Services assume no liability for indirect,
248
0
consequential, or incidental damages which may result from
249
0
the use or misuse of TreePlan. Some states do not allow
250
0
the exclusion of the limit of liability for consequential or
251
0
incidental damages, so the above limitation may not apply
252
0
to you. This agreement shall be governed by the laws of the
253
0
State of California and shall inure to the benefit of the author
254
0
and TreePlan Software and any successors,
255
0
administrators, heirs, and assigns. Any action or
256
0
proceeding brought by either party against the other arising
257
out of or related to this agreement shall be brought only in a
258
RollbackEvent
0
state or federal court of competent jurisdiction located in the
259
0
city and county of San Francisco, California. The parties
260
0
hereby consent to in personam jurisdiction of said courts.
261
0
262
0
263
0
ACKNOWLEDGMENT
264
0
265
0
Jim Smith CB fix, email 20020426
Sincere thanks to Professor James E. Smith, Duke
266
0
University, for adding exponential utility and several
267
0
other features.
268
0
269
0
270
0
AUTHOR INFORMATION
271
0
272
0
Please send comments about TreePlan and suggestions
273
0
for improvements to:
274
0
275
0
Michael R. Middleton
276
0
TreePlan Software
277
0
2105 Buchanan St, Apt 1
278
0
San Francisco, CA 94115
279
280
RollbackTerm
0
Mobile: 415-310-7190
281
0
282
0
283
0
284
0
TreePlan for Excel 1.79
285
0
Copyright 2011
286
Michael R. Middleton
287
tMain
tMain (Ctrl + t)
Avoid conflict with Solver Main 97FEB20
All Rights Reserved
288
0
0
19990804
Code last modified by Jim Smith November 23, 1994
0
Avoid error when no workbook is open.
Saved as international macro April 9, 1996
0
Added Print_Area and HelpOffset July 15, 1996
0
Changed exponential utility; added formats July 27, 1996
0
XL7 calc fix and web site (1.56) Sep. 8, 1996
0
XL7 global = replace calc fix (1.57) Sep. 23, 1996
0
XL8, Office 97, closed polygon, 1.58 November, 1996
0
Solver Main fix of menu command, 1.59 1997FEB20
0
2008 02 10 too many objects selected
Try to avoid distorted triangles in XL97, 1.60 1997FEB21
0
more than 1024 characters
Replace triangle with vertical line, 1.61 1997FEB22
0
Digibuy; drop XL4; detect no sheet, 1.62 20000131
0
Win/Mac dialogs, 1.63 20020405
0
20091124 1.74
Change >=5 to >=5; Jim Smith CB fix; 1.64 20020427
0
VBA menu code; 1.70 20060330
0
20080209, 1.71, triangle, select, alternative, outcome
0
20080505, 1.72, persistent Print_Area, revised watermarks
0
20090313, 1.73, magnification, calculation
0
20101230 1.77
20091124, 1.74 prerelease, square, circle, 2010 shapes
0
Win/Mac Difference
20100113, 1.74, delete only tree objects before redraw
0
20101230 1.77
20101230, 1.77, Mac Excel 2011 & Win, TreePlan Software
DataResult
TreeData
20110609, 1.78, VBA for non-English formulas
DiagResult
TreeDiagram
20110805, 1.79, bug fix in VBA terminal formulas
BaseResult
TreeDiagBase
0
0
0
0
0
0
0
0
''=SET.NAME("ObjectType",GET.OBJECT(1))
''=ALERT("tMain XLM code, ObjectType "&ObjectType)
''=ALERT("tMain XLM code, Selection "&SELECTION())
''=ALERT("tMain XLM code, Active.Cell "&ACTIVE.CELL())
0
0
0
0
''= ALERT("just before ProcessCell is called from tMain")
0
0
''= ALERT("just before ProcessObject is called from tMain")
0
0
0
0
0
ProcessNew
0
0
0
0
NewBoxResult
1
0
0
0
0
0
0
BuildNewTree
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20110609 1.78
0
0
0
0
ProcessCell
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessNode
0
0
0
0
0
0
0
0
ProcessDecision
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessEvent
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessTerminal
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ShowDecBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ResDecBox
13
0
0
0
0
0
0
0
0
ShowEveBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ResEveBox
11
0
0
0
0
0
0
0
0
ShowTermBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ResTerBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessField
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessColumn
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilFromTerm
0
0
0
0
0
0
0
0
0
20080208
0
20080208
0
0
0
0
0
0
0
0
0
0
0
0
0
UpdateData
0
0
2009 03 14 1.73
0
2009 03 14 1.73
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2009 03 14 1.73
0
ProcessObject
0
0
0
0
20080209, added ObjectType=30
''=ALERT("ProcessObject XLM code "&ObjectType)
0
Added type 10, 23NOV96,
0
to detect terminal node object;
0
not needed if it's a line
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2008 02 11 change -1 to -2
0
0
0
0
0
0
0
0
0
0
0
ProcessLine
0
0
0
0
0
0
0
0
0
0
0
UtilAdd
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilPaste
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TotalNumSuc
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilInsert
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilToDec
0
0
0
0
0
UtilToEvent
0
0
0
0
0
UtilToTerm
0
0
0
0
0
0
0
0
0
0
0
UtilSearch
0
0
0
0
UtilDelete
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilClearHigh
0
0
0
0
UtilShorten
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
UtilRemove
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
LoopSelBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
DoSelection
0
0
0
0
0
MakeCelSel
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MakeObjSel
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MakeColSel
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ShowHelpBox
0
0
0
0
0
0
''=SET.NAME("NoTreePlanCommand",ISNA(GET.BAR(1,6,"Decision Tree&...")))
Changed "Options" to 6, 96NOV26;
''=IF(NoTreePlanCommand)
changed TreePlan to Decision Tree, 97FEB13
''= ADD.COMMAND(1,6,TreePlanMenu)
Changed "Options" to 6, 96NOV05
''=ELSE()
''= ALERT("Decision Tree command already exists on Tools menu.",2)
2000-01-26, not needed with VBA menu item
''=END.IF()
Auto_Open
'=SET.NAME("IsMac",LEFT(GET.WORKSPACE(1),1)="M")
New Auto_Open entry point 20060328
'=ERROR(FALSE)
'=IF(IsMac)
Auto_Open defined name deleted for 1.76
'= COPY(XYWHDecMac,XYWHDec)
Use only 1.73 on Mac Excel 2004
'= COPY(XYWHEveMac,XYWHEve)
2010 08 17
'= COPY(XYWHHelMac,XYWHHel)
'= COPY(XYWHSelMac,XYWHSel)
This section could be deleted.
'= COPY(XYWHTerMac,XYWHTer)
'= COPY(XYWHOptMac,XYWHOpt)
'= COPY(XYWHPurMac,XYWHPur)
'= SET.NAME("ColWidNode",1)
'= SET.NAME("ColWidDiag",2)
'=ELSE()
'= COPY(XYWHDecWin,XYWHDec)
'= COPY(XYWHEveWin,XYWHEve)
'= COPY(XYWHHelWin,XYWHHel)
'= COPY(XYWHSelWin,XYWHSel)
'= COPY(XYWHTerWin,XYWHTer)
'= COPY(XYWHOptWin,XYWHOpt)
'= COPY(XYWHPurWin,XYWHPur)
'= SET.NAME("ColWidNode",1.57)
'= SET.NAME("ColWidDiag",3)
'=END.IF()
'=ERROR(TRUE)
'=RETURN()
ShowOptionsBox
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ProcessPurchase
0
0
0
PurchaseBoxResult
0
0
0
0
0
0
0
WatermarkBranding
0
2008 05 05
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
MacDialogBoxes
0
0
0
0
0
0
0
0
0
0
0
0