Retaining Wall Spreadsheet 2

[CTruax]

I am about to write my own concrete retaining wall excel-spreadsheet.
Does anyone have an un-protected (not for sale) sheet (or source) I could use as a starting point?

 

[Qshake]

CTruax,

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.

Good Luck.

Regards,
Qshake

Eng-Tips Forums:Real Solutions for Real Problems Really Quick.

 

[TFL]

i would add one reference the crsi handbook has tables with retaining wall in them you could use it as a check

 

[NewImhotep]

CTruax
u can found several Spreadsheets (it's protected without password).
in this site

http://www.civl.port.ac.uk/rcc2000/

including retaining wall design.

i hope it's help.

Ahmed

 

[bashabo]

check this out:

http://www.engineering-international.com