?>  Xy  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F?+0Workbook_VBA_PROJECT_CUR"b$?@9f$?VBA b$?e$?  !"#$%&')*+,-/0123456789:;<=>?@ABCDEFGIJKLMNOPQRSTUVWYZ[\]^_`bcdefghijklmnoprstuvwxyz{|}~8 ``i??3f3333f3ffff333ff333f33f33BBB\`aScenario_dialogh Save_dialogVoOptions_dialog Add_dialog Show_dialog" Finish_dialogS Solver_dialogSolver1Solver2Solver3Solver4^ VBA_FunctionsExcel4Functions Language  __Command`d,$@Tools Sol&ver...Stub---4Find feasible or optimal solution to worksheet model oftip.hlp!858 __DemandLoadadd_for:W! add_formula:Xadd_ref:Vaddarg1:addarg2:addarg3:Addfunc: Addin_Bar:# Addin_Command: Adjustablesanscount assumelinear assumenonnegBarOpen:CellTxt change_for:_$change_formula:` change_ref:^Cleanup<! CommandName: Constraint_Add Constraint_help Constraint_OK Constraint_sign Cont_button convergencedel_for:g! del_formula:hdel_ref:fDelfunc: derivatives dShowref:! Enginecount<" Engineresult< estimates Finish_cancel Finish_help   Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&WindowOM  SOLVER.ADDcell_ref  SOLVER.CHANGEcell_r  SOLVER.DELETEcell_r  SOLVER.FINISHkeep_ SOLVER.FINISH?keep_  SOLVER.GETtype_ SOLVER.LOA ) SOLVER.OKset_cell,max_min ) SOLVER.OK?set_cell,max_min }SOLVER.OPTIONSmaxtime,iterations,precision,assumelinear,stepthru,estim SOLVER SOLVER.SAV  SOLVER.SOLVEuser\p Jim Orlinool of Management Ba=  ThisWorkbook=J-&< X@"1Arial1Arial1Arial1Arial1Arial1Helv1Helv1Helv1Arial1Arial1 Helv1Tahoma"$"#,##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\ "DM";\-#,##0\ "DM"##,##0\ "DM";[Red]\-#,##0\ "DM"$#,##0.00\ "DM";\-#,##0.00\ "DM")$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM">9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_->9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-FA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-FA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-                + )   , *             0       0UU            8   8  8U  8U  0U  0UP  0U  0U@ @   8U@   8UP@  0U@  0UP@   8U@ @   (UP@   X    0U   0U   0UP   0UU     8   8   8   8P   8   8P   8P    8P   8P   8PP  Comma_SOLVERComma_SOLVER (2)Currency_SOLVERCurrency_SOLVER (2) Normal_SOLVERNormal_SOLVER (2)Finish_okGetDef:  inttolerance iterations keep_finalload_arg:P Load_helploadarg1:Loadfunc: Main_help Max_button_push max_min_valmaxtime MenuUpdate:y Min_button_push msg_branch: msg_incumb:! msg_setcell: msg_setup: msg_trial:Namecell:  Obj" ok?_changing:6" ok?_set_cell:5! ok_changing:.! ok_set_cell:-okarg1:okarg2:okarg3:okarg4:Okfunc:optarg1:optarg10:optarg11:optarg12:optarg2:optarg3:optarg4:optarg5:optarg6:optarg7:optarg8:optarg9: Option_cancel Option_help Option_OK! Optionsfunc:precison Push_add Push_change Push_close Push_delete Push_guess Push_load Push_options Push_reset Push_save Push_scenario relation reportarray Resetfunc:!  RestoreCall<   RestoreDLL:save_arg:Lsavearg1:Savefunc: SaveLoad"  SaveScen_Dlg:#scaling) Scenario_dialog;  Scenario_help Scenario_OK!  ScenDlgName: search Sheet sheet_nameShow: show_case% Show_dialog; Show_Dlg: show_ref ShowEcho: ShowForm:! showmsg; Showtext:SolvAdd SolvChange SolvDelete Solve_problem  SolveCall: SolveDLL: Solvefunc:T !SOLVER.ADD:SAdds constraint to a Solver modelmacrofun.hlp!3425d .SOLVER.CHANGE:[Changes existing constraints on a Solver modelmacrofun.hlp!3426f 0SOLVER.DELETE:cDeletes existing constraints from a Solver modelmacrofun.hlp!3427 WSOLVER.FINISH:kKeeps or discards final results, and creates reports after a successful Solver solutionmacrofun.hlp!3428t=SOLVER.FINISH?:oDisplays the Solver results dialog box; use after SolverSolvemacrofun.hlp!3428[ (SOLVER.GET:sReturns information about a Solver modelmacrofun.hlp!3429u ASOLVER.LOAD:OLoads a Solver model definition that is stored in worksheet cellsmacrofun.hlp!3430H SOLVER.OK:)Defines a Solver modelmacrofun.hlp!3431 ]SOLVER.OK?:1Displays the Solver dialog box; equivalent to choosing the Solver command from the Tools menumacrofun.hlp!3431Z#SOLVER.OPTIONS:9Sets calculation options for Solvermacrofun.hlp!3432b -SOLVER.RESET:wResets Solver options to their default valuesmacrofun.hlp!3433f 2SOLVER.SAVE:KSaves a Solver model definition in worksheet cellsmacrofun.hlp!3434J SOLVER.SOLVE:GStarts a solution runmacrofun.hlp!3435 solver_bin:$Solver_err_msg:$solver_grg_eng:) solver_int:# solver_lp_eng:*# solver_ls_eng:," Solver_msg_1:# Solver_msg_10:$Solver_msg_100:$Solver_msg_101:$Solver_msg_102:$Solver_msg_103:$Solver_msg_104:$Solver_msg_105:$Solver_msg_106:$Solver_msg_107:$Solver_msg_108:$Solver_msg_109:$solver_msg_10a:# Solver_msg_11:$Solver_msg_110:$Solver_msg_111:$Solver_msg_112:$Solver_msg_113:$Solver_msg_114:$Solver_msg_115:$Solver_msg_116:$Solver_msg_117:$Solver_msg_118:$Solver_msg_119:# Solver_msg_12:$Solver_msg_120:$Solver_msg_121:$Solver_msg_122:$Solver_msg_123:$Solver_msg_124:$Solver_msg_125:$Solver_msg_126:$Solver_msg_127:$Solver_msg_128:$Solver_msg_129:# Solver_msg_13:$Solver_msg_130:$Solver_msg_131:$$Solver_msg_132:%# Solver_msg_14:# Solver_msg_15:$solver_msg_150:$solver_msg_151:# Solver_msg_16:# Solver_msg_17:# Solver_msg_18:# Solver_msg_19:# solver_msg_1a:# solver_msg_1b:# solver_msg_1c:" Solver_msg_2:# Solver_msg_20:# Solver_msg_21:# Solver_msg_22:# Solver_msg_23:# Solver_msg_24: $solver_msg_24a:"$solver_msg_24b:## Solver_msg_25:!$solver_msg_25a:&$solver_msg_25b:'# Solver_msg_26:.# Solver_msg_27:/# Solver_msg_28:0# Solver_msg_29:2$Solver_msg_29a:3" Solver_msg_3:# Solver_msg_30:4# Solver_msg_31:5# Solver_msg_32:6# Solver_msg_33:7# Solver_msg_34:8# Solver_msg_35:9# Solver_msg_36::# Solver_msg_37:;# Solver_msg_38:<# Solver_msg_39:=# solver_msg_3a:" Solver_msg_4:# Solver_msg_40:># Solver_msg_41:?# Solver_msg_42:@# Solver_msg_43:A# Solver_msg_44:B# Solver_msg_45:E# Solver_msg_46:F$solver_msg_46a:H$solver_msg_46b:I# Solver_msg_47:K# Solver_msg_48:M# Solver_msg_49:N" Solver_msg_5: # Solver_msg_50:O# Solver_msg_51:P# Solver_msg_52:Q# Solver_msg_53:S# Solver_msg_54:T# Solver_msg_55:U# Solver_msg_56:V# Solver_msg_57:W# Solver_msg_58:X# Solver_msg_59:Y" Solver_msg_6: # Solver_msg_60:Z# Solver_msg_61:[# Solver_msg_62:]# Solver_msg_63:^# Solver_msg_64:_# Solver_msg_65:`# Solver_msg_66:a# Solver_msg_67:c# Solver_msg_68:d# Solver_msg_69:e# solver_msg_6b: # solver_msg_6c: " Solver_msg_7:# Solver_msg_70:f# Solver_msg_71:g# Solver_msg_72:h# Solver_msg_73:i# Solver_msg_74:j# Solver_msg_75:k# Solver_msg_76:l# Solver_msg_77:n# Solver_msg_78:o# Solver_msg_79:p# solver_msg_7a: " Solver_msg_8:# Solver_msg_80:r# Solver_msg_81:s# Solver_msg_82:t# Solver_msg_83:u# Solver_msg_84:v# Solver_msg_85:w# Solver_msg_86:x# Solver_msg_87:y# Solver_msg_88:z# Solver_msg_89:{" Solver_msg_9:# Solver_msg_90:|# Solver_msg_91:}# Solver_msg_92:~# Solver_msg_93:# Solver_msg_94:# Solver_msg_95:# Solver_msg_96:# Solver_msg_97:# Solver_msg_98:# Solver_msg_99:$solver_msg_bin:$solver_msg_int:# solver_msg_se:D solver_opt# solver_qp_eng:+" solver_table:  solver_tbl: solver_tbl:$ SolverMenu;# SolverMenubar:$SolverMenuitem: SolvFinishSolvFinishDialogSolvGetSolvLoadSolvOk SolvOkDialog SolvOptions SolvResetSolvSave SolvSolvestepthru Stop_button Stop_help TheCall:TheCall: tmp_Echo type_numunregi: user_finish Value_button_push value_ofH b'  3  @@  Start of solvercallitemxywidthheighttext init/resultxlmain8.hlp!1836Show Trial Solution>Solver paused, current solution values displayed on worksheet.ContinueS&top&Help&Save Scenario...xlmain8.hlp!1835 Save ScenarioScenario Name:OKCancelQRed box is solver_tbl. Sensitivity information gets stored starting at that point$The following cell contains dShowref'General validation and warning messagesFActive document is not a worksheet, is protected or is in shared mode.Solver32.dll is unavailable -- you will be able to define and edit Solver models, but not actually solve them. To fix this, please use Excel setup to reinstall Solver.*Cannot do this command in Group Edit mode./Cannot do this command in an embedded workbook.5Find feasible or optimal solution to worksheet model.1Cannot guess Adjustable Cells without a Set Cell.-Adjustable Cells must be on the active sheet.ESet Cell must have precedents containing numbers on the active sheet.&Reset previous Solver cell selections?'Load Model: Invalid Constraint Formula. Load Model: Invalid Target Cell.$Load Model: Invalid Adjustable Cell.+Set Target Cell contents must be a formula.:Set Target Cell must be a single cell on the active sheet.#Max Time must be a positive number.%Iterations must be a positive number.*Precision must be a small positive number.+Convergence must be a small postive number.5Integer Tolerance must be a number between 0 and 100.)Integer Cutoff must be blank or a number.6Coefficient tolerance must be a small positive number.3Solution tolerance must be a small positive number.0Pivot tolerance must be a small positive number.7Reduced Cost tolerance must be a small positive number.-Reset all Solver options and cell selections?Problem to solve not specified.Too many adjustable cells.6Cell Reference box is empty or contents are not valid.OConstraint must be a number, simple reference, or formula with a numeric value.9Unequal number of cells in Cell Reference and Constraint.EInteger constraint Cell Reference must include only Adjustable Cells.DBinary constraint Cell Reference must include only Adjustable Cells.PToo many adjustable cells. A scenario can have no more than 32 adjustable cells.Scenario Name cannot be empty.Scenario Name must be unique.)Reference not large enough to hold model;cells are required.No constraint to change.No constraint to delete.Different engine listingsStandard GRG NonlinearStandard Simplex LPStandard LP/QuadraticLarge-Scale LP Solver9Names of different reports as listed in the finish dialogAnswer SensitivityLimits$Different messages for finish dialogRSolver found a solution. All constraints and optimality conditions are satisfied.cSolver found a solution within tolerance. All constraints and optimality conditions are satisfied.MSolver has converged to the current solution. All constraints are satisfied.KSolver cannot improve the current solution. All constraints are satisfied.9Stop chosen when the maximum iteration limit was reached.$The Set Cell values do not converge.*Solver could not find a feasible solution.!Solver stopped at user's request.8The conditions for Assume LP/QP Model are not satisfied.9The conditions for Assume Linear Model are not satisfied..The problem is too large for Solver to handle.ASolver encountered an error value in a target or constraint cell.4Stop chosen when the maximum time limit was reached.:There is not enough memory available to solve the problem.=Another Excel instance is using SOLVER.DLL. Try again later.HError in model. Please verify that all cells and constraints are valid./An error occurred. Please contact Tech Support.$Dialog titles for Load or Save ModelCannot save model in this area. Load Model Save Model+Dialog titles for Add and Change constraintAdd ConstraintChange ConstraintReport Messages=Internal Error: Can't find report information on macro sheet.Answer Report MessagesForming Answer Report...Microsoft Excel Answer Report Worksheet:Report Created:Target Cell SectionMaxMinValue Of Target CellNONECellNameOriginal Value Final ValueAdjustable Cells SectionAdjustable CellsConstraints Section Constraints Cell ValueFormulaStatusSlack Not BindingBinding$Reports terminated at user's requestSensitivity Report Messages^Sensitivity Report and Limits Report are not meaningful for problems with integer constraints.Forming Sensitivity Report...Sensitivity ReportFinalValueReducedCost Objective Coefficient AllowableIncreaseDecreaseGradientShadowPrice Constraint R.H. SideLagrange MultiplierLimits Report MessagesForming Limits Report... Limits ReportTargetAdjustable Section AdjustableLowerLimitResultUpperStatus Bar MessagesSetting Up Problem...Trial Solution:Branch: Incumbent: Set Cell:Interruption Messages4The maximum time limit was reached; continue anyway?9The maximum iteration limit was reached; continue anyway?General Error MessageQSolver: An unexpected internal error occurred, or available memory was exhausted.;Next 5 column entrees determine placing of Solver on menu. Sol&ver...Main4Find feasible or optimal solution to worksheet model oftip.hlp!858No active document available.Constraint is too long.integerbinaryintbinfNext entries determine the code that is recorded. Should be consistent with localised function names. SolverAdd SolverDelete SolverLoadSolverOk SolverOptions SolverReset SolverSave SolverSolveCellRefRelation FormulaTextLoadAreaSetCell MaxMinValValueOfByChangeMaxTime Iterations Precision AssumeLinearStepThru Estimates Derivatives SearchOption IntToleranceScaling Convergence AssumeNonNegSaveArea,Next item is the menu name: Tools in EnglishToolsIE EW@Fh]G _sI6lJrkL.RSN 4AO P R TTUtlVVLkxW;RW*XXqYlZ/ [[,\R\M]~w?RT04h   DIr0  6+T6?w4[w S0t0=wh?wh46? +w46+6?wvalue_oftton_push#4?\Lw@#t ?0H#p,wH#nw4h  6 RT06 {wRT0x X8Pw\w)w@P|0E`E~02T0pEEu0!T0|0E(!0@EZ0@=Z04F0@F` 0=EStart of solvercallitemxywidthheighttext init/resultxlmain8.hlp!1836Show Tria   b  dMbP?_*+%i&A Page &P"P??x U<$(  r  0@A@ 5]@ E  <Save Scenario<   s FA@Scenario_name 3 ]& `x E    D?OK_button]*@ E G X#o $ <OK< ff  c $,?&], E $<Cancel< ll  s *?(3], E Gx9n $H<Help< rr  0p@A@) ]@pP E <Scenario Name: < >"@   yi  dMbP?_*+%i&A Page &P"P??U2 (  r  0P@A@ 1]@PE  < Load Model< rr  0@A@# ]@`E <Select Model Area: < ~~  s <A@The_area 0 ]& `E    D?OK_button]*E8G P#j $ <OK< ff  c $$?$]$E $<Cancel< ll  s *?&0],0ELGp9. $H<Help< >"@   #p  dMbP?_*+%i&A Page &P"P??9U0 & (   r  0?@A@I,]@?(E <Solver Options< rr  0<@A@# ] @<E T < Max Time:< ~~  s <A@Max_time&+ ]& `xE <100< rr  0@A@ $] @8E I < Iterations:< ~~  s <TA@Max_iter& -]& `TE <100< rr  0@A@$] @E P < Precision:<   s >A@Precision&3]& `H E < 0.000001< b#rr  0X@A@%] @X!E e < Tolerance:<   s >A@Tolerance&2]& `!E <5<  rr & 0 @A@&]&@ p"E v <Convergence: <  % s BpA@Convergence&3]& %`p#E <0.001< '  P?@A@Assume0I]6 ?#E MM "<Assume Linear Model<  $ R(@A@non_neg0"%]6 $($%E gg "<Assume Non-Negative<   T@A@auto_scl1II]6 l&E UU "<Use Automatic Scaling<   V?@A@Show_iter1H"%]6 ?'E RR "<Show Iteration Results< xx  6@A @#(+]$@@(E  < Estimates<   R@A@Tangent$&'%]H )E a ?a "<Tangent<   V@A@Quadratic'&*%]H *E Q |Q " < Quadratic< xx  6pA @)#7+]$@p4,E  < Derivatives<   R?@A@Forward*$5'%]H ?,E F F "<Forward<   R@@A@Central*'5*%]H @$.E C C "<Central< xx  6A @8#F+]$@l/E <Search<   P@A@Newton9$E'%]H 0E N DN "<Newton<   Vp@A@Conjugate9'E*%]H p\1E o ?o " < Conjugate<   D ?OK_button8G ]* 2EdG #U $ <OK< ll  s *?8 G]*L3ExG X#S $<Cancel< ll  s *d?8G]*d3EG #] $L <Load Model...< ll  s *#?8G]*#4EG #` $S <Save Model...< ll  s *#?8G]* #D5EG \##T $H<Help< rr  0c@A@,5 ]@c5E <seconds< rr # 0|c@A@26]#@|c6E <% <   >"@     dMbP?_*+%i&A Page &P"P??U @ (  r  0\?@A@'["]@\?L;E <Add Constraint< rr  0?@A@(:]@?;E R<Cell Reference:< tt  s 2 ?A@lhs(<]& ` ?=intbinrr  0P?@A@EIIUI]@P?=E C < Constraint:< tt   s 2?A@rhsEYn]& `?>E    DP??Ok_button(2!]*P?"@     dMbP?_*+%i&A Page &P"P??#ULP4(  r  0?@A@ A]@?CE <Show Trial Solution<   P\?@A@Show_message3 ]@\?@DE ><?Solver paused, current solution values displayed on worksheet.< >||  :?? Cont5? ]*?DEG ?# $ < Continue< ||  :?? Stop5 ?]*?EE,G T?#B $ t<Stop< ll  s *`??5?]*`?8FE@G ?#C $H<Help< ll  s * ??!]* ?FETG ?#a $S<Save Scenario...< >"@     dMbP?_*+%i&A Page &P"P??#aU` (  r  0?@A@ I]@?KE <Solver Results<   RL?@A@Final_message7 ]@L?@LE Q<RSolver found a solution. All constraints and optimality conditions are satisfied< Q  ^?@A@Keep_solution&I]H ?LE K ?K "<Keep Solver Solution<   `,?@A@Restore_values'I]H ,?0NE O ?O "<Restore Original Values< rr   0|?@A@7 B ] @|?xOE R<Reports<    F@AReports7 GI]_  PE Answer SensitivityLimitsll  s *??]*?PEhG p?#( $ <OK< ll  s *|??']*|?pQE|G ?#& $<Cancel< xx  6?A @)]$@?RE  ll   s *??):]* ?REG (?#a $S<Save Scenario...< T?ll   s *4??<G]* 4?hSEG ?#' $H<Help< >"@     dMbP?_*+%i&A Page &P"P??#'U p (  r  0?@A@N)]@? XE <Solver Parameters< rr  0h?@A@  ]@h?XE e<Set Target Cell:<   P?A@Optimum_Cell * ]6 `?pYEG ?#=     ^?@A@Max_button !%]X ?ZEG M ? @?#2M  "<Max<    ^D?@A@Min_button! (%]X D?`[EG n ? ?#6n  "<Min<    b?@A@Value_button) 5%]X ?\EG V @? ?#JV  " < Value of:< ~~  s <8?A@dValueOf5 ?]& `8?]E <0< xx  6?A @B(]$@?^EB <By Changing Cells:<   X$?A@"Adjustable_Cells4]6 `$?@_EG ?#   ll  s *??6@]*?_EG `?#\ $G<Guess< xx  60?A @B(]$@0?`Eu <Subject to the Constraints:<   V@A Constraint_list4&I]<8aE ll  s * ?6@]* aE0G ?#X $A<Add< ll  s *?6@!]*bEDG l#Y $C<Change< ll  s *x?6"@%]*x0cEXG #[ $D<Delete< ll  s *$?C M ]*$cElG # $ S<Solve< ll  s * ?CM], dEGp9Z $ <Close< ll  s *?CM]*(eEG H#^ $O<Options< ll  s *T?C M#]*TeEG #_ $R < Reset All< ll  s *?C$M']*xfEG #1 $H<Help< rr  0`@A@ ]@` gE  < Equal To:< >"@  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P @  @xBtra  dMbP?_*+%&f Page &pMHP LaserJet III  dLg_);N}w;}d)A"d??U} I} $}  } } } } m} } I} Ix  T0          0 :0 E E E   E0 0EEE0E}E 0E|0ET & """ 'BT"""" "" "( CB    ! ! ! ! (BT 8 99:P{@:S@ : ~ ;@ "( CDAB$<@$@$@%s@%@@ % = %(@#D Al<?$t@$@%W@% % = (A<@$t@$<@%W@% % = ) #DB7<8@$t@$J@%W@% % = >@? @?J@@b@@ @A ' * CellTxtBQ  """"% ( SheetBQ 8 99 :s@:Q@ :~ ;@1 ( CA B7B <@$$@$@ %% % =$ ( CCrB <@$$@$3@%q@ %%=< )&C)A # #)"B7 <?$$@$E@%V@ % % =<@$[@$E@%V@% %=)+ show_caseBQ>8@?i@?E@@V@@ @ A.BT$$$%%%%,B`#, C"B=,'@=C"(Cu)#zB`,&,@CzA&B7,A/,#|#{CuBAl 2,B+,tmp_Echo(ABX 0,CFA& BWB,@#vA0,CFA& BWB0,CwA& B7B1,Cw  B7B1, Cw  B7BD l2BpwkqXGwwZNq8!'A*A94"4>? T0!"#$%&' (0):*E+E,E-.E/ 0E01EE23045E67} 8E09:E;|0<E=>T?! ,! #pAl +!,"tmp_Echo(ABX!0",#CFA& BWB"#,$#mA#0$,%CFA& BWB$2%,&CkA& #yA5B%&&,'#o9pB&'-)#yA5'(()4*set_cellBQ+*5+ max_min_valBQ(+5,value_ofBQ+,5- by_changingBQ8-5p D."set_cellBkB=Bx$A$8;.5| D/% by_changingBkB=Bx $A$1:$A$7;/61%#;#A#3@#K#@"B7(142set_cellBQ+253 max_min_valBQ(354value_ofBQ+455 by_changingBQ8556"set_cellBkB=Bx;657% by_changingBkB=Bx?769)#<#?#3@#K@#>"B7'94:maxtimeBQ*:5; iterationsBQ);5< precisionBQ,<5= assumelinearBQ(=5>stepthruBQ)>5? estimatesBQ+?5@ derivativesBQDwl/9>,>@4, ,/,/GO?,/,/<?C+.-0,-@T0ABCDE F0GHI: JE0KELEM NE0OPEQEE!R0S0TUEVW}XEY ZE0[|0\E]^T_&@5AsearchBQ,A5B inttoleranceBQ'B5CscalingBQ+C5D convergenceBQ,D5E assumenonnegBQsE6G]#=@#4@#+@#W@##A#%#!#q#*@#l##" B7+G4H user_finishBQ(H5Ishow_refBQ-I6K#@#I#x"B7)K4L save_areaBQ9L5 DM# save_areaBkB=Bx "$H$5:$H$60"(M6O#?#g"B7)O4P load_areaBQ9P5 DQ# load_areaBkB=Bx#N/A(Q6S#:#-"B7(S4Tcell_refBQ(T5UrelationBQ/U5VformulaBQ8V5 DW"cell_refBkB=Bx#N/A:W5 DX$formulaBk"Bx=Bx12.45.X5 DYCB=Bx12.456Y6[ #}##b#@"B7([4\cell_refBQ(\5]relationBQ/]5^formulaBQ8^5 D_"cell_refBkB=Bx#N/A:_5 D`$formulaBk"Bx=Bx12.45Dal*0+/0w/,1-P,-H,,,3GJ>:,,3G`T0a b0cdefghi: jE0kElEm nE0opEqEE!r0s0tuE v0w}0xE0yzE{|0|E}~T.`5 DaCB=Bx12.452a6c#~##b#"B7(c4dcell_refBQ(d5erelationBQ/e5fformulaBQ8f5 Dg"cell_refBkB=Bx#N/A:g5 Dh$formulaBk"Bx=Bx12.45.h5 DiCB=Bx12.45:i6k$##@#b@#"B7*k4l keep_finalBQ,l5m report_array@BQ-m6o#7#,#c"B7*o4p keep_finalBQ,p5q report_array@BQ-q6s#8#,#c"B7(s4ttype_numBQ*t5u sheet_nameBQ-u6w#9#G#s"B7#w7y #>"B7'y0*z C5C6B%z,{C5AA&B+{,|@ C5C6B0|,(@}@ #5#4#5B},~A1~,(@@ #5#4---B,ADl>6,,3GJ>>.01.01,.1'+)/45T0 0  :0EEE{(e $BBABsM :SOLVER \SOLVER32@B@SolveIEB(m $BBABsM :SOLVER \SOLVER32@B@ SolveRestoreAIRB1B7+CA.CfA/B7 " """" uT0vwuvw Z( >@????m|0|E}~TLHT070<!0LHTt0y0?LHT0}0t}w0}h3 qq      @  ,k{E g  dMbP?_*+%&A Page &P"PD??U} #DT0  T0   TT0TT0}|0ET #           ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5D@l T0!"#$%&'()*T0+,-T.T/0T01T2304567}89:;|0<E=>T? 6 !7 "8 #9 $: %; &< '= (#> )? *@ +A ,B -#C .D /E 0F 1#G 2H 3I 4J 5K 6L 7M 8N 9O :P ;Q <R =S >T ?UD@l@T0ABCDEFGHIJT0KLMTNTO0TPQTRS0TUVW}XYZ[|0\E]^T_ @V AW BX C#Y D3Z E[ F\ G#] H^ I_ J#` Ka L#b Mc Nd Oe Pf Qg R#h Si Tj Uk Vl Wm Xn Yo Zp [q \#r ]s ^n _oD@l`T0abcdefghijT0klmTnTo0TpqTrs0tuvw}xyz{|0|E}~T `p aq b#t cu dn eo fv gw hx iy jz k{ l| m#} n~ o p q#r rs sn to u v w x y z { | } ~ D@lT0T0TT0TT0}|0ET  #t u n o             m #   #h n  o  n #  o  D@lT0T0TT0TT0}|0ET        m* #      #    #  #           #  Drl BT0T0TT0TT0}|0E                            # >0>@ Solver2 x9__SRP_3__SRP_2 Solver34nM ME  " (8@HP %X&h " %" " 8 ( "0 48px "   "  " $BW %`>qp   "   -0".P <qx )   )  .Y( <qX )  2o 0j""@hVp ` 8@ HPX`<qhVx "  8HP "X $`  "    "  0 "8 @ `x " 0 B]C( D@ >NX 4 Bx  4 8 @ >qH   "   "      0 P X  % |      H Q  @j (      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~xhh (04<@Ldlpx|Vk@2NNl@> L*LLLLL"   0@4B8?:D<F@?DHFJHL J 8 L b `H 2k && 14<\d^f`hd l(!` xk! 14n"` h4oh "I   14phrj@ltpvt>xD|xFz?|X #`pzk#  14 X$` |k$ 14 %`k% 14 &`Hk&  14h'`P>k8'I  14 (`k( 14 )`Xk)  14 X*``hk* 14 +`k+  14 ,`Hk, ! 14 H-`P`k- + 14T.`X?0/ . 5I  14(/`8@0/ / >I  14(0`@8Boh 0;;GI  14Z??? ??H1``Fkh 1((I I  14?rtF? 2` Tk 2 I I I I I (I$ HI( hI, I0 I4 I8 I< ZH0 8P@ HP ((0H0h ( (@  X0 ( X$ 14$ 14xp(8zP:@l @\ @X @(H @XD @4 @$ @@ @ @ h\>6@@ @ @ p(@XHP:8>@px @h @d @`T @D @4 @0 @x, @ @0 @ p(6@@ @ @ v@ X v@ p@( @ @@ (@ y0! !!8!!"PN:8@P!x @h!h @"d @"T @!D @!4 @@0 @, @! @@" @(" @ @X" @p" @" @ @ !>6(!  h$# $##p#%#@l $p#8>6@#h @P$X @T p@P `#@8$@ @$0 @$ @(% @$ @$ @$ X@$ @% @ @X% @@% @ @p% @% (@%t #(@@d  *&'&&(*0(Fb@&x @v @&d 0@'` @'P @0'@ @'0 @H' @x' p&N2468@' @ (@( @h( ((`$(@( @ @( @ `3 `'8>6@ h  P ,+,+(-0,2H,PN:R@+x @+h @1d @@-T @,D @,4 @X,2 p,0,L@0 Z-X,Lp@, X@, @, (@, @- @p- +T8Z\@ @X- @- @- @ X,@- @. -\P>@. @(.p @@.` @X.P @@p.@ @.0 @. @. @. @/ (@`/ @0/ @H/ @x/ @/ @/ @/ @/p @0` @/P @P0@ @ 00 @80 @p0 @0 @0 `@0 @1 @ @01 @H1 @`1 @x1 @p @1l @1h @d -6 @xh3283324N\8>@3x @ 3h @d @3T @P3D @34 @0 @3 @3 @4 @(4 @) @@4 @p4 @X4 @ 4@ 2685@5@(phP6555X75<@5X=X5@nl 5@58>6P:@5h @6X @7T @P `<5 @ 6@ @60 @86 @h6 @H<  @6 @6 @6 @7 \@6 @6 @(7 @7 @@7| @7l @7h h5~T\@d @0;` @7P @8@ @80 @08 @8 @H8 @`8 @x8 @8 @8 @8 @8 @P9 @9 @ 9p @89` @h9P @9@ @90 @9 @9 @@: @9 @9 @: @(: @X: @p: @: @ @:p N@:` @:P @:@ @;0 @; @ @H; @x; p7.*:PN@< ff(f`@0< @ @`< @x< @ @< <<n@ <<n>6<sf``;\4:8>6@>l @@=\ (@(?X @>H 8>===@?@D @>4 @?$ @ p@ @ = G?h@P@8@? @@`Tz ?58@:z @h @@X @@T p@@D @@ @0 hAAAAhAAA`z hA>A:l @h h@AX P@BT @ BD @@ @0 pBhC0CCHCEEBhDB@l XEBG P@xC\ @EX @`CH @C8 @C( @C @ @C @D @8D @ D @PD @D @D C\:(@D @D @Dt @Dd @(ET @ED @@E4 @$ XE@ EE^@\ @E @ _ EE^En @ @ @l  @FF@\  H(F 0(FHGG0G`GHFHF\P:@xGX @GH @D @XH4 @0 @G @G @G @G @ @0H HHH@H/ pH0H@ H0H@H HH@/ HHHG8>6IIII@x @t @Id @JT @(JD @@J4 @XJ$ @pJ @J @J @J @J @J @K @K @0K @HK @`Kt @xKd @KT @KD @K4 @K$ @K @L @ L @8L @PL @hL @L @L @L @L @t MMMM@x @t @Md @MT @ND @(N4 @@N$ @XN @pN @N @N @N @N @N @O @O @0O @HOt @`Od @xOT @OD @O4 @O$ @O @O @P @ P @8P @PP @hP @P @P @P @t hQ" R"R(*S( U`TTxTHT8>6(@Tx @Th @d @TT @TD @4 @U$ @8U @ @PU @ V VV8VhV8WVF(8>6N@PVt @Vd @W` @\ `hV8@VL @W< @V, @W @ @ W @PW VP:\`b@pW @W @W @W @ @ @ X(*`Y(HZ0ZZ(j@l @\ [([(8`P ^\\\@``_a_P:8>6@\ @\ @H] @] @] @] @0] @`] @x] @] @] @] @8^ @h^t @]d @^T @ ^D @P^4 @_0 @^ @^ @`  @^ @`_ p\(\N@_ @0_ @H_ @ @ @x_ @_ @_ @t @_p `_@l_ `_@`h ^@X`d @p`` @\ @X (a`@`T @`P @`L @H (`z_Cba`bb8baPb(8\>6@ bx @bh @d @` `8bT@xbP @b@ @b0 Z*@, @b @ @ (dcdcc8>6@cx @dh @d @@dT @P @Xd@ @pd0 @d @ @ fpeeeefe(8@ex @fh @d @(f` `@fe@eP @Pf@ @0 @, `(f@hf @f @f @ @ Xe>6 gggghhh@@hl 8>6@g\ @phX @T @hD @(h4 @Xh$ @h @xi @ i @h `hhT@ `h\g@i @8i @Pi @i @ @ @ j`jjxjHj8>6@jx @jh @d @jT @kD @4 @0 @ k @8k @Pk @ l ll8ll8>6@Plx @hlh @d @lT @lD @4 @0 @l @l @m @ nm@nmm8>6@nx @(nh @pnd @XnT @nD @4 @n0 @, @n @ @n @o @ o( 0qppppppp:&8>6@d @qT @HqD @p@ qp@<_ qpp@8 @`q( @xq @q @ @ rxrrr`r>86@rx @t @p @r` @8sP @s@ @ s0 @Ps @ @ tuHtt`tt0t t@,l t8>6N:@xth @tX @huT @tD @t4 @Pu$ @t @ u @ @8u @u @ @u @u @x @u @u @u @v @(vt @@vd @XvT @pvD @v4 @v$ @v @v @v @w @w @0w @Hw @`w @xw @w @wt @wd @wT @wD @ x4 @Px0 @8x @hx @ @ z8yyyPy y8>6@hyx @yh @d @yT @yD @z4 @Hz$  z y @0z @z @`z @xz @z @z @ @ @ |{{{{n8>6@h|l @{\ @8|L @|H @D @@ @P|0 @| @ @ P}}h}}8}}8>6@}x @}h @~d @~T @}D @h~4 @$ }@ ~ @8~ @P~ @ @~ @~ @~ @~ @~ @ @( @@| @Xl @\ @pL @< @, @ @ @ p`n8>6@l @?\ @L @H @@D @04 @$  x H @ @ @? @ @( @ @ @ @X @ @ pX@((8>6@l @\ @X @T @D @?4 @$ @ @ ?8>6@x @0h @d @HT @D @`4 @x$ @ @ @ x?`>86@x @t @p @` @8P @@ @ 0 @P @ @ ? h8>86@Px @h @d @T @D @4 @$ @  @ @ ?(>86@x @t @p @@` @P @X@ @p0 @ @ @ p?X>86@x @t @p @` @0P @@ @0 @H @ @ 0`x>86@Hx @t @p @` @?P @@ @ 0 @ @ @ H(h?H@l @\ @L @< @0, @` 8>6@x @ @ @? @ @P @ @ @8 @| @hl @\ @X @T Ho33H Dw  PX1`F{x   *W  *W0 `6JhBJ J,`  P X ` p ,W   6N L Nh V T Xh V :Z RX x R  :Z R  R 0 8Z8 Rp  R  P V Bh M M   0 # 8 #@ `h .bp .b   .b ( 8.bH x .b  $K  0 HDoh  *K,K0 8 @ P  XKh=B LSB8MP hxMBM M0HPXp xB=B L8HPSXBxM MBM0 HXMp       8 ( 0 88  %P >q`   >q   "! 0!8! @!-P!(4p!(P! ! !!!>q! "(" "0" 8"X"`">Z"#"" " """#z#>q(#Zxh###C#Zx#P$X$`$Yh$$8$2$%<%'0%>QP%%%>q%%% "% %& &:Z(&2h&#x&& & &&&&4&<q&Vx8' ''''<'@]'((>q(X(`( "h( .p(("4(((>q( )() B 0)8)@) -X)+x)+) )')))!* 8*@*H*'P*)p*!* *** *<q*)+!8+ X+`+h+ p+<q+)+!+ ,,,DM,>q`,),!, ,,,HM,>q@-)-!- --- .-(-.DM .>qh.).!. ... //Nm/@~`/Z/R0VX0@d0@d0@d01dp1T1Z02T2 62 3 333>q 3`3h3 "p3 "x33 -3 (3 (3 $/4 (04 &/P4 %x4 %4 %4 %4 %4 %5 %05 H5 P5X5`5 Dh55 -5:i5:i6<iX6Fx6&/6>i7$:H7 %p77 %77$:7 %77 %8 8$:(8 %P8p8 %x88$:8 %88 %89$:9 %@9 %`99 %9 %99$:9 %9 %:8: %@: %`::$:: %: %:: %: %;(;0; 8; @;H;P;>qX;;; " ; (;; ;Fz; 0<8<*K@<p< %x< -<"<""< <%=(0=!P= h= -p=(=(=$/=(=&/>%@>%X>%x>%>%>%>%> ?? ?2(?2H? !h?|x? !? @Vx@ %h@x@@@>q@@@ "@ @AA4JAPAXA>q`AAA "A AAA4JA B(B>q0BpBxB "B BBB4IBRxBHCPC>qXCCC "C C CC "C ,C D(D %8D 8HDD0DD D DDD>qD E(E "0E 8EXE_`EEE>qEEE B E 2E FBW(F %pF>qF %F FFFNgF %8G>qHG %G GGGG G4gG 9H %H >q(H %hH  xH H HHH=H %H>qH %I I I(I 0I8I@I>qHIII "I *III 1I %IJJ<ZJPJ<]XJJJJJ !J JJ2JKRK`K hKxK2KKKRKL>NL 'PLBj`LrLx MrMrNtNzOvO8ZO0P8P@PHPBjPP:ZPPPPPBjP<Z@QQQQQBjQ:ZQ(R0R8R@RBjHR:ZRRRRRBjR:Z8SxSSSSBjS8ZST T(T0TBj8T T !T +TTT>qTTU "U U0U8UXUxU %U U>SU UH[V :HV V EV V  V V V ZV <V  W :0W pW-W W 8iW W $3W X X $3(X PX `X BhX &X XVX&X X X X X X ZY $Y (YC8Y PY&_`Y"[Y YBY"[Z0Z8Z @Z<PZCZZZZBZ"Z ZUZ"[([0[ 8[ @[ *_H[ Hlx[ [ [ [ [  [ [ [ \\\ \ a(\ \ ;\] ^^ (_ 0_8_ !@_DWP__D^````pa !abbb>q b`bhb "pb xbbb>Sb cDic"Xc "pc  c%c "c  cc "c  cc>xcT8d~d2KeVzHe  eV}e  ff2Qf@]Hf4ff>qfffg>qgHgPg "Xg `gxg.Kg.Kg~g2K`h2Kh@]h4i0i8i>q@iii B i 2iiii j-0j.Pj  pj >qxj )j j  j jjNj  @k >qHk )k k  k kkk.tk  k >ql )@l Xl  `l hlplxl %l&]l*l2lBl0m 38m&]Xm m  m >qm )m m  m %n n%n  0n >q8n )xn n  n %n nn1n/n Kno -o(o0o 1@oXo`o 3ho  o>qo)o o  o %o ppp.^ p lPp  q>qq)r  r  (r %0r @r Hr 4Pr rr&Er 1r r <r sss&bsZ@sXsGhss @s*sHhstnt  t $6t>qt t>qu @u )Hu `u  hu %pu uu uu/u<uuu u >qv )@vXv `v %hvxvvvvv$Dv vTuvHl(w pw xwww wDWwwLew@x Hx !hx>Sxx|xd8yLy"yzz[z 0z T@zz LzzzT{X{ `{ h{;p{ {| |}} !} }}}>q} ~(~ "0~ .8~h~ p~4~~~~>q~~ " (80J@4p .K8hFxpJfJfhpx>q? "? $? .K.KH~x2K2K0Fxh %??>q? "( (0X `px>q? " ? (?=>q `h p>I ?>q? (*d0`h>qp>q " $@DfH__?>q08 "@ 0Hx_>q " 4@4NH__???>q ( "0 8X_`>q?? " ,_ @H>qP " &?_?>qHP B X`Th B U  B  Z p_"?T9@ `h 6p" v  ( 1??'    /  9(4HBXpx 6   :? ?2V8@H PX` hpx B  ? 15,g0:@PX9`:x'&] Z %&^8 [` x $??:>q@H B P *X @lJs8@H>qP x! update tool-menubar if necessary u8h0' (bje ! !MenuUpdate B@lhP ( !!Unregi B@l 2 called when user presses continue on "show" stop.'"l- called when user presses stop on "show" stop'"l@ user presses "add" buttonAdd'('*l8Cancel'(l user presses "delete" buttonConstraint_list Solver_dialog %0%2!4 (solver_msg_25b 8%:!f !< >&A@6'(a@Delete'(h(l 0user hits "guess" buttonZDA@FGuess'( Solver_dialog %0 Optimum_cell7H!J solver_msg_3 8%:!f !< >&A@6 Optimum_cell7H!9Lu h N Optimum_cell7H!9Luh Optimum_cell7H!J$P$:!R solver_msg_4 8%:!f !< >&A@6 Optimum_cell7H!9Lu@a8 Optimum_Cell7H!J$P$:!T!V'B B Optimum_Cell7H!J$P$:!T!RAdjustable_cells7H(Ja \Z Optimum_Cell7H!J$P$:!T%XAdjustable_cells7H(Jh0a( \Z ` Optimum_Cell7H!J$P$:!T%^%XAdjustable_cells7H(JhhnA@buD solver_msg_4 8%:!f !< >&A@6 Optimum_cell Solver_dialog %0%H! Solver_dialog %0(Lul user hits "Change" buttonChange'('*l user presses "options" buttonOptions'(l`8 user presses "reset"Continue'(A@jl user presses "save model" Save_model'(l user presses "load model" Load_model'(l()prepares and displays "save model" dialogZxv0Options'( solver_msg_46 8%:!f Save_dialog %0!x(J z$P$:!|'r z$P$:!~'tConstraint_list Solver_dialog %0%2!' r t$ r  t$$:B@J \Z %XThe_area Save_dialog %0%H(J Save_dialog %0B@uvsolver_err_msg 8%:!f !< >&A@6dplhSaveload'(lHv8ZH`xZZ 8ZPhZThe_area Save_dialog %0%H!J$P$:!V  The_area Save_dialog %0%H!J$P$:!V  (solver_msg_131 8%:!f    solver_msg_132 8%:!f !< >*A@6 Save_again'(uXhP'The_area Save_dialog %0%H!J$P$:!V The_area Save_dialog %0%H!J: \Z  The_area Save_dialog %0%H!J$P$:%%XThe_area Save_dialog %0%H(JhThe_area Save_dialog %0%H!J!}savefunc 8%:!f savearg1 8%:!f:="$The_area Save_dialog %0%H!J"$'a8The_area Save_dialog %0%H!J"$}savefunc 8%:!f savearg1 8%:!f:="$The_area Save_dialog %0%H!J"$'aPsavefunc 8%:!f savearg1 8%:!f:="$The_area Save_dialog %0%H!J$"$'hh  B@ The_area Save_dialog %0%H!J$P$:  N =MAX( N$:!X) ( b=MIN( N$:!X) (advalueof Solver_dialog %0%H!J'.  %   %}' _.     %}' h = N$:!X=  (h h b =COUNT( $:!X) (hH   b  optionsMax_timeOptions_dialog %0%H!J'   %Max_iterOptions_dialog %0%H!J'   % PrecisionOptions_dialog %0%H!J'   % ToleranceOptions_dialog %0%H!JdU '   %AssumeOptions_dialog %0%! U '   % Show_iterOptions_dialog %0%! U '   %auto_sclOptions_dialog %0%! U 'TangentOptions_dialog %0%!    %1'a   %2'hX ForwardOptions_dialog %0%!    %1'a   %2'h NewtonOptions_dialog %0%!    %1'ah   %2'h@   % ConvergenceOptions_dialog %0%H!J'   %non_negOptions_dialog %0%! U '.  %   %}' _.     %}' h !  !& ! =VAR( ) (a={ } (ha solver_lhs  %U $' solver_rel  %U $' 1HQ<=' solver_rhs  %U $'2HQ=' solver_rhs  %U $'3HQ>=' solver_rhs  %U $'4HQ='INT( $:!X)'k !  !& !  4 5=SUM( $:!X) SUM( )'aH 4 =INT(SUM( $:!X))'a =INT(SUM( $:!X))=1'hh  (a 5 $:!X  ' $:!V .  % .}' _  %   .}'h    %'.  %   %}' _.     %}'PhH=  (a(.  %   %}' _.     %}'h=  (ha( $:!X=0)+( $:!X=1)=1' $:!V .  % .}' _  %   .}'h    %'.  %   %}' _.     %}'h=  (a.  %   %}' _.     %}'phh=  (hHh@h8h0  '   rh z$P$:B@Ju z$P$:B@J ( solver_msg_se 8%:!f !< >*A@6uXvPsolver_err_msg 8%:!f !< >&A@6dl)prepares and displays "load model" dialogvOptions'( Save_dialog %0 solver_msg_45 8%:!f5x(J \Z %XThe_area7H(JC@n0u(v solver_err_msg 8%:!f !< >&A@6dl0 validation of variablesvZAdjustable_cells Solver_dialog %0%H!J' $P''' uh $:!! ! solver_msg_3a 8%:!f !< >&A@6Adjustable_cells Solver_dialog %0%H! Solver_dialog %0(Lu0h( $:!V Adjustable_cells Solver_dialog %0%H! Solver_dialog %0(Luhv $:!!V'     $:%!X$  %'   $:%!X  %'   $'   $' Adjustable_cells Solver_dialog %0%H(fuhv`solver_err_msg 8%:!f !< >&A@6dlvalidation of objectivevZ0 Optimum_cell Solver_dialog %0%H!J' !Z  $P'hp'N uPhH@ $:!V $:!! ! solver_msg_7 8%:!f !< >&A@6 Optimum_cell Solver_dialog %0%H! Solver_dialog %0(L'(u`hXvP $:!X'N N$ Optimum_cell Solver_dialog %0%H(fuvsolver_err_msg 8%:!f !< >&A@6dlH( prepares and displays option dialog boxvXOptions_dialog %0B@u(v solver_err_msg 8%:!f !< >&A@6dlZ  Options_dialog %0Max_time7H!JU'Max_iter7H!JU' OK_button7(    Max_time7H!9L OK_button7('sh    Max_iter7H!9L OK_button7('s@h8  solver_msg_8 8%:!f !< >&A@6Max_time7H!9L OK_button7('sh  solver_msg_9 8%:!f !< >&A@6Max_iter7H!9L OK_button7('sh Precision7H!JU Precision7H!JU solver_msg_10 8%:!f !< >&A@6 Precision7H!9L OK_button7('sh Convergence7H!JU Convergence7H!JUsolver_msg_10a 8%:!f !< >&A@6 Convergence7H!9L OK_button7('s0h( Tolerance7H!JU Tolerance7H(Jh Tolerance7H!JU Tolerance7H!JUd solver_msg_11 8%:!f !< >&A@6 Tolerance7H!9L OK_button7('sh'A@ optionsfunc 8%:!f optarg1 8%:!f:='  , optarg2 8%:!f:= ' , optarg3 8%:!f:= solver_pre %U $' , optarg4 8%:!f:=Assume7! ' , optarg5 8%:!f:= Show_iter7! ' , optarg6 8%:!f:=  ' , optarg7 8%:!f:=  ' , optarg8 8%:!f:=  ' , optarg9 8%:!f:= solver_tol %U $UdU ' , optarg10 8%:!f:=auto_scl7! ' , optarg11 8%:!f:= solver_cvg %U $' , optarg12 8%:!f:=non_neg7! '  B@n '(s v solver_err_msg 8%:!f !< >&A@6d f 0  restore settings if not new Options_dialog %0dU Max_time7H(JdU Max_iter7H(J??>U Precision7H(JU Tolerance7H(JMbP?U Convergence7H(J Assume7( non_neg7(  show_iter7( auto_scl7( Tangent7( Forward7( Newton7(n '(u h > If old model, these names are not always available; therefor:H Options_dialog %0 solver_tim %U $Max_time7H(J solver_itr %U $Max_iter7H(J solver_pre %U $ Precision7H(J solver_tol %U $UdU Tolerance7H(JMbP?U Convergence7H(J solver_cvg %U $ Convergence7H(J solver_lin %U =1 Assume7(ap Assume7(hP solver_neg %U =1 Non_neg7(a non_neg7(h solver_sho %U =1  Show_iter7(a  Show_iter7(h` solver_scl %U =1 auto_scl7(a auto_scl7(h solver_est %U =1 Tangent7(  Quadratic7(ax Tangent7(  Quadratic7(h0 solver_drv %U =1 Forward7( Central7(a Forward7( Central7(hx solver_nwt %U =1 Newton7(  Conjugate7(a Newton7(  Conjugate7(hvn'(uvsolver_err_msg 8%:!f !< >&A@6d`lX "reset everything to default valuesv   solver_msg_17 8%:!f! !< >&$6uh resetfunc 8%:!f B@h ( Solver_dialog %0 Optimum_cell7H(fAdjustable_cells7H(JConstraint_list72B@   max_button7(U dValueof7H(fdValueof7H(nOptions_dialog %0dU Max_time7H(JdU Max_iter7H(J??>U Precision7H(JU Tolerance7H(JMbP?U Convergence7H(J Assume7( non_neg7(  show_iter7( auto_scl7( Tangent7( Forward7( Newton7(nA@ solver_adj %B@ solver_opt %B@  (' !' !solver_numConstraint_list solver_dialog %0%2! B@  (?  Optimum_cell Solver_dialog %0%H! Solver_dialog %0(L (h?ux?vp?solver_err_msg 8%:!f !< >&A@6d(?l ?  user clicks on "max"v>'dValueof Solver_dialog %0%H(u>v>solver_err_msg 8%:!f !< >&A@6dX>lP>@  user clicks on "min"v >'dValueof Solver_dialog %0%H(u=v=solver_err_msg 8%:!f !< >&A@6d=l=  user clicks on "value of"vP='dValueof Solver_dialog %0%H(dValueof Solver_dialog %0%H! Solver_dialog %0(Lu<v<solver_err_msg 8%:!f !< >&A@6d`<lX<  user hits solve CallSolver'(l<0 & user hits cancel in finish dialog boxv;Z  (2 Application.Run ("'Excel4Functions'!RestoreCall")'  $: $& (  '0;u(;v ;solver_err_msg 8%:!f !< >&A@6d:l:  help for finish dialogv: !< >- B@*ux:vp:solver_err_msg 8%:!f !< >&A@6d(:l : , validation of model before trying to solve.v9Adjustable_cells Solver_dialog %0%H!J ( solver_msg_18 8%:!f !< >&A@6 (',s 9h9 NConstraint_list solver_dialog %0%2! ( solver_msg_18 8%:!f !< >&A@6 (',sX8hP8H8 N $: N$: %.!V $:!V N$:!R ( solver_msg_7a 8%:!f !< >&A@6 (',sx7hp7hh7h`7 $:!V  ( solver_msg_19 8%:!f !< >&A@6 (',s6h6',s6v6solver_err_msg 8%:!f !< >&A@6dp6fh6P # defines necessary names for solverv(6Z !'0 (A@FA@b max_button Solver_dialog %0%! ' min_button Solver_dialog %0%! b'aX5'hH5  ( N 5 solver_opt %B@a4' !' !solver_opt= N !B@h4 4 solver_adj %B@vX4aP4' !' !solver_adj=  !B@h3Constraint_list solver_dialog %0%2!' !' !' !solver_typ C@' !' !solver_valdvalueof solver_dialog %0%H!fUC@' !' !solver_numConstraint_list solver_dialog %0%2!C@' !' !solver_timMax_timeOptions_dialog %0%H!JUC@' !' !solver_itrMax_iterOptions_dialog %0%H!JUC@' !' !solver_pre PrecisionOptions_dialog %0%H!JUC@' !' !solver_tol ToleranceOptions_dialog %0%H!JUdC@' !' !solver_cvg ConvergenceOptions_dialog %0%H!JUC@assumeOptions_dialog %0%! '2a/'2h/' !' !solver_lin 2C@non_negOptions_dialog %0%! '4a/'4h/' !' !solver_neg 4C@ Show_iterOptions_dialog %0%! '6ap.'6h`.' !' !solver_sho 6C@auto_sclOptions_dialog %0%! '8a-'8h-' !' !solver_scl 8C@TangentOptions_dialog %0%! 'a -'h-' !' !solver_est C@ForwardOptions_dialog %0%! 'ax,'hh,' !' !solver_drv C@NewtonOptions_dialog %0%! 'a+'h+' !' !solver_nwt C@nx+  ( 0 (uP+vH+solver_err_msg 8%:!f !< >&A@6d+l*  delete a constraintv*Z  8 P Zh    Z    ('LConstraint_list Solver_dialog %0%2!4'< < Constraint_list Solver_dialog %0%2! solver_lhs $P$N %U $'>p) >$:!X$R 'H'Lr@)h8) >$:!X$'> solver_rel $P$N %U $U'B B solver_rhs $P$N %U $'@ @$T @$'@hh( BOptions Add_dialog %0%V%X'D Bbsolver_msg_int 8%:!f'@='D Bbsolver_msg_bin 8%:!f'@='Dh'.  % @.}' _  % @  @.}'('h ' B ''Z @$:!X$'@ Z  formula @ !}'  @' !'!} @' !'!}' _ @  $ @ @  !  $\'@ @' !'!}'%a% _ @  $ @ @  ! $\'@ @ !}'P%hH%h@%.  % @.}' _  % @  @.}'$h$h$h$ >  D  @$N'F <Constraint_list Solver_dialog %0%2%X F 'Hr0$h($ @$R'L 'Hr$h## L B delfunc 8%:!f addarg1 8%:!f:="$ \Z >$P$:%X"$, addarg2 8%:!f:= B B@a# @"$}delfunc 8%:!f addarg1 8%:!f:="$ \Z >$P$:%X"$, addarg2 8%:!f:= B, addarg3 8%:!f:="$ @"$ B@a!delfunc 8%:!f addarg1 8%:!f:="$ \Z >$P$:%X"$, addarg2 8%:!f:= B, addarg3 8%:!f:="$ @$"$ B@h h h  ( <`Constraint_list Solver_dialog %0%2B@^' !' !solver_numConstraint_list solver_dialog %0%2! !B@Constraint_list Solver_dialog %0%2! 'J' !' !solver_lhs H$P$N solver_lhs J$P$N %! B@' !' !solver_rel H$P$N solver_rel J$P$N %! B@' !' !solver_rhs H$P$N solver_rhs J$P$N %! B@  (huvsolver_err_msg 8%:!f !< >&A@6dl( change a constraintv`ZxConstraint_list Solver_dialog %0%2!4'< < <Constraint_list Solver_dialog %0%2%X'h h <= } h <= }'d'f h >= } b h >= }'d'fa0 h = }'d'fh h d$$Nlhs Add_dialog %0%H(J= h h d  $\$N rhs Add_dialog %0%H(J<==>= solver_int 8%:!f solver_bin 8%:!fDOptions Add_dialog %0%V(XOptions Add_dialog %0%V(jrhs Add_dialog %0%H!J=solver_msg_int 8%:!f'frhs Add_dialog %0%H!J=solver_msg_bin 8%:!fb'fh fOptions Add_dialog %0%V(4solver_msg_46b 8%:!f Add_dialog %0!x(J Add_dialog %0B@aPsolver_msg_25a 8%:!f !< >&A@6huvsolver_err_msg 8%:!f !< >&A@6dl add a constraintvlhs Add_dialog %0%H(Jrhs Add_dialog %0%H(J<==>= solver_int 8%:!f solver_bin 8%:!fDOptions Add_dialog %0%V(XOptions Add_dialog %0%V(jOptions Add_dialog %0%V(4solver_msg_46a 8%:!f Add_dialog %0!x(J Add_dialog %0B@uvsolver_err_msg 8%:!f !< >&A@6dxlp(+ validates constraint and saves it if validv(ZZ(Z@Xp Add_dialog %0lhs7H!J  solver_msg_20 8%:!f !< >&A@6lhs7H!9Lh('nshlhs7H!J!}lhs7H!J !}  solver_msg_20 8%:!f !< >&A@6lhs7H!9LhX'nsHh@8lhs7H!J$P$:!!V  solver_msg_20 8%:!f !< >&A@6lhs7H!9Lh'nshv (lhs7H!J$P$:!V'pOptions7V!4'v !Z rhs7H!J !Z !Z ~ %rhs7H(Jhrhs7H!J$P$Trhs7H!J$P$:!V'r r  solver_msg_21 8%:!f !< >&A@6rhs7H!9Lh'n (s r p r b  solver_msg_22 8%:!f !< >&A@6rhs7H!9Lhh'n (sHh@rhs7H!J'@ @$= @ @ $\$'@a @$'@h @x rhs7H!J'@harhs7H!J$P$  solver_msg_21 8%:!f !< >&A@6rhs7H!9Lh'n (shrhs7H!J$P %$rhs7H!Jsolver_msg_int 8%:!frhs7H!J=solver_msg_int 8%:!f voptions7V%X solver_int 8%:!frhs7H!Jsolver_msg_bin 8%:!frhs7H!J=solver_msg_bin 8%:!f voptions7V%X solver_bin 8%:!f  solver_msg_21 8%:!f !< >&A@6rhs7H!9Lh 'n (s a rhs7H!J !Z !Z ~ %'@hp ah rhs7H!J$=rhs7H!J'@a =rhs7H!J'@h h h lhs7H!J$P$:!X'> >$:!X$'> >x >$:!X'>hx voptions7V%X'Doptions7V!4'x D solver_int 8%:!f D solver_bin 8%:!f  solver_adj %!$:!V >$P$: solver_adj %!$:$.!V  D solver_int 8%:!f solver_msg_23 8%:!f !< >&A@6a solver_msg_24 8%:!f !< >&A@6h lhs7H!9Lh 'n (sx hp ='DhX @$= @ @ $\'@h @x solver_msg_151 8%:!f !< >&A@6rhs7H!9Lh 'n (s hx *A@:h` >  D  @'F'z Constraint_list Solver_dialog %0%2!$P$N F Constraint_list Solver_dialog %0%2%X 'zrhxp z FfConstraint_list Solver_dialog %0%2B@a Ff z`Constraint_list Solver_dialog %0%2B@h update define names  (Constraint_list Solver_dialog %0%2!'|' !' !solver_numConstraint_list solver_dialog %0%2! B@' !' !solver_lhs |= >$P$:!X B@' !' !solver_rel | x B@ @$P$T't @$!'t t' !' !solver_rhs |= @ B@a`' !' !solver_rhs | t B@ha' !' !solver_rhs |= @ B@h'n  @"$}addfunc 8%:!f addarg1 8%:!f:="$ \Z >$P$:%X"$, addarg2 8%:!f:= x, addarg3 8%:!f:="$ @"$ B@ahaddfunc 8%:!f addarg1 8%:!f:="$ \Z >$P$:%X"$, addarg2 8%:!f:= x, addarg3 8%:!f:="$ @$"$ B@hPhH  (n0s(v solver_err_msg 8%:!f !< >&A@6df( user clicks ok in add-constraint dialogv$n add_dialog %0B@hXuPvHsolver_err_msg 8%:!f !< >&A@6dl" user changes middle of constraintvOptions Add_dialog %0%V!4HHHQrhs Add_dialog %0%H!J=solver_msg_int 8%:!frhs Add_dialog %0%H!J=solver_msg_bin 8%:!frhs Add_dialog %0%H(Jhrhs Add_dialog %0%H! Add_dialog %0(LHQsolver_msg_int 8%:!frhs Add_dialog %0%H(JHQsolver_msg_bin 8%:!frhs Add_dialog %0%H(Jk~u~v~solver_err_msg 8%:!f !< >&A@6d8~l0~Xuser clicks add in add-dialogv}$nlhs Add_dialog %0%H(Jrhs Add_dialog %0%H(J<==>= solver_int 8%:!f solver_bin 8%:!fDOptions Add_dialog %0%V(XOptions Add_dialog %0%V(jOptions Add_dialog %0%V(4lhs Add_dialog %0%H! Add_dialog %0(L (h8|u0|v(|solver_err_msg 8%:!f !< >&A@6d{l{! user hits "save scenario" buttonv{scenario'(u{v{solver_err_msg 8%:!f !< >&A@6d8{l0{" user clicks OK in scenario dialogvz $:!V solver_msg_25 8%:!f !< >+A@6uzhz $ Scenario_nameScenario_dialog %0%H!J'h8z solver_msg_24a 8%:!f !< >+A@6uyhyy  $: !B@uyysolver_msg_24b 8%:!f !< >+A@6uHyv@ysolver_err_msg 8%:!f !< >&A@6dxlxhhelp for add-constraint dialogvx Add_dialog %0!x!Jsolver_msg_46a 8%:!f !< >' B@*aHx !< >( B@*h xuxvxsolver_err_msg 8%:!f !< >&A@6dwlw) help for user when solver is interruptedvw !< >, B@*uXwvPwsolver_err_msg 8%:!f !< >&A@6dwlw. help for user when load or save model is usedvv Save_dialog %0!x!J Save Model !< >* B@*aXv !< >) B@*h0vu(vv vsolver_err_msg 8%:!f !< >&A@6duluX help from main dialogvu !< >& B@*uxuvpusolver_err_msg 8%:!f !< >&A@6d(ul u% help from option dialog small solvervt !< >. B@*utvtsolver_err_msg 8%:!f !< >&A@6dhtl`t help from save scenario dialogv(t !< >+ B@*utvssolver_err_msg 8%:!f !< >&A@6dslsHs $:!!V 'Tahs'ThXsfPs@s $:!!V'as'hsfr(S translates cell reference into names if name is defined, otherwise returns addressZZv`r $P'    %' !}GET.DEF("$ "$  %GET.DOCUMENT(1))' $$String 'aq $'hxqapq '}GET.DEF("$   !} $\"$  %GET.DOCUMENT(1))'apGET.DEF("$     $\'}  $\"$  %GET.DOCUMENT(1))'h@p8p !''   B@J' $:B@J  $$String !  $:!X'ao 'hxoapo $'hXorPohHo@o $B@Jh(o  'ho !Z  'an    %'hnsnvn 'snn'nfn( creates names for reportsvPnZZ0 !' $B@ $ \Z $P$:%X $' $B@smhm $:!|'r $:!~'t''  r   t$!$String  t$!'rlhll  t  r $!$String r $!'rlhxlpl     'a8l  'h l $B@slvlsolver_err_msg 8%:!f !< >&A@6dkfkH# changes argument order for optionsvpk  U U U     d U $ 'ak U U U     d U  U $ 'hjsjvjsolver_err_msg 8%:!f !< >&A@6dhjf`jXjwAttribute VB_Name = "Solver2" Option ExplicitHPub, Sub Auto_open() ,.ProcDataInvok@e_Func P\n14h ' updatool-menubar if necessary R 'IfuOted Then0ExitEnpd If 1= Truepjap.ScreeDnUAingNFalsRun (ThisWor@kbook.&0 "!MZ e"O?4 cplose A`UnregiJ/A.Cont_toL|h/' callqwq us er pr{es c@inue "show" `stop.n_sGj\,S@ ,,s,%+Q++Push_ad^dKE)JS""f n$ac}AddDpchang?aD_xWW "~Cancel deletf#M"K$ |DialogSheets(?_d").ListBoxe@astrai`elAIndexU0:xGMsg H ex$4l@5u age.Ra6("a_msg_25b@Text, @32, , i Path & helpfile, 1830cB` 1dBED"1e$&7@Ap4gu{[77[hits "b+7Dimc As IntPeger#O rror GoTo "ebj? GWi '?B%BC I.EdiCCAmum_8l5CaC@q"KCau>r>3_>T>Q.Focus) v an7 Pva %wt)opt"~ 4,~ A Not 1Stylechec k()).HasFormula_8Q84P?898 ____?;quo)_CLel)`Prdents.Coun !41O0___XfAdjustable6s6,N 0=&-?7xO(Referepb+:=saves,@w 60_ / O1/ 2`K/ ' 0Specq!s(xlpa").  a a $e XWsgI]:;;;ssa?!(V//$?2d@A xx_xTqp?xCxt@auBc)s As Js!" "="a;ons@;et _r  H?Reset_P@py D e Push_save.VB_ProcDataXInvoke_Func = " \n14" ' user presses "| model@actionl S_4End Sub P`ublicload() Attribut8>LpnPtatSe T' Tpa adisplay dialogDim rowiAs Lon@g, colI@ntegerOn Error GoTo maineOpsDlThisWorkbook.DSheets(&"7"")Frame.Cayexcel4language.Re("solver_msg_46Text!2= C Stylecheck(cu rrentFa)).Row : Column xnum@(8)8ListBoxe>@ConstrPt_l@0Coun2/CellsF(5e),  8+ 2$ ).Se@?&bEdiE)The_L'dC.AddA(RefeVce[:=s!/n^_Q Sh2ExiRtx L:/Msg`( CRC !C, 32, ,0 App@non.Path & helpfile, 1830 &vA}Ovv?e+gDo1fkZyAi , jkC&!the ZhingS", _answ1I varj le ft) middlerigh ; o`_donB Boolea}dummy, vbacHobj, 2C,b_(If?e$et" < 3J A<_['non> <1 +4)8ScreenUpd9P#= True >``131t>U<"&M&@"/Cgd132/C/C(C4 <_ag?]4pMpIfei@d-1?!kj(Ogtg ?!awP[F=Moa%///f: /3Offset(t0)nna[UIn`Po  , "!")"05eI=qn-`f p&20Harg 5:=Chr(34)? $s/El~s?//, 8BFtp"_ X  J !&$$!gNfix////&J"!xS6yeRecordMacro basicq{:=&FPEach c In?EO.O.O.M.)p -c^p  <> "">dtyp`@u  "c. mula0"=MAX(;?~w&M@")Xj27q$g 2O =MINnge(solver_opt).Address & ")" ! Else H dummy2 = ThisWorkbook.DialogSheets("Sd(").EditBoxe4dvalueofCaptionaIf "." <> A@pplica%.@Intern al(xlDecimalSeparator)eLInStrj(_,-)R+Do WhileW0Mid;?, 1)HsCYLoopE nd Ifc.FormulaA*="RaB-2L@}i0qadjAY ""zK+COUN|T(,@W% n@um + 1' ?s >thestring@5Os_Max_time B&ZListHf&w@x=ir??nOy?9Prs1__TC:r:Toleranc: / 100jG= ( Check$As4suBOV!XxlOn)<)(dShow_$Qaq))R auto_scl?R`55BuPtton`Tsnt, i7%wv1 ?+oooc2kjONL0nwardO?O]VY."Oroo?oO~OO(7LNew '??Hp ??f&o???p"?;___wocCXxCon0gec 6666X. )Nnon_negl!+cp'???h%pis%n mQ__ ?$ ? ?ActiveFaat}WK3 Or OReF38.oF$M3f kVA~RB|od<{{Q }bl|efA/.Namalhsi)), 2`midd= crel!Select CaserC,ac F"<=! righCStr(ActiveSheet.Names("solver_rhs" & i)), 2)  Case "2" ,Dmidstring = "=@theright>Mid(?j3>b4CB"INT(Range(left).Address") 1End SelectIf Workbook.Fil@eFormaxlWK3 Or 38]FM3 Then @ /dle <> "04" A* 5" SUMEFG& " @CNElse .@..P8 *?Ao +!"v=13PIf <c.EulatF N>; ]9@8L#,Count0 > 1TK"."RApplication.Internbal(xlDecimalSeparator) ` dumdmyIn!f&, CDo Wh s d0O! b, 1)X =  Loopr RKContO, xlA1R1C1*`A::( 3"?.(.@/@)"b@::_  4  FArra3p0\v! /G<<<  CC4??`?my_ R,_ OwO_ x?/fp  E"?a*=0)+/+1)/tp&ff 7****Y@o'o'Go'f'_0_0V0<6_ _  o'" ! fffcooooF G  7 G_ _ o,$  fqfFbt Mid(thestring, dummy, 1) = "."< (RJInStr Application.@Internal(xlDecimalSepar@ator))aLoopEnd Ifc.Formula=" & /#  i4i + 1/If i > solver_num Then AExit V +Next Range(Stylecheck(currentarea)).Se (Sub save_error:"nScreenUpdong:TrueCMsgBox excel4l)uage .C+">msg_@se").T3, 32, , Pathhhel pfile8343main2[a _@0nd AcR Pub@ @ Load_model(Atbute.VB_Pr@ocDataInvoke_FuncO" \n1"4'pres adispl@ays "l " dialoBg%On Et `GoTo EacA?OpAsWiXThisWorkbook.DB Sheets("SAE "(qFrame.CaB =45d..Edit`Ee }`_!W cXaAddress(RHefe\ce^:=YsA`)Show a5kB7?GoV?GV2GGt`hcHAdjustabl "HHAH valiAton ofri #!FDim As S newCadj_countAger,@FO/cOIE!_@lsGF/ ?DEb$"G!;Nf,Resume ?@ Sc ).!qso.Nk <> AwveBrcr_3a`$_VT+ /gB,Focus//K0 @_?#?5Not C(> 0  _R*%M  a?#_#or\+6=?As.cp@8= 1 a1>Y0(& Get_n(((i).Y)z |1??List6& -}e7=` Leftq, n) -sZ y''1$r6Y g2?n}?n?nmb Obj?l oTX'lobjeQl orllPl=B?>>mumh`M?I10xlxR1C9Y /lng$l9C'opt0kB""P?Ukk9Vj1 Or_omomom?m7_m??83_mo"S\?`?`!!ll a}S!\+?0? Z/H"Hts("Solver_dialog").EditBoxeOptimum_celldText = Get_name(sopt) Exit Sub mainerror:2Msg ex4language.Re("cG/_msh, 32, , Application.Path & helpfile, 1830znd End~ Pub6 Show_As(Attribute .VB_ProcDataInvoke _Funcy" \n14"5' prepares a8displPays 1 boxOn E GoTo ThisWorkbook.D0Shee?onsdZA}[tic Lk 0x_OKK]\PResume NBDim thee As Do~@iter@vbacodB S@ngWiaC = CDbl(IMax_#@Ca@on$ + .Butt@("OK_Dismiss!True%IfFC<> Int(D*) Or>767 Then9.Focus{ N`~ Fals ?.YFc ayIfc9B!4A )r-`@D3 <= 0k1ra_8@=m'7Pn=c9#=#msg_9##?FBus?F@?FPrecis@I}AI >= 1'o2xzngzA10P'zz' ?9_P\PoongFaFFCon@gencer?` ) >a ]OK]fToleraj"" *C ~<(0wOn) <0Y?4("140?\?<1  J y~Defs`U=FFfpdx" "PIarg5:=&&& ",_6S2(P |qa_ _>S3^Mid(,Active.@R ")), 24.= _p\4(.Check+!As@Value8xlO/O#5/*A_ / $$!6!^2 - st/ / g7drvel5,` nw t? rg9").Text & ":="0CStr(CDbl(Mid(4ActiveSheet.Names("solver_tol")), 2)) * 100) vbacode = , excel4language.Re("optarg10(.CheckBoxvauto_sct .Valu`xl4On  N/lO HS1 Ua 3 SX  = #}")#4 a #/) oe? `gj /"QuadrPcgj nr r0"5l6Edrv3ozozBP-Centra\?ROO*>P__:M=[Iwwo1 ":U" bjugat Xl%_Poo_%GoTo fC:S?6?&n." ? Public Sub Reset_all(do_msg) Attributep.VB_Pro cData,Invoke_Func = " \n@14" 'r everything to default valuesPOn Error GoTo maineIf  Then\MsgBox(excel4language.Re("solw_17").Text, 33,@ , Appation.Path & helpfile, 1830) <> 1 89Exit BEnd If+RecordMacro basiccode:=VfT(. -ScreenUpd`= Fal$seWigThisWorkbook.DialogSheets("Sd "5A.EditSe Optimum_UlD$vu I Adjustable s@ Ca@Don LisC onstr@zt_l@ RemoveAllItemA#onButt ("max_7 VAxl*O I'dof CStr(0> En4d@ WdXc[.s_[vM@4\e(NB)10) iter Precis (0.01"To@lerancP5Tw5_KSf:) N#?VDef_namActiv2eB.N?adj@Deletywopy@isa".Add !:="'"' @"!Dnum", RefersTo:=$ p.CounVe:=(= thelFFocus&_?F7+- ZTru$moy:3x omg7x|qx$mDx2OxOx0` v rw 1P`_push(Hooe user c ks Pl!gT&typp1 xy_hYh1nOOI iny Msin24(" *=1111b"k%???4 ps2;223ox7L777V_RV_Sr_Sd+_!_!_!_!]!_promm;S hits #a`CCPr\3 Finish_cQlk /o o o s i,n  c> box ++Dim i As Integer, c/Sto w'*Run ("'Ers'!torvei,d @Each cP S"PXc.=oldvars(ii + S Next Exit Sub maine rror:MsgBox excel4langu age.R e("solver_^_msg").T, 32, , Application.Path & helpfile, 1830nd End~ Pub6 Finish_5() Attribute .VB_Pr@ocData Invoke_Func = " \Pn14"i' for fY d ialogOn E{ GoTon eHbn7_ blem_okVAVvalid{ of model beZe trying to .F[If ThisWorkb ook.DjSheets("SCCo@EditeAdjusta%@6_ls@Cap<@"@en@IuScreen Up0+= TrueF a@_180#FalsG#hx/IfUoptx" A@ox-f-Lise-Constrt_l CounA 0--?5---` |-\Resume譫0<> " SiiSUn`(c1a`dj), J :)<)./` DThG(`` NotO .HasFormula+9b {g?hra_7a?h? zeci<?@g%k  mn1> 20eVmsg_19_*/"Ro#G?OIgWlB%_  ?tnc BDee_na~mgZtofd"s necessary ?/tDim u#e As B`ooleaod=?O<p3q"ObvjwsEeg|`POzButte("max_Value9 kxl`JL$Qtyp1sE0\??min2 3xCActiveB .N0$ 8sQ v{* f - Dele~t?q#F s .Add :="'"0 &  "!XjeferhsTop=q, Visi :=(ETporxQ  "' P num66t(" Wiet>o!}-~:z `//'@*CDbl(B!dueofPO+ ? ? < P: !td Name:="'" & ActiveSheet.`"!solver_tim", RefersTo:=CDbl(ThisWorkbook.@Dialogs("Options_d*").EditBoxe6(MaxeCa'), VisiblFalse .Ad-itrJiterSpreSPreconQTtol?*~TolerancI~ / 100?cvg++Conge ,*If iCheckassumDValue = xlOn@enCc7lin1E 2nd Ifp? *)g? .) non_negW^ [ _ rbD @ _ _ J Show_ xsho  r~_` @ auto_sclAcl|   Yr cl  .Butt@("Tajnt fOest 0$~Pe;_O For_`o@IGOQ/&lForwardobhodrvo! 4;o Qor_`ooqlNew`!___nw BU__= \_0Swt _AE'With*= thes nDpplica.Scre enUpdng uExit Sub mainerror:#Msg`v ex cel4l5uage.R6("!_msgTex 32, , A!Path0helpfile, 18357nd  Pub0 ( Stp c1 Delete_c=tr t() Attribute.VB_Pr@ocDataInvoke_Func`" \n1D4" ' d \a  Eq `GoTo fDim which_one As Integer,AA_leftAS ng3righJmid_i ?i.dlEnewentry=jxp!] la>s01 RXBoan, dum|my#yN%= =?N7NS?&NLisU?s _lP>Index W> 0'pOQ i 1 _tCountC#!= Mid(C(;P4lhs Trim(i), 20/Q)Re Np7)Is+(:5)Zress)Pq"= i TruCPRDp?=EGet_JO ddB y3= r|el ApplicaT.Internal(xlDecimalSeparatorARdummyXIfnU, Do Whi@~ F0SMid, , 1)*+OC= *LooNpI?H< ROn Error Resume N5MA). dress,# > 0M ' formulza$j@n# @| jAI @:@o.' "'!") @ r"z ?@R2LeDftTj -AT& Rg)Len)A+`E?e(tm[% T$$$$OPP{," r ]&s>|." ?vUjU``O t`?o( newentrh!(l9Q0 AF!&!?q w0ofSCABoxC`traint_lpzwhich_onelf P0XiExit Forip Is_LorF e1i_c TrueL?tnp Not_ p> 3k RecordMacro basiccode:=gdelfuncv!addarg1:=!#Chr(3 4)xStylecheck')Fy(Fb:=spaves"12d >wt(z///7 /"/n/t/ce/& //!/(B3""`4#P4 {Owo. .Nooo?oooo oo_VoG !fixQ ?V ThelpsXOeOe$OeHeRemov?eItem Index:=which_one  ActiveWorkbook.Names.Add $:="'" & HSheetB$0"!solver_num", RefersTo:=ThisDialog>s("1d").ListBoxeConstraint_lCount, Visible@:=Falslast = sSR9 + 1lhsTrim(Str(theW))v))).Xxrelx,M,_rOXMi,&= xs AnCEnd Ifxit S ub m9error:CMsg excel4language4.Re _mDsgTex32, , Application .Pathhelpfile, 1830Dnd  a Pub Stc!H Cha_cq() Attribute.VB_ProcDataaInvoke _Funcr" \n14"C' bc a COn E! GoT o #Dim f Asteger, place*/_i] Sngc _tr__t?BC I"f> 0@enC0H??(F_8=P`'(, " <= ") N,=5g/=HE@ In>3?Yi)2)y8@gEEdiE?l@).CapurLeft 2")6 N 1 "="lbhRiDghLen) -t5- 2_K}DropDown`lOrs$1Array("_Og?WOObinO 0 A@_RAvek.2)0/-0000"f 0= 0Resume< N#@#NStylecheck75)).Areas.Ci> 1m-?-?-?-?-]2?-?-?IScre enUpdngjK= ?4.d 4b3;= .DropDown Os List`IndexAReferenceCxlAl>zG@ ?I Con`tFormulajL { bwZy)IsCel:l(/2])).`aS3sP# K@c"ccc1P'u d0$ d?K^PK1Truf Eg EPi.0e7be[OL O{__R2_l__.#{>c_H_n~GF0s0L0(V'|"=nrGet_nF(Len) - 1)@ {/!x0#H@&l $2;/ORDR,IK/KcFMy,(---D//?-?-%P?-?-)gDDt&? xtNot IsN`ric(E0u ( 120j middle`rel_i`$=XIndexcF ?k$~%JOn Error Resume N@ %ApveShe8et. $adja).Coua<> _&U>n #D8BA5), c@?%%%(, @23$5so4Ziabz@ ?? E_bP @O3 I!RYdr_X!N1gRG$LeCH) - 1@zJ , ?A15B _?Z } tI lchk^Deletenewentry!H0" dX&%]ex i1 To Trim(Str(ThisWorkbook.DialogS`SdB : 4_lbU)$ !6 <aZ.N(ii"or%d`,aS Item := TO/$, }:=' ue define Du$Ysac"v=o%}%" 1!%=s :="'10' 1"!Tnu m"`|sTo:=/( "+ , Visible:=E 0 j@? C?~t? 1   r_  :=? 6IsCell?GC_h=Rk4""?Q0(`0,?+9+*P0!//!O 0ELineD7dd14 oM^"gMPIScreenUpdng )XEo?o?o?o?0?n.?o?Push_scenario[?F?ata.VB_Invoke_Func = " \n14" ' user hits "save scenario" buttonLOn Error GoTo maine6actiont.Exit SPub /: MsgBox excel4language.Re("solver___msg").Text, 32, , Ap plicap.Path & helpfile, 1830`End ~ Pub Stc  Sr_OK(Op'al Name) AttriePro,cDc=ks@ OK in dialogW0 If adj).Count > TheG?@U_25,V5C*uYIf@*IsMissing(XR )ThisWork@book.DESheets("E _CK,Edite nkCaq'"%""M4a)MA3con*f@t2AveD.2s.Add W:= 7, Ch@`Cells:=nG, Locked:=False%fuuuJ4b#u#???? 'ub Constr@t_(* ' f`add- = ?or5lxfBeiFr d.c ns!946\d?Help1KM`?2ndd?UA5c FStoppEDDU+Dw # i s tupteZot6_/A|j||||z9Load_PMd_?za\l  9?mode~lPz9gOl99"SQMq\jooj4d7/= 1) The fFalsEfGet_name(as~ng) ' ' trans@lates  reference into 6s if is defined, orwiseturns address Dim SnS,, comb@urtshheetwA @\erAIntegercandid. FwGoTo ma{DNa@Styleck(Se-= Ap&p@onnvertFormula , xlA1AR1C1@d9In<@, "!")0CGET.DEF(" & Chr(34)@GQI% AFrn(al(xlListSep@arator"BOCUMENT0(1))C*TypeNExec Ex@4Macro(Dk)) <> "p" 0@Gb|= R[` idaj R,'Q,@N,Righ"t5Len) - 9) _&!f5n5l5N)DiEP1)Za.- 2MVSSo)%+K{ez pf0cIw veS.A\f'a@{ Each w= Workdcpw.Sec F @?`XE> C sesF A!*&vA?UBFs/q/E6L`Axit P ("() '`<50#{m hk#h CozooZx:kV>d60sJE 1mByValUk,Bz ?D'\ cAfreportD/R j9pw, rowiLong,l"^}rol, iOTCQ2.E.QC?)).D(-:=saves?kF`-C) P +{'& i7= PRo2wcoColum@gp>@'`=- 1 1`ep -61 ` bs($i,T!).-ue?A 1 al?pE2od)Q 4 1`"  -P)   d p" Ap73 s0BQVf6&zWng-A O-M-XTMsgBox el uageB.-"sol_pI_msg").T@, 32, B,jPath helpfile, 183YEnd End FunctionH   solver_opxs2(MaxTime, maxiter, P recisx, tol, assBu@showBScaling, Estimates, deriv, search , ConfgencZNonNegative) Attribute .VB_ProcData Invoke_ = " \n14"' changes argAnt or 0for mOn Err GoTborineIf T2" The PSO(CDbl)y100 * 0Elsea ?)K{/)B?0 1If1E)Hmai:MsgBox excel4l@~uage.R("?u_msg").Text, 32, , Applicon.Path & helpfil1830O C:d-%\LW, :<#]/6L,\q:d%LW, t"$ t | (&lv*F' , /t6 L,):d-%\LW,&%\(6L, v.#0J):d-%\LW,&%\(6L,Yt'%:d-%\LW, F%"$ ta t6 L,\Eq:d%LW, t"$ t | (&lv*F' , /t6 L,):d-%\LW,&%\(6L,ot'%:d%\LW, F%"$ ta +``av"pz)t`6 L, kzjt'%:d%\LW, F%"$ ta +``a )t`6 L,\P":<#%:d"%\L 5L @t'%:d%\LW, F%"$ ta +`` `F%:<"%\ )t`6L, @<%t'%:d%\LW, F%"$ ta +``+ `F%:"%\ )t`6L, \ ^q:d%LW, t"$ t | (&lv*F' , /t6 L,x:<-%`:d%t"$ t d `LW,&%:%"$  d ()t`6L,(\Dt`L,H z$ @ $ P  c\ 5\ $ \@  $ @ $ pK ]:l%\W$%D:H%X"$ X d DW4 )XD6\4$CX'4% F\%"$ Xa$"_X6\4$DX'4% F\%"$ Xa$"_X6\4$N:H%D:l%X"$ X d D\W4Uz)XD6\4_il%_DH%X"$ XX\_ui%_D%D"$ XD44%\%"$ )XD6\4x @X "$ X4%:H%:l%D"$ D d \ )XD6\44D:l%X"$ X d D)XDq:l%\W4 X"$ X | (&lv*F'$ 4 /X6 \4$$ 0 XD\4$@ !$ $$K#K"'%:%:%"$  d W F%"$ av"u0'4%:t%:%"$  d dWT FD%"$ 0a v"rU~} 3% ( I a 19a 1y )9h9Y1 pQ Aya)iI9y 9 )!Y!!!!"I"y"""#I### $A$y$Q)$$)%p i%%%%)&A&&& 'I''' (I((( )I)xy)|))9*y***+Y++P + ,i,, -i---).Y.y../1/// 0i000)1Y1I 111!2Q2222!3A3a33 4I4444 5Y555 6Q6 66)7q770q3/ 89888)9y999:Q:y::;Y;; <1<x|AI@ }AY}}}iDA~ !BaBI~~B~9q]J{www{sgkSO AMaM)4IFF!GIEaGqG HIHHHI1IqIF AiEB!iMI Wi @u z% x"$ x  xt'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%t"$  lt*Fd%x"$ x /tx<6@4$tdTD4$tdTDW@$ "txdTD4$tdTD4$t,% x"$ x  xt'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%t"$  lt*Fd%x"$ x /tx(6@4$tdTD4$tdTD,$ "txdTD4$tdTD4$t< z $ < z $ H z$ @ $ \ W:T%d:h%x"$ x d dDW$(4]/)xd6D$\% x"$ x  xq:h%DW$ x"$ x | (&lv*F' $ /x6 D$ #  $ ,xdD$ K ] -`:d%t"$ t d Q`\t.) 06dTD4 % "$   :%W:%dWT "$  | (*l v*F '4 :@uD:t@TD / 6dTD4 pz'%:%:%"$  d W F%"$ av")6 :%:%"$  d W : @uD%(%'T%:%:t%"$  d W Fd%"$ D+00 4`F %:%:%"$  d  )06dTD4 j:%:%"$  d W :(t]/)6\/:%W:@:%Wd:tBT"D D4:%:%"$  d  W " `1,)6dTD 4tw:%:%"$  d W " (]/)6\:%W:@:%Wd:tBT"D D4:%:%"$  d  W " `1,)6dTD 4r:%W:@:%Wd:tBT"D D4:%:%"$  d  W  " t`1,)6dTD 4t1 '%l,F%"$   5{'%:%:%"$  d W F%"$ Q[p`)6rl" kz v.#= uaW'%v.F%"$ a`# *#h*F%`2 h6 ua W'%v.F%"$ a`# *#h*F%`2 h6 J:n%:%"$  d W )5B:] %"$   <5\T J %"$   050(]<\T 0":J %"$   05 `h'%v.F%"$ a`# *#hh*F%`2 h6P" kz1 v$#=, W'%v$F%"$ a`# *#h*F%`2 h6P"kzumN:1%:0%"$  d W `1p)6lpF %"$   :t2%:0%"$  d W `1p)6 lpF %"$   :t8%:0%"$  d W `1p)6 lpF %"$   :t<%:0%"$  d W (dKFdT`1p)6 dTlpF %"$   :tJ%:0%"$  d KWL]/KFdT`1p)6 dTlpF %"$   :tN%:0%"$  d KWL]/KFdT`1p)6 dTlpF %"$   :tX%:0%"$  d KWL]/KFdT`1p)6 dTZ:~%:0%"$  d `WLH]/)6\RlpF %"$   :`1p6CRlpF %"$   :`1p6Z:%:0%"$  d `WLH]/)6\RlpF %"$   :`1p6HRlpF %"$   :`1p6Z:%:0%"$  d `WLH]/)6\RlpF %"$   :`1p6MRlpF %"$   :`1p6lpF %"$   :t:%:0%"$  d W `1p)6 lpF %"$   :t\%:0%"$  d KWL]/KFdT`1p)6 dTB:] %"$   <5\MlpF %"$   050(]<\p0"OMlpF %"$   05d "$ H ld` "$ H l`&\ "$ H l\ )C#lp*# *F%`/ 5h#lp*# *F%`/ 5P"bkz# *F%"$ @G'KF E`1T/ 6 bkz# *F%"$ @G'KF E`1P/ 6 lPCX lX0CHbkz# *F%"$ @G'KF E`1L/ 6   lX0/hCHbkz# *F%"$ @G'KF E`1L/ 6   lX0CHbkz# *F%"$ @G'KF E`1L/ 6   lX0 hCHK'%lTF%"$ a`# *#h*1L2 h6/Xd "$ H ld` "$ H l`&\ "$ H l\ )lP=lP=$o'%lTF%"$ a`# *#h*#TlH*#P*#LlL*#H*1p2 hTPLH6 lP0K'%lTF%"$ a`# *#h*1p2 h6K'%lTF%"$ a`# *#h*1p2 h6lpF%`N" lP=K'%lTF%"$ a`# lH*#hlL*1p2 h6='%lTF%"$ av"6B:] %"$   <5\[lpi00(]<\[Lp0" %"$   `# O/ 5lpi0S '%'%%lpF%"$  p `1p6B:] %"$   <5\MlpF %"$   050(]<\p0"OMlpF %"$   05?hlp*F%`5B:] %"$   <5\MlpF %"$   050(]<\p0"OMlpF %"$   05ghlp*F%`5L"'%lTF%"$ a`# *#h*#T'%lTF%"$ a`#P*#L*1p2 hTPL)6='%lTF%"$ av"6%!B:] %"$   <5\lpi00(]<\Lp0" %"$   `# O/ 5lpi0+S '%'%%lpF%"$  p `1p6B:] %"$   <5\!MlpF %"$   050(]<\!p0"OMlpF %"$   05 hlp*F%`5J"B:] %"$   <5\/"MlpF %"$   050(]<\/"p0"OMlpF %"$   05!hlp*F%`5 kzpzkzut"l" `sl"8'% F%"$ 68'% F%"$ 6% "$   q:%W "$  | (*l v*F'  / 6 q:%W "$  | (&l v*F'  / 6 4$\#DXplH,PD0LTp`X hTPLH0dTD4 tTK -d:h%x"$ x d Qd`x4:h%PW0%`W@ 6P@0P @x "$ x@%:h%`P x6P@ ` `q:h%PW@, x"$ x | (&l,v*F'0 @ /,x6 P@0T(`,,xdP@04KZ:T"%d:h%x"$ x d dDW4 `#0_/0)xd6D4#_Mh@ #0_/0#_ #$_#0Kz0x'D%_Fh%"$ xa4\%dd H%>0F],"$ @,W &<)xd,6D4 \q:h'%DW40 x"$ x | (&l0v*F ' 4 /0x6 D4 x:T"%d:h%x"$ x d dDW4&%:%,"$ , d ()xd,6D4Cx'D%_Fh%"$ xa4v"x6D4x:T"%d:h%x"$ x d dDW4&%:%,"$ , d ()xd,6D4KYx'D%_Fh%"$ xa48)ddav"_)xd6D4__c_ F_iT%x'D%_Fh%"$ xa48)dd+,,a `F * t%"$   `#0_ /0)xd,6D4 v$_iT%x'D%_Fh%"$ xa48)dd+,,a `#0*F %"$   `$/0)xd,6D4 _dW<_ J_ Mh@D , D`#0_ /05D'v$J$Mh@D , D`$5DQ_ F%:T"%d:h%x"$ x d dD)xd5Dq:h%DW40 x"$ x | (&l0v*F ' 4 /0x6 D4 4$ D0xd,D4  K0Z:T-%d:h%x"$ x d dDW4 `#0_/0)xd6D42, x"$ x  l,x#_Mh@ #0_/0 #._#0Kx'D%_Fh%"$ xa4v"0d'%_FT%"$ da \% H%>0F]"$ @W&<)xd6 D4 \q:h/%DW40 x"$ x | (&l0v*F ' 4 /0x6 D4 x:T-%d:h%x"$ x d dDW4&%:%"$  d ()xd6D4 #K0<x'D%_Fh%"$ xa4`.x6D4].Mh@D *D%:-%d:T%x"$ x d d4)xd64Dq:h%DW40 x"$ x | (&l0v*F ' 4 /0x6 D4 $0 @ 0xdD4 K>4d:h0%x"$ x d d)xdq:h%TW@P x"$ x | (&lPv*F '0 @ /Px6 T@0 |$> ,PxdT@0 K-T:X0%h"$ h d QTPh+:X1%P@W0 H_6@0+:X2%P@W0 H_ 6@0 c %:X3%P@455@'___+):X1%P@W0&%P(6@0!f %:X3%P@455@ fXl'_ _ _ ):X2%P@W0&%P(6@0!f %:X3%P@455@ fXl_q:X6%@W0 h"$ h | (&lv*F' 0 /h6 @0 ):X1%P@W0&%P(6@0!f %:X3%P@455@ fXl_ jq:X7%@W0 h"$ h | (&lv*F' 0 /h6 @0 ):X2%P@W0&%P(6@0!f %:X3%P@455@ fXlM:X8%P@W0 H: 8%P W H6@0 q:X9%@W0 h"$ h | (&lv*F' 0 /h6 @0 ):X8%P@W0&%P(6@0!f %:X3%P@455@ fXlM:X:%P@W0 H: :%P W H6@0 q:X;%@W0 h"$ h | (&lv*F' 0 /h6 @0 ):X:%P@W0&%P(6@0!f %:X3%P@455@ fXl.:X<%P@W0 : #]/ 6@0\(F0%:X<%P@ 6@0M:X<%P@W0 H: <%P W Hd6@0 q:X=%@W0 h"$ h | (&lv*F' 0 /h6 @0 ):X<%P@W0&%P(6@0!f %:X3%P@455@ fXl cXl >m:X?%@W0: @ :A%W:B`#_(/6@0 ~_(_#*#C*F0:XD%@W : B_ k`#_(26 @0 :F%h"$ @hG_(C*F0:XH%@W : B'KF Et`#_(/h6@0 t_(C*F0:XI%@W : B:J%PKWL|]/`#_(/6@0 _(C*F0:XM%@W : B:N%PKWL|]/`#_(/6@0 d_(C*F0:XP%@W : BuOD`#_(/6 @0 d_(C*F0:XR%@W : BuQD`#_(/6 @0 d_(C*F0:XT%@W : BuSD`#_(/6 @0 :U%h"$ @hG_(C*F0:XV%@W : B'KF EHdFtd`#_(/h6@0 td_(C*F0:XW%@W : B:X%PKWL|]/`#_(/6@0 :Y%h"$ @hG_(C*F0:XZ%@W : B'KF Et`#_(/h6@0 t_(C*F0:X[%@W : B:\%PKWL|]/`#_(/6@0 6 '@%_(FX%h"$ h  h5@ P #q:X%@W0 h"$ h | (&lv*F' 0 /h6 @0 , lPLhT@0 tdD u'-d:h0%x"$ x d Qd`x(dF@%:h1%`P 6P@(dF@%:h2%`P 6P@/??>F@%:h8%`P 6P@(F@%:h<%`P 6P@/MbP?F@%:h:%`P 6P@%0%:hJ%`PKL5P%0%:h\%`PKL5P%0%:h%`PKL5P%0%:hX%`PKL5P%0%:h~%`P`L5P%0%:h%`P`L5P%0%:h%`P`L5P ` #K-d:h0%x"$ x d Qd,xi:h%x"$ @xPG'PKF@ E %:01%, x6 P@ i:h%x"$ @xPG'PKF@ E %:02%, x6 P@ i:hF%x"$ @xPG'PKF@ E %:08%, x6 P@ x:hU%x"$ @xPG'PKF@ E HdF%:0<%, x6P@ /MbP?F@%:h:%,P 6P@i:hY%x"$ @xPG'PKF@ E %:0:%, x6 P@ ::h%x"$ @xPGK#0/x5P%0%:hJ%,PKL5P/%0%:hJ%,PKL5P::h%x"$ @xPGK#=/x5P%0%:h%,PKL5P%0%:h\%,PKL5P::h%x"$ @xPGK#0/x5P%0%:hN%,PKL5PE%0%:hN%,PKL5P::h%x"$ @xPGK#0/x5P%0%:hX%,PKL5P%0%:hX%,PKL5P::h %x"$ @xPGK#0/x5PY%0%:h~%,P`L5P%0%:h %,P`L5P%0%:h~%,P`L5P%0%:h %,P`L5P::h %x"$ @xPGK#0/x5P.%0%:h%,P`L5P%0%:h %,P`L5Pz%0%:h%,P`L5P%0%:h %,P`L5P::h %x"$ @xPGK#0/x5P %0%:h%,P`L5P%0%:h%,P`L5PO %0%:h%,P`L5P%0%:h%,P`L5PKm , #q:h%PW@ x"$ x | (&lv*F ' @ /x6 P@   ,m `,0 xdP@ K6  l\z:l%\WDT X"$ X | (&lTv*F$'4!D^/TX6 \D4$K '4%:l%\WD%X"$ X  X6\D4% X"$ X  X-:l%X"$ X d QX":#%:l-%\5\":#%:l"%\ 5\:l%\5\%%:l_%\`L5\(FD%:l%\6\D!f%:l%\5\ -:l0%X"$ X d QX(dFD%:l1%\ 6\D(dFD%:l2%\ 6\D/??>FD%:l8%\ 6\D(FD%:l<%\ 6\D/MbP?FD%:l:%\ 6\D%%:lJ%\KL5\%%:l\%\KL5\%%:l%\KL5\%%:lX%\KL5\%%:l~%\`L5\%%:l%\`L5\%%:l%\`L5\ K >2:li%X"$ @X\GeX5\2:ld%X"$ @X\GeX5\!cX"$ @X&X:lfX"$ @XW\&D:f4:o$%:%:k%"$  d W%f%"$ )X6 \D4$!X"$ @X&X  l\1x:-%:l%X"$ X d \WD&%:%"$  d ()X6\D% X"$ X  Xq:l%\WDT X"$ X | (&lTv*F$'4 D /TX6 \D4$0,68 TX\D4$$K[zaJf4%:T%d:h%x"$ x d dD)xd5Dq:h%DW 0 x"$ x | (&l0v*F'  /0x6 D $[ ,0xdD $K[zaJf4%:T%d:h%x"$ x d dD)xd5Dq:h%DW 0 x"$ x | (&l0v*F'  /0x6 D $[ ,0xdD LKzaIc4%:T%d:h%x"$ x d dD)xd5Dx:T%d:h%x"$ x d dDW&%,:4%0"$ 0 d ,()xd0,6Dq:h%DW x"$ x | (&lv*F'  /x6 DL$ 4 xd0,D@ $ d K% d"$ d  dpz0d'D%v$FT%"$ Qd[@h5Dr<kzvkT%hL kzpz hs?@ABCDEFGH0JKLMNOPQRSTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~xd6D4"_d&"_d_^ _`"_dy"_d_^ _`"_d_^ _`x_^_dMh@D , D4 4%: %d:T%x"$ x d d )xd6D4_dJ_^_dMh@D :ThD4 4%:%d: %x"$ x d d )xd6D4:h%DW:T%4W:l:hl: l Z%:%d:%x"$ x d d)xd6D4K( %:T%d:h%x"$ x d dD)xd5Dz:T%d:h%x"$ x d dDW :h: %4W/)xd6 D4\x _`z:T%d:h%x"$ x d dDW :h: %4W/)xd6 D4\ _`Q_`D %:T%d:h%x"$ x d dD)xd5D]:h%DW%d:T%x"$ x d dW4 )xd6D44d:h%x"$ x d d)xdXq:h%DW40 x"$ x | (&l0v*F' 4 /0x6 D4q:h%DW40 x"$ x | (&l0v*F' 4 /0x6 D4$] : 0xdD4_0KK:4#%:T%d:h%x"$ x d dD )xd5DK:4#%:T%d:h%x"$ x d dD )xd5D:h%DW:T%$W   :l :hl :4l    Z%:%d:%x"$ x d d)xd6D$K(4%:T%d:h%x"$ x d dD)xd5DK(4%:T%d:h%x"$ x d dD)xd5D]:h%DW%d:T%x"$ x d dW$ )xd6D$4d:h%x"$ x d d)xdq:h%DW$ x"$ x | (&lv*F' $ /x6 D$0$ : xdD$ x"x!K -T:X%h"$ h d QTPh.:X%P@W :0#]/6@ \ X\q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl:X%P@W :0(]<:%PW h"$ @hW&(]/|'lh6 @ \i X\Wq:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXlKth'%:X%P@W F%"$ ha8)TTav")hT6 @  X\q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXlK % h"$ h  h]h'%:X%P@W F%"$ hav"_hh6 @ *:X%P@W U_t6@ 2h h"$ h  lhhL:X%P@W h h"$ h  d T"$ T   '%%ldi0%lh %`"$ ` p %:%P )hT`6 @ 3:X%P@W F 6@ ]h'%:X%P@W F%"$ hav"_jh6 @ _j X\q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  h"_j_h_j X\q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  h1:X%P@W `# _l/ 6@ /_lMX@@ , @:0h]/ 5@\{K_lJ_lMX@@ @ * `# _l/ 6@ -_lMX@@ *@`# _l/ 5@_lJx1:X%P@W `# _l/ 6@ 3:X%P@W F 6@  X\ q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  hK^ :X%P@W F%h"$ h  h6@  :X%P@W :0% W/:%PWl :h:%W|/P@_t@:0%P :%W/':%PWp :%W`/P:@q : %P0W :h: %W/_t@:%P`:%pWP/@'0 64p`P@ l| p`0\ X\ q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  h :X%P@W h h"$ h  d T"$ T   '%%ldi0%lh %`"$ ` p `# _l/ )hT`6@ E:X%P@W   , :0h]/6@ \]1:X%P@W `# _l/ 6@ <:0h:X%P@W `# _l/ 6@ bh'%:X%P@W F%"$ ha`# _x/ h6 @ Zh'@%_xFX%"$ ha `F *`# _x/ h6@ _xJxGh'@%_xFX%"$ ha `# _x/ h6@ @_t@:X%P@ `# _|/ 6@ *:X%P@W U_6@ h_|F0]:X%@W /_|F]:%W/6@ \K:Xi%h"$ @h@GW &_xM0@ 1 `'%> F%"$ :i% "$ @ GW&'|%%"$ T'% %"$ Tav" ' %'0%'@%'P%'`%'p%'%'%'%'%'^%'%'%'0%'P%'`%'p%'%'%'%'%'%'%'%' %'@%'P%'l%Q[Q`["$ av") hT 6Lp`P0p`P@0 @ |lP@  X\6_|F0]:X%@W /6@ \q:X%@W  h"$ h | (&l v*F'  / h6 @ q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  hh_|/_lMX@@ , @:0h]/ 5@\e<_lJ_lMX@@ @`# _l/ 5@_lJxW X\ q:X%@W  h"$ h | (&l v*F'  / h6 @ ):X%P@W &%P(6@  fXl% h"$ h  huh D_x@*# _|*#@*#_l*#_2 _u_:0%T:X%h"$ h d T@W   U)hT6@ cl_F]_@:0%T:X%h"$ h d T@ c)hT6@ \___d/_-W_@:0%T:X%h"$ h d T@)hT5@e_@_@:0%T:X%h"$ h d T@)hT5@!ch"$ @h&hS:0%T:X%h"$ h d T@W U_)hT6@ :Xfh"$ @hW@& :0f:o%:%`:k%T"$ T d `W%f0% "$  )hT` 6 @ :Xfh"$ @hW@& :0f:_D%hT'%_xM@ F%"$ Ta`# *F|%f0%`"$ `/ )hT`6@ |:Xfh"$ @hW@& :0f:_D%_@f%T"$ T)hT6 @ "_lMX@ F@ 5@ #_pK[_lFX%h"$ h@TTa `# _p/ )hT6@ _p#0q:Xfh"$ @hW@& :0f:_D%h_l*F%f%T"$ T)hT6 @ :Xfh"$ @hW@& :0f:_D%_p@f%T"$ T)hT6 @ :Xfh"$ @hW@& :0f:_D%h_l*F%f%T"$ T)hT6 @  cXl X\ ;_lFX"@ @ (0]/5@\ '`%:X%@W :0@:%W:B" | @h'P%_xM@ Fl%"$ h @`F " :0C:%W:Bp_D`:@CP: %0W:B" _lF" p%T"$ T  )hT6Bp`0Pp`@ lP@|   'P%:X%@W :0@:%W:B" | @h'P%_xM@ Fl%"$ h @`F " :0C:%W:Bp _D`:@CP: %0W:B" _lM@ "p p`%T"$ T  )hT6Dp`0Pp`P@ lP@| !h"$ @h&h Pq:X%@W  h"$ h | (&l v*F'  / h6 @  x!, lP2 hT` @ |lP@ p`P0p`P@0  KWc\L L5\R4D:l%H"$ H d D)HDq:l%\WL@ H"$ H | (&l@v*F '0 L /@H6 \L0 |$W ,@HD\L0 ,K5J:T%d:h%x"$ x d dDW4$)xd5D4$(h]/T$(]/$(]/\::T%d:h%x"$ x d dDW :h:%4W/:%:%"$  d W, :\h:|%lWLK( $4h 6S  @  P X `h Hp % >q %  - 08-@ X`h@Zp :  >  @ 5H  "`  x     >q   " & (  %0 @ H P >qX   "   &   &,@ >qh     2   -  ,( *hH  Ax &R "  ,a  '   0 8  %@ P &qX   ,U (E  & R #Bw  1h"8xHnR0@w  $3 $3( P$3`H5(_: 0 (8 H X2Y` 2Y2Y2Y2YP": 8b8b8bH8b8b\ P pxhb<@HLPXp|8^(k@(VV?l@> L LLLL" 6@P  h ( @@ x P @ P E :&@  Z @_ Z_ ]X(  ` 8>6@` l @ \ @0 L @ H @D @H 4 @x $ @x  @  : PN@` @ @  @_ ( _  @ @ @ @ @ @  @ @t @d ( ,2N\68:&>P@Z@` Z @\_ Zx(@8Z P@X 8@H `85@D Dxxh80PN8>@z `@px (`@8h @ X @PH @8 @( @ $ @ @ @ @  @ (6:2Pe@ @x 8q@_ xq,2xt@  ,2\@ @p @8 @ @ @p @` Z@\ @X_ `Z >P@ZD@V p@T @P H8P x`PN8>@z  @x 8@Hh @0X @`H @08 @( @H$ @ @ @ @x @H 6:x @ ,N@ `@p_ ( @  ,N2@P @ @ @ @ Z@p @` \:>T@\ @X pY@T_  YZH@D @(4 @@$ @X @p @ @ @ @ @ @@ @ @ @t @d @T @D @04 @H$ @` @x @ 06@ZV@ 8>6@x @ph @(X @T @@D @X4 @$ @ @ pX@8>6F(@ l @\ @0 X @T @D @4 @ $ @ @ @ H!0!!!"8>6@!l @`!\ @!X @T @x!D @!4 @!$ @! @ @ " @H" 6NF(@ @ H  ME  " (8 @ `<N4JH $34I$34I X$3`>k >k>k>kX>k>k>khX  >k  (5HX(T`: **:<E02Hh/p  5,a ^`:h0lx0y(\([(a(([Px5:  fh p J &Z(_2w0BhB*M ( 0X@ 4h  .l 0ZDt@L Dt(Y( P X `Xp 4h   .l  *H@ Dtp L  !Dt!(YX! ! ! !X! !4h" 8" .l@" 0Zp"Dt"L" 8#Dt@#(Y# # B# $ ,>$ .l8$ Dth$ (Y$ B$  % ,>(% .lX% Dt% (Y% B%@&H&4P& 'h&5x& (& %&&&>q&&',O' 8'@'H' $P'`'h'>qp'''' "' 8'(>q(5P( (`( %p( (( (((>q((( ") )()&0) X)x)@) >q) ** *&,(*>qP*** -* ,*>* A+&R +"H+ X+,a`+ '+ +++ %++&q+, (, ,,U0,(E`, &,R, #,Bw, 1-.-/0-0H-nX-R-@w . `.2Y.2Y.2Y.2Y(/2Y`/ /2Y/2Y/2Y02YP02Y02Y02Y02Y018lh112Y12Y18l2P2 X28bx2 28b28b28b038bh3 3 8b3 8b3 8b 4 8bX4 8b4 8b4 8b5 8b85 \p55 8b5 8b6 \H6668b66 6 757,a(7X7 ^p77:7*c7*p8"XH8"Rp8:8"R8 9 :9 :P9 :9999 9:(: f@:: : J:; &Z;@;"VH;,np;<;<;B <<h< < B< B= BH===4= '=5= (= %==>>q>H>P>,OX> >>> $>>>>q>??? "?  ?@? H?h???@? >q@ @@H@P@&,X@>q@@@ @@2@A - A ,@A>`A AA&RA"A A,aA 'B (B8B@B %HBXB&q`BBB,UB(EB !B &CRC #(CBw8C 1C.C/C0CnCRHD@wD D2YD2Y0E2YhE2YE":E F2Y F2YXF2YF2YF@oGE@G2Y`G2YG2YG2YH@o@HEH2YH2YH2YI2YHI@oI I II5I(TI: J0J (8J HJ2YXJ>JJ*J*JEK?(K@K HK #hK xKFlK5K,aK:LL X0LL*cL*pL"XL"RM5@MNvPMNvMB]M8N %@N&PNxN %NKN N ;NN NNFN 0O N@O "R`O JO "ROO 8bO 8bPHPB]PP5PP %P&PP %PKQ Q(Q 0Q ;@QXQ `QhQpQUxQFQ Q NQ "RR J8R "RXRR 8bR 8bRRS #S5 S0S58SJHSJSS2S TR TxT TRTT0dT4 U48U4PU 'hU5xU !U (U %UUU>qUVV,OV HVPVXV $`VpVxV>qVVVV "V (VW>qW5PWJ`WJW XRXhX pXRXX !X (X %Y (Y Y0Y8Y>q@YYY Yx" prepare and display finish dialogv@ZPh " solver_msg_26 8%:!f solver_msg_27 8%:!f solver_msg_28 8%:!fDReports Finish_dialog %0%2(X  Keep_solution Finish_dialog %0%(%2Reports Finish_dialog %0%2(5b HQ solver_msg_29 8%:!f'aReports Finish_dialog %0%2(er hHQ solver_msg_30 8%:!f'Reports Finish_dialog %0%2(HHQ solver_msg_31 8%:!f' 8Reports Finish_dialog %0%2(mum_HQ solver_msg_32 8%:!f'HQ solver_msg_33 8%:!f'hHQ solver_msg_34 8%:!f'RHQ solver_msg_35 8%:!f'!<HQ solver_msg_37 8%:!f'9HQ solver_msg_38 8%:!f' HQ solver_msg_39 8%:!f' HQ solver_msg_40 8%:!f' HQ solver_msg_41 8%:!f' HQ solver_msg_42 8%:!f' HQ solver_msg_43 8%:!f'HQsolver_msg_29a 8%:!f'Reports Finish_dialog %0%2(P solver_msg_44 8%:!f'k  Final_message Finish_dialog %0%(fA@'\xfinish'( ( Finish_dialog %0B@ (scenario Scenario_nameScenario_dialog %0%H(Jscenario_dialog %0B@h (finish Reports Finish_dialog %0%2!''   solver_rel $P$N %U $U 'rh $$ ( solver_msg_77 8%:!f !< >&A@6hX ($A@h($ A@h$ A@hh Keep_solution Finish_dialog %0%! 3 Application.Run ("'Excel4Functions'!Cleanup") Else7 Application.Run ("'Excel4Functions'!RestoreCall")'  $: $& (  'huvsolver_err_msg 8%:!f !< >&A@6dl user clicks ok on finish dialogvP ('u0v(solver_err_msg 8%:!f !< >&A@6dl creates answer reportvZhZ(@ZXp solver_tbl %:!$ solver_msg_47 8%:!f !< >&A@6ua' solver_opt %U $$:!'vx solver_tbl %:!|'r solver_tbl %:!~'t solver_adj %!$:!V' r t %!'  r t %! '  '  solver_adj %!$: ! +  'Hh@ ((anscount$!U $' v  ' anscount  !B@ solver_msg_48 8%:!f ( !' !B@ (" solver_msg_50 8%:!f  $P$N ( !'? $A$1:$A$3$:($ $A$1:$A$3$:!&(( solver_msg_49 8%:!f  !*  solver_msg_50 8%:!f$( solver_msg_51 8%:!f [ !] $( solver_msg_52 8%:!f  ,$( target section  solver_msg_53 8%:!f' b solver_msg_54 8%:!f' b solver_msg_55 8%:!f'h solver_msg_56 8%:!f ( )$(' $B@ solver_opt %U $' $B@.H 2 (0 ' solver_msg_57 8%:!f$(a' solver_msg_58 8%:!f$( solver_msg_59 8%:!f$( solver_msg_60 8%:!f$( solver_msg_61 8%:!f$(x $B$7:$E$8$:B@4hH adjustables section solver_msg_62 8%:!f  $( solver_msg_63 8%:!f  $( solver_msg_64 8%:!f  $( solver_msg_65 8%:!f  $( solver_msg_66 8%:!f  $( $B$  $P$N:$E$   $P$N$:B@4 constraint section  solver_msg_67 8%:!f   $(h8  solver_msg_68 8%:!f   $( solver_msg_69 8%:!f   $( solver_msg_70 8%:!f   $( solver_msg_71 8%:!f   $( solver_msg_72 8%:!f   $( solver_msg_73 8%:!f   $( $B$   $P$N:$G$    $P$N$:B@4a8  solver_msg_57 8%:!f   $(h h  fill in target cell $B@ solver_opt %U $'N $B@  \Z N$:%X$( N$:!X $$( $B@ 6$( $( : $D$8:$E$8$:(8h   (< fill in vars' $B@  solver_adj %!$:   solver_msg_48 8%:!f d    % done. (h $B@ \Z %X   $( !X $   $( $&   $( $>   $(8 $   $( $>   $(8  ' $B@` $B@ fill in constraints     solver_msg_48 8%:!f d      % done. (h \ = r   t %!   %$'a( r   t %!'h     $(  $    $( $P $%:!    $( $P $%:!8    $(8 r   t %!HQ \ <== r   t %!   %$'a`<= r   t %!'h       $( r   t %! solver_msg_74 8%:!f    $( r   t %!    $(a  solver_msg_75 8%:!f    $(    $(hHQ \ == r   t %!   %$'a0= r   t %!'h      $(    %! solver_msg_74 8%:!f    $( r   t %!    $(a solver_msg_75 8%:!f    $(    $(hxHQ \ >== r   t %!   %$'a>= r   t %!'h      $( r   t %! solver_msg_74 8%:!f    $( r   t %!    $(a solver_msg_75 8%:!f    $(    $(hH $P $%:!8    $(8HQ=solver_msg_int 8%:!f'      $( solver_msg_75 8%:!f    $(    $( $P $%:!8    $(8HQ=solver_msg_bin 8%:!f'      $( solver_msg_75 8%:!f    $(    $( $P $%:!8    $(8k##B:G$@B@B (< $B@ ( (uP#vH#solver_err_msg 8%:!f !< >&A@6d#"anscount !B@' "." ZA@Da"solver_err_msg 8%:!f !< >&A@6dH"h@"l8"1 user escaped out of answer or sensitivity reportv! solver_msg_76 8%:!f !< >&A@6 $B@ ( ( F (0Cancel'(uX!vP!solver_err_msg 8%:!f !< >&A@6d!l!` create sensitivity reportv Z(Z`x   solver_rel $P$N %U $U solver_msg_77 8%:!f !< >&A@6uh solver_tbl %:!$ solver_msg_47 8%:!f !< >&A@6uha` solver_tbl %:!|'r solver_tbl %:!~'t r t %!' r t %!'  r t %! '  '  solver_adj %!$: ! +  '@h8 ( sencount$!U $'H. 2 (0 H 'Hsencount H !B@ solver_msg_78 8%:!f ( !' !B@ (" solver_msg_79 8%:!f  H$P$N ( !' $A$1:$A$3$:B@J? ($ !&(( solver_msg_49 8%:!f  !*  solver_msg_79 8%:!f$( solver_msg_51 8%:!f [ !] $( solver_msg_52 8%:!f  ,$( adjustables section solver_msg_80 8%:!f$( solver_msg_81 8%:!f$( solver_msg_82 8%:!f$( solver_msg_83 8%:!f$( solver_msg_84 8%:!f$( 2 solver_msg_85 8%:!f$( solver_msg_86 8%:!f$( solver_msg_87 8%:!f$( solver_msg_88 8%:!f$( solver_msg_89 8%:!f$( solver_msg_90 8%:!f$( solver_msg_91 8%:!f$( solver_msg_92 8%:!f$( $B$7:$H$  $P$N$:B@4aX solver_msg_93 8%:!f$( solver_msg_94 8%:!f$( $B$7:$E$  $P$N$:B@4h constraint section solver_msg_95 8%:!f  $(  solver_msg_96 8%:!f  $( solver_msg_97 8%:!f  $( solver_msg_98 8%:!f  $( solver_msg_99 8%:!f  $( 2solver_msg_100 8%:!f  $(solver_msg_101 8%:!f  $(solver_msg_102 8%:!f  $(solver_msg_103 8%:!f  $(solver_msg_104 8%:!f  $(solver_msg_105 8%:!f  $(solver_msg_106 8%:!f  $(solver_msg_107 8%:!f  $( $B$  $P$N:$H$   $P$N$:B@4a(solver_msg_108 8%:!f  $(solver_msg_109 8%:!f  $( $B$  $P$N:$E$   $P$N$:B@4hPaHsolver_msg_110 8%:!f  $(h fill in vars' $B@  solver_adj %!$:   solver_msg_78 8%:!f d    % done. (h( $B@ \Z %X  $( !X $  $( $  $( $>  $(8 r  t %!  $( $>  $(8 2 r  t %!  $( r  t %!  $( r  t %!  $(h(  ' fill in constraints     solver_msg_78 8%:!f d      % done. (hP \ = r   t %!   %$'a r   t %!'h    $(  $   $( $P $%:!   $( $P $%:!8   $(8 r   t %   $( $P $%:!8   $(8 2 r   t %   $( r   t %   $( r   t %   $(hh ` B:H$@B@B (< $B@ ( (u v solver_err_msg 8%:!f !< >&A@6d  sencount !B@'Hh .` ZA@Da@ solver_err_msg 8%:!f !< >&A@6d h l  create limits reportv ZH`xZZ 8P   solver_rel $P$N %U $U solver_msg_77 8%:!f !< >&A@6u h solver_tbl %:!$ solver_msg_47 8%:!f !< >&A@6u8 a0 ' solver_opt %U $$:!'v solver_tbl %:!|'r solver_tbl %:!~'t r t %!' r t %!'  r t %! '  '  solver_adj %!$: ! +  'h (limcount$!U $'Jvp J 'Jlimcount J !B@solver_msg_111 8%:!f (  ( !' !B@ ("solver_msg_112 8%:!f  J$P$N ( !' $A$1:$A$3$:B@J? ($ !&(( solver_msg_49 8%:!f  !* solver_msg_112 8%:!f$( solver_msg_51 8%:!f [ !] $( solver_msg_52 8%:!f  ,$( target sectionsolver_msg_113 8%:!f$(solver_msg_114 8%:!f$(solver_msg_115 8%:!f$(solver_msg_116 8%:!f$( $B$6:$D$8$:B@4 adjustable sectionsolver_msg_117 8%:!f $(solver_msg_118 8%:!f $(solver_msg_119 8%:!f $(solver_msg_120 8%:!f $( $B$11:$D$   $P$N$:B@4? $($solver_msg_121 8%:!f $(solver_msg_122 8%:!f $(solver_msg_123 8%:!f $(solver_msg_124 8%:!f $( $F$11:$G$   $P$N$:B@4? $($solver_msg_125 8%:!f $(solver_msg_126 8%:!f $(solver_msg_127 8%:!f $(solver_msg_128 8%:!f $( $I$11:$J$   $P$N$:B@4 fill in target'N $B@ solver_opt %U $'N $B@.I 2 (0 Nsolver_msg_129 8%:!f$($(aPI \Z N$:%X$( N$:!X $$( $( :$(8hH adjustable section B@P'' ' !solver_sho !B@ $B@  solver_adj %!$: $B@  solver_msg_111 8%:!f d  % done. (hpG \Z %X  $( !X $  $( $  $( $>  $(8 $B@' ' !solver_adj= !X B@' ' !solver_opt= !X B@' ' !solver_typ B@E (R ! !SolveCall %'.E (R !X$:!'N N N$:!'La(E'LhEsolver_msg_112 8%:!f  J$P$N$B@  N  $( $>  $(8 L  $( $>  $(8a(Dsolver_msg_130 8%:!f  $(solver_msg_130 8%:!f  $(hC' ' !solver_typ B@ $B@PC (R ! !SolveCall %'.C (R !X$:!'N TV('LB N N$:!'LaB'LhB.B $ !X$:(solver_msg_112 8%:!f  J$P$N$B@  N  $( $>  $(8 L  $( $>  $(8axAsolver_msg_130 8%:!f  $(solver_msg_130 8%:!f  $(hA  ' B@P $B@@ $B@' !' !solver_typ  !B@' !' !solver_sho 6 !B@@ solver_opt %B@ N' !' !solver_opt= N !B@h? ' !' !solver_adj=  !B@h?Limits Report J$P$N$B@B:D$@B@BF:G$@B@BI:J$@B@B (< $B@  ( ( (u@>v8>solver_err_msg 8%:!f !< >&A@6d==limcount !B@'J=.= ZA@Va=solver_err_msg 8%:!f !< >&A@6d8=h0=l(=! user escaped out of limit reportv< solver_msg_76 8%:!f !< >&A@6 $B@' !' !solver_typ  !B@' !' !solver_sho 6 !B@ N' !' !solver_opt= N !B@h; ' !' !solver_adj=  !B@h ;  ( ( ( F (0Cancel'(u:v:solver_err_msg 8%:!f !< >&A@6dx:lp:h:Attribute VB_Name = "Solver3" Option ExplicitHPub, Static Sub Finish(), &.Pr@ocDataInvoke_Func \n14i ' prepare and display fZalog (Orror GoTo m0aineDim msg Asring, Uorts, no senseBoolean, iInteger, c"ThisWorkbook.Di=Sheets("k_d ").ListBoxe Rep3 o_&YArray(excel4language.Re("sE_Z_26T`ext,  798q@ButtonAAKeep_4uCValux(lOnWs@En abled@XFalseSele ct Caxanswer0 =R9a c},TruD,B&1l&30&?62?jW31?h"h63?+2*.4k3o5k4o6k5o7k!8kh9kl1_uK4 bjkW`L1UL1U29aD m(8 WKEXUOnBn4k0E~[# goCLab elL@yal_mess`u u#B i_ge0?= HdDoc acrD0 Ap.ScreenUpdng/  s ShowIfscenarioz"es?OFSc47Edi5n?Cap?%  If Loop UnxtilThs??#&ed0?+ pFi1 ?numv p CDbl(Mid(CStr(A"tve.q0)rel" & TrHim(i), 2)) > 3mV=@q2Exit  9}@N Vp6((2) Or 3j`..`1#Msg@ngI7'32, ,!4Pathhelpfile, 183` \ O= 01)Do_APAPNotVmS@itivitnyv? ?> 0Limits ;;?0?ffu' Run ("'E??Ss'!Cxup"ab.0RestoreCallR9:Each `c In #?7adj? c.oldvars(i i +  4)b8Sub : 0p?@I?000` 3 f_o2ksh`Knvoke_Func = " \n14" ' user clicks ok on finish dialogOn Error GoTo `maine8App|ation.ScreenU$pdngFalse'report_ge<-TruExit@ Sub ^:7MsgBox excel4language.Re("solver__msg").Text, 32, , Path & helpfile, 18300End ? PDubh StRc Do_Answer() Attribute .VB_ProcDataI' ates :a( DDim newobj As=RciInteger, c, rowind Long olF adju8stsHAconstr@x(bndI ,0count, thZei)SKn3op , @3_#rhs,?vars() Do?@Dshee2If Not IsNumeric( . tblValue) ThenC?_47ss? EF@{= ?Res5< N@F+ 7Mid(CY(ActiveS$.Namesf1")), 2)).f 7:QL=r*Row cCQColum0U= #  1).CShZ Cells(e+ 1M""c"`= d+j 2 Rea@6BZ$`+UAi1F@Each c Iny dj &a i) c >i @KIf?HBhand@= U$TE RefersToU1 ? FcGWorkbooka .Add :=""%", :=, Visib0le:=!tatusBar@,#;4ֆ8?re0memb@= \ !osJ>ow.DisplayGripg= Ao #7va ,50d t"& `Trim(F), ' ` !'$A$1:@3?Wid{= 1.5C .Font.Bold8 1~)rmulag9] yV`F C P`E@ 0 The 2 }12}9, 17End IfBObndsC3C2+C8!953970S+716G7j273m1>%oG+oRWpElse#^ `_o?v, ^5ko oi' fill in target lCWorksheets(remem8bervatDOn Error Resume NfoptAMid(CA eS! .Names?"))a.new? z308'Dddress(ReferenceStyle:=savesA) +n@(V , ?k( ,U*ol~d@` h"0$D$8Nu:= c # E#7Window.ScrollRo:w.7j'Kvarsci`1CK@ Each c In #7Hm@Q%7i Mopd 10+o7 Applica!r.StatusBarg4e{}Int(100 * (i / (v+yo0C% done."c!t7/P3{i,/c.A/./.?R3O/A/O._ '"(i sto0++sO, 2?Q/iP/ /UT 7it7A47 To('@T2?A 22]2&P<2 2+Eq)2t22 A>Z;0xlA1`ath\ringh?hContq(\"=<@rg.(r5=Vj/?Ca0se 2savyl{xlA1{@"="Mid(Application.Con@rt( ., xlR1C1A1), 2)K7PgO)8 Ku ru2s?Ts?`@ssA`s W0;Js3js^>sas*0?ssHdg'AA5s:sS 0`*_+~4tt :??:pt  8: {:mNumber qqatsWorkc`eme) $Stxcheck(()).YHBC4ZZ6@C6""int?4?3ROlOO pD"5"= IbinRg __y?=P,{;;r;;;?Selec+NColumns("B:GAutoFiTActiveWow.ScrollRow=E1  at4?StatusBar`Fa*creenUpd?= TruExit Sub mainerror:MsgBox***, 32, ,B Pathhelpfile,0 183Y  handgTVbook.Names.Add :="anscou`O, RefersTo:=0, Visible:=hdResume handleCancel: If Err = 18 ThenT`Quit_r eportLElsetMsgBox ex4language.Re("solver_err_msg").Text, 32, , Application.Path & help file,301cEnd  If Sub @ PubE  () Attribute .VB_Pro cDataInvoke_Func}" \n14"6' user escaped out of answ or sensitivity OnGoTo mainor*!_76Worksheets(remember).AcUat StatusB2aFawcr@eenUpdkn"g@JTruPEnDabKey xlDisDpa@!4on"ZExitp KO?EicDo_SzjTcDim i As Integer, c, r owindALodngolF a@djustsJnewvars()9Doi$; copnstr`Xb ndK @bcount the@iFS`raR!ccFfiC1 `g1?numCDbl(Mid(C%(ZeSA^.Namesrel"`Trim(!i), 2)) > 3k M_77?s ]AAAaN#Not IsNumeric(B&".tblVaplue)?#4?6vb Q=DWRow;cCVColumgZ pCellba).B%(\ + 12Ba= e+*q 2 Rener+`bceEach c Bb Ed ai)7cAi*+ccerqh0BvD= >=en"F RefmTo)A=BOT jxlorH{@ 1ue1wbookG .Add :=""", :=E, Visir:=_wRyg8  pm!? ?Q *dow.|playGridees oXo m 9d Z" [)*p*RD` q*Q$A$1:@3SelectCWidP.5Font.Bold%3<1?).7mula/,4.i(V0,0 7C C IO "51y[C,Q .]$3el2N`l' Ns$o{4^S6U80) 8B?R\3o RY7, 4__WQ-g>s _OG84z?P= -?wC 5 5J:  ? 6     V 7   <   9. 8 l_anguage.Re("solver_msg_91").Text Cells(8, 8).Formula = excel44l2 $B$7:$H$" & Trim(Str(8 + adjusts))@).Autokat frat:=12Else 7, 5+3r,$ 4rE6rnd Ifs' constraint section D10, 1+5 /Ifs > 0 TheD 226K371I)4v8`)9ZDlin1JZ@DF1+100 j8 )10NFC6.103N n}7.  r6 n4A _ mo 1HC))@"n1Rw] 3&\Km4& ?&c#& _?& &f/u(,N O^'11{GEAlfill OvharscliOWorksheets(rememberpovat` Each c In #'AeS.NamesvP1)c@Wi Mod s=|n Applicav.StatusBar zg 7#Q0Int(100 * (i / (N.!% done<." (new  cQic.Address(ReferenceStyle:=savesWjzy%nP(, + Jjs a d(i+ NuA = olvd3sO94.rowi0)i"cowd0Valu}9l   0 azg_]0_Za_]0W[ -?i1#Ny' B`C qPo)=g===& H==?>Sl>` $59GxlA^ th0;ring!Mid( Con`t3@("=HL0gI&F, xlR1C1qA1)AEw: 7dc(|o j6Vo`/M!M/M !MllkbWcheck(2 IeChestring)).NumberFormat  Cells(12 + ad justs$i, 5).ula = excel4sheet.`@rowind hcol*5)! eWorkcs(reme).Range(Stylecheck(tIf sol0ver_H-1 pThenJ}|6:|6|17171*818EyIfNNexColumns("B:H").AutoFiActiveWow.ScrollRowAaGCzBate Application.StatusBarFalscreenU$pd@ ng Tru Exit Sub main@error:MsgBoxDluage" P_msg9T?, 32, , I'Path & helpfile,` 1830O B Bhand@gDDIbook.Names.Add A:="sencount", RefersTo:=0, Visible:=A =Resum e l"eCan'xdEr)18KcQuit_repor9E- Z%|r_%%` "&  !O7 Pub@B Aic!: Do_LimiHts(@VAtbute.VB_ProcDataaInvoke_Func%" \n14"C5' H)O l On %or GoT o HDim i As Integer, newobjADo@1 Bc, Lopng, ? con`UAbnds %)`G freshVariantbvke  +aSb ) = @onum9 NCDbl@(Mid(C(-`S?_(nrel"iTrimr(i), 2)) > 3NRrw_77_xQxaQ gS@Not Isepric(tblValue)?#4?OI J>+= D/zE.= ` opt")).V"6S44;so0owF6Oe&'Smvu5E<)l ;mp1>=Br@+?(2Re1J 6obrjNuG!=p old End Ifc)"g"kkTr~uwaP? %P CV)0.Valx;m<> ""n@f5hXei k@=H.EE%Q limcoun>t?0p<= 2.<6?6S< u3{ T omL!O?O?O?L?L 8'WK+eet).Activate On Error Resume NextpApplication.DisplayAlerts @= Falsa`nswer, dRun(ThisWorkbook.Naa& "!SolveCall")GoTo handl"ncDel"TrunewvaRange(c.Address).Va lf hobj\CV(xl NAJIf sdr_opt <> "" The~nX1FFE 0)End If?o?m s(es`DDele2 *ive*!*"=1D+sIMq'adj1?0er_ 0*?%A$"LimiR`eportYC olumn6B:D5AutoFi#dfF:GvI:Jm#indow.ScrollRow`wvH o9sA= then0|8?StatusB2wY3)cre enUpdng0 {Exit Sub main e:3MsgBxox LP}._hh, 32, , IPath`!helpfile, 183u' ing?zFnj$0#pf @d?p018qQuit_&e{t Q q Pub+ (Attribute.VB_ProcDataInvoke_Func" \n14"!c' usescaped out of#rr7s$76$$$5r23]o%e?lCVj'go(oo o 3us?lZ ZZbZ3TEnaCaKey:xlAda@on/DH6 \L4$r _K:lJ%H"*$+ @,H\<'4\KFL$ :'%$"*$+ ,aB_)H6 \L4$K1-:lH%F\WLK"_,6\L,:lH%F\WLLU_06\Lh'4%:lM%H"*$+ @,H\<WLN%"*$+ ,a$v"_2)H6\L4$A_,@_0Dl%F\OWLU_46\LR_4D_,@_0Dl%F\OWL4U_66\L4"_2_L _a'4%:lM%H"*$+ @,H\<WLN%"*$+ ,Q[_H6\L4rr'_W\B__L5\___s&% H"*$+ ,H -HKr2q:lP%H"*$+ ,H\QaL'$LKF4 :U_8)H6 \L4$K1_8_8U:lP%_8@f%H"*$+ H,H  )HE:lR%\WL% H"*$+ ,H -H6\L&H"*$+ @,HW\N`SH5\R '$%'4%'L%'\%H"*$+ H,H   ( )H6\L4$#fl%H"*$+ D,H,Hw:lT%\WL:U4_8M@$ 8$ 9%H"*$+ @,HNH6 \L$41H"*$+ @,HW\N`#D_P/DH5\8?%H'\%:lV%"*$+ ,H,H5\Hc%H'\%:lV%"*$+ ,HaLW,`)H6\L:lX%\WL:U4D H"*$+ ,H d->DF$:U:T%W%(%(t%"*$+ X,dY)H6\L4$d:lZ%\WL:[4DH"*$+ H,H  >DF$:\vSF%(%(t%"*$+ X,Y)H6\L4$w:l^%\WL:U4$ ]$%(%(%H"*$+ X,HrU~}  3 O PQPPP aY.Q$!iEYQQQ1RyRR SQSS TQTTT)UqUU VQVyV(V19 W8)9AWW ,i,9 i- )W!Ih0 6 XIXi%XXA&XX/)YqYyYYZJaZZZZA[[ \Q\\\]1<]a]]]9^^^_I__ `Q`q```)aqaabIbbpY8Xbbc 1YC)& 4Acc4y..c_1//[ dQddddeYeee1fxyff gQgg hQhhhiaiii)jqjjkIkk lYlllImmmnanno!oYop oP pYpppIqqq!rqrrrIss tYttt1uuu v%)&% 'Yvv%v9wYwywqI@ K% :l%\W:L%<W:,%W Z%:%: %"$  d  )6 \<N,%:L%:l %"$  d \)5\Jf,%:L%:l %"$  d \ )5\ (l]/L\!3:l%\W<`#_/6\<Ic,%:L%:l %"$  d \ )5\!(l]/L\3:l%\W<`#_/6\<Ic,%:L%:l %"$  d \ )5\!(l]/L\C3:l%\W<`#_/6\<Ic,%:L%:l %"$  d \ )5\!(l]/L\3:l%\W<`#_/6\<!(l]/L\3:l%\W<`#_/6\<!(l]/L\3:l%\W<`#_/6\<!(l]/L\c3:l%\W<`#_/6\<!(l]/L\3:l%\W<`#_/6\<!(l]/L\3:l%\W<`#_/6\<!(l ]/L\;3:l%\W<`#_/6\<!(l ]/L\3:l%\W<`#_/6\<!(l ]/L\3:l%\W<`#_/6\<!(l ]/L\3:l %\W<`#_/6\<!(l ]/L\[3:l!%\W<`#_/6\<!(l]/L\3:l"%\W<`#_/6\<Ic,%:L%:l %"$  d \ )5\!3:l#%\W<`#_/6\<5Q_F,%:L$%:l %"$  d \%)5\ &z' )(% "*$+ , -4:l %"$  d .) v(/0uK:,0%:L1%:l2%"$  d \34)5\4:l5%"$  d .) v()0u'< S:L%:l %"$  d \ W<6_)6\< __u7c _Ml@\ 8:L;\< 9<%"*$+ @,<'KF :H6\< _ _d H_,(l%_\(L%_<'6\<\ % "*$+ , -q:l?%\W< "*$+ , |-(&lv=*F' < >/6 \<% "*$+ , -(l%_\\  @-(l%_\_L'<5\\  A-(l%_\_L'<5\\:  BZ:L%:l %"$  d \W<,]/)6\<\ _5'\%vCFl%"*$+ ,Q[_5\r "_vDkl%____s q:lE%\W< "*$+ , |-(&lv=*F' < >/6 \< 0% B \<K6% x"*$+ ,x -xz'q:hE%XWDT x"*$+ ,x |-(&lTv=*F$'4 D >/Tx6 XD4$x$6 (TxXD4$33K1,:lH%F\WL G6\Lq:lI%\WLYH6 \L4$ u_3:l`%\WL`#D_</D6\L, u_3:la%\WL`#D_</D6\L, u_, 3:lb%\WL`#D_</D6\L:lc%\WL:d4_<F$:e%(%(t%H"*$+ X,HYH6 \L4$0_@K5vSFl%H"*$+ ,H d f)H_:lJ%H"*$+ @,H\<'4\KFL$ :$`#D_@/DH6\L4$:_PFl%H"*$+ ,H d f)HK2( H"*$+ ,H <-H_@006 _DY:lg%\W4%(%(%H"*$+ X,HLYH6\L4  _DY:lh%\W4%(%(%H"*$+ X,HLYH6\L4Y:li%\W4%(%(%H"*$+ X,HLYH6\L4Y:lj%\W4%(%(%H"*$+ X,HLYH6\L4Y:lk%\W4%(%(%H"*$+ X,HLYH6\L4:( %H'\%:ll%"*$+ ,H rH5\b:lm%\W4%_DD%(%H"*$+ X,HLYH6\L4b:ln%\W4% _DD%(%H"*$+ X,HLYH6\L4b:lo%\W4% _DD%(%H"*$+ X,HLYH6\L4b:lp%\W4% _DD%(%H"*$+ X,HLYH6\L4b:lq%\W4% _DD%(%H"*$+ X,HLYH6\L4( %H'd%:r _DD\L 8L4 94$:s _D_2D 8 9%"*$+ ,H rH6\L4$d_2k:lt%\W4% _D_2D%(%H"*$+ X,HLYH6\L4_6Rk:lu%\W4% _D_2D%(%H"*$+ X,HLYH6\L4k:lv%\W4% _D_2D%(%H"*$+ X,HLYH6\L4k:lw%\W4% _D_2D%(%H"*$+ X,HLYH6\L4k:lx%\W4% _D_2D%(%H"*$+ X,HLYH6\L4k:ly%\W4% _D_2D%(%H"*$+ X,HLYH6\L4k:lz%\W4% _D_2D%(%H"*$+ X,HLYH6\L4( %H'd%:r _D_2D\L 8L4 94$:{ _D_2_6D 8 9%"*$+ ,H rH6\L4$d_2k:lg%\W4% _D_2D%(%H"*$+ X,HLYH6\L45vSFl%H"*$+ ,H d f)HKT:lJ%H"*$+ @,H\<'4\KFL$ :$`|H6\L4$:_PFl%H"*$+ ,H d f)H_D} @H'\%v|Fl%"*$+ ,H L`F$%(%(%"*$+ X,4Y)H6\L4$H'\%v|Fl%"*$+ ,HaLSM@L`F4%$ ~$%(%(%"*$+ X,Y)H6 \L4$:_PFl%H"*$+ ,H d f)H<(l%(%H"*$+ X,H\YH5\E_k%(l%(%H"*$+ X,H\YH5\2vF%H'\%:l%"*$+ ,H,H5\/_Dil%H"*$+ D,H,H _5vSFl%H"*$+ ,H d f)Ha'4%:lM%H"*$+ @,H\<WLN%"*$+ ,Q[`_H6\L4r\_ :lR%\WLL:4d__2_6?j$:% H"*$+ ,H -H6 \L4$:_PFl%H"*$+ ,H d f)Hl} @_L% _D_Dl%(%H"*$+ X,H\YH6\Ly_W\SMl@\%L ~L% _D_D%(%H"*$+ X,H4YH6\4L\_vDk% _D_Dl%(%H"*$+ X,H\YH5\[_vF% _D_Dl%(%H"*$+ X,H\H5\a__Lk% _D_Dl%(%H"*$+ X,H\YH5\[_vF% _D_Dl%(%H"*$+ X,H\H5\__5vSFl%H"*$+ ,H d f)H_s\t:_PFl%H"*$+ ,H d f)H__6cX1_ :lR%\WLL:4d__2_2_6?j$:% H"*$+ ,H -H6 \L4$}l]/\\_,_2_il%_0@F\OWLY '%'$%%:L4%H"*$+ ,H p-' :`#D_</DH6\L4$8Z_,_2_il%_0@F\OWLY`#D_</D6\L__<F% _D_2_Dl%(%H"*$+ X,H\YH5\wSM@_<Fl%\ ~\% _D_2_D%(%H"*$+ X,HLYH6L\_<Ml@ F\%vSF%H"*$+ ,H d LW$% _D_2_D%(%"*$+ X,4Y)H6\L4$_<Ml@ F\%vSF%H"*$+ ,H d LW$% _D_2_D%(%"*$+ X,4)H6\L4$M_,_2_il%_0D%F\OWLH5\H(l]/\#}l]/\\ _,_2_il%_0D%F\OWLY '%'$%%:L4%H"*$+ ,H p-:' :`#D_H/DH6\L4$!h:_,_2_il%_0D%F\OWLY4`#D_H/D6\L4l_<_H*FL% _D_2_Dl%(%H"*$+ X,H\YH6\LZ_,_2_il%_0D%F\OWL(]/46\L\"t:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4_,_2_il%_0D%F\OW4% _D_2_D%(%H"*$+ X,HLYH6\L4#t:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4Y(% _D_2_Dl%(%H"*$+ X,H\YH5\ 1H(l]/\'}l]/\\$_,_2_il%_0D%F\OWLY '%'$%%:L4%H"*$+ ,H p-:' :`#D_H/DH6\L4$6%h:_,_2_il%_0D%F\OWLY4`#D_H/D6\L4l_<_H*FL% _D_2_Dl%(%H"*$+ X,H\YH6\LH_2_Dl%(%F\OWL(]/46\L\'t:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4_,_2_il%_0D%F\OW4% _D_2_D%(%H"*$+ X,HLYH6\L4't:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4Y(% _D_2_Dl%(%H"*$+ X,H\YH5\ 1H(l]/\,}l]/\\(_,_2_il%_0D%F\OWLY '%'$%%:L4%H"*$+ ,H p-:' :`#D_H/DH6\L4$<)h:_,_2_il%_0D%F\OWLY4`#D_H/D6\L4l_<_H*FL% _D_2_Dl%(%H"*$+ X,H\YH6\LZ_,_2_il%_0D%F\OWL(]/46\L\+t:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4_,_2_il%_0D%F\OW4% _D_2_D%(%H"*$+ X,HLYH6\L4+t:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4Y(% _D_2_Dl%(%H"*$+ X,H\YH5\_<Ml@ F\%vSF%H"*$+ ,H d LW$% _D_2_D%(%"*$+ X,4)H6\L4$ 1H(l]/\.>::l%\WL4`#D_H/D6\L4l_<_H*FL% _D_2_Dl%(%H"*$+ X,H\YH6\Lt:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4Y(% _D_2_Dl%(%H"*$+ X,H\YH5\_<Ml@ F\%vSF%H"*$+ ,H d LW$% _D_2_D%(%"*$+ X,4)H6\L4$ 1H(l]/\ 1>::l%\WL4`#D_H/D6\L4l_<_H*FL% _D_2_Dl%(%H"*$+ X,H\YH6\Lt:l%\W4% _D_2_D%(%H"*$+ X,HLYH6\L4Y(% _D_2_Dl%(%H"*$+ X,H\YH5\_<Ml@ F\%vSF%H"*$+ ,H d LW$% _D_2_D%(%"*$+ X,4)H6\L4$5H_dXU4:l%H"*$+ `,H\H5\'l%H"*$+ D,H,H5vSFl%H"*$+ ,H d f)H(fl% H"*$+ ,H -H% H"*$+ ,H -Hq:lE%\WLD H"*$+ ,H |-(&lDv=*F$'4 L >/DH6 \L4$O:lP%(%f%H"*$+ H,H  )H _8 $D HH lDH3 x3q:lE%\WLD H"*$+ ,H |-(&lDv=*F$'4 L >/DH6 \L4$838x3 `\HDDH\L4$dK.q:l%\WDT X"*$+ ,X |-(&lTv=*F$'4 D >/TX6 \D4$5vSFl%X"*$+ ,X d f)X(fl% X"*$+ ,X -X% X"*$+ ,X -X( X"*$+ ,X <-X (q:lE%\WDT X"*$+ ,X |-(&lTv=*F$'4 D >/TX6 \D4$|$. ,TX\D4$$&%K,$_Tu7cx(_TMh@X 8:8;XH 9H(%$"*$+ @,$<'KF :H$6XH(q:h?%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(_Tdx,:hH%FXWH G6XHq:hI%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(-:hH%FXWHK"_h6XH,:hH%FXWHLU_l6XH>_h@_l@FXOWHU_n6XHA_h@_lDh%FXOWHU_t6XHR_tD8_h@_lDh%FXOWH(U_v6XH("_n_p _Ta'(%:hM%$"*$+ @,$X<WHN%"*$+ ,Q[_X$6XH(r'_XWXB_T_p5X_T_T_Xs% $"*$+ ,$ -$K$q:h%$"*$+ ,$XQaH'HKF( :U_x)$6 XH(K%( $"*$+ ,$ <-$_x_xU:h%_x@f8%$"*$+ H,$  )$E:h%XWH% $"*$+ ,$ -$6XH&$"*$+ @,$WXN`S$5XR '%'(%'H%'X%$"*$+ H,$   ( )$6XH(#fh%$"*$+ D,$,$w:h%XWH:8U(_xM@ 8 9%$"*$+ @,$N$6 XH(1$"*$+ @,$WXN`#_/$5X.$'X%:hV%"*$+ ,$$5X/h?%$ "*$+ ,$$0ch%$ "*$+ ,$WX$5X:hX%XWH:8U( $"*$+ ,$ d->F:U:%W%(%(p%"*$+ X,`Y)$6XH(`:hZ%XWH:8[($"*$+ H,$  >F:\vSF%(%(p%"*$+ X,Y)$6XH(w:h^%XWH:8U( ]%(%(%$"*$+ X,$Y$6 XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH( uY:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(l( %$'%:8_nDXH 8H( 9(%"*$+ ,$ r$6 XH( Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(l( %$'%:8_nDXH 8H( 9(%"*$+ ,$ r$6 XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(_teb:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH( ub:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(( %$'`%:8r _nDXH 8H( 9(: _n_tD 8 9%"*$+ ,$ r$6XH(``b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH(( %$'`%:8r _nDXH 8H( 9(:s _n_tD 8 9%"*$+ ,$ r$6XH(`b:h%XW(% _nD8%(%$"*$+ X,$HY$6XH( _T5vSFh%$"*$+ ,$ d f)$a'(%:hM%$"*$+ @,$X<WHN%"*$+ ,Q[\_X$6XH(rXQ_T  :h%XWHH:8(d_T_n_t?j:% $"*$+ ,$ -$6 XH(:_Fh%$"*$+ ,$ d f)$c} @_XH%_TDh%(8%$"*$+ X,$XY$6XHp_XWXSMh@X%H ~H%_TD8%(%$"*$+ X,$(Y$6X(HX_T_pk%_TDh%(8%$"*$+ X,$XY$5XR_TvF%_TDh%(8%$"*$+ X,$X$5X_h_Tih%_lD8%FXOW(%_TD%(%$"*$+ X,$HY$6XH(R_TvF%_TDh%(8%$"*$+ X,$X$5X u*_h_Tih%_lD8%FXOW(%_TD%(%$"*$+ X,$HY$6XH(_h_Tih%_lD8%FXOW(%_TD%(%$"*$+ X,$HY$6XH(_h_Tih%_lD8%FXOW(%_TD%(%$"*$+ X,$HY$6XH(_T_T_XsXm_T_tcTL#_T :h%XWHH:8(d_T_n_n_t?j:% $"*$+ ,$ -$6 XH(}h]/X\_h_n_Tih%_l@FXOWHY '%'%%:8H(%$"*$+ ,$ p-' :`#_|/$6XH(NZ_h_n_Tih%_l@FXOWHY`#_|/6XHV_|F% _n_TDh%(8%$"*$+ X,$XY$5XnSM8@_|Fh%X ~X% _n_TD%(%$"*$+ X,$HY$6HX_|Mh@ FX%vSF8%$"*$+ ,$ d HW% _n_TD%(%"*$+ X,(Y)$6XH(_|Mh@ FX%vSF8%$"*$+ ,$ d HW% _n_TD%(%"*$+ X,()$6XH(_h_n_Tih%_lD8%FHO% _n_TD%(%$"*$+ X,$XY$6XH_|Mh@ FX%vSF8%$"*$+ ,$ d HW% _n_TD%(%"*$+ X,()$6XH( u;#_h_n_Tih%_lD8%FHO% _n_TD%(%$"*$+ X,$XY$6XH_h_n_Tih%_lD8%FHO% _n_TD%(%$"*$+ X,$XY$6XH_h_n_Tih%_lD8%FHO% _n_TD%(%$"*$+ X,$XY$6XH_TdTk4:h%$"*$+ `,$X$5X'h%$"*$+ D,$,$5vSFh%$"*$+ ,$ d f)$(fh% $"*$+ ,$ -$% $"*$+ ,$ -$q:hE%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(O:h%(8%f%$"*$+ H,$  )$ _x $P $$ lP$0% %q:hE%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(,%4%\XD$XH(`+D*K(_u7cx(_Mh@X 8:8;XH 9H(%$"*$+ @,$<'KF :H$6XH(q:h?%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(_dx,:hH%FXWH G6XHq:hI%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(i _K:hJ%$"*$+ @,$X<'(XKFH :'%"*$+ ,aB_)$6 XH(K(-:hH%FXWHK"_6XH,:hH%FXWHLU_6XH>_@_@FXOWHU_6XHA_@_Dh%FXOWHU_6XHR_D8_@_Dh%FXOWH(U_6XH("__ _a'(%:hM%$"*$+ @,$X<WHN%"*$+ ,Q[_$6XH(ri'_WXB__5X___s% $"*$+ ,$ -$K7)q:h%$"*$+ ,$XQaH'HKF( :U_)$6 XH(K(__U:h%_@f8%$"*$+ H,$  )$E:h%XWH% $"*$+ ,$ -$6XH!$"*$+ @,$N$&$"*$+ @,$WXN`S$5XR '%'(%'H%'X%$"*$+ H,$   ( )$6XH(#fh%$"*$+ D,$,$w:h%XWH:8U(_M@ 8 9%$"*$+ @,$N$6 XH(1$"*$+ @,$WXN`#_/$5X.$'X%:hV%"*$+ ,$$5X/h?%$ "*$+ ,$$0ch%$ "*$+ ,$WX$5X:hX%XWH:8U( $"*$+ ,$ d->F:U:%W%(%(p%"*$+ X,`Y)$6XH(`:hZ%XWH:8[($"*$+ H,$  >F:\%(%(%"*$+ X,Y)$6XH(w:h^%XWH:8U( ]%(%(%$"*$+ X,$Y$6 XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(:(8 %$'X%:h%"*$+ ,$ r$5XY:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(o( %$'%:8 _DXH 8H( 9(%"*$+ ,$ r$6 XH(E?%(h %(8%$"*$+ X,$X$5XY:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(Y:h%XW(%(8 %(%$"*$+ X,$HY$6XH(o( %$'%:8 _DXH 8H( 9(%"*$+ ,$ r$6 XH(E?%(h %(8%$"*$+ X,$X$5XY:h%XW(%(8 %( %$"*$+ X,$HY$6XH(Y:h%XW(%(8 %( %$"*$+ X,$HY$6XH(Y:h%XW(%(8 %( %$"*$+ X,$HY$6XH(Y:h%XW(%(8 %( %$"*$+ X,$HY$6XH(o( %$'%:8 _DXH 8H( 9(%"*$+ ,$ r$6 XH( 0|K5vSFh%$"*$+ ,$ d f)$T:hJ%$"*$+ @,$X<'(XKFH :`|$6XH(:_Fh%$"*$+ ,$ d f)$K)( $"*$+ ,$ <-$ v|00Y:h%XW(%(8%(%$"*$+ X,$HY$6XH(>(%(h%(8%$"*$+ X,$XY$5Xc} @$'X%v|Fh%"*$+ ,$ H`F%(8%(%"*$+ X,(Y)$6XH($'X%v|Fh%"*$+ ,$aHSM8@H`F(% ~%(%(%"*$+ X,Y)$6 XH(E_k%(h%(8%$"*$+ X,$XY$5X?vF%(h%(8%$"*$+ X,$X$5X# $"*$+ ,$ T-$ _lvS*#*#\*FX%(h%f8%$"*$+ H,$  2\)$5X5vSFh%$"*$+ ,$ d f)$a'(%:hM%$"*$+ @,$X<WHN%"*$+ ,Q[X_$6XH(rT/$:_Fh%$"*$+ ,$ d f)$_ f:h%XWHH:8(d__?j:% $"*$+ ,$ -$6 XH(c} @_H% _Dh%(8%$"*$+ X,$XY$6XHp_WXSMh@X%H ~H% _D8%(%$"*$+ X,$(Y$6X(HX__k% _Dh%(8%$"*$+ X,$XY$5XR_vF% _Dh%(8%$"*$+ X,$X$5X5vSFh%$"*$+ ,$ d f)$vvS*#*#\*F(%:h_WXH%f8%$"*$+ ,$2\$6X(HvvS*#*#\*F(%:h_WXH%f8%$"*$+ ,$2\$6X(H]vS*#*#\*FX%(h%f8%$"*$+ ,$2\$5XK% $"*$+ ,$ -$'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'`%'%'%'%'%'%'%'(%'H%"$  l*FX%$"*$+ ,$ -/$R6>tdTD4$XH(`D4$K)% $"*$+ ,$ -$K_WX$'H%X%"*$+ ,$a(B_$6XH( v|0=S;$'X%v|Fh%"*$+ ,$aH_$6XHe(h_:h%XWH:8U(_M@ 8 9%$"*$+ ,$ d f)$6 XH((h]IX\@N_k% _Dh%(8%$"*$+ X,$XY$5XR_vF% _Dh%(8%$"*$+ X,$X$5XJ_} _Dh%(8%$"*$+ X,$XY$5XR_vF% _Dh%(8%$"*$+ X,$X$5Xb:h%XW(% _D8%(%$"*$+ X,$HY$6XH(b:h%XW(% _D8%(%$"*$+ X,$HY$6XH(]vS*#*#\*FX%(h%f8%$"*$+ ,$2\$5X5vSFh%$"*$+ ,$ d f)$K% $"*$+ ,$ -$'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'`%'%'%'%'%'%'%'(%'H%"$  l*FX%$"*$+ ,$ -/$6>tdTD4$XH(`D4$K)% $"*$+ ,$ -$K_WX$'H%X%"*$+ ,$a(B_$6XH(h_K v|0= ;$'X%v|Fh%"*$+ ,$aH_$6XH (h_K)U_WX__kh%$'H%X%"*$+ ,$,$6XH:h%XWH:8U(_M@ 8 9%$"*$+ ,$ d f)$6 XH((h]IX\"N_k% _Dh%(8 %$"*$+ X,$XY$5XR_vF% _Dh%(8 %$"*$+ X,$X$5XJ_} _Dh%(8 %$"*$+ X,$XY$5XR_vF% _Dh%(8 %$"*$+ X,$X$5X#b:h%XW(% _D8%( %$"*$+ X,$HY$6XH(b:h%XW(% _D8%( %$"*$+ X,$HY$6XH(__# $"*$+ ,$ T-$5vSFh%$"*$+ ,$ d f)$_sT5vSFh%$"*$+ ,$ d f)$:h$"*$+ @,$WXNH:8(:%_@f%"*$+ H,  )$6XH(:h$"*$+ @,$WXNH:8(:%@f%"*$+ H,  )$6XH(K2:hJ%$"*$+ @,$X<$5X v|0=R&:h$"*$+ @,$WXNH:8(:%v|*F%f%"*$+ H,  )$6 XH( vC0=&:h$"*$+ @,$WXNH:8(:%vC*F%f%"*$+ H,  )$6 XH(d:8_Mh@X 8XH 9H(%$"*$+ ,$ d f)$6XH(4:h%$"*$+ `,$X$5X4:h%$"*$+ `,$X$5X4:h%$"*$+ `,$X$5X'h%$"*$+ D,$,$5vSFh%$"*$+ ,$ d f)$!$"*$+ @,$N$(fh% $"*$+ ,$ -$% $"*$+ ,$ -$q:hE%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(O:h%(8%f%$"*$+ H,$  )$ _ $ $$ l$) =*q:hE%XWH $"*$+ ,$ |-(&lv=*F'( H >/$6 XH(D*4=*XT%\$XH(`D4$tdTD4$x$Kq:l%\WDT X"*$+ ,X |-(&lTv=*F$'4 D >/TX6 \D4$5vSFl%X"*$+ ,X d f)X:lX"*$+ @,XW\ND:4:$%_@f%"*$+ H,  )X6\D4$:lX"*$+ @,XW\ND:4:$%@f%"*$+ H,  )X6\D4$ v|0=d:lX"*$+ @,XW\ND:4:$%v|*F%f%"*$+ H,  )X6 \D4$ vC0=:lX"*$+ @,XW\ND:4:$%vC*F%f%"*$+ H,  )X6 \D4$!X"*$+ @,XNX(fl% X"*$+ ,X -X% X"*$+ ,X -X( X"*$+ ,X <-X (q:lE%\WDT X"*$+ ,X |-(&lTv=*F$'4 D >/TX6 \D4$$$ 0 TX\D4$MrU  $`y$`y$`y$`y$!`y$I`y$q`yprU~}  ! I q  F0 xB  B  B  B  B  (@ B HPh B px B  B G B :58 B@HP B X`p B x xJ this module contains all VBA functions the users can use in their macros.8 This is the place where localization should take place.I NOTE: For localization to work with recording macros, the function namesI here must be the same as the names on the Language sheet, starting$ atxk@1a!(6 < <2$*\Rffff*1132879c9f$*\Rffff*1332879c9f+Z`PX \k@ $i\ `9 i^i`  The+d`` \k i\ i^0i`   14+h`x x \k i\ i^i`  14+l`Pp \kP in pip  14+t0`Xh \k in ip  14+x``\kp "izi|  14+0` X\k &i  14+`(P\kp *i i i i  14+` H k@ .i `i i` i  14+ `(\k 2 iX 0i Pi pi i i$ i( i, i0 0i4 Pi8 pi<  14+ `\k 6 14+` `\k0 :i  14+ `\k >i i  140`0`Xp $ 14h( @`h ( P @ `Zl ( b@\ 0` H 8 `dl  f@\  X  @ 0 `hl  j @\  pPP  8 ( `ll dT r@\ H0 `tl hv@\ p@(`xl "~h@\ 8 `l &@\ p0`l *@\ h@(`l . @@\ @XL 4@p< @, @ @ 0pP0pPXp`l X2@\ PPxh`l P6@d@\ 0HHp``l H:@\ @@hX`l p%@> @@\  `H MEE  P >X P P *8 Rh L  A197, including parametersK On the Excel4Functions sheet, the user functions are outlined in blue, and`gE the first cell in each of these must be renamed for localization for@ backwards compatibility.? The 2 dialogs on the Excel4Functions should also be localized.e( \ ^ `$b'ZiofX \ ^ `$f'd, f0` \ ^ `$j'h"f n p$r'lext, f n p$v't"solvef0 z |$~'xal(xlLf $'1)fp0    $' ":=" f@    $'ddarg3f            $ 'f 'f $'f`  $'f`XRAttribute VB_Name = "VBA_Functio ns" Op4 ExplicitH' this module contain s allA fLe use@rs can in(ir macros. ' TLOthe place whe    & !"#$% '()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstvwx{|}~re localizashould tak$:NOTE: For ,to work with recordings, n}sC {:@ ?` , 8Load(AArea'bY? _UZUA VO bOk&Setc bMaxMinV6P@ueOgv8ByDPiOOk//*Ok , F ,pp}Of, , 5yQ~Ok xee?s'%Tig I`"s/'n`rPisA@ssumeLarStepThruEstimateoDeriv vSearch#!KToleran0/ S#Conge4_NonNegP s#?# 6#, , ,P GS, , sH@nt,> C**Reset(2R??Save(AbQ A V B#=Uc'8=Show? (w p"3    9 a \$lll\ \l $(l\\$lll\ \l $(l\\$lll\ \l $(l\X ll\  \l (l\X ll\  \l (l\X ll\  \l (l\Tl\ \l (l\`(llll\ \l ((l\PGllll\ \%'','<'L  ,6 L<,\ pP(l$\L<, x@5l<l8l4l0l,l(l$l llll\ 4\l8 @(l\T\ \l (l\Tl\ \l (l\X ll\ \l (l\    /__SRP_7HSolver1:__SRP_9 z`__SRP_8X:rU 0` y/&0` y/&0` y/&,`y,!`y,I`y9Q&(q`yq/8`y8`y` `00y9 i)Qq9$ `y(9 `y /,a `y)Ipp  " "  X( 0 V<uX`*h>uxP< , <u P X`hEp>u C >u8 @9H Ph ,Q    &Q     ( >u0px 1 % 1 ( 39 :0 %8 H PX`hp x0 % "4 (  0 8 *d@ p FqPh Fq b    6      8 lH *Q  Pp  ~ *QH x b h 6p         %          %    T0  x  % % %(0 HX p   $G %   >u @>WH J~J@JHJh xxx (08<PXhp nY/k@u/ffuh@> L  "LLLLL >@8@BB@p DD@ HH@"L L@ PP@? dd@ > ll@$erenceSt@ 14 Endx?8` @ ? @? @& he0 14 `xp|k").E`8 oge() 14N =   ?? ?    `Pk``ho 14  @B> ?$?&F(z,D0 `p8`!k 14Z`b `#kP I Z`h`8$f `&k i0xiPi8 14Z+P``'$k Z I Z  14 14`h8k 4 he m?4ing 8x, a< ?L on ?PZ?@ T ZX ? h ?l  pH 8 0 ? @(@( @?x, ,@N44@?< <@6@ @@hFF@J J@?zT T@&hXh@8 p p@?\t t@? @>@@   8 h  H p xX (`  @ P@p(X`xP`0 8>6@x @ h @X @H @xD @4 @8$ @  @  @x @ H \F\@8 @ @ @ @ 84@ @ @(hz(H:Nl:@ @h @ @ @ @x @ h @PX @T @D @4 @$ @ @ @ @ @8 P`bp,T6,@ 8 P:&>&>@ @ @_ @ @  @8 @P @h @p @` @P @@ @0 @ @ @( @@ @X @ Z00H`px8hP0p8HF\:b@x @h @X @PT @D @@ @ 0 @ @ @ @ 0 PNZ@ p"@ "@ @ @ @ @ X\8>6@h @ @ @ ff`ff`k@ `(m@ ` X p  8x8 8>6j@ x @Ph @d @hT @D @4 @$ @ @X @ @ @( @ @@ @ @p @ @ @ @x @h @X @H @08 @`( P: @ @ x. @_ P.H @  bNn\@`  x8w@ `w`y@ z@ z@ @( @@ @X @p @ 8! x P !h \8>@8 x @ h @d @ ` ` P @ P @ @ @0!0 @ @ ` @ 6@H! @ `""x"0""8# #P#8>6@H"x @"h @d @\ @"L @"< @", @( @# @ @ "\@`# x#8#@ #`#`#$`%x$`$$8$H%P$@l %8$@$T @$D @4 @x%$ P $$@ % 8%$@% % %@ @ % %@% %%@ %%%P0&&@'&'&&&@l &@'h @('X @T @X'D @p'4 @'$ @' @ @ @ p((((p(((`Pxp(\@(h @)X @T @D @()4 @$  @X  > ME  8XP$* :(&@*Mh %   %: + ( + 08.@9Xpx>u<u (0 "8@ (H -p ,W ( ! % "" @ ` -h ( ( $/ ( &/ %8 %P %p % % % % >u `h "p Hx J0 P px: @b:K08 @4H >Q>K ( 0(_@:Yh ;   4J 8N(  ` h 4Jx 8N    4I :N8  x<G *Y:ZXp G<  : 0 @ H ZP $h xC &_"[ B"[X <C  B "(  8 UH "h x     : T &_!"[(!,|P!!P!&s!!!! ! ! ! " 8i" H" $5X" " " $5" ""*_" # Lv #p#  x## # DW## Le#8$@$H$ -P$ >tp$ >t$ @t$ Fx0% @x% % &/% Bt% 0& $:8& %`& x& %& & 8& & $:& %' (' %0' P' X' $:`' %' ' %' ' $:' %(  ( %(( H( P( $:X( %( %( ( %( %( ) $:) %8) %X) x) %) %) ) $:) %) %* (* %0* %H* h* p*x**>u*** -* (* (+ $/8+ (`+ &/+ %+ %+ %+ %, % , %@, %`, x,,, ,,, ",0,$0,,P- -8- @-X--`->up--- $- $- 3-'-./ . @.X. `.h. p.x... B . :. \.8/H/,P/h///(/ >// ///0 0 (00080 @0H0 B P0 X0Hbh0  00 0000Xn0,-@1p1,-x111 B 11 1 11S1222 2(2 "02 .82h2p2222 %2Fh233  383 %3 @~3 4(4 0484 %@4 P4@j`4 485 Dw@5 5  6 (6 66666 6 7F7 P7 `7 8h7 $7B7&7 7V7&788/8088N88Vp8 #8F~8n 9F~9 #98Q9 :2(:H:8NP:V: #:n:F~`;F~; #;8Q< 8<<@<<:N<`<^(=4I= #=x=F~H>b> #> ?2?0?28?T|H??f?@ @ @(@20@P@2X@T|h@@f@0A 8A@AHA^PA/A$VAA$VB(B0B@BXBhBpB.B MB(nBCC C(C0C|8CC%C2KC/Dh0DNDDbDNXEE E<uEF%F2K F/XFhxFNF0Gb8GNGG G<uHHH%PH2KhHJhH/H/I2K0IJhhID|IJD|JPJXJN`JJ J<uJK%K2K0KJhhKNK L<uLXL%`L2KxL/LhLN8MMbMNMHN PN<u`NNN<uNN N O OOO % O0O8O @OPOXO `OpOxO %O<uOOO %O>uO0P8P %@P>uPPPP>uPPP PZ X   Z (P Z x Z  H Z @p hSolverZ  AreaZ   Z  rSZ  8 UsZ `  @A@A@lR This is the main routine, displaying the Solver dialog box, and taking appropiate) action, depending on what the user does.Zs VaZ(@XpA@ !n  ! solver_msg_1 8%:!f !< >&A@6ceStdh !@ I solver_msg_1c 8%:!f !< >&A@6d@h8 !$W !*U  !& he solver_msg_1 8%:!f !< >&A@6dhhh !!V solver_msg_1b 8%:!f !< >&A@6d0h( !' $N = solver_msg_1a 8%:!f !< >&A@6a'    !$W $ $\ SOLVER32.DLL'r8h0a( $$\SOLVER'rhh  solver_msg_1a 8%:!f !< >&A@6hhvx !' ( !' F (0 !Z'\  \Z %X'zv' solver_typ %'v (' A@aA@h'( B@ (Cancel (Cancel'(( Solver_dialog %0B@v (Cancel (A@' solver_adj %!$:!X' N  \ okfunc 8%:!f okarg2 8%:!f:='  , okarg3 8%:!f:="$dValueof Solver_dialog %0%H!J"$' , okarg4 8%:!f:="$ "$'a@okfunc 8%:!f okarg2 8%:!f:='  , okarg3 8%:!f:="$dValueof Solver_dialog %0%H!J"$' , okarg4 8%:!f:="$    %"$'h  B@a N  \ okfunc 8%:!f okarg1 8%:!f:="$ N"$, ' okarg2 8%:!f:='  , okarg3 8%:!f:="$dValueof Solver_dialog %0%H!J"$' , okarg4 8%:!f:="$ "$'a8okfunc 8%:!f okarg1 8%:!f:="$ N   %"$, ' okarg2 8%:!f:='  , okarg3 8%:!f:="$dValueof Solver_dialog %0%H!J"$' , okarg4 8%:!f:="$    %"$'h  B@hphhh` (AddHQ (A@lDeleteHQA@:ChangeHQ (A@bOptionsHQ (Options ( Save_model ( Load_model (Saveload (OptionsHQ (A@ Save_modelHQ (A@p Load_modelHQ (A@k (SaveloadA@ (SaveloadOptions'( ( Save_againb Save_model'(hphh` CallSolverHQ msg_setup 8%:!f ( (A@  solver_msg_1a 8%:!f !< >&A@6$,b Optimum_cell Solver_dialog %0%H!f TV('6a` Optimum_cell Solver_dialog %0%H!J$P$:!'6 Optimum_cell Solver_dialog %0%H!J$P$:!8':h $:!V& $:!V>' Adjustable_cells Solver_dialog %0%H!J$P$: ! +& !8 +>  ' z$P$:B@J ! !Solvecall %' solvefunc 8%:!f B@ (A@Cancel'(h8 k0 ( ( z$P$:B@J  ( (  (u  $A$1$:B@J \Z %X'z v solver_err_msg 8%:!f !< >&A@6d8 0 solver_msg_1 8%:!f !< >&A@6d  ' l v " sets default for fresh worksheet. Solver_dialog %0 \Z %X Optimum_Cell7H(fU dValueof7H(fdValueof7H(  max_button7(Adjustable_cells7H(JConstraint_list72B@ n Options_dialog %0dU Max_time7H(JdU Max_iter7H(J??>U Precision7H(JU Tolerance7H(JMbP?U Convergence7H(J Assume7( non_neg7(  show_iter7( auto_scl7( Tangent7( Forward7( Newton7(nuvsolver_err_msg 8%:!f !< >&A@6dl Agets relevant setting for the worksheet, if not a fresh worksheetC many options need not always be defined, so "on error resume next"ZpZDQZ0H`x' solver_opt %'  $ Optimum_Cell Solver_dialog %0%H(Ja Optimum_Cell Solver_dialog %0%H(JhA@F' \Z solver_adj %!$:%X'vx  Adjustable_Cells Solver_dialog %0%H(Ja(Adjustable_Cells Solver_dialog %0%H(JhA@bU ' solver_val %U $' UU dValueof Solver_dialog %0%H(f=1' solver_typ %U ' =1HQdValueof Solver_dialog %0%H(  max_button Solver_dialog %0%('=2HQdValueof Solver_dialog %0%H(  min_button Solver_dialog %0%('=3HQdValueof Solver_dialog %0%H(  value_button Solver_dialog %0%('kxConstraint_list Solver_dialog %0%2B@ ' solver_num %U $U'   solver_lhs $P$N %U $'> >$:!X$'> >x >$:!X'>h` solver_rel $P$N %U $U'B B solver_rhs $P$N %U $'@ @$'Z @$:!X$'@ Z  formula @ !}'  @' !'!} @' !'!}' _ @  $ @ @  !  $\'@ @' !'!}'xap _ @  $ @ @  ! $\'@ @ !}'hh.  % @.}' _  % @  @.}'hxap @x solver_rhs $P$N %U $'@ @ !!} @' !'!} @' !'!}' @ @  !  $\'@ax @ !!}' @ @  ! $\'@h(h hha @UU '@h BOptions Add_dialog %0%V%X'D Bbsolver_msg_int 8%:!f'@='D Bbsolver_msg_bin 8%:!f'@='Dh  >  D  @$N'F  FConstraint_list Solver_dialog %0%2!$'za'zhx z FfConstraint_list Solver_dialog %0%2B@a Ff z`Constraint_list Solver_dialog %0%2B@hOptions_dialog %0 solver_tim %U $UU Max_time7H(J solver_itr %U $UU Max_iter7H(J solver_pre %U $UU Precision7H(J solver_tol %U $UdU Tolerance7H(J 9new convergence option will not always be available, so..@MbP?U Convergence7H(J solver_cvg %U $UU Convergence7H(J solver_lin %U =1 Assume7(a Assume7(h` 1 new option nonneg will not always be there, so..  solver_neg %U =1 non_neg7(a non_neg7(h solver_sho %U =1  Show_iter7(aP  Show_iter7(h( solver_scl %U =1 auto_scl7(a auto_scl7(h solver_est %U =1 Tangent7(  Quadratic7(a8 Tangent7(  Quadratic7(h solver_drv %U =1 Forward7( Central7(a Forward7( Central7(h8 solver_nwt %U =1 Newton7(  Conjugate7(a Newton7(  Conjugate7(hnuvxsolver_err_msg 8%:!f !< >&A@6d0(Options_dialog %0dU Max_time7H(JdU Max_iter7H(J??>U Precision7H(JU Tolerance7H(JMbP?U Convergence7H(J Assume7( non_neg7(  show_iter7( auto_scl7( Tangent7( Forward7( Newton7(nuxp'`lXLanguage %.8Excel4Functions %.Z !$W \xlmain8.hlp'>a:MS EXCEL HELP'>h !Vsolver_msg_150 8%:!f !< >&A@6dHh@ !' !' !Z'\ '}    $'"  hh A@hxlp4 This procedure doubles the "'s inside its argument.V This is necessary to avoid recording problems on sheets with quotes in their names!!!Z      $ + $"$"$"$ +h '    $' 's'f    Constraint_list Solver_dialog %0%2%X 'a@  'h(s h    Constraint_list Solver_dialog %0%2%X     $'a      $'hPfH8 \  'Pa    %'Ph s  'Pf ( user presses "ok" on load or save modelv Z@ X Zp  Z  Z   ( Save_dialog %0!x!J solver_msg_46 8%:!fA@a  load model Constraint_list Solver_dialog %0%2!Adjustable_cells Solver_dialog %0%H!J ( solver_msg_5 8%:!f! !< >&$6' u h h (A@jThe_area Save_dialog %0%H!J!}loadfunc 8%:!f loadarg1 8%:!f:="$The_area Save_dialog %0%H!J"$'a The_area Save_dialog %0%H!J"$}loadfunc 8%:!f loadarg1 8%:!f:="$The_area Save_dialog %0%H!J"$'a loadfunc 8%:!f loadarg1 8%:!f:="$The_area Save_dialog %0%H!J$"$'h0 h(  B@  '' The_area Save_dialog %0%H!J$P$: $   !=} !'.  % .}' _  %   .}'h $=MIN  Min_button Solver_dialog %0%(   $$ Optimum_cell Solver_dialog %0%H(J  (' !' !solver_typ B@' !' !solver_opt=   $$:!X B@' !' !solver_val B@  (U dvalueof Solver_dialog %0%H(J' $=MAXb  Max_button Solver_dialog %0%(   $$ Optimum_cell Solver_dialog %0%H(J  (' !' !solver_opt=   $$:!X B@' !' !solver_typ B@' !' !solver_val B@  (U dvalueof Solver_dialog %0%H(J' COUNT}   %} bx  Value_button Solver_dialog %0%(  =~ $$ Optimum_cell Solver_dialog %0%H(J ! !=~ $UU dvalueof Solver_dialog %0%H(Jdvalueof Solver_dialog %0%H(  (' !' !solver_opt=  =~ $$:!X B@' !' !solver_typ B@' !' !solver_val  =~ $ B@  (' $=COUNTAb !Z    $Adjustable_cells solver_dialog %0%H(JaX   $   %Adjustable_cells solver_dialog %0%H(Jh?'A@bA@ $=COUNTb? !Z    $Adjustable_cells solver_dialog %0%H(Ja8?   $   %Adjustable_cells solver_dialog %0%H(Jh>'A@bA@ =~ <=~ >=~ =INT}b $=VAR   $$N'a>   $$N'h=Z   +=     %} $ +  $ $'   %}     +'r<h<<$$$$$$$$ $ $ $ $ 'r@< <=~ bOptions add_dialog %0%V(4 $=SUM  =~  =~  $rhs add_dialog %0%H(J  <=~ $lhs add_dialog %0%H(Ja;  =~  =~ $rhs add_dialog %0%H(J  <=~ $lhs add_dialog %0%H(JhP:$n solver_msg_6 8%:!f !< >&A@6h9 >=~ bOptions add_dialog %0%V(4 $=SUM  =~  =~  $rhs add_dialog %0%H(J  >=~ $lhs add_dialog %0%H(Ja8  =~  =~ $rhs add_dialog %0%H(J  >=~ $lhs add_dialog %0%H(Jh8$n solver_msg_6 8%:!f !< >&A@6h7 =INT} bOptions add_dialog %0%V(4solver_msg_int 8%:!frhs add_dialog %0%H(J $=INT $\))=1Options add_dialog %0%V(4solver_msg_bin 8%:!frhs add_dialog %0%H(J   $lhs add_dialog %0%H(Ja5   $lhs add_dialog %0%H(Jh5a5  =~ $lhs add_dialog %0%H(JhH5$n solver_msg_6 8%:!f !< >&A@6h4 =0)+(~ bOptions add_dialog %0%V(4solver_msg_bin 8%:!frhs add_dialog %0%H(J  =~ $lhs add_dialog %0%H(J$n solver_msg_6 8%:!f !< >&A@6h3 =~ bOptions add_dialog %0%V(4 $=SUM  =~  =~  $rhs add_dialog %0%H(J  =~ $lhs add_dialog %0%H(Jap2  =~  =~ $rhs add_dialog %0%H(J  =~ $lhs add_dialog %0%H(Jh1$n solver_msg_6 8%:!f !< >&A@6hX1aP1 solver_msg_6 8%:!f !< >&A@6h1'h0h00h0 (u0 0 0h0 0h0 ( solver_msg_6 8%:!f !< >&A@6u(0 0 ( solver_msg_6b 8%:!f !< >&A@6u// ( solver_msg_6c 8%:!f !< >&A@6uh/v`/solver_err_msg 8%:!f !< >&A@6d/l//?Attribute VB_Name = "Solver1" Public answer, action As Sng, c hange"Boolean, fresh" oldobj, format'Kdllavai l;s_adj3 1op GliIntegxnegBNt$yp,  re sho%sce @esV nw drv1Hort_generastop_] remembershee6^Acurrentarea>num qvars()Do eBvCvLAutoOp@-&d ,avEyle"excel4l@uag., th0n, helpfilE DOpIExp@itASub stub() A.@ProcDataInvok@e_Func \n14 I4_o@4 @Main End6 B ?St@jcA KAg ' This B m routinJdisplayingJ C dialo`g box(tak!appropiat@/ |, deda@~ wh`uA user@ does.Dim s7cal8culFQ[";at usbaro>creenupdAG dummy!S i c, v`bacod=CarrayOn Error GoTo eAdgIf "AveSd.Type <> x lWorkM O@H@EtectCo`nts`3e@)aMsgBox& #X%Z.R("msg_1").Text, 32, , ApAUB*.Path &B]a[, 1830A NAOIfcbook.I(sIn@Cc!Truegec?r?'Left()!ngSys(tem )AoW"7$VA> "C F(6)L "MultiUZEdi hgN ,8r_8z88 99 ;igindow.Sel QedXs.Count > 1,O V_1b@T)PW)d D:C)RegirledVZs IsNull(}7 a lpq+ElsR`= FaFPEi@ LBd o U<  /p}/)B-RightY&(i302R3SOLVER32.DLL 4PX A 3Exit 9# 1), :Q  sV  NV Not ThI\ /&/&/&\\& +k~bkSswstv=jcDusBar97+)zSU{`Ena@bleCanKeyxlADA yRefe?ceStKs"N^?CP.Add0s([:=#oc?B asV"P,? Kp(H?A= 1c`- ,Set_defao4VNGsetp dp;3*'RecordMacro@ basic?:d="Wh@b<> "!|yIGVResuo@I>A?D3r( _c@bShow W  AhMDef_A4BK4 x`?A?i'"I).Name).Address  If solver_opt = "" AndLadj <>PThenl|ravestylepxlA1 JP@vbacod#excel4language.Re("okfunc").Text & "& +arg2+:=" pz&htyp50,13 1Ch r(34)ThisWorkbook.DialogSheets(4"Sd !Ed@itBoxe dValueof Caption*`"Z4-/gyt& 2Else"nokn@nnn?EnA@pplicaL.ContFor mula(u, AAR1C1iSy{If< RecordMacro@ basicAw:=iE+_uA ez=V?G@/1fafiaqk(G%di D>????$?"_xrg_x G??GvJvL=faLo&5o&eo&O{o&GssQto&sSxo&hA2/soWg-soWjoWEWp9WPW Select Case acQdR"pky ScreenUpdhngTru_constraintD|te 3_ 3 Ch%o po m ?7OsKWhi"E OrKQS_ml"Loadl(  HShowQ#8? ?? _)   Q2??! bRok! P'G_m_ag7""A T* D_ WendCCall?. #tatusBar 4g`msg_setup`aQj ''FaDefine_n@.0Not dlla0vailMsvg0?nQ dr 1a , 32, B,*PathphelpfE, 18830* Problem_ok()0uu uxes("Optimum_cell").Text = "" Th en oldobjCVE rr(xl NAB) RElsezRange(Stylecheck(ThisWorkbook.DialogSheetSolver_dEditBoCaon)@).Valuf0orma]CNu`mberF7nd If ReDim vars (Osadj).Countknis1!, Each c I n IBkAdju@stablesrFl Ai)@(ctJE= ^e .VB_ProcDataInvo0ke_FA= \Hn14='gUrPtvantVBVthe &V, if not aWc:'P[ny o@s needlways be[rd, so "hon rl @eun@ znopro@m As Bo4an,@w!`S dummy# 0 _right9mid_i@Integer, lef{z!xs?iAjnewuk4Obj; $=r_PpQ)?eStyle:= saves)  On Error GoTo maine8pIf noproblem Then,lThisWorkbook.DialogSheets("So@lver_d(").EditBoxeAdjustaN_CellsCaption = newadjaElseYk""3nd IfNsResume Next helpstring[CStr (0 Mid(ActiveP.Namsval")), 2dValue4ofTRJCD(bl(H)("=1B -typ-CSelect Case @G@ qH9End*FaOBButtonmax_bGQTxlO Dm?182DR8Ar818in#Sc2m38Tru'~8L jue3EYqfLiseCItrt_l`0RemoveAllItemdInumI0 jbw_ {F`ziS G C Sthe_left@ _lhs" &@ Trim(i)? Get_n(Range(% ).Addr8ess$Len' > 120Kk T 7% mid_i9= )qCArel3 < 4righ+?+r>+ @ N@ot IsNr,ic&b )n% "B~`&Ey }_/p1> ' forpmulavb@jIn!%, g?ej <s2~"'p-"'!") t, ?}5#Do WhileN C _c IL :,- 1)R&55$"-A -&%y9et Lodopo  OOMOgOOme = +l+?sR_/XCN4N8NHI d "*o , %o[VI, End If LElse the_right = CStr(CDbl(*))\&middle=ThisWorkbook.DialogSheets("Add_d").DropDownOptionsAList(J_indrIf c4 ThenTexcel4language.Re("solver_ms g-t5Text? 0a"=" >b5:>bin)>newentryrxleft & r"@& 0T8rimp4Ri 8> 1 2^exsearch(aE, 1, vSWFwrBoxe@wCvtraint_lw@?Cou|ntx'.@3E"0 1 N3X+ Item A:=?EDG% ?CI, Index:=>RGN[On Error GoToD eAhan\rWith;dsv .Edit  _. {e s z ? r PB }shoq=o Z Show_Jo o  !_ ^ c1C,3 ,auto_sO J  0? 9 Csdues0/;u B.smButt("TQnqE=Quadratic> ,Z:}F0!!drv?._"ForwardN?CaP(9%/m% "y nwp_& New&8!ujugat)onVlO* =;Vlqidxit Sub mb:Msgr _gW?1, 32, , Applic7on.Pa`& helpfbi183 ~ t^s?@(,I\O6n[0C .EditBoxes("Tolerance").Caption = CStr (5) Co@nvergej0.001 rCheckAssumAkValueix0lOff g -no`n_neg".show_iter%0auto_sc lOButtonan|tn ` Forward'New5End With7Exit Sub error trap: noproblem False Re_ Next   SoltName(oAttribute.VB_Pr@ocDataInvoke_Func" \n14"Set e@xcel4l@KuagzThisWorkbook.EBMacroSPheetVL ";s@Intl $sDim i AsB eger)If Left(A@pplica .OptingSystem, 1)6W" Theyhelpfil5"\xlmai@n8.hlp?E [ I :MS EXCEL HELP sIC#EGs.Count@0 Msg?V.RNe("sp_msg_150Ty, 32, , 9Path &f830B"}BbCDthe b0nCActive6.E!savesty"'A)ReferS? !InS , "'") <> +#`l<= 1 To:n(J#" Mid, :i=' =B""8(&l`Not A Mned;_opLs Z .fix(3t|ng 'vuu "'is `cedure dous .s inside it s argnt.4Enecessary to avoid recordiA Qs Ds w quote A ir ALs!!! vnewsbwB 6y On bE Go@@h0andl&a placeholde@rs(Len( +a}@C J .@;B i!F&K @OChr(34)A E& $/G eF!O '(= * 0>$ z7& 'BF#j5,4k3Tka  /searc`h(ent&,` star5V^,1%eV0_z2so2_mD>`<=mia C <4nD`ialogunv_dB`ZLispc.dt_lP( ! p3gkq.4^ w" > "k ((8+s) / 2),  ,1}5  y %d$o%S -B#6*n0rNlc?F6+ xo)))}KOi@t` vxlAq( #J_#j{?t`Dmula , xlR1C1qATU& ?/ r^sGw@Q1 P ji0c St`ub SLoad_|ok<>' userk`m0jP"ok"kl or  modelbhARhgrkHk, mcB+_answ Lk@osaqvar_done14BoaTdummy, vbac` iobjoa9ScreenUpdngp#&,OOFr?O_46P1G Do0XO' X@ Y?YKK"Or _c oRoReRaAdju ]_ l@fP"/#xTrub the_answer = MsgBox(excel4lang@uage.R e("solver_msg_5").Text, 33, , Application.Path & helpfile, 1830)  If x<> 1 Then %2Exit Sub EndC  ScreenUpdng FalseReset_all ( TQInStr(ThisWorkbook.DialogSheets("Save_d Edite f_arDea Cap, "!")?0tvbacode loadfunc&" "!arg1:=Chr(34)haV@oPPQRI^R bR3ELS7L Namefix``OmFyRecordMacro basicg:=>POn Error@ GoTo eobj_doFnAn?varF Each c In #Stylecheck###?gNot IsEmpty(c~)Q=+@E cB.mula@=Tmainstri( 0"." 8)Internal(xlDecimalSeparat orc dummy ."$Do Wh6 c`0Mid(i "?{ C= ELoop .0Left = "=MIN"EcE2obooO2nButtonoMin_bOValu6xlO~a Qw[T!mum_ldv@#*G}n`K(}6, LenH) - 6)$A Active~.AP!>sPs.AddrS`w'wH& ""!4typ", RefersTo:=2, Visible:= J 5meeopt~"3M??1Aress  A r_val 0 /( /(/(d ueof'C1?$O7& =, =AX=f =Boo=ax==d =!0=i, ==$ "=?/"O,O,O,r_6q6ng_ gJ?6oA r_MH166==== /(/(/(='==1a=/"COUNTAbi_gList7Qv? On Error GoTo loadep2  $ThisWorkbook.DialogSheets("So@lver_d(").Option@Buttonxthe=7`!C3OBE.If Le$ftq7)"=COUNTA" The?0  Applicaa.IenceStyle xlA1?W ?Adjustis~i49,!nh!O9'l_I_ #i'Con/?INTA/X [, 42VAR2/c}EsETrimD6(- 6oR/(WzLzeW3!D@im ol(do 11) As `I  T k?dkR"/ Next@/x7@Interntal(xlListSeparator)ko^7I2 ) +? S'1   1k < 10 s @=  7VG0" Exit 3Hdummy4V62(` 1OU`2c3c4c5uc6c7cR910tqGa? NIK> NGGoefeaddGDropDowQo*Index1_ MMSUM?MT b g?t> 01%iDropDo4wn?OListIndex@F3R-@&Left4) "=SUMn"Wy5^|"*- 5?_B<+`WH+%++++c+d++^P2@e?p=INT?.4WWO[gK[xintd[/M,> tMMRighOQ "))=1OQ/g @)[5 OOAAv?<bin q>0v0^- 1o>E ?;1/ 11oQ< p*)TSVTs_ F Tr/T/////@ /"=0x)+(Uj o_o&/?/?,, ,>>>//,?4;4((&&&&&&&& & {pq&&2?]/ ,"[*= Mid(mainstring, InStr(2, "=") + 5, Le"n) -`- 5) ThisWorkbook.DialogSheets(@"add_d").EditBoDxelhsCaption "6- 7ElseHRrR1*i3V3Vnd IfWIf Not Valid_ coA t(Fac) TheneMsg excel4langu age.Re("solver_ msg_6Te xt, 3@, Applica.Path & helpfile@, 1830E70'n'&ob@j_doneTruMO ,N&c! 'ScreenHUpd)ng Exit Sub loaderror: @>=3/8_LXLp$2$wi`b``03?= M_(D(c?;L?r_a_Rnd Ac\ #$ (x P`F0%:hO%`@- x6P@0(F@%:h,%`P- 6P@!f %:h,%`P-V5P% %:hW%`PXF5P": %:hE%`P-.5P:h]%`P^_5P `-d:hw%x"$ x dQdx(dF@%:hy%P-.6P@(dF@%:h{%P-.6P@/??>F@%:h}%P-.6P@(F@%:h%P-.6P@/MbP?F@%:h%P-.6P@% %:h%PF5P% %:h%PF5P% %:h%PF5P% %:h%PF5P% %:h%PXF5P% %:h%PXF5P% %:h%PXF5P u:hL%PW@  x"$ x | (&l*F'0 @ /x6 P@0,X`,xdP@0, _K::hM%x"$ @xX`#T_/Tx5X _b_Mh@X NX%:0O%@:D%x"$ x d@ -.)x@6 X K:0%:DO%@:h%x"$ x d@X-.)x@5X P _t @@'%:h#%x"$ @xXW $%"$ @ `#T_/T)x@6X K _Q_F0%:DQ%@:h%x"$ x d@X-.)x@5XSK:0%:DQ%@:h%x"$ x d@X-.)x@5X RK#T_ /T_:hT%x"$ @xX'XKF  S`#T_ /Tx6X Y_ 3F %:D,%@:h%x"$ x d@X- )x@6X U_ ;:h%x"$ @xXK#T_ /Tx5X _ C lU05Jf0%:D,%@:h%x"$ x d@X-V)x@5XN0%:DW%@:h%x"$ x d@uw{rU~}  ! 199=Y=)=a!>i>>>)? 0q?? 1 @ I@ a IA&y@y@i0@ AAAqAAAqA!BaBy BB!C!  9!YCC DADi%1iDQD)9 EIEiE$$E)%EEFaF ,i,,i--61//%//5-).Y.y.)&.q 31F FA ")#!GY!!aGy$G" H#IHy*HH*I1IY+qIIII y)JaJI JJ!KIK '%I''KKG LQL&L44LLM+AMa3A3iMMMNIN YiD  $  K|Vx"$ @xWXh] FXH H:h]/4x6XH\< x"$ x d l #q2 x, x"$ Hx  kxu:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$Ex"$ DxaXDD 0l)xD5Xyu:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$C4 'H%'X%x"$ x  4_x6XH4_ Hu:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$6 ,9_5qL__5qcP x"$ x t > FXH H:h]/4x6XH\@Q_@(h%_Xq lH  -H:]/46XH\; ,Q_@(h%_XqlH  -H:]/46XH\ ,_d ,4u:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$K1 x"$ x  k_x% x"$ x  x1 x"$ x  k_x( x"$ x < x3 x"$ x  lihtxK9t @x "$ xXTxK K::h%x"$ @xX`# _/ x5XK% x"$ x  x <    T0 'X%:h%x"$ x  x5X=% x"$ x  x TK4D:h%x"$ x dD!)xDK== " T0KdD'4%:h#%x"$ @xXWH$%"$ Da$`0)xD6XH4$400= th]/X\f q:h%%XWH :&4:'%$W :(`# _/ 6XH$4_<# *#**FH:h+%XW4 $:(" ):,%D:%x"$ x dD-W.x"h )hX`#T_2 T)xD6XH4$xhX_**FH:h/%XW4 $:(" )0F" )x`# _/ 6XH4$x q:h%%XWH :&4:'%$W :(`# _/ 6XH$4_<# *#**FH:h+%XW4 $:(" ):,%D:%x"$ x dD-W.x"h )hX`#T_2 T)xD6XH4$xhX_**FH:h/%XW4 $:(" )x '%'%x%0F%x"$ x p xh"X )XD`# _/ x6XH4$xhXD6 'X%_Fh%x"$ x  x5X4=0=th]/X\:h%%XWH :&4:0%$W :(" )4F4x"h )hX:$*D`# _/ 6XH$4xhXDQ_F:h'%XWH 4:($`# _/ 6XH4$_<# *#**FH:h+%XW4 $:(" ):,%D:%x"$ x dD-W.x"h )hX`#T_2 T)xD6XH4$xhX_**FH:h/%XW4 $:(" )0F" )x`# _/ 6XH4$x:h%%XWH :&4:0%$W :(" )X 'h%'x%$%4F4%x"$ x p XD" ):*`# _/ xr6 XH$4xhXDQ_F:h'%XWH 4:($`# _/ 6XH4$_<# *#**FH:h+%XW4 $:(" ):,%D:%x"$ x dD-W.x"h )hX`#T_2 T)xD6XH4$xhX_**FH:h/%XW4 $:(" )x '%'%x%0F%x"$ x p xh"X )XD`# _/ x6XH4$xhXD6 'X%_Fh%x"$ x  x5X C l10)% x"$ x  x 2 l30@ 4 l50|% x"$ x  x 6 l7007080?90?:0 C l70% x"$ x  x ;t l80;% x"$ x  x <t l90t% x"$ x  x =/:0 >:0 7T?0 8T l@0G:hA%XWH % x"$ x  x6XH% x"$ x  x " ,u:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$X BXW:C%D:h%x"$ x dDX-WH :]/4)xD6XH\OhP~'$%:C%D:h%x"$ x dDX-WH. DF4%"$ a)xD6XH4$'$%:C%D:h%x"$ x dDX-WH. DF4%"$ a`()xD6 XH4$Jx'X%0Fh%"$ xaHv"hx6XHJx'X%0Fh%"$ xaHv"lx6XH _'$%:E%D:h%x"$ x dDX-WH. DF4%"$ Q[_)xD6XH4$r$_WXFB_h5X*_WXG`# _l;/ 5X___sr:x'H%T DFX%"$ xx6XH'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'D%'X%'h%'x%'%'%'%'%'%'$%'4%'H% "$  l H*FX%x"$ x / x'6>p`P@0 XH4$xhXDM '4%:hI%XWH %x"$ x  x6XH4% x"$ x  x J T/6% x"$ x  x:x'H%T DFX%"$ xx6XH+_ x"$ x  x(fh% x"$ x  x+_ x"$ x  x.x'X%:hK%"$ xx5X9t @x "$ xXTx u:hL%XWH  x"$ x | (&l *F$'4 H / x6 XH4$u:h%XWH  x"$ x | (&l *F$'4 H / x6 XH4$  4' TxDXH4$xhXDp`P@0 ,KX-d:h%x"$ x dQd`xWt @x"XXF)x@5X < lY0Jf0%:D,%@:h%x"$ x d@X-V)x@5XN0%:DZ%@:h%x"$ x d@XXF)x@5X < l[0Ic0%:D,%@:h%x"$ x d@X-V)x@5XN0%:D\%@:h%x"$ x d@XXF)x@5X </G:D]%@:h%x"$ x d@X^_)x@5X dY:h`%x"$ @xX'XKF  SHdx6 X _$dc_$Mh@X a:DcX b %x"$ @x'KF S`#T_/Tx6X Zx'X%_Fh%"$ xa `F N`#T_/Tx6X _JxGx'X%_Fh%"$ xa `#T_/Tx6X _$Mh@X a:DdX b %x"$ @x'KF SH_x6X __$Mh@X a:DeX b %x"$ @x'KF S`#T_/Tx6X _Mh@ fK gxx hxZx'X%_Fh%"$ xa `F N`#T_/Tx6X $ gxx hlx C_Fhx"$ @xWX$ U_&x5X_& __F0:hix"$ @xWX$ :Dj(]<x6X \ [_F0:hix"$ @xWX$ :DjU_&x6X _& x"$ @xW $_&_Mh@X X_J_&iD (0"_M@  `#T_/Tx6 X[_F0:hix"$ @xWX$ :DjU_&x6X   _& x"$ @xW $_&_Mh@X X_J_&iD "_M0@  `#T_/Tx6 XC_Fhx"$ @xWX$ U_&x5X B:Dk]X h%x"$ x  X< x5X\ "_k_&_& U__&X h%x"$ x  X`#TO/Tx5X"_k_& _Jx_$Mh@X a:DeX b %x"$ @x'KF S`#T_/Tx6X T_FDx"$ @xWX$:hl (0]<x6X \__F0:hix"$ @xWX$ :Dj(]<x6X \[_F0:hix"$ @xWX$ :DjU_&x6X |x"$ @xWX$_J_&ihX (D"_M0@  `#T_/Tx6XP_FDx"$ @xWX$:hl U_&x6X sx"$ @xWX$_J_&ihX "_MD@  `#T_/Tx6X_3#T_/Ti_@:D7%@:hm%x"$ x d@Xn o`#T_0/T)x@6X _q5:hp%XW `#T_/T6X q_0_5:hr%XW `#T_/T6X q_0__&*#T_0*#&*F _Mh@X bX`#_(2T6 X_$v:D]%@:h%x"$ x d@X^W t U++_( sU_,)x@6X  _,_,(W_(@:D]%@:h%x"$ x d@X^u )x@5Xe_(@_,@:D]%@:h%x"$ x d@X^u v)x@5X_$dXK-@:hw%x"$ x dQ@xt:hx%x"$ @xX'XKF  SHF%:Dy%-.x6X t:hz%x"$ @xX'XKF  SHF%:D{%-.x6X t:h|%x"$ @xX'XKF  SHF%:D}%-.x6X x:h~%x"$ @xX'XKF  SHdF%:D%-.x6X K/MbP?F %:h%X-.6X t:h%x"$ @xX'XKF  SHF%:D%-.x6X K::h%x"$ @xXK#TU0/Tx5X%D%:h%XF5X%D%:h%XF5XK::h%x"$ @xXK#TU=/Tx5XE%D%:h%XF5Xl%D%:h%XF5XK::h%x"$ @xXK#TU0/Tx5X%D%:h%XF5X%D%:h%XF5X::h%x"$ @xXK#TU0/Tx5X`%D%:h%XF5X%D%:h%XF5XK::h%x"$ @xXK#TU0/Tx5X%D%:h%XXF5X%D%:h%XXF5Xa%D%:h%XXF5X%D%:h%XXF5X::h%x"$ @xXK#TU0/Tx5X%D%:h%XXF5X%D%:h%XXF5X6%D%:h%XXF5X%D%:h%XXF5X::h%x"$ @xXK#TU0/Tx5X%D%:h%XXF5X%D%:h%XXF5X %D%:h%XXF5X%D%:h%XXF5X u:hL%XW T x"$ x | (&lT*F'  /Tx6 X -@:hw%x"$ x dQ@x(dF %:hy%X-.6X (dF %:h{%X-.6X /??>F %:h}%X-.6X (F %:h%X-.6X /MbP?F %:h%X-.6X %D%:h%XF5X%D%:h%XF5X%D%:h%XF5X%D%:h%XF5X%D%:h%XXF5X%D%:h%XXF5X%D%:h%XXF5X  _ 0< Tx@X 0d:h%x"$  x dQdx0d:h%x"$  x dQdxP\ x"$ x t >\FL< <:h]/,x6L<\ T T-(x"$ x 0l(xsu:h%LW< \ x"$ x | (&l\*F', < /\x6 L<,$x"$ @xWL$x$x"$ @xWL$x3( x"$ x  l(ihtx':hiL(]<<\bLUc/(Lkb< S<:i]/,6L<\tkb:h bd. p $ ,\xdL<,LK9,TD(4$" 5$fTDUc/(Dkfl$ S$`#kfl ;/6D$(kfl FT]"D )D/$5D\>"D )D"$ )$`#kfl ;/6D$ fdKChfTDUc'lhkfl *1h fd  lhFTl :Tl xL89lh  D$p bF$]l@:D]%T:X%h"$ h dT4^oc)hT64\ DXlDXlnF]j$%:D]%T:X%h"$ h dT4^op)hT64\8-l+l4 s4lg-+ll4 s4lp(gl hT4Kth]/X\.  h1xS$ '4%'X%D% h%T"$ T p $`1xT6X4$  h1xX(xTX4$080K/% x"$ x  xhd:h%x"$ x ddWTW$.:D%4W /)xd6T4$\ -:D]%d:h%x"$ x ddT^W4t(]<$:E%:%"$  d-W.:]<)xd6T4\% x"$ x  x~:h%TW4  x"$ x | (&l*F'$!4^_L/x6 T4$_L% x"$ x  xfT 5Tj:D%d:h%x"$ x ddT-W4.:l$(]/)xd6T4\:h%TW4 :D&$:%W :(" )x:%d:%x"$ x ddh-WX.H"8 )8(`#_h/)xd6T4$hxXH8(w:D%d:h%x"$ x ddT-W$."4 )4(]/)xd6T$4\:h%TW4 :D&$:%W :(" )x:%d:%x"$ x ddh-WX.H"8 )8(`#_h/)xd6T4$hxXH8(:h%TW4 :D&$:%W :(" )x:%d:%x"$ x ddh-WX.H H8"( )(`#_h/)xd6T4$hXxH8(6 'T%_hFh%x"$ x  x5TK- _l _T'%:D%d:h%x"$ x ddT-W4. DF$%"$ Q[_<)xd6T4$r-_< z-K-8_<WT:hq4(D]/$5T\x-$_<WT`#_8/5TB:Dk]T h%x"$ x  T<4x5T\;&_8kih_X_X(h]_4 cT h%x"$ x  _PFDT4($"_PM@ `#_4_p;/x6TM'T_4_pJ_PMh@4 S4`#_P/6T4n_PFDT h%x"$ x  T4(]/$_4 'x5T\_P_4_p;_P_4dx_PM@ _p@M@ _p@M@ _p@M@_p@M@_p@M@_p@M@_p@M@_p@M@_p@M@_p@MD@_p@Mh@T 4T_X5T-j-"_8K(%:D7%d:h%x"$ x ddTn)xd5T/_8Mh@T T:D]/45T\_8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8iT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4 _8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8iT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4fT4 4$6T4\u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$j-"_8J#K(%:D7%d:h%x"$ x ddTn)xd5T/_8Mh@T T:D]/45T\}!_8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8iT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4"_8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8iT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4fT4 4$6T4\E#u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$j-"_8Y'K(%:D7%d:h%x"$ x ddTn)xd5Th:hp%TW$ %:%d:D%x"$ x dd4-.)xd6T4$/_8Mh@T T:D]/45T\2&/_8Mh@T  T:D]/45T\%K(%:D7%d:h%x"$ x ddTn)xd5Th:hr%TW$ %:%d:D%x"$ x dd4-.)xd6T4$|_8J iT _8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4-&|_8J iT _8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4&_8qiT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4fT4 4$6T4\T'u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$j-"_8Q)K(%:D7%d:h%x"$ x ddTn)xd5Th:hr%TW$ %:%d:D%x"$ x dd4-.)xd6T4$_8qiT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4fT4 4$6T4\L)u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$j-"_8q,K(%:D7%d:h%x"$ x ddTn)xd5T/_8Mh@T T:D]/45T\&+_8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8qiT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4X,_8J_8qiT_8q_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4_8qiT_8Mh@4 S4%:%d:%x"$ x dd$-.)xd6T$4fT4 4$6T4\,u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$j-u:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$ _l_<s% x"$ x  x_l-._T-/% x"$ x  xu:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$% x"$ x  xu:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$% x"$ x  xu:h%TW4  x"$ x | (&l*F'$ 4 /x6 T4$u:hL%TW4  x"$ x | (&l*F'$ 4 /x6 T4$80,/\xdT4$xhXH8(CrU $ `y$ `y$ `$ `y$! `y(I `ya/0q ` y0&&( `ya/$ `y prU 0 ` y/&0 ` y/&0 ` y/&, `y,! `y,I `y9QSolver4__SRP_a<}__SRP_baThisWorkbook q ME9  B  1( %8HVP p (  (.9  0 8HX` h  (  (  ( 0 (8HP Xh   (  B M M    ( 8 .9@ p        `  X (` px(S  !p^XL   0 !8 (H X`h p6   ( <   (  (%0HX !`pp^^@ L  !  (     >q( h p  x  B     1  %   V    ( 0 8 @ H  `  (h x   .9            x Dk@%DUX@> LL   LL"L<\<`+b`` h 8do@ i\ `i^i` @\ @L +f`  To  i\ @U 'i^`i`  14`jX`h'b`f(@T @D +jH`(PoH }}i\ hi^'bi` X 14`j%`h`f``'` \$@L $+rh`(#k EExin `ip  14`"j `$h `&f V `ddj @T .@D +v`p&k um in 8ip  14@\ lhs+~`X(oP  izp'i|( $P 14`(h`f' `  B@@P ' @@ !sol8 X x +`+o ((si  14@\ `,B`@ @0 `*,`( `@ !V` +`-xo LLi (i Hi( hi  14@\ + `0k i  i 0 i  P i  14@,1\ @L + `2k  i  i 0 i P i p i  i$  i(  i,  i0  i 4 0 i8 P i<  14@ \ + `p `64k  14@\ + `x p 7o@ ..i  14@@ H + `x 9o HHi  ip:  14@H `2@ `  Xh H   $ 14 @``H0`bl R@H 8@F @4 @x$ @ @8 @ @  @ PT:.@h @ @P @ @ @ @ @ @ @| ( @x @(h @ @@X @XH @p8 @( @ @ 8!@ @ @ @ @0 @H @` @x @x @h @@X @H @8 @( @  @8 @P @h @ @ @ @ @ PN8>@ h$@8 @t @d 86@P @`(`fl  $R@X@ @> X%@, @%@@ @p p%@ %@ %@ @ PT:.@0 @H @ '@ @( @` @x @| @x @t @xp @` @P @ @ @80 @P @h 24@ @ @ @ @ @ @ @( $@@ @Xp @p` @P @@ @0 @ @ @ @ @0 @H @` @ @ @ PN8>@ @ @ @@ @Xt @pd @T 66`0Hh`h!`!x`jl h!`R@H @F @4 @$ @0 @ @H @ @! PT:.P@ @ @ f@P i@! @  @8 @ @h @| @8!x @h @X @H @8  @( @( &@@ @X @@p @ @ @ @ @ @ @ x @0 h *@H X @` H @x 8 @ ( @  @  @ @ @! @ ! @P! 4@ G@ @! !h!C8@" H"!C xN8>6@X" 8@" @"| @0"l @\ "!O@p"X @T @"R ""b@P ""b"l4 #P8&$P$8$ $$(%%%#(&#`rl @%#8R@@  @> @$, R@h$ @$ @$ @$ @ @@& @$ @ #:&8>@P% h%(%@_ x%P% %P%L@% P %%#L@ %%l @ &%%P@ %6L@X& @ ''P'''h'''('`vl 'H 8@X R@V @((D @'4 @'$ @  8'>6 R@( @@( @ 0@ p P*8))h)P)+)(*)`~l )(nR@)< @: @)( @ @) @  @8* P*)@* @ * @* @`* x*8*@+ +`* )PNZ8>6@* @*  @ @  (+`*@8+ LP++@p+ `+8+|+8+ @+ |+p+@ +++@ 8hP-,(-,,,X-,`l ,sRPj@p-X @V @-D @ @@- @- ,8>6@ @ @- @- @ T.Hh/.(/...0.`l .RPT:@00X @V @X/D @@ @@/0 @/ @p/ @/ @/ @/ @/ @ @0 R@H0 .8>@`0 @0 @ @x 06Rp 0 P (21211111`l 18>6@H h@F @24 R@@2$ @  @X2 @p2 @2 @ @  P 0 X3  P p 0 43433X3H6p3`l RX3R @@4X @V R@3D @34 @p4$ @(4 @X4 @85 @4 @4 @4  @5 @4 R@ @5 @ R@ @ 38>6R 7@77p7X77(77`l 7jR@X @V @D @4 p @888888@89X8`l @8zRP@p9h R@9X G@F @94 @0 h8:8>@(9 @@9 @X9 @9 @ @ @ 860  H ;::::;p:;:`l ;p:zR@h @(;X @F @@;4 @ @X; @ @; ::8>6&@; @0< p;>TP@; <;@_ <;;@H< @`< @x< @< @<t @<d @<T @<D @=4 @ =$ @8= @P= @h= @= @= @= @= @= @= @> @(>t @@>d @X>T @p>D @>4 @>$ @ 3  (( 8 @ H  X  (` p x    (      (        ((  8 @  H  BP  Mh    M      (-        08@ HX``   ( (S( 06@  x ( <   ( % (i@         (( 8@ H P ` (hx !X !  ( >q(hp x B   1 %V  ( 08@H ` (hx.9     ((8@H X (`px  (  (  `(   ( (S  i8         (  0 8 @ H  X (` px.9    (8 [@`h >D :{ P @X     ((8@ !HLX0 !@ P (Xhp>qx  B   1 %(8$,@ h (x % )  ( 60  PX` hx0     %0 8 H P X ` h p x       (   >q( h p B x    1  %  $,    ( !!#!0!8! @! (H!X!`!>qh!!! B !!!! 1! %"" " 0" (@"P"X"`" x""" %"";""" ""5"# #(Q#@#*[H#x#(Q##(Q##*[#$2f$P$@h$ $ $$2f$%@% X% `%p%2fx%%%@%& &  &0&8&*[@& $p& &  &&&&*[& $& &  &&''*[' $@' P' X'h'p'x'*[' $' ' ''''2_' $(( 8(  @(H(P(X(2_`( $( (  ((((2_( $) )  )()0)8)0_@) $p) )  ))))0_) $) )  ))**0_* $@* P*  X*`*h*p**[x* $* * ****2_* $ + 0+  8+@+H+2P+ (`+p+x+>q+++ ++ B +++ 1, %, ,,(,X, p, (x,,,,.9, ,, ,,-- - ((-8-@- H-0BX-4I--- - (---<q-8.@.>qH... B ... 1. %.....9/ 0/@/ H/X/h/p/  / (/ /////=/  / (0 00 0$=(0  P0 (X0 h0p0x0  00&0  0 (0 0000 1 (1 1(101.981 h1x1 11111>1 1 (1111 !2X2Xh2F|2F|3 !P3 `3 (h3x33>q333 B 3333 13 %44 4 @4 P4 (X4h4p4x4 4 (444>q444 B 455 15 % 50585@5 &`5  5 (5 5555 &5  5 (5 666 6,@6  p6 (x6 66666 662-6  07 (87 H7P7X7`77 772-7  7 (7 888 8@8 P8`8h8 888  8 (8 88889 9(909 H9X9`9  9 (9 99999 999 : :(:  H: (P: `:h:p:x:,:  : (: ::::; 0;H;2-P;  ; (; ;;;;,;  < (<  <(<0<8<X< p<<2-<  < (< <<< !<=H(=p=x=H===P>X>`> > F~>> F~>(?0?8? X? F~h?? F~?@@@H0@x@@H@@@HAXA`AVAAA B F~BXB F~`BBBBPB(C0C PC F~`CC F~CCD !DD D ((D8D@D>qHDDD BDDD 1D %DD D D (DEE E E B (E0E '8EHEPE 1XE %hExEE E (EEEE.9E EF F F(F0F HF (PF`FhFpF>xF F (FFF0BF4IGHG PG (XGhGpG.xG 'GGG>qGGG B HH 'H H(H 10H %@HPHXHhH0[HH$HHHH H II I(I=0I %HI>qXI (I IIIFIFIJ0J J8J PJ `J %hJ,xJ&JJ %JJ JJ JJK K (K0K8K@KHK8PK (hKxKK>qKKK KKK.K 'L L(L 8LxhZ !'ti (eWA@ !n  ! V('b@  (shh`vX \$ \$R'b  (s a \$Range \U $P$T \!X'\h \U '\_1 8 \$P'\vh ^$ ^$R'b  ( s`hX \$T_m'b  ( s(h ^$'b  (sh ^ ^ 'b  (sh ^ `$ `$R'b  (s`aX.  % `  %}' _. `  `  %}'h `$ `$Range `U $P$T `!X'`hx `U '` `$P'`vPaH `U'`h0h(h ^  solver_adj %!$:!V \$: solver_adj %!$:$.!V'b  (shhx'h solver_num %U $'v8 ^  (      !"#$%&'()*+,-./012345679:;H=>?@ABCDEFG8IJKLMNOPQRSTUVWXYZ[\]^_`ab