ࡱ> p  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F *nqMWorkbook_VBA_PROJECT_CUR"@sXnPXnVBA01vXnڱXn  !"#$%&'()*+,-./013456789:;<=>?ABDEFGHIJKLMNOPQRSTUVWXZ[\_`abcdefghijklmnopqrstuvwxyz{|}~P@  P    PP         @@  @  P @  @  P@  P # # !  (    @@  @   @  @    @   ( ( (    (   @     P  (  ( 2 20% - Accent1 20% - Accent2 20% - Accent3 20% - Accent4 20% - Accent5 20% - Accent6 40% - Accent1 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 60% - Accent1 60% - Accent2 60% - Accent3 60% - Accent4! 60% - Accent5" 60% - Accent6 #Accent1 $Accent2 %Accent3 &Accent4 'Accent5 (Accent6)Bad* Calculation+ Check Cell,-./0Explanatory Text 1Good2 Heading 13 Heading 24 Heading 35 Heading 4 6Input7 Linked Cell 8Neutral 9Note :Output; <Title =Total> Warning Text` Empty TreePlanXLM# MinimizeCosts#TreeData# TreeDiagBase# TreeDiagram# UseExpUtilitya=AcademicNotCommercial:Tr \pMike 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 Roman1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1.Times New Roman1Calibri1Calibri1 Calibri1Calibri1& Courier New"$"#,##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;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.0050_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-*%"+""$"#,##0.00;"-""$"#,##0.00;"$"0.00!"+""$"#,##0;"-""$"#,##0;"$"0                                                                       ff ( &       P  P        `            a>     ( )8 )   @@  @  P @  @   P   eePlan Academic Version, Not Licensed For Commercial Use0 ActiveCell[Book3]Sheet1!R10C14 ActiveCell: ActiveNode eAlertStringbDecision Tree command already exists on Options menu (Excel 4) or Tools menu (Excel 5, 7, and 97).# AllImmSucMark:DAllMark AllObjects AllSucMark :BaseNode BaseResult: BoxTest: " BuildNewTree:/ BuildTree:cCol CellCol:CellRow CellZeroCol CellZeroRowcIDcKind ClearTree:^ cListcMarkcNamecNumSuc ColPerStage ColWidDiag" ColWidNodeQ?CountcPredcProbcRow cStagecSuc1cSuc2 cSuc3 cSuc4 cSuc5CurColCurNode CurObjLine 77cValue DataResult:  DecCancel% DecisionBox;Tc DecOK DecOptions DecSelect! DefDiagName:T# 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:o$ EndPointCellR23C18 EveCancel" EventBox;BQ EveOK EveOptions EveSelect" ExcelVersion8.0e" FirstNotMark::%FirstSucNotMark:M"FirstTerminalNode) FirstTriangle Drawing 12FormCol FormRow $ FormText =R[-1]C[2]! HelpBox;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:Low MakeCelSel: MakeColSel: MakeObjSel: MaxNodeCol  MaxNodeRow Module2.VBA Module2Select.VBAModule3Shape.VBA  NewBox;9< " NewBoxResult:'! NewData;&4NewNode NewNumSucc"NoTreePlanCommand NumNewNodes! ObjectCellR3C10 ObjectType$ OptionsBox;kw OptsBox  OptsCancel OptsChangedOptsOK OptsSelBox OptsSelectPredNode  ;!! ProcessCell:=# ProcessColumn:9%ProcessDecision:x" ProcessEvent:" ProcessField:*! ProcessLine: ProcessNew:#! ProcessNode:o# ProcessObject:r%ProcessPurchase:s%ProcessTerminal:% PurchaseBox;z 'PurchaseBoxResult:v  ;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;  SelectCells SelectColumns SelectedNode SelectShapesSelOKSelOptsXBSelText?Line 51,Line 55,Line 58,Line 62,Line 66,Line 69,Line 72,Line 75" SetColWidths:f% SetSeedMenu;! SheetNameSheet2 ShowDecBox: ShowEveBox:! ShowHelpBox:$ShowOptionsBox:8! ShowTermBox:SUB SubtreeNodeSucNode  TerCancel% TerminalBox;"4  TermRowNumTerOK TerOptions TerSelect.TestCell[Book3]Sheet1!R10C14" TestCellRefR3C10tMain:! TotalNumSuc:3TreePlanEducFootTreePlan Academic& TreePlanMenu=];TreePlanNotLicensed8This Version Not Licensed For Commercial Or Academic UseF!TreePlanTryoutHeadFootTreePlan Tryout For Evaluation TriangleR/TryoutOnlyEvaluation,TreePlan Tryout Version, Only For Evaluation UpdateData:bURowUtilAdd:# UtilClearHigh:^ UtilDelete:9" UtilFromTerm:K UtilInsert: UtilPaste: UtilRemove:u UtilSearch:4! UtilShorten:d UtilToDec:! UtilToEvent:" UtilToTerm:('WatermarkBranding:~! 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  BuildTreeBuildTree (formerly Ctrl + b)itemxywidthheighttext init/resultnamesHelpText HelpLineNewRenumber T after editing help.NewDataIDNameValueProbPredKindNSS1S2S3S4S5RowColMark SelectBox (Arial 10)Locate entry lines in S. XYWHSelWin XYWHSelMactMainTreePlanD ResSelBut (CW 28.33)Decision Tree SoftwareSelect S and T.T Branch namesCreate Names (left column).Partial cash flows 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 andColumnsOK Options...;To change the structure of the tree diagram, select a node,Cancel3start TreePlan, and choose commands from a TreePlanHelp=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, 1996NOV05&If you want to continue using TreePlan: To select a set of nonadjacent columns for subsequent%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 LICENSE DoTermForm0period. 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.:Instructors who require their students 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. 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 credi<t card)HelpLinePurchase RollbackEvent:After you enter quantity and billing/shipping addresses at;sites where (a) you will enter your credit card information8without placing your credit card number on the internet. RollbackTerm2105 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 author3administrators, 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, 96NOV05ShowOptionsBoxProcessPurchasePurchaseBoxResultG''=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 20060328for Windows and Macintosh,email with a download link for the software.$You may contact us by postal mail atVoiceMail: 415-673-6217VBA menu code; 1.70 200603302www.treeplan.com for information about purchasing.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<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, contact Alternative 1 Alternative 2 2008 02 0920080209, added ObjectType=30620080209, 1.71, triangle, select, alternative, outcome2Decision Toolworks grants a license to prospective(Decision Toolworks via www.treeplan.com.3Decision Toolworks has granted a license to certainDecision Toolworks*and Decision Toolworks and any successors,Copyright 2008"Add-In for Microsoft Excel 97-20072dialog box. Do not use Excel's commands to modify;the tree structure or any other cells or graphic objects in$the tree diagram. Only use TreePlan.2008 02 11 change -1 to -2'''=SET.NAME("ObjectType",GET.OBJECT(1))4''=ALERT("tMain XLM code, ObjectType "&ObjectType)8''=ALERT("tMain XLM code, Active.Cell "&ACTIVE.CELL())$2008 02 10 too many objects selectedmore than 1024 characters4''=ALERT("tMain XLM code, Selection "&SELECTION())''= ALERT("just before ProcessCell is called from tMain")''= ALERT("just before ProcessObject is called from tMain")0''=ALERT("ProcessObject XLM code "&ObjectType))2000-01-26, not needed with VBA menu item('' =FORMULA.REPLACE("=","=",2,1,FALSE)'' =SELECT(!TreeDiagram)5In Excel 97, choose Tools | Macro | Macros | W7 | Run2These defined names are used by VBA CreateMenuItem8Set protection in VBE, and save as add-in using Excel 97)Select cell W7 with text "VersionStrings"for 30-day evaluation use only.$after 30 days, you must purchase the<purchasers to use the Tryout version for a 30-day evaluation=If you want to continue using the software after 30 days, youservice, SWReg.7After your purchase, SWReg will send you a confirmation3www.swreg.org, you will be connected to SWReg's web"Email: Mike@DecisionToolworks.com-sets Excel's Print_Area equal to TreeDiagram. 2008 05 05GTreePlan for Excel 1.72920080505, 1.72, persistent Print_Area, revised watermarksTreePlan Acad. - SelectTreePlan Acad. - Terminal NodeTreePlan Acad. - New TreeTreePlan Acad. - Event NodeTreePlan Acad. - Decision NodeTreePlan Acad. - HelpTreePlan Acad. - Options; cD` ?)@3a_@,AB D*E4 E 2F G _H _3IS J'`J,K3LoM=N#`N,OPQESeT9&VFWԸY=9TZt\ .]*2Y^U_tap*c& d3yeu lgh X g  _h[ h PUiQ i tjl ymu3nZpV$~qzr $t fvbw:y6߿0;t0 XYWHTerWinrandingionotink|@|=|OwX-8 045 `T0lmSwH3@jSw`T03lSw`T0USw@lSw-Pw"-Pw#Ժ.PwkSw`T0`T0<;<4܃0\w#04ڬp08ם0p004 X-cX-cS]0X-ˑc%0a0j<<0\t card)HelpLinePurchase RollbackEvent:After you enter quantity and billing/shipping addresses at;sites where (a) you will enter your credit card information8without placing your credit card number on the internet. RollbackTerm2105 Buchanan Street, #1San Francisco, CA 94115tMain (Ctrl + t)'Avoid conflict with Solver Main 97FEB2019990804WARRANTcc||r}-}< 00;"$"0.}A}2 00;"$"0.-@_-_) }A}3 00;"$"0.?-@_-_) }A}4 00;"$"0.23-@_-_) }-}5 00;"$"0.}A}1 a00;"$"0.-@_-_) }A}) 00;"$"0.-@_-_) }A}8 e00;"$"0.-@_-_) }}6 ??v00;"$"0.̙-@_-_)    }}: ???00;"$"0.-@_-_) ??? ??? ??? ???}}* }00;"$"0.-@_-_)    }A}7 }00;"$"0.-@_-_) }}+ 00;"$"0.-@_-_) ??? ??? ??? ???}-}> 00;"$"0.}x}900;"$"0.-@_??? ??? ???}-}0 00;"$"0.}U}= 00;"$"0.-@_ }A}# 00;"$"0.-@_}A} 00;"$"0.ef-@_}A} 00;"$"0.L-@_}A} 00;"$"0.23-@_}A}$ 00;"$"0.-@_}A} 00;"$"0.ef-@_}A} 00;"$"0.L-@_}A} 00;"$"0.23-@_}A}% 00;"$"0.-@_}A} 00;"$"0.ef-@_}A} 00;"$"0.L-@_}A} 00;"$"0.23-@_}A}& 00;"$"0.-@_}A} 00;"$"0.ef-@_}A} 00;"$"0.L-@_}A}  00;"$"0.23-@_}A}' 00;"$"0.-@_}A} 00;"$"0.ef-@_}A} 00;"$"0.L-@_}A}! 00;"$"0.23-@_}A}( 00;"$"0. -@_}A} 00;"$"0.ef -@_}A} 00;"$"0.L -@_}A}" 00;"$"0.23 -@_M 20% - Accent1 ef %M" 20% - Accent2 ef %M& 20% - Accent3 ef %M* 20% - Accent4 ef %M. 20% - Accent5 ef %M2 20% - Accent6  ef %M 40% - Accent1 L %M# 40% - Accent2 L湸 %M' 40% - Accent3 L %M+ 40% - Accent4 L %M/ 40% - Accent5 L %M3 40% - Accent6  Lմ %M 60% - Accent1 23 %M$ 60% - Accent2 23ٗ %M( 60% - Accent3 23֚ %M, 60% - Accent4 23 %M0 60% - Accent5 23 %M4 60% - Accent6  23 %AAccent1 O %A!Accent2 PM %A%Accent3 Y %A)Accent4 d %A-Accent5 K %A1Accent6  F %9Bad  % Calculation  }%  Check Cell  %????????? ??? Comma( Comma [0]&Currency. Currency [0]G5Explanatory Text %;Good  a%G Heading 1 I}%OG Heading 2 I}%?G Heading 3 I}%239 Heading 4 I}%uInput ̙ ??v% K Linked Cell }%ANeutral  e%"Normalb Note  wOutput  ???%????????? ???$Percent1Title I}%MTotal %OO? Warning Text %XTableStyleMedium9PivotStyleLight16B?yr-d    dMbP?_*+%"??@jU>@ Sheet1 @ [-#D3_Mn\ϐ'lpl N&4TBLYbn_xeg]  dMbP?_*+%&L&F &A&R &T &D&?'?(?)?MjHP LaserJet P2015 Series PCL 5C odXXLetterDINU"4XՑ56XIUPHdLetter o [none] [none]Arial4Pd?MIKE MIDDLETON<Automatic>R 44  dSpooler SubSystem Appijkkmmexcel.exeC:\Program Files\Excel 97\Office\excel.exe"XX??U} C} @h} *C} C} C} C} UC} C} *C} UC} C} C} UC} *} UC} *B} Z} *C}  C} U C}  C} U C} UC} UC} C} *C} C} UC} !UC} ""C} ##*C} $%U C} &&C} ''C} ((C} )+C} ,,C} -1C} 22UC} 33C} 44C} 56U C} 77 C} 8U C88T0@ 8@8@8@8@8@8@8@8@ 8@ 8@ 8@PG 8@ 8@8@8@8@8@8@SG8@8@8@T8@SG8@8Pw@PG8@PG8Sw@T 8@8@8@8T0@8@ C h C C C C C C C C C A \ ~ C? C  C C C C C !C "C #C %C &H 'H (H )H *H +H ,H -H .H /H 0H 1H 2H 3H 4H 6pp7hBW C DEEE@Ed@  E F C@~ C@   C EEE@Ed@ C!  EE!"E@Ee@#~ &H 'H#(HHH* +H$*,H@H?H@HHH1 2JJJ4 6pp7h* #4B~ G&@HHHHH ~  I"@  C%~  C0@ C& A'~ C@ C( HHHH HHHH#~ &H? 'H(HHH* +H)*,HHHHHH1 2JJJ4 6pq7h* #IBG(@H.@H4@ HH  H* I~  C1@ A~ C@ C+ ~ zH.@H4@ HH H.@H4@kg@"#H~ &H@ 'H(HHH* +H)*,HHHHHH1 2JJJ4 6pp7h* #3B~ G(@HHHH  H, I~  C2@ A~ C@ HHHH  HH!~ "kg@#H 6pp7h* #B~ G(@HHHH  H- I~  C3@A~ C@ HHHH  HH!~ "kg@#H 6pp7h* #MB~ G(@HHHH  H. I~  C4@ A/~ C@ C0 P1HHHH  HH!~ "kg@#H 6pp7h* #LB C2~ Gj@HHHH  H3 I~  C5@ A4~ C @'CIsTryoutBXHHHH  HH!~ "kg@#H 6pp7h*  #JB~ G(@HHHH  H5 I~  C6@ A6~ C"@%CIsEducBXHHHH  HH!~ "kg@#H 6pp7 P*  #B~ C!sA G(@Hj@H4@ HH H7 I~ C7@ A~ C$@( C #w#mB$B Hj@H4@ HH Hl@H4@ke@" #H 6pp7+ h  SubtreeNodeBX~ G(@ HHHH H8 I~ C8@ A9~ C&@L C 6@(IsTryout and IsEduc cannot both be TRUE.Bv HHHH HH!~ "ke@ #H 6pp7O h 999C"BN"NBm~ G(@ HHHH H: I~ C9@ A;~ C(@ C @B7 HHHH HH!~ "ke@ #H 6pp7 h B.~ G(@ HHHH H< I~ C:@ A~ C*@ C A HHHH HH!~ "ke@ #H 6pp7 l C=~ G(@ HHHH H> I~ C;@ A?~ C,@ C CwB HHHH HH!~ "ke@ #H 6pp7 l C@~ G(@HHHH  HA I~  C<@ A~ C.@HC2ATreePlan Tryout - Select#"NB`HHHH  HH!~ "ke@#H 6pp7ihS99CC"BN9CCBN"NBBmG(@H@x@H4@ HH  HB I~  C=@A~ C0@OC9ATreePlan Tryout - Terminal Node#"NB`H@x@H4@ HH Hz@H4@ke@"#H 6pp7Pr:'C '!Print_Area='C '!TreeDiagramB=~ Cr~ G(@HHHH  HC I~  C>@ AD~ C1@JC4ATreePlan Tryout - New Tree#"NB`HHHH  HH!~ "ke@#H 6pp7hB7~ G(@HHHH  HE I~  C?@ AF~ C2@LC6ATreePlan Tryout - Event Node#P"NB`HHHH  HH!~ "ke@#H 6pp7~ G(@HHHH  HH I~  C@@ AI~ C3@OC9ATreePlan Tryout - Decision Node#/"NB`HHHH  HH!~ "ke@#H 6pp7 CG'h cIDBX~ G(@HHHH  H5 I~  C@@ AJ~ C4@FC0ATreePlan Tryout - Help#\"NB`HHHH  HH!~ "ke@#H 6pp7)h cNameBX$G,@H@H@H@f@H]@  HK I~  CA@ AL~ C5@IC3ATreePlan Tryout - Options#"NB`H@H@H@f@H]@ H@H@Hh@H_@# 6pp7*h cValueBX$G,@Hi@H@H@d@H]@  HM I~  CA@ AN~ C6@HC2ATreePlan Tryout - Select#"NB`Hi@H@H@d@H]@ Hk@H@Hf@H_@# 6pp7)h cProbBX$G,@Hw@H@H`d@HY@  HO I~  CB@ A~ C7@CAHw@H@H`d@HY@ H@z@H@Hf@H[@# 6pp7)h cPredBXG?H&@H@`@HV@ H  HP I~  CB@A~ C8@C CmBH&@H@`@HV@H H&@Ha@HV@"#H 6pp7)h cKindBXG@H^@H@`@HV@ H  HQ I~  CC@ AR~ C9@GC1ATreePlan Acad. - Select#"NB`H^@H@`@HV@H H`f@Ha@HV@"#H 6pp7J+h cNumSucBXG@H m@H@`@HV@ H  HS I~  CC@ AT~ C:@NC8ATreePlan Acad. - Terminal Node#"NB`H m@H@`@HV@H Hu@Ha@HV@"#H 6pp7J)h cSuc1BXK@L|@M@`@MV@ L  LU N~  CD@ A~ C;@IC3ATreePlan Acad. - New Tree#"NB`L|@M@`@MV@L L@Ha@MV@"#L 6pp7J(h cRow BX~  CD@ A~ C<@KC5ATreePlan Acad. - Event Node#P"NB` 6pp7J(h cCol BX ~  CE@ A~ C=@NC8ATreePlan Acad. - Decision Node#/"NB` 6pp7J)h cMarkBX ~  CE@A~ C>@EC/ATreePlan Acad. - Help#\"NB` 6pp7hB7 ~  CF@ ?V~ C?@HC2ATreePlan Acad. - Options#"NB` 6pp7~  CF@ ?X~ C@@GC 1ATreePlan Acad. - Select#"NB`# 6pp7De&lHu'X+66@SL 8T0@!8@ "8@#8@$8@%8@&8@'8@(8@)8@*8@+8@PG,8@-8@.8@/8@08@18@28@SG38@48@ 58@T68@SG78@88Pw@Pg98@PW:8Sw@T;8@<8@ =8@>8T0@?8@ CW h BW~ CG@ ?Y~ C@@ C!A  # 6pp77!h!!9C"NBa !C !C !C !C ! C ! C ! C ! C ~ ! CG@ !?Z~ !CA@.!C"CmA&CwA&B$B !C !C !C !C ! C !!C !"C !#C !6pp7/"h"  ColPerStageBX "C[ "DEE"E`v@Ec@ " E" F~ " CH@ "?\~ "CA@A"C#+ATreePlan - Select#"NB` "C] "EE"E`v@Ec@ "C^ " EE!""Et@E@e@# "6pp7*#h# CurColBX$#G,@H$@H@Hl@HV@ # HI ~ # CH@ #?_~ #CB@H#C$2ATreePlan - Terminal Node#"NB`#H$@H@Hl@HV@# H$@H@H@j@HW@# #6pp7.$h$  RowPerTermBX~ $G[@$HHHHH ~ $ I? $ C`~ $ CI@$?~ $CB@C$C%-ATreePlan - New Tree#"NB`$HHHH$ HHHH# $6pp74%h%  TermRowNumBX~ %G(@%HHHH % Ha~ % I?~ % CI@ %?b~ %CC@E%C&/ATreePlan - Event Node#P"NB`%HHHH % HH!~ %"k`h@%#H %6pp7E&h&/ CurNode9C$"NBX~ &G(@&HHHH & Hc~ & I?~ & CJ@ &?d~ &CC@H&C'2ATreePlan - Decision Node#/"NB`&HHHH & HH!~ &"k`h@&#H &6pp7''h' DoneBX 'Ce~ 'Gj@'HHHH ' Hf~ ' I?~ ' CJ@ '?g~ 'CD@?'C()ATreePlan - Help#\"NB`'HHHH ' HH!~ '"k`h@'#H '6pp7!(h( CHA&A (Ch~ (G(@(HHHH ( Hi~ ( I?~ ( CK@ (?j~ (CD@B(C),ATreePlan - Options#"NB`(HHHH ( HH!~ ("k`h@(#H (6pp74)h)@ AllSucMark#"BX )Ck$)Gj@Ho@H@H@V@H@Z@ ) Hl~ ) I?~ ) CK@ )?m~ )CE@A)C*+ATreePlan - Select#"NB`)Ho@H@H@V@H@Z@) Hl@H@HT@H\@# )6pp70*h*@# C* B$B *Cn~ *G`j@*HHHHH ~ * I@ * Co~ * CL@ *?p~ *CE@*C+A*HHHH* HHHH# *6pp7++h+ @DoneBX~ +G(@+HHHH + Hq+ I~ + CL@+?~ +CF@+C,B7+HHHH+ HHHH# +6pp7=,h-'A9C*CBNT A~ ,G(@,HHHH , Hr, I~ , CM@ ,?s~ ,CF@,HHHH, HHHH# ,6pp7>-h.(AC)9C*C"NB`~ -G(@-HHHH - Ht- I~ - CM@ -?u~ -CG@-HHHH- HHHH# -6pp7:.h/$ @ TermRowNumCCBX~ .G(@.HHHH . Hv. I~ . CN@.?~ .CG@.HHHH. HHHH# .6pp7>/h0(AC9C*C""NB`~ /G(@/HHHH / Hw/ I~ / CN@ /?x~ /CH@/HHHH/ HHHH# /6pp7;0h1%A9C*C"NB`0G?H(@HX@HV@0 H 0 HP0 I~ 0 CO@ 0?y~ 0CH@0H(@HX@HV@0H0 H(@H\@HV@"0#H 06pp7K1h25 @CurNode9C*C "NBX1G@H(@H@_@HV@1 H 1 HS1 I~ 1 CO@1?~ 1CI@1H(@H@_@HV@1H1 H(@Ha@HV@"1#H 16pp762h3  @CurColC)CBX 2Cz2G@Hp@H@_@HV@2 H 2 H{2 I~ 2 CP@ 2?|~ 2CI@2Hp@H@_@HV@2H2 Hk@Ha@HV@"2#H 26pp7"3h4 @C A3G@H`@HX@HV@3 H 3 HQ3 I~ 3 C@P@ 3?}~ 3CJ@3H`@HX@HV@3H3 H@]@H\@HV@"3#H 36pp7>4h5(AC)9C*C"NB`4K@L`@L@_@LV@4 L 4 LU4 N~ 4 CP@ 4?~~ 4CJ@4L`@L@_@LV@4L4 L@]@La@LV@"4#L 46pp75h6A99C*C$BNC"BN99C*C9C*CBNBNC"BNA9C*C""NB`~ 5 CP@5A~ 5CK@ 56pp7;6h7%A9C*C"NB`~ 6 CQ@6A~ 6CK@ 66pp7K7h85 @CurNode9C*C "NBX7 ~ 7 C@Q@ 7A 7Z~ 7CL@ 76pp768h9  @CurColC)CBX 8C 8C 8C 8C 8 C 8 C 8 C 8 C ~ 8 CQ@ 8A~ 8CL@ 86pp79h:@A 9C 9DEE9Et@EB@ 9 E9 F~ 9 CQ@9A~ 9CM@ 96pp7 :C#:h@; @#VB:G?H$@H@HV@: H : H: I~ : CR@ :A~ :CM@ :6pp71;h< @CurNode#UBX;G@H]@H@HV@; H ; HS; I~ ; C@R@ ;A~ ;CN@ ;6pp76<h=  @CurColC)CBX<K@Lk@L@LV@< L < LU< N~ < CR@ <A~ <CN@ <6pp7=h>@A~ = CR@=A~ =CO@ =6pp7>h?A~ > CS@ >A~ >CO@>># >6pp7?h@99C$BNC"BN99C9CBNBNC"BNA9C""NB`~ ? C@S@ ?A~ ?CP@??# ?6pp7D+ l`,-A(%K sU}@8T0@A8@ B8@C8@D8@E8@F8@G8@H8@I8@J8@K8@PGL8@M8@N8@O8@P8@Q8@ R8@SWS8@ T8@U8@TV8@SGW8@X8Pw@PGY8@PGZ8Sw@T[8@\8@]8@^8T0@_8G9@hA#9C"NB`~ @ CS@ @A~ @C@P@@@# @6pp7>AhB(C)9C*C"NB` AC AC AC AC A C A C A C A C ~ A CS@AA~ ACP@ AC AC AC AC A C A!C A"C A#C A6pp7BhDB7 BC BDEEBEt@E`d@ B EB F~ B CT@ BA~ BCP@ BC BEEBEt@E`d@ BC B EE!B"Es@Ef@# B6pp7$CG,@H,@H@Hg@H c@ C HI ~ C C@T@ CA~ CCQ@CH,@H@Hg@H c@C H,@H@He@H@e@# C6pp7 DCDhEB`~ DG&@DHHHHH ~ D I? D C~ D CT@ DA~ DC@Q@DHHHHD HHHH# D6pp7*EhF AllMarkBX EC~ EG(@EHHHH E HE I~ E CT@EA~ ECQ@EHHHH E HH!~ E"kb@E#H E6pp7@FhG*i9C*CBNB~ FG(@FHHHH F HF I~ F CU@ FA~ FCQ@FHHHH F HH!~ F"kb@F#H F6pp7XGhHBA99C*CCgBNCBNA&B~ GG(@GHHHH G HG I~ G C@U@ GA~ GCR@GHHHH G HH!~ G"kb@G#H G6pp7.HhI @AllMarkBX~ HG(@HHHHH H HH I~ H CU@ HA~ HC@R@HHHHH H HH!~ H"kb@H#H H6pp7IhJ@A~ IG(@IHHHH I HI I~ I CU@IA~ ICR@IHHHH I HH!~ I"kb@I#H I6pp7JhKA JC~ JGj@JHHHH J HJ I~ J CV@ JA~ JCR@JHHHH J HH!~ J"kb@J#H J6pp7KhM #B7~ KG(@KHHHH K HK I~ K C@V@ KA~ KCS@KHHHH K HH!~ K"kb@K#H K6pp7 LC~ LG(@LHHHH L HL I~ L CV@ LA~ LC@S@LHHHH L HH!~ L"kb@L#H L6pp7 MCMhNB`MG?Hk@H"@HV@M H M HPM I~ M CV@MA~ MCS@MHk@H"@HV@MHM Hi@H"@HV@"M#H M6pp7%NhO iBXNG@Hk@HC@HV@N H N HSN I~ N CW@ NA~ NCS@NHk@HC@HV@NHN Hi@HC@HV@"N#H N6pp7TOhP>99C*CCgBNCBNA OCOG@Hk@H@Q@HV@O H O H{O I~ O C@W@ OA~ OCT@OHk@H@Q@HV@OHO Hi@H@Q@HV@"O#H O6pp7/PhQ @iCgBXPG@Hk@HX@HV@P H P HQP I~ P CW@PA~ PC@T@PHk@HX@HV@PHP Hi@HX@HV@"P#H P6pp7QhRAQK@Lk@L `@LV@Q L Q LUQ N~ Q CW@ QA~ QCT@QQLk@L `@LV@QLQQ Hi@L `@LV@"Q#L Q6pp7?RhT)9C*CCg"NB7~ R CX@ RA~ RCT@RR# R6pp7 SC SC SC SC S C S C S C S C ~ S C@X@ SA~ SCU@ SC SC SC SC S C S!C S"C S#C S6pp7 TC!ThU B TC T`aaTat@a`d@ T aT b~ T CX@TA~ TC@U@ TC TaaTat@a`d@ TC T aa!T"as@af@# T6pp7SUhV=  MaxNodeRow9C"9AL"NBBX$Uc,@H,@H@Hg@H c@ U Hd ~ U CX@ UA~ UCU@UH,@H@Hg@H c@U H,@H@He@H@e@# U6pp7SVhW=  MaxNodeCol9C9AL"NBBX~ Vc&@VHHHHH ~ V d? V C~ V CY@ VA~ VCU@VHHHHV HHHH# V6pp7#WhX CT B WC~ Wc(@WHHHH W HW d~ W C@Y@ WA~ WCV@WHHHH W HH!~ W"kb@W#H W6pp7XhYAYF'C '!TreeDiagram9CC"NB=I'C '!TreeDiagram9CC"NB=B XC~ Xc(@XHHHH X HX d~ X CY@XA~ XC@V@XHHHH X HH!~ X"kb@X#H X6pp7YhZA~ Yc(@YHHHH Y HY d~ Y CY@ YA~ YCV@YHHHH Y HH!~ Y"kb@Y#H Y6pp7Zh[AY9 TreeDiagram9CC"NB=< TreeDiagram9CC"NB=B ZC~ Zc(@ZHHHH Z HZ d~ Z CZ@ ZA~ ZCV@ZHHHH Z HH!~ Z"kb@Z#H Z6pp7[h\A [C~ [c(@[HHHH [ H[ d~ [ C@Z@ [A~ [CW@[HHHH [ HH!~ ["kb@[#H [6pp7\h^B7 \C~ \cj@\HHHH \ H\ d~ \ CZ@\A~ \C@W@\HHHH \ HH!~ \"kb@\#H \6pp7 ]C~ ]c(@]HHHH ] H] d~ ] CZ@]A~ ]CW@]HHHH ] HH!~ ]"kb@]#H ]6pp7 ^C^h_BW ^C~ ^c(@^HHHH ^ H^ d~ ^ C[@ ^A ^Z~ ^CW@^HHHH ^ HH!~ ^"kb@^#H ^6pp7!_h` 9Bm_c?Hk@H"@HV@_ H _ HP_ d~ _ C@[@_A~ _CX@_Hk@H"@HV@_H_ Hi@H"@HV@"_#H _6pp7D lV. kU`8T0@a8@b8@c8@ d8@e8@ f8@g8@h8@ i8@j8@"k8@PWl8@m8@n8@o8@p8@q8@r8@SGs8@t8@u8@Tv8@SGw8@ x8Pw@PWy8@Pgz8Sw@T{8@|8@}8@~8T0@8@`haB4`c@Hk@HC@HV@` H ` HS` d~ ` C[@ `Aa~ `C@X@`Hk@HC@HV@`H` Hi@HC@HV@"`#H `6pp7:ah b$99B  Line 25 aCac@Hk@H@Q@HV@a H a H{a d~ a C[@ aA~ aCX@aHk@H@Q@HV@aHa Hi@H@Q@HV@"a#H a6pp7bhc Bbc@Hk@HX@HV@b H b HQb d~ b C\@ bA~ bCX@bHk@HX@HV@bHb Hi@HX@HV@"b#H b6pp7chdB4ce@fk@H `@fV@c f c fUc g~ c C@\@cA~ cCY@ccfk@H `@fV@cfcc Hi@H `@fV@"c#f c6pp7dhfB7~ d C\@ dAc~ dC@Y@ d6pp7 eC eC eC eC e C e C e C e C ~ e C\@ eA~ eCY@ eC eC eC eC e C e!C e"C e#C e6pp7 fCfhgBW fH fDEEfE@@El@ f Ef F~ f C]@ fA~ fCY@ fC fEEfE@@El@ fC f EE!f"E~@E@p@# f6pp7$ghh9B/gH$gG.@H@H@H~@Hi@ g H ~ g I@b@ g C~ g C@]@gA~ gCZ@gH@H@H~@Hi@g H@H@H`}@Hk@# g6pp7)hhiiCBhHhK?Li@Li@LV@h L h Lh N~ h C]@ hAf~ hC@Z@hLi@Li@LV@hLh Lh@Ll@LV@"h#L h6pp7<ihj&AC9Cg"NB/~ i C]@ iA~ iCZ@ i6pp7@jhk*AC9Cg"NB/ jC jC jC jC j C j C j C j C ~ j C^@ jA~ jCZ@ jC jC jC jC j C j!C j"C j#C j6pp7khlA kC kDEEkE0x@Eb@ k Ek F~ k C@^@kA~ kC[@ kC kEEkE0x@Eb@ kC k EE!k"Et@Ec@# k6pp7>lhm(9C"NB/0lC?C?G,@H@H@HPw@HJ@ l Hl I~ l C^@ lAi~ lC@[@lH@H@HPw@HJ@l H@H@Hs@HL@# l6pp7mhoB7mC@C@G&@mHHHHH ~ m I@ m C~ m C^@ mA~ mC[@mHHHHm HHHH# m6pp7nC@C@G(@nHHHH n Hn I~ n C_@ nA~ nC[@nHHHH n HH!~ n"kr@n#H n6pp7 oCohpBWoC@C@G(@oHHHH o Ho I~ o C@_@oA~ oC\@oHHHH o HH!~ o"kr@o#H o6pp7*phq LineWeightBX~ pC@$pG,@H@HN@HPw@HJ@ p Hp I~ p C_@pA~ pC@\@pH@HN@HPw@HJ@p H@HP@Hs@HL@# p6pp7/qhsi9ALB~ qC@~ qG&@qHHHHH ~ q I? q C~ q C_@ qA qZ~ qC\@qHHHHq HHHH# q6pp7~ rC@~ rG(@rHHHH r Hr I~ r C`@rA~ rC\@rHHHH r HH!~ r"kr@r#H r6pp7Csht-ACellRow9CgC""NBX~ sC @~ sG(@sHHHH s Hs I~ s C `@ sAK~ sC]@sHHHH s HH!~ s"kr@s#H s6pp7Cthv-ACellCol9CgC"NBX*tC"@C@G?H@H@]@HV@t H t HPt I~ t C@`@ tA~ tC@]@tH@H@]@HV@tHt H@H `@HQ@"t#H t6pp7*uC$@C@G@HY@H@]@HV@u H u HSu I~ u C``@ uA~ uC]@uHY@H@]@HV@uHu H@V@H `@HQ@"u#H u6pp7>vhw(A9CgCBND B*vC&@C@G@Hh@H@]@HV@v H v H{v I~ v C`@ vA~ vC]@vHh@H@]@HV@vHv H`e@H `@HQ@"v#H v6pp7Zwh xDA9CC"N9CC"N  B  Rectangle 33*wC(@C @K@L@r@H@]@LV@w L w LUw N~ w C`@wA~ wC^@wL@r@H@]@LV@wLw Lo@H `@HQ@"w#L w6pp7!xhy @BπxJJJJJJJ ~ x C`@ xAM~ xC@^@ x6pp7,yhz@C~BT yC yC yC yC y C y C y C y C ~ y C`@ yA~ yC^@ yC yC yC yC y C y!C y"C y#C y6pp7zh{@A zJ zTUUzUt@Up@ z Uz V~ z Ca@ zA~ zC^@ zC zUUzUt@Up@ zC z mm!z"mp@m@z@# z6pp7>{h|(A9CgCBNE B~ {C?{J{G@H@H@ {HH { H{ I~ { C a@ {A~ {C_@{H@H@ {HH{ n@n$@n@o@n4@# {6pp7Z|h }DA9CC"N9CC"N  B  Oval 26~ |C@|J|G@H@H4@ |HH | H| I~ | C@a@|A~ |C@_@|H@H4@ |HH| n@nA@n@o@n4@# |6pp7!}h~ @Bπ }C~ }C@}J}G@H@H@@ }HH } H} I~ } C`a@ }AO~ }C_@}H@H@@ }HH} n@nK@n@o@n4@# }6pp7,~h@C~BT ~C~ ~C@~G@H@HG@ ~HH ~ H~ I~ ~ Ca@ ~A~ ~C_@~H@HG@ ~HH~ n@nT@n@o@n4@# ~6pp7h@A~ C@G@H@HM@ HH  H I~  Ca@ A~ C`@H@HM@ HH n@nY@n@o@n4@# 6pp7D!l"Vx\ AuH @  8T0@8@8@8@8@8@8@8@8@8@8@8@PG8@8@8@ 8@8@8@8@SG8@8@8@T8@SG8@8Pw@PG8@PG8Sw@T8@8@8@8T0@8@>h(A9CgCBNT B~ C@G@H@HQ@ HH H I~ Ca@A~ C `@H@HQ@ HH n@n^@n@o@n4@# 6pp73hA 9CC"NBm~ C@G@H@HU@ HH H I~ Ca@A~ C@`@H@HU@ HH n@n b@n@o@n4@# 6pp7 h @ BT~ C @G@H@HX@ HH H I~ Cb@ A Z~ C``@H@HX@ HH n@nd@n@o@n4@# 6pp76h @ )###"B C~ C"@G@H@H@\@ HH H I~ C b@A~ C`@H@H@\@ HH n@ng@n@o@n4@# 6pp7 h @ BT~ C$@G@H@H@_@ HH H I~ C@b@ A~ C`@H@H@_@ HH n@n@j@n@o@n4@# 6pp7!h @ Bπ~ C&@G@H@Ha@ HH H I~ C`b@ A~ C`@H@Ha@ HH n@n`m@n@o@n4@# 6pp7,h@ C~BT~ C(@G@H@Hc@ HH H I~ Cb@ A~ C`@H@Hc@ HH n@no@n@o@n4@# 6pp7)h@CCB~ C*@$G,@H@Hd@Hs@HO@ QI ~ Cb@ A~ Ca@H@Hd@Hs@HO@ n@nq@no@nV@# 6pp7`h JA 9CC"N 9CC"NB  Line 37~ C,@G@H$@Hf@ HH H I~ Cb@ @~ C a@H$@Hf@ HH n.@nq@n`m@n4@# 6pp7*h@ BT C~ C.@G@H$@Hg@ HH H I~ Cb@ ]~ C@a@H$@Hg@ HH n.@ns@n`m@n4@# 6pp7h@A C~ C0@G@H$@Hi@ HH H I~ Cc@ A~ C`a@H$@Hi@ HH n.@nPt@n`m@n4@# 6pp7h@A~ C1@G@H$@Hj@ HH H I~ C c@ ]~ Ca@H$@Hj@ HH n.@nu@n`m@n4@# 6pp7^h HA9CC"N9CC"NB  Line 47~ C2@W?S$@S`m@SV@ S S I~ C@c@]~ Ca@S$@S`m@SV@S n@nw@nR@n9@# 6pp7,h@C~BT~ C3@W@S]@S`m@SV@ S S I~ C`c@ A~ Ca@S]@S`m@SV@S nV@nw@nK@n9@# 6pp7h A999CgC BNC"BN99CgC BNCBN"N 9CC"NB  Line 48~ C4@X@Yk@Y`m@YV@ Y Y N~ Cc@ A~ Ca@Yk@Y`m@YV@Y o`c@nw@o@Z@n9@# 6pp7,h@C~BT~ Cc@ A~ Cb@ 6pp7\hFA9CgC"N9CC"NB1~ Cc@ @~ C b@ 6pp7Th>A99CgC BNCBNE B O~ Cc@ @~ C@b@ 6pp7\h FA9CgC!"N9CC"NB1 C#A~ Cd@ @~ C`b@ 6pp7Ah +A9CC"NBm CB7~ C d@ @~ Cb@ 6pp7!h @B+~ C@d@@~ Cb@ 6pp7h@A~ C`d@ @~ Cb@ 6pp7\hFA9CgC,"N9CC"NB1~ Cd@ @~ Cb@ 6pp7Ah+A9CC"NBm @~ Cc@ 6pp7!h @B+ @~ C c@ 6pp7hA @~ C@c@ 6pp7Eh/ CellZeroRow9C""NBX @~ C`c@ 6pp7Eh/ CellZeroCol9C"NBX @~ Cc@ 6pp7<h&A9CBND B @~ Cc@ 6pp7Zh$ DA9CC"N9CC"N  B  Rectangle 49@~ Cc@ 6pp7!h @Bπ@~ Cc@ 6pp7,h@C~BT @~ Cd@ 6pp7DWl @ >hYYoOGssjK8T0@8@8@8@8@8@8@8@8@8@8@8@PG8@8@8@8@8@8@8@SG8@8@8@T8@SG8@8Pw@PG8@PG8Sw@T8@8@8@8T0@8@h@A@~ C d@ 6pp7<h&A9CBNE B @~ C@d@ 6pp7ZhDA9CC"N9CC"N  B @~ C`d@ 6pp7!h @Bπ @~ Cd@ 6pp7,h@C~BT @~ Cd@ 6pp7h@A @~ Cd@ 6pp7^h@ H9CC"N9CC"NB  Line 50 @~ Cd@ 6pp7(hC~BT @ ~ Ce@ 6pp7hB7@~ C e@ 6pp7 @~ C@e@ 6pp7 ChBW @~ C`e@ 6pp7/hi9ALB @~ Ce@ 6pp7>h(A9CgCBNT B@~ Ce@ 6pp7Kh5 @FormRow9CgC""NBX @ ~ Ce@ 6pp75h @FormColCBX @~ Ce@ 6pp7jhT @FormText =sum(R[1]C[9CgCBNCY]BX @ ~ Cf@ 6pp7Kh5 @CurNode9CgC "NBX @~ C f@ 6pp7&h@C*A@~ C@f@ 6pp7h @ FormTextC[,R[9C*C"BNCZ]C[9C*CBNCY]BX@~ C`f@ 6pp7Kh5 @ CurNode9C*C "NBX @~ Cf@ 6pp7h@A@~ Cf@ 6pp77h! @FormTextC[)BX @~ Cf@ 6pp7Sh=A99CgC"BNC"NBm @ ~ Cf@ 6pp7#h @C[B` @~ Cg@ 6pp7h@A@~ C g@ 6pp7hA@~ C@g@ 6pp7hB7 @~ C`g@ 6pp7@~ Cg@ 6pp7 C hBW @~ Cg@ 6pp75hCurNode9ALB @~ Cg@ 6pp7Oh9 @FormRow9C*C"BNBX @~ Cg@ 6pp7Oh9 @FormCol9C*CBNBX @~ Ch@ 6pp7DlGjOZKVD*X]hycyPyGeQGCH&Xc}8T0@8@8@8@8@8@8@8@8@8@8@8@PG8@8@8@8@8@8@8@SG8@8@8@T8@SG8@8Pw@PG8@PG8Sw@T8@8@8@8T0@8@Oh9A9C*CBND  #"B @~ C h@ 6pp7Oh9A9C*CBNE  #"B @~ C@h@ 6pp7Oh*9A9C*CBNT  #"B @~ C`h@ 6pp7hA@~ Ch@ 6pp7hB7 @~ Ch@ 6pp7 @~ Ch@ 6pp7 C0h FormText=maxBX @~ Ch@ 6pp7?h)YFormText=minBXB @~ Ci@ 6pp7h FormTextC[(R[99C*CBNC"BNCZ]C[99C*CBNCBNCY]BX @~ C i@ 6pp7@h*i9C*CBNB @~ C@i@ 6pp7h @FormTextC[,R[99C*CCgBNC"BNCZ]C[99C*CCgBNCBNCY]BX @~ C`i@ 6pp7hA@~ Ci@ 6pp73h FormTextC[)BX@~ Ci@ 6pp79h#9CZCY"NBm A Z~ Ci@ 6pp7h C[B`@~ Ci@ 6pp7"h R[1]CBm @~ Cj@ 6pp7uh_YPY=A-B*exp(R[-1]C/RT)B`"=A-B*exp(-R[-1]C/RT)B`"B @~ C j@ 6pp7h FormText=if(R[1]C[-1]=R[99C*CBNC"BNCZ]C[99C*CBNCBNCY],1BX @~ C@j@ 6pp7@h*i9C*CBNB@~ C`j@ 6pp7h @FormTextC[,if(R[1]C[-1]=R[99C*CCgBNC"BNCZ]C[99C*CCgBNCBNCY],CgBX @~ Cj@ 6pp7hA @~ Cj@ 6pp7@h*i9C*CBNB@~ Cj@ 6pp77h! @FormTextC[)BX @~ Cj@ 6pp7hA @~ Ck@ 6pp7&h R[-2]C[1]Bm @~ C k@ 6pp7h C[B` @~ C@k@ 6pp7hB7 @~ C`k@ 6pp7@~ Ck@ 6pp7 C(h URowBX @~ Ck@ 6pp7!h YB @~ Ck@ 6pp79h#A9CZCY"NBm~ Ck@ 6pp7fhP@Y=ln((A-R[1]C)/B)*RTB`"=-ln((A-R[1]C)/B)*RTB`B @~ Cl@ 6pp7Dl}}}CH*lmnC]uIPjGjeGTMR&dOc8T0@8@8@8@8@8@8@8@8@8@8@8@PG8@8@8@8@8@8@8@SG8@8@8@T8@SG8@8Pw@PG8@PG8Sw@T8@8@8@8T0@8@5h @FormRowCZBX @~ C l@ 6pp7,h @URowBX @~ C@l@ 6pp7hA@~ C`l@ 6pp7h FormText=if(abs(1-sum(R[99C*CBNC"BNCZ]C[99C*CBNCBNCY]BX @~ Cl@ 6pp7@h*i9C*CBNBA~ Cl@ 6pp7h @FormTextC[,R[99C*CCgBNC"BNCZ]C[99C*CCgBNCBNCY]BX A~ Cl@ 6pp7hA A~ Cl@ 6pp7h FormTextC[))<=0.00001,sum(R[99C*CBNC"BNCZ]C[99C*CBNCBNCY]*R[BX A~ Cm@ 6pp7h FormTextC[99C*CBNC"BNCCZ]C[99C*CBNCBNCY]BXA~ C m@ 6pp7@h*i9C*CBNBA~ C@m@ 6pp7h @FormTextC[,R[99C*CCgBNC"BNCZ]C[99C*CCgBNCBNCY]*R[BX A#~ C`m@ 6pp7h @FormTextC[99C*CCgBNC"BNCCZ]C[99C*CCgBNCBNCY]BXA~ Cm@ 6pp7hA A%~ Cm@ 6pp79h# FormTextC[),na())BX A&~ Cm@ 6pp79h#9CZCY"NBm A'~ Cm@ 6pp7h C[B` A(~ Cn@ 6pp7hB7 A)~ C n@ 6pp7 A*~ C@n@ 6pp7 CIh3 FormText=R[-1]C[CCY]BX A+~ C`n@ 6pp79h#9CZCY"NBm A,~ Cn@ 6pp7h C[B` A.~ Cn@ 6pp7"h R[1]CBm A0~ Cn@ 6pp7uh_YPY=A-B*exp(R[-1]C/RT)B`"=A-B*exp(-R[-1]C/RT)B`"B A2~ Cn@ 6pp7hB7 A3~ Co@ A4~ C o@ C" h  C! A6~ C@o@Lh6IsUnprotectedWorksheetB BA&B$BX A7~ C`o@%hCxAA&B P" A~ Co@\hF@8Activate an unprotected worksheet before using TreePlan.Bv C$ A8~ Co@h@B7 A9~ Co@hA A:~ Co@"h CxA&B A;~ Cp@D+lmdCjGjGggMH*gMP:FlS>9T0@@@@@@@@@ @ @ @PG @ @@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@\hF@8Activate an unprotected worksheet before using TreePlan.Bv A<~ Cp@h@B7 A=~ C p@hAA~ C0p@ h A_AB CA~ C@p@YhC@5Select a single cell or object before using TreePlan.Bv C @>~ CPp@h@B7@~ C`p@hA @?~ Cpp@hBW @@~ Cp@*h  HelpOffsetBX @B~ Cp@ C-' hP  TreeDataBz TreeData C5 A~ Cp@ C/* hd   TreeDiagramBz TreeDiagram A~ Cp@ C1+ h|   TreeDiagBaseBz TreeDiagBase AC~ Cp@: h $ ExcelVersionreleaseABX A~ Cp@- h SheetName"BX AE~ Cp@dhN]CB|A~A&3 SheetNameCCA ]CB|BtBXBqh[CT ]CB|A~A&B$3 SheetNameCCA ]CB|BtBXB AF~ Cp@<h&C AC-AA&C5AA&B$BA~ Cq@Qh;A'C'!TreeDiagBase9"NB=h~ACT ;'C'!TreeDiagBase9"NB=1 TreeDiagBase9"NB=B AG~ Cq@hA A~ C q@ l A~ C0q@ l A~ C@q@ lA~ CPq@ l A~ C`q@.hC-AC5AB%B A~ Cpq@Ah*+@Cw #"#"BA~ Cq@#h BAAh !^AiAA~ Cq@ l A~ Cq@#h* @#B A~ Cq@'h,A_BRAA AG~ Cq@ l AI~ Cq@#h* @#BhA ?JYh C@5Select a single cell or object before using TreePlan.Bv ?KD l|>5J:9<JnflVMX 9**&*N]b*CG*1+ T0@!@"@#@$@%@&@'@(@)@*@+@PG,@-@.@/@0@1@2@SG3@4@5@T6@SG7@8Pw@PG9@PG:Sw@T;@<@=@>T0@?@ h!A ?L!h#B7 !?M "?O #CA!#h$ #Al #?P,$h% SelectedNodeBX $?Q"%h& C A %?R &h' @BW &^S 'CD"'h?( @#A '?T (h) @BW (?U8)h**"@C  #"B )?V2*h+@C B7B *?WC+h,-@C #C_Cd"B +?,h-A ,?-h/B7 -?.? /CH9/h/#'C'!TreeDiagBase!^B=h/h0RCT ''C'!TreeDiagBase!^B= TreeDiagBase!^B=B/?0h1 #B20?!1h2 :Bm1?$2h3B52?=3h3''C '!TreeData;B=p3h4ZCT +'C '!TreeData;B=!TreeData;B=B3?94h4#'C'!UseExpUtilityB=h4h5RCT ''C'!UseExpUtilityB= UseExpUtilityB=B4?95h5#'C'!MinimizeCostsB=h5h6RCT ''C'!MinimizeCostsB= MinimizeCostsB=B5?6h*7 #B6h6?P7h7:'C '!Print_Area='C '!TreeDiagramB=7h8sCT >'C '!Print_Area='C '!TreeDiagramB=' Print_Area =TreeDiagramB=B7?!8h9 9Bm8?<9h:&"+"$#,##0.00;"-"$#,##0.00;$0.00B*9?:3:h;"+"$#,##0;"-"$#,##0;$0B*:?;h=B7;?<? =CN.=h> ActiveCell!^BBX=?%>h?IsNodeBX>?*?h@ IsNameFieldBX??D l+,A>42B2JDU+, -/27/JK( J3@T0@A@B@C@D@E@F@G@H@I@J@K@PGL@M@N@O@P@Q@R@SGS@T@U@TV@SGW@XPw@PGY@PGZSw@T[@\@]@^T0@_@+@hA IsValueFieldBX@?*AhB IsEVCEFieldBXA?(BhC IsEUFieldBXB?*ChD IsProbFieldBXC?*DhE IsTermFieldBXD?'EhFCurNodeBXE?9FhG#CsA&C*9AL B$AF?tGhH^ATestCell99C*C"BN9C*CBN"NBBXG?)HhI@CC BH?0IhJ@ ActiveNode#*BXI?)JhK@IsNodeBXJ?KhL@AK?1LhM@CurNodeC*BXL?MhNAM?NhO CsBN?6OiP @ SelectedNodeC*BXO?#Ph*Q @#BP?QhRAQ?+RhS@CurNodeBXR?ZShTD@#r#y#o#n#u#vB%A&C*9AL B$AS?|ThUfATestCell99C*C"BN9C*CBN"NBBXT?EUhV/@CC  IsNameFieldBXBU?|VhWfATestCell99C*C"BN9C*CBN"NBBXV?FWhX0@CC  IsValueFieldBXBW?|XhYfATestCell99C*C"BN9C*CBN"NBBXX?EYhZ/@CC  IsEVCEFieldBXBY?|Zh[fATestCell99C*C"BN9C*CBN"NBBXZ?C[h\-@CC  IsEUFieldBXB[?T\h]>A99C*C BNCBNE B\?|]h^fA TestCell99C*C"BN9C*CBN"NBBX]?E^h_/@ CC  IsProbFieldBXB^?_h`@A_?D l986885G7>7+?'-D1'9hSTSQbS`T0@a@b@c@d@e@f@g@h@i@j@k@PGl@m@n@o@p@q@r@SGs@t@u@Tv@SGw@xPw@PGy@PGzSw@T{@|@}@~T0@@>`ha(A9C*CBNT B`?gahbQA TestCell99C*C"BN9AM"NBBXa?Ebhc/@ CC  IsTermFieldBXBb?chd@Ac?1dhe@CurNodeC*BXd?ehf@Ae?dfigN@#r#y#o#n#u#vB%  SelectedNodeC*BXBf?xghhbATestCell99C"BN9CBN"NBBXg?Ehhi/@CC  IsEVCEFieldBXBh?xihjbATestCell99C"BN9CBN"NBBXi?Cjhk-@CC  IsEUFieldBXBj?^kh*lH@#r#y#n#o#u#vB% #"#"Bk?lhmAl?mhoB7m?n? oCX>ohp(9CCBND Bo?#ph*q @#Bp?=qhr'9CCBNE Aq?#rh*s @#Br?=sht'9CCBNT As?#th*u @#Bt?uhvAu?vhxB7v?w? xCYxh*y #Bx?"yhz C2 By?%zh{@#Alz?#{h*| @#B{?7|h*}!@C  #K"B|?!}h~ C1 A}?#~h* @#B~?.hC0 C B$A?D lLuS+?+rSQl'( Z1K1K1'( ;031E/1T0@@@@@@@@@@@@PG@@@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@1h@ SubtreeNode#BX?!h C0 A?#h* @#B?#h* @#B?8h*"@C  #"B?Eh/@C C B% #"B?8h"@C  #"B?8h"@C  #"B?8h"@C  #"B?8h"@C  #"B?#h* @#B?hA?hB7?? CZh* #B?"h CS B?%h@#Al?#h* @#B?7h*!@C  #K"B?!h CR A?#h* @#B?.hCQ C B$A?1h@ SubtreeNode#BX?!h CQ A?#h* @#B?#h* @#B?8h*"@C  #"B?Eh/@C C B% #"B?8h"@C  #"B?8h"@C  #"B?8h"@C  #"B?8h"@C  #"B?D l?/11FSFFFF1'( ;031E/1<?/11FSFFFT0@@@@@@@@@@@@PG@@@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@#h* @#B?hA?hB7?? C[h* #B?"h C B?%h@# Al?#h* @#B?7h*!@C  #K"B?!h C A?#h* @#B?#h* @#B?Eh*/@C C B% #"B?8h"@C  #"B?8h"@C  #"B?#h* @#B?!h C A?#h* @#B?hA?hB7?? C\#h C B?;h%A9CBN B?%h@#6 Al?%h@#Al?h@A?%h@#6Al?%h@#Al?h@A?%h@#7Al?%h@#9Al?hA9CBN 99CBNCBND B$#< Al#<AlB?D/ l1'( ;031E/11SFF1/1'( ?I33+33+33T0@@@@@@@@@@@@PG@@@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@%h@#=Al?%h@#:Al?hA?=h'A9CCBN B?%h@#6 Al?%h@#Al?h@A?%h@#6Al?%h@#Al?h@A?%h@#7 Al?%h@#9 Al?%h@#8 Al?_hIA9CCBN #< Al#<AlB?%h@#= Al?hjA9CC BN 9CBN B$#:Al#: AlB?hA?!h #Al?7h! LastUsedNode9ALBX?!h #;AlEh/C| #;Al#;AlB?$hDecOKBX?(h DecSelectBX?(h DecCancelBX?)h DecOptionsBX?4h#0#2#.#1B%A&A? h @BW? C]"h @#/A? h @BW?=h'@C DecOKBXB?@h*@C  DecCancelBXB?Ah+@C  DecSelectBXB?Bh,@C  DecOptionsBXB?D= l33'K33+33+333m3'/Ex2667B.>.KNOT0@@@@@@@@@@@@PG@@@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@Ch-@C #C^Cd"B?hA?hB7?? C^=h'9CCBN B?%h@#> Al?%h@#Al?hA?%h@#>Al?%h@#Al?hA?_hI9CCBN #AAl#A AlB?hj9CC BN 9CBN B$#?Al#? AlB?!h #Al?7h! LastUsedNode9ALBX?!h #@AlEh/C| #@Al#@AlB?$hEveOKBX?(h EveSelectBX?)h EveOptionsBX?(h EveCancelBX?4h#Q#S#O#RB%A&A? h @BW? C_"h&@ @#PA? h @BW?=h'@C EveOKBXB?Bh,@C  EveOptionsBXB?@h*@C  EveCancelBXB?Ah+@C  EveSelectBXB?Ch-@C #C^Cd"B?hA?hB7??D lQ'( Y33'33'm/Ex2676B.>.KPNOQ'(T0@@@@@@@@@ @ @ @PG @ @@@@@@SG@@@T@SG@Pw@PG@PGSw@T@@@T0@@ C`#h C B?%h@#EAl?hA?)h@IsPredBX?-h@CurNode#BX?2h@CtA&C* B$A?Vh@A9C*C BNC IsPredBXB?Ch-ACurNode9C*C "NBX?h @A?E h /@Ct#EAl#E AlB ? h A ? h j9CC BN 9CBN B$#FAl#F AlB ?! h  #Al ?! h #Al ?!h #CAl?!h #D Al?7h! LastUsedNode9ALBX?!h #GAlEh/C| #GAl#GAlB?$hTerOKBX?(h TerSelectBX?(h TerCancelBX?)h TerOptionsBX?4h####B%A&A? h @BW? Ca"h,@ @#A? h @BW?=h'@C TerOKBXB?@h*@C  TerCancelBXB?Ah+@C  TerSelectBXB?Bh,@C  TerOptionsBXB?Ch-@C #CcCd"B?4h @C C B%B?D l?3'7;@dQ+S'////Ex2667B.>.KNOPQ T0@!@"@#@$@%@&@'@(@)@*@+@PG,@-@.@/@0@1@2@SG3@4@5@T6@SG7@8Pw@PG9@PG:Sw@T;@<@=@>T0@?@% h!@#CAl ?%!h"@#D Al!?"h#      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmno}rstuvwxyz{|@A"?%#h$@#CAl#?%$h%@#DAl$?%h&@A%?&h(A&?'?(h*B7(?)? *Cb7*h+! LastUsedNode9ALBX*?#+h, C| B+?9,h-#@Cr #AlB,?9-h.#@Cy #AlB-?9.h/#@Cu #AlB.?9/h0#@Co #AlB/?[0h1E@Cn 1Y#Al#Al"B0?91h2#@Cv #AlB1?#2h*3 @#B2?73h*4!@C  #K"B3?4h5A4?O5h69@+Select a single node before using TreePlan.Bv5?6h7A6?7h9B77?8? 9Cc79h:! LastUsedNode9ALBX9?#:h; C| B:?F;h<0@C"B 9B 9AM B;?%<h=@#Al<?=h>@A=?N>h?8 @SelColC"B 9B A'BX>?:?h@$@C #AlB??D l33+33+' ( S1GGGGiG1E']'( S1T3+\@T0@A@B@C@D@E@F@G@H@I@J@K@PGL@M@N@O@P@Q@R@SGS@T@U@TV@SGW@XPw@PGY@PGZSw@T[@\@]@^T0@_@:@hA$@C #AlB@?:AhB$@C # AlBA?:BhC$@C #AlBB?ChD@AC?#Dh*E @#BD?7EhF!@C  #K"BE?FhGAF?OGhH9@+Select a single node before using TreePlan.BvG?HhIAH?IhKB7I?J? KCdRKhL<C 'D9CC"NB`BK?RLhM<C 'E9CC"NB`BL?>MhN(C9CC"NB`M?7NhO! LastUsedNode9ALBXN?&OhPiCBO?3PhQ@NewNodeC|CgBXP?DQhR.AC9CCCg"NB`Q?>RhS(AC9CC"NB`R?cShTMAC 8 Alternative C9CC"NB`B~ SCBS?_ThUIAC 4Outcome C9CC"NB`B~ TCBT?<UhV&A9CC,"NB`U?QVhW;AC &9CC!"NB`BV?WWhXAAC ,C9CC!"NB`BW?>XhY(AC9CC "NB`X?=YhZ'AT9CC"NB`Y?<Zh[&A9CC"NB`Z?[J([h\@jB[?\JB\h],A9CCCz"NB`\?]J]h^@A]?^h_A^?W_h_A'C '!TreeData99ALC"NB=_h`CT A'C '!TreeData99ALC"NB=7TreeData99ALC"NB=B_?D0 lHHH+1E']'( n`LE4ARL{J_eLKJ@Z5'`T0@a@b@c@d@e@f@g@h@i@j@k@PGl@m@n@o@p@q@r@SGs@t@u@Tv@SGw@xPw@PGy@PGzSw@T{@|@}@~T0@@`hbB7`?a? bCebhcBWb?/chdi9ALBc?mdheWA99CgC"BN9CgCBN"NB1d?9ehf#A9CgC"NBme?fhg@B3f?mghhWA99CgC"BN9CgCBN"NB1g?9hhi#A9CgC,"NBmh?ihj@B3i?Tjhk>A99CgC BNCBNE BjRmkhlWA99CgC"BN9CgCBN"NB1kR9lhm#A9CgC!"NBmlRmhn@B3mRnho@AnRohpAoRphrB7pRqR rCf7rhs! LastUsedNode9ALBXrR.sht ObjectTypeBBXsR.thu ObjectCellBBXtR%uhwIsNodeBX uCuR vlvRKwhx5C C C C C B%B wCgwR+xhy@CurNodeBX xChxR4yhz@CsA&C*C| B$A yCiyRwzh{aA TestCellRef99C*C"BN9C*CBN"NBBXzRK{h|5@ TestCellRefCCA !CB|BtBX{R)|h}@CC B|R0}h~@  ActiveNode#*BX}R)~h@ IsNodeBX~Rh@ARD l( 8={G,{G,b{G,+'( S<<AgGPY7>7T0@@@@@OOOOOOO@OOOOOOO@OOOO@OPwO@O@SwOOOOT0OO1h@CurNodeC*BXOOOOOOO Rh@AOOOOOOO RhAOOOOOOO R"h Cs BOOOOOOO R6h @ SelectedNodeC*BXOOOOOOO RC#h* @#BCCRZCC"h C ACCRZCC4h@ EndPointCellBBXCCRZCC+h@IsBranchBXCCRZCC-h@ IsDiagonalBXCCRZCC.h@ IsConnectorBXCCRZC+h@CurNodeBXC  RZCDh.@CiA&ClA&CkA&C*C| B$AC  RZCwhaA TestCellRef99C*C"BN9C*CBN"NBBXC  RZCKh5@ TestCellRefCCA !CB|BtBXC  RZCBh,@CCN IsBranchBXBC  R[C{heA TestCellRef99C*C"BN9C*CBN"NBBXC  R[CKh5@ TestCellRefCCA !CB|BtBXC  ?[CDh.@CCN  IsDiagonalBXBC  ?[C>h(A9C*CBNT BC  ?[CjhTA  TestCellRef99C*C"BN9AM"NBBX C  ?[CKh5@  TestCellRefCCA !CB|BtBXC  ?[CEh/@ CCN  IsConnectorBXBC  ?[Ch@AC  ?[C1h@CurNodeC*BXC  ?[Ch@AC  ?[Csh]A TestCellRef99C"BN9CBN"NBBXC  ?[CKh5@ TestCellRefCCA !CB|BtBXC  ?[CBh,@CCN IsBranchBXBC  ?[CBh*,@#i#l#kB% #"BC  ?[ChAC  ?[ChB7C  ?[DlWC?H\YXjacZ_xvxryQeQvvMT0OOOOOOOOOOOO@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@O ChC  ?[ Cj7h! LastUsedNode9ALBXC  ?[C#h C| B  ?[C9h#@Ci # AlBC  ?[C9h#@Cl # AlBC  ?[C9h#@Ck # AlBC  ?[C#h* @#BC  ?[C7h*!@C  #K"BCCCCCCCC  ?[ChACCCCCCC  ?[COh9@+Select a single node before using TreePlan.BvCCCCCCC  ?[ChACCCCCCC  ?[ChB7CCCCCCCC  ?[ O?[O CkJh4 NewNumSucc9CCBNBX O?[O>h(C9CC"NB` O?[O7h! LastUsedNode9ALBX O?[O-hNewNodeC|BX O?[O>h(C9CC"NB` O?[Dh.C9CCC"NB` ?[>h(C9CC "NB` ?[zhd9CCBND 8 Alternative C9CC"NB`B ?[vh`9CCBNE 4Outcome C9CC"NB`B ?[<h&9CC,"NB`?<h&9CC!"NB`O?=h'T9CC"NB`O?<h&9CC"NB`O?J$hjBO?JBh,A9CCCz"NB`O?JhAO?Uh?'C '!TreeData99AL"NB=hCT ?'C '!TreeData99AL"NB=5TreeData99AL"NB=B?hB7O?O?DCl,oMmmmW[[fv\UKRVPJTUTFd;2T0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@O Cl*hBaseNode#BXO?1h NumNewNodes#"BXO?+hcListBXO?7h! LastUsedNode9ALBXO?)hNewNode#|BXO?&hiC|BO?<h&A9CgCBN BO?1h@NewNodeCBXO?>h(AC9CgC"NB`O?h@AO?<h&A9CgC"NB`O?h@AO?hAO?>h(C9CC"NB`O?Th>9CC"N9CC"NB2O?Th>9CC"N9CC"NB2O?@h*i9CCBNBO?vh`A99CCCgBNC"N9CCCg"NB2O?hAO?&hiC|BO?<h&A9CgCBN BO?=h'Ak9CgC"NBXO?>h(AC{9C{C"NB`O?Th>A9CgC"N9C{C"NB2O?Th>A9CgC,"N9C{C,"NB2O?Th>A9CgC!"N9C{C!"NB2O?jhTA99CgC BNC"N9C{C "NB2O?Th>A9CgC"N9C{C"NB2O?Th>A9CgC"N9C{C"NB2O?@h*Aj9CgCBNBO?vh`A 99CgCCzBNC"N9C{CCz"NB2?h@A?D3 lPICOA>TIV5T51VllX1>TUVlllllXT0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@ODh.Aj9CgCBNB?Bh,A 9C{CCz"NB`?h@A?h@A?hA?WhA'C '!TreeData99ALC"NB=hCT A'C '!TreeData99ALC"NB=7TreeData99ALC"NB=B?hB7?? CmhB`?7h!9C"NBa?Ch-CurNode9C C$"NBX?%hCountBX?#h DoneBX?!h CHA&A?4h@ AllSucMark#"BX?2h@# C*C B$B?'h@DoneBX?"h @C A?;h%A9C*C"NB`?/h@CountCBX?Ch-ACurNode9C*C "NBX?h@A?1h@CurNode#V"BX?h@A?hA?h #B7?? Cn7h! LastUsedNode9ALBX?-hNewNodeC|BX?@h*i9CCBNB?ZhDAC99CCCgBNC "NB`?hA?DX lRP++' ( 9EQ31/B@50I=Q+?+'- S;NhT0@O@O@O@O@O@O@O@O@O @O @O @O@ @O @O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@O>h(C9CC "NB`?>h(C9CC"NB`?0hC C B%B?Nh8A Alternative C9CC"NB`?<h&A9CC!"NB`?/hC C B%A?Jh4AOutcome C9CC"NB`?<h&A9CC!"NB`?h A?< h &9CC,"NB` ?T h >9CCBN9CC"NB` ?@ h *i9CCBNB ?` h JA9CCCgBN9CCCg"NB` ? hA ?JDh.i9CCBNB?JBh,A9CCCg"NB`?JhA?Th>9CCBN9CC"NB`?<h&9CC"NB`?Bh,C9CC"NB`?J$hiB?JBh,A9CCCg"NB`?JhA?_hIC C B%'D9CC"NB`B?_hIC C B%'E9CC"NB`B?Uh?'C '!TreeData99AL"NB=?hB7?? Co=h'D9CC"NB`?@h*i9CCBNB?XhBA99CCCgBNC!"NB`?h A?D lLL>\J=XJ'JbNn'\Z1bJP<Z1mmc( YNf T0@O!@O"@O#@O$@O%@O&@O'@O(@O)@O*@O+@O@,@O-@O.@O/@O0@O1@O2@O@3@O4@O5@O6@O@7@O8Pw@O@9@O@:Sw@O;@O<@O=@O>T0@O?@O h"B7 ?!? "Cp="h#'E9CC"NB`"?@#h$*i9CCBNB#?t$h%^A9CCBN99CCCgBNC!"NB`$?%h&A%?&h(B7&?'? (Cq>(h)(9CCBNTB(?.)h*@BaseNode#BX)?/*h+@Count#"BX*?=+h,'AT9CC"NB`+?<,h-&A9CC"NB`,?-J(-h.@iB-?.JB.h/,A9CCCg"NB`.?/J/h0@A/?#0h*1 @#B0?1h2A1?2h4B72?3? 4CrM4h57CCf 9CCBN A&B$A4?-5h6@LowCBX5?6h7A6?7h9B77?8? 9Cs/9h:High9ALBX9?#:h; LowBX:?1;h<CCf B7B;?;<h=%9CfCBN A<?#=h*> @#B=?>h?A>??h*@ #B??D{ l( YN'( Z<=KJ@Z51'( i;'( K1?I1'@T0@OA@OB@OC@OD@OE@OF@OG@OH@OI@OJ@OK@O@L@OM@ON@OO@OP@OQ@OR@O@S@OT@OU@OV@O@W@OXPw@O@Y@O@ZSw@O[@O\@O]@O^T0@O_@O$@hACCf A@?<AhB&A9CfCBN BA?#Bh*C @#BB?ChD@AC?#Dh*E @#BD?)EhF@CCf BE?TFhG>A 9CfC"N9CC"NB1F?TGhH>A 9CfC,"N9CC,"NB1G?THhI>A 9CfC!"N9CC!"NB1H?TIhJ>A 9CfC BN9CC "NB`I?TJhK>A 9CfCBN9CC"NB`J?TKhL>A 9CfCBN9CC"NB`K?LP(LhM@ iBL?`MhNJA 9CfCCgBN9CCCg"NB`M?CNhO-A 9CCCgBNBN?ZOhPDAC99CCCgBNC "NB`O?PhQ@ AP?QhR@ AQ?RP(RhS@ iBR?[ShTEA 99CfC BNCCgBNCf BS?ZThUDAC99CfC BNCCg"NB`T?UhV@ AU?VhW@ AV?#Wh*X @ #BW?;XhY%A 9CC"NB`X?YhZ@AY?Zh[@AZ?[h\A[?\h^B7\?]? ^Ct=^h_'9Cf"NBm^?_haB6_?D l2J1+17bbbbbb@nQh++@ih++1I++'( Y`T0@Oa@Ob@Oc@Od@Oe@Of@Og@Oh@Oi@Oj@Ok@O@l@Om@On@Oo@Op@Oq@Or@O@s@Ot@Ou@Ov@O@w@OxPw@O@y@O@zSw@O{@O|@O}@O~T0@O@O`?*ahbHighCfBXa?bhdB7b?c? dCuFdhe0SucNode9CC$"NAZBXd?.ehf SelectedNode#BXe?>fhg(9CCBNT Bf?#gh*h @#Bg?hhiAh?Tihj>A9CCBN9CC"NB`i?Tjhk>A9CCBN9CC"NB`j?@khl*Ai9CCBNBk?`lhmJA9CCCgBN9CCCg"NB`l?ZmhnDAC99CCCgBNC "NB`m?nho@An?7ohp!A9C"NBao?;phq%A9CC"NB`p?#qh*r @#Bq?rhsAr?shuB7s?t? uCvuh*v #Bu?Gvhw1PredNode9CC "NAZBXv?.whx SelectedNode#BXw?=xhy'9CCBN Bx?0yhz@ ActiveNode#BXy?#zh*{ @#Bz?{h|A{?)|h}@LevelBX|?Z}h~DAC99CC BNCC}BNA}?/~h@LevelC}BX~?h@A?D l 8( b<L1'bbNnh+EI1'( ;U<K>1'7h=T0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@O?h)AC}9CCBN B?Fh0AiC}9CCBNB?dhNA 9CCCgBN9CCCg"NB`?h@A?h@A?XhBA9CC9CCBN"NB`?XhBA9CCBN9CC"NB`?7h!A9C"NBa?;h%A9CC"NB`?#h* @#B?hA?hB7?? Cw$hSelOKBX?&hSelOptsBX?(h SelCancelBX?Ch-Y#B Al#BAlB?/h###B%A&A? h @BW?2h@ ResSelBox#ABX? h @BW?=h'@C SelOKBXB?@h*@C  SelCancelBXB??h)@C SelOptsBXB?Ch-@C #CbCd"B?hA?0hC #"B?hB7?? CxAh+C C B$ #"B?Ah*+C C B$ #"B?Ah+ C C B$ #"B?Dj lMTr++ffEI1'( @46Q=.@.KNMQ'>( ]OT0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@OhB7?4h)###"B? CyhBT7h! LastUsedNode9ALBX?2h)###"B'hSelTextBX?hBT#h C B?hB7*h@iC|B?ZhDASelTextCR[9CgC"BN]C[BX?Sh=ASelTextC9CgCBN],BX?h@A?hA?#h C B?*h@iC|B?ZhDASelTextCR[9CgC"BN]C[BX?Sh=ASelTextC9CgCBN],BX?h@A?hA?#h C B?*h@iC|B?Th>A99CgC BNCBNE B?ZhDA SelTextCR[9CgC"BN]C[BX?Sh=A SelTextC9CgCBN],BX?h@A?h@A?hA?#h C B?*h@iC|B?ZhDASelTextCR[9CgC"BN]C[BX?Sh=ASelTextC9CgCBN],BX?h@A?hA?#h C B?*h@iC|B?D l(BskQVha+'18ha+'18bha++'18ha+'1T0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@OZhDASelTextCR[9CgC"BN]C[BX?Sh=ASelTextC9CgCBN],BX?h@A?hA?#h C B?*h@iC|B?>h(A9CgCBNT B?Vh@A SelTextCR[9CgC"BN]C[BX?Bh,@ SelTextC9AM],BX?h@A?h@A?hA?&hCA  B?=h'@SelTextCCA BsBX?%h@9Bm?#h @#Bm?hA?hB7?? CzhBTh B?2h)###"B/h AllObjectsA_,BX?hBT'hSelTextBX?hB7Sh=  MaxNodeCol9C9AL"NBBX?7h! LastUsedNode9ALBX?%hCA  A?Ah+@CurObjC,CBRBsBX?Jh4@ AllObjectsCCA ,CBRBtBX?#h @#+Bm?2h@ ObjectTypeBBX?2h@ ObjectCellBBX?4h@ EndPointCellBBX?ZhD@C C B$"SelTextCC+,BXB?D lha+'18LdP++'4K31'( YsUE3OX1@@BT0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@OZhD@C C B$"SelTextCC+,BXB?ZhD@C C B$"SelTextCC+,BXB?4h@C C B$B?0h@CurNodeC|B?whaA  TestCellRef99C*C"BN9C*CBN"NBBX?Kh5@  TestCellRefCCA !CB|BtBX?Oh9@ CCN "SelTextCC+,BXB?h@A?h@A?4h@C C B$B?0h@CurNodeC|B?{heA  TestCellRef99C*C"BN9C*CBN"NBBX?Kh5@  TestCellRefCCA !CB|BtBX?Oh9@ CCN "SelTextCC+,BXB?h@A?h@A?4h@C C B$B?0h@CurNodeC|B?>h(A 9C*CBNT B?ehOA  TestCellRef99C*C"BNC"NBBX?Kh5@  TestCellRefCCA !CB|BtBX?Oh9@ CCN "SelTextCC+,BXB?h@ A?h@A?h@A?hA?&hCA  B?=h'@SelTextCCA BsBX?%h@9Bm?#h @#Bm?hA?hB7?DE lhhB>Y]++B>Y]++B>LsY]+++'4K31'T0@O@O@O@O@O@O@O@O@O @O @O @O@ @O @O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@OT0@O@O? C{hBT'hSelTextBX?2h)###"B5h RelTermCol9AMBX?hBT#h C B?hB79h#@SelTextC[C],BX?hA?^hH@RelColC  & "dBX?(h@CC A??h )@SelTextCC[C],BX?0 h @RelColCBX ? h @A ? h A ?9 h #SelTextCCA BsBX ?! h 9Bm ?h #Bm?hB7?? C|(hHelpLineBQ?#h #hC]Al?hBW?h@#\A?hBW?hB7?? l C~? l C? l C? l? l _? l? C}4hIsMacABsM BX C?h BT?D l cyQe'l6M>+'G/-( D1*,*( &&&&^ T0@O!@O"@O#@O$@O%@O&@O'@O(@O)@O*@O+@O@,@O-@O.@O/@O0@O1@O2@O@3@O4@O5@O6@O@7@O8Pw@O@9@O@:Sw@O;@O<@O=@O>T0@O?@O h! CqB ?(!h"@##B2!?("h#@##B2"?(#h$@##B2#?($h%@##B2$?(%h&@##B2%?(&h'@##B2&?('h(@##B2'?.(h)@ ColWidNodeBX(?.)h*@ ColWidDiagBX*h+A(+h,@##B2(,h-@##B2(-h.@##B2(.h/@##B2(/h0@##B2(0h1@##B2(1h2@##B242h3@ ColWidNodeQ?BX.3h4@ ColWidDiagBX4h5A5h6BT6h8B77? 8C%8h9OptsOKBX8?)9h: OptsCancelBX9?):h; OptsSelectBX:?P;h<:!UseExpUtilityBkA UseExpUtilityB=B;?C<h=-Y#Al#AlB<?P=h>:!MinimizeCostsBkA MinimizeCostsB=B=?C>h?-Y#Al#AlB>?*?j@ OptsChangedBX??Dl-6666666<2,,,,,,,82  A77^Q^Q@T0@OA@OB@OC@OD@OE@OF@OG@OH@OI@OJ@OK@O@L@OM@ON@OO@OP@OQ@OR@O@S@OT@OU@OV@O@W@OXPw@O@Y@O@ZSw@O[@O\@O]@O^T0@O_@O/@hA###B%A&A@? AhB @BWA?0BhC@OptsBox#ABXB? ChD @BWC?>DhE(@C OptsOKBXBD?AEhF+@C  OptsCancelBXBE?BFhG,@C  OptsSelectBXBF?CGhH-@C #C`Cd"BG?HhIAH?+IhJCB7BI?JhK CBJ?%KhL@#AlK?#Lh*M @#BL?7MhN!@C  #K"BM?NjO@B7N?OjPAO?1PhQC Y B$BP?'QjR@CT BQ?=RjS'@'C'!UseExpUtilityB=R?JSjT4@!ABkA'C'!AB=BS?JTjU4@!BBkA'C'!BB=BT?RUjV<@!RTBkA#'C'!RTmBB=BU?VjWj@!ScaledABkAL'C '!ScaledA*=exp(-Low/RT)/(exp(-Low/RT)-exp(-High/RT))B=BuWjX_@!ScaledBBkAA'C '!ScaledB=1/(exp(-Low/RT)-exp(-High/RT))B=BXjY@A0YjZ@ UseExpUtilityB==Zj['@!ABkAAB=B=[j\'@!BBkABB=BE\j]/@!RTBkARTmBB=Bs]j^]@!ScaledABkA?ScaledA*=exp(-Low/RT)/(exp(-Low/RT)-exp(-High/RT))B=Bh^j_R@!ScaledBBkA4ScaledB=1/(exp(-Low/RT)-exp(-High/RT))B=B_j`@AD l=.>.LOPQ'9-31E,'?5KXX`y!4AAIwl`T0@Oa@Ob@Oc@Od@Oe@Of@Og@Oh@Oi@Oj@Ok@O@l@Om@On@Oo@Op@Oq@Os@O@t@Ou@Ov@Ow@O@x@OyPw@O@z@O@{Sw@O|@O~@O@O.`ja@ OptsChangedBX0ajbC Y B$A=bjb'@'C'!UseExpUtilityB=lbjcV@CT ''C'!UseExpUtilityB= UseExpUtilityB=B.cjd@ OptsChangedBXdjeA1ehfC Y B$B=fjf'@'C'!MinimizeCostsB=lfjgV@CT ''C'!MinimizeCostsB= MinimizeCostsB=B.gjh@ OptsChangedBX0hjiC Y B$A=iji'@'C'!MinimizeCostsB=lijjV@CT ''C'!MinimizeCostsB= MinimizeCostsB=B.jjk@ OptsChangedBXkjlAlhm CB#mh*n @#B#nh*o @#B#oh*p @#BphqAqhsB7 s!sht #Al"thu C A uhv @BW vC"vh2@w @#Aw whx @BW8xh*y"@C  #"B2yhz@C B7BCzh{-@C #CaCd"B{h|A|h~B7 ~C~h CmB ~C%h@9Bm@ D2425242#'''3&$4.<6G?T0@O@O@O@O@O@O@O@O@O@O@O@O@@O@O@O@O@O@O@O@@O@O@O@O@@OPw@O@@O@Sw@O@O@O@O:h$@TreePlan Academic VersionB`"h @BDh.A99AM"NBBm6h @Only For Academic UseB`"h @B!h @B+hAh CwB%h@9BmMh7@,TreePlan Tryout Version, Only For EvaluationB`"h @BDh.A99AM"NBBm1h@www.TreePlan.comB`"h @B!h @B+Oh9A99AL9AM"NBBmYhC@8This Version Not Licensed For Commercial Or Academic UseB`"h @B!h @B+hAhBTh CmBth^@R&l&bTreePlan Academic Version, Not Licensed For Commercial Use&r&bwww.TreePlan.comBhAh CwB]hG@<&l&bThis Version Not Licensed For Commercial Or Academic UseB^hH@<&l&bTreePlan Tryout, Only For Evaluation&r&bwww.TreePlan.comBhAhBThB7@bD>&H:&%#)Q&H5&%S]&% #x#ab >@ggD& ThisWorkbook c __SRP_62J__SRP_7 @Sheet1Cd<fhNAPFFofKp4zx QO#ofKp4zfhNAPF ' 4PSLSS6"L <N0{00020819-0000-0000-C000-000000000046}(T*H "*\Rffff*9482a53e6*\R1*#b8*\R1*#20b$*\Rffff*1b482a5437@`|khit`|klui os$@ $8 $h $ $ $ $ @l @\ @L @< @0, @H @` @x @ @ @ @ @ @ @  @8| @Pl @h\ @L @< @, @ @ @ @ @0 @H @` @x @ @ @|  p@@phME  ""@ " HPX hxATreePlanXLM!Auto_OpenA@ritl8@A l 8Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |CreatablFalse ^PredeclaIdTru "@ExposeTemplateD0eriv$eCustomiz2 Option 0licit 0 P#' Sub _Ope@n() Call jeMe@nuItem Run ("TreePlanXLM!Auto"End*1Bef oreClu(Cancel As Boolean=Delet=,rU  A   1Y 4` `1? |'%'%'%'%'%'%'%'%' %'%',%'<%'L%'\%'l%'|%'%'%'%'%'%'%'%'%' %'%',%'<%'L%'\%:l%"$ 6>, |\L<, |l\L<$ \L<, |l\L<, |<   $ 44SrU @$`h()`l 9#p<n+F2}2nm F UKNBJLþx"8QV# UKNBJLþn+F2}2nm>4(SLSS6"N0{00020820-0000-0000-C000-000000000046}(T*H $*\Rffff*4148180ee6h($` $" $ $0 $"(TART $X $80@0ME xpAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |CreatablFalse PredeclaIdTru "ExposeTemplate`Deriv$eCustomizdOption /licit rU pa4Q){crU @prU~} #qA  __SRP_cY__SRP_d ]@Module1Menu6 __SRP_8^ 4T6 .B@0runA 7u<$8%:.& &>Cannot add Decision Tree item to Tools menu. Use Ctrl+Shift+T.A@>a IsTryout TreePlanXLM %4%$!&=TRUEIsEduc TreePlanXLM %4%$!&=TRUE Dn &!@%B.* *9DecisionTreeMain9FDecision &Tree...9H Ctrl+Shift+T5J(Lnh5''not Tryout and not Educ, therefore Standard version EIsTryout TreePlanXLM %4%$!&=TRUEFu Dn &!@%B.*mn() *9DecisionTreeMain9FDecision &Tree...9Hber = Ctrl+Shift+T5J(Ln Dn &!@%B.*eCol *DecisionTreeMain9FTreePlan Tryout Version9Hnh Dn &!@%B.* Set *DecisionTreeMain9FOnly For Evaluation9H Enh''IsTryout = TrueIsEduc TreePlanXLM %4%$!~ &=TRUE Dn &!@%B.* *9DecisionTreeMain9FDecision &Tree...9H Ctrl+Shift+T5J(Ln Dn &!@%B.* *DecisionTreeMain9FTreePlan Academic Version9Hn Dn &!@%B.*B *DecisionTreeMain9FOnly For Academic Use9Hn h''IsEduc = Trueh ''ToolsMenu exists ...lDecision &Tree...7u<$8%:%@B@NTreePlan Tryout Version7u<$8%:%@B@NOnly For Evaluation7u<$8%:%@B@N TreePlan Academic Version7u<$8%:%@B@N( Only For Academic Use7u<$8%:%@B@NlTreePlanXLM!tMainA@lPHʹAttribute VB_Name = "Module1Menu" Option Explicit Sub CreateItem()  Dim Tools0 As CommandBarPopup1JNewx 'Button(O}rror ResbuNexnA pa.Macros _9#:="DecisTreeMain", %HasShortcutKey:=True "T.MGoTo 0:Call DelFe Set=s(1).FindControl(Id:=30H007IfIs Nothin`g The{sgBox "Cannot addKF i $to m@{. Use Ctrl+Shift+T.9ElseI/!@@isWorkbook.Excel4\She ets("PlanXLM").IsTryout@Refers@O@=TRUE" AndfxEduc L8Ahɩ=].g8s.AV(Type:=msoD õpE With A .BeginGroupÁOnAcBP3ι Ca &y5..%>%bD.}`T p!IE$EE?`8 H X'''SA ` 6, therefore St ard vEx ' ThRRREElEEEoEE%8.E bEE!++qql i'e VXZf?L___ H@*.o>n t Only F0|Evalu{ CW CcQO@iO@sb"tibo*O8brbbb; yebgo@ xs  o@ NO0O0f@Academic@+Q?x`0?&x???q##q59@60 @:@ If" exists pS quu/%v(f3).3 )6%e_`_ _ ("Zn  (f / |$$7/[G.PPr@ocDataInvoke_Func'"T\n14+Run W LLLLL"LLL(T*H $*\Rffff*1b482a5437*\R4*#4d*\R4*#4c*\R1*#20b*\R1*#b8*\R1*#208*\R1*#a7*\R4*#48*\R4*#49*\R4*#4b*\R0*#11"*\Rffff*9482a53e6*\R1*#c1*\R1*#ac*\R4*#30*\R4*#4a `XXoOO\L &xXmp$ *@txba$  `0o Qdd D P` |kZ$P$`p(. 8>D@p @@` @XP @H@ @0 @ @ @ @ @ @ @0 @` @x @ @ @ @ @t p`$0 @l(`6 $` phX`$@(Hd`Ek$p.NDOWS\``$8\`1$ @X`$FC:\H8soft Shared\fi@x Offi@0h @d @T teMe@`D Menu@x4 Tree@$ @ @ Tr@ @ Termal@l lect@\ Deci@L Se@< @ , eSha@8 nchL@P @h ectD@ @ @ @ @ @ @ @( | @@ l @X \ @p L @ < @ , @  @ @ @ @ @0 @H @` @x @ @| PT 14 (MEa "  B`(p x b H+   $L        > >WX  $L         $L(  P X p    $L        <W(  $Lh         $L   (" @  h  $Lp          " (:t0@tp<tBt>t8x " xZ@Z`X  DecisionTreeMain2 1  Aa 1YII!LK` '%'%'%'%:@%cP%'%' %'0%:`%p"$ p p60 K b'%'%' %(P7u%'0%(`%p"$ dp H l= x)p60  lxc+''' :` N00 60 E:P %:`%p" $ p d0W :@]/:%:%" $  dW:]/Ą't)p60 \cL'%'%' %'0%`%px P p $l=t)p60  ltp p | p  p :`%pp pp pW:P %:`%p" $ p d0W :@]/)p60 \SL'%'%' %'0%`%px P p $l=t)p60  ltl l | l  l :`%pl pp lL'%'%' %'0%`%px P p $l=t)p60  lth h  h  hL'%'%' %'0%`%px P p $l=t)p60  ltd d  d  dW:P%:`%p" $ p d0W :@]/)p60 \CL'%'%' %'0%`%px P p $l=t)p60  lt` ` | `  ` :`%p` pp `L'%'%' %'0%`%px P p $l=t)p60  lt\ \  \  \L'%'%' %'0%`%px P p $l=t)p60  ltX X  X  X$LHE0 plhd`\Xtx@ p0 tPKt:%'%'$%'4%(T7u%'D%d(h%x"$ dx Hd  !)xd6 D4$t:%'%'$%'4%(T7u%'D%d(h%x"$ dx Hd  !)xd6 D4$t:%'%'$%'4%(T7u%'D%d(h%x"$ dx Hd  !)xd6 D4$t:%'%'$%'4%(T7u%'D%d(h%x"$ dx Hd  !)xd6 D4$t:%'%'$%'4%(T7u%'D%d(h%x"$ dx Hd  !)xd6 D4$P$ ,xdD4$|'%'%'%'%'%'%'%'%' %'%',%'<%'L%'\%'l%'|%'%'%'%'%'%'%'%'%' %'%',%'<%'L%'\%:l"%"$ 6>, |\L<, |l\L<$ \L<, |l\L<, |arU $`$`$`prU $`(`(`(`(!`__SRP_9 Module2Select__SRP_3f>__SRP_2|(0@P$SX 0q6z.M 8 HX`x  B$S 6|6zH.M    B(8$SH px0q4u6z6z0.Mh     B($S0 X`6|x0q.M  08P Xh Bpx$S 6|0q .MP x{VQOVP)8Z(> "LLL(T*H *\R1*#15d$*\Rffff*1c482a5437*\R1*#1fc"*\Rffff*9482a53e6*\R1*#c1*\R1*#ac*\R1*#20b*\R1*#b8hS Tx`(k`Vx Xtpun$+`@`@PkHQ$`lth`npj`pl`rh td8$+b`Pk*@$`lt`np`pl`rh tdl4$+d``LkH< Co$`lt=300`npan A`pllete`rh.Fin tdCont$``).De+f` Pk(QreeM$`ltnc =`npTree`pl Sub`rhVers tdd Wi$+hx`%Pkc $`lt `nphisC`pl `rhnion tdplumn$+j@`*Pkud Fu$`ltolum`npermi`plong,`rh Lon td8 Ran$ `.,kCoun`Vx= 3 `0khisC`lxRang`ntumns`pp `rls No thPSet $ dp $``Colu  Colu En  8 `2k ) As`lxColu`ntisCo`ppDim `rl Ter thActi$ d.Col$`` = 4 nNum   `5k `lx`nt`pp`rl th$ d $`` ` H h  `h8k `lx`nt`pp`rl th@ $ d` $``    x `0;k ##`lx`nt`p`l h $`d`H ` \ $ x X $`T P 8 X  `(>k ##5`lx`nt`pp`rl th0 $ dP $```     X`@(kX`Vx XtP$+``Bkk$`t`Cp l$+`HFk0{$`t`p l$+ `0Jk$`t`p l$+`Nk`$`Nt`p l$+`R0k$`t 8@ @ x XxxR$X@p0`bdfhj@p @` @\ @L @< @, @(  X@( `x$Z|~@T @pD @@ @0 @, @8 @ @ @  @h @P @ @ @ @ @ @ @t @d @(T @@D @X4 @p$ @ @ @ @ @ @ @ @0 @H @` @xt @d @T @P 'pHp bx$`p*Z|~@T @D @@ @00 @8, @ @p H0@ Pp0@ @ @ @ @ @( @@ @X @p @t @d @T @D @4 @$ @ @0 @H @` @x @ @ @ @ @ @t @ d @T @P p9Phx`H0  dx$<Z|~@(P @@ @< @, @ ( @X @ B@ B@@ @ @p @ @ @ @ @ @ @p @0` @HP @`@ @x0 @ @ @ @ @ @ @ @8 @P @h @ @ p @ ` @P @L N0!Hx`"!!h"!!! fx!$"!QZ|~@"T @ "D @8"@ @P"0 @X%, @" @" "h"W@ p%"W@" @# @# @0# @ @H# @`# @x# @# @#t @#d @#T @#D @$4 @ $$ @8$ @P$ @h$ @$ @$ @$ @$ @$ @$ @% @(%t @@%d @T @P "`X &@(&&h&& &P&@& hx8&$' &cZ|~@H'T @&D @&@ @&0 @), @x' @ ' 8'&i@ * 'i@`' @' @' @' @ @' @' @( @ ( @8(t @P(d @h(T @(D @(4 @($ @( @( @( @) @() @@) @X) @p) @) @) @)t @)d @T @P 'r *(++*+*** jx*$+*uZ|~@+T @@+D @X+@ @p+0 @x., @ , @+ ++{@ .+{@+ @, @ @8, @P, @h, @, @, @, @,t @,d @,T @-D @(-4 @@-$ @X- @p- @- @- @- @- @- @. @. @0. @H.t @`.d @T @P +X//p//@/0@/t @/d @` @P @/@ @0 @, /X8x200082X10p1Z|@1P @1@ @(1< @@1, @( @1 @1 1X1@  P21@1 @1 @ @2 @ 2 @ @`2 x282@O 2`2@2 @ 2`21(@pXP53335 4x384Z|@p4P @3@ @3< @4, @( @4 @H4 `4 4@  5H4@4 @4 @ @4 @4 @ @(5 @55@O 5(5@h5 @ 5(5H40 x 86p6X676@67Z|@87P @6@ @6< @6, @( @7 @7 (76@  77@P7 @h7 @ @7 @7 @ @7 87@O H87@08 @ X877H (  h :P989 9:999Z|@:P @h9@ @9< @9, @( @0: @9 99@  :9@: @`: @H: @x: @ @ @: ::@O ;:@: @ ;: 9   0 `  =<<;X=x<;<Z|@<D @0<4 @H<0 @`< @ @< @< <x<@ p=<@< @(= @= @@= @ @ @= =X=%@O >=%@= @= @= @ >=.<08  p X @?>>P@p?>?Z|@?P @(?@ @@?< @X?, @( @@ @?  ?p??@ h@??@? @? @ @ @ @8@ @ @x@ @P@G@O @x@G@@ @ @x@P?S8 ABA8BAPB@Ap @A` @\ @L @ B< @, @( 8B\HCxC`CC0C C xC$Ck|~@Ch @X @CH @C8 @C( @0F$ @C @D @ D @8D @PD @hD @D @D @D @D @Dt @Dd @ET @(ED @@E4 @XE$ @pE @E @E @E @E @E @F @F @ @ FPh80G`GHGFGG xG$F{|~@Gh @X @xGH @G8 @G( @J$ @G @G @H @ H @8H @PH @hH @H @H @H @Ht @Hd @HT @ID @(I4 @@I$ @XI @pI @I @I @I @I @I @J @ @ JKHK0KJKJ xJ$J|~@Kh @X @`KH @xK8 @K( @N$ @K @K @K @L @ L @8L @PL @hL @L @L @Lt @Ld @LT @LD @M4 @(M$ @@M @XM @pM @M @M @M @M @M @ @ hO0OONNN xN$N|~@xOh @X @HOH @`O8 @O( @Q$ @O @O @O @O @P @ P @8P @PP @hP @P @Pt @Pd @PT @PD @P4 @Q$ @(Q @@Q @XQ @pQ @Q @Q @Q @Q @ @ RRSSRRR xR$R|@p @` @0SP @HS@ @0 5 ME " 6O(`h p       B   B $S  8 @ 4uX 6| &C .M   0 @  H ` h  p  "  6O            ( 0 8 @ "H P ` x $S    4u 6| 6|H , .M 2  G   0 H  P  X h  p  (L  "   $S8 @H4u`6|6| ,.M8 h2 , G  @ H P` h x(L "$S0 8@4uX6|6| ,.M0 `2 , G 8 @ HX ` p(L " P(@$SPx  D6|6z  ,X.M 2 , G 8HX p     (L " (8Ph$Sx  D6|6zH ,.M 6|6z8 ,p.M2 , 8P`p      (L0 "8@Ph$Sx&C  4u6|0h 6| , 4T  2@ ,XG    ( 8(LX "6O   ( 0@ HX` B&C  *F   ( 8 @ X ` p x B   &C   *F  ! !0!8!P!X!h!p! Bx!!!&C! ! !*F! " "("0"H"P"`" h" Bp"x""&C" " "*F" # # #(#@#H#X#`# Bh#p#&Cx#*F## #xpZ@ZX ResSelBut TreePlanXLM %\%Z!^'V6 VHQ$`.XHQ$b.XHQ$d.XHQ$f.XHQ$h.XHQ$j.Xk XF XB@JgrlxZ1ZZ TreeData$Z!v!x 'nh.` l n l TreeData$Z%z!^'p l TreeData$Z%z!^ 'r p r TreeDiagram |%Z%z.t ` t.`a ` t$~.`h lBfh@ZZZTreeData$Z!v!x 'n.b l n0" l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r p r TreeDiagram |%Z%z.t b t.b #a( b t$~.bh l=fZPhcrZBAZTreeData$Z!v!x 'nY.d l n l TreeData$Z%z!^'  TreeData$Z%z!^E l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r p r TreeDiagram |%Z%z.t dX E t.dCa@ d t$~.dWDh h lfZ0HZ`x ZTreeData$Z!v!x 'nCUME.f l nVBE\MS l TreeData$Z%z!^ 'p l TreeData$Z%z!^'r p r TreeDiagram |%Z%z.t\m fOf t.fa f t$~.fxh lCreatefZZ(@TrZXTreeData$Z!v!x 'n.h l neePlan l TreeData$Z%z!^ 'p l TreeData$Z%z!^'r p r TreeDiagram |%Z%z.t h t.haX h t$~.hh8 lf xZZZ TreeData$Z!v!x 'n.j l n l TreeData$Z%z!^T l TreeData$Z%z!^ 'p TreeDiagram |%Z!!x'r p r TreeDiagram |%Z%z.t j t.ja j t$~.jhh lfx@Z ResSelBut TreePlanXLM %\%Z!^'V VHQA@HQA@ HQA@ HQA@ HQA@ HQA@klZZ 8ZXxTreeData$Z!v!x 'nZ' l n l TreeData$Z%z!^D l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r%''MsgBox CellRow & " " & CellColumn p r TreeDiagram |%Z%z.t  |! !! t!  ' @ ! +rh h l''MsgBox ShapeCount F  |!%ZB@Jgl0Z(@ZXpZTreeData$Z!v!x 'nZ' l n l TreeData$Z%z!^E l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r%''MsgBox CellRow & " " & CellColumn p r TreeDiagram |%Z%z.t''MsgBox ThisCell.Address  |! &''MsgBox ThisShape.TopLeftCell.Address !! t!  ' @0 ! +''MsgBox ThisShape.Namerh h l''MsgBox ShapeCount F  |!%ZB@Jgl88ZxZZ TreeData$Z!v!x 'nZ0 ' l n l TreeData$Z%z!^T l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r%''MsgBox CellRow & " " & CellColumn p r TreeDiagram |%Z%z.t''MsgBox ThisCell.Address  |! &''MsgBox ThisShape.TopLeftCell.Address !! t!  ' @ ! +''MsgBox ThisShape.Namer h h l''MsgBox ShapeCount F  |!%ZB@Jgl@  J''This procedure does not select the short branch before the initial node.Z  Z  ( ZH h TreeData$Z!v!x 'nZ ' l n>''If Range("TreeData").Cells(ThisNode + 1, 6).Value = "T" Then l TreeData$Z%z!^ 'p l TreeData$Z%z!^ 'r%''MsgBox CellRow & " " & CellColumn p r TreeDiagram |%Z%z.t''MsgBox ThisCell.Address  |! &''MsgBox ThisShape.TopLeftCell.Address !! t!  ' @ ! +''MsgBox ThisShape.Namerh h` ''End If l''MsgBox ShapeCount F  |!%ZB@Jgl Z 0 ZH ` x Z   Z  TreeData$Z!v!x 'nZ ' l n>''If Range("TreeData").Cells(ThisNode + 1, 6).Value = "T" Then l TreeData$Z%z!^ ' l TreeData$Z%z!^ '%''MsgBox CellRow & " " & CellColumn   TreeDiagram |%Z%z.''MsgBox ThisCell.Address l TreeData$Z%z!^ ' l TreeData$Z%z!^ '%''MsgBox CellRow & " " & CellColumn   TreeDiagram |%Z%z.  |! &''MsgBox ThisShape.TopLeftCell.Address !! ! !! !  ' @p ! +''MsgBox ThisShape.NamerPhH ''End If l''MsgBox ShapeCount F  |!%ZB@Jglx Z  Z   Z8 X TreeData$Z!v!x 'nZp TreeDiagram |%Z!!x'Z ' l n l TreeData$Z%z!^T l TreeData$Z%z!^ 'r r   l TreeData$Z%z!^ 'p%''MsgBox CellRow & " " & CellColumn p r TreeDiagram |%Z%z.t''MsgBox ThisCell.Address  |! &''MsgBox ThisShape.TopLeftCell.Address !! t!  ' @ ! +''MsgBox ThisShape.Namerh hh l''MsgBox ShapeCount F  |!%ZB@Jglx Z Z8 ResSelBut TreePlanXLM %\%Z!^'V V HQ$.XHQ$.XHQ$.XHQ$.XHQ$.Xk XF XB@JglxXZZ TreeDiagram |%Z!!x''   _  TreeDiagram |%Z%.  .a  $~.h  'fZ8PZh TreeDiagram |%Z!!x''   _  TreeDiagram |%Z%.  .a  $~.h  'fZZ TreeDiagram |%Z!!x''   _  TreeDiagram |%Z%.  .a  $~.h  'f ZhZ TreeDiagram |%Z!!x''   _  TreeDiagram |%Z%.  .a  $~.h  'fZ TreeDiagram |%Z!!x'  TreeDiagram |%Z%.f( Attribute VB_Name = "Module2Select" Option Explicit@Base 1 Sub \Cells() Dim$vButtonValue As` LongB\To;RangeP{ 9= ThisWorkbook.Sheets("TreePlanXLM").@("ResTwwS Cp _ jSet R= Branch w;2#hF(low3Probabilit y4RollbackEVCEU5$U6Terminal`FEndD If No XIshing|en_.n ubFuncfNod, LastUsedIRowA,!Column 7AJ= Ĥ!DataAows.Count ~-A /@FAA 0 For¾B)= 1 ToJ.a!A,= Int(s(@+ 1, 13).3@vbXw4_f#= A@4vevt"iagram`"-D`EM$,EQ)ElsO !/Un`(=,b1$AQIf Next4#TESTGTA>Th TTJ_Tk?c.;_TtLT + īT A>TCT"T$T)%UTTS"SfX#*ngoT** oTsQ, Predecesso&r24 +geUUm VaVtBR]a V5{VLZs]B06@ "E"@Fen#"KqQ@_5[5c *RC:`~_Q1 5DO`l 52O6CuZq +alsp c7=7ab b )8s1888887aJ! /7#70?c?6c_2_2V2f-C" %Z0 ,,@hD , a@͹ ,0?c13 ?= ,cкҷ/+)+++/tQ,5/bU++}ߍ  **d8 ?&?&X*Tq_X_Xݼ*VN*0s"TreeDiagram").C ells((Row, @Colu@mn) If RollbackEUts Is Nothing ThenNV(SetX=FisCpNElse1Union( v,HEnd If NextNodZFunct!C  TerminalValued() As RangDim" Long, LastUsed- ?  Th 5*=@(ata,s.Count - 1 _ =sor_= 1 T~o ^; .s()B9+ 1, 6).I"T"@y >= InLt(413D) GDM= A@mveSheet.GFGYJP\־ſRiG,CASub SelectShapes(k\chButtonAec!R!}Wor@kbook.9sCCPlanXLMa[PRes ` @b e Case$7 '7G)DexcisAX8AEventR9'M/10BranchLinX)b1y2a-[o@2m Conn4or=# bubA':";}$:_wŚge\!bwä<, I_owJATArrayúVariantJZ = 5F+0?ò9D?>e??U, 14'''Ms0gBox2\& ")" &X)(Sv1PaZQ0EachkR!eZ`}BsWQY^.TopLeftQ .Address (&Q1"!jRPm Perve ''Wdq?= Rp.Nam Exit K?ѐF_5 a  P <> 2Оsz t).J JXIs DShA@+LrIpeqCIng Ig<I II0+;JI" (AIGEIllaDNdeDI&IIIm|?4IIII7.Ew7K"%K_Ls?Oq?Ou L@"?Oϗ  `uhe`hOsDP ).S0elec@Sub ub BranchLinYs(+!= procedure does not sb the short b befoinitialde.Ǡb cdfeiggQ!o B"߭@C)x׭,%1-`=!! $֠{, 1~-ԯk<= %ȅ,d% IQn|'Vi]A0qD`p} V)VVHV_- 2 bH5t s Tae_YVauT"@V 0?eVt wVVt.gVayVVD*oVR&Rϐ|E4top1mlRBottom>gm,qWng(BrC1/WQ = /W!/Wf"M/(Wodqm\_W,W - 2I.Wm $<C|WW(WWw&bo? ( ^lB??=ogel7, Q/oookC!;okokPhi.shk#.Or _C Righ@TjP;o?F2WH@3alLineShapeArray(PCount) = ThisD.Name  '''MsgBoxRExit For End IfNextJc&Nod} If  <> 0Qen@ Activeet. s.Range(Diagon).Sel ect >Sub   Connor%() Dim]N As Long, LastUsed Cel0lRowColumV W3< ,z>$ >= x"TreeData"$). s.{ - 1ermiD"Number4 TQ=WWram@CSKQ)Var8ian@_7(= 80 GY@ T>oX:Qs(ATc+ 1, 6).Value"T"@enCA -Int(14) %H@Ra!"=z !3!́# & " " & #Setis?!i"=[s( , A"ea ag%].Addre ss>EachbB!pz .TopLeftAS @56@  iGeeXC RecP erve d)i$3"a1m߾*߾ξ#~aseionButtonÈ&󢛁`ToBe",Workbook@ s(bPlanXLM""Res @e CaseD c13dq=0sf = QZa=s4yte 15!9Branch6Right 7uXc@ANotLIsthing@'?lunonk!#a'x,Xy:C H_{e'_{xBO= 2@o WhHile < eD&eHOe-"|OPdes~ + 8.PcSElsخ Un5(89K3o+ 5LoopFd" 6o#$Io#3o#Jo##I20&)+= 0HDo#o#1o#b ?,s[]g#|#A1[#?alSs '#$o$ o$ f%o$Fj$V24 O&$$sqD$$$)$߲$P3$n$$ PPJ#Sc$$i!$H_<= $% %7hisColumnNumber = T + 4 Loop End Fun`ction<, RightBranchs() As Range Dim Terminal "Long,w;GTP= AveSheet.~("TreeDiagram").unt x= 1:o Wh(ileL `<"$ @ `<"$ @ `<"$ @ `<"$ @ `0"$ @0W4 "064  dD_*XhX"\< 04  ,S<'@%:P%"$  `<"$ @ Module3Shape__SRP_4__SRP_5_VBA_PROJECT!L<0<4<8<<<(T*H $*\Rffff*1d482a5437*\R4*#1f*\R1*#20b*\R1*#b8*\R1*#15d*\R1*#7b*\R4*#22*\R4*#0*\R4*#1*\R0*#10*\R0*#c X`0k`x`k  i!` h`dX($@H0||@t @p @l @x\ @`L @< @, @ @ @ nB@ h8 @l @` @\/ @PL @< @, @ @ @ XME( " 8=P +p  & @DD@@D@8FP&Sh _  B   "6   8@"0Hp xZ@  ! ! |!%B@JV@ !B@HQ  ( (  !!j(l? !!j(vl? !!(x | !!(z  !!(~J !!(v n !!(l !!!r(t$B !!!(B !$ (lPXZ! '(    $ Frg     'a     $' Terminal 'hpfh`Attribute VB_Name = "Module3Shape" Option Explicit Sub Trian gle()"Dim OriginalAs Sng ActiveSheet.As.Add(msoIsos celesV, 0_ =Cell.Left, Top, 12).S>clRe.IncrementRota-90#PlacxlMovetrintObjectTru'c6FiVVi0siblqFalsMTransparency/1 M-Line.WeighB00.75a Da`shStyBSolid iy .KUM$JEQE9ForeColor.Schf@GB8#Back R GB @(255<, «DTe4rm(K En d PrivaFun@'SSpPo si@Long,Length = (I =To 1ep -1If MiZd,j)'"@ " Theit ` Nexl 1^` C&  EfC + 1)-7`& " & ?If?@? rU~} A  !I AaQq iA<\%t"$ (taL%p"$ (pa<~%(, %( %l"$ @lW )tpl6L< =V@k\%t "$ tWLt5L+\%t "$ tt&c\%t "$ t t@\%t "$ tWLW< t6L<D\?%t "$ tWLW< t6L<D\?%t "$ tWLW< t6L<@\%t "$ tWLW< t6L<@\%t "$ tWLW< t6L<D\%t "$ tWLW< t6L<@\%t "$ tWLW< t6L<F(\%t "$ tWLW< W t6L< S^ i\%t "$ tWLW< W t6L< _t "$ tWL`< <%p "$ p/)tp6L<(x,tplL<  Jqdldhl\b1(,lhlML@ : ]/6,\Xb hg\"lhlhld FLl0ldlhi,lhlML@ l5,:Ll,l (l,frU $`(`0p      !"$%&'(*+,-./013ueCells8ThisNodeu LastUsedNodehCellRowl~ CellColumnmThisCell"RowsUCount0vCells ActiveSheet%NUnionPredecessorNodeColumnsp9 (SelectShapesl(SelectDecisionNodeShapesn(SelectEventNodeShapes:J(SelectTerminalNodeShapesy(SelectBranchLineShapesi'(SelectDiagonalLineShapes(SelectConnectorShapesc ThisShape Shape ShapeCount5DecisionNodeShapeArray>Shapes< TopLeftCellVAddressEventNodeShapeArrayiTerminalNodeShapeArrayԎBranchLineShapeArrayJ TopCellRow TopCellColumnTopCell BottomCellRowABottomCellColumn\n BottomCellDiagonalLineShapeArrayBottomRightCellFTerminalColumnNumberConnectorShapeArrayl (SelectColumns (NodeColumnsG[(DiagonalColumns3(LeftBranchColumns S(RightBranchColumnsv(TerminalValueColumnسThisColumnNumber ThisColumniD Module3Shape”(TrianglewAddShape,msoShapeIsoscelesTriangle ActiveCellTop5 SelectionZ ShapeRangeIncrementRotationw PlacementIxlMove37Workbookk BeforeClose~;Itemz WorksheetModule1b_Defaultj OriginalName _B_var_FunctionO TerminalNameOriginalLength?NumberStartPositionpv _B_var_doSearchCharacterFindn _B_var_FindUPosition _B_var_ForjL _B_var_Next'opostionWorksheetFunction& _B_var_IfP SpacePositionu_B_var_Position _B_var_whileIf _B_var_Midp IsTryoutCopy SubMenuItem0V BeginGroupIsAcademicCopyG_B_var_IsTryoutCopy_B_var_IsAcademicCopyJ TreePlanXLM istryout_B_var_TreePlanXLM>NamesοRefersTo _B_var_EndF Worksheets_B_var_SubMenuItemGMenuEnd_B_var_MenuEndA _B_var_WithYExcel4MacroSheetsɷModule4Watermark VersionNumberdURLTryoutNotLicensediTryoutLeftFooterIAcademicLeftFooter@WatermarkCells(WatermarkSheet*SensItSheetCaption RightColumnChartBottomRowBFontUBoldSizeHorizontalAlignmentS@xlRighteWatermarkPrintouty PageSetup PrintAreaP LeftFooter RightFooter|S LeftHeaderZoomFitToPagesWideFitToPagesTallZTreePlanSheetCaptiongFill,VisiblemsoTrue Solidc ForeColor SchemeColorx TransparencyWeight1 DashStyleb  msoLineSolidBStylep msoLineSingle BackColorރ PrintObject!msoFalseF.TryoutOnlyEvaluationbRelativeRightColumn]RelativeBottomRow E _B_vara^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dll#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.2#0#C:\Program Files\Microsoft Excel 97\Office\EXCEL8.OLB#Microsoft Excel 8.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\system32\stdole2.tlb#OLE Automation*\G{B6546FA1-B158-450A-986B-B92A57EB4D1F}#2.0#0#C:\WINDOWS\system32\MSForms.TWD#Microsoft Forms 2.0 Object Library *\G{8DD3D104-FA12-4687-894D-31196211A559}#2.0#0#C:\DOCUME~1\MIKEMI~1\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M &*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.0#0#C:\Program Files\Common Files\Microsoft Shared\office11\mso.dll#Microsoft Office 8.0 Object Library <Decision Tree Add-In for Excel(T*H QThisWorkbook 9482a53e6*DO0' Sheet1 4148180ee6*D#VModule1Menu 1b482a5437*D$0eModule2Select 1c482a5437*DROHModule3Shape 1d482a5437*D6`J x0H` :Ke^18LE$ٌ&Hq=~r='C@N]*IDLpcN-<hPF As=Dim@DoDElseUFor_GoTo`IfyLongzLoopNotSetStepThenToTrueWhileWith Excel+ VBAWin16~Win32Mac TreePlan stdole`MSFormsCOfficeu (ThisWorkbook| _Evaluate Workbook_Open(CreateMenuItemRun_Workbook_BeforeCloseCancel(DeleteMenuItem,g Sheet1 Module1Menu ToolsMenu`wCommandBarPopup  NewMenuItemCommandBarButton9 Application* MacroOptions^MacrocHasShortcutKey! ShortcutKey$ CommandBars  FindControl mId]MsgBoxRControlsKAddrmsoControlButtonnOnActionCaptionxControl ShortcutTextފDeletex(DecisionTreeMain>n Module2Select (SelectCells4SelectionButtonValuey CellsToSelectqRange Sheets ValueK(BranchNameCells3? (CashFlowCells֬(ProbabilityCells }(RollbackEVCECellsHk(RollbackEUCells(TerminalVal_Sub TreeRange _B_var_Set_B_var_TreePlanSheetCaptionAcademicTopLeftCell AcademicOnlyEAcademicNotCommercial! RefersToRange CenterHeaderD RightHeader CenterFooter #% S   Z@ A @Bdir__SRP_03__SRP_1PROJECTwm0* pHdTreePlan4Deci sion , Add-In for Excel@<Fecison Tr&eAd-Ifo Ex1el?h=   (T*H %q9stdole>(stioSe( h+^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\system32\22.tlb#OLE Auto8mat0MSForms>SFvm/| rGB6546FA1-B158-450A-986B-B92A57EB4D1FG4.TWD#Microsoft > b Object Library:(0 (8DD3 D104-)2-4687-894D-311962@11A559(DOCUME~1\@MIKEMIL OCALSTemp\VBE\E-exdf-.E .`0M ~Offic~Of@i 012DF8D04C-5BFA-10"1YDE5~AA}421Program Files\CommYShared\o 11\ms`o.dll4& (8.0bB"QBThisWorkbookN24T@AWkbAokHB1' @,BO""+gShePet1h2bSE e xt1  A V Module1Menu "2 xM dubv1eu0e!" #2Sel `@ D22u!t0/O+#3Cpe7)73hap,M7J-,6rU~~~~w aRGB ResSelButRangeValue TreeData TreeDiagramCells EColumnsCount D9DFFn+F2}2nm F UKNBJLþDF WorksheetWatermarkCellsWatermarkPrintoutFontBold www.DecisionToolworks.comSize HorizontalAlignment 8This Version Not Licensed For Commercial Or Academic Use &"Arial,Bold" :TreePlan Academic Version, Not Licensed For Commercial Use &10 &14 ,TreePlan Tryout Version, Only For Evaluation 0TreePlan Academic Version, Only For Academic Use www.TreePlan.com PageSetup LeftFooter RightFooter LeftHeader RefersToRange  CenterHeader RightHeader CenterFooterModule1dule1Menu Module2SelectSheet1Module4WatermarkTreePlanF=   Decision Tree Add-In for ExcelT 14 y  OriginalName yCancel y( ya8WatermarkSheetTreePlanSheetCaption RightColumnChartBottomRow9  QThisWorkbookThisWorkbookSheet1Sheet1Module1MenuModule1MenuModule2SelectModule2SelectModule3ShapeModule3ShapeӍFM1bID="{7726B8ED-677B-4AE9-A17E-D9F9B6C2AD6E}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Module1Menu Module=Module2Select Module=Module3Shape HelpFile="" Name="TreePlan" HelpContextID="0" Description="Decision Tree Add-In for Excel" CMG="030136C931CD31CD30CE30CE" DPB="020037CA3FD33FD35B52A384A7C6E89856" GC="0103343935393539" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H000000PROJECT`SummaryInformation(#PDocumentSummaryInformation8)CompObj2f00 [Workspace] ThisWorkbook=104, 195, 881, 850, Sheet1=0, 0, 0, 0, C Module1Menu=0, 0, 0, 0, C Module2Select=0, 0, 0, 0, C Module3Shape=0, 0, 0, 0, C e IncrementRotation Oh+'0  X`x  TreePlan 1.72xMichael R Middleton(TreePlan Decision Tree Add-In for ExcelMike MiddletonoMicrosoft Excel@Vm@? @K)^rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CMjAlY  a )a )Aa a 1a ai  1 a ! Y I ! Q a a iyiI ThisWorkbook Module3Shape Module1Menu Module2SelectSheet1Module4WatermarkTreePlanF=C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.dllVBA  Y(F5C:\Program Files\Microsoft Excel 97\Office\EXCEL8.OLBExcel a80FC:\WINDOWS\system32\stdole2.tlbstdole  QHoTX Ek*WMC:\WINDOWS\system32\MSForms.TWDMSForms 1X.E .`M ӍFM1bY 2C:\DOCUME~1\MIKEMI~1\LOCALS~1\Temp\VBE\MSForms.exd 1hL-[DR?C:\Program Files\Common Files\Microsoft Shared\office11\mso.dllOffice ixCreateMenuItemDeleteMenuItemDecisionTreeMain F TreePlanXLM!tMainF  SelectCellsBranchNameCellsFF CashFlowCellsProbabilityCellsRollbackEVCECellsRollbackEUCellsTerminalValueCells SelectShapesSelectDecisionNodeShapesSelectEventNodeShapesSelectTerminalNodeShapesSelectBranchLineShapesFSelectDiagonalLineShapesSelectConnectorShapes SelectColumns NodeColumnsDiagonalColumnsLeftBranchColumnsRightBranchColumnsTerminalValueColumnTriangle TerminalNameShapesAddShapeSelect ShapeRange IncrementRotation PlacementName VBA332.DLL !x    Terminal fhNAPFFofKp4zDFWorkbook Workbook_OpenWorkbook_BeforeClose @ Decision &Tree... F FControlsDelete TreePlan Tryout Version Only For Evaluation TreePlan Academic Version Only For Academic Use TreePlanXLM!Auto_Open T DecisionTreeMainF  F !S ! >Cannot add Decision Tree item to Tools menu. Use Ctrl+Shift+T. IsTryout TreePlanXLMFNamesRefersTo =TRUE IsEduc F F F Ctrl+Shift+T ShortcutText3(rJC['/ 6 18mQC1M3C?,- 1H PrintObjectFillVisibleSolid ForeColor SchemeColor TransparencyLineWeight DashStyleStyle !L X BackColorm՜.+,D՜.+,H PXt | Decision Toolworkse1 Empty TreePlanXLM  WorksheetsExcel 4.0 Macros(T\h_PID_LINKBASE _PID_GUIDAAN{15C4D1E8-1D0C-4D0E-A2DB-3D9B4551C40F} FMicrosoft Excel WorksheetBiff8Excel.Sheet.89q