Excel VBA在吊索具自动化设计中的应用  

Application of Excel VBA in Automatic Design of Slings

作　　者：常建衡 李宁 Chang Jianheng;Li Ning(Zhangjiakou General Lifting Engineering Co.,Ltd.,Zhangjiakou 075000)

机构地区：[1]张家口通运吊装工程技术有限公司,张家口075000

出　　处：《中国特种设备安全》2023年第4期81-86,共6页China Special Equipment Safety

摘　　要：本文主要研究了SKIP品牌产品基于Excel VBA语言环境的算法建模和数据引用,通过标准化的变量输入和逻辑条件判断,对吊索具这一工业组合产品设计过程进行程序化重现,可以快速、有效地完成在吊索具标准结构专业化设计、产品选型、长度和负载校核及制图等方面的设计构建工作。快速响应了客户需求技术化描述,提高了技术交流的工业化专业服务效率。This paper mainly studied the algorithm modeling and data references of the SKIP brand product based on Excel VBA language environment.Through standardized variable input and logical condition judgment,the design process of slings,an industrial combination product,can be reproduced by programming,which can quickly and effectively complete the design and construction work in the sling standard structure design,product selection,length and load verifying and drawing design,etc.It can quickly respond to the technical description of customer demand,and improve the efficiency of industrialized professional service of technical exchange.

关 键 词：Excel VBA 吊索具 设计 运算 

分 类 号：X941[环境科学与工程—安全科学]