Thank you for the response. My apologies for not listing the constraint.
9999 is the max allowed assignment, the servicing is performed in a round robin rotation and not serviced by one technician.
Assign the tasks to technicians in a round robin rotation
example:
task 1 is assigned to tech...
Hello,
I enjoyed the below posting and have a similar problem to solve and would appreciate your assistance. I have attached a sample file for review.
"Formula Forensics No. 031 – Production Scheduling using Excel"
I have a list of tasks and a list of technicians
I need to assign the tasks...