: 16, : 17, D16, D17, D18 22:31.
22:31 ( , =$ $16:$$17). -.
D16 =ר(;)
E F3.
D17 .
D18 .
. 2 .
. 2.
3:12 , 3
=' '!A22
E , . Excel .
3:12.
E 3 3:12, 3, . , 3:12.
D2:I2, ( D2:I2 ):
1. 6:11 . D2 .
2. D2:I2 .
=(' '!B6:B11)
E () .
() . Ctrl, Shift Enter. .
D3:I12 , 0;1
J2 . J2 . , .
J3:J12 .
D13
=($C3:$C12;;D3:D12)
D13:I14 .
D3:I12, . . 2:12 à. . .
|
|
D3:I12 . 5.2 ( ).
3:12 . , . 5.2.
. . 3 .
. 3.
3:14, . 3
=(' '!B$6;$A3-1;0)
3:14.
E () ( ).
3:14.
E 3:14 , 14.03.99.
3 =(' '!$D$6;A3-1;0)
4 =(' '!$D$6;A3-1;1)
.
F3 =(!$D$13;0;A3-1)
F4 =(!$D$13;1;A3-1)
F.
G3 =(E3/F3;0)
G.
3:14 .
, (). , _. , . () , .
(_; _;)
_ .
_ _. _ ; .
, (, ).
I3 =(H3;G3-1;). I.
J2
=("1"&' '!C1&' '!D1)
() , .
(__)
__ , (, 30.01.1998).
E & .
2 =J2+1 .
J2, , . . , à ( ), ..
E , , , .
J2:AN2, J2
E J2 J2:AN2, J2, . . J2:AN2.
|
|
, . J2 à . 4.
E 1 ( ). 2 ( ).
E , , - . , ( ). ( ).
E , .
J2 .
. 4. J2:AN2
, , J3
=((J$2>=$H3;J$2<=$I3);$F3;"")
E () ( ).
J3:AN14.
, , , . J3 . 5.
. 5. J3:AN14
E 1 ( ). 2 ( , ). 3 ( 1).
J3 J3:AN3, J5:AN5, J7:N7, J9:N9, J11:AN11, J13:AN13.
J4 J4:AN4, J6:AN6, J8:N8, J10:N10, J12:AN12, J14:AN14.
, , .
E . .
àà 1 , ' '!$D$2:$AN$14. . 2 01.05.05 , , =, . . 3 . 4 J15 . J15
{=(($D$3:$D$14="";1;0))}
, . , {=(($D$3:$D$14="";J$3:J$14;0))}
E , Ctrl, Shift Enter.
J15 . 6.
. 6. J15:AN15
E 1 , 2 3 .
J15:AN16.
J17 J15 J16. .
- D19:AN26 .
' '!B22:B31.
F20 ( , =. F21
|
|
=(F20;' '!B22:C31;2;0)
() ( F20) , ' '!B22:C31.
. I20
=($F$20;!$B$3:$I$12;G20+2;0)
(0 , 1 ).
J20
=($I20=1;(J$3;($F$21=;2*($G20-1);2*$G20-1);0);"")
, . J20 . 7.
. 7. J20:AN25
. J26 =ר(J20:J25), , . , , 1.
.
I3. 01.05.05, , . (). I3
=(H3-1;G3;) .
MS Excel . , . àà ... ( ).