摘要
文章利用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.
出处
《合肥工业大学学报(自然科学版)》
CAS
CSCD
北大核心
2008年第11期1828-1832,1847,共6页
Journal of Hefei University of Technology:Natural Science
基金
安徽省教育厅青年基金资助项目(2005jq1021)
合肥工业大学博士专项基金资助项目(2007GDBJ044)
关键词
土钉支护
稳定性
安全系数
电子表格
soil nailed structure
stability
factor of safety
spreadsheet