Hi Paul,
I see what you mean and I think that we should try it the way that you are suggesting and forget about the city pairs.
I want to use 4 metrics, score1 and score2 for city 1 and score1 and score2 for city2.
I then add the scores to get 2 total scores which I then weight with weights? This would give me 1 weight for score1 and 1 weight for score2? And perhaps a weight for total score? Or is that just adding useless information?
Name Score1 Score2 Total score Score1 Score2 Total score City1 City1 37 22 59 9 36 45 City1 City2 16 78 44 29 63 92 City1 City3 48 25 29 79 79 158 City1 City4 80 25 39 31 13 44 City1 City5 61 86 81 41 61 102 City1 City6 73 73 42 48 38 86 City1 City7 73 86 0 9 13 22
This is how I think that my raw data will look like.
