Automate car park rota?

Hello all,

I work in a building of 1000 people, we have 25 car park spaces.

We only give out spaces to blue badge holders, and sometimes passport holders (someone with a temporary issue) who tend to come in between 3-4 days between Mon-Fri - all different days.

Is there a way to automate this? People who can park fill in a sheet of what days they need and excel takes that info and spits a rota out for us. It’s a long winded process at the moment and seems more effort than it’s worth.

Thanks!