Ariadne index page

 

Ariadne - Technical description

A444

Viking Team results report

Introduction

Viking Venlo has a special team race. In this team race the issue is not which team is the fastest, but which team improves most the times the members of the got in their individual event run.

The members of the teams must have an individual run result. On basis the ranking this individual run result the participants are triple wise assigned to a team. See function A380 for the team composition. Next the teams run the team race. The team result is calculated from the difference between the team result and the individual results.

Calculation of the team result

A team is composed of three members with adjacent individual results on the individual ranking list.

- member 1 result
- member 2 result
- member 3 result

- team result

Member results must be valid results and are only selected from members with a 'p' mark (for 'ploeg' ( Dutch for Team)) in the Competing-unit-name attribute of the competing unit record.

The team improvement is calculated as :

minimum ( (team result - member 1 result), (team result - member 2 result), (team result - member 3 result))

When the team improves, the improvement figure is negative. Therefore the min-function which takes the biggest negative figure, or the smallest positive figure. (A positive improvement figure means a worsening of the team result. In that case the smallest worsening counts.)

Remark: teams may have only two members.

Access path

F000-Menu  
R580-Viking-team-results (races)
R582-Viking-team-results-sub (team result)
R584-Viking-team-results-sub-sub (individual result)

Function structure

The R580 report selects and displays the event information.

Report Control Subform Query Table Attribute
R580-Viking-team-results     Q580-Viking-team-results T100-Current competition
T110-Program-block *)
T400-Race
 
  subform
Race-results
R582-Viking-team-results-sub     race-id
           

*) The team races to report are selected on basis of the program block they are assigned to. This requires there to be a special program block which contains only the special team races.

The R582 sub-report selects and displays the team information.

Report Control Subform Query Table Attribute
R582-Viking-team-results-sub     Q582-Viking-team-results-sub T040-Category
T400-Race
T450-Category-in-race
T500-Competing-unit
T510-Run
Q395-Viking-max-improvement
 
  subform
Race-results
R584-Viking-team-results-sub-sub     competing-unit-id
           

The R584 sub-report selects and displays the team member information.

Report Control Subform Query Table Attribute
R584-Viking-team-results-sub-sub     Q584-Viking-team-results-sub-sub T040-Category
T100-Current-competition
T200-Person
T230-Participant
T300-Club
T500-Competing-unit
T510-Run
 
           

 


Change history

date Ariadne version change
25 Sep 2004 4.2.5 First release