, - . , 20 .
, , , , , 1) .
. .
. Excel , .
, , , . , . .
.
, 6 , 8 , 10 , 3 , , , . 10 000 . , .
. , , : - - . , : Ai*+i, - ; i i - , :
- 1,5 (2=1,5; 2=0);
- - 3 (3=0; 3=3);
- - 30 . , (4=3; B4=30);
- - 2 (5=2; 5=0);
- - 40 . (6=1,5; 6=40);
- - 4 (7=4; 7=0);
- - 20 . (8=4; 8=20);
,
N1*A1*C+N2*(A2*C+B2)+...+N8*(A8*C+B8) = 10000,
N1 - , N2 - ..
A1...A8, B1...B8 N1... N8, .
, . .
, .
D . , D4 =B4*$H$8+C4.
F . , F4 =D4*E4.
F12 . , .
|
|
, :
- ;
- " " F12, ;
- "" 10000;
- " " H8 .
hospital.xls.
, Excel . , . , , , , , - , . , Excel, .
7.1. x2-sinx=0.
=0,5.
, : 0 0,87, Excel .
, .
. , , .
, , . , ?
Excel .
, .
.
7.2.1.1
. , 5-7 , 8-10 , 10 , 3 , , , . . , , , 80 .
, , . :
N1*A1*C+N2*(A2*C+B2)+...+N8*(A8*C+B8) = .
(N1), (N2), (N3) ().
, .
hospital.xls.
.
F12, .
, .
, .
:
, . 7.1.
, - .
. 7.2. : , .
|
|
, .
.
7.2.1.2
, . "A", "B" "C". , 10- "" 9 ., "" - 10 . "" - 16 .
7. 1 -
7. 2 -
( ), . , , .
10 .
, .
, 7.3.
.
. , , 7.4.
, 80 "" 20 "". "" . 400 .
7.2.1.3 Solvsamp.xls
Solvsamp.xls, Excel, Examples\Solver .
7. 3 -
7. 4 -
. " "1), " " " ", , , . , .