, .7, .3. 1 3, 2 . 3 . 1 2, . , 3 2.
.7.
3
X1 | X2 | X3 | V |
LN(2;1,4) | LN(2;1,4) | E(2;0,05) | G(0,7) |
Excel (.8) . A B - , () [0;1]. C, D, E F X1, X2, X3 V , . G Y, H Z.
.8.
A1, B1,, H1 . A2 B2 :
A2=()
B2=()
C2,D2,E2 X1, X2, X3, , - , .2:
C2=EXP(2+1,4*(-2*LN(B2))*COS(2*()*A2)
D2=EXP(2+1,4*(-2*LN(B2))*COS(2*()*A2)
E2=-(LN(A2)+LN(B2))/0,05
F2 V, 0,7:
F2 = (LN(A2)/LN(1-0,7))+1
, .7. 1 2 , , , X1+X2. 1 2 , 3, . , Y=min(X1+X2,X3). G2 , Y:
G2 = (C2+D2;E2)
H2 Z:
H2 = G2/(1+0,1*F2)
A2, B2,, H2. 100 . A2, B2,, H2 101 (.8).
A2:H101 . , :
(Ctrl+C),
Microsoft Word Word (Ctrl+V),
Word (Ctrl+C),
Microsoft Excel Excel (Ctrl+V).
Z , , A1:J10.