, . , , . , , , . , . , .
, . , , ( 1.26).
.
G2 , , .
, , , . . - , .
( 1.13)
1.26
1.13
5 | =(B5<>"";1;"") | - |
A6 | =(B6<>"";A5+1;"") | 7-10 |
5 | =(B5<>"";(E5+D5/G5*$M$2<D5; D5/G5*$M$2;D5-E5);"") | 6-10 |
I5 | =(B5<>"";E5+H5;"") | I6-I10 |
J5 | =(B5<>"";D5-I5;"") | J6-J10 |
K5 | =(B5<>"";(E5+D5/G5*$M$2<D5; D5/G5*$M$2;D5-E5)-(E5+D5/G5* ($M$2-1)<D5;D5/G5*($M$2-1);D5-E5);"") | K6-K10 |
N5 | =(D5:D10) | - |
N6 | =(E5:E10) | - |
N8 | =(H5:H10) | - |
N9 | =(I5:I10) | - |
N10 | =(J5:J10) | - |
N11 | =(K5:K10) | - |
5 , , , .
6 , .
5 , . . , , . E5+D5/G5*$M$2<D5 , , , , , D5/G5*$M$2. .
|
|
, 5 :
=(B5<>"";(E5+D5/G5*$M$2<D5;D5/G5*$M$2;D5-E5)-(E5+D5/G5* ($M$2-1)<D5;D5/G5*($M$2-1);D5-E5);"")
, , . , 5.
, . , , .
4
: .
, . Excel . . . .
, , (. 1.27).
1.27
. . .
, .
, , (. 1.28).
J1 2001.
1.28
( 1.13).
1.13
D2 | =(((J1);(J1);1);(J1;0);!G2:G12) | - |
A7 | =(B7<>"";1;"") | A8-A10 |
C7 | =(B7<>"";(B7;!$A$3: $E$10;2;);"") | C8-C10 |
D7 | =(B7<>"";(B7;!$A$3: $E$10;3;);"") | D8-D10 |
G7 | =(B7<>"";D7/$D$2*E7;"") | G8-G10 |
K7 | =(G7:J7) | K8-K10 |
L7 | =K7*14% | L8-L10 |
M7 | =K7*11% | M8-M10 |
N7 | =K7*3% | N8-N10 |
O7 | =K7*4% | O8-O10 |
P7 | =K7*3,4% | P8-P10 |
Q7 | =K7*0,2% | Q8-Q10 |
R7 | =K7*0,2% | R8-R10 |
T7 | =((B7<>"";W7=0);400;0) | T8-T10 |
U7 | =(B7<>"";(B7;! $A$3:$E$10;5;);"") | U8-U10 |
V7 | =U7*300 | V8-V10 |
X7 | =(B7<>"";(S7<20000;(K7-T7-V7-W7)*13%;(K7-V7-W7)*13%);"") | X8-X10 |
Y7 | =(B7<>"";K7-F7-X7;"") | Y8-Y10 |
Z7 | =(K7:K10) | - |
AA7 | =(Y7:Y10) | - |