You never mention 'Categories' so I don't know how they would play

My Assumptions --

1. For each metric

2. Compare each city against all others by subtracting scores

3. Weight the difference by the metric weight

4. Highest score wins


In my screen shot above, row 7 City K and R have score of 82 and 38 for metric 1 which has a weight of .05

The weighted difference is 2.2 which is the highest for metric 1


Again ....


I have a small formula that calculates the difference in percentage units between two city pairs.

Say City1 vs City2. City1 could be 30%, and 50% better. Does this help in anyway?

I still don't see how your scoring for city pairs is going to work

To me it makes much more sense to score each city in each metric, weight the score, and them pick the city with the highest weighted score in each metric