MSA第四版_GRR表格

 测量系统分析MSA GR&R---数据记录表 Data Worksheet报告编号Report NO.量具名称Equipment Name量具编号Equipment NO.参数规格Dimension单位Unit分析时机Analytical Occasion零件编号Parts NO.1.A2.3.4.5.123均值Mean#DIV/0!Sum A 极差Range123均值Mean#DIV/0!Sum B10. 极差Range123均值MeanSum C15. 极差Range零件均值Parts Mean#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!#N/A0#N/A#DIV/0!0000#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!000000.0000000#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!00#DIV/0!0000.000012产品类型Description基件编号P/N规格上限USL规格下限LSL测量人员OperatorＡ测量人员OperatorＢ测量人员OperatorＣ过程变差/过程能力Process Variation(σ/PP)测试日期Test Tate平价人数Appraisers试验次数Trials样 品 数Samples10Regular34New QCP567PPAP8Other910Total000平均值Average#DIV/0!#DIV/0!#DIV/0!XA=#DIV/0!RA=0.000000#DIV/0!#DIV/0!#DIV/0!6.B7.8.9.XB=#DIV/0!RB=0.000000#DIV/0!#DIV/0!#DIV/0!11.C12.13.14.XC=#N/ARC=#N/AXPX=2D43.2701.88#DIV/0!Total0.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.0000000.000000R=(RA+Rb+Rc)/Appraisers=RP=#DIV/0!32.57501.023#N/A#DIV/0!试验次数TrialsXDIFF=MaxX-MinX=UCLX=X+A2R=#DIV/0!#DIV/0!UCLR=D4R=LCLR=D3R=#N/A#N/AD3A2LCLX=X-A2R= 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。12345678910#DIV/0!#DIV/0!#N/A#N/AA均值图meanchartUCLx1.00000 LCLxUCLR0.80000 LCLR0.60000 #DIV/0!#DIV/0!#N/A#N/A公差：#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A#DIV/0!#DIV/0!#N/A#N/A极差图RangechartUCLx#DIV/0!#DIV/0!#DIV/0!基于公差base on parts spec0.0000000.000000#N/A0.40000 LCLx#N/A#N/A#N/A%EV基于零件变差base on parts variation#DIV/0!#DIV/0!#DIV/0!%AVB基于过程能力Base on process PP#N/A#N/A#N/A%RR0.20000 #DIV/0!#DIV/0!#DIV/0!%PVC公式A Formula Andc#DIV/0!公式B Formula BsumSQ(sum(men))/nr#DIV/0!#DIV/0!#DIV/0!0.00000 X^2/nkrn=part k=men r=timesumSQ(all)SUMSQ(sum(men-part))/r#DIV/0!0.0000000ANOVA Table With Operator*Part InteractionANOVA Table Without Operator*Part InteractionSourceDFSSMSFPSourceDFSSMSFP1.0000 Parts9#DIV/0!#DIV/0!#DIV/0!#DIV/0!Parts9#DIV/0!#DIV/0!#DIV/0!#DIV/0!Operators-1#DIV/0!#DIV/0!#DIV/0!#DIV/0!Operators-1#DIV/0!#DIV/0!#DIV/0!#DIV/0!Operators*Part-9#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.8000 Repeatability0#DIV/0!#DIV/0!Repeatability-9#DIV/0!#DIV/0!CTotal-1#DIV/0!Total-1#DIV/0!0.6000 Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part InteractionUCLRSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotal Gauge R&R#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total Gauge R&R#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.4000 LCLR Repeatability#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! Repeatability#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! Reproducibility#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! Reproducibility#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!B Operator#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! Operator#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.2000 Operators*Part#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!APart - To - Part#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Part - To - Part#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.0000 PVTV6σPVTVpp变差#DIV/0!PV#DIV/0!TV#N/A#DIV/0!#N/A#DIV/0!#N/ASUMSQ(sum(1-10part))/kr基于过程变差base on process variationPage：1/4

Rangechart0.0000 Total Variation#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Total Variation#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! 测量系统分析MSA GR&R---均值极差法Average and method报告编号Report NO.量具名称Equipment量具编号Equipment NO.参数规格Specification测量单位UnitDatasheet：产品类型Description基件编号Part NO.规格上限Upper limit规格下限Lower Limit测量人员OperatorＡ测量人员OperatorＢ测量人员OperatorＣ过程变差/过程能力Process Variation(σ/PP)测试日期Test平价人数Appr试验次数Trials样 品数1900/1/00010R=#N/AXDIFF=#DIV/0!RP=#DIV/0!分析方式Analysis mode测量系统分析MSA重复性Repeatability－设备变差Equipment Variation(EV)基于零件变差base on parts variation% 总变差Total variation（TV）%EV=100´(EV/TV)= #N/A试验次数K1Trials20.886230.5908EV=R´K1= #N/A再现性Reproducibility－評价人变差Appraiser Variation(AV)AV=(XDIFF´K2)-EV/nr22()评价人数K2Appraise20.707130.5231%AV=100´(AV/TV)= #DIV/0!= #DIV/0!重复性和再现性Repeatability and Reproducibility(R&R)%R&R=100´(R&R/TV)零件数量K3Part30.5231450.44670.40430.37420.35340.33750.32490.3146有效分辨率Availability Resolution(NDC)=1.41*（PV/R&R）R&R=EV2+AV2= #N/A= #N/A零件变差Parts Variation(PV)6公式A Formula A78910PV=Rp´K3= #DIV/0!%PV=100´(PV/TV)= #DIV/0!A PV=Rp´K3B PV=TV2-GRR总变差Total Variation(TV)TV=R&R2+PV2=#N/A基于零件变差Base on parts variation基于过程变差Base on process variation=#DIV/0!TV=Tol/6 TV=基于零件公差Base on parts spec基于过程能力Base on process PPTV=(USL-LSL)/6PP判定标准Decide Criterion1) 0%<%R&R<10%：量测系统状况良好Excellent； 10%≤%R&R≤30%：量测系统状况可以接收，但需改进Accepted but need improvement；判定Decide#DIV/0!#DIV/0! 30%<%R&R<100%：量测系统必须改进Rejected and must be improved 。2) 数据分级数NDC经四舍五入取整后，必须大于或等于5 The NDC is truncated tothe integer and ought to be greater than or equal to 5。分析评价措施Analysis andactionPage：2/4

分析人Analyst日期Date 测量系统分析MSA GR&R---变差数分析法ANOVA method报告编号Report NO.量具名称Equipment量具编号Equipment NO.参数规格Specification测量单位Unit方差分析表格#DIV/0!ANOVA变差来源Source零件Parts评价者Operators评价者和零件Operators*Part产品类型Description基件编号Part NO.规格上限Upper limit规格下限Lower Limit操作员和零件的相互作用Operator*Part Interaction自由DF平方的总和SSDegree ofSum of squares#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!变差估计值Estimate of vaiance测量人员OperatorＡ测量人员OperatorＢ测量人员OperatorＣ过程变差Process Variation(6σ)测试日期平价人数试验次数样 品数1900/1/00010平均平方MSMean square#DIV/0!#DIV/0!#DIV/0!#DIV/0!F-比率F-ratio#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!标准偏差Stdev#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!有效分辨率AvailabilityResolution(NDC)设备Equipment汇总Total变差来源Source系统Total Gauge R&R重复性Repeatability再现性Reproducibility评价者Operator相互作用InteractionINT=0#DIV/0!#DIV/0!%贡献率Contribution%总变差TV%公差Tolerance#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!零件Part总变差Total Variation##人与零件相互作用分界 P值The interaction between Operator and part boundaries P value is0.25实际P值#DIV/0!Actual P Value变差比重Components of variation200%%贡献率Contribution%总变差TV0.00%0.00%0%系统Total Gauge R&R重复性Repeatability再现性Reproducibility零件Part 0%0.00%0.00%0%0.00%0.00%0%0.00%0.00%0%%公差ToleranceResponse by operator10.80.60.40.20Response by part1.0 %贡献率Contribution0.8 0.6 基于零件变差Base on parts variation基于公差Base on parts spec%总变差TV#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.4 0.2 0.0 ABC#DIV/0!#DIV/0!分析方法Analysis method分析评价措施Analysis andaction基于零件变差Base on partsvariation12345678910结论Result#DIV/0!Page：3/4