基于VBA的EXCEL智能岸罐计重通用表单的设计与应用

Design and Application of EXCEL Intelligent Shore Tank Weighing General Form Based on VBA

本文介绍了基于VBA(Visual Basic for Applications)的EXCEL智能岸罐计算通用表单的设计与应用,通过VBA代码编写与组合,实现了罐容量、理化参数的自动查找计算,集成了3种岸罐计重方法,使得一张表单同时满足动植物油脂、液体化工品、石油产品的计算需求。只需正确填写货物名称、岸罐编号、液位高度、温度、密度等测量数据,即可快速得到重量数值,节约了大量人工查表计算时间,降低了计算误差,并有效避免人为计算错误。VBA代码易于维护和修正,并可为开发Web版和App版提供技术思路。

This paper introduces the design and application of the EXCEL intelligent shore tank calculation general form based on VBA(Visual Basic for Applications).Through the compilation and combination of VBA code,the automatic search and calculation of tank capacity and physical and chemical parameters are realized,and three shore tank meters are integrated.The heavy method makes one sheet meet the calculation needs of animal and vegetable oils,liquid chemicals,and petroleum products at the same time.It only needs to fill in the measurement data of the cargo name,shore tank number,liquid level height,temperature,density,and so on,the weight value can be obtained quickly,saving a lot of manual table look-up calculation time,reducing calculation errors,and effectively avoiding human calculation errors.VBA code is easy to maintain and modify,and can provide technical ideas for the development of Web version and App version.