I have an exccellent 9.9 rating as a Rentacoder Buyer, and did this same exact project a year ago. The Coder from last year is unavailable.
The website [url removed, login to view] has a listing of about 1800 companies exhibiting at an upcoming trade show (click the "Exhibitor List" link in the left column.) Each entry on the list is clickable to provide a database record for that company. I need you to convert these 1800 records into a single excel file.
All data may be included if easiest, but required fields are:
Business Name (the main bold title)
Business Address 1
Business address 2
Representative (only the first name listed)
Representative title (if indicated for that first name listed)
Exceptions: If the same company is listed multiple times (e.g. Browning), then the coder has the option to omit all but the first record.
If your automated solution requires a small change to the above (such as having the entire business address in one field, or including all the representatives, not the just the first one listed) that may be acceptable, and variations should be listed in your bid.
Project includes one or two minor unspecified modifications to the complete file (such as inserting "owner" where the representative field is blank, or other minor formatting changes.)
Obvious duplicates should be removed.
Typographical and transcription errors are unacceptable, so automated procedures are required. Project output to MS Excel.
This has been done previously, and last year's files, including the script info will be provided (and likely added here by Nov 15 or earlier - as I'm away from a computer with winzip). Please do not assume that all the data is formatted the same this year, and that the script will work without modification.