MSA-GRR数据自动生成工具演示教学

,,,,,,,,,,,,,

,GageR&RLong(x-BarRange)Method-3Trials,,,,,,,,,,,

,,,,,,,,,,,,,

Date:,,>>>>,2006.12.25,,,,,,,,,

日期,,,,,,,,,,,,

PerformedBy:,,>>>>,韦云刘忠云丁德利,,,Dept.,,>>>>,质量部,,,

完成人,,,,,,部门,,,,,,

PartNo.&Name:,,>>>>,DQG128点火线圈,,,GageName:,,>>>>,卡尺,,,

零件编号和名称,,,,,,量具名称,,,,,,

CharacteristicMeasured:,,>>>>,长度,,,GageNo.:,,>>>>,JW023,,,

测试特性,,,,,,量具号,,,,,,

TotalTolerence=,,>>>>,76.5,80.5,,Gagetype:,,>>>>,计量,,,

总偏差,,,,,,量具类型,,,,,,

ResultsSummary:,,Variationintotalmeasurementsystem-SeeMSAreferencemanual,,,,,,,,,,

结果总概,,在测量系统中全部的变量可参看MSA参考手册,,,,,,,,,,

,,,E.V.=,3.1%,,,,R&R=,3.2%,,,

,,,A.V.=,0.7%,,,,PV=,99.9%,,,

,,R&R/Tolerence-Seeacceptanceguidelinesbelow.,,,,,,,,,,

,,R&R/,偏差-查看如下可接受输入数据的指导,,,,,,,,,

,,,E.V.=,0.18%,,A.V.=,0%,,R&R=,0.19%,,

,,,,,,,,,,,,,

ApprovedBy:,>>>>,证实人,,,,,Date:,>>>>,,,,

证实人,,,,,,,日期,,,,,

Gageaccepted:,>>>>,Yes,√,,,,,,,,,

接受量具,,No,,,,,,,,,,

,,,,,,,,,,,,,

Significantfactorstoconsiderbeforestartingstudy,,,,,,,,,,,,CHECK

开始研究前，必须考虑的重要因素,,,,,,,,,,,,检查

1,Whenpossiblesamplepartsshouldbeselectedfromtheprocessandrepresentitsentire,,,,,,,,,,,

,operatingrange.(1or2partsrandomlyselectedperdayuntilsufficientpartsarecollected).,,,,,,,,,,,

,尽可能从工艺流程中选取，并且要能代表该零件的整个工艺过程的各特性（每天随机抽取1到2个零件，直至收集到足够的零件）,,,,,,,,,,,

2,Partsmustbeidentified.,,,,,,,,,,,

,零件必须被确认,,,,,,,,,,,

3,Theinstrumentusedmusthavediscriminationtomeasure1/10oftheexpected,,,,,,,,,,,

,processvariation.,,,,,,,,,,,

,使用的仪器必须具备对工艺变量1/10的分辨率,,,,,,,,,,,

4,Assurethattheproperdimensionismeasured.,,,,,,,,,,,

,确保测量适当的尺寸,,,,,,,,,,,

5,Assurethatallmeasuringinstructionsareavailableandunderstoodbyeach,,,,,,,,,,,

,appraiser.,,,,,,,,,,,

,确保测量说明书可用性和便于评审者阅读,,,,,,,,,,,

6,Measurementsshouldbemadeinrandomorder.,,,,,,,,,,,

,测量应以随机顺序进行,,,,,,,,,,,

7,Readingsshouldbeestimatedtothenearestnumberthatcanbeobtained.,,,,,,,,,,,

,相关的材料上，应该尽量采用可获取的最接近的数据,,,,,,,,,,,

8,ConsulttheMSAreferencemanualformoredetail.,,,,,,,,,,,

,欲获取更详细的情况，可查看MSA参考手册,,,,,,,,,,,

Guidlinesforgageacceptancefor%R&R.,,,,,,,,,,,,

R&R量具,,,,,,,,,,,,

1,<10%-,,Measurementsystemacceptable.,,,,,,,,,

,,,"对于测量系统,可以接受",,,,,,,,,

2,10-30%,,"Maybeacceptablebaseduponimportanceofapplication,costofgage,",,,,,,,,,

,,,"costofrepairs,etc.",,,,,,,,,

,,,基于量具的应用、花费和修理等因素的重要性考虑，而选择接受与否,,,,,,,,,

3,>30%-,,Measurementsystemneedsimprovement.Makeeveryefforttoidentifythe,,,,,,,,,

,,,problemsandhavethemcorrected.,,,,,,,,,

,,,检测系统需要改进。尽可能的找到问题，并予以纠正。,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

使用本表前请阅读可调储存格的批注，%R&R达到预期要求时立即复制数据，选择粘贴数值的方式粘贴到新表。,,,,,,,,,,,,

参数规格下限,规格上限,,测量偏差系数,规格偏差系数,小数位数,,,,,数据结果,,

12.32,15.68,,,,,,,,,,,

,14,0.672,0.02,0.2,2,,,,GR&R=,3.2%,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

量具重复性和再现性数据表,,,,,,,,,,,,

,零件,,,,,,,,,,,

评价人/试验,1,2,3,4,5,6,7,8,9,10,,Average均值

1A1.,13.62,14.18,13.63,14.2,14.25,14.09,13.84,13.57,13.91,14.31,,13.960

2.2.,13.64,14.18,13.64,14.21,14.26,14.09,13.85,13.58,13.91,14.33,,13.969

3.3.,13.63,14.2,13.63,14.22,14.26,14.11,13.85,13.57,13.93,14.31,,13.971

4.Average均值,13.6300,14.1867,13.6333,14.2100,14.2567,14.0967,13.8467,13.5733,13.9167,14.3167,X-bar/A=,13.967

5.Range极差,0.0200,0.0200,0.0100,0.0200,0.0100,0.0200,0.0100,0.0100,0.0200,0.0200,R-bar/A=,.016

6.B1.,13.63,14.18,13.63,14.21,14.25,14.11,13.84,13.59,13.91,14.31,,13.966

7.2.,13.63,14.19,13.63,14.2,14.26,14.1,13.86,13.57,13.92,14.33,,13.969

83.,13.63,14.19,13.64,14.21,14.26,14.11,13.85,13.59,13.93,14.32,,13.973

9.Average均值,13.6300,14.1867,13.6333,14.2067,14.2567,14.1067,13.8500,13.5833,13.9200,14.3200,X-bar/B=,13.969

10.Range极差,0.0000,0.0100,0.0100,0.0100,0.0100,0.0100,0.0200,0.0200,0.0200,0.0200,R-bar/B=,.013

11.C1.,13.63,14.2,13.64,14.2,14.26,14.11,13.84,13.58,13.92,14.33,,13.971

12.2.,13.63,14.18,13.64,14.21,14.26,14.1,13.85,13.58,13.92,14.33,,13.970

13.3.,13.64,14.19,13.64,14.21,14.27,14.1,13.84,13.58,13.92,14.32,,13.971

14.Average均值,13.6333,14.1900,13.6400,14.2067,14.2633,14.1033,13.8433,13.5800,13.9200,14.3267,X-bar/C=,13.971

15.Range极差,0.0100,0.0200,0.0000,0.0100,0.0100,0.0100,0.0100,0.0000,0.0000,0.0100,R-bar/C=,.008

16.PartAverageXbar/p零件均值（Xp）,13.6311,14.1878,13.6356,14.2078,14.2589,14.1022,13.8467,13.5789,13.9189,14.3211,X-barbar=,13.969

,,,,,,,,,,,Rp=,.742

17.[Ra=]+[Rb=]+[Rc=]/[评价人数量=]=,,,,,,,,,,,R=,.012

18.[MaxX=]-[MinX=]=XDIFF,,,,,,,,,,,,.004

19.[R=]×[D4=]※=UCLR,,,,,,,,,,,UCL/R=,.032

20.[R=]×[D3=]※=UCLR,,,,,,,,,,,LCR/R=,.000

trials,D4,D3,,"Note:CompareallRangevaluestoUCL/R.Ifanyarehigher,identifythecauseanddiscardthevalues.RecomputeRusingremainingvalues.",,,,,,,,

2,3.27,0,,,,,,,,,,

3,2.58,0,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

量具重复性和再现性报告,,,,,,,,,,,,

,,,,,,,,,,,,,

零件编号和名称：,DQG128点火线圈,,,,量具名称：,卡尺,,,日期：,2006.12.25,,

特性：,长度,,,,量具号：,JW023,,,完成人：,韦云刘忠云丁德利,,

规范：,76.5-80.5,,,,量具类型：,计量,,,,,,

,R=,,0.012333333,,,x-BarDiff.=,,0.004,,R/p=,,.742

,,,,,,,,,,,,,

Numberoftrials=,3,,X-barbar=,,13.96888889,,Tol.=,4,,No.ofParts=,,10

,,,,,,,,,,,,,

MeasurementUnitValue,,,,,,,TotalVariation(TV),,,,,

,,,,,,,,,,,,,

Repeatability-EquipmentVariation(EV),,,,,,,%EV=,,EV/TV,,,

,,,,,,,=,,3.12%,,(Variation),

EV=,R-barbarxK1,,,,,,,,EV/Tol,,,

EntervalueK1=,,0.5908,,Trials,K1,,=,,0.18%,,(Tolerence),<<<<

,,,,2,0.8862,,,,,,,

EV=,,0.007286533,,3,0.5908,,,,,,,

,,,,,,,,,,,,,

,,,,,,,,,,,,,

Reproducibility-Appraiservariation(AV),,,,,,,%AV=,,AV/TV,,,

,,,,,,,=,,0.69%,,(Variation),

AV=,Sq.Rt.((X-barDIFFxK2)^2-(EV^2/(nr))),,,,,,,,AV/Tol,,,

,,,,,,,=,,0.04%,,(Tolerence),<<<<

=,0.001615039,,,,,,,,,,,

Note:Anegativevalueunderthesquarerootsignwill,,,Appraisers,,2,3,n=,Numberofparts=,,,10,

defaulttheappraiservariationtozero.,,,,K2,0.7071,0.5231,r=,Numberoftria