Team Score Fields

After defining the Team Score with ID X, the following additional fields can be used (note that you can always replace TSx with the Team Score name, e.g. Team Results M/F.Rank):

Team Score ranks also use the field Dot Logic for additional formatting of ranks.

TSx.Rank
TeamScoreName.Rank

 

Rank of the team, e.g. 13

 

.P

Rank of the team with a period at the end, e.g. 13.

  .Th The rank as an ordinal value, e.g. 13th
  .Max Maximum rank given to a team in the group, or in other terms, the number of teams ranked in the same group as the considered participant.

TSx.DecimalTime1
TSx.DecimalTime2
TSx.DecimalTime3
TSx.DecimalTime4

Decimal times of the team

TSx.Time1
TSx.Time2
TSx.Time3
TSx.Time4

Formatted times of the team

TSx.Scored

1 if the participant was scored, 0 otherwise.
When using the option Max. No. Of Teams: 1 and show all participants, then not all team members will be scored.

TSx.Gender

Gender of the scored team members.
1=only men, 2=only women, 3=men and women

TSx.GenderAll

Gender of the team including all team members.
1=only men, 2=only women, 3=men and women

TSx.Position

Position of the athlete within the team, based on the results or order setting of the Team Score.

TSx.TeamIndex

Number of the team, if there are several teams for the same club.

TSx.Number

Number of members in the team.

TSx.NumberWomen

Number of women in the team.

TSx.NumberScored

Number of scored members in the team.

TSx.NumberWomenScored

Number of scored women in the team.

TSx.DecimalTimeTop1
TSx.DecimalTimeTop2
TSx.DecimalTimeTop3
TSx.DecimalTimeTop4

Decimal times of the first team in the ranking.

TSx.DecimalTimePrev1
TSx.DecimalTimePrev2
TSx.DecimalTimePrev3
TSx.DecimalTimePrev4

Decimal times of the previous team in the ranking.

TSx.TimeTextTop1
TSx.TimeTextTop2
TSx.TimeTextTop3
TSx.TimeTextTop4

Formatted times of the first team in the ranking.

TSx.TimeTextPrev1
TSx.TimeTextPrev2
TSx.TimeTextPrev3
TSx.TimeTextPrev4

Formatted times of the previous team in the ranking.

Team Scores: Accessing Team Members

When creating a race certificate for a team, you can access the data of all members of the team:


 
As you can see, you can access the data of the yth member of the team according to team score x via TSx.Py.

You can use this to turn the detailed team results ..


 
.. into a short version with one line per team, still showing the last names of the athletes.



How does this work?


 
TS1.Px is used to access the three names of the athletes and show them in one line. Without any other modification the list would look like this:

It would still show one line per participant. So we have to add the filter TS1.Position = 1. TS1.Position is the internal numbering of the team (1 => first team member, 2 => second team member, …), so the filter makes sure that only one record per team will be shown.

Team Lap Race: Additional Fields

When using the Team Score Lap Mode, the following additional fields can be used:

Individual participant fields:

TSx.Laps.Count Number of Laps by the individual participant.
TSx.Laps.Min   Fastest lap time of the individual participant as a formatted time.
  .Decimal ...as a decimal value.
  .Lap Lap in which the fastest lap time was recorded.

TSx.Laps.Avg

  Average lap time of the individual participant as a formatted time.
  .Decimal ...as a decimal value.
TSx.Laps.Max   Slowest lap time of the individual participant as a formatted time.
  .Decimal ...as a decimal value.
  .Lap Lap in which the slowest lap time was recorded.
TSx.Laps.Sum   Sum of all laps by the individual participant as a formatted time.
  .Decimal ...as a decimal value.
TSx.Laps.Last   Shows the formatted time of the participant's last lap.
  .Decimal ...as a decimal value.
TSx.Laps.Stages Determines the number of times a participant has been on the course, independent of the total number of laps.
TSx.Laps.Lemans   The difference between T0 and the first time recorded, for example in a Le Mans style start. 
  .Decimal ...as a decimal value.
TSx.Laps.Active

Determines if this participant is the current one on course. Only applicable when the lap timing point is after the changeover area.

TSx.Lap(n)   Shows the time for lap n completed by the individual as a formatted time.
  .Decimal ...as a decimal value.
  .Gun   Shows the total time after lap n completed by the individual as a formatted time.
    .Decimal ...as a decimal value.
  .ToD   Shows the Time of Day after lap n completed by the individual as a formatted time.
    .Decimal ...as a decimal value.

 

Team result fields:

TSx.TeamLaps.Count   Total number of laps for the team.
  .Women ...which were completed by female team members.
TSx.TeamLaps.Min   Fastest lap time of the team as a formatted time.
  .Decimal ...as a decimal value.
  .Lap Lap in which the fastest lap time was recorded.
TSx.TeamLaps.Avg   Average lap time of the team as a formatted time.
  .Decimal ...as a decimal value.
TSx.TeamLaps.Max   Slowest lap time of the team as a formatted time.
  .Decimal ...as a decimal value.
  .Lap Lap in which the slowest lap time was recorded.
TSx.TeamLaps.Last   Shows the last lap time completed by the team as a formatted time.
  .Decimal ...as a decimal value.
TSx.TeamLaps.Sum   Sum of all lap times by the team (excluding Le Mans start time) as a formatted time.
  .Decimal ...as a decimal value.
TSx.TeamLaps.Total  

Sum of all lap times by the team (including Le Mans start time) as a formatted time.

  .Decimal ...as a decimal value.
TSx.TeamLaps.Stages Sum of the total number of times each team member has been on course.
TSx.TeamLaps.Lemans   Le Mans start time of the team (it is only recorded for the first participant to cross the timing point) as a formatted time.
  .Decimal ...as a decimal value.
  .Bib Bib number of the team member who recorded the Le Mans time.
TSx.TeamLaps.Penalty    
  .Time   Sum of the team's penalty times.
    .Decimal ...as a decimal value
  .Laps Sum of the team's penalty laps.
TSx.TeamLap(n)   Shows the time for lap n completed by the team as a formatted time.
  .Decimal ...as a decimal value
  .Gun Shows the total time after lap n completed by the team as a formatted time.
    .Decimal ...as a decimal value
  .ToD Shows the Time of Day after lap n completed by the team as a formatted time.
    .Decimal ...as a decimal value

 

Additionally, TSx.TeamLap(y).P.SomeField can be used to access the particpant who completed lap y. For example this field would return the last name of the athlete who completed lap 25 according to Team Score 1.

TS1.TeamLap(25).P.Lastname