Idea Transcript
. .
2017
519.86:656.2 65.050 23
: .
.
,
.
.-
.
,
» .
.
,
.
« ;
.
,
. . 23 : . 2017. – 76 .
/
.
.
. –
:
,
, « ». ,
-
, MS Excel 2010. , 38.03.02 «
».
,
-
. 519.86:656.2 65.050
© ©
. ., 2017 , 2017
2
..................................................................................................... 4 ........................................................................................................... 5
1. ........................................................................................... 8 2. .................................. 17 3.
... 22
4. .. 31 5. ................................................. 36 6. ........................................................................ 44 7. ............................................................................................... 51 8. ........................................................................ 60
..................................................................................................... 68 ........................................................................... 69 «
1.2» ....................................................... 70
«
3.3»........................................................ 73
3
«
»
»,
« .
–
, , -
Microsoft Excel 2010 8 . . . , ) Microsoft Excel. Microsoft Excel. . . . 4 8– 3 .
. 1–5 , , ( , 5 6
.
8 2 ,
. , .
4
. –
,
-
, , .
,
, . .
, . .
. : ; ; ,
.
,
, –
-
.
, (
). -
, .
, , Mathcad Microsoft Excel 2010, Microsoft Office.
Matlab, ,
,
, . , 1941 .
1930 . . , .
.
,
. ,
5
,
, .
( ,
, ,
). ,
,
, ,
,
.
xij ,
-
(
),
ij
: m
n
min .
c ij xij i 1 j 1
,
-
. , ,
.
, , 50–60-
XX . ,
.
.
.
.
-
[8]. , .
.
[7]. [3, 7],
[6]. , . . ,
. .
-
,
-
1909 . . , 6
,
,
–
,
-
. , (
)
. .
, -
Microsoft Excel 2010.
7
1
Microsoft Excel 2010 )
.
,
-
, . (
.
.
-
2–7). -
f ( x1 , x2 ,..., xn ) c1 x1 c2 x2 ... cn xn ( c j
R, j 1, 2, ..., n ),
x1 , x2 , ..., xn
(1.1) -
a11 x1 a12 x2 ... a1n xn
b1 ,
............................................. ak 1 x1 ak 2 x2 ... akn xn bk , ak
x
1,1 1
ak
x
1,2 2
... ak
x
bk 1 ,
1,n n
(1.2)
............................................. am1 x1 am 2 x2 ... amn xn (aij , bi
bm ,
R, i 1, 2, ..., m, j 1, 2, ..., n),
xj
0, j 1, 2, ..., n .
(1.1) ,
(1.3) .
(1.2), (1.2) –
,
-
. -
f ( x1 , x2 ,..., xn ) c1 x1 c2 x2 ... cn xn 8
max ,
(1.4)
f ( x1 , x2 ,..., xn ) c1 x1 c2 x2 ... cn xn .
min .
(1.5)
, ( f ( x1 , x2 ,..., xn ) , :
, ,
f ( x1 , x2 ,..., xn )
c1 x1 c2 x2 ... cn xn
max ), -
min .
, . (1.2), (1.3), (1.4)
(1.5), . -
,
:
f ( x1 , x2 ,..., xn ) c1 x1 c2 x2 ... cn xn
max (min),
a11 x1 a12 x2 ... a1n xn
b1 ,
a21 x1 a22 x2 ... a2 n xn
b2 ,
............................................. am1 x1 am 2 x2 ... amn xn
xj
bm ,
0, j 1, 2, ..., n . -
,
:
f ( x1 , x2 ,..., xn ) c1 x1 c2 x2 ... cn xn
max (min),
a11 x1 a12 x2 ... a1n xn
b1 ,
a21 x1 a22 x2 ... a2 n xn
b2 ,
............................................. am1 x1 am 2 x2 ... amn xn
xj
0, j 1, 2, ..., n .
( ( x1 , x2 , ..., xn ) , (1.2)
bm ,
) (1.3).
. 9
-
( x1* , x2* , ..., xn* ) , (1.1)
-
. –
. ,
(1.1)
(
)
-
, .
[8], .
,
,
, (
,
).
-
, ). , -
Microsoft Excel 2010. ,
Microsoft Excel 2010 ,
.
, -
. ,
. Excel
.
,
-
. 1.3. ,
-
Microsoft Excel. Excel. 1.1.
-
:
10
f ( x1 , x2 , x3 , x4 ) 130,5 x1 20 x2 1,8 x1 2 x2 6 x1 2 x2 4x
x3 4 x4 4 x3
x4
xj
max,
756, 450,
1,5 x2 10,4 x3 13 x4
1
56 x3 87,8 x4
89,
0, j 1, 2, 3, 4. .
1.1
. 1. 1.1):
.
1
1. x1 , x 2 , x 3 , x 4 . 3: 3
2: 2 .
-
,
1.1 (
2. ,
6: 6 F6 (B$3:E$3;B6:E6).
3 Excel F6
,
. 1.1).
$
, 3
-
.
0( ).
. 1.1.
1.1
. –
,
fx
11
-
.
,
,
-
: F6;
fx , ; ; ; 1 B6:E6
B$3:E$3,
2–
. 1.2).
. 1.2.
3.
10: 10
. 11-
10, .
, 12-
.
11 12 F10, F11 F12
, -
. F10
: (B$3:E$3;B10:E10); F10
,
. F12
.
,
-
. F10, F11
F11
0, (
.
-
. 1.1); -
F10, F11 ,
F12.
.
12
2-
.
, Microsoft Excel. , . 1.3):
1.
, , . . $F$6. , F6
.
2.
, .
3.
$B$3:$E$3, . ,
,
.
. 1.3.
1.1 13
4. : ( ); , , . . $F$10; «=»; , . . $H$10
. 1.4); , ;
OK
.
$F$10=$H$10, $F$11>=$H$11, $F$12