Instructions

Event details :

This is a stage of the French Triathlon Grand Prix, on a Sprint distance format: 750 m swim, 20 km bike, 5 km run.

There is a female and a male category.

It is an individual race, with a team classification: the ranks of the 3 best athletes of a club are added-up, the team with the lowest sum wins. If two teams are on the same points count, the rank of the 3rd participant of the team is used as tie-breaker.

Each team starts with 5 athletes, some extra young athletes can take part, but they do not count in the team classification, and need to be excluded from the points calculation as well.

Your task:

Produce the following result lists:

• Overall results, men and women, with sector times: swim, transition 1, bike, transition 2, run. This list must include DNFs, DNSs and DSQs at the bottom.
• Team results, displaying all athletes of the team, sorted by rank or status.
• Details list, showing all splits and sector times, including bike laps and run laps. The sum of the lap times must correspond to the total bike / run times.

Note that some participants lost their chips and have no split detections, but their manual finish times are included in the detections file.

Files provided:

• Complete start list in Excel format, including assigned chip (Startlist_Chipfile.xls)
• List of timing points, expected detections and start times (Timing_Points_Start_times.xls)
• GPX course file (Course.gpx)
• Detections file containing all detections from the event (Detections.txt)
• Complete set of PDF results, to check your output against (Results.zip).

Submitting your work and stopping your time:

Once you have completed the task, check that the times and ranks in your PDF results match the provided samples exactly. The layout of the results is irrelevant, you can organise the contents as you want. Any incomplete or incorrect results will be penalised.

When ready to submit, compile your PDFs into a ZIP file, name the archive with your team number and team name, and upload it in my.raceresult.com using the link provided in the email.
Once the confirmation of your submission received, come to the timing desk with your chip and scan it on the USB Timing Box to stop the time.