×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

GD&T

GD&T

(OP)
A few years ago I came across an Excel spreadsheet that you can take two parts and type in the dim's with tolerances using position, runout, etc. It gave you a tolerance number to use. I can no longer find it. Has anyone seen it or has anyone created one on your own? If so, can I get a copy? I am going to attempt to create a spreadsheet that is linked to design tables of parts for users to do GD&T. Thank you
ctopher

RE: GD&T

ctopher,

   Are you talking about the ISO tolerance letters?

   Numerical tolerances are based on your application, not just the dimensions.

                      JHG

RE: GD&T

(OP)
All of GD&T in general

RE: GD&T

ctopher,

   I am not sure of what you mean by a tolerance number.  Are you talking about the actual tolerance value?

                        JHG

RE: GD&T

(OP)
yes

RE: GD&T

ctopher,

   Your tolerances are based on your requirements.  For positional tolerances for screws through holes they are

Floating:    holeMMC - screwMMC

Fixed:       (holeMMC - screwMMC)/2

   For everything else, you need to know what kind of fit you want.  The ANSI standard fits in the Machinery's Handbook are a good start.  There is a page showing what manufacturing process achieve the fits.  You do not want to weld to +/-.0001" if you can help it.  :)

                         JHG

RE: GD&T

(OP)
Thanks drawoh. But I am looking for the spreadsheet I had seen before or if someone had created one in Excel. Just insert tolerances from mating parts to come up with GD&T on a dwg.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources