Optimisation for Resource Allocation
Hello!
I’m currently trying to process data in Excel, and looking at how I might optimise my distribution of resources.
Effectively, I have a number of students who have provided up to 3 preferences for a staff member to talk to for guidance, and I’m looking if there’s a way to optimise my spread for the most equal distribution of students per staff member.
Some staff members have been requested more than others, which is unavoidably going to lead to them having larger loads, but trying to distribute as evenly as possible. Is there a solution I’m not thinking of right now? I have the ability to process this data in either 365 or the desktop app.
Hello!I’m currently trying to process data in Excel, and looking at how I might optimise my distribution of resources.Effectively, I have a number of students who have provided up to 3 preferences for a staff member to talk to for guidance, and I’m looking if there’s a way to optimise my spread for the most equal distribution of students per staff member. Some staff members have been requested more than others, which is unavoidably going to lead to them having larger loads, but trying to distribute as evenly as possible. Is there a solution I’m not thinking of right now? I have the ability to process this data in either 365 or the desktop app. Read More