PSHAcirculararea.xls (7.57 MB)
Probabilistic seismic hazard assessment for circular area using Excel
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.