Output files

Several csv outputs are produced by Damage Calculator, the exact number depending on the settings that have been selected and the additional damage types calculated. This section provides a description of all the outputs that may be produced.

(projectName).csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset.
CalcCode	Abbreviation of 'Calculated Code' - mcmcode / property type code used for each individual property, accounting for any property code mappings applied in the 'property codes' section of the 'settings' tab.
CalcFloor	Abbreviation of 'Calculated Floor Area'. Floor area of each individual property, accounting for any floor areas updated using 'DefaultFloorArea' in depth-damage data file, if 'assume zero floor areas valid' setting not checked.
PVD	Uncapped and un-written off present value direct property damages.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total direct property damage costs.
Vehicle PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total vehicle costs.
Indirect PVD (Capped /Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total indirect non-residential costs.
Emergency PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total emergency services costs.
Evacuation PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total evacuation costs.
Mental Health PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total mental health costs.
Human Intangible PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total human intangible costs.
Risk To Life PVD (Capped / Written Off / Combined)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total risk to life costs.
DPTH_(RP)_(scenarioYear)	Multiple columns. Each column contains the flood depth above threshold level at an individual property for the stated return period and scenario year (epoch) in the column title.
PROP_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the direct property damage at an individual property for the stated return period and scenario year (epoch) in the column title.
VEH_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the vehicle damage costs at each individual property for the stated return period and scenario year (epoch) in the column title.
NRP_IND_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the indirect non-residential costs at each individual property for the stated return period and scenario year (epoch) in the column title.
EMERG_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the emergency services costs at each individual property for the stated return period and scenario year (epoch) in the column title.
EVAC_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the evacuation costs at each individual property for the stated return period and scenario year (epoch) in the column title.
MENT_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the mental health costs at each individual property for the stated return period and scenario year (epoch) in the column title.
Onset_(scenarioYear)	Multiple columns. Each column contains the return period of onset of flooding for each individual property for the stated scenario year (epoch) in the column title.
AAD_(scenarioYear)	Multiple columns. Each column contains the annual average damage for each individual property for the stated scenario year (epoch) in the column title.
LOL_DMG (RP)_(scenarioYear)	Multiple columns. Each column contains the loss of life / risk to life costs at each individual property for the stated return period and scenario year (epoch) in the column title.
AA_LOL_(scenarioYear)	Multiple columns. Each column contains the annual average loss of life costs for each individual property for the stated scenario year (epoch) in the column title.
Error	Contains any calculation errors associated with each individual property.

(projectName)_allPvd.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
Capped?	Yes / No whether property is capped or not.
Written Off?	Yes / No whether property is written off or not.
Year of Capping	Year property is capped.
Year of Writeoff	Year property is written off.
Year (Earliest) of Capping or Writeoff	Earliest year of capping or writeoff.
PVD from AAD	uncapped, unwritten off PVD accumulated from discounted AADs derived from flood damages.
PVD from AAD (to MV cap limit)	PVD accumulated from discounted AADs derived from flood damages, capped at market value.
PVD from AAD (to writeoff limit)	PVD accumulated from discounted AADs derived from flood damages, limited at point in time property is written off.
PVD from AAD (to MV cap OR writeoff limit)	PVD accumulated from discounted AADs derived from flood damages, limited at either capped market value, or the point in time that property is written off, whichever happens earliest.
PVD of Writeoff Year Discounted Markval	Discounted market value in year of writeoff. It should be noted that this is calculated for upper floor properties, to represent the fact that if the ground floor of a property is written off, the upper floor is also likely to be uninhabitable. If this is not required, the property should be deleted from the property dataset.
PVD (AAD until writeoff + discounted markval)	PVD (not accounting for capping) until writeoff, plus discounted market value at point of writeoff.
PVD (AAD + discounted markval)	PVD (accounting for capping and writeoff), plus discounted market value at point of writeoff.
Total PVD Capping and Writeoff	Total PVD, accounting for discounted market value and curtailment of damages due to both capping and writeoff.
PV_(x)	Present value direct property damage in year (x) of appraisal period.

(projectName)_allPvd_Emergency.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total emergency services costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total emergency services costs.
PV_(x)	Present value emergency services costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_Evacuation.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total evacuation costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total evacuation costs.
PV_(x)	Present value evacuation costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_HumanIntangible.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total human intangible costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total human intangible costs.
PV_(x)	Present value human intangible costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_Indirect.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total indirect non-residential costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total indirect non-residential costs.
PV_(x)	Present value indirect non-residential costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_MentalHealth.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total mental health costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total mental health costs.
PV_(x)	Present value mental health costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_RiskToLife.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total risk to life costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total risk to life costs.
PV_(x)	Present value risk to life costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_allPvd_Vehicle.csv

Column Titles	Notes
(various property information)	Various property information such as address, reproduced from property dataset if relevant property information included in property dataset - otherwise columns blank.
markval	Contains market value reproduced from property input information.
PVD	Uncapped and un-written off present value total vehicle costs.
PVD Capped / PVD Written Off / PVD Combined	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total vehicle costs.
PV_(x)	Present value vehicle costs in year (x) of appraisal period. It should be noted that this column is only populated until the year the property is capped / written off, if either or both of these settings has been selected.

(projectName)_err.csv

This output reproduces property information for properties where an error has been detected during the damage calculation process. The error is reported in the final column of the table.

(projectName)_log.csv

This output records several useful pieces and sets of information related to the damage calculator run which it forms part of, including:

The version of Damage Calculator used
The output filepath
All property dataset field mappings used
All settings used
The depth-damage filepath used
The depth-damage files used
The filepath of the property dataset used
The filepath of depth / level grids used

(projectName)_summary.csv

Column Titles	Notes
Damages	Lists damage type which other columns provide details of.
PVD (No Capping or Write Off)	Uncapped and un-written off present value damages for the damage type listed in 'Damages' column.
PVD (With Capping + Write Off)	Depending on whether 'Apply Capping', 'Apply Write Off' or both have been selected, this column contains the capped / written off / both present value total for the damage type listed in 'Damages' column.
(scenarioYear) Damage (RP)yr	Multiple columns. Each column contains the total event damage costs for the stated return period and scenario year (epoch) in the column title.
(scenarioYear) Fatalities (RP)yr	Multiple columns. Each column contains the number of fatalities for the stated return period and scenario year (epoch) in the column title.
(scenarioYear) WetPropCount (RP)yr	Multiple columns. Each column contains the number of properties subject to above threshold flooding for the stated return period and scenario year (epoch) in the column title. It should be noted that only ground floor properties subject to above threshold flooding are included in this total. Upper floor properties are not included. Properties which are subject to economic damage from below-threshold flooding are not included.
(scenarioYear) AAD	Multiple columns. Each column contains the annual average damage total for the stated scenario year (epoch) in the column title.

Reviewing results on damage calculator interface

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

The ‘Results Summary’ tab displays column totals, i.e. damage, additional damage, AAD and PVD totals for all properties in the analysis area.
The ‘Results per Property’ tab combines the key attributes of each property with the calculated flood depth depth and economic damages. 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 AAD values. Clicking the ‘Export to Shapefile’ button generates a new point shapefile with each point corresponding to a row on the results tab (i.e. a property). This data can also be automatically added to the Flood Modeller map view by ticking the View in Flood Modeller checkbox prior to exporting. This option is only only available Damage Calculator is running within the Flood Modeller interface.

Right-clicking on any header within the results table accesses 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:

Data can be grouped 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.

If data is exported to shapefile after filtering the results table, only the displayed data will be exported. Hidden rows and columns will not be included in the shapefile.

Reviewing results in flood modeler interface

After loading the damage data shapefile in Flood Modeller, settings can be modified to highlight the largest event damages, AAD values and PVD values. This allows a visual check for any anomalies, providing some qualitative verification of hydraulic model results.

The standard display when a point shapefile is loaded into the map view is shown below. Each feature (point) in the shapefile is displayed with the same size and colour.

Right-click on the shapefile in the Layers panel to display the layer properties (in a new window). Select the Symbology tab and Visual Style sub-tab as shown below:

The display in the map view will now clearly show the locations of properties with maximum AAD values. Use the map tools (i.e. zoom, pan and info tool) to investigate the factors underlying these high values further.