WUProp Hours Stats Comparisons

[Maxwell]

Spoken from someone obsessive, I know...

So, unless I'm blindly retarded (which is certainly possible), I can't find any way to compare hours stats across people like we do with credits. Even something simple like the Mega Milestones for WUProp hours (which is all the WUProp badge is, anyway), would be awesome. I'd like a way to see how I stack up against other people without having to go to individuals' stats pages and look. Something like the ability to find out "Maxwell has 107 applications with at least 100 hours, ranking him XXX on the team and XXX in the world."

Is this out there and findable?

[Bok]

I could do that easily enough, but remember it's only based on users who have switched on their flag at WuProp to allow the hours data to be exported.

One quick sql

mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
| id   | nick                          | mycount |
+------+-------------------------------+---------+
|  797 | zombie67 [MM]                 |     242 |
| 2482 | LCB001                        |     207 |
| 1169 | Coleslaw                      |     188 |
| 5500 | Bryan                         |     167 |
| 6346 | Steve Hawker*                 |     165 |
|   68 | vaughan                       |     163 |
|  276 | KAMCOBILL                     |     161 |
|  747 | Jeff17                        |     158 |
| 1504 | TBirdTheYuri                  |     157 |
| 2536 | james ying                    |     156 |
| 4230 | Sphynx[BlackOps]              |     151 |
|  509 | Conan                         |     151 |
| 1105 | arkiss                        |     147 |
| 4492 | cpuid                         |     145 |
| 6136 | Bazooka_CZ                    |     145 |
| 1500 | Sabroe_SMC                    |     144 |
|  846 | [SG]MichaelR.                 |     139 |
| 6971 | JagDoc                        |     139 |
| 3134 | fthibaud0001                  |     138 |
|   84 | Bok                           |     138 |
| 1882 | B Johansson                   |     137 |
| 2826 | Dirk Broer                    |     136 |
| 2317 | morgan                        |     136 |
|  995 | Sir Stooper                   |     132 |
|  825 | HGW                           |     130 |
|  807 | 7ri9991 [MM]                  |     128 |
| 2439 | L@MiR                         |     125 |
| 1912 | PanStaszek                    |     125 |
| 1039 | DoctorNow                     |     125 |
| 7207 | Werinbert                     |     124 |
| 4209 | aborek                        |     124 |
|  795 | Mumps [MM]                    |     123 |
| 6439 | georg70                       |     123 |
| 4494 | eisler jiri                   |     123 |
| 7257 | conf [MM]                     |     122 |
| 2542 | [AF>France>Astro]Spica        |     122 |
| 1739 | [AF>Libristes] Pascal         |     121 |
| 7558 | [AF>Amis des Lapins] Phil1966 |     121 |
| 2101 | Pete Broad                    |     118 |
|  562 | Cruncher Pete                 |     118 |
| 6100 | Roadranner                    |     116 |
| 3123 | anchedo                       |     116 |
| 1640 | [AF>Kirass>MPF] Nafrayou      |     115 |
| 6277 | krezol                        |     114 |
| 2978 | Fabrice.ltn                   |     113 |
|  784 | [AF] Hildor                   |     110 |
| 2479 | skgiven                       |     108 |
|  728 | frankhagen                    |     107 |
| 2762 | [AF>Libristes]IxPo            |     107 |
|  801 | Maxwell [MM]                  |     107 |
+------+-------------------------------+---------+
50 rows in set (0.28 sec)

[Maxwell]

I could do that easily enough, but remember it's only based on users who have switched on their flag at WuProp to allow the hours data to be exported.

You are awesome, Bok! And yes - I knew that regarding exporting. I just think it's fun tracking and comparing numbers, and I didn't have a good way to do that for WUProp hours. Thanks!

[Bok]

Have a think about what you'd like to see and I'll try and make it happen... but yeah, I think these could even be new MM categories...

[Maxwell]

Have a think about what you'd like to see and I'll try and make it happen... but yeah, I think these could even be new MM categories...

What I'm envisioning is a box on your individual WUProp page that has "WUProp Mega Milestone" almost exactly like what you see on the individual stats pages. Like with the MM tables, under the "type" column, there would be links to the counts for everyone, and links to counts within the team under the "RankT" column.

Type     Many      RankT          RankP
1M Hrs    x           x            x
500k Hrs  x           x            x
250k Hrs  x           x            x
100k Hrs  x           x            x
50k Hrs   x           x            x
25k Hrs   x           x            x
10k Hrs   x           x            x
5k Hrs    x           x            x
2.5k Hrs  x           x            x
1k Hrs    x           x            x
500 Hrs   x           x            x
250 Hrs   x           x            x
100 Hrs   x           x            x

[zombie67]

| id   | nick                          | mycount |
+------+-------------------------------+---------+
|  797 | zombie67 [MM]                 |     242 |

Awwwww yeeeeeeeeea!

[Maxwell]

| id   | nick                          | mycount |
+------+-------------------------------+---------+
|  797 | zombie67 [MM]                 |     242 |

Awwwww yeeeeeeeeea!

Of course, the last thing we need is more categories where zombie67 is in the lead by a ginormous margin...

[Bok]

well..

mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100000 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
| id   | nick                          | mycount |
+------+-------------------------------+---------+
|  795 | Mumps [MM]                    |      18 |
|  857 | [SG-FC] hl                    |       8 |
| 7422 | tng*                          |       6 |
| 1608 | Bikermatt                     |       5 |
| 1535 | ..:: Thor ::..                |       5 |
| 1912 | PanStaszek                    |       4 |
| 6957 | Sylvester@Planet 3Dnow!       |       3 |
| 8445 | Grandpa                       |       3 |
| 6433 | PERPLEXER ~ Thomas Huettinger |       3 |
| 6971 | JagDoc                        |       3 |
| 5500 | Bryan                         |       2 |
| 7222 | Gandalf_the_Grey              |       2 |
| 2482 | LCB001                        |       2 |
| 6154 | guiyuan                       |       2 |
|  797 | zombie67 [MM]                 |       1 |
| 1169 | Coleslaw                      |       1 |
| 2536 | james ying                    |       1 |
| 6467 | leprechaun                    |       1 |
| 6736 | JugNut                        |       1 |
| 4971 | ArcSedna                      |       1 |
| 1953 | bundaboy                      |       1 |
| 7306 | Perry Maskell                 |       1 |
|  631 | Mad Matt                      |       1 |
+------+-------------------------------+---------+
23 rows in set (0.09 sec)

[Maxwell]

Yeah - he's the other one.

[Mumps]

well..

mysql> select a.id,b.nick, count(*) as mycount from wuprop_hours a join stats.boinc_user b where b.proj = 'wup' and a.id = b.id and a.running0 > 100000 group by a.id order by mycount desc limit 0,50;+------+-------------------------------+---------+
| id   | nick                          | mycount |
+------+-------------------------------+---------+
|  795 | Mumps [MM]                    |      18 |
+------+-------------------------------+---------+
23 rows in set (0.09 sec)

Awwwww yeeeeeeeeea!

I can't believe that there's still a chance to be the first person ever with a 100K Hours star...