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.
Skip Nav Destination
ASME 2004 International Design Engineering Technical Conferences and Computers and Information in Engineering Conference
September 28–October 2, 2004
Salt Lake City, Utah, USA
Conference Sponsors:
- Design Engineering Division and Computers and Information in Engineering Division
ISBN:
0-7918-4697-0
PROCEEDINGS PAPER
Using Spreadsheet Modules to Augment Tolerance Dimensioning
Terry E. Shoup
Terry E. Shoup
Santa Clara University, Santa Clara, CA
Search for other works by this author on:
Terry E. Shoup
Santa Clara University, Santa Clara, CA
Paper No:
DETC2004-57649, pp. 27-30; 4 pages
Published Online:
June 27, 2008
Citation
Shoup, TE. "Using Spreadsheet Modules to Augment Tolerance Dimensioning." Proceedings of the ASME 2004 International Design Engineering Technical Conferences and Computers and Information in Engineering Conference. Volume 4: 24th Computers and Information in Engineering Conference. Salt Lake City, Utah, USA. September 28–October 2, 2004. pp. 27-30. ASME. https://doi.org/10.1115/DETC2004-57649
Download citation file:
6
Views
Related Proceedings Papers
Related Articles
Numerical Simulation and Convergence Analysis of Fractional Optimization Problems With Right-Sided Caputo Fractional Derivative
J. Comput. Nonlinear Dynam (January,2018)
The Numerical Solution of the Bagley–Torvik Equation With Fractional Taylor Method
J. Comput. Nonlinear Dynam (September,2016)
Solving Nonlinear Fractional Integro-Differential Equations of Volterra Type Using Novel Mathematical Matrices
J. Comput. Nonlinear Dynam (November,2015)
Related Chapters
Strategic Academic Mangment System
International Conference on Software Technology and Engineering, 3rd (ICSTE 2011)
A Quantitative Analysis of Difficulty Degree of CET-4 Listening Materials Based on Sugeno Measure
International Conference on Electronics, Information and Communication Engineering (EICE 2012)
Algorithm Analysis of Student Placement
International Conference on Computer and Computer Intelligence (ICCCI 2011)