基于Excel/Minitab的大规模定制开放式交互质量控制系统设计  

Design of Open Interactive Quality Control System for Mass Customization Based on Excel/Minitab

作　　者：权政 赵玲玲 徐滨 樊树海[1,2] QUAN Zheng;ZHAO Lingling;XU Bin;FAN Shuhai(Department of Industrial Engineering,Nanjing Tech University,Nanjing Jiangsu 210009,China;MIT Quality Information Program“Data Quality&Info Security”Lab,Cambridge,MA,USA)

机构地区：[1]南京工业大学工业工程系,江苏南京210009 [2]MIT Quality Information Program“Data Quality&Info Security”Lab,Cambridge,MA,USA

出　　处：《机床与液压》2022年第14期71-75,共5页Machine Tool & Hydraulics

基　　金：国家自然科学基金面上项目(71671089,71171110);江苏省研究生科研与实践创新计划项目(SJCX21_0416,SJCX21_0417)。

摘　　要：大规模定制生产的质量控制体系建立在全面质量管理基础上,针对制造型企业采用大规模定制生产模式的特点,为提高质量控制系统的效率,提出改进型AEWMAQ控制图。使用TURNSIM仿真系统模拟相关数据,通过VBA创建用户自定义动态数据交换对Excel/Minitab交互系统进行二次开发,实现数据实时共享。通过实验验证了此交互系统的可行性,且AEWMAQ控制图较传统控制图具有更高的灵敏性和预测能力。将该系统运用于大规模定制生产的过程质量控制中,提升了质量监控的便捷性,同时降低了企业的生产成本。The quality control system of mass customization(MC)is based on the total quality management.Aiming at the characteristics of the MC production mode of manufacturing enterprises,an improved AEWMAQ control diagram was proposed to improve the efficiency of the quality control system.The TURNSIM simulation system was used to simulate relevant data,and the Excel/Minitab interactive system was secondarily developed through the user-defined dynamic data exchange(DDE)created by VBA to realize,real-time data sharing.The feasibility of the interaction system is verified by experiments,and the AEWMAQ control diagram has a higher sensitivity and predictive power than the traditional control diagram.The system is applied to the process quality control of MC production,which improves the convenience of quality control and reduces the production cost of enterprises.

关 键 词：大规模定制 交互质量控制 AEWMAQ控制图 二次开发 

分 类 号：TH165.4[机械工程—机械制造及自动化]