???????? ???? ??????? ??????? Solver ??????????? ??????

?????? ????????? ?????? ?????????
???? ???????: 82890 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? Microsoft Excel Solver ???????? "?????? ??????? ??????? ????" (GRG2) ?????? ????? ????. ?? ????? ??? ?????????? ?????? Lasdon ???? ?? ????? Texas ??? Austin Allan Waren ?? ????? ???? Cleveland.

????? ??? "?" ??? ???? ??????? ??????? simplex ?? ???? ??? ????????? ?????? ????? ????? ???? ??? John Watson ? Dan Fylstra ?? Frontline Systems, Inc.

??????? ????

?????? Microsoft Excel Solver ???????? ?????? ????? ???? ????? "plugging ??" ????????? ??? ??????? ??????? ??????? ?????? ??????? ????? ??????? ??? ?????? ????. ???? ?? ????? "?????." ??? ????? ????? ???? "??????" ??? ???? ?????? (???? ?? ??? ????? ??????? ??? ?????? ?? ??????? ??????? ??????? ?????) ? ???? Microsoft Excel Solver ??????? ????? ????????? ???? ??? ???????? ?????? ?????? ??? ??????? ??? ????? ?? ????????? ?????? ??????? ????? ????????? ???????.

?? ????? ??????? ???? ?????? ? ?????? ???? ????? (???? ???? ???? ????? ???) ??????? ??????? ???????. (????? ???? ?? ???? ???? ???? ??????? ????? ?? ??? ????? ???????. ??? ???? ?????? ?? ????? ??????? ?????? ??? derivatives ?????? ???? ?? ???? ??????? ?? ??????? ??? ?? ?? ??? ??????? ? ????? derivatives ?????? ????? ???? ???? ?????? ??????.

derivatives (?????????) ????? ???? ?? ???????? ??????? ?? Microsoft Excel Solver. ??? ???? ???? ??? ??? ????? ??????? ??????? ???????. ??? ???? ??????? ?? ???? ????? ?????? ???? ???? ?????? ????? ?? ?? ??????? ??? ???? ???? ??????? ????? ????? ??? ???? ? ????? ???? ?????? ??? ?????? ?? ??? ??? ??? Microsoft Excel Solver ??? ????? ???? ?????? ??????? ??????? ?????? ??? ??????? ?????? ???????. ????? ???? ?????? ????? ??? ?? ???? ????? ???? ?????? ??????? ??????? ??? ????? ?? ??????? ???????.

?????? ? ???????? Differencing

approximates Microsoft Excel Solver ?? derivatives ?????? ?? ???? ??? ?? ???? ???? ???? ??????? ?????? ?????? ???? ??????? ?? ?? ???? ????? ????? ????. ???? ??? ??????? ??? ???? ?? ????? ????. ????? ??????? Microsoft Excel Solver differencing ?????? ?? differencing ????? ??? ????? ?????? Derivatives ??? ???? ?????? Solver Options.

?????? differencing ?????? ???? ????? (???? ??? ??????? ?? ??? ??????? ??????? ???????) ????? ?????? ?? ???? ??????? ????? ???? ? ????? differencing ????? ?????? ?????? ?? ????????? ???????. differencing ????? ??? ???? ??? ??? ???? ????? ????? ????? ??? ???? ?????? ????? ????? ???? ?????? ?????? ???????? ????????. ?????? ????????? ?? ?????? differencing ? ??? ??? ?? ???? ???????.

???? ?? ??????? ??? ?? ????? ???? ??? ?? ????? ???? Microsoft Excel Solver ?? ????? ??? ????? ???? derivatives ????? ?? ???? ????????? ??????? ???? ??????? ????? ?? ????? ???? ???? ?????. ??? ????? ??????? ??? ????? ????? ??? ????? ??? ????? ???? ???????? Assume Linear Model ?? ???? ?????? Solver Options. ??? ?? ???? ??? ?????? ???? Microsoft Excel Solver ?? ?? ??????? ?? ???? ???? ???? ??????? ???? ????? ??????? ?????? ????.

??? ??? ???? ?? ????? ??? ???? ????, ?????? ?????? Assume Linear Model ??? ????? ????? ???? ?????? ???? ???? ???????? ???? (???????? ??? ??? ???? ?????). ??? downside ???? ? ??? ???? ??? ???? ?? ???? ?????? ??? ?????? ?? ??????? ??? ????.

??? ????? ?? ?? Microsoft Excel Solver ?????? ???? ??????? ??? ????? "?????? ??????? ?????" ???????? ????? ???? ???? ??? ???? ??? ??? ???? ????? ?? ??? truly ???????. ????? ?????? ????? ??? ???? ?????? ????? ??? ??????? ?? ????? ????? ???? ????????.

????? ?????? ?? ????? ????? ??? ????? ??? ?????? ???????? ??? ?????? ???? ?????? ?????. ?? ???? ??? ??????? amenable ?????? ????? ??? ?? ?????? "?????? ??????? ?????". ????? ????? ????? ????? ????. ????? "?????? ??????? ??????? ????" ???????? ?? ??? Microsoft Excel Solver ?????? ?????? ?? ??????? ?? ??? ????? ???? ?????? approximations ??? ?????? ??????? ?? ??? ??????? ?? ????? ????; ??? ??? ????? ?????? ??? approximations ??????.

???? optimality

??? ???? ????? (?? ????) ?????? ???? ???? ???? ??????? ?? ??????? ??? (?? ??) ????? ?? ??????? ??????? ??????? ????? ???? ???? derivatives ??????? ????? ???? ??? (??? ?????? ?? ?? ???? ???) ? ?? ?? ???? ????? ????? optimality ??????? (??? ?????? ?????? ????? ??? ?????? ?????? ?????) ?????? ?????? ??? ???? (?? ???) ????? ???????? ?????? ????.

?????? ?????? ???? ????

????? ??? ??????? ?????? ?? ???? ???? ?????? ??? ??? derivatives ??????? ????? ???? ???. ???? ????? ????? ?????? ?????? ?????? ?? ??? ??? ??????? ?????? ?? ?????? ???????? ?? ?????? ???? ??? ??????. ??? ??? ??????? ?? ?????? ????? ?? ??? ??????? ??????? ??????? ? ??? ???? ???????? ????????? ?? ??? Microsoft Excel Solver ??? ????? ??? ???? hilltop ?? ??? ???? ?????? ?? ???? ???????. ???? Microsoft Excel Solver ?? ????? ?? ????? ????? ?? ??? ??? ???? hilltop ????, ??? ???? ??????? ??? ????? ??????.

??????? ??????? ????? ?? optimum ???????? ?? ????? ????? ????? ???????. ??? ?? ???? ??????? ??????? reasoning ??? ??????? ?? ?? ???? experimentation ? ??? ???? ????? ??????? ?????? ??? ??? optimum ???????? ?? ???? Microsoft Excel Solver ?? ??? ??????? ??????? ??????? ???????? ???? ??? ???????. ????? ?? ???? ???? ??? ????? Microsoft Excel Solver ?? ??? ???? ??????, ?????? ??? ???? ???? ?? ???? ?? ???? ??????.

????? ?? ????????? ??? ????? ???? ???????? ?????? Solver ??? ???????:

   Frontline Systems
   P.O. Box 4288
   Incline Village, Nevada  89450-4288
   (702) 831-0300
				


?? ??? ????? ????????? ?? http://www.frontsys.com/

??? ????? ??????? ??? ??????? ???????? ????? ?? ??? ??????? ???????? ?? ?????? ??? ????? ?????? ?????. ??????? ??? ??????? ??? ???? ??????? ??? ?????. ???? Microsoft ?? ??? ????? ??? ??? ????????? ???? ???????.

??? ?????? Microsoft Excel Solver ?? ???? ????? 1990? 1991 ? 1992 ?????? ????? Frontline Systems, Inc. ???? ????? 1989 ??? Optimal ??????, Inc.

?????

"Microsoft Excel Solver ???? ??????" ???????? ??????? 3.0 ? ?????? 2

"Microsoft Excel Solver ???? ??????" ?? Windows ??????? 3.0 ? ?????? 2

???????

???? ???????: 82890 - ????? ??? ??????: 25/????/1427 - ??????: 1.4
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbinfo KB82890 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????82890

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com