I'm creating an excel sheet to evenly distribute work files to a list of agents automatically.
Each agent starts the day with carry-on files from the day before.
To make matters more complicated, there's 2 types of files, let's call them the blue files and the red files.
So each agents will start the day with red and blues files each as carry-on from the previous day, and a set of new files to be distributed evenly to give them, as much as possible, the same amount of file in total each. (blue and red combined)
Of course, I can't have half files sent to any agent, and rounding up is not an option as my numbers need to add up to the real data.
Any suggestions?
Bookmarks