Perforated Wood Shear Walls

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

Calculation Preview

"PERFWALL" is a spreadsheet program written in MS-Excel for the purpose of automating analysis of perforated wood shear walls.  Equations and limits of applicability are based on section 4.3 of the 2015 edition of Special Design Provisions for Wind and Seismic (SDPWS-2015) published by the American Wood Council.

Program Assumptions and Limitations:

1.  See SDPWS-2015 for other limits of applicability and further information.  More restrictions and requirements are present than simply those which are incorporated into this worksheet.

2.  This program is the author's interpretation of SDPWS-2015 and has not been reviewed or authorized by the American Wood Council.  User is responsible for confirming output.  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND.  IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, OUT OF OR IN CONNECTION WITH THE SOFTWARE.

3. This program contains numerous “comment boxes” which include explanations of input or output items, equations used, data tables, etc.  Presence of a “comment box” is denoted by a red triangle in the upper right-hand corner of a cell.  Move the mouse pointer to the desired cell to view the contents of each comment.

4. In general, input fields are shaded yellow and output text is colored blue.  Red text warns of input errors and black text gives context to adjacent information.  This worksheet evaluates only shear walls with at least one perforation, data for which is provided in the column called Opening No. 1.  Other data input columns are optional and grey out if no input is provided in the top row.

5. A variety of combinations of panel thickness, fastener size, and fastener spacing are presented in SDPWS. This program does not attempt to duplicate the full complexity of the source document.  Capacity data for only some of the most common combinations are included.  To check the capacity of combinations not included, look up the nominal capacity and input this value in place of the pre-defined capacity.

6. Input validation equations and data for the sketch are hidden in several columns to the right of input.  These calculations can be displayed by removing sheet protection (there is no password) and un-hiding the columns. Users may freely modify and redistribute copies this work:  it is released into the public domain.

Calculation Reference
American Wood Council
| Find on | Find on | Find on | Find on | Find on |
Wind and Seismic
| 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.

Submitted On:
12 Jul 2016
Submitted By:
File Date:
11 Jul 2016
File Author:
Jeff Layman
File Version:
File Size:
46.12 Kb
File Type:
stars/5.gifTotal Votes:2
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.


#1 JohnDoyle[Admin] 2016-07-12 09:12
An excellent debut calculation Jeff I have awarded a 6 month extension to your XLC Pro subscription by way of thanks.

Please sign in or register to add a comment.

We have 5 guests and 40 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