Rosetta@Home - 11/13: Stats

[BlackMountainCow]

No new members yesterday!


TA[R@H] is still 37 members strong.


Need some stats? Take a look at Free-DC, BOINC Stats and BOINC Synergy




Yesterday's highest TeAm climber: TA_JC (5 spots)

Yesterday's highest producer: TeAm Enterprise (2,703 creds)


Yesterday's production for TA: 13,006 creds :thumbsup: (- 143 creds)

TA's total score: 366,77165 creds

TA's world rank is: #6

Upcoming Threats: XPC (10,5 days) and US-Distributed (45 days)!

Upcoming Conquests: none




Milestone Makers::beer:


BadThad passes 5,000 creds!

Chris Duchesne passes 1,000 creds!






:beer::beer:

BMC

 

[BlackMountainCow]

I'm looking for a way to get/calculate the highest overall climber. I can't do it by the Free-DC stats as they only show the highest climber according to the latest update of the stats. Any ideas for that? I do these stats by hand so if you suggest any server or XML files, explain it so a n00b (=me) understands it!

 

[Bok7575]

What is your definition of Highest Overall Climber ? I might be able to add it to the stats to make it easy for you...

Bok

 

[Wolfsraider]

Originally posted by: Bok7575
What is your definition of Highest Overall Climber ? I might be able to add it to the stats to make it easy for you...

Bok

Bok always on the lurk to help out. You are better than a super hero

 

[BadThad]

I'd say don't worry about highest climber. Personally, I'd like to just see the top 10 producers everyday and, like Hellburners SETI stats, where we're at in relation to the other teams.

Thanks BMC!

 

[BlackMountainCow]

Originally posted by: Bok7575
What is your definition of Highest Overall Climber ? I might be able to add it to the stats to make it easy for you...

Bok

First of all, thx for the great stats site Bok, you do an awesome job there! :beer::beer:


To me the highest overall climber is that person, who went up the world stats the most in 24 hours. Usually when you start doing R@H or any other DC, you climb like 500 spots and only later it may take weeks to just go up one spot. I'm talking about the world ranks here, not the ranks within a team.

As BadThad said, it's not really that important and I don't really want to cause you any more work or trouble. So if there's a really easy and fast way for you do it, I'd really appreciate it. If not, then don't even worry about it.


Thx again!

 

[BlackMountainCow]

Originally posted by: BadThad
I'd say don't worry about highest climber. Personally, I'd like to just see the top 10 producers everyday and, like Hellburners SETI stats, where we're at in relation to the other teams.

Thanks BMC!

No problem, I can add that. I'm glad you give me some feedback on the stats. After all, these stats are for the TeAm and not just for my fame so if you want that, you'll get it!

 

[rise]

Originally posted by: BlackMountainCow

First of all, thx for the great stats site Bok, you do an awesome job there! :beer,:beer:

whoa whoa whoa, you're spilling your :beer: LOL

i added the rosetta link to my sig, maybe one of my 3000+ posts will do some good and get a new member or two

:beer::beer:

 

[BlackMountainCow]

Thx for the hint rise!

 

[Bok7575]

mysql> select max(projrank1 - projrank0) from rah_user where team0 like '%Anand%';
+----------------------------+
| max(projrank1 - projrank0) |
+----------------------------+
| 480 |
+----------------------------+
1 row in set (0.08 sec)

mysql> select name,nick,team0,(projrank1 - projrank0) as rank from rah_user where (projrank1 - projrank0 = 480)
-> ;
+-------+----------------+----------------+------+
| name | nick | team0 | rank |
+-------+----------------+----------------+------+
| 11378 | Chris Duchesne | TeAm AnandTech | 480 |
+-------+----------------+----------------+------+
1 row in set (0.08 sec)

mysql>

Is this what you are after...

I think I can probably do something with this on the teamstats.php page, and yes the sql can probably be done in 1 call with a subselect

However in the teamstats, it shows this anyway, in the projrank column, this is not necessarily the last 24 hours but since the previous day.

Bok

 

[Crazee]

Bok, you rock!

Very nice stats. You provide a great service to the DC community

Thanks for the update BMC

 

[BlackMountainCow]

Originally posted by: Bok7575

...

However in the teamstats, it shows this anyway, in the projrank column, this is not necessarily the last 24 hours but since the previous day.

Bok

Ah! Now if that number in the projectrank column is indeed for the last day, then you actually don't need to make any changes at all. 'Cause then i can just work with that number. I just thought that that number changes with each update. But you must know better, it's your site

Sorry for all the inconvenience Bok!

:beer:

 

[BadThad]

Originally posted by: Crazee
Bok, you rock!

Very nice stats. You provide a great service to the DC community

Thanks for the update BMC

:thumbsup:

 

[Bok7575]

The number might chaneg with each update as the user climbs up the ranking with each update. Basically , on the rollover of a day, I set a column - projrank1 to be whatever the rank at that point is, then projrank0 (current rank) is calculated with each update, the difference between these two is what is shown in the column, so it may well change during the day..

I store the project ranks for the past 28 days, so maybe you really want the max(projrank2 - projrank1) which would be static during the day..?

Bok

 

[BlackMountainCow]

Originally posted by: Bok7575

...

I store the project ranks for the past 28 days, so maybe you really want the max(projrank2 - projrank1) which would be static during the day..?

Bok

That'd be exactly the function I was looking for.