Crunching Stats Calculator

Okay, try this then;

Hope you don't think I'm thread spamming :lol:

Code: 
[SIZE=2][B]

               [size=4][color=#6698ff][U]WCG Daily Team Stats - The PC Review Crew II[/U][/color][/size]

[url=http://www.worldcommunitygrid.org/team/viewTeamInfo.do?teamId=3CJW57FQP1]WCG PC Review Team Stats - copy/paste URL may be required due to url length[/url]

[U]Milestones for the day:[/U][color=#f87a17]
Ian Cunningham: 1 Thousand Results
[/color]

[U]Today's stats for[/U][color=00800]
Sunday 29 October 2006 [/color]
         [I][/I][I][/I]                        New      New | [I][/I][I][/I]     Total  [I][/I][I][/I]    Total   |       CPU Time
 +/-  #  [I][/I][I][/I] Member Name         Points  Results | [I][/I][I][/I]    Points  [I][/I][I][/I]  Results   |      Yr:Day:Hr
 === ====[I][/I][I][/I] ===============    =======  ======= | [I][/I][I][/I] =========  [I][/I][I][/I]=========   |     ==========
 --  1   [color=#000000] Adywebb          [/color]    1,675       14 | [I][/I][I][/I] 3,224,195  [I][/I][I][/I]    7,991   |       5:005:17
 --  2   [color=#000000] Chris_Postill    [/color]    3,440        8 | [I][/I][I][/I] 1,337,228  [I][/I][I][/I]    4,234   |       3:107:06
(+1) 3   [color=#008000] TriplexDread     [/color]    7,553       16 | [I][/I][I][/I]   976,483  [I][/I][I][/I]    2,667   |       1:212:09
(-1) 4   [color=#f63817] chelseafc2005    [/color]    1,914        4 | [I][/I][I][/I]   972,252  [I][/I][I][/I]    2,237   |       1:109:07
 --  5   [color=#000000] muckshifter      [/color]    2,028        8 | [I][/I][I][/I]   812,219  [I][/I][I][/I]    3,359   |       1:226:01
 --  6   [color=#000000] CITech           [/color]        0        0 | [I][/I][I][/I]   807,878  [I][/I][I][/I]    2,164   |       1:041:18
 --  7   [color=#000000] V_R              [/color]    6,846       13 | [I][/I][I][/I]   785,923  [I][/I][I][/I]    1,896   |       1:168:10
 --  8   [color=#000000] Harvey           [/color]    5,466       14 | [I][/I][I][/I]   759,892  [I][/I][I][/I]    2,272   |       1:092:13
 --  9   [color=#000000] pikakilla        [/color]    3,307        8 | [I][/I][I][/I]   636,537  [I][/I][I][/I]    1,656   |       0:325:16
 --  10  [color=#000000] cImrie           [/color]    9,885       47 | [I][/I][I][/I]   536,529  [I][/I][I][/I]    1,902   |       2:286:12
---------[I][/I][I][/I] ---------------  -------------------|-[I][/I][I][/I]------------[I][/I][I][/I]------------|-----------------
 --  11  [color=#000000] itisi            [/color]    1,666        2 | [I][/I][I][/I]   518,735  [I][/I][I][/I]    1,287   |       1:046:10
 --  12  [color=#000000] Fred B           [/color]        0        0 | [I][/I][I][/I]   410,723  [I][/I][I][/I]    1,104   |       1:013:06
 --  13  [color=#000000] Ian Cunningham   [/color]    2,214        4 | [I][/I][I][/I]   369,494  [color=#ff8c00]    1,003  [/color] |       0:267:08
 --  14  [color=#000000] Rush             [/color]      706        5 | [I][/I][I][/I]   363,214  [I][/I][I][/I]    1,424   |       0:240:23
 --  15  [color=#000000] Michael John We  [/color]    1,229        6 | [I][/I][I][/I]   362,035  [I][/I][I][/I]    1,162   |       0:325:04
 --  16  [color=#000000] peahouse05       [/color]    1,243        4 | [I][/I][I][/I]   332,491  [I][/I][I][/I]      882   |       0:248:06
 --  17  [color=#000000] Quadophile       [/color]        0        0 | [I][/I][I][/I]   306,130  [I][/I][I][/I]      750   |       0:174:02
 --  18  [color=#000000] RustySherrif     [/color]        0        0 | [I][/I][I][/I]   273,060  [I][/I][I][/I]    1,099   |       1:017:06
 --  19  [color=#000000] AbsoluteKevster  [/color]    6,581       17 | [I][/I][I][/I]   249,724  [I][/I][I][/I]      789   |       0:265:23
 --  20  [color=#000000] ChrisIMRIE       [/color]        0        0 | [I][/I][I][/I]   196,335  [I][/I][I][/I]    1,115   |       0:188:21
---------[I][/I][I][/I] ---------------  -------------------|-[I][/I][I][/I]------------[I][/I][I][/I]------------|-----------------
 --  21  [color=#000000] feckit           [/color]        0        0 | [I][/I][I][/I]   183,941  [I][/I][I][/I]      449   |       0:083:14
 --  22  [color=#000000] Me__2001         [/color]    1,434        3 | [I][/I][I][/I]   170,630  [I][/I][I][/I]      453   |       0:103:17
 --  23  [color=#000000] MajorMellons     [/color]        0        0 | [I][/I][I][/I]   165,783  [I][/I][I][/I]      400   |       0:209:05
 --  24  [color=#000000] kingnathski88    [/color]        0        0 | [I][/I][I][/I]    97,343  [I][/I][I][/I]      317   |       0:138:04
 --  25  [color=#000000] Rudi the Red     [/color]        0        0 | [I][/I][I][/I]    93,940  [I][/I][I][/I]      279   |       0:061:20
 --  26  [color=#000000] RufusW           [/color]      403        1 | [I][/I][I][/I]    64,473  [I][/I][I][/I]      255   |       0:078:22
 --  27  [color=#000000] herval307        [/color]        0        0 | [I][/I][I][/I]    37,384  [I][/I][I][/I]       80   |       0:045:05
 --  28  [color=#000000] VAIO GRX616      [/color]        0        0 | [I][/I][I][/I]    36,325  [I][/I][I][/I]      116   |       0:032:06
 --  29  [color=#000000] cirianz          [/color]        0        0 | [I][/I][I][/I]    35,313  [I][/I][I][/I]       56   |       0:065:00
 --  30  [color=#000000] Stuartw101       [/color]        0        0 | [I][/I][I][/I]    32,893  [I][/I][I][/I]      103   |       0:025:16
---------[I][/I][I][/I] ---------------  -------------------|-[I][/I][I][/I]------------[I][/I][I][/I]------------|-----------------
 --  31  [color=#000000] Sexy Bex         [/color]        0        0 | [I][/I][I][/I]    24,361  [I][/I][I][/I]      125   |       0:038:10
 --  32  [color=#000000] TLD              [/color]        0        0 | [I][/I][I][/I]    22,257  [I][/I][I][/I]       64   |       0:014:17
 --  33  [color=#000000] Charles Chan     [/color]        0        0 | [I][/I][I][/I]    15,377  [I][/I][I][/I]        9   |       0:019:11
 --  34  [color=#000000] HAKA ryu         [/color]        0        0 | [I][/I][I][/I]    10,807  [I][/I][I][/I]       57   |       0:016:21
 --  35  [color=#000000] Tunix            [/color]        0        0 | [I][/I][I][/I]     6,364  [I][/I][I][/I]       49   |       0:006:02
 --  36  [color=#000000] phicksus         [/color]        0        0 | [I][/I][I][/I]     5,831  [I][/I][I][/I]       26   |       0:003:21
 --  37  [color=#000000] jaxx83           [/color]        0        0 | [I][/I][I][/I]     5,798  [I][/I][I][/I]       30   |       0:006:08
 --  38  [color=#000000] ladypcer2        [/color]        0        0 | [I][/I][I][/I]     3,129  [I][/I][I][/I]        8   |       0:001:09
 --  39  [color=#000000] Cache-man        [/color]        0        0 | [I][/I][I][/I]     2,995  [I][/I][I][/I]        6   |       0:004:23
 --  40  [color=#000000] midas1           [/color]        0        0 | [I][/I][I][/I]     2,305  [I][/I][I][/I]       10   |       0:002:23
---------[I][/I][I][/I] ---------------  -------------------|-[I][/I][I][/I]------------[I][/I][I][/I]------------|-----------------
 --  41  [color=#000000] Covenant         [/color]        0        0 | [I][/I][I][/I]     1,139  [I][/I][I][/I]        5   |       0:001:16
 --  42  [color=#000000] arabicdes        [/color]        0        0 | [I][/I][I][/I]       833  [I][/I][I][/I]        4   |       0:001:05
 --  43  [color=#000000] chris24ang       [/color]        0        0 | [I][/I][I][/I]         0  [I][/I][I][/I]        0   |       -:---:--
 --  44  [color=#000000] Crusader325      [/color]        0        0 | [I][/I][I][/I]         0  [I][/I][I][/I]        0   |       -:---:--
         [I][/I][I][/I] ===============    =======  ======= | [I][/I][I][/I] =========  [I][/I][I][/I]=========   |     ==========
         [color=#ADD8E6] .               [/color]       New      New | [I][/I][I][/I]     Total  [I][/I][I][/I]    Total   |      Team Time
         [color=#ADD8E6] .               [/color]    Points  Results | [I][/I][I][/I]    Points  [I][/I][I][/I]  Results   |      Yr:Day:Hr
         [color=#ADD8E6] .               [/color]   -------  ------- | [I][/I][I][/I] ---------  [I][/I][I][/I]---------   |     ----------
         [I][/I][I][/I] Team Total          57,590      174 | [I][/I][I][/I]15,250,298  [I][/I][I][/I]   43,894   |      30:310:10
         [color=#ADD8E6] .               [/color] =====================[I][/I][I][/I] =========  [I][/I][I][/I]=========   |     ==========
         [color=#59e817] Up Rank         [/color] Last weeks 10/22/2006[I][/I][I][/I]15,192,708  [I][/I][I][/I]   43,720  
         [color=#008000] Down Rank       [/color] ---------------------[I][/I][I][/I] ---------  [I][/I][I][/I]---------  
         [color=#000000] No Change       [/color] Weekly running total [I][/I][I][/I]    57,590  [I][/I][I][/I]      174  
         [color=#ff8c00] Newbe           [/color] =====================[I][/I][I][/I] =========  [I][/I][I][/I]=========  
         [color=#999795] Inactive        [/color] Uploaded last week   [I][/I][I][/I]         0  [I][/I][I][/I]        0  
         [color=#ADD8E6] .               [/color] Output +/- of        [color=#008000]    57,590 [/color] [color=#008000]      174 [/color]
         [color=#ADD8E6] .               [/color] ---------------------[I][/I][I][/I] ---------  [I][/I][I][/I]---------  
         [color=#ADD8E6] .               [/color]                      [I][/I][I][/I]            [I][/I][I][/I]           
         [color=#008000] Team Rank       [/color]        84 (+1)

[U]Top 10 Dumpers for the day:[/U]
|================================|
|   Member Name   |    Points    |
|--------------------------------|
| cImrie          |        9,885 |
| TriplexDread    |        7,553 |
| V_R             |        6,846 |
| AbsoluteKevster |        6,581 |
| Harvey          |        5,466 |
| Chris_Postill   |        3,440 |
| pikakilla       |        3,307 |
| Ian Cunningham  |        2,214 |
| muckshifter     |        2,028 |
| chelseafc2005   |        1,914 |
|================================|

[U]Movers of the day:[/U]
|================================|
|   Member Name   |    Points    |
|--------------------------------|
| TriplexDread    |(+1) 7553     |
|================================|

Win2kuser (XPC) WCG Stats Rev 1.7.2
Averages and inactive members calculated over 14 days

[/B][/SIZE]
 
Thanks!!

This looks excellent Mark :nod: - thank you for all your time and effort :bow:


.......Its so clear that I just noticed reading it that I have just completed 5 years of computer runtime :D
 
That green date looks better :D I really appreciate the effort you are putting in to this - if there's anything I can do to help you please let me know :)
 
Just wanted to say.....that's great! :thumb::thumb::thumb:

I dont have a clue how you did it but fair play to you!
bowdown.gif
 
Ian Cunningham said:
Just out of curiosity - does the code run within Excel as VBScript?
Click to expand...

hmm, yes and no really, most of it runs as a macro, the rest is VBA code :)

When you open the workbook, you will see a standard Visual Basic form that just gives you info as it goes about it's business, you actually get a 1 minute countdown before it starts to give you time to cancell the macro and play with the file; behind the form is the actual workbook which you will see flashing around is it's told to do certain things. Once it's finished, it just saves the workbook, outputs the txt file and shuts down.

All automated with VBA macros :D

There's no real way to explain it, you have to see it run...

Soon enough though, won't be long...
 
By Ian

if there's anything I can do to help you please let me know :)
Click to expand...


Got any PCReview magnets left Ian :) , he would love one of them :thumb:
 
Glad you like it, got to finish a few things on it ready for tomorrow mornings run, then I'll have to start thinking about writting instructions for it :lol:

Laterz...
 
Mark - just one thing, should the Up Rank/Down Rank explaination colours at the bottom (under Team Total) be that nicer green for Up Rank and red for Down Rank?
 
Rush said:
Got any PCReview magnets left Ian :) , he would love one of them :thumb:
Click to expand...

Oh yes! If you want a PCR magnet then drop me a PM with your address and I'll get one on its way - I've still got a few left from the last giveaway to all crunchers.
 
Please don't take this as criticism, its just an observation. :)

In IE the stats automatically widen to the full width, so you don't need side scrolling. But in Firefox you need to use the side scroll as it only fills out the page as the same width as a normal post.

Is that something i can change on my end?
 
V_R said:
Please don't take this as criticism, its just an observation. :)

In IE the stats automatically widen to the full width, so you don't need side scrolling. But in Firefox you need to use the side scroll as it only fills out the page as the same width as a normal post.

Is that something i can change on my end?
Click to expand...
Don't worry about it V_R - thats something in vBulletin not the stats so I can sort it out once the script is sorted :)
 
Ok no worries Ian. Its not a problem i have side scroll on my G7. :D

Its just i know we have a few FF users here. :)
 
This is a bloody damn excellent bit o' work ... thanks is too small a word, but thanks anyway.
nod.gif


Greatly appreciated. :thumb:
 
Back
Top