Asee peer logo

A Spreadsheet Based Tool For Shafting Design

Download Paper |


2004 Annual Conference


Salt Lake City, Utah

Publication Date

June 20, 2004

Start Date

June 20, 2004

End Date

June 23, 2004



Conference Session

Computers in Education Poster Session

Page Count


Page Numbers

9.104.1 - 9.104.11



Permanent URL

Download Count


Request a correction

Paper Authors

author page

H.Y. Shadow Huang

author page

Ernest Tollner

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

A shaft design aid for integrating basic elements of introductory machine design.

Ernest W. Tollner and H.Y. Shadow Huang Biological and Agricultural Engineering Department Driftmier Engineering Center University of Georgia Athens, GA 30602


Many of the concepts one learns in a two course sequence in machinery design culminates in the design of power transmission shafts and supporting elements ranging from various drives, supporting bearings and other supports. By the time one reaches the end of the sequence, there is little time to develop a program that can enable the average student to achieve the benefit of the integration advantage. A Microsoft Excel-based spreadsheet platform has been developed to this end. Using flexure, shear and superposition, the model can accommodate design of a simply supported circular solid or hollow shaft with simultaneous overhung normal and lateral thrust loads on each end and two loads interior to the supporting bearings. Loads may originate from the x-y and x-z planes, with a provision for shaft tension-compression forces being included. Dynamic loads are not specifically addressed. The model is organized into respective pages in which x-y, y-z and resultant forces are computed. The model also has a page devoted to showing various shear and bending moment diagrams representing the various loading planes and resultants. Stress concentration factors and associated calculation aids are included on a page. Development assumptions and comments are organized into a page. Finally, there is an input-output page walking students through the process of developing inputs and organizing key outputs for use. During the period of instruction on shaft design, students are provided with the model and do some hand calculations enabling checking the model performance as particular topics are introduced. As a project or exam, students can then use the tool to do realistic power transmission problems where they design a variety of drives, the bearings and the shaft.

Huang, H. S., & Tollner, E. (2004, June), A Spreadsheet Based Tool For Shafting Design Paper presented at 2004 Annual Conference, Salt Lake City, Utah. 10.18260/1-2--13907

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2004 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015