| 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 | ||