Inputs for each of these metrics come GIS modeling of the ZOIs. Each metric is calucated for three flood events (2-year, 20-year, and 100-year) and converted to expected annual (see worksheet 'EADExample' and project report).

For buidlings, roads, and critical facilities exposed, GIS modeling tallies the number/miles for each event and the worksheets here simply convert to expected annual. For expected annual damages to buildings, there are four worksheets. 'Inputs' worksheet is where we enter charateristics for each building. 'Coastal_DDF' contains a number of depth-damage functions taken from FEMA's HAZUS software and from the USACE (2015) NACCS report. 'Damage' applies characteristics of the buildings and the appropriate depth damage functions to calculate pre-project and post-project damages for each building affected at each project site and across each flood event modeled. The UID column is a unique identifier to track each combination of building and NFWF project site. Finally, the worksheet 'Metric9ByProject' sums up damages across all buildings for each project and flood scenario and converts the result to expected annual damages pre-project and post-project.