基于Microsoft Excel的刚架弯矩分配计算

The Frame Construction Calculation Based on Microsoft Excel

为解决课程设计过程中时间紧、工作量大的矛盾,论文将Excel 规划的求解功能移植到框架结构计算中以替代烦琐的弯矩分配计算,使结构专业的学生和工程技术人员在缺少专用程序的情况下也可以轻松地完成框架分析.

For solving the contradiction between tight time and large amount of work in the process of the course design, in this paper, the functions of the programming and seeking answers of Excel procedure are transplanted into the frame construction calculation as a substitute for trivial moment distribution calculation, which enable students majoring in construction and personnel engaged in engineering and technology to complete frame analyses with ease under circumstance of lack of special programs.