I work for a global company and they use purpose built software to track absences and it wasn’t as sophisticated as your spreadsheet. They only started to put in rules like that after some director of an entire continent got a request to approve a work order for some trivial one-off handyman type job at some office. The dozen or so managers under them were all on PTO at the same time so the request just kept rolling up the chain. That pissed them off and now we have restrictions.