TXT-tool 3.001-1.4: Using Excel Tools for Slope Stability Analysis

  • Beena Ajmera
  • Binod Tiwari


Each year landslides around the world are responsible for the loss of hundreds of lives, damage to infrastructure, billions of dollars in economic loss and have an impact on the environment. An understanding of the stability of slopes is crucial to reduce the impact of landslides and there are several available methods and computer programs to do so. However, the development of simple spreadsheets to evaluate the stability of slopes can be beneficial in reducing the cost of purchasing commercially available programs and the learning component associated with these programs. This teaching tools outlines the procedures to develop Excel Spreadsheets for four commonly used slope stability analysis methods. Specifically, step-by-step procedures to determine the factor of safety using the Ordinary Method of Slices, Bishop’s Simplified Method, Simplified Janbu Method and the Lowe and Karafiath Method are provided.


Slope stability Excel tools Ordinary method of slices Bishop’s simplified method Janbu simplified method Lowe’s method 


  1. Bishop AW (1955) The use of slip circle in the stability analysis of earth slopes. Géotechnique 5(1):7–17CrossRefGoogle Scholar
  2. Duncan JM, Wright SG, Brandon TL (2014) Soil strength and slope stability. Wiley, New Jersey, p 2Google Scholar
  3. Fellenius W (1922) Staten Jarnjvagars Geoteknniska Commission. Stockholm, SwedenGoogle Scholar
  4. Fellenius W (1936) Calculation of the stability of earth dams. In: Transactions of the 2nd congress on large dams, international commission on large dams of the world power conference, vol 4, pp 445–462Google Scholar
  5. Janbu N (1973) Slope stability computations. Embankment-dam engineering-Casagrande. Wiley, New York, pp 47–86Google Scholar
  6. Janbu N, Bjerrum L, Kjærnsli B (1956) Veiledning ved Løsnig av Fundamenteriingsoppgaver (Soil mechanics applied to some engineering problems) vol 16. Norwegian Geotechnical InstituteGoogle Scholar
  7. Lowe J, Karafiath L (1959) Stability of earth dams upon drawdown. In: Proceedings of first pan American conference on soil mechanics and foundation engineering, vol 2, pp 537–552Google Scholar
  8. Morgenstern NR, Price VE (1967) A numerical method for solving the equations of stability of general slip surfaces. Comput J 9(4):388–393CrossRefGoogle Scholar
  9. Skempton AW (1948) The φ = 0 analysis of stability and its theoretical basis. In: Proceedings of the second international conference on soil mechanics and foundation engineering, vol 1, pp 72–78Google Scholar
  10. Spencer E (1967) A method of analysis of the stability of embankments assuming parallel inter-slice forces. Géotechnique 17(1):11–26CrossRefGoogle Scholar
  11. Taylor DW (1948) Fundamentals of soil mechanics. Wiley, New YorkGoogle Scholar

Copyright information

© Springer International Publishing AG 2018

Authors and Affiliations

  1. 1.Department of Civil and Environmental EngineeringCalifornia State University FullertonFullertonUSA
  2. 2.Department of Civil and Environmental EngineeringCalifornia State University FullertonFullertonUSA

Personalised recommendations