| Excel规划求解三轴试验抗剪强度指标 |
| |
| 引用本文： | 阮波,张向京,彭意.Excel规划求解三轴试验抗剪强度指标[J].铁道科学与工程学报,2009,6(5). |
| |
| 作者姓名： | 阮波 张向京 彭意 |
| |
| 作者单位： | 中南大学,土木建筑学院,湖南,长沙,410075 |
| |
| 基金项目： | 国家自然科学基金资助项目(50678175) |
| |
| 摘 要： | 基于非线性规划方法,建立了描述三轴试验强度包线的数学模型;通过正确设置Excel软件的规划求解参数对话框,快速而准确地求解出目标函数的最优解,获取了三轴试验的抗剪强度指标;利用Excel图表向导进行绘图,实现试验数据自动处理及自动绘图.该方法简便易行 ,结果准确可靠.
|
| 关 键 词： | 抗剪强度 非线性规划 三轴试验 Excel 最优化 数据处理 |
Programming solver tools of Excel evaluate shear strength parameters from results of triaxial tests |
| |
| RUAN Bo
,
ZHANG Xiang-jing
,
PENG Yi.Programming solver tools of Excel evaluate shear strength parameters from results of triaxial tests[J].Journal of Railway Science and Engineering,2009,6(5). |
| |
| Authors: | RUAN Bo ZHANG Xiang-jing PENG Yi |
| |
| Institution: | RUAN Bo,ZHANG Xiang-jing,PENG Yi(School of Civil , Architectural Engineering,Central South University,Changsha 410075,China) |
| |
| Abstract: | The mathematics model of linear programming was established to evaluate shear strength parameters of triaxial shear test data of soil.The programming solver tools of Excel were used to slove the equations.The optimum results of the aim function were obtained by setting the dialog box accurately.Mohr's circles and Mohr's strength envelope was plotted by using thegraph guidefunction,strength parameters and the plot were exported automatically.The method is simple,rapid and accurate. |
| |
| Keywords: | soil shear strength nonlinear program triaxial compression test Excel optimization data handling |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
