Risk systemicity questionnaire

Link to external tool

http://smr-project.eu/fileadmin/user_upload/Documents/Resources/WP_3/RSQ_Final_3.0.xlsm (+ manual here)

Use in decision framework

risk analysis


The Risk Systemicity Questionnaire is an Excel based tool where users are asked to consider the relative likelihood of a broad range of risks in their cities.

Based on the responses to the questions contained in each of the topics of the RSQ, participants are provided with a relative risk score (an estimated risk level for the city) and an awareness score (the level of knowledge the city has about the possible risk scenarios). In addition to this, users can access policies recommendations that may be used to address those risk scenarios that are of most threat to the city.

Not only does completing the Risk Systemicity Questionnaire help cities to assess their exposure to risk, but it also indicates their level of awareness of risk and where cities should prioritise their efforts. The purpose of the questionnaire is for it to be used by groups of users with diverse areas of expertise so that it can prompt valuable discussions where different stakeholders’ experiences can be brought together to determine a city’s priorities to enable them to anticipate and appropriately respond to future challenges.1)Text taken from http://smr-project.eu/tools/risk-systemicity-questionnaire/

The tool guides the user in the process to identify climate risks with helpful texts and an extensive set of questions as a foundation for the end result.


In order to use the tool, a rather extensive set of information has to be gathered, best described as indicators for likelihood, vulnerability and impact. The tool ask for specific indicators and automatically calculates a list of adaptation priorities based on the answers.

User friendliness

The tool is implemented in a macro-enabled Excel. It is structured to skip irrelevant questions based on your answers and provides helpful texts and images with questions.


Output of the tool is a prioritised list of risk scenarios.


The tool was developed in the EU funded H2020 project Smart Mature Resilience (SMR).

Conditions for use

The tool is free for use.


Not available

Footnotes   [ + ]