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

Fig. 1: Spreadsheet Equations
where:
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.

Fig. 2: Site Specific Equations/Variables
where:
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.

Fig. 3: Component Specific Equations/Variables
where:
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.

Fig. 4: Spreadsheet Results/Summary
where:
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:
- Designed using the ASCE 7-05 edition.
- See Chapter 13
- 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.