SSP 0 IDPA Match Scoring Spreadsheet Sort Key lookup table
ESP 1
CDP 2 Table used to convert IDPA Divisions and classes into numeric sort keys.
SSR 3 The sort keys can then be used with the total match scores to produce a sort by score within division and class.
The shooter's division is looked up in the upper table and converted to anumber.
MA 0 Then his or her class is looked up in the lower table and converted to a number.
EX 1
SS 2 A three-column sort on the division sort key first, class sort key next, and total match score third will yield a properly-ordered report.
MM 3
NV 4
0 MA This table is used to look up IDPA Classes using the numeric Class Sort Key value for purposes of promotions at sanctioned matches.
1 EX
2 SS
3 MM
4   Invalid Shooter Class entered on spreadsheet!