
å®éšèšç»æ³ïŒDOEïŒå ¥éââå°ãªã詊è¡ã§æé©æ¡ä»¶ãèŠã€ãã
æ°ããéšåã®å å·¥æ¡ä»¶ãåºãããšã«ãªã£ããæ¯ããæ¡ä»¶ã¯ãååé床ã»éãã»å·¥å ·ã®3ã€ã
ãšããããé床ãå€ããŠè©Šããå°ãæªããªã£ãããããå ã«æ»ããŠãä»åºŠã¯éããå€ããããã£ãšæªããªã£ããå·¥å ·ãå€ããŠã¿ãããããããã¡ã
ãçµå±ãããŸã®æ¡ä»¶ããã¡ã°ãè¯ãã§ããã
ââãã®çµè«ãééã£ãŠãããããããŸããã
ä»åã¯ãæ¡ä»¶åºãã®è©Šè¡é¯èª€ããåãã«å€ããéå ·ã**å®éšèšç»æ³ïŒDOEïŒ**ã解説ããŸãã
æåã«ïŒäžå åãã€å€ããŠã¯ãããªã
æ¡ä»¶ã1ã€ãã€å€ããŠè©Šãæ¹æ³ãã**äžå åå®éšïŒOFATïŒ**ãšåŒã³ãŸããçŸå Žã§ãã¡ã°ããã䜿ãããŠããããæ¹ã§ãã
ãããŠããã¡ã°ã倱æããŠããããæ¹ã§ããããŸãã
ãªããã¡ãªã®ããå®äŸã§èŠãŠãã ããã
å®äŸïŒ3ã€ã®æ¡ä»¶ã§è¡šé¢ç²ããäžãã
ååå å·¥ã®è¡šé¢ç²ãïŒRaã»å°ããã»ã©è¯ãïŒãäžãããããšãã課é¡ã§ããæ¯ããæ¡ä»¶ã¯3ã€ã
| å å | æ°Žæº1 | æ°Žæº2 |
|---|---|---|
| AïŒååé床 | 120 m/min | 180 m/min |
| BïŒéã | 0.10 mm/rev | 0.20 mm/rev |
| CïŒå·¥å
· | æ¢åå | æ°å |
çŸç¶ã¯ Aäœéã»Béã0.10ã»Cæ¢åå·¥å · ã§ãRa 1.45 ÎŒm ã§ãã
ãŸããOFATã§ãã£ãŠã¿ã
çŸç¶ãåºæºã«ã1ã€ãã€å€ããŸãã
| å€ãããã® | çµæ | å€å® |
|---|---|---|
| A ãé«é180ã« | Ra 1.58 | +0.13 æªå |
| B ãéã0.20ã« | Ra 2.70 | +1.25 æªå |
| C ãæ°åå·¥å
·ã« | Ra 1.62 | +0.17 æªå |
3ã€ãšãæªåããŸããã
çŸå Žãªãããçµè«ããŸãã
ãé床ãéããå·¥å ·ããå€ããªãã»ãããããçŸç¶ã®Ra 1.45ãæé©ã
ãããŠãæ°åå·¥å ·ã¯ã广ãªãããšããŠåŽäžãããŸãã
ãšããããå šéšã®çµåãã詊ããš
3å åã»2æ°Žæºãªããçµåãã¯å šéšã§ 2Ã2Ã2 ïŒ 8éãã§ããå šéšãã£ãŠã¿ãŸãã
| No | A ååé床 | B éã | C å·¥å
· | Ra |
|---|---|---|---|---|
| 1 | äœé120 | 0.10 | æ¢å | 1.45 |
| 2 | äœé120 | 0.10 | æ°å | 1.62 |
| 3 | äœé120 | 0.20 | æ¢å | 2.70 |
| 4 | äœé120 | 0.20 | æ°å | 2.88 |
| 5 | é«é180 | 0.10 | æ¢å | 1.58 |
| 6 | é«é180 | 0.10 | æ°å | 1.02 |
| 7 | é«é180 | 0.20 | æ¢å | 2.82 |
| 8 | é«é180 | 0.20 | æ°å | 2.20 |
No.6 ã Ra 1.02ãçŸç¶ã®1.45ãã 0.43 ãäœãïŒ29.7%æ¹åïŒã
OFATã§ã¯ããã®æ¡ä»¶ã«æ°žä¹ ã«ãã©ãçããŸããããªããªãã
A ãåç¬ã§å€ãããšæªåãã
C ãåç¬ã§å€ãããšæªåãã
ã§ããAãšCãåæã«å€ãããšå€§ããè¯ããªã
ããã§ãã
亀äºäœçšââOFATã倱æããçç±
ããŸèµ·ããŠããã®ã¯ã亀äºäœçšãšåŒã°ããçŸè±¡ã§ãã
ããæ¡ä»¶ã®å¹ãæ¹ããå¥ã®æ¡ä»¶ã«ãã£ãŠå€ããããšã
æ°åã§èŠãŠã¿ãŸããæ°åå·¥å ·ã«å€ãããšãã®å¹æããé床å¥ã«èšç®ããŸãã
| é床 | æ¢åå·¥å
·ã®å¹³å | æ°åå·¥å
·ã®å¹³å | æ°åã®å¹æ |
|---|---|---|---|
| äœé120 | 2.075 | 2.250 | +0.175ïŒæªåïŒ |
| é«é180 | 2.200 | 1.610 | â0.590ïŒæ¹åïŒ |
äœéã§ã¯æ°åå·¥å ·ã¯æªåãããé«éã§ã¯å€§ããæ¹åãããã 广ã®åããé転ããŠããŸãã
çŸå Žçã«ã¯ããèªããŸãã
ãã®æ°åå·¥å ·ã¯ãé«éåè»¢ã§æ¬é ãçºæ®ããèšèšã«ãªã£ãŠããã
äœéã§è©Šããããã§ãã䜿ããªãå·¥å ·ããšå€æãããŠããã
**OFATã¯ãå¿ ããä»ã®æ¡ä»¶ãçŸç¶ã«åºå®ãããŸãŸã1ã€ãåãããŸãã**ã ãããããããçµåãã®å¹æã¯åççã«èŠã€ããããŸããã
广ã®å€§ããã䞊ã¹ãŠã¿ã
忡件ã®å¹æãèšç®ãããšããããªããŸãã
| 广 | 倧ãã |
|---|---|
| B éãã®äž»å¹æ | +1.2325 |
| AÃC 亀äºäœçš | â0.3825 |
| A ååé床ã®äž»å¹æ | â0.2575 |
| C å·¥å
·ã®äž»å¹æ | â0.2075 |
AÃCã®äº€äºäœçšïŒ0.3825ïŒããAãšCããããã®äž»å¹æãã倧ããã
ããããå·¥çšã§ã¯ãOFATã¯100%倱æããŸãããããŠæ®å¿µãªããã補é çŸå Žã®æ¡ä»¶åºãã§ã¯çãããããŸããã
ïŒäž»å¹æã¯ãæ°Žæº2ã®å¹³å â æ°Žæº1ã®å¹³åãã§èšç®ããŸããExcelã®å¹³å颿°ã ãã§åºããŸããïŒ
å®éšèšç»æ³ãšã¯äœã
ãããŸã§ãåæ©ã§ããå®éšèšç»æ³ïŒDOEïŒDesign of ExperimentsïŒãäžèšã§ãããšã
æ¡ä»¶ã®çµåããããããããèšç»ããŠæ¯ãæ¹æ³ã
ãã£ãŠããããšã¯3ã€ã§ãã
â å åãšæ°Žæºã決ãã
ãäœãããã©ã®ç¯å²ã§ãæ¯ãããå ã«æ±ºããŸããäžã®äŸãªã3å åã»2æ°Žæºã
â¡ çµåã衚ãäœã£ãŠãå šéšããïŒãŸãã¯äžéšãèšç»çã«éžã¶ïŒ
æãã€ãã§è©Šãã®ã§ã¯ãªãã衚ãäœã£ãŠããå®éšããŸãã
â¢ äž»å¹æãšäº€äºäœçšãèšç®ãã
å¹³åã®åŒãç®ã ãã§ããé£ããèšç®ã¯èŠããŸããã
ã1åãã€è©ŠããŠãè¯ããã°æ¡çšãããã衚ãäœã£ãŠäžæ°ã«åããã«å€ããã ãã§ãã
詊è¡åæ°ãå€ããããšãââçŽäº€è¡š
3å åãªã8åã§æžã¿ãŸãããå åãå¢ãããšççºããŸãã
| æ¡ä»¶ | å
šçµåã | çŽäº€è¡šã䜿ããš |
|---|---|---|
| 2æ°Žæº 3å å | 8å | L4ïŒ4åïŒãã ã亀äºäœçšã¯èŠãããªãïŒ |
| 2æ°Žæº 4å å | 16å | L8ïŒ8å |
| 2æ°Žæº 7å å | 128å | L8ïŒ8åïŒ94%åæžïŒ |
| 3æ°Žæº 4å å | 81å | L9ïŒ9åïŒ89%åæžïŒ |
7å åã8åã§èª¿ã¹ãããââãããçŽäº€è¡šã®åšåã§ãã
ãã ããã¿ãã§ã¯ãããŸãã
çŽäº€è¡šã§è©Šè¡ãæžãããšã亀äºäœçšãäž»å¹æãšæ··ãããŸãïŒäº€çµ¡ãšãããŸãïŒã
ã€ãŸãããAã®å¹æããšããŠåºãŠããæ°åããå®ã¯ãBãšCã®äº€äºäœçšãã ã£ãââãšããããšãèµ·ããããŸãã
äžã®äŸã®ããã«äº€äºäœçšãäž»å¹æãã倧ããå·¥çšã§ã¯ãããã¯èŽåœçã§ãã
çŸå ŽãšããŠã®äœ¿ãåã
ç§ã®å®æã§ã¯ããã®åºæºã§ååã§ãã
| å åã®æ° | ããæ¹ |
|---|---|
| 3ã€ãŸã§ | å
šçµåãïŒ8åïŒãããã亀äºäœçšãŸã§åããããã¡ã°ãå®å
š |
| 4ã7〠| L8ã§åœãããã€ãããå¹ããå åã ãçµã£ãŠåå®éš |
| 8ã€ä»¥äž | ãŸãå åãæžããïŒçŸå Žã®ç¥èŠã§åè£ãçµãïŒ |
8åã®å®éšãåãããªããè¿·ããå šçµåãã«ããŠãã ããã 衚ãäœãæéããè§£éã®é£ããããçŽäº€è¡šããå§åçã«æ¥œã§ãã
å®éšã®äœæ³ââãããå€ããšå šéšã ãã«ãªã
èšç»ã®äžèº«ãããå®éšã®ããæ¹ã§ã€ãŸããããšã®ã»ããå€ãã§ãã4ã€ã ãæããŸãã
â å®éšã®é çªãã©ã³ãã ã«ãã
衚ã®äžããé ã«No.1âNo.8ãšãã£ãŠã¯ãããŸããã
å·¥å ·ã¯å®éšäžã«æ©èããŸãã宀枩ãå€ãããŸããååãšååŸã§äœæ¥è ã®èª¿åãéããé çªã©ããã«ãããšãããããæéçãªå€åããæ¡ä»¶ã®å¹æãã«åããŸãã
ãµã€ã³ãã§ãExcelã®RAND颿°ã§ãããã®ã§ãé çªãã·ã£ããã«ããŠãã ããã
=RAND() ã§ä¹±æ°ãåºããŠããã®åã§äžŠã¹æ¿ããããã ãã§é²ããŸãã
â¡ ã§ããã°2åãã€ç¹°ãè¿ã
1æ¡ä»¶1åã ãšããã®å·¥çšã®èª€å·®ãã©ããããããåãããŸãããã0.1ã®å·®ããæå³ã®ããå·®ãªã®ãããã ã®ã°ãã€ããªã®ã倿ã§ããŸããã
8åã16åã«ãªããŸããã倿ã®ç¢ºããããããŸã£ããéããŸãã
ç¹°ãè¿ããªãå Žåã¯ããããŠçŸç¶æ¡ä»¶ã ã3åæž¬ã£ãŠãã ãããããã誀差ã®ç®å®ã«ãªããŸãã
⢠氎æºã®å¹ ãçãããããªã
ãé床120ãš125ã§æ¯ã¹ããââããã§ã¯å·®ã誀差ã«åãããŸãã
çŸå Žã§å®éã«äœ¿ãç¯å²ã®ã䞡端ã«è¿ããšãããåã£ãŠãã ããããã ããæããã«äžè¯ã«ãªãé åã¯é¿ããŸãã
â£ ç¹æ§å€ã¯ã枬ãããã®ããéžã¶
ãè¯ãæããããªããããã§ã¯èšç»ã«ãªããŸãããRaã寞æ³ãæéãäžè¯æ°ãªã©ãæ°åã§æž¬ãããã®ã«ããŠãã ããã
Excelã§ã®ããæ¹
ç¹å¥ãªãœããã¯èŠããŸããã
衚ãäœã
Aã»Bã»Cã®æ°Žæºãã1ãã2ãã§æžãã8è¡ã®è¡šãäœããŸãã
| No | A | B | C | Ra |
|---|---|---|---|---|
| 1 | 1 | 1 | 1 | |
| 2 | 1 | 1 | 2 | |
| ⊠| | | | |
èŠåæ§ãããã®ã§ãã³ããŒã§äžç¬ã§ãïŒCã¯1,2,1,2âŠïŒBã¯1,1,2,2âŠïŒAã¯1ã4ã€ã2ã4ã€ïŒã
äž»å¹æãåºã
=AVERAGEIF(Aå, 2, Raå) - AVERAGEIF(Aå, 1, Raå)ããã§ A ã®äž»å¹æãåºãŸããBã»Cãåãã§ãã
亀äºäœçšãåºã
AÃC ãªããAãšCã®äž¡æ¹ã§çµã蟌ã¿ãŸãã
Aã1ã®ãšãã®Cã®å¹æïŒ
=AVERAGEIFS(Raå, Aå, 1, Cå, 2) - AVERAGEIFS(Raå, Aå, 1, Cå, 1)
Aã2ã®ãšãã®Cã®å¹æïŒ
=AVERAGEIFS(Raå, Aå, 2, Cå, 2) - AVERAGEIFS(Raå, Aå, 2, Cå, 1)**ãã®2ã€ã®æ°åã倧ããéãã°ã亀äºäœçšããããŸãã**笊å·ãéãªãããªãããã§ãã
ã°ã©ãã«ãã
暪軞ã«ãå·¥å ·ïŒæ¢åïŒæ°åïŒãã瞊軞ã«Raãåããäœéã®ç·ãšé«éã®ç·ã2æ¬åŒããŸãã
**2æ¬ã®ç·ã亀差ããŠãããã亀äºäœçšããããŸãã**å¹³è¡ãªãããããŸããããã®1æããå®éšèšç»æ³ã§ãã¡ã°ãåãããããå³ã§ãã
广ã誀差ãã倧ãããã確ãããããªã
ç¹°ãè¿ãå®éšããããªãã**忣åæïŒANOVAïŒ**ã§ããã®å¹æã¯å¶ç¶ã§ã¯ãªããããå€å®ã§ããŸãïŒâã忣åæïŒANOVAïŒå ¥éââ3ã€ä»¥äžã®æ¡ä»¶ãæ¯ã¹ããïŒã
Excelã®ãããŒã¿åæãã¢ãã€ã³ã«**ã忣åæïŒç¹°ãè¿ãã®ããäºå é 眮ã**ãããã亀äºäœçšã®æç¡ãŸã§å€å®ããŠãããŸãã
泚æç¹
â å®éšããç¯å²ã®å€ã¯åãããªã
é床120ãš180ã§å®éšãããªããèšããã®ã¯ãã®ç¯å²ã ãã§ããã240ãªããã£ãšè¯ãããšã¯èšããŸããã倿¿ã¯å±éºã§ãã
â¡ æé©æ¡ä»¶ã¯å¿ ãåçŸç¢ºèªãã
èšç®ã§åºãæé©æ¡ä»¶ïŒä»åã¯No.6ïŒã¯ã**ããäžåºŠãè€æ°åã§å®éã«äœã£ãŠç¢ºãããŠãã ããã**ããŸããŸè¯ãã£ãã ãããšããããšããããŸãã
⢠è¯ãæ¡ä»¶ãã端ãã«åºããããŸã å ããã
æé©ãæ°Žæºã®ç«¯ïŒä»åãªãé«é180ïŒã«æ¥ãå Žåã**ãã®å ã«ãã£ãšè¯ãé åããããããããŸããã**ç¯å²ãããããŠ2åç®ã®å®éšãæ€èšããŠãã ããã
⣠å質ã ãã§æ±ºããªã
Ra 1.02ãæé©ã§ããå·¥å ·å¯¿åœã»ã³ã¹ãã»ãµã€ã¯ã«ã¿ã€ã ãæªåããŠãããããããŸãããç¹æ§å€ã¯è€æ°èŠãŠãã ãããä»åãªããé«é180ã§å·¥å ·å¯¿åœãã©ããªãããã®ç¢ºèªã¯å¿ é ã§ãã
†枬å®ã®ã°ãã€ããå ã«ç¢ºèªãã
æ¡ä»¶ã®å·®ã ãšæã£ãŠãããã®ããæž¬å®åšã®ã°ãã€ãã ã£ãââããã¯å®éã«èµ·ãããŸãïŒâãæž¬å®ã·ã¹ãã åæïŒGR&RïŒå ¥éãïŒã
ãŸãšã
äžå åãã€å€ããïŒOFATïŒã¯ãæ¡ä»¶åºãã§æã倱æããããããæ¹
å®äŸã§ã¯ã3ã€ãšãåç¬ã§ã¯æªå â ãçŸç¶ãæé©ããšèª€çµè«ã
å®éã¯çµåãã§29.7%æ¹åã§ããåå ã¯äº€äºäœçšïŒããæ¡ä»¶ã®å¹ãæ¹ããå¥ã®æ¡ä»¶ã§å€ããïŒã
å®äŸã§ã¯äº€äºäœçšãäž»å¹æãã倧ããã£ãå®éšèšç»æ³ïŒçµåããããããã衚ã«ããŠãèšç»çã«æ¯ã
äž»å¹æã亀äºäœçšããå¹³åã®åŒãç®ã ãã§åºãã
å åãå€ããšãã¯çŽäº€è¡šïŒ7å åã8åã§èª¿ã¹ãããïŒã
ãã ã亀äºäœçšãäž»å¹æãšæ··ããïŒäº€çµ¡ïŒå å3ã€ãŸã§ãªããå šçµåã8åãæãå®å šã§æ¥œ
å®éšã®äœæ³ïŒé çªãã©ã³ãã ã«ïŒã§ããã°2åç¹°ãè¿ãïŒ
æ°Žæºã®å¹ ãçãããããªãïŒæž¬ããç¹æ§å€ãéžã¶æé©æ¡ä»¶ã¯å¿ ãåçŸç¢ºèªãå®éšç¯å²ã®å€ã¯åãããªã
å質ã ãã§æ±ºããªãïŒå·¥å ·å¯¿åœã»ã³ã¹ãã»ã¿ã¯ããèŠãïŒ
ããããã詊ãããã©ãçŸç¶ããã¡ã°ãè¯ãã£ãã§ããââãã®å ±åã®è£ã«ã29.7%ã®æ¹åãç ã£ãŠãããããããŸããã
8åã®å®éšã§ç¢ºããããããªãããã£ãŠã¿ã䟡å€ã¯ãããŸãã
ð æ¡ä»¶åºãã»å·¥çšç®¡çã«äœ¿ããExcelãã³ãã¬ãŒã
å·¥çšããŒã¿ã®ãŸãšããå質管çã«äœ¿ãããã³ãã¬ãŒããBOOTHã§çšæããŠããŸãã
â¶ QC7ã€éå
·ãã³ãã¬ãŒãïŒãã¹ãã°ã©ã ã»ç®¡çå³ã»ãïŒÂ¥900
https://booth.pm/ja/items/8265320
â¶ å質管çãã³ãã¬ãŒãéãäžè¯åæã»å€åç¹ã»8D察å¿ãÂ¥1,200
https://booth.pm/ja/items/8344840
â¶ å質管ç3ç¹ã»ãããQC7ã€éå
·ïŒãªããªãåæïŒFMEAãÂ¥2,000
https://booth.pm/ja/items/8266319
ããããŠèªã¿ãã
âŒ åæ£åæïŒANOVAïŒå ¥éââ3ã€ä»¥äžã®æ¡ä»¶ãæ¯ã¹ã
âŒ æšæºåå·®ãš3Ïãšã¯ïŒçç£æè¡ãæ€æ»æ©ã®éŸå€ãèšå®ããæé
⌠工çšèœåææ°ïŒCpã»CpkïŒã®èšç®ãšå€æåºæºââ1.33ã¯ãªãåæ Œã©ã€ã³ã
Cpã»CpkãçŸå ŽããŒã¿ã§äœ¿ãããªãæ¹æ³ãæžããŸããïŒææïŒ
æ¡ä»¶åºãã§è¯ãçµæãåºãããæ¬¡ã¯ããããå·¥çšãšããŠå®å®ããŠããããã瀺ãçªã§ããå®ããŒã¿ã䜿ã£ãExcelã®èšç®æé ãããå ±åæžã®æäŸããããã質åãžã®çãæ¹ãŸã§ããŸãšããå®å šçãå ¬éããŠããŸãã
âŒãå®è·µå®å šçãæšæºåå·®ã»Cpã»CpkãçŸå ŽããŒã¿ã§äœ¿ãããªãââExcelæé ããäžåžãžã®å ±åæžãŸã§ïŒÂ¥300ïŒ
æ¬ã«ããŸããïŒKindleïŒ
補é çŸå Žã§äœ¿ãçµ±èšããé çªã«åŠã¹ã1åã«ãŸãšããŸããããã³å€åŸ30åã®å®æž¬ããŒã¿ãæåããæåŸãŸã§è¿œããããæ§æã§ãå¹³åã»ã°ãã€ãã»ãã¹ãã°ã©ã ã»å·¥çšèœåã»ç®¡çå³ã»ãµã³ããªã³ã°ãŸã§ãéãã§è§£èª¬ããŠããŸããåç« æ«ã«å®è·µæŒç¿ãå·»æ«ã«Excel颿°æ©èŠè¡šãšçšèªéã€ãã
⌠çŸå Žã§äœ¿ãçµ±èšå
¥éââ補é çŸå Žã®æ°åã«åŒ·ããªã8ã€ã®ã¹ããã
https://www.amazon.co.jp/dp/B0HCWJLMDT
â» Kindle Unlimited ããå©çšã®æ¹ã¯è¿œå æéãªãã§èªããŸãã
ð¬ èšäºã®å 容ã§è³ªåã»çåãããã°ãã³ã¡ã³ãæ¬ãžã©ãããããããã ã質åã¯ãèšäºã«ããŠè©³ãããçãããŠããŸãã