土钉支护结构内部稳定分析的电子表格法

Internal stability analysis of soil nailed structures using spreadsheet method

文章利用Microsoft Excel的规划求解及VB编程功能,采用电子表格法进行了土钉支护结构的内部稳定性分析,得出了最小安全系数及其相应的临界滑面的位置;建立的电子表格计算模型适用于分层土体,由数据输入模块、土钉计算模块、土层计算模块及优化求解模块4部分组成;只要改变土钉计算模块或土体计算模块的行数,即可适用于不同土钉排数、不同土体条分数的情况;算例分析表明,方法正确,计算简单并直观。

By applying the functions of Solver and VB programming, this paper uses Microsoft Excel to carry out the internal stability analysis of soil nailed structures, from which the minimum factor of safety of soil nailed structure and its corresponding location of the slip surface can be obtained. The model built in the spreadsheet is composed of four parts： the module of input parameters, the module of soil nailed structure,the module of soil layers and the module of optimum calculation. The spreadsheet model is suitable for different number of soil layers, different number of soil nails and different number of soil slices. Examples demonstrate that the method proposed is correct, simple and direct.