MSA测量系统分析表格.xlsx
- 文档编号:1375313
- 上传时间:2023-04-30
- 格式:XLSX
- 页数:3
- 大小:125.13KB
MSA测量系统分析表格.xlsx
《MSA测量系统分析表格.xlsx》由会员分享,可在线阅读,更多相关《MSA测量系统分析表格.xlsx(3页珍藏版)》请在冰点文库上搜索。
测测量量系系统统分分析析MSAGR&R-数数据据记记录录表表DataWorksheet报报告告编编号号ReportNO.QAC-001/20150127量具名称EquipmentName电阻测量工装产品类型Description电阻应变计测量人员Operator李永江测试日期TestTate2015.1.27量具编号EquipmentNO.D6123679CD251/001-085基件编号P/N测量人员Operator程静娅平价人数Appraisers3参数规格Dimension规格上限USL测量人员Operator冯博试验次数Trials3单位Unit规格下限LSL过程变差/过程能力ProcessVariation(/PP)样品数Samples10分析时机AnalyticalOccasion零件编号PartsNO.12345678910Total平均值Average1.A1350.41350.06349.8349.8349.78349.91349.94349.89349.8349.83499.19349.9190002.2350.41350.02349.77349.78349.78349.93349.94349.91349.8349.833499.17349.9170003.3350.41350.04349.78349.78349.76349.92349.97349.92349.8349.833499.21349.9210004.均值Mean350.41000350.04000349.78333349.78667349.77333349.92000349.95000349.90667349.80000349.82000349.919000SumA1051.231050.121049.351049.361049.321049.761049.851049.721049.41049.4610497.57005.极差Range00.040.030.020.020.020.030.0300.030.0220006.B1350.36350.04349.76349.78349.78349.91349.9349.87349.78349.793498.97349.8970007.2350.4350.04349.8349.77349.77349.92349.91349.88349.77349.811.304349.9060008.3350.39350.02349.82349.8349.81349.87349.92349.86349.84349.783499.11349.9110009.均值Mean350.38333350.03333349.79333349.78333349.78667349.90000349.91000349.87000349.79667349.79000349.904667SumB1051.151050.11049.381049.351049.361049.71049.731049.611049.391049.3710497.140010.极差Range0.040.020.060.030.040.050.020.020.070.020.03700011.C1350.35350349.78349.77349.76349.94349.95349.9349.79349.853499.09349.90900012.2350.36350.01349.77349.78349.78349.92349.96349.93349.81349.813499.13349.91300013.3350.36350.02349.77349.75349.73349.89349.94349.89349.79349.823498.96349.89600014.均值Mean350.35667350.01000349.77333349.76667349.75667349.91667349.95000349.90667349.79667349.82667349.906000SumC1051.071050.031049.321049.31049.271049.751049.851049.721049.391049.4810497.1815.极差Range0.01000.02000.01000.03000.05000.05000.02000.04000.02000.04000.029000零件均值PartsMean350.383333350.027778349.783333349.778889349.772222349.912222349.936667349.894444349.797778349.812222349.909889Total3153.4500003150.2500003148.0500003148.0100003147.9500003149.2100003149.4300003149.0500003148.1800003148.31000031491.890.6111110.029333试验次数Trials230.014333D43.272.575349.9398970.075533D300349.8798810.000000A21.881.023注:
当分析结果超出要求后,利用均值极差图分析原因Whenanalysisresultisoutofspec,needanalysetherootcausebymeanandrangechart。
均值图meanchart12345678910UCLx349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399349.9399LCLx349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799349.8799UCLR0.07550.07550.07550.07550.07550.07550.07550.07550.07550.0755LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差:
6pp变差PV0.192256PV0.1922560.192256PV0.192256TV0.000000TV0.000000#DIV/0!
TV0.193155基于公差baseonpartsspec%EV#DIV/0!
#DIV/0!
#DIV/0!
8.97%基于零件变差baseonpartsvariation%AV#DIV/0!
#DIV/0!
#DIV/0!
3.52%基于过程变差baseonprocessvariation%RR#DIV/0!
#DIV/0!
#DIV/0!
9.64%基于过程能力BaseonprocessPP%PV#DIV/0!
#DIV/0!
#DIV/0!
99.53%公式AFormulaAndc14.56203294公式BFormulaBX2/nkr11019323.7308011sumSQ(sum(men)/nr11019323.7345633SUMSQ(sum(1-10part)/kr11019326.5500111极差图RangechartSUMSQ(sum(men-part)/r11019326.5673000sumSQ(all)11019326.5857000n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionSourceDFSSMSFPSourceDFSSMSFPParts92.819210.31325416.837410.00000Parts92.819210.31325765.289990.00000Operators20.003760.001882.503200.10985Operators20.003760.001884.595740.01261Operators*Part180.013530.000752.450480.00499Repeatability600.018400.00031Repeatability780.031930.00041Total892.85490Total892.85490GaugeR&RWithOperator*PartInteractionGaugeR&RWithoutOperator*PartInteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&R0.000490.022191.40%11.83%#DIV/0!
TotalGaugeR&R0.000460.021411.30%11.41%#DIV/0!
Repeatability0.000310.017510.87%9.33%#DIV/0!
Repeatability0.000410.020231.16%10.78%#DIV/0!
Reproducibility0.000190.013640.53%7.27%#DIV/0!
Reproducibility0.000050.007000.14%3.73%#DIV/0!
Operator0.000040.006140.11%3.27%#DIV/0!
Operator0.000050.007000.14%3.73%#DIV/0!
Operators*Part0.000150.012180.42%6.49%#DIV/0!
Part-To-Part0.034720.1863498.60%99.30%#DIV/0!
Part-To-Part0.034760.1864498.70%99.35%#DIV/0!
TotalVariation0.035210.18765100.00%100.00%#DIV/0!
TotalVariation0.035220.18766100.00%100.00%#DIV/0!
AXARBXBRCX佃RPPXXnXxXRLX2RAXLX2RDL屒4吳349.40000349.60000349.80000350.00000350.20000350.40000350.60000AUCLxLCLxBC0.00000.01000.02000.03000.04000.05000.06000.07000.0800CUCLRLCLRBARegularNewQCPPPAPOtherAppraisersRcRRbA/)(RPage:
1/3测测量量系系统统分分析析MSAGR&R-均均值值极极差差法法AverageAverageandandmethodmethod报报告告编编号号ReportReportNO.NO.QAC-001/20150127量具名称Equipment电阻测量工装产品类型Description电阻应变计测量人员Operator李永江测试日期TestTate2015.1.27量具编号EquipmentNO.D6123679CD251/001-085基件编号PartNO.测量人员Operator程静娅平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator冯博试验次数Trials3测量单位Unit规格下限LowerLimit过程变差/过程能力ProcessVariation(/PP)样品数Samples10Datasheet:
0.0293330.0143330.611111分析方式Analysismode基基于于零零件件变变差差basebaseononpartspartsvariationvariation测量系统分析MSA%总变差Totalvariation(TV)重复性Repeatability设备变差EquipmentVariation(EV)=8.97%=0.017330试验次数TrialsK120.886230.5908再现性Reproducibility評价人变差AppraiserVariation(AV)=3.52%=0.006797评价人数AppraisersK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&R)零件数量PartQTYK3=9.64%=0.01861630.523140.446750.4043零件变差PartsVariation(PV)60.3742公式AFormulaA70.3534=99.53%=0.19225680.337590.3249100.3146总变差TotalVariation(TV)有效分辨率AvailabilityResolution(NDC)=1.41*(PV/R&R)基于零件变差Baseonpartsvariation=15=0.193155基于过程变差Baseonprocessvariation基于零件公差Baseonpartsspec基于过程能力BaseonprocessPP判定标准DecideCriterion1)0%R&R10%:
量测系统状况良好Excellent;判定Decide良良好好ExcellentExcellent10%R&R30%:
量测系统状况可以接收,但需改进Acceptedbutneedimprovement;30%R&R100%:
量测系统必须改进Rejectedandmustbeimproved。
2)数据分级数NDC经四舍五入取整后,必须大于或等于5TheNDCistruncatedtotheintegerandoughttobegreaterthanorequalto5。
分析评价措施Analysisandaction高精度数字万用表D612367与测阻夹9CD251/001-085重复性及再现性良好,完成能满足试验要求。
分析人Analyst李永江日期Date2015.1.27倱楋R噅(牮臶K噁/2222&噁池噅偬汒汒)/(0%噔噅噅琩琯琨氥噔瑬噁硴噁汸)/&(0&%噔RRRR)/(0%噔噐噐RPXDIFF3PVKRp6/TolTVTV22PVR&RTVLSL)/6PP-USL(TV3PVAKRpGRRTV2PVBPage:
2/3测测量量系系统统分分析析MSAGR&R-变变差差数数分分析析法法ANOVAANOVAmethodmethod报报告告编编号号ReportReportNO.NO.QAC-001/20150127量具名称Equipment电阻测量工装产品类型Description电阻应变计测量人员Operator李永江测试日期TestTate2015.1.27量具编号EquipmentNO.D6123679CD251/001-085基件编号PartNO.测量人员Operator程静娅平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator冯博试验次数Trials3测量单位Unit规格下限LowerLimit过程变差ProcessVariation(6)样品数Samples10方差分析表格ANOVATable包含With操作员和零件的相互作用Operator*PartInteraction变差来源Source自由DFDegreeoffreedom平方的总和SSSumofsquares平均平方MSMeansquareF-比率F-ratio有效分辨率AvailabilityResolution(NDC)零件Parts92.81920.3132416.8374评价者Operators20.00380.00192.5032评价者和零件Operators*Part180.01350.00082.4505设备Equipment600.01840.000311.837901111汇总Total892.8549变差来源Source变差估计值Estimateofvaiance标准偏差Stdev%贡献率Contribution%总变差TV%公差Tolerance系统TotalGaugeR&R0.00050.02221.40%1.40%11.83%11.83%#DIV/0!
#DIV/0!
重复性Repeatability0.00030.01750.87%9.33%#DIV/0!
再现性Reproducibility0.00020.01360.53%7.27%#DIV/0!
评价者Operator0.00000.00610.11%3.27%#DIV/0!
相互作用InteractionINT=000000零件Part0.03470.186398.60%99.30%#DIV/0!
总变差TotalVariation0.03520.1877100.00%100.00%#DIV/0!
Note:
RefertoabovetablesbecausePvalueofoperator*Partislessthansettingvalue人与零件相互作用分界P值TheinteractionbetweenOperatorandpartboundariesPvalueis0.25实际P值ActualPValue0.005基于零件变差Baseonpartsvariation%贡献率Contribution%总变差TV1.40%11.83%基于公差Baseonpartsspec1.40%#DIV/0!
可接收Accepted#DIV/0!
分析方法Analysismethod基于零件变差Baseonpartsvariation结论Result可接收Accepted分析评价措施Analysisandaction分析人Analyst日期Date1.40%0.87%0.53%98.60%11.83%9.33%7.27%99.30%0%0%0%0%变差比重Componentsofvariation系统TotalGaugeR&R重复性Repeatability再现性Reproducibility零件Part0%200%贡献率Contribution%总变差TV%公差ToleranceResponsebypart12345678910349.7349.8349.9350.0350.1350.2350.3350.4350.5ResponsebyoperatorABC349.4349.6349.8350350.2350.4350.6Page:
3/3
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- MSA 测量 系统分析 表格