. . 1 .
. 1.
2 =(). D2 =C2+1 .
E (' '!2) F3.
1- 3 =!B6*/(1+) .
2- . C4:G4 =*/(1+) Ctrl, Shift Enter., . .
5 =C4* .
6 =C3-C5 .
C7:G7
{=*(+)/(1+)}
C8:G8 .
C9:G9
{=*}
10 =C9*(' '!$D$8:$D$10) .
E $ F4. , $ .
11 =(C7:C10), 12 =C6-C11, 13
=(;)
.
C14:G14 {=/(1+)}
15 =C13+C14 .
C16:G16
{=*(1+(' '!D8:D10))+}
17 =C15+C16 .
C18:G18 ().
(;;).
.
.
, ( ).
0. , =1/ . D18
=(;0;1/'. '!$D$3)+(;0;1/'. '!$D$4)
E. () D18, , , .
2006 , 18 =3/12*D18
C19:G19 0.
E , , Ctrl Enter.
20 =(C18:C19), 21 =C12-C17-C20, 22 =(C21<0;0;C21*), 23 =C21-C22. .