LITTLEBLACKDOG.COM

Butt Sniffer Joined: 13 Jan 2002 Posts: 1168 Location: USA

Yet again… The Folded Paper
We are still in 46th place, but looks like we’re gonna pass 3 teams on Wednesday the 22nd (see below)

We had 1 new person (Welcome SeanOhara) and 34 active members out of our 82 total members, so we turned in 433 WU's for a score of 4540.12 !!

Top producers:
1. Bathomps with 937.8 pts
2. sspies with 435.08 pts
3. Klingenthal with 353.68 pts
4. Jamz with 258.94 pts
5. Blahpony with 229.75 pts

Movers and shakers:
Klingenthal passed 2 people for 2nd
sspiess passed Code_Mokney for 12th
Medic99 passed Rcowski for 17th
CaptMorgan passed 5 people for 23rd
Heatmizr66 passed 3 people for 36th
Crater passed RED1944 for 43rd
Anub|s passed blahponey for 51st
SeanOhara joined us at 82nd

Comments:
More Team movement stats:

Code: Select all

   


Name           Start           Weekly   Intersect   Day to Catch (or be caught)


 LITTLEWHITEDOG   62608.08   5168.59      Monday, January 20, 2003


 RagingBull   63889.22   2153.94     3   Wednesday, January 22, 2003


 Modeemi   63834.88   1474.77     2   Wednesday, January 22, 2003


 Team MacNN   66505.64   3714.36     19   Friday, February 07, 2003


 Hotmail   64456.36   546.72     3   Wednesday, January 22, 2003


 Alien Soup   67394.64   1985.16     11   Thursday, January 30, 2003


 Team Macphilez   75651.25   2224.24     31   Thursday, February 20, 2003


 Macrumors.com   78833.34   4658.87     223   Saturday, August 30, 2003


 AthlonXP   80460.17   6483.96     No   Not at this pace...


 OcUK           76777.94   1917.31     31   Wednesday, February 19, 2003


 Tweak-AU   84027.78   4784.74     391   Saturday, February 14, 2004


U of Alabama   84231.61   4229.4     161   Monday, June 30, 2003


 StorageForum   88163.75   5189.57     No   Not at this pace...


 Hong Kong Team   91290.41   5132.9     5626   Friday, June 15, 2018


 Team Alberta   91745.43   3459.57     119   Monday, May 19, 2003


 -----------------------Teams of Note behind us-----------------------


Russia           57795.33   4914.68     No   Passed already...


[b] Team PimpRig   57757.85   5318.12     227   Thursday, September 04, 2003[/b]

Toast

Adding a doggie to the kennel in

posts

EEps · Posted: Mon Jan 20, 2003 1:43 am Post subject:

Now that my comps are back in order again, Team PimpRig isn't going to come close to us at all...

Posted: Mon Jan 20, 2003 4:27 am Post subject:

And, I will be bringing more boxes online with F@H, so we should be overtaking MacNN sooner, rather than later..

Posted: Mon Jan 20, 2003 5:01 am Post subject:

Quote:
Code: Select all
[u][b]Name Start Weekly Inter§ Day to Catch (or be caught)[/b][/u] LITTLEWHITEDOG 62,608.08 5,168.59 01/20/2003 RagingBull 63,889.22 2,153.94 3 01/22/2003 Modeemi 63,834.88 1,474.77 2 01/22/2003 Team MacNN 66,505.64 3,714.36 19 02/07/2003 Hotmail 64,456.36 546.72 3 01/22/2003 Alien Soup 67,394.64 1,985.16 11 01/30/2003 Team Macphilez 75,651.25 2,224.24 31 02/20/2003 Macrumors.com 78,833.34 4,658.87 223 08/30/2003 AthlonXP 80,460.17 6,483.96 No Not at this pace... OcUK 76,777.94 1,917.31 31 02/19/2003 Tweak-AU 84,027.78 4,784.74 391 02/14/2004 U of Alabama 84,231.61 4,229.40 161 06/30/2003 StorageForum 88,163.75 5,189.57 No Not at this pace... Hong Kong Team 91,290.41 5,132.90 5,626 06/15/2018 Team Alberta 91,745.43 3,459.57 119 05/19/2003 -----------------------Teams of Note behind us----------------------- Russia 57,795.33 4,914.68 No Passed already... Team PimpRig 57,757.85 5,318.12 227 09/04/2003

S-s-s-sorry...Ever since BamZipPow showed me how to do that, I can't stop

There's too much coffee in my coffee Blush Smile

EEps · Posted: Mon Jan 20, 2003 11:37 am Post subject:

Quote:

S-s-s-sorry...Ever since BamZipPow showed me how to do that, I can't stop

There's too much coffee in my coffee [:I]

TM

First they ignore you, then they laugh at you,
then they fight you, then you win.

Heeheee... Wait till I show you more stuff!! Looks like I'll get to reel EEH72 back in and take over his spot...maybe within 2 or 3 weeks!

Posted: Mon Jan 20, 2003 11:51 am Post subject:

Lookin good there Toast.

Butt Sniffer Joined: 13 Jan 2002 Posts: 1168 Location: USA

I suppose i could have edited the cell formats to include commas, and change the date displays, but if you note the time I posted, it was awful late last nigth, and i didnt think of it.

If you'ld prefer I'll change it to include commas, and if anyone would like some other stats, I'm kinda having fun playing with Excel doing this...

(anyone know how to do auto modifications to compare rankings?) It takes a lot of work to adjust all the formulas by hand when someone joins or passes someone...?

Maybe have a separate column titled (if this person moved up one/ down one?)
And a method of automatically populating the fields w/ data would be good, maybe a macro? (I've never messed w/ macro's but i'm willing to learn)

Toast

Adding a doggie to the kennel in

posts

Posted: Mon Jan 20, 2003 12:55 pm Post subject:

Quote:
(anyone know how to do auto modifications to compare rankings?) It takes a lot of work to adjust all the formulas by hand when someone joins or passes someone...?

! If it's an Excel spreadsheet, you can do an alpha sort (two separate tables independently), then you only have to deal with joins, which is considerably less often than those moving up/down in rank. Write a formula to compare names from one table to the other, e.g.,

=IF(A2=J2,0,999)

to make finding them faster. You then insert a row for each new member, and move everyone in that table up a row. Once they're all lined up, re-sort by current ranking as a single table.

Stray Dog Joined: 13 Jan 2003 Posts: 19

Making everything run perfectly without constant manual editing is rough. You can probably cover much of it with Excel, but there will always be something. We use a php-mysql backend, and it does run unattended on the server.

But it takes 8,600 lines of backend processing code to do that, and a very few things can still mess it up. If the page output code is thrown in, that adds another 10,000 lines.

Welcome to the stats game, Toast. Be a little careful, it is all too easy to get in over your head. Next thing you know, you no longer have any free time, and work on nothing but stats. My stats have eaten over a thousand hours of my free time over the past year, and I hate to think of how much money I could have made during that time. Have not watched anything on the TV in months.

Your tables are very decent for spreadsheet stats, I started there too. Welcome again, and good luck.

Edited by - reader50 on 01/20/2003 16:13:41

Posted: Mon Jan 20, 2003 1:33 pm Post subject:

Welcome to the pound, reader50!

Butt Sniffer Joined: 13 Jan 2002 Posts: 1168 Location: USA

My current system involves me copy/pasting the team stats page from Stanford into an Excel SS.

this has 2 areas (old stats and new stats) then to the right i have a logical check to see if the name is the same in both places in line. If not, then it tells me "Changed" and it brings my attention to that area, for manual adjustments... When someone changes position I have to adjust their formula to F3-F4 if they moved up in order to have the numbers to come out right.

Also have a simple F3-B3 sort of function to see what change in score has occured, (this is actually 2 lines, one for WU's, the other is for points)

I also have another logical check to see if the person has been active, with a SUM function to give me a total number of active members. (I also have SUM's set to show me team totals for WU's, and Points)

Reader50, thanks for the words of warning.
TOM, I'm not sure i understand your suggestion [???]

Toast

Adding a doggie to the kennel in

posts

Posted: Mon Jan 20, 2003 3:45 pm Post subject:

Quote:
TOM, I'm not sure i understand your suggestion [???]

I've done it so many times, I may *forget* to mention a step...If you sort both old and new tables separately by Dog name, they will line up on the same row with very little effort. Then you don't change any formulas, as long as a cruncher is always on the same row. Then re-sort the 2 tables together by ascending Current Rank (or descending Total Score, same diff)

Code: Select all

Sort->    (A)               (B)


Sort->                  (C)


|--------- Old Table ---------|   |--------- New Table --------|   Rnk


[u]Rank   User   Score     WU[/u]   [u]Rank     User   Score     WU   Chg[/u]


47   Dog1   35     12   45    Dog1   46    16    +2


46   Dog2   37     14   46    Dog2   43    16     -


45   Dog3   38     14   47    Dog3   40    15    (2)


55   Dog4   31     10   48    Dog4   34    15    +7


..   ...    -     0   49    Dog5   32    13   *NEW*

What you're doing, essentially, is joining 2 relational databases, and inserting rows for records that didn't exist in the old table.

In the Monthly Bath, it cut my time gathering stats from 3 hours down to less than ½ hour (typically with more than 30 new members in a month). In the Gauntlet race, it cut the time from an hour gathering down to few minutes - Wink Smile

Butt Sniffer Joined: 13 Jan 2002 Posts: 1168 Location: USA

Ok, so you're saying have 2 separate spread sheets, and sort by name, so they will be in alphabetical order, then do a check to see if the rank is the same or not?

could do a simple function to show the change in position... and simply add a blank line for noobs... I think i got it...

Gonna start playing again now...

I'm very receptive to any suggestions (I may not understand, but I'll ask...)

BTW, think this'd be a good stat to add: Pts/Day? I think it'd be interesting....

Toast

Adding a doggie to the kennel in

posts