1,2,3,4 , 45, 45, 100 160 . 1, 2, 3, 180, 90 170 . : 11≥100, 32≤200. :
1 | 2 | 3 | ||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
:
, .. ( ).
- :
- () - , (-) , : i, j. , - i bj. , ij .
B1 | B2 | B3 | ||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
S1=100*3+80*2+45*1+45*3+80*2=300+160+45+135+160=800(.),
S1- ;
Microsoft Excel:
1. , :
2. 18 =(14:17) 18:18;
3. 14 =(14:D14) 13:16;
4. 18 =(4:D7;14:D17);
5. → ;
6. :
$E$18,
: ,
$$14:$D$17,
:
$B$14:$D$17 =
$B$14:$E$17 >= 0 ,
$B$18:$D$18 <= $B$8:$D$8 1- .
$$14:$$17 = $$4:$$7 - 1- .
7. ;
8. ,
9. ʻ;
|
|
10. .
11. : 14:D17 , i- j- , E18 ( ) S=800 .