I am currently using an excel spreadsheet to calculate the results of an MSA. I am looking for software to spread up my process and I am currently trialing JMP. The calculations I am using in my spreadsheet are from the EMP III book by Donald Wheeler. My problem is that my spreadsheet repeatability and reproducibility results don't marry up with any of the JMP analysis options - Variance Components, EMP Gauge R&R results or Gauge R&R - despite getting the same average range, average, and control limits (on both the average range change and the range chart). I am wondering if I am using the wrong bias correction factors or the wrong formulas. I have attached my excel spreadsheet. Any help to understand the difference would be much appreciated. Thank you!