Location
San Diego, California
Presentation Date
29 May 2010, 8:00 am - 9:30 am
Abstract
A spreadsheet-based framework for quantifying local site response due to seismic excitation is presented in this paper. The main focus here is on equivalent-linear one-dimensional analysis, similar to the computer program SHAKE or its derivative kin, which by far is the most commonly used approach for performing ground response evaluation. Such analysis involves the computation of the response of a semi-infinite horizontally layered deposit overlying a uniform half-space subjected to vertically propagating shear waves. The bulk of the analysis is actually carried out in the frequency domain, which involves operations with complex-algebraic parameters. Widely available spreadsheet software is typically equipped with sophisticated features, such as programmability and handling of complex-valued data (even Fourier analysis), rendering these productivity tools fully tenable for seismic site response analysis. Since frequency domain analysis is valid primarily for linear systems, an iterative procedure is typically employed to approximate the nonlinear behavior of soil/rock materials. The benefits of performing seismic site response calculations with spreadsheets can be quite substantial, considering their rigorous functionality, dependability, and customizability, in addition to their robustness, user-friendliness, and cost-effectiveness. While the thrust of this paper is directed at the equivalent-linear one-dimensional approach, most of the spreadsheet techniques presented here can also be applied and extended to nonlinear analyses, even in two or more dimensions.
Department(s)
Civil, Architectural and Environmental Engineering
Meeting Name
5th International Conference on Recent Advances in Geotechnical Earthquake Engineering and Soil Dynamics
Publisher
Missouri University of Science and Technology
Document Version
Final Version
Rights
© 2010 Missouri University of Science and Technology, All rights reserved.
Creative Commons Licensing
This work is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 4.0 License.
Document Type
Article - Conference proceedings
File Type
text
Language
English
Recommended Citation
Iglesia, Geraldo R. and Stiady, James L., "Seismic Site Response Analysis Using Spreadsheets" (2010). International Conferences on Recent Advances in Geotechnical Earthquake Engineering and Soil Dynamics. 10.
https://scholarsmine.mst.edu/icrageesd/05icrageesd/session03b/10
Included in
Seismic Site Response Analysis Using Spreadsheets
San Diego, California
A spreadsheet-based framework for quantifying local site response due to seismic excitation is presented in this paper. The main focus here is on equivalent-linear one-dimensional analysis, similar to the computer program SHAKE or its derivative kin, which by far is the most commonly used approach for performing ground response evaluation. Such analysis involves the computation of the response of a semi-infinite horizontally layered deposit overlying a uniform half-space subjected to vertically propagating shear waves. The bulk of the analysis is actually carried out in the frequency domain, which involves operations with complex-algebraic parameters. Widely available spreadsheet software is typically equipped with sophisticated features, such as programmability and handling of complex-valued data (even Fourier analysis), rendering these productivity tools fully tenable for seismic site response analysis. Since frequency domain analysis is valid primarily for linear systems, an iterative procedure is typically employed to approximate the nonlinear behavior of soil/rock materials. The benefits of performing seismic site response calculations with spreadsheets can be quite substantial, considering their rigorous functionality, dependability, and customizability, in addition to their robustness, user-friendliness, and cost-effectiveness. While the thrust of this paper is directed at the equivalent-linear one-dimensional approach, most of the spreadsheet techniques presented here can also be applied and extended to nonlinear analyses, even in two or more dimensions.
