应用Excel实现重力坝坝基多滑面抗滑稳定自动计算

彭文明; 唐志丹; 王方亮; 闫勇

doi:10.11988/ckyyb.20190802

PDF(2180 KB)

长江科学院院报 ›› 2020, Vol. 37 ›› Issue (11) : 156-163. DOI: 10.11988/ckyyb.20190802

科技简报

应用Excel实现重力坝坝基多滑面抗滑稳定自动计算

彭文明, 唐志丹, 王方亮, 闫勇

作者信息 +

Application of Excel to Automatic Calculation of Slide-resistant Stability of Gravity Dam Foundation with Multiple Sliding Surfaces

PENG Wen-ming, TANG Zhi-dan, WANG Fang-liang, YAN Yong

Author information +

文章历史 +

摘要

根据重力坝多滑面抗滑稳定计算的特点,编制Excel抗滑稳定计算工具。介绍了计算工具的编制思路,重点解析了荷载计算时的Excel函数嵌套应用以及方程单变量求解要点。应用该工具,用户仅需输入基本数据,就可快速完成多滑面抗滑稳定计算,而且计算过程全透明,便于检查和统一设计标准。通过考题和工程实例,证明了Excel抗滑稳定计算工具的准确性和实用性。该方法有利于坝基多滑面抗滑稳定自动计算的推广应用,也可供类似设计计算参考。

Abstract

In this paper we present an Excel-based tool for calculating the slide-resistant stability of gravity dam with multiple slip surfaces. We put forward the ideas of compiling this calculation tool and expound the key points in load calculation such as applying nested functions and solving single variable equation. With this tool, users can quickly complete the calculation by merely inputting basic data. The calculation process is transparent and easy to check and unify the design standards. A couple of examples verify the accuracy and practicability of the tool. This method is beneficial to the popularization and application of stability calculation for dam foundation with multiple slip surfaces, and also offers a reference for similar design calculation.

导出引用

彭文明, 唐志丹, 王方亮, 闫勇. 应用Excel实现重力坝坝基多滑面抗滑稳定自动计算[J]. 长江科学院院报. 2020, 37(11): 156-163 https://doi.org/10.11988/ckyyb.20190802

PENG Wen-ming, TANG Zhi-dan, WANG Fang-liang, YAN Yong. Application of Excel to Automatic Calculation of Slide-resistant Stability of Gravity Dam Foundation with Multiple Sliding Surfaces[J]. Journal of Changjiang River Scientific Research Institute. 2020, 37(11): 156-163 https://doi.org/10.11988/ckyyb.20190802

中图分类号： TV315

参考文献

[1] NB/T 35026—2014,混凝土重力坝设计规范[S].北京:中国电力出版社,2015.
[2] 周建平,钮新强,贾金生.重力坝设计二十年[M].北京:中国水利水电出版社,2008.
[3] 彭文明,马行东.多滑动面方法在官地电站深层抗滑稳定分析中的应用[J].四川水利,2008,4:6-9.
[4] 彭文明,姚雷.建基面与软弱结构面组合的抗滑稳定分析方法探讨[J].长江科学院院报,2014,31(4):46-47.
[5] 陈祖煜,汪小刚,杨健,等.岩质边坡稳定分析:原理·方法·程序[M].北京:中国水利水电出版社,2005:443-446.
[6] 梅明荣,任青文.基于优化理论的刚体极限平衡模型[J].长江科学院院报,1999,16(3):17-20.
[7] 彭文明. 坝体条分下的坝基抗滑力学机理及其影响分析[J]. 水力发电,2019,45(5):58-61,85.
[8] 彭文明. 重力坝多滑面深层抗滑稳定计算的优化方法[J].长江科学院院报,2019,36(4):1-8.
[9] DL 5077—1997, 水工建筑物荷载设计规范[S].北京:中国电力出版社,1998.
[10]NB/T 35047—2015,水电工程水工建筑物抗震设计规范[S].北京:中国电力出版社,2015.
[11]SL319—2018, 混凝土重力坝设计规范[S].北京:中国水利水电出版社,2018.
[12]EM 1110-2—2200, Gravity Dam Design[S]. Washington DC: US Army Corps of Engineers, 1995.