EXCEL在边坡稳定性分析中的应用

利用Excel强大的数据处理、便捷的公式函数和所支持的面向对象化的程序设计语言VBA，应用于土坡的稳定性分析。基本方法为：先采用传统的瑞典条分法对边坡进行计算分析，在求得最危险滑动面的基础上，通过简化Bishop法对边坡安全系数Fs进行改进。在此过程中，Excel加载VBA子程序可以方便地得到极限平衡条分法中的各未知量，并计算出最危险滑动面上的安全系数Fs，同时使用其可视化功能绘出最危险滑动面的位置。此方法简化了计算程序，不仅容易在Excel表格中实现，且计算对比表明本文方法计算结果与简化Bishop法计算结果非常接近，可满足工程需要。

The Application of EXCEL in Slope Stability Analysis

By exploiting Excel＇s powerful data-processing and convenient formula for support functions and of object-oriented programming language VBA, it applies to the stability analysis of some slopes. The basic method is that first Swedish slices method which is the traditional method, is used to calculate and analyze this slope, and at the basis of former method obtaining the most dangerous sliding surface, the safety factor Fs will be improved through simplified Bishop method. In this process, the unknown variable of the limit equilibrium method can be easily obtained by Excel add-VBA subroutine, and factor of safety （Fs） of the most dangerous sliding surface is calculated. At the same time,a visualization button is designed to draw the location of the most dangerous sliding line of this slope. This method make the calculation procedure simplify, and it can not only achieve easily in the Excel, but also the results are proved to be very close when the data obtained from this method, is compared with the simplified Bishop method, so it can meet demand for project.