Combine 5 data sets to make one master list. Clean, standardize and append records. We need a Toronto-based individuals who can do the job on-site.

$1500-3000 CAD

Закрито

Опублікований

over 9 years ago

$1500-3000 CAD

Оплачується при отриманні

We have 5 data sets of customers and prospects with company name, contact details and other relevant information. We would like to combine all five data sets to make one master list. The issue: a. Company name/ Contact names and address are not standardized. For example, one list might have the company name as "ABC Incorporated", another one will have "ABC Inc." and the third one might have the name as "ABC". b. One list might have three contact name under one company, another list might have 5 contact names and the third one 2 names. These names might be same or might have few duplicates. c. Number of fields (columns) vary from list to list. Which needs to be standardized. Data size: List A: 650 records List B: approx. 3,000 records List C: approx. 2,000 records List D: approx. 3,500 records List E: approx. To be determined (should be around 10,000)

Excel

ID проекту: 6626409

Про проект

22 пропозицій(-ї)

Дистанційний проект

Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

22 фрілансерів(-и) готові виконати цю роботу у середньому за $1 887 CAD

@Dhruvika111

Greetings! I hope you are doing well! We complete the task engaging 5 operators,due if we use any tools or software the output file have corrupted data. So for giving you a high accuracy work,we have to use manual process. Thanks Dhruvika

$1 500 CAD за 3 дні(-в)

4,6

(87 відгуки(-ів))

6,8

@greggfletcher

Unfortunately, i am not from Canada, but you might want to take my bid into consideration, if there isn't more suitable candidate. It won't take more than 3 weeks to merge and consolidate all ~19150 entries. Thank You. Best Regards.

$2 950 CAD за 20 дні(-в)

4,9

(38 відгуки(-ів))

6,5

@hdlong66

Hello, I'm not Toronto-based freelancer, but I am good in excel and able to deliver quality work. Kindly refer to my related projects at https://www.freelancer.com/projects/Excel-Format-Layout/Micro-Microsoft-Excel-Project.html https://www.freelancer.com/projects/Data-Entry-Excel/Fill-Spreadsheet-with-Data.6498192.html https://www.freelancer.com/projects/Data-Entry-Excel/Merge-edit-two-email-lists.html https://www.freelancer.com/projects/Data-Entry-Excel/Copy-spreadsheet-schedule-found-another.html https://www.freelancer.com/projects/Data-Analysis-Conditional-formatting.html https://www.freelancer.com/projects/Merge-Spreadsheets.html https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that.html https://www.freelancer.com/projects/Excel-Data-Processing/some-Excel-Work.6080256.html https://www.freelancer.com/projects/Enhance-Spreadsheet.html https://www.freelancer.com/projects/Excel/Write-some-Software.5960899.html Wait for your response. Thank you and Best regards,

$1 500 CAD за 7 дні(-в)

4,9

(36 відгуки(-ів))

4,6

@KennySVG

A proposal has not yet been provided

$1 500 CAD за 21 дні(-в)

5,0

(20 відгуки(-ів))

4,4

@zebracaro

i can do it for you quickly and exactly with vba . please give me your file .

$1 500 CAD за 3 дні(-в)

5,0

(3 відгуки(-ів))

3,0

@AndreasPant

Goodmorning, I am really good in the use of Excel and also a quick typist. If you choose me I will work with dedication and deliver this task as quickly as possible, with the right feedback from your part of course.

$1 500 CAD за 12 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@darodriguezrs

I have 6 years of experience in the field of database management in excel, through automating macros for better information management

$2 500 CAD за 5 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@bethena7

Major in Financial analysis and risk management, have experiemce of managing data. Currntly work in a top500 company and one of my weekly basis task is to build a report that includes approx. 3,000 data entries and provide analysis. For this project, I would like to use Excel macro or approprite formulas to sort and standardize provided data. I'm detail-oriented and very conscience. I'm able to work immediately. Please contact me to discuss further details. Thank you.

$1 500 CAD за 5 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@bcdiss

A proposal has not yet been provided

$1 777 CAD за 30 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@rakeshrinku99

I've a very good experience in Excel sheet work and Data entry jobs.I can perform this task effectively and efficiently. Thank U.

$1 666 CAD за 4 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@FAM2014

I have worked on this kind of project for some few years and in my career I have worked as Data Entry personnel. I also have experience in excel spreadsheet and MS word and with me you should be rest assured that your work will be done as accurate as possible to your satisfaction and you will always request for my service. I believe that my skills will be beneficial to you and I am ready to start work now.

$2 500 CAD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@madhava86

A proposal has not yet been provided

$2 500 CAD за 30 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@ForeignTree

confirm perfect solution for your excel sheet E as defined the calculation. it is also possinle that you would get it done in 2 days only.

$1 500 CAD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@Canutza

i am a very organised person myself and i understand this struggle, but i developed some skill for this kind of situations and working with this kind of data sets. Consider me!

$2 222 CAD за 7 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@fxpk

A proposal has not yet been provided

$2 777 CAD за 18 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@macroPOL

Hello, I'm Excel and VBA programmer with over 5 year of experience. I have written many different applications for Excel in recent years. I am confident that I can perform this task. I am currently working in a large trading company in Europe. Thank you very much Jan Krzyzak

$1 500 CAD за 15 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@milenajakov

I am new bidder but very good with, excel, e-mail, word, PDF, internet... I will be happy to help you with your project and provide you my best service. I have years of experience during my every day job. I can do a free test job, that way you can make sure that I am the right person for your job. Pay me only if you are satisfied!

$2 222 CAD за 30 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@markof83

I have a lot experiences with Excel data, I'm very good at standardizing data, finding duplicates, and working all that very accurately, and everything double check. If a get job I will work very hard and 100% meet deadline. Thank you for opportunity

$1 500 CAD за 3 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@scotttcg

Dear Employer I am a Freelancer, local to Toronto and have worked with Excel and VBA for many years. My strength is organizing and cleaning data. 1. The first action I will be taking is a general review of the data and columns and comparing them with each of the 5 sheets, to confirm their consistency. 2. I will create a new sheet and using VBA, draw in all the data from the original 5 sheets. 3. Using your expected conventions I will correct the company names with VBA and confirm the addresses are in the correct format. I expect with this number of records the contact names may need some adjustments as well. 4. I will add sort and filters to columns. For your information, I have been doing this work in Toronto as a contractor for 12 years for Enbridge Gas, CIBC, Rogers, OPG (Pickering and Darlington nuclear power plants), Honda and Bombardier Regional Aircraft. Please feel free too contact me for any further details. I enjoy my work and work very well with others. Thank you, Scott Bennett

$1 777 CAD за 15 дні(-в)