simple data-based program to match singers at music centres
$15-25 USD / hour
Lukket
Slået op cirka 6 år siden
$15-25 USD / hour
A simple spreadsheet to match male and female singers at various music centres in an afternoon or evening
Time: For rows A, B, C …, they show the half-hour singing time slots (e.g. 13:00-13:30, 13:30-14:00 ….). For a 3-hour period (from 13:00 to 17:00) , there are 6 time slots, and 6 songs can be sung.
Place: For columns 1,2,3… they show the music centres ([login to view URL] locations}. Let's assume there are 20.
Songs: The total is 120 songs — being sung in the 20 music centres in the 3-hour period.
Singers: For each cell, it shows …
1. the name of the male singer,
2. the name of the female singer
2. the name of the song that they will sing together.
All the data are in Excel or plaintext format, to be fed into the program by an administrator.
When there are 30 such singer pairs (30 males and 30 females), they share the 120 song-singing time slots. Therefore each singer does 4 songs. In each cell (which is sub-divided) the information is: male name, female name, song name.
Each singer has his or her own able-to-sing song list (i.e. about 20-30 or songs that he or she knows). The lists will be in the form of various tables (in Excel or plaintext format).Therefore for the 60 males and 60 females, there will be 120 separate tables (but the songs often overlap, which is why a male singer and female singer can sing together).
This is what the spreadsheet should be able to do:
1. It can at random match the male and female singers. That is, a different male singer vs the same female singer. Or a different female singer vs the same male singer.
2. Find from the song lists (60 tables from the males, 60 tables from the females) those songs that the male and female know in common. Excel can do so by “joining” two tables and show only the common cell entries.
3. Arrange the pair (with a song) into each spreadsheet cell (i.e. the half-an-hour time slot at a certain music centre). The cell is sub-divided into 3 parts: the male, the female, the song. In other words, not only can the administrator change the male-female combination, the administrator can also change the song (provided both singers know the song).
4. Arrange a maximum of 3 different music centres for each singer to go to (otherwise the singer would have to hurry going from one centre to another).
5. The information in a cell (male, female, song) can be “grouped” — so that in the last minute the administrator can manually swap the singing slots if necessary.
In the spreadsheet, the administrator just has to enter the names of all male singers and all female singers. The singers' own song lists are also provided. Then the matching should be AUTOMATIC. The program decides for the singers WHAT song to sing, WHERE to and WHEN to. The administrator can re-run the program for alternative combinations.
Dear Sir,
I have gone through your project details and understand that you need data-based program to match singers at music centres.
I have 5 years of experience in Data Entry, Excel
I will make spreadsheet to match male and female singers at various music centres in an afternoon or evening
Kindly ping me to discuss further details.
Hello, I'm Smile Song, developer in China.
I'm interesting your project very well
I'm a Good SQL, C++, c#, Python, .Net, swift, object-c, OpenCV, Math, Java, Algorithm expert.
I m quite well experienced in these jobs.
Let's go ahead with me
I want to service for you continously.
Thanks
Hey,
I have gone through the details of this project. Can you please show me the excel file so that i can tell you how much time is it gonna take.
Thanks
Sajid Khan
Hi]
I am a data entry expert and very well in vba code to handle your project requirements to match and make sure is working as you want
you projects require macros to make it work perfectly and I am the person to do that
hope we will discuss further
Thanks in advance
Hello, I am interested in your offer and I am ready to cooperate.
I have experience in writing macros VBA for Excel.
I can write a program to perform this task and generate this table.
I am a Data entry worker basically and I have good working record previously on this site,and I will do my best to fulfill your requirements.I will try to complete this project as soon as possible.
Thanks
Hi Everyone,
I'm available now and can start the job immediately after hire. I am willing to learn any kind of work, coz I believe that any kind of job can be learn and teach, if there's a proper training and instruction.
I'm reliable, detail oriented, and self-motivated. I take every job seriously and Passionately
I am always determined to deliver projects to upwork clients before meeting the dead line with 110% satisfaction & loyalty.
Thank you for your time and I’m looking forward for you great response.
Your parntner you're looking for,
Francis Velez
I'm professional freelancer, expertise in Graphic Design, Word processing, data entry. Good at web design, SEO, HTML-5, CSS, Bootstrap.
I have long time practical experience in Microsoft Office - "Youth Development Department as a Instructor Under Youth and Sports Ministry, The Republic of Bangladesh".
I'm very interested for freelancing with freelancer.com
I am interested in your project. I have done similar project before and would be able to do you project in a well organized manner. I am willing to give you extended support for a time span of 6 months where in minor changes can be done.