Concrete Special Structural Wall ACI 318-08.xls

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Calculation Preview

The International Building Code (IBC) requires all concrete walls in seismic category D, E, and F, must be designed as a Special Reinforced Concrete Shear Wall. Basically all concrete walls in the West Coast of the US must be designed as a special wall.

The calcs in this spreadsheet are transparent unlike the typical blackbox calculations.

Also the figure of the wall in the spreadsheet changes with the input parameters.

The spreadsheet checks essentially all of the applicable codes in the ACI 318-08. The spreadsheet contains extensive boolean programming to address the convoluted nature of the code provisions for special concrete structural walls.

Anyone who has designed a special concrete structural wall knows how extremely complicated it can be, and will surely appreciate how easy to use and how thorough this spreadsheet is.

IMPORTANT: If upon opening this file, a warning message about circular referencing appears, DO NOT CLICK OK. You must CLICK CANCEL, click on Tools -> Options -> Calculation tab and enable Iteration as shown in the picture to the right. or the spreadsheet will not work properly. The reason for iteration: A vertical axial load P applied eccentrically on the wall will induce a deflection in the wall. The axial load P applied eccentrially on a wall that is deflected will cause it to deflect more. If this iteration was to be calculated by hand, it will take multiple iterations before the numbers converge to an acceptable level.

Calculation Reference
Reinforced Concrete
| Find on | Find on | Find on | Find on | Find on |
| Find on | Find on | Find on | Find on | Find on |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

The file is locked with a blank password and can unlocked to modify or study it.

Submitted On:
22 Nov 2011
Submitted By:
File Date:
22 Nov 2011
File Author:
File Version:
File Size:
7,319.00 Kb
File Type:
stars/4.gifTotal Votes:6
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.


#7 anniesball 2017-11-29 21:19
Will this be updated for ACI 318-14?
#6 DL12345 2017-01-24 01:11

Yes, some kind of unity check may be appropriate when you have significant in-plane and out-of-plane bending effects occurring simultaneously. However, there are no codes or published design guides out there that address this issue. Also it is rare to have any significant out-of-plane bending in your shear wall. The out-of-plane bending is normally for walls supporting a large cantilever slab or basement walls resisting soil. Walls supporting a cantilever slabs should not experience much in-plane shear or moments. Basement walls are braced top and bottom so the out-of-plane bending should have insignificant effect on its in-plane shear and moment capacity.
#5 alumpkin 2016-10-06 17:10
Program is very well done and a huge help for all the walls are not SDG =D only some of the boundary requirements are not needed.

Please comment on the need to have a final wall check using a unity equation....pu/pa + Mux/Max + Muy/May.....if these walls have axial and bending in two directions I think we need to check a unity equation or plot an intercation curve for the wall stability. What say you?

#4 nservin 2015-07-19 18:15
do you have one for ordinary shear wall?
#3 JohnDoyle[Admin] 2015-05-05 07:16
I downloaded the file and opened it successfully. I don't think we have a problem here. Please try to download again.

Please sign in or register to add a comment.

We have 7 guests and 43 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.



Real Time Analytics