Spreadsheet to Calculate Required
Seismic Loads to Design the Structures and
Elements of Structures for Multistory Buildings Per ASCE 7-22
Analysis Features
- Static seismic base shear including Redundancy Factor
- Seismic Design Category Determination and Automatic Site Coefficients Interpolation
- Lateral force Fx, story shear Vx and overturning moment on each level/story
- Diaphragm load Fpx on each level
- Component lateral force Fp on each level considering resonance and ductility factors
- Vertical seismic forces
- Out of plan lateral design forces for walls and required anchorage forces
- Structural wall's anchorage forces to flexible roof or rigid floor diaphragm
Spreadsheet Features
- The spreadsheet can be used for any number of stories
- Main assumptions, input descriptions and example problem verification are included in the package
- The main sheet is not protected so it can be modified to the user's need
- Built-in drop down input and input guides provided through validation box
To obtain the spreadsheet, we ask your contribution to our seminar or online training on
ASCE 7 Seismic Design Parameter and ICBPRO at under-resourced institutions in high seismic regions.
Please contact us for expected contribution and metric unit versions.