Casting Solidification Simulation Program Based on VBA

Author of the article:FENG Yanfeng, ZHANG Shouyin

Author's Workplace：School of Aeronautical Manufacturing Engineering, Nanchang Hangkong University, Nanchang 330063, China

Key Words：Visual basic for applications; Microsoft Excel; casting; solidification; simulation; Two-dimensional steady-state heat conduction

Abstract：For solving the problem of heat transfer in irregular objects, the analytical solution has great limitations and cannot be solved for complex problems. The implementation process of VBA-based solidification simulation of casting was studied in this paper. A section of the casting was divided into a finite number of meshes. The heat transfer among the internal meshes, the boundary meshes and the environment was studied. The algebraic equations of the grid physical quantities were established. Microsoft Excel was utilized to realize the iterative calculation of heat transfer based on VBA. The results show that the temperature field and solid fraction during the solidification process can be obtained. Combined with the chart function of Microsoft Excel. it can be used to simulate the casting of any simple casting section and predict possible defects such as shrinkage, porosity, etc.