Print

In physics, damping is any effect that tends to reduce the amplitude of oscillations in an oscillatory system. These Excel worksheets have been supplied by the visionary ExcelCalcs user George Lungu. They allow you to interact with a live animated oscillator to investigate the effects of changes to mass, stiffness and damping. 

SpringDamper1DOF.png
Watch these videos: Spring Damper 1DOF Demonstration and Spring Damper 1DOF Explained
In mechanics, friction is one such damping effect. For many purposes the frictional force F can be modelled as being proportional to the velocity v of the object. The value of the damping ratio ζ critically determines the behaviour of the system. A damped harmonic oscillator can be:
    * Overdamped (ζ > 1): The system returns (exponentially decays) to equilibrium without oscillating. Larger values of the damping ratio ζ return to equilibrium slower.
    * Critically damped (ζ = 1): The system returns to equilibrium as quickly as possible without oscillating. This is often desired for the damping of systems such as doors.
    * Underdamped (ζ < 1): The system oscillates (with a slightly different frequency than the undamped case) with the amplitude gradually decreasing to zero.

Spring%20Damper%202DOF.pngTwo degrees of freedom means that two is the minimum number of coordinates necessary to uniquely specify the position of the system. Study the properties of linear vibrating systems with two degrees-of-freedom. If you have already seen the one degree-of-freedom vibrating system (the mass-spring-dashpot system) then you will have some familiarity with natural frequency and resonance. It is a very useful worksheet to investigate tuned absorbers/dampers. These are reactive devices used in structural (and acoustic) systems to either absorb oscillation at a certain forcing frequency or damp oscillation at a particular resonant frequency. You can download it here: Spring Damper 2DOF.xls

Tripple%20Spring%20DamperTn.png
Tripple Spring Damper Demonstration
One mass and three spring dampers are used to create and Excel spirograph. Its an impressive demonstration of Excel used as a simulation tool. It can be downloaded here: Tripple Spring Damper.xls

 

Repository News

krugerprojects earns his XLC Pro subscription with this new calculation Hollow Section RHS.xls
Hollow%20Section%20RHS.png


Dino earns his XLC Pro subscription with this new calculation Pile design.xls
Pile%20design.png

Dino earns an extension to his XLC Pro subscription with this new calculation Concrete Beam Design(CSA A23_1-94).xls
Concrete%20Beam%20Design%28CSA%20A23_1-94%29.png

Dino earns another extension to his XLC Pro subscription with this new calculation: Steel Beam-Column Design (Metric - CISC 2000).xls
Steel%20Beam-Column%20Design%20%28Metric%20-%20CISC%202000%29.png

Rosochacki earns his XLC Pro subscription with this new calculation Mcabe Theile.xls
Mcabe%20Theile.png

jwt extends his existing subscription by 3 months with his new calculation Rectangular Steel Bar Design.xls
Rectangular%20Steel%20Bar%20Design.png

derekm follows the upload guidelines and is rewarded with a free XLC Pro (12M) subscription for Trajectory.xls
Trajectory.png