Crunching Stats Calculator

W

Win2Kuser

Joined
Oct 29, 2006
Messages
36
Reaction score
0
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]
 
Adywebb

Adywebb

Growing old....
Moderator
Joined
Jan 1, 2005
Messages
5,459
Reaction score
21
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
 
Ian

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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 :)
 
V_R

V_R

¯\_(ツ)_/¯
Moderator
Joined
Jan 31, 2005
Messages
13,572
Reaction score
1,888
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
 
W

Win2Kuser

Joined
Oct 29, 2006
Messages
36
Reaction score
0
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...
 
Rush

Rush

Cool Cruncher
Joined
Nov 3, 2005
Messages
4,129
Reaction score
9
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:
 
W

Win2Kuser

Joined
Oct 29, 2006
Messages
36
Reaction score
0
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...
 
Adywebb

Adywebb

Growing old....
Moderator
Joined
Jan 1, 2005
Messages
5,459
Reaction score
21
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?
 
Ian

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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.
 
V_R

V_R

¯\_(ツ)_/¯
Moderator
Joined
Jan 31, 2005
Messages
13,572
Reaction score
1,888
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?
 
Ian

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
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 :)
 
V_R

V_R

¯\_(ツ)_/¯
Moderator
Joined
Jan 31, 2005
Messages
13,572
Reaction score
1,888
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. :)
 
muckshifter

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,739
Reaction score
1,204
This is a bloody damn excellent bit o' work ... thanks is too small a word, but thanks anyway.
nod.gif


Greatly appreciated. :thumb:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WCG Stats Sub forum 7
Crunching 7
Crunching on Galaxy S4 8
Sadly its time for me to retire....... 22
Important Stats Notice ... please read 0
WCG Stats Script? 6
Crunching, Me & Life 11
BOINC Stats Banners 1

Top