Data Scrub
$30-250 USD
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.
Project ID: #8584252
About the project
Awarded to:
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
14 freelancers are bidding on average $118 for this job
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
Hi, I am good at excel. Looking forward to work on this project and discuss with you in the private chat.
Hi! Thank you for invitation. I can finish this in 12 hours. Please send me chat for sample work done quickly.
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
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
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
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!
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
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