边坡稳定分析的电子表格法LOSSAP

陈立宏; 孙平; 陈祖煜

边坡稳定分析的电子表格法LOSSAP English Version

(1. 北京交通大学土木建筑工程学院，北京 100044；2. 中国水利水电科学研究院，北京 100048)

详细信息

作者简介:
陈立宏(1975– )，男，浙江桐庐人，博士，副教授，硕士生导师，主要从事桩基工程、边坡工程等方面的研究与教学工作。E-mail: Lhchen@bjtu.edu.cn。

中图分类号: TU470
计量
- 文章访问数: 02240
- HTML全文浏览量: 0
- PDF下载量: 0823
出版历程
- 收稿日期: 2011-06-13
- 发布日期: 2012-07-24

LOSSAP: spreadsheet approach for slope stability analysis

(1. School of Civil Engineering, Beijing Jiaotong University, Beijing 100044, China; 2. China Institute of Water Resources and Hydropower Research, Beijing 100048, China)

摘要

摘要: 边坡稳定分析的电子表格法充分利用了电子表格的计算能力和规划求解功能，程序简单易用、计算过程透明、可自校核。采用了数据捕捉和VBA函数的电子表格法LOSSAP使得计算过程具有很高程度的自动化，能够从AutoCAD中自动获取边坡几何信息以及自动计算条块的相关数据。目前该程序能实现指定滑裂面的考虑外荷载、地震力、孔压、不同形式滑裂面的多种边坡稳定分析方法的计算，是一个方便、实用、免费共享的边坡稳定分析工具。
- 边坡稳定 /
- 极限平衡 /
- 电子表格 /
- 规划求解
Abstract: The spreadsheet method for slope stability analysis based on Excel takes the advantages of powerful calculation function of the spreadsheet. It is easy-to-understand and self-explanatory. The powerful optimization tool of Excel is employed to obtain the factor of safety of the slope. The digitized geometrical information of the slope and slip slices can be obtained and written to a data file by a program developed by AutoLisp language in Autocad. The spreadsheet will deal with that data and calculate the basic data for slope stability analysis by user-defined VBA subroutines or functions. Different limit equilibrium methods for slope stability analysis are arranged in different sheets and solved by “solver tool” of Excel. The spreadsheet program is an easy tool which can acquire the factor of safety of specified slide surface under different situations.
- slope stability /
- limit equilibrium /
- spreadsheet /
- programming

HTML全文

参考文献(7)

[1]	LOW B K, WILSON H Tang. Efficient reliability evaluation using spreadsheet[J]. Engrg Mechanics, 1997, 123(7): 749–752.
[2]	LOW B K, LEE S R. Slope stability analysis using generalized method of slices[J]. Geotechnical and Geoenvironmental Engineering, 1998, 124(4): 350–362.
[3]	CHEN L H, CHEN Z Y, SUN P. Slope stability analysis using graphic acquisitions and spreadsheets[C]// Proceedings of 10th International Symposium of Landslide and Engineered Slope. Xi'an, 2008.
[4]	郭秀娟. AutoLISP语言程序设计[M]. 北京: 化学工业出版社, 2008. (GUO Xiu-juan. AutoLISP Yuyan Chengxu Sheji[M]. Beijing: Chemical Industry Press, 2008. (in Chinese))
[5]	陈仲颐, 周景星, 王洪瑾. 土力学[M]. 北京: 清华大学出版社, 1992. (CHEN Zhong-yi, ZHOU Jing-xing, WANG Hong-jin. Soil mechanics[M]. Beijing: Tsinghua University Press, 1992. (in Chinese))
[6]	陈祖煜. 土质边坡稳定分析: 原理、方法、程序[M]. 北京: 中国水利水电出版社, 2002. (CHEN Zu-yu. Soil slope stability analysis: theory, methods and programs[M]. Beijing: China Water Power Press, 2002. (in Chinese))
[7]	中国水电顾问集团昆明勘测设计研究院. 糥扎渡高心墙坝坝料特性及结构优化研究报告[R]. 昆明: 中国水电顾问集团昆明勘测设计研究院, 2006. (HYDROCHINA Kunming Engineering Corporation. Study report of Nuozhadu Dam on its materials’ character and structural improvement[R]. Kunming: HYDROCHINA Kunming Engineering Corporation, 2006. (in Chinese))