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 uptodate spreadsheet available

What does the Seismic Design for NonStructural Components Solve?
This spreadsheet will solve for your seismic design for nonstructural 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
Where to download?
How to use this Spreadsheet:
This spreadsheet works in Microsoft Excel 2003 and later. This spreadsheet will solve for your NonStructural 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 NonStructural components (this is based on § 13.3 of the ASCE 705). 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 nonstructural components
Fig. 1: Spreadsheet Equations
where:
F_{P} = 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.
a_{P} = The component amplification factor (varies from 1 to 2.5)
S_{DS} = The short period design spectral response acceleration parameter
W_{P} = The weight of the component
R_{P} = 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)
I_{P} = 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:
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.
S_{S} = The parameter for the 0.2 second spectral response acceleration
S_{MS} = The MCE, 5 percent damped, spectral response acceleration at short periods adjusted for site class effects
S_{DS} = The design, 5 percent damped, spectral response acceleration at short periods adjusted for site class effects
S_{D1} = 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:
a_{P} = The component amplification factor (varies from 1 to 2.5)
R_{P} = 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)
I_{P} = 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:
F_{P} = 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)
W_{P} = 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 705 edition.
 The weight of the component needs to be less than 25% of the weight of the building, otherwise the structure should be considered a nonbuilding structure.
Addendum
 V1.0: This is the original version of the NonStructural Seismic Design Spreadsheet.