Having spoken with Korith, I've discovered something his spreadsheet was not designed to do, but he has suggested a workaround.

His spreadsheet is not designed to handle an alpha game, but he has suggested that should an alpha pick someone who already had a role, that role becomes reassigned. It's not the most effective solution, but it works.