船舶生产设计物量自动统计程序开发及应用  

Development and Application of Automatic Statistical Program for Ship Production Design Amount

作　　者：李辉 刘亚 陈政 张润涛 LI Hui;LIU Ya;CHEN Zheng;ZHANG Runtao(CSSC Huangpu Wenchong Shipbuilding Co.,Ltd.,Guangzhou 511462)

机构地区：[1]中船黄埔文冲船舶有限公司,广州511462

出　　处：《广东造船》2023年第5期112-114,共3页Guangdong shipbuilding

摘　　要：分析了船舶设计过程中各专业生产设计物量统计工作的内容及要求,针对统计工作项目较多、分类较细、表格数量庞大、手动处理表格操作繁琐易出错等问题,开发了基于Excel软件的生产设计物量自动统计程序。实现了生产设计托盘表读取、各专业生产设计物量自动分类计算及汇总、生产设计物量报表自动生成等工作的自动化,有效地减少了设计工作量,提高了工作效率,实现了生产设计物量数据统计信息化管理。This paper analyzes the content and requirements of production design amount statistics for various specialties in the process of ship design.A production design amount automatic statistics program based on Excel software has been developed to address the issues of numerous statistical work projects,detailed classification,large number of tables,and cumbersome and error prone manual processing of tables.The automation of production design tray table reading,automatic classification calculation and summary of production design quantities for various specialties,and automatic generation of production design quantity reports has been achieved,which effectively reduces the design workload,improves the work efficiency,and achieves the information management of production design amount data statistics.

关 键 词：生产设计物量 数据统计 VBA程序设计 

分 类 号：U662.9[交通运输工程—船舶及航道工程]