Exporting results from a competition

Export options

When exporting results from a competition, there are available some options in the export dialog

Use decimals

Setting     Each shot counts as Example
Off     Whole points A shot of 10.7 counts as 10
On Points with one decimal A shot of 10.7 counts as 10.7

This setting only changes the scores. Inner hits are counted regardless of these settings.

Split into sub-series

Normally, the file has one score for each series in the shooting program. Turn on Split into sub-series to divide each series into smaller groups of shots, and use the slider to choose how many shots go in each group (1–20).

This is useful when you need sums for every 10 shots, for example. If a series can't be divided evenly, the last group gets the shots that are left over.

Example: with 10 shots per sub-series, a 25-shot series gives three sums: shots 1–10, shots 11–20 and shots 21–25.

The sub-series are numbered continuously through the file. If each series gives three sub-series, Sum 1–3 come from series 1, Sum 4–6 from series 2, and so on. The file does not mark where one series ends and the next begins.

File format

Rows

  • The first row holds the column headings.
  • Each following row holds one shooter's result in one shooting program. A shooter who shot two programs in the same competition gets two rows.
  • Only shooters who have results are included. Results without a shooter name are left out.
  • Rows are sorted by Total sum, highest first. Shooters with the same total are not separated by inner hits.

Columns

Column Description
Shooter name The shooter's first and last name
Shooter ID The shooter's ID in the organisation, for example a membership number. Empty if the shooter has no ID
Club The shooter's club
Class     The shooter's class
EventID The ID of the shooting program the result belongs to, for example DFS_100M_35_SHOT. Use it to tell rows apart when a competition uses more than one program
Event name Not in use. This column is currently always empty
Sum 1 The score for series 1, or for sub-series 1 if you split the series
Inner hit 1 The number of inner hits in series 1 (or sub-series 1)
Sum 2, Inner hit 2, ... The same two columns are repeated for every series
Total sum The total score: all Sum columns added together
Total inner hit The total number of inner hits

Notes

Below are some important notes related to the export format

  • Shots that weren't fired count as 0. If a shooter fired fewer shots than the series has, the missing shots add nothing to the sum.
  • Shots with an error status are not counted.
  • Inner hits are hits in the inner ten (often marked with an X), as defined by the target used.

Example files

DFS 25-shots export example file