Event: This event is a simplified version of a 25 hour team cycling race, with each team consisting of 4 riders. Teams may have 1 rider on course at any time and the winning team is the one to complete the most laps in 25 hours, and in the shortest time in the event of a tie. Teams may be all male, all female or mixed. The data has been invalidated after 20:31:00 to make testing the tasks easier. 

Task: Your task is to use the existing data in the event file to calculate some additional requirements for the event

• Calculate the gender of each team. This would most easily be done with TS1.Gender, however try to find an alternative solution which could be used in a file where team members are all stored in a single participant record.
• Find a way to flag when 2 riders from any team are on course based on the timing data available. 
• Create an output list which only shows participants who have been on course for too long which could indicate a puncture or crashed rider on course.

Notes: The event has 3 timing points - the Main Lap / FInish point for counting laps. After this is the pit entry which riders will only cross if they are entering the changeover zone. The third point is after the pit exit and is crossed by all athletes whether they just started after a changeover or continued without changeover. 

Team Score 1 is used to group team members by their team name, stored in the club field. It is not used for any scoring. 

For the third task there is a UDF created called "TimeNow", this is the format of the response from the Now() function set to a fixed time. If you plan to use elapsed time you may need to modify the time to make it fit, our suggested reference point is 20:37:00.