Skip to main content

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

Reply


Terms & ConditionsCookie settings