Seat allocation with Date & Time

I have a project of scheduling candidates across three cities where I have to assign candidates a particular date and time as per their preferred choice of city.

Assumption:
I have with me two sets of data:

1) Detail of test centers where a single city can have multiple LABS (Centre Code). For eg. in Barcelona city there are 9 labs; LAB1 can accommodate maximum 11 candidates in a particular date and time, 11 candidates on 2nd jan 10:00. I will be having this data as a matrix as shown in the attached file (Capacity Matrix).

2) Candidate information will be available as a single list as shown in the attached file(List-1)

Aim:
The aim is to assign a particular candidate(identified here with unique application id) a specific date and time in his/her first preferred city at a particular Centre Code.

Also, I want to limit giving schedule in a particular city to ONLY 80% of its capacity; for eg Boston can have maximum 81 candidates; so I need to stop giving schedule to candidates in Boston once the "number of candidates scheduled reaches 81*0.80=64.8~65; after 65 candidates have been given Boston, stop and move on to the next city and the same process is followed.

Output:
The result should be populated as shown in "candidate schedule" of the attached file.

small change in the attachment.

Can anybody help?

It would be nice if someone looks into the above scenario that I have with me and responds.

Hi Holger,

I posted this in another forum because I was not getting any response to my query... so that's the only reason I cross-posted it.
My sincere apologies for not providing the link to the cross-post.

Jay

Can anybody help?