ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I optimaly distibute a number (whole values) into a range (https://www.excelbanter.com/excel-worksheet-functions/82219-how-do-i-optimaly-distibute-number-whole-values-into-range.html)

Kevin O

How do I optimaly distibute a number (whole values) into a range
 
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

Gary''s Student

How do I optimaly distibute a number (whole values) into a range
 
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.
--
Gary's Student


"Kevin O" wrote:

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



All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com