Requirements for Excel Clean up Project. *******Price fixed: $60+freelancer fee. *******
Please do NOT extract data. You must make edits in this worksheet (40,634 rows) and keep it intact.
You must review the ENTIRE WORKSHEET (ALL 40,634 ROWS) for the below to see where edits needed. Obviously, not every record has an issue and a lot of records are fine.
1) Ensure data aligns with the correct column heading (as one example, check that the address is actually under the address column)
2) The city/state columns must be fixed so they match the city/state listed in the address column. The address column is always correct SO pls use that as the guide.
3) Fix "Phone No" column. The correct std must be used, which must match the city/state in the address column. Phone number should be in the format std code-number without any spaces, special characters (e.g 011-22145673). Only one number per cell allowed. If the number is bad (cannot form a whole phone number with std code), delete it.
4) The clinic name and doctors name should be fixed where needed. Example - If clinic name i Dr Avy Dental And Medical Clinic, Doctors name should be Dr. Avy
5) Formatting needs fixing - remove block letters in names, addresses. Example- name should be Dr. Rao, not "DR. RAO"
6) All breaks/yellow rows in data set should be removed so dataset reads as a whole
7) Pin Code column - if the address column contains the pin code, copy that pin code into the pin code column (dont delete pin code from address column in the process.) if not pincode in address column, skip this.
Hi,
Please allow me to this job for you. I assure you that you will get 100% outcome. Please award me if you were satisfied with my previous work.
Best Regards,
Nishith Gupta
$64 USD en 5 días
5,0 (6 comentarios)
2,6
2,6
25 freelancers están ofertando un promedio de $99 USD por este trabajo
Dear sir/Mam, Let's start work right now and finished asap.I've lot's of experience similar project.I look forward to hearing from you.I know XL Formula to finish it quickly.I will complete it accurately no problem
Hello sir, i am master in excel , i know how to do this kind of work on Macro or formula, i have read the project and understand the out put you are looking for. waiting for your kind response to finish the work in time.
Hi!
Thanks.
After reading all instruction & understand. I'm willing to do this for you, can start immediately following your instruction.
Honest sincere professional.
Please give me the data sheet.
Regards.
Dear Project Owner,
I am interested in this project. I have understood the project requirement and able to complete this very carefully.
wish to get response from you.
Thanks
Seasons greetings,
I read and understand this job requires a lot of patience, commitment and attention to detail. I am a person who possesses all these characters in abundance, and that is why I feel I am a good fit for the position...I assure you quality and you wouldn't repent choosing me!!!
Looking forward to hear from you
Cheers
Dhivya
Hello
Greetings
I read the project description.I can do this work.
Being Indian i have thorough know about Pin codes
Kindly PM for further communication
Waiting for your positive response
Thank You
Hi, I am interested to work on this project and have completed similar Excel and data entry work projects with 100% accuracy. Please let me know if we can get started. I can complete the project in on time. If I am able to complete the project beforehand, I will deliver even sooner. I would like to have a look at the files before starting. Please send me the required details. Regards Kuberudu
Hi,
This is Papri dutta, belong from India. To proof myself, I will work harder and efficiently as your
requirement. I'm very much flexible with my work / working time.
I'm also having hold 2 years’ experience in web development (php,html,Css) filed and extracting data
from website, add coupon in a use base shopping cart so as your recruitment I released that, I will
served better this project rather than other.
i could be the best person for this work as im a very good writer and typist and i do possibly have a good eye to point out errors of the sheet paper documents etc.................
Hi.
Thank you for the opportunity extended.
Please let me know if you have any data entry work for me
Looking forward to hear from your end.
Regards,
Prabakar,
Hello, I am a regular Excel operator with the working knowledge on Excel. I understand that your projects needs some certainity and reliability with negligible errors and i aim to proceed towards that way. With my excel skills, I plan to complete your project in 3 days and request you to contact me and hire me for further details. Thank you.