摘要
仪表专业的仪表数据表设计工作大多采用键盘输入或复制粘贴的传统方式填写工艺数据,该方式存在设计用时偏长、错误率偏高的问题,为此,本文采用Excel VBA开发了一系列能自动生成仪表数据表和索引页的应用程序,解决了在设计过程中仪表条件输入与修改工作量较大的问题,缩短了设计时间。
Most of the design work of instrument professional instrument data sheet adopts the traditional way of keyboard input or copy and paste to fillin the process data,which has the phenomenon of long design time and high error rate.Aiming at this traditional method,this paper introduces the use of Excel VBA to develop a series of application programs to automatically generate instrument data table and index pages,which can solve the problem of heavy workload of instrument condition input and modification in the design process and shorten the design time.
作者
田忠
张金亮
薄涛
TIAN Zhong;ZHANG Jinliang;BO Tao(Shandong Tianli Technology Engineering Co.,Ltd.,Jinan,Shandong 250000,China)
出处
《自动化应用》
2023年第11期187-189,192,共4页
Automation Application
关键词
仪表设计
仪表数据表
VBA
仪表索引
instrument design
instrument data sheet
VBA
instrument index
