Well, it just seems to me that it's hard to take a 2 cities' metric scores and use them
Now if you had a score for each city pair, then it seems you could evaluate the pair which is now just a single paramater
Capture.JPG
So if comparing Karlshamn to Karlskrona for Metric1 was 82, then I think it would be valid to compare that pair against the others
The hard part would be to figure out how to come up with the 82
I took a shot at trying to derive a city pair score from each combination by subtracting the city score from each other in Workbook to be analyzed_2.xlsx and
