WCA Workbook Integrity Checker

General Checks:

Names of competitors should be exactly identical to their name in the WCA database, if it already exists.
Date of birth should be in a format such as "mm/dd/yyyy".
Gender should be lowercase "m" or lowercase "f".
WCAid's should be of the format: 1234CAPS99
Make sure names and WCAid's match on all pages. Here is a useful formula to autofill country and WCAid using a name:
```
=IF(VLOOKUP($B5,Registration!$B$4:$D$66,2,FALSE)=0,"",VLOOKUP($B5,Registration!$B$4:$D$66,2,FALSE))
```
This can be put in the C5 cell of a workbook and propogated down. Similarly for country in the D5 cell:
```
=IF(VLOOKUP($B5,Registration!$B$4:$D$66,3,FALSE)=0,"",VLOOKUP($B5,Registration!$B$4:$D$66,3,FALSE))
```
Results should be sorted by average or mean (if applicable), then by best single result.
"DNF" and "DNS" results should be capitalized.
For combined final rounds, no result should be entered if a competitor did not make finals.
Times over 10 minutes should be rounded to the nearest second.

To-do:

Download this script:

Upload a workbook to check*:

*If you would like to use this script instead of downloading and installing it yourself, please contact us for a password.