Machine Design Spreadsheet Analysis Elements - a PDH Online Course for Engineers, Surveyors and Architects

Machine Design Spreadsheet Analysis Elements Elements

Course Outline

This 5 hour online course defines the design equations of several basic machine components resulting in Excel print-outs of design parameters and calculated results. Topics include: Power Transmission Shafting, Straight and Curved Beams, Couplings, Power Screw Actuators, Brakes, Spur and Worm Gears.

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;
Calculate stress and deflections of machine elements;
Analyze power transmission shafting;
Design rigid couplings;
Determine hub and shaft key dimensions;
Calculate power screw actuator lifting capacity;
Find brake torque capacity;
Verify V-belt power transmitting values;
Optimize spur gear dimensions;
Calculate the strength and limits of worm gears;
Document engineering calculations in a spread sheet format;
Create spread sheets for more engineering calculations; and
Be able to employ Excel’s Goal Seek tool to optimize designs.

Intended Audience

The information will be especially useful to students, engineers, and innovators who need tools for creative machine design.

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 design parameters. Machine design 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.

Course Content

You need to download and study the following spreadsheet:

Machine Design 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 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. Topics include: Power Transmission Shafting, Straight and Curved Beams, Couplings, Power Screw Actuators, Brakes, Spur and Worm Gears.

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.