基于VBA的铸造凝固模拟  

Casting Solidification Simulation Program Based on VBA

作　　者：冯晏锋 张守银[1] FENG Yanfeng;ZHANG Shouyin(School of Aeronautical Manufacturing Engineering,Nanchang Hangkong University,Nanchang 330063,China)

机构地区：[1]南昌航空大学航空制造工程学院,江西南昌330063

出　　处：《铸造技术》2022年第9期830-835,共6页Foundry Technology

基　　金：江西省教育厅科技项目(DA201903144);博士启动基金(EA201703481)。

摘　　要：针对不规则物体中热量传输问题,采用分析解法的局限性较大,对复杂问题无法求解。本文研究了基于VBA的铸造凝固模拟实现过程。将铸件的截面划分为有限个网格,通过研究内部网格、边界网格以及环境之间的热量传输,建立网格物理量的代数方程。结果表明,基于Visual Basic宏语言(Visual basic for applications, VBA)使用Microsoft Excel可实现热量传输的迭代计算,并获得了铸件凝固过程中温度场和固相率的变化关系。结合Microsoft Excel的图表功能反映此变化,可用来对任意简单铸件截面进行铸造模拟,预测可能产生的缩松缩孔等缺陷。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.

关 键 词：VBA Microsoft Excel 铸造 凝固 模拟 二维稳态导热 

分 类 号：TG244.3[金属学及工艺—铸造] TM743[电气工程—电力系统及自动化]