Forumers statistics

[Carlos Fernandez Riera]

Based on list provided by Paula on http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x6ae8ff77de2bd611abd50090277a778c,00.html
i have added country for the 50 first.

28 /50 USA
6 / 50 UK
5 / 50 GERMANY
....

36 / 50 English native speakers...

Attached excel file.
___

If anyone would like continue ....

[Justo Exposito]

Hi Carlos,

It's interesting, but I can't open the file.

Regards,

Justo.

[Carlos Fernandez Riera]

Trying again...

[Carlos Fernandez Riera]

txt...

[Justo Exposito]

Hi Carlos,

I can open the text version but not the excel version.

Thanks a lot,

Justo.

[John Bolene]

Thanks Carlos and all who made up this list.

[Mark Vollmers]

Cool. I was surprised by how few people have hats (or rather, how high up on the list you are if you have one), but I guess it makes sense. Kinda neat to see it all laid out. Thanks!

Mark

[Paula J Frazer-Campbell]

Hi

Whilst I am not anti Americian,

I am not from the USA Y'all.

Good ol' Blighty ---- Whatho..


Paula

[Jeff Schussele]

Carlos,

Pretty cool...but data appears several days old.
Any chance of getting regular updates on this?

Rgds,
Jeff

[Paula J Frazer-Campbell]

Hi

Wodisch did the initial extract.

Paula

[Wodisch]

Hi all,

nice work, Carlos!

I try do this on a monthly base in Dan's monthly-thread, but due to problems with the 'j' members page for a couple of weeks I am running late on this :-(

It is not very sophisticated:
- download the member pages (wget)
- AWK out the names, ids, and points
- sort and map to hats (AWK again)

But the extracting the country would need to download the individual member's page - and with all the problems the forums-server has had with spiders/crawlers/bots and such in the recent months I would not like to do this too often...
Though, doing it for the "top 50 piranhas" (Harry or Michael call us that way, IIRC :-) would perhaps NOT hurt so much.

Regards,
Wodisch (hah, back in germany - the first beer after 4 weeks of arabia tasted really good!

[Carlos Fernandez Riera]

Hi all:

I am very glad you like this small statistics... ( maybe on Friday will be update to 100th).


I am sorry Paula, i know you are from UK ( if i donk make any typo, dont feel myself), in next release will patched.


But statistics are for get ideas, and this is the aim of this... What are your thinks about..?

Also, I never aim just one thing when i can aim two... ( i'm sure it is very easy to Dan or others forums admins, and of course very cheaper - in time-).

[H.Merijn Brand (procura]

I'm sure I asked somewhere else, but how big would the bzipped version be of an archive of the downloaded profiles? HP complained that if all of us were to wget the profiles the forum would slow down, but if someone already fetched those, and made the .tbz or .tgz available, I could try to make a perl script to analyze the profiles.

[Sachin Patel]

Hi Carlos,
Great, no word for it.

Sachin

[Steven Sim Kok Leong]

Hi Carlos,

This is interesting :-) Good effort!

Frankly, I always wanted to know the % of active forumers in each country. For me, would be interesting to know how many active forumers are there in Singapore, apart for me and Animesh.

Regards.

Steven Sim Kok Leong

[Carlos Fernandez Riera]

UPDATED to 100!!!

And more statistics..



Contar AUSTRALIA 1
Contar BELGIUM 4
Contar CANADA 2
Contar FRANCE 1
Contar GERMANY 9
Contar INDIA 1
Contar ISRAEL 1
Contar ITALY 2
Contar KOREA 1
Contar LITHUANIA 1
Contar MALAYSIA 1
Contar MALTA 1
Contar NETHERLANDS 3
Contar NORWAY 1
Contar POLAND 1
Contar PORTUGAL 1
Contar RUSSIA 1
Contar SINGAPORE 2
Contar SOUTH_AFRICA 2
Contar SPAIN 3
Contar SWITZERLAND 3
Contar UK 10
Contar USA 48
TOTAL 100

[H.Merijn Brand (procura]

Carlos, can you put the profiles on line in a tgz?

[H.Merijn Brand (procura]

Well, it's the temptation again, I could not resist.

It's still fetching, I've got 587 member profiles so far.

Attached is the perl script that analyzes and summarizes the profiles and a list of the first 587 members I got.

For the country list, it yields for these 587:

149 UK
97 GERMANY
65 NETHERLANDS
30 FRANCE
26 SPAIN
24 USA
18 BELGIUM
16 DENMARK
16 SWEDEN
14 ITALY
13 IRELAND
13 SWITZERLAND
11 POLAND
10 SOUTH_AFRICA
8 AUSTRIA
6 ISRAEL
6 PORTUGAL
6 RUSSIA
5 HUNGARY
4 GREECE
4 INDIA
4 TURKEY
3 BRAZIL
3 BULGARIA
3 CZECH_REPUBLIC
3 LATVIA
3 NORWAY
3 SLOVENIA
2 AUSTRALIA
2 CHINA
2 FINLAND
2 LUXEMBOURG
2 MALTA
2 MOROCCO
2 UAE
1 BELARUS
1 CANADA
1 CROATIA
1 HONG_KONG
1 ICELAND
1 INDONESIA
1 LITHUANIA
1 ROMANIA
1 SAUDI_ARABIA
1 VENEZUELA

[Steven Sim Kok Leong]

Hi Procura,

Thanks for the efforts!

Btw, I wonder if my eyes are playing tricks with me, but I don't see Singapore in your country breakdown?

Regards.

Steven Sim Kok Leong

[Steven Sim Kok Leong]

Hi,

Oh, you are getting the _first_ (by sequence) 500+ member pages, not the _top_ (by scores) 500+ member pages. I have mistaken in that case.

Steven Sim Kok Leong

[Michael Tully]

Hi,

Just to set the record straight, the initial inclusion of the word "piranhas" was introduced by Paul Courry. It looks as though Harry and I may have used it before we first appeared in the Top 25 list.

There's the history lesson for the day....

Cheers
~Michael~

[Alexander M. Ermes]

Hi there.
Interesting statistics.
Good job. This is really giving a picture of the situation.
Thanks for this.
Rgds
Alexander M. Ermes

[Carlos Fernandez Riera]

As i said, stats are for get many ideas...

1- Yes... it seem this river is plenty of 'piranhas'... 2/3 of points are for 100th firsts forumers.

2- All ( almost all) people form India is working at USA...( Some of that names sounds to me not being from Spain, neither Germany ..).

3- USA time is the MFT ( Main Forum Time)

4- 20000 Points are lots of points, but... it is less than 5% of all...

5- Data from Procura.. It shows better the distribution of forumers along the world. Also it shows that there are to few people from USA that begin with A (expect A. Clay, of course).

And so on...
____

Procura... Attached file is what you want.

Dan... You can delete it if you find it no-politicaly-correct.

[Justo Exposito]

Hi all,

I think that the information is not political correct or not. It depends the use of that.

It's interesting to know how is distributed the people and the use of the forum that the people do.

I think that is normal that there are more people asking that answering, perhaps in this case there are a great difference.

Great work Carlos and all,

Best Regards,

Justo.

[H.Merijn Brand (procura]

Carlos, I cannot do anything useful with the attached zip. Neither Powerarchiver, not unzip can read.

a5:/data 106 > unzip itrc
Archive: itrc.zip
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.
note: itrc.zip may be a plain executable, not an archive
unzip: cannot find zipfile directory in one of itrc or
itrc.zip, and cannot find itrc.ZIP, period.
a5:/data 107 >

I've attached the latest list for over 3500 profiles, but I am missing some ID's easy to spot in the top ten

How can I get a list of all ID's. Attached text file is OK.