. - .
, . , .
, , .
. . .
[3,5].
, [7, .294], [8, .217], [2, .173]. [6].
[5, .137], [2, . 286].
[8].
1
: , , , , .
[1, 2.2]. () Microsoft Excel, .
:
a) , (), , ;
) , , ;
) , ;
) ( " ") , ;
) ( " ") , , .
:
a) ( " ");
) ( " ");
) ( " ").
1.1. :
1,8 1+2 2+ 34 4=756,
6 1+2 2+4 3 4 ≥450, (1.1)
4 11,5 2+10,4 3+13 4≤89,
j≥0, j=1,,4.
F()=130,5 1+20 2+56 3+87,8 4→ max; (1.2)
|
|
(1.1)(1,2) .1.1.
1.1. (1.1)(1,2) ( F6)
.1.1 Excel. , , (1.1) B3( 1), C3( 2), D3( 3), E3( 4), B6( 1=130,5), C6( 2=20), D6( 3=56), E6(c 4=87,8), H10(b 1=756), H11(b 2=450), H12(b 3=89) ..
F6, , , . (1.2)
Excel (. .1.1), (1.2) , (B3, C3, D3, E3), , (B6, C6, D6, E6). F6 "Enter"
=(B$3:E$3;B6:E6), (1.3)
$ 3 , Excel 3 ; : , , , (, B6:E6 B6, C6, D6 E6). 0 ( ) (. 1.2).
1.2. (1.1)(1,2) ( F6)
1. Excel " ", "" " f " . , , (1.3) :
F6;
" f ", " 1 2";
"" "";
"" ;
"" " 1" B$3:E$3, " 2" B6:E6 (.1.3);
" 1" " 2" "" (. .1.3), F6 , , 0 ( ).
1.3. " "
(1.1) , (B3, C3, D3, E3), , (B10, C10, D10, E10 1- ; B11, C11, D11, E11 2- B12, C12, D12, E12 3- ). , , . 1.
|
|
, (1.1)
1
Excel | |
1,8 1+2 2+ 34 4 3⋅10+3⋅10+D3⋅D10+3⋅10 | =(B$3:E$3;B10:E10) |
6 1+2 2+4 3 4 3⋅11+ 3⋅11+ D3⋅D11+3⋅11 | =(B$3:E$3;B11:E11) |
4 11,5 2+10,4 3+13 4 3⋅12+ 3⋅12+ D3⋅D12+3⋅12 | =(B$3:E$3;B12:E12) |
. 1, , (1.1), (1.3) F6 . , . . :
F6 F6 ( "Ctrl-Insert");
, F10, F11 F12, ( "Shift-Insert") ( , );
F10, F11 F12 0 ( ) (. .1.2).
" " (Solver Add-in), 2003 "". " " "" , " " ʻ. .
2007 Microsoft Office ( 2010 ), Excel. Excel. . , . : , .
, , .
2003 , 2007 2010 .
" " (. 1.4) :
" "(Set Target Cell);
$F$6 ;
, " : "(Equal to Max Value of:).
1.4. " " (1.1)(1,2)
" " " " (By Changing Cell) $B$3:$E$3. " " .
, (. . 1.1).
" "(Add), " " (Add Constraints) (. 1.5).
" "(Cell Reference) $B$3:$E$3. , .
|
|
≥.
" " (Subject to the Constraints) , $B$4:$E$4. .
1.5. (1.1)
≤, ≥, =
" " " ".
" " , $F$10. , .
(1.1) , =.
" " , $H$10.
: $F$11>=$H$11, $F$12<=$H$12.
OK.
" " (1.1)(1,2) .1.4. , , " " " ".
" ". " " " " (. 1.6).
1.6. ,
" " ( ), . , 32 767 ( 9 ).
" " . , 32 767.
" " , . 0 1. , . , , .
" " . .
" " .
" " -.
"OK".
" " " "(Solve).
" " , . 1.7, 1.8 1.9.
1.7. (Solver Found a Solution)
|
|
1.8.
1.9.
, . 1.8 1.9, , , Excel , Excel , .
" " .
, 0,000001 0,00001 ..
" " : " ", " ", " ". (. 1.4). ( , ) (Keep Solver Solution) "OK". (. 1.10).
1.10. (1.1)(1,2)