基于非线性规划方法,建立了描述三轴试验强度包线的数学模型;通过正确设置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.