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?