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 Seismic Design for Non-Structural Components Solve?

This spreadsheet will solve for your seismic design for non-structural components (e.g. Veneers, cabinets, signs, HVAC's, elevators, generators, piping, ductwork, cabletrays, etc.). It only finds your component seismic forces, you will still need to plug any seismic shear forces into either your ASD? or LRFD? load combinations to analyze the components connections/structural integrity

This spreadsheet solves for:

  • Your Seismic Response Coefficient
  • Your Seismic Component Force
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. This spreadsheet will solve for your Non-Structural Seismic Response Coefficient and your Component Seismic Force.

The portions of the spreadsheet highlighted in yellow are the variables. The portions highlighted in blue are your results:

Equations

The top portion of the spreadsheet shows you all of the Seismic Response Coefficient equations for Non-Structural components (this is based on 13.3 of the ASCE 7-05). There are multiple equations that determine: the calculated seismic response coefficient, the minimum allowable seismic response coeff, and the maximum allowable seismic response coeff. for non-structural components

Non-Structural Seismic Design Spreadsheet
Fig. 1: Spreadsheet Equations

where:

FP = Seismic Design Force for the component attached to a structure. This force will be used to evaluate any connections and the structural integrity of the system.
aP = The component amplification factor (varies from 1 to 2.5)
SDS = The short period design spectral response acceleration parameter
WP = The weight of the component
RP = The Response Modification Factor of the component (this factor is based off of the type of component being hung; higher R values react better to earthquakes then lower R values)
IP = The Importance Factor of the component (see 13.1.3)
z = The height of the point of attachment of the component w.r.t. the base
h = The average roof height of the structure w.r.t. the base


Site Specific Variables

The next portion of the excel sheet covers all of the site specific variables. These are variables are determined by the location of the building.

Non-Structural Seismic Design Spreadsheet
Fig. 2: Site Specific Equations/Variables

where:

Site Class = Aka Seismic Design Catagory. The Seismic Design Catagory is based off of the occupancy or use of the structure, and the expected soil seismic ground motion. If this variable is unknown it is usually appropriate to use class "D" in seismic zones.
SS = The parameter for the 0.2 second spectral response acceleration
SMS = The MCE, 5 percent damped, spectral response acceleration at short periods adjusted for site class effects
SDS = The design, 5 percent damped, spectral response acceleration at short periods adjusted for site class effects
SD1 = The design, 5 percent damped, spectral response acceleration at 1 second adjusted for site class effects


Component Specific Variables

The next portion of the excel sheet covers all of the component specific variables. These are variables are determined by the type of component being hung from the building, the occupancy, and importance.

Non-Structural Seismic Design Spreadsheet
Fig. 3: Component Specific Equations/Variables

where:

aP = The component amplification factor (varies from 1 to 2.5)
RP = The Response Modification Factor of the component (this factor is based off of the type of component being hung; higher R values react better to earthquakes then lower R values)
IP = The Importance Factor of the component (see 13.1.3)
z = The height of the point of attachment of the component w.r.t. the base
h = The average roof height of the structure w.r.t. the base

Note: z/h cannot be greater than 1.0




Results

The final section sums everything up.

Non-Structural Seismic Design Spreadsheet
Fig. 4: Spreadsheet Results/Summary

where:

FP = Seismic Design Force for the component attached to a structure. This force will be used to evaluate any connections and the structural integrity of the system.
Factor = The Seismic Design Factor (in G's)
WP = W = The weight of the component

Note: Don't forget that you still need to plug these values into your load combinations to properly analyze the structure.




Notes:

The following notes must be considered when using this spreadsheet:

  1. Designed using the ASCE 7-05 edition.
    • See Chapter 13
  2. The weight of the component needs to be less than 25% of the weight of the building, otherwise the structure should be considered a non-building structure.

Addendum

  • V1.0: This is the original version of the Non-Structural Seismic Design Spreadsheet.

Main

Construction

Electrical Engineering

Environmental

General Engineering

Geotechnical

Structural

Transportation

Water Resources

Miscellaneous

edit SideBar