The Weighted Annual Average Damage (WAAD) Estimation Tool

This “ballpark” estimation tool can be used if you have little or no understanding on the techniques of flood loss assessment and if you have no data for calculating the potential flood losses.  The tool provides an indication of the potential annual benefits (or avoided annual flood losses) provided by a flood defence scheme for residential and non-residential (commercial) properties only.   

Click on the image below to download the tool as an Excel spreadsheet (1.6mb)

Warning: This is average data and may not be a true representation of a flood event at your locale.  We do not recommend using it at a detailed scale (e.g. street level).

Simplified benefit: cost appraisal tool for flood risk management

This spreadsheet incorporating all the stages in calculating the benefit:cost ratio and other indices of scheme worthwhileness. It is not for the novice, because the complexity will be somewhat off-putting. It is also somewhat simplified, in that average flood depths are used for properties affected, rather than individual property levels and resulting flood depths. It is a tool to be “played with”, rather than used as a serious project appraisal calculator.

Click on the image below to download the tool as an Excel spreadsheet (3.4mb)