Excel SPC(Statistical Process Control) [²Îpµ{§Ç±±¨î]³nÅé
QI Macros SPC for Excel³nÅé¥i¥H¥Í¦¨±Æ¦C¹Ï(pareto charts)¡A±±¨î¹Ï¡Aª½¤è¹Ï¡A½c½u¹Ï¡A´²ÂI¹Ïµ¥¡C¥t¥~ÁÙ¥]§t¶W¹L80Ó¥i¶ñ¥RªÅ¥Õ½d¥»¡A¥]¬AQFD,GageR&R, DOE, PPAP ©M FMEA.¡C§ó«nªº¬O¡A§Ú̬O¦bExcel¤¤§¹¦¨¥¦¡C±z¥u»Ýn¿ï¾Ü±zªº¸ê®Æ¡AµM«á±qQI Macros¥\¯àªí¤¤¿ï¾Ü¹Ïªí¡C
QI Macros«D±`®e©ö¨Ï¥Î * ¦]¬°³nÅé¬O¦bExcel¤¤¤u§@ªº¡A¥u»Ýn²³æªº¿ï¾Ü¥\¯àªí´N¥i¥H§Ö³t¶Ç»¼µ²ªG¡C - ¸ê®Æ¿ï¾Ü¨¾§b-±zªº¸ê®Æ¥i¯à¬O³s°_¨Óªº©Î³æ¿Wªº¡A¦æ©Î¦C¡CQI Macros±N²M- °£±¼«D¼Æȸê®Æ¡A×¥¿¥ô·Nªº¿ù»~±Æ¦C¡A©M±z¿ï¾Ü®É¤@¼Ë¨Ó¨Ï¥Î±zªº¸ê®Æ¡C - ±±¨î¹ÏÂQ¾É-¬°±z¦Û°Ê¿ï¾Ü¥¿½Tªº±±¨î¹Ï - ±±¨î¹Ï»ö¿ö½L-²¤Æ¾\Ū³ø§i - ¼Ï¯Ã¤ÀªRªíÂQ¾É-²¤Æ¤ÀªR½ÆÂøªº³B²zÀÉ - ²Îp¤ÀªR¨¾§b(Excel¥i¯à¬O¬D窺¡A¦pªG¸ê®Æ¨S¦³¨Ï¥Î¥¿½T¥i¯à·|²£¥ÍµL®Äªºµ²ªG) * ¦]¬°QI Macros¬°±z°µ¤F©Ò¦³ªº¼Æ¾Ç©M²Îp¤ÀªR¡C³oùبS¦³½ÆÂøªº¤½¦¡»Ýn¥h»â·|©ÎÀ³¥Î¡A¥u¦³¹Ïªí©Mµ²ªG¡C * ¦]¬°¦³¥i¶ñ¥RªºªÅ¥ÕªºÂ²³æ©öÀ´ªº80¥H¤Wªº¹Ïªí©M¤åÀɽd¥» * ¦]¬°±z¤£»Ýnªá®É¶¡¥hÂà´«©Î±qExcel¶Ç°e±zªº¸ê®Æ¨ì¨ä¥L³æ¿Wªº®M¸Ëµ{¦¡¡CQI Macros¤u§@¦bExcel¤¤¡C
¥¦ºë½T¶Ü¡H QI Macros¨Ï¥Î¤U¦C¤èªkÅçÃÒ¹L 1. ³q¹L¤â¤upºâÅçÃÒ 2. ©M±Ð¬ì®Ñ¤¤ªº¥Ü¨Ò¹ï·ÓÅçÃÒ 3. ©M¨ä¥LSPC³nÅé¹ï·ÓÅçÃÒ
½Ö¥¿¦b¨Ï¥Î¥¦¡H QI Macros³Ð«Ø©ó1996¦~¡C°ò©ó«È¤áªº¿é¤J¡A§Ṳ́@ª½¦b¼W¥[·sªº¥\¯à¡C¥þ¥@¬É§Ú̦³¶W¹L9¸UӫȤá¡C * ¶W¹L2500®aÂå°|¦b¨Ï¥ÎQI Macros¨Ó´î¤ÖÂåÀø¿ù»~©M±Ï¦º§ß¶Ë * ¦¨¤dªº¨î³y«¬¤½¥q¨Ï¥ÎQI Macros¨Ó´ú¶q¡AºÊµø©M¨¾§b«OÅ@¥Í²£¡C * ¹«~¤½¥q¨Ï¥ÎQI Macros¨ÓºÊµø¥L̥Ͳ£ªº«~½è©M¦w¥þ©Ê * ¯èªÅ¥ø·~¨Ï¥ÎQI Macros * x¶¤¨Ï¥ÎQI Macros * Âå°|¨Ï¥ÎQI Macros¨Ó§ïµ½«È¤áÅéÅç
¤U¸ü¸Õ¥Î
õ·Q¤è®×¦³¤½¥q (Cogito Solutions Ltd) www.cogitosolutions.com
§ó¸Ô²Ó¸ê®Æ»P»Ý¨D½Ð¬¢¸ß ¹q¤l«H½c¡Gsalestw@cogitosolutions.com ¹q¸Ü¡G(02) 2722-3381
|