This project is to enter and sort data into excel.
The data can be manipulated using excel functions and can be completed very quickly if you are familiar with excel.
I have started to compile a list of indoor rock climbing gyms from [url removed, login to view] and other similar websites. Please see the attached file.
In the file I have begun to list states of all the gyms. Not all of the states are completed, and not all of the states are formatted how I need them.
The deliverable is as follows:
Using all the data from all of the worksheets in the attached file, compile the data into worksheets that list all of the climbing gyms by their state and/or canada.
Also, put all of the formatted lists of gyms by state into one large worksheet that uses the same formatting and has all of the gyms for the united states and canada.
You will see in the document that after I list some of the states I have other datasources. All of this data is included in the project scope. You will have to check for duplicates. Duplicates should be deleted. If there are any discrepancies in the data, highlight the text in green, and alert me at the end of the project to all of the discrepancies.
The worksheet for California contains the proper organization and formatting for the gyms. The project will not be considered complete until all data is correctly formatted and sorted.
Below is a description of all the desired fields in the spreadsheet. It is your responsibility to categorize the provided information, not to search for information on the web. If data is missing, leave the field blank. All fields are to be formatted as text, except for the zip code and the gym sq/ft.
Name - This field is for the name of the gym
Name 2 - This field is for the occasion when there are multiple names for the same entry -Format: text
Street - This field is the street address
Street 2 - This field is for the building number, or any other aspect of the address, including PO BOX
City - This field is for the city where the gym is located
State - This field is for the state where the gym is located
Zip - This field is for the zip code of the mailing address for the gym
Phone - This field is for the primary phone number
Phone 2 - This field is for the secondary phone number
Web - This field is for the gym's website
Contact - This field is for the name of the contact person, if applicable
Email - This field is for the email for the gym or the contact person
Gym sq/ft - This field is for the size of the climbable area of the gym. It is sometimes noted in the comments.
Comments - This field is for any comments about the gym.
Please review the worksheets prior to bidding.
33 freelancers are bidding on average $57 for this job
Hello, We have very good knowledge in excel. Pls check PM for more details. Thank you
Ready to start immediately on your project, as I'm the expert in such things. Waiting for your selection. Thanks!
Ready to start the work immediately. Please refer PMB. Thanks.
We've looked at the workbook and the project seems clear. We can reorganize the data into a single consistent spreadsheet and remove the duplications. Bryan Forst Uddami Software Services
Hi, I have exceLlant knowledge in [url removed, login to view] PM. Thanks.
Hi There I can do this work I have done a project like that in which population was sorted out by states. hope you will find me good in this regard and will find good and efficient work from my side inshAllah. waiting Daha Fazla
we can do your project. we have good experience in this field. we are living in Montreal, Please contact me.
I immediately start on this project, I have knowlege & Experince in excle. Waiting for your Favourable Reply. Have Good Day, Thanking U!
I'm very much familiar with excel, spreadsheets. I'll be able to complete this project in 7 days times with complete accuracy.
We have gone through the data attached and will be able to do this task as per your requirement.
Hi, there. I'm interested in assisting you with this project. I'm a 3rd year psychology student, and I do freelance work from home. I also have good experience in the IT industry which ensures that I'm very familiar Daha Fazla
We provide word-processing from speeds of 50wpm to 100wpm, data entry, 1600 keystrokes, spreadsheets, technical writing, medical, legal and general transcription and financial reports. We have been in business for t Daha Fazla