Our Knowledge Base article Stop "Double Dipping" for Age Group Award will explain the basics of double-dipping. This article will discuss an advanced double-dipping setup where you have a MasterRank and a GrandMasterRank.

User-Defined Fields/Fcts.

First, create UDFs to help us organize the various filters needed for our rankings. Listed below are the UDFs you will need.

These two UDFs check for rank eligibility. For example, IsMaster checks to see if the participant is aged 40 to 49.

[Age] IN "40-49"

[Age]>=50

The award depths UDFs are where you store the award depth value for each ranking.

These three check to see if someone is an award winner for that ranking. For example, IsGenderWinner checks to see if someone has a GenderRank greater than 0 and a GenderRank less than or equal to the GenderAwardsDepth. If they do, they are considered a winner for that ranking which will be represented by the number 1. Those who do not fit this filter will be represented with the number 0.

[GenderRank]>0 AND [GenderRank]<=[GenderAwardsDepth]

[MasterRank]>0 AND [MasterRank]<=[MasterAwardsDepth]

[GrandMasterRank]>0 AND [GrandMasterRank]<=[GrandMasterAwardsDepth]

Rankings

The above UDFs can now be used to filter your rankings.

[Finished] AND [Status]=0

[Finished] AND [Status]=0 AND [IsMaster] AND [IsGenderWinner]=0

[Finished] AND [Status]=0 AND [IsGrandMaster] AND [IsGenderWinner]=0

[Finished] AND [Status]=0 AND [IsGenderWinner]=0 AND [IsMasterAwardWinner]=0 AND [IsGrandMasterAwardWinner]=0

GenderRank has the default filter checking for if the racer finished the race and if their status is normal (represented by a 0).

MasterRank, we add the filter

AND [IsMaster] AND [IsGenderWinner]=0

IsMaster checks to make sure the participant is eligible for the MasterRank. [IsGenderWinner]=0 checks to make sure the participant is not a GenderRank winner meaning they are not within the specified awards depth for GenderRank.

GrandMasterRank has a similar filter to MasterRank. The only difference is that IsMaster is changed to IsGrandMaster.

AgeGroupRank filters by all the IsWinner UDFs since it is last in the ranking order, we want to make sure that none of the previous winners are eligible for the AgeGroupRank.

Output Report

For an advanced awards report, please see Advanced Awards Report (Different Award Categories in one List).

To add a basic output report for MasterRank and GrandMasterRank you can simply copy the Gender Results report from our standard template. Make sure to update GenderRank to MastersRank in all three sections, Grouping/Sorting, Fields/Columns, and Filter.

Attached to this article is a copy of a basic event file with all of these functions, rankings, and output reports.