TEAM EVALUATION
Budget: €8 – €30 EUR
1. Have a list of users in TAB F1, they have a ID number(column A) and a Category in CAT (column B).
2. Have a list of users in TAB C1 that will evaluate the users in TAB F1 (this users can belong also to TAB F1 list)
3. to make assignment from users C1 to F1 i have conditions:
1. Users from TAB C1 need to be chosen Random
2. When assigned, the CAT of user from list C1 must be different from user on the list F1.
3. each user of C1 list, randomly assigned, can only have a max of 2 (need this value be a variable, i can put 3, 4 users, the original database will have lists of 300 users to be assigned, see column E (F1 per C1).
examples in excel:
Line 3: user ID 72 with CAT TTA, user 14 was assigned with CAT PLMJ-----(is ok), and user 14 only have 2 ----- (is ok)
Line 4: user ID 78 with CAT RL, user 10 was assigned with CAT RL -------(not ok) and user 10 only have 2 ------(is ok)
The goal is all like Line 3, differ CAT and maximum of X per user in C1 list
if using VBA, add a buton to initiate the process, a cel to describe how many maximum user per user in F1.
2. Have a list of users in TAB C1 that will evaluate the users in TAB F1 (this users can belong also to TAB F1 list)
3. to make assignment from users C1 to F1 i have conditions:
1. Users from TAB C1 need to be chosen Random
2. When assigned, the CAT of user from list C1 must be different from user on the list F1.
3. each user of C1 list, randomly assigned, can only have a max of 2 (need this value be a variable, i can put 3, 4 users, the original database will have lists of 300 users to be assigned, see column E (F1 per C1).
examples in excel:
Line 3: user ID 72 with CAT TTA, user 14 was assigned with CAT PLMJ-----(is ok), and user 14 only have 2 ----- (is ok)
Line 4: user ID 78 with CAT RL, user 10 was assigned with CAT RL -------(not ok) and user 10 only have 2 ------(is ok)
The goal is all like Line 3, differ CAT and maximum of X per user in C1 list
if using VBA, add a buton to initiate the process, a cel to describe how many maximum user per user in F1.