Database calculations automated

I am looking to set up a database that can will automatically calculate some figures when a new data set is uploaded. At present, this is being done manually.

Every year a list of athletes is generated where they are assigned to one of 32 sports across two different levels (lets call then a or b).

I would like review these against the previous years intake to generate figures on:

a) the % on the b list which are new, i.e. they were not on the b list last year
b) the % on the b list that are still there from the previous year
c) the % on the b list that are no longer there as they have been promoted to the a list
c) the % from the previous year that are no longer there as they have been relegated / released from the b list

This needs to be done across a number of sports, and thus needs to allow me to separate out accordingly.