My apologies now for this may be rather complex.
At work we have a car parking roster which involves 7 reserved spaces and 7 casual spaces.
The 7 reserved spaces are used mainly by the same 7 people (upper management). Unless they are away and then their space is made available to the roster.
Of the 7 casual spaces, 4 senior staff have preferential treatment. Unless they are away and then their space is made available to the roster.
The remaining 3 casual spaces are shared amongst general staff who have requested to be on the roster. At the moment there are 12 general staff on the roster, each with their own unique requirements for parking preferences (ie part timers and full timers).
The roster is allocated over a 2 week period with available bays as fairly allocated amongst all 23 staff as possible. As you can imagine, a bit of a planning nightmare (and it isn't even my job!)
The roster is currently in an excel spreadsheet and uses 3 tables to track availability of car park spaces. And then one table to allocate what is available to the 12 general staff.
I am hoping to get some suggestions as to how we can use formulas, etc, to make this process a little/lot easier. I have a basic understanding of formulas but i am not even sure where to start!
I have attached the spreadsheet. I look forward to hearing from you!