Cost-benefit analysis for Operational Earthquake Forecasting using probabilistic seismic hazard assessment for circular area using Excel

This is a Microsoft Excel spreadsheet to under cost-benefit analyses for operational earthquake forecasting actions based on 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 (Cauzzi and Faccoli, 2008). 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).

The numbers in yellow can be changed to assess the benefit-to-cost ratio for different actions.

It is an extension of my spreadsheet for PSHA for a circular source, which is also available here.

For more details please see the article by Douglas and Azarbakht (2020).