...

1. Must have a test date for each record.
2. Must have a Exam Name for each record.
3. Must have a valid Examinee Id (U-number) for a USF Health student.
4. Columns must be in the order indicated on the files in the Required File Format folder.
5. The excel sheet name should not have a '&' character.
6. File must be in .xlsx format.

...

1. Go to the folder location.
2. Go to Required File Format sub-folder and check for file formats.
3. Create/Download the new NBME Course data file(s) and save them with the same format as the above template filefile format from step 2. 
4. The file(s) should be named appropriately with a date appended in the end and saved as an 'Excel Workbook' (*.xlsx) to the respective course folder. 
   If there are multiple files for same course they all can be placed in the same location.

...

1. Go to the folder location.
2. Go to the Error Logs sub-folder, and then to the course subfolder.
3. Locate the error log file name mentioned in the email.
4. Open the file and check for the error records. Note that error records will not have scores provided. 
5. Use the file course number to identify the format of the corrected data files, and create new file(s) with the corrected data in the format specified in the Required File Format folder.
6. Rename the file(s) appropriately with a date appended in the end.
7. Save the file(s) as an 'Excel Workbook' (*.xlsx) to the appropriate course folder. (Course1, Course2, Course3, Course4, Course5, Course6, Course7)

Load Schedule

It is important that the Excel files be closed and are not open for editing before the load process begins. The load is expected to happen XXXXXXXXXX.