Guild Wars 2

Anyone out there know of a way for me to quickly turn the leaderboard into Excel format? I just want to pivot some data, or filter out people with less than X games.

Thanks

Check out this site
http://www.gwshack.info/?region=na

Has the top 1000 for SoloQ + Team NA and Europe in a nice table format. You should be able to simply cut and paste and it will seperate into seperate columns for you in excel and if it doesn’t, you could use the text to column function.

Top 25 NA soloQ with > 100 games:

Iroha
Magnobear
Dustinbro
Identity Lost
Stuningstyles
Juaraz Feng
Scintelle
Anathemancer
Baby Feed
Illusionary Bong
Cryptographic
Mini Grimmy Soulz
Uhíwi
Chiisakute Kawaii
Lily Rosethorn
Fatty Eggs
Melancholia
Cruuk
Vvv Steamhawke
Genyen Z
Super Mang Jose Jr
Elita One
Gadgets Vain
Wacky Bruce
Thenleaf

It may not be an accurate read but it’s the most accurate we have. No one on that list is getting carried, queue dodging and pugstomping, crutching on easy wins in the early games, or just getting lucky. Luck is still a bit of a factor with 100 games, but it’s had some time to start evening out. Quite a few of them stream, well worth watching if you’re looking to improve your play and maybe get up there yourself.

It would be nice to be able to filter by profession. There are a lot of necros, engis, and guardians there. I don’t know the main solo queue profession of a few of the people on the list though.

BTW top 100 with > 100 games is equal to rank 363 atm. Everyone who is above that with > 100 games played is in the list.

Also, I think Symbolic is the best evidence that the initial ratings deviation is too high right now. He got to #1 (or was it 2?) by going 11-0 against the kind of opposition you can go 11-0 against, which is clearly weaker than the level of opposition he faces now, because he then went 11-6 and dropped to #27 despite having almost 65% win rate while playing at the top. He needs to play a lot more games before those initial 11 high RD games against weak opposition will be absorbed into his rating properly. If he continues with that win percentage, he would be around #10 on this list.

I’m not criticising Symbolic here, it just seems the Glicko2 system could use some tweaking if people only need to play 1 game a month to maintain their leaderboard spot. If everyone who goes 11-0 or 11-1 drops rating when they keep playing, there’s obviously a problem, and everyone does. The system is clearly not finding the appropriate rating for them via that high initial RD, it’s just overly rewarding those who have a lucky initial run and overly punishing those who get a few 4v5s or otherwise terrible teams early on. That might be fine for chess, where luck is not a factor, but in a random team environment, it does make a difference.

Lastly, team queue is where it’s really at. The skillset is slightly different, and larger. However, the soloboard removes the possibility that someone is being carried and should have a somewhat lower rank. I think this could apply to a handful of ‘good players’ after watching some of the streams out there.