Okay, firstly I would highly recommend you get rid of any excel spreadsheets for GRR, I found roughly 6 different GRR’s forms and all gave different results and as the AIAG doesn’t recommend any spreadsheet per say, well you have no correct Spreadsheet or bad Spreadsheet.
Secondly, I have let to see a spreadsheet that will do single sided tolerances. When you enter the product (feature) tolerance you enter the total tolerance (+/-0,010mm would be entered as 0,020mm in the relevant cell) and the calculations are straight forward.
However if the same tolerance is used (+0,020mm) the spreadsheet automatically thinks you mean +/-0,010 and so it will calculate readings accordingly. So lets say on average, readings are mid limit to the 0,020mm single sided tolerance (perhaps how you would like them) the spreadsheet things the results are actually on the top limit, so you end up with really bad GRR results.
In Minitab, you have the option to enter single sided tolerances and the results are massively different as Minitab is calculating the readings based on single sided tolerance.
I had the same problem when choosing a suitable method of hole position measurement, as hole position GD&T callouts are diametric and not the previous standard of +/-. I couldn’t find a measurement device that had a good enough GRR result until I used Minitab. Minitab is my best tool and its soooo cheap to buy!
Regards
Lee01