It means that in this context, your taste is more unusual/uncommon. Which means that your favorites might not do too well most of the time, since there aren't that many who might share your taste. It also means that you probably send and enjoy more "unique" songs, the kind that normally wouldn't be played on a regular radio station.
I think this has nothing to do with regular radio stations. I don't expect most songs that do well in WV to be played in regular radio stations. If I listen to "Orome", "Ein", or most of WV winners in a regular radio station, I'd be very surprised. And there are so many big hits (both recent and older) that do poorly in contests, but they play all the time in the radio stations.
Kinda love how some people try to extract from any situation or statistics that they are or their taste is unique and they send unique songs Although this is false in most cases
Highest compatibilty ever in WV (edition21): ( memorable for me) 93% and 91% I can't say I was expecting this to ever happen, but I can't say I was schocked. This, in case of happening, could only be with these 2. We have ups and downs, and I'm not their third twin 2, but overall they are the closest I've got in this forum to that (in all the contests' finals btw)!
Highest compatibilty ever in WV (edition21): ( memorable for me) 93% and 91% I can't say I was expecting this to ever happen, but I can't say I was schocked. This, in case of happening, could only be with these 2. We have ups and downs, and I'm not their third twin 2, but overall they are the closest I've got in this forum to that (in all the contests' finals btw)!
It's not a secret [MENTION=12992]Extra[/MENTION] [MENTION=10002]LeBomb[/MENTION] , it was explained many times how it's done it's dogmeat who came up with this in NSC, so all the credit to him
Simply, you compare two sets of votes and then multiply the votes which appear in both sets.
for example, I gave Norway 12 points, while you gave it 3 points, which then multiplied is 36. I gave 10 points to Australia, but you gave it nothing, so the score is 0. So you simply sum up all the scores for two countries and then divide it by 4,48 to get the % similarity (448 is the max. score two countries can get - that's when they send two identical sets of votes).
Also, the votes of finalists are modified so that they gave 12 to themselves, 10 to their 12 pointer etc. This way, when 2 countries voted for each other, it's also reflected in their similarity.
Here is the Excel file for the last edition. https://www.dropbox.com/s/0yh80oviftn1pqj/wv27.xlsx
Scoreboard27 sheet contains the votes, Scoreboard27mod contains modified votes and then there is the Similarity sheet. I use named ranges in my formulas, othewise it would be too messy.
In this particular file there are only 2 named ranges - Table27 - which is just the table in Scoreboard27 sheet, and Columns27mod, which is the header of the table in the Scoreboard27mod sheet.
You can see how each named range is defined in the Formulas -> Names manager menu. (or whatever it's called in the english version of Excel ).
Basic formula in the Similarity sheet looks like this:
=IF($A2=B$1;"";
((((SUMPRODUCT(
INDIRECT("Scoreboard27mod!"&ADDRESS(2;MATCH($A2;Columns27mod;0))&":"&ADDRESS(29;MATCH($A2;Columns27mod;0)));
INDIRECT("Scoreboard27mod!"&ADDRESS(2;MATCH(B$1;Columns27mod;0))&":"&ADDRESS(29;MATCH(B$1;Columns27mod;0)))))
/(448))*(100))))
First line checks if the country in the row and column is the same, if yes then it leaves the cell blank.
Next 3 lines find the columns with votes of two countries in the Scoreboard27mod sheet. The multiplication and sum of the scores is provided by the SUMPRODUCT function.
Last line is obvious.
I always insert this basic formula in the B2 cell and then drag it to the whole table
I suck at explaining things like this in English, so I hope it was at least a bit understandable.
[MENTION=9138]nofuxCZ[/MENTION] thanks for your explanation, it's very clear now... and also thanks to [MENTION=10002]LeBomb[/MENTION] for asking, I had the same question before but just left it be