September 27, 201410 yr Actually you can see both of those stats in one chart. Just sort by rows in 'points given' and you'll have points received ( :magic: ) Ashton 536 tho :/
September 27, 201410 yr Actually you can see both of those stats in one chart. Just sort by rows in 'points given' and you'll have points received ( :magic: ) Ashton 536 tho :/ How do you sort rows? I admittedly have an old version of Excel so it might just be a feature that was added later but I've never been able to figure out a way to do that.
September 27, 201410 yr There are two sheets in that file, the first is for points given and the second for points received (because Excel only lets you sort columns for some reason). The lists for both are generated by reverse alphabetising the column of your country. If that makes sense. And yes this is up to date as of LXVIII! Thanks! I didn't notice the 2nd sheet
September 27, 201410 yr These tables are fascinating for highlighting one-way love affairs. It's strange that Kylienips have dished out four times as many points to Fljótavík as they've received for example. Obviously one factor is that Kylienips DNQ a lot more frequently but it's strange how two countries with such similar music tastes can have such a voting discrepancy. :o I think the DNQ element is the primary factor here, the secondary factor is that Kylienips tend to DNQ with their best tracks and qualify with their more generic dance sounding ones that I'm less likely to vote for.
September 27, 201410 yr How do you sort rows? I admittedly have an old version of Excel so it might just be a feature that was added later but I've never been able to figure out a way to do that. You can sort them by selection sort, then pick options in the pop-up menu and change it to rows (this is literally translated from dutch so it might be named differently
September 27, 201410 yr How do you sort rows? I admittedly have an old version of Excel so it might just be a feature that was added later but I've never been able to figure out a way to do that. You can sort them by selection sort, then pick options in the pop-up menu and change it to rows (this is literally translated from dutch so it might be named differently Yeah I did that. I think a transpose of the table -> normal sort would work as well
September 27, 201410 yr I think the DNQ element is the primary factor here, the secondary factor is that Kylienips tend to DNQ with their best tracks and qualify with their more generic dance sounding ones that I'm less likely to vote for. I have the same problem with D'yermak'er and especially Terra Avium, I think I'd have given 12 points to 3/4 of D'yermak'er's DNQs and Terra Avium only ever seem to Q with their less good entries, only exception being Kissy Sell Out really :/ Yeah I did that. I think a transpose of the table -> normal sort would work as well A transposition of the table is exactly what the second sheet is! I meant I couldn't find a way to DIRECTLY sort rows (although even if there is a way it wouldn't be easily copy and paste-able so the way I've done it is probably better anyway). EDIT: Oh I got the other way to work yay. But yeah it doesn't work very well so the two sheets are still easier.
September 27, 201410 yr Given 01. 16 Danaelanda (2) 02. 14 Republic Of Adonia (2) = 14 Jamvale (2) 04. 13 D'yermak'er (2) 05. 12 Daehun (2) 06. 12 Oslol (1) = 12 Greenfroze (1) = 12 Fljotavik (1) 09. 11 N DNTN (2) 10. 10 Allecian (1) = 10 Florina (1) 12. 09 Kylienips (2) = 09 Cadelicia (2) 14. 08 Yehesi (2) 15. 08 Ethanola (1) = 08 Seyetana (1) = 08 Botanikka (1) 18. 07 Zechonia (1) 19. 06 Aeroche (1) = 06 Ojnoj (1) 21. 05 Sandeborg (1) 22. 04 Kathaldazia (1) 23. 03 FSR Rontvia (1) = 03 Jayrusalem (1) = 03 Unovia (1) 26. 02 Ethanola (1) = 02 Mdice (1) = 02 Umiiruka (1) 29. 01 Utopia (1) = 01 Persephonia (1) = 01 Hendinia (1) Received 01. 12 Danaelanda (1) = 12 Varake (1) 03. 10 Jukianie (1) = 10 Kylienips (1) 05. 08 Eledan (1) = 08 Republic of Adonia (1) = 08 Florina (1) 08. 07 Aquafina (1) = 07 Hushkanukia (1) 10. 06 Sandenia (1) = 06 Terra Di Campioni (1) 12. 05 Ultraviolenceland (1) = 05 Zechonia (1) = 05 D'yermak'er (1) = 05 Sandeborg (1) = 05 Quintessa (1) 17. 04 Desbuanda (1) = 04 Greenfroze (1) = 04 Hendinia (1) 20. 03 Trifoski (1) 21. 02 N-Lazone (1) = 02 Tartford (1) = 02 Terra Avium (1) 24. 01 Jamvale (1)
September 27, 201410 yr These tables are fascinating for highlighting one-way love affairs. It's strange that Kylienips have dished out four times as many points to Fljótavík as they've received for example. Obviously one factor is that Kylienips DNQ a lot more frequently but it's strange how two countries with such similar music tastes can have such a voting discrepancy. :o Similarly, Sandeborg have given me 98 points and I've reciprocated 21, eek, sorry Adam! Loads of my favourites of yours seem to DNQ :( I've given you 100 and in return have received 5 :( That document is truly incredible and must never ever be lost Bre!
September 27, 201410 yr I've given you 100 and in return have received 5 :( That document is truly incredible and must never ever be lost Bre! :drama: Another case of the entries of yours that I love DNQ'ing. You do have a habit of appearing in my commiserations a fair bit too I think, during 2011 in particular iirc.
September 27, 201410 yr I've given you 100 and in return have received 5 :( That document is truly incredible and must never ever be lost Bre! if only it also contained breakdowns and whatnot~~
September 27, 201410 yr Quick bit of Excel wizardry: the top 10 most lopsided points relationships :magic: (first country listed owes the specifed number of points to second country listed) 261 FSR Rontvia -> Ashton 174 FSR Rontvia -> Kylienips 165 Aeroche -> Kylienips 146 Fljótavík -> Kylienips 142 Fljótavík -> PRoJ 139 Hendinia -> Tinnmark 135 Mdiče -> Kylienips 128 Numayania -> Sangria 119 Aeroche -> Espen 118 Mdiče -> Espen Poor Kylienips and Espen. :(
September 27, 201410 yr the espen one seems really strange to me ! cos i am a big espen fan but then again most of the ones that would've SWEPT my points this year have dnqed.
September 27, 201410 yr Oops! My excuse is that we're the three still standing from the first contest and I've had 7 DNQ's in the period compared to 26 for Kylienips and 16 for Ashton so I've missed a lot of chances to give them points! Ashton's tragic DNQ run of four in a row in 2010 alone would have bagged them another 35 points or so.
September 27, 201410 yr Points Given: 01 (136) Hendinia 02 (100) FSR Rontvia 03 (80) Ramrynia 04 (73) Aeroche 05 (71) Pendulous Republic of Nork 06 (63) Botanikka 07 (62) Eledan 08 (54) Daehun 09 (53) D'yermak'er 10 (52) Batidas 11 (51) Fljotavik 12 (50) Numayania 13 (49) Caerfyrddia 14 (49) Unovia 15 (48) Isconia 16 (47) Ojnoj 17 (46) B.a.N.G 18 (42) Bignia-Zaragovina 19 (40) UnoShake 20 (38) Seyetana 21 (38) Trifoski 22 (36) Espen 23 (36) N DNTN 24 (34) Altyr Muunilinst 25 (32) Persephonia 26 (31) Allecian 27 (31) Ingermanlandia 28 (30) Ashton 29 (28) Tinnmark 30 (27) Syndare 31 (26) Yehesi 32 (25) #00274E 33 (25) Greenfroze 34 (24) Juranabaijan 35 (24) Sandeborg 36 (23) Skall 37 (21) Mdice 38 (19) Herzebania 39 (19) Kingdom of Shadow 40 (19) Terra Avium 41 (19) Zechonia 42 (18) Cumulonimbia 43 (17) Kylienips 44 (17) Utopia 45 (16) Sangria 46 (15) Danaelanda 47 (15) Yuxhaaq 48 (14) Aquafina 49 (14) Republic of Adonia 50 (14) Sandenia 51 (14) Torchwood 52 (14) United States of Jack 53 (13) Cadelicia 54 (13) ChrIseland 55 (13) Dalisska 56 (13) Florina 57 (13) Jamvale 58 (12) Budtar 59 (10) Launica 60 (10) Lorikeet 61 (8) Xanaga 62 (7) Farahtyn 63 (6) New Caprica 64 (5) Bellamia 65 (5) Ben's Sanctuary 66 (5) FARC 67 (5) PRoJ 68 (4) Land of Jack 69 (4) Usfland 70 (3) Kathaldazia 71 (3) N-Lazone 72 (2) Ethanola 73 (2) Scherzland 74 (2) Umiiruka 75 (2) Varake 76 (2) Vulkyria 77 (1) Euphoriffith 78 (1) Jayrusalem 79 (1) Quotosibb Points received: (88) Zechonia (61) Danaelanda (54) Fljotavik (52) Budtar (51) Daehun (46) Batidas (44) Isconia (42) Altyr Muunilinst (42) Ashton (42) Utopia (40) Farahtyn (38) Aquafina (38) ChrIseland (38) Greenfroze (38) Mdice (38) Unovia (37) Seyetana (36) Bellamia (36) Eledan (36) UnoShake (34) Allecian (34) Bignia-Zaragovina (34) D'yermak'er (33) Persephonia (32) Botanikka (31) Palmyra (31) Tinnmark (30) Terra Avium (29) N-Lazone (29) Usfland (27) Yuxhaaq (26) Trifoski (25) Caerfyrddia (24) N DNTN (23) Aeroche (23) Dalisska (23) Hendinia (23) Jamvale (23) Umiiruka (22) Skall (21) #00274E (21) Ramrynia (21) Sandeborg (17) Deandria (17) Singerpurear (16) Lievant (15) Numayania (14) Herzebania (14) Quintessa (14) Vulkyria (14) Yehesi (13) Euphoriffith (13) Florina (13) Juranabaijan (13) Ojnoj (12) Espen (12) Ethanola (12) Fervorosia (12) Harmonica (12) Jayrusalem (10) Kingdom of Shadow (9) Kylienips (9) Land of Jack (9) PRoJ (9) Torchwood (8) B.a.N.G (8) Cadelicia (8) Keypopian Republic (8) Lotopialand (8) Oslol (8) Pendulous Republic of Nork (7) Avalonia (7) Lake Thermwoods (7) Sangria (7) Scherzland (7) Syndare (6) Xanaga (5) Desbuanda (5) FSR Rontvia (5) Kathaldazia (4) Hushkanukia (4) Ingermanlandia (3) Varake (2) Alteria (2) FNT Nickodonia (2) Quotosibb (1) Fanadminaj (1) Lorikeet Only the coolest kids vote Kluminican 8-)
October 19, 201410 yr Update after 69 finals: 1. Ashton 275 2. Kopecka/Nork 218 3. Numayania 202 4. Ojnoj 152 5. Hendinia 127 6. Espen 126 7. Botanikka 121 8. Mdice 120 9. Eledan 112 10. Altyr Muunilinst 106 11. Kylienips 105 12. Herzebania 90 13. Caerfyrddia 80 14. Tinnmark 78 15. Syndare 78 16. Xanaga 76 17. Torchwood 71 18. Batidas 69 19. Greenfroze 67 20. Sangria 67 21. Fljótavík 65 22. Angelicland 65 23. Aeroche 63 24. Isconia 59 25. Bhangra 58 26. BaNG 56 27. Ramrynia 55 28. Seyetana 55 29. Kingdom Of Shadow 49 30. Yuxhaaq 48 31. Bignia-Zaragovina 44 32. Nonsuch 43 33. Utopia 43 34. Skall 42 35. Yehesi 42 36. Zechonia 42 37. Quotosibb 42 38. #00274E 42 39. PRoJ 41 40. Daehun 41 41. United States Of Jack 39 42. Bellamia 37 43. Letland 37 44. Land Of Jack 36 45. FNT Nickodonia 36 46. Kathaldazia 35 47. Ingermanlandia 32 48. N DNTN 31 49. Lorikeet 31 50. Danaelanda 30 51. Aquafina 30 52. Unovia 29 53. Persephonia 29 54. Dalisska 29 55. Simondly 29 56. Lotopialand 26 57. MKL 25 58. Allecian/Lexico 25 59. Triodopolis 21 60. Sandebörg 21 61. Trifoski 20 62. Unoshake 20 63. Rivandia 20 64. Tapitalandia 19 65. D'yermak'er 18 66. Florina 18 67. Tartford 17 68. FARC 17 69. Järkangel 16 70. Liechenstaan 15 71. N-Lazone 15 72. Cascadia 14 73. Ben’s Sanctuary 14 74. Oslol 12 75. Jamvale 12 76. Terra Avium 12 77. Cumulonimbia 12 78. Farahtyn 12 79. Euphorrifth 12 80. Varake 12 81. Greenland 12 82. Umiiruka 12 83. Bokia 11 84. Phlumptopia 11 85. Britmasu 10 86. Juranabaijan 10 87. Kluminican Republic 9 88. Fervorosia 9 89. New Caprica 9 90. Usfland 8 91. Lievant 8 92. Palmyra 8 93. Faztickle 8 94. Frahliso 8 95. Tyronasaurusland 8 96. Poisonvine Bay 7 97. Astoria 7 98. Deandria 7 99. Priceville 6 100. Jamora 6 101. New Alba 6 102. Jukianië 5 103. Londonski 5 104. Cadelicia 4 105. Scherzland 4 106. Quintessa 3 107. Spila 3 108. Sandénia 2 109. Inner Massivia 2 110. Terra Di Campioni 2 111. Camdonia 1 112. ChrIseland 1 12 points for Altyr crushes Kylienips' dreams as the former climb back into the top ten, knocking Kylie down to 11th, even though they scored points too this month. Big scores for big tunes from Kathaldazia, N DNTN and Trifoski push them up the mid-table while Oslol and Aquafina register small climbs and Aeroche grab another point to add to their tally. We vote for both rarely but Kluminican Republic and Lexico both score this month and as such both move up the leaderboard.
October 19, 201410 yr These are the updates on votes given by Singerpurear: 2 new entries from Ajanaeda and Desbuanda at 46 and 40, 0074E goes top 30, Eledan goes top 20, and Fljotavik goes top 10 and hovers just outside the top 5. Altyr goes top 5, and FSR Rontvia drops to 3 despite gaining points, overhauled by Kylienips up to 2 and cutting Yehesi's lead down to a mere 19 points. 1 1 Yehesi 74 2 4 Kylienips 55 3 2 FSR Rontvia 48 4 2 Greenfroze 44 5 6 Altyr Muunilinst 41 6 5 Trifoski 38 6 13 Fljotavik 38 8 6 Isconia 35 9 8 Skall 32 9 8 Ramrynia 32 9 8 Hendinia 32 12 11 B.a.N.G. 30 13 12 Bignia-Zaragovina 29 14 13 Federal Republic of Ashton 28 14 13 Juranabaijan 28 14 13 Ingermanlandia 28 14 13 D’yermak’er 28 18 18 Jamvale 26 19 19 Sandeborg 23 19 19 Oslol/The People’s Republic of Ginsay Lohands 23 19 19 Unovia 23 19 25 Eledan 23 23 22 N DNTN 22 23 22 Numayania 22 23 22 Daehun 22 23 29 Kluminican Republic 22 27 25 Tartford 20 28 27 Terra Avium Dinosaur 19 29 28 Quintessa 18 30 32 0074E 16 31 30 Espen 15 31 30 Persephonia 15 33 32 Aeroche 14 33 32 Utopia 14 35 35 Batidas 13 35 35 Ojnoj 13 37 37 Cumulonimbia 12 38 38 Umiiruka 10 39 39 Mdice 9 40 40 Ben’s Sanctuary 8 40 40 PRoJ 8 40 40 FNT Nickodonia 8 40 40 Allecian 8 40 40 Syndare 8 40 NEW Desbuanda 8 46 45 Botannika 7 46 46 Aquafina 7 46 NEW Ajanaeda 7 49 46 Varake 6 49 46 N-Lazone 6 49 46 Scherzland 6 49 46 Harmonica 6 49 46 Florina 6 54 52 Danaelanda 5 54 52 Zechonia 5 54 52 Bellamia 5 54 52 Ethanola 5 58 56 Palmyra 4 59 57 Caerfyddia 3 59 57 Cadelicia 3 59 57 Jukianie 3 62 60 Sandenia 2 62 60 FARC 2 64 62 Tinnmark 1 64 62 Euphoriffith 1
October 19, 201410 yr ✖ 26 CONTESTS ✖ 193 N DNTN (+12) 118 Mdice 72 Skall 60 Fljotavik 59 Eledan (+08) 59 Syndare 55 #00274E 53 Persephonia 43 Hendinia 41 FSR Rontvia 41 Utopia 41 Isconia 39 Altyr Muunilinst (+02) 36 Danaelanda (+04) 32 D'yermak'er 32 Ethanola 30 FARC 28 Espen (+05) 28 Cadelicia 26 Ramrynia 25 Terra Avium (+10) 25 Botanikka (+07) 23 Kluminican Republic 20 Batidas 19 Bellamia 19 Daehun 19 Ingermanlandia 18 Yehesi 17 Trifoski 16 Seyetana 16 Bijescia 15 Usfland 15 PRoJ 14 B.a.N.G 13 Umiiruka 12 Jamvale 11 Allecian 11 Sandeborg 10 Cumolunimbia 10 Varake 10 Republic Of Adonia 10 Fervorosia 10 Kingdom Of Shadow 10 Sangria 09 Aquafina 09 Caerfyrddia 08 OSLOL (+06) 08 Jarkangel 07 Unovia 07 Ojnoj 06 Kylienips 06 Jayrusalem 06 Herzebania 06 Pendulous Republic Of Nork 05 Kathaldazia (+01) 05 Ashton, Federal Republic Of 05 Lake Thermwoods 04 Vülkyria 04 Sandenia 03 Euphoriffith 03 Palmyra 03 Tinnmark 02 Lorikeet 01 Singerpurear 01 Dalisska chris this is getting ridiculous now.
Create an account or sign in to comment