[De...] Posted January 23, 2019 Share Posted January 23, 2019 I have created two calculators that I find handy. I am not sure if they will help anyone but I made them in order to allow me to do some simple calculations without having to keep having to do them out long hand. The first is a MPE e0 calculator, it allows you to use your machines spec to calculate the allowable error at a given distance. This is handy for determining the uncertainty inherent in any given measurement. The second calculator lets you calculate the amount of compensation that needs to be applied to a given measurement based on the known temperature at a given nominal size with given coefficient of thermal expansion. (It also shows what 10 percent of that value is so it may be used to help determine uncertainty of a given measurement, given as from my research NIST suggests that any CTE is inherently inaccurate unless it has been determined through tests completed on the actual part to be measured.) I created these because I was often calculating this information when someone wanted to know 'how accurate is the machine' or 'how do we know this is accurate'. With different temperature scales, different values for the CTE whether in metric or not, as well as measurements in metric and inch I found it tedious to complete these longhand and so created these calculators as a shortcut. I figured this would allow me to give a definitive statement regarding any specific measurement that this measurement is XXX and is accurate within +/- xxxx amount based on the machine having a valid calibration that is within manufacturers specifications. To the best of my knowledge these should not have any issues, however if anyone notices something incorrect please let me know so I might fix it. Hope these can be helpful.CMM_Calculator.xlsm Link to comment Share on other sites More sharing options...
[Ow...] Posted January 23, 2019 Share Posted January 23, 2019 Thanks for sharing Derek and Nice job! Link to comment Share on other sites More sharing options...
[De...] Posted January 24, 2019 Author Share Posted January 24, 2019 Glad you like it. Thanks. Link to comment Share on other sites More sharing options...
[Ri...] Posted October 18, 2023 Share Posted October 18, 2023 How would you enter this: (2.00 + 3.00 * L/1000) Link to comment Share on other sites More sharing options...
[To...] Posted October 20, 2023 Share Posted October 20, 2023 Please sign in to view this quote. Like this. You have to un-protect the worksheet to edit uom.mpe caclulator.JPG Link to comment Share on other sites More sharing options...
[Da...] Posted October 20, 2023 Share Posted October 20, 2023 Please sign in to view this quote. Why not like this?: Link to comment Share on other sites More sharing options...
[To...] Posted October 20, 2023 Share Posted October 20, 2023 Please sign in to view this quote. Though it was not obvious, I was interpreting the Rick's question as ±3µm + 2/1000 Link to comment Share on other sites More sharing options...
[Ri...] Posted October 25, 2023 Share Posted October 25, 2023 Please sign in to view this quote. This is the actual formula for a B&S CMM. (2.00 + 3.00 * L/1000) I've never seen it this way. Typically, its: (2* L/1000) (Example) Link to comment Share on other sites More sharing options...
[To...] Posted October 27, 2023 Share Posted October 27, 2023 Please sign in to view this quote. I've only ever seen #.# + L / XXX Link to comment Share on other sites More sharing options...
[To...] Posted October 27, 2023 Share Posted October 27, 2023 Here's a related document by Herr Stauffer...CMM Accuracy Statements.pdf Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in