ࡱ> o?ACompObjpi06>JD n``0)T0)Tf]uTahoma esCells8#FrameOutputVariablesCells', #FrameInputValues $4ButtonOK# ( 8ButtonCancel#( 4ButtonHelpel#,<ButtonResetAlles'  ` Microsoft Forms 2.0 FormEmbedded Object9qz{|}~  !"#$%&()*+,-.013456789:;<=>?@ABCDEFGIJKNOPQRSTUVWXYZ[\]^_`abdefijklmnopqrstuvwxyz{|}~ input cells in adjacent cells in a single column, arrange corresponding labels in adjacent cells in a single column, and arrange One Extreme, Base Case, and Other Extreme input values for each input variable in three separate columns. The three ranges containing input values can be worst case, likely case, and best case, or they can be low, base, and high (or high, base, and low). Cells for Input Variables and Cells for Input Values: The input ranges can be in columns, in rows, or in nonadjacent cells. To make nonadjacent selections, click in the range edit box, make the first selection, and press the Control key while making other cell selections. Each of the input range edit boxes must reference the same number of cells. For example, if your model has five inputs, the names of the five inputs could be text in A1:A5. The input cells of your model could be numbers in B1:B5; when you change a number in one of these cells, the output of your model changes. The One Extreme input values could be numbers in D1 \pMike Middleton Ba=   ThisWorkbook=[;"8X@"1Arial1Arial1Arial1Arial1$Arial1 Arial1Tahoma1Tahoma"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)mmmm\ d\,\ yyyy 00000""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-General;\-General;"Manual"0.0 0.000 0.0000 0.00000 0.000000 0.0000000 0.00000000 0.000000000 "$"#,##0 "$"#,##0.0 "$"#,##0.00                       X (X X !    ` SEmptyU HelpSheet \Bins bins; ! Screen1;! Screen2;! Screen3;! Screen3;! Screen4=! Screen5;   InstallationTryout LicenseSensIt OverviewOne Input, One OutputMany Inputs, One OutputAcknowledgementsHow To UninstallnTo uninstall or delete SensIt: (A) First, use your file manager to locate the SensIt xla file, and delete the file from your hard drive. (B1) If SensIt is listed under Excel's add-in manager (Tools | Add-Ins) 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 will see "Cannot find ... Delete from list?" Click Yes. (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 will see "Cannot find ... Delete from list?" Click Yes.}Use SensIt s Many Inputs, One Output option to see how your model s output depends on ranges you specify for each of the model s input variables. Before using this option, a typical arrangement is to enter your model:D5, chosen as the minimum possible value you think each input variable could be. The Base Case input values could be numbers in E1:E5, chosen as the most likely value for each input; you might also have these same numbers in B1:B5 as current inputs to your model. The Other Extreme input values could be numbers in F1:F5, chosen as the maximum possible value you think each input variable could be. Cells for Output Variable: Enter a single cell reference in each range edit box, or point to a single cell on the worksheet. The Label cell should be descriptive text, and the Value cell should contain a formula that produces a numerical value as the output of your model. Tornado Chart,The Many Inputs, One Output feature produces a tornado chart. For each input variable, SensIt sets all other input values at their Base Case values, copies the One Extreme input value to the input variable cell, recalculates the worksheet, and copies the value of the output variable cell to the table. The steps are repeated using each Other Extreme input value. For each input variable, SensIt computes the swing, i.e., the range of the extreme output variable values, sorts the table from largest swing down to smallest swing, and prepares a bar chart. Spider ChartTThe Many Inputs, One Output feature produces a spider chart. For each input variable, SensIt sets all other input values at their Base Case values, copies the One Extreme input value to the input variable cell, recalculates the worksheet, and copies the value of the output variable cell to the table. The steps are repeated using each Other Extreme input value. For each input variable, SensIt computes the swing, i.e., the range of the extreme output variable values, and sorts the table from largest swing down to smallest swing. For each input variable, SensIt expresses the One Extreme and Other Extreme input values as a percentage of the Base Case value. An XY (Scatter) chart shows how the output value depends on the input values. If the Base Case value of an input variable is zero, that input variable is not included in the spider chart.Use SensIt s One Input,One Output option to see how your model s output depends on changes in a single input variable. Cells for Input Variable: Enter a single cell reference in each range edit box, or point to a single cell on the worksheet. The Label cell should be descriptive text, and the Value cell should contain a numerical value used as an input to your model. Input Values: Enter numerical values into each edit box. Cells for Output Variable: Enter a single cell reference in each range edit box, or point to a single cell on the worksheet. The Label cell should be descriptive text, and the Value cell should contain a formula that produces a numerical value as the output of your model. SensIt uses the Start, Step, and Stop values to prepare a table of values. Each value is copied to ypur model's input variable value cell, the worksheet is recalculated, and the value of your model's output variable value cell is copied to the table. (You could do this manually using the Edit | Fill | Series and Data | Table commands.) SensIt uses the input and output values to<  prepare an XY (Scatter) chart; the text in the label cells you identified are used as the chart s axis labels. (You could do this manually using the ChartWizard.)Warranty GuaranteefIf you are not satisfied with our software, your money will be refunded during a period of 30 days from the date of purchase. We offer free tryout versions of our software so that you can be sure that it meets your requirements before you purchase. But if you are not satisfied with the purchased software during the first 30 days, we will refund your money.*There are several ways to install SensIt: (1) Start Excel, and use Excel s File | Open command to open the SensIt xla file from floppy or hard drive. (2) Copy the SensIt xla file to the Excel or Office | Library subdirectory of your hard drive. Start Excel, and use Excel s Tools | Add-Ins command to load and unload SensIt as needed. (3) Copy the SensIt xla file to a subdirectory of your hard drive. Start Excel, and use Excel s Tools | Add-Ins | Browse command to specify the subdirectory location of the SensIt xla file. (On a Macintosh use Tools | Add-Ins | Select.) Then use Excel s Tools | Add-Ins command to load and unload SensIt as needed. (4) 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.SupportAcademic LicenseStandard LicenseSensIt Sensitivity Analysis Add-In for Microsoft Excel (Excel 97-2007) for Windows and Macintosh To run SensIt, start Excel and open the SensIt xla file. SensIt adds a Sensitivity Analysis item to the Tools menu. The Sensitivity Analysis command has three subcommands: One Input, One Output; Many Inputs, One Output; and SensIt Help. All of SensIt s functionality is included in the SensIt xla file. There is no separate setup file or help file. Before using the SensIt options, you must have a spreadsheet model with one or more numerical inputs and a numerical output. All SensIt options make it easy for you to see how sensitive the output is to changes in the inputs.8The original version of SensIt for Excel was developed by Michael R. Middleton of the University of San Francisco and James E. Smith of Duke University. Thierry Crifasi and Renu Gupta provided assistance with subsequent versions. This current version was completely rewritten during 2005-2007 by Mike Middleton./Decision Toolworks grants a license to prospective purchasers to use the Tryout version of a Decision ToolKit add-in for a 30-day evaluation period. Please share copies of the Tryout version freely with prospective purchasers. You are granted permission to make as many copies of the Tryout version as you wish. The Tryout version is not free software. If you want to continue using the software after 30 days, you must purchase a standard or Academic license. For information about purchasing the standard or Academic version of a Decision ToolKit add-in online, by phone, or by mail, visit www.treeplan.com. Instructors who require their students to use the software must obtain an Academic license, either by having students use a textbook that has a license or by purchasing a license from Decision Toolworks.Decision Toolworks will grant a license to a purchaser to use the standard version of our software. To purchase a standard license, visit www.treeplan.com. A licensed copy of our software may be used by a single person who uses the software personally on one or more computers, or it may be installed on a single workstation used non-simultaneously by multiple persons, but not both. You may access a licensed copy of our software through a network, provided that you have obtained multiple licenses for the software covering all workstations that will access the software through the network. That is, each workstation must have its own license, regardless of whether the software is used at different times or concurrently.Documentation pdf files and example xls files are available for download from www.treeplan.com. For additional support, send email to mike@treeplan.com.Decision Toolworks will grant a license to a student or a multi-user license to a university, school, department, or instructor to allow students to use the Academic version. The Academic version is for use only by instructors and students in a specific university, school, or department covered by the license. To purchase an Academic license, visit www.treeplan.com. Instructors who require their students to use the software must obtain an Academic license for their students, either (1) by purchasing a license from Decision Toolworks via Digibuy, or (2) by having students own a textbook that has a license. With a multi-user license, after you purchase and download the file, you may duplicate and distribute the downloaded files to licensed users by disk, network, web, etc. A licensed copy of our software may be used by a single person who uses the software personally on one or more computers, or it may be installed on a single workstation used non-simultaneously by multiple persons, but not both. You may access a licensed copy of our software through a network, provided that you have obtained multiple licenses for the software covering all workstations that will access the software through the network. That is, each workstation must have its own license, regardless of whether the software is used at different times or concurrently. The multi-user prices for Academic licenses are heavily discounted, so there is no discount for future Academic versions or for moving from the Academic version to the standard version. Support is provided only to the person who makes the purchase via Digibuy or only to another person designated by the purchaser.?Decision Toolworks warrants that the software will perform substantially as specified in the product's user guide for a period of 30 days from the date of purchase. We reserve the right to make changes to the specifications of the software and the contents of the user guide without obligation to notify any person or organization of such changes. Any implied warranties are limited to 30 days. Some states do not allow limitations of duration of an implied warranty, so the above limitations may not apply to you. Decision Toolworks' entire liability and your exclusive remedy shall be, at our option, either the return of the price paid or the replacement of the software that does not beet our Limited Warranty and which is returned to us with a copy of your receipt. This Limited Warra<*nty is void if failure of the software is due to accident, abuse, misapplication, or complications arising from your choice of hardware, operating system, or auxiliary software. Except as specified above, Decision Toolworks disclaims all other warranties, either express or implied, including but not limited to implied warranties of merchantability and fitness for a particular purpose, with respect to the software, example files, and user guides. This warranty gives you specific legal rights. You may have other rights which vary from state to state. In no event shall Decision Toolworks or any of its employees be liable for any damages whatsoever (including without limitation damages for loss of business profits, business interruption, loss of business information, and the like) arising out of the use of or inability to use our software, even if we have been advised of the possibility of damages. Since some states do not allow the exclusion of limitation of liability for consequential or incidental damages, the above limitation may not apply to you.Q `hL,bhu> _Titlerea55 n#ʹ3,34ATwН0`T0, и+ip0n#   n# 8|||DQv&Zh_#T0dt008>Pw*zm00 E000߿0h_#t0Screen5Percent0]rlinkܹ@Pw5e#8046@?@`T0l_/Tw ?H3+Tw`T0-Tw`T0cTw-Tw3Pw2PwԺ3Pw\-Tw`T0`T0<;<Æ0`T0 ڬp08ם0p004e#l#he#l#S]0e#|#l#%0a0~ucc  T  dMbP?_*+%"D??U>@ Sheet1  X[  dMbP?_*+%&A Page &PMHP LaserJet 2100 PCL64C odXXLetterDINU"4O "dXX??U} I} 8] T0/  q] |  w   )PG /  W                             >@ Sheet3   \^  dMbP?_*+%"??U T0 $@?*@@0@@4@@:@@@@@D@@I@$@P@$@ T@$@>@ Sheet2 ThisWorkbook7 __SRP_1d '__SRP_1c/Sheet18 2`<I^@lzfFE]DӒxAdm#E]DӒ⮹I^@lzf]4PSLSS6" <<<N0{00020819-0000-0000-C000-000000000046} F!$*\Rffff*4746f815f3$*\Rffff*4d46f815f3h8@`|kh`|kl i @s$@ $8 $h $ $ $ $0 $` $ $8 P@8h@phME  " "  (0 @xAl`@A lH@Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |CreatablFalse ^PredeclaIdTru "@ExposeTemplateD0eriv$eCustomiz2 Option 3licit  P&* Sub _Open() Call meMenuItem End BeforeClf(Cancel As B@oolean ,Delet,rU 8 9! a 4q a ` `1?<   $ <   $ 44SrU @$`h()`l #p<JedOTw2 FZjoCKx*8d&]#ZjoCKJedOTw2F4(SLSS6"N0{00020820-0000-0000-C000-000000000046} F!$*\Rffff*4846f815f3p($@h $" $ $( $"0 $` $@8@0ME xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |CreatablFalse PredeclaIdTru "ExposeTemplate`Deriv$eCustomiz d __SRP_fH__SRP_eL@Sheet3!Mx__SRP_1fcrU 4)Q{crU @p<Z|hYM|yΧC Fg[#Jz3Ix*8d#g[#Jz3IZ|hYM|yΧC F4(SLSS6"N0{00020820-0000-0000-C000-000000000046} F!$*\Rffff*4946f815f3p($@h $$ $ $( $$0 $` $@8@0ME xAttribute VB_Name = "She@et3" Bast0{00020820- C$0046} |CreatablFalse PredeclaIdTru "ExposeTemplate`Deriv$eCustomiz d rU ِ4)Q{crU @p__SRP_1eg@Sheet2h__SRP_21,__SRP_20@<ޥpoF1J% Fz9CX\x*8dN)#z9CX\ޥpoF1J%F4(SLSS6"N0{00020820-0000-0000-C000-000000000046} F!$*\Rffff*4a46f815f3p(:1$@h $& $ $( $&0 $` $@8@0ME  xpAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |CreatablFalse PredeclaIdTru "ExposeTemplate`Deriv$eCustomiz d Option 3licit rU @)Q4)Q{crU !@prU $`$)`$i`(`y0$`$)FormSensItOneInOneOut,%O=s__SRP_6T0__SRP_7 'FormSensItManyInOneOut.ect Library*#26*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#55*\R1*#16f*\R0*#16*\R0*#10*\R1*#b8*\R1*#20b>*\G{5B2237B6-E926-4ED5-A1E9-867B2DBBEAF7}#1.0#0#..\..\..\Documents and Settings\Mike Middleton\Application Data\Microsoft\Forms\RefEdit.exd#Ref Edit Control*#0>*\G{5B2237B6-E926-4ED5-A1E9-867B2DBBEAF7}#1.0#0#..\..\..\Documents and Settings\Mike Middleton\Application Data\Microsoft\Forms\RefEdit.exd#Ref Edit Control*#2$*\Rffff*5246f815f3$*\Rffff*5146f815f3*\R0*#1a*\R0*#1b@0($X0L" $*`xk*N,`|k4`o `6x 8tP`$`<8p >l$`@ph Bd$`D`| F\a$`HT`JL`LD`NB `P<`R8H`TH`VH`X8 H`ZX Hbh` (k0i `z` Xk` o00`x`\ neg`!^`\!` `0 ` p`!f`A@b``!j` h```` !^h`$($$8SeCGFU쒴NMS^Yx~7K5D40S䀔Ngwx)pdw0S䀔Ngw8SeCGF)b`48<@DHLPTX\`dhlptx|SPSSS(:>"L*L*L*LL  LL*LL*L"  <<<<<<<<<<<<<<<<<<<<<<<<<0{372B0422-40FE-490D-A6F0-46CE57BB6B32}{C23F99EA-3AE0-45DC-B728-497C9398AC79} F!$*\Rffff*4b46f815f3*\R1*#15d*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#42*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#53*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*#4*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#41*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#51*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#4*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#28*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#2f*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*#28*\R1*#a7*\R1*#208*\R0*#c$*\Rffff*1846f81a1b*\R0*#11*\R0*#1$*\Rffff*4f46f815f3*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Objt@x .0 xH`0 (  p RBox for input variable Label must be empty or a valid reference for a single cell.IBox for input variable Value must be a valid reference for a single cell.SBox for output variable Label must be empty or a valid reference for a single cell._Box for output variable Value must be a valid reference for a single cell containing a formula.=Boxes for Start, Step, and Stop input values must be numbers.\:`bnprx@X 8 @@ ( @@  @  F@ 2@ I~1\@ fEdi@ @ vz|~(t@ 0Ph 8 @H@P h @X @ H @ 8 @( h P \nprxz|@x @h @X xH 8hH8h(~\@t @p @` @X @H z|@(8 @( Pnprxz|@ 0``h$H`4$`($% `($@/(P8`$p :Xh`$PD`4$Ox`($Z(`($Hd0X@`$x(o`p`$Xy`4$`($`($8 H0`($hPx``d$H`d$x`d$`$(P `($xh`$P`$0`0 XME "  "( H0 x  "  ^ V`l8J P nH n ((8;@ $X h x2  (^   08@  H X;` $x  2  (^ 0 @PX  ` (p; $  2   ((^0 X hx   ; $  2   0@H(^P x      +    0 8  #@ +P  h  x    # +        #  $ (( P p 8 &   0 8@ &x  FC FC0 HCx FC BC @CP @C FC 0N+  h x " 42 "      $ $( $8 H X 4` L @ L( "x  <3   89("D` 89"D :9"D8 `89h"D 49"J 0298"Jp 29"J 89 @P` h    0@H P`hx 5        0 8@HPX ` h x         (0 (8 (H )X hpx ( ( )      ( 8 @HPX` h p          (08 (@ (P )` px ( ( )       0 @ HPX`h p x         (08 @ H X h x         ( 8 HPX`hp x           (08@ H P ` p          0 @ P  X ` h xx` A@tH0lXAHelpTopic is a public string variable defined in ModuleSensItHelpOne Input, One Output'. 0B@2lPZ 8ZXpZZZ0ZHZ`ZRBox for input variable Label must be empty or a valid reference for a single cell.x ZIBox for input variable Value must be a valid reference for a single cell. CZSBox for output variable Label must be empty or a valid reference for a single cell.Z_Box for output variable Value must be a valid reference for a single cell containing a formula.Z=Boxes for Start, Step, and Stop input values must be numbers.JConst MessageStartEqualStop As String = "Start must not be equal to Stop."hConst MessageStepPositive As String = "If Start is less than Stop, then Step must be a positive number."hConst MessageStepNegative As String = "If Stop is less than Start, then Step must be a negative number." \!^ \!^$:.8 ` RA@b \B@dpuhh` 8!f!h RA@b \B@du h 8!j!h 8!l!h  RA@b \B@duhh \!^'6 n!^$:.> `om TA@b nB@dPuHh@ >!f!h TA@b nB@duh >!j!h >!l!h  TA@b nB@duh n!^'< p!^x p!^$:.B ` VA@b pB@d(u h B!f!h VA@b pB@duh B!j!h B!l!h  VA@b pB@duhxhp p!^'@X r!^$:.F ` XA@b rB@duh F!f!h XA@b rB@duh F!j!h F!l!h  XA@b rB@du`hX F!t XA@b rB@du h r!^'D x!f$v ZA@b xB@duh x!^'H z!f$v ZA@b zB@duphh z!^'J |!f$v ZA@b |B@duh |!^'LIf ValueStop = ValueStart Then! Message MessageStartEqualStop TextBoxStop.SetFocus Exit SubEnd If1If ValueStop > ValueStart And ValueStep <= 0 Then Message MessageStepPositive TextBoxStep.SetFocus Exit SubEnd If1If ValueStop < ValueStart And ValueStep >= 0 Then Message MessageStepNegative TextBoxStart.SetFocus Exit SubEnd If"SensItOneInOneOutRefEditInputLabel 6 ~!B@!SensItOneInOneOutRefEditInputCell < ~!B@#SensItOneInOneOutRefEditOutputLabel @ ~!B@"SensItOneInOneOutRefEditOutputCell D ~!B@SensItOneInOneOutTextBoxStart H ~!B@SensItOneInOneOutTextBoxStep J ~!B@SensItOneInOneOutTextBoxStop L ~!B@"SensItOneInOneOutCheckBoxRunSolver N ~!B@  6 8 < > @ B D F H J L NA (A@tlZP  SensIt - One Input, One Output$'l0h \(^ n(^ p(^ r(^ x(^ z(^ |(^ \B@dl.''Most of this code is for the Mac dialog box.F''Controls of the original dialog box were modified using Mac Excel X.:''For each control the location, size, and font were notedE''in the Mac VBE properties window and entered into Win Excel 97 VBE.X"Z' F Tryout'g F Academic'g,SensIt   - One Input, One Output (( Z'"SensItOneInOneOutRefEditInputLabel ~%!'   $ \(^DH%X'!SensItOneInOneOutRefEditInputCell ~%!'   $ n(^$7'#SensItOneInOneOutRefEditOutputLabel ~%!'X,   $ p(^X k'"SensItOneInOneOutRefEditOutputCell ~%!'   $ r(^'SensItOneInOneOutTextBoxStart ~%!'DH%   $ x(^ X'SensItOneInOneOutTextBoxStep ~%!'   $ z(^'SensItOneInOneOutTextBoxStop ~%!',   $ |(^,'"SensItOneInOneOutCheckBoxRunSolver ~%!'Z0ZH`Zx Button Light Shadow &H80000016' U ', Arial' ''Z%ZXZ Window Background &H80000005'X5` U 'XArial' ''Z Z8Arial' '' !*Win* (9999 95 9N999 9 5( 5( 5(n 59$999 9 5( X7 5( k 5( X7n` 599,9$9 9 5( 5( 5(ln5\099 99 9 5( k 5( X 5( n5n099(99 9 5(jH 5( 5(n(5999N9 9 5( 5( 5(H%n59$999 9 5(% 5(jH 5((jnX59$9,99 9 5(X 5(`( 5(n5p499 99 9 5( 5(Q 5( hn5r499(99 9 5(X 5( 5(Xn 5 99Z9i9 9 5(  5(7 5( n59$999 9 5( 5(X 5(nP59$9,99 9 5(7 5( 5( n59$9H99 9 5(%X 5( 5(%Xn5x099 99 9 5(7 5( 5( Dn5z099(99 9 5(, 5(%X 5(,n5|099D99 9 5(7 5( D 5(0nH59P9_99 9 5(H% 5(X, 5(n59P999 9 5(7 5( 0 5(Xnx59P9_99 9 5(X 5( 5(n59P999 9 5( 5(%X 5(nnhlAttribute VB_Name = "FormSensItOneInOut" Bas0{372B0422-40FE-490D-A6F0-46CE57BB6B32}{C23F99EA-3AE65DC -B728/7C9398AC79} dCreatabliFalse PredeclaIdTru "Expose@Templat@eDerivCustomizDOption 0licit P"& Sub ButtonCancel_C@k() Unload MUEndHel p' Topic is a p$ub, sng variQdefinfin Module@#{w Input, z@b* .Show  -OK, Dim TextLabel As S+, Ran>g Cel EL 0RPValue Start6Dode, Depo:RunSolverA BooPleanCAsCounBLongConst@8ssaMPWBox for iw GEm be Q`ty a lid refereVba singpXl.B/%B"  7OoutIn?_r x+ contain-7mulaS.b saEYesb6bQ,lep, a!t N@Us0numbe4rs '*;bEqualSv;b1CnotH to`op epP0osit`If@!gless Pthan,@eA hGF`S NegaT s ) S nG @RefEdi(.#=<> "" T,hewAO@rrkResuNQSetN=#( $Err @ 0( M'@OCAO Focus7F GoTo 0Exitj`\If!{\.2K.CK> 1 QK ?   eluHmns8 Or=.xRow!utT_ V._ _ Q  r`!&fA`&xP0 Y%ut+%%/za9$ #b#5/c ?`,`"Co_"O" GyQ  pWrG Ac"roI§O#A# Ha=uII>> A%Q0%%,& w>a &O geI 'IYIf! O (`JX ) )&:J3.&_J o HA΄Y<= 0#epPositiv@"s"<">_NegaQg6wAcSheet.Names .Add !:="SensItOneIn$yoLabel", `ersTo:= G, Visi ble:=  u !S !? d#b  ?5&SA'_F ep1 ep k "o o ZCheck RunSolver Call Sd a" _a'c=gX'rxStr)zUnload >Vˆ Private (Msg As StringQ\Dim Resp onPInteger= !, vbExclampOon, TJ - 0J v," B uttonPetAll_Click( ~N."x""qD4[)uvv/ tRKâ1'''Most of this@ code pfore Mac dialog box.pt''ControlsCe original were modifiepd us el X$ eachPlocsize, a yf#notedRin VBE properties windTowe$ri`nto W 97 0@*Use"r-_In}al a*VPnionpTypeg,Йh= ! IsTryoopy ` $EduCCAca demic  A .8.Capt c! " &berb & "o3?d3!aAf#;YOnp Err0"3 N0@ (/7").0PTo9l5Mid(, 3, Len()3=:  O O I A(KF9@ArialU9= 11 6= TrueHdmc&Lc F)tb\bD aWin^ *groundHa 0`05g0l+0//`/0i/d+/#@OK\'Pa'(2J2 'If Not Application.Oper ngSystiLike "*`9*" ThenaQWith Form. .Left` Hebq= 22b7$Top%Wid@ = 492?bCr .FrInputVanblesCellsc 1 b78(6(e23B"" AB@F 85C/8! 8 8#8! 8 BtT85+8! 8 l>F 85!C/8! 8 8#8! 8 BtL85+8! 8 l>F 85C/8! 8 8#8! 8 BtD85C:(%x@f%8" $ @ 8W 85C:(%p@f%8" $ @ 8W 85C:( %h@f%8" $ @ 8W 85C:(!%`@f%8" $ @ 8W 85C:("%T@f%8" $ @ 8W 85C:(#%L@f%8" $ @ 8W 85C:($%D@f%8" $ @ 8W 85C:(%%B @f%8" $ @ 8W 85+BDLT\`dhlptx &0 "'V(8"$ 8( D,xhlptd`\(8t82'('8:X*NHH0l Mh@^)pz6H8(T8$ H8(4:h%x! x,x:h%x! x,x:h%x! x,x:h%x! x,x$:hNXXx! x x5X$:hNXXx! x x5X$:hNXXx! x x5Xx! xx$$ xXCx+Cx(,Cx3-.*#tlx*#p/*F`%"'$(,2tp5`KC\9:H%X" $ @ X`W8`1\X6`8Dl\Ji`\MH@8 08%X! X,X6`8C\9:H%X" $ @ X`W8`1\X6`8Dl\Ji`\MH@8 08%X! X,X6`8C\9:H %X" $ @ X`W8`1\X6`8Dl\Ji`\MH@8 08%X! X,X6`8C\9:H!%X" $ @ X`W8`1\X6`8Dl\Ji`\MH@8 08%X! X,X6`8C\9:H"%X" $ @ X`W8`rU : y# $i$$%&A& (i)*Y+ ,-9---.1.a..!/ 00111A2  I3/++ɗ 444!5I55556)6Q6ɑy4 `18a<a9@aiDaHaALaaPT9X99\a`9d9h l99p9Yt9y xY` |Y`1a  Y9`q YY`r??T lx"$ x $ xT$ "$$$ ( (8! 8a:(]<85\K;'%8! 8a%" $ Qt86$ 88  l8C/8! 88K2ta888av"86%C/8! 88^ta88av"taav")86C/8! 888! 8a`1x85K;'%8! 8a%" $ Ql86$ 88  l8oC/8! 88K2la888av"86C/8! 88^la88av"laav")86aC/8! 888! 8a`1p85(8! 8a:(]<85\6K;'%8! 8a%" $ Qd86$ 88 1\X6`8Jl\Ji`\MH@8 08X! X X6`C\9:H#%X" $ @ X`W8`1\X6`8Jl\Ji`\MH@8 08X! X X6`C\9:H$%X" $ @ X`W8`1\X6`8Jl\Ji`\MH@8 08X! X X6`C\9:H%%X" $ @ X`W8`1\X6`81C lPq2C  p p3C lPq2C pp2C pp5t X" $  X t4lt5~/tX"'V(jH%,jH%,jH%,jH%, l 6X QX 7 hN7 D7 7  l 6l FH%X d6X,Xk DH%X d6X,X kH%X d6X,X X QX7 h$7 7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX7 h7 D,7 $7  l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX0jH%,jH%, jH%,jH%,@, (lFH%a`8XX,X5`(kDH%a`8XX,X5`)kH%a`8XX,X5` X QX0jH%,jH%,(jH%,jH%,@, (lFH%a`8XX,X5`(kDH%a`8XX,X5`)kH%a`8XX,X5` X QX7 h7 7 N7 D l 6l FH%X d6X,Xk DH%X d6X,X kH%X d6X,X X QX7 h$7 7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX7 h$7 ,7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX4jH%,jH%, jH%,jH%,@, (lFH%a`8XX,X5`(kDH%a`8XX,X5`)kH%a`8XX,X5` X QX4jH%,jH%,(jH%,jH%,@, (lFH%a`8XX,X5`(kDH%a`8XX,X5`)kH%a`8XX,X5` X QX 7 h7 Z7 i7 D l 6l FH%X d6X,Xk DH%X d6X,X kH%X d6X,X X QX7 h$7 7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX7 h$7 ,7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX7 h$7 H7 7 D l 7l FH%X X7X,Xk DH%X X7X,X kH%X X7X,X X QX07 h7  7 7 D l 0lFH%X X,XkDH%X X,X kH%X X,X X QX07 h7 (7 7 D l 0lFH%X X,XkDH%X X,X kH%X X,X X QX07 h7 D7 7 D l 0lFH%X X,XkDH%X X,X kH%X X,X X QX7 hP7 _7 7 D l 9lFH%X H9X,XkDH%X H9X,X kH%X H9X,X X QX7 hP7 7 7 D l 9lFH%X H9X,XkDH%X H9X,X kH%X H9X,X X QX7 hP7 _7 7 D l 9lFH%X H9X,XkDH%X H9X,X kH%X H9X,X X QX7 hP7 7 7 D l 9lFH%X H9X,XkDH%X H9X,X kH%X H9X,X  \x$tpX`8|x43`prU $`$)`$i`$`$`()`y0p)6Q6 DrU~}   9a stem32\FM20.DLL#Microsoft Forms 2.0 Object Library*#28*\R1*#a7*\R1*#208>*\G{5B2237B6-E926-4ED5-A1E9-867B2DBBEAF7}#1.0#0#..\..\..\Documents and Settings\Mike Middleton\Application Data\Microsoft\Forms\RefEdit.exd#Ref Edit Control*#0>*\G{5B2237B6-E926-4ED5-A1E9-867B2DBBEAF7}#1.0#0#..\..\..\Documents and Settings\Mike Middleton\Application Data\Microsoft\Forms\RefEdit.exd#Ref Edit Control*#2*\R0*#c*\R1*#b8*\R1*#20b$*\Rffff*1846f81a1bh0($X0 $`(o;;*N`x`\`$` 8``` ``` `` `H ``` 40`0o=`x tx$` p l$`hH dH$`` \ $`X TX$`R `P `H` HF `@@ Bx<$`"8&H80 $@4(U '$`N2 '`P,WW`&H`(Hnd`ZH`*`hHAria`,`H`.PH`0xH'`VH*Win`2HH9`4H9`6H9`8HH9`:H`<8H5 > $ B(<9$ D85$ FP0($*p`xk5`hk 9,`|k-b`(k035i 5`zp`0$$ $0x( .C:h]@45\Xu{JQ$vݬHh?s\gMZA)""   LL*L*LL*LL*LL <<<<<<<<<<<<<<<<<<<<<<<<<<<0{5C951251-DDF8-4A7C-AB09-80ABBB611278}{B4632356-34BA-4BA6-B8DF-77FFDF34C7D9} F!$*\Rffff*4c46f815f3*\R1*#15d*\R0*#11*\R0*#1$*\Rffff*5246f815f3$*\Rffff*5146f815f3*\R0*#1a*\R0*#1b$*\Rffff*4e46f815f3*\R1*#16f*\R0*#16*\R0*#10*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#42*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#53*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*#4*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#41*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#51*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#4*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#28*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#26*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#..\..\..\WINDOWS\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#2f*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#..\..\..\WINDOWS\sy @ ~@t >@p D@X ` J@X P@p H V@8 \@( bp `$ H0 (  `d$H OX @ `T$x ( Z p `T$ X e `x$ p `x$ {0 `d$P 0 ` H `T$ 0  x `T$ `  `x$  `x$   `d$@ P 8 `T$p  h `T$ P  `T$  `x$  `x$0 @ ( `x$`  p X `H$ @  `H$ p 0   `H$ `H$ +P must be a valid reference for a cell or a range of cells on a single worksheet.@ nBox for input variables Labels must be a valid reference for a cell or a range of cells on a single worksheet.nBox for input variables Values must be a valid reference for a cell or a range of cells on a single worksheet.pBox for input values One Extreme must be a valid reference for a cell or a range of cells on a single worksheet. rangenBox for input values Base Case must be a valid reference for a cell or a range of cells on a single worksheet.rBox for input values Other Extreme must be a valid reference for a cell or a range of cells on a single worksheet.ange'Box for Step must be a positive number. input JBox for output variable Label must be a valid reference for a single cell.s onJBox for output variable Value must be a valid reference for a single cell.H:`bl @ renc@ @H iabl@` lid @ le c0h`p0Bmust be the same as number of cells in input variables Labels box.els pNumber of cells in input variables Values box must be the same as number of cells in input variables Labels box.els borNumber of cells in input values One Extreme box must be the same as number of cells in input variables Labels box.els pNumber of cells in input values Base Case box must be the same as number of cells in input variables Labels box.els botNumber of cells in input values Other Extreme box must be the same as number of cells in input variables Labels box.el@ pv~J"@ ,l@x x@ @ "@ ,l@ @ @t "@d ,l@ T @8D @P4 "@h$ ,l@ @ @ "@ ,l@ @ @ "@( ,l@@ @X @pt "@d ,l@T 8@D d@@ @4 @ ,O 88@X(O H p $T@$O XX"@ tt@x p@x @h h.00P8  "@Ph @X  @@H @8 @( 0`0 pME7 "  @ >3`  :9"D  :9("Dh :9"D 89"D@ h<9p"D :9"D  H:9P"D     0@H P`p x   5 (08@H P X`hpx            (08@H P X h x   ( ( )    (( (8 )H X `hpx           ( 08@HP X ` p    ( ( )       (  (0  (@  )P  ` h p x                      0 8 @ H P X  `  h  x                   ( 0  (8  (H  )X  h p x      (  (  )         (  (  )(  8 @ H P X `  h  p                     ( 0  8  @  P  `  p x              . "  X(  \000`20440VhV A  $8 H Xhpx A $   A $  (8@H PAX $p   A $     N( x N@B@XD %    ( 8 %H ` p  %    %   08 @ (P`;h $  2  (^ 8 HX`h  p ; $  2   ((^0 X hx   @ L (0 HP hp <   N HX` h pL    P8   9@  ( 0PH  X \ .p 4 V ,0 ` x  PCPCPC@ NC RC PC8!PC! X~@!  X" *h" "" "" ""  " " " " # #  # 0# @# "H# HP# # ## " ##62#$($x`Z' F Tryout'g F Academic'gSensIt   - Many Inputs, One Output (ZP'$SensItManyInOneOutRefEditInputLabels ~%!'   $ (^ '$SensItManyInOneOutRefEditInputValues ~%!'   $ (^'#SensItManyInOneOutRefEditOneExtreme ~%!'xK_Cl   $ (^Click('!SensItManyInOneOutRefEditBaseCase ~%!'   $ (^RefEdi'%SensItManyInOneOutRefEditOtherExtreme ~%!'se.V   $ (^ue = "'$SensItManyInOneOutRefEditOutputLabel ~%!'efEdit   $ p(^ Priva'$SensItManyInOneOutRefEditOutputValue ~%!'ble de   $ (^pTopic B@dnputs,Z ZlpZ0 Button Light Shadow &H80000016'WW U 'tivateArial'ac ''ZH`WWZxZ Window Background &H80000005' U 'Arial' ''ZZArial' '' !*Win* 9999 959N99 9 9 5( 5( 5(n@59U999 9 5( 5( 5(n599,9U9 9 5( 5( 5(np5Z99 99 9 5( 5( 5(n5Z99(99 9 5( 5( 5(n5999N9 9 5( 5( 5(n859(999 9 5( 5( 5(;n59(9,99 9 5(0 5(. 5(,nh5p-99 99 9 5( l 5( t 5(pen5-99(99 9 5( v 5( o 5(Itn59 9Z9i9 9 5( 3 5(ev 5(onn059U999 9 5(e 5( v 5( fn59U9,99 9 5( Y 5( g 5( pn`59U9H99 9 5(f 5(yo 5(sin5Z99 99 9 5( i 5(fr 5(twn5Z99(99 9 5(g 5(ft 5(ftn(5Z99D99 9 5(an 5(r 5(icn59P9_99 9 5(ur 5(g 5(annX59P9_99 9 5(en 5(d- 5(inn59P999 9 5(.t 5(n. 5(Inn59P999 9 5(ts 5(e 5(ftn nhl &'' Private Sub UserForm_Initialize()e( !)-59AIZH`(@`x0ZHZP must be a valid reference for a cell or a range of cells on a single worksheet.`onZBox for input variables Labels &xZBox for input variables Values &Z Box for input values One Extreme &ZBox for input values Base Case &Z"Box for input values Other Extreme &Z'Box for Step must be a positive number.ZlZJBox for output variable Label must be a valid reference for a single cell.ZJBox for output variable Value must be a valid reference for a single cell.  !f$:.j ` (A@bZ B@duhx !f$:.   ` ZA@b B@d(u h !f$:.F `V *A@bVf B@dfv u h  !f$:. ` ,A@b B@dX uP hH @ !f$:. ` .A@b B@d u h ''H''Check for same number of cells in each of the first five RefEdit boxes''ZBmust be the same as number of cells in input variables Labels box.8Z.Number of cells in input variables Values box 4PZ0Number of cells in input values One Extreme box 4hZ.Number of cells in input values Base Case box 4Z2Number of cells in input values Other Extreme box 4 !h !h 6A@b B@d u h !f' !f' ( !h !hH 8A@b B@dPux hp !f' !h !h :A@bB B@d@u h !f' % !h !h <A@b<P B@du h !f' p!^ p!^$:.B ` VA@b& pB@dH u@ h8 B!f!h 8 VA@b pB@duh B!j!h B!l!h  VA@b pB@d uhh p!^'@x !^$:.$ ` 2A@b? B@dH(u h $!f!h x 2A@b B@duh $!j!h $!l!h  2A@bA B@d,uhx !^'" 9''All inputs are valid ranges with appropriate dimensionsF''Check for intersection between input cells and the three data values:Z   %@.>Z   %@.BZ   %@.D  > B DEThe range for input variables Values cannot have any cell references Kthat are the same as any cell references in the range for the input values )One Extreme, Base Case, or Other Extreme.A@b, B@du@h8Z F  F!^$vDCells for One Extreme input values must contain a number, not text. A@b B@duh F  F!^$v BCells for Base Case input values must contain a number, not text. A@b  B@duh F  F!^$vFCells for Other Extreme input values must contain a number, not text. A@b B@d( u`hXP $!H$=6The output variable Value cell must contain a formula.A@b B@duh $!^$v 'EFormula in output variable Value cell must return a number, not text.A@b B@duPhHR''Should I try to enforce the following practice of good spreadsheet model design?U''SensIt works either way, but eventually replaces the formula with a number or text.'''For Each ThisCell In RangeInputValues-'' If Left(ThisCell.Formula, 1) = "=" ThenH P'' Message "Cells for input variables Values must not contain a formula."%'' RefEditInputValues.SetFocus'' Exit Sub '' End If ''Next $SensItManyInOneOutRefEditInputLabels  ~!B@ $SensItManyInOneOutRefEditInputValues  ~!B@ #SensItManyInOneOutRefEditOneExtreme  ~!B@ !SensItManyInOneOutRefEditBaseCase  ~!B@ %SensItManyInOneOutRefEditOtherExtreme  ~!B@ $SensItManyInOneOutRefEditOutputLabel @ ~!B@ $SensItManyInOneOutRefEditOutputValue " ~!B@( #'               @ B " $ NAJ A@tl !'' Private Sub ButtonOK_Click()0 A@tlHp (^ (^ (^ (^ (^ p(^ (^ B@dlAHelpTopic is a public string variable defined in ModuleSensItHelpMany Inputs, One Output'. 0B@2l0ZP   SensIt - Many Inputs, One Output$'l{Attribute VB_Name = "FormSensItManyInOne@Out" Bas0{5C951251-DDF8-4A7C-AB09-80ABBB611278}{B4632356-34BA-6-B8DF-77FFDF3@4C7D9} dCreatabli False Pr@edeclaI"dTru "Ex0pose@TemplateDerivCustomizDOption 0licit P"& Sub User_Initialize()Dim VersType As Sng  If IsTryoutCopy Then  EducaMAcadeHmic {.Ca7C" &ENumber1& " - Inputs, BA>A ; >OQrror ResuNe>xTH ! Act@mSheet.s("RefEdit$Labels").@`To .ValuAMid(, 3, Len);3t A)?B )))@;Extreme)meA)ing+>@N:C qe;?? @?'Other9)????Nd)`yBhR>utbd!ȉ.Set FocusLo ngMac"%BackCol ,a caFontaL,AtegerIS3AInB# Bo oleanBoldaPm ButtmLight Shadow k X&H8r016DOA= CLng(O2ϠSVAr@s ^= 11 t =@q Box v @` Tem Win groundXp' 8057?<p r 0%66r3%%/A =e 2j k7%PNo`t App.OperngSyst@Like "**"RA`With  .Left'0n`He8= 227TopWid0= 502!_9P9S1 .Fr"MVa`7L4 5"v 78X 6 26 R@UCt4+DrDEnd@9thS?`_ .m8C1Y19__r ._S_t._q_t._C _r R .Wbx& P.c44___=K q______U4:9D@ ..`1Ca .Width = 170  .Back ColordLongMacBoxTFont.NameRStriV., TSizTIntegerW+ +BoldVBoolean++End With  .RefEditInputValues.LeftX9 yTop4 Heigh<19)ĹFr@qOutLriableL275L22 HL6 L 78HLLabel B A"F F ! N.QMJM1RMMHa#^sb a,&gt& .NluM&s4.s&D M &&  M4'+M2?'_.#_Ba#jM@&`&dLF:M?&.#&_% J t.?&+!# s>.`ss&= 26Y*v9068 9@8*39?c<&t.^7O BMne@ExtremM is8ISo`o9 M 9 OOO&,Oa|O#SMd seCas//P"/ 4?`sKĮS //ײB)9&&/c S(Other&6o 7`oo %@M&&&GMoo4O:;/t`1 &Oԅ; "$mnOO&C,.sOLB99!IAMosMM LL?Q9$99%%%?9OS5`= 6_!Ps//ngMacBoxFontName ..Size = Inte8ger\ BoldVBooleanV.VEnd With  .ButtonResetAll.LeftT280WidtFh Top95'Heigh>2BackColor.LongTLabel StriV #m'OKY41LLBGɚCancePM133]=.ѿxtHe 0 ThevnCu4 _5.Focus6 GoTo Exit1jl xt 4I  e s   ub > g  _/&+&El uO O F E*     RIT}% Q?2<%%''' @Chec:kls`OWrin` each@ hfiryfqR$; boxe@:W@#{SA6"%W "as_n input variables Labels box." Const MessageIValuesNumber As Stri@ng = "&o f celin i x " & TextMustBeSame mOneExtrXeme,l = >#nBaseC16 lthermn If Ran.Count <> C|DThen }C RefEdit.Set FocusExit Sub End If A} = D#  . ;w;à ;: @:/7/E.!.n.HZuLO. xt h/ CYOut P."Le"" 'cOn ErrorVsume NDkp(E? )cu 0h 0qh #a +$GoTo 0tuae.Areas<> 1ut)&aColum:nO4/IRow?$??Ú HSmC MLM#UOMBCY@M`'L^ %%%_$/hw_ ;_ 0rge,#i<#rQ_ _ o)"-"# R!"'''All s arelid r s with approp`te dimensi Check fMintersect betwe6eUCa`8S threpatacaDimI O= Applicja.('s,8p- jp/onPvfoRk?2`-(Not (Wj(Is h)) Q_`= t_>" (t&[ǒ,s cannP hav e any referencAá E"that. s a/OP1*egi, , 1`S  *ThisCAԤ1F@EachuInHn XIeric(^)0eTa ^z"!s2C< m conta a n, t. 11a_ 1MncNyR OE)/m/e-g'/Q "EgŔ6p)e//u// OQE+o contain a number, not text. " RefEditOtherExtreme.SetFocusJExi t Sub"End If N If NLeft(RangeOutputValue.Formula, 1) = "=" ThenHMessage " o4 vari able > cell must cfR.t ^\YIsNumeric\?6)Vi Zretur9^''' Shoul try to ence following @practiof good spreadsheet model design? ensIt works ei way, but eventually replacesDx w F orÚL EachSisCAtIn BIn@@ ATh FuAs@@r@gsÓsÒғH( GEA@aveS].Names.Add !A:="SB]ManyInOnωLabels", _ersTpo:=TB', Visi@:=False t_CneďU@#$aBaseC`5 bjh"D+GDB C c(_GEae&b s,j!)LB ( BhO8 JdBool|ea~ByC StepDou}ǁ Two ' $RunSolver)Unload aqQЃZ#RPrivate ButtonOK_Click(Can71_dMNResetAllV.!y=rs@6Kite!얏t,rit 0(k _Hel p'!Topic is}p0'strvdefinedѐModule3 kgg *5 Ԑ'$uA.@wo #$(Msg As Sb #!Dim ` ponseIntegertsD= Box!, vbExclamation, dy - / "__SRP_166__SRP_17'ModuleSensItMenu".u__SRP_d$  X,X6`8X! XXC l Pq$C ppC lPqC  p pC pp5t X"$  X tlt~/tXU"VjH%,jH%,jH%,jH%, l$ X QX7 hN7 D7  7  l$ lFH%X dX,XkDH%X dX,X kH%X dX,X X QX7 hU7 7 7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QX7 h7 D,7 U7  l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QXZjH%,jH%, jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QXZjH%,jH%,(jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QX7 h7 7 N7 D l$ lFH%X dX,XkDH%X dX,X kH%X dX,X X QX7 h(7 7 7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QX7 h(7 ,7 7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QX-jH%,jH%, jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QX-jH%,jH%,(jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QX7 h 7 Z7 i7 D l$ lFH%X dX,XkDH%X dX,X kH%X dX,X X QX7 hU7 7 7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QX7 hU7 ,7 7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QX7 hU7 H7 rU HS#/+P+ɗ> a?-1.4 @@QAAB9C4!5I5555-6)6Q6 DDEFG H $i$HY LM PQyJ T)UVV XY \] `%&Iab dIe*f h)iYjjj l-.a.m  nC 1Y 4a#8a <<a9<@aa<Da<H<La9P9<T!=X9Q=\9=`9=d9=hA `l9>p9t  xY` |Y` Y9`1 YY`qa>r??\CxCx(Cx3*#tlx*#p*F`%"$,2tp5`KC\9:H %X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X! X,X6`8C\9:H%X"$ @ X` W8 `1\X6`8Dl\Ji`\MH@8 8%X!7 D l$ lFH%X XX,XkDH%X XX,X kH%X XX,X X QXZjH%,jH%, jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QXZjH%,jH%,(jH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QXZjH%,jH%,DjH%,jH%,@, (l FH%a`XX,X5`(k DH%a`XX,X5`)kH%a`XX,X5` X QX7 hP7 _7 7 D l$ lFH%X HX,XkDH%X HX,X kH%X HX,X X QX7 hP7 _7 7 D l$ lFH%X HX,XkDH%X HX,X kH%X HX,X X QX7 hP7 7 7 D l$ lFH%X HX,XkDH%X HX,X kH%X HX,X X QX7 hP7 7 7 D l$ lFH%X HX,XkDH%X HX,X kH%X HX,X \U \x  tpX`8KA'%! a`F%"$ Qt6$ & 'l(C)/! KKA'%! a`F%"$ Ql6$ & 'l@*C)/! KKA'%! a`F%"$ Qd6$ & 'l+C)/! KKA'%! a`F%"$ Q\6$ & 'l,C)/! KKA'%! a`F%"$ QT6$ & 'l -C)/! K%lav"tav"6v3C)/! ! a`1x5! a`1p5%dav"tav"6 4C)/! ! a`1h5%\av"tav"65C)/! ! a`1`5%Tav"tav"66C)/! ! a`1X5(! a:]<5\K;'%! a%"$ Q<6$ & 'l7C)/! K25 ?C)/!  0,9 l\0(9 0a >5p @C)/!  0(9) lT0$9 0a >5 AC)/!  0$9 94a B :C]/6\M DC)/! 4a >5 EC)/! C: %x@f%"$ @ W FG H5C:%p@f%"$ @ W FG H5C:%h@f%"$ @ W FG H5C:%`@f%"$ @ W FG H5C:%X@f%"$ @ W FG H5C:%@@f%"$ @ W FG H5C:%8@f%"$ @ W FG H5@248<@FHPRTX\`dhlptx IL "V"J$K Lhx `,($4T@dp0t<`l8<X8hx\"4@tdTD4$tdTDT lx"J$K Lx $ x:h%x! x,x:h%x! x,x:h%x! x,x:h%x! x,x:h%x! x,x:h%x! x,x:h%x! x,xx! xx$ xT$ NM"O$PC$$ t82'('8:XRNHH0l Mh@^Qpz6H8(T8$ H8(hx|3