MSA-GRR數(shù)據(jù)自動生成工具(已經(jīng)解密)

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

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

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

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

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

PerformedBy:,,>>>>,韋云劉忠云丁德利,,,Dept.,,>>>>,質(zhì)量部,,,

完成人,,,,,,部門,,,,,,

PartNo.&Name:,,>>>>,DQG128點(diǎn)火線圈,,,GageName:,,>>>>,卡尺,,,

零件編號和名稱,,,,,,量具名稱,,,,,,

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

測試特性,,,,,,量具號,,,,,,

TotalTolerence=,,>>>>,76.5,80.5,,Gagetype:,,>>>>,計(jì)量,,,

總偏差,,,,,,量具類型,,,,,,

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

結(jié)果總概,,在測量系統(tǒng)中全部的變量可參看MSA參考手冊,,,,,,,,,,

,,,E.V.=,11.5%,,,,R&R=,12.2%,,,

,,,A.V.=,4.0%,,,,PV=,99.3%,,,

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

,,R&R/,偏差-查看如下可接受輸入數(shù)據(jù)的指導(dǎo),,,,,,,,,

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

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

ApprovedBy:,>>>>,證實(shí)人,,,,,Date:,>>>>,,,,

證實(shí)人,,,,,,,日期,,,,,

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

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

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

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

開始研究前，必須考慮的重要因素,,,,,,,,,,,,檢查

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

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

,盡可能從工藝流程中選取，并且要能代表該零件的整個工藝過程的各特性（每天隨機(jī)抽取1到2個零件，直至收集到足夠的零件）,,,,,,,,,,,

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

,零件必須被確認(rèn),,,,,,,,,,,

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

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

,使用的儀器必須具備對工藝變量1/10的分辨率,,,,,,,,,,,

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

,確保測量適當(dāng)?shù)某叽?,,,,,,,,,,

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

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

,確保測量說明書可用性和便于評審者閱讀,,,,,,,,,,,

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

,測量應(yīng)以隨機(jī)順序進(jìn)行,,,,,,,,,,,

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

,相關(guān)的材料上，應(yīng)該盡量采用可獲取的最接近的數(shù)據(jù),,,,,,,,,,,

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

,欲獲取更詳細(xì)的情況，可查看MSA參考手冊,,,,,,,,,,,

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

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

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

,,,"對于測量系統(tǒng),可以接受",,,,,,,,,

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

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

,,,基于量具的應(yīng)用、花費(fèi)和修理等因素的重要性考慮，而選擇接受與否,,,,,,,,,

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

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

,,,檢測系統(tǒng)需要改進(jìn)。盡可能的找到問題，并予以糾正。,,,,,,,,,

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

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

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

使用本表前請閱讀可調(diào)儲存格的批注，%R&R達(dá)到預(yù)期要求時立即復(fù)制數(shù)據(jù)，選擇粘貼數(shù)值的方式粘貼到新表。,,,,,,,,,,,,

參數(shù)規(guī)格下限,規(guī)格上限,,測量偏差系數(shù),規(guī)格偏差系數(shù),小數(shù)位數(shù),,,,,數(shù)據(jù)結(jié)果,,

10.15,10.8,,,,,,,,,,,

,10.475,0.13,0.02,0.2,2,,,,GR&R=,12.2%,,

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

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

量具重復(fù)性和再現(xiàn)性數(shù)據(jù)表,,,,,,,,,,,,

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

評價人/試驗(yàn),1,2,3,4,5,6,7,8,9,10,,Average均值

1A1.,10.59,10.45,10.59,10.46,10.56,10.49,10.47,10.6,10.51,10.39,,10.511

2.2.,10.6,10.45,10.6,10.48,10.56,10.5,10.48,10.62,10.53,10.4,,10.522

3.3.,10.59,10.46,10.61,10.47,10.58,10.49,10.47,10.6,10.51,10.41,,10.519

4.Average均值,10.5933,10.4533,10.6000,10.4700,10.5667,10.4933,10.4733,10.6067,10.5167,10.4000,X-bar/A=,10.517

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

6.B1.,10.61,10.47,10.61,10.47,10.57,10.5,10.49,10.61,10.51,10.41,,10.525

7.2.,10.61,10.47,10.6,10.48,10.56,10.5,10.49,10.6,10.52,10.4,,10.523

83.,10.6,10.47,10.6,10.47,10.57,10.5,10.47,10.61,10.52,10.4,,10.521

9.Average均值,10.6067,10.4700,10.6033,10.4733,10.5667,10.5000,10.4833,10.6067,10.5167,10.4033,X-bar/B=,10.523

10.Range極差,0.0100,0.0000,0.0100,0.0100,0.0100,0.0000,0.0200,0.0100,0.0100,0.0100,R-bar/B=,.009

11.C1.,10.6,10.45,10.61,10.48,10.56,10.51,10.48,10.61,10.53,10.41,,10.524

12.2.,10.59,10.45,10.6,10.47,10.56,10.49,10.49,10.61,10.52,10.39,,10.517

13.3.,10.6,10.45,10.61,10.46,10.58,10.51,10.48,10.6,10.53,10.4,,10.522

14.Average均值,10.5967,10.4500,10.6067,10.4700,10.5667,10.5033,10.4833,10.6067,10.5267,10.4000,X-bar/C=,10.521

15.Range極差,0.0100,0.0000,0.0100,0.0200,0.0200,0.0200,0.0100,0.0100,0.0100,0.0200,R-bar/C=,.013

16.PartAverageXbar/p零件均值（Xp）,10.5989,10.4578,10.6033,10.4711,10.5667,10.4989,10.4800,10.6067,10.5200,10.4011,X-barbar=,10.520

,,,,,,,,,,,Rp=,.206

17.[Ra=]+[Rb=]+[Rc=]/[評價人數(shù)量=]=,,,,,,,,,,,R=,.013

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

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

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

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

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

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

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

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

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

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

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

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

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

量具重復(fù)性和再現(xiàn)性報(bào)告,,,,,,,,,,,,

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

零件編號和名稱：,DQG128點(diǎn)火線圈,,,,量具名稱：,卡尺,,,日期：,2006.12.25,,

特性：,長度,,,,量具號：,JW023,,,完成人：,韋云劉忠云丁德利,,

規(guī)范：,76.5-80.5,,,,量具類型：,計(jì)量,,,,,,

,R=,,0.012666667,,,x-BarDiff.=,,0.006,,R/p=,,.206

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

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

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

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

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

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

,,,,,,,=,,11.49%,,(Variation),

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

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

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

EV=,,0.007483467,,3,0.5908,,,,,,,

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

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

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

,,,,,,,=,,4.04%,,(Variation),

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

,,,,,,,=,,0.07%,,(Tolerence),<<<<

=,0.002630577,,,,,,,,,,,

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

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