Journal of Yangtze River Scientific Research Institute ›› 2020, Vol. 37 ›› Issue (11): 156-163.DOI: 10.11988/ckyyb.20190802

• SCIENCE AND TECHNOLOGY NEWSLETTER • Previous Articles     Next Articles

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 Online:2020-11-01 Published:2020-12-02

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

CLC Number: