Data Entry, Manipulation and Gather

We are looking for a data set of 1400 records (Dataset 1) to be cross referenced against a data set of 34,000+ records (Dataset 2), both of which are in Excel format. We require 3 processes to complete the task

1. Using Dataset 1 find the corresponding record in Dataset 2 using Postcode, First Line address and Venue Name. Then transfer all data for the record in Dataset 2 to the corresponding columns in Dataset 1.
Matches may not be exact so some judgement will be required to decide the correct record. Use the following rules in order to determine the correct record
a. Text Match Postcode, First Line address and Venue Name
b. Text Match First Line address and Venue Name
c. Text Match on Venue Name and first half of postcode match. Where available provide a secondary visual check of the venue front - Use the record image URLs in Dataset 2 and the Google street view venue location (see process 3) using good judgement
d. Partial match on venue name and first half of postcode match. Where available provide a secondary visual check of the venue front - Use the record image URLs in Dataset 2 and the Google street view venue location (see process 3) using good judgement

2. When transferring record data the following changes are required:
a. Opening Hours - Split into opening time and closing time for each day of the week and input into the corresponding day of the week column in 24 hour format e.g. 01:00 for 1am or 13:00 for 1pm.
b. Features - Enter a Yes in the corresponding column in Dataset 1 if the feature is listed and No if not.
c. Facilities - Enter a Yes in the corresponding column in Dataset 1 if the feature is listed and No if not.
d. Image Urls - Add image url's from Dataset 2 to empty url columns in Dataset 1 only. Ignore the remaining urls if there are no more empty columns.

3. Each record in Dataset 1 needs the following information found and added:
a. The exact Latitude and Longitude of the venue and placed into the corresponding fields (The postcode listed in Dataset 1 will be a useful starting point) see fig 1.jpg
b. A Google street view URL that best display the front of the venue. e.g for the venue "Temple Bar, Frodsham Street, CH1 3JL" the generated url should be https://www.google.co.uk/maps/@53.1921441,-2.8884588,3a,90y,36.6h,88.49t/data=!3m6!1e1!3m4!1speiZa4gl4Z2M9JJwIc2e4Q!2e0!7i13312!8i6656!6m1!1e1
c. The TV region for the record using the postcode using http://www.digitaluk.co.uk/coveragechecker/. Although house name and number is requested it is not required. As an example the region is underlined in fig 2.jpg, Please do not include the word region when copying i.e "Tyne Tees" not "Tyne Tees region"

Successful applicants are required to provide 10 records as an example to show they are able to carry out work effectively.
Dataset 2 will be provided on acceptance of proposal however its is of similar structure to Dataset 1