X-bar and R charts are useful control charts for use with rational subgroups. X-bar measure between-sample variation. R charts measure within-sample variation. All processes vary. The data you collect ...

One way to improve your spreadsheet is to present data in chart form, and Excel is a great program for doing just this.