Dear Annulfo
1-Before I begin to ask your questions, I have to say that I am sorry about my mistake, those Comments were in Farsi (Iranian language) and I forgot to translate them to English. I have translated them for you in this attached file.
2- The criterions of decesioning in this spreadsheet are:
If %GR&R less than %10 Gage is acceptable
If %GR&R more than %30 Gage is not acceptable
If %GR&R more than %10 and less than %30 the spreadsheet will multiple RPN in %GR&R and calculate the breakpoint, if the result is less than 37.8 Gage is acceptable otherwise gage is not acceptable. This section of calculation is according to Delphi spreadsheet for PPAP. You can download it from Cove’s free files. (This spreadsheet is called Partcertall-6.06)
3- Your guess is true the RPN is Risk Priority Number you have to calculate the RPN for work/inspection station that you want to use the gage.
4- There are two sheets in this file and they are independent:
GR&R-WIV is for calculatin %GR&R according to with in part variation method.
GR&R-PtoP is for calculatin %GR&R according to part to part variation method.
5- I think that I have asked your fifth question in my second answer.
6- In with in part variation method, n is the number appraisers (for example 3) and r is the number of trials (for example 2) but in part to part variation n is the number of parts (for example 10) and r is the number of trials.
Finally I have to say that I have checked this file with MSA manual’s examples but I think it should be better that you check it again.
I am ready to answer to your question.
Yours truly,
Mansoor
Partcertall-6.06