一种新的图纸明细表管理利用方法研究

New manage method about the blueprint listing

根据设备的结构提出一种新的基于Excel的零部件明细表管理方法,构成设备清单,直观的表达了设备的零部件构成。通过VBA二次开发实现了零件的分类汇总、自动统计计算等功能,方便了备件计划和图纸的查阅,把图纸明细电子化,有利于设备管理。

Thinking up a new manage method for Blueprint List based on Excel according the equipment configuration,and form a parts bill.Developed some function such as classifying,auto calculate and so on through VBA language.It＇s conduce for the plant malntenace.