Website Matching

Delivered November 13th, 2021. Contributors: Emmanuel A., Kevin W., Folarin O., Emmad, Darius G., Mayank B. and

Part

of six

Part

Website Matching: Rows 2-102

The assigned companies in rows 2-102 on the "Companies to Match" tab have been matched to those in subsequent tabs of the attached spreadsheet.
FindingsOnly the following 30 companies are listed in the subsequent tabs:
Shanghai Pudong Development Bank Company
Intesa Sanpaolo
CK Hutchison
Prudential UK
Sunac China Holdings
Mizuho Financial Group
Gree Electric Appliances
Oil and Natural Gas Corporation
HuaXia Bank
China Unicom
Mitsubishi Electric
SK Hynix
First Abu Dhabi Bank
Canadian Natural Resources
New China Life Insurance
Bank Rakyat
Posco
Wilmar International
Shimao Property Holdings
Norilsk Nickel
Imperial Brands
Investor
National Thermal Power Corporation
Weichai Power
Samsung C&T
Samsung Life Insurance
Kubota
China Taiping Insurance
Loews
Evonik Industries
Research StrategyWe matched the assigned companies in rows 2-102 on the "Companies to Match" to those in subsequent tabs as required. We conducted a comprehensive search for the full company name, as well as variations on the company name. The matched companies were confirmed by using the data provided in the Companies to Match tab (e.g. sector, country, region). We also visited the websites for further confirmation. Only 30 companies were found in the subsequent tabs.

Part

of six

Part

Website Matching: Rows 103-203

The requested information on website matching has been provided in rows 103-203 of the attached spreadsheet.
Selected FindingsKajima was matched in tab K.
Bank for Foreign Trade of Vietnam was matched in tab V.
Sumitomo Chemical Company was matched in tab S.
Intact Financial was matched in tab B 
Research strategyWe leveraged the "find" feature in Google Sheets to search through multiple sheets for each company and provide the requested information. To ensure accuracy, each company name was searched in multiple ways. However, some companies were not matched with any other companies listed in the subsequent tabs. We have indicated as N/A in the respective calls.

Part

of six

Part

Website Matching: Rows 204-304

IntroductionThe companies in rows 204 to 304 in the "Companies to Match" tab of the spreadsheet have been compared to the companies listed in the subsequent tabs. Of the 100 companies 31 were matched in the subsequent tabs. Where applicable, the websites have been copied into column C in the attached project spreadsheet. Selected findings are presented below.

Matched Companies COSCO Shipping, and China Merchants Securities were identified in tab "C".
The Bank of Greece, and Brighthouse Financial were matched in tab "B"
 Helvetia Group, and Howmet Aerospace were located in tab "H"
Research StrategyUsing the "find" feature in Google Sheets we were able to search through multiple sheets for each company. To ensure accuracy each company name was searched in multiple ways. For example,Terma, was searched using the listed name on the "Companies to Match" tab , and then the search was expanded to Terma Group.

Part

of six

Part

Website Matching: Rows 305-405

IntroductionThe companies in rows 305 to 405 in the "Companies to Match" tab of the spreadsheet have been compared to the companies listed in the subsequent tabs. Of the 100 companies 27 were matched in the subsequent tabs. Where applicable, the websites have been copied into column C in the attached project spreadsheet. Select findings are presented below.
Matched Companies Coca-Cola Hellenic Bottling Company, and Cenovus Energy were identified in tab "C".
The Nippon Paint Company, and Nari Technology Development were matched in tab "N"
 Husky Energy, and Host Hotels & Resorts were located in tab "H"
Research StrategyUsing the "find" feature in Google Sheets we were able to search through multiple sheets for each company. To ensure accuracy each company name was searched in multiple ways. For example, Sino-Ocean Group Holding, was searched using the full name, and then a search was conducted for Sino-Ocean only.

Part

of six

Part

Website Matching: Rows 406-505

IntroductionThe assigned companies listed in rows 406 through 505 of the attached spreadsheet (on the "Companies to Match" tab) have been matched with those mentioned in the subsequent tabs.
SummaryUnicaja Banco's official website is available here.
The official website of Nippon Express is available through this link.
The official website of Ramsay Health Care is available through this link.
Research Strategy:To match the companies listed in the attached spreadsheet with those in the subsequent tabs, we utilized the "find" feature available through Google Sheets (ctrl F) and entered in the provided company names. We also searched for any variations of the provided company names, including acronyms. For any matches that we identified, we visited each of their official websites and utilized the information provided in the "Companies to Match" tab of the spreadsheet to ensure that they were a definite match. We then copied their websites presented in the subsequent tabs of the spreadsheet into column C of the "Companies to Match" tab. For companies that we were unable to identify a match for, we entered N/A (not available) in their respective areas of the "Companies to Match" tab. 

Part

of six

Part

Website Matching: Rows 506-605

IntroductionThis research compares the assigned companies present in rows 506 to 605 in the 'Companies to Match' tab of the attached spreadsheet with the companies listed in the subsequent tabs. Of the 100 companies listed in the 'Companies to Match' tab, we successfully matched 28 companies in the subsequent tabs. Where applicable, the corresponding websites have been copied into column C of the spreadsheet. Below are a few selected findings from the research.
Selected FindingsIDBI Bank was identified in the tab 'I' of the spreadsheet. Its website in the tab is listed as http://idbi.com.
Luzerner Kantonalbank was matched in the tab 'L' of the spreadsheet. Its website in the tab is listed as http://lukb.ch.
United Utilities Group was matched to United Utilities in the tab 'U' of the spreadsheet. Its website in the tab is listed as http://unitedutilities.com.
Kirkland Lake Gold was matched to Kirkland Lake Gold (KL) in the tab 'K' of the spreadsheet. Its website in the tab is listed as http://klgold.com.
Research StrategyTo match the companies listed in the attached spreadsheet with those in the subsequent tabs, we utilized the "find" feature available through Google Sheets (Ctrl+F) and entered in the provided company names. We also searched for any variations of the provided company names, including acronyms. For any matches that we identified, we visited each of their official websites and utilized the information provided in the "Companies to Match" tab of the spreadsheet to ensure that they were a definite match. We then copied their websites presented in the subsequent tabs of the spreadsheet into column C of the "Companies to Match" tab. For companies that we were unable to identify a match for, we entered N/A (not available) in their respective areas of the "Companies to Match" tab.