# simple data-based program to match singers at music centres

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.

Skills: Data Entry, Excel

( 0 reviews ) Hong Kong

Project ID: #16457572

## 31 freelancers are bidding on average \$906 for this job

katilinas

Hello, I'm ready to work on "spreadsheet to match male and female singers" project. Relevant Skills Excel, VBA Milestones 776 HKD - code writing 194 HKD - userfriendly interface I read through the job details care More

\$970 HKD in 2 days
(114 Reviews)
6.4
\$1244 HKD in 3 days
(52 Reviews)
6.1
point2solutions

Dear client As a highly skilled Data Entry .I read your posting for Data Entry task. I would like to express my deep interest in your project With more than 8+ years’ experience as a proficient Data Entry .I ple More

\$1244 HKD in 3 days
(1 Review)
4.2
Sercho56

I will write a VBA Macro that will use a simplified version of an algorithm I wrote for an aviation training organisation to program their training events. The Macro will use all the provided information for the singe More

\$2000 HKD in 7 days
(8 Reviews)
3.7
webanis

Hi , I am interested by your offer. Let me know more details of this work. I will start working immediately :) Br;

\$1244 HKD in 3 days
(16 Reviews)
4.0
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d More

\$1000 HKD in 1 day
(14 Reviews)
3.6
hassanmustafa01

I have an experienced team for Data Entry (MS Excel, PDF to Excel, MS Word), web searching, Internet Marketing, and web scraping. Customer satisfaction is our highest priority. Feel free to message me for any assistanc More

\$265 HKD in 3 days
(31 Reviews)
3.9
mayankinnovative

A proposal has not yet been provided

\$944 HKD in 5 days
(1 Review)
3.0
viswakarmaya

Shall complete the project of matching the singers and center within stipulated time and high quality. I have expertise and experience to complete the projects and i provide additional add ons if required.

\$1244 HKD in 3 days
(2 Reviews)
1.0
inzamamabbaci

Hello, Dear Concern: I am an experienced research writer having 6 years of experience. I am hereby to offer you my services for "data entry” for only "\$20". Moreover, I have joined freelancer recently but my experien More

\$1111 HKD in 3 days
(1 Review)
1.0
nguyenanh78

Do it by using database. - Put singer list in. - Put song list in - put centre list in. ..... show result.

\$666 HKD in 5 days
(3 Reviews)
1.8
wajeeha288

Hello its wajeeha here,im an engineer and jobless from 7 months.i have a good command in office [login to view URL] [login to view URL] you.

\$240 HKD in 1 day
(0 Reviews)
0.0
romamrmr78

work hard accurate work hard accurate work hard accurate work hard accurate work hard accurate work hard accurate

\$1244 HKD in 3 days
(0 Reviews)
0.0
Indi1995

A proposal has not yet been provided

\$888 HKD in 3 days
(0 Reviews)
0.0
priyankara88265

A proposal has not yet been provided

\$340 HKD in 3 days
(0 Reviews)
0.0
amitsaxena1976

I am assuring for qualitative and 100% accurate outcome . Relevant Skills and Experience Have 17 yrs experience in data handling and other management tasks.

\$1088 HKD in 3 days
(0 Reviews)
0.0

I have keen interest in this field. and have a four year experience of writing, you will not be disappoint after hiring me.

\$240 HKD in 7 days
(0 Reviews)
0.0
lazarovicipaul

i like music and i want to work in this project

\$290 HKD in 4 days
(0 Reviews)
0.0