Damn Roncli, you're on a roll...

kfx · Post by **kfx** » Sat Jul 20, 2002 6:43 pm

So, Barry I would volunteer to do the counting for you if you like.

Sounds great, I love statisticks. The last counted month is november 2001.

roncli · Post by **roncli** » Sat Jul 20, 2002 6:53 pm

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?

427? That's IT?

Hold on...

Frankie · Post by **Frankie** » Sat Jul 20, 2002 7:08 pm

I Just did a manually count, and still got it to 427.

Post by **mahlemiut** » Sat Jul 20, 2002 8:14 pm

Frankie wrote:So, Barry I would volunteer to do the counting for you if you like?

Sure, if you want to. Saves me some time to do some coding.

Frankie · Post by **Frankie** » 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.

Chad · Post by **Chad** » 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

Post by **mahlemiut** » 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.

Kale · Post by **Kale** » Fri Jul 26, 2002 8:28 pm

Here are the sheets for confirm counts updated for june 2002,hoping that you like this...

kfx · Post by **kfx** » 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.

Kale · Post by **Kale** » 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...

kfx · Post by **kfx** » Fri Aug 02, 2002 7:31 pm

How do you copy the information from the confirms page into Excel?

Kale · Post by **Kale** » Sat Aug 03, 2002 1:46 pm

kfx wrote:How do you copy the information from the confirms page into Excel?

There are two ways(if you are using IE):
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

kfx · Post by **kfx** » 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.

Kale · Post by **Kale** » Sat Aug 03, 2002 7:09 pm

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.

It's "columns" like the Sega game;
Probably you should see your IE properties and/or upgrade to IE 6.0

DRN · Post by **DRN** » 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.