机械图明细表智能制作

Intelligent Editing of Mechanical List

三维设计是现代化工程设计的主流,计算机三维实体造型的方法和技巧融入传统机械制图中,形成一种新的设计体系。机械设计需要编制明细表,一套设备的零部件少则数百件、多则上千件,传统人工统计编制明细表的方法耗时耗力,而且容易出错。文中利用Excel VBA编程,实现了机械设计明细表智能化编辑,解决了明细表编制技术含量不高但耗时耗力的问题。

3 D mechanical design is the mainstream of modern engineering design.The methods and skills of computer 3 D solid modeling are integrated into traditional mechanical drawing to form a new design system.Mechanical design requires the preparation of detailed list,and a set of equipment includes hundreds of parts or thousands of parts.The traditional manual statistical method of compiling detailed list is time-consuming and labor-consuming,and error-prone.This paper uses Excel VBA programming to realize the intelligent editing of the mechanical design schedule,and solves the problem of low technical content but time-consuming and labor-intensive preparation of the schedule.