Statistics

[WorldVision]

WV 191 pots
WV Statistics (courtesy of @ShoeFlo)

​

A Argentina Estonia Ireland Germany London Sweden Southern USA Spain Ukraine Western USA​	B Bavaria Bosnia & Herzegovina Brazil Martinique Northwestern Russia Russia South Africa Türkiye​	C Albania Armenia Croatia Italy Hungary Romania United Kingdom​
D Afghanistan Egypt France Japan Kanto Mazovia Pacific States Paris Sudogwon Vestlandet​	E England Faröe Islands Götaland Greece Iceland Istria Norway Portugal United States​	F Canada Cyprus Finland Latvia New Zealand Scania Svealand​

N
Australia
Morocco
Ghana
North Macedonia



Other:

WV 182 Statistics update
WV 60 - 146 results

How are similarities counted?

​

 

[nofuxCZ]

WV28 table
WV28 table with OP members

 

[EurovisionSmile]

WV28 table
(+ I will add OP members' individual similarity later)

You're always so fast!

 

[Luki]

TOP 5:

1. ::vien Vienna 81%
2. sq Basque Country 63%
3. Svealand 59%
4. Finland 56%
5. India 55%
-. Serbia 55%

BTM 5:

1. Andorra 0%
2. Malasiya 2%
-. Australia 2%
4. London 3%
-. Romania 3%

 

[esc87fan]

50% or more
54%
51%

10% or less
0%
6%
7%
8%
de 9%

 

[anselm]

Top 5

1. Tinchey (81%)
nofuxCZ (77%)
Trash (76%)
2. sq pjelacki (74%)
3. chontono (70%)
4. de JamieBrown (57%)
5. Stargazer (56%)

Bottom 5

1. TomCherson (0%)
Gogerko (0%)
Rodrigo (2%)
2. Simon87 (4%)
2. RomanFromRussia/Inter (4%)
4. Guilep (6%)
5. FabiESC (7%)
5. Staewi (7%)

 

[cegs5]

Top
78% ::uusi

Bottom
0%

 

[JamieBrown]

Top 5

1. as78 - 70 %
2. Nicholas123 - 65 %
3. Stargazer - 62 %
4. nofuxCZ - 59 %
5. ::vien anselm - 57 %
5. sq pjelacki - 57 %

Bottom 5
1. shmelsasha - 1%
2. Amir - 2 %
3. Xoxryak - 4 %
3. blein - 4 %
5. Guilep - 5 %
5. Hele. - 5 %

And only 7 % to [MENTION=11728]Alex1211ander[/MENTION] I knew your music taste is hopeless

 

[daniels1000]

60%+

83% Celia
79% Nicholas123
72% as78
71% Stargazer
67% Ank
61% EmperorG


10%-

::blgr 4% SRBIJA
4% Adrian
5% nekoisneko
5% Amir
6% Simon87
7% Evangeline
9% Staewi
9% Hele.
10% FabiESC
10% HEAON
10% Avalon
::wenl 10% Rodrigo

 

[EurovisionSmile]

50% or more:

77%
73%
60%
60%
59%
55% awh!

Czechia 54%

54%
53%
52%

10% or less:

10%
8%
8%
5%
5%
3%
3%
0%

 

[Gera11]

69%
.
.
.
0%

 

[SRBIJA]

sq pjelacki 72%
.
.
.
viktOr 0%​

 

[Amir]

Great that you included OP members :3

for

Top5:

71%
67%
63%
62%
58%

Bottom 5:

0%
0%
1%
de 2%
3%
3%


btw, you wrote for Iran Amir, not chontono 2

 

[nofuxCZ]

btw, you wrote for Iran Amir, not chontono 2

sorry, chon xD all these changes of regions and new people, it's so confusing sometimes

 

[dogmeat]

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 must say it's... so embarrassing... I wrote a small C++ program to calculate the table... I didn't know there was such an easy way to do it in excel

 

[Avalon]

+ 50%

72%
63%
55%
52%


- 10%

8%
9%
10%

 

[nofuxCZ]

I must say it's... so embarrassing... I wrote a small C++ program to calculate the table... I didn't know there was such an easy way to do it in excel

I first wrote an Excel macro to do this but it was just too slow, so I thought there must be a way how to do it with just excel formulas and luckily I figured it out (but it took me lots of time and lots of searching on excel forums, especially the formula for counting the combined similarity - it's like 40 lines long and so messy I'm thinking of writing a program in C# or C++ for that soon )

 

[FilipFromSweden]

Great that you included OP members :3

for

Top5:

71%



btw, you wrote for Iran Amir, not chontono 2

 

[dogmeat]

Well, I'm impressed. God job. I'm just learning the functions you used and deciphering your formula. Excel is a powerful tool indeed.

 

[CypriotGirl]

50%+
56% (Milos-BC)
55% (Veliky)
54% (esc87fan)
52% (Trece)
50% (Evangeline)

10%-
4% (TomCherson)
8% (Alex1211ander)
9% (Sven)

 

[Trece]

52% (Trece)

Finally