Advancing INDEX RANK RAND to match a skill

[MrWoods1990]

Good evening All!

PROBLEM 1

I have created a staff floor plan that randomly fills all work areas from an INDEX of staff names, utilising RANK and RAND to randomly place 58 names across 58 positions and change every time I recalculate.

This works exactly as I want it to, however, some staff in the Matrix have the skill "B" accredited to them in a separate column and some positions in the floor plan have skill "B" in certain areas.

In the attached example I would like only staff with the skill "B" to randomise in the unshaded areas of 5 and 10 and all other staff to continue to rotate through the other positions

PROBLEM 2

Some staff have more than one Skill IE "B" and "I"

In positions 1-4 of Area 1 I would like it to populate firstly with staff who have the skill "I" but not "B" but then "I" and "B"

PROBLEM 3

To make matters more complicated, some staff have the skills "B", "I" and "C"

Area 6, 7, 9 and 13 should prioritise staff only with "C" and not other skills.

PROBLEM 4

Staff with no skills should then randomly populate all other positions.


The only solution I can see is making separate lists based on skills but I would like to keep to one list as I would then have to choose the staff who go in which list, rather than basing the selection totally randomly.

[MarvinP]

Hi MrWoods,

I think I'd try to reduce the Skills letters to a single column. You will need to duplicate the names to do this. That would mean name of "Name1 Name12" would have two separate rows in your Matrix table. One for skill B and a second for skill C.

You could then randomize your names and filter using Not B but C (or other filters) to fill in your schedule. You could use a rank or counter after the names are randomized to fill in the schedule.


I hope that makes sense.