In this topic, you will learn how to export a list of reviewers from G5 to Excel.
Steps:
Click the Reviewer Pool menu item to begin the process of querying a list of reviewers to export to Excel.
Step 1Note: There are different ways to query reviewers. You may query all reviewers with certain key words in their profiles by using the Smart Search field. You may also query using a combination of parameters to display a list of reviewers from which to choose. For this example, the Last Name and State fields will be used.
Step 2Enter the information into the Last Name field.
For this example, enter a valid value e.g. "Reviewer".
Step 3Click the button to the right of the State field to display the list of states.
Step 4Click the DISTRICT OF COLUMBIA list item.
Step 5Click the Search button to search for reviewers which match the criteria.
Step 6Click the Vertical scrollbar to scroll down and view the search results.
Step 7Note: There are different role types in G5. Depending on where the reviewer is in the registration process, he or she may have one of three possible roles:
Other - This type of reviewer is not yet in the reviewer pool. He or she has registered in G5, but has not yet completed the Reviewer registration fields.
Potential Reviewer - This type of reviewer is not yet in the reviewer pool. He or she has registered in G5, and has completed the Reviewer registration fields.
Reviewer - This type of reviewer is in the reviewer pool, has registered in G5 and has completed the Reviewer registration fields.
Step 8Click the Export to Excel button to begin the process of exporting the search results to MS Excel.
Step 9The systems displays the standard MS Office exporting to Excel box.
Click the OK button to continue exporting to Excel.
Step 10Note: The data displays in an Excel spreadsheet. You may format the data as needed for analysis and save as needed to one of your directories.
Step 11Once you have saved the file, click the Close button to return to the G5 Search Results screen.
Step 12Click the Vertical scrollbar to scroll back to the top of the screen.
Step 13Note: If you would like to perform another search, you may clear your search terms and repeat the process.
Step 14Hover over the Main menu and click the Home menu item to return to the My Home Page screen.
Step 15Congratulations!
You have successfully exported a list of reviewers to Excel.