Completed

Dance Card Spreadsheet

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

Skills: Data Entry, Data Mining, Data Processing, Excel, Visual Basic

See more: dance card excel spreadsheet, business card template spreadsheet excel, excel credit card spreadsheet, bni gains worksheet, bni one to one template, bni worksheets, bni 1-2-1 planner, bni 121 dance card, bni 1-2-1 form, bni 121 template, bni one to one planner, data entry, data processing, sql, excel, visual basic, data mining, database programming, microsoft access, business analysis

About the Employer:
( 1 review ) Paige, United States

Project ID: #16264418

Awarded to:

jasalaz100

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 More

$133 USD in 3 days
(21 Reviews)
4.7

10 freelancers are bidding on average $147 for this job

$155 USD in 3 days
(36 Reviews)
5.5
katiewells3

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 More

$222 USD in 5 days
(22 Reviews)
4.8
nadiaislam1987

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 in More

$100 USD in 3 days
(17 Reviews)
4.4
SeniorWebDev1

Hi, dear! I am a data Entry & excel expert I already read your proposal and understood your idea. I can do it effectively and perfectly. I'd like to work with you. I'm interested in your project. Please send More

$155 USD in 3 days
(5 Reviews)
3.8
Meagan26

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 developm More

$177 USD in 3 days
(7 Reviews)
3.2
kujin2018

hello, nice to see you. As a pro in the field of data entry, data mining, excel, and visual basic, i can help you a lot.

$66 USD in 3 days
(1 Review)
2.9
pkbonly

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

$155 USD in 3 days
(1 Review)
0.0
arajan95

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 talen More

$155 USD in 2 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0