Census checks by hour/time of day.

Suggestions for WarcraftRealms.com
Post Reply
Wynta
Posts: 23
Joined: Sun Dec 02, 2007 6:49 am
Location: UK

Census checks by hour/time of day.

Post by Wynta »

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 :)

1974ER
Epic Censi
Posts: 761
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

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.

Wynta
Posts: 23
Joined: Sun Dec 02, 2007 6:49 am
Location: UK

Post by Wynta »

Hiya :D

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 :)

Wynta
Posts: 23
Joined: Sun Dec 02, 2007 6:49 am
Location: UK

Post by Wynta »

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 ;)

1974ER
Epic Censi
Posts: 761
Joined: Fri Nov 07, 2008 3:30 am

Post by 1974ER »

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. :)

Wynta
Posts: 23
Joined: Sun Dec 02, 2007 6:49 am
Location: UK

Post by Wynta »

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 ;) )

Wynta
Posts: 23
Joined: Sun Dec 02, 2007 6:49 am
Location: UK

Post by Wynta »

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 :)

Kaptain
Posts: 7
Joined: Sun Feb 08, 2009 11:32 am

Post by Kaptain »

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.

Post Reply