Yskuma
08-06-2010, 05:00 AM
I’ve extracted the guild lists for the 7 servers from the guild leaderboards and exported them to Excel. I’m not sure if there will be any interest but I figured I might as well post them. I thought it might be interesting to be able to look in more detail at the number of people in each guild and whether the renown earned by guilds was vastly different between servers.
Link to the file
http://rapidshare.com/files/411353548/Guild_Lists_2010-08-06.xls.html
http://www.megaupload.com/?d=8Y3HK0KO
Here are a few quick statistics.
Server Total Guilds Total Characters Total Renown Avg Char\Guild Avg Renown\Guild
Argonnessen 2659 51441 166010954 19.35 62433.60
Ghallanda 3011 54941 156775181 18.25 52067.48
Khyber 4050 67834 201142024 16.75 49664.70
Sarlona 3338 59513 179531585 17.83 53784.18
Thelanis 3802 66721 222484995 17.55 58517.88
Cannith 2548 38646 140665167 15.17 55206.11
Orien 2261 34292 127368103 15.17 56332.64
That gives a total of 373388 characters in guilds across the servers.
I’d really like to do an export every day/week and see how the renown for the guilds changes with time. I don’t know how thrilled Turbine would be with me crawling through 1000ish web pages every day though so for now we’ll call this a one off. If you spot any issues let me know and I'll try and correct them.
Note to Turbine: Any chance we could get daily csv dumps of the guild leaderboard please? An export to csv option would be really nice too...
Link to the file
http://rapidshare.com/files/411353548/Guild_Lists_2010-08-06.xls.html
http://www.megaupload.com/?d=8Y3HK0KO
Here are a few quick statistics.
Server Total Guilds Total Characters Total Renown Avg Char\Guild Avg Renown\Guild
Argonnessen 2659 51441 166010954 19.35 62433.60
Ghallanda 3011 54941 156775181 18.25 52067.48
Khyber 4050 67834 201142024 16.75 49664.70
Sarlona 3338 59513 179531585 17.83 53784.18
Thelanis 3802 66721 222484995 17.55 58517.88
Cannith 2548 38646 140665167 15.17 55206.11
Orien 2261 34292 127368103 15.17 56332.64
That gives a total of 373388 characters in guilds across the servers.
I’d really like to do an export every day/week and see how the renown for the guilds changes with time. I don’t know how thrilled Turbine would be with me crawling through 1000ish web pages every day though so for now we’ll call this a one off. If you spot any issues let me know and I'll try and correct them.
Note to Turbine: Any chance we could get daily csv dumps of the guild leaderboard please? An export to csv option would be really nice too...