SPREADSHEET SOLUTIONS FOR VIBRATION ANALYSIS AND MODELLING

Abstract

The use of a tuned absorber to control the vibration amplitudes of a secondary system subjected to base excitation via a primary system is investigated computationally. A second investigation considers the use of an impact damper mounted on the tuned absorber to control vibration amplitudes of secondary system subjected to base excitation via the same primary system. A series of spreadsheet programs have been written to assist in the investigation of the two vibration control problems. Techniques for solving both closed form and numerical integration problems using spreadsheet macros are presented. The graphics capabilities of spreadsheets are used to present the results of batch case runs of different system parameters. User manuals for both series of programs have been written, fully explaining the programs and how they can be used as a basis for continued investigations of these and similar situations.