Design of Wood Beam-Columns with Spreadsheet
Kent Davis, Ph.D, PE
Course Outline
This course summarizes
the major factors involved in the design of wood beam-columns. Included is an
explanation of the use of an Excel© 2003 spreadsheet that can be used to
design or evaluate the capacity of wood beam-columns. The use of the spreadsheet
is illustrated with six 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.
Benefit to Attendee
The design of wood beam-columns is a necessary part of structural design but it is quite involved, and there is little prescriptive guidance available because of the countless possible combinations of bending and axial loads. The explanation given and the spreadsheet provided as part of the course allows the user to quickly design and analyze beam-columns for a variety of situations and conditions.
Course
Content
The course content and the spreadsheet are in the following links:
Design of Wood Beam-Columns with Spreadsheet (Content PDF File 192 KB)
BEAMCOL© spreadsheet (Spreadsheet PDF File 13 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 program
2. On the Tools
menu of Excel, click Add-Ins.
3. Select the Analysis ToolPak check box.
4. Click OK
This 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.
You may need to download Acrobat Reader to view and print the document.
Table of Content
Introduction
Relevant Wood Properties
Allowable Stresses for Wood
Combining Factors
Members with Bending or Compression Only
Combined Bending and Compression
Using the Spreadsheet
Examples 1-6
References
Quiz
Once
you finish studying the
above course content,
you need to
take a quiz
to obtain the PDH credits.