?>  Xy  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F?+0Workbook_VBA_PROJECT_CUR"b$?@9f$?VBA b$?e$?  !"#$%&')*+,-/0123456789:;<=>?@ABCDEFGIJKLMNOPQRSTUVWYZ[\]^_`bcdefghijklmnoprstuvwxyz{|}~8 ``i??3f3333f3ffff333ff333f33f33BBB\`aScenario_dialogh Save_dialogVoOptions_dialog Add_dialog Show_dialog" Finish_dialogS Solver_dialogSolver1Solver2Solver3Solver4^ VBA_FunctionsExcel4Functions Language  __Command`d,$@Tools Sol&ver...Stub---4Find feasible or optimal solution to worksheet model oftip.hlp!858 __DemandLoadadd_for:W! add_formula:Xadd_ref:Vaddarg1:addarg2:addarg3:Addfunc: Addin_Bar:# Addin_Command: Adjustablesanscount assumelinear assumenonnegBarOpen:CellTxt change_for:_$change_formula:` change_ref:^Cleanup<! CommandName: Constraint_Add Constraint_help Constraint_OK Constraint_sign Cont_button convergencedel_for:g! del_formula:hdel_ref:fDelfunc: derivatives dShowref:! Enginecount<" Engineresult< estimates Finish_cancel Finish_help   Worksheet"&Tools&WindowChart"&Tools&Window(Visual Basic Module"&Tools&WindowOM  SOLVER.ADDcell_ref  SOLVER.CHANGEcell_r  SOLVER.DELETEcell_r  SOLVER.FINISHkeep_ SOLVER.FINISH?keep_  SOLVER.GETtype_ SOLVER.LOA ) SOLVER.OKset_cell,max_min ) SOLVER.OK?set_cell,max_min }SOLVER.OPTIONSmaxtime,iterations,precision,assumelinear,stepthru,estim SOLVER SOLVER.SAV  SOLVER.SOLVEuser\p Jim Orlinool of Management Ba=  ThisWorkbook=J-&< X@"1Arial1Arial1Arial1Arial1Arial1Helv1Helv1Helv1Arial1Arial1 Helv1Tahoma"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)#,##0\ "DM";\-#,##0\ "DM"##,##0\ "DM";[Red]\-#,##0\ "DM"$#,##0.00\ "DM";\-#,##0.00\ "DM")$#,##0.00\ "DM";[Red]\-#,##0.00\ "DM">9_-* #,##0\ "DM"_-;\-* #,##0\ "DM"_-;_-* "-"\ "DM"_-;_-@_->9_-* #,##0\ _D_M_-;\-* #,##0\ _D_M_-;_-* "-"\ _D_M_-;_-@_-FA_-* #,##0.00\ "DM"_-;\-* #,##0.00\ "DM"_-;_-* "-"??\ "DM"_-;_-@_-FA_-* #,##0.00\ _D_M_-;\-* #,##0.00\ _D_M_-;_-* "-"??\ _D_M_-;_-@_-                + )   , *             0       0UU            8   8  8U  8U  0U  0UP  0U  0U@ @   8U@   8UP@  0U@  0UP@   8U@ @   (UP@   X    0U   0U   0UP   0UU     8   8   8   8P   8   8P   8P    8P   8P   8PP  Comma_SOLVERComma_SOLVER (2)Currency_SOLVERCurrency_SOLVER (2) Normal_SOLVERNormal_SOLVER (2)Finish_okGetDef:  inttolerance iterations keep_finalload_arg:P Load_helploadarg1:Loadfunc: Main_help Max_button_push max_min_valmaxtime MenuUpdate:y Min_button_push msg_branch: msg_incumb:! msg_setcell: msg_setup: msg_trial:Namecell:  Obj" ok?_changing:6" ok?_set_cell:5! ok_changing:.! ok_set_cell:-okarg1:okarg2:okarg3:okarg4:Okfunc:optarg1:optarg10:optarg11:optarg12:optarg2:optarg3:optarg4:optarg5:optarg6:optarg7:optarg8:optarg9: Option_cancel Option_help Option_OK! Optionsfunc:precison Push_add Push_change Push_close Push_delete Push_guess Push_load Push_options Push_reset Push_save Push_scenario relation reportarray Resetfunc:!  RestoreCall<   RestoreDLL:save_arg:Lsavearg1:Savefunc: SaveLoad"  SaveScen_Dlg:#scaling) Scenario_dialog;  Scenario_help Scenario_OK!  ScenDlgName: search Sheet sheet_nameShow: show_case% Show_dialog; Show_Dlg: show_ref ShowEcho: ShowForm:! showmsg; Showtext:SolvAdd SolvChange SolvDelete Solve_problem  SolveCall: SolveDLL: Solvefunc:T !SOLVER.ADD:SAdds constraint to a Solver modelmacrofun.hlp!3425d .SOLVER.CHANGE:[Changes existing constraints on a Solver modelmacrofun.hlp!3426f 0SOLVER.DELETE:cDeletes existing constraints from a Solver modelmacrofun.hlp!3427 WSOLVER.FINISH:kKeeps or discards final results, and creates reports after a successful Solver solutionmacrofun.hlp!3428t=SOLVER.FINISH?:oDisplays the Solver results dialog box; use after SolverSolvemacrofun.hlp!3428[ (SOLVER.GET:sReturns information about a Solver modelmacrofun.hlp!3429u ASOLVER.LOAD:OLoads a Solver model definition that is stored in worksheet cellsmacrofun.hlp!3430H SOLVER.OK:)Defines a Solver modelmacrofun.hlp!3431 ]SOLVER.OK?:1Displays the Solver dialog box; equivalent to choosing the Solver command from the Tools menumacrofun.hlp!3431Z#SOLVER.OPTIONS:9Sets calculation options for Solvermacrofun.hlp!3432b -SOLVER.RESET:wResets Solver options to their default valuesmacrofun.hlp!3433f 2SOLVER.SAVE:KSaves a Solver model definition in worksheet cellsmacrofun.hlp!3434J SOLVER.SOLVE:GStarts a solution runmacrofun.hlp!3435 solver_bin:$Solver_err_msg:$solver_grg_eng:) solver_int:# solver_lp_eng:*# solver_ls_eng:," Solver_msg_1:# Solver_msg_10:$Solver_msg_100:$Solver_msg_101:$Solver_msg_102:$Solver_msg_103:$Solver_msg_104:$Solver_msg_105:$Solver_msg_106:$Solver_msg_107:$Solver_msg_108:$Solver_msg_109:$solver_msg_10a:# Solver_msg_11:$Solver_msg_110:$Solver_msg_111:$Solver_msg_112:$Solver_msg_113:$Solver_msg_114:$Solver_msg_115:$Solver_msg_116:$Solver_msg_117:$Solver_msg_118:$Solver_msg_119:# Solver_msg_12:$Solver_msg_120:$Solver_msg_121:$Solver_msg_122:$Solver_msg_123:$Solver_msg_124:$Solver_msg_125:$Solver_msg_126:$Solver_msg_127:$Solver_msg_128:$Solver_msg_129:# Solver_msg_13:$Solver_msg_130:$Solver_msg_131:$$Solver_msg_132:%# Solver_msg_14:# Solver_msg_15:$solver_msg_150:$solver_msg_151:# Solver_msg_16:# Solver_msg_17:# Solver_msg_18:# Solver_msg_19:# solver_msg_1a:# solver_msg_1b:# solver_msg_1c:" Solver_msg_2:# Solver_msg_20:# Solver_msg_21:# Solver_msg_22:# Solver_msg_23:# Solver_msg_24: $solver_msg_24a:"$solver_msg_24b:## Solver_msg_25:!$solver_msg_25a:&$solver_msg_25b:'# Solver_msg_26:.# Solver_msg_27:/# Solver_msg_28:0# Solver_msg_29:2$Solver_msg_29a:3" Solver_msg_3:# Solver_msg_30:4# Solver_msg_31:5# Solver_msg_32:6# Solver_msg_33:7# Solver_msg_34:8# Solver_msg_35:9# Solver_msg_36::# Solver_msg_37:;# Solver_msg_38:<# Solver_msg_39:=# solver_msg_3a:" Solver_msg_4:# Solver_msg_40:># Solver_msg_41:?# Solver_msg_42:@# Solver_msg_43:A# Solver_msg_44:B# Solver_msg_45:E# Solver_msg_46:F$solver_msg_46a:H$solver_msg_46b:I# Solver_msg_47:K# Solver_msg_48:M# Solver_msg_49:N" Solver_msg_5: # Solver_msg_50:O# Solver_msg_51:P# Solver_msg_52:Q# Solver_msg_53:S# Solver_msg_54:T# Solver_msg_55:U# Solver_msg_56:V# Solver_msg_57:W# Solver_msg_58:X# Solver_msg_59:Y" Solver_msg_6: # Solver_msg_60:Z# Solver_msg_61:[# Solver_msg_62:]# Solver_msg_63:^# Solver_msg_64:_# Solver_msg_65:`# Solver_msg_66:a# Solver_msg_67:c# Solver_msg_68:d# Solver_msg_69:e# solver_msg_6b: # solver_msg_6c: " Solver_msg_7:# Solver_msg_70:f# Solver_msg_71:g# Solver_msg_72:h# Solver_msg_73:i# Solver_msg_74:j# Solver_msg_75:k# Solver_msg_76:l# Solver_msg_77:n# Solver_msg_78:o# Solver_msg_79:p# solver_msg_7a: " Solver_msg_8:# Solver_msg_80:r# Solver_msg_81:s# Solver_msg_82:t# Solver_msg_83:u# Solver_msg_84:v# Solver_msg_85:w# Solver_msg_86:x# Solver_msg_87:y# Solver_msg_88:z# Solver_msg_89:{" Solver_msg_9:# Solver_msg_90:|# Solver_msg_91:}# Solver_msg_92:~# Solver_msg_93:# Solver_msg_94:# Solver_msg_95:# Solver_msg_96:# Solver_msg_97:# Solver_msg_98:# Solver_msg_99:$solver_msg_bin:$solver_msg_int:# solver_msg_se:D solver_opt# solver_qp_eng:+" solver_table:  solver_tbl: solver_tbl:$ SolverMenu;# SolverMenubar:$SolverMenuitem: SolvFinishSolvFinishDialogSolvGetSolvLoadSolvOk SolvOkDialog SolvOptions SolvResetSolvSave SolvSolvestepthru Stop_button Stop_help TheCall:TheCall: tmp_Echo type_numunregi: user_finish Value_button_push value_ofH b'  3  @@  Start of solvercallitemxywidthheighttext init/resultxlmain8.hlp!1836Show Trial Solution>Solver paused, current solution values displayed on worksheet.ContinueS&top&Help&Save Scenario...xlmain8.hlp!1835 Save ScenarioScenario Name:OKCancelQRed box is solver_tbl. Sensitivity information gets stored starting at that point$The following cell contains dShowref'General validation and warning messagesFActive document is not a worksheet, is protected or is in shared mode.Solver32.dll is unavailable -- you will be able to define and edit Solver models, but not actually solve them. To fix this, please use Excel setup to reinstall Solver.*Cannot do this command in Group Edit mode./Cannot do this command in an embedded workbook.5Find feasible or optimal solution to worksheet model.1Cannot guess Adjustable Cells without a Set Cell.-Adjustable Cells must be on the active sheet.ESet Cell must have precedents containing numbers on the active sheet.&Reset previous Solver cell selections?'Load Model: Invalid Constraint Formula. Load Model: Invalid Target Cell.$Load Model: Invalid Adjustable Cell.+Set Target Cell contents must be a formula.:Set Target Cell must be a single cell on the active sheet.#Max Time must be a positive number.%Iterations must be a positive number.*Precision must be a small positive number.+Convergence must be a small postive number.5Integer Tolerance must be a number between 0 and 100.)Integer Cutoff must be blank or a number.6Coefficient tolerance must be a small positive number.3Solution tolerance must be a small positive number.0Pivot tolerance must be a small positive number.7Reduced Cost tolerance must be a small positive number.-Reset all Solver options and cell selections?Problem to solve not specified.Too many adjustable cells.6Cell Reference box is empty or contents are not valid.OConstraint must be a number, simple reference, or formula with a numeric value.9Unequal number of cells in Cell Reference and Constraint.EInteger constraint Cell Reference must include only Adjustable Cells.DBinary constraint Cell Reference must include only Adjustable Cells.PToo many adjustable cells. A scenario can have no more than 32 adjustable cells.Scenario Name cannot be empty.Scenario Name must be unique.)Reference not large enough to hold model;cells are required.No constraint to change.No constraint to delete.Different engine listingsStandard GRG NonlinearStandard Simplex LPStandard LP/QuadraticLarge-Scale LP Solver9Names of different reports as listed in the finish dialogAnswer SensitivityLimits$Different messages for finish dialogRSolver found a solution. All constraints and optimality conditions are satisfied.cSolver found a solution within tolerance. All constraints and optimality conditions are satisfied.MSolver has converged to the current solution. All constraints are satisfied.KSolver cannot improve the current solution. All constraints are satisfied.9Stop chosen when the maximum iteration limit was reached.$The Set Cell values do not converge.*Solver could not find a feasible solution.!Solver stopped at user's request.8The conditions for Assume LP/QP Model are not satisfied.9The conditions for Assume Linear Model are not satisfied..The problem is too large for Solver to handle.ASolver encountered an error value in a target or constraint cell.4Stop chosen when the maximum time limit was reached.:There is not enough memory available to solve the problem.=Another Excel instance is using SOLVER.DLL. Try again later.HError in model. Please verify that all cells and constraints are valid./An error occurred. Please contact Tech Support.$Dialog titles for Load or Save ModelCannot save model in this area. Load Model Save Model+Dialog titles for Add and Change constraintAdd ConstraintChange ConstraintReport Messages=Internal Error: Can't find report information on macro sheet.Answer Report MessagesForming Answer Report...Microsoft Excel Answer Report Worksheet:Report Created:Target Cell SectionMaxMinValue Of Target CellNONECellNameOriginal Value Final ValueAdjustable Cells SectionAdjustable CellsConstraints Section Constraints Cell ValueFormulaStatusSlack Not BindingBinding$Reports terminated at user's requestSensitivity Report Messages^Sensitivity Report and Limits Report are not meaningful for problems with integer constraints.Forming Sensitivity Report...Sensitivity ReportFinalValueReducedCost Objective Coefficient AllowableIncreaseDecreaseGradientShadowPrice Constraint R.H. SideLagrange MultiplierLimits Report MessagesForming Limits Report... Limits ReportTargetAdjustable Section AdjustableLowerLimitResultUpperStatus Bar MessagesSetting Up Problem...Trial Solution:Branch: Incumbent: Set Cell:Interruption Messages4The maximum time limit was reached; continue anyway?9The maximum iteration limit was reached; continue anyway?General Error MessageQSolver: An unexpected internal error occurred, or available memory was exhausted.;Next 5 column entrees determine placing of Solver on menu. Sol&ver...Main4Find feasible or optimal solution to worksheet model oftip.hlp!858No active document available.Constraint is too long.integerbinaryintbinfNext entries determine the code that is recorded. Should be consistent with localised function names. SolverAdd SolverDelete SolverLoadSolverOk SolverOptions SolverReset SolverSave SolverSolveCellRefRelation FormulaTextLoadAreaSetCell MaxMinValValueOfByChangeMaxTime Iterations Precision AssumeLinearStepThru Estimates Derivatives SearchOption IntToleranceScaling Convergence AssumeNonNegSaveArea,Next item is the menu name: Tools in EnglishToolsIE EW@Fh]G _sI6lJrkL.RSN 4AO P R TTUtlVVLkxW;RW*XXqYlZ/ [[,\R\M]~w?RT04h   DIr0  6+T6?w4[w S0t0=wh?wh46? +w46+6?wvalue_oftton_push#4?\Lw@#t ?0H#p,wH#nw4h  6 RT06 {wRT0x X8Pw\w)w@P|0E`E~02T0pEEu0!T0|0E(!0@EZ0@=Z04F0@F` 0=EStart of solvercallitemxywidthheighttext init/resultxlmain8.hlp!1836Show Tria   b  dMbP?_*+%i&A Page &P"P??x U<$(  r  0@A@ 5]@ E  <Save Scenario<   s FA@Scenario_name 3 ]& `x E    D?OK_button]*@ E G X#o $ <OK< ff  c $,?&], E $<Cancel< ll  s *?(3], E Gx9n $H<Help< rr  0p@A@) ]@pP E <Scenario Name: < >"@   yi  dMbP?_*+%i&A Page &P"P??U2 (  r  0P@A@ 1]@PE  < Load Model< rr  0@A@# ]@`E <Select Model Area: < ~~  s <A@The_area 0 ]& `E    D?OK_button]*E8G P#j $ <OK< ff  c $$?$]$E $<Cancel< ll  s *?&0],0ELGp9. $H<Help< >"@   #p  dMbP?_*+%i&A Page &P"P??9U0 & (   r  0?@A@I,]@?(E <Solver Options< rr  0<@A@# ] @<E T < Max Time:< ~~  s <A@Max_time&+ ]& `xE <100< rr  0@A@ $] @8E I < Iterations:< ~~  s <TA@Max_iter& -]& `TE <100< rr  0@A@$] @E P < Precision:<   s >A@Precision&3]& `H E < 0.000001< b#rr  0X@A@%] @X!E e < Tolerance:<   s >A@Tolerance&2]& `!E <5<  rr & 0 @A@&]&@ p"E v <Convergence: <  % s BpA@Convergence&3]& %`p#E <0.001< '  P?@A@Assume0I]6 ?#E MM "<Assume Linear Model<  $ R(@A@non_neg0"%]6 $($%E gg "<Assume Non-Negative<   T@A@auto_scl1II]6 l&E UU "<Use Automatic Scaling<   V?@A@Show_iter1H"%]6 ?'E RR "<Show Iteration Results< xx  6@A @#(+]$@@(E  < Estimates<   R@A@Tangent$&'%]H )E a ?a "<Tangent<   V@A@Quadratic'&*%]H *E Q |Q " < Quadratic< xx  6pA @)#7+]$@p4,E  < Derivatives<   R?@A@Forward*$5'%]H ?,E F F "<Forward<   R@@A@Central*'5*%]H @$.E C C "<Central< xx  6A @8#F+]$@l/E <Search<   P@A@Newton9$E'%]H 0E N DN "<Newton<   Vp@A@Conjugate9'E*%]H p\1E o ?o " < Conjugate<   D ?OK_button8G ]* 2EdG #U $ <OK< ll  s *?8 G]*L3ExG X#S $<Cancel< ll  s *d?8G]*d3EG #] $L <Load Model...< ll  s *#?8G]*#4EG #` $S <Save Model...< ll  s *#?8G]* #D5EG \##T $H<Help< rr  0c@A@,5 ]@c5E <seconds< rr # 0|c@A@26]#@|c6E <% <   >"@     dMbP?_*+%i&A Page &P"P??U @ (  r  0\?@A@'["]@\?L;E <Add Constraint< rr  0?@A@(:]@?;E R<Cell Reference:< tt  s 2 ?A@lhs(<]& ` ?=intbinrr  0P?@A@EIIUI]@P?=E C < Constraint:< tt   s 2?A@rhsEYn]& `?>E    DP??Ok_button(2!]*P?"@     dMbP?_*+%i&A Page &P"P??#ULP4(  r  0?@A@ A]@?CE <Show Trial Solution<   P\?@A@Show_message3 ]@\?@DE ><?Solver paused, current solution values displayed on worksheet.< >||  :?? Cont5? ]*?DEG ?# $ < Continue< ||  :?? Stop5 ?]*?EE,G T?#B $ t<Stop< ll  s *`??5?]*`?8FE@G ?#C $H<Help< ll  s * ??!]* ?FETG ?#a $S<Save Scenario...< >"@     dMbP?_*+%i&A Page &P"P??#aU` (  r  0?@A@ I]@?KE <Solver Results<   RL?@A@Final_message7 ]@L?@LE Q<RSolver found a solution. All constraints and optimality conditions are satisfied< Q  ^?@A@Keep_solution&I]H ?LE K ?K "<Keep Solver Solution<   `,?@A@Restore_values'I]H ,?0NE O ?O "<Restore Original Values< rr   0|?@A@7 B ] @|?xOE R<Reports<    F@AReports7 GI]_  PE Answer SensitivityLimitsll  s *??]*?PEhG p?#( $ <OK< ll  s *|??']*|?pQE|G ?#& $<Cancel< xx  6?A @)]$@?RE  ll   s *??):]* ?REG (?#a $S<Save Scenario...< T?ll   s *4??<G]* 4?hSEG ?#' $H<Help< >"@     dMbP?_*+%i&A Page &P"P??#'U p (  r  0?@A@N)]@? XE <Solver Parameters< rr  0h?@A@  ]@h?XE e<Set Target Cell:<   P?A@Optimum_Cell * ]6 `?pYEG ?#=     ^?@A@Max_button !%]X ?ZEG M ? @?#2M  "<Max<    ^D?@A@Min_button! (%]X D?`[EG n ? ?#6n  "<Min<    b?@A@Value_button) 5%]X ?\EG V @? ?#JV  " < Value of:< ~~  s <8?A@dValueOf5 ?]& `8?]E <0< xx  6?A @B(]$@?^EB <By Changing Cells:<   X$?A@"Adjustable_Cells4]6 `$?@_EG ?#   ll  s *??6@]*?_EG `?#\ $G<Guess< xx  60?A @B(]$@0?`Eu <Subject to the Constraints:<   V@A Constraint_list4&I]<8aE ll  s * ?6@]* aE0G ?#X $A<Add< ll  s *?6@!]*bEDG l#Y $C<Change< ll  s *x?6"@%]*x0cEXG #[ $D<Delete< ll  s *$?C M ]*$cElG # $ S<Solve< ll  s * ?CM], dEGp9Z $ <Close< ll  s *?CM]*(eEG H#^ $O<Options< ll  s *T?C M#]*TeEG #_ $R < Reset All< ll  s *?C$M']*xfEG #1 $H<Help< rr  0`@A@ ]@` gE  < Equal To:< >"@  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P  &A Page &P"PFinue??> P @  @xBtra  dMbP?_*+%&f Page &pMHP LaserJet III  dLg_);N}w;}d)A"d??U} I} $}  } } } } m} } I} Ix  T0          0 :0 E E E   E0 0EEE0E}E 0E|0ET & """ 'BT"""" "" "( CB    ! ! ! ! (BT 8 99:P{@:S@ : ~ ;@ "( CDAB$<@$@$@%s@%@@ % = %(@#D Al<?$t@$@%W@% % = (A<@$t@$<@%W@% % = ) #DB7<8@$t@$J@%W@% % = >@? @?J@@b@@ @A ' * CellTxtBQ  """"% ( SheetBQ 8 99 :s@:Q@ :~ ;@1 ( CA B7B <@$$@$@ %% % =$ ( CCrB <@$$@$3@%q@ %%=< )&C)A # #)"B7 <?$$@$E@%V@ % % =<@$[@$E@%V@% %=)+ show_caseBQ>8@?i@?E@@V@@ @ A.BT$$$%%%%,B`#, C"B=,'@=C"(Cu)#zB`,&,@CzA&B7,A/,#|#{CuBAl 2,B+,tmp_Echo(ABX 0,CFA& BWB,@#vA0,CFA& BWB0,CwA& B7B1,Cw  B7B1, Cw  B7BD l2BpwkqXGwwZNq8!'A*A94"4>? T0!"#$%&' (0):*E+E,E-.E/ 0E01EE23045E67} 8E09:E;|0<E=>T?! ,! #pAl +!,"tmp_Echo(ABX!0",#CFA& BWB"#,$#mA#0$,%CFA& BWB$2%,&CkA& #yA5B%&&,'#o9pB&'-)#yA5'(()4*set_cellBQ+*5+ max_min_valBQ(+5,value_ofBQ+,5- by_changingBQ8-5p D."set_cellBkB=Bx$A$8;.5| D/% by_changingBkB=Bx $A$1:$A$7;/61%#;#A#3@#K#@"B7(142set_cellBQ+253 max_min_valBQ(354value_ofBQ+455 by_changingBQ8556"set_cellBkB=Bx;657% by_changingBkB=Bx?769)#<#?#3@#K@#>"B7'94:maxtimeBQ*:5; iterationsBQ);5< precisionBQ,<5= assumelinearBQ(=5>stepthruBQ)>5? estimatesBQ+?5@ derivativesBQDwl/9>,>@4, ,/,/GO?,/,/<?C+.-0,-@T0ABCDE F0GHI: JE0KELEM NE0OPEQEE!R0S0TUEVW}XEY ZE0[|0\E]^T_&@5AsearchBQ,A5B inttoleranceBQ'B5CscalingBQ+C5D convergenceBQ,D5E assumenonnegBQsE6G]#=@#4@#+@#W@##A#%#!#q#*@#l##" B7+G4H user_finishBQ(H5Ishow_refBQ-I6K#@#I#x"B7)K4L save_areaBQ9L5 DM# save_areaBkB=Bx "$H$5:$H$60"(M6O#?#g"B7)O4P load_areaBQ9P5 DQ# load_areaBkB=Bx#N/A(Q6S#:#-"B7(S4Tcell_refBQ(T5UrelationBQ/U5VformulaBQ8V5 DW"cell_refBkB=Bx#N/A:W5 DX$formulaBk"Bx=Bx12.45.X5 DYCB=Bx12.456Y6[ #}##b#@"B7([4\cell_refBQ(\5]relationBQ/]5^formulaBQ8^5 D_"cell_refBkB=Bx#N/A:_5 D`$formulaBk"Bx=Bx12.45Dal*0+/0w/,1-P,-H,,,3GJ>:,,3G`T0a b0cdefghi: jE0kElEm nE0opEqEE!r0s0tuE v0w}0xE0yzE{|0|E}~T.`5 DaCB=Bx12.452a6c#~##b#"B7(c4dcell_refBQ(d5erelationBQ/e5fformulaBQ8f5 Dg"cell_refBkB=Bx#N/A:g5 Dh$formulaBk"Bx=Bx12.45.h5 DiCB=Bx12.45:i6k$##@#b@#"B7*k4l keep_finalBQ,l5m report_array@BQ-m6o#7#,#c"B7*o4p keep_finalBQ,p5q report_array@BQ-q6s#8#,#c"B7(s4ttype_numBQ*t5u sheet_nameBQ-u6w#9#G#s"B7#w7y #>"B7'y0*z C5C6B%z,{C5AA&B+{,|@ C5C6B0|,(@}@ #5#4#5B},~A1~,(@@ #5#4---B,ADl>6,,3GJ>>.01.01,.1'+)/45T0 0  :0EEE{(e $BBABsM :SOLVER \SOLVER32@B@SolveIEB(m $BBABsM :SOLVER \SOLVER32@B@ SolveRestoreAIRB1B7+CA.CfA/B7 " """" uT0vwuvw Z( >@????m|0|E}~TLHT070<!0LHTt0y0?LHT0}0t}w0}h3 qq      @  ,k{E g  dMbP?_*+%&A Page &P"PD??U} #DT0  T0   TT0TT0}|0ET #           ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5D@l T0!"#$%&'()*T0+,-T.T/0T01T2304567}89:;|0<E=>T? 6 !7 "8 #9 $: %; &< '= (#> )? *@ +A ,B -#C .D /E 0F 1#G 2H 3I 4J 5K 6L 7M 8N 9O :P ;Q <R =S >T ?UD@l@T0ABCDEFGHIJT0KLMTNTO0TPQTRS0TUVW}XYZ[|0\E]^T_ @V AW BX C#Y D3Z E[ F\ G#] H^ I_ J#` Ka L#b Mc Nd Oe Pf Qg R#h Si Tj Uk Vl Wm Xn Yo Zp [q \#r ]s ^n _oD@l`T0abcdefghijT0klmTnTo0TpqTrs0tuvw}xyz{|0|E}~T `p aq b#t cu dn eo fv gw hx iy jz k{ l| m#} n~ o p q#r rs sn to u v w x y z { | } ~ D@lT0T0TT0TT0}|0ET  #t u n o             m #   #h n  o  n #  o  D@lT0T0TT0TT0}|0ET        m* #      #    #  #           #  Drl BT0T0TT0TT0}|0E                            # >0>@ Solver2 x9__SRP_3__SRP_2 Solver34nM ME  " (8@HP %X&h " %" " 8 ( "0 48px "   "  " $BW %`>qp   "   -0".P <qx )   )  .Y( <qX )  2o 0j""@hVp ` 8@ HPX`<qhVx "  8HP "X $`  "    "  0 "8 @ `x " 0 B]C( D@ >NX 4 Bx  4 8 @ >qH   "   "      0 P X  % |      H Q  @j (      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~xhh (04<@Ldlpx|Vk@2NNl@> L*LLLLL"   0@4B8?:D<F@?DHFJHL J 8 L b `H 2k && 14<\d^f`hd l(!` xk! 14n"` h4oh "I   14phrj@ltpvt>xD|xFz?|X #`pzk#  14 X$` |k$ 14 %`k% 14 &`Hk&  14h'`P>k8'I  14 (`k( 14 )`Xk)  14 X*``hk* 14 +`k+  14 ,`Hk, ! 14 H-`P`k- + 14T.`X?0/ . 5I  14(/`8@0/ / >I  14(0`@8Boh 0;;GI  14Z??? ??H1``Fkh 1((I I  14?rtF? 2` Tk 2 I I I I I (I$ HI( hI, I0 I4 I8 I< ZH0 8P@ HP ((0H0h ( (@  X0 ( X$ 14$ 14xp(8zP:@l @\ @X @(H @XD @4 @$ @@ @ @ h\>6@@ @ @ p(@XHP:8>@px @h @d @`T @D @4 @0 @x, @ @0 @ p(6@@ @ @ v@ X v@ p@( @ @@ (@ y0! !!8!!"PN:8@P!x @h!h @"d @"T @!D @!4 @@0 @, @! @@" @(" @ @X" @p" @" @ @ !>6(!  h$# $##p#%#@l $p#8>6@#h @P$X @T p@P `#@8$@ @$0 @$ @(% @$ @$ @$ X@$ @% @ @X% @@% @ @p% @% (@%t #(@@d  *&'&&(*0(Fb@&x @v @&d 0@'` @'P @0'@ @'0 @H' @x' p&N2468@' @ (@( @h( ((`$(@( @ @( @ `3 `'8>6@ h  P ,+,+(-0,2H,PN:R@+x @+h @1d @@-T @,D @,4 @X,2 p,0,L@0 Z-X,Lp@, X@, @, (@, @- @p- +T8Z\@ @X- @- @- @ X,@- @. -\P>@. @(.p @@.` @X.P @@p.@ @.0 @. @. @. @/ (@`/ @0/ @H/ @x/ @/ @/ @/ @/p @0` @/P @P0@ @ 00 @80 @p0 @0 @0 `@0 @1 @ @01 @H1 @`1 @x1 @p @1l @1h @d -6 @xh3283324N\8>@3x @ 3h @d @3T @P3D @34 @0 @3 @3 @4 @(4 @) @@4 @p4 @X4 @ 4@ 2685@5@(phP6555X75<@5X=X5@nl 5@58>6P:@5h @6X @7T @P `<5 @ 6@ @60 @86 @h6 @H<  @6 @6 @6 @7 \@6 @6 @(7 @7 @@7| @7l @7h h5~T\@d @0;` @7P @8@ @80 @08 @8 @H8 @`8 @x8 @8 @8 @8 @8 @P9 @9 @ 9p @89` @h9P @9@ @90 @9 @9 @@: @9 @9 @: @(: @X: @p: @: @ @:p N@:` @:P @:@ @;0 @; @ @H; @x; p7.*:PN@< ff(f`@0< @ @`< @x< @ @< <<n@ <<n>6<sf``;\4:8>6@>l @@=\ (@(?X @>H 8>===@?@D @>4 @?$ @ p@ @ = G?h@P@8@? @@`Tz ?58@:z @h @@X @@T p@@D @@ @0 hAAAAhAAA`z hA>A:l @h h@AX P@BT @ BD @@ @0 pBhC0CCHCEEBhDB@l XEBG P@xC\ @EX @`CH @C8 @C( @C @ @C @D @8D @ D @PD @D @D C\:(@D @D @Dt @Dd @(ET @ED @@E4 @$ XE@ EE^@\ @E @ _ EE^En @ @ @l  @FF@\  H(F 0(FHGG0G`GHFHF\P:@xGX @GH @D @XH4 @0 @G @G @G @G @ @0H HHH@H/ pH0H@ H0H@H HH@/ HHHG8>6IIII@x @t @Id @JT @(JD @@J4 @XJ$ @pJ @J @J @J @J @J @K @K @0K @HK @`Kt @xKd @KT @KD @K4 @K$ @K @L @ L @8L @PL @hL @L @L @L @L @t MMMM@x @t @Md @MT @ND @(N4 @@N$ @XN @pN @N @N @N @N @N @O @O @0O @HOt @`Od @xOT @OD @O4 @O$ @O @O @P @ P @8P @PP @hP @P @P @P @t hQ" R"R(*S( U`TTxTHT8>6(@Tx @Th @d @TT @TD @4 @U$ @8U @ @PU @ V VV8VhV8WVF(8>6N@PVt @Vd @W` @\ `hV8@VL @W< @V, @W @ @ W @PW VP:\`b@pW @W @W @W @ @ @ X(*`Y(HZ0ZZ(j@l @\ [([(8`P ^\\\@``_a_P:8>6@\ @\ @H] @] @] @] @0] @`] @x] @] @] @] @8^ @h^t @]d @^T @ ^D @P^4 @_0 @^ @^ @`  @^ @`_ p\(\N@_ @0_ @H_ @ @ @x_ @_ @_ @t @_p `_@l_ `_@`h ^@X`d @p`` @\ @X (a`@`T @`P @`L @H (`z_Cba`bb8baPb(8\>6@ bx @bh @d @` `8bT@xbP @b@ @b0 Z*@, @b @ @ (dcdcc8>6@cx @dh @d @@dT @P @Xd@ @pd0 @d @ @ fpeeeefe(8@ex @fh @d @(f` `@fe@eP @Pf@ @0 @, `(f@hf @f @f @ @ Xe>6 gggghhh@@hl 8>6@g\ @phX @T @hD @(h4 @Xh$ @h @xi @ i @h `hhT@ `h\g@i @8i @Pi @i @ @ @ j`jjxjHj8>6@jx @jh @d @jT @kD @4 @0 @ k @8k @Pk @ l ll8ll8>6@Plx @hlh @d @lT @lD @4 @0 @l @l @m @ nm@nmm8>6@nx @(nh @pnd @XnT @nD @4 @n0 @, @n @ @n @o @ o( 0qppppppp:&8>6@d @qT @HqD @p@ qp@<_ qpp@8 @`q( @xq @q @ @ rxrrr`r>86@rx @t @p @r` @8sP @s@ @ s0 @Ps @ @ tuHtt`tt0t t@,l t8>6N:@xth @tX @huT @tD @t4 @Pu$ @t @ u @ @8u @u @ @u @u @x @u @u @u @v @(vt @@vd @XvT @pvD @v4 @v$ @v @v @v @w @w @0w @Hw @`w @xw @w @wt @wd @wT @wD @ x4 @Px0 @8x @hx @ @ z8yyyPy y8>6@hyx @yh @d @yT @yD @z4 @Hz$  z y @0z @z @`z @xz @z @z @ @ @ |{{{{n8>6@h|l @{\ @8|L @|H @D @@ @P|0 @| @ @ P}}h}}8}}8>6@}x @}h @~d @~T @}D @h~4 @$ }@ ~ @8~ @P~ @ @~ @~ @~ @~ @~ @ @( @@| @Xl @\ @pL @< @, @ @ @ p`n8>6@l @?\ @L @H @@D @04 @$  x H @ @ @? @ @( @ @ @ @X @ @ pX@((8>6@l @\ @X @T @D @?4 @$ @ @ ?8>6@x @0h @d @HT @D @`4 @x$ @ @ @ x?`>86@x @t @p @` @8P @@ @ 0 @P @ @ ? h8>86@Px @h @d @T @D @4 @$ @  @ @ ?(>86@x @t @p @@` @P @X@ @p0 @ @ @ p?X>86@x @t @p @` @0P @@ @0 @H @ @ 0`x>86@Hx @t @p @` @?P @@ @ 0 @ @ @ H(h?H@l @\ @L @< @0, @` 8>6@x @ @ @? @ @P @ @ @8 @| @hl @\ @X @T Ho