多种方法结合的扭矩系统数据自动处理研究

Research on Automatic Data Processing of Torque System Based on Multiple Methods

面对车间投入的无线扭矩系统存在项目工程师前期数据准备时间长等问题,先通过对数据准备工作的拆解,明确需要解决问题是从“项目标准物料清单”到“工具正确调用拧紧程序”中的3个工时投入长的点并进行流程和数据标准化梳理,同时结合Python、VBA等编程工具和方法将这部分工作自动化。经过多个项目的实际运行,结果表明数据前处理的效率上提升了76%,利用数字化的方法对试制拧紧系统向智能化起到了进一步的推动作用。

For the problems of long data preparation time of project engineers in the wireless torque system, this paper first disassembles the data preparation work and clarifies that the issues to be solved are 3 points with long manhour investment from the“project standards bill of materials”to“tool correctly invoke the tightening program”and standardize the data, and at the same time combine Python, VBA and other programming tools and methods to automate this part of the work. After the actual operation of several projects, the results show that the efficiency of data preprocessing has been improved by 76%, and the use of digital methods has promoted the trial production tightening system to play a further role in promoting intelligence.