The software development for calculating the closing energy of automotive side swing door based on Microsoft excel

Yingjun Li,Gangan Ma,Yunkai Gao,Shanshan Wang
DOI: https://doi.org/10.1504/ijvp.2018.10009702
2018-01-01
International Journal of Vehicle Performance
Abstract:The energy consumption of the door closing process was decomposed into six subsystems, which include door weight, hinge, check­link, latch, weather strip seal and air­binding effect. The working principle of each subsystem was analysed and then the mathematical model of each subsystem in the door closing process was established, respectively. The energy consumption of the door was calculated programmatically via an Excel­based software using VBA programming language. The energy consumption of different subsystems of a production vehicle door was measured to verify the accuracy of the calculation software developed. The proposed research provided not only the theoretical basis for the future door closing energy research, but also an interactive method and system, and improved the efficiency of vehicle door design effectively.
What problem does this paper attempt to address?