1) The following spreadsheet is used to calculate an Attribute GR&R Effectiveness, in which up to
100 samples can be evaluated, using 2 or 3 operators.
2) In the Data Entry worksheet fill in the appropriate information in the Scoring Report section and
enter the type of Attributes you are evaluating in the Attribute Legend section. YOU MUST ENTER
THE INFORMATION IN THE ATTRIBUTE LEGEND SECTION OR THE SPREADSHEET
WILL NOT WORK. First attribute MUST be the "good" result and second attribute
MUST be the "bad" result. The attributes can be either alpha or numeric, e.g. Yes, No; pass, fail;
go, stop; or 1, 2. You must be consistent throughout the form and spell properly, anything
will work as the spreadsheet compares what is in each cell.
3) If you or an expert has selected samples to be evaluated and you know what attributes these
samples are, enter this information in the Attribute sample column. This will enable you to determine
how well each operator can evaluate a set of samples against a known standard. You do not
need to enter information in this column for the spreadsheet to work.
4) You do not have to specify how many operators or the # of samples that you will be evaluating
during the test. Simply enter the data into the spreadsheet under the specific operator. Remember
the attributes must be spelled properly or the spreadsheet will not analyze the data correctly.