品質(zhì)圖表制作模板

1、2009/10/202022/3/141232009/10/271 Sunday周末2099/12/152009/10/122009/10/132 Monday日常 TuesdayMondayTuesday2 Monday3 Tuesday日常 日常日常日常4 Wednesday 日常44645 Thursday日常12.12022/3/14 22:206 Friday日常137 Saturday周末6150.796224848今天是:2 20 02 22 2/ /3 3/ /1 14 4跟進(jìn)項(xiàng)目計(jì)劃完成時(shí)間是否關(guān)閉通知1 041-000477-00的承認(rèn)書制作2010/1/7否否時(shí)時(shí)間間已已

2、超超, ,請(qǐng)請(qǐng)注注意意關(guān)關(guān)閉閉該該問問題題2深象M3組合螺釘M04-051140-彈墊過大擰緊后彈墊會(huì)張開2009/12/25否否時(shí)時(shí)間間已已超超, ,請(qǐng)請(qǐng)注注意意關(guān)關(guān)閉閉該該問問題題3 品質(zhì)常用工具與excel的運(yùn)用技巧2010/1/5否否時(shí)時(shí)間間已已超超, ,請(qǐng)請(qǐng)注注意意關(guān)關(guān)閉閉該該問問題題4 表面處理的培訓(xùn)2009/12/26是是-5 到飛黃出差2009/12/27是是-456789106-2009/10/142009/10/152009/10/162009/10/172009/10/182009/10/192009/10/207-Wednesday Thursday FridaySat

3、urday SundayMondayTuesday8-日常日常日常周末周末日常日常1 時(shí)間已超,請(qǐng)注意關(guān)閉該問題2 該項(xiàng)目緊急，請(qǐng)速完成3 距離完成還有時(shí)間，請(qǐng)注意及時(shí)完成1來來料料質(zhì)質(zhì)量量檢檢驗(yàn)驗(yàn)部部加加班班申申請(qǐng)請(qǐng)表表-2009-2009年年( ( 0707 ) )月月項(xiàng)項(xiàng)目目日日 期期姓姓名名工工碼碼組組別別123456789101112 13 14 15 16 17 18 19 20 21 22 2350002165機(jī)械2113332380220850003253機(jī)械8227.53333083322850004257機(jī)械2233233383320850004593機(jī)械221133223

4、83202850005507機(jī)械2113323383323050005694機(jī)械22113323083222850005891機(jī)械113323383022850006049機(jī)械2113320383222050006368機(jī)械8882113333003320050006367機(jī)械22113322082222850007212機(jī)械8221133333833200 備注: 1)每天下班前提出當(dāng)日加班申請(qǐng)、周五下班前提出周末加班申請(qǐng); 2)每天在相應(yīng)的日期中記錄加班申請(qǐng)小時(shí); 3)加班申請(qǐng)事由每次申請(qǐng)時(shí)進(jìn)行更新; 4)每月根據(jù)周末/假日的日期更新表格的統(tǒng)計(jì)算法; 5)若當(dāng)天申請(qǐng)加班時(shí)間與實(shí)際加班時(shí)間有

5、差異,請(qǐng)于第二天申請(qǐng)時(shí)更新;6)標(biāo)注黃色為支援產(chǎn)線統(tǒng)統(tǒng)計(jì)計(jì)加加班班事事由由備備注注24 25 26 27 28 29 30 31日常周末假日總計(jì)47休息57.557.5事務(wù)處理4545休息51來料檢驗(yàn)4646來料檢驗(yàn)51培訓(xùn)48來料檢驗(yàn)4141來料檢驗(yàn)5757休息49三瑞外檢5454休息來來料料質(zhì)質(zhì)量量檢檢驗(yàn)驗(yàn)部部加加班班申申請(qǐng)請(qǐng)表表-2009-2009年年( ( 0707 ) )月月日日 期期總計(jì) 日常 周末 假日總計(jì)日常1 4700 057.502 5800 05703 4500 05404 5100 05105 4600 05106 5100 04907 4800 04808 4100

6、04709 5700 046010 4900 045011 5400 0410周末 假日0000000000000000000000關(guān)關(guān)于于第第四四季季度度散散熱熱片片的的不不良良匯匯總總數(shù)數(shù)據(jù)據(jù)如如下下: :s/ns/n螺螺紋紋不不良良位位置置度度超超差差導(dǎo)導(dǎo)通通不不良良表表面面贓贓物物來來錯(cuò)錯(cuò)物物料料不不良良數(shù)數(shù)量量5 50 03 32 21 18 86 64 4不不良良比比率率4 43 3. .1 10 0% %2 27 7. .5 59 9% %1 15 5. .5 52 2% %5 5. .1 17 7% %3 3. .4 45 5% %累累積積不不良良率率4 43 3. .1 10

7、 0% %7 70 0. .6 69 9% %8 86 6. .2 21 1% %9 91 1. .3 38 8% %9 94 4. .8 83 3% %503218642443.10%70.69%86.21%91.38%94.83%96.55%100.00%09/第第四四季季度度散散熱熱片片不不良良狀狀況況螺紋不良位置度超差導(dǎo)通不良表面贓物來錯(cuò)物料變形其它0204060801000%10%20%30%40%50%60%70%80%90%100%不良類別不良數(shù)量不良比率不良數(shù)量累積不良率變變形形其其它它2 24 41161 1. .7 72 2% %3 3. .4 45 5% %9 96 6.

8、 .5 55 5% %1 10 00 0. .0 00 0% %503218642443.10%70.69%86.21%91.38%94.83%96.55%100.00%09/第第四四季季度度散散熱熱片片不不良良狀狀況況螺紋不良位置度超差導(dǎo)通不良表面贓物來錯(cuò)物料變形其它0204060801000%10%20%30%40%50%60%70%80%90%100%不良類別不良數(shù)量不良比率不良數(shù)量累積不良率某鈑金件長度尺寸:150.2mm邁瑞友信鑫115.1515.13215.0815.06315.0214.99414.8614.83514.8914.87615.1715.15714.9414.978

9、14.9214.90915.1015.111014.8714.861115.1615.141215.0915.071315.0315.081414.8714.911514.9014.951615.1815.241714.9515.061814.9314.981915.1115.202014.8814.942114.9915.202214.9215.132314.8615.062414.7014.892514.7314.932615.0115.142714.7814.962814.7614.892914.9415.103014.7114.85R=0.792R2=0.6315.30 15.20 1

10、5.10 15.00 14.90 14.80 14.70 14.60 14.50 14.40 14.70 14.80 14.90 15.00 15.10 15.20 15.30 15.30 15.20 15.10 15.00 14.90 14.80 14.70 14.60 14.50 14.40 14.70 14.80 14.90 15.00 15.10 15.20 15.30 某客戶的電阻值要求為50020歐最近發(fā)現(xiàn)客戶的產(chǎn)品波動(dòng)比較大，所以歸納了近段時(shí)間的IQC來料測量數(shù)值，數(shù)值如下：第1批第2批第3批第4批1489.1476.4507.4526.92511.1520.6475.1491.

11、43504.5498.3482.9498.14494.0491.1513.3490.55492.7469.3489.0480.46492.3492.7520.1534.57502.3499.6521.0504.58505.2501.3481.7479.89519.8484.9488.4487.410485.6507.5502.5497.8最大值=534.5最小值=469.3全距=65.2計(jì)算組數(shù)K=7.125725493 =1+3.32*LOG(COUNTA(C11:I20)四舍五入得 K= 7計(jì)算組距=9.314285714 =D23/D25計(jì)算上下組列：下界上界區(qū)間1469.3478.64

12、69.3478.62478.6487.9478.6487.93487.9497.2487.9497.24497.2506.5497.2506.55506.5515.8506.5515.86515.8525.1515.8525.17525.1534.4525.1534.48-9-10-4 12 16 17 10 7 4 電阻500+/-20直方圖分析469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.40 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)4 12 16 17 10 7 4 電阻500+/

13、-20直方圖分析10 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.44 12 16 17 10 7 4 電阻500+/-20直方圖分析469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.40 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)第5批第6批第7批495.5506.5503.4469.4500.8500.5519.0508.8518.9480.

14、3484.3528.8509.4484.9495.6501.4507.6507.5500.0515.2493.9480.5482.3493.3495.0490.6511.3501.0518.5527.2組數(shù)4121617107470最近發(fā)現(xiàn)客戶的產(chǎn)品波動(dòng)比較大，所以歸納了近段時(shí)間的IQC來料測量數(shù)值，數(shù)值如下：4 12 16 17 10 7 4 電阻500+/-20直方圖分析469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.40 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)4 12 16 17

15、10 7 4 電阻500+/-20直方圖分析469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.40 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)4 12 16 17 10 7 4 電阻500+/-20直方圖分析10 2 4 6 8 10 12 14 16 18 區(qū)間值個(gè)數(shù)469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515.8525.1525.1534.4 附件4:測量系統(tǒng)分析（GR&R）量具重復(fù)性和再現(xiàn)性數(shù)據(jù)收集表評(píng)價(jià)人/試驗(yàn)零件均

16、值12345678910A 16.90006.89006.89006.82006.83006.84006.84006.73006.74006.740026.89006.89006.88006.83006.84006.82006.83006.74006.75006.740036.89006.88006.89006.82006.82006.82006.82006.75006.74006.7300均值6.89336.88676.88676.82336.83006.82676.83006.74006.74336.73676.8197極差0.01000.01000.01000.01000.02000.0

17、2000.02000.02000.01000.01000.0140B 16.89006.88006.88006.83006.82006.83006.82006.74006.73006.740026.89006.88006.89006.83006.82006.82006.82006.73006.72006.730036.88006.89006.89006.82006.81006.82006.83006.73006.72006.7200均值6.88676.88336.88676.82676.81676.82336.82336.73336.72336.73006.8133極差0.01000.0100

18、0.01000.01000.01000.01000.01000.01000.01000.02000.0110C 16.88006.88006.89006.83006.82006.83006.82006.73006.73006.740026.89006.87006.88006.83006.82006.82006.82006.73006.74006.720036.88006.88006.88006.82006.83006.82006.83006.72006.73006.7200均值6.88336.87676.88336.82676.82336.82336.82336.72676.73336.726

19、76.8127極差0.01000.01000.01000.01000.01000.01000.01000.01000.01000.02000.0110零件均值6.88786.88226.88566.82566.82336.82446.82566.73336.73336.73116.8152Rp =0.1567(Ra= +Rb= +Rc= )/# 評(píng)價(jià)人數(shù) = R=0.0120XDIFF=MaxX= -MinX= =XDIFF= 0.00702.580.0310*UCLR=R= xD4= =2.580.030962次試驗(yàn)對(duì)于D4*=3.27，3次試驗(yàn)時(shí)4*=2.58。UCLR表示單個(gè)極差的控制限

20、，圈出那些超出極限的點(diǎn)，識(shí)別原因并糾正。使用與開始時(shí)相同的評(píng)價(jià)人和單位重復(fù)這些讀數(shù)，或者放棄某些值，從保留的觀察值重新平均，生新計(jì)算R和控制限。RaXaRbXbRcXc=XRUCLDR=4*注：_制表/日期：_審核/日期:_附件4: 測量系統(tǒng)分析（GR&R）量具重復(fù)性和再現(xiàn)性報(bào)告物料編號(hào)名稱:量具名稱:日期：特性：量具編號(hào): 評(píng)價(jià)人：測量對(duì)象：量具類型：從數(shù)據(jù)表：R=0.012XDIFF=0.007RP=0.156667測量單位分析% 總變差重復(fù)性設(shè)備變差(EV) (EV) %EV=100EV/TV試驗(yàn)次數(shù)K1=0.012X0.590820.886=0.007089630.5908再現(xiàn)

21、性-評(píng)價(jià)人變差（AV) (AV) %AV=100AV/TV=0.0036600250.523123=n= 10r= 3K20.70710.5231重復(fù)性和再現(xiàn)性 (GRR)%GRR=100GRR/TV=0.007978609K3=20.7071零件變差 (PV)30.5231%PV=100PV/TV40.447=0.04928733350.403=60.3742總變差70.3534ndc =1.41(PV/GRR)80.3375=0.04992894490.3249=100.3146綜合判定 %GRRR條件下接受原因分析ndc可以接受表格中的理論和常數(shù)信息見MSA參考手冊(cè)，第三版1*KREV

22、=)/()*(222nrEVKXAVDIFF)(22A VE VG R R+=3*KRpPV =)&(22PVRRTV製表/日期：_ 審核/日期:_14.20 %7.33 %15.98 %98.71 %8.71附件4: 測量系統(tǒng)分析（GR&R）量具重復(fù)性和再現(xiàn)性報(bào)告日期：評(píng)價(jià)人：% 總變差 %EV=100EV/TV %AV=100AV/TV%GRR=100GRR/TV%PV=100PV/TVndc =1.41(PV/GRR)表格中的理論和常數(shù)信息見MSA參考手冊(cè)，第三版審核/日期:_附件6:測量系統(tǒng)分析（交叉法）量具名稱物料編號(hào)名稱測量特性評(píng)價(jià)人分析人一一致致性性判判定定標(biāo)標(biāo)準(zhǔn)

23、準(zhǔn)：通用的比例法則是Kappa0.75則表示有很好的一致性，Kappa0.40則表示一致性不好。有有效效性性判判定定標(biāo)標(biāo)準(zhǔn)準(zhǔn)有效性漏報(bào)率錯(cuò)誤報(bào)警率可接受90%2%5%邊邊界界接接受受但但要要改改善善80%80%5%5%10%10%不可接受80%5%10%交交叉叉法法評(píng)評(píng)估估結(jié)結(jié)果果測測量量員員之之間間一一致致性性評(píng)評(píng)價(jià)價(jià)KappaABC結(jié)論A0.910.92B0.910.93C0.920.93測測量量員員與與標(biāo)標(biāo)準(zhǔn)準(zhǔn)之之間間一一致致性性評(píng)評(píng)價(jià)價(jià)KappaABC結(jié)論標(biāo)準(zhǔn)0.950.960.97系系統(tǒng)統(tǒng)有有效效性性評(píng)評(píng)價(jià)價(jià)結(jié)結(jié)果果有效性漏發(fā)警報(bào)的比例誤發(fā)警報(bào)的比例結(jié)論A100%0.0%#DIV/0

24、!B100%0.0%#DIV/0!C100%0.0%#DIV/0! 評(píng)價(jià)者零件A-1A-2A-3B-1B-2B-3C-1C-2C-3參考決定11111111111211011111113111111111141111111111511110111116111111111171111111111811111101119000000000010000000000011001000000012111111111113111111111114111110111115000000000016000000000017000000000018000000000019000000000020000000000

25、021000000000022000000000023000000000024000000000025111111111126000000000027111111111128000000000029111111111130000000000031000010000032000000000033000000000034000000000035010000000036000000000037000000000038000000000039000000000040111111111141111111111142111111111143111111011144111111111145111111111

26、1461111111111471111111111481101111111491111111111501111111111 備注：產(chǎn)品檢驗(yàn)合格在相應(yīng)表格填“1”，不合格填“0”A*BA*B交交叉叉表表B總計(jì)01A0數(shù)量72375期望數(shù)量38.0037.00751數(shù)量47175期望數(shù)量38.0037.0075總計(jì)數(shù)量7674150期望數(shù)量7674150B*CB*C交交叉叉表表C總計(jì)01B0數(shù)量74276期望數(shù)量39.0136.99761數(shù)量37174期望數(shù)量37.9936.0174總計(jì)數(shù)量7773150期望數(shù)量7773150A*CA*C交交叉叉表表C總計(jì)01A0數(shù)量73275期望數(shù)量38.503

27、6.50751數(shù)量47175期望數(shù)量38.5036.5075總計(jì)數(shù)量7773150期望數(shù)量7773150KappaABCA0.910.92B0.910.93C0.920.93Po0.953333 (E5+F7)/G9Pe0.5 (E6+F8)/G10PoPePoPe0.9533330.50.960.50.966667 0.500178A*SA*S交交叉叉表表S總計(jì)01A0數(shù)量73275期望數(shù)量37.5037.50751數(shù)量27375期望數(shù)量37.5037.5075總計(jì)數(shù)量7575150期望數(shù)量7575150B*SB*S交交叉叉表表S總計(jì)01B0數(shù)量74276期望數(shù)量38.0038.00761數(shù)

28、量17374期望數(shù)量37.0037.0074總計(jì)數(shù)量7575150期望數(shù)量7575150A*SA*S交交叉叉表表S總計(jì)01C0數(shù)量75277期望數(shù)量38.5038.50771數(shù)量07373期望數(shù)量36.5036.5073總計(jì)數(shù)量7575150期望數(shù)量7575150KappaABCS0.950.960.97PoPePoPe0.9733330.5 0.9866670.50.980.5A-B(same)A-C(same)B-C(same)1111111111011011111111111111111110111110111111111111111111101101111111111111111111

29、011011111111111111111111011111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111011111011111111111111111111111110110111111111111111111111111111111111111111111111111111111111111110110111111111111111111111111111111111110110

30、111111111111111111A=0,B=0A=0,C=0B=0,C=0A=0,B=110000000000010000000000010000000000010000000000010000000000010000000000010000000000010000000000011111111110011111111110011101101110010000000000010000000000000000000000011111111110011111111110011111111110011111111110011111111110011111111110011111111110011

31、1111111100111111111100111111111100100000000000111111111100100000000000111111111100100000000000111111111100110111110101111111111100111111111100111111111100110110111100111111111100111111111100111111111100111111111100100000000000B-C(same)10000000000010000000000010000000000010000000000010000000000010000

32、0000000100000000000100000000000100000000000100000000000A=B=0的個(gè)數(shù)A=C=0的個(gè)數(shù)B=C=0的個(gè)數(shù)A=0,B=1的個(gè)數(shù)7273743A=0,C=1B=0,C=1A=1,B=0A=1,C=000000000000100100000000000000000000000000000000001001000000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000100100000000000000000000000

33、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000A=0,B=100000000000000000000000000000

34、000100000000000000000000000000000000000000000000100100000000000000000000000000000A=0,C=1的個(gè)數(shù)B=0,C=1的個(gè)數(shù)A=1,B=0的個(gè)數(shù)A=1,C=0的個(gè)數(shù)2244A=0,B=1的個(gè)數(shù)3B=1,C=0A=1,B=1A=1,C=100000111110000011011000001111100000111110000010111000001111100000111110010011101000000000000000000000100000000000001111100000111110000011011000

35、00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011111000000000000000111110000000000000001111100000000000001000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000011111A=1,C=0000001111100000111110010011101000001

36、1111000001111100000111110000011111000001101100000111110000011111B=1,C=0的個(gè)數(shù)A=B=1的個(gè)數(shù)A=C=1的個(gè)數(shù)37171A=1,C=0的個(gè)數(shù)4B=1,C=11111011111111111110111111111101100000000000011111111111000000000000000000000000000000000000000001111000011110000111100000000000000000000000000000000000000001111A=1,C=111111111101111111111

37、11111111011111111111B=C=1的個(gè)數(shù)71A=C=1的個(gè)數(shù)71A-S(same)B-S(same)C-S(same)11111111110111111111111111111111111101111111111111111111111111011111111111111111110111111111111111111111111110111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111

38、11111111111011111111111111111111111111110111111111111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111110111111111111111111111A=0,S=0B=0,S=0C=0,S=0A=0,S=1100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000111111111

39、100111111111100111011111100100000000000100000000000100000000000111111111100111111111100111111111100111111111100111111111100111111111100111111111100111111111100111111111100111111111100100000000000111111111100100000000000111111111100100000000000111111111100111110111100111111111100111111111100111111111

40、100110111111100111111111100111111111100111111111100111111111100100000000000C-S(same)100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000A=S=0的個(gè)數(shù)B=S=0的個(gè)數(shù)C=S=0的個(gè)數(shù)A=0,S=1的個(gè)數(shù)7374752B=0,S=1C=0,S=1A=1,S=0B=1,S=0000000000001000000000000000

41、000000000000000000010000000000000000000000000000000000100000000000000000000000000000000000001000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

42、00000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000A=0,S=100000000000000000000000000100000000000000000000000000000000000000000000000000100000000000000000000000000000000B=0,S=1的個(gè)數(shù)C=0,S=1的個(gè)數(shù)A=1,S=0的個(gè)數(shù)B=1,S=0的個(gè)數(shù)2221A=0,S=1的個(gè)數(shù)2C=1,S=0A=1,S=1B

43、=1,S=1000001111100000110110000011111000001111100000111100000011111000001111100000111110000000000000000000000000000000000011111000001111100000111110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001111100000000000000011111000000000000000111110000

44、0000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011111B=1,S=00000011111000001111100000111110000011111000001111100000111110000011111000001101100000111110000011111C=1,S=0的個(gè)數(shù)A=S=1的個(gè)數(shù)B=S=1的個(gè)數(shù)07373B=1,S=0的個(gè)數(shù)1C=1,S=111111111111111111111111111111011000000

45、00000011111111011100000000000000000000000000000000000000001111000011110000111100000000000000000000000000000000000000001111B=1,S=11111111110111111111111111111111111111111C=S=1的個(gè)數(shù)73B=S=1的個(gè)數(shù)73ABCS11110110111111111010111111111100111111110110111111111010111111111111111111111111111111111111111111111111111

46、11111111111111010111111111111011011111111111111111111111111111100111111111111111101101111111146474841某某產(chǎn)產(chǎn)品品的的圖圖紙紙要要求求：150.1mm150.1mm供供應(yīng)應(yīng)商商A A供供應(yīng)應(yīng)商商B B115.17614.9765214.98714.9549315.027815.0347415.11715.033515.142514.9868614.934615.00032814.993415.04212915.064714.97533015.120514.99553114.881915.0028

47、3214.922614.97683315.052515.01063415.065214.98773514.978415.0488Max=Max=15.17615.17615.056415.0564Min=Min=14.872214.872214.953114.9531USL=USL=15.115.115.115.1LSL=LSL=14.914.914.914.9Mean=Mean=15.010215.010215.000815.0008=0.08590.08590.02600.02600.1017140.0082CP=CP=0.390.391.281.280.348577 1.269561CP

48、U=CPU=0.350.351.271.27CPL=CPL=0.430.431.291.29CPK=CPK=0.350.351.271.27Lot1Lot2Lot3Lot4Lot5Lot6Lot17115.0215.0115.0215.0215.0215.0215.00215.0014.9915.0115.0115.0315.0215.00315.0115.0415.0115.0215.0015.0014.99415.0015.0115.0015.0215.0015.0115.01515.0115.0115.0115.0015.0015.0115.02Xbar=15.0115.0115.011

49、5.0115.0115.0115.00R=0.020.050.020.020.030.020.02Rbar=0.03Xbar=15.0098UCLR=0.0557884 =C10*VLOOKUP(5,AC11:AF20,4,FALSE)LCLR=#VALUE!UCLXbar=15.0251352 =F10+C10*VLOOKUP(5,AC11:AF20,2,FALSE)LclXbar=14.9944648UCLXbar=15.02515.02515.02515.02515.02515.02515.025+2S=15.02015.02015.02015.02015.02015.02015.020

50、+1s=15.01515.01515.01515.01515.01515.01515.015Xbar=15.01015.01015.01015.01015.01015.01015.010-1s=15.00515.00515.00515.00515.00515.00515.005-2s=15.00015.00015.00015.00015.00015.00015.000LclXbar=14.99414.99414.99414.99414.99414.99414.994日期樣 本 數(shù)據(jù)115.0115.0015.0115.0115.0115.0114.99214.9914.9815.0015.00

51、15.0215.0114.99315.0015.0315.0015.0114.9914.9914.98414.9915.0014.9915.0114.9915.0015.00515.0015.0015.0014.9914.9915.0015.01X= 和 樣本數(shù)量#REF!#REF!#REF!#REF!#REF!#REF!#REF!R=最大-最小0.0200.0490.0200.0160.0290.0160.02412345678910111213141514.99 15.00 15.00 15.01 15.01 15.02 15.02 15.03 15.03 Lot18Lot19Lot20L

52、ot21Lot22Lot23Lot24Lot2515.0315.0115.0215.0115.0115.0014.9915.0215.0215.0015.0115.0115.0015.0015.0315.0215.0315.0115.0115.0115.0115.0315.0215.0015.0015.0015.0215.0014.9915.0115.0115.0015.0115.0215.0215.0115.0215.0115.0115.0115.0215.0115.0215.0115.0115.0115.0115.010.030.020.010.020.030.040.040.02A221

53、.8831.0240.7350.5860.4815.02515.02515.02515.02515.02515.02515.02515.02570.4215.02015.02015.02015.02015.02015.02015.02015.02080.3715.01515.01515.01515.01515.01515.01515.01515.01590.3415.01015.01015.01015.01015.01015.01015.01015.010100.3115.00515.00515.00515.00515.00515.00515.00515.00515.00015.00015.0

54、0015.00015.00015.00015.00015.00014.99414.99414.99414.99414.99414.99414.99414.99415.0215.0015.0115.0015.0014.9914.9815.0115.0114.9915.0015.0014.9914.9915.0215.0115.0215.0015.0015.0015.0015.0215.0114.9914.9914.9915.0114.9914.9815.0015.0014.9915.0015.0115.0115.0015.0115.0015.0015.00#REF!#REF!#REF!#REF!

55、#REF!#REF!#REF!#REF!0.0270.0210.0090.0180.0300.0360.0360.02112345678910111213141514.99 15.00 15.00 15.01 15.01 15.02 15.02 15.03 15.03 D3D4*3.27*2.57*2.28*2.11*2.000.081.920.141.860.181.820.221.78附件3:測量系統(tǒng)評(píng)估（穩(wěn)定性）儀器編號(hào)儀器名稱精度測量員對(duì)對(duì)特特殊殊原原因因采采取取措措施施的的說說明明X = X 平均值=3.749UCL=X+A2R=3.764LCL=X-A2R= 3.734任何超出控制

56、限的點(diǎn);連續(xù)7點(diǎn)全在中心線 之上或之下;連續(xù)7點(diǎn)上升或下降;任何其它明顯非隨機(jī) 的圓形.4.22345678910111213141516171819202122232425X 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749 3.749UCL 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.76

57、4 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764 3.764LCL 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734 3.734採採取取措措施施的的說說明明: :1.2.3.4.5.R = R 平均值= 0.026UCL=D4R= 0.055UCL=D3R=012345678910111213141516171819202122232425R 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026 0.026UCL 0.055 0.0