Download the Spreadsheet here.

Disclaimer: The Engineering Tools provided have been checked, but, that being said, WikiEngineer is not able to guarantee the complete accuracy of all these works. Therefore it is important for everyone to do their due diligence to make sure that all works are complete and accurate.

If any mistakes are found they will be added to the Addendum portion you will find under each spreadsheet. Also, if a new version is uploaded the version will change (all versions will start at v1.0 and update accordingly). It is up to you to do your own research and make certain that you have reviewed the spreadsheet you're using and that you are using the most up-to-date spreadsheet available

What does the Column Stability Factor Spreadsheet solve?

An example of a wooden column
Fig. 1: A Wooden Column

The column stability factor is one of the lumber adjustment factors necessary to solve for compression in a column. The factor, CP, is used to solve for FC in sawn lumber, glue laminated timbers, and round poles/piles.

See Column Stability Factor for complete details on how this wood factor is calculated. Or try here to see an example of how everything is calculated.

How to Understand this Spreadsheet
  1. Where to Download
  2. How to use this spreadsheet
  3. Notes
  4. Addendum
  5. Spreadsheet FAQ's

Where to download?

Download the Spreadsheet here.

How to use this Spreadsheet:

This spreadsheet works in Microsoft Excel 2003 and later. A complete walkdown of how CP is calculated can be found here.

The top portion of the spreadsheet allows you to change your inputs:

Wood Column Factor Inputs
Figure 2: Spreadsheet Inputs

where:

l1 = length of the member (strong axis)
d1 = depth of the member (strong axis)
l2 = length of the member (weak axis)
d2 = depth of the member (weak axis)
CD = the load duration factor
CM, t, F, i = other misc. factors
c = factor taken from NDS 3.7.1
Emin' = Emin' = Emin * CM * Ct * Ci * CT
Fc = Compression Stress parallel to the grain

The bottom portion of the spreadsheet calculates CP and uses it to find Fc' & Pa

Wood Column Factor Results
Figure 2: Spreadsheet Results

As you can see the spreadsheet's primary function is to calculate CP, yet the spreadsheet does go one step further and tell you what your allowable axial force and stress is.

Notes:

The following notes must be considered when using this spreadsheet:

  1. When a compression member is supported throughout its length to prevent lateral displacement, CP = 1.0
  2. l / d < 50 except during construction when l /d is allowed to be < 75
  3. Emin' = Emin assumes that CM, Ct, Ci, & CT are also unity which is most often the case but should be verified
  4. This spreadsheet was made using the ANSI / NF&PA NDS 2005

Addendum

  • V1.0: This is the original version of the column stability factor spreadsheet

Main

Construction

Environmental

General Engineering

Geotechnical

Structural

Transportation

Water Resources

Miscellaneous

edit SideBar