Wood Perforated Shear Wall Design

(4/12)

Description


This program may be used to design wood perforated shear walls in accordance with IBC 2003 & ANSI/AF&PA SDPWS-2005.

Calculation Reference
IBC 2003

Calculation Reference

IBC 2003

Perforated Shear Wall

Timber Design

Calculation Preview

Jason M. McQueen (MSE)
27 Sep 2012
File Size: 475.50 Kb
Downloads: 690
File Version: 1.0
File Author: Jason M. McQueen
File Rating (4/12)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 6
jefflayman 8 years ago
Anyone interested in this calculation may want to check out the perforated wood shear wall worksheet that I uploaded. It is based on a newer document (SDPWS-2015 instead of IBC-2003)and includes graphics that update in real time to depict wall perforations. see [here](/404/).
anniesball 12 years ago
This is nice, but what are the forces around the opening? Is it possible to get this information?
johndoyle-admin 12 years ago
Sorry I should have explained there is no update to the Excel file I simply updated the description to include a calculation preview in response to a user request. [Admin]
MSE 14 years ago
Some comments ask some questions of your spreadsheet MSE. I am copying them here because they should have been raised in the forum.
gfs_se 14 years ago
I like the look of the spreadsheet. How did you create the graphics? They don't appear to be excel drawing tools.
Why have so much of the calculation buried in hidden columns? Wouldn't it be more meaningful for a reviewer, i.e. city, county or state plans examiner, to see all of the calculations that go into F. The comments have a lot of useful information in them, but none of that will show up when the sheet is printed out to submit to the plans examiner.
Several of your equations appear to be a special function called embed. Is this an excel function or from an add-in?
Have you considered highlighting the cells that require input to differentiate them from calculated results? Any thoughts of including the shear tables?
MSE 16 years ago
The program allows for an unlimited number of segments. The segments can be of any size that does not violate the aspect ratio. The figure is only presented as an example of the application.
Web Analytics