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

Chiuso

Pubblicato

più di 9 anni fa

$1500-3000 CAD

Pagato al completamento

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

Rif. progetto: 6626409

Info sul progetto

22 proposte

Progetto a distanza

Attivo 9 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

22 freelance hanno fatto un'offerta media di $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 in 3 giorni

4,6

(87 valutazioni)

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 in 20 giorni

4,9

(38 valutazioni)

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 in 7 giorni

4,9

(36 valutazioni)

4,6

@KennySVG

Bandiera: SAINT VINCENT AND THE GRENADINES

A proposal has not yet been provided

$1.500 CAD in 21 giorni

5,0

(20 valutazioni)

4,4

@zebracaro

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

$1.500 CAD in 3 giorni

5,0

(3 valutazioni)

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 in 12 giorni

0,0

(0 valutazioni)

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 in 5 giorni

0,0

(0 valutazioni)

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 in 5 giorni

0,0

(0 valutazioni)

0,0

@bcdiss

A proposal has not yet been provided

$1.777 CAD in 30 giorni

0,0

(0 valutazioni)

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 in 4 giorni

0,0

(0 valutazioni)

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 in 3 giorni

0,0

(0 valutazioni)

0,0

@madhava86

A proposal has not yet been provided

$2.500 CAD in 30 giorni

0,0

(0 valutazioni)

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 in 3 giorni

0,0

(0 valutazioni)

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 in 7 giorni

0,0

(0 valutazioni)

0,0

@fxpk

A proposal has not yet been provided

$2.777 CAD in 18 giorni

0,0

(0 valutazioni)

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 in 15 giorni

0,0

(0 valutazioni)

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 in 30 giorni

0,0

(0 valutazioni)

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 in 3 giorni

0,0

(0 valutazioni)

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 in 15 giorni