Probabilistic seismic hazard assessment for circular area using Excel
datasetposted on 26.01.2020 by John Douglas
Datasets usually provide raw data for analysis. This raw data often comes in spreadsheet form, but can be any collection of data, on which analysis can be performed.
This is a Microsoft Excel spreadsheet to compute the probabilistic seismic hazard for a circular area of uniform seismicity characterised by a Gutenberg-Richter relation and using a simple ground motion prediction equation. The circular area is split into 10 annuli to integrate over the area. The hazard curve is computed as well as various associated parameters (e.g. mean disaggregated scenario).
It is an extension of my spreadsheet for PSHA for a point source, which is also available here.