| CDP | NewClassLookup!A7:B11 | Equipment Divisions to Classification score table lookup. |
| ESP | NewClassLookup!A13:B17 | (Equipment Divisions Must be in alphabetic order) |
| ESR | NewClassLookup!A25:B29 | |
| SSP | NewClassLookup!A19:B23 | |
| SSR | NewClassLookup!A31:B35 | |
| 0.00 | MA | CDP Division Class scores |
| 91.77 | EX | (Best score you can shoot without making Master Class) |
| 111.44 | SS | |
| 141.83 | MM | |
| 195.01 | NV | (Best score you can shoot without making MM class) |
| 0.00 | MA | ESP Division Class scores |
| 89.42 | EX | |
| 108.58 | SS | |
| 138.19 | MM | |
| 190.01 | NV | |
| 0.00 | MA | SSP Division Class scores |
| 98.83 | EX | |
| 120.01 | SS | |
| 152.74 | MM | |
| 210.01 | NV | |
| 0.00 | MA | ESR Division Class scores |
| 100.83 | EX | |
| 122.01 | SS | |
| 154.74 | MM | |
| 211.99 | NV | |
| 0.00 | MA | SSR Division Class scores |
| 104.36 | EX | |
| 126.30 | SS | |
| 160.19 | MM | |
| 219.51 | NV | |
| This is the data lookup table used to determine the shooters' new classification shown in column G of the main scoring spreadsheet. | ||
| It is arranged slightly differently than the official IDPA classification chart, due to requirements of the Excel VLOOKUP-in-range function. | ||
| Specifically, this table is arranged from the shortest time to the longest time, top-to-bottom. | ||
| Therefore, the times shown to the left of each class are the FASTEST time you can get, and still stay in that class, without being promoted to the next higher class. | ||
| Sorry for the confusion, but this is just how Excel VLookup works! | ||