, , F4 ( F4 ), " ".
" " 2:2 ( ).
"", " " " F5, " " " <= ", 5.
"" F6<=H6, F7<=H7 B2>=B3,C2>=C3,D2>=D3 2>=E3 i>=0.
"" , " ".
.., .
" " "",
- 100 .( 2^15=32767 c.> 4 .), - 100( ), "" " ", , , :
:
D E F G H
1 1 2 3 4 .
2 10 0 6 0
3
4 . 60 70 120 130 1320 max
5 1 1 1 1 16 <= 16
6 6 5 4 1 84 <= 110
7 4 6 10 13 100 <= 100
.. (1,2,3,4)=(10,0,6,0)
- - 16 (1)
- - 84 (2)
- - 100 (3)
F 1320 .
: F 1320 .
1 3 10 6 , 3 4 ( ). (1) (3) , (2) 110-84=26 .
, , (1) (3) F, (2) - .
1,2 3 . 1=3=0, 2=26 . , 2 26 ., .
1 . .
2 Excel.
3
4
|
|
5 Excel.
1 , , ..
i=Ai+, ij=Bij+, Ci=Ci+.
2 . .
3 , 2 , 2 3.
4 . 1 . , 2 3 . 1 , 2 . 3 (. 2).
1 , 2 3 . Q .., V .. .
2
A1 | A2 | A3 | B1 | B2 | B3 | C1 | C2 | C3 | Q | V | |
|
|
1, ,
2
3
4
8
Excel
:
:
1
2
3 .
4 .
Excel :
- , , , ;
- , ;
- , Excel.
:
.
. , (, , , ), . .
, .