•Worksheet Validation - The forms validate the data using lists of values, date formats, field lengths and some other field level validation.
•Upload Validation - The upload process will perform the worksheet validation above as well as the validation within the AMG.
Data keyed directly into the worksheet (not via the forms) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the appropriate form. Any incorrect data will appear in red on the form, also changing the offending cell on the worksheet to red. Most but not all possible errors can be identified this way.
