...
a. To upload the latest data to the GMEData.xlsx file, follow instructions below:
i. Click on Upload
ii. Select File – Ensure the file is named GMEData.xlsx
iii. Choose the File to Upload
iv iv. Click on Open
v v. You will get the following message
vi vi. Select Replace Button
...
b. IT will be getting the data from the ACGME tab and the Research Year tab. Please do not rename these
tabs
c. IT will be uploading the data from the following columns. Please do not rename these columns:
i. EMPLID
ii ii. Last Name
iii iii. First name
iv iv. Middle name
v. Program Start Date
vi. Program End Date
vii vii. Current Program
viii. Post Graduate Year
ix ix. Compensation Status
x x. Program ACGME Number
xi xi. Annual Comp Benefits
xii. Fiscal Year
2. ResearchControlResearchConrol.xlsx
a. To enter new values GME Percentage Used and Rent for a Fiscal Year, following the instructions
below:
i. Open the ResearchControl.xlsx file
ii. Enter Fiscal Year and GME Percentage Used values on the next empty row.
Please do not change the name of the columns
iii iii. The file will automatically autom tically save the changes