ࡱ> CS  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FP<%D@3Workbookz_VBA_PROJECT_CUR"ur%P<%VBAur%%  !"#$%&'()*+,-./123456789:;<=?@BCDEFGHIJKLMNOPQRSTUVXYZ]^_`abcdefghijklmnopqrtuwxyz{|}~Q?CountcPredcProbcRow cStagecSuc1cSuc2 cSuc3 cSuc4 cSuc5CurColCurNode  CurObjLine 337cValue DataResult: DecCancel% DecisionBox;Tc DecOK DecOptions DecSelect! DefDiagName:S# DefineColNums: DiagResult: DimDecAdd:W DimDecCop:X DimDecEve:[ DimDecIns:Z DimDecRem:^ DimDecSel:a DimDecSho:\ DimDecTer:] DimEveAdd:E DimEveRem:L DimEveSel:O DimEveSho:JDimSelEU: DimTerGro:) DimTerOpt:* DimTerPas:' DimTerRem:( DimTerSel:2Done" DoNodeRowCol:$DoRollbackForm:! DoSelection: DoTermForm:DrawTree:n# EndPointCellR8C10 EveCancel" EventBox;BQ EveOK EveOptions EveSelect" ExcelVersion8.0e" FirstNotMark:9%FirstSucNotMark:L"FirstTerminalNode) FirstTriangle Drawing 12FormColFormRow$ FormText =R[-1]C[2]! \pMichael R Middleton Ba= ThisWorkbook7=58X@"1.Times New Roman1* MS Sans Serif1* MS Sans Serif1* MS Sans Serif1* MS Sans Serif1.Times New Roman1.Times New Roman1Arial1Arial1.Times New Roman1.Times New Roman"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)*%"+""$"#,##0.00;"-""$"#,##0.00;"$"0.00!"+""$"#,##0;"-""$"#,##0;"$"0                 ( &       ( )8 )   @@  @  P @  @   P   P@  P    PP         @@  @  P @  @  P@  P # # !  (    @@  @   @  @    @   ( ( (    (   @     P 2` 8nEmptyBo T170_2006# MinimizeCosts#TreeData# TreeDiagBase# TreeDiagram# UseExpUtility. ActiveCell[Book2]Sheet1!R8C6 ActiveNode eAlertStringbDecision Tree command already exists on Options menu (Excel 4) or Tools menu (Excel 5, 7, and 97).# AllImmSucMark:CAllMark AllObjects AllSucMark : BaseNode  BaseResult:BoxTest: " BuildNewTree: BuildTree:cCol cIDcKind ClearTree:] cListcMarkcNamecNumSuc ColPerStage ColWidDiag" ColWidNodeHelpBox;fh HelpLine&HelpLineDecision:7! HelpLineNew:%HelpLineOptions:&HelpLinePurchase:$HelpLineSelect:q&HelpLineTerminal:^ HelpOffset" HelpText;Highi" InitHelpItem:g IsBranch IsCEField IsConnector IsDiagonalIsEduc IsEUField IsEVCEField IsEVFieldIsMac IsNameFieldIsNodeIsPred IsProbField IsTermFieldIsTryout'IsUnprotectedWorksheet IsValueFieldjk LastUsedNodeLevel LineWeight LoopSelBox:zLow MakeCelSel: MakeColSel: MakeObjSel: MaxNodeCol MaxNodeRow  NewBox;9< " NewBoxResult:! NewData;&4NewNode NewNumSucc"NoTreePlanCommand NumNewNodes ObjectCellR3C6 ObjectType $ OptionsBox;kw OptsBox OptsCancel OptsChangedOptsOK OptsSelBox OptsSelectPredNode  ;x ! ProcessCell:+# ProcessColumn:'%ProcessDecision:f" ProcessEvent:|" ProcessField:! ProcessLine: ProcessNew:! ProcessNode:]# ProcessObject:`%ProcessPurchase:`%ProcessTerminal:% PurchaseBox;z 'PurchaseBoxResult:c  ;RelCol  RelTermCol  ResDecBox: ResDecBut:V  ResEveBox: ResEveBut:D  ResOptBut:m " ResOptExpBut:m " ResOptMinBut:q  ResSelBox ResSelBut:  ResTerBox: ResTerBut:$  ResTerNum:* ! RollbackDec:# RollbackEvent:" RollbackTerm: RowPerTerm SelCancelSelCol# SelectBox;  SelectedNodeSelOKSelOptsfPSelTextMR[21]C[0],R[14]C[4],R[29]C[4],R[4]C[8],R[9]C[8],R[14]C[8],R[19]C[8],R[24]C[8]" SetColWidths:e% SetSeedMenu;! SheetNameSheet2 ShowDecBox: ShowEveBox:! ShowHelpBox:$ShowOptionsBox:%! ShowTermBox: SubtreeNodeSucNode TerCancel% TerminalBox;"4  TermRowNumTerOK TerOptions TerSelect,TestCell[Book2]Sheet1!R8C6! TestCellRefR3C6tMain:! TotalNumSuc:TreePlanEducFoot& TreePlanMenu=57%TreePlanTryoutHeadFoot UpdateData:PURowUtilAdd:# UtilClearHigh:K UtilDelete:&" UtilFromTerm:9 UtilInsert: UtilPaste: UtilRemove:b UtilSearch:!! UtilShorten:Q UtilToDec: ! UtilToEvent: UtilToTerm:'WatermarkBranding:k! XYWHDec;Tc $ XYWHDecMac;Tc #$ XYWHDecWin;Tc! XYWHEve;BQ $ XYWHEveMac;BQ #$ XYWHEveWin;BQ! XYWHHel;fh $ XYWHHelMac;fh #$ XYWHHelWin;fh! XYWHOpt;kw $ XYWHOptMac;kw #$ XYWHOptWin;kw! XYWHPur;z $ XYWHPurMac;z #$ XYWHPurWin;z! XYWHSel; $ XYWHSelMac; #$ XYWHSelWin;! XYWHTer;"4 $ XYWHTerMac;"4 #$ XYWHTerWin;"4 y BuildTreeBuildTree (formerly Ctrl + b)itemxywidthheighttext init/resultnamesHelpText HelpLineNewRenumber T after editing help.NewDataIDNameValueProbPredKindNSS1S2S3S4S5RowColMark SelectBox (Arial 10)Locate entry lines in S.*Select the cell with text "VersionStrings" XYWHSelWin XYWHSelMactMainTreePlanD ResSelBut (CW 28.33)Decision Tree SoftwareSelect S and T. Decision 1T Branch namesCreate Names (left column).CClear contents of this column (optional to reduce add-in file size) Decision 2Partial cash flowsChoose Tools | Make Add-In ProbabilitiesRollback EVs/CEs:TreePlan helps you build and modify decision tree diagramsVersionStrings20000104DimSelEU Rollback EUs:in Excel worksheets. TreePlan automatically puts formulasTerminal values-on your worksheet for evaluating these trees.Decision nodes Event nodes<To build a new decision tree, first create a new worksheet. Terminal nodes'Then start TreePlan in one of two ways: Branch lines(Restrict XL7 recalc fix to tree, 96NOV26Diagonal lines4(1) Choose Decision Tree... from the Tools menu, orFixes XL7 recalc bug ConnectorsNodes Diagonals2When the TreePlan...New dialog box appears, choose Left branches9New Tree. TreePlan builds a tree diagram with an initial DefineColNumsRight branches8decision node and two branches. The tree diagram begins9with the upper left corner of the diagram near the activeCells8cell at the time New... is chosen. TreePlan assigns theObjects5name TreeDiagram to the range of the tree diagram andColumns7initially sets Excel's Print_Area equal to TreeDiagram.OK Options...;To change the structure of the tree diagram, select a node,Cancel3start TreePlan, and choose commands from a TreePlanHelp<dialog box. To select a terminal node in Excel 97 or later,@select the square cell next to the vertical line at the end of aterminal branch.=On the left side of each branch of the tree diagram, there is DoNodeRowCol:a name field above the branch line and a partial-cash-flow6value field below the line. On the left side of event:branches, there is also a probability field above the name TerminalBox>field. Decision nodes also have a number in them indicating XYWHTerWin XYWHTerMacthe optimal branch. ResTerButChange to decision node;On the right side of each branch of the tree diagram, thereChange to event node6is a rollback Expected Value field below the line near DimTerPas Paste subtree7each node. TreePlan automatically puts the rollback EV DimTerRemRemove previous branch5formula into this cell: maximum of successor EVs at a DimTerGroBranches8decision node, and expected value of successor EVs at an DimTerOpt ResTerNum event node.OneTwo9To the right of the terminal nodes, there is an endpoint Three?value field that sums all of the partial cashflows in the tree.FourFive7Internally, TreePlan uses the TreeData range, near cell%GV1000, to construct the TreeDiagram. DimTerSel Select...8CAUTION: Do not insert or delete rows or columns in the8TreeDiagram or TreeData ranges. Modify the tree diagram&only by using TreePlan's menu options.TREEPLAN...DECISION and HelpLineDecisionTREEPLAN...EVENT dialog boxes FirstNotMarkNewBoxNew Tree Add branch3 Adds a single branch after the selected node .+ (No more than 5 branches are allowed.) Copy subtree; Copies the selected node and all its successors to the TreePlan clipboard.EventBoxInsert decision XYWHEveWin XYWHEveMac AllImmSucMark9 Inserts a decision node and single branch before the ResEveBut selected node. DimEveAdd Insert event7 Inserts an event node and single branch before theChange to decision DimEveSho Shorten treeChange to terminal; Changes the selected event node to a decision node andFirstSucNotMark DimEveRem Remove branch; erases the probability fields from the event branches.Change to event DimEveSel9 Changes the selected decision node to an event node.7 Removes the selected node and its single successor DefDiagName branch. DecisionBox XYWHDecWin XYWHDecMac ResDecBut7 Changes the selected node to a terminal node. All DimDecAdd# successor branches are erased. DimDecCop DimDecIns; Erases the selected node, the previous branch, and any DimDecEve" successor branches and nodes. DimDecSho ClearTree DimDecTer DimDecRemTREEPLAN...TERMINAL dialog boxHelpLineTerminal DimDecSel: Changes the selected terminal node to a decision node) with one to five successor branches. SetColWidths8 Changes the selected terminal node to an event nodeHelpBox XYWHHelWin XYWHHelMac InitHelpItemClose< Pastes the subtree onto the selected terminal node from the TreePlan clipboard. OptionsBox XYWHOptWin XYWHOptMacCertainty Equivalents ResOptExpBut7 Erases the selected terminal node and the previousDrawTreeUse Expected Values Use Exponential Utility FunctionDecision Node EV/CE Choices ResOptMinButTREEPLAN...SELECT dialog boxHelpLineSelectMaximize (profits)Minimize (costs)8 To select a set of nonadjacent cells for subsequent6 formatting, select the appropriate option button.8 (In large trees, this option may not be available.): To select all objects, choose Select Special from the PurchaseBoxTreePlan Tryout8 Formula menu, and select the Objects option button. XYWHPurWin XYWHPurMacThank you for trying TreePlan.*Avoid distorted triangles in XL97, 97FEB22*This is a fully functional, tryout version1Added initial vertice to polygon array, 1996NOV05for 15-day evaluation use only.&If you want to continue using TreePlan: To select a set of nonadjacent columns for subsequent$after 15 days, you must purchase the%You can purchase TreePlan by check or)charge card, by mail, phone, or Internet.TREEPLAN...OPTIONS dialog boxHelpLineOptions'Dashed line only when needed, 1997FEB22A The default is to rollback the tree using expected values. Shorter dashed line, 1997FEB22&display this purchase reminder notice.> If you chose to use exponential utilities, TreePlan will > compute utilities and certainty equivalents at each node.(I understand that I may use this version7 For the Maximize option, the rollback formulas are(of TreePlan only for evaluation and that8 U=A-B*EXP(-X/RT) and X=-LN((A-U)/B)*RT, and for the&any other use requires purchase of the) Minimize option, U=A-B*EXP(X/RT) and X=LN((A-U)/B)*RT.I AgreeQuit6 NOTE: TreePlan uses the name RT to represent the8 risk tolerance parameter of the exponential utility4 function; the names A and B determine scaling.> If the names A, B, and RT don't exist, they are initiallyBoxTest (formerly Ctrl + d)4 defined as A=1, B=1, and RT=999999999999. The < name UseExpUtility is a flag indicating whether to use . exponential utilities or expected values.: The default is to Maximize profits. If you choose to< Minimize costs instead, the cash flows are interpreted 5 as costs, and decisions are made by choosing the7 minimum expected value/CE rather than the maximum.3 TreePlan uses the name MinimizeCosts as a flag7 indicating whether to maximize profits or minimize costs.TRYOUT LICENSE9Decision Support Services grants a license to prospective DoTermForm<purchasers to use the Tryout version for a 15-day evaluation0period. You can download the Tryout version from3www.treeplan.com. Please share copies of the Tryout;version freely with prospective purchasers. You are granted7permission to make as many copies of the Tryout version as you wish.=If you want to continue using the software after 15 days, you:Instructors who require their <qstudents to use the software;textbook that has a license or by purchasing a license fromDoRollbackForm5allows you to use one copy of the software on any onecomputer at any one time.:Decision Support Services has granted a license to certain RollbackDec9specific edition. According to such an agreement with the<instructors and students who are using a specific edition of9a textbook covered by the license. Visit www.treeplan.comfor a list of textbooks.<universities, schools, departments, and instructors to allow8version is for use only by instructors and students in a9specific university, school, or department covered by the,TREEPLAN PURCHASE (by web using credit card)HelpLinePurchase RollbackEvent:After you enter quantity and billing/shipping addresses at7www.digibuy.com, you will be connected to DigiBuy's web;sites where (a) you will enter your credit card information8without placing your credit card number on the internet. RollbackTermDecision Support Services2105 Buchanan Street, #1San Francisco, CA 94115tMain (Ctrl + t)'Avoid conflict with Solver Main 97FEB2019990804WARRANTY%Avoid error when no workbook is open.<Users of TreePlan must accept this disclaimer of warranty: 3TreePlan copyrighted software and documentation are6provided on an 'as is' basis. The author and Decision6Support Services disclaim all warranties, expressed or9implied, including, without limitation, the warranties of9merchantability and of fitness for any purpose. The user;assumes all risks as to the quality and performance of this4software and documentation. The author and Decision DataResult3Support Services assume no liability for indirect, DiagResult:consequential, or incidental damages which may result from BaseResult8the use or misuse of TreePlan. Some states do not allow<the exclusion of the limit of liability for consequential or9incidental damages, so the above limitation may not apply Jim Smith CB fix, email 20020426<to you. This agreement shall be governed by the laws of the@State of California and shall inure to the benefit of the author1and Decision Support Services and any successors,3administrators, heirs, and assigns. Any action or <proceeding brought by either party against the other arising>out of or related to this agreement shall be brought only in a?state or federal court of competent jurisdiction located in the:city and county of San Francisco, California. The parties:hereby consent to in personam jurisdiction of said courts.ACKNOWLEDGMENT0Sincere thanks to Professor James E. Smith, Duke6University, for adding exponential utility and several ProcessNewother features.AUTHOR INFORMATION NewBoxResult3Please send comments about TreePlan and suggestionsfor improvements to:Michael R. Middleton BuildNewTreeAll Rights Reserved9Code last modified by Jim Smith November 23, 1994@Saved as international macro April 9, 1996<Added Print_Area and HelpOffset July 15, 19969Changed exponential utility; added formats July 27, 1996 ProcessCell?XL7 calc fix and web site (1.56) Sep. 8, 1996>XL7 global = replace calc fix (1.57) Sep. 23, 1996:XL8, Office 97, closed polygon, 1.58 November, 19968Solver Main fix of menu command, 1.59 1997FEB20<Try to avoid distorted triangles in XL97, 1.60 1997FEB21?Replace triangle with vertical line, 1.61 1997FEB22<Digibuy; drop XL4; detect no sheet, 1.62 20000131AWin/Mac dialogs, 1.63 200204053Change >=5 to >=5; Jim Smith CB fix; 1.64 20020427 ProcessNodeProcessDecision ProcessEventProcessTerminal ShowDecBox ResDecBox ShowEveBox ResEveBox ShowTermBox ResTerBox ProcessField ProcessColumn UtilFromTerm UpdateData ProcessObjectAdded type 10, 23NOV96, to detect terminal node object;not needed if it's a line ProcessLineUtilAdd UtilPaste TotalNumSuc UtilInsert UtilToDec UtilToEvent UtilToTerm UtilSearch UtilDelete UtilClearHigh UtilShorten UtilRemove LoopSelBox DoSelection MakeCelSel MakeObjSel MakeColSel ShowHelpBox Auto_Open Changed "Options" to 6, 96NOV26;*changed TreePlan to Decision Tree, 97FEB13Changed "Options" to 6, 96NOV05 2000-01-26ShowOptionsBoxProcessPurchasePurchaseBoxResultG''=SET.NAME("NoTreePlanCommand",ISNA(GET.BAR(1,6,"Decision Tree&...")))''=IF(NoTreePlanCommand)%''= ADD.COMMAND(1,6,TreePlanMenu) ''=ELSE()F''= ALERT("Decision Tree command already exists on Tools menu.",2) ''=END.IF()"New Auto_Open entry point 200603289Add-In for Microsoft Excel 97 and later versions of Excelfor Windows and Macintosh9After your purchase, Digibuy will send you a confirmation,email with a download link for the software.$You may contact us by postal mail atVoiceMail: 415-673-6217Email: mike@treeplan.comGTreePlan for Excel 1.70Copyright 2006VBA menu code; 1.70 200603302www.treeplan.com for information about purchasing./Decision Support Services via www.treeplan.com.3To start, browse to the "How To Buy It Now" page atwww.treeplan.com.;If you have any questions about the status of your purchase5or about refunds, contact us at support@treeplan.com.8Please download a free User Guide from www.treeplan.com. How To Buy*For purchasing information and Help, clickthe How To Buy button below.0You can purchase with VISA, MasterCard, American:Express, or Discover credit card from our order-processing*service, DigiBuy (Maagnum Internet Group).<securely or (b) you will be able to purchase by fax or phone<(2) Shortcut key: Hold down Control and Shift and press T.8Edit value of each Boolean Constant, IsTryout and IsEducWatermarkBrandingstandard or Academic version.%Standard and Academic versions do not3must purchase a standard or Academic license. Visit2must obtain an Academic license, either by using aSTANDARD LICENSE7If you have purchased the standard version, the licenseACADEMIC LICENSE:textbook publishers to include the Academic version with a2publisher, the Academic version is for use only by2students to use the Academic version. The Academic1license. To purchase an Academic license, contactTreePlan Tryout - SelectTreePlan Tryout - Terminal NodeTreePlan Tryout - New TreeTreePlan Tryout - Event NodeTreePlan Tryout - Decision NodeTreePlan Tryout - HelpTreePlan Tryout - OptionsDIn Excel 97, choose Tools | Macro | Macros | Run W7 (VersionStrings)- T-.`.h._/Hl/rH0{14112 3.4 /6bZ7 @8s K59h 9 ;; `; _/<a=;>n?:?w@3ZAABABDM0EceFH7"IUJ TL<M ܃0\w#0,>ڬp08ם0p004 xBV}VQxBV}VS]0xBVV}V%0a0~Z:D)<0Mstudents to use the software;textbook that has a license or by purchasing a license fromDoRollbackForm5allows you to use one copy of the software on any onecomputer at any one time.:Decision Support Services has granted a license to certain RollbackDec9specific edition. According to such an agreement with the<instructors and students who are  n  dMbP?_*+%"`T0??U>@ Sheet1 @ t`"1#*4yBNYgpz?ңCKE3& 1X;hG+QYcnwx  dMbP?_*+%&L&F &A&R &T &D&?'?(?)?MHP LaserJet 2100 PCL64C odXXLetterDINU"4O "dhh??U} } *7?} U} } } } U} } *} U} } } U} *} U} *} 1} *}  } U }  } U } U} U} } *} } U} !U} ""} ##*} $%U } &&} ''} ((} )+} ,,} -1} 22U} 33} 44} 5U 55T0@ 5@5@5@54@5@5@5@5@ 5@n 5?@ 5ZA@ 5B@ 50E@c5H@7 5J@ $M@$@$@$@PG$@$@$@PG$@$@$@$@"$Tw@$@$@$Tw@$@  ?           3 ~ ?        ! " # % & ' ( ) * + , - . / 0 1 2 3 4?BW  @d@    ~ @    ! @d@ "  !"@e@#~ & '$(* +%*,@?@1 2!!!4?* #.B~ &@ ~  0@  &~  0@ ' (~ @ )  #~ &? '*(* ++*,1 2!!!4?* #CB(@.@4@   , ~  1@ ~ @ - ..@4@  .@4@Bg@"#~ &@ '/(* ++*,1 2!!!4?* #-B~ (@  0 ~  2@ ~ @ 1  !~ "Bg@#?* #B~ (@  2 ~  3@~ @   !~ "Bg@#?* #GB~ (@  3 ~  4@ 4~ @ 5 '6  !~ "Bg@#?* #FB 7~ j@  8 ~  5@ 9~  @'IsTryoutBX  !~ "Bg@#?* #DB~ (@  : ~  6@ ;~ "@% IsEducBX  !~ "Bg@#   #B~ !sA (@j@4@  < ~ 7@ ~ $@(  #q#gB$B j@4@  l@4@Be@" #+ ?  SubtreeNodeBX~ (@  = ~ 8@ >~ &@L  6@(IsTryout and IsEduc cannot both be TRUE.Bv  !~ "Be@ #O ? 999CBN"NBm~ (@  ? ~ 9@ @~ (@  @B7  !~ "Be@ # ? B.~ (@  A ~ :@ ~ *@  A  !~ "Be@ #! ?  9Bm B~ (@  C ~ ;@ D~ ,@  CqB  !~ "Be@ #*?==B E~ (@  F ~  <@ ~ .@H2ATreePlan Tryout - Select#"NB`  !~ "Be@#i?S99CCBN9CCBN"NBBm(@@x@4@   G ~  =@~ 0@O9ATreePlan Tryout - Terminal Node#"NB`@x@4@  z@4@Be@"#?B7~ (@  H ~  >@ I~ 1@J4ATreePlan Tryout - New Tree#"NB`  !~ "Be@#~ (@  J ~  ?@ K~ 2@L6ATreePlan Tryout - Event Node#J"NB`  !~ "Be@# L'? cIDBX~ (@  M ~  @@ N~ 3@O9ATreePlan Tryout - Decision Node#)"NB`  !~ "Be@#)? cNameBX~ (@  : ~  @@ O~ 4@F0ATreePlan Tryout - Help#V"NB`  !~ "Be@#*? cValueBX$,@@@@f@]@  P ~  A@ Q~ 5@I3ATreePlan Tryout - Options#"NB`@@@f@]@ @@h@_@#)? cProbBX$,@i@@@d@]@  R ~  A@ S~ 6@H2ATreePlan Tryout - Select#"NB`i@@@d@]@ k@@f@_@#)? cPredBX$,@w@@`d@Y@  T ~  B@ U~ 7@Aw@@`d@Y@ @z@@f@[@#)? cKindBX?&@@`@V@   V ~  B@~ 8@ CgB&@@`@V@ &@a@V@"#!+? cNumSucBX@^@@`@V@   W ~  C@ X~ 9@G1ATreePlan Acad. - Select#"NB`^@@`@V@ `f@a@V@"#!)? cSuc1BX@ m@@`@V@   Y ~  C@ Z~ :@N8ATreePlan Acad. - Terminal Node#"NB` m@@`@V@ u@a@V@"#!(? cRow BX"@#|@$@`@$V@ #  #[ %~  D@ \~ ;@I3ATreePlan Acad. - New Tree#"NB`#|@$@`@$V@# #@a@$V@"##!(? cCol BX~  D@ ]~ <@K5ATreePlan Acad. - Event Node#J"NB`!)? cMarkBX ~  E@ ^~ =@N8ATreePlan Acad. - Decision Node#)"NB`?B7 ~  E@~ >@E/ATreePlan Acad. - Help#V"NB` ~  F@ _~ ?@H2ATreePlan Acad. - Options#"NB` `?BW~  F@ a~ @@G 1ATreePlan Acad. - Select#"NB`#D$l:g"r&)'>C= $T0@!$@ "$@#$@$$4@%$@&$@'$@($@)$@n*$?@+$ZA@,$B@-$0E@c.$H@7 /$J@ 0$M@1$@2$@3$@PG4$@ 5$@6$@PG7$@8$@"9$@:$@;$Tw@<$@ =$@>$Tw@?$@7 ? !9C"NBa~ G@ b~ @@ !A  #/!?!  ColPerStageBX ! ! ! ! !  !  !  !  ~ ! G@ !c~ !A@.!"CgA&CqA&B$B ! ! ! ! !  !! !" !#*"?" CurColBX "d ""`v@c@ " " ~ " H@ "e~ "A@A"#+ATreePlan - Select#"NB` "f ""`v@c@ "g " !""t@@e@#.#?#  RowPerTermBX$#,@$@@l@V@ #  ~ # H@ #h~ #B@H#$2ATreePlan - Terminal Node#"NB`#$@@l@V@# $@@@j@W@#4$?$  TermRowNumBX~ $[@$ ~ $ @ $ i~ $ I@$~ $B@C$%-ATreePlan - New Tree#"NB`$$ #E%?%/ CurNode9C"NBX~ %(@% % j~ % ?~ % I@ %k~ %C@E%&/ATreePlan - Event Node#J"NB`% % !~ %"B`h@%#'&?& DoneBX~ &(@& & l~ & ?~ & J@ &m~ &C@H&'2ATreePlan - Decision Node#)"NB`& & !~ &"B`h@&#!'?' CBA&A 'n~ 'j@' ' o~ ' ?~ ' J@ 'p~ 'D@?'()ATreePlan - Help#V"NB`' ' !~ '"B`h@'#4(?(@ AllSucMark#"BX (q~ ((@( ( r~ ( ?~ ( K@ (s~ (D@B(),ATreePlan - Options#"NB`( ( !~ ("B`h@(#0)?)@#C$ B$B )t$)j@o@@@V@@Z@ ) u~ ) ?~ ) K@ )v~ )E@A)*+ATreePlan - Select#"NB`)o@@@V@@Z@) l@@T@\@#+*?* @DoneBX *w~ *`j@* ~ * @ * x~ * L@ *y~ *E@*+A** #=+?+'A9C$CBNT A~ +(@+ + z+ ~ + L@+~ +F@+,B7++ #>,?-(AC#9C$C"NB`~ ,(@, , {, ~ , M@ ,|~ ,F@,, #:-?.$ @ TermRowNumCCBX~ -(@- - }- ~ - M@ -~~ -G@-- #>.?/(AC9C$C"NB`~ .(@. . . ~ . N@.~ .G@.. #;/?0%A9C$C"NB`~ /(@/ / / ~ / N@ /~ /H@// #K0?15 @CurNode9C$C"NBX0?(@X@V@0  0 V0 ~ 0 O@ 0~ 0H@0(@X@V@00 (@\@V@"0#61?2  @CurColC#CBX1@(@@_@V@1  1 Y1 ~ 1 O@1~ 1I@1(@@_@V@11 (@a@V@"1#"2?3 @CA 22@p@@_@V@2  2 2 ~ 2 P@ 2~ 2I@2p@@_@V@22 k@a@V@"2#>3?4(AC#9C$C"NB`3@`@X@V@3  3 W3 ~ 3 @P@ 3~ 3J@3`@X@V@33 @]@\@V@"3#4?5A99C$CBNCBN99C$C9C$CBNBNCBNA9C$C"NB`4"@#`@#@_@#V@4 # 4 #[4 %~ 4 P@ 4~ 4J@4#`@#@_@#V@4#4 #@]@#a@#V@"4##;5?6%A9C$C"NB`~ 5 P@5~ 5K@K6?75 @CurNode9C$C"NBX~ 6 Q@6~ 6K@67?8  @CurColC#CBX7 ~ 7 @Q@ 7 71~ 7L@8?9@A 8 8 8 8 8  8  8  8  ~ 8 Q@ 8~ 8L@ 9#9?@: @#PB 9 99t@B@ 9 9 ~ 9 Q@9~ 9M@1:?; @CurNode#OBX:?$@@V@:  : : ~ : R@ :~ :M@6;?<  @CurColC#CBX;@]@@V@;  ; Y; ~ ; @R@ ;~ ;N@<?=@A<"@#k@#@#V@< # < #[< %~ < R@ <~ <N@=?>A~ = R@=~ =O@>??99CBNCBN99C9CBNBNCBNA9C"NB`~ > S@ >~ >O@>>#9??@#9C"NB`~ ? @S@ ?~ ?P@??#DzloM"0*9 ~eu|C@$T0@A$@ B$@C$@D$4@E$@F$@G$@H$@I$@nJ$?@K$ZA@L$B@M$0E@cN$H@7 O$J@ P$M@Q$@ R$@S$@PgT$@U$@V$@PGW$@X$@Y$@Z$@[$Tw@\$@]$@^$Tw@_$G>@?A(C#9C$C"NB`~ @ S@ @~ @@P@@@#A?CB7 A A A A A  A  A  A  ~ A S@A~ AP@ A A A A A  A! A" A# B BBt@`d@ B B ~ B T@ B~ BP@ B BBt@`d@ B B !B"s@f@# CC?DB`$C,@,@@g@ c@ C  ~ C @T@ C~ CQ@C,@@g@ c@C ,@@e@@e@#*D?E AllMarkBX~ D&@D ~ D ? D ~ D T@ D~ D@Q@DD #@E?F*i9C$CBNB E~ E(@E E E ~ E T@E~ EQ@E E !~ E"Bb@E#XF?GBA99C$CCaBNCBNA&B~ F(@F F F ~ F U@ F~ FQ@F F !~ F"Bb@F#.G?H @AllMarkBX~ G(@G G G ~ G @U@ G~ GR@G G !~ G"Bb@G#H?I@A~ H(@H H H ~ H U@ H~ H@R@H H !~ H"Bb@H#I?JA~ I(@I I I ~ I U@I~ IR@I I !~ I"Bb@I#J?L #B7 J~ Jj@J J J ~ J V@ J~ JR@J J !~ J"Bb@J#~ K(@K K K ~ K @V@ K~ KS@K K !~ K"Bb@K# LL?MB` L~ L(@L L L ~ L V@ L~ L@S@L L !~ L"Bb@L#%M?N iBXM?k@"@V@M  M VM ~ M V@M~ MS@Mk@"@V@MM i@"@V@"M#TN?O>99C$CCaBNCBNAN@k@C@V@N  N YN ~ N W@ N~ NS@Nk@C@V@NN i@C@V@"N#/O?P @iCaBX OO@k@@Q@V@O  O O ~ O @W@ O~ OT@Ok@@Q@V@OO i@@Q@V@"O#P?QAP@k@X@V@P  P WP ~ P W@P~ P@T@Pk@X@V@PP i@X@V@"P#?Q?S)9C$CCa"NB7Q"@#k@# `@#V@Q # Q #[Q %~ Q W@ Q~ QT@QQ#k@# `@#V@Q#QQ i@# `@#V@"Q##~ R X@ R~ RT@RR# S!S?T B S S S S S  S  S  S  ~ S @X@ S~ SU@ S S S S S  S! S" S#ST?U=  MaxNodeRow9C9AL"NBBX T T788T8t@8`d@ T 8T 9~ T X@T~ T@U@ T T88T8t@8`d@ T T 88!T"8s@8f@#SU?V=  MaxNodeCol9C9AL"NBBX$U:,@,@@g@ c@ U ; ~ U X@ U~ UU@U,@@g@ c@U ,@@e@@e@##V?W CN B~ V:&@V ~ V ;? V ~ V Y@ V~ VU@VV #W?XAYF'C '!TreeDiagram9CC~"NB=I'C '!TreeDiagram9CC~"NB=B W~ W:(@W W W ;~ W @Y@ W~ WV@W W !~ W"Bb@W#X?YA X~ X:j@X X X ;~ X Y@X~ X@V@X X !~ X"Bb@X#Y?ZAY9 TreeDiagram9CC~"NB=< TreeDiagram9CC~"NB=B~ Y:(@Y Y Y ;~ Y Y@ Y~ YV@Y Y !~ Y"Bb@Y#Z?[A Z~ Z:j@Z Z Z ;~ Z Z@ Z~ ZV@Z Z !~ Z"Bb@Z#[?]B7 [~ [:(@[ [ [ ;~ [ @Z@ [~ [W@[ [ !~ ["Bb@[# \~ \:j@\ \ \ ;~ \ Z@\~ \@W@\ \ !~ \"Bb@\# ]]?^BW ]~ ]:j@] ] ] ;~ ] Z@]~ ]W@] ] !~ ]"Bb@]#!^?_ 9Bm ^~ ^:j@^ ^ ^ ;~ ^ [@ ^ ^1~ ^W@^ ^ !~ ^"Bb@^#_?`B4_:?k@"@V@_  _ V_ ;~ _ @[@_~ _X@_k@"@V@__ i@"@V@"_#D;l$R=-a9`$T0@a$@b$@c$@ d$4@e$@ f$@g$@h$@ i$@nj$?@"k$ZA@l$B@m$0E@cn$H@7 o$J@ p$M@q$@r$@s$@PGt$@u$@v$@PGw$@ x$@y$@ z$@{$Tw@|$@}$@~$Tw@$@:`?)Ea$99B  Line 25`:@k@C@V@`  ` Y` ;~ ` [@ `j~ `@X@`k@C@V@`` i@C@V@"`#a?b B aa:@k@@Q@V@a  a a ;~ a [@ a~ aX@ak@@Q@V@aa i@@Q@V@"a#b?cB4b:@k@X@V@b  b Wb ;~ b \@ b~ bX@bk@X@V@bb i@X@V@"b#c?eB7c<@=k@ `@=V@c = c =[c >~ c @\@c~ cY@cc=k@ `@=V@c=cc i@ `@=V@"c#=~ d \@ dl~ d@Y@ ee?fBW e e e e e  e  e  e  ~ e \@ e~ eY@ e e e e e  e! e" e#$f?g9B/ f ff@@l@ f f ~ f ]@ f~ fY@ f ff@@l@ f f !f"~@@p@#)g?hiC~Bg$g.@@@~@i@ g  ~ g @b@ g ~ g @]@g~ gZ@g@@~@i@g @@`}@k@#<h?i&AC9Ca"NB/hh"?#i@#i@#V@h # h #h %~ h ]@ ho~ h@Z@h#i@#i@#V@h#h #h@#l@#V@"h##@i?j*AC9Ca"NB/~ i ]@ i~ iZ@j?kA j j j j j  j  j  j  ~ j ^@ j~ jZ@ j j j j j  j! j" j#>k?l(9C~"NB/ k kk0x@b@ k k ~ k @^@k~ k[@ k kk0x@b@ k k !k"t@c@#l?nB70l??,@@@Pw@J@ l l ~ l ^@ lr~ l@[@l@@Pw@J@l @@s@L@#m@@&@m ~ m ? m ~ m ^@ m~ m[@mm # nn?oBWn@@(@n n n ~ n _@ n~ n[@n n !~ n"Br@n#*o?p LineWeightBXo@@(@o o o ~ o @_@o~ o\@o o !~ o"Br@o#/p?qi9ALB~ p@$p,@@N@Pw@J@ p p ~ p _@p~ p@\@p@N@Pw@J@p @P@s@L@#>q?r(A9CaCBND B~ q@~ q&@q ~ q ? q ~ q _@ q q1~ q\@qq #r?)EsA99CaCBN9CaCBN"N99CaCBN9CaCBN"N  B  Rectangle 48~ r@~ r(@r r r ~ r `@r~ r\@r r !~ r"Br@r#!s?t @Bπ~ s @~ s(@s s s ~ s  `@ sP~ s]@s s !~ s"Br@s#,t?u@CxBT*t"@@?@@]@V@t  t Vt ~ t @`@ t~ t@]@t@@]@V@tt @ `@Q@"t#u?v@A*u$@@@Y@@]@V@u  u Yu ~ u ``@ u~ u]@uY@@]@V@uu @V@ `@Q@"u#>v?w(A9CaCBNE B*v&@@@h@@]@V@v  v v ~ v `@ v~ v]@vh@@]@V@vv `e@ `@Q@"v#w?)ExA99CaCBN9CaCBN"N99CaCBN9CaCBN"N  B  Oval 26*w(@ @"@#@r@@]@#V@w # w #[w %~ w `@w~ w^@w#@r@@]@#V@w#w #o@ `@Q@"w##!x?y @Bπx!!!!!!! ~ x `@ xR~ x@^@,y?z@CxBT y y y y y  y  y  y  ~ y `@ y~ y^@ y y y y y  y! y" y#z?{@A z! z+,,z,t@,p@ z ,z -~ z a@ z~ z^@ z z,,z,t@,p@ z z DD!z"Dp@D@z@#>{?|(A9CaCBNT B~ {?{!{@@@ { { { ~ {  a@ {~ {_@{@@ {{ E@E$@E@o@E4@#1|?}@CNBsA! B |~ |@|!|@@4@ | | | ~ | @a@|~ |@_@|@4@ || E@EA@E@o@E4@#}?)E~A  99CaCBN9CaCBN"N99CaCBN9CaCBN"N  `,VB @(@(@(@@ Drawing 4 }~ }@}!}@@@@ } } } ~ } `a@ }T~ }_@}@@@ }} E@EK@E@o@E4@#!~? @ Bπ~ ~@~@@G@ ~ ~ ~ ~ ~ a@ ~~ ~_@~@G@ ~~ E@ET@E@o@E4@#,?@ CxBT~ @@@M@    ~  a@ ~ `@@M@  E@EY@E@o@E4@#DD!l*8n'mg:  $T0@$@$@$@$4@$@$@$@$@$@n$?@$ZA@$B@$0E@c$H@7*$J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@?@A~ @@@Q@   ~ a@~  `@@Q@  E@E^@E@o@E4@#? *EA 99CaCBN9CaCBN"N99CaCBN9CaCBN"N B  Line 4~ @@@U@   ~ a@~ @`@@U@  E@E b@E@o@E4@#!? @ Bπ~  @@@X@   ~ b@  1~ ``@@X@  E@Ed@E@o@E4@#,?@ CxBT~ "@@@@\@   ~  b@~ `@@@\@  E@Eg@E@o@E4@#?@A~ $@@@@_@   ~ @b@ ~ `@@@_@  E@E@j@E@o@E4@#??)A9CaCBNC~B ~ &@@@a@   ~ `b@ ~ `@@a@  E@E`m@E@o@E4@#?*EA 99CaCBN9CaCBN"N 99CaCBNC~"NB  Line 30 ~ (@@@c@   ~ b@ ~ `@@c@  E@Eo@E@o@E4@#*?@ BT~ *@$,@@d@s@O@ ( ~ b@ ~ a@@d@s@O@ E@Eq@Eo@EV@#?@A~ ,@@$@f@   ~ b@ ~  a@$@f@  E.@Eq@E`m@E4@#?@A~ .@@$@g@   ~ b@ 4~ @a@$@g@  E.@Es@E`m@E4@#?,*EA99CaCBN9CaCBN"N99CaCBN9CaCBN"NB  Line 5~ 0@@$@i@   ~ c@ ~ `a@$@i@  E.@EPt@E`m@E4@#,?@CxBT~ 1@@$@j@   ~  c@ 4~ a@$@j@  E.@Eu@E`m@E4@#?<*EA999CaCBNCBN99CaCBNCBN"N 99CaCBN9CaCBN"NB  Line 6~ 2@.?*$@*`m@*V@ * * ~ @c@4~ a@*$@*`m@*V@* E@Ew@ER@E9@#,?@CxBT~ 3@.@*]@*`m@*V@ * * ~ `c@ ~ a@*]@*`m@*V@* EV@Ew@EK@E9@#?rA9CaC"N99CaCBN9CaCBN"NB1~ 4@/@0k@0`m@0V@ 0 0 %~ c@ ~ a@0k@0`m@0V@0 F`c@Ew@F@Z@E9@#T?>A99CaCBNCBNE B~ c@ ~ b@?rA9CaC"N99CaCBN9CaCBN"NB1~ c@ ~  b@?@A &~ c@ ~ @b@? rA9CaC&"N99CaCBN9CaCBN"NB1 #A~ d@ ~ `b@? A B7~  d@ ~ b@<?&A9CBND B~ @d@~ b@?L*EA99CBN9CBN"N99CBN9CBN"N  B  Rectangle 7~ `d@ ~ b@!? @Bπ~ d@ ~ b@,?@CxBT ~ c@?@A  ~  c@<?&A9CBNE B  ~ @c@?d*EA99CBN9CBN"N99CBN9CBN"N  B  Oval 86  ~ `c@!? @Bπ  ~ c@,?@CxBT  ~ c@?@A~ c@?t*E99CBN9CBN"N99CBN9CBN"NB  Line 8~ c@(?CxBT ~ d@DXlPYefOL=\AL9T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@?B7~  d@ ~ @d@ ?BW ~ `d@/?i9ALB ~ d@>?(A9CaCBNT B ~ d@K?5 @FormRow9CaC"NBX ~ d@5? @FormColC~BX ~ d@j?T @FormText =sum(R[1]C[9CaCBNCS]BX ~ e@K?5 @CurNode9CaC"NBX~  e@&?@C$A ~ @e@? @ FormTextCU,R[9C$CBNCT]C[9C$CBNCS]BX ~ `e@K?5 @ CurNode9C$C"NBX ~ e@?@A~ e@7?! @FormTextCU)BX ~ e@S?=A99CaCBNC~"NBm ~ e@#? @CUB` ~ f@?@A ~  f@?A~ @f@?B7~ `f@ ~ f@ ?BW~ f@5?CurNode9ALB ~ f@O?9 @FormRow9C$CBNBX ~ f@O?9 @FormCol9C$CBNBX ~ g@O?9A9C$CBND  #"B~  g@O?9A9C$CBNE  #"B~ @g@O?*9A9C$CBNT  #"B ~ `g@?A~ g@?B7 ~ g@ ~ g@ 0? FormText=maxBX ~ g@??)YFormText=minBXB ~ h@D l6JO^k_gFk9WsC=56FUookko5:^T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@? FormTextCU(R[99C$CBNCBNCT]C[99C$CBNCBNCS]BX  ~  h@@?*i9C$CBNB !~ @h@? @FormTextCU,R[99C$CCaBNCBNCT]C[99C$CCaBNCBNCS]BX "~ `h@?A~ h@3? FormTextCU)BX ~ h@9?#9CTCS"NBm #~ h@? CUB` ~ h@"? R[1]CBm $~ i@u?_YPY=A-B*exp(R[-1]C/RT)B`"=A-B*exp(-R[-1]C/RT)B`"B %~  i@? FormText=if(R[1]C[-1]=R[99C$CBNCBNCT]C[99C$CBNCBNCS],1BX ~ @i@@?*i9C$CBNB ~ `i@? @FormTextCU,if(R[1]C[-1]=R[99C$CCaBNCBNCT]C[99C$CCaBNCBNCS],CaBX~ i@?A~ i@@?*i9C$CBNB & 1'~ i@7?! @FormTextCU)BX~ i@?A ~ j@&? R[-2]C[1]Bm ~  j@? CUB` ~ @j@?B7~ `j@ ~ j@ ((? URowBX ~ j@!? YB~ j@9?#A9CTCS"NBm )~ j@f?P@Y=ln((A-R[1]C)/B)*RTB`"=-ln((A-R[1]C)/B)*RTB`B *~ k@5? @FormRowCTBX +~  k@,? @URowBX ~ @k@?A ,~ `k@? FormText=if(abs(1-sum(R[99C$CBNCBNCT]C[99C$CBNCBNCS]BX~ k@@?*i9C$CBNB ~ k@? @FormTextCU,R[99C$CCaBNCBNCT]C[99C$CCaBNCBNCS]BX ~ k@?A~ k@? FormTextCU))<=0.00001,sum(R[99C$CBNCBNCT]C[99C$CBNCBNCS]*R[BX ~ l@Dl`5SY?B`5nS9F?@V=Y_V9`5T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@? FormTextCU99C$CBNCBNCCT]C[99C$CBNCBNCS]BX ~  l@@?*i9C$CBNB ~ @l@? @FormTextCU,R[99C$CCaBNCBNCT]C[99C$CCaBNCBNCS]*R[BX~ `l@? @FormTextCU99C$CCaBNCBNCCT]C[99C$CCaBNCBNCS]BX ~ l@?A~ l@9?# FormTextCU),na())BX .~ l@9?#9CTCS"NBm /~ l@? CUB` 0~ m@?B7~  m@~ @m@ -I?3 FormText=R[-1]C[C~CS]BX 4~ `m@9?#9CTCS"NBm~ m@? CUB` 6~ m@"? R[1]CBm 7~ m@u?_YPY=A-B*exp(R[-1]C/RT)B`"=A-B*exp(-R[-1]C/RT)B`"B 8~ m@?B7 9~ n@ :~  n@ # ?1 2 ;~ @n@L?6IsUnprotectedWorksheetB BA&B$BX <~ `n@%?CrAA&B '3 =~ n@\?F@8Activate an unprotected worksheet before using TreePlan.Bv 5 ?~ n@?@B7 A~ n@?A C~ n@"? CrA&B D~ o@\?F@8Activate an unprotected worksheet before using TreePlan.Bv E~  o@?@B7 G~ @o@?A H~ `o@?BW I~ o@*? HelpOffsetBX J~ o@ >'?**FTreeDataBz K~ o@ @*?**F TreeDiagramBz L~ o@ B+?**F TreeDiagBaseBz M~ p@Dl`5YY?6wU?B:FlS>9B|>9<JUXT0@@@@4@@@@@ @n ?@ ZA@ B@ 0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@:?$ ExcelVersionreleaseABX N~ p@-? SheetName"BX O~  p@q?[CN ]CB|A~A&B$3 SheetNameCCA ]CB|BtBXB F~ 0p@<?&C AC'AA&C/AA&B$B~ @p@?~ACN ;'C'!TreeDiagBase9"NB=1 TreeDiagBase9"NB=B P~ Pp@?A~ `p@.?C'AC/AB%B Q~ pp@A?*+@Cq #"#"B R~ p@?  !^AiA T~ p@# ?*  @#B ~ p@' ? ,A_BRAA ~ p@# ?*  @#B U~ p@ ? A ~ p@Y ?C@5Select a single cell or object before using TreePlan.Bv W~ p@?A X~ p@?B7~ q@ Y~ q@ S!? #Al .~  q@,? SelectedNodeBX /~ 0q@"? C A 0~ @q@ ? @BW~ Pq@ V"?? @#A ~ `q@ ? @BW ~ pq@8?*"@C  # "B~ q@2?@C B7B~ q@C?-@C #CYC^"B ~ q@?A ~ q@?B7 Y~ q@ [~ q@ Zh?RCN ''C'!TreeDiagBase!^B= TreeDiagBase!^B=B? #B2 \!?  :Bm ]D lZMX5Na??CC5y96OLB<P@TNc9:1 T0@!@"@#@$4@%@&@'@(@)@n*?@+ZA@,B@-0E@c.H@7 /J@ 0M@1@2@3@PG4@5@6@PG7@8@9@:@;Tw@<@=@>Tw@?@$ ?!B5 ^p!?"ZCN +'C '!TreeData;B=!TreeData;B=B !_h"?#RCN ''C'!UseExpUtilityB= UseExpUtilityB=B "ah#?$RCN ''C'!MinimizeCostsB= MinimizeCostsB=B #b$?*% # B $c%?&sCN >'C '!Print_Area='C '!TreeDiagramB=' Print_Area =TreeDiagramB=B %d!&?' 9Bm &5e<'?(&"+"$#,##0.00;"-"$#,##0.00;$0.00B* 'f(3(?)"+"$#,##0;"-"$#,##0;$0B* (g)?+B7 )h *i +`.+?, ActiveCell!^BBX +%,?-IsNodeBX,*-?. IsNameFieldBX-+.?/ IsValueFieldBX.*/?0 IsEVCEFieldBX/(0?1 IsEUFieldBX0*1?2 IsProbFieldBX1*2?3 IsTermFieldBX2'3?4CurNodeBX394?5#CmA&C$9AL B$A4t5?6^ATestCell99C$CBN9C$CBN"NBBX5)6?7@CC B607?8@ ActiveNode#$BX7)8?9@IsNodeBX89?:@A91:?;@CurNodeC$BX:;?<A;<?= CmB<6=@> @ SelectedNodeC$BX=#>?*? @#B>??@A?D l6zz13NO,N38986885G7>7+?'-D1@T0@A@B@C@D4@E@F@G@H@I@nJ?@KZA@LB@M0E@cNH@7 OJ@ PM@Q@R@S@PGT@U@V@PGW@X@Y@Z@[Tw@\@]@^Tw@_@+@?A@CurNodeBX@ZA?BD@#l#s#i#h#o#pB%A&C$9AL B$AA|B?CfATestCell99C$CBN9C$CBN"NBBXBEC?D/@CC  IsNameFieldBXBC|D?EfATestCell99C$CBN9C$CBN"NBBXDFE?F0@CC  IsValueFieldBXBE|F?GfATestCell99C$CBN9C$CBN"NBBXFEG?H/@CC  IsEVCEFieldBXBG|H?IfATestCell99C$CBN9C$CBN"NBBXHCI?J-@CC  IsEUFieldBXBITJ?K>A99C$CBNCBNE BJ|K?LfA TestCell99C$CBN9C$CBN"NBBXKEL?M/@ CC  IsProbFieldBXBLM?N@AM>N?O(A9C$CBNT BNgO?PQA TestCell99C$CBN9AM"NBBXOEP?Q/@ CC  IsTermFieldBXBPQ?R@AQ1R?S@CurNodeC$BXRS?T@ASdT@UN@#l#s#i#h#o#pB%  SelectedNodeC$BXBTxU?VbATestCell99CBN9CBN"NBBXUEV?W/@CC  IsEVCEFieldBXBVxW?XbATestCell99CBN9CBN"NBBXWCX?Y-@CC  IsEUFieldBXBX^Y?*ZH@#l#s#h#i#o#pB% #"#"BYZ?[AZ[?]B7[\ ]j>]?^(9CCBND B]#^?*_ @#B^=_?`'9CCBNE A_Dd l9hSTSQbS+LuS+?+rSQl'( Z1`T0@a@b@c@d4@e@f@g@h@i@nj?@kZA@lB@m0E@cnH@7 oJ@ pM@q@r@s@PGt@u@v@PGw@x@y@z@{Tw@|@}@~Tw@@#`?*a @#B`=a?b'9CCBNT Aa#b?*c @#Bbc?dAcd?fB7de fkf?*g #Bf"g?h C, Bg%h?i@#Alh#i?*j @#yBi7j?k!@C  #E"Bj!k?l C+ Ak#l?*m @#Bl.m?nC* C B$Am1n?o@ SubtreeNode#BXn!o?p C* Ao#p?*q @#Bp#q?*r @#Bq8r?*s"@C  #"BrEs?t/@C C B% #"Bs8t?u"@C  #"Bt8u?v"@C  #"Bu8v?w"@C  #"Bv8w?x"@C  #"Bw#x?*y @# Bxy?zAyz?|B7z{ |l|?*} #B|"}?~ CM B}%~?@#Al~#?* @#yBD l1K1'( ;031E/1<?/11FSFFFF1'( ;03T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@7?*!@C  #E"B!? CL A#?* @#B.?CK C B$A1?@ SubtreeNode#BX!? CK A#?* @#B#?* @#B8?*"@C  #"BE?/@C C B% #"B8?"@C  #"B8?"@C  #"B8?"@C  #"B8?"@C  #"B#?* @# B?A?B7 m?* #B"? C B%?@# Al#?* @#yB7?!@C  #E"B!? C A#?* @#B#?* @#BE?*/@C C B% #"B8?"@C  #"B8?"@C  #"B#?* @# B!? C A#?* @#BD lE/1<?/11FSFFFF1'( ;031E/11SFF1/T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@?A?B7 n#? C B;?%A9CBN B%?@#0 Al%?@#Al?@A%?@#0Al%?@#Al?@A%?@#1Al%?@#3Al?A9CBN 99CBNCBND B$#6 Al#6AlB%?@#7Al%?@#4Al?A=?'A9CCBN B%?@#0 Al%?@#Al?@A%?@#0Al%?@#Al?@A%?@#1 Al%?@#3 Al%?@#2 Al_?IA9CCBN #6 Al#6AlB%?@#7 Al?jA9CCBN 9CBN B$#4Al#4 AlB?A!? #AlD l'( ?I33+33+3333'K33+33+333m3'T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@7?! LastUsedNode9ALBXE?/Cv #5Al#5AlB$?DecOKBX(? DecSelectBX(? DecCancelBX)? DecOptionsBX4?#*#,#(#+B%A&A ? @BW o"? @#)A ? @BW=?'@C DecOKBXB@?*@C  DecCancelBXBA?+@C  DecSelectBXBB?,@C  DecOptionsBXBC?-@C #CXC^"B?A?B7 p=?'9CCBN B%?@#8 Al%?@#Al?A%?@#8Al%?@#Al?A_?I9CCBN #;Al#; AlB?j9CCBN 9CBN B$#9Al#9 AlB!? #Al7?! LastUsedNode9ALBXE?/Cv #:Al#:AlB$?EveOKBX(? EveSelectBXDH lES2667B.>.KNOPQ'( Y33'33'm/ES2T0@@@@4@@@@@@n?@ZA@B@0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@)? EveOptionsBX(? EveCancelBX4?#K#M#I#LB%A&A ? @BW q"? @#JA ? @BW=?'@C EveOKBXBB?,@C  EveOptionsBXB@?*@C  EveCancelBXBA?+@C  EveSelectBXBC?-@C #CXC^"B?A?B7 r#? C B%?@#?Al?A)?@IsPredBX-?@CurNode#BX2?@CnA&C$ B$AV?@A9C$CBNC IsPredBXBC?-ACurNode9C$C"NBX?@AE?/@Cn#?Al#? AlB?A?j9CCBN 9CBN B$#@Al#@ AlB!? #Al!? #Al!? #=Al!? #> Al7?! LastUsedNode9ALBXE?/Cv #AAl#AAlBD2 l76B.>.KPNOQ'( ?3'7;@dQ+S'////ET0@@@@4@@@@@ @n ?@ ZA@ B@ 0E@cH@7 J@ M@@@@PG@@@PG@@@@Tw@@@Tw@@$?TerOKBX(? TerSelectBX(? TerCancelBX)? TerOptionsBX4?####B%A&A ? @BW s"?,@ @#A ? @BW=? '@C TerOKBXB@ ? *@C  TerCancelBXB A ? +@C  TerSelectBXB B ? ,@C  TerOptionsBXB C ? -@C #C]C^"B 4 ?@C C B%B %?@#=Al%?@#> Al?@A%?@#=Al%?@#>Al?@A?A?B7 t7?! LastUsedNode9ALBX#? Cv B9?#@Cl #AlB9?#@Cs #AlB9?#@Co #AlB9?#@Ci #AlB[?E@Ch 1Y#Al#Al"B9? #@Cp #AlBD l2667B.>.KNOPQB33+33+' ( S1GGGGi T0@!@"@#@$4@%@&@'@(@)@n*?@+ZA@,B@-0E@c.H@7 /J@ 0M@1@2@3@PG4@5@6@PG7@8@9@:@;Tw@<@=@>Tw@?@# ?*! @#yB 7!?*"!@C  #E"B!"?#A"O#?$9@+Select a single node before using TreePlan.Bv#$?%A$%?'B7%& 'u7'?(! LastUsedNode9ALBX'#(?) Cv B(F)?*0@C"B 9B 9AM B)%*?+@#Al*+?,@A+N,?-8 @SelColC"B 9B A'BX,:-?.$@C #AlB-:.?/$@C #AlB.:/?0$@C # AlB/:0?1$@C #AlB01?2@A1#2?*3 @#yB273?4!@C  #E"B34?5A4O5?69@+Select a single node before using TreePlan.Bv56?7A67?9B778 9vR9?:<C 'D9CC"NB`B9R:?;<C 'E9CC"NB`B:>;?<(C9CC"NB`;7<?=! LastUsedNode9ALBX<&=?>iCB=3>??@NewNodeCvCaBX>D??@.AC9CCCa"NB`?D) l1E']'( S1T3+\HHHH+1E']'( n`LE4A@T0@A@B@C@D4@E@F@G@H@I@nJ?@KZA@LB@M0E@cNH@7 OJ@ PM@Q@R@S@PGT@U@V@PGW@X@Y@Z@[Tw@\@]@^Tw@_@>@?A(AC9CC"NB`@`A?BJAC 5 Decision C9CC"NB`BA]B?CGAC 2Event C9CC"NB`BB<C?D&A9CC&"NB`CQD?E;AC &9CC"NB`BDWE?FAAC ,C9CC"NB`BE>F?G(AC9CC"NB`F=G?H'AT9CC"NB`G<H?I&A9CC"NB`HI!(I?J@jBIJ!BJ?K,A9CCCt"NB`JK!K?L@AKL?MALM?NCN A'C '!TreeData99ALC"NB=7TreeData99ALC"NB=BMN?PB7NO PwP?QBWP/Q?Ri9ALBQmR?SWA99CaCBN9CaCBN"NB1R9S?T#A9CaC"NBmST?U@B3TmU?VWA99CaCBN9CaCBN"NB1U9V?W#A9CaC&"NBmVW?X@B3WTX?Y>A99CaCBNCBNE BXmY?ZWA99CaCBN9CaCBN"NB1Y9Z?[#A9CaC"NBmZ[?\@B3[\?]@A\]?^A]^?`B7^_D lLnkJ_eLKJ@Z5'( 8={G,{G,b{G,+'(`T0@a@b@c@d4@e@f@g@h@i@nj?@kZA@lB@m0E@cnH@7 oJ@ pM@q@r@s@PGt@u@v@PGw@x@y@z@{Tw@|@}@~Tw@@ `x7`?a! LastUsedNode9ALBX`.a?b ObjectTypeBBXa.b?c ObjectCellBBXb%c?dIsNodeBXcBd?e,C C C C B%B dyd+e?f@CurNodeBX eze4f?g@CmA&C$Cv B$A f{fwg?haA TestCellRef99C$CBN9C$CBN"NBBXgKh?i5@ TestCellRefCCA !CB|BtBXh)i?j@CC Bi0j?k@  ActiveNode#$BXj))k?l@ IsNodeBXk)l?m@Al)1m?n@CurNodeC$BXm)n?o@An)o?pAo)"p?q Cm Bp)6q?r @ SelectedNodeC$BXq)#r?*s @#Br)"s?t C As)4t?u@ EndPointCellBBXt)+u?v@IsBranchBXu)-v?w@ IsDiagonalBXv).w?x@ IsConnectorBXw)+x?y@CurNodeBXx)Dy?z.@CcA&CfA&CeA&C$Cv B$Ay)wz?{aA TestCellRef99C$CBN9C$CBN"NBBXz)K{?|5@ TestCellRefCCA !CB|BtBX{)B|?},@CCH IsBranchBXB|){}?~eA TestCellRef99C$CBN9C$CBN"NBBX})K~?5@ TestCellRefCCA !CB|BtBX~)D?.@CCH  IsDiagonalBXB)Dm lS<<3^GPY7>7+?+'0D10B9;<9RYPYT0@@@@4@&&&&&?&ZA&B&0E&H&J&M&&&&@&&&@&&&&Tw&&&Tw&&>?(A9C$CBNT B&&&&&&& )j?TA  TestCellRef99C$CBN9AM"NBBX&&&&&&& )K?5@  TestCellRefCCA !CB|BtBX&&&&&&& )E?/@ CCH  IsConnectorBXB&&&&&&& )?@A&&&&&&& )1?@CurNodeC$BX)1?@A)1s?]A TestCellRef99CBN9CBN"NBBX)1K?5@ TestCellRefCCA !CB|BtBX)1B?,@CCH IsBranchBXB)1B?*,@#c#f#eB% #"B)1?A  )1?B7  )1 ?  )1 |7?! LastUsedNode9ALBX  )1#? Cv B  )29?#@Cc # AlB  )29?#@Cf # AlB  29?#@Ce # AlB  2#?* @#yB  27?!@C  #E"B  2?A  2O?9@+Select a single node before using TreePlan.Bv  2?A  2?B7  2 ?  2 }J?4 NewNumSucc9CCBNBX  2>?(C9CC"NB`  27?! LastUsedNode9ALBX  2-?NewNodeCvBX  2>?(C9CC"NB`  2D?.C9CCC"NB`  2D4ldqkCgSxnMN,oWmmmWkMMN,rkarT0&&&&4&&&&&&?&ZA&B@&0E@&H@&J@&M@&@&@&@&@@&@&@&@@&@&@&@&Tw@&@&@&Tw@&@&>?(C9CC"NB`  2w?a9CCBND 5 Decision C9CC"NB`B  2t?^9CCBNE 2Event C9CC"NB`B  2<?&9CC&"NB`  2<?&9CC"NB`  2=?'T9CC"NB`  2<?&9CC"NB`  2!$?jB  2!B?,A9CCCt"NB`  2!?A  2?CN ?'C '!TreeData99AL"NB=5TreeData99AL"NB=B  2?B7  2& &2& ~*?BaseNode#BX& &2&1? NumNewNodes#"BX& &2&+?cListBX& &2&7?! LastUsedNode9ALBX& &2&)?NewNode#vBX& &2&?iCvB& 2<?&A9CaCBN B& 21?@NewNodeCBX& 2>?(AC9CaC"NB`& 2?@A&<?&A9CaC"NB`&?@A&?A&>?(C9CC"NB`&T?>9CC"N9CC"NB2&T?>9CC"N9CC"NB2&@?*i9CCBNB&v?`A99CCCaBNC"N9CCCa"NB2&?A&Dlrpfgff[\$`YS_GBXMZ5T51VllXT0@&@&@&@&4@&@&@&@&@&@&?@&ZA@&B@&0E@&H@&J@&M@&@&@&@&@@&@&@&@@&@&@&@&Tw@&@&@&Tw@&@&&?iCvB&<?&A9CaCBN B&=?'Ak9CaC"NBX&>?(ACu9CuC"NB`&T?>A9CaC"N9CuC"NB2&T?>A9CaC&"N9CuC&"NB2&T?>A9CaC"N9CuC"NB2&j?TA99CaCBNC"N9CuC"NB2&T?>A9CaC"N9CuC"NB2&T?>A9CaC"N9CuC"NB2&@?*Aj9CaCBNB&v?`A 99CaCCtBNC"N9CuCCt"NB2?@AD?.Aj9CaCBNBB?,A 9CuCCt"NB`?@A?@A?A?CN A'C '!TreeData99ALC"NB=7TreeData99ALC"NB=B?B7 ?B`7?!9C"NBaC?-CurNode9C C"NBX%?CountBX#? DoneBX!? CBA&A4?@ AllSucMark#"BX2?@#C$C B$B'?@DoneBX"? @CA;?%A9C$C"NB`D l>TUVlllllX+RP++'( 9EQ31/B@50T0@&@&@&@&4@&@&@&@&@&@&?@&ZA@&B@&0E@&H@&J@&M@&@&@&@&@@&@&@&@@&@&@&@&Tw@&@&@&Tw@&@&/?@CountCBXC?-ACurNode9C$C"NBX?@A1?@CurNode#P"BX?@A?A? #B7 7?! LastUsedNode9