Assigned job tickets to multiple people automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-2990866%22%20slang%3D%22en-US%22%3EAssigned%20job%20tickets%20to%20multiple%20people%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2990866%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20main%20excel%20spreadsheet%20everyday%20for%20job%20tickets%20that%20operation%20teams%20completed%20on%20yesterday.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%205%20members%20who%20are%20auditing%20the%20jobs%20tickets%2C%20they%20working%20on%205%20separate%20excel%20files.%20Every%20morning%2C%20I%20have%20to%20check%20their%20schedule%20and%20allocate%20right%20amount%20of%20ticket%20to%20their%20worksheet%20and%20put%20the%20rest%20in%20'Overflow'%20worksheet.%20I%20am%20wondering%20instead%20of%20copy%2Fpaste%20the%20main%20excel%20to%20individual.%20Is%20there%20a%20better%20way%20to%20do%20it%3F%20What%20the%20function%20can%20make%20it%20work%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20put%20a%20number%20against%20each%20name%2C%20then%20the%20numbers%20of%20job%20tickets%20can%20automatically%20add%20in%20each%20excel%20file.%20(all%20files%20save%20on%20share%20point)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2990866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2991191%22%20slang%3D%22en-US%22%3ERe%3A%20Assigned%20job%20tickets%20to%20multiple%20people%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2991191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1225560%22%20target%3D%22_blank%22%3E%40CindyCHU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efirst%20what%20are%20the%20categories%20of%20job%20tickets%2C%20next%20based%20on%20previous%20historical%20information%20how%20long%20does%20each%20person%20spend%20to%20get%20the%20particular%20job%20ticket%20category%20take%2C%20next%20who's%20good%20at%20which%20category%2C%20gathering%20all%20these%20information%20you%20can%20use%20in%20your%20formula%20logic%20to%20forecast%20which%20category%20job%20ticket%20to%20assign.%26nbsp%3B%20In%20other%20words%20you%20rank%20each%20person%20on%20each%20job%20ticket%20category%20so%20you'll%20know%20which%20preferred%20job%20ticket%20you%20want%20to%20assign%20to%20each%20person%20based%20on%20their%20rank%20on%20how%20fast%20they%20can%20work%20on%20whichever%20category%20they're%20good%20at.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a main excel spreadsheet everyday for job tickets that operation teams completed on yesterday. 

I have 5 members who are auditing the jobs tickets, they working on 5 separate excel files. Every morning, I have to check their schedule and allocate right amount of ticket to their worksheet and put the rest in 'Overflow' worksheet. I am wondering instead of copy/paste the main excel to individual. Is there a better way to do it? What the function can make it work?  

 

I want to put a number against each name, then the numbers of job tickets can automatically add in each excel file. (all files save on share point)

 

 

1 Reply

@CindyCHU 

 

first what are the categories of job tickets, next based on previous historical information how long does each person spend to get the particular job ticket category take, next who's good at which category, gathering all these information you can use in your formula logic to forecast which category job ticket to assign.  In other words you rank each person on each job ticket category so you'll know which preferred job ticket you want to assign to each person based on their rank on how fast they can work on whichever category they're good at.