最实用的MSA测量系统分析自动表格表格推荐下载.xlsx
- 文档编号:13184397
- 上传时间:2022-10-07
- 格式:XLSX
- 页数:4
- 大小:124.60KB
最实用的MSA测量系统分析自动表格表格推荐下载.xlsx
《最实用的MSA测量系统分析自动表格表格推荐下载.xlsx》由会员分享,可在线阅读,更多相关《最实用的MSA测量系统分析自动表格表格推荐下载.xlsx(4页珍藏版)》请在冰豆网上搜索。
均值图meanchart12345678910UCLx0.35100.35100.35100.35100.35100.35100.35100.35100.35100.3510LCLx-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481-0.3481UCLR0.87980.87980.87980.87980.87980.87980.87980.87980.87980.8798LCLR0.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000公差:
6pp变差PV1.104596PV1.1045961.104596PV1.104596TV0.000000TV0.000000#DIV/0!
TV1.146135基于公差baseonpartsspec%EV#DIV/0!
#DIV/0!
17.61%基于零件变差baseonpartsvariation%AV#DIV/0!
20.04%基于过程变差baseonprocessvariation%RR#DIV/0!
26.68%基于过程能力BaseonprocessPP%PV#DIV/0!
96.38%公式AFormulaAndc5.093692473公式BFormulaBX2/nkr0.0001878sumSQ(sum(men)/nr3.1674500SUMSQ(sum(1-10part)/kr88.3621222极差图RangechartSUMSQ(sum(men-part)/r91.8883667sumSQ(all)94.6473000n=partk=menr=timeANOVATableWithOperator*PartInteractionANOVATableWithoutOperator*PartInteractionSourceDFSSMSFPSourceDFSSMSFPParts988.361939.81799492.291420.00000Parts988.361939.81799245.613910.00000Operators23.167261.5836379.406050.00000Operators23.167261.5836339.617250.00000Operators*Part180.358980.019940.433720.97411Repeatability602.758930.04598Repeatability783.117920.03997Total8994.64711Total8994.64711GaugeR&
RWithOperator*PartInteractionGaugeR&
RWithoutOperator*PartInteractionSourceVarCompStdev%Contribution%TV%ToleranceSourceVarCompStdev%Contribution%TV%ToleranceTotalGaugeR&
R0.098110.313228.27%28.75%#DIV/0!
TotalGaugeR&
R0.091430.302377.76%27.86%#DIV/0!
Repeatability0.045980.214433.87%19.68%#DIV/0!
Repeatability0.039970.199933.39%18.42%#DIV/0!
Reproducibility0.052120.228304.39%20.96%#DIV/0!
Reproducibility0.051460.226844.37%20.90%#DIV/0!
Operator0.052120.228304.39%20.96%#DIV/0!
Operator0.051460.226844.37%20.90%#DIV/0!
Operators*Part0.000000.000000.00%0.00%#DIV/0!
Part-To-Part1.088671.0433991.73%95.78%#DIV/0!
Part-To-Part1.086451.0423392.24%96.04%#DIV/0!
AXARBXBRCX佃RPPXXnXxXRLX2RAXLX2RDL屒4吳-2.50000-2.00000-1.50000-1.00000-0.500000.000000.500001.000001.500002.000002.50000AUCLxLCLxBC0.00000.20000.40000.60000.80001.00001.2000CUCLRLCLRBARegularNewQCPPPAPOtherAppraisersRcRRbA/)(RPage:
1/4TotalVariation1.186781.08939100.00%100.00%#DIV/0!
TotalVariation1.177881.08530100.00%100.00%#DIV/0!
测测量量系系统统分分析析MSAGR&
R-均均值值极极差差法法AverageAverageandandmethodmethod报报告告编编号号ReportReportNO.NO.量具名称Equipment产品类型Description测量人员Operator测试日期TestTate1900/1/0量具编号EquipmentNO.基件编号PartNO.测量人员Operator平价人数Appraisers3参数规格Specification规格上限Upperlimit测量人员Operator试验次数Trials3测量单位UnitMM规格下限LowerLimit过程变差/过程能力ProcessVariation(/PP)样品数Samples10Datasheet:
0.3416670.4446673.511111分析方式Analysismode基基于于零零件件变变差差basebaseononpartspartsvariationvariation测量系统分析MSA%总变差Totalvariation(TV)重复性Repeatability设备变差EquipmentVariation(EV)=17.61%=0.201857试验次数TrialsK120.886230.5908再现性Reproducibility評价人变差AppraiserVariation(AV)=20.04%=0.229667评价人数AppraisersK220.707130.5231重复性和再现性RepeatabilityandReproducibility(R&
R)零件数量PartQTYK3=26.68%=0.30576630.523140.446750.4043零件变差PartsVariation(PV)60.3742公式AFormulaA70.3534=96.38%=1.10459680.337590.3249100.3146总变差TotalVariation(TV)有效分辨率AvailabilityResolution(NDC)=1.41*(PV/R&
R)基于零件变差Baseonpartsvariation=5=1.1
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 实用 MSA 测量 系统分析 自动 表格