APQP-PPAP-MSA测量系统分析自动表格GRR可编辑版本.xls

3 723 71.410 12345678910Total 1. A171.724471.685771.7058 71.70371.68271.724471.685771.705871.70371.682 717.0018 2.271.724771.686371.7035 71.698971.6821 71.724771.686371.703571.698971.6821 716.991 3.371.723071.685771.7029 71.702971.6834 71.723071.685771.702971.702971.6834716.9958 4.均值Mean 71.72403 71.68590 71.70407 71.70160 71.68250 71.72403 71.68590 71.70407 71.70160 71.6825071.699620 Sum A 215.1721 215.0577 215.1122 215.1048 215.0475 215.1721 215.0577 215.1122 215.1048 215.04752150.9886 5. 极差Range0.00170.00060.00290.00410.00140.00170.00060.00290.00410.00140.002140 6. B171.723371.689171.704671.7033 71.68371.723371.689171.704671.703371.683 717.0066 7.271.725671.688571.704371.7034 71.6845 71.725671.688571.704371.7034 71.6845 11.304 8.371.7251 71.691771.704671.703971.6829 71.725171.691771.704671.703971.6829717.0164 9.均值Mean 71.72467 71.68977 71.70450 71.70353 71.68347 71.72467 71.68977 71.70450 71.70353 71.6834771.701187 Sum B215.174215.0693 215.1135 215.1106 215.0504215.174215.0693 215.1135 215.1106 215.05042151.0356 10. 极差Range0.00320.00030.00060.00160.00230.00320.00030.00060.00160.001522 11. C171.7257 71.690171.701871.704471.6824 71.725771.690171.701871.704471.6824717.0088 12.271.7237 71.689671.701971.704571.6834 71.723771.689671.701971.704571.6834717.0062 13.371.724771.690471.7025 71.70471.684271.724771.690471.702571.70471.6842717.0116 14.均值Mean 71.72470 71.69003 71.70207 71.70430 71.68333 71.72470 71.69003 71.70207 71.70430 71.6833371.700887 Sum C 215.1741 215.0701 215.1062 215.1129215.05215.1741 215.0701 215.1062 215.1129215.052151.0266 15. 极差Range0.00200.00080.00070.00050.00180.00200.00080.00070.00050.00180.001160 71.724467 71.688567 71.703544 71.703144 71.683100 71.724467 71.688567 71.703544 71.703144 71.68310071.700564 645.520200645.197100645.331900645.328300645.147900645.520200645.197100645.331900645.328300645.1479006453.05080.041367 0.00160723 D43.272.575 71.7022090.004139D300 71.6989200.000000A21.881.023 12345678910 UCLx71.702271.702271.702271.702271.702271.702271.702271.702271.702271.7022 LCLx71.698971.698971.698971.698971.698971.698971.698971.698971.698971.6989 UCLR0.00410.00410.00410.00410.00410.00410.00410.00410.00410.0041 LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000 公差：6pp变差 PVPV0.013014PV TVTV#DIV/0!TV 基于公差base on parts spec %EV#DIV/0! 基于零件变差base on parts variation %AV#DIV/0! 基于过程变差base on process variation %RR#DIV/0! 基于过程能力Base on process PP %PV#DIV/0!公式A Formula A ndc14.77027381公式B Formula B X2/nkr 462687.3847487462687.3847902462687.4033932 462687.4035058462687.4035732 SourceDFSSMSFPSourceDFSSMSFP Parts90.018640.00207524.016570.0000090.018640.002071166.180210.00000 20.000040.000025.247340.0160220.000040.0000211.677760.00003 180.000070.000003.519300.00013 600.000070.00000780.000140.00000 Total890.01882890.01882 SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance 0.000000.001621.13%10.63%1.62%0.000000.001551.04% 10.18%1.55% 0.000000.001060.48%6.95%1.06%0.000000.001330.76%8.74%1.33% 0.000000.001230.65%8.04%1.23%0.000000.000800.27%5.22%0.80% 0.000000.000750.24%4.91%0.75%0.000000.000800.27%5.22%0.80% 0.000000.000970.41%6.37%0.97% 0.000230.0151698.87%99.43%15.16%0.000230.0151798.96% 99.48%15.17% 0.000230.01524100.00%100.00%15.24%0.000230.01524100.00%100.00%15.24% 测试日期 Test Tate 量具编号 Equipment NO. 基件编号 P/N 测量人员 Operator B 平价人数 Appraisers 测量系统分析测量系统分析MSA GR&R-数据记录表数据记录表 Data Worksheet 报告编号报告编号Report NO. 量具名称 Equipment Name 产品类型 Description 测量人员 Operator A 试验次数 Trials 单位 Unit MM 规格下限 LSL 过程变差/过程能力 Process Variation(/PP) 样 品 数 Samples 参数规格 Dimension 规格上限 USL 测量人员 Operator C 71.699580 71.700660 71.701260 71.701640 71.700880 71.700620 分析时机Analytical Occasion 零件编号Parts NO.平均值Average 71.700180 71.699100 sumSQ(sum(men)/nrSUMSQ(sum(1-10part)/kr 71.701160 零件均值 Parts Mean Total 试验次数Trials 0.001567 Part - To - PartPart - To - Part Total VariationTotal Variation 注:当分析结果超出要求后，利用均值极差图分析原因When analysis result is out of spec,need analyse the root cause by mean and range chart 。 均值图 mean chart 0.0130140.0130140.013014 0.1000000.0000000.013073 1.24%#DIV/0!9.50% #DIV/0!6.13% 13.01%#DIV/0!99.55% 0.95%#DIV/0!7.26% 0.80% Total Gauge R&RTotal Gauge R&R Repeatability Repeatability Operators Operators*Part RepeatabilityRepeatability Total SUMSQ(sum(men-part)/rsumSQ(all) n=part k=men r=time ANOVA Table With Operator*Part InteractionANOVA Table Without Operator*Part Interaction Parts Reproducibility Reproducibility Operator Operator Operators*Part 极差图 Range chart Operators Gauge R&R With Operator*Part InteractionGauge R&R Without Operator*Part Interaction = A X = A R = B X = B R = C X = C R =X = P R P X =-=XMinXMaxXDIFF =+=RAXUCLX 2 =-=RAXLCLX 2 =RDUCLR 4 =RDLCLR 3 71.66000 71.68000 71.70000 71.72000 71.74000 A UCLx LCLx B C 0.0000 0.0010 0.0020 0.0030 0.0040 0.0050 C UCLR LCLR B A Regular New QCP PPAP Other =+=AppraisersRcRRb A /)(R Page：1/6 测试 日期 1900/1/0 平价 人数 3 72 试验 次数 3 71.4 样 品 数 10 0.0016070.0015670.041367 分析方式Analysis mode 重复性Repeatability设备变差Equipment Variation(EV) = = 试验次数 Trials K1 20.8862 30.5908 再现性Reproducibility評价人变差Appraiser Variation(AV) = = 评价人数 Appraiser K2 20.7071 30.5231 重复性和再现性Repeatability and Reproducibility(R&R) 零件数量 Part QTY K3= = 30.5231 40.4467 50.4043 零件变差Parts Variation(PV)60.3742 70.3534= = 80.3375 90.3249 100.3146 总变差Total Variation(TV) = = 判定标准Decide Criterion 分析人Analyst日期Date 测量系统分析测量系统分析MSA GR&R-均值极差法Average and method均值极差法Average and method 量具编号 Equipment NO. 基件编号 Part NO. 测量人员 Operator B 报告编号报告编号Report NO. 量具名称 Equipment 产品类型 Description 测量人员 Operator A 测量单位 Unit MM 规格下限 Lower Limit 过程变差/过程能力 Process Variation( /PP) 参数规格 Specification 规格上限 Upper limit 测量人员 Operator C 6.13% 0.000801 9.50% 0.001242 Datasheet： 基于零件变差基于零件变差base on parts variation 测量系统分析MSA% 总变差Total variation（TV） 7.26% 0.000950 基于零件变差Base on parts variation15 0.013073基于过程变差Base on process variation 基于零件公差Base on parts spec 公式A Formula A99.55% 0.013014 有效分辨率Availability Resolution(NDC)=1.41*（PV/R&R） 分析评价措施 Analysis and action 基于过程能力Base on process PP 1) 0%R&R10%：量测系统状况良好Excellent； 判定Decide 良好良好Excellent 10%R&R30%：量测系统状况可以接收，但需改进Accepted but need improvement； 30%R&R100%：量测系统必须改进Rejected and must be improved 。 2) 数据分级数NDC经四舍五入取整后，必须大于或等于5 The NDC is truncated to the integer and ought to be greater than or equal to 5。 测量系统分析测量系统分析MSA GR&R-变差数分析法ANOVA method变差数分析法ANOVA method 报告编号报告编号Report NO. 1 KREV?= ()()nrEVKXAV DIFF / 2 2 2 -?= 22 &AVEVRR+= )/(100%TVEVEV?= )/(100%TVAVAV = )/&(100&%TVRRRR?= )/(100%TVPVPV?= =R = P R = XDIFF 3 PVKR p = 6/TolTV= =TV 22 PVR&RTV+= LSL)/6PP-USL(TV = 3 PVA KRp= GRRTV - = 2 PV B Page：2/6 测试 日期 1900/1/0 平价 人数 3 72 试验 次数 3 71.4 样 品 数 10 包含With 13.18741 1313 Note:Refer to above tables because P value of operator*Part is less than setting value 0.25 0.000 可接收Accepted 良好Excellent 结论 Result 分析人Analyst 量具名称 Equipment 产品类型 Description 测量人员 Operator A 参数规格 Specification 规格上限 Upper limit 测量人员 Operator C 测量单位 Unit MM 量具编号 Equipment NO. 基件编号 Part NO. 测量人员 Operator B 方差分析表格 ANOVA Table 操作员和零件的相互作用 Operator*Part Interaction 变差来源 Source 自由DF Degree of freedom 平方的总和SS Sum of squares 平均平方MS Mean square 规格下限 Lower Limit 过程变差 Process Variation(6) 0.0000 5.2473 评价者和零件Operators*Part180.0001 0.0000 3.5193 F-比率 F-ratio 有效分辨率Availabili ty Resolution(NDC)零件Parts90.0186 0.0021 524.0166 评价者Operators20.0000 变差来源 Source 变差估计值 Estimate of vaiance 标准偏差 Stdev%贡献率Contribution%总变差TV%公差Tolerance 设备Equipment600.0001 0.0000 汇总Total890.0188 重复性Repeatability0.0000 0.0011 0.48%6.95%1.06% 系统Total Gauge R&R0.0000 0.0016 1.13%1.13%10.63%10.63%1.62%1.62% 1.23% 评价者Operator0.0000 0.0007 0.24%4.91%0.75