I need an excel spreadsheet that can make dance cards automatically
The input will be First Name, Last Name, Age, Gender
I need the spreadsheet to generate dance partners based on this criteria.
User must enter number of dances to generate. Factors to consider:
Males dance with females and females dance with males.
Age matching should utilize a bottom up methodology. Youngest male dances with the youngest of the females on up. The importance here is that especially for kids, girls do not care to dance with boys younger then them. This may not be possible depending on the entries but in the formula should take this into consideration keeping the age gap between male and female that the male is equal to or older whenever possible. Favoritism should be given to a +1 year or equal age whenever possible for male to female.
All the time whichever parameter or combination of parameters is turned on, these are not determinates to exclude a dancer. Things to consider. If uneven number of participants exist the grouping with the fewer number should have full dance cards, i.e. 45 males and 30 females would mean that all females would have full dance cards while males would have partials by default. However if an over all option to "create ideal pairings" could be incorporated, this would allow for pairings to be completed only for those that matched the selected criteria and were within parameters.
Finally, a worksheet should be generated with the Male Matrix one for the female Matrix.
I am looking to enter names on a spreadsheet. Fields should be: First Name, Last Name, Gender, Age
Once the names are entered, I need to pair up males with females for dances. The selection will be male paired with female, and preference for closeness in age. There will be an uneven amount of males and females, so if there are more females, the females will have to rotate around with all the males and there will be a number of females who are not paired up for a dance depending on the difference in number between male and female. It needs to cycle through so that the selection is random except for age preference and that everyone gets the most dances possible with different people.
For example, there could be 20 males and 30 females. There may also be 15 dances. So, number of dances needs to be a Field as well. All 20 males will always be paired since there are less of them. So, all 20 males will dance 15 dances with different females who are closest in age to them. The 30 females will have to take turns so that only 20 are paired up for a specific dance and 10 have to sit, but then another 20 are paired up for the next dance and a different 10 have to sit. It should cycle through so that all the females get the most dances possible.
Skills Required
Data Entry, Excel
Immediate availability.
Responsible, fast and accurate.
Full-time freelancer.
Excel expert.
100% satisfaction guaranteed. Available to any help after completion.
Experience of 7 years using excel for organizing and analyzing any company variables.
Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$133 USD in 3 days
4.9 (32 reviews)
4.9
4.9
8 freelancers are bidding on average $157 USD for this job
I am a technical business analyst with 15 years of professional experience. I was wondering if you have a license for Access or if this solution has to be delivered in Excel? I think the only way to solve this will be to generate every possible match scenario (within reason so wildly varying age differences could be ruled out) and then determine which most fits the ideal. Access will be far more suited to handling this kind of work (I almost want to suggest installing SQL Server Express to harness it's processing power then building a front end attached to that; however that may be because I just completed a similar project - creating ideal matches for responses to a valentines day survey- and SQL certainly smoothed the entire process) because it is really more a database problem.
I have expert level SQL, Access, Excel and VBA and love to solve puzzles, so it would be great to chat further on this one!
Hi I provide quality services including; Data entry, Excel, Web searching, Web scraping, Craigslist, Lead, Email Marketing, Internet Research etc. If you think I am perfect person for your project, please message me inbox & we can discuss about project.
Thanks
I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development.. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality.
My skill-set includes...
-PHP
-HTML5
-CSS
-AJAX
-Responsive Design
-Joomla
-Wordpress
-Magento
-Drupal
-Photoshop
-Illustrator
-Video Editing
-Data entry
-Iphone
-Android
I look forward to hearing from you and hopefully we will have the opportunity to work together.
Thank you,
Coasif
Hello,
I am very much interested on your project.I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills.
Thanks
In my previous positions I have gained experience in research, analysis, designing high impact Power Point presentations, managing people, performance and much more. Combine all of this experience with my natural talents (writing, aesthetics, analytical problem solving, strategic planning, and research) and with my work ethic you have a well-rounded candidate you will be proud to have on your project.