检具重复性，再现性Gage RR1.xlsVIP

GAGERR UnderTheHood A_ALCL .00 .00 1.00 A_AUCL .00 .00 1.00 A_Ave .00 .00 A_Range .00 .00 A_Rbar .00 .00 1.00 A_RUCL .00 .00 1.00 A_Xbar .00 .00 1.00 Ax_Range .00 .00 B_ALCL .00 .00 1.00 B_AUCL .00 .00 1.00 B_Ave 9.00 .00 1.00 B_Range 9.00 .00 1.00 B_Rbar .00 .00 1.00 B_RUCL .00 .00 1.00 B_Xbar .00 .00 1.00 Bx_Range .00 .00 C_ALCL .00 .00 1.00 C_AUCL .00 .00 1.00 C_Ave 18.00 .00 2.00 C_Range 18.00 .00 2.00 C_Rbar .00 .00 1.00 C_RUCL .00 .00 1.00 C_Xbar .00 .00 1.00 Cx_Range .00 .00 X_Range A_xRange B_xRange SAMPLE SIZE APPRAISERS TRIALS Appraiser/ Trail # AVG A AVGS Xa Range Ra B Xb Rb C Xc Rc Part X Average Rp Instructions说明: 1) Add reference information to cells highlighted in light yellow:请完成浅黄色区域的信息 2) Add required information to all cells highlighted in gold:请完成金色区域的信息 Note: Sample data is only required for the number of samples and trials actually run - you may leave some gold boxes empty.样品数据只是针对样品数量和实际生产的数量-你们可以留一些金色区域的地方不填 3) Results are shown in cells highlighted in light blue: 浅蓝色区域是显示的结果 4) Manually adjust the scale on the Averages Chart so the control limits are wide enough to see the variation. 请调整好每个区域的格式，以便能足够的宽来显示变化 Note:You may unprotect this worksheet should you wish to modify it: select Tools, then Protection, then Unprotect Sheet MEASUREMENT SYSTEMS ANALYSIS 测量系统分析 REPEATABILITY - EQUIPMENT VARIATION (EV) REPEATABILITY REPRODUCIBILITY 重复性生产重复性 DATE日期 REPRODUCIBILITY - APPRAISER VARIATION (AV) REPEATABILITY REPRODUCIBILITY (RR) GAGE NAME 检具名称 CHARACTERISTIC 特征 PART VARIATION (PV) TOTAL VARIATION (TV) GAGE TYPE 检具类型 SPECIFICATION 规格 GAGE NUMBER 检具编号 TEST NUMBER 测试编号 n / TV n / Tol EV APPRAISER A NAME 评价者A姓名 APPRAISER B NAME 评价者B姓名 AV RR SAMPLE SIZE 样品尺寸 APPRAISERS 评价者 APPRAISER C NAME 评价者C名字 PV TRIALS 试验 TV Trial # Rp RANGE VARIATION # Trials D4 Rdoublebar x (D4) = UCLR Note: LCL is zero with 8 trials SUM Rdoublebar A2 Xbar + ( Rbar x A2) UCLX Xbar - LCLX Max.