176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Normalise data in Excel
Sign in to Add to Watch List

Admin Support > Other - Administrative Support

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jul 14, 2012

Job awarded.

Jul 11, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Jul 11, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

The purpose of this application is to clean a list of words and produce a normalised list.

Attached is a file called Wordlist to clean (this one is an excel spreadsheet). As you can see there are a number of words in this file. These are words that consumers have given us to describe companies. They are their words, so the data is quite dirty.

The problem is that the list is not normalised, which makes it impossible to analyse.

We want to build a tool (almost certainly as an Excel macro) that goes through the list and references it against a "normalised list". The normalised list will have a list or words in the way they are presented when typed in and then a list of normalised responses.

So ugly and uhgly would be normalised to Ugly
And Cheep and cheip would normalise to Cheap

Any words that do not match the normalised list are highlighted to the user who then enters a normalised version of the words (this pair is then added to the list of normalised words). Alternatively...

Sign in or Register to see more

Desired Skills
Microsoft Excel
Job ID: 31877298
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
I am a college student majoring in psychology. I have been working a data entry job for about a year and also have experiencing managing my own...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32030606  |  Submitted: Jul 17, 2012 13:12 ET 
Proposal SEALED

 India  |  
I am looking to apply through Elance, for either short-term or long-term, time jobs, that I am qualified for. My objective is to always provide...
4
  |  
 4.9   |  Private   |  3 Jobs
Bid ID: 31944223  |  Submitted: Jul 13, 2012 17:26 ET 
Proposal SEALED

 India  |  
We are doing Data Entry, Web Research, Data Minning, SEO , Data Conversion these kind of tasks to our client.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31943783  |  Submitted: Jul 13, 2012 16:58 ET 
Proposal SEALED

 United States  |  
Winner
I am very excited to help build and support your business by paying close attention to detail while providing an accurate and efficient result. I...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31923179  |  Submitted: Jul 13, 2012 00:11 ET 
Delivery
Within 1 week
$109.59

 India  |  
I work for a MNC Company. I have rich experience in excel automation (Macros / Website Scraping) as well as in windows applications (VB.NET with...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31922476  |  Submitted: Jul 12, 2012 23:21 ET 
Proposal SEALED

Unber B.      
Unber B.'s identity has been verified.  Learn More
 Bahrain  |  
Hello All I am here to serve, as a Data Miner, Web Researcher, Content Writer.I am hard worker ,reliable and quick learner, my first priority is...
Skills: English
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31909610  |  Submitted: Jul 12, 2012 12:05 ET 
Proposal SEALED

 India  |  
I have been working since long and I like working from home. However, I am very schedule oriented, detail conscious, do things persistently and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31903092  |  Submitted: Jul 12, 2012 07:48 ET 
Proposal SEALED

 Bangladesh  |  
hello, i have vast knowledge & working experiances about HTML5,microsoft word2010,online article writing & bloging,data entry,virtual assistant,web...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31895194  |  Submitted: Jul 12, 2012 02:00 ET 
Proposal SEALED

 Malaysia  |  
i'm a system analyst with 12 years experiences in software development, microsoft office expert.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31891109  |  Submitted: Jul 11, 2012 22:06 ET 
Proposal SEALED

 United States  |  
Accomplished Analysts with 10+ years of experience in financial analysis, Data Analysis, Financial Modeling and Statistical Analysis, Mathematical...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31890656  |  Submitted: Jul 11, 2012 21:34 ET 
Proposal SEALED

 Bangladesh  |  
3 years working experience as an Information Analyst in a multinational bank. Energetic and motivated with proven ability to effectively manage...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31885521  |  Submitted: Jul 11, 2012 16:03 ET 
Proposal SEALED

 Taiwan  |  
If you are looking for a high quality work with a fair price, then you have found the right person for your job. Though, I am currently pursuing...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31880861  |  Submitted: Jul 11, 2012 13:08 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »