I have a spreadsheet of approximately 100 entries for recent publications on a select themes.
The goal of this project is to find the Last author’s personal contact information, based on the name of the “Institute” using the last name cited in the “author” column. You will see under the author column, that each author is separated by a set of “//”. You are directed to capture only the last of these listed for each entry. To do this you must find the website of the institution, and try and locate a specific profile for the individual, or department. Many professors and scientists have their own web pages or URL’s on their university’s site, or have them hosted elsewhere. Please locate the personal information for every first author where possible, and copy their vital contact information, including: 1. Complete mailing address with mailstop and or department numbers etc “mail” 2. Email address 3. Direct Phone number (s). 4. First and last names (in separate columns) This document will be used for subsequent mail merge and related marketing efforts, so it must be formatted appropriately-remove excessive white space, non-standard characters, and reformat to appropriate title case etc. Please confirm that you can take on this assignment, and estimate completion date. Please review this thoroughly and be sure that you understand it completely before beginning any work. Please confirm that you understand this assignment and ask questions if you require additional clarification from me. |
