Aggregation of sustainability indicators by shifted geometric means and comparison with established rankings

This spreadsheet file contains data and calculations to supplement manuscript with tentative title
Y. A. Phillis, V. S. Kouikoglou, E. Grigoroudis, and F. D. Kanellos, "On a mathematical theory of sustainability assessment".

We start with n sustainability indicators relevant to a country whose sustainability is assessed. The following are common assumptions in most sustainability assessment approaches:
a) each indicator i, i = 1, …, n, is normalized into a dimensionless number x_i on [0, 1], where 0 corresponds indicator values deemed unsustainable and 1 corresponds to completely sustainable values
b) each indicator i is assigned a weight of importance w_i where w_i>0 and Σ w_i = 1.

The shifted geometric mean of x_i is defined by
GM_c = Π (c + x_i)^{w_i} - c
where c is a positive parameter. For simplicity we choose c=1 and use GM_1 as an alternative national sustainability index. We compare some publicly available sustainability indices with GM_1 using the same indicator values and weights.

The spreadsheet contains several sheets grouped by color. Each color corresponds to one of the following assessment approaches
1) Human Development Index (HDI)
2) Environmental Performance Index (EPI)
3) Two TOPSIS-based assessments using the EPI data (TOPSIS: Technique for Order of Preference by Similarity to Ideal Solution)
4) Sustainability Assessment by Fuzzy Evaluation (SAFE)
Each sheet contains one of the following:
i) Indicator and sustainability indices from sources mentioned in the "Steps to reproduce" section below.
ii) Calculations involving GM (GM_1) or TOPSIS
iii) Computation of correlation coefficients (Pearson r, Kendall tau) between the overall sustainability indices obtained by two models.