This spreadsheet is derived from the previous example which listed the allowable wood stresses for various member sizes.  To know how far each member can span we must first describe the loads that are to be supported.  Use your scroll buttons to move to the right (past column "H").  You'll see that I have added two areas: "Loading Data" and "Loading Examples".

The example dead loads (weights of construction materials & finishes) are expressed in terms of pounds per square foot of floor (or roof) area.  Individual loads are listed in the "Loading Data" area.  You will need to overwrite the example loads when you work on your project.  The total of all dead loads is automatically updated as you complete each entry.

Project live loads (loads related to occupancy or use) are entered next. Live loads can include temporary roof loads during construction, snow loads, or residential floor loads (40 psf).

• Tributary Width refers to the spacing of the members (in feet).

• Stress Increase is always equal to 1.0 for floors, but can be greater than 1.0 for certain roof loading conditions.

• Deflection Criteria are limits set for member deflection under dead (D) and dead plus live (D+L) loading situations.  For example:

1. Roof joists that do not support a rigid ceiling - Hold L/180 max. (D+L)

2. Joists or rafters supporting a gypboard ceiling - Hold L/240 max. (D)

3. Joists supporting a cement plaster (stucco) soffit - Hold L/360 max. (D)

4. Floor joists - Hold L/360 for dead loads and L/300 for dead + live loads.  In addition, live load deflection should be less than 1/2" total, regardless of span.