Combine and de-duplicate various date versions of excel spreadsheets into 2 master spreadsheet

$30-250 SGD

Completed

Posted

about 9 years ago

$30-250 SGD

Paid on delivery

Hi I am a researcher and I need someone to help me combine monthly versions of spreadsheet into an updated master spreadsheet. I have 2 sets of spreadsheets that I need this to be done. First Set of Excel Spreadsheet: EventsEye Number of Spreadsheet versions to combine: 7 versions EventEye_13 Jun 2014 EventEye_17 Jun 2014 EventEye_1 Oct 2014 EventEye_31 Oct 2014 EventEye_1 Dec 2014 EventEye_15 Dec 2014 EventEye_31 Dec 2014 I want to combine all the versions into one master spreadsheet. The master copy must have all the most updated and added records, and also all the past records. As these different versions are extracted over different months from an online directory, some information may be taken down whilst newer information are added (as seen in the latest version). In summary I want all the records to be in here (old + new) in one master spreadsheet. I need them the master spreadsheet to be deduplicated and only contain unique records. Second Set of Excel Spreadsheet: Jetro Number of Spreadsheet versions to combine: 7 versions Jetro_13 Jun 2014 Jetro_17 Jun 2014 Jetro_6 Aug 2014 Jetro_1 Oct 2014 Jetro_31 Oct 2014 Jetro_1 Dec 2014 Jetro_31 Dec 2014 Same instructions as per the first set of spreadsheet. In summary, I want 2 complete set of master database with everything in and updated. All records must be deduplicated accordingly. Selected freelancer needs to complete this activity within 3 days after being awarded the bid. Interested bidders please quote project reference - SLPJ_EEJT_2014. Please find attached 2 sample screenshot of the excel spreadsheet for reference.

Data Entry

Data Processing

Excel

Project ID: 7024498

About the project

24 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Halgren

Greetings I have experience in the data processing field and I can complete this task within 3 days as requested. However first I would need some clarification on two details: 1) So eventually you need 2 master spreadsheets (1 for EventEye and 1 for Jetro) or both sets in a single master spreadsheet? 2) Two entries are duplicates if they have the same Event Name, is that correct? Thank you for consideration.

$80 SGD in 3 days

4.9

(11 reviews)

4.4

24 freelancers are bidding on average $113 SGD for this job

@bayzidkhan

Sir, I am willing to do your project and ready to start work. I will provide you a good result . My aim is to satisfy my client by my work . Please response . Thanks

$100 SGD in 1 day

4.9

(190 reviews)

7.5

@hdlong66

Hello, I am highly interested in your project and able to deliver quality work. Kindly refer to my similar projects at https://www.freelancer.com/projects/Data-Entry-Excel/Merge-edit-two-email-lists.html https://www.freelancer.com/projects/spreadsheet-merge.html https://www.freelancer.com/projects/Merge-Spreadsheets.html https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that.html Best regards,

$175 SGD in 3 days

5.0

(145 reviews)

6.9

@raghav1101

Hi, I would love to work on this project. I have experience in similar projects and i am sure i can deliver within 24 hours. Kindly get in touch. Regards, Raghav Bansal

$85 SGD in 3 days

4.9

(99 reviews)

6.6

@gokulanand

Hello, I can get this task done using a Excel macro on a button click. I will make sure to get this done in the next 12 to 24 hours. Let me know if you are interested. Thanks

$70 SGD in 1 day

5.0

(100 reviews)

6.0

@bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.

$150 SGD in 3 days

4.9

(20 reviews)

5.8

@mdreju

To whom it may concern: Your project sounds feasible enough and all steps can be performed very easily, so it will be simple to integrate with any documents you may be using at this point. I have many years of experience in data entry, data processing, web research, and website scrapping. I am not a new at this site and I have already built some strong reputation and you can view my past working history and reviews here (https://www.freelancer.com/u/mdreju.html). If you assign me this project, this be done quickly and accurately. Please feel free to ask me if you want me to make a sample work on your project. I am always ready to do a sample so that you can be assured that I have enough quality to work on this project. Thank you for your consideration and best of luck with fulfilling this project. Sincerely, Md. Reju

$100 SGD in 3 days

5.0

(55 reviews)

5.8

@sangwanpankajs

SLPJ_EEJT_2014 Hello sir, I am good at excel, data processing and understood you project and would like to work on it Give me a chance to prove my skills , I will ensure you quality work and timely submission I will be worth it Looking for your message Thanks

$111 SGD in 3 days

4.9

(79 reviews)

5.3

@quickprogexpert

Hello, Greetings from Shweta. I have experience in handling excel files using perl. I can get this done in 2 days. thanks, Shweta

$100 SGD in 3 days

4.8

(34 reviews)

5.2

@prabakarm23

SLPJ_EEJT_2014 Greetings for the Day!!! I have 6 years of experience in .NET, Excel, word ,VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M

$83 SGD in 1 day

5.0

(50 reviews)

4.7

@sreejithakaz

I have over 9 years of experience in Excel, and VBA . I have developed several Tools, Automation, Dashboard, Database CRM and Tools using VBA. I have done similar project using VBA.

$98 SGD in 2 days

4.9

(12 reviews)

3.9

@kapekape

HI I AM AN EXPERT IN EXCEL, VB AND MACROS Please send me a message so that we can have a dialogue I am available now you can access my cell phone number from the freelancer site Project reference - SLPJ_EEJT_2014 Combining these sheets will be very easy, I have an existing program that will accurately merge these file, validate the outcome. Deduplication is easy. I have worked with excel for many years and used it for many different purposes. As a result of this I can create user forms, interactive sheets, connect to external databases, create reports and send information to other applications, complex calculations and Models. I can also sort out data as you require. I learnt these skills in laboratory background. At one moment in my career I was LIMS specialist for large complex laboratory. (LIMS – Laboratory information management system) If you have any questions please contact me. I am available now Regards Stuart

$80 SGD in 3 days

4.3

(6 reviews)

3.4

@byron743

'' SLPJ_EEJT_2014 ''hi, i am a professional data analysis with the skills tools ad experienced to deliver the quality results you seek and desire after. i am ready to discuss additional details and get started immediately

$216 SGD in 3 days

5.0

(1 review)

1.3

@abadh100

project reference - SLPJ_EEJT_2014 Dear Sir/Madam, I can work for your precious data and combine it to make master spreadsheet in efficient manner. Thanks Abadhesh

$155 SGD in 3 days

5.0

(1 review)

0.7

@satnamsidhu

"- SLPJ_EEJT_2014" I will move all your data from Events eye data and jetro in two different files. But i have a question do you need data from recent file to be replaced with previous file data OR both of them. Thank you.

$83 SGD in 3 days

4.6

(2 reviews)

0.8

@Mostert5

I am a hard working loyal person who enjoys taking on new challenges. I can easily work with others in a group and can also handle large tasks on my own. I am a go getter and like to set high goals for myself. I can be relied upon to take pressure off of colleagues and meet deadlines with minimal supervision. I have excellent communication, time management and organizational skills.

$194 SGD in 3 days

0.0

(0 reviews)

0.0

@jotey00

Hi, I have 15 years experience in Microsoft's Excel, so I can provide you a quality and affordable service. I am Microsoft's Excel Power Users and I can use most of the excel functions and features.

$100 SGD in 2 days

0.0

(0 reviews)

0.0

@sherif2010

A proposal has not yet been provided

$111 SGD in 2 days

0.0

(0 reviews)

0.0

@agullotti

Thank you for considering my bid. I can combine the spreadsheets according to your instructions and remove any duplicate entries. If chosen I can submit a sample file within 24 hours for you to confirm all instructions have been followed. I guarantee satisfaction if chosen; I hope to do business with you in the near future. Best regards, Tony Gullotti

$89 SGD in 3 days

0.0

(0 reviews)

0.0

@biexcel

at your disposal to discuss the details

$133 SGD in 2 days

0.0

(0 reviews)

0.0

@lo2ma

I can accomplish the job via a data integration tool called Informatica Powercenter and the job can be accomplished in no time (2 days) which accomplish the job perfectly. I'm an expert in Data Integration with 3 years of experience in Informatica ETL products. Looking forward to hear from you sir.

$155 SGD in 3 days