Stats coding for subteams/divisions have commenced Most of the backend already done, got some quick hacked pages to display the data out.
Lots to do still....interesting though. It's already generated 120,000 rows of data
Very brief preview....
Code:
mysql> select subteam,projrank0,metric1 as credits ,metric2 as RAC,teamrank0 from boinc_subteam where proj = 'dne' and teamid = 42 order by metric1 desc limit 0,20;
+--------------------------+-----------+------------------+----------------+-----------+
| subteam | projrank0 | credits | RAC | teamrank0 |
+--------------------------+-----------+------------------+----------------+-----------+
| AF>HFR>RR | 4 | 413444501.741201 | 1719911.450219 | 1 |
| AF>EDLS | 10 | 216556051.196711 | 983475.040841 | 2 |
| AF>Libristes | 11 | 196972112.197099 | 845104.424451 | 3 |
| AF>HFR>HOP! | 12 | 182042728.73951 | 482679.467339 | 4 |
| AF>Occitania>Lengadocian | 13 | 134746561.493026 | 593704.740611 | 5 |
| AF>Amis des Lapins | 14 | 119460275.647808 | 561980.199818 | 6 |
| AF>Quebec | 16 | 109398172.661261 | 606473.653509 | 7 |
| AF>Occitania>Gascon | 20 | 76822500.206671 | 245918.901825 | 8 |
| AF>HFR | 24 | 64938118.583758 | 329470.631848 | 9 |
| AF>Kirass>MPF | 25 | 64492006.202387 | 436618.641229 | 10 |
| AF>EDLS>Physique | 27 | 57763552.828209 | 476633.271865 | 11 |
| AF>WildWildWest | 28 | 55982679.839994 | 272633.894882 | 12 |
| AF>France | 29 | 54466685.53565 | 297207.197182 | 13 |
| AF>IJV | 32 | 46996707.421188 | 26572.791958 | 14 |
| AF>Libristes>GNU-Linux | 34 | 38559874.715097 | 117536.340171 | 15 |
| AF>HFR>MPT | 35 | 37166659.749998 | 31657.927201 | 16 |
| AF | 46 | 17093933.5 | 69177.30436 | 17 |
| AF>France>Est>Alsace | 47 | 16149337.999999 | 207735.831315 | 18 |
| AF>2TF | 48 | 15791156.442013 | 68192.930384 | 19 |
| AF>Le_Pommier | 49 | 14125187.135336 | 104648.373022 | 20 |
+--------------------------+-----------+------------------+----------------+-----------+
20 rows in set (0.00 sec)