I need to build a spreadsheet of about 500 facilities plus their operating stats for 10-40 years using public records on the web.

Basically, you would be pulling data and photos from several pages on two websites and put it on two Excel spreadsheet pages, plus rename the photos to refer to the facility name and put them in a zip file.

Below are the specifics (exact details, site, and sample spreadsheet will be given to low bidders).

First, visit the first website and on the left choose country, then click on each facility. For each, copy data from 14 fields

Second, click on Operating History and add the history for all years to page 2 of the spreadsheet. You should be able to do a COPY >> PASTE SPECIAL >> TEXT and the data will be in the correct cells.

Third, when you have entered all existing facilities from the first site, visit the second site, and Choose country, then facility, and for each, add seven fields of data not found on the first site.

If there are any facilities that were not be in the first list, they need to be added.

Fourth, click on the Photo Gallery, and if there are any photos, right click on them and save them renaming the file with the facility name+.jpg. Then enter the number of photos in the spreadsheet.

Fifth, go to a third site and verify country by country that we did not miss anything, and ADD the missing PLANNED and VAGUELY PLANNED facilities from their list.

The final spreadsheet should have about 500 records in the facility list, plus thousands of records in the history page, plus several hundred photos.

I have already awarded this project once, and the worker flaked out. Do not bid if you cannot do it, and you must be accurate, or I will give you a negative review.Attached file: NSPlants.xls
File info: Excel spreadsheet with starter data