【转帖】appendix b4 asme y14.5m-1994 fixed fastener positional toler

yang686526

appendix b4 asme y14.5m-1994 fixed fastener positional toler
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...
check out our whitepaper library.
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."
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
"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.fff"> - robert hunter