| 基于Excel与AutoCAD仪表安装材料的自动统计 |
| |
| 引用本文： | 张小广,王秋红.基于Excel与AutoCAD仪表安装材料的自动统计[J].石油化工自动化,2011,47(6):65-67. |
| |
| 作者姓名： | 张小广 王秋红 |
| |
| 作者单位： | 中石油东北炼化工程有限公司吉林设计院,吉林吉林,132002 |
| |
| 摘 要： | 针对手动统计仪表安装材料费时、费力、容易出错的问题,提出一种基于Excel和AutoCAD软件的自动统计仪表安装材料方法。主要利用AutoCAD表格功能,从AutoCAD图纸提取材料表格数据到Excel文件中,然后使用VBA编程进行材料的类型识别和数量统计,从而快速准确地生成仪表安装材料表,提高了仪表工程设计效率与设计质量。
|
| 关 键 词： | 仪表安装材料 宏函数 自动统计 |
Automatic Statistic of Instrument Installation Material Based on Excel and AutoCAD Software |
| |
| Zhang Xiaoguang,Wang Qiuhong.Automatic Statistic of Instrument Installation Material Based on Excel and AutoCAD Software[J].Automation in Petro-chemical Industry,2011,47(6):65-67. |
| |
| Authors: | Zhang Xiaoguang Wang Qiuhong |
| |
| Affiliation: | (Petrochina Refining-Chemical Northeast Eng.Co.Ltd. Jilin Design Institution,Jilin,132002,China) |
| |
| Abstract: | 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 |
| |
| Keywords: | instrument installation material macro function automatic statistic |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
