We need a script written that will access a website with our user name and password, run a search based on two, simple criteria, and generate a list of names and addresses.
That list will then be exported to an Excel spreadsheet.
The software then will re-arrange the order of the data, separate some of the fields into separate columns, convert names from all caps to first initial cap followed by lower case letters, and conduct a simple zip code look-up, inserting the zip code into the appropriate field.
The spreadsheet will then be saved and accessible to us for export into another program.
## Deliverables
For a better look at what our input and desired output will look like, go here:
<[login to view URL]>