simple data-based program to match singers at music centres
$240-2000 HKD
Suljettu
Julkaistu noin 6 vuotta sitten
$240-2000 HKD
Maksettu toimituksen yhteydessä
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.
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 carefully and I am sure that I can do the project.
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 singers and determine the pairing of singers with songs as per your instructions.
I will work with you to ensure that you are happy with the solution provided.
Obviously I will transfer all Intellectual Property rights to the VBA code upon full payment. Below are the milestones that I would request:
1. $200HKD upon providing a demonstration list of singers/songs. This list will be produced by the VBA code.
2. $600HKD upon client agreement with the layout and formatting (after reviews as necessary) of the list provided.
3. $1000HKD upon provision of Excel Workbook with VBA code included.
What I need to know:
1. What version of Excel will be used?
2. What O/S will be used?
What you need to provide:
1. Indicative list of Singers
2. Indicative singers’ song list
3. Indicative list of locations
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 pleased to inform that we have Expert team in organizing information, prioritizing tasks, and document management. Moreover,
we excel at:
Managing data entry and customer support for busy website.
Developing improved systems for data entry and filing.
Updating paper-based systems and converting them to computer-based processes.
Gathering, analyzing, and reporting on detailed statistical information.
In addition to my experience and personal qualities, we have a passion for accurate data entry.
we are a self-starter and excel at verifying information, analyzing errors, and managing confidential information. we are also deeply familiar with MS Excel MS OFFICE ,Quick Books Accounting Systems ,Data Scrapping , Excellent computer skills ,Excellent written and verbal communication , and adapt quickly to new programs.
I will follow up to request an schedule a call to discuss how my experience and background meets your needs.
I look forwards to hearing form you soon.
Thank you for your time and consideration.
Sincerely,
Neelu
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 assistance…
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 do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
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.
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 experience is vast. You can have a look at my portfolio. It would be my honor to work for you. I am awaited for your sincere response.
Regards: Inzamam
Hello,
I am a fresh and new freelancer also can be done perfectly as per your need. Please provide me more details in PM for doing some sample work before hiring.
Thanks for your time,
Abrar Bin Fazal
I believe I could do the work very nicely.
I believe it's not that much complicated but not so easy. I can make it smoothly.
Relevant Skills and Experience
I have been working with my local people. Have done great so far.. .
I am a self-motivated person who is willing to go above and beyond on any project, and to learn valuable skills on my own time.. I know you are looking for a self-motivated computer technician with both skills and passion, and I know this is a work style in which I excel.