Data Collection project #2

Go to [login to view URL] If you click on one of the links in the 'Event Name' column, this will open a table of results. The task is to copy this data into a spreadsheet, make the corrections listed below, copy into the attached [login to view URL] file and then store this data and move onto the next file. Taking the first event in the list as an example - Indonesian Masters - copy the data into a spreadsheet. Here are the steps: 1/ replace the text 'T' in column A 2/ replace the text '-' in columns D-G 3/ replace any rows with no values (or only '-') in columns D-G 4/ copy the values from column A and paste into column H in the [login to view URL] file 5/ copy the values from columns D-G and paste into columns I-L in the [login to view URL] file 6/ use the text-to-columns command (with space as the separator) to split the names in column C. 7/ where the name information is across more than two cells combine the data so that the first name is in column C and the surname is in column D 8/ copy the values from columns C-D and paste in columns F-G in the [login to view URL] file. 9/ enter the relevant event information in cells A2-E2 in the [login to view URL] file (the sources for this information will be provided) If done correctly, the data should be the same as in the attached version of results.xls. I'm looking for this exercise to be completed for 457 events and completed in seven days. If you cannot meet this deadline, please indicate how many you will be able to complete alongside your bid price for that amount of events. I am happy to split this project across multiple freelancers if this means that the deadline can be met. Thanks for reading. Please provide an example of a completed [login to view URL] for any event listed at [login to view URL] so I can see that you understand the process.