The project requires cleaning, de-duplication, adding information, custom sorting and segmentation of a large list of names, emails, contact details and song requests.
The skill set required will be de-duping.
Manual matching of songs to internet sources to ensure appropriate correct formatting.
The task may require some macros or potentially web scraping.
In More detail.
I have a website where users request songs they'd like played on our show.
The website contains mandatory drop down fields from a database (that we need to develop out further) for users to chose from. However, if the drop downs does not have a song or artist available it allows users to enter their request freehand.
P1. The freehand request data needs to be checked if actually an artist and song is already in our database and if already available in drop down requests but was just missed. Post formatting the freehand requests to match the database, we also need to be verify if the song is within the shows programming parameters (that is the show plays music from 1950's-1980's... therefore any songs from the 90's must be removed from requests list).
P2. Once the data is cleaned the requests have to be sorted by popularity for each month using pivot tables anf the likes. The thing here is that some users make the same request multiple times entering in different names. Therefore a formula must be applied to sorting whereby any request made from the same IP for the same artist/song is only counted "once per month".
P3. Existing database and songs need to be verified against the web to add in their appropriate date of recording / release.
this job will likely become a monthly task for the appropriate applicant as requests come in monthly. As the database is updated thee task each month should become considerably less.
We require someone who is highly proficient in English and communications as well as highly skilled in excel, pivot tables, web scraping and data management.
Please do not apply to learn on the job
53 freelancers are bidding on average $163 for this job
i have good skills of Excel sheet i can handle huge amount of excel sheet and can delete , sort , arrange and sort easily waiting for your response thank you
I am an expert in Excel and VBA having more than 10 years of experience. Please consider me for the job. Pay me if you are satisfied with the work. Looking forward to hear from you soon