计算表单软件仿真静定梁内力图的应用
|
摘要
利用计算表单软件强大的公式输入和函数库等数值计算功能以及快速数据批处理、可视化交互和计算分析功能,可解决静定梁内力图绘制过程中遇到的大量计算和图形绘制问题,其方法具有节约时间、计算准确等特点,对科研、教学、工程有重要的参考价值。文章阐述了静定梁内力图的计算和绘制方法,提出了使用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.
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.
引文
[1]赵全斌,冯敏杰.回弹法检测混凝土抗压强度的Excel方法[J].工程建设与设计,2006(11):22-24.
[2]谭晓慧,王建国.土钉支护结构可靠度分析的电子表格法[J].岩土力学,2009,30(11):3447-3452.
[3]王德成.电子表格在城市工程测量上的应用[J].测绘通报,2010(2):45-46,73.
[4]赵全斌,谢剑,赵彤.Excel计算表单在建筑工程中的应用[J].工程力学,2004,21(S):368-373.
[5]黄明,侯晓江.利用Excel软件进行排水管道水力计算[J].山东建筑工程学院学报,2005,20(3):52-55.
[6]赵全斌,李洪江.结构地震反应数值计算的Excel方法[J].工程建设与设计,2008(5):27-29.
[7]Gottfried B S.Spreadsheet tools for engineers using Excel[M].New York:McGraw-Hill Companies,Inc,2003.
[2]谭晓慧,王建国.土钉支护结构可靠度分析的电子表格法[J].岩土力学,2009,30(11):3447-3452.
[3]王德成.电子表格在城市工程测量上的应用[J].测绘通报,2010(2):45-46,73.
[4]赵全斌,谢剑,赵彤.Excel计算表单在建筑工程中的应用[J].工程力学,2004,21(S):368-373.
[5]黄明,侯晓江.利用Excel软件进行排水管道水力计算[J].山东建筑工程学院学报,2005,20(3):52-55.
[6]赵全斌,李洪江.结构地震反应数值计算的Excel方法[J].工程建设与设计,2008(5):27-29.
[7]Gottfried B S.Spreadsheet tools for engineers using Excel[M].New York:McGraw-Hill Companies,Inc,2003.
版权所有：© 2023 中国地质图书馆 中国地质调查局地学文献中心