量具重复性和再现性数据表.xlsVIP

Sheet3 Sheet2 Sheet1 量具重复性和再現性數据表 APPRAISER/TRIAL # 評价人/試驗# AVERAGE 平均值 PART \零件 4. Average \平均值 5. Range \均差 9. Average \平均值 10. Range \均差 14. Average \平均值 15. Range \均差 16.Part Average\零件平均值(Xp) 19.[R= ]*[D4= ]=UCLR 20.[R= ]*[D3= ]=LCLR individual Rs . Circle those that ate beyond this limit .Identify the cause and correct . Repeat these readings using the same appeaiser and unit as originally used originally used or discard values and re-average and recompute R and the limiting value form the remaining D4=3.27for 2 trials 2.58 for trials ; D3=0 for up to trials .UCLR represents the limit of observation .\*D4=3.27(兩次試驗),D4=2.58(三次試驗);D3=0(不大于7次試驗),UCLR代表單個R的限值, 值, 由剩余測值再次計算R和限值. 圈出那些超限的值,查明原因并糾正;同一評价人采用最初的儀器重复這些超限讀數据或者剔出這些超限 Apprived By \核准: Beviewed By\審查: Prepared By\制表: Date \日期: Gauge Repeatability and Reproducibility Date Sheet Xa= QR-112-01A Ra= Xb= Rb= Rp= R= Xc= Rc= XDIFF= 量具重复性程再現性報告 Gage Repeatabilty and Reproducibility Report Gage Nmge \量具名稱: Date \日期: Characteristics \被測參數: Gage NO\量具號: PerformedBy\操作者: From date sheet \根据數据表: Gage Type \量具類型: Specification \ 規格: R= XDIFF= Rp= Measurement Unit Analysis \測量設備分析 Repeatability -Equipment Variation (EV)\重复性-評价人變差 EV= R*K1 .= Trials \試驗次數 K1 Reproducibility -Appraiser Variation (AV)\重复性和再現性(RR) AV= √[( Appraisers\評价人 √[(XDIFF*K2)]2-(EV2/nr)] ./10*3 Repeatability Reproducibility (RR)\ 重复性和再現性(RR) RR= parts 零件 K3 Part Variation (PV)\ 零件變差(PV) PV= Rp*K3 .= Total Variation (TV)\總變差(TV) TV= √EV2*AV2 √ √RR2+PV2 .=√ .= All calculations are based upon predicting 5.15 sigma (99.0% of the area the normal sixtribution curve).\ K1 is 5.15/d2 where d2 is dependent on the number of trials (m) and of parts time number of operations (g) which is assumed to be greater than 15. D2 values ate from Table2,P.29\K1=5.15/d2,式中d2取決于試驗次數(m)和零件數目与操作者數量之積(g),g假定大于15.d2值來自表2. 所有計算均基于預計5.15(正常分布曲線下99.0%的面積. AV-if a megative value is dependent on the s