How do I optimaly distibute a number (whole values) into a range

G

Guest

I have a number of staff (say 25) that I want to optimally distibute amongst
14 workstations. Each workstation will have a set percentage of the overall
workload therefor each workstations set workload might range from 1.3% to
14.8% for example. I can have between 0 to 4 people at any station depending
on work load.

How can I OPTIMALLY distribute ALL 25 of my staff (whole numbers only) into
these workstations and steer clear of decimalizing. I cannot place 2.23
workers in a work station
 
G

Guest

Say the 14 machines were represented by 14 columns. Sequentially starti
adding staff to the columns using the following strategy:

Starting with the person generating the greatest load, add the people to the
machine having the least current load. Each of the first 14 people will get
a machine to themselves, the 15th person gets assigned to the machine least
loaded, and so on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I have a cell value define a dynamic named range? 15
How to turn a number range into a date 2
How can I test a range of cells for the presence of a border? 7
How do I round a number after finding the average? 3
How do I use a range of numbers in an if statement? 2
HOW DO I ROUNDUP A RESULT OF A FORMULA TO NEAREST WHOLE NUMBER 3
How do I print 100 copies of a document, each copy with a number? 1
how can i use a whole number after dividing? 3

Top