, 16 .
3. :
, Excel. .
3.1. G3-G7 .
3.2. H3-H7 :
H3: =D8 =15.01.15
H4: =H3+D10 =20.01.15
H5: =H3+D12 =20.01.15
H6: =H4+D14+D16 =29.01.15
H7: =H6+D17 =04.02.15
/ H3-H7 , 14.03.01/
3.3. I3-I7 ( ):
I3: =(($C$6-H3)>=D9;D9;$C$6-H3) =7
I4: =(($C$6-H4)>=(D9-D10+D11);(D9-D10+D11);$C$6-H4) =2
I5: =(($C$6-H5)>=D13;D13;$C$6-H5) =2
I6: =(($C$6-H6)>=D15-D16;D15-D16;$C$6-H6) =-7
I7: =(($C$6-H7)>=D18;D18;$C$6-H7) =-13
, .
3.4. J3-J7 ( ):
J3: =(I3<0;D9;D9-I3) =1
J4: =(I4<0;(D9-D10+D11);(D9-D10+D11) -I4) =2
J5: =(I5<0;D13;D13-I5) =6
J6: =(I6<0;D15-D16;D15-D16-I6) =18
J7: =(I7<0;D18;D18-I7) =16
4. :
4.1. G2-J7 Excel .
4.2. , 셻
4.3. , .
4.4. . .
4.5. , . .
.
6. ( ) , .
7. . . , , , .
, , 01.01.1900.
, MS Excel, .
8. , . , ջ. , .
|
|
9. . . .
, .
10. - . .
.
11. .
, .
12. . . .
ʻ. .
13. . . , , , .
ʻ. .
14. . . .
.
15. . , .
.
1.
1.
1.1. : , (--( )- )
1.2. :