民用飞机规范EBOM的生成方法及工具的研究

飞机行业的工程物料清单(EBOM)是飞机工程设计部门提供给制造、采购等部门作为生产控制及采购的依据,因此EBOM应具备信息全面、格式规范、简单易读等特点.以某民用飞机项目中实际应用的较为规范的EBOM格式为蓝本,以Excel电子表格为应用平台,定制EBOM所需包含的属性信息,利用Excel提供的功能定制一套生成规范的EBOM的方法及工作流程,通过Excel开发平台及VBA语言、函数的运用将EBOM的排版过程进行程序化,实现了规范EBOM的自动生成.

Research on the Tool for making Standard EBOM of Civil Aircraft

EBOM(Engineering Bill of Material) applied in Aircraft field is the deliverable which Design Department of Aircraft Engineering should provide to Procurement, Methods and Project Department as the basis of purchasing and manufacturing controlling. Whether the information is ample or deficient, whether the format is standard or nonstandard, whether it is easy to read or not, they all represent the work quality of Design Department to some extent. Taking the relatively standard EBOM practically applied in one Civil Airplane Project as the original version, and the Excel tables as applying platform, the necessary property information has been customized, and one set of method and workflow has been customized by use of the functions of Excel. The workflow of formatting EBOM has been programmed, which tremendously improved the efficiency and quality of making and updating EBOM.