Stats on Majestic12

Bok, I was wondering why is Free-DC ranked 6th on our Free-DC stats but the Majestic12 stats show that we are 4th overall?

Just curious.

It's because I'm calculating the team totals from the sum of the users totals (which may well be wrong, and I should change it..)

mysql> select team0,sum(metric1) as total from maj_user group by team0 order by total desc;
+---------------------+-----------+
| team0 | total |
+---------------------+-----------+
| | 674167922 |
| Team Canada | 426167364 |
| AMD Users | 360116540 |
| Team Kansas | 292245454 |
| X Grubbers Kick Ass | 261115500 |
| team lazytom | 260751208 |
| Free-DC | 192942450 |
| Busy nerds | 175215092 |
| Team Finland | 138542385 |
| Team Europe | 108886555 |
| 256/64Kbps | 107306388 |
| Team Iowa | 89059734 |
| TeAm AnandTech | 65032137 |
| Team Magion | 48976227 |
| Knights Who Say Ni! | 24129429 |
| Team Ninja | 17458333 |
| Team France | 16240000 |
| FBK | 13189239 |
| Seti.nl | 8752029 |
| Info Sharkz | 8594403 |
| Ars Technica | 7400000 |
| Rechenkraft.net | 5899906 |
| Team Deutschland | 300000 |
| Crunchers Inc | 280000 |
| DC-Gemeinschaft | 20000 |
+---------------------+-----------+
25 rows in set (0.00 sec)

It might be that you can't do this, like in sob. I'll switch it to use the team_total.csv scores instead. It might make the totals look screwy for a while though...

Bok

Thanks Bok.

Any chance of adding this project to the DCr and also the stats signature?

I will, just got a couple of other things I'm taking care of first.... :)

like

this

and

this

graphs are being tweaked for size right now...

I'll get the majestic12 stuff in the sigs and dcr tomorrow though.

Bok

:woot:

More stats!!!!!

I could kiss you right now, but I won't. I'll leave that to your wife ;) :thumbs: