当前位置：首页 > 过刊浏览->2022年43卷第9期
基于 VBA 的铸造凝固模拟
Casting Solidification Simulation Program Based on VBA
浏览(3321) 下载(8)
- DOI:
- 作者:
- 冯晏锋，张守银
FENG Yanfeng, ZHANG Shouyin
- 作者单位:
- 南昌航空大学 航空制造工程学院，江西 南昌 330063
School of Aeronautical Manufacturing Engineering, Nanchang Hangkong University, Nanchang 330063, China
- 关键词:
- VBA；Microsoft Excel；铸造；凝固；模拟；二维稳态导热
Visual basic for applications; Microsoft Excel; casting; solidification; simulation; Two-dimensional steady-state heat conduction
- 摘要:
- 针对不规则物体中热量传输问题，采用分析解法的局限性较大，对复杂问题无法求解。 本文研究了基于
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.