Announcer List

This list is intended for an announcer to be able to provide live updates to spectators, a separate output list will be created for each stage following the same format. 

To provide an overview of the stage, participants are sorted and grouped according to whether they have started, finished, or not yet started the stage, with participants currently on the stage (started) shown at the top, followed by those who have already finished and yet to start shown last. 

The sorting first assigns a value based on the special results for the stage, returning 3 for started (and not finished), 2 for finished and 1 for not yet started. This uses a switch() statement looking at the values of the StageX_Time and StageX_Start values.

The same logic is then used to group participants, returning the corresponding label for each possible value. 

Within each group participants are then sorted either by their stage finish or stage start times according to whether they have finished or not. These results store the time of day so the last to start or finish are shown at the top of the respective group. 

A final sorting is applied using the StageStatus() User-Defined Function which was built to sort participants who have not yet started the stage. 

The output then shows some fields specific to each individual stage. The first column first checks the StageStatus() for the corresponding stage and then either returns the value for ShowStatus() or the stage rank. 

The speed should only be shown if the participant has completed the stage, this is checked by looking at whether the decimal value is greater than zero. Similarly, if the stage has been finished then the stage time is shown, otherwise the ElapsedTime() function is used to show the participants' current running time on that stage. 

Stage Result List

This list groups participants by their category, sorting them by fastest to slowest. Speed, Time and Gap Time are the most important info to be displayed. Again, an example of the first 3 stages result lists is shown down below in the Presenter section.

Presenter

With the presenter tool, it is possible to show the live results of a specific stage, by loading the list for the announcer.
Playing with some CSS, you can add colors, format the list based on device width, add a background to make it look nicer and much more...

And for the LED Wall, it is possible to load a presenter with the final result of each stage at the end of DAY 1 and DAY 2, with the option to auto-scroll the list.