Fill in a Spreadsheet with Data

We need to build an excel spreadsheet and fill in with data selected form a PDF file. A) FIRST PART OF THE WORK TO BE DONE To do the work you need to build first an excel spreadsheet with the following fields (i.e. columns) 1) Name of the company Note: most part of them are Italian company 2) Address (e.g. Street, road, square, etc.) 3) City (eg. Bistagno, Sesia, Rome, ecc.) Note: some big cities such as Rome or Milan, are also County 4) County (e.g. Rome, Milan, Paris, etc.) Note: county is often between brackets ( ) and shortened, e.g. Milan is reported as (MI) or as MI, Turin as (TO) or as TO, Rome as (RM) or as RM. 5) Region (eg. Piemonte, Lazio, etc.) This is a list of regions in Italy:  Abruzzo  Basilicata  Calabria  Campania  Emilia-Romagna  Friuli-Venezia Giulia  Lazio  Liguria  Lombardia  Marche  Molise  Piemonte  Puglia  Sardegna  Sicilia  Toscana  Trentino-Alto Adige  Umbria  Valle d’Aosta  Veneto 6) Country (e.g. Italy, Spain, Germany, etc.) 7) Type of company – primary activity (e.g. Coffee machines producer- Professional) 8) Type of company – secondary activity (e.g. Coffee machine producer - OCS) 9) Type of company – third activity (e.g. Coffee machine accessories) Note: to decide what type of company is a selected company, sometime you need to visit their website. This a list of possible types of company:  Roasting company  Coffee machines producers- Professional (target [login to view URL], [login to view URL] and Bar and Pub)  Coffee machines producer – OCS (Office Coffee Service and Home)  Coffee machines producer – Professional and OCS  Coffee machine accessories (e.g. grinders)  Large-Scale Catering Group  Large-Scale Distribution Group  Coffee shops chain  Vending Group  Association  Magazine  Exhibitions  Vending machines and complements  Parts and accessories for vending and coffee machines  Coffee trading & logistic services  Hot drink producer  Roasting and processing machines  Analysis, control, measurement, marking and weighing  Packaging  Dispenser and materials for public places NOTE: YOU CAN ADD OTHER TYPES IF YOU THINK IT’S NECESSARY 10) Company description (to copy it when available in Italian, often contained in “Products & Brands”) 11) Turnover (when available) 12) Number of employees (when Available) 13) E-mail address 1 14) Email address 2 (if existing) 15) Fix telephone 16) Mobile telephone (if existing) 17) Fax (if existing) B) SECPOND PART OF THE WORK TO BE DONE We then need to fill it in with data coming from a pdf file (39 Mb - 314 pages with a lot of graphics - available on request). Information in the pdf file is not structured, so you need to look for and select it. Once populated the excel spreadsheet, you need to check the accuracy of the information (e.g. web site is correct? e-mail is correct?) For the company in the category “COFFEE MACHINES AND ACCESSORIES” of the pdf file (pag. 245), you need to do additional check. The company could have declared just a primary type of activity, but to have also a secondary or third type of activity. This is, for example the case of [login to view URL] that declares to be and OCS producer, but it’s also a producer of professional coffee machine and coffee machine accessories.