基于Excel与AutoCAD仪表安装材料的自动统计  

Automatic Statistic of Instrument Installation Material Based on Excel and AutoCAD Software

作　　者：张小广 王秋红 

机构地区：[1]中石油东北炼化工程有限公司吉林设计院,吉林吉林132002

出　　处：《石油化工自动化》2011年第6期65-67,共3页Automation in Petro-chemical Industry

摘　　要：针对手动统计仪表安装材料费时、费力、容易出错的问题,提出一种基于Excel和AutoCAD软件的自动统计仪表安装材料方法。主要利用AutoCAD表格功能,从AutoCAD图纸提取材料表格数据到Excel文件中,然后使用VBA编程进行材料的类型识别和数量统计,从而快速准确地生成仪表安装材料表,提高了仪表工程设计效率与设计质量。omissions Aiming at the problem of time-consuming, laborious and easy occurrence of errors and during manual statistic for instrument installation material, one automatic statistic method of instrument installation material based on Excel and AutoCAD software is proposed. The method mainly adopts AutoCAD table function to extract material sheet data from AutoCAD drawing into Excel sheet. Type identification and quantity statistic of material are accomplished by VBA program to fast generating precise sheets of instrument installation material, efficiency and quality. which improves instrument engineering design

关 键 词：仪表安装材料 宏函数 自动统计 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] TP391.72[自动化与计算机技术—计算机科学与技术]