This post is an extension of a previous post http://howtoengineer.com/retaining-wall-lateral-earth-pressure/
The spreadsheet will use the nomeclature found in NCMA’s Design Manual for Segmental Retaining Walls and Coulomb Theory.
Also here is a ‘fun’ spreadsheet where you can enter values in green columns. There are a bunch of graphs to show you how ka (the horizontal earth pressure coefficient will change with different values for backslope, effective friction angle, wall batter, and friction between wall and soil.
Earth pressure spreadsheet: Lateral Earth Pressure – Coulomb
Attached are a couple of TEDDS calcs that show the analysis of active and passive pressures based on Coulomb Theory. I am working on incorporating a berm distance into the passive equations and will probably present this in a seperate post. Using Coulomb equations for Toe slopes and backslopes should be used with caution and these conditions may warrant a Global (or slope) Stability Analysis!