CREATE COMPREHENSIVE EXCEL FROM AUDIO FILE METADATA

Closed

Background:

Our Music Library is in the process of uploading our entire collection of audio files to an Online Music Delivery System called SourceAudio. Currently all of our Master Audio Files are on their site with all of the correct metadata. In addition to the Master Audio Files, we have alternate versions of those files - Stems (Alternate mixes of the original Master Audio File but still the same length as the original) and Cutdowns (60, 30, and 15 second versions of the Master Audio File). The next step is to upload all of the Stem Files and Cutdown Files so that they will "nest" themselves into their corresponding "parent" Master Audio File.

Goal:

We are looking to create a comprehensive Master Excel Sheet that accounts for all of our Master Audio Files along with their corresponding Stem Files and Cutdown Files. This Master Excel will primarily be used to upload and assign metadata to the remaining audio files (Stems and Cutdowns) once they have been uploaded to the SourceAudio site.

Important Details:

RAW DATA EXAMPLE - This is the data we have available to us in its current form. To help give a bit more insight into the project we've added 3 sheets (MASTER FILES, STEM FILENAMES, CUTDOWN FILENAMES) that contain the entire batch of RAW DATA to be used in creating our final excel. We have roughly 4,200 Master Audio Files, 12,000 Stem Files, and while Cutdown File creation is still a work in progress, we are probably looking at 7,000-8,000 Cutdown Files. Add it all up and we are looking at a Master Excel with roughly 25,000 rows.

RESULT EXAMPLE - This is exactly how the Excel would need to appear (Color formatting is NOT necessary for the final Master Excel). We've started with the metadata from the 2 Master Audio Files listed, added in the pertinent data from the CUTDOWN and STEM FILE DATA, copied what needed to be copied, and entered in everything else.

NESTING WITH MASTER ID - The algorithm analyzing this metadata will take it's cue for how to "nest" related files into it's parent file by looking at the Master ID column. If a group of Stems and Cutdowns are to be "nested" into the Master File, those related files will need the parent file's SourceAudio ID pasted into their Master ID column. In other words the Master ID column will point to the file to be nested under.

YELLOW - Means this metadata just needs to be copied down from the Master Audio File.

RED - This would need to be left blank

GREEN - This metadata needs to be created. Notice the Title is a stripped down version of the Filename. It is required they be in this format. Also, when the Filenames have a (-1, -2, or -3) they are the same audio file but have been categorized in different Genres and therefore needed unique Filenames and metadata to fit SourceAudio's scheme. Stem Filename's are copied from above. Cutdown Filename's have to be created. Master ID comes from the parent file's SourceAudio ID. As mentioned before, Length for the Master Audio File and the Stems is the same. The Cutdown lengths are self explanatory. 60 is 1:00, 30 is 0:30, and 15 is 0:15. Cue ID is our own internal ID. SA4544 is actually the first ID in line. When this Excel is made the first newly created audio file row will get this first ID and then it will increment downward. The Master Audio Files need to keep their currently listed Cue ID. File Type just needs to be filled in with STEM or CUTDOWN depending on the type of file.

Skills: Data Entry, Data Processing, Excel

See more: comprehensive excel file, what comes under data entry, what algorithm means, stem system, online help with excel, online help for excel, how to create data entry form in excel, how to create an algorithm, how to create a data entry form in excel, how to create a data entry form, give an example of an algorithm, excel help needed, data entry process available, creating algorithm, creating a data entry form in excel, create excel form for data entry, create data entry form in excel, create 8 bit music, comprehensive online data entry, batch processing of excel data, algorithm creation, still in progress, online with audio, online audio, master audio

Project ID: #4969133

11 freelancers are bidding on average $11/hour for this job

diamond247

Hello Sir, We are a big set up company with excellent skilled operator who have a lot of experience in this segment, our employee complete more than 300 similar job, i have gone through your project specification, i More

$8 USD / hour
(90 Reviews)
6.6
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly looking forward to work for you.

$14 USD / hour
(134 Reviews)
6.3
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Looking for further discussions in this regard. I strongly believe in dedication, commitment and accuracy. Waiting to More

$12 USD / hour
(65 Reviews)
5.8
vsolcorp

Hello sgtpeppas, We are professional & skilled team with experienced in this track. I would very much like to work with you on this project and request that you contact me through www.freelancer.com to discuss specific More

$8 USD / hour
(45 Reviews)
5.7
qualifiedcoders

hi hope you are doing fine. We have read your requirements and have 10 Data entry experts in our company who have very good typing speed and accuracy. They have Very good knowledge of excel and other microsoft of More

$15 USD / hour
(1 Review)
4.5
abhius

Hello Sir :) Dedicated and Professional here committed to deadlines and 100% accuracy. Quality work is assured. Ready to start.

$8 USD / hour
(18 Reviews)
4.3
afua23

I can get this done for you. I have taken my time to read and understand what you is required to be done and i am sure i have understood what i have to do. I will be able to do exactly what you are asking for. I would More

$16 USD / hour
(18 Reviews)
3.6
chyconsl

HI, I have done similar projects in the past. I will like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that More

$12 USD / hour
(7 Reviews)
3.6
onlineiftikhar

Dear Friend, I am Iftikhar Ahmed from Lahore, Pakistan. I am doing this business for last 3 years. And providing the Admin Field and Internet Marketing services to clients. I have good reviews on Freelancer.com. You More

$8 USD / hour
(5 Reviews)
1.5
praveenchiluka

Hi, I think that i can do your job easily as am a data entry professional and sure that i can submit your work on-time. Thank you

$12 USD / hour
(0 Reviews)
0.0
mazmdm

I'm biostatistician : 5th year of university in agronomy + 5th year of university in statistical methodes. I'm ready to do your sheet. Well-off with manipulations on Excel and Internet, it will be easy for me to create More

$12 USD / hour
(0 Reviews)
0.0