()
... .
..
, 2002
1
Excel
, , . , , - . , . :
;
;
.
, , .
(MathCad, MatLab, Maple, Mathematica .), Excel. , , , , - .
- () Excel.
, , .
, , , .
Excel, .. . , :
- 1 ;
- 2 ( , ), .
- 3 .
|
|
1. ( )
, . ( / ) . , , . , . , .
, , , -. , (. [3]), , Excel
.
F xj, (), .
(), gi(xj)<=bi, ai<= gi(xj)<= bi.
() - kj<=xj<=vj.
, , .. , .
:
F=f(xj) = max (min, const)
<= bi..........................(1.1.1)
kj<=xj<=vj
, , . , .
, n m. :
- n<m - ;
- n=m -, ;
- n>m - , .