Under Lists it is possible to define an indefinite number of lists, useful to create participants lists, results lists and internal lists which will help you to proof check data.

In this template, you will find participant lists and result lists for each event.

The participant lists are each filtered by the additional field EventX, in order to display only the relevant participants;
The result lists are instead filtered by the TimeX01.Positive field, which returns 1 when a participant has a valid finish time.

The Final list displays the ranking of the whole series, by filtering only those participants who have at least participated to one event (thus they have a [Time1.Positive]=1), and sorts them by number of events completed (Z>A) and then by fastest to slowest(A>Z).