Well not 100% automated, he still has to manually enter in who has left

But after that either a fully automated unseen script, or a KiXform should be quite doable.