Em Andamento

Excel Data Tidying and Sorting - 45k lines

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

Habilidades: Processamento de dados, Excel, Captura de dados na web

Ver mais: who needs an artist, where to learn programming, website to learn programming, website show sorting in programming, website learn programming, web de develop, sorted data set, scraping data from web database, request an artist, programming macros, programming in excel, learn web scraping, learn to develop website, learn programming website, learn database programming, freehand job, excel data programming, excel add in programming, excel 2016 programming, custom web scraping, custom list in excel, custom excel programming, artist names, match align data excel columns, online sorting data excel

Acerca do Empregador:
( 2 comentários ) Castle Hill, Australia

ID do Projeto: #10500249

Premiar a:

RSwapnil

Hi, I have gone through the project description. I have good hands on data deduplication and cleaning. If could provide some sample records for review that would be great to provide you per entry cost. I think Mais

$277 AUD em 30 dias
(169 Avaliações)
6.5

53 freelancers estão ofertando em média $163 para este trabalho

$200 AUD in 3 dias
(301 Comentários)
7.4
$200 AUD in 2 dias
(241 Comentários)
7.5
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Mais

$200 AUD in 5 dias
(111 Comentários)
6.2
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca Mais

$250 AUD in 5 dias
(65 Comentários)
5.7
BrothersTeam

Hi Good day. I am a data entry team with 4 persons, expert in Product listing on platforms like Magento, Volusion,ebay,Bigcommerce, Wordpress, Shopify, WooCommerce with many years advanced experience. My prices are co Mais

$155 AUD in 3 dias
(50 Comentários)
5.2
sknadeem123

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

$155 AUD in 3 dias
(40 Comentários)
5.3
$222 AUD in 3 dias
(48 Comentários)
5.0
$55 AUD em 1 dia
(44 Comentários)
4.8
datadexterous

Hi there, I'd like to be considered for your data sorting project. I have team of 5 members, expert in web scraping, excel and data management work. If you award us this project, we can complete it in your budget & Mais

$206 AUD in 3 dias
(22 Comentários)
4.0
mallikasomu87

Hi, I read through your requirement. I have 7 years of experience in MS advanced excel data analysis, manipulation, formulation, Pivoting, Dashboard, formatting, power pivots, scenario managers etc. I have done Mais

$100 AUD in 2 dias
(6 Comentários)
3.9
$250 AUD in 7 dias
(3 Comentários)
3.6
lillysoft

Sir i am really interested in your project . sir i am an expert of software and web development. i have already developed many web and windows applications and some are similar to your project . you can check my port Mais

$277 AUD em 1 dia
(3 Comentários)
3.7
jhony1981

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

$35 AUD in 3 dias
(10 Comentários)
3.5
ybautista

Hi, I have extensive experience as an ETL developer, and I know the challenges involved in the cleansing, de-duplication, enrichment, sorting and segmentation of raw data. For this project, I can develop an ETL (Ex Mais

$220 AUD in 2 dias
(3 Comentários)
3.1
Dilipjaipur

Hello, I have ranking in top 6000 on [url removed, login to view] and I hope it will give you an idea about my work quality and dedication to work. You will be safe while working with me. I am able to work on given tasks. I Mais

$177 AUD in 15 dias
(10 Comentários)
3.2
buzitsol

Hi there, Thanks for sharing your requirement Having elevated the performance and profitability of diverse organizations through expert alignment of innovative techniques in web scraping, web search, data mining, da Mais

$111 AUD in 2 dias
(1 Comentário)
2.7
UyangaS

I have three years of working experience in market research area. I know how important the data entry process can be and have experience in carrying out whole survey project from questionnaire development, data entry a Mais

$100 AUD in 3 dias
(3 Comentários)
2.2
$155 AUD in 3 dias
(3 Comentários)
1.8
likamoon

Hi! I'm Irina from Ukraine. I really good in task like this. I always pay great attention for details. Kind regards.

$222 AUD in 9 dias
(0 Comentários)
0.0
datasensenz

I have 15 years experience in database management and data manipulation and cleansing. I always focus on efficiency, usability, and expandability in my work. I am also looking to build my portfolio of work with the go Mais

$155 AUD in 3 dias
(0 Comentários)
0.0