Race results

Hi everybody,

I need to make a table to include race results.

I have +/- 50 Pilots from several teams.

The pilots are in two different groups and each group has 2 races and the 12 best from each group go into a final race.

Every pilot may get points from 3 differents jurys.

Now I need to get an result for each race and final, each group and an overall result for a raceday.
As well I need an overall result for each team but here only the results from the 6 best pilots of each team should be calculated even though there could be more or less than 6 pilots per team.

Over a year there are 7 racedays.

Is there someone how could help me out with this because I'm stuck.
Many thanks in advance