This paper presents an easy-to-use spreadsheet module in Microsoft Excel to handle the implementation of the ANSI standards for tolerance fits for shafts and collars. The module makes use of drop-down menus and an embedded Visual Basic numerical algorithm to locate the correct tolerance ranges for a shaft and collar combination for the entire range of tolerances handled by the tables published in the ANSI standard. This module allows the quick implementation of designs and features a process that is less subject to errors associated with the traditional method of reading of the tolerance tables and transferring this information manually. The method is particularly helpful to students and inexperienced designers who first encounter the need to utilize tolerances in engineering designs. The paper presents an example application to illustrate the overall utility of the module.

This content is only available via PDF.
You do not currently have access to this content.