MSA改善案例.xls

GAGEGAGE CAPABILITYCAPABILITY PART ASM PART ASM NAMENAMEGAGEGAGE NAMENAME DPS 800GB AATS1 CHARACTERISTICCHARACTERISTICGAGEGAGE NUMBERNUMBER SPECIFICATIONSPECIFICATION12 15 0 02GAGEGAGE TYPETYPE TOTALTOTAL TOLERANCETOLERANCE0 040 04CHROMA 6000 Operator Operator A A 王王趁趁霞霞B B 宋宋志志敏敏 SampleSample1st1st2nd2nd3rd3rdRangeRange1st1st2nd2nd3rd3rdRangeRange NumberNumberTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrial 1 112 13712 13712 13112 13112 14312 1430 0120 01212 13712 13712 14312 14312 13712 1370 0060 006 2 212 16912 16912 16912 16912 16312 1630 0060 00612 16912 16912 16312 16312 16912 1690 0060 006 3 312 14012 14012 14612 14612 14612 1460 0060 00612 14612 14612 14612 14612 14012 1400 0060 006 4 412 16012 16012 16612 16612 1540 0120 01212 16612 16612 15412 16012 1600 0120 012 5 512 13912 13912 13312 13312 13312 1330 0060 00612 13312 13312 13312 13312 13912 1390 0060 006 6 612 14412 14412 15012 15012 15012 1500 0060 00612 15012 15012 15012 15012 14412 1440 0060 006 7 712 16312 16312 15612 15612 15612 1560 0070 00712 15612 15612 15612 15612 16312 1630 0070 007 8 812 16012 16012 16612 16612 16012 1600 0060 00612 16612 16612 16012 16012 16012 1600 0060 006 9 912 15612 15612 15012 15012 15612 1560 0060 00612 15012 15012 15612 15612 15612 1560 0060 006 101012 14212 14212 14812 14812 14212 1420 0060 00612 14812 14812 14212 14212 14212 1420 0060 006 TOTALSTOTALS121 510121 510121 515121 515121 503121 5030 0730 073121 510121 510121 503121 503121 510121 5100 0070 007 0 00730 0073 0 00670 0067 REF REF SumSum364 528364 528SumSum243 013243 013 A A12 150912 1509 B B12 150712 1507 TESTTEST FORFOR CONTROL CONTROL UpperUpper ControlControl LimitLimitUCLUCLR R D D4 4 0 0170 017 where where is is thethe averageaverage of of A A B B C C 0 0 0 00 07 73 3 0 0 0 00 06 67 7 D D4 4 3 273 27 forfor 2 2 trialstrials or or 2 582 58 forfor 3 3 trials trials If If anyany individualindividual rangerange exceedsexceeds thisthis limit limit thethe measurementmeasurement or or readingreading shouldshould bebe reviewed reviewed repeated repeated correctedcorrected or or discardeddiscarded as as appropriate appropriate andand newnew averagesaverages andand rangesranges shouldshould bebe puted MEASUREMENTMEASUREMENT SYSTEM GAGESYSTEM GAGE CAPABILITYCAPABILITY ANALYSIS ANALYSIS EquipmentEquipment VariationVariation Repeatability Repeatability K K1 1 3 3 0 05 5X X0 0 0 00 06 67 7 0 0 0 02 20 0 where where K K1 1 4 564 56 forfor 2 2 trialstrials or or 3 053 05 forfor 3 3 trials trials OperatorOperator VariationVariation Reproducibility Reproducibility K K2 2 diffdiff 2 2 7 7X X0 0 0 00 00 09 9 0 0 0 00 02 2 where where K K2 2 3 653 65 forfor 2 2 operatorsoperators or or 2 702 70 forfor 3 3 operators operators diffdiff is is thethe differencedifference betweenbetween thethe maxmax andand minmin TotalTotal Repeatability Repeatability andand Reproducibility Reproducibility VariationVariation R R R R Repeatability Repeatability 2 2 Reproducibility Reproducibility 2 2 0 0 0 02 20 0 2 2 0 0020 002 2 2 0 000420 00042 GAGEGAGE ACCEPTABILITYACCEPTABILITY DETERMINATION DETERMINATION TotalTotal GageGage Capability R R Capability R R SpecificationSpecification ToleranceTolerance NOTESNOTES R R XX R R RRR R X XXX APPROVEDAPPROVED BY BY ANALYSISANALYSIS PERFORMEDPERFORMED BY BY FILE GRRLOR XLSFILE GRRLOR XLS GageGage R RR R Contribution Contribution SourceSource VarCompVarComp of of VarComp VarComp TotalTotal GageGage R RR R 1 19E 051 19E 05 9 169 16 RepeatabilityRepeatability 1 19E 051 19E 05 9 169 16 ReproducibilityReproducibility 0 00E 000 00E 00 0 000 00 operatoroperator 0 00E 000 00E 00 0 000 00 Part To PartPart To Part 1 18E 041 18E 04 90 8490 84 TotalTotal VariationVariation 1 29E 041 29E 04 100 00100 00 StdDevStdDev StudyStudy VarVar Study Study VarVar Tolerance Tolerance SourceSource SD SD 5 15 SD 5 15 SD SV SV SV Toler SV Toler TotalTotal GageGage R RR R 3 44E 033 44E 03 1 77E 021 77E 02 30 2730 27 44 3244 32 RepeatabilityRepeatability 3 44E 033 44E 03 1 77E 021 77E 02 30 2730 27 44 3244 32 ReproducibilityReproducibility 0 00E 000 00E 00 0 00E 000 00E 00 0 000 00 0 000 00 operatoroperator 0 00E 000 00E 00 0 00E 000 00E 00 0 000 00 0 000 00 Part To PartPart To Part 1 08E 021 08E 02 5 58E 025 58E 02 95 3195 31 139 58139 58 TotalTotal VariationVariation 1 14E 021 14E 02 5 86E 025 86E 02 100 00100 00 146 45146 45 NumberNumber of of DistinctDistinct CategoriesCategories 4 4 GageGage R RR R forfor datadata Misc Tolerance Reported by Date of study Gage name 0 12 17 12 16 12 15 12 14 12 13 cba Xbar Chart by operator Sample Mean Mean 12 15 UCL 12 16 LCL 12 14 0 0 02 0 01 0 00 cba R Chart by operator Sample Range R 0 0067 UCL 0 01725 LCL 0 10 9 8 7 6 5 4 3 2 1 12 165 12 155 12 145 12 135 Part no operator operator Part no Interaction Average a b cba 12 17 12 16 12 15 12 14 12 13 operator By operator 10 9 8 7 6 5 4 3 2 1 12 17 12 16 12 15 12 14 12 13 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 140 120 100 80 60 40 20 0 Components of Variation Percent Gage R R ANOVA for data Part To PartPart To Part 1 08E 021 08E 02 5 58E 025 58E 02 95 3195 31 139 58139 58 由由上上分分析析 產產品品本本身身變變異異是是影影響響最最大大 首首要要解解決決是是產產品品之之間間的的變變異異 經經分分析析 產產品品在在測測試試過過程程中中 每每台台產產品品之之間間12V電電壓壓差差異異很很大大 是是因因為為溫溫度度不不同同產產品品的的電電壓壓不不同同 產產品品溫溫度度影影響響電電壓壓 改改善善對對策策 在在測測試試過過程程中中 在在產產品品治治具具上上加加一一風風扇扇來來散散熱熱 如如附附圖圖 FAN Before 在在治治具具上上加加風風扇扇後後再再做做GR R分分析析 如如附附檔檔2 Misc Tolerance Reported by Date of study Gage name 0 12 17 12 16 12 15 12 14 12 13 cba Xbar Chart by operator Sample Mean Mean 12 15 UCL 12 16 LCL 12 14 0 0 02 0 01 0 00 cba R Chart by operator Sample Range R 0 0067 UCL 0 01725 LCL 0 10 9 8 7 6 5 4 3 2 1 12 165 12 155 12 145 12 135 Part no operator operator Part no Interaction Average a b cba 12 17 12 16 12 15 12 14 12 13 operator By operator 10 9 8 7 6 5 4 3 2 1 12 17 12 16 12 15 12 14 12 13 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 140 120 100 80 60 40 20 0 Components of Variation Percent Gage R R ANOVA for data CALCULATIONCALCULATION WORKSHEETWORKSHEET PARTPART NUMBERNUMBER MEASUREMENTMEASUREMENT UNITUNIT V C C 劉劉換換芝芝 1st1st2nd2nd3rd3rdRangeRange TrialTrialTrialTrialTrialTrial 12 14312 14312 13712 13712 13712 1370 0060 006 12 16312 16312 16912 16912 16912 1690 0060 006 12 14612 14612 14612 14612 14012 1400 0060 006 12 16012 16612 16612 16612 1660 0060 006 12 13312 13312 13312 13312 13912 1390 0060 006 12 15012 15012 15012 15012 14412 1440 0060 006 12 15612 15612 15612 15612 16312 1630 0070 007 12 16012 16012 16612 16612 16012 1600 0060 006 12 15612 15612 15012 15012 15612 1560 0060 006 12 14212 14212 14812 14812 14212 1420 0060 006 121 509121 509121 521121 521121 516121 5160 0610 061 0 00610 0061 SumSum364 546364 546 C C12 151512 1515 0 0 0 00 06 61 1 0 0 0 00 06 67 7 RepeatabilityRepeatability ReproducibilityReproducibility GAGEGAGE CAPABILITYCAPABILITY 0 0 0 00 00 00 01 1 0 0 0 02 21 1 0 0210 021 5 51 1 4 4 0 040 04 R X GAGEGAGE CAPABILITYCAPABILITY If If anyany individualindividual rangerange exceedsexceeds thisthis limit limit thethe measurementmeasurement or or readingreading shouldshould bebe reviewed reviewed repeated repeated correctedcorrected or or discardeddiscarded as as appropriate appropriate andand newnew Repeatability Repeatability 2 2 Reproducibility Reproducibility 2 2 DATE DATE 饒饒二二德德7 7 7 7 2 20 00 06 6 Misc Tolerance Reported by Date of study Gage name 0 12 17 12 16 12 15 12 14 12 13 cba Xbar Chart by operator Sample Mean Mean 12 15 UCL 12 16 LCL 12 14 0 0 02 0 01 0 00 cba R Chart by operator Sample Range R 0 0067 UCL 0 01725 LCL 0 10 9 8 7 6 5 4 3 2 1 12 165 12 155 12 145 12 135 Part no operator operator Part no Interaction Average a b cba 12 17 12 16 12 15 12 14 12 13 operator By operator 10 9 8 7 6 5 4 3 2 1 12 17 12 16 12 15 12 14 12 13 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 140 120 100 80 60 40 20 0 Components of Variation Percent Gage R R ANOVA for data after Misc Tolerance Reported by Date of study Gage name 0 12 17 12 16 12 15 12 14 12 13 cba Xbar Chart by operator Sample Mean Mean 12 15 UCL 12 16 LCL 12 14 0 0 02 0 01 0 00 cba R Chart by operator Sample Range R 0 0067 UCL 0 01725 LCL 0 10 9 8 7 6 5 4 3 2 1 12 165 12 155 12 145 12 135 Part no operator operator Part no Interaction Average a b cba 12 17 12 16 12 15 12 14 12 13 operator By operator 10 9 8 7 6 5 4 3 2 1 12 17 12 16 12 15 12 14 12 13 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 140 120 100 80 60 40 20 0 Components of Variation Percent Gage R R ANOVA for data GAGEGAGE CAPABILITYCAPABILITY PART ASM PART ASM NAMENAMEGAGEGAGE NAMENAME DPS 800GB ACOROMA 6000 CHARACTERISTICCHARACTERISTICGAGEGAGE NUMBERNUMBER 12V SPECIFICATIONSPECIFICATION12 150 0 020GAGEGAGE TYPETYPE TOTALTOTAL TOLERANCETOLERANCE0 040 04CHROMA 6000 Operator Operator A A 宋宋志志敏敏B B 王王趁趁霞霞 SampleSample1st1st2nd2nd3rd3rdRangeRange1st1st2nd2nd3rd3rdRangeRange NumberNumberTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrial 1 112 14112 14112 14312 14312 14312 1430 0020 00212 14112 14112 14512 14512 14312 1430 0040 004 2 212 14512 14512 14412 14412 14612 1460 0020 00212 14712 14712 14312 14312 14312 1430 0040 004 3 312 14312 14312 14012 14012 14312 1430 0030 00312 14812 14812 14512 14512 14812 1480 0030 003 4 412 14012 14012 14312 14312 1400 0030 00312 14112 14112 14112 14112 14512 1450 0040 004 5 512 13912 13912 14212 14212 13912 1390 0030 00312 14012 14012 14212 14212 14412 1440 0040 004 6 612 14012 14012 14312 14312 14112 1410 0030 00312 14312 14312 14012 14012 14212 1420 0030 003 7 712 14112 14112 14412 14412 14312 1430 0030 00312 14012 14012 14312 14312 14312 1430 0030 003 8 812 14112 14112 14312 14312 14012 1400 0030 00312 14412 14412 14512 14512 14212 1420 0030 003 9 912 14312 14312 14212 14212 14012 1400 0030 00312 14612 14612 14112 14112 14512 1450 0050 005 101012 14712 14712 14712 14712 14512 1450 0020 00212 14512 14512 14512 14512 14612 1460 0010 001 TOTALSTOTALS121 420121 420121 431121 431121 420121 4200 0270 027121 435121 435121 430121 430121 441121 4410 0340 034 0 00270 0027 0 00340 0034 1 12 21 1 4 44 41 1 SumSum364 271364 271SumSum364 306364 306 A A12 142412 1424 B B12 143512 1435 TESTTEST FORFOR CONTROL CONTROL UpperUpper ControlControl LimitLimitUCLUCLR R D D4 4 0 0080 008 where where is is thethe averageaverage of of A A B B C C 0 0 0 00 02 27 7 0 0 0 00 03 34 4 D D4 4 3 273 27 forfor 2 2 trialstrials or or 2 582 58 forfor 3 3 trials trials If If anyany individualindividual rangerange exceedsexceeds thisthis limit limit thethe measurementmeasurement or or readingreading shouldshould bebe reviewed reviewed repeated repeated correctedcorrected or or discardeddiscarded as as appropriate appropriate andand newnew averagesaverages andand rangesranges shouldshould bebe puted MEASUREMENTMEASUREMENT SYSTEM GAGESYSTEM GAGE CAPABILITYCAPABILITY ANALYSIS ANALYSIS EquipmentEquipment VariationVariation Repeatability Repeatability K K1 1 3 3 0 05 5X X0 0 0 00 02 29 9 0 0 0 00 09 9 where where K K1 1 4 564 56 forfor 2 2 trialstrials or or 3 053 05 forfor 3 3 trials trials OperatorOperator VariationVariation Reproducibility Reproducibility K K2 2 diffdiff 2 2 7 7X X0 0 0 00 02 23 3 0 0 0 00 06 6 where where K K2 2 3 653 65 forfor 2 2 operatorsoperators or or 2 702 70 forfor 3 3 operators operators diffdiff is is thethe differencedifference betweenbetween thethe maxmax andand minmin TotalTotal Repeatability Repeatability andand Reproducibility Reproducibility VariationVariation R R R R Repeatability Repeatability 2 2 Reproducibility Reproducibility 2 2 0 0 0 00 09 9 2 2 0 0060 006 2 2 0 000080 00008 GAGEGAGE ACCEPTABILITYACCEPTABILITY DETERMINATION DETERMINATION TotalTotal GageGage Capability R R Capability R R SpecificationSpecification ToleranceTolerance NOTESNOTES R R XX R R RRR R X XXX APPROVEDAPPROVED BY BY ANALYSISANALYSIS PERFORMEDPERFORMED BY BY FILE GRRLOR XLSFILE GRRLOR XLS Contribution Contribution SourceSource VarCompVarComp of of VarComp VarComp TotalTotal GageGage R RR R 6 39E 066 39E 06 95 6295 62 RepeatabilityRepeatability 2 67E 062 67E 06 39 8939 89 ReproducibilityReproducibility 3 73E 063 73E 06 55 7355 73 operatoroperator 9 15E 079 15E 07 13 6813 68 operator Partoperator Part nono 2 81E 062 81E 06 42 0542 05 Part To PartPart To Part 2 93E 072 93E 07 4 384 38 TotalTotal VariationVariation 6 69E 066 69E 06 100 00100 00 StdDevStdDev StudyStudy VarVar Study Study VarVar Tolerance Tolerance SourceSource SD SD 5 15 SD 5 15 SD SV SV SV Toler SV Toler TotalTotal GageGage R RR R 2 53E 032 53E 03 1 30E 021 30E 02 97 7997 79 32 5532 55 RepeatabilityRepeatability 1 63E 031 63E 03 8 41E 038 41E 03 63 1663 16 21 0221 02 ReproducibilityReproducibility 1 93E 031 93E 03 9 94E 039 94E 03 74 6674 66 24 8524 85 operatoroperator 9 56E 049 56E 04 4 93E 034 93E 03 36 9936 99 12 3112 31 operator Partoperator Part nono 1 68E 031 68E 03 8 63E 038 63E 03 64 8564 85 21 5921 59 Part To PartPart To Part 5 41E 045 41E 04 2 79E 032 79E 03 20 9220 92 6 966 96 TotalTotal VariationVariation 2 59E 032 59E 03 1 33E 021 33E 02 100 00100 00 33 2933 29 NumberNumber of of DistinctDistinct CategoriesCategories 0 0 GageGage R RR R forfor datadata Misc Tolerance Reported by Date of study Gage name 0 12 149 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 12 139 cba Xbar Chart by operator Sample Mean Mean 12 14 UCL 12 15 LCL 12 14 0 0 008 0 006 0 004 0 002 0 000 cba R Chart by operator Sample Range R 0 002933 UCL 0 007551 LCL 0 10 9 8 7 6 5 4 3 2 1 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 Part no operator operator Part no Interaction Average a b cba 12 150 12 145 12 140 operator By operator 10 9 8 7 6 5 4 3 2 1 12 150 12 145 12 140 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 100 50 0 Components of Variation Percent Gage R R ANOVA for data Part To PartPart To Part 5 41E 045 41E 04 2 79E 032 79E 03 20 9220 92 6 966 96 由由以以上上數數據據可可知知 零零件件變變異異由由139 8改改善善到到了了6 96 但但totalGR R為為32 55 還還沒沒有有達達到到我我們們的的目目標標 第第二二步步改改善善 將將電電壓壓量量測測用用HP 34401A代代替替chroma6000的的SA量量測測 再再來來做做GR R分分析析 數數據據如如附附檔檔3 Misc Tolerance Reported by Date of study Gage name 0 12 149 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 12 139 cba Xbar Chart by operator Sample Mean Mean 12 14 UCL 12 15 LCL 12 14 0 0 008 0 006 0 004 0 002 0 000 cba R Chart by operator Sample Range R 0 002933 UCL 0 007551 LCL 0 10 9 8 7 6 5 4 3 2 1 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 Part no operator operator Part no Interaction Average a b cba 12 150 12 145 12 140 operator By operator 10 9 8 7 6 5 4 3 2 1 12 150 12 145 12 140 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 100 50 0 Components of Variation Percent Gage R R ANOVA for data CALCULATIONCALCULATION WORKSHEETWORKSHEET PARTPART NUMBERNUMBER 12V電電壓壓 MEASUREMENTMEASUREMENT UNITUNIT V ZEROZERO EQUALSEQUALS 0 0 C C 賈賈锐锐玲玲 1st1st2nd2nd3rd3rdRangeRange TrialTrialTrialTrialTrialTrial 12 14312 14312 14012 14012 14212 1420 0030 003 12 14612 14612 14212 14212 14412 1440 0040 004 12 14312 14312 14112 14112 14012 1400 0030 003 12 14212 14212 14312 14312 14112 1410 0020 002 12 14312 14312 14612 14612 14512 1450 0030 003 12 14512 14512 14812 14812 14812 1480 0030 003 12 14612 14612 14512 14512 14612 1460 0010 001 12 14712 14712 14612 14612 14512 1450 0020 002 12 14812 14812 14712 14712 14912 1490 0020 002 12 14412 14412 14812 14812 14612 1460 0040 004 121 447121 447121 446121 446121 446121 4460 0270 027 0 00270 0027 SumSum364 339364 339 C C12 144612 1446 0 0 0 00 02 27 7 0 0 0 00 02 29 9 RepeatabilityRepeatability ReproducibilityReproducibility GAGEGAGE CAPABILITYCAPABILITY 0 0 0 00 00 00 04 4 0 0 0 01 11 1 0 0110 011 2 27 7 1 1 0 040 04 R X GAGEGAGE CAPABILITYCAPABILITY If If anyany individualindividual rangerange exceedsexceeds thisthis limit limit thethe measurementmeasurement or or readingreading shouldshould bebe reviewed reviewed repeated repeated correctedcorrected or or discardeddiscarded as as appropriate appropriate andand newnew Repeatability Repeatability 2 2 Reproducibility Reproducibility 2 2 DATE DATE 饒饒二二德德1 10 0 1 12 2 2 20 00 06 6 Misc Tolerance Reported by Date of study Gage name 0 12 149 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 12 139 cba Xbar Chart by operator Sample Mean Mean 12 14 UCL 12 15 LCL 12 14 0 0 008 0 006 0 004 0 002 0 000 cba R Chart by operator Sample Range R 0 002933 UCL 0 007551 LCL 0 10 9 8 7 6 5 4 3 2 1 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 Part no operator operator Part no Interaction Average a b cba 12 150 12 145 12 140 operator By operator 10 9 8 7 6 5 4 3 2 1 12 150 12 145 12 140 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 100 50 0 Components of Variation Percent Gage R R ANOVA for data Misc Tolerance Reported by Date of study Gage name 0 12 149 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 12 139 cba Xbar Chart by operator Sample Mean Mean 12 14 UCL 12 15 LCL 12 14 0 0 008 0 006 0 004 0 002 0 000 cba R Chart by operator Sample Range R 0 002933 UCL 0 007551 LCL 0 10 9 8 7 6 5 4 3 2 1 12 148 12 147 12 146 12 145 12 144 12 143 12 142 12 141 12 140 Part no operator operator Part no Interaction Average a b cba 12 150 12 145 12 140 operator By operator 10 9 8 7 6 5 4 3 2 1 12 150 12 145 12 140 Part no By Part no Contribution Study Var Tolerance Part to PartReprodRepeatGage R R 100 50 0 Components of Variation Percent Gage R R ANOVA for data GAGEGAGE CAPABILITYCAPABILITY PART ASM PART ASM NAMENAMEGAGEGAGE NAMENAME DPS 800GB AATS1 CHARACTERISTICCHARACTERISTICGAGEGAGE NUMBERNUMBER SPECIFICATIONSPECIFICATION12 15 0 02GAGEGAGE TYPETYPE TOTALTOTAL TOLERANCETOLERANCE0 040 04HP 34401A Operator Operator A A 宋宋志志敏敏B B 王王趁趁霞霞 SampleSample1st1st2nd2nd3rd3rdRangeRange1st1st2nd2nd3rd3rdRangeRange NumberNumberTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrialTrial 1 112 14912 14912 15012 1