The following spreadsheet has been designed to calculate the factor of safety using the Duncan, Wright, & Chong three-stage analysis teachnique applied to a case involving infinite slopes:
Click here to download a copy of the spreadsheet.
Using the equations on the spreadsheet and the example problem described on pages 174-177 of your textbook, complete the spreadsheet by entering formulas in each of the yellow cells. Test your spreadsheet using two depths (z=5ft, z=30ft) and compare to solution found on table 9.2
Submittal Instructions
Upload your spreadsheet via Learning Suite.