GRR计算表格模板

,,,,,,,,,,,,,,,,,

,,,,,电子股份有限公司,,,,,,PAGE,1,OF,1,,

,,,,,,,,,,,,,,,,,

,GAGER&R计算表格,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,设备名称:,,,二次元,,,实验次数:,,,3,,部门:,,品保中心,,

,设备标号:,,,CFBJ0092,,,测量人员:,,,3,,准备人:,,,,

,项目:,,,尺寸,,,测量单位:,,,检测中心,,日期:,,2014/3/25,,

,零部件编号:,,,/,,,公差:,,USL:,2.020,,效验:,,委外方,,

,零部件名称:,,,精密块规,,,,,LSL:,1.980,,日期:,,2013/3/28,,

,,,,,,,,,,,,,,,,,

,NO,,测量员A,,,,测量员B,,,,测量员C,,,,平均值,

,,,1st,2nd,3rd,范围,1st,2nd,3rd,范围,1st,2nd,3rd,范围,,

,,1,2.005,2.002,2.004,0.003,2.002,2.001,2.002,0.001,2.002,2.006,2.006,0.004,2.003,

,,2,2.005,2.005,2.002,0.003,2.004,2.005,2.002,0.003,2.004,2.002,2.007,0.005,2.004,

,,3,2.004,2.004,2.006,0.002,2.006,2.002,2.002,0.004,2.001,2.002,2.002,0.001,2.003,

,,4,2.007,2.007,2.007,0.000,2.008,2.002,2.007,0.006,2.006,2.001,2.002,0.005,2.005,

,,5,2.004,2.002,2.001,0.003,2.004,2.002,2.002,0.002,2.005,2.002,2.002,0.003,2.003,

,,6,2.009,2.009,2.009,0.000,2.002,2.002,2.004,0.002,2.005,2.004,2.002,0.003,2.005,

,,7,2.004,2.005,2.004,0.001,2.005,2.004,2.004,0.001,2.005,2.002,2.002,0.003,2.004,

,,8,2.004,2.004,2.004,0.000,2.004,2.004,2.004,0.000,2.004,2.004,2.004,0.000,2.004,

,,9,2.002,2.001,2.002,0.001,2.004,2.002,2.002,0.002,2.001,2.001,2.001,0.000,2.002,

,,10,2.003,2.003,2.003,0.000,1.999,2.003,2.003,0.004,1.999,2.003,2.003,0.004,2.002,

,,Average,XA=,2.004,RA=,0.001,XB=,2.003,RB=,0.003,XC=,2.003,RC=,0.003,Xmean=,2.004

,,,,,,,,,,,,,,,,,

,,Rmean=,{[RA=,0.001,]+[RB=,0.003,]+[RC=,0.003,]}/n=,0.002,,Trials,2,3,Rmean=,0.002

,,Xdiff=,[XMAX=,2.004,]-[XMIN=,2.003,]=,0.001,,,,D4,3.27,2.58,Xdiff=,0.001

,,UCLR=,[Rmean=,0.002,]x[D4=,2.58,]=,0.006,,,,,,,UCLR=,0.0058

,RangeTest:,,,RMAX,>,UCLRis,REJ,,,,,,,,RMAX=,0.0060

,Note:UCLRistheupperlimitofindividualRi.,,,,,,,,,,,,,,,

,"OnlyallRi<UCLRandtherangetestcanbeacceptable,otherwiserejectedandthefollowingcalculationisonlyforreference.",,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,测量系统分析（MeasuringSystemAnalysis）,,,,,,,,,,,%ToleranceAnalysis,,,,

,,,,,,,,,,,,,,,,,

,重复性-EquipmentVariation(EV),,,,,,,,,,,%EV=100[EV/T],,,,

,,EV=RmeanxK1,,,,,,,测量次数,2,3,=,17.029,%,,

,,=,0.007,,,,,,K1,4.56,3.05,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,再生性-Appraiservariation(AV),,,,,,,,,n=零部数目=,10,%AV=100[AV/T],,,,

,,AV=[(XdiffxK2)2-EV2/(nxr)]1/2,,,,,,,,r=测量次数=,3,=,8.566,%,,

,,=,0.003,,,,,,测量员数量,2,3,,,,,

,"Note:Ifanegativevalueiscalculatedunderthesquarerootsign,",,,,,,,,K2,3.65,2.70,,,,,

,,thenA.V.=0,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,重复性和再生性(R&R),,,,,,,,,,,%R&R=100[R&R/T],,,,

,,R&R=(EV2+AV2)1/2,,,,,,,,,,=,19.062,%,,

,,=,0.008,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,全程公差(T),,,,,,,,,,,Note:%GR&Rarebaseduponpredicting5.15d,,,,

,,T=USL-LSL,,,Bilateraltolerance,,,,,,,(99%oftheareaunderthenormaldistribution,,,,

,,T=2(USL-Xmean),,,"Unilateral,onlyupper",,,,T=,0.040,,curve),,,,

,,T=2(Xmean-LSL),,,"Unilateral,onlylower",,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,Criteria,,,,,,EV%,,AV%,,R&R%,,,结果,,

,接受,,,Lessthan10%,,,,,8.566,,,,,,,

,有條件接受,,,10-30%,,,17.029,,,,19.062,,,有條件接受,,

,不可接受,,,Greaterthan30%,,,,,,,,,,,,

,ActionforImprovement:,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,Non-QSControlForm,,

,,,,,,,,,,,,,,,,,

,Remark:,,,,,,,,,,,,,,,

,1.,"Forinformationonthetheoryandconstants