Đã Hủy

Wine list to Excel conversion and standardisation

I need assistance gathering wine list data from restaurant websites (normally in PDF), converting to Excel and formatting into a standardised 2 column list (wine name, colour) for upload into a database.

The challenge: restaurants lists vary in presentation from restaurant to restaurant, meanwhile I need standardised information. Converting each list into the required format requires a significant amount of manual intervention. Each list is different.

Issues

There are three principal issues / challenges: Colour – Name - Formatting

Colour (white – rose – red)

Wine lists are normally organised by colour / style – typically: sparkling wine (which are mainly white, but include rose), white wines, red wine, dessert wines (normally white), fortified (mixture of red and white). Lists normally include general headers white wines – red wines, etc, but not always, meanwhile I need a colour attached to every line in the csv output file

Name

I need wine names in a standardised format that the database will recognise.

The complete list of wines in the database can be downloaded for comparison – however, Excel VLOOKUP is not sophisticated enough for matching between the two data sets

Some wines include maker name + wine name + region + vineyard name. Others just include maker name.

E.g. for Bordeaux wines producer name only: Chateau Margaux. For Burgundy producer name + village name + vineyard name

Domaine ABC + Vineyard name + reference for Premier or Grand Cru + Village name

Producer names and wine are often in different cells – sometimes the producer name will be at the top of a sub section and the concatenation therefore needs an absolute reference

Formatting

Converting accented characters to non-accented

Removing and standardising certain words, phrases and characters

Removing blanks and reducing the list to a standardised three column format

Some of the formatting processes are relatively easy to run through VBA modules (e.g. find and replace / delete)

If you would like to help me please visit [login to view URL] for an example of a particularly long and complex list. Please convert the PDF into XL, format and send me a sample 20 lines in a 2 column file (name, colour)

I need this done quickly and with 100% accuracy.

Payment will be batches at the rate of $100 / 5000 lines of lines of output. Scope: 150 restaurant lists - size varies from list to list.

If you can come up with an automated solution using VBA so much the better

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Web Scraping, Tìm kiếm web

Về khách hàng:
( 0 nhận xét ) Delhi, India

ID dự án: #34380243

24 freelancer chào giá trung bình₹7053 cho công việc này

(27 Nhận xét)
5.6
arunodaya123

HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,RPA,P Thêm

₹6000 INR trong 6 ngày
(7 Nhận xét)
2.8
meena2246

I am good at typing with high speed at good accuracy. I have good command over Excel, Power point and word softwarre. I have handled same kind of projects before.

₹1500 INR trong 5 ngày
(0 Nhận xét)
0.0
Musyokajustine8

I have all the skills and experience listed in the job description. I am confident that I can solidly contribute to the success of the company. My self drive is an assurance that I will be able to deliver within the s Thêm

₹11000 INR trong 7 ngày
(0 Nhận xét)
0.0
ayushpinty143

Hi Dear sir/madam I am a proffessional data entry oprator Please asign me this project i will do my job best

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
zankrutipatel8

I ambestwriter . And all skill are prensent to this lroject requiredso plzz hired me and please one chance give me

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
Thameem809191

“I am interested in this job because it will offer me an opportunity to utilize my professional skills in typing and accuracy. I can type 75 words per minute with 95% accuracy. I believe that these skills will make me Thêm

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
rAj1king

I read your massage. I do it. Please send your data then I try it fast . Let me more Hopping to reply me Thanks

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
annweshab

I am especially talented when it comes to organization. I have worked in the financial sector before and am well versed with the basics and advanced of excel. As per my understanding, I have to organize a list of wines Thêm

₹6000 INR trong 8 ngày
(0 Nhận xét)
0.0
yogandhardewanga

Hello sir and ma'am I am Yogandhar dewangan and I am data entry expert and ms office tools my work is neet and clean I am do your work in time and fast ..... Give me opportunity to this work thanku....

₹3000 INR trong 1 ngày
(0 Nhận xét)
0.0
cbshada5

I am a Sommelier So i provided You The Best Wine List that You Are Looking For and i am good in data entry so in that project i give my best effort .

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
cheersoul12

i am a experienced data entry operator and i am expertin these projects and i am sure that you be happy by my works

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
kjabra

After reading through your requirements i belive i am the right person for the job i know exactly what needs to be done and there are better ways than vlookup

₹12000 INR trong 7 ngày
(0 Nhận xét)
0.0
Manojmanu619

Hello, I'm well experienced in data wrangling where I can extract data from websites and convert it to excel . I do my research well before starting this project about wine history and I'm curious to learn about it to Thêm

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
Diksha8916

I am a very creative person, I have worked for 3 months as a content marketing executive in Ahmedabad school of digital marketing, [login to view URL] I have written a lots of blogs and even edited their website co Thêm

₹12000 INR trong 7 ngày
(0 Nhận xét)
0.0
anilsharmaproch

I believe in quality work and customer satisfaction is our motives.i know you need quality work rather then quantity.

₹6777 INR trong 7 ngày
(0 Nhận xét)
0.0
mitanshuvish88

I found this job online and decided to apply because it seemed interesting, and things at my current employer seem a little uncertain. They’re laying off a lot of people right now, so I wanted to see what other options Thêm

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
este11

hello... i'm an excel specialist Give me a chance to make this work I will have the work ready in 5 days

₹6999.94 INR trong 7 ngày
(0 Nhận xét)
0.0
manishchaudhari7

I am expert in data entry work from my side let you get rid of any problem and finish your work before your due time I want to work not for you but for me

₹7000 INR trong 7 ngày
(0 Nhận xét)
0.0
joymahmud5

I am a expert data entry operator. I am interested to do this work . please give me this project.

₹1500 INR trong 5 ngày
(0 Nhận xét)
0.0