Issue Jobs Evenly - a little challenge

I have an idea, but don’t know if it can be done,

I am creating a helpdesk and am at the stage of allocating jobs to technicians.

I would like to ensure that the tasks are spread out evenly between the technicians, for example:

I have 4 Technicians and 100 jobs; I would like the jobs to be allocated 25 each,

As the jobs are cleared that technician’s job list will decline.

In the meantime new jobs may come in I would then want these added to the technicians so that they become evenly spread out again.

Is this as complicated as it sounds…….

A nice little example would be nice please…..

Lets add another dimesion to the complexity, Do you weight the jobs the technicians have to do based on potential complexity? and thus need the weighted job distribution to be even?

S-

hmmmm....yeah that soundds cool....

maybe not so much the complexity but the type of fault.

for axample if it was a network fault Tech 1 may be the specialist, if it was a programming fault tech 2 might be the expert.

although with general faults these could be handed out to who ever has little to do in their job list

So in other words...

Lets hear all the logic you need to distibute the jobs and how the data will be stored

S-

ok so here is my database, i have a combobox on the form to assign the technician, but ideally i would prefer this to be automatically.

i was thinking of displaying thi info on the form if possible, so that the clerk could make sure this function was working

anymore thoughts please anyone???

We really need the logic that you want to use to ditribute the jobs. IT could be something as easy as...

Tech 1 Programming expert 5 jobs in que
Tech 2 Desktop Expert 7 jobs in que
Tech 3 Network Expert 6 jobs in que



5 unqued jobs
#1 programming
#2 network
#3 Desktop
#4 Desktop
#5 Desktop

-When all jobs are assigned all techs should have 7-8 jobs
Determine that tech 1 needs 2-3 jobs to reach max.
Determine that tech 3 needs 1-2 jobs to reach max.
Determine that tech 2 needs 0-1 jobs to reach max.

Job 1 is prgramming assign to tech 1
job 2 is network assign to tech 3
job 3 is desktop assign to tech 2 (reached limit)
job 4 is desktop assign to tech 1 (currently has least amount of jobs assigned
job 5 is randomly assigned to either tech 1,3


S-