EXCEL在边坡稳定性分析中的应用
摘要:利用Excel强大的数据处理、便捷的公式函数和所支持的面向对象化的程序设计语言VBA,应用于土坡的稳定性分析。基本方法为:先采用传统的瑞典条分法对边坡进行计算分析,在求得最危险滑动面的基础上,通过简化Bishop法对边坡安全系数F_S进行改进。在此过程中,Excel加载VBA子程序可以方便地得到极限平衡条分法中的各未知量,并计算出最危险滑动面上的安全系数F_S,同时使用其可视化功能绘出最危险滑动面的位置。此方法简化了计算程序,不仅容易在Excel表格中实现,且计算对比表明本文方法计算结果与简化Bishop法计算结果非常接近,可满足工程需要。
Abstract:By exploiting Excel's powerful data-processing and convenient formula for support functions and of object-oriented programming language VBA, it applies to the stability analysis of some slopes. The basic method is that first Swedish slices method which is the traditional method, is used to calculate and analyze this slope, and at the basis of former method obtaining the most dangerous sliding surface, the safety factor Fs will be improved through simplified Bishop method. In this process, the unknown variable of the limit equilibrium method can be easily obtained by Excel add-VBA subroutine, and factor of safety (Fs) of the most dangerous sliding surface is calculated. At the same time,a visualization button is designed to draw the location of the most dangerous sliding line of this slope. This method make the calculation procedure simplify, and it can not only achieve easily in the Excel, but also the results are proved to be very close when the data obtained from this method, is compared with the simplified Bishop method, so it can meet demand for project.
中文标题：
EXCEL在边坡稳定性分析中的应用
The Application of EXCEL in Slope Stability Analysis
作者：
邓东平,李亮,赵炼恒
Deng Dongping,Li Liang,Zhao Lianheng
作者简介:邓东平,1985年生,男,湖南岳阳人,中南大学硕士研究生,主要从事道路与铁道工程方面的研究。
通讯地址：
中南大学土木建筑学院, 湖南长沙 410075
CollegeofCivilandArchitecturalEngineeringsCentralSouthUniversity,Changsha410075,Hunan,China
中图分类号:TU457
doi:10.3969/j.issn.1007-2993.2009.06.009
出版物：岩土工程技术
收稿日期:2009-09-08
关键词:边坡稳定性分析,瑞典条分法,简化BISHOP法,Excel建模,安全系数,滑动线位置
Key words:slope stability analysis,Swedish slice method,simplified Bishop method,Excel model,factor of safety,location of sliding line
文档包含图片数量：图片(0)张
文档包含表格数量：表格(0)个
参考文献：
基金项目：
基金项目: 西部交通建设科技项目(2006318802111)
- 文件大小:
- 295.49 KB
- 下载次数:
- 60
-
高速下载
|
|
