LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 113
Default Random generation of employee assignments

We have 65 work assignments and must randomly re-assign them to our
employees each month. We have given each work assignment a number 1-65.
How do we randomly re-shuffle a list of 45 whole numbers at the beginning of
each month?

Once we have learned how to perform the random re-shuffle above, we would
also like to learn how to tailor the random assignments as follows:

First, how do we prevent an employee from being re-assigned the same
assignment they performed last month or perhaps the last 3 months?

Second, how do we prevent employees from receiving certain random numbers
that represent tasks they are not capable of performing? In other words,
how do we prohibit an employee from being assigned a subset of certain tasks
(task numbers) included in the comprehensive list of tasks?

Thank you for any help with this question.

 
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
Random generation of employee assignments Blue Max New Users to Excel 4 October 6th 09 03:43 PM
random letter generation Ann Excel Worksheet Functions 5 May 30th 08 06:52 PM
random assignments of workload to set # of people Dawn Bjork Buzbee Excel Worksheet Functions 3 February 21st 07 03:17 PM
Random List Generation carl Excel Worksheet Functions 4 May 23rd 06 02:18 PM
Random Name Generation pkbro Excel Worksheet Functions 1 June 21st 05 02:03 AM


All times are GMT +1. The time now is 06:35 PM.

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"