Most people think a 25-space lot for 1,000 employees is a math problem. It is not. It is a coordination problem, and the reason it feels like "more effort than it's worth" is that the tool you are using, Excel, was never designed to solve coordination problems. It was designed to store and calculate numbers. When you ask it to manage a rotating, human-driven schedule of blue badge holders and temporary passport holders with varying days, you are asking a ledger to think like a scheduler. It cannot.
The person who posted this question has already done the hardest part: they have identified the real constraint. It is not the number of spaces. It is the manual overhead of collecting preferences, checking eligibility, and resolving conflicts every single week. That is a workflow problem, not a spreadsheet problem. An AI-native tool can ingest the same data, who needs which days, and apply a set of rules that Excel cannot handle gracefully: priority for blue badge holders, fair distribution for temporary needs, and automatic conflict detection. The output is not a static table that someone still has to read and enforce. It is a live rota that updates as people submit their requests, with no human mediating each row.
What this means in practice is that the person currently managing that sheet can stop being a traffic cop and start being a decision-maker. Instead of spending Monday morning reconciling who claimed Tuesday before someone else, they can look at the system's proposed allocation, override it if a genuine exception exists, and move on. The rota becomes a byproduct of the rules, not the work itself. For the 1,000 people who never get a space, nothing changes. For the 25 who do, the process becomes predictable and fair. And for the person running it, the effort drops to near zero.
That is the transformation worth exploring. Not because AI is magical, but because the old way, manual entries, conditional formatting, email chains, was never built for this. The question is not whether automation is possible. It is whether you are ready to stop managing a list and start managing a system.