Like I said, I'm struggling with meaningful analysis for city pairs. One city at a time is easy


What I tried was ...

1. Comparing Karlshamn against Karlskrona for 20 metrics, if Karlshamn > Karlskrona for 7 and Karlshamn < Karlskrona for 12 and even for 1, then I scored the Karlshamn - Karlskrona pair as -5 ( i.e. 7 - 12 + 0)

I could just count the 'greaters than' and then Karlshamn would = 0 and Karlskrona = 12


2. I started with the 'Data' sheet and 'Score' was the last. I'd format 'Score' better to make it more understandable ("easy enough for a VP to read" )


3. I think I'll take a shot at just a single city comparison and see what it looks like