I would like to post the Excel file I created for critique but I'm not really sure how to do that with the unbelievable IT restrictions we have here. This is not my normal method of extracting the information I need but it is the customer engineering intent. That is correct, however, datum A is not perfectly flat and I cannot assume that the hole is bored exactly perpendicular to the surface. I thought I would get an email letting me know someone replied. Any assistance would be greatly appreciated!!! As a general rule, I measure products on the CMM but in this case, the supplier is sending me raw data from manual measurements and they need help reporting the data. I cannot find any mathematical formulas for hole pattern true position. I am trying to write a series of formulas using PLTZF (Pattern Locating Tolerance Zone Framework) and FRTZF (Feature-Relating Tolerance Zone Framework) that will determine if the pattern of holes is accurate and I have no idea where to begin. The formulas all seem to work accurately as I have confirmed the numbers using an online calculator, as well as, my CMM software. I have another series of formulas that establish MMC bonus tolerance and a formula that uses an IF statement for "PASS" or "FAIL". I have a spreadsheet that uses the following formula to attain the true position of 0.0200 to A, B, & C: =2*SQRT((A7*A7)+(B7*B7)+(C7*C7))Ī7 is the deviation in the X direction, B7 is the deviation in the Y direction, & C7 is the deviation in the Z direction.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |