I just found and fixed a fairly major bug in the calculation

This has affected the scores fairly dramatically, but I think they are correct now.

Let me try to explain for anyone interested

I get the total score for all teams in the project also in the DCR. This is something like, for r5prp for instance (where I noticed the problem)

select sum(a.metric1) from sob_team a,team_aliases b where a.team = b.sob and b.dcr = 'Y';

Now there are only two teams with r5prp teams set up. Free-DC and X-Grubbers, so this should bring back the sum of their two scores... But because there is a team of spaces in r5prp (correctly as there is in a number of projects), this matches to many of the rows in team_aliases which are spaces, so skewing the scores downwards because of this..

I added a condition to the where of ''and a.team <> '' to get around it..

Bok