LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 113
Default Random sorting with restrictions

We are attempting to perform a random sort (re-ordering) of employee
assignments where a limited number of employees may not be able to perform
certain assignments. We would like some suggestions on how to successfully
perform such a random sort while also assuring that those with restrictions
are not given a restricted assignment. Here is some further information:

FIRST, each employee is assigned to one line of the weekly schedule and that
line might include serveral different assignments during the day. At the
end of the week, the employees are randomly rotated in order to provide them
with a new set of assignments for the next week. The rotation prevents
single-assignment burnout and assures that no one monopolizes the favored
assignments.

SECOND, some employees cannot perform certain assignments. As such, they
cannot be assigned a line on the weekly schedule that contains any
assignment they cannot perform. Obviously, this restricts the possible
lines they can be assigned to, to a subset of the total lines to be staffed.

THIRD, each line can have any combination of about a dozen possible
assignments, but will usually only include 4 or 5 of the possible dozen
assignment types. The schedule provides lines for about 50 employees,
including cells to indicate the restrictions for any given employee (cell
marked for the restricted area).

Somehow, we need to identify lines to which a given employee cannot be
assigned, randomly assign that employee to one of the remaining lines, and
then remove that line from the pool of possible line assignments for
remaining unassigned employees. This approach focuses on assigning
employees to a diminishing pool of line assignments, but you could
alternatively approach the problem by assigning lines to a diminishing pool
of employees.

We would appreciate any thoughts on how to efficiently accomplish this
random rotation so that each employee is assured a fair chance to be
assigned to any of the lines on the schedule for which they qualify.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting random Data created from a random formula Six Sigma Blackbelt Excel Discussion (Misc queries) 1 September 11th 08 11:03 PM
Random sorting of list Kathrine Excel Discussion (Misc queries) 2 March 30th 07 11:12 AM
How to do look up with restrictions JackR Excel Discussion (Misc queries) 3 April 3rd 06 01:12 AM
Non-random numbers generated by excel's data analysis random gener Allie Excel Worksheet Functions 10 September 17th 05 06:19 AM
Non-random numbers generated by excel's data analysis random gener Harlan Grove Excel Discussion (Misc queries) 2 September 13th 05 04:06 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"