How do you organize what actors get what mics

I’m in charge for the first time of our school play and I need to figure out what characters will be getting what mics for each scene. I’m curious about how other people do it case right now I’m using a spreadsheet.