Data Scrub

Completed Posted Sep 30, 2015 Paid on delivery
Completed Paid on delivery

Directions

I am looking for someone that can complete our project in 12 hours (Please do not bid on this project unless you are 100% you can complete it by 3:00am (Pacific Standard Time, California Time) Please complete a couple of examples for me so I am able to check for accuracy and I can award the project right away.

Project Details:

1. You will be working with two spreadsheets

a. Spreadsheet Top 200_9302015 (For reference)

b. Spreadsheet VOIP_Inovation 9302015 (plug in data)

2. The data will be plugged into excel spreadsheet VOIP_Inovation 9302015, referencing data from excel spreadsheet Top 200_9302015.

3. First, you will search for the city and state on spreadsheet Top 2000_9302015 that corresponds to City and state on spreadsheet VOIP_Inovation 9302015 spreadsheet.

4. You will then use columns A (US POPULATION RANK), B (City), C (State) on spreadsheet Top 200_9302015 which need to match up with columns D & I on spreadsheet VOIP_Inovation 9302015

5. Then once you match up the city and state you will then plug into columns A (US POPULATION RANK), B (City), C (State) on excel spreadsheet named VOIP_Inovation 9302015

6. Please see my examples on spreadsheet named VOIP_Inovation 9302015 highlighted in Yellow.

a. Please be advised that both City and State columns need to match on both spreadsheets in order to plug in data onto spreadsheet VOIP_Inovation 9302015 from spreadsheet named Top 200_9302015

b. Please be aware that you will find duplicate city and states on spreadsheet named VOIP_Inovation 9302015, make sure you plug in the corresponding data to each of the columns like I show in my examples in yellow

c. If you can't find a city and state that correspond please use N/A in the cells, like I show in my examples.

Data Entry Data Processing Excel

Project ID: #8584252

About the project

14 proposals Remote project Active Sep 30, 2015

Awarded to:

safiqulislam67

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu More

$100 USD in 0 days
(70 Reviews)
5.8

14 freelancers are bidding on average $118 for this job

bpwebanalysts

Hi, I had a look at both the spreadsheets and also the brief document and I am clear on the requirements. And I am also sure that I will be able to complete this before 3:00am (Pacific Standard Time, California Time More

$200 USD in 0 days
(123 Reviews)
7.1
DeepSyaal

would you like to discuss with me

$45 USD in 1 day
(229 Reviews)
6.4
ahmedmalik0093

A proposal has not yet been provided

$250 USD in 3 days
(31 Reviews)
5.5
cgullapalli

Hi, I am good at excel. Looking forward to work on this project and discuss with you in the private chat.

$70 USD in 1 day
(74 Reviews)
5.1
Khurramz

Hi! Thank you for invitation. I can finish this in 12 hours. Please send me chat for sample work done quickly.

$50 USD in 1 day
(68 Reviews)
4.7
abumusalilla

Hi, I am available right now and interested in your work. I done your work as per your requirement also within time and budget. Contact me for better results. Thanks and Regards Asif

$77 USD in 0 days
(24 Reviews)
3.7
SidraMalik13

A proposal has not yet been provided

$166 USD in 3 days
(5 Reviews)
3.0
nurmohammad21

Hello Sir, I can do this easily... I have Eight years experience in Information and Technology. There I worked this types work most of the time…I assure that I will provide you Quality Work with 100% accuracy. Please More

$60 USD in 0 days
(9 Reviews)
2.2
GuruOfAutomation

Hi, My name is Hamid. I've good experience with such kind of work. I've understood the requirements and saw the attached documents. I shall deliver solution within few hours after winning the project. You can ask me More

$55 USD in 1 day
(0 Reviews)
0.0
shrinkcom02

I have around 3 years of experience in excel

$133 USD in 0 days
(0 Reviews)
0.0
jashy247

I can do this in 12 hours and I fully understand what you mean in the directions! I have a lot of experience in this field!

$333 USD in 0 days
(0 Reviews)
0.0
andreszapata1222

Hello, this validation of the data could make in a single day, it's easy work I can send them at this time, a move that I made stay tuned Thank you

$88 USD in 1 day
(0 Reviews)
0.0
kwisniewski91

Hello! I'm studing on University of Technology so i know MS Excel pretty well. Using PC, typing and couting is easy for me as well, so i belive i'm the best choice for this job. I didn't begin studies yet (it is next More

$122 USD in 1 day
(0 Reviews)
0.0