|
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?

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 | |||||||||||||
Where to download?
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:

Figure 2: Spreadsheet Inputs
where:
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

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:
- When a compression member is supported throughout its length to prevent lateral displacement, CP = 1.0
- l / d < 50 except during construction when l /d is allowed to be < 75
- Emin' = Emin assumes that CM, Ct, Ci, & CT are also unity which is most often the case but should be verified
- 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