The 167 active users production last week, SETI@Home 14.03.2006.

[Rattledagger]

# _____ CS/day________ name

1 _____ 7.848,143 _____ mondobyte
2 _____ 5.878,571 _____ TenaciousT - Huntsville, AL
3 _____ 5.755,857 _____ amd.borg
4 _____ 4.588,429 _____ cory e
5 _____ 4.269,857 _____ Ace
6 _____ 3.146,143 _____ nova
7 _____ 2.197,429 _____ shuxclams
8 _____ 1.862,143 _____ Astro-AL
9 _____ 1.858,857 _____ baxsie
10 _____ 1.513,286 _____ plasma
11 _____ 901,857 _____ Pabster
12 _____ 873,429 _____ CraigRT
13 _____ 792,571 _____ Hellburner
14 _____ 774,857 _____ Pnko
15 _____ 711,429 _____ Home_of_Akin
16 _____ 695,571 _____ PK709394
17 _____ 612,857 _____ petrusbroder
18 _____ 582,857 _____ Alan J. Simpson
19 _____ 579,000 _____ Grant
20 _____ 520,429 _____ homeless
21 _____ 506,286 _____ Fee
22 _____ 462,143 _____ daocwinky
23 _____ 444,000 _____ Ber Makiah
24 _____ 435,857 _____ Pokey
25 _____ 433,286 _____ DimensionX
26 _____ 410,000 _____ Goo
27 _____ 394,714 _____ Gobbletwo
28 _____ 391,000 _____ kimcheeboy
29 _____ 388,571 _____ Soggy
30 _____ 379,143 _____ dpl1111
31 _____ 369,429 _____ Michael G. Potter
32 _____ 364,000 _____ Rich Hisgen
33 _____ 362,714 _____ Vindum
34 _____ 325,571 _____ Bruce
35 _____ 319,143 _____ NT4Mike
36 _____ 287,714 _____ IHATEHUMANS
37 _____ 263,429 _____ Sunny129
38 _____ 263,286 _____ ayemooth
39 _____ 259,857 _____ RoHo (Apple G5 dual 2.3)
40 _____ 248,714 _____ Handy_Dave
41 _____ 248,143 _____ minendo
42 _____ 245,714 _____ Mikesci457
43 _____ 241,714 _____ Scott Schafer
44 _____ 241,714 _____ uallas5
45 _____ 224,286 _____ Voodoo
46 _____ 223,857 _____ Patrick Van Uffelen
47 _____ 222,286 _____ qt0cali
48 _____ 221,714 _____ CheesePoofs
49 _____ 217,714 _____ RussianSensation
50 _____ 206,286 _____ Sofa King
51 _____ 201,000 _____ johnmal
52 _____ 198,286 _____ Alpha Psi
53 _____ 197,571 _____ rabidjade
54 _____ 196,429 _____ Defster
55 _____ 195,143 _____ Zoomie1982
56 _____ 189,429 _____ panhead49
57 _____ 185,857 _____ PoloMaster
58 _____ 179,714 _____ strikermike
59 _____ 177,857 _____ jetskr9
60 _____ 177,286 _____ Robert Everly
61 _____ 174,286 _____ martyreadling
62 _____ 174,143 _____ IsOs ? TeAm AnandTech
63 _____ 173,143 _____ ORION
64 _____ 171,143 _____ bountyhunterxl
65 _____ 170,857 _____ Jason
66 _____ 162,714 _____ bsauerbr
67 _____ 162,000 _____ matchbook
68 _____ 153,143 _____ Niege
69 _____ 150,286 _____ lparkin
70 _____ 149,714 _____ Xemus
71 _____ 149,143 _____ strider7
72 _____ 147,714 _____ blues008
73 _____ 144,143 _____ crventure
74 _____ 138,714 _____ GregANDTCH
75 _____ 135,143 _____ Looker2000
76 _____ 135,143 _____ JHutch - Team AnandTech
77 _____ 135,000 _____ zordz
78 _____ 134,286 _____ jjsetihead
79 _____ 133,429 _____ Chris Buchach
80 _____ 133,143 _____ subspace
81 _____ 131,143 _____ Chris S
82 _____ 127,857 _____ Truenofan
83 _____ 124,000 _____ mrbeci
84 _____ 114,429 _____ RAF
85 _____ 112,571 _____ FatmanOSU
86 _____ 111,429 _____ Wayne S
87 _____ 108,429 _____ Scratch
88 _____ 104,571 _____ Jaramin
89 _____ 102,857 _____ Anarchy
90 _____ 102,429 _____ jlaine
91 _____ 102,143 _____ lizardth
92 _____ 100,429 _____ Eltano
93 _____ 100,429 _____ Mike
94 _____ 96,429 _____ Orion
95 _____ 90,286 _____ DaFinn
96 _____ 89,429 _____ HouZe
97 _____ 86,714 _____ caddlad
98 _____ 84,714 _____ Surge_On
99 _____ 84,571 _____ GhettoFob
100 _____ 84,143 _____ Vendetta
101 _____ 82,714 _____ vwbobby
102 _____ 81,857 _____ liquidsun
103 _____ 79,714 _____ Xanth
104 _____ 77,429 _____ Schadenfroh
105 _____ 76,000 _____ Foofish
106 _____ 75,714 _____ fredlight
107 _____ 74,286 _____ Dave Graham
108 _____ 71,429 _____ Nathan
109 _____ 70,857 _____ LastKnight
110 _____ 70,429 _____ groundedsailor
111 _____ 68,143 _____ Webmonkey
112 _____ 65,714 _____ DRingdahl
113 _____ 64,286 _____ Baluba
114 _____ 63,571 _____ Blade
115 _____ 62,714 _____ Steve
116 _____ 59,571 _____ Specabecca
117 _____ 58,286 _____ Swanny
118 _____ 55,429 _____ earthman
119 _____ 55,000 _____ ElFenix
120 _____ 54,571 _____ Assimilator1 - Team AnandTech
121 _____ 52,429 _____ HughesITS
122 _____ 50,571 _____ geomagick
123 _____ 48,000 _____ CaMiX
124 _____ 47,714 _____ kwhited
125 _____ 47,143 _____ icmurdie
126 _____ 41,714 _____ Alphatea
127 _____ 41,571 _____ RCaplinger
128 _____ 41,429 _____ mirkaba
129 _____ 39,714 _____ Lorenzo Macuja
130 _____ 37,143 _____ LOAF
131 _____ 33,143 _____ Killa_s
132 _____ 30,714 _____ mnelsonx
133 _____ 30,286 _____ RedFish
134 _____ 25,571 _____ benedict
135 _____ 24,571 _____ NoBozos
136 _____ 22,857 _____ michael^
137 _____ 20,429 _____ Marlowe
138 _____ 18,000 _____ andrew_teo86
139 _____ 17,000 _____ Mortimer
140 _____ 17,000 _____ Dr. J
141 _____ 16,429 _____ quietdad
142 _____ 15,429 _____ mk
143 _____ 13,857 _____ De Genius
144 _____ 13,857 _____ brian
145 _____ 13,429 _____ neutrix
146 _____ 13,286 _____ Jarrod Hammack
147 _____ 11,571 _____ 1sk8er
148 _____ 11,286 _____ Audigy
149 _____ 10,857 _____ THE TERMINATOR
150 _____ 8,857 _____ Chris Highfill
151 _____ 7,000 _____ idlorj
152 _____ 6,857 _____ Mlani
153 _____ 6,571 _____ jswjimmy
154 _____ 6,429 _____ Peter
155 _____ 5,429 _____ sgriffin
156 _____ 4,429 _____ calin
157 _____ 4,000 _____ Joe
158 _____ 3,714 _____ Ric
159 _____ 3,143 _____ MrPickins
160 _____ 3,143 _____ Zues
161 _____ 3,000 _____ Shelgeyr
162 _____ 2,857 _____ See Cai Yong
163 _____ 2,857 _____ Daniel Schulken
164 _____ 2,857 _____ Gregg Iceton
165 _____ 2,714 _____ Waldo_2k
166 _____ 2,571 _____ Howard
167 _____ 1,286 _____ big8little


Assimilator1 has been bugging about how to generate some weekly user-stats, and this is a quick and dirty attempt... :beer:



Using a "cheap" trick, since BoincStats is already calculating the last 7 days, in theory it's just to copy/paste from here and do some formatting...

... but ran into a couple problems... :frown:


Anyway, on web-page right-click and "Select all", copy the whole page to Excel. Do this for the next 100 also, just add to bottom.

Afterwards, select everything in Excel, and copy to another sheet, and select Edit/Paste Special/Values. (ok)

Select everything and sort after I, and appart for a "gap" at 100 you've now sorted everything.


The easy is to just delete any columns you don't want to use, and re-shuffle the others so you have
place, CS/week, name, just add a column between each and add ______ to this...


It's also possible to calculate CS/day, but apparently even it's not displayed in Excel atleast there is a hidden á on the numbers and as long as this is present you can't calculate CS/day... :disgust:


Of course, have no idea if BoincStats numbers are correct or not...


Oh, and did see the question, but hadn't time to test anything before now. :beer:

 

[amdxborg]

Pretty cool thanx RD!

 

[Assimilator1]

Ah excellent ,thanks mate

Good to see some old names crunching away there (but some missing too)

No problems on the delay,no hurry ,I just wasn't sure if you'd seen it

I will try to do a run of these stats on Saturday.

It's also possible to calculate CS/day, but apparently even it's not displayed in Excel atleast there is a hidden á on the numbers and as long as this is present you can't calculate CS/day...

But you have calculated CS/day

I'm going to try a dummy run now

 

[Assimilator1]

Why do we need to copy to a 2nd sheet?

I go to edit>paste special but there's no values option

 

[Rattledagger]

Originally posted by: Assimilator1
But you have calculated CS/day

Saved the "offending" column to a text-file, opened-up in "good old" wp51, and did a search/replace on á, saved file as text again, and opened back up in Excel, just replace the "bad" column with the now "good" column...

Can do the same in Word, open text-file, show codes, select and copy the o or whatever shows up, and choose replace and use this as input and nothing as output...

 

[Rattledagger]

Originally posted by: Assimilator1
Why do we need to copy to a 2nd sheet?

I go to edit>paste special but there's no values option

The "raw" copy from web-page among other things places the stats over 2 rows per user and so on, so isn't really usable...


As for "Paste Special", when you're using this you'll remove all the formatting that has been added, and you can now also sort columns and so on, something that doesn't work on the "raw" copy.

As for not seeing "values", it's possibly they'll calling it something else depending on which Excel-version you're using...
Oh, make sure you're copying from Excel, and not from web-page when you tries "paste special", since if you tries a web-page there's only choise of html or text, and neither is really useful since html you've back to just copy/paste and as text everything is placed in one column so isn't usable for formatting anything...

 

[panhead49]

Good to see some old names crunching away there (but some missing too)

yes ,i agree!!! we have to do something about this???....

(and yes ..its good to see my name on a stats page again finally..been months!! )

edit...o yea Assimilator1....good idea about doing the daily stats....it will help in the motivation department......

 

[Assimilator1]

The trouble is some of the old names have switched to other projects ,not much we can do about that.New recruites is our best chance.

RD
I'll check out that info latter ,thx
Btw I have MS Office 2000

 

[Rattledagger]

Originally posted by: Assimilator1
Btw I have MS Office 2000

Haven't bothered upgrading from 97-version, so would guess your version has all the same things, just shaken-around so it's difficult to find them again...

 

[Spacehead]

Hey Assimilator1, are you just wanting to do numbers for the week? Or do you want other things too, daily averages, etc?

Something like this only takes about 5-10 minutes...


___ Last 7 Days ___ Name
1 ___ 180,991 ___ mondobyte
2 ___ 112,336 ___ TenaciousT - Huntsville, AL
3 ____ 76,175 ___ shuxclams
4 ____ 67,555 ___ Ace
5 ____ 65,463 ___ cory e
6 ____ 48,016 ___ amd.borg
7 ____ 44,653 ___ nova
8 ____ 28,031 ___ Astro-AL
9 ____ 27,962 ___ baxsie
10 ___ 22,298 ___ uallas5
11 ___ 18,429 ___ plasma
12 ___ 15,859 ___ CraigRT
13 ___ 14,855 ___ Pabster
14 ___ 14,233 ___ Pnko
15 ___ 13,748 ___ strider7
16 ___ 12,394 ___ PK709394
17 ___ 11,722 ___ Merlin
18 ____ 9,607 ___ Hellburner
19 ____ 9,056 ___ Home_of_Akin
20 ____ 8,836 ___ homeless
21 ____ 8,824 ___ Alan J. Simpson
22 ____ 8,524 ___ Grant
23 ____ 8,439 ___ petrusbroder
24 ____ 7,097 ___ dpl1111
25 ____ 6,442 ___ jjsetihead
26 ____ 6,347 ___ Pokey
27 ____ 6,113 ___ Rich Hisgen
28 ____ 6,101 ___ DimensionX
29 ____ 5,968 ___ strikermike
30 ____ 5,916 ___ Bruce
31 ____ 5,746 ___ Christian Diepold
32 ____ 5,720 ___ LastKnight
33 ____ 5,688 ___ NT4Mike
34 ____ 5,212 ___ Vindum
35 ____ 5,139 ___ kb3edk
36 ____ 4,824 ___ Goo
37 ____ 4,661 ___ Chris S
38 ____ 4,324 ___ Soggy
39 ____ 4,257 ___ Alpha Psi
40 ____ 4,244 ___ mrbeci
41 ____ 4,166 ___ Voodoo
42 ____ 4,153 ___ matchbook
43 ____ 3,962 ___ Sunny129
44 ____ 3,873 ___ Blade
45 ____ 3,867 ___ JHutch - Team AnandTech
46 ____ 3,616 ___ Scott Schafer
47 ____ 3,490 ___ SETIdude
48 ____ 3,469 ___ Poolman
49 ____ 3,424 ___ IsOs ® TeAm AnandTech
50 ____ 3,416 ___ fredlight
51 ____ 3,345 ___ martyreadling
52 ____ 3,287 ___ Mikesci457
53 ____ 3,169 ___ Handy_Dave
54 ____ 3,160 ___ RoHo (Apple G5 dual 2.3)
55 ____ 3,106 ___ RussianSensation
56 ____ 3,105 ___ Alphatea
57 ____ 3,104 ___ Michael G. Potter
58 ____ 3,104 ___ Zoomie1982
59 ____ 3,055 ___ Jason
60 ____ 2,974 ___ Defster
61 ____ 2,945 ___ Niege
62 ____ 2,935 ___ Patrick Van Uffelen
63 ____ 2,810 ___ Looker2000
64 ____ 2,640 ___ Daniel Schulken
65 ____ 2,629 ___ GregANDTCH
66 ____ 2,604 ___ bsauerbr
67 ____ 2,583 ___ blues008
68 ____ 2,520 ___ Chris Buchach
69 ____ 2,476 ___ Sofa King
70 ____ 2,475 ___ Foofish
71 ____ 2,474 ___ ayemooth
72 ____ 2,368 ___ rabidjade
73 ____ 2,332 ___ Nathan
74 ____ 2,320 ___ qt0cali
75 ____ 2,315 ___ crventure
76 ____ 2,295 ___ bountyhunterxl
77 ____ 2,284 ___ Xemus
78 ____ 2,281 ___ daocwinky
79 ____ 2,250 ___ andrew_teo86
80 ____ 2,216 ___ Fee
81 ____ 2,169 ___ minendo
82 ____ 2,134 ___ subspace
83 ____ 2,125 ___ LANMAN
84 ____ 2,092 ___ ElFenix
85 ____ 2,035 ___ Colton Murphy
86 ____ 2,018 ___ johnmal
87 ____ 2,010 ___ kwhited
88 ____ 1,970 ___ Brad
89 ____ 1,939 ___ [CGAA]Omega Geek
90 ____ 1,922 ___ CheesePoofs
91 ____ 1,852 ___ caddlad
92 ____ 1,831 ___ ORION
93 ____ 1,824 ___ FatmanOSU
94 ____ 1,749 ___ Anarchy
95 ____ 1,733 ___ DaFinn
96 ____ 1,729 ___ Grimner
97 ____ 1,720 ___ hjo3
98 ____ 1,648 ___ groundedsailor
99 ____ 1,642 ___ zordz
100 ___ 1,609 ___ IHATEHUMANS
101 ___ 1,579 ___ Webmonkey
102 ___ 1,562 ___ HouZe
103 ___ 1,522 ___ michael^
104 ___ 1,511 ___ Robert Everly
105 ___ 1,493 ___ BlueVisor
106 ___ 1,400 ___ Vendetta
107 ___ 1,385 ___ Jaramin
108 ___ 1,360 ___ Icefire_QuickSilver
109 ___ 1,301 ___ liquidsun
110 ___ 1,298 ___ skidawg
111 ___ 1,295 ___ Scratch
112 ___ 1,291 ___ Xanth
113 ___ 1,286 ___ Wayne S
114 ___ 1,244 ___ Schadenfroh
115 ___ 1,236 ___ asim
116 ___ 1,198 ___ evergreencaw
117 ___ 1,179 ___ quietdad
118 ___ 1,147 ___ lparkin
119 ___ 1,146 ___ BobTheWizard
120 ___ 1,114 ___ Dave Graham
121 ___ 1,067 ___ RedFish
122 ____ 952 ___ Swanny
123 ____ 945 ___ GhettoFob
124 ____ 928 ___ RAF
125 ____ 878 ___ icmurdie
126 ____ 857 ___ amish
127 ____ 837 ___ CaMiX
128 ____ 837 ___ Assimilator1 - Team AnandTech
129 ____ 819 ___ calin
130 ____ 814 ___ Lorenzo Macuja
131 ____ 771 ___ Mortimer
132 ____ 729 ___ NoBozos
133 ____ 710 ___ geomagick
134 ____ 664 ___ Doublejr
135 ____ 644 ___ Audigy
136 ____ 637 ___ vwbobby
137 ____ 634 ___ Shelgeyr
138 ____ 620 ___ Rezag1000
139 ____ 606 ___ Tallbill
140 ____ 588 ___ TeAm Enterprise
141 ____ 581 ___ Steve
142 ____ 571 ___ Gobbletwo
143 ____ 564 ___ rcofell
144 ____ 562 ___ HughesITS
145 ____ 549 ___ Baluba
146 ____ 532 ___ mnelsonx
147 ____ 528 ___ Soni
148 ____ 505 ___ LOAF
149 ____ 466 ___ GLeeM
150 ____ 452 ___ neutrix
151 ____ 433 ___ jswjimmy
152 ____ 429 ___ Eltano
153 ____ 428 ___ Talyn00
154 ____ 419 ___ earthman
155 ____ 413 ___ THE TERMINATOR
156 ____ 409 ___ DRingdahl
157 ____ 392 ___ idlorj
158 ____ 390 ___ the melon
159 ____ 381 ___ Allen Cope
160 ____ 381 ___ Orion
161 ____ 377 ___ Krystophv
162 ____ 343 ___ benedict
163 ____ 341 ___ cooper76
164 ____ 340 ___ Specabecca
165 ____ 316 ___ Examancer
166 ____ 311 ___ perra
167 ____ 310 ___ esberger
168 ____ 287 ___ Mlani
169 ____ 282 ___ brian
170 ____ 270 ___ Surge_On
171 ____ 253 ___ Jonnyunited
172 ____ 252 ___ PoloMaster
173 ____ 240 ___ Mortis
174 ____ 230 ___ Yue Jon
175 ____ 228 ___ aka1nas
176 ____ 226 ___ alokoko
177 ____ 226 ___ Zues
178 ____ 223 ___ Waldo_2k
179 ____ 215 ___ Ingleside
180 ____ 191 ___ Jarrod Hammack
181 ____ 186 ___ 1sk8er
182 ____ 178 ___ Dr. J
183 ____ 176 ___ Dredd
184 ____ 149 ___ Ber Makiah
185 ____ 140 ___ mike
186 ____ 133 ___ kimcheeboy
187 ____ 120 ___ salvorhardin
188 ____ 120 ___ RCaplinger
189 ____ 118 ___ Killa_s
190 ____ 104 ___ 440sixpack
191 _____ 78 ___ Charles Wise
192 _____ 69 ___ De Genius
193 _____ 66 ___ Gregg Iceton
194 _____ 56 ___ Ric
195 _____ 54 ___ Joe
196 _____ 34 ___ cramand1
197 _____ 34 ___ pcgamez
198 _____ 32 ___ Mr_Rocker
199 _____ 29 ___ iceberg
200 _____ 29 ___ mk
201 _____ 26 ___ Marlowe
202 _____ 26 ___ Jened
203 _____ 21 ___ See Cai Yong
204 _____ 19 ___ big8little
205 _____ 18 ___ dschley
206 _____ 15 ___ oztutor

 

[Rattledagger]

Originally posted by: Spacehead
Something like this only takes about 5-10 minutes...

You forgot to calculate the daily averages.

But yes, when finally found-out how to "crack" all the garbage BoincStats is throwing at you, it should actually be faster to make these stats than the daily team-stats, since you don't need to do the time-consuming formatting-step.


Hmm... but, my results is completely different than your stats...

Uhm, seeing Anandtech has RAC around 75k, it doesn't make sence that according to your stats the top-5 has produced roughly 500k in a week, since this means 71k/day...


Oh, and note to self, remember to also fix the decimal-point at same time cleans-out the other "garbage", since otherwise users in the 2nd. half of the table will actually have higher production than the 1st. half... :frown:


# _____ CS/day________ name

1 ______ 7.789,57 ______ mondobyte
2 ______ 6.308,71 ______ TenaciousT - Huntsville, AL
3 ______ 6.211,57 ______ amd.borg
4 ______ 4.404,00 ______ cory e
5 ______ 4.354,86 ______ Ace
6 ______ 3.106,57 ______ nova
7 ______ 2.322,71 ______ shuxclams
8 ______ 1.996,00 ______ baxsie
9 ______ 1.876,86 ______ Astro-AL
10 ______ 1.504,71 ______ plasma
11 ______ 1.027,57 ______ Pabster
12 ______ 924,29 ______ Pnko
13 ______ 833,86 ______ Hellburner
14 ______ 813,14 ______ CraigRT
15 ______ 756,57 ______ PK709394
16 ______ 741,29 ______ Home_of_Akin
17 ______ 683,86 ______ kimcheeboy
18 ______ 643,71 ______ Fee
19 ______ 601,29 ______ andrew_teo86
20 ______ 598,57 ______ petrusbroder
21 ______ 596,00 ______ Alan J. Simpson
22 ______ 571,14 ______ homeless
23 ______ 559,14 ______ Grant
24 ______ 555,43 ______ Bruce
25 ______ 478,29 ______ IHATEHUMANS
26 ______ 458,43 ______ Michael G. Potter
27 ______ 457,71 ______ Soggy
28 ______ 455,71 ______ Pokey
29 ______ 434,00 ______ daocwinky
30 ______ 395,29 ______ dpl1111
31 ______ 394,57 ______ Vindum
32 ______ 380,57 ______ Mikesci457
33 ______ 374,29 ______ Rich Hisgen
34 ______ 373,43 ______ johnmal
35 ______ 340,29 ______ Goo
36 ______ 292,14 ______ DimensionX
37 ______ 274,43 ______ Sunny129
38 ______ 272,00 ______ panhead49
39 ______ 253,29 ______ JHutch - Team AnandTech
40 ______ 250,14 ______ Gobbletwo
41 ______ 246,86 ______ PoloMaster
42 ______ 246,57 ______ jjsetihead
43 ______ 244,29 ______ uallas5
44 ______ 237,29 ______ Niege
45 ______ 228,86 ______ strider7
46 ______ 228,57 ______ minendo
47 ______ 228,43 ______ Handy_Dave
48 ______ 227,29 ______ matchbook
49 ______ 225,86 ______ Scott Schafer
50 ______ 222,29 ______ RussianSensation
51 ______ 220,86 ______ Defster
52 ______ 217,57 ______ Voodoo
53 ______ 216,57 ______ Patrick Van Uffelen
54 ______ 208,29 ______ RoHo (Apple G5 dual 2.3)
55 ______ 203,57 ______ martyreadling
56 ______ 203,00 ______ rabidjade
57 ______ 189,71 ______ blues008
58 ______ 184,86 ______ strikermike
59 ______ 182,43 ______ bsauerbr
60 ______ 178,86 ______ earthman
61 ______ 176,29 ______ Xemus
62 ______ 174,43 ______ Peter
63 ______ 168,43 ______ Alpha Psi
64 ______ 167,86 ______ qt0cali
65 ______ 167,00 ______ IsOs ® TeAm AnandTech
66 ______ 161,00 ______ Jason
67 ______ 160,00 ______ Zoomie1982
68 ______ 156,86 ______ caddlad
69 ______ 156,43 ______ zordz
70 ______ 151,86 ______ Mike
71 ______ 146,29 ______ Looker2000
72 ______ 144,71 ______ Chris Buchach
73 ______ 144,71 ______ bountyhunterxl
74 ______ 142,43 ______ NT4Mike
75 ______ 142,00 ______ Chris S
76 ______ 139,00 ______ subspace
77 ______ 138,86 ______ Robert Everly
78 ______ 137,14 ______ CheesePoofs
79 ______ 135,14 ______ jetskr9
80 ______ 134,57 ______ MrPickins
81 ______ 133,14 ______ Xanth
82 ______ 131,71 ______ crventure
83 ______ 131,71 ______ Wayne S
84 ______ 130,14 ______ ORION
85 ______ 127,00 ______ RAF
86 ______ 123,43 ______ ayemooth
87 ______ 119,86 ______ Dan W
88 ______ 118,00 ______ lizardth
89 ______ 117,71 ______ GregANDTCH
90 ______ 117,57 ______ fredlight
91 ______ 115,14 ______ FatmanOSU
92 ______ 114,43 ______ Swanny
93 ______ 113,43 ______ Jaramin
94 ______ 111,14 ______ mrbeci
95 ______ 108,00 ______ kwhited
96 ______ 103,43 ______ Orion
97 ______ 99,57 ______ HouZe
98 ______ 95,43 ______ Baluba
99 ______ 94,71 ______ Specabecca
100 ______ 91,29 ______ Truenofan
101 ______ 89,86 ______ jlaine
102 ______ 89,00 ______ Schadenfroh
103 ______ 88,71 ______ DaFinn
104 ______ 85,57 ______ lparkin
105 ______ 84,43 ______ vwbobby
106 ______ 84,00 ______ Eltano
107 ______ 82,57 ______ Alphatea
108 ______ 80,29 ______ GhettoFob
109 ______ 78,29 ______ liquidsun
110 ______ 75,57 ______ CB0159
111 ______ 75,29 ______ Blade
112 ______ 72,29 ______ Vendetta
113 ______ 62,43 ______ Assimilator1 - Team AnandTech
114 ______ 60,29 ______ ElFenix
115 ______ 57,14 ______ Nathan
116 ______ 56,14 ______ Waldo_2k
117 ______ 54,14 ______ CaMiX
118 ______ 48,29 ______ Dave Graham
119 ______ 47,71 ______ Steve
120 ______ 47,00 ______ RedFish
121 ______ 44,86 ______ mirkaba
122 ______ 43,14 ______ DRingdahl
123 ______ 42,29 ______ jswjimmy
124 ______ 42,00 ______ Surge_On
125 ______ 41,86 ______ Scratch
126 ______ 39,71 ______ groundedsailor
127 ______ 38,14 ______ HughesITS
128 ______ 36,86 ______ Howard
129 ______ 34,57 ______ mnelsonx
130 ______ 32,71 ______ geomagick
131 ______ 32,57 ______ NoBozos
132 ______ 31,29 ______ Marlowe
133 ______ 30,14 ______ Lorenzo Macuja
134 ______ 28,14 ______ icmurdie
135 ______ 24,14 ______ LOAF
136 ______ 21,86 ______ Anarchy
137 ______ 20,71 ______ kb3edk
138 ______ 20,57 ______ Daniel Schulken
139 ______ 19,86 ______ idlorj
140 ______ 19,57 ______ Dr. J
141 ______ 19,43 ______ mk
142 ______ 19,43 ______ brian
143 ______ 17,86 ______ benedict
144 ______ 17,14 ______ Krystophv
145 ______ 16,71 ______ Killa_s
146 ______ 15,29 ______ Foofish
147 ______ 14,86 ______ Mlani
148 ______ 13,29 ______ Webmonkey
149 ______ 12,14 ______ amish
150 ______ 11,29 ______ De Genius
151 ______ 11,14 ______ jackhole
152 ______ 9,71 ______ Audigy
153 ______ 9,29 ______ michael^
154 ______ 8,86 ______ Mortimer
155 ______ 8,43 ______ quietdad
156 ______ 8,14 ______ Joe
157 ______ 7,71 ______ neutrix
158 ______ 5,86 ______ LastKnight
159 ______ 5,86 ______ THE TERMINATOR
160 ______ 5,57 ______ Colton Murphy
161 ______ 5,57 ______ sgriffin
162 ______ 5,14 ______ Chris Highfill
163 ______ 4,57 ______ Jarrod Hammack
164 ______ 4,43 ______ Sofa King
165 ______ 4,43 ______ Zim Hosein
166 ______ 4,00 ______ RCaplinger
167 ______ 3,71 ______ Ric
168 ______ 3,43 ______ ironman@sidetracks
169 ______ 2,71 ______ See Cai Yong
170 ______ 2,71 ______ Mortis
171 ______ 1,29 ______ big8little

 

[Spacehead]

I used Free-DC to gather those numbers. I couldn't reach the BoincStats site at that time, so that probably is the difference. I assume Free-DC shows cobblestones & not something else.

Like i said, i didn't know exactly what Assimilator! wanted so that was just an example.

 

[Assimilator1]

Yea I wanted to do daily averages like RD did in his 1st post.

I'm gonna have another go tomorrow

 

[Spacehead]

Free-DC will give you 7 day averages.

 

[Assimilator1]

Where? your link doesn't show any stats.

Btw just typical, I actually get around to giving it another try & the stats page is down

 

[Spacehead]

Haven't looked at that page in awhile. I know he's had trouble with SETI in the past do to the shear number of people/teams/numbers involved. Hopefully it won't be down too long.

 

[Rattledagger]

Originally posted by: Assimilator1
Btw just typical, I actually get around to giving it another try & the stats page is down

Hmm, BoincStats is down when they're adding the new stats, since otherwise their server craps-out...

Another possibility, did you try with http://www.boincstats.com/... and not the temporary? 82...-address?

 

[Assimilator1]

Where do I get the Team stats in there?

 

[Spacehead]

Originally posted by: Assimilator1
Where do I get the Team stats in there?

On the left hand column of projects, if you click on one a sub-menu will appear. After searching around you end up here. I believe this is what you want.


It appears Free-DC's SETI stats are back too.
Text

 

[mondobyte]

It appears that I need to get out and do an old fashioned round-up ... and rebrand some of the strays ...

stats are slipping ...

 

[Assimilator1]

I'll try those stats thanks Spacehead

 

[Assimilator1]

Hmm ,Im spreading this out so far I keep forgetting where I am

Anyway I finally managed to follow RDs instructions ,its works but atm I've only got output for the week ,if I could divide each row by 7 then that would give me the daily average output for the past week.How do I do that?

Or would I be better off just copying off the freeDC stats site from the Daily average column?
But over what period is that averaged? (I only want it averaged over 1 week)
Hmm ,its not over 1 week....

RD
Was your 1st stats out by a factor 100?
For my stats I'm not sure if you mean 54 thousand ,571 (which makes no sense) or 54 point 571 ,in which case it should be 54.571 & Mondo's stats should be 7,848.143
Or am I losing it?

 

[Spacehead]

Originally posted by: Assimilator1
Anyway I finally managed to follow RDs instructions ,its works but atm I've only got output for the week ,if I could divide each row by 7 then that would give me the daily average output for the past week.How do I do that?

I'm sure all spreadsheets are different. I use Open Office, but you should be able to choose an empty cell, then enter the cells you want to add, subtract, etc.
Example, "B1/B2" to divide or "B1-B2" to subtract.
Do the one at the top of the sheet then you can do the rest of the list at once.

Hope that helps a little.

Originally posted by: Assimilator1
Or would I be better off just copying off the freeDC stats site from the Daily average column?
But over what period is that averaged? (I only want it averaged over 1 week)
Hmm ,its not over 1 week....

If you look at some ones individual stats page, it shows totals for Day 0, Day 1, Day 2, etc. I think the numbers shown on the team page under "Last 7 days" is the totals from Day 0 - Day 6 but averages are the totals from Day 1 - Day 7.
The "Daily Average" on the team page is for 7 days.

 

[Rattledagger]

Originally posted by: Assimilator1
Anyway I finally managed to follow RDs instructions ,its works but atm I've only got output for the week ,if I could divide each row by 7 then that would give me the daily average output for the past week.How do I do that?

Normally it would be to just divide by 7, but this doesn't work directly since there is some hidden "garbage", and till this is removed it doesn't work to calculate daily average. :frown:

To remove the garbage, copy the column with weekly stats over to Notepad, and afterwards from Notepad over to Word... Copying directly from Excel to Word doesn't work as it should...
In Word, enable to show "hidden" codes, atleast in my old copy it looks like a large PI, placed besides the %zoom.
Select whatever is the offending code, and select copy.
Choose "Find and Replace", paste the offending code, and replace with nothing, "Replace All".

When removed the garbage, just copy from Word back in Excel, and you can now divide by 7.

And yes, it is crazy that you needs to take these round-about-ways to get usable stats.

RD
Was your 1st stats out by a factor 100?
For my stats I'm not sure if you mean 54 thousand ,571 (which makes no sense) or 54 point 571 ,in which case it should be 54.571 & Mondo's stats should be 7,848.143
Or am I losing it?

No, the 1st. run had 3 decimals, while only used 2 in the next.
Mondo had close to 8k/day in 1st. stats, while you had 55/day.

It's not my fault you can't even write decimal , correctly.

 

[petrusbroder]

- it is (as often) different cultures ... american (decimal point, thousands-divider-comma) vs continental Europe (decimal-comma, thousands-divider-point). Took me a few months (some loooong time ago, when I lived in the USA) to get used to that.