Event: This event is a real triathlon reduced to a single Contest for simplicity. There is a full set of data in the event file which has not been reduced in any way. Scoring is setup using Splits based on Chip Time, and includes multiple bike and run laps.

Task: This task is all about extracting data in different ways, and some different types of calculations. We have designed 6 different parts to this task, which should be displayed in an output list, of which some requirements are outlined below.

• Create an Output list which shows how many positions each participant has gained or lost at their last split, this should be sorted and grouped by their last split, and then sorted in an appropriate order within that. 
• Create an output list which sorts participants by their deviation from the average Run leg time for their Gender
• Calculate each leg as a percentage of the participant's total time and find a way to display this
• Create an Output list to identify participants who have not completed the correct number of bike laps.
• Display the Speed for Bike Lap 7 in both km/h AND mph
• Calculate each participants Swim time as a percentage of the Swim time of the race winner for their gender.

Notes: In each part of the task think about the display of the data you are presenting, what more could you do to make this data meaningful and understandable to participants or spectators.

Some calculations will be best done directly in an output list whereas others may be simplified by using advanced Results.