ࡱ> x;8CancelButton (2Label4@r( 4HelpButtonon s Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} TypeForm Caption = "Type of table" ClientHeight = 1875 ClientLeft = 45 ClientTop = 330VBFrame'OnewayForm7*#\%V1U ,V1Ufo"(  !"#$%&'()*+,-./0123456789:;<=>?@ABCDFGHIJKLMNOPRSUVWXYZ[\]^_`abcdefghijklnopqrstuvwxyz{|}~">@ Sheet1 I&A Page &P"P3f??f> P Module1-__SRP_5b__SRP_4=ThisWorkbook x05MEH  b7 (? N= > X "8@  H (X (`(@h8 x "p 9=(/   1'2 2'(2'7@2 911 89<X=( "X` %p 8L  (8 "n2hfV I\pCISis Albright Ba= ThisWorkbook=xx$W<X@"1Arial1Arial1Arial1Arial1Arial1* MS Sans Serif1 Arial"$"#,##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.000_);\("$"#,##0.000\) 0.000 0.0000 0.00000 0.00000000 0.0000000 0.000000 "$"#,##0.00"$"#,##0;\-"$"#,##0                + ) & ( , *      Comma [0]_Pigskin1Comma_Pigskin1Currency [0]_Pigskin1Currency_Pigskin1Normal_Pigskin18 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`Sheet1MModule1 Book4 Sheet1 (2)Sheet1YY  Demand;  EndInv;HoldPct:InitInv:Input1:Input2:  InvCap;Loc:  OnHand;Out1: Out2;! ProdCap;" Produced; TotCost:-"C:\SolverTable\SolverTableHelp.htm ,  Sheet_Titlereab@b\bebTbX`T0 be`T0bbNe`T0b(񂼛 bbzm0 Zh0<TbDbbbZT0bt00 bby7B"fwBTb ǀbe24by7B"fTotCostd4b ǀHbe2,}wBetb 0pb(TEpbe(ee(E?<`T0? ?be`T0<b zeЛ̗ǹePЛe`T0`T0jHll@bÆ0Л`T0Lb\b`T0bdbǬp0p00pb Ʃ8SƩS]04ũbbXƩ.b%0 b ba0 I    dMbP?_*+%"D??̗UT0 l0340 .(<H^>pVXdX2H34)*.113 33j8 "@4> %x   h P]5   &0 HX `  h pS04C8?$H6  7 L767 7 `px '`  7/H  &0 'H XH84V8P8BX8x8   S9 R `j4bjP5   2:%PxS6}4Do6@80><`<L LL"""> ` 68 `P#,k $`H0(88@ `0 8 x8 p0x@   `Tz(( 8   X @x`x(z~ $    `v`Vd   X z @ ~ @`b 0@`\`*Z  $0H@x  @h   `0k =88 @80 8xpH (0px xH( x0@ Pp0@d @(T @P @@@ @X0 @ @ `@ @ @ @ `pCXdP `@l @\ @L !$&`@< $0             @ , @ ( @0  @ @ dP $p(!X!@!H @!p @` 0 @p!P @!@ @< @, dNPH"@P"p $)" @` @8"P @"@ @< @, XZ(&* @d @"T @#D (@%4 @0  X `! ""!h$(#"$"$$@,_ $"$ @( @ @ (&(&X&%$'(d* @&d @@&T @&D @p&4 @&$ @& @ @ @ '' 2 @'x )x)h@'t @p 0)(()()0,%* @H,T x)P(`@H)@ @,< @0), @x+ p@`) @h* @)_ +`))j $%*x)n @(* -  @*)o(@8- (+(*o(& 2@* @* @* 2@* @* @* @+ @H+p ++}@`+` @P @,@ @+<_ +8`++ ++,4` `,+-(*@p,$ P*p,4@ @, @ @ @-_ (-, .$`P--@`- x-8-@- -`--`-@- --@ . 0.-.-8.,@H. `. .@p. .H.@. .p.@ ..@._ /./%`(/._ )`H//)X/.h/.8H. (&*$# (1p0H00/`0@d_ 0H0@T 0H0@0R 00@P 00 0@.111@L 1  C x40C `  p x $ SH4`4$ 7 7 L@9h4 P9 8?5 4 `  p /9h '!8.9`9p9h9 h'2:5P' 4 p'  x' 'S9'' "''''' ' ' x(%'(( #0( H(P( %X(h( " 11( ( ( ) ") 8)P) `) *h) )((* @* .H* "x*(, 0,/8, "  @,)H, `,h, p, x,, "(181,9,:.,.,,-LP1 - v0/*h1-/- -(--,-<X-./,, " @-.W/L P///P-.0- " 99:XX:J x::(:@:H:P: " 000 01@010 14X0000P00(0 " @&|X?.`0@*^`@ @>@ @<@<@ @(@AxpA@xl$ C@$ '$ 'Z$Data 2$0%4 SolverTable...:SolvTab<Table...>56B@8nlSolverTable...Data 2$0%4%6B@BlA@N  *aXhHA@PZ B@Jl(Zh 8B@n$ (!\!^'X X&'T V ( V!` T+& T 'TxlpZTypeDlog f%h OnewayOpt7j.b l b(`5n b!` l *'a ,'hadhnl0 %Z OnewayDlog f%hInputBox7.pMinBox7.tIncrBox7.vMaxBox7.x OutputBox7.zLocBox7.| ~5 ~(fp\h'5n' ~5 ~!f'r h !An entry is required in each box.  Missing entryA@' p!f$!b+The input cell should contain a value, not a formula. Value required for inputA@' p!f$!\!^ b*The input cell must be a single cell (not a range). Improper input cellA@' |!f$!\!^ b-The location cell must be a single cell (not a range). Improper location cellA@' x!f$ t!f$ b,The maximum cannot be less than the minimum. Improper max/min valuesA@' v!f$ bThe increment must be positive. Improper incrementA@'a p!f$2$!`+$ t!f$+ v!f$+" x!f$+'$ $" $ ^  ' +  z!f$. |!f$.hadh nl %1Z TwowayDlog f%h TInputBox T7 T2pMinBox T7 T2tIncrBox T7 T2vMaxBox T7 T2x0 OutputBox7.zLocBox7.| ~5 ~(f\'5n' ~5 ~!f'rhxp !An entry is required in each box.  Missing entryA@'$p!f$!\!^ $p!f$!\!^ b+Each input cell must be a single cell (not a range). Improper input cellsA@'$p!f$p!fb+The two input cells should not be the same. Distinct input cells requiredA@'$p!f$!$p!f$!b,Each input cell should contain a value, not a formula. Values required for inputsA@' |!f$!\!^ b-The location cell must be a single cell (not a range). Improper location cellA@'$x!f$$t!f$ $x!f$$t!f$ b%Neither maximum can be less than the corresponding minimum. Improper max/min valuesA@' $v!f$ $v!f$ b Each increment must be positive. Improper incrementA@'a T T$p!f$ T2 T$!` T+$ T$t!f$ T+ T$v!f$ T+" T$x!f$ T+' T$  T$" T$ ^  '  T+  z!f$. |!f$.hxapdhh` nHl@Z( (  * $  !\!^ %$.a  $  !\!^$   %$.hp B@lX @ *F$5(g T 7 (  * 0The input values are along the side, the output cell(s) are shown along the topC@' V   ' 7 V!9` 9n( T$  $ ; T$+ T$ T;$'aIQ .Solver has converged to the current solution. All constraints are satisfied.+  b,Solver cannot improve the current solution. All constraints are satisfied.+ a 'Stop chosen when the maximum iteration limit was reached.+ iehh0  T7B@' V   ' V!`9` n '*'* HQ T7Stop9`$ C@$ C@$ C@$ C@ $ C@(5(n T7No convergence9`&This problem has no feasible solution.+ is p!Solver stopped at user's request.+ (5(nX T7 Not feasible9` $ C@ $ C@ (5(n T7Stopped9` $ C@ $ C@ $9`(5(n` T7 Not linear9`  'The conditions for Assume Linear Model ,are not satisfied. (This could be a scaling /problem--big numbers mixed with small numbers--"or it could be real nonlinearity.)+ (5(n8 T7 Too large9`.The problem is too large for Solver to handle.+ le.(5(n T7 Error value9`'Solver encountered an error value in a target or constraint cell. + (5(n T7Stopped9`0Stop chosen when maximum time limit was reached. + d.(5(n` T7Memory9`(There is not enough memory available to solve the problem. + (5(n T7SOLVER.DLL problem9` Another Excel instance is using SOLVER.DLL. Try again later. + (5(n T7Error9` T7$all Stop+nts ar(5(nhk`  7$  !\!^7$B@na' V   '  $   %.The first input is along the side, the second 9is along the top, the output cell is shown in this upper corner.C@ V!9` 9 $  $+; T$  T$+;8an( $  T$ \'*' V   ' $9`h( $)Solver found a solution. All constraints (and optimality conditions are satisfied.' b$.Solver has converged to the current solution. All constraints are satisfied.'a$,Solver cannot improve the current solution. All constraints are satisfied.'h V!`9` V!9 T7No convergence9`$!The target cell didn't converge. -This problem must have an unbounded solution.C@(5( T7 Not feasible9`&This problem has no feasible solution.C@(5(n HQ T7Stopped9`!Solver stopped at user's request.C@(5(nHQ T7 Not linear9` $$$'The conditions for Assume Linear Model ,are not satisfied. (This could be a scaling /problem--big numbers mixed with small numbers--"or it could be real nonlinearity.)C@(5(nHQ T7 Too large9`$'The problem is too large for Solver to handle.C@(5(n HQ T7 Error value9`$'Solver encountered an error value in a target or constraint cell.C@(5(n8 HQ T7Stopped9`$$Stop chosen when maximum time limit was reached.C@(5(n HQ T7Memory9`$(There is not enough memory available to solve the problem.C@(5(n HQ T7SOLVER.DLL problem9`$ Another Excel instance is using SOLVER.DLL. Try again later.C@(5(nX HQ T7Error9`$#Error in model. Please verify that $all cells and constraints are valid.C@(5(nk  7$ $ 7$B@nPH@8h0l(8 Z  'T V ( T$& V(` T 'T$$$(`a@ T In T$$ T$(`ph (l  *,$Z$.(. 4B@n 6B@n*A@F$ C@' <5f'Enter a value in this box.'@Value required'B5f$Nb'"Enter a numeric value in this box.'@Numeric value required'BStopped+'#Enter a positive value in this box.'@Positive value required'B F5f b'&Enter a nonnegative value in this box.'@Nonnegative value required'B Not linear+'*Enter a value between 0 and 1 in this box.'@Value between 0 and 1 required'B J5f5fdb',Enter a value between 0 and 100 in this box.'@ Value between 0 and 100 required'B L5f b'(Enter a value of at least 1 in this box.'@Value at least 1 required'Bh'nx'lp' @  BA@ <9fC@Rn0'l(' 'l.'' $dn, OptNo entry'BImproper entry'B"fu'a(. .Improper range'Bce hl'Zp'3Enter a cell address (or a range name) in this box.'@rang'h,h, p9fC@Rn,u,h,,9fC@Rn ,h'1Enter a cell address (or range name) in this box.'@+The input cell should contain a value, not a formula.'@0, Not a range'BP1 Too large+@1  @ BA@P  @ BA@P  @ BA@P $d$!\!^  +The input cell should contain a value, not a formula.'@Improper entry'B x @ BA@P x$d$! A@P F < @ BA@Pg 0'l2 8 t$d'`',The maximum cannot be less than the minimum.'@aImproper values'B t @ BA@P J'xh1Zp    x$d'box b ` 1Z xZ` $d$.e !This range must be a single cell.'@omap3 H Error value +Stopped +uZ  *$+$a $+$h$ 'lu#Error in model. Please verify that $all cells and constraints are valid. + )Solver found a solution. All constraints (and optimality conditions are satisfied.+ !The target cell didn't converge. -This problem must have an unbounded solution.+ Memory +SOLVER.DLL problem +Error +No convergence+1 Not feasible+ *F(A@&g *F(A@&g'*h15 put2n@5 Remember that the first input cell is $! %B@  Remember that the input cell is $!7B@ Remember that the second input cell is $! %B@s4  $   T  %  $   %$6 $"'l6Start f! \SolverTableHelp.htm'6\'*$+$ax7$+$$+$h@787"Z 00p  $+$ (A@&hp7  V!9$' A@& *6 * $   2 T7B@a8 $  T7B@h83Note: The Assume Linear Box was turned off; Solver thinks the model is not linear.'2p8 XFA@Rg'X Linear = SolverGet(13)'X(A@& 4ah $ C@ *F$5(g *F(A@&g *F(A@&gB@ $   2C@Ve9Z X 'Improper entry'B x @ BA@P'h :l: x$d$$N +The input cell should contain a value, not a label.'@:;l;n0 f%F.htmC@A17"C:\SolverTable\SolverTableHelp.htm5HB@8:P;xZ f%F!H!^'P There are P hyperlinks.A@l;The address is  f%F%H!A@;l f%FnH<  There is 5H!^ hyperlink in this file. Its address is 7H!. The workbook is  f!A@<l= f%F!H!^A@=$Z( 8   HpxEA Solver function cannot be found on your system. SolverTable should Fstill work fine, but the values in your model won't be reset to their original values. Missing Solver FunctionA@<The boolean values are \ and  ^A@'\'^n>Z ew77$.~?Z0@Z  T$ T;? (!|!^ (!!^ (%\77$.z?Text z%\( ~Text7\(Text 7\(nX?A@xl@?77$.z77$.~n> ~@ 7\(@ z%\(nx>p>@7\(AzAttribute VB_Name = "Module1" Option Explicit@Base 1Pub4 TableType As Integer,putCe ll(2)0Range, Out._ Loc1Min In0DSingblEMaxFNMs3cr GL inear7Bo oleanC m$Val1(a? 2 Dim Orig 9 3( (Ch{SolvMsg(0 `To 13Dng, Err3SwitchtSMissSAerFn A@Oneway &TwoNLNConst ONEWAY@1, TWO2Sub/p() G#.@ProcDataInvoke _Func \n14ASetTupt@3s*s#Form.SHhowIf='TheD~< Else@ nd If GetCurrent)zue$CrOldDef_@Messag R g= @((4)WKa6=.".0Coun@%RewtciX ?@ Each bIni #a E}i) !.A! i +cNexT k1A "!(1DV4=oJ]'Ĩ=9"zer.xilt P(;:cO;T ruXBox d"A f@"cannot be$ f6d your syste m.`le should " $& "still work ap, the valu inB B moden' reset toAir oinal.",@ vbInf@a!,샮e! tEsrrb!c{o,CW{9Ap~ .Scre enUpdng ,"Gs*]{T99J, JOff`(N"'s+,H;=[.o(sok2)oi * ;)V%`e.b ,_es20(0q="3.a soluQ#. AP,cv@raints)aopmalit$y dis ar1sfieApher`stance u1^SOLVER.DLL. TAgN @:=!"|. Pp7ify>. aT0Q`SR0iRZD@NoA2R?@_;Not:?T:98!,t,+" ۵ SolvErrMsg(9) = "`or value" 10Stopped>1>Mem(ory<2|OLVER.DLL problem*3*witchNote: The Assume Linear Box was turned off; er " _& "think!model is not l$.:End S@ub  Run%() Attribute .VB_Pr@ocDataInvoke_FuncY \n14AeDim i] Integer, jResulBt cellVariant,fkAs SPng, Was BooleanApplication.Scr@eenUpdng+False G= If TBaoType ONEWAYdYWith Loc^C@/A.pT ext "qinputÝs are alo!t@g@side, Ao|utA Jr@tH(s)shown^ .Offset(1, 0)H#Remembthat&`TI09(1).AddressUKIfLoop Until <> 7<= 2pgah%xijjCj42kkm/c.Num =j'4c.rior.ColorIndexT36 _; ;Ea-1/&Q*~`k("OG4|U + N!HC^l x &P"PuSeEt]?%IerDarW  k(5 u1), _* p.aVs,unt)).BorderArou` Weqi :=xlT, C'01AutoP6icG!$8 ?:first ` ~҃&@P4d?x|&"seco 2ut2o kB4U;k@ (k - * ( ՠ2@"0? oe  Q93in@}u0\bqo@rÉaߡ//bl2?,ҡpPj2(m _AA  9!K ts(R.Or C kbooxٕ" B_2ŗDish:=Tru e) If Result = 7 ThentSolverOptions AssumeLinear:=FalsetWas)f)End IfLoop Until<> *7'k]0For Each cell In OutputRangY$k + 1&With LocC'.Offset((k - 1) * (N$In/s(+ 2)#i, jÁ'<= 2.ValuevhT Number@Bmaz (Gp .Interior.ColorIndex#36EZB)5AErrMsg(COS#4 ՚<[H.NoteText .!. & "@& Switch@zHj Y\\X, 04m(e12,@e, f, _7!E2))).BorderArou`Weight:=xlT`hin, VaAuto cicE$N@>k+hEuUSub Publi c atore(/Attribute.VB_ProcDataaInvoke_Funcu" \n14"Dim i teger,As VariantiChA g Orig|(ihE! iG&%Tab leTypONEWAỴbƢ A 1D aB To 2CLag i)s 4QaApp3aa.ScreenUprdng #;9CheckEB(EBox1Control, FlagBoolea@X$^al NoxnneIpG1S!ng, 2= |@0.rN= ""jS = +1 @Ec a v"lin this` box.t(2 "0nrequiredH Q Islhc( n) x1q n`r5    = J#< 0 wn0%veC"I ,O b"BCp(rEB ""%p]% AIJ('-!F)ringd,@!1, vbExcla1[o0@4 19a4B @s 3must be9sB bsLImproperX@2\j^A1a,xi !:: Q^#a4#d 5AZOI  P8#DrHas|mula(I=92_7`r _7Q7p`%h#0#2@G'5shoulhd cP}ap6tp,p not`La for %g$8PYIlBox, MsgB1P2 Flag = TruePEnd If Sub Public  CheckIsNumeric(I As Control ,  Boolean)Dim|*String'FalsIf Not qRange(Trim|))) Then?" input cell sh@ould cTain a val ue, n." _!& "a label.",2,ImpropPer ezyCyrEB p¶MinMax(? d5@-inValfil@H@JDj( g+ax-xD< Dsmaximum canmbe less thane minm}sPmC,m(AZ= "@SetupJtUss(AWith ActiveSheet.Cs(IRows.Count,K olumn Oneway(.Offset(-8,@ -1), 0#,Two714, 0+0)ED7).`berFormatj@D+!Ca13W ! AX, zdP% L" $ L .L0,dhL0 H  0  9 llM\ @L ll=/ L:<]/,l5L\lCxCttxl  hKmL(',% llM\ @L ll=/ L" $ Q(pl6L,fv(',% llM\ @L ll=/ L" $ (aav")l(6L,dCxCttxl   Cx!Cttxl   x0mxtp(l(L,W<'@% ppM` @P lp=/ P" $ :%( %_ahxxTx6hT <:%( %ahxxTx6hT<:%( %ahxxTx6hT ,,xdPhT@0     /rU $`$`$`$`$!`$I`8q` !y=I#8` 9Q=I008` !=I##4 `!=I#4 `!=I#@9 ` q!=I=I#$a `p<7j@Մ{F7j@Մ{xD R}4{4#7j@Մ{rU~}  bab (V (b !I#i A '1Fi )+*4y5IgYo 72+8aI' 1 9@aBC DDiEFIGYHHJJ LLMQNr PP xYRS TTQUUqF HIJyKNK)RqS)U)1@Ax9BaGyy zAzV XY "$ ?"$T"$     _ $ Kj =0'4%'T+dD ' D" $ Q06TD4/_aT00aDv"pf06TDkfpzhr,hWT(*kz5T kzpz hs, 'AXaT*5Te'AXaT*5T'AXaT*5T <''4:*NDD@+,*#(-*FT )/(6TD4t,j,h$(0TD4`% d" $ d .d TD4%_aTddaDv"i$%_ o% o%" $ Qxd6TDKTD4%_aTddaDv"Ti$%_ o% o%" $ Qxd6TD xo`,Kxh$dTDX/0*#x;/x12*#x;/x32*#x;/x45*#x;/x67*#x;/x8;9;.:;*#x<*#t=*#p;2xtp>;?@*#x ;/xA ;BC*#x ;/xDE*#x ;/xFG*#x ;/xH;I;J;K;L;M;N ;K ;O ;P ;Q ;RS* $ xtp ` % T" $ T .TpZ   PTU*F@%Pg5@]VAXa@`#<*F%(,%(%P TTg/<T6@ pxdrG kxpx&(,%kxD%P@5@dW@W%,5@,%, dszTckZK'`'p''''''c@''' P X46@ p`PpZCkzj@%kzD,%(%P@TTT5@$kzj,%AX, ' c@ Y Upv6@ kvL'`'p''''''f@''' P X46@ p`PpZ kv" kvypxdrkZX K'`'p''''''c@''' P X46@ p`P` XX @ P<84\dP<T @ p`P$pzhrdIkzjT%h( kzpz hsd ~%jT%AX,zcP#kzjT%kz7j@Մ{` D 4SLSS6"<4*L<8<<<N0{00020819-0000-0000-C000-000000000046}n65"*\Rffff*936702746*\R1*#175*\R1*#174*\R1*#173*\R1*#172*\R1*#171*\R1*#b8*\R1*#20b*\R1*#3dp($H $h=" $f $  $(8 $i ` $ $ $i  $ $ $i fҋHB $fhp8`|l(i: f $f $ $$20@(0@(x @Xh @@X @pT @D @4 @0 @ ` @ L( @ ` kh(@phME  " m@LD` ( "  068xpl(llData 2$0%4 i SolverTable...:SolvTab<Table...>56B@8nHSolverTable...Data 2$0%4%6B@BAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |CreatablFalse ^PredeclaIdTru "@ExposeTemplateD0eriv$eCustomiz2Option /licit P"& Sub _Open() With MenuBa rs(xlsh eet). s(t"Dw" Items.Add _# CaB:="SolverTP...", OnAcP  before/End U\ fnBBCl@X(Cancel As BooPlean1OIrror Resu@Nex@K/`B?(8).Delet{F)rU = ##i 1Q" 9"__SRP_2 E__SRP_3QSheet1TTypeForm4"#` `1?m:4%h%x"$ xXTTaDO00 )xT06XD D:h%:4%: %aXQ xxx5X p($xT0XD 0   44SrU @$`h()`l #p<,7j@Մ{ F+7j@Մ{x8}4<4#+7j@Մ{,7j@Մ{b4(SLSS6"N0{00020820-0000-0000-C000-000000000046}n65$*\Rffff*13367027ce(XuJ$H0h $"" $ $ $8 $h $8p $ $ $@xME xpAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |CreatablFalse PredeclaIdTru "ExposeTemplate`Deriv$eCustomizdOption /licit rU a `a**y* y 4 ME " ( 82H0 " : "  "hxp x`lh A@tXlH A@tMd0(XlHl8' *'l a ,'h A1 (%B@Jl x = Shell(RunName, 1)P>XuP ?This was supposed to open your default browser and display the Hhelp file, but your system isn't being cooperative. OK, try this. Go to 8Windows Explorer (file manager) and double-click on the %SolverTableHelp.htm file to see help. ll:5Tahoma@ (Output cell(s):5Tahoma@$(Location of table:! 5Tahoma@,((upper left cell of table)M 5Tahoma@(Note: Be careful. The table will write over anything in its way! You might want to delete any old tables before creating any new ones."45Tahoma@(If you already ran a oneway SolverTable on this sheet, the previous Unknown errorA@x  f%F= "Stan5HB@Bk.PathXlZ f%F!H!^'P There are P hyperlinks.A@ f%F%HB@TpA17 f! \SolverTableHelp.htm5HB@8hZ   $"'Start f! \SolverTableHelp.htm'Attribute VB_Name = "TypeForm"  Bas|0{87B6640F-C0FA-11D2-ABBB-C4098951E977}J1J dCreatablAiFalse PredeclaDIdTru "E`xpose@TemplateDeriv%Cus tomizDOp tion 0licit P"& Sub CancelBut ton_Ck() Unl`oad MUAct=Sheet.Range("A1").Sel ec+End  , 4Help3Dim x As Variant, Run rSngG Start " & _ThisWorkbook .Path"\SolverTDA .ht x@b3ll(D, 1>/OK/If @Oneway@Y Then#@ONEWAYE‡ &D TWOG nd IfC b!'UserA_InitializfeEq'= Ý{X27j@Մ{/7j@Մ{7j@Մ{17j@Մ{x@}4J17j@Մ{27j@Մ{88848<@DHLP8@SPSSSb2  ( 0 8@H xhP  + (C@  ^   )  ,>8h)@+ C =H r2&(Pn2X8 x K     H  X  ` hpP H0xH8 0@ L Lp LP 0X LhBB   "Px h `    X "0 H @    8 " =  F8 = X  LHLXL($  $$$    L  F8 FhH  p           P 0 (  8 x @ H  P X `  (xlh A@tlH A@t d0(InputBox7.pMinBox7.tIncrBox7.vMaxBox7.x OutputBox7.zLocBox7.|O ~5R ~(f(\ '5n' ~5 ~!f'r8h0( !An entry is required in each box.  Missing entryA@' p!f$!b+The input cell should contain a value, not a formula. Value required for inputA@&' p!f$!\!^ b*The input cell must be a single cell (not a range). Improper input cellA@' |!f$!\!^ b-The location cell must be a single cell (not a range). Improper location cellA@' x!f>r Qw>r Qw?>r Qw>r Qwx}( }4J>r Qw>r Qw(YO48<@DHLPTX\`dlt|xph`@SPSSS @, @ @0 t:xv"@ @  Nz@H ` #(@ pH#(H%@ +@ h+@ @ @ @ @ `` H$xH4 @ P|@_ FM@ @ @ t @8d @PT @hD @4 @$ @ @ @ @ @ @( @@ @X @p @ @t @d @T @D @4 X$ @0$ H  @H @ @x @ @_ _f`((iv8zt8(x `X`$oX@x @h X 0XME " ( 82 H0 " Z+  &  & L + X + ?  $ t!f$ b,The maximum cannot be less than the minimum. Improper max/min valuesA@' v!f$ bThe increment must be positive. Improper incrementA@'a p!f$2Index$!`+$ t!f$+ v!f$+" x!f$+'$ $" $ ^traLin  'h +  z!f$. |!f$.h adh r nllhn pB@R ""9fC@R z p$d 1Enter a cell address (or range name) in this box. No entryA@u'a`lX p$. !+The input cell should contain a value, not a formula. Value required for inputA@ !\!^ b''*The input cell must be a single cell (not a range). Improper input cellA@'hh  p9fC@Rnuht3Enter a cell address (or a range name) in this box. Improper entryA@ p9fC@RnP Fug B t A@: p @ BA@P p A@ua z$d$. Fug B t$d+ Fug B t x A@x FuguHa@ x$d+ v$d+"A@Pu p A@ v FA@:  ,The maximum cannot be less than the minimum. Improper valuesA@ t9fC@Rn 'xuh'$ $" $ ^  ' + $ $" $ ^  ' +  7Enter a range address (or a range name, or range names !separated by commas) in this box.  Not a rangeA@ z9fC@Rn p @ BA@P'B u +The input cell should contain a value, not a formula.'@Improper entry'B h@ Fug Buh |9f p$d$2ntai |$d$.foC@RImproper entry'B p @ BA@Pu(h nhu`9fhP'C@Rnh'hpA1 (%B@J0 Fug BhImproper values'B t @ BA@Pn the $ $" $ ^ 9fC@Rn'xuh V  V!` z @ BA@P Msg2 Empty cell'Bde an | A@ z9fC@RnXuPhH@0u$! !Output includes input'Be z @ BA@P't be  ' v0 + uhh@h0  $$! !$'/The location cell shouldn't be the same as the input cell. Improper location cellA@$   $! !b'2The location cell shouldn't be part of the output range. Improper location cellA@hP h@9fC@Rn(u  V!` $  !\!^ %$. V  uuRange required'Bmp.It doesn't make any sense to include an empty cell in the output range.'@,The maximum cannot be less than the minimum.'@the Enter a range in this box.'@ z @ BA@P  )The range where the table will be placed is not empty. Are you sure $you want to write over its contents?   Write over contents?$ h /The location cell shouldn't be the same as the input cell. Improper location cellA@   $! !b' 2The location cell shouldn't be part of the output range. Improper location cellA@ah FugH x A@:008 z A@ FugA69F5The input cell shouldn't be part of the output range.'@  $d''a ' r p A@6 Fug'p t x bahn7\'v 7\'zlla( v'z'|'b;\$!;\ t$d;\ x$d;\ v$d;\ !;\ ! ;\7\wayRan7\'p7\'ts(7\'x 7\'| 7\ T$  T 'b'a8''t'x'v7\'h  T$, b;\ap;\BohX x$d;\tput v$d;\d Wi $d;\putBh zh T'ah$  +  9fC@Rn(u a  +' @  '$($ T $" T+  T$, T   $N,Enter a set of numeric values, separated by commas. Improper inputA@   T   $$d' )Z  8 @Xp   T  $$d' l C@R9lC@R9 tnh x(62A69F v(E-9E98 (A4F} T n( t( = x(table" v(tHeigh9f9n9f9n9f9n9f9n t(  x(  v() Ty (7\ t(H x(u v(Taho (es\Mic x( v(tAttribute VB_Name = "OnewayForm"D Bas0{87B66415-C0FA-11D2-ABBB-C409895@1E977}J09J dCreatabliFalse Predec$laIdTru "Expose@TemplateDerivCustomizDOption 0licit  P"& Sub CancelButton_Ck() Unload M#UAct=Sheet.Range("A1").`Selec+Epnd , 4OK2Dim Flag As Boolean, kInteger@, Msg1Sng2_+ @2lVariant, Ans8wer+, iInputNCha rsJ svCommaJNumMV ,Chec2k@id(Bohx, ,BFC I"fITheritGX=Hasu8la VIs,cmSet Cell(1)@2(Trim(")@11 A1&0EB Min>χ-AX>ax&Max` `b# b@ nhb9@!Incr, Nonneg:= a<#aD k510Do Until!!+q* '! k +  LoTopNb s#k9Rea a1(OH`[v= @Go '!wbiPi2+ (i - SgNexbwa x=qY u es+;D= Lenc^= 0` s`0H"bf3d `,`," Or$lS$$!MiI?- G.H!a aE*-?? W5FhIf/3f"rNopLEP()|J@i0 "EPjr a spPof numRTvalP",`parvd by8 " (b& "c!es.", vbExma{, "Impro|pe!.WxithX6*.T@/'"% }tFocuso11x=RQǯW#= ioQN43sP oaCEserveVE(1^ ?% =gEGKaQSY_Outp&ag"*1yS= (y62A!GEach “In 3. :u"1HIt doesn't make any0nse to includA Pto10@ the o Zrq.,+820"EmpQ CPr@u21R2'=qE^+Un5`(,$).Addres^h?[W 1 Pshould!be @Et F ebs3?r_+alqU+Loc"+//b +`**Pr$/$Opۓ` "ql\ocV'saasN\*iQY[[Zqp$ge, $ $" $s 9OO!3 %% "8jj/pR_YJv.Off@v(ܳNInputs(1), _ OutRange.Cells.Count))For Each c> In Answerf IfF.Value <> "" pThen J})MsgBox("  r where thable will be placed " & "is not em@pty. AFyou su6want to write over its contents?", vbYesNo +@vbInformation, "W%#x) =$#fFlagTrueEnd If pxit ҋ NextCIa$With Loc3g .T@(""SetFocu>sAH)SubCI!OnewayLä1=2T¶@ .A`ddres!8Opt13 a4Trimp(MinBH 5)G axV 6F Incr Els{&v2=H7Bs̋ 8!~n&>9@a+ +k;Unload M`"< Priva j !0_Clixck(d(">*:En~d`=+`.KM..qD-t&HFa1W2PP0_ [Mo?aUserm_Initialize 4Rr jD~1DQk!Q9D2lgoBw= G$Ca&eyE{'4,ac4g5p 6T` kOFq1FQ`>2 { No a s H#}1OG% }$-7CycV08lcvg92 V pxq/Q Nq7Q8qTVq8?/#Q)#v# 5({ #xgzTT4(D]/$T6h4\F(X%xahTT4% !  ,)T 6h4=(X%xahTT4(D]/$T6h4\UchT! T T5hT! T TT! T TT! T TL(X%xahTT4$$ !  )T 6h$L(X%xahTT4$$ !  )T 6h$L(X%xahTT4$$ !  )T 6h$$:XNhhT! T T5hT! T TchT! T T5h$:XNhhT! T T5h$:XNhhT! T T5h$:XNhhT! T T5hT! T TT! T TT! T TT! T TL(X%xahTT4$$ !  )T 6h$F(X%xahTT4% !  ,)T 6h4F(X %xahTT4% !  ,)T 6h4b:X%T! T,TchT! T T5hT! QT    h T! QT    h T! QT    h T! QT  h   :X%T! T,T:X%T! T,T xT! TTl8b x T h4$|txpH;__SRP_bTwowayFormpj__SRP_8  +__SRP_9C MET " ( 82XH0 " `H+ & &x  + & &  4`3x    LL(+8 H+X h?x //+ /*(  HX`0H .%` (  (A2.A0`(>hb2  ( 0 8@HPrU V2(a'**)+#`iq9P````ai8 @`'YiZYYaf\H`^_iW ``0Y]^)2a**y*Aiy4Q!8Q!1<Qa@QDY H1 AY ` L  PY aTY  XY  \Y !`Y 9dY hY IlY Ipq a`  t a `1 xq a`q  |  ` Y Q!QyQ!s ?    0   +D! z+>lD=@@  )D@kz8&D! zlD=@@ )D@kzi&D! zlD=@@ )D@kzL@' %D! QDo, " $ l@ @6, D! QDo,(+D! +>zlD=@@  )D@kz2+D! +>zlD=@@  )D@kzh?D! @! zl@=lD=  )D@kz/D! QDo, *6,/D! QDo, *6,+D! +>zlD=@@  )D@kzF/D! QDo, *6,px(kx kxpx|kxZc%%kZkZv ZdR(D! QDo, `1T6, lTJpRpPpJZkRcDA(,kZTM@ :]/ kZkR6,\82(,kZTM@ :]/ 6,\1AkZkPD,kPTM@   `1L6, q>kZkPD,kPTM@   `1L6, lL0LM@ 2'' :N0*F, 6, D! QD  h   6kZpP kJpJkJlL+kJv ZdzkJ+D! z+>lD=@@  )D@kzC@' %D! QDo, " $ Q@6, "`rG`W,:]/5,\:  *1t!Cp)D! ptlD=@@ " )D@ `s '$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%' %'%',% @"D" $ a`#"Xa`#02)D@_6<tdTD4$, tdTD4$#Ct$Cp)D! ptlD=@@ " )D@+D! z+>lD=@@  )D@kzC@' %D! QDo, " $ Q@%6, = AXa,`#"%Xa`#026,pz2'' :&N0'(*F, 6,   '$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%' %'%',%"%@"D" $ a`#"Xa`#02)D@b  6<tdTD4$, tdTD4$ pz2'' :&N0)**F, 6,  D%"Xa,DDav"i%"%X @ o%"%o%" $ Q@\D6, l\`r `W,:]<5,\ K'' :+N@,-*#.*F,^/6,  pz  `sr kz= D! QD:%,   "0(%(%a,DDD5,H(% AXa,`F %aDDD6, D! QDo, 0(%(%a,DDD5,L(%D! QDo, %a @@@6, L(%D! QDo, %a @@@6, L(%D! QDo, %a @@@6, n 0(%(%a,DDD5,L(%D! QDo, %a @@@6, B(%"Xa,`F %aDDD6, B( %"%Xa,`F %aDDD6, lD"/$0 1DPn 8 tpL\T`$D@, tdTD4$tdTD4$x! Qxt t  t  tx! x xx! x xx! x x(txx! Qxt t  t  tx! x xx! x xx! x x(tx "x=(X%xah Xhx  + + ? 0/@/X+p /*(    .% ((0 @PX` (Ax2.A(> (b2H       (0@+p C ^  ( )@ X` hT <h )+ (C8<pxpp2 &n2hV~ 0]`P p K@PH X `hpx     0 H  0 0L L L LHH  0 0L` Lx L LB B(  @   "    ( 0 @ P` " hp x      "         " (0 8 @ H P ` pA>r Qw7>r QwA>r Qw@>r Qwxb0I }4.J@>r QwA>r Qw70ZZ#[%4@DHL8< XT\ P`dhlptx|   $ @SPSSS6" @H , @`  @x @ @ @ @ @ @H  @8 @8  @ @H  :@ @ ( `h$ P " N@ ( 3@H 083`5@p H;@ p;0@p @` \`@$    DpP( z@(Z @e@XX P(ep(g `    @V Xm@T mP`@$v@xL_ (P|~@P< @h, @ @ @ @ @ @ @ @( @@ ( @X  @p| @l @\ @L @< @, @ d@ @0 @` @ @x @ @ @ @ @ @x @ h @8X @PH @h8 @( :@ @ @ @ @ @ @( ours@@ val@X @p @x D@h 4"@X H@H @8 @( @$ @0 @ @` @ @_ xx`h$` $t@H8L_ hx|~P< @, @ @ @ @ @ @ @ @ @ @ @| @l @\ @L @< @, @ @ @ @ @ @ @ @ @ @ @ @x @h @X @H @8 @( @ @ @ @ @ @ @ @ @ @ @x @h @X @H @8 @( $ @ @ h!( @ @_    `h!@ P 8 `h!h!!X!H$Xh!0x tP!`h!H$"H$XH$@x @h H$X P  H0@p8 P  H0@p8 P  H0@p8 `X0 <  " p =  F8 =H` h x LLL$  $$$   ( 8LH X FH =Xp x  LLL$  $$$  ( 8 HLX h F` Fp                       p x                       ( 0 8 x`lh A@tXlH A@td0(A1 (%B@J9fC@Rn LocBox = ""l OutputBox = ""  A@ Fug  A@ FugJ $d$2X  A@: Fug  A@: Fugxk   A@ Fugxk $d+ $d+  FA@: Fug $d+"'$ $" $ ^  ' +  z A@ Fug  z$d$. V  V!`.It doesn't make any sense to include an empty cell in the output range.'@5@ Empty cell'BCp z @ BA@PX=uh' $! !$! !($ 'aOutput includes input'BT z @ BA@P u h | A@ FugT |$d$. V   $  %$. $ $  %$.Im   $! !b' 2The location cell shouldn't be part of the output range. Improper location cellA@a V!`  )The range where the table will be placed is not empty. Are you sure $you want to write over its contents?   Write over contents?$ 'rhhh  |9fC@Rnuh  A@ Fugi4%  A@ Fugo $d$2$  A@: 0The two input cells should not be the same cell. Identical input cellsA@ 9fC@Rn' uh  $d$! $d$! Fug  A@:' Fug`   A@ Fug $d+$ $d+  FA@: Fug $d+"<'$ $" $ ^\  '@ +   $$! ! $$! !4An input cell shouldn't be part of the output range.'@ .The location cell shouldn't be the same as an input cell. Improper location cellA@  !\!^ F  !\!^ $   'g@  A@6 Fug  A@6 Fug)Lx l  MinBox1 = .Cells(3) IncrBox1 = .Cells(5) Else  End If| IncrBox2 = .Cells(9) InputBox1 = "" ~;\$!;\ $d;\ $d;\ $d;\ !;\ !;\n $!;\ $d ;\ $d ;\ $d ;\ l ~7\ If .Cells(1) = 1 Then! InputBox1 = .Cells(2) MaxBox1 = .Cells(4)! InputBox2 = .Cells(6) MinBox2 = .Cells(7) MaxBox2 = .Cells(8)" OutputBox = .Cells(10) LocBox = .Cells(11) InputBox2 = "" MinBox1 = "" MinBox2 = "" MaxBox1 = "" MaxBox2 = "" IncrBox1 = "" IncrBox2 = "" End With InputBox1.SetFocus 7\'7\1.SetF' ( ( (7\'7\'7\'' (a'''' ( ( ( (7\'hH7\'z7\'|a '' 99fn 99fn 99fn 9f9n 'z'|hx np B@R7\'  7\' ( ( ( 7\' 7\' 7\'' (a '''' ( ( ( ( 7\'h8 ' ' 99fn 99fn 99fn 9f9n   9C@Rn ( ( (l 9C@Rn ( ( (l 9C@RnX ( ( (l  9C@Rn ( ( (l ;\a;\h $d;\  ;\aP ;\h8 $d ;\ $  T$ $ T $" T+a $d' ''' T   T$, T   T$,   T   $$d'a   T  $$d'h  $N,Enter a set of numeric values, separated by commas. Improper inputA@ 9fC@Rnua T'  ' @  +hh + h $  T$ $ T $" T+ a $d' ''' T   T$, T   T$,   T   $$d'aP   T  $$d'h  $N,Enter a set of numeric values, separated by commas. Improper inputA@ 9fC@Rnx up ah T'  ' @  +h( h  + h !-Z0H`P      Attribute VB_Name = "TwowayForm"D Bas0{87B6641A-C0FA-11D2-ABBB-C409895@1E977}J0,J dCreatabliFalse Predec$laIdTru "Expose@TemplateDerivCustomizDOption 0licit  P"& Sub CancelButton_Ck() Unload M#UAct=Sheet.Range("A1").`Selec+Epnd , 4OK2Dim Flag As Boolean, kInteger@, Msg1Sng2_+ @2lVariant, Ans8wer+, `NRowsiJHInput@ NChar@xvCommaNumMV@ C1 Check@id-Box1, MA,K IfCNThewitC]ABHasAula gH[Is-c12?1B  #B0(Trim(&()).AddressyEp2h4 3@Zhe two iL Ws should notl b s.", H! vbEx ma|, "Identicali aaWith9'a.Text"SetFocusa|A '$2 Ex SIf #Celpl(1).2`.c 1_1 K/BEB Min@0jgIaj '!k + LoTopGN2s# k9wRegpJ1('w S i To W!7i!)y+ (i - - N6Ewb=_G0 u esdh= LenI` 7i= 0K(mB fdF, i,a ," OrR6@} /eTsMi)  'QUqg, ')_ IN93f"rN@^j() KucEr a set of numrzval`",`pard by "-c & "c asedmpropeiLaUeG*#/ffIgR= i aND3s GUqcEservemE"DQD % &EgKLSp)r2rckrz`sBi~r߫ubT_aO?{!qD"(2r2NrI% dm4 r SA( 58 mmr rry rr# r!@=@,2rrtsA2rb r rϵe InputStr = Trim(xValuesBox2)NCharsqLenLl>PrevComma=D0lj$For i%1 To V/If Midd, i, 1)1"," O<Then <@2Num Ao+ 1H -  -O%Els/ 4)2ndX If3"N ot IsCompObj)pi56-53 n``$6V1U=V1UfL=o24A erHic() CMsg "Enter a set of num v,parated by " _">& "cs.", vbExclamation, "Impropi"SWith .TextT%.SetFoctusE@WTxit SubO~ч= iN ReDim serveE2( ;O##Ao a-KmN ,'N xs(2ucCheckidRange Out`M, Fa flag FbT< E-6D= =(˜f faEach cell %WIC b#f.u.eFcb1aIt doesn't make any@anse to includ emptbain the oi"! r".LV2E  CleparEB)!, !G )"\%=':/Uns()+ ,LC(1)).Addres!߈hක 2 ka#An.`I<@should3be b,%E8sc -?-A*U9`Loc5True_b_0@(_c ^ 8"r55G2)Mk:qNuXo@ " 8loc^/sam3s4_d2baccJTX,g I9+9?g)?on??)t?p@ss/ agNRow1:Y1a;"s.Count > 0=}b+ B.  */ ( + -Ans8wer-, .Off(,. ",h0A9n`PAV`<> Q(B.` wher`@]table wi`gqHlac_q. s notcc. A`you suπogAwa@gPwritdvts conts?RYesNo0x.TbvbInftorfWw}vb`/@pPh3S@j2+ W#@HK QqtYTwoway+71@s-1ngW1IOpt1_39wq 3[@27) h4qMin yC$5 'ax/lls(6&Incr?1n78 |s8_j 2 t 9Q4&d109M5R3?(1 2O(1D (1B)^oAddress  .Cells(15) = (Loc8. En@d WithUnload Me 0Sub Private  Opt1_1_Click ()j~ Min0Box1~.E@nabledyT ruQ .Se`tFocu M axFllKz{2h2hh2hT42_4h?6h?%hhPhUserForm_InitializeTwowayRangHIf E1 ThenGsA)""`nd2tB3#}wAa}@ez߰\ˆ4j5E6sꀀ""k.+Q1"D[eE)a. #o9A 9T '  \7l7oIfc28gl9c5Ɂc) 10 kwY1_ E1߽DZ]/( Z/$522A  + 2aCWT  2B / 213<2 OutdH V U 1!䤀/_.Text AAja7q # tqI!O ?3Q ?*E50&2O <G_ qXVqU?VqIر&?2Y(OOrC]VFC 5z FC$Y ??0 X  8+D! z+>lD=@@ )D@kz8&D! zlD=@@ )D@kzi&D! zlD=@@ )D@kz+D! z+>lD=@@ )D@kz&D! zlD=@@ )D@kz&D! zlD=@@ )D@kz2@' %D! QDo, "$ @a`#'%! Qo "$ a`#02)@6, c3'' : N0: N,, 6, D! QD: %,  : %D! D,DL@' %D! QDo, "$ l@ @6, L@' %D! QDo, "$ l@ @6, D! QDo,?+D! +>zlD=@@  )D@kzI+D! +>zlD=@@  )D@kz?D! @! zl@=lD=  )D@kz/D! QDo, *6,/D! QDo, *6,+D! +>zlD=@@  )D@kz]/D! QDo, *6,px(kx kxpxkxXc<%kXkXv Xd i(D! QDo, `1T6, lTJpRpPpJXkRc[A(,kXTM@ :p]/ kXkR`6,\O2(,kXTM@ :p]/ 6,\HAkXkPD,kPTM@   `1L6, >kXkPD,kPTM@   `1L6, lL 0LM@ 2'' :N0*F, 6, D! QD\  \ h \  \MkXpP kJpJkJlL+kJv XdkJD! QDo, +D! +>zlD=@@  )D@kz+D! +>zlD=@@  )D@kz?D! @! zl@=lD=  )D@kz7/D! QDo, *6,/D! QDo, *6,+D! +>zlD=@@  )D@kz/D! QDo, *6,px(kx9 kxpx kxXcX %kXkXv XdX{  (D! QDo, `1T6, lTJpRpPpJXkRcT A(,kXTM@ :p]/ kXkR`6,\ 2(,kXTM@ :p]/ 6,\ AkXkPD,kPTM@   `1L6,  >kXkPD,kPTM@   `1L6, lL 0LM@  2'' :N0rU b4 )+#i z |*`q9P````ai8* a@`'YiZYY|\H`^}iW ``'0Y]^)20aa**y*%iyA 4Y 8Y <Y @Y  D aH LY PY    TY XY    \Y `Y dq a`qhq aw`lQ!Cpq a?`1tQ!+xq a`|Y I1 Y `qY !Y 9Y  a `1  `QaQQ!Q!Q!Q!   Q!)   Q!A   QyQY *F, 6, D! QDP  P h P  P kXpP kJpJkJlL+kJv XdT kJ+D! z+>lD=@@ )D@kz C@' %D! QDo, "$ Q@6, "`rL `W,: ]/5,\  *1t!Cp)D! ptlD=@@ " )D@ `sLc  ' %'%',%'<%'L%'\%'l%'|%'%'%'%'%'%'%'%'%' %'%',%'<%'%'%'%'%'%' %'%',% @"D"$ a`#"Xa`#0$ '(%'8%'H%'X%'h%'x%'%'%'%'%'%'% '%'%'%'%'(%'8%'H%'X%'h%'x%'%'%'%'%'%'% ""$ $a`#"Xa`#02) D@$6x(XH8(xhXH8|l\L<, xh, <, %#Ct$Cp)D! ptlD=@@ " )D@+D! z+>lD=@@ )D@kz]C@' %D! QDo, "$ Q@%6, p AXa,`#"%Xa`#0 AXa `#"%Xa`#026, Lpz2'' :&N0'(*F, 6,  ' %'%',%'<%'L%'\%'l%'|%'%'%'%'%'%'%'%'%' %'%',%'<%'%'%'%'%'%' %'%',%"%@"D"$ a`#"Xa`#02)D@a6<|l\L<, , <, pz2'' :&N0)**F, 6, pZ5"Xa,+DDav"D6,+IkZ"Xa,+DDav"粪pZD6,]kZD%D%"%X,D,+o%"%op%"$ QD\6,l\`r`W,: ]<5,\K'' :,N@-.*#/*F,^ /6, pz `skzaD! QD: %,   "00(%(%a,+DDD5,H(% AXa,`F %a+DDD6, D! QDo,00(%(%a,+DDD5,b0(%(%a,+DDD5,L(%D! QDo, %a +@@@6, L(%D! QDo, %a +@@@6, L(%D! QDo, %a +@@@6, L(%D! QDo, %a +@@@6, H(% AXa,`F %a+DDD6, D! QDo,%0( %(%a,+DDD5,W0( %(%a,+DDD5,L( %D! QDo, %a +@@@6, L( %D! QDo, %a +@@@6, L( %D! QDo, %a +@@@6, L( %D! QDo, %a +@@@6, B(%"Xa,`F %a+DDD6, B(%"%Xa,`F %a+DDD6, lD"1$2 3D8XW@ \PLtpL\T`$FD@$, <, |l\L<, xhXH8(xhXH8(0   0   0   0    0   dhxp+$`0$)`4$i`8p0* pHd SolverTable8@ = t  n6(5 J< rstdole>stdole f%\*\G{00020430-;C 0046}#2.0#0#C:\WINDOWS\SYSTEM\c2.tlb#OLE AutomatioFn^ SOLVER.xls>OLVER.xJs E*\C4Program Files\Microsoft Office\Library\E_VBA_PROJECT$*dir__SRP_0<z__SRP_1 Auto_ClosewDeletex(SolvTab(GetCurrentValues GetTableTypemGetOnewayParameters=GetTwowayParameters(ClearOld (RunSolver7j(Restore>i`cellNCells~ SolverGetCellsCount0vValueKOpt1u  OptionButton ThisWorkbook| DialogSheetsK OptionButtons@xlOnShowInputBox EditBoxO MinBox IncrBoxMaxBox0 OutputBox/&LocBoxBoxyFlagAnyEmptyNkb EditBoxes MsgBoxR vbExclamation HasFormulaVal TableRange7 Application*ScreenUpdating! OffsetClearjaResulturInputValvMsgQNoteTextAddressHorizontalAlignmentS@xlRighte SolverSolveQ UserFinishs NumberFormatRInterior; ColorIndex BorderAroundWeight1xlThinw xlAutomatic@ MSFormsC_Defaultj SolverTabledWorkbookk Sheet1 Worksheet UserForm1)TypeDlog.x OnewayDlog6 RefEdit TwowayDlogUserFormN GroupBox7Label8,Label10@Label11AButton2]Button3]Label6,Label16FLabel18HLabel20eLabel21fOKButton| CancelButtonOKButton_ClickfClickCancelButton_ClickMinBox1yMaxBox1IncrBox1 GroupBox26yMinBox2zMaxBox2IncrBox2Label27lLabel28mLabel29n InputBox1D InputBox2DUpperLabLabel25jLabel31Label32UnloadeG_B_var_UnloadeJ OnewayOptW TwowayOptpLabel4, Workbook_OpenWorkbook_AddinInstallWorkbook_AddinUninstall AddinInstallAddinUninstall ActiveSheet%NUserForm_ClickUserForm_Initialize5c InitializeN _B_var_Opt1nOnewayOpt_Click OnewayForm TwowayForm׋ TypeForm(CheckEB.EBox[ControlMsg1cMsg2dPosNonnegZeroOne ZeroHundredpGE1 IsNumeric$*(ClearEBSetFocus_B_var_InputBox1N_B_var_MinBox1_B_var_MaxBox1_B_var_IncrBox1Ci_B_var_InputBox2N _B_var_WithYMinValpMaxValTrim@ _B_var_TrimmT _B_var_IfP _B_var_On6 NotARange _B_var_Set _B_var_ElseIfqm _B_var_FlagcInputCellNotARangeD& CheckInputBoxIBox IBoxNotARangeCCheckIB«vbAbortRetryIgnoreT$vbAbortRetryIgnorvbAbortRetryIgnoGRvbAbortRetryIgnvbAbortRetryIgW vbAbortRetryIV vbAbortRetryX vbAbortRetrI vbAbortRet vbAbortRevbAbortRjvbAbort)vbAbor^vbAbo9vbAb#vb_OBoxNotA^g OBoxNotARangeia^  *\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 Office\Office\EXCEL8.OLB#Microsoft Excel 8.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\stdole2.tlb#OLE Automation*\CC:\Program Files\Microsoft Office\Office\Library\Solver\SOLVER.XLA*\C..\Program Files\Microsoft Office\Office\Library\Solver\SOLVER.XLA ,*\G{CE1742A5-1B20-11D2-ABBB-EAE4E3FB242E}#2.0#0#C:\WINDOWS\SYSTEM\MSForms.TWD#Microsoft Forms 2.0 Object Library*\G{CE1742A6-1B20-11D2-ABBB-EAE4E3FB242E}#2.0#0#C:\WINDOWS\TEMP\VBE\MSForms.EXD#Microsoft Forms 2.0 Object Library.E .`M *\G{0EBB8479-2AD0-11D2-ABBB-A9AE98085949}#1.0#0#C:\WINDOWS\SYSTEM\RefEdit.TWD#Ref Edit Control*\G{2F91B992-5EB0-11D2-ABBB-9A8F0C353076}#1.0#0#C:\WINDOWS\TEMP\VBE\RefEdit.EXD#Ref Edit ControlEFn65}4Module1 ed36c1e59e*DD`xThisWorkbook 936702746*Dg{4 D Sheet1 13367027ce*D<4@bTypeForm 3636c1df4a*D9J`OnewayForm 1136c1d84f*D5JxYOTwowayForm 5836c1df88*D7.J#[`x@ <]L9amH`<]L9amH<]L9amH җrfƒ1%#rfƒ1%#rfƒ1%#H_ AsCEachEElseIfSFalse_Goto`IfcIndinputlIs|meReDimThenToWith ATTRIBUTE VB_CREATABLEVB_DESCRIPTIONVB_NAME Excel+(VBAWin16~Win32MacSolverTable95New.xls`+stdole` Module1b _Evaluate (TableType (InputCellRange  (OutputRange(LocCell=(MinInput~(MaxInputc(NInputs(Incr|Z OrigInputValIOrigVal  ChCellRangeT(ONEWAY(TWOWAYT= Auto_OpenV MenuBars% xlWorksheet,Menus!L MenuItemsAddrCaptionxOnActionbefore CheckSingleCellIBHas _B_var_Msg1 _B_var_Msg2InCellvby vbYesNo vbInformationnvbNo% _B_var_ONEWAY _B_var_NonnegzB _B_var_ForjL _B_var_cellUnionFlaَ _B_var_FlaK Validation  AnswerRangez@The'(CheckHasFormulaDICellGRagtCheckHast_B_var_CheckHas|aCheckSingleCell\E\Checko _B_var_Check\{ (CheckMinMax"_B_var_CheckMinMaxCheckValidCell_B_var_CheckValidCell SingleCell3 IRangeRBoxRRange RBoxNotARange|z(CheckValidRange_B_var_CheckValidRangeHzM_U^MaxBoxz2GW_B_var_MaxBoxz2. AddCommentvmCounxNColsV _B_var_NColsErrMsg _B_var_ErrMsg`?DefineErrMessages _B_var_Sub(DefineSolverMessagesؐSolvMsg_B_var_SolvMsg SolvErrMsg/g_B_var_SolvErrMsgNRowso HelpButtonHelpButton_Clickf DisplayHelpKHelpName xoRunNamePath2ShellV(Linear SolverOptionsJ AssumeLinear; WasLinearA_B_var_WasLinear3K _B_var_LoopFontU SwitchMsg _B_var_SwitchMsg(CheckIsNumeric<<Workbook_BeforeCloseCancel BeforeClose~;CannotDoJKCannot> _B_var_CannotO AddHyperlink Worksheets Hyperlinks: HyperlinkwFollow} CountLinks=ne CheckLinksEjAddToFavoritesGetRid-MissingSolverFn)G SolverErrorNHaveRun1+HaveRun2+HaveRunuHaveRuJDHaveR]Have RHav Ha~]H_ThA_TkLabel22gLabel33Label34 Label34_ClickI (OnewayRange"RowsU (TwowayRange MaxBox3IncrBox4 TrimMinBox1d OptionButton1k@ OptionButton2l@Label23hTextBox1SOpt2v InputValuesBox% InputValsi_B_var_InputVals1s _B_var_ReDim_B_var_i _B_var_InputVal:N InputValues_B_var_InputValues^InputStrki_B_var_InputStr@NCharsc  _B_var_NChars  _B_var_Midp PrevComma _B_var_PrevCommatNumStr _B_var_NumStr!PrevC NumString (InputVal1i_B_var_InputVal1s_B_var_j NValsַ _B_var_NVals{ (InputVal2i_B_var_InputVal2s Opt2_ClickS Opt1_ClickWEnabled۪Test4Columnsp9Frame1Label35Label36Label37Frame2TextBox2STextBox3SLabel38Label39Label40Label41TextBox4S Frame1_ClickFOpt1_1]{Opt2_1InputValuesBox1BOpr1_2"Opt2_2InputValuesBox2BOpt1_2^{ Opt1_1_Click# Opt2_1_Click Opt1_2_Clicku% Opt2_2_Click _B_var_Opt1_2SettingsRanges(SetupSettingsRanges@o579g l@S \4XLA$..\<$ ,LMSF(ormbSFrms/z pCE1742A5-1B20-11D2-ABBB-EAE4E3FB0242EU.TXWD#> b Object >G(0 r(6,(|P\VHBE\(EX(.E .`M -RefEdit>eEi/h,^-0EBB8479-2ADUA9AE98085949}#1U  Control#0~ `AQ2F91B992-5EB#9A8F0C35307`g((E+ @Fa&B"}4cSodule12*"MTdub1*" H1X", DT!"+bThisWorkbook.2U`T5iaWckDbokD{4" `Sheetg2bS etqVb < y$pek2ayp |I/'/'Jc( %OneXway 2On wawYOovTwojcTw 4}4#[o.p&rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#     q  Y  (  PMinBox1MaxBox1IncrBox1 GroupBox26MinBox2MaxBox2IncrBox2Label27Label28 rfƒ1%#rfƒ1%#rfƒ1%#rfƒ1%# 1  UserForm_ClickFJrfƒ1%# FIrfƒ1%#DF Worksheet @SolvTabGetCurrentValuesGetTwowayParametersClearOld RunSolverRestoreCheckEBƏYl|ClearEB  +S Improper values A1SelectE    $leanOption<D L0^TStri, MOptlonalaxVal #JJCheckIBgFrfƒ1%#CҋB ` +The input cell should contain a value, not  a formula.>r QwE  |LT $8K@DD<D L0^TStri, MOptlonalaxVal #JJCheckSingleCellIBF#idFeFfF SolverTable... SolvTab Table...E  ` $H<r a nge naTTLlrangaddres nam* FHrfƒ1%#FGrfƒ1%#DFWorkbookWorkbook_AddinInstallWorkbook_AddinUninstallF# DataE  .AL $BL4B<TlDelete嘈rfƒ1%#Иrfƒ1%#˘rfƒ1%#Ϙrfƒ1%#瘈rfƒ1%# '  RangeFFValueE    $8K@DD< 4T$l( 4#=h8+3q9* G?,2qL9*y* ҋB ` VBA332.DLL  + K)^E*\CC:\Program Files\Microsoft Office\Office\Library\Solver\SOLVER.XLArU! ~~~~~~~~~~~~~~~~~~~*~*~*~~~"*~~~*~~~*~~~~~~~*~*~*~~~~*~~~~*~6~~~~~~~~~~~~~~~6~6~~~~~~~7~~~~~7~~8~~~8~8~~~~~~~.8~~~~~~~~~~~~~~8~~~8~~~8~~8~~8~~~8~~~8~~9~~~9~:~~~:~~~;~~;~~~<~<~=~~=~~~~~~.=~~~~~0=~~~~5=~~~7=~~~7 a$d Qw   a  ` Y9ry9fAaYkca q a  Q a a a y )Qy  =Eb< Module1 ThisWorkbookSheet1TypeDlog OnewayDlog TwowayDlog SolverTable OnewayForm TwowayFormTypeFormF=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBA332.DLLVBA  PF 3C:\Program Files\Microsoft Office\Office\EXCEL8.OLBExcel !`0FC:\WINDOWS\SYSTEM\stdole2.tlbstdole 1yp`lYKC:\WINDOWS\SYSTEM\MSForms.TWDMSForms Y.E .`M ¹nKC:\WINDOWS\TEMP\VBE\MSForms.EXD YqlYKC:\WINDOWS\SYSTEM\RefEdit.TWDRefEdit )EFx|UƒSr Qw No convergence !The target cell didn't converge.  -This problem must have an unbounded solution. Not feasible &This problem has no feasible solution. Stopped !Solver stopped at user's request. Not linear Error value 'The conditions for Assume Linear Model  ,are not satisfied. (This could be a scaling  /problem--big numbers mixed with small numbers-- "or it could be real nonlinearity.) Too large 'The problem is too large for Solver to  handle. 'Solver encountered an error value in a  target or constraint cell. $Stop chosen when maximum time limit  was reached. Memory (There is not enough memory available to solve the problem. SOLVER.DLL problemBp+joD Another Excel instance is using  SOLVER.DLL. Try again later. Error #Error in model. Please verify that  $all cells and constraints are valid. .The first input is along the side, the second  input cell. k   9is along the top, the output cell is shown in this upper  corner.rfƒ1%# Empty cell .It doesn't make any sense to include an empty  cell in the output range.rfƒ1%# Enter a range in this box. Range requiredp+joD 4The input cell shouldn't be one of the output cells. Output includes input )The range where the table will be placed  is not empty. Are you sure Improper location cell /The location cell shouldn't be the same as the p+joD 2The location cell shouldn't be part of the output  range.8rfƒ1%#CheckHasFormulaE    $8K@DD<T.tblpCheckSingleCell CheckMinMaxZm]hƒ1%#E  ee'e $<in inT mghtle ny or cr oCheckValidRange 5The input cell shouldn't be part of the output range. !This range must be a single cell.[m]hƒ1%#E    $8K@DD<in inT mghtle ny or cr oCrfƒ1%#Lrfƒ1%#Drfƒ1%#Krfƒ1%#Erfƒ1%# j  CheckIsNumericZm]hƒ1%#6[m]hƒ1%#.[m]hƒ1%#E   $<MTlԑ^rfƒ1%#drfƒ1%#_rfƒ1%#crfƒ1%#`rfƒ1%# n   Improper range  ("E    $ld n be th<xKT,lxValDefineSolverMessages w  8 .The problem is too large for Solver to handle. {  Opr1_2Y bb 0000000-C0 $O<in inT mghtle ny or cr o\h  lrfƒ1%#ꘈrfƒ1%#zrfƒ1%#똈rfƒ1%#ᘈrfƒ1%#yrfƒ1%#혈rfƒ1%#Opt2_1 0Stop chosen when maximum time limit was reached. Remember that the input cell is  Remember that the first input  cell is  Remember that the second input Identical input cells   ^8h y`8h yMF 0The two input cells should not be the same cell. 4An input cell shouldn't be part of the output range. .The location cell shouldn't be the same as an rfƒ1%#rfƒ1%#B $. ~YH Ƀ)d8h yOpt1_1Y bb  @@ $<0@<@Tlٕ @<  DisplayHelp  HelpButton_Click \b8h yzv-=p%Label41Y bb  $<!2*@<@Tlq1 @< f8h y8h yg8h yL8h y8h y HelpButton8h yLabel39Y bb ` $< TH˦le@  rfƒ1%#rfƒ1%#   !rfƒ1%#rfƒ1%#rfƒ1%#Y bb   $8K@DD<in inT mghtle ny or cr o H )rfƒ1%#-rfƒ1%# 3Note: The Assume Linear Box was turned off; Solver Z ff   $8K@DD<T""l# 2"#0d s=#z6 4rfƒ1%#8rfƒ1%# thinks the model is not linear.  Zm]hƒ1%#Z ff .c $M<lbMinT mghtle ny or cr o A ([m]hƒ1%#Zm]hƒ1%#  #,[m]hƒ1%#7[m]hƒ1%#-[m]hƒ1%# c  X a label. Start \SolverTableHelp.htm  +X h Start SolverTableHelp.htm  0* $Start c:\myfiles\SolverTableHelp.htm \STHelp.htmi ioD Workbook_OpenWorkbook_BeforeClosep+joDZ ff  $<T,@<@TlIT @< oghƒ1%#$ghƒ1%#  )ghƒ1%# ghƒ1%#i ioDZ ff y $,<<@Tl<mh< 8C p+joDp+joD  -p+joDp+joDp+joD [  0.p+joDp+joDp+joDp+joDp+joDp+joD )  h.  1 The value of x is  Unknown error! ?This was supposed to open your default browser and display the  p+joD:p+joDZ ff  $<,@T;!{!lC)<@4 p+joDp+joDp+joDp+joDp+joDp+joD CountLinksLabel40& Hhelp file, but your system isn't being cooperative. OK, try this. Go to  8Windows Explorer (file manager) and double-click on the  %SolverTableHelp.htm file to see help. AddHyperlink"p+joD!p+joD HyperlinkFollow;p+joDp+joDZ ff |q $h `<T l  "C:\SolverTable\SolverTableHelp.htmF HyperlinksAddZ ff les\crosof $r.xl<T l l˟ Count There are  hyperlinks. The address is Cp+joDZ ff tĎ躋 $4V@L-D< T30l2 33 0 o|-  CheckLinks . The workbook  is o8/~AddToFavoritesB $.Z ff  @@ $<#;@<@Tl # @<  There is   hyperlink in this file. Its address is <>r Qw Y3y*YI a)9/^ 50v  )9GetRid  GLabel34 >r Qw Missing Solver Function$ EA Solver function cannot be found on your system. SolverTable should OffsetLabel37Z ff  $024EF<@,@T9#:\PlOMON T HARDLu   ;  ELabel22 >r QwLabel36Z ff  $<% <@Tlu < 7j@Մ{7j@Մ{:7j@Մ{77j@Մ{7j@Մ{97j@Մ{`>r QwZ ff xHO  $0<m@,@Tl (7j@Մ{7j@Մ{37j@Մ{K>r Qw Y  ?^>r QwZ ff ,- $<@,@T`l> 4 PJ  7j@Մ{17j@Մ{F>r Qw 1  CI>r Qw47j@Մ{Z ff e   $The dress <UR<@T %Fl ere isn th file.7<@,A@  The boolean values are   and D>r Qw27j@Մ{/7j@Մ{Label38Z ff   $&D\O<in inT mghtle ny or cr oyU =~##  e>r Qw>r Qwf>r Qw?>r Qw>r Qw>r QwLabel35\ nn $<TptlQtH.D  ARows>r Qw_>r QwA>r Qw>r Qw>r QwFrame2% Fstill work fine, but the values in your model won't be reset to their original values.L>r Qwg>r Qwn>r Qwh>r Qwm>r Qwl>r Qw Y  .TextBox1 OptionButton1 OptionButton2Label23  JOpt2Opt1\ nn $8I<LI, tTs re lrs, yewvale.O!  |>r Qw>r Qw}>r Qw>r Qw>r QwInputValuesBoxColumns^ xx)IA $@TGD<hIT1"!""2l""2Tr Qw;>r Qw  +x P/ ,>r Qwa 0000000-C0 $<P tTttngslf ourteewlus i The%eLT%e\%e%e >r Qw>r Qw>r Qw>r Qw>r Qw>r Qw   RFrame1 a  0 $<QO StTOwne Tyl7ehoed3I >r Qw,>r Qw3>r Qw->r Qw2>r Qw.>r Qw  pV Opt1_1_Click Opt2_1_Click Opt1_2_Click Opt2_2_Click   HZAa 0000000-C0 $eROHъ<x, tTs re lrs, yewluifyou<%e%e\d%el%e%e 6>r Qw=>r Qw7>r Qw<>r QwOpt1_2;>r Qwa  $<dOTl H( A>r Qw@>r Qwm>r QwSetupSettingsRangesa )IA $@EGD<ee, tTs re lrs, yewluifyou`t >r Qw Text @>r Qw 8 1 H QX Qh 1 x I1  Y1  y 14 qEBoxFlagMsg1Msg2PosNonnegZeroOne ZeroHundredGE1IBox " )'1  a.1  /1 MinBoxMaxBoxRBox SingleCell k1  o1  qr1 ( 8 1 H iQX 9{1 h s1 x )1  o1  11  W1  1  11  1 Cancel 11  1  Q1  1 ( Y1 8 1 H 1 X 91 h y1 x 1  1  Q1  1  1  1 (H  @}" R KQi01& n``\%V1U\%V1Uf!o%'CompObjp    4y !"#,%&'()*+-./01235t789:;D=>?@ABC6EFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuv}{|~TypeForm!`k V1U\%V1UfKoPi01 n`` V1U@4V1Usettings are shown. Of course, you can enter new values if you like.Jr5Tahoma@$@InputBox`/( @OutputBox@ $ @LocBox@ !( 74OKButton, ;8CancelButton( 2<Label6@>W(2@Label16(2DLabel18!(2L Label20foCompObjpCompObj a!(2 Label21$(2 Label22> Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} OnewayForm Caption = "Parameters for oneway table" ClientHeight = 5925 ClientLeft = 45 ClientTop = 330 ClientWidth = 5745 StartUpPositioCompObj$) aVBFrame 7TwowayForm, ,V1U pV1Uf_n = 1 'CenterOwner TypeInfoVer = 61 End (H  B@}%B",R KQDBTahoma8KEFҋB `EF( @InputBox1& TH x,$A$15Tahoma@ TH  ,$A$25Tahoma@(TH  ,$B$3:$D$35Tahoma@$TH ,$A$11@5DBTahoma( #GroupBox7, n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q4F F0@Oneway table5Tahoma@4F F1@Twoway table5Tahoma@(H  } \( TOnewayOpt( TTwow}ayOpt s(OK@<|uTahoma@(Cancel@<{uTahoma@(You can create a oneway or twoway table, depending on whether you want to test the sensitivity of outputs to one or two inputs.'5Tahoma@(Help<{uTahoma@(74OKButton , wu , !"#$%&'()*+-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[]^_ancdefghijklm\opqrstvwxyz|~zCompObj?pCompObj6`aVBFrameb8PROJECTwm9g   U !"#$%&'(*,-./012345789:;<=>@BCDEFGHIJKMNOPQRSTVWXYZ[\]^_acdefhiklmnopqrstuxyz|}~ ClientWidth = 4950 StartUpPosition = 1 'CenterOwner TypeInfoVer = 23 End $  =}'(R KQDBTahoma8KEFҋB `EF ( #GroupBox7@#  n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q@H(,1@5Tahoma@@H(,6@5Tahoma@@H(,2@5Tahoma@ (Minimum value:h 5Tahoma@ (Maximum value:h 5Tahoma@( Increment:luh F5Tahoma@HF,0@Base input values on following:5Tahoma@TF+mb0@Use the values below (separate with commas)5Tahoma@ ( Input values:5Tahoma@H,5Tahoma@PH   }a$Values of input to use for tableR KQDBTahoma $<MinBox@ $<MaxBox@ $<IncrBox (2@Label8@(2@Label10(2<Label11 hOpt1#u tOpt2#h (2@ Label235,4InputValuesBoxM+  TH y,$A$15Tahoma@ TH ',$D$35Tahoma@ TH h ,$A$65Tahoma@(OK@<{uTahoma@(Cancel@<|uTahoma@( Input ceTahoma@(OK@<{uTahoma@(Cancel@<uTahoma@( Input1 cell:5Tahoma@ (Output cell(s):5Tahoma@$(Location of table:! 5Tahoma@0( (upper left cell of (top) table)5Tahoma@( Input2 cell:5Tahoma@`(PNote: Input1 will be put along the left side of the table, input2 along the top.)5Tahoma@(Note: Be careful. If you select more than one output cell, there will be a table for each, stacked on top of one another. They will overwrite anything in their way! You might want to delete any old tables before creating any new ones.M.5Tahoma@(If you already ran a twoway SolverTable on this sheet, the old settings are shown. Of course, you can enter new values if you like.)bedded ObjectForms.Frame.19q@H(,1@5Tahoma@@H(,6@5Tahoma@@H(,2@5Tahoma@ (Minimum value:h 5Tahoma@ (Maximum value:h 5Tahoma@( Increment:luh F5Tahoma@HF,0@Base input values on following:o+1i44/ n`` ,V1U ,V1Uf6=o.0+8CancelButtonB9(2<Label6@XN(2@ Label16X (2D Label18X#(2P UpperLab#(2< Label25"N(2 Label31Xi(2 Label32X{&(2Label34X=$,#Frame1@f $8#Frame2@!  s Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} TwowayForm Caption = "Parameters for twoway table" ClientHeight = 6405 ClientLeft = 45 ClientTop = 330 ClientWidth = 9600 StartUpPosition = 1 'CenterOwner TypeInfoVer = 169 End Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1TypeFormTypeFormOnewayFormOnewayFormTwowayFormTwowayFormID="{8B5D3C8D-4CE9-11D2-8DC2-CE39616DB048}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=TypeForm BaseClass=OnewayForm BaseClass=TwowayForm HelpFile="" Name="SolverTable" HelpContextID="0" CMG="C1C3C3C1C7C1C7C1C7C1C7" DPB="82808043484C484C248933DD0F7421E355" GC="434141820383038303" PROJECTjPROJECTlkvSummaryInformation(;wDocumentSummaryInformation8{ [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 536, 360, ThisWorkbook=22, 22, 508, 342, Sheet1=0, 0, 0, 0, C TypeForm=0, 0, 486, 320, , 0, 0, 486, 320, OnewayForm=132, 132, 618, 452, , 22, 22, 508, 342, Z TwowayForm=154, 154, 640, 474, , 44, 44, 530, 364, EFOh+'085Tahoma@ n``Microsoft Forms 2.0 FrameEmbedded ObjectForms.Frame.19q@H(,1@5Tahoma@@H(,6@5Tahoma@@H(,2@5Tahoma@ (Minimum value:vh 5Tahoma@ (Maximum value:vh 5Tahoma@( Increment:luh F5Tahoma@HF,0@Base input values on following:5Tahoma@TF+mb0@Use the values below (separate with commas)5Tahoma@ ( Input values:5Tahoma@H,q5Tahoma@TH  6"}cValues of input 1 to use for tableR KQ@Tahoma @Xp Chris AlbrightChris AlbrightMicrosoft Excel@nbd՜.+,D՜.+, PXt | Indiana Universityh1 Sheet1  Worksheets 6>Root Entry F md`d`aWorkbook<_VBA_PROJECT_CUR":2U1UV1UVBA8_:U1U`k V1U$-<MinBox1 $.<MaxBox1 $/<IncrBox1 (02@Label35(12@Label36(22<Label37$3hOpt1_1@#u$4tOpt2_1@#h (52@ Label235,64InputValuesBox1+  { n``Microsoft Forms 2.0 FrameEm5Tahoma@TF+mb0@Use the values below (separate with commas)5Tahoma@ ( Input values:5Tahoma@H,q5Tahoma@TH  B" }cValues of input 2 to use for tableR KQ@Tahoma $9<MinBox2 $:<MaxBox2 $;<IncrBox2 (<2@Label38(=2@Label39(>2<Label40$?hOpt1_2@#u$@tOpt2_2@#h (A2@ Label415,B4InputValuesBox2+  {( @InputBox2=)&( HOutputBox3 $DLocBox@3 #(74OKButtonB9, ; _PID_GUIDAN{8B5D3C8E-4CE9-11D2-8DC2-CE39616DB048} FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qCompObjf