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

K

Kevin O

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

Gary''s Student

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 use VLookup with a range of numbers? 3
How may I lookup and return a value between two numbers 2
countif from whole row as range 10
How do I round a number after finding the average? 3
Find range a value fits to, assign new value based on importance 0
Having Excel calculate the number of times a range of values occur 2
How do I filter a number list by numbers to the right of the decim 2

Top