ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FE3tcWorkbook: _VBA_PROJECT_CUR"87;8Tm;8VBA ;8@^;8  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_abcdeghijlmnopqrstuvwxyz{|}~_button9# Cancel_button9! CategoryMaximumL! CategoryMinimum#  ComputeRanges:& ContentsText;  CopyInputs:)% CreatePlotChart:% CreatePlotTable:#  DoBestOutputs:y% DoLikelyOutputs:q& DoOutputHeadings:M"  DoPlotLabels:$ DoWorstOutputs:e!  FormatSheet: h:' " HelpText; InitPlot:1input`V102025)input`W13  ModelSheet: MultCols  MultOutCells#  MyCreateChart:$ Newbook_button9$Newbook_button9 % Newsheet_button9!%Newsheet_button9"  NonContig NumVars: ObjectID: OutputLabelFperc`(\0.570.690.810.931.05iperc` \ 0.50.60.70.80.911.11.21.31.41.5 PlotButtonHandler PlotInputLabel$ PlotModelSheet:"  PlotObjectID: PlotOutputLabel% PlotReportSHeet:  ;6  ;0' ProcessPlotNewBookButton( ProcessPlotNewSheetButton) ProcessPlotThisSheetButton!  ReportSheet:' RestoreInputCells:. ScaleSmartVBA.ScalePlotCategory+ ScaleSmartVBA.ScalePlotValue) ScaleSmartVBA.ScaleTornado#  SensInputCell:  ɀ Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&Window\pMichael R Middletonn Ba=2  ThisWorkbook߯=%a8=@"1Arial1Arial1Arial1Arial1Arial1* MS Sans Serif1.Times New Roman1* MS Sans Serif1.Times New Roman1Arial1Arial1Tahoma"$"#,##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.0000000 0.0000 0.000000 0.00000 .00% 0.00000000 0.000000000 0.0000.0 0.0%=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) "$"#,##0                + ) , *         ! !    ("@ @    ("@      "8   "@  " @  !8"@   (" @  ("@ !8"@ )8"@  "@ 8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\` `Binsc OverwriteiSensItContentsDialogBoxnSensItHelpDialogBoxt HelpFiles SensItHelpVBAݷSpiderMainDialogBoxSpiderNewLogicSpiderErrorCheckR ScaleSmartVBA SpiderVBA0 SensitXLM9PlotMainDialogBoxFVPlotVBAVPlotErrorCheck$W PlotNewLogicWTornadoMainDialogBoxYsTornadoNewLogics TornadoVBA7tTornadoErrorChecktTryoutDialogBox TryoutVBAӆ AutoOpenSubBEducProfTryout AutoCloseSub    BaseCaseValue& bin;  ButtonPlotOK ButtonSpiderOK ButtonTornadoOK CalcMode#  Cancel$ SensInputLabel: $ SensOutputCell:" % SensOutputLabel: $ SensStartValue:%   SensSteps#  SensStepValue:' #  SensStopValue:) #  SetLikelyCase:b" SpiderButtonHandler( SpiderVBA.Newbook_button1) SpiderVBA.Newsheet_button1* SpiderVBA.Thissheet_button1 StartPlot:" StartTornado:  Step#  tempBestCases: $ tempInputCells: % tempInputLabels: % tempLikelyCases: $ tempOutputCell: % tempOutputLabel: $ tempWorstCases: & Thissheet_button9P# TornadoButtonHandler) TornadoVBA.Newbook_button1* TornadoVBA.Newsheet_button1+ TornadoVBA.Thissheet_button1" TryoutButtonHandler  UnequalRows  ValueMaximumu$ ValueMinimum VarCount H x3  @@   XHelpTextSENSIT ContentsTextSensIt Arial Reg 10 InstallationCW50Sensitivity Analysis Add-InOverviewPlotfor Windows and MacintoshPlot Input VariablePlot Output Variable9To run SensIt, start Excel and open the SensIt.xla file. Plot Input Values7SensIt adds a Sensitivity Analysis command to the ToolsSpiderSpider Input Variables.subcommands: Plot, Spider, Tornado, and Help.Spider Output VariableSpider Input Changes********************TornadoTornado Input VariablesTornado Output Variable INSTALLATIONTornado Input ValuesTryout License&Here are three ways to install SensIt:Professional LicenseEducation License8(1) Start Excel, and use Excel s File | Open command to(SensIt Purchase by web using credit card3open the SensIt.xla file from floppy or hard drive.*SensIt Purchase by postal mail using checkWarranty4(2) Copy the SensIt.xla file to the Excel | Library About SensIt>subdirectory of your hard drive. Start Excel, and use Excel s4Tools | Add-Ins command to load and unload SensIt asneeded. help textblank4(3) Copy the SensIt.xla file to the Excel | Startup?subdirectory of your hard drive, in which case the file will be"opened every time you start Excel. asterisksBAll of SensIt s functionality is included in the SensIt.xla file. -There is no separate setup file or help file. contents itemTo uninstall or delete SensIt:;(A) First, use your file manager to locate SensIt.xla, and%delete the file from your hard drive.>(B1) If SensIt is listed under Excel's add-in manager and the<box is checked, when you start Excel you'll see "Cannot find<..." Click OK. Choose Tools | Add-Ins, uncheck the box for>SensIt; you'll see "Cannot find ... Delete from list?" ClickYes.>(B2) If SensIt is listed under Excel's add-in manager and the<box is not checked, start Excel and choose Tools | Add-Ins. =Check the box for SensIt; you'll see "Cannot find ... Deletefrom list?" Click Yes.OVERVIEW0Before using the SensIt options, you must have a9spreadsheet model with one or more inputs and an output. 8All three SensIt options make it easy for you to see how1sensitive the output is to changes in the inputs.7Use SensIt s Plot option to see how your model s output.depends on changes in a single input variable.9Use SensIt s Spider option to see how your model s output6depends on the same percentage changes for each of themodel s input variables.:Use SensIt s Tornado option to see how your model s output;depends on ranges you specify for each of the model s input variables.PLOTPLOT INPUT VARIABLE=Plot Input Variable s Cells: Option: In the Label edit box,=type a cell reference, or point to the cell containing a text>label and click. Required: In the Cell edit box, type a cell:reference, or point to the cell containing a numeric valuethat s an input to your model.PLOT OUTPUT VARIABLE>Plot Output Variable s Cells: Option: In the Label edit box,?reference, or point to the cell containing a formula that s theoutput of your model.PLOT INPUT VALUES8Plot Input Values: Type numbers in the Start, Step, and9Stop edit boxes to specify values to be used in the input2variable s cell. Cell references are not allowed.<Send Output To: Select the destination for the output table9and chart. If you send output to This Worksheet, enter a=Cell reference for the top left corner of the output. Output=options are not available on the Macintosh; output is alwayssent to a new worksheet.<Click OK: SensIt Plot uses the Start, Step, and Stop values:to prepare a table of values. Each value is copied to the;input variable cell, the worksheet is recalculated, and the?value of the output variable cell is copied to the table. (You>could do this manually using the Edit | Fill | Series and Data9| Table commands.) SensIt Plot uses the input and output>values to prepare an XY (Scatter) chart; optionally, the text>in the label cells you identified are used as the chart s axis<labels. (You could do this manually using the ChartWizard.)SPIDER;model s input variables. Before using Spider, arrange your7model input cells in adjacent cells in a single column,:arrange corresponding labels in adjacent cells in a single9column, and be sure your model s input cells contain base case values.<For example, if your model has five inputs, the names of the<five inputs could be text in A1:A5. The input cells of your3model could be numbers in B1:B5; when you change a6number in one of these cells, the output of your model9changes; enter base case values in the input cells B1:B5before using Spider.SPIDER INPUT VARIABLES9Spider Input Variables Ranges: Labels edit box: Type a7range reference, or point to the range (click and drag)6containing text labels. Cells edit box: Type a range:reference, or point to the range containing numeric values;that are inputs to your model. Each range must be adjacentcells in a single column.SPIDER OUTPUT VARIABLE=Spider Output Variable s Cells: Label edit box: Type a cell;reference, or point to the cell containing a text label and>click. Cell edit box: Type a cell reference, or point to the:cell containing a formula that s the output of your model.SPIDER INPUT CHANGES9Spider Input Changes (%): Type numbers in the Start (%),8Step (%), and Stop (%) edit boxes to define the percents=that will be multiplied times the current value in each input:Click OK: SensIt Spider uses the Start (%), Step (%), and=Stop (%) values and the original (base case) numeric value in9each input variable cell to prepare a table of percentage>change input values. For each input variable, all other input9values are set at their base case values, each percentage<change input value is copied to the input variable cell, the6worksheet is recalculated, and the value of the outputAvariable cell is copied to the table. The output variable values8are also expressed as percentage change of the base case6output value. SensIt Spider prepares two XY (Scatter):charts; the horizontal axis is percentage change of input:variables; the vertical axis is model output value on one8chart and percentage change of model output value on the?other; the input variables labels are used for chart legends.TORNADO:variables. Before using Tornado, arrange your model input3cells in adjacent cells in a single column, arrange:corresponding labels in adjacent cells in a single column,;and arrange Low, Base, and High input values for each input=variable in three separate columns. Alternatively, the three9columns containing input values can be worst case, likelycase, and best case.9changes. The Low input values could be numbers in D1:D5,9chosen as the minimum possible value you think each input:variable could be. The Base input values could be numbers:in E1:E5, chosen as the most likely v<alue for each input; 2you might also have these same numbers in B1:B5 as=current inputs to your model. The High input values could be6numbers in F1:F5, chosen as the maximum possible value)you think each input variable could be. TORNADO INPUT VARIABLES:Tornado Input Variables Ranges: Labels edit box: Type aTORNADO OUTPUT VARIABLE>Tornado Output Variable s Cells: Label edit box: Type a cellTORNADO INPUT VALUES9Tornado Input Values Ranges: In the Low, Base, and High9edit boxes, type a range reference, or point to the range;(click and drag) containing numeric values for each of yourmodel s inputs.;Click OK: For each input variable, SensIt Tornado sets all<other input values at their Base case values, copies the Low8input value to the input variable cell, recalculates the>worksheet, and copies the value of the output variable cell to8the table; the steps are repeated using each High input<value. For each input variable, SensIt Tornado computes the9range of the output variable values, sorts the table from8largest range down to smallest range, and prepares a barchart.TRYOUT LICENSE9Decision Support Services grants a license to prospective<purchasers to use the Tryout version for a 15-day evaluation0period. You can download the Tryout version from3www.decisiontoolpak.com. Please share copies of the:Tryout version freely with prospective purchasers. You are7granted permission to make as many copies of the Tryoutversion as you wish.=If you want to continue using the software after 15 days, you8must purchase a Professional or Education license. Visit1www.decisiontoolpak.com for ordering information.:Instructors who require their students to use the software<must obtain an Education license, either by using a textbook;that has a license or by purchasing a license from Decision*Support Services info@decisiontoolpak.com.PROFESSIONAL LICENSE;If you have purchased the Professional version, the license5allows you to use one copy of the software on any onecomputer at any one time.EDUCATION LICENSE:Decision Support Services has granted a license to certain;textbook publishers to include the Education version with a9specific edition. According to such an agreement with the3publisher, the Education version is for use only by>instructors and students who are using a specific edition of a&textbook covered by the license. Visit0www.decisiontoolpak.com for a list of textbooks.<universities, schools, departments, and instructors to allow4students to use the Education version. The Education8version is for use only by instructors and students in a9specific university, school, or department covered by the;license. To purchase an Education license, contact Decision-Support Services at info@decisiontoolpak.com.(SENSIT PURCHASE by web using credit card9You can order with VISA, MasterCard, American Express, or;Discover credit card from our order-taking service, DigiBuy(Maagnum Internet Group).<Use your internet browser to visit www.digibuy.com directly,,or visit www.decisiontoolpak.com for a link.: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 information9securely or (b) you will be able to order by fax or phone8without placing your credit card number on the internet.4DigiBuy will notify us, and we will mail you printed2documentation and a disk with the latest version. =If you have any questions about the status of the shipment of*your order or about refunds, contact us atorder@decisiontoolpak.com.*SENSIT PURCHASE by postal mail using check6Alternatively, you can order with money order or check:directly from Decision Support Services. In January, 2000,6the price of SensIt Professional is $29.00 (California9residents, add sales tax) plus $4.00 shipping to U.S. and7Canada, $6.00 elsewhere. Make money order or check (in4U.S. funds drawn on a U.S. bank) payable to DecisionSupport Services, and mail to:Decision Support Services2105 Buchanan Street, #1San Francisco, CA 94115WARRANTY:Users of SensIt must accept this disclaimer of warranty: 1SensIt 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 Decision3Support Services assume no liability for indirect, :consequential, or incidental damages which may result from6the use or misuse of SensIt. Some states do not allow<the exclusion of the limit of liability for consequential or9incidental damages, so the above limitation may not apply<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.2the evaluation period, purchase fee, and support. ABOUT SENSIT7SensIt for Excel was originally developed by Michael R.9Middleton of the University of San Francisco and James E.9Smith of Duke University. Thierry Crifasi and Renu Gupta-provided assistance with subsequent versions.5Please send comments about SensIt and suggestions forimprovements to: Michael R. Middleton University of San Francisco 2130 Fulton Street San Francisco, CA 94117# Internet: middleton@usfca.edu6SensIt for Excel is copyrighted material. For license&and distribution information, contact: Decision Support Services 2105 Buchanan Street, #1 San Francisco, CA 94115 Voice/Fax 415-673-6217# http://www.decisiontoolpak.comMichael R. MiddletonTornado init/resultname ModelSheet $A$4:$A$13tempInputLabels $B$4:$B$13tempInputCells$A$18tempOutputLabel$B$18tempOutputCell StartTornadoNumVars $D$4:$D$13tempWorstCases $E$4:$E$13tempLikelyCases ReportSheet $F$4:$F$13 tempBestCases$A$3SensInputLabel$B$3 SensInputCellEmptyReferences$A$8SensOutputLabel$B$8SensOutputCellSensStartValue SensStepValue CopyInputs SensStopValue 6/19/1997DoOutputHeadings SetLikelyCaseDoWorstOutputsDoLikelyOutputs DoBestOutputsRestoreInputCells ComputeRanges MyCreateChartObjectID FormatSheetPlot PlotModelSheet StartPlotInitPlot DoPlotLabelsCreatePlotTableCreatePlotChart PlotObjectID)for Microsoft Excel 97 and later versions School of BusinessGSensIt for Excel 1.13Copyright 2002BAll Rights Reserved 2002-07-303SensIt 1.13 is like 1.12 with Excel 97 compilation.0menu. The Sensitivity Analysis command has fourR {`h_ 6l?"r#%5t& ܷ(. *F ,@.80q 2lO4/6RH8t:h<'>B@3ByC?EF 0soH 0J KNM N@|P\R7TU<V]WNW5>XXYY Zx*0* ZOS0ht00XkDn w5=tw0n00 0000Ot0VarCountimumHandlert_button1ory3=euw:< 0w8?6=?@0sT0xw ?=H=3=w0sT0L wXk wwcwbw9@Tw0Wx0RT0,LC[{0AT0Lw0лr062010y0 X+08<nx0=alue for each input; 2you might also have these same numbers in B1:B5 as=current inputs to your model. The High input values could be6numbers in F1:F5, chosen as the maximum possible value)you think each input variable could be.  ɀ  a_c  dMbP?_*+%&A Page &P"d,,??U}  T0(, $@?*@@0@@4@@:@@@@@D@@I@$@P@$@ T@$@>@ Sheet1 ɀ d  dMbP?_*+%i&A Page &P"P??U(  r  0Đ@A@7]@Đ !<"SensIt 1.13 Education - Overwrite< !ll  s *8?!]8 $ <OK< ll  s *?(2]T $<Cancel< rr  0 @A@.%]@  M<NOutput will overwrite non-empty cells. Press OK to overwrite cells in range:< M  Hl@A@Filename6n]@l )<*[Sensit.0625.1820.xls] Sheet4! $I$1:$L$16< )>"@ ɀ j  dMbP?_*+%i&L&F &A&R&D &T&?'?"d??UT <(  r  0̕@A@ 2"]@̕  %<&SensIt 1.13 Education - Help Contents< %rj  0@A1]J   9   B?Index_OK!]p $ <OK<   Jl?Index_Cancel%0!]l@ $ <Cancel< >"@ ɀ o  dMbP?_*+%i&L&F &A&R&D &T&?'?"d??Ur0Z( FFFG  r  0̚@A@K&]@̚ <SensIt 1.13 Education - Help< rj  0@AJ %]JL  9  F?Help_Close4"D%] $ <Close<   dl?4RiskSimHelpContentsButton"&%]l $ <Help Contents< >"@ ɀ D)vjBjʣ.  dMbP?_*+%&AMHP LaserJet 3100 CDGX XXx  "B,??U} $ } 2!} } m%} T0@ :    0gw=wG=GG== #  # '$?D#B@  %$.@L#B@    %$J@  Q % $R@  % $S@ % $U@  %$W@   %$^@  W %$ a@    %  $@b@  % ' $ c@ D #B@   %  $g@   %  $ j@   %  $@k@   %$ l@ )$`o@   )$q@ )'$q@D#B@   * '$r@D#B@$$$$$$$$$$  ! *"'$t@D#B@ %#'$u@D#B@  $ &%'$`w@ D#B@  &  '  ( ) *  + )  , *  - . *  / *  0 1D lmnSEEAEEEEMEAAEAECeGCG T0!"#$%&'():*+,-./0123045G6w=78w9G:=;G<G==>=?  * ! 2 !)" # 3 $ 4% & 5 ' 6 ( 7 ) 8 * 9+ , : - ; . < / =0 1 2 3 4 >5 6 ? 7 @ 8 A 9 B: ; C < D= > E ? FD4l        @T0ABCDEFGHI:JKLMNOPQRS0TUGVw=WXwYGZ=[G\G]=^=_ @ GA B H C I D JE F G H I KJ K C L DM N LO P M Q N R O S P T QU V RW X S Y N Z O [ T \ U] ^ V_ Dl         `T0abcdefghi:jklmnopqrs0tuGvw=wxwyGz={G|G}=~= ` W a X b Yc d Z e [ f'\ g ] h ^i j _ k ` l a m b n c o d p e q f r gs t u v w hx y E z F { i | j } k ~ l  mD(l     T0:0Gw=wG=GG==  n  o  p  q  r  s  t  u  v  w  x  y  z  {  |  }  ~         Y  ZD l        T0:0Gw=wG=GG==  [ '\ '] '^                      H  I      D,l    T0:0Gw=wG=GG==     n  o  p  q              v  w  x  y  z     }  ~   D(l     T0:0Gw=wG=GG==         Z  [ '\ '] '^              )) ) ) ) )D$l      T0 :    0Gw=wG=GG== ) ) )) ) ) )) ) ) ) ) ) ))) )) ) ) )) ))) )) ) ) ) ) )Dl         T0!"#$%&'():*+,-./0123045G6w=78w9G:=;G<G==>=? ) !)") #) $) %) &) ') () ))*) +),)-) .+/) 0) 1) 2)3) 4) 5)6) 7) 8) 9) :) ;)<) =) >)?,Dl       @T0ABCDEFGHI:JKLMNOPQRS0TUGVw=WXwYGZ=[G\G]=^=_ @) A) B)C)D) E)F) G+H, I) J) K) L) M) N) O)P) Q+ R+ S+T+ U)V+W+ X+Y+ Z+ [+ \+ ]+ ^+ _+Dl       `T0abcdefghi:jklmnopqrs0tuGvw=wxwyGz={G|G}=~= `+ a+ b+ c+ d+ e+ f+ g+ h+ i+ j+ k+ l+ m+ n+ o+ p q r s t u v w  x  y  z { |  } ~  D(l     T0:0 Gw=wG  R                        S  T   (U V8P       >@ Sheet2 ɀ&A Page &PMZHP LASERJET 5P/5MP (HP)&X&6ә@X"d??> d ɀ ̸  dMbP?_*+%i&L&F &A&R&D &T&?'?"d??U@x( .h r  0@A@ 9+]@8  <SensIt 1.13 Education - Spider<   s >PA@input_lab " ]& `P     s @A@input_cell "]& `      s @A@output_lab"]& `0      s BLA@output_cell"]& `L   xx  s 6A@ Start. 7 ]& `  <50< zamvv  s 4A@ Step. 7]& ``  <10< ll_cvv  s 4HA@ Stop.7]& `H <150< p   H?SpiderOK)1],9 $ <OK<   >?cancel$,] $ <Cancel< rr  0@A@  ]@h  <Labels< rr  0H@A@ ]@H! <Cells < rr  0A@ #]$`! <Input Variables' Ranges< rr   0A@ #]$ ``" <Output Variable's Cells< ||   :h@A@f ] @h#  < Label Label < ||   :ȹ@A@t ] @ȹ# <Cell < rr  08A@ 6*]$`8h$ <Send Output To<   \غ@A@Thissheet #%]Z غ%  t9E "<This Worksheet<   Zx@A@Newsheet #&%]Z xX&(  9D " <New Worksheet<   `@A@Newworkbook &)%]Z '@  t9C " < New Workbook<   `ļ?*SpiderMainHelpButton.6],ļ(XT9B $<Help< rr  04A@$8]$`4) <Input Changes (%)< rr  0@A@% - ]@8*  < Start (%)< rr  0@A@% -]@* < Step (%)< rr  0D@A@%-]@D+ < Stop (%)<   H@A@cell_lab '"]@0, <Cell< vv  s 4A@ Cell' 5"]& `,    HX@A@name_lab#'%]@X- <Name< vv  s 4A@ Name'#5%]& `(.  >"@ ɀ&A Page &PMZHP LASERJET 5P/5MP (HP)&X&6ә@X"d??> d ɀ&A Page &P"d??> d ɀ&A Page &P"d??> d ɀ&A Page &P"d??> d @ɀ 81A>d e((Y479  dMbP?_*+%&L&F &A&R&D &T&?'?"b??U} $} 2} } } m} $} } m} } $} I} } $ } } $ } } } $ 1T0 :    G w =  0 !G w      = G = = ~ ? ~   ~ 5@  l& B[Eagle.xls]Sheet1 ,CalcMode"BX B      !( NonContigBX * UnequalRowsBX  "  #'MultColsBX +  MultOutCellsBX #   1$B`  $ %  B7     & '  ( BW  )$$@CK"AL  *  +D. OutputLabel'C'!CN"BX   ,  - .& B[Eagle.xls]Sheet1 * # B  /  0* #B * #AB * #B * #B * #B    * #5B * # B * #B * #B  1  2 CB   B7  3  4  D lh>LUHlGK[:>Jjd4cW????W?I?W?R T0! " # $ % & ' ( ) :* + , - . / G0 w1 =2 3 04 !G5 w6 7 8 9 : ; =< G= => =?  5! ! #KAl  6 7!!" #JAl! !"# #NAl" " 8 " 9#!#$ #MAl# $!$% #OAl$ %!%& #LAl% ~ % @@ % :!&' #IAl& ')B7' ~ ' Y@ ' ;( )<)* C4Bg) ~ ) 0@ ) =*H*+2:DD"NCK"AL "NBm *">* ++,B4+ ,-kTornado Analysis for C run on AJmmm dd, yyyy (hh:mm AM/PM)A0:DD"NB`, 3-.:DD"NBm- B./, Input Values:DD"NB`. /0B /  01B+ 0  312:DD"NBm 1  D23.Input Variable:DD"NB` 2  !34 B- 3  945#Low:DD"NB` 4  :56$Base:DD"NB`:67$High:DD"NB`L786)+:DD"N:DD"NBm!89 B-9:B+6:; 'C'!CK"B23;<:DD"NBm$<=B5$=>B56>? 'C'!CO"B23?@:DD"NBmDg lgAYKKcAReGSb0/EV3K>>P%!:7((:@T0ABCDEFGHI:JKMNOPGQwR=ST0U!GVwWXYZ[\=]G^=_=$@AB5$ABB56BC 'C'!CL"B23CD:DD"NBm$DEB5$EFB56FG 'C'!CI"B2G3GH:DD"NBm$HIB5$IJB5OJK9'C'!CJ":DD"NB2KMB7 M?MN C4Bg3NO:DD"NBmPOP:Output Values (C&):DD"NB`PQBQRB+9R=S#Low:DD"NB`:ST$Base:DD"NB`:TU$High:DD"NB`LUV6)+:DD"N:DD"NBm!VW B-WXB+;XY%Swing: DD"NB`3YZ: DD"NBm=Z['Percent: DD"NB`[\B+\>\](Variance: DD"NB`L]^6)+: DD"N: DD"NBm!^_ B-__`B+BX((:7((:A((S17T"!=>>P%!?7A!LP%`T0bcefghijk:lmnoqrGswt=uv0w!Gywz{|}~=`bB7 b@abcK:DD"NC$"N'C'!CJ"B2ceB7 eA-efVarCountC$B]fgG@'Doing Low Cases for Tornado: Variable @CY@.BzwghaA:DD"NCY"N'C'!CJ"CY"NB2hi@B:ij$@'C'!CM"B2?jk)A:DD"NCY"NBmk(kl@B5(lm@B5wmnaA:DD"NCY"N'C'!CJ"CY"NB2noAoqB7 qBqrB6rs 'C'!CM"B2sEst/:DD"NC$"NBm$tuB5$uvB5Ivw3 BaseCaseValue'C'!CM"AZBXwyB7 yC-yzVarCountC$B^z{H@(Doing High Cases for Tornado: Variable @CY@.Bzw{|aA:DD"NCY"N'C'!CJ"CY"NB2|}@B:}~$@'C'!CM"B2?~)A:DD"NCY"NBm(@B5< s?a{">C6,{,:S((M?b{">CT0:Gw=0!Gw=G==(@B5waA:DD"NCY"N'C'!CJ"CY"NB2AB7 DaK:DD"NC$"N'C'!CJ"B2E/:DD"NC$"NBmB4B7 E C4BgXB ValueMinimum:DD"NC$"NBBXXB ValueMaximum:DD"NC$"NBBXE/:DD"NC$"NBmB2E/: DD"NC$"NBm$B53: DD"NBm0=ABS(RC[-2]-RC[-4])B`E/: DD"NC$"NBmB9t^ =(RC[-1]^2)/R@D@@C@@ D@: DD"NB`E/: DD"NC$"NBmB9" #0.0%B*3: DD"NBm! B-B+D.Total Variance: DD"NB`3: DD"NBm>(=SUM(RC[-3]:R[C$ ]C[-3]^2)BbB7BQ X,{ sI!1\\II(74IxI&7%+H7BT0:Gw=0!Gw=G== F:$Creating Chart for Tornado.Bzt^R@D@C@@D@:RC$DC@ DBmB='RDC DB'B2 G& zRC$DCD?&@RC$ DC DG@&@B  Chart 2'C4'!RDCD:RC$DCD,RDCD:RC$DCD,RDCD:RC$DCD#&BNB *C4 C%B^# Axis 1Bm/BT-CBW# Axis 1Bm)#8#X#WB# Axis 2Bm/BT S2Bm7!B T# Axis 2Bm5d2B # Axis 2Bm)BW! PlotBm5B T-VarCountC$B/@Text S1PCYBmO9@='C4'!RCYDCDB`/@Text S2PCYBmO9@='C4'!RCYDCDB`A$B|K5.="SensIt - Sensitivity Analysis - Tornado"B`Db l LxA!.'31'A'3#;'9'-%913S=S(T0:Gw=0!Gw=GB]B7 H C4BgI3:DD"NC$ "NBm  B/`JRDCD:RC$ DC DBmB YC&FPage &P??BBz3:DD"NBmB7   I J& B[01061525.XLS]Bins# 1$B`B7 KBW& B [Model.xls]Model, Box, Output* #B* #B>0 1W$d(k*A(  H1.E#T0:Gw=0!Gw=* #B* #BB7 LH2PlotOutputLabel'C+'!C<"BXG1PlotInputLabel'C+'!C:"BX M C.BgoSensitivity Analysis for C+ run on AJmmm dd, yyyy (hh:mm AM/PM)A0:DD"NB`;%Input:DD"NB`# C: B>(AVariable:DD"NB`A8"AC*:DD"NB`A<&Output:DD"NB`# C< B>(AVariable:DD"NB`A8"AC-:DD"NB`AL6)+:DD"N:DD"NBmBB+L6)+:DD"N:DD"NBm! B-B7 NO9'C+'!C9":DD"NB2# h#?BX;% SensStepsC@C=C?ABX<##ZK1?'L'F'J1L'F'P"!P%a'T0 :    Gw=0!Gw=G==)StepC>B`J@"Evaluating Model for Plot: Value @CH@@.@BzK5@C=CCH'C+'!C9"B`aKA'C+'!C9":DD"NCH"NB2@B:$@'C+'!C;"B2E/A:DD"NCH"NBm(@B5( @B5  @AO  9:DD"N'C+'!C9"B23  :DD"NBm  B4I 3:DD"NC>"NBm  B/_ICategoryMinimum:DD"NC>"NBBX_ICategoryMaximum:DD"NC>"NBBX\F ValueMinimum:DD"NC>"NBBX\F ValueMaximum:DD"NC>"NBBXB7 O7!Creating Chart for Plot.BzB2 P(' jRDCD%@%@RDCDC@ @B  Chart 13C: C< A&B$B@'C.'!RDCD:RC>DCDInput VariableC-B 2C: A&C< B$A@'C.'!RDCD:RC>DCDC*Output VariableB /C: C< B$A@'C.'!RDCD:RC>DCDInput VariableOutput VariableB A {@'C.'!RDCD:RC>DCDC*C-B B X-dOe,>S,,!S7!M$cc``I763 T0!"#$%&'():*+,-./G0w !Ac!"MRDCD:RC>BDCDBm"#B#Y#$C&FPage &P??B*$%C. C,B^#%& Axis 1Bm)&'#7#X#WB#'( Axis 2Bm)()#6# # B!)* PlotBm5*+B T$+,B|H,-2+="SensIt - Sensitivity Analysis - Plot"B`-.B]3./:DD"NBm/0Bz00B7&@gg.'-'-%9(L7 >@ ɀ [:  dMbP?_*+%i&A Page &P"P??UP|(  r  0@A@ 9/]@0 <SensIt 1.13 Education - Plot<   X?"PlotMainOKButton+3],41DR(9 $<OK< İ|  Z,?*PlotMainCancelButton%.!],1 $ <Cancel< rr  0A@ #8.]$`2 <Send Output To<   p<@A@(PlotThisSheetButton $'%]Z <\3\R  x93 "<This Worksheet<   n@A@&PlotNewSheetButton '*%]Z 4tR  x92 " <New Worksheet<   l|@A@$PlotNewBookButton *-%]Z |5R  91 " < New Workbook<   d@A@.PlotThisSheetCellLabel!$'&]@47 <Cell<    b,@A@,PlotNewSheetNameLabel!''*] @,8 <Name<    s \A@2PlotThisSheetCellEditBox)$7']& `8     s ZA@0PlotNewSheetNameEditBox)'7*]& `9  rr   0DA@ $]$ `D: <Input Variable's Cells< rr   0@A@ ] @L;  < Label (Opt.)< rr  0@A@ ]@; <Cell<   s HXA@PlotInputLabel #]& `X<    s FA@PlotInputCell#]& `D=  rr  0 A@ $!]$` = <Output Variable's Cells< rr  0\@A@ ]@\>  < Label (Opt.)< rr  0@A@  ]@HA@PlotStart- 7]& `HC  ~~  s <A@PlotStep-7]& `D  ~~  s <A@PlotStop-7]& ``E    \?&PlotMainHelpButton08!], FR,9) $<Help< >"@ ɀ&A Page &P"P??> P ɀ&A Page &P"d??> d ɀ&A Page &P"d??> d ɀ X  dMbP?_*+%i&L&F &A&R&D &T&?'?"d??U`j(  r  0@A@ <*]@H < SensIt 1.13 Education - Tornado<   s >0A@input_lab$ ]& `0XI    s @A@input_cell $]& `J     s @A@output_lab$]& `J    s B,A@output_cell$]& `,K  tt  s 2A@Low-: ]& `LL  vv  s 4A@ Base- :]& `L  vv  s 4(A@ High-:]& `(M    \@A@Thissheet"%]Z dNR  @d9T "<This Worksheet<   Z@A@Newsheet" %%]Z OR  @9S " <New Worksheet<   `D@A@Newworkbook% (%]Z DPR  d9R " < New Workbook<   H@A@Cell_lab$+!]@"@ ɀ&A Page &P"d??> d ɀ&A Page &P"d??> d ɀ&A Page &P"d??> d ɀ su  dMbP?_*+%i&A Page &P"P??9Up(  `  S A@?;]`(` <SensIt 1.12 Tryout< [  Z`?$TryoutOrderButton(6=9],``4S_9U $ O<Ordering Information< e:rr  0 aA@->:]$` axa  rr  04a@A@.=5n]@4a b <I understand that I may use this tryout version of SensIt only for evaluation and that any other use requires purchase of the commercial version.< rr  0a@A@ >n]@ab s<tSensIt Tryout Version Copyright 2002 by Decision Support Services 2105 Buchanan Street #1, San Francisco, CA 94115< Ssrr  0a@A@>]@apc <Thank you for trying SensIt.< rr   0Db@A@>%] @Dbd B<CThis is a fully functional tryout version for evaluation use only.< +Brr   0b@A@>n] @bd <You can purchase the professional or education version of SensIt with check or charge card by mail, phone, or Internet: www.decisiontoolpak.com< rr   0c@A@">'%] @che i<jYou will receive the latest version on disk with printed documentation and a 30-day money-back guarantee.< irr   0dc@A@'>,%] @dcf N<OThe professional and education versions do not display this purchase reminder.< {Nrr   0c@A@>!] @cf :<;Click the "Ordering Information" button below for details.< :  T8d?$TryoutAgreeButton6&9]8d`g $<I Agree< $  Rd?"TryoutQuitButton69]d0h $ <Quit< >"@ ɀ&A Page &PMZHP LASERJET 5P/5MP (HP)&X&6ә@X"d??> d ɀ&A Page &P"P??> P ɀ&A Page &P"P??> P ɀ&A Page &P"P??> P TornadoVBAo__SRP_14B__SRP_15&SensitHelpVBA oOutpu`t()  8.ProcDataInvoke _Funcp \n14k' De@clare \MainDialogBox as object variable  Dim,As O, Set#= ThisWorkbook.4Sheets( A"s 'Move f In~P FroB Tto d Cells in SensitXLM With <93 .Range("L5").0Valu.Edit=e\iJ_labTexkً%7%c110ho&12oc'MLowL1iLBase9!eqHighEnd ߂s Integer, NewA C @`}\.~Buttonaa  f ?! wtGDuAateh˜"Boolean, Tenta(tivS ngx, x#b" IfG)= 1uen h #u NDoC P= Fals aFor EachEIn: FsG AUCuS() c#".=)(eTruE&O2& "p (2)%Epxit KbI:fgN$ Loop Until Not OG%.Add '''@U aMdbecomes the acHautomKcally; `,AK( <>PThJAJ$C i BuC1LE0gCIY2d C1 SensitXLM %%( Cell %"!f$!@ C2 SensitXLM %%( hXSensitXLM!StartTornado BB@Dl()Read Output Option Entered In Tornado BoxTornadoMainDialogBox %< .EditBoxes("Name").Text = "Sheet" & Worksheets.Count + 1Name_lab7H(JName7"(JName_lab7H(LName7"(LCell_lab7H(JCell7"(JCell_lab7H(LCell7"(LCell9Nnl@TornadoMainDialogBox %< .EditBoxes("Name").Text = "Sheet" & Worksheets.Count + 1Cell_lab7H(JCell7"(JName_lab7H(JName7"(JCell_lab7H(LCell7"(LName_lab7H(LName7"(LName9NnPlHTornadoMainDialogBox %Cell_lab7H(JCell7"(JName_lab7H(JName7"(JCell_lab7H(LCell7"(LName_lab7H(LName7"(LnPlH@NAttribute VB_Name = "TornadoVBA" Option ExplicitHSub D\(b P(h(hh(PME 6   0 @ "HP.X @8< N`4  "(0*8@h. "08LH8N4 Xpx  xZ  DZ (alogZ$ Pt vaZ(ZSensitContentsDialogBox %!h'f fb X'V'b fb(/''OK button clicked or list item double-clickedSensitContentsDialogBox %%j!l'Z Z ContentsText HelpFiles %4%%n'^ ^HelpText HelpFiles %4% B%p ` '\ \SensitHelpDialogBox %%j(l SensitHelpBox'Vhl''ShowSensitContentsBoxZPSensitHelpDialogBox %!h't t 0''Close (Cancel) button clicked (or X or Escape) X'V'b tb$''Help Contents button clickedSensitContentsBox'Vhl''ShowSensitHelpBoxhOverview'^ ^ ContentsText HelpFiles %4% B%p'Z ZSensitContentsDialogBox %%j(l ^HelpText HelpFiles %4% B%p ` '\ \SensitHelpDialogBox %%j(l SensitHelpBox'V'b\ VSensitContentsBoxHQA@d SensitHelpBoxHQA@rk( bl''HelpFromMenubAttribute VB_Name = "SensitHelpVBA" Option Ex@plicitHPub, NextBox As Sng, Pre vious , `ContentPsRowhI gper, n +Itema Jst8OffsetRD10Dim$FromMenuDone'BooleanSub pShow|;`(X) .ProcDataInvoke_Func \n14B,ResulWC= ThisWorkbook.DialogSheets( X").S If (False+e| p=m d M#rue ETB'''OK tcked or lJimiudoe-E-At@LBes(1).Index ZsWB?iles@TRange(" E&T@Cell.CaԀwSensitivity Analysis" ThenDelete Next 'I+=("1).-End %"!f' $.Z0H$Start %"!f'Step %"!f'XStop %"!f'+absolute = box.CheckBoxes("absolute").Value/percentage = box.CheckBoxes("percentage").ValueZ`xZ Thissheet %*! '$Newsheet %*! '& Newworkbook %*! '(Cell %"!f' $ $  X$' $ $.hXZ &NameSpiderMainDialogBox %%"!f'.\', 0 4 .$6 0!$6', . (2)'.rh 0 , 4B@8:''New worksheet becomes the active worksheet automatically :! . . :(hA1$.h ( <B@8A1$.''x is the starting Output CellhxCr     +9& !"#$%'()*,-./012345678:D;<>Q?@ABCENFGHIJKLMhPRSTU_WXYZ[\]^O`abcdefgjklmnozqrstuvwxyi{|}~eates Input Values TablePlease Wait. Calculating ... B( B( !> !@$n !>   !@   $n$B@ !> !@$n !>   !@   $n$B@  !> !@$n !>   !@   $n$B@ $d %(  %B@J  n Z X$dX $dZ B@ %!B@JPercent ( Input Variables Values9 5(n !> !@$n !> !@   $n$B@J   %( B@ %B@J B@ B( !> !@ $n !> !@   $n$.input ! !B@8perc ! !B@8 !> !@ $n !>   !@   $n$B@J =input*perc ( B@  B@Z(@    %n! !>  !@ $n !>  !@   $n$( Creates Output Values Table  %. $d %(  %B@J  n Z X$dX $dZ B@ %!B@JPercent ( Output Variable Values ( ! )9 5(n !> !@$n !> !@   $n$B@J   %( B@ %B@J B@ ! B@  B(ZX    %n! '     %!   %n(  !    %(  !  xA B (<<26 <MG=$*\Rffff*1b3d474d56‒  @‖P@‘@$ 0`  14` $ (s" T$ H'Men$ hols"$ lysi$ $ $@ ````X`@$ @& @( ```, `. 0 $``@ @ ``````` | Fx`p  P 14 P`  14 R` )" 14  `h H557'iT ab  14`V.`X%"``$‎@Star‐@%"—(@f'0(Px/pexXPx$0MEl  ( " 8@`p(    @ Pp"  20 6h  "0 *P    8 (HPh p xJ    ( 88H ( XX8^ &X0 DH `p  V( &( \P      v  "  &  X(    2   D X  p         2 $X $    . &8`Xx4 HXD`      8X2p,   \x     &0  X*x   xP`( L0 &  $$   @ Xpx  V 0 H`hx   *   (8\@ 2  0H `x  V 8 Php       2 " @&H Bp0H` x " & B(@Xp  " & 8Ph "   0( 8 8P  (     ! 0!  " 0@"  X# 4p# (# 8# "$ 0$ 0P$ *$ @$ 0$ ( % ,H% x% *% % 0% *& @8& 0x& (& ,& ' (' 8' X' `'>p' ':'(((  (xZZ@|Z@(P$Z0ivity ZPp ZPSpiderMainDialogBox %.Z B!'  B(Z input_lab %"!f' $. !!' input_cell %"!f' $. output_lab %"!f' $. output_cell  %(    %n(  'Creates Output Value Table (percentage)  %. $d %(  %B@J  n Z X$dX $dZ B@ %!B@JPercent ( Output Variable Percent ( ! )9 5(n !> !@$n !> !@   $n$B@J   %( B@ %B@J B@ B(Zp ! '    %n! '     %!   %n(  !     %(     %n(   !> !@ $n !>   !@   $n$B@JPercent (0.00% ( Chart Outputs Values ChartZ'  !@  $ ! '  !>    'Z' ''Do both charts, 1997-06-25  MsgBox ("x1.Row = " & x1.Row & Chr(10) & "x1.Column = " & x1.Column & Chr(10) & "inp = " & inp & Chr(10) & "steps =" & steps) '''1997-09-28 1540r m = Int(Application.Min(Range(Cells(x1.Row + 2, x1.Column + 1), Cells(x1.Row + inp + 1, x1.Column + steps + 1)))) !> !@ $n !>   !@   $n :%.'F MsgBox ("DataRange typename is " & TypeName(DataRange)) '''1998-09-28MsgBox ("Before calling Bins.") A MsgBox ("After calling Bins.")  L :!"%8B@J B( *8D !> !@$n !>  !@   $n$( ,* .024*Sensit - Sensitivity Analysis - Spider6% Change in Input Value8  Value: $B@& :!"! :%"B@< @ $%>B@J @ $%> 9B 9D 9Fnp