摘要
基于非线性规划方法,建立了描述三轴试验强度包线的数学模型;通过正确设置Excel软件的规划求解参数对话框,快速而准确地求解出目标函数的最优解,获取了三轴试验的抗剪强度指标;利用Excel图表向导进行绘图,实现试验数据自动处理及自动绘图。该方法简便易行,结果准确可靠。
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 the"graph guide"function,strength parameters and the plot were exported automatically.The method is simple,rapid and accurate.
出处
《铁道科学与工程学报》
CAS
CSCD
2009年第5期57-60,共4页
Journal of Railway Science and Engineering
基金
国家自然科学基金资助项目(50678175)
关键词
抗剪强度
非线性规划
三轴试验
EXCEL
最优化
数据处理
soil shear strength
nonlinear program
triaxial compression test
Excel
optimization
data handling