14.8. Complans

This tab is in the Plan Setup tab.

The Complans tab is used to define the plans used in complex progressions.

Complans are defined in three tables: Complans, ComplanStages, and ComplanRules.

The Complans table defines the systems of plans. It contains one row for each plan within a system of plans. All plans in the same system share the same system name; each plan within a system specifies the number of entrants for which that plan applies. There can be multiple plans with the same number of entrants.

The ComplanStages table defines how many stages there are for a plan, the round number for each stage in the plan, and how many sections there are for each stage. Each row of the ComplanStages table represents one stage in one plan.

The ComplanRules table defines how finishers advance from one round to the next. Each row of the ComplanRules table specifies how one specific finisher progresses, from a specific round, section and finishing place to a specific round, section and lane.

14.8.1. Query and Edit Tabs

  • The ID field is the unique ID for this Site. The default ID prefix is SP

  • The System field is the name of the system of plans.

  • The Plan field is the name of a plan for a specified range of entries.

  • The Min Entries field is the minimum number of entries for which this is a valid plan.

  • The Max Entries field is the maximum number of entries for which this is a valid plan.

  • The Plan Order field provides a mechanism by which a specific plan can be selected from among multiple plans with the same entry counts. Within a group of plans with the same entry counts, each plan should have a unique number such that there is a specific order among the plans. Because a module function is applied to the plan selection numbers, the planOrder values should start at 0 and count up from there rather than starting at 1 and counting up.

14.8.2. Export

The Export tab in the Complans tab allows you to export your Complan data to a file, to be easily imported by another JRaceman user.

You can select one of the following export types:

  • Complan Setup includes all data about all Complans.

Select an output file, then press the Export button.

14.8.3. Table

ColumnTypeDescription
idStringUnique ID [primary key]
systemStringName of the system for this plan
planString Name of the plan for the specified range of entries
minEntriesint Minimum number of entries for which this plan is valid
maxEntriesint Maximum number of entries for which this plan is valid
planOrderint An ordering number among all plans in the system with the same entry counts.