测量系统分析(xls)(1)

MEASUREMENTSYSTEMSANALYSIS-RANGEMETHOD测量系统分析-极差法编号:010801PartNo.&NameGageNameDate零件号/名称量具名称日期CharacleristicGageNo.PerformedBy被测参数量具编号操作者SpecificationGageType尺寸规格量具类型PART(零件)APPRAISERA(评价人A)APPRAISERB(评价人B)RANGE(极差)1#45.25345.253R1=02#45.24945.25R2=0.0013#45.25545.254R3=0.0014#45.25145.251R4=05#45.24945.246R5=0.003平均极差AVERAGERANGE(R)=ΣRi/5=0.0010GR&R=5.15(R)/d2=5.15(R)/1.19=0.0043过程变差PROCESSVARITION=*注：过程变差可用容差代替cansubstitutetoleranceforprocessvarition%GR&R=100[GR&R/ProcessVariation]=#DIV/0!%2001/8/11D45.237LM11910D913AMEASUREMENTSYSTEMSANALYSIS-GRAPHICALANALYSIS(X&R)测量系统分析-图表分析（X&R）编号:010901PartNo.&NameGageNameDate零件号/名称量具名称日期CharacleristicGageNo.PerformedBy被测参数量具编号LF-02-01操作者王娟、赵建乐、徐远涛SpecificationGageType尺寸规格量具类型APPRAISER(评价人)PART(零件)AVERAGETRIAL#(试验#)1#2#3#4#5#6#7#8#9#10#(平均值)10.982.081.661.321.061.151.11.061.061.05Xa1=1.2520A评价人20.972.061.631.321.051.121.11.071.051.05Xa2=1.242030.962.061.621.341.041.151.091.061.021.03Xa3=1.2370AVG.平均值0.9702.0671.6371.3271.0501.1401.0971.0631.0431.043Xa=1.2437RNG.极差0.02000.02000.04000.02000.02000.03000.01000.01000.04000.0200Ra=0.023010.982.051.671.331.011.010.990.990.991Xa1=1.202B评价人20.992.061.691.32110.990.9911Xa2=1.20430.992.051.671.3310.990.980.9810.99Xa3=1.198AVG.平均值0.9872.0531.6771.3271.0031.0000.9870.9870.9970.997Xb=1.2013RNG.极差0.01000.01000.02000.01000.01000.02000.01000.01000.01000.0100Rb=0.012112.091.671.261.141.041.011.011.011.02Xc1=1.225C评价人212.071.681.31.151.021.021.031.011.01Xc2=1.22931.012.051.71.31.121.021.011.011.021.02Xc3=1.226AVG.平均值1.0032.0701.6831.2871.1371.0271.0131.0171.0131.017Xc=1.2267RNG.极差0.01000.04000.03000.04000.03000.02000.01000.02000.01000.0100Rc=0.0220Fromdatasheet:Appraisernumber=3Trialnumber=3来自数据表：评价人数量试验次数R=0.0190X=1.2239LCLr=RXD3=0.0000UCLr=RXD4=0.0489LCLx=X-A2R=1.2045UCLx=X+A2R=1.2433Trials试验次数A2D3D421.88003.26731.02302.575RepeatabilityRangeControlChart2001/9/11△Cir41.349BLM67048动态波纹度仪重复性极差控制图编号:010901Part1:DataforRepeatabilityRangeControlChart重复性极差控制图数据表1＃2＃3＃4＃5＃6＃7＃8＃9＃10＃Ra0.02000.02000.04000.02000.02000.03000.01000.01000.04000.0200Rb0.01000.01000.02000.01000.01000.02000.01000.01000.01000.0100Rc0.01000.04000.03000.04000.03000.02000.01000.02000.01000.0100UCLr0.04890.04890.04890.04890.04890.04890.04890.04890.04890.0489LCLr0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000R0.01900.01900.01900.01900.01900.01900.01900.01900.01900.0190Part2:RepeatabilityRangeControlChart重复性极差控制图PartAppraiserAverageChart0.00000.01000.02000.03000.04000.05000.06001＃2＃3＃4＃5＃6＃7＃8＃9＃10＃RaRbRcUCLrLCLrR零件评价人平均值图编号:0003Part1:DataforPartAppraiserAverageChart零件评价人平均值图数据表1＃2＃3＃4＃5＃6＃7＃8＃9＃10＃Xa0.9702.0671.6371.3271.0501.1401.0971.0631.0431.043Xb0.9872.0531.6771.3271.0031.0000.9870.9870.9970.997Xc1.0032.0701.6831.2871.1371.0271.0131.0171.0131.017UCLx1.2431.2431.2431.2431.2431.2431.2431.2431.2431.243LCLx1.2041.2041.2041.2041.2041.2041.2041.2041.2041.204X1.2241.2241.2241.2241.2241.2241.2241.2241.2241.224Part2:PartAppraiserAverageChart零件评价人平均值图0.0000.5001.0001.5002.0002.5001＃3＃5＃7＃9＃XaXbXcUCLxLCLxXGAGEREPEATABILITYANDREPRODUCIBILITYDATASHEET量具重复性和再现性数据表编号:010901APPRAISER(评价人)PART(零件)AVERAGETRIAL#(试验#)1#2#3#4#5#6#7#8#9#10#(平均值)10.982.081.661.321.061.151.11.061.061.05Xa1=1.2520A评价人20.972.061.631.321.051.121.11.071.051.05Xa2=1.242030.962.061.621.341.041.151.091.061.021.03Xa3=1.2370AVG.平均值0.9702.0671.6371.3271.0501.1401.0971.0631.0431.043Xa=1.2437RNG.极差0.02000.02000.04000.02000.02000.03000.01000.01000.04000.0200Ra=0.023010.982.051.671.331.011.010.990.990.991Xa1=1.202B评价人20.992.061.691.32110.990.9911Xa2=1.20430.992.051.671.3310.990.980.9810.99Xa3=1.198AVG.平均值0.9872.0531.6771.3271.0031.0000.9870.9870.9970.997Xb=1.2013RNG.极差0.01000.01000.02000.01000.01000.02000.01000.01000.01000.0100Rb=0.012112.091.671.261.141.041.011.011.011.02Xc1=1.225C评价人212.071.681.31.151.021.021.031.011.01Xc2=1.22931.012.051.71.31.121.021.011.011.021.02Xc3=1.226AVG.平均值1.0032.0701.6831.2871.1371.0271.0131.0171.0131.017Xc=1.2267RNG.极差0.01000.04000.03000.04000.03000.02000.01000.02000.01000.0100Rc=0.0220PARTAVG.0.9872.0631.6661.3131.0631.0561.0321.0221.0181.019Xp=1.2239零件平均值Rp=1.0767Fromdatasheet:Appraisernumber=3Trialnumber=3来自数据表：评价人数量试验次数R=0.01900Xdiff=Xmax-Xmin=0.0423Rp=1.0767UCLr=(R)X(D4)=0.04902Trials试验次数23D43.272.58--------------------------------------------------------------------------------------------------------------------------------------------UCLrrepresentsthelimitofindividualR's.Circlethosethatarebeyondthislimit.Identifythecauseandcorrect.RepeatthesereadingsusingthesameappraiserandunitasoriginallyusedordiscardvaluesandreaverageandrecomputeRandthelimitingvaluefromtheremainingobservations.UCLr表示各个R的上控制限，圈出那些超过控制限的R，找出原因并予改正。重复进行这些读数，且使用原来的检验者和单元；或者废除这些值，根据余下的观察值重新进行平均和计算R及极限值。GAGEREPEATABILITYANDREPRODUCIBILITYREPORT量具重复性和再现性报告编号:010901PartNo.&NameGageNameDate零件号/名称量具名称日期CharacleristicGageNo.PerformedBy被测参数量具编号操作者SpecificationGageType尺寸规格量具类型Fromdatasheet:来自数据表：R=0.01900Xdiff=0.04233Rp=1.0767--------------------------------------------------------------------------------------------