基于Excel平台的车门气压阻效应计算软件的开发研究

通过对汽车车门气压阻效应的理论分析,提出一种新的数学模型.基于Excel平台、利用VBA语言、使用数值积分方法,开发出一种用于计算车门关门能量/力中气压阻效应的应用软件.该软件不仅具有可视化的人机交互界面,而且能够方便快捷的根据需要计算出气压阻效应在关门过程中消耗的能量/力.与试验数据比较误差不超过10%,从而证明了该软件的计算准确性.

Development for Calculation Software of Door Air Bound Effect Based on Excel

A new mathematical model is proposed in this paper based on the theory analysis of door bound effect,Based on Excel,the application software that is used to calculate air bound effect in door closing energy/force is developed by using language VBA and numerical value integral method.The software not only has the visual man-machine interface,but also can be used to calculate air bound effect during door closing process conveniently.Compared with the experimental data,errors are less than 10 %,so the calculat...