̲
. 3
1. 3
2. 4
3. 5
1. 6
2. 12
3. 16
腅.....22
1.
Ø y=a*cos(x)+b 1<<3 1, = 110; b=026.
Ø .
Ø ϳ ( ).
Ø : , 3; , 4. ( ).
Ø , , ( ).
Ø ( ).
Ø , ) .
Ø , ( ) . .
Ø -, .
Ø , , -.
Ø .
2.
, , F1, , W, .
. 1 -
L | z1 | z2 | z3 | F1 | F2 | q1 | q2 | T |
3
, . .
.
.
, .
1.
y=a*cos(x)+b 1<<3 1, = 110; b=26.
. . .
|
|
x | y |
85,43 | |
-19,78 | |
-82,90 |
x | y |
=H$2*COS(A2)+I$2 | |
=H$2*COS(A3)+I$2 | |
=H$2*COS(A4)+I$2 |
. .
x | y |
85,43 | |
-19,78 | |
-82,90 | |
-5,75 |
x | y |
=H$2*COS(A2)+I$2 | |
=H$2*COS(A3)+I$2 | |
=H$2*COS(A4)+I$2 | |
=(B2:B4) |
: , 3; , 4. . .
x | y | |
85,43 | 341,73 | |
-19,78 | -59,33 | |
-82,90 | -248,70 |
x | y | |
=H$2*COS(A2)+I$2 | =(B2<B$5;B2*3;B2*4) | |
=H$2*COS(A3)+I$2 | =(B3<B$5;B3*3;B3*4) | |
=H$2*COS(A4)+I$2 | =(B4<B$5;B4*3;B4*4) |
, , ( ). .
x | y | ||
85,43 | 341,73 | 29195,36 | |
-19,78 | -59,33 | -6758,16 | |
-82,90 | -248,70 | -28329,38 |
:
x | y | ||
=H$2*COS(A2)+I$2 | =(B2<B$5;B2*3;B2*4) | =B2*C$2 | |
=H$2*COS(A3)+I$2 | =(B3<B$5;B3*3;B3*4) | =B3*C$2 | |
=H$2*COS(A4)+I$2 | =(B4<B$5;B4*3;B4*4) | =B4*C$2 |
( ).
x | y | |||
85,43 | 341,73 | 29195,36 | 2494254,88 | |
-19,78 | -59,33 | -6758,16 | 133650,48 | |
-82,90 | -248,70 | -28329,38 | 2348482,62 |
:
y | |||
=H$2*COS(A2)+I$2 | =(B2<B$5;B2*3;B2*4) | =B2*C$2 | =B2*D2 |
=H$2*COS(A3)+I$2 | =(B3<B$5;B3*3;B3*4) | =B3*C$2 | =B3*D3 |
=H$2*COS(A4)+I$2 | =(B4<B$5;B4*3;B4*4) | =B4*C$2 | =B4*D4 |
=(B2:B4) | =(C2:C4) | =(D2*$E2;D3*$E3;D4*$E4) | =(E2*$E2;E3*$E3;E4*$E4) |
) .
29195,36 | 2494254,88 |
-6758,16 | 133650,48 |
-28329,38 | 2348482,62 |
1,18E+13 |
=B2*C$2 | =B2*D2 |
=B3*C$2 | =B3*D3 |
=B4*C$2 | =B4*D4 |
=(D2*$E2;D3*$E3;D4*$E4) | =(E2*$E2;E3*$E3;E4*$E4) |
, ( ) . . . :
2,1E+08 | 8,5E+08 | 7,3E+10 | 6,2E+12 |
-2,6E+06 | -7,9E+06 | -9,0E+08 | 1,8E+10 |
-1,9E+08 | -5,8E+08 | -6,7E+10 | 5,5E+12 |
-6,8E+13 | 4,0E+15 | 6,3E+22 | 1,4E+26 |
|
|
:
=B2*$E2 | =C2*$E2 | =D2*$E2 | =E2*$E2 |
=B3*$E3 | =C3*$E3 | =D3*$E3 | =E3*$E3 |
=B4*$E4 | =C4*$E4 | =D4*$E4 | =E4*$E4 |
=B5*$E5 | =C5*$E5 | =D5*$E5 | =E5*$E5 |
-. . :
2,13E+08 |
-2,64E+06 |
-1,95E+08 |
-6,76E+13 |
=B2*E2 |
=B3*E3 |
=B4*E4 |
=B5*E5 |
, , -.
, .
-1,5E+50 |
=(A7:D10) |
, .
, .
-1,40783E-08 | -1,66037E-05 | 2,04868E-07 | -5,3974E-21 |
4,6928E-09 | 1,00895E-06 | -8,56109E-09 | 9,46013E-30 |
-3,12752E-16 | 3,82755E-08 | -5,19632E-10 | 1,57942E-23 |
4,92899E-27 | -1,75393E-11 | 2,38116E-13 | -2,35758E-34 |
, :
=(A7:D10) | =(A7:D10) | =(A7:D10) | =(A7:D10) |
=(A7:D10) | =(A7:D10) | =(A7:D10) | =(A7:D10) |
=(A7:D10) | =(A7:D10) | =(A7:D10) | =(A7:D10) |
=(A7:D10) | =(A7:D10) | =(A7:D10) | =(A7:D10) |
0,999999991 |
6,11889E-11 |
-6,3892E-18 |
2,37471E-21 |
:
=(B15:E18;F7:F10) |
=(B15:E18;F7:F10) |
=(B15:E18;F7:F10) |
=(B15:E18;F7:F10) |
, . .
2,13,E+08 |
-2,64,E+06 |
-1,95,E+08 |
-6,76,E+13 |
:
=(A7:D10;B20:B23) |
=(A7:D10;B20:B23) |
=(A7:D10;B20:B23) |
=(A7:D10;B20:B23) |
.
. 2
2
.
. .
L | z1 | z2 | z3 | F1 | F2 | q1 | q2 | T |
, , z3 .
.
.3 ³
x | |
M(x) |
:
x | |
M(x) | =-E2*(B7-B2) |
.
.
.4 ³
:
x | |
M(x) |
:
X | |
M(x) | =-E2*(B6-B2)+(G2*(B6-B2)^2)/2 |
.
.
.5 ³
:
x | |
M(x) | -232,5 |
:
x3 | |
M(x)3 | =-E2*B7+G2*(D2-C2)*(B7-(D2-C2)/2) |
( ).
|
|
.6
ij . . 10.
:
W= | 0,29 |
F1 :
F1= | 0,57 |
W= | =B8/I2 |
F1= | =B8/(I2/2) |
3
- .
, . .
. 0 3600.
:
φ1 | φ1 |
0,000 | |
0,524 | |
1,047 | |
1,571 | |
2,094 | |
2,618 | |
3,142 | |
3,665 | |
4,189 | |
4,712 | |
5,236 | |
5,760 | |
6,283 |
:
φ1 | φ1 |
=(B5) | |
=(B6) | |
=(B7) | |
=(B8) | |
=(B9) | |
=(B10) | |
=(B11) | |
=(B12) | |
=(B13) | |
=(B14) | |
=(B15) | |
=(B16) | |
=(B17) |
.
r | l | e | a |
0,05 | 0,25 | 0,01 |
:
φ1 | φ1 | φ2(φ1) | φ2'(φ1) | Xb | X'b |
0,000 | 0,100 | -0,201 | 0,299 | 0,0050 | |
0,524 | -0,150 | -0,175 | 0,290 | -0,0315 | |
1,047 | -0,333 | -0,106 | 0,261 | -0,0519 | |
1,571 | -0,400 | 0,000 | 0,230 | -0,0500 | |
2,094 | -0,333 | 0,106 | 0,211 | -0,0347 | |
2,618 | -0,150 | 0,175 | 0,204 | -0,0185 | |
3,142 | 0,100 | 0,201 | 0,199 | -0,0050 | |
3,665 | 0,350 | 0,184 | 0,192 | 0,0092 | |
4,189 | 0,533 | 0,116 | 0,190 | 0,0286 | |
4,712 | 0,600 | 0,000 | 0,206 | 0,0500 | |
5,236 | 0,533 | -0,116 | 0,240 | 0,0580 | |
5,760 | 0,350 | -0,184 | 0,278 | 0,0408 | |
6,283 | 0,100 | -0,201 | 0,299 | 0,0050 |
φ1 | φ1 | φ2(φ1) | φ2'(φ1) | Xb | X'b |
=(B5) | =D$2*SIN((C$2-A$2*SIN(C5))/1) | =-A$2*COS(C5)/(B$2*COS(D5)) | =A$2*COS(C5)+B$2*COS(D5) | =-A$2*SIN(C5)-B$2*E5*SIN(D5) | |
=(B6) | =D$2*SIN((C$2-A$2*SIN(C6))/1) | =-A$2*COS(C6)/(B$2*COS(D6)) | =A$2*COS(C6)+B$2*COS(D6) | =-A$2*SIN(C6)-B$2*E6*SIN(D6) | |
=(B7) | =D$2*SIN((C$2-A$2*SIN(C7))/1) | =-A$2*COS(C7)/(B$2*COS(D7)) | =A$2*COS(C7)+B$2*COS(D7) | =-A$2*SIN(C7)-B$2*E7*SIN(D7) | |
=(B8) | =D$2*SIN((C$2-A$2*SIN(C8))/1) | =-A$2*COS(C8)/(B$2*COS(D8)) | =A$2*COS(C8)+B$2*COS(D8) | =-A$2*SIN(C8)-B$2*E8*SIN(D8) | |
=(B9) | =D$2*SIN((C$2-A$2*SIN(C9))/1) | =-A$2*COS(C9)/(B$2*COS(D9)) | =A$2*COS(C9)+B$2*COS(D9) | =-A$2*SIN(C9)-B$2*E9*SIN(D9) | |
=(B10) | =D$2*SIN((C$2-A$2*SIN(C10))/1) | =-A$2*COS(C10)/(B$2*COS(D10)) | =A$2*COS(C10)+B$2*COS(D10) | =-A$2*SIN(C10)-B$2*E10*SIN(D10) | |
=(B11) | =D$2*SIN((C$2-A$2*SIN(C11))/1) | =-A$2*COS(C11)/(B$2*COS(D11)) | =A$2*COS(C11)+B$2*COS(D11) | =-A$2*SIN(C11)-B$2*E11*SIN(D11) | |
=(B12) | =D$2*SIN((C$2-A$2*SIN(C12))/1) | =-A$2*COS(C12)/(B$2*COS(D12)) | =A$2*COS(C12)+B$2*COS(D12) | =-A$2*SIN(C12)-B$2*E12*SIN(D12) | |
=(B13) | =D$2*SIN((C$2-A$2*SIN(C13))/1) | =-A$2*COS(C13)/(B$2*COS(D13)) | =A$2*COS(C13)+B$2*COS(D13) | =-A$2*SIN(C13)-B$2*E13*SIN(D13) | |
=(B14) | =D$2*SIN((C$2-A$2*SIN(C14))/1) | =-A$2*COS(C14)/(B$2*COS(D14)) | =A$2*COS(C14)+B$2*COS(D14) | =-A$2*SIN(C14)-B$2*E14*SIN(D14) | |
=(B15) | =D$2*SIN((C$2-A$2*SIN(C15))/1) | =-A$2*COS(C15)/(B$2*COS(D15)) | =A$2*COS(C15)+B$2*COS(D15) | =-A$2*SIN(C15)-B$2*E15*SIN(D15) | |
=(B16) | =D$2*SIN((C$2-A$2*SIN(C16))/1) | =-A$2*COS(C16)/(B$2*COS(D16)) | =A$2*COS(C16)+B$2*COS(D16) | =-A$2*SIN(C16)-B$2*E16*SIN(D16) | |
=(B17) | =D$2*SIN((C$2-A$2*SIN(C17))/1) | =-A$2*COS(C17)/(B$2*COS(D17)) | =A$2*COS(C17)+B$2*COS(D17) | =-A$2*SIN(C17)-B$2*E17*SIN(D17) |
|
|
.7
.
:
.8 .
:
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
0,3 |
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
=A2*COS(A5)+B2*COS(y) |
.9 .
:
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
5,23 | 0,53 | -0,12 | 0,0580 |
:
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
5,23 | 0,53 | -0,12 | =-A2*SIN(A5)-B2*C5*SIN(B5) |
, .
.10 .
:
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
0,10 |
:
φ1 | φ2(φ1) | φ2'(φ1) | Xb |
=('3 '!A$2*COS(A1)+'3 '!B$2*COS(B1))/3 |
Microsoft Office Excel . . , .
, Microsoft Office Excel.