October 4, 200520 yr I have a table of job candidates, which will need to be assigned to committees for review. There are 6 committees. In general, the assignments can be completely arbitrary. candidate 1--committee 1 candidate 2--committee 2 3 - 3 4 - 4 5 - 5 6 - 6 7 - 1 8 - 2 9 - 3 . . . etc. That would be easy enough I guess.. but, here's the monkey wrench. My boss will need to predesignate some of the candidates in one way or another. He may say, designate candidate 23 to committee 4 or he may say, do NOT give candidate 24 to committee 5 So, I'd like a way to allow for these manual per-candidate rules to be allowed for, WHILE at the same time, in the end, having distributed an equal (or as close as possible to equal) # of candidates to each committee. so far, I have the following tables: CANDIDATE COMMITTEE COMMITTEE_ASSIGNMENT I'm thinking that it is easy enough to manually assign committee assignments for instances where my boss tells me: designate candidate 23 to committee 4 or do NOT give candidate 24 to committee 5 BUT.. how do I make is so that the arbitrary assignments, which are scripted, should compare all the assignments to the 6 committees so that it keeps them all at an even level ? I'm lost about how to approach this. Could anyone offer any advice ? thanks ;)
Create an account or sign in to comment