|
Post by Gawayn on Apr 16, 2012 10:17:44 GMT -5
Oooh, that's a good idea, Dees!
Let me see if I can get some prizes together for who'd help the most. I'll also see if I can get more than 15 posts a page or get all the info together somehow. Would you be willing to be Master of the Excel for this? That way, we can send in our results to you to compile? I think I'll just start in on this and post results as I go. Maybe others will jump in as we go along.
Good idea about the cutoff, too!
|
|
|
Post by deesloop on Aug 31, 2012 15:07:31 GMT -5
Oh dear I totally forgot about this. I'm still happy to do this. I am quite happy to throw something together in excel. It would be very helpful to get this in a more usable format however
I'll spend a couple of hours on it just now
*edit* One hour goes by and all 758 pages are downloaded. Now to figure out the format of this forum! Man this is hammering my CPU - my legs are burning with this laptop!!!
*edit* 2 hours go by - Cpu at 80% for the last 90 minutes i've got it into a spreadsheet now. 22,700 rows One with the user name and the one below it with their comment.
*edit* 2.5 hours go by
Ive hit a snag however in that I can get this to work if people use the correct name.
I know however Dragon_Stalker is often referred to as D_S And I've been called dees and other things so I'll need little time to think on this.
So much for a simple excel file...
|
|
|
Post by deesloop on Sept 4, 2012 5:32:56 GMT -5
Hmm. Tricky, tricky I was relying on the word hit or miss but thats no use as it's not always used. I cant use a search for text as folk have used multiple names for a person. I dont think doing it in excel is going to be the answer - too much fuzzy logic required for my skills. I'll plod away at it, but don't know if I'm going to come up with the goods. Maybe a lookup based on an array is the answer but 22000 posts means quite easy to miss a combination out. Harrrummppph!
|
|
|
Post by Dragon_Stalker on Sept 4, 2012 8:56:35 GMT -5
Suggestion: We should break up game winners by ERA! Each year can be a new winner ;D This way you can see who was most active in this thread each year, and reward someone different each time (probably) by giving them an everlasting, revered title "Best Guesser of 20XX!"
We can assign years: -Dragon_Stalker (2006) -
|
|
|
Post by deesloop on Sept 4, 2012 11:00:27 GMT -5
Alas I have stripped out all the unnecessary data from the spreadsheet. Dates included.
Sorry folks, but I think this is too big a job for me. I'm pretty handy with excel but there are just too many variables for me and I probably need a faster computer to do it on.
My lappy is suffering greatly.
If anyone's interested in having the file to have a go themselves send me a PM with your email address and I'll send it out.
*edit* I've got it to search for the correct name or the word hit or yes and count them, but it's still not really that close.
|
|