Excel
, - . , 20 .
, , , , , .
. .
. 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 . , .
|
|
, :
o ;
o " " F12, ;
o "" 10000;
o " " H8 .
hospital.xls.
, Excel . , . , , , , - , . , Excel, .
1. x2-sinx=0.
=0,5.
, : 0 0,87, Excel .
, .
. , , .
, , . , ?
Excel .
2.1
, .
.
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, .
, .
, .
:
|
|
, . 1.
, - .
. 2. : , .
, .
.
, . "A", "B" "C". , 10- "" 9 ., "" - 10 . "" - 16 .
1 -
2 -
( ), . , , .
10 .
, .
, 3.
.
. , , 4.
, 80 "" 20 "". "" . 400 .
2.1.3 Solvsamp.xls
Solvsamp.xls, Excel, Examples\Solver .
3 -
4 -
. " "1), " " " ", , , . , .
Solverex.xls, Excel, : , . : " , ?".
, , , .
, : .
2- : " " " ". , 1- :
( 2) - 0.92);
( 9) - 8 . ;
( 10) - 10 . .
:
( 17) - 40 ;
( 18) - 25 .
:
|
|
3) ( 4)
=35*B2*(B10+3000)^0,5
( 4), , 5
=B4*B17
" "
B6=B4*B18
, , 7,
=B5-B6
15% , B11
=0,15*B5
, ,
B12=(B9:B11)
,
B14=B7-B12
B15=B14/B5
, , . 7.5.
=> :
B14, 4);
- ;
, 5) - B10;
. , .
, (. 6).
, 17 093 . . , . 8%.
5 -
2
,
f = (x-1)2 + y2 - 0,5cos(2z)
-0,5 x=1; y=-7,9E-07 z=3,14159.
x=1, y=2 z=3.
6 -