一种编制焊工胸牌的工具解析研究

Analysis and Research on a Tool for Badge Preparation of Welders

文章所述工具旨在实现焊工胸牌的高效编制过程。在将焊工胸牌中的信息根据其特点及胸牌编制中引用的灵活性进行划分的基础上,编写了信息收录及整合的Excel VBA代码而形成了本胸牌编制工具,实现了可灵活应用于多场景的焊工胸牌的快速编制过程。本工具在焊工胸牌数量巨大的大型钢结构焊接建造项目中可极大地缩短胸牌编制的时间,从而降低人工成本;同时对各类信息的汇总收集,可推动实现焊工信息的数据库模式的管理方式,提高焊工资质的管理质量。

The tool described in this paper aims to achieve an efficient preparation process of welder badges.On the basis of dividing the information in the welder badges according to their characteristics and the flexibility of citation in badge preparation,an Excel VBA code for information collection and integration is developed to form this badge preparation tool,and it realizes the rapid preparation process of welder badges which can be flexibly applied in multiple scenarios.This tool can greatly shorten the time of badge preparation to reduce labor costs in large-scale steel structure welding construction projects with a large number of welder badges.Simultaneously,summarizing and collecting various types of information can promote the implementation of a database management mode for welder information and improve the management quality of welder qualification.