基于Excel的连续梁内力有限元数值迭代计算

FEM Numerical Iterative Computation of Internal Force for Continuous Beam Based on Excel

建立了连续梁的内力计算有限元数值模型,以Excel软件为计算工具,分别用雅克比迭代法、高斯-赛德尔迭代法、超松弛迭代法和共轭梯度法等4种常用方法对模型进行了迭代计算,并对4种迭代计算方法的收敛速度和效率进行了分析和研究,提出了一种基于Excel的快捷有效的有限元数值计算方法.

The FEM computational model of internal force for continuous beam was built up by based on Excel, and the iterative computation was made to the model with difference use of the following four. kind commonly used method, Jacobi method,G- S method, SOR method and CG method, the constringency speed and the efficiency of the four iterative computation method was analyzed and studied, a shortcut effective method for FEM numerical computation based on Excel was put forwarded.