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.
Data Entry, Excel
9 freelancers are bidding on average $156 for this job
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