Programming solver tools of Excel evaluate shear strength parameters from results of triaxial tests

In this study,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 for solving the equations.The optimum results of the aim function were figured out by setting the dialog box accurately.Mohr's circles and Mohr's strength envelope was plotted by use of the"graph guide"function,strength parameters and the plot was exported automatically.The method is simple,rapid and accurate.