Design Bolted Wood Connections With Spreadsheet
Kent Davis, Ph.D, PE
Course Outline
This course summarizes
the major factors involved in the design of laterally loaded bolted wood connections.
An Excel© 2003 spreadsheet is provided that determines the allowable lateral
load on a bolted wood connection based on the bolts and the member tensile stress.
The use of the spreadsheet is illustrated with five examples.
This course includes
a multiple choice quiz at the end, which is designed to enhance the understanding
of the course materials.
Learning Objective
At the conclusion of this course, the student will:
Intended Audience
Structural Engineers, Architectural Engineers, Civil Engineers, and Architects.
Course
Content
The course content and the spreadsheet are in the following links:
Design Bolted Wood Connections With Spreadsheet ( Content PDF File 2.5 MB)
BOLTUP© spreadsheet (Spreadsheet PDF File 52 KB. The actual Excel spreadsheet is needed to solve quiz problems and is available in the quiz)
You must have a licensed copy of Excel program to use this spreadsheet.
Analysis ToolPak needs to be installed before the Excel spreadsheet can function properly. To install the Analysis ToolPak:
1. Start Mircrosoft Excel spreadsheet programThis spreadsheet is provided for illustrative teaching purpose
only, and is not intended for use in any specific project. Anyone making use
of the information contained in this spreadsheet does so at his/her own risk
and assumes any and all resulting liability arising therefrom.
You need to open or download above files to study this course.
Table of Content
Introduction
Wood Properties Relevant to Connector Design
Combining Factors
Bolt Properties Relevant to Wood Design
Load Application
Steel Side Plates
Failure Modes and Equations
Connecting Wood to Concrete or Masonry
Member Failure
Using the Spreadsheet
Examples 1-5
References
Quiz
Once
you finish studying the
above course content,
you need to
take a quiz
to obtain the PDH credits.