MSA测量系统分析自动表格

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

2016/4/1137.835.41012345678910Total1.A17.297.277.137.217.287.367.257.047.007.1071.932.27.287.267.127.227.287.357.267.037.017.0771.883.37.297.267.147.217.297.367.257.067.017.0871.954.均值Mean7.286677.263337.130007.213337.283337.356677.253337.043337.006677.083337.192000SumA21.8621.7921.3921.6421.8522.0721.7621.1321.0221.25215.76005.极差Range0.010.010.020.010.010.010.010.030.010.030.0150006.B17.187.267.207.287.157.347.277.066.916.9371.587.27.167.257.207.287.157.347.257.056.916.9511.3048.37.187.267.217.267.147.337.267.066.946.9571.599.均值Mean7.173337.256677.203337.273337.146677.336677.260007.056676.920006.943337.157000SumB21.5221.7721.6121.8221.4422.0121.7821.1720.7620.83214.710010.极差Range0.020.010.010.020.010.010.020.010.030.020.01600011.C16.977.267.187.167.087.407.297.186.966.8071.2812.26.957.257.187.147.077.387.297.186.986.8571.2713.36.947.267.167.157.067.377.277.176.966.8371.1714.均值Mean6.953337.256677.173337.150007.070007.383337.283337.176676.966676.826677.124000SumC20.8621.7721.5221.4521.2122.1521.8521.5320.920.48213.7215.极差Range0.03000.01000.02000.02000.02000.03000.02000.01000.02000.05000.0230007.1377787.2588897.1688897.2122227.1666677.3588897.2655567.0922226.9644446.9511117.15766764.24000065.33000064.52000064.91000064.50000066.23000065.39000063.83000062.68000062.560000644.190.4077780.01800023D43.272.5757.1760810.046350D3007.1392530.000000A21.881.02312345678910UCLx7.17617.17617.17617.17617.17617.17617.17617.17617.17617.1761LCLx7.13937.13937.13937.13937.13937.13937.13937.13937.13937.1393UCLR0.04630.04630.04630.04630.04630.04630.04630.04630.04630.0463LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差:6σpp变差PVPV0.128287PVTVTV#DIV/0!TV基于公差baseonpartsspec%EV#DIV/0!基于零件变差baseonpartsvariation%AV#DIV/0!基于过程变差baseonprocessvariation%RR#DIV/0!基于过程能力BaseonprocessPP%PV#DIV/0!公式AFormulaAndc4.878797653公式BFormulaBX^2/nkr4610.89729004610.96667004612.24943334612.67043334612.6775000SourceDFSSMSFPSourceDFSSMSFPParts91.352140.150247.690940.0001391.352140.1502432.670790.0000020.069380.034691.775840.1977520.069380.034697.543690.00094180.351620.01953165.858490.00000600.007070.00012780.358690.00460Total891.78021891.78021SourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%Tolerance0.007100.0842332.82%57.29%21.06%0.005600.0748425.71%50.71%18.71%0.000120.010850.54%7.38%2.71%0.004600.0678121.11%45.95%16.95%0.006980.0835332.28%56.81%20.88%0.001000.031674.60%21.46%7.92%0.000510.022482.34%15.29%5.62%0.001000.031674.60%21.46%7.92%0.006470.0804529.94%54.72%20.11%0.014520.1205167.18%81.96%30.13%0.016180.1272174.29%86.19%31.80%极差图RangechartOperatorsGaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionReproducibilityReproducibilityOperatorOperatorOperators*PartSUMSQ(sum(men-part))/rsumSQ(all)n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionPartsTotalGaugeR&RTotalGaugeR&RRepeatabilityRepeatabilityOperatorsOperators*PartRepeatabilityRepeatabilityTotal32.07%#DIV/0!96.07%2.66%#DIV/0!7.96%8.88%0.1282870.1282870.4000000.0000000.1335379.27%#DIV/0!27.76%0.068000Part-To-PartPart-To-Part注:当分析结果超出要求后,利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。均值图meanchart0.128287#DIV/0!26.60%sumSQ(sum(men))/nrSUMSQ(sum(1-10part))/kr7.117000零件均值PartsMeanTotal试验次数Trials分析时机AnalyticalOccasion零件编号PartsNO.平均值Average7.1930007.1880007.1950007.1580007.1540007.1590007.1280007.127000参数规格Dimension6.8规格上限USL测量人员OperatorCC试验次数Trials单位UnituM规格下限LSL过程变差/过程能力ProcessVariation(σ/PP)样品数Samples测量系统分析MSAGR&R---数据记录表DataWorksheet报告编号ReportNO.量具名称EquipmentName锡厚3D测试仪产品类型DescriptionPCBA测量人员OperatorAA测试日期TestTate量具编号EquipmentNO.SMT0001基件编号P/N12511820B-23测量人员OperatorBB平价人数Appraisers=AX=AR=BX=BR=CX=CR=X=PRPX=-=XMinXMaxXDIFF=+=RAXUCLX2=-=RAXLCLX2==RDUCLR4==RDLCLR36.400006.600006.800007.000007.200007.400007.60000AUCLxLCLxBC0.00000.01000.02000.03000.04000.05000.0600CUCLRLCLRBARegularNewQCPPPAPOther=++=AppraisersRcRRbA/)(RPage:1/40.021620.14703100.00%100.00%36.76%0.021780.14759100.00%100.00%36.90%测试日期Test2016/4/11平价人数Appr37.8试验次数Trials35.4样品数100.0180000.0680000.407778分析方式Analysismode重复性Repeatability-设备变差EquipmentVariation(EV)==试验次数TrialsK120.886230.5908再现性Reproducibility-評价人变差AppraiserVariation(AV)==评价人数AppraiseK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartK3==30.523140.446750.4043零件变差PartsVariation(PV)60.374270.3534==80.337590.3249100.3146总变差TotalVariation(TV)==判定标准DecideCriterion基于过程能力BaseonprocessPP1)   0%%R&R10%:量测系统状况良好Excellent;判定Decide可接收Accepted10%≤%R&R≤30%:量测系统状况可以接收,但需改进Acceptedbutneedimprovement;30%%R&R100%:量测系统必须改进Rejectedandmustbeimproved。2)数据分级数NDC经四舍五入取整后,必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。分析评价措施Analysisandaction公式AFormulaA96.07%0.128287有效分辨率AvailabilityResolution(NDC)=1.41*(PV/R&R)基于零件变差Baseonpartsvariation50.133537基于过程变差Baseonprocessvariation基于零件公差BaseonpartsspecDatasheet:基于零件变差baseonpartsvariation测量系统分析MSA%总变差Totalvariation(TV)7.96%0.01063426.60%0.03551827.76%0.037076参数规格Speci

1 / 4
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功