Tracking Team Skills, Peter Addor

In order to track the ability of a team to do its work it is necessary to know both how much skill the team has built up as a team and what the experience levels of the individual team members are.  By creating a matrix of team membership that includes both time with the team and individual experience levels it is possible to do this.  Using a fairly large array and the tricky SHIFT IF TRUE function it is possible to track team skills and their individual components with any desired degree of precision.