Retaining wall spreadsheet 2

[WARose]

Anybody got a good retaining wall spreadsheet? It doesn't have to check every aspect of the wall.....just a quick OT & sliding check with various geometries.

 

[HTURKAK]

If for just a quick OT & sliding check with various geometries, you may develop your excell spreadsheet.
In past , i developed a lot of spreadsheets for similar cases..

 

[Celt83]

Two versions:

Link
This one is an older one I had laying around. This one does a 1.6 factor on the bearing pressure for determining the heel and toe shear and moments.

Link
This one is set up more generally, so it required macros to do rigid body statics calculations for all of the load combinations. This one does overturning and sliding based on IBC, allows additional vertical and horizontal loads, does automatic wind pressure on the exposed stem face, service level and ultimate level bearing pressures per IBC load combos. The heel and toe shear and moments consider all the loads. Soil loading from the left is hard coded to be considered the destabilizing soil and soil from the right hard coded to be the stabilizing soil (lower load factor applied in the combos)

Feel free to bug me with any questions. If you feel like making any improvements and wouldn't mind sharing after doing so let me know and I'll either get you added so you can push an update to Github or we can work out another means of you getting me your changes that way I can do some version control/tracking.

My Personal Open Source Structural Applications:

https://github.com/buddyd16/Structural-Engineering

Open Source Structural GitHub Group:

https://github.com/open-struct-engineer

 

[JoelTXCive]

I've attempted to develop spreadsheets in the past, but they always get so complicated. Especially if you are doing battered walls or stepped wall sections.

Instead of all that......You could try out IesWeb's QuickRWall.

They give you a free 30 day trial and It's super easy to use. They have several videos on youtube.

The awesome part of that software is that they show you all the calculations so you can backcheck.

https://www.iesweb.com/quick/index.html

I've been using the software for about 18 months now and love it.

 

[dik]

Knock the dust off this, and check...

Rather than think climate change and the corona virus as science, think of it as the wrath of God. Feel any better?

-Dik

 

[WARose]

Thanks dik (and everyone else).

 

[dik]

You're welcome, but, it's part of our job description...

Rather than think climate change and the corona virus as science, think of it as the wrath of God. Feel any better?

-Dik