Back when I was enlisted, my sergeant had a bit of a conundrum. Troops were grumbling about being repeatedly assigned to the same posts, and we didn't have enough time during the shift to scramble the roster while ensuring adequate manning.
I wrote a simple Excel macro which randomly assigned security personnel to posts they held qualifications for. Since it didn't have any knowledge of personality conflicts or preferences of the troops getting assignments, the results generated by the Rosternator 3000 were generally hated by all involved.
In the end the tool was still useful - the mere threat of a randomized roster was enough to get everyone to quit grumbling.
I wrote a simple Excel macro which randomly assigned security personnel to posts they held qualifications for. Since it didn't have any knowledge of personality conflicts or preferences of the troops getting assignments, the results generated by the Rosternator 3000 were generally hated by all involved.
In the end the tool was still useful - the mere threat of a randomized roster was enough to get everyone to quit grumbling.