Posted: Sat Jul 20, 2002 6:43 pm
Sounds great, I love statisticks. The last counted month is november 2001.So, Barry I would volunteer to do the counting for you if you like.
Page 2 of 3
Posted: Sat Jul 20, 2002 6:53 pm
427? That's IT?Frankie wrote:Without checking for double confirms it seems that Roncli have confirmed 427 recordings so far this month.
Roncli, do you have a life?
Hold on...
Posted: Sat Jul 20, 2002 7:08 pm
I Just did a manually count, and still got it to 427.
Posted: Sat Jul 20, 2002 8:14 pm
Sure, if you want to. Saves me some time to do some coding.Frankie wrote:So, Barry I would volunteer to do the counting for you if you like?
Posted: Sat Jul 20, 2002 9:26 pm
Allright, I'll mail you when I'm done.
BTW, October and November 2001 are counted and could be included to the stats.
BTW, October and November 2001 are counted and could be included to the stats.
Posted: Sat Jul 20, 2002 11:31 pm
who needs spread sheets and manual counting. unix is cool: for the year 2002
$ for a in 1 2 3 4 5 6 ; do echo MONTH 0$a ; cut -f2 -d'(' 0${a}2002.txt |cut -f1 -d')'|sort|uniq -c|sort -rn ; done
MONTH 01
171 br
50 ceh
37 plf
37 bbh
29 wfra
27 ant
14 ztt
10 phl
6 wpc
4 tjt
3 kal
2 jdl
1 zy
1 taz
1 rsm
1 pky
1 mlh
1 kid
1 jvl
1 jg
1 cb
1 bjw
MONTH 02
163 br
71 plf
40 wfra
35 ceh
23 bbh
20 rsm
19 ztt
12 tjt
10 ant
6 tjm
6 phl
3 kal
3 cmp
2 jvl
2 jdl
1 wpc
1 taz
1 qrs
1 pat
1 max
MONTH 03
131 br
49 ztt
48 bbh
28 ceh
22 plf
17 kal
16 phl
11 ant
7 rsm
6 ozz
2 wpc
2 qrs
2 jg
2 jdl
2 cb
1 tjm
1 mlh
1 jvl
1 dr
1 dmj
MONTH 04
145 br
79 plf
67 ztt
46 ceh
35 ant
26 rsm
17 bbh
15 kal
10 jvl
7 phl
5 qrs
5 db
3 tjm
3 cb
2 wpc
1 jg
1 jdl
1 al
MONTH 05
117 br
95 ceh
89 plf
66 ztt
64 ant
22 phl
15 lcf
15 bbh
10 kal
9 qrs
5 wpc
3 rsm
3 jvl
2 pky
2 gf
1 zy
1 tjm
1 ra
1 oak
1 mlh
1 max
1 jg
1 dmj
1 db
1 cb
MONTH 06
94 kfx
79 br
76 ceh
70 ztt
68 plf
45 lcf
29 phl
20 wpc
18 bbh
13 qrs
6 ra
6 jvl
6 ant
3 mlh
2 tjt
2 pky
2 kal
1 tjm
1 rsm
1 jdl
1 cb
$ for a in 1 2 3 4 5 6 ; do echo MONTH 0$a ; cut -f2 -d'(' 0${a}2002.txt |cut -f1 -d')'|sort|uniq -c|sort -rn ; done
MONTH 01
171 br
50 ceh
37 plf
37 bbh
29 wfra
27 ant
14 ztt
10 phl
6 wpc
4 tjt
3 kal
2 jdl
1 zy
1 taz
1 rsm
1 pky
1 mlh
1 kid
1 jvl
1 jg
1 cb
1 bjw
MONTH 02
163 br
71 plf
40 wfra
35 ceh
23 bbh
20 rsm
19 ztt
12 tjt
10 ant
6 tjm
6 phl
3 kal
3 cmp
2 jvl
2 jdl
1 wpc
1 taz
1 qrs
1 pat
1 max
MONTH 03
131 br
49 ztt
48 bbh
28 ceh
22 plf
17 kal
16 phl
11 ant
7 rsm
6 ozz
2 wpc
2 qrs
2 jg
2 jdl
2 cb
1 tjm
1 mlh
1 jvl
1 dr
1 dmj
MONTH 04
145 br
79 plf
67 ztt
46 ceh
35 ant
26 rsm
17 bbh
15 kal
10 jvl
7 phl
5 qrs
5 db
3 tjm
3 cb
2 wpc
1 jg
1 jdl
1 al
MONTH 05
117 br
95 ceh
89 plf
66 ztt
64 ant
22 phl
15 lcf
15 bbh
10 kal
9 qrs
5 wpc
3 rsm
3 jvl
2 pky
2 gf
1 zy
1 tjm
1 ra
1 oak
1 mlh
1 max
1 jg
1 dmj
1 db
1 cb
MONTH 06
94 kfx
79 br
76 ceh
70 ztt
68 plf
45 lcf
29 phl
20 wpc
18 bbh
13 qrs
6 ra
6 jvl
6 ant
3 mlh
2 tjt
2 pky
2 kal
1 tjm
1 rsm
1 jdl
1 cb
Posted: Sun Jul 21, 2002 12:14 am
I've updated the Dec 2001 and Jan 2002 confirm logs based on what Frankie sent me. Now I guess I have to update the other months too now. Thanks, Skito. I think. 
EDIT: Done that now. Finally.
EDIT: Done that now. Finally.
Posted: Fri Jul 26, 2002 8:28 pm
Here are the sheets for confirm counts updated for june 2002,hoping that you like this...
Posted: Fri Jul 26, 2002 9:01 pm
How did you get the confirms into the sheet? I have been trying to do it, but it always turns into rubbish.
Posted: Fri Aug 02, 2002 6:56 pm
Do you mean the sheet_total.xls in the zip file?Sorry,it wasn't the right one.Here's the right one,updated for July...
Posted: Fri Aug 02, 2002 7:31 pm
How do you copy the information from the confirms page into Excel?
Posted: Sat Aug 03, 2002 1:46 pm
There are two ways(if you are using IE):kfx wrote:How do you copy the information from the confirms page into Excel?
A:Use "Open in another window" on the pages,and save them using the regular "save as"
B:Open the page and use "edit with Microsoft Excel",then "save as" with it
Posted: Sat Aug 03, 2002 2:00 pm
OK, if i use a and save it as a html document, and then I open it with Excel, it still is messy, how do you get the colums (not sure if it´s spelled right) right like A, B and C and so on.?
I can not use option B, the only programe I cen edit with is Frontpage.
I can not use option B, the only programe I cen edit with is Frontpage.
Posted: Sat Aug 03, 2002 7:09 pm
It's "columns" like the Sega game;kfx wrote:OK, if i use a and save it as a html document, and then I open it with Excel, it still is messy, how do you get the colums (not sure if it´s spelled right) right like A, B and C and so on.?
I can not use option B, the only programe I cen edit with is Frontpage.
Probably you should see your IE properties and/or upgrade to IE 6.0
Posted: Sat Aug 03, 2002 10:11 pm
This might sound a bit obvious but have you tried just copying and pasting it straight into Excel? Then you just have to adjust the size of the columns and that's it.