WarcraftRealms.com

Hiya,

Since I run censuses at different times of day, I'd like to know where my time could be best spent:

What I'd like to see is, the number of censuses taken by hour or period:

EG by period
----server------- ---morning ---- afternoon ---- night ---- total
EU-Dragonblight ------- 2 ------------ 10 ---------28 -------40
EU-Aggrammar --------0 ---------------1 ----------48 --------49
EU-Daggerspine -------28 --------------5----------9 ----------42

Or in more detail...
Server -------HR>--0-----1-----2-----3-----4-----5-----6-----7-----8-----9----10----11----12----13----14----15----16----17----18----19----20----21----22----23
EU-Alonsus--------11----15----5-----0-----0-----0-----0-----0-----0-----4----18----16----13----16----13----14----10----16----21----12----21----18----15----18
EU-Aman'Thul-------0-----0-----0-----0-----0-----0-----0-----0-----0-----0-----0-----0-----0-----0------0-----0------0-----0-----0-----0------0------1-----0-----0
EU-Ambossar-------0-----0-----0------0-----0-----0-----0-----0-----0-----0-----0-----0-----0-----0------0-----0------0-----0-----0------0------0------1-----0-----0
EU-Anachronos-----2-----1-----3-----5-----1-----0-----0-----0-----0------1------1-----4-----7-----5-----2-----3------2------1-----2-----0-----2-----2------1-----5


A csv file would be great so I can filter in excel etc

Hello Wynta!

I can't offer you a CSV file... but the data you are looking for is visible in each realm's page, just click on the link in the "Activity Ratio" and you will get to a page that will reveal the info you are after. Do note that if there are no submissions for one (or both) side(s), the link might not be there.

Hiya

Yep I can see it on each server hence me thinking it would be a relatively simple csv for rollie to make

problem is it either takes lot of time for me to check each of the 110 eu servers manually, or it puts load on the server for me to screen-grab 'automatically'

Either way it would be far easier to have one list from here so I could see which servers lack a census for 11am, say

OF course, if it's ok for me to screen-grab once a week, I'll do that now and if it's of interest I'll be happy to put the csv file somewhere - can't promise when it'll be updated tho

I suggest that you wait until you hear from Rollie. I am not familiar with the technique, so I am not aware how much strain the grapping would put on the server, which is why am suggesting erring on the side of caution for now.

I think you are right. However, I couldn't resist grabbing the High Population ones (since this is a shorter list)

Here are the EU ones for today (hopefully one can copy and paste into a csv file if this is useful).

One thing I've noticed is that the individual server activity pages don't seem to be updated at the same time as the general stats, so that's another reason why screen grabbing is not a good ongoing solution


ALLIANCE

ServerKnownAs,ServerLocation,ServerLanguage,WowStatus,Faction,AlliancePop,Hour-00,Hour-01,Hour-02,Hour-03,Hour-04,Hour-05,Hour-06,Hour-07,Hour-08,Hour-09,Hour-10,Hour-11,Hour-12,Hour-13,Hour-14,Hour-15,Hour-16,Hour-17,Hour-18,Hour-19,Hour-20,Hour-21,Hour-22,Hour-23
EU-Argent Dawn,EU,enGB,High,Alliance,24741,11,9,7,6,2,0,1,0,2,8,8,10,15,6,10,6,8,15,15,15,12,11,12,9
EU-Burning Blade,EU,enGB,High,Alliance,13527,8,3,2,1,1,0,33,15,14,7,16,9,27,10,6,11,28,28,21,29,32,26,20,14
EU-Darksorrow,EU,enGB,High,Alliance,6329,0,0,0,0,0,0,0,0,1,1,1,0,1,1,1,0,3,1,1,0,3,0,2,0
EU-Frostmane,EU,enGB,Full,Alliance,7181,0,0,0,1,0,0,0,0,0,0,1,1,1,1,0,0,1,1,1,0,0,1,1,2
EU-Kazzak,EU,enGB,High,Alliance,3497,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,0,1,0,0,0,0,0,1,1
EU-Khadgar,EU,enGB,High,Alliance,7151,1,0,1,0,0,2,0,0,0,0,1,2,0,0,1,0,1,1,1,1,4,1,1,1
EU-Mazrigos,EU,enGB,High,Alliance,11960,30,6,5,2,4,11,21,30,37,36,31,22,17,17,15,19,21,22,46,66,75,64,52,43
EU-Outland,EU,enGB,High,Alliance,9148,1,0,0,0,0,0,0,0,0,0,2,0,0,2,2,1,1,1,0,0,3,3,2,3
EU-Ravencrest,EU,enGB,High,Alliance,5563,0,0,0,0,0,0,0,0,1,0,0,1,0,2,0,0,1,1,0,0,1,1,0,0
EU-Silvermoon,EU,enGB,High,Alliance,27023,4,3,2,2,0,0,0,1,2,2,2,4,7,8,6,6,8,5,6,5,6,4,2,1
EU-Stormscale,EU,enGB,High,Alliance,1324,0,0,0,0,0,0,0,0,0,0,2,1,0,0,2,0,0,0,1,0,1,0,0,0
EU-Sylvanas,EU,enGB,High,Alliance,8358,0,0,0,0,0,0,0,0,0,0,1,5,2,2,2,0,0,0,2,4,3,4,3,0
EU-Twilight's Hammer,EU,enGB,High,Alliance,2088,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,1,1,0,0,1,1,0,0,0
EU-Aegwynn,EU,DE,High,Alliance,2385,0,0,0,0,1,0,0,0,0,1,2,0,1,0,0,1,0,0,0,1,0,0,0,0
EU-Archimonde,EU,FR,High,Alliance,5192,4,2,0,1,0,0,2,0,0,0,0,1,0,0,0,0,0,3,4,0,0,0,1,0
EU-Blackrock,EU,DE,High,Alliance,8448,6,7,4,2,2,0,0,0,1,3,7,6,4,1,0,0,0,0,1,3,5,9,8,11
EU-Dalaran,EU,FR,High,Alliance,6750,0,1,0,0,0,0,0,0,1,0,0,0,0,0,2,2,0,0,1,0,1,3,0,1
EU-Dun Morogh,EU,DE,High,Alliance,17648,11,7,1,1,3,0,4,9,53,77,12,5,3,7,22,17,13,6,9,26,26,22,33,20
EU-Frostwolf,EU,DE,High,Alliance,7986,8,1,0,0,0,0,0,0,4,5,11,7,1,4,6,3,2,4,8,8,7,8,11,12
EU-Tichondrius,EU,DE,High,Alliance,11476,5,0,0,0,0,0,0,0,2,8,17,9,12,17,21,16,19,15,17,26,23,25,25,13


HORDE

ServerKnownAs,ServerLocation,ServerLanguage,WowStatus,Faction,HordePop,Hour-00,Hour-01,Hour-02,Hour-03,Hour-04,Hour-05,Hour-06,Hour-07,Hour-08,Hour-09,Hour-10,Hour-11,Hour-12,Hour-13,Hour-14,Hour-15,Hour-16,Hour-17,Hour-18,Hour-19,Hour-20,Hour-21,Hour-22,Hour-23
EU-Argent Dawn,EU,enGB,High,Horde,11784,3,3,3,2,2,0,1,0,2,2,4,4,8,7,2,4,1,5,5,8,4,1,1,7
EU-Burning Blade,EU,enGB,High,Horde,2766,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,1,2,1,0,1,2,0,0,0
EU-Darksorrow,EU,enGB,High,Horde,6042,0,0,0,0,0,0,0,0,1,1,1,0,1,1,1,2,1,1,1,0,3,0,2,0
EU-Frostmane,EU,enGB,Full,Horde,4739,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,0,1,1,0,1,1,1,0
EU-Kazzak,EU,enGB,High,Horde,8538,1,1,0,0,0,0,0,0,0,0,0,1,2,1,0,0,0,0,2,0,0,1,2,2
EU-Khadgar,EU,enGB,High,Horde,1738,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0
EU-Mazrigos,EU,enGB,High,Horde,8898,1,0,4,1,1,0,1,1,0,0,2,0,1,3,2,4,3,3,9,6,2,3,4,4
EU-Outland,EU,enGB,High,Horde,12488,0,1,0,0,0,0,0,0,0,1,4,3,4,3,6,5,2,8,2,2,3,6,4,8
EU-Ravencrest,EU,enGB,High,Horde,3926,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,2,2,0,0,0
EU-Silvermoon,EU,enGB,High,Horde,2780,22,14,1,1,0,1,1,0,0,3,7,9,12,21,16,19,23,20,26,31,29,28,27,31
EU-Stormscale,EU,enGB,High,Horde,3617,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,1,0,0,0,0,0,0
EU-Sylvanas,EU,enGB,High,Horde,2956,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,1,1,0,1,0,0,0
EU-Twilight's Hammer,EU,enGB,High,Horde,1554,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0
EU-Aegwynn,EU,DE,High,Horde,3448,3,1,0,0,0,0,0,0,2,2,2,2,5,3,2,2,0,1,2,1,2,2,1,2
EU-Archimonde,EU,FR,High,Horde,8989,0,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,2,6,0,1,0,1,0
EU-Blackrock,EU,DE,High,Horde,9172,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,4,3,2,1,1,3,0
EU-Dalaran,EU,FR,High,Horde,2757,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,0,1,0,1,0,1
EU-Dun Morogh,EU,DE,High,Horde,10797,23,10,4,0,0,0,1,1,20,108,56,41,31,16,16,21,21,21,16,34,60,42,38,39
EU-Frostwolf,EU,DE,High,Horde,10079,0,0,0,1,0,0,0,0,0,2,2,3,0,3,6,0,2,1,1,1,1,2,0,0
EU-Tichondrius,EU,DE,High,Horde,4309,3,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,6,6,5,5,5



(oops, first paste had wrong data, hope no one saw )

Hmm I'm suddenly not hopeful about this being taken up - I can't see any sign of Rollie on here since the start of June, and his lvl 80 char hasn't been played since July 20th.

http://www.wowarmory.com/character-shee ... h&n=Bizzam

Hope it's just a summer holiday rather than anything serious!

This domain name expires 25-Nov-10, so hopefully he (you, Rollie, if you're reading this ) will be back before then!

I think this site is incredibly useful to players and I can't believe it's without commercial value, at least enough to support its hosting and Rollie's time; so I don't mean to sound all despairing

Wynta wrote:Hmm I'm suddenly not hopeful about this being taken up - I can't see any sign of Rollie on here since the start of June, and his lvl 80 char hasn't been played since July 20th.

http://www.wowarmory.com/character-shee ... h&n=Bizzam

Hope it's just a summer holiday rather than anything serious!

This domain name expires 25-Nov-10, so hopefully he (you, Rollie, if you're reading this ) will be back before then!

I think this site is incredibly useful to players and I can't believe it's without commercial value, at least enough to support its hosting and Rollie's time; so I don't mean to sound all despairing

I too hope it's just a holiday, the bars on the realm pages haven't worked for a while.