The current M DELENAH 1.1 is an updated version of M DELENAH with changes in the sectors agriculture, unpaved and paved roads, public sector and forest, and industry and commerce (correction of code comment only). Details of code updating are described in the User's Manual. Updates include (1) new features for the agricultural sector (specific livestock loss calculation based on a matrix where numbers of affected animals per type can be inserted), (2) correction of mistakes (wrong divisor, or wrong cell relation – all of less importance for total results in test cases) and (3) exchange of numbers to parameters (to make M DELENAH more convenient most parameters can be directly changed via constants for minimum requirement sheet in excel).
As one of the 195 member countries of the United Nations, Germany signed the Sendai Framework for Disaster Risk Reduction 2015-2030 (SFDRR). With this, though voluntary and non-binding, Germany agreed to report on measures taken to reduce disaster impacts and to monitor impacts. Among other targets, the SFDRR aims at reducing direct economic losses in relation to the global gross domestic product by 2030. The United Nations Office for Disaster Risk Reduction (UNISDR) has hence proposed a methodology for consistently estimating direct economic losses per event and country on the basis of physically damaged or destroyed items in different sectors, derived from event documentation, standardized costs per item and mean loss ratios. The method was developed based on experiences from developing countries. Therefore, Natho & Thieken (2018) test the approach for assessing costs of natural hazards in Germany and validate the existing method for an industrialized country for the first time. The methodology, presented here as Excel VBA code, was tested for the three costliest natural hazard types in Germany, i.e. floods, wind and hail storms, considering 12 case studies on the federal or state scale between 1984 and 2016. In the Excel presented here example data sets for one flood, one wind storm, and one hail storm are available. The M. DELENAH Manual provides step-by-step information for recalculating examples, create new data sets and calculate the UNISDR method or adapted versions of the UNISDR method.
Adaptation, further than only adapting parameters of the UNISDR method was necessary because analyses of loss and event reports revealed that important damage components are not included in the UNISDR method. Therefore, three new modules were developed to better adapt this methodology to German conditions: transportation (cars), forestry and paved roads. Furthermore, overheads are proposed to include the damage costs of (housing) contents as well as the overall damage costs of urban infrastructure, one of the most important but often neglected damage sectors.
Altogether three different versions of the methodology are presented in the Excel. Selection of the version requested is carried out in the readme-sheet where also a short description of the sectors considered can be found. The country-specific method (adapted parameters and modules) is set as default when “Start” is chosen. “Reference” refers to the UNISDR reference method and “Parameter” implies country-specific parameters on the basis of the original modules. Further details on the functioning of the Excel can be found in the M. DELENAH Manual attached to this data publication and information on deduction, calibration and testing are described in detail in Natho & Thieken (2018). The presented versions can be applied to available datasets or datasets created by the user. For application in Europe we suggest applying the country-specific method because the original UNISDR method both over- and underestimates the losses of the tested events by a wide margin. The parameter-adapted method leads to more realistic results and the adapted, country-specific method is finally able to calculate losses well for river floods, hail storms and storms (see Natho & Thieken, 2018). Only for flash floods with huge debris load, where urban infrastructure can account for more than 90% of the total losses, is the method not reasonable.
The adapted methodology serves as a good starting point for macro-scale loss estimations by accounting for the most important damage sectors. By publishing the VBA code for adaptation and discussion we aim to support the implementation of the SFDRR and contribute to a better documentation standard after natural hazards. However, the method and data presented is suitable for research purposes only, it has not been tested for engineering/insurance/other practical applications.