Dance Card Matrix Maker


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.

Skills: Excel

See more: name card maker, dance card excel spreadsheet, tcw, find the words maker, find maker, find a maker, difference between these and those, make a name card, matrix, find matching words, dancer, create excel worksheet, create name card, male dynamic, older male, assignment kids, girls boys need sex, excel name card, card excel spreadsheet, matching excel, excel criteria matrix, boys sex, sex male, sex need boys, girls number girls number

Project ID: #4657868

Awarded to:


Excel is my middle name

$136 USD in 7 days
(2 Reviews)

8 freelancers are bidding on average $133 for this job


Hello, I can help you.

$147 USD in 3 days
(10 Reviews)

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!

$150 USD in 3 days
(1 Review)

Let me handle this for you!!

$105 USD in 3 days
(5 Reviews)

I got it. Can do easily hire me.

$155 USD in 3 days
(0 Reviews)

Hi, I can do this job in a professional manner. I can assure you to provide 100% accurate work. Please contact with me through private message. Thanks.

$103 USD in 3 days
(0 Reviews)

I can do this, :)) Let me do it for you.

$155 USD in 3 days
(0 Reviews)

Im guru in Excel

$100 USD in 5 days
(0 Reviews)

i can help you when do you want it?

$155 USD in 3 days
(0 Reviews)

@@ I believe my skills would be ideal for your project. @@

$111 USD in 3 days
(1 Review)