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

• 科技简报 • 上一篇    下一篇

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

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

  1. 中国电建集团成都勘测设计研究院有限公司 勘测设计分公司,成都 610072
  • 收稿日期:2019-07-11 修回日期:2019-09-19 出版日期:2020-11-01 发布日期:2020-12-02
  • 作者简介:彭文明(1978-),男,江西宜春人,教授级高级工程师,硕士,主要从事水工结构设计和计算工作。E-mail:pwm02@163.com

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   

  1. Department of Survey and Design, Power China Chengdu Engineering Corporation Ltd.,Chengdu 610072,China
  • Received:2019-07-11 Revised:2019-09-19 Published:2020-11-01 Online:2020-12-02

摘要: 根据重力坝多滑面抗滑稳定计算的特点,编制Excel抗滑稳定计算工具。介绍了计算工具的编制思路,重点解析了荷载计算时的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.

Key words: gravity dam, multiple sliding surfaces, slide-resistant stability, Excel, automatic calculation

中图分类号: