ࡱ>   [7$%Root EntryRoot Entry F;k/CompObjfWorkbook _VBA_PROJECT_CUR"k9k  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~SummaryInformation(xDocumentSummaryInformation8VBAk9kPROJECT  !"#$%&'()*+,-./023456789:;<=>?ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`abcdefgijklmoqrstvwxyz{|}՜.+,D՜.+,\HP X`hp x :  Excel4Functions LanguageScenario_dialog Save_dialogOptions_dialog Add_dialog Show_dialogFinish_dialogSolver_dialog Excel 4.0 MacrosDialogs$Oh+'0H PXp ( 4@Solver Add-InxMicrosoft Corp.`A tool that helps you use a variety of numerical methods for equation solving and optimization.Microsoft CorporationusMicrosoft Excel@c@q1l_ FMicrosoft Excel WorksheetBiff8Excel.Sheet.89qPROJECTwmdirSolver1 Solver2& J@ Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&Windowhf  SOLVER.ADDcell_ref,relation,formula  SOLVER.CHANGEcell_ref,relation,formula  SOLVER.DELETEcell_ref,relation,formula  SOLVER.FINISHkeep_final,report_array SOLVER.FINISH?keep_final,report_array  SOLVER.GETtype_num,sheet_name SOLVER.LOADload_area ) SOLVER.OKset_cell,max_min_val,value_of,by_changing ) SOLVER.OK?set_cell,max_min_val,value_of,by_changing }SOLVER.OPTIONSmaxtime,iterations,precision,assumelinear,stepthru,estimates,derivatives,search,inttolerance,scaling,convergence,assumenonneg SOLVER.RESET SOLVER.SAVEsave_area  SOLVER.SOLVEuser_finish,show_ref\pMicrosoft Corporation Ba=  ThisWorkbook=J-&< X@"1Arial1Arial1Arial1Arial1Arial1Helv1Helv1Arial1Arial1 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_-;_-@_-"F"\ #,##0_-;"F"\ #,##0\-#"F"\ #,##0_-;[Red]"F"\ #,##0\-$"F"\ #,##0.00_-;"F"\ #,##0.00\-)$"F"\ #,##0.00_-;[Red]"F"\ #,##0.00\-;6_-"F"\ * #,##0_-;_-"F"\ * #,##0\-;_-"F"\ * "-"_-;_-@_-,'_-* #,##0_-;_-* #,##0\-;_-* "-"_-;_-@_-C>_-"F"\ * #,##0.00_-;_-"F"\ * #,##0.00\-;_-"F"\ * "-"??_-;_-@_-4/_-* #,##0.00_-;_-* #,##0.00\-;_-* "-"??_-;_-@_-                       A  A  A 0     A 0UU      A     8   8 A 8U A 8U A 0U A 0UP A 0U A 0U@ @  8U@  8UP@ A 0U@ A 0UP@  8U@ @  (UP@  A X   A 0U  A 0U  A 0UP  A 0UU    8  8   8   8P  8   8P  8P   8P   8P   8PP Normal_SOLVER (2)8 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`aScenario_dialogbh Save_dialog8oOptions_dialog֎ Add_dialog" Show_dialogc Finish_dialog Solver_dialog VBA_FunctionsTExcel4FunctionsLanguage   __Command`XA$@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 assumenonneg BarOpen: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 Finish_okGetDef:  inttolerance iterations keep_finalload_arg:P Load_helploadarg1:Loadfunc: Main_help max_min_valmaxtime MenuUpdate:y 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 report_array 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_of8H b'  3  @@  >Start of solvercallitemxywidthheighttext init/resultShow Trial Solution>Solver paused, current solution values displayed on worksheet.ContinueS&top&Help&Save Scenario... 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 EnglishToolsR17C2R17C3R17C4R17C5R18C2R18C3R18C4R18C5R19C2R19C3R19C4R19C5R11C2R11C3R11C4R11C5R12C2R12C3R12C4R12C5R13C2R13C3R13C4R13C5R14C2R14C3R14C4R14C5R23C2R23C3R23C4R23C5R24C2R24C3R24C4R24C5R25C2R25C3R25C4R25C5R17C6R17C7R18C6R18C7R19C6R19C7R7C4R8C4"4,5"xladdin.chm!1836xladdin.chm!1835R7C3R8C3R5C3R6C3 7G GW)HIK]LrNG\P1 7Q Rb VT+ #VWWjWbX7]Y2YZZ\ [r\GD]] ^o^D^/_o_D__/`m`B J@ b  dMbP?_*+%i&A Page &P"P??U<$(  r  04A@A@ 5]@4A   <Save Scenario<   s FAA@Scenario_name 3 ]& `A     D4A?OK_button]*4A B ԧA#m $ <OK< ff  c $A?&]AX  $<Cancel< ll  s *A?(3],ABA9l $H<Help< rr  0A@A@) ]@A <Scenario Name: < >"@ J@ /i  dMbP?_*+%i&A Page &P"P??U2 (  r  0A@A@ 1]@A  < Load Model< rr  0XA@A@# ]@XAX <Select Model Area: < ~~  s <AA@The_area 0 ]& `A  < $D$5:$D$8< $C 9ظ  DXA?OK_button]*XAxB A#h $ <OK< ff  c $̮A?$]̮A $<Cancel< ll  s *A?&0],A,BA9. $H<Help< >"@ J@ p  dMbP?_*+%i&A Page &P"P??9U0 & (   r  0A@A@I,]@A@ <Solver Options< rr  0A@A@# ] @A T < Max Time:< ~~  s <tAA@Max_time&+ ]& `tA  <100< u ilrr  0ijA@A@ $] @ijA I < Iterations:< ~~  s <(AA@Max_iter& -]& `(AP <100< t drr  0xA@A@$] @xA P < Precision:<   s >ܴAA@Precision&3]& `ܴA < 0.000002< t olrr  0,A@A@%] @,A e < Tolerance:<   s >AA@Tolerance&2]& `A <5< el, rr & 0A@A@&]&@A@  v <Convergence: <  % s BDAA@Convergence&3]& %`DA  <0.0003< ualy  PA@A@Assume0I]6 Ap! MM "<Assume Linear Model< d $ RA@A@non_neg0"%]6 $A" gg "<Assume Non-Negative< j  TXA@A@auto_scl1II]6 XA # UU "<Use Automatic Scaling< i  VA@A@Show_iter1H"%]6 A$ RR "<Show Iteration Results< mxx  6AA @#(+]$@A$  < Estimates< .   R|A@A@Tangent$&'%]H |AL% a Aa "<Tangent< (  VA@A@Quadratic'&*%]H A<& Q PAQ " < Quadratic< / xx  6DAA @)#7+]$@DA4'  < Derivatives< 6   RA@A@Forward*$5'%]H A' F AF "<Forward< (  RA@A@Central*'5*%]H At( C AC "<Central< #xx  6tAA @8#F+]$@tAl) <Search< !  PܺA@A@Newton9$E'%]H ܺA) N AN "<Newton< %  VDA@A@Conjugate9'E*%]H DA* o Ao " < Conjugate< 2   DA?OK_button8G ]*A+HB A#S $ <OK< ll  s *A?8 G]*A+`B ,A#Q $<Cancel< ll  s *8A?8G]*8A-xB ؼA#[ $L <Load Model...< ll  s *A?8G]*A.B A#^ $S <Save Model...< ll  s *A?8G]* A/B 0A#R $H<Help< rr  0A@A@,5 ]@A|0 <seconds< rr # 0PA@A@26]#@PA0 <% <   >"@ J@   dMbP?_*+%i&A Page &P"P??U @ (  r  0\A@A@'["]@\A5 <Change Constraint< rr  0A@A@(:]@A 6 R<Cell Reference:< tt  s 2 AA@lhs(<]& ` A6 < C$5:$C$8<     L@AOptions=D]r @7B \A9<==>=intbinrr  0A@A@EIIUI]@A7 C < Constraint:< tt   s 2AA@rhsEYn]& `A8 <5<   DA?Ok_button(2!]*A 9B $A# $<OK< ff  c $A?5?!]A9 $ <Cancel< ll  s *A?BL!]*AX;B DA# $A<Add< ll  s *PA?OY!]*PA0< B A# $H<Help< >"@ J@   dMbP?_*+%i&A Page &P"P??#ULP4(  r  0\A@A@ A]@\A> <Show Trial Solution<   PA@A@Show_message3 ]@A(? ><?Solver paused, current solution values displayed on worksheet.< >||  :hA? Cont5? ]*hAx?$B A# $ < Continue< ||  :A? Stop5 ?]*A0@<B A#@ $ t<Stop< ll  s *A?5?]*A`ATB `A#A $H<Help< ll  s *lA?!]*lAClB  A#_ $S<Save Scenario...< >"@ J@ 0  dMbP?_*+%i&A Page &P"P??#_U` (  r  0xA@A@ I]@xAH <Solver Results<   RA@A@Final_message7 ]@ATH R<SSolver found a solution. All constraints and optimality conditions are satisfied.< R  ^PA@A@Keep_solution&I]H PAH K AK "<Keep Solver Solution< b  `A@A@Restore_values'I]H AI O $AO "<Restore Original Values< orr   0A@A@7 B ] @AJ R<Reports<    F@AReports7 GI]_ K Answer SensitivityLimitsll  s *XA?]*XAKB A#( $ <OK< ll  s *A?']*ALB A#& $<Cancel< xx  6tAA @)]$@tAN  ll   s * A?):]*  AlNB A#_ $S<Save Scenario...< All   s *A?<G]* AOB \A#' $H<Help<   >"@ J@ l  dMbP?_*+%i&A Page &P"P??#'U p (  r  0A@A@N)]@AT <Solver Parameters< rr  0A@A@  ]@AT e<Set Target Cell:<   PAA@Optimum_Cell * ]6 `AUB hA#; <$A$5< 2.ll   ^ A@A@Max_button !%]H  AV M \AM  "<Max<    ^A@A@Min_button! (%]H AV n An  "<Min<    bA@A@Value_button) 5%]H AW V AV  " < Value of:< + ~~  s <DAA@dValueOf5 ?]& `DAX <0< valaxx  6AA @B(]$@A4YB <By Changing Cells:< Y  X0AA@"Adjustable_Cells4]6 `0AZB A#   ll  s *A?6@]*AZB lA#Z $G<Guess< xx  6"@ J@&A Page &P"PDe Sc?? S> P @J@ @x<e/;]emu}a  dMbP?_*+%&f Page &pMHP LaserJet III  dLg_);N}w;}d)A"d??U} I} $}  } } } } m} } I} Ix            0 0      0 0 0 !  "BT  "# CB        #BT 3 445P{@5S@ 5~ 6@ "# CBAB$7@@@ s@ @@  8 %#@#B Al7?t@@ W@  8 #A7@t@<@ W@  8 $ #BB778@t@J@ W@  8 9@: @:J@;b@; ; < ' % CellTxtBQ  % # SheetBQ 3 44 5s@5Q@ 5~ 6@1 # CA B7B 7@$@@     8$ # CCpB 7@$@3@ q@  8< $&C)A # #)"B7 7?$@E@ V@    87@[@E@ V@  8)& show_caseBQ98@:i@:E@;V@; ; <)BT 'B`#' C"B=''@=C"(Cs)#xB`'&'@CxA&B7'A/'#z#yCsBAl -'B+'tmp_Echo(ABX@@0'CDA& BWB $?'@#tA $?0'CDA& BWB $?0'CuA& B7B $?1'Cu  B7B $?@??1' Cu  B7B $?@??D6 l2BpwkqXGwwZNq8!'A*AKjXjjk !"#$%&' (0)*+,-./ 001234567 809:;<=>?! '! #nAl $ ?@??+!'"tmp_Echo(ABX !$!?@??0"'#CDA& BWB "~ "? ""#'$#kA #~ #? ##0$'%CDA& BWB $$2%'&CiA& #wA5B %%&&''#m9nB &&'()#wA5 ''( ((()/*set_cellBQ ))+*0+ max_min_valBQ **(+0,value_ofBQ +++,0- by_changingBQ ,,8-0 ."set_cellBkB=Bx$A$8 --;.0 /% by_changingBkB=Bx $A$1:$A$7 ..;/11%#9#?#2@#H#>"B7 // 00(1/2set_cellBQ 11+203 max_min_valBQ 22???(304value_ofBQ 33???+405 by_changingBQ 44???8506"set_cellBkB=Bx 55???;607% by_changingBkB=Bx 6~ 6? 66??719)#:#=#2@#H@#<"B7 7~ 7? 77? 8~ 8? 88?'9/:maxtimeBQ 9~ 9? 99Y@*:0; iterationsBQ :~ :? ::?);0< precisionBQ ;~ ;? ;;?,<0= assumelinearBQ <~ <? <<?(=0>stepthruBQ =~ =? ==?)>0? estimatesBQ >~ >? >>?+?0@ derivativesBQ ?~ ?? ???Dl[etbdfZR:\_\_wo0\_\_l@knmplm@ABCDE F0GHI J0KLM N0OPQ R0STUVWXY Z0[\]^_&@0AsearchBQ @~ @? @@?,A0B inttoleranceBQ A~ A? AA?'B0CscalingBQ B~ B? BB?+C0D convergenceBQ C~ C? CCi@,D0E assumenonnegBQ D~ D? DDi@sE1G]#;@#3@#+@#U@##?#%#!#o#*@#j##" B7 EE@? FF@?+G/H user_finishBQ GG@?(H0Ishow_refBQ HH@?-I1K#>#G#v"B7 II@? JJ@?)K/L save_areaBQ KK@?9L0 M# save_areaBkB=Bx "$H$5:$H$60" LL@?(M1O#=#e"B7 MM@? NN@?)O/P load_areaBQ OO@?9P0 Q# load_areaBkB=Bx#N/A PP@?(Q1S#8#-"B7(S/Tcell_refBQ(T0UrelationBQ/U0VformulaBQ8V0 W"cell_refBkB=Bx#N/A:W0 X$formulaBk"Bx=Bx12.45.X0 YCB=Bx12.456Y1[ #{##`#@"B7([/\cell_refBQ(\0]relationBQ/]0^formulaBQ8^0 _"cell_refBkB=Bx#N/A:_0 `$formulaBk"Bx=Bx12.45D ljpkop0_\a0]\0]x,,,3GJ>:,,3G`a b0cdefghi j0klm n0opq r0stu v0w0x0yz{|}~.`0 aCB=Bx12.452a1c#|##`#"B7(c/dcell_refBQ(d0erelationBQ/e0fformulaBQ8f0$ g"cell_refBkB=Bx#N/A:g00 h$formulaBk"Bx=Bx12.45.h0< iCB=Bx12.45:i1k$#}#@#`@#"B7*k/l keep_finalBQ,l0m report_array@BQ-m1o#5#,#a"B7*o/p keep_finalBQ,p0q report_array@BQ-q1s#6#,#a"B7(s/ttype_numBQ*t0u sheet_nameBQ-u1w#7#E#q"B7#w2y #<"B7'y+*z C3C4B%z'{C4AA&B+{'|@ C3C4B0|'*@}@ #3#2#4B}'~A1~'*@@ #3#2---B'ADl>6,,3GJ>>.01.01,.1'+)/45 0  0#l $BBABsM :Solver Add-In \SOLVER32@B@SolveIEB#t $BBABsM :Solver Add-In \SOLVER32@B@ SolveRestoreAIRB,B7&CA)CdA*B7 "" uvwuvw Z( >@????m0.00000L0p0(/0pXPX`hpxqq      @J@ ,>N  ^:  dMbP?_*+%&A Page &P"PD??U} #D                   ! " # $ % & ' ( ) * + , - . / 0 1 2 3D@l !"#$%&'()*+,-./0123456789:;<=>? 4 !5 "6 #7 $8 %9 &: '; (< )= *> +? ,@ -A .B /C 0D 1E 2F 3G 4H 5I 6J 7K 8L 9M :N ;O <P =Q >R ?SD@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @T AU BV CW D.X EY FZ G[ H\ I] J^ K_ L` Ma Nb Oc Pd Qe Rf Sg Th Ui Vj Wk Xl Ym Zn [o \p ]q ^l _mD@l`abcdefghijklmnopqrstuvwxyz{|}~ `n ao br cs dl em ft gu hv iw jx ky lz m{ n| o} p~ qp rq sl tm u v w x y z { | } ~ D@l  r s l m             k    f l  m  l   m  D@l        k*                          Drl B                             >0>@ VBA_FunctionsVBA_FunctionsThisWorkbookThisWorkbookSolver1Solver1Solver2Solver2Solver3Solver3Solver4Solver4ID="{CE5F7934-48A9-11D0-AC43-00A0C91BBF12}" Module=VBA_Functions Document=ThisWorkbook/&H00000000 Module=Solver1 Module=Solver2 Module=Solver3 Module=Solver4 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} HelpFile="" Name="SOLVER" HelpContextID="0" VersionCompatible32="393222000" CMG="ADAF752A8FD393D393D393D393" DPB="5A58829D22AA22AA7568B2B07377B0B96658FB581C" GC="0705DF7021B0CFB1CFB1CF" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] VBA_Functions=66, 66, 663, 385, ThisWorkbook=0, 0, 0, 0, C Solver1=-2, 5, 601, 353, Z Solver2=-38, 42, 502, 421, Solver3=5, 6, 468, 320, Solver4=22, 22, 541, 386, <jx#<`_˄FSolver3 lSolver48__SRP_0 EC__SRP_1Z__SRP_2 __SRP_3~! __SRP_4\v__SRP_5u__SRP_6p__SRP_7nB__SRP_8ޓ__SRP_9ha__SRP_ay__SRP_bY__SRP_c@__SRP_d1ThisWorkbook_VBA_PROJECT'VBA_Functions& Q!xME(6 < <x+` \k@ i `ii I N 14+ P`H \k i i(age i   at  14+$` \k i  in ii  14+(`x \k8 i* Xi,  14+0`( \k  i* i,  14+4`0\kH $i6hi8  14+<`8\k (i>  14+B`@\k8 ,iD XiF xiHX iJ  14+N`H\k 0iD  iF @iH  `iJ  14+RP `HP\k 4 iT iV iX (iZ Hi\ hi^$ i`( ib, id0 if4 ih8 (ij<  14+n `X\k 8 14+r ``\k <it  14+x `h\k@ @iz `i|  14PP % @` `l  @\ ( ` l  "@\  `$l  &@\ X8 `(l  .@\    `0l  2@\ hH `4l :@\ (`<l @@\ x80`Bl L@\ @`8 `Nl P@\ (h(H@(`Rl l@\ H0`nl  p@\ P8`rl (v@\ @`X@ `xl 0~@\  3$*\Rffff*0<37ff36c8$*\Rffff*0;37ff36b9G  P >X P P *8 Rh L  F0 xB  B  B  B  B  (@ B HPh B px B  B  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$ at A197, including parametersK On the Excel4Functions sheet, the user functions are outlined in blue, andE 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.   $'iX   $"' i0P   $&'$i * ,$.'(i * ,$2'0i 6 8$:'4i >$@'<ip D F H J$L'Bi@ D F H J$P'Ni T V X Z \ ^ ` b d f h j$l 'RiP p'ni t$v'ri z |$~'xi`XQAttribute VB_Name = "VBA_Functio ns" OpD ExplicitX' this module contain s allA fLe use@rs can in(ir macros. ' TLOthe place where localizashould tak$:NOTE: For ,to work with recordings,R nsC {:@ ?` , 8Load(AArea'bY? _UZUA VO bOk&Setc bMaxMinV6P@ueOgv8ByDPiOOk//*Ok , F ,pp}Of, , 5yQ~Ok |(??e?>ҭsG% Ti[ (IBsO'nPisAssumeL arStep0ThruEs@timateoADeriv v#SearchC!KToleranP/ S1GCongeT_NonN|egP3 s####, , ,P GS, , H@nt|, C**Reset(2RSave(A/b6Q A V B#=U烃'8=Showǿ >(w p"3 Tam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#D:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications *\G{00020813-0000-0000-C000-000000000046}#1.3#0#D:\Program Files\Microsoft Office\Office\EXCEL9.OLB#Microsoft Excel 9.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#D:\EXCEL 97\stdole2.tlb#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#D:\WINNT\System32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{896125D8-899F-11D2-8DAF-005345000000}#2.0#0#D:\WINNT\Profiles\cyu\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M    3VBA_Functions0<37ff36c8VBA_FunctionsxW!ThisWorkbook0937ff36b9ThisWorkbookSolver10837ff36b9Solver1H`0Solver20737ff36b9Solver20xH-zSolver30:37ff36b9Solver30H`Solver40;37ff36b9Solver40H`x0H`x`_˄`_˄`_˄`_˄`_˄`_˄hdUformat Excel+ VBAWin16~Win32MacVBA6# SOLVERstdole`MSFormsC VBA_FunctionsG _Evaluate (SolverAdd7CellRef|RelationB FormulaText(SolvAdd+ (SolverChangeoA (SolvChangei (SolverDelete (SolvDelete (SolverFinish$ KeepFinalO reportArray 7 (SolvFinish0(SolverFinishDialog](SolvFinishDialog l (SolverGetTypeNum SheetName6(SolvGetv (SolverLoadQLoadArea(SolvLoad(SolverOkCSetCellY MaxMinVal7.ValueOfGuByChange(SolvOka(SolverOkDialog (SolvOkDialog! (SolverOptionsJMaxTimeu Iterations Precision AssumeLinear;StepThru Estimates& Derivatives‘ SearchOption IntToleranceScaling` Convergence AssumeNonNeg3 (SolvOptions (SolverReset (SolvResetR (SolverSaveMSaveAreaB(SolvSave (SolverSolveQ UserFinishsShowRef (SolvSolveJz ThisWorkbook| Solver1(answer,(actionR(change(fresh((oldobj!u (oldobjformat9(dllavail^ (solver_adj. (solver_optB{ (solver_lin.j (solver_negEt (solver_typ (solver_rep (solver_shoy (solver_scl (solver_est7F (solver_nwtv (solver_drv@(report_generation* (stop_solverO (remembersheeto (currentarea (solver_numv(oldvars (oldvarformatsh (AutoOpened (savestylew(excel4language  (excel4sheet (thesheetname (helpsheetname(helpfile(stub5 (Auto_openV (Main,savecalculation savestatusbarD=savescreenupdatejdummyDi`cZvbacodethearray newpartfdummy2ɇ (SolverNamel errorhandlingg  ActiveSheet%N xlWorksheet,ProtectContentsMsgBoxRRange ActiveWorkbook IsInplace  Application*OperatingSystem[VersionMultiUserEditingwa ActiveWindow+SelectedSheetsCount0vRegisteredFunctionsIsNullRight  mainerror[DisplayStatusBarScreenUpdating! EnableCancelKey xlDisabledReferenceStyle9selectionerrorP SelectionZAddress freshhandleNamesο Set_defaults8 (Get_settings E RecordMacro basiccode?  DialogSheetsKShow (Define_names EditBoxes Captionx InternationalxlDecimalSeparatorxlA1ChrK~ConvertFormulaxlR1C1p(Add_constraint(Delete_constraintW(Change_constraint% (Show_options, (Save_model)  (Load_model0 (SaveLoad_ok StatusBarʜ (Problem_okxlErrNA^ (Stylecheck:ValueK NumberFormatRRun_(FinishX ActiveCell OptionButtons@xlOn ListBoxes%RemoveAllItemsu4 CheckBoxes̍xlOff' noproblem9hnewopt4Inewadj the_rightmid_ind\3the_leftc1 helpstring$janewentry(theindex:- the_middleW errortrapQ(Get_name!L(Obj (AdjustablesqhTrim@Str RefersToLocal IsNumeric$*Erro DropDownsGZList*(search ListCount6AddItem Index errorhandlerOExcel4MacroSheetsɷExcel4IntlMacroSheets. WorkbooksB(Namefix thestring6 newstring+ errorhandle_ placeholders&entrystarttheend0iferrorVkb mainstringi the_answer theoptionsvar_donebobj_done9 DialogFrame (DoTheSaveC (Reset_all~ loaderror$IsEmpty FormulaqY loaderror2+JAddrRefersToVisiblexlListSeparator loaderror3,Jol^(solver_options2 ListIndexQ(Valid_constraint( Solver2 (Auto_closew (Cont_buttonv0 (Stop_button](Push_add  (Push_close$i (Push_deleteo (Push_guessznprec guesserror#Focus HasFormula Precedents SpecialCells xlConstants (Push_changeZ (Push_optionsK (Push_reset (Push_save2 (Push_load6rowind6colind)RowColumniCells(SaveLoad^ varstringtheleft themiddletheright midstringP save_error,Offset FileFormatxlWK3!xlWK3FM3 FormulaArrayΠ thenewstring adj_count>H WorksheetAreasK (Option_OK thetimetheiterButtons] DismissButtonv (Option_cancelndo_msgDeletex(Max_button_pushg?(Min_button_pushX(Value_button_push (Solve_problemQV (Finish_cancel (Finish_help4HelpfUnionupdate which_one3theoneNflastone6terror_constraintpIsErrorU(IsCellReference4 RemoveItemZplacem! the_indexؿ constraintD DropDownLinesY number_of_lhs@+ number_of_rhsVK Right_ind the_option3rel_indthecount xlAbsolute (IsCellRef}EvaluateT (Constraint_OKEHide9z(Constraint_signQ(Constraint_AddL (Push_scenario (Scenario_OKB ScenarioName IsMissing nameconflict~ Scenariosk ChangingCellsLocked (Constraint_help!. (Stop_help (Load_help%m (Main_help. (Option_help (Scenario_helpgthecellsastring=combine  currentsheetewmcounter candidate'TypeNameExecuteExcel4MacroO Worksheets(FormnameIasheet rowstring? colstring4Activate|maxiterA0tol1assumeshowiterderiv> NonNegativeʢ Solver3msgQreportsnosenseEnabled۪Labels,BeepSelectedY (Do_Answer(Do_SensitivityZF (Do_Limits (Finish_ok֖newobj$Gadjusts constraints constbnds8canscountۢopt obj_adjustz( rhsstringnewvarsXEnewsheet DisplayGridlinesgivenamen ColumnWidthFontUBoldNow% handleCancel\xlErrorHandler AutoFormat ScrollRow"Columnsp9AutoFit&  (Quit_reportosencountlimcountzfreshobjnewvarvl Calculate DisplayAlerts (Quit_limits Solver4rememberscreen xlErrValuematchesmremember stringmatchm answer_reporty sens_report limits_reportg nameofsheet"y ByChangetring8resulturWorkbookk_Defaultj _B_var_LeftQ _B_var_Midp _B_var_Str _B_var_TrimmTNumber- _B_var_Right9 _B_var_Chr\;_B_var_placeholdersM     l  H Д,@0Q@;TBl@@ 1B`_˄x`_˄`_˄ME(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` % %`h8@0 3$*\Rffff*0937ff36b94xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU 0 ` a /&0 ` a /&0 ` a /&, `a)I,! `a)I,I `ai&(q `a/8 `a !8 `a !` `00a A9a $ `a(9 `aA/,a `aanrU~|  ! I q     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\`(llll\ \l N ((l\x@5l<l8l4l0l,l(l$l llll\ 4\lge 8 @(l\T\ \l (l\Tl\ \l (l\X ll\ \l (l\    /rU 0 ` a /&0 ` a /&0 ` a /&, `a)I,! `a)I,I `ai&(q `a/8 `a !8 `a !` `00a A9a $ `a(9 `aA/,a `aan     Y !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ]^_`abcdefghijklmnopqrstuvwxyz{|}~rU~|  )!1;Q;Y8a.9)z5I!#ah9E ",-- #-$A-i**9Y()Y)). +11+A/3,QzpI!IQ9I"= DyEEEyFF9GyG HyH9FF  zzX Iy qL"a# $I$ { Y9iY{{{%A%%q&&'9((%1'&&H{B |I!A|xAupK.F H$ H kF4\H" H$ H H RH$ @HW$4]<$ @W)H6$4l%\V H$ H HKl l @ (4l%\V H$ H HK9l # 04KF$ F /6$lA$ b4KF$bl F$bK lM4@ lM@   (4l%\V H$ H Hl S (4l%\V H$ H HlM4@  (4l%\V H$ H H (4l%\V H$ H H l l D (4l%\V H$ H H=:]$ 4%H$ H $@H5$BJ$ 4%H$ H $LH5$L(4]@BlL":4J$ 4%H$ H $LH5$l K9l # 04KF$ F /6$lA$ b4KF$bl F$bK4Hkb K:4%H$ @H$A'%%$ :%$ @AdP'T%d$ '%$ av" '%'%'%'%'%'%'%'%'%'%'(%'8%'H%'X%'h%'x%'%'%'%'%'%'%'%'%'%'%'(%'8%QP[HQ[L$ atv") HLH6 $dt (4l%\V H$ H HzKP:4%H$ @H$'$KF UzH6$K  H$ @HH:4H$ @HW$::uDdt td dT%'%%$ aD`#*F4%f8%$ /)H6$dtdDT4:4H$ @HW$::uDdt td dT%l@f%$ )H6$dtdT|:4H$ @HW$::%uD%f%$ )H6$  :4H$ @HW$::uDdt td dT%::% >D!A4"$%f8%$ )H6$dtdD4T$ :4H$ @HW$::uDdt td dT%::#% >D!A4"$%f8%$ )H6$dtdD4T$$H$ @HH%\V H$ H H (4l l  H'%4%$ Ha$v"'%%$ av"'T%%$ av")H6$ (4l%\V H$ H HA 9$ 4%H$ H $ H5$? (4l%\V H$ H H#l$ % $:4]@5$z :4$bH$ @HH:4H$ @HW$::uDdt td dT%'%%$ aD`#*F4%f8%$ /)H6$dtdDT4:4H$ @HW$::uDdt td dT%l@f%$ )H6$dtdT:4H$ @HW$::uDdt td dT%f%$ )H6$dtdT|:4H$ @HW$::%uD%f%$ )H6$$H$ @HH%\V H$ H H (4lC:4&% >$!="(&'M@'  (6$4lX0l\L\HPLH$dtdTD4$^z .> @$ @ k>,T@" @$ @ @K  R@$ @@W,]< $ @W)@6,l%TV @$ @ @Kl l l @ (,l%TV @$ @ @K9l # 0,KF F /6 lA b,KFbl FbKl  lM,@ lM@   (,l%TV @$ @ @l S (,l%TV @$ @ @lM,@  (,l%TV @$ @ @ (,l%TV @$ @ @ l l D (,l%TV @$ @ @K=:] ,%@$ @ @@5GJ ,%@$ @  D@5D(,]@GlD":,J ,%@$ @  D@5-l # 0,KF /5lA b,KFbl FbKl  UK:,%@$ @@A '%%$ :|%$ @A\H'L%\$ '% $ av"| '%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%'%' %'0%QH[@Q[D$ |alv") @D@|6  \lS (,l%TV @$ @ @zKP:,%@$ @@'KF  Uz@6 Kl l @'%,%$ @av"'%%$ a v"'L%|%$ av")@6  (,l%TV @$ @ @9 ,%@$ @  @5 (,l%TV @$ @ @#l % :,]@5::,bpjhuch :)hM@   %$ @\'X\KFlH :0*hML@$ $ %$ @@'%,%$ @a`#'l%H$ a8`#40D]'KF /'24)@6" \lXH8$ kjpj kj khpf kj (,l%TV @$ @ @ hdhS kjZ (,l%TV @$ @ @@$ @@@:,@$ @@W ::fM@\ \l lX%f%$ )@6 \lX$@$ @@@ (,l%TV @$ @ @C:,&% >!= "(&'M@'  (6 ,l 0lTD|4@HD@| \lXH8$^W,K.B D$ D kB0LD" D$ D D RD$ @DW 0]< $ @ W)D 6 0l%LV D$ D DKl l @ (0l%LV D$ D DK9l # 00KF F /6 lA b0KF bl F bK lM0@ lM@   (0l%LV D$ D Dl S (0l%LV D$ D DlM0@  (0l%LV D$ D D (0l%LV D$ D D :0%D$ @D A'%%$ :%$ @A`L'P%`$  '%$  av" '%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'%'%'%'$%'4%QL[DQ[H$ apv") D HD6 `p (0l%LV D$ D DzKP:0%D$ @D ' KF UzD6 Kpjphl l .fucl:)fM@  % $ @ `'\`KFpL :4*fMP@( ( %$ @D'%0%$ Da `#'p%L$ a<`#80D]'KF /'28)D 6" `p\L<( khph khkfpj kh (0l%LV D$ D D fdl" kh) (0l%LV D$ D DK9l # 00KF F /6 |lA b0KF bl F bK l ,yD'%0%$ Da `##8*# '%%$  a`#*1`28)D 6 VD'%0%$ Da `##8*F`1`28D6 fucx:+fM0@   %D$ @D'pKF`\ \`1\D6 `p\\M0@ xK ,DD -DDD'%l\F0%$ Da `F .`1\D6 $ ,DD -lD :l\F0D$ @DW UpJD6  kJ2 Wl\F:0D$ @DW :/(]@D6 r Pl\F:0D$ @DW :/UpJD6  kJo {kJ\M0@ %  l\JkJiD$ @DW(`"\M@p 0 p\`1\D6 p\Pl\F:0D$ @DW :/UpJD6  0  kJ0 rkJ\M0@ %  l\JkJiD$ @DW"\M@` 0 `p`1\D6 `p:l\F0D$ @DW UpJD6 t =:] 0%D$ D  @D5  l\pJ kJ H\kJ 0%D$ D  `#O/D5 l\pJ sl\Jxqx:+fM0@   %D$ @D'pKF`\ \`1\D6 `p\Ll\FD$ @DW :01(]@D6 oWl\F:0D$ @DW :/(]@D6 Pl\F:0D$ @DW :/UpJD6 Yl\JkJi0D$ @DW ("\M@` 0 ``1\D6 `mEl\FD$ @DW :01UpJD6 Pl\JkJi0D$ @DW "\M@ 0 `1\D6  l\31\:)fM0@   %D$ @D'pKF`\ :*fM@< <( (%$ @ '%\$  aL`F'KF l\F4K#l`0/)D 6& `p\L<(kfpj fd kj (0l%LV D$ D DD$ @DD|:0D$ @DW ::%uD%f% $  )D 6 :0D$ @DW ::jM@` `p p\%:)M@L L< <(% $ @ A2%f4%$ )D 6 `pL<(\:0D$ @DW ::jM@` `p p\%:*M@L L< <(% $ @ A2%f4%$ )D 6 `pL<(\:0D$ @DW ::jM@` `p p\%:+M@L L< <(% $ @ A2%f4%$ )D 6 `pL<(\$D$ @DD (0l%LV D$ D DC:0&% > !="(&'M@'  (6 0l,4lL\`8D LHD `p\L<(^W/4K.> @$ @ k>,D@" @$ @ @ ):,3%4> !=5 6 ,l%DV @$ @ @" @$ @ @l l  (,b+(,]c (]ph (,l%DV @$ @ @l l &l5Il5I (,l(,]3'pd*@'%v6F,%$ Q@[Tr'kdv7k,%TC5 kdpd Ts" @$ @ @l l Qpjphpf l5ILdl5Icad@l (,]3pj(,]3ph(,]3pf ddkjkhkf 8kj- 9kh> :kfO ; (,l%DV @$ @ @C:,&% > !="(&'M@'  (6 <$lDT @ tK%.V X$ X kVD\X" X$ X X ):D3%4>$!=5 6$Dl%\V X$ X X :D3%4>$!A5<5$ = (Dl%\V X$ X XC:D&% >$!="(&'M@'  (6$/t,l\ X$`KH.: <$ < k:(P<" <$ < <  lM(@ lM@ (l%PV <$ < <(ll l "<$ @W`1h)<5KH<$ @?)<p kN:(@%<$ @<'KF l<6 ktX:(A%<$ @<'KF Hkl<6  kN:(B%<$ @<'KF l<6 k,N:(%<$ @<'KF l<6 kX:(%<$ @<'KF Hkl<6  kc:(%<$ @<'KF H`<6 fl`c:)fM(@  %<$ @<'KF| |`#xkfl`;/x<6| fdl`M( l kc:(%<$ @<'KF H`<6 fl`ct:*fM(@  %<$ @<'KF| |`#xkfl`;/x<6| fdt6l`M( l kc:(%<$ @<'KF H`<6 fl`cpK:+fM(@  %<$ @<'KF| |`#xkfl`;/x<6|KH fdpWl`M( l k KX:(C%<$ @<'KF Hkl<6 $l ,<< -ll< ,<< -< ((dl k kKX:(D%<$ @<'KF Hkl<6 $l ,<< -ll<f ,<< -< ((dl k ( KX:(E%<$ @<'KF Hkl<6 $l ,<< -ll<#  ,<< -<(ư>l k  KX:(F%<$ @<'KF Hkl<6 $l ,<< -ll<  ,<< -<(?l k  K\:(G%<$ @<'KF Hl<6 $l ,<< -ll<  ,<< -< f(l kW K\:(H%<$ @<'KF Hl<6 $l ,<< -ll<R  ,<< -< f(l k K\:(I%<$ @<'KF Hl<6 $l ,<< -ll<  ,<< -< f(l k KX:(J%<$ @<'KF Hkl<6 $l ,<< -ll<  ,<< -< ((l k| KX:(K%<$ @<'KF Hkl<6 $l ,<< -ll<w  ,<< -< ((l k2KX:(L%<$ @<'KF Hkl<6 $l ,<< -ll<- ,<< -< ((l kKX:(M%<$ @<'KF Hkl<6 $l ,<< -ll< ,<< -<(-C6?l kK\:(N%<$ @<'KF Hl<6 $l ,<< -ll< ,<< -< f(l/@<$ < d>?)<%PV <$ < <C:(&% >!="(&'M@'  (6(l `@t&lPh`@4 x<| PK.V X$ X kVD\X" X$ X X l l  (Dl%\V X$ X XK9l # 0DKF F O/6lA bDKFbKl F O5c (Dl%\V X$ X Xf P5U:DQ% >!A"%:R%XS$T UX d>WVCW)X6G%:X%:DR%XS$T UX d>YCW)X5 Z [ (Dl%\V X$ X XC:D\% >!="(|&'M@'  (6|C:D&% >!="(|&'M@'  (6|$ <$l\(,0(X|hK.V X$ X kVD\X" X$ X X l l 7K9l #@ 0DKF0 F /@60 lA0 bDKF0bl F0bKl l 5 (Dl%\V X$ X Xl l K6X'%D%$ Xa0v"X50 (Dl%\V X$ X XK?(D]<0(]< '(]<'> (Dl%\V X$ X Xl l ` (Db+(D]/0l ' 5 (Dl%\V X$ X Xl l  (Dl%\V X$ X XK9l #@ 0DKF0 F O/@60 dlA0 bDKF0bl F0bKK7X'%D%$ Xa0v"X50 (Dl%\V X$ X XKX$ @XX:DX$ @XW0 ::]%'%%$ a`#@*Fx%fX%$ /@)X6 0 x:DX$ @XW0 ::^%'%%$ a`#@*Fx%fX%$ /@)X6 0 xv:DX$ @XW0 ::_%f%$ )X60 v:DX$ @XW0 ::`%f%$ )X60 $X$ @XX (Dl%\V X$ X XC:Da% >0!= "(&'M@'  (60 4,l\4 @X0 xLK.F H$ H kF4LH" H$ H H llll$ b$\\(4]@ \l%LV H$ H H c (4l%LV H$ H HC:4&% >$!="(&'M@'  (6$L0lL\ H$K.V X$ X kVD\X" X$ X X Kl l &DH4H$H (Dl%\V X$ X Xl l Q&DH4H$HO (Dl%\V X$ X Xl l  } D%X$ X ($]I %$  (]V)X6 (Dl%\V X$ X Xl l l #d0/m4:De]/M$b-l #f=l #d=2 (Dl%\V X$ X Xl l l #d0/! 4:De]/M$b -l #f=l #d=2 (Dl%\V X$ X Xl$ l$ 8$4:De]3 :Dg0$$4:Dh]3 :Di0$$DH$4H6 (Dl%\V X$ X Xl( l( (4:De]3p :Dg0((4:Dh]3 :Di0((DH(4H (Dl%\V X$ X Xl, l, ,4:De]3  :Dg0,,4:Dh]3@ :Di0,,DH,4H (Dl%\V X$ X Xl0 l0 g} 0D%X$ X ($]c 0%$  (d]V)X6e (D l%\V X$ X Xl4 l4 l4 #d0/44:De]/M$b4-l4 #f=l4 #d=2 (D l%\V X$ X Xl8 l8 } 8D%X$ X ($]I 8%$  (]V)X6 (D l%\V X$ X Xl< l< l< #d0/7<4:De]/M$b<-l< #f=l< #d=2 (D l%\V X$ X XX$ @XXl l U :DX$ @XW:4:$j%Hk%fx%$ )X6l l  :DX$ @XW:4:$k%Hk%fx%$ )X6l l  :DX$ @XW:4:$l% %$  fx%d$ d)Xd6 l l  DML x:DX$ @XW:4:$m%(%f%$ )X6 x:DX$ @XW:4:$m%(%f%$ )X6l l   DMm x:DX$ @XW:4:$n%(%f%$ )X6 x:DX$ @XW:4:$n%(%f%$ )X6l$ l$  :DX$ @XW:4:$o%$Hk%fx%$ )X6l( l( :DX$ @XW:4:$p%(Hk%fx%$ )X6l, l, :DX$ @XW:4:$q%,Hk%fx%$ )X6l0 l0 v:DX$ @XW:4:$r% 0%$  (dT%fh%d$ d)Xd6 l4 l4 4DMx:DX$ @XW:4:$s%(%f%$ )X6x:DX$ @XW:4:$s%(%f%$ )X6l8 l8 P:DX$ @XW:4:$t% 8%$  fx%d$ d)Xd6 l< l< q<DMx:DX$ @XW:4:$u%(%f%$ )X6ox:DX$ @XW:4:$u%(%f%$ )X6$X$ @XX [ (Dl%\V X$ X XC:D&% >!="(&'M@'  (688,l\8 XdTK.V X$ X kVD\X" X$ X X f4 P54 (Dl%\V X$ X XDlH,l\X4K $h $ hWX vhKr.F h$ h kF4Hh" h$ h h l l  (4l%HV h$ h h;K9l #0 04KFX F O/06X $lAX b4KFXbKrl FX O5X (4l%HV h$ h h [zh'4%l FX%$ ha v"u'%l F%$ av")h6X E (4l%HV h$ h hU:4w% >X!A "%:R%hS$T Uh d>WVCW)h6X G%:X%:4R%hS$T Uh d>XYCW)h5X Z (4l%HV h$ h h(h'%:4x%$ hh$h $ hWX vh C:4&% >X!= "(&'M@'  (6X  ,lH(0hX 0Kv$h $ hWX vhKa.F h$ h kF4Hh" h$ h h l l Th$ Hh Ul1*FX4 %:y%4>!Cz/h6X  :{%:4y%4>X!Cz5XK [ v6{0H4lK6h'%v6F4%$ haXv"h5X " h$ h hC:4|% >X!= "(&'M@'  (6X %HV h$ h h (4l?h'%v6F4%$ haXv"7h5X?h'%v6F4%$ haXv"}h5Xp2*h'%v6F4%$ Qh[ r AX5Bk2v75X AX~`#k2v};/5X k2p2  s" h$ h h&h'4%v$ hh '%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'4%S$T Ul*#*FX%h$ h  <2h5XK" h$ h h< q4l| <ll l 4X = =1h'4%v FX%$ hh5X%HV h$ h hC:4&% >X!= "(&'M@'  (6X 4l(h'%:4x%$ hh$h $ hWX vh l8 lH (hX     /rU  $`a$`a$`a$`a$!`a$I`a$q`anrU @nrU~| OYOO2C PX IQI*QP!PP QQQQQ)RqRRSISS TQTTT1UyUUW4U)9V!Q66 QVVhY)-- V(!IpYW5 XI"QXiX!#aXX@. +XAYyYYIY1ZQZiZ1cZZA[[[[!: \Q\\\)]q]]]9^^^_1_Y__ `Q```)aqaYaaaIxA #)1!bibI1i**bbbc dQddddeYeee1fyff gQgg hQhhhiaiii)jqjjkQkk lYlllImmmnannn oYoo pYppp1qqq!rqrrrIssW tYtttIuu"&a#" $uv "avvvvq= KR :l%>LA:<%>A: %>A Z:%:% $  d P C)6 LPI,%:\%:l% $  d LC)5LEf,%:\%:l% $  d L C)5L@@(l]30:l%>LA`#<_/<6LDc,%:\%:l% $  d L C)5L@(l]3w0:l%>LA`#<_/<6LDc,%:\%:l% $  d L C)5L@(l]30:l%>LA`#<_/<6LDc,%:\%:l% $  d L C)5L@(l]3A0:l%>LA`#<_/<6L@(l]30:l%>LA`#<_/<6L@(l]30:l%>LA`#<_/<6L@(l]3 0:l%>LA`#<_/<6L@(l]3M0:l%>LA`#<_/<6L@(l]30:l%>LA`#<_/<6L@(l ]30:l%>LA`#<_/<6L@(l ]30:l%>LA`#<_/<6L@(l ]3Y0:l%>LA`#<_/<6L@(l ]30:l %>LA`#<_/<6L@(l ]30:l!%>LA`#<_/<6L@(l]3f0:l"%>LA`#<_/<6LDc,%:\%:l% $  d L C)5L0:l#%>LA`#<_/<6LL_F,%:\$%:l% $  d L%C)5L &z' ()" *$+ , -1:l% $  d .) v)/0F:,0%:\1%:l2% $  d L3C4)5L1:l5% $  d .) v)(=u'w O:\%:l% $  d L A6_)6L __u7c8 :\8_Ml@L 9L :%*$+ @,;'KF <H6L _ _d8]L_ (l%_L(<%_'6L  " *$+ , -C:l=%>L=(&>M,@'  ?6L" *$+ , -(l%_L5L  @3(l%_L_<'6L<9  A3(l%_L_<'6L<u  BT:\%:l% $  d LA,]3)6LM _/'\%vCFl%*$+ ,Q[4_r0M _vDkl%_C___s0 C:lE%>L=(&>M,@'  ?6LL 0r40@B <LP8K3" x*$+ ,x -xz'C:hE%>H=8(&>M@' 8 ?6H8$ xH880/K.):lF%G>L=< H6L<yC:lI%>L=<(&>M @' < ?6L< _(Kx:lJ%*$+ @,L;'LKF< <' %*$+ ,aB_()6 L<K.*:lF%G>LALA_D@_HD\%G>LOA<U_L6L<O_LD _D@_HD\%G>LOA<U_N6L<"_J_d _0X',%:lM%*$+ @,L;ALA<% *$+ , -6L<#*$+ @,WLN`Q5LD ' %',%'\%'l%*$+ H,   ( ) fl%*$+ D,,K R S _Pq:lT%>LA<:,U_PM @ 9 :%*$+ @,N6 L<$ R Sl R S_P_P/K.*$+ @,WLN`#_h/5L2,?%'\%:lV%*$+ ,,Ac,%'\%:lV%*$+ ,aLW,`)5L:lX%>LA<:,U *$+ , d->F: U:T%>Ap%(`%(@%*$+ X,CY)6L<p:lZ%>LA<:,[*$+ H,  >F: \vQF%(%(P%*$+ X,CY)6L<o:l]%>LA<:,U ^%( %(%*$+ X,CY6 L< u_0:l`%>LA<`#_T/6L< u_0:la%>LA<`#_T/6L< u_0:lb%>LA<`#_T/6L<x:lc%>LA<:,d_TF :e%(%(P%*$+ X,CY6 L<0_XK2vQFl%*$+ , d f)\:lJ%*$+ @,L;'LKF< <`#_X/6L<7_hFl%*$+ , d f)K9/% *$+ , <-_X00 _\Q:lg%>LA<%(,%(%*$+ X,CY6L<  _\Q:lh%>LA<%(,%(%*$+ X,CY6L<Q:li%>LA<%(,%(%*$+ X,CY6L<Q:lj%>LA<%(,%(%*$+ X,CY6L<Q:lk%>LA<%(,%(%*$+ X,CY6L<4(, %'\%:ll%*$+ , rZ:lm%>LA<%_\D,%(%*$+ X,CY6L<Z:ln%>LA<% _\D,%(%*$+ X,CY6L<Z:lo%>LA<% _\D,%(%*$+ X,CY6L<Z:lp%>LA<% _\D,%(%*$+ X,CY6L<Z:lq%>LA<% _\D,%(%*$+ X,CY6L<( %'%:\r _\DL< 9< ::,s _\_JD 9 :p%*$+ , r6L<p_Jrc:lt%>LA<% _\_JD,%(%*$+ X,CY6L<_Nc:lu%>LA<% _\_JD,%(%*$+ X,CY6L<c:lv%>LA<% _\_JD,%(%*$+ X,CY6L<c:lw%>LA<% _\_JD,%(%*$+ X,CY6L<c:lx%>LA<% _\_JD,%(%*$+ X,CY6L<c:ly%>LA<% _\_JD,%(%*$+ X,CY6L<c:lz%>LA<% _\_JD,%(%*$+ X,CY6L<( %'%:\r _\_JDL< 9< ::,{ _\_J_ND 9 :p%*$+ , r6L<p _J c:lg%>LA<% _\_JD,%(%*$+ X,CY6L<2vQFl%*$+ , d f)KQ:lJ%*$+ @,L;'LKF< <`|6L<7_hFl%*$+ , d f)_\u} @'\%v|Fl%*$+ , L`F<%( %(%*$+ X,CY)6L<'\%v|Fl%*$+ ,aLQM,@L`F<% ~( %(%*$+ X,CY)6L<7_hFl%*$+ , d f)7(l%(,%*$+ X,LCY5L@_(k%(l%(,%*$+ X,LCY5L,vF,%'\%:l%*$+ ,,,_\il%*$+ D,, _02vQFl%*$+ , d f)X',%:lM%*$+ @,L;ALA<:,d_0_J_N붳k :% *$+ , -6 L<7_hFl%*$+ , d f)g} @_4L% _\_0D\%( %*$+ X,<CY6L<s_4ALQMl@L< ~< _\_0D\%( %*$+ X,CY6L<W_0vDk% _\_0Dl%(,%*$+ X,LCY5LV_0vF% _\_0Dl%(,%*$+ X,LC5L\_0_dk% _\_0Dl%(,%*$+ X,LCY5LV_0vF% _\_0Dl%(,%*$+ X,LC5L_0_02vQFl%*$+ , d f)_4sq7_hFl%*$+ , d f)_0_Nc-_0 :lP%>LA<:,d_0_J_J_N붳k :% *$+ , -6 L<}l]3_D_J_0il%_H@G>LOALOALOA<5L(l]3(!}l]37_D_J_0il%_HD,%G>LOALOALOA<(]36L<a l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<_D_J_0il%_HD,%G>LOA<% _\_J_0D%(`%*$+ X,CY6L<#!l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<T(% _\_J_0Dl%(,%*$+ X,LCY5L-(l]3$}l]3"_D_J_0il%_HD,%G>LOALOALOA<(]36L<8$l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<_D_J_0il%_HD,%G>LOA<% _\_J_0D%(`%*$+ X,CY6L<$l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<T(% _\_J_0Dl%(,%*$+ X,LCY5L-(l]3)}l]3%_D_J_0il%_HD,%G>LOALOALOA<(]36L<(l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<_D_J_0il%_HD,%G>LOA<% _\_J_0D%(`%*$+ X,CY6L<(l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<T(% _\_J_0Dl%(,%*$+ X,LCY5L_TMl@ FL%vQF\%*$+ , d <A% _\_J_0D %(%*$+ X,C)6L<-(l]3+;:,:l%>LA<`#_`/6L<g_T_`*FL% _\_J_0Dl%(,%*$+ X,<CY6L<l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<T(% _\_J_0Dl%(,%*$+ X,LCY5L_TMl@ FL%vQF\%*$+ , d <A% _\_J_0D %(%*$+ X,C)6L<-(l]3-;:,:l%>LA<`#_`/6L<g_T_`*FL% _\_J_0Dl%(,%*$+ X,<CY6L<l:l%>LA<% _\_J_0D,%(%*$+ X,CY6L<T(% _\_J_0Dl%(,%*$+ X,LCY5L_TMl@ FL%vQF\%*$+ , d <A% _\_J_0D %(%*$+ X,C)6L<_0d1:l%*$+ `,<5<$l%*$+ D,,2vQFl%*$+ , d f)%fl% *$+ , -" *$+ , -C:lE%>L=<(&>M @' < ?6L<L:l%(,%f%*$+ H,  ) _P $ R Slg/ /C:lE%>L=<(&>M @' < ?6L</8|  DL<p@KC:l%>L=<(&>M @' < ?6L<2vQFl%*$+ , d f)%fl% *$+ , -" *$+ , -% *$+ , <- )C:lE%>L=<(&>M @' < ?6L<@$ $L<"\"K9!_lu7cx:88_lMh@X 9XH :H(%$*$+ @,$;'KF <H$6XH(C:h=%>X=H(&>M@'( H ?6XH(_ldx):hF%G>X=H H6XHiC:hI%>X=H(&>M@'( H ?6XH(W*:hF%G>XAHK"_6XH):hF%G>XAHLU_6XH;_@_@G>XOAHU_6XH>_@_D8%G>XOAHU_6XHO_D_@_D8%G>XOAH(U_6XH("__ _lX'%:hM%$*$+ @,$X;AHN%*$+ ,Q[_p$6XHrW&_pAXB_l_5X_l_l_ps " $*$+ ,$ -$K!% $*$+ ,$ <-$?:h%>XAH% $*$+ ,$ -$6XH#$*$+ @,$WXN`Q$5XD '%'%'8%'h%$*$+ H,$   ( )$ fh%$*$+ D,$,$K R$$ S$ _q:h%>XAH:U(_M@ 9 :%$*$+ @,$N$6 XH($ R$$ Sl$_ R$$ S$__K.$*$+ @,$WXN`#_/$5X($'8%:hV%*$+ ,$$,h?%$ *$+ ,$$+ch%$ *$+ ,$WXC$5X:hX%>XAH:U( $*$+ ,$ d->F:U:%>A|l%(\%(<%*$+ X, CY)$6XH(|l :hZ%>XAH:[($*$+ H,$  >F:\vQF%(%(L%*$+ X,|CY)$6XH(|o:h]%>XAH:U( ^%(%(%$*$+ X,$CY$6 XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH( uj Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(g( %$'%:8_DXH 9H( :(%*$+ ,$ r$6XH(u Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(g( %$'%:8_DXH 9H( :(%*$+ ,$ r$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(_8Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH( uZ:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(( %$'%:8r _DXH 9H( :(: __D 9| :|l%*$+ ,$ r$6XH(|l3Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(( %$'%:8r _DXH 9H( :(:s __D 9| :|l%*$+ ,$ r$6XH(|lZ:h%>XAH% _D%(%$*$+ X,$(CY$6XH( _l2vQFh%$*$+ ,$ d f)$X'%:hM%$*$+ @,$X;AHN%*$+ ,Q[_p$6XHr_l :h%>XAH:(d_l__붳k:% $*$+ ,$ -$6 XH(7_Fh%$*$+ ,$ d f)$^} @_pX%_lD8%(%$*$+ X,$HCY$6XHj_pAXQMh@XH ~H_lD8%(%$*$+ X,$(CY$6XH(S_l_k%_lDh%(%$*$+ X,$XCY$5XM_lvF%_lDh%(%$*$+ X,$XC$5Xz__lih%_D%G>XOAH%_lD%(\%$*$+ X,$(CY$6XH(M_lvF%_lDh%(%$*$+ X,$XC$5X uz__lih%_D%G>XOAH%_lD%(\%$*$+ X,$(CY$6XH(z__lih%_D%G>XOAH%_lD%(\%$*$+ X,$(CY$6XH(z__lih%_D%G>XOAH%_lD%(\%$*$+ X,$(CY$6XH(_l_l_ps,_l_ch _l :h%>XAH:(d_l___붳k:% $*$+ ,$ -$6 XH(}h]3R___lih%_@G>XOAHY '\%'%%:H(%$*$+ ,$ p-' <`#_/$6 XH(W___lih%_@G>XOAHY`#_/6XHQ_F% __lDh%(%$*$+ X,$XCY$5XiQM8@_Fh%X ~X __lD%(%$*$+ X,$HCY$6XH_Mh@ FX%vQF8%$*$+ ,$ d HA(% __lD%(%*$+ X,CY)$6XH(_Mh@ FX%vQF8%$*$+ ,$ d HA(% __lD%(%*$+ X,C)$6XH(___lih%_D%GBXO% __lD%(\%$*$+ X,$HCY$6XH_Mh@ FX%vQF8%$*$+ ,$ d HA(% __lD%(%*$+ X,C)$6XH( uW ___lih%_D%GBXO% __lD%(\%$*$+ X,$HCY$6XH___lih%_D%GBXO% __lD%(\%$*$+ X,$HCY$6XH___lih%_D%GBXO% __lD%(\%$*$+ X,$HCY$6XH_ld1:h%$*$+ `,$H$5H$h%$*$+ D,$,$2vQFh%$*$+ ,$ d f)$%fh% $*$+ ,$ -$" $*$+ ,$ -$C:hE%>X=H(&>M@'( H ?6XH(L:h%(%f%$*$+ H,$  )$ _ $ R$$ Sl$ " U"C:hE%>X=H(&>M@'( H ?6XH(|\"4D$XH(|l &$&K%_u7cx:88_Mh@X 9XH :H(%$*$+ @,$;'KF <H$6XH(C:h=%>X=H(&>M@'( H ?6XH(_dx):hF%G>X=H H6XHiC:hI%>X=H(&>M@'( H ?6XH( _Kx:hJ%$*$+ @,$X;'(XKFH <'%*$+ ,aB_)$6 XH(K%*:hF%G>XAHK"_6XH):hF%G>XAHLU_6XH;_@_@G>XOAHU_6XH>_@_D8%G>XOAHU_6XHO_D_@_D8%G>XOAH(U_6XH("__ _X'%:hM%$*$+ @,$X;AHN%*$+ ,Q[_$6XHr&_AXB__5X___s" $*$+ ,$ -$?:h%>XAH% $*$+ ,$ -$6XH$*$+ @,$N$#$*$+ @,$WXN`Q$5XD '%'%'8%'h%$*$+ H,$   ( )$ fh%$*$+ D,$,$K R$$ S$ _q:h%>XAH:U(_M@ 9 :%$*$+ @,$N$6 XH($ R$$ Sl$ R$$ S$__K.$*$+ @,$WXN`#_/$5X($'8%:hV%*$+ ,$$,h?%$ *$+ ,$$+ch%$ *$+ ,$WXC$5X:hX%>XAH:U( $*$+ ,$ d->F:U:%>A|l%(\%(<%*$+ X, CY)$6XH(|l :hZ%>XAH:[($*$+ H,$  >F:\%(%(\%*$+ X,|CY)$6XH(|o:h]%>XAH:U( ^%(%(%$*$+ X,$CY$6 XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(4( %$'8%:h%*$+ ,$ r$Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(j( %$'%:8 _DXH 9H( :(%*$+ ,$ r$6XH(@Ĵ?%(h %(%$*$+ X,$XC$5XQ:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(Q:h%>XAH%( %(%$*$+ X,$(CY$6XH(j( %$'%:8 _DXH 9H( :(%*$+ ,$ r$6XH(@Ĵ?%(h %(%$*$+ X,$XC$5XQ:h%>XAH%( %( %$*$+ X,$(CY$6XH(Q:h%>XAH%( %( %$*$+ X,$(CY$6XH(Q:h%>XAH%( %( %$*$+ X,$(CY$6XH(Q:h%>XAH%( %( %$*$+ X,$(CY$6XH(j( %$'%:8 _DXH 9H( :(%*$+ ,$ r$6XH( 0|K2vQFh%$*$+ ,$ d f)$Q:hJ%$*$+ @,$X;'(XKFH <`|$6XH(7_Fh%$*$+ ,$ d f)$K%% $*$+ ,$ <-$ v|00Q:h%>XAH%(%(%$*$+ X,$(CY$6XH(9(%(h%(%$*$+ X,$XCY$5XWu} @$'8%v|Fh%*$+ ,$ X`FH%(%(%*$+ X,(CY)$6XH($'8%v|Fh%*$+ ,$aXQM@X`FH%( ~((%(%*$+ X,CY)$6XH(@_k%(h%(%$*$+ X,$XCY$5X:vF%(h%(%$*$+ X,$XC$5X $*$+ ,$ T-$ _ivQ*#*#*FX%(8%f%$*$+ H,$  2)$5X2vQFh%$*$+ ,$ d f)$X'%:hM%$*$+ @,$X;AHN%*$+ ,Q[_$6XHr 7_Fh%$*$+ ,$ d f)$_ :x:h%>XAH:(d__붳k:% $*$+ ,$ -$6 XH(^} @_X% _D8%(%$*$+ X,$HCY$6XHj_AXQMh@XH ~H _D8%(%$*$+ X,$(CY$6XH(S__k% _Dh%(%$*$+ X,$XCY$5XM_vF% _Dh%(%$*$+ X,$XC$5X2vQFh%$*$+ ,$ d f)$rvQ*#*#*F(%:h_AXH%f%$*$+ ,$2$6X(HrvQ*#*#*F(%:h_AXH%f%$*$+ ,$2$6X(HZvQ*#*#*FX%(8%f%$*$+ ,$2$5XK" $*$+ ,$ -$H'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%',%'<%'L%'\%'%'%'%'%'8%'h% $  l*#*FX%$*$+ ,$ -H2$5XK%" $*$+ ,$ -$E_AX$'h%X*$+ ,$aHB_$6XH v|0=4$'8%v|Fh%*$+ ,$aX_$5X(h_:h%>XAH:U(_M@ 9 :%$*$+ ,$ d f)$6 XH((h]MI_k% _Dh%(%$*$+ X,$XCY$5XM_vF% _Dh%(%$*$+ X,$XC$5XE_} _Dh%(%$*$+ X,$XCY$5XM_vF% _Dh%(%$*$+ X,$XC$5X9Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(Z:h%>XAH% _D%(%$*$+ X,$(CY$6XH(ZvQ*#*#*FX%(8%f%$*$+ ,$2$5X2vQFh%$*$+ ,$ d f)$K" $*$+ ,$ -$H'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%',%'<%'L%'\%'%'%'%'%'8%'h% $  l*#*FX%$*$+ ,$ -H2$5XK%" $*$+ ,$ -$E_AX$'h%X*$+ ,$aHB_$6XHh_5hK v|0=4$'8%v|Fh%*$+ ,$aX_$5X(h_K%M_AX__k8%$'h%X*$+ ,$,$5X:h%>XAH:U(_M@ 9 :%$*$+ ,$ d f)$6 XH((h]MI_k% _Dh%( %$*$+ X,$XCY$5XM_vF% _Dh%( %$*$+ X,$XC$5XE_} _Dh%( %$*$+ X,$XCY$5XM_vF% _Dh%( %$*$+ X,$XC$5XZ Z:h%>XAH% _D%( %$*$+ X,$(CY$6XH(Z:h%>XAH% _D%( %$*$+ X,$(CY$6XH(__ $*$+ ,$ T-$2vQFh%$*$+ ,$ d f)$_sx2vQFh%$*$+ ,$ d f)$:h$*$+ @,$WXNH:8(:%_@f%*$+ H,  )$6XH(:h$*$+ @,$WXNH:8(:%@f%*$+ H,  )$6XH(K/:hJ%$*$+ @,$H;$5H v|0=":h$*$+ @,$WXNH:8(:%v|*F%f%*$+ H,  )$6 XH( vC0=y#:h$*$+ @,$WXNH:8(:%vC*F%f%*$+ H,  )$6 XH(7_Fh%$*$+ ,$ d f)$1:h%$*$+ `,$H$5H1:h%$*$+ `,$H$5H1:h%$*$+ `,$H$5H$h%$*$+ D,$,$2vQFh%$*$+ ,$ d f)$$*$+ @,$N$%fh% $*$+ ,$ -$" $*$+ ,$ -$C:hE%>X=H(&>M@'( H ?6XH(L:h%(%f%$*$+ H,$  )$ _ $ R$$ Sl$% &C:hE%>X=H(&>M@'( H ?6XH($&4H$XH(|l KTC:l%>L=<(&>M @' < ?6L<2vQFl%*$+ , d f):l*$+ @,WLN<:\:,%_@f%*$+ H,  )6L<:l*$+ @,WLN<:\:,%@f%*$+ H,  )6L< v|0=!:l*$+ @,WLN<:\:,%v|*F%f%*$+ H,  )6 L< vC0=:l*$+ @,WLN<:\:,%vC*F%f%*$+ H,  )6 L<*$+ @,N%fl% *$+ , -" *$+ , -% *$+ , <- )C:lE%>L=<(&>M @' < ?6L<$ ,L<MrU HqI4`rU $`a$`a$`$`a$!`a(I`aI/0q` ai0&&(`aI/$`a nrU  $`a$`arU~|  !)1;Q;;I <9Q<Qi<B<A/<A=I=!=X 9I!#a= I 1>a>> 0>>!?A?qq? ? @QyI@@@!yA"AAABYI"11CQyC) DID!!iD "DDQD9E)--Y)) 5. +1+3)*I*i* #*q59, yEYEEy9FyFF!!F9Gy yGq'G H (IHyHy(HH yy)I qIIIMI J1J $"I$$qJJJKIK#yK)1I1KK L(IL 10qLLL MQM||}Q}}}~D  $ | KRx$ @xWXh]X=H($&M@'4 H 6XH4$'x$ Hx d kxG:h %>X=H($&M@'4 H 6XH4$K x$ x t >FXH H:h]3x6XH9 x$ x d l#q2x) x$ Hx  kxG:h%>X=H($&M@'4 H 6XH4$Bx$ DxaXDD 0l)xD5XG:h%>X=H($&M@'4 H 6XH4$:X '%'h%x$ x  X_$x5X_$ DG:h%>X=H($&M@'4 H 6XH4$ ,/_$5IL_ _$5IcK x$ x t >FXH H:h]3x6XH+O_ @(h%_$Xq lH  -H:]36XH& ,O_ @(h%_$Xq lH  -H:]36XH ,_ d~ ,G:h%>X=H($&M@'4 H 6XH4$K. x$ x  k_x" x$ x  x. x$ x  k_x% x$ x < x0 x$ x  lihtxKo6t @x $ xXTxK Ki7:h%x$ @xX`#_/x5XK" x$ x  x <    T* '%:h%x$ x  x=" x$ x  x TK1D:h%x$ x dD!)xDK== " T0K[D'%:h#%x$ @xXAH$%$ Da4`0)xD6XH4V:%%D:h%x$ x dDX&AH'`#_4/)xD6XH=:(]X h%x$ x  X@x5X6 X_4FX h%x$ x  XHU_8x6XHw_8_4Mh@X X:(H'4_8_4M@$ )$`#_4/6 X4H$400=* th]3 k:h*%>XAH:+4:,%>$A:-`#_ /6XH$4_ <#*#.*FH:h/%>XA4$:-" 0_4F|"l 0l\`#X_ 2X6XH4$|l\_ .*FH:h1%>XA4$:-" 00F|"l 0l\`#_ /6XH4$|l\ k:h*%>XAH:+4:,%>$A:-`#_ /6XH$4_ <#*#.*FH:h/%>XA4$:-" 0_4F|"l 0l\`#X_ 2X6XH4$|l\_ .*FH:h1%>XA4$:-" 0| 'H%'%%0F%x$ x p |l"\ 0\8`#_ /x6XH4$|l\80 '%_ Fh%x$ x  x4=0=th]3:h*%>XAH:+4:2%>$A:-"| 0|l4FH\"8 08(:.`#_ /6XH$4|l\8(N_ F:h,%>XAH4:-$`#_ /6XH4$_ <#*#.*FH:h/%>XA4$:-" 0_4F|"l 0l\`#X_ 2X6XH4$|l\_ .*FH:h1%>XA4$:-" 00F|"l 0l\`#_ /6XH4$|l\T:h*%>XAH:+4:2%>$A:-"| 0|l\ '%'%%4FH%x$ x p \8"( 0(:.`#_ /x6XH$4|l\8(N_ F:h,%>XAH4:-$`#_ /6XH4$_ <#*#.*FH:h/%>XA4$:-" 0_4F|"l 0l\`#X_ 2X6XH4$|l\_ .*FH:h1%>XA4$:-" 0| 'H%'%%0F%x$ x p |l"\ 0\8`#_ /x6XH4$|l\80 '%_ Fh%x$ x  xC l30" x$ x  x 4 l50 6 l70" x$ x  x 8 l90g090:0Ŕ;0Ŕ<0dC l90" x$ x  x = l:0" x$ x  x > l;0" x$ x  x ?<0] @<0B 9T[A0[ :T, lB0A:hC%>XAH% x$ x  x6XH" x$ x  x " ,3G:h%>X=H($&M@'4 H 6XH4$X DX5XQ:E%D:h%x$ x dDX&AH:]3)xD6XHhu'%:E%D:h%x$ x dDX&=H' FF4%$ a$)xD6XH4x'%:E%D:h%x$ x dDX&=H' FF4%$ a$`()xD6XH4$Cx'%0Fh%$ xaXv"hx5XCx'%0Fh%$ xaXv"lx5X _ 1x'%0Fh%$ Qx[_r#_AXGB_ h5X)_AXH`#_ l;/5X_ _ _sa3x'h%T FFX%$ xx5XH'%'%'%'%'%'%'%'%'%'%'$%'4%'D%'T%'d%'t%'%'%'%'%'%'%'%'H%'%'%'%'%'%'h%I$  l*#J*FX%x$ x H2x5XE '%:hK%>XAH%x$ x  x6XH" x$ x  xS '%x'h%T FFX%$ QxoH%D$ D  D6XH L T" x$ x  x3x'h%T FFX%$ xx5X(_ x$ x  x%fh% x$ x  x(_ x$ x  x(x'%:hM%$ xx6t @x $ xXTx G:hN%>X=H($&M@'4 H 6XH4$G:h%>X=H($&M@'4 H 6XH4$  |4`XxDXH4$|l\8(XK*d:h%x$ x dQd`xRt @x$ (x P`F %:@Q%`&Cx6P &FP%:h%%` &C6P #0%:hW%`PXCG5P :0%:h%`P&C'5P:h]%` ^_5 c`*d:hv%x$ x dQdx&dFP%:hx% &C'6P &dFP%:hz% &C'6P -ư>FP%:h|% &C'6P &FP%:h~% &C'6P --C6?FP%:h% &C'6P #0%:h%PCG5P#0%:h%PCG5P#0%:h%PCG5P#0%:h%PCG5P#0%:h%PXCG5P#0%:h%PXCG5P#0%:h%PXCG5PcG:hN%>P= (&M@'  6P X,`$xdP 0 _:K7:hO%x$ @xH`#D_</Dx5H _:]_<Mh@H PH:0Q%@:X%x$ x d@&C')x@6HF: %:XQ%@:h%x$ x d@H&C')x@5H R _:vt @@'0%:h#%x$ @xHA$%$ @ `#D_@/D)x@6HKc _:L_@F %:XS%@:h%x$ x d@H&C')x@5H3F: %:XS%@:h%x$ x d@H&C')x@5H TK#D_`/D\:hU%x$ @xH'HKF )`#D_`/Dx6HT_`3FH%:X%%@:h%x$ x d@&C)x@6HV_`8:h%x$ @xHK#D_`/Dx5H_`C lV0I %:XW%@:h%x$ x d@HXCG)x@5H <| lY0I %:XZ%@:h%x$ x d@HXCG)x@5H <| l[0|I %:X\%@:h%x$ x d@HXCG)x@5H <D:X]%@:h%x$ x d@^_)x@5 dV:h`%x$ @xH'HKF )Hdx6 H_ddc:Xa_dMh@H bH c%x$ @x'KF )`#D_\/Dx6HUx'X%_\Fh%$ xaH`F P`#D_\/Dx6H_\Jxj@x'X%_\Fh%$ xaH`#D_\/Dx5H:Xd_dMh@H bH c%x$ @x'KF )H_Xx6H_X:Xe_dMh@H bH c%x$ @xAf'KF )`#D_T/Dx6H_TMh@ g&K hxx ixUx'X%_TFh%$ xaH`F P`#D_T/Dx6H$ hxx ilxB D_TFhx$ @xWH$U_fx6H_fS \_TF0:hIx$ @xWH$:Xj( ]@x6H_ Z_TF0:hIx$ @xWH$:XjU_fx6H_f\ _f_TMh@H H_TJ_fiXx$ @xW$(0"_TM @  `#D_T/Dx6HZ_TF0:hIx$ @xWH$:XjU_fx6HM Q _fQ _f_TMh@H H_TJ_fiXx$ @xW$"_TM0@  `#D_T/Dx6HD_TFhx$ @xWH$U_fx6Ha =:X(]H h%x$ x  H@x5H= "_T(_f_f= R_T_fH h%x$ x  H`#DO/Dx5H"_T(_f !_TJx:Xe_dMh@H bH c%x$ @x'KF )`#D_T/Dx6HQ_TFXx$ @xWH$:hk(0]@x6H\_TF0:hIx$ @xWH$:Xj( ]@x6H_Z_TF0:hIx$ @xWH$:XjU_fx6Ht_TJ_fihx$ @xWH$(X"_TM0@  `#D_T/Dx6HO_TFXx$ @xWH$:hkU_fx6Hk_TJ_fihx$ @xWH$"_TMX@  `#D_T/Dx6HE_T3#D_T/Dd_X@:X9%@:hl%x$ x d@HmBn`#D_p/D)x@6HQ_X2:ho%>HA`#D_T/D6Hp_pQ_XQ2:hq%>HA`#D_T/D6Hp_p__\+*#D_p*#+*F_TMh@H cH`#_h2D6H_d2m:X]%@:h%x$ x d@H^ArU++_h sU_l)x@6H@ _l_lT_h@:X]%@:h%x$ x d@^t)x@5 b_h@_l@:X]%@:h%x$ x d@^tu)x@5_dd8K*@:hv%x$ x dQ@xw:hw%x$ @xHAf'KF )HF%: x%&C'x6Hw:hy%x$ @xHAf'KF )HF%: z%&C'x6Hw:h{%x$ @xHAf'KF )HF%: |%&C'x6H{:h}%x$ @xHAf'KF )HdF%: ~%&C'x6HK--C6?FH%:h%&C'6Hw:h%x$ @xHAf'KF )HF%: %&C'x6HK7:h%x$ @xHK#DV0/Dx5H8#0%:h%HCG5H]#0%:h%HCG5HK7:h%x$ @xHK#DV=/Dx5H#0%:h%HCG5H#0%:h%HCG5HK7:h%x$ @xHK#DV0/Dx5HJ#0%:h%HCG5Ho#0%:h%HCG5H7:h%x$ @xHK#DV0/Dx5H#0%:h%HCG5H#0%:h%HCG5HK7:h%x$ @xHK#DV0/Dx5Hz#0%:h%HXCG5H#0%:h%HXCG5H#0%:h%HXCG5H#0%:h%HXCG5H7:h%x$ @xHK#DV0/Dx5HD#0%:h%HXCG5H#0%:h%HXCG5H#0%:h%HXCG5H#0%:h%HXCG5H7:h%x$ @xHK#DV0/Dx5H#0%:h%HXCG5H#0%:h%HXCG5HV#0%:h%HXCG5H#0%:h%HXCG5HcG:hN%>H=(&M @'  6H*@:hv%x$ x dQ@px&dFH%:hx%p&C'6H&dFH%:hz%p&C'6H-ư>FH%:h|%p&C'6H&FH%:h~%p&C'6H--C6?FH%:h%p&C'6H#0%:h%pHCG5H#0%:h%pHCG5H#0%:h%pHCG5H#0%:h%pHCG5H#0%:h%pHXCG5H#0%:h%pHXCG5H#0%:h%pHXCG5Hcp _:  0pp@ Dx@H0T-d:h%x$  x dQdx-d:h%x$  x dQdxK\ x$ x t >\FL< <:h]3x6L< T T*(x$ x 0l(x7G:h%>L=<(&M@', < 6L<,!x$ @xWL$x!x$ @xWL$x0( x$ x  l(ihtx(:hIL(]@5L:bLUc:-(Lkb< )<:I]36L<.kb:h bd pN T$ (\xdL<,HK7,TD(4$" 5$fTDUc/(Dkfl$ )$`#kfl ;/6D$&kfl FT]"D 0D35D>"D 0D"$ 0$`#kfl ;/6D$ fdKChfTDUc%lhkfl *1h fd  lhFTl :Tl xH8lh D$d [F]l@:D]%T:X%h$ h dT^Bng)hT6x DXlDXlgF]k$%:D]%T:X%h$ h dT^Bnt)hT6*-l+l slY-+ll sld(l hTK}th]3,  h1xxJX '%'$%4% h%T$ T p X`1xT5X  h1xh(xTX,\,K," x$ x  x_d:h%x$ x ddWTA':D%>$A3)xd6T$ u*:D]%d:h%x$ x ddT^A$r(]<:%:%$  d&A':]<|)xd6T$" x$ x  xP:h%>T=$(&M@'!$^ _6T$_" x$ x  xfT 5Tf:D%d:h%x$ x ddT&A$':k(]3)xd6T$9:h%>TA$:4+:%>A:-|"l 0l\:%d:%x$ x dd<&A,'" 0 `#_/)xd6T$|l<\, s:D%d:h%x$ x ddT&A'"$ 0$(]3)xd6T$:h%>TA$:4+:%>A:-|"l 0l\:%d:%x$ x dd<&A,'" 0 `#_/)xd6T$|l<\, :h%>TA$:4+:%>A:-|"l 0l\:%d:%x$ x dd<&=,'  " 0`#_/)xd6T$|l<,\ 0 'D%_Fh%x$ x  xK* _ _w'%:D%d:h%x$ x ddT&=$' FF%$ Q[_|)xd6T$ru*_| c*K*=_|AT:hp$(D]/6T$a*#_|AT`#_x/5T=:D(]T h%x$ x  T@x5T&_x(ih__(h]@S_x_"T h%x$ x  T`#O/x5T&_x(ih_'-_xMh@T T:D]35T K6+I%:D%d:h%x$ x ddTXCG)xd5T_xJiT_xMh@$ )$ P:E%d:4%x$ x dd&C')xd6T$ x$ @x$xx:hIx$ @xWT$$:DI:4%(%f%d$ d)xd6T$_xJi_xM@ ):hIx$ @xWT$$:DI:4%pd'%$ da|`#*Fl%fL%$ /)xd6T$|lx:hIx$ @xWT$$:DI:4%(%f%d$ d)xd6T$ x$ @x$xLFT%:D%d:h%x$ x dd$&C')xd6T$ <S*-_xMh@T T:D]35TzK6+I%:D%d:h%x$ x ddTXCG)xd5T_xJiT_xMh@$ )$ P:E%d:4%x$ x dd&C')xd6T$ x$ @x$x_xJi_xM@ ):hIx$ @xWT$$:DI:4%pd'%$ da|`#*Fl%fL%$ /)xd6T$|lx:hIx$ @xWT$$:DI:4%(%f%d$ d)xd6T$x:hIx$ @xWT$$:DI:4%(%f%d$ d)xd6T$ x$ @x$xLFT%:D%d:h%x$ x dd$&C')xd6T$ <S*_x_xFDT h%x$ x  T$(4]/'_'x6T$K6+I%:D%d:h%x$ x ddTXCG)xd5T_xpiT_xMh@$ )$ P:E%d:4%x$ x dd&C')xd6T$_|AT'T:hp$(D"_xM4@ )HF%:%d:%x$ x dd|&C')xd6T$| x$ @x$x_xpi_xM@ ):hIx$ @xWT$$:DI:4%pd'%$ da|`#*Fl%fL%$ /)xd6T$|lx:hIx$ @xWT$$:DI:4%(%f%d$ d)xd6T$:hIx$ @xWT$$:DI:4%'_xp_xM@ )f%d$ d)xd6 T$ x$ @x$x <S*-_xMh@T T:D]35TK+/ x$ x  lxw_xJ iT _xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xJ iT _xMh@$ ) '%'%4%$x$ x p :%:%d$ d d&C')xd6T$ _ T "S*-_xMh@T T:D]35TMK+/ x$ x  lxyw_xJiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$._xJiT_xMh@$ ) '%'%4%$x$ x p :%:%d$ d d&C')xd6T$ _ T "S*|_xp_x_x_x-_xMh@T T:D]35TOV_xJiT_xMh@$ )$ c`#_/6T$V_xJiT_xMh@$ )$ c`#_/6T$_t c_t_;_td_t c_FDT h%x$ x  T$(4"_M@ `#_t_;/x6T$M'T_t_J_Mh@$ )$`#_/6T$s_FDT h%x$ x  T$(4]/_t 'x6T$v__t_;__td_M@ _@M@ _@M@ _@ML@_@M@_@M@_@M@_@M@_@M@_@M4@_@MD@_@Mh@T 4T_5Tu*S*"_xF(%:D9%d:h%x$ x ddTmC)xd5T-_xMh@T T:D]35TM_xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$u_xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$!fT$ $6T$G:h%>T=$(&M@' $ 6T$S*"_x?!F(%:D9%d:h%x$ x ddTmC)xd5T-_xMh@T T:D]35T_xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$ _xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$!fT$ $6T$:!G:h%>T=$(&M@' $ 6T$S*"_x$F(%:D9%d:h%x$ x ddTmC)xd5T`:ho%>TA$%:%d:4%x$ x dd&C')xd6T$-_xMh@T T:D]35T#-_xMh@T  T:D]35T#F(%:D9%d:h%x$ x ddTmC)xd5T`:hq%>TA$%:%d:4%x$ x dd&C')xd6T$w_xJ iT _xMh@$ )$:%d:4%x$ x dd&C')xd6T$#w_xJ iT _xMh@$ )$:%d:4%x$ x dd&C')xd6T$$_xpiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$!fT$ $6T$$G:h%>T=$(&M@' $ 6T$S*"_x&F(%:D9%d:h%x$ x ddTmC)xd5T`:hq%>TA$%:%d:4%x$ x dd&C')xd6T$_xpiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$!fT$ $6T$&G:h%>T=$(&M@' $ 6T$S*"_xp *F(%:D9%d:h%x$ x ddTmC)xd5T-_xMh@T T:D]35Ts(_xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xpiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$)_xJ_xpiT_xp_xMh@$ )$:%d:4%x$ x dd&C')xd6T$_xpiT_xMh@$ )$:%d:4%x$ x dd&C')xd6T$!fT$ $6T$*G:h%>T=$(&M@' $ 6T$S*G:h%>T=$(&M@' $ 6T$ __|sL" x$ x  x_*6+_*+" x$ x  xG:h%>T=$(&M@' $ 6T$" x$ x  xG:h%>T=$(&M@' $ 6T$" x$ x  xG:h%>T=$(&M@' $ 6T$G:hN%>T=$(&M@' $ 6T$\,,\xdT$|l\<, C$`a$`a$!`a$I`a$q`a$`a$`a$ `a$ `a$9 `a$a `a$ `a$`a$`a$`a$)`a$Q`a$y`a$`a$`a( `ay/$1`a$Y`a$`a$`a$`a$`a$!`a$I`a$q`a$ `a$!`a("`ay/$#`a$9$`a$a%`a$&`a('`a$(`a$)`a$)*`a$Q+`a$y,`a$-`a(.`a/( /`a/(10`a/,Y1`a/`2`0a !9Yi )////////////nrU~}     14do_msg ScenarioNamethecellsastringasheetMaxTimemaxiter PrecisiontolassumeshowiterScaling Estimates     { !"#$%&'()*+,-./01234569:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~rU~| 3%# y X IQyH)QhI 9Y(Q 9 !9a1y Y)i1y IQIa9i!(Q0, I y !!Q!Q)!! "I"""" #!#a## $I$$$%A%%%&A&q&& &$1'q'' (9(y((()--a.Y)))*I*i**. +1+A/Q++ 0+ ,IY,9,,,-A-y0000 1)1I1i1121)2y29333/ 5 49444q5A5i5 6Y8Q666977i77 8899Y99!: x1~8!?=i~A?~~)1Cq?q ? @ I@Yq[I 1{{aف1YLقL1YHyEEE9FyFIDF F9GyGG HIHyHH9D=@pA|I LV h$u z" x$ x "xp'%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%jt$  lt*#p*F`%x$ x "2tpx6`p" x$ x "x $$ tpx`pT" x$ x "xp'%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%'`%'p%'%'%'%'%'%'%'%'%'%'%' %'0%'@%'P%jt$  lt*#p*F`%x$ x "2tpx6`p" x$ x "x" $ tpx`p< z $ < z $ H z$ @ $ Q:T%d:h%x$ x d d4A($]3)xd64" x$ x "xC:h%>4=(&M$@'  64 & $ $xd4`K? a *`:d%t$ t d Q`\t+:d/%\<A :,&]36<C:d%><=(&M@'  6< (:d/%\<A)%\+6< v0&0(:d/%\<A)%\+6<Ut',%:d/%\<= F %$ ta t6< C:d%><=(&M@'  6< (:d/%\<A)%\+6<+it',%:d%\<= F %$ ta -``av"pz)t`6 < kzuht',%:d%\<= F %$ ta -``a )t`6 <  :,&%:d!%\<C 5<p @t',%:d%\<= F %$ ta -`` `F%:!%\C )t`6< ) @%t',%:d%\<= F %$ ta -``- `F%:!%\XC )t`6< Xc\ bC:d%><=(&M@'  6< q:L/%`:d%t$ t d `<A)%T:%$  d T+)t`T6<((\< t`T< XH z$ @ $ P  c\ 5\ $ \@ $ @ $ Kz U:l%>LA$%4:8%H$ H d 4W C )H46L$>H'l% FL%$ Ha$"_H6L$?H'l% FL%$ Ha$"_H6L$J:\%4:l%H$ H d 4LA$Uz)H46L$_il%_D8%H$ XHL_ui%_D%4$ X4$$L$ )H46L$p @H $ HL%:8%:\%4$ 4 d $C )H46L$14:l%H$ H d 4)H4C:l%>L=$(&M@' $ 6L$$ (H4L$@  $ ##K"K%"'%:%:%$  d = F%$ av"u'%:d%t:x%$  d tD=4 F$%$ av") t6D4$" $  ":%>A:d%>4A$(*M@' :BuD:xBD$ 64D$ pz|'%:%:%$  d = F%$ av")6:d%:x%$  d =D 14:%:%$  d A : @uD%(%t'%>4F4%$ t$- `F%:h%x:|%$  d x8C /4)tx6D4$8f:%:%$  d A :(x]3)6:%>A:B:%>AD4:dD$" :%:T%$  d A8 $" `1,)6D4$8$s:%:%$  d A " (]3)6:%>A:B:%>AD4:dD$" :%:T%$  d A8 $" `1,)6D4$8$:%>A:B:%>AD4:dD$" :%:T%$  d =8 $ $" `1,)6D4$8$+ '%l,F%$  "r'%:%:%$  d = F%$ Q[`)6r! kz v0&= ueP'%v0F%$ a`#4*#*F%`C246 ue\P'%v0F%$ a`#4*#*F%`C246 F:r%:%$  d A )5=:G] %$  "@5 G %$  "050(]@ 0":GG %$  "05( Yl'%v0F%$ a`#4*#l*F%`C246! kzi v'&=d P'%v'F%$ a`#4*#*F%`C246!kzuJ:3%:2%$  d A `1p)6lpF %$  ":4%:2%$  d A D`1p)6 DlpF %$  "::%:2%$  d A D`1p)6 DlpF %$  ":>%:2%$  d A (ddDKF4$`1p)6 4$T:J%:2%$  d KAL]3)6 OlpF %$  ":N`1p6g OlpF %$  ":O`1p6T:P%:2%$  d KAL]3)6OlpF %$  ":N`1p6`OlpF %$  ":O`1p6T:\%:2%$  d KAL]3)6OlpF %$  ":N`1p6YOlpF %$  ":O`1p6T:%:2%$  d dAL]3)6OlpF %$  ":`1p6ROlpF %$  ":`1p6T:%:2%$  d dAL]3)6OlpF %$  ":`1p6KOlpF %$  ":`1p6T:%:2%$  d dAL]3)6OlpF %$  ":`1p6DOlpF %$  ":`1p6lpF %$  ":<%:2%$  d A D`1p)6 DT:_%:2%$  d KAL]3)6vOlpF %$  ":N`1p6OlpF %$  ":O`1p6=:G] %$  "@5JlpF %$  "050(]@p0"GOJlpF %$  "05P $ H l $ H l& $ H l )o!lp*#4*F%`C/45!lp*#4*F%`C/45!_kz#4*F%$ @Y'KFD %D`1T/46 D_kz#4*F%$ @Y'KFD %D`1P/46 DlPC l0CH_kz#4*F%$ @Y'KFD %D`1L/46 D l0MlCH_kz#4*F%$ @Y'KFD %D`1L/46 D l0CH_kz#4*F%$ @Y'KFD %D`1L/46 D l0lCHD'%lTF%$ a`#4*#*1L245 $ H l $ H l& $ H l )lP=lP=%h'%lTF%$ a`#4*#*#lH*#*#lL*#*1p2 45 lP0{D'%lTF%$ a`#4*#*1p245D'%lTF%$ a`#4*#*1p245lpF%`C! lP=D'%lTF%$ a`#4lH*#lL*1p2456'%lTF%$ av"5=:G] %$  "@54lpGi00(]@4Ip0" %$  "`#4O/45lpGi0J '%'%%lpF%$  p"`1p5=:G] %$  "@5{JlpF %$  "050(]@{p0"GOJlpF %$  "05llp*F%`C5=:G] %$  "@5JlpF %$  "050(]@p0"GOJlpF %$  "05 llp*F%`C5!'%lTF%$ a`#4*#*#'%lTF%$ a`#*#*1p2 4)66'%lTF%$ av"5 =:G] %$  "@5AlpGi00(]@AIp0" %$  "`#4O/45lpGi0J '%'%%lpF%$  p"`1p5=:G] %$  "@5 JlpF %$  "050(]@ p0"GOJlpF %$  "05 llp*F%`C5!=:G] %$  "@5!JlpF %$  "050(]@!p0"GOJlpF %$  "05-!llp*F%`C5 kzpzkzu!! `s1'% F%$ 51'% F%$ 5" $  "C:%>=(*M@'  6C:%>=(&M@'  6#\DH,PD0LTp`X4txD4$8$B`K *d:h%x$ x d Qd`x/:h%>@A0%`W C 6@0K @x $ x@%:P%`0C x6@0 `c`C:h%>@=0(&M@' 0 6@0(`$xd@0PKV:T!%d:h%x$ x d d4A$ `# _/ )xd64$=4 h%x$ x "4:T#]@x54X_FT4 h%x$ x "4$U_x64$_w__Mh@4 $ 4:T#$'__MD@ %`# _/ 6 4$X_FT4 h%x$ x "4$U_x64$#_Mh@ # _/ &_ &'_&0'Kp x'T%_Fh%$ xa4\(dd H(> F$]$ @W)@)xd64$UC:h*%>4=$(&M@' $ 64$q:T!%d:h%x$ x d d4A$)%:%$  d +)xd64$<x'T%_Fh%$ xa4v"x54q:T!%d:h%x$ x d d4A$)%:%$  d +)xd64$KTx'T%_Fh%$ xa48,dda$v"_)xd64$__c_ F_iD%x'T%_Fh%$ xa48,dd$-a`F . %$  "`# _ / )xd64$v'_iD%x'T%_Fh%$ xa48,dd$-a`# *##*'2 )xd64$_d|<_ J_ Mh@4 $ 4`# _ / 54'v'J'Mh@4 $ 4`'54L_ F%:T!%d:h%x$ x d d4C)xd54C:h%>4=$(&M@' $ 64$$ D xd4$,KV:T/%d:h%x$ x d d4A$ `# _/ )xd64$/ x$ x "lx#_Mh@ # _/  &0_&0Kx'T%_Fh%$ xa4v" d' %_FD%$ da$\( H(> F]$ @W)<)xd6 4$HC:h1%>4=$(&M @' $ 64$q:T/%d:h%x$ x d d4A$)%: %$  d +)xd64$ &K5x'T%_Fh%$ xa4`0x54X0Mh@4 .4:D/%d:T%x$ x d d$C)xd64$C:h%>4=$(&M @' $ 64$,$ 8 xd4$K;1d:h2%x$ x d d)xdC:h%>D=4(&M@' 4 6D4$ $xdD4,K*T:X2%h$ h d QTPh*:X3%P0A H_60 *:X4%P0A H_ 60 c%:X5%P06C750'___!(:X3%P0A )%P+60 f%:X5%P06C750 fXl'_ _ _ (:X4%P0A )%P+60 f%:X5%P06C750 fXl_NC:X8%>0= (&M@'  60 (:X3%P0A )%P+60 f%:X5%P06C750 fXl_ C:X9%>0= (&M@'  60 (:X4%P0A )%P+60 f%:X5%P06C750 fXlK:X:%P0A H::%PA H60 C:X;%>0= (&M@'  60 (:X:%P0A )%P+60 f%:X5%P06C750 fXlK:X<%P0A H:<%PA H60 C:X=%>0= (&M@'  60 (:X<%P0A )%P+60 f%:X5%P06C750 fXl+:X>%P0A :&]360 &F0%:X>%P C 60 K:X>%P0A H:>%PA Hd60 C:X?%>0= (&M@'  60 (:X>%P0A )%P+60 f%:X5%P06C750 fXl cXl @g:XA%>0A :B:C%>A:D`#_(/60 {_(_#*#E*F :XF%>0A:D_ k`#_(26 0 0:X:%P0A `#_0/60 =:@G]0 X%h$ h "0@h50X_0F@0 X%h$ h "0 U_,h60 K:H'0_,_0MX@ % `#_0/60 c_(E*F :XI%>0A:D_0F`#_(/6 0 .:XJ%P0KA L]360 ]_(E*F :XM%>0A:D:N`#_(/6 0 Y ]_(E*F :XM%>0A:D:O`#_(/6 0 .:XP%P0KA L]360  ]_(E*F :XQ%>0A:D:N`#_(/6 0 H ]_(E*F :XQ%>0A:D:O`#_(/6 0 ^_(E*F :XR%>0A:DuSD`#_(/6 0 ^_(E*F :XT%>0A:DuUD`#_(/6 0 ^_(E*F :XV%>0A:DuWD`#_(/6 0 m:XX%h$ @h0YA Z' KF %Hd#_0/h6 0 =:@G]0 X%h$ h "0@h50 X_0F@0 X%h$ h "0 U_,h60 w_,_0MX@0 $ 0:@G '_,_0M@ %`#_0/6 0 c_(E*F :X[%>0A:D_0F`#_(/6 0 .:X\%P0KA L]360  ]_(E*F :X]%>0A:D:N`#_(/6 0 /]_(E*F :X]%>0A:D:O`#_(/6 0 0:X<%P0A `#_0/60 =:@G]0 X%h$ h "0@h50AX_0F@0 X%h$ h "0 U_,h60 K:H'0_,_0MX@ % `#_0/60 c_(E*F :X^%>0A:D_0F`#_(/6 0 .:X_%P0KA L]360 4]_(E*F :X`%>0A:D:N`#_(/6 0 ]_(E*F :X`%>0A:D:O`#_(/6 0 0 '@%_(FX%h$ h "hcP &C:X%>0= (&M@'  60 ,,lP< hT0  d u *d:h2%x$ x d Qd`x&dF@%:h3%` C 6@ &dF@%:h4%` C 6@ -ư>F@%:h:%` C 6@ &F@%:h>%` C 6@ --C6?F@%:h<%` C 6@ #0%:hJ%`@KCL5@#0%:h_%`@KCL5@#0%:h%`@KCL5@#0%:h\%`@KCL5@#0%:h%`@dCL5@#0%:h%`@dCL5@#0%:h%`@dCL5@c` &K*d:h2%x$ x d Qd xl:h%x$ @x@YA Z' KF %:3% C x6 @ l:h%x$ @x@YA Z' KF %:4% C x6 @ l:h%x$ @x@YA Z' KF %::% C x6 @ {:hX%x$ @x@YA Z' KF %HdF%:>% C x6@ --C6?F@%:h<% C 6@ l:h%x$ @x@YA Z' KF %:<% C x6 @ 7:h%x$ @x@YK# 0/x5@#0%:hJ% @KCL5@#0%:hJ% @KCL5@7:h %x$ @x@YK# =/x5@s#0%:h % @KCL5@#0%:h_% @KCL5@7:h %x$ @x@YK# 0/x5@#0%:hP% @KCL5@#0%:hP% @KCL5@7:h %x$ @x@YK# 0/x5@{#0%:h\% @KCL5@#0%:h\% @KCL5@7:h%x$ @x@YK# 0/x5@"#0%:h% @dCL5@#0%:h% @dCL5@j#0%:h% @dCL5@#0%:h% @dCL5@7:h%x$ @x@YK# 0/x5@#0%:h% @dCL5@#0%:h% @dCL5@4#0%:h% @dCL5@#0%:h% @dCL5@7:h%x$ @x@YK# 0/x5@#0%:h% @dCL5@#0%:h% @dCL5@#0%:h% @dCL5@#0%:h% @dCL5@K c &C:h%>@= (&M@'  6@ d ,` 4 xd@ @K  lL:l%>L=<(&M @'!<^6L<cC ',%:l%>LA<%$  "6L<" $  "*:l%$  d Q :,&%:l/%LC5L :,&%:l!%LC 5L:l%<5<#,%:lc%LdCL5L&FL%:l%<C6L<c*:l2%$  d Q&dFL%:l3%<C 6L<&dFL%:l4%<C 6L<-ư>FL%:l:%<C 6L<&FL%:l>%<C 6L<--C6?FL%:l<%<C 6L<#,%:lJ%LKCL5L#,%:l_%LKCL5L#,%:l%LKCL5L#,%:l\%LKCL5L#,%:l%LdCL5L#,%:l%LdCL5L#,%:l%LdCL5LcK @/:lm%$ @L=<(&M @' < 6L<,4 L<\KzeC:l%>L=<(&M @' < 6L<\$ L<\KzeC:l%>L=<(&M @' < 6L<\$ L<Kzeq:T%d:h%x$ x d d4A )%: %0$ 0 d +)xd064 C:h%>4= (&M @'  64 $ ,xd04 @  $ $K" d$ d "dpz*d'D%v'FT%$ Qd[@hr<kzvkT%hCL kzpz hs,=(&M@'  6,0@<h d,K7- (X-%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8$ xH8|KQ:D!%T:X%h$ h d T$A :&]3)hT6$" h$ h "hC:X%>$=(&M@'  6$" h$ h "h fXlgv0&0:D%T:Xo%h$ h d T$A(]/')hT6$" h$ h "hC:X%>$=(&M@'  6$" h$ h "h fXlK v0&=h'D%v'FX%$ T'%v0F4%$  '%'(%'8%'H%'X%'h%'x%'%'%'%'%'%'%'%'%'%'%'(%'8%'H%'X%'h%'x%'%'%'%'%'%QT[Qh[$  "a$v"'%v'F%$ av") 6$4h'D%v0FX%$ ha$ h5$" h$ h "hC:X%>$=(&M@'  6$" h$ h "h fXl6h'D%v'FX%$ ha$v"h5$" h$ h "hC:X%>$=(&M@'  6$" h$ h "h fXl cXlC:X%>$=(&M@'  6$:(`l8 hT$KV.v x$ x "kv_4x" x$ x "x a bT:Pc%`:d%x$ x d `0dAL ]3)x`60ze*T:Pf%`:d%x$ x d `0dAL ]3)x`60!ze*zegx$ @x)x v0&0K/:dh%x$ @xYix5:djx$ @xW0):Pj:@k%lv0*F%f%`$ H`  )x`6 0 v'&0gK/:dm%x$ @xYix5KV:djx$ @xW0):Pj:@n%lv'*F%f%`$ H`  )x`6 0J:P%`:do%x$ x d `0AUz)x`60$`x$ Hx  Q`xg:djx$ @xW0):Pj:@p%e@f%x60:djx$ @xW0):Pj:@q%:r%: o%`$ ` d A%fx%)x`6 0:djx$ @xW0):Pj:@s%:%: o%`$ ` d A%fx%)x`6 0:djx$ @xW0):Pj:@t%:3%: 2%`$ ` d A Hk%fh%)x`6 0:djx$ @xW0):Pj:@u%:4%: 2%`$ ` d A Hk%fh%)x`6 0:djx$ @xW0):Pj:@v%::%: 2%`$ ` d A Hk%fh%)x`6 0:djx$ @xW0):Pj:@w%:>%: 2%`$ ` d A Hdk%fh%)x`6 0:djx$ @xW0):Pj:@x%:<%: 2%`$ ` d A Hk%fh%)x`6 0T:Py%`:d2%x$ x d `0KAL ]3)x`60zzzzg:djx$ @xW0):Pj:@{%z@f%x60T:P_%`:d2%x$ x d `0KAL ]3)x`60 z| z|g:djx$ @xW0):Pj:@}%|@f%x60T:PP%`:d2%x$ x d `0KAL ]3)x`60S z~\ z~g:djx$ @xW0):Pj:@%~@f%x60T:P\%`:d2%x$ x d `0KAL ]3)x`60# z, zg:djx$ @xW0):Pj:@%@f%x60T:P%`:d2%x$ x d `0dAL ]3)x`60 zS zSg:djx$ @xW0):Pj:@%S@f%x60T:P%`:d2%x$ x d `0dAL ]3)x`60 zU zUg:djx$ @xW0):Pj:@%U@f%x60T:P%`:d2%x$ x d `0dAL ]3)x`60 zW zWg:djx$ @xW0):Pj:@%W@f%x60cx$ @x)x(_4 x$ x "xC:d%>0=(&M @'  60$(0 x`0dK?" x$ x "x _RO:T%d:h%x$ x d d4A$U_6)xd64$_6:W_B:T%d:h%x$ x d d4A$U)xd64$c h :T_BMh@4 4$ $%x$ @xY'KF %`#_8/x64$K@x'T%_8Fh%$ xa4`F$ x64$_B_N _Rh Ux'T%_8Fh%$ xa4`F$ .`#_8/x64$:T_BMh@4 4$ $%x$ @xY'KF %H_@x64$_@:T_BMh@4 4$ $%x$ @xY'KF %`#_</x64$_<Mh@ -_<Mh@4 .4`#_</54d_@@:T%d:h%x$ x d d4B$`#_D/)xd64$_@P0:h%>4A$`#_</64$l_D_@0:h%>4A$`#_</64$l_D=:TG]4 h%x$ x "4@x54&_<Gih_T_T(h]@S_<_T"4 h%x$ x "4`#O/x54&_<Gih_T_@> K xx xUx'T%_<Fh%$ xa4`F$ .`#_</x64$$ xx lx< D_<Fhx$ @xW4)$U_Lx64$_LP \_<FD:hjx$ @xW4)$:T(]@x64$\Z_<FD:hjx$ @xW4)$:TU_Lx64$_LY_L_<Mh@4 $ 4_<J_LiTx$ @xW$)(D"_<M@ `#_</x6$4Z_<FD:hjx$ @xW4)$:TU_Lx64$JN _LN _L_<Mh@4 $ 4_<J_LiTx$ @xW$)"_<MD@ `#_</x6$4D_<Fhx$ @xW4)$U_Lx64$^=:TG]4 h%x$ x "4@x54: "_<G_L_L: R_<_L4 h%x$ x "4`#O/x54"_<G_L __8B*#_D*#B*F$_<Mh@4 4`#_H26$4e_6@:T%d:h%x$ x d d4B$_HF]3)xd64$ _B_Nh _<Mh@ W _R_B_Nh _Bd _R_@  ' %:h%>4A$:DB:%>A:D" p @x'@%_8M`@ FP%$ x `F" :E:%>Ap:`DP_@D@0%d$ d ")xd6*4$P ppP0=_<Fh"4 4$(T]364$ '0%:h%>4A$:DB:%>A:D" p @x'@%_8M`@ FP%$ x `F" :E:%>Ap:`DP_@D@0: E:%>A:D" _<Fp`"P P@%d$ d ")xd6>@4$P ppP0`P '0%:h%>4A$:DB:%>A:D" p @x'@%_8M`@ FP%$ x `F" :E:%>Ap:`DP_@D@0: E:%>A:D" _<Mp@` `P"@ @ %d$ d ")xd6@@ 4$P ppP0`Pgx$ @x)xT_6@:T%d:h%x$ x d d$)xd5$:hjx$ @xW4)$:Tj:Ds%:%:o%d$ d d A%f0%$ H  ) xd6 4$Z:T%d:h%x$ x d d4A$(U_P)xd64$:hjx$ @xW4)$:Tj:D_NM@  %:_PM@ p pP%d$ @d YA%f%$ )xd64$pP :hjx$ @xW4)$:Tj:D_NM@  %:_PM@ p pP%d$ @d YA%f%$ )xd64$pP :hjx$ @xW4)$:Tj:D_NM@  %:_PM@ p pP%d$ @d YA%f%$ )xd64$pP x$ @x)xC:h%>4=$(&M@' $ 64$h$ (xd4$pP pP0`P@ H,KO:T%d:h%x$ x d d4A$U_d)xd64$_dd_d@:T%d:h%x$ x d d4B$`#_l/)xd64$"_l"_l_f _h"_lp"_l_f _h"_l_f _hs_f_lMh@4 $ 4$ $:D%d:T%x$ x d dC )xd64$:Tl_lJ_f_lMh@4 4$ $%:%d:D%x$ x d dC )xd64$:l:ll:l:h%>4A:D%>$A Z:%d:%x$ x d d\C)xd64$\F(%:T%d:h%x$ x d d4C)xd54q:T%d:h%x$ x d d4A :l:%>$A3)xd6 4$B _hq:T%d:h%x$ x d d4A :l:%>$A3)xd6 4$ _hL_hD%:T%d:h%x$ x d d4C)xd54U:h%>4A$%d:D%x$ x d dW C )xd64$1d:h%x$ x d d)xdC:h%>4=$(&M@' $ 64$C:h%>4=$(&M@' $ 64$x ,$ : xd4$\_&KF:4&%:T%d:h%x$ x d dC )xd5F:4&%:T%d:h%x$ x d dC )xd5:$l:ll:l:h%>A:D%>A Z:%d:%x$ x d d`C)xd6`F(4%:T%d:h%x$ x d dC)xd5F(4%:T%d:h%x$ x d dC)xd5U:h%>A%d:D%x$ x d dW C )xd61d:h%x$ x d d)xdC:h%>=(&M4@'  6$ 6 xd`%x Ka*T:X%h$ h d QTPh+:X%P0A : &]360 XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXl:X%P0A : (]<:%PA h$ @hW)(p]/`'Ph60  XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXlKnh' %:X%P0= F%$ ha8,TTav")hT6 0  XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXlKa" h$ h "hWh' %:X%P0= F%$ hav"_ph60):X%P0AU_|60/L h$ h "lLh:X%P0A L h$ h "H T$ T " '%%lHi %lLD$ D p":%PC )hTD602:X%P0= F 60Wh' %:X%P0= F%$ hav"_rh60_r XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "h"_r_p_r XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "h0:X%P0A `#0_t/060-_tMX@0 $ 0:@l]350dK_tJ_tMX@0 0 .`#0_t/060-_tMX@0 .0`#0_t/050_tJx0:X%P0A `#0_t/060 2:X%P0= F 60 XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "hK3:X%P0= F 60) :X%P0A : %>A/:%PAP : l:p%>A`/_|@:%PB:%>Ap/`'P:@%P A :%>A/:%PA :Pl:%>`A@0/_|@:%PB:%>Ap/`'P@0640P`p `@ 0pl Z :X%P0= F%h$ h " h60 Xz C:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "hg B:X%P0=  $ : l]360( 0:X%P0A `#0_t/060e ;: l:X%P0A `#0_t/060$ :X%P0A L h$ h "H T$ T " '%%lHi %lLD$ D p"`#0_t/0)hTD60 B:X%P0=  $ : l]360 0:X%P0A `#0_t/060 ;: l:X%P0A `#0_t/060\h' %:X%P0= F%$ ha`#0_/0h60Uh'@%_FX%$ ha0`F .`#0_/0h60_Jx@h'@%_FX%$ ha0`#0_/0h50>_|@:X%P0B`#0_/060):X%P0AU_60d_F ]:X%>0A/_F]:%>A/60K:Xm%h$ @h0YA)_M@ 10D'%>0F%$ :m%,$ @,YA)('4%$ T' %$ Tav" '%'%'%'%'%'%'%'%'%'%'%'%'%'P%'p%'%'%'%'%'%'0%'@%'%'%'%'%'%' %Q([ QD[$$ av"/0) hT,$ 60\ X%1_F ]:X%>0A360C:X%>0=(&M@'  60C:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "h1_F ]:X%>0A3600:X%>0A`#0_t/0600:X%>0A`#0_t/060l_-_tMX@0 $ 0:@l]350q<_tJ_tMX@0 0`#0_t/050_tJx3 XC:X%>0=(&M@'  60(:X%P0A)%P+60 fXl" h$ h "huD D_B*#0_*#B*#_t*#_20 _q_:@%T:X%h$ h d T0=  U)hT60ce_F]_@:@%T:X%h$ h d T0Bg)hT60___d_T_@:@%T:X%h$ h d T)hT5_b_@_@:@%T:X%h$ h d T)hT5gh$ @h)hO:@%T:X%h$ h d T0AU_)hT60:Xjh$ @hW0):@j: s%:%D:o%T$ T d DA%f %,$ ,)hTD,6 0_M@ 1:Xjh$ @hW0):@j: _D%lT'%>F%$ Ta`#0*F%f %D$ D20)hTD60:Xjh$ @hW0):@j: _D%_@fp%T$ T)hT6 0"_tMX@ F0 50&_xKX_tFX%h$ h0TTa`#0_x/0)hT60_x&0:Xjh$ @hW0):@j: _D%l_t*F%fp%T$ T)hT6 0:Xjh$ @hW0):@j: _D%_x@fp%T$ T)hT6 0H:Xjh$ @hW0):@j: _D%l_t*F%fp%T$ T)hT6 0 cXl X3=_tFX"0 0(@]360` '%:X%>0A: B:%>A:D" ` @h'4%_Mp@ FP%$ h `F" :Ep:%>`AP :D_D:@E:0%>A`:D@"0 0 _tF" %T$ T ")hT6>0P``pP `@0 1 '%:X%>0A: B:%>A:D" ` @h'4%_Mp@ FP%$ h `F" :Ep:%>`AP :D_D:@E:0%>A`:D@"0 0 _tM@ " %T$ T ")hT6@0P``pP `@0 h$ @h)hcPC:X%>0=(&M@'  60 ,lP20hTD,($ 0`Pp`P `@0 p`P@0xKYc\L L6\LT1D:l%H$ H d D )HDC:l%>\=L(&M@' L 6\L6$ $HD\LDK:T%d:h%x$ x d d4A$)xd54,(h]3y(T]3y(D]3:T%d:h%x$ x d d4A :l:%>$A/:|%:%$  d \A :l:L%>,A /)xd64$\, F:&%:T%d:h%x$ x d d4C )xd54q:T%d:h%x$ x d d4A$)%:%$  d +)xd64$(h]3^:h%>4A$%:%d:D%x$ x d dC )xd64$(h]3^:h%>4A$%:%d:D%x$ x d dC )xd64$C:h%>4=$(&M@' $ 64$D(xPxd4$\, ZKc\L L6\LF:&%:4%D:l%H$ H d D\C )HD5\F:&%:4%D:l%H$ H d D\C )HD5\:l:ll:l:l%>\A:$%>LA Z:%D:%H$ H d D`C)HD6\L`F(%:4%D:l%H$ H d D\C)HD5\F(%:4%D:l%H$ H d D\C)HD5\q:4%D:l%H$ H d D\AL)%X:%\$ \ d X+)HD\X6\L" H$ H "HC:l%>\=L(&M@' L 6\L$$ > HD\X\L``K !C:l%>L=<(&M @' < 6L<`$ L<p(K6X'\%v'Fl%$ XaHv" X5HC:l%>H=8(+M@' 8 6H8 l E:\%:l%X$ X d HA8 b )X5H \:l&]32C:l%>H=8(+M@' 8 6H8K\ X'\%v'Fl%$ QXoH%f%$ @W )6HC:l%>H=8(+M@' 8 6H8C:l%>H=8(&M@' 8 6H8($ $XH8`K]d:h%x$ x d dWT A :D%>$A3)xd6T$- (D'%vFh%x$ x "x- (D(%vFh%x$ x "xC:h%>T=$(&M@' $ 6T$$ (xdT$K7- (X,%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8-$ xH8K7- (X*%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8 $ xH8K7- (X&%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8$ xH8K7- (X.%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8|$ xH8K7- (X,%vFh%x$ x "xC:h%>H=8(&M@' 8 6H8c$ xH8pKOD'H% h%$ Da48,00a v")D064 `pzipz\p$ D04 pKPD'H% h%$ Da48,00a v")D064 apzjpz\p$ D04  Kl F\bV\ '%'%(%H%X$ X p"\`#_/X5\"_f:H"\ \_F8" :(`#_/6 \6\ _$ \ #=/5\GH#_/|3\ _$ \`#_/5\"_j>:H"\ \_J__M8@ " :(`#_/6\:H"\ \_Ji_J_M8@ :(j("_M@ "t td:TD`#_/6\tdDK.X$ @XW\)`#_/X5\&_$X$ QX[@_r<_ _)X'(%H%$ XX_6\ _$ \ #=/5\/X$ @XW\)_FH]3X5\p;X'(%H%$ Xa\`#_/X5\H#_/3\ _$ \`#_/5\<_sH=(&M@'  6Hl,l\,DX HTK8L:\&]3l'l'l(dHkl4l0l,l$l ,HkLHk\Hk<\ "4\l6 <=(&M@'  6<8 T(l(<l\      !"#$%&'()*+,-./012kderivsearch Convergence NonNegative thestringentrystarttheend 9CellRefRelation FormulaText KeepFinal reportArrayTypeNum SheetNameLoadAreaSetCell MaxMinValValueOfByChange Iterations AssumeLinearStepThru Derivatives SearchOption IntTolerance AssumeNonNegSaveArea UserFinishShowRefM0* pHdSOLVER$@T=j  3 J < stdole>stdole( `%V*\G{00020430-C 0046}#2.0#0#D:\EXCEL 97\]2.tlb#OLE AutomationXMSFo@rms>SFBrmHs3AD452EE1-E08F-101A-8-02608C4D0BB4AWINNT\System32\FM20.DLL#Microso(ft 9 Y Object Library/;C1|p||00}#0|#j00896125D 8-89961D@2-8DAF@5x345@V6Profiles\cyu\LOCAK*mrU~~~~~~~4~~~~~~~~~~~~~~~~5~~~~3~~~:~~~: `_˄  a + Qxqxxxxy9yYyyyyyy za 1 a  N8 1Qi1a a Q:(3)Ii )Iq )Ii ) Q y  9 a  A i ) I i  9 Ia a v(AAAB1BYByBaa + wwsgSkc_?O;73y19 SOLVER VBA_Functions ThisWorkbookSolver1Solver2Solver3Solver4F /D:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  !0F 3D:\Program Files\Microsoft Office\Office\EXCEL9.OLBExcel !@0FD:\EXCEL 97\stdole2.tlbstdole P.E .`M D:\WINNT\System32\FM20.DLLMSForms aa`%aSE 3D:\WINNT\Profiles\cyu\LOCALS~1\Temp\VBE\MSForms.exd 9aap Auto_open Auto_close Cont_button Stop_buttonPush_add Push_close Push_delete Push_guess Push_change Push_options Push_reset Push_save Push_load Save_modelSaveLoad DoTheSave Load_model AdjustablesObj Show_options Option_OK Option_cancel Reset_allMax_button_pushMin_button_pushValue_button_push Solve_problem Finish_cancel Finish_help Problem_ok Define_namesDelete_constraintChange_constraintAdd_constraintValid_constraint Constraint_OKConstraint_signConstraint_Add Push_scenario Scenario_OKConstraint_help Stop_help Load_help Main_help Option_help Scenario_helpIsCellReference IsCellRefGet_nameFormnamesolver_options2  OptionsstubMain Set_defaults Get_settings SolverNameNamefixsearch Stylecheck SaveLoad_ok XX(04PThlt solver_msg_46 RangeText Save_dialogF`_˄F`_˄DFWorkbook @FDialogFrameCaptionFF Constraint_list Solver_dialogListBoxesListCountReferenceStyleAddress The_areaEditBoxesShow solver_err_msgxVBE6.DLL S  Saveload Adjustable_cellsF , FName solver_msg_3a Focus`FFF i  Tolerance Names x  Optimum_cell solver_msg_7 Options_dialog Max_time Max_iter OK_buttonButtonsDismissButton solver_msg_8 solver_msg_9 Precision solver_msg_10 Convergence solver_msg_10a solver_msg_11 optionsfunc   optarg1 := ,  optarg2 . 0. optarg3 AssumeCheckBoxes Value optarg4 TRUE FALSE Show_iter optarg5 optarg6 optarg7 optarg8 solver_tolRefersToLocal optarg9 auto_scl optarg10 optarg11 non_neg optarg12 max_buttonOptionButtons min_button solver_opt Delete ' !solver_opt = solver_adj !solver_adj solver_dialog !solver_typ !solver_val dvalueof !solver_num !solver_tim !solver_itr !solver_pre !solver_tol !solver_cvg assume !solver_lin !solver_neg !solver_sho !solver_scl Tangent !solver_est Forward !solver_drv Newton !solver_nwtListIndex solver_lhs solver_rel solver_rhs Add_dialogDropDownsList solver_msg_int solver_msg_binfĤIx8< '! delfunc addarg1 addarg2  addarg3 IndexRemoveItem !solver_lhsRefersTo !solver_rel !solver_rhs e    / (  H k h solver_msg_22 `   <=   >=   =  lhs rhs <= >= solver_int solver_binDropDownLines solver_msg_46b solver_msg_25a Y  solver_msg_20 ! solver_msg_21 SolvSolve options solver_msg_23 solver_msg_24 solver_msg_151AddItemF addfunc 1  solver_msg_25 Scenario_name Scenario_dialog solver_msg_24aScenariosChangingCells LockedAddSolvSave solver_msg_24b P  GET.DEF( ",GET.DOCUMENT(1)) String Select O Activate ll (08<DHTltxTypeProtectContents solver_msg_1 SolvReset solver_msg_1c W solver_msg_1b solver_msg_1a SOLVER32.DLL Solver Add-In solver_typ Cancel dValueof okfunc okarg2 okarg3 okarg4 okarg1 Add Delete Change Save_model SolvOkDialog Load_model Save_again CallSolver msg_setupNumberFormat '!Solvecall solvefuncFinish Finish_ok Do_Answer Quit_reportDo_Sensitivity Do_Limits Quit_limits $A$1 0  Optimum_Cell Adjustable_Cells Reports solver_val =1 =2 =3 value_buttonRemoveAllItems solver_num solver_tim solver_itr solver_pre solver_cvg solver_lin solver_neg solver_sho solver_scl solver_est Quadratic solver_drv Central solver_nwt Conjugate show_iter solver_msg_5 loadfunc loadarg1Formula =MIN Min_button =MAX Max_button COUNT Value_button =COUNTA =COUNT =INT =VAR add_dialog =SUM solver_msg_6 ))=1 =0)+( solver_msg_6b solver_msg_6c .   $4<@DT\`hpx|$  solver_msg_26 solver_msg_27 solver_msg_28 SolvOptions Finish_dialog Keep_solutionEnabled solver_msg_29 solver_msg_30 solver_msg_31 solver_msg_32 solver_msg_33 solver_msg_34 solver_msg_35 solver_msg_37 solver_msg_38 solver_msg_39 solver_msg_40SolvFinishDialog solver_msg_41 solver_msg_42 solver_msg_43 solver_msg_29a solver_msg_44 Final_message Labels finish scenario scenario_dialogSelected solver_msg_77   solver_tbl $F$11:$G$ solver_msg_47Row Column Cells solver_msg_48 solver_msg_50 $A$1:$A$3MF solver_msg_49 solver_msg_51  [ ] solver_msg_52 solver_msg_53 solver_msg_54 solver_msg_55 solver_msg_56  ( ) solver_msg_57 solver_msg_58 solver_msg_59 solver_msg_60 solver_msg_61 $B$7:$E$8 solver_msg_62 solver_msg_63 solver_msg_64 solver_msg_65 solver_msg_66 $B$ :$E$ solver_msg_67 solver_msg_68SolvOk solver_msg_69 solver_msg_70 solver_msg_71 solver_msg_72 solver_msg_73 :$G$ $D$8:$E$8   % done. solver_msg_74 solver_msg_75 B:GAutoFit anscount "  solver_msg_78SolvLoad solver_msg_79ColumnWidthFontBold solver_msg_80 solver_msg_81 solver_msg_82 solver_msg_83 solver_msg_84 solver_msg_85 solver_msg_86 solver_msg_87 solver_msg_88 solver_msg_89 solver_msg_90 SolvFinish solver_msg_91 solver_msg_92 $B$7:$H$ solver_msg_93 solver_msg_94 $B$7:$E$ solver_msg_95 solver_msg_96 solver_msg_97 solver_msg_98 solver_msg_99 solver_msg_100 solver_msg_101 solver_msg_102SolvGet solver_msg_103 solver_msg_104 solver_msg_105 solver_msg_106 solver_msg_107 :$H$ solver_msg_108 solver_msg_109 solver_msg_110 B:H sencount solver_msg_111 solver_msg_112 solver_msg_113 solver_msg_114 solver_msg_115 solver_msg_116 $B$6:$D$8 solver_msg_117 solver_msg_118 solver_msg_119 solver_msg_120 $B$11:$D$ solver_msg_121 solver_msg_122 solver_msg_123 solver_msg_124 SolvDelete solver_msg_125 solver_msg_126 solver_msg_127 solver_msg_128 $I$11:$J$ solver_msg_129 '!SolveCall solver_msg_130 B:D F:G I:J limcount bb4TX`d.hpSolvAdd SolvChange '!MenuUpdate SolverAdd SolverChange SolverDelete SolverFinishSolverFinishDialog SolverGet SolverLoadSolverOkSolverOkDialog SolverOptions SolverReset SolverSave SolverSolve Range TheCall Solver_msg_45 save_dialog Solver_err_msg Boolean 1 2 Solver_msg_46 dshowref solver_msg_19 Language Excel4Functions xladdin.chm :MS EXCEL HELPF solver_msg_150 " '!Unregi solver_msg_25b Guess solver_msg_3 solver_msg_4 Continue solver_msg_131 solver_msg_132 : savefunc savearg1 =MAX( =MIN( =COUNT( =VAR( ={ } 3 4 INT( 5 =SUM( SUM( =INT(SUM( ))FormulaArray ( =1)=1 solver_msg_se solver_msg_45 Non_neg solver_msg_17 resetfunc solver_msg_18 solver_msg_7a solver_msg_46aHide solver_msg_76@dDbFxMET@> LL  L L"L $ 14@\ er_m`rX.B`@@0 `0,'`($\@ ` $+L`h0Ho LLiD iF (iH HiJ   14@\ '+P `H (3k iD ' iF  reliH (  iJ '  14@23\ rhs@L +l` `@ 5Dk ( iT  iV  $iX  iZ @ %i\ `  i^$   i`(  ib,  !id0   if 4  ih8   ij<  14@ \ '"+p ` 884k  14@\ !+v@ ` 9o ..it '" 14@ H +~ ` ;o HHiz  i|<  14@H `2@ $ 0 `@ ` H   %@p`p``l p_adj $ Z"@8H (@F '@4 um @ $ '@P ؆@( @h !@ @ hL\.N$@ @ @ @ @X @@ @ @p @t @d @T @P @L @H @8 @0( @H @` @x @ @ @ @ @ @ @  @8x @Ph @hX @H @8 @( @ @ @ @ @( @@ @X @p @ @ @ @t @d @T @0D @H4 @$ 8X(h(0`"l @ Z@@ @> @X, @ @ @ @ @0 @( PL\.N@p @ @ @ @ @ @` @| @Hl @`\ @L @xH @D @H@ @0 @ @ @ @  @8 @P @h @ @ @ @ @p @` @P @(@ @@0 @X @p @ @ @ @ @ @ @ @0 @ @| @l @@j a@h a@X @H @@8 @4 @X$ @p @ @ @ @ @ @ @ mx08Xx0x`Hp$@"$`&l X" Z@D @B @ 0 @ @ @ @ @ @" L\N@8 @P @h @ @ @ @( @ @p @("` @pP @@L @XH @"D @4 @$ @ @ @ @ @ @0 @H @` @x @ @ t @ d @ T @ D @!4 @ !$ @8! @P! @h! @! @! @! @! @! @! @ @ @"p @h"n "@"=@ $l #h"=|.@"\ @"L @#< @#8 @ #( @8# @P# @h# @# @# @# @# @ 8$h"I@$ @ @H$ `$ $\@ $H$\@ H$"P%H0%&%%&@'&P%x'h%`.l x%P%& Z@@ @> @%, @0& @& @`& @H& @' @' %&@& &&@_ &&'&@' 0'&&@ X''&@ h'@'''/x&@ @ `(()((`(@)x(`2l (`( T@X @V @(D @X)4 @()$ @p) (@) @) @) @ @ `@,* +**-P+p*@,*`:l *p*h+Z @8+< @: @+( @+ @x+ @ @+ ,P+@+ @+ @+ @X, @- @, 0,+$@, ,,$*@p, @, @| @x ,,&@,v -,*@(-t -,*@-,,@P-r h-(-0@p x-P-0P-4@l @\ `Hx0../..X.8/p.`@l .X.ZLv@/X @V @P/D @ @ / @/ .D@h/ @/ @ @/ @/ @/ @ @| 0p(HH11`1011030`Ll 00ZL\@h2X @V @1D @@ @x10 @1 @1 @1 @1 @ 2 @2 @2 @82 @2 0v@2 @ @2 @x @2h @2X @H P2h P  ( 4`4H404343`Pl 33L@H @F @x44 @4$ @4 @4 @4 @5 @4 @ @ H ` 5 @ `766@6(65 85`ll 55Z@6X @V @X6D @p64 @6$ @6 @7 @7 @6 @7 @07 @7 @H7 @7 @x7 @ @7 @7x @8h @d @T @D 5 8(9p9X9@9898`pl 98 @X @V @D @4 ( (::x::::(:;@:`vl P:(:ZL@P;h @;X @F @8;4 @0 `:vD@ ; @h; @; @ @ @; @; @; @ : H=<=0==8>< ><`~l <<P>Z@h @`=X @F @x=4 @> @= @= @= @= @> < @> @ =JTL@`> x>8>@_ >`>`>#@ @> @> @>p @?` @(?P @@?@ @X?0 @p? @? @? @? @? @? @@ @@ @0@ @H@ @`@ @x@p @@` @@P @@@ @@0 @@ @ > @ P 3$*\Rffff*0;37ff36b9*\R1*#229*\R1*#c4*\R1*#b3$*\Rffff*0837ff36b9*\R1*#3e*\R1*#5c*\R0*#13$*\Rffff*0737ff36b9*\R1*#67*\R1*#175*\R0*#f*\R0*#10*\R1*#1d5*\R0*#14*\R0*#1a*\R0*#19$*\Rffff*0:37ff36b9*\R1*#b8$*\Rffff*0937ff36b9*\R1*#cdd  B  .( "8HRP p %  %.9  0 8HX` h  %  %  % 0 %8HP Xh   %  = J J    ( 8 .9@ p        `^  X %` px(P  p^XL|   0 8 %H X`h p6   % 9   %  (#0HX `pp^^@ L|    %     4C( ` h  p  B     .  "   R    % ( 0 8 @  X  %` p x  .9             % 0 8 @  P  %X h p x   %      %         %  0 8  @  =H  J`  x  J      (-       (08 @P`^X   % (P  (68  p %x 9   % # W8         %  08 @ H X %`px X   %4C X` hx B   . "R  %(08@ X %`px.9     % 08@ P %Xhpx  %  %  `^    % (P W0         % ( 0 8 @  P %X hpx.9    (y0 V8X` :xx    D $ : (&W8"P` B{"P <r(:h= H :x(Lh&W"P,YE&P0X`h p x   / ( 0 8 @H P ` %hx L|p   %4C   B    ( H  .P  "` p $)x    %    "   !+! ! %(!8!@!H! &h!  !!! !!*! !  ! !" """8"@"H" P" p" " " " " " " " "" """ ""# ###  #(#0# 8# %@#P#X#4C`### B ### .# "##$)# $ % $0$8$ @$`$h$ p$ %x$$$4C$$$ B $$$% .% "(%8% @% X% %h%x%%% %%% "%%8%&& &2 &0& 8&(N@&h&*Xp&&(N&&(N&'*X'8'2c@'x'@' ' ''2c'((@@( ( ((2c(((@(8) @) H)X)`)*Xh) $) )  ))))*X) $* *  * *(*0**X8* $h* x* *****X* $* * *+++2\+ $P+ `+  h+p+x++2\+ $+ +  ++++2\+ $0, @,  H,P,X,`,*Xh, $, ,  ,,,,*X, $- -  - -(-0-*X8- $h- x-  ----*X- $- - --..2\. $H. X.  `.h.p./x. %...4C... ./ B /// . / "0/@/,H/x/ / %////.9/ /0 00 0(0 @0 %H0X0`0 h0BUx04G001 1 %1 1(12C01h1p14Cx111 B 111 .1 "112 2.9(2 X2h2 p2222  2 %2 2222363  3 %(3 83@3H3$?P3  x3 %3 333  33+3  3 %3 4444 04 %84H4P4X4.9`4 44 4444474 4 %555 5 (5X85X5Fv5Fv06 x6 6 %6664C666 B 6777 .7 "(787@7 `7 p7 %x7777 7 %7774C788 B 88 8 .(8 "88H8P8X8 &x8  8 %8 8888 &8  9 %9  9(90989,}X9  9 %9 99999 9:2-:  H: %P: `:h:p:x:: ::2-:  ; %;  ;(;0;8;X; h;x;; ;;;  ; %; ;;;< < 0<@<H< `<p<x<  < %< <<<<< <== (=8=@=  `= %h= x====,}=  = %= =>>>0> H>`>2-h>  > %> >>>>,}>  ? %(? 8?@?H?P?p? ??2-?  ? %? ?@@ @ @H@@@@H@@AP ApAxA A FxAA FxA@BHBPB pB FxBB FxBC C(CHHCCCHCDDH(DpDxDVDDD E Fx(EpE FxxEEEEPE@FHF hF FxxFF FxFGG  G0G 8G %@GPGXG4C`GGG BGGG .G "GG G G %HHH  H0H B 8H@H $HHXH`H .hH "xHHH H %HHHH.9H II  I0I8I@I XI %`IpIxII>zI I %IIIBUI4G8JpJ xJ %JJJ(J $JJJ4CJKK B  K(K $0K@KHK .PK "`KpKxKK0TKK KLLL L (L8L@LHL6PL "hL4CxL %L LLL?L?LM* M8MPM hM xM "M&M0MM "MM MN NN N@N HNPNXN`NhN1pN %NNN4CNNN NOO(O $(O8O@O POxh] !' ( 14A@ !l  ! Y('  (zhk`X $ $Z'  (Dz d $Range X $L$\ !'k X ' $L'k $ $Z'  (z`kX $\'  (z(k $'  (zk   '  (Pgzk   $ $Z'  (z`dX. . %,  . %,' b.    . %,'k $ $Range X $L$\ !'jkx X '0k $L' PdH X'Hkk0k(k   solver_adj %!$! $ solver_adj %!$$N!'  (zkkx'h solver_num %X $'8    (Xn' !' !solver_lhs  $$= $! B@' !' !solver_rel  $$  B@ ' !' !solver_num   B@Hp ' !' !solver_rhs  $$=solver_msg_int %!d B@ dX' !' !solver_rhs  $$=solver_msg_bin %!d B@k  (  (r'zk $\ $! $! $!'  (sz(k d  %x$'  (szkk $== 'k  (' !' !solver_lhs  $$= $! B@' !' !solver_rel  $$  B@' !' !solver_rhs  $$  B@' !' !solver_num   B@  ($  (hy'zsolver_err_msg %!d &A@ g Y(' ix]$] !' ( A@ !l  ! Y('"({  ( zk $ $Z'"  (zdx $Range X $L$\ !'k0 X ' $L'k $ $Z'"  ( zk $\'"  (`~zk $'"  (zXkP   '"  (zk   $ $Z'"  (zd. . %,  . %,' b.    . %,'@k8 $Range X $\ !'k X 'ȃ $L'kk   solver_adj %!$! $ solver_adj %!$$N!'"  (z(k k' solver_num %X $' $\؆ $! $! $!'"  (.zpkhd`  %x$'"  (z(k k $== 'k'"  _msg_5 $! solver_lhs $$ %X $$!  solver_rel $$ %X $ " '"$ "$ '$kk " '"  (solvzk "('"  ('zk  (!d' !' !solver_rhs $$$  B@  (%'"  ((z  solver_err_msg %!d &A@g  Y('"i ]]0%@ !'$ ( solvA@ !l  !$ Y('& solv  (%z k  $ $Z'&  ( z d x $Range X $L$\ !'$B$k0 X ' $L'  k $ $Z'&  (ctioz k $\lv'&  (!dz k $'&  (ZzX kP   '&  (z k  !dOn Error Resume Next( solver_adj %!$! $ solver_adj %!$$N!'&  ($z` kX kP '@ solver_num %X $' '$'" $ $Z  $B$ $! solver_lhs $$ %X $$!  solver_rel $$ %X $ " '" " '$k k " 4'&  ( zk "''&  (zkdx $Range X $L$\ !'(k0 X 'B@ $L' $\$ $!  $!'&d $!  '& fk  $ solver_rhs $$ %X $'j j$0' j$!$|'j    formula j !'r(F r$ j' !'! j' !'!'r rb$ j r $ j j r !  $'j  j' !'!'r d rb j r $ j j r ! $'j j !'r fxkpkh. . %, j.'r rbsolv . %, j r j.'rkd jx solver_rhs $$ %X $'j % j !! j' !'! j' !'!'r j j r !  $'jd j !!'r6 j j r ! $'j kkkkd jXX 'j%kh solver_lhs $$ %X $$! solver_rel $$ %X $ jX &X   '$ykk $''&  ( zkx  (' !' !solver_num   B@ ' !' !solver_lhs $$$ solver_lhs $$ %! B@ %' !' !solver_rel $$$ solver_rel $$ %! B@ ' !' !solver_rhs $$$ solver_rhs $$ %! B@%4  (''&  ( zPHsolver_err_msg %!d &A@ g Y('&tiH]0]H !'  ( A@TheCall %!N$% Y('.   ( z8k0 ( solv *$ *$Z'*k * * '.  ( zk ,$ ,$Z , , '.khk` *4'  $>= $ (N  'k ( ,$ ,$Z'('*',  , , solv $,%KT'(KT'*KT',nH@ ( * ,!NA@&k (A@k *A@k ,A@kk'.  (`Fzsolver_err_msg %!d &A@%g`iX`H] !'KT (solverA@TheCall %!N$ Y('2   (zdTheCall %!N' A@Tk'2  ( zphsolver_err_msg %!d &A@ g(i ]_bin] !'  ( A@ 6$ 6$Z Y(': %  ( zkx 6 6  Y(': kH 8$ 8$Z !'.Pd 8$!'.(k !'B:G .$B@H 6KT solver_opt %X $':KT solver_typ %X $X':!dKT solver_val %X $':KT solver_adj %X $':KT solver_num %X $X':solvKT solver_num %X $X8"   u solver_lhs $$ %X $ +($':!dKT solver_num %X $XX (   solver_rel $$ %X $ +x$':KT solver_num %X $Xx(!   solver_rhs $$ %X $ +$': KT solver_tim %X $X':!d  &A@'d':k@ KT0 solver_itr %X $X':_msg_4  !d'd':k KT solver_pre %X $X':_tbl  ''ư>':'kh KTX solver_tol %X $X':!N  '?':k KT solver_lin %X $X':'  '':kKTx solver_sho %X $X':  '':kKT solver_scl %X $X':$  ('':kKT solver_est %X $X':  3$'':k@KT0 solver_drv %X $X':!d  !'':kKT solver_nwt %X $X': %  ['':kpKT` solver_cvg %X $X':   $'-C6?':blkKT solver_neg %X $X': solv  %'':kn $B@H  (!dz`Xsolver_err_msg %!d &A@(g Y(': %i] !' (_msg_8A@]0H`xsg_8 >$ >$Z'@  (solvzPdH@ >$Range >X $L$v% >!'>k >X '> solvk >$L$v('@  (sg_9zkA@( Solver_msg_45 %!d save_dialog %"!(* solv >The_area save_dialog %"%((*A@DA@'@  ($z solver_msg_6 %!d &A@zsolver_err_msg %!d &A@$B$7gHi@0]p !' c (sectioA@ D$ D$Z!d D$Range DX $L$\_9 D!'D!dk DX 'D( D$L'D_9h F$ F$Z'L  (sg_9z0 k( k D$ D$Zsg_9 D$! $'L  (z k  F F Fsolv'L  (!dzh k` H$ H$Z'Hk8 F H$solv'L  (!dz k k J$ J$Z'L  ($z d  J$Range JX $L$vlv J!'J%kX JX 'J$ J$L'Jlv0 k(  J$! 'L  ( z k   ( ' !' !solver_opt= D$! B@' !' !solver_adj= J$! B@' !' !solver_typ F B@' !' !solver_val H B@  ( f'L  ('zX P Solver_err_msg %!d &A@ g i ]P ]h !'d ( A@ D F H J$L'2 2 2'P  ( zpkhA@'P  ( z@8solver_err_msg %!d &A@$gi ]H !'  ( A@ T$ T$Z TX TX TX'l  ( zHk@k8 V$ V$Z VX VX VX'l  ( zkk X$ X$Z X %x X %xin c'l  (zXkPkH Z$ Z$Zsg_7 Z$String ZTRUEX,'Z k Z$Boolean Z$String'l  ( zkk \$ \$Z \$String \TRUEX,'\k0 \$Boolean \$String'l  (zkk ^$ ^$Z ^TRUE1'^ $k ^FALSE 2'^PkP ^X ^X 'l  ((zkk `$ `$Z `TRUE1'`k `FALSE %2'` k `X `X 'l  ( zHk@k8 b$ b$Z bTRUE1'b k bFALSE 2'bB@k bX bX'l  ((zkxkp d$ d$Z!d d %x d %xdsenc 'l  ( zkk f$ f$Z f$String fTRUEX,'f!dk f$Boolean f$String c 'l  (z@k8k0 h$ h$Z h %x h %x 'l  (zkk j$ j$ZX j$String jTRUEX,'j kX j$Boolean j$String% 'l  (solvzk?k?  ( T$ T$Z' !' !solver_tim TX B@kp? V$ V$Z' !' !solver_itr VX B@k? X$ X$Z' !' !solver_pre X %x B@k> Z$ Z$Z ZX,' !' !solver_lin B@d>' !' !solver_lin B@k=k= \$ \$Z \X,' !' !solver_sho B@d0=' !' !solver_sho B@k<k< ^$ ^$Z' !' !solver_est ^X B@kh< `$ `$Z' !' !solver_drv `X B@k; b$ b$Z' !' !solver_nwt bX B@k; d$ d$Z' !' !solver_tol d %xd B@k; f$ f$Z fX,' !' !solver_scl B@d:' !' !solver_scl B@k8:k0: h$ h$Z' !' !solver_cvg h %x B@k9 j$ j$Z jX,' !' !solver_neg B@d89' !' !solver_neg B@k8k8  (A@'l  (z88solver_err_msg %!d &A@g`8iX8` H8] !' (A@A@'p  (z77 Y('pi7 7 !'7]( !' (A@ t$ t$Z'v  (z87d07(7 t$Range tX $L$v t!'tk6 tX 't6k6 t$L$v'v  (z6k6A@ t$L$!  t$L$! 'v  (z6k6 Solver_msg_46 %!d save_dialog %"!(* tThe_area save_dialog %"%((*A@D'v  (zh5`5$A$1$B@H !'05(5solver_err_msg %!d &A@g4i4@ 4 !'4] !' (A@]  |$ |$Z !! |dshowref %(d 4dshowref %(k33A@  Y('~z3k33 $!  ( solver_msg_19 %!d &A@  ('~z03k(3 $!( $!H '  $ !N + !P +  '2 ( $B@H' ! '!SolveCall %R'(2 ( $ JY('~d1 '~k1 z$ z$Z zA@Tk1d1A@Tk1 $L$B@H  (z`1X1solver_err_msg %!d &A@g11 Y('~z00$A$1$B@H !'0i00TAttribute VB_Name = "Solver4" Option ExplicitX0FuncPZAdd(CellRef As Variant, Re laH(Inte ger, al FormulaPText5)  g.Pro cData In`voke_ \n1 Orror GoTo e hand@ling  Dim rememberscreen, dummyg .Aph.SUpd'False,elerIveSheet.Type <> x@lWorks 0Or AtectConts Then%k:CVErr(xlValue)V> Exit ~End IfK\mainB]@9IsMissK_E)6Is'orJ331@8..Fd.ResuN.Ael)Range" A@Not IsDerence(Styleche@ck(CStG8)R)Ll =E.ress Z+  I!釁:6)7z772f7&rf\O10 -J{hr#fNJric(_$?F _$_$DL8 < 1Ao> 5KRG$6ng_$oDw4k''N*O3&+++?PP".N" rnbal DecimalSeparati"_Jao5num@T@?B&u`")), 2" = helzpұnA!3 :="'" &Oʳq "!4 lhsTrimpr(+0O@ ptTo0= U:, Visible:=( as XC p_rel r_ O!Os& fI:= }0r?excel4l:uage.e*msg_int ? }M |r_ & geJ bin '@ 25eSheet.Name = thesxnp Application.Scr@eenUpd8ngremembers0fSolPvAdd@0&Exit Func*End If If IsCellReference(FormulaText) Then),Rang ".Count > 1 AX <> m)02b3<  Els"epNotNu@meric( ;Evaluat  .n`3@hLeftAp, 1) _"<="Ksy@& WDɊAvhelp̮s.A:="'" & & "!s@er_lhs Trim(Str(num +0), sTo 2&ress, Visibl`e:=Favu%relf%Rel &"r"Aw"7m $330" 03s E/z̜kd,|mainerror:XMsgBox excel4luage.#"_msg")., 32, , a[file h83 nd  handling CVErr((xlVe)L ah' e C As Variant-IInteg@er, OpalIu)h AttributeH .VB_Pro cDataaIn`voke_ \n14"c'Dim matc }fiш+, dummyK`wAzEh}On /or GoTo 5 .erACUType!x lWork› OrJ(tectCo2nts -B" ?~=~ m IZ0IsMiss+($') |Is7Zyw* 1 x Res x NPp = "=<"{ Style@,ck(Ce){a3lQe60YA!OR+SfG/F 2 ///+Oe%%bo o o o o Is L.:95 <г F> 5;Eo o o o o g< 4k'؆*(zZ( ϠJ?  @KE )oExtv "."1_'nrn"al }DecimalSeparaxtorCn In@, A Do W~hЈt $SMid`R.d}  Loop\S\"_\2\9 ڑ=] /?x (^t(Nr GoTo mainerror End Ifp ,If Relation > 3 ThenahOn EDsume Next8range(ActiveSheet.Names("solver@_adj")).Count <> Unk(R:CellRef)|, "JK S tCh+ = 1S Applicr.ScreenHUpdngremembers Exit Ftunooyntum*0#Mid(CStr+")2), fIsVerence(FormulaT@p) yqk> 1 A@CgsErf30ffflse9Not IsNric(Evaluat ILI@*ʗ0 뗀0LefBtIr, 1)"<="t(5Q& h" YmatchLes'W i1 U * ?Add8resAZ_lhs" & TrHim(_i),0 2 _ .))N.e bQŕ= _ _xrelR ;G %+0g")@E&i))- mZg4 ߚߚ j0La0a+helpsAn ΃bAE !0:="'!?n& "!ZrP8C To:=g, Visibleat@jkj&_& &%: MsgBox ex cel4lpua8ge.C9y_m sgya, 32, , Afil2epE83 p udlingc CVp(xlP:VTe@js DeleVDc As Varpiant=@Integer, dOpalILX) Attribute.VB_ProcDataInvoke_A $" \n14"Dim 5Oe=o &ߌh'9me!v"Sheet.Names("solver_adj"))).Count Then  SDelete = 1 2Application.Scre enUpdngRremembe rs0 lExit` Func8End If (numT0On Error Resume Ne xt -Mid(@CStr(Ajve+")), 2),GoTo maine4iDmatchesIf IsMissing(Fo@rmulaTN) Or Z  i&1 >e?Ȁ0Range(CellRef).AddresB {lhs" &@ Trim(Hi)@A _@ŅAhRel{(`relR)Θ@RE+K> HL@HiiL3ɕ O>  4@#HƀJD0*wF(pElseucTypeKb= ""Y" aNNot g]erence`Vyle ock|)m)K Weg2@ bHdSt" :Is  z ' f#*jIn! <, `j ><$~"']`e"'!") t, ?A5#Do While C _c F`Left,- 1)FR&Len) -A%?y Loopo(L;HOO%8OOOme)'^?s/~rob1."."+rInternal(xlDecimalSeparat|orC@/ 1."_?@/qPV@,+=    Os  /)\#2?O@)`ͯ`3S\19M,MsU>R_/Xpfe?eNN- <q o o , o[I,o/ۻ0ki2CDbl(g+?.&21w1Zsolver_lhs" & Trim(Str(i), 2)).Addresst Mid(CtActiveSheet.Names(b"rel|the_right) = stringmatch) Then  remember.i Exi t ForEnd IfNexFt If T0 sSDelet e84$Application.ScreenUpdng&s ӆOunoj C$helps^n# :="'&  "!num", RefersTo:= - 1, Visible:=False͍C))I ,Nj*.0,Gͨ,,tr,,= @yUg>0J?g{)gfmainerror: MsgBox excel4language.R e_msg").T , 3 2, , kfile, 183 r handl *CVErr(xlValue) yFF{ e Fin@ish(Opal Keep` As Variant, reportArray )h Atbu .VB_ProcDataaInvoke_A`" \n1D4"&On or GoTo F*Dim answ C!Boolean, sens_limit2iInteger, c U=kE I$erNot IsNumeri 2`_tr! ce*4 4UBound(1:> 3) Q* 9 "2c` G=Mi0 Each c0 In N\adj Ip%c.+oldvarsAi + qTruO$MOO[H= -HHu!L PSct Case}pZ= |U=5S"Sw93  ]q' 70@Cy+/Defuz_s&.Ot[CDo_Ah ` Y No_SkiityOF 0`LmI ?/` //////dhDialog_l}_X=?&_ac eQMM#OxIooQ.T@+o&% φSo h +&0 Else answer = excel4sheet.Range("TheCall").ValuFinishEnd IBfSolv6Dialog02Application.ScreenUpdn#remembers0Exit Func2 mainerror:MsgBoxluage"ser_/_msgText, 32, , helpfile,0 183Na Sd8  jGet(TypeNum As Integer, OBpOal SNameVariant) Attribute(.VB_Pro cDataIn`voke_;"@ \n14"wOn E~ GoTo handlingDim n>of 20 ( AF BGH = Av:e .,j WorkIs(' I(T*!IFHh).Selectc1c Case d,k"1c l@ MPid(C ](- s("Dopt")), 2dDB 2O CDbl( _typ 3#B,gvam4_ P adj5O #(num6 Re& ' F4or= kUB`ound(  R f i)?v`lhs" & Trim(ADi)@ N@$ dE7trP)FtJrel4@88fG. fGResuw o@] YA!Nrx/#o(9 xNLQ-ti|9F  > h 9b= R't10wv9i.1 = itrKE  r vbg ti p|re b60.0f i    WtofFH0# e p (#/!@%`71V /0SP /0s;(s$x c ?-Zsho ! Q1 < Ds   te/1lsc%rro%o%i%z %և? %%q es5/%_UXUU_ 1_F /"$drv$X) If Err > 0 PThen X= 0DSolvG@et = 1*E nd IfCa se 186Onor Resume Next8LCDbl(Mid(CStr(ActiveSheet.Names("swer_nwt")), 2)Y9U_cvgD_0.0002u$(`e1=bFpalse\ɒSelecDWorkss(rem ember).I Application.Scr@eenUpdng@+ CExit Funomainerror:MsgBox excel4language4.Re _msE.T, 32, , hel@pfile,3c4 han`dlingV@(xl@ValueXABG(  A Load(Area As Variant) Attribute .VB_ProcDataaInvoke_a %" \n1 4"c FHGoTo &$Dim *k@ 73 :7DerjInteger, k@c, ByC-g>e` @`$`/, theopaEsAAdummy`8obj_doneaBoolea@IsMissf/) Or Is6orj6!wQ+ඬV!E i~0TypeA(= ""Z" A NotCellRe f(StyqheckCM))) fQ=F.Address6 eH"ZPc `V 2kaiet_a0ll (YThisbook.Dialog ave_dB")dFr`.CaVISa _45?`!/  EditOw@,_aEoPcS _ okp_set~t02xP/ZrsZZlOTZZD!6 ZZaianga)aa & "] |^Ok(O"al SeNt9qI^, M`axMincnBeOfRdwdOk_d_d_d_d_dC$O.##%_d4svCe]4J#E]]W'WVIsVerence^WOW!=/W+WWK_^oY"2Vr)rX 1POk 2P"is Y 3 Q,e .Count 1t1S2?_ұxSiT!?>6` <> 1*2/3 a4 w(tP(6((k7X= 3"3$Nrxic(`!F3.̯d.q+ If If IsMissing(ByChange) OrX ErrorPTh enSolv@Ok = 4$Application.ScreenUpdngLremembers0fExit 0Func5ElDseOn  Resume NextTyp eName= "R" And NotCellRef(Stylecheck(CStn)) op^.Address@E0  /*E ){GoTo maineƃ:~.Count > 0 l Q&h: MsgBox excel4luage:.A" F n_m@sg").T, 32, , ARfile, 18f3r r' e cDial og(Op!al dN As Variant, 4+EJ)h Attribute*.VB_ProcDataaInvoke_q" \n14"'xDim `ulr @ W<Z@t7uK 0(/, aalVqc`<4: @kf}Mc#Fd=@2O0?2Sf?2?2TU?2?23 ?2 =21s'29Ti`M/23It4ers-(4Prec@\onn(AssLpuarStepTh ruEstiPmateoDeriv vSearch?!IntTol1@nceScalpConvergeHNonNeg(BBBBBA"154A綄L,orC(s#* CDbl(< "1nt() E?1  iF1l7 Mw 2BBɯ?sGUiEuE(=P&?93??O#Q??Wo&k`P"܉3CBool(L"TRUE"ة P \2*"eanv Q s6,?OOrG ߳ End If If Not IsMissing(StepThru) AlErrord0Then|Ty@peNameD= "Str"  Z`a = CBool5"TRpUE")\ k<> "Hean"#olvO@ptionsA5>8Applica .ScreenUpdngremembers Exit Func fEstimates  Ms 1"R&YJ FALSEr2Y CDbl( ) m@c1Bj2g6F-ggDeriv@vQh hWi i TjL 55M575t!i5`B`mearchC|-6SW6z666)6n}6866vIntToleraxnce66)EPvalu(K<@ 0 Or ? @>= 1009&&&&Scal`ip\$r{152`0{3f1{n!yo{b!_{eCSZa10Zono{oFT o{o{n{Converge*Г*g*<=*a2**1?Gp suAssumeNonNeg*O+k+ 2*+L3?,D9,V,,2OC-AuveShee t. Phelp:sn@9 >/MaxTimY(s.Add :="'" & & "!s+er_", RefжTo:=r%, Visible:=False n ItPe}/(  itr X 1! XڐPrec0on3 pre rte(G S2Lin * `<= True>P''me(w u 1/!0E'r_~2#o`&And Not IsError(StepThru) Then  If CBool|= True XNames.Ad:="'" & ActiveSheet.B$0"!solver_sho", RefersTo:=1, Visible:@=FalseE Hq28If@EMissing(Estimates) G estC8Dbl?e^Derivai/ ?0q|drv00SearchOptxion`K?11nwPap1IntToleranceO1K1tolJ1@Applic@Aon.Evalu@Z(/ 100.dScal e3?*ߎߎ& ǎcKߎ Bw!?,(` u:wCon@geEE__cvgEDDAssumeNonNegE3FkFFFneK FbFFF-!Fn@= thes1ynmGet_sett0:sSyU`s = 0CBScreenUpd Cng0remembp|Exit Funpo`maine:MsgBox excel4language.Re("_msg").Text, 3 , helpfile, 183 P )  Re@(%s Variant Attribute.VB_ProcDataInv0oke_p" \n14" On  GoTo a handNDim  <`?qer$s2_all z(R)c.{ iC"V(xlPVaxlue"Save(AArea A6sele* bcurrenta= Sres2K&.b !5p?gUIs5u) Orgkap 1 %!@*f*0_ N= TypVeQ, )"A"ahCellyheck(CStͥ ) 1 '2''rsf H!WThisWorkbook.Diahlogrsf _Nd"PfFrq.Ca2ŀ/jg j 〴i_46j o1mEdit pe`_Fpw%RLoad_ok0z1 #\OOBen Exit FunctioselePerror: Range("$A$1").Sdcurrentarea = 2.Address|esume Next mainMsgBox excel4lguage.psolver_._msgzTB, 32, , helpfile@, 1830iE0nd   SMe(Opal UserFinish As Variant, ShoPwRef) Attribute..VB_ProcDataInvoke_B" \n14"!On E GoTo " #handling"Dim rememberscre@'ApplicaG.S xUpdF0alseBYrN,am iNInteger, c If Not @IsMiss+(s\@YndHTh/shee$t.Čdslref@FormulAveWor@kbook.A& & "!"@$6E0h"sAIf eGet_sett@<BadjS"" :'ATBUCVD(xl@Value),@ $R ').Count > 200@Tru> ſ{r!{_19{o:Q\I'1_%#ReaVoldvar\s(t#/if@Na:t=i8D`T Each c In0 ei), _A??? ZoT?SϏϏϏϏ"V       !"#'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~`$D8 'xh0b4TX`d.hpesses MEd@> "LLLLL F( $1h 6O  @  P X `h Lp " 4C "  3 (038 PX`@Th :  > 8 /@   X  p     4C   " &   " 0 8 @ 4CH   "   &    &)( 4CP     2x   *  ) *_(  >X &Ox "  ,X  &      " (?0  #X Dh  x     Bq  $  ( .0"2@AhnR@oP  $0 $0 $0(PHxX2(\7 %  2Q(` h2Qp2Q2Q2Q"4Px 8Z8Z8Z8ZH8Z\  8>cH >c>c>c >c`>c>ch   >c 2 (Q(7P `*up*77@,0,8 P h2p,X ^(700g@0sp(W(V(\(V@2P`7h x f0 8 JH &W(Z2rB0Bx*J  X `4eh  .g 0UDlLP Dl(T    (X8 4e  .g 0L Dl8 L   Dl (T ! H! P! X!Xh! !4e! " .g" 0U8"Dlh"L" #Dl#(TP# x# B# # ,;# .g$ Dl0$ (Tx$ B$ $ ,;$ .g % DlP% (T% B%&&1& $0&2@& %P& "`&p&x&4C&&&,L& &'' $' '('4C0'h'p'x' "' 8''4C'2( %( " ( %0( @(P(X(4C`((( "( ((&( ) )@8) 4Cx) )))&))4C)(*0* *8* )X*;x* >*&O*"* *,X* &(+ @+P+X+ "`+p+ %x+(?+ #+D+ +++ ++Bq, $H,X,`,p,x,, .,(,,,+,n,RP-@o- -2Q.2Q@.2Qx.2Q.2Q. /2Q0/2Qh/2Q/2Q/2Q02QH02Q02Q08g0(12Q012Qh18g11 18Z2 828ZH28Z28Z28Z2 (3 8Z83 8Zp3 8Z3 8Z3 8Z4 8ZP4 8Z4 8Z4 \4X5 8Z`5 8Z5 \506868Z@6x6 6 626,X66 ^6X77`7*^p7*j7"S7"M7:z 8"M`8 8 :z8 :z8 :z9X9`9p9 x999 f90: 8: JH:: &W::"Q:,i:<(;<h;B;<; 0< B@< B< B<= =1(= $@=2P= %`= "p===4C===,L= >>> $ >0>8>4C@>x>>> "> >> >>? ?@8? 4Cx? ???&)?4C?(@0@ 8@@@2xH@@ *@ )@;@ >@&OA"0A @A,XHA &xA AAA "A(?A A #ADB B(B0B 8B@BBqHB $BBBBBB .B(B,C+Cn(CRC@oC 0D2QHD2QD2QD2QD"4(E PE2QpE2QE2QE2QF@jPF@F2QF2QF2Q G2QXG@jG@G2QG2Q(H2Q`H2QH@jH I (I0I28I(QHI7pII %I I2QI9II*uJ*0J@`J:xJJ J J JFiJ2K,X(K7XKhK XxKK*^K*jL"S@L"MhL2LNrLNrLBZ@MM "M0MM "MEM N 4N(N 0N8NF@N N IN "MN EN "MO(O 8Z0O 8ZhOOBZO2OP "P0PHP "PPE`P xPP P 4PP PPPMPFP @Q IPQ "MpQ EQ "MQQ 8ZQ 8Z RXR`R pR2RR2RJRJRHS/PS pSRSS SRSHT7PT1`T1xT1T $T2T T %T "TTU4CU@UHU,LPU UUU $UUU4CUUUV "V (V8V4C@V2xVJVJV (WR8WW WRWX X %X "(X %8X HXXX`X4ChXXX Xx" prepare and display finish dialog@]H`x " solver_msg_26 %!d solver_msg_27 %!d solver_msg_28 %!dDReports Finish_dialog %"%\( Z Keep_solution Finish_dialog %"%X(NReports Finish_dialog %"%\( KT solver_msg_29 %!d'Reports Finish_dialog %"%\(KT solver_msg_30 %!d'Reports Finish_dialog %"%\(HKT solver_msg_31 %!d'Reports Finish_dialog %"%\(KT solver_msg_32 %!d'KT solver_msg_33 %!d'KT solver_msg_34 %!d'KT solver_msg_35 %!d'KT solver_msg_37 %!d'KT solver_msg_38 %!d' KT solver_msg_39 %!d' KT solver_msg_40 %!d' KT solver_msg_41 %!d' KT solver_msg_42 %!d' KT solver_msg_43 %!d'KTsolver_msg_29a %!d'Reports Finish_dialog %"%\(S solver_msg_44 %!d'n  Final_message Finish_dialog %"%(dA@'_xfinish' ( Finish_dialog %"B@$ scenario Scenario_nameScenario_dialog %"%((*scenario_dialog %"B@$k finish Reports Finish_dialog %"%\!''   solver_rel $$ %X $X 'yk $$ ( solver_msg_77 %!d &A@k` ($A@k0$ A@k$ A@kk Keep_solution Finish_dialog %"%X!N b3 Application.Run ("'Excel4Functions'!Cleanup") Else7 Application.Run ("'Excel4Functions'!RestoreCall")'  $ $ (N  'k|solver_err_msg %!d &A@go user clicks ok on finish dialog` ('|@8solver_err_msg %!d &A@go creates answer report]Ph](]@Xp solver_tbl %!N$ solver_msg_47 %!d &A@|d' solver_opt %X $$!N' solver_tbl %! ' solver_tbl %! ' solver_adj %!$!'   %!N'    %!N ' '  solver_adj %!$ !N +  'hk` ( solver_msg_48 %!d (F !' !B@ ('' solver_msg_50 %!d  $$ (  '  '`kXP !'? $A$1:$A$3$( $A$1:$A$3$!( solver_msg_49 %!d  !  solver_msg_50 %!d$( solver_msg_51 %!d [ !] $( solver_msg_52 %!d  $( target section  solver_msg_53 %!d' e solver_msg_54 %!d' e solver_msg_55 %!d'k( solver_msg_56 %!d ( )$(' $B@ solver_opt %X $' $B@  (  ' solver_msg_57 %!d$(d' solver_msg_58 %!d$( solver_msg_59 %!d$( solver_msg_60 %!d$( solver_msg_61 %!d$( $B$7:$E$8$B@k adjustables section! solver_msg_62 %!d  $( solver_msg_63 %!d  $( solver_msg_64 %!d  $( solver_msg_65 %!d  $( solver_msg_66 %!d  $( $B$  $$:$E$   $$$B@ constraint section$   solver_msg_67 %!d   $(kp  Z solver_msg_68 %!d   $( solver_msg_69 %!d   $( solver_msg_70 %!d   $( solver_msg_71 %!d   $( solver_msg_72 %!d   $( solver_msg_73 %!d   $( $B$   $$:$G$    $$$B@dp   solver_msg_57 %!d   $(kk fill in target cell4 $B@ solver_opt %X $' $B@   $%$( $! $$( $B@ $( $(  $D$8:$E$8$(P2k   ( fill in vars' $B@  solver_adj %!$   solver_msg_48 %!d d    % done. (Fk $B@  %   $( ! $   $( $   $( $   $(P $   $( $   $(P  ' $B@ $B@ fill in constraintsP2  x2  2 solver_msg_48 %!d d      % done. (Fk  0=     %! 6 0 %4$'d`     %!'k0     $(  $    $(6 $L $%!N    $( $L $%!P    $(P7     %!NP8KT  08<==     %! 6 0 %4$'d<=     %!'>kX      $(     %!N solver_msg_74 %!d    $(     %!N    $(<dX solver_msg_75 %!d    $(    $(kKT  0==     %! 6 0 %4$'dh=     %!'k(      $(    %!N solver_msg_74 %!d    $(@     %!N    $( d( solver_msg_75 %!d    $(    $(kKT  0>==     %! 6 0 %4$'d8>=     %!'Ck      $(     %!N solver_msg_74 %!d    $(Z     %!N    $("d solver_msg_75 %!d    $(`F    $(k $L $%!P    $(PHGKT=solver_msg_int %!d'      $( solver_msg_75 %!d    $(    $( $L $%!P    $(P(IKT=solver_msg_bin %!d'      $( solver_msg_75 %!d    $(    $( $L $%!P    $(Pn##B:G$B@  ( $B@ (F (|##solver_err_msg %!d &A@g@#8#anscount !B@'"" A@ d"solver_err_msg %!d &A@g"k"o"1 user escaped out of answer or sensitivity report8" solver_msg_76 %!d &A@ $B@ (F (  ( Cancel'|!!solver_err_msg %!d &A@g`!oX!@ create sensitivity report(!]]8Ph   solver_rel $$ %X $X solver_msg_77 %!d &A@|H k@ 8 solver_tbl %!N$ solver_msg_47 %!d &A@|d solver_tbl %! ' solver_tbl %! '   %!N'   %!N'    %!N ' '  solver_adj %!$ !N +  'k (  (  solver_msg_78 %!d (F !' !B@ ('' solver_msg_79 %!d  $$ (  '  'kx !' $A$1:$A$3$B@H? ( !( solver_msg_49 %!d  !  solver_msg_79 %!d$( solver_msg_51 %!d [ !] $( solver_msg_52 %!d  $( adjustables section solver_msg_80 %!d$( solver_msg_81 %!d$( solver_msg_82 %!d$( solver_msg_83 %!d$( solver_msg_84 %!d$(  solver_msg_85 %!d$( solver_msg_86 %!d$( solver_msg_87 %!d$( solver_msg_88 %!d$( solver_msg_89 %!d$( solver_msg_90 %!d$( solver_msg_91 %!d$( solver_msg_92 %!d$( $B$7:$H$  $$$B@d solver_msg_93 %!d$( solver_msg_94 %!d$( $B$7:$E$  $$$B@k  constraint section solver_msg_95 %!d  $(  solver_msg_96 %!d  $( solver_msg_97 %!d  $( solver_msg_98 %!d  $( solver_msg_99 %!d  $( solver_msg_100 %!d  $(solver_msg_101 %!d  $(solver_msg_102 %!d  $(solver_msg_103 %!d  $(solver_msg_104 %!d  $(solver_msg_105 %!d  $(solver_msg_106 %!d  $(solver_msg_107 %!d  $( $B$  $$:$H$   $$$B@dsolver_msg_108 %!d  $(solver_msg_109 %!d  $( $B$  $$:$E$   $$$B@kdsolver_msg_110 %!d  $(k fill in vars' $B@  solver_adj %!$   solver_msg_78 %!d d    % done. (Fk $B@  %  $( ! $  $( $  $( $  $(P    %!N  $( $  $(P     %!N  $(    %!N  $(    %!N  $(k  ' fill in constraints     solver_msg_78 %!d d      % done. (Fk  0=     %! 6 0 %4$'d`     %!'k0    $(  $   $( $L $%!N   $( $L $%!P   $(P     %   $( $L $%!P   $(P      %   $(     %   $(     %   $(k B:H$B@  ( $B@ (F (|x p solver_err_msg %!d &A@g0 ( sencount !B@'  A@ d solver_err_msg %!d &A@g kx op  create limits report@ ]0H`x]] X   solver_rel $$ %X $X solver_msg_77 %!d &A@|H k@ 8 solver_tbl %!N$ solver_msg_47 %!d &A@| d ' solver_opt %X $$!N'x solver_tbl %! ' solver_tbl %! '   %!N'   %!N'    %!N ' '  solver_adj %!$ !N +  'XkP (solver_msg_111 %!d (F  ( !' !B@ (''solver_msg_112 %!d  $$ (  '  '@k80 !' $A$1:$A$3$B@H? ( !( solver_msg_49 %!d  ! solver_msg_112 %!d$( solver_msg_51 %!d [ !] $( solver_msg_52 %!d  $( target sectionsolver_msg_113 %!d$(solver_msg_114 %!d$(solver_msg_115 %!d$(solver_msg_116 %!d$( $B$6:$D$8$B@ adjustable sectionsolver_msg_117 %!d $(solver_msg_118 %!d $(solver_msg_119 %!d $(solver_msg_120 %!d $( $B$11:$D$   $$$B@? $(solver_msg_121 %!d $(solver_msg_122 %!d $(solver_msg_123 %!d $(solver_msg_124 %!d $( $F$11:$G$   $$$B@? $(solver_msg_125 %!d $(solver_msg_126 %!d $(solver_msg_127 %!d $(solver_msg_128 %!d $( $I$11:$J$   $$$B@ fill in target' $B@ solver_opt %X $' $B@x  (  solver_msg_129 %!d$($(d  $%$( $! $$( $( $(PkhI adjustable section B@'' ' !solver_sho !B@ $B@  solver_adj %!$ $B@  solver_msg_111 %!d d  % done. (Fk H  %  $( ! $  $( $  $( $  $(P $B@' ' !solver_adj= ! B@' ' !solver_opt= ! B@' ' !solver_typ B@pF (' ! '!SolveCall %R'(F ( !$!N'  $!N'dE'kEsolver_msg_112 %!d  $$$B@    $( $  $(P   $( $  $(PdDsolver_msg_130 %!d  $(solver_msg_130 %!d  $(kXD' ' !solver_typ B@ $B@C (' ! '!SolveCall %R'C ( !$!N' JY('pC  $!N'd@C'k0C(C $ !$(Nsolver_msg_112 %!d  $$$B@    $( $  $(P   $( $  $(PdBsolver_msg_130 %!d  $(solver_msg_130 %!d  $(kA  ' B@ $B@hA $B@' !' !solver_typ  !B@' !' !solver_sho  !B@@ solver_opt %B@> ' !' !solver_opt=  !B@k @ ' !' !solver_adj=  !B@k? $B@B:D$B@ F:G$B@ I:J$B@  ( $B@  ( (F (|?>solver_err_msg %!d &A@g>>limcount !B@'p>h> A@dH>solver_err_msg %!d &A@g>k>o=! user escaped out of limit report= solver_msg_76 %!d &A@ $B@' !' !solver_typ  !B@' !' !solver_sho  !B@ ' !' !solver_opt=  !B@kh< ' !' !solver_adj=  !B@k;  ( (F (  ( Cancel'|;;solver_err_msg %!d &A@gX;oP;H;Attribute VB_Name = "Solver3" Option ExplicitXPub, Static Sub Finish(), &.Pr@ocDataInvoke_Funco \n14m ' 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 acr0D0 Ap.ScreenUpdng/  s ShowIfscenarioz"esҀOFSc47Edi5nCap?%  If Loop UnxtilThs??#&ed0ՠ+ pFi1 Хnumv p CDbl(Mid(CStr(A"tve.0)rel" & TrHim(i), 2)) > 3mV=@q2Exit  9}@N Vp6((2) Or 3j`..`1#Msg@ngI7'32, , helpfil@e, 183_ , ;U 1)Do_A A Not&=SitipvityF? ?= 0Limits :v:O__P/Pffu' Run (8"'EaaRs'!Cup"a;ta.RestoreCal>lR89Each c In cӄ6adj˃ c.oldva0rs(i i t+ Ƃ 3)27Sub : o/oݰQoHs/u/0  u_ok?sh`oo]' user 5clicks ok on finish dial og On Error GoTo mainFe8pAppation.Scr@eenUpdng = FalseNreport8_gexZi @KIftatusBar`ng8arememberL? \Workbook.ps.AdWow.DisplayGrid7m``dr = 5gln ld'^50D & " & Trim(xe )Da> 0K hF 0 The Cells( 12 r, 1).oula = @excel47End IfBObndsC3C2+C8 Cs/3/J94705U1627m31|EGK pElse#^ `_o`doR˟^)5ko oi' fill in target zlCWorksheets(remember#vatDOn Error Resume NDoptMid(CAeS! .Namesf")), 2).xnewg 3}08! (Dddress(ReferenceStyle:=savesA n@(V , k(y ,U*old@ H` h"$D$89Nu:= c # E#7Window.ScrollRow.7jC'Kvarsci=`1CK@ Each c In #7H@۠J&6oi Mod 10K o ApplicaA.StatusBar 4e{}Int(100 * (i / (v+yo0C% done."c!t7Pci,/c.A/./.?3O/A/O._ , -"(i |st++sO, 2!ߒQ/i@ / /rMpT ?7it7A47 To('@T20 222&P<2 2+Eq)222U Z;xlA1` th\ringGhi Conлtŀm("=<@Œ.(rowOcw=6colPV, xlR1C1qA1l@=  DUco j&S?:_AQA_A ?GsP B3u3ab{check(Valuvo-EeIBfSel0 CasetO& C&PP E11qrhspC1" 3 Txhen ndn7J AGX3!Nv`Not IsNumeri,c(~#.~tblValue)w+4kE7FL=Row&,cQColum'3%V Cell^])."(GW + 12\t= a+*q 2 Rejm -b y= 1`Each c@| @W] B_ i)@jc#AmiARUj īhande 1uBHr/Yiqgq8 qso qesbookb.s.AdjWUow.lpla yGridVesr Res=z ruVS givenLn} ۯ9O"HP)"G0Q0DA= Ǖ8 3S$R S#{!d)C ]O$A$1:@3P Selxect3CWidth1.5 Font.Bo\ldw;1p).7mula4i-V0 7C C HO 519[oC,AQ ]03?952Ne_' SNs;680{Y8A}oe8\3o ϷƷ8Y7, 4__WQ-gJ _84zP=PI -ДَC 5 5JP?  e˓ 6   Ōߏ  b 7   <   9. 8   9.   .YB$7:$H$?ֶ8P?s`.AutoLat format:=12S)%Y|l4language.Re("solver_msg_93").Text Cells(8, 5).Formula = ex4ce4 $B$7:$E$" & Trim(Str(8 + adjusts))@).Autokat frat:=12End If ' constraint sectionD10V, 1+5 _If5s > 0 The6 Մ727276)3+)7)1I)4v8`)9Zlin1JZDF1+100 p1J+6*]102c+n}Y7(<10.c 10 r68n4A mo j1-))":$Hˣ1Rw Elsec 3&\Km Drg10 ?& #& ?& &(̪'jcj'1Afill @vharsC6iCWorksheets(remembervat< Each c In (A!eS.Names&0wE1)c@Wi Mod s=|n Applicav.StatusBar /zg7#Q0Int(X * (i / (DN.!% done." (new  Si, c.Address(ReferenceStyle:=savesWjzy%nP(, + Jjs a d(i+ NuA `= olvds>4.rowi/i"cowd0ValugDj }9 l   0 a g_]0_Za_]0[ -?i1#Nf' B`C qPo)=g==à=& H==7>Sl>` $59GxlA^ th0;rinBgMid( C4ont3("=HL0gI&f, xlR1C1qA1)AEw: 7dxj(|o *N6Vo`/M!M/M !?MllkbWcheck(`2 IeY,S`P$&Q\(Vo k*._0PSNumberFormat If solver_lin = 1 ThenxCells(12 + adjustsi, 6)".ulalexcel4sheet.`rowin2d hcof6)U!c7:c7"c818%1EwIfkNexColumns("B:H").AutoFi ActiveWow.Scrol0lRowƒ"Works(reme#ateApplication.Sta@tusBar#FalscreenUpd@ ng Tru Exit Sub mainerror:MsgBox zlanguage.Re(" _msg9T?, 32, , helpfile, 1830CJ handgD>book.Names.Add A:="sencount", RefersTo:=0, Visible:=< @8Resume CgBeCaNnD@ErAN18Quit_repornEFV_FFG  e Pub%{ yicj Do_Limits(Attribute.VB_ProcDataaInvoke_Func@#" \n14"2' `C)J l IOn #or GoT o CDim i As Integer, newobjADo@1?c, Lopng,  constrPAbnds E)`bE freshVariantbv ge  +paS-ng ࡀ oŪ8num9KCDbl(Mid(Cu(]S¦B]Firel" & TrHim(!i), 2)) > 3?Pr!s_77s?N`G`Not Iseric(##̃tblValue)+4kjuR|= D[ʃ X= C_7_opt"))b5.?:h c=w(Ć Dh#v3{9)l 9j v15<= @t>+7(+00ReG:t wyi@N1f1:Each cJDo8m +9!i)cAi'E]q{}y?{.~6x"x_111 x z&nvS ]?Qz{*#DisplayGri!es(o853y;V]pV ga oUg2W" jW)N> 0 L pH + W("t Y!B0'R0 $AĘ$A$1:@3P Selec$1@Width1.5Font.Boldǡ=81/((49I/V00 S S PF=m _ V 5e1[QS,Q?]th'2s3w&Now ' target s0{0 7dv11w? 6@oh4(3ooh5oa4ooh6j/B$6:$8D$82 fab:=12aa?1OaC1 24 x 1@-6pp Formula = excel4language.R@e("solver_msg_120").Text $B$11:$D$" & Trim(Str(11 + adjusts1))).Autoat fat:=12KCells(12, 5).ColumnWidt"h1.5 #1, 6).*1 k-G2#G7G3G#4#FGj8c9?5?6c10,$7$.V8 EdIBdJzd' fill in targeHopt@""On Error Resume NWorksheets(reme0mber`sct`ivate# MPid(CazAaeS.Namesƃ")), 2) newR GoTo handleCan`CApplication.EnabKey@xl"Hr#If ! Then~n8߇ɞ9:) 4L0# Els(vB/ddress(Refere Style:=savesA+I V3n`2(v , K>"6obj9NuG! = 8old #End Ifc'!8h se@HoD2) ""@f 6hXe*j Dl@ >.Egm1a limcountfU0p<= 2.k=6o#c _=_=\H7D3٣  omL!????L 8'yoBoBoBoBoBoBvloB@0 KKoBKoBjBx "" Thenfreshobj = Range(b).ValueZEls t0Hnd IfOn Error GoTo handleCanc el"vc.Addsunewvars(i)+Workshee ts(exD4lAuage.E"msg_112").T & "& Trim(Str(limcount))).Activatmanswer <= 2Cells(12 + i, 9).FormulaXVNumberatoldq:f ait104ۗ5 %Mv8]30]&GME*iRid1Application.CalchxȑremedM.Ne BeA book.Names A:="'"{@ SB"!typ", RefersTo:=, Visible:=FaF@{Resume %9Ms(es`DDele2*"=1D+sIM'adj1??  ?7?U਒[Column3B:D 2AutoFifF:GvI:Jmindow.ScrollRo~ws$so(d= th @n@j|i|StatusB}_1cobE 5!V ITVrVVEnaPKeyP9xlDi*sAd35aon:S:ZrtLO8O8IIp H       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyzhLL@'zpl (08<DHTltxMEh@> "LLLLL*L `Hbk  140`8!o pp 14204  "('!Me,0P : `doOO4 14 h `` fdo@ 11I<  14 @ ` ik  14 B ` 8kk  14 D@ `8 lk  14 F ` n|+ 14 H ` pok 14`z'@h  JH `@ xqk  14 H ` so ++ 14& ` `$XoZZ! 14P4 cell:X `0 x'okk{ 14R6n8 8!j<l@%BA@xDcelltH(rLCellTN!VPX R Cellh T !< ` .\k && 14RdL`fAdjubh*dl 8H!`@Hx`k!  14"`X1o "I< d 14hpOptijrialojtlx%"n|nhitsxChanp(tpresvPrppres z#`{k#  14 ~`$`X|k$ 14 %`XXk% 14 &`@k&  14X'`PX;k0'I  14 (`Єk(8 14 )`k) F 14 0*`(Pk*P 14 x+`pk+ _ 14 ,`k, i 14 -`Hk- s 14\p.`h= /H . }I  14v/`> / / I Save 14|0`8H@4o 0;;I !d 14@A@ in'pPThe_1`PCk 1((I 0SaveI  14Thg `DLlog 2`\k( 2 IT H!I hIX ThIH "I I$ _diaIf(( $2I^, ( I0 Hg1 I4 h2Ih8 g I<  14H xH  PxX 0 X h8X `h ` Hp@ 0 res%  L,@l mum_@0\ g @`L '@HH = @x8  @4 @$ @ =COU@8 @ H @ ells@ Max_@ og @ '%,@ dial%"%(*8 h8@XL@x %"@h @d @ T @D @P4 @$ ons_@  !@ @ '@ @ E|ng@( og @ Z@ %,@h @%,@ hd@ "@ $@ @ @ 'h!Newtx H  h!6L @ x '@ h ons_@ d @0 T @ D @` 4 @ $ @  @ @8! @  @ @! @ ! @P! @ @ |p@X$p"""" "H$8"@0l H" ""&.@"h @"X @T @P `"@(#@ @#0 @X# @@# @p# @# @# @# @# @# @ @ @$ @0$ @ X"Z %%H%0%&`'&~Z@`%x @v @x%d @8&` @%P @%@ @%0 @h& @% @ & %@P& @ @& @& @& @' 0 &`@%&@ @' @0'x @H'h @X &b P @  ( )0((H()(x.(Z@`(x @x(h @0.d @(T @p)D @(4 @()$ @)" )( @  H*) @@) @X) @) @0* @) @p* @* (|\.2@ @* @ @X* )P@* @* @*p )L@*` @+P @+@ @+0 @0+ @H+ @`+ @x+ @+ @+ @+ @+ @8, @, @ , @P,p @h,` @,P @,@ @,0 @, @, @, @@- @- @(- @X- @- @p- @- @- @.p @-` @-P @.@ @0 @ @H. @`. @ * 0H//0`/0/@x/x @/h @d @/T @/D @/4 @80$ @ 0 @ @P0 @h0 @0 @0 & @0 @@1 @0 @1 @(1| @l @\ 1X@4H22`2842:1@;2@l  212L@x2h @2X @4T @P `:2@2@ @30 @03 @3 @`3 @H3 @x3 @3 @3 @3 @3 @3 @4 @4p @ 4` @4P @h4L 020t\|v@H @H9D @44 @:0 @5 @4 @X5 @(5 @@5 @p5 @5 @5 @6 @5 @5 @5p @6` @H6P @06@ @`60 @6 @x6 @6 @6 @6 @6 @ 7 @7 @87 @h7 @P7 @7p @7` @8P @7@ @70 @7 @7 @X8 @(8 @@8 @p8 @8 @8 @9 @8 @8 @8p @9` @9P @09@ @0 @`9, @9( P4N:2@9$ @: @9 @9 @: @ : @8: @P: @h: @ @ @: @: @ @; ;:@ 0;;;x90@<X<<;@(<l @<\ @=X @p<H @<8 @<( @< @< @ @ @ =HP>h>>===`\z ==@ >h @8>X @H @>D @>4 @0 @ P??@?P??h?`vz x?P?@?h @?X @H @@D @0@4 @0 @ @XAPA8AhAC0C@CA@|l A@HCL062@A\ @CX @AH @A8 @A( @A @B @ @B @(B @@B @XB @pB @B @B @B @Bt @Cd @T @D A@XC@ pC0C@<_ CXCXC'@8 @4 0pDXEDD EE`DFxD@l D`DD@\ ED|L@PEX @hEH @D @8E4 @F$ @ @E @E @E @ @E FE@XF/ HFE@0F @F pFE@F FXF@/ FFFD@ GGGHG@x @Gt @p @J` @HP @0H@ @HH0 @`H @xH @H @H @H @H @H @I @ I @8I @PI @hIp @I` @IP @I@ @I0 @I @I @J @(J @@J @XJ @pJ @J @J @J @ @p KKKLK@x @Kt @p @N` @LP @0L@ @HL0 @`L @xL @L @L @L @L @L @M @ M @8M @PM @hMp @M` @MP @M@ @M0 @M @M @N @(N @@N @XN @pN @N @N @N @ @p O@PPQRRRhR@Rx @Rh @d @RT @SD @(S4 @XS$ @@S @pS @ @ @@TTXTTpUT~L@pTt @Td @V` @\ `T@TL @T< @(U, @U @XU @@U @U @U (T@U @U @U @V @HV @`V @0Vx @h @X @T WWXXX@l @\ pY(ZpH(0@Xp^Zp[[h__^8`_L@([ @@[ @[ @X[ @[ @[ @[ @[ @\ @\ @x\ @0\ @H\x @\t @`\d @\T @\D @\4 @\$ @ ] @] @] @P] @8] @] @X^ Z2.@] @] @] @] @^| @x @(^h @@^X @H @^8 @8_4 @^$ @^ @^ @ @_ (_^@_ __@_ h]Z"$0@_ @_ @ @ P`_l@_ @` @ ` @ P_6_aa0a`aaxa@Hax @ah @d @` ``a@aP @a@ @a0 @b @0b @b @ @ c`ccb@0cx @Hch @d @cT @xcD @c4 @c$ @c @c @ @ xfdHedef ebZ@dx @0eh @d @e` `ee@`eP @xe@ @e0 @e @f @ `e@e @f @Hf @0f @ @`f @ @ d@ 8hgHghhhh@xgl Zb&@g\ @gL @g< @g, @ h @h @h @i @Ph @h @h `hhh @ `h`g@i @0i @Hi @ @`i @ @xi @it @d j`jHj@xjl @j\ @jL @j< @j, @ k @k @ @ lkk@ll @Pl\ @8lL @hl< @l, @l @l @ @ mmmhm@mx @mh @nd @mT @(nD @Xn4 @@n0 @pn @ @n @ @n @ Xo (pp@ppppp@d @XpT @qD @p@ ppp@<_ ppp @p, @q @0q @`q @Hq @ @ 0rxrHrr@x @`rh @rX @rH @r8 @r( @s @r @ @ stt(tsss@Hl ss@@th @XtX @uT @ptD @t4 @t$ @t @t @u @`u @ @0u @Hu @w @xu @u @u @u @ux @uh @vX @ vH @8v8 @Pv( @hv @v @v @v @v @v @v @w @(w @@w @Xwx @pwh @wX @wH @w8 @w( @x @0x @x @ @ yyyyx@0yx @Hyh @d @`yT @xyD @y4 @z$ @y @@z z y @(z @z @Xz @pz @z @z @z @z @p @` |{{{@0|l @{\ @`|L @|H @D @H|4 @x|$ @| @| @ @ x}}} ~`}8~@}x @}h @~d @}T @H~D @~4 @~$ @ ~@`~ @x~ @ @~ @~ @~ @h @  @8 @ @P| @l @\ @L @< @, @ @ @ @( @@ @ X(@l @@\ @PL @pH @D @4 @$ @Ё @    @8 @ @h @ @ @ @Ȃ @ @p @` @(\ @X (@l @X\ @@L @p< @, @ @ @ @ Ѕp@x @h @d @T @D @x4 @0$ @H @` @ @ @ `xH@x @h @؇X @H @8 @( @8 @  @ @ P @x @8h @X @hH @8 @( @ @ȉ @ @ Ȋ@x @h @(X @H @@8 @X( @ @p @ @ Xp@@x @h @ЌX @H @8 @( @0 @ @ @ H@x @0h @xX @`H @8 @( @؎ @ @ @ (hhHȏ@@l @\ @L @< @(, @X l@p @ @ @А @ @ @ @0 @H @| @`l @\ n33 M 3$*\Rffff*0737ff36b9$*\Rffff*0837ff36b9$*\Rffff*0937ff36b9*\R1*#cd*\R1*#b8*\R1*#229*\R1*#c4*\R1*#175*\R0*#14*\R1*#67*\R1*#b3*\R0*#f*\R1*#c0*\R1*#187*\R1*#45*\R1*#b*\R1*#1d5*\R0*#10*\R0*#13*\R0*#1a*\R0*#19*\R0*#17*\R1*#82*\R1*#1d6*\R1*#66$*\Rffff*0;37ff36b9  " (8@HP "X.h " " "* " " 8PX "` 4h "   "  " $ BQH "4C   " 08@ H *X"+x 2C (   ( 8@.UH 2Cx (  2i 0h(" XV ` PX`hpx2CVq "  ( HX` "h $p  "    "  (@ "H P p " 0 BU>8 ?P >Jh 4 Bp  1( H P 4CX   "   "     ( 8 X `  " r      H| B  @f (Ds  PX+`Frx   *P  *P0 `6Fh=G G,Y  P X ` p ,P   6J L Nh V 8T "OH p $Ox  <T "O  $O @ :TH "O  $O  :T O( H OP p :Tx O  O  8T O@ ` Oh  P :T "O  H $OP x = J J   0 !0 P !X x ._ ._   ._ @ P._`  ._  $D ( 00 `Dh  *D,DH P X h  pD6= I (J0=PJh J=J  0JH`hp B6=  I0P`hJp=J J   ( =0 JH  ` p J             !! !1(!@!H!1P! "h!4Cx!!!4C!!" "" 0"@" H"*X"(/x"(K" """"4C" #(# "0# 8#X#`#>V#=#X# # 6w$ X8$P$X$#`$p$ x$ $$$$p$4C$Zq%`%h%<p%Zq%%%%T&&80&*h&&<&'&>L& '('4C0'h'p' "x' ''':V'/'#(( (  (0(8(@(4H(2C(Vq( )) )()50)@XH)))4C))) ") .)*"1 *H*P*4CX*** B ** * *****+0+'P+(p++ +++'+(+, (,0,8, @,2CP,(,, ,,, ,2C,((-H- h-p-x-DK-4C-(. . @.H.P.HKX.4C.(.. / /(/ +0/&P/p/DKx/4C/(/0 80@0H0 P0X0Ng`0@{000=1X(1 K@1`1:ch1.1>]12@]2P2 .X2>]x22@]23:^3:^H3:^36m3=4X46w04h4:cp4.4>]45@]5X50`5=5X5 K55:c5.6>]86x6@]66066 6664C787@7 "H7 "P7x7 *7 &7 &7 $-7 &8 &-(8 #P8 #h8 #8 #8 #8 #8 #9 9 (90989 D@99 *9>l9>l9@l0:J{p:&-:Bl:$70; #X;p; #x;;$7; #;; #;<$7< #8<X< #`<<$7< #<< #<<$7= #(= #H=h= #p= #==$7= #= #> > #(> #H>h>$7p> #> #>> #> #>?? ? (?0?8?4C@?x?? " ? (?? ?<L? @@*C@H@ "P@ *`@ @" @ @#@&A 4(A`A *hA&A&A$-A&A&-B#8B#PB#pB#B#B#B#BCCC/ C/@C `C|pC C DVqD "`DpDxDD4CDDD "D DDE ZEhEpE4CxEEE "E EEE ZEXF`F4ChFFF "F FFF ZFRqHGGG4CGGG "G H H0H "8H ,@HpHxH "H 8HH*HH I I I(I4C0IhIpI "xI II-III4CIJJ B J 2 JXJBQ`J "J4CJ "J KKKNgK "hK4CxK "K KKKK K4K 4(L "@L 4CPL "L  L L LLL6L "L4CL " M 0M8M@M HMPMXM4C`MMM "M *MMM .M "NNN<T N`N<WhNNNNN N NN/NOROpO xOO/OOOROP>J P $`PBgpPpPx(QrQrRtRzSvS8TT8T@THTPTBgXT:TTTTTTBgU<THUUUUUBgU:TU0V8V@VHVBgPV:TVVVVVBgV:T@WWWWWBgW8TW X(X0X8XBg@XX X (XXX4CXXY "Y Y0Y8YXYxY "Y Y>OY YHWZ :HZ Z @Z Z  Z Z Z UZ <Z  [ :0[ p[-[ [ 8d[ [ $0[ \ \ $0(\ P\ `\ =h\ &\ \S\&\ \ \ \ \ \ U] $] (]D8] P]&\`]"Z] ]B]"Z^0^8^ @^<P^D^^^^=^"^ ^R^"_(_0_ 8_ @_ *_H_ Hex_ _ _ _ _  _ _ _ ``` ` H(` ` =`a bb (c 0c8c @cDTPccDZd`ddpe efff4C fXf`f "hf pfff>Of fDdg"Pg "hg  g%g "g  gg "g  gg>sgT0h~h2FiVq@i  iVti  ij2Lj@U@j1jj4Cjjjj4Cj0k8k "@k Hk`k.Fhk.Fk~k2FHl2Fl@Ul1lm m4C(m`mhm B pm 2xmmmm m*n+0n  Pn 4CXn (n n  n nnNn  o 4C o (Xo po  xo ooo.no  o 4Co (p  p  (p 0p8p@p "Hp&WXp)p/pBpp 2q&W q Hq  Xq 4C`q (q q  q "q q%q  q 4Cq (0r Hr  Pr "Xr hrpr0xr-r Krr -rrr 0rss 2 s  @s4CHs(s s  s "s sss ^s"30t lXt .Zu u4Cv(8vPv Xv "`vpv xv&Bv0vv;vv v v 4w 8w@w&BHw 0pw w ;w www&\wUwx@x0x >8x)XxHdxxxnxx  8y $1@y4Chy y4Cy y (y z  z "z  z(z $10z $0Xz z $0z zz zz-z<z{{ ({ 4C0{ (h{{ { "{{{{{{$D{ {Tq{HeP| | ||| |DT|}Lb}h} p} }>O}|}d`~L~"08X@ X Th L T(  =  Ђ؂ 4C@H "P .X 1ȃЃ4C؃ " ((P0FX, .FPFqЅJ^؅(J^04CІ؆ " $ .F(.FX~2F2F@Fqx "Ј؈4C ( "0 (8` hx4Cȉ " Љ (؉64C X` h>Ex 4CЊ*\ PX4C`4C " $ D](-p-4C " 0@-H`h4Cp " 4 Z (` - Ȏ4CЎ "  @-H`h4Cp " ,-4C X` "h &p-4CȐ B O @HPX` B hpPx B  Zȑ (HPXVh"Ff6  3(0"8 hP @H .P`$h x   )  6/Д; 3 ( 0 8@7HX `px/LȕЕ ؕ  B  08X .h2x,`7Ȗؖ23 ((&YH Vp &&Z W  $0HP`7hx4CȘ B И *ؘ @l `Jshș4CЙ  x! update tool-menubar if necessary |8k0' ( ' ! '!MenuUpdate B@R ( 14oPH (`' !'!Unregi B@R( (@o2 called when user presses continue on "show" stop.'o- called when user presses stop on "show" stopwhat'oP  user presses "add" buttonAdd'x'ohCancel'o user presses "delete" buttonConstraint_list Solver_dialog %"%\! (solver_msg_25b %!d &A@'dDelete'kouser hits "guess" button]@A@~Guess' Solver_dialog %" Optimum_cell7(!* solver_msg_3 %!d &A@ Optimum_cell7(!9|k  Optimum_cell7(!9|k Optimum_cell7(!*$L$! solver_msg_4 %!d &A@ Optimum_cell7(!9|(d  Optimum_Cell7(!*$L$!!'  Optimum_Cell7(!*$L$!!Adjustable_cells7((*dx  Optimum_Cell7(!*$L$!%Adjustable_cells7((*kd   Optimum_Cell7(!*$L$!%%Adjustable_cells7((*kkqA@| solver_msg_4 %!d &A@ Optimum_cell Solver_dialog %"%(! Solver_dialog %"(|oX user hits "Change" buttonChange''o user presses "options" buttonOptions'oP user presses "reset"Continue'A@o0 user presses "save model" Save_model'ox user presses "load model" Load_model'op)prepares and displays "save model" dialog]  Options' solver_msg_46 %!d Save_dialog %"!(* $L$! ' $L$! 'Constraint_list Solver_dialog %"%\!'  $   $$B@H  %The_area Save_dialog %"%((* Save_dialog %"B@$|solver_err_msg %!d &A@gho`8Saveload'o@0]](@X]p]]0HThe_area Save_dialog %"%(!*$L$!  The_area Save_dialog %"%(!*$L$!  (solver_msg_131 %!d    solver_msg_132 %!d *A@ Save_again'|XkP'The_area Save_dialog %"%(!*$L$! The_area Save_dialog %"%(!*:   The_area Save_dialog %"%(!*$L$%%The_area Save_dialog %"%((*kThe_area Save_dialog %"%(!*!savefunc %!d savearg1 %!d:="$2The_area Save_dialog %"%(!*"$2'd8The_area Save_dialog %"%(!*"$2savefunc %!d savearg1 %!d:="$2The_area Save_dialog %"%(!*"$2'dPsavefunc %!d savearg1 %!d:="$2The_area Save_dialog %"%(!*$"$2'kk   B@g for The_area Save_dialog %"%(!*$L$lw ,  res =MAX( $!) ( e=MIN( $!) (zddvalueof Solver_dialog %"%(!*'Ce. . %,  . %,' bmum_.  g  . %,' k = $!=  ($k k e stab=COUNT( $!) (*kH   e_Cells  optionsloMax_timeOptions_dialog %"%(!*''   %,Max_iterOptions_dialog %"%(!*'er_d   %, PrecisionOptions_dialog %"%(!*'   %, ToleranceOptions_dialog %"%(!*dX 'BoAssumeOptions_dialog %"%`!N Z   %,TRUE''d   %,FALSE'DialkX Show_iterOptions_dialog %"%`!N Z   %,TRUE'"%d   %,FALSE' Tk auto_sclOptions_dialog %"%`!N Zabled   %,TRUE'lver_ddH   %,FALSE'@k TangentOptions_dialog %"%X!N Z'   %,1'd   %,2'k ForwardOptions_dialog %"%X!N Zn$   %,1'd   %,2'kNewtonOptions_dialog %"%X!N Z   %,1'd   %,2'kp   %, ConvergenceOptions_dialog %"%(!*'non_negOptions_dialog %"%`!N Z   %,TRUE'd   %,FALSE' $k. . %,  . %,' b!.    . %,'k !  " ! & !  $=VAR( ) (d={ } (%kdx solver_lhs  %X $' solver_rel  %X $' 1KT solv<='$ solver_rhs  %X $'2KT='j solver_rhs  %X $'!3KT'>='j j solver_rhs  %X $'4KT='INT( $!)'jn !  " ! & !  $ 4 5Add_=SUM( $!) SUM( )'%d0 4' =INT(SUM( $!))' %d =INT(SUM( $!))=1' xkk  (d 5 $!  '_d $! !. . %, .' b . %,   .'k  0 6 %4'v. . %,  . %,' b.  x  . %,'8k0=  (&X d. . %,  . %,' bX .  iter  . %,'k=  ( kpdh( $!=0)+( $!=1)=1'rance $! ne. . %, .' bo.. . %,  erge .'k  0 6 %4'X . . %,  . %,' b=1.  me7  . %,'k=  (&d. . %,  . %,' b.    . %,'XkP=  (k0k(k k  '   yk $L$B@H| $L$B@H ( solver_msg_se %!d *A@|H@solver_err_msg %!d &A@go`)prepares and displays "load model" dialogOptions' Save_dialog %" solver_msg_45 %!d5(*  %The_area7((*C@$q(| solver_err_msg %!d &A@go validation of variables] 8Adjustable_cells Solver_dialog %"%(!*'  %,,   %,' b   $,   $'   %,'k $L''(' |hk`X $!,! ! solver_msg_3a %!d &A@Adjustable_cells Solver_dialog %"%(! Solver_dialog %"(|k $! Adjustable_cells Solver_dialog %"%(! Solver_dialog %"(|k $!.!'*  * (  $%.!$|  %,'(   $%.!,'` ( ( $'(   $' (Adjustable_cells Solver_dialog %"%((d|solver_err_msg %!d &A@goPvalidation of objectiveX] Optimum_cell Solver_dialog %"%(!*' ! 6 $L'k' |k $! $!,! ! solver_msg_7 %!d &A@ Optimum_cell Solver_dialog %"%(! Solver_dialog %"('|k $!' $| Optimum_cell Solver_dialog %"%((d|phsolver_err_msg %!d &A@g(o ( prepares and displays option dialog boxOptions_dialog %"B@$|solver_err_msg %!d &A@gho`P]@XpOptions_dialog %"Max_time7(!*X'2Max_iter7(!*X'4 OK_button76(8 2 2 2 Max_time7(!9 OK_button76(8'0z@k8 4 4 4 Max_iter7(!9 OK_button76(8'0zk 2 solver_msg_8 %!d &A@Max_time7(!9 OK_button76(8'0z(k  4 solver_msg_9 %!d &A@Max_iter7(!9 OK_button76(8'0zk Precision7(!*X Precision7(!*X solver_msg_10 %!d &A@ Precision7(!9 OK_button76(8'0zk Convergence7(!*X Convergence7(!*Xsolver_msg_10a %!d &A@ Convergence7(!9 OK_button76(8'0zk Tolerance7(!*X Tolerance7((*k Tolerance7(!*X Tolerance7(!*Xd  solver_msg_11 %!d &A@ Tolerance7(!9 OK_button76(8'0zk'0A@& optionsfunc %!d optarg1 %!d:='  2, optarg2 %!d:= 4' Precision7(!*'. . %,  . %,'0.   $'k , optarg3 %!d:= 'Assume7`!N Z , optarg4 %!d:=TRUE'd , optarg4 %!d:=FALSE'k Show_iter7`!N Z , optarg5 %!d:=TRUE'd@ , optarg5 %!d:=FALSE'k , optarg6 %!d:= ' , optarg7 %!d:= ' , optarg8 %!d:= ' solver_tol %!X $XdX '. . %,  . %,'   $.   $'k , optarg9 %!d:= 'auto_scl7`!N Z , optarg10 %!d:=TRUE'd , optarg10 %!d:=FALSE'k Convergence7(!*'. . %,  . %,'0.   $'k( , optarg11 %!d:= 'non_neg7`!N Z , optarg12 %!d:=TRUE'd , optarg12 %!d:=FALSE'k8   B@q 'z  solver_err_msg %!d &A@gi restore settings if not new Options_dialog %"dX Max_time7((*dX Max_iter7((*ư>X Precision7((*X Tolerance7((*-C6?X Convergence7((* bAssume7`(N bnon_neg7`(N b show_iter7`(N bauto_scl7`(N ZTangent7X(N ZForward7X(N ZNewton7X(Nq'|k> If old model, these names are not always available; therefor:pOptions_dialog %" solver_tim %!X $Max_time7((* solver_itr %!X $Max_iter7((* solver_pre %!X $ Precision7((* solver_tol %!X $XdX Tolerance7((*-C6?X Convergence7((* solver_cvg %!X $ Convergence7((* solver_lin %X =1 ZAssume7`(Nd bAssume7`(Nkh solver_neg %X =1 bNon_neg7`(Nd Znon_neg7`(Nk solver_sho %X =1 Z Show_iter7`(Nd b Show_iter7`(Nkx solver_scl %X =1 Zauto_scl7`(Nd( bauto_scl7`(Nk solver_est %X =1 ZTangent7X(N b Quadratic7X(Nd bTangent7X(N Z Quadratic7X(NkH solver_drv %X =1 ZForward7X(N bCentral7X(Nd bForward7X(N ZCentral7X(Nk solver_nwt %X =1 ZNewton7X(N b Conjugate7X(Nd( bNewton7X(N Z Conjugate7X(Nkq'|solver_err_msg %!d &A@gox "reset everything to default values@ < solver_msg_17 %!d! &$?|?k? resetfunc %!d  B@k? ( Solver_dialog %" Optimum_cell7((dAdjustable_cells7((*Constraint_list7\B@^ Z max_button7X(NX dValueof7((d. .EditBoxes("dValueof").Enabled = Falseq>Options_dialog %"dX Max_time7((*dX Max_iter7((*ư>X Precision7((*X Tolerance7((*-C6?X Convergence7((* bAssume7`(N bnon_neg7`(N b show_iter7`(N bauto_scl7`(N ZTangent7X(N ZForward7X(N ZNewton7X(Nq<<A@& solver_adj %B@> solver_opt %B@>  (' !' !solver_numConstraint_list solver_dialog %"%\! B@  ( < Optimum_cell Solver_dialog %"%(! Solver_dialog %"( (k;|;x;solver_err_msg %!d &A@g8;o0;h  user clicks on "max";'T ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = False|::solver_err_msg %!d &A@gH:o@:  user clicks on "min":'T ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = False|99solver_err_msg %!d &A@gX9oP9  user clicks on "value of" 9'S ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = TruedValueof Solver_dialog %"%(! Solver_dialog %"(|X8P8solver_err_msg %!d &A@g8o8@  user hits solve CallSolver'o7 & user hits cancel in finish dialog box7]  (2 Application.Run ("'Excel4Functions'!RestoreCall")'  $ $ (N  '6|66solver_err_msg %!d &A@g6o6  help for finish dialogX6 - B@L|8606solver_err_msg %!d &A@g5o5H , validation of model before trying to solve.5Adjustable_cells Solver_dialog %"%(!* ( solver_msg_18 %!d &A@ ('Hz4k4 Constraint_list solver_dialog %"%\! ( solver_msg_18 %!d &A@ ('Hz04k(4 4  $ $ %N! $! $! ( solver_msg_7a %!d &A@ ('HzX3kP3kH3k@3 $!  ( solver_msg_19 %!d &A@ ('Hz2k2'Hz22solver_err_msg %!d &A@g`2iX2 # defines necessary names for solver2] !'P (A@~A@ max_button Solver_dialog %"%X!N Z' min_button Solver_dialog %"%X!N Ze'dH1'k81  ( 1 solver_opt %B@>d0' !' !solver_opt=  !B@k0 p0 solver_adj %B@>H0d@0' !' !solver_adj=  !B@k/Constraint_list solver_dialog %"%\!' !' !' !solver_typ C@' !' !solver_valdvalueof solver_dialog %"%(!dC@' !' !solver_numConstraint_list solver_dialog %"%\!C@' !' !solver_timMax_timeOptions_dialog %"%(!*XC@' !' !solver_itrMax_iterOptions_dialog %"%(!*XC@' !' !solver_pre PrecisionOptions_dialog %"%(!*XC@' !' !solver_tol ToleranceOptions_dialog %"%(!*XdC@' !' !solver_cvg ConvergenceOptions_dialog %"%(!*XC@assumeOptions_dialog %"%`!N Z'd+'k+' !' !solver_lin C@non_negOptions_dialog %"%`!N Z'd+'k+' !' !solver_neg C@ Show_iterOptions_dialog %"%`!N Z'dh*'kX*' !' !solver_sho C@auto_sclOptions_dialog %"%`!N Z'd)'k)' !' !solver_scl C@TangentOptions_dialog %"%X!N b'd)'k)' !' !solver_est C@ForwardOptions_dialog %"%X!N b'dp('k`(' !' !solver_drv C@NewtonOptions_dialog %"%X!N b'd''k'' !' !solver_nwt C@qp'  ( P (|H'@'solver_err_msg %!d &A@g'o&  delete a constraint&]8 P h  ]    ]  ( @ ('XConstraint_list Solver_dialog %"%\!'R R Constraint_list Solver_dialog %"%\! solver_lhs $$ %X $'np% n$!$Z 'T'Xy@%k8% n$!$|'n solver_rel $$ %X $X'l l solver_rhs $$ %X $'j j$\ j$|'jkh$ lOptions Add_dialog %"%%'x lesolver_msg_int %!d'j='x lesolver_msg_bin %!d'j='xk#. . %, j.' b . %, j  j.'(#k # l #' j$!$|'j   formula j !'r r j' !'! j' !'!'r rb j r $ j j r !  $'j j' !'!'r!d! rb j r $ j j r ! $'j j !'rP!kH!k@!. . %, j.'r rb . %, j r j.'r k k k n  x  j$'t RConstraint_list Solver_dialog %"%\% t 'Ty0 k( j$Z'X 'Ty k X l delfunc %!d addarg1 %!d:="$2  n$L$%"$2, addarg2 %!d:= l  B@d j"$2delfunc %!d addarg1 %!d:="$2  n$L$%"$2, addarg2 %!d:= l, addarg3 %!d:="$2 j"$2  B@ddelfunc %!d addarg1 %!d:="$2  n$L$%"$2, addarg2 %!d:= l, addarg3 %!d:="$2 j$"$2  B@kkk  ( RConstraint_list Solver_dialog %"%\B@^' !' !solver_numConstraint_list solver_dialog %"%\! !B@Constraint_list Solver_dialog %"%\! 'V' !' !solver_lhs T$$ solver_lhs V$$ %! B@' !' !solver_rel T$$ solver_rel V$$ %! B@' !' !solver_rhs T$$ solver_rhs V$$ %! B@  (k|solver_err_msg %!d &A@goX  change a constrainth]    Constraint_list Solver_dialog %"%\!'R R RConstraint_list Solver_dialog %"%\%'d d <= d <= '`'b d >= e d >= '`'bd8 d = '`'bk d `$$lhs Add_dialog %"%((*= d d `  $$ rhs Add_dialog %"%((*<==>= solver_int %!d solver_bin %!dDOptions Add_dialog %"%(Options Add_dialog %"%(frhs Add_dialog %"%(!*=solver_msg_int %!d'brhs Add_dialog %"%(!*=solver_msg_bin %!de'bk bOptions Add_dialog %"%(solver_msg_46b %!d Add_dialog %"!(* Add_dialog %"B@$dXsolver_msg_25a %!d &A@k|solver_err_msg %!d &A@go add a constraintlhs Add_dialog %"%((*rhs Add_dialog %"%((*<==>= solver_int %!d solver_bin %!dDOptions Add_dialog %"%(Options Add_dialog %"%(fOptions Add_dialog %"%(solver_msg_46a %!d Add_dialog %"!(* Add_dialog %"B@$|solver_err_msg %!d &A@goH+ validates constraint and saves it if validH]](@]Xp Add_dialog %"lhs7(!* < solver_msg_20 %!d &A@lhs7(!9kP'z@k8lhs7(!*!lhs7(!* ! < solver_msg_20 %!d &A@lhs7(!9k'zxkphlhs7(!*$L$!.! < solver_msg_20 %!d &A@lhs7(!9k'zk (lhs7(!*$L$!'hOptions7!'n ! 0rhs7(!* ! ! t %4rhs7((*krhs7(!*$L$\rhs7(!*$L$!'j j < solver_msg_21 %!d &A@rhs7(!9kH' (z( j h j e < solver_msg_22 %!d &A@rhs7(!9k ' (z k rhs7(!*'j j$= j j $$|'jd0 j$|'jk jx rhs7(!*'jk d rhs7(!*$L$v < solver_msg_21 %!d &A@rhs7(!9k` ' (z@ k8 0 W If Not IsNumeric(Application.Evaluate((Stylecheck(.EditBoxes("rhs").Caption)))) Thenrhs7(!*$L$rhs7(!*solver_msg_int %!drhs7(!*=solver_msg_int %!d noptions7% solver_int %!drhs7(!*solver_msg_bin %!drhs7(!*=solver_msg_bin %!d noptions7% solver_bin %!drhs7(!*$L %x$ < solver_msg_21 %!d &A@rhs7(!9k ' (z d rhs7(!*$=rhs7(!*'jd8 =rhs7(!*'jk k d rhs7(!* ! ! t %4'jkdrhs7(!*$=rhs7(!*'jdp=rhs7(!*'jkHk@k8lhs7(!*$L$!'n n$!$|'n nx n$!'nk noptions7%'xoptions7!'p x solver_int %!d x solver_bin %!d8 solver_adj %!$! n$L$ solver_adj %!$$N! < x solver_int %!d solver_msg_23 %!d &A@dX solver_msg_24 %!d &A@klhs7(!9k' (zd x solver_int %!dsolver_msg_int %!d'jdxsolver_msg_bin %!d'jkHk@='xk( j$= j j $'jk jx <solver_msg_151 %!d &A@rhs7(!9kx' (zXkP A@:k8 n  x  j't'v Constraint_list Solver_dialog %"%\!$$ t Constraint_list Solver_dialog %"%\% 'vyXkPH v tdConstraint_list Solver_dialog %"%\B@d td vConstraint_list Solver_dialog %"%\B@k update define names  (Constraint_list Solver_dialog %"%\!'r' !' !solver_numConstraint_list solver_dialog %"%\! B@' !' !solver_lhs r= n$L$! B@' !' !solver_rel r p B@ j$L$\'l j$!'l l' !' !solver_rhs r= j B@d8' !' !solver_rhs r l B@kd' !' !solver_rhs r= j B@kx' < j"$2addfunc %!d addarg1 %!d:="$2  n$L$%"$2, addarg2 %!d:= p, addarg3 %!d:="$2 j"$2  B@d@~addfunc %!d addarg1 %!d:="$2  n$L$%"$2, addarg2 %!d:= p, addarg3 %!d:="$2 j$"$2  B@k(}k }  (q}z}|solver_err_msg %!d &A@g|i|( user clicks ok in add-constraint dialogp|$ add_dialog %"B@|k8||0|(|solver_err_msg %!d &A@g{o{" user changes middle of constraint{Options Add_dialog %"%!KKKTrhs Add_dialog %"%(!*=solver_msg_int %!drhs Add_dialog %"%(!*=solver_msg_bin %!drhs Add_dialog %"%((*kxzrhs Add_dialog %"%(! Add_dialog %"(KTsolver_msg_int %!drhs Add_dialog %"%((*KTsolver_msg_bin %!drhs Add_dialog %"%((*nxy|pyhysolver_err_msg %!d &A@g(yo y`user clicks add in add-dialogx$lhs Add_dialog %"%((*rhs Add_dialog %"%((*<==>= solver_int %!d solver_bin %!dDOptions Add_dialog %"%(Options Add_dialog %"%(fOptions Add_dialog %"%(lhs Add_dialog %"%(! Add_dialog %"( (k(w| wwsolver_err_msg %!d &A@gvov! user hits "save scenario" buttonvscenario'|vxvsolver_err_msg %!d &A@g8vo0v" user clicks OK in scenario dialogu $! solver_msg_25 %!d +A@|uku $ Scenario_nameScenario_dialog %"%(!*'k@u solver_msg_24a %!d +A@|tktt  $ !B@|ttsolver_msg_24b %!d +A@|`tXtsolver_err_msg %!d &A@gtotXhelp for add-constraint dialogs Add_dialog %"!!*solver_msg_46a %!d ' B@Ldps ( B@LkPs|Hs@ssolver_err_msg %!d &A@gsor) help for user when solver is interruptedr , B@L|rrsolver_err_msg %!d &A@gProHr. help for user when load or save model is usedrSIf ThisWorkbook.DialogSheets("Save_dialog").DialogFrame.Caption = "Save Model" Then" Application.Help helpfile, 1834Else * B@LEnd If|8q0qsolver_err_msg %!d &A@gpop0 help from main dialogp & B@L|ppsolver_err_msg %!d &A@gPpoHpx% help from option dialog small solverp . B@L|oosolver_err_msg %!d &A@gooo help from save scenario dialog`o , B@L|@o8osolver_err_msg %!d &A@gnonn $!.! '\dn'\kninpn $!.!'vdXn'vkHni@nS translates cell reference into names if name is defined, otherwise returns address]@Xp]m $L'  0 6 %4' !GET.DEF("$2 "$2,GET.DOCUMENT(1))' $$String 'dl $'kldl 'GET.DEF("$2   ! $"$2,GET.DOCUMENT(1))'d@lGET.DEF("$2     $'  $"$2,GET.DOCUMENT(1))'kkzk !''   B@H' $B@H  $$String !  $!'dk 'kjdj $'kjyjkjj $B@Hkj  'kj ! 0 '|d`j  0 6 %4'|k8jz0j(j '|zjzj'jii creates names for reportsi]Xp] !' $B@ $|  $L$% $|' $B@z iki $! ' $! '''     $!N$String  $!N'yphkhh`h     $!N$String  $!N'ygkgg     'dg  'kg $B@zgxgsolver_err_msg %!d &A@g8gi0g# changes argument order for optionsf h TX X XX   ^  d X f$l 'df TX X XX   ^  d X f hX $l 'k@fz8f0fsolver_err_msg %!d &A@geieemAttribute VB_Name = "Solver2" Option ExplicitXPub, Sub Auto_open() ,.ProcDataInvok@e_Func P\n14l ' updatool-menubar if necessary R 'IfuOted Then0ExitEnpd If 1= Truepjap.ScreeDnUAingNFalsRun @("'" &>isWorkbook.& "'!fM]#e"YA3GVclo|se Bv;U nregi~:Cont_to̒:' callw user pres c@ inue "show" stop._sǀgS@ ,,s,%+Q+YPush_addˑte)"` " 7caFc"Add{chang!L*]Cancel deletl#K$`ThhDialogSheet$s(_d").ListBoxe@astrai `elIndexU0ˡ}cE`Msg ex$4l@5uage.Ra6("a_ms g_25b@Text, 32, , helpfile, 1830o@ /@EfD.e4gu`xPX44"hits "b3Dimc As IntPegerCO rror GoTo "ebj GWithk>C % .E di@Amum_e5l1CaCn" @a_;r3 .Focus&O F p py?ay@1&opt" A1 j Not /Stylech0eck(])).HasFormxula554 rA/3A 9q1?a'_Cel'0Pr@dents.Coun`!410___XOfAdjustableB4sY4+C0=%?7t(Referel2*:=saves*ts Q50_ $hO.GSpecmQPs(xlla").  a a Tb QV s7H[::::oQ }}~P'T//$`Oo2t_Útۄm!tCbtpC{Vu& aPs Ѧs Is" ;"9ons 9et _r  H̄R eset_ (?@ !C ttribute Push_save.VB_Pr@ocDataXInvoke_Func = " \n14" ' user presses "| model@@actionlS_4End Sub Pu0blic load() A o8>L8LtatOa P P$pa adi splay d ialogDi@m rowiAs Long, colIntegerOn Error GoTo maineSOpsDjThisWorkb ook.DSheets("7"")Frame.Cawexcel4langu age.Re("solver_@msg_46Text!2= C Stylecheck(currentFa)).Row : Column num@(8)8ListBoxe>ConstrPt_l@0Coun2/Cells(5e),  + 2$ ).Se@?#&bEdiE)Th|e_L'd.AddA(RefeVce[:=~s!/my_Q SBh2Exitw L:/Msg`(> CRC !C, 32, , helpfile, 01830 Іsayos?sK d0ub Do/ck&zvai ~|, jk%!the@WhingSB, _answ1I varj le ft) middlerigh ; o`_donB Boolea$zdummy, vbac Hobj, 2C,__HIf_bDbqB < 3j A_ p'on> 1 @V)A~Appw non.ScreenUpdP#@= True G=^^131= z&"PLeAgKc132AA4 [;_ag [magJS@Ifia-1 k(gqvgP  aPX=o^W$/o//dP: ?1Of fset(-r0)?kk¨1ZUIn;0Oo , "!")"035H=onn,@fp n0/arg3:=Chr(34) $s/Elsw>//, 80E&e  J ! p Nfix////P )K'xS6IdRecordMacro basicAz:=FEach c In?E///-)D -c^o_P <> "">dtyp`@]t "c. mula0"=MAX(;S}w&M ")Xjo2q$ 2O =MINp C Else  dummy2 = ThisWorkbook.DialogSheets("Sol ver_d(").EditBoxe4dvalueof*CaptionIf "." <> Applica%.Intern al(xlDecimalSeparator)eLInStr(,+[)R+Do While 0W0Mid;, 1)Hs)= YLoop9@End If c.FormulaA*=" & Ra nge(sCwopt).Address"B-2L@}i0q#DadjA""zK+COUNT(,@,)"*W% num + 1,' CsIthestring@5OsMax_time B&ZList&w2V]&ir??nOy?9Prs1__TC:r:Toleranc: / 100j^ Check$AssuBFV!OxlOnNV = _!T!"TRUnEh? nA"pFALSL &onhm&Show_dZ_'g{_'_'1A_'_' _'_'$'auto_scl 7 ROK~ O'O'MO'\b̐JButt("TAuntތ   _"1:?/k'//& "2k:fg^&LwardOOhx o O~0 T/AOOOh3MLNew '???`   ??q&_3_3o^Conge~YOWyԮjnon_neg/0?W?WJ?W?WOOOh2p& /.- E$ Z Mֳ If ActiveWorkbook.FileFormat = xlWK3 dOr38BFM3 Then c.mulan"=VAR(" & thestring ")" 3ElseC{@} @nd If!#'=lef~Mid(CStr(Sheet.Names("solver_lhs6i)), 2) K#middlek $rel$Select Case*4"1 s = "<=*righ$!!4 "4" A`5"q@KX=SUM"@#_& "e ]`+ jh@0@ 7) S? sD)=E0H @ɴF)LN>;]9@8),Countp > 1TK"."RApplication.I nternbal(xlDecimalSepara0tor) ` dummyInAf&<, *`FDoh Wh d0O b, 1~)x /&s=2 _ ."_ dLoop?% D= ConvtD-s@,A1QR1C1ooooF r,J ## 4  ` my P&/_ _ //_    FArra3"=- /G ۯ _ _ _ _ _ BxPK/fp #q߂*=0)+/+1/ta&ff7****Yfgo'o'o'f'fsvs<6_ _  o'"fEfffcooooF ?Zk Do While dummy <> 0  ,Mid(thestring,f, 1) = " ."p= InStr Application.@Intern al(xlDecimalSepar@ator))aLoopEnd Ifc.FormulaArray`=" & o!Else%If*g Then(ܘ}}}}|/яLi@i + 1zi > solver_numAExit NextRange(Stylecheck(currentarea))8.Se BSub save_error:\ScreenU$pdvngTrudMsgBox excel4lAuage."Dmsg_se").T, 32, , helpf` L834'main  r_@ Ğ@, ,A$ Pub  Load_m odel(At!bute.VB_ProcDataaInvok@e_Func #" \n14'pBres a@Ldisplays "l " d ialogOn E5 GoTof f acA O p!s WithJisWorkb ook.DB Sheets("S@ "hFrampe.CaB 945,!.Edit@e _aR SAddress(RefeWce"Z:=!Us[)Show a5AfB7DQJD+Dt`cEAdjustabl@ EEE valilon of9ri CDim As S{1nnew|yadj_countAQyger, iSr!Tho&e&cN&9!_PBls!OR/u0onListx","{TW__q3?(siqZyLeft i -& & ba- P_ ??-q!2E (cf!ET[!"D0b [AF+Resuxme 'm sb).1Ls%.NpI1A`OveL3a3?g3a@'gle7gw.gvT .Focus//!^xR?1 10`Not C<  d_>_  AS#/"oroo+gJ=?AЏs.ϒc51 t?R)/'& Get_np'((i).l)@Ŀ:::5& ?-EG4 = kIV , nJ)JsyO%O%?/"04Y /?~?~.4?p(?~}7~Obj?}?S'+}objeMc/} or/}"} 4}=?oy%heets("Solver_dialog").EditBoxeOptimum_celldCa< on If Application.ReferenceStyle = xlR1C1 The`fthestring>Nche(ck()ZEnPd If sopt3""{ J"" fExit Sub, MOn Error Resume Next)RangeF.Count <`> 1 O Works.Na%ActiveFS ~Msg $ex4l&ua(ge.:"sms(g_7TL, 32, , helpfile, 01830WThisAbook.Dނ<Focus(W;!a@<onf&_GoTo maineAcCJzbAddrexe60onsC C*c*%d*tc a# #_OK++f+Dim e As Do `!)>`767.坔*Fals C +[K!{ك>B!4A )ċ-O on0O PO K = 0RO=m@o8 OoNonx*__/','__0  {<_P9_ _T 7P7___\nDPrecis l{`uD 2P) >=0ϔxϔ!yɔ10P%%?C(>" %%%OCOK55?YCon@g_r\ :::10a**7O; M;9bTolera@7C`y(0rëOn) `5>@o/yPU>V60solver_esD47drv48nw$gqCA{`CDbl(qActiveSheet.Namac$tol@ RefersToLocal), 2)) `* 100Dw L"|<>?CjLeft-ߠ93C>sauto_sc.= %F10n_ iQ sA4.EditIJConmgencaCap=f%MܟgM II11Inon_neg@$uoG$vg12$8!////P$!iRecordMacro basic9:=TWitha@Ponezxit Funr maine rror:Msjg+ jgcr0r_msa, 32, , helpfile, 01830   Pub Sub Or0_cap1l((Attribute.VB_Pr@ocDataInvoke_q \n14' r more settings if not 9s If@hk a isWorkbook.Dialog2d s_dR"2 >Max_ti2t> "ie{#MiOP:rs`+\0.0uTolerQ5?L o:f_ ==5sϟ ?`hBuPttonT`nt G Forpward@. Newa4w=0=0E=p57' old m l, these nq a21always available;QrefA"EB ReA N`ɣ33`333im` p^6_^itr_`_9aXonpr oa]Nxon_ ^?^nG}^sho&Show_iterG_scl&0auto_ /est/OptionButtonTangen 0ʌ QuadraticKm-IU؄drv%%ForwardUC+ra@J ,%H4|%?%8%nwJNewL%g+Conjuga~t _%=%x%On Error GoTo maineCWitJhaon"xit Sub :#Msg excel4lruage.RGs _ms.Text, 32, , helpfile, 1830 nd ab Public! Reset_all(do Attribute.VB_ProcDataaInvoke_Func \n14d'r! eything to default vAs'/`(gecP_17&3) <> 1>E;!Q{AppNon.RecordMacro basiccode:= R>fT 怩ScreenUpd= Fa6T$p isWorkbook.DialoVgr0\S#dB"h.EditDXmum_%Hqx)AdjustPables0 CacMLis%Or(0O@ HYo - olOo )_(b./{Yrlϻ)&TP\0 Np`32Defh_naPGadjDpeletͿoptJװ4!hsQ.Add :="'" &N } "!n0um",ph:=|ThOpOu8.HinHCoun`sV2M:=(@ = the< ?jRactiChall r`rFinish_ca~n@J Pin f C6 boxS Dim i As Integer, cQApp a.ScreenUpdng*' Run ("'Eas'!Restore%"]i`AFEach c C1$adjc.x oldvars(i! i + N@Cßß ?=A2@?? f'>Hnkn7$}ttD.  orIf /SόadƌAdPjustQ_AlbsCap2-""Pen#@/~8_P_18@_ h7S aRIf@T#opt~ASN LisUConstbr@t_lPC(oun0icNNx/ng'Ҵ /U`!ߏcH +aWume P+<> -') Unn(nY,Z)).ϳ0Th-P Not.Haspamulak0 /(11msg_7a@#11S_TO93 C> 20/0?~5~/0/0Z19N `!?/0SS <r 3'PWJtcDep|e_nsnnnnd"s necesTsary names for solver On ErrPGoTo mai ne8pDim update As Boolean4,= Application.ScreenU1bingP> =@ False'Obj0djust ablesIf ThisWorkbook.DialogShee ts("S_dA").OpB uttonmax_b Val$ue;xl{Thee_typ51;EM=in]=2= N3nd IfActive.Nahelps#2D9opt""U@FResume NextC @V@VDele>tDrM n's.Add A:=" '" & 0& "!H, Re@fersTo = , Visii:=ȔEI?adj?"?@KRտG@LGA!G#num`#mmListBoxJeBCntr t_l"CounHWithd= BEBBu"G3_ N valH Local:=$$(Edi$d` ueof #Tk_c_6 7t7?#?"tim*CDbl(s)M eCa)itrÈiterߢ͢preS*rCO1 0{FoHr iA1 ;Th??stCoxunt##/CB=@ Mid(C 8(Gmu$glhsTrim(!i)x, 2`^ SResume NlI@IsW(re)ress)!C !E= i `p9TrugB*?!{%E`/Ge TQdrnoonal(xlDecimalSeparator_!Y InBa , ZDo Whx\Tx&5h{)0  eLoop?&;boRxY@@Rp ]OJ@T?p Qg" @' formula|x jnb= $np !OPB!")!27 `0F)j)YL0R,- 1) FRLen) -Akvp=pM6_X"-uJ/OE|Ohe+OOOme)'/! !+֋ ??rob.U.UUߒC/ Q.."_?C\UjU `_"C / > ?R& "&v4z%*0(Fwhich_one) = newentry Th en thei `Exi t For ,End If "If IsError(_right)e#_cons@traintqT8rue K9Ne xtNNot :mid_il> 3\Application.RecordMacro basiccode:=excel4language.Re("delfunc").TL & "& addarg1:="Chr(34)*Stylecheckleft)).Address(Reference:=savesA ",^"2N"cI lEls pSInSt, 0X XXXJkX3؊g6 /7o0?]?]?]?]?]f(g6]0Av0Namefix)&a1 LActiveSh0eet. hehlpsn ThisWorkbook.Dialogs("Solver_dIListBoxee@Cƴ_lRemoveItem Index:=&f  sA !'."!snum6BsTo:=X$_tCount, Visibl FaIlast&j + 1%?#!O+#lhsA(Trim()), %+T)c`A! me rel} e ,  o  0't3'r??7   1<= p\,=y@Sub m:3&Msg> /^J("/^(F46W<= ") @=@(_{=R[" >`! Ry3}/'qq ,2}ex@xEdixq[).Cap!Ȱ_L )_?O"+ RqLen) -t5- 2_("DropDownP3Ors{Array("<=B>Q?MMbi~n?O N Lines 5 ,OOO AOR ("]P]_ int").Text Then  the_index = 4`ElseIfisWorkbook.DialogSheets("Add_d"EditBoxe.rhs Caption"=" & excel4language.Re("solver_ms`g_bin65And IfTh#DropDo4wnTOQVLixstI/-F`rame.|4 6b|8ShowMsgƟ25aD, 32, , helpfile, 18 30ZExit Sub mainerror:C  z E PublicA constr@ t() Attribute.VB_ProcDataInvoke_Func \n14"C/' add a On E9 GoTo <l ٬a`#Array("<=", w>AZYG,;O'}`7F2LQs@ x Ɂ^1= cg46%q ?s8?s㨁2stattak@Valid_tdoAumuuv ateshv a savif #*:yDim numb`of_t As Integer,(`n*aŠrightSng  RAt, !oCI l efCmiddls rele ewentry ifpcounDS With//og"ۤ< .N"!A/e20e^lF1.FocuB N{3g *FFap9Q8E0siI:n(V!") <> 0 A,_d, Active. ) 0oB ߳ ) f?Resume< N #pSStylecheckou)).Areas.C2> 1oo?[`,Voo,Yoo N iTdorA pplic`on.ScreenUdpdngW= DDS4U= ._A}I Reference @ xlA  ;ContFormula %j:X  , bp4Wy @IsCell(-o)),@ z ' OI@_`+ OIOIBI1o`o`U33 \I׊/` ` Y!^0True(_LqD<>`b+IX If do_msg Then MsgBox excel4language.R e("s olvert_22").Text, 32, , helpfile@, 1830 .Focus = .Edit`es ("rhsCName -End Valid_constraint!FFals 5Application.ScreenHUpdng-Tru bxit F8unc4 120Z,B RE *IsCellRef(Stylecheck(9))" 妯1 ??E!On Error Resume N' (Not IsN`ric()hEvaluate(4n)4 =on=((7D@l^@= Or0dyu& ) A j.Dr@opDownoLisCZ binon @Bɨ o}BտTTATiLY⿊+ԅ$ FE ]Up_]6qlodpx&/@./Cy?If) Con4tFormula_Mu, YrerenceRTCxlAbPuteG. TRClpN3hxld)).AddressSHT2) > X  mipddle ogogn rel_i+jbjIndex3 kgkuocķ_ۃx^tc ' AлveSheet.1cwadj 1).Cou<> _@Un`(s! ), OO)"SԠ e"/j__23__2 :`04@Y.5_:)/q ooopMq"%88j the_right = excel4langu age.R@e("solver_msg_bin").Text  End If" middlbe"="N HIf Left(, 1), ThenY R 2Len) -Cj '> 120 39Gdow wMsgBox151, 32, , helpfilbem830h). Focush.Edit/es("rhs Name Valid_constraiBnFalsApplication.ScreenUpdng5Tru,xit pFunc gchCDeleteH OnewenXtrynly & "@&C index@LFor i1 To Trim(Str(ThisWorkbook.Dialo@gSheetQSdTLisEX2CFN_l@Count)) @Z 0KS# as.  !:="'"cc"!num", RefersTxo:=$, Visible|:=(!{l )) Stylechec&kA))#retss?m(rel!-1@_`p @lIsCellb/pence)o {ա @I"zO n ErrResume Gyi/(.E?H -"LM3&ahP*=DӃ/ !zA o/M9n/0O09S Q =O8 RBW-Local/5\ |n5ziInpUChr(340(= \)RecordMacro basiccod@4/g addfk_q"2|arg` o/?@+?(F6A:@=savesAB)ߪP2h d>P 3 7 V9/1ƺ3 1? s!p _S0;fixQWHY@.>=LWithfmPe\:xqͿ1 w Pub Sub OK(Attribute.VB_Pr@ocDataInvoke_Qh` \n14Di0ser c ks @ok in $-8ƓlGoиKM(1ǼqŐ_Hid! ,R0o_signٟbs tҘof Oo LSct Caseϴs("Add_dialog").DropDownOptionsPListInd ex Case 1, 2, 3D(If ThisWorkb ook.DSheet EditBoxe.rh_Caj = "=" & excel4language.Re("solver_m@sg_intT@ext Orhwbin;Then~ A~"(End If%.Focus6FNameCy4n vhu 5  xaSelectxit Sub mainerror:CMsg @@, helpfile, 1830nd  PublicA Ctr@t_@() Attribute.VB_Pro cDataInvoke_Func \n14'user c` ks add in-cOn E GoTo Valid_c(True)seSÐHlMd  ͗V*Array("<=",a>AN,GS>@A_ C L@Ym!["1C@?#}"^'NEgAppZa!.ScreenUpd|ngTAmE||| Push_scenar orBacQ`"r?Q||, ?Qn 0?Q0QtQS!_OK(Ӌal Ea!RRBROKR R|orR RSDadj).Count > 32KSe_Q25ee=d` IsMissing( q4:Dn` zR%y a%1("?oxSng24aOOO;2 0ofPF4Ap2ve G3dhOn Err@GoTo mai neIf ThisWorkbook.DialogSheetsH("SS_d")Frame.Caption)$ Mx"KenYApplic2a(.Hfile, 1834a(Else'nd IfExit Sub m: MsgBox excel4language.Re("solver__msgnText, `32, ,S053nE<5 ` Pubo= M_n() Attribute ,romBk _!s[1KKKOK4LoCL small {CzO8C'Scenario0(J(.Nsd Oor#O6'uu3u'tc aIsCellReference(the`ls) As Booleay,,vResume N9 C.Areas.Count > 19Faf/Tru!i"_!E' L @!Not (!= 1) F!` ?)!@?"FDGet_n (as "sɒ =5i-T/o`'oRigh"tLen) - ?0) _ ED$//$ $~ ~1)t- 21%%$w$Z2 k5oorCpci L94e4e4DǻCA@T 5\ A)W-(O/q??@P¬P Ê'"()  "LO<)a֚d ` ^ey/#h?g6g6 _gyUGx it Function errortrap:  count@er = 0@Resume Next End Public` Stat  Formname(ByVal astring,heet) ABtbute*.VB_ProcData Invoke_R" \n14"' creates cs for re ps On E GoTo mainDim currentbsF As_OrowipLoW(colIgexr, f+ol , i'== AveSD.NWor"kNs(a).zIf Ge t_) <> Range(Stylecheck) ddress(Refe @?ceB :=saves ) Theq_! * 6+@ Exʝe@ AIf^=D04.RowbColumD-g= "D d6 e=sw- 1 1ep -1A(YTypef(Cells(i$, C").ue)ASX"O $ HorH/C" /@$JO ! K B 42x2222< 2 x,\P/ $4<@DT\`hpx|$ pMEd@> LLLL"  LL @ꀠ@B@ꀢX D@ꀦ H@ꀪL @ꀬ P@ꀰ d@ l@%8$@xʀH @ʀ @ʀp @0 `|k 14` o 14     $ 48  @`pk`po 14d: f<h@D jTlXn\p`drfthvlxp  ` k 14`b `"k` I  14`h`#f `xX%k i8iXi 14+L`h'k I  14D`( k 14tx| 0    x 8   ʀh @ꀆ@ꀊ( @ꀐx, @ꀔ4@ꀚ< @ꀞ@ @ꀤhF@ꀨJ @ʀT @hX@ꀶ p @ʀt @ʀ @@@p   h   h  @0 X x@ (H  @ P0`HxP0`H8X@x @h @xX @H @pD @4 @X$ @ @ @  @ @ @ ` @ @ @ !@ !@ -\Sh&(.026@p @ e@ 0@ @| @l @0\ p@X @`H @H8 @x( @  e@ @ @ p@ @ @0 Ht@8:<>@BDH@ 0 JLT@ @ `@_ " e@ @  e@0 @Ht @`d @xT e@D @4 @$ p@ @ @ @  @8  e@P @h 8@ @  e@ H`0xhx|~ @x @@h @X @@H @D H@@ @0 @( @@ H@X @p @ @ `PZ@ p/@ ;/ e@0 @H  @` `@  e@ .b @ `@  e@ @  0x e@X `pz@t @p `X H `  8P 2@hx @h @@d p@T @D @(4 @$ @  e@ @ @X @@p @ @ @ @ @0 @ @| p@l @H\ @pL @`< @x,  e@ @ @ @  L.Z@ @0 pH"@_ 0"|0@x @ pX6&@ kp@ k0m e@@ Xn@ h@n@v e@ @ 0X $(@pVZb@Xx @h @d @( ` `@ p@P @@ @0 @  e@P  @h @ ` ( ` @ x @ !8!!P!!"p""@h!x @!h @d @\ @!L @!< @X", @( @" @(" @@" @ @ $ !@" ."""@ """"  $$##P$#$#@l ###h$ @#T @$D @4 @$$ ` 8@x$ H$$P$@$ H$$x$2@ @ %x$ @ % 8%$ @ H% % P% %.X8%H&&`&P'%0&&@l  &%`& @x&h @&X @T @&D @&4 @&$ &@' @8' @ ' @ '@ @ ((p(X((@( (`Lx0((06@(h @X @T @(D @(4 @($ (@ X) @@ p > 3$*\Rffff*0837ff36b9*\R1*#229*\R1*#c4*\R1*#3e*\R0*#14*\R1*#cd*\R1*#b3*\R0*#f*\R1*#171*\R1*#b8*\R0*#13*\R1*#4e$*\Rffff*0937ff36b9$*\Rffff*0737ff36b9*\R1*#175*\R1*#67*\R1*#45*\R1*#5c$*\Rffff*0:37ff36b9*\R1*#b*\R0*#10*\R0*#1a*\R0*#19*\R1*#1d5*\R1*#ce  8Xp  " "  X( 0 R2G(`h'p4GK9 ) 2G H PX`Bh4G : 4G  (/0 KP ,Op    .O     4G X`h .p " . % 06 7 "  0 8@HPX `*h " "1      *[( 6VX = X 6w   Fk(VpP  Fk Vh b  (  00  H  P  h lx *N V Pp  ~ *NH Vx b 8 0@  X  ` h  p  x  "          "      T0  H P "`px " " ( @X` h p $A "   4G >Q P`JuhJxCC0 P1X#p)30*E "0S@` h x "3 ( % ((6(04G8px2G  " ( * ,R8 &h 6 # "  ( *0 &P &p $- & &- # # #8 #X #x # #4G ( "0 H8 J  087@ `@]h:F 4v@ H>LP>F (\:T( h8x   ` 8I  H P `` 8I    ^ :Ip  <D *V8:PU @<  >( h x  U $ D &\"Z 8BH"Z <D 0 8 @ =H "`  p R "      : Q!&\8!"Z`!,t!!O!&k!"""  " (" 0" @" 8dH" " $2" " " $2" ##*_# H# LmX##  ## # DT#$ Lb $p$x$$ *$ Bw$ Bw$ Dw8% J{% @% & &-& Fw@& & $7& #& & #& & 8& 0' $78' #`' ' #' ' ' $7' #' ( #( (( $70( #X( x( #( ( ( $7( #( #( ) # ) #@) `) $7h) #) #) ) #) #) * $7 * #H* #`* * #* #* ****4G*+ + *(+ &H+ &h+ $-+ &+ &-+ #+ #, #0, #P, #p, #, #,,,, ,,, ",--$- -H-KP- p-- --*-4G--. !. !. 0(.(8.P.-h. .. .. .... B . :. \ ///,////&/ >0 0 (00080P0 h0 p0x00 00 B 0 0H[0  01 11 1(1Xg01,-11,-111 B 22 2 2(2J02P2X2`2 h2p2 "x2 .222222 "3F_3X3`3 h33 "4 6P 4 X4h4 p4x4 "4 4@f4 4x5 Ds5 5 `6 h6 770707 87 @7FwH7 7 7 =7 #7=7&7 8S8&08@8H8-P8p88Ix8V8 9Fx9n`9Fx9 :8L(: `:0h::8I:V: ;n0;Fx;Fx; 0<8L@< x<<<<:I<`=Zh= f= 0>x@>Fx>b? h? x?0??/?Tw?@f@@ @@@0@@/@Tw@0Af8AA AAA^A- B$V@BhB$VpBBBBBBB.B M(C(sHCpCCCCC|C(D%0D2FHD-DhDNEXEb`ENEF ! F2G0FhF%pF2FF-FhFNHGGbGNHXH !`H2GpHH%H2FHJ`I-PI-pI2FIJ`IDwJ`JDwhJJJNJK !K2G(K`K%hK2FKJ`KNL !`L2GpLL%L2FL-Mh MNMMbMNHNN !N2GNNN2GN0O 8O @O HOPOXO "`OpOxO OOO OOO "O2GOPP "P4G(P`PhP "pP4GPPP4GPQQ Q] @ h  ] (P ] x ]  0 ] @X h ]   14]  ]  ]   ] H p @A@A@oR This is the main routine, displaying the Solver dialog box, and taking appropiate) action, depending on what the user does.]]0H`x]14A@ !l  ! solver_msg_1 %!d &A@gk ! solver_msg_1c %!d &A@g@k8 !$W !X ! solver_msg_1 %!d &A@gkkk !! solver_msg_1b %!d &A@g@k8 !' $ solver_msg_1a %!d &A@d'    !$W $ $ SOLVER32.DLL'yPkHd@ $ $ Solver Add-In'ykk  solver_msg_1a %!d &A@kk !' ( !'  (  !'8  %'' solver_typ %' (' A@dA@k'  B@ Cancel (Cancel'@ Solver_dialog %"B@$ Cancel A@&' solver_adj %!$!'dValueof Solver_dialog %"%(!*'. . %,  . %,'   $.   $'k    0okfunc %!d okarg2 %!d:='  , okarg3 %!d:="$2 "$2' , okarg4 %!d:="$2 "$2'dokfunc %!d okarg2 %!d:='  , okarg3 %!d:="$2 "$2' , okarg4 %!d:="$2  0 6 %4"$2'k   B@d    0okfunc %!d okarg1 %!d:="$2 "$2, ' okarg2 %!d:='  , okarg3 %!d:="$2 "$2' , okarg4 %!d:="$2 "$2'd8okfunc %!d okarg1 %!d:="$2  0 6 %4"$2, ' okarg2 %!d:='  , okarg3 %!d:="$2 "$2' , okarg4 %!d:="$2  0 6 %4"$2'k   B@kkk AddKT (A@8DeleteKTA@:ChangeKT (A@<OptionsKT Options  Save_model  Load_model Saveload OptionsKT (A@> Save_modelKT (A@@ Load_modelKT (A@Bn  SaveloadA@D SaveloadOptions'  Save_againe Save_model'kk CallSolverKT msg_setup %!d (F (A@&  solver_msg_1a %!d &A@$He Optimum_cell Solver_dialog %"%(!d JY('d Optimum_cell Solver_dialog %"%(!*$L$!N' Optimum_cell Solver_dialog %"%(!*$L$!P'k $! $!'  $ !N + !P +  'H $L$B@H' ! '!Solvecall %R' solvefunc %!d  B@ ( $L$ B@A@TCancel'k nx p ( $L$B@H  ( (F  (|  $A$1$B@H  %'  solver_err_msg %!d &A@g  solver_msg_1 %!d &A@g@ 8 '( o  " sets default for fresh worksheet. Solver_dialog %"  V% Optimum_Cell7((dX dValueof7((d/ .EditBoxes("dValueof").Enabled = False Z max_button7X(NAdjustable_cells7((*Constraint_list7\B@^q Options_dialog %"dX Max_time7((*dX Max_iter7((*ư>X Precision7((*X Tolerance7((*-C6?X Convergence7((* bAssume7`(N bnon_neg7`(N b show_iter7`(N bauto_scl7`(N ZTangent7X(N ZForward7X(N ZNewton7X(Nq( |  solver_err_msg %!d &A@go@Agets relevant setting for the worksheet, if not a fresh worksheetC many options need not always be defined, so "on error resume next"]]D0Q]H`x'dz solver_opt %'f d f$| Optimum_Cell Solver_dialog %"%((*dP Optimum_Cell Solver_dialog %"%((*kA@~'d  solver_adj %!$%'h d hAdjustable_Cells Solver_dialog %"%((*dhAdjustable_Cells Solver_dialog %"%((*k A@X 'p solver_val %X $'p pXX dValueof Solver_dialog %"%((d=1'p solver_typ %X 'p p=1KTY ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = False Z max_button Solver_dialog %"%X(N'=2KTY ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = False Z min_button Solver_dialog %"%X(N'=3KTX ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dValueof").Enabled = True Z value_button Solver_dialog %"%X(N'n@Constraint_list Solver_dialog %"%\B@^' solver_num %X $X'   solver_lhs $$ %X $'n n$!$|'n nx n$!'nk( solver_rel $$ %X $X'l l solver_rhs $$ %!X $'j j$' j$!$|'j   formula j !'r r j' !'! j' !'!'r rb j r $ j j r !  $'j j' !'!'r@d8 rb j r $ j j r ! $'j j !'rkk. . %, j.'r rb . %, j r j.'rHk@d8 jx solver_rhs $$ %X $'j j !! j' !'! j' !'!'r j j r !  $'jd@ j !!'r j j r ! $'jkkkkd jXX 'jk lOptions Add_dialog %"%%'x lesolver_msg_int %!d'j='x lesolver_msg_bin %!d'j='xk n  x  j$'t  tConstraint_list Solver_dialog %"%\!$'vdP'vk@ v tdConstraint_list Solver_dialog %"%\B@d td vConstraint_list Solver_dialog %"%\B@kxOptions_dialog %" solver_tim %!X $XX Max_time7((* solver_itr %!X $XX Max_iter7((* solver_pre %!X $XX Precision7((* solver_tol %!X $XdX Tolerance7((* 9new convergence option will not always be available, so..-C6?X Convergence7((* solver_cvg %!X $XX Convergence7((*p solver_lin %X =1 ZAssume7`(Nd( bAssume7`(Nk 1 new option nonneg will not always be there, so.. solver_neg %X =1 bnon_neg7`(Ndx Znon_neg7`(NkPH solver_sho %X =1 Z Show_iter7`(Nd b Show_iter7`(Nk solver_scl %X =1 Zauto_scl7`(Nd bauto_scl7`(NkXP solver_est %X =1 ZTangent7X(N b Quadratic7X(Nd bTangent7X(N Z Quadratic7X(Nk solver_drv %X =1 ZForward7X(N bCentral7X(Nd( bForward7X(N ZCentral7X(Nk solver_nwt %X =1 ZNewton7X(N b Conjugate7X(Ndx bNewton7X(N Z Conjugate7X(Nk8q0|( solver_err_msg %!d &A@gOptions_dialog %"dX Max_time7((*dX Max_iter7((*ư>X Precision7((*X Tolerance7((*-C6?X Convergence7((* bAssume7`(N bnon_neg7`(N b show_iter7`(N bauto_scl7`(N ZTangent7X(N ZForward7X(N ZNewton7X(Nq0|(z 'doLanguage %.Excel4Functions %.] !$W xladdin.chm'dp:MS EXCEL HELP'kP !solver_msg_150 %!d &A@gk !' !' !' '    $'"  kXPkH A@k0o( 4 This procedure doubles the "'s inside its argument.V This is necessary to avoid recording problems on sheets with quotes in their names!!!]h      $ + $"$2"$2"$2 +k'    $' 'zx'ih    Constraint_list Solver_dialog %"%\% 'd  'kzk    Constraint_list Solver_dialog %"%\%     $'d@      $'ki  0 'Ld  6 0 %4'Lk z  'Li ( user presses "ok" on load or save modelH ]0 H ]` x ]  ]   ( Save_dialog %"!!* solver_msg_46 %!dA@d  load model Constraint_list Solver_dialog %"%\!Adjustable_cells Solver_dialog %"%(!* ( solver_msg_5 %!d! &$' | k k (A@The_area Save_dialog %"%(!*!loadfunc %!d loadarg1 %!d:="$2The_area Save_dialog %"%(!*"$2'd The_area Save_dialog %"%(!*"$2loadfunc %!d loadarg1 %!d:="$2The_area Save_dialog %"%(!*"$2'd loadfunc %!d loadarg1 %!d:="$2The_area Save_dialog %"%(!*$"$2'kk   B@'' The_area Save_dialog %"%(!*$L$ $X != !'. . %, .' b . %,   .'k $=MIN Z Min_button Solver_dialog %"%X(N   $$| Optimum_cell Solver_dialog %"%((*  (' !' !solver_typ B@' !' !solver_opt=   $$! B@' !' !solver_val B@  (X dvalueof Solver_dialog %"%((*' $=MAXep Z Max_button Solver_dialog %"%X(N   $$| Optimum_cell Solver_dialog %"%((*  (' !' !solver_opt=   $$! B@' !' !solver_typ B@' !' !solver_val B@  (X dvalueof Solver_dialog %"%((*' COUNT   %, e8 Z Value_button Solver_dialog %"%X(N  = $$| Optimum_cell Solver_dialog %"%((*  != $XX dvalueof Solver_dialog %"%((*_ ThisWorkbook.DialogSheets("Solver_dialog").EditBoxes("dvalueof").Enabled = True  (' !' !solver_opt=  = $$! B@' !' !solver_typ B@' !' !solver_val  = $ B@  (' $=COUNTAeX ! 0   $Adjustable_cells solver_dialog %"%((*d?   $ 0 6 %4Adjustable_cells solver_dialog %"%((*kx?'A@A@& $=COUNTe8? ! 0   $Adjustable_cells solver_dialog %"%((*d>   $ 0 6 %4Adjustable_cells solver_dialog %"%((*kX>'A@A@& = <= >= =INTe $=VAR   $$'d=   $$'k`=]   + =     %, $ +  $ $'   %,     +'yh<k`<X<$$$$$$$$ $ $ $ $ 'y; <= eOptions add_dialog %"%( $=SUM  =  =  $rhs add_dialog %"%((*  <= $lhs add_dialog %"%((*d:  =  = $rhs add_dialog %"%((*  <= $lhs add_dialog %"%((*k9$ solver_msg_6 %!d &A@k9 >= eOptions add_dialog %"%( $=SUM  =  =  $rhs add_dialog %"%((*  >= $lhs add_dialog %"%((*d`8  =  = $rhs add_dialog %"%((*  >= $lhs add_dialog %"%((*k7$ solver_msg_6 %!d &A@kP7 =INT eOptions add_dialog %"%(solver_msg_int %!drhs add_dialog %"%((* $=INT $))=1Options add_dialog %"%(solver_msg_bin %!drhs add_dialog %"%((*   $lhs add_dialog %"%((*d5   $lhs add_dialog %"%((*kH5d@5  = $lhs add_dialog %"%((*k4$ solver_msg_6 %!d &A@k4 =0)+( eOptions add_dialog %"%(solver_msg_bin %!drhs add_dialog %"%((*  = $lhs add_dialog %"%((*$ solver_msg_6 %!d &A@kP3 = eOptions add_dialog %"%( $=SUM  =  =  $rhs add_dialog %"%((*  = $lhs add_dialog %"%((*d 2  =  = $rhs add_dialog %"%((*  = $lhs add_dialog %"%((*k`1$ solver_msg_6 %!d &A@k1d1 solver_msg_6 %!d &A@k0'k0k00k0 (|00 h0k`0 H0k@0 ( solver_msg_6 %!d &A@|// ( solver_msg_6b %!d &A@|// ( solver_msg_6c %!d &A@|@/8/solver_err_msg %!d &A@g.o..Attribute VB_Name = "Solver1" Public answer, action As S|ng, c hange"Boolean, fresh" oldobj, format'Kdllavai l;s_adj3 1op GliIntegxnegB Nt$yp,  re sho%sce @esV nw drv1Hort_generastop_] remembersheeB^Acurrentarea>num qvars()DoeBvCvLAutoOp@-&d ,avEyle"excel4l@uag., th0n, helpfilE O"pBIExpitSub stu`b() A.ProcDataInvoke _Func \n14@ 3$_o4 @Main End DSthc  A' ' `This @A m@ routinIdisplaPyingH dialog box@&takAappropiat.` {, deda}whtA user does.b Dim s6calculPZb:atusbar=creepnupdG dPummy!SDi c, vbacod<Carraynewpar]! 2 %aOn Error GoTo VeAdgIf AveSi.Type <> xlWorkR OH`JtectCo`nts 9eE/aMsgBox #]%_.R("msg_1").Text,` 32, _^, 1830c PsRIfcbook.IsInFcATruegec Left(Aps I.angSyPstem)oWn"+!V>D C G(6)  O MultiU[Edi igN3r_30 f!#fiindow.Sel JedPs.Count > 1? bp& Q B"8RegbiPredQTXss IsNull>( a(_1a ~ ElsN = FaF`?Ri LBd o| U< o,p"zo,_&)Right&(iq/02/SOLVER32.DLL|0#X < Exit )&9# 41) 3 Add-In C sV  N`QCV Not ThV %%=%l00;y d{ds tstUr= 93D|уusBary +'ivuSUx~EnableCanKeyxl mAd yRefepceStKsK`Zȧ73M.$s([:=!oCj>}A {sx", KpxG$~!=< 1c0, +Set_defa`kTTjMGsetl?`D#*'RecordMacro basic:="Wh<> "!ఈxHGVResu`=fDR#o(_``Show "W  AhLDef _!4J4q xPȢA3ɥ'01)1K%=fisets("Solver_dialog").EditBoxes("dValueofTCaption If "." <> Applica>.Internal(xlDecimalSeparator)0 The dummy2 = InStr(new,t,+W)SDaTLeftSk- 1) && hMid+(E`nd If~sopt2"" A adj vavestylexlA1avbacodexcel4language.Re("okfuncTextf "arg2:="f@ D& 4typA, 3 Chr(34[d& " :"4cElse"^ok^@^r^OY/Con`tFor mula(2, _R1CBroU RecordMacro basicg:=X;=xy`D_yf%j= ?Jy@/1^!^wN] G%& D> YS??_!4 r??#y?nBn_",_"_"ui _"0fmo@_"C` f/V,wP_"WOOj9oO 9O?Oa Select Cas0e acR"A dd+y Scre enUpdng1`Trukv_constraintDte 3_ SCh!(o թo m ?7OsKWhiМb"E OrQSIp_ml"Load= "l# ? 2Show_Ds" 0??fWJC Q2fRok! P'_i_ag7"6 D_ 0Wend ;all. #tatusBar4tg msg_setupđZ''Fa}Define_name.0Not dllavailMsg0oNnQ 1a , 32, , helpfD, 18830 хProblem_ok(a0ThisWorkbook.DSheet0EditBoxes("Optimum_cell").Text = "" Then oldobjDCVErr(xl NA) RElsezRange(Stylecheck(ThisWorkbook.Dialo@gSheetSolver_dCaon)@).Valuf0ormas]CNu`mberF7nd If ReDim vars (Osadj).Countknis1!, Each c I 120k T 7 mid_i9= )CArel3c < 4rXigh?+Br0+.RefersTo`Local(  ` Not IsbNric'").' ؂ ۀ@O9P1> ' formulaVbe@jIn&, hej <2~"'P."'!") t, ?~5#Do Whi8le C _c -IL;,- 1)R'6$"-A -6%yet Loopo * OONOOOme = +|+?sMCPMN#e0"."+Ap plica.I nternal(xlDecimalSeparaxtorC?1."_ ?ezfV@,+=    ## /)\#kD)/w3 a-w''19MHM[>R_/XpCNN8NHI d "*o ,o m 8,oxF Else 8the_right = CStr(CDbl( T))End If LmiddlezThisWorkbook.DialogSheets("Add_d").DropDownOptions List(J_indrIf c4 Then excel4language.Re("solver_msg-Bt5Texta",=" >5:>bin)> newentrylef t & "&  TrimiRi > 1 2 ^exsearch(E, 1,; vSWFwrBoxe@wCvtraint_lw@?Countx'@3E"0 1 N3X+Item A:=EDG% ӿCI, Index,:=>RGNOn Error G oTo eAha n@urWith;dsv .Edit  _. }e? rzTR}shoq=o Z Show_$N o  !_ ^ cE,# P:auto_s?,lO? 9 @Oi\es .qButtP("TnE=Quadratic> ,[:+}F Oe!drv?._"ForpwardN?Cqaam/:/p, C4y nwp_& New&d!rjugatQD on>ll8&1mExit Sub mҫ:Msgr g߀, 32, , helpfia183P D]T߱Ss߱߱/(rOwnД01) .EditBoxes("Tolerance").Caption = CStr(5Convergej0.CheckoAssumAlValuejx0lOff -no`n_neg".show_iter%0auto_sc lOButtonan|tn ` Forward'New5End With7Exit Sub error trap: noproblem FalseRe_ Next   SoluName(}Attribute.VB_Pr@ocDataInvoke_Func" \n14"Set e@xcel4l@KuagzThisWorkbook.EBMacroSPheetVL ";s@Intl $AsDim i AsB eger)If Left(A@pplica .OptingSystem, 1)6W" Theyhelpfil5"xladdin.chm>EF[ :MS EXCEL HELvP sI@#Gs@.Count0a Msg@LV.BRMe("so_msg_150@T@y, 32, ,830@@bAAthe-nA ActivzeB4.aCsavesty$I,ReferASc `InS , "'") <> i9= 1 To 8n(G" Mid, i:':B""6(&jN0ot A Jnedj9_opdJC`q EX a.fix(3`rn>g s_sEs 'is cedure dou s .s inside its argnt.4Enecessary to avoid rehcor agA AsF @Ds w` `quote A ir ALs!!! atnewsbauBq6 w On E1 Go@@bhandla placeholder s(Len( +zC J .@;B ia!F&K @OChr(34)A E& $G eF!O '(= U? z7& 'BF#i5,i3ja /search(ent&, star5],1%eT0D^z2so2lD>`<=)` C <4mDialofg5mCu_dB0YLis@.aint_lP( ! p3f kq.4^ " > " Z((8+s) / 2),  ,{5  x %d$o%S -B#6*n0r;NlcF6+ 8o)))KOi@t vxlAq芇 #J#j{t`Dmula , xlR1C1qAU&w ?/ r^3y@Piic St`ub S`Load_ok|OOd>' user kCli"ok"akl! or q modelgm;gQgkj,  mc+_ans^w Kosaqvar_done1Boadummy, 0vbac` iobjo2Scre enUpdng"p&*NN 1 Then J1Exi t Sub En0d If Application.ScreenHUpdngFalse9Reset_all (InStr(ThisWorkbook.DialogSheets("Save _d Edit e f_are"a CapD, P"!")?0tvbacode loadfuncC& & "&B arg1:="Chr(34)haV@oPP0QR^RbR3ELS77Namefix``qOD8fFyyRecordMacro basicg:=>f On Error GoTo eobj_donAnˁvarF Each c In ßStylecheck###ʤgNot IsEmpty(c)Q=+@E ♄c.mula@=Tmainstri(a "." )I nternal(xlDecimalSeparatorc dum= J 5meEe"optLocal 2Mress i r_val0 ((џ&x(Bd ueof:(C?^70%7 a>, >AX>f >oo >ax>>d >q0>2j, >>$ "=2/"πO,O,O,r_+769b_ S 6A r_H166==k== /(/(/(='w==1?b="COUNTԘAy!ListQƮ OCBCҴ2 ThisWorkbook.DialogSheets("Solver_dP").OptionButtonCDblMLc.Formula, K+ 1)L' (LEnabledMTrueR?ActiveB~.N@U hel=͹'>th^e>d8"`D3BE@/If Left r7)"=COUNTA" TheӄOn Error GoTo loade0 d ApplicaA.BJenceStyle xlA~1W xkƟhkA`djustjsӪ49,!nh!9'Rm_)_#i'ContĒK.,A1R1C1nd IfvaonA5 W-srDefinebQ6QQQ4 Q__<_/KIN>TpA( [, 42VAR2c }EsETrimŞD6(- 6_R/(WPzLeW3!Dim ol(do 11) As ЦI  T k?kdkR"/ Next@/?xձ7Interntal(xlListSeparator)ko^7I2 ) +P S'?1   1k < 10 s @=  VG 0" Exit 3Hdummy4Vi62(` 1O`2Uc3c4c5c6]c7cR910tqGa NIK> NGoefeaddDropDowqcQo*Index1_ MMSUMMT 7b gȗrhxX`u`+ 5oR-c- 5 Prkbook.DialogSheets("add_d").Ed@itBoxe\lhs@Caption = Mid(mainstring, 6, InStr(2, ."<=") - 7) 0Else*ThisWo*rP+ 1, Le~nj[gZ33nd IfIf Not Valid_coCAqrt(Fac) ThenUeMsg excel4language.Re("solver_msg_6Text, 3, helpfile, 1830RE,@,b>Ao> 0-DropDown@OALis@tIndex3CR-@&LeftJ4) "=SUM"SV + 5v5\__\B<_oM+@U_ﱜP_ǥ"+++c+Vd+_M+^____jJp=INT ??.=>42TTޱint$}DLOL! RighP "))=1P ~߈)Y5 ?g/@).'?g+obin?9og10]- 1?=0 / 0 / ѕ11?PT q$ S#U!\ r_ F SrϗSϗϗϗ  C o@"=0)+(S$$$S %=*=~==o30//,?=;=_'_';%%o2%%%% %C% OyROOAo%l%2?ooM o 777og$}4Kc ThisWorkbook.DialogSheets("add_dD").Ed@itBoxe.lhs Caption = Mid(mainstring, 6, InStr(2, ."=") - 7) Else+0rP+ 1, Leni[gZ33nd IfIf Not Valid_cop!@rt(Fac) TheneMsg excel4language.Re("solver_msg_6Text, 3, helpfile, 1830RE,ֈ"""obj_done@TruͭO LNC> ApplicaA.ScreenUpdngExit Sub loaderror:s&pKpGoTo 2O varE>3/6G{G"2$"IYbY 3= I##caE \r_x Y & YBS !LS~1\Tem@p\VBE\DT.8exd`<".E .@`M žVBA_FuncqsGVBA_A@nunciUpn@p 2 QHB1BW!B,B#,+BThisWorkbookGA@Thi!Wkbok7@ 2 $q$"B#$ASolver1GB"Slvr61!2ٯ+! 2/2-zU/33j3U3p4U444*/,b<