Vibration and Shock Load Spreadsheet Analysis Elements - a PDH Online Course for Engineers, Surveyors and Architects

Vibration and Shock Load Spreadsheet Analysis Elements

Course Outline

This 4 hour online course defines the design equations of several basic engineering calculations resulting in Excel print-outs of design parameters and calculated results.

Topics include:

Power Transmission Shafting
Damped and Un-damped Vibrating Systems with Forcing Functions
Isolation mounts combined stiffness
Viscous damping ratio
Vibration amplitude
Transmissibility Force
Elastic and in-elastic impact shock analysis
Required Isolator factor calculation

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

Have a spread sheet useful for machine design calculations;
Adjust machine dimensions to meet design specifications;
Document design calculations in a spread sheet format;
Determine machine vibration frequencies;
Analyze forced and damped vibration amplitudes;
Calculate the critical speed of a shaft with an overhanging load;
Evaluate cantilever and beam deflections and natural frequencies;
Determine rectangular and circular plate deflections and natural frequencies;
Apply static and dynamic balance masses to rotating shafts;
Calculate shock impulse accelerations and deflections;
Document engineering calculations in a spread sheet format;
Create spread sheets for more engineering calculations;
Be able to employ Excel’s Goal Seek tool to optimize designs; and
Use Excel’s “Solver” to determine system minimum frequency.

Intended Audience

The information will be especially useful to: students, engineers, and innovators who need tools for system vibration and shock load analysis.

Benefit to Attendees

Attendee of this course will be able to calculate and optimize variables in a range of machine design projects.

Course Introduction

Excel spread sheets are used to calculate and optimize machine vibration design parameters. These calculations have been done with a calculator and written by hand with pen or pencil. Optimizing design values with a calculator is difficult and time consuming. Quite often it is impossible to read and check these documents. As time passes it becomes more difficult to use these documents to make improvements to existing designs. Digitizing engineering calculations with Excel spreadsheets provides legible engineering work that can easily be retrieved anytime in the future.

Course Content

You need to download and study the following spreadsheet:

Vibration and Shock Load Spreadsheet Analysis Elements

DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."

Course Summary

This course provides Excel spread sheets to calculate a range of basic machine vibration design parameters. All variables can be adjusted to optimize design goals. Excel print-outs of design parameters and calculated results provide easy to read documentation for checking and future improvements.

Related Links

Go to: www.PDHonline.com for Machine Design.

Vibration Isolator Vendor> http://www.barrycontrols.com/

Excel tutorials can be found at: www.dslimited.biz/excel_tutorials.html

The United States Patent and Trademark Office Home Page at www.uspto.gov
Provides links to information about all aspects pertaining to invention patents.

Quiz

Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.

DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.