计算表单软件仿真静定梁内力图的应用

Application of spreadsheet to simulate the internal force diagram of statically determinate beam

利用计算表单软件强大的公式输入和函数库等数值计算功能以及快速数据批处理、可视化交互和计算分析功能,可解决静定梁内力图绘制过程中遇到的大量计算和图形绘制问题,其方法具有节约时间、计算准确等特点,对科研、教学、工程有重要的参考价值。文章阐述了静定梁内力图的计算和绘制方法,提出了使用Excel计算表单的解决方案,利用计算表单软件Excel的计算批处理、函数库、图表等功能与技术对某一商场改造工程上的力学计算问题进行了应用分析,分析过程简单快捷有效,值得工程上推广应用。

The use of spreadsheet,such as function library and formula batch processing and rapid data processing,visual interacting and computation and analysis function,can help solve a large number of calculation and picture drawing problems in protracting the internal force diagram of statically determinate beam and boast the advantages of accurate and time-saving,thus being of great referential importance to scientific reach,teaching and engineering.The paper describes the calculation and drawing method of the internal force diagram of statically determinate beam and.proposes the solution by using spreadsheet of Excel.Appling the function of batch processing,function library,graphics and others,spreadsheet is successfully used to the mechanics calculation in the improvement project,of a shopping centre,which proves to be simple,efficient and effective in the analysis process,and should be applied widely in engineering.