This task is useful for checking participants still on course and those who may not have completed the right number of laps on a particular part of the course. 

To calculate the number of laps completed from our Splits we use the .SplitCount field, this counts the number of Splits which have a calculated time up to and including the specified Split.  

The 2 Splits we need to consider are BikeOut, the start of the bike leg and BikeFinish which is the end of the last lap. 

By calculating the difference between these 2 Splits we can calculate the number of laps which have been completed. 

[BikeFinish.SplitCount]-[BikeOut.SplitCount]

For participants with all Splits up to BikeOut, then BikeOut.SplitCount will return 3
For participants with all laps completed up to BikeFinish then BikeFinish.SplitCountwill return 10

To find participants who have not completed all 7 laps we filter the Output list by those who have passed BikeOut already and who's SplitCount difference is less than 7.

The output is then sorted and grouped according to participants last split, first sorted by {LastSplit}.OrderPos from largest to smallest, so those further on the course will show at the top of the list, and grouped by {LastSplit}.Label. Within each group participants are sorted by BikeFinish.SplitCount so those with fewer laps completed are flagged first.

For each participant we show primarily the name, bib and lapscompleted using our calculation. We also use Position1 which gives a count of the number of participants in each group. This allows for a quick count of the number of participants still on course.