This is pretty basic right? For example Team X has four members, just add up the four member's scores for a time frame (we'll say a week in this example) and that's the team score for the week and then just do that for every team. And just update the total scores?
If that's it then wouldn't just creating a work book in excel that auto updates when entering in daily numbers be the best way to go? Granted, would take a little leg work getting it setup but after that it would be easy.
If that's all there is to it and there isn't someone who is taking this over yet let me know and I'll start to create the work book so it's ready to go for April.