MSA-GRR數(shù)據(jù)自動生成工具

1、Gage R&R Long (x-Bar Range) Method - 3 TrialsDate:2006.12.25日期Performed By:韋云 劉忠云 丁德利Dept.質(zhì)量部完成人部門Part No. & Name:DQG128點火線圈Gage Name:卡尺零件編號和名稱量具名稱Characteristic Measured:長度Gage No.: 測試特性量具號Total Tolerence=Gage type:計量總偏差量具類型Results Summary:Variation in total measurement system-See MSA refer

2、ence manual結(jié)結(jié)果果總總概概在在測測量量系系統(tǒng)統(tǒng)中中全全部部的的變變量量可可參參看看MSA參參考考手手冊冊 R&R/Tolerence-See acceptance guidelines below.偏差-查看如下可接受輸入數(shù)據(jù)的指導(dǎo)Approved By:證實人Date:證實人日期Gage accepted:接受量具Significant factors to consider before starting studyCHECK開開始始研研究究前前，必必須須考考慮慮的的重重要要因因素素檢查When possible sample parts should be selec

3、ted from the process and represent its entire operating range. (1 or 2 parts randomly selected per day until sufficient parts are collected).盡可能從工藝流程中選取，并且要能代表該零件的整個工藝過程的各特性（每天隨機抽取1到2個零件，直至收集到足夠的零件）Parts must be identified.零件必須被確認(rèn)The instrument used must have discrimination to measure 1/10 of the ex

4、pectedprocess variation.使用的儀器必須具備對工藝變量1/10的分辨率Assure that the proper dimension is measured.確保測量適當(dāng)?shù)某叽鏏ssure that all measuring instructions are available and understood by each appraiser.確保測量說明書可用性和便于評審者閱讀Measurements should be made in random order.測量應(yīng)以隨機順序進(jìn)行Readings should be estimated to the neares

5、t number that can be obtained.相關(guān)的材料上，應(yīng)該盡量采用可獲取的最接近的數(shù)據(jù)Consult the MSA reference manual for more detail. 欲獲取更詳細(xì)的情況，可查 看MSA參考手冊Guidlines for gage acceptance for % R&R.R&R量具M(jìn)easurement system acceptable.對于測量系統(tǒng),可以接受May be acceptable based upon importance of application,cost of gage, cost of repai

6、rs, etc.基于量具的應(yīng)用、花費和修理等因素的重要性考慮，而選擇接受與否Measurement system needs improvement. Make every effort to identify theproblems and have them corrected.檢測系統(tǒng)需要改進(jìn)。盡可能的找到問題，并予以糾正。使使用用本本表表前前請請閱閱讀讀可可調(diào)調(diào)儲儲存存格格的的批批注注，%R&R達(dá)達(dá)到到預(yù)預(yù)期期要要求求時時立立即即復(fù)復(fù)制制數(shù)數(shù)據(jù)據(jù)，選選擇擇粘粘貼貼數(shù)數(shù)值值的的方方式式粘粘貼貼到到新新表表。參參數(shù)數(shù)規(guī)規(guī)格格下下限限規(guī)規(guī)格格上上限限測測量量偏偏差差系系數(shù)數(shù)規(guī)規(guī)格格偏

7、偏差差系系數(shù)數(shù)小小數(shù)數(shù)位位數(shù)數(shù)數(shù)數(shù)據(jù)據(jù)結(jié)結(jié)果果7072710.60.020.32GR&R=2.0%量量具具重重復(fù)復(fù)性性和和再再現(xiàn)現(xiàn)性性數(shù)數(shù)據(jù)據(jù)表表零件評價人/試驗12345678910Average均值1 A 1.70.8370.970.5271.0771.4870.7870.8170.8371.5571.170.9872. 2.70.8570.9270.5271.0971.570.7970.8270.8571.5671.171.0003. 3.70.8470.970.5271.0871.570.7870.8270.8471.5671.1170.9954. Average均值 70.8

8、40070.9067 70.5200 71.080071.493370.7833 70.8167 70.8400 71.5567 71.1033 X-bar/A=70.994SUM A212.52212.72211.56213.24214.48212.35212.45212.52214.67213.315. Range極差0.02000.02000.00000.02000.02000.01000.01000.02000.01000.0100R-bar/A=.0146. B 1. 70.8470.970.5371.0871.4970.7970.8270.8371.5771.170.9957. 2

9、. 70.8470.9170.5371.0971.570.7970.8270.8571.5671.1271.0018 3. 70.8470.9170.5271.0871.4970.7970.8270.8571.5671.1170.9979. Average均值70.8470.9067 70.5267 71.083371.4933370.7970.8270.8433 71.563371.11X-bar/B=70.998SUM B212.52212.72211.58213.25214.48212.37212.46212.53214.69213.3310. Range極差0.00000.01000.

10、01000.01000.01000.00000.00000.02000.01000.0200R-bar/B=.00911. C 1. 70.8470.970.5471.0771.570.7970.8170.8471.5771.1170.99712. 2. 70.8470.9270.5371.0871.4970.7970.8170.8571.5771.1170.99913. 3. 70.8370.9170.5371.0771.4970.870.8270.8471.5671.1170.99614. Average均值 70.836770.9100 70.5333 71.073371.493370.

11、7933 70.8133 70.8433 71.5667 71.1100 X-bar/C=70.997SUM C212.51212.73211.6213.22214.48212.38212.44212.53214.7213.3315. Range極差0.01000.02000.01000.01000.01000.01000.01000.01000.01000.0000R-bar/C=.01016. PartAverageXbar/p零件均值（Xp）70.838970.9078 70.5267 71.078971.493370.7889 70.8167 70.8422 71.5622 71.10

12、78 X-barbar=70.996Rp=1.03617. Ra= + Rb= + Rc= / 評價人數(shù)量 = =R =.01118.Max X = - Min X = = XDIFF .00419.R = D4 = = UCLR UCL/R=.02820.R = D3 = = UCLR LCR/R=.000trialsD4D3Note: Compare all Range values to UCL/R. If any are higher, identify the causeand discard the values. Recompute R using remaining value

13、s.23.27032.580量量具具重重復(fù)復(fù)性性和和再再現(xiàn)現(xiàn)性性報報告告零件編號和名稱：量具名稱：日期：特性：量具號：完成人：韋云 劉忠云 丁德利規(guī)范：量具類型：R=x-Bar Diff.=R/p=Number of trials=No. of Parts=Measurement Unit ValueTotal Variation (TV)Repeatability - Equipment Variation (EV)% EV=(Variation)R-barbar x K1Enter value K1 = (Tolerence)Reproducibility - Appraiser vari

14、ation (AV)(Variation)Sq.Rt.(X-bar DIFF x K2)2-(EV2/(nr)(Tolerence)Note:A negative value under the square root sign willAppraisersNumber of parts =default the appraiser variation to zero.Number of trials =Repeatability & Reproduciibility (R&R)(Variation)SqRt(EV2) + (AV2)(Tolerence)Part Variat

15、ion (PV)(PV / TV)Rp x K3Total Variation (TV)SQRT(R&R2 + PV2)結(jié)論：該測量系統(tǒng)可以接受，滿足測量要求。確認(rèn)：制表：Gage R&R Long (x-Bar Range) Method - 3 TrialsDate:2006.12.25日期Performed By:韋云 劉忠云 丁德利Dept.質(zhì)量部完成人部門Part No. & Name:DQG128點火線圈Gage Name:卡尺零件編號和名稱量具名稱Characteristic Measured:長度Gage No.: 測試特性量具號Total Tolere

16、nce=Gage type:計量總偏差量具類型Results Summary:Variation in total measurement system-See MSA reference manual結(jié)結(jié)果果總總概概在在測測量量系系統(tǒng)統(tǒng)中中全全部部的的變變量量可可參參看看MSA參參考考手手冊冊 R&R/Tolerence-See acceptance guidelines below.偏差-查看如下可接受輸入數(shù)據(jù)的指導(dǎo)Approved By:證實人Date:證實人日期Gage accepted:接受量具Significant factors to consider before st

17、arting studyCHECK開開始始研研究究前前，必必須須考考慮慮的的重重要要因因素素檢查When possible sample parts should be selected from the process and represent its entire operating range. (1 or 2 parts randomly selected per day until sufficient parts are collected).盡可能從工藝流程中選取，并且要能代表該零件的整個工藝過程的各特性（每天隨機抽取1到2個零件，直至收集到足夠的零件）Parts must b

18、e identified.零件必須被確認(rèn)The instrument used must have discrimination to measure 1/10 of the expectedprocess variation.使用的儀器必須具備對工藝變量1/10的分辨率Assure that the proper dimension is measured.確保測量適當(dāng)?shù)某叽鏏ssure that all measuring instructions are available and understood by each appraiser.確保測量說明書可用性和便于評審者閱讀Measur

19、ements should be made in random order.測量應(yīng)以隨機順序進(jìn)行Readings should be estimated to the nearest number that can be obtained.相關(guān)的材料上，應(yīng)該盡量采用可獲取的最接近的數(shù)據(jù)Consult the MSA reference manual for more detail. 欲獲取更詳細(xì)的情況，可查 看MSA參考手冊Guidlines for gage acceptance for % R&R.R&R量具M(jìn)easurement system acceptable.對于測

20、量系統(tǒng),可以接受May be acceptable based upon importance of application,cost of gage, cost of repairs, etc.基于量具的應(yīng)用、花費和修理等因素的重要性考慮，而選擇接受與否Measurement system needs improvement. Make every effort to identify theproblems and have them corrected.檢測系統(tǒng)需要改進(jìn)。盡可能的找到問題，并予以糾正。使使用用本本表表前前請請閱閱讀讀可可調(diào)調(diào)儲儲存存格格的的批批注注，%R&R達(dá)達(dá)到

21、到預(yù)預(yù)期期要要求求時時立立即即復(fù)復(fù)制制數(shù)數(shù)據(jù)據(jù)，選選擇擇粘粘貼貼數(shù)數(shù)值值的的方方式式粘粘貼貼到到新新表表。參參數(shù)數(shù)規(guī)規(guī)格格下下限限規(guī)規(guī)格格上上限限測測量量偏偏差差系系數(shù)數(shù)規(guī)規(guī)格格偏偏差差系系數(shù)數(shù)小小數(shù)數(shù)位位數(shù)數(shù)數(shù)數(shù)據(jù)據(jù)結(jié)結(jié)果果12.3215.68140.6720.020.23GR&R=2.0%量量具具重重復(fù)復(fù)性性和和再再現(xiàn)現(xiàn)性性數(shù)數(shù)據(jù)據(jù)表表零件評價人/試驗12345678910Average均值1 A 1. 13.82514.28814.59314.07214.29913.46414.47313.82914.414.21114.1452. 2. 13.83514.28914.60114

22、.08714.30813.46514.47713.83814.40614.22114.1533. 3. 13.82614.29114.61114.08114.30913.47214.48813.84814.4214.22814.1574. Average均值 13.828714.2893 14.6017 14.080014.305313.4670 14.4793 13.8383 14.4087 14.2200 X-bar/A=14.1525. Range極差0.01000.00300.01800.01500.01000.00800.01500.01900.02000.0170R-bar/A=.

23、0146. B 1. 13.83614.30314.60214.07514.30613.48214.48713.84714.40414.22814.1577. 2. 13.83114.30214.59814.07314.31813.46614.48813.84314.40414.22314.1558 3. 13.83214.2914.60314.08814.313.47314.47713.83514.41214.21214.1529. Average均值13.833014.2983 14.6010 14.078714.308013.4737 14.4840 13.8417 14.4067 14

24、.2210 X-bar/B=14.15510. Range極差0.00500.01300.00500.01500.01800.01600.01100.01200.00800.0160R-bar/B=.01211. C 1. 13.83414.2914.59314.07914.31813.47314.47513.8314.40914.22614.15312. 2. 13.83914.30514.60214.08914.30913.46514.47413.83214.40414.22814.15513. 3. 13.82814.30114.59914.08114.30613.48414.48613

25、.84514.40314.22614.15614. Average均值 13.833714.2987 14.5980 14.083014.311013.4740 14.4783 13.8357 14.4053 14.2267 X-bar/C=14.15415. Range極差0.01100.01500.00900.01000.01200.01900.01200.01500.00600.0020R-bar/C=.01116. PartAverageXbar/p零件均值（Xp）13.831814.2954 14.6002 14.080614.308113.4716 14.4806 13.8386 14.4069 14.2226 X-barbar=14.154Rp=1.12917. Ra= + Rb= + Rc= / 評價人數(shù)量 = =R =.01218.Max X = - Min X = = XDIFF .00319.R = D4 = = UCLR UCL/R=.03120.R = D3 = =