| Abstract: | ![]()
A practical and transparent procedure is described for implementing a generalized limit equilibrium method via cell-object-oriented constrained optimization in the spreadsheet platform. The formulation allows switching among the Spencer, Bishop simplified and wedge methods on the same template by specifying different side-force inclination and different constraints of optimization. Search for the critical circular or non-circular slip surface is possible. The deterministic procedure is extended probabilistically by implementing the first-order reliability method via constrained optimization of the equivalent dispersion ellipsoid in the original space of the random variables. This procedure is illustrated for an embankment on soft ground, and for a clay slope in southern Norway, both involving spatially correlated soil properties. The effects of autocorrelation distance on the results of reliability analysis are studied. Shear strength anisotropy is modelled via user-created simple function codes in the programming environment of the spreadsheet. The meaning of probability of failure is discussed. |
