首页|基于Excel VBA的喷漆线设备规划与提资系统

基于Excel VBA的喷漆线设备规划与提资系统

扫码查看
主要介绍了以Excel为基础通过VBA程序关联AutoCAD和Word的喷漆线设备规划与提资系统,其能达到涂装车间喷漆室、空调、工作区等相关设备计算书、电控提资及公用耗量、流程图、技术参数表的连通,实现"数出一源、多点共享、准确高效"的效果.文中描述了其规划思路、各模块构成和功能,供相关设计人员参考.
Equipment Planning and Funding System for Painting Line Based on Excel VBA
This article introduces a painting line equipment planning and data collection system based on Excel and associated with AutoCAD and Word through VBA programs.It can achieve the connection of equipment calculation sheets,electric control data collection,public consumption,flow charts,and technical parameter tables in painting workshops,such as painting rooms,air conditioners,and work areas,to achieve the effect of"counting one source,multi-point sharing,accuracy and efficiency".The article describes its planning ideas,composition and functions of each module for reference by relevant designers.

Excel VBApainting line equipmententhalpy and humidity chartair supply and exhaust flow chart

王建凯、刘晓亮、马力、刘聪

展开 >

中国汽车工业工程有限公司,天津 300113

Excel VBA 喷漆线设备 焓湿图 送排风流程图

2024

现代涂料与涂装
北方涂料工业研究设计院 全国涂装信息站

现代涂料与涂装

影响因子:0.195
ISSN:1007-9548
年,卷(期):2024.27(3)
  • 3