?????? Generalized ????? ????? ????????? ??????????

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

?? ????? ??

??????

Microsoft Excel ?????? nonlinear ???????? optimizing ?? ??? Generalized ????? ????????? (GRG2) ????????? ?? ????? ???? ??? ?? ?????????? ?? ???? Lasdon, ????????????? ?? Texas Austin ?? Allan Waren, Cleveland ????? ?? ????????????? ?? ?? ?????? ?????? ???? ??? ???

Linear ?? ???????? ???????? ?? ?? ???? ?? ????? ????, ???? ?????? ?? Dan Fylstra, Frontline ??????, Inc. ?? ?????? ???? ???? ??? ?? ?? ???? ?? ??? simplex ???? ?? ?????

???? ???????

Microsoft Excel ?????? iterative numerical ??????? ?? ?????? ???????? ???? ?? optimum ???? ??????? observing adjustable ?????? ?? ??? ??????? ??? "??? plugging" ?? ????? ???? ?? ?? ????? ???? ??? ???????? ??????? ?? "???????????." ??? ???? ?? ???? ??? ????? "??????? ?? ??????" approach (??????? ???????? ?? ??? ?? adjustable ???? ?? ?????? ?? ??????) ?? ???????? ???? ??? ?? ???? ??, ??????? Microsoft Excel ?????? ?? observed ?????? ?? ??????? analyses ?? ???? ?? ?? ???????? ?? ??? ??? ????? ??? varied, ??? ?? ?? ??????? ????? ?? ?????????? ???? ?? ????

?? ??????? ?????? ??? ?????? ?? optimum ???? ??? ?? ?????? (??????, ?? ?? ??????) adjustable ????? (??? ?????? ?? ???? derivative measures ?? ????????? ???? ???? ????? varied ?? ??? ???? ?? ??? ???? ??? ?? ???, ?? ?????? ?? ?? partial derivatives ???????? ?? ??? respect ?? ????? ????? ??? ?? ???????? ?? ???? ?? measuring ??; ?? ???, partial derivatives ?????? ?? ????????? ??? ??? ??? vector ????????

Derivatives (?? gradients) ??? Microsoft Excel ?????? iterative ??????? ??? ?? ?????????? ?????? ?????? ?? ???? adjustable ???? varied ???? ????? ?? ?? ??? ??? clues ?????? ????? ??? ?????? ?? ???, ??? optimum ???? ??? ???? ??? ?? ??? ??, ?? adjustable ?? ?? ???? ?? respect ?? ??? ???? partial derivative ?? ?? ???? ??????? ??????, ???? ???? partial derivative ????? ?? ???? ??, ?? Microsoft Excel ?????? ????? ?????? ????? ?? ???? ??????????? ???? adjustable ???? ?? ???? ???? ????????? partial derivative ??????? ?? ?? ??????? adjustable ???? ?? ??? ?????? ???? ??? varied ???? ??????

??? ?? ???? Differencing

Microsoft Excel ?????? approximates derivatives numerically ???????? adjustable ???? ?? ??? ?? ??? ???? ?? ???????? ???????? ???? ?? optimum ???? ?? ???????? ?? ?? observing ??????? ?? ????????? ?? derivative finite ???? ?????? ?? ??? ???? ??? Microsoft Excel ?????? ????? ?? ???? ?? ?? ??? differencing ?? ???? differencing, ?? ??? ??? Derivatives ????? ?? ?????? ?????? ????? ????? ?????? ????????? ????

??? ??? ????? (?? adjustable ???? ????? ?? ??? ??) derivative, ?? ?????? ?????? ??? ?? ??????? ?? ????? ??????? differencing ?? ????? compute ???? ?? ??? ??????? ????? ?? ??? ???? ?? ?? ??? differencing ?? ????? ???? ??? ???? differencing ?? ?? ???? ??? derivative ?? ????? rapidly ??????? ????? ?? ??, ????? ?? ???? recalculations ?? ???????? ??? ??????? ?????? ?? ??? differencing, ?? ????? ??????? ????????? ??? ???

Nonlinear ???????? ?? ??? ?? ??? ???? ????? ???????? ?? ?? ???? ?? ?? ???? ???; ??????????? derivatives recompute ???? ?? ??? Microsoft Excel ?????? ?? ???????? ???? ??, ?? ????????? ???? ?? ?????????? recalculating ?? ????? ?? ???? ?????? ?? ??? ?? ???? ???? ?? ??? ?? ??? ????? ??? brought ??? ?? ?????? ?????? ????? ????? ??? ??? ????? ???? ???????? ?? ?????? ??? ?? ?? ????? ?? ??? ? ????, Microsoft Excel ?????? ?????? ?? ?? ?? ???? ???, ????? ?? ??? ???????? ??? ?????? ???????

?? ?? ????? ??? ?? ??? ?????? ???? ??? ?? ????? ??, ????? ???? ???? ?????? ?? ????? ???? ??? ?????? ?????? ????????? ?? ?? ???? ?? ??? twenty ??? (???? ?? ?????????? ?? ????) ?? ?? ??????? ??????? Downside ?? ??, ???????? ?????????? ????? nonlinear ???, ?? ?? ?????? ????? ??, ??? ?? ??? ?????? ?? ?? ???

Microsoft Excel ?????? ????? ?????? ?? ???? ???? ?? ????? ???? ???? ???? ???? ????????????? ?? ??????????? ?? ????? ?? ??? ??, ?????? ?? ???? ?? ??? ????? ?????? ?????? truly ????? ??? ?? ??? ????? ?? ????? ???? ?? ??? ???? ?????? ?? ??? ?? ?????? ???? ??? ????? ?? ???? ????

?? ??????? ???????????? mostly ????? ????? ?? ??? ??? ????? nonlinear ????? ??? ??? ?? ???????? ?? ????? ???????????? ?? ????? ???? ???? ?????? ??????? ?? ??? amenable ???? ???? ?? nonlinear ???????????? ?? ????? ???? ?? ???????? ??? Generalized ????? ????????? ???? Microsoft Excel ?????? ?????? ????? ?? ?? ?????? ?? ???????? ?? ??? ??? ??? ???? ?? ??????? ?? ?????? ????????? ??? ????? ?? ?????? ??? ????? approximations ?????? ?????? ?? ??? ????? ????; ???????? ?????? ????? ???, ?? ?? approximations ??? ????

Optimality ??????

??????? ???? derivative (?? ?????????) optimum ???? ?? ???????? ?? ??? respect ?? (?? ????????) ?? ???? ?? measures adjustable ????, ?? ??? partial derivatives optimum ???? ?? ????? ?? (??????, ????????? ?? ????? vector), optimality ?? ??? ???? ???? ????????? ???? ??? ?? (??? ???????? ??????? ???? ????????? ?? ?? ??? ???? ?? ?????) ?????????? ?????? (?? ???????) ???? ???? optimum ???? ?? ??? ??????? ????

??????? ??? ?? ?????? Optimum ?????

??? ???????? ??? ???? partial derivatives optimum ???? ?? ????? ??? ?? ??????? ??? ?? optimum ????? ???? ??? ?????? ??? optimum ???? ?????? ?? ?? ????? ?? hills ?? ?? ????? ?? ????? ?? valleys ?????? ???? ??? ?? ???? ??? ?? adjustable ???? ????? ?? ??? ?? ??????? ????, ??????? ?? ????? Microsoft Excel ?????? ?? ???? ??? hilltop ?? valley ?? ??????? ????? ?? ??? ???? converge ???? ?? ??? tend ?????? ????? Microsoft Excel ?????? ??? ????????? ???? ?? ??? taller hilltop ??, ?????? ?? ???, ??? distance ??? ????? ?? ????? ???

?????? ?? ????? ????? ?? ???? ???? ?? ??? ??????? optimum ?????? ?? ??? ??????? ????? ??? ?? ?? ?????? ?? ???? ??? reasoning common sense ?? ?????? ?? ?? experimentation ?? ?????? ??, ?? ??????? ??????? ??? ?? ??????? optimum lies ?? ?? ??????? ??? ??? ?? adjustable ???? ????? ?? ??? Microsoft Excel ?????? ??????? ????????? ???? ????? ???????? ??? ??, ?? ?? ???? ??? Microsoft Excel ?????? ?? ????, widely separated ????? ?? ??????? ???? ?? ????? ???-?? ?????? ??????? ???

?????? ?? ?????? ?????? ????????? ?? ???? ??? ???? ??????? ?? ??? ?????? ????:

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


?? ?? ?? ??????? ??? ???? ??HTTP://www.frontsys.com/

???? ?????? ?????? ???? ??? ??? ???? ?? ??? ?? ???? ??? ????? ?????-???? ?????? ??????? ?????? ?? ?? ??? ?????? ??????? ?? ???? ??? ????? ???? ???????? ??? ?? ??? ????? ???? ??? Microsoft ?? ?????-???? ?????? ??????? ?? ??????? guarantees ???

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

??????

"Microsoft Excel ?????? ?????????? ????????????" Macintosh, 3.0, ??????? ?? ??? ????? 2

Windows, 3.0, ??????? ?? ??? "Microsoft Excel ?????? ?????????? ????????????" ????? 2

???

???? ID: 82890 - ????? ???????: 20 ??????? 2011 - ??????: 5.0
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 98 for Macintosh
??????: 
kbinfo kbmt KB82890 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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