已完成

Fill in a Spreadsheet with Data

该项目成功由sisicirnes ,以€100 EUR的价钱在5 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
€30 - €250 EUR
完成于
5 天
全部竞标
79
项目描述

Data need to be gathered from the webpage and put in the Google sheet. It should be a very simple, yet a bit time-consuming work due to a large amount of data.

All the process of gathering the data is explained. If you find any other way to be more effective, you are welcome to implement it.

Target data:

- football club name

- contact person name (up to 4 contacts per club)

- function/role of the contact person

- email

All the data can be found on the webpage [url removed, login to view]

The webpage is in German, however it is easy to deal with once you start.

Here is the link to the Google spreadsheet:

https://docs.google.com/spreadsheets/d/1iQaVYKNV8ewSeNqWtUR5Fmc0fOfXZy9WGPKKMji_mhg/edit#gid=1583841078

Steps:

1. To find the right league on the webpage, you should go under "TABELLEN & ERGEBNISSE" and find the right one of the 9 areas, then select the right league from the 2 drop-down menus on the webpage. The process is simple once you see it.

2. After you find the right league, you should fill the club names.

I suggest you choose the link "Statistik" and select the last table (called "Auswartstabelle"), copy it (select all the clubs in the league from the bottom to the top) and paste it to the Google sheet.

Then remove the unnecessary data so that only club names and underlining webpage links remain in the sheet.

3. To get the contact person names, click on the club name and check the link "Funktionare" and "Trainer".

Each club should have a name of the following persons:

- sportlicher leiter

- trainer (what is important here is that you choose the main trainer, usually this is the first one on the list)

- sektionsleiter

- obmann

Up to 4 contacts is needed, minimum 2 per club.

4. You fill in the role/position.

5. You copy and paste the email address.

In the sheet, there is an example to show how the data should look like.

As said, the task is simple for someone who is behind a computer and is able to click & copy the data in the sheet for hours. By the way, I have more such tasks to be done for someone who is interested in such work.

完成:

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online