Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Appendix B4 ASME Y14.5M-1994 Fixed Fastener Positional Tolerance Calc. 5

Status
Not open for further replies.

KENAT

Mechanical
Jun 12, 2006
18,387
Linked below is a spreadsheet I’ve set up for calculating positional tolerances.

Typically I wouldn’t expect to need to fill in the top portion but if copy is needed for records etc then I thought it may come in useful.

Please feel free to use it and/or to give constructive criticism.

If members think it would be worth it I’ll put it as part of a FAQ.


KENAT, probably the least qualified checker you'll ever meet...
 
Replies continue below

Recommended for you

Kenat,

Im sure your intent is good. However, I see no particular benefit in using the spreadsheet. If the user does not how to apply the formula, there is a problem that I don't believe the spreadsheet will necessarily solve for him. Perhaps add to the confusion.

FWIW

 
However, ringman, if the user knows how to apply the formula, then the spreadsheet becomes a welcome increase in efficiency.

Thanks, KENAT!

I'll let you know when I use it.

V
 
vc66,

If it increased efficiency, I say go for it. However, it does not illustrate the need for projected height. Or am I missisng something.
 
Ringman, see ASME Y14.5M-Appendix B4 as clearly referenced on the spreadsheet regarding projected tolerance.

As regards not seeing the benefit etc. When I release this as a worksheet I'll add a worked example with some annotation/explanation etc. One of my goals for the year is to try and teach people about matching hole patterns & doing the tolerance etc. This only forms part of this effort.

As to all the pretty formatting, every now & then it's usefull/required to have a copy of a tolerance analysis for presentation/records, that's where it comes in.

KENAT, probably the least qualified checker you'll ever meet...
 
Kenat,

The longer I look, the more questions that arise. If this is a stud, which it appears to be, would you not tolerance the hole with the thread on the other end for starters?

And then apply a projection tolerance equivalent to the height of the stud which protrudes after assy?.
 
The image is based on an example from training material by Gary Whitmire, originally the sheet used the terminology from that training pack. Perhaps a simpler/more classic threaded hole image would have been better.

I've already addressed the protrusion issue above.

KENAT, probably the least qualified checker you'll ever meet...
 
Make a pie and people will complain about not having cake. It is a useful spreadsheet for most applications.

"Art without engineering is dreaming; Engineering without art is calculating."

Have you read faq731-376 to make the be
 
Very nice.
I had a similar spreadsheet years ago at another company, but lost it. But never got around to recreating it.
It is also good to print out and send with the drawing to the checker.
Great job KENAT!

Chris
SolidWorks/PDMWorks 08 3.1
AutoCAD 06/08
ctopher's home (updated Jul 13, 2008)
 
"It is also good to print out and send with the drawing to the checker." That's kind of where I was heading.

(By the way, the colors are a compromise between looking OK on screen and printing out OK in B & W/Greyscale.)

KENAT, probably the least qualified checker you'll ever meet...
 
Thanks again, KENAT! Something I've been procrastinating about.

Believe it if you need it or leave it if you dare. - [small]Robert Hunter[/small]
 
You can also add the calendar option to Excel to add the date, if you don't want to type the date. I can send you the instructions if you need them.

Chris
SolidWorks/PDMWorks 08 3.1
AutoCAD 06/08
ctopher's home (updated Jul 13, 2008)
 
Doesn't the date auto update when you open the doc?

Trouble with that is if someone just saves the excel then opens the excel at a later date the date changes. Not a big deal for this but caused a pain when we had similar in one of our drawing formats.

A few things to think about:

Does it make sense to have 4 "clearance" or "interference" cells or would one be better. Each does it's own check but it's the same equation re-aranged, if ones 'clearance' obviously so are the others.

Also, on the image that ringman brought up. Just remembered the original had "MAJOR' under the FCF for the stud and I didn't copy it across. Thinking about it that made sense for a stud & I probably should have left it in. However I think what I'll actually do is create a new image with a classic threaded hole more like fig B-2 in Y14.5 and just add the annotation.

Any more constructive comments will be considered;-).

KENAT, probably the least qualified checker you'll ever meet...
 
There is no date with the file I downloaded...but is ok.

Chris
SolidWorks/PDMWorks 08 3.1
AutoCAD 06/08
ctopher's home (updated Jul 13, 2008)
 
Sorry, what I meant is that if you use the auto date from Excel you get the problem, so I didn't use it.

The field I put is blank but formatted for date.

KENAT, probably the least qualified checker you'll ever meet...
 
Chris, if you were talking about something other than the auto date then let me know, maybe I'm misunderstanding.

KENAT, probably the least qualified checker you'll ever meet...
 
OK, I know it's been a while and you've been overwrought with anticipation so without further ado or prevarication...

I’ve updated it with a more ‘typical’ figure closer to figure B2 in ASME Y14.5M-1994.

I’ve also given some examples showing how it can be used.

Please let me know what you think, if I’ve made any errors or it needs fine-tuning.

In return, I’ll only charge you a nominal fee to use it;-).


KENAT, probably the least qualified checker you'll ever meet...
 
 http://files.engineering.com/getfile.aspx?folder=a07e9927-87fc-4c7c-874b-68d9b849f922&file=APPENDIX_B4_ASME_Y14.5M-1994.xls
Kenat, do you have a version of your spreadsheet that covers projected zone? It wouldn't be a big deal to add it, but thought I would check if you'd already done it.

It's an awesome tool and has been very useful for me to double check my calcs (also much prettier :)
 
I haven't done that. When we have interfaces of concern we tend to add an actual projected tolerance zone rather than oversize the hole per B5.

Feel free to plagerize, maybe post it back here for others.

KENAT,

Have you reminded yourself of faq731-376 recently, or taken a look at posting policies:
 
I feel that these tolerance calculations are so simple that a spreasheet only "muddies the waters." Pencil and paper are the only way to completely document the calculation so that all the terms can be defined relative to the parts involved and that anyone with enough knowledge can follow the calculation and learn the problem immediately.



Tunalover
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor