1.1.
A | B | C | D | E | F | G | H | I | J | K | |
1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||
6.5 | 10.5 | ||||||||||
( ) | |||||||||||
. | 987.5 | ||||||||||
( 1 ) | . | ||||||||||
.1 | 0.2 | 0.1 | 0.15 | 0.2 | 0.25 | 0.1 | 0.3 | 3.6 | <= | 3.6 | |
.2 | 0.2 | 0.2 | 0.15 | 0.1 | 0.1 | 0.2 | 0.1 | 2.025 | <= | 4.2 | |
.4 | 0.1 | 0.15 | 0.2 | 0.1 | 0.15 | 0.2 | 0.1 | 2.875 | <= | 3.4 | |
.5 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 1.7 | <= | 1.7 |
1.1.
1.1. ()
4 ( 1.1) :
- ( 1.1),
- ,
- ,
( ).
1.1
:
- 6:6 - ( ),
- 9.12 - (
);
- 9:12 - (
),
- Y9:Y12- .
1.1 ( ,
). 1.1
, " "
- 16, ,
- " ",
- "",
- ,
- ;
- 1 $3:$3,
- 1-7;
- 2 6:6,
- ,
- "*' ( 16 ); 1.1 F=O, .. 0 1/7.
I9:I12 , 1/7 .
|
|
, ;
- 16 ,
- 19;
- " " ,
- 19 I10:I12, , , .
I9:I12 , .. 1/7 .
.
" " ""
" " ( 1.2) :
- ;
- : " ",
- " " $$3;$$3,
- "" " " ( 1.3), .
:
- " " XI - $$3,
- " " >;
- XI - $$4;
1.2. " "
1.3.
2+7.
:
- - $I$9;
- £;
- $K$9;
- ;
- I10£K10,I11£K11,I12£K12;
- .
( 1.2) .
, .
, , ( 1.4).
, , . , , , .
. 32767. 100, , .
, 100.
- .
|
|
.
1.4.
( 1.2).
-, ( 1.5)
, 1.1.
3:3 , I6 ; I9:I12 ( ).
1.5
, , 1.1.
1=0 2=0 3=6,5
4=0 5=10,5 6=0 7=0
, 5 6,5 10,5 . 987,5 . : 1 3,6 , 2 2,025 , 3 2,875 , 1,7
, ( 1.5) .
, 8 11 , 1.1.
Excel 1.1
, , .
, 1.6.
() , .
, , 1.1.
()
$I$6 | . | 987,5 |
$B$3 | |||
$C$3 | |||
$D$3 | 6.5 | 6.5 | |
$E$3 | |||
$F$3 | 10.5 | 10.5 | |
$G$3 | |||
$H$3 |
$I$9 | .1.. | 3,6 | $I$9<=$K$9 | ||
$I$10 | .2. . | 2,025 | $I$10<=$K$10 | . | 2,175 |
$I$11 | .4. . | 2,875 | $I$11<=$k$11 | . | 0,525 |
$I$12 | .5. . | 1,7 | $I$12<=$K$12 | ||
$B$3 | $B$3>=$B$4 | ||||
$C$3 | $C$3>=$C$4 | ||||
$D$3 | 6,5 | $D$3>=$D$4 | . | 6,5 | |
$E$3 | $E$3>=$E$4 | ||||
$F$3 | 10,5 | $F$3>=$F$4 | . | 10,5 | |
$G$3 | $G$3>=$G$4 | ||||
$H$3 | $H$3>=$G$4 |
1.6.
" " .
"" , " ", . . , "" , "" " ", "" - . .
|
|
, ( 1.7). : , - .
. | . | 1 | ||||
$B$3 | I | -27,5 | 27,5 | 1E+30 | ||
$$3 | 2 | -12,5 | 12,5 | 1E+30 | ||
$D$3 | 6.5 | 1,666666667 | ||||
$$3 | 4 | -17,5 | 17,5 | 1E+30 | ||
$F$3 | 5 | 10,5 | 5,000000001 | |||
$G$3 | 6 | -2,5 | 2,5 | 1E+30 | ||
$$3 | 7 | -32,5 | 32,5 | 1E+30 |
. | , | |||||
$l$9 | 1 .. | 3.6 | 3,6 | 0,65 | 1,05 | |
$I$10 | .2 .. | 2,025 | 4,2 | 1E+30 | 2,175 | |
$I$11 | .4 e.. | 2,875 | 3,4 | 1E+30 | 0,525 | |
$I$12 | .5 .. | 1,7 | 1,7 | ,190909091 | 0,26 |
1.7.
, , .
" " ,
" " " " Di,, .
" " Z,, , .
" " " " Dbi, , .
( 1.8) , , , .
Xj Xj. , , Xj , , .
, .
$I$6 | . | 987,5 |
$B$3 | 1 | |
$C$3 | 2 | |
$D$3 | 3 | 6,5 |
$E$3 | 4 | |
$F$3 | 5 | 10,5 |
$G$3 | 6 | |
$H$3 | 7 |
|
|
987,5 | |
987,5 | |
987,5 | |
357,0 | |
987,5 | |
987,5 |
987,5 | |
987,5 | |
6,5 | 987,5 |
987,5 | |
10,5 | 987,5 |
987,5 | |
987,5 |
1.8.
2. .