品质图表制作

1、2009/10/202022/3/612345672009/10/271 Sunday周末2099/12/152009/10/122009/10/132009/10/142009/10/152009/10/162009/10/172 Monday日常 TuesdayMondayTuesdayWednesday Thursday FridaySaturday1 Sunday3 Tuesday日常 日常日常日常日常日常日常周末4 Wednesday 日常44565 Thursday日常12.12022/3/6 21:466 Friday日常137 Saturday周末6150.9099751671

2、今天是:2 20 02 22 2/ /3 3/ /6 6跟进项目计划完成时间是否关闭通知1 041-000477-00的承认书制作2010/1/7否否时时间间已已超超, ,请请注注意意关关闭闭该该问问题题2深象M3组合螺钉M04-051140-弹垫过大拧紧后弹垫会张开2009/12/25否否时时间间已已超超, ,请请注注意意关关闭闭该该问问题题3 品质常用工具与excel的运用技巧2010/1/5否否时时间间已已超超, ,请请注注意意关关闭闭该该问问题题4 表面处理的培训2009/12/26是是-5 到飞黄出差2009/12/27是是-89106-2009/10/182009/10/19200

3、9/10/207-SundayMondayTuesday8-周末日常日常1 时间已超,请注意关闭该问题2 该项目紧急，请速完成3 距离完成还有时间，请注意及时完成来来料料质质量量检检验验部部加加班班申申请请表表-2009-2009年年( ( 0707 ) )月月项项目目日日 期期统统计计加加班班事事由由备备注注姓姓名名工工码码组组别别123456789101112 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31日常周末假日总计50002165机械2113332380220847休息50003253机械8227.533330833

4、22857.557.5事务处理50004257机械223323338332084545休息50004593机械22113322383202851来料检验50005507机械211332338332304646来料检验50005694机械22113323083222851培训50005891机械113323383022848来料检验50006049机械211332038322204141来料检验50006368机械888211333300332005757休息50006367机械22113322082222849三瑞外检50007212机械82211333338332005454休息 备注: 1

5、)每天下班前提出当日加班申请、周五下班前提出周末加班申请; 2)每天在相应的日期中记录加班申请小时; 3)加班申请事由每次申请时进行更新; 4)每月根据周末/假日的日期更新表格的统计算法; 5)若当天申请加班时间与实际加班时间有差异,请于第二天申请时更新;6)标注黄色为支援产线1234567891011总计 日常 周末 假日总计日常 周末 假日4700 057.50005800 0570004500 0540005100 0510004600 0510005100 0490004800 0480004100 0470005700 0460004900 0450005400 041000关关于于

6、第第四四季季度度散散热热片片的的不不良良汇汇总总数数据据如如下下: :s/ns/n螺螺纹纹不不良良位位置置度度超超差差导导通通不不良良表表面面赃赃物物来来错错物物料料变变形形其其它它不不良良数数量量5 50 03 32 21 18 86 64 42 24 4116不不良良比比率率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% %1 1. .7 72 2% %3 3. .4 45 5% %累累积积不不良良率率4 43 3. .1 10 0% %7 70 0. .6 69 9% %

7、8 86 6. .2 21 1% %9 91 1. .3 38 8% %9 94 4. .8 83 3% %9 96 6. .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/第第四四季季度度散散热热片片不不良良状状况况螺纹不良位置度超差导通不良表面赃物来错物料变形其它0204060801000%10%20%30%40%50%60%70%80%90%100%不良类别不良数量不良比率不良数量累积不良率某钣金件长度尺寸:150.2mm迈瑞友信鑫115.1515.13215.08

8、15.06315.0214.99414.8614.83514.8914.87615.1715.15714.9414.97814.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.9628

9、14.7614.892914.9415.103014.7114.85R=0.792R2=0.6315.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 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欧最近发现客户的产品波动比较大，所以归纳了近段时间的IQC来料测量

10、数值，数值如下：第1批第2批第3批第4批1489.1476.4507.4526.92511.1520.6475.1491.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计算组数K=7.125725493 =1+3.32*LOG(COUNTA(C11:I20

11、)四舍五入得 K= 7计算组距=9.314285714 =D23/D25计算上下组列：下界上界区间1469.3478.6469.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.

12、1534.40 2 4 6 8 10 12 14 16 18 区间值个数4 12 16 17 10 7 4 电阻500+/-20直方图分析10 2 4 6 8 10 12 14 16 18 区间值个数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 区间

13、值个数第5批第6批第7批495.5506.5503.4469.4500.8500.5519.0508.8518.9480.3484.3528.8509.4484.9495.6501.4507.6507.5500.0515.2493.9480.5482.3493.3495.0490.6511.3501.0518.5527.2组数4121617107470最近发现客户的产品波动比较大，所以归纳了近段时间的IQC来料测量数值，数值如下：4 12 16 17 10 7 4 电阻500+/-20直方图分析469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8

14、515.8525.1525.1534.40 2 4 6 8 10 12 14 16 18 区间值个数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 区间值个数4 12 16 17 10 7 4 电阻500+/-20直方图分析10 2 4 6 8 10 12 14 16 18 区间值个数469.3478.6478.6487.9487.9497.2497.2506.5506.5515.8515

15、.8525.1525.1534.4 附件4:測量系統分析（GR&R）量具重复性和再现现性性数数据据收收集集表評價人/试验零件均值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.82

16、676.83006.74006.74336.73676.8197极差0.01000.01000.01000.01000.02000.02000.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

17、.88676.82676.81676.82336.82336.73336.72336.73006.8133极差0.01000.01000.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.7300

18、6.7200均值6.88336.87676.88336.82676.82336.82336.82336.72676.73336.72676.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= )/# 评价人数 = R=0.0120XDIFF=MaxX= -MinX= =XDIFF= 0.00702.580.0310*

19、UCLR=R= xD4= =2.580.030962次试验对于D4*=3.27，3次试验时4*=2.58。UCLR表示单个极差的控制限，圈出那些超出极限的点，识别原因并纠正。使用与开始时相同的评价人和单位重复这些读数，或者放弃某些值，从保留的观察值重新平均，生新计算R和控制限。RaXaRbXbRcXc=XRUCLDR=4*注：_製表/日期：_ 審核/日期:_附件4: 測量系統分析（GR&R）量具重复性和再现性報告物料编号名称:量具名称:日期：特性：量具编号: 评价人：测量对象：量具类型：从数据表：R=0.012XDIFF=0.007RP=0.156667测量单位分析% 总变差重复性设备

20、变差(EV) (EV) %EV=100EV/TV试验次数K1=0.012X0.590820.886=0.007089630.5908再现性-评价人变差（AV) (AV) %AV=100AV/TV=0.0036600250.523123=n= 10r= 3K20.70710.5231重复性和再现性 (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.3

21、249=100.3146综合判定 %GRRR条件下接受原因分析ndc可以接受表格中的理论和常数信息见MSA参考手册，第三版1*KREV =)/()*(222nrEVKXAVDIFF)(22A VE VG R R+=3*KRpPV =)&(22PVRRTV製表/日期：_ 審核/日期:_14.20 %7.33 %15.98 %98.71 %8.71附件4: 測量系統分析（GR&R）量具重复性和再现性報告日期：评价人：% 总变差 %EV=100EV/TV %AV=100AV/TV%GRR=100GRR/TV%PV=100PV/TVndc =1.41(PV/GRR)表格中的理论和常数信

22、息见MSA参考手册，第三版審核/日期:_附件6:测量系统分析（交叉法）量具名称物料编号名称测量特性评价人分析人一一致致性性判判定定标标准准：通用的比例法则是Kappa0.75则表示有很好的一致性，Kappa0.40则表示一致性不好。有有效效性性判判定定标标准准有效性漏报率错误报警率可接受90%2%5%边边界界接接受受但但要要改改善善80%80%5%5%10%10%不可接受80%5%10%交交叉叉法法评评估估结结果果测测量量员员之之间间一一致致性性评评价价KappaABC结论A0.910.92B0.910.93C0.920.93测测量量员员与与标标准准之之间间一一致致性性评评价价KappaABC

23、结论标准0.950.960.97系系统统有有效效性性评评价价结结果果有效性漏发警报的比例误发警报的比例结论A100%0.0%#DIV/0!B100%0.0%#DIV/0!C100%0.0%#DIV/0! 评价者零件A-1A-2A-3B-1B-2B-3C-1C-2C-3参考决定111111111112110111111131111111111411111111115111101111161111111111711111111118111111011190000000000100000000000110010000000121111111111131111111111141111101111150

24、000000000160000000000170000000000180000000000190000000000200000000000210000000000220000000000230000000000240000000000251111111111260000000000271111111111280000000000291111111111300000000000310000100000320000000000330000000000340000000000350100000000360000000000370000000000380000000000390000000000401

25、111111111411111111111421111111111431111110111441111111111451111111111461111111111471111111111481101111111491111111111501111111111 备注：产品检验合格在相应表格填“1”，不合格填“0”A*BA*B交交叉叉表表B总计01A0数量72375期望数量38.0037.00751数量47175期望数量38.0037.0075总计数量7674150期望数量7674150B*CB*C交交叉叉表表C总计01B0数量74276期望数量39.0136.99761数量37174期望数量37

26、.9936.0174总计数量7773150期望数量7773150A*CA*C交交叉叉表表C总计01A0数量73275期望数量38.5036.50751数量47175期望数量38.5036.5075总计数量7773150期望数量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总计01A0数量73275期望数量37.5037.50751数量27375期望数量37.5037.50

27、75总计数量7575150期望数量7575150B*SB*S交交叉叉表表S总计01B0数量74276期望数量38.0038.00761数量17374期望数量37.0037.0074总计数量7575150期望数量7575150A*SA*S交交叉叉表表S总计01C0数量75277期望数量38.5038.50771数量07373期望数量36.5036.5073总计数量7575150期望数量7575150KappaABCS0.950.960.97PoPePoPe0.9733330.5 0.9866670.50.980.5A-B(same)A-C(same)B-C(same)11111111110110

28、111111111111111111101111101111111111111111111011011111111111111111110110111111111111111111110111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110111110111111111111111111111111101101111111111111111111111111111111111111

29、11111111111111111111111110110111111111111111111111111111111111110110111111111111111111A=0,B=0A=0,C=0B=0,C=0A=0,B=1100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000111111111100111111111100111011011100100000000000100000000000000000000000111111111100111111

30、111100111111111100111111111100111111111100111111111100111111111100111111111100111111111100111111111100100000000000111111111100100000000000111111111100100000000000111111111100110111110101111111111100111111111100111111111100110110111100111111111100111111111100111111111100111111111100100000000000B-C(sa

31、me)100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000A=B=0的个数A=C=0的个数B=C=0的个数A=0,B=1的个数7273743A=0,C=1B=0,C=1A=1,B=0A=1,C=0000000000001001000000000000000000000000000000000010010000000000000000000000000000000000100000000000000000000

32、000000000001000000000000000000000000000001001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000

33、00000000000000000000000000000000A=0,B=100000000000000000000000000000000100000000000000000000000000000000000000000000100100000000000000000000000000000A=0,C=1的个数B=0,C=1的个数A=1,B=0的个数A=1,C=0的个数2244A=0,B=1的个数3B=1,C=0A=1,B=1A=1,C=1000001111100000110110000011111000001111100000101110000011111000001111100100

34、111010000000000000000000001000000000000011111000001111100000110110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001111100000000000000011111000000000000000111110000000000000100000000000000000000000000000000000010000000000000000000000000000000000

35、0000000000000000000011111A=1,C=00000011111000001111100100111010000011111000001111100000111110000011111000001101100000111110000011111B=1,C=0的个数A=B=1的个数A=C=1的个数37171A=1,C=0的个数4B=1,C=111110111111111111101111111111011000000000000111111111110000000000000000000000000000000000000000011110000111100001111000

36、00000000000000000000000000000000000001111A=1,C=11111111110111111111111111111011111111111B=C=1的个数71A=C=1的个数71A-S(same)B-S(same)C-S(same)111111111101111111111111111111111111011111111111111111111111110111111111111111111101111111111111111111111111101111111111111111111111111111111111111111111111111111111

37、1111111111111111111111111111111111111111111111111111111111111111111111111111111011111111111111111111111111110111111111111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111110111111111111111111111A=0,S=0B=0,S=0C=0,S=0A=0,S=11000000000001000000000001000000000001

38、000000000001000000000001000000000001000000000001000000000001111111111001111111111001110111111001000000000001000000000001000000000001111111111001111111111001111111111001111111111001111111111001111111111001111111111001111111111001111111111001111111111001000000000001111111111001000000000001111111111001

39、00000000000111111111100111110111100111111111100111111111100111111111100110111111100111111111100111111111100111111111100111111111100100000000000C-S(same)100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000100000000000A=S=0的个数B=S=0的个数C=S=0的个数A=0,

40、S=1的个数7374752B=0,S=1C=0,S=1A=1,S=0B=1,S=00000000000010000000000000000000000000000000000100000000000000000000000000000000001000000000000000000000000000000000000010000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

41、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000A=0,S=100000000000000000000000000100000000000000000000000000000000000000000000000000100000000000000000000000000000000B=

42、0,S=1的个数C=0,S=1的个数A=1,S=0的个数B=1,S=0的个数2221A=0,S=1的个数2C=1,S=0A=1,S=1B=1,S=10000011111000001101100000111110000011111000001111000000111110000011111000001111100000000000000000000000000000000000111110000011111000001111100000000000000000000000000000000000000000000000000000000000000000000000000000000000000

43、000000000000000000011111000000000000000111110000000000000001111100000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000011111B=1,S=00000011111000001111100000111110000011111000001111100000111110000011111000001101100000111110000011111C=1,S=0的个数A=S=1的个数B

44、=S=1的个数07373B=1,S=0的个数1C=1,S=11111111111111111111111111111101100000000000011111111011100000000000000000000000000000000000000001111000011110000111100000000000000000000000000000000000000001111B=1,S=11111111110111111111111111111111111111111C=S=1的个数73B=S=1的个数73ABCS111101101111111110101111111111001111111

45、1011011111111101011111111111111111111111111111111111111111111111111111111111111111010111111111111011011111111111111111111111111111100111111111111111101101111111146474841某某产产品品的的图图纸纸要要求求：150.1mm150.1mm供供应应商商A A供供应应商商B B115.17614.9765214.98714.9549315.027815.0347415.11715.033515.142514.9868614.934615.

46、00032814.993415.04212915.064714.97533015.120514.99553114.881915.00283214.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.085

47、90.02600.02600.1017140.0082CP=CP=0.390.391.281.280.348577 1.269561CPU=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.0

48、015.0115.01515.0115.0115.0115.0015.0015.0115.02Xbar=15.0115.0115.0115.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

49、.02515.02515.02515.025+2S=15.02015.02015.02015.02015.02015.02015.020+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.

50、994日期样 本 数据115.0115.0015.0115.0115.0115.0114.99214.9914.9815.0015.0015.0215.0114.99315.0015.0315.0015.0114.9914.9914.98414.9915.0014.9915.0114.9915.0015.00515.0015.0015.0014.9914.9915.0015.01X= 和 样本数量#REF!#REF!#REF!#REF!#REF!#REF!#REF!R=最大-最小0.0200.0490.0200.0160.0290.0160.02412345678910111213141514

51、.99 15.00 15.00 15.01 15.01 15.02 15.02 15.03 15.03 Lot18Lot19Lot20Lot21Lot22Lot23Lot24Lot2515.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.

52、0115.0215.0115.0115.0115.0115.010.030.020.010.020.030.040.040.02A221.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.01010

53、0.3115.00515.00515.00515.00515.00515.00515.00515.00515.00015.00015.00015.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

54、.0014.9915.0015.0115.0115.0015.0115.0015.0015.00#REF!#REF!#REF!#REF!#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:测测量量系系统统评评估估（稳稳定定性性）仪器编号仪器名称精度

55、测量员對對特特殊殊原原因因采采取取措措施施的的說說明明X = X 平均值=3.749UCL=X+A2R=3.764LCL=X-A2R= 3.734任何超出控制限的點;連續7點全在中心線 之上或之下;連續7點上升或下降;任何其它明顯非隨機 的圓形.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

56、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.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.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

57、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.055 0.055 0.055 0.055 0