How to review Damage Calculator results

On completion of a Damage Calculator analysis, results are displayed in tables in two tabs entitled Results and Results Summary. These are only activated and visible when a damage calculation completes successfully.

The following steps detail how to review these results:

1. The results tab table combines the key attributes of each property identified within the flood extent with the calculated depth and associated damage. The total damage is also displayed below the relevant column in the table. If multiple grids are included in the analysis then the results table will contain multiple depth and damage data in extra columns, together with an AAD value.

   

2. The Results Summary tab displays all column totals, i.e. damage, additional damage, AAD and PVD totals for all properties in your analysis area. Note, the property damages are displayed here as separate totals for residential and non-residential properties.

   

3. The tool writes the tabular results data to a series of csv format text files when the Export Results button is clicked (on the Results tab). One file contains all data displayed on the Results tab and one contains all data displayed on the Results Summary tab. These data will also automatically open in Excel when the Export Results button is clicked. Note that, if a PVD calculation is performed, an additional csv file is generated that provides a check of the contributions to PVD for each year of the specified appraisal period. This lists all discounted, interpolated AAD values (over the appraisal period) that are summed to calculate PVD totals for each property.

4. Clicking the Export to Shapefile button will generate a new point shapefile with each point corresponding to a row in the currently displayed data, with the displayed tabular data included as feature attributes. These data can also be automatically added to your Flood Modeller map view by ticking the View in Flood Modeller checkbox prior to exporting (this option only works when you start Damage Calculator from within the Flood Modeller interface).

   The export buttons are located below the table on the Results tab.

5. If you right-click on any header within the results table you can access tools to customise the displayed data. The available tools are as follows:

   • Sort the table using the selected column in ascending or descending order, e.g. to show the properties contributing most to overall damage totals. Note that simply clicking on a column header will also run the sort function (first click sorts in ascending order, second click re-sorts to descending order).
   • Group by selected column – grouping by a selected column converts the table to a tree view in which each branch contains rows with the same value for the selected column, e.g. group by MCM code to see all properties assigned code 1. Branches can be expanded or collapsed either by clicking the triangle icon to the left of each group or by selecting new right-click menu options to expand/collapse all. Note that all groups will be collapsed initially, as shown in the example below:

   
   You can group by multiple columns. Grouping extra columns will create a nested tree view.

   The “Show Group By Box” command displays the selected column that defines the displayed groupings in a header above the table.

   Selecting the right-click option on a column header to Ungroup will return the table back to its original format.

   • Show / hide columns – either user menu command to hide the selected column or display the column selection pop-up window as shown below. This can show/hide columns by dragging into the box or double-clicking on an item in the box already respectively. It can do the same for whole bands of columns, e.g. hide all property metadata columns copied in from the input property dataset.

     

   • Filter editor – create expressions to define which rows in the table to display, e.g. only show properties with 100yr return period damages > 50,000.

     

   After filtering your results table, if you choose to export data to a point shapefile then only the displayed data will be exported. Hidden rows and columns will not be included in the shapefile.

6. Each damage analysis performed generates a log file in your specified output folder. The contents of this can also be viewed in the Damage Calculator interface on the Output log tab. This log file will include a summary of your analysis settings and any notes describing the simulation (added in the Project Notes section of the interface). In addition, any issues during the analysis are listed, e.g. where a property’s (MCM) code did match any of the curves included in the nominated depth damage database.

   

7. After completing your analysis, you can save the settings you specified to an xml format settings file, referred to as a Damage Calculator calculation file. Click the File menu in the upper left corner of the interface and select Save Calculation from the dropdown menu.

   Use the File menu to then reload a calculation file to review or repeat your analysis in a later session. Note that many of the default Damage Calculator settings (e.g. nominated depth damage data folder) will be stored by the tool and be present by default at the start of your next session.