Note: I WILL CONSIDER YOUR APPLICATION IF YOU SEND ME YOUR WORK ON ONE TEAM. IF YOU DO IT OK I WILL HIRE YOU TO DO THIS JOB FOR 6 LEAGUES. NOTE: DO NOT USE HYPELINK FUNCTION OF EXCEL, manually insert hyperlinks instead
1. Open links https://int.soccerway.com/national/norway/3divisjon/2023/group-5/r73175/ https://int.soccerway.com/national/norway/3divisjon/2023/group-6/r73176/ https://int.soccerway.com/national/norway/3divisjon/2023/group-4/r73174/ https://int.soccerway.com/national/norway/3divisjon/2023/group-3/r73173/ https://int.soccerway.com/national/norway/3divisjon/2023/group-2/r73172/ https://int.soccerway.com/national/norway/3divisjon/2023/group-1/r73171/
2. Click on relevant division (I have attached a screenshot for Uruguay). You will see a table of teams in that league. Click on team name to go to their page. 5. On team page, you'll find the team's city, address (I need it as a hyperlink to google maps, info below), surface (if you click on the stadium logo – have attached a screenshot for where to click), venue capacity and the stadium name.
You can find a link to their website in soccerway– I want this one as a hyperlink (text in the hyperlink to be team’s name). I also want the team's website. An example for this is
8. I want the team's twitter profile as a hyperlink - search for "team name" + "twitter" in google and post the twitter link. searching for 'CA penarol twitter' will give you this
https://twitter.com/OficialCAP
10. Also, I want the "news" for the club. To do this search for the club name in google. Then click on news and give me that link. Example:
11. I want a link to total corner. Just search for team name + totalcorner in google (e.g. ca penarol totalcorner). For CA Penarol the link is
https://www.totalcorner.com/team/view/836
12. I also want you to search for the team in oddsportal. For CA Penarol it is:
https://www.oddsportal.com/search/CA%20penarol
13. Same as the above – but for bmbets.com. Example here
https://www.bmbets.com/search/?query=CA+Penarol
14. I want the "elevation" of the city. To do so search for the city name + country name + elevation in google. For CA Penarol search for "montevideo uruguay elevation" and the result should be 43metres.
15. I want a hyperlink to BBC weather for relevant city. E.g. for Montevideo it is (hyperlink should be team's name)
https://www.bbc.co.uk/weather/3441575
Search for city name + country name (e.g. montevideo uruguay bbc weather) Row number - column A Team name – B Soccerway link – C (hyperlink with text = team’s name) Transfermarkt link – D (hyperlink with text = team’s name) Flashscore link - E City - F Stadium name - G Country - H Address of stadium (google maps link) – column I (hyperlink with text = team’s name). Note that the stadium’s address should be in the final destination whereas the initial destination should be empty (I have attached a relevant screenshot) Division – J (e.g. primera division, not primera division apertura for Uruguay Primera Division) Surface – K. If it is artificial turf, just call it “artificial” venue Capacity – L Official website: M Twitter profile: N - (hyperlink with text = team’s name) Instagram profile: O - (hyperlink with text = team’s name) News: column P Total Corner link: column Q Oddsportal link: column R BMBets link: column S Elevation: column T (metres) Weather: column U (hyperlink with text = team’s name)
Note: For column H you need soccerway first, but then have to go to google maps