Event File
The relay consists of 4 team members, 2 males and 2 females. The first team member completes their triathlon before the next team member starts. 3 team members will finish at an alternative finishing line relay finish with the final team member running through the finish.
Timing Locations
Start, Swim Out, Transition Out, Transition In, Relay Finish, Finish
Result Calculations
Since each participant's start time depends on the previous team member's finish time, for this event type we will use the advanced results setup.
1 - 6: Times calculated for each split
10 - 20: Raw data from timing systems
30 - 36: Cumulative split times
101 – 102: Determine where the participant was last detected
Team Members
Participants are identified on course with a combination oftheir team number and letter to identify their position in their team. This can be calculated by combining two functions into one user defined field:
DisplayBib: [TeamID] & choose(right([Bib];1);"/A";"/B";"/C";"/D")
DisplayBib: Take the team index, which is the first 1 or 2 bib numbers from the participant's bib, and the right most digit of the bib, if this is 1, display A, if 2 display B and so on. Bib 133 would be translated as 13/C (TeamID 13, team member C)
Ranks
The HelperRank orders team members by their RelayID. The RelayID is taken from the last digit of the bib number (1-4).
Start Time Calculation
The first team member's time is calculated from T0, the following participant's times are calculated from the previous team member's finish time. Thanks to the dot logic we can identify the finish time of the previous team member as defined by the HelperRank (Rank100.Prev.T15).
switch([RelayID]=1;T0;[RelayID]>1 AND nz([Rank100.Prev.T15])>0;nz([Rank100.Prev.T15]))
Using RelayID the switch function identifies in which position the participant is starting, if RelayID is 1 use T0; if RelayID > 1 and the finish time of the previous team member is > 0 then use the finish time of the previous team member.
Finish Time Calculation
The first 3 team members use an alternate finish Relay Finish whilst the last team member uses the finish line. We can determine the finish location by using the choose function:
choose([RelayID];T15;T15;T15;T16)
If RelayID = 1,2 or 3 use time from TimingRun (T15), if RelayID = 4 use the time from TimingFInishLine (T16).
e.g. The raw finish time for team member C (relay ID 3) is determined from the finish of TimingRun.
Team Score Calculation
Team members are determined by having the same contest and club name to a maximum of 4 participants. The overall finish result is the minimum time for the Result AfterFinishLine which only the 4th team member receives.
Live Output List
To enable the grouping by finishers and location we have several layers of grouping and sorting.
- Contest and ContestName
- RelayID and RelayName
- LastSplit and LastSplitName
- Time102 Time of the last split
A live rank has been used to determine the position on the course at each of the timing locations. start, swim, transition1, bike, transition2, run and finish line.
The rank of the last split can be determined using Rank(x) with the LastSplitID Result:
Rank([LastSplitID])
Final Result
Grouping Participants by Team
To group team members we use the user-defined function OrTeamStatus([TeamTime.Rank]) & ".///" & [Club] & "///" & [CountryIOC] & "///" & [TeamTime.Time1]
This will group all team members and sort by the overall rank of the team score, club name, country and team time. If the team has a status of non regular, the team status will be shown.
Using "///" will push the field into the next column along.
