I need an excel spreadsheet that can make dance cards automatically
The input will be First Name, Last Name, Age, Sex, Height, Skill, User Defined 1, User Defined 2, User Defined 3
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 espcially 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 forumla should take this into conidertaion 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.
Other considerations would be the ability to turn on or off field qualifiers. Skill and the three uder defined fields should have the option to be included in pairings if desired (but not by default utilized) This would allow for greater dynamic in the assignment of dance partners. THe User Defined fields however may be used for other identifying reasons so may not be used for assigning, hence the need for being able to toggle its use for pairing.
The Height field should also be able to be turned on or off when pairing. Often times a 5 foot young lady would find it difficult or even uncomfortable to dance with a 6'2" boy, and vise versa. Using a 3 inch height difference as the ideal (Male being 3 inches taller than the female) and working out from there would be ideal not exceeding equal height on the bottom of the scale or 6 inches taller on the top of the scale.
All the time whichever paramter or combination of parameters is turned on, these are not determinates to disclude a dancer. Things to consider. If uneven number of particpants exist the grouping with the fewr 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. Without this option, ranking of importance for consideration of parameters should be used (this should also be user definable) Does age trump height which trumps User Define field 2.
The last consideration would be for "arranged dances" and "prohibited dances". There may be a need to manually "arrange" a dance. Each individual should have the ability to have other participants be "arranged" to dance with. In other words if Male #2 must dance with Female #17, Female 23, and Female 42. These would be taken in to consideration prior to and over all other parameters. On the reverse side of things Male #3 and Female #7 are borther and sister and do not or will not dance together. This should be set as a prohibited dance partner and regardless of parameters will not be paired together. Both records do not need to reflect the arranged or prohibited setting. As long as one has it the other automatically receives it as well.
If arranged dance partner selections exceed the number of dances shceduled then the other parameters should be used to rank priority.
Finally, a worksheet should be generated with the Male Matrix one for the female Matrix.
8 freelancers are bidding on average $133 for this job
Good afternoon- I'm an Excel guru with years of experience designing tools. It sounds like an optimization model. 'd be happy to talk with you in more detail about what I can do for you!