29 Dec 04 22:26
It's good that you've decided to make this step. It will go along way towards your understanding of the subject and will reduce time spent on such task during projects. Ultimately this will help reduce costs for the client.
That said, let me also state that you're not the first to undertake such a task and won't be the last. It's something about spreadsheets that makes everyone just want to have one of their own everything. So, you really don't need another one for starters but you will need these references:
Foundation Engineering by Das - Very detailed and easy to read examples and theory on retaining structures such as walls (gravity and cantilever); sheet-pile applications; ti-backs and braced excavations.
Foundation Engineering by Bowles - Similar to the above but with a little more toward computational soil mechanics also.
Foundation Engineering by Peck Hanson and Thornburn - The industry staple for a handbook. Here you will find examples of cantilever retaining walls with spread footings and pile cap footings.
From the three references and a spreadsheet you can write one heck of a program that will analyze just about anything. With a little knowledge of visual basic for applications you will have a spreadsheet that will be the envy of others.
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.