:
1. , , .
2. . .
3. ( ).
5.1
5.4 2:
(5.2)
:
1. . B5:B46 -1 1 ( ) 0,1. , . C4:AR4. 5.2 .
2. 6:47 2 3 (
3. 5: =(1-$B5*$B5-D$4*D$4)^(1/2)*(($A6;2)=0;1;-1)
4. 4:AR46 ( ). ( 5.3).
5.2
5.3
5.5.1 ?
5.5.2 ?
5.5.3 ?
 
| 
| ||
| 
| ||
|
| ||
| 
| ||
| 
| ||
| 
| ||
| 
| ||
|
| 
| ||
|
| 
| ||
|
|
| ||
|
|
| ||
|
|
| ||
|
|
6.
, , MSExcel.
, , , . : ; ; ;
. , ( ) , . .
|
|
|
MS Excel , .
:
F =11+22.+nxn ->max (min) (6.1)
a11x1 +a12x2+........+a1n xn=b1;
....................................................... (6.2)
an1xn +an2x2+...........+ann xn=bn;
a11x1 +a12x2+........+a1n xn <b1;
....................................................... (6.3)
an1xn +an2x2+...........+ann xn <bn;
:
( 6.1).
6.1-
| ( | F=f(xj)- max(min,const) J=1,n | , , . : , , . | |
| Gi(xj)<=(=;>=)bi, i=1,m, j=1,n. Xj=1,m<=k<=n ( ); | . . . | ||
| dj<=xj<=Dj,j=1,n | , . |
, 6.1, , .
, n m. n<m .
n>m. , n=m , .
, , :
- , :
- , , .
.
6.2.
6.2 -
| , ( ) | |
| ( , , ) , . | |
| , . , , . | |
| , . , , . |
|
|
|
6.1 :
: . . : I II. 7 9 . I II 1 6.3.
, 1 . , 3 . : 4000 .. 3000 .. , .
6.3 -
| , ( ) | , | ||
| I | |||
| II |
1. :
- : 1 , 2 .
- ( ). 1 2 :
F=4000*2+3000*1.
1 2 , F:
F=4000*2+3000*1. max.
- :
,
2>=0, 1>=0;
, :
2*2+3*1<=7,
3*2+2*1<=9.
:
1-2<=1,
1=<3.
:
-
F=4000*2+3000*1. max. (6.4)
-
2*2+3*1<=7,
3*2+2*1<=9, (6.5)
1-2<=1,
1=<3.
2>=0, 1>=0;
2. MSExcel : 1 2 3 4.
(6.4) 6 = 4000*4+3000*3.
(6.5) 8:D11 ( ).
3. : , .
6.2.1 ?
6.2.2 ?
6.2.3 .
6.2.4 ?
6.2.5 ?
6.2.6 .
6.2.7 ?
6.2.8 .
1-5 1-4, : , . 6.4.
6.4
| 1 | 2 | 3 | 4 | ||
, , : 1 60 .., 2 70 .., 3 120 .., 4 130 .. , .
|
|
|
6-10 1, 2, 3. , 450 2, 600 . 240000.. , . 6.5.
6.5
| , . .. | ||||
| 1 | 2 | 3 | ||
| , 3 | 1,5 | |||
| , | 1,5 | |||
| , . .. |
11-15 , . 6.6.
6.6
| 40/3 | ||||
| 20/3 | ||||
16-20 1 2 80 . 1 30 , 2 40 . 1 3 .., 2 5 .. 1 2 , 2 1 . , .
21-25 , 6.7, , .
6.7
7.
( ) .
() () . :
= (_; ; _; _);
= (_; ; _; _);
:
- _ , () ;
- , . () , /;
- _ (_) , () ;
- _ : .
|
|
|
7.1 : ,
:
( ) , 7.1.
D2 : = C2* (B2; $F$16:$B$20;2),
:
2 ( ), , $F$16:$B$20;
2 , ( , );
2 .
2 =2+D2.
.
.
7.1
7.2.1 ?
7.2.2 ?
7.2.3 ?
7.2.4 ?
7.2.5 ?
MS Excel. .
++ ( ).
1-5
| 1 . | ||||
| 1 . |
6-10
| / 1 | / | ||||
| / 1 | |
11-15
| 15.02.06 | ll | 46,9 | |||
| 13.03.06 | Kmobile | 46,9 | |||
| 21.03.06 | |||||
| 09.04.06 | Kcell | 46,9 | |||
| 30.04.06 | |||||
| 11.05.06 | |||||
| 20.05.06 | |||||
| 31.05.06 |
| Kcell | |
| Kmobile | |
16-20
| , | , | , /* | ||
| 29,6 | ||||
| , /* | |
| 0,2 | |
| 0,295 | |
| 0,31 | |
| 0,108 |
: Q=c*m*t, Q ,
= , m , t .
21-25
| / 1 | () | / | ||
| / 1 | |
|
|
|
1. .., .. /++ . -: , 2005.
2. . . Excel. .: , 2002.
3. .., .. . : , 2008
4. .., . . .: , 1970
