. . 14
MS Excel
1. : Excel.
2.1. . , . .
, , :
(1)
F ;
j - ;
i- ;
i- j - ;
, j - .
2.1.1. . . , , , . .
.
, 1, 2, 3, 4, : , , . , , . , , , 1. .
1
1 | 2 | 3 | 4 | |||
= | max | |||||
<= | ||||||
<= | ||||||
<= |
1, 1
6 , , 1 6 x1 , x1 1. , , :
(2)
, .
(3)
. : (3).
-. Excel , . Excel , (3).
|
|
3.1. 1. , 1.
3.1.1. :
1. (.1).
2. 2. (.2).
- F6 = (B$3:E$3;B6:E6).
A | B | C | D | E | F | G | H | |
1 | 2 | 3 | 4 | |||||
= (B$3:E$3;B6:E6) | max | |||||||
= (B$3:E$3;B10:E10) | <= | |||||||
= (B$3:E$3;B11:E11) | <= | |||||||
= (B$3:E$3;B12:E12) | <= |
1.
2.
- 1 B$3:E$3. , Enter. B3 B$3, F4 .
- 2 B6:E6.
- . , F6 F10:F12.
- . > (. 3).
-
3.
- : : $F$6; : ;
: $B$3:$E$3.
- (. 4):
$B$3>=$B$4, $C$3>=$C$4, $D$3>=$D$4, $E$3>=$E$4, $F$10<=$H$10, $F$11<=$H$11, $F$12<=$H$12.
4.
3. 2.
2.
A | B | C | D | E | F | G | H | |
1 | 2 | 3 | 4 | |||||
max | ||||||||
<= | ||||||||
<= | ||||||||
<= |
|
|
2 , : 1 = 10, 2 = 0, 3 = 6, 4 = 0.
1320, : = 16, = 84, = 100. .
3.2. 2. .
3.2.1. :
.
5.
4 : IBM PC, MS Excel.
5.
1. .
2. , .
3. c .
4. .
5. .
6. :
1. ?
2. .
3. .
4. .
5. ?
6. ?
7. .
8. .
9. .
10. ?
11. .