Following
is the beginning portion of the Excel Worksheet calculating a linear
vibration system |
|
of single
degree of freedom.If you copy this sample to a Excel Worksheet,you can read
the calculating formulas |
as well as
the feagures of calculation results.@ |
|
|
|
Parameter; |
|
|
dt |
’t |
F0(N) |
M(Kg) |
K(N/m) |
C(N*s/m) |
|
0.0001 |
0.05 |
0 |
253.6 |
1,000,000 |
1000 |
|
No. |
|
t |
F(t) |
d2X(t)/dt2= |
dX(t)/dt= |
X(t)= |
|
|
@IF(+C9<$D$3, |
(+D9-$G$3*G9 |
|
|
+$E$3/$D$3*C9, |
-$H$3*F9)/$F$3 |
+F9+E9*$C$3 |
+G9+F9*$C$3 |
|
|
+$E$3) |
|
0 |
0 |
0 |
0 |
0 |
0 |
0.01 |
|
1 |
|
0.0001 |
0 |
-39.43217666 |
0 |
0.01 |
|
2 |
|
0.0002 |
0 |
-39.41662769 |
-0.003943218 |
0.01 |
|
3 |
|
0.0003 |
0 |
-39.39952996 |
-0.00788488 |
0.009999606 |
|
4 |
|
0.0004 |
0 |
-39.38088469 |
-0.011824833 |
0.009998817 |
|
5 |
|
0.0005 |
0 |
-39.36069316 |
-0.015762922 |
0.009997635 |
|
6 |
|
0.0006 |
0 |
-39.33895672 |
-0.019698991 |
0.009996058 |
|
7 |
|
0.0007 |
0 |
-39.31567677 |
-0.023632887 |
0.009994089 |
|
8 |
|
0.0008 |
0 |
-39.29085478 |
-0.027564455 |
0.009991725 |
|
9 |
|
0.0009 |
0 |
-39.26449228 |
-0.03149354 |
0.009988969 |
|
10 |
0.001 |
0.001 |
0 |
-39.23659084 |
-0.035419989 |
0.009985819 |
|
11 |
|
0.0011 |
0 |
-39.20715213 |
-0.039343648 |
0.009982277 |
|
|
|
|
|
|
|
|
|