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.=,#NUM!,,,,R&R=,#NUM!,,,

,,,A.V.=,#NUM!,,,,PV=,#NUM!,,,

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

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

,,,E.V.=,0.02%,,A.V.=,0%,,R&R=,#NUM!,,

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

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达到预期要求时立即复制数据，选择粘贴数值的方式粘贴到新表。,,,,,,,,,,,,

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

38.4,38.8,,,,,,,,,,,

,38.6,0.08,0.002,0.2,3,,,,GR&R=,#NUM!,,

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

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

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

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

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

1A1.,38.663,38.561,38.597,38.558,38.614,38.524,38.669,38.552,38.673,38.577,,38.599

2.2.,38.665,38.563,38.598,38.56,38.615,38.524,38.67,38.553,38.674,38.578,,38.600

3.3.,38.664,38.562,38.599,38.559,38.615,38.526,38.67,38.552,38.674,38.578,,38.600

4.Average均值,38.6640,38.5620,38.5980,38.5590,38.6147,38.5247,38.6697,38.5523,38.6737,38.5777,X-bar/A=,38.600

SUMA,115.992,115.686,115.794,115.677,115.844,115.574,116.009,115.657,116.021,115.733,,

5.Range极差,0.0020,0.0020,0.0020,0.0020,0.0010,0.0020,0.0010,0.0010,0.0010,0.0010,R-bar/A=,.002

6.B1.,38.663,38.561,38.598,38.559,38.615,38.524,38.67,38.553,38.674,38.578,,38.600

7.2.,38.663,38.562,38.598,38.559,38.614,38.525,38.671,38.553,38.674,38.578,,38.600

83.,38.664,38.561,38.598,38.56,38.616,38.524,38.67,38.552,38.674,38.578,,38.600

9.Average均值,38.66333333,38.56133333,38.598,38.55933333,38.615,38.52433333,38.67033333,38.55266667,38.674,38.578,X-bar/B=,38.600

SUMB,115.99,115.684,115.794,115.678,115.845,115.573,116.011,115.658,116.022,115.734,,

10.Range极差,0.0010,0.0010,0.0000,0.0010,0.0020,0.0010,0.0010,0.0010,0.0000,0.0000,R-bar/B=,.001

11.C1.,38.664,38.562,38.599,38.559,38.615,38.525,38.67,38.553,38.675,38.577,,38.600

12.2.,38.663,38.562,38.597,38.56,38.615,38.524,38.67,38.553,38.674,38.577,,38.600

13.3.,38.665,38.562,38.598,38.558,38.615,38.525,38.67,38.553,38.674,38.578,,38.600

14.Average均值,38.6640,38.5620,38.5980,38.5590,38.6150,38.5247,38.6700,38.5530,38.6743,38.5773,X-bar/C=,38.600

SUMC,115.992,115.686,115.794,115.677,115.845,115.574,116.01,115.659,116.023,115.732,,

15.Range极差,0.0020,0.0000,0.0020,0.0020,0.0000,0.0010,0.0000,0.0000,0.0010,0.0010,R-bar/C=,.001

16.PartAverageXbar/p零件均值（Xp）,38.6638,38.5618,38.5980,38.5591,38.6149,38.5246,38.6700,38.5527,38.6740,38.5777,X-barbar=,38.600

,,,,,,,,,,,Rp=,.149

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

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

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

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.001066667,,,x-BarDiff.=,,0.000,,R/p=,,.149

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

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

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

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

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

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

,,,,,,,=,,#NUM!,,(Variation),

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

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

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

EV=,,0.000630187,,3,0.5908,,,,,,,

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

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

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

,,,,,,,=,,#NUM!,,(Variation),

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

,,,,,,,=,,#NUM!,,(Tolerence),<<<<

=,#NUM!,,,,,,,,,,,

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

defaulttheappraiservariationto