Find Jobs
Hire Freelancers

Dance Card Matrix Maker

$30-250 USD

Complété
Publié il y a presque 11 ans

$30-250 USD

Payé lors de la livraison
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.
N° de projet : 4657868

Concernant le projet

8 propositions
Projet à distance
Actif à il y a 11 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Excel is my middle name
$136 USD en 7 jours
5,0 (2 commentaires)
2,8
2,8
8 freelances proposent en moyenne $133 USD pour ce travail
Avatar de l'utilisateur
Hello, I can help you.
$147 USD en 3 jours
5,0 (10 commentaires)
3,7
3,7
Avatar de l'utilisateur
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 en 3 jours
5,0 (1 commentaire)
2,8
2,8
Avatar de l'utilisateur
Let me handle this for you!!
$105 USD en 3 jours
4,9 (5 commentaires)
2,5
2,5
Avatar de l'utilisateur
i can help you when do you want it?
$155 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
@@ I believe my skills would be ideal for your project. @@
$111 USD en 3 jours
0,0 (1 commentaire)
0,0
0,0
Avatar de l'utilisateur
Im guru in Excel
$100 USD en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I can do this, :)) Let me do it for you.
$155 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I got it. Can do easily hire me.
$155 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Minneapolis, United States
5,0
58
Méthode de paiement vérifiée
Membre depuis nov. 29, 2005

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.