Em Andamento

Data Entry and Google Image Search - Wine Portfolios

The successful bidder will input individual wine information from a PDF of a wine wholesaler portfolio into an Excel spreadsheet to enable bulk upload of the data to a website. Some wine knowledge would be beneficial, but this is not essential. There are two main tasks, as follows:

1. Input wine data from wine wholesaler portfolios into a structured Excel spreadsheet. There are 75 fields in total for each respective wine, but of these only 14 are mandatory, including the following:

- Image ID (see task two below)

- Producer Name

- Wine Name (if any)

- Vintage

- Country

- State

- Region

- Appellation/Subregion

- LUC

- Wholesale Case Price

- Case Size

- Type (still, sparkling, fortified)

- Sub Type

- Variety

The complete data structure is available at the following:

[url removed, login to view]

Wine Variety is very important so in rare occasions where the portfolio document does not contain the information for the variety (e.g. it states only that the wine is a blend then leave the cell blank). Please do not guess - where a wine consists of multiple varieties then add the additional varieties in the subsequent fields.

Where Appellation/Subregion is not stated assume it is the same as the Region. Regions inside Australia can be verified here:

[url removed, login to view]

2. Google image search each specific wine producer to find and save an image for their logo. The logo is to be saved as a jpg file into a Google Drive shared folder. Please note - this does not need to be done for each wine, only for each wine producer as each wine producer will have multiple wines. Please also note it is the logos and not the respective wine labels that are required.

Please save the file name with the producer as the prefix. For example, the producer 'Two Hills' would be saved as [url removed, login to view] and this file name must be saved in the Image ID column.

You will need a Google account to access the folder to save the images, which is located here:

[url removed, login to view]

Tips:

The Wholesalers will usually list wines by variety or producer and in some cases by both. The Freelancer may need to refer to both in order to attain the necessary information.

Freelancers may find it quicker to use a PDF viewer to cut and paste the information into an Excel/Google Sheets spreadsheet and then split and clean the data before cutting and pasting it into the required fields. Alternatively, the Freelancer may feel more comfortable typing the data directly into the cells.

Habilidades: Processamento de Dados, Excel, PDF, Busca na Web

Ver mais: wine freelancer, wine com, wholesalers com, where to register as freelancer, where to find australia freelancers, vintage logos com, usp of freelancer in, use of data structure, type of data structure in c, type of data structure, tips to find a producer, tips freelancer, tasks available for freelancers, search in freelancer com, search in australia, search freelancers freelancer, search freelancers australia, search freelancer it, search freelancer by name, search for www freelancer com, search for https www freelancer com, search data structure, search australia, register as freelancer at freelancer com, production spreadsheet

Acerca do Empregador:
( 5 comentários ) SURRY HILLS, Australia

ID do Projeto: #6780590

Premiar a:

Hel2014

I have a fair knowledge of wine, use excel and the internet daily. I also understand the need for information to be accurate as the inclusion of assumptions in some fields invalidates all the information. Please Mais

$111 AUD em 3 dias
(0 Avaliações)
0.0

6 freelancers estão ofertando em média $152 para este trabalho

HongGiang

Hello sir/madam, I'm expert on data entry, web research, web scraping and other skills. I did a lot of research projects and data mining to help businesses/traders understand the market or competition. My favorite sear Mais

$210 AUD in 7 dias
(238 Comentários)
7.0
FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this. Regards

$147 AUD in 3 dias
(53 Comentários)
5.3
talhamunir2002

A proposal has not yet been provided

$147 AUD in 3 dias
(94 Comentários)
5.0
sg11513

HI, Greetings! I have gone through the project details carefully and would like to offer our services for your project assistance. We have recently completed similar assignment on wine data collection and upload Mais

$155 AUD in 3 dias
(11 Comentários)
4.0
onyiuzo

Hello, I am very proficient with all the skills you listed for this project. In addition to that, my excellent time management skill, and ability to pay attention to details will enable me provide 100% satisfaction Mais

$166 AUD in 5 dias
(0 Comentários)
0.0
ValTu

A proposal has not yet been provided

$120 AUD in 4 dias
(0 Comentários)
0.0