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

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

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

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.