Question

Ticket allocation

Hi Team, Need help on logic, I am working on ticket allocation system using excel data.

in Assignment_Agnet file will get all info regarding need to assign to new hire or tenured folks (Col A),

in Agent_Info file will get how many new hire and how many tenured folks available.

We will get info regarding how many ticket are there to assign in file Assignment_Agnet(Col A).

I need to distribute equally all ticket to new hire and tenured folks in file Assignment_Agnet (Col ,

Ex: if there are only 2 new hire are available, and new to assign 6 ticket to new hire, then we need to assign 3,3 to each agent.

Please find below algorithm i prepared:

example 1:

Count total tenured folks ticket= 8

Count tenured agent available = 2

equal distribution count= 8/2 = 4

Start loop= 8

loop=4 agnet A

loop=4 agnet B

end

example 2:

Count total tenured folks ticket= 9

Count tenured agent available = 2

equal distribution count= 9/2 = 4.5

Start loop= 9

loop=5 agnet A

loop=4 agnet B

end

Sign up