Seismic hazard analyses for Taipei city including deaggregation, design spectra, and time history with excel applications

Given the difficulty of earthquake forecast, Probabilistic Seismic Hazard Analysis (PSHA) has been a method to best estimate site-specific ground motion or response spectra in earthquake engineering and engineering seismology. In this paper, the first in-depth PSHA study for Taipei, the economic center of Taiwan with a six-million population, was carried out. Unlike the very recent PSHA study for Taiwan, this study includes the follow-up hazard deaggregation, response spectra, and the earthquake motion recommendations. Hazard deaggregation results show that moderate-size and near-source earthquakes are the most probable scenario for this city. Moreover, similar to the findings in a few recent studies, the earthquake risk for Taipei should be relatively high and considering this cityʹs importance, the high risk should not be overlooked and a potential revision of the local technical reference would be needed. In addition to the case study, some innovative Excel applications to PSHA are introduced in this paper. Such spreadsheet applications are applicable to geosciences research as those developed for data reduction or quantitative analysis with Excelʹs user-friendly nature and wide accessibility.