Line 207:
Line 207:
The impact is normalised in order to calculate the score.
The impact is normalised in order to calculate the score.
+
+
==== Export matrix worksheet ====
+
This worksheet shows the scores as used by OFF and are setup such that they can easily be imported. Instead of the country names the [https://en.wikipedia.org/wiki/ISO_3166-2 ISO 3166-2] codes are used. Rows and columns are alphabetically sorted on these codes. Each cell contains a formula to extract the data from the '''Score matrix worksheet'''.
+
+
Adding a new country can be done by:
+
* inserting a column in the right (alphabetical) location;
+
* linking the header of the new column to the corresponding row header;
+
* copying a formula from an existing cell to all the rows of the new column;
==== Update Procedure ====
==== Update Procedure ====